X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Finquiry%2Fpo_search.php;h=efd650752943570cc799e37c4fe2154021840b2d;hb=97c5e11dd178b2b10edd2b99276b3347470fafc8;hp=3f23f5bbad21c219c896130755e53661f8dff380;hpb=1ff0f43ae7d1c68abde7d1fdd9387934221bad8f;p=fa-stable.git diff --git a/purchasing/inquiry/po_search.php b/purchasing/inquiry/po_search.php index 3f23f5bb..efd65075 100644 --- a/purchasing/inquiry/po_search.php +++ b/purchasing/inquiry/po_search.php @@ -9,8 +9,8 @@ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the License here . ***********************************************************************/ -$page_security = 2; -$path_to_root="../.."; +$page_security = 'SA_SUPPTRANSVIEW'; +$path_to_root = "../.."; include($path_to_root . "/includes/db_pager.inc"); include($path_to_root . "/includes/session.inc"); @@ -18,11 +18,11 @@ include($path_to_root . "/purchasing/includes/purchasing_ui.inc"); include_once($path_to_root . "/reporting/includes/reporting.inc"); $js = ""; -if ($use_popup_windows) +if ($SysPrefs->use_popup_windows) $js .= get_js_open_window(900, 500); -if ($use_date_picker) +if (user_use_date_picker()) $js .= get_js_date_picker(); -page(_("Search Outstanding Purchase Orders"), false, false, "", $js); +page(_($help_context = "Search Outstanding Purchase Orders"), false, false, "", $js); if (isset($_GET['order_number'])) { @@ -55,46 +55,49 @@ if (get_post('SearchOrders')) //--------------------------------------------------------------------------------------------- -start_form(false, true); +start_form(); -start_table("class='tablestyle_noborder'"); +start_table(TABLESTYLE_NOBORDER); start_row(); ref_cells(_("#:"), 'order_number', '',null, '', true); -date_cells(_("from:"), 'OrdersAfterDate', '', null, -30); +date_cells(_("from:"), 'OrdersAfterDate', '', null, -user_transaction_days()); date_cells(_("to:"), 'OrdersToDate'); locations_list_cells(_("Location:"), 'StockLocation', null, true); +end_row(); +end_table(); + +start_table(TABLESTYLE_NOBORDER); +start_row(); stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true); -submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true); +supplier_list_cells(_("Select a supplier: "), 'supplier_id', null, true, true); + +submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default'); end_row(); -end_table(); -end_form(); +end_table(1); //--------------------------------------------------------------------------------------------- function trans_view($trans) { - return get_trans_view_str(systypes::po(), $trans["order_no"]); + return get_trans_view_str(ST_PURCHORDER, $trans["order_no"]); } function edit_link($row) { - return pager_link( _("Edit"), - "/purchasing/po_entry_items.php?" . SID - . "ModifyOrderNumber=" . $row["order_no"], ICON_EDIT); + return trans_editor_link(ST_PURCHORDER, $row["order_no"]); } function prt_link($row) { - return print_document_link($row['order_no'], _("Print"), true, 18, ICON_PRINT); + return print_document_link($row['order_no'], _("Print"), true, ST_PURCHORDER, ICON_PRINT); } function receive_link($row) { return pager_link( _("Receive"), - "/purchasing/po_receive_items.php?" . SID - . "PONumber=" . $row["order_no"], ICON_RECEIVE); + "/purchasing/po_receive_items.php?PONumber=" . $row["order_no"], ICON_RECEIVE); } function check_overdue($row) @@ -103,69 +106,11 @@ function check_overdue($row) } //--------------------------------------------------------------------------------------------- -if (isset($_POST['order_number']) && ($_POST['order_number'] != "")) -{ - $order_number = $_POST['order_number']; -} - -if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "") && - ($_POST['SelectStockFromList'] != $all_items)) -{ - $selected_stock_item = $_POST['SelectStockFromList']; -} -else -{ - unset($selected_stock_item); -} - //figure out the sql required from the inputs available -$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 porder.reference LIKE '%". $order_number . "%'"; -} -else -{ - $data_after = date2sql($_POST['OrdersAfterDate']); - $data_before = date2sql($_POST['OrdersToDate']); +$sql = get_sql_for_po_search(get_post('OrdersAfterDate'), get_post('OrdersToDate'), get_post('supplier_id'), get_post('StockLocation'), + $_POST['order_number'], get_post('SelectStockFromList')); - $sql .= " AND porder.ord_date >= '$data_after'"; - $sql .= " AND porder.ord_date <= '$data_before'"; - - if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items) - { - $sql .= " AND porder.into_stock_location = '". $_POST['StockLocation'] . "' "; - } - - if (isset($selected_stock_item)) - { - $sql .= " AND line.item_code='". $selected_stock_item ."' "; - } -} //end not order number selected - -$sql .= " GROUP BY porder.order_no"; - -$result = db_query($sql,"No orders were returned"); +//$result = db_query($sql,"No orders were returned"); /*show a table of the orders returned by the sql */ $cols = array( @@ -178,26 +123,20 @@ $cols = array( _("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') + array('insert'=>true, 'fun'=>'receive_link'), + array('insert'=>true, 'fun'=>'prt_link') ); -if (get_post('StockLocation') != $all_items) { +if (get_post('StockLocation') != ALL_TEXT) { $cols[_("Location")] = 'skip'; } $table =& new_db_pager('orders_tbl', $sql, $cols); $table->set_marker('check_overdue', _("Marked orders have overdue items.")); -if (get_post('SearchOrders')) { - $table->set_sql($sql); - $table->set_columns($cols); -} $table->width = "80%"; -start_form(); display_db_pager($table); end_form(); end_page(); -?>