
    ]iy                     T   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mZ  G d deee      Z G d d	eee      Z G d
 deee      Z G d deee      Z G d deee      Z G d de      Z G d deee      Z G d deee      Zd dlmZ d dl m!Z! y)    )datetime)Decimal)BooleanDate
ForeignKeyIntegerNumericStringTextTime)Mappedmapped_columnrelationship)BaseSoftDeleteMixinTimestampMixinc                      e Zd ZU dZ ed      Zee   ed<    e e	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
      Zeedz     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
      Zeedz     ed<    e e	d      d
      Zeedz     ed<    e edd       ed            Zee   ed<    eed      Zee   ed<    edd      Zeed      ed<    edd      Zeed      ed <    edd      Zeed!      ed"<    edd      Zeed#      ed$<   y)%Spbumaster_spbuTprimary_keyid   name2   )uniqueindexnomor_pertaminanullableNkode_internalalamat   
no_telepond   	nama_bankno_rekening	atas_nama      z0.300default teller_discrepancy_threshold_pct	is_activespbuall, delete-orphanback_populatescascadeShiftshiftsIslandislandsTangkitangkisUserSpbuAssignmentassignments) __name__
__module____qualname____tablename__r   r   r   int__annotations__r   r   strr   r"   r   r#   r%   r'   r(   r)   r
   r   r.   r   r/   boolr   r6   listr8   r:   r<        1/var/www/html/spbu.com/backend/app/models/spbu.pyr   r   
   s   !M#5Bs5%fSk2D&+2#0DPT#UOVC[U(5fRj4(PM6#*%P!.td!CFF3:C%26":%MJsTz"M$1&+$MIvcDj!M&3F2J&NKd
#N$1&+$MIvcDj!M8E1ww/9$fWo  ,GTBIvd|B$0';%FF4=!  '3';'GVDN#  '3';'GVDN#  7C';7K123 rG   r   c                      e Zd ZU dZ ed      Zee   ed<    e e	dd      d      Z
ee   ed	<    e ed
            Zee   ed<    ee      Zee   ed<    ee      Zee   ed<    eed      Zee   ed<    ed      Zed   ed<   y)r5   master_spbu_shiftTr   r   master_spbu.idCASCADEondeleter   spbu_idr&   nama	jam_mulaijam_selesair,   r/   r6   r3   r   r0   N)r=   r>   r?   r@   r   r   r   rA   rB   r   rP   r   rQ   rC   r   rR   r   rS   r   r/   rD   r   r0   rF   rG   rH   r5   r5   *   s    'M#5Bs5(#i8GVC[  &fSk2D&+2+D1Ivd|1 -d 3K3+GTBIvd|B'x@D&.@rG   r5   c                   (   e Zd ZU dZ ed      Zee   ed<    e e	dd      d      Z
ee   ed	<    e ed
            Zee   ed<    eed      Zee   ed<    eed      Zee   ed<    ed      Zed   ed<    edd      Zeed      ed<   y)r7   master_spbu_islandTr   r   rK   rL   rM   rO   rP   r&   rQ      r,   urutanr/   r8   rT   r   r0   islandr1   r2   NozzlenozzlesN)r=   r>   r?   r@   r   r   r   rA   rB   r   rP   r   rQ   rC   r	   rX   r   r/   rD   r   r0   r[   rE   rF   rG   rH   r7   r7   9   s    (M#5Bs5(#i8GVC[  &fSk2D&+2';FF3K;+GTBIvd|B'yAD&.A&2)='GVDN# rG   r7   c                      e Zd ZU dZ ed      Zee   ed<    e e	dd      d      Z
ee   ed	<    e ed
            Zee   ed<    e e	dd      d      Zeedz     ed<    e e	dd      d      Zeedz     ed<    e ed      dd      Zee   ed<    eed      Zee   ed<    ed      Zed   ed<    e       Zed   ed<    ed      Zed    ed!<   y)"rZ   master_spbu_nozzleTr   r   zmaster_spbu_island.idrL   rM   rO   	island_idr   rQ   master_produk.idSET NULLr    N	produk_idmaster_spbu_tangki.id	tangki_id
   manualF)r-   r!   primary_tellerr,   r/   r[   rT   r7   rY   Produk | NoneprodukzTangki | Nonetangki)r=   r>   r?   r@   r   r   r   rA   rB   r   r^   r   rQ   rC   ra   rc   rf   r   r/   rD   r   rY   rh   ri   rF   rG   rH   rZ   rZ   J   s   (M#5Bs5**Y?tIvc{  &fRj1D&+1$1%
;d%IvcDj!  %2*Z@4%IvcDj!  #0r
HW\"]NF3K]+GTBIvd|B+9EFF8E&2nFF?#4&2)&LFF?#LrG   rZ   c                      e Zd ZU dZ ed      Zee   ed<    e e	dd      d      Z
ee   ed	<    e ed
            Zee   ed<    e ed      d      Zeedz     ed<    e edd            Zee   ed<    e e	dd      d      Zeedz     ed<    eed      Zee   ed<    ed      Zed   ed<    e       Zed   ed<    eddd !      Zeed"      ed#<    ed      Zeed$      ed%<   y)&r9   master_spbu_tangkiTr   r   rK   rL   rM   rO   rP   r&   rQ   r   r    Nkode_kalibrasi   r+   kapasitas_literr_   r`   ra   r,   r/   r:   rT   r   r0   rg   rh   ri   r1   zKalibrasiTangki.tinggi_mm)r3   r4   order_byKalibrasiTangki	kalibrasirZ   r[   )r=   r>   r?   r@   r   r   r   rA   rB   r   rP   r   rQ   rC   rl   r
   rn   r   ra   r   r/   rD   r   r0   rh   rq   rE   r[   rF   rG   rH   r9   r9   a   s-   (M#5Bs5(#i8GVC[  &fSk2D&+2)6vbzD)QNF3:&Q'4WR^'DOVG_D$1%
;d%IvcDj!  ,GTBIvd|B'yAD&.A&2nFF?#41=)=Hc2Ivd,-.  '3(&KGVDN#KrG   r9   c                       e Zd ZU dZ ed      Zee   ed<    e e	dd      d      Z
ee   ed	<    e ed
d            Zee   ed<    e edd            Zee   ed<    ed      Zed   ed<   y)rp   master_spbu_kalibrasiTr   r   rb   rL   rM   rO   rc   rd   rW   	tinggi_mmrm   r+   volume_literrq   rT   r9   ri   N)r=   r>   r?   r@   r   r   r   rA   rB   r   rc   r
   rt   r   ru   r   ri   rF   rG   rH   rp   rp   x   s    +M#5Bs5**Y?tIvc{  "/wr1~!>Ivg>$1'"a.$AL&/A+;GFF8GrG   rp   c                      e Zd ZU dZ ed      Zee   ed<    e e	dd      d      Z
ee   ed	<    e e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dz     ed<    e ed
      d      Zeedz     ed<    eed      Zee   ed<    edd      Zeed      ed<   y)Tenantmaster_spbu_tenantTr   r   rK   rL   rM   rO   rP   r   rQ   r&   r    Njenis_usahard      luas_m2kontakr,   r/   tenantr1   r2   KontrakSewakontrak)r=   r>   r?   r@   r   r   r   rA   rB   r   rP   r   rQ   rC   ry   r
   r{   r   r|   r   r/   rD   r   r   rE   rF   rG   rH   rw   rw      s    (M#5Bs5(#i8GVC[  &fSk2D&+2&3F3K$&OKd
#O&3GBNT&RGVGdN#R!.vc{T!JFF3:J+GTBIvd|B+7)=,GVD'( rG   rw   c                   R   e Zd ZU dZ ed      Zee   ed<    e e	dd      d      Z
ee   ed	<    e ed
d            Zee   ed<    ee      Zee   ed<    ee      Zee   ed<    e ed      d      Zee   ed<    eed      Zeedz     ed<    ed      Zed   ed<   y)r~   master_spbu_kontrakTr   r   zmaster_spbu_tenant.idrL   rM   rO   	tenant_idrm   r+   nilai_bulanantanggal_mulaitanggal_akhir   activer,   statusr    Ndokumen_urlr   rT   rw   r}   )r=   r>   r?   r@   r   r   r   rA   rB   r   r   r
   r   r   r   r   r   r   r   r   rC   r   r   r   r}   rF   rG   rH   r~   r~      s    )M#5Bs5**Y?tIvc{  &372q>%BM6'?B"/"5M6$<5"/"5M6$<5'r
HEFF3KE&3D4&HKd
#H+9EFF8ErG   r~   )Produk)r;   N)"datetimer   r   decimalr   
sqlalchemyr   r   r   r	   r
   r   r   r   sqlalchemy.ormr   r   r   app.models.baser   r   r   r   r5   r7   rZ   r9   rp   rw   r~   app.models.productr   app.models.roler;   rF   rG   rH   <module>r      s      V V V > > A A4 @AD./ AT>? "MT>? M.LT>? L.
Hd 
HT>? $F$ F  & .rG   