vtiger.py

from datetime import datetime, timedelta
import sys,requests,pprint

sys.path.append('/home/naren/Downloads/vtwsclib/Vtiger')

from WSClient import *


class KnowTiger(object):

	today = datetime.now()
	def __init__(self,vtigerserver,username,accessKey):
		self.vtigerserver = vtigerserver
		self.username = username
		self.accessKey = accessKey
		self.client = Vtiger_WSClient(vtigerserver)
		self.login = self.client.doLogin(username, accessKey)

	def contact_id(self,number):
		query = "SELECT id FROM Contacts where phone=%s"%number
		result = self.client.doQuery(query)
		return result


	#InDirect
	def search_contact(self,number):
		query = "SELECT * FROM Contacts where phone=%s"%number
		result = self.client.doQuery(query)
		return result

	#InDirect
	def create_contact(self,number,name=None):
		result = self.search_contact(number)
		if not result:
			recordInfo = client.doCreate('Contacts', {'firstname': name , 'phone': number})

	#Direct
	def create_ticket(self,knowlarity_number,callee_number):
		self.create_contact(knowlarity_number)
		query = "SELECT id FROM Contacts where phone=%s"%knowlarity_number
		contact_id = self.contact_id(knowlarity_number)
		ticket = None
		try:
			ticket = self.client.doCreate('HelpDesk',
						{u'ticketstatus': u'Open', 
						u'ticket_title': callee_number + u' called on ' + self.today.strftime(u'%a %b %d %H:%M:%S %Y'),
						u'contact_id': contact_id,
						u'ticketpriorities': u'HIGH'
						})
		except:
			pass
		return ticket

	def view_tables(self):
		query = "SELECT * from Contacts"
		result = self.client.doQuery(query)
		return result


k = KnowTiger('https://knowlaritycommunications.od1.vtiger.com','narenarya246@yahoo.com','LPRiqH1afmLyzNfN')

#pprint.pprint(k.contact_id('1-462-394-1211'))
pprint.pprint(k.view_tables())
#pprint.pprint(k.search_contact(9866086554))