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