-$item_dec = get_qty_dec($_POST['stock_id']);
-//
-// Get summary displayed in headewr and footer.
-//
-function get_summary(&$table)
-{
- global $Ajax, $item_dec;
-
- $sql = "SELECT
- Sum(qty) as sum,
- Sum(IF(qty>0, qty, 0)) as in_qty,
- Sum(IF(qty<0, -qty, 0)) as out_qty
- FROM ".TB_PREF."stock_moves
- WHERE loc_code='" . $_POST['StockLocation'] . "'
- AND tran_date >= '". date2sql($_POST['AfterDate']) . "'
- AND tran_date <= '" . date2sql($_POST['BeforeDate']) . "'
- AND stock_id = '" . $_POST['stock_id'] . "'";
- " GROUP BY rec";
- $result = db_query($sql, "cannot retrieve stock moves");
-
- $qty = db_fetch($result);
-
- $sum['beg'] = get_qoh_on_date($_POST['stock_id'], $_POST['StockLocation'],
- add_days($_POST['AfterDate'], -1));
- $sum['in'] = $qty['in_qty'];
- $sum['out'] = $qty['out_qty'];
- $sum['end'] = $sum['beg'] + $qty['sum'];
- $sum['dec'] = $item_dec = get_qty_dec($_POST['stock_id']);
-
- $table->sum = $sum;
- $Ajax->activate('summary');
- }
-//-----------------------------------------------------------------------------
-
-function systype_name($row)
-{
- return systypes::name($row["type"]);
-}