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_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 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 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 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 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 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 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."}
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 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'}