
    i                         U d Z ddlmZmZ ddlZddlmZ dZe	e
d<   dZee	ee	   df   e
d<   dZee	ee	   df   e
d	<   dZee	ee	   df   e
d
<   ddZddZy)zvadd_laporan_shift_penjualan

Revision ID: c3d4e5f6a1b2
Revises: b2c3d4e5f6a1
Create Date: 2026-04-02 00:00:00.000000

    )SequenceUnionN)opc3d4e5f6a1b2revisionb2c3d4e5f6a1down_revisionbranch_labels
depends_onc                  
   t        j                  dddddd      } | j                  t        j                         d	       t        j
                  d
t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      dd      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                         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                         dt        j                  d            t        j                  dt        j                         dt        j                  d            t        j                  dgdgd !      t        j                  dgd"gd#!      t        j                  dgd$gd%!      t        j                  dgd$gd%!      t        j                  d      t        j                  dddd&             t        j                   d'd
dg       t        j                   d(d
dg       t        j                   d)d
ddg       t        j
                  d*t        j                  dt        j                         d      t        j                  d+t        j                         d      t        j                  d,t        j                         d      t        j                  d-t        j"                  d.d/0      d      t        j                  d1t        j"                  d.d/0      d      t        j                  d2t        j$                         dd3      t        j                  d4t        j"                  d.d/0      d      t        j                  d5t        j"                  d.d/0      d      t        j                  d6t        j"                  d.d/0      d      t        j                  d+gd7gd !      t        j                  d,gd8gd#!      t        j                  d             t        j                   d9d*d+g       y ):Ndraft	submittedapprovedrejectedlockedstatuslaporanenumnameT
checkfirstlaporan_shiftidF)nullablespbu_idshift_idtanggalstatus   )length)r   server_defaultsubmitted_by_idsubmitted_at)timezonereviewed_by_idreviewed_atcatatan_reviewunlock_reason
created_atznow()
updated_atzmaster_spbu.idCASCADE)ondeletezmaster_spbu_shift.idRESTRICTzmaster_user.idzSET NULL#uq_laporan_shift_spbu_shift_tanggalix_laporan_shift_spbu_idix_laporan_shift_shift_idix_laporan_shift_spbu_tanggalpenjualan_nozzlelaporan_shift_id	nozzle_idteller_awal      )	precisionscaleteller_akhirflag_reset_tellerfalsevolume
harga_jualnilaizlaporan_shift.idzmaster_spbu_nozzle.id$ix_penjualan_nozzle_laporan_shift_id)saEnumcreater   get_bindcreate_tableColumnIntegerDateStringDateTimeTexttextForeignKeyConstraintPrimaryKeyConstraintUniqueConstraintcreate_indexNumericBoolean)r   s    [/var/www/html/spbu.com/backend/alembic/versions/c3d4e5f6a1b2_add_laporan_shift_penjualan.pyupgraderS      s   j*h  R[[]t< OO
		$

u5
		)RZZ\E:
		*bjjlU;
		)RWWY7
		(BIIR05QXY
		#RZZ\DA
		."++t"<tL
		"BJJL4@
		-d!;dK
		"BGGI=
		/2779t<
		,bggV]N^_
		,bggV]N^_
.>-?)T
/E.FQ[\
!2 36F5GR\]
!1 25E4FQ[\
%
Iz9Chi), OO.)MOO/:,OOO3_yR[F\] OO
		$

u5
		$bjjlUC
		+rzz|e<
		-b!BUS
		."**r"CeT
		%rzz|eT[\
		(BJJ1=N
		,

Rq AER
		'2::!<uM
!3 47I6JU^_
0G/HS]^
% OO:<NQcPde    c                     t        j                  dd       t        j                  d       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  d       t        j                  d	      j                  t        j                         d
       y )Nr?   r1   )
table_namer0   r   r/   r.   r   r   Tr   )r   
drop_index
drop_tabler@   rA   droprC    rT   rR   	downgrader[   I   s{    MM8EWXMM$%MM1oNMM-/JMM,IMM/"GG$%**2;;=T*JrT   )returnN)__doc__typingr   r   
sqlalchemyr@   alembicr   r   str__annotations__r	   r
   r   rS   r[   rZ   rT   rR   <module>rc      sz    #  # 1?uS(3--. ?15uS(3--. 5.2
E#x}d*+ 23fl	KrT   