from flask import Flask, render_template, request, session,redirect, url_for
import os.path
from encrypt import encryptprepassword,encryptpassword
import hashlib,binascii
app = Flask(__name__)
app.secret_key = "hussain"
BASE_DIR = os.path.dirname(os.path.abspath(__file__))
db_path = os.path.join(BASE_DIR, "alaa1.db")
import sqlite3
conn = sqlite3.connect(db_path)
conn.row_factory = sqlite3.Row
cursor = conn.cursor()
@app.route("/",methods=['GET','POST'])
def index():
        return render_template("index.html")
@app.route("/login",methods=['GET','POST'])
def login():
    if request.method == 'POST':
        password = encryptpassword(request.form['password'], 'alaa')
        username = request.form['username']
        cursor.execute("SELECT * FROM mydata WHERE username=? AND password=?", (username,password,))
        data = cursor.fetchone()
        dataa = {'username': username}
        if data:
            session['username'] = username
            session['userid'] = data[0]
            if data[10] == "4":
                cursor.execute("SELECT * FROM mydata")
                data = cursor.fetchall()
                res = len(data)
                context = {'res': res, 'data': data}
                conn.commit()
                return render_template('wellcom.html', data=data, dataa=dataa, context=context)
            else:
                conn.commit()
                return render_template('wellcom.html', data=data)
        else:
            return render_template('login.html', error=" soory!! plase cheack usernam or password")
    else:
        return render_template('login.html')
@app.route("/logout")
def logout():
    session.clear()
    return redirect(url_for('index'))
@app.route("/sign",methods=['GET','POST'])
def sign():
    if request.method == 'POST':
        username = request.form['username']
        password = encryptpassword(request.form['password'], 'alaa')
        prepassword = encryptprepassword(request.form['prepassword'], 'alaa')
        namee = request.form['namee']
        email= request.form['email']
        phone = request.form['phone']
        gender = request.form['gender']
        nationality =request.form['nationality']
        datee = request.form['datee']
        cursor.execute('''SELECT * FROM mydata WHERE username=(?)''',(username,))
        use=cursor.fetchone()
        cursor.execute('''SELECT * FROM mydata WHERE email=(?)''',(email,))
        em= cursor.fetchone()
        cursor.execute('''SELECT * FROM mydata WHERE phone=(?)''',(phone,))
        pho= cursor.fetchone()
        datau = {'username': username,'password': password,'prepassword': prepassword,'email': email,'phone': phone,'namee': namee,'gender':
            gender,'nationality': nationality,'datee':datee}
        no = 'password not same prepassword!!'
        ero = "Please"
        if use is None and em is None and pho is None:
            cursor.execute("INSERT INTO mydata(username, password, prepassword, namee,email, phone, gender, nationality, datee)""VALUES"
                "(?,?,?,?,?,?,?,?,?)",(username, password, prepassword, namee, email, phone, gender, nationality,datee,))
            if not password == prepassword :
                return render_template('sign.html', no=no)
            else:
                conn.commit()
                return render_template('wellcom.html', datau=datau)
        else:
            return render_template('sign.html', ero=ero)
    else:
        return render_template("sign.html")
@app.route("/update_1",methods=['POST','GET'])
def up():
    username = request.form['username']
    password = encryptpassword(request.form['password'], 'alaa')
    prepassword = encryptprepassword(request.form['prepassword'], 'alaa')
    email = request.form['email']
    try:
        cursor.execute("UPDATE mydata SET username=? , password=? , prepassword=? ,email=?  where username=?",
                       ( username,password, prepassword ,email,session['username']))
        if password == prepassword:
            conn.commit()
            return render_template("test.html", msg="done")
        else:
            return render_template("test.html", msg="eroo")
    except:
        return render_template("test.html",msg="error")
@app.route("/update",methods=['GET','POST'])
def update():
    cursor.execute('SELECT * from mydata where id=?', (session['userid'],))
    all = cursor.fetchone()
    return render_template('update.html', all=all)
@app.route("/delet",methods=['GET','POST'])
def delet():
    if request.method == 'POST':
        username = request.form['username']
        password = encryptpassword(request.form['password'], 'alaa')
        cursor.execute("SELECT * FROM mydata WHERE username=(?) AND password=(?)", (username, password,))
        dell=cursor.fetchone()
        error = 'deleted'
        n='not delet'
        if dell is not None:
            cursor.execute('''DELETE FROM mydata WHERE username=(?)''',(username,))
            conn.commit()
            return render_template('delet.html', error=error)
        else:
            return render_template('delet.html',n=n)
    else:
        return render_template('delet.html')
@app.route("/forgot",methods=['GET','POST'])
def forget():
    if request.method == 'POST':
        username = request.form['username']or None
        email = request.form['email']or None
        password = request.form['password']or None
        prepassword = request.form['prepassword'] or None
        enc_password = encryptpassword(password, 'alaa')
        cursor.execute('''SELECT * FROM mydata WHERE username=(?)''', (username,))
        use = cursor.fetchone()
        cursor.execute('''SELECT * FROM mydata WHERE email=(?)''', (email,))
        em = cursor.fetchone()
        da = {'username': username, 'password': password, 'email':email}
        if use is None and em is None:
            cursor.execute('''UPDATE mydata SET password = ? , prepassword = ? WHERE id=?''',(id,enc_password,enc_prepassword,))
            if not password == prepassword:
                return render_template('forgot.html')
            else:
                conn.commit()
                return render_template('forgot.html', da=da)
        else:
            return render_template('forgot.html')
    else:
        return render_template('forgot.html')
if __name__ == '__main__':
    app.run(debug=True)