def search(self,params):
params["pageNo"]=(params["pageNo"]-1)*self.pageSize
sql="select * from sos_timetable where 1=1 "
rowSql="select count(ID) from sos_timetable where 1=1"
val = params.get("subjectName",None)
if( DataValidator.isNotNull(val)):
sql+=" and subjectName = '"+val+"' "
rowSql+=" and subjectName = '"+val+"' "
val = params.get("semester",None)
if( DataValidator.isNotNull(val)):
sql+=" and semester = '"+val+"' "
rowSql+=" and semester = '"+val+"' "
sql+=" LIMIT %s,%s"
rowSql+=" LIMIT %s,%s"
cursor = connection.cursor()
cursor.execute(sql,[params["pageNo"],self.pageSize])
result=cursor.fetchall()
test_tup1=("id","examTime","examDate","subjectName","courseName","semester")
res={
"data":[],
"count":[]
}
count=0
for x in result:
res["data"].append({test_tup1[i] : x[i] for i, _ in enumerate(x)})
return res
return q
def input_validation(self):
super().input_validation()
inputError = self.form["inputError"]
if (DataValidator.isNull(self.form["firstName"])):
inputError["firstName"] = "Name can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["lastName"])):
inputError["lastName"] = "Last Name can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["login_id"])):
inputError["login_id"] = "Login can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["password"])):
inputError["password"] = "******"
self.form["error"] = True
if (DataValidator.isNull(self.form["confirmpassword"])):
inputError["confirmpassword"] = "******"
self.form["error"] = True
if (DataValidator.isNotNull(self.form["confirmpassword"])):
if (self.form["password"] != self.form["confirmpassword"]):
inputError[
"confirmpassword"] = "******"
self.form["error"] = True
if (DataValidator.isNull(self.form["dob"])):
inputError["dob"] = "dob can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["address"])):
inputError["address"] = "address can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["mobilenumber"])):
inputError["mobilenumber"] = "mobileNumber can not be null"
self.form["error"] = True
return self.form["error"]
def input_validation(self):
super().input_validation()
inputError = self.form["inputError"]
if (DataValidator.isNull(self.form["firstName"])):
inputError["firstName"] = "Name can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["lastName"])):
inputError["lastName"] = "Last Name can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["login"])):
inputError["login"] = "******"
self.form["error"] = True
if (DataValidator.isNull(self.form["password"])):
inputError["password"] = "******"
self.form["error"] = True
if (DataValidator.isNull(self.form["dob"])):
inputError["dob"] = "dob can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["mobileNumber"])):
inputError["mobileNumber"] = "mobileNumber can not be null"
self.form["error"] = True
return self.form["error"]
def get_login_id(self, login):
q = self.get_model().objects.filter()
if (DataValidator.isNotNull(login)):
q = q.filter(login_id=login)
return q
def search(self, params):
q = self.get_model().objects.filter()
val = params.get("firstName", None)
if (DataValidator.isNotNull(val)):
q = q.filter(firstName=val)
val = params.get("lastName", None)
if (DataValidator.isNotNull(val)):
q = q.filter(lastName=val)
val = params.get("email", None)
if (DataValidator.isNotNull(val)):
q = q.filter(email=val)
val = params.get("password", None)
if (DataValidator.isNotNull(val)):
q = q.filter(password=val)
val = params.get("mobileNumber", None)
if (DataValidator.isNotNull(val)):
q = q.filter(mobileNumber=val)
val = params.get("address", None)
if (DataValidator.isNotNull(val)):
q = q.filter(address=val)
val = params.get("gender", None)
if (DataValidator.isNotNull(val)):
q = q.filter(gender=val)
val = params.get("dob", None)
if (DataValidator.isNotNull(val)):
q = q.filter(dob=val)
val = params.get("college_ID", None)
if (DataValidator.isNotNull(val)):
q = q.filter(college_ID=val)
val = params.get("collegeName", None)
if (DataValidator.isNotNull(val)):
q = q.filter(collegeName=val)
val = params.get("subject_ID", None)
if (DataValidator.isNotNull(val)):
q = q.filter(subject_ID=val)
val = params.get("subjectName", None)
if (DataValidator.isNotNull(val)):
q = q.filter(subjectName=val)
val = params.get("course_ID", None)
if (DataValidator.isNotNull(val)):
q = q.filter(course_ID=val)
val = params.get("courseName", None)
if (DataValidator.isNotNull(val)):
q = q.filter(courseName=val)
return q
def input_validation(self):
super().input_validation()
inputError = self.form["inputError"]
if (DataValidator.isNull(self.form["firstName"])):
inputError["firstName"] = "Name can not be null"
self.form["error"] = True
else:
if DataValidator.isaplhacheck(self.form['firstName']):
inputError['firstName'] = "First Name contains only alphabets"
self.form['error'] = True
if (DataValidator.isNull(self.form["lastName"])):
inputError["lastName"] = "Last Name can not be null"
self.form["error"] = True
else:
if DataValidator.isaplhacheck(self.form['lastName']):
inputError['lastName'] = "Last Name contains only alphabet"
self.form["error"] = True
if (DataValidator.isNull(self.form["login"])):
inputError["login"] = "******"
self.form["error"] = True
else:
if DataValidator.isemail(self.form['login']):
inputError['login'] = "******"
self.form['error'] = True
if (DataValidator.isNull(self.form["password"])):
inputError["password"] = "******"
self.form["error"] = True
if (DataValidator.isNull(self.form["dob"])):
inputError["dob"] = "DOB can not be null"
self.form["error"] = True
if (DataValidator.isNull(self.form["mobileNumber"])):
inputError["mobileNumber"] = "Mobile Number can not be null"
self.form["error"] = True
else:
if DataValidator.ismobilecheck(self.form['mobileNumber']):
inputError['mobileNumber'] = "Invalid Mobile Number"
self.form['error'] = True
if (DataValidator.isNull(self.form["gender"])):
inputError['gender'] = "Please Select Gender"
self.form['error'] = True
return self.form["error"]
