function db_customer_has_branches($customer_id)
{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE debtor_no='$customer_id'");
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch "
+ ."WHERE debtor_no=".db_escape($customer_id));
}
function db_has_customer_branches()
{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch");
+ return check_empty_result("SELECT COUNT(*) FROM "
+ .TB_PREF."cust_branch WHERE !inactive");
}
function check_db_has_customer_branches($msg)
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 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 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_bank_accounts($msg)
{
global $path_to_root;
+
if (!db_has_bank_accounts())
{
display_error($msg, true);
}
}
+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");
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."quick_entries");
}
+function db_has_tags($type)
+{
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."tags WHERE type=".db_escape($type));
+}
+
+function check_db_has_tags($type, $msg)
+{
+ global $path_to_root;
+ if (!db_has_tags($type))
+ {
+ display_error($msg, true);
+ end_page();
+ exit;
+ }
+}
+
function check_empty_result($sql)
{
$result = db_query($sql, "could not do check empty query");
$myrow = db_fetch_row($result);
- return $myrow[0] > 0;
+ return $myrow[0] > 0;
}
//
// Integer input check
//
// Numeric input check.
// Return 1 if number has proper form and is within <min, max> range
+// Empty/not defined fields are defaulted to $dflt value.
//
-function check_num($postname, $min=null, $max=null) {
+function check_num($postname, $min=null, $max=null, $dflt=0) {
if(!isset($_POST[$postname]))
return 0;
- $num = input_num($postname);
- if ($num === false)
+ $num = input_num($postname, $dflt);
+ if ($num === false || $num === null)
return 0;
if (isset($min) && ($num<$min))
return 0;
return 1;
}
-
-?>
\ No newline at end of file
+function check_is_closed($type, $type_no, $msg=null)
+{
+ global $systypes_array;
+
+ if (($type_no > 0) && is_closed_trans($type, $type_no))
+ {
+ if (!$msg)
+ $msg = sprintf(_("%s #%s is closed for further edition."), $systypes_array[$type], $type_no);
+ display_error($msg, true);
+ end_page();
+ exit;
+ }
+}