import time import sys import os import json from pprint import pprint from datetime import datetime from datetime import date, timedelta from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() mongodbaggregate = Mongodbaggregate("worldfone4xs") base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) log = open( base_url + "cronjob/python/Loan/log/saveDailyProdProdEachUserGroup.txt", "a") now = datetime.now() subUserType = 'LO'
import time import sys import os import json from pprint import pprint from datetime import datetime from datetime import date, timedelta from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() mongodbaggregate = Mongodbaggregate("worldfone4xs") base_url = config.base_url() log = open(base_url + "cronjob/python/Loan/log/saveOsBalanceGroup.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Os_balance_group_sibs') try: insertData = [] updateData = [] listDebtGroup = []
import time import ntpath import json from helper.mongod import Mongodb from datetime import datetime from datetime import date from datetime import timedelta from pprint import pprint from bson import ObjectId from helper.common import Common import pandas as pd common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) now = datetime.now() subUserType = 'LO' account_collection = common.getSubUser(subUserType, 'List_of_account_in_collection') sbv_collection = common.getSubUser(subUserType, 'SBV') collection = common.getSubUser(subUserType, 'Group_card') due_date_collection = common.getSubUser(subUserType, 'Report_due_date') log = open(base_url + "cronjob/python/Loan/log/groupCard_log.txt", "a") try: data = [] insertData = [] updateDate = []
import ntpath import json import calendar from helper.mongod import Mongodb from datetime import datetime from datetime import date from datetime import timedelta from pprint import pprint from bson import ObjectId from helper.common import Common import pandas as pd common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) now = datetime.now() subUserType = 'LO' account_collection = common.getSubUser(subUserType, 'List_of_account_in_collection') sbv_collection = common.getSubUser(subUserType, 'SBV') collection = common.getSubUser(subUserType, 'Group_card') due_date_collection = common.getSubUser(subUserType, 'Report_due_date') log = open(base_url + "cronjob/python/Loan/log/groupCard_log.txt","a") log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': Start Log' + '\n') try: data = [] insertData = [] updateDate = [] today = date.today()
from datetime import date from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common try: excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) log = open(base_url + "cronjob/python/Loan/log/importNewOverdueListDaily.txt","a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'New_overdue_list_daily') modelColumns = [] modelConverters = {} modelPosition = {} modelFormat = {} updateKey = [] checkNullKey = [] ftpInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(subUserType, 'ftp_config'), WHERE={'collection': collection})
import time import sys import os import json from pprint import pprint from datetime import datetime from datetime import date, timedelta from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() mongodbaggregate = Mongodbaggregate("worldfone4xs") base_url = config.base_url() log = open( base_url + "cronjob/python/Loan/log/saveDailyProdProdEachUserGroup.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Daily_prod_prod_each_user_group') try: insertData = []
import ntpath import json import calendar from helper.mongod import Mongodb from datetime import datetime from datetime import date, timedelta from pprint import pprint from bson import ObjectId from helper.common import Common import pandas as pd import xlsxwriter common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'List_of_all_customer_report') log = open( base_url + "cronjob/python/Loan/log/List_of_all_customer_report_log.txt", "a") try: data = [] insertData = [] resultData = [] errorData = [] today = date.today()
from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate from math import ceil excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) # log = open(base_url + "cronjob/python/Loan/log/importSBV.txt","a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'First_time_payment_delinqunecy') lnjc05_collection = 'LNJC05' zaccf_collection = 'ZACCF_report' try: today = date.today() # today = datetime.strptime('31/03/2020', "%d/%m/%Y").date() yesterday = today - timedelta(days=1) day = today.day month = today.month year = today.year
import os from pprint import pprint from datetime import datetime from datetime import date from bson import ObjectId from dateutil import parser import pandas as pd import csv from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common try: mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = config.base_url() now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'SBV') url = '/var/www/html/worldfone4xs_ibm/cronjob/python/Loan/ZACCF_header.xlsx' filename = 'ZACCF_header.xlsx' filenameExtension = filename.split('.') if (filenameExtension[1] == 'csv'): inputDataRaw = excel.getDataCSV(file_path=url,
import time import sys import os import json import csv from pprint import pprint from datetime import datetime from datetime import date from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = config.base_url() log = open(base_url + "cronjob/python/Loan/log/importlnjc05.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'LNJC05') try: modelColumns = [] modelConverters = {} modelConverters1 = []
import json from pprint import pprint from datetime import datetime from datetime import date, timedelta from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) subUserType = 'LO' collection = common.getSubUser(subUserType, 'Daily_prod_each_group') lnjc05_collection = common.getSubUser(subUserType, 'LNJC05') ln3206_collection = common.getSubUser(subUserType, 'LN3206F') product_collection = common.getSubUser(subUserType, 'Product') sbv_collection = common.getSubUser(subUserType, 'SBV') store_collection = common.getSubUser(subUserType, 'SBV_Stored') account_collection = common.getSubUser(subUserType, 'List_of_account_in_collection') payment_of_card_collection = common.getSubUser(subUserType, 'Report_input_payment_of_card') jsondata_collection = common.getSubUser(subUserType, 'Jsondata') report_due_date_collection = common.getSubUser(subUserType, 'Report_due_date') due_date_next_date_collection = common.getSubUser(subUserType, 'Due_date_next_date')
from helper.mongod import Mongodb from datetime import datetime, timedelta from datetime import date from pprint import pprint from bson import ObjectId from helper.common import Common from xlsxwriter.utility import xl_rowcol_to_cell import pandas as pd from helper.jaccs import Config import xlsxwriter import traceback common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) log = open(base_url + "cronjob/python/Loan/log/saveTendencyDelinquent.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'First_time_payment_delinqunecy') collection_column = common.getSubUser( subUserType, 'First_time_payment_delinqunecy_columns') try: today = date.today() # today = datetime.strptime('18/01/2020', "%d/%m/%Y").date() yesterday = today - timedelta(days=1) day = today.day month = today.month
from datetime import date # from xlsxwriter.utility import xl_rowcol_to_cell from pprint import pprint from bson import ObjectId from helper.common import Common from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from dateutil.parser import parse import os.path from os import path common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb("worldfone4xs", wff_env) _mongodb = Mongodb("_worldfone4xs", wff_env) excel = Excel() config = Config() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Datalibrary') now = datetime.now() # log = open(base_url + "cronjob/python/Telesales/importDataLibrary.txt","a") now = datetime.now() # log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': Start Import' + '\n') try: try: sys.argv[1] importLogId = str(sys.argv[1]) importLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(
from datetime import datetime, timedelta from datetime import date from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) log = open( base_url + "cronjob/python/Loan/log/importListOfCusAssignedToPartner.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Cus_assigned_partner') try: modelColumns = [] modelConverters = {} modelConverters1 = [] modelPosition = {} modelPosition1 = [] modelFormat = {}
from bson import ObjectId from dateutil import parser from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common try: excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) log = open( base_url + "cronjob/python/Loan/log/importListOfAccountInCollection.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'List_of_account_in_collection') modelColumns = [] modelConverters = {} modelConverters1 = [] modelPosition = {} modelPosition1 = [] modelFormat = {}
import calendar import traceback from helper.mongod import Mongodb from datetime import datetime from datetime import date from pprint import pprint from bson import ObjectId from helper.common import Common from helper.jaccs import Config import pandas as pd import xlsxwriter common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Master_data_report') lnjc05_collection = common.getSubUser(subUserType, 'LNJC05') account_collection = common.getSubUser(subUserType, 'List_of_account_in_collection') zaccf_collection = common.getSubUser(subUserType, 'ZACCF_report') customer_collection = common.getSubUser(subUserType, 'Cus_assigned_partner') product_collection = common.getSubUser(subUserType, 'Product') release_sale_collection = common.getSubUser(subUserType, 'Report_release_sale') investigation_collection = common.getSubUser(subUserType, 'Investigation_file') sbv_collection = common.getSubUser(subUserType, 'SBV') trialBalance_collection = common.getSubUser(subUserType, 'Trial_balance_report')
import json from pprint import pprint from datetime import datetime from datetime import date, timedelta from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) excel = Excel() config = Config() ftp = Ftp() mongodbaggregate = Mongodbaggregate("worldfone4xs") log = open( base_url + "cronjob/python/Loan/log/saveDailyProdProdEachUserGroup.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Daily_prod_prod_each_user_group') try: insertData = [] updateData = [] listDebtGroup = []
import sys import time import os from datetime import datetime from datetime import date from xlsxwriter.utility import xl_rowcol_to_cell from pprint import pprint from bson import ObjectId from time import mktime as mktime from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = config.base_url() log = open(base_url + "cronjob/python/Telesales/importSCschedule.txt", "a") now = datetime.now() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Sc_schedule') try: modelColumns = [] modelConverters = {} modelConverters1 = []
from datetime import date from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.mongod import Mongo_common from helper.excel import Excel from helper.jaccs import Config from helper.common import Common excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) mongo_common = Mongo_common() log = open(base_url + "cronjob/python/Telesales/log/exportCallinglist.txt", "a") now = datetime.now() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Telesalelist') # try: # pprint("test") # # updateLastCallCallinglist() # listApp = list(mongodb.get(MONGO_COLLECTION=common.getSubUser(subUserType, 'Appointment'))) # for appointment in listApp: # if 'cmnd' in appointment.keys(): # # Update thong tin app_status vao calling list
from pprint import pprint from datetime import datetime from datetime import date from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common try: excel = Excel() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) file_path = '/mnt/nas/upload_file/20191226/CARD_A02_26122019.xlsx' subUserType = 'LO' collection = common.getSubUser(subUserType, 'Note') inputDataRaw = excel.getDataExcel(file_path=file_path, active_sheet="Sheet1", header=None, na_values='') inputData = inputDataRaw.to_dict('records') skip = 0 insertData = [] for idx, row in enumerate(inputData): if skip == 0:
import calendar import traceback from helper.mongod import Mongodb from datetime import datetime from datetime import date, timedelta from pprint import pprint from bson import ObjectId from helper.common import Common from helper.jaccs import Config import pandas as pd import xlsxwriter common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Daily_payment_report') lnjc05_collection = common.getSubUser(subUserType, 'LNJC05_yesterday') ln3206_collection = common.getSubUser(subUserType, 'LN3206F') zaccf_collection = common.getSubUser(subUserType, 'ZACCF_yesterday') product_collection = common.getSubUser(subUserType, 'Product') sbv_collection = common.getSubUser(subUserType, 'SBV_yesterday') store_collection = common.getSubUser(subUserType, 'SBV_Stored') account_collection = common.getSubUser( subUserType, 'List_of_account_in_collection_yesterday') payment_of_card_collection = common.getSubUser(subUserType, 'Report_input_payment_of_card') diallist_collection = common.getSubUser(subUserType, 'Diallist_detail')
# help round down def round_down(n, decimals=0): multiplier = 10**decimals return math.floor(n * multiplier) / multiplier # Python code to merge dict using update() method def Merge(dict1, dict2): return (dict2.update(dict1)) #help common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) now = datetime.now() subUserType = 'LO' temp_collection = common.getSubUser(subUserType, 'List_of_all_customer_total_report_temp') collection1 = common.getSubUser(subUserType, 'List_of_all_customer_total_report') zaccf_collection = common.getSubUser(subUserType, 'ZACCF') sbv_collection = common.getSubUser(subUserType, 'SBV') product_collection = common.getSubUser(subUserType, 'Product') user_collection = common.getSubUser(subUserType, 'User')
import traceback from pprint import pprint from datetime import datetime from datetime import date, timedelta from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) excel = Excel() config = Config() ftp = Ftp() log = open(base_url + "cronjob/python/Loan/log/calDueDateValue.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Due_date_next_date_by_group') zaccf_collection = common.getSubUser(subUserType, 'ZACCF_report') sbv_collection = common.getSubUser(subUserType, 'SBV') diallist_collection = common.getSubUser(subUserType, 'Diallist_detail') group_collection = common.getSubUser(subUserType, 'Group') report_due_date_collection = common.getSubUser(subUserType, 'Report_due_date') jsonData_collection = common.getSubUser(subUserType, 'Jsondata') product_collection = common.getSubUser(subUserType, 'Product')
import os import time import ntpath import json from helper.mongod import Mongodb from datetime import datetime from datetime import date from pprint import pprint from bson import ObjectId from helper.common import Common from helper.jaccs import Config common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Reminder_letter_report') lnjc05_collection = common.getSubUser(subUserType, 'LNJC05') ln3206_collection = common.getSubUser(subUserType, 'LN3206F') zaccf_collection = common.getSubUser(subUserType, 'ZACCF') product_collection = common.getSubUser(subUserType, 'Product') sbv_collection = common.getSubUser(subUserType, 'SBV') group_collection = common.getSubUser(subUserType, 'Group_card') account_collection = common.getSubUser(subUserType, 'List_of_account_in_collection') payment_of_card_collection = common.getSubUser(subUserType, 'Report_input_payment_of_card')
from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common try: excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) log = open(base_url + "cronjob/python/Loan/log/importtemporarypayment.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Temporary_payment') modelColumns = [] modelConverters = {} modelConverters1 = [] modelPosition = {} modelPosition1 = [] modelFormat = {} modelFormat1 = [] converters = {} insertData = []
from datetime import datetime, timedelta from datetime import date from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = common.base_url() wff_env = common.wff_env(base_url) mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env) _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env) log = open(base_url + "cronjob/python/Loan/log/importWoMonth.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'WO_monthly') try: modelColumns = [] modelConverters = {} modelConverters1 = [] modelPosition = {} modelPosition1 = [] modelFormat = {} modelFormat1 = [] converters = {}
import time import sys import os import json import csv from pprint import pprint from datetime import datetime from datetime import date from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() base_url = config.base_url() log = open(base_url + "cronjob/python/Telesales/log/importDealer.txt", "a") now = datetime.now() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Dealer') try: modelColumns = [] modelConverters = {} modelConverters1 = []
import time import sys import os import json from pprint import pprint from datetime import datetime from datetime import date, timedelta from bson import ObjectId from helper.ftp import Ftp from helper.mongod import Mongodb from helper.excel import Excel from helper.jaccs import Config from helper.common import Common from helper.mongodbaggregate import Mongodbaggregate mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") excel = Excel() config = Config() ftp = Ftp() common = Common() mongodbaggregate = Mongodbaggregate("worldfone4xs") base_url = config.base_url() log = open(base_url + "cronjob/python/Loan/log/saveDailyProdWorkingDays.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Daily_prod_working_days_report') try: insertData = [] updateData = []