public function insert() { //insert in si_invoice global $db_server; $sql = "INSERT \n\t\t\t\tINTO\n\t\t\t" . TB_PREFIX . "invoices (\n\t\t\t\tid, \n\t\t \t\tindex_id,\n\t\t\t\tdomain_id,\n\t\t\t\tbiller_id, \n\t\t\t\tcustomer_id, \n\t\t\t\ttype_id,\n\t\t\t\tpreference_id, \n\t\t\t\tdate, \n\t\t\t\tnote,\n\t\t\t\tcustom_field1,\n\t\t\t\tcustom_field2,\n\t\t\t\tcustom_field3,\n\t\t\t\tcustom_field4\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\tNULL,\n\t\t\t\t:index_id,\n\t\t\t\t:domain_id,\n\t\t\t\t:biller_id,\n\t\t\t\t:customer_id,\n\t\t\t\t:type_id,\n\t\t\t\t:preference_id,\n\t\t\t\t:date,\n\t\t\t\t:note,\n\t\t\t\t:custom_field1,\n\t\t\t\t:custom_field2,\n\t\t\t\t:custom_field3,\n\t\t\t\t:custom_field4\n\t\t\t\t)"; $pref_group = getPreference($this->preference_id, $this->domain_id); $sth = dbQuery($sql, ':index_id', index::next('invoice', $pref_group['index_group'], $this->domain_id), ':domain_id', $this->domain_id, ':biller_id', $this->biller_id, ':customer_id', $this->customer_id, ':type_id', $this->type_id, ':preference_id', $this->preference_id, ':date', $this->date, ':note', trim($this->note), ':custom_field1', $this->custom_field1, ':custom_field2', $this->custom_field2, ':custom_field3', $this->custom_field3, ':custom_field4', $this->custom_field4); #index::increment('invoice',$pref_group['index_group'], $domain_id,$this->biller_id); index::increment('invoice', $pref_group['index_group'], $this->domain_id); return lastInsertID(); }
public static function increment($node, $sub_node = 0, $domain_id = '', $sub_node_2 = 0) { $domain_id = domain_id::get($domain_id); $next = index::next($node, $sub_node, $domain_id, $sub_node_2); if ($next == 1) { $sql = "INSERT INTO " . TB_PREFIX . "index (id, node, sub_node, sub_node_2, domain_id) \n\t\t\t\t\tVALUES (:id, :node, :sub_node, :sub_node_2, :domain_id)"; } else { $sql = "UPDATE " . TB_PREFIX . "index \n SET id = :id \n WHERE node = :node\n\t\t\t\t\tAND sub_node = :sub_node\n AND sub_node_2 = :sub_node_2\n AND domain_id = :domain_id\n\t\t\t\t "; } $sth = dbQuery($sql, ':id', $next, ':node', $node, ':sub_node', $sub_node, ':sub_node_2', $sub_node_2, ':domain_id', $domain_id); return $next; }
public static function increment($node, $sub_node = "") { $next = index::next($node, $sub_node); global $db; global $auth_session; /* if ($sub_node !="") { $subnode = "and sub_node = ".$sub_node; } */ if ($next == 1) { $sql = "insert into si_index (id, node, sub_node, domain_id) VALUES (:id, :node, :sub_node, :domain_id);"; } else { $sql = "update\n si_index \n set \n id = :id \n where\n node = :node\n and\n domain_id = :domain_id\n and\n sub_node = :sub_node"; } $sth = $db->query($sql, ':id', $next, ':node', $node, ':sub_node', $sub_node, ':domain_id', $auth_session->domain_id) or die(htmlsafe(end($dbh->errorInfo()))); return $next; }
function insertInvoice($type, $domain_id = '') { global $db_server; $domain_id = domain_id::get($domain_id); if ($db_server == 'mysql' && !_invoice_check_fk($_POST['biller_id'], $_POST['customer_id'], $type, $_POST['preference_id'])) { return null; } $sql = "INSERT INTO\n\t\t" . TB_PREFIX . "invoices (\n\t\t\tid, \n index_id,\n\t\t\tdomain_id,\n\t\t\tbiller_id, \n\t\t\tcustomer_id, \n\t\t\ttype_id,\n\t\t\tpreference_id, \n\t\t\tdate, \n\t\t\tnote,\n\t\t\tcustom_field1,\n\t\t\tcustom_field2,\n\t\t\tcustom_field3,\n\t\t\tcustom_field4\n\t\t)\n\t\tVALUES\n\t\t(\n\t\t\tNULL,\n\t\t\t:index_id,\n\t\t\t:domain_id,\n\t\t\t:biller_id,\n\t\t\t:customer_id,\n\t\t\t:type,\n\t\t\t:preference_id,\n\t\t\t:date,\n\t\t\t:note,\n\t\t\t:customField1,\n\t\t\t:customField2,\n\t\t\t:customField3,\n\t\t\t:customField4\n\t\t\t)"; if ($db_server == 'pgsql') { $sql = "INSERT INTO\n\t\t\t" . TB_PREFIX . "invoices (\n\t\t\t\tindex_id,\n\t\t\t\tdomain_id,\n\t\t\t\tbiller_id, \n\t\t\t\tcustomer_id, \n\t\t\t\ttype_id,\n\t\t\t\tpreference_id, \n\t\t\t\tdate, \n\t\t\t\tnote,\n\t\t\t\tcustom_field1,\n\t\t\t\tcustom_field2,\n\t\t\t\tcustom_field3,\n\t\t\t\tcustom_field4\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t:index_id,\n\t\t\t\t:domain_id,\n\t\t\t\t:biller_id,\n\t\t\t\t:customer_id,\n\t\t\t\t:type,\n\t\t\t\t:preference_id,\n\t\t\t\t:date,\n\t\t\t\t:note,\n\t\t\t\t:customField1,\n\t\t\t\t:customField2,\n\t\t\t\t:customField3,\n\t\t\t\t:customField4\n\t\t\t\t)"; } $pref_group = getPreference($_POST[preference_id]); //also set the current time (if null or =00:00:00) $clean_date = SqlDateWithTime($_POST['date']); $sth = dbQuery($sql, ':index_id', index::next('invoice', $pref_group['index_group'], $domain_id), ':domain_id', $domain_id, ':biller_id', $_POST['biller_id'], ':customer_id', $_POST['customer_id'], ':type', $type, ':preference_id', $_POST['preference_id'], ':date', $clean_date, ':note', trim($_POST['note']), ':customField1', $_POST['customField1'], ':customField2', $_POST['customField2'], ':customField3', $_POST['customField3'], ':customField4', $_POST['customField4']); #index::increment('invoice',$pref_group[index_group], $domain_id,$_POST[biller_id]); // Needed only if si_index table exists index::increment('invoice', $pref_group[index_group], $domain_id); return $sth; }
function insertInvoice($type) { global $dbh; global $db_server; global $auth_session; if ($db_server == 'mysql' && !_invoice_check_fk($_POST['biller_id'], $_POST['customer_id'], $type, $_POST['preference_id'])) { return null; } $sql = "INSERT \n\t\t\tINTO\n\t\t" . TB_PREFIX . "invoices (\n\t\t\tid, \n \t\tindex_id,\n\t\t\tdomain_id,\n\t\t\tbiller_id, \n\t\t\tcustomer_id, \n\t\t\ttype_id,\n\t\t\tpreference_id, \n\t\t\tdate, \n\t\t\tnote,\n\t\t\tcustom_field1,\n\t\t\tcustom_field2,\n\t\t\tcustom_field3,\n\t\t\tcustom_field4\n\t\t)\n\t\tVALUES\n\t\t(\n\t\t\tNULL,\n\t\t\t:index_id,\n\t\t\t:domain_id,\n\t\t\t:biller_id,\n\t\t\t:customer_id,\n\t\t\t:type,\n\t\t\t:preference_id,\n\t\t\t:date,\n\t\t\t:note,\n\t\t\t:customField1,\n\t\t\t:customField2,\n\t\t\t:customField3,\n\t\t\t:customField4\n\t\t\t)"; if ($db_server == 'pgsql') { $sql = "INSERT \n\t\t\t\tINTO\n\t\t\t" . TB_PREFIX . "invoices (\n\t\t\t\tindex_id,\n\t\t\t\tdomain_id,\n\t\t\t\tbiller_id, \n\t\t\t\tcustomer_id, \n\t\t\t\ttype_id,\n\t\t\t\tpreference_id, \n\t\t\t\tdate, \n\t\t\t\tnote,\n\t\t\t\tcustom_field1,\n\t\t\t\tcustom_field2,\n\t\t\t\tcustom_field3,\n\t\t\t\tcustom_field4\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t:index_id,\n\t\t\t\t:domain_id,\n\t\t\t\t:biller_id,\n\t\t\t\t:customer_id,\n\t\t\t\t:type,\n\t\t\t\t:preference_id,\n\t\t\t\t:date,\n\t\t\t\t:note,\n\t\t\t\t:customField1,\n\t\t\t\t:customField2,\n\t\t\t\t:customField3,\n\t\t\t\t:customField4\n\t\t\t\t)"; } //echo $sql; $pref_group = getPreference($_POST[preference_id]); $sth = dbQuery($sql, ':index_id', index::next('invoice', $pref_group[index_group]), ':domain_id', $auth_session->domain_id, ':biller_id', $_POST[biller_id], ':customer_id', $_POST[customer_id], ':type', $type, ':preference_id', $_POST[preference_id], ':date', $_POST[date], ':note', $_POST[note], ':customField1', $_POST[customField1], ':customField2', $_POST[customField2], ':customField3', $_POST[customField3], ':customField4', $_POST[customField4]); #index::increment('invoice',$pref_group[index_group],$_POST[biller_id]); index::increment('invoice', $pref_group[index_group]); return $sth; }