Esempi in Python per Common

Esempio n. 1

File: williamhill_spider.py Progetto: didoogan/sporttech_test

 def parse(self, response):
     raw_countries = response.xpath('//div[@class="eventselection"]/text()')
     countries = [self.process_raw_country(rc) for rc in raw_countries]
     raw_bets = response.xpath('//div[@class="eventprice"]/text()')
     bets = [self.process_raw_bet(rb) for rb in raw_bets]
     result = dict(zip(countries, bets))
     Common.write_result(self.name, result)

Esempio n. 2

File: info_visualizer.py Progetto: didoogan/sporttech_test

 def show_common_matrix(self):
     process = CrawlerProcess()
     process.crawl(PaddypowerSpider)
     process.crawl(SkybetSpider)
     process.crawl(WilliamhillSpider)
     process.start()
     result = Common.read_result()
     print(tabulate(result['result'], result['headers'], tablefmt="grid"))

Esempio n. 3

import sys
import os
import time
import ntpath
import json
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

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, 'Block_card_report')
lnjc05_collection = common.getSubUser(subUserType, 'LNJC05')
ln3206_collection = common.getSubUser(subUserType, 'LN3206F')
zaccf_collection = common.getSubUser(subUserType, 'ZACCF_report')
product_collection = common.getSubUser(subUserType, 'Product')
sbv_collection = common.getSubUser(subUserType, 'SBV')
group_collection = common.getSubUser(subUserType, 'Group_card')
account_collection = common.getSubUser(subUserType,

Esempio n. 4

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')

    modelColumns = []
    modelConverters = {}
    modelConverters1 = []

Esempio n. 5

File: saveDailyProdEachUserGroup.py Progetto: heodat234/worldfone4xs_ibm

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

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_user_group')
lnjc05_collection = common.getSubUser(subUserType, 'LNJC05')
ln3206f_collection = common.getSubUser(subUserType, 'LN3206F')
account_collection = common.getSubUser(subUserType,
                                       'List_of_account_in_collection')
gl_collection = common.getSubUser(subUserType, 'Report_input_payment_of_card')
jsonData_collection = common.getSubUser(subUserType, 'Jsondata')
group_collection = common.getSubUser(subUserType, 'Group')
target_collection = common.getSubUser(subUserType, 'Target_of_report')

Esempio n. 6

from datetime import datetime
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

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/importListOfAccountInCollection.txt","a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'List_of_account_in_collection')

try:
    modelColumns = []
    modelConverters = {}
    modelFormat = {}
    insertData = []
    updateData = []

    ftpInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(subUserType, 'ftp_config'), WHERE={'collection': collection})
    ftpConfig = config.ftp_config()

Esempio n. 7

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

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/importListOfCusAssignedToPartner.txt", "a")
    now = datetime.now()
    subUserType = 'LO'
    collection = common.getSubUser(subUserType, 'Cus_assigned_partner')

    modelColumns = []
    modelConverters = {}
    modelConverters1 = []
    modelPosition = {}

Esempio n. 8

File: saveDailyProdProdEachUserGroup.py Progetto: heodat234/worldfone4xs_ibm

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 = []
    updateData = []
    listDebtGroup = []

    # today = date.today()
    today = datetime.strptime('12/10/2019', "%d/%m/%Y").date()

Esempio n. 9

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

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)
config = Config()
ftp = Ftp()
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_each_user_group')
try:
    insertData = []
    updateData = []

Esempio n. 10

File: saveTendencyDelinquent.py Progetto: heodat234/worldfone4xs_ibm

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
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, 'Tendency_delinquent')
lnjc05_today = 'LNJC05'
list_of_acc_today = 'List_of_account_in_collection'
lnjc05_yesterday = 'LNJC05_yesterday'
list_of_acc_yesterday = 'List_of_account_in_collection_yesterday'
zaccf_col = 'ZACCF_report'
sbv_col = 'SBV'
diallist_detail = 'Diallist_detail'

Esempio n. 11

File: importSCSchedule.py Progetto: heodat234/worldfone4xs_ibm

import os
import time
import traceback
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

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]

Esempio n. 12

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 = {}
    modelConverters1 = []
    modelPosition = {}
    modelPosition1 = []

Esempio n. 13

File: exportReminderLetter.py Progetto: heodat234/worldfone4xs_ibm

import ntpath
import json
import calendar
import urllib
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
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)

now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Reminder_letter_report')
log = open(
    base_url + "cronjob/python/Loan/log/exportReminder_letter_report_log.txt",
    "a")
log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': Start Import' + '\n')

# fileOutput = "C:\\Users\\DELL\\Desktop\\temp-excel.xlsx"
try:

Esempio n. 14

File: saveOsBalanceGroupMain.py Progetto: heodat234/worldfone4xs_ibm

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 = []
    lnjc05ByGroup = {}

    # today = date.today()
    today = datetime.strptime('22/10/2019', "%d/%m/%Y").date()

Esempio n. 15

File: saveSmsDaily.py Progetto: heodat234/worldfone4xs_ibm

# -*- coding: utf-8 -*-
import sys
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, 'Sms_daily_report')
lnjc05_collection = common.getSubUser(subUserType, 'LNJC05')
group_collection = common.getSubUser(subUserType, 'Group_card')
account_collection = common.getSubUser(subUserType,
                                       'List_of_account_in_collection')

log = open(base_url + "cronjob/python/Loan/log/SMSDaily_log.txt", "a")

try:

Esempio n. 16

File: importLNJC05FStartMonth.py Progetto: heodat234/worldfone4xs_ibm

import json
import csv
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

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/importlnjc05_start_month.txt",
           "a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'LNJC05_start_of_month')

try:
    modelColumns = []
    modelConverters = {}
    modelConverters1 = []
    modelPosition = {}

Esempio n. 17

File: saveCDR.py Progetto: heodat234/worldfone4xs_ibm

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
from pathlib import Path

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'
collection = common.getSubUser(subUserType, 'worldfonepbxmanager')

try:
    today = date.today()
    tomorrow = today + timedelta(days=1)

Esempio n. 18

# -*- coding: utf-8 -*-
import sys
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
import pandas as pd
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, 'Master_data_report')
log = open(base_url + "cronjob/python/Loan/log/exportMasterData_log.txt", "a")
fileOutput = base_url + 'upload/loan/export/MasterData.xlsx'
try:
    data = []
    insertData = []
    resultData = []
    errorData = []

Esempio n. 19

File: saveOutsoucingCollectionTrend.py Progetto: heodat234/worldfone4xs_ibm

import ntpath
import json
import calendar
import traceback
import math
from helper.mongod import Mongodb
from datetime import datetime
from datetime import date, timedelta
from dateutil.relativedelta import relativedelta
from pprint import pprint
from bson import ObjectId
from helper.common import Common
from helper.jaccs import Config
from calendar import monthrange

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)
config = Config()
common = Common()
log = open(base_url + "cronjob/python/Loan/log/saveOutsoucingCollectionTrend.txt","a")
now = datetime.now()
subUserType = 'LO'
collection                 = common.getSubUser(subUserType, 'Cus_assigned_partner')
collection_temp            = common.getSubUser(subUserType, 'Outsoucing_Collection_Trend_report_temp')
collection_lnjc05          = common.getSubUser(subUserType, 'LNJC05_start_of_month')
collection_listofAccount   = common.getSubUser(subUserType, 'List_of_account_in_collection_start_of_month')

collection_ln3206f         =  common.getSubUser(subUserType, 'LN3206F')

Esempio n. 20

import calendar
import time
import sys
import os
import json
import traceback
from pprint import pprint
from datetime import datetime
from datetime import date, timedelta
from bson import ObjectId
from helper.mongod import Mongodb
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)
log = open(base_url + "cronjob/python/Loan/log/calDueDateValue.txt", "a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Due_date_next_date')
lnjc05_collection = common.getSubUser(subUserType, 'LNJC05')
sbv_collection = common.getSubUser(subUserType, 'SBV')
store_collection = common.getSubUser(subUserType, 'SBV_Stored')
account_collection = common.getSubUser(subUserType,
                                       'List_of_account_in_collection')
report_due_date_collection = common.getSubUser(subUserType, 'Report_due_date')
jsonData_collection = common.getSubUser(subUserType, 'Jsondata')

Esempio n. 21

import sys
import os
import time
import ntpath
import json
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

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, 'Os_balance_group_report')
lnjc05_collection = common.getSubUser(subUserType, 'LNJC05')
listOfAccount_collection = common.getSubUser(subUserType,
                                             'List_of_account_in_collection')
target_collection = common.getSubUser(subUserType, 'Target_of_report')
report_due_date_collection = common.getSubUser(subUserType, 'Report_due_date')
lnjc05_yesterday_collection = common.getSubUser(subUserType,
                                                'LNJC05_yesterday')
listAcc_yesterday_collection = common.getSubUser(

Esempio n. 22

File: saveDailyProductivity.py Progetto: heodat234/worldfone4xs_ibm

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/saveDailyProductivity.txt","a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Os_balance_group')

try:
    insertData = {}

    today = date.today()
    day = today.day
    month = today.month
    year = today.year
    weekday = today.weekday()

Esempio n. 23

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 = {}
    modelConverters1 = []
    modelPosition = {}
    modelPosition1 = []

Esempio n. 24

File: saveDailyReportEachDueDateEachGroup.py Progetto: heodat234/worldfone4xs_ibm

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

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/saveDailyProdEachGroup.txt","a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Daily_prod_each_group')
try:
    insertData = []
    insertDataTotal = []

Esempio n. 25

import sys
import os
import time
import ntpath
import json
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

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_assignment_report')
# lnjc05_collection  = common.getSubUser(subUserType, 'LNJC05_yesterday')
zaccf_collection     = common.getSubUser(subUserType, 'ZACCF')
product_collection   = common.getSubUser(subUserType, 'Product')
sbv_collection       = common.getSubUser(subUserType, 'SBV')
diallist_detail_collection  = common.getSubUser(subUserType, 'Diallist_detail')
cdr_collection       = common.getSubUser(subUserType, 'worldfonepbxmanager')
jsonData_collection  = common.getSubUser(subUserType, 'Jsondata')
user_collection      = common.getSubUser(subUserType, 'User')

Esempio n. 26

import urllib
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
import pandas as pd
from helper.jaccs import Config
import xlsxwriter
import traceback

# 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/saveTendencyDelinquent.txt","a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Tendency_delinquent')

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

Esempio n. 27

File: importLNJC05Yesterday.py Progetto: heodat234/worldfone4xs_ibm

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 = []
    modelConverters = {}
    modelConverters1 = []
    modelPosition = {}

Esempio n. 28

File: threading_test.py Progetto: heodat234/worldfone4xs_ibm

import csv
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

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 = 'LO'
collection = common.getSubUser(subUserType, 'ZACCF_24032020_test')

today = datetime.strptime('24/03/2020', "%d/%m/%Y").date()
todayString = today.strftime("%d/%m/%Y")
todayTimeStamp = int(
    time.mktime(
        time.strptime(str(todayString + " 00:00:00"), "%d/%m/%Y %H:%M:%S")))

Esempio n. 29

File: importLawsuit.py Progetto: heodat234/worldfone4xs_ibm

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 = {}
    modelConverters1 = []
    modelPosition = {}
    modelPosition1 = []

Esempio n. 30

File: importLNJC05F_bak.py Progetto: heodat234/worldfone4xs_ibm

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 = []
    checkNullKey = []

    ftpConfig = config.ftp_config()