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                 phone2=".db_escape($_POST['phone2']). ",
  86                 fax=".db_escape($_POST['fax']).",
  87                 contact_name=".db_escape($_POST['contact_name']) . ",
  88                 salesman= ".db_escape($_POST['salesman']) . ",
  89                 area=".db_escape($_POST['area']) . ",
  90                 email=".db_escape($_POST['email']) . ",
  91                 tax_group_id=".db_escape($_POST['tax_group_id']). ",
  92                                 sales_account=".db_escape($_POST['sales_account']) . ",
  93                                 sales_discount_account=".db_escape($_POST['sales_discount_account']) . ",
  94                                 receivables_account=".db_escape($_POST['receivables_account']) . ",
  95                                 payment_discount_account=".db_escape($_POST['payment_discount_account']) . ",
  96                 default_location=".db_escape($_POST['default_location']) . ",
  97                 br_post_address =".db_escape($_POST['br_post_address']) . ",
  98                 disable_trans=".db_escape($_POST['disable_trans']) . ",
  99                                 group_no=".db_escape($_POST['group_no']) . ",
 100                 default_ship_via=".db_escape($_POST['default_ship_via']) . ",
 101                 notes=".db_escape($_POST['notes']) . "
 102                 WHERE branch_code =".db_escape($_POST['branch_code']) . "
 103                 AND debtor_no=".db_escape($_POST['customer_id']);
 104
 105                         $note =_('Selected customer branch has been updated');
 106                 }
 107                 else
 108                 {
 109                         /*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 */
 110                         $sql = "INSERT INTO ".TB_PREF."cust_branch (debtor_no, br_name, branch_ref, br_address,
 111                                 salesman, phone, phone2, fax,
 112                                 contact_name, area, email, tax_group_id, sales_account, receivables_account, payment_discount_account, sales_discount_account, default_location,
 113                                 br_post_address, disable_trans, group_no, default_ship_via, notes)
 114                                 VALUES (".db_escape($_POST['customer_id']). ",".db_escape($_POST['br_name']) . ", "
 115                                         .db_escape($_POST['br_ref']) . ", "
 116                                         .db_escape($_POST['br_address']) . ", ".db_escape($_POST['salesman']) . ", "
 117                                         .db_escape($_POST['phone']) . ", ".db_escape($_POST['phone2']) . ", "
 118                                         .db_escape($_POST['fax']) . ","
 119                                         .db_escape($_POST['contact_name']) . ", ".db_escape($_POST['area']) . ","
 120                                         .db_escape($_POST['email']) . ", ".db_escape($_POST['tax_group_id']) . ", "
 121                                         .db_escape($_POST['sales_account']) . ", "
 122                                         .db_escape($_POST['receivables_account']) . ", "
 123                                         .db_escape($_POST['payment_discount_account']) . ", "
 124                                         .db_escape($_POST['sales_discount_account']) . ", "
 125                                         .db_escape($_POST['default_location']) . ", "
 126                                         .db_escape($_POST['br_post_address']) . ","
 127                                         .db_escape($_POST['disable_trans']) . ", "
 128                                         .db_escape($_POST['group_no']) . ", "
 129                                         .db_escape($_POST['default_ship_via']). ", "
 130                                         .db_escape($_POST['notes']) . ")";
 131
 132                         $note = _('New customer branch has been added');
 133                 }
 134                 //run the sql from either of the above possibilites
 135                 db_query($sql,"The branch record could not be inserted or updated");
 136                 display_notification($note);
 137                 $Mode = 'RESET';
 138                 if (@$_REQUEST['popup']) {
 139                         set_focus("Select".($_POST['branch_code'] == -1
 140                                 ? db_insert_id(): $_POST['branch_code']));
 141                 }
 142         }
 143
 144 }
 145 elseif ($Mode == 'Delete')
 146 {
 147         //the link to delete a selected record was clicked instead of the submit button
 148
 149         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
 150
 151         $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no = '" . $_POST['customer_id']. "'";
 152         $result = db_query($sql,"could not query debtortrans");
 153         $myrow = db_fetch_row($result);
 154         if ($myrow[0] > 0)
 155         {
 156                 display_error(_("Cannot delete this branch because customer transactions have been created to this branch."));
 157
 158         }
 159         else
 160         {
 161                 $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no = '" . $_POST['customer_id']. "'";
 162                 $result = db_query($sql,"could not query sales orders");
 163
 164                 $myrow = db_fetch_row($result);
 165                 if ($myrow[0] > 0)
 166                 {
 167                         display_error(_("Cannot delete this branch because sales orders exist for it. Purge old sales orders first."));
 168                 }
 169                 else
 170                 {
 171                         $sql="DELETE FROM ".TB_PREF."cust_branch WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no='" . $_POST['customer_id']. "'";
 172                         db_query($sql,"could not delete branch");
 173                         display_notification(_('Selected customer branch has been deleted'));
 174                 }
 175         } //end ifs to test if the branch can be deleted
 176         $Mode = 'RESET';
 177 }
 178
 179 if ($Mode == 'RESET' || get_post('_customer_id_update'))
 180 {
 181         $selected_id = -1;
 182         $cust_id = $_POST['customer_id'];
 183         $inact = get_post('show_inactive');
 184         unset($_POST);
 185         $_POST['show_inactive'] = $inact;
 186         $_POST['customer_id'] = $cust_id;
 187         $Ajax->activate('_page_body');
 188 }
 189
 190 function branch_email($row) {
 191         return  '<a href = "mailto:'.$row["email"].'">'.$row["email"].'</a>';
 192 }
 193
 194 function edit_link($row) {
 195         return button("Edit".$row["branch_code"],_("Edit"), '', ICON_EDIT);
 196 }
 197
 198 function del_link($row) {
 199         return button("Delete".$row["branch_code"],_("Delete"), '', ICON_DELETE);
 200 }
 201
 202 function select_link($row) {
 203         return button("Select".$row["branch_code"],_("Select"), '', ICON_ADD, 'selector');
 204 }
 205
 206 start_form();
 207
 208 echo "<center>" . _("Select a customer: ") . "&nbsp;&nbsp;";
 209 customer_list('customer_id', null, false, true);
 210 echo "</center><br>";
 211
 212 $num_branches = db_customer_has_branches($_POST['customer_id']);
 213
 214         $sql = "SELECT "
 215                 ."b.branch_code, "
 216                 ."b.branch_ref, "
 217                 ."b.br_name, "
 218                 ."b.contact_name, "
 219                 ."s.salesman_name, "
 220                 ."a.description, "
 221                 ."b.phone, "
 222                 ."b.fax, "
 223                 ."b.email, "
 224                 ."t.name AS tax_group_name, "
 225                 ."b.inactive
 226                 FROM ".TB_PREF."cust_branch b, "
 227                         .TB_PREF."debtors_master c, "
 228                         .TB_PREF."areas a, "
 229                         .TB_PREF."salesman s, "
 230                         .TB_PREF."tax_groups t
 231                 WHERE b.debtor_no=c.debtor_no
 232                 AND b.tax_group_id=t.id
 233                 AND b.area=a.area_code
 234                 AND b.salesman=s.salesman_code
 235                 AND b.debtor_no = '" . $_POST['customer_id']. "'";
 236
 237         if (!get_post('show_inactive')) $sql .= " AND !b.inactive";
 238 //------------------------------------------------------------------------------------------------
 239 if ($num_branches)
 240 {
 241 $cols = array(
 242         'branch_code' => 'skip',
 243         _("Short Name"),
 244         _("Name"),
 245         _("Contact"),
 246         _("Sales Person"),
 247         _("Area"),
 248         _("Phone No"),
 249         _("Fax No"),
 250         _("E-mail") => 'email',
 251         _("Tax Group"),
 252         _("Inactive") => 'inactive',
 253 //              array('fun'=>'inactive'),
 254                 ' '=> array('insert'=>true, 'fun'=>'select_link'),
 255                 array('insert'=>true, 'fun'=>'edit_link'),
 256                 array('insert'=>true, 'fun'=>'del_link')
 257         );
 258
 259         if (!@$_REQUEST['popup']) {
 260                 $cols[' '] = 'skip';
 261         }
 262
 263 $table =& new_db_pager('branch_tbl', $sql, $cols, 'cust_branch');
 264 $table->set_inactive_ctrl('cust_branch', 'branch_code');
 265
 266 //$table->width = "85%";
 267 display_db_pager($table);
 268 }
 269 else
 270         display_note(_("The selected customer does not have any branches. Please create at least one branch."));
 271
 272 start_outer_table($table_style2, 5);
 273
 274 table_section(1);
 275
 276 $_POST['email'] = "";
 277 if ($selected_id != -1)
 278 {
 279         if ($Mode == 'Edit') {
 280
 281                 //editing an existing branch
 282         $sql = "SELECT * FROM ".TB_PREF."cust_branch
 283                         WHERE branch_code='" . $_POST['branch_code'] . "'
 284                         AND debtor_no='" . $_POST['customer_id'] . "'";
 285                 $result = db_query($sql,"check failed");
 286             $myrow = db_fetch($result);
 287                 set_focus('br_name');
 288         $_POST['branch_code'] = $myrow["branch_code"];
 289             $_POST['br_name']  = $myrow["br_name"];
 290             $_POST['br_ref']  = $myrow["branch_ref"];
 291             $_POST['br_address']  = $myrow["br_address"];
 292             $_POST['br_post_address']  = $myrow["br_post_address"];
 293             $_POST['contact_name'] = $myrow["contact_name"];
 294             $_POST['salesman'] =$myrow["salesman"];
 295             $_POST['area'] =$myrow["area"];
 296             $_POST['phone'] =$myrow["phone"];
 297             $_POST['phone2'] =$myrow["phone2"];
 298             $_POST['fax'] =$myrow["fax"];
 299             $_POST['email'] =$myrow["email"];
 300             $_POST['tax_group_id'] = $myrow["tax_group_id"];
 301             $_POST['disable_trans'] = $myrow['disable_trans'];
 302             $_POST['default_location'] = $myrow["default_location"];
 303             $_POST['default_ship_via'] = $myrow['default_ship_via'];
 304             $_POST['sales_account'] = $myrow["sales_account"];
 305             $_POST['sales_discount_account'] = $myrow['sales_discount_account'];
 306             $_POST['receivables_account'] = $myrow['receivables_account'];
 307             $_POST['payment_discount_account'] = $myrow['payment_discount_account'];
 308                 $_POST['group_no']  = $myrow["group_no"];
 309                 $_POST['notes']  = $myrow["notes"];
 310
 311         }
 312 }
 313 elseif ($Mode != 'ADD_ITEM')
 314 { //end of if $SelectedBranch only do the else when a new record is being entered
 315         if(!$num_branches) {
 316                 $sql = "SELECT name, address, email, debtor_ref
 317                         FROM ".TB_PREF."debtors_master WHERE debtor_no = '" . $_POST['customer_id']. "'";
 318                 $result = db_query($sql,"check failed");
 319                 $myrow = db_fetch($result);
 320                 $_POST['br_name'] = $myrow["name"];
 321                 $_POST['br_ref'] = $myrow["debtor_ref"];
 322                 $_POST['contact_name'] = _('Main Branch');
 323                 $_POST['br_address'] = $_POST['br_post_address'] = $myrow["address"];
 324                 $_POST['email'] = $myrow['email'];
 325         }
 326         $_POST['branch_code'] = "";
 327         if (!isset($_POST['sales_account']) || !isset($_POST['sales_discount_account']))
 328         {
 329                 $company_record = get_company_prefs();
 330
 331                 // We use the Item Sales Account as default!
 332             // $_POST['sales_account'] = $company_record["default_sales_act"];
 333             $_POST['sales_account'] = $_POST['notes']  = '';
 334             $_POST['sales_discount_account'] = $company_record['default_sales_discount_act'];
 335             $_POST['receivables_account'] = $company_record['debtors_act'];
 336             $_POST['payment_discount_account'] = $company_record['default_prompt_payment_act'];
 337
 338         }
 339
 340 }
 341 hidden('selected_id', $selected_id);
 342 hidden('branch_code');
 343 hidden('popup', @$_REQUEST['popup']);
 344
 345 table_section_title(_("Name and Contact"));
 346
 347 text_row(_("Branch Name:"), 'br_name', null, 35, 40);
 348 text_row(_("Branch Short Name:"), 'br_ref', null, 30, 30);
 349 text_row(_("Contact Person:"), 'contact_name', null, 35, 40);
 350
 351 text_row(_("Phone Number:"), 'phone', null, 32, 30);
 352 text_row(_("Secondary Phone Number:"), 'phone2', null, 32, 30);
 353 text_row(_("Fax Number:"), 'fax', null, 32, 30);
 354
 355 email_row(_("E-mail:"), 'email', null, 35, 55);
 356
 357 table_section_title(_("Sales"));
 358
 359 sales_persons_list_row( _("Sales Person:"), 'salesman', null);
 360
 361 sales_areas_list_row( _("Sales Area:"), 'area', null);
 362
 363 sales_groups_list_row(_("Sales Group:"), 'group_no', null, true);
 364
 365 locations_list_row(_("Default Inventory Location:"), 'default_location', null);
 366
 367 shippers_list_row(_("Default Shipping Company:"), 'default_ship_via', null);
 368
 369 tax_groups_list_row(_("Tax Group:"), 'tax_group_id', null);
 370
 371 yesno_list_row(_("Disable this Branch:"), 'disable_trans', null);
 372
 373 table_section(2);
 374
 375 table_section_title(_("GL Accounts"));
 376
 377 // 2006-06-14. Changed gl_al_accounts_list to have an optional all_option 'Use Item Sales Accounts'
 378 gl_all_accounts_list_row(_("Sales Account:"), 'sales_account', null, false, false, true);
 379
 380 gl_all_accounts_list_row(_("Sales Discount Account:"), 'sales_discount_account');
 381
 382 gl_all_accounts_list_row(_("Accounts Receivable Account:"), 'receivables_account');
 383
 384 gl_all_accounts_list_row(_("Prompt Payment Discount Account:"), 'payment_discount_account');
 385
 386 table_section_title(_("Addresses"));
 387
 388 textarea_row(_("Mailing Address:"), 'br_post_address', null, 35, 4);
 389
 390 textarea_row(_("Billing Address:"), 'br_address', null, 35, 4);
 391
 392 textarea_row(_("General Notes:"), 'notes', null, 35, 4);
 393
 394 end_outer_table(1);
 395
 396 submit_add_or_update_center($selected_id == -1, '', 'both');
 397
 398 end_form();
 399
 400 end_page();
 401
 402 ?>