projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Bank payment/deposit edit. Attachment will follow the new edit number.
[fa-stable.git]
/
admin
/
db
/
company_db.inc
diff --git
a/admin/db/company_db.inc
b/admin/db/company_db.inc
index b3339053640565e13d49430baa629385e2caca36..5ef679820c11ac41c9794b008ee582db81aea474 100644
(file)
--- a/
admin/db/company_db.inc
+++ b/
admin/db/company_db.inc
@@
-34,7
+34,10
@@
function get_company_pref($prefs = null, $tbpref = null)
{
global $SysPrefs, $db_version;
{
global $SysPrefs, $db_version;
- if (!isset($_SESSION['SysPrefs']->prefs)) { // cached preferences
+ static $cached; // retrieve values from db once a request. Some values can't be cached between requests
+ // to ensure prefs integrity for all usrs (e.g. gl_close_date).
+
+ if (!$cached || !isset($_SESSION['SysPrefs'])) { // cached preferences
$_SESSION['SysPrefs'] = new sys_prefs();
$_SESSION['SysPrefs'] = new sys_prefs();
@@
-55,6
+58,7
@@
function get_company_pref($prefs = null, $tbpref = null)
// update current db status for info in log file
$SysPrefs->db_ok = $SysPrefs->prefs['version_id'] == $db_version;
// update current db status for info in log file
$SysPrefs->db_ok = $SysPrefs->prefs['version_id'] == $db_version;
+ $cached = true;
}
$all = $_SESSION['SysPrefs']->prefs;
}
$all = $_SESSION['SysPrefs']->prefs;
@@
-187,7
+191,7
@@
function key_in_foreign_table($id, $tables, $stdkey, $escaped=false)
$tbl = $key;
$key = $stdkey;
}
$tbl = $key;
$key = $stdkey;
}
- $sqls[] = "(SELECT COUNT(*) as cnt FROM
".TB_PREF."$tbl WHERE $key=$id
)\n";
+ $sqls[] = "(SELECT COUNT(*) as cnt FROM
`".TB_PREF."$tbl` WHERE `$key`=".db_escape($id)."
)\n";
}
$sql = "SELECT sum(cnt) FROM (". implode(' UNION ', $sqls).") as counts";
}
$sql = "SELECT sum(cnt) FROM (". implode(' UNION ', $sqls).") as counts";