def search(request):
if 'logged' not in request.session:
return {'ok': 0, 'msg': 'Please login.'}
else:
if request.is_xhr: # is ajax request
query = request.params['query']
emp = EmployersModel(request)
try:
#Search by cid
q = int(query)
rs = emp.search_by_cid(request.session['owner'], query)
except Exception as e:
#Search by name
rs = emp.search_by_name(request.session['owner'], query)
#return {'ok': 1, 'rows': rs.count()}
if rs:
rows = []
for r in rs:
obj = {
'id': str(r['_id']),
'cid': r['cid'],
'fullname': r['fullname'],
'birth': r['birth'] if 'birth' in r else '-',
'sex': r['sex'],
'position': h.get_position_name(request, r['position']),
'grade': h.get_position_grade_name(request, r['grade']),
'start_date': r['start_date'],
'end_date': r['end_date'],
'email': r['email'],
'telephone': r['telephone'],
'status': r['status'] if 'status' in r else '0',
'address': r['address'] if 'address' in r else '-',
'skype': r['skype'] if 'skype' in r else '-',
'facebook': r['facebook'] if 'facebook' in r else '-',
'line': r['line'] if 'line' in r else '-',
'graduate': r['graduate'] if 'graduate' in r else '',
'graduate_place': r['graduate_place'] if 'graduate_place' in r else '-'
}
rows.append(obj)
return {'ok': 1, 'rows': rows}
else:
return {'ok': 0, 'msg': u'ไม่พบข้อมูล'}
else:
return {'ok': 0, 'msg': 'Not ajax request'}
def search(request):
if 'logged' not in request.session:
return {'ok': 0, 'msg': 'Please login.'}
else:
if request.is_xhr: # is ajax request
query = request.params['query']
emp = EmployersModel(request)
try:
#Search by cid
q = int(query)
rs = emp.search_by_cid(request.session['owner'], query)
except Exception as e:
#Search by name
rs = emp.search_by_name(request.session['owner'], query)
#return {'ok': 1, 'rows': rs.count()}
if rs:
rows = []
for r in rs:
obj = {
'id':
str(r['_id']),
'cid':
r['cid'],
'fullname':
r['fullname'],
'birth':
r['birth'] if 'birth' in r else '-',
'sex':
r['sex'],
'position':
h.get_position_name(request, r['position']),
'grade':
h.get_position_grade_name(request, r['grade']),
'start_date':
r['start_date'],
'end_date':
r['end_date'],
'email':
r['email'],
'telephone':
r['telephone'],
'status':
r['status'] if 'status' in r else '0',
'address':
r['address'] if 'address' in r else '-',
'skype':
r['skype'] if 'skype' in r else '-',
'facebook':
r['facebook'] if 'facebook' in r else '-',
'line':
r['line'] if 'line' in r else '-',
'graduate':
r['graduate'] if 'graduate' in r else '',
'graduate_place':
r['graduate_place'] if 'graduate_place' in r else '-'
}
rows.append(obj)
return {'ok': 1, 'rows': rows}
else:
return {'ok': 0, 'msg': u'ไม่พบข้อมูล'}
else:
return {'ok': 0, 'msg': 'Not ajax request'}
