Subversion Repositories SmartDukaan

Rev

Rev 17161 | Rev 17168 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 17161 Rev 17167
Line 246... Line 246...
246 
    affNotReconciledSheet = workbook.add_sheet("Snapdeal Aff not reconciled")
 246 
    affNotReconciledSheet = workbook.add_sheet("Snapdeal Aff not reconciled")
247 
    setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet, worksheet3)
 247 
    setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet, worksheet3)
248 
    row = 0
 248 
    row = 0
249 
    anotherrow = 0
 249 
    anotherrow = 0
250 
    row5=0
 250 
    row5=0
251 
    datemap={}
 - 
 
252 
    for row1 in curs:
 251 
    for row1 in curs:
253 
        orderId = row1[0]
 252 
        orderId = row1[0]
254 
        order = db.merchantOrder.find_one({"orderId":orderId})
 253 
        order = db.merchantOrder.find_one({"orderId":orderId})
255 
        if order is None:
 254 
        if order is None:
256 
            continue
 255 
            continue
Line 258... Line 257...
258 
        try:
 257 
        try:
259 
            saleTime = datetime.strptime(order['placedOn'], "%a, %d %b, %Y").strftime("%Y-%m-%d")
 258 
            saleTime = datetime.strptime(order['placedOn'], "%a, %d %b, %Y").strftime("%Y-%m-%d")
260 
        except:
 259 
        except:
261 
            saleTime = datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").strftime("%Y-%m-%d")
260 
            saleTime = datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").strftime("%Y-%m-%d")
262
261
263 
        aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))
 - 
 
264 
        if len(aff) > 1:
 - 
 
265 
            aff = [f for f in aff if f.get("payOut")>0]
 - 
 
266 
        anotherrow += 1
 - 
 
267 
        try:
 262 
        try:
268 
            formattedTimestamp = order['placedOn']
 263 
            formattedTimestamp = order['placedOn']
269 
            timestamp1 = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))
 264 
            timestamp1 = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))
270 
        except:
 265 
        except:
271 
            timestamp1 = int(time.mktime(row1[-4].timetuple()))
 266 
            timestamp1 = int(time.mktime(row1[-4].timetuple()))
272 
            formattedTimestamp = datetime.strftime(utils.fromTimeStamp(timestamp1), "%b %d, %Y, %I:%M %p")
 267 
            formattedTimestamp = datetime.strftime(utils.fromTimeStamp(timestamp1), "%b %d, %Y, %I:%M %p")
- 
 
 268 
 
273 
        if len(aff) > 0 and order["subTagId"] not in matchedList and int(order["paidAmount"])==int(aff[0]["saleAmount"]):
 269 
        affs = list(db.snapdealOrderAffiliateInfo1.find({"orderId":order["merchantOrderId"]}))
274
270 
        anotherrow += 1
- 
 
 271 
        if len(affs) > 0:
275 
            matchedList.append(order["subTagId"])
 272 
            matchedList.append(order["merchantOrderId"])
276 
            db.snapdealOrderAffiliateInfo.update({"adId":aff[0].get("adId")}, {"$set":{"reconciled":True, "orderId":orderId}}, multi=True)
 - 
 
277 
            order['reconciled'] = True
 273 
            order['reconciled'] = True
278 
            order['adId'] = aff[0].get("adId")
 - 
 
279 
            db.merchantOrder.save(order)
 274 
            db.merchantOrder.save(order)
280 
            row += 1
 275 
            row += 1
281 
            i=-1
276 
            i=-1
282 
            worksheet.write(row, inc(), orderId)
 277 
            worksheet.write(row, inc(), orderId)
283 
            worksheet1.write(anotherrow, i, orderId)
 - 
 
284 
            worksheet.write(row, inc(), row1[1])
 278 
            worksheet.write(row, inc(), row1[1])
285 
            worksheet1.write(anotherrow, i, row1[1])
 - 
 
286 
            worksheet.write(row, inc(), row1[-1])
 279 
            worksheet.write(row, inc(), row1[-1])
287 
            worksheet1.write(anotherrow, i, row1[-1])
 - 
 
288 
            worksheet.write(row, inc(), row1[-2])
 280 
            worksheet.write(row, inc(), row1[-2])
289 
            worksheet1.write(anotherrow, i, row1[-2])
 - 
 
290 
            worksheet.write(row, inc(), row1[-3])
 281 
            worksheet.write(row, inc(), row1[-3])
291 
            worksheet1.write(anotherrow, i, row1[-3])
 - 
 
292 
            worksheet.write(row, inc(), order['merchantOrderId'])
 282 
            worksheet.write(row, inc(), order['merchantOrderId'])
293 
            worksheet1.write(anotherrow, i, order['merchantOrderId'])
 - 
 
294 
            worksheet.write(row, inc(), order['subTagId'])
 283 
            worksheet.write(row, inc(), order['subTagId'])
295 
            worksheet1.write(anotherrow, i, order['subTagId'])
 - 
 
296 
            worksheet.write(row, inc(), order['placedOn'])
 284 
            worksheet.write(row, inc(), order['placedOn'])
297 
            worksheet1.write(anotherrow, i, order['placedOn'])
 - 
 
298 
            worksheet.write(row, inc(), formattedTimestamp)
 285 
            worksheet.write(row, inc(), formattedTimestamp)
299 
            worksheet1.write(anotherrow, i, formattedTimestamp)
 - 
 
300 
            worksheet.write(row, inc(), int(order['paidAmount']))
 286 
            worksheet.write(row, inc(), int(order['paidAmount']))
301 
            worksheet1.write(anotherrow, i, int(order['paidAmount']))
 - 
 
302 
            worksheet.write(row, inc(), aff[0]['saleDate'])
 - 
 
303 
            worksheet1.write(anotherrow, i, aff[0]['saleDate'])
 - 
 
304 
            worksheet.write(row, inc(), aff[0]['saleAmount'])
 - 
 
305 
            worksheet1.write(anotherrow, i, aff[0]['saleAmount'])
 - 
 
306 
            worksheet.write(row, inc(), aff[0]['payOut'])
 - 
 
307 
            worksheet1.write(anotherrow, i, aff[0]['payOut'])
 - 
 
308 
            worksheet.write(row, inc(), aff[0]['ip'])
 - 
 
309 
            worksheet1.write(anotherrow, i, aff[0]['ip'])
 - 
 
310 
            worksheet.write(row, inc(), aff[0]['conversionStatus'])
 - 
 
311 
            worksheet1.write(anotherrow, i, aff[0]['conversionStatus'])
 - 
 
312 
            k = i
 287 
            k = i
313 
            row -= 1
 288 
            row -= 1
314 
            anotherrow -= 1
 289 
            anotherrow -= 1
315 
            for subOrder in order['subOrders']:
 290 
            for subOrder in order['subOrders']:
316 
                i = k
 291 
                i = k
317 
                row += 1
 292 
                row += 1
318 
                anotherrow += 1
 293 
                anotherrow += 1
319 
                worksheet.write(row, inc(), subOrder['productTitle'])
 294 
                for aff in affs:
320 
                worksheet1.write(anotherrow, i, subOrder['productTitle'])
 295 
                    if subOrder['title']==aff['productCode']:
321 
                worksheet.write(row, inc(), subOrder['amountPaid'])
 296 
                        worksheet.write(row, inc(), aff[0]['saleDate'])
322 
                worksheet1.write(anotherrow, i, subOrder['amountPaid'])
 297 
                        worksheet.write(row, inc(), aff[0]['saleAmount'])
323 
                worksheet.write(row, inc(), subOrder['quantity'])
 298 
                        worksheet.write(row, inc(), aff[0]['payOut'])
324 
                worksheet1.write(anotherrow, i, subOrder['quantity'])
 299 
                        worksheet.write(row, inc(), subOrder['productTitle'])
325 
                worksheet.write(row, inc(), subOrder['status'])
 300 
                        worksheet.write(row, inc(), subOrder['amountPaid'])
326 
                worksheet1.write(anotherrow, i, subOrder['status'])
 301 
                        worksheet.write(row, inc(), subOrder['quantity'])
327 
                worksheet.write(row, inc(), subOrder['cashBackStatus'])
 302 
                        worksheet.write(row, inc(), subOrder['status'])
328 
                worksheet1.write(anotherrow, i, subOrder['cashBackStatus'])
 303 
                        worksheet.write(row, inc(), subOrder['cashBackStatus'])
329 
                worksheet.write(row, inc(), subOrder['cashBackAmount'])
 304 
                        worksheet.write(row, inc(), subOrder['cashBackAmount'])
330 
                worksheet1.write(anotherrow, i, subOrder['cashBackAmount'])
 - 
 
331 
 
 305 
 
332 
        else:
 306 
        else:
333 
            i=-1
 - 
 
334 
            worksheet1.write(anotherrow, inc(), orderId)
 - 
 
335 
            worksheet1.write(anotherrow, inc(), row1[1])
 - 
 
336 
            worksheet1.write(anotherrow, inc(), row1[-1])
 - 
 
337 
            worksheet1.write(anotherrow, inc(), row1[-2])
 - 
 
338 
            worksheet1.write(anotherrow, inc(), row1[-3])
 - 
 
339 
            worksheet1.write(anotherrow, inc(), order['merchantOrderId'])
 - 
 
340 
            worksheet1.write(anotherrow, inc(), order['subTagId'])
 - 
 
341 
            worksheet1.write(anotherrow, inc(), order['placedOn'])
 - 
 
342 
            worksheet1.write(anotherrow, inc(), formattedTimestamp)
 - 
 
343 
            worksheet1.write(anotherrow, inc(), int(order['paidAmount']))
 - 
 
344
- 
 
345 
            notReconciled[orderId] = (anotherrow, i, int(order['paidAmount']), timestamp1, order["subTagId"])
- 
 
346 
            inc()
 - 
 
347 
            inc()
 - 
 
348 
            inc()
 - 
 
349 
            inc()
 - 
 
350 
            inc()
 - 
 
351 
            k = i
 - 
 
352 
            anotherrow -= 1
 - 
 
353 
            for subOrder in order['subOrders']:
 - 
 
354 
                anotherrow += 1
 - 
 
355 
                i = k
 - 
 
356 
                worksheet1.write(anotherrow, inc(), subOrder['productTitle'])
 - 
 
357 
                worksheet1.write(anotherrow, inc(), subOrder['amountPaid'])
 - 
 
358 
                worksheet1.write(anotherrow, inc(), subOrder['quantity'])
 - 
 
359 
                worksheet1.write(anotherrow, inc(), subOrder['status'])
 - 
 
360 
                worksheet1.write(anotherrow, inc(), subOrder['cashBackStatus'])
 - 
 
361 
                worksheet1.write(anotherrow, inc(), subOrder['cashBackAmount'])
 - 
 
362 
            row5 += 1
 307 
            row5 += 1
363 
            i=-1
 308 
            i=-1
364 
            worksheet2.write(row5, inc(), order["orderId"])
 309 
            worksheet2.write(row5, inc(), order["orderId"])
365 
            worksheet2.write(row5, inc(), row1[1])
 310 
            worksheet2.write(row5, inc(), row1[1])
366 
            worksheet2.write(row5, inc(), row1[-1])
 311 
            worksheet2.write(row5, inc(), row1[-1])
Line 948... Line 893...
948 
    sh1 = workbook.add_sheet("All Orders")
 893 
    sh1 = workbook.add_sheet("All Orders")
949 
    sh2 = workbook.add_sheet("Flipkart Orders")
 894 
    sh2 = workbook.add_sheet("Flipkart Orders")
950 
    worksheet = workbook.add_sheet("All Users")
 895 
    worksheet = workbook.add_sheet("All Users")
951
896
952 
    db=client.Dtr
 897 
    db=client.Dtr
953 
    prevDate = date.today() - timedelta(days=61)
 898 
    prevDate = date.today() - timedelta(days=31)
954 
    results = Mysql.fetchResult("select * from allorder where created_on > %s", prevDate)
 899 
    results = Mysql.fetchResult("select * from allorder where created_on > %s", prevDate)
955 
    row = 0
 900 
    row = 0
956 
    i=-1
 901 
    i=-1
957 
    worksheet.write(row, inc(), 'User Id', boldStyle)
 902 
    worksheet.write(row, inc(), 'User Id', boldStyle)
958 
    worksheet.write(row, inc(), 'User name', boldStyle)
 903 
    worksheet.write(row, inc(), 'User name', boldStyle)
Line 1021... Line 966...
1021 
    number_format = xlwt.XFStyle()
 966 
    number_format = xlwt.XFStyle()
1022 
    number_format.num_format_str = '#,##0'
 967 
    number_format.num_format_str = '#,##0'
1023 
 
 968 
 
1024 
 
 969 
 
1025 
    row=0
 970 
    row=0
1026 
    row3=0
 - 
 
1027 
    for r in results:
 971 
    for r in results:
1028 
        row += 1
 972 
        row += 1
1029 
        column = 0
 973 
        column = 0
1030 
        for data in r :
 974 
        for data in r :
1031 
            sh1.write(row, column, int(data) if type(data) is float else data, datetime_format if type(data) is datetime else default_format)
 975 
            sh1.write(row, column, int(data) if type(data) is float else data, datetime_format if type(data) is datetime else default_format)