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;
}
