}
}
+function db_has_currency_rates($currency, $date_, $msg=false)
+{
+ $date = date2sql($date_);
+
+ if (is_company_currency($currency))
+ return 1;
+ $ret = check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."exchange_rates WHERE curr_code = '$currency' && date_ <= '$date'");
+ if ($ret == 0 && $msg)
+ display_error(sprintf(_("Cannot retrieve exchange rate for currency %s as of %s. Please add exchange rate manually on Exchange Rates page."),
+ $currency, $date_), true);
+ return $ret;
+}
+
function db_has_sales_types()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."sales_types");
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;