iUdZddlmZmZddlmZddlZdZe e d<dZ ee ee dfe d<dZ ee ee dfe d <dZ ee ee dfe d <d d Zd d Zy)zwbackfill_penerimaan_shift_id Revision ID: f4386bca7ccf Revises: f8g9h0i1j2k3 Create Date: 2026-05-07 22:20:06.182541 )SequenceUnion)opN f4386bca7ccfrevision f8g9h0i1j2k3 down_revision branch_labels depends_onc.tjdy)Na UPDATE penerimaan p SET shift_id = ( SELECT s.id FROM master_spbu_shift s WHERE s.spbu_id = p.spbu_id AND s.is_active = true AND s.deleted_at IS NULL AND ( CASE WHEN s.jam_selesai > s.jam_mulai THEN p.jam_tiba >= s.jam_mulai AND p.jam_tiba < s.jam_selesai ELSE p.jam_tiba >= s.jam_mulai OR p.jam_tiba < s.jam_selesai END ) ORDER BY s.id LIMIT 1 ) WHERE p.shift_id IS NULL AND p.jam_tiba IS NOT NULL )rexecute\/var/www/html/spbu.com/backend/alembic/versions/f4386bca7ccf_backfill_penerimaan_shift_id.pyupgradersJJ rcy)Nrrrr downgrader7sr)returnN)__doc__typingrralembicr sqlalchemysarstr__annotations__r r r rrrrrrsz##1? uS(3--.?15 uS(3--.5.2 E#x}d* +2 D r