def labourerReg(self,clientId,msgDict,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() nameLs = [] valueLs = [] for key,val in msgDict.items(): nameLs.append(key.lower()) valueLs.append(val) try: siteid = adminDb.fetchData("sites",["siteid"],{"sitenames":msgDict["siteOfJoining"]}) nameLs.append("siteid") valueLs.append(siteid[0]) if adminDb.pushData("labourer",nameLs,valueLs): self.log.logEvent("labourerManage",2,"labourer added successfully",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labourer added successfully","data":""},"Signature":{"signature":"","Key":""}} return response else: self.log.logEvent("labourerManage",2,"labourer can't added",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"fail","module":"labourerManage"},"Body":{"message":"labourer can't added","data":""},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerManage","exception","exception on labourerManage module",str(expc)) self.log.logEvent("labourerManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def labbourerAddlist(self,clientId,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() total = [] final = [] projectData = adminDb.fetchData("projects",["projectname","projectid"]) shiftList =[] proLs = [] try: for cnt in range(len(projectData)): sitedb = adminDb.fetchData("sites",["sitenames"],{"projectid":projectData[cnt][1]}) total.append([projectData[cnt][0],sitedb]) # total.append(sitedb) final.append(list(total)) print("projects",total) classdb = adminDb.fetchData("labourerclass",["labourerclass "]) #"compensation","Retention","Advance","Concrete_charges" final.append(classdb) print("\n\n\nclass",final) shiftdb = adminDb.fetchData("shift",["shiftid"]) final.append(shiftdb) print("\n\n\n.......total",final) self.log.logEvent("labourerManage",0,"labourer addlist listed sucessfully",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labbouerAddlist","data":final},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerManage","exception","exception on labourerManage module",str(expc)) self.log.logEvent("labourerMange",2,str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def advanceApply(self,clientId,msgDict,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() # try: if adminDb.fetchData("labourer",["labourerid"],{"siteid":msgDict["siteId"],"labourerid":msgDict["labourerId"]}): timestamp = datetime.datetime.now() if adminDb.pushData("accountinfo",["labourerid","timestamp","phonenumber","siteid","recoveryperiod","reson"],[msgDict["labourerId"],timestamp,msgDict["phoneNumber"],msgDict["siteId"],msgDict["recoveryPeriod"],msgDict["reasonForRequest"]]): sitedbData = adminDb.fetchData("sites",[ "projectid","siteid ","creditaccountid","debitaccountid"],{"siteid":msgDict["siteId"]}) print("............ls",sitedbData) adminDb.pushData("account",["timestamp","projectid","siteid ","creditaccountid","debitaccountid"],[timestamp,sitedbData[0][0],sitedbData[0][1],sitedbData[0][2],sitedbData[0][3]]) adminDb.pushData("payment",["timestamp","projectid","siteid ","creditaccountid","debitaccountid","amount","resontype"],[timestamp,sitedbData[0][0],sitedbData[0][1],sitedbData[0][2],sitedbData[0][3],msgDict["fundAuthorized"],msgDict["reasonType"]]) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labbouerAdavnce request placed sucessfully","data":""},"Signature":{"signature":"","Key":""}} return response else: self.log.logEvent("laboureradvance",2,"advanceapply canot apply",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"fail","module":"labourerManage"},"Body":{"message":"labbouerAdavnce request can't be placed","data":""},"Signature":{"signature":"","Key":""}} return response else: response = {"Header":{"status":"fail","module":"labourerManage"},"Body":{"message":"labbouer can't exist this site","data":""},"Signature":{"signature":"","Key":""}} return response
def approvecodeList(self,clientId,msgDict,sessionkey): try: masterdb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterdb.initConnection() dbpass = masterdb.fetchData("regusers",["password"],{"clientid":clientId}) password = dbpass[0][0] admindb = DatabaseAgent(clientId,clientId,conf.host,password,conf.port) admindb.initConnection() listAdvance = admindb.fetchData("accountinfo",["labourerid","reson","recoveryPeriod","approvestatus","approveid","paystatus"],{"approveid":msgDict["approveId"]}) timeStamp = admindb.fetchData("accountinfo",["timestamp"],{"approveid":msgDict["approveId"]})[0][0] print("time stamp............................",timeStamp) listpayment = admindb.fetchData("payment",["timestamp","projectid","siteid","amount"],{"timestamp":timeStamp}) print("payment......",listpayment) print("advnavce list...........",listAdvance) totalLs =[] finalLS = [] for cnt in range(len(listAdvance)): totalLs = list(listAdvance[cnt]) + list(listpayment[cnt]) finalLS.append(totalLs) response = {"Header":{"status":"success","module":"labfinace"},"Body":{"message":"labourer Advancepay list","data":finalLS},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerclassManage","exception","exception on labourerclassManage module",str(expc)) self.log.logEvent("labourerclassManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"]) print("exception is occured at",str(expc))
def roleList(self, clientId, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() self.log.logEvent("Admin", 2, "total permission list listed successfully", clientId, sessionMange.session[sessionkey]["userid"]) try: responseData = adminDb.fetchData("permission", ["rolename", "roleid"]) response = { "Header": { "status": "success", "module": "admin" }, "Body": { "message": "user role list", "data": responseData }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: self.log.logEvent("Admin", 0, "occured exception is " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def payProcess(self,clientId,msgDict,sessionkey): try: masterdb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterdb.initConnection() dbpass = masterdb.fetchData("regusers",["password"],{"clientid":clientId}) password = dbpass[0][0] admindb = DatabaseAgent(clientId,clientId,conf.host,password,conf.port) admindb.initConnection() accountDb = admindb.fetchData("accountinfo",["labourerid","timestamp"],{"approveid":msgDict["approveId"]}) print("accoutndb........................",accountDb) timeStamp = accountDb[0][1] labourerId = accountDb[0][0] print("time stamp............................",timeStamp) admindb.connection hash = hashlib.md5(str(datetime.datetime.now()) .encode()).hexdigest() transationId = hash[:10] accinfoCont = " set paystatus =' paid ' "+" where " accountcont = " set transationid = '"+str(transationId) +" ' where " payflag = " set payflag = 'True'"+", issuer = '"+sessionMange.session[sessionkey]["userid"]+"',reciverid = '"+labourerId +"',transationid = '"+str(transationId)+"' where " if admindb.updateTable(accinfoCont,"accountinfo",{"approveid":msgDict["approveId"]}): if admindb.updateTable(payflag,"payment",{"timestamp":timeStamp}): if admindb.updateTable(accountcont,"account",{"timestamp":timeStamp}): response = {"Header":{"status":"success","module":"labfinace"},"Body":{"message":"amount payed sucessfully","data":""},"Signature":{"signature":"","Key":""}} return response else: response = {"Header":{"status":"fail","module":"labfinace"},"Body":{"message":"amout can't paid","data":""},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerclassManage","exception","exception on labourerclassManage module",str(expc)) self.log.logEvent("labourerclassManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"]) print("exception is occured at",str(expc))
def editList(self, clientId, msgDict, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() totalLs = [] datalis = ["projectname,projectid"] siteinfo = [ "sitenames", "siteid", "numoflabourer", "compensationamount", "compensationdays", "concreteamount" ] self.log.logEvent("projectManage", 0, "project listed successfully", clientId, sessionMange.session[sessionkey]["userid"]) try: projectData = adminDb.fetchData( "projects", datalis, {"projectid": msgDict["projectId"]}) print("Project Names and ID : ", projectData) print("Length od Project Data : ", len(projectData)) for cnt in range(len(projectData)): print("Count: ", cnt) ls = adminDb.fetchData("sites", siteinfo, {"projectid": projectData[cnt][1]}) print("List: ", ls) totalLs.append([projectData[cnt][0], projectData[cnt][1]]) totalLs[-1].append(list(ls)) print("TotalLs: ", totalLs) response = { "Header": { "status": "success", "module": "projectManage" }, "Body": { "message": "project list", "data": totalLs }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: # self.syslog.eventHandle("projectmanagement","exception","exception on projectManage module",str(expc)) self.log.logEvent( "projectManage", 3, " all role permission listed occured " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def listRoles(self, clientId, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() permiSdata = [] try: permiSdata = adminDb.fetchData( "permission", ["rolename", "roleid", "permissions"]) # out = [item for t in permiSdata for item in t] print("database value is", permiSdata) out = [] for t in permiSdata: out.append(list(t)) # for cnt in range(2,len(out),+3): print("out", out) for cnt in range(len(out)): data = bytes(out[cnt][2]) data1 = data.decode("utf-8") data2 = str(data1).split('&&') out[cnt][2] = data2 self.log.logEvent("roleManage", 3, " all role permission listed successfully", clientId, sessionMange.session[sessionkey]["userid"]) response = { "Header": { "status": "success", "module": "roleManage" }, "Body": { "message": "uerer role list", "data": out }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: # self.syslog.eventHandle("rolemanagement","exception","exception on rolemanage module",str(expc)) self.log.logEvent( "roleManage", 3, " all role permission listed occured exception is = " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def uRolePermissionCheck(self, clientid, apiEndPoint, sessionkey): if sessionMange.session[sessionkey]["userrole"] == "Admin": return True else: masterDb = DatabaseAgent("kunnel", "kunnel", "127.0.0.1", "kunnel123", 5432) masterDb.initConnection() dblist = [] cond = {"clientid": clientid} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientid, clientid, "127.0.0.1", password, 5432) adminDb.initConnection() # condition = {"roleid":"role1001"} condition = { "rolename": sessionMange.session[sessionkey]["userrole"] } dbroleList = adminDb.fetchData("permission", ["permissions"], condition) print("dbrolelist", dbroleList) permissions = (bytes(dbroleList[0][0])).decode("utf-8").split("&&") print("datas ..", permissions) if apiEndPoint in permissions: self.log.logEvent("Communication", 2, "client permission granted") return True else: self.log.logEvent("Communication", 2, "wrong user access") return False # return True ################################################################################testing################################################ # def testing(self): # dbagent = DatabaseAgent("kunnel", "kunnel", "127.0.0.1", "kunnel123", "5432") # dbagent.initConnection() # value = dbagent.fetchData("users",["password","salt"]) # salt = value[0][1] # print("sal type........",salt) # # hashPassword = hashlib.sha512(password.encode() + salt.encode()).hexdigest() # #print("producing hash value",hashPassword) # print("databse hash value",bytes(value[0][0])) # auth = Authentication() # print("reval is....",auth.uRolePermissionCheck("kec136","/user/archieve"))
def login(self, msg, tableName, fileds, dbConfig, sessionkey): val = False try: username = msg["userName"] password = msg["password"] #username.replace(" ","") condition = {"username": username} dbagent = DatabaseAgent(dbConfig[0], dbConfig[1], "127.0.0.1", dbConfig[2], dbConfig[3]) dbagent.initConnection() value = dbagent.fetchData(tableName, fileds, condition) print("totals...", value) salt = bytes(value[0][1]) print("sal.....................", salt) hashPassword = hashlib.sha512(password.encode() + salt).hexdigest() print("databse hash value", bytes(value[0][0])) print("hashedpassword", hashPassword.encode()) sign = [] if hashPassword.encode() == bytes(value[0][0]): val = True sessionMange.session[sessionkey] = {} sessionMange.session[sessionkey]["userid"] = (value[0][2]) sessionMange.session[sessionkey]["userrole"] = (value[0][3]) sign_key = nacl.signing.SigningKey.generate() verifyKey = sign_key.verify_key sessionMange.session[sessionkey]["signkey"] = (sign_key) sessionMange.session[sessionkey]["verifykey"] = (verifyKey) else: val = False return val except Exception as excp: print("occured exceptio is ", excp)
def editLabourer(self,clientId,msgDict,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() condition = {"labourerid": msgDict["labourerId"]} changDist = {} for key in msgDict: if key == "labourerId": continue else: changDist[key.lower()] = (msgDict[key]) try: if adminDb.editData("labourer",changDist,condition): self.log.logEvent("labourerManage",2,"labourer Edited success",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labourer edited successfully","data":""},"Signature":{"signature":"","Key":""}} return response else: self.log.logEvent("labourerManage",2,"labourer labourer can't ediot",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"fail","module":"labourerManage"},"Body":{"message":"labourer canot edited","data":""},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerManage","exception","exception on labourerManage module",str(expc)) self.log.logEvent("labourerManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def addSites(self, clientId, msgDict, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() nameLs = [] valuels = [] try: for key in msgDict: nameLs.append(key.lower()) valuels.append(msgDict[key]) if adminDb.pushData("sites", nameLs, valuels): self.log.logEvent("projectManage", 2, "project added successfully", clientId, sessionMange.session[sessionkey]["userid"]) response = { "Header": { "status": "success", "module": "projectManage" }, "Body": { "message": "site added sucessfully", "data": "" }, "Signature": { "signature": "", "Key": "" } } return response else: self.log.logEvent("projectManage", 2, "project can't added", clientId, sessionMange.session[sessionkey]["userid"]) response = { "Header": { "status": "success", "module": "projectManage" }, "Body": { "message": "site can't added", "data": "" }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: # self.syslog.eventHandle("projectmanagement","exception","exception on projectManage module",str(expc)) self.log.logEvent( "projectManage", 3, " all role permission listed occured " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def shiftCreation(self,clientId,msgDict,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() nameLs = [] valueLs = [] for key in msgDict: nameLs.append(key) valueLs.append(msgDict[key]) curTime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") nameLs.append("shiftcreatedon") valueLs.append(curTime) reval = False try: reval = adminDb.pushData("shift",nameLs,valueLs) if reval: self.log.logEvent("shiftManage",2,"labourer shift created successfully",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"success","module":"ShiftManage"},"Body":{"message":"shift Added successfully","data":""},"Signature":{"signature":"","Key":""}} return response else: self.log.logEvent("shiftManage",2,"labourer shift creation error",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"fail","module":"ShiftManage"},"Body":{"message":"shift can't created","data":""},"Signature":{"signature":"","Key":""}} return response except Exception as expc: print("oocured exception is",expc) self.log.logEvent("shiftmanage",2,str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def labouerList(self,clientId,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() try: labourerData = ["labourername","labourerid","projectname","siteid","labourerclass","shiftid"] self.log.logEvent("labourerManage",2,"labourer info showed successfully",clientId,sessionMange.session[sessionkey]["userid"]) responseData = adminDb.fetchData("labourer",labourerData ) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labourer list","data":responseData},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerManage","exception","exception on labourerManage module",str(expc)) self.log.logEvent("labourerManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def deleteProjects(self, clientId, msgDict, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() delete = " set delete = 'True' where " condition = {"projectid": msgDict["projectId"]} try: if adminDb.updateTable(delete, "projects", condition) and adminDb.updateTable( delete, "sites", condition): self.log.logEvent("projectManage", 3, "project deleted successfully", clientId, sessionMange.session[sessionkey]["userid"]) response = { "Header": { "status": "success", "module": "projectManage" }, "Body": { "message": "project deleted successfully", "data": "" }, "Signature": { "signature": "", "Key": "" } } return response else: self.log.logEvent("projectManage", 3, "project deleted db error occured", clientId, sessionMange.session[sessionkey]["userid"]) response = { "Header": { "status": "fail", "module": "projectManage" }, "Body": { "message": "project can't deleted", "data": "" }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: # self.syslog.eventHandle("projectmanagement","exception","exception on projectManage module",str(expc)) self.log.logEvent( "projectManage", 3, " all role permission listed occured " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def editList(self, clientId, msgDict, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() condition = {"employeeid": msgDict["employeeId"]} datalis = [ "fullname", "employeeid", "designation", "emailid", "userrole", 'archive' ] cliList = adminDb.fetchData("clientusers", datalis, condition) infolist = [] try: for info in cliList: for tup in info: infolist.append(tup) role = adminDb.fetchData("permission", ["rolename", "roleid"]) infolist.append(role) self.log.logEvent("Admin", 2, "edit button wanted listed successfully", clientId, sessionMange.session[sessionkey]["userid"]) response = { "Header": { "status": "success", "module": "admin" }, "Body": { "message": "user edit list", "data": infolist }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: self.log.logEvent("Admin", 0, "occured exception is " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def publicVerification(self): dbagent = DatabaseAgent("kunnel", "kunnel", "127.0.0.1", "kunnel123", "5432") key = [] cond = {"userid": "1557"} key.append("PrivateKey") dbprivatekey = dbagent.fetchData(key, "userkeys", cond) prvk = base64.b64decode(str(data).encode('utf8')) print("actual key2", prvk)
def classList(self,clientId,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() labclas = ["labourerclass","wageclass","labourerclassid","compensation","retention","advance","concretecharges"] #,"compensation","Retention","Advance","Concrete_charges"] self.log.logEvent("Admin",2,"class list listed successfully",clientId,sessionMange.session[sessionkey]["userid"]) try: responseData = adminDb.fetchData("labourerclass",labclas) response = {"Header":{"status":"success","module":"labourerClass"},"Body":{"message":"class list","data":responseData},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerclassManage","exception","exception on labourerclassManage module",str(expc)) self.log.logEvent("labourerclassManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def bankInfo(self,clientId,msgDict,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() conditiond = {"labourerid":msgDict["labourerId"]} try: bankdata = ["bankname","ifsccode","branchname","bankaccountnumber","nameinbank"] self.log.logEvent("labourerManage",2,"labourer info showed successfully",clientId,sessionMange.session[sessionkey]["userid"]) responseData = adminDb.fetchData("labourer",bankdata,conditiond) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labourer info","data":responseData},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerManage","exception","exception on labourerManage module",str(expc)) self.log.logEvent("labourerManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def labourerInfo(self,clientId,msgDict,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() conditiond = {"labourerid":msgDict["labourerId"]} try: labourdata = ["labourername","callbyname","gender","dateofbirth","fathername","bloodgroup","nextofkin","contactnumberofnextofkin","mothertounge","addressline1","addressline2","addressline3","village","state","country","pincode" ,"mobilenumber","residancephonenumber","emergencyphonenumber","dateofjoining" ,"migrantworker","designation","projectname" ,"siteid" ,"siteofjoining","labourerclass","shiftid","documenttype","documentnumber","nameasperdoc","bankname","ifsccode","branchname","bankaccountnumber","nameinbank","labourerid"] self.log.logEvent("labourerManage",2,"labourer info showed successfully",clientId,sessionMange.session[sessionkey]["userid"]) responseData = adminDb.fetchData("labourer",labourdata,conditiond) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labourer info","data":responseData},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerManage","exception","exception on labourerManage module",str(expc)) self.log.logEvent("labourerManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"])
def shiftList(self,clientId,sessionkey): masterDb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterDb.initConnection() cond = {"clientid":clientId} dbData = masterDb.fetchData("regusers",["password"],cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host,password, 5432) adminDb.initConnection() try: responseData = adminDb.fetchData("shift","*") self.log.logEvent("shiftmanage",2,"labourer shift list",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"success","module":"ShiftManage"},"Body":{"message":"shift can't created","data":responseData},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("shiftmanage","exception","exception on shiftManage module",str(expc)) print("oocured exception is",expc) self.log.logEvent("shiftmanage",2,"labourer shift listed successfully",clientId,sessionMange.session[sessionkey]["userid"])
def getAttendacePers(self, clientId, msgDict, sessionkey): masterDb = DatabaseAgent("kunnel", "kunnel", "127.0.0.1", "kunnel123", "5432") masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, "127.0.0.1", password, 5432) adminDb.initConnection() dataFields = [ "day", "date", "labourerid", "labourername", "labouercategory", "intime", "outtime", "numberofhours", "overtimeallocated", "overtimeworked", "shiftid" ] tableName = "attendance" condition = {} try: for key in msgDict: condition[key.lower()] = (msgDict[key]) responseData = adminDb.fetchData(tableName, dataFields, condition) print("dictonary", responseData) self.log.logEvent("Admin", 2, "attendance listed success fully") response = { "Header": { "status": "success", "module": "attendance" }, "Body": { "message": "filtered attendance", "data": responseData }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: # self.syslog.eventHandle("attendanceManage","exception","exception on attendanceManage module",str(expc)) self.log.logEvent( "attendanceManage", 3, " all role permission listed occured " + str(expc))
def filterProjects(self, clientId, msgDict, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() # condiotion ={"delete ":"False"} condition = {} try: for key in msgDict: condition[key.lower()] = msgDict(key) datalis = [ "projectname,projectlocations,projectlabourers,projectid,siteid" ] self.log.logEvent("projectManage", 0, "project listed successfully", clientId, sessionMange.session[sessionkey]["userid"]) responseData = adminDb.fetchData("projects", datalis, condition) response = { "Header": { "status": "success", "module": "projectManage" }, "Body": { "message": "project filterd", "data": responseData }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: # self.syslog.eventHandle("projectmanagement","exception","exception on projectManage module",str(expc)) self.log.logEvent( "projectManage", 3, " all role permission listed occured " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def advanceRespo(self,clientId,msgDict,sessionkey): try: masterdb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterdb.initConnection() dbpass = masterdb.fetchData("regusers",["password"],{"clientid":clientId}) password = dbpass[0][0] admindb = DatabaseAgent(clientId,clientId,conf.host,password,conf.port) admindb.initConnection() listAdvance = admindb.fetchData("laboureradvance",["status","advanceid"],{"labourerid":msgDict["labourerId"]}) self.log.logEvent("paymentDesk",2,"advancerespo",clientId,sessionMange.session[sessionkey]["userid"]) response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labourer requstedAdvance satus check","data":listAdvance},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerManage","exception","exception on labourerManage module",str(expc)) self.log.logEvent("labourerclassManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"]) print("exception is occured at",str(expc)) # labad = paymentDesk() # # print("total advance list",labad.requstList("kec166")) # print("approvelist",labad.requstApprove("kec166",{"labourerId":"lab1001"})) # # print("approvelist",labad.requstReject("kec166",{"labourerId":"lab1001"}))
def decrypt(self, encmsg, pubkey, cond): dbagent = DatabaseAgent("kunnel", "kunnel", "127.0.0.1", "kunnel123", "5432") key = [ "PrivateKey", ] dbPrivateKey = dbagent.fetchData(key, "userkeys", cond) utf8PriKey = base64.b64decode(str(dbprivatekey).encode('utf8')) key_box = libnacl.public.Box(utf8PriKey, pubkey) dec_mess = key_box.decrypt(encmsg) plainTxt = str(dec_mess, 'utf-8') return plainTxt
def encrypt(self, msg, pubkey, cond): dbagent = DatabaseAgent("kunnel", "kunnel", "127.0.0.1", "kunnel123", "5432") key = [ "PrivateKey", ] dbPrivatekey = dbagent.fetchData(key, "userkeys", cond) utf8PriKey = base64.b64decode(str(dbPrivatekey).encode('utf8')) print(type(utf8PriKey)) key_box = libnacl.public.Box(utf8PriKey, pubkey) messageEncoded = bytes(msg, 'utf-8') cipher = key_box.encrypt(messageEncoded) return cipher
def userProfile(self, clientId, msgDict, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] dbCompanyname = masterDb.fetchData("regusers", ["companyname"], cond) print(".................", dbData) adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() conditions = {"employeeid": msgDict["employeeId"]} detail = ["fullname", "employeeid", "userrole", "designation"] self.log.logEvent("Admin", 0, "user profile showed", clientId, msgDict["employeeId"]) try: responseData = adminDb.fetchData("clientusers", detail, conditions) print("response data", responseData) responseData.append(dbCompanyname[0][0]) response = { "Header": { "status": "success", "module": "admin" }, "Body": { "message": "user profile", "data": responseData }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: self.log.logEvent("Admin", 0, "occured exception is " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def listClientUser(self, clientId, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] print(".................", dbData) adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() datalis = [ "fullname", "employeeid", "designation", "userrole", 'archive' ] self.log.logEvent("Admin", 0, "Client user listed successfully", clientId, sessionMange.session[sessionkey]["userid"]) try: responseData = adminDb.fetchData("clientusers", datalis) print("dbdata is................................", responseData) response = { "Header": { "status": "success", "module": "admin" }, "Body": { "message": "user list", "data": responseData }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: self.log.logEvent("Admin", 0, "occured exception is " + str(expc), clientId, sessionMange.session[sessionkey]["userid"])
def projectIdList(self, clientId, sessionkey): masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host, conf.mdbPassword, conf.port) masterDb.initConnection() cond = {"clientid": clientId} dbData = masterDb.fetchData("regusers", ["password"], cond) password = dbData[0][0] adminDb = DatabaseAgent(clientId, clientId, conf.host, password, 5432) adminDb.initConnection() try: responseData = adminDb.fetchData("projects", ["projectid"]) self.log.logEvent("projectManage", 0, "projectId listed successfully", clientId, sessionMange.session[sessionkey]["userid"]) response = { "Header": { "status": "success", "module": "projectManage" }, "Body": { "message": "project idlist", "data": responseData }, "Signature": { "signature": "", "Key": "" } } return response except Exception as expc: # self.syslog.eventHandle("projectmanagement","exception","exception on projectManage module",str(expc)) self.log.logEvent("projectManage", 3, str(expc), clientId, sessionMange.session[sessionkey]["userid"]) # pro = projectManage() # pro.listProjects("kec119","karthi007")
def requstApprove(self,clientId,msgDist,sessionkey): masterdb = DatabaseAgent(conf.mdbName,conf.muserName,conf.host,conf.mdbPassword,conf.port) masterdb.initConnection() dbpass = masterdb.fetchData("regusers",["password"],{"clientid":clientId}) password = dbpass[0][0] admindb = DatabaseAgent(clientId,clientId,conf.host,password,conf.port) admindb.initConnection() randomid = str(random.randint(10000000000,1000000000000))[:8] approveCont = " set approvestatus = 'approved', approveid = "+randomid+" where " try: if admindb.updateTable(approveCont,"accountinfo",{"labourerid":msgDist["labourerId"]}): response = {"Header":{"status":"success","module":"labfinace"},"Body":{"message":"labourer requst is approved","data":""},"Signature":{"signature":"","Key":""}} return response else: response = {"Header":{"status":"fail","module":"labfinace"},"Body":{"message":"labourer requst is can't approved","data":""},"Signature":{"signature":"","Key":""}} return response except Exception as expc: # self.syslog.eventHandle("labourerclassManage","exception","exception on labourerclassManage module",str(expc)) self.log.logEvent("labourerclassManage",2,"occured expection is"+str(expc),clientId,sessionMange.session[sessionkey]["userid"])