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