Single quotes encoded before database data insert.
[fa-stable.git] / sales / includes / ui / sales_order_ui.inc
index 1349bdb43468e0e0e051d20180f3cc474b8d814e..5ec8dfcb1d22a06769c527efd1f46ba6196f0fe0 100644 (file)
@@ -1,13 +1,13 @@
 <?php
 /**********************************************************************
     Copyright (C) FrontAccounting, LLC.
-       Released under the terms of the GNU Affero General Public License,
-       AGPL, as published by the Free Software Foundation, either version 
-       of the License, or (at your option) any later version.
+       Released under the terms of the GNU General Public License, GPL, 
+       as published by the Free Software Foundation, either version 3 
+       of the License, or (at your option) any later version.
     This program is distributed in the hope that it will be useful,
     but WITHOUT ANY WARRANTY; without even the implied warranty of
     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
-    See the License here <http://www.gnu.org/licenses/agpl-3.0.html>.
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
 include_once($path_to_root . "/sales/includes/cart_class.inc");
 include_once($path_to_root . "/includes/manufacturing.inc");
@@ -58,7 +58,7 @@ function add_to_order(&$order, $new_item, $new_item_qty, $price, $discount)
                        if (strcasecmp($order_item->stock_id, $item['stock_id']) == 0)
                        {
                                display_warning(_("For Part :").$item['stock_id']. " " 
-                                       . _("This item is already on this order. You have been warned."));
+                                       . _("This item is already on this document. You have been warned."));
                                break;
                        }
                }
@@ -89,7 +89,7 @@ function get_customer_details_to_order(&$order, $customer_id, $branch_id)
        $order->set_sales_type($myrow['salestype'], $myrow['sales_type'], $myrow['tax_included'],
            $myrow['factor']);
 
-       if ($order->trans_type != 30)
+       if ($order->trans_type != ST_SALESORDER && $order->trans_type != ST_SALESQUOTE)
        {
                $order->dimension_id = $myrow['dimension_id'];
                $order->dimension2_id = $myrow['dimension2_id'];
@@ -111,10 +111,10 @@ function get_customer_details_to_order(&$order, $customer_id, $branch_id)
 
        $order->set_delivery($myrow["default_ship_via"], $myrow["br_name"],
                $address);
-       if ($order->trans_type == 10) {
+       if ($order->trans_type == ST_SALESINVOICE) {
                $order->due_date = get_invoice_duedate($customer_id, $order->document_date);
                if ($order->pos != -1)
-                       $order->cash = date_diff($order->due_date, Today(), 'd')<2;
+                       $order->cash = date_diff2($order->due_date, Today(), 'd')<2;
        }
        if($order->cash ) {
                if($order->pos != -1) {
@@ -131,7 +131,7 @@ function get_customer_details_to_order(&$order, $customer_id, $branch_id)
 
 function display_order_summary($title, &$order, $editable_items=false)
 {
-       global $table_style, $path_to_root;
+       global $table_style, $path_to_root, $SysPrefs;
 
        display_heading($title);
 
@@ -154,24 +154,42 @@ function display_order_summary($title, &$order, $editable_items=false)
        $k = 0;  //row colour counter
 
        $id = find_submit('Edit');
+       $has_marked = false;
        foreach ($order->line_items as $line_no=>$stock_item)
        {
 
                $line_total = round($stock_item->qty_dispatched * $stock_item->price * (1 - $stock_item->discount_percent),
                   user_price_dec());
 
-
+               $qoh_msg = '';
                if (!$editable_items || $id != $line_no)
                {
-                       alt_table_row_color($k);
+                       if (!$SysPrefs->allow_negative_stock() && is_inventory_item($stock_item->stock_id)) {
+                               $qoh = get_qoh_on_date($stock_item->stock_id, 
+                                       $_POST['Location'], $_POST['OrderDate']);
+                               if ($stock_item->qty_dispatched > $qoh) 
+                               {
+                                       // oops, we don't have enough of one of the component items
+                                       start_row("class='stockmankobg'");
+                                       $qoh_msg .= $stock_item->stock_id . " - " . $stock_item->item_description . ": " .
+                                       _("Quantity On Hand") . " = " 
+                                       . number_format2($qoh, get_qty_dec($stock_item->stock_id)) . '<br>';
+                                       $has_marked = true;
+                                } else 
+                                       alt_table_row_color($k);
+                       } else {
+                               alt_table_row_color($k);
+                       }
 
                        view_stock_status_cell($stock_item->stock_id);
 
-                       label_cell($stock_item->item_description, "nowrap" );
-                       qty_cell($stock_item->qty_dispatched, false, get_qty_dec($stock_item->stock_id));
+                       //label_cell($stock_item->item_description, "nowrap" );
+                       label_cell($stock_item->item_description );
+                       $dec = get_qty_dec($stock_item->stock_id);
+                       qty_cell($stock_item->qty_dispatched, false, $dec);
 
                        if ($order->trans_no!=0)
-                               amount_cell($stock_item->qty_done);
+                               qty_cell($stock_item->qty_done, false, $dec);
 
                        label_cell($stock_item->units);
                        amount_cell($stock_item->price);
@@ -204,6 +222,12 @@ function display_order_summary($title, &$order, $editable_items=false)
                "nowrap align=right", 2);
 
        end_table();
+       if ($has_marked) {
+               display_note(_("Marked items have insufficient quantities in stock as on day of delivery."), 0, 1, "class='stockmankofg'");
+               if ($order->trans_type!=30 && !$SysPrefs->allow_negative_stock())
+                       display_error(_("The delivery cannot be processed because there is an insufficient quantity for item:")
+                               . '<br>'. $qoh_msg);
+       }
     div_end();
 }
 
@@ -211,7 +235,7 @@ function display_order_summary($title, &$order, $editable_items=false)
 
 function display_order_header(&$order, $editable, $date_text, $display_tax_group=false)
 {
-       global $table_style, $Ajax;
+       global $table_style, $Ajax, $SysPrefs;
 
        start_outer_table("width=80% $table_style");
 
@@ -223,18 +247,19 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
        if (isset($order) && !$editable)
        {
                // can't change the customer/branch if items already received on this order
-               echo $order->customer_name . " - " . $order->deliver_to;
+               //echo $order->customer_name . " - " . $order->deliver_to;
+               label_row(null, $order->customer_name . " - " . $order->deliver_to);
                hidden('customer_id', $order->customer_id);
                hidden('branch_id', $order->Branch);
                hidden('sales_type', $order->sales_type);
-               if ($order->trans_type != 30) {
+               if ($order->trans_type != ST_SALESORDER  && $order->trans_type != ST_SALESQUOTE) {
                        hidden('dimension_id', $order->dimension_id); // 2008-11-12 Joe Hunt
                        hidden('dimension2_id', $order->dimension2_id);
                }       
        }
        else
        {
-               customer_list_row(_("Customer:"), 'customer_id', null, false, true);
+               customer_list_row(_("Customer:"), 'customer_id', null, false, true, false, true);
 
                if ($order->customer_id != get_post('customer_id', -1))
                {
@@ -242,27 +267,29 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
                        $Ajax->activate('branch_id');
                }
                customer_branches_list_row(_("Branch:"),
-                 $_POST['customer_id'], 'branch_id', null, false, true, true);
+                 $_POST['customer_id'], 'branch_id', null, false, true, true, true);
 
-       if( ($order->customer_id != get_post('customer_id', -1)) ||
+               if( ($order->customer_id != get_post('customer_id', -1)) ||
                        ($order->Branch != get_post('branch_id', -1)) ||
-                       list_updated('customer_id')) {
-
-               if (!isset($_POST['branch_id']) || $_POST['branch_id'] == "")
+                       list_updated('customer_id')) 
                {
-                       // ignore errors on customer search box call
-                       if ($_POST['customer_id'] == '')
-                           $customer_error = _("No customer found for entered text.");
+
+                       if (!isset($_POST['branch_id']) || $_POST['branch_id'] == "")
+                       {
+                               // ignore errors on customer search box call
+                               if ($_POST['customer_id'] == '')
+                                       $customer_error = _("No customer found for entered text.");
+                               else
+                                       $customer_error = _("The selected customer does not have any branches. Please create at least one branch.");
+                               unset($_POST['branch_id']);
+                               $order->Branch = 0;
+                       } 
                        else
-                           $customer_error = _("The selected customer does not have any branches. Please create at least one branch.");
-                   unset($_POST['branch_id']);
-                   $order->Branch = 0;
-               } else
-               {
+                       {
 
                                $old_order = (PHP_VERSION<5) ? $order : clone( $order );
-                               $customer_error = get_customer_details_to_order($order, $_POST['customer_id'], $_POST['branch_id']);
 
+                               $customer_error = get_customer_details_to_order($order, $_POST['customer_id'], $_POST['branch_id']);
                                $_POST['Location'] = $order->Location;
                                $_POST['deliver_to'] = $order->deliver_to;
                                $_POST['delivery_address'] = $order->delivery_address;
@@ -272,7 +299,7 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
                                        $Ajax->activate('delivery');
                                        $Ajax->activate('cash');
                                } else {
-                                       if ($order->trans_type == 10)
+                                       if ($order->trans_type == ST_SALESINVOICE)
                                        {
                                                $_POST['delivery_date'] = $order->due_date;
                                                $Ajax->activate('delivery_date');
@@ -285,13 +312,13 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
                                // change prices if necessary
                                // what about discount in template case?
                                if ($old_order->customer_currency != $order->customer_currency) {
-                                   $change_prices = 1;
+                                       $change_prices = 1;
                                }
                                if ($old_order->sales_type != $order->sales_type) {
                                //  || $old_order->default_discount!=$order->default_discount
                                        $_POST['sales_type'] = $order->sales_type;
-                                   $Ajax->activate('sales_type');
-                                   $change_prices = 1;
+                                       $Ajax->activate('sales_type');
+                                       $change_prices = 1;
                                }
                                if ($old_order->dimension_id != $order->dimension_id) {
                                        $_POST['dimension_id'] = $order->dimension_id;
@@ -303,27 +330,30 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
                                }
                                unset($old_order);
                        }
-               set_global_customer($_POST['customer_id']);
+                       set_global_customer($_POST['customer_id']);
                } // changed branch
+               else
+               {
+                       $row = get_customer_to_order($_POST['customer_id']);
+                       if ($row['dissallow_invoices'] == 1)
+                               $customer_error = _("The selected customer account is currently on hold. Please contact the credit control personnel to discuss.");
+               
+               }
        }
 
-       if ($order->trans_type != 30) {
-               ref_cells(_("Reference").':', 'ref', _('Reference number unique for this document type'), null, '');
-       }
+       ref_cells(_("Reference").':', 'ref', _('Reference number unique for this document type'), null, '');
 
        if (!is_company_currency($order->customer_currency))
        {
            table_section(2);
 
-           div_start('currency');
                label_row(_("Customer Currency:"), $order->customer_currency);
                exchange_rate_display($order->customer_currency, get_company_currency(),
                        ($editable ? $_POST['OrderDate'] : $order->document_date));
-           div_end();
        }
        table_section(3);
 
-       if ($order->trans_type == 10 && $order->pos != -1) {
+       if ($order->trans_type == ST_SALESINVOICE && $order->pos != -1) {
                sale_payment_list_cells(_('Payment:'), 'cash', null, true);
                $cash_payment = get_post('cash', 0);
                // current user can issue both credit and cash invoices
@@ -336,7 +366,7 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
                                $_POST['Location'] = $order->Location = $paym['pos_location'];
                                $order->location_name = $paym['location_name'];
                        }
-                       check_qoh($order);
+                       $Ajax->activate('items_table');
                        $Ajax->activate('delivery');
                        set_focus($order->pos == -1 ? 'delivery_date' : 'account');
                }
@@ -365,21 +395,22 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
                if (!isset($_POST['OrderDate']) || $_POST['OrderDate'] == "")
                        $_POST['OrderDate'] = $order->document_date;
 
-               date_row($date_text, 'OrderDate',
-                 _('Date of order receive'), null, 0, 0, 0, null, true);
+               date_row($date_text, 'OrderDate', _('Date of order receive'),
+                       $order->trans_no==0, 0, 0, 0, null, true);
                if (isset($_POST['_OrderDate_changed'])) {
                        if (!is_company_currency($order->customer_currency) 
                                && (get_base_sales_type()>0)) {
                                        $change_prices = 1;
                        }
-                       $Ajax->activate('currency');
-                       if ($order->trans_type == 10) {
+                       $Ajax->activate('_ex_rate');
+                       if ($order->trans_type == ST_SALESINVOICE) {
                                $_POST['delivery_date'] = get_invoice_duedate(get_post('customer_id'), get_post('OrderDate'));
                        } else 
-                               $_POST['delivery_date'] = add_days(get_post('OrderDate'), sys_prefs::default_delivery_required_by());
+                               $_POST['delivery_date'] = add_days(get_post('OrderDate'), $SysPrefs->default_delivery_required_by());
+                       $Ajax->activate('items_table');
                        $Ajax->activate('delivery_date');
                }
-               if ($order->trans_type != 30)
+               if ($order->trans_type != ST_SALESORDER && $order->trans_type != ST_SALESQUOTE)
                {       // 2008-11-12 Joe Hunt added dimensions
                        $dim = get_company_pref('use_dimension');
                        if ($dim > 0)
@@ -437,10 +468,12 @@ function sales_order_item_controls(&$order, &$rowcounter, $line_no=-1)
                $_POST['qty'] = number_format2($order->line_items[$id]->qty_dispatched, $dec);
                $_POST['price'] = price_format($order->line_items[$id]->price);
                $_POST['Disc'] = percent_format($order->line_items[$id]->discount_percent*100);
+               $_POST['item_description'] = $order->line_items[$id]->item_description;
                $units = $order->line_items[$id]->units;
                hidden('stock_id', $_POST['stock_id']);
                label_cell($_POST['stock_id']);
-               label_cell($order->line_items[$line_no]->item_description, "nowrap");
+               text_cells(null,'item_description', null, 45, 150);
+               //label_cell($order->line_items[$line_no]->item_description, "nowrap");
            $Ajax->activate('items_table');
        }
        else    // prepare new line
@@ -508,6 +541,7 @@ function display_delivery_details(&$order)
        div_start('delivery');  
 
        if (get_post('cash', 0)) {      // Direct payment sale
+               $Ajax->activate('items_table');
                display_heading(_('Cash payment'));
                start_table("$table_style2 width=60%");
                label_row(_("Deliver from Location:"), $order->location_name);
@@ -518,16 +552,21 @@ function display_delivery_details(&$order)
                end_table();
        } else {
 
-               if ($order->trans_type==10)
+               if ($order->trans_type==ST_SALESINVOICE)
                {
                        $title = _("Delivery Details");
                        $delname = _("Due Date").':';
                }
-               elseif ($order->trans_type==13)
+               elseif ($order->trans_type==ST_CUSTDELIVERY)
                {
                        $title = _("Invoice Delivery Details");
                        $delname = _("Invoice before").':';
                }
+               elseif ($order->trans_type==ST_SALESQUOTE)
+               {
+                       $title = _("Quotation Delivery Details");
+                       $delname = _("Valid until").':';
+               }
                else
                {
                        $title = _("Order Delivery Details");
@@ -540,11 +579,11 @@ function display_delivery_details(&$order)
                locations_list_row(_("Deliver from Location:"), 'Location', null, 
                        false, true);
                if (list_updated('Location'))
-                       check_qoh($order);
+                       $Ajax->activate('items_table');
+
 
                date_row($delname, 'delivery_date',
-                       $order->trans_type==30 ?  _('Enter requested day of delivery') : '', 
-                       $order->due_date, 0, 0, 0);
+                       $order->trans_type==ST_SALESORDER ?  _('Enter requested day of delivery') : $order->trans_type==ST_SALESQUOTE ? _('Enter Valid until Date') : '');
                text_row(_("Deliver To:"), 'deliver_to', $order->deliver_to, 40, 40,
                        _('Additional identifier for delivery e.g. name of receiving person'));
 
@@ -569,23 +608,4 @@ function display_delivery_details(&$order)
        div_end();
 }
 
-function check_qoh($order) 
-{
-       $msg = '';
-       foreach($order->line_items as $line_no => $line) {
-               if (!is_inventory_item($line['stock_id'])) continue;
-               $qoh = get_qoh_on_date($line->stock_id, $_POST['Location'], $_POST['OrderDate']);
-               if ($line->qty_dispatched > $qoh)       {
-                       $msg .= $line->stock_id . " - " . $line->item_description . ": " .
-                               _("Quantity On Hand") . " = " 
-                               . number_format2($qoh, get_qty_dec($line->stock_id)) . '<br>';
-               }
-       }
-       if (strlen($msg)) {
-               display_error(_("The delivery cannot be processed because there is an insufficient quantity for item:")
-                       . '<br>'. $msg);
-               return false;
-       }
-       return true;
-}
 ?>
\ No newline at end of file