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'}