-//-----------------------------------------------------------------------------
-
-$before_date = date2sql($_POST['BeforeDate']);
-$after_date = date2sql($_POST['AfterDate']);
-
-$sql = "SELECT
- type,
- trans_no,
- reference,
- tran_date,
- person_id,
- qty
- FROM ".TB_PREF."stock_moves
- WHERE loc_code='" . $_POST['StockLocation'] . "'
- AND tran_date >= '". $after_date . "'
- AND tran_date <= '" . $before_date . "'
- AND stock_id = '" . $_POST['stock_id'] . "'";
-
-$cols = array(
- _("Type") => array('fun'=>'systype_name' ),
- _("#") => array('fun'=>'trans_view' ),
- _("Reference"),
- _("Date") => array('date', 'ord'=>'desc'),
- _("Detail") => array('fun'=>'show_details' ),
- _("Quantity In") => array('type'=>'amount', 'dec'=> $item_dec, 'insert'=>true,'fun'=>'qty_in' ),
- _("Quantity Out") => array('type'=>'amount', 'dec'=> $item_dec,'insert'=>true,'fun'=>'qty_out' ),
-// _("Quantity On Hand") => array('insert'=>true,'type'=>'amount', 'fun'=>'show_qoh' )
-);
-
-$table =& new_db_pager('doc_tbl', $sql, $cols);
-$table->set_header('before_status');
-$table->set_footer('after_status');