def getdata(self):
try:
logger.info("Bắt đầu getdata")
results = self.db.execquery(
'select ID,MA_DV from CRMS_TOKHAI_NOTHUE WHERE ROWNUM<5')
cols = results["col"]
datas = results["data"]
# print(datas)
listobj = [] # khởi tạo một list nợ thuế
obj = None
for row in datas:
obj = crms_tokhai_nothue()
# for key in cols.keys():
# if hasattr(obj,key):
# print("key {} : value : {}".format(key,row[cols[key]]))
# setattr(obj,key,row[cols[key]])
helper.toObject(cols, row, obj)
listobj.append(obj)
return listobj
except Exception as ex:
logger.exception("Lỗi :")
finally:
logger.info("kết thúc : getdata!")
def getdata_proc(self, id: int):
try:
logger.info("Bắt đầu getdata_proc")
result = self.db.execproc("CRMS.PKG_XHDN_V2.SP_GETDATA", pID=None)
cols = result["col"]
datas = result["data"]
listobj = [] # khởi tạo một list nợ thuế
obj = None
for row in datas:
obj = crms_tokhai_nothue()
helper.toObject(cols, row, obj)
listobj.append(obj)
return listobj
except Exception as ex:
logger.exception("Lỗi :")
finally:
logger.info("kết thúc : getdata_proc id = {}".format(id))
def get_hsvps(self):
try:
logger.info("Bắt đầu - lấy thông tin QLT_THONGTINVIPHAM")
result = self.db.execproc("CRMS.PKG_XHDN_V2.SP_GET_THONGTINVIPHAM")
cols = result["col"]
datas = result["data"]
lstHSVPs = [] # khởi tạo một list QLT_THONGTINVIPHAM
objHVP = None
for row in datas:
objHVP = QLT_THONGTINVIPHAM()
helper.toObject(cols, row, objHVP)
lstHSVPs.append(objHVP)
return lstHSVPs
except Exception as ex:
logger.exception("Lỗi :")
finally:
logger.info("kết thúc - lấy thông tin QLT_THONGTINVIPHAM")
def get_params_plxephangs(self):
try:
logger.info("Bắt đầu - lấy thông tin QLT_PARAMS_PLXEPHANG")
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_PLXEPHANG")
cols = result["col"]
datas = result["data"]
lstplxephangs = [] # khởi tạo một list QLT_PARAMS_PLXEPHANG
for row in datas:
kl = QLT_PARAMS_PLXEPHANG()
helper.toObject(cols, row, kl)
lstplxephangs.append(kl)
return lstplxephangs
except Exception as ex:
logger.exception("Lỗi :")
finally:
logger.info("kết thúc - lấy thông tin QLT_PARAMS_PLXEPHANG")
def get_hsdns(self, FromRowID: int, ToRowID: int, IsTinhLai: int):
try:
logger.info("Bắt đầu - lấy thông tin QLT_THONGTINDOANHNGHIEP")
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_THONGTINDOANHNGHIEP",
p_FromRowID=FromRowID,
p_ToRowID=ToRowID,
p_IsTinhLai=IsTinhLai)
cols = result["col"]
datas = result["data"]
lstHSDNs = [] # khởi tạo một list QLT_THONGTINDOANHNGHIEP
for row in datas:
objHSDN = QLT_THONGTINDOANHNGHIEP()
helper.toObject(cols, row, objHSDN)
lstHSDNs.append(objHSDN)
return lstHSDNs
except Exception as ex:
logger.exception("Lỗi :")
finally:
logger.info("kết thúc - lấy thông tin QLT_THONGTINDOANHNGHIEP")
def get_hsvp_params(self):
try:
logger.info("Bắt đầu - lấy thông tin các bảng params HSVP")
hsvp_params = {}
# 1. QLT_PARAMS_HSVP_HSPLTN
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_HSPLTN")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_HSPLTN
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_HSPLTN()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_HSPLTN] = lstPARAMS
# END QLT_PARAMS_HSVP_HSPLTN
# 2. QLT_PARAMS_HSVP_HSPLXNK
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_HSPLXNK")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_HSPLXNK
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_HSPLXNK()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_HSPLXNK] = lstPARAMS
# END QLT_PARAMS_HSVP_HSPLXNK
# 3. QLT_PARAMS_HSVP_PLCLT
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_PLCLT")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_PLCLT
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_PLCLT()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_PLCLT] = lstPARAMS
# END QLT_PARAMS_HSVP_PLCLT
# 4. QLT_PARAMS_HSVP_PLHSVP
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_PLHSVP")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_PLHSVP
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_PLHSVP()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_PLHSVP] = lstPARAMS
# END QLT_PARAMS_HSVP_PLHSVP
# 5. QLT_PARAMS_HSVP_PLSLVP
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_PLSLVP")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_PLSLVP
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_PLSLVP()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_PLSLVP] = lstPARAMS
# END QLT_PARAMS_HSVP_PLSLVP
# 6. QLT_PARAMS_HSVP_PLTLVP
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_PLTLVP")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_PLTLVP
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_PLTLVP()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_PLTLVP] = lstPARAMS
# END QLT_PARAMS_HSVP_PLTLVP
# 7. QLT_PARAMS_HSVP_PLVP
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_PLVP")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_PLVP
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_PLVP()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_PLVP] = lstPARAMS
# END QLT_PARAMS_HSVP_PLVP
# 8. QLT_PARAMS_HSVP_PLVPKTK
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSVP_PLVPKTK")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSVP_PLVPKTK
objParam = None
for row in datas:
objParam = QLT_PARAMS_HSVP_PLVPKTK()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_PARAMS_HSVP_PLVPKTK] = lstPARAMS
# END QLT_PARAMS_HSVP_PLVPKTK
# 9. QLT_HSVP_SOTOKHAIDUOCTHONGQUAN
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_SOTK_THONGQUAN")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_HSVP_SOTOKHAIDUOCTHONGQUAN
objParam = None
for row in datas:
objParam = QLT_HSVP_SOTOKHAIDUOCTHONGQUAN()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[
const_hsvp_params.QLT_HSVP_SOTOKHAIDUOCTHONGQUAN] = lstPARAMS
# END QLT_HSVP_SOTOKHAIDUOCTHONGQUAN
# 10. QLT_HSVP_VIPHAMTOKHAI
result = self.db.execproc("CRMS.PKG_XHDN_V2.SP_GET_VIPHAMTOKHAI")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_HSVP_VIPHAMTOKHAI
objParam = None
for row in datas:
objParam = QLT_HSVP_VIPHAMTOKHAI()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsvp_params[const_hsvp_params.QLT_HSVP_VIPHAMTOKHAI] = lstPARAMS
# END QLT_HSVP_VIPHAMTOKHAI
return hsvp_params
except Exception as ex:
logger.exception("Lỗi :")
finally:
logger.info("kết thúc - lấy thông tin các bảng params HSVP")
def get_hsdn_params(self):
try:
logger.info("Bắt đầu - lấy thông tin các bảng params HSDN")
hsdn_params = {}
#1. QLT_PARAMS_HSDN_TC_MOTA
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSDN_TC_MOTA")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSDN_TC_MOTA
#objParam = None
for row in datas:
objParam = QLT_PARAMS_HSDN_TC_MOTA()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsdn_params[const_hsdn_params.QLT_PARAMS_HSDN_TC_MOTA] = lstPARAMS
#END QLT_PARAMS_HSDN_TC_MOTA
#2. QLT_PARAMS_HSDN_DGTC
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSDN_DGTC")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSDN_DGTC
#objParam = None
for row in datas:
objParam = QLT_PARAMS_HSDN_DGTC()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsdn_params[const_hsdn_params.QLT_PARAMS_HSDN_DGTC] = lstPARAMS
# END QLT_PARAMS_HSDN_DGTC
#3. QLT_PARAMS_HSDN_PLDCC
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSDN_PLDCC")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSDN_PLDCC
#objParam = None
for row in datas:
objParam = QLT_PARAMS_HSDN_PLDCC()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsdn_params[const_hsdn_params.QLT_PARAMS_HSDN_PLDCC] = lstPARAMS
# END QLT_PARAMS_HSDN_PLDCC
# 4. QLT_PARAMS_HSDN_PTAD
result = self.db.execproc(
"CRMS.PKG_XHDN_V2.SP_GET_QLT_PARAMS_HSDN_PTAD")
cols = result["col"]
datas = result["data"]
lstPARAMS = [] # khởi tạo một list QLT_PARAMS_HSDN_PTAD
#objParam = None
for row in datas:
objParam = QLT_PARAMS_HSDN_PTAD()
helper.toObject(cols, row, objParam)
lstPARAMS.append(objParam)
hsdn_params[const_hsdn_params.QLT_PARAMS_HSDN_PTAD] = lstPARAMS
# END QLT_PARAMS_HSDN_PLDCC
# 5. lấy MIN ID, MAX ID QLT_THONGTINDOANHNGHIEP
result = self.db.execproc("CRMS.PKG_XHDN_V2.SP_GetMinMaxID")
cols = result["col"]
datas = result["data"]
hsdn_params[const_hsdn_params.QLT_MIN_MAX_ID] = (
datas[0][cols["ROW_MIN_ID"]], datas[0][cols["ROW_MAX_ID"]])
# END lấy MIN ID, MAX ID QLT_THONGTINDOANHNGHIEP
return hsdn_params
except Exception as ex:
logger.exception("Lỗi :")
finally:
logger.info("kết thúc - lấy thông tin các bảng params HSDN")