X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Finquiry%2Fpo_search_completed.php;h=8c939aba7717cc474867caf8750512813b3b150f;hb=2758ae02d6477d7e6df35f19f44fb08e38900f50;hp=8c18824a8949a18d281f8c59d55d8f1b3bf8529d;hpb=7d866f768b8be95c82ab0664721da9ca09c7604f;p=fa-stable.git diff --git a/purchasing/inquiry/po_search_completed.php b/purchasing/inquiry/po_search_completed.php index 8c18824a..8c939aba 100644 --- a/purchasing/inquiry/po_search_completed.php +++ b/purchasing/inquiry/po_search_completed.php @@ -1,145 +1,135 @@ . +***********************************************************************/ +$page_security = 'SA_SUPPTRANSVIEW'; $path_to_root="../.."; -include($path_to_root . "/includes/session.inc"); +include_once($path_to_root . "/includes/db_pager.inc"); +include_once($path_to_root . "/includes/session.inc"); -include($path_to_root . "/purchasing/includes/purchasing_ui.inc"); +include_once($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 Purchase Orders"), false, false, "", $js); +page(_($help_context = "Search Purchase Orders"), false, false, "", $js); -if (isset($_GET['order_number'])) +//--------------------------------------------------------------------------------------------- +function trans_view($trans) { - $order_number = $_GET['order_number']; + return get_trans_view_str(ST_PURCHORDER, $trans["order_no"]); } -//--------------------------------------------------------------------------------------------- - -start_form(false, true); - -start_table("class='tablestyle_noborder'"); -start_row(); -ref_cells(_("#:"), 'order_number'); - -date_cells(_("from:"), 'OrdersAfterDate', null, -30); -date_cells(_("to:"), 'OrdersToDate'); - -locations_list_cells(_("into location:"), 'StockLocation', null, true); - -stock_items_list_cells(_("for item:"), 'SelectStockFromList', null, true); - -submit_cells('SearchOrders', _("Search")); -end_row(); -end_table(); - -end_form(); +function edit_link($row) +{ + global $page_nested; -//--------------------------------------------------------------------------------------------- + return $page_nested || !$row['isopen'] ? '' : + trans_editor_link(ST_PURCHORDER, $row["order_no"]); +} -if (isset($_POST['order_number'])) +function prt_link($row) { - $order_number = $_POST['order_number']; + return print_document_link($row['order_no'], _("Print"), true, ST_PURCHORDER, ICON_PRINT); } -if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "") && - ($_POST['SelectStockFromList'] != reserved_words::get_all())) +if (isset($_GET['order_number'])) { - $selected_stock_item = $_POST['SelectStockFromList']; + $_POST['order_number'] = $_GET['order_number']; } -else + +//----------------------------------------------------------------------------------- +// Ajax updates +// +if (get_post('SearchOrders')) { - unset($selected_stock_item); -} + $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); -//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.ord_date, ".TB_PREF."purch_orders.into_stock_location, - ".TB_PREF."purch_orders.requisition_no, ".TB_PREF."purch_orders.reference, ".TB_PREF."locations.location_name, - ".TB_PREF."suppliers.curr_code, Sum(".TB_PREF."purch_order_details.unit_price*".TB_PREF."purch_order_details.quantity_ordered) AS OrderValue - 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 "; + if ($disable) { + $Ajax->addFocus(true, 'order_number'); + } else + $Ajax->addFocus(true, 'OrdersAfterDate'); -if (isset($order_number) && $order_number != "") -{ - $sql .= "AND ".TB_PREF."purch_orders.reference LIKE '%". $order_number . "%'"; + $Ajax->activate('orders_tbl'); } -else -{ - - $data_after = date2sql($_POST['OrdersAfterDate']); - $date_before = date2sql($_POST['OrdersToDate']); +//--------------------------------------------------------------------------------------------- - $sql .= " AND ".TB_PREF."purch_orders.ord_date >= '$data_after'"; - $sql .= " AND ".TB_PREF."purch_orders.ord_date <= '$date_before'"; +start_form(); - if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all()) - { - $sql .= " AND ".TB_PREF."purch_orders.into_stock_location = '". $_POST['StockLocation'] . "' "; - } - if (isset($selected_stock_item)) - { - $sql .= " AND ".TB_PREF."purch_order_details.item_code='". $selected_stock_item ."' "; - } +start_table(TABLESTYLE_NOBORDER); +start_row(); +ref_cells(_("#:"), 'order_number', '',null, '', true); -} //end not order number selected +date_cells(_("from:"), 'OrdersAfterDate', '', null, -user_transaction_days()); +date_cells(_("to:"), 'OrdersToDate'); -$sql .= " GROUP BY ".TB_PREF."purch_orders.order_no"; +locations_list_cells(_("into location:"), 'StockLocation', null, true); +end_row(); +end_table(); -$result = db_query($sql,"No orders were returned"); +start_table(TABLESTYLE_NOBORDER); +start_row(); -print_hidden_script(18); +stock_items_list_cells(_("for item:"), 'SelectStockFromList', null, true); -start_table("$table_style colspan=7 width=80%"); +if (!$page_nested) + supplier_list_cells(_("Select a supplier: "), 'supplier_id', null, true, true); -if (isset($_POST['StockLocation']) && $_POST['StockLocation'] == reserved_words::get_all()) - $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"),""); +check_cells(_('Also closed:'), 'also_closed', check_value('also_closed')); -table_header($th); +submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default'); +end_row(); +end_table(1); -$j = 1; -$k = 0; //row colour counter -while ($myrow = db_fetch($result)) -{ +//--------------------------------------------------------------------------------------------- - alt_table_row_color($k); - - $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'] == reserved_words::get_all()) - label_cell($myrow["location_name"]); - label_cell($myrow["requisition_no"]); - label_cell($date); - label_cell($myrow["curr_code"]); - amount_cell($myrow["OrderValue"]); - label_cell(print_document_link($myrow['order_no'], _("Print"))); - end_row(); - - $j++; - if ($j == 12) - { - $j = 1; - table_header($th); - } +$sql = get_sql_for_po_search_completed(get_post('OrdersAfterDate'), get_post('OrdersToDate'), + get_post('supplier_id'), get_post('StockLocation'), get_post('order_number'), + get_post('SelectStockFromList'), get_post('also_closed')); + +$cols = array( + _("#") => array('fun'=>'trans_view', 'ord'=>'', 'align'=>'right'), + _("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'), +); + +if (get_post('StockLocation') != ALL_TEXT) { + $cols[_("Location")] = 'skip'; } -end_table(2); - //--------------------------------------------------------------------------------------------------- +$table =& new_db_pager('orders_tbl', $sql, $cols); + +$table->width = "80%"; + +display_db_pager($table); + +end_form(); end_page(); -?>