if (!db_query($sql. db_escape($value). " WHERE name=".db_escape($name),
"The company prefferences could not be updated "))
return false;
+ // update cached value
+ $_SESSION['SysPrefs']->prefs[$name] = $value;
}
return true;
}
if (!$prefs)
return $all;
elseif (is_string($prefs))
- return $all[$prefs];
+ return @$all[$prefs];
$ret = array();
foreach($prefs as $name)
function get_base_sales_type()
{
- $sql = "SELECT base_sales FROM ".TB_PREF."company WHERE coy_code=1";
-
- $result = db_query($sql, "could not get base sales type");
- $myrow = db_fetch($result);
- return $myrow[0];
+ return get_company_pref('base_sales');
}
function get_company_extensions($id = -1) {
function get_payment_terms($selected_id)
{
- $sql = "SELECT * FROM ".TB_PREF."payment_terms WHERE terms_indicator=".db_escape($selected_id);
+ $sql = "SELECT *, (t.days_before_due=0) AND (t.day_in_following_month=0) as cash_sale
+ FROM ".TB_PREF."payment_terms t WHERE terms_indicator=".db_escape($selected_id);
$result = db_query($sql,"could not get payment term");
+
return db_fetch($result);
}