rpc_groups.py
+++++++++++++
	+ This is the class ``groups`` provides the information about tha ``groups`` and ``subgroups``
	  as per accounting rule .
	+ we already have some ``groups`` and ``subgroups`` for the given organisation while deploying.
	  or creating organisation.
	+ to know present groupnames and subgroupnames see ``rpc_Deploy`` function from ``rpc_main`` module.
	+ import liabraries as needed.
	
	+ def xmlrpc_setSubGroup(self,queryParams,client_id):
	
		- used ``subGroups`` table to query .
		- function for adding new subgroups in table subgroups	
		- Parameters : groupname(datatype:text), subgroupname(datatype:text) , client_id (datatype:integer)
		- Returns : returns 1 when successful, 0 when subgroupname(datatype:text) is null
		  When successful it returns 1 otherwise it returns 0. 
		
		.. code-block:: python
		
			def xmlrpc_setSubGroup(self,queryParams,client_id):
		
				queryParams = blankspace.remove_whitespaces(queryParams)
				# call getGroupCodeByGroupName func to get groupcode
				result = self.xmlrpc_getGroupCodeByGroupName([queryParams[0]],client_id) 
				# call getSubGroupCodeBySubGroupName fun to get subgroupcode
				 
				if result != None:
					group_code = result[0]
					#print group_code
					connection = dbconnect.engines[client_id].connect()
					Session = dbconnect.session(bind=connection)
					Session.add_all([dbconnect.subGroups(group_code,queryParams[1])])
					Session.commit()
					Session.close()
					connection.connection.close()
					if queryParams[1]=="null":
						return "0"
					else:
						return "1"
				else:
					return []
	
	+ def xmlrpc_getAllGroups(self,client_id):
		
		- function to get all groups present in the groups table
		- querys the ``Groups`` table,it retrieves all rows of groups table based on groupname.
		- when successful it returns the list of lists
		- list contain each row that are retrived from groups table 
		- input: client_id(datatype:integer) from client side
		- output: returns list containing group groupcode(datatype:integer),groupname(datatype:text),groupdescription(datatype:text).
		
		.. code-block:: python
			
			def xmlrpc_getAllGroups(self,client_id):
		
		
				connection = dbconnect.engines[client_id].connect()
				Session = dbconnect.session(bind=connection)
				result = Session.query(dbconnect.Groups).order_by(dbconnect.Groups.groupname).all()
				Session.close()
				connection.connection.close()
				#print result
				if result == []:
					return result
				else:
					grouplist = []
					for i in range(0,len(result)):
						grouplist.append([result[i].groupcode, result[i].groupname, result[i].groupdesc])
					#print grouplist
					return grouplist
	
	+ def xmlrpc_getSubGroupsByGroupName(self,queryParams,client_id):
	 
		- function for extracting all rows of view_group_subgroup based on groupname
		- querys the ``view_group_subgroup`` which is created based on the account,
		  subgroups and groups table.	
		- it retrieves all rows of view_group_subgroup based on groupname order by subgroupname.
		- input: list containing groupname(datatype:text)
		- returns: When successful it returns the list of lists in which 
			   each list contain each row that are retrived from view otherwise 
			   it returns list in which two default subgroup strings.
			    
		.. code-block:: python
				
			def xmlrpc_getSubGroupsByGroupName(self,queryParams,client_id):
		
				queryParams = blankspace.remove_whitespaces(queryParams)
				statement = "select subgroupname\
					from view_group_subgroup\
					where groupname ='"+queryParams[0]+"'\
					order by subgroupname"
			
				result=dbconnect.engines[client_id].execute(statement).fetchall()
				subgrouplist = []
				if result == []:
					subgrouplist.append("No Sub-Group")
					subgrouplist.append("Create New Sub-Group")
					#print subgrp
					return subgrouplist
				else:
					subgrouplist.append("No Sub-Group")
					for l in range(0,len(result)): 
						subgrouplist.append(result[l][0])
					subgrouplist.append("Create New Sub-Group")
					#print subgrp
					return subgrouplist
		
	+ def xmlrpc_getGroupCodeByGroupName(self,queryParams,client_id):
	
		- function for extracting groupcpde of group based on groupname.
		- query to retrive groupcode requested groupname by client
		- input : groupname(datatype:text) , client_id(datatype:integer)
		- output : returns list containing groupcode if its not None else will return false.
		
		.. code-block:: python
				
			def xmlrpc_getGroupCodeByGroupName(self,queryParams,client_id):
		
				queryParams = blankspace.remove_whitespaces(queryParams)
				connection = dbconnect.engines[client_id].connect()
				Session = dbconnect.session(bind=connection)
				result = Session.query(dbconnect.Groups).\
				      filter(dbconnect.Groups.groupname == queryParams[0]).\
				      first()
				Session.close()
				connection.connection.close()
				if result != None:
			
					return [result.groupcode]
				else:
					return []
	
	+ def xmlrpc_getSubGroupCodeBySubGroupName(self,queryParams,client_id):
	
		- function for extracting subgroupcpde of group based on subgroupname
		- query the subgroup table to retrive subgroupcode for reqested subgroupname 
		- input: subgroupname(datatype:text),client_id(datatype:integer)
		- output: returns list containing subgroupcode if its not None else will return false.
			
		.. code-block:: python
		
			def xmlrpc_getSubGroupCodeBySubGroupName(self,queryParams,client_id):
		
				queryParams = blankspace.remove_whitespaces(queryParams)
				connection = dbconnect.engines[client_id].connect()
				Session = dbconnect.session(bind=connection)
				result = Session.query(dbconnect.subGroups).\
				      filter(dbconnect.subGroups.subgroupname == queryParams[0]).\
				      first()
				Session.close()
				connection.connection.close()
				if result != None:
			
					return [result.subgroupcode]
				else:
					return []
	
	+ def xmlrpc_getGroupNameByAccountName(self,queryParams,client_id):
	
		- function for extracting groupname from group table by account name
		- i/p: accountname
		- o/p: groupname
		
		.. code-block:: python
			
			def xmlrpc_getGroupNameByAccountName(self,queryParams,client_id):
			
				connection = dbconnect.engines[client_id].connect()
				Session = dbconnect.session(bind=connection)
				result = Session.query(dbconnect.Groups).select_from(join(dbconnect.Groups,dbconnect.Account)).\
					filter(and_(dbconnect.Account.accountname == queryParams[0],\
					dbconnect.Groups.groupcode == dbconnect.Account.groupcode)).\
					first()
				Session.close()
				connection.connection.close()
				if result != None:
					return [result.groupname]
				else:
					return []
					
	+ def xmlrpc_subgroupExists(self,queryParams,client_id):
		
		- checks if the new subgroup typed by the user already exists.
		- This will validate and prevent any duplication.
		- The function takes queryParams as its parameter and contains one element, 
		  the subgroupname as string.
		- input: subgroupname(datatype:text)	
		- output : Returns ``1`` if the subgroup exists else ``0``.
		
		.. code-block:: python	
				
			def xmlrpc_subgroupExists(self,queryParams,client_id):	
		
				queryParams = blankspace.remove_whitespaces(queryParams)	
				connection = dbconnect.engines[client_id].connect()
				Session = dbconnect.session(bind=connection)
				result = Session.query(func.count(dbconnect.subGroups.subgroupname)).\
				      filter((func.lower(dbconnect.subGroups.subgroupname)) == queryParams[0].lower()).scalar()
				Session.close()
				connection.connection.close()
				print "subgroup exist"
				print result
				if result == 0:
					return "0"
				else:
					return "1"