X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fdb%2Fsuppalloc_db.inc;h=228f7b1c4a72335b4dfc9604c5c625fe613cf8ba;hb=ee0dff4cdf462ac0476531181ad61ff7f9db1c6c;hp=57e76b35fd23ca2ea23e132d842e93fd56ee5f4a;hpb=d1babda7c01b314d35fb89f2d195553b55936532;p=fa-stable.git

diff --git a/purchasing/includes/db/suppalloc_db.inc b/purchasing/includes/db/suppalloc_db.inc
index 57e76b35..228f7b1c 100644
--- a/purchasing/includes/db/suppalloc_db.inc
+++ b/purchasing/includes/db/suppalloc_db.inc
@@ -44,7 +44,7 @@ function get_supp_trans_allocation_balance($trans_type, $trans_no)
 	$result = db_query($sql,"calculate the allocation");
 	$myrow = db_fetch_row($result);
 
-	return $myrow[0];
+	return $myrow ? $myrow[0] : 0;
 }
 
 //----------------------------------------------------------------------------------------
@@ -97,14 +97,10 @@ function clear_supp_alloctions($type, $type_no, $person_id=null, $date="")
 		$sql .= " AND person_id=".db_escape($person_id);
 
 	db_query($sql, "could not void supp transactions for type=$type and trans_no=$type_no");
-// is this necessary?
-//	if ($date != "")
-//		exchange_variation($type, $type_no, $row['trans_type_to'], $row['trans_no_to'], $date,
-//			$row['amt'], PT_SUPPLIER, true);
 }
 //-------------------------------------------------------------------------------------------------------------
 
-function get_allocatable_from_supp_sql($supplier_id=null, $settled)
+function get_allocatable_from_supp_sql($supplier_id, $settled)
 {
 	$sql = "SELECT
 		trans.type,
@@ -168,8 +164,6 @@ function get_allocatable_purch_orders($supplier_id = null, $trans_no=null, $type
 	}
 	else
 	{
-// 	FIXME: change to form below when prepayments terms finally can be selected in PO entry form:
-//		$sql .= " AND round(prep_amount) > 0 AND ISNULL(grn.purch_order_no)"; // only sales orders with prepayment level set and no yet received
 		$sql .= " AND ISNULL(grn.purch_order_no)"; // only sales orders no yet received
 	}
 	if ($supplier_id)
@@ -261,7 +255,6 @@ function get_allocatable_from_supp_transactions($supplier_id, $trans_no=null, $t
 			AND trans.type NOT IN (".implode(',',array(ST_SUPPAYMENT,ST_BANKPAYMENT)).")";
 		$sql .= " GROUP BY type, trans_no";
 	}
-//_vd($sql);
 	return db_query($sql." ORDER BY due_date", "Cannot retreive alloc to transactions");
 }
 
@@ -309,6 +302,10 @@ function get_sql_for_supplier_allocation_inquiry()
    		{
 			$sql .= " AND trans.type = ".ST_SUPPCREDIT." ";
    		}
+   		elseif ($_POST['filterType'] == '6')	// Journal
+   		{
+			$sql .= " AND trans.type = ".ST_JOURNAL." ";
+   		}
 
    		if (($_POST['filterType'] == '2') || ($_POST['filterType'] == '5')) // overdude 
    		{