temp['ratio_target_no'] = (temp['accumulated_no'] / temp['target_no']) * 100 else: temp['ratio_target_no'] = 0 if temp['start_os_bl'] != 0: temp['ratio_start_os_bl'] = (temp['accumulated_os_bl'] / temp['start_os_bl']) * 100 else: temp['ratio_start_os_bl'] = 0 if temp['start_no'] != 0: temp['ratio_start_no'] = (temp['accumulated_no'] / temp['start_no']) * 100 else: temp['ratio_start_no'] = 0 mongodb.insert(MONGO_COLLECTION=collection, insert_data=temp) mongodb.update(MONGO_COLLECTION=collection, WHERE={ 'created_at': { '$gte': yesterdayTimeStamp, '$lte': (yesterdayTimeStamp + 86399) }, 'debt_group_name': group }, VALUE=tempYesterday) # pprint(insertData) except Exception as e: log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': ' + str(e) + '\n')
if day == 1: mongodb.create_db(DB_NAME=logDbName) mongodbresult = Mongodb(logDbName) else: mongodbresult = Mongodb(logDbName) ftpLocalUrl = common.getDownloadFolder() + fileName try: sys.argv[1] importLogId = str(sys.argv[1]) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': ObjectId(sys.argv[1])}, VALUE={ 'command': '/usr/local/bin/python3.6 ' + base_url + "cronjob/python/Loan/importAppointment_cron.py " + importLogId + " > /dev/null &" }) importLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': ObjectId(sys.argv[1])}) except Exception as SysArgvError: if not os.path.isfile(ftpLocalUrl): sys.exit() importLogInfo = { 'collection': collection, 'begin_import': time.time(), 'file_name': fileName,
group = 'C' + debt_group if int(sbv['delinquency_group']) == 4: group = 'D' + debt_group if int(sbv['delinquency_group']) == 5: group = 'E' + debt_group temp['account_number'] = row['account_number'] temp['due_date'] = row['overdue_date'] temp['group'] = group temp['group_number'] = sbv['delinquency_group'] temp['created_at'] = int(time.time()) temp['created_by'] = 'system' insertData.append(temp) tempSbv['first_due_group'] = sbv['delinquency_group'] mongodb.update( MONGO_COLLECTION=sbv_collection, WHERE={'contract_no': str(row['account_number'])}, VALUE=tempSbv) # print(temp) if mod > 0: result = mongodb.get(MONGO_COLLECTION=account_collection, SELECT=['account_number', 'overdue_date'], SORT=([('_id', -1)]), SKIP=int(int(quotient) * limit), TAKE=int(mod)) for idx, row in enumerate(result): temp = {} tempSbv = {} group = '' if row['overdue_date'] != 0: date_time = datetime.fromtimestamp(row['overdue_date'])
value['updatedAt'])) if 'updatedAt' in value.keys( ) and value['updatedAt'] != '' else '' worksheet.write(key + 1, header_key, cell_value) # worksheet.set_column(key + 1, header_key, len(str(cell_value))) continue cell_value = str( value[header_value]) if header_value in value.keys() else '' worksheet.write(key + 1, header_key, cell_value) workbook.close() now_end = datetime.now() if 'exportLogId' in locals(): mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Export'), WHERE={'_id': ObjectId(exportLogId)}, VALUE={ 'status': 1, 'end': time.time() }), # notification = { # 'title' : f'Export Calling list success', # 'active' : True, # 'icon' : 'fa fa-info-circle', # 'color' : 'text-success', # 'content' : f'Xuất excel thành công. Nhấn vào thông báo để tải về.', # 'link' : '/upload/telesales/export/Calling_list'+ today.strftime("%d%m%Y") +'.xlsx', # 'to' : exportLogInfo['created_by'], # 'notifyDate' : datetime.utcnow(), # 'is_download' : True, # 'createdBy' : 'System', # 'createdAt' : time.time()
MONGO_COLLECTION=collection, WHERE={'CONTRACTNR': temp['CONTRACTNR']}) if checkInfo is not None: updateDate.append(temp) else: insertData.append(temp) result = True if (len(errorData) > 0): mongodb.batch_insert( common.getSubUser(subUserType, 'Cus_assigned_partner_result'), errorData) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': importLogId}, VALUE={ 'status': 0, 'complete_import': time.time() }) else: if len(insertData) > 0: mongodb.batch_insert(MONGO_COLLECTION=collection, insert_data=insertData) mongodb.batch_insert(common.getSubUser( subUserType, 'Cus_assigned_partner_result'), insert_data=insertData) if len(updateDate) > 0: for updateD in updateDate: mongodb.update(MONGO_COLLECTION=collection, WHERE={'CONTRACTNR': temp['CONTRACTNR']},
try: importLogId = sys.argv[1] random = sys.argv[2] extensions = sys.argv[3] insertData = [] resultData = [] errorData = [] randoms = random.split(',') extensions = extensions.split(',') # log.write(str(extensions)) now = datetime.now() log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': Start Log' + '\n') mongodb.update(MONGO_COLLECTION='TS_Import', WHERE={'_id': ObjectId(importLogId)}, VALUE={'assign': int(-1)}) assign_log = mongodb.getOne(MONGO_COLLECTION='TS_Assign_log') if assign_log == None: users = _mongodb.get(MONGO_COLLECTION='TS_User', WHERE=None, SELECT=['extension', 'agentname'], SORT=([('id', 1)])) users = list(users) # log.write(str(users)) arrayCMND = {} assign_log = {} for user in users: arrayCMND[user['extension']] = [] assign_log[user['extension']] = [] assign_log['_id'] = mongodb.insert('TS_Assign_log', arrayCMND) array_cmnd = [] for u,extension in enumerate(extensions): user = _mongodb.getOne(MONGO_COLLECTION='TS_User', WHERE={'extension': str(extension)}, SELECT=['extension', 'agentname'])
temp['account_number'] = row['account_number'] temp['due_date'] = due_date temp['group'] = group temp['group_number'] = sbv['delinquency_group'] temp['created_at'] = todayTimeStamp temp['created_by'] = 'system' checkDataInDB = mongodb.getOne(MONGO_COLLECTION=collection, WHERE={'account_number': temp['account_number']}) if checkDataInDB is not None: updateDate.append(temp) else: insertData.append(temp) # tempSbv['first_due_group'] = sbv['delinquency_group'] # mongodb.update(MONGO_COLLECTION=sbv_collection, WHERE={'contract_no': str(row['account_number'])}, VALUE=tempSbv) if len(insertData) > 0: mongodb.batch_insert(MONGO_COLLECTION=collection, insert_data=insertData) if len(updateDate) > 0: for updateD in updateDate: mongodb.update(MONGO_COLLECTION=collection, WHERE={'account_number': updateD['account_number']}, VALUE=updateD) now_end = datetime.now() log.write(now_end.strftime("%d/%m/%Y, %H:%M:%S") + ': End Log' + '\n') print('DONE') except Exception as e: print(e) log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': ' + str(e) + '\n')
temp['created_at'] = time.time() temp['import_id'] = str(importLogId) if(result == False): errorData.append(temp) else: temp['result'] = 'success' checkDataInDB = mongodb.getOne(MONGO_COLLECTION=collection, WHERE={'account_number': temp['account_number']}) if checkDataInDB is not None: updateDate.append(temp) else: insertData.append(temp) result = True # break if(len(errorData) > 0): mongodb.batch_insert(common.getSubUser(subUserType, 'LNJC05_result'), errorData) else: if len(insertData) > 0: mongodb.remove_document(MONGO_COLLECTION=collection) mongodb.batch_insert(MONGO_COLLECTION=collection, insert_data=insertData) mongodb.batch_insert(common.getSubUser(subUserType, 'LNJC05_result'), insert_data=insertData) if len(updateDate) > 0: for updateD in updateDate: mongodb.update(MONGO_COLLECTION=collection, WHERE={'account_number': updateD['account_number']}, VALUE=updateD) mongodb.batch_insert(common.getSubUser(subUserType, 'LNJC05_result'), insert_data=updateDate) mongodb.update(MONGO_COLLECTION=common.getSubUser(subUserType, 'Import'), WHERE={'_id': importLogId}, VALUE={'status': 1, 'complete_import': time.time(),'error': errorData}) print(111) except Exception as e: log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': ' + str(e) + '\n')
}) if checkdata is not None: updateDate.append(temp) else: insertData.append(temp) # mongodb.remove_document(MONGO_COLLECTION=collection) if (len(errorData) > 0): mongodb.batch_insert( common.getSubUser(subUserType, 'WO_monthly_result'), errorData) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': importLogId}, VALUE={ 'status': 0, 'complete_import': time.time(), 'total': total, 'complete': complete }) else: if len(insertData) > 0: mongodb.batch_insert(MONGO_COLLECTION=collection, insert_data=insertData) mongodb.batch_insert(common.getSubUser(subUserType, 'WO_monthly_result'), insert_data=insertData) if len(updateDate) > 0: for updateD in updateDate: mongodb.update(MONGO_COLLECTION=collection, WHERE={
# except Exception as e: # log.write(traceback.format_exc()) # print(traceback.format_exc()) # UPDATE LAST CALL CALLING LIST # try: # listCallingList = mongodb.get(MONGO_COLLECTION=collection) # for callingList in listCallingList: # if 'phone' in callingList.keys(): # cdrInfo = list(mongodb.get(MONGO_COLLECTION='TS_worldfonepbxmanager', WHERE={'customernumber': callingList['phone']}, SELECT={'starttime'}, SORT=[('starttime', -1)], TAKE=1)) # if len(cdrInfo) > 0: # mongodb.update(MONGO_COLLECTION=collection, WHERE={'_id': ObjectId(callingList['_id'])}, VALUE={'starttime_call': cdrInfo[0]['starttime']}) # pprint(cdrInfo) # except Exception as e: # pprint(traceback.format_exc()) # Update last_modified try: listAppointment = mongodb.get("TS_Appointment") for appointment in listAppointment: if 'updated_at' not in appointment.keys(): mongodb.update(MONGO_COLLECTION='TS_Appointment', WHERE={'_id': appointment['_id']}, VALUE={'last_modified': appointment['created_at']}) else: mongodb.update(MONGO_COLLECTION='TS_Appointment', WHERE={'_id': appointment['_id']}, VALUE={'last_modified': appointment['updated_at']}) except Exception as e: pprint(traceback.format_exc())
}] for product in products: if product['group_code'] != '300': list_prod_code = list( common.array_column(product['product_code'], 'code')) rows = [] listCoumn = { 'for_year': reportDate[str(todayTimeStamp)]['for_year'], 'prod_group_code': product['group_code'], } mongodb.update( MONGO_COLLECTION=common.getSubUser( subUserType, 'First_time_payment_delinqunecy_columns'), WHERE={ 'for_year': str(reportDate[str(todayTimeStamp)]['for_year']), 'prod_group_code': product['group_code'] }, VALUE=listCoumn) temp_column = [] for rowValue in rowsValue: if rowValue['value'] == 'payday': temp = { 'for_month': str(reportDate[str(todayTimeStamp)]['for_month']), 'for_year': str(reportDate[str(todayTimeStamp)]['for_year']), 'prod_group_code': product['group_code'], 'prod_group_name':
value = str(listDataLibrary[key][idx]) temp['createdBy'] = 'Byfixed-Import' if header['field'] == 'assign' and value == '': temp['createdBy'] = '' temp[header['field']] = value temp['id_import'] = importLogId temp['createdAt'] = int(time.time()) temp['updatedAt'] = int(time.time()) temp['updatedBy'] = 'system' if checkErr == False: try: mongodb.update(MONGO_COLLECTION=collection, WHERE={'cif': temp['cif']}, VALUE=temp) except Exception as e: now_log = datetime.now() # log.write(now_log.strftime("%d/%m/%Y, %H:%M:%S") + ': ' + str(err) + '\n') if len(errorData) <= 0: status = 1 else: status = 0 # log.write( str(errorData) + '\n') mongodb.update(MONGO_COLLECTION='TS_Import', WHERE={'_id': ObjectId(importLogId)}, VALUE={ 'complete_import': time.time(),
complete += 1 if (len(errorData) > 0): mongodbresult.remove_document( MONGO_COLLECTION=common.getSubUser(subUserType, ( 'Cus_assigned_partner_' + str(year) + str(month) + str(day)))) mongodbresult.batch_insert( common.getSubUser( subUserType, ('Cus_assigned_partner_' + str(year) + str(month) + str(day))), errorData) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': importLogId}, VALUE={ 'status': 0, 'complete_import': time.time(), 'total': total, 'complete': complete }) else: if len(insertData) > 0: mongodb.batch_insert(MONGO_COLLECTION=collection, insert_data=insertData) if len(updateDate) > 0: for updateD in updateDate: mongodb.update(MONGO_COLLECTION=collection, WHERE={'CONTRACTNR': updateD['CONTRACTNR']}, VALUE=updateD) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'),
temp['kendoGridField'] = scField temp['result'] = 'success' temp['from_date'] = int( time.mktime(time.strptime(ngayTrucs[idx], "%d/%m/%Y"))) insertData.append(temp) resultData.append(temp) else: errorData.append(temp) resultData.append(temp) if len(errorData) > 0: resultImport = mongodb.batch_insert( common.getSubUser(subUserType, 'Sc_schedule_result'), errorData) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': ObjectId(importLogId)}, VALUE={ 'status': 0, 'complete_import': time.time() }) else: resultImport = mongodb.batch_insert(collection, insertData) resultImport = mongodb.batch_insert( common.getSubUser(subUserType, 'Sc_schedule_result'), resultData) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': ObjectId(importLogId)}, VALUE={ 'status': 1, 'complete_import': time.time() }) except Exception as e:
total_overdue_outstanding_bal += no_overdue_amt if key == '6': temp['index_' + str(todayIndex)] = yesterdayInfo['index_' + str(todayIndex - 1)] - no_overdue_amt if yesterdayInfo is not None and yesterdayInfo['index_' + str(todayIndex - 1)] is not None else 0 total_collected_amt_and_day += temp['index_' + str(todayIndex)] if key == '7': temp['index_' + str(todayIndex)] = yesterdayInfo['start_amt'] - no_overdue_amt if yesterdayInfo is not None and yesterdayInfo['start_amt'] is not None else 0 total_collected_amt_accumulated += temp['index_' + str(todayIndex)] if key == '8': temp['index_' + str(todayIndex)] = (yesterdayInfo['index_' + str(todayIndex - 1)] - no_overdue_amt) / yesterdayInfo['start_amt'] if yesterdayInfo is not None and yesterdayInfo['start_amt'] is not None and yesterdayInfo['index_' + str(todayIndex - 1)] is not None else 0 total_collected_ratio_amt += temp['index_' + str(todayIndex)] if yesterdayInfo is not None: mongodb.update(MONGO_COLLECTION=common.getSubUser(subUserType, 'Daily_prod_working_day'), WHERE={'team_id': str(groupCell['_id']), 'day_code': key, 'updated_at': {'$gte': yesterday_starttime, '$lte': yesterday_endtime}}, VALUE=temp) else: temp['group'] = debtGroupCell[0:1] + ' GROUP' temp['month'] = today.strftime("%b-%y") temp['due'] = due[debtGroupCell[1:3]] temp['product'] = groupProductCell['value'] if todayTimeStamp > dueDayOfMonth['due_date_add_1']: temp['due_date']= dueDayOfMonth['due_date_add_1'] else: temp['due_date']= dueDayLastMonth['due_date_add_1'] temp['due_date'] = todayTimeStamp - 86400 temp['day'] = dpWorkingdaysdaycol[key] temp['day_code'] = key temp['team_name'] = groupCell['name'] temp['team_id'] = str(groupCell['_id']) temp['created_at'] = time.time()
temp_card_10_days = {} lnjc05_aggregate = [{ '$match': { 'group_id': 'A' + report_day['debt_group'], } }] lnjc05_info = list( mongodb.aggregate_pipeline( MONGO_COLLECTION=common.getSubUser(subUserType, lnjc05_today), aggregate_pipeline=lnjc05_aggregate)) temp_sibs_10_days['group_2_tran_no'] = len(lnjc05_info) mongodb.update(MONGO_COLLECTION=collection, WHERE={ 'for_month': str(report_day['for_month']), 'for_year': str(report_day['for_year']), 'debt_group': 'A' + report_day['debt_group'], 'prod_name': 'Bike/PL' }, VALUE=temp_sibs_10_days) list_acc_info_temp = list( mongodb.get(MONGO_COLLECTION=common.getSubUser( subUserType, list_of_acc_today), SELECT=['account_number'])) list_acc_info = list( common.array_column(list_acc_info_temp, 'account_number')) check_with_store = list( mongodb.get(MONGO_COLLECTION=common.getSubUser( subUserType, sbv_store), WHERE={ 'contract_no': {
if header['field'] == 'assign' and value == '': temp['createdBy'] = '' temp['assign_name'] = '' temp[header['field']] = value temp['id_import'] = importLogId temp['createdAt'] = int(time.time()) temp['updatedAt'] = int(time.time()) temp['updatedBy'] = 'system' header_index += 1 if checkErr == False: try: mongodb.update(MONGO_COLLECTION=collection, WHERE={'id_no': temp['id_no']}, VALUE=temp) except Exception as e: now_log = datetime.now() # log.write(now_log.strftime("%d/%m/%Y, %H:%M:%S") + ': ' + str(e) + '\n') if len(errorData) <= 0: # mongodb.insert('2_Assign_log', arrayCMND) status = 1 else: status = 0 # print(errorData) # log.write( str(errorData) + '\n') mongodb.update(MONGO_COLLECTION='TS_Import', WHERE={'_id': ObjectId(importLogId)},
} }, { "$group": { "_id": '$DPD', "sum_acc": {'$sum': 1}, "sum_amount": {'$sum': '$amount'}, } } ] data = mongodb.aggregate_pipeline(MONGO_COLLECTION=collection_temp,aggregate_pipeline=aggregate_pipeline) if data != None: for row_result in data: if(row_result['_id'] == '<30'): modified = mongodb.update(MONGO_COLLECTION=collection_amount_report,WHERE=where,VALUE={'outsoucing.account.before.l30.T'+str(lastMonth) :row_result['sum_acc'], 'outsoucing.amount.before.l30.T'+str(lastMonth) : row_result['sum_amount']}) elif(row_result['_id'] == '30+'): modified = mongodb.update(MONGO_COLLECTION=collection_amount_report,WHERE=where,VALUE={'outsoucing.account.before.l30.T'+str(lastMonth) :row_result['sum_acc'], 'outsoucing.amount.before.l30.T'+str(lastMonth) : row_result['sum_amount']}) elif(row_result['_id'] == '60+'): modified = mongodb.update(MONGO_COLLECTION=collection_amount_report,WHERE=where,VALUE={'outsoucing.account.before.p60.T'+str(lastMonth) :row_result['sum_acc'], 'outsoucing.amount.before.p60.T'+str(lastMonth) : row_result['sum_amount']}) elif(row_result['_id'] == '90+'): modified = mongodb.update(MONGO_COLLECTION=collection_amount_report,WHERE=where,VALUE={'outsoucing.account.before.p90.T'+str(lastMonth) :row_result['sum_acc'], 'outsoucing.amount.before.p90.T'+str(lastMonth) : row_result['sum_amount']}) elif(row_result['_id'] == '180+'): modified = mongodb.update(MONGO_COLLECTION=collection_amount_report,WHERE=where,VALUE={'outsoucing.account.before.p180.T'+str(lastMonth):row_result['sum_acc'], 'outsoucing.amount.before.p180.T'+str(lastMonth) : row_result['sum_amount']}) else: continue # tinh subtotal aggregate_pipeline = [ { '$match' : {
zaccf['error_mesg'] = 'Sai kiểu dữ liệu nhập' zaccf['result'] = 'error' result = False if(result == False): errorData.append(zaccf) else: if(checkSibs is None): insertData.append(zaccf) else: updateData.append(zaccf) zaccf['result'] = 'success' result = True else: continue if(len(errorData) > 0): mongodb.batch_insert(common.getSubUser(subUserType, 'Sibs_result'), errorData) else: if len(updateData) > 0: for upData in updateData: mongodb.update(MONGO_COLLECTION=collection, WHERE={'account_no': upData['account_no']}, VALUE=upData) mongodb.batch_insert(common.getSubUser(subUserType, 'Sibs_result'), updateData) if len(insertData) > 0: mongodb.batch_insert(MONGO_COLLECTION=collection, insert_data=insertData) mongodb.batch_insert(common.getSubUser(subUserType, 'Sibs_result'), insert_data=insertData) mongodb.update(MONGO_COLLECTION=common.getSubUser(subUserType, 'Import'), WHERE={'_id': ObjectId(importLogId)}, VALUE={'status': 1, 'complete_import': time.time()}) pprint({'status': 1}) except Exception as e: log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': ' + str(e) + '\n')
temp['daily_no'] = temp['start_no'] checkYesterDay = mongodb.count(MONGO_COLLECTION=collection, WHERE={ 'createdAt': dueDayOfMonth['due_date'], 'debt_group': duedate_type, 'type': targetGroup['debt_type'] }) if len(temp_final) > 0: mongodb.update(MONGO_COLLECTION=collection, WHERE={ 'createdAt': dueDayOfMonth['due_date'], 'debt_group': duedate_type, 'type': targetGroup['debt_type'] }, VALUE=temp_final) # if todayTimeStamp > dueDayOfMonth['due_date_add_1']: # temp['due_date'] = dueDayOfMonth['due_date'] else: if targetGroup['debt_type'] == 'SIBS': aggregate_lnjc05 = [{ "$match": { "group_id": duedate_type, } }, { "$group": { "_id": 'null',
'_' + str(report_year)] = sum( map( lambda x: float(x), zaccf['group_3_over_w_org'] if 'group_3_over_w_org' in zaccf.keys() else 0)) temp_detail['group_3_over_acc_count_' + str( report_month ) + '_' + str(report_year)] = zaccf[ 'group_3_over_acc_count'] if 'group_3_over_acc_count' in zaccf.keys( ) else 0 # pprint(temp_detail) mongodb.update(MONGO_COLLECTION=collection, WHERE={ 'group_code': product['group_code'], 'int_rate': zaccf['_id'], 'year': year }, VALUE=temp_detail) temp_total['total_w_org_' + str(report_month) + '_' + str(report_year)] += temp_detail[ 'total_w_org_' + str(report_month) + '_' + str(report_year)] temp_total['total_acc_count_' + str(report_month) + '_' + str(report_year)] += temp_detail[ 'total_acc_count_' + str(report_month) + '_' + str(report_year)] temp_total['group_2_w_org_' + str(report_month) + '_' + str(report_year)] += temp_detail[ 'group_2_w_org_' + str(report_month) + '_' + str(report_year)]
result = True complete += 1 if (len(errorData) > 0): mongodbresult.remove_document( MONGO_COLLECTION=common.getSubUser(subUserType, ( 'Lawsuit_' + str(year) + str(month) + str(day)))) mongodbresult.batch_insert( common.getSubUser( subUserType, ('Lawsuit_' + str(year) + str(month) + str(day))), errorData) mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': importLogId}, VALUE={ 'status': 0, 'complete_import': time.time(), 'total': total, 'complete': complete }) else: if len(insertData) > 0: mongodb.batch_insert(MONGO_COLLECTION=collection, insert_data=insertData) pprint("TEST") mongodb.update(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': importLogId}, VALUE={ 'status': 1, 'complete_import': time.time(),
'tar_acc'] - temp_old['col'] temp_old['ratio_acc'] = 1 - ( temp_old['paid_acc'] / temp_old['tar_acc'] if temp_old['tar_acc'] != 0 else 0) temp_old['paid_amt'] = temp_old[ 'tar_amt'] - temp_old['total_amt'] temp_old['ratio_amt'] = 1 - ( temp_old['paid_amt'] / temp_old['tar_amt'] if temp_old['tar_amt'] != 0 else 0) oldReport['col_end_day'] = oldReport[ 'col'] - temp_old['col'] oldReport['amt_end_day'] = oldReport[ 'total_amt'] - temp_old['total_amt'] mongodb.update( MONGO_COLLECTION=collection, WHERE={'_id': ObjectId(oldReport['_id'])}, VALUE=oldReport) oldReportData = mongodb.get( MONGO_COLLECTION=collection, WHERE={ 'team_id': str(groupCell['_id']), 'due_date_code': debtGroupCell[1:3], 'month': str(oldMonth) }) if oldReportData != None: for oldReportDt in oldReportData: temp_old['pay_amt'] += oldReportDt[ 'pay_amt'] temp_old['createdAt'] = time.time()