X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fmanage%2Fcurrencies.php;h=971dbf3b123ca6a38047314c12084ce2f47fbbeb;hb=3ad91c632701f94f1f381c008428751be883ecea;hp=4d5bf91892f1dc1557fb2b05b0c1345991c03f6c;hpb=a1e0df1ef259550f26bc150cf912fd518c7344e3;p=fa-stable.git

diff --git a/gl/manage/currencies.php b/gl/manage/currencies.php
index 4d5bf918..971dbf3b 100644
--- a/gl/manage/currencies.php
+++ b/gl/manage/currencies.php
@@ -9,11 +9,11 @@
     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
-$page_security = 9;
-$path_to_root="../..";
+$page_security = 'SA_CURRENCY';
+$path_to_root = "../..";
 include_once($path_to_root . "/includes/session.inc");
 
-page(_("Currencies"));
+page(_($help_context = "Currencies"));
 
 include_once($path_to_root . "/includes/ui.inc");
 include_once($path_to_root . "/includes/banking.inc");
@@ -80,45 +80,33 @@ function handle_submit()
 
 //---------------------------------------------------------------------------------------------
 
-function check_can_delete()
+function check_can_delete($curr)
 {
-	global $selected_id;
-		
-	if ($selected_id == "")
+
+	if ($curr == "")
 		return false;
+
 	// PREVENT DELETES IF DEPENDENT RECORDS IN debtors_master
-	$sql= "SELECT COUNT(*) FROM ".TB_PREF."debtors_master WHERE curr_code = '$selected_id'";
-	$result = db_query($sql);
-	$myrow = db_fetch_row($result);
-	if ($myrow[0] > 0) 
+	if (key_in_foreign_table($curr, 'debtors_master', 'curr_code'))
 	{
 		display_error(_("Cannot delete this currency, because customer accounts have been created referring to this currency."));
 		return false;
 	}
 
-	$sql= "SELECT COUNT(*) FROM ".TB_PREF."suppliers WHERE curr_code = '$selected_id'";
-	$result = db_query($sql);
-	$myrow = db_fetch_row($result);
-	if ($myrow[0] > 0) 
+	if (key_in_foreign_table($curr, 'suppliers', 'curr_code'))
 	{
 		display_error(_("Cannot delete this currency, because supplier accounts have been created referring to this currency."));
 		return false;
 	}
-		
-	$sql= "SELECT COUNT(*) FROM ".TB_PREF."company WHERE curr_default = '$selected_id'";
-	$result = db_query($sql);
-	$myrow = db_fetch_row($result);
-	if ($myrow[0] > 0) 
+
+	if ($curr == get_company_pref('curr_default'))
 	{
 		display_error(_("Cannot delete this currency, because the company preferences uses this currency."));
 		return false;
 	}
 	
 	// see if there are any bank accounts that use this currency
-	$sql= "SELECT COUNT(*) FROM ".TB_PREF."bank_accounts WHERE bank_curr_code = '$selected_id'";
-	$result = db_query($sql);
-	$myrow = db_fetch_row($result);
-	if ($myrow[0] > 0) 
+	if (key_in_foreign_table($curr, 'bank_accounts', 'bank_curr_code'))
 	{
 		display_error(_("Cannot delete this currency, because thre are bank accounts that use this currency."));
 		return false;
@@ -132,7 +120,7 @@ function check_can_delete()
 function handle_delete()
 {
 	global $selected_id, $Mode;
-	if (check_can_delete()) {
+	if (check_can_delete($selected_id)) {
 	//only delete if used in neither customer or supplier, comp prefs, bank trans accounts
 		delete_currency($selected_id);
 		display_notification(_('Selected currency has been deleted'));
@@ -144,12 +132,10 @@ function handle_delete()
 
 function display_currencies()
 {
-	global $table_style;
-
 	$company_currency = get_company_currency();
 	
     $result = get_currencies(check_value('show_inactive'));
-    start_table($table_style);
+    start_table(TABLESTYLE);
     $th = array(_("Abbreviation"), _("Symbol"), _("Currency Name"),
     	_("Hundredths name"), _("Country"), _("Auto update"), "", "");
 	inactive_control_column($th);
@@ -193,9 +179,9 @@ function display_currencies()
 
 function display_currency_edit($selected_id)
 {
-	global $table_style2, $Mode;
+	global $Mode;
 	
-	start_table($table_style2);
+	start_table(TABLESTYLE2);
 
 	if ($selected_id != '') 
 	{
@@ -258,4 +244,3 @@ end_form();
 
 end_page();
 
-?>