INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','09:30:33'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','09:40:49'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','10:06:53'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','10:10:10'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0013'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-03','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-03'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-02'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-02'; 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-06-02' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-02'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-02'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-02'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-02'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05'; UPDATE tt_barang_saldo SET tanggal= '2026-06-03' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-02' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; 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-260603-0001','D','2026-06-03','10:19:55','TBC','SALDO AWAL','SALDO AWAL','0','23239088014','23239088014'); 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-260603-0001','D','2026-06-03','10:19:55','BCD','SALDO AWAL','SALDO AWAL','0','1392303500','1392303500'); 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-260603-0001','D','2026-06-03','10:19:55','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); 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-260603-0001','D','2026-06-03','10:19:55','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-260603-0001','D','2026-06-03','10:19:55','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); 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-260603-0001','D','2026-06-03','10:19:55','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); 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-260603-0001','D','2026-06-03','10:19:55','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); 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-260603-0001','D','2026-06-03','10:19:55','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); 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-260603-0001','D','2026-06-03','10:19:55','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); 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-260603-0001','D','2026-06-03','10:19:55','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); 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-260603-0001','D','2026-06-03','10:19:55','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000'); 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-260603-0001','D','2026-06-03','10:19:55','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650'); UPDATE tp_system SET tgl_system='2026-06-03'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','10:25:44'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','11:09:22'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','11:12:54'); 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,potong_rp,keterangan) VALUES ('FJ-260603-0001','sby','1',' 950K-135-0','TOKO','SBYPER','PSBY-ZEXA-64-0','CINCIN SILVER 925 ','','1.460','1','100.00','149000','0','0','17800','1050000','0','0','0','1050000','VAN','00043086','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-64-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='PSBY-ZEXA-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0001','2026-06-03','1.460','2026-06-03','11:16:20','PLG0011710','1050000','1050000','0','1050000','0','sby','2026-06-03 11:16:20','FJ-260603-0001','','POTONG'); 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-06-03','FJ-260603-0001','2026-06-03','11:16:20','VAN','1050000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260603-0001','2026-06-03','2026-06-03 11:16:20','PENJUALAN : FJ-260603-0001','','TBC','1050000','1050000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0002','D','2026-06-03','11:16:20','TBC','PENJUALAN','FJ-260603-0001','23239088014','1050000','23240138014','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-260603-0001' 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,potong_rp,keterangan) VALUES ('FJ-260603-0002','sby',' 1',' 750K-195-0','TOKO','SBYPER','PSBY-ZEXE-3-0','CINCIN SILVER 925 ','','2.340','1','100.00','239000','0','0','17800','850000','0','0','0','850000','VAN','00043199','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='PSBY-ZEXE-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0002','2026-06-03','2.340','2026-06-03','11:16:20','PLG0011711','850000','850000','0','850000','0','sby','2026-06-03 11:16:20','FJ-260603-0001','','POTONG'); 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-06-03','FJ-260603-0002','2026-06-03','11:16:20','VAN','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260603-0002','2026-06-03','2026-06-03 11:16:20','PENJUALAN : FJ-260603-0002','','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0003','D','2026-06-03','11:16:20','TBC','PENJUALAN','FJ-260603-0002','23240138014','850000','23240988014','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1900000' WHERE no_faktur_jual='FJ-260603-0002' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','11:41:55'); 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,potong_rp,keterangan) VALUES ('FJ-260603-0003','kasir','1',' BDC-00035 ','TOKO','TFCBR','BDC-XIAF-21-0','CINCIN BDC-00035','','2.340','1','83.00','8044000','2294000','129','17800','9500000','0','0','0','9500000','ONLILUNG','00031285','BDC','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDC-XIAF-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='BDC-XIAF-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0003','2026-06-03','2.340','2026-06-03','11:44:54','PLG0011712','9500000','9500000','0','9500000','0','kasir','2026-06-03 11:44:53','FJ-260603-0003','','POTONG'); 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-06-03','FJ-260603-0003','2026-06-03','11:44:54','ONLILUNG','9500000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260603-0003','2026-06-03','2026-06-03 11:44:53','PENJUALAN : FJ-260603-0003','.','TBC','9500000','9500000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0004','D','2026-06-03','11:44:54','TBC','PENJUALAN BERLIAN','FJ-260603-0003','23240988014','9500000','23250488014','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='9500000' WHERE no_faktur_jual='FJ-260603-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','11:46: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-20260603-0001','1','CMMM-ZDBI-37-0','1','1.240','1.240','TOKO','MMCM','TOKO','MMCM'); DELETE FROM tm_barang WHERE kode_barang='CMMM-ZDBI-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMMM-ZDBI-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CMMM-ZDBI-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMMM-ZDBI-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMCM',tgl_last_beli='2026-06-03 11:46:41' WHERE kode_barang='CMMM-ZDBI-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CMMM-ZDBI-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-06-03 11:46:41','TOKO','MMCM','CMMM','CMMM-ZDBI-37-0','1','1.240','1.240','1','1.240','1.240','45.00'); DELETE FROM tm_dept WHERE kode_dept='CMMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMMM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CMMM-ZDBI-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='CMMM-ZDBI-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260603-0001','2026-06-03','11:46','1.240','kasir','2026-06-03 11:46:41'); 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-20260603-0002','1','PSPLT-ZFXB-2-0','1','6.590','6.590','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXB-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXB-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXB-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXB-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-03 11:47:19' WHERE kode_barang='PSPLT-ZFXB-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXB-2-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-06-03 11:47:19','TOKO','MMPSN','PSPLT','PSPLT-ZFXB-2-0','1','6.590','6.590','1','6.590','6.590','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXB-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXB-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0002','1','PSPRT-ZFXB-3-0','1','3.280','3.280','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZFXB-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZFXB-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXB-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-03 11:47:19' WHERE kode_barang='PSPRT-ZFXB-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZFXB-3-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-06-03 11:47:19','TOKO','MMPSN','PSPRT','PSPRT-ZFXB-3-0','1','3.280','3.280','1','3.280','3.280','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZFXB-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260603-0002','2026-06-03','11:47','9.870','kasir','2026-06-03 11:47:18'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','11:50:37'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','13:15:13'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02345','KUR','1','PER','CINCIN KAWIN SILVER PROMO','','','3.000','','925.00','1','100000','0','1150000','0','1150000','cowok size 20.5 grf Rahmah font vintage rotter model yl01','cewe size 16 grf Rizki fon vintage rotter model SR 03','EXPRES 100.000 BIKIN sesuai contoh','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0004','2026-06-03','2026-06-03 13:43:00','PESANAN : DP-02345','.','TBC','1150000','1150000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0005','D','2026-06-03','13:43:00','TBC','PESANAN','DP-02345','23250488014','1150000','23251638014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02345','2026-06-03','2026-06-03','13:43:00','PLG0011713','KUR','2026-06-13','kasirbip','2026-06-03 13:43:00','3.000','0','0','0','1150000','0','0','1150000','1150000','0'); UPDATE tt_service_head SET tgl_selesai='2026-06-03', status ='DONE' WHERE no_service='SV-02060'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02060'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-03', status ='CLOS' WHERE no_service='SV-02060'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02060'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','14:10:54'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02346','VAN','1','GOLD','WEDDING RING','','','3.000','','75.00','1','2450000','2400000','0','900000','8100000','permata zirkon 9 (menyesuaikan)','size:13 GRF: N & D (Vladimir)','finishing : putih glossy','90000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0005','2026-06-03','2026-06-03 14:20:17','PESANAN : DP-02346','-','TBC','5700000','5700000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0006','D','2026-06-03','14:20:17','TBC','PESANAN','DP-02346','23251638014','5700000','23257338014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02346','2026-06-03','2026-06-03','14:20:17','PLG0011714','VAN','2026-06-28','sby','2026-06-03 14:20:17','3.000','0','0','0','5700000','0','900000','8190000','8190000','2490000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','14:25:03'); 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,potong_rp,keterangan) VALUES ('FJ-260603-0004','kasirbip','1',' DP-02120BI','TOKO','BIPPSN','PSPRT-ZEBE-13-0','CINCIN PERAK ','','2.060','1','100.00','211000','0','0','17800','850000','0','0','0','850000','SULIS','00043774','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBE-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='PSPRT-ZEBE-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0004','2026-06-03','2.060','2026-06-03','14:29:03','PLG0011715','850000','850000','0','850000','0','kasirbip','2026-06-03 14:29:03','FJ-260603-0004','DP-02120','850000'); 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-06-03','FJ-260603-0004','2026-06-03','14:29:03','SULIS','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260603-0004' 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,potong_rp,keterangan) VALUES ('FJ-260603-0005','kasirbip',' 1',' DP-02121BI','TOKO','BIPPSN','PSPRT-ZEBE-12-0','CINCIN PERAK ','','1.540','1','100.00','158000','0','0','17800','900000','0','0','0','900000','SULIS','00043773','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBE-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='PSPRT-ZEBE-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0005','2026-06-03','1.540','2026-06-03','14:29:03','PLG0011716','900000','900000','0','900000','0','kasirbip','2026-06-03 14:29:03','FJ-260603-0004','DP-02121','900000'); 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-06-03','FJ-260603-0005','2026-06-03','14:29:03','SULIS','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260603-0005' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02347','VAN','1','GOLD','WEDDING RING','','','4.000','','25.00','1','2450000','550000','0','750000','2950000','Size: 19','Grf: N&D (Font: Vladimir)','Finishing: putih doff','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0006','2026-06-03','2026-06-03 14:31:20','PESANAN : DP-02347','-','TBC','2000000','2000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0007','D','2026-06-03','14:31:20','TBC','PESANAN','DP-02347','23257338014','2000000','23259338014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02347','2026-06-03','2026-06-03','14:31:20','PLG0011717','VAN','2026-06-17','sby','2026-06-03 14:31:20','4.000','0','0','0','2000000','0','750000','2950000','2950000','950000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0005'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02348','PUT','1','PLD','WEDD RING','','','6.000','','50.00','1','1200000','1000000','0','800000','6800000','exspress 100.000','sz 31 crom doff semprot','grf Nining font vintage','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0007','2026-06-03','2026-06-03 14:38:53','PESANAN : DP-02348','.','TBC','5440000','5440000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0008','D','2026-06-03','14:38:53','TBC','PESANAN','DP-02348','23259338014','5440000','23264778014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02348','2026-06-03','2026-06-03','14:38:53','PLG0011718','PUT','2026-06-11','kasirbip','2026-06-03 14:38:53','6.000','0','0','0','5440000','0','800000','6800000','6800000','1360000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02349','PUT','1','GOLD','WEDD RING','','','3.000','','50.00','1','2450000','2000000','0','800000','6800000','exspress 100.000','sz 15.5 crom doff semprot samakan sprti cntoh','grf Muhammad Soleh font Vintage','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0008','2026-06-03','2026-06-03 14:41:33','PESANAN : DP-02349','.','TBC','5440000','5440000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0009','D','2026-06-03','14:41:33','TBC','PESANAN','DP-02349','23264778014','5440000','23270218014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02349','2026-06-03','2026-06-03','14:41:33','PLG0011719','PUT','2026-06-11','kasirbip','2026-06-03 14:41:33','3.000','0','0','0','5440000','0','800000','6800000','6800000','1360000'); 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-20260603-0003','1','PSPLT-ZFXA-21-0','1','2.960','2.960','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-21-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-21-0','1','2.960','2.960','1','2.960','2.960','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-22-0','1','1.800','1.800','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-22-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-22-0','1','1.800','1.800','1','1.800','1.800','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-23-0','1','2.510','2.510','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-23-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-23-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-23-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-23-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-23-0','1','2.510','2.510','1','2.510','2.510','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-23-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-24-0','1','2.930','2.930','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-24-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-24-0','1','2.930','2.930','1','2.930','2.930','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-25-0','1','1.370','1.370','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-25-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-25-0','1','1.370','1.370','1','1.370','1.370','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-26-0','1','1.810','1.810','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-26-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-26-0','1','1.810','1.810','1','1.810','1.810','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-27-0','1','2.650','2.650','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-27-0','1','2.650','2.650','1','2.650','2.650','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-28-0','1','4.030','4.030','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-28-0','1','4.030','4.030','1','4.030','4.030','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-29-0','1','2.350','2.350','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-29-0','1','2.350','2.350','1','2.350','2.350','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXA-30-0','1','2.990','2.990','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXA-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXA-30-0','1','2.990','2.990','1','2.990','2.990','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSGT-ZFXA-31-0','1','1.260','1.260','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZFXA-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZFXA-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZFXA-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSGT-ZFXA-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZFXA-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-06-03 15:13:32','TOKO','BIPPSN','PSGT','PSGT-ZFXA-31-0','1','1.260','1.260','1','1.260','1.260','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZFXA-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0003','1','PSPLT-ZFXB-4-0','1','3.360','3.360','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXB-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXB-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXB-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXB-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-06-03 15:13:32' WHERE kode_barang='PSPLT-ZFXB-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXB-4-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-06-03 15:13:32','TOKO','BIPPSN','PSPLT','PSPLT-ZFXB-4-0','1','3.360','3.360','1','3.360','3.360','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXB-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXB-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260603-0003','2026-06-03','15:11','30.020','kasirbip','2026-06-03 15:13:31'); 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-20260603-0004','1','BDCM-ZDBI-55-0','1','1.930','1.930','TOKO','CMBD','TOKO','BIPCMP'); DELETE FROM tm_barang WHERE kode_barang='BDCM-ZDBI-55-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-55-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='BDCM-ZDBI-55-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='BDCM-ZDBI-55-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPCMP',tgl_last_beli='2026-06-03 15:19:39' WHERE kode_barang='BDCM-ZDBI-55-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='BDCM-ZDBI-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-06-03 15:19:39','TOKO','BIPCMP','BDCM','BDCM-ZDBI-55-0','1','1.930','1.930','1','1.930','1.930','45.00'); DELETE FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='BDCM-ZDBI-55-0'; DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-55-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0004','1','BDCM-ZDBI-56-0','1','1.350','1.350','TOKO','CMBD','TOKO','BIPCMP'); DELETE FROM tm_barang WHERE kode_barang='BDCM-ZDBI-56-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-56-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='BDCM-ZDBI-56-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='BDCM-ZDBI-56-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPCMP',tgl_last_beli='2026-06-03 15:19:39' WHERE kode_barang='BDCM-ZDBI-56-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='BDCM-ZDBI-56-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-06-03 15:19:39','TOKO','BIPCMP','BDCM','BDCM-ZDBI-56-0','1','1.350','1.350','1','1.350','1.350','45.00'); DELETE FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='BDCM-ZDBI-56-0'; DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-56-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0004','1','BDCM-ZDBI-58-0','1','1.500','1.500','TOKO','CMBD','TOKO','BIPCMP'); DELETE FROM tm_barang WHERE kode_barang='BDCM-ZDBI-58-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-58-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='BDCM-ZDBI-58-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='BDCM-ZDBI-58-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPCMP',tgl_last_beli='2026-06-03 15:19:40' WHERE kode_barang='BDCM-ZDBI-58-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='BDCM-ZDBI-58-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-06-03 15:19:40','TOKO','BIPCMP','BDCM','BDCM-ZDBI-58-0','1','1.500','1.500','1','1.500','1.500','45.00'); DELETE FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='BDCM-ZDBI-58-0'; DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-58-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; 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-20260603-0004','1','BDCM-ZDBI-59-0','1','1.550','1.550','TOKO','CMBD','TOKO','BIPCMP'); DELETE FROM tm_barang WHERE kode_barang='BDCM-ZDBI-59-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-59-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='BDCM-ZDBI-59-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='BDCM-ZDBI-59-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPCMP',tgl_last_beli='2026-06-03 15:19:40' WHERE kode_barang='BDCM-ZDBI-59-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='BDCM-ZDBI-59-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-06-03 15:19:40','TOKO','BIPCMP','BDCM','BDCM-ZDBI-59-0','1','1.550','1.550','1','1.550','1.550','45.00'); DELETE FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='BDCM-ZDBI-59-0'; DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZDBI-59-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260603-0004','2026-06-03','15:19','6.330','kasirbip','2026-06-03 15:19:40'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','15:26:14'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','15:28:40'); UPDATE tt_service_head SET tgl_selesai='2026-06-03', status ='DONE' WHERE no_service='SV-02089'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02089'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02350','PUT','1','PLD','1 BUAH CINCIN','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','exspress 100.000','sz 21.5 crom doff semprot','grf Santika font Vintage','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0009','2026-06-03','2026-06-03 15:41:47','PESANAN : DP-02350','.','TBC','1440000','1440000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0010','D','2026-06-03','15:41:47','TBC','PESANAN','DP-02350','23270218014','1440000','23271658014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02350','2026-06-03','2026-06-03','15:41:47','PLG0011720','PUT','2026-06-10','kasirbip','2026-06-03 15:41:47','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','15:43:02'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-04','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-04'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-03'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-03'; 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-06-03' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-03'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-03'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-03'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-03'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05'; UPDATE tt_barang_saldo SET tanggal= '2026-06-04' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-03' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; 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-260604-0001','D','2026-06-04','15:43:19','TBC','SALDO AWAL','SALDO AWAL','0','23271658014','23271658014'); 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-260604-0001','D','2026-06-04','15:43:19','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650'); 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-260604-0001','D','2026-06-04','15:43:19','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000'); 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-260604-0001','D','2026-06-04','15:43:19','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); 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-260604-0001','D','2026-06-04','15:43:19','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); 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-260604-0001','D','2026-06-04','15:43:19','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); 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-260604-0001','D','2026-06-04','15:43:19','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); 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-260604-0001','D','2026-06-04','15:43:19','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); 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-260604-0001','D','2026-06-04','15:43:19','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); 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-260604-0001','D','2026-06-04','15:43:19','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-260604-0001','D','2026-06-04','15:43:19','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); 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-260604-0001','D','2026-06-04','15:43:19','BCD','SALDO AWAL','SALDO AWAL','0','1392303500','1392303500'); UPDATE tp_system SET tgl_system='2026-06-04'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','15:43:31'); UPDATE tt_service_head SET tgl_selesai='2026-06-04', status ='DONE' WHERE no_service='SV-02091'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02091'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-04', status ='CLOS' WHERE no_service='SV-02091'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02091'; 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,potong_rp,keterangan) VALUES ('FJ-260603-0006','kasir','1',' DP-02202MM','TOKO','MMPSN','PSPRT-ZFXB-3-0','CINCIN PERAK YL-01 ','','3.280','1','100.00','335000','0','0','17800','850000','0','0','0','850000','ELLA','00043925','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFXB-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSPRT-ZFXB-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0006','2026-06-04','3.280','2026-06-03','17:03:06','PLG0011721','850000','850000','0','850000','0','kasir','2026-06-03 17:03:06','FJ-260603-0006','DP-02202','850000'); 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-06-04','FJ-260603-0006','2026-06-03','17:03:06','ELLA','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260603-0006' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02351','DIL','1','PLD','WEDD RING','','','3.500','','10.00','1','1200000','350000','0','700000','1925000','SIZE 17 GRF: AULwayswithBING??','CROM : PUTIH DOFF MIX GLOSSY','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0010','2026-06-03','2026-06-03 17:51:09','PESANAN : DP-02351','-','TBC','1300000','1300000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0001','D','2026-06-03','17:51:09','TBC','PESANAN','DP-02351','0','1300000','1300000','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02351','2026-06-03','2026-06-03','17:51:09','PLG0011722','DIL','2026-06-30','sby','2026-06-03 17:51:09','3.500','0','0','0','1300000','0','700000','1925000','1925000','625000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02352','DIL','1','GOLD','WEDD RING','','','2.500','','37.50','1','2450000','1500000','0','700000','4450000','PERMATA 3 BUTIR','SIZE 10.5 GRF : AULwayswithBING?? (Yaseva)','putih (emas putih)','30000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0011','2026-06-03','2026-06-03 17:55:50','PESANAN : DP-02352','-','TBC','3100000','3100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0002','D','2026-06-03','17:55:50','TBC','PESANAN','DP-02352','1300000','3100000','4400000','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02352','2026-06-03','2026-06-03','17:55:50','PLG0011723','DIL','2026-06-30','sby','2026-06-03 17:55:50','2.500','0','0','0','3100000','0','700000','4480000','4480000','1380000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','18:01:58'); 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,potong_rp,keterangan) VALUES ('FJ-260603-0007','sby','1',' 850K-12-00','TOKO','SBYPER','PSBY-ZEXA-17-0','CINCIN SILVER 925 ','','1.500','1','100.00','153000','0','0','17800','950000','0','0','0','950000','VAN','00043039','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSBY-ZEXA-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0007','2026-06-04','1.500','2026-06-03','18:07:50','PLG0011724','950000','950000','0','950000','0','sby','2026-06-03 18:07:49','FJ-260603-0007','','POTONG'); 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-06-04','FJ-260603-0007','2026-06-03','18:07:50','VAN','950000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0001','2026-06-04','2026-06-03 18:07:49','PENJUALAN : FJ-260603-0007','','TBC','950000','950000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0002','D','2026-06-04','18:07:50','TBC','PENJUALAN','FJ-260603-0007','23271658014','950000','23272608014','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260603-0007' 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,potong_rp,keterangan) VALUES ('FJ-260603-0008','sby',' 1',' 750K-195-0','TOKO','SBYPER','PSBY-ZEXA-25-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17800','850000','0','0','0','850000','VAN','00043047','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSBY-ZEXA-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0008','2026-06-04','2.270','2026-06-03','18:07:50','PLG0011725','850000','850000','0','850000','0','sby','2026-06-03 18:07:49','FJ-260603-0007','','POTONG'); 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-06-04','FJ-260603-0008','2026-06-03','18:07:50','VAN','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0002','2026-06-04','2026-06-03 18:07:49','PENJUALAN : FJ-260603-0008','','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0003','D','2026-06-04','18:07:50','TBC','PENJUALAN','FJ-260603-0008','23272608014','850000','23273458014','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-260603-0008' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02353','PUT','1','PLD','WEDD RING','','','2.500','','25.00','1','1200000','550000','0','800000','2175000','exspress 100.000','sz 13.5 crom putih gllosy sirkon 15','grf Bakhrul font Swash','0','150000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0012','2026-06-03','2026-06-03 18:16:02','PESANAN : DP-02353','.','TBC','1860000','1860000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0003','D','2026-06-03','18:16:02','TBC','PESANAN','DP-02353','4400000','1860000','6260000','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02353','2026-06-03','2026-06-03','18:16:02','PLG0011726','PUT','2026-06-14','kasirbip','2026-06-03 18:16:02','2.500','0','0','0','1860000','0','800000','2325000','2325000','465000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02354','PUT','1','PLD','WEDD RING','','','3.500','','25.00','1','1200000','550000','0','750000','2675000','exspress 100.000','sz 16 crom doff semprot samakan sprti cntoh','grf Aya font Swash','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260603-0013','2026-06-03','2026-06-03 18:19:08','PESANAN : DP-02354','.','TBC','2140000','2140000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260603-0004','D','2026-06-03','18:19:08','TBC','PESANAN','DP-02354','6260000','2140000','8400000','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02354','2026-06-03','2026-06-03','18:19:08','PLG0011727','PUT','2026-06-14','kasirbip','2026-06-03 18:19:08','3.500','0','0','0','2140000','0','750000','2675000','2675000','535000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','18:31:33'); 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,potong_rp,keterangan) VALUES ('FJ-260603-0009','sby','1',' 850K-11-00','TOKO','SBYPER','PSBY-ZEXE-46-0','CINCIN SILVER 925 ','','2.670','1','100.00','273000','0','0','17800','900000','0','0','0','900000','VAN','00043242','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSBY-ZEXE-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-260603-0009','2026-06-04','2.670','2026-06-03','18:33:51','PLG0011728','900000','900000','0','900000','0','sby','2026-06-03 18:33:50','FJ-260603-0009','','POTONG'); 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-06-04','FJ-260603-0009','2026-06-03','18:33:51','VAN','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0003','2026-06-04','2026-06-03 18:33:50','PENJUALAN : FJ-260603-0009','','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0004','D','2026-06-04','18:33:51','TBC','PENJUALAN','FJ-260603-0009','23273458014','900000','23274358014','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260603-0009' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','18:36:04'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02355','PUT','1','PER','WEDRING PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','cowo sz 16 YL 01 grf Farah','cewe sz 6 SR 03 grf Ari','font vintage','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0004','2026-06-04','2026-06-03 18:43:02','PESANAN : DP-02355','.','TBC','950000','950000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0005','D','2026-06-04','18:43:02','TBC','PESANAN','DP-02355','23274358014','950000','23275308014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02355','2026-06-04','2026-06-04','18:43:02','PLG0011729','PUT','2026-06-22','kasirbip','2026-06-03 18:43:02','3.000','0','0','0','950000','0','0','950000','950000','0'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-03', status ='CLOS' WHERE no_service='SV-02057'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02057'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','18:44: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-20260604-0001','1','PSPRT-ZFXB-5-0','1','1.600','1.600','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZFXB-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZFXB-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXB-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-06-04 18:54:03' WHERE kode_barang='PSPRT-ZFXB-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZFXB-5-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-06-04 18:54:03','TOKO','DUPSN','PSPRT','PSPRT-ZFXB-5-0','1','1.600','1.600','1','1.600','1.600','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZFXB-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-04' WHERE no_faktur_beli=''; 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-20260604-0001','1','PSPRT-ZFXB-6-0','1','3.550','3.550','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZFXB-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZFXB-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXB-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-06-04 18:54:03' WHERE kode_barang='PSPRT-ZFXB-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZFXB-6-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-06-04 18:54:03','TOKO','DUPSN','PSPRT','PSPRT-ZFXB-6-0','1','3.550','3.550','1','3.550','3.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZFXB-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-04' WHERE no_faktur_beli=''; 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-20260604-0001','1','PSPRT-ZFXB-7-0','1','4.160','4.160','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZFXB-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZFXB-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXB-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-06-04 18:54:03' WHERE kode_barang='PSPRT-ZFXB-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZFXB-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-06-04 18:54:03','TOKO','DUPSN','PSPRT','PSPRT-ZFXB-7-0','1','4.160','4.160','1','4.160','4.160','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZFXB-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-04' WHERE no_faktur_beli=''; 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-20260604-0001','1','PSPRT-ZFXB-8-0','1','2.040','2.040','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZFXB-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZFXB-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXB-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-06-04 18:54:03' WHERE kode_barang='PSPRT-ZFXB-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZFXB-8-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-06-04 18:54:03','TOKO','DUPSN','PSPRT','PSPRT-ZFXB-8-0','1','2.040','2.040','1','2.040','2.040','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZFXB-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-04' WHERE no_faktur_beli=''; 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-20260604-0001','1','PSPRT-ZFXB-9-0','1','2.450','2.450','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZFXB-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZFXB-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFXB-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-06-04 18:54:03' WHERE kode_barang='PSPRT-ZFXB-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZFXB-9-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-06-04 18:54:03','TOKO','DUPSN','PSPRT','PSPRT-ZFXB-9-0','1','2.450','2.450','1','2.450','2.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZFXB-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFXB-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-04' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260604-0001','2026-06-04','18:53','13.800','kasirbip','2026-06-03 18:54:03'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02114','SAL','1','CINCIN SILVER','CROM ULANG PUTIH GLOSY COMB DOFF AMPLAS GRF JGN HILANG','2.000','1','50000','50000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0005','2026-06-04','2026-06-03 18:59:27','SERVICE : SV-02114','.','TBC','50000','50000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0006','D','2026-06-04','18:59:27','TBC','SERVICE','SV-02114','23275308014','50000','23275358014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02114','2026-06-04','2026-06-04','18:59:27','PLG0011730','kasirbip','2026-06-12','kasirbip','2026-06-03 18:59:27','2.000','0','0','0','50000','0','50000','50000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260603-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260603-0009'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','19:18:47'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','19:19:11'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02356','PUT','1','PER','WEDD RING','','','3.000','','925.00','1','100000','0','1300000','0','1300000','sz 18.5 crom putih gllosy','grf 27.06.2026 font Berkshire','Exspress 100.000','0','','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0006','2026-06-04','2026-06-03 19:19:57','PESANAN : DP-02356','.','TBC','1300000','1300000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0007','D','2026-06-04','19:19:57','TBC','PESANAN','DP-02356','23275358014','1300000','23276658014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02356','2026-06-04','2026-06-04','19:19:57','PLG0011731','PUT','2026-06-10','kasirbip','2026-06-03 19:19:57','3.000','0','0','0','1300000','0','0','1300000','1300000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','19:21:24'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02357','PUT','1','PER','WEDD RING','','','3.000','','925.00','1','100000','0','900000','0','900000','exspress 100.000','sz 20 crom doff semprot','grf 27.06.26 font Berkshire','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0007','2026-06-04','2026-06-03 19:23:16','PESANAN : DP-02357','.','TBC','900000','900000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0008','D','2026-06-04','19:23:16','TBC','PESANAN','DP-02357','23276658014','900000','23277558014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02357','2026-06-04','2026-06-04','19:23:16','PLG0011732','PUT','2026-06-10','kasirbip','2026-06-03 19:23:16','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02358','PUT','1','PER','WEDD RING','','','3.000','','925.00','1','100000','0','900000','0','900000','exspress 100.000','sz 20 crom doff semprot','grf 27.06.26 font Berkshire','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0008','2026-06-04','2026-06-03 19:23:44','PESANAN : DP-02358','.','TBC','900000','900000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0009','D','2026-06-04','19:23:44','TBC','PESANAN','DP-02358','23277558014','900000','23278458014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02358','2026-06-04','2026-06-04','19:23:44','PLG0011733','PUT','2026-06-10','kasirbip','2026-06-03 19:23:44','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02359','DIL','1','PER','WEDD RING','','','1.000','','925.00','1','100000','0','800000','0','800000','SIZE 17.5 GRF: PAW (BERKSHIRE)','CROM PUTIH DOFF MIX GLOSSY','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0009','2026-06-04','2026-06-03 19:24:37','PESANAN : DP-02359','-','TBC','800000','800000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0010','D','2026-06-04','19:24:37','TBC','PESANAN','DP-02359','23278458014','800000','23279258014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02359','2026-06-04','2026-06-04','19:24:37','PLG0011734','DIL','2026-06-30','sby','2026-06-03 19:24:37','1.000','0','0','0','800000','0','0','800000','800000','0'); 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-00000351','X-00000351','GELANG KAKU KUNING','GR','---','GLKK','BELI','BELI001','5626000','2026-06-03','3.880','1','kasir','2026-06-03 19:27:07'); DELETE FROM tp_barang WHERE kode_dept = 'X-GLKK'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GLKK','X-00000351','X-00000351'); 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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260603-0001','TF GLK','FIR','1','BELI','BELI001','GLKK', 'X-00000351', 'GELANG KAKU KUNING','3.880','3.880','70.00','4480000','5626000','1450000','1','5626000','5626000','MULUS'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-03','BELI','BELI001','GLKK','GLKK','70.00','3.880','3.880','1','3.880','3.880','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,status_valid,type_bayar) VALUES ('FB-260603-0001','2026-06-03','2026-06-03','19:27:07','FIR','---','3.880','5626000','5626000','5626000','5626000','5626000','kasir','2026-06-03 19:27:07','FB-260603-0001','OPEN','CASH'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260603-0001','-','JKT','','JKT','','kasir','2026-06-03 19:27:07'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-03' 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,status_valid) VALUES ('KK-260603-0001','K','2026-06-03','19:27:07','kasir','PEMBELIAN UMUM','FB-260603-0001','0','5626000','-5626000','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-03 ','19:29:01'); UPDATE tm_user SET nama_lkp='b',pass_key='579',type='OWN' WHERE user_id='b'; INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02358'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02358'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02358'; 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-260604-0002','K','2026-06-04','19:30:36','Nagatech','PESANAN BATAL','DP-02358','10094200','0','10094200'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02360','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1200000','0','1200000','putih glosy 14 zirkon','sz 8 font syahrani grf Aditya','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0010','2026-06-04','2026-06-03 19:31:18','PESANAN : DP-02360','.','TBC','1200000','1200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0011','D','2026-06-04','19:31:18','TBC','PESANAN','DP-02360','23279258014','1200000','23280458014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02360','2026-06-04','2026-06-04','19:31:18','PLG0011735','KUR','2026-06-23','kasirbip','2026-06-03 19:31:18','3.000','0','0','0','1200000','0','0','1200000','1200000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02361','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','0','900000','900000','putih glosy comb doff semprot 1 zirkon','sz 18.5 font syahrani grf Maulydiani','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0011','2026-06-04','2026-06-03 19:34:45','PESANAN : DP-02361','.','TBC','900000','900000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0012','D','2026-06-04','19:34:45','TBC','PESANAN','DP-02361','23280458014','900000','23281358014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02361','2026-06-04','2026-06-04','19:34:45','PLG0011736','KUR','2026-06-23','kasirbip','2026-06-03 19:34:45','2.000','0','0','0','900000','0','900000','900000','900000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-03 ','19:43:55'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-03 ','19:57:26'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','20:01:57'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-03 ','20:03:44'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02362','VAN','1','GOLD','WEDDING RING','','','2.500','','375.00','1','2450000','1500000','0','750000','4500000','permata 1','Size:18 Grf:ZAKY (Font:Berkshire)','Putih','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0012','2026-06-04','2026-06-03 20:30:59','PESANAN : DP-02362','-','TBC','3100000','3100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0013','D','2026-06-04','20:30:59','TBC','PESANAN','DP-02362','23281358014','3100000','23284458014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02362','2026-06-04','2026-06-04','20:30:59','PLG0011737','VAN','2026-06-30','sby','2026-06-03 20:30:59','2.500','0','0','0','3100000','0','750000','4510000','4510000','1410000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-03 ','20:34:48'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02363','VAN','1','PLD','WEDDING RING','','','5.000','','10.00','1','1200000','350000','0','800000','2550000','Size: 33','GRF: ERICA (Berkshire)','finishing: putih doff mix glossy','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0013','2026-06-04','2026-06-03 20:37:57','PESANAN : DP-02363','-','TBC','1700000','1700000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0014','D','2026-06-04','20:37:57','TBC','PESANAN','DP-02363','23284458014','1700000','23286158014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02363','2026-06-04','2026-06-04','20:37:57','PLG0011738','VAN','2026-06-30','sby','2026-06-03 20:37:57','5.000','0','0','0','1700000','0','800000','2550000','2550000','850000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-03 ','20:41:26'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02364','DIL','1','PER','WEDD RING','','','1.000','','925.00','1','100000','0','850000','0','850000','SIZE 17.5 GRF: Lani (infinity) font : (vladimir)','crom putih doff mix rose gold','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0014','2026-06-04','2026-06-03 20:57:24','PESANAN : DP-02364','-','TBC','850000','850000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0015','D','2026-06-04','20:57:24','TBC','PESANAN','DP-02364','23286158014','850000','23287008014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02364','2026-06-04','2026-06-04','20:57:24','PLG0011739','DIL','2026-06-30','sby','2026-06-03 20:57:24','1.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02365','DIL','1','PER','WEDD RING','','','1.000','','925.00','1','100000','0','1050000','0','1050000','PERMATA 14 BUTIR','SIZE 13.5 GRF: Bad (infinity) font (vladimir)','crom rose gold','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0015','2026-06-04','2026-06-03 21:04:08','PESANAN : DP-02365','-','TBC','1050000','1050000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0016','D','2026-06-04','21:04:08','TBC','PESANAN','DP-02365','23287008014','1050000','23288058014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02365','2026-06-04','2026-06-04','21:04:08','PLG0011740','DIL','2026-06-30','sby','2026-06-03 21:04:08','1.000','0','0','0','1050000','0','0','1050000','1050000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02366','DIL','1','PLD','WEDD RING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','permata 1 butir','size 17 . grf : Miftachul Ilmiah ?? (vintage)','crom putih doff mix glossy rose gold','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0016','2026-06-04','2026-06-03 21:57:39','PESANAN : DP-02366','-','TBC','1300000','1300000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0017','D','2026-06-04','21:57:39','TBC','PESANAN','DP-02366','23288058014','1300000','23289358014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02366','2026-06-04','2026-06-04','21:57:39','PLG0011741','DIL','2026-06-30','sby','2026-06-03 21:57:39','3.500','0','0','0','1300000','0','750000','1985000','1985000','685000');