sales/manage/customer_branches.php

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 $page_security = 'SA_CUSTOMER';
  13 //$page_security = 3;
  14 $path_to_root="../..";
  15 include($path_to_root . "/includes/db_pager.inc");
  16 include($path_to_root . "/includes/session.inc");
  17
  18 page(_("Customer Branches"), @$_REQUEST['popup']);
  19
  20 include($path_to_root . "/includes/ui.inc");
  21
  22 //-----------------------------------------------------------------------------------------------
  23
  24 check_db_has_customers(_("There are no customers defined in the system. Please define a customer to add customer branches."));
  25
  26 check_db_has_sales_people(_("There are no sales people defined in the system. At least one sales person is required before proceeding."));
  27
  28 check_db_has_sales_areas(_("There are no sales areas defined in the system. At least one sales area is required before proceeding."));
  29
  30 check_db_has_shippers(_("There are no shipping companies defined in the system. At least one shipping company is required before proceeding."));
  31
  32 check_db_has_tax_groups(_("There are no tax groups defined in the system. At least one tax group is required before proceeding."));
  33
  34 simple_page_mode(true);
  35 //-----------------------------------------------------------------------------------------------
  36
  37 if (isset($_GET['debtor_no']))
  38 {
  39         $_POST['customer_id'] = strtoupper($_GET['debtor_no']);
  40 }
  41 $_POST['branch_code'] = $selected_id;
  42
  43 if (isset($_GET['SelectedBranch']))
  44 {
  45         $br = get_branch($_GET['SelectedBranch']);
  46         $_POST['customer_id'] = $br['debtor_no'];
  47         $selected_id = $_POST['branch_code'] = $br['branch_code'];
  48         $Mode = 'Edit';
  49 }
  50 //-----------------------------------------------------------------------------------------------
  51
  52 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
  53 {
  54
  55         //initialise no input errors assumed initially before we test
  56         $input_error = 0;
  57
  58         //first off validate inputs sensible
  59
  60         if (strlen($_POST['br_name']) == 0)
  61         {
  62                 $input_error = 1;
  63                 display_error(_("The Branch name cannot be empty."));
  64                 set_focus('br_name');
  65         }
  66
  67         if (strlen($_POST['br_ref']) == 0)
  68         {
  69                 $input_error = 1;
  70                 display_error(_("The Branch short name cannot be empty."));
  71                 set_focus('br_ref');
  72         }
  73
  74         if ($input_error != 1)
  75         {
  76
  77         if ($selected_id != -1)
  78                 {
  79                         /*SelectedBranch could also exist if submit had not been clicked this code would not run in this case cos submit is false of course see the     delete code below*/
  80
  81                         $sql = "UPDATE ".TB_PREF."cust_branch SET br_name = " . db_escape($_POST['br_name']) . ",
  82                                 branch_ref = " . db_escape($_POST['br_ref']) . ",
  83                                 br_address = ".db_escape($_POST['br_address']). ",
  84                 phone=".db_escape($_POST['phone']). ",
  85                 fax=".db_escape($_POST['fax']).",
  86                 contact_name=".db_escape($_POST['contact_name']) . ",
  87                 salesman= ".db_escape($_POST['salesman']) . ",
  88                 area=".db_escape($_POST['area']) . ",
  89                 email=".db_escape($_POST['email']) . ",
  90                 tax_group_id=".db_escape($_POST['tax_group_id']). ",
  91                                 sales_account=".db_escape($_POST['sales_account']) . ",
  92                                 sales_discount_account=".db_escape($_POST['sales_discount_account']) . ",
  93                                 receivables_account=".db_escape($_POST['receivables_account']) . ",
  94                                 payment_discount_account=".db_escape($_POST['payment_discount_account']) . ",
  95                 default_location=".db_escape($_POST['default_location']) . ",
  96                 br_post_address =".db_escape($_POST['br_post_address']) . ",
  97                 disable_trans=".db_escape($_POST['disable_trans']) . ",
  98                                 group_no=".db_escape($_POST['group_no']) . ",
  99                 default_ship_via=".db_escape($_POST['default_ship_via']) . "
 100                 WHERE branch_code =".db_escape($_POST['branch_code']) . "
 101                 AND debtor_no=".db_escape($_POST['customer_id']);
 102
 103                         $note =_('Selected customer branch has been updated');
 104                 }
 105                 else
 106                 {
 107                         /*Selected branch is null cos no item selected on first time round so must be adding a  record must be submitting new entries in the new Customer Branches form */
 108                         $sql = "INSERT INTO ".TB_PREF."cust_branch (debtor_no, br_name, branch_ref, br_address,
 109                                 salesman, phone, fax,
 110                                 contact_name, area, email, tax_group_id, sales_account, receivables_account, payment_discount_account, sales_discount_account, default_location,
 111                                 br_post_address, disable_trans, group_no, default_ship_via)
 112                                 VALUES (".db_escape($_POST['customer_id']). ",".db_escape($_POST['br_name']) . ", "
 113                                         .db_escape($_POST['br_ref']) . ", "
 114                                         .db_escape($_POST['br_address']) . ", ".db_escape($_POST['salesman']) . ", "
 115                                         .db_escape($_POST['phone']) . ", ".db_escape($_POST['fax']) . ","
 116                                         .db_escape($_POST['contact_name']) . ", ".db_escape($_POST['area']) . ","
 117                                         .db_escape($_POST['email']) . ", ".db_escape($_POST['tax_group_id']) . ", "
 118                                         .db_escape($_POST['sales_account']) . ", "
 119                                         .db_escape($_POST['receivables_account']) . ", "
 120                                         .db_escape($_POST['payment_discount_account']) . ", "
 121                                         .db_escape($_POST['sales_discount_account']) . ", "
 122                                         .db_escape($_POST['default_location']) . ", "
 123                                         .db_escape($_POST['br_post_address']) . ","
 124                                         .db_escape($_POST['disable_trans']) . ", "
 125                                         .db_escape($_POST['group_no']) . ", "
 126                                         .db_escape($_POST['default_ship_via']) . ")";
 127
 128                         $note = _('New customer branch has been added');
 129                 }
 130                 //run the sql from either of the above possibilites
 131                 db_query($sql,"The branch record could not be inserted or updated");
 132                 display_notification($note);
 133                 $Mode = 'RESET';
 134                 if (@$_REQUEST['popup']) {
 135                         set_focus("Select".($_POST['branch_code'] == -1
 136                                 ? db_insert_id(): $_POST['branch_code']));
 137                 }
 138         }
 139
 140 }
 141 elseif ($Mode == 'Delete')
 142 {
 143         //the link to delete a selected record was clicked instead of the submit button
 144
 145         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
 146
 147         $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no = '" . $_POST['customer_id']. "'";
 148         $result = db_query($sql,"could not query debtortrans");
 149         $myrow = db_fetch_row($result);
 150         if ($myrow[0] > 0)
 151         {
 152                 display_error(_("Cannot delete this branch because customer transactions have been created to this branch."));
 153
 154         }
 155         else
 156         {
 157                 $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no = '" . $_POST['customer_id']. "'";
 158                 $result = db_query($sql,"could not query sales orders");
 159
 160                 $myrow = db_fetch_row($result);
 161                 if ($myrow[0] > 0)
 162                 {
 163                         display_error(_("Cannot delete this branch because sales orders exist for it. Purge old sales orders first."));
 164                 }
 165                 else
 166                 {
 167                         $sql="DELETE FROM ".TB_PREF."cust_branch WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no='" . $_POST['customer_id']. "'";
 168                         db_query($sql,"could not delete branch");
 169                         display_notification(_('Selected customer branch has been deleted'));
 170                 }
 171         } //end ifs to test if the branch can be deleted
 172         $Mode = 'RESET';
 173 }
 174
 175 if ($Mode == 'RESET' || get_post('_customer_id_update'))
 176 {
 177         $selected_id = -1;
 178         $cust_id = $_POST['customer_id'];
 179         $inact = get_post('show_inactive');
 180         unset($_POST);
 181         $_POST['show_inactive'] = $inact;
 182         $_POST['customer_id'] = $cust_id;
 183         $Ajax->activate('_page_body');
 184 }
 185
 186 function branch_email($row) {
 187         return  '<a href = "mailto:'.$row["email"].'">'.$row["email"].'</a>';
 188 }
 189
 190 function edit_link($row) {
 191         return button("Edit".$row["branch_code"],_("Edit"), '', ICON_EDIT);
 192 }
 193
 194 function del_link($row) {
 195         return button("Delete".$row["branch_code"],_("Delete"), '', ICON_DELETE);
 196 }
 197
 198 function select_link($row) {
 199         return button("Select".$row["branch_code"],_("Select"), '', ICON_ADD, 'selector');
 200 }
 201
 202 start_form();
 203
 204 echo "<center>" . _("Select a customer: ") . "&nbsp;&nbsp;";
 205 customer_list('customer_id', null, false, true);
 206 echo "</center><br>";
 207
 208 $num_branches = db_customer_has_branches($_POST['customer_id']);
 209
 210         $sql = "SELECT "
 211                 ."b.branch_code, "
 212                 ."b.branch_ref, "
 213                 ."b.br_name, "
 214                 ."b.contact_name, "
 215                 ."s.salesman_name, "
 216                 ."a.description, "
 217                 ."b.phone, "
 218                 ."b.fax, "
 219                 ."b.email, "
 220                 ."t.name AS tax_group_name, "
 221                 ."b.inactive
 222                 FROM ".TB_PREF."cust_branch b, "
 223                         .TB_PREF."debtors_master c, "
 224                         .TB_PREF."areas a, "
 225                         .TB_PREF."salesman s, "
 226                         .TB_PREF."tax_groups t
 227                 WHERE b.debtor_no=c.debtor_no
 228                 AND b.tax_group_id=t.id
 229                 AND b.area=a.area_code
 230                 AND b.salesman=s.salesman_code
 231                 AND b.debtor_no = '" . $_POST['customer_id']. "'";
 232
 233         if (!get_post('show_inactive')) $sql .= " AND !b.inactive";
 234 //------------------------------------------------------------------------------------------------
 235 if ($num_branches)
 236 {
 237 $cols = array(
 238         'branch_code' => 'skip',
 239         _("Short Name"),
 240         _("Name"),
 241         _("Contact"),
 242         _("Sales Person"),
 243         _("Area"),
 244         _("Phone No"),
 245         _("Fax No"),
 246         _("E-mail") => 'email',
 247         _("Tax Group"),
 248         _("Inactive") => 'inactive',
 249 //              array('fun'=>'inactive'),
 250                 ' '=> array('insert'=>true, 'fun'=>'select_link'),
 251                 array('insert'=>true, 'fun'=>'edit_link'),
 252                 array('insert'=>true, 'fun'=>'del_link')
 253         );
 254
 255         if (!@$_REQUEST['popup']) {
 256                 $cols[' '] = 'skip';
 257         }
 258
 259 $table =& new_db_pager('branch_tbl', $sql, $cols, 'cust_branch');
 260 $table->set_inactive_ctrl('cust_branch', 'branch_code');
 261
 262 //$table->width = "85%";
 263 display_db_pager($table);
 264 }
 265 else
 266         display_note(_("The selected customer does not have any branches. Please create at least one branch."));
 267
 268 start_outer_table($table_style2, 5);
 269
 270 table_section(1);
 271
 272 $_POST['email'] = "";
 273 if ($selected_id != -1)
 274 {
 275         if ($Mode == 'Edit') {
 276
 277                 //editing an existing branch
 278         $sql = "SELECT * FROM ".TB_PREF."cust_branch
 279                         WHERE branch_code='" . $_POST['branch_code'] . "'
 280                         AND debtor_no='" . $_POST['customer_id'] . "'";
 281                 $result = db_query($sql,"check failed");
 282             $myrow = db_fetch($result);
 283                 set_focus('br_name');
 284         $_POST['branch_code'] = $myrow["branch_code"];
 285             $_POST['br_name']  = $myrow["br_name"];
 286             $_POST['br_ref']  = $myrow["branch_ref"];
 287             $_POST['br_address']  = $myrow["br_address"];
 288             $_POST['br_post_address']  = $myrow["br_post_address"];
 289             $_POST['contact_name'] = $myrow["contact_name"];
 290             $_POST['salesman'] =$myrow["salesman"];
 291             $_POST['area'] =$myrow["area"];
 292             $_POST['phone'] =$myrow["phone"];
 293             $_POST['fax'] =$myrow["fax"];
 294             $_POST['email'] =$myrow["email"];
 295             $_POST['tax_group_id'] = $myrow["tax_group_id"];
 296             $_POST['disable_trans'] = $myrow['disable_trans'];
 297             $_POST['default_location'] = $myrow["default_location"];
 298             $_POST['default_ship_via'] = $myrow['default_ship_via'];
 299             $_POST['sales_account'] = $myrow["sales_account"];
 300             $_POST['sales_discount_account'] = $myrow['sales_discount_account'];
 301             $_POST['receivables_account'] = $myrow['receivables_account'];
 302             $_POST['payment_discount_account'] = $myrow['payment_discount_account'];
 303                 $_POST['group_no']  = $myrow["group_no"];
 304         }
 305 }
 306 elseif ($Mode != 'ADD_ITEM')
 307 { //end of if $SelectedBranch only do the else when a new record is being entered
 308         if(!$num_branches) {
 309                 $sql = "SELECT name, address, email, debtor_ref
 310                         FROM ".TB_PREF."debtors_master WHERE debtor_no = '" . $_POST['customer_id']. "'";
 311                 $result = db_query($sql,"check failed");
 312                 $myrow = db_fetch($result);
 313                 $_POST['br_name'] = $myrow["name"];
 314                 $_POST['br_ref'] = $myrow["debtor_ref"];
 315                 $_POST['contact_name'] = _('Main Branch');
 316                 $_POST['br_address'] = $_POST['br_post_address'] = $myrow["address"];
 317                 $_POST['email'] = $myrow['email'];
 318         }
 319         $_POST['branch_code'] = "";
 320         if (!isset($_POST['sales_account']) || !isset($_POST['sales_discount_account']))
 321         {
 322                 $company_record = get_company_prefs();
 323
 324                 // We use the Item Sales Account as default!
 325             // $_POST['sales_account'] = $company_record["default_sales_act"];
 326             $_POST['sales_account'] = "";
 327             $_POST['sales_discount_account'] = $company_record['default_sales_discount_act'];
 328             $_POST['receivables_account'] = $company_record['debtors_act'];
 329             $_POST['payment_discount_account'] = $company_record['default_prompt_payment_act'];
 330
 331         }
 332
 333 }
 334 hidden('selected_id', $selected_id);
 335 hidden('branch_code');
 336 hidden('popup', @$_REQUEST['popup']);
 337
 338 table_section_title(_("Name and Contact"));
 339
 340 text_row(_("Branch Name:"), 'br_name', null, 35, 40);
 341 text_row(_("Branch Short Name:"), 'br_ref', null, 30, 30);
 342 text_row(_("Contact Person:"), 'contact_name', null, 35, 40);
 343
 344 text_row(_("Phone Number:"), 'phone', null, 20, 20);
 345 text_row(_("Fax Number:"), 'fax', null, 20, 20);
 346
 347 email_row(_("E-mail:"), 'email', null, 35, 55);
 348
 349 table_section_title(_("Sales"));
 350
 351 sales_persons_list_row( _("Sales Person:"), 'salesman', null);
 352
 353 sales_areas_list_row( _("Sales Area:"), 'area', null);
 354
 355 sales_groups_list_row(_("Sales Group:"), 'group_no', null, true);
 356
 357 locations_list_row(_("Default Inventory Location:"), 'default_location', null);
 358
 359 shippers_list_row(_("Default Shipping Company:"), 'default_ship_via', null);
 360
 361 tax_groups_list_row(_("Tax Group:"), 'tax_group_id', null);
 362
 363 yesno_list_row(_("Disable this Branch:"), 'disable_trans', null);
 364
 365 table_section(2);
 366
 367 table_section_title(_("GL Accounts"));
 368
 369 // 2006-06-14. Changed gl_al_accounts_list to have an optional all_option 'Use Item Sales Accounts'
 370 gl_all_accounts_list_row(_("Sales Account:"), 'sales_account', null, false, false, true);
 371
 372 gl_all_accounts_list_row(_("Sales Discount Account:"), 'sales_discount_account');
 373
 374 gl_all_accounts_list_row(_("Accounts Receivable Account:"), 'receivables_account');
 375
 376 gl_all_accounts_list_row(_("Prompt Payment Discount Account:"), 'payment_discount_account');
 377
 378 table_section_title(_("Addresses"));
 379
 380 textarea_row(_("Mailing Address:"), 'br_post_address', null, 35, 5);
 381
 382 textarea_row(_("Billing Address:"), 'br_address', null, 35, 5);
 383
 384 end_outer_table(1);
 385
 386 submit_add_or_update_center($selected_id == -1, '', 'both');
 387
 388 end_form();
 389
 390 end_page();
 391
 392 ?>