INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-29 ','07:38:37'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-29 ','07:57:23'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-29 ','08:55:10'); 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-20261029-0001','1','PSPLT-ZJBI-1-0','1','2.200','2.200','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBI-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBI-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBI-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBI-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-29 08:55:47' WHERE kode_barang='PSPLT-ZJBI-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBI-1-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-10-29 08:55:47','TOKO','MMPSN','PSPLT','PSPLT-ZJBI-1-0','1','2.200','2.200','1','2.200','2.200','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-ZJBI-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBI-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261029-0001','2026-10-29','08:55','2.200','kasir','2026-10-29 08:55:47'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-29 ','10:31:11'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-29 ','10:43:02'); 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-261029-0001','kasirbip','1',' DP-04370BI','TOKO','BIPPSN','PSPRT-ZJBC-51-0','CINCIN PERAK ','','1.970','1','100.00','201000','0','0','17800','1000000','0','0','0','1000000','SAL','00048571','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-51-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBC-51-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-261029-0001','2026-10-29','1.970','2026-10-29','10:46:15','PLG0018087','1000000','1000000','0','1000000','0','kasirbip','2026-10-29 10:46:15','FJ-261029-0001','DP-04370','1000000'); 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-10-29','FJ-261029-0001','2026-10-29','10:46:15','SAL','1000000','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-261029-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-261029-0002','kasirbip',' 1',' DP-04369BI','TOKO','BIPPSN','PSPRT-ZJBC-50-0','CINCIN PERAK ','','2.610','1','100.00','267000','0','0','17800','850000','0','0','0','850000','SAL','00048570','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-50-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.610',berat_jual_asli=berat_jual_asli+'2.610',stock_jual='1',berat_akhir=berat_akhir-'2.610',berat_akhir_asli=berat_akhir_asli-'2.610',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBC-50-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-261029-0002','2026-10-29','2.610','2026-10-29','10:46:15','PLG0018088','850000','850000','0','850000','0','kasirbip','2026-10-29 10:46:15','FJ-261029-0001','DP-04369','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-10-29','FJ-261029-0002','2026-10-29','10:46:15','SAL','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-261029-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0002'; 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-20261029-0002','1','LXPER-ZJBG-1-0','1','1.770','1.770','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-1-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-1-0','1','1.770','1.770','1','1.770','1.770','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-2-0','1','1.570','1.570','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-2-0','1','1.570','1.570','1','1.570','1.570','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-3-0','1','1.510','1.510','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-3-0','1','1.510','1.510','1','1.510','1.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-4-0','1','1.680','1.680','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-4-0','1','1.680','1.680','1','1.680','1.680','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-5-0','1','2.240','2.240','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-5-0','1','2.240','2.240','1','2.240','2.240','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-6-0','1','1.540','1.540','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-6-0','1','1.540','1.540','1','1.540','1.540','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-7-0','1','1.250','1.250','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-7-0','1','1.250','1.250','1','1.250','1.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-8-0','1','1.760','1.760','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-8-0','1','1.760','1.760','1','1.760','1.760','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-9-0','1','1.630','1.630','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-9-0','1','1.630','1.630','1','1.630','1.630','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-10-0','1','3.550','3.550','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-10-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-10-0','1','3.550','3.550','1','3.550','3.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-11-0','1','3.470','3.470','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-11-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-11-0','1','3.470','3.470','1','3.470','3.470','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-12-0','1','4.060','4.060','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-12-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-12-0','1','4.060','4.060','1','4.060','4.060','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-13-0','1','3.880','3.880','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-13-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-13-0','1','3.880','3.880','1','3.880','3.880','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-14-0','1','2.820','2.820','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-14-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-14-0','1','2.820','2.820','1','2.820','2.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-15-0','1','1.380','1.380','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-15-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-15-0','1','1.380','1.380','1','1.380','1.380','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-16-0','1','1.790','1.790','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-16-0','1','1.790','1.790','1','1.790','1.790','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-17-0','1','1.670','1.670','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-17-0','1','1.670','1.670','1','1.670','1.670','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-18-0','1','1.420','1.420','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-18-0','1','1.420','1.420','1','1.420','1.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-19-0','1','1.360','1.360','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-19-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-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-19-0','1','1.360','1.360','1','1.360','1.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0002','1','LXPER-ZJBG-20-0','1','3.380','3.380','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBG-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-29 10:52:33' WHERE kode_barang='LXPER-ZJBG-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBG-20-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:52:33','TOKO','DUPERBDG','LXPER','LXPER-ZJBG-20-0','1','3.380','3.380','1','3.380','3.380','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBG-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261029-0002','2026-10-29','10:51','43.730','kasirbip','2026-10-29 10:52:32'); 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-20261029-0003','1','PSPRT-ZJBG-29-0','1','2.820','2.820','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-29 10:53:57' WHERE kode_barang='PSPRT-ZJBG-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-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-10-29 10:53:57','TOKO','DUPSN','PSPRT','PSPRT-ZJBG-29-0','1','2.820','2.820','1','2.820','2.820','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-ZJBG-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0003','1','PSPRT-ZJBG-30-0','1','2.160','2.160','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-29 10:53:57' WHERE kode_barang='PSPRT-ZJBG-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-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-10-29 10:53:57','TOKO','DUPSN','PSPRT','PSPRT-ZJBG-30-0','1','2.160','2.160','1','2.160','2.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-ZJBG-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0003','1','PSPRT-ZJBG-36-0','1','1.580','1.580','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-29 10:53:57' WHERE kode_barang='PSPRT-ZJBG-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-36-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:53:57','TOKO','DUPSN','PSPRT','PSPRT-ZJBG-36-0','1','1.580','1.580','1','1.580','1.580','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-ZJBG-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0003','1','PSPRT-ZJBG-39-0','1','3.090','3.090','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-29 10:53:57' WHERE kode_barang='PSPRT-ZJBG-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-39-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:53:57','TOKO','DUPSN','PSPRT','PSPRT-ZJBG-39-0','1','3.090','3.090','1','3.090','3.090','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-ZJBG-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0003','1','PSPRT-ZJBG-40-0','1','3.590','3.590','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-29 10:53:57' WHERE kode_barang='PSPRT-ZJBG-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-40-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 10:53:57','TOKO','DUPSN','PSPRT','PSPRT-ZJBG-40-0','1','3.590','3.590','1','3.590','3.590','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-ZJBG-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261029-0003','2026-10-29','10:52','13.240','kasirbip','2026-10-29 10:53:57'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-29 ','10:59:15'); 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-261029-0003','kasirbip','1',' DP-04335BI','TOKO','BIPPSN','PSPLT-ZJBF-31-0','CINCIN PALADIUM ','','2.510','1','32.00','1061000','0','0','17800','2130500','0','0','0','2130500','SULIS','00048641','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBF-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPLT-ZJBF-31-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-261029-0003','2026-10-29','2.510','2026-10-29','12:04:27','PLG0018089','2130500','2130500','0','2130500','0','kasirbip','2026-10-29 12:04:27','FJ-261029-0003','DP-04335','1920000'); 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-10-29','FJ-261029-0003','2026-10-29','12:04:27','SULIS','2130500','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-261029-0001','2026-10-29','2026-10-29 12:04:27','PENJUALAN : FJ-261029-0003','.','TBC','210500','210500','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-261029-0002','D','2026-10-29','12:04:27','TBC','PENJUALAN','FJ-261029-0003','30099798964','210500','30100009464','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='210500' WHERE no_faktur_jual='FJ-261029-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0003'; 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-261029-0004','kasirbip','1',' DP-04449DU','TOKO','DUPSN','PSPRT-ZJBF-20-0','CINCIN PERAK CM03 ','','3.960','1','100.00','404000','0','0','17800','1450000','0','0','0','1450000','MIL','00048630','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.960',berat_jual_asli=berat_jual_asli+'3.960',stock_jual='1',berat_akhir=berat_akhir-'3.960',berat_akhir_asli=berat_akhir_asli-'3.960',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBF-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-261029-0004','2026-10-29','3.960','2026-10-29','12:12:34','PLG0018090','1450000','1450000','0','1450000','0','kasirbip','2026-10-29 12:12:33','FJ-261029-0004','DP-04449','1450000'); 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-10-29','FJ-261029-0004','2026-10-29','12:12:34','MIL','1450000','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-261029-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0004'; 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-261029-0005','kasirbip','1',' 750K-135 ','TOKO','BIPCMP','BDCM-ZFAE-11-0','CINCIN EMAS ','','1.170','1','45.00','1220000','0','0','17800','2400000','0','0','0','2400000','KUR','00044418','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZFAE-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='BDCM-ZFAE-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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-261029-0005','2026-10-29','1.170','2026-10-29','13:10:33','PLG0018091','2400000','2400000','0','2400000','0','kasirbip','2026-10-29 13:10:33','FJ-261029-0005','','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-10-29','FJ-261029-0005','2026-10-29','13:10:33','KUR','2400000','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-261029-0002','2026-10-29','2026-10-29 13:10:33','PENJUALAN : FJ-261029-0005','..','TBC','2400000','2400000','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-261029-0003','D','2026-10-29','13:10:33','TBC','PENJUALAN','FJ-261029-0005','30100009464','2400000','30102409464','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='2400000' WHERE no_faktur_jual='FJ-261029-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0005'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-29 ','15:01:04'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-29 ','15:11:17'); 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-261029-0006','kasirbip','1',' DP-04600DU','TOKO','DUPSN','PSPRT-ZJBG-36-0','CINCIN PERAK ','','1.580','1','100.00','162000','0','0','17800','850000','0','0','0','850000','PUT','00048690','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBG-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-261029-0006','2026-10-29','1.580','2026-10-29','15:12:21','PLG0018092','850000','850000','0','850000','0','kasirbip','2026-10-29 15:12:20','FJ-261029-0006','DP-04600','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-10-29','FJ-261029-0006','2026-10-29','15:12:21','PUT','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-261029-0006' 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-261029-0007','kasirbip',' 1',' DP-04601DU','TOKO','DUPSN','PSPRT-ZJBG-30-0','CINCIN PERAK ','','2.160','1','100.00','221000','0','0','17800','850000','0','0','0','850000','PUT','00048684','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBG-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-261029-0007','2026-10-29','2.160','2026-10-29','15:12:21','PLG0018093','850000','850000','0','850000','0','kasirbip','2026-10-29 15:12:20','FJ-261029-0006','DP-04601','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-10-29','FJ-261029-0007','2026-10-29','15:12:21','PUT','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-261029-0007' LIMIT 1; 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-20261029-0004','1','PSPLT-ZJBG-37-0','1','3.900','3.900','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-29 15:14:14' WHERE kode_barang='PSPLT-ZJBG-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBG-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-10-29 15:14:14','TOKO','JOGPSN','PSPLT','PSPLT-ZJBG-37-0','1','3.900','','1','3.900','','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-ZJBG-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0004','1','PSPLT-ZJBG-44-0','1','3.250','3.250','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-44-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-44-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-44-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-29 15:14:14' WHERE kode_barang='PSPLT-ZJBG-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBG-44-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 15:14:14','TOKO','JOGPSN','PSPLT','PSPLT-ZJBG-44-0','1','3.250','','1','3.250','','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-ZJBG-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-44-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0004','1','PSPLT-ZJBG-43-0','1','2.800','2.800','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-43-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-43-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-43-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-29 15:14:14' WHERE kode_barang='PSPLT-ZJBG-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBG-43-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-10-29 15:14:14','TOKO','JOGPSN','PSPLT','PSPLT-ZJBG-43-0','1','2.800','','1','2.800','','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-ZJBG-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-43-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0004','1','PSPRT-ZJBG-38-0','1','2.870','2.870','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-29 15:14:14' WHERE kode_barang='PSPRT-ZJBG-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-38-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-10-29 15:14:14','TOKO','JOGPSN','PSPRT','PSPRT-ZJBG-38-0','1','2.870','','1','2.870','','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-ZJBG-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0004','1','PSPRT-ZJBG-45-0','1','3.370','3.370','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-45-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-45-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-45-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-29 15:14:14' WHERE kode_barang='PSPRT-ZJBG-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-45-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-10-29 15:14:14','TOKO','JOGPSN','PSPRT','PSPRT-ZJBG-45-0','1','3.370','','1','3.370','','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-ZJBG-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-45-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261029-0004','2026-10-29','15:01','16.190','jogja','2026-10-29 15:14:14'); 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-04861','MIL ','1','PER','WEDRING PROMO','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwo 20 YL-01 grf Widia','sz cwe 10 grf Ramdan','font brekshire EXSPRESS 100.000','100000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261029-0003','2026-10-29','2026-10-29 15:44:38','PESANAN : DP-04861','.','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-261029-0004','D','2026-10-29','15:44:38','TBC','PESANAN','DP-04861','30102409464','950000','30103359464','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-04861','2026-10-29','2026-10-29','15:44:38','PLG0018094','MIL ','2026-11-13','kasirbip','2026-10-29 15:44:38','3.000','0','0','0','950000','0','0','950000','950000','0'); 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-261029-0008','kasirbip','1',' DP-04578BI','TOKO','BIPPSN','PSPRT-ZJBG-35-0','CINCIN PERAK CP03 ','','4.030','1','100.00','412000','0','0','17800','1400000','0','0','0','1400000','SULIS','00048689','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBG-35-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-261029-0008','2026-10-29','4.030','2026-10-29','16:35:01','PLG0018095','1400000','1400000','0','1400000','0','kasirbip','2026-10-29 16:35:00','FJ-261029-0008','DP-04578','1400000'); 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-10-29','FJ-261029-0008','2026-10-29','16:35:01','SULIS','1400000','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-261029-0008' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0008'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-29 ','16:53:41'); 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-261029-0009','kasir','1',' DP-04356MM','TOKO','MMPSN','PSPRT-ZJBG-32-0','CINCIN PERAK SR05 YL01 ','','2.950','1','100.00','301000','0','0','17800','950000','0','0','0','950000','ALIKA','00048686','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBG-32-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-261029-0009','2026-10-29','2.950','2026-10-29','16:56:06','PLG0018096','950000','950000','0','950000','0','kasir','2026-10-29 16:56:05','FJ-261029-0009','DP-04356','950000'); 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-10-29','FJ-261029-0009','2026-10-29','16:56:06','ALIKA','950000','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-261029-0009' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-29 ','17:04:56'); 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-20261029-0005','1','PSGT-ZJBH-6-0','1','2.530','2.530','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBH-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBH-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBH-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBH-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSGT-ZJBH-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBH-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-10-29 17:09:14','TOKO','SBYPSN','PSGT','PSGT-ZJBH-6-0','1','2.530','2.530','1','2.530','2.530','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-ZJBH-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBH-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPRT-ZJBH-7-0','1','2.970','2.970','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBH-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBH-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBH-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPRT-ZJBH-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBH-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-10-29 17:09:14','TOKO','SBYPSN','PSPRT','PSPRT-ZJBH-7-0','1','2.970','2.970','1','2.970','2.970','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-ZJBH-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPLT-ZJBH-8-0','1','3.370','3.370','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBH-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBH-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBH-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPLT-ZJBH-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBH-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-10-29 17:09:14','TOKO','SBYPSN','PSPLT','PSPLT-ZJBH-8-0','1','3.370','3.370','1','3.370','3.370','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-ZJBH-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPRT-ZJBH-9-0','1','2.710','2.710','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBH-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBH-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBH-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPRT-ZJBH-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBH-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-10-29 17:09:14','TOKO','SBYPSN','PSPRT','PSPRT-ZJBH-9-0','1','2.710','2.710','1','2.710','2.710','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-ZJBH-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPRT-ZJBH-10-0','1','3.110','3.110','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBH-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBH-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBH-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPRT-ZJBH-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBH-10-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-10-29 17:09:14','TOKO','SBYPSN','PSPRT','PSPRT-ZJBH-10-0','1','3.110','3.110','1','3.110','3.110','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-ZJBH-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPLT-ZJBH-11-0','1','3.360','3.360','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBH-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBH-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBH-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPLT-ZJBH-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBH-11-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-10-29 17:09:14','TOKO','SBYPSN','PSPLT','PSPLT-ZJBH-11-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-ZJBH-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSGT-ZJBH-12-0','1','3.300','3.300','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBH-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBH-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBH-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBH-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSGT-ZJBH-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBH-12-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-10-29 17:09:14','TOKO','SBYPSN','PSGT','PSGT-ZJBH-12-0','1','3.300','3.300','1','3.300','3.300','57.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-ZJBH-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBH-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPRT-ZJBH-13-0','1','3.640','3.640','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBH-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBH-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBH-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPRT-ZJBH-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBH-13-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-10-29 17:09:14','TOKO','SBYPSN','PSPRT','PSPRT-ZJBH-13-0','1','3.640','3.640','1','3.640','3.640','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-ZJBH-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSGT-ZJBH-14-0','1','2.480','2.480','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBH-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBH-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBH-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBH-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSGT-ZJBH-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBH-14-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 17:09:14','TOKO','SBYPSN','PSGT','PSGT-ZJBH-14-0','1','2.480','2.480','1','2.480','2.480','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-ZJBH-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBH-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPLT-ZJBH-15-0','1','3.280','3.280','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBH-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBH-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBH-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPLT-ZJBH-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBH-15-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 17:09:14','TOKO','SBYPSN','PSPLT','PSPLT-ZJBH-15-0','1','3.280','3.280','1','3.280','3.280','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-ZJBH-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPLT-ZJBH-16-0','1','4.000','4.000','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBH-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBH-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBH-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPLT-ZJBH-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBH-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 17:09:14','TOKO','SBYPSN','PSPLT','PSPLT-ZJBH-16-0','1','4.000','4.000','1','4.000','4.000','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-ZJBH-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPLT-ZJBH-17-0','1','2.780','2.780','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBH-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBH-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBH-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPLT-ZJBH-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBH-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 17:09:14','TOKO','SBYPSN','PSPLT','PSPLT-ZJBH-17-0','1','2.780','2.780','1','2.780','2.780','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-ZJBH-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' 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-20261029-0005','1','PSPRT-ZJBH-18-0','1','3.890','3.890','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBH-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBH-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBH-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-29 17:09:14' WHERE kode_barang='PSPRT-ZJBH-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBH-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-29 17:09:14','TOKO','SBYPSN','PSPRT','PSPRT-ZJBH-18-0','1','3.890','3.890','1','3.890','3.890','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-ZJBH-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261029-0005','2026-10-29','17:05','41.420','sby','2026-10-29 17:09:14'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-29 ','17:34:22'); 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-04862','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','37.50','1','2270000','1400000','0','850000','4350000','PERMATA 14','SIZE: 20 TNPA UKIR','PUTIH GLOSSY','140000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261029-0004','2026-10-29','2026-10-29 17:36:22','PESANAN : DP-04862','-','TBC','3000000','3000000'); 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-261029-0005','D','2026-10-29','17:36:22','TBC','PESANAN','DP-04862','30103359464','3000000','30106359464','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-04862','2026-10-29','2026-10-29','17:36:22','PLG0018097','VAN','2026-11-21','sby','2026-10-29 17:36:22','2.500','0','0','0','3000000','0','850000','4490000','4490000','1490000'); 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-04863','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','SIZE: 22','GRF: Chintya&Febry FONT: VLADIMIR','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-261029-0005','2026-10-29','2026-10-29 17:39:07','PESANAN : DP-04863','-','TBC','1500000','1500000'); 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-261029-0006','D','2026-10-29','17:39:07','TBC','PESANAN','DP-04863','30106359464','1500000','30107859464','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-04863','2026-10-29','2026-10-29','17:39:07','PLG0018098','VAN','2026-11-21','sby','2026-10-29 17:39:07','4.000','0','0','0','1500000','0','800000','2200000','2200000','700000'); 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-04864','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwo 15.5 crom pitih glosy doff semprot','grf Sakila font yeseva','EXSPRESSS 100.000','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-261029-0006','2026-10-29','2026-10-29 17:54:39','PESANAN : DP-04864','.','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-261029-0007','D','2026-10-29','17:54:39','TBC','PESANAN','DP-04864','30107859464','950000','30108809464','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-04864','2026-10-29','2026-10-29','17:54:39','PLG0018099','PUT','2026-11-13','kasirbip','2026-10-29 17:54:39','3.000','0','0','0','950000','0','0','950000','950000','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-04865','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','1050000','0','1050000','sz cwe 11 putih glosy','grf Irman font yeseva','EXSPRESS 100.000','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-261029-0007','2026-10-29','2026-10-29 17:57:10','PESANAN : DP-04865','.','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-261029-0008','D','2026-10-29','17:57:10','TBC','PESANAN','DP-04865','30108809464','1050000','30109859464','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-04865','2026-10-29','2026-10-29','17:57:10','PLG0018100','MIL','2026-11-13','kasirbip','2026-10-29 17:57:10','3.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-04866','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','1050000','0','1050000','sz cwe 11 putih glosy','grf Irman font yeseva','EXSPRESS 100.000','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-261029-0008','2026-10-29','2026-10-29 17:57:10','PESANAN : DP-04866','.','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-261029-0009','D','2026-10-29','17:57:10','TBC','PESANAN','DP-04866','30109859464','1050000','30110909464','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-04866','2026-10-29','2026-10-29','17:57:10','PLG0018101','MIL','2026-11-13','kasirbip','2026-10-29 17:57:10','3.000','0','0','0','1050000','0','0','1050000','1050000','0'); 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-261029-0010','kasirbip','1',' 750K-9-278','TOKO','BIPPER','PBDG-ZGAE-19-0','CINCIN SILVER 925 ','','1.630','1','100.00','167000','0','0','17800','850000','0','0','0','850000','SAL','00045207','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGAE-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PBDG-ZGAE-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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-261029-0010','2026-10-29','1.630','2026-10-29','18:23:39','PLG0018102','850000','850000','0','850000','0','kasirbip','2026-10-29 18:23:38','FJ-261029-0010','','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-10-29','FJ-261029-0010','2026-10-29','18:23:39','SAL','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-261029-0009','2026-10-29','2026-10-29 18:23:38','PENJUALAN : FJ-261029-0010','.','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-261029-0010','D','2026-10-29','18:23:39','TBC','PENJUALAN','FJ-261029-0010','30110909464','850000','30111759464','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='850000' WHERE no_faktur_jual='FJ-261029-0010' LIMIT 1; INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-04866'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-04866'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-04866'; 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-261029-0002','K','2026-10-29','18:28:27','kasirbip','PESANAN BATAL','DP-04866','1994600','0','1994600'); 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-261029-0011','jogja','1',' DP-04455JO','TOKO','JOGPSN','PSPLT-ZJBG-43-0','CINCIN PALADIUM ','','2.800','1','17.00','629000','0','0','17800','980000','0','750000','0','1730000','ADL','00048697','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBG-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.800',berat_jual_asli=berat_jual_asli+'2.800',stock_jual='1',berat_akhir=berat_akhir-'2.800',berat_akhir_asli=berat_akhir_asli-'2.800',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPLT-ZJBG-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261029-0011','2026-10-29','2.800','2026-10-29','19:14:22','PLG0018103','980000','980000','750000','1730000','0','jogja','2026-10-29 19:14:20','FJ-261029-0011','DP-04455','1580000'); 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-10-29','FJ-261029-0011','2026-10-29','19:14:22','ADL','1730000','750000'); 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-261029-0010','2026-10-29','2026-10-29 19:14:20','PENJUALAN : FJ-261029-0011','','TBC','150000','150000','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-261029-0011','D','2026-10-29','19:14:22','TBC','PENJUALAN','FJ-261029-0011','30111759464','150000','30111909464','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='150000' WHERE no_faktur_jual='FJ-261029-0011' 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-261029-0012','jogja','1',' DP-04654JO','TOKO','JOGPSN','PSPLT-ZJBA-41-0','CINCIN PALADIUM ','','2.410','1','32.00','1019000','0','0','17800','1325500','0','750000','0','2075500','ADL','00048471','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBA-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPLT-ZJBA-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261029-0012','2026-10-29','2.410','2026-10-29','19:18:08','PLG0018104','1325500','1325500','750000','2075500','0','jogja','2026-10-29 19:18:08','FJ-261029-0012','DP-04654','1700000'); 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-10-29','FJ-261029-0012','2026-10-29','19:18:08','ADL','2075500','750000'); 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-261029-0011','2026-10-29','2026-10-29 19:18:08','PENJUALAN : FJ-261029-0012','','TBC','375500','375500','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-261029-0012','D','2026-10-29','19:18:08','TBC','PENJUALAN','FJ-261029-0012','30111909464','375500','30112284964','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='375500' WHERE no_faktur_jual='FJ-261029-0012' 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-261029-0013','jogja',' 1',' DP-04653JO','TOKO','JOGPSN','PSPLT-ZJBA-43-0','CINCIN PALADIUM ','','2.100','1','32.00','888000','0','0','17800','1225000','70000','900000','0','2125000','ADL','00048473','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBA-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPLT-ZJBA-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261029-0013','2026-10-29','2.100','2026-10-29','19:18:08','PLG0018105','1225000','1225000','900000','2125000','0','jogja','2026-10-29 19:18:08','FJ-261029-0012','DP-04653','1656000'); 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-10-29','FJ-261029-0013','2026-10-29','19:18:08','ADL','2125000','900000'); 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-261029-0012','2026-10-29','2026-10-29 19:18:08','PENJUALAN : FJ-261029-0013','','TBC','469000','469000','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-261029-0013','D','2026-10-29','19:18:08','TBC','PENJUALAN','FJ-261029-0013','30112284964','469000','30112753964','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='844500' WHERE no_faktur_jual='FJ-261029-0013' 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-04867','VAN','1','PER','WEDDRING SEPAKET CP08','','','3.000','','925.00','1','100000','0','1600000','0','1600000','SIZE PRIA: 22.5 GRF: Febby??','SIZE WANITA: 12 GRF: Juned??','FONT: VINTAGE FINISHING: PUTIH','100000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261029-0013','2026-10-29','2026-10-29 19:27:09','PESANAN : DP-04867','-','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-261029-0014','D','2026-10-29','19:27:09','TBC','PESANAN','DP-04867','30112753964','1700000','30114453964','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-04867','2026-10-29','2026-10-29','19:27:09','PLG0018106','VAN','2026-11-20','sby','2026-10-29 19:27:09','3.000','0','0','0','1700000','0','0','1700000','1700000','0'); 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-261029-0014','sby','1',' DP-04359SB','TOKO','SBYPSN','PSPLT-ZJBF-39-0','CINCIN PALADIUM ','','4.150','1','17.00','932000','0','0','17800','2212000','0','0','0','2212000','DIL','00048649','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBF-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPLT-ZJBF-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261029-0014','2026-10-29','4.150','2026-10-29','19:46:13','PLG0018107','2212000','2212000','0','2212000','0','sby','2026-10-29 19:46:13','FJ-261029-0014','DP-04359','1500000'); 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-10-29','FJ-261029-0014','2026-10-29','19:46:13','DIL','2212000','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-261029-0014','2026-10-29','2026-10-29 19:46:13','PENJUALAN : FJ-261029-0014','','TBC','712000','712000','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-261029-0015','D','2026-10-29','19:46:13','TBC','PENJUALAN','FJ-261029-0014','30114453964','712000','30115165964','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='712000' WHERE no_faktur_jual='FJ-261029-0014' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0014'; 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-261029-0015','kasirbip','1',' DP-04470DU','TOKO','DUPSN','PSPRT-ZJBF-18-0','CINCIN PERAK YL10 ','','3.850','1','100.00','393000','0','0','17800','1000000','0','0','0','1000000','MIL','00048628','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.850',berat_jual_asli=berat_jual_asli+'3.850',stock_jual='1',berat_akhir=berat_akhir-'3.850',berat_akhir_asli=berat_akhir_asli-'3.850',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBF-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-261029-0015','2026-10-29','3.850','2026-10-29','19:48:59','PLG0018108','1000000','1000000','0','1000000','0','kasirbip','2026-10-29 19:48:58','FJ-261029-0015','DP-04470','1000000'); 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-10-29','FJ-261029-0015','2026-10-29','19:48:59','MIL','1000000','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-261029-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0015'; 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-04868','KUR','1','PLD','WED RING','','','2.500','','10.00','1','1200000','350000','0','600000','1475000','YL01 sz 15 putih doff amplas','','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261029-0015','2026-10-29','2026-10-29 19:54:40','PESANAN : DP-04868','.','TBC','1180000','1180000'); 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-261029-0016','D','2026-10-29','19:54:40','TBC','PESANAN','DP-04868','30115165964','1180000','30116345964','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-04868','2026-10-29','2026-10-29','19:54:40','PLG0018109','KUR','2026-11-28','kasirbip','2026-10-29 19:54:40','2.500','0','0','0','1180000','0','600000','1475000','1475000','295000'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02303','SAL','1','CCN SILVER','PASANG 1 MATA KROM PUTIH GLOSSY FONT VINTAGE ROTTER','2.000','1','50000','50000'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02303','SAL','2','','','','','',''); 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-261029-0016','2026-10-29','2026-10-29 20:02:40','SERVICE : SV-02303','.','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-261029-0017','D','2026-10-29','20:02:40','TBC','SERVICE','SV-02303','30116345964','50000','30116395964','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-02303','2026-10-29','2026-10-29','20:02:40','PLG0018110','kasirbip','2026-11-13','kasirbip','2026-10-29 20:02:40','2.000','0','0','0','50000','0','50000','50000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-29 ','20:02:56'); 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-261029-0016','kasirbip','1',' DP-04822BI','TOKO','BIPPSN','PSPRT-ZJBG-46-0','CINCIN PERAK YL01 ','','2.990','1','100.00','305000','0','0','17800','850000','0','0','0','850000','SULIS','00048700','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='PSPRT-ZJBG-46-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-261029-0016','2026-10-29','2.990','2026-10-29','20:40:40','PLG0018111','850000','850000','0','850000','0','kasirbip','2026-10-29 20:40:39','FJ-261029-0016','DP-04822','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-10-29','FJ-261029-0016','2026-10-29','20:40:40','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-261029-0016' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261029-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261029-0016'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-30','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-29'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-29'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-29'; 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-10-29' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-29'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-29'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-29'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-29'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-30' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-29' 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-261030-0001','D','2026-10-30','21:18:48','TBC','SALDO AWAL','SALDO AWAL','0','30116395964','30116395964'); 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-261030-0001','D','2026-10-30','21:18:48','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); 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-261030-0001','D','2026-10-30','21:18:48','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-261030-0001','D','2026-10-30','21:18:48','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-261030-0001','D','2026-10-30','21:18:48','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-261030-0001','D','2026-10-30','21:18:48','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-261030-0001','D','2026-10-30','21:18:48','','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-261030-0001','D','2026-10-30','21:18:48','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-261030-0001','D','2026-10-30','21:18:48','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000'); 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-261030-0001','D','2026-10-30','21:18:48','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500'); 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-261030-0001','D','2026-10-30','21:18:48','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); 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-261030-0001','D','2026-10-30','21:18:48','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); UPDATE tp_system SET tgl_system='2026-10-30';