- $table_name = $db_info[0];
- $type_name = $db_info[1];
- $trans_no_name = $db_info[2];
- $trans_ref = $db_info[3];
-
- $sql = "SELECT DISTINCT $trans_no_name ";
-
- if ($trans_ref)
- $sql .= " ,$trans_ref ";
-
- $sql .= " FROM $table_name
- WHERE $trans_no_name >= " . $_POST['FromTransNo']. "
- AND $trans_no_name <= " . $_POST['ToTransNo'];
-
- if ($type_name != null)
- $sql .= " AND $type_name = " . $_POST['filterType'];
-
- $sql .= " ORDER BY $trans_no_name";
-
- $result = db_query($sql, "could not query transactions on $table_name");
-
- if (db_num_rows($result) == 0)
- {
- echo _("There are no transactions for the given parameters.");
- return;
- }
- $print_type = $_POST['filterType'];
- $print_out = ($print_type == 10 || $print_type == 11 || $print_type == systypes::cust_dispatch() ||
- $print_type == systypes::po() || $print_type == systypes::sales_order());
- if ($print_out)
- {
- print_hidden_script($print_type);
- if ($trans_ref)
- $th = array(_("#"), _("Reference"), _("View"), _("Print"), _("GL"));
- else
- $th = array(_("#"), _("View"), _("Print"), _("GL"));
+ $print_type = get_post('filterType');
+ $print_out = ($print_type == ST_SALESINVOICE || $print_type == ST_CUSTCREDIT || $print_type == ST_CUSTDELIVERY ||
+ $print_type == ST_PURCHORDER || $print_type == ST_SALESORDER || $print_type == ST_SALESQUOTE ||
+ $print_type == ST_CUSTPAYMENT || $print_type == ST_SUPPAYMENT || $print_type == ST_WORKORDER);
+
+ $cols = array(
+ _("#") => array('insert'=>true, 'fun'=>'view_link'),
+ _("Reference") => array('fun'=>'ref_view'),
+ _("Date") => array('type'=>'date', 'fun'=>'date_view'),
+ _("Print") => array('insert'=>true, 'fun'=>'prt_link'),
+ _("GL") => array('insert'=>true, 'fun'=>'gl_view')
+ );
+ if(!$print_out) {
+ array_remove($cols, 3);