day_of_month = monthrange(lastYear, lastMonth)[1] end_day_of_month = yesterday.replace(day=day_of_month) endDayString = end_day_of_month.strftime("%d/%m/%Y") endDayTimeStamp = int(time.mktime(time.strptime(str(endDayString + " 23:59:59"), "%d/%m/%Y %H:%M:%S"))) start_day_of_month = yesterday.replace(day=1) startDayString = start_day_of_month.strftime("%d/%m/%Y") startDayTimeStamp = int(time.mktime(time.strptime(str(startDayString + " 00:00:00"), "%d/%m/%Y %H:%M:%S"))) else: lastMonth = month firstDayOfMonth = datetime(year, lastMonth, 1, 0, 0) # TẠO ROW CHO TỪNG PARTNER NẾU CHƯA TỒN TẠI partner_lists = mongodb.getDistinct(MONGO_COLLECTION=collection , SELECT="COMPANY") if partner_lists != None: for row_partner in partner_lists: pprint(row_partner) exists_amount = mongodb.count(MONGO_COLLECTION=collection_amount_report,WHERE={'partner':row_partner, 'year' : {'$eq' : str(year)} }) if exists_amount == 0 : mongodb.insert(MONGO_COLLECTION=collection_amount_report, insert_data={ 'partner': row_partner, 'outsoucing' : { 'account' : { 'before' : { 'l30' : { 'T1':0,'T2':0,'T3':0,'T4':0,'T5':0,'T6':0,'T7':0,'T8':0,'T9':0,'T10':0,'T11':0,'T12':0}, 'p30' : { 'T1':0,'T2':0,'T3':0,'T4':0,'T5':0,'T6':0,'T7':0,'T8':0,'T9':0,'T10':0,'T11':0,'T12':0}, 'p60' : { 'T1':0,'T2':0,'T3':0,'T4':0,'T5':0,'T6':0,'T7':0,'T8':0,'T9':0,'T10':0,'T11':0,'T12':0}, 'p90' : { 'T1':0,'T2':0,'T3':0,'T4':0,'T5':0,'T6':0,'T7':0,'T8':0,'T9':0,'T10':0,'T11':0,'T12':0}, 'p180' : { 'T1':0,'T2':0,'T3':0,'T4':0,'T5':0,'T6':0,'T7':0,'T8':0,'T9':0,'T10':0,'T11':0,'T12':0}, 'subtotal':{ 'T1':0,'T2':0,'T3':0,'T4':0,'T5':0,'T6':0,'T7':0,'T8':0,'T9':0,'T10':0,'T11':0,'T12':0},
tt_temp['group'] = "TOTAL" tt_temp["g" + product_value['code']] = total_report1[0][ "g" + product_value['code']] tt_temp["a" + product_value['code']] = total_report1[0][ "a" + product_value['code']] tt_temp['t_g'] = total_report1[0]["t_g"] tt_temp['t_a'] = total_report1[0]["t_a"] tt_temp['createdAt'] = time.time() insertData1.append(tt_temp) if len(insertData1) > 0: mongodb.batch_insert(MONGO_COLLECTION=temp_collection, insert_data=insertData1) # doc du lieu ra tu bang tam grouplist = mongodb.getDistinct(MONGO_COLLECTION=temp_collection, SELECT='group') i = 0 for group in grouplist: i = i + 1 temp = {} list_product = mongodb.get(common.getSubUser(subUserType, 'Product'), SORT=[("code", 1)]) for product_code, product_value in enumerate(list_product): aggregate_sum = [ { "$match": { 'group': group, # "$and" : [{ # "createdAt" : { # "$gte" : startMonth, # "$lte" : endMonth