INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261114-0001','1','B1E-YEAI-14-0','1','0.610','TOKO','SBK-B'); DELETE FROM tm_barang_export WHERE kode_barang='B1E-YEAI-14-0' LIMIT 1; INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1E-YEAI-14-0' LIMIT 1; DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='ME' LIMIT 1; INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1; DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='B1E' LIMIT 1; INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1E' LIMIT 1; DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-B'; INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-B'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1E-YEAI-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.610',berat_out_asli='0.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.610',berat_akhir_asli =berat_akhir_asli-'0.610' WHERE kode_barang='B1E-YEAI-14-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261114-0001','2026-11-14','2026-11-14','07:45','0.610','admpindah','261114'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1D-ZKAC-14-0','1','1.320','1.320','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKAC-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-14-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1D-ZKAC-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKAC-14-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1D','E1D-ZKAC-14-0','1','1.320','1.320','1','1.320','1.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZKAC-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-14-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1D-ZKAC-15-0','1','1.900','1.900','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKAC-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-15-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1D-ZKAC-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKAC-15-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1D','E1D-ZKAC-15-0','1','1.900','1.900','1','1.900','1.900','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZKAC-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-15-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1D-ZKAC-16-0','1','1.950','1.950','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKAC-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-16-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1D-ZKAC-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKAC-16-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1D','E1D-ZKAC-16-0','1','1.950','1.950','1','1.950','1.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZKAC-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-16-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1D-ZKAC-17-0','1','2.050','2.050','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKAC-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-17-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1D-ZKAC-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKAC-17-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1D','E1D-ZKAC-17-0','1','2.050','2.050','1','2.050','2.050','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZKAC-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-17-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1D-ZKAC-18-0','1','1.950','1.950','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKAC-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-18-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1D-ZKAC-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKAC-18-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1D','E1D-ZKAC-18-0','1','1.950','1.950','1','1.950','1.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZKAC-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-18-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1D-ZKAC-20-0','1','1.910','1.910','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKAC-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-20-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1D-ZKAC-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKAC-20-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1D','E1D-ZKAC-20-0','1','1.910','1.910','1','1.910','1.910','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZKAC-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKAC-20-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E2E-ZKAC-27-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZKAC-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-27-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E2E-ZKAC-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZKAC-27-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E2E','E2E-ZKAC-27-0','1','0.480','0.480','1','0.480','0.480','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZKAC-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-27-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E2E-ZKAC-28-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZKAC-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-28-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E2E-ZKAC-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZKAC-28-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E2E','E2E-ZKAC-28-0','1','0.500','0.500','1','0.500','0.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZKAC-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-28-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E2E-ZKAC-29-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZKAC-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-29-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E2E-ZKAC-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZKAC-29-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E2E','E2E-ZKAC-29-0','1','0.500','0.500','1','0.500','0.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZKAC-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-29-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E2E-ZKAC-30-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZKAC-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-30-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E2E-ZKAC-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZKAC-30-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E2E','E2E-ZKAC-30-0','1','0.450','0.450','1','0.450','0.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZKAC-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-30-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E2E-ZKAC-31-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZKAC-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-31-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E2E-ZKAC-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZKAC-31-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E2E','E2E-ZKAC-31-0','1','0.460','0.460','1','0.460','0.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZKAC-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-31-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E2E-ZKAC-32-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZKAC-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-32-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E2E-ZKAC-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZKAC-32-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E2E','E2E-ZKAC-32-0','1','0.500','0.500','1','0.500','0.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZKAC-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-32-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E2E-ZKAC-33-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZKAC-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-33-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E2E-ZKAC-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZKAC-33-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E2E','E2E-ZKAC-33-0','1','0.480','0.480','1','0.480','0.480','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZKAC-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZKAC-33-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1E-ZKAC-34-0','1','0.420','0.420','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZKAC-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZKAC-34-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1E-ZKAC-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZKAC-34-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1E','E1E-ZKAC-34-0','1','0.420','0.420','1','0.420','0.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZKAC-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZKAC-34-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1E-ZKAC-35-0','1','0.420','0.420','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZKAC-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZKAC-35-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1E-ZKAC-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZKAC-35-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1E','E1E-ZKAC-35-0','1','0.420','0.420','1','0.420','0.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZKAC-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZKAC-35-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1F-ZKAC-36-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZKAC-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZKAC-36-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1F-ZKAC-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZKAC-36-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1F','E1F-ZKAC-36-0','1','0.380','0.380','1','0.380','0.380','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZKAC-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZKAC-36-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','E1F-ZKAC-37-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZKAC-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZKAC-37-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-14 07:45:45' WHERE kode_barang='E1F-ZKAC-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZKAC-37-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:45:45','TOKO','PM-E','E1F','E1F-ZKAC-37-0','1','0.380','0.380','1','0.380','0.380','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZKAC-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZKAC-37-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261114-0001','2026-11-14','07:45','16.050','admpindah','2026-11-14 07:45:44'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','F1E-ZJCX-55-0','1','3.300','3.300','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJCX-55-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJCX-55-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-14 07:46:12' WHERE kode_barang='F1E-ZJCX-55-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJCX-55-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:46:12','TOKO','PM-F','F1E','F1E-ZJCX-55-0','1','3.300','3.300','1','3.300','3.300','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJCX-55-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJCX-55-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','F1E-ZKXD-61-0','1','2.930','2.930','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZKXD-61-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZKXD-61-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-14 07:46:12' WHERE kode_barang='F1E-ZKXD-61-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZKXD-61-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:46:12','TOKO','PM-F','F1E','F1E-ZKXD-61-0','1','2.930','2.930','1','2.930','2.930','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZKXD-61-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZKXD-61-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','F1E-ZKAA-84-0','1','2.220','2.220','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZKAA-84-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZKAA-84-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-14 07:46:12' WHERE kode_barang='F1E-ZKAA-84-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZKAA-84-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:46:12','TOKO','PM-F','F1E','F1E-ZKAA-84-0','1','2.220','2.220','1','2.220','2.220','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZKAA-84-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZKAA-84-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','F3E-ZKAC-39-0','1','1.910','1.910','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKAC-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKAC-39-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-14 07:46:12' WHERE kode_barang='F3E-ZKAC-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKAC-39-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:46:12','TOKO','PM-F','F3E','F3E-ZKAC-39-0','1','1.910','1.910','1','1.910','1.910','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZKAC-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKAC-39-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','F3E-ZKAC-40-0','1','1.420','1.420','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKAC-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKAC-40-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-14 07:46:12' WHERE kode_barang='F3E-ZKAC-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKAC-40-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:46:12','TOKO','PM-F','F3E','F3E-ZKAC-40-0','1','1.420','1.420','1','1.420','1.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZKAC-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKAC-40-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261114-0001','2026-11-14','07:46','11.780','admpindah','2026-11-14 07:46:12'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','H1E-ZKAC-41-0','1','4.020','4.020','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAC-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAC-41-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-14 07:46:34' WHERE kode_barang='H1E-ZKAC-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAC-41-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:46:34','TOKO','PM-H','H1E','H1E-ZKAC-41-0','1','4.020','4.020','1','4.020','4.020','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZKAC-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAC-41-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261114-0001','2026-11-14','07:46','4.020','admpindah','2026-11-14 07:46:33'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261114-0001','1','PHG-ZKAC-42-0','1','1.300','1.300','TOKO','PMBK-P','TOKO','PM-P'); DELETE FROM tm_barang WHERE kode_barang='PHG-ZKAC-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PHG-ZKAC-42-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-P',tgl_last_beli='2026-11-14 07:46:53' WHERE kode_barang='PHG-ZKAC-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PHG-ZKAC-42-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-14 07:46:53','TOKO','PM-P','PHG','PHG-ZKAC-42-0','1','1.300','1.300','1','1.300','1.300','100.00'); DELETE FROM tm_dept WHERE kode_dept='PHG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PHG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PHG-ZKAC-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='PHG-ZKAC-42-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261114-0001','2026-11-14','07:46','1.300','admpindah','2026-11-14 07:46:53'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140812391','input','1',' MEE2 X LG ','TOKO','PM-E','E2E-ZHCA-65-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.480','1','100.00','490000','0','0','15000','490000','0','0','0','490000','LIS','00421353','E2E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHCA-65-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E2E-ZHCA-65-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140812391','2026-11-14','0.480','2026-11-14','08:12:39','PLG0032352','490000','490000','0','490000','490000','input','2026-11-14 08:12:39','F32614081239'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140812391','2026-11-14','08:12:39','LIS','490000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261114-0002','D','2026-11-14','08:12:39','input','PENJUALAN','F326140812391','8195446000','490000','8195936000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140828111','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZCXB-312-0','GL X SANTA HATI VAR HW 8K ','','1.410','1','100.00','1438000','0','0','15000','1438000','0','0','0','1438000','FIT','00391735','F3E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-312-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F3E-ZCXB-312-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140828111','2026-11-14','1.410','2026-11-14','08:28:12','PLG0032353','1438000','1438000','0','1438000','1438000','input','2026-11-14 08:28:11','F32614082811'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140828111','2026-11-14','08:28:12','FIT','1438000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0003','D','2026-11-14','08:28:12','input','PENJUALAN','F326140828111','8195936000','1438000','8197374000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1438000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140828111' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140828112','input',' 1',' MEF3E X HW','TOKO','PM-F','F3E-ZKXD-98-0','GL X RANTAI HOLLO KUPU VAR HW 8K ','','0.980','1','100.00','1000000','0','0','15000','1000000','0','0','0','1000000','FIT','00433068','F3E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZKXD-98-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F3E-ZKXD-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140828112','2026-11-14','0.980','2026-11-14','08:28:12','PLG0032354','1000000','1000000','0','1000000','1000000','input','2026-11-14 08:28:11','F32614082811'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140828112','2026-11-14','08:28:12','FIT','1000000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0004','D','2026-11-14','08:28:12','input','PENJUALAN','F326140828112','8197374000','1000000','8198374000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140828112' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140908181','input','1',' MEF3E XXX ','TOKO','PM-F','F3E-ZJXE-346-0','GL XXX CASTELI ARESO SLEP HW 8K ','','2.640','1','100.00','2693000','0','0','15000','2615000','0','0','0','2615000','LIS','00427837','F3E','0','0','-','1','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXE-346-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F3E-ZJXE-346-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140908181','2026-11-14','2.640','2026-11-14','09:08:19','PLG0032355','2615000','2615000','0','2615000','2615000','input','2026-11-14 09:08:18','F32614090818'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140908181','2026-11-14','09:08:19','LIS','2615000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261114-0005','D','2026-11-14','09:08:19','input','PENJUALAN','F326140908181','8198374000','2615000','8200989000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140921301','input','1',' MEF3 XX KH','TOKO','PM-F','F3E-ZJCX-80-0','GL XX SANTA SPECTRA VAR SERUT KH 8K ','','1.850','1','100.00','1887000','0','0','15000','1830000','0','0','0','1830000','AAT','00432306','F3E','0','0','-','1','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJCX-80-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F3E-ZJCX-80-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140921301','2026-11-14','1.850','2026-11-14','09:21:30','PLG0032356','1830000','1830000','0','1830000','1830000','input','2026-11-14 09:21:30','F32614092130'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140921301','2026-11-14','09:21:30','AAT','1830000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0006','D','2026-11-14','09:21:30','input','PENJUALAN','F326140921301','8200989000','1830000','8202819000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1830000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140921301' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140921302','input',' 1',' MEE2 X CM ','TOKO','PM-E','E2E-ZJAF-157-0','CC X MODEL MATA CM 12 8K ','','0.800','1','100.00','816000','0','0','15000','815000','0','0','0','815000','AAT','00430336','E2E','0','0','-','1','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJAF-157-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E2E-ZJAF-157-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140921302','2026-11-14','0.800','2026-11-14','09:21:30','PLG0032357','815000','815000','0','815000','815000','input','2026-11-14 09:21:30','F32614092130'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140921302','2026-11-14','09:21:30','AAT','815000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0007','D','2026-11-14','09:21:30','input','PENJUALAN','F326140921302','8202819000','815000','8203634000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='815000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140921302' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140921303','input',' 1',' MEE2 X MJ ','TOKO','PM-E','E2E-ZDAH-158-0','CC X MODEL MATA MJ 17 8K ','','0.750','1','100.00','765000','0','0','15000','765000','0','0','0','765000','AAT','00399859','E2E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDAH-158-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E2E-ZDAH-158-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140921303','2026-11-14','0.750','2026-11-14','09:21:30','PLG0032358','765000','765000','0','765000','765000','input','2026-11-14 09:21:30','F32614092130'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140921303','2026-11-14','09:21:30','AAT','765000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0008','D','2026-11-14','09:21:30','input','PENJUALAN','F326140921303','8203634000','765000','8204399000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='765000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140921303' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140921304','input',' 1',' MEE2 5K LG','TOKO','PM-E','E2E-ZGXA-350-0','CC BONEKA ANAK CAT MATA LG 8K ','','0.600','1','100.00','612000','0','0','15000','613000','0','5000','0','618000','AAT','00411874','E2E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXA-350-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E2E-ZGXA-350-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140921304','2026-11-14','0.600','2026-11-14','09:21:30','PLG0032359','613000','613000','5000','618000','618000','input','2026-11-14 09:21:30','F32614092130'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140921304','2026-11-14','09:21:30','AAT','618000','5000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0009','D','2026-11-14','09:21:30','input','PENJUALAN','F326140921304','8204399000','618000','8205017000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='618000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140921304' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326141115391','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZKAA-135-0','GL X FLIK SLEP UB 8K ','','1.810','1','100.00','1846000','0','0','15000','1847000','0','0','0','1847000','LIS','00434503','F3E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZKAA-135-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F3E-ZKAA-135-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141115391','2026-11-14','1.810','2026-11-14','11:15:40','PLG0032360','1847000','1847000','0','1847000','1847000','kasir','2026-11-14 11:15:39','F32614111539'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326141115391','2026-11-14','11:15:40','LIS','1847000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0010','D','2026-11-14','11:15:40','kasir','PENJUALAN','F326141115391','8205017000','1847000','8206864000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1847000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141115391' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326141115392','kasir',' 1',' MFE1 X KH ','TOKO','PM-E','E1F-ZKXE-216-0','CC X MODEL SPECTRA SLEP KH 18 8K ','','0.370','1','100.00','385000','0','0','15000','385000','0','0','0','385000','LIS','00433563','E1F','0','0','-','0','1050000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZKXE-216-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E1F-ZKXE-216-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141115392','2026-11-14','0.370','2026-11-14','11:15:40','PLG0032361','385000','385000','0','385000','385000','kasir','2026-11-14 11:15:39','F32614111539'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326141115392','2026-11-14','11:15:40','LIS','385000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0011','D','2026-11-14','11:15:40','kasir','PENJUALAN','F326141115392','8206864000','385000','8207249000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='385000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141115392' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326141115393','kasir',' 1',' MEE1 X HW ','TOKO','PM-E','E1E-ZEBH-287-0','CC X MODEL GELOMBANG CAT HITAM HW 17 8K ','','0.790','1','100.00','806000','0','0','15000','806000','0','0','0','806000','LIS','00405505','E1E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-287-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.790',berat_jual_asli=berat_jual_asli+'0.790',stock_jual='1',berat_akhir=berat_akhir-'0.790',berat_akhir_asli=berat_akhir_asli-'0.790',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E1E-ZEBH-287-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141115393','2026-11-14','0.790','2026-11-14','11:15:40','PLG0032362','806000','806000','0','806000','806000','kasir','2026-11-14 11:15:39','F32614111539'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326141115393','2026-11-14','11:15:40','LIS','806000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0012','D','2026-11-14','11:15:40','kasir','PENJUALAN','F326141115393','8207249000','806000','8208055000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='806000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141115393' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326141129121','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZJAE-122-0','KL X SIEM COBRA KH 42 8K ','','1.280','1','100.00','1306000','0','0','15000','1306000','0','0','0','1306000','AAT','00430005','H1E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJAE-122-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='H1E-ZJAE-122-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141129121','2026-11-14','1.280','2026-11-14','11:29:13','PLG0032363','1306000','1306000','0','1306000','1306000','kasir','2026-11-14 11:29:12','F32614112912'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326141129121','2026-11-14','11:29:13','AAT','1306000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0013','D','2026-11-14','11:29:13','kasir','PENJUALAN','F326141129121','8208055000','1306000','8209361000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1306000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141129121' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326141129122','kasir',' 1',' MED2E X LG','TOKO','PM-D','D2E-ZEXI-50-0','LT X MODEL HURUF MATA LG R 8K ','','0.470','1','100.00','479000','0','0','15000','479000','0','0','0','479000','AAT','00402871','D2E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEXI-50-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='D2E-ZEXI-50-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141129122','2026-11-14','0.470','2026-11-14','11:29:13','PLG0032364','479000','479000','0','479000','479000','kasir','2026-11-14 11:29:12','F32614112912'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326141129122','2026-11-14','11:29:13','AAT','479000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0014','D','2026-11-14','11:29:13','kasir','PENJUALAN','F326141129122','8209361000','479000','8209840000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='479000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141129122' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326141133341','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZKXB-96-0','GL MODEL TIFFANE CLOVER SLEP HW 8K ','','2.280','1','100.00','2326000','0','0','15000','2325000','0','0','0','2325000','AAT','00432616','F3E','0','0','-','1','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZKXB-96-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.280',berat_jual_asli=berat_jual_asli+'2.280',stock_jual='1',berat_akhir=berat_akhir-'2.280',berat_akhir_asli=berat_akhir_asli-'2.280',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F3E-ZKXB-96-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141133341','2026-11-14','2.280','2026-11-14','11:33:35','PLG0032365','2325000','2325000','0','2325000','2325000','input','2026-11-14 11:33:34','F32614113334'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326141133341','2026-11-14','11:33:35','AAT','2325000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261114-0015','D','2026-11-14','11:33:35','input','PENJUALAN','F326141133341','8209840000','2325000','8212165000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020836','X-00020836','GW ITALY PANJANG HATI ARESO VAR CM 8K','GR','---','B1E','BELI','BELI001','687000','2026-11-14','0.730','1','kasir','2026-11-14 12:35:48'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00020836','X-00020836'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0001','F326081151441','AAT','1','BELI','BELI001','B1E', 'X-00020836', 'GW ITALY PANJANG HATI ARESO VAR CM 8K','0.730','0.730','100.00','748000','687000','941096','1030000','1','687000','687000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.730',berat_beli_asli=berat_beli_asli+'0.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.730',berat_akhir_asli=berat_akhir_asli+'0.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0001','2026-11-14','2026-11-14','12:35:47','AAT','---','0.730','687000','687000','687000','687000','687000','kasir','2026-11-14 12:35:48','FB-261114-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0001','AUREL','PURWANTORO','','','','kasir','2026-11-14 12:35:48'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0016','K','2026-11-14','12:35:47','kasir','PEMBELIAN UMUM','FB-261114-0001','8212165000','687000','8211478000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020837','X-00020837','CC MODEL SLEP KH 12 8K','GR','---','E1E','BELI','BELI001','492000','2026-11-14','0.520','1','kasir','2026-11-14 12:37:26'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020837','X-00020837'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0002','F326181034432','FIT','1','BELI','BELI001','E1E', 'X-00020837', 'CC MODEL SLEP KH 12 8K','0.520','0.520','100.00','542000','492000','946154','1030000','1','492000','492000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0002','2026-11-14','2026-11-14','12:37:25','FIT','---','0.520','492000','492000','492000','492000','492000','kasir','2026-11-14 12:37:26','FB-261114-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0002','TITIK','PUHPELEM','','','082136955755','kasir','2026-11-14 12:37:26'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0017','K','2026-11-14','12:37:25','kasir','PEMBELIAN UMUM','FB-261114-0002','8211478000','492000','8210986000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020838','X-00020838','CC X MODEL SPECTRA SLEP KH 10 8K','GR','---','E1F','BELI','BELI001','308000','2026-11-14','0.330','1','kasir','2026-11-14 12:37:26'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020838','X-00020838'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0003','F326031143151','FIT','2','BELI','BELI001','E1F', 'X-00020838', 'CC X MODEL SPECTRA SLEP KH 10 8K','0.330','0.330','100.00','342000','308000','933333','1050000','1','308000','308000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.330',berat_beli_asli=berat_beli_asli+'0.330',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.330',berat_akhir_asli=berat_akhir_asli+'0.330',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0003','2026-11-14','2026-11-14','12:37:25','FIT','---','0.330','308000','308000','308000','308000','308000','kasir','2026-11-14 12:37:26','FB-261114-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0003','TITIK','PUHPELEM','','','','kasir','2026-11-14 12:37:26'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0018','K','2026-11-14','12:37:25','kasir','PEMBELIAN UMUM','FB-261114-0003','8210986000','308000','8210678000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020839','X-00020839','GL X RANTE HOLLOW P4 KH 8K','GR','---','F3E','BELI','BELI001','3490000','2026-11-14','3.910','1','kasir','2026-11-14 12:37:46'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020839','X-00020839'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0004','F325020853221','LIS','1','BELI','BELI001','F3E', 'X-00020839', 'GL X RANTE HOLLOW P4 KH 8K','3.910','3.910','100.00','3795000','3490000','892583','1030000','1','3490000','3490000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.910',berat_beli_asli=berat_beli_asli+'3.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.910',berat_akhir_asli=berat_akhir_asli+'3.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0004','2026-11-14','2026-11-14','12:37:45','LIS','---','3.910','3490000','3490000','3490000','3490000','3490000','kasir','2026-11-14 12:37:46','FB-261114-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0004','HENI','JENGKOLAN NDARJO WNG','','','0895800844100','kasir','2026-11-14 12:37:46'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0019','K','2026-11-14','12:37:45','kasir','PEMBELIAN UMUM','FB-261114-0004','8210678000','3490000','8207188000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020840','X-00020840','GL XX PIPA MATA PM 54 8K','GR','---','F2E','BELI','BELI001','2935000','2026-11-14','3.000','1','kasir','2026-11-14 12:38:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020840','X-00020840'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0005','F326271139061','AAT','1','BELI','BELI001','F2E', 'X-00020840', 'GL XX PIPA MATA PM 54 8K','3.000','3.000','100.00','3240000','2935000','978333','1030000','1','2935000','2935000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0005','2026-11-14','2026-11-14','12:38:43','AAT','---','3.000','2935000','2935000','2935000','2935000','2935000','kasir','2026-11-14 12:38:43','FB-261114-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0005','BU WIJI','BITING','','','','kasir','2026-11-14 12:38:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0020','K','2026-11-14','12:38:43','kasir','PEMBELIAN UMUM','FB-261114-0005','8207188000','2935000','8204253000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020841','X-00020841','AT MODEL ITALY PANJANG VAR UB 8K','GR','---','A1D','BELI','BELI001','815000','2026-11-14','0.950','1','kasir','2026-11-14 12:38:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020841','X-00020841'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0006','F326111133241','AAT','2','BELI','BELI001','A1D', 'X-00020841', 'AT MODEL ITALY PANJANG VAR UB 8K','0.950','0.950','100.00','1126000','815000','857895','1010000','1','815000','815000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0006','2026-11-14','2026-11-14','12:38:43','AAT','---','0.950','815000','815000','815000','815000','815000','kasir','2026-11-14 12:38:43','FB-261114-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0006','AGUNG','NAWANGAN PACITAN','','','085259270972','kasir','2026-11-14 12:38:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0021','K','2026-11-14','12:38:43','kasir','PEMBELIAN UMUM','FB-261114-0006','8204253000','815000','8203438000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020842','X-00020842','CC X WEDDING MATA CM 18 8K','GR','---','E2D','BELI','BELI001','1857000','2026-11-14','2.000','1','kasir','2026-11-14 12:38:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020842','X-00020842'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0007','F326150247011','AAT','3','BELI','BELI001','E2D', 'X-00020842', 'CC X WEDDING MATA CM 18 8K','2.000','2.000','100.00','2170000','1857000','928500','1010000','1','1857000','1857000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0007','2026-11-14','2026-11-14','12:38:43','AAT','---','2.000','1857000','1857000','1857000','1857000','1857000','kasir','2026-11-14 12:38:43','FB-261114-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0007','LASTRI','JATEN MIRICINDE','','','','kasir','2026-11-14 12:38:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0022','K','2026-11-14','12:38:43','kasir','PEMBELIAN UMUM','FB-261114-0007','8203438000','1857000','8201581000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020843','X-00020843','GL X SANTA DAUN SERUT YT 8K','GR','---','F3E','BELI','BELI001','2202000','2026-11-14','2.310','1','kasir','2026-11-14 12:43:58'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020843','X-00020843'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0008','F326270233111','AAT','1','BELI','BELI001','F3E', 'X-00020843', 'GL X SANTA DAUN SERUT YT 8K','2.310','2.310','100.00','2368000','2202000','953247','1030000','1','2202000','2202000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.310',berat_beli_asli=berat_beli_asli+'2.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.310',berat_akhir_asli=berat_akhir_asli+'2.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0008','2026-11-14','2026-11-14','12:43:58','AAT','---','2.310','2202000','2202000','2202000','2202000','2202000','kasir','2026-11-14 12:43:58','FB-261114-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0008','MB NAR','GELANG','','','','kasir','2026-11-14 12:43:58'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0023','K','2026-11-14','12:43:58','kasir','PEMBELIAN UMUM','FB-261114-0008','8201581000','2202000','8199379000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140109401','kasir','1',' MEF3 X HW ','TOKO','PM-F','F3E-ZIBF-265-0','GL X TIFF SLEP VAR HW 8K ','','1.420','1','100.00','1448000','0','0','15000','1450000','0','0','0','1450000','AAT','00425883','F3E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBF-265-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F3E-ZIBF-265-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140109401','2026-11-14','1.420','2026-11-14','13:09:40','PLG0032366','1450000','1450000','0','1450000','1450000','kasir','2026-11-14 13:09:40','F32614010940'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140109401','2026-11-14','13:09:40','AAT','1450000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261114-0024','D','2026-11-14','13:09:40','kasir','PENJUALAN','F326140109401','8199379000','1450000','8200829000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020844','X-00020844','GL X LONG LING UB 8K','GR','---','F3E','BELI','BELI001','920000','2026-11-14','0.960','1','kasir','2026-11-14 13:11:20'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020844','X-00020844'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0009','F326261106212','FIT','1','BELI','BELI001','F3E', 'X-00020844', 'GL X LONG LING UB 8K','0.960','0.960','100.00','1012000','920000','958333','1030000','1','920000','920000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0009','2026-11-14','2026-11-14','13:11:20','FIT','---','0.960','920000','920000','920000','920000','920000','kasir','2026-11-14 13:11:20','FB-261114-0009'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0009','RINI NOVITASARI','NAWANGAN PCT','','','085150896971','kasir','2026-11-14 13:11:20'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0025','K','2026-11-14','13:11:20','kasir','PEMBELIAN UMUM','FB-261114-0009','8200829000','920000','8199909000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140113451','kasir','1',' TEH1 UB 36','TOKO','PT-H','H1TE-ZGAG-66-T','KL MILANO ANAK UB 36 17K ','','2.070','1','100.00','3892000','0','0','15000','3892000','0','0','0','3892000','FIT','T0081289','H1TE','0','0','-','0','1880000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZGAG-66-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='H1TE-ZGAG-66-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140113451','2026-11-14','2.070','2026-11-14','13:13:46','PLG0032367','3892000','3892000','0','3892000','3892000','kasir','2026-11-14 13:13:45','F32614011345'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140113451','2026-11-14','13:13:46','FIT','3892000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261114-0026','D','2026-11-14','13:13:46','kasir','PENJUALAN','F326140113451','8199909000','3892000','8203801000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020845','X-00020845','KL X SIEM COBRA ANAK KH 34 9K','GR','---','H2J','BELI','BELI001','2050000','2026-11-14','1.950','1','kasir','2026-11-14 13:15:34'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2J'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00020845','X-00020845'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261114-0010','F326161106531','FIT','1','BELI','BELI001','H2J', 'X-00020845', 'KL X SIEM COBRA ANAK KH 34 9K','1.950','1.950','100.00','2360000','2050000','1051282','1120000','1','2050000','2050000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261114-0010','2026-11-14','2026-11-14','13:15:33','FIT','---','1.950','2050000','2050000','2050000','2050000','2050000','kasir','2026-11-14 13:15:34','FB-261114-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261114-0010','FITRI','JANGGIR SUMBER','','','','kasir','2026-11-14 13:15:34'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-14' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261114-0027','K','2026-11-14','13:15:33','kasir','PEMBELIAN UMUM','FB-261114-0010','8203801000','2050000','8201751000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140151101','kasir','1',' MEF1 X CM ','TOKO','PM-F','F1E-ZEXI-26-0','GL X OSROT TINJU ANAK SLEP CM 8K ','','1.430','1','100.00','1459000','0','0','15000','1459000','0','0','0','1459000','LIS','00402847','F1E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEXI-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='F1E-ZEXI-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140151101','2026-11-14','1.430','2026-11-14','13:51:10','PLG0032368','1459000','1459000','0','1459000','1459000','kasir','2026-11-14 13:51:10','F32614015110'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140151101','2026-11-14','13:51:10','LIS','1459000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0028','D','2026-11-14','13:51:10','kasir','PENJUALAN','F326140151101','8201751000','1459000','8203210000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1459000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140151101' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140151102','kasir',' 1',' MEE1 X CM ','TOKO','PM-E','E1E-ZFXA-29-0','CC X BANGKOK SLEP CM 11 8K ','','0.540','1','100.00','551000','0','0','15000','551000','0','0','0','551000','LIS','00406197','E1E','0','0','-','0','1030000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXA-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E1E-ZFXA-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140151102','2026-11-14','0.540','2026-11-14','13:51:10','PLG0032369','551000','551000','0','551000','551000','kasir','2026-11-14 13:51:10','F32614015110'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140151102','2026-11-14','13:51:10','LIS','551000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0029','D','2026-11-14','13:51:10','kasir','PENJUALAN','F326140151102','8203210000','551000','8203761000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='551000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140151102' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140230101','input','1',' MDE2 CM 14','TOKO','PM-E','E2D-ZJXE-365-0','CC WEDDING MATA CM 14 8K ','','0.880','1','100.00','880000','0','0','15000','880000','0','0','0','880000','LIS','00427856','E2D','0','0','-','0','1010000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJXE-365-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E2D-ZJXE-365-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140230101','2026-11-14','0.880','2026-11-14','14:30:10','PLG0032370','880000','880000','0','880000','880000','input','2026-11-14 14:30:10','F32614023010'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140230101','2026-11-14','14:30:10','LIS','880000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0030','D','2026-11-14','14:30:10','input','PENJUALAN','F326140230101','8203761000','880000','8204641000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='880000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140230101' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326140230102','input',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZDAC-108-0','CC WEDDING MATA CM 22 8K ','','0.960','1','100.00','960000','0','0','15000','960000','0','10000','0','970000','LIS','00399278','E2D','0','0','-','0','1010000'); UPDATE tm_barang SET tgl_last_jual='2026-11-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAC-108-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-11-14' AND kode_barang='E2D-ZDAC-108-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140230102','2026-11-14','0.960','2026-11-14','14:30:10','PLG0032371','960000','960000','10000','970000','970000','input','2026-11-14 14:30:10','F32614023010'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-14','F326140230102','2026-11-14','14:30:10','LIS','970000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261114-0031','D','2026-11-14','14:30:10','input','PENJUALAN','F326140230102','8204641000','970000','8205611000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='970000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140230102' LIMIT 1; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261114-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261114-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140109401' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140109401' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140109401'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140113451' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140113451' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140113451'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151101' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151101' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140151101'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151102' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140151102' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140151102'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140230101' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140230101' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140230101'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140230102' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140230102' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140230102'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140812391' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140812391' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140812391'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140828111' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140828111' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140828111'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140828112' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140828112' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140828112'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140908181' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140908181' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140908181'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921301' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921301' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140921301'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921302' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921302' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140921302'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921303' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921303' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140921303'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921304' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140921304' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140921304'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141115391' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141115391' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141115391'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141115392' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141115392' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141115392'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141115393' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141115393' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141115393'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141129121' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141129121' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141129121'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141129122' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141129122' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141129122'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141133341' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141133341' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141133341'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-15','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-15'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-14'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-14'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-14' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-14'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-14'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-14'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-14'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-15' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-14' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261115-0001','D','2026-11-15','15:09:56','SYSTEM','SALDO AWAL','SALDO AWAL','0','8205611000','8205611000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261115-0001','D','2026-11-15','15:09:56','BRI','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261115-0001','D','2026-11-15','15:09:56','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261115-0001','D','2026-11-15','15:09:56','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); UPDATE tp_system SET tgl_system='2026-11-15'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','D2E-ZJCX-7-0','1','0.580','0.580','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D2E-ZJCX-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZJCX-7-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-11-15 17:31:12' WHERE kode_barang='D2E-ZJCX-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZJCX-7-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:31:12','TOKO','PM-D','D2E','D2E-ZJCX-7-0','1','0.580','0.580','1','0.580','0.580','100.00'); DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZJCX-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZJCX-7-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261115-0001','2026-11-15','17:31','0.580','admpindah','2026-11-14 17:31:11'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','E2E-ZGBI-61-0','1','0.580','0.580','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZGBI-61-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGBI-61-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-15 17:31:24' WHERE kode_barang='E2E-ZGBI-61-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGBI-61-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:31:24','TOKO','PM-E','E2E','E2E-ZGBI-61-0','1','0.580','0.580','1','0.580','0.580','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZGBI-61-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGBI-61-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261115-0001','2026-11-15','17:31','0.580','admpindah','2026-11-14 17:31:24'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','H2J-ZJCX-44-0','1','1.220','1.220','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H2J-ZJCX-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZJCX-44-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-15 17:31:39' WHERE kode_barang='H2J-ZJCX-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZJCX-44-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:31:39','TOKO','PM-H','H2J','H2J-ZJCX-44-0','1','1.220','1.220','1','1.220','1.220','100.00'); DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZJCX-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZJCX-44-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','H1E-ZKAA-124-0','1','1.230','1.230','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAA-124-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAA-124-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-15 17:31:39' WHERE kode_barang='H1E-ZKAA-124-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAA-124-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:31:39','TOKO','PM-H','H1E','H1E-ZKAA-124-0','1','1.230','1.230','1','1.230','1.230','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZKAA-124-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAA-124-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261115-0001','2026-11-15','17:31','2.450','admpindah','2026-11-14 17:31:39');