3
)g                 @   s"  d dl m Z mZ d dlmZmZmZmZmZmZm	Z	m
Z
 d dlmZmZmZmZmZ d dlmZmZmZmZ d dlmZmZ d dlmZmZmZmZ d dlZd dl j!Z"e j#dd	d
gde j#dd	d
gdedd Z$e j#dd	d
gddd Z%e j#dd	d
gddd Z&e j#dd	d
gddd Z'e j#dd	d
gddd Z(e j#ddd Z)e j#dedd  Z*e j#d!d	d
gded"d# Z+e j#d$ed%d& Z,e j#d'ed(d) Z-e j#d*ed+d, Z.e j#d-ed.d/ Z/e j#d0ed1d2 Z0e j#d3ed4d5 Z1e j#d6ed7d8 Z2dS )9    )appdb)SearchCCFormSearchNOFormSearchMACFormSearchSNForm	LoginForminsPINgenLicSearchLicenze)render_templateflashredirecturl_forrequest)UserPINlic_clilic_oem)
insert_pinsalva_files)
login_userlogout_usercurrent_userlogin_requiredN/GETPOST)methodsz/indexc           
   C   s   t  } t }t }t }| j r:td| |||d| jjdS |j r\td| |||d|jjdS |j r~td| |||d|j	jdS |j rtd| |||d|j
j|jjd	S td| |||d d
S )Nz
index.htmlcodcli)formCCformNOformMACformSNcontent
codclientenumord)r    r!   r"   r#   r$   r&   macadd)r    r!   r"   r#   r$   r'   sernum)r    r!   r"   r#   r$   r(   modello)r    r!   r"   r#   r$   )r   r   r   r   validate_on_submitr   r%   datar&   r'   r(   r)   )r    r!   r"   r#    r,    /data/www/html/LML/app/routes.pyindex
   s     r.   z/loginc              C   s   t jrttdS t } | j rtjjt	j
tjtj| jjk}|d ksZ|j| jj rntd ttdS t|| jjd ttdS tdd| dS )Nr.   zNome utente o password erratilogin)rememberz
login.htmlzSign In)titleform)r   is_authenticatedr   r   r   r*   r   sessionscalarsaselectr   whereusernamer+   Zcheck_passwordpasswordr   r   Zremember_mer   )r2   userr,   r,   r-   r/      s    "r/   z	/registerc              C   s   t jrttdS t } | j rxt| jj| j	j| j
j| jjd}|j| jj tjj| tjj  td ttdS tdd| dS )Nr.   )namesurnamer9   emailzRegistrazione effettuata!r/   zregister.htmlZRegister)r1   r2   )r   r3   r   r   ZRegistrationFormr*   r   r<   r+   r=   r9   r>   set_passwordr:   r   r4   addcommitr   r   )r2   r;   r,   r,   r-   register*   s     
rB   z/reset_password_requestc              C   sp   t jrttdS t } | j rbtjjt	j
tjtj| jjk}|rNt| td ttdS tdd| dS )Nr.   z=Controlla la tua mail per avere istruzioni su come procedere.r/   zreset_password_request.htmlzReset Password)r1   r2   )r   r3   r   r   ZResetPasswordRequestFormr*   r   r4   r5   r6   r7   r   r8   r>   r+   Zsend_password_reset_emailr   r   )r2   r;   r,   r,   r-   reset_password_request8   s    rC   z/reset_password/<token>c             C   sr   t jrttdS tj| }|s,ttdS t }|j rf|j|j	j
 tjj  td ttdS td|dS )Nr.   zYour password has been reset.r/   zreset_password.html)r2   )r   r3   r   r   r   Zverify_reset_password_tokenZResetPasswordFormr*   r?   r:   r+   r   r4   rA   r   r   )tokenr;   r2   r,   r,   r-   reset_passwordG   s    

rE   z/logoutc               C   s   t   ttdS )Nr.   )r   r   r   r,   r,   r,   r-   logoutV   s    rF   z/statc              C   s"   t jt } t jt }td| |dS )Nz	stat.html)totlista)r   Ztot_pinZcod_desc_numr   )rG   rH   r,   r,   r-   stat[   s    

rI   z/pinc              C   s   t  } | j r~tjjd | j }tjjd tjjd| jj t| jj}tjjd| tjjd t	||}t
dttdS t
d| d	S )
NzSono nel IFzHo creato il clientezHo letto i files %s  zHo salvato i files %szChiamo insert_pinz	stat.html)rG   rH   zpin.html)formPIN)r	   r*   r   loggerinfoZcrea_clienteZfilePINr+   r   r   r   rG   rH   )rJ   Zclientefilesresr,   r,   r-   pinb   s    
rO   z/licc              C   s   t  } td| dS )Nzlic.html)formLic)r
   r   )rP   r,   r,   r-   licr   s    rQ   z/orfc              C   s   t jt } td| dS )Nzorf.html)rN   )r   Zstampa_orfanir   )rN   r,   r,   r-   orfx   s    
rR   z/codcli/<codcliente>c             C   s   t j| }td|d dS )Nzcodcli.html)rr$   )appSZSearchFromCodClir   )r%   rN   r,   r,   r-   r   ~   s    
r   z/macadd/<macadd>c             C   s   t j| }td|d dS )Nzmacadd.html)rS   r$   )rT   ZSearchFromMacr   )r'   rN   r,   r,   r-   r'      s    
r'   z/licenze/<macPBX>c               C   s   t dtdS )Nzlicenze.html)result)r   rU   r,   r,   r,   r-   licenze   s    rV   z/numord/<numord>c             C   s   t j| }td|d dS )Nznumord.html)rS   r$   )rT   ZSearchFromNOr   )r&   rN   r,   r,   r-   r&      s    
r&   z/sernum/<sernum>?<modello>c             C   s   t j| |}td|d dS )Nzsernum.html)rS   r$   )rT   ZSearchFromSNr   )r(   r)   rN   r,   r,   r-   r(      s    r(   )3r   r   Z	app.formsr   r   r   r   r   r	   r
   r   flaskr   r   r   r   r   
app.modelsr   r   r   r   Z
app.insertr   r   flask_loginr   r   r   r   
sqlalchemyr6   Z
app.searchsearchrT   router.   r/   rB   rC   rE   rF   rI   rO   rQ   rR   r   r'   rV   r&   r(   r,   r,   r,   r-   <module>   sB   (
