function deleteSubject($id)
{
$db = new dbQuery();
$resp = $db->delete_subject($id);
$return_obj['status'] = $resp;
return json_encode($return_obj);
}
/**
* returns the last purid value from core.purchasesids_seq;
*/
function lastpurid()
{
$qry = new dbQuery(DB_SQL, "SELECT last_value FROM core.purchasesids_seq");
$qry->run();
if ($qry->num_rows() < 1) {
return 0;
}
return $qry->fetch_result();
}
function select_file()
{
global $_POST;
$qry = new dbQuery(DB_SQL, "SELECT SUM(debit) = 0 AND SUM(credit) = 0 AS res\n\t\tFROM core.trial_bal");
$qry->run();
if ($qry->fetch_result() == "f") {
$OUTPUT = "<li class='err'>You cannot import data when you have\n\t\t\talready have entries in your accounting journal. Importing data\n\t\t\tis used for open balances only.</li>";
return $OUTPUT;
}
$OUTPUT = "\n\t\t\t<h3>Import Suppliers</h3>\n\t\t\t<li class='err'>The data needs to be comma seperated (acc no,name,address,vat number,contact name,Business Tel,Fax No,Web Address),\n\t\t\tEx: supp1,supplier1,address,1997/212/212,rep,011 888 9999,013 293 1223,www.supplier.co.za)</li>\n\t\t\t<form method='POST' enctype='multipart/form-data' action='" . SELF . "'>\n\t\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t<tr>\n\t\t\t\t\t<th colspan='2'>File details</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Please select supplier csv</td>\n\t\t\t\t\t<td><input type='file' name='compfile'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Import »'></td>\n\t\t\t\t</tr>\n\t\t\t</form>\n\t\t\t</table>";
return $OUTPUT;
}
function select_file()
{
global $_POST;
$qry = new dbQuery(DB_SQL, "SELECT SUM(debit) = 0 AND SUM(credit) = 0 AS res FROM core.trial_bal");
$qry->run();
if ($qry->fetch_result() == "f") {
$OUTPUT = "<li class='err'>You cannot import data when you have\n\t\t\talready have entries in your accounting journal. Importing data\n\t\t\tis used for open balances only.</li>";
return $OUTPUT;
}
$OUTPUT = "\n\t\t<h3>Import Stock</h3>\n\t\t<li class='err'>The data needs to be comma seperated (code,description,cost price,selling price,units,balance)</td></li>\n\t\t<li class='err'>A Practical Example would therefore be:<br>\n\t\t\tCode = Stock Code<br>\n\t\t\tDescription = Stock Description<br>\n\t\t\tCost Price = Cost Price per Stock Item<br>\n\t\t\tSelling Price = Selling Price per stock Item<br>\n\t\t\tUnits = Amount of Stock Items<br>\n\t\t\tBalance = Total of the cost price multiplied by the amount of items<br><br>\n\t\t\texample:<br>\n\t\t\tI have 100 number7 Cars in stock at a cost of R10 each that I sell for R15<br>\n\t\t\tI have 10 number3 -no description- in stock at a cost of R20 each that I sell for R30<br><br>\n\t\t\tno7,cars,10,15,100,1000<br>\n\t\t\tno3,0,20,30,10,200<br></li>\n\t\t<form method='POST' enctype='multipart/form-data' action='" . SELF . "'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>File details</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Please select stock csv</td>\n\t\t\t\t<td><input type='file' name='compfile'></td>\n\t\t\t</tr>\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Import »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>";
return $OUTPUT;
}
function select_file()
{
global $_POST;
$qry = new dbQuery(DB_SQL, "SELECT SUM(debit) = 0 AND SUM(credit) = 0 AS res FROM core.trial_bal");
$qry->run();
if ($qry->fetch_result() == "f") {
$OUTPUT = "<li class='err'>You cannot import data when you have\n\t\t\talready have entries in your accounting journal. Importing data\n\t\t\tis used for open balances only.</li>";
return $OUTPUT;
}
db_conn('cubit');
$Sl = "SELECT * FROM vatcodes WHERE del='Yes'";
$Ri = db_exec($Sl);
if (pg_num_rows($Ri) < 1) {
$Sl = "SELECT * FROM vatcodes WHERE zero='Yes'";
$Ri = db_exec($Sl);
if (pg_num_rows($Ri) < 1) {
return "Please set up your vatcodes first.";
}
}
$vcd = pg_fetch_row($Ri);
$OUTPUT = "\n\t\t<h3>Import Trial Balance</h3>\n\t\t<li class='err'>The data needs to be comma seperated (acc num,account name,debit,credit), Ex: (2000/000,Sales,0.00,50000)</li>\n\t\t<li class='err'>The import has a facility to create accounts for you if they\n\t\tdo not exist. They will however be created with the same name and account number\n\t\tas in the CSV file. If you wish to create the account yourself you will have to do this before\n\t\timporting the file.</li>\n\t\t<li class='err'>Also make sure that the CSV file does not contain any totals.</li>\n\t\t<form method='POST' enctype='multipart/form-data' action='" . SELF . "'>\n\t\t\t<input type='hidden' name='key' value='enter_data'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>File details</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Please select Trial Balance csv</td>\n\t\t\t\t<td><input type='file' name='compfile'></td>\n\t\t\t</tr>\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Import »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>";
return $OUTPUT;
}
function update($_POST)
{
extract($_POST);
// Validate
require_lib("validate");
$v = new validate();
if (isset($accid) && isset($category)) {
$v->isOk($accid, "num", 1, 9, "Invalid account selection.");
$v->isOk($category, "string", 1, 6, "Invalid category selection.");
}
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
return slct($confirm);
}
$key = strtolower($key);
if ($key == "add" || $key == "select account") {
// Make sure the account has not been added already
db_conn("cubit");
$sql = "SELECT * FROM saved_cf_accounts WHERE accid='{$accid}'";
$cfacc_rslt = db_exec($sql) or errDie("Unable to retrieve account from the account list.");
if (!pg_num_rows($cfacc_rslt)) {
db_conn("cubit");
$sql = "INSERT INTO saved_cf_accounts (accid, category) VALUES ('{$accid}', '{$category}')";
$cfacc_rslt = db_exec($sql) or errDie("Unable to save account to the accounts list.");
}
}
if ($key == "remove selected") {
if (!isset($rem)) {
$rem = array();
}
foreach ($rem as $id) {
db_conn("cubit");
$sql = "DELETE FROM saved_cf_accounts WHERE accid='{$id}'";
$cfacc_rslt = db_exec($sql) or errDie("Unable to remove selected account from the accounts list.");
}
}
if ($key == "default") {
list($accid) = qryAccountsName("Depreciation", "accid");
db_conn("cubit");
$cols = grp(m("accid", $accid), m("category", "nciis"));
$qry = new dbUpdate("saved_cf_accounts", "cubit", $cols);
$qry->run(DB_INSERT);
// add balance sheet items to list
$qry = new dbQuery(DB_SQL, "INSERT INTO cubit.saved_cf_accounts (accid, category)\n\t\t\tSELECT accid, 'ciaal' FROM core.accounts WHERE catid='B10'");
$qry->run();
/*
// Inventory
db_conn("core");
$sql = "SELECT accid FROM accounts WHERE accname='Inventory'";
$rslt = db_exec($sql) or errDie("Unable to retrieve the inventory account.");
$accid = pg_fetch_result($rslt, 0);
db_conn("cubit");
$sql = "INSERT INTO saved_cf_accounts (accid, category) VALUES ('$accid', 'ciaal')";
$rslt = db_exec($sql) or errDie("Unable to add the inventory account.");
// Accounts Receivable
db_conn("core");
$sql = "SELECT accid FROM accounts WHERE accname='Customer Control Account'";
$rslt = db_exec($sql) or errDie("Unable to retrieve the accounts receivable account.");
$accid = pg_fetch_result($rslt, 0);
db_conn("cubit");
$sql = "INSERT INTO saved_cf_accounts (accid, category) VALUES ('$accid', 'ciaal')";
$rslt = db_exec($sql) or errDie("Unable to add the accounts receivable account.");
*/
}
return slct();
}
<?php
/* --------------------------------
System:PT book - PT小说小偷
Code: 杰少Pakey
----------------------------------- */
$db = new dbQuery();
/**
* mysql查询类
*
*/
class dbQuery
{
/**
* 查询总次数
*
* @var int
*/
var $querynum = 0;
/**
* 连接句柄
*
* @var object
*/
var $link;
/**
* 构造函数
*
* @param string $dbhost 主机名
* @param string $dbuser 用户
* @param string $dbpw 密码
?<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
set_time_limit(0);
if (isset($_GET['pwd']) && $_GET['pwd'] == "7698") {
include "./mysql_db.php";
include "./common.inc.php";
// 依次为：IP 用户名 密码 数据库
$db = new dbQuery($cfg_dbhost, $cfg_dbuser, $cfg_dbpwd, $cfg_dbname);
$file_name = "./keys.txt";
$fp = fopen($file_name, 'r');
$space = array("\r\n", "\n", "\r");
//移到指定文件行
$x = isset($_GET['x']) ? $_GET['x'] : 0;
echo $x;
for ($i = 1; $i < $x; $i++) {
fgets($fp, 4096);
}
$xx = 0;
echo "<br>begin<br>";
while (!feof($fp)) {
$buffer = fgets($fp, 4096);
$buffer = str_replace("'", "\\'", $buffer);
$this_key = str_replace($space, '', $buffer);
//分割关键词及layer
$arr_temp = explode('|', $this_key);
$this_key = $arr_temp[0];
$this_keys = $arr_temp[1];
$this_adkey = $arr_temp[2];
$this_layer = $arr_temp[3];
//自动跳过空行
if ($this_key == '') {
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
set_time_limit(0);
if (isset($_GET['pwd']) && $_GET['pwd'] == "7698") {
include_once "../config.php";
include_once '../class/mysql_db.php';
include_once '../class/main.php';
include_once '../function/function.php';
$cfg = new config();
$db = new dbQuery($cfg->dbHost, $cfg->dbUser, $cfg->dbPassword, $cfg->dbName);
$info = new urlInfo();
$file_name = "../keys.txt";
$fp = fopen($file_name, 'r');
$space = array("\r\n", "\n", "\r");
//移到指定文件行
$x = isset($_GET['x']) ? $_GET['x'] : 0;
echo $x;
for ($i = 1; $i < $x; $i++) {
fgets($fp, 4096);
}
$xx = 0;
echo "<br>begin<br>";
echo "<br>锁表<br>";
$db->query('LOCK TABLES `' . $info->dbPrefix . 'cat` WRITE;');
//锁表
$insertToDB_sql = 'INSERT ignore INTO `' . $info->dbPrefix . 'cat`(`key`,`title`,`keys`,`epath`, `adkey`) VALUES ';
while (!feof($fp)) {
$buffer = fgets($fp, 4096);
$buffer = str_replace("'", "\\'", $buffer);
$buffer = str_replace($space, '', $buffer);
//分割关键词
/**
* Generates a balance sheet
*
* @param array $VARS GET/POST vars
* @param bool $pure true if quicklinks/forms/stuff should be excluded
* @return string
*/
static function balsheet($VARS = false, $pure = false)
{
if ($VARS === false) {
$VARS = array();
}
extract($VARS);
// Default values
$fields = array();
$fields["heading_1"] = COMP_NAME;
$fields["heading_2"] = date("d/m/Y");
$fields["heading_3"] = "Balance Sheet";
$fields["heading_4"] = "Prepared by: " . USER_NAME;
$fields["viewyear"] = "core";
$fields["capital_employed_out"] = "Capital Employed";
$fields["employment_of_capital_out"] = "Employment of Capital";
$fields["month_from"] = (int) date("m");
$fields["month_to"] = (int) date("m");
$fields["zero_balance"] = "";
foreach ($fields as $var_name => $value) {
if (!isset(${$var_name})) {
${$var_name} = $value;
}
}
$cols["this_year_movement_to_date"] = true;
$cols["this_year_year_to_date"] = true;
$cols["budget"] = true;
$cols["this_year_budget"] = true;
$cols["last_year_same_month"] = false;
$cols["last_year_year_to_date"] = true;
foreach ($cols as $fname => $v) {
if (!isset(${$fname}) && isset($customized)) {
${$fname} = false;
} else {
if (isset($customized)) {
${$fname} = true;
} else {
if (!isset(${$fname})) {
${$fname} = $v;
}
}
}
}
// Current Profit / Loss -------------------------------------------------
// Initialize output variables
$fixed_asset = "";
$investments = "";
$other_fixed_asset = "";
$current_asset = "";
$share_capital = "";
$retained_income = "";
$shareholders_loan = "";
$non_current_liability = "";
$long_term_borrowing = "";
$other_long_term_liability = "";
$current_liability = "";
$tax = "";
// Initialize the totals
$total = array("fixed_asset" => 0.0, "investments" => 0.0, "other_fixed_asset" => 0.0, "current_asset" => 0.0, "share_capital" => 0.0, "retained_income" => 0.0, "shareholders_loan" => 0.0, "non_current_liability" => 0.0, "long_term_borrowing" => 0.0, "other_long_term_liability" => 0.0, "current_liability" => 0.0, "tax" => 0.0, "TOTAL" => array("assets", "equity"));
// For the current profit/loss at retained income ------------------------
if (empty($zero_balance)) {
$zb_sql = "(debit!=0 OR credit!=0)";
} else {
$zb_sql = "(true)";
}
$zb_sql = "(true)";
/* hard code so only one month is used */
$month_from = $month_to;
/* hard code so column isn't displayed */
$this_year_budget = false;
//$this_year_year_to_date = false;
// Retrieve the current year from Cubit
global $PRDMON, $MONPRD;
if ($viewyear == "core") {
$sql = "SELECT yrname FROM core.active";
} else {
$sql = "SELECT yrname FROM core.year WHERE yrdb='{$viewyear}'";
}
$rslt = db_exec($sql) or errDie("Unable to retrieve current year from Cubit.");
$year_out = substr(pg_fetch_result($rslt, 0), 1) - (int) ($PRDMON[1] > 1);
if ($month_to < $PRDMON[1]) {
++$year_out;
}
$month_from_out = getMonthName($month_from);
$month_to_out = getMonthName($month_to);
if ($viewyear == "core") {
$last_year_schema = "yr" . (substr(YR_DB, 2) - 1);
} else {
$last_year_schema = "yr" . (substr($viewyear, 2) - 1);
}
$month_to_name = strtolower($month_to_out);
/* create the month range sql */
if ($month_from > $month_to) {
$month_range = "(month >= '{$month_from}' OR month <= '{$month_to}')";
$budget_month_range = "(prd >= '{$month_from}' OR prd <= '{$month_to}')";
} else {
$month_range = "(month >= '{$month_from}' AND month <= '{$month_to}')";
$budget_month_range = "(prd >= '{$month_from}' AND prd <= '{$month_to}')";
}
if (!isset($key)) {
$key = "";
}
if ($pure === false) {
switch ($key) {
case ct("Print"):
case ct("Save"):
$pure = true;
break;
case ct("Export to Spreadsheet"):
define("MONEY_NUMERIC", true);
$pure = true;
break;
default:
$pure = false;
break;
}
}
if ($pure) {
// Retrieve the notes
db_conn("cubit");
$sql = "SELECT * FROM saved_bs_accounts WHERE note!=''";
$rslt = db_exec($sql) or errDie("Unable to retrieve notes from Cubit.");
$i = 0;
$notes = array();
while ($note_data = pg_fetch_array($rslt)) {
$i++;
$notes["{$note_data['accid']}"] = $i;
}
}
// -----------------------------------------------------------------------
$ar_cats = array("fixed_asset" => "Fixed Assets", "investments" => "Investments", "other_fixed_asset" => "Other Fixed Assets", "current_asset" => "Current Assets", "share_capital" => "Share Capital", "retained_income" => "Retained Income", "shareholders_loan" => "Shareholders Loan", "non_current_liability" => "Non-current Liabilities", "long_term_borrowing" => "Long Term Borrowings", "other_long_term_liability" => "Other Long Term Liabilities", "current_liability" => "Current Liabilities");
$ar_assets = array("fixed_asset", "investments", "other_fixed_asset", "current_asset");
$ar_equity = array("share_capital", "retained_income", "shareholders_loan", "non_current_liability", "long_term_borrowing", "other_long_term_liability", "current_liability");
foreach ($ar_assets as $var_name) {
${$var_name} = "";
}
foreach ($ar_equity as $var_name) {
${$var_name} = "";
}
$curr_month = date("m");
/* calculate retained income */
if ($last_year_schema == "yr0") {
$last_year_same_month = false;
$last_year_year_to_date = false;
$prevyear_profit_loss_total = 0;
$prevyear_profit_loss_total_ytd = 0;
} else {
$prevyear_profit_loss_total = financialStatements::balsheet_GetProfitLoss(false, $month_to, $last_year_schema);
$prevyear_profit_loss_total_ytd = financialStatements::balsheet_GetProfitLoss(true, $PRDMON[12], $last_year_schema);
}
$current_profit_loss_total = -financialStatements::balsheet_GetProfitLoss(false, $month_to, $viewyear);
$current_profit_loss_total_ytd = financialStatements::balsheet_GetProfitLoss(true, $month_to, $viewyear);
/* calculate movement */
$mon0_profit_loss_total = financialStatements::balsheet_GetProfitLoss(true, 0, $viewyear);
$current_profit_loss_total_mtd = 0 - ($current_profit_loss_total_ytd - $mon0_profit_loss_total);
//$totals["equity"] += $current_profit_loss_total;
//$totals["tymtd"] += $current_profit_loss_total_mtd;
//$totals["tyytd"] += $current_profit_loss_total_ytd;
//if ($last_year_same_month) $totals["lysm"] += $prevyear_profit_loss_total;
//if ($last_year_year_to_date) $totals["lyytd"] += $prevyear_profit_loss_total_ytd;
/* calculate retained income budget */
$ri_calc = new dbQuery(DB_SQL, "SELECT SUM(CASE WHEN budtype='inc' THEN (amt) ELSE (amt*-1) END) AS amt\n\t\t\t\tFROM cubit.budgets b JOIN cubit.buditems bi ON(bi.budid=b.budid)\n\t\t\t\tWHERE b.budfor='acc' AND (b.budtype='inc' OR b.budtype='exp') AND bi.prd='{$month_to}'");
$ri_calc->run();
$retained_income_budget = $ri_calc->fetch_result(0, 0);
//$totals["budget"] += $retained_income_budget;
// Retrieve saved balance sheet information
//db_conn("cubit");
//$sql = "SELECT * FROM saved_bs_accounts";
//$tb_rslt = db_exec($sql) or errDie("Unable to retrieve accounts list from Cubit.");
//if (pg_num_rows($tb_rslt) == 0 || !isset($acc_view)) {
db_conn($viewyear);
$sql = "SELECT DISTINCT accid, topacc, accnum, accname FROM trial_bal WHERE div='" . USER_DIV . "' AND {$month_range} AND {$zb_sql}";
$tb_rslt = db_exec($sql) or errDie("Unable to retrieve trial balance information from Cubit.");
//}
$assets_out = "";
$equity_out = "";
$report_out = "";
$tymtd_out = "";
$tyytd_out = "";
$budget_out = "";
$tybudget_out = "";
$lysm_out = "";
$lyytd_out = "";
while ($tb_data = pg_fetch_array($tb_rslt)) {
db_conn("core");
$sql = "SELECT * FROM accounts WHERE accid='{$tb_data['accid']}'";
$acc_rslt = db_exec($sql) or errDie("Unable to retrieve account information from Cubit.");
$acc_data = pg_fetch_array($acc_rslt);
if (isset($tb_data["toptype"])) {
$acc_data["toptype"] = $tb_data["toptype"];
}
if ($acc_data["acctype"] == "B") {
if (financialStatements::balsheet_type($acc_data["toptype"]) == "assets") {
$assets[$acc_data["toptype"]][] = $acc_data["accid"];
} elseif (financialStatements::balsheet_type($acc_data["toptype"]) == "equity") {
$equity[$acc_data["toptype"]][] = $acc_data["accid"];
}
}
}
$totals["assets"] = 0.0;
$totals["lysm"] = 0.0;
$totals["tymtd"] = 0.0;
$totals["tyytd"] = 0.0;
$totals["lyytd"] = 0.0;
$totals["budget"] = 0.0;
$totals["tybudget"] = 0.0;
/* ASSETS - CAPITAL EMPLOYED */
if (isset($assets)) {
foreach ($assets as $toptype => $arlv2) {
foreach ($assets[$toptype] as $accid) {
/* determines whether a figure in any of the accounts */
$disp_acc = false;
db_conn($viewyear);
$sql = "SELECT * FROM trial_bal_actual\n\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='{$month_to}' AND {$zb_sql}";
$tb_rslt = db_exec($sql) or errDie("Unable to retrieve account information from Cubit.");
$tb_data = pg_fetch_array($tb_rslt);
// Retrieve this year, movement to date
if ($this_year_movement_to_date) {
$tymtd = array();
$tymtd["debit"] = 0;
$tymtd["credit"] = 0;
db_conn($viewyear);
/* current year, year to date */
$sql = "SELECT debit,credit FROM trial_bal\n\t\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='{$month_to}' AND {$zb_sql} LIMIT 1";
$tymtd_rslt = db_exec($sql) or errDie("Unable to retrieve this year, year to date information from Cubit.");
while ($tymtd_data = pg_fetch_array($tymtd_rslt)) {
$tymtd["debit"] += $tymtd_data["debit"];
$tymtd["credit"] += $tymtd_data["credit"];
}
/* deduct previous year end of year amounts */
$sql = "SELECT debit,credit FROM trial_bal\n\t\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='0' AND {$zb_sql} LIMIT 1";
$tymtd_rslt = db_exec($sql) or errDie("Unable to retrieve this year, year to date information from Cubit.");
while ($tymtd_data = pg_fetch_array($tymtd_rslt)) {
$tymtd["debit"] -= $tymtd_data["debit"];
$tymtd["credit"] -= $tymtd_data["credit"];
}
$amt = financialStatements::balsheet_calculate($toptype, $tymtd["debit"], $tymtd["credit"]);
$tymtd_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["tymtd"] += $amt;
} else {
$tymtd_out = "";
}
// Retrieve this year, year to date
if ($this_year_year_to_date) {
db_conn($viewyear);
$sql = "SELECT debit,credit FROM trial_bal\n\t\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='{$month_to}' AND {$zb_sql} LIMIT 1";
$tyytd_rslt = db_exec($sql) or errDie("Unable to retrieve this year, year to date information from Cubit.");
$tyytd = array();
$tyytd["debit"] = 0;
$tyytd["credit"] = 0;
while ($tyytd_data = pg_fetch_array($tyytd_rslt)) {
$tyytd["debit"] += $tyytd_data["debit"];
$tyytd["credit"] += $tyytd_data["credit"];
}
$amt = financialStatements::balsheet_calculate($toptype, $tyytd["debit"], $tyytd["credit"]);
$tyytd_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["tyytd"] += $amt;
} else {
$tyytd_out = "";
}
// Budget values
if ($budget) {
db_conn("cubit");
$sql = "SELECT SUM(amt) AS amt FROM buditems WHERE prd='{$month_to}' AND id='{$accid}'";
$bud_rslt = db_exec($sql) or errDie("Unable to retrieve budget values from Cubit.");
$bud_amt = pg_fetch_result($bud_rslt, 0, 0);
$budget_out = "<td align='right' width='10%'>" . fsmoney($bud_amt) . "</td>";
if ($bud_amt != 0) {
$disp_acc = true;
}
$totals["budget"] += $bud_amt;
} else {
$budget_out = "";
}
if ($this_year_budget) {
if ($PRDMON[1] == 1) {
$prdwhere = "prd<='{$month_to}'";
} else {
if ($month_to < $PRDMON[1]) {
$prdwhere = "(prd>='{$PRDMON['1']}' OR prd<='{$month_to}')";
} else {
if ($month_to >= $PRDMON[1]) {
$prdwhere = "(prd>='{$PRDMON['1']}' AND prd<='{$month_to}')";
}
}
}
// Retrieve current year budget from Cubit
db_conn("cubit");
$sql = "SELECT SUM(bi.amt)\n\t \t\t\t\t\t\tFROM cubit.budgets b LEFT JOIN cubit.buditems bi\n\t \t\t\t\t\t\tON b.budid=bi.budid\n\t \t\t\t\t\t\tWHERE bi.id='{$accid}' AND {$prdwhere}";
$rslt = db_exec($sql) or errDie("Unable to retrieve this year budget items from Cubit.");
$bud_amt = pg_fetch_result($rslt, 0, 0);
$tybudget_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($bud_amt) . "\n\t\t\t\t\t\t\t</td>";
if ($bud_amt != 0) {
$disp_acc = true;
}
$totals["tybudget"] += $bud_amt;
} else {
$tybudget_out = "";
}
// Retrieve last year this month trial balance data
if ($last_year_same_month) {
db_conn($last_year_schema);
$sql = "SELECT * FROM {$month_to_name} WHERE accid='{$accid}' AND {$zb_sql}";
$lytm_rslt = db_exec($sql) or errDie("Unable to retrieve last year this month information from Cubit.");
$lytm_data = pg_fetch_array($lytm_rslt);
$amt = financialStatements::balsheet_calculate($toptype, $lytm_data["debit"], $lytm_data["credit"]);
$lysm_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["lysm"] += $amt;
} else {
$lysm_out = "";
}
// Last year's values
if ($last_year_year_to_date) {
db_conn($last_year_schema);
$sql = "SELECT * FROM year_balance WHERE accid='{$accid}' AND {$zb_sql}";
$py_rslt = db_exec($sql) or errDie("Unable to retrieve previous year trial balance from Cubit.");
$py_data = pg_fetch_array($py_rslt);
$amt = financialStatements::balsheet_calculate($toptype, $py_data["debit"], $py_data["credit"]);
$lyytd_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["lyytd"] += $amt;
} else {
$lyytd_out = "";
}
if (empty($zero_balance) && !$disp_acc && $tb_data["credit"] == $tb_data["debit"]) {
continue;
}
if ($pure && isset($notes[$accid])) {
$note_out = $notes[$accid];
} else {
if (!$pure) {
$note_out = "<a href='#' onclick='openwindow(\"" . SELF . "?key=note_view&accid={$accid}\")'>Note</a>";
} else {
$note_out = " ";
}
}
$amt = financialStatements::balsheet_calculate($toptype, $tb_data["debit"], $tb_data["credit"]);
${$toptype} .= "\n\t\t\t\t\t\t<tr class='bg-odd'>\n\t\t\t\t\t\t\t<td><a onClick=\"window.open('drill-view-trans.php?accid={$accid}&month_to={$month_to}','window{$accid}','width=900, height=380, scrollbars=yes');\" href='#'>{$tb_data['accname']}</a></td>\n\t\t\t\t\t\t\t<td align='right' width='10%'><a href='#' onClick=\"window.open('../core/drill-trans-new.php?dtaccid={$accid}&ctaccid={$accid}','window{$accid}','height=420, width=900, scrollbars=yes');\">" . fsmoney($amt) . "</a></td>\n\t\t\t\t\t\t\t{$tymtd_out}\n\t\t\t\t\t\t\t{$tyytd_out}\n\t\t\t\t\t\t\t{$budget_out}\n\t\t\t\t\t\t\t{$tybudget_out}\n\t\t\t\t\t\t\t{$lysm_out}\n\t\t\t\t\t\t\t{$lyytd_out}\n\t\t\t\t\t\t\t<td align='right'>{$note_out}</td>\n\t\t\t\t\t\t</tr>";
// add up the totals
$totals["assets"] += $amt;
}
}
// Decide which categories to display
/* if (!empty($fixed_asset))
$assets_out .= "<tr><th colspan='10' class='balsheet_cats'>- Fixed Assets</th></tr>$fixed_asset";
if (!empty($investments))
$assets_out .= "<tr><th colspan='10' class='balsheet_cats'>- Investments</th></tr>$investments";
if (!empty($other_fixed_asset))
$assets_out .= "<tr><th colspan='10' class='balsheet_cats'>- Other Fixed Assets</th></tr>$other_fixed_asset";
if (!empty($current_asset))
$assets_out .= "<tr><th colspan='10' class='balsheet_cats'>- Current Assets</th></tr>$current_asset";*/
foreach ($ar_assets as $ctoptype) {
if (!empty(${$ctoptype})) {
$assets_out .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='10' class='balsheet_cats'>- {$ar_cats[$ctoptype]}</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t{${$ctoptype}}";
}
}
}
// Assets total output
if ($this_year_movement_to_date) {
$tymtd_out = "<td align='right'>" . fsmoney($totals["tymtd"]) . "</td>";
}
if ($this_year_year_to_date) {
$tyytd_out = "<td align='right'>" . fsmoney($totals["tyytd"]) . "</td>";
}
if ($budget) {
$budget_out = "<td align='right'>" . fsmoney($totals["budget"]) . "</td>";
}
if ($this_year_budget) {
$tybudget_out = "<td align='right'>" . fsmoney($totals["tybudget"]) . "</td>";
}
if ($last_year_same_month) {
$lysm_out = "<td align='right'>" . fsmoney($totals["lysm"]) . "</td>";
}
if ($last_year_year_to_date) {
$lyytd_out = "<td align='right'>" . fsmoney($totals["lyytd"]) . "</td>";
}
//$balance2 = $totals["assets"];
$balance2 = $totals["tyytd"];
// $assets_out .= "
// <tr class='bg-even'>
// <td> </td>
// <td align='right'>".fsmoney($totals["assets"], 2)."</td>
// $tymtd_out
// $tyytd_out
// $budget_out
// $tybudget_out
// $lysm_out
// $lyytd_out
// <td> </td>
// </tr>";
$assets1 .= "\n\t\t\t\t<tr class='bg-even'>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td align='right'>" . fsmoney($totals["assets"], 2) . "</td>\n\t\t\t\t\t{$tymtd_out}\n\t\t\t\t\t{$tyytd_out}\n\t\t\t\t\t{$budget_out}\n\t\t\t\t\t{$tybudget_out}\n\t\t\t\t\t{$lysm_out}\n\t\t\t\t\t{$lyytd_out}\n\t\t\t\t\t<td> </td>\n\t\t\t\t</tr>";
$assets2 .= "\n\t\t\t\t<tr class='bg-even'>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td align='right'>" . fsmoney($totals["assets"], 2) . "</td>\n\t\t\t\t\t{$tymtd_out}\n\t\t\t\t\t<td><p class='err'>ERROR: Database Corruption Detected. Please Contact Your Dealer</p></td>\n\t\t\t\t\t{$budget_out}\n\t\t\t\t\t{$tybudget_out}\n\t\t\t\t\t{$lysm_out}\n\t\t\t\t\t{$lyytd_out}\n\t\t\t\t\t<td> </td>\n\t\t\t\t</tr>";
// print "assets:$totals[assets]<br>";
// print "lysm:$totals[lysm]<br>";
// print "tymtd:$totals[tymtd]<br>";
// print "tyytd:$totals[tyytd]<br>";
// print "lyytd:$totals[lyytd]<br>";
// print "budget:$totals[budget]<br>";
// print "tybudget:$totals[tybudget]<br><br>";
$assets_total_tyytd = $totals['tyytd'];
$totals = array();
$totals["equity"] = 0.0;
$totals["tymtd"] = 0.0;
$totals["tyytd"] = 0.0;
$totals["budget"] = 0.0;
$totals["tybudget"] = 0.0;
$totals["lysm"] = 0.0;
$totals["lyytd"] = 0.0;
/* EQUITY - LIABILITIES - EMPLOYEMENT OF CAPITAL */
if (isset($equity)) {
foreach ($equity as $toptype => $arlv2) {
foreach ($equity[$toptype] as $accid) {
$disp_acc = false;
db_conn($viewyear);
$sql = "SELECT * FROM trial_bal_actual\n\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='{$month_to}' AND {$zb_sql}";
$tb_rslt = db_exec($sql) or errDie("Unable to retrieve account information from Cubit.");
$tb_data = pg_fetch_array($tb_rslt);
if ($tb_data["topacc"] == "5200" && $tb_data["accnum"] == "000") {
$retinc_acc = true;
} else {
$retinc_acc = false;
}
// Retrieve this year, movement to date
if ($this_year_movement_to_date) {
$tymtd = array();
$tymtd["debit"] = 0;
$tymtd["credit"] = 0;
db_conn($viewyear);
/* current year, year to date */
$sql = "SELECT debit,credit FROM trial_bal\n\t\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='{$month_to}' AND {$zb_sql} LIMIT 1";
$tymtd_rslt = db_exec($sql) or errDie("Unable to retrieve this year, year to date information from Cubit.");
while ($tymtd_data = pg_fetch_array($tymtd_rslt)) {
$tymtd["debit"] += $tymtd_data["debit"];
$tymtd["credit"] += $tymtd_data["credit"];
}
/* deduct previous year end of year amounts */
$sql = "SELECT debit,credit FROM trial_bal\n\t\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='0' AND {$zb_sql} LIMIT 1";
$tymtd_rslt = db_exec($sql) or errDie("Unable to retrieve this year, year to date information from Cubit.");
while ($tymtd_data = pg_fetch_array($tymtd_rslt)) {
$tymtd["debit"] -= $tymtd_data["debit"];
$tymtd["credit"] -= $tymtd_data["credit"];
}
//$amt = financialStatements::balsheet_calculate($toptype, $tymtd["debit"], $tymtd["credit"]);
$amt = $tymtd["debit"] - $tymtd["credit"];
if ($retinc_acc) {
$amt += $current_profit_loss_total_mtd;
}
$tymtd_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["tymtd"] += $amt;
//financialStatements::balsheet_calculate($toptype, $tymtd["debit"], $tymtd["credit"]);
} else {
$tymtd_out = "";
}
// Retrieve this year, year to date
if ($this_year_year_to_date) {
db_conn($viewyear);
$sql = "SELECT debit,credit FROM trial_bal\n\t\t\t\t\t\t\t\tWHERE accid='{$accid}' AND month='{$month_to}' AND {$zb_sql} LIMIT 1";
$tyytd_rslt = db_exec($sql) or errDie("Unable to retrieve this year, year to date information from Cubit.");
$tyytd = array();
$tyytd["debit"] = 0;
$tyytd["credit"] = 0;
while ($tyytd_data = pg_fetch_array($tyytd_rslt)) {
$tyytd["debit"] += $tyytd_data["debit"];
$tyytd["credit"] += $tyytd_data["credit"];
}
$amt = financialStatements::balsheet_calculate($toptype, $tyytd["debit"], $tyytd["credit"]);
if ($retinc_acc) {
$amt += $current_profit_loss_total_ytd;
}
$tyytd_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["tyytd"] += $amt;
} else {
$tyytd_out = "";
}
// Budget values
if ($budget) {
db_conn("cubit");
$sql = "SELECT SUM(amt) FROM buditems WHERE prd='{$month_to}' AND id='{$accid}'";
$bud_rslt = db_exec($sql) or errDie("Unable to retrieve budget values from Cubit.");
$bud_amt = pg_fetch_result($bud_rslt, 0, 0);
if ($retinc_acc) {
$bud_amt += $retained_income_budget;
}
$budget_out = "<td align='right' width='10%'>" . fsmoney($bud_amt) . "</td>";
if ($bud_amt != 0) {
$disp_acc = true;
}
$totals["budget"] += $bud_amt;
} else {
$budget_out = "";
}
if ($this_year_budget) {
if ($PRDMON[1] == 1) {
$prdwhere = "prd<='{$month_to}'";
} else {
if ($month_to < $PRDMON[1]) {
$prdwhere = "(prd>='{$PRDMON['1']}' OR prd<='{$month_to}')";
} else {
if ($month_to >= $PRDMON[1]) {
$prdwhere = "(prd>='{$PRDMON['1']}' AND prd<='{$month_to}')";
}
}
}
// Retrieve current year budget from Cubit
db_conn("cubit");
$sql = "SELECT SUM(bi.amt) \n\t \t\t\t\t\t\tFROM cubit.budgets b LEFT JOIN cubit.buditems bi \n\t \t\t\t\t\t\tON b.budid=bi.budid \n\t \t\t\t\t\t\tWHERE bi.id='{$accid}' AND {$prdwhere}";
$rslt = db_exec($sql) or errDie("Unable to retrieve this year budget items from Cubit.");
$bud_amt = pg_fetch_result($rslt, 0, 0);
if ($bud_amt != 0) {
$disp_acc = true;
}
$totals["tybudget"] += $bud_amt;
$tybudget_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($bud_amt) . "\n\t\t\t\t\t\t\t</td>";
} else {
$tybudget_out = "";
}
// Retrieve last year this month trial balance data
if ($last_year_same_month) {
db_conn($last_year_schema);
$sql = "SELECT * FROM {$month_to_name} WHERE accid='{$accid}' AND {$zb_sql}";
$lytm_rslt = db_exec($sql) or errDie("Unable to retrieve last year this month information from Cubit.");
$lytm_data = pg_fetch_array($lytm_rslt);
$amt = financialStatements::balsheet_calculate($toptype, $lytm_data["debit"], $lytm_data["credit"]);
if ($retinc_acc) {
$amt += $prevyear_profit_loss_total;
}
$lysm_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["lysm"] += $amt;
} else {
$lysm_out = "";
}
// Last year's values
if ($last_year_year_to_date) {
db_conn($last_year_schema);
$sql = "SELECT * FROM year_balance WHERE accid='{$accid}' AND {$zb_sql}";
$py_rslt = db_exec($sql) or errDie("Unable to retrieve previous year trial balance from Cubit.");
$py_data = pg_fetch_array($py_rslt);
$amt = financialStatements::balsheet_calculate($toptype, $py_data["debit"], $py_data["credit"]);
if ($retinc_acc) {
$amt += $prevyear_profit_loss_total_ytd;
}
$lyytd_out = "\n\t\t\t\t\t\t\t<td align='right' width='10%'>\n\t\t\t\t\t\t\t\t" . fsmoney($amt) . "\n\t\t\t\t\t\t\t</td>";
if ($amt != 0) {
$disp_acc = true;
}
$totals["lyytd"] += $amt;
} else {
$lyytd_out = "";
}
if (empty($zero_balance) && !$disp_acc && $tb_data["credit"] == $tb_data["debit"]) {
continue;
}
if ($pure && isset($notes[$accid])) {
$note_out = $notes[$accid];
} else {
if (!$pure) {
$note_out = "<a href='#' onclick='openwindow(\"" . SELF . "?key=note_view&accid={$accid}\")'>Note</a>";
} else {
$note_out = " ";
}
}
//$amt = financialStatements::balsheet_calculate($toptype, $tb_data["debit"], $tb_data["credit"]);
$amt = $tb_data["debit"] - $tb_data["credit"];
if ($retinc_acc) {
$amt += $current_profit_loss_total;
}
${$toptype} .= "\n\t\t\t\t\t\t<tr class='bg-odd'>\n\t\t\t\t\t\t\t<td><a onClick=\"window.open('drill-view-trans.php?accid={$accid}&month_to={$month_to}','window{$accid}','width=900, height=380, scrollbars=yes');\" href='#'>{$tb_data['accname']}</a></td>\n\t\t\t\t\t\t\t<td align='right' width='10%'><a href='#' onClick=\"window.open('../core/drill-trans-new.php?dtaccid={$accid}&ctaccid={$accid}','window{$accid}','height=420, width=900, scrollbars=yes');\">" . fsmoney($amt) . "</a></td>\n\t\t\t\t\t\t\t{$tymtd_out}\n\t\t\t\t\t\t\t{$tyytd_out}\n\t\t\t\t\t\t\t{$budget_out}\n\t\t\t\t\t\t\t{$tybudget_out}\n\t\t\t\t\t\t\t{$lysm_out}\n\t\t\t\t\t\t\t{$lyytd_out}\n\t\t\t\t\t\t\t<td align='right'>{$note_out}</td>\n\t\t\t\t\t\t</tr>";
$totals["equity"] += $amt;
}
}
// Decide which categories to display
/* if (!empty($share_capital))
$equity_out .= "<tr><th colspan='10' class='balsheet_cats'>- Share Capital</th></tr>$share_capital";
if (!empty($retained_income))
$equity_out .= "<tr><th colspan='10' class='balsheet_cats'>- Retained Income</th></tr>$retained_income";
if (!empty($shareholders_loan))
$equity_out .= "<tr><th colspan='10' class='balsheet_cats'>- Shareholders Loan</th></tr>$shareholders_loan";
if (!empty($long_term_borrowing))
$equity_out .= "<tr><th colspan='10' class='balsheet_cats'>- Long Term Borrowings</th></tr>$long_term_borrowing";
if (!empty($other_long_term_liability))
$equity_out .= "<tr><th colspan='10' class='balsheet_cats'>- Other Long Term Liabilities</th></tr>$other_long_term_liability";
if (!empty($current_liability))
$equity_out .= "<tr><th colspan='10' class='balsheet_cats'>- Current Liabilities</th></tr>$current_liability";*/
foreach ($ar_equity as $ctoptype) {
if (!empty(${$ctoptype})) {
$equity_out .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='10' class='balsheet_cats'>- {$ar_cats[$ctoptype]}</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t{${$ctoptype}}";
}
}
}
// equity totals output
/*if ($last_year_same_month) $lysm_out = "<td align='right'>".fsmoney($prevyear_profit_loss_total)."</td>";
if ($last_year_year_to_date) $lyytd_out = "<td align='right'>".fsmoney($prevyear_profit_loss_total_ytd)."</td>";
if ($this_year_movement_to_date) $tymtd_out = "<td align='right'>".fsmoney($current_profit_loss_total_mtd)."</td>";
if ($this_year_year_to_date) $tyytd_out = "<td align='right'>".fsmoney($current_profit_loss_total_ytd)."</td>";
if ($budget) $budget_out = "<td align='right'>".fsmoney($retained_income_budget)."</td>";
if ($this_year_budget) $tybudget_out = "<td> </td>";
$equity_out .= "
<tr class='bg-even'>
<td>Retained Income</td>
<td align='right'>".fsmoney($current_profit_loss_total)."</td>
$lysm_out
$lyytd_out
$tymtd_out
$tyytd_out
$budget_out
$tybudget_out
<td> </td>
</tr>";*/
if ($this_year_movement_to_date) {
$tymtd_out = "<td align='right'>" . fsmoney($totals["tymtd"]) . "</td>";
}
if ($this_year_year_to_date) {
$tyytd_out = "<td align='right'>" . fsmoney($totals["tyytd"]) . "</td>";
}
if ($budget) {
$budget_out = "<td align='right'>" . fsmoney($totals["budget"]) . "</td>";
}
if ($this_year_budget) {
$tybudget_out = "<td align='right'>" . fsmoney($totals["tybudget"]) . "</td>";
}
if ($last_year_same_month) {
$lysm_out = "<td align='right'>" . fsmoney($totals["lysm"]) . "</td>";
}
if ($last_year_year_to_date) {
$lyytd_out = "<td align='right'>" . fsmoney($totals["lyytd"]) . "</td>";
}
//$balance1 = $totals["equity"];
$balance1 = $totals["tyytd"];
// $equity_out .= "
// <tr class='bg-even'>
// <td> </td>
// <td align='right'>".fsmoney($totals["equity"], 2)."</td>
// $tymtd_out
// $tyytd_out
// $budget_out
// $tybudget_out
// $lysm_out
// $lyytd_out
// <td> </td>
// </tr>";
$equity1 .= "\n\t\t\t\t<tr class='bg-even'>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td align='right'>" . fsmoney($totals["equity"], 2) . "</td>\n\t\t\t\t\t{$tymtd_out}\n\t\t\t\t\t{$tyytd_out}\n\t\t\t\t\t{$budget_out}\n\t\t\t\t\t{$tybudget_out}\n\t\t\t\t\t{$lysm_out}\n\t\t\t\t\t{$lyytd_out}\n\t\t\t\t\t<td> </td>\n\t\t\t\t</tr>";
$equity2 .= "\n\t\t\t\t<tr class='bg-even'>\n\t\t\t\t\t<td> </td>\n\t\t\t\t\t<td align='right'>" . fsmoney($totals["equity"], 2) . "</td>\n\t\t\t\t\t{$tymtd_out}\n\t\t\t\t\t<td><p class='err'>ERROR: Database Corruption Detected. Please Contact Your Dealer</p></td>\n\t\t\t\t\t{$budget_out}\n\t\t\t\t\t{$tybudget_out}\n\t\t\t\t\t{$lysm_out}\n\t\t\t\t\t{$lyytd_out}\n\t\t\t\t\t<td> </td>\n\t\t\t\t</tr>";
if (isset($acc_view)) {
$acc_view_hidden = "<input type='hidden' name='acc_view' value='{$acc_view}'>";
} else {
$acc_view_hidden = "";
}
if ($month_from == $month_to) {
$date_range = "{$month_from_out} {$year_out}";
} else {
$date_range = "{$month_from_out} TO {$month_to_out} {$year_out}";
}
/* headings */
$head = "\n\t\t<tr>\n\t\t\t<th align='left' class='thkborder thkborder_left'>Account</th>\n\t\t\t<th align='right' class='thkborder'>Movement during<br />{$month_to_out} {$year_out}</th>";
if ($this_year_movement_to_date) {
$head .= "<th align='right' class='thkborder'>Movement<br />To {$month_to_out} {$year_out}</th>";
}
if ($this_year_year_to_date) {
$head .= "<th align='right' class='thkborder'>This Year<br />At {$month_to_out} {$year_out}</th>";
}
if ($budget) {
$head .= "<th align='right' class='thkborder'>Budget<br />for {$month_to_out} {$year_out}</th>";
}
if ($this_year_budget) {
$head .= "<th align='right' class='thkborder'>Budget<br />To {$month_to_out} {$year_out}</th>";
}
if ($last_year_same_month) {
$head .= "<th align='right' class='thkborder'>Last Year<br />At {$month_to_out} {$year_out}</th>";
}
if ($last_year_year_to_date) {
$head .= "<th align='right' class='thkborder'>Last Year<br />Year End</th>";
}
$head .= "\n\t\t\t<th align='left' class='thkborder thkborder_right'>Note</th>\n\t\t</tr>";
/* calculate colspans to half the total column span */
$totcols = 3;
if ($this_year_movement_to_date) {
++$totcols;
}
if ($this_year_year_to_date) {
++$totcols;
}
if ($budget) {
++$totcols;
}
if ($this_year_budget) {
++$totcols;
}
if ($last_year_same_month) {
++$totcols;
}
if ($last_year_year_to_date) {
++$totcols;
}
$half_left = (int) ($totcols / 2);
$half_right = $totcols - $half_left;
$OUTPUT = "";
// print "equity:$totals[equity]<br>";
// print "tymtd:$totals[tymtd]<br>";
// print "tyytd:$totals[tyytd]<br>";
// print "budget:$totals[budget]<br>";
// print "tybudget:$totals[tybudget]<br>";
// print "lysm:$totals[lysm]<br>";
// print "lyytd:$totals[lyytd]<br>";
$equity_total_tyytd = $totals['tyytd'];
$balance1 += 0;
$balance2 += 0;
if ((string) $balance1 != (string) $balance2) {
$assets_out .= $assets2;
$equity_out .= $equity2;
} else {
$assets_out .= $assets1;
$equity_out .= $equity1;
}
// Layout
$OUTPUT .= "\n\t\t\t{$acc_view_hidden}\n\t\t\t<table " . TMPL_tblDflts . " width='100%'>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='{$half_left}' align='left'><h3>{$heading_1}</h3></td>\n\t\t\t\t\t<td colspan='{$half_right}' align='right'><h3>{$heading_2}</h3></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='{$half_left}' align='left'><h3>{$heading_3}</h3></td>\n\t\t\t\t\t<td colspan='{$half_right}' align='right'><h3>{$heading_4}</h3></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='10' align='center'><h3>{$date_range}</h3></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<th colspan='10' class='balsheet_cats'><h3>{$capital_employed_out}</h3></th>\n\t\t\t\t</tr>\n\t\t\t\t{$head}\n\t\t\t\t{$equity_out}\n\t\t\t\t<tr>\n\t\t\t\t\t<th colspan='10' class='balsheet_cats'><h3>{$employment_of_capital_out}</h3></th>\n\t\t\t\t</tr>\n\t\t\t\t{$head}\n\t\t\t\t{$assets_out}";
if ($pure) {
$OUTPUT .= "<tr><td> </td></tr>";
$notes_display = "";
foreach ($notes as $accid => $num) {
db_conn("cubit");
$sql = "SELECT * FROM saved_bs_accounts WHERE accid='{$accid}'";
$rslt = db_exec($sql) or errDie("Unable to retrieve note from Cubit.");
$note_data = pg_fetch_array($rslt);
$OUTPUT .= "\n\t\t\t\t\t<tr><td></td></tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan='10'><u>{$num}) {$note_data['accname']}</u></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan='10'>" . nl2br(base64_decode($note_data["note"])) . "</u></td>\n\t\t\t\t\t</tr>";
}
} else {
$OUTPUT .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan='5' align='center'>\n\t\t\t\t\t\t<form method='POST' action='" . SELF . "'>\n\t\t\t\t\t\t\t<input type='hidden' name='key' value='customize' />\n\t\t\t\t\t\t\t<input type='hidden' name='heading_1' value='{$heading_1}' />\n\t\t\t\t\t\t\t<input type='hidden' name='heading_2' value='{$heading_2}' />\n\t\t\t\t\t\t\t<input type='hidden' name='heading_3' value='{$heading_3}' />\n\t\t\t\t\t\t\t<input type='hidden' name='heading_4' value='{$heading_4}' />\n\t\t\t\t\t\t\t<input type='hidden' name='capital_employed_out' value='{$capital_employed_out}' />\n\t\t\t\t\t\t\t<input type='hidden' name='employment_of_capital_out' value='{$employment_of_capital_out}' />\n\t\t\t\t\t\t\t<input type='hidden' name='viewyear' value='{$viewyear}' />\n\t\t\t\t\t\t\t<input type='hidden' name='month_from' value='{$month_from}' />\n\t\t\t\t\t\t\t<input type='hidden' name='month_to' value='{$month_to}' />\n\t\t\t\t\t\t\t<input type='hidden' name='last_year_same_month' value='{$last_year_same_month}' />\n\t\t\t\t\t\t\t<input type='hidden' name='last_year_year_to_date' value='{$last_year_year_to_date}' />\n\t\t\t\t\t\t\t<input type='hidden' name='this_year_movement_to_date' value='{$this_year_movement_to_date}' />\n\t\t\t\t\t\t\t<input type='hidden' name='this_year_year_to_date' value='{$this_year_year_to_date}' />\n\t\t\t\t\t\t\t<input type='hidden' name='budget' value='{$budget}' />\n\t\t\t\t\t\t\t<input type='hidden' name='this_year_budget' value='{$this_year_budget}' />\n\t\t\t\t\t\t\t<input type='hidden' name='zero_balance' value='{$zero_balance}' />\n\t\t\t\t\t\t\t<input type='submit' value='Customise' />\n\t\t\t\t\t\t\t<input type='submit' name='key' value='Print' />\n\t\t\t\t\t\t\t<input type='submit' name='key' value='Save' />\n\t\t\t\t\t\t\t<input type='submit' name='key' value='Export to Spreadsheet' />\n\t\t\t\t\t\t</form>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t<p>\n\t\t\t\t<center>\n\t\t\t\t<table " . TMPL_tblDflts . " width='25%'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='datacell'>\n\t\t\t\t\t\t<td align='center'><a target='_blank' href='../core/acc-new2.php'>Add account (New Window)</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='datacell'>\n\t\t\t\t\t\t<td align='center'><a href='index-reports.php'>Financials</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='datacell'>\n\t\t\t\t\t\t<td align='center'><a href='index-reports-stmnt.php'>Current Year Financial Statements</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='datacell'>\n\t\t\t\t\t\t<td align='center'><a href='../main.php'>Main Menu</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t</center>";
}
return $OUTPUT;
}
* User: ori
* Date: 12-8-12
* Time: 下午2:24
* To change this template use File | Settings | File Templates.
*/
header("Content-type:text/html; charset=utf-8");
error_reporting(E_ALL & ~E_NOTICE);
ini_set("magic_quotes_runtime", 0);
include_once './class/mysql_db.php';
include_once './config.php';
include_once './class/baidu.php';
include_once './class/randArticle.php';
include_once './class/main.php';
include_once './function/function.php';
$cfg = new config();
$db = new dbQuery($cfg->dbHost, $cfg->dbUser, $cfg->dbPassword, $cfg->dbName);
$indexContent = new indexContent();
//--------------------获取maxid-------------------------------------
$content = '';
if ($cfg->isMemcached) {
$memcached = new Memcached();
$memcached->addServer('127.0.0.1', '11211');
$content = $memcached->get($indexContent->mainDomain);
}
if ($content == '' && file_exists('./cfg')) {
$content = file_get_contents('./cfg');
}
if ($content == '') {
$sqlSelect = 'SELECT MAX(cid) as maxcid FROM `' . $indexContent->dbPrefix . 'cat`;';
$result = $db->query($sqlSelect);
$arrResult = $db->fetch_array($result);
<?php
include "./common.inc.php";
include './mysql_db.php';
$db = new dbQuery($cfg_dbhost, $cfg_dbuser, $cfg_dbpwd, $cfg_dbname);
//$arr_host
foreach ($cfg_arr_host as $host) {
$qz = str_replace('.', '_', $host);
$qz = $qz . '_';
$sql1 = "drop table if exists `" . $qz . "cat`";
$sql2 = "\r\n\t\tCREATE TABLE `" . $qz . "cat` (\r\n\t\t `cid` int(9) NOT NULL auto_increment,\r\n\t\t `title` varchar(200) NOT NULL,\r\n\t\t `key` varchar(50) NOT NULL,\r\n\t\t `keys` varchar(255) default NULL,\r\n\t\t `epath` varchar(30) default NULL,\r\n\t\t `flink` text default NULL,\r\n\t\t `layer` tinyint(4) NOT NULL default '0',\r\n\t\t `ad_key` varchar(50) NOT NULL,\r\n\t\t PRIMARY KEY (`cid`),\r\n\t\t UNIQUE KEY `key` (`key`),\r\n\t\t UNIQUE KEY `epath` (`epath`),\r\n\t\t KEY `layer` (`layer`)\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$db->query($sql1);
$db->query($sql2);
echo "create database -- {$qz} -- success.<br>";
}
//
$db->close();
//rename("install.php","install.php.bak");
echo "Create database success,<a href='./addkey.php?pwd=7698'>click here</a>to add keys!";
echo "<meta http-equiv=refresh content='0; url=./addkey.php?pwd=7698'>";
/**
* Function for joining tables to get some extra data in result set
*
* @param dbQuery $query Collection query
*/
public function joinTables(&$query)
{
$query->join('user')->order_by('Modyfied', 'DESC')->join('structurematerial')->join('structure');
}
<?php
include_once "../config.php";
include_once '../class/mysql_db.php';
include_once '../class/main.php';
$cfg = new config();
$db = new dbQuery($cfg->dbHost, $cfg->dbUser, $cfg->dbPassword, $cfg->dbName);
$info = new urlInfo();
$db->query("drop table if exists `" . $info->dbPrefix . "cat`");
$sqlCreate = "\r\n\t\tCREATE TABLE `" . $info->dbPrefix . "cat` (\r\n\t\t `cid` int(9) NOT NULL auto_increment,\r\n\t\t `title` varchar(200) NOT NULL,\r\n\t\t `key` varchar(50) NOT NULL,\r\n\t\t `keys` varchar(255) default NULL,\r\n\t\t `epath` varchar(30) default NULL,\r\n\t\t `adkey` varchar(50) default NULL,\r\n\t\t `index` TEXT default NULL,\r\n\t\t `baidu1` TEXT default NULL,\r\n\t\t `baidu2` TEXT default NULL,\r\n\t\t `baidu3` TEXT default NULL,\r\n\t\t `baidu4` TEXT default NULL,\r\n\t\t `baidu5` TEXT default NULL,\r\n\t\t `baidu6` TEXT default NULL,\r\n\t\t `baidu7` TEXT default NULL,\r\n\t\t `baidu8` TEXT default NULL,\r\n\t\t `baidu9` TEXT default NULL,\r\n\t\t `baidu10` TEXT default NULL,\r\n\t\t PRIMARY KEY (`cid`),\r\n\t\t UNIQUE KEY `key` (`key`),\r\n\t\t UNIQUE KEY `epath` (`epath`)\r\n\t\t) ENGINE=myisam DEFAULT CHARSET=utf8;";
$db->query($sqlCreate);
$db->close();
echo "Create database success,<a href='./addkey.php?pwd=7698'>click here</a>to add keys!";
echo "<meta http-equiv=refresh content='0; url=./addkey.php?pwd=7698'>";
/**
* 更新tagkey
* @param dbQuery $db 传址 数据库连接
* @return mixed
*/
function UpDateTagKey(dbQuery &$db)
{
$cycles = (int) ((time() - $this->createTime) / 259200) + 1;
//以3天为周期更新tagKey
if ($cycles > 20 && rand(1, 100) > 10 && $this->tagKey != '') {
return;
}
//几率更新
switch ($cycles) {
case $cycles > 20:
$nowMaxId = 434 + ($cycles - 10) * 100;
break;
case $cycles > 10:
$nowMaxId = 34 + ($cycles - 10) * 40;
break;
case $cycles > 4:
$nowMaxId = 4 + ($cycles - 4) * 5;
break;
default:
$nowMaxId = $cycles;
}
$nowMaxId = $nowMaxId < $this->maxTagID ? $nowMaxId : $this->maxTagID;
$nowMaxId = $nowMaxId < 25 ? 25 : $nowMaxId;
$totalTagNumber = $nowMaxId >= 10 ? 10 : $nowMaxId;
$arrTagKey = array();
for ($i = 0; $i < $totalTagNumber; $i++) {
$sqlSelect = 'SELECT `key` FROM `' . $this->dbPrefix . 'cat` WHERE `cid`=' . rand(1, $nowMaxId);
$result = $db->query($sqlSelect);
$arrResult = $db->fetch_array($result);
$arrTagKey[] = $arrResult['key'];
}
$this->tagKey = implode(',', $arrTagKey);
$this->isUp = TRUE;
}
function printPurch($_POST, $pure = false)
{
extract($_POST);
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
if ($v->isError()) {
return $v->genErrors();
}
require_lib("docman");
$OUT = "";
if (!$pure) {
$OUT .= "\n\t\t<center>\n\t\t<h3>Received Stock Orders</h3>";
}
$OUT .= "\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Purchase No.</th>\n\t\t\t\t<th>Order No.</th>\n\t\t\t\t<th>Supp Inv No.</th>\n\t\t\t\t<th>Order Date</th>\n\t\t\t\t<th>Received Date</th>\n\t\t\t\t<th>Supplier</th>\n\t\t\t\t<th>Sub Total</th>\n\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t<th>VAT</th>\n\t\t\t\t<th>Total</th>\n\t\t\t\t<th>Delivery Reference No.</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t\t<th colspan='5'>Options</th>\n\t\t\t</tr>";
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
$supsql = "";
if (isset($supplier) and $supplier != 0) {
$supsql = " AND supid = '{$supplier}'";
}
/* build the sql */
$queries = array();
for ($i = 1; $i <= 12; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".purchases WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND done = 'y' AND div = '" . USER_DIV . "' {$supsql}";
}
$sql = implode(" UNION ", $queries) . " ORDER BY pdate DESC";
$qry = new dbQuery(DB_SQL, $sql);
$qry->run();
if ($qry->num_rows() < 1) {
return "<li class='err'> No Received Stock Orders found.</li><br>";
}
while ($stkp = $qry->fetch_array()) {
$prd = $stkp["query_schema"];
/* calculate the subtotal */
$stkp['total'] = sprint($stkp['total']);
$stkp['shipchrg'] = sprint($stkp['shipping']);
$subtot = $stkp['subtot'];
$subtot = sprint($subtot);
/* add the totals */
$tot1 = sprint($tot1 + $subtot);
$tot2 = sprint($tot2 + $stkp['shipchrg']);
$tot3 = sprint($tot3 + $stkp['total']);
$tot4 = sprint($tot4 + $stkp["vat"]);
$docs = doclib_getdocs("pur", $stkp['purnum']);
$docs .= " <a href='#' onClick=\"printer('purch-recv.php?key=recv_print&purid={$stkp['purid']}');\">GRN</a>";
$OUT .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t<td>{$stkp['ordernum']}</td>\n\t\t\t\t<td>{$stkp['supinv']}</td>\n\t\t\t\t<td>{$stkp['pdate']}</td>\n\t\t\t\t<td>{$stkp['ddate']}</td>\n\t\t\t\t<td>{$stkp['supname']}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$subtot}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$stkp['shipchrg']}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$stkp['vat']}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$stkp['total']}</td>\n\t\t\t\t<td>{$stkp['refno']}</td>\n\t\t\t\t<td>{$docs}</td>";
if ($stkp['returned'] != 'y') {
$OUT .= "<td><a href='purch-return.php?purid={$stkp['purid']}&prd={$prd}'>Return</a></td>";
} else {
$OUT .= "<td> </td>";
}
if ($stkp['rsubtot'] > 0) {
$OUT .= "<td><a href='purch-recnote.php?purid={$stkp['purid']}&prd={$prd}'>Record Credit Note</a></td>";
} else {
$OUT .= "<td> </td>";
}
$OUT .= "\n\t\t\t\t<td><a href='purch-det-prd.php?purid={$stkp['purid']}&prd={$prd}'>Details</a></td>\n\t\t\t\t<td><a target='_blank' href='purch-recv-print.php?purid={$stkp['purid']}&prd={$prd}'>Print</a></td>\n\t\t\t</tr>";
}
$OUT .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td colspan='6'>Totals</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot1}</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot2}</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot4}</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot3}</td>\n\t\t</tr>";
if (!$pure) {
$OUT .= "\n\t\t\t" . TBL_BR . "\n\t\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t\t<input type='hidden' name='key' value='export' />\n\t\t\t\t<input type='hidden' name='prd' value='{$prd}' />\n\t\t\t\t<input type='hidden' name='from_day' value='{$from_day}' />\n\t\t\t\t<input type='hidden' name='from_month' value='{$from_month}' />\n\t\t\t\t<input type='hidden' name='from_year' value='{$from_year}' />\n\t\t\t\t<input type='hidden' name='to_day' value='{$to_day}' />\n\t\t\t\t<input type='hidden' name='to_month' value='{$to_month}' />\n\t\t\t\t<input type='hidden' name='to_year' value='{$to_year}' />\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='4'><input type='submit' value='Export to Spreadsheet'></td>\n\t\t\t\t</tr>\n\t\t\t</form>";
}
$OUT .= "</table>";
return $OUT;
}
* Created by JetBrains PhpStorm.
* User: ori
* Date: 12-8-14
* Time: 上午12:11
* To change this template use File | Settings | File Templates.
*/
header("Content-type:text/html; charset=utf-8");
error_reporting(E_ALL & ~E_NOTICE);
ini_set("magic_quotes_runtime", 0);
include_once './class/mysql_db.php';
include_once './config.php';
include_once './class/randArticle.php';
include_once './class/main.php';
include_once './function/function.php';
$cfg = new config();
$db = new dbQuery($cfg->dbHost, $cfg->dbUser, $cfg->dbPassword, $cfg->dbName);
$indexCache = new indexContent();
$viewID = InStr('read-', '.html', $_SERVER["REQUEST_URI"]);
//当前百度问答采集页面ID。范围从1-10。对应baidu1-baidu10
//--------------------从数据库中读取-------------------------------------
$sqlSelect = 'SELECT `cid`,`title`,`key`,`keys`,`adkey`,`index` FROM `' . $indexCache->dbPrefix . "cat` WHERE `epath`='" . $indexCache->epath . "';";
$result = $db->query($sqlSelect);
$arrResult = $db->fetch_array($result);
//--------------------初始化数据--------------------------------------------
$indexCache->AnalysisData($arrResult);
//将viewid转换成数组
$indexCache->AnalysisCache();
$arrResult = null;
unset($arrResult);
//--------------------获取createTime-------------------------------------
$content = '';
$arr_cache['rn_des'] = $rn_des;
$arr_cache['riid'] = $riid;
$arr_cache['ri_title'] = $ri_title;
$arr_cache['ri_des'] = $ri_des;
$cache_con = serialize($arr_cache);
cache_put_contents($cache_con, $cache_path);
}
out_index($arr_cache, $domain, $base_url);
die;
}
/*===============================
*
* cache不存在，初始化生成
*
===============================*/
$db = new dbQuery($cfg_dbhost, $cfg_dbuser, $cfg_dbpwd, $cfg_dbname);
$sql = "select * from `" . $cfg_dbqz . "cat` where `epath`= '{$epath}'";
$result = $db->query($sql);
$row = $db->fetch_array($result);
/*
* 错误页面
*/
if ($db->affected_rows() == 0) {
for ($ii = 0; $ii < 50; $ii++) {
$sql = "SELECT `key`,`epath` FROM `" . $cfg_dbqz . "cat` WHERE `cid`=" . rand(1, $maxid);
$f_result = $db->query($sql);
$f_row = $db->fetch_array($f_result);
$e_key = $f_row['key'];
$e_epath = $f_row['epath'];
// --- /xxx/格式或者/
$arr_temp = explode("/", $e_epath);
