3
*gc                 @   sl   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mZ dd Zdd Zdd Zd	d
 ZdS )    )SearchCCFormSearchNOFormSearchMACFormSearchSNForm	LoginForminsPINgenLicSearchLicenze)UserPINlic_clilic_oemlicenzePBXc             C   s   t jt | }|g kr|d j|d j|d j|d jg}i }g }x|D ]}tjt|jd }yD||j	 }|j
|j|j|j|j|j	|j|jf |j|j	|i W qF   |j|j|j|j|j	|j|jfg||j	< Y qFX qFW ||fS d S )Nr   )r   search_codclicod_cliragsocnomecognomer   search_codFcodLicmacPBXappenddataordinecodPBX	serialPBXcodFitredesFitreupdate)
codclientelista_ordiniclienteresultnowr   licenza r&    /data/www/html/LML/app/search.pySearchFromCodCli   s    $

&2r(   c             C   s   t jt | }|g kr|d j|d j|d j|d jg}i }g }x|D ]}tjt|jd }yD||j	 }|j
|j|j|j|j|j	|j|jf |j|j	|i W qF   |j|j|j|j|j	|j|jfg||j	< Y qFX qFW ||fS d S )Nr   )r   
search_macr   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   )macaddr!   r"   r#   r$   r   r%   r&   r&   r'   SearchFromMac   s    $

&2r+   c             C   s   t jt | }|g kr|d j|d j|d j|d jg}i }g }x|D ]}tjt|jd }yD||j	 }|j
|j|j|j|j|j	|j|jf |j|j	|i W qF   |j|j|j|j|j	|j|jfg||j	< Y qFX qFW ||fS d S )Nr   )r   search_ordiner   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   )numordr!   r"   r#   r$   r   r%   r&   r&   r'   SearchFromNO(   s    $

&2r.   c             C   s   t jt | |}|g kr|d j|d j|d j|d jg}i }g }x|D ]}tjt|jd }yD||j	 }|j
|j|j|j|j|j	|j|jf |j|j	|i W qH   |j|j|j|j|j	|j|jfg||j	< Y qHX qHW ||fS d S )Nr   )r   
search_snmr   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   )sernummodellor!   r"   r#   r$   r   r%   r&   r&   r'   SearchFromSN9   s    $

&2r2   N)	app.formsr   r   r   r   r   r   r   r	   
app.modelsr
   r   r   r   r   r   r(   r+   r.   r2   r&   r&   r&   r'   <module>   s
   ( 