
    jz                         S SK Jr  S SKJrJr   " S S\R
                  5      r " S S\R
                  5      r " S S\R
                  5      rg	)
    )models)TeamVendorsc                      \ rS rSrSrSrSr\R                  " SSSS9r	\R                  " S\S	S
9r
\R                  " SSSSS9r\R                  " SSS9r\R                  " SSSSS9r\R                  " \\R"                  SSS9r\R                  " S\SS
9r\R                  " S\SS
9r\R                  " \\R"                  SSSS9r\R                  " SSS9r\R                  " SSS9r\R                  " SSS9r\R4                  " SSSS9r\R8                  " SSSS9r\R<                  " SSS9r\R@                  " SS9r!\R@                  " SS9r"Sr#g)Asset   ))Electronicsr	   )	Furniturer
   )Vehicler   Otherr   ))Newr   )Goodr   )Fairr   )Damagedr   )Written-offr   ))In Storer   )Issuedr   )Under Repairr   )Disposedr      F
max_lengthblanknull   r   r   choicesdefaultd   T)r   uniquer   r   r   r    r   r   r   r   	on_deleter   r   r   r   assigned_assets)r&   r   r   related_namezinventory/assets)	upload_tor   r   auto_now_addauto_now N)$__name__
__module____qualname____firstlineno__CATEGORY_CHOICESCONDITION_CHOICESSTATUS_CHOICESr   	CharField
asset_namecategory	asset_tag	DateFieldpurchase_datepurchase_cost
ForeignKeyr   SET_NULLvendor	conditionstatusr   assigned_to
issue_datereturn_datewarranty_expiry
ImageFieldphoto	FileFieldinvoice	TextFieldnotesDateTimeField
created_at
updated_at__static_attributes__r.       &/var/www/html/KUNJ/inventory/models.pyr   r      sz   N !!SEJJ27GQXYH  CEPUVI$$4d;M$$4dTVWMw&//TXYF  B8ISXYI^ZXF##DFOO4VZiz{K!!48J""D9K&&T=O(:$TRE);4dSG4d3E%%48J%%t4JrP   r   c                      \ rS rSrSrSr\R                  " SSSS9r\R                  " S\SS	9r	\R                  " S
\SS	9r
\R                  " SS9r\R                  " SS9r\R                  " SS9r\S 5       r\S 5       rSrg)
Stock_Item,   ))
StationeryrU   )MedicalrV   )Training MaterialrW   r   ))PcsrX   )BoxrY   )KgrZ   )Ltrr[   r   Fr   r   r   r   
   rX   r   )r   Tr*   r,   c           
         U R                   R                  [        R                  " S[        R                  " SS9S9[        R                  " S[        R                  " SS9S9S9nUS   =(       d    SUS	   =(       d    S-
  $ )
NquantityIn)transaction_type)filterOut)total_in	total_outrc   r   rd   )transactions	aggregater   SumQ)selftotalss     rQ   current_quantityStock_Item.current_quantity@   sl    "",,ZZ
688T3RSjjFHHe4TU - 
 z"'aF;,?,D1EErP   c                 4    U R                   U R                  :*  $ )N)rk   reorder_level)ri   s    rQ   is_low_stockStock_Item.is_low_stockH   s    $$(:(:::rP   r.   N)r/   r0   r1   r2   r3   UNIT_CHOICESr   r6   	item_namer8   unitIntegerFieldrn   rL   rM   rN   propertyrk   ro   rO   r.   rP   rQ   rS   rS   ,   s    L   Cu5II27GQXYHr<OD''2M%%48J%%t4JF F ; ;rP   rS   c                      \ rS rSrSr\R                  " \\R                  SS9r	\R                  " S\S9r\R                  " SSS9r\R                  " SSS9r\R                  " \\R"                  S	S	S
9r\R                  " \\R"                  S	S	S
9r\R                  " S\R"                  S	S	S
9r\R                  " SS	S	SS9r\R.                  " S	S9rSrg)Stock_TransactionM   ))r_   r_   )rb   rb   re   )r&   r(   r\   )r   r   Fr"   Tr%   zprogram_department.Projectsr   r#   r$   r*   r.   N)r/   r0   r1   r2   TRANSACTION_TYPE_CHOICESr   r=   rS   CASCADEitemr6   r`   rt   r^   r:   dater   r>   r?   r   	issued_toprojectrK   rL   rM   rO   r.   rP   rQ   rw   rw   M   s      Z6>>P^_D''2?WX""U;H%e4Dw&//TXYF!!$&//TXYI =`dkopG4dBOE%%48JrP   rw   N)		django.dbr   hr_department.modelsr   r   Modelr   rS   rw   r.   rP   rQ   <module>r      s=     .$5FLL $5N; ;B9 9rP   