INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-15 ','08:37:21');
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-20260715-0001','1','PMM-ZGAD-23-0','1','1.150','1.150','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-23-0','1','1.150','1.150','1','1.150','1.150','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-ZGAD-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-24-0','1','2.130','2.130','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-24-0','1','2.130','2.130','1','2.130','2.130','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-ZGAD-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-25-0','1','2.150','2.150','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-25-0','1','2.150','2.150','1','2.150','2.150','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-ZGAD-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-26-0','1','1.540','1.540','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-26-0','1','1.540','1.540','1','1.540','1.540','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-ZGAD-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-26-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-27-0','1','2.170','2.170','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-27-0','1','2.170','2.170','1','2.170','2.170','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-ZGAD-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-28-0','1','1.760','1.760','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-28-0','1','1.760','1.760','1','1.760','1.760','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-ZGAD-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-29-0','1','2.750','2.750','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-29-0','1','2.750','2.750','1','2.750','2.750','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-ZGAD-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-30-0','1','2.080','2.080','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-30-0','1','2.080','2.080','1','2.080','2.080','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-ZGAD-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-31-0','1','2.550','2.550','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-31-0','1','2.550','2.550','1','2.550','2.550','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-ZGAD-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-32-0','1','2.710','2.710','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-32-0','1','2.710','2.710','1','2.710','2.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-ZGAD-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-33-0','1','2.840','2.840','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-33-0','1','2.840','2.840','1','2.840','2.840','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-ZGAD-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-34-0','1','2.920','2.920','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:35' WHERE kode_barang='PMM-ZGAD-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:35','TOKO','MMPER','PMM','PMM-ZGAD-34-0','1','2.920','2.920','1','2.920','2.920','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-ZGAD-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-35-0','1','2.990','2.990','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:36' WHERE kode_barang='PMM-ZGAD-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:36','TOKO','MMPER','PMM','PMM-ZGAD-35-0','1','2.990','2.990','1','2.990','2.990','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-ZGAD-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-36-0','1','1.350','1.350','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:36' WHERE kode_barang='PMM-ZGAD-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:36','TOKO','MMPER','PMM','PMM-ZGAD-36-0','1','1.350','1.350','1','1.350','1.350','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-ZGAD-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0001','1','PMM-ZGAD-37-0','1','1.400','1.400','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZGAD-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZGAD-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZGAD-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-07-15 08:37:36' WHERE kode_barang='PMM-ZGAD-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZGAD-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-07-15 08:37:36','TOKO','MMPER','PMM','PMM-ZGAD-37-0','1','1.400','1.400','1','1.400','1.400','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-ZGAD-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZGAD-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260715-0001','2026-07-15','08:37','32.490','kasir','2026-07-15 08:37:35');
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-20260715-0002','1','PSPRT-ZGAD-17-0','1','3.360','3.360','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-15 08:38:03' WHERE kode_barang='PSPRT-ZGAD-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 08:38:03','TOKO','MMPSN','PSPRT','PSPRT-ZGAD-17-0','1','3.360','3.360','1','3.360','3.360','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-ZGAD-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0002','1','PSPRT-ZGAD-18-0','1','3.730','3.730','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-15 08:38:03' WHERE kode_barang='PSPRT-ZGAD-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 08:38:03','TOKO','MMPSN','PSPRT','PSPRT-ZGAD-18-0','1','3.730','3.730','1','3.730','3.730','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-ZGAD-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0002','1','PSPRT-ZGAD-19-0','1','4.780','4.780','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-15 08:38:03' WHERE kode_barang='PSPRT-ZGAD-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 08:38:03','TOKO','MMPSN','PSPRT','PSPRT-ZGAD-19-0','1','4.780','4.780','1','4.780','4.780','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-ZGAD-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260715-0002','2026-07-15','08:37','11.870','kasir','2026-07-15 08:38:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-15 ','08:42:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-15 ','08:44:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-15 ','10:28:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-15 ','11:22:41');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260715-0001','sby','1',' 750K-17-00','TOKO','SBYPER','PSBY-ZFBB-5-0','CINCIN SILVER 925 ','','3.280','1','100.00','335000','0','0','17800','850000','0','0','0','850000','DIL','00044619','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZFBB-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSBY-ZFBB-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260715-0001','2026-07-15','3.280','2026-07-15','11:24:50','PLG0013184','850000','850000','0','850000','0','sby','2026-07-15 11:24:50','FJ-260715-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-07-15','FJ-260715-0001','2026-07-15','11:24:50','DIL','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-260715-0001','2026-07-15','2026-07-15 11:24:50','PENJUALAN : FJ-260715-0001','','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-260715-0002','D','2026-07-15','11:24:50','TBC','PENJUALAN','FJ-260715-0001','24876944564','850000','24877794564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260715-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-260715-0002','sby',' 1',' 900K-135-0','TOKO','SBYPER','PSBY-ZFBB-16-0','CINCIN SILVER 925 ','','1.720','1','100.00','176000','0','0','17800','1000000','0','0','0','1000000','DIL','00044630','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZFBB-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSBY-ZFBB-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260715-0002','2026-07-15','1.720','2026-07-15','11:24:50','PLG0013185','1000000','1000000','0','1000000','0','sby','2026-07-15 11:24:50','FJ-260715-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-07-15','FJ-260715-0002','2026-07-15','11:24:50','DIL','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-260715-0002','2026-07-15','2026-07-15 11:24:50','PENJUALAN : FJ-260715-0002','','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-260715-0003','D','2026-07-15','11:24:50','TBC','PENJUALAN','FJ-260715-0002','24877794564','1000000','24878794564','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-260715-0002' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-15 ','11:41:10');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260715-0002','K','2026-07-15','11:51:59','kasir','KAS BESAR','DIBAWA KE KANTOR','38993200','22000000','16993200');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-15 ','13:14:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260715-0003','1','PSPRT-ZGAD-1-0','1','3.530','3.530','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-15 13:16:11' WHERE kode_barang='PSPRT-ZGAD-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 13:16:11','TOKO','DUPSN','PSPRT','PSPRT-ZGAD-1-0','1','3.530','3.530','1','3.530','3.530','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-ZGAD-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0003','1','PSPRT-ZGAD-2-0','1','3.460','3.460','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-15 13:16:11' WHERE kode_barang='PSPRT-ZGAD-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 13:16:11','TOKO','DUPSN','PSPRT','PSPRT-ZGAD-2-0','1','3.460','3.460','1','3.460','3.460','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-ZGAD-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0003','1','PSPRT-ZGAD-3-0','1','2.270','2.270','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-15 13:16:11' WHERE kode_barang='PSPRT-ZGAD-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 13:16:11','TOKO','DUPSN','PSPRT','PSPRT-ZGAD-3-0','1','2.270','2.270','1','2.270','2.270','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-ZGAD-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0003','1','PSPRT-ZGAD-4-0','1','1.430','1.430','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-15 13:16:11' WHERE kode_barang='PSPRT-ZGAD-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 13:16:11','TOKO','DUPSN','PSPRT','PSPRT-ZGAD-4-0','1','1.430','1.430','1','1.430','1.430','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-ZGAD-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0003','1','PSPRT-ZGAD-5-0','1','4.460','4.460','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-15 13:16:11' WHERE kode_barang='PSPRT-ZGAD-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 13:16:11','TOKO','DUPSN','PSPRT','PSPRT-ZGAD-5-0','1','4.460','4.460','1','4.460','4.460','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-ZGAD-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260715-0003','2026-07-15','13:14','15.150','kasirbip','2026-07-15 13:16:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-15 ','13:43:00');
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-260715-0003','kasirbip','1',' DP-02435DU','TOKO','DUPSN','PSPLT-ZFBI-47-0','CINCIN PALADIUM ','','2.580','1','32.00','1091000','0','0','17800','2739000','0','0','0','2739000','PUT','00044838','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBI-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.580',berat_jual_asli=berat_jual_asli+'2.580',stock_jual='1',berat_akhir=berat_akhir-'2.580',berat_akhir_asli=berat_akhir_asli-'2.580',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPLT-ZFBI-47-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-260715-0003','2026-07-15','2.580','2026-07-15','13:48:05','PLG0013186','2739000','2739000','0','2739000','0','kasirbip','2026-07-15 13:48:04','FJ-260715-0003','DP-02435','2050000');
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-07-15','FJ-260715-0003','2026-07-15','13:48:05','PUT','2739000','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-260715-0003','2026-07-15','2026-07-15 13:48:04','PENJUALAN : FJ-260715-0003','.','TBC','689000','689000','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-260715-0004','D','2026-07-15','13:48:05','TBC','PENJUALAN','FJ-260715-0003','24878794564','689000','24879483564','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='689000' WHERE no_faktur_jual='FJ-260715-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-260715-0004','kasirbip',' 1',' DP-02436DU','TOKO','DUPSN','PSPLT-ZFBI-48-0','CINCIN PALADIUM ','','3.110','1','32.00','1314000','0','0','17800','2460500','0','0','0','2460500','PUT','00044839','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBI-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPLT-ZFBI-48-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-260715-0004','2026-07-15','3.110','2026-07-15','13:48:05','PLG0013187','2460500','2460500','0','2460500','0','kasirbip','2026-07-15 13:48:04','FJ-260715-0003','DP-02436','2050000');
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-07-15','FJ-260715-0004','2026-07-15','13:48:05','PUT','2460500','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-260715-0004','2026-07-15','2026-07-15 13:48:04','PENJUALAN : FJ-260715-0004','.','TBC','410500','410500','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-260715-0005','D','2026-07-15','13:48:05','TBC','PENJUALAN','FJ-260715-0004','24879483564','410500','24879894064','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='1099500' WHERE no_faktur_jual='FJ-260715-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-15 ','14:03:42');
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-260715-0005','kasirbip','1',' DP-02756BI','TOKO','BIPPSN','PSPRT-ZGAX-22-0','CINCIN PERAK ','','3.230','1','100.00','330000','0','0','17800','900000','0','0','0','900000','SULIS','00045102','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAX-22-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-260715-0005','2026-07-15','3.230','2026-07-15','14:06:59','PLG0013188','900000','900000','0','900000','0','kasirbip','2026-07-15 14:06:58','FJ-260715-0005','DP-02756','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-07-15','FJ-260715-0005','2026-07-15','14:06:59','SULIS','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260715-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-260715-0006','kasirbip',' 1',' DP-02755BI','TOKO','BIPPSN','PSPRT-ZGAX-26-0','CINCIN PERAK ','','1.700','1','100.00','174000','0','0','17800','1100000','0','0','0','1100000','SULIS','00045106','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAX-26-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-260715-0006','2026-07-15','1.700','2026-07-15','14:06:59','PLG0013189','1100000','1100000','0','1100000','0','kasirbip','2026-07-15 14:06:58','FJ-260715-0005','DP-02755','1100000');
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-07-15','FJ-260715-0006','2026-07-15','14:06:59','SULIS','1100000','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-260715-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0006';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260715-0003','K','2026-07-15','14:09:48','kasir','BELANJA','BELI TISU TOKO','16993200','29900','16963300');
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-260715-0007','kasirbip','1',' DP-02570BI','TOKO','BIPPSN','PSPRT-ZGAX-7-0','CINCIN PERAK SR-01 ','','0.980','1','100.00','100000','0','0','17800','850000','0','0','0','850000','SULIS','00045087','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAX-7-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-260715-0007','2026-07-15','0.980','2026-07-15','14:15:14','PLG0013190','850000','850000','0','850000','0','kasirbip','2026-07-15 14:15:14','FJ-260715-0007','DP-02570','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-07-15','FJ-260715-0007','2026-07-15','14:15:14','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260715-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260715-0008','kasirbip',' 1',' DP-02569BI','TOKO','BIPPSN','PSPRT-ZGAX-3-0','CINCIN PERAK ','','2.490','1','100.00','255000','0','0','17800','850000','0','0','0','850000','SULIS','00045083','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAX-3-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-260715-0008','2026-07-15','2.490','2026-07-15','14:15:14','PLG0013191','850000','850000','0','850000','0','kasirbip','2026-07-15 14:15:14','FJ-260715-0007','DP-02569','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-07-15','FJ-260715-0008','2026-07-15','14:15:14','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260715-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0008';
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-02948','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 10 putih doff semprot 1 zirkon','font brush script grf Sirrul S & S','model sprt contoh','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260715-0005','2026-07-15','2026-07-15 14:21:26','PESANAN : DP-02948','.','TBC','1440000','1440000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260715-0006','D','2026-07-15','14:21:26','TBC','PESANAN','DP-02948','24879894064','1440000','24881334064','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-02948','2026-07-15','2026-07-15','14:21:26','PLG0013192','KUR','2026-08-15','kasirbip','2026-07-15 14:21:26','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-02949','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 13 putih doff semprot 1 zirkon','font brush script grf Sulastri S & S','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260715-0006','2026-07-15','2026-07-15 14:23:03','PESANAN : DP-02949','.','TBC','1440000','1440000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260715-0007','D','2026-07-15','14:23:03','TBC','PESANAN','DP-02949','24881334064','1440000','24882774064','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-02949','2026-07-15','2026-07-15','14:23:03','PLG0013193','KUR','2026-08-15','kasirbip','2026-07-15 14:23:03','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-20260715-0004','1','PSPRT-ZGAD-15-0','1','4.880','4.880','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPRT-ZGAD-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPRT','PSPRT-ZGAD-15-0','1','4.880','4.880','1','4.880','4.880','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-ZGAD-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPRT-ZGAD-16-0','1','1.840','1.840','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPRT-ZGAD-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPRT','PSPRT-ZGAD-16-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-ZGAD-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPLT-ZGAD-20-0','1','2.920','2.920','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPLT-ZGAD-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPLT','PSPLT-ZGAD-20-0','1','2.920','2.920','1','2.920','2.920','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-ZGAD-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPRT-ZGAD-21-0','1','3.380','3.380','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPRT-ZGAD-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-15 14:45:47','TOKO','BIPPSN','PSPRT','PSPRT-ZGAD-21-0','1','3.380','3.380','1','3.380','3.380','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-ZGAD-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPRT-ZGAD-38-0','1','2.460','2.460','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPRT-ZGAD-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPRT','PSPRT-ZGAD-38-0','1','2.460','2.460','1','2.460','2.460','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-ZGAD-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPLT-ZGAD-39-0','1','2.460','2.460','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPLT-ZGAD-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPLT','PSPLT-ZGAD-39-0','1','2.460','2.460','1','2.460','2.460','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-ZGAD-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPLT-ZGAD-40-0','1','1.810','1.810','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-40-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-40-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPLT-ZGAD-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPLT','PSPLT-ZGAD-40-0','1','1.810','1.810','1','1.810','1.810','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGAD-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-40-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPLT-ZGAD-41-0','1','2.350','2.350','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPLT-ZGAD-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPLT','PSPLT-ZGAD-41-0','1','2.350','2.350','1','2.350','2.350','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGAD-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-41-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPLT-ZGAD-42-0','1','2.040','2.040','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPLT-ZGAD-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPLT','PSPLT-ZGAD-42-0','1','2.040','2.040','1','2.040','2.040','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-ZGAD-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSPLT-ZGAD-43-0','1','2.060','2.060','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSPLT-ZGAD-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSPLT','PSPLT-ZGAD-43-0','1','2.060','2.060','1','2.060','2.060','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-ZGAD-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSGT-ZGAD-44-0','1','1.590','1.590','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGAD-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGAD-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGAD-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSGT-ZGAD-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGAD-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-07-15 14:45:47','TOKO','BIPPSN','PSGT','PSGT-ZGAD-44-0','1','1.590','1.590','1','1.590','1.590','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-ZGAD-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSGT-ZGAD-45-0','1','2.270','2.270','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGAD-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGAD-45-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGAD-45-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSGT-ZGAD-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGAD-45-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-15 14:45:47','TOKO','BIPPSN','PSGT','PSGT-ZGAD-45-0','1','2.270','2.270','1','2.270','2.270','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-ZGAD-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-45-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSGT-ZGAD-46-0','1','1.660','1.660','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGAD-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-46-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGAD-46-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGAD-46-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSGT-ZGAD-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGAD-46-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-07-15 14:45:47','TOKO','BIPPSN','PSGT','PSGT-ZGAD-46-0','1','1.660','1.660','1','1.660','1.660','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-ZGAD-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-46-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0004','1','PSGT-ZGAD-47-0','1','1.170','1.170','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGAD-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGAD-47-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGAD-47-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-15 14:45:47' WHERE kode_barang='PSGT-ZGAD-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGAD-47-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-07-15 14:45:47','TOKO','BIPPSN','PSGT','PSGT-ZGAD-47-0','1','1.170','1.170','1','1.170','1.170','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-ZGAD-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGAD-47-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260715-0004','2026-07-15','14:45','32.890','kasirbip','2026-07-15 14:45:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-15 ','15:08:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-15 ','15:08:31');
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-02950','DIL','1','PER','CINCIN SEPAKET 950K','','','3.000','','925.00','1','100000','0','950000','0','950000','WANITA: SIZE 10.5 GRF: Ricki Kurnia ?? (berkshire)','PRIA: SIZE 18.5 GRF: Desi Lia ?? (BERKSHIRE)','CROM SESUAI FOTO','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-260715-0007','2026-07-15','2026-07-15 15:12:39','PESANAN : DP-02950','-','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-260715-0008','D','2026-07-15','15:12:39','TBC','PESANAN','DP-02950','24882774064','950000','24883724064','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-02950','2026-07-15','2026-07-15','15:12:39','PLG0013194','DIL','2026-08-12','sby','2026-07-15 15:12:39','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260715-0009','kasirbip','1',' DP-02752BI','TOKO','BIPPSN','PSPRT-ZGAD-15-0','1PS CINCIN PERAK ','','4.880','1','100.00','498000','0','0','17800','1600000','0','0','0','1600000','SULIS','00045152','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.880',berat_jual_asli=berat_jual_asli+'4.880',stock_jual='1',berat_akhir=berat_akhir-'4.880',berat_akhir_asli=berat_akhir_asli-'4.880',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAD-15-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-260715-0009','2026-07-15','4.880','2026-07-15','15:12:48','PLG0013195','1600000','1600000','0','1600000','0','kasirbip','2026-07-15 15:12:47','FJ-260715-0009','DP-02752','1600000');
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-07-15','FJ-260715-0009','2026-07-15','15:12:48','SULIS','1600000','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-260715-0009' 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-260715-0010','kasirbip','1',' DP-02594BI','TOKO','BIPPSN','PSGT-ZGXA-22-0','CINCIN EMAS ','','3.100','1','83.00','5984000','0','0','17800','8240000','0','0','0','8240000','SULIS','00044882','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGXA-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSGT-ZGXA-22-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-260715-0010','2026-07-15','3.100','2026-07-15','15:30:43','PLG0013196','8240000','8240000','0','8240000','0','kasirbip','2026-07-15 15:30:42','FJ-260715-0010','DP-02594','6400000');
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-07-15','FJ-260715-0010','2026-07-15','15:30:43','SULIS','8240000','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-260715-0008','2026-07-15','2026-07-15 15:30:42','PENJUALAN : FJ-260715-0010','.','TBC','1840000','1840000','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-260715-0009','D','2026-07-15','15:30:43','TBC','PENJUALAN','FJ-260715-0010','24883724064','1840000','24885564064','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='1840000' WHERE no_faktur_jual='FJ-260715-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0010';
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-260715-0011','kasirbip','1',' DP-02688BI','TOKO','BIPPSN','PSPRT-ZGAD-21-0','CINCIN PERAK SR-02 YL-01 ','','3.380','1','100.00','345000','0','0','17800','950000','0','0','0','950000','KUR','00045158','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAD-21-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-260715-0011','2026-07-15','3.380','2026-07-15','16:42:02','PLG0013197','950000','950000','0','950000','0','kasirbip','2026-07-15 16:42:02','FJ-260715-0011','DP-02688','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-07-15','FJ-260715-0011','2026-07-15','16:42:02','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-260715-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0011';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-15 ','18:22:51');
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-20260715-0005','1','PSPRT-ZGAD-6-0','1','3.940','3.940','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-6-0','1','3.940','3.940','1','3.940','3.940','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-ZGAD-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-7-0','1','2.140','2.140','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-7-0','1','2.140','2.140','1','2.140','2.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-ZGAD-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-8-0','1','1.380','1.380','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-8-0','1','1.380','1.380','1','1.380','1.380','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-ZGAD-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPLT-ZGAD-9-0','1','1.650','1.650','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPLT-ZGAD-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPLT','PSPLT-ZGAD-9-0','1','1.650','1.650','1','1.650','1.650','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGAD-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-10-0','1','2.190','2.190','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-10-0','1','2.190','2.190','1','2.190','2.190','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-ZGAD-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-11-0','1','3.920','3.920','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-11-0','1','3.920','3.920','1','3.920','3.920','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-ZGAD-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-12-0','1','2.270','2.270','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-12-0','1','2.270','2.270','1','2.270','2.270','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-ZGAD-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPLT-ZGAD-13-0','1','2.720','2.720','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPLT-ZGAD-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPLT','PSPLT-ZGAD-13-0','1','2.720','2.720','1','2.720','2.720','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-ZGAD-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-14-0','1','2.200','2.200','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-14-0','1','2.200','2.200','1','2.200','2.200','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-ZGAD-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-22-0','1','3.510','3.510','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-22-0','1','3.510','3.510','1','3.510','3.510','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-ZGAD-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-48-0','1','3.180','3.180','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-48-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-48-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-48-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-48-0','1','3.180','3.180','1','3.180','3.180','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-ZGAD-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-48-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-49-0','1','6.460','6.460','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-49-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-49-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-49-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-49-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-49-0','1','6.460','6.460','1','6.460','6.460','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-ZGAD-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-49-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPRT-ZGAD-50-0','1','3.380','3.380','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAD-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-50-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAD-50-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAD-50-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPRT-ZGAD-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAD-50-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-07-15 18:24:23','TOKO','SBYPSN','PSPRT','PSPRT-ZGAD-50-0','1','3.380','3.380','1','3.380','3.380','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-ZGAD-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAD-50-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' 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-20260715-0005','1','PSPLT-ZGAD-51-0','1','2.500','2.500','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAD-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-51-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAD-51-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAD-51-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-15 18:24:23' WHERE kode_barang='PSPLT-ZGAD-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAD-51-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-07-15 18:24:23','TOKO','SBYPSN','PSPLT','PSPLT-ZGAD-51-0','1','2.500','2.500','1','2.500','2.500','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-ZGAD-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAD-51-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-15' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260715-0005','2026-07-15','18:23','41.440','sby','2026-07-15 18:24:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-15 ','18:38:16');
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-260715-0012','sby','1',' DP-02546SB','TOKO','SBYPSN','PSPRT-ZGAX-13-0','CINCIN PERAK ','','4.530','1','100.00','463000','0','0','17800','850000','0','0','0','850000','DIL','00045093','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.530',berat_jual_asli=berat_jual_asli+'4.530',stock_jual='1',berat_akhir=berat_akhir-'4.530',berat_akhir_asli=berat_akhir_asli-'4.530',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAX-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260715-0012','2026-07-15','4.530','2026-07-15','18:40:53','PLG0013198','850000','850000','0','850000','0','sby','2026-07-15 18:40:53','FJ-260715-0012','DP-02546','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-07-15','FJ-260715-0012','2026-07-15','18:40:53','DIL','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-260715-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-260715-0013','sby',' 1',' DP-02451SB','TOKO','SBYPSN','PSPLT-ZGXA-26-0','CINCIN PALADIUM ','','1.730','1','32.00','731000','0','0','17800','1712000','0','0','0','1712000','DIL','00044886','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXA-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPLT-ZGXA-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260715-0013','2026-07-15','1.730','2026-07-15','18:40:53','PLG0013199','1712000','1712000','0','1712000','0','sby','2026-07-15 18:40:53','FJ-260715-0012','DP-02451','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-15','FJ-260715-0013','2026-07-15','18:40:53','DIL','1712000','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-260715-0009','2026-07-15','2026-07-15 18:40:53','PENJUALAN : FJ-260715-0013','','TBC','312000','312000','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-260715-0010','D','2026-07-15','18:40:53','TBC','PENJUALAN','FJ-260715-0013','24885564064','312000','24885876064','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='312000' WHERE no_faktur_jual='FJ-260715-0013' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02171','SULIS','1','CINCIN SILVER','REVISI LEBAR 3 5MM SIZE 25 PUTIH GLOSSY','2.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02171','2026-07-15','2026-07-15','18:48:37','PLG0013200','kasirbip','2026-07-30','kasirbip','2026-07-15 18:48:37','2.000','0','0','0','0','0','0','0','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-260715-0014','kasirbip','1',' DP-02800BI','TOKO','BIPPSN','PSPRT-ZGAC-1-0','CINCIN PERAK SR-03 YL-01 ','','3.410','1','100.00','348000','0','0','17800','950000','0','0','0','950000','SAL','00045111','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAC-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.410',berat_jual_asli=berat_jual_asli+'3.410',stock_jual='1',berat_akhir=berat_akhir-'3.410',berat_akhir_asli=berat_akhir_asli-'3.410',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAC-1-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-260715-0014','2026-07-15','3.410','2026-07-15','19:34:48','PLG0013201','950000','950000','0','950000','0','kasirbip','2026-07-15 19:34:48','FJ-260715-0014','DP-02800','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-07-15','FJ-260715-0014','2026-07-15','19:34:48','SAL','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-260715-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0014';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-15 ','19:39:51');
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-260715-0015','kasir','1',' DP-02749MM','TOKO','MMPSN','PSPRT-ZGAD-17-0','CINCIN PERAK YL-01 ','','3.360','1','100.00','343000','0','0','17800','850000','0','0','0','850000','ELLA','00045154','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.360',berat_jual_asli=berat_jual_asli+'3.360',stock_jual='1',berat_akhir=berat_akhir-'3.360',berat_akhir_asli=berat_akhir_asli-'3.360',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAD-17-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-260715-0015','2026-07-15','3.360','2026-07-15','19:41:07','PLG0013202','850000','850000','0','850000','0','kasir','2026-07-15 19:41:06','FJ-260715-0015','DP-02749','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-07-15','FJ-260715-0015','2026-07-15','19:41:07','ELLA','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260715-0015' LIMIT 1;
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-07-15',  status ='CLOS' WHERE no_service='SV-02158';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02158';
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-260715-0016','kasirbip','1',' DP-02799BI','TOKO','BIPPSN','PSGT-ZGAD-47-0','CINCIN EMAS ','','1.170','1','57.00','1552000','0','0','17800','3086000','0','0','0','3086000','SULIS','00045184','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGAD-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSGT-ZGAD-47-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-260715-0016','2026-07-15','1.170','2026-07-15','19:56:20','PLG0013203','3086000','3086000','0','3086000','0','kasirbip','2026-07-15 19:56:20','FJ-260715-0016','DP-02799','2944000');
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-07-15','FJ-260715-0016','2026-07-15','19:56:20','SULIS','3086000','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-260715-0010','2026-07-15','2026-07-15 19:56:20','PENJUALAN : FJ-260715-0016','.','TBC','142000','142000','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-260715-0011','D','2026-07-15','19:56:20','TBC','PENJUALAN','FJ-260715-0016','24885876064','142000','24886018064','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='142000' WHERE no_faktur_jual='FJ-260715-0016' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02951','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','800000','1675000','zircon 9 sz 14.5 putih gllosy','lebar di bkin 2mm rata daun ny tipis zircon tengah sedang','grf Divo .. Annisa font Berkshire','90000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260715-0011','2026-07-15','2026-07-15 19:56:41','PESANAN : DP-02951','.','TBC','1412000','1412000');
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-260715-0012','D','2026-07-15','19:56:41','TBC','PESANAN','DP-02951','24886018064','1412000','24887430064','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-02951','2026-07-15','2026-07-15','19:56:41','PLG0013204','PUT','2026-08-10','kasirbip','2026-07-15 19:56:41','2.500','0','0','0','1412000','0','800000','1765000','1765000','353000');
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-02952','PUT','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','800000','2025000','sz 23.5 crom putih doff semprot','grf Annisa .. Divo font Berkshire','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260715-0012','2026-07-15','2026-07-15 20:00:18','PESANAN : DP-02952','.','TBC','1620000','1620000');
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-260715-0013','D','2026-07-15','20:00:18','TBC','PESANAN','DP-02952','24887430064','1620000','24889050064','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-02952','2026-07-15','2026-07-15','20:00:18','PLG0013205','PUT','2026-08-10','kasirbip','2026-07-15 20:00:18','3.500','0','0','0','1620000','0','800000','2025000','2025000','405000');
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-02953','DIL','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE 17 GRF: Ihza ?? Winda (vintage)','CROM PUTIH GLOSSY','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260715-0013','2026-07-15','2026-07-15 20:00:57','PESANAN : DP-02953','-','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-260715-0014','D','2026-07-15','20:00:57','TBC','PESANAN','DP-02953','24889050064','850000','24889900064','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-02953','2026-07-15','2026-07-15','20:00:57','PLG0013206','DIL','2026-08-08','sby','2026-07-15 20:00:57','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0016';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-15 ','20:14:16');
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-260715-0017','sby','1',' DP-02590SB','TOKO','SBYPSN','PSPRT-ZGAD-22-0','CINCIN PERAK ','','3.510','1','100.00','359000','0','0','17800','950000','0','0','0','950000','DIL','00045159','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPRT-ZGAD-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260715-0017','2026-07-15','3.510','2026-07-15','20:15:25','PLG0013207','950000','950000','0','950000','0','sby','2026-07-15 20:15:24','FJ-260715-0017','DP-02590','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-07-15','FJ-260715-0017','2026-07-15','20:15:25','DIL','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-260715-0017' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02954','KUR','1','GOLD','CINCIN KAWIN','','','3.000','','75.00','1','2280000','2250000','0','950000','7700000','size15 grf Ichal','putih kilat sirkon 13','font vladimir','0','130000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260715-0014','2026-07-15','2026-07-15 20:38:21','PESANAN : DP-02954','.','TBC','3900000','3900000');
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-260715-0015','D','2026-07-15','20:38:21','TBC','PESANAN','DP-02954','24889900064','3900000','24893800064','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-02954','2026-07-15','2026-07-15','20:38:21','PLG0013208','KUR','2026-08-15','kasirbip','2026-07-15 20:38:21','3.000','0','0','0','3900000','0','950000','7830000','7830000','3930000');
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-260715-0018','kasirbip','1',' DP-02698BI','TOKO','BIPPSN','PSPLT-ZGAC-8-0','CINCIN PALADIUM ','','2.200','1','17.00','494000','0','0','17800','1520000','0','0','0','1520000','SULIS','00045118','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAC-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPLT-ZGAC-8-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-260715-0018','2026-07-15','2.200','2026-07-15','20:40:19','PLG0013209','1520000','1520000','0','1520000','0','kasirbip','2026-07-15 20:40:18','FJ-260715-0018','DP-02698','1440000');
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-07-15','FJ-260715-0018','2026-07-15','20:40:19','SULIS','1520000','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-260715-0015','2026-07-15','2026-07-15 20:40:18','PENJUALAN : FJ-260715-0018','.','TBC','80000','80000','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-260715-0016','D','2026-07-15','20:40:19','TBC','PENJUALAN','FJ-260715-0018','24893800064','80000','24893880064','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='80000' WHERE no_faktur_jual='FJ-260715-0018' 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-260715-0019','kasirbip',' 1',' DP-02699BI','TOKO','BIPPSN','PSPLT-ZGAC-7-0','CINCIN PALADIUM ','','3.470','1','17.00','779000','0','0','17800','1964500','0','0','0','1964500','SULIS','00045117','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAC-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2026-07-15' AND kode_barang='PSPLT-ZGAC-7-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-260715-0019','2026-07-15','3.470','2026-07-15','20:40:19','PLG0013210','1964500','1964500','0','1964500','0','kasirbip','2026-07-15 20:40:18','FJ-260715-0018','DP-02699','1720000');
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-07-15','FJ-260715-0019','2026-07-15','20:40:19','SULIS','1964500','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-260715-0016','2026-07-15','2026-07-15 20:40:18','PENJUALAN : FJ-260715-0019','.','TBC','244500','244500','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-260715-0017','D','2026-07-15','20:40:19','TBC','PENJUALAN','FJ-260715-0019','24893880064','244500','24894124564','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='324500' WHERE no_faktur_jual='FJ-260715-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260715-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260715-0019';
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-02955','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','sz 25 putih glossy','dibuat polos tanpa permata','font vladimir grf Diana','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-260715-0017','2026-07-15','2026-07-15 20:46:12','PESANAN : DP-02955','.','TBC','1000000','1000000');
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-260715-0018','D','2026-07-15','20:46:12','TBC','PESANAN','DP-02955','24894124564','1000000','24895124564','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-02955','2026-07-15','2026-07-15','20:46:12','PLG0013211','KUR','2026-08-15','kasirbip','2026-07-15 20:46:12','3.000','0','0','0','1000000','0','0','1000000','1000000','0');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-07-15',  status ='CLOS' WHERE no_service='SV-02143';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02143';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-15';
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-07-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-15' 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-260716-0001','D','2026-07-16','21:12:53','TBC','SALDO AWAL','SALDO AWAL','0','24895124564','24895124564');
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-260716-0001','D','2026-07-16','21:12:53','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
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-260716-0001','D','2026-07-16','21:12:53','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-260716-0001','D','2026-07-16','21:12:53','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260716-0001','D','2026-07-16','21:12:53','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-260716-0001','D','2026-07-16','21:12:53','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-260716-0001','D','2026-07-16','21:12:53','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-260716-0001','D','2026-07-16','21:12:53','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-260716-0001','D','2026-07-16','21:12:53','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-260716-0001','D','2026-07-16','21:12:53','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-260716-0001','D','2026-07-16','21:12:53','','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-260716-0001','D','2026-07-16','21:12:53','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
UPDATE tp_system SET tgl_system='2026-07-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-15 ','21:13:21');