X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Finquiry%2Fstock_movements.php;h=1192cd0685c29f602080f2a3124cd12b08f094d4;hb=117a47981e773ef0ac7aafaf5984978c59c6947a;hp=944cb437b3c95ae1b501f8bfa20de6002a553080;hpb=99730b8d6deb7e81d2f1ebeb2ce7066d27729485;p=fa-stable.git diff --git a/inventory/inquiry/stock_movements.php b/inventory/inquiry/stock_movements.php index 944cb437..1192cd06 100644 --- a/inventory/inquiry/stock_movements.php +++ b/inventory/inquiry/stock_movements.php @@ -1,6 +1,14 @@ . +***********************************************************************/ $page_security = 2; $path_to_root="../.."; include_once($path_to_root . "/includes/session.inc"); @@ -17,13 +25,21 @@ if ($use_date_picker) $js .= get_js_date_picker(); page(_("Inventory Item Movement"), false, false, "", $js); +//------------------------------------------------------------------------------------------------ + +check_db_has_stock_items(_("There are no items defined in the system.")); + +if(get_post('ShowMoves')) +{ + $Ajax->activate('doc_tbl'); +} if (isset($_GET['stock_id'])) { $_POST['stock_id'] = $_GET['stock_id']; } -start_form(false, true); +start_form(); if (!isset($_POST['stock_id'])) $_POST['stock_id'] = get_global_stock_item(); @@ -37,7 +53,7 @@ locations_list_cells(_("From Location:"), 'StockLocation', null); date_cells(_("From:"), 'AfterDate', '', null, -30); date_cells(_("To:"), 'BeforeDate'); -submit_cells('ShowMoves',_("Show Movements")); +submit_cells('ShowMoves',_("Show Movements"),'',_('Refresh Inquiry'), 'default'); end_table(); end_form(); @@ -56,7 +72,8 @@ $result = db_query($sql, "could not query stock moves"); check_db_error("The stock movements for the selected criteria could not be retrieved",$sql); -start_table("$table_style width=70%"); +div_start('doc_tbl'); +start_table($table_style); $th = array(_("Type"), _("#"), _("Reference"), _("Date"), _("Detail"), _("Quantity In"), _("Quantity Out"), _("Quantity On Hand")); @@ -114,7 +131,6 @@ 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"])); - label_cell($trandate); $person = $myrow["person_id"]; @@ -128,7 +144,7 @@ while ($myrow = db_fetch($result)) $person = $cust_row['name'] . " (" . $cust_row['br_name'] . ")"; } - elseif ($myrow["type"] == 25) + elseif ($myrow["type"] == 25 || $myrow['type'] == 21) { // get the supplier name $sql = "SELECT supp_name FROM ".TB_PREF."suppliers WHERE supplier_id = '" . $myrow["person_id"] . "'"; @@ -167,19 +183,15 @@ while ($myrow = db_fetch($result)) } //end of while loop -// 2008-06-14. Always write this. -//if ($total_in != 0 || $total_out != 0) -//{ - start_row("class='inquirybg'"); - label_cell(""._("Quantity on hand after") . " " . $_POST['BeforeDate']."", "align=center colspan=5"); - qty_cell($total_in, false, $dec); - qty_cell($total_out, false, $dec); - qty_cell($after_qty, false, $dec); - end_row(); -//} +start_row("class='inquirybg'"); +label_cell(""._("Quantity on hand after") . " " . $_POST['BeforeDate']."", "align=center colspan=5"); +qty_cell($total_in, false, $dec); +qty_cell($total_out, false, $dec); +qty_cell($after_qty, false, $dec); +end_row(); end_table(1); - +div_end(); end_page(); ?>