X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_accounts.inc;h=34bbdaabd1786c9b26131e4237515d1f0b6e791c;hb=303eb17e9cdd9702eee9fdfcaee51e654a1da541;hp=685619736746e6bffbd9b152d5adf4ed95f8c3d0;hpb=ca24cca52aea78062e53ea229ad43dd464a6b39c;p=fa-stable.git

diff --git a/gl/includes/db/gl_db_accounts.inc b/gl/includes/db/gl_db_accounts.inc
index 68561973..34bbdaab 100644
--- a/gl/includes/db/gl_db_accounts.inc
+++ b/gl/includes/db/gl_db_accounts.inc
@@ -34,7 +34,7 @@ function delete_gl_account($code)
 	db_query($sql, "could not delete gl account");
 }
 
-function get_gl_accounts($from=null, $to=null)
+function get_gl_accounts($from=null, $to=null, $type=null)
 {
 	$sql = "SELECT ".TB_PREF."chart_master.*,".TB_PREF."chart_types.name AS AccountTypeName
 		FROM ".TB_PREF."chart_master,".TB_PREF."chart_types
@@ -43,6 +43,8 @@ function get_gl_accounts($from=null, $to=null)
 		$sql .= " AND ".TB_PREF."chart_master.account_code >= ".db_escape($from);
 	if ($to != null)
 		$sql .= " AND ".TB_PREF."chart_master.account_code <= ".db_escape($to);
+	if ($type != null)
+		$sql .= " AND account_type=".db_escape($type);
 	$sql .= " ORDER BY account_code";
 
 	return db_query($sql, "could not get gl accounts");