Rerun. Update button for change of shipping
[fa-stable.git] / sales / sales_order_entry.php
index e7cd0636d2e54c591e146e1d6a0754a47f48e37b..c7255881b92864033b91df8305d2373ca9129513 100644 (file)
 ***********************************************************************/
 //-----------------------------------------------------------------------------
 //
+//     Entry/Modify Sales Quotations
 //     Entry/Modify Sales Order
 //     Entry Direct Delivery
 //     Entry Direct Invoice
 //
 
-$page_security = 1;
-$path_to_root="..";
+$path_to_root = "..";
+$page_security = 'SA_SALESORDER';
 
 include_once($path_to_root . "/sales/includes/cart_class.inc");
 include_once($path_to_root . "/includes/session.inc");
@@ -26,6 +27,20 @@ include_once($path_to_root . "/sales/includes/ui/sales_order_ui.inc");
 include_once($path_to_root . "/sales/includes/sales_db.inc");
 include_once($path_to_root . "/sales/includes/db/sales_types_db.inc");
 include_once($path_to_root . "/reporting/includes/reporting.inc");
+
+set_page_security( @$_SESSION['Items']->trans_type,
+       array(  ST_SALESORDER=>'SA_SALESORDER',
+                       ST_SALESQUOTE => 'SA_SALESQUOTE',
+                       ST_CUSTDELIVERY => 'SA_SALESDELIVERY',
+                       ST_SALESINVOICE => 'SA_SALESINVOICE'),
+       array(  'NewOrder' => 'SA_SALESORDER',
+                       'ModifySalesOrder' => 'SA_SALESORDER',
+                       'NewQuotation' => 'SA_SALESQUOTE',
+                       'ModifyQuotationNumber' => 'SA_SALESQUOTE',
+                       'NewDelivery' => 'SA_SALESDELIVERY',
+                       'NewInvoice' => 'SA_SALESINVOICE')
+);
+
 $js = '';
 
 if ($use_popup_windows) {
@@ -38,24 +53,37 @@ if ($use_date_picker) {
 
 if (isset($_GET['NewDelivery']) && is_numeric($_GET['NewDelivery'])) {
 
-       $_SESSION['page_title'] = _("Direct Sales Delivery");
-       create_cart(13, $_GET['NewDelivery']);
+       $_SESSION['page_title'] = _($help_context = "Direct Sales Delivery");
+       create_cart(ST_CUSTDELIVERY, $_GET['NewDelivery']);
 
 } elseif (isset($_GET['NewInvoice']) && is_numeric($_GET['NewInvoice'])) {
 
-       $_SESSION['page_title'] = _("Direct Sales Invoice");
-       create_cart(10, $_GET['NewInvoice']);
+       $_SESSION['page_title'] = _($help_context = "Direct Sales Invoice");
+       create_cart(ST_SALESINVOICE, $_GET['NewInvoice']);
 
 } elseif (isset($_GET['ModifyOrderNumber']) && is_numeric($_GET['ModifyOrderNumber'])) {
 
-       $help_page_title = _('Modifying Sales Order');
+       $help_context = 'Modifying Sales Order';
        $_SESSION['page_title'] = sprintf( _("Modifying Sales Order # %d"), $_GET['ModifyOrderNumber']);
-       create_cart(30, $_GET['ModifyOrderNumber']);
+       create_cart(ST_SALESORDER, $_GET['ModifyOrderNumber']);
+
+} elseif (isset($_GET['ModifyQuotationNumber']) && is_numeric($_GET['ModifyQuotationNumber'])) {
+
+       $help_context = 'Modifying Sales Quotation';
+       $_SESSION['page_title'] = sprintf( _("Modifying Sales Quotation # %d"), $_GET['ModifyQuotationNumber']);
+       create_cart(ST_SALESQUOTE, $_GET['ModifyQuotationNumber']);
 
 } elseif (isset($_GET['NewOrder'])) {
 
-       $_SESSION['page_title'] = _("New Sales Order Entry");
-       create_cart(30, 0);
+       $_SESSION['page_title'] = _($help_context = "New Sales Order Entry");
+       create_cart(ST_SALESORDER, 0);
+} elseif (isset($_GET['NewQuotation'])) {
+
+       $_SESSION['page_title'] = _($help_context = "New Sales Quotation Entry");
+       create_cart(ST_SALESQUOTE, 0);
+} elseif (isset($_GET['NewQuoteToSalesOrder'])) {
+       $_SESSION['page_title'] = _($help_context = "Sales Order Entry");
+       create_cart(ST_SALESQUOTE, $_GET['NewQuoteToSalesOrder']);
 }
 
 page($_SESSION['page_title'], false, false, "", $js);
@@ -72,10 +100,10 @@ if (isset($_GET['AddedID'])) {
        $order_no = $_GET['AddedID'];
        display_notification_centered(sprintf( _("Order # %d has been entered."),$order_no));
 
-       submenu_view(_("&View This Order"), 30, $order_no);
+       submenu_view(_("&View This Order"), ST_SALESORDER, $order_no);
 
-       submenu_print(_("&Print This Order"), 30, $order_no, 'prtopt');
-       submenu_print(_("&Email This Order"), 30, $order_no, null, 1);
+       submenu_print(_("&Print This Order"), ST_SALESORDER, $order_no, 'prtopt');
+       submenu_print(_("&Email This Order"), ST_SALESORDER, $order_no, null, 1);
        set_focus('prtopt');
        
        submenu_option(_("Make &Delivery Against This Order"),
@@ -90,10 +118,10 @@ if (isset($_GET['AddedID'])) {
 
        display_notification_centered(sprintf( _("Order # %d has been updated."),$order_no));
 
-       submenu_view(_("&View This Order"), 30, $order_no);
+       submenu_view(_("&View This Order"), ST_SALESORDER, $order_no);
 
-       submenu_print(_("&Print This Order"), 30, $order_no, 'prtopt');
-       submenu_print(_("&Email This Order"), 30, $order_no, null, 1);
+       submenu_print(_("&Print This Order"), ST_SALESORDER, $order_no, 'prtopt');
+       submenu_print(_("&Email This Order"), ST_SALESORDER, $order_no, null, 1);
        set_focus('prtopt');
 
        submenu_option(_("Confirm Order Quantities and Make &Delivery"),
@@ -104,18 +132,55 @@ if (isset($_GET['AddedID'])) {
 
        display_footer_exit();
 
+} elseif (isset($_GET['AddedQU'])) {
+       $order_no = $_GET['AddedQU'];
+       display_notification_centered(sprintf( _("Quotation # %d has been entered."),$order_no));
+
+       submenu_view(_("&View This Quotation"), ST_SALESQUOTE, $order_no);
+
+       submenu_print(_("&Print This Quotation"), ST_SALESQUOTE, $order_no, 'prtopt');
+       submenu_print(_("&Email This Quotation"), ST_SALESQUOTE, $order_no, null, 1);
+       set_focus('prtopt');
+       
+       submenu_option(_("Make &Sales Order Against This Quotation"),
+               "/sales/sales_order_entry.php?NewQuoteToSalesOrder=$order_no");
+
+       submenu_option(_("Enter a New &Quotation"),     "/sales/sales_order_entry.php?NewQuotation=0");
+
+       display_footer_exit();
+
+} elseif (isset($_GET['UpdatedQU'])) {
+       $order_no = $_GET['UpdatedQU'];
+
+       display_notification_centered(sprintf( _("Quotation # %d has been updated."),$order_no));
+
+       submenu_view(_("&View This Quotation"), ST_SALESQUOTE, $order_no);
+
+       submenu_print(_("&Print This Quotation"), ST_SALESQUOTE, $order_no, 'prtopt');
+       submenu_print(_("&Email This Quotation"), ST_SALESQUOTE, $order_no, null, 1);
+       set_focus('prtopt');
+
+       submenu_option(_("Make &Sales Order Against This Quotation"),
+               "/sales/sales_order_entry.php?NewQuoteToSalesOrder=$order_no");
+
+       submenu_option(_("Select A Different &Quotation"),
+               "/sales/inquiry/sales_orders_view.php?type=".ST_SALESQUOTE);
+
+       display_footer_exit();
 } elseif (isset($_GET['AddedDN'])) {
        $delivery = $_GET['AddedDN'];
 
        display_notification_centered(sprintf(_("Delivery # %d has been entered."),$delivery));
 
-       submenu_view(_("&View This Delivery"), 13, $delivery);
+       submenu_view(_("&View This Delivery"), ST_CUSTDELIVERY, $delivery);
 
-       submenu_print(_("&Print Delivery Note"), 13, $delivery, 'prtopt');
-       submenu_print(_("&Email Delivery Note"), 13, $delivery, null, 1);
+       submenu_print(_("&Print Delivery Note"), ST_CUSTDELIVERY, $delivery, 'prtopt');
+       submenu_print(_("&Email Delivery Note"), ST_CUSTDELIVERY, $delivery, null, 1);
+       submenu_print(_("P&rint as Packing Slip"), ST_CUSTDELIVERY, $delivery, 'prtopt', null, 1);
+       submenu_print(_("E&mail as Packing Slip"), ST_CUSTDELIVERY, $delivery, null, 1, 1);
        set_focus('prtopt');
 
-       display_note(get_gl_view_str(13, $delivery, _("View the GL Journal Entries for this Dispatch")),0, 1);
+       display_note(get_gl_view_str(ST_CUSTDELIVERY, $delivery, _("View the GL Journal Entries for this Dispatch")),0, 1);
 
        submenu_option(_("Make &Invoice Against This Delivery"),
                "/sales/customer_invoice.php?DeliveryNumber=$delivery");
@@ -134,13 +199,13 @@ if (isset($_GET['AddedID'])) {
 
        display_notification_centered(sprintf(_("Invoice # %d has been entered."), $invoice));
 
-       submenu_view(_("&View This Invoice"), 10, $invoice);
+       submenu_view(_("&View This Invoice"), ST_SALESINVOICE, $invoice);
 
-       submenu_print(_("&Print Sales Invoice"), 10, $invoice, 'prtopt');
-       submenu_print(_("&Email Sales Invoice"), 10, $invoice, null, 1);
+       submenu_print(_("&Print Sales Invoice"), ST_SALESINVOICE, $invoice, 'prtopt');
+       submenu_print(_("&Email Sales Invoice"), ST_SALESINVOICE, $invoice, null, 1);
        set_focus('prtopt');
 
-       display_note(get_gl_view_str(10, $invoice, _("View the GL &Journal Entries for this Invoice")),0, 1);
+       display_note(get_gl_view_str(ST_SALESINVOICE, $invoice, _("View the GL &Journal Entries for this Invoice")),0, 1);
 
        if ((isset($_GET['Type']) && $_GET['Type'] == 1))
                submenu_option(_("Enter a &New Template Invoice"), 
@@ -158,13 +223,12 @@ function copy_to_cart()
 {
        $cart = &$_SESSION['Items'];
 
-       if ($cart->trans_type!=30) {
-               $cart->reference = $_POST['ref'];
-       } 
+       $cart->reference = $_POST['ref'];
+
        $cart->Comments =  $_POST['Comments'];
 
        $cart->document_date = $_POST['OrderDate'];
-       if ($cart->trans_type == 10)
+       if ($cart->trans_type == ST_SALESINVOICE)
                $cart->cash = $_POST['cash']; 
        if ($cart->cash) {
                $cart->due_date = $cart->document_date;
@@ -190,7 +254,7 @@ function copy_to_cart()
        $cart->Branch = $_POST['branch_id'];
        $cart->sales_type = $_POST['sales_type'];
        // POS
-       if ($cart->trans_type!=30) { // 2008-11-12 Joe Hunt
+       if ($cart->trans_type!=ST_SALESORDER && $cart->trans_type!=ST_SALESQUOTE) { // 2008-11-12 Joe Hunt
                $cart->dimension_id = $_POST['dimension_id'];
                $cart->dimension2_id = $_POST['dimension2_id'];
        }       
@@ -201,9 +265,7 @@ function copy_to_cart()
 function copy_from_cart()
 {
        $cart = &$_SESSION['Items'];
-       if ($cart->trans_type!=30) {
-               $_POST['ref'] = $cart->reference;
-       }
+       $_POST['ref'] = $cart->reference;
        $_POST['Comments'] = $cart->Comments;
 
        $_POST['OrderDate'] = $cart->document_date;
@@ -222,9 +284,9 @@ function copy_from_cart()
        $_POST['branch_id'] = $cart->Branch;
        $_POST['sales_type'] = $cart->sales_type;
        // POS 
-       if ($cart->trans_type == 10)
+       if ($cart->trans_type == ST_SALESINVOICE)
                $_POST['cash'] = $cart->cash;
-       if ($cart->trans_type!=30) { // 2008-11-12 Joe Hunt
+       if ($cart->trans_type!=ST_SALESORDER && $cart->trans_type!=ST_SALESQUOTE) { // 2008-11-12 Joe Hunt
                $_POST['dimension_id'] = $cart->dimension_id;
                $_POST['dimension2_id'] = $cart->dimension2_id;
        }       
@@ -242,12 +304,14 @@ function line_start_focus() {
 
 //--------------------------------------------------------------------------------
 function can_process() {
+       global $Refs;
+
        if (!is_date($_POST['OrderDate'])) {
                display_error(_("The entered date is invalid."));
                set_focus('OrderDate');
                return false;
        }
-       if ($_SESSION['Items']->trans_type!=30 && !is_date_in_fiscalyear($_POST['OrderDate'])) {
+       if ($_SESSION['Items']->trans_type!=ST_SALESORDER && $_SESSION['Items']->trans_type!=ST_SALESQUOTE && !is_date_in_fiscalyear($_POST['OrderDate'])) {
                display_error(_("The entered date is not in fiscal year"));
                set_focus('OrderDate');
                return false;
@@ -279,18 +343,24 @@ function can_process() {
                        return false;
                }
                if (!is_date($_POST['delivery_date'])) {
-                       display_error(_("The delivery date is invalid."));
+                       if ($_SESSION['Items']->trans_type==ST_SALESQUOTE)
+                               display_error(_("The Valid date is invalid."));
+                       else    
+                               display_error(_("The delivery date is invalid."));
                        set_focus('delivery_date');
                        return false;
                }
                //if (date1_greater_date2($_SESSION['Items']->document_date, $_POST['delivery_date'])) {
                if (date1_greater_date2($_POST['OrderDate'], $_POST['delivery_date'])) {
-                       display_error(_("The requested delivery date is before the date of the order."));
+                       if ($_SESSION['Items']->trans_type==ST_SALESQUOTE)
+                               display_error(_("The requested valid date is before the date of the quotation."));
+                       else    
+                               display_error(_("The requested delivery date is before the date of the order."));
                        set_focus('delivery_date');
                        return false;
                }
        }
-       if ($_SESSION['Items']->trans_type != 30 && !references::is_valid($_POST['ref'])) {
+       if (!$Refs->is_valid($_POST['ref'])) {
                display_error(_("You must enter a reference."));
                set_focus('ref');
                return false;
@@ -315,20 +385,31 @@ if (isset($_POST['ProcessOrder']) && can_process()) {
        new_doc_date($_SESSION['Items']->document_date);
        processing_end();
        if ($modified) {
-               meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$trans_no");
-       } elseif ($trans_type == 30) {
+               if ($trans_type == ST_SALESQUOTE)
+                       meta_forward($_SERVER['PHP_SELF'], "UpdatedQU=$trans_no");
+               else    
+                       meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$trans_no");
+       } elseif ($trans_type == ST_SALESORDER) {
                meta_forward($_SERVER['PHP_SELF'], "AddedID=$trans_no");
-       } elseif ($trans_type == 10) {
+       } elseif ($trans_type == ST_SALESQUOTE) {
+               meta_forward($_SERVER['PHP_SELF'], "AddedQU=$trans_no");
+       } elseif ($trans_type == ST_SALESINVOICE) {
                meta_forward($_SERVER['PHP_SELF'], "AddedDI=$trans_no&Type=$so_type");
        } else {
                meta_forward($_SERVER['PHP_SELF'], "AddedDN=$trans_no&Type=$so_type");
        }
 }
 
+if (isset($_POST['update'])) {
+       $Ajax->activate('items_table');
+}
+
 //--------------------------------------------------------------------------------
 
 function check_item_data()
 {
+       global $SysPrefs;
+
        if (!check_num('qty', 0) || !check_num('Disc', 0, 100)) {
                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."));
                set_focus('qty');
@@ -344,7 +425,7 @@ function check_item_data()
                display_error(_("You attempting to make the quantity ordered a quantity less than has already been delivered. The quantity delivered cannot be modified retrospectively."));
                return false;
        } // Joe Hunt added 2008-09-22 -------------------------
-       elseif ($_SESSION['Items']->trans_type!=30 && !sys_prefs::allow_negative_stock() &&
+       elseif ($_SESSION['Items']->trans_type!=ST_SALESORDER && $_SESSION['Items']->trans_type!=ST_SALESQUOTE && !$SysPrefs->allow_negative_stock() &&
                is_inventory_item($_POST['stock_id']))
        {
                $qoh = get_qoh_on_date($_POST['stock_id'], $_POST['Location'], $_POST['OrderDate']);
@@ -406,11 +487,11 @@ function  handle_cancel_order()
        global $path_to_root, $Ajax;
 
 
-       if ($_SESSION['Items']->trans_type == 13) {
+       if ($_SESSION['Items']->trans_type == ST_CUSTDELIVERY) {
                display_note(_("Direct delivery entry has been cancelled as requested."), 1);
                submenu_option(_("Enter a New Sales Delivery"), $_SERVER['PHP_SELF']."?NewDelivery=0");
 
-       } elseif ($_SESSION['Items']->trans_type == 10) {
+       } elseif ($_SESSION['Items']->trans_type == ST_SALESINVOICE) {
                display_note(_("Direct invoice entry has been cancelled as requested."), 1);
                submenu_option(_("Enter a New Sales Invoice"),  $_SERVER['PHP_SELF']."?NewInvoice=0");
        } else {
@@ -418,11 +499,18 @@ function  handle_cancel_order()
                        if (sales_order_has_deliveries(key($_SESSION['Items']->trans_no)))
                                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."));
                        else {
-                               delete_sales_order(key($_SESSION['Items']->trans_no));
-
-                       display_note(_("This sales order has been cancelled as requested."), 1);
-                       submenu_option(_("Enter a New Sales Order"), $_SERVER['PHP_SELF']."?NewOrder=Yes");
-                       }
+                               delete_sales_order(key($_SESSION['Items']->trans_no), $_SESSION['Items']->trans_type);
+                               if ($_SESSION['Items']->trans_type == ST_SALESQUOTE)
+                               {
+                                       display_note(_("This sales quotation has been cancelled as requested."), 1);
+                                       submenu_option(_("Enter a New Sales Quotation"), $_SERVER['PHP_SELF']."?NewQuotation=Yes");
+                               }
+                               else
+                               {
+                                       display_note(_("This sales order has been cancelled as requested."), 1);
+                                       submenu_option(_("Enter a New Sales Order"), $_SERVER['PHP_SELF']."?NewOrder=Yes");
+                               }
+                       }       
                } else {
                        processing_end();
                        meta_forward($path_to_root.'/index.php','application=orders');
@@ -439,17 +527,30 @@ function  handle_cancel_order()
 
 function create_cart($type, $trans_no)
 { 
+       global $Refs;
+
        processing_start();
        $doc_type = $type;
 
-       if($type != 30 && $trans_no != 0) { // this is template
-               $doc_type = 30;
+       if (isset($_GET['NewQuoteToSalesOrder']))
+       {
+               $trans_no = $_GET['NewQuoteToSalesOrder'];
+               $doc = new Cart(ST_SALESQUOTE, $trans_no);
+               $doc->trans_no = 0;
+               $doc->trans_type = ST_SALESORDER;
+               $doc->reference = $Refs->get_next($doc->trans_type);
+               $doc->document_date = $doc->due_date = new_doc_date();
+               $doc->Comments = _("Sales Quotation") . " # " . $trans_no;
+               $_SESSION['Items'] = $doc;
+       }       
+       elseif($type != ST_SALESORDER && $type != ST_SALESQUOTE && $trans_no != 0) { // this is template
+               $doc_type = ST_SALESORDER;
 
-               $doc = new Cart(30, array($trans_no));
+               $doc = new Cart(ST_SALESORDER, array($trans_no));
                $doc->trans_type = $type;
                $doc->trans_no = 0;
                $doc->document_date = new_doc_date();
-               if ($type == 10) {
+               if ($type == ST_SALESINVOICE) {
                        $doc->due_date = get_invoice_duedate($doc->customer_id, $doc->document_date);
                        $doc->pos = user_pos();
                        $pos = get_sales_point($doc->pos);
@@ -457,10 +558,10 @@ function create_cart($type, $trans_no)
                        if (!$pos['cash_sale'] || !$pos['credit_sale']) 
                                $doc->pos = -1; // mark not editable payment type
                        else
-                               $doc->cash = date_diff($doc->due_date, Today(), 'd')<2;
+                               $doc->cash = date_diff2($doc->due_date, Today(), 'd')<2;
                } else
                        $doc->due_date = $doc->document_date;
-               $doc->reference = references::get_next($doc->trans_type);
+               $doc->reference = $Refs->get_next($doc->trans_type);
                //$doc->Comments='';
                foreach($doc->line_items as $line_no => $line) {
                        $doc->line_items[$line_no]->qty_done = 0;
@@ -495,18 +596,25 @@ check_db_has_stock_items(_("There are no inventory items defined in the system."
 
 check_db_has_customer_branches(_("There are no customers, or there are no customers with branches. Please define customers and customer branches."));
 
-if ($_SESSION['Items']->trans_type == 10) {
+if ($_SESSION['Items']->trans_type == ST_SALESINVOICE) {
        $idate = _("Invoice Date:");
        $orderitems = _("Sales Invoice Items");
        $deliverydetails = _("Enter Delivery Details and Confirm Invoice");
        $cancelorder = _("Cancel Invoice");
        $porder = _("Place Invoice");
-} elseif ($_SESSION['Items']->trans_type == 13) {
+} elseif ($_SESSION['Items']->trans_type == ST_CUSTDELIVERY) {
        $idate = _("Delivery Date:");
        $orderitems = _("Delivery Note Items");
        $deliverydetails = _("Enter Delivery Details and Confirm Dispatch");
        $cancelorder = _("Cancel Delivery");
        $porder = _("Place Delivery");
+} elseif ($_SESSION['Items']->trans_type == ST_SALESQUOTE) {
+       $idate = _("Quotation Date:");
+       $orderitems = _("Sales Quotation Items");
+       $deliverydetails = _("Enter Delivery Details and Confirm Quotation");
+       $cancelorder = _("Cancel Quotation");
+       $porder = _("Place Quotation");
+       $corder = _("Commit Quotations Changes");
 } else {
        $idate = _("Order Date:");
        $orderitems = _("Sales Order Items");
@@ -536,7 +644,7 @@ if ($customer_error == "") {
 
                submit_center_first('ProcessOrder', $porder,
                    _('Check entered data and save document'), 'default');
-               submit_js_confirm('CancelOrder', _('You are about to void this Sales Order.\nDo you want to continue?'));
+               submit_js_confirm('CancelOrder', _('You are about to void this Document.\nDo you want to continue?'));
        } else {
                submit_center_first('ProcessOrder', $corder,
                    _('Validate changes and update document'), 'default');