def mod_std(request, subject):
std = request.POST.getlist('mod_std')
print(std[0])
session.query(Standard).filter_by(subject=subject).update({"standard":int(std[0])})
session.commit()
return redirect("view/standard")
def person_main(self, jobID):
info = session.query(Res).filter_by(emp_id=jobID)
name = session.query(Employee.name, Employee.id).filter_by(id = jobID)
context_dict = {
'data': info,
'name': name
}
return render_to_response('grade.html', context_dict)
def std_list(request):
rows = session.query(Standard).count()
if rows >= 1:
context_dict = {
'data': session.query(Standard).all()
}
return render_to_response('standard_list.html', context_dict)
return render_to_response('std_subject_num.html')
def employee(request):
rows = session.query(Employee).count()
print(rows)
if(rows > 0):
context_dict = {
'data': select_all()
}
return render(request, 'main.html', context_dict)
return render(request, 'landing.html')
def add_grade(request, jobID):
user = session.query(Employee).filter_by(id=jobID)
context_dict = {
"id" : user
}
return render_to_response('subject_num.html', context_dict)
def del_info(self, jobID):
session.query(Employee).filter_by(id=jobID).delete()
session.commit()
return redirect('/')
def upd_std(request, subject):
subdata = session.query(Standard).filter_by(subject=subject)
context_dict = {
'data' : subdata
}
return render(request, 'std_diff.html', context_dict)
def select_all():
queries = session.query(Employee).all
return queries
