INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-23 ','08:07:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-23 ','08:26:55');
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-20260923-0001','1','PMM-ZIBB-1-0','1','2.420','2.420','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIBB-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIBB-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIBB-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-23 08:27:10' WHERE kode_barang='PMM-ZIBB-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIBB-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-09-23 08:27:10','TOKO','MMPER','PMM','PMM-ZIBB-1-0','1','2.420','2.420','1','2.420','2.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZIBB-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0001','1','PMM-ZIBB-2-0','1','2.020','2.020','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIBB-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIBB-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIBB-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-23 08:27:10' WHERE kode_barang='PMM-ZIBB-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIBB-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-09-23 08:27:10','TOKO','MMPER','PMM','PMM-ZIBB-2-0','1','2.020','2.020','1','2.020','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZIBB-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0001','1','PMM-ZIBB-3-0','1','3.520','3.520','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIBB-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIBB-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIBB-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-23 08:27:10' WHERE kode_barang='PMM-ZIBB-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIBB-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-09-23 08:27:10','TOKO','MMPER','PMM','PMM-ZIBB-3-0','1','3.520','3.520','1','3.520','3.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZIBB-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0001','1','PMM-ZIBB-4-0','1','3.530','3.530','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIBB-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIBB-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIBB-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-23 08:27:10' WHERE kode_barang='PMM-ZIBB-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIBB-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-09-23 08:27:10','TOKO','MMPER','PMM','PMM-ZIBB-4-0','1','3.530','3.530','1','3.530','3.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZIBB-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0001','1','PMM-ZIBB-5-0','1','1.710','1.710','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIBB-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIBB-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIBB-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-23 08:27:10' WHERE kode_barang='PMM-ZIBB-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIBB-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-09-23 08:27:10','TOKO','MMPER','PMM','PMM-ZIBB-5-0','1','1.710','1.710','1','1.710','1.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZIBB-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIBB-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260923-0001','2026-09-23','08:27','13.200','kasir','2026-09-23 08:27:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-23 ','10:23:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-23 ','11:33:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-23 ','11:36:48');
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-20260923-0002','1','LXPER-ZIBB-11-0','1','2.450','2.450','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIBB-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIBB-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIBB-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-23 11:37:18' WHERE kode_barang='LXPER-ZIBB-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIBB-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-09-23 11:37:18','TOKO','DUPERBDG','LXPER','LXPER-ZIBB-11-0','1','2.450','2.450','1','2.450','2.450','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-ZIBB-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0002','1','LXPER-ZIBB-12-0','1','1.990','1.990','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIBB-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIBB-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIBB-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-23 11:37:18' WHERE kode_barang='LXPER-ZIBB-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIBB-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-09-23 11:37:18','TOKO','DUPERBDG','LXPER','LXPER-ZIBB-12-0','1','1.990','1.990','1','1.990','1.990','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-ZIBB-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0002','1','LXPER-ZIBB-13-0','1','3.200','3.200','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIBB-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIBB-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIBB-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-23 11:37:18' WHERE kode_barang='LXPER-ZIBB-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIBB-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-09-23 11:37:18','TOKO','DUPERBDG','LXPER','LXPER-ZIBB-13-0','1','3.200','3.200','1','3.200','3.200','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-ZIBB-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0002','1','LXPER-ZIBB-14-0','1','3.460','3.460','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIBB-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIBB-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIBB-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-23 11:37:18' WHERE kode_barang='LXPER-ZIBB-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIBB-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-09-23 11:37:18','TOKO','DUPERBDG','LXPER','LXPER-ZIBB-14-0','1','3.460','3.460','1','3.460','3.460','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-ZIBB-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0002','1','LXPER-ZIBB-15-0','1','1.630','1.630','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIBB-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIBB-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIBB-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-23 11:37:18' WHERE kode_barang='LXPER-ZIBB-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIBB-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-09-23 11:37:18','TOKO','DUPERBDG','LXPER','LXPER-ZIBB-15-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-ZIBB-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIBB-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260923-0002','2026-09-23','11:37','12.730','kasirbip','2026-09-23 11:37:17');
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-20260923-0003','1','PSGT-ZIBB-25-0','1','1.700','1.700','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBB-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBB-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBB-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSGT-ZIBB-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBB-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSGT','PSGT-ZIBB-25-0','1','1.700','1.700','1','1.700','1.700','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-ZIBB-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSGT-ZIBB-26-0','1','2.000','2.000','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBB-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBB-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBB-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSGT-ZIBB-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBB-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSGT','PSGT-ZIBB-26-0','1','2.000','2.000','1','2.000','2.000','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-ZIBB-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-26-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSGT-ZIBB-27-0','1','1.840','1.840','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBB-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBB-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBB-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSGT-ZIBB-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBB-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSGT','PSGT-ZIBB-27-0','1','1.840','1.840','1','1.840','1.840','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-ZIBB-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSGT-ZIBB-28-0','1','2.240','2.240','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBB-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBB-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBB-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSGT-ZIBB-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBB-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSGT','PSGT-ZIBB-28-0','1','2.240','2.240','1','2.240','2.240','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-ZIBB-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPRT-ZIBB-29-0','1','1.910','1.910','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPRT-ZIBB-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-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-09-23 11:38:17','TOKO','DUPSN','PSPRT','PSPRT-ZIBB-29-0','1','1.910','1.910','1','1.910','1.910','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-ZIBB-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPRT-ZIBB-30-0','1','1.840','1.840','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPRT-ZIBB-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-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-09-23 11:38:17','TOKO','DUPSN','PSPRT','PSPRT-ZIBB-30-0','1','1.840','1.840','1','1.840','1.840','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-ZIBB-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPRT-ZIBB-31-0','1','1.960','1.960','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPRT-ZIBB-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSPRT','PSPRT-ZIBB-31-0','1','1.960','1.960','1','1.960','1.960','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-ZIBB-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPRT-ZIBB-32-0','1','4.900','4.900','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPRT-ZIBB-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSPRT','PSPRT-ZIBB-32-0','1','4.900','4.900','1','4.900','4.900','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-ZIBB-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPRT-ZIBB-34-0','1','1.800','1.800','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPRT-ZIBB-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-34-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSPRT','PSPRT-ZIBB-34-0','1','1.800','1.800','1','1.800','1.800','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-ZIBB-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPRT-ZIBB-35-0','1','3.570','3.570','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPRT-ZIBB-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 11:38:17','TOKO','DUPSN','PSPRT','PSPRT-ZIBB-35-0','1','3.570','3.570','1','3.570','3.570','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-ZIBB-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPLT-ZIBB-36-0','1','2.140','2.140','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBB-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBB-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBB-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBB-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPLT-ZIBB-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBB-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-09-23 11:38:17','TOKO','DUPSN','PSPLT','PSPLT-ZIBB-36-0','1','2.140','2.140','1','2.140','2.140','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-ZIBB-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBB-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPLT-ZIBB-37-0','1','2.110','2.110','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBB-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBB-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBB-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBB-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPLT-ZIBB-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBB-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-09-23 11:38:17','TOKO','DUPSN','PSPLT','PSPLT-ZIBB-37-0','1','2.110','2.110','1','2.110','2.110','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-ZIBB-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBB-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSGT-ZIBB-38-0','1','2.900','2.900','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBB-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBB-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBB-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSGT-ZIBB-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBB-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-09-23 11:38:17','TOKO','DUPSN','PSGT','PSGT-ZIBB-38-0','1','2.900','2.900','1','2.900','2.900','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-ZIBB-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0003','1','PSPRT-ZIBB-39-0','1','2.720','2.720','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-23 11:38:17' WHERE kode_barang='PSPRT-ZIBB-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-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-09-23 11:38:17','TOKO','DUPSN','PSPRT','PSPRT-ZIBB-39-0','1','2.720','2.720','1','2.720','2.720','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-ZIBB-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260923-0003','2026-09-23','11:37','33.630','kasirbip','2026-09-23 11:38:17');
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-20260923-0004','1','PBDG-ZIBB-6-0','1','1.120','1.120','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIBB-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIBB-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIBB-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-23 12:14:05' WHERE kode_barang='PBDG-ZIBB-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIBB-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-09-23 12:14:05','TOKO','BIPPER','PBDG','PBDG-ZIBB-6-0','1','1.120','1.120','1','1.120','1.120','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIBB-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0004','1','PBDG-ZIBB-7-0','1','2.020','2.020','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIBB-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIBB-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIBB-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-23 12:14:05' WHERE kode_barang='PBDG-ZIBB-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIBB-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-09-23 12:14:05','TOKO','BIPPER','PBDG','PBDG-ZIBB-7-0','1','2.020','2.020','1','2.020','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIBB-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0004','1','PBDG-ZIBB-8-0','1','3.360','3.360','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIBB-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIBB-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIBB-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-23 12:14:05' WHERE kode_barang='PBDG-ZIBB-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIBB-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-09-23 12:14:05','TOKO','BIPPER','PBDG','PBDG-ZIBB-8-0','1','3.360','3.360','1','3.360','3.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIBB-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0004','1','PBDG-ZIBB-9-0','1','3.200','3.200','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIBB-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIBB-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIBB-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-23 12:14:05' WHERE kode_barang='PBDG-ZIBB-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIBB-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-09-23 12:14:05','TOKO','BIPPER','PBDG','PBDG-ZIBB-9-0','1','3.200','3.200','1','3.200','3.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIBB-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' 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-20260923-0004','1','PBDG-ZIBB-10-0','1','3.880','3.880','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIBB-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIBB-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIBB-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-23 12:14:05' WHERE kode_barang='PBDG-ZIBB-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIBB-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-09-23 12:14:05','TOKO','BIPPER','PBDG','PBDG-ZIBB-10-0','1','3.880','3.880','1','3.880','3.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIBB-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIBB-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260923-0004','2026-09-23','12:13','13.580','kasirbip','2026-09-23 12:14:05');
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-20260923-0005','1','PSPRT-ZIBB-33-0','1','3.030','3.030','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-23 12:14:38' WHERE kode_barang='PSPRT-ZIBB-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-23 12:14:38','TOKO','BIPPSN','PSPRT','PSPRT-ZIBB-33-0','1','3.030','3.030','1','3.030','3.030','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-ZIBB-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260923-0005','2026-09-23','12:14','3.030','kasirbip','2026-09-23 12:14:38');
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-260923-0001','kasirbip','1',' 1.3K-115-2','TOKO','BIPPER','PBDG-ZIAF-39-0','CINCIN SILVER 925 ','','2.380','1','100.00','243000','0','0','17800','1400000','0','0','0','1400000','KUR','00047271','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIAF-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PBDG-ZIAF-39-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-260923-0001','2026-09-23','2.380','2026-09-23','12:48:48','PLG0016253','1400000','1400000','0','1400000','0','kasirbip','2026-09-23 12:48:47','FJ-260923-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-23','FJ-260923-0001','2026-09-23','12:48:48','KUR','1400000','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-260923-0001','2026-09-23','2026-09-23 12:48:47','PENJUALAN : FJ-260923-0001','.','TBC','1400000','1400000','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-260923-0002','D','2026-09-23','12:48:48','TBC','PENJUALAN','FJ-260923-0001','28174349964','1400000','28175749964','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='1400000' WHERE no_faktur_jual='FJ-260923-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-260923-0002','kasirbip',' 1',' 750K-15-29','TOKO','BIPPER','PBDG-ZIXD-8-0','CINCIN SILVER 925 ','','3.260','1','100.00','333000','0','0','17800','800000','0','0','0','800000','KUR','00046871','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.260',berat_jual_asli=berat_jual_asli+'3.260',stock_jual='1',berat_akhir=berat_akhir-'3.260',berat_akhir_asli=berat_akhir_asli-'3.260',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PBDG-ZIXD-8-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-260923-0002','2026-09-23','3.260','2026-09-23','12:48:48','PLG0016254','800000','800000','0','800000','0','kasirbip','2026-09-23 12:48:47','FJ-260923-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-23','FJ-260923-0002','2026-09-23','12:48:48','KUR','800000','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-260923-0002','2026-09-23','2026-09-23 12:48:47','PENJUALAN : FJ-260923-0002','.','TBC','800000','800000','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-260923-0003','D','2026-09-23','12:48:48','TBC','PENJUALAN','FJ-260923-0002','28175749964','800000','28176549964','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='2200000' WHERE no_faktur_jual='FJ-260923-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0002';
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-04188','NAD','1','PLD','WEDRING','','','2.000','','10.00','1','1200000','350000','0','700000','1400000','size 10 crom putih glossy','Grf Ibnu & Tina Font Vintage','Zircon 20','0','0','200000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260923-0003','2026-09-23','2026-09-23 13:03:50','PESANAN : DP-04188','.','TBC','1280000','1280000');
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-260923-0004','D','2026-09-23','13:03:50','TBC','PESANAN','DP-04188','28176549964','1280000','28177829964','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-04188','2026-09-23','2026-09-23','13:03:50','PLG0016255','NAD','2026-10-21','kasirbip','2026-09-23 13:03:50','2.000','0','0','0','1280000','0','700000','1600000','1600000','320000');
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-04189','NAD','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','size 22 crom putih doff semprot','Grf Tina & Ibnu Font Vintage','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260923-0004','2026-09-23','2026-09-23 13:05:25','PESANAN : DP-04189','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260923-0005','D','2026-09-23','13:05:25','TBC','PESANAN','DP-04189','28177829964','850000','28178679964','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-04189','2026-09-23','2026-09-23','13:05:25','PLG0016256','NAD','2026-10-21','kasirbip','2026-09-23 13:05:25','3.000','0','0','0','850000','0','0','850000','850000','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-260923-0003','kasirbip','1',' 1.050K-12-','TOKO','DUPERBDG','LXPER-ZBAH-32-0','CINCIN SILVER 925 ','','3.180','1','100.00','325000','0','0','17800','1150000','0','0','0','1150000','NAD','00041650','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='LXPER-ZBAH-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260923-0003','2026-09-23','3.180','2026-09-23','14:29:26','PLG0016257','1150000','1150000','0','1150000','0','kasirbip','2026-09-23 14:29:26','FJ-260923-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-23','FJ-260923-0003','2026-09-23','14:29:26','NAD','1150000','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-260923-0005','2026-09-23','2026-09-23 14:29:26','PENJUALAN : FJ-260923-0003','.','TBC','1150000','1150000','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-260923-0006','D','2026-09-23','14:29:26','TBC','PENJUALAN','FJ-260923-0003','28178679964','1150000','28179829964','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='1150000' WHERE no_faktur_jual='FJ-260923-0003' 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-260923-0004','kasirbip',' 1',' 800K-205-0','TOKO','DUPERBDG','LXPER-ZIXG-27-0','CINCIN SILVER 925 ','','2.740','1','100.00','280000','0','0','17800','900000','0','0','0','900000','NAD','00046994','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZIXG-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.740',berat_jual_asli=berat_jual_asli+'2.740',stock_jual='1',berat_akhir=berat_akhir-'2.740',berat_akhir_asli=berat_akhir_asli-'2.740',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='LXPER-ZIXG-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260923-0004','2026-09-23','2.740','2026-09-23','14:29:26','PLG0016258','900000','900000','0','900000','0','kasirbip','2026-09-23 14:29:26','FJ-260923-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-23','FJ-260923-0004','2026-09-23','14:29:26','NAD','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260923-0006','2026-09-23','2026-09-23 14:29:26','PENJUALAN : FJ-260923-0004','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260923-0007','D','2026-09-23','14:29:26','TBC','PENJUALAN','FJ-260923-0004','28179829964','900000','28180729964','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='2050000' WHERE no_faktur_jual='FJ-260923-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260923-0005','kasirbip','1',' DP-03615DU','TOKO','DUPSN','PSPRT-ZIAH-43-0','CINCIN PERAK ','','1.630','1','100.00','167000','0','0','17800','850000','0','0','0','850000','NAD','00047372','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-43-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-09-23' AND kode_barang='PSPRT-ZIAH-43-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-260923-0005','2026-09-23','1.630','2026-09-23','14:44:10','PLG0016259','850000','850000','0','850000','0','kasirbip','2026-09-23 14:44:09','FJ-260923-0005','DP-03615','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-09-23','FJ-260923-0005','2026-09-23','14:44:10','NAD','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-260923-0005' 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-260923-0006','kasirbip',' 1',' DP-03614DU','TOKO','DUPSN','PSPRT-ZIAH-40-0','CINCIN PERAK ','','1.480','1','100.00','151000','0','0','17800','900000','0','0','0','900000','NAD','00047369','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PSPRT-ZIAH-40-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-260923-0006','2026-09-23','1.480','2026-09-23','14:44:10','PLG0016260','900000','900000','0','900000','0','kasirbip','2026-09-23 14:44:09','FJ-260923-0005','DP-03614','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-23','FJ-260923-0006','2026-09-23','14:44:10','NAD','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260923-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0006';
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-260923-0007','kasirbip','1',' DP-03991DU','TOKO','DUPSN','PSPRT-ZIBA-15-0','CINCIN PERAK ','','4.260','1','100.00','435000','0','0','17800','900000','0','0','0','900000','NAD','00047413','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBA-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.260',berat_jual_asli=berat_jual_asli+'4.260',stock_jual='1',berat_akhir=berat_akhir-'4.260',berat_akhir_asli=berat_akhir_asli-'4.260',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PSPRT-ZIBA-15-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-260923-0007','2026-09-23','4.260','2026-09-23','14:54:51','PLG0016261','900000','900000','0','900000','0','kasirbip','2026-09-23 14:54:50','FJ-260923-0007','DP-03991','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-23','FJ-260923-0007','2026-09-23','14:54:51','NAD','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260923-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-23 ','16:00: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-260923-0008','kasir','1',' 800K-15-12','TOKO','MMPER','PMM-ZIXC-21-0','CINCIN SILVER 925 ','','2.860','1','100.00','292000','0','0','17800','900000','0','0','0','900000','ELLA','00046851','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZIXC-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PMM-ZIXC-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-260923-0008','2026-09-23','2.860','2026-09-23','16:02:10','PLG0016262','900000','900000','0','900000','0','kasir','2026-09-23 16:02:09','FJ-260923-0008','','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-09-23','FJ-260923-0008','2026-09-23','16:02:10','ELLA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260923-0007','2026-09-23','2026-09-23 16:02:09','PENJUALAN : FJ-260923-0008','0','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260923-0008','D','2026-09-23','16:02:10','TBC','PENJUALAN','FJ-260923-0008','28180729964','900000','28181629964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260923-0008' 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-260923-0009','kasir',' 1',' 750K-12-11','TOKO','MMPER','PMM-ZGBA-78-0','CINCIN SILVER 925 ','','1.850','1','100.00','189000','0','0','17800','850000','0','0','0','850000','ELLA','00045471','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGBA-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PMM-ZGBA-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-260923-0009','2026-09-23','1.850','2026-09-23','16:02:10','PLG0016263','850000','850000','0','850000','0','kasir','2026-09-23 16:02:09','FJ-260923-0008','','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-09-23','FJ-260923-0009','2026-09-23','16:02:10','ELLA','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-260923-0008','2026-09-23','2026-09-23 16:02:09','PENJUALAN : FJ-260923-0009','0','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-260923-0009','D','2026-09-23','16:02:10','TBC','PENJUALAN','FJ-260923-0009','28181629964','850000','28182479964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-260923-0009' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-23 ','16:16:44');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04190','ADL','1','PER','PROMISE RING','','','4.000','','925.00','2','100000','0','1500000','0','1500000','sz cwe 12 5 sz cwo 17 5','ukir fn vintage cwe: Riau.. cwo: Sherly..','mix warna yellowgold silver','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-260923-0009','2026-09-23','2026-09-23 17:56:06','PESANAN : DP-04190','-','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-260923-0010','D','2026-09-23','17:56:06','TBC','PESANAN','DP-04190','28182479964','1500000','28183979964','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-04190','2026-09-23','2026-09-23','17:56:06','PLG0016264','ADL','2026-10-17','jogja','2026-09-23 17:56:06','4.000','0','0','0','1500000','0','0','1500000','1500000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-23 ','18:24:13');
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-260923-0010','kasir','1',' TFCMR75-81','TOKO','TFCINMAS','TFCMR-YLXC-28-0','THIFA CINCIN MAS RG ','','0.600','1','81.00','1190000','0','0','17800','1275000','0','0','0','1275000','RISIANA','00040151','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YLXC-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='TFCMR-YLXC-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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-260923-0010','2026-09-23','0.600','2026-09-23','18:25:10','PLG0016265','1275000','1275000','0','1275000','0','kasir','2026-09-23 18:25:10','FJ-260923-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-09-23','FJ-260923-0010','2026-09-23','18:25:10','RISIANA','1275000','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-260923-0010','2026-09-23','2026-09-23 18:25:10','PENJUALAN : FJ-260923-0010','.','TBC','1275000','1275000','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-260923-0011','D','2026-09-23','18:25:10','TBC','PENJUALAN','FJ-260923-0010','28183979964','1275000','28185254964','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='1275000' WHERE no_faktur_jual='FJ-260923-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0010';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-09-23 ','18:35:36');
UPDATE tm_user SET nama_lkp='Thifa',pass_key='tk~uA4?AC',type='KSR' WHERE user_id='kasir';
UPDATE th_user_login SET tgl_logout = '2026-09-23', jam_logout = '18:36:44' WHERE user_id = 'Nagatech' AND tgl_login = '2026-09-23' AND jam_login= '18:35:36';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-23 ','18:36:57');
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-260923-0011','kasir','1',' DP-03627MM','TOKO','MMPSN','PSPRT-ZIBA-22-0','CINCIN PERAK ','','2.440','1','100.00','249000','0','0','17800','950000','0','0','0','950000','ELLA','00047420','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBA-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PSPRT-ZIBA-22-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-260923-0011','2026-09-23','2.440','2026-09-23','18:38:07','PLG0016266','950000','950000','0','950000','0','kasir','2026-09-23 18:38:06','FJ-260923-0011','DP-03627','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-09-23','FJ-260923-0011','2026-09-23','18:38:07','ELLA','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-260923-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-260923-0012','kasir',' 1',' DP-03628MM','TOKO','MMPSN','PSPRT-ZIAG-10-0','CINCIN PERAK ','','3.200','1','100.00','327000','0','0','17800','950000','0','0','0','950000','ELLA','00047326','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAG-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PSPRT-ZIAG-10-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-260923-0012','2026-09-23','3.200','2026-09-23','18:38:07','PLG0016267','950000','950000','0','950000','0','kasir','2026-09-23 18:38:06','FJ-260923-0011','DP-03628','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-09-23','FJ-260923-0012','2026-09-23','18:38:07','ELLA','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-260923-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-260923-0013','kasirbip','1',' DP-03605DU','TOKO','DUPSN','PSPRT-ZIAF-67-0','CINCIN PERAK ','','4.330','1','100.00','442000','0','0','17800','850000','0','0','0','850000','NAD','00047299','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAF-67-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.330',berat_jual_asli=berat_jual_asli+'4.330',stock_jual='1',berat_akhir=berat_akhir-'4.330',berat_akhir_asli=berat_akhir_asli-'4.330',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PSPRT-ZIAF-67-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-260923-0013','2026-09-23','4.330','2026-09-23','18:47:01','PLG0016268','850000','850000','0','850000','0','kasirbip','2026-09-23 18:47:01','FJ-260923-0013','DP-03605','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-09-23','FJ-260923-0013','2026-09-23','18:47:01','NAD','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-260923-0013' 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-260923-0014','kasirbip',' 1',' DP-03604DU','TOKO','DUPSN','PSPRT-ZIBA-17-0','CINCIN PERAK ','','1.450','1','100.00','148000','0','0','17800','850000','0','0','0','850000','NAD','00047415','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBA-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PSPRT-ZIBA-17-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-260923-0014','2026-09-23','1.450','2026-09-23','18:47:01','PLG0016269','850000','850000','0','850000','0','kasirbip','2026-09-23 18:47:01','FJ-260923-0013','DP-03604','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-09-23','FJ-260923-0014','2026-09-23','18:47:01','NAD','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-260923-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-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-260923-0015','kasirbip','1',' DP-03842BI','TOKO','BIPPSN','PSPRT-ZIBA-11-0','CINCIN PERAK SR05 YL01 ','','3.180','1','100.00','325000','0','0','17800','950000','0','0','0','950000','KUR','00047409','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBA-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PSPRT-ZIBA-11-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-260923-0015','2026-09-23','3.180','2026-09-23','19:28:41','PLG0016270','950000','950000','0','950000','0','kasirbip','2026-09-23 19:28:41','FJ-260923-0015','DP-03842','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-09-23','FJ-260923-0015','2026-09-23','19:28:41','KUR','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-260923-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0015';
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-260923-0016','kasirbip','1',' 900K-11-29','TOKO','BIPPER','PBDG-ZHCA-46-0','CINCIN SILVER 925 ','','2.760','1','100.00','282000','0','0','17800','1000000','0','0','0','1000000','SULIS','00046738','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHCA-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.760',berat_jual_asli=berat_jual_asli+'2.760',stock_jual='1',berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PBDG-ZHCA-46-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-260923-0016','2026-09-23','2.760','2026-09-23','19:50:58','PLG0016271','1000000','1000000','0','1000000','0','kasirbip','2026-09-23 19:50:57','FJ-260923-0016','','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-09-23','FJ-260923-0016','2026-09-23','19:50:58','SULIS','1000000','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-260923-0011','2026-09-23','2026-09-23 19:50:57','PENJUALAN : FJ-260923-0016','.','TBC','1000000','1000000','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-260923-0012','D','2026-09-23','19:50:58','TBC','PENJUALAN','FJ-260923-0016','28185254964','1000000','28186254964','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='1000000' WHERE no_faktur_jual='FJ-260923-0016' 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-260923-0017','kasirbip',' 1',' 750K-16-29','TOKO','BIPPER','PBDG-ZIXD-6-0','CINCIN SILVER 925 ','','2.080','1','100.00','213000','0','0','17800','850000','0','0','0','850000','SULIS','00046869','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXD-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PBDG-ZIXD-6-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-260923-0017','2026-09-23','2.080','2026-09-23','19:50:58','PLG0016272','850000','850000','0','850000','0','kasirbip','2026-09-23 19:50:57','FJ-260923-0016','','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-09-23','FJ-260923-0017','2026-09-23','19:50:58','SULIS','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-260923-0012','2026-09-23','2026-09-23 19:50:57','PENJUALAN : FJ-260923-0017','.','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-260923-0013','D','2026-09-23','19:50:58','TBC','PENJUALAN','FJ-260923-0017','28186254964','850000','28187104964','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='1850000' WHERE no_faktur_jual='FJ-260923-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0017';
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-04191','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwo YL-01 Sz 16.5 grf Laila','cwe Sr-04 Sz 9.5 Grf Fauzan','font berkshire swash','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260923-0013','2026-09-23','2026-09-23 19:59:49','PESANAN : DP-04191','.','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-260923-0014','D','2026-09-23','19:59:49','TBC','PESANAN','DP-04191','28187104964','950000','28188054964','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-04191','2026-09-23','2026-09-23','19:59:49','PLG0016273','SAL','2026-10-15','kasirbip','2026-09-23 19:59:49','2.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-260923-0018','kasirbip','1',' 850K-105-2','TOKO','BIPPER','PBDG-ZIXD-14-0','CINCIN SILVER 925 ','','1.590','1','100.00','163000','0','0','17800','950000','0','0','0','950000','KUR','00046877','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXD-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2026-09-23' AND kode_barang='PBDG-ZIXD-14-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-260923-0018','2026-09-23','1.590','2026-09-23','20:04:07','PLG0016274','950000','950000','0','950000','0','kasirbip','2026-09-23 20:04:06','FJ-260923-0018','','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-09-23','FJ-260923-0018','2026-09-23','20:04:07','KUR','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260923-0014','2026-09-23','2026-09-23 20:04:06','PENJUALAN : FJ-260923-0018','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260923-0015','D','2026-09-23','20:04:07','TBC','PENJUALAN','FJ-260923-0018','28188054964','950000','28189004964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260923-0018' LIMIT 1;
UPDATE tt_service_head SET tgl_selesai='2026-09-23',  status ='DONE' WHERE no_service='SV-02248';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02248';
UPDATE tt_service_head SET tgl_selesai='2026-09-23',  status ='DONE' WHERE no_service='SV-02250';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02250';
UPDATE tt_service_head SET tgl_selesai='2026-09-23',  status ='DONE' WHERE no_service='SV-02254';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02254';
UPDATE tt_service_head SET tgl_selesai='2026-09-23',  status ='DONE' WHERE no_service='SV-02251';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02251';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-09-23',  status ='CLOS' WHERE no_service='SV-02250';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02250';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260923-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260923-0018';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-23 ','20:34:20');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-23';
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-09-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-23' 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-260924-0001','D','2026-09-24','21:04:36','TBC','SALDO AWAL','SALDO AWAL','0','28189004964','28189004964');
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-260924-0001','D','2026-09-24','21:04:36','BCD','SALDO AWAL','SALDO AWAL','0','1461269500','1461269500');
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-260924-0001','D','2026-09-24','21:04:36','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-260924-0001','D','2026-09-24','21:04:36','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-260924-0001','D','2026-09-24','21:04:36','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260924-0001','D','2026-09-24','21:04:36','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-260924-0001','D','2026-09-24','21:04:36','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260924-0001','D','2026-09-24','21:04:36','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-260924-0001','D','2026-09-24','21:04:36','','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-260924-0001','D','2026-09-24','21:04:36','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-260924-0001','D','2026-09-24','21:04:36','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260924-0001','D','2026-09-24','21:04:36','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
UPDATE tp_system SET tgl_system='2026-09-24';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-23 ','21:28:17');
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-20260924-0001','1','PSBY-ZIBB-16-0','1','1.980','1.980','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIBB-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIBB-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIBB-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-24 21:29:28' WHERE kode_barang='PSBY-ZIBB-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIBB-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-09-24 21:29:28','TOKO','SBYPER','PSBY','PSBY-ZIBB-16-0','1','1.980','1.980','1','1.980','1.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZIBB-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0001','1','PSBY-ZIBB-17-0','1','3.520','3.520','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIBB-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIBB-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIBB-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-24 21:29:28' WHERE kode_barang='PSBY-ZIBB-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIBB-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-09-24 21:29:28','TOKO','SBYPER','PSBY','PSBY-ZIBB-17-0','1','3.520','3.520','1','3.520','3.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZIBB-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0001','1','PSBY-ZIBB-18-0','1','3.770','3.770','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIBB-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIBB-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIBB-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-24 21:29:28' WHERE kode_barang='PSBY-ZIBB-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIBB-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-09-24 21:29:28','TOKO','SBYPER','PSBY','PSBY-ZIBB-18-0','1','3.770','3.770','1','3.770','3.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZIBB-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0001','1','PSBY-ZIBB-19-0','1','1.420','1.420','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIBB-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIBB-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIBB-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-24 21:29:28' WHERE kode_barang='PSBY-ZIBB-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIBB-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-09-24 21:29:28','TOKO','SBYPER','PSBY','PSBY-ZIBB-19-0','1','1.420','1.420','1','1.420','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZIBB-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0001','1','PSBY-ZIBB-20-0','1','1.630','1.630','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIBB-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIBB-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIBB-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-24 21:29:28' WHERE kode_barang='PSBY-ZIBB-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIBB-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-09-24 21:29:28','TOKO','SBYPER','PSBY','PSBY-ZIBB-20-0','1','1.630','1.630','1','1.630','1.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZIBB-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIBB-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260924-0001','2026-09-24','21:28','12.320','sby','2026-09-23 21:29:28');
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-20260924-0002','1','PSPRT-ZIBB-40-0','1','5.140','5.140','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-40-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-40-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-24 21:31:21' WHERE kode_barang='PSPRT-ZIBB-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-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-09-24 21:31:21','TOKO','SBYPSN','PSPRT','PSPRT-ZIBB-40-0','1','5.140','5.140','1','5.140','5.140','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-ZIBB-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-40-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0002','1','PSPRT-ZIBB-41-0','1','2.450','2.450','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-24 21:31:21' WHERE kode_barang='PSPRT-ZIBB-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-41-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-24 21:31:21','TOKO','SBYPSN','PSPRT','PSPRT-ZIBB-41-0','1','2.450','2.450','1','2.450','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIBB-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-41-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0002','1','PSPRT-ZIBB-42-0','1','3.390','3.390','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-24 21:31:21' WHERE kode_barang='PSPRT-ZIBB-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-42-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-24 21:31:21','TOKO','SBYPSN','PSPRT','PSPRT-ZIBB-42-0','1','3.390','3.390','1','3.390','3.390','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-ZIBB-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0002','1','PSGT-ZIBB-43-0','1','1.490','1.490','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBB-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBB-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBB-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-24 21:31:21' WHERE kode_barang='PSGT-ZIBB-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBB-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-09-24 21:31:21','TOKO','SBYPSN','PSGT','PSGT-ZIBB-43-0','1','1.490','1.490','1','1.490','1.490','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-ZIBB-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBB-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' 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-20260924-0002','1','PSPRT-ZIBB-44-0','1','2.470','2.470','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBB-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBB-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBB-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-24 21:31:21' WHERE kode_barang='PSPRT-ZIBB-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBB-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-09-24 21:31:21','TOKO','SBYPSN','PSPRT','PSPRT-ZIBB-44-0','1','2.470','2.470','1','2.470','2.470','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-ZIBB-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBB-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260924-0002','2026-09-24','21:29','14.940','sby','2026-09-23 21:31:20');