sales/sales_order_entry.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 //-----------------------------------------------------------------------------
  13 //
  14 //      Entry/Modify Sales Quotations
  15 //      Entry/Modify Sales Order
  16 //      Entry Direct Delivery
  17 //      Entry Direct Invoice
  18 //
  19
  20 $path_to_root = "..";
  21 $page_security = 'SA_SALESORDER';
  22
  23 include_once($path_to_root . "/sales/includes/cart_class.inc");
  24 include_once($path_to_root . "/includes/session.inc");
  25 include_once($path_to_root . "/sales/includes/sales_ui.inc");
  26 include_once($path_to_root . "/sales/includes/ui/sales_order_ui.inc");
  27 include_once($path_to_root . "/sales/includes/sales_db.inc");
  28 include_once($path_to_root . "/sales/includes/db/sales_types_db.inc");
  29 include_once($path_to_root . "/reporting/includes/reporting.inc");
  30
  31 set_page_security( @$_SESSION['Items']->trans_type,
  32         array(  ST_SALESORDER=>'SA_SALESORDER',
  33                         ST_SALESQUOTE => 'SA_SALESQUOTE',
  34                         ST_CUSTDELIVERY => 'SA_SALESDELIVERY',
  35                         ST_SALESINVOICE => 'SA_SALESINVOICE'),
  36         array(  'NewOrder' => 'SA_SALESORDER',
  37                         'ModifyOrderNumber' => 'SA_SALESORDER',
  38                         'AddedID' => 'SA_SALESORDER',
  39                         'UpdatedID' => 'SA_SALESORDER',
  40                         'NewQuotation' => 'SA_SALESQUOTE',
  41                         'ModifyQuotationNumber' => 'SA_SALESQUOTE',
  42                         'NewQuoteToSalesOrder' => 'SA_SALESQUOTE',
  43                         'AddedQU' => 'SA_SALESQUOTE',
  44                         'UpdatedQU' => 'SA_SALESQUOTE',
  45                         'NewDelivery' => 'SA_SALESDELIVERY',
  46                         'AddedDN' => 'SA_SALESDELIVERY',
  47                         'NewInvoice' => 'SA_SALESINVOICE',
  48                         'AddedDI' => 'SA_SALESINVOICE'
  49                         )
  50 );
  51
  52 $js = '';
  53
  54 if ($SysPrefs->use_popup_windows) {
  55         $js .= get_js_open_window(900, 500);
  56 }
  57
  58 if (user_use_date_picker()) {
  59         $js .= get_js_date_picker();
  60 }
  61
  62 if (isset($_GET['NewDelivery']) && is_numeric($_GET['NewDelivery'])) {
  63
  64         $_SESSION['page_title'] = _($help_context = "Direct Sales Delivery");
  65         create_cart(ST_CUSTDELIVERY, $_GET['NewDelivery']);
  66
  67 } elseif (isset($_GET['NewInvoice']) && is_numeric($_GET['NewInvoice'])) {
  68
  69         create_cart(ST_SALESINVOICE, $_GET['NewInvoice']);
  70
  71         if (isset($_GET['FixedAsset'])) {
  72                 $_SESSION['page_title'] = _($help_context = "Fixed Assets Sale");
  73                 $_SESSION['Items']->fixed_asset = true;
  74         } else
  75                 $_SESSION['page_title'] = _($help_context = "Direct Sales Invoice");
  76
  77 } elseif (isset($_GET['ModifyOrderNumber']) && is_numeric($_GET['ModifyOrderNumber'])) {
  78
  79         $help_context = 'Modifying Sales Order';
  80         $_SESSION['page_title'] = sprintf( _("Modifying Sales Order # %d"), $_GET['ModifyOrderNumber']);
  81         create_cart(ST_SALESORDER, $_GET['ModifyOrderNumber']);
  82
  83 } elseif (isset($_GET['ModifyQuotationNumber']) && is_numeric($_GET['ModifyQuotationNumber'])) {
  84
  85         $help_context = 'Modifying Sales Quotation';
  86         $_SESSION['page_title'] = sprintf( _("Modifying Sales Quotation # %d"), $_GET['ModifyQuotationNumber']);
  87         create_cart(ST_SALESQUOTE, $_GET['ModifyQuotationNumber']);
  88
  89 } elseif (isset($_GET['NewOrder'])) {
  90
  91         $_SESSION['page_title'] = _($help_context = "New Sales Order Entry");
  92         create_cart(ST_SALESORDER, 0);
  93 } elseif (isset($_GET['NewQuotation'])) {
  94
  95         $_SESSION['page_title'] = _($help_context = "New Sales Quotation Entry");
  96         create_cart(ST_SALESQUOTE, 0);
  97 } elseif (isset($_GET['NewQuoteToSalesOrder'])) {
  98         $_SESSION['page_title'] = _($help_context = "Sales Order Entry");
  99         create_cart(ST_SALESQUOTE, $_GET['NewQuoteToSalesOrder']);
 100 }
 101
 102 page($_SESSION['page_title'], false, false, "", $js);
 103
 104 if (isset($_GET['ModifyOrderNumber']) && is_prepaid_order_open($_GET['ModifyOrderNumber']))
 105 {
 106         display_error(_("This order cannot be edited because there are invoices or payments related to it, and prepayment terms were used."));
 107         end_page(); exit;
 108 }
 109 if (isset($_GET['ModifyOrderNumber']))
 110         check_is_editable(ST_SALESORDER, $_GET['ModifyOrderNumber']);
 111 elseif (isset($_GET['ModifyQuotationNumber']))
 112         check_is_editable(ST_SALESQUOTE, $_GET['ModifyQuotationNumber']);
 113
 114 //-----------------------------------------------------------------------------
 115
 116 if (list_updated('branch_id')) {
 117         // when branch is selected via external editor also customer can change
 118         $br = get_branch(get_post('branch_id'));
 119         $_POST['customer_id'] = $br['debtor_no'];
 120         $Ajax->activate('customer_id');
 121 }
 122
 123 if (isset($_GET['AddedID'])) {
 124         $order_no = $_GET['AddedID'];
 125         display_notification_centered(sprintf( _("Order # %d has been entered."),$order_no));
 126
 127         submenu_view(_("&View This Order"), ST_SALESORDER, $order_no);
 128
 129         submenu_print(_("&Print This Order"), ST_SALESORDER, $order_no, 'prtopt');
 130         submenu_print(_("&Email This Order"), ST_SALESORDER, $order_no, null, 1);
 131         set_focus('prtopt');
 132
 133         submenu_option(_("Make &Delivery Against This Order"),
 134                 "/sales/customer_delivery.php?OrderNumber=$order_no");
 135
 136         submenu_option(_("Work &Order Entry"),  "/manufacturing/work_order_entry.php?");
 137
 138         submenu_option(_("Enter a &New Order"), "/sales/sales_order_entry.php?NewOrder=0");
 139
 140         submenu_option(_("Add an Attachment"), "/admin/attachments.php?filterType=".ST_SALESORDER."&trans_no=$order_no");
 141
 142         display_footer_exit();
 143
 144 } elseif (isset($_GET['UpdatedID'])) {
 145         $order_no = $_GET['UpdatedID'];
 146
 147         display_notification_centered(sprintf( _("Order # %d has been updated."),$order_no));
 148
 149         submenu_view(_("&View This Order"), ST_SALESORDER, $order_no);
 150
 151         submenu_print(_("&Print This Order"), ST_SALESORDER, $order_no, 'prtopt');
 152         submenu_print(_("&Email This Order"), ST_SALESORDER, $order_no, null, 1);
 153         set_focus('prtopt');
 154
 155         submenu_option(_("Confirm Order Quantities and Make &Delivery"),
 156                 "/sales/customer_delivery.php?OrderNumber=$order_no");
 157
 158         submenu_option(_("Select A Different &Order"),
 159                 "/sales/inquiry/sales_orders_view.php?OutstandingOnly=1");
 160
 161         display_footer_exit();
 162
 163 } elseif (isset($_GET['AddedQU'])) {
 164         $order_no = $_GET['AddedQU'];
 165         display_notification_centered(sprintf( _("Quotation # %d has been entered."),$order_no));
 166
 167         submenu_view(_("&View This Quotation"), ST_SALESQUOTE, $order_no);
 168
 169         submenu_print(_("&Print This Quotation"), ST_SALESQUOTE, $order_no, 'prtopt');
 170         submenu_print(_("&Email This Quotation"), ST_SALESQUOTE, $order_no, null, 1);
 171         set_focus('prtopt');
 172
 173         submenu_option(_("Make &Sales Order Against This Quotation"),
 174                 "/sales/sales_order_entry.php?NewQuoteToSalesOrder=$order_no");
 175
 176         submenu_option(_("Enter a New &Quotation"),     "/sales/sales_order_entry.php?NewQuotation=0");
 177
 178         submenu_option(_("Add an Attachment"), "/admin/attachments.php?filterType=".ST_SALESQUOTE."&trans_no=$order_no");
 179
 180         display_footer_exit();
 181
 182 } elseif (isset($_GET['UpdatedQU'])) {
 183         $order_no = $_GET['UpdatedQU'];
 184
 185         display_notification_centered(sprintf( _("Quotation # %d has been updated."),$order_no));
 186
 187         submenu_view(_("&View This Quotation"), ST_SALESQUOTE, $order_no);
 188
 189         submenu_print(_("&Print This Quotation"), ST_SALESQUOTE, $order_no, 'prtopt');
 190         submenu_print(_("&Email This Quotation"), ST_SALESQUOTE, $order_no, null, 1);
 191         set_focus('prtopt');
 192
 193         submenu_option(_("Make &Sales Order Against This Quotation"),
 194                 "/sales/sales_order_entry.php?NewQuoteToSalesOrder=$order_no");
 195
 196         submenu_option(_("Select A Different &Quotation"),
 197                 "/sales/inquiry/sales_orders_view.php?type=".ST_SALESQUOTE);
 198
 199         display_footer_exit();
 200 } elseif (isset($_GET['AddedDN'])) {
 201         $delivery = $_GET['AddedDN'];
 202
 203         display_notification_centered(sprintf(_("Delivery # %d has been entered."),$delivery));
 204
 205         submenu_view(_("&View This Delivery"), ST_CUSTDELIVERY, $delivery);
 206
 207         submenu_print(_("&Print Delivery Note"), ST_CUSTDELIVERY, $delivery, 'prtopt');
 208         submenu_print(_("&Email Delivery Note"), ST_CUSTDELIVERY, $delivery, null, 1);
 209         submenu_print(_("P&rint as Packing Slip"), ST_CUSTDELIVERY, $delivery, 'prtopt', null, 1);
 210         submenu_print(_("E&mail as Packing Slip"), ST_CUSTDELIVERY, $delivery, null, 1, 1);
 211         set_focus('prtopt');
 212
 213         display_note(get_gl_view_str(ST_CUSTDELIVERY, $delivery, _("View the GL Journal Entries for this Dispatch")),0, 1);
 214
 215         submenu_option(_("Make &Invoice Against This Delivery"),
 216                 "/sales/customer_invoice.php?DeliveryNumber=$delivery");
 217
 218         if ((isset($_GET['Type']) && $_GET['Type'] == 1))
 219                 submenu_option(_("Enter a New Template &Delivery"),
 220                         "/sales/inquiry/sales_orders_view.php?DeliveryTemplates=Yes");
 221         else
 222                 submenu_option(_("Enter a &New Delivery"),
 223                         "/sales/sales_order_entry.php?NewDelivery=0");
 224
 225         submenu_option(_("Add an Attachment"), "/admin/attachments.php?filterType=".ST_CUSTDELIVERY."&trans_no=$delivery");
 226
 227         display_footer_exit();
 228
 229 } elseif (isset($_GET['AddedDI'])) {
 230         $invoice = $_GET['AddedDI'];
 231
 232         display_notification_centered(sprintf(_("Invoice # %d has been entered."), $invoice));
 233
 234         submenu_view(_("&View This Invoice"), ST_SALESINVOICE, $invoice);
 235
 236         submenu_print(_("&Print Sales Invoice"), ST_SALESINVOICE, $invoice."-".ST_SALESINVOICE, 'prtopt');
 237         submenu_print(_("&Email Sales Invoice"), ST_SALESINVOICE, $invoice."-".ST_SALESINVOICE, null, 1);
 238         set_focus('prtopt');
 239
 240         $row = db_fetch(get_allocatable_from_cust_transactions(null, $invoice, ST_SALESINVOICE));
 241         if ($row !== false)
 242                 submenu_print(_("Print &Receipt"), $row['type'], $row['trans_no']."-".$row['type'], 'prtopt');
 243
 244         display_note(get_gl_view_str(ST_SALESINVOICE, $invoice, _("View the GL &Journal Entries for this Invoice")),0, 1);
 245
 246         if ((isset($_GET['Type']) && $_GET['Type'] == 1))
 247                 submenu_option(_("Enter a &New Template Invoice"),
 248                         "/sales/inquiry/sales_orders_view.php?InvoiceTemplates=Yes");
 249         else
 250                 submenu_option(_("Enter a &New Direct Invoice"),
 251                         "/sales/sales_order_entry.php?NewInvoice=0");
 252
 253         if ($row === false)
 254                 submenu_option(_("Entry &customer payment for this invoice"), "/sales/customer_payments.php?SInvoice=".$invoice);
 255
 256         submenu_option(_("Add an Attachment"), "/admin/attachments.php?filterType=".ST_SALESINVOICE."&trans_no=$invoice");
 257
 258         display_footer_exit();
 259 } else
 260         check_edit_conflicts(get_post('cart_id'));
 261 //-----------------------------------------------------------------------------
 262
 263 function copy_to_cart()
 264 {
 265         $cart = &$_SESSION['Items'];
 266
 267         $cart->reference = get_post('ref');
 268
 269         $cart->Comments =  $_POST['Comments'];
 270
 271         $cart->document_date = $_POST['OrderDate'];
 272
 273         $newpayment = false;
 274
 275         if (isset($_POST['payment']) && ($cart->payment != $_POST['payment'])) {
 276                 $cart->payment = $_POST['payment'];
 277                 $cart->payment_terms = get_payment_terms($_POST['payment']);
 278                 $newpayment = true;
 279         }
 280         if ($cart->payment_terms['cash_sale']) {
 281                 if ($newpayment) {
 282                         $cart->due_date = $cart->document_date;
 283                         $cart->phone = $cart->cust_ref = $cart->delivery_address = '';
 284                         $cart->ship_via = 0;
 285                         $cart->deliver_to = '';
 286                         $cart->prep_amount = 0;
 287                 }
 288         } else {
 289                 $cart->due_date = $_POST['delivery_date'];
 290                 $cart->cust_ref = $_POST['cust_ref'];
 291                 $cart->deliver_to = $_POST['deliver_to'];
 292                 $cart->delivery_address = $_POST['delivery_address'];
 293                 $cart->phone = $_POST['phone'];
 294                 $cart->ship_via = $_POST['ship_via'];
 295                 if (!$cart->trans_no || ($cart->trans_type == ST_SALESORDER && !$cart->is_started()))
 296                         $cart->prep_amount = input_num('prep_amount', 0);
 297         }
 298         $cart->Location = $_POST['Location'];
 299         $cart->freight_cost = input_num('freight_cost');
 300         if (isset($_POST['email']))
 301                 $cart->email =$_POST['email'];
 302         else
 303                 $cart->email = '';
 304         $cart->customer_id      = $_POST['customer_id'];
 305         $cart->Branch = $_POST['branch_id'];
 306         $cart->sales_type = $_POST['sales_type'];
 307
 308         if ($cart->trans_type!=ST_SALESORDER && $cart->trans_type!=ST_SALESQUOTE) { // 2008-11-12 Joe Hunt
 309                 $cart->dimension_id = $_POST['dimension_id'];
 310                 $cart->dimension2_id = $_POST['dimension2_id'];
 311         }
 312         $cart->ex_rate = input_num('_ex_rate', null);
 313 }
 314
 315 //-----------------------------------------------------------------------------
 316
 317 function copy_from_cart()
 318 {
 319         $cart = &$_SESSION['Items'];
 320         $_POST['ref'] = $cart->reference;
 321         $_POST['Comments'] = $cart->Comments;
 322
 323         $_POST['OrderDate'] = $cart->document_date;
 324         $_POST['delivery_date'] = $cart->due_date;
 325         $_POST['cust_ref'] = $cart->cust_ref;
 326         $_POST['freight_cost'] = price_format($cart->freight_cost);
 327
 328         $_POST['deliver_to'] = $cart->deliver_to;
 329         $_POST['delivery_address'] = $cart->delivery_address;
 330         $_POST['phone'] = $cart->phone;
 331         $_POST['Location'] = $cart->Location;
 332         $_POST['ship_via'] = $cart->ship_via;
 333
 334         $_POST['customer_id'] = $cart->customer_id;
 335
 336         $_POST['branch_id'] = $cart->Branch;
 337         $_POST['sales_type'] = $cart->sales_type;
 338         $_POST['prep_amount'] = price_format($cart->prep_amount);
 339         // POS
 340         $_POST['payment'] = $cart->payment;
 341         if ($cart->trans_type!=ST_SALESORDER && $cart->trans_type!=ST_SALESQUOTE) { // 2008-11-12 Joe Hunt
 342                 $_POST['dimension_id'] = $cart->dimension_id;
 343                 $_POST['dimension2_id'] = $cart->dimension2_id;
 344         }
 345         $_POST['cart_id'] = $cart->cart_id;
 346         $_POST['_ex_rate'] = $cart->ex_rate;
 347 }
 348 //--------------------------------------------------------------------------------
 349
 350 function line_start_focus() {
 351         global  $Ajax;
 352
 353         $Ajax->activate('items_table');
 354         set_focus('_stock_id_edit');
 355 }
 356
 357 //--------------------------------------------------------------------------------
 358 function can_process() {
 359
 360         global $Refs, $SysPrefs;
 361
 362         copy_to_cart();
 363
 364         if (!get_post('customer_id'))
 365         {
 366                 display_error(_("There is no customer selected."));
 367                 set_focus('customer_id');
 368                 return false;
 369         }
 370
 371         if (!get_post('branch_id'))
 372         {
 373                 display_error(_("This customer has no branch defined."));
 374                 set_focus('branch_id');
 375                 return false;
 376         }
 377
 378         if (!is_date($_POST['OrderDate'])) {
 379                 display_error(_("The entered date is invalid."));
 380                 set_focus('OrderDate');
 381                 return false;
 382         }
 383         if ($_SESSION['Items']->trans_type!=ST_SALESORDER && $_SESSION['Items']->trans_type!=ST_SALESQUOTE && !is_date_in_fiscalyear($_POST['OrderDate'])) {
 384                 display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
 385                 set_focus('OrderDate');
 386                 return false;
 387         }
 388         if (count($_SESSION['Items']->line_items) == 0) {
 389                 display_error(_("You must enter at least one non empty item line."));
 390                 set_focus('AddItem');
 391                 return false;
 392         }
 393         if (!$SysPrefs->allow_negative_stock() && ($low_stock = $_SESSION['Items']->check_qoh()))
 394         {
 395                 display_error(_("This document cannot be processed because there is insufficient quantity for items marked."));
 396                 return false;
 397         }
 398         if ($_SESSION['Items']->payment_terms['cash_sale'] == 0) {
 399                 if (!$_SESSION['Items']->is_started() && ($_SESSION['Items']->payment_terms['days_before_due'] == -1) && ((input_num('prep_amount')<=0) ||
 400                         input_num('prep_amount')>$_SESSION['Items']->get_trans_total())) {
 401                         display_error(_("Pre-payment required have to be positive and less than total amount."));
 402                         set_focus('prep_amount');
 403                         return false;
 404                 }
 405                 if (strlen($_POST['deliver_to']) <= 1) {
 406                         display_error(_("You must enter the person or company to whom delivery should be made to."));
 407                         set_focus('deliver_to');
 408                         return false;
 409                 }
 410
 411                 if ($_SESSION['Items']->trans_type != ST_SALESQUOTE && strlen($_POST['delivery_address']) <= 1) {
 412                         display_error( _("You should enter the street address in the box provided. Orders cannot be accepted without a valid street address."));
 413                         set_focus('delivery_address');
 414                         return false;
 415                 }
 416
 417                 if ($_POST['freight_cost'] == "")
 418                         $_POST['freight_cost'] = price_format(0);
 419
 420                 if (!check_num('freight_cost',0)) {
 421                         display_error(_("The shipping cost entered is expected to be numeric."));
 422                         set_focus('freight_cost');
 423                         return false;
 424                 }
 425                 if (!is_date($_POST['delivery_date'])) {
 426                         if ($_SESSION['Items']->trans_type==ST_SALESQUOTE)
 427                                 display_error(_("The Valid date is invalid."));
 428                         else
 429                                 display_error(_("The delivery date is invalid."));
 430                         set_focus('delivery_date');
 431                         return false;
 432                 }
 433                 if (date1_greater_date2($_POST['OrderDate'], $_POST['delivery_date'])) {
 434                         if ($_SESSION['Items']->trans_type==ST_SALESQUOTE)
 435                                 display_error(_("The requested valid date is before the date of the quotation."));
 436                         else
 437                                 display_error(_("The requested delivery date is before the date of the order."));
 438                         set_focus('delivery_date');
 439                         return false;
 440                 }
 441         }
 442         else
 443         {
 444                 if (!db_has_cash_accounts())
 445                 {
 446                         display_error(_("You need to define a cash account for your Sales Point."));
 447                         return false;
 448                 }
 449         }
 450         if (!$Refs->is_valid($_POST['ref'], $_SESSION['Items']->trans_type)) {
 451                 display_error(_("You must enter a reference."));
 452                 set_focus('ref');
 453                 return false;
 454         }
 455         if (!db_has_currency_rates($_SESSION['Items']->customer_currency, $_POST['OrderDate']))
 456                 return false;
 457
 458         if ($_SESSION['Items']->get_items_total() < 0) {
 459                 display_error("Invoice total amount cannot be less than zero.");
 460                 return false;
 461         }
 462
 463         if ($_SESSION['Items']->payment_terms['cash_sale'] &&
 464                 ($_SESSION['Items']->trans_type == ST_CUSTDELIVERY || $_SESSION['Items']->trans_type == ST_SALESINVOICE))
 465                 $_SESSION['Items']->due_date = $_SESSION['Items']->document_date;
 466         return true;
 467 }
 468
 469 //-----------------------------------------------------------------------------
 470
 471 if (isset($_POST['update'])) {
 472         copy_to_cart();
 473         $Ajax->activate('items_table');
 474 }
 475
 476 if (isset($_POST['ProcessOrder']) && can_process()) {
 477
 478         $modified = ($_SESSION['Items']->trans_no != 0);
 479         $so_type = $_SESSION['Items']->so_type;
 480
 481         $ret = $_SESSION['Items']->write(1);
 482         if ($ret == -1)
 483         {
 484                 display_error(_("The entered reference is already in use."));
 485                 $ref = $Refs->get_next($_SESSION['Items']->trans_type, null, array('date' => Today()));
 486                 if ($ref != $_SESSION['Items']->reference)
 487                 {
 488                         unset($_POST['ref']); // force refresh reference
 489                         display_error(_("The reference number field has been increased. Please save the document again."));
 490                 }
 491                 set_focus('ref');
 492         }
 493         else
 494         {
 495                 if (count($messages)) { // abort on failure or error messages are lost
 496                         $Ajax->activate('_page_body');
 497                         display_footer_exit();
 498                 }
 499                 $trans_no = key($_SESSION['Items']->trans_no);
 500                 $trans_type = $_SESSION['Items']->trans_type;
 501                 new_doc_date($_SESSION['Items']->document_date);
 502                 processing_end();
 503                 if ($modified) {
 504                         if ($trans_type == ST_SALESQUOTE)
 505                                 meta_forward($_SERVER['PHP_SELF'], "UpdatedQU=$trans_no");
 506                         else
 507                                 meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$trans_no");
 508                 } elseif ($trans_type == ST_SALESORDER) {
 509                         meta_forward($_SERVER['PHP_SELF'], "AddedID=$trans_no");
 510                 } elseif ($trans_type == ST_SALESQUOTE) {
 511                         meta_forward($_SERVER['PHP_SELF'], "AddedQU=$trans_no");
 512                 } elseif ($trans_type == ST_SALESINVOICE) {
 513                         meta_forward($_SERVER['PHP_SELF'], "AddedDI=$trans_no&Type=$so_type");
 514                 } else {
 515                         meta_forward($_SERVER['PHP_SELF'], "AddedDN=$trans_no&Type=$so_type");
 516                 }
 517         }
 518 }
 519
 520 //--------------------------------------------------------------------------------
 521
 522 function check_item_data()
 523 {
 524         global $SysPrefs;
 525
 526         $is_inventory_item = is_inventory_item(get_post('stock_id'));
 527         if(!get_post('stock_id_text', true)) {
 528                 display_error( _("Item description cannot be empty."));
 529                 set_focus('stock_id_edit');
 530                 return false;
 531         }
 532         elseif (!check_num('qty', 0) || !check_num('Disc', 0, 100)) {
 533                 display_error( _("The item could not be updated because you are attempting to set the quantity ordered to less than 0, or the discount percent to more than 100."));
 534                 set_focus('qty');
 535                 return false;
 536         } elseif (!check_num('price', 0) && (!$SysPrefs->allow_negative_prices() || $is_inventory_item)) {
 537                 display_error( _("Price for inventory item must be entered and can not be less than 0"));
 538                 set_focus('price');
 539                 return false;
 540         } elseif (isset($_POST['LineNo']) && isset($_SESSION['Items']->line_items[$_POST['LineNo']])
 541             && !check_num('qty', $_SESSION['Items']->line_items[$_POST['LineNo']]->qty_done)) {
 542
 543                 set_focus('qty');
 544                 display_error(_("You attempting to make the quantity ordered a quantity less than has already been delivered. The quantity delivered cannot be modified retrospectively."));
 545                 return false;
 546         }
 547
 548         $cost_home = get_unit_cost(get_post('stock_id')); // Added 2011-03-27 Joe Hunt
 549         $cost = $cost_home / get_exchange_rate_from_home_currency($_SESSION['Items']->customer_currency, $_SESSION['Items']->document_date);
 550         if (input_num('price') < $cost)
 551         {
 552                 $dec = user_price_dec();
 553                 $curr = $_SESSION['Items']->customer_currency;
 554                 $price = number_format2(input_num('price'), $dec);
 555                 if ($cost_home == $cost)
 556                         $std_cost = number_format2($cost_home, $dec);
 557                 else
 558                 {
 559                         $price = $curr . " " . $price;
 560                         $std_cost = $curr . " " . number_format2($cost, $dec);
 561                 }
 562                 display_warning(sprintf(_("Price %s is below Standard Cost %s"), $price, $std_cost));
 563         }
 564         return true;
 565 }
 566
 567 //--------------------------------------------------------------------------------
 568
 569 function handle_update_item()
 570 {
 571         if ($_POST['UpdateItem'] != '' && check_item_data()) {
 572                 $_SESSION['Items']->update_cart_item($_POST['LineNo'],
 573                  input_num('qty'), input_num('price'),
 574                  input_num('Disc') / 100, $_POST['item_description'] );
 575         }
 576         page_modified();
 577   line_start_focus();
 578 }
 579
 580 //--------------------------------------------------------------------------------
 581
 582 function handle_delete_item($line_no)
 583 {
 584     if ($_SESSION['Items']->some_already_delivered($line_no) == 0) {
 585             $_SESSION['Items']->remove_from_cart($line_no);
 586     } else {
 587                 display_error(_("This item cannot be deleted because some of it has already been delivered."));
 588     }
 589     line_start_focus();
 590 }
 591
 592 //--------------------------------------------------------------------------------
 593
 594 function handle_new_item()
 595 {
 596
 597         if (!check_item_data()) {
 598                         return;
 599         }
 600         add_to_order($_SESSION['Items'], get_post('stock_id'), input_num('qty'),
 601                 input_num('price'), input_num('Disc') / 100, get_post('stock_id_text'));
 602
 603         unset($_POST['_stock_id_edit'], $_POST['stock_id']);
 604         page_modified();
 605         line_start_focus();
 606 }
 607
 608 //--------------------------------------------------------------------------------
 609
 610 function  handle_cancel_order()
 611 {
 612         global $path_to_root, $Ajax;
 613
 614
 615         if ($_SESSION['Items']->trans_type == ST_CUSTDELIVERY) {
 616                 display_notification(_("Direct delivery entry has been cancelled as requested."), 1);
 617                 submenu_option(_("Enter a New Sales Delivery"), "/sales/sales_order_entry.php?NewDelivery=1");
 618         } elseif ($_SESSION['Items']->trans_type == ST_SALESINVOICE) {
 619                 display_notification(_("Direct invoice entry has been cancelled as requested."), 1);
 620                 submenu_option(_("Enter a New Sales Invoice"),  "/sales/sales_order_entry.php?NewInvoice=1");
 621         } elseif ($_SESSION['Items']->trans_type == ST_SALESQUOTE)
 622         {
 623                 if ($_SESSION['Items']->trans_no != 0)
 624                         delete_sales_order(key($_SESSION['Items']->trans_no), $_SESSION['Items']->trans_type);
 625                 display_notification(_("This sales quotation has been cancelled as requested."), 1);
 626                 submenu_option(_("Enter a New Sales Quotation"), "/sales/sales_order_entry.php?NewQuotation=Yes");
 627         } else { // sales order
 628                 if ($_SESSION['Items']->trans_no != 0) {
 629                         $order_no = key($_SESSION['Items']->trans_no);
 630                         if (sales_order_has_deliveries($order_no))
 631                         {
 632                                 close_sales_order($order_no);
 633                                 display_notification(_("Undelivered part of order has been cancelled as requested."), 1);
 634                                 submenu_option(_("Select Another Sales Order for Edition"), "/sales/inquiry/sales_orders_view.php?type=".ST_SALESORDER);
 635                         } else {
 636                                 delete_sales_order(key($_SESSION['Items']->trans_no), $_SESSION['Items']->trans_type);
 637
 638                                 display_notification(_("This sales order has been cancelled as requested."), 1);
 639                                 submenu_option(_("Enter a New Sales Order"), "/sales/sales_order_entry.php?NewOrder=Yes");
 640                         }
 641                 } else {
 642                         processing_end();
 643                         meta_forward($path_to_root.'/index.php','application=orders');
 644                 }
 645         }
 646         processing_end();
 647         display_footer_exit();
 648 }
 649
 650 //--------------------------------------------------------------------------------
 651
 652 function create_cart($type, $trans_no)
 653 {
 654         global $Refs, $SysPrefs;
 655
 656         if (!$SysPrefs->db_ok) // create_cart is called before page() where the check is done
 657                 return;
 658
 659         processing_start();
 660
 661         if (isset($_GET['NewQuoteToSalesOrder']))
 662         {
 663                 $trans_no = $_GET['NewQuoteToSalesOrder'];
 664                 $doc = new Cart(ST_SALESQUOTE, $trans_no, true);
 665                 $doc->Comments = _("Sales Quotation") . " # " . $trans_no;
 666                 $_SESSION['Items'] = $doc;
 667         }
 668         elseif($type != ST_SALESORDER && $type != ST_SALESQUOTE && $trans_no != 0) { // this is template
 669
 670                 $doc = new Cart(ST_SALESORDER, array($trans_no));
 671                 $doc->trans_type = $type;
 672                 $doc->trans_no = 0;
 673                 $doc->document_date = new_doc_date();
 674                 if ($type == ST_SALESINVOICE) {
 675                         $doc->due_date = get_invoice_duedate($doc->payment, $doc->document_date);
 676                         $doc->pos = get_sales_point(user_pos());
 677                 } else
 678                         $doc->due_date = $doc->document_date;
 679                 $doc->reference = $Refs->get_next($doc->trans_type, null, array('date' => Today()));
 680                 //$doc->Comments='';
 681                 foreach($doc->line_items as $line_no => $line) {
 682                         $doc->line_items[$line_no]->qty_done = 0;
 683                 }
 684                 $_SESSION['Items'] = $doc;
 685         } else
 686                 $_SESSION['Items'] = new Cart($type, array($trans_no));
 687         copy_from_cart();
 688 }
 689
 690 //--------------------------------------------------------------------------------
 691
 692 if (isset($_POST['CancelOrder']))
 693         handle_cancel_order();
 694
 695 $id = find_submit('Delete');
 696 if ($id!=-1)
 697         handle_delete_item($id);
 698
 699 if (isset($_POST['UpdateItem']))
 700         handle_update_item();
 701
 702 if (isset($_POST['AddItem']))
 703         handle_new_item();
 704
 705 if (isset($_POST['CancelItemChanges'])) {
 706         line_start_focus();
 707 }
 708
 709 //--------------------------------------------------------------------------------
 710 if ($_SESSION['Items']->fixed_asset)
 711         check_db_has_disposable_fixed_assets(_("There are no fixed assets defined in the system."));
 712 else
 713         check_db_has_stock_items(_("There are no inventory items defined in the system."));
 714
 715 check_db_has_customer_branches(_("There are no customers, or there are no customers with branches. Please define customers and customer branches."));
 716
 717 if ($_SESSION['Items']->trans_type == ST_SALESINVOICE) {
 718         $idate = _("Invoice Date:");
 719         $orderitems = _("Sales Invoice Items");
 720         $deliverydetails = _("Enter Delivery Details and Confirm Invoice");
 721         $cancelorder = _("Cancel Invoice");
 722         $porder = _("Place Invoice");
 723 } elseif ($_SESSION['Items']->trans_type == ST_CUSTDELIVERY) {
 724         $idate = _("Delivery Date:");
 725         $orderitems = _("Delivery Note Items");
 726         $deliverydetails = _("Enter Delivery Details and Confirm Dispatch");
 727         $cancelorder = _("Cancel Delivery");
 728         $porder = _("Place Delivery");
 729 } elseif ($_SESSION['Items']->trans_type == ST_SALESQUOTE) {
 730         $idate = _("Quotation Date:");
 731         $orderitems = _("Sales Quotation Items");
 732         $deliverydetails = _("Enter Delivery Details and Confirm Quotation");
 733         $cancelorder = _("Cancel Quotation");
 734         $porder = _("Place Quotation");
 735         $corder = _("Commit Quotations Changes");
 736 } else {
 737         $idate = _("Order Date:");
 738         $orderitems = _("Sales Order Items");
 739         $deliverydetails = _("Enter Delivery Details and Confirm Order");
 740         $cancelorder = _("Cancel Order");
 741         $porder = _("Place Order");
 742         $corder = _("Commit Order Changes");
 743 }
 744 start_form();
 745
 746 hidden('cart_id');
 747 $customer_error = display_order_header($_SESSION['Items'], !$_SESSION['Items']->is_started(), $idate);
 748
 749 if ($customer_error == "") {
 750         start_table(TABLESTYLE, "width='80%'", 10);
 751         echo "<tr><td>";
 752         display_order_summary($orderitems, $_SESSION['Items'], true);
 753         echo "</td></tr>";
 754         echo "<tr><td>";
 755         display_delivery_details($_SESSION['Items']);
 756         echo "</td></tr>";
 757         end_table(1);
 758
 759         if ($_SESSION['Items']->trans_no == 0) {
 760
 761                 submit_center_first('ProcessOrder', $porder,
 762                     _('Check entered data and save document'), 'default');
 763                 submit_center_last('CancelOrder', $cancelorder,
 764                         _('Cancels document entry or removes sales order when editing an old document'));
 765                 submit_js_confirm('CancelOrder', _('You are about to void this Document.\nDo you want to continue?'));
 766         } else {
 767                 submit_center_first('ProcessOrder', $corder,
 768                     _('Validate changes and update document'), 'default');
 769                 submit_center_last('CancelOrder', $cancelorder,
 770                         _('Cancels document entry or removes sales order when editing an old document'));
 771                 if ($_SESSION['Items']->trans_type==ST_SALESORDER)
 772                         submit_js_confirm('CancelOrder', _('You are about to cancel undelivered part of this order.\nDo you want to continue?'));
 773                 else
 774                         submit_js_confirm('CancelOrder', _('You are about to void this Document.\nDo you want to continue?'));
 775         }
 776
 777 } else {
 778         display_error($customer_error);
 779 }
 780
 781 end_form();
 782 end_page();