def save_fb_user(content):
"""
Internal dao method to save/update an fb user
"""
res = {}
res['valid'] = False
try:
user = User()
user.userid = content['id']
user.firstname = content['first_name'] if 'first_name' in content else None
user.lastname = content['last_name'] if 'last_name' in content else None
user.email = content['email'] if 'email' in content else None
user.birthday = datetime.strptime(content['birthday'], '%m/%d/%Y') if 'birthday' in content else None
user.gender = content['gender'] if 'gender' in content else None
user.access_token = content['access_token']
user.location = update_fb_user_location(content['location']) if 'location' in content else None
user.save()
res['valid'] = True
res['userid'] = content['id']
res['access_token'] = content['access_token']
except:
logger.exception("Unexpected error while saving user: "+str(sys.exc_info()[0]))
res['valid'] = False
return res
return res
def handle(self, *args, **options):
Magazine.objects.all().delete()
User.objects.all().delete()
Subscribe.objects.all().delete()
Task.objects.all().delete()
Order.objects.all().delete()
titles = [
"Reader's Digest USA", 'Harvard Business Review',
'Scientific American', 'Bloomberg Businessweek', 'WSJ', 'Time',
'TE', 'FT', 'TWP', 'The New Yorker'
]
for title in titles:
if len(Magazine.objects.filter(title=title)) > 0:
continue
magazine = Magazine(title=title)
magazine.save()
if len(User.objects.filter(uuid='uuid')) == 0:
user = User(email='xxx',
uuid='uuid',
key='key',
invitor='invitor',
expire_date=localdate())
user.save()
def updateLocation(user_name, longitude, latitude):
try:
user = User.objects.get(user_name=user_name)
except User.DoesNotExist:
user = User(user_name=user_name)
user.longitude = longitude
user.latitude = latitude
user.save()
return
def register(request): #회원가입
if request.method == "GET":
return render(request, 'uuser/register.html')
elif request.method == "POST":
username = request.POST.get('username', None)
password = request.POST.get('password', None)
user = User(username=username, password=make_password(password))
user.save()
return redirect('/')
def register(request: HttpRequest) -> HttpResponse:
agreement = request.data.get('agreement')
if agreement:
username = request.data.get('username')
password = request.data.get('password')
tel = request.data.get('tel')
if username and password and tel:
try:
password = gen_md5_digest(password)
user = User(username=username, password=password, tel=tel)
user.save()
return Response({'code': 30000, 'mesg': '注册成功'})
except DatabaseError:
hint = '注册失败，请尝试更换用户名'
else:
hint = '请输入有效的注册信息'
else:
hint = '请勾选同意网站用户协议及隐私政策'
return Response({'code': 30001, 'mesg': hint})
def regUser(request):
rsp = RegRsp(200, -1)
if smartstring.equals_ingorecase(request.method, "POST"):
regmsg = RegMsg()
regmsg.parse(request.body)
if not hasUser(regmsg.account):
u = User()
u.account = regmsg.account
u.password = regmsg.password
u.token = hashlib.sha1(os.urandom(24)).hexdigest()
u.save()
rsp.Code = 0
rsp.Userid = u.id
return HttpResponse(rsp.toJson())
else:
rsp.Code = 100
rsp.Userid = -1
return HttpResponse(rsp.toJson())
else:
return HttpResponse(rsp.toJson())
def register(request: HttpRequest) -> HttpResponse:
"""注册"""
hint = ''
if request.method == 'POST':
agreement = request.POST.get('agreement')
if agreement == 'on':
code_from_user = request.POST.get('mobilecode','0')
code_from_sess = request.session.get('mobilecode','1')
if code_from_user == code_from_sess:
username = request.POST.get('username')
password = request.POST.get('password')
tel = request.POST.get('tel')
if check_username(username):
if check_password(password):
if tel:
user = User()
user.username = username
user.password = gen_md5_digest(password)
user.tel = tel
try:
user.save()
except DatabaseError:
hint = '用户或手机号已被注册，请尝试其他的用户名或手机号'
else:
hint = '注册成功,请登录'
return redirect(f'/login/?hint={hint}')
else:
hint = '电话号码错误'
else:
hint = '密码少于8位'
else:
hint = '用户名少于6位数'
else:
hint = '请输入正确的手机验证码'
else:
hint = '请勾选同意网站用户协议及隐私政策'
return render(request, 'register.html', {'hint': hint})
def register(request):
"""用户注册"""
username, tel, hint = '', '', ''
if request.method == 'POST':
agreement = request.data.get('agreement')
if agreement:
username = request.data.get('username', '').strip()
password = request.data.get('password', '')
tel = request.data.get('tel', '').strip()
redis_cli = get_redis_connection()
code_from_user = request.data.get('mobilecode', '0')
code_from_redis = redis_cli.get(f'mobile:valid:{tel}').decode()
if code_from_user == code_from_redis:
if check_username(username) and check_password(
password) and check_tel(tel):
password = gen_sha256_digest(password)
try:
user = User(username=username,
password=password,
tel=tel)
user.last_visit = timezone.now()
user.save()
# 验证码只能消费一次，注册成功用过的验证码立即失效
redis_cli.delete(f'mobile:valid:{tel}')
hint = '注册成功，请登录'
# return redirect(f'/login/?hint={hint}')
return Response({'code': 30000, 'mesg': hint})
except DatabaseError:
hint = '注册失败，用户名或手机号已被使用'
else:
hint = '请输入有效的注册信息'
else:
hint = '请输入正确的手机验证码'
else:
hint = '请勾选同意网站用户协议及隐私政策'
# return render(request, 'register.html', {'hint': hint, 'username': username, 'tel': tel})
return Response({'code': 30001, 'mesg': hint})
def register_new_user(self, username: str, password: str, email: str,
country_name: str, link_country_flag: str):
country = SystemService().create_default_country(
country_name, link_country_flag)
try:
country.save()
except Exception as error:
print(error)
return False
user = User(username=username,
password=sha256(password.encode()).hexdigest(),
email=email,
country=country.pk)
try:
user.save()
except Exception as error:
print(error)
country.delete()
return False
if GlobalSettings.objects().first().email_notification:
SystemService().send_notification([email], EmailEvent.REGISTRATION,
username, country_name,
str(user.pk), link_country_flag)
return True
def newuser(request):
user = User(name='tianyi', age=32)
user.save()
return render(request, 'polls/hello.html', {'dt': user})
def add_user(request):
test1 = User(user_name='呵呵哒', psw='55555')
test1.save()
return HttpResponse("数据库polls_user添加name成功！看去看看吧")
def add_user(request):
user = User(100, 'Xiapengyu', 30, 'PM', '17688556401')
user.save()
return HttpResponse('添加用户成功')
def update(request, timestamp):
print 'Hello'
json_data = request.read()
data = simplejson.loads(json_data)
current_date = datetime.datetime.now()
current_timestamp = long(time.mktime(current_date.timetuple()))
print data['timestamp']
###Handle Add Operation
#Condition: add if only if KTP is not exist
for a in data['add']['user']:
try:
temp = User.objects.get(ktp=a['local_ktp'])
except User.DoesNotExist:
u = User(
ktp=a['local_ktp'],
username=a['username'],
password=a['password'],
name=a['name'],
address=a['address'],
email=a['email'],
phone=a['phone'],
description=a['description'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
u.save()
print 'saving user', u.ktp
#Condition: add if only if KTP is not exist
for a in data['add']['patient']:
try:
temp = Patient.objects.get(ktp=a['local_ktp'])
except Patient.DoesNotExist:
p = Patient(
ktp=a['local_ktp'],
name=a['name'],
address=a['address'],
phone=a['phone'],
birthdate=a['birthdate'],
filename=a['filename'],
description=a['description'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
p.save()
print 'saving patient', p.ktp
#Condition: add if only if Patient's KTP+Pregnancy Number is not exist
for a in data['add']['pregnancy']:
try:
temp = Pregnancy.objects.get(
patient__ktp=a['local_patient_id'],
pregnancy_number=a['local_pregnancy_number'])
except Pregnancy.DoesNotExist:
patient_temp = Patient.objects.get(ktp=a['local_patient_id'])
p = Pregnancy(
patient=patient_temp,
pregnancy_number=a['local_pregnancy_number'],
is_finish=a['is_finish'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
p.save()
print 'saving pregnancy', p.patient.ktp, p.pregnancy_number
#Condition: Add if only if no doctor with identical ktp or id
for a in data['add']['doctor']:
temp = Doctor.objects.filter(
Q(user__ktp=a['local_ktp']) | Q(doctor_id=a['doctor_id']))
if len(temp) < 1:
u = User.objects.get(ktp=a['local_ktp'])
d = Doctor(
user=u,
doctor_id=a['doctor_id'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
d.save()
print 'saving doctor', d.user.ktp, d.doctor_id
#Condition: Add if only if no identical clinic id exist
for a in data['add']['clinic']:
try:
temp = Clinic.objects.get(clinic_id=a['local_clinic_id'])
except Clinic.DoesNotExist:
c = Clinic(
clinic_id=a['local_clinic_id'],
name=a['name'],
address=a['address'],
city=a['city'],
province=a['province'],
phone=a['phone'],
description=a['description'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
c.save()
print 'saving clinic', c.clinic_id
#Condition: Add if only if no officer with identical ktp or id
for a in data['add']['officer']:
temp = Officer.objects.filter(
Q(user__ktp=a['local_ktp']) | Q(officer_id=a['officer_id']))
if len(temp) == 0:
u = User.objects.get(ktp=a['local_ktp'])
o = Officer(
user=u,
officer_id=a['officer_id'],
clinic_id=a['local_clinic_id'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
o.save()
print 'saving officer', o.user.ktp, o.officer_id
photo_confirmation = []
#Condition: Add as long as KTP + Pregnancy exist. Global photo number may be differ
for a in data['add']['photo']:
try:
temp = Pregnancy.objects.get(
patient__ktp=a['local_ktp'],
pregnancy_number=a['local_pregnancy_number'])
o = Officer.objects.get(user__ktp=a['local_officer_ktp'])
last_objects = Photo.objects.filter(
pregnancy__pregnancy_id=temp.pregnancy_id).aggregate(
Max('photo_number'))
last_number = last_objects['photo_number__max']
if last_number is None:
last_number = 1
p = Photo(
pregnancy=temp,
officer=o,
photo_number=last_number + 1,
analyze_timestamp=a['analyze_timestamp'],
filename=a['filename'],
x=a['x'],
y=a['y'],
a=a['a'],
b=a['b'],
tetha=a['tetha'],
scale=a['scale'],
method=a['method'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
p.save()
photo_confirmation.append({
'local_number':
a['local_photo_number'],
'ktp':
a['local_ktp'],
'pregnancy_number':
a['local_pregnancy_number'],
'global_number':
p.photo_number
})
print 'saving photo', p.pregnancy.patient.ktp, p.pregnancy.pregnancy_number, p.photo_number
except (Pregnancy.DoesNotExist, Officer.DoesNotExist):
print 'Pregnancy, photo, Officer not exist'
#Condition: Add if only if clinic and patient exist, no existing serve, the server_id may vary
for a in data['add']['serve']:
try:
temp = Serve.objects.get(clinic__clinic_id=a['local_clinic_id'],
patient__ktp=a['local_ktp'])
except Serve.DoesNotExist:
try:
c = Clinic.objects.get(clinic_id=a['local_clinic_id'])
p = Patient.objects.get(ktp=a['local_ktp'])
s = Serve(
clinic=c,
patient=p,
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
s.save()
print 'saving serve', p.ktp, c.clinic_id
except (Clinic.DoesNotExist, Patient.DoesNotExist) as e:
print 'Clinic, Patient not exist'
#Condition: Add if only if clinic and doctor exist, no existing works0n
print data['add']['works_on']
for a in data['add']['works_on']:
try:
temp = Works_On.objects.get(clinic__clinic_id=a['local_clinic_id'],
doctor__user__ktp=a['local_ktp'])
except Works_On.DoesNotExist:
try:
c = Clinic.objects.get(clinic_id=a['local_clinic_id'])
d = Doctor.objects.get(user__ktp=a['local_ktp'])
w = Works_On(
clinic=c,
doctor=d,
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
w.save()
print 'saving works_on', d.user.ktp, c.clinic_id
except (Clinic.DoesNotExist, Doctor.DoesNotExist) as e:
print 'Clinic, Doctor not exist'
#Condition: Add if only if photo and doctor exist, no existing Validation
for a in data['add']['validation']:
try:
current_photo_number = a['photo_number']
if current_photo_number == -1:
for ii in photo_confirmation:
if ii['local_number'] == a['local_photo_number'] and ii[
'ktp'] == a['local_patient_ktp'] and ii[
'pregnancy_number'] == a[
'local_pregnancy_number']:
current_photo_number = ii['global_number']
break
if current_photo_number == -1:
continue
temp = Validation.objects.get(
doctor__user__ktp=a['local_doctor_ktp'],
photo__photo_number=current_photo_number,
photo__pregnancy__pregnancy_number=a['local_pregnancy_number'],
photo__pregnancy__patient__ktp=a['local_patient_ktp'])
except Validation.DoesNotExist:
try:
if current_photo_number != -1:
p = Photo.objects.get(
photo_number=current_photo_number,
pregnancy__pregnancy_number=a[
'local_pregnancy_number'],
pregnancy__patient__ktp=a['local_patient_ktp'])
d = Doctor.objects.get(user__ktp=a['local_doctor_ktp'])
v = Validation(
doctor=d,
photo=p,
x=a['x'],
y=a['y'],
a=a['a'],
b=a['b'],
tetha=a['tetha'],
has_seen=a['has_seen'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
v.save()
print 'saving validation', d.user.ktp, p.pregnancy.patient.ktp, p.pregnancy.pregnancy_number, p.photo_number
except (Photo.DoesNotExist, Doctor.DoesNotExist) as e:
print 'Photo, Doctor not exist'
comment_confirmation = []
#Condition: Add as long as KTP + Pregnancy exist. Global photo number may be differ
for a in data['add']['comment']:
try:
d = Doctor.objects.get(user__ktp=a['local_doctor_ktp'])
o = Officer.objects.get(user__ktp=a['local_officer_ktp'])
p = Patient.objects.get(ktp=a['local_patient_ktp'])
last_objects = Comment.objects.filter(
patient__ktp=p.ktp).aggregate(Max('comment_number'))
last_number = last_objects['comment_number__max']
if last_number is None:
last_number = 1
c = Comment(
doctor=d,
officer=o,
patient=p,
comment_number=last_number + 1,
from_doctor=a['from_doctor'],
content=a['content'],
has_seen=a['has_seen'],
is_active=a['is_active'],
modify_timestamp=a['modify_timestamp'],
create_timestamp=a['create_timestamp'],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
c.save()
comment_confirmation.append({
'local_number':
a['local_comment_number'],
'ktp':
a['local_patient_ktp'],
'global_number':
c.comment_number
})
print 'saving comment', p.ktp, c.comment_number
except (Doctor.DoesNotExist, Officer.DoesNotExist,
Patient.DoesNotExist):
print 'Doctor, officer, patient not exist'
#update user, exceptional: username, server_create_timestamp
for a in data['update']['user']:
try:
temp = User.objects.get(ktp=a['ktp'])
temp.password = a['password']
temp.name = a['name']
temp.address = a['address']
temp.email = a['email']
temp.phone = a['phone']
temp.description = a['description']
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'user updated', a['ktp']
except User.DoesNotExist:
print 'user not exist', a['ktp']
#update patient, exceptional: ktp, server_create_timestamp
for a in data['update']['patient']:
try:
temp = Patient.objects.get(ktp=a['ktp'])
name = a['name'],
temp.address = a['address'],
temp.phone = a['phone'],
temp.birthdate = a['birthdate'],
temp.description = a['description'],
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'patient updated', a['ktp']
except Patient.DoesNotExist:
print 'patient not exist', a['ktp']
#Update pregnancy, except patient pregnancy_number server_create_timestamp
for a in data['update']['pregnancy']:
try:
temp = Pregnancy.objects.get(
patient__ktp=a['patient_id'],
pregnancy_number=a['pregnancy_number'])
temp.is_finish = a['is_finish']
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'pregnancy updated', a['patient_id'], a['pregnancy_number']
except Pregnancy.DoesNotExist:
print 'pregnancy not exist', a['patient_id'], a['pregnancy_number']
#Update doctor, except user_ktp doctor_id server_arrival_timestamp
for a in data['update']['doctor']:
try:
temp = Doctor.objects.get(user__ktp=a['ktp'])
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'doctor updated ', a['ktp']
except Doctor.DoesNotExist:
print 'doctor not exist', a['ktp']
#Update clinic, except clinic_id server_arrival_timestamp
for a in data['update']['clinic']:
try:
temp = Clinic.objects.get(clinic_id=a['clinic_id'])
temp.name = a['name']
temp.address = a['address']
temp.city = a['city']
temp.province = a['province']
temp.phone = a['phone']
temp.description = a['description']
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'clinic updated ', a['clinic_id']
except Clinic.DoesNotExist:
print 'clinic not exist', a['clinic_id']
#Update officer, except user_ktp officer_id clinic_id server_arrival_timestamp
for a in data['update']['officer']:
try:
temp = Officer.objects.get(user__ktp=a['ktp'])
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'officer updated ', a['ktp']
except Officer.DoesNotExist:
print 'officer not exist', a['ktp']
#Update Photo, except patient_ktp, pregnancy_number, photo_number, officer_ktp server_arrival_timestamp
for a in data['update']['photo']:
try:
temp = Photo.objects.get(
pregnancy__patient__ktp=a['ktp'],
pregnancy__pregnancy_number=a['pregnancy_number'],
photo_number=a['photo_number'])
temp.analyze_timestamp = a['analyze_timestamp']
temp.filename = a['filename']
temp.x = a['x']
temp.y = a['y']
temp.a = a['a']
temp.b = a['b']
temp.tetha = a['tetha']
temp.scale = a['scale']
temp.method = a['method']
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'Photo updated ', a['ktp'], a['pregnancy_number'], a[
'photo_number']
except Photo.DoesNotExist:
print 'Photo not exist ', a['ktp'], a['pregnancy_number'], a[
'photo_number']
#Update Serve, except clinic_id patient_ktp server_arrival_timestamp
for a in data['update']['serve']:
try:
temp = Serve.objects.get(clinic__clinic_id=a['clinic_id'],
patient__ktp=a['ktp'])
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'Serve updated ', a['clinic_id'], a['ktp']
except Serve.DoesNotExist:
print 'Serve not exist ', a['clinic_id'], a['ktp']
#Update WorksOn, except clinic_id doctor_ktp server_arrival_timestamp
for a in data['update']['works_on']:
try:
temp = Works_On.objects.get(clinic__clinic_id=a['clinic_id'],
doctor__user__ktp=a['ktp'])
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'WorksOn updated ', a['clinic_id'], a['ktp']
except Works_On.DoesNotExist:
print 'WorksOn not exist ', a['clinic_id'], a['ktp']
#Update Validation, except photo_number, pregnancy_number, patient_ktp server_arrival_timestamp
for a in data['update']['validation']:
try:
temp = Validation.objects.get(
doctor__user__ktp=a['doctor_ktp'],
photo__photo_number=a['photo_number'],
photo__pregnancy__pregnancy_number=a['pregnancy_number'],
photo__pregnancy__patient__ktp=a['patient_ktp'])
temp.x = a['x']
temp.y = a['y']
temp.a = a['a']
temp.b = a['b']
temp.tetha = a['tetha']
temp.has_seen = a['has_seen']
temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'Validation updated ', a['doctor_ktp'], a['photo_number'], a[
'pregnancy_number'], a['patient_ktp']
except Validation.DoesNotExist:
print 'Validation not exist ', a['doctor_ktp'], a[
'photo_number'], a['pregnancy_number'], a['patient_ktp']
#Update Validation, except officer doctor comment_number patient_ktp server_arrival_timestamp
for a in data['update']['comment']:
try:
temp = Comment.objects.get(patient__ktp=a['patient_ktp'],
comment_number=a['comment_number'])
temp.from_doctor = a['from_doctor']
temp.content = a['content']
temp.has_seen = a['has_seen']
temp.temp.is_active = a['is_active']
temp.modify_timestamp = a['modify_timestamp']
temp.create_timestamp = a['create_timestamp']
temp.server_modify_timestamp = current_timestamp
temp.save()
print 'Validation updated ', a['patient_ktp'], a['comment_number']
except Comment.DoesNotExist:
print 'Validation updated ', a['patient_ktp'], a['comment_number']
# confirm_doctor = []
# confirm_json = {'user':confirm_user,
# 'doctor':confirm_doctor}
###Cari new Addition
#table user
new_user_json = []
new_users = User.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for user in new_users:
new_user_json.append(user.get_json())
#table doctor
new_doctor_json = []
new_doctors = Doctor.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for doctor in new_doctors:
new_doctor_json.append(doctor.get_json())
#table clinic
new_clinic_json = []
new_clinics = Clinic.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for clinic in new_clinics:
new_clinic_json.append(clinic.get_json())
#table officer
new_officer_json = []
new_officers = Officer.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for officer in new_officers:
new_officer_json.append(officer.get_json())
#table patient
new_patient_json = []
new_patients = Patient.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for patient in new_patients:
new_patient_json.append(patient.get_json())
#table pregnancy
new_pregnancy_json = []
new_pregnancies = Clinic.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for pregnancy in new_pregnancies:
new_pregnancy_json.append(pregnancy.get_json())
#table photo
new_photo_json = []
new_photos = Photo.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for photo in new_photos:
new_photo_json.append(photo.get_json())
#table serve
new_serve_json = []
new_serves = Serve.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for serve in new_serves:
new_serve_json.append(serve.get_json())
#table works_on
new_workson_json = []
new_worksons = Works_On.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for workson in new_worksons:
new_workson_json.append(workson.get_json())
#table validation
new_validation_json = []
new_validations = Validation.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for validation in new_validations:
new_validation_json.append(validation.get_json())
#table comment
new_comment_json = []
new_comments = Comment.objects.all().filter(
server_arrival_timestamp__gt=timestamp, is_active=True)
for comment in new_comments:
new_comment_json.append(comment.get_json())
#table user
update_user_json = []
update_users = User.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for user in update_users:
update_user_json.append(user.get_json())
#table doctor
update_doctor_json = []
update_doctors = Doctor.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for doctor in update_doctors:
update_doctor_json.append(doctor.get_json())
#table clinic
update_clinic_json = []
update_clinics = Clinic.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for clinic in update_clinics:
update_clinic_json.append(clinic.get_json())
#table officer
update_officer_json = []
update_officers = Officer.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for officer in update_officers:
update_officer_json.append(officer.get_json())
#table patient
update_patient_json = []
update_patients = Patient.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for patient in update_patients:
update_patient_json.append(patient.get_json())
#table pregnancy
update_pregnancy_json = []
update_pregnancies = Clinic.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for pregnancy in update_pregnancies:
update_pregnancy_json.append(pregnancy.get_json())
#table photo
update_photo_json = []
update_photos = Photo.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for photo in update_photos:
update_photo_json.append(photo.get_json())
#table serve
update_serve_json = []
update_serves = Serve.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for serve in update_serves:
update_serve_json.append(serve.get_json())
#table works_on
update_workson_json = []
update_worksons = Works_On.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for workson in update_worksons:
update_workson_json.append(workson.get_json())
#table validation
update_validation_json = []
update_validations = Validation.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for validation in update_validations:
update_validation_json.append(validation.get_json())
#table comment
update_comment_json = []
update_comments = Comment.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp)
| Q(modify_timestamp__gt=timestamp))
for comment in update_comments:
update_comment_json.append(comment.get_json())
return HttpResponse(simplejson.dumps(
{
'add': {
'user': new_user_json,
'doctor': new_doctor_json,
'clinic': new_clinic_json,
'officer': new_officer_json,
'patient': new_patient_json,
'pregnancy': new_pregnancy_json,
'photo': new_photo_json,
'serve': new_serve_json,
'works_on': new_workson_json,
'validation': new_validation_json,
'comment': new_comment_json,
},
'update': {
'user': update_user_json,
'doctor': update_doctor_json,
'clinic': update_clinic_json,
'officer': update_officer_json,
'patient': update_patient_json,
'pregnancy': update_pregnancy_json,
'photo': update_photo_json,
'serve': update_serve_json,
'works_on': update_workson_json,
'validation': update_validation_json,
'comment': update_comment_json,
},
'confirm_add': {
'photo': photo_confirmation,
'comment': comment_confirmation,
},
},
indent=4),
mimetype="application/json")
from polls.models import User, Chiller user = User(username="******", password="******") user.save()
from polls.models import Team, User, Progress
#create account
user_email = ""
hashed_pass = ""
user_name = ""
new_account = User(email=user_email,
hashed_password=hashed_pass,
name=user_name)
new_account.save()
#create team
t_name = ""
t_leader = ""
new_team = Team(leader=t_leader, team_name=t_name)
new_team.save()
#join team
user_name = ""
account = User.objects.filter(name=user_name)
t_name = ""
team = Team.objects.filter(team_name=t_name)
t_id = team.team_id
account.team_id = t_id
account.save()
if (team.member_2 == NULL):
def update(request, timestamp):
print "Hello"
json_data = request.read()
data = simplejson.loads(json_data)
current_date = datetime.datetime.now()
current_timestamp = long(time.mktime(current_date.timetuple()))
print data["timestamp"]
###Handle Add Operation
# Condition: add if only if KTP is not exist
for a in data["add"]["user"]:
try:
temp = User.objects.get(ktp=a["local_ktp"])
except User.DoesNotExist:
u = User(
ktp=a["local_ktp"],
username=a["username"],
password=a["password"],
name=a["name"],
address=a["address"],
email=a["email"],
phone=a["phone"],
description=a["description"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
u.save()
print "saving user", u.ktp
# Condition: add if only if KTP is not exist
for a in data["add"]["patient"]:
try:
temp = Patient.objects.get(ktp=a["local_ktp"])
except Patient.DoesNotExist:
p = Patient(
ktp=a["local_ktp"],
name=a["name"],
address=a["address"],
phone=a["phone"],
birthdate=a["birthdate"],
filename=a["filename"],
description=a["description"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
p.save()
print "saving patient", p.ktp
# Condition: add if only if Patient's KTP+Pregnancy Number is not exist
for a in data["add"]["pregnancy"]:
try:
temp = Pregnancy.objects.get(
patient__ktp=a["local_patient_id"], pregnancy_number=a["local_pregnancy_number"]
)
except Pregnancy.DoesNotExist:
patient_temp = Patient.objects.get(ktp=a["local_patient_id"])
p = Pregnancy(
patient=patient_temp,
pregnancy_number=a["local_pregnancy_number"],
is_finish=a["is_finish"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
p.save()
print "saving pregnancy", p.patient.ktp, p.pregnancy_number
# Condition: Add if only if no doctor with identical ktp or id
for a in data["add"]["doctor"]:
temp = Doctor.objects.filter(Q(user__ktp=a["local_ktp"]) | Q(doctor_id=a["doctor_id"]))
if len(temp) < 1:
u = User.objects.get(ktp=a["local_ktp"])
d = Doctor(
user=u,
doctor_id=a["doctor_id"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
d.save()
print "saving doctor", d.user.ktp, d.doctor_id
# Condition: Add if only if no identical clinic id exist
for a in data["add"]["clinic"]:
try:
temp = Clinic.objects.get(clinic_id=a["local_clinic_id"])
except Clinic.DoesNotExist:
c = Clinic(
clinic_id=a["local_clinic_id"],
name=a["name"],
address=a["address"],
city=a["city"],
province=a["province"],
phone=a["phone"],
description=a["description"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
c.save()
print "saving clinic", c.clinic_id
# Condition: Add if only if no officer with identical ktp or id
for a in data["add"]["officer"]:
temp = Officer.objects.filter(Q(user__ktp=a["local_ktp"]) | Q(officer_id=a["officer_id"]))
if len(temp) == 0:
u = User.objects.get(ktp=a["local_ktp"])
o = Officer(
user=u,
officer_id=a["officer_id"],
clinic_id=a["local_clinic_id"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
o.save()
print "saving officer", o.user.ktp, o.officer_id
photo_confirmation = []
# Condition: Add as long as KTP + Pregnancy exist. Global photo number may be differ
for a in data["add"]["photo"]:
try:
temp = Pregnancy.objects.get(patient__ktp=a["local_ktp"], pregnancy_number=a["local_pregnancy_number"])
o = Officer.objects.get(user__ktp=a["local_officer_ktp"])
last_objects = Photo.objects.filter(pregnancy__pregnancy_id=temp.pregnancy_id).aggregate(
Max("photo_number")
)
last_number = last_objects["photo_number__max"]
if last_number is None:
last_number = 1
p = Photo(
pregnancy=temp,
officer=o,
photo_number=last_number + 1,
analyze_timestamp=a["analyze_timestamp"],
filename=a["filename"],
x=a["x"],
y=a["y"],
a=a["a"],
b=a["b"],
tetha=a["tetha"],
scale=a["scale"],
method=a["method"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
p.save()
photo_confirmation.append(
{
"local_number": a["local_photo_number"],
"ktp": a["local_ktp"],
"pregnancy_number": a["local_pregnancy_number"],
"global_number": p.photo_number,
}
)
print "saving photo", p.pregnancy.patient.ktp, p.pregnancy.pregnancy_number, p.photo_number
except (Pregnancy.DoesNotExist, Officer.DoesNotExist):
print "Pregnancy, photo, Officer not exist"
# Condition: Add if only if clinic and patient exist, no existing serve, the server_id may vary
for a in data["add"]["serve"]:
try:
temp = Serve.objects.get(clinic__clinic_id=a["local_clinic_id"], patient__ktp=a["local_ktp"])
except Serve.DoesNotExist:
try:
c = Clinic.objects.get(clinic_id=a["local_clinic_id"])
p = Patient.objects.get(ktp=a["local_ktp"])
s = Serve(
clinic=c,
patient=p,
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
s.save()
print "saving serve", p.ktp, c.clinic_id
except (Clinic.DoesNotExist, Patient.DoesNotExist) as e:
print "Clinic, Patient not exist"
# Condition: Add if only if clinic and doctor exist, no existing works0n
print data["add"]["works_on"]
for a in data["add"]["works_on"]:
try:
temp = Works_On.objects.get(clinic__clinic_id=a["local_clinic_id"], doctor__user__ktp=a["local_ktp"])
except Works_On.DoesNotExist:
try:
c = Clinic.objects.get(clinic_id=a["local_clinic_id"])
d = Doctor.objects.get(user__ktp=a["local_ktp"])
w = Works_On(
clinic=c,
doctor=d,
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
w.save()
print "saving works_on", d.user.ktp, c.clinic_id
except (Clinic.DoesNotExist, Doctor.DoesNotExist) as e:
print "Clinic, Doctor not exist"
# Condition: Add if only if photo and doctor exist, no existing Validation
for a in data["add"]["validation"]:
try:
current_photo_number = a["photo_number"]
if current_photo_number == -1:
for ii in photo_confirmation:
if (
ii["local_number"] == a["local_photo_number"]
and ii["ktp"] == a["local_patient_ktp"]
and ii["pregnancy_number"] == a["local_pregnancy_number"]
):
current_photo_number = ii["global_number"]
break
if current_photo_number == -1:
continue
temp = Validation.objects.get(
doctor__user__ktp=a["local_doctor_ktp"],
photo__photo_number=current_photo_number,
photo__pregnancy__pregnancy_number=a["local_pregnancy_number"],
photo__pregnancy__patient__ktp=a["local_patient_ktp"],
)
except Validation.DoesNotExist:
try:
if current_photo_number != -1:
p = Photo.objects.get(
photo_number=current_photo_number,
pregnancy__pregnancy_number=a["local_pregnancy_number"],
pregnancy__patient__ktp=a["local_patient_ktp"],
)
d = Doctor.objects.get(user__ktp=a["local_doctor_ktp"])
v = Validation(
doctor=d,
photo=p,
x=a["x"],
y=a["y"],
a=a["a"],
b=a["b"],
tetha=a["tetha"],
has_seen=a["has_seen"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
v.save()
print "saving validation", d.user.ktp, p.pregnancy.patient.ktp, p.pregnancy.pregnancy_number, p.photo_number
except (Photo.DoesNotExist, Doctor.DoesNotExist) as e:
print "Photo, Doctor not exist"
comment_confirmation = []
# Condition: Add as long as KTP + Pregnancy exist. Global photo number may be differ
for a in data["add"]["comment"]:
try:
d = Doctor.objects.get(user__ktp=a["local_doctor_ktp"])
o = Officer.objects.get(user__ktp=a["local_officer_ktp"])
p = Patient.objects.get(ktp=a["local_patient_ktp"])
last_objects = Comment.objects.filter(patient__ktp=p.ktp).aggregate(Max("comment_number"))
last_number = last_objects["comment_number__max"]
if last_number is None:
last_number = 1
c = Comment(
doctor=d,
officer=o,
patient=p,
comment_number=last_number + 1,
from_doctor=a["from_doctor"],
content=a["content"],
has_seen=a["has_seen"],
is_active=a["is_active"],
modify_timestamp=a["modify_timestamp"],
create_timestamp=a["create_timestamp"],
server_arrival_timestamp=current_timestamp,
server_modify_timestamp=current_timestamp,
)
c.save()
comment_confirmation.append(
{
"local_number": a["local_comment_number"],
"ktp": a["local_patient_ktp"],
"global_number": c.comment_number,
}
)
print "saving comment", p.ktp, c.comment_number
except (Doctor.DoesNotExist, Officer.DoesNotExist, Patient.DoesNotExist):
print "Doctor, officer, patient not exist"
# update user, exceptional: username, server_create_timestamp
for a in data["update"]["user"]:
try:
temp = User.objects.get(ktp=a["ktp"])
temp.password = a["password"]
temp.name = a["name"]
temp.address = a["address"]
temp.email = a["email"]
temp.phone = a["phone"]
temp.description = a["description"]
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "user updated", a["ktp"]
except User.DoesNotExist:
print "user not exist", a["ktp"]
# update patient, exceptional: ktp, server_create_timestamp
for a in data["update"]["patient"]:
try:
temp = Patient.objects.get(ktp=a["ktp"])
name = (a["name"],)
temp.address = (a["address"],)
temp.phone = (a["phone"],)
temp.birthdate = (a["birthdate"],)
temp.description = (a["description"],)
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "patient updated", a["ktp"]
except Patient.DoesNotExist:
print "patient not exist", a["ktp"]
# Update pregnancy, except patient pregnancy_number server_create_timestamp
for a in data["update"]["pregnancy"]:
try:
temp = Pregnancy.objects.get(patient__ktp=a["patient_id"], pregnancy_number=a["pregnancy_number"])
temp.is_finish = a["is_finish"]
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "pregnancy updated", a["patient_id"], a["pregnancy_number"]
except Pregnancy.DoesNotExist:
print "pregnancy not exist", a["patient_id"], a["pregnancy_number"]
# Update doctor, except user_ktp doctor_id server_arrival_timestamp
for a in data["update"]["doctor"]:
try:
temp = Doctor.objects.get(user__ktp=a["ktp"])
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "doctor updated ", a["ktp"]
except Doctor.DoesNotExist:
print "doctor not exist", a["ktp"]
# Update clinic, except clinic_id server_arrival_timestamp
for a in data["update"]["clinic"]:
try:
temp = Clinic.objects.get(clinic_id=a["clinic_id"])
temp.name = a["name"]
temp.address = a["address"]
temp.city = a["city"]
temp.province = a["province"]
temp.phone = a["phone"]
temp.description = a["description"]
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "clinic updated ", a["clinic_id"]
except Clinic.DoesNotExist:
print "clinic not exist", a["clinic_id"]
# Update officer, except user_ktp officer_id clinic_id server_arrival_timestamp
for a in data["update"]["officer"]:
try:
temp = Officer.objects.get(user__ktp=a["ktp"])
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "officer updated ", a["ktp"]
except Officer.DoesNotExist:
print "officer not exist", a["ktp"]
# Update Photo, except patient_ktp, pregnancy_number, photo_number, officer_ktp server_arrival_timestamp
for a in data["update"]["photo"]:
try:
temp = Photo.objects.get(
pregnancy__patient__ktp=a["ktp"],
pregnancy__pregnancy_number=a["pregnancy_number"],
photo_number=a["photo_number"],
)
temp.analyze_timestamp = a["analyze_timestamp"]
temp.filename = a["filename"]
temp.x = a["x"]
temp.y = a["y"]
temp.a = a["a"]
temp.b = a["b"]
temp.tetha = a["tetha"]
temp.scale = a["scale"]
temp.method = a["method"]
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "Photo updated ", a["ktp"], a["pregnancy_number"], a["photo_number"]
except Photo.DoesNotExist:
print "Photo not exist ", a["ktp"], a["pregnancy_number"], a["photo_number"]
# Update Serve, except clinic_id patient_ktp server_arrival_timestamp
for a in data["update"]["serve"]:
try:
temp = Serve.objects.get(clinic__clinic_id=a["clinic_id"], patient__ktp=a["ktp"])
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "Serve updated ", a["clinic_id"], a["ktp"]
except Serve.DoesNotExist:
print "Serve not exist ", a["clinic_id"], a["ktp"]
# Update WorksOn, except clinic_id doctor_ktp server_arrival_timestamp
for a in data["update"]["works_on"]:
try:
temp = Works_On.objects.get(clinic__clinic_id=a["clinic_id"], doctor__user__ktp=a["ktp"])
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "WorksOn updated ", a["clinic_id"], a["ktp"]
except Works_On.DoesNotExist:
print "WorksOn not exist ", a["clinic_id"], a["ktp"]
# Update Validation, except photo_number, pregnancy_number, patient_ktp server_arrival_timestamp
for a in data["update"]["validation"]:
try:
temp = Validation.objects.get(
doctor__user__ktp=a["doctor_ktp"],
photo__photo_number=a["photo_number"],
photo__pregnancy__pregnancy_number=a["pregnancy_number"],
photo__pregnancy__patient__ktp=a["patient_ktp"],
)
temp.x = a["x"]
temp.y = a["y"]
temp.a = a["a"]
temp.b = a["b"]
temp.tetha = a["tetha"]
temp.has_seen = a["has_seen"]
temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "Validation updated ", a["doctor_ktp"], a["photo_number"], a["pregnancy_number"], a["patient_ktp"]
except Validation.DoesNotExist:
print "Validation not exist ", a["doctor_ktp"], a["photo_number"], a["pregnancy_number"], a["patient_ktp"]
# Update Validation, except officer doctor comment_number patient_ktp server_arrival_timestamp
for a in data["update"]["comment"]:
try:
temp = Comment.objects.get(patient__ktp=a["patient_ktp"], comment_number=a["comment_number"])
temp.from_doctor = a["from_doctor"]
temp.content = a["content"]
temp.has_seen = a["has_seen"]
temp.temp.is_active = a["is_active"]
temp.modify_timestamp = a["modify_timestamp"]
temp.create_timestamp = a["create_timestamp"]
temp.server_modify_timestamp = current_timestamp
temp.save()
print "Validation updated ", a["patient_ktp"], a["comment_number"]
except Comment.DoesNotExist:
print "Validation updated ", a["patient_ktp"], a["comment_number"]
# confirm_doctor = []
# confirm_json = {'user':confirm_user,
# 'doctor':confirm_doctor}
###Cari new Addition
# table user
new_user_json = []
new_users = User.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for user in new_users:
new_user_json.append(user.get_json())
# table doctor
new_doctor_json = []
new_doctors = Doctor.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for doctor in new_doctors:
new_doctor_json.append(doctor.get_json())
# table clinic
new_clinic_json = []
new_clinics = Clinic.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for clinic in new_clinics:
new_clinic_json.append(clinic.get_json())
# table officer
new_officer_json = []
new_officers = Officer.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for officer in new_officers:
new_officer_json.append(officer.get_json())
# table patient
new_patient_json = []
new_patients = Patient.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for patient in new_patients:
new_patient_json.append(patient.get_json())
# table pregnancy
new_pregnancy_json = []
new_pregnancies = Clinic.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for pregnancy in new_pregnancies:
new_pregnancy_json.append(pregnancy.get_json())
# table photo
new_photo_json = []
new_photos = Photo.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for photo in new_photos:
new_photo_json.append(photo.get_json())
# table serve
new_serve_json = []
new_serves = Serve.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for serve in new_serves:
new_serve_json.append(serve.get_json())
# table works_on
new_workson_json = []
new_worksons = Works_On.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for workson in new_worksons:
new_workson_json.append(workson.get_json())
# table validation
new_validation_json = []
new_validations = Validation.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for validation in new_validations:
new_validation_json.append(validation.get_json())
# table comment
new_comment_json = []
new_comments = Comment.objects.all().filter(server_arrival_timestamp__gt=timestamp, is_active=True)
for comment in new_comments:
new_comment_json.append(comment.get_json())
# table user
update_user_json = []
update_users = User.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for user in update_users:
update_user_json.append(user.get_json())
# table doctor
update_doctor_json = []
update_doctors = Doctor.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for doctor in update_doctors:
update_doctor_json.append(doctor.get_json())
# table clinic
update_clinic_json = []
update_clinics = Clinic.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for clinic in update_clinics:
update_clinic_json.append(clinic.get_json())
# table officer
update_officer_json = []
update_officers = Officer.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for officer in update_officers:
update_officer_json.append(officer.get_json())
# table patient
update_patient_json = []
update_patients = Patient.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for patient in update_patients:
update_patient_json.append(patient.get_json())
# table pregnancy
update_pregnancy_json = []
update_pregnancies = Clinic.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for pregnancy in update_pregnancies:
update_pregnancy_json.append(pregnancy.get_json())
# table photo
update_photo_json = []
update_photos = Photo.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for photo in update_photos:
update_photo_json.append(photo.get_json())
# table serve
update_serve_json = []
update_serves = Serve.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for serve in update_serves:
update_serve_json.append(serve.get_json())
# table works_on
update_workson_json = []
update_worksons = Works_On.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for workson in update_worksons:
update_workson_json.append(workson.get_json())
# table validation
update_validation_json = []
update_validations = Validation.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for validation in update_validations:
update_validation_json.append(validation.get_json())
# table comment
update_comment_json = []
update_comments = Comment.objects.all().filter(
Q(is_active=True) & Q(server_modify_timestamp__gt=timestamp) | Q(modify_timestamp__gt=timestamp)
)
for comment in update_comments:
update_comment_json.append(comment.get_json())
return HttpResponse(
simplejson.dumps(
{
"add": {
"user": new_user_json,
"doctor": new_doctor_json,
"clinic": new_clinic_json,
"officer": new_officer_json,
"patient": new_patient_json,
"pregnancy": new_pregnancy_json,
"photo": new_photo_json,
"serve": new_serve_json,
"works_on": new_workson_json,
"validation": new_validation_json,
"comment": new_comment_json,
},
"update": {
"user": update_user_json,
"doctor": update_doctor_json,
"clinic": update_clinic_json,
"officer": update_officer_json,
"patient": update_patient_json,
"pregnancy": update_pregnancy_json,
"photo": update_photo_json,
"serve": update_serve_json,
"works_on": update_workson_json,
"validation": update_validation_json,
"comment": update_comment_json,
},
"confirm_add": {"photo": photo_confirmation, "comment": comment_confirmation},
},
indent=4,
),
mimetype="application/json",
)
