INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','09:52:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-02 ','09:53:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','09:58:31');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-01';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-01' 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-260602-0001','D','2026-06-02','10:03:42','TBC','SALDO AWAL','SALDO AWAL','0','23183233014','23183233014');
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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','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-260602-0001','D','2026-06-02','10:03:42','','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-260602-0001','D','2026-06-02','10:03:42','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260602-0001','D','2026-06-02','10:03:42','BCD','SALDO AWAL','SALDO AWAL','0','1392303500','1392303500');
UPDATE tp_system SET tgl_system='2026-06-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','10:10:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','10:19:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','10:23:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-02 ','10:45:31');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260602-0001','1','PMM-ZFXA-1-0','1','1.190','1.190','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-1-0','1','1.190','1.190','1','1.190','1.190','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-ZFXA-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-2-0','1','1.230','1.230','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-2-0','1','1.230','1.230','1','1.230','1.230','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-ZFXA-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-3-0','1','1.730','1.730','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-3-0','1','1.730','1.730','1','1.730','1.730','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-ZFXA-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-4-0','1','2.700','2.700','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-4-0','1','2.700','2.700','1','2.700','2.700','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-ZFXA-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-5-0','1','1.510','1.510','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-5-0','1','1.510','1.510','1','1.510','1.510','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-ZFXA-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-6-0','1','1.380','1.380','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-6-0','1','1.380','1.380','1','1.380','1.380','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-ZFXA-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-7-0','1','1.210','1.210','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-7-0','1','1.210','1.210','1','1.210','1.210','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-ZFXA-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-8-0','1','2.080','2.080','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-8-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-ZFXA-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-9-0','1','1.230','1.230','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-9-0','1','1.230','1.230','1','1.230','1.230','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-ZFXA-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-10-0','1','1.230','1.230','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-10-0','1','1.230','1.230','1','1.230','1.230','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-ZFXA-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-11-0','1','1.650','1.650','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-11-0','1','1.650','1.650','1','1.650','1.650','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-ZFXA-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-12-0','1','2.230','2.230','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-12-0','1','2.230','2.230','1','2.230','2.230','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-ZFXA-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-13-0','1','1.660','1.660','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-13-0','1','1.660','1.660','1','1.660','1.660','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-ZFXA-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-14-0','1','2.360','2.360','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-14-0','1','2.360','2.360','1','2.360','2.360','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-ZFXA-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-15-0','1','2.400','2.400','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-15-0','1','2.400','2.400','1','2.400','2.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-ZFXA-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-16-0','1','1.330','1.330','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-16-0','1','1.330','1.330','1','1.330','1.330','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-ZFXA-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-17-0','1','1.420','1.420','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-17-0','1','1.420','1.420','1','1.420','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZFXA-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-18-0','1','2.370','2.370','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-18-0','1','2.370','2.370','1','2.370','2.370','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-ZFXA-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-19-0','1','1.690','1.690','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-19-0','1','1.690','1.690','1','1.690','1.690','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-ZFXA-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0001','1','PMM-ZFXA-20-0','1','1.680','1.680','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZFXA-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZFXA-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZFXA-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-06-02 10:51:29' WHERE kode_barang='PMM-ZFXA-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZFXA-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-06-02 10:51:29','TOKO','MMPER','PMM','PMM-ZFXA-20-0','1','1.680','1.680','1','1.680','1.680','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-ZFXA-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFXA-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0001','2026-06-02','10:51','34.280','kasir','2026-06-02 10:51:29');
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-20260602-0002','1','PSGT-ZFXA-32-0','1','1.810','1.810','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZFXA-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZFXA-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZFXA-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-02 10:52:52' WHERE kode_barang='PSGT-ZFXA-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZFXA-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-06-02 10:52:52','TOKO','MMPSN','PSGT','PSGT-ZFXA-32-0','1','1.810','1.810','1','1.810','1.810','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-ZFXA-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0002','1','PSPLT-ZFXA-33-0','1','3.620','3.620','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-02 10:52:52' WHERE kode_barang='PSPLT-ZFXA-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-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-06-02 10:52:52','TOKO','MMPSN','PSPLT','PSPLT-ZFXA-33-0','1','3.620','3.620','1','3.620','3.620','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0002','1','PSPLT-ZFXA-34-0','1','4.150','4.150','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXA-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXA-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXA-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-02 10:52:52' WHERE kode_barang='PSPLT-ZFXA-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXA-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-06-02 10:52:52','TOKO','MMPSN','PSPLT','PSPLT-ZFXA-34-0','1','4.150','4.150','1','4.150','4.150','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXA-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXA-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0002','1','PSGT-ZFXA-35-0','1','1.850','1.850','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZFXA-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZFXA-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZFXA-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-02 10:52:52' WHERE kode_barang='PSGT-ZFXA-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZFXA-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-06-02 10:52:52','TOKO','MMPSN','PSGT','PSGT-ZFXA-35-0','1','1.850','1.850','1','1.850','1.850','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-ZFXA-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0002','1','PSGT-ZFXA-36-0','1','1.980','1.980','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZFXA-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZFXA-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZFXA-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-02 10:52:52' WHERE kode_barang='PSGT-ZFXA-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZFXA-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-06-02 10:52:52','TOKO','MMPSN','PSGT','PSGT-ZFXA-36-0','1','1.980','1.980','1','1.980','1.980','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZFXA-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0002','1','PSGT-ZFXA-37-0','1','1.740','1.740','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZFXA-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZFXA-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZFXA-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-02 10:52:52' WHERE kode_barang='PSGT-ZFXA-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZFXA-37-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 10:52:52','TOKO','MMPSN','PSGT','PSGT-ZFXA-37-0','1','1.740','1.740','1','1.740','1.740','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZFXA-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0002','1','PSGT-ZFXA-38-0','1','1.180','1.180','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZFXA-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZFXA-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZFXA-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-06-02 10:52:52' WHERE kode_barang='PSGT-ZFXA-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZFXA-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-06-02 10:52:52','TOKO','MMPSN','PSGT','PSGT-ZFXA-38-0','1','1.180','1.180','1','1.180','1.180','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZFXA-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFXA-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0002','2026-06-02','10:52','16.330','kasir','2026-06-02 10:52:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','11:17:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-02 ','11:22:15');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02305';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02305';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02305';
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-260602-0002','K','2026-06-02','11:23:57','Nagatech','PESANAN BATAL','DP-02305','3894200','0','3894200');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','11:26:19');
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-02326','VAN','1','PLD','WEDDING RING','','','3.000','','35.00','1','1200000','550000','0','900000','2550000','permata 15','size:125 Grf: Shafi ??(love full) Font: Berkshire','putih','150000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0001','2026-06-02','2026-06-02 11:34:20','PESANAN : DP-02326','-','TBC','1800000','1800000');
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-260602-0002','D','2026-06-02','11:34:20','TBC','PESANAN','DP-02326','23183233014','1800000','23185033014','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-02326','2026-06-02','2026-06-02','11:34:20','PLG0011676','VAN','2026-06-16','sby','2026-06-02 11:34:20','3.000','0','0','0','1800000','0','900000','2700000','2700000','900000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','11:37:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','11:42:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('b','2026-06-02 ','11:43:13');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02326';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02326';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02326';
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-260602-0003','K','2026-06-02','11:43:43','b','PESANAN BATAL','DP-02326','3894200','0','3894200');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','11:44:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','11:44:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','11:45:42');
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-02327','VAN','1','PLD','WEDDING RING','','','3.000','','25.00','1','1200000','550000','0','900000','2550000','permata 15','Size: 12.5 Grf:Shafi ?? (love ful) font:Berkshire','putih','150000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0002','2026-06-02','2026-06-02 11:55:42','PESANAN : DP-02327','-','TBC','1800000','1800000');
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-260602-0003','D','2026-06-02','11:55:42','TBC','PESANAN','DP-02327','23185033014','1800000','23186833014','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-02327','2026-06-02','2026-06-02','11:55:42','PLG0011677','VAN','2026-06-26','sby','2026-06-02 11:55:42','3.000','0','0','0','1800000','0','900000','2700000','2700000','900000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','12:37:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-02 ','12:38:59');
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-260602-0001','kasirbip','1',' DP-02217DU','TOKO','DUPSN','PSPRT-ZEBI-8-0','CINCIN PERAK YL-01 ','','3.140','1','100.00','321000','0','0','17800','850000','0','0','0','850000','PUT','00043834','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.140',berat_jual_asli=berat_jual_asli+'3.140',stock_jual='1',berat_akhir=berat_akhir-'3.140',berat_akhir_asli=berat_akhir_asli-'3.140',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSPRT-ZEBI-8-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-260602-0001','2026-06-02','3.140','2026-06-02','12:39:44','PLG0011678','850000','850000','0','850000','0','kasirbip','2026-06-02 12:39:44','FJ-260602-0001','DP-02217','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0001','2026-06-02','12:39:44','PUT','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260602-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-260602-0002','kasir','1',' DP-02196MM','TOKO','MMPSN','PSPRT-ZEBH-5-0','CINCIN PERAK YL-01 ','','1.800','1','100.00','184000','0','0','17800','500000','0','0','0','500000','ELLA','00043810','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBH-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSPRT-ZEBH-5-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-260602-0002','2026-06-02','1.800','2026-06-02','12:40:28','PLG0011679','500000','500000','0','500000','0','kasir','2026-06-02 12:40:28','FJ-260602-0002','DP-02196','500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0002','2026-06-02','12:40:28','ELLA','500000','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-260602-0002' 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-260602-0003','kasir',' 1',' DP-02195MM','TOKO','MMPSN','PSGT-ZFXA-38-0','CINCIN EMAS SR-01 ','','1.180','1','45.00','1328000','0','0','17800','2520000','0','0','0','2520000','ELLA','00043918','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFXA-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSGT-ZFXA-38-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-260602-0003','2026-06-02','1.180','2026-06-02','12:40:28','PLG0011680','2520000','2520000','0','2520000','0','kasir','2026-06-02 12:40:28','FJ-260602-0002','DP-02195','2040000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0003','2026-06-02','12:40:28','ELLA','2520000','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-260602-0003','2026-06-02','2026-06-02 12:40:28','PENJUALAN : FJ-260602-0003','0','TBC','480000','480000','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-260602-0004','D','2026-06-02','12:40:28','TBC','PENJUALAN','FJ-260602-0003','23186833014','480000','23187313014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='480000' WHERE no_faktur_jual='FJ-260602-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0001';
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-260602-0004','kasir','1',' BDL-00001 ','TOKO','TFLBR','BDL-XIXC-40-0','LIONTIN BDL-00001','','1.240','1','103.00','5410000','1613000','91','17800','6500000','0','0','0','6500000','FAISAL','00031074','BDL','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDL-XIXC-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='BDL-XIXC-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFLBR' 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-260602-0004','2026-06-02','1.240','2026-06-02','13:14:00','PLG0011681','6500000','6500000','0','6500000','6200000','kasir','2026-06-02 13:14:00','FJ-260602-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0004','2026-06-02','13:14:00','FAISAL','6500000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260602-0004','D','2026-06-02','13:14:00','kasir','PENJUALAN BERLIAN','FJ-260602-0004','3894200','6200000','10094200','OPEN');
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-260602-0004','2026-06-02','2026-06-02 13:14:00','PENJUALAN : FJ-260602-0004','','TBC','300000','300000','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-260602-0005','D','2026-06-02','13:14:00','TBC','PENJUALAN BERLIAN','FJ-260602-0004','23187313014','300000','23187613014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='6200000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='300000' WHERE no_faktur_jual='FJ-260602-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','13:25:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','13:27:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-02 ','13:46:18');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02112','SULIS','1','1PS CINCIN SILVER','SIZE COWK 16 GRF WULAN SIZE CEWE 14 GRF ADAM FONT BERKSHIRE SWASH DAN KROM PUTIH KILAT','6.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-02112','2026-06-02','2026-06-02','13:57:10','PLG0011682','kasirbip','2026-06-18','kasirbip','2026-06-02 13:57:10','6.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','13:58:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-02 ','14:00:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','14:05:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-02 ','14:15:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','14:20:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','14:21:23');
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-260602-0005','kasir','1',' TFGRR75-87','TOKO','TFGLR','TFGRR-ZBBF-23-0','THIFA GELANG RANTAI RG ','','4.030','1','87.00','8655000','0','0','17800','8680000','0','0','0','8680000','ILUNG','00041922','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-ZBBF-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='TFGRR-ZBBF-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-260602-0005','2026-06-02','4.030','2026-06-02','14:46:13','PLG0011683','8680000','8680000','0','8680000','0','kasir','2026-06-02 14:46:12','FJ-260602-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0005','2026-06-02','14:46:13','ILUNG','8680000','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-260602-0005','2026-06-02','2026-06-02 14:46:12','PENJUALAN : FJ-260602-0005','.','TBC','8680000','8680000','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-260602-0006','D','2026-06-02','14:46:13','TBC','PENJUALAN','FJ-260602-0005','23187613014','8680000','23196293014','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='8680000' WHERE no_faktur_jual='FJ-260602-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-02 ','14:53:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-02 ','14:56:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','14:56:24');
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-260602-0006','kasirbip','1',' DP-02222DU','TOKO','DUPSN','PSPLT-ZEBI-49-0','CINCIN PALADIUM YL-10 ','','4.520','1','17.00','1015000','0','0','17800','2332000','0','0','0','2332000','PUT','00043875','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBI-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.520',berat_jual_asli=berat_jual_asli+'4.520',stock_jual='1',berat_akhir=berat_akhir-'4.520',berat_akhir_asli=berat_akhir_asli-'4.520',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSPLT-ZEBI-49-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-260602-0006','2026-06-02','4.520','2026-06-02','14:56:54','PLG0011684','2332000','2332000','0','2332000','0','kasirbip','2026-06-02 14:56:53','FJ-260602-0006','DP-02222','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-06-02','FJ-260602-0006','2026-06-02','14:56:54','PUT','2332000','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-260602-0006','2026-06-02','2026-06-02 14:56:53','PENJUALAN : FJ-260602-0006','.','TBC','612000','612000','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-260602-0007','D','2026-06-02','14:56:54','TBC','PENJUALAN','FJ-260602-0006','23196293014','612000','23196905014','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='612000' WHERE no_faktur_jual='FJ-260602-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260602-0007','kasirbip','1',' DP-02221DU','TOKO','DUPSN','PSPLT-ZEBI-48-0','CINCIN PALADIUM ','','1.780','1','17.00','400000','0','0','17800','1423000','0','0','0','1423000','PUT','00043874','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBI-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSPLT-ZEBI-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-260602-0007','2026-06-02','1.780','2026-06-02','14:57:38','PLG0011685','1423000','1423000','0','1423000','0','kasirbip','2026-06-02 14:57:37','FJ-260602-0007','DP-02221','1340000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0007','2026-06-02','14:57:38','PUT','1423000','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-260602-0007','2026-06-02','2026-06-02 14:57:37','PENJUALAN : FJ-260602-0007','.','TBC','83000','83000','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-260602-0008','D','2026-06-02','14:57:38','TBC','PENJUALAN','FJ-260602-0007','23196905014','83000','23196988014','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='83000' WHERE no_faktur_jual='FJ-260602-0007' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','14:57:42');
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-02328','KUR','1','PLD','WED RING','','','1.500','','10.00','1','1200000','350000','0','950000','1475000','18 ZIRCON ROSEGOLD GLOSY','SZ 11.5','','180000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0008','2026-06-02','2026-06-02 14:58:44','PESANAN : DP-02328','.','TBC','1460000','1460000');
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-260602-0009','D','2026-06-02','14:58:44','TBC','PESANAN','DP-02328','23196988014','1460000','23198448014','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-02328','2026-06-02','2026-06-02','14:58:44','PLG0011686','KUR','2026-06-23','kasirbip','2026-06-02 14:58:44','1.500','0','0','0','1460000','0','950000','1655000','1655000','195000');
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-260602-0008','sby','1',' 900K-12-00','TOKO','SBYPER','PSBY-ZEXA-82-0','CINCIN SILVER 925 ','','2.060','1','100.00','211000','0','0','17800','1000000','0','0','0','1000000','VAN','00043104','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-82-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSBY-ZEXA-82-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-260602-0008','2026-06-02','2.060','2026-06-02','15:01:02','PLG0011687','1000000','1000000','0','1000000','0','sby','2026-06-02 15:01:01','FJ-260602-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0008','2026-06-02','15:01:02','VAN','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-260602-0009','2026-06-02','2026-06-02 15:01:01','PENJUALAN : FJ-260602-0008','','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-260602-0010','D','2026-06-02','15:01:02','TBC','PENJUALAN','FJ-260602-0008','23198448014','1000000','23199448014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-260602-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260602-0009','sby',' 1',' 800K-195-0','TOKO','SBYPER','PSBY-ZEXE-81-0','CINCIN SILVER 925 ','','2.390','1','100.00','244000','0','0','17800','900000','0','0','0','900000','VAN','00043277','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSBY-ZEXE-81-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-260602-0009','2026-06-02','2.390','2026-06-02','15:01:02','PLG0011688','900000','900000','0','900000','0','sby','2026-06-02 15:01:01','FJ-260602-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0009','2026-06-02','15:01:02','VAN','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260602-0010','2026-06-02','2026-06-02 15:01:01','PENJUALAN : FJ-260602-0009','','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0011','D','2026-06-02','15:01:02','TBC','PENJUALAN','FJ-260602-0009','23199448014','900000','23200348014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1900000' WHERE no_faktur_jual='FJ-260602-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','15:29:08');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','15:36:47');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','15:58:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','15:58:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-02 ','15:58:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-02 ','16:01:17');
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-02329','VAN','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','size:21','Finishing:putih doff mix glossy','Grf: NurCahyo ?? (font:Vintage)','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0011','2026-06-02','2026-06-02 16:20:38','PESANAN : DP-02329','-','TBC','1400000','1400000');
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-260602-0012','D','2026-06-02','16:20:38','TBC','PESANAN','DP-02329','23200348014','1400000','23201748014','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-02329','2026-06-02','2026-06-02','16:20:38','PLG0011689','VAN','2026-06-26','sby','2026-06-02 16:20:38','4.000','0','0','0','1400000','0','700000','2100000','2100000','700000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','16:25:10');
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-02330','VAN','1','GOLD','WEDDING RING','','','2.500','','375.00','1','2420000','1500000','0','750000','4500000','permata zirkon 1','size:16 Grf: NurCahyo (Font:Vintage)','Finishing : putih doff mix glossy','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0012','2026-06-02','2026-06-02 16:30:52','PESANAN : DP-02330','-','TBC','3100000','3100000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0013','D','2026-06-02','16:30:52','TBC','PESANAN','DP-02330','23201748014','3100000','23204848014','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-02330','2026-06-02','2026-06-02','16:30:52','PLG0011690','VAN','2026-06-26','sby','2026-06-02 16:30:52','2.500','0','0','0','3100000','0','750000','4510000','4510000','1410000');
UPDATE tt_service_head SET tgl_selesai='2026-06-02',  status ='DONE' WHERE no_service='SV-02087';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02087';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-02',  status ='CLOS' WHERE no_service='SV-02087';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02087';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','16:55:00');
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-20260602-0003','1','PSGT-ZEBI-9-0','1','3.010','3.010','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-06-02 16:57:01' WHERE kode_barang='PSGT-ZEBI-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 16:57:01','TOKO','SBYPSN','PSGT','PSGT-ZEBI-9-0','1','3.010','3.010','1','3.010','3.010','83.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-ZEBI-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0003','1','PSGT-ZEBI-10-0','1','2.580','2.580','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-06-02 16:57:01' WHERE kode_barang='PSGT-ZEBI-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-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-06-02 16:57:01','TOKO','SBYPSN','PSGT','PSGT-ZEBI-10-0','1','2.580','2.580','1','2.580','2.580','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-ZEBI-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0003','1','PSGT-ZEBI-53-0','1','4.120','4.120','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-06-02 16:57:01' WHERE kode_barang='PSGT-ZEBI-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-53-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 16:57:01','TOKO','SBYPSN','PSGT','PSGT-ZEBI-53-0','1','4.120','4.120','1','4.120','4.120','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-ZEBI-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-53-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0003','1','PSGT-ZEBI-54-0','1','2.380','2.380','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-54-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-54-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-54-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-06-02 16:57:01' WHERE kode_barang='PSGT-ZEBI-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-54-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 16:57:01','TOKO','SBYPSN','PSGT','PSGT-ZEBI-54-0','1','2.380','2.380','1','2.380','2.380','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-ZEBI-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-54-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0003','2026-06-02','16:56','12.090','sby','2026-06-02 16:57:01');
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-20260602-0004','1','PSBY-ZEXA-109-0','1','2.180','2.180','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZEXA-109-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZEXA-109-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZEXA-109-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZEXA-109-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-06-02 17:00:44' WHERE kode_barang='PSBY-ZEXA-109-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZEXA-109-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 17:00:44','TOKO','SBYPER','PSBY','PSBY-ZEXA-109-0','1','2.180','2.180','1','2.180','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZEXA-109-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZEXA-109-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0004','2026-06-02','16:57','2.180','sby','2026-06-02 17:00:44');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260602-0005','1','CMSBY-ZEXA-104-0','1','1.210','1.210','TOKO','SBYCM','TOKO','SBYCM');
DELETE FROM tm_barang WHERE kode_barang='CMSBY-ZEXA-104-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-104-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CMSBY-ZEXA-104-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMSBY-ZEXA-104-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYCM',tgl_last_beli='2026-06-02 17:02:36' WHERE kode_barang='CMSBY-ZEXA-104-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CMSBY-ZEXA-104-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 17:02:36','TOKO','SBYCM','CMSBY','CMSBY-ZEXA-104-0','1','1.210','1.210','1','1.210','1.210','45.00');
DELETE FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CMSBY-ZEXA-104-0';
DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-104-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0005','1','CMSBY-ZEXA-105-0','1','1.500','1.500','TOKO','SBYCM','TOKO','SBYCM');
DELETE FROM tm_barang WHERE kode_barang='CMSBY-ZEXA-105-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-105-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CMSBY-ZEXA-105-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMSBY-ZEXA-105-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYCM',tgl_last_beli='2026-06-02 17:02:36' WHERE kode_barang='CMSBY-ZEXA-105-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CMSBY-ZEXA-105-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 17:02:36','TOKO','SBYCM','CMSBY','CMSBY-ZEXA-105-0','1','1.500','1.500','1','1.500','1.500','45.00');
DELETE FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CMSBY-ZEXA-105-0';
DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-105-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0005','1','CMSBY-ZEXA-106-0','1','1.480','1.480','TOKO','SBYCM','TOKO','SBYCM');
DELETE FROM tm_barang WHERE kode_barang='CMSBY-ZEXA-106-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-106-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CMSBY-ZEXA-106-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMSBY-ZEXA-106-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYCM',tgl_last_beli='2026-06-02 17:02:36' WHERE kode_barang='CMSBY-ZEXA-106-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CMSBY-ZEXA-106-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 17:02:36','TOKO','SBYCM','CMSBY','CMSBY-ZEXA-106-0','1','1.480','1.480','1','1.480','1.480','45.00');
DELETE FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CMSBY-ZEXA-106-0';
DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-106-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0005','1','CMSBY-ZEXA-107-0','1','1.400','1.400','TOKO','SBYCM','TOKO','SBYCM');
DELETE FROM tm_barang WHERE kode_barang='CMSBY-ZEXA-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-107-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CMSBY-ZEXA-107-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMSBY-ZEXA-107-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYCM',tgl_last_beli='2026-06-02 17:02:36' WHERE kode_barang='CMSBY-ZEXA-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CMSBY-ZEXA-107-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 17:02:36','TOKO','SBYCM','CMSBY','CMSBY-ZEXA-107-0','1','1.400','1.400','1','1.400','1.400','45.00');
DELETE FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CMSBY-ZEXA-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-107-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' 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-20260602-0005','1','CMSBY-ZEXA-108-0','1','1.390','1.390','TOKO','SBYCM','TOKO','SBYCM');
DELETE FROM tm_barang WHERE kode_barang='CMSBY-ZEXA-108-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-108-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CMSBY-ZEXA-108-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMSBY-ZEXA-108-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYCM',tgl_last_beli='2026-06-02 17:02:36' WHERE kode_barang='CMSBY-ZEXA-108-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CMSBY-ZEXA-108-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-02 17:02:36','TOKO','SBYCM','CMSBY','CMSBY-ZEXA-108-0','1','1.390','1.390','1','1.390','1.390','45.00');
DELETE FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CMSBY-ZEXA-108-0';
DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZEXA-108-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0005','2026-06-02','17:00','6.980','sby','2026-06-02 17:02:35');
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-02331','PUT','1','PER','WEDD RING','','','2.500','','925.00','1','100000','0','800000','0','800000','sz 13 crom doff semprot samakan sprti cntoh','grf Alexander 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-260602-0013','2026-06-02','2026-06-02 17:12:26','PESANAN : DP-02331','.','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0014','D','2026-06-02','17:12:26','TBC','PESANAN','DP-02331','23204848014','800000','23205648014','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-02331','2026-06-02','2026-06-02','17:12:26','PLG0011691','PUT','2026-06-24','kasirbip','2026-06-02 17:12:26','2.500','0','0','0','800000','0','0','800000','800000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02332','PUT','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 14.5 crom doff semprot samakan sprti cntoh','grf Karina 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-260602-0014','2026-06-02','2026-06-02 17:17:49','PESANAN : DP-02332','.','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-260602-0015','D','2026-06-02','17:17:49','TBC','PESANAN','DP-02332','23205648014','850000','23206498014','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-02332','2026-06-02','2026-06-02','17:17:49','PLG0011692','PUT','2026-06-24','kasirbip','2026-06-02 17:17:49','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260602-0010','kasir','1',' DP-02179MM','TOKO','MMPSN','PSGT-ZFXA-37-0','CINCIN EMAS SR-03 ','','1.740','1','45.00','1957000','0','0','17800','3360000','0','0','0','3360000','ELLA','00043917','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFXA-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSGT-ZFXA-37-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-260602-0010','2026-06-02','1.740','2026-06-02','18:01:59','PLG0011693','3360000','3360000','0','3360000','0','kasir','2026-06-02 18:01:58','FJ-260602-0010','DP-02179','2280000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0010','2026-06-02','18:01:59','ELLA','3360000','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-260602-0015','2026-06-02','2026-06-02 18:01:58','PENJUALAN : FJ-260602-0010','0','TBC','1080000','1080000','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-260602-0016','D','2026-06-02','18:01:59','TBC','PENJUALAN','FJ-260602-0010','23206498014','1080000','23207578014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1080000' WHERE no_faktur_jual='FJ-260602-0010' 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-260602-0011','kasir','1',' DP-02180MM','TOKO','MMPSN','PSPRT-ZEBH-4-0','CINCIN PERAK YL-01 ','','2.110','1','100.00','216000','0','0','17800','500000','0','0','0','500000','RIRIN','00043809','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBH-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSPRT-ZEBH-4-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-260602-0011','2026-06-02','2.110','2026-06-02','18:03:45','PLG0011694','500000','500000','0','500000','-100000','kasir','2026-06-02 18:03:44','FJ-260602-0011','DP-02180','600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0011','2026-06-02','18:03:45','RIRIN','500000','0');
UPDATE tt_jual_head SET dibayar_rp='-100000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260602-0011' 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-02333','PUT','1','PLD','1 BUAH CINCIN','','','2.500','','25.00','1','1200000','550000','0','750000','2125000','exspress 100.000','sz 17 crom silver kombinasi warna kuning','grf Firma & Dodi','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-260602-0016','2026-06-02','2026-06-02 18:10:22','PESANAN : DP-02333','.','TBC','1700000','1700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0017','D','2026-06-02','18:10:22','TBC','PESANAN','DP-02333','23207578014','1700000','23209278014','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-02333','2026-06-02','2026-06-02','18:10:22','PLG0011695','PUT','2026-06-08','kasirbip','2026-06-02 18:10:22','2.500','0','0','0','1700000','0','750000','2125000','2125000','425000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0011';
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-02334','SULIS','1','GOLD','WED RING','','','1.300','','37.50','1','2450000','1500000','0','750000','2700000','sz 11 kuning doff semprot 1 zircon','font brush script grf JULIUS','EXPRESS SR-01','0','0','200000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0017','2026-06-02','2026-06-02 18:23:32','PESANAN : DP-02334','.','TBC','2360000','2360000');
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-260602-0018','D','2026-06-02','18:23:32','TBC','PESANAN','DP-02334','23209278014','2360000','23211638014','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-02334','2026-06-02','2026-06-02','18:23:32','PLG0011696','SULIS','2026-06-12','kasirbip','2026-06-02 18:23:32','1.300','0','0','0','2360000','0','750000','2900000','2900000','540000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','18:32:19');
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-02335','VAN','1','GOLD','WEDDING RING','','','3.500','','37.50','1','2450000','1500000','0','1000000','6250000','30 permata','grf: X ?? D (font:Brush script)','size: 18 (finishing:gold kuning)','300000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0018','2026-06-02','2026-06-02 18:39:31','PESANAN : DP-02335','-','TBC','4500000','4500000');
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-260602-0019','D','2026-06-02','18:39:31','TBC','PESANAN','DP-02335','23211638014','4500000','23216138014','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-02335','2026-06-02','2026-06-02','18:39:31','PLG0011697','VAN','2026-06-21','sby','2026-06-02 18:39:31','3.500','0','0','0','4500000','0','1000000','6550000','6550000','2050000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','18:41:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','18:43:17');
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-02336','VAN','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','size: 18','Grf: X ?? D (Font:Brush script)','finishing putih doff mix glossy','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0019','2026-06-02','2026-06-02 18:53:58','PESANAN : DP-02336','-','TBC','1400000','1400000');
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-260602-0020','D','2026-06-02','18:53:58','TBC','PESANAN','DP-02336','23216138014','1400000','23217538014','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-02336','2026-06-02','2026-06-02','18:53:58','PLG0011698','VAN','2026-06-21','sby','2026-06-02 18:53:58','4.000','0','0','0','1400000','0','700000','2100000','2100000','700000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02113','ILUNG','1','CBR','JADI SIZE 16 KRUM PUTIH URGENT PAGI UDAH SELESAI YAA','2.340','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-02113','2026-06-02','2026-06-02','19:51:53','PLG0011699','kasir','2026-06-04','kasir','2026-06-02 19:51:53','2.340','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-260602-0012','kasirbip','1',' 700K-165-2','TOKO','BIPPER','PBDG-ZEBB-25-0','CINCIN SILVER 925 ','','1.950','1','100.00','199000','0','0','17800','800000','0','0','0','800000','KUR','00043737','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBB-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PBDG-ZEBB-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260602-0012','2026-06-02','1.950','2026-06-02','19:59:26','PLG0011700','800000','800000','0','800000','0','kasirbip','2026-06-02 19:59:26','FJ-260602-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0012','2026-06-02','19:59:26','KUR','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260602-0020','2026-06-02','2026-06-02 19:59:26','PENJUALAN : FJ-260602-0012','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0021','D','2026-06-02','19:59:26','TBC','PENJUALAN','FJ-260602-0012','23217538014','800000','23218338014','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='800000' WHERE no_faktur_jual='FJ-260602-0012' 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-02337','DIL','1','PLD','WEDD RING CUSTOM','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','PERMATA ZIRCON 1 BUTIR','SIZE 18','CROM PUTIH GLOSSY','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0021','2026-06-02','2026-06-02 20:02:11','PESANAN : DP-02337','-','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0022','D','2026-06-02','20:02:11','TBC','PESANAN','DP-02337','23218338014','2000000','23220338014','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-02337','2026-06-02','2026-06-02','20:02:11','PLG0011701','DIL','2026-06-28','sby','2026-06-02 20:02:11','4.000','0','0','0','2000000','0','750000','2960000','2960000','960000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260602-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260602-0012';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-02',  status ='CLOS' WHERE no_service='SV-02079';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02079';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','21:06:11');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02338','VAN','1','PER','WEDDING RING SR 03','','','1.000','','925.00','1','100000','0','950000','0','950000','size pria:18 wanita:9','grf:Adis ?? Rian (font:Times new roman)','putih','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-260602-0022','2026-06-02','2026-06-02 21:18:06','PESANAN : DP-02338','-','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-260602-0023','D','2026-06-02','21:18:06','TBC','PESANAN','DP-02338','23220338014','950000','23221288014','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-02338','2026-06-02','2026-06-02','21:18:06','PLG0011702','VAN','2026-06-23','sby','2026-06-02 21:18:06','1.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02339','DIL','1','PLD','WEDD RING CUSTOM','','','5.000','','25.00','1','1200000','550000','0','750000','3500000','SIZE 17 . GRF : WINA ?? RIKY','REQ LEBAR 5MM . ULIRAN FULL','CROM PUTIH DOFF MIX GLOSSY ROSE GOLD','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0023','2026-06-02','2026-06-02 21:26:13','PESANAN : DP-02339','-','TBC','2400000','2400000');
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-260602-0024','D','2026-06-02','21:26:13','TBC','PESANAN','DP-02339','23221288014','2400000','23223688014','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-02339','2026-06-02','2026-06-02','21:26:13','PLG0011703','DIL','2026-06-12','sby','2026-06-02 21:26:13','5.000','0','0','0','2400000','0','750000','3500000','3500000','1100000');
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-02340','DIL','1','GOLD','WEDD RING CUSTOM','','','4.000','','75.00','1','2450000','2400000','0','850000','10450000','PERMATA 14 BUTIR . REQ LEBAR 4MM . ULIRAN SETENGAH','SIZE 11 . GRF : RIKY ?? WINA','PUTIH (EMAS PUTIH) MIX ROSE GOLD','140000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0024','2026-06-02','2026-06-02 21:37:42','PESANAN : DP-02340','-','TBC','7400000','7400000');
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-260602-0025','D','2026-06-02','21:37:42','TBC','PESANAN','DP-02340','23223688014','7400000','23231088014','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-02340','2026-06-02','2026-06-02','21:37:42','PLG0011704','DIL','2026-06-12','sby','2026-06-02 21:37:42','4.000','0','0','0','7400000','0','850000','10590000','10590000','3190000');
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-02341','DIL','1','GOLD','WEDD RING','','','2.500','','37.50','1','2450000','1500000','0','950000','4700000','PERMATA 25 BUTIR','SIZE 13 . GRF : Fandi (times new)','crom putih (emas putih)','250000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0025','2026-06-02','2026-06-02 21:45:59','PESANAN : DP-02341','-','TBC','3400000','3400000');
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-260602-0026','D','2026-06-02','21:45:59','TBC','PESANAN','DP-02341','23231088014','3400000','23234488014','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-02341','2026-06-02','2026-06-02','21:45:59','PLG0011705','DIL','2026-06-28','sby','2026-06-02 21:45:59','2.500','0','0','0','3400000','0','950000','4950000','4950000','1550000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','21:46:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','21:56:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','21:58:58');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260602-0013','sby','1',' 850K-20-00','TOKO','SBYPER','PSBY-ZEXE-48-0','CINCIN SILVER 925 ','','4.810','1','100.00','492000','0','0','17800','950000','0','0','0','950000','DIL','00043244','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.810',berat_jual_asli=berat_jual_asli+'4.810',stock_jual='1',berat_akhir=berat_akhir-'4.810',berat_akhir_asli=berat_akhir_asli-'4.810',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='PSBY-ZEXE-48-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-260602-0013','2026-06-02','4.810','2026-06-02','22:00:52','PLG0011706','950000','950000','0','950000','0','sby','2026-06-02 22:00:52','FJ-260602-0013','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','FJ-260602-0013','2026-06-02','22:00:52','DIL','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260602-0026','2026-06-02','2026-06-02 22:00:52','PENJUALAN : FJ-260602-0013','','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0027','D','2026-06-02','22:00:52','TBC','PENJUALAN','FJ-260602-0013','23234488014','950000','23235438014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260602-0013' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02342','DIL','1','PER','WEDD RING','','','1.000','','925.00','1','100000','0','850000','0','850000','size 19 . grf : Ana (times new)','crom putih doff mix glossy','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0027','2026-06-02','2026-06-02 22:05:42','PESANAN : DP-02342','-','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-260602-0028','D','2026-06-02','22:05:42','TBC','PESANAN','DP-02342','23235438014','850000','23236288014','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-02342','2026-06-02','2026-06-02','22:05:42','PLG0011707','DIL','2026-06-28','sby','2026-06-02 22:05:42','1.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-02 ','22:11:43');
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-02343','DIL','1','PLD','WEDD RING','','','3.500','','10.00','1','1200000','350000','0','700000','1925000','size 18.5 grf : Nia ?? Zaki (vintage)','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-260602-0028','2026-06-02','2026-06-02 22:14:16','PESANAN : DP-02343','-','TBC','1300000','1300000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0029','D','2026-06-02','22:14:16','TBC','PESANAN','DP-02343','23236288014','1300000','23237588014','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-02343','2026-06-02','2026-06-02','22:14:16','PLG0011708','DIL','2026-06-12','sby','2026-06-02 22:14:16','3.500','0','0','0','1300000','0','700000','1925000','1925000','625000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02344','DIL','1','PLD','WEED RING','','','2.500','','25.00','1','1200000','550000','0','800000','2175000','permata 1 butir','size 13 grf : Zaki ?? Nia (vintage)','putih','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260602-0029','2026-06-02','2026-06-02 22:16:29','PESANAN : DP-02344','-','TBC','1500000','1500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260602-0030','D','2026-06-02','22:16:29','TBC','PESANAN','DP-02344','23237588014','1500000','23239088014','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-02344','2026-06-02','2026-06-02','22:16:29','PLG0011709','DIL','2026-06-12','sby','2026-06-02 22:16:29','2.500','0','0','0','1500000','0','800000','2185000','2185000','685000');