LandGreenProject/LandGreen Project/LandGreen/app/main/views.py

#主業務邏輯中的視圖和路由的定義
import os
import datetime
from flask import render_template, request, session
#導入藍圖程序，用於構建路由
from werkzeug.utils import redirect
from . import main
from manage import  mqtt
#導入db，用於操作數據庫
from manage import db
#導入實體類，用於操作數據庫
from ..models import *
import json
from datetime import datetime as dt
from sqlalchemy import text


#主頁的訪問路徑
@main.route('/')
def main_index():
    #獲取登入信息
    if 'id' in session and 'uname' in session:
        username = session['uname']
        try:
            liquid = LiquidTank.query.order_by(text('datetime desc')).first()
        except Exception:
            pass
        try:
            tank1_duration1 = liquid.tk1_duration1
        except Exception:
            pass
        try:
            tank1_duration2 = liquid.tk1_duration2
        except Exception:
            pass
        try:
            tank1_duration3 = liquid.tk1_duration3
        except Exception:
            pass
        try:
            tank2_duration1 = liquid.tk2_duration1
        except Exception:
            pass
        try:
            tank2_duration2 = liquid.tk2_duration2
        except Exception:
            pass
        try:
            tank2_duration3 = liquid.tk2_duration3
        except Exception:
            pass
        try:
            tank1_from_hr1, tank1_from_min1 = liquid.tk1_start1.split(':')[0], liquid.tk1_start1.split(':')[1]
            tank1_to_hr1, tank1_to_min1 = liquid.tk1_end1.split(':')[0], liquid.tk1_end1.split(':')[1]
        except Exception:
            pass
        try:
            tank1_from_hr2, tank1_from_min2 = liquid.tk1_start2.split(':')[0], liquid.tk1_start2.split(':')[1]
            tank1_to_hr2, tank1_to_min2 = liquid.tk1_end2.split(':')[0], liquid.tk1_end2.split(':')[1]
        except Exception:
            pass
        try:
            tank1_from_hr3, tank1_from_min3 = liquid.tk1_start3.split(':')[0], liquid.tk1_start3.split(':')[1]
            tank1_to_hr3, tank1_to_min3 = liquid.tk1_end3.split(':')[0], liquid.tk1_end3.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr1, tank2_from_min1 = liquid.tk2_start1.split(':')[0], liquid.tk2_start1.split(':')[1]
            tank2_to_hr1, tank2_to_min1 = liquid.tk2_end1.split(':')[0], liquid.tk2_end1.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr2, tank2_from_min2 = liquid.tk2_start2.split(':')[0], liquid.tk2_start2.split(':')[1]
            tank2_to_hr2, tank2_to_min2 = liquid.tk2_end2.split(':')[0], liquid.tk2_end2.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr3, tank2_from_min3 = liquid.tk2_start3.split(':')[0], liquid.tk2_start3.split(':')[1]
            tank2_to_hr3, tank2_to_min3 = liquid.tk2_end3.split(':')[0], liquid.tk2_end3.split(':')[1]
        except Exception:
            pass

        return render_template('set_liquid.html',params=locals())
    else:
        return render_template('sign_in.html')

#登入頁面的訪問路徑
@main.route('/login', methods=['GET','POST'])
def login_views():
    if request.method == 'GET':
        if 'id' in session and 'uname' in session:
            return redirect('/')
        else:
            return render_template('sign_in.html')
    else:
        #接收前端傳過來的資料
        username = request.form['username']
        password = request.form['password']
        #使用接收的用戶和密碼到資料庫中查詢
        user = User.query.filter_by(username=username, password=password).first()
        #如果用戶存在，將信息保存置session並重定向回首頁，否則重定向回登入頁
        if user:
            resp = redirect('/')
            #判斷是否有記住密碼
            if 'rem' in request.form:
                userID = str(user.userID)
                max_age = 60*60*24*365
                resp.set_cookie("username", username, max_age=max_age)
                resp.set_cookie("userID", userID, max_age=max_age)

            session['uname'] = user.username
            session['id'] = user.userID
            return resp
        else:
            errMsg = "Wrong login or password"
            return render_template('sign_in.html',errMsg=errMsg)

#登入重設密碼的頁面
@main.route('/reset_password', methods=['POST', 'GET'])
def reset_password_views():
    if request.method == 'GET':
        if 'mail' in session:
            del session['mail']
        return render_template('reset_pwd1.html')
    else:
        #如果有id在session裡，代表從reset_pwd2過來的
        if "mail" in session:
            new_pwd = request.form['new_pwd']
            confirm_pwd = request.form['confirm_pwd']
            #判斷密碼是否一致
            if new_pwd == confirm_pwd:
                mail = session['mail']
                user = User.query.filter_by(mail=mail).first()
                user.password = new_pwd
                db.session.add(user)
                del session['mail']
                #修改完後回登入頁
                return redirect('/login')
            else:
                errMsg = "Passwords does not match"
                return render_template('reset_pwd2.html', errMsg=errMsg)

        email = request.form['email']
        user = User.query.filter_by(mail=email).first()
        if user:
            session['mail'] = user.mail
            return render_template('reset_pwd2.html')
        else:
            errMsg = "Wrong email.Please try again"
            return render_template('reset_pwd1.html', errMsg=errMsg)

#註冊頁面的訪問路徑
@main.route('/register',methods=['POST',"GET"])
def register_views():
    if request.method == 'GET':
        return render_template('registration.html')
    else:
        #獲取文本框的值並賦值給user實體對象
        user = User()
        user.firstname = request.form['firstname']
        user.lastname = request.form['lastname']
        user.mail = request.form['email']
        user.phone = request.form['phone']
        user.username = request.form['username']
        user.password = request.form['password']
        user.status = 1
        #將數據保存進資料庫  - 註冊
        db.session.add(user)
        #手動提交，目的是為了獲取提交後的user的id
        db.session.commit()
        #當user成功插入進資料庫之後，程序會自動將所有信息取出來在賦值給user
        #完成登入的操作
        user = User.query.filter_by(username=user.username).first()
        session['id'] = user.userID
        session['uname'] = user.username
        return redirect('/')

#驗證email訪問路徑
@main.route('/check_email')
def check_email_views():
    email = request.args['email']
    user = User.query.filter_by(mail=email).first()
    if user:
        result = {"errMsg":" "}
    else:
        result = {"pass":" "}
    return json.dumps(result)

#驗證username訪問路徑
@main.route('/check_username')
def check_username_views():
    username = request.args['username']
    user = User.query.filter_by(username=username).first()
    if user:
        result = {"errMsg":" "}
    else:
        result = {"pass":" "}
    return json.dumps(result)

#liquid的訪問路徑
@main.route('/setting_liquid', methods=['POST','GET'])
def setting_liquid_views():
    username = session['uname']
    if request.method == 'GET':
        liquid = LiquidTank.query.order_by('datetime desc').limit(1)
        return render_template('set_liquid.html', params=locals())
    else:
        liquid = LiquidTank()
        liquid.datetime = dt.now()

        tank1_num = 1
        tank1_from_num = 1
        tank1_to_num = 1
        tank2_num = 1
        tank2_from_num = 1
        tank2_to_num = 1

        for i in request.form:
            if i[:14] == 'tank1_duration':
                if tank1_num == 1:
                    liquid.tk1_duration1 = request.form[i]
                    tank1_num += 1
                elif tank1_num == 2:
                    liquid.tk1_duration2 = request.form[i]
                    tank1_num += 1
                elif tank1_num == 3:
                    liquid.tk1_duration3 = request.form[i]
            else:
                if i[:13] == 'tank1_from_hr':
                    tk1_from_hr = request.form[i]

                elif i[:14] == 'tank1_from_min':
                    tk1_from_min = request.form[i]
                    if tank1_from_num == 1:
                        liquid.tk1_start1 = tk1_from_hr + ":" + tk1_from_min
                        tank1_from_num += 1
                    elif tank1_from_num == 2:
                        liquid.tk1_start2 = tk1_from_hr + ":" + tk1_from_min
                        tank1_from_num += 1
                    elif tank1_from_num == 3:
                        liquid.tk1_start3 = tk1_from_hr + ":" + tk1_from_min

                elif i[:11] == 'tank1_to_hr':
                    tk1_to_hr = request.form[i]
                elif i[:12] == 'tank1_to_min':
                    tk1_to_min = request.form[i]
                    if tank1_to_num ==1 :
                        liquid.tk1_end1 = tk1_to_hr + ":" + tk1_to_min
                        tank1_to_num += 1
                    elif tank1_to_num == 2:
                        liquid.tk1_end2 = tk1_to_hr + ":" + tk1_to_min
                        tank1_to_num += 1
                    elif tank1_to_num == 3:
                        liquid.tk1_end3 = tk1_to_hr + ":" + tk1_to_min

            if i[:14] == 'tank2_duration':
                if tank2_num == 1:
                    liquid.tk2_duration1 = request.form[i]
                    tank2_num += 1
                elif tank2_num == 2:
                    liquid.tk2_duration2 = request.form[i]
                    tank2_num += 1
                elif tank2_num == 3:
                    liquid.tk2_duration3 = request.form[i]
            else:
                if i[:13] == 'tank2_from_hr':
                    tk2_from_hr = request.form[i]
                elif i[:14] == 'tank2_from_min':
                    tk2_from_min = request.form[i]
                    if tank2_from_num == 1:
                        liquid.tk2_start1 = tk2_from_hr + ":" + tk2_from_min
                        tank2_from_num += 1
                    elif tank2_from_num == 2:
                        liquid.tk2_start2 = tk2_from_hr + ":" + tk2_from_min
                        tank2_from_num += 1
                    elif tank2_from_num == 3:
                        liquid.tk2_start3 = tk2_from_hr + ":" + tk2_from_min


                elif i[:11] == 'tank2_to_hr':
                    tk2_to_hr = request.form[i]
                elif i[:12] == 'tank2_to_min':
                    tk2_to_min = request.form[i]
                    if tank2_to_num == 1:
                        liquid.tk2_end1 = tk2_to_hr + ":" + tk2_to_min
                        tank2_to_num += 1
                    elif tank2_to_num == 2:
                        liquid.tk2_end2 = tk2_to_hr + ":" + tk2_to_min
                        tank2_to_num += 1
                    elif tank2_to_num == 3:
                        liquid.tk2_end3 = tk2_to_hr + ":" + tk2_to_min



        db.session.add(liquid)
        db.session.commit()
        # return render_template('set_root.html', params=locals())
        return redirect('/setting_root')

#root systems的訪問路徑
@main.route('/setting_root', methods=['POST','GET'])
def setting_root_views():
    username = session['uname']
    if request.method == 'GET':
        root = RootSystem.query.order_by(text('datetime desc')).first()
        try:
            tem1 = root.tem_tem1
        except Exception:
            pass
        try:
            tem2 = root.tem_tem2
        except Exception:
            pass
        try:
            tem3 = root.tem_tem3
        except Exception:
            pass
        try:
            tem_from_hr1, tem_from_min1 = root.tem_start1.split(':')[0], root.tem_start1.split(':')[1]
        except Exception:
            pass
        try:
            tem_to_hr1, tem_to_min1 = root.tem_end1.split(':')[0], root.tem_end1.split(':')[1]
        except Exception:
            pass
        try:
            tem_from_hr2, tem_from_min2 = root.tem_start2.split(':')[0], root.tem_start2.split(':')[1]
        except Exception:
            pass
        try:
            tem_to_hr2, tem_to_min2 = root.tem_end2.split(':')[0], root.tem_end2.split(':')[1]
        except Exception:
            pass
        try:
            tem_from_hr3, tem_from_min3 = root.tem_start3.split(':')[0], root.tem_start3.split(':')[1]
        except Exception:
            pass
        try:
            tem_to_hr3, tem_to_min3 = root.tem_end3.split(':')[0], root.tem_end3.split(':')[1]
        except Exception:
            pass

        try:
            lamp_from_hr1, lamp_from_min1 = root.l_start1.split(':')[0], root.l_start1.split(':')[1]
        except Exception:
            pass
        try:
            lamp_to_hr1, lamp_to_min1 = root.l_end1.split(':')[0], root.l_end1.split(':')[1]
        except Exception:
            pass
        try:
            lamp_from_hr2, lamp_from_min2 = root.l_start2.split(':')[0], root.l_start2.split(':')[1]
        except Exception:
            pass
        try:
            lamp_to_hr2, lamp_to_min2 = root.l_end2.split(':')[0], root.l_end2.split(':')[1]
        except Exception:
            pass
        try:
            lamp_from_hr3, lamp_from_min3 = root.l_start3.split(':')[0], root.l_start3.split(':')[1]
        except Exception:
            pass
        try:
            lamp_to_hr3, lamp_to_min3 = root.l_end3.split(':')[0], root.l_end3.split(':')[1]
        except Exception:
            pass

        try:
            r = str(root.l_r)
            g = str(root.l_g)
            b = str(root.l_b)
            color = '(' + r + ',' + g + ',' + b + ')'
        except Exception:
            pass

        try:
            if root.l_bright_auto == 0:
                #+1是為了讓前端不要判定為假
                bright_on = root.l_bright_auto + 1

            bright_vol = root.l_bright_vol

            if root.fan_status == 0:
                fan_on = root.fan_status + 1

            periodicity = root.fan_periodicity
            duration = root.fan_duration
            speed = root.fan_speed
            humidity = root.humidity
        except Exception:
            pass

        return render_template('set_root.html', params=locals())
    else:
        root = RootSystem()
        root.datetime = dt.now()

        tem_num = 1
        tem_from_num = 1
        tem_to_num = 1
        lamp_from_num = 1
        lamp_to_num = 1
        for i in request.form:
            if i[:3] == 'tem' and len(i) <= 7:
                if tem_num == 1:
                    root.tem_tem1 = request.form[i]
                    tem_num += 1
                elif tem_num == 2:
                    root.tem_tem2 = request.form[i]
                    tem_num += 1
                elif tem_num == 3:
                    root.tem_tem3 = request.form[i]
            else:
                if i[:11] == 'tem_from_hr':
                    tem_from_hr = request.form[i]

                elif i[:12] == 'tem_from_min':
                    tem_from_min = request.form[i]
                    if tem_from_num == 1:
                        root.tem_start1 = tem_from_hr + ":" + tem_from_min
                        tem_from_num += 1
                    elif tem_from_num == 2:
                        root.tem_start2 = tem_from_hr + ":" + tem_from_min
                        tem_from_num += 1
                    elif tem_from_num == 3:
                        root.tem_start3 = tem_from_hr + ":" + tem_from_min

                elif i[:9] == 'tem_to_hr':
                    tem_to_hr = request.form[i]
                elif i[:10] == 'tem_to_min':
                    tem_to_min = request.form[i]
                    if tem_to_num ==1 :
                        root.tem_end1 = tem_to_hr + ":" + tem_to_min
                        tem_to_num += 1
                    elif tem_to_num == 2:
                        root.tem_end2 = tem_to_hr + ":" + tem_to_min
                        tem_to_num += 1
                    elif tem_to_num == 3:
                        root.tem_end3 = tem_to_hr + ":" + tem_to_min

            if i[:12] == 'lamp_from_hr':
                lamp_from_hr = request.form[i]

            elif i[:13] == 'lamp_from_min':
                lamp_from_min = request.form[i]
                if lamp_from_num == 1:
                    root.l_start1 = lamp_from_hr + ":" + lamp_from_min
                    lamp_from_num += 1
                elif lamp_from_num == 2:
                    root.l_start2 = lamp_from_hr + ":" + lamp_from_min
                    lamp_from_num += 1
                elif lamp_from_num == 3:
                    root.l_start3 = lamp_from_hr + ":" + lamp_from_min
            if i[:10] == 'lamp_to_hr':
                lamp_to_hr = request.form[i]
            elif i[:11] == 'lamp_to_min':
                lamp_to_min = request.form[i]
                if lamp_to_num ==1 :
                    root.l_end1 = lamp_to_hr + ":" + lamp_to_min
                    lamp_to_num += 1
                elif lamp_to_num == 2:
                    root.l_end2 = lamp_to_hr + ":" + lamp_to_min
                    lamp_to_num += 1
                elif lamp_to_num == 3:
                    root.l_end3 = lamp_to_hr + ":" + lamp_to_min

            if i == 'color':
                try:
                    color = request.form['color']
                    root.l_r, root.l_g, root.l_b = color.split(',')[0], color.split(',')[1][1:], color.split(',')[2][1:]
                except Exception:
                    pass

        if 'bright-on' in request.form:
            root.l_bright_auto = 1
        else:
            root.l_bright_auto = 0

        root.l_bright_vol = request.form['bright-vol']

        if 'fan-on' in request.form:
            root.fan_status = 1
        else:
            root.fan_status = 0

        root.fan_periodicity = request.form['periodicity']
        root.fan_duration = request.form['duration']
        root.fan_speed = request.form['speed']
        root.humidity = request.form['humidity']

        db.session.add(root)
        db.session.commit()

        # return render_template('set_stem.html', params=locals())
        return redirect('/setting_stem')

#stem systems的訪問路徑
@main.route('/setting_stem', methods=['POST','GET'])
def setting_stem_views():
    username = session['uname']
    if request.method == 'GET':
        stem = StemSystem.query.order_by(text('datetime desc')).first()
        try:
            tem1 = stem.tem_tem1
        except Exception:
            pass
        try:
            tem2 = stem.tem_tem2
        except Exception:
            pass
        try:
            tem3 = stem.tem_tem3
        except Exception:
            pass
        try:
            tem_from_hr1, tem_from_min1 = stem.tem_start1.split(':')[0], stem.tem_start1.split(':')[1]
        except Exception:
            pass
        try:
            tem_to_hr1, tem_to_min1 = stem.tem_end1.split(':')[0], stem.tem_end1.split(':')[1]
        except Exception:
            pass
        try:
            tem_from_hr2, tem_from_min2 = stem.tem_start2.split(':')[0], stem.tem_start2.split(':')[1]
        except Exception:
            pass
        try:
            tem_to_hr2, tem_to_min2 = stem.tem_end2.split(':')[0], stem.tem_end2.split(':')[1]
        except Exception:
            pass
        try:
            tem_from_hr3, tem_from_min3 = stem.tem_start3.split(':')[0], stem.tem_start3.split(':')[1]
        except Exception:
            pass
        try:
            tem_to_hr3, tem_to_min3 = stem.tem_end3.split(':')[0], stem.tem_end3.split(':')[1]
        except Exception:
            pass

        try:
            led_from_hr1, led_from_min1 = stem.l_start1.split(':')[0], stem.l_start1.split(':')[1]
        except Exception:
            pass
        try:
            led_to_hr1, led_to_min1 = stem.l_end1.split(':')[0], stem.l_end1.split(':')[1]
        except Exception:
            pass
        try:
            led_from_hr2, led_from_min2 = stem.l_start2.split(':')[0], stem.l_start2.split(':')[1]
        except Exception:
            pass
        try:
            led_to_hr2, led_to_min2 = stem.l_end2.split(':')[0], stem.l_end2.split(':')[1]
        except Exception:
            pass
        try:
            led_from_hr3, led_from_min3 = stem.l_start3.split(':')[0], stem.l_start3.split(':')[1]
        except Exception:
            pass
        try:
            led_to_hr3, led_to_min3 = stem.l_end3.split(':')[0], stem.l_end3.split(':')[1]
        except Exception:
            pass

        try:
            r = str(stem.l_r)
            g = str(stem.l_g)
            b = str(stem.l_b)
            color = '(' + r + ',' + g + ',' + b + ')'
        except Exception:
            pass

        try:
            if stem.l_bright_auto == 0:
                #+1是為了讓前端不要判定為假
                bright_on = stem.l_bright_auto + 1

            bright_vol = stem.l_bright_vol

        except Exception:
            pass

        try:
            if stem.c_status == 0:
                # +1是為了讓前端不要判定為假
                camera_on = stem.c_status + 1
        except Exception:
            pass
        try:
            duration = stem.c_duration
        except Exception:
            pass

        try:
            tem_near_stem1 = stem.t_n_s_tem1
        except Exception:
            pass
        try:
            tem_near_stem2 = stem.t_n_s_tem2
        except Exception:
            pass
        try:
            tem_near_stem3 = stem.t_n_s_tem3
        except Exception:
            pass
        try:
            t_n_s_from_hr1, t_n_s_from_min1 = stem.t_n_s_start1.split(':')[0], stem.t_n_s_start1.split(':')[1]
        except Exception:
            pass
        try:
            t_n_s_to_hr1, t_n_s_to_min1 = stem.t_n_s_end1.split(':')[0], stem.t_n_s_end1.split(':')[1]
        except Exception:
            pass
        try:
            t_n_s_from_hr2, t_n_s_from_min2 = stem.t_n_s_start2.split(':')[0], stem.t_n_s_start2.split(':')[1]
        except Exception:
            pass
        try:
            t_n_s_to_hr2, t_n_s_to_min2 = stem.t_n_s_end2.split(':')[0], stem.t_n_s_end2.split(':')[1]
        except Exception:
            pass
        try:
            t_n_s_from_hr3, t_n_s_from_min3 = stem.t_n_s_start3.split(':')[0], stem.t_n_s_start3.split(':')[1]
        except Exception:
            pass
        try:
            t_n_s_to_hr3, t_n_s_to_min3 = stem.t_n_s_end3.split(':')[0], stem.t_n_s_end3.split(':')[1]
        except Exception:
            pass


        try:
            music1 = stem.m_playlist1
        except Exception:
            pass
        try:
            music2 = stem.m_playlist2
        except Exception:
            pass
        try:
            music3 = stem.m_playlist3
        except Exception:
            pass
        try:
            music_from_hr1, music_from_min1 = stem.m_start1.split(':')[0], stem.m_start1.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr1, music_to_min1 = stem.m_end1.split(':')[0], stem.m_end1.split(':')[1]
        except Exception:
            pass
        try:
            music_from_hr2, music_from_min2 = stem.m_start2.split(':')[0], stem.m_start2.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr2, music_to_min2 = stem.m_end2.split(':')[0], stem.m_end2.split(':')[1]
        except Exception:
            pass
        try:
            music_from_hr3, music_from_min3 = stem.m_start3.split(':')[0], stem.m_start3.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr3, music_to_min3 = stem.m_end3.split(':')[0], stem.m_end3.split(':')[1]
        except Exception:
            pass


        try:
            u_s_from_hr1, u_s_from_min1 = stem.u_s_start1.split(':')[0], stem.u_s_start1.split(':')[1]
        except Exception:
            pass
        try:
            u_s_to_hr1, u_s_to_min1 = stem.u_s_end1.split(':')[0], stem.u_s_end1.split(':')[1]
        except Exception:
            pass
        try:
            u_s_from_hr2, u_s_from_min2 = stem.u_s_start2.split(':')[0], stem.u_s_start2.split(':')[1]
        except Exception:
            pass
        try:
            u_s_to_hr2, u_s_to_min2 = stem.u_s_end2.split(':')[0], stem.u_s_end2.split(':')[1]
        except Exception:
            pass
        try:
            u_s_from_hr3, u_s_from_min3 = stem.u_s_start3.split(':')[0], stem.u_s_start3.split(':')[1]
        except Exception:
            pass
        try:
            u_s_to_hr3, u_s_to_min3 = stem.u_s_end3.split(':')[0], stem.u_s_end3.split(':')[1]
        except Exception:
            pass

        try:
            if stem.u_s_status == 0:
                # +1是為了讓前端不要判定為假
                ultra_sonic_on = stem.u_s_status + 1
        except Exception:
            pass
        try:
            volume = stem.u_s_vol
        except Exception:
            pass

        try:
            vibration1 = stem.v_vol1
        except Exception:
            pass
        try:
            vibration2 = stem.v_vol2
        except Exception:
            pass
        try:
            vibration3 = stem.v_vol3
        except Exception:
            pass
        try:
            v_from_hr1, v_from_min1 = stem.v_start1.split(':')[0], stem.v_start1.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr1, v_to_min1 = stem.v_end1.split(':')[0], stem.v_end1.split(':')[1]
        except Exception:
            pass
        try:
            v_from_hr2, v_from_min2 = stem.v_start2.split(':')[0], stem.v_start2.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr2, v_to_min2 = stem.v_end2.split(':')[0], stem.v_end2.split(':')[1]
        except Exception:
            pass
        try:
            v_from_hr3, v_from_min3 = stem.v_start3.split(':')[0], stem.v_start3.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr3, v_to_min3 = stem.v_end3.split(':')[0], stem.v_end3.split(':')[1]
        except Exception:
            pass



        try:
            wind_flow1 = stem.w_vol1
        except Exception:
            pass
        try:
            wind_flow2 = stem.w_vol2
        except Exception:
            pass
        try:
            wind_flow3 = stem.w_vol3
        except Exception:
            pass
        try:
            w_from_hr1, w_from_min1 = stem.w_start1.split(':')[0], stem.w_start1.split(':')[1]
        except Exception:
            pass
        try:
            w_to_hr1, w_to_min1 = stem.w_end1.split(':')[0], stem.w_end1.split(':')[1]
        except Exception:
            pass
        try:
            w_from_hr2, w_from_min2 = stem.w_start2.split(':')[0], stem.w_start2.split(':')[1]
        except Exception:
            pass
        try:
            w_to_hr2, w_to_min2 = stem.w_end2.split(':')[0], stem.w_end2.split(':')[1]
        except Exception:
            pass
        try:
            w_from_hr3, w_from_min3 = stem.w_start3.split(':')[0], stem.w_start3.split(':')[1]
        except Exception:
            pass
        try:
            w_to_hr3, w_to_min3 = stem.w_end3.split(':')[0], stem.w_end3.split(':')[1]
        except Exception:
            pass

        try:
            c_duration = stem.c_duration
        except Exception:
            pass

        try:
            rh = stem.rh
        except Exception:
            pass



        return render_template('set_stem.html', params=locals())
    else:
        stem = StemSystem()
        stem.datetime = dt.now()

        tem_num = 1
        tem_from_num = 1
        tem_to_num = 1
        led_from_num = 1
        led_to_num = 1
        t_n_s_num = 1
        t_n_s_from_num = 1
        t_n_s_to_num = 1
        music_num = 1
        music_from_num = 1
        music_to_num = 1
        u_s_from_num = 1
        u_s_to_num = 1
        v_num = 1
        v_from_num = 1
        v_to_num = 1
        w_num = 1
        w_from_num = 1
        w_to_num = 1

        for i in request.form:
            if i[:3] == 'tem' and len(i) <= 7:
                if tem_num == 1:
                    stem.tem_tem1 = request.form[i]
                    tem_num += 1
                elif tem_num == 2:
                    stem.tem_tem2 = request.form[i]
                    tem_num += 1
                elif tem_num == 3:
                    stem.tem_tem3 = request.form[i]
            else:
                if i[:11] == 'tem_from_hr':
                    tem_from_hr = request.form[i]

                elif i[:12] == 'tem_from_min':
                    tem_from_min = request.form[i]
                    if tem_from_num == 1:
                        stem.tem_start1 = tem_from_hr + ":" + tem_from_min
                        tem_from_num += 1
                    elif tem_from_num == 2:
                        stem.tem_start2 = tem_from_hr + ":" + tem_from_min
                        tem_from_num += 1
                    elif tem_from_num == 3:
                        stem.tem_start3 = tem_from_hr + ":" + tem_from_min

                elif i[:9] == 'tem_to_hr':
                    tem_to_hr = request.form[i]
                elif i[:10] == 'tem_to_min':
                    tem_to_min = request.form[i]
                    if tem_to_num ==1 :
                        stem.tem_end1 = tem_to_hr + ":" + tem_to_min
                        tem_to_num += 1
                    elif tem_to_num == 2:
                        stem.tem_end2 = tem_to_hr + ":" + tem_to_min
                        tem_to_num += 1
                    elif tem_to_num == 3:
                        stem.tem_end3 = tem_to_hr + ":" + tem_to_min

            if i[:11] == 'led_from_hr':
                led_from_hr = request.form[i]

            elif i[:12] == 'led_from_min':
                led_from_min = request.form[i]
                if led_from_num == 1:
                    stem.l_start1 = led_from_hr + ":" + led_from_min
                    led_from_num += 1
                elif led_from_num == 2:
                    stem.l_start2 = led_from_hr + ":" + led_from_min
                    led_from_num += 1
                elif led_from_num == 3:
                    stem.l_start3 = led_from_hr + ":" + led_from_min
            if i[:9] == 'led_to_hr':
                led_to_hr = request.form[i]
            elif i[:10] == 'led_to_min':
                led_to_min = request.form[i]
                if led_to_num ==1 :
                    stem.l_end1 = led_to_hr + ":" + led_to_min
                    led_to_num += 1
                elif led_to_num == 2:
                    stem.l_end2 = led_to_hr + ":" + led_to_min
                    led_to_num += 1
                elif led_to_num == 3:
                    stem.l_end3 = led_to_hr + ":" + led_to_min

            if i == 'color':
                try:
                    color = request.form['color']
                    stem.l_r, stem.l_g, stem.l_b = color.split(',')[0], color.split(',')[1][1:], color.split(',')[2][1:]
                except Exception:
                    pass

            if i[:13] == 'tem-near-stem':
                if t_n_s_num == 1:
                    stem.t_n_s_tem1 = request.form[i]
                    print(request.form[i])
                    t_n_s_num += 1
                elif t_n_s_num == 2:
                    stem.t_n_s_tem2 = request.form[i]
                    t_n_s_num += 1
                elif t_n_s_num == 3:
                    stem.t_n_s_tem3 = request.form[i]
            else:
                if i[:11] == 'tns_from_hr':
                    t_n_s_from_hr = request.form[i]

                elif i[:12] == 'tns_from_min':
                    t_n_s_from_min = request.form[i]
                    if t_n_s_from_num == 1:
                        stem.t_n_s_start1 = t_n_s_from_hr + ":" + t_n_s_from_min
                        t_n_s_from_num += 1
                    elif t_n_s_from_num == 2:
                        stem.t_n_s_start2 = t_n_s_from_hr + ":" + t_n_s_from_min
                        t_n_s_from_num += 1
                    elif t_n_s_from_num == 3:
                        stem.t_n_s_start3 = t_n_s_from_hr + ":" + t_n_s_from_min

                elif i[:9] == 'tns_to_hr':
                    t_n_s_to_hr = request.form[i]
                elif i[:10] == 'tns_to_min':
                    t_n_s_to_min = request.form[i]
                    if t_n_s_to_num == 1:
                        stem.t_n_s_end1 = t_n_s_to_hr + ":" + t_n_s_to_min
                        t_n_s_to_num += 1
                    elif t_n_s_to_num == 2:
                        stem.t_n_s_end2 = t_n_s_to_hr + ":" + t_n_s_to_min
                        t_n_s_to_num += 1
                    elif t_n_s_to_num == 3:
                        stem.t_n_s_end3 = t_n_s_to_hr + ":" + t_n_s_to_min

            if i[:5] == 'music' and len(i) <=11:
                if music_num == 1:
                    stem.m_playlist1 = request.form[i]
                    music_num += 1
                elif music_num == 2:
                    stem.m_playlist2 = request.form[i]
                    music_num += 1
                elif music_num == 3:
                    stem.m_playlist3 = request.form[i]
            else:
                if i[:13] == 'music_from_hr':
                    music_from_hr = request.form[i]

                elif i[:14] == 'music_from_min':
                    music_from_min = request.form[i]
                    if music_from_num == 1:
                        stem.m_start1 = music_from_hr + ":" + music_from_min
                        music_from_num += 1
                    elif music_from_num == 2:
                        stem.m_start2 = music_from_hr + ":" + music_from_min
                        music_from_num += 1
                    elif music_from_num == 3:
                        stem.m_start3 = music_from_hr + ":" + music_from_min

                elif i[:11] == 'music_to_hr':
                    music_to_hr = request.form[i]
                elif i[:12] == 'music_to_min':
                    music_to_min = request.form[i]
                    if music_to_num == 1:
                        stem.m_end1 = music_to_hr + ":" + music_to_min
                        music_to_num += 1
                    elif music_to_num == 2:
                        stem.m_end2 = music_to_hr + ":" + music_to_min
                        music_to_num += 1
                    elif music_to_num == 3:
                        stem.m_end3 = music_to_hr + ":" + music_to_min

            if i[:9] == 'vibration':
                if v_num == 1:
                    stem.v_vol1 = request.form[i]
                    v_num += 1
                elif v_num == 2:
                    stem.v_vol2 = request.form[i]
                    v_num += 1
                elif v_num == 3:
                    stem.v_vol3 = request.form[i]
            else:
                if i[:9] == 'v_from_hr':
                    v_from_hr = request.form[i]

                elif i[:10] == 'v_from_min':
                    v_from_min = request.form[i]
                    if v_from_num == 1:
                        stem.v_start1 = v_from_hr + ":" + v_from_min
                        v_from_num += 1
                    elif v_from_num == 2:
                        stem.v_start2 = v_from_hr + ":" + v_from_min
                        v_from_num += 1
                    elif v_from_num == 3:
                        stem.v_start3 = v_from_hr + ":" + v_from_min

                elif i[:7] == 'v_to_hr':
                    v_to_hr = request.form[i]
                elif i[:8] == 'v_to_min':
                    v_to_min = request.form[i]
                    if v_to_num == 1:
                        stem.v_end1 = v_to_hr + ":" + v_to_min
                        v_to_num += 1
                    elif v_to_num == 2:
                        stem.v_end2 = v_to_hr + ":" + v_to_min
                        v_to_num += 1
                    elif v_to_num == 3:
                        stem.v_end3 = v_to_hr + ":" + v_to_min

            if i[:9] == 'wind-flow':
                if w_num == 1:
                    stem.w_vol1 = request.form[i]
                    w_num += 1
                elif w_num == 2:
                    stem.w_vol2 = request.form[i]
                    w_num += 1
                elif w_num == 3:
                    stem.w_vol3 = request.form[i]
            else:
                if i[:9] == 'w_from_hr':
                    w_from_hr = request.form[i]

                elif i[:10] == 'w_from_min':
                    w_from_min = request.form[i]
                    if w_from_num == 1:
                        stem.w_start1 = w_from_hr + ":" + w_from_min
                        w_from_num += 1
                    elif w_from_num == 2:
                        stem.w_start2 = w_from_hr + ":" + w_from_min
                        w_from_num += 1
                    elif w_from_num == 3:
                        stem.w_start3 = w_from_hr + ":" + w_from_min

                elif i[:7] == 'w_to_hr':
                    w_to_hr = request.form[i]
                elif i[:8] == 'w_to_min':
                    w_to_min = request.form[i]
                    if w_to_num == 1:
                        stem.w_end1 = w_to_hr + ":" + w_to_min
                        w_to_num += 1
                    elif w_to_num == 2:
                        stem.w_end2 = w_to_hr + ":" + w_to_min
                        w_to_num += 1
                    elif w_to_num == 3:
                        stem.w_end3 = w_to_hr + ":" + w_to_min

            if i[:10] == 'us_from_hr':
                u_s_from_hr = request.form[i]

            elif i[:11] == 'us_from_min':
                u_s_from_min = request.form[i]
                if u_s_from_num == 1:
                    stem.u_s_start1 = u_s_from_hr + ":" + u_s_from_min
                    u_s_from_num += 1
                elif u_s_from_num == 2:
                    stem.u_s_start2 = u_s_from_hr + ":" + u_s_from_min
                    u_s_from_num += 1
                elif u_s_from_num == 3:
                    stem.u_s_start3 = u_s_from_hr + ":" + u_s_from_min

            elif i[:8] == 'us_to_hr':
                u_s_to_hr = request.form[i]
            elif i[:9] == 'us_to_min':
                u_s_to_min = request.form[i]
                if u_s_to_num == 1:
                    stem.u_s_end1 = u_s_to_hr + ":" + u_s_to_min
                    u_s_to_num += 1
                elif u_s_to_num == 2:
                    stem.u_s_end2 = u_s_to_hr + ":" + u_s_to_min
                    u_s_to_num += 1
                elif u_s_to_num == 3:
                    stem.u_s_end3 = u_s_to_hr + ":" + u_s_to_min

        if 'ultra-sonic-on' in request.form:
            stem.u_s_status = 1
        else:
            stem.u_s_status = 0

        if 'volume' in request.form:
            stem.u_s_vol = request.form['volume']

        if 'bright-on' in request.form:
            stem.l_bright_auto = 1
        else:
            stem.l_bright_auto = 0

        stem.l_bright_vol = request.form['bright-vol']

        if 'camera-on' in request.form:
            stem.c_status = 1
        else:
            stem.c_status = 0

        stem.c_duration = request.form['duration']

        stem.rh = request.form['rh']


        db.session.add(stem)
        db.session.commit()

        print(request.form)

        # return render_template('online_fitolab.html', params=locals())
        return redirect('online_fitolab')




#online_fitolab的訪問路徑
@main.route('/online_fitolab', methods=['POST',"GET"])
def online_fitolib_views():
    username = session['uname']
    if request.method == 'GET':
        stem = StemSystem.query.order_by(text('datetime desc')).first()
        root = RootSystem.query.order_by(text('datetime desc')).first()
        liquid = LiquidTank.query.order_by(text('datetime desc')).first()
        fitolab1 = Fitolab1Sensor.query.order_by(text('datetime desc')).first()

        try:
            stem_r = str(stem.l_r)
            stem_g = str(stem.l_g)
            stem_b = str(stem.l_b)
            stem_color = '(' + stem_r + ',' + stem_g + ',' + stem_b + ')'
        except Exception:
            pass

        try:
            if stem.l_bright_auto == 0:
                #+1是為了讓前端不要判定為假
                stem_bright_on = stem.l_bright_auto + 1

            stem_bright_vol = stem.l_bright_vol
        except Exception:
            pass

        try:
            music1 = stem.m_playlist1
        except Exception:
            pass
        try:
            music2 = stem.m_playlist2
        except Exception:
            pass
        try:
            music3 = stem.m_playlist3
        except Exception:
            pass
        try:
            music_from_hr1, music_from_min1 = stem.m_start1.split(':')[0], stem.m_start1.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr1, music_to_min1 = stem.m_end1.split(':')[0], stem.m_end1.split(':')[1]
        except Exception:
            pass
        try:
            music_from_hr2, music_from_min2 = stem.m_start2.split(':')[0], stem.m_start2.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr2, music_to_min2 = stem.m_end2.split(':')[0], stem.m_end2.split(':')[1]
        except Exception:
            pass
        try:
            music_from_hr3, music_from_min3 = stem.m_start3.split(':')[0], stem.m_start3.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr3, music_to_min3 = stem.m_end3.split(':')[0], stem.m_end3.split(':')[1]
        except Exception:
            pass

        try:
            m_vol = stem.m_vol
        except Exception:
            pass

        try:
            root_r = str(root.l_r)
            root_g = str(root.l_g)
            root_b = str(root.l_b)
            root_color = '(' + root_r + ',' + root_g + ',' + root_b + ')'
        except Exception:
            pass

        try:
            if root.l_bright_auto == 0:
                #+1是為了讓前端不要判定為假
                root_bright_on = root.l_bright_auto + 1

            root_bright_vol = root.l_bright_vol
        except Exception:
            pass


        try:
            vibration1 = stem.v_vol1
        except Exception:
            pass
        try:
            vibration2 = stem.v_vol2
        except Exception:
            pass
        try:
            vibration3 = stem.v_vol3
        except Exception:
            pass
        try:
            v_from_hr1, v_from_min1 = stem.v_start1.split(':')[0], stem.v_start1.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr1, v_to_min1 = stem.v_end1.split(':')[0], stem.v_end1.split(':')[1]
        except Exception:
            pass
        try:
            v_from_hr2, v_from_min2 = stem.v_start2.split(':')[0], stem.v_start2.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr2, v_to_min2 = stem.v_end2.split(':')[0], stem.v_end2.split(':')[1]
        except Exception:
            pass
        try:
            v_from_hr3, v_from_min3 = stem.v_start3.split(':')[0], stem.v_start3.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr3, v_to_min3 = stem.v_end3.split(':')[0], stem.v_end3.split(':')[1]
        except Exception:
            pass

        try:
            v_pow = stem.v_power
        except Exception:
            pass

        try:
            tank1_duration1 = liquid.tk1_duration1
            tank2_duration1 = liquid.tk2_duration1

            tank1_from_hr1, tank1_from_min1 = liquid.tk1_start1.split(':')[0], liquid.tk1_start1.split(':')[1]
            tank1_to_hr1, tank1_to_min1 = liquid.tk1_end1.split(':')[0], liquid.tk1_end1.split(':')[1]
        except Exception:
            pass
        try:
            tank1_from_hr2, tank1_from_min2 = liquid.tk1_start2.split(':')[0], liquid.tk1_start2.split(':')[1]
            tank1_to_hr2, tank1_to_min2 = liquid.tk1_end2.split(':')[0], liquid.tk1_end2.split(':')[1]
        except Exception:
            pass
        try:
            tank1_from_hr3, tank1_from_min3 = liquid.tk1_start3.split(':')[0], liquid.tk1_start3.split(':')[1]
            tank1_to_hr3, tank1_to_min3 = liquid.tk1_end3.split(':')[0], liquid.tk1_end3.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr1, tank2_from_min1 = liquid.tk2_start1.split(':')[0], liquid.tk2_start1.split(':')[1]
            tank2_to_hr1, tank2_to_min1 = liquid.tk2_end1.split(':')[0], liquid.tk2_end1.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr2, tank2_from_min2 = liquid.tk2_start2.split(':')[0], liquid.tk2_start2.split(':')[1]
            tank2_to_hr2, tank2_to_min2 = liquid.tk2_end2.split(':')[0], liquid.tk2_end2.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr3, tank2_from_min3 = liquid.tk2_start3.split(':')[0], liquid.tk2_start3.split(':')[1]
            tank2_to_hr3, tank2_to_min3 = liquid.tk2_end3.split(':')[0], liquid.tk2_end3.split(':')[1]
        except Exception:
            pass

        try:
            if stem.c_status == 0:
                # +1是為了讓前端不要判定為假
                camera_on = stem.c_status + 1
        except Exception:
            pass

        try:
            c_duration = stem.c_duration
        except Exception:
            pass

        try:
            music1 = stem.m_playlist1
        except Exception:
            pass
        try:
            music2 = stem.m_playlist2
        except Exception:
            pass
        try:
            music3 = stem.m_playlist3
        except Exception:
            pass
        try:
            music_from_hr1, music_from_min1 = stem.m_start1.split(':')[0], stem.m_start1.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr1, music_to_min1 = stem.m_end1.split(':')[0], stem.m_end1.split(':')[1]
        except Exception:
            pass
        try:
            music_from_hr2, music_from_min2 = stem.m_start2.split(':')[0], stem.m_start2.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr2, music_to_min2 = stem.m_end2.split(':')[0], stem.m_end2.split(':')[1]
        except Exception:
            pass
        try:
            music_from_hr3, music_from_min3 = stem.m_start3.split(':')[0], stem.m_start3.split(':')[1]
        except Exception:
            pass
        try:
            music_to_hr3, music_to_min3 = stem.m_end3.split(':')[0], stem.m_end3.split(':')[1]
        except Exception:
            pass


        try:
            m_vol = stem.m_vol
        except Exception:
            pass

        try:
            if stem.c_status == 0:
                #+1是為了讓前端不要判定為假
                camara_on = stem.c_status + 1
        except Exception:
            pass



        try:
            vibration1 = stem.v_vol1
        except Exception:
            pass
        try:
            vibration2 = stem.v_vol2
        except Exception:
            pass
        try:
            vibration3 = stem.v_vol3
        except Exception:
            pass
        try:
            v_from_hr1, v_from_min1 = stem.v_start1.split(':')[0], stem.v_start1.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr1, v_to_min1 = stem.v_end1.split(':')[0], stem.v_end1.split(':')[1]
        except Exception:
            pass
        try:
            v_from_hr2, v_from_min2 = stem.v_start2.split(':')[0], stem.v_start2.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr2, v_to_min2 = stem.v_end2.split(':')[0], stem.v_end2.split(':')[1]
        except Exception:
            pass
        try:
            v_from_hr3, v_from_min3 = stem.v_start3.split(':')[0], stem.v_start3.split(':')[1]
        except Exception:
            pass
        try:
            v_to_hr3, v_to_min3 = stem.v_end3.split(':')[0], stem.v_end3.split(':')[1]
        except Exception:
            pass

        try:
            v_pow = stem.v_power
        except Exception:
            pass


        try:
            tank1_duration1 = liquid.tk1_duration1
        except Exception:
            pass
        try:
            tank1_duration2 = liquid.tk1_duration2
        except Exception:
            pass
        try:
            tank1_duration3 = liquid.tk1_duration3
        except Exception:
            pass
        try:
            tank2_duration1 = liquid.tk2_duration1
        except Exception:
            pass
        try:
            tank2_duration2 = liquid.tk2_duration2
        except Exception:
            pass
        try:
            tank2_duration3 = liquid.tk2_duration3
        except Exception:
            pass
        try:
            tank1_from_hr1, tank1_from_min1 = liquid.tk1_start1.split(':')[0], liquid.tk1_start1.split(':')[1]
            tank1_to_hr1, tank1_to_min1 = liquid.tk1_end1.split(':')[0], liquid.tk1_end1.split(':')[1]
        except Exception:
            pass
        try:
            tank1_from_hr2, tank1_from_min2 = liquid.tk1_start2.split(':')[0], liquid.tk1_start2.split(':')[1]
            tank1_to_hr2, tank1_to_min2 = liquid.tk1_end2.split(':')[0], liquid.tk1_end2.split(':')[1]
        except Exception:
            pass
        try:
            tank1_from_hr3, tank1_from_min3 = liquid.tk1_start3.split(':')[0], liquid.tk1_start3.split(':')[1]
            tank1_to_hr3, tank1_to_min3 = liquid.tk1_end3.split(':')[0], liquid.tk1_end3.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr1, tank2_from_min1 = liquid.tk2_start1.split(':')[0], liquid.tk2_start1.split(':')[1]
            tank2_to_hr1, tank2_to_min1 = liquid.tk2_end1.split(':')[0], liquid.tk2_end1.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr2, tank2_from_min2 = liquid.tk2_start2.split(':')[0], liquid.tk2_start2.split(':')[1]
            tank2_to_hr2, tank2_to_min2 = liquid.tk2_end2.split(':')[0], liquid.tk2_end2.split(':')[1]
        except Exception:
            pass
        try:
            tank2_from_hr3, tank2_from_min3 = liquid.tk2_start3.split(':')[0], liquid.tk2_start3.split(':')[1]
            tank2_to_hr3, tank2_to_min3 = liquid.tk2_end3.split(':')[0], liquid.tk2_end3.split(':')[1]
        except Exception:
            pass

        try:
            air_temp1 = fitolab1.s_air_tem1
        except Exception:
            pass
        try:
            air_humidity1 = fitolab1.s_humidity
        except Exception:
            pass
        try:
            ph = fitolab1.r_ph
        except Exception:
            pass
        try:
            do = fitolab1.r_do
        except Exception:
            pass
        try:
            ec = fitolab1.r_ec
        except Exception:
            pass
        try:
            water_level = fitolab1.r_water_level
        except Exception:
            pass
        try:
            tds1 = fitolab1.r_turbidity
        except Exception:
            pass
        try:
            o3 = fitolab1.s_o3
        except Exception:
            pass
        try:
            co2 = fitolab1.s_co2
        except Exception:
            pass
        try:
            h2 = fitolab1.s_h2
        except Exception:
            pass
        try:
            weight1 = fitolab1.s_wgt_sensor1
        except Exception:
            pass
        try:
            weight2 = fitolab1.s_wgt_sensor2
        except Exception:
            pass



        return render_template('online_fitolab.html', params=locals())
    else:
        stem = StemSystem.query.order_by(text('datetime desc')).first()
        root = RootSystem.query.order_by(text('datetime desc')).first()
        liquid = LiquidTank.query.order_by(text('datetime desc')).first()
        fitolab1 = Fitolab1Sensor.query.order_by(text('datetime desc')).first()

        music_num = 1
        music_from_num = 1
        music_to_num = 1
        v_num = 1
        v_from_num = 1
        v_to_num = 1
        tank1_num = 1
        tank1_from_num = 1
        tank1_to_num = 1
        tank2_num = 1
        tank2_from_num = 1
        tank2_to_num = 1

        for i in request.form:
            if i == 'stem-color':
                try:
                    color = request.form['stem-color']
                    stem.l_r, stem.l_g, stem.l_b = color.split(',')[0], color.split(',')[1][1:], color.split(',')[2][1:]
                except Exception:
                    pass
            elif i == 'root-color':
                try:
                    color = request.form['root-color']
                    root.l_r, root.l_g, root.l_b = color.split(',')[0], color.split(',')[1][1:], color.split(',')[2][1:]
                except Exception:
                    pass

            if 'stem-bright-on' in request.form:
                stem.l_bright_auto = 1
            else:
                stem.l_bright_auto = 0

            if 'root-bright-on' in request.form:
                root.l_bright_auto = 1
            else:
                root.l_bright_auto = 0


            if i[:5] == 'music' and len(i) <=11:
                if music_num == 1:
                    stem.m_playlist1 = request.form[i]
                    stem.m_playlist2 = None
                    stem.m_playlist3 = None
                    music_num += 1
                elif music_num == 2:
                    stem.m_playlist2 = request.form[i]
                    stem.m_playlist3 = None
                    music_num += 1
                elif music_num == 3:
                    stem.m_playlist3 = request.form[i]
            else:
                if i[:13] == 'music_from_hr':
                    music_from_hr = request.form[i]

                elif i[:14] == 'music_from_min':
                    music_from_min = request.form[i]
                    if music_from_num == 1:
                        stem.m_start1 = music_from_hr + ":" + music_from_min
                        stem.m_start2 = None
                        stem.m_start3 = None
                        music_from_num += 1
                    elif music_from_num == 2:
                        stem.m_start2 = music_from_hr + ":" + music_from_min
                        stem.m_start3 = None
                        music_from_num += 1
                    elif music_from_num == 3:
                        stem.m_start3 = music_from_hr + ":" + music_from_min

                elif i[:11] == 'music_to_hr':
                    music_to_hr = request.form[i]
                elif i[:12] == 'music_to_min':
                    music_to_min = request.form[i]
                    if music_to_num == 1:
                        stem.m_end1 = music_to_hr + ":" + music_to_min
                        stem.m_end2 = None
                        stem.m_end3 = None
                        music_to_num += 1
                    elif music_to_num == 2:
                        stem.m_end2 = music_to_hr + ":" + music_to_min
                        stem.m_end3 = None
                        music_to_num += 1
                    elif music_to_num == 3:
                        stem.m_end3 = music_to_hr + ":" + music_to_min


            if 'camera-on' in request.form:
                stem.c_status = 1
            else:
                stem.c_status = 0


            if i[:9] == 'vibration':
                if v_num == 1:
                    stem.v_vol1 = request.form[i]
                    stem.v_vol2 = None
                    stem.v_vol3 = None
                    v_num += 1
                elif v_num == 2:
                    stem.v_vol2 = request.form[i]
                    stem.v_vol3 = None
                    v_num += 1
                elif v_num == 3:
                    stem.v_vol3 = request.form[i]
            else:
                if i[:9] == 'v_from_hr':
                    v_from_hr = request.form[i]

                elif i[:10] == 'v_from_min':
                    v_from_min = request.form[i]
                    if v_from_num == 1:
                        stem.v_start1 = v_from_hr + ":" + v_from_min
                        stem.v_start2 = None
                        stem.v_start3 = None
                        v_from_num += 1
                    elif v_from_num == 2:
                        stem.v_start2 = v_from_hr + ":" + v_from_min
                        stem.v_start3 = None
                        v_from_num += 1
                    elif v_from_num == 3:
                        stem.v_start3 = v_from_hr + ":" + v_from_min

                elif i[:7] == 'v_to_hr':
                    v_to_hr = request.form[i]
                elif i[:8] == 'v_to_min':
                    v_to_min = request.form[i]
                    if v_to_num == 1:
                        stem.v_end1 = v_to_hr + ":" + v_to_min
                        stem.v_end2 = None
                        stem.v_end3 = None
                        v_to_num += 1
                    elif v_to_num == 2:
                        stem.v_end2 = v_to_hr + ":" + v_to_min
                        stem.v_end3 = None
                        v_to_num += 1
                    elif v_to_num == 3:
                        stem.v_end3 = v_to_hr + ":" + v_to_min

            if i[:14] == 'tank1_duration':
                if tank1_num == 1:
                    liquid.tk1_duration1 = request.form[i]
                    liquid.tk1_duration2 = None
                    liquid.tk1_duration3 = None
                    tank1_num += 1
                elif tank1_num == 2:
                    liquid.tk1_duration2 = request.form[i]
                    liquid.tk1_duration3 = None
                    tank1_num += 1
                elif tank1_num == 3:
                    liquid.tk1_duration3 = request.form[i]
            else:
                if i[:13] == 'tank1_from_hr':
                    tk1_from_hr = request.form[i]

                elif i[:14] == 'tank1_from_min':
                    tk1_from_min = request.form[i]
                    if tank1_from_num == 1:
                        liquid.tk1_start1 = tk1_from_hr + ":" + tk1_from_min
                        liquid.tk1_start2 = None
                        liquid.tk1_start3 = None
                        tank1_from_num += 1
                    elif tank1_from_num == 2:
                        liquid.tk1_start2 = tk1_from_hr + ":" + tk1_from_min
                        liquid.tk1_start3 = None
                        tank1_from_num += 1
                    elif tank1_from_num == 3:
                        liquid.tk1_start3 = tk1_from_hr + ":" + tk1_from_min

                elif i[:11] == 'tank1_to_hr':
                    tk1_to_hr = request.form[i]
                elif i[:12] == 'tank1_to_min':
                    tk1_to_min = request.form[i]
                    if tank1_to_num == 1:
                        liquid.tk1_end1 = tk1_to_hr + ":" + tk1_to_min
                        liquid.tk1_end2 = None
                        liquid.tk1_end3 = None
                        tank1_to_num += 1
                    elif tank1_to_num == 2:
                        liquid.tk1_end2 = tk1_to_hr + ":" + tk1_to_min
                        liquid.tk1_end3 = None
                        tank1_to_num += 1
                    elif tank1_to_num == 3:
                        liquid.tk1_end3 = tk1_to_hr + ":" + tk1_to_min

            if i[:14] == 'tank2_duration':
                if tank2_num == 1:
                    liquid.tk2_duration1 = request.form[i]
                    liquid.tk2_duration2 = None
                    liquid.tk2_duration3 = None
                    tank2_num += 1
                elif tank2_num == 2:
                    liquid.tk2_duration2 = request.form[i]
                    liquid.tk2_duration3 = None
                    tank2_num += 1
                elif tank2_num == 3:
                    liquid.tk2_duration3 = request.form[i]
            else:
                if i[:13] == 'tank2_from_hr':
                    tk2_from_hr = request.form[i]
                elif i[:14] == 'tank2_from_min':
                    tk2_from_min = request.form[i]
                    if tank2_from_num == 1:
                        liquid.tk2_start1 = tk2_from_hr + ":" + tk2_from_min
                        liquid.tk2_start2 = None
                        liquid.tk2_start3 = None
                        tank2_from_num += 1
                    elif tank2_from_num == 2:
                        liquid.tk2_start2 = tk2_from_hr + ":" + tk2_from_min
                        liquid.tk2_start3 = None
                        tank2_from_num += 1
                    elif tank2_from_num == 3:
                        liquid.tk2_start3 = tk2_from_hr + ":" + tk2_from_min


                elif i[:11] == 'tank2_to_hr':
                    tk2_to_hr = request.form[i]
                elif i[:12] == 'tank2_to_min':
                    tk2_to_min = request.form[i]
                    if tank2_to_num == 1:
                        liquid.tk2_end1 = tk2_to_hr + ":" + tk2_to_min
                        liquid.tk2_end2 = None
                        liquid.tk2_end3 = None
                        tank2_to_num += 1
                    elif tank2_to_num == 2:
                        liquid.tk2_end2 = tk2_to_hr + ":" + tk2_to_min
                        liquid.tk2_end3 = None
                        tank2_to_num += 1
                    elif tank2_to_num == 3:
                        liquid.tk2_end3 = tk2_to_hr + ":" + tk2_to_min

            if i == 'root-color':
                try:
                    color = request.form['root-color']
                    root.l_r, root.l_g, root.l_b = color.split(',')[0], color.split(',')[1][1:], color.split(',')[2][1:]
                except Exception:
                    pass

            if i == 'stem-color':
                try:
                    color = request.form['stem-color']
                    stem.l_r, stem.l_g, stem.l_b = color.split(',')[0], color.split(',')[1][1:], color.split(',')[2][1:]
                except Exception:
                    pass

        stem.l_bright_vol = request.form['stem-bright-vol']
        root.l_bright_vol = request.form['root-bright-vol']

        stem.m_vol = request.form['m-vol']
        stem.c_duration = request.form['c-duration']

        stem.v_power = request.form['v-pow']




        db.session.add(stem)
        db.session.add(root)
        db.session.commit()


        return redirect('/online_fitolab')


#退出的訪問路徑
@main.route('/logout')
def logout_views():
    if 'id' in session and 'uname' in session:
        del session['id']
        del session['uname']
    return redirect('/')