def get_info(request): if 'logged' not in request.session: return HTTPFound(location='/signin') else: if request.is_xhr: csrf_token = request.params['csrf_token'] is_token = (csrf_token == unicode(request.session.get_csrf_token())) if is_token: hospcode = request.params['hospcode'] pid = request.params['pid'] seq = request.params['seq'] diagcode = request.params['diagcode'] epidem = EpidemModel(request) person = PersonModel(request) rs = epidem.get_info(hospcode, pid, seq, diagcode) p = person.get_person_detail(pid, hospcode) if rs: if p: village = '0%s' % rs['illvillage'] if len(rs['illvillage']) < 2 else rs['illvillage'] catm = '%s%s%s%s' % (rs['illchanwat'], rs['illampur'], rs['illtambon'], village) obj = { 'an': rs['an'], 'cid': rs['cid'], 'pid': rs['pid'], 'fullname': '%s %s' % (p['name'], p['lname']), 'sex': p['sex'], 'birth': h.to_thai_date(p['birth']), 'age': h.count_age(p['birth']), 'code506': '[%s] %s' % (rs['code506'], h.get_code506_name(request, rs['code506'])), 'diag': '[%s] %s' % (rs['diagcode'], h.get_diag_name(request, rs['diagcode'])), 'date_death': h.to_thai_date(rs['date_death']), 'date_serv': h.to_thai_date(rs['date_serv']), 'illdate': h.to_thai_date(rs['illdate']), 'ill_address': '%s %s' % (rs['illhouse'], h.get_address_from_catm(request, catm)), 'latLng': '%s, %s' % (rs['latitude'], rs['longitude']), 'ptstatus': rs['ptstatus'], 'complication': h.get_complication_name(request, rs['complication']), } return { 'ok': 1, 'rows': obj } else: return { 'ok': 0, 'msg': u'ไม่พบข้อมูลบุคคล' } else: return {'ok': 0, 'msg': u'ไม่พบข้อมูล'} else: return {'ok': 0, 'msg': 'Invalid token.'}
def get_list_total(request): if 'logged' not in request.session: return HTTPFound(location='/signin') csrf_token = request.params['csrf_token'] is_token = (csrf_token == unicode(request.session.get_csrf_token())) if is_token: epidem = EpidemModel(request) start_date = request.params['start_date'] end_date = request.params['end_date'] code506 = request.params['code506'] ptstatus = request.params['ptstatus'] start_date = start_date.split('/') end_date = end_date.split('/') sy = int(start_date[2]) - 543 ey = int(end_date[2]) - 543 start_date = str(sy) + start_date[1] + start_date[0] end_date = str(ey) + end_date[1] + end_date[0] if code506 and not ptstatus: total = epidem.get_list_total_by_code506(request.session['hospcode'], code506, start_date, end_date) elif ptstatus and not code506: total = epidem.get_list_total_by_ptstatus(request.session['hospcode'], ptstatus, start_date, end_date) elif ptstatus and code506: total = epidem.get_list_total_by_code506_ptstatus(request.session['hospcode'], code506, ptstatus, start_date, end_date) else: total = epidem.get_list_total(request.session['hospcode'], start_date, end_date) return {'ok': 1, 'total': total} if total else {'ok': 0, 'msg': u'ไม่พบข้อมูล'} else: return {'ok': 0, 'msg': 'Not ajax request'}
def get_list_total(request): if 'logged' not in request.session: return HTTPFound(location='/signin') csrf_token = request.params['csrf_token'] is_token = (csrf_token == unicode(request.session.get_csrf_token())) if is_token: epidem = EpidemModel(request) start_date = request.params['start_date'] end_date = request.params['end_date'] code506 = request.params['code506'] ptstatus = request.params['ptstatus'] start_date = start_date.split('/') end_date = end_date.split('/') sy = int(start_date[2]) - 543 ey = int(end_date[2]) - 543 start_date = str(sy) + start_date[1] + start_date[0] end_date = str(ey) + end_date[1] + end_date[0] if code506 and not ptstatus: total = epidem.get_list_total_by_code506( request.session['hospcode'], code506, start_date, end_date) elif ptstatus and not code506: total = epidem.get_list_total_by_ptstatus( request.session['hospcode'], ptstatus, start_date, end_date) elif ptstatus and code506: total = epidem.get_list_total_by_code506_ptstatus( request.session['hospcode'], code506, ptstatus, start_date, end_date) else: total = epidem.get_list_total(request.session['hospcode'], start_date, end_date) return { 'ok': 1, 'total': total } if total else { 'ok': 0, 'msg': u'ไม่พบข้อมูล' } else: return {'ok': 0, 'msg': 'Not ajax request'}
def get_info(request): if 'logged' not in request.session: return HTTPFound(location='/signin') else: if request.is_xhr: csrf_token = request.params['csrf_token'] is_token = (csrf_token == unicode( request.session.get_csrf_token())) if is_token: hospcode = request.params['hospcode'] pid = request.params['pid'] seq = request.params['seq'] diagcode = request.params['diagcode'] epidem = EpidemModel(request) person = PersonModel(request) rs = epidem.get_info(hospcode, pid, seq, diagcode) p = person.get_person_detail(pid, hospcode) if rs: if p: village = '0%s' % rs['illvillage'] if len( rs['illvillage']) < 2 else rs['illvillage'] catm = '%s%s%s%s' % (rs['illchanwat'], rs['illampur'], rs['illtambon'], village) obj = { 'an': rs['an'], 'cid': rs['cid'], 'pid': rs['pid'], 'fullname': '%s %s' % (p['name'], p['lname']), 'sex': p['sex'], 'birth': h.to_thai_date(p['birth']), 'age': h.count_age(p['birth']), 'code506': '[%s] %s' % (rs['code506'], h.get_code506_name(request, rs['code506'])), 'diag': '[%s] %s' % (rs['diagcode'], h.get_diag_name(request, rs['diagcode'])), 'date_death': h.to_thai_date(rs['date_death']), 'date_serv': h.to_thai_date(rs['date_serv']), 'illdate': h.to_thai_date(rs['illdate']), 'ill_address': '%s %s' % (rs['illhouse'], h.get_address_from_catm(request, catm)), 'latLng': '%s, %s' % (rs['latitude'], rs['longitude']), 'ptstatus': rs['ptstatus'], 'complication': h.get_complication_name(request, rs['complication']), } return {'ok': 1, 'rows': obj} else: return {'ok': 0, 'msg': u'ไม่พบข้อมูลบุคคล'} else: return {'ok': 0, 'msg': u'ไม่พบข้อมูล'} else: return {'ok': 0, 'msg': 'Invalid token.'}
def get_list(request): if 'logged' not in request.session: return HTTPFound(location='/signin') else: if request.is_xhr: # is ajax request csrf_token = request.params['csrf_token'] is_token = (csrf_token == unicode( request.session.get_csrf_token())) if is_token: start_date = request.params['start_date'] end_date = request.params['end_date'] code506 = request.params['code506'] ptstatus = request.params['ptstatus'] start_date = start_date.split('/') end_date = end_date.split('/') sy = int(start_date[2]) - 543 ey = int(end_date[2]) - 543 start_date = str(sy) + start_date[1] + start_date[0] end_date = str(ey) + end_date[1] + end_date[0] start = request.params['start'] stop = request.params['stop'] limit = int(stop) - int(start) epidem = EpidemModel(request) person = PersonModel(request) if code506 and not ptstatus: rs = epidem.get_list_by_code506( request.session['hospcode'], code506, start_date, end_date, int(start), int(limit)) elif ptstatus and not code506: rs = epidem.get_list_by_ptstatus( request.session['hospcode'], ptstatus, start_date, end_date, int(start), int(limit)) elif ptstatus and code506: rs = epidem.get_list_by_code506_ptstatus( request.session['hospcode'], code506, ptstatus, start_date, end_date, int(start), int(limit)) else: rs = epidem.get_list(request.session['hospcode'], start_date, end_date, int(start), int(limit)) rows = [] if rs: for r in rs: p = person.get_person_detail(r['pid'], r['hospcode']) if p: village = '0%s' % r['illvillage'] if len( r['illvillage']) < 2 else r['illvillage'] catm = '%s%s%s%s' % (r['illchanwat'], r['illampur'], r['illtambon'], village) obj = { 'pid': r['pid'], 'cid': p['cid'], 'fullname': p['name'] + ' ' + p['lname'], 'birth': h.to_thai_date(p['birth']), 'age': h.count_age(p['birth']), 'sex': p['sex'], 'ill_address': '%s %s' % (r['illhouse'], h.get_address_from_catm(request, catm)), 'illdate': h.to_thai_date(r['illdate']), 'date_serv': h.to_thai_date(r['date_serv']), 'code506': r['code506'], 'code506_name': h.get_code506_name(request, r['code506']), 'ptstatus': r['ptstatus'], 'seq': r['seq'], 'diagcode': r['diagcode'], 'diagname': h.get_diag_name(request, r['diagcode']), 'hospcode': r['hospcode'] } else: obj = { 'pid': '-', 'cid': '-', 'fullname': '-', 'birth': '-', 'age': '-', 'sex': '-', 'ill_address': '-', 'illdate': '-', 'code506': '-', 'code506_name': '-', 'ptstatus': '-' } rows.append(obj) return {'ok': 1, 'rows': rows} else: return {'ok': 0, 'msg': u'ไม่พบข้อมูล'} else: return {'ok': 0, 'msg': 'Token not found.'} else: return {'ok': 0, 'msg': 'Not ajax request.'}
def get_list(request): if 'logged' not in request.session: return HTTPFound(location='/signin') else: if request.is_xhr: # is ajax request csrf_token = request.params['csrf_token'] is_token = (csrf_token == unicode(request.session.get_csrf_token())) if is_token: start_date = request.params['start_date'] end_date = request.params['end_date'] code506 = request.params['code506'] ptstatus = request.params['ptstatus'] start_date = start_date.split('/') end_date = end_date.split('/') sy = int(start_date[2]) - 543 ey = int(end_date[2]) - 543 start_date = str(sy) + start_date[1] + start_date[0] end_date = str(ey) + end_date[1] + end_date[0] start = request.params['start'] stop = request.params['stop'] limit = int(stop) - int(start) epidem = EpidemModel(request) person = PersonModel(request) if code506 and not ptstatus: rs = epidem.get_list_by_code506(request.session['hospcode'], code506, start_date, end_date, int(start), int(limit)) elif ptstatus and not code506: rs = epidem.get_list_by_ptstatus(request.session['hospcode'], ptstatus, start_date, end_date, int(start), int(limit)) elif ptstatus and code506: rs = epidem.get_list_by_code506_ptstatus(request.session['hospcode'], code506, ptstatus, start_date, end_date, int(start), int(limit)) else: rs = epidem.get_list(request.session['hospcode'], start_date, end_date, int(start), int(limit)) rows = [] if rs: for r in rs: p = person.get_person_detail(r['pid'], r['hospcode']) if p: village = '0%s' % r['illvillage'] if len(r['illvillage']) < 2 else r['illvillage'] catm = '%s%s%s%s' % (r['illchanwat'], r['illampur'], r['illtambon'], village) obj = { 'pid': r['pid'], 'cid': p['cid'], 'fullname': p['name'] + ' ' + p['lname'], 'birth': h.to_thai_date(p['birth']), 'age': h.count_age(p['birth']), 'sex': p['sex'], 'ill_address': '%s %s' % (r['illhouse'], h.get_address_from_catm(request, catm)), 'illdate': h.to_thai_date(r['illdate']), 'date_serv': h.to_thai_date(r['date_serv']), 'code506': r['code506'], 'code506_name': h.get_code506_name(request, r['code506']), 'ptstatus': r['ptstatus'], 'seq': r['seq'], 'diagcode': r['diagcode'], 'diagname': h.get_diag_name(request, r['diagcode']), 'hospcode': r['hospcode'] } else: obj = { 'pid': '-', 'cid': '-', 'fullname': '-', 'birth': '-', 'age': '-', 'sex': '-', 'ill_address': '-', 'illdate': '-', 'code506': '-', 'code506_name': '-', 'ptstatus': '-' } rows.append(obj) return {'ok': 1, 'rows': rows} else: return {'ok': 0, 'msg': u'ไม่พบข้อมูล'} else: return {'ok': 0, 'msg': 'Token not found.'} else: return {'ok': 0, 'msg': 'Not ajax request.'}