def register_office():
data_profile = reader_card()
file_img = data_profile[31]
print(file_img)
#img_profile = os.path.join(app.config['UPLOAD_FOLDER'], file_img)#รูปจากบัตร
img_profile = os.listdir('static/img/temp_img/')
return render_template('register.html',
img_profile=img_profile,
data_profile=data_profile)
import sqlite3
import shutil
from Card_reading import reader_card
data = reader_card()
def create_user_officer(file_id): #move office
file_id = file_id
x = file_id[2]
# print(x[0])
print(x[1:18]) #ID_card
# 6 gender (7 8)name
#print('บ้านเลขที่ ' +x[14] +' ' + x[15]+' ' + x[16]+' ' + x[17]+' ' + x[18]+' ' + x[19]+' ' + x[20]+' ' + x[21]) #address
name_file = x[1:18]
Name_USER = file_id[7] + ' ' + file_id[8]
GENDER = file_id[6]
# address = x[14] +' ' + x[15]+' ' + x[16]+' ' + x[17]+' ' + x[18]+' ' + x[19]+' ' + x[20]+' ' + x[21]
address = file_id[15]
Office = "KMITL" #สมมุติ
file_name = name_file + '.db'
print(file_name)
conn = sqlite3.connect(file_name)
cursor = conn.cursor()
print("create database 0f " + file_name)
# conn.execute('''CREATE TABLE USER
# (ID INT PRIMARY KEY NOT NULL,
# GENDER TEXT NOT NULL,
# NAME TEXT NOT NULL,
# ADRESS TEXT NOT NULL,
# OFFICE TEXT NOT NULL);''')
def success_KMITL():
data_profile = reader_card()
#delete temp_img SIAM-ID txt.file บรรทัดสุดท้าย
return render_template('success_banana.html', data_profile=data_profile)
def success_KMUTMD():
data_profile = reader_card()
return render_template('success_duck.html', data_profile=data_profile)
path_Office_kmitl = 'C:/Users/Tacha/VideoStreamingFlask/Office/kmitl'
path_Office_kmutnb = ''
path_Office_kmutt = ''
path_Excel_kmitl = 'C:/Users/Tacha/VideoStreamingFlask/Excel/kmitl'
path_Excel_kmutnb = ''
path_Excel_kmutt = ''
'''
token = 'Hkf9EI7Ilafe4uinK9Iibud1p8OJVMBz8hOLHTCL0gs'
headers = {'content-type':'application/x-www-form-urlencoded','Authorization':'Bearer '+token_kmitl}
msg = 'Hello LINE Notify'
r = requests.post(url, headers=headers, data = {'message':msg})
print (r.text)
'''
test = reader_card()
x = ["Ford", "Volvo", "BMW","Ford", "Volvo", "BMW", "Volvo", "BMW", "Volvo", "BMW"] #ตัวแปรอ่านค่า
def insert_guest(data,Office,explain):
path_file = 'C:/Users/Tacha/VideoStreamingFlask/CARD_READER/SIAM-ID/1101801037083.jpg' #data[31] #file_phot form CARD_READER
Office = Office
if Office == 'kmitl':
files=[
('imageFile',('1101801037083.jpg',open('C:/Users/Tacha/VideoStreamingFlask/CARD_READER/SIAM-ID/1101801037083.jpg','rb'),'image/jpeg'))
]
headers = {'Authorization': 'Bearer '+token_kmitl}
msg = 'accestime :'+ data[1] +' ' +data[0]+ " " + data[6]+' ' + data[7] +' '+ data[8] +' detail: '+explain
print(path_file)
r = requests.request("POST",url, headers=headers,files = files,data = {'message':msg})
path_dest ='C:/Users/Tacha/VideoStreamingFlask/kmitl/Guest'
# dest = shutil.move(path_source, path_dest) # ยังไม่ได้ใว่ source_file