
    i                         d Z ddlZddlmZmZ ddl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 ddlmZmZ  G d d	eej.                        Z G d
 dee      Z G d de      ZddlmZ ddlmZ ddlm Z  y)u4   Penebusan models — BBM procurement from Pertamina.    N)datedatetime)Decimal)BooleanDateDateTime
ForeignKeyIndexNumericStringUniqueConstraint)Mappedmapped_columnrelationship)BaseTimestampMixinc                        e Zd ZdZdZdZdZdZy)StatusPenebusandraft
waiting_so	submittedpartially_receivedfully_receivedN)__name__
__module____qualname__DRAFT
WAITING_SO	SUBMITTEDPARTIALLY_RECEIVEDFULLY_RECEIVED     6/var/www/html/spbu.com/backend/app/models/penebusan.pyr   r      s    EJI-%Nr#   r   c                      e Zd ZU dZdZ eddd       eddd      fZ ed	
      Z	e
e   ed<    e edd      dd	      Ze
e   ed<    eed      Ze
e   ed<    e ed      d      Ze
e   ed<    e ed      d	      Ze
edz     ed<    e ed      dej.                        Ze
e   ed<    e edd      d ed            Ze
e   ed<    e edd      d ed            Ze
e   ed<    e edd      d ed            Ze
e   ed<    e edd      d ed            Ze
e   ed<    e edd      d ed            Ze
e   ed<    e edd      d ed            Z e
e   ed <    e edd      d ed            Z!e
e   ed!<    e edd      d ed            Z"e
e   ed"<    ee#dd      Z$e
e%   ed#<    e ed$      d	      Z&e
edz     ed%<    e ed$      d	      Z'e
edz     ed&<    e ed'd(      d	      Z(e
edz     ed)<    e)dd*+      Z*e
e+d,      ed-<    e)eg.      Z,e
d/   ed0<    e)e(g.      Z-e
d1   ed2<   y)3	Penebusanz+One BBM procurement booking from Pertamina.	penebusanspbu_idbooking_codeuq_penebusan_spbu_booking)nameix_penebusan_spbu_tanggaltanggalTprimary_keyidzmaster_spbu.idCASCADEondeleteF)nullableindexr4   2   Nno_so   r4   defaultstatus      0subtotaldiscountppnpph22pbbkbroundingdebit_credittotal	is_manuali  
pdf_do_urlpdf_bukti_bayar_urlzmaster_user.idzSET NULLcreated_by_idzall, delete-orphan)back_populatescascadePenebusanItemitemsforeign_keysSpbuspbuzUser | None
created_by).r   r   r   __doc____tablename__r   r
   __table_args__r   r0   r   int__annotations__r	   r(   r   r-   r   r   r)   strr8   r   r   r<   r   r   r@   rA   rB   rC   rD   rE   rF   rG   r   rH   boolrI   rJ   rK   r   rO   listrS   rT   r"   r#   r$   r&   r&      s   5M 	N9TU)9i@N
 $5Bs5(#i85PTGVC[  *$?GVD\? -fRj5 IL&+I -fRj4 HE6#*H&3r
UO,A,A'FF?# 
 !.gb!nuV]^aVb cHfWoc -gb!nuV]^aVb cHfWoc(Q%QXY\Q]^C^*72q>ESZ[^S_`E6'?`*72q>ESZ[^S_`E6'?` -gb!nuV]^aVb cHfWoc$1'"a.5ZabeZf$gL&/g*72q>ESZ[^S_`E6'?` ,GeUSIvd|S &36#;%NJsTz"N.;F3KRV.Wd
+W )6#j9D)M6#*% 
 ,8",@,E6$'(  (gY?D&.?(4=/(RJ}%Rr#   r&   c                      e Zd ZU dZdZ edd      fZ ed      Ze	e
   ed<    e edd	
      d      Ze	e
   ed<    e edd
      d      Ze	e
   ed<    e ed      d      Ze	edz     ed<    e edd      d      Ze	e   ed<    e edd      d ed            Ze	e   ed<    eed      Ze	edz     ed<    e ed      d      Ze	edz     ed<    ed      Ze	d   ed<    eeg       Ze	d!   ed"<   y)#rN   z3One line item (product) inside a Penebusan booking.penebusan_itemix_penebusan_item_penebusan_idpenebusan_idTr.   r0   zpenebusan.idr1   r2   Fr6   zmaster_produk.idRESTRICT	produk_idr7   Nkode_item_pertaminar=   r>   volume_pesanr?   r:   volume_diterimatanggal_kirim   sent_to_textrO   )rL   r&   r'   rP   Produkproduk)r   r   r   rU   rV   r
   rW   r   r0   r   rX   rY   r	   r`   rb   r   rc   rZ   r   rd   r   re   r   rf   r   rh   r   r'   rj   r"   r#   r$   rN   rN   Q   sA   =$M 	.?N $5Bs5 ->I6!L&+  +%
;eIvc{  /<F2JQU.Vd
+V$1'"a.5$QL&/Q'4A(OVG_  *7td)KM6$+&K'4VC[4'PL&t$P &2%IIvk"I+)EFF8Er#   rN   )ri   )rR   )User)!rU   enumr   r   decimalr   
sqlalchemyr   r   r   r	   r
   r   r   r   sqlalchemy.ormr   r   r   app.models.baser   r   rZ   Enumr   r&   rN   app.models.productri   app.models.spburR   app.models.userrk   r"   r#   r$   <module>ru      sg    :  # 	 	 	 ? > 0&c499 &0Sn 0SfFD F< &    r#   