projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Buggy file view/download in ajax mode.
[fa-stable.git]
/
includes
/
data_checks.inc
diff --git
a/includes/data_checks.inc
b/includes/data_checks.inc
index 37da7a3fc4539f6566a8fdf17d41463cb6dfc3a3..0b461636ed6c7a7f638b2b411ebbe6b7419be412 100644
(file)
--- a/
includes/data_checks.inc
+++ b/
includes/data_checks.inc
@@
-267,7
+267,7
@@
function check_db_has_stock_items($msg)
function db_has_bom_stock_items()
{
function db_has_bom_stock_items()
{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE
(mb_flag='M' OR mb_flag='K')
");
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE
mb_flag='M'
");
}
function check_db_has_bom_stock_items($msg)
}
function check_db_has_bom_stock_items($msg)
@@
-299,7
+299,7
@@
function check_db_has_manufacturable_items($msg)
function db_has_purchasable_items()
{
function db_has_purchasable_items()
{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE
(mb_flag!='M' AND mb_flag!='K')
");
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE
mb_flag!='M'
");
}
function check_db_has_purchasable_items($msg)
}
function check_db_has_purchasable_items($msg)
@@
-315,7
+315,7
@@
function check_db_has_purchasable_items($msg)
function db_has_costable_items()
{
function db_has_costable_items()
{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE
(mb_flag!='D' AND mb_flag!='K')
");
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE
mb_flag!='D'
");
}
function check_db_has_costable_items($msg)
}
function check_db_has_costable_items($msg)
@@
-385,6
+385,7
@@
function db_has_bank_accounts()
function check_db_has_bank_accounts($msg)
{
global $path_to_root;
function check_db_has_bank_accounts($msg)
{
global $path_to_root;
+
if (!db_has_bank_accounts())
{
display_error($msg, true);
if (!db_has_bank_accounts())
{
display_error($msg, true);
@@
-393,6
+394,12
@@
function check_db_has_bank_accounts($msg)
}
}
}
}
+function db_has_cash_accounts()
+{
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."bank_accounts
+ WHERE account_type=3");
+}
+
function db_has_gl_accounts()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."chart_master");
function db_has_gl_accounts()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."chart_master");