. ***********************************************************************/ $page_security = 'SA_SUPPTRANSVIEW'; $path_to_root="../.."; include_once($path_to_root . "/includes/db_pager.inc"); include_once($path_to_root . "/includes/session.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) $js .= get_js_open_window(900, 500); if (user_use_date_picker()) $js .= get_js_date_picker(); page(_($help_context = "Search Purchase Orders"), false, false, "", $js); 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'); } //--------------------------------------------------------------------------------------------- start_form(); start_table(TABLESTYLE_NOBORDER); start_row(); ref_cells(_("#:"), 'order_number', '',null, '', true); date_cells(_("from:"), 'OrdersAfterDate', '', null, -$_SESSION["wa_current_user"]->prefs->transaction_days()); date_cells(_("to:"), 'OrdersToDate'); locations_list_cells(_("into location:"), 'StockLocation', null, true); end_row(); end_table(); start_table(TABLESTYLE_NOBORDER); start_row(); stock_items_list_cells(_("for item:"), 'SelectStockFromList', null, true); if (!@$_GET['popup']) supplier_list_cells(_("Select a supplier: "), 'supplier_id', null, true, true); submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default'); end_row(); end_table(1); //--------------------------------------------------------------------------------------------- function trans_view($trans) { return get_trans_view_str(ST_PURCHORDER, $trans["order_no"]); } function edit_link($row) { global $page_nested; if ($page_nested) return ''; 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); } //--------------------------------------------------------------------------------------------- $sql = get_sql_for_po_search_completed(get_post('OrdersAfterDate'), get_post('OrdersToDate'), @$_GET['popup'] ? ALL_TEXT : get_post('supplier_id'), get_post('StockLocation'), get_post('order_number'), get_post('SelectStockFromList')); $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'), ); if (get_post('StockLocation') != $all_items) { $cols[_("Location")] = 'skip'; } //--------------------------------------------------------------------------------------------------- $table =& new_db_pager('orders_tbl', $sql, $cols); $table->width = "80%"; display_db_pager($table); end_form(); end_page();