function enter()
{
# check if setting exists
$sql = "SELECT label FROM set WHERE label = 'ACCNEW_LNK'";
$Rslt = db_exec($sql) or errDie("Unable to check database for existing settings.");
if (pg_numrows($Rslt) > 0) {
return printSet();
}
# connect to db
$enter = "<h3>Cubit Settings</h3>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t<form action='" . SELF . "' method=post>\n\t<input type=hidden name=key value=confirm>\n\t\t<tr><th colspan=2>Account Creation</th></tr>\n\t\t<tr class='bg-odd'><td><input type=radio size=20 name=accc value='cubit' checked=yes>Use Cubit Account numbers(No Default accounts)</td>\n\t\t<td><input type=radio size=20 name=accc value='user'>Use user selected account numbers(Can select default accounts)</td></tr>\n\t\t<tr><td><br></td></tr>\n\t\t<tr><td align=right colspan=2><input type=submit value='Continue »'></td></tr>\n\t</form>\n\t</table>\n\t<p>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t\t<tr><th>Quick Links</th></tr>\n\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t</table>";
return $enter;
}
function get_sets()
{
db_conn('cubit');
# Check if setting exists
$sql = "SELECT value FROM set WHERE label = 'ACCNEW_LNK'";
$Rslt = db_exec($sql) or errDie("Unable to check database for existing settings.");
if (pg_numrows($Rslt) > 0) {
$set = pg_fetch_array($Rslt);
if ($set['value'] == 'acc-new.php') {
return printSet();
}
}
core_connect();
$sql = "SELECT accname FROM accounts WHERE accnum != '999' AND div = '" . USER_DIV . "'";
$Rslt = db_exec($sql) or errDie("Unable to check database for existing accounts.");
if (pg_numrows($Rslt) > 0) {
$acc = "\n\t\t<center>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<td><li class='err'>ERROR : There are accounts in Cubit</li></td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<th>Note : </th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Quick Setup can only be run on a new cubit installation.</td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t</table>\n \t<p>\n\t\t<table " . TMPL_tblDflts . " width='15%'>\n \t" . TBL_BR . "\n \t<tr>\n \t\t<th>Quick Links</th>\n \t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $acc;
}
$month = 1;
$months = array("1", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$smonth = "<select name='smonth'>";
while ($month <= 12) {
if ($month == 3) {
$sel = "selected";
} else {
$sel = "";
}
$smonth .= "<option {$sel} value='{$month}'>{$months[$month]}</option>";
$month++;
}
$smonth .= "</select>";
$mdat = date("m");
$mdat += 0;
if ($mdat > 2) {
$plus = 1;
} else {
$plus = 0;
}
$amonth = 1;
$amonths = array("1", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$asmonth = "<select name='activemonth'>";
while ($amonth <= 12) {
if ($amonth == $mdat) {
$sel = "selected";
} else {
$sel = "";
}
$asmonth .= "<option {$sel} value='{$amonth}'>{$amonths[$amonth]}</option>";
$amonth++;
}
$asmonth .= "</select>";
$asmonth = "<input type='hidden' name='activemonth' value='1'>";
$selyear = "<select name='selyear'>";
for ($i = 1971; $i <= 2027; $i++) {
if ($i == date("Y") + $plus) {
$sel = "selected";
} else {
$sel = "";
}
$selyear .= "<option {$sel} value='{$i}'>{$i}</option>";
}
$selyear .= "</select>";
# 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) {
$monset = "\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Financial Years Start in</td>\n\t\t\t\t\t\t<td valign='center'>{$smonth}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t";
} else {
$act = pg_fetch_array($cRs);
$monset = "\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Financial Years Start in</td>\n\t\t\t\t\t\t<td valign='center'><input type='hidden' name='smonth' value='{$act['prddb']}'>" . $months[$act['prddb']] . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t";
}
$sets = "\n\t\t\t<h3>Setup</h3>\n\t\t\t<br>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t\t<input type='hidden' name='key' value='write' />\n\t\t\t\t<input type='hidden' name='yr1' value='y2003' />\n\t\t\t\t<input type='hidden' name='yr2' value='y2004' />\n\t\t\t\t<input type='hidden' name='yr3' value='y2005' />\n\t\t\t\t<input type='hidden' name='yr4' value='y2006' />\n\t\t\t\t<input type='hidden' name='yr5' value='y2007' />\n\t\t\t\t<input type='hidden' name='yr6' value='y2008' />\n\t\t\t\t<input type='hidden' name='yr7' value='y2009' />\n\t\t\t\t<input type='hidden' name='yr8' value='y2010' />\n\t\t\t\t<input type='hidden' name='yr9' value='y2011' />\n\t\t\t\t<input type='hidden' name='yr10' value='y2012' />\n\t\t\t\t<tr>\n\t\t\t\t\t<th colspan='2'>Please Select the Following</th>\n\t\t\t\t</tr>\n\t\t\t\t{$monset}\n\t\t\t\t{$asmonth}\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Select Financial Year to Start At:</td>\n\t\t\t\t\t<td>{$selyear}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Select Installation Type:</td>\n\t\t\t\t\t<td>HQ (Default) <input type='radio' name='inst_mode' value='hq' checked='yes'> Branch <input type='radio' name='inst_mode' value='branch'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Auto Setup »'></td>\n\t\t\t\t</tr>\n\t\t\t</form>\n\t\t\t</table>\n\t\t\t<p>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t</tr>\n\t\t\t</table>";
return $sets;
}
#http://www.accounting-123.com/a.php?a=153/GPLv3
#
#
#
#
#
#
#
#
#
#
#
// Get global variables & functions
require "settings.php";
// Show current users
$OUTPUT = printSet();
require "template.php";
// Prints a form to enter new stock details into
function printSet()
{
// Connect to database
Db_Connect();
// Query server
$sql = "SELECT * FROM set WHERE div = '" . USER_DIV . "'";
$rslt = db_exec($sql) or errDie("ERROR: Unable to view settings", SELF);
// Die with custom error if failed
if (pg_numrows($rslt) < 1) {
$OUTPUT = "<li class=err> No Setting currently in database.";
} else {
// Set up table to display in
$OUTPUT = "\n\t\t<h3>View Current Settings</h3>\n\t\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width=300>\n\t\t<tr><th>Setting Type</th><th>Current Setting</th></tr>";
