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 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 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 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 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 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 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 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()
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 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 signUp(self, password):
salt = base64.urlsafe_b64encode(uuid.uuid4().bytes)
hashPassword = hashlib.sha512(password.encode() + salt).hexdigest()
signobj = {}
signobj["hashPassword"] = hashPassword
print("salt type...................", type(salt))
signobj["salt"] = salt
print("hashedpassword", hashPassword)
print("salt---", salt)
dbagent = DatabaseAgent("kunnel", "kunnel", "127.0.0.1", "kunnel123",
"5432")
dbagent.initConnection()
fileds = ["username", "password", "salt"]
datas = ["karthiban", hashPassword, salt]
dbagent.pushData("users", fileds, datas)
return signobj
class Logger:
def __init__(self):
self.curTime = datetime.datetime.now()
self.db = DatabaseAgent(conf.mdbName, conf.muserName, conf.host,
conf.mdbPassword, conf.port)
self.db.initConnection()
def finalizeLogger(self):
self.db.dbFinalize()
def logEvent(self,
moduleName,
severityLevel,
message,
clientId="",
userId=""):
if severityLevel not in range(Constants.LOG_SEVERITY_LOW,
Constants.LOG_SEVERITY_CRITICAL):
return False
logSeverity = [
"LOG_SEVERITY_LOW", "LOG_SEVERITY_MEDIUM", "LOG_SEVERITY_HIGH",
"LOG_SEVERITY_CRITICAL"
]
logData = "<" + moduleName + " : " + str(
self.curTime) + "> " + message
logYear = self.curTime.year
logDay = self.curTime.day
logMonth = self.curTime.month
print("data::::", logData)
fields = [
"module_name", "day", "month", "year", "log_severity", "message",
"clientid", "userid"
]
values = [
moduleName, logDay, logMonth, logYear, logSeverity[severityLevel],
logData, clientId, userId
]
self.db.pushData("applogs", fields, values)
# log = Logger()
# log.logEvent("admin",1,"master login")
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 fincheck(self):
recdict = bytes(self.storage[0]).decode("utf-8")
print("nomore clients here/////////", recdict)
dataDict = json.loads(recdict)
bigstr = ""
nameLs = []
valueLs = []
for key in dataDict:
if key == "FinSig":
nameLs.append(key)
valueLs.append(dataDict[key])
continue
else:
bigstr += dataDict[key]
nameLs.append(key)
valueLs.append(dataDict[key])
print("nomore clients here/////////", bigstr)
sign = hashlib.md5(bigstr.encode("utf-8")).hexdigest()
print("sign value is", sign)
if dataDict["FinSig"] == sign:
masterDb = DatabaseAgent(conf.mdbName, conf.muserName, conf.host,
conf.mdbPassword, conf.port)
masterDb.initConnection()
if not masterDb.fetchSyslogg():
entry = sign + "GEN000000X"
else:
dbEntryId = masterDb.fetchSyslogg()
# decoEntryId = bytes(dbEntryId[0][0]).decode("utf-8")
# print("entryid",str(decoEntryId))
entry = sign + dbEntryId[0][0]
hash = hashlib.md5(entry.encode()).hexdigest()
firstChar = hash[0]
while firstChar != "0":
hash = hashlib.md5(hash.encode()).hexdigest()
print("Entry ID hash: Current hash = ", hash)
firstChar = hash[0]
print("true")
nameLs.append("entryid")
valueLs.append(hash[:10])
masterDb.pushData("syslogg", nameLs, valueLs)
else:
print("fing signature is wrong")
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 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"])
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 companyProfile(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:
compnydata = self.fetchCompanySummary(adminDb)
projectsColl = self.fetchProjectsSummary(adminDb)
finalList = []
finalList.append(list(compnydata))
finalList.append(list(projectsColl))
self.log.logEvent("Admin", 2, "Company pofile sended successfully",
clientId,
sessionMange.session[sessionkey]["userid"])
print("final list is...", finalList)
response = {
"Header": {
"status": "success",
"module": "admin"
},
"Body": {
"message": "companyprile",
"data": finalList
},
"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 deleteLabourer(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 = {"labourerid": msgDict["labourerId"]}
try:
if adminDb.updateTable(delete,"labourer",condition):
self.log.logEvent("labourerManage",2,"labourer deleted successfully",clientId,sessionMange.session[sessionkey]["userid"])
response = {"Header":{"status":"success","module":"labourerManage"},"Body":{"message":"labourer deleted successfully","data":""},"Signature":{"signature":"","Key":""}}
return response
else:
self.log.logEvent("labourerManage",2,"labourer deletd successfully",clientId,sessionMange.session[sessionkey]["userid"])
response = {"Header":{"status":"fail","module":"labourerManage"},"Body":{"message":"labouer cant deleted","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 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"])
