rpc_getaccountsbyrule.py
++++++++++++++++++++++++

	+ This file provides accoutnames as per transaction rule.
	+ In acounting there are different type of voucher and each of 
	  them has different rule 
	+ below functions will facilitate those functionality.
	
	+ def xmlrpc_getContraAccounts(self,client_id):
		
		- fetches the list of all accounts which are
		  used in a ``contra voucher``. 
		- takes no arguments and returns list of accounts. 
		  if no accounts are found for contra then returns false.
		- this function is called for populating
		  the account's list with all the accounts for contra.
		- Note that contra voucher only involves cash and bank
		  accounts.
		  
		.. code-block:: python
			
			def xmlrpc_getContraAccounts(self,client_id):
				statement = "select accountname\
					from group_subgroup_account\
					where subgroupname \
					in ('Cash','Bank') order by accountname"
				result = dbconnect.engines[client_id].execute(statement).fetchall()
				if result == []:
					return result
				else:
					contraAccounts = []
					for row in result:
						contraAccounts.append(row[0])
			
					return contraAccounts
	

	+ def xmlrpc_getJournalAccounts(self,client_id):
		
		- fetches the list of all accounts which are
		  used in a ``journal voucher``. 
		- takes no arguments and returns list of accounts. 
		- if no accounts are found for journal then returns false.
		- this function is called for populating
		  the account's list with all the accounts for journal.
		- Note that journal voucher involves all accounts,
		  except cash and bank accounts.
		
		.. code-block:: python	
		
			def xmlrpc_getJournalAccounts(self,client_id):
				statement = "select accountname\
					from group_subgroup_account\
					where subgroupname is null\
					or subgroupname != 'Cash' and subgroupname != 'Bank' order by accountname"
				result = dbconnect.engines[client_id].execute(statement).fetchall()
				if result == []:
					return result
				else:
					journalAccounts = []
					for row in result:
						journalAccounts.append(row[0])
					return journalAccounts

	+ def xmlrpc_getReceivableAccounts(self,queryParams,client_id):
		
		- fetches the list of all accounts which are
		  used in a ``Receivable voucher``.
		- take one argument Cr or Dr and returns list of
		  accounts according.  
		- if no accounts are found for Receivable then returns false.  
		- this function is called for populating
		  the account's list with all the accounts for Receivable.  
		- if account type is ``Cr`` then it will returns
		  account name list, except ``cash`` and ``bank`` accounts.  
		- if account type is ``Dr`` then return only ``cash`` and ``bank`` accounts.
		
		.. code-block:: python	
		
			def xmlrpc_getReceivableAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
					statement = "select accountname\
						from group_subgroup_account\
						where subgroupname is null\
						or subgroupname != 'Cash' and subgroupname != 'Bank' order by accountname"
				
				else :
					statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Cash','Bank') order by accountname"
					   
				result = dbconnect.engines[client_id].execute(statement).fetchall()
	
				if result == []:
					return result
				else:	 
					recievableAccounts = []
					for row in result:
						recievableAccounts.append(row[0])
					return recievableAccounts
			
	+ def xmlrpc_getPaymentAccounts(self,queryParams,client_id):
		
		- fetches the list of all accounts which are
		  used in a ``Payment voucher``.
		- take one argument ``Cr`` or ``Dr`` and 
		  returns list of accounts accordingly.  
		- if no accounts are found for payment then returns false.  
		- this function is called for populating
		  the account's list with all the accounts for payment.
		- if type is ``Dr`` then it will returns list of account
		  names, except ``cash`` and ``bank`` accounts.  
		- if type is ``Cr`` then returns only ``cash`` and ``bank`` accounts.
		
		.. code-block:: python
			
			def xmlrpc_getPaymentAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
				 	statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Cash','Bank') order by accountname"
					   
					#result = dbconnect.engines[client_id].execute(statement).fetchall()
				else:
					statement = "select accountname\
						from group_subgroup_account\
						where subgroupname is null\
						or subgroupname != 'Cash' and subgroupname != 'Bank' order by accountname"
				
				result = dbconnect.engines[client_id].execute(statement).fetchall()
				if result == []:
					return result
				else:
					paymentAccounts = []
					for row in result:
						paymentAccounts.append(row[0])
					return paymentAccounts
	
		
	+ def xmlrpc_getDebitNoteAccounts(self,queryParams,client_id):
		
		- get the list of accounts for debit note
		  either for credit or debit side.  
		- function takes one parameter cr_dr_flag.
		- returns a list of accounts pertaining to
		  debit note.  
		- if the input parameter is ``Cr`` then returns account
		  under the groupnames ``Direct Expense`` ``Fixed Assets`` 
		  ``Indirect Expense``
		- else returns accountname under subgroupnames 
		  ``Sundry Creditors for Expense`` ``Sundry Creditors for Purchase``.
		
		.. code-block:: python
			
			def xmlrpc_getDebitNoteAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
				 	statement = "select accountname\
						from group_subgroup_account\
						where groupname \
						in ('Direct Expense','Fixed Assets','Indirect Expense') order by accountname"
				
				else:
					statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Sundry Creditors for Expense','Sundry Creditors for Purchase') order by accountname"

				result = dbconnect.engines[client_id].execute(statement).fetchall()
				if result == []:
					return result
				else:
					debitnoteAccounts = []
					for row in result:
						debitnoteAccounts.append(row[0])
					return debitnoteAccounts
	

	+ def xmlrpc_getCreditNoteAccounts(self,queryParams,client_id):
		
		- gets the list of accounts for credit note either for credit or debit side. 
		- returns a list of accounts pertaining to credit note.  
		- if the input parameter is ``Cr`` then returns the accountnames under subgroupname
		  ``Sundry Debtors``.
		- else returns account under groupname ``Direct Income`` ``Indirect Income``.

		.. code-block:: python
			
			def xmlrpc_getCreditNoteAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
				 	statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Sundry Debtors') order by accountname"
				
				else:
					statement = "select accountname\
						from group_subgroup_account\
						where groupname \
						in ('Direct Income','Indirect Income') order by accountname"
				
				result = dbconnect.engines[client_id].execute(statement).fetchall()		
				if result == []:
					return result
				else:
					creditnoteAccounts = []
					for row in result:
						creditnoteAccounts.append(row[0])
					return creditnoteAccounts


	+ def xmlrpc_getSalesAccounts(self,queryParams,client_id):
		- gets the list of accounts for sales accounts
		  either for credit or debit side.  
		- returns a list of accounts pertaining to
		  sales accounts.  
		- if the input parameter in queryParams[0] is ``Cr``
		  then return the accountname under groupname ``Direct
		  Income`` ``Indirect Income`` 
		- else returns accountname under subgroupname ``Bank`` ``Cash``
		   ``Sundry Debtor``.
		
		.. code-block:: python
			
			def xmlrpc_getSalesAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
				 	statement = "select accountname\
						from group_subgroup_account\
						where groupname \
						in ('Direct Income','Indirect Income') order by accountname"
				
				else:
					statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Bank','Cash','Sundry Debtors') order by accountname"
						  
				result = dbconnect.engines[client_id].execute(statement).fetchall()	
				if result == []:
					return result
				else:
					salesAccounts = []
					for row in result:
						salesAccounts.append(row[0])
					return salesAccounts
		
	+ def xmlrpc_getPurchaseAccounts(self,queryParams,client_id):
		- gets the list of accounts for purchase
		  accounts either for credit or debit side.  
		- returns a list of accounts pertaining to
		  purchase accounts.  
		- if the input parameter in queryParams[0] is ``Cr`` then 
		  returns accountnames under subgroupname ``Bank`` ``Cash`` 
		  ``Sundry Creditors for Expense`` ``Sundry Creditors for Purchase`` 
		- else returns acountnames under groupnames ``Direct Expense`` ``Indirect Expense``.
		 
		.. code-block:: python
			
			def xmlrpc_getPurchaseAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
				 	statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Bank','Cash','Sundry Creditors for Expense','Sundry Creditors for Purchase') order by accountname"
				
				else:
					statement = "select accountname\
						from group_subgroup_account\
						where groupname \
						in ('Direct Expense','Indirect Expense') order by accountname" 
				
				result = dbconnect.engines[client_id].execute(statement).fetchall()
				if result == []:
					return result
				else:
					purchaseAccounts = []
					for row in result:
						purchaseAccounts.append(row[0])
					return purchaseAccounts

	
	+ def xmlrpc_getSalesReturnAccounts(self,queryParams,client_id):
		
		- gets the list of accounts for ``salesreturn``
		  either for credit or debit side. 
		- returns a list of accounts pertaining to
		  sales return accounts.  
		- If the input parameter in queryParams[0] is ``Cr`` 
		  then returns the accountname under subgroupname ``Sundry Debtors``
		- else returns accountnames under groupname ``Direct Expense`` 
		  ``Indirect Expense`` .
		
		.. code-block:: python
			
			def xmlrpc_getSalesReturnAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
				 	statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Sundry Debtors') order by accountname"
				
				else:
					statement = "select accountname\
						from group_subgroup_account\
						where groupname \
						in ('Direct Expense','Indirect Expense') order by accountname"
				result = dbconnect.engines[client_id].execute(statement).fetchall()
				if result == []:
					return result
				else:
					salesreturnAccounts = []
					for row in result:
						salesreturnAccounts.append(row[0])
					return salesreturnAccounts
		
		
	+ def xmlrpc_getPurchaseReturnAccounts(self,queryParams,client_id):
		
		- gets the list of accounts for ``purchases
		  return`` either for credit or debit side.  
		- returns a list of accounts pertaining to
		  ``purchases return``.  
		- if the input parameter in queryParams[0] is ``Cr`` 
		  then returns accuntnames under groupname ``Direct
		  Income`` ``Indirect Income``
		- else returns accountname under subgroupname 
		  ``Sundry Creditors for Expense`` ``Sundry Creditors for Purchase`` .
		
		.. code-block:: python
			
			def xmlrpc_getPurchaseReturnAccounts(self,queryParams,client_id):
				if  queryParams[0] == 'Cr':
				 	statement = "select accountname\
						from group_subgroup_account\
						where groupname \
						in ('Direct Income','Indirect Income') order by accountname"
				
				else:
					statement = "select accountname\
						from group_subgroup_account\
						where subgroupname \
						in ('Sundry Creditors for Expense','Sundry Creditors for Purchase')  order by accountname" 
				result = dbconnect.engines[client_id].execute(statement).fetchall()
				if result == []:
					return result
				else:
					purchasereturnAccounts = []
					for row in result:
						purchasereturnAccounts.append(row[0])
					return purchasereturnAccounts