X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=dimensions%2Finquiry%2Fsearch_dimensions.php;h=4eb25480fe3ef751630139871c0ef1864404a0c6;hb=6351305b2b0e5782804ab4d9e3db5f84b671d6f2;hp=29b58efe3f1a76a74ff3b4617587086729373050;hpb=d2cc0860eccf02eaefcd90731ac3af141a841529;p=fa-stable.git

diff --git a/dimensions/inquiry/search_dimensions.php b/dimensions/inquiry/search_dimensions.php
index 29b58efe..4eb25480 100644
--- a/dimensions/inquiry/search_dimensions.php
+++ b/dimensions/inquiry/search_dimensions.php
@@ -17,10 +17,11 @@ 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 . "/reporting/includes/reporting.inc");
 $js = "";
-if ($use_popup_windows)
+if ($SysPrefs->use_popup_windows)
 	$js .= get_js_open_window(800, 500);
-if ($use_date_picker)
+if (user_use_date_picker())
 	$js .= get_js_date_picker();
 
 if (isset($_GET['outstanding_only']) && $_GET['outstanding_only'])
@@ -50,7 +51,6 @@ if (get_post('SearchOrders'))
 	$Ajax->addDisable(true, 'OpenOnly', $disable);
 
 	if ($disable) {
-//		$Ajax->addFocus(true, 'OrderNumber');
 		set_focus('OrderNumber');
 	} else
 		set_focus('type_');
@@ -67,7 +67,7 @@ if (isset($_GET["stock_id"]))
 
 start_form(false, false, $_SERVER['PHP_SELF'] ."?outstanding_only=$outstanding_only");
 
-start_table("class='tablestyle_noborder'");
+start_table(TABLESTYLE_NOBORDER);
 start_row();
 
 ref_cells(_("Reference:"), 'OrderNumber', '',null, '', true);
@@ -97,21 +97,14 @@ function view_link($row)
 	return get_dimensions_trans_view_str(ST_DIMENSION, $row["id"]);
 }
 
-function is_closed($row)
+function sum_dimension($row) 
 {
-	return $row['closed'] ? _('Yes') : _('No');
+	return get_dimension_balance($row['id'], $_POST['FromDate'], $_POST['ToDate']); 
 }
 
-function sum_dimension($row) 
+function is_closed($row)
 {
-	$sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE tran_date >= '" .
-		date2sql($_POST['FromDate']) . "' AND
-		tran_date <= '" . date2sql($_POST['ToDate']) . "' AND (dimension_id = " .
-		$row['id']." OR dimension2_id = " .$row['id'].")";
-	$res = db_query($sql, "Sum of transactions could not be calculated");
-	$row = db_fetch_row($res);
-
-	return $row[0];
+	return $row['closed'] ? _('Yes') : _('No');
 }
 
 function is_overdue($row)
@@ -121,50 +114,18 @@ function is_overdue($row)
 
 function edit_link($row)
 {
-	//return $row["closed"] ?  '' :
-	//	pager_link(_("Edit"),
-	//		"/dimensions/dimension_entry.php?trans_no=" . $row["id"], ICON_EDIT);
 	return pager_link(_("Edit"),
 			"/dimensions/dimension_entry.php?trans_no=" . $row["id"], ICON_EDIT);
 }
 
-$sql = "SELECT dim.id,
-	dim.reference,
-	dim.name,
-	dim.type_,
-	dim.date_,
-	dim.due_date,
-	dim.closed
-	FROM ".TB_PREF."dimensions as dim WHERE id > 0";
-
-if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
+function prt_link($row)
 {
-	$sql .= " AND reference LIKE ".db_escape("%". $_POST['OrderNumber'] . "%");
-} else {
-
-	if ($dim == 1)
-		$sql .= " AND type_=1";
-
-	if (isset($_POST['OpenOnly']))
-	{
-   		$sql .= " AND closed=0";
-	}
-
-	if (isset($_POST['type_']) && ($_POST['type_'] > 0))
-	{
-   		$sql .= " AND type_=".db_escape($_POST['type_']);
-	}
-
-	if (isset($_POST['OverdueOnly']))
-	{
-		$today = date2sql(Today());
+	return print_document_link($row['id'], _("Print"), true, ST_DIMENSION, ICON_PRINT);
+}
 
-	   	$sql .= " AND due_date < '$today'";
-	}
 
-	$sql .= " AND date_ >= '" . date2sql($_POST['FromDate']) . "'
-		AND date_ <= '" . date2sql($_POST['ToDate']) . "'";
-}
+$sql = get_sql_for_search_dimensions($dim, $_POST['FromDate'], $_POST['ToDate'],
+	$_POST['OrderNumber'], $_POST['type_'], check_value('OpenOnly'), check_value('OverdueOnly'));
 
 $cols = array(
 	_("#") => array('fun'=>'view_link'), 
@@ -175,7 +136,8 @@ $cols = array(
 	_("Due Date") => array('name'=>'due_date', 'type'=>'date', 'ord'=>'asc'), 
 	_("Closed") => array('fun'=>'is_closed'),
 	_("Balance") => array('type'=>'amount', 'insert'=>true, 'fun'=>'sum_dimension'),
-	array('insert'=>true, 'fun'=>'edit_link')
+	array('insert'=>true, 'fun'=>'edit_link'),
+	array('insert'=>true, 'fun'=>'prt_link')
 );
 
 if ($outstanding_only) {
@@ -192,4 +154,3 @@ display_db_pager($table);
 end_form();
 end_page();
 
-?>