X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Finquiry%2Fstock_movements.php;h=e7fb0eed31d893b157e62dd5d99ef286dc6a5140;hb=bd8f517d30d1edd3261e26e582ddd9e11c555616;hp=1dd1382733810d280c45e26ea2db506279e8ff2d;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git diff --git a/inventory/inquiry/stock_movements.php b/inventory/inquiry/stock_movements.php index 1dd13827..e7fb0eed 100644 --- a/inventory/inquiry/stock_movements.php +++ b/inventory/inquiry/stock_movements.php @@ -19,12 +19,11 @@ include_once($path_to_root . "/sales/includes/sales_db.inc"); include_once($path_to_root . "/includes/ui.inc"); $js = ""; -if ($use_popup_windows) +if ($SysPrefs->use_popup_windows) $js .= get_js_open_window(800, 500); -if ($use_date_picker) +if (user_use_date_picker()) $js .= get_js_date_picker(); - -page(_($help_context = "Inventory Item Movement"), false, false, "", $js); +page(_($help_context = "Inventory Item Movement"), @$_GET['popup'], false, "", $js); //------------------------------------------------------------------------------------------------ check_db_has_stock_items(_("There are no items defined in the system.")); @@ -46,35 +45,40 @@ if (!isset($_POST['stock_id'])) start_table(TABLESTYLE_NOBORDER); start_row(); -stock_items_list_cells(_("Item:"), 'stock_id', $_POST['stock_id']); +if (!$page_nested) + stock_costable_items_list_cells(_("Item:"), 'stock_id', $_POST['stock_id']); end_row(); end_table(); start_table(TABLESTYLE_NOBORDER); start_row(); -locations_list_cells(_("From Location:"), 'StockLocation', null); +locations_list_cells(_("From Location:"), 'StockLocation', null, true); -date_cells(_("From:"), 'AfterDate', '', null, -30); +date_cells(_("From:"), 'AfterDate', '', null, -user_transaction_days()); date_cells(_("To:"), 'BeforeDate'); submit_cells('ShowMoves',_("Show Movements"),'',_('Refresh Inquiry'), 'default'); end_row(); end_table(); -end_form(); +if (!@$_GET['popup']) + end_form(); set_global_stock_item($_POST['stock_id']); $before_date = date2sql($_POST['BeforeDate']); $after_date = date2sql($_POST['AfterDate']); +$display_location = !$_POST['StockLocation']; $result = get_stock_movements($_POST['stock_id'], $_POST['StockLocation'], $_POST['BeforeDate'], $_POST['AfterDate']); div_start('doc_tbl'); start_table(TABLESTYLE); -$th = array(_("Type"), _("#"), _("Reference"), _("Date"), _("Detail"), - _("Quantity In"), _("Quantity Out"), _("Quantity On Hand")); +$th = array(_("Type"), _("#"), _("Reference")); +if($display_location) array_push($th, _("Location")); +array_push($th, _("Date"), _("Detail"), _("Quantity In"), _("Quantity Out"), _("Quantity On Hand")); + table_header($th); @@ -89,7 +93,8 @@ if (!isset($before_qty_row[0])) } */ start_row("class='inquirybg'"); -label_cell(""._("Quantity on hand before") . " " . $_POST['AfterDate']."", "align=center colspan=5"); +$header_span = $display_location ? 6 : 5; +label_cell(""._("Quantity on hand before") . " " . $_POST['AfterDate']."", "align=center colspan=$header_span"); label_cell(" ", "colspan=2"); $dec = get_qty_dec($_POST['stock_id']); qty_cell($before_qty, false, $dec); @@ -127,6 +132,9 @@ while ($myrow = db_fetch($result)) label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"])); label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"], $myrow["reference"])); + if($display_location) { + label_cell($myrow['loc_code']); + } label_cell($trandate); $person = $myrow["person_id"]; @@ -177,7 +185,7 @@ while ($myrow = db_fetch($result)) //end of while loop start_row("class='inquirybg'"); -label_cell(""._("Quantity on hand after") . " " . $_POST['BeforeDate']."", "align=center colspan=5"); +label_cell(""._("Quantity on hand after") . " " . $_POST['BeforeDate']."", "align=center colspan=$header_span"); qty_cell($total_in, false, $dec); qty_cell($total_out, false, $dec); qty_cell($after_qty, false, $dec); @@ -187,4 +195,3 @@ end_table(1); div_end(); end_page(); -?>