
    e3j'                     |   S SK Jr  S SKJrJrJrJrJrJrJ	r	J
r
JrJrJrJrJrJrJr  S SKJr  S SKJr   " S S\5      r " S S\5      r " S	 S
\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r  " S S\5      r! " S S \5      r" " S! S"\5      r# " S# S$\5      r$ " S% S&\5      r% " S' S(\5      r& " S) S*\5      r' " S+ S,\5      r( " S- S.\5      r) " S/ S0\5      r* " S1 S2\5      r+ " S3 S4\5      r,g5)6    )Base)ColumnInteger
BigIntegerStringDateTimeDateTime
ForeignKeyFloatBooleanTextNumericEnumUniqueConstraintselect)column_property)datetimec                   v    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)AccountTypeModel   account_typesTprimary_key    N)__name__
__module____qualname____firstlineno____tablename__r   r   idr   account_typer   
added_dateupdated_date__static_attributes__r       RC:\Users\jesus\Desktop\proyecto_pie360\backend\app\backend\db\models\erp_legacy.pyr   r      9    #M	T	*B&+&L
#J(*%Lr'   r   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \" S5      5      r
\" \" S5      5      r\" \" 5       5      rSrg)SettingModel   settingsTr   r   r   N)r   r   r   r    r!   r   r   r"   r   company_emailcompany_phonecompany_whatsappr   r%   r&   r   r'   r(   r+   r+      sJ    M	T	*B6#;'M6#;'MfSk*(*%Lr'   r+   c                      \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \5      r
\" \5      r\" \" S5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" 5       5      r\" \" SS5      5      r\" \5      r\" \" SS5      5      r \" \5      r!\" \" SS5      5      r"\" \" 5       5      r#\" \$" 5       5      r%\" \$" 5       5      r&\" \5      r'S	r(g
)ShoppingModel   	shoppingsTr   d   r   
      r   N))r   r   r   r    r!   r   r   r"   r   shopping_numbersupplier_id	status_idemailr   totalmaritime_freightmerchandise_insurancemanifest_openingdeconsolidationland_freightport_charges
honorariesphysical_assessment_expensesadministrative_expensesdollar_valuefolder_processingvalija_expensesr   customs_company_supportwire_transfer_amountr	   wire_transfer_date
commissionexchange_rateextra_expensespayment_supportr   r$   r%   prepaid_status_idr&   r   r'   r(   r2   r2      s   M	T	*BVC[)O/KwI6#;E72q>"Egb!n-"72q>2gb!n-WR^,O'"a.)L'"a.)LA'J#)'"a.#9 $WR^4'"a.)Lwr1~.WR^,O$TVn!'"a.1A'J7OMGBN+NTVnO
#J(*%L wr'   r2   c                   "   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \" SS5      5      r\" \" SS5      5      r\" \5      r\" \" SS5      5      r\" \" SS5      5      r\" \" 5       5      r\" \" 5       5      rSrg)	ShoppingProductModel9   shoppings_productsTr   r6   r7   r   N)r   r   r   r    r!   r   r   r"   shopping_id
product_idunit_measure_idquantityr   quantity_per_packageoriginal_unit_costdiscount_percentagefinal_unit_costamountr   r$   r%   r&   r   r'   r(   rR   rR   9   s    (M	T	*B/KJWoOgH!'"a.1A/ /WR^,OGBN#F
#J(*%Lr'   rR   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \" S5      5      r
\" \" 5       5      r\" \" 5       5      r\" \" 5       5      rSrg)SupplierModelI   	suppliersTr   r   r   N)r   r   r   r    r!   r   r   r"   r   identification_numbersupplierr   addressr   r$   r%   r&   r   r'   r(   r_   r_   I   sS    M	T	*B"6#;/fSk"HTVnG
#J(*%Lr'   r_   c                   v    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)UnitMeasureModelS   unit_measuresTr   r   r   N)r   r   r   r    r!   r   r   r"   r   unit_measurer   r$   r%   r&   r   r'   r(   rf   rf   S   r)   r'   rf   c                   >   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \SS9r\" \5      r\" \5      r\" \SS9r\" \5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       \R.                  S9r\" \" 5       \R.                  S9rSrg)		SaleModel[   salesTr   r   defaultr   N)r   r   r   r    r!   r   r   r"   customer_idshipping_method_iddte_type_idr:   folior   subtotaltaxshipping_costr<   r   rO   delivery_addressr   r   nowr$   r%   r&   r   r'   r(   rk   rk   [   s    M	T	*B/K/KwI7A&Ee}H
-C5!,M5METVnOdf~
HLL9J(*hll;Lr'   rk   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      r\" \5      rSrg)SaleProductModelm   sales_productsTr   r   N)r   r   r   r    r!   r   r   r"   sale_idrV   inventory_movement_idinventory_idlot_item_idrX   pricer&   r   r'   r(   rz   rz   m   sS    $M	T	*BWoGJ"7O'?L/KgH7OEr'   rz   c                   v    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)LocationModely   	locationsTr   r   r   N)r   r   r   r    r!   r   r   r"   r   locationr   r$   r%   r&   r   r'   r(   r   r   y   s9    M	T	*BfSk"H
#J(*%Lr'   r   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \" S5      5      r
\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)CategoryModel   
categoriesTr   r   r   N)r   r   r   r    r!   r   r   r"   r   categorypublic_namecolorr   r$   r%   r&   r   r'   r(   r   r      sU     M	T	*BfSk"H%K6#;E
#J(*%Lr'   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)LiterFeatureModel   liter_featuresTr   r   r   N)r   r   r   r    r!   r   r   r"   rV   rY   quantity_per_palletr   weight_per_literweight_per_palletr   r$   r%   r&   r   r'   r(   r   r      sf    $M	T	*BJ!'? /fSk*vc{+
#J(*%Lr'   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)PreInventoryStockModel   pre_inventory_stocksTr   r   N)r   r   r   r    r!   r   r   r"   rV   rU   
lot_numberstockr   r$   r%   r&   r   r'   r(   r   r      sO    *M	T	*BJ/KJ7OE
#J(*%Lr'   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)UnitFeatureModel   unit_featuresTr   r   r   N)r   r   r   r    r!   r   r   r"   rV   rY   r   r   weight_per_unitr   r   r$   r%   r&   r   r'   r(   r   r      se    #M	T	*BJ!'? /VC[)Ovc{+
#J(*%Lr'   r   c                      \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \5      r\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)ProductModel   productsTr   r   r   N)r   r   r   r    r!   r   r   r"   r9   category_idrW   r   codeproductr   rZ   r[   r\   short_descriptiondescriptionphotocatalogis_compoundcompound_product_idr   r$   r%   r&   r   r'   r(   r   r      s    M	T	*B/K/KWoO&+DVC[!G .TVnOtv.K46NETVnG/K /
#J(*%Lr'   r   c                   V    \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
Srg)CustomerProductDiscountModel   customers_products_discountsTr   r   N)r   r   r   r    r!   r   r   r"   rp   rV   r[   r&   r   r'   r(   r   r      s/    2M	T	*B/KJ /r'   r   c                       \ rS rSrSr\" \SSS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)InventoryModel   inventoriesTr   autoincrementr   N)r   r   r   r    r!   r   r   r"   rV   location_idminimum_stockmaximum_stockr   last_updater$   r&   r   r'   r(   r   r      sQ    !M	T	>BJ/K7OM7OM$K
#Jr'   r   c                       \ rS rSrSr\" \SSS9r\" \5      r\" \	" S5      5      r
\" \" 5       5      r\" \" 5       5      r\" \" 5       5      rSrg)LotModel   lotsTr   r   r   N)r   r   r   r    r!   r   r   r"   r9   r   r   r	   arrival_dater   r$   r%   r&   r   r'   r(   r   r      sO    M	T	>B/Ks$J$&>L
#J(*%Lr'   r   c                       \ rS rSrSr\" \SSS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)LotItemModel   	lot_itemsTr   r   N)r   r   r   r    r!   r   r   r"   lot_idrV   rX   	unit_costpublic_sale_priceprivate_sale_pricer   r$   r%   r&   r   r'   r(   r   r      se    M	T	>BG_FJgHwIw
#J(*%Lr'   r   c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)	InventoryLotItemModel   inventories_lotsTr   inventories.idzlots.idr   N)r   r   r   r    r!   r   r   r"   r   r   r   rX   r   r$   r%   r&   r   r'   r(   r   r      sY    &M	T	>B':.>#?@L*Y"78KgH
#J(*%Lr'   r   c                   x    \ rS rSrSr\" \SSS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)MovementTypeModel   movement_typesTr   r   r   N)r   r   r   r    r!   r   r   r"   r   movement_typer   r$   r%   r&   r   r'   r(   r   r      s;    $M	T	>B6#;'M
#J(*%Lr'   r   c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \\" S5      5      r\" \5      r\" \5      r\" \" 5       5      r\" \" 5       5      rSrg	)
InventoryMovementModelr   inventories_movementsTr   r   zlot_items.idzmovement_types.idr   N)r   r   r   r    r!   r   r   r"   r   r   r   movement_type_idrX   r   r   reasonr   r$   r&   r   r'   r(   r   r      st    +M	T	>B':.>#?@L*^"<=Kgz2E'FGgHwIDF^F
#Jr'   r   c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \5      r\" \5      r\" \" 5       5      r\" \" 5       \R"                  S9rSrg	)
InventoryAuditModeli  inventories_auditsTr   zusers.idr   rn   r   N)r   r   r   r    r!   r   r   r"   r   user_idr   previous_stock	new_stockr   r   r   r   rx   r$   r&   r   r'   r(   r   r     sg    (M	T	>BWj45G':.>#?@LG_NwIDF^F
HLL9Jr'   r   c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \" 5       \R                  S9r\" \" 5       5      rSrg	)
SupplierCategoryModeli  suppliers_categoriesTr   zsuppliers.idzcategories.idrn   r   N)r   r   r   r    r!   r   r   r"   r   r9   r   r   r   rx   r$   r%   r&   r   r'   r(   r   r     sU    *M	T	>B*^"<=K*_"=>K
HLL9J(*%Lr'   r   c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \SS9r
\" \SS9r\" \" 5       \R                  S9r\" \" 5       \R                  S9rSrg	)
KardexValuesModeli  kardex_valuesTr   zproducts.idr   rn   r   N)r   r   r   r    r!   r   r   r"   r   rV   rX   average_costr   r   rx   r$   r%   r&   r   r'   r(   r   r     sb    #M	T	>BM!:;Jgq)H'1-L
HLL9J(*hll;Lr'   r   N)-app.backend.db.databaser   
sqlalchemyr   r   r   r   r   r	   r
   r   r   r   r   r   r   r   r   sqlalchemy.ormr   r   r   r+   r2   rR   r_   rf   rk   rz   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r'   r(   <module>r      sM   ( \  \  \  \  \ * &t &&4 & (D  (D&4 & &D &&t &< <$
t 
&D &&D &
& 
&	&T 	&
&t 
&&4 &**4 *	$T 	$&t &&4 &&D && &
$T 
$	:$ 	:&D &< <r'   