X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fsales_orders_view.php;h=e797863cb4ddb8e90823246ad1610e30f1ff35c4;hb=74dc09864f66962353e8a1dbb7fa174cc084cbe8;hp=b5af5158fdf6123cac64536a5ffcd5b2896943a9;hpb=0c1bcd8ce3c089d7ddb3722a097f8fc8417f41e6;p=fa-stable.git diff --git a/sales/inquiry/sales_orders_view.php b/sales/inquiry/sales_orders_view.php index b5af5158..e797863c 100644 --- a/sales/inquiry/sales_orders_view.php +++ b/sales/inquiry/sales_orders_view.php @@ -5,6 +5,7 @@ $path_to_root="../.."; include($path_to_root . "/includes/session.inc"); include($path_to_root . "/sales/includes/sales_ui.inc"); +include_once($path_to_root . "/reporting/includes/reporting.inc"); $js = ""; if ($use_popup_windows) @@ -12,17 +13,17 @@ if ($use_popup_windows) if ($use_date_picker) $js .= get_js_date_picker(); -if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true)) +if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true)) { $_POST['order_view_mode'] = 'OutstandingOnly'; $_SESSION['page_title'] = _("Search Outstanding Sales Orders"); -} -elseif (isset($_GET['InvoiceTemplates']) && ($_GET['InvoiceTemplates'] == true)) +} +elseif (isset($_GET['InvoiceTemplates']) && ($_GET['InvoiceTemplates'] == true)) { $_POST['order_view_mode'] = 'InvoiceTemplates'; $_SESSION['page_title'] = _("Search Template for Invoicing"); -} -elseif (isset($_GET['DeliveryTemplates']) && ($_GET['DeliveryTemplates'] == true)) +} +elseif (isset($_GET['DeliveryTemplates']) && ($_GET['DeliveryTemplates'] == true)) { $_POST['order_view_mode'] = 'DeliveryTemplates'; $_SESSION['page_title'] = _("Select Template for Delivery"); @@ -38,46 +39,56 @@ page($_SESSION['page_title'], false, false, "", $js); if (isset($_GET['selected_customer'])) { $selected_customer = $_GET['selected_customer']; -} +} elseif (isset($_POST['selected_customer'])) { $selected_customer = $_POST['selected_customer']; } else $selected_customer = -1; - -//----------------------------------------------------------------------------------- -/* -$action = $_SERVER['PHP_SELF']; -if ($_POST['order_view_mode']=='OutstandingOnly') -{ - $action .= "?OutstandingOnly=" . $_POST['order_view_mode']$_PO; -} -elseif ($_POST['order_view_mode']=='InvoiceTemplates') +//----------------------------------------------------------------------------------- +// Ajax updates +// +if (get_post('SearchOrders')) { - $action .= "?InvoiceTemplates=" . $_POST['InvoiceTemplates']; -} -elseif ($_POST['order_view_mode']=='DeliveryTemplates') + $Ajax->activate('orders_tbl'); +} elseif (get_post('_OrderNumber_changed')) { - $action .= "?DeliveryTemplates=" . $_POST['InvoiceTemplates']; + $disable = get_post('OrderNumber') !== ''; + + if ($_POST['order_view_mode']!='DeliveryTemplates' + && $_POST['order_view_mode']!='InvoiceTemplates') { + $Ajax->addDisable(true, 'OrdersAfterDate', $disable); + $Ajax->addDisable(true, 'OrdersToDate', $disable); + } + $Ajax->addDisable(true, 'StockLocation', $disable); + $Ajax->addDisable(true, '_SelectStockFromList_edit', $disable); + $Ajax->addDisable(true, 'SelectStockFromList', $disable); + + if ($disable) { + $Ajax->addFocus(true, 'OrderNumber'); + } else + $Ajax->addFocus(true, 'OrdersAfterDate'); + + $Ajax->activate('orders_tbl'); } -*/ + start_form(false, false, $_SERVER['PHP_SELF'] .SID); start_table("class='tablestyle_noborder'"); start_row(); -ref_cells(_("#:"), 'OrderNumber'); -if ($_POST['order_view_mode']!='DeliveryTemplates' && $_POST['order_view_mode']!='InvoiceTemplates') +ref_cells(_("#:"), 'OrderNumber', '',null, '', true); +if ($_POST['order_view_mode'] != 'DeliveryTemplates' && $_POST['order_view_mode'] != 'InvoiceTemplates') { - date_cells(_("from:"), 'OrdersAfterDate', null, -30); - date_cells(_("to:"), 'OrdersToDate', null, 1); + date_cells(_("from:"), 'OrdersAfterDate', '', null, -30); + date_cells(_("to:"), 'OrdersToDate', '', null, 1); } locations_list_cells(_("Location:"), 'StockLocation', null, true); stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true); -submit_cells('SearchOrders', _("Search")); +submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true); hidden('order_view_mode', $_POST['order_view_mode']); @@ -92,17 +103,19 @@ if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "" ($_POST['SelectStockFromList'] != reserved_words::get_all())) { $selected_stock_item = $_POST['SelectStockFromList']; -} -else +} +else { unset($selected_stock_item); } //--------------------------------------------------------------------------------------------- -if (isset($_POST['ChangeTmpl']) && $_POST['ChangeTmpl']!=0) { - $sql = "UPDATE ".TB_PREF."sales_orders SET type = !type WHERE order_no=".$_POST['ChangeTmpl']; +if (isset($_POST['ChangeTmpl']) && $_POST['ChangeTmpl'] != 0) +{ + $sql = "UPDATE ".TB_PREF."sales_orders SET type = !type WHERE order_no=".$_POST['ChangeTmpl']; - db_query($sql, "Can't change sales order type"); + db_query($sql, "Can't change sales order type"); + $Ajax->activate('orders_tbl'); } //--------------------------------------------------------------------------------------------- @@ -117,7 +130,7 @@ $sql .= " Sum(".TB_PREF."sales_order_details.unit_price*".TB_PREF."sales_order_d $sql .= TB_PREF."sales_orders.comments, "; //else $sql .= TB_PREF."sales_orders.customer_ref"; - + $sql .= " FROM ".TB_PREF."sales_orders, ".TB_PREF."sales_order_details, ".TB_PREF."debtors_master, ".TB_PREF."cust_branch WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no AND ".TB_PREF."sales_orders.debtor_no = ".TB_PREF."debtors_master.debtor_no @@ -125,20 +138,22 @@ $sql .= " FROM ".TB_PREF."sales_orders, ".TB_PREF."sales_order_details, ".TB_PRE AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."cust_branch.debtor_no "; //figure out the sql required from the inputs available -if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "") +if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "") { - $sql .= " AND ".TB_PREF."sales_orders.order_no LIKE '%". $_POST['OrderNumber'] ."' GROUP BY ".TB_PREF."sales_orders.order_no"; -} -else +// if ($_POST['OrderNumber'] != '*') // TODO paged table + $sql .= " AND ".TB_PREF."sales_orders.order_no LIKE '%". $_POST['OrderNumber'] ."'"; + $sql .= " GROUP BY ".TB_PREF."sales_orders.order_no"; +} +else { - if ($_POST['order_view_mode']!='DeliveryTemplates' && $_POST['order_view_mode']!='InvoiceTemplates') - { - $date_after = date2sql($_POST['OrdersAfterDate']); - $date_before = date2sql($_POST['OrdersToDate']); - - $sql .= " AND ".TB_PREF."sales_orders.ord_date >= '$date_after'"; - $sql .= " AND ".TB_PREF."sales_orders.ord_date <= '$date_before'"; - } + if ($_POST['order_view_mode']!='DeliveryTemplates' && $_POST['order_view_mode']!='InvoiceTemplates') + { + $date_after = date2sql($_POST['OrdersAfterDate']); + $date_before = date2sql($_POST['OrdersToDate']); + + $sql .= " AND ".TB_PREF."sales_orders.ord_date >= '$date_after'"; + $sql .= " AND ".TB_PREF."sales_orders.ord_date <= '$date_before'"; + } if ($selected_customer != -1) $sql .= " AND ".TB_PREF."sales_orders.debtor_no='" . $selected_customer . "'"; @@ -157,34 +172,35 @@ else ".TB_PREF."sales_orders.customer_ref, ".TB_PREF."sales_orders.ord_date, ".TB_PREF."sales_orders.deliver_to"; } //end not order number selected - $result = db_query($sql,"No orders were returned"); - //----------------------------------------------------------------------------------- - -if ($result) +if ($result) { + print_hidden_script(30); + start_form(); /*show a table of the orders returned by the sql */ + div_start('orders_tbl'); start_table("$table_style colspan=6 width=95%"); $th = array(_("Order #"), _("Customer"), _("Branch"), _("Cust Order #"), _("Order Date"), - _("Required By"), _("Delivery To"), _("Order Total"), _("Currency"), _("Tmpl"),""); + _("Required By"), _("Delivery To"), _("Order Total"), _("Currency"), ""); if($_POST['order_view_mode']=='InvoiceTemplates' || $_POST['order_view_mode']=='DeliveryTemplates') { $th[3] = _('Description'); - } + } elseif ($_POST['order_view_mode'] != 'OutstandingOnly') { + $th[9] = _('Tmpl'); + $th[] =''; $th[] =''; + } table_header($th); -start_form(); $j = 1; $k = 0; //row colour counter $overdue_items = false; - while ($myrow = db_fetch($result)) + while ($myrow = db_fetch($result)) { - $view_page = get_customer_trans_view_str(systypes::sales_order(), $myrow["order_no"]); $formated_del_date = sql2date($myrow["delivery_date"]); $formated_order_date = sql2date($myrow["ord_date"]); @@ -195,8 +211,8 @@ start_form(); { start_row("class='overduebg'"); $overdue_items = true; - } - else + } + else { alt_table_row_color($k); } @@ -204,16 +220,16 @@ start_form(); label_cell($view_page); label_cell($myrow["name"]); label_cell($myrow["br_name"]); - if($_POST['order_view_mode']=='InvoiceTemplates' || $_POST['order_view_mode']=='DeliveryTemplates') - label_cell($myrow["comments"]); - else - label_cell($myrow["customer_ref"]); + if($_POST['order_view_mode']=='InvoiceTemplates' || $_POST['order_view_mode']=='DeliveryTemplates') + label_cell($myrow["comments"]); + else + label_cell($myrow["customer_ref"]); label_cell($formated_order_date); label_cell($formated_del_date); label_cell($myrow["deliver_to"]); amount_cell($myrow["OrderValue"]); label_cell($myrow["curr_code"]); - if ($_POST['order_view_mode']=='OutstandingOnly'/* || $not_closed*/) + if ($_POST['order_view_mode']=='OutstandingOnly'/* || $not_closed*/) { $delivery_note = $path_to_root . "/sales/customer_delivery.php?" . SID . "OrderNumber=" .$myrow["order_no"]; label_cell("" . _("Dispatch") . ""); @@ -230,17 +246,18 @@ start_form(); } else { - echo ""; + echo ""; - $modify_page = $path_to_root . "/sales/sales_order_entry.php?" . SID . "ModifyOrderNumber=" . $myrow["order_no"]; - label_cell("" . _("Edit") . ""); + $modify_page = $path_to_root . "/sales/sales_order_entry.php?" . SID . "ModifyOrderNumber=" . $myrow["order_no"]; + label_cell("" . _("Edit") . ""); + label_cell(print_document_link($myrow['order_no'], _("Print"))); } end_row();; $j++; - If ($j == 12) + if ($j == 12) { $j = 1; table_header($th); @@ -248,15 +265,15 @@ start_form(); //end of page full new headings if } //end of while loop - hidden('ChangeTmpl', 0); -end_form(); + hidden('ChangeTmpl', 0); end_table(); if ($overdue_items) display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'"); + div_end(); + end_form(); } echo "
"; - end_page(); ?> \ No newline at end of file