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