- $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 == ST_SALESINVOICE || $print_type == ST_CUSTCREDIT || $print_type == ST_CUSTDELIVERY ||
+ $print_type == ST_PURCHORDER || $print_type == ST_SALESORDER || $print_type == ST_SALESQUOTE);
+
+ $cols = array(
+ _("#"),
+ _("Reference"),
+ _("View") => array('insert'=>true, 'fun'=>'view_link'),
+ _("Print") => array('insert'=>true, 'fun'=>'prt_link'),
+ _("GL") => array('insert'=>true, 'fun'=>'gl_view')
+ );
+ if(!$print_out) {
+ array_remove($cols, 3);