def syncContactData(self):
page = 0
date = datetime.datetime.now().strftime("%Y-%m-%d") + '%'
contactData = self.getContactDataByDate(date, page)
while contactData:
for contact in contactData:
tContact = Contact.objects.filter(CrmId=contact['Id'])
if tContact.exists():
tContact.update(FirstName=contact['FirstName'], LastName=contact['LastName'],
PhoneNumber=contact['Phone1'], Company=contact['Company'])
else:
if 'LastName' not in contact:
contact['LastName'] = ""
if 'FirstName' not in contact:
contact['FirstName'] = ""
if 'Phone1' not in contact:
contact['Phone1'] = ""
if 'Company' not in contact:
contact['Company'] = ""
tContact = Contact(FirstName=contact['FirstName'], LastName=contact['LastName'],
PhoneNumber=contact['Phone1'], Company=contact['Company'], CrmId=contact['Id'])
tContact.save()
page = page + 1
contactData = self.getContactDataByDate(date, page)
print("Contact Synced\n")
def syncInvoiceData(self):
page = 0
date = datetime.datetime.now().strftime("%Y-%m-%d") + '%'
invoiceData = self.getInvoiceDataByDate(date, page)
while invoiceData:
for invoice in invoiceData:
tInvoice = Invoice.objects.filter(InvoiceId=invoice['Id'])
if not tInvoice.exists():
tInvoice = Contact(ContactId=invoice['ContactId'], TotalPaid=invoice['TotalPaid'],
TotalDue=invoice['TotalDue'], InvoiceId=invoice['Id'],
InvoiceTotal=invoice['InvoiceTotal'], RefundStatus=invoice['RefundStatus'],
DateCreated=invoice['DateCreated'])
tInvoice.save()
print("Invoice inserted\n")
page = page + 1
invoiceData = self.getInvoiceDataByDate(date, page)
print("Invoice Synced\n")
