X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Freferences.inc;h=bba6f155545d3c8ce773d3b8c35abb930d93b732;hb=11109ad9f0e6af3f59d72731a95e473e72fb308b;hp=cd01ab6c67386032182dbda57e5a962390f1bea2;hpb=0b63d898491b6577a5a5bf90e771dca0dcbbcf1f;p=fa-stable.git

diff --git a/includes/references.inc b/includes/references.inc
index cd01ab6c..bba6f155 100644
--- a/includes/references.inc
+++ b/includes/references.inc
@@ -100,48 +100,3 @@ class references
 	}
 }
 
-//----------------------------------------------------------------------------
-//
-//	Check if reference was not used so far (for other transaction than $trans_no)
-//
-function is_new_reference($ref, $type, $trans_no=0)
-{
-	$db_info = get_systype_db_info($type);
-	$db_name = $db_info[0];
-	$db_type = $db_info[1];
-	$db_trans = $db_info[2];
-	$db_ref = $db_info[3];
-	
-	$ref = db_escape(trim($ref));
-	$type = db_escape($type);
-	
-	if ($db_ref == null) { // journal or bank trans store references in refs table
-		$db_name = TB_PREF."refs";
-		$db_type = 'type';
-		$db_trans = 'id';
-		$db_ref = 'reference';
-	}
-
-	if ($db_type != null) {
-		$sql = "SELECT $db_ref FROM $db_name tbl
-			LEFT JOIN ".TB_PREF."voided v ON 
-				tbl.$db_type=v.type AND tbl.$db_trans=v.id
-			WHERE $db_ref=$ref AND ISNULL(v.id)
-				AND tbl.$db_type=$type";
-	} else {
-		$sql = "SELECT $db_ref ref FROM $db_name tbl
-			LEFT JOIN ".TB_PREF."voided v ON 
-				v.type=$type AND tbl.$db_trans=v.id
-			WHERE $db_ref=$ref AND ISNULL(v.id)";
-	}
-	if ($trans_no)
-			$sql .= " AND tbl.`$db_trans` != ".db_escape($trans_no);
-
-	$result = db_query($sql, "could not test for unique reference");
-
-	return (db_num_rows($result) == 0);
-
-}
-
-
-?>
\ No newline at end of file