from app import app, db
from app.forms import SearchCCForm, SearchNOForm, SearchMACForm, SearchSNForm, LoginForm, insPIN, genLic, SearchLicenze
from flask import render_template, flash, redirect, url_for, request
from app.models import User, PIN, lic_cli, lic_oem
from app.insert import insert_pin, salva_files
from flask_login import login_user, logout_user, current_user, login_required
import sqlalchemy as sa
import app.search as appS

@app.route('/', methods=['GET', 'POST'])
@app.route('/index', methods=['GET', 'POST'])
@login_required
def index():
    formCC = SearchCCForm()
    formNO = SearchNOForm()
    formMAC = SearchMACForm()
    formSN = SearchSNForm()
    if formCC.validate_on_submit():
        return render_template('index.html', formCC=formCC, formNO=formNO, formMAC=formMAC, formSN=formSN, content="codcli", codcliente=formCC.codcliente.data)
    if formNO.validate_on_submit():
        return render_template('index.html', formCC=formCC, formNO=formNO, formMAC=formMAC, formSN=formSN, content="numord", numord=formNO.numord.data)
    if formMAC.validate_on_submit():
        return render_template('index.html', formCC=formCC, formNO=formNO, formMAC=formMAC, formSN=formSN, content="macadd", macadd=formMAC.macadd.data)
    if formSN.validate_on_submit():
        return render_template('index.html', formCC=formCC, formNO=formNO, formMAC=formMAC, formSN=formSN, content="sernum", sernum=formSN.sernum.data, modello=formSN.modello.data)
    return render_template('index.html', formCC=formCC, formNO=formNO, formMAC=formMAC, formSN=formSN, content=None)

@app.route('/login', methods=['GET', 'POST'])
def login():
    if current_user.is_authenticated:
        return redirect(url_for('index'))
    form = LoginForm()
    if form.validate_on_submit():
        user = db.session.scalar(sa.select(User).where(User.username == form.username.data))
        if user is None or not user.check_password(form.password.data):
            flash('Nome utente o password errati')
            return redirect(url_for('login'))
        login_user(user, remember=form.remember_me.data)
        return redirect(url_for('index'))
    return render_template('login.html', title='Sign In', form=form)
    
@app.route('/register', methods=['GET', 'POST'])
def register():
    if current_user.is_authenticated:
        return redirect(url_for('index'))
    form = RegistrationForm()
    if form.validate_on_submit():
        user = User(name=form.name.data, surname=form.surname.data, username=form.username.data, email=form.email.data)
        user.set_password(form.password.data)
        db.session.add(user)
        db.session.commit()
        flash('Registrazione effettuata!')
        return redirect(url_for('login'))
    return render_template('register.html', title='Register', form=form)
    
@app.route('/reset_password_request', methods=['GET', 'POST'])
def reset_password_request():
    if current_user.is_authenticated:
        return redirect(url_for('index'))
    form = ResetPasswordRequestForm()
    if form.validate_on_submit():
        user = db.session.scalar(
            sa.select(User).where(User.email == form.email.data))
        if user:
            send_password_reset_email(user)
        flash('Controlla la tua mail per avere istruzioni su come procedere.')
        return redirect(url_for('login'))
    return render_template('reset_password_request.html',
                           title='Reset Password', form=form)

@app.route('/reset_password/<token>', methods=['GET', 'POST'])
def reset_password(token):
    if current_user.is_authenticated:
        return redirect(url_for('index'))
    user = User.verify_reset_password_token(token)
    if not user:
        return redirect(url_for('index'))
    form = ResetPasswordForm()
    if form.validate_on_submit():
        user.set_password(form.password.data)
        db.session.commit()
        flash('Your password has been reset.')
        return redirect(url_for('login'))
    return render_template('reset_password.html', form=form)

@app.route('/logout')
def logout():
    logout_user()
    return redirect(url_for('index'))
    
@app.route('/stat')
@login_required
def stat():
    tot = PIN.tot_pin(PIN)
    lista = PIN.cod_desc_num(PIN)
    return render_template('stat.html', tot=tot, lista=lista)

@app.route('/pin', methods=['GET', 'POST'])
@login_required
def pin():
    formPIN = insPIN()
    if formPIN.validate_on_submit():
        app.logger.info('Sono nel IF')
        cliente = formPIN.crea_cliente()
        app.logger.info('Ho creato il cliente')
        app.logger.info('Ho letto i files %s  ', formPIN.filePIN.data)
        files = salva_files(formPIN.filePIN.data)
        app.logger.info('Ho salvato i files %s', files)
        app.logger.info('Chiamo insert_pin')
        res = insert_pin(cliente, files)
        return render_template('pin_result.html', cliente=cliente, res=res)
    return render_template('pin.html', formPIN=formPIN)

@app.route('/lic')
@login_required
def lic():
    formLic = genLic()
    return render_template('lic.html', formLic=formLic)

@app.route('/orf')
@login_required
def orf():
    res = PIN.stampa_orfani(PIN)
    return render_template('orf.html', res=res)

@app.route('/codcli/<codcliente>')
@login_required
def codcli(codcliente):
    res = appS.SearchFromCodCli(codcliente)
    return render_template('codcli.html', r=res, content=None)

@app.route('/macadd/<macadd>')
@login_required
def macadd(macadd):
    res = appS.SearchFromMac(macadd)
    return render_template('macadd.html', r=res, content=None)

@app.route('/licenze/<macPBX>')
@login_required
def licenze():
    
    return render_template('licenze.html', result=result)


@app.route('/numord/<numord>')
@login_required
def numord(numord):
    res = appS.SearchFromNO(numord)
    return render_template('numord.html', r=res, content=None)

    

    
@app.route('/sernum/<sernum>?<modello>')
@login_required
def sernum(sernum,modello):
    res = appS.SearchFromSN(sernum,modello)
    return render_template('sernum.html', r=res, content=None)