INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-01 ','08:23:25');
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-20261001-0001','1','TFKMP-ZJXA-1-0','1','1.980','1.980','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-1-0','1','1.980','1.980','1','1.980','1.980','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-2-0','1','1.980','1.980','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-2-0','1','1.980','1.980','1','1.980','1.980','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-3-0','1','2.030','2.030','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-3-0','1','2.030','2.030','1','2.030','2.030','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-4-0','1','2.050','2.050','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-4-0','1','2.050','2.050','1','2.050','2.050','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-5-0','1','2.060','2.060','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-5-0','1','2.060','2.060','1','2.060','2.060','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-6-0','1','2.050','2.050','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-6-0','1','2.050','2.050','1','2.050','2.050','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-7-0','1','2.030','2.030','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-7-0','1','2.030','2.030','1','2.030','2.030','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-8-0','1','2.050','2.050','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-8-0','1','2.050','2.050','1','2.050','2.050','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-9-0','1','2.950','2.950','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-9-0','1','2.950','2.950','1','2.950','2.950','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0001','1','TFKMP-ZJXA-10-0','1','2.860','2.860','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZJXA-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZJXA-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZJXA-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-10-01 08:24:07' WHERE kode_barang='TFKMP-ZJXA-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZJXA-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 08:24:07','TOKO','TFKMP','TFKMP','TFKMP-ZJXA-10-0','1','2.860','2.860','1','2.860','2.860','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZJXA-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZJXA-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261001-0001','2026-10-01','08:23','22.040','kasir','2026-10-01 08:24:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-01 ','08:32:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-01 ','10:36:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-01 ','10:43:17');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0001','jogja','1',' 750K-155-0','TOKO','JOGPER','PJOG-ZFAA-61-0','CINCIN SILVER 925 ','','2.470','1','100.00','253000','0','0','17800','850000','0','0','0','850000','DEW','00044260','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.470',berat_jual_asli=berat_jual_asli+'2.470',stock_jual='1',berat_akhir=berat_akhir-'2.470',berat_akhir_asli=berat_akhir_asli-'2.470',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PJOG-ZFAA-61-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261001-0001','2026-10-01','2.470','2026-10-01','10:53:31','PLG0016680','850000','850000','0','850000','0','jogja','2026-10-01 10:53:30','FJ-261001-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0001','2026-10-01','10:53:31','DEW','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261001-0001','2026-10-01','2026-10-01 10:53:30','PENJUALAN : FJ-261001-0001','.','BCD','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0002','D','2026-10-01','10:53:31','BCD','PENJUALAN','FJ-261001-0001','1462437500','850000','1463287500','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261001-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-261001-0002','jogja',' 1',' 750K-10-00','TOKO','JOGPER','PJOG-ZFAA-92-0','CINCIN SILVER 925 ','','1.840','1','100.00','188000','0','0','17800','850000','0','0','0','850000','DEW','00044291','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.840',berat_jual_asli=berat_jual_asli+'1.840',stock_jual='1',berat_akhir=berat_akhir-'1.840',berat_akhir_asli=berat_akhir_asli-'1.840',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PJOG-ZFAA-92-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261001-0002','2026-10-01','1.840','2026-10-01','10:53:31','PLG0016681','850000','850000','0','850000','0','jogja','2026-10-01 10:53:30','FJ-261001-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0002','2026-10-01','10:53:31','DEW','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261001-0002','2026-10-01','2026-10-01 10:53:30','PENJUALAN : FJ-261001-0002','.','BCD','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0003','D','2026-10-01','10:53:31','BCD','PENJUALAN','FJ-261001-0002','1463287500','850000','1464137500','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='1700000' WHERE no_faktur_jual='FJ-261001-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-261001-0003','kasirbip','1',' DP-03775DU','TOKO','DUPSN','PSPRT-ZIBF-8-0','CINCIN PERAK ','','1.820','1','100.00','186000','0','0','17800','950000','0','0','0','950000','NAD','00047646','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBF-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBF-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-261001-0003','2026-10-01','1.820','2026-10-01','10:54:24','PLG0016682','950000','950000','0','950000','0','kasirbip','2026-10-01 10:54:23','FJ-261001-0003','DP-03775','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0003','2026-10-01','10:54:24','NAD','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0004','kasirbip',' 1',' DP-03776DU','TOKO','DUPSN','PSPRT-ZIBD-17-0','CINCIN PERAK YL10 ','','4.950','1','100.00','505000','0','0','17800','900000','0','0','0','900000','NAD','00047557','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBD-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBD-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0004','2026-10-01','4.950','2026-10-01','10:54:24','PLG0016683','900000','900000','0','900000','0','kasirbip','2026-10-01 10:54:23','FJ-261001-0003','DP-03776','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0004','2026-10-01','10:54:24','NAD','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-01 ','11:02:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-01 ','11:04:11');
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-261001-0005','kasirbip','1',' 800K-19-29','TOKO','BIPPER','PBDG-ZIBC-10-0','CINCIN SILVER 925 ','','3.240','1','100.00','331000','0','0','17800','900000','0','0','0','900000','KUR','00047489','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBC-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.240',berat_jual_asli=berat_jual_asli+'3.240',stock_jual='1',berat_akhir=berat_akhir-'3.240',berat_akhir_asli=berat_akhir_asli-'3.240',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PBDG-ZIBC-10-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-261001-0005','2026-10-01','3.240','2026-10-01','11:06:49','PLG0016684','900000','900000','0','900000','0','kasirbip','2026-10-01 11:06:49','FJ-261001-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0005','2026-10-01','11:06:49','KUR','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-261001-0003','2026-10-01','2026-10-01 11:06:49','PENJUALAN : FJ-261001-0005','.','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-261001-0002','D','2026-10-01','11:06:49','TBC','PENJUALAN','FJ-261001-0005','28559808464','900000','28560708464','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261001-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0005';
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-20261001-0002','1','PSPLT-ZICX-3-0','1','3.480','3.480','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZICX-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZICX-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZICX-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPLT-ZICX-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZICX-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPLT','PSPLT-ZICX-3-0','1','3.480','3.480','1','3.480','3.480','57.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-ZICX-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPRT-ZICX-4-0','1','2.180','2.180','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPRT-ZICX-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPRT','PSPRT-ZICX-4-0','1','2.180','2.180','1','2.180','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPRT-ZICX-5-0','1','3.250','3.250','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPRT-ZICX-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPRT','PSPRT-ZICX-5-0','1','3.250','3.250','1','3.250','3.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPRT-ZICX-6-0','1','1.930','1.930','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPRT-ZICX-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPRT','PSPRT-ZICX-6-0','1','1.930','1.930','1','1.930','1.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPLT-ZICX-7-0','1','2.960','2.960','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZICX-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZICX-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZICX-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPLT-ZICX-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZICX-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPLT','PSPLT-ZICX-7-0','1','2.960','2.960','1','2.960','2.960','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZICX-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPRT-ZICX-8-0','1','2.280','2.280','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPRT-ZICX-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPRT','PSPRT-ZICX-8-0','1','2.280','2.280','1','2.280','2.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPRT-ZICX-12-0','1','6.500','6.500','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPRT-ZICX-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPRT','PSPRT-ZICX-12-0','1','6.500','6.500','1','6.500','6.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSGT-ZICX-13-0','1','1.700','1.700','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZICX-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZICX-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZICX-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSGT-ZICX-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZICX-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSGT','PSGT-ZICX-13-0','1','1.700','1.700','1','1.700','1.700','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZICX-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSGT-ZICX-14-0','1','2.270','2.270','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZICX-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZICX-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZICX-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSGT-ZICX-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZICX-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSGT','PSGT-ZICX-14-0','1','2.270','2.270','1','2.270','2.270','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-ZICX-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPRT-ZICX-15-0','1','3.200','3.200','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPRT-ZICX-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPRT','PSPRT-ZICX-15-0','1','3.200','3.200','1','3.200','3.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSPRT-ZICX-16-0','1','3.450','3.450','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSPRT-ZICX-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSPRT','PSPRT-ZICX-16-0','1','3.450','3.450','1','3.450','3.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0002','1','PSGT-ZICX-17-0','1','2.040','2.040','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZICX-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZICX-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZICX-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-01 11:23:26' WHERE kode_barang='PSGT-ZICX-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZICX-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 11:23:26','TOKO','DUPSN','PSGT','PSGT-ZICX-17-0','1','2.040','2.040','1','2.040','2.040','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-ZICX-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261001-0002','2026-10-01','11:23','35.240','kasirbip','2026-10-01 11:23:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-01 ','11:39:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-01 ','11:39:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-01 ','11:56:32');
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-261001-0006','sby','1',' DP-03821SB','TOKO','SBYPSN','PSPRT-ZIBE-26-0','CINCIN PERAK ','','1.750','1','100.00','179000','0','0','17800','850000','0','0','0','850000','DIL','00047606','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBE-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBE-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0006','2026-10-01','1.750','2026-10-01','11:57:27','PLG0016685','850000','850000','0','850000','0','sby','2026-10-01 11:57:26','FJ-261001-0006','DP-03821','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0006','2026-10-01','11:57:27','DIL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-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-261001-0007','kasir','1',' TFC-21511 ','TOKO','TFCBR','TFC-ZBXI-3-0','CINCIN TFC-21511 ','','4.240','1','83.00','16811000','6835500','384','17800','22000000','0','0','0','22000000','FAISAL','00041414','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-ZBXI-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.240',berat_jual_asli=berat_jual_asli+'4.240',stock_jual='1',berat_akhir=berat_akhir-'4.240',berat_akhir_asli=berat_akhir_asli-'4.240',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='TFC-ZBXI-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0007','2026-10-01','4.240','2026-10-01','12:12:53','PLG0016686','22000000','22000000','0','22000000','0','kasir','2026-10-01 12:12:52','FJ-261001-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0007','2026-10-01','12:12:53','FAISAL','22000000','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-261001-0004','2026-10-01','2026-10-01 12:12:52','PENJUALAN : FJ-261001-0007','.','TBC','22000000','22000000','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-261001-0003','D','2026-10-01','12:12:53','TBC','PENJUALAN BERLIAN','FJ-261001-0007','28560708464','22000000','28582708464','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='22000000' WHERE no_faktur_jual='FJ-261001-0007' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-01 ','12:15:26');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0007';
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-04305','PUT','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','1000000','0','1000000','sz cwe 16.5 crom putih glosy','grf Krisna Aditya 13','font Comic sans','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-261001-0005','2026-10-01','2026-10-01 12:21:46','PESANAN : DP-04305','.','TBC','1000000','1000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0004','D','2026-10-01','12:21:46','TBC','PESANAN','DP-04305','28582708464','1000000','28583708464','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-04305','2026-10-01','2026-10-01','12:21:46','PLG0016687','PUT','2026-10-25','kasirbip','2026-10-01 12:21:46','2.500','0','0','0','1000000','0','0','1000000','1000000','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-04306','PUT','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwo 18','grf Siti Nurjanah 13','font comic sans','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-261001-0006','2026-10-01','2026-10-01 12:23:16','PESANAN : DP-04306','.','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-261001-0005','D','2026-10-01','12:23:16','TBC','PESANAN','DP-04306','28583708464','850000','28584558464','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-04306','2026-10-01','2026-10-01','12:23:16','PLG0016688','PUT','2026-10-25','kasirbip','2026-10-01 12:23:16','2.500','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-261001-0008','kasirbip','1',' DP-03958BI','TOKO','BIPPSN','PSPRT-ZIBI-10-0','CINCIN PERAK ','','2.760','1','100.00','282000','0','0','17800','900000','0','0','0','900000','KUR','00047749','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.760',berat_jual_asli=berat_jual_asli+'2.760',stock_jual='1',berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBI-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0008','2026-10-01','2.760','2026-10-01','12:59:27','PLG0016689','900000','900000','0','900000','0','kasirbip','2026-10-01 12:59:27','FJ-261001-0008','DP-03958','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0008','2026-10-01','12:59:27','KUR','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-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-261001-0009','kasirbip',' 1',' DP-03957BI','TOKO','BIPPSN','PSPRT-ZIBI-33-0','CINCIN PERAK SR04 ','','1.170','1','100.00','120000','0','0','17800','800000','0','0','0','800000','KUR','00047772','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBI-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0009','2026-10-01','1.170','2026-10-01','12:59:27','PLG0016690','800000','800000','0','800000','0','kasirbip','2026-10-01 12:59:27','FJ-261001-0008','DP-03957','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0009','2026-10-01','12:59:27','KUR','800000','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-261001-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-01 ','13:51:51');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0010','sby','1',' DP-03884SB','TOKO','SBYPSN','PSGT-ZIBH-54-0','CINCIN EMAS ','','2.310','1','45.00','2439000','0','0','17800','4324000','0','0','0','4324000','VAN','00047718','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBH-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSGT-ZIBH-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0010','2026-10-01','2.310','2026-10-01','13:55:29','PLG0016691','4324000','4324000','0','4324000','0','sby','2026-10-01 13:55:29','FJ-261001-0010','DP-03884','3700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0010','2026-10-01','13:55:29','VAN','4324000','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-261001-0007','2026-10-01','2026-10-01 13:55:29','PENJUALAN : FJ-261001-0010','','TBC','624000','624000','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-261001-0006','D','2026-10-01','13:55:29','TBC','PENJUALAN','FJ-261001-0010','28584558464','624000','28585182464','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='624000' WHERE no_faktur_jual='FJ-261001-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-261001-0011','sby',' 1',' DP-03883SB','TOKO','SBYPSN','PSGT-ZIBH-56-0','CINCIN EMAS ','','3.190','1','45.00','3369000','0','0','17800','5166000','0','0','0','5166000','VAN','00047720','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBH-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSGT-ZIBH-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0011','2026-10-01','3.190','2026-10-01','13:55:29','PLG0016692','5166000','5166000','0','5166000','0','sby','2026-10-01 13:55:29','FJ-261001-0010','DP-03883','4300000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0011','2026-10-01','13:55:29','VAN','5166000','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-261001-0008','2026-10-01','2026-10-01 13:55:29','PENJUALAN : FJ-261001-0011','','TBC','866000','866000','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-261001-0007','D','2026-10-01','13:55:29','TBC','PENJUALAN','FJ-261001-0011','28585182464','866000','28586048464','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='1490000' WHERE no_faktur_jual='FJ-261001-0011' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0012','kasirbip','1',' DP-04180DU','TOKO','DUPSN','PSGT-ZIBI-42-0','CINCIN EMAS ','','2.280','1','45.00','2408000','0','0','17800','3892000','0','0','0','3892000','NAD','00047781','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBI-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.280',berat_jual_asli=berat_jual_asli+'2.280',stock_jual='1',berat_akhir=berat_akhir-'2.280',berat_akhir_asli=berat_akhir_asli-'2.280',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSGT-ZIBI-42-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-261001-0012','2026-10-01','2.280','2026-10-01','14:28:12','PLG0016693','3892000','3892000','0','3892000','0','kasirbip','2026-10-01 14:28:12','FJ-261001-0012','DP-04180','2800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0012','2026-10-01','14:28:12','NAD','3892000','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-261001-0009','2026-10-01','2026-10-01 14:28:12','PENJUALAN : FJ-261001-0012','.','TBC','1092000','1092000','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-261001-0008','D','2026-10-01','14:28:12','TBC','PENJUALAN','FJ-261001-0012','28586048464','1092000','28587140464','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='1092000' WHERE no_faktur_jual='FJ-261001-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0013','kasirbip',' 1',' DP-04181DU','TOKO','DUPSN','PSPRT-ZIBH-47-0','CINCIN PERAK ','','2.680','1','100.00','274000','0','0','17800','850000','0','0','0','850000','NAD','00047711','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBH-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBH-47-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0013','2026-10-01','2.680','2026-10-01','14:28:12','PLG0016694','850000','850000','0','850000','0','kasirbip','2026-10-01 14:28:12','FJ-261001-0012','DP-04181','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0013','2026-10-01','14:28:12','NAD','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1092000' WHERE no_faktur_jual='FJ-261001-0013' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0014','kasirbip','1',' DP-03840BI','TOKO','BIPPSN','PSPLT-ZIBI-32-0','CINCIN PALADIUM ','','3.200','1','17.00','719000','0','0','17800','1920000','0','0','0','1920000','SAL','00047771','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBI-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPLT-ZIBI-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0014','2026-10-01','3.200','2026-10-01','14:38:46','PLG0016695','1920000','1920000','0','1920000','0','kasirbip','2026-10-01 14:38:45','FJ-261001-0014','DP-03840','1620000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0014','2026-10-01','14:38:46','SAL','1920000','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-261001-0010','2026-10-01','2026-10-01 14:38:45','PENJUALAN : FJ-261001-0014','.','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-261001-0009','D','2026-10-01','14:38:46','TBC','PENJUALAN','FJ-261001-0014','28587140464','300000','28587440464','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='300000' WHERE no_faktur_jual='FJ-261001-0014' 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-261001-0015','kasirbip',' 1',' DP-03839BI','TOKO','BIPPSN','PSPLT-ZIBF-6-0','CINCIN PALADIUM ','','3.930','1','17.00','883000','0','0','17800','2175500','0','0','0','2175500','SAL','00047644','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.930',berat_jual_asli=berat_jual_asli+'3.930',stock_jual='1',berat_akhir=berat_akhir-'3.930',berat_akhir_asli=berat_akhir_asli-'3.930',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPLT-ZIBF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0015','2026-10-01','3.930','2026-10-01','14:38:46','PLG0016696','2175500','2175500','0','2175500','0','kasirbip','2026-10-01 14:38:45','FJ-261001-0014','DP-03839','1816000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0015','2026-10-01','14:38:46','SAL','2175500','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-261001-0011','2026-10-01','2026-10-01 14:38:45','PENJUALAN : FJ-261001-0015','.','TBC','359500','359500','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-261001-0010','D','2026-10-01','14:38:46','TBC','PENJUALAN','FJ-261001-0015','28587440464','359500','28587799964','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='659500' WHERE no_faktur_jual='FJ-261001-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0015';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-01 ','15:28:55');
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-04307','VAN','1','PER','WEDDRING SEPAKET CP08','','','3.000','','925.00','1','100000','0','1600000','0','1600000','SIZE WANITA: 9 SIZE PRIA: 15','TANPA UKIR NAMA','FINISHING: 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-261001-0012','2026-10-01','2026-10-01 15:32:54','PESANAN : DP-04307','-','TBC','1600000','1600000');
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-261001-0011','D','2026-10-01','15:32:54','TBC','PESANAN','DP-04307','28587799964','1600000','28589399964','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-04307','2026-10-01','2026-10-01','15:32:54','PLG0016697','VAN','2026-10-25','sby','2026-10-01 15:32:54','3.000','0','0','0','1600000','0','0','1600000','1600000','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-261001-0016','kasirbip','1',' 750K-16-29','TOKO','BIPPER','PBDG-ZIBB-7-0','CINCIN SILVER 925 ','','2.020','1','100.00','207000','0','0','17800','900000','0','0','0','900000','KUR','00047440','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBB-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PBDG-ZIBB-7-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-261001-0016','2026-10-01','2.020','2026-10-01','15:33:55','PLG0016698','900000','900000','0','900000','0','kasirbip','2026-10-01 15:33:54','FJ-261001-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0016','2026-10-01','15:33:55','KUR','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-261001-0013','2026-10-01','2026-10-01 15:33:54','PENJUALAN : FJ-261001-0016','.','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-261001-0012','D','2026-10-01','15:33:55','TBC','PENJUALAN','FJ-261001-0016','28589399964','900000','28590299964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261001-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0017','kasirbip',' 1',' PLBDG-0014','TOKO','BIPPLD','PLBDG-ZACX-44-0','CINCIN PALADIUM PLBDG-00147 ','','2.420','1','17.00','544000','0','0','17800','1650000','0','0','0','1650000','KUR','00041258','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZACX-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PLBDG-ZACX-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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-261001-0017','2026-10-01','2.420','2026-10-01','15:33:55','PLG0016699','1650000','1650000','0','1650000','0','kasirbip','2026-10-01 15:33:54','FJ-261001-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0017','2026-10-01','15:33:55','KUR','1650000','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-261001-0014','2026-10-01','2026-10-01 15:33:54','PENJUALAN : FJ-261001-0017','.','TBC','1650000','1650000','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-261001-0013','D','2026-10-01','15:33:55','TBC','PENJUALAN','FJ-261001-0017','28590299964','1650000','28591949964','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='2550000' WHERE no_faktur_jual='FJ-261001-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0017';
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-261001-0018','jogja','1',' 750K-135-0','TOKO','JOGPER','PJOG-ZFAA-103-0','CINCIN SILVER 925 ','','1.990','1','100.00','203000','0','0','17800','850000','0','0','0','850000','DEW','00044302','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PJOG-ZFAA-103-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261001-0018','2026-10-01','1.990','2026-10-01','15:48:59','PLG0016700','850000','850000','0','850000','0','jogja','2026-10-01 15:48:58','FJ-261001-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0018','2026-10-01','15:48:59','DEW','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261001-0015','2026-10-01','2026-10-01 15:48:58','PENJUALAN : FJ-261001-0018','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0014','D','2026-10-01','15:48:59','TBC','PENJUALAN','FJ-261001-0018','28591949964','850000','28592799964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261001-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0018';
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-261001-0019','kasirbip','1',' DP-04112DU','TOKO','DUPSN','PSGT-ZICX-17-0','CINCIN EMAS ','','2.040','1','83.00','3973000','0','0','17800','5290000','0','0','0','5290000','PUT','00047803','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZICX-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSGT-ZICX-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0019','2026-10-01','2.040','2026-10-01','15:58:44','PLG0016701','5290000','5290000','0','5290000','0','kasirbip','2026-10-01 15:58:43','FJ-261001-0019','DP-04112','4160000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0019','2026-10-01','15:58:44','PUT','5290000','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-261001-0016','2026-10-01','2026-10-01 15:58:43','PENJUALAN : FJ-261001-0019','.','TBC','1130000','1130000','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-261001-0015','D','2026-10-01','15:58:44','TBC','PENJUALAN','FJ-261001-0019','28592799964','1130000','28593929964','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='1130000' WHERE no_faktur_jual='FJ-261001-0019' 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-261001-0020','kasirbip',' 1',' DP-04113DU','TOKO','DUPSN','PSPRT-ZICX-6-0','CINCIN PERAK ','','1.930','1','100.00','197000','0','0','17800','850000','0','0','0','850000','PUT','00047792','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZICX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZICX-6-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-261001-0020','2026-10-01','1.930','2026-10-01','15:58:44','PLG0016702','850000','850000','0','850000','0','kasirbip','2026-10-01 15:58:43','FJ-261001-0019','DP-04113','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0020','2026-10-01','15:58:44','PUT','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1130000' WHERE no_faktur_jual='FJ-261001-0020' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0020';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-01 ','16:03:18');
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-261001-0021','kasirbip','1',' DP-03857DU','TOKO','DUPSN','PSPRT-ZIBF-1-0','CINCIN PERAK YL10 ','','4.420','1','100.00','451000','0','0','17800','900000','0','0','0','900000','NAD','00047639','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBF-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.420',berat_jual_asli=berat_jual_asli+'4.420',stock_jual='1',berat_akhir=berat_akhir-'4.420',berat_akhir_asli=berat_akhir_asli-'4.420',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBF-1-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-261001-0021','2026-10-01','4.420','2026-10-01','16:07:24','PLG0016703','900000','900000','0','900000','0','kasirbip','2026-10-01 16:07:23','FJ-261001-0021','DP-03857','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0021','2026-10-01','16:07:24','NAD','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0021' 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-04308','DIL','1','PER','WEDD RING PRIA','','','4.000','','925.00','1','100000','0','900000','0','900000','PERMATA 1 BUTIR','SIZE 16','PUTIH DOFF','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261001-0017','2026-10-01','2026-10-01 16:08:21','PESANAN : DP-04308','-','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0016','D','2026-10-01','16:08:21','TBC','PESANAN','DP-04308','28593929964','900000','28594829964','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-04308','2026-10-01','2026-10-01','16:08:21','PLG0016704','DIL','2026-10-24','sby','2026-10-01 16:08:21','4.000','0','0','0','900000','0','0','900000','900000','0');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-01',  status ='CLOS' WHERE no_service='SV-02265';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02265';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-01 ','16:32:40');
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-261001-0022','kasirbip','1',' DP-03894DU','TOKO','DUPSN','PSPLT-ZIBI-28-0','CINCIN PALADIUM ','','2.600','1','32.00','1099000','0','0','17800','2180000','0','0','0','2180000','PUT','00047767','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBI-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPLT-ZIBI-28-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-261001-0022','2026-10-01','2.600','2026-10-01','16:33:56','PLG0016705','2180000','2180000','0','2180000','0','kasirbip','2026-10-01 16:33:56','FJ-261001-0022','DP-03894','1700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0022','2026-10-01','16:33:56','PUT','2180000','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-261001-0018','2026-10-01','2026-10-01 16:33:56','PENJUALAN : FJ-261001-0022','.','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-261001-0017','D','2026-10-01','16:33:56','TBC','PENJUALAN','FJ-261001-0022','28594829964','480000','28595309964','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='480000' WHERE no_faktur_jual='FJ-261001-0022' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0022';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-01 ','16:38:18');
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-20261001-0003','1','PSPLT-ZIBI-29-0','1','4.120','4.120','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBI-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBI-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBI-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBI-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 16:44:02' WHERE kode_barang='PSPLT-ZIBI-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBI-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 16:44:02','TOKO','SBYPSN','PSPLT','PSPLT-ZIBI-29-0','1','4.120','4.120','1','4.120','4.120','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIBI-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBI-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0003','1','PSPLT-ZIBI-30-0','1','3.360','3.360','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBI-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBI-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBI-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBI-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 16:44:02' WHERE kode_barang='PSPLT-ZIBI-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBI-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 16:44:02','TOKO','SBYPSN','PSPLT','PSPLT-ZIBI-30-0','1','3.360','3.360','1','3.360','3.360','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIBI-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBI-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0003','1','PSPLT-ZIBI-31-0','1','3.940','3.940','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBI-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBI-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBI-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBI-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 16:44:02' WHERE kode_barang='PSPLT-ZIBI-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBI-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 16:44:02','TOKO','SBYPSN','PSPLT','PSPLT-ZIBI-31-0','1','3.940','3.940','1','3.940','3.940','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIBI-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBI-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0003','1','PSPRT-ZIBI-44-0','1','2.000','2.000','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBI-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBI-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBI-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBI-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 16:44:02' WHERE kode_barang='PSPRT-ZIBI-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBI-44-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 16:44:02','TOKO','SBYPSN','PSPRT','PSPRT-ZIBI-44-0','1','2.000','2.000','1','2.000','2.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIBI-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBI-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0003','1','PSPRT-ZIBI-45-0','1','1.520','1.520','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBI-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBI-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBI-45-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBI-45-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 16:44:02' WHERE kode_barang='PSPRT-ZIBI-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBI-45-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 16:44:02','TOKO','SBYPSN','PSPRT','PSPRT-ZIBI-45-0','1','1.520','1.520','1','1.520','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIBI-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBI-45-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0003','1','PSPRT-ZIBI-46-0','1','1.810','1.810','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBI-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBI-46-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBI-46-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBI-46-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 16:44:02' WHERE kode_barang='PSPRT-ZIBI-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBI-46-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 16:44:02','TOKO','SBYPSN','PSPRT','PSPRT-ZIBI-46-0','1','1.810','1.810','1','1.810','1.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIBI-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBI-46-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0003','1','PSGT-ZIBI-47-0','1','2.250','2.250','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBI-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBI-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBI-47-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBI-47-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 16:44:02' WHERE kode_barang='PSGT-ZIBI-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBI-47-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 16:44:02','TOKO','SBYPSN','PSGT','PSGT-ZIBI-47-0','1','2.250','2.250','1','2.250','2.250','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-ZIBI-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBI-47-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261001-0003','2026-10-01','16:41','19.000','sby','2026-10-01 16:44:02');
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-04309','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','850000','0','850000','sz cwe 21.5 grf Silvia .... Nadi','sz cwo 12.5 grf Nadi .... Silvia','font Berkshire','100000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261001-0019','2026-10-01','2026-10-01 17:05:22','PESANAN : DP-04309','.','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-261001-0018','D','2026-10-01','17:05:22','TBC','PESANAN','DP-04309','28595309964','950000','28596259964','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-04309','2026-10-01','2026-10-01','17:05:22','PLG0016706','PUT','2026-10-20','kasirbip','2026-10-01 17:05:22','4.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0023','kasirbip','1',' DP-03419BI','TOKO','BIPPSN','PSPRT-ZIXH-9-0','1PS CINCIN PERAK ','','3.260','1','100.00','333000','0','0','17800','1500000','0','0','0','1500000','SAL','00047022','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXH-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.260',berat_jual_asli=berat_jual_asli+'3.260',stock_jual='1',berat_akhir=berat_akhir-'3.260',berat_akhir_asli=berat_akhir_asli-'3.260',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIXH-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0023','2026-10-01','3.260','2026-10-01','17:10:06','PLG0016707','1500000','1500000','0','1500000','0','kasirbip','2026-10-01 17:10:06','FJ-261001-0023','DP-03419','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0023','2026-10-01','17:10:06','SAL','1500000','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-261001-0023' 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-261001-0024','sby','1',' 750K-155-0','TOKO','SBYPER','PSBY-ZGBB-36-0','CINCIN SILVER 925 ','','2.130','1','100.00','218000','0','0','17800','850000','0','0','0','850000','VAN','00045527','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSBY-ZGBB-36-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-261001-0024','2026-10-01','2.130','2026-10-01','17:17:25','PLG0016708','850000','850000','0','850000','0','sby','2026-10-01 17:17:24','FJ-261001-0024','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0024','2026-10-01','17:17:25','VAN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261001-0020','2026-10-01','2026-10-01 17:17:24','PENJUALAN : FJ-261001-0024','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0019','D','2026-10-01','17:17:25','TBC','PENJUALAN','FJ-261001-0024','28596259964','850000','28597109964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261001-0024' 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-261001-0025','sby','1',' DP-03750SB','TOKO','SBYPSN','PSPRT-ZIBB-41-0','CINCIN PERAK ','','2.450','1','100.00','251000','0','0','17800','850000','0','0','0','850000','DIL','00047474','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBB-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBB-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0025','2026-10-01','2.450','2026-10-01','17:41:47','PLG0016709','850000','850000','0','850000','0','sby','2026-10-01 17:41:47','FJ-261001-0025','DP-03750','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0025','2026-10-01','17:41:47','DIL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0025' 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-261001-0026','sby',' 1',' DP-03751SB','TOKO','SBYPSN','PSPLT-ZIBC-45-0','CINCIN PALADIUM ','','1.610','1','17.00','362000','0','0','17800','1484000','0','0','0','1484000','DIL','00047524','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBC-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPLT-ZIBC-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0026','2026-10-01','1.610','2026-10-01','17:41:47','PLG0016710','1484000','1484000','0','1484000','0','sby','2026-10-01 17:41:47','FJ-261001-0025','DP-03751','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0026','2026-10-01','17:41:47','DIL','1484000','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-261001-0021','2026-10-01','2026-10-01 17:41:47','PENJUALAN : FJ-261001-0026','','TBC','284000','284000','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-261001-0020','D','2026-10-01','17:41:47','TBC','PENJUALAN','FJ-261001-0026','28597109964','284000','28597393964','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='284000' WHERE no_faktur_jual='FJ-261001-0026' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261001-0004','1','PSPRT-ZICX-9-0','1','2.950','2.950','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 17:43:41' WHERE kode_barang='PSPRT-ZICX-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 17:43:41','TOKO','SBYPSN','PSPRT','PSPRT-ZICX-9-0','1','2.950','2.950','1','2.950','2.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0004','1','PSGT-ZICX-18-0','1','2.640','2.640','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZICX-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZICX-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZICX-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 17:43:41' WHERE kode_barang='PSGT-ZICX-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZICX-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 17:43:41','TOKO','SBYPSN','PSGT','PSGT-ZICX-18-0','1','2.640','2.640','1','2.640','2.640','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-ZICX-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0004','1','PSGT-ZICX-19-0','1','1.850','1.850','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZICX-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZICX-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZICX-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 17:43:41' WHERE kode_barang='PSGT-ZICX-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZICX-19-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 17:43:41','TOKO','SBYPSN','PSGT','PSGT-ZICX-19-0','1','1.850','1.850','1','1.850','1.850','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-ZICX-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0004','1','PSPRT-ZICX-20-0','1','4.580','4.580','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-01 17:43:41' WHERE kode_barang='PSPRT-ZICX-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 17:43:41','TOKO','SBYPSN','PSPRT','PSPRT-ZICX-20-0','1','4.580','4.580','1','4.580','4.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261001-0004','2026-10-01','17:42','12.020','sby','2026-10-01 17:43:40');
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-261001-0027','kasirbip','1',' DP-03998BI','TOKO','BIPPSN','PSPRT-ZIBI-34-0','CINCIN PERAK SR03 YL01 ','','3.400','1','100.00','347000','0','0','17800','950000','0','0','0','950000','KUR','00047773','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBI-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0027','2026-10-01','3.400','2026-10-01','17:45:58','PLG0016711','950000','950000','0','950000','0','kasirbip','2026-10-01 17:45:57','FJ-261001-0027','DP-03998','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0027','2026-10-01','17:45:58','KUR','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0027';
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-261001-0028','kasirbip','1',' DP-03942DU','TOKO','DUPSN','PSGT-ZICX-13-0','CINCIN EMAS ','','1.700','1','45.00','1795000','0','0','17800','3080000','0','0','0','3080000','NAD','00047799','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZICX-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSGT-ZICX-13-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-261001-0028','2026-10-01','1.700','2026-10-01','18:15:17','PLG0016712','3080000','3080000','0','3080000','0','kasirbip','2026-10-01 18:15:17','FJ-261001-0028','DP-03942','2800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0028','2026-10-01','18:15:17','NAD','3080000','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-261001-0022','2026-10-01','2026-10-01 18:15:17','PENJUALAN : FJ-261001-0028','.','TBC','280000','280000','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-261001-0021','D','2026-10-01','18:15:17','TBC','PENJUALAN','FJ-261001-0028','28597393964','280000','28597673964','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='280000' WHERE no_faktur_jual='FJ-261001-0028' 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-261001-0029','kasirbip',' 1',' DP-03932DU','TOKO','DUPSN','PSPRT-ZIBI-40-0','CINCIN PERAK ','','1.940','1','100.00','198000','0','0','17800','850000','0','0','0','850000','NAD','00047779','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBI-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0029','2026-10-01','1.940','2026-10-01','18:15:17','PLG0016713','850000','850000','0','850000','0','kasirbip','2026-10-01 18:15:17','FJ-261001-0028','DP-03932','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0029','2026-10-01','18:15:17','NAD','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='280000' WHERE no_faktur_jual='FJ-261001-0029' 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-261001-0030','kasirbip','1',' DP-03774BI','TOKO','BIPPSN','PSPRT-ZIBC-33-0','CINCIN PERAK YL01 ','','1.770','1','100.00','181000','0','0','17800','600000','0','0','0','600000','SAL','00047512','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBC-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBC-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0030','2026-10-01','1.770','2026-10-01','18:25:40','PLG0016714','600000','600000','0','600000','0','kasirbip','2026-10-01 18:25:40','FJ-261001-0030','DP-03774','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-10-01','FJ-261001-0030','2026-10-01','18:25:40','SAL','600000','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-261001-0030' 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-261001-0031','kasirbip',' 1',' DP-03773BI','TOKO','BIPPSN','PSPRT-ZIBI-7-0','CINCIN PERAK ','','1.610','1','100.00','165000','0','0','17800','1000000','0','0','0','1000000','SAL','00047746','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBI-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0031','2026-10-01','1.610','2026-10-01','18:25:40','PLG0016715','1000000','1000000','0','1000000','0','kasirbip','2026-10-01 18:25:40','FJ-261001-0030','DP-03773','1000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0031','2026-10-01','18:25:40','SAL','1000000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0031' 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-261001-0032','kasirbip','1',' DP-03939DU','TOKO','DUPSN','PSPRT-ZICX-16-0','CINCIN PERAK CM03 YL01 ','','3.450','1','100.00','352000','0','0','17800','1200000','0','0','0','1200000','NAD','00047802','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZICX-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.450',berat_jual_asli=berat_jual_asli+'3.450',stock_jual='1',berat_akhir=berat_akhir-'3.450',berat_akhir_asli=berat_akhir_asli-'3.450',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZICX-16-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-261001-0032','2026-10-01','3.450','2026-10-01','18:30:29','PLG0016716','1200000','1200000','0','1200000','0','kasirbip','2026-10-01 18:30:29','FJ-261001-0032','DP-03939','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0032','2026-10-01','18:30:29','NAD','1200000','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-261001-0032' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-01 ','18:32:03');
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-04310','ASRI','1','PER','PROMO SILVER 850','','','3.000','','925.00','1','100000','0','0','0','850000','cewe size 11.5 grf Ramot crom kuning','cowo size 23 grf Rosena crom kuning doff amplas','up size 100k dan expres 100k','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-261001-0023','2026-10-01','2026-10-01 18:42:01','PESANAN : DP-04310','.','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-261001-0022','D','2026-10-01','18:42:01','TBC','PESANAN','DP-04310','28597673964','850000','28598523964','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-04310','2026-10-01','2026-10-01','18:42:01','PLG0016717','ASRI','2026-10-14','kasir','2026-10-01 18:42:01','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tm_credit_card SET nama_customer='-',no_ktp='',alamat1='' ,alamat2='' ,kota= '' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-10-01 18:57:15' WHERE id_card = '-';
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-261001-0033','sby','1',' DP-03891SB','TOKO','SBYPSN','PSPLT-ZIBH-57-0','CINCIN PALADIUM YL01 ','','3.600','1','17.00','808000','0','0','17800','1960000','0','0','0','1960000','DIL','00047721','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBH-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.600',berat_jual_asli=berat_jual_asli+'3.600',stock_jual='1',berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPLT-ZIBH-57-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0033','2026-10-01','3.600','2026-10-01','18:57:21','PLG0016718','1960000','1960000','0','1960000','0','sby','2026-10-01 18:57:20','FJ-261001-0033','DP-03891','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0033','2026-10-01','18:57:21','DIL','1960000','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-261001-0024','2026-10-01','2026-10-01 18:57:20','PENJUALAN : FJ-261001-0033','','TBC','560000','560000','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-261001-0023','D','2026-10-01','18:57:21','TBC','PENJUALAN','FJ-261001-0033','28598523964','560000','28599083964','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='560000' WHERE no_faktur_jual='FJ-261001-0033' 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-261001-0034','kasirbip','1',' DP-03844BI','TOKO','BIPPSN','PSGT-ZIBI-6-0','CINCIN EMAS ','','2.140','1','45.00','2260000','0','0','17800','3956000','0','0','0','3956000','SAL','00047745','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBI-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSGT-ZIBI-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0034','2026-10-01','2.140','2026-10-01','18:58:33','PLG0016719','3956000','3956000','0','3956000','0','kasirbip','2026-10-01 18:58:33','FJ-261001-0034','DP-03844','3568000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0034','2026-10-01','18:58:33','SAL','3956000','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-261001-0025','2026-10-01','2026-10-01 18:58:33','PENJUALAN : FJ-261001-0034','.','TBC','388000','388000','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-261001-0024','D','2026-10-01','18:58:33','TBC','PENJUALAN','FJ-261001-0034','28599083964','388000','28599471964','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='388000' WHERE no_faktur_jual='FJ-261001-0034' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0030';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0034';
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-20261001-0005','1','PSGT-ZICX-1-0','1','2.240','2.240','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZICX-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZICX-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZICX-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-01 19:16:26' WHERE kode_barang='PSGT-ZICX-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZICX-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 19:16:26','TOKO','JOGPSN','PSGT','PSGT-ZICX-1-0','1','2.240','2.240','1','2.240','2.240','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-ZICX-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZICX-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0005','1','PSPRT-ZICX-2-0','1','3.470','3.470','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-01 19:16:26' WHERE kode_barang='PSPRT-ZICX-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 19:16:26','TOKO','JOGPSN','PSPRT','PSPRT-ZICX-2-0','1','3.470','3.470','1','3.470','3.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0005','1','PSPRT-ZICX-10-0','1','2.160','2.160','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-01 19:16:26' WHERE kode_barang='PSPRT-ZICX-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 19:16:26','TOKO','JOGPSN','PSPRT','PSPRT-ZICX-10-0','1','2.160','2.160','1','2.160','2.160','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0005','1','PSPRT-ZICX-11-0','1','1.530','1.530','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-01 19:16:26' WHERE kode_barang='PSPRT-ZICX-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 19:16:26','TOKO','JOGPSN','PSPRT','PSPRT-ZICX-11-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0005','1','PSPRT-ZICX-21-0','1','2.190','2.190','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZICX-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZICX-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZICX-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-01 19:16:26' WHERE kode_barang='PSPRT-ZICX-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZICX-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 19:16:26','TOKO','JOGPSN','PSPRT','PSPRT-ZICX-21-0','1','2.190','2.190','1','2.190','2.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZICX-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZICX-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0005','1','PSPLT-ZICX-22-0','1','2.420','2.420','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZICX-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZICX-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZICX-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-01 19:16:26' WHERE kode_barang='PSPLT-ZICX-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZICX-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 19:16:26','TOKO','JOGPSN','PSPLT','PSPLT-ZICX-22-0','1','2.420','2.420','1','2.420','2.420','57.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-ZICX-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' 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-20261001-0005','1','PSPLT-ZICX-23-0','1','4.250','4.250','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZICX-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZICX-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZICX-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-01 19:16:26' WHERE kode_barang='PSPLT-ZICX-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZICX-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-01 19:16:26','TOKO','JOGPSN','PSPLT','PSPLT-ZICX-23-0','1','4.250','4.250','1','4.250','4.250','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZICX-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZICX-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-01' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261001-0005','2026-10-01','18:51','18.260','jogja','2026-10-01 19:16:25');
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-261001-0035','sby','1',' DP-04173SB','TOKO','SBYPSN','PSPLT-ZIBI-29-0','CINCIN PALADIUM ','','4.120','1','32.00','1741000','0','0','17800','3026000','0','0','0','3026000','VAN','00047768','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBI-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.120',berat_jual_asli=berat_jual_asli+'4.120',stock_jual='1',berat_akhir=berat_akhir-'4.120',berat_akhir_asli=berat_akhir_asli-'4.120',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPLT-ZIBI-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0035','2026-10-01','4.120','2026-10-01','19:39:28','PLG0016720','3026000','3026000','0','3026000','0','sby','2026-10-01 19:39:28','FJ-261001-0035','DP-04173','2000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0035','2026-10-01','19:39:28','VAN','3026000','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-261001-0026','2026-10-01','2026-10-01 19:39:28','PENJUALAN : FJ-261001-0035','','TBC','1026000','1026000','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-261001-0025','D','2026-10-01','19:39:28','TBC','PENJUALAN','FJ-261001-0035','28599471964','1026000','28600497964','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='1026000' WHERE no_faktur_jual='FJ-261001-0035' 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-04311','DIL','1','PER','WEDD RING PRIA','','','4.000','','925.00','1','100000','0','850000','0','850000','SIZE 20','PUTIH GLOSSY MIX DOFF','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261001-0027','2026-10-01','2026-10-01 19:53:24','PESANAN : DP-04311','-','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-261001-0026','D','2026-10-01','19:53:24','TBC','PESANAN','DP-04311','28600497964','850000','28601347964','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-04311','2026-10-01','2026-10-01','19:53:24','PLG0016721','DIL','2026-10-24','sby','2026-10-01 19:53:24','4.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-261001-0036','kasirbip','1',' DP-03681DU','TOKO','DUPSN','PSPRT-ZIBB-39-0','CINCIN PERAK ','','2.720','1','100.00','278000','0','0','17800','850000','0','0','0','850000','NAD','00047472','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBB-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBB-39-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-261001-0036','2026-10-01','2.720','2026-10-01','19:59:53','PLG0016722','850000','850000','0','850000','0','kasirbip','2026-10-01 19:59:52','FJ-261001-0036','DP-03681','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0036','2026-10-01','19:59:53','NAD','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0036' 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-261001-0037','kasirbip',' 1',' DP-03683DU','TOKO','DUPSN','PSPRT-ZIBB-32-0','CINCIN PERAK YL10 ','','4.900','1','100.00','501000','0','0','17800','900000','0','0','0','900000','NAD','00047465','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBB-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.900',berat_jual_asli=berat_jual_asli+'4.900',stock_jual='1',berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPRT-ZIBB-32-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-261001-0037','2026-10-01','4.900','2026-10-01','19:59:53','PLG0016723','900000','900000','0','900000','0','kasirbip','2026-10-01 19:59:52','FJ-261001-0036','DP-03683','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0037','2026-10-01','19:59:53','NAD','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261001-0037' 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-261001-0038','jogja','1',' 750K-12-00','TOKO','JOGPER','PJOG-ZFAA-58-0','CINCIN SILVER 925 ','','1.830','1','100.00','187000','0','0','17800','900000','0','0','0','900000','DEW','00044257','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PJOG-ZFAA-58-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261001-0038','2026-10-01','1.830','2026-10-01','20:01:17','PLG0016724','900000','900000','0','900000','0','jogja','2026-10-01 20:01:16','FJ-261001-0038','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0038','2026-10-01','20:01:17','DEW','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-261001-0028','2026-10-01','2026-10-01 20:01:16','PENJUALAN : FJ-261001-0038','','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-261001-0027','D','2026-10-01','20:01:17','TBC','PENJUALAN','FJ-261001-0038','28601347964','900000','28602247964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261001-0038' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0038' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0038' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0038';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0037' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0037' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0037';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0036' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0036' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0036';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0035' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261001-0035' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261001-0035';
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-04312','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1050000','0','1050000','sz 12 putih glossy 18 zirkon','font berkshire swash grf Iqbal 29.11.26','model persis sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261001-0029','2026-10-01','2026-10-01 20:16:50','PESANAN : DP-04312','.','TBC','1050000','1050000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0028','D','2026-10-01','20:16:50','TBC','PESANAN','DP-04312','28602247964','1050000','28603297964','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-04312','2026-10-01','2026-10-01','20:16:50','PLG0016725','SAL','2026-10-22','kasirbip','2026-10-01 20:16:50','3.000','0','0','0','1050000','0','0','1050000','1050000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04313','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 18 putih doff amplas','font berkshire swash grf Selvi 29.11.26','model persis sprt contoh lebar dan tebalnya','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-261001-0030','2026-10-01','2026-10-01 20:18:19','PESANAN : DP-04313','.','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261001-0029','D','2026-10-01','20:18:19','TBC','PESANAN','DP-04313','28603297964','900000','28604197964','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-04313','2026-10-01','2026-10-01','20:18:19','PLG0016726','SAL','2026-10-22','kasirbip','2026-10-01 20:18:19','3.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-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-10-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-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-261002-0001','D','2026-10-02','21:08:02','TBC','SALDO AWAL','SALDO AWAL','0','28604197964','28604197964');
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-261002-0001','D','2026-10-02','21:08:02','BCD','SALDO AWAL','SALDO AWAL','0','1464137500','1464137500');
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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','','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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','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-261002-0001','D','2026-10-02','21:08:02','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
UPDATE tp_system SET tgl_system='2026-10-02';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261001-0039','sby','1',' DP-03918SB','TOKO','SBYPSN','PSPLT-ZIBF-15-0','CINCIN PALADIUM ','','2.600','1','17.00','584000','0','0','17800','2220000','0','0','0','2220000','VAN','00047653','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBF-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-10-01' AND kode_barang='PSPLT-ZIBF-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261001-0039','2026-10-01','2.600','2026-10-01','21:37:20','PLG0016727','2220000','2220000','0','2220000','0','sby','2026-10-01 21:37:20','FJ-261001-0039','DP-03918','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-01','FJ-261001-0039','2026-10-01','21:37:20','VAN','2220000','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-261001-0031','2026-10-01','2026-10-01 21:37:20','PENJUALAN : FJ-261001-0039','','TBC','1020000','1020000','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-261001-0001','D','2026-10-01','21:37:20','TBC','PENJUALAN','FJ-261001-0039','0','1020000','1020000','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='1020000' WHERE no_faktur_jual='FJ-261001-0039' LIMIT 1;