
    ]i                     <    d Z ddlmZ ddlZdZdZdZdZddZ	ddZ
y)	zwredesign penyetoran: per-shift + batch table

Revision ID: e7h8i9j0k1l2
Revises: d6g7h8i9j0k1
Create Date: 2026-04-12

    )opNe7h8i9j0k1l2d6g7h8i9j0k1c                     t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         t        j
                  dd      d	
      t        j                  dt        j                         d	
      t        j                  dt        j                         d	
      t        j                  dt        j                  dd      d	d      t        j                  dt        j                         d
      t        j                  dt        j                  d      d	d      t        j                  dt        j                         t        j
                  dd      d
      t        j                  dt        j                  d      d
      t        j                  dt        j                         t        j
                  dd      d
      t        j                  dt        j                  d      d
      t        j                  dt        j                         d
      t        j                  dt        j                         d
      t        j                  dt        j                         t        j
                  dd      d
      t        j                  d t        j                  d      d
      t        j                  d!t        j                  d      t        j                  j                         d	"      t        j                  d#t        j                  d      t        j                  j                         t        j                  j                         d	$             t        j                  d%ddg       t        j                  d&       t        j                  d&t        j                  dt        j                         d      t        j                  dt        j                         t        j
                  dd      d	
      t        j                  d't        j                         t        j
                  d(d      d	
      t        j                  d)t        j                         d	
      t        j                  d*t        j                         t        j
                  d+d,      d	
      t        j                  d-t        j                  dd      d	d      t        j                  d.t        j                  dd      d	d      t        j                  d/t        j                  dd      d	d      t        j                  dt        j                         d
      t        j                  d0t        j                  d1      d
      t        j                  dt        j                  d      d	d2      t        j                  d3t        j                         t        j
                  d4d      d
      t        j                  d5t        j                         t        j
                  dd      d
      t        j                  d!t        j                  d      t        j                  j                         d	"      t        j                  d#t        j                  d      t        j                  j                         t        j                  j                         d	$      t        j                  d'd67             t        j                  d8d&dd)g       t        j                  d9d&d3g       y ):Npenyetoran_batchidTprimary_keyspbu_idmaster_spbu.idCASCADEondeleteFnullabletanggal_from
tanggal_tototal_amount      0r   server_defaultcatatanstatus   	submittedsubmitted_by_idmaster_user.idSET NULLsubmitted_attimezonereviewed_by_idreviewed_atcatatan_reviewunlock_reasonunlocked_by_idunlocked_at
created_atr   r   
updated_atr   onupdater   ix_penyetoran_batch_spbu
penyetoranlaporan_shift_idzlaporan_shift.idtanggalshift_idzmaster_spbu_shift.idRESTRICT
jumlah_kasjumlah_non_kastotal_penjualan	bukti_url  draftbatch_idzpenyetoran_batch.idcreated_by_iduq_penyetoran_laporan_shiftnameix_penyetoran_spbu_tanggalix_penyetoran_batch_id)r   create_tablesaColumnInteger
ForeignKeyDateNumericTextStringDateTimefuncnowcreate_index
drop_tableUniqueConstraint     S/var/www/html/spbu.com/backend/alembic/versions/e7h8i9j0k1l2_redesign_penyetoran.pyupgraderT      s}   OO
		$

$7
		)RZZ\2==9IT]+^ino
		."'')e<
		,	E:
		."**R"3eTWX
		)RWWY6
		(BIIbME+V
		#RZZ\2==AQ\f3grvw
		."++t"<tL
		"BJJL"--@P[e2fquv
		-d!;dK
		"BGGI=
		/2779t<
		"BJJL"--@P[e2fquv
		-d!;dK
		,T :277;;=chi
		,T :277;;=cecjcjcncncp  |A  	B%( OO.0BYKP MM,OO
		$

$7
		)RZZ\2==9IT]+^ino
		$bjjlBMMBT_h4ityz
		)RWWY7
		*bjjlBMM:P[e,fqvw
		,

2q 1ERUV
		"BJJr1$5VYZ
		#RZZA%6WZ[
		)RWWY6
		+ryy~=
		(BIIbME'R
		*bjjlBMM:OZd,eptu
		/2::<?OZd1eptu
		,T :277;;=chi
		,T :277;;=cecjcjcncncp  |A  	B
.5RS#& OO0,I@VWOO,lZLIrR   c                     t        j                  d       t        j                  d       t        j                  dt        j                  dt        j
                         d      t        j                  dt        j
                         t        j                  dd	      d
      t        j                  dt        j                         d
      t        j                  dt        j                  dd      d
d      t        j                  dt        j                  dd      d
d      t        j                  dt        j                  dd      d
d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d
d      t        j                  dt        j
                         t        j                  dd	      d      t        j                  dt        j
                         t        j                  dd	      d      t        j                  dt        j                  d      d      t        j                  d t        j                         d      t        j                  d!t        j                  d      t        j                  j                         d
"      t        j                  d#t        j                  d      t        j                  j                         t        j                  j                         d
$      t        j                  ddd%&             y )'Nr0   r   r   Tr	   r   r   r   r   Fr   r2   r7   r   r   r   r   total_expensesjumlah_setorr   r8   r9   r   r   r:   r<   r   r    confirmed_by_idconfirmed_atr"   catatan_konfirmasir*   r+   r,   r-   uq_penyetoran_spbu_tanggalr>   )r   rO   rB   rC   rD   rE   rF   rG   rH   rI   rJ   rK   rL   rM   rP   rQ   rR   rS   	downgrader\   C   s   MM,MM$%OO
		$

$7
		)RZZ\2==9IT]+^ino
		)RWWY7
		#RZZA%6WZ[
		"BJJr1$5VYZ
		."**R"3eTWX
		)RWWY6
		+ryy~=
		(BIIbME'R
		/2::<?OZd1eptu
		#RZZ\2==AQ\f3grvw
		."++t"<tL
		&	DA
		,T :277;;=chi
		,T :277;;=cecjcjcncncp  |A  	B
Iy7ST#rR   )returnN)__doc__alembicr   
sqlalchemyrC   revisiondown_revisionbranch_labels
depends_onrT   r\   rQ   rR   rS   <module>re      s2     
/JdrR   