X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=fixed_assets%2Fincludes%2Ffixed_assets_db.inc;h=11c9c027d50662f5d85d8fbf5c87174f9ca21750;hb=3539962a4e524de683d8c5e851c482ad99a97267;hp=911cdddff438ca11f56250ef35b832cc4253df9e;hpb=d6acd81ab6a3c773ddd1557a8476002d96db0cd3;p=fa-stable.git

diff --git a/fixed_assets/includes/fixed_assets_db.inc b/fixed_assets/includes/fixed_assets_db.inc
index 911cdddf..11c9c027 100644
--- a/fixed_assets/includes/fixed_assets_db.inc
+++ b/fixed_assets/includes/fixed_assets_db.inc
@@ -85,7 +85,9 @@ function get_fixed_asset_disposal($stock_id) {
 
   $sql = "SELECT * FROM ".TB_PREF."stock_moves 
     	WHERE stock_id=".db_escape($stock_id)."
-    		AND (type=".ST_INVADJUST." OR type=".ST_CUSTDELIVERY.")";
+    		AND (type=".ST_INVADJUST." OR type=".ST_CUSTDELIVERY.")
+        ORDER BY tran_date DESC
+        LIMIT 1";
 
   $result = db_query($sql, "cannot retrieve fixed asset move");
 
@@ -96,23 +98,25 @@ function get_fixed_asset_disposal($stock_id) {
   return $row;
 }
 
-function get_fixed_asset_purchase($stock_id) {
-
-  $sql = "SELECT * 
-  	FROM ".TB_PREF."stock_master m, "
-  		.TB_PREF."supp_invoice_items i, "
-  		.TB_PREF."supp_trans t
-    WHERE m.stock_id=".db_escape($stock_id)."
-	    AND i.supp_trans_no=t.trans_no
-    	AND m.stock_id=i.stock_id";
-
-  $result = db_query($sql, "cannot retrieve fixed asset move");
-
-  if (db_num_rows($result) == 0)
-    return false;
-
-  $row = db_fetch_assoc($result);
-  return $row;
+function get_fixed_asset_purchase($stock_id) 
+{
+  	$sql = "SELECT * 
+  		FROM ".TB_PREF."stock_master m, "
+  			.TB_PREF."supp_invoice_items i, "
+  			.TB_PREF."supp_trans t
+    	WHERE m.stock_id=".db_escape($stock_id)."
+		    AND i.supp_trans_no=t.trans_no
+    		AND m.stock_id=i.stock_id
+    	ORDER BY t.tran_date DESC
+    	LIMIT 1";
+
+  	$result = db_query($sql, "cannot retrieve fixed asset move");
+
+  	if (db_num_rows($result) == 0)
+    	return false;
+
+  	$row = db_fetch_assoc($result);
+  	return $row;
 }
 
 //--------------------------------------------------------------------------------------------------
@@ -130,17 +134,17 @@ function get_fixed_asset_class($id)
 
 function get_sql_for_fixed_assets($show_inactive = false)
 {
-  $sql = "SELECT s.stock_id, c.description, s.units, s.description as name,
-    s.depreciation_rate, s.depreciation_method, s.inactive, rcv.tran_date as purchase_date, rcv.trans_no as purchase_no,
-    adj.tran_date as disposal_date, adj.type as disposal_type, adj.trans_no as disposal_no, s.material_cost, s.purchase_cost, s.depreciation_factor
+  	$sql = "SELECT s.stock_id, c.description, s.units, s.description as name,
+        s.depreciation_rate, s.depreciation_method, s.inactive, 
+        s.material_cost, s.purchase_cost, s.depreciation_factor
     FROM ".TB_PREF."stock_master s"
-    	." LEFT JOIN ".TB_PREF."stock_moves rcv ON rcv.stock_id=s.stock_id AND rcv.type=".ST_SUPPRECEIVE
-    	." LEFT JOIN ".TB_PREF."stock_moves adj ON adj.stock_id=s.stock_id AND adj.type IN(".ST_INVADJUST.",".ST_CUSTDELIVERY.")"
     	." LEFT JOIN ".TB_PREF."stock_fa_class c ON s.fa_class_id=c.fa_class_id"
     	." WHERE s.mb_flag='F'";
 
-  if (!$show_inactive)
-    $sql .= " AND !s.inactive AND !ISNULL(rcv.tran_date) AND ISNULL(adj.tran_date)";
+  	if (!$show_inactive)
+    	$sql .= " AND !s.inactive ";
+
+  	$sql .= " ORDER BY c.description ";
 
 	return $sql;
 }