function branch($brancod, $branname, $brandet, $code)
{
# Validate input
require_lib("validate");
$v = new validate();
$v->isOk($brancod, "string", 0, 50, "Invalid branch code.");
$v->isOk($branname, "string", 1, 255, "Invalid branch name.");
$v->isOk($brandet, "string", 0, 255, "Invalid branch details.");
# Display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
return $confirm;
}
# Check stock code
// db_connect();
db_conn("cubit_" . $code);
$sql = "SELECT branname FROM branches WHERE lower(branname) = lower('{$branname}')";
$cRslt = db_exec($sql);
if (pg_numrows($cRslt) > 0) {
$error = "<li class='err'>Branch name : <b>{$branname}</b> already exists.</li>";
$error .= "<p><input type='button' onClick='history.back();' value='« Correct submission'>";
return $error;
}
// Insert into stock
// db_connect();
db_conn("cubit_" . $code);
$sql = "\n\t\tINSERT INTO branches (\n\t\t\tbrancod, branname, brandet\n\t\t) VALUES (\n\t\t\t'{$brancod}', '{$branname}', '{$brandet}'\n\t\t)";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.", SELF);
$div = pglib_lastid("branches", "div", $code);
// Insert sequences
$sql = "INSERT INTO seq(type, last_value, div) VALUES('inv', '0', '{$div}')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.", SELF);
$sql = "INSERT INTO seq(type, last_value, div) VALUES('pur', '0', '{$div}')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.", SELF);
$sql = "INSERT INTO seq(type, last_value, div) VALUES('note', '0', '{$div}')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.", SELF);
# Create Default Accounts
// Profit/Loss account (999/999)
$catid = createcat("Profit/Loss", $div, "B", $code);
if (createacc("9999", "999", "Profit/Loss account", $catid, "B", "n", $div, $code) > 0) {
return "<li class='err'>Failed to create default accounts</li>";
}
// Total Income account (199/999)
$catid = createcat("Total Income", $div, "I", $code);
if (createacc("1999", "999", "Total Income account", $catid, "I", "n", $div, $code) > 0) {
return "<li class='err'>Failed to create default accounts</li>";
}
// Total Expenses account (499/999)
$catid = createcat("Total Expenses", $div, "E", $code);
if (createacc("4999", "999", "Total Expenses account", $catid, "E", "n", $div, $code) > 0) {
return "<li class='err'>Failed to create default accounts</li>";
}
return $div;
}
function write($_POST)
{
# Get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
if (isset($back)) {
return view($_POST);
}
# Validate input
require_lib("validate");
$v = new validate();
$v->isOk($brancod, "string", 0, 50, "Invalid branch code.");
$v->isOk($branname, "string", 1, 255, "Invalid branch name.");
$v->isOk($brandet, "string", 0, 255, "Invalid branch details.");
# Display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>{$e['msg']}</li>";
}
$confirm .= "</li><p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Check stock code
db_connect();
$sql = "SELECT branname FROM branches WHERE lower(branname) = lower('{$branname}')";
$cRslt = db_exec($sql);
if (pg_numrows($cRslt) > 0) {
$error = "<li class=err>Branch name : <b>{$branname}</b> already exists.</li>";
$error .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $error;
}
// Insert into stock
db_connect();
$sql = "INSERT INTO branches(brancod, branname, brandet) VALUES('{$brancod}', '{$branname}', '{$brandet}')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.", SELF);
$div = pglib_lastid("branches", "div");
/*
// Insert sequences
$sql = "INSERT INTO seq(type, last_value, div) VALUES('inv', '0', '$div')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.",SELF);
$sql = "INSERT INTO seq(type, last_value, div) VALUES('pur', '0', '$div')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.",SELF);
$sql = "INSERT INTO seq(type, last_value, div) VALUES('note', '0', '$div')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.",SELF);
*/
# Create Default Accounts
// Profit/Loss account (999/999)
$catid = createcat("Profit/Loss", $div, "B");
if (createacc("9999", "999", "Profit/Loss account", $catid, "B", "n", $div) > 0) {
return "<li class=err>Failed to create default accounts</li>";
}
// Total Income account (199/999)
$catid = createcat("Total Income", $div, "I");
if (createacc("1999", "999", "Total Income account", $catid, "I", "n", $div) > 0) {
return "<li class=err>Failed to create default accounts</li>";
}
// Total Expenses account (499/999)
$catid = createcat("Total Expenses", $div, "E");
if (createacc("4999", "999", "Total Expenses account", $catid, "E", "n", $div) > 0) {
return "<li class=err>Failed to create default accounts</li>";
}
// Layout
$write = "\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\r\n\t<tr><th>New Branch added to database</th></tr>\r\n\t<tr class=datacell><td>New Branch, {$branname} ({$brancod}) has been successfully added to Cubit.</td></tr>\r\n\t</table>\r\n\t<p>\r\n\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t\t<tr><th>Quick Links</th></tr>\r\n\t\t<tr class='bg-odd'><td><a href='admin-branview.php'>View Branches</a></td></tr>\r\n\t\t<tr class='bg-odd'><td><a href='main.php'>Main Menu</a></td></tr>\r\n\t</table>";
return $write;
}
function write($_POST)
{
# Get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
if (isset($back)) {
return view($_POST);
}
# Validate input
require_lib("validate");
$v = new validate();
$v->isOk($brancod, "string", 0, 50, "Invalid branch code.");
$v->isOk($branname, "string", 1, 255, "Invalid branch name.");
$v->isOk($brandet, "string", 0, 255, "Invalid branch details.");
# Display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>{$e['msg']}</li>";
}
$confirm .= "</li><p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Check stock code
db_connect();
$sql = "SELECT branname FROM branches WHERE lower(branname) = lower('{$branname}')";
$cRslt = db_exec($sql);
if (pg_numrows($cRslt) > 0) {
$error = "<li class=err>Branch name : <b>{$branname}</b> already exists.</li>";
$error .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $error;
}
// Insert into stock
db_connect();
$sql = "INSERT INTO branches(brancod, branname, brandet) VALUES('{$brancod}', '{$branname}', '{$brandet}')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.", SELF);
$div = pglib_lastid("branches", "div");
/*
// Insert sequences
$sql = "INSERT INTO seq(type, last_value, div) VALUES('inv', '0', '$div')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.",SELF);
$sql = "INSERT INTO seq(type, last_value, div) VALUES('pur', '0', '$div')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.",SELF);
$sql = "INSERT INTO seq(type, last_value, div) VALUES('note', '0', '$div')";
$rslt = db_exec($sql) or errDie("Unable to insert branch to Cubit.",SELF);
*/
# Create Default Accounts
// Profit/Loss account (999/999)
db_conn('cubit');
// ,bc='$bc',vat='$vat',cs='$cs'
//Select user selected account numbering
$sql = "SELECT label FROM set WHERE label = 'ACCNEW_LNK' AND div = '{$div}'";
$Rslt = db_exec($sql) or errDie("Unable to check database for existing account creation settings.");
if (pg_numrows($Rslt) > 0) {
$Sql = "UPDATE set SET value = 'acc-new2.php', type = 'Account Creation' WHERE label = 'ACCNEW_LNK'";
} else {
$Sql = "INSERT INTO set(type, label, value, descript, div) VALUES('Account Creation', 'ACCNEW_LNK', 'acc-new2.php', 'Use user selected account numbers', '{$div}')";
}
$setRslt = db_exec($Sql) or errDie("Unable to insert account creation settings to Cubit.");
db_conn('core');
//Insert Income Account Category
$sql = "INSERT INTO income (catid, catname, div) VALUES ('I' || nextval('income_seq'), 'Income', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add income Category to Database.");
# Get last inserted id for new cat
$catid = pglib_getlastid("income_seq");
$catid = "I" . $catid;
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('1000', '000', 'Sales','I', '{$catid}', 'f', 'sales', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$sales_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '1000', '000', 'Sales', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('1100', '000', 'Point of Sale - Sales','I', '{$catid}', 'f', 'sales', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$pos_sales_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '1100', '000', 'Point of Sale - Sales', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('1150', '000', 'Interest Received','I', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$interest_received_acc = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '1150', '000', 'Interest Received', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('1200', '000', 'Sundry Income','I', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '1200', '000', 'Sundry Income', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('1250', '000', 'Exchange Rate Profit/Loss','I', '{$catid}', 'f', 'other_income', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '1250', '000', 'Exchange Rate Profit/Loss', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
//Insert Expense Account Category
$sql = "INSERT INTO expenditure (catid, catname, div) VALUES ('E' || nextval('expenditure_seq'),'Expenditure', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add expense Category to Database.");
/*
$sql = "SELECT * FROM expenditure";
$catRslt = db_exec($sql) or errDie("Could not retrieve expense Categories Information from the Database.");
$rows = pg_numrows($catRslt);
if($rows < 1){
return "There are no Account Categories under expen";
}
$cat = pg_fetch_array($catRslt);
$catid=$cat['catid'];
*/
# Get last inserted id for new cat
$catid = pglib_getlastid("expenditure_seq");
$catid = "E" . $catid;
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('2150', '000', 'Cost of Sales','E', '{$catid}', 'f', 'cost_of_sales', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$cost_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2150', '000', 'Cost of Sales', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2510', '000', 'Pension','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$pension_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2510', '000', 'Pension', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2520', '000', 'Retirement Annuity Fund','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$retiree_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2520', '000', 'Retirement Annuity Fund', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2530', '000', 'Provident Fund','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$providente_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2530', '000', 'Provident Fund', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2540', '000', 'Medical Aid','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$medical_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2540', '000', 'Medical Aid', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('2160', '000', 'Cost Variance','E', '{$catid}', 'f', 'cost_of_sales', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$costvar_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2160', '000', 'Cost Variance', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('2170', '000', 'Variance','E', '{$catid}', 'f', 'cost_of_sales', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$salesvar_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2170', '000', 'Variance', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2500', '000', 'Salaries and Wages','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$salaries_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2500', '000', 'Salaries and Wages', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2550', '000', 'Salaries - Commission','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$commision_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2550', '000', 'Salaries - Commission', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2560', '000', 'UIF','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$uifexp = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2560', '000', 'UIF', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2570', '000', 'SDL','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$sdlexp = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2570', '000', 'SDL', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2000', '000', 'Accounting Fees','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2000', '000', 'Accounting Fees', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2050', '000', 'Advertising and Promotions','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2050', '000', 'Advertising and Promotions', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2100', '000', 'Bank Charges','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2100', '000', 'Bank Charges', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2200', '000', 'Depreciation','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2200', '000', 'Depreciation', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2250', '000', 'Electricity and Water','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2250', '000', 'Electricity and Water', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2300', '000', 'General Expenses','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2300', '000', 'General Expenses', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2350', '000', 'Insurance','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2350', '000', 'Insurance', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2400', '000', 'Interest Paid','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2400', '000', 'Interest Paid', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2450', '000', 'Printing and Stationery','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2450', '000', 'Printing and Stationery', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2650', '000', 'Rent Paid','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2650', '000', 'Rent Paid', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, div) VALUES ('2600', '000', 'Telephone and Fax','E', '{$catid}', 'f', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2600', '000', 'Telephone and Fax', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('2700', '000', 'POS Rounding','E', '{$catid}', 'f', 'cost_of_sales', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$racc = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2700', '000', 'POS Rounding', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
//Insert Balance Account Category
$sql = "INSERT INTO balance (catid, catname, div) VALUES ('B' || nextval('balance_seq'),'Balance', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add balance Category to Database.");
/*
$sql = "SELECT * FROM balance";
$catRslt = db_exec($sql) or errDie("Could not retrieve income Categories Information from Cubit.");
$rows = pg_numrows($catRslt);
if($rows < 1){
return "There are no Account Categories under income";
}
$cat = pg_fetch_array($catRslt);
$catid=$cat['catid'];
*/
# Get last inserted id for new cat
$catid = pglib_getlastid("balance_seq");
$catid = "B" . $catid;
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6400', '000', 'Customer Control Account','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$deptors_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6400', '000', 'Customer Control Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6500', '000', 'Supplier Control Account','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$creditors_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6500', '000', 'Supplier Control Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('7200', '000', 'Cash on Hand','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$pos_cash_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '7200', '000', 'Cash on Hand', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('7300', '000', 'POS Credit Card Control','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$cc = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '7300', '000', 'POS Credit Card Control', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8000', '000', 'VAT Control Account','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$vat_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '8000', '000', 'VAT Control Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8010', '000', 'VAT Input Account','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$vat_in = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '8010', '000', 'VAT Input Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8020', '000', 'VAT Output Account','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$vat_out = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '8020', '000', 'VAT Output Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6350', '000', 'Inventory','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$stock_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6350', '000', 'Inventory', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6300', '000', 'Inventory Suspense Account','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sales Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$stock_control = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6300', '000', 'Inventory Suspense Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add sales Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6600', '000', 'Employees Control Account','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$salary_control_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div ) VALUES('{$accid}', '6600', '000', 'Employees Control Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add salaries control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8400', '000', 'Pension Payable','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$pensionc_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div ) VALUES('{$accid}', '8400', '000', 'Pension Payable', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add salaries control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8500', '000', 'Medical Aid Payable','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$medicalc_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div ) VALUES('{$accid}', '8500', '000', 'Medical Aid Payable', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add salaries control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8600', '000', 'Retirement Annuity Fund Payable','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$retire_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div ) VALUES('{$accid}', '8600', '000', 'Retirement Annuity Fund Payable', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add salaries control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8700', '000', 'Provident Fund Payable','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$provident_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div ) VALUES('{$accid}', '8700', '000', 'Provident Fund Payable', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add salaries control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8100', '000', 'PAYE Payable','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$paye_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '8100', '000', 'PAYE Payable', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add salaries control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8200', '000', 'UIF Payable','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$uif_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '8200', '000', 'UIF Payable', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add uif control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('8300', '000', 'SDL Payable','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$sdlbal = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '8300', '000', 'SDL Payable', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add uif control Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6700', '000', 'Employee Loan Account','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add sasalaries control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$loan_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6700', '000', 'Employee Loan Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add loan Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('7000', '000', 'Bank','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$bank_account = $accid;
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '7000', '000', 'Bank', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('5200', '000', 'Retained Income / Accumulated Loss','B', '{$catid}', 'f', 'retained_income', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '5200', '000', 'Retained Income / Accumulated Loss', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('5250', '000', 'Share Capital / Members Contribution','B', '{$catid}', 'f', 'share_capital', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '5250', '000', 'Share Capital / Members Contribution', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('5300', '000', 'Shareholder / Director / Members Loan Account','B', '{$catid}', 'f', 'shareholders_loan', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '5300', '000', 'Shareholder / Director / Members Loan Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6000', '000', 'Land & Buildings - Net Value','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6000', '000', 'Land & Buildings - Net Value', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6000', '010', 'Land & Buildings - Cost','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6000', '010', 'Land & Buildings - Cost', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6000', '020', 'Land & Buildings - Accum Depreciation','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6000', '020', 'Land & Buildings - Accum Depreciation', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6100', '020', 'Motor Vehicle - Accum Depreciation','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6100', '020', 'Motor Vehicle - Accum Depreciation', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6100', '000', 'Motor Vehicle - Net Value','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6100', '000', 'Motor Vehicle - Net Value', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6100', '010', 'Motor Vehicle - Cost','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6100', '010', 'Motor Vehicle - Cost', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6150', '000', 'Computer Equipment - Net Value','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6150', '000', 'Computer Equipment - Net Value', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6150', '010', 'Computer Equipment - Cost','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6150', '010', 'Computer Equipment - Cost', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6150', '020', 'Computer Equipment - Accum Depreciation','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6150', '020', 'Computer Equipment - Accum Depreciation', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6160', '000', 'Office Equipment - Net Value','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6160', '000', 'Office Equipment - Net Value', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6160', '010', 'Office Equipment - Cost','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6160', '010', 'Office Equipment - Cost', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6160', '020', 'Office Equipment - Accum Depreciation','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6160', '020', 'Office Equipment - Accum Depreciation', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6170', '000', 'Furniture & Fittings - Net Value','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6170', '000', 'Furniture & Fittings - Net Value', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6170', '010', 'Furniture & Fittings - Cost','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6170', '010', 'Furniture & Fittings - Cost', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('6170', '020', 'Furniture & Fittings - Accum Depreciation','B', '{$catid}', 'f', 'fixed_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '6170', '020', 'Furniture & Fittings - Accum Depreciation', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('7100', '000', 'Petty Cash','B', '{$catid}', 'f', 'current_asset', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
$pettya = $accid;
# Insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '7100', '000', 'Petty Cash', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# Write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('9000', '000', 'Opening Balances / Suspense Account','B', '{$catid}', 'f', 'current_liability', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add bank control Account to Database.", SELF);
# Get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# Insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '9000', '000', 'Opening Balances / Suspense Account', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add bank Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Begin sql transaction
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
# Write to DB
$sql = "INSERT INTO accounts (topacc, accnum, accname, acctype, catid, vat, toptype, div) VALUES ('2800', '000', 'Normal Tax','E', 'E10', 'f', 'tax', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add Normal Tax Account to Database.", SELF);
# Get last inserted id for new acc
$accid = pglib_lastid("accounts", "accid");
# Insert account into trial Balance
$query = "INSERT INTO trial_bal(accid, topacc, accnum, accname, vat, div) VALUES('{$accid}', '2800', '000', 'Normal Tax', 'f', '{$div}')";
$trialRslt = db_exec($query) or errDie("Unable to add Normal Tax Account to Database.", SELF);
# Commit sql transaction
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
$sql = "SELECT * FROM bankacc WHERE name = 'Petty Cash' AND div = '{$div}'";
$checkRslt = db_exec($sql) or errDie("Unable to retrieve Petty Cash Account details from database.");
if (pg_numrows($checkRslt) > 0) {
$link = "UPDATE bankacc SET accnum='{$pettya}' WHERE name = 'Petty Cash', '{$div}'";
} else {
$link = "INSERT INTO bankacc(name, accnum, div) VALUES('Petty Cash', '{$pettya}', '{$div}')";
}
$linkRslt = db_exec($link) or errDie("Unable to add Petty Cash Account link to Database.", SELF);
# Check if year has been opened
core_connect();
$sql = "SELECT * FROM active";
$cRs = db_exec($sql) or errDie("Database Access Failed - check year open.", SELF);
if (pg_numrows($cRs) < 1) {
/* Skip Period Management */
# Empty the year name table
$sql = "DELETE FROM year";
$rslt = db_exec($sql);
for ($i = 1; $i <= 10; $i++) {
$sql = "INSERT INTO year VALUES('y" . ($selyear + $i - 1) . "', 'yr{$i}', 'n', '{$div}')";
$rslt = db_exec($sql) or errDie("Could not set year name in Cubit", SELF);
}
$yrname = "y{$selyear}";
$endmon = $smonth - 1;
if (intval($endmon == 0)) {
$endmon = 12;
}
$Sql = "TRUNCATE range";
$Rs = db_exec($Sql) or errDie("Unable to empty year range", SELF);
$firstmonth = $smonth;
$activeyear = $yrname;
$sql = "INSERT INTO range(\"start\", \"end\", div) VALUES('{$smonth}', '{$endmon}', '{$div}')";
$Rslt = db_exec($sql) or errDie("Unable to insert year range", SELF);
$sql = "SELECT * FROM year WHERE yrname='{$yrname}'";
$yrs = db_exec($sql);
$yr = pg_fetch_array($yrs);
if ($yr['closed'] == 'y') {
return "<center><li class=err>ERROR : The Selected Financial year : <b>{$yrname}</b> has been closed.\n\t\t\t<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
}
$yrdb = $yr['yrdb'];
$sql = "SELECT * FROM range";
$Rslt = db_exec($sql);
if (pg_numrows($Rslt) < 1) {
$OUTPUT = "<center><li class=err>ERROR : The Financial year Period range was not found on Database, Please make sure that everything is set during instalation.";
require "template.php";
}
$range = Pg_fetch_array($Rslt);
// Months array
$months = array("1", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$sql = "UPDATE active SET yrdb = '{$yrdb}', yrname = '{$yrname}', prddb = '{$range['start']}', prdname='" . $months[$range['start']] . "' WHERE div = '{$div}'";
$rslt = db_exec($sql) or errDie("Could not Set Next Year Database and Name", SELF);
if (pg_cmdtuples($rslt) < 1) {
$sql = "INSERT INTO active (yrdb, yrname, prddb, prdname, div) VALUES ('{$yrdb}', '{$yrname}', '{$range['start']}', '" . $months[$range['start']] . "', '{$div}')";
$rslt = db_exec($sql) or errDie("Could not Set Next Year Database and Name", SELF);
}
/* Skiped the period management stuff */
} else {
$firstmonth = $smonth;
}
$link = "INSERT INTO pchsacc(name, accnum, div) VALUES('Cost Variance', '{$costvar_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "DELETE FROM salesacc WHERE name='VAT' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salesacc(name, accnum, div) VALUES('VAT', '{$vat_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add vat Account link to Database.", SELF);
$link = "DELETE FROM salesacc WHERE name='rounding' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salesacc(name, accnum, div) VALUES('rounding', '{$racc}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add vat Account link to Database.", SELF);
$link = "DELETE FROM salesacc WHERE name='VATIN' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salesacc(name, accnum, div) VALUES('VATIN', '{$vat_in}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add vat Account link to Database.", SELF);
$link = "DELETE FROM salesacc WHERE name='VATOUT' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salesacc(name, accnum, div) VALUES('VATOUT', '{$vat_out}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add vat Account link to Database.", SELF);
$link = "DELETE FROM salesacc WHERE name='sales_variance' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salesacc(name, accnum, div) VALUES('sales_variance', '{$salesvar_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add vat Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='salaries' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('salaries', '{$salaries_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='cash' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('cash', '{$pos_cash_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='cc' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('cc', '{$cc}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='salaries control' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('salaries control', '{$salary_control_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('salaries control original', '{$salary_control_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='Commision' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('Commission', '{$commision_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='PAYE' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('PAYE', '{$paye_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='UIF' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('UIF', '{$uif_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='loanacc' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('loanacc', '{$loan_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='uifexp' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('uifexp', '{$uifexp}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='uifbal' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('uifbal', '{$uif_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='sdlexp' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('sdlexp', '{$sdlexp}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='sdlbal' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('sdlbal', '{$sdlbal}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='pensionexpense' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('pensionexpense', '{$pension_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='interestreceived' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete interest received Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('interestreceived', '{$interest_received_acc}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add interest received link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='medicalexpense' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('medicalexpense', '{$medical_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('retire', '{$retire_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('retireexpense', '{$retiree_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('provident', '{$provident_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Provident Fund Payable link to Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('providentexpense', '{$providente_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Provident Fund Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='pension' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('pension', '{$pensionc_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
$link = "DELETE FROM salacc WHERE name='medical' AND div = '{$div}'";
$linkRslt = db_exec($link) or errDie("Unable to delete vat Account link from Database.", SELF);
$link = "INSERT INTO salacc(name, accnum, div) VALUES('medical', '{$medicalc_account}', '{$div}')";
$linkRslt = db_exec($link) or errDie("Unable to add Salaries Account link to Database.", SELF);
db_conn("exten");
$sql = "INSERT INTO departments(deptno, deptname, incacc, debtacc, credacc, pia, pca, div) VALUES ('1', 'Ledger 1', '{$sales_account}', '{$deptors_account}', '{$creditors_account}', '{$pos_sales_account}', '{$pos_cash_account}', '{$div}')";
$deptRslt = db_exec($sql) or errDie("Unable to add deparment to system.", SELF);
$sql = "INSERT INTO salespeople(salespno, salesp, div) VALUES ('1', 'General', '{$div}')";
$salespRslt = db_exec($sql) or errDie("Unable to add warehouse to system.", SELF);
$sql = "INSERT INTO categories(category, div) VALUES ('General', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add category to system.", SELF);
$sql = "INSERT INTO class(classname, div) VALUES ('General', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add fringe benefit to system.", SELF);
$sql = "INSERT INTO warehouses(whno, whname, stkacc, cosacc, conacc, div) VALUES ('1', 'Store 1', '{$stock_account}', '{$cost_account}', '{$stock_control}', '{$div}')";
$whouseRslt = db_exec($sql) or errDie("Unable to add warehouse to system.", SELF);
$whid = pglib_lastid("warehouses", "whid");
$sql = "INSERT INTO pricelist(listname, div) VALUES ('Standard', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to price list to system.", SELF);
db_conn("cubit");
$sql = "INSERT INTO stockcat(catcod, cat, descript, div) VALUES('1', 'General', 'General Stock Category', '{$div}')";
$rslt = db_exec($sql) or errDie("Unable to insert stock category to Cubit.", SELF);
$sql = "INSERT INTO stockclass(classcode, classname, div) VALUES ('1', 'General', '{$div}')";
$catRslt = db_exec($sql) or errDie("Unable to add class to system.", SELF);
# check if setting exists(default warehouse)
$sql = "SELECT label FROM set WHERE label = 'DEF_WH' AND div = '{$div}'";
$Rslt = db_exec($sql) or errDie("Unable to check database for existing settings.");
if (pg_numrows($Rslt) > 0) {
$Sql = "UPDATE set SET value = '{$whid}', type = 'Default Warehouse' WHERE label = 'DEF_WH' AND div = '{$div}'";
} else {
$Sql = "INSERT INTO set(type, label, value, descript, div) VALUES('Default Warehouse', 'DEF_WH', '{$whid}', '1 Store1', '{$div}')";
}
$setRslt = db_exec($Sql) or errDie("Unable to insert settings to Cubit.");
# Check if setting exists (vat type)
$sql = "SELECT label FROM set WHERE label = 'SELAMT_VAT' AND div = '{$div}'";
$Rslt = db_exec($sql) or errDie("Unable to check database for existing settings.");
if (pg_numrows($Rslt) > 0) {
$Sql = "UPDATE set SET value = 'inc', descript = 'Vat Inclusive' WHERE label = 'SELAMT_VAT' AND div = '{$div}'";
} else {
$Sql = "INSERT INTO set(type, label, value, descript, div) VALUES('Vat type on stock selling price', 'SELAMT_VAT', 'inc', 'Vat Inclusive', '{$div}')";
}
$setRslt = db_exec($Sql) or errDie("Unable to insert settings to Cubit.");
# begin sql transaction
# pglib_transaction ("BEGIN") or errDie("Unable to start a database transaction.",SELF);
$sql = "INSERT INTO bankacct (acctype, bankname, branchname, branchcode, accname, accnum, details, div,btype) VALUES ('Cheque', 'Bank', 'Branch', '000000', 'Account Name', '000000000000', 'Default bank Account', '{$div}','loc')";
$bankAccRslt = db_exec($sql) or errDie("Unable to add bank account to database.");
$accid = pglib_lastid("bankacct", "bankid");
# Commit sql transaction
# pglib_transaction ("COMMIT") or errDie("Unable to finish a database transaction.",SELF);
db_conn("core");
$hook = "INSERT INTO bankacc(accid, accnum, div) VALUES('{$accid}', '{$bank_account}', '{$div}')";
$Rlst = db_exec($hook) or errDie("Unable to add link for for new bank account", SELF);
db_conn("crm");
$Sl = "INSERT INTO links (name,script) VALUES ('Add Client','../customers-new.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('View Client','../customers-view.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('New Invoice','../cust-credit-stockinv.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('Find Invoice','../invoice-search.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('View Stock','../stock-view.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('Add Supplier','../supp-new.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('View Suppliers','../supp-view.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('New Purchase','../purchase-new.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('View Purchases','../purchase-view.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('Add Quote','../quote-new.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('View Invoices','../invoice-view.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('View Quotes','../quote-view.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('Debtors Age Analysis','../reporting/debt-age-analysis.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('Creditors Age Analysis','../reporting/cred-age-analysis.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO links (name,script) VALUES ('Bank Reconciliation','../reporting/bank-recon.php')";
$Ry = db_exec($Sl) or errDie("Unable to insert link.");
$Sl = "INSERT INTO teams (name,div) VALUES ('Sales','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO teams (name,div) VALUES ('Support','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO teams (name,div) VALUES ('Accounts','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO teams (name,div) VALUES ('Company Relations','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO teams (name,div) VALUES ('Purchasing - Supplier Relations','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Product Enquiries','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Place an Order','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Complain','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Account querries','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Delivery or Installation Tracking','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Comment on good service or Remarks','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Ask about employment','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('General','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Potential Supplier','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO tcats (name,div) VALUES ('Product Support','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into teams");
$Sl = "INSERT INTO actions (action) VALUES ('Called - Need to call again.')";
$Ry = db_exec($Sl) or errDie("Unable to insert action.");
$Sl = "INSERT INTO actions (action) VALUES ('Called - Could not get in touch')";
$Ry = db_exec($Sl) or errDie("Unable to insert action.");
$Sl = "INSERT INTO actions (action) VALUES ('Requested more information')";
$Ry = db_exec($Sl) or errDie("Unable to insert action.");
$Sl = "INSERT INTO actions (action) VALUES ('Sent Fax')";
$Ry = db_exec($Sl) or errDie("Unable to insert action.");
$pactivemonth = $activemonth;
$pactivemonth--;
if ($pactivemonth == 0) {
$pactivemonth = 12;
}
$i = 0;
$current = $firstmonth;
$current--;
if ($current == 0) {
$current = 12;
}
while ($current != $pactivemonth) {
$i++;
if ($i > 20) {
break;
}
$current++;
if ($current == 13) {
$current = 1;
}
//close_month('yr1',$current);
}
// //if(is/*set($firstmonth)) {
// $start=$firstmonth;
//
// for($i=1; $i<=12; $i++) {
// if(($i<$activemonth) and ($i>=$start)) {
// close_month('yr1',$i);
// }
// }
// // }
db_conn('core');
$Sl = "SELECT accid FROM accounts WHERE accname='Bank Charges'";
$Ri = db_exec($Sl);
$ad = pg_fetch_array($Ri);
$bc = $ad['accid'];
$Sl = "SELECT accid FROM accounts WHERE accname='Interest Paid'";
$Ri = db_exec($Sl);
$ad = pg_fetch_array($Ri);
$i = $ad['accid'];
$Sl = "SELECT accid FROM accounts WHERE accname='Interest Received'";
$Ri = db_exec($Sl);
$ad = pg_fetch_array($Ri);
$ii = $ad['accid'];
db_conn('exten');
$Sl = "INSERT INTO spricelist (listname,div) VALUES ('Standard','{$div}')";
$Ry = db_exec($Sl) or errDie("Unable to insert into supplier price list.");
db_conn('cubit');
$Sl = "INSERT INTO currency (symbol,descrip,rate,def) VALUES ('R','Rand',0.00,'')";
$Ry = db_exec($Sl) or errDie("Unable to insert currency.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('CASH DEPOSIT FEE','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('FEE CHEQUE CASHED','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('FEE-SPECIAL PRESENTATION','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('SERVICE FEE','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('OVERDRAFT LEDGER FEE','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('INTEREST','i','-','c','{$i}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('INTEREST','i','+','c','{$ii}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('TRANSACTION CHARGE ','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('ADMIN CHARGE','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('GARAGE CRD CHARGES','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('STAMP DUTY','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('BANKING CHARGES','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO statement_refs (ref,dets,pn,action,account,by) VALUES ('01 CASH DEP','i','-','c','{$bc}','Default');";
$Ry = db_exec($Sl) or errDie("Unable to insert data.");
// db_conn('cubit');
//
// $Sl="CREATE INDEX stkid_stock_key ON stock USING btree(stkid);";
// $Ri=db_exec($Sl) or errDie("Unable to index.");
//
// db_conn('core');
//
// $Sl="CREATE INDEX accid_accounts_key ON accounts USING btree(accid);";
// $Ri=db_exec($Sl) or errDie("Unable to index.");
//
// $Sl="CREATE INDEX accid_trial_bal_key ON trial_bal USING btree(accid);";
// $Ri=db_exec($Sl) or errDie("Unable to index.");
//
// /*for($p = 1; $p <=12; $p++){
// db_conn($p);
//
// $Sl="CREATE INDEX accid_accounts_key ON accounts USING btree(accid);";
// $Ri=db_exec($Sl) or errDie("Unable to index.");
//
// $Sl="CREATE INDEX accid_trial_bal_key ON trial_bal USING btree(accid);";
// $Ri=db_exec($Sl) or errDie("Unable to index.");
//
// }*/
db_conn('cubit');
$Sl = "INSERT INTO vatcodes (code,description,del,zero,vat_amount) VALUES ('01','Normal','Yes','No','14');";
$Ri = db_exec($Sl) or errDie("Unabel to insert data.");
$Sl = "INSERT INTO vatcodes (code,description,del,zero,vat_amount) VALUES ('02','Capital Goods','No','No','0');";
$Ri = db_exec($Sl) or errDie("Unabel to insert data.");
$Sl = "INSERT INTO vatcodes (code,description,del,zero,vat_amount) VALUES ('03','Capital Goods','No','Yes','0');";
$Ri = db_exec($Sl) or errDie("Unabel to insert data.");
$Sl = "INSERT INTO vatcodes (code,description,del,zero,vat_amount) VALUES ('04','Zero VAT','No','Yes','0');";
$Ri = db_exec($Sl) or errDie("Unabel to insert data.");
$Sl = "INSERT INTO vatcodes (code,description,del,zero,vat_amount) VALUES ('05','VAT Exempt','No','Yes','0');";
$Ri = db_exec($Sl) or errDie("Unabel to insert data.");
$Sl = "INSERT INTO login_retries (tries, minutes) VALUES ('0', '0');";
$Ri = db_exec($Sl) or errDie("Unabel to insert data.");
$Sl = "INSERT INTO supp_groups (id, groupname) VALUES ('0', '[None]');";
$Ri = db_exec($Sl) or errDie("Unabel to insert data.");
$Sl = "INSERT INTO template_settings (template, filename, div) VALUES ('statements', 'pdf/cust-pdf-stmnt.php', '{$div}');";
$Ri = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO template_settings (template, filename, div) VALUES ('invoices', 'invoice-print.php', '{$div}');";
$Ri = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO template_settings (template, filename, div) VALUES ('reprints', 'default', '{$div}');";
$Ri = db_exec($Sl) or errDie("Unable to insert data.");
$Sl = "INSERT INTO workshop_settings (setting, value, div) VALUES ('workshop_conditions', 'As per display notice.', '{$div}');";
$Ri = db_exec($Sl) or errDie("Unable to insert data.");
db_conn('cubit');
$Sql = "INSERT INTO set(type, label, value, descript, div) VALUES('Block main accounts', 'BLOCK', 'use', 'Block main accounts', '{$div}')";
$Ri = db_exec($Sql);
db_conn('exten');
$Sl = "INSERT INTO ct (days,div) VALUES ('0','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO ct (days,div) VALUES ('7','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO ct (days,div) VALUES ('14','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO ct (days,div) VALUES ('30','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO ct (days,div) VALUES ('60','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO ct (days,div) VALUES ('90','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO ct (days,div) VALUES ('120','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO od (days,div) VALUES ('0','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO od (days,div) VALUES ('7','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO od (days,div) VALUES ('14','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO od (days,div) VALUES ('30','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO od (days,div) VALUES ('60','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO od (days,div) VALUES ('90','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
$Sl = "INSERT INTO od (days,div) VALUES ('120','{$div}')";
$Ri = db_exec($Sl) or errDie("Unable to insert default terms");
db_conn('core');
block();
$catid = createcat("Profit/Loss", $div, "B");
if (createacc("9999", "999", "Profit/Loss account", $catid, "B", "n", $div) > 0) {
return "<li class=err>Failed to create default accounts</li>";
}
// Total Income account (199/999)
$catid = createcat("Total Income", $div, "I");
if (createacc("1999", "999", "Total Income account", $catid, "I", "n", $div) > 0) {
return "<li class=err>Failed to create default accounts</li>";
}
// Total Expenses account (499/999)
$catid = createcat("Total Expenses", $div, "E");
if (createacc("4999", "999", "Total Expenses account", $catid, "E", "n", $div) > 0) {
return "<li class=err>Failed to create default accounts</li>";
}
// Layout
$write = "\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\n\t<tr><th>New Branch added to database</th></tr>\n\t<tr class=datacell><td>New Branch, {$branname} ({$brancod}) has been successfully added to Cubit.</td></tr>\n\t</table>\n\t<p>\n\t<table border=0 cellpadding='2' cellspacing='1'>\n\t\t<tr><th>Quick Links</th></tr>\n\t\t<tr class='bg-odd'><td><a href='admin-branview.php'>View Branches</a></td></tr>\n\t\t<tr class='bg-odd'><td><a href='main.php'>Main Menu</a></td></tr>\n\t</table>";
return $write;
}
