def get_meetings(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Call employers model emp = EmployersModel(request) cid = request.params['cid'] #Check duplicate rs = emp.get_meetings(request.session['owner'], cid) if rs: rows = [] if 'meetings' in rs: for r in rs['meetings']: obj = { 'id': str(r['id']), 'title': r['title'], 'start_date': r['start_date'], 'end_date': r['end_date'], 'owner_name': r['owner_name'], 'place_name': r['place_name'], 'hour': r['hour'] if 'hour' in r else '-' } rows.append(obj) return {'ok': 1, 'rows': rows} else: return {'ok': 0, 'msg': 'ไม่พบรายการ'} else: return {'ok': 0, 'msg': 'ไม่พบรายการ'}
def save_topic(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Call employers model emp = EmployersModel(request) empid = request.params['empid'] topic_name = request.params['topic_name'] topic_type = request.params['topic_type'] desc = request.params['desc'] topic_id = request.params["topic_id"] if 'topic_id' in request.params else False if topic_id: rs = emp.update_topic(ObjectId(empid), ObjectId(topic_id), topic_name, topic_type, desc) if rs: return {'ok': 1, 'msg': 'Update'} else: return {'ok': 0, 'msg': 'ไม่สามารถปรับปรุงรายการได้'} else: request_date = h.get_current_jsdate() rs = emp.save_topic(ObjectId(empid), topic_name, topic_type, desc, request_date) if rs: return {'ok': 1, 'msg': 'Insert'} else: return {'ok': 0, 'msg': 'ไม่สามารถบันทึกรายการได้'}
def get_topics(request): if 'logged' not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: if request.is_xhr: # is ajax request empid = request.params['id'] emp = EmployersModel(request) rs = emp.get_topics(ObjectId(empid)) if rs: rows = [] if 'topics' in rs: for r in rs['topics']: obj = { 'id': str(r['id']), 'topic_name': r['topic_name'], 'topic_type': r['topic_type'], 'request_date': r['request_date'], 'desc': r['desc'] } rows.append(obj) return {'ok': 1, 'rows': rows} else: return {'ok': 0, 'msg': 'ไม่พบรายการ'} else: return {'ok': 0, 'msg': 'Not ajax request'}
def save_topic(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Call employers model emp = EmployersModel(request) empid = request.params['empid'] topic_name = request.params['topic_name'] topic_type = request.params['topic_type'] desc = request.params['desc'] topic_id = request.params[ "topic_id"] if 'topic_id' in request.params else False if topic_id: rs = emp.update_topic(ObjectId(empid), ObjectId(topic_id), topic_name, topic_type, desc) if rs: return {'ok': 1, 'msg': 'Update'} else: return {'ok': 0, 'msg': 'ไม่สามารถปรับปรุงรายการได้'} else: request_date = h.get_current_jsdate() rs = emp.save_topic(ObjectId(empid), topic_name, topic_type, desc, request_date) if rs: return {'ok': 1, 'msg': 'Insert'} else: return {'ok': 0, 'msg': 'ไม่สามารถบันทึกรายการได้'}
def remove_topic(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Call employers model emp = EmployersModel(request) employer_id = request.params['employer_id'] topic_id = request.params['topic_id'] rs = emp.remove_topic(ObjectId(str(employer_id)), ObjectId(str(topic_id))) return {'ok': 1} if rs else {'ok': 0, 'msg': 'ไม่สามารถลบรายการได้'}
def remove_meetings(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Call employers model emp = EmployersModel(request) cid = request.params['cid'] id = request.params['id'] rs = emp.remove_meeting(request.session['owner'], cid, id) return {'ok': 1} if rs else {'ok': 0, 'msg': 'ไม่สามารถลบรายการได้'}
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 get_list(request): if 'logged' not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: if request.is_xhr: # is ajax request start = request.params['start'] if 'start' in request.params else 0 stop = request.params['stop'] if 'stop' in request.params else 25 limit = int(stop) - int(start) emp = EmployersModel(request) rs = emp.get_list(request.session['owner'], int(start), int(limit)) #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 get_detail(request): if 'logged' not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: #If ajax request if request.is_xhr: if request.params['id']: id = request.params['id'] emp = EmployersModel(request) try: r = emp.detail(ObjectId(id)) obj = { 'id': str(r['_id']), 'cid': r['cid'], 'fullname': r['fullname'], 'birth': r['birth'] if 'birth' in r else '-', 'sex': r['sex'], 'position': str(r['position']), 'position_id': r['position_id'] if 'position_id' in r else '-', 'email': r['email'] if 'email' in r else '-', 'telephone': r['telephone'] if 'telephone' in r else '-', 'grade': str(r['grade']), 'department': r['department'] if 'department' in r else '-', 'start_date': r['start_date'] if 'start_date' in r else '', 'end_date': r['end_date'] if 'end_date' in r else '', 'position_id': r['position_id'] if 'position_id' in r else '-', '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 '-' } return {'ok': 1, 'rows': obj} except Exception as e: raise e else: return {'ok': 0, 'msg': u'กรุณาระบุ id'} else: return {'ok': 0, 'msg': 'Not ajax.'}
def get_total(request): if 'logged' not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: csrf_token = request.params['csrf_token'] is_token = (csrf_token == unicode(request.session.get_csrf_token())) if is_token: emp = EmployersModel(request) try: total = emp.get_total(request.session['owner']) return {'ok': 1, 'total': total} except Exception as e: return {'ok': 0, 'msg': e.message} else: return {'ok': 0, 'msg': 'Not ajax request'}
def save_meetings(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Call employers model emp = EmployersModel(request) cid = request.params['cid'] start_date = request.params['s'] end_date = request.params['e'] title = request.params['t'] owner_name = request.params['o'] place_name = request.params['p'] hour = request.params['hour'] id = request.params["id"] if 'id' in request.params else False if id: rs = emp.update_meeting(request.session['owner'], cid, id, title, start_date, end_date, owner_name, place_name, hour) if rs: return {'ok': 1} else: return {'ok': 0, 'msg': 'ไม่สามารถปรับปรุงรายการได้'} else: #Check duplicate is_duplicate = emp.check_meeting_duplicate( request.session['owner'], cid, title, start_date, end_date, owner_name) if is_duplicate: return {'ok': 0, 'msg': 'ข้อมูลซ้ำ'} else: #Save rs = emp.save_meetings(request.session['owner'], cid, title, start_date, end_date, owner_name, place_name, hour) if rs: return {'ok': 1} else: return {'ok': 0, 'msg': 'ไม่สามารถบันทึกรายการได้'}
def save_meetings(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Call employers model emp = EmployersModel(request) cid = request.params['cid'] start_date = request.params['s'] end_date = request.params['e'] title = request.params['t'] owner_name = request.params['o'] place_name = request.params['p'] hour = request.params['hour'] id = request.params["id"] if 'id' in request.params else False if id: rs = emp.update_meeting(request.session['owner'], cid, id, title, start_date, end_date, owner_name, place_name, hour) if rs: return {'ok': 1} else: return {'ok': 0, 'msg': 'ไม่สามารถปรับปรุงรายการได้'} else: #Check duplicate is_duplicate = emp.check_meeting_duplicate(request.session['owner'], cid, title, start_date, end_date, owner_name) if is_duplicate: return {'ok': 0, 'msg': 'ข้อมูลซ้ำ'} else: #Save rs = emp.save_meetings(request.session['owner'], cid, title, start_date, end_date, owner_name, place_name, hour) if rs: return {'ok': 1} else: return {'ok': 0, 'msg': 'ไม่สามารถบันทึกรายการได้'}
def save_new(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Check if ajax request if request.is_xhr: # Get parameters id = request.params["id"] if 'id' in request.params else False fullname = request.params["f"] cid = request.params["c"] birth = request.params["b"] sex = request.params["s"] position = request.params["p"] position_grade = request.params["pg"] position_id = request.params["pid"] department = request.params["d"] email = request.params["e"] telephone = request.params["t"] start_date = request.params["sd"] end_date = request.params["ed"] status = request.params["st"] line = request.params['line'] facebook = request.params['facebook'] skype = request.params['skype'] address = request.params['address'] graduate = request.params['graduate'] graduate_place = request.params['graduate_place'] # Check data is valid chk = fullname and cid and birth and sex and position # Data is valid if chk: # Call employers model emp = EmployersModel(request) rs = False if id: # Update emp.update(ObjectId(id), fullname, birth, sex, ObjectId(position), ObjectId(position_grade), department, email, telephone, start_date, end_date, status, position_id, skype, line, facebook, address, graduate, graduate_place) return {"ok": 1} else: # Create # Check if cid exist is_duplicated = emp.check_duplicated(request.session['owner'], cid) # If cid don't exist if is_duplicated: return {'ok': 0, 'msg': u'เลขบัตรประชาชนซ้ำ'} else: # Save new employer rs = emp.save_new(request.session['owner'], fullname, cid, birth, sex, ObjectId(position), ObjectId(position_grade), department, email, telephone, start_date, end_date, status, position_id, skype, line, facebook, address, graduate, graduate_place) if rs: return {"ok": 1} # Has error else: return {"ok": 0, "msg": u"ไม่สามารถบันทึกรายการได้"} else: return {"ok": 0, "msg": u"ข้อมูลไม่สมบูรณ์ กรุณาตรวจสอบ"} else: return {"ok": 0, "msg": "Not ajax request."}
def save_new(request): if "logged" not in request.session: return {'ok': 0, 'msg': 'Please login.'} else: # Check if ajax request if request.is_xhr: # Get parameters id = request.params["id"] if 'id' in request.params else False fullname = request.params["f"] cid = request.params["c"] birth = request.params["b"] sex = request.params["s"] position = request.params["p"] position_grade = request.params["pg"] position_id = request.params["pid"] department = request.params["d"] email = request.params["e"] telephone = request.params["t"] start_date = request.params["sd"] end_date = request.params["ed"] status = request.params["st"] line = request.params['line'] facebook = request.params['facebook'] skype = request.params['skype'] address = request.params['address'] graduate = request.params['graduate'] graduate_place = request.params['graduate_place'] # Check data is valid chk = fullname and cid and birth and sex and position # Data is valid if chk: # Call employers model emp = EmployersModel(request) rs = False if id: # Update emp.update(ObjectId(id), fullname, birth, sex, ObjectId(position), ObjectId(position_grade), department, email, telephone, start_date, end_date, status, position_id, skype, line, facebook, address, graduate, graduate_place) return {"ok": 1} else: # Create # Check if cid exist is_duplicated = emp.check_duplicated( request.session['owner'], cid) # If cid don't exist if is_duplicated: return {'ok': 0, 'msg': u'เลขบัตรประชาชนซ้ำ'} else: # Save new employer rs = emp.save_new(request.session['owner'], fullname, cid, birth, sex, ObjectId(position), ObjectId(position_grade), department, email, telephone, start_date, end_date, status, position_id, skype, line, facebook, address, graduate, graduate_place) if rs: return {"ok": 1} # Has error else: return { "ok": 0, "msg": u"ไม่สามารถบันทึกรายการได้" } else: return {"ok": 0, "msg": u"ข้อมูลไม่สมบูรณ์ กรุณาตรวจสอบ"} else: return {"ok": 0, "msg": "Not ajax request."}