X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=includes%2Freferences.inc;h=38bd84cdceb541470d38674b2b4f1eb638d5c187;hb=3faff3b471c0953bc1d11a6c00308779787a55f2;hp=292ccf4402c178b7fe8cd9c1073ca5cebc4de7fc;hpb=264c09696d65efe4532c197f317162daf8c24f32;p=fa-stable.git diff --git a/includes/references.inc b/includes/references.inc index 292ccf44..38bd84cd 100644 --- a/includes/references.inc +++ b/includes/references.inc @@ -57,7 +57,7 @@ class references function save($type, $id, $reference) { update_reference($type, $id, $reference); // store in refs table - if ($reference == $this->get_next($type)) { // if reference was not changed from default + if ($reference == $this->get_next($type)) { // if reference was bigger or not changed from default $next = $this->_increment($reference); // increment default save_next_reference($type, $next); } @@ -100,46 +100,4 @@ 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