def post(self):
asid = tornado.escape.native_str(self.get_secure_cookie("sid"))
autor = tornado.escape.native_str(self.get_secure_cookie('user'))
orgid = str(self.get_cookie('companyId'))
attr = self.get_argument('attr')
if attr=='list':
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
q_sql = "select report.report_list('"+ asid +"','"+ orgid +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
else:
param = ((self.request.body).decode('UTF8'))
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
q_sql = "select report."+attr+"('"+ asid +"','"+ orgid +"','"+param+"')"
total=''
cur.execute(q_sql)
for row in cur:
res=(row[0])
total=total+str(res)
self.write(total)
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid,encoded,'Выполение отчёта '+attr)
def post(self):
asid = tornado.escape.native_str(self.get_secure_cookie("sid"))
autor = tornado.escape.native_str(self.get_secure_cookie('user'))
attr = self.get_argument('attr')
fname = self.get_argument('fname')
if attr == 'del':
os.remove('/opt/IORDan/upload/' + fname)
self.write('success')
elif attr == 'runformat':
org_id = self.get_argument('org_id')
fname_short = fname
fname = "/opt/IORDan/upload/" + fname
conn = db_conn.db_connect('web_receivables')
loadxls.LoadFile(fname, conn, asid, fname_short)
cur = conn.cursor()
q_sql = "select loader.addfileparam('" + fname_short + "','orgid','" + org_id + "')"
cur.execute(q_sql)
conn.commit()
zipname = str(time.time())
z = zipfile.ZipFile("/opt/IORDan/archive/" + zipname + '.zip', 'w',
zipfile.ZIP_DEFLATED)
z.write(fname)
z.close()
os.remove(fname)
self.write('success')
def add_log(asid, query, note):
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
cur.callproc('log.add_log_rec', [asid, query, note])
conn.commit()
cur.close()
conn.close()
def fnk_lst(asid, orgid, fnk_name, adate, operation):
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
res = ''
if fnk_name == 'usr_list':
q_sql = "select admin.usr_list('" + asid + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif fnk_name == 'news_list':
q_sql = "select admin.news_list('" + asid + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif fnk_name == 'news':
q_sql = "select admin.adddel_news('" + asid + "','" + adate + "','" + operation + "')"
print(q_sql)
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Добавление/удаление новости')
conn.commit()
cur.close()
conn.close()
return res
def chck_ss(asid):
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
cur.callproc('access.check_sid', [asid])
conn.commit()
for row in cur:
res = (row[0])
return res
cur.close()
conn.close()
def post(self):
asid = tornado.escape.native_str(self.get_secure_cookie("sid"))
autor = tornado.escape.native_str(self.get_secure_cookie("user"))
file1 = self.request.files['file'][0]
original_fname = file1['filename']
try:
accid = self.get_argument('accid')
accid_path = accid.split('@')[0]
except:
accid = ''
try:
vtype = self.get_argument('type')
except:
vtype = ''
#fexist = os.path.exists("www/upload/" + autor + "/" + original_fname)
fexist = os.path.exists("/opt/IORDan/upload/" + original_fname)
if accid=='':
if fexist==True:
for cnt in range (1,1000):
final_filename = "Копия_"+str(cnt)+"-"+original_fname
#fexist = os.path.exists("upload/" + autor + "/" + final_filename)
fexist = os.path.exists("/opt/IORDan/upload/" + final_filename)
if fexist==True:
cnt =+1
else:
break
else:
final_filename = original_fname
#output_file = open("upload/" + autor + "/" + final_filename, 'wb')
output_file = open("/opt/IORDan/upload/" + final_filename, 'wb')
output_file.write(file1['body'])
output_file.close()
self.write('success')
else:
fid=''
res=''
dexist = os.path.exists("/opt/IORDan/privat_file/" + accid_path)
if dexist!=True:
os.mkdir("/opt/IORDan/privat_file/" + accid_path)
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
cur.callproc('loader.add_privat_file',[asid,original_fname,accid,vtype])
for row in cur:
fid=(row[0])
res=(row[1])
output_file = open("/opt/IORDan/privat_file/"+accid_path+'/'+ fid, 'wb')
output_file.write(file1['body'])
output_file.close()
f_ext = os.path.splitext(original_fname)[1]
if f_ext.lower() == '.xml' and vtype=='rosreester':
loadxml.read_file("/opt/IORDan/privat_file/"+accid_path+'/'+ fid,accid_path)
conn.commit()
cur.close()
conn.close()
self.write(res)
def read_file(fname, vaccid):
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
f = open(fname, 'r')
ifile = ''
try:
for line in f:
ifile = ifile + line
if len(ifile) > 10:
cur.callproc('loader.xml_upload', [ifile, fname, vaccid])
conn.commit()
cur.close()
conn.close()
except:
print('bad')
def post(self):
asid = tornado.escape.native_str(self.get_secure_cookie('sid'))
doc_id = self.get_argument('doc_id')
doc_summ = self.get_argument('doc_summ')
num = self.get_argument('num')
page_json = ((self.request.body).decode('UTF-8'))
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
q_sql = "select main.load_bank_doc('"+asid +"','"+ doc_id +"','"+ num +"','"+ page_json +"','"+ doc_summ +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
conn.commit()
cur.close()
conn.close()
def post(self):
asid = tornado.escape.native_str(self.get_secure_cookie("sid"))
orgid = str(self.get_cookie('companyId'))
adate = str(((self.request.body).decode('UTF8')))
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
q_sql = 'report.proxy_srv' + str([asid,orgid,adate])
cur.callproc('report.proxy_srv',[asid,orgid,adate])
for row in cur:
res=(row[0])
self.write(res)
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid,encoded,'Выполнение пакетного документа')
conn.commit()
cur.close()
conn.close()
def get(self):
if not self.current_user:
self.redirect("/login")
return
asid = tornado.escape.native_str(self.get_secure_cookie('sid'))
pid = self.get_argument('pid')
orgid = self.get_argument('orgid')
tname = self.get_argument('templ_name')
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
q_sql = "select loader.bank_template"+tname +"('"+asid +"','"+ pid +"','"+ orgid +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
cur.close()
conn.close()
def get(self):
if not self.current_user:
self.redirect("/")
return
asid = tornado.escape.native_str(self.get_secure_cookie("sid"))
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
q_sql = "select access.user_rights('"+asid +"')"
cur.execute(q_sql)
for row in cur:
res=json.loads(row[0])
try:
utupe = res["u_type"]
except:
utupe = ''
if utupe=='admin':
self.render("frontend/html/admin_page.html")
else:
self.write('Нет прав доступа')
def get(self):
if not self.current_user:
self.redirect("/login")
return
asid = tornado.escape.native_str(self.get_secure_cookie('sid'))
val_param = self.get_argument('query')
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
if val_param=='user_rights':
q_sql = "select access.user_rights('"+asid +"')"
else:
q_sql = "select main.webrqst('"+asid +"','"+ val_param +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
conn.commit()
cur.close()
conn.close()
def read_file (fname):
print(fname)
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
f = open(fname, 'r')
#data = pd.read_csv(fname, sep="\t", header=None)
print('run')
#print(data)
ifile=''
try:
for line in f:
ifile=ifile+line
#q_sql = "select main.add_str3('"+ line +"','"+ fname +"')"
#cur.execute(q_sql)
if len(ifile)>10:
q_sql = "select main.add_str3('"+ ifile +"','"+ fname +"')"
cur.execute(q_sql)
conn.commit()
cur.close()
conn.close()
except:
print('bad')
def login(uname, pwd, ip_adr):
passwd = hashlib.md5(pwd.encode('utf-8')).hexdigest()
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
note = '{"ip": "' + ip_adr + '"}'
cur.callproc('access.login', [uname, passwd, note])
for row in cur:
res = (row[0])
print(res)
if res != 'no_usr_or_pwd':
conn.commit()
cur.close()
conn.close()
dexist = os.path.exists("/opt/IORDan/personal/" + uname)
if dexist == True:
return res
else:
os.mkdir("/opt/IORDan/personal/" + uname)
return res
else:
cur.close()
conn.close()
return res
def get(self):
if not self.current_user:
self.redirect("/")
return
asid = tornado.escape.native_str(self.get_secure_cookie("sid"))
orgid = str(self.get_cookie('companyId'))
hdate = str(self.get_cookie('history_table_date'))
accid = self.get_argument('accid')
humanid = self.get_argument('humanid')
rtype = self.get_argument('rtype')
rnum = self.get_argument('rnum')
try:
multi = self.get_argument('multi')
except:
multi = ''
try:
fio = self.get_argument('fio')
except:
fio = ''
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
if rtype == 'certificate' and multi=='' and rnum=='16':
q_sql = "select report.sprav"+ rnum +"('"+ asid +"','"+ accid +"','"+ humanid +"','0','"+ hdate +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid,encoded,'Выполнение справки')
elif rtype == 'certificate' and multi=='':
q_sql = "select report.sprav"+ rnum +"('"+ asid +"','"+ accid +"','"+ humanid +"','"+ fio +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid,encoded,'Выполнение отчёта')
elif rtype == 'report' and multi=='':
dateb = self.get_argument('dateb')
datee = self.get_argument('datee')
q_sql = "select report.rep"+ rnum +"('"+ asid +"','"+ accid +"','"+ humanid +"','"+ dateb +"','"+ datee +"','"+ fio +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid,encoded,'Выполнение отчёта')
elif multi=='true':
createRegistry = self.get_argument('createRegistry')
q_sql = "select report.rep_multi('"+ asid +"','"+ accid +"','"+ rtype +"','"+ rnum +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
if createRegistry== 'true':
q_sql = "select main.ree_registry_create('"+ asid +"','"+ orgid +"','"+ res +"','"+ accid +"')"
cur.execute(q_sql)
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid,encoded,'Выполнение массового отчёта/справки')
elif multi!='true' and multi!='':
dateb = self.get_argument('dateb')
datee = self.get_argument('datee')
q_sql = "select report.rep_fast_access('"+ asid +"','"+ accid +"','"+ rtype +"','"+ dateb +"','"+ datee +"','"+ multi +"')"
cur.execute(q_sql)
for row in cur:
res=(row[0])
self.write(res)
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid,encoded,'Выполнение групового отчёта/справки')
conn.commit()
cur.close()
conn.close()
def fnk_lst(asid, orgid, fnk_name, adate, val_param, val_param1, val_param2,
val_param3, val_param4, val_param5, val_param6, val_param7,
val_param8, val_param9, val_param10):
conn = db_conn.db_connect('web_receivables')
cur = conn.cursor()
res = ''
if fnk_name == 'chg_history_setting':
q_sql = 'main.chg_history_setting' + str([asid, orgid, adate])
cur.callproc('main.chg_history_setting', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Изменение настроект')
if fnk_name == 'objects_tree_filters':
q_sql = 'main.house_tree' + str([asid, orgid, adate])
cur.callproc('main.house_tree', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Применение фильтра объектов')
elif fnk_name == 'account_history':
q_sql = 'main.account_history' + str([asid, orgid, adate])
cur.callproc('main.account_history', [asid, orgid, adate])
for row in cur:
res = (row[0])
elif fnk_name == 'adr_info':
q_sql = 'main.adr_info' + str([asid, orgid, adate])
cur.callproc('main.adr_info', [asid, orgid, adate])
for row in cur:
res = (row[0])
elif val_param == 'addchg_human':
q_sql = 'main.addchg_human' + str([asid, orgid, adate])
print(q_sql)
cur.callproc('main.addchg_human', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Добавление/удаление human')
elif val_param == 'addchg_kvdocs':
q_sql = "select main.addchg_kvdocs('" + asid + "','" + val_param1 + "','" + val_param2 + "','" + val_param3 + "','" + val_param4 + "','" + val_param5 + "','" + val_param6 + "','" + val_param7 + "','" + val_param8 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded,
'Добавление/удаление документа на квартиру')
elif val_param == 'chg_place_val':
q_sql = "select main.chg_adate_place('" + asid + "','" + val_param1 + "','" + val_param2 + "','" + val_param3 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Изменение атрибутов квартиры')
elif val_param == 'addchg_contact':
q_sql = "select main.addchg_contact('" + asid + "','" + val_param1 + "','" + val_param2 + "','" + val_param3 + "','" + val_param4 + "','" + val_param5 + "','" + val_param6 + "','" + val_param7 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded,
'Добавление/удаление контактных данных')
elif fnk_name == 'reports_setting':
q_sql = 'report.sprav_note_chg' + str([asid, orgid, adate])
cur.callproc('report.sprav_note_chg', [asid, orgid, adate])
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded,
'Редактирование примечания по справкам')
elif val_param == 'fast_find':
q_sql = "select main.fast_find('" + asid + "','" + val_param1 + "','" + val_param2 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif val_param == 'news_portal':
q_sql = "select main.news_portal('" + asid + "','" + val_param1 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif val_param == 'addchg_accnote':
q_sql = "select main.addchg_accnote('" + asid + "','" + val_param1 + "','" + val_param2 + "','" + val_param3 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Примечание по адресу')
elif val_param == 'loader_file_list':
q_sql = 'loader.filelist' + str([asid, orgid])
cur.callproc('loader.filelist', [asid, orgid])
for row in cur:
res = (row[0])
elif val_param == 'delfilepart':
q_sql = "select loader.delfilepart('" + asid + "','" + val_param1 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Удалить лист платёжного документа')
elif val_param == 'document_list':
q_sql = 'main.document_list' + str([asid, orgid])
cur.callproc('main.document_list', [asid, orgid])
for row in cur:
res = (row[0])
elif val_param == 'rollback_bank':
q_sql = "select main.rollback_bank_doc('" + asid + "','" + val_param1 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded,
'Удалить проведённый платёжный документ')
elif val_param == 'document_rec':
q_sql = "select main.document_rec('" + asid + "','" + val_param1 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif val_param == 'registries_list':
q_sql = 'main.registries_list' + str([asid, orgid])
cur.callproc('main.registries_list', [asid, orgid])
for row in cur:
res = (row[0])
elif val_param == 'chg_passwd':
q_sql = "select access.chg_passwd('" + asid + "','" + val_param1 + "','" + val_param2 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Смена пароля')
elif val_param == 'chg_user_attr':
q_sql = 'access.chg_user_attr' + str([asid, adate])
cur.callproc('access.chg_user_attr', [asid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Смена настроек пользователя')
elif val_param == 'ree_reestrs':
q_sql = "select main.ree_reestrs('" + asid + "','" + val_param1 + "','" + orgid + "','" + val_param2 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif fnk_name == 'get_registry':
q_sql = 'main.ree_recodrs' + str([asid, orgid, adate])
cur.callproc('main.ree_recodrs', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Открытие реестра')
elif fnk_name == 'addchg_ree_recodrs':
adate = urllib.parse.unquote(adate)
q_sql = 'main.addchg_ree_recodrs' + str([asid, orgid, adate])
tracert.tprint('addchg_ree_recodrs', q_sql)
cur.callproc('main.addchg_ree_recodrs', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded,
'Добавление редактирование строки в реестре')
elif val_param == 'house_groups':
q_sql = "select main.adddel_house_group('" + asid + "','" + orgid + "','" + val_param1 + "','" + val_param2 + "','" + val_param3 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Добавление группы домов')
elif val_param == 'house_group_list':
q_sql = 'main.house_group_list' + str([asid, orgid])
cur.callproc('main.house_group_list', [asid, orgid])
for row in cur:
res = (row[0])
elif val_param == 'add_usr_hsgrlst':
q_sql = "select main.add_usr_hsgrlst('" + asid + "','" + orgid + "','" + val_param1 + "','" + val_param2 + "','" + val_param3 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif val_param == 'house_group_usr':
q_sql = "select main.house_group_usr('" + asid + "','" + val_param1 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
elif fnk_name == 'registry_settings':
q_sql = 'main.chgthead_reereestrs' + str([asid, orgid, adate])
cur.callproc('main.chgthead_reereestrs', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Изменение заголовка реестра')
elif val_param == 'ree_reestrs_close':
q_sql = "select main.ree_reestrs_close('" + asid + "','" + val_param1 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Закрытие реестра')
elif val_param == 'chg_reputation':
q_sql = "select main.chg_reputation('" + asid + "','" + val_param1 + "','" + val_param2 + "')"
cur.execute(q_sql)
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Изменение репутации')
elif fnk_name == 'ree_regular_create':
q_sql = 'main.ree_regular_create' + str([asid, orgid, adate])
cur.callproc('main.ree_regular_create', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Создание регулярного реестра')
elif fnk_name == 'ree_print_registry_content':
q_sql = 'main.ree_print_registry_content' + str([asid, orgid, adate])
cur.callproc('main.ree_print_registry_content', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Просмотр документа массовой печати')
elif fnk_name == 'chg_history_foropl':
q_sql = 'main.chg_history_foropl' + str([asid, orgid, adate])
cur.callproc('main.chg_history_foropl', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Разбивка оплаты')
elif fnk_name == 'get_last_pay_date':
q_sql = 'main.get_last_pay_date' + str([asid, orgid, adate])
cur.callproc('main.get_last_pay_date', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Разбивка оплаты')
elif fnk_name == 'log_views':
q_sql = 'log.log_views' + str([asid, adate])
cur.callproc('log.log_views', [asid, adate])
for row in cur:
res = (row[0])
elif fnk_name == 'get_egrp_rec':
q_sql = 'main.get_egrp_rec' + str([asid, orgid, adate])
print(q_sql)
cur.callproc('main.get_egrp_rec', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Добавление собственников из ЕГРП')
elif fnk_name == 'get_fssp_rec':
q_sql = 'main.get_fssp_rec' + str([asid, orgid, adate])
print(q_sql)
cur.callproc('main.get_fssp_rec', [asid, orgid, adate])
for row in cur:
res = (row[0])
encoded = base64.b64encode(q_sql.encode()).decode()
logg_web.add_log(asid, encoded, 'Запрос истории ФССП')
conn.commit()
cur.close()
conn.close()
return res
