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 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/importlawsuit.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Lawsuit') try: modelColumns = [] modelConverters = {}
import os import csv import json from pprint import pprint from datetime import datetime, timedelta from datetime import date 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')
import time import sys import os import json import csv from pprint import pprint 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/importlnjc05yesterday.txt","a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'LNJC05_yesterday') modelCollection = common.getSubUser(subUserType, 'LNJC05') try: modelColumns = []
import sys import os import json 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/importLNJC05F.txt","a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'LNJC05') try: modelColumns = [] modelConverters = {} modelPosition = {} modelFormat = {} updateKey = []
import calendar import time import sys import os import json 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 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/importSiteResult.txt","a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Site_result') try: modelColumns = [] modelConverters = {}
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 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) now = datetime.now() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Appointment') log = open('/data/log_data/python/telesales/importAppointment.txt', "a") try: modelColumns = [] modelConverters = {}
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 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() ftp = Ftp() # 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: importLogId = sys.argv[1] insertData = [] resultData = [] errorData = [] countRow = 0
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=wff_env) _mongodb = Mongodb("_worldfone4xs", WFF_ENV=wff_env) excel = Excel() config = Config() base_url = config.base_url() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Telesalelist') # log = open(base_url + "cronjob/python/Telesales/importTelesales.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( subUserType, 'Import'), WHERE={'_id': ObjectId(importLogId)})
import calendar import time import sys 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/importSCschedule.txt","a") now = datetime.now() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Sibs') importLogId = sys.argv[1] sibsColumns = [] sibsConverters = {} try: importLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(subUserType, 'Import'), WHERE={'_id': ObjectId(importLogId)})
import time import sys import os import json 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 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 = {}
import sys import os import json 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/importZACCF.txt", "a") logRun = open(base_url + "cronjob/python/Loan/log/runImportZACCF.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'ZACCF') try: modelColumns = [] modelConverters = {} modelPosition = {} modelFormat = {}
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/importSibs.txt", "a") now = datetime.now() subUserType = 'TS' collection = common.getSubUser(subUserType, 'Sibs') try: modelColumns = [] modelConverters = {} modelConverters1 = [] modelPosition = {} modelPosition1 = []
import time import sys import os import json import csv 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')
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, sep=',', header=0,
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( subUserType, 'Import'), WHERE={'_id': ObjectId(importLogId)})
import sys import os import json from pprint import pprint 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 mongodb = Mongodb("worldfone4xs") _mongodb = Mongodb("_worldfone4xs") 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/importWoPayment.txt", "a") now = datetime.now() subUserType = 'LO' collection = common.getSubUser(subUserType, 'Wo_payment') try: modelColumns = [] modelConverters = {}