Python Mongodb示例

示例#1

文件： saveDPWorkingDay.py 项目： 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

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'

示例#2

文件： saveOsBalanceGroupCard.py 项目： 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

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

示例#3

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

示例#4

文件： updateGroupCard.py 项目： heodat234/worldfone4xs_ibm

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

示例#5

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

示例#6

文件： saveDailyProdProdEachUserGroup.py 项目： 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

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

示例#7

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

示例#8

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

示例#9

文件： importHeaderTemplate.py 项目： heodat234/worldfone4xs_ibm

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,

示例#10

文件： LNJC05_Prod.py 项目： heodat234/worldfone4xs_ibm

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

示例#11

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

示例#12

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

示例#13

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(

示例#14

文件： importListOfCusAssignedToPartner.py 项目： heodat234/worldfone4xs_ibm

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 = {}

示例#15

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 = {}

示例#16

文件： saveMasterData.py 项目： heodat234/worldfone4xs_ibm

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

示例#17

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

示例#18

文件： importSCSchedule_cron.py 项目： heodat234/worldfone4xs_ibm

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

示例#19

文件： update_app_status_callinglist.py 项目： heodat234/worldfone4xs_ibm

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

示例#20

文件： importNote.py 项目： heodat234/worldfone4xs_ibm

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:

示例#21

文件： saveDailyPayment.py 项目： heodat234/worldfone4xs_ibm

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

示例#22

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

示例#23

文件： calDueDateValueByGroup.py 项目： heodat234/worldfone4xs_ibm

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

示例#24

文件： saveReminderLetter.py 项目： heodat234/worldfone4xs_ibm

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

示例#25

文件： importTemporaryPayment.py 项目： heodat234/worldfone4xs_ibm

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

示例#26

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 = {}

示例#27

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

示例#28

文件： saveDailyProdWorkingDays.py 项目： 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

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