Skip to content

Instantly share code, notes, and snippets.

@jumbojet
Created September 30, 2013 20:10
Show Gist options
  • Save jumbojet/6769428 to your computer and use it in GitHub Desktop.
Save jumbojet/6769428 to your computer and use it in GitHub Desktop.
Code for searching and selecting employee
''' changes to url.py '''
urlpatterns = patterns('',
url(r'^employees/$',get_all_employees),
url(r'^employees/empdetail$',get_employee_by_id),
url(r'^employees/empsearch$',get_employee_search),
)
'''changes to views.py ###### '''
def get_employee_by_id(request):
empDetail ={}
if 'EMP_ID' in request.GET:
emp_id = request.GET['EMP_ID']
emp = Employee.objects.get(employeeid=emp_id)
empDetail['EMPLOYEE_ID'] = emp.employeeid
empDetail['EMPLOYEE_NAME'] = emp.name
empDetail['EMPLOYEE_DOB'] =str(emp.dob.date()) # Get only the date part
empDetail['EMPLOYEE_SALARY'] =emp.salary
return HttpResponse(json.dumps(empDetail))
def get_employee_search(request):
emp_id,emp_name ="",""
empDetail ={}
if 'EMP_ID' in request.GET:
emp_id = request.GET['EMP_ID']
if 'EMP_NAME' in request.GET:
emp_name = request.GET['EMP_NAME']
if emp_id == "":
empSet = Employee.objects.filter(name=emp_name) # as there will be a list of employees with same name
empList =[]
for emp in empSet:
empDict ={}
empDict['EMPLOYEE_ID'] = emp.employeeid
empDict['EMPLOYEE_NAME'] = emp.name
empDict['EMPLOYEE_DOB'] =str(emp.dob.date()) # Get only the date part
empDict['EMPLOYEE_SALARY'] =emp.salary
empList.append(empDict)
return HttpResponse(json.dumps(empList))
emp = Employee.objects.get(employeeid=emp_id)
empDetail['EMPLOYEE_ID'] = emp.employeeid
empDetail['EMPLOYEE_NAME'] = emp.name
empDetail['EMPLOYEE_DOB'] =str(emp.dob.date()) # Get only the date part
empDetail['EMPLOYEE_SALARY'] =emp.salary
return HttpResponse(json.dumps(empDetail))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment