Save/retrieve last document date.
[fa-stable.git] / sales / includes / ui / sales_order_ui.inc
index 56926b42a451e930747ec2d204ef29df8978849d..6665f468cf631d1384609d55c8a7bbafdc6edc08 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");
@@ -57,7 +57,7 @@ function add_to_order(&$order, $new_item, $new_item_qty, $price, $discount)
                {
                        if (strcasecmp($order_item->stock_id, $item['stock_id']) == 0)
                        {
-                               display_notification(_("For Part :").$item['stock_id']. " " 
+                               display_warning(_("For Part :").$item['stock_id']. " " 
                                        . _("This item is already on this order. You have been warned."));
                                break;
                        }
@@ -80,7 +80,7 @@ function get_customer_details_to_order(&$order, $customer_id, $branch_id)
        if ($myrow['dissallow_invoices'] == 1)
                $ret_error = _("The selected customer account is currently on hold. Please contact the credit control personnel to discuss.");
 
-       $deliver = $myrow['address']; // in case no delivery address.
+       $deliver = $myrow['address']; // in case no branch address use company address
 
        $order->set_customer($customer_id, $name, $myrow['curr_code'], 
                $myrow['discount'], $myrow['pymt_discount']);
@@ -106,10 +106,9 @@ function get_customer_details_to_order(&$order, $customer_id, $branch_id)
        $order->set_branch($branch_id, $myrow["tax_group_id"],
        $myrow["tax_group_name"], $myrow["phone"], $myrow["email"]);
 
-       $address = $myrow["br_post_address"];
+       $address = trim($myrow["br_post_address"]) != '' ? $myrow["br_post_address"]
+               : (trim($myrow["br_address"]) != '' ? $myrow["br_address"]:$deliver);
 
-       if (strlen($address) <= 1)      // if branch has no address
-               $address = $deliver;    // set sales order address
        $order->set_delivery($myrow["default_ship_via"], $myrow["br_name"],
                $address);
        if ($order->trans_type == 10) {
@@ -168,7 +167,8 @@ function display_order_summary($title, &$order, $editable_items=false)
 
                        view_stock_status_cell($stock_item->stock_id);
 
-                       label_cell($stock_item->item_description, "nowrap" );
+                       //label_cell($stock_item->item_description, "nowrap" );
+                       label_cell($stock_item->item_description );
                        qty_cell($stock_item->qty_dispatched, false, get_qty_dec($stock_item->stock_id));
 
                        if ($order->trans_no!=0)
@@ -214,10 +214,10 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
 {
        global $table_style, $Ajax;
 
-       start_table("width=80% $table_style");
-       echo "<tr><td valign=top>"; // outer table
-       echo "<table>";
+       start_outer_table("width=80% $table_style");
 
+       table_section(1);
+       
        $customer_error = "";
        $change_prices = 0;
 
@@ -245,25 +245,27 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
                customer_branches_list_row(_("Branch:"),
                  $_POST['customer_id'], 'branch_id', null, false, 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;
@@ -286,13 +288,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;
@@ -304,32 +306,33 @@ 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 ($_SESSION['Items']->trans_type!=30) {
+       if ($order->trans_type != 30) {
                ref_cells(_("Reference").':', 'ref', _('Reference number unique for this document type'), null, '');
        }
 
-       echo "</table>";
-
-       echo "</td><td>"; // outer table
-
        if (!is_company_currency($order->customer_currency))
        {
+           table_section(2);
+
            div_start('currency');
-               echo "<table height='5'>";
                label_row(_("Customer Currency:"), $order->customer_currency);
                exchange_rate_display($order->customer_currency, get_company_currency(),
                        ($editable ? $_POST['OrderDate'] : $order->document_date));
-               echo "</table>";
            div_end();
-               echo "</td><td>"; // outer table
        }
+       table_section(3);
 
-
-       echo "<table height='5'>";
        if ($order->trans_type == 10 && $order->pos != -1) {
                sale_payment_list_cells(_('Payment:'), 'cash', null, true);
                $cash_payment = get_post('cash', 0);
@@ -364,21 +367,21 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
        }
 
        label_row(_("Customer Discount:"), ($order->default_discount * 100) . "%");
-       echo "</table>";
-
-       echo "</td><td>"; // outer table
-
-       echo "<table height='5'>";
+       
+       table_section(4);
 
        if ($editable)
        {
                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'])) {
-                       $change_prices = 1;
+                       if (!is_company_currency($order->customer_currency) 
+                               && (get_base_sales_type()>0)) {
+                                       $change_prices = 1;
+                       }
                        $Ajax->activate('currency');
                        if ($order->trans_type == 10) {
                                $_POST['delivery_date'] = get_invoice_duedate(get_post('customer_id'), get_post('OrderDate'));
@@ -410,13 +413,10 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group
        if ($display_tax_group)
        {
            label_row(_("Tax Group:"), $order->tax_group_name);
-           hidden('tax_group_id', $_SESSION['Items']->tax_group_id);
+           hidden('tax_group_id', $order->tax_group_id);
        }
-       echo "</table>";
 
-       echo "</td></tr>";
-
-       end_table(1); // outer table
+       end_outer_table(1); // outer table
 
        if ($change_prices != 0) {
                foreach ($order->line_items as $line_no=>$item) {
@@ -447,10 +447,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
@@ -515,17 +517,17 @@ function display_delivery_details(&$order)
 {
        global $table_style2, $Ajax;
 
-div_start('delivery'); 
+       div_start('delivery');  
 
        if (get_post('cash', 0)) {      // Direct payment sale
                display_heading(_('Cash payment'));
-               echo "<table $table_style2 width=60% align=center>";
+               start_table("$table_style2 width=60%");
                label_row(_("Deliver from Location:"), $order->location_name);
 
                hidden('Location', $order->Location);
                label_row(_("Cash account:"), $order->account_name);
                textarea_row(_("Comments:"), "Comments", $order->Comments, 31, 5);
-               echo "</table>";
+               end_table();
        } else {
 
                if ($order->trans_type==10)
@@ -544,19 +546,16 @@ div_start('delivery');
                        $delname = _("Required Delivery Date").':';
                }
                display_heading($title);
-               echo "<br>";
-               start_table("$table_style2 width=90%");
-               echo "<tr valign=top><td>"; // outer table
-               echo "<table>";
+               start_outer_table("$table_style2 width=90%");
+               table_section(1);
 
                locations_list_row(_("Deliver from Location:"), 'Location', null, 
                        false, true);
                if (list_updated('Location'))
                        check_qoh($order);
-
+//             $_POST['delivery_date'] = get_post('delivery_date', $order->due_date);
                date_row($delname, 'delivery_date',
-                       $order->trans_type==30 ?  _('Enter requested day of delivery') : '', 
-                       $order->due_date, 0, 0, 0);
+                       $order->trans_type==30 ?  _('Enter requested day of delivery') : '');
                text_row(_("Deliver To:"), 'deliver_to', $order->deliver_to, 40, 40,
                        _('Additional identifier for delivery e.g. name of receiving person'));
 
@@ -565,11 +564,7 @@ div_start('delivery');
                text_row(_("Contact Phone Number:"), 'phone', $order->phone, 25, 25,
                    _('Phone number of ordering person. Defaults to branch phone number'));
 
-               echo "</table>";
-
-               echo "</td><td>"; // outer table
-
-               echo "<table>";
+               table_section(2);
 
                text_row(_("Customer Reference:"), 'cust_ref', $order->cust_ref, 25, 25,
                  _('Customer reference number for this order (if any)'));
@@ -579,9 +574,8 @@ div_start('delivery');
                price_format(get_post('freight_cost',0)));
 
                shippers_list_row(_("Shipping Company:"), 'ship_via', $order->ship_via);
-               echo "</table>";
-               echo "</td></tr>";
-               end_table(1); // outer table
+
+               end_outer_table(1);
        }
        div_end();
 }
@@ -590,6 +584,7 @@ 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 . ": " .