<?php
-
+/**********************************************************************
+ Copyright (C) FrontAccounting, LLC.
+ Released under the terms of the GNU General Public License, GPL,
+ as published by the Free Software Foundation, either version 3
+ of the License, or (at your option) any later version.
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
function db_has_customers()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."debtors_master");
}
}
+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_has_bank_trans_types()
-{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."bank_trans_types");
-}
-
-function check_db_has_bank_trans_types($msg)
-{
- global $path_to_root;
- if (!db_has_bank_trans_types())
- {
- display_error($msg, true);
- end_page();
- exit;
- }
-}
-
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");
}
}
+function db_has_quick_entries()
+{
+ 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
+// Return 1 if number has proper form and is within <min, max> range
+//
+function check_int($postname, $min=null, $max=null) {
+ if(!isset($_POST[$postname]))
+ return 0;
+ $num = input_num($postname);
+ if(!is_int($num))
+ return 0;
+ if (isset($min) && ($num<$min))
+ return 0;
+ if (isset($max) && ($num>$max))
+ return 0;
+ return 1;
+}
+//
+// 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, $dflt=0) {
+ if(!isset($_POST[$postname]))
+ return 0;
+ $num = input_num($postname, $dflt);
+ if ($num === false || $num === null)
+ return 0;
+ if (isset($min) && ($num<$min))
+ return 0;
+ if (isset($max) && ($num>$max))
+ return 0;
+ return 1;
}
+
?>
\ No newline at end of file