def scan(request): date = datetime.datetime.now() date = date.strftime("%Y-%m-%d %H:%M:%S") json_obj = api.get_data_json() json_obj1 = api.get_data_json1() arduino = json_obj1["camera_id"] data = json_obj["camera_info"] data1 = json_obj["user_info"]["1"]["id"] data4 = json_obj["app_info"][str(data1)] Number_box = "" RFID = "" for scan1 in data: print(scan1) data2 = json_obj["camera_info"][scan1]["camera_status"] if data2 == "": data3 = json_obj["camera_info"][scan1]["camera_id"] if data3 == arduino: RFID = str(data3) Number_box = scan1 return render(request, 'scan.html', {"Number": Number_box, "RFID": RFID})
def enter_b(request): password1 = request.POST['password1'] password2 = request.POST['password2'] password3 = request.POST['password3'] password4 = request.POST['password4'] password5 = request.POST['password5'] password6 = request.POST['password6'] print("ttttttttttttttttttttttttttttttt") key = str(password1) + str(password2) + str(password3) + str( password4) + str(password5) + str(password6) print(key) json_obj = api.get_data_json() data = json_obj["app_info"] data1 = json_obj["user_info"]["1"]["id"] data3 = json_obj["app_info"][str(data1)]["action"] for data1 in data: data2 = json_obj["app_info"][data1]["random_key"] if str(data2) == str(key): if str(data3) == "": return redirect('/scan') if str(data3) == "borrow": return redirect('/scan_return') messages.info(request, 'รหัสไม่ถูกต้อง') return redirect('/enter')
def Return(request): json_obj = api.get_data_json() data = json_obj["user_info"]["1"]["id"] data1 = json_obj["app_info"][str(data)]["action"] if data1 == "borrow": ran = api.sent_password(str(data)) else: ran = "No borrowing" return render(request, 'return.html', {"random": ran})
def index(request): json_obj = api.get_data_json() data = json_obj["camera_info"] Dis = 0 for i in range(1, 3): s = data[str(i)]["camera_status"] if s == "borrow": Dis += 1 return render(request, 'index.html', {"Dis": Dis})
def done_scan(request): date = datetime.datetime.now() date = date.strftime("%Y-%m-%d %H:%M:%S") json_obj1 = api.get_data_json1() arduino = json_obj1["camera_id"] json_obj = api.get_data_json() data = json_obj["camera_info"] data1 = json_obj["user_info"]["1"]["id"] data4 = json_obj["app_info"][str(data1)]["camera_id"] print("******** Wait RFID *************") con = False G = "" g = "" while not con: G = str(sendata.readline()) for i in G: # print(i) if i.isdigit(): g = G break else: g = "" if g != "": # print(g) con = True g = g[2:-5] print(g) for scan1 in data: data2 = json_obj["camera_info"][scan1]["camera_status"] if data2 == "": data3 = json_obj["camera_info"][scan1]["camera_id"] # if data3 == arduino: if data3 == g: api.update_json("camera_info", str(scan1), "camera_status", "borrow") api.update_json("camera_info", str(scan1), "camera_data", date) api.update_json("app_info", str(data1), "action", "borrow") api.update_json("app_info", str(data1), "camera_id", data3) api.update_json("app_info", str(data1), "datetime", date) if g == "185:75:154:153:241": led_on1() elif g == "172:72:101:163:34": led_on2() return redirect('/complete_borrow') messages.info(request, '***scan please***') return redirect('/scan')
def done_scan_return(request): json_obj1 = api.get_data_json1() arduino = json_obj1["camera_id"] date = datetime.datetime.now() date = date.strftime("%Y-%m-%d %H:%M:%S") json_obj = api.get_data_json() data = json_obj["camera_info"] data1 = json_obj["user_info"]["1"]["id"] data5 = json_obj["app_info"][str(data1)]["camera_id"] data7 = json_obj["app_info"]["61340500048"] data4 = json_obj["app_info"][str(data1)]["camera_id"] print("******** Wait RFID *************") con = False G = "" g = "" while not con: G = str(sendata.readline()) for i in G: # print(i) if i.isdigit(): g = G break else: g = "" if g != "": # print(g) con = True g = g[2:-5] print(g) for scan1 in data: data3 = json_obj["camera_info"][scan1]["camera_id"] # if arduino == data5: if g == data5 == data3: api.update_json("camera_info", str(scan1), "camera_status", "return") api.update_json("camera_info", str(scan1), "camera_data", date) api.update_json("app_info", str(data1), "action", "return") api.update_json("app_info", str(data1), "datetime", date) if g == "185:75:154:153:241": led_off1() elif g == "172:72:101:163:34": led_off2() return redirect('/complete_return') messages.info(request, 'รหัสไม่ถูกต้อง') return redirect('/scan_return')
def test(request): # api.sent_password(str(1)) json_obj = api.get_data_json() data = json_obj["app_info"]["185:75:154:153:241"] # update_sql api.update_json('app_info', "61340500048", "action", '') # update_sql print(data) db = connect_db() cursor = db.cursor() # sql = api.delete_sql("app_info", "id", data) # sql = api.delete_sql("camera_info", "camera_id", data) sql = api.update_sql("camera_info", "camera_id", key, value_json) cursor.execute(sql) db.commit() db.close() return render(request, 'test.html', {"random": data})
def complete_borrow(request): json_obj = api.get_data_json() data = json_obj["camera_info"] data1 = json_obj["user_info"]["1"]["id"] data4 = json_obj["app_info"][str(data1)] data5 = json_obj["app_info"][str(data1)]["camera_id"] db = connect_db() cursor = db.cursor() for check in data: data2 = json_obj["camera_info"][check]["camera_status"] data6 = json_obj["camera_info"][check] if data2 == "borrow": cursor.execute(api.insert_sql("app_info", data4)) cursor.execute(api.insert_sql("camera_info", data6)) db.commit() db.close() return render(request, 'complete_borrow.html', { "user": data1, "id_camera": data5 })
def complete_return(request): json_obj1 = api.get_data_json1() arduino = json_obj1["camera_id"] date = datetime.datetime.now() date = date.strftime("%Y-%m-%d %H:%M:%S") json_obj = api.get_data_json() data = json_obj["camera_info"] data1 = json_obj["user_info"]["1"]["id"] data4 = json_obj["app_info"][str(data1)] data5 = json_obj["app_info"][str(data1)]["camera_id"] data7 = json_obj["app_info"]["61340500048"] data6 = json_obj["app_info"][str(data1)] db = connect_db() cursor = db.cursor() cursor.execute(api.insert_sql("app_info", data6)) for i in range(1, 3): s = data[str(i)] if str(data6["camera_id"]) == s["camera_id"]: print(s) cursor.execute(api.insert_sql("camera_info", s)) api.update_json("camera_info", str(i), "camera_status", "") db.commit() db.close() api.update_json("app_info", str(data1), "action", "") api.update_json("app_info", str(data1), "camera_id", "") api.update_json("app_info", str(data1), "datetime", "") return render(request, 'complete_return.html', { "user": data1, "date": date })
def scan_return(request): json_obj = api.get_data_json() data1 = json_obj["user_info"]["1"]["id"] data4 = json_obj["app_info"][str(data1)]["camera_id"] return render(request, 'scan_return.html', {"RFID": data4})
def borrow(request): json_obj = api.get_data_json() data = json_obj["user_info"]["1"]["id"] ran = api.sent_password(str(data)) return render(request, 'borrow.html', {"random": ran})