WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/script/ProfitMandiSalesAssociate.py

+from datetime import datetime
+from dateutil.relativedelta import relativedelta
 from elixir import *
 from shop2020.model.v1.order.impl import DataService
-from shop2020.model.v1.order.impl.DataService import PMSA_Agents, PMSA, Order, LineItem
-from dateutil.relativedelta import relativedelta
-from datetime import datetime
-from shop2020.utils.Utils import to_java_date
-import xlwt
-from shop2020.thriftpy.model.v1.order.ttypes import OrderStatus
 from shop2020.model.v1.order.impl.Convertors import cutoff_date
+from shop2020.model.v1.order.impl.DataService import PMSA_Agents, PMSA, Order, \
+    LineItem
-from shop2020.utils.EmailAttachmentSender import get_attachment_part
+from shop2020.thriftpy.model.v1.order.ttypes import OrderStatus
 from shop2020.utils import EmailAttachmentSender
+from shop2020.utils.EmailAttachmentSender import get_attachment_part
+from shop2020.utils.Utils import to_java_date
+from xlwt.Style import XFStyle
+import xlwt
 DataService.initialize(db_hostname = "192.168.190.114", echoOn=False)
 associates_map = {}
 retailer_list = []
 user_sales = {}
 xstr = lambda s: s or ""
+date_format = XFStyle()
+date_format.num_format_str = 'dd/MM/yyyy'
 class __retailers:
     def __init__(self, user_id, activated_through, activation_code, order_list, name):
         self.user_id = user_id
         self.name = name
         self.activation_code = activation_code
                 order_list.append(sd)
             retailer.order_list = order_list
 def get_report_headers(wbk):
     sheet = wbk.add_sheet('orders_summary')
-    date_style = xlwt.XFStyle()
-    date_style.num_format_str = "D/M/YY"
     heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
     sheet.set_panes_frozen(True)
     sheet.set_horz_split_pos(1)
     sheet.set_remove_splits(True)
                                 sheet.write(i,3,order.city)
                                 sheet.write(i,4,order.pincode)
                                 sheet.write(i,5,order.contact_number)
                                 sheet.write(i,6,order.name)
                                 sheet.write(i,7,"")
-                                sheet.write(i,8,get_formatted_date(order.order_date))
+                                sheet.write(i,8,get_formatted_date(order.order_date), date_format)
                                 sheet.write(i,9,order.order_id)
                                 sheet.write(i,10,OrderStatus._VALUES_TO_NAMES.get(order.order_status))
-                                sheet.write(i,11, get_formatted_date(order.invoice_date))
+                                sheet.write(i,11, get_formatted_date(order.invoice_date), date_format)
                                 sheet.write(i,12, xstr(order.invoice_number))
-                                sheet.write(i,13, get_formatted_date(order.delivery_date))
+                                sheet.write(i,13, get_formatted_date(order.delivery_date), date_format)
                                 sheet.write(i,14, xstr(order.brand))
                                 sheet.write(i,15, xstr(order.model_name))
                                 sheet.write(i,16, xstr(order.model_number))
                                 sheet.write(i,17, xstr(order.color))
                                 sheet.write(i,18, order.item_id)
             wbk.save(filename)
             email_text = get_email_text(associate['name'], str(get_cut_off().year) + "-" + str(get_cut_off().month)+ "-"+str(get_cut_off().day))
             #EmailAttachmentSender.mail_send_grid("sales-associates@profitmandi.com","apikey", "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", [associate['emailId']], "Order Summary Report "+associate['emailId'],email_text , [get_attachment_part(filename)],["kamini.sharma@profitmandi.com","tarun.verma@profitmandi.com"],["amit.gupta@saholic.com","kshitij.sood@saholic.com"])
             EmailAttachmentSender.mail_send_grid("sales-associates@profitmandi.com","apikey", "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", [associate['emailId']], "Order Summary Report "+associate['emailId'],email_text , [get_attachment_part(filename)],[],[])
+def write_last_month_report():
+    pass
 def get_formatted_date(datetime_obj):
     try:
         return str(datetime_obj.day)+"/"+str(datetime_obj.month)+"/"+str(datetime_obj.year)
     except:
         return ""
 def main():
     get_user_data()
     associates_data()
     track_sales()
-    write_report()
+    #write_report()
+    #generate last month report
+    if datetime.today()==1:
+        write_last_month_report()
 if __name__ == '__main__':
     try:
         main()

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/script/ProfitMandiSalesAssociate.py – Rev 22973 → 22974