X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Freferences.inc;h=bba6f155545d3c8ce773d3b8c35abb930d93b732;hb=7e8df3a179c05c51085349e139aac9ce88b9378d;hp=6a8c7af2d0f87044206bc2fb0f243697e90b1051;hpb=1571869d54be48452fdbe08f25130972ff0a7b5a;p=fa-stable.git diff --git a/includes/references.inc b/includes/references.inc index 6a8c7af2..bba6f155 100644 --- a/includes/references.inc +++ b/includes/references.inc @@ -100,46 +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 - LEFT JOIN ".TB_PREF."voided v ON - $db_name.$db_type=v.type AND $db_name.$db_trans=v.id - WHERE $db_name.$db_ref=$ref AND ISNULL(v.id) - AND $db_name.$db_type=$type"; - } else { - $sql = "SELECT $db_ref FROM $db_name - LEFT JOIN ".TB_PREF."voided v ON - v.type=$type AND $db_name.$db_trans=v.id - WHERE $db_ref=$ref AND ISNULL(v.id)"; - } - - $result = db_query($sql, "could not test for unique reference"); - - return (db_num_rows($result) == 0); - -} - - -?> \ No newline at end of file