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