X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fview_print_transaction.php;h=65bc42d4a69aaa57f150efcd297847d9c1b2cb26;hb=02dd4aefa3e3babb64d61140bb7f7de14e37f755;hp=b3e35f6220ea3b95ee1b2c115f5acd94b5b4dc38;hpb=d2cc0860eccf02eaefcd90731ac3af141a841529;p=fa-stable.git

diff --git a/admin/view_print_transaction.php b/admin/view_print_transaction.php
index b3e35f62..65bc42d4 100644
--- a/admin/view_print_transaction.php
+++ b/admin/view_print_transaction.php
@@ -18,6 +18,7 @@ include_once($path_to_root . "/includes/session.inc");
 include_once($path_to_root . "/includes/date_functions.inc");
 include_once($path_to_root . "/includes/ui.inc");
 include_once($path_to_root . "/includes/data_checks.inc");
+include_once($path_to_root . "/admin/db/transactions_db.inc");
 
 include_once($path_to_root . "/reporting/includes/reporting.inc");
 $js = "";
@@ -93,31 +94,11 @@ function handle_search()
 	global $table_style;
 	if (check_valid_entries()==true)
 	{
-		$db_info = get_systype_db_info($_POST['filterType']);
-
-		if ($db_info == null)
+		$trans_ref = false;
+		$sql = get_sql_for_view_transactions($_POST['filterType'], $_POST['FromTransNo'], $_POST['ToTransNo'], $trans_ref);
+		if ($sql == "")
 			return;
 
-		$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 as trans_no";
-
-		if ($trans_ref)
-			$sql .= " ,$trans_ref ";
-
-		$sql .= ", ".$_POST['filterType']." as type FROM $table_name
-			WHERE $trans_no_name >= ".db_escape($_POST['FromTransNo']). "
-			AND  $trans_no_name <= ".db_escape($_POST['ToTransNo']);
-
-		if ($type_name != null)
-			$sql .= " AND `$type_name` = ".db_escape($_POST['filterType']);
-
-		$sql .= " ORDER BY $trans_no_name";
-
-
 		$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);