# login
@app.route("/login", methods=['GET', 'POST'])
@mobile_template('/login')
def login(template):
        if not session_exist('username'):
            if session.get('level') == 'admin':
                return redirect(url_for('wellcom_admin'))
            else:
                return redirect(url_for('wellcom_user'))
        else:
            if request.method == 'POST':
                password = encrypt.encryptpassword(request.form['password'], 'alaa')
                username = request.form['username']
                ipd = request.environ.get('HTTP_X_FORWARDED_FOR') or request.environ.get('REMOTE_ADDR')
                error='soory!! plase cheack username or password'
                conn = db.create_connection(database)
                try:
                    with conn:
                        db.select_data(conn,'*', 'lada', "ldate = '{}' and username = '{}'"
                          .format(lastu, password),fetchall=False)
                        data = db.select_data(conn,'*', 'mydata', "username = '{}' and password = '{}'"
                          .format(username, password), fetchall=False)
                        if data:
                            session['username'] = username
                            session['userid'] = data[0]
                            db.update_data(conn,'mydata', "ip = '{}' ,session = '{}'".format(ipd,session['username']), "username = '{}'".format(session['username']))
                            if data[10] == "admin":
                                return redirect(url_for('wellcom_admin'))
                            elif data[10] == "twitter" or data[10] == "gmail" or data[10] == "facebook" or data[10] == "user":
                                if data[13] == 'doctor':
                                    return redirect(url_for("wellcom_doctor"))
                                else:
                                    return redirect(url_for("wellcom_user"))
                            else:
                                return render_template('login.html',error=" soory!! plase cheack usernam or password")
                        else:
                            return render_template('login.html', error=error)
                except Exception as e:
                    print("Something went wrong, Details: {}".format(e))
                finally:
                    conn.close()
            else:
                return render_template('login.html')
#wellcom_user
@app.route("/login/wellcom_user", methods=['GET', 'POST'])
@mobile_template('/login/wellcom_user')
def wellcom_user(template):
    conn = db.create_connection(database)
    try:
        print(session)
        with conn:

            db.select_data(conn, '*', 'lada', "username = '{}'".format(session['username']),fetchall=False)
            data = db.select_data(conn, '*', 'mydata', "username = '{}'".format(session['username']),fetchall=False)
            db.update_data(conn, 'lada', "ldate = '{}'".format(lastu),"username = '{}'".format(session['username']))
            return render_template("wellcom_user.html", data=data)
    except Exception as e:
        print("Something went wrong, Details: {}".format(e))
        flash('Something went wrong, Details: {}'.format(e))
        return render_template('login.html')
    finally:
        conn.close()
#wellcom_admin
@app.route("/login/wellcom_admin", methods=['GET', 'POST'])
@mobile_template('/login/wellcom_admin')
def wellcom_admin(template):
    conn = db.create_connection(database)
    try:
        with conn:
            data = db.select_data(conn, '*', 'mydata',None,fetchall=True)
            se = db.select_data(conn, 'COUNT(*)', 'mydata', None, fetchall=False)
            for a in se:
                return render_template("wellcom_admin.html", data=data,a=a)
    except Exception as e:
        print("Something went wrong, Details: {}".format(e))
    finally:
        conn.close()
#wellcom_doctor
@app.route("/login/wellcom_doctor", methods=['GET', 'POST'])
@mobile_template('/login/wellcom_doctor')
def wellcom_doctor(template):
    conn = db.create_connection(database)
    try:
        with conn:
            data=db.select_data(conn, '*', 'mydata',"username = '{}'".format(session['username']),fetchall=False)
            db.update_data(conn, 'lada', "ldate = '{}'".format(lastu),
                           "username = '{}'".format(session['username']))
            return render_template("wellcom_user_doctor.html", data=data)
    except Exception as e:
        print("Something went wrong, Details: {}".format(e))
    finally:
        conn.close()