if day == 1:
mongodb.create_db(DB_NAME=logDbName)
mongodbresult = Mongodb(logDbName, WFF_ENV=wff_env)
else:
mongodbresult = Mongodb(logDbName, WFF_ENV=wff_env)
ftpLocalUrl = common.getDownloadFolderByDate(yesterday.strftime("%Y%m%d")) + fileName
try:
sys.argv[1]
importLogId = str(sys.argv[1])
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):
user_info = list(_mongodb.get(MONGO_COLLECTION=common.getSubUser(subUserType, 'User'), SELECT={'extension'}))
user = common.array_column(user_info, 'extension')
notification = {
'title' : f'Import {fileName} error',
'active' : True,
'icon' : 'fa fa-exclamation-triangle',
'color' : 'text-warning',
'content' : f'Không có file import đầu ngày <b style="font-size: 15px">{ftpLocalUrl}</b>. Xin vui lòng thông báo cho bộ phận IT',
'link' : '/manage/data/import_file',
'to' : list(user),
'notifyDate': datetime.utcnow(),
'createdBy' : 'System',
'createdAt' : time.time()
}
mongodb.insert(MONGO_COLLECTION=common.getSubUser(subUserType, 'Notification'), insert_data=notification)
sys.exit()
complete = 0
today = date.today()
fileOutput = base_url + 'upload/telesales/export/Calling_list_' + today.strftime(
"%d%m%Y") + '.xlsx'
model = list(
_mongodb.get(MONGO_COLLECTION='Model',
WHERE={
'collection':
common.getSubUser(subUserType, 'Telesalelist'),
'sub_type': {
'$ne': None
}
},
SORT=[('index', 1)]))
model_field = list(common.array_column(model, 'field'))
model_field.insert(0, 'starttime_call')
model_title = list(common.array_column(model, 'title'))
model_title.insert(0, 'Nearest Call')
try:
sys.argv[1]
exportLogId = str(sys.argv[1])
exportLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(
subUserType, 'Export'),
WHERE={'_id': ObjectId(exportLogId)})
if exportLogInfo['filter'] not in [None, [], "[]"]:
filter_value = json.loads(exportLogInfo['filter'])
report_data = list(
mongodb.get(MONGO_COLLECTION=collection,
WHERE=filter_value[0]['$match']))
else:
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': {
'$in': list_acc_info
},
'overdue_indicator': 'A',
'kydue': report_day['debt_group']
}))
temp_card_10_days['group_2_tran_no'] = len(check_with_store)
mongodb.update(MONGO_COLLECTION=collection,
WHERE={
'for_month': str(report_day['for_month']),
'for_year': str(report_day['for_year']),
total['group_2_acc_count_' + str(report_month) + '_' +
str(report_year)] = 0
total['group_2_overdue_ratio_' + str(report_month) + '_' +
str(report_year)] = 0
total['group_3_over_w_org_' + str(report_month) + '_' +
str(report_year)] = 0
total['group_3_over_acc_count_' + str(report_month) + '_' +
str(report_year)] = 0
total['group_3_over_overdue_ratio_' + str(report_month) + '_' +
str(report_year)] = 0
for product in products:
# pprint(product['code'])
if product['group_code'] not in ['300']:
list_product_code = list(
common.array_column(product['product_code'], 'code'))
temp_total = {
'group_code': product['group_code'],
'int_rate': product['group_code'] + ' Total',
'int_rate_name': product['group_name'] + ' Total',
'year': year,
}
temp_total['total_w_org_' + str(report_month) + '_' +
str(report_year)] = 0
temp_total['total_acc_count_' + str(report_month) + '_' +
str(report_year)] = 0
temp_total['group_2_w_org_' + str(report_month) + '_' +
str(report_year)] = 0
temp_total['group_2_acc_count_' + str(report_month) + '_' +
str(report_year)] = 0
temp_total['group_2_overdue_ratio_' + str(report_month) + '_' +
