
    وh                        d dl mZmZ d dlmZ d dlmZ d dlmZm	Z	m
Z
mZ d dlmZ d dlmZmZ d dlmZ d dlZ ed	d
g      Zej+                  d       ee      fdedefd       Zej+                  d       ee      fdedefd       Zej1                  d       ee      fdedefd       Zej7                  d       ee      fdedefd       Zej+                  d       ee      fdede	defd       Zej1                  d       ee      fdedefd       Zej1                  d       ee      fdefd       Zej1                  d       ee      fdefd        Zy)!    )	APIRouterDepends)get_db)Session)CustomerUpdateCustomer	UserLoginCustomerList)CustomerClass)CustomerModelCustomer2Model)get_current_active_userNz
/customers	Customers)prefixtags/customerdbc                 h    t        |      j                  | j                  | j                        }d|iS Nmessage)r   get_allrutpage)r   r   datas      I/var/www/intrajisbackend.com/public_html/app/backend/routers/customers.pyindexr      s.     $$X\\8==ADt    z/storecustomer_inputsc                 >    t        |      j                  |       }d|iS r   )r   store)r   r   r   s      r   r!   r!      s"    ""?3Dtr   z
/edit/{id}idc                 >    t        |      j                  |       }d|iS r   )r   getr"   r   r   s      r   editr&      s"      $Dtr   z/delete/{id}c                 >    t        |      j                  |       }d|iS r   )r   deleter%   s      r   r(   r(   "   s"    ##B'Dtr   z/update/{id}c                 @    t        |      j                  | |      }d|iS r   )r   update)r"   r   r   r   s       r   r*   r*   (   s$    ##B1Dtr   z/existence/{rut}r   c                 >    t        |      j                  |       }d|iS r   )r   check_existence)r   r   r   s      r   r&   r&   .   s"    ,,S1Dtr   z/insert_customersc                    t        j                  ddddt         j                  j                        }|j	                         5 }|j                  d       |j                         }|D ]  }|d   }|d   }|d	   }|d
   }|d   }	|d   }
|d   }|d   }t        |||||	|
||       | j                  t              j                  t        j                  |k(        j                         }|dk(  rOt        |||||	|
j                         ||      }| j                  |       | j!                          t        d|       t        d|        	 d d d        |j#                          diS # 1 sw Y   xY wNzjisparking.comjysparki_adminz
Admin2024$jysparki_jis)hostuserpasswordr   cursorclassz
            SELECT 
               customers.*,
                users.names
            FROM customers LEFT JOIN users ON customers.rut = users.rut
        r   emailphone	region_id
commune_idnamesactivityaddressr   )r   r5   r6   r7   r8   r   r:   r;   zCliente guardado:zEl cliente ya existe:r   pymysqlconnectcursors
DictCursorcursorexecutefetchallprintqueryr   filterr   countr   upperaddcommitcloser   connrA   resultrowr   r5   r6   r7   r8   r9   r:   r;   r   new_customers                  r   old_dtesrQ   4   z   ??OO..D 
 $4&  	 " 	4Ce*CLELEK(I\*JLE:H)nG#ueY
E8WUxx.55m6G6G36NOUUWH1}-')"[[]%#	  |$		)3/-s37	4$4L 	JJLFQ$4 $4   DE&&E/z/old_customersc                    t        j                  ddddt         j                  j                        }|j	                         5 }|j                  d       |j                         }|D ]  }|d   }|d   }|d	   }|d
   }|d   }	|d   }
|d   }|d   }t        |||||	|
||       | j                  t              j                  t        j                  |k(        j                         }|dk(  rOt        |||||	|
j                         ||      }| j                  |       | j!                          t        d|       t        d|        	 d d d        |j#                          diS # 1 sw Y   xY wr.   r<   rL   s                  r   rQ   rQ   h   rR   rS   )fastapir   r   app.backend.db.databaser   sqlalchemy.ormr   app.backend.schemasr   r   r	   r
   "app.backend.classes.customer_classr   app.backend.db.modelsr   r   app.backend.auth.auth_userr   r=   	customerspostr   r!   r$   intr&   r(   r*   strrQ    r   r   <module>ra      s   & * " Q Q < ? > 
	
 07 L g   29&/ (   
 | ' S g  
 .!!( c w  "
 <CFO s n '   
 !"!( c w  #
 "#"6? 1 1 $1f  "6? 1 1 !1r   