WebSVN – SmartDukaan – Diff – //trunk/PyDTR/src/dtr/reports/affiliatereco.py

     email.append('amit.gupta@shop2020.in')
     MAILTO = email
     mailServer.login(SENDER, PASSWORD)
     mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
-def setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet, worksheet3):
+def setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet, worksheet3=None):
     boldStyle = xlwt.XFStyle()
     f = xlwt.Font()
     f.bold = True
     boldStyle.font = f
     row = 0
     affNotReconciledSheet.write(row, inc(), 'Sale Amount', boldStyle)
     affNotReconciledSheet.write(row, inc(), 'Pay Out', boldStyle)
     affNotReconciledSheet.write(row, inc(), 'Status', boldStyle)
     affNotReconciledSheet.write(row, inc(), 'IP', boldStyle)
+    if worksheet3:
-    i =-1
+        i =-1
-    worksheet3.write(row, inc(), 'Date', boldStyle)
+        worksheet3.write(row, inc(), 'Date', boldStyle)
-    worksheet3.write(row, inc(), 'Sale Amount', boldStyle)
+        worksheet3.write(row, inc(), 'Sale Amount', boldStyle)
-    worksheet3.write(row, inc(), 'Approved Sales', boldStyle)
+        worksheet3.write(row, inc(), 'Approved Sales', boldStyle)
-    worksheet3.write(row, inc(), 'Rejected Sales', boldStyle)
+        worksheet3.write(row, inc(), 'Rejected Sales', boldStyle)
 def getUserAmountReconciled():
     pass
 def getUserOrders():

Subversion Repositories SmartDukaan