def registration_parent_data():
if request.method == 'POST':
first_name = request.form['first_name']
last_name = request.form['last_name']
mail_addres = request.form['mail_addres']
password = request.form['password']
check_pass = request.form['check_pass']
addres1 = request.form['addr11']
addres2 = request.form['Address2']
buzer_number = request.form['buzer_number']
school_name = request.form['school_name']
if password != check_pass:
return redirect(url_for('registration_parent'))
# 緯度経度から住所を出す
lat, lon = atik.address_to_latlon(addres1 + addres2)
# 学校名から緯度経度を出す
school_latlon = geocoder.osm(school_name, timeout=5.0)
# 学校名でヒットしなかった場合はとりあえず自宅の座標を入れる
if school_latlon is None:
school_lat = lat
school_lon = lon
school_lat = school_latlon.latlng[0]
school_lon = school_latlon.latlng[1]
db = DB()
# parent_ID作成用に現在の登録者数取得
sql = 'select * from parent'
ID_count = len(db.select(sql))
# parentに登録
data = (
'P' + str(10000 + ID_count),
buzer_number,
addres1 + addres2,
lat,
lon,
first_name + last_name,
mail_addres,
password,
school_name,
school_lat,
school_lon,
)
sql = 'insert into parent values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
db.insert_update(sql, data)
db.end_DB()
# 登録確認メール送信
mail = My_Mail(app)
mail.p_registration_mail([mail_addres], first_name + last_name,
'P' + str(10000 + ID_count))
return redirect(url_for('home'))
def registration_safehouse_data():
if request.method == 'POST':
first_name = request.form['first_name']
last_name = request.form['last_name']
mail_addres = request.form['mail_address']
password = request.form['password']
check_pass = request.form['check_pass']
addres1 = request.form['addr11']
addres2 = request.form['address']
if password != check_pass:
return redirect(url_for('registration_parent'))
# safeguardの画像保存
img_path = None
if 'uploadfile' in request.files:
imgfile = request.files['uploadfile']
if imgfile and allowed_file(imgfile.filename):
filename = secure_filename(imgfile.filename)
img_path = os.path.join(upload_folder, filename)
imgfile.save(img_path)
# 住所を緯度経度変換
lat, lon = atik.address_to_latlon(addres1 + addres2)
db = DB()
# safeguard_ID作成のために現在の登録数を取得
sql = 'select * from safeguard'
ID_count = len(db.select(sql))
# safeguardの登録
data = ('S' + str(10000 + ID_count), addres1 + addres2, lat, lon,
first_name + last_name, mail_addres, password, img_path)
sql = 'insert into safeguard values (%s,%s,%s,%s,%s,%s,%s,%s)'
db.insert_update(sql, data)
db.end_DB()
# 登録確認メールの送信
mail = My_Mail(app)
mail.s_registration_mail([mail_addres], first_name + last_name,
'S' + str(10000 + ID_count))
return redirect(url_for('home'))