X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_accounts.inc;h=6ee9938236531c36167bf7882ddfbe117a03d053;hb=ae02d179c0a5f6b7a68aaafa8c3591955d864c9f;hp=de487be2d4581a256929bad7e0901532c422dd9f;hpb=f44132511cc91b83f20f91af0625d4b112b4c26e;p=fa-stable.git

diff --git a/gl/includes/db/gl_db_accounts.inc b/gl/includes/db/gl_db_accounts.inc
index de487be2..6ee99382 100644
--- a/gl/includes/db/gl_db_accounts.inc
+++ b/gl/includes/db/gl_db_accounts.inc
@@ -111,7 +111,7 @@ function gl_account_in_company_defaults($acc)
 		OR name='default_cogs_act'
 		OR name='default_adj_act'
 		OR name='default_inv_sales_act'
-		OR name='default_assembly_act') AND value=".db_escape($acc);
+		OR name='default_wip_act') AND value=".db_escape($acc);
 	$result = db_query($sql,"Couldn't test for default company GL codes");
 
 	$myrow = db_fetch_row($result);
@@ -288,3 +288,24 @@ function is_bank_account($account_code)
 	} else
 		return false;
 }
+
+function get_chart_accounts_search($like)
+{
+	global $SysPrefs;
+
+	if (isset($SysPrefs->max_rows_in_search))
+		$limit = $SysPrefs->max_rows_in_search;
+	else
+		$limit = 10;
+
+
+	$sql = "SELECT chart.account_code, chart.account_name, type.name
+			FROM ".TB_PREF."chart_master chart,".TB_PREF."chart_types type
+			WHERE chart.account_type=type.id
+        AND (
+          chart.account_name LIKE " . db_escape("%" . $like. "%") . " OR
+          chart.account_code LIKE " . db_escape("%" . $like. "%") . "
+        ) 
+      	ORDER BY chart.account_code LIMIT 0,".(int)($limit); // We only display 10 items.
+	return db_query($sql, "Failed in retreiving GL account list.");
+}