X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Finquiry%2Fpo_search.php;h=3f23f5bbad21c219c896130755e53661f8dff380;hb=2a878e547f50149b44bfdd1187179a7df8260d10;hp=e460d53e121ef31745ffd4cdb1d0942e5867cf41;hpb=431531eebf3ba494002cfbf7ea36f9e82d4975c0;p=fa-stable.git diff --git a/purchasing/inquiry/po_search.php b/purchasing/inquiry/po_search.php index e460d53e..3f23f5bb 100644 --- a/purchasing/inquiry/po_search.php +++ b/purchasing/inquiry/po_search.php @@ -1,10 +1,21 @@ . +***********************************************************************/ $page_security = 2; $path_to_root="../.."; +include($path_to_root . "/includes/db_pager.inc"); include($path_to_root . "/includes/session.inc"); include($path_to_root . "/purchasing/includes/purchasing_ui.inc"); +include_once($path_to_root . "/reporting/includes/reporting.inc"); $js = ""; if ($use_popup_windows) @@ -17,6 +28,30 @@ if (isset($_GET['order_number'])) { $_POST['order_number'] = $_GET['order_number']; } +//----------------------------------------------------------------------------------- +// Ajax updates +// +if (get_post('SearchOrders')) +{ + $Ajax->activate('orders_tbl'); +} elseif (get_post('_order_number_changed')) +{ + $disable = get_post('order_number') !== ''; + + $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, 'order_number'); + } else + $Ajax->addFocus(true, 'OrdersAfterDate'); + + $Ajax->activate('orders_tbl'); +} + //--------------------------------------------------------------------------------------------- @@ -24,21 +59,48 @@ start_form(false, true); start_table("class='tablestyle_noborder'"); start_row(); -ref_cells(_("#:"), 'order_number'); +ref_cells(_("#:"), 'order_number', '',null, '', true); -date_cells(_("from:"), 'OrdersAfterDate', null, -30); +date_cells(_("from:"), 'OrdersAfterDate', '', null, -30); date_cells(_("to:"), 'OrdersToDate'); 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); end_row(); end_table(); - end_form(); +//--------------------------------------------------------------------------------------------- +function trans_view($trans) +{ + return get_trans_view_str(systypes::po(), $trans["order_no"]); +} + +function edit_link($row) +{ + return pager_link( _("Edit"), + "/purchasing/po_entry_items.php?" . SID + . "ModifyOrderNumber=" . $row["order_no"], ICON_EDIT); +} + +function prt_link($row) +{ + return print_document_link($row['order_no'], _("Print"), true, 18, ICON_PRINT); +} + +function receive_link($row) +{ + return pager_link( _("Receive"), + "/purchasing/po_receive_items.php?" . SID + . "PONumber=" . $row["order_no"], ICON_RECEIVE); +} +function check_overdue($row) +{ + return $row['OverDue']==1; +} //--------------------------------------------------------------------------------------------- if (isset($_POST['order_number']) && ($_POST['order_number'] != "")) @@ -50,116 +112,92 @@ if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "" ($_POST['SelectStockFromList'] != $all_items)) { $selected_stock_item = $_POST['SelectStockFromList']; -} -else +} +else { unset($selected_stock_item); } -$today = date2sql(Today()); - //figure out the sql required from the inputs available -$sql = "SELECT ".TB_PREF."purch_orders.order_no, ".TB_PREF."suppliers.supp_name, ".TB_PREF."purch_orders.into_stock_location, - ".TB_PREF."purch_orders.ord_date, ".TB_PREF."purch_orders.requisition_no, ".TB_PREF."purch_orders.reference, - ".TB_PREF."suppliers.curr_code, ".TB_PREF."locations.location_name, - Sum(".TB_PREF."purch_order_details.unit_price*".TB_PREF."purch_order_details.quantity_ordered) AS OrderValue, - Sum(".TB_PREF."purch_order_details.delivery_date < '" . $today. "' - AND (".TB_PREF."purch_order_details.quantity_ordered > ".TB_PREF."purch_order_details.quantity_received)) As OverDue - FROM ".TB_PREF."purch_orders, ".TB_PREF."purch_order_details, ".TB_PREF."suppliers, ".TB_PREF."locations - WHERE ".TB_PREF."purch_orders.order_no = ".TB_PREF."purch_order_details.order_no - AND ".TB_PREF."purch_orders.supplier_id = ".TB_PREF."suppliers.supplier_id - AND ".TB_PREF."locations.loc_code = ".TB_PREF."purch_orders.into_stock_location - AND (".TB_PREF."purch_order_details.quantity_ordered > ".TB_PREF."purch_order_details.quantity_received) "; - -if (isset($order_number) && $order_number != "") +$sql = "SELECT + porder.order_no, + porder.reference, + supplier.supp_name, + location.location_name, + porder.requisition_no, + porder.ord_date, + supplier.curr_code, + Sum(line.unit_price*line.quantity_ordered) AS OrderValue, + Sum(line.delivery_date < '". date2sql(Today()) ."' + AND (line.quantity_ordered > line.quantity_received)) As OverDue + FROM " + .TB_PREF."purch_orders as porder, " + .TB_PREF."purch_order_details as line, " + .TB_PREF."suppliers as supplier, " + .TB_PREF."locations as location + WHERE porder.order_no = line.order_no + AND porder.supplier_id = supplier.supplier_id + AND location.loc_code = porder.into_stock_location + AND (line.quantity_ordered > line.quantity_received) "; + +if (isset($order_number) && $order_number != "") { - $sql .= "AND ".TB_PREF."purch_orders.reference LIKE '%". $order_number . "%'"; -} -else + $sql .= "AND porder.reference LIKE '%". $order_number . "%'"; +} +else { - $data_after = date2sql($_POST['OrdersAfterDate']); $data_before = date2sql($_POST['OrdersToDate']); - $sql .= " AND ".TB_PREF."purch_orders.ord_date >= '$data_after'"; - $sql .= " AND ".TB_PREF."purch_orders.ord_date <= '$data_before'"; + $sql .= " AND porder.ord_date >= '$data_after'"; + $sql .= " AND porder.ord_date <= '$data_before'"; - if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items) + if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items) { - $sql .= " AND ".TB_PREF."purch_orders.into_stock_location = '". $_POST['StockLocation'] . "' "; + $sql .= " AND porder.into_stock_location = '". $_POST['StockLocation'] . "' "; } - if (isset($selected_stock_item)) + if (isset($selected_stock_item)) { - $sql .= " AND ".TB_PREF."purch_order_details.item_code='". $selected_stock_item ."' "; + $sql .= " AND line.item_code='". $selected_stock_item ."' "; } } //end not order number selected -$sql .= " GROUP BY ".TB_PREF."purch_orders.order_no"; +$sql .= " GROUP BY porder.order_no"; $result = db_query($sql,"No orders were returned"); /*show a table of the orders returned by the sql */ +$cols = array( + _("#") => array('fun'=>'trans_view', 'ord'=>''), + _("Reference"), + _("Supplier") => array('ord'=>''), + _("Location"), + _("Supplier's Reference"), + _("Order Date") => array('name'=>'ord_date', 'type'=>'date', 'ord'=>'desc'), + _("Currency") => array('align'=>'center'), + _("Order Total") => 'amount', + array('insert'=>true, 'fun'=>'edit_link'), + array('insert'=>true, 'fun'=>'prt_link'), + array('insert'=>true, 'fun'=>'receive_link') +); + +if (get_post('StockLocation') != $all_items) { + $cols[_("Location")] = 'skip'; +} -start_table("$table_style colspan=7 width=80%"); - -if (isset($_POST['StockLocation']) && $_POST['StockLocation'] == $all_items) - $th = array(_("#"), _("Reference"), _("Supplier"), _("Location"), - _("Supplier's Reference"), _("Order Date"), _("Currency"), _("Order Total")); -else - $th = array(_("#"), _("Reference"), _("Supplier"), - _("Supplier's Reference"), _("Order Date"), _("Currency"), _("Order Total")); - -table_header($th); - -$j = 1; -$k = 0; //row colour counter -$overdue_items = false; -while ($myrow = db_fetch($result)) -{ - - if ($myrow["OverDue"] == 1) - { - start_row("class='overduebg'"); - $overdue_items = true; - } - else - { - alt_table_row_color($k); - } +$table =& new_db_pager('orders_tbl', $sql, $cols); +$table->set_marker('check_overdue', _("Marked orders have overdue items.")); - $modify = "$path_to_root/purchasing/po_entry_items.php?" . SID . "ModifyOrderNumber=" . $myrow["order_no"]; - $receive = "$path_to_root/purchasing/po_receive_items.php?" . SID . "PONumber=" . $myrow["order_no"]; - - $date = sql2date($myrow["ord_date"]); - - label_cell(get_trans_view_str(systypes::po(), $myrow["order_no"])); - label_cell($myrow["reference"]); - label_cell($myrow["supp_name"]); - if (isset($_POST['StockLocation']) && $_POST['StockLocation'] == $all_items) - label_cell($myrow["location_name"]); - label_cell($myrow["requisition_no"]); - label_cell($date); - label_cell($myrow["curr_code"]); - amount_cell($myrow["OrderValue"]); - label_cell("" . _("Edit") . ""); - label_cell("" . _("Receive") . ""); - end_row(); - - $j++; - If ($j == 12) - { - $j = 1; - table_header($th); - } -//end of page full new headings if +if (get_post('SearchOrders')) { + $table->set_sql($sql); + $table->set_columns($cols); } -//end of while loop +$table->width = "80%"; +start_form(); -end_table(); - -if ($overdue_items) - display_note(_("Marked orders have overdue items."), 0, 1, "class='overduefg'"); +display_db_pager($table); +end_form(); end_page(); ?>