INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','08:27:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-04 ','08:27:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','08:28:24');
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-20260604-0002','1','TFC-ZFXC-8-0','1','2.420','2.420','TOKO','TFC','TOKO','TFCBR');
DELETE FROM tm_barang WHERE kode_barang='TFC-ZFXC-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZFXC-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-ZFXC-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZFXC-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-06-04 08:28:42' WHERE kode_barang='TFC-ZFXC-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZFXC-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-04 08:28:42','TOKO','TFCBR','TFC','TFC-ZFXC-8-0','1','2.420','2.420','1','2.420','2.420','83.00');
DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-ZFXC-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZFXC-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-06-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260604-0002','2026-06-04','08:28','2.420','kasir','2026-06-04 08:28:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','08:33:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-04 ','08:52:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','08:53:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-04 ','08:58:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','09:08:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','10:05:53');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260603-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260603-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','10:21:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','10:47:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','10:54:06');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02115','SAL','1','SEPASANG WED RING SILVER','GRF','3.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02115','2026-06-04','2026-06-04','12:53:03','PLG0011742','kasirbip','2026-06-19','kasirbip','2026-06-04 12:53:03','3.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260604-0001','kasir','1',' TFGRP75-84','TOKO','TFGLR','TFGRP-YLXD-79-0','THIFA GELANG RANTAI PUTIH ','','1.770','1','84.00','3671000','0','0','17800','3750000','0','0','0','3750000','FIR','00040259','TFGRP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRP-YLXD-79-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-06-04' AND kode_barang='TFGRP-YLXD-79-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260604-0001','2026-06-04','1.770','2026-06-04','13:03:48','PLG0011743','3750000','3750000','0','3750000','0','kasir','2026-06-04 13:03:48','FJ-260604-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-06-04','FJ-260604-0001','2026-06-04','13:03:48','FIR','3750000','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-260604-0017','2026-06-04','2026-06-04 13:03:48','PENJUALAN : FJ-260604-0001','.','TBC','3750000','3750000','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-260604-0018','D','2026-06-04','13:03:48','TBC','PENJUALAN','FJ-260604-0001','23289358014','3750000','23293108014','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='3750000' WHERE no_faktur_jual='FJ-260604-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-260604-0002','kasir','1',' BDC-00109 ','TOKO','TFCBR','BDC-YBBE-18-0','CINCIN BDC-00109','','1.180','1','83.00','3823000','953000','54','17800','5600000','0','0','0','5600000','FIR','00034371','BDC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDC-YBBE-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='BDC-YBBE-18-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-260604-0002','2026-06-04','1.180','2026-06-04','13:09:33','PLG0011744','5600000','5600000','0','5600000','0','kasir','2026-06-04 13:09:33','FJ-260604-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0002','2026-06-04','13:09:33','FIR','5600000','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-260604-0018','2026-06-04','2026-06-04 13:09:33','PENJUALAN : FJ-260604-0002','.','TBC','5600000','5600000','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-260604-0019','D','2026-06-04','13:09:33','TBC','PENJUALAN BERLIAN','FJ-260604-0002','23293108014','5600000','23298708014','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='5600000' WHERE no_faktur_jual='FJ-260604-0002' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','13:09:12');
UPDATE tp_curr SET rp= '18100.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '18100.00', 'kasir','2026-06-04 13:09:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','13:10:54');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0002';
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8672000',harga_beli ='8672000' WHERE kode_barcode='00017312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7831500',harga_beli ='7831500' WHERE kode_barcode='00017383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8590000',harga_beli ='8590000' WHERE kode_barcode='00017542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5802000',harga_beli ='5802000' WHERE kode_barcode='00017624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9307500',harga_beli ='9307500' WHERE kode_barcode='00017626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9123000',harga_beli ='9123000' WHERE kode_barcode='00017628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7380500',harga_beli ='7380500' WHERE kode_barcode='00017636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5207500',harga_beli ='5207500' WHERE kode_barcode='00017662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6294000',harga_beli ='6294000' WHERE kode_barcode='00017663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12280500',harga_beli ='12280500' WHERE kode_barcode='00017681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12096000',harga_beli ='12096000' WHERE kode_barcode='00017697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5720000',harga_beli ='5720000' WHERE kode_barcode='00017698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5904500',harga_beli ='5904500' WHERE kode_barcode='00017717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3014000',harga_beli ='3014000' WHERE kode_barcode='00017759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2973000',harga_beli ='2973000' WHERE kode_barcode='00017760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12526500',harga_beli ='12526500' WHERE kode_barcode='00017900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='48423500',harga_beli ='48423500' WHERE kode_barcode='00017913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4203000',harga_beli ='4203000' WHERE kode_barcode='00017959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8200500',harga_beli ='8200500' WHERE kode_barcode='00017982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12424000',harga_beli ='12424000' WHERE kode_barcode='00018019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8559000',harga_beli ='8559000' WHERE kode_barcode='00018036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6335000',harga_beli ='6335000' WHERE kode_barcode='00018073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='18984000',harga_beli ='18984000' WHERE kode_barcode='00018112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6929500',harga_beli ='6929500' WHERE kode_barcode='00018284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7011500',harga_beli ='7011500' WHERE kode_barcode='00018285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5638000',harga_beli ='5638000' WHERE kode_barcode='00018302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2788500',harga_beli ='2788500' WHERE kode_barcode='00018312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2747500',harga_beli ='2747500' WHERE kode_barcode='00018337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9123000',harga_beli ='9123000' WHERE kode_barcode='00018371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9594500',harga_beli ='9594500' WHERE kode_barcode='00018463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13346500',harga_beli ='13346500' WHERE kode_barcode='00018491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5433000',harga_beli ='5433000' WHERE kode_barcode='00018517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5925000',harga_beli ='5925000' WHERE kode_barcode='00018519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7366000',harga_beli ='7366000' WHERE kode_barcode='00018718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4162000',harga_beli ='4162000' WHERE kode_barcode='00018891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4961500',harga_beli ='4961500' WHERE kode_barcode='00018924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3895500',harga_beli ='3895500' WHERE kode_barcode='00018925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4121000',harga_beli ='4121000' WHERE kode_barcode='00018937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4182500',harga_beli ='4182500' WHERE kode_barcode='00019018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10169000',harga_beli ='10169000' WHERE kode_barcode='00019120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='00019123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3998000',harga_beli ='3998000' WHERE kode_barcode='00019148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5064000',harga_beli ='5064000' WHERE kode_barcode='00019153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7134500',harga_beli ='7134500' WHERE kode_barcode='00019234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5392000',harga_beli ='5392000' WHERE kode_barcode='00019236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7155000',harga_beli ='7155000' WHERE kode_barcode='00019283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8815500',harga_beli ='8815500' WHERE kode_barcode='00019360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4490000',harga_beli ='4490000' WHERE kode_barcode='00019451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5207500',harga_beli ='5207500' WHERE kode_barcode='00019510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6765500',harga_beli ='6765500' WHERE kode_barcode='00019562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6417000',harga_beli ='6417000' WHERE kode_barcode='00019563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6130000',harga_beli ='6130000' WHERE kode_barcode='00019564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8323500',harga_beli ='8323500' WHERE kode_barcode='00019652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6499000',harga_beli ='6499000' WHERE kode_barcode='00019655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4531000',harga_beli ='4531000' WHERE kode_barcode='00019656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9635500',harga_beli ='9635500' WHERE kode_barcode='00019742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4080000',harga_beli ='4080000' WHERE kode_barcode='00019840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5863500',harga_beli ='5863500' WHERE kode_barcode='00019911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6212000',harga_beli ='6212000' WHERE kode_barcode='00020018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7298500',harga_beli ='7298500' WHERE kode_barcode='00020068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6888500',harga_beli ='6888500' WHERE kode_barcode='00020069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7114000',harga_beli ='7114000' WHERE kode_barcode='00020070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6519500',harga_beli ='6519500' WHERE kode_barcode='00020071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7790500',harga_beli ='7790500' WHERE kode_barcode='00020074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6847500',harga_beli ='6847500' WHERE kode_barcode='00020075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7052500',harga_beli ='7052500' WHERE kode_barcode='00020076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5638000',harga_beli ='5638000' WHERE kode_barcode='00020077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6765500',harga_beli ='6765500' WHERE kode_barcode='00020080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6642500',harga_beli ='6642500' WHERE kode_barcode='00020166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8118500',harga_beli ='8118500' WHERE kode_barcode='00020168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5884000',harga_beli ='5884000' WHERE kode_barcode='00020179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6007000',harga_beli ='6007000' WHERE kode_barcode='00020186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8139000',harga_beli ='8139000' WHERE kode_barcode='00020191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5966000',harga_beli ='5966000' WHERE kode_barcode='00020200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='47202000',harga_beli ='47202000' WHERE kode_barcode='00020223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6519500',harga_beli ='6519500' WHERE kode_barcode='00020259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7114000',harga_beli ='7114000' WHERE kode_barcode='00020365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4879500',harga_beli ='4879500' WHERE kode_barcode='00020492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5822500',harga_beli ='5822500' WHERE kode_barcode='00020616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='00020834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5494500',harga_beli ='5494500' WHERE kode_barcode='00020846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7872500',harga_beli ='7872500' WHERE kode_barcode='00021113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8877000',harga_beli ='8877000' WHERE kode_barcode='00021253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6478500',harga_beli ='6478500' WHERE kode_barcode='00021254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6232500',harga_beli ='6232500' WHERE kode_barcode='00021280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9164000',harga_beli ='9164000' WHERE kode_barcode='00021405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5317000',harga_beli ='5317000' WHERE kode_barcode='00021475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4279500',harga_beli ='4279500' WHERE kode_barcode='00021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='24638500',harga_beli ='24638500' WHERE kode_barcode='00021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13642000',harga_beli ='13642000' WHERE kode_barcode='00021506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9803500',harga_beli ='9803500' WHERE kode_barcode='00021585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3942500',harga_beli ='3942500' WHERE kode_barcode='00021609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11282000',harga_beli ='11282000' WHERE kode_barcode='00021630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8403000',harga_beli ='8403000' WHERE kode_barcode='00021635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6294000',harga_beli ='6294000' WHERE kode_barcode='00021755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8610500',harga_beli ='8610500' WHERE kode_barcode='00021756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6683500',harga_beli ='6683500' WHERE kode_barcode='00021758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8877000',harga_beli ='8877000' WHERE kode_barcode='00021759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5515000',harga_beli ='5515000' WHERE kode_barcode='00021781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9635500',harga_beli ='9635500' WHERE kode_barcode='00021782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7975000',harga_beli ='7975000' WHERE kode_barcode='00021783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='15950000',harga_beli ='15950000' WHERE kode_barcode='00021815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11399000',harga_beli ='11399000' WHERE kode_barcode='00021835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12608500',harga_beli ='12608500' WHERE kode_barcode='00021844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4176000',harga_beli ='4176000' WHERE kode_barcode='00021867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4176000',harga_beli ='4176000' WHERE kode_barcode='00021876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4876000',harga_beli ='4876000' WHERE kode_barcode='00021878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='14945500',harga_beli ='14945500' WHERE kode_barcode='00021882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11399000',harga_beli ='11399000' WHERE kode_barcode='00021905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5002500',harga_beli ='5002500' WHERE kode_barcode='00021976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6089000',harga_beli ='6089000' WHERE kode_barcode='00021977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5638000',harga_beli ='5638000' WHERE kode_barcode='00021979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5351000',harga_beli ='5351000' WHERE kode_barcode='00021980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6806500',harga_beli ='6806500' WHERE kode_barcode='00022044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5966000',harga_beli ='5966000' WHERE kode_barcode='00022045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7688000',harga_beli ='7688000' WHERE kode_barcode='00022046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5494500',harga_beli ='5494500' WHERE kode_barcode='00022071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6294000',harga_beli ='6294000' WHERE kode_barcode='00022114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7667500',harga_beli ='7667500' WHERE kode_barcode='00022140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5945500',harga_beli ='5945500' WHERE kode_barcode='00022141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5617500',harga_beli ='5617500' WHERE kode_barcode='00022142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5556000',harga_beli ='5556000' WHERE kode_barcode='00022143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10661000',harga_beli ='10661000' WHERE kode_barcode='00022144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7106500',harga_beli ='7106500' WHERE kode_barcode='00022173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9311000',harga_beli ='9311000' WHERE kode_barcode='00022174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10167000',harga_beli ='10167000' WHERE kode_barcode='00022176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7366000',harga_beli ='7366000' WHERE kode_barcode='00022180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7314000',harga_beli ='7314000' WHERE kode_barcode='00022227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10476500',harga_beli ='10476500' WHERE kode_barcode='00022322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13694000',harga_beli ='13694000' WHERE kode_barcode='00022356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7524000',harga_beli ='7524000' WHERE kode_barcode='00022433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7340000',harga_beli ='7340000' WHERE kode_barcode='00022442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5166500',harga_beli ='5166500' WHERE kode_barcode='00022450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5556000',harga_beli ='5556000' WHERE kode_barcode='00022468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8385000',harga_beli ='8385000' WHERE kode_barcode='00022517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='19088500',harga_beli ='19088500' WHERE kode_barcode='00022649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5887500',harga_beli ='5887500' WHERE kode_barcode='00022758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7392000',harga_beli ='7392000' WHERE kode_barcode='00022759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7910500',harga_beli ='7910500' WHERE kode_barcode='00022765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11904500',harga_beli ='11904500' WHERE kode_barcode='00022774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10945000',harga_beli ='10945000' WHERE kode_barcode='00022806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7236000',harga_beli ='7236000' WHERE kode_barcode='00022808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9726000',harga_beli ='9726000' WHERE kode_barcode='00022809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9259000',harga_beli ='9259000' WHERE kode_barcode='00022867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7210000',harga_beli ='7210000' WHERE kode_barcode='00022883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3875000',harga_beli ='3875000' WHERE kode_barcode='00022912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5535500',harga_beli ='5535500' WHERE kode_barcode='00022950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7421500',harga_beli ='7421500' WHERE kode_barcode='00023060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9388500',harga_beli ='9388500' WHERE kode_barcode='00023123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5166500',harga_beli ='5166500' WHERE kode_barcode='00023126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9717500',harga_beli ='9717500' WHERE kode_barcode='00023146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6642500',harga_beli ='6642500' WHERE kode_barcode='00023437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8014000',harga_beli ='8014000' WHERE kode_barcode='00023488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11132500',harga_beli ='11132500' WHERE kode_barcode='00023490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='45489000',harga_beli ='45489000' WHERE kode_barcode='00023493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='23279000',harga_beli ='23279000' WHERE kode_barcode='00023537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00023549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6109500',harga_beli ='6109500' WHERE kode_barcode='00023563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7544500',harga_beli ='7544500' WHERE kode_barcode='00023572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10394500',harga_beli ='10394500' WHERE kode_barcode='00023585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3998000',harga_beli ='3998000' WHERE kode_barcode='00023590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6589500',harga_beli ='6589500' WHERE kode_barcode='00023593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6513000',harga_beli ='6513000' WHERE kode_barcode='00023594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6462500',harga_beli ='6462500' WHERE kode_barcode='00023595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7196000',harga_beli ='7196000' WHERE kode_barcode='00023596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10329500',harga_beli ='10329500' WHERE kode_barcode='00023600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10278500',harga_beli ='10278500' WHERE kode_barcode='00023602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7352500',harga_beli ='7352500' WHERE kode_barcode='00023604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7988500',harga_beli ='7988500' WHERE kode_barcode='00023605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13051500',harga_beli ='13051500' WHERE kode_barcode='00023606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8523000',harga_beli ='8523000' WHERE kode_barcode='00023607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10380000',harga_beli ='10380000' WHERE kode_barcode='00023608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7378000',harga_beli ='7378000' WHERE kode_barcode='00023609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11550500',harga_beli ='11550500' WHERE kode_barcode='00023611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10787500',harga_beli ='10787500' WHERE kode_barcode='00023612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8599500',harga_beli ='8599500' WHERE kode_barcode='00023613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10812500',harga_beli ='10812500' WHERE kode_barcode='00023614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6538500',harga_beli ='6538500' WHERE kode_barcode='00023617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5576500',harga_beli ='5576500' WHERE kode_barcode='00023622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5088500',harga_beli ='5088500' WHERE kode_barcode='00023623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13859000',harga_beli ='13859000' WHERE kode_barcode='00023626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7011500',harga_beli ='7011500' WHERE kode_barcode='00023629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3116500',harga_beli ='3116500' WHERE kode_barcode='00023632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4121000',harga_beli ='4121000' WHERE kode_barcode='00023666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2358000',harga_beli ='2358000' WHERE kode_barcode='00023679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5433000',harga_beli ='5433000' WHERE kode_barcode='00023691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7421500',harga_beli ='7421500' WHERE kode_barcode='00023692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8795000',harga_beli ='8795000' WHERE kode_barcode='00023693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8795000',harga_beli ='8795000' WHERE kode_barcode='00023697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='18318000',harga_beli ='18318000' WHERE kode_barcode='00023704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10005000',harga_beli ='10005000' WHERE kode_barcode='00023760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12415500',harga_beli ='12415500' WHERE kode_barcode='00023815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4285000',harga_beli ='4285000' WHERE kode_barcode='00023830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11378500',harga_beli ='11378500' WHERE kode_barcode='00023843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4579500',harga_beli ='4579500' WHERE kode_barcode='00023848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6048000',harga_beli ='6048000' WHERE kode_barcode='00023857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6642500',harga_beli ='6642500' WHERE kode_barcode='00023907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6437500',harga_beli ='6437500' WHERE kode_barcode='00023913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5597000',harga_beli ='5597000' WHERE kode_barcode='00023917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6284000',harga_beli ='6284000' WHERE kode_barcode='00023920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6560500',harga_beli ='6560500' WHERE kode_barcode='00023934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3178000',harga_beli ='3178000' WHERE kode_barcode='00023964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8139000',harga_beli ='8139000' WHERE kode_barcode='00023965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9006500',harga_beli ='9006500' WHERE kode_barcode='00023979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5515000',harga_beli ='5515000' WHERE kode_barcode='00023985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9307500',harga_beli ='9307500' WHERE kode_barcode='00023991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6888500',harga_beli ='6888500' WHERE kode_barcode='00023997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7524000',harga_beli ='7524000' WHERE kode_barcode='00023998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7237000',harga_beli ='7237000' WHERE kode_barcode='00024000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9574000',harga_beli ='9574000' WHERE kode_barcode='00024004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5515000',harga_beli ='5515000' WHERE kode_barcode='00024013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8803000',harga_beli ='8803000' WHERE kode_barcode='00024038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='00024062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7729000',harga_beli ='7729000' WHERE kode_barcode='00024069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3342000',harga_beli ='3342000' WHERE kode_barcode='00024077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5474000',harga_beli ='5474000' WHERE kode_barcode='00024085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5330500',harga_beli ='5330500' WHERE kode_barcode='00024086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4350500',harga_beli ='4350500' WHERE kode_barcode='00024095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7893000',harga_beli ='7893000' WHERE kode_barcode='00024096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7134500',harga_beli ='7134500' WHERE kode_barcode='00024104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8221000',harga_beli ='8221000' WHERE kode_barcode='00024148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6355500',harga_beli ='6355500' WHERE kode_barcode='00024186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6253000',harga_beli ='6253000' WHERE kode_barcode='00024189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11788500',harga_beli ='11788500' WHERE kode_barcode='00024193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4551500',harga_beli ='4551500' WHERE kode_barcode='00024194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6417000',harga_beli ='6417000' WHERE kode_barcode='00024363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7380500',harga_beli ='7380500' WHERE kode_barcode='00025284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7872500',harga_beli ='7872500' WHERE kode_barcode='00025286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='14945500',harga_beli ='14945500' WHERE kode_barcode='00025510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='19025000',harga_beli ='19025000' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='16308000',harga_beli ='16308000' WHERE kode_barcode='00026302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8549000',harga_beli ='8549000' WHERE kode_barcode='00026725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5699500',harga_beli ='5699500' WHERE kode_barcode='00026884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3260000',harga_beli ='3260000' WHERE kode_barcode='00026926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5822500',harga_beli ='5822500' WHERE kode_barcode='00026927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10087000',harga_beli ='10087000' WHERE kode_barcode='00026952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5638000',harga_beli ='5638000' WHERE kode_barcode='00027033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11296500',harga_beli ='11296500' WHERE kode_barcode='00027034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5904500',harga_beli ='5904500' WHERE kode_barcode='00027038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5474000',harga_beli ='5474000' WHERE kode_barcode='00027050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5248500',harga_beli ='5248500' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3649500',harga_beli ='3649500' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='17795000',harga_beli ='17795000' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4777000',harga_beli ='4777000' WHERE kode_barcode='00027229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5392000',harga_beli ='5392000' WHERE kode_barcode='00027334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='00027480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13367000',harga_beli ='13367000' WHERE kode_barcode='00027482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00027795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8426000',harga_beli ='8426000' WHERE kode_barcode='00027945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6818500',harga_beli ='6818500' WHERE kode_barcode='00028046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5125500',harga_beli ='5125500' WHERE kode_barcode='00028107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12383000',harga_beli ='12383000' WHERE kode_barcode='00028220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12237500',harga_beli ='12237500' WHERE kode_barcode='00028368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8345000',harga_beli ='8345000' WHERE kode_barcode='00028381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11194000',harga_beli ='11194000' WHERE kode_barcode='00028442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3714500',harga_beli ='3714500' WHERE kode_barcode='00028566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8036500',harga_beli ='8036500' WHERE kode_barcode='00028582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6786000',harga_beli ='6786000' WHERE kode_barcode='00028682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5679000',harga_beli ='5679000' WHERE kode_barcode='00028692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9591500',harga_beli ='9591500' WHERE kode_barcode='00028772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5289500',harga_beli ='5289500' WHERE kode_barcode='00029136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4478000',harga_beli ='4478000' WHERE kode_barcode='00029506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10374000',harga_beli ='10374000' WHERE kode_barcode='00029526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5597500',harga_beli ='5597500' WHERE kode_barcode='00029662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13331500',harga_beli ='13331500' WHERE kode_barcode='00030349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4900000',harga_beli ='4900000' WHERE kode_barcode='00030671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7531000',harga_beli ='7531000' WHERE kode_barcode='00030672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6360500',harga_beli ='6360500' WHERE kode_barcode='00030674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3765500',harga_beli ='3765500' WHERE kode_barcode='00030709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3816500',harga_beli ='3816500' WHERE kode_barcode='00030712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3740000',harga_beli ='3740000' WHERE kode_barcode='00030714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4579500',harga_beli ='4579500' WHERE kode_barcode='00030716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4452500',harga_beli ='4452500' WHERE kode_barcode='00030719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4147000',harga_beli ='4147000' WHERE kode_barcode='00030721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6538500',harga_beli ='6538500' WHERE kode_barcode='00030821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4818000',harga_beli ='4818000' WHERE kode_barcode='00030827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2153000',harga_beli ='2153000' WHERE kode_barcode='00031061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2132500',harga_beli ='2132500' WHERE kode_barcode='00031062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2050500',harga_beli ='2050500' WHERE kode_barcode='00031064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3424000',harga_beli ='3424000' WHERE kode_barcode='00031066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4121000',harga_beli ='4121000' WHERE kode_barcode='00031069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3772500',harga_beli ='3772500' WHERE kode_barcode='00031070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3731500',harga_beli ='3731500' WHERE kode_barcode='00031071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6171000',harga_beli ='6171000' WHERE kode_barcode='00031112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8631000',harga_beli ='8631000' WHERE kode_barcode='00031113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6519500',harga_beli ='6519500' WHERE kode_barcode='00031114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3649500',harga_beli ='3649500' WHERE kode_barcode='00031115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3280500',harga_beli ='3280500' WHERE kode_barcode='00031116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8930000',harga_beli ='8930000' WHERE kode_barcode='00031117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='22059500',harga_beli ='22059500' WHERE kode_barcode='00031126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='20399000',harga_beli ='20399000' WHERE kode_barcode='00031175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7093500',harga_beli ='7093500' WHERE kode_barcode='00031182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7887000',harga_beli ='7887000' WHERE kode_barcode='00031184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6996500',harga_beli ='6996500' WHERE kode_barcode='00031187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12797000',harga_beli ='12797000' WHERE kode_barcode='00031190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6030000',harga_beli ='6030000' WHERE kode_barcode='00031191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='35363500',harga_beli ='35363500' WHERE kode_barcode='00031203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='18699500',harga_beli ='18699500' WHERE kode_barcode='00031204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6191500',harga_beli ='6191500' WHERE kode_barcode='00031267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5330500',harga_beli ='5330500' WHERE kode_barcode='00031268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8057000',harga_beli ='8057000' WHERE kode_barcode='00031269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7893000',harga_beli ='7893000' WHERE kode_barcode='00031270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4674500',harga_beli ='4674500' WHERE kode_barcode='00031272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5392000',harga_beli ='5392000' WHERE kode_barcode='00031274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5761000',harga_beli ='5761000' WHERE kode_barcode='00031276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7032000',harga_beli ='7032000' WHERE kode_barcode='00031277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='00031278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5330500',harga_beli ='5330500' WHERE kode_barcode='00031279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4982000',harga_beli ='4982000' WHERE kode_barcode='00031280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6765500',harga_beli ='6765500' WHERE kode_barcode='00031282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6663000',harga_beli ='6663000' WHERE kode_barcode='00031283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7052500',harga_beli ='7052500' WHERE kode_barcode='00031284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3342000',harga_beli ='3342000' WHERE kode_barcode='00031286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3690500',harga_beli ='3690500' WHERE kode_barcode='00031287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6786000',harga_beli ='6786000' WHERE kode_barcode='00031333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7626500',harga_beli ='7626500' WHERE kode_barcode='00031335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4059500',harga_beli ='4059500' WHERE kode_barcode='00031337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6089000',harga_beli ='6089000' WHERE kode_barcode='00031382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5617500',harga_beli ='5617500' WHERE kode_barcode='00031383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4346500',harga_beli ='4346500' WHERE kode_barcode='00031385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4326000',harga_beli ='4326000' WHERE kode_barcode='00031386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2870500',harga_beli ='2870500' WHERE kode_barcode='00031387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7175500',harga_beli ='7175500' WHERE kode_barcode='00031390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5207500',harga_beli ='5207500' WHERE kode_barcode='00031391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3362500',harga_beli ='3362500' WHERE kode_barcode='00031392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5146000',harga_beli ='5146000' WHERE kode_barcode='00031394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7442000',harga_beli ='7442000' WHERE kode_barcode='00031396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6171000',harga_beli ='6171000' WHERE kode_barcode='00031397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6806500',harga_beli ='6806500' WHERE kode_barcode='00031399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8733500',harga_beli ='8733500' WHERE kode_barcode='00031401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6683500',harga_beli ='6683500' WHERE kode_barcode='00031402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4900000',harga_beli ='4900000' WHERE kode_barcode='00031404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5392000',harga_beli ='5392000' WHERE kode_barcode='00031406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='00031407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6827000',harga_beli ='6827000' WHERE kode_barcode='00031409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6253000',harga_beli ='6253000' WHERE kode_barcode='00031410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7626500',harga_beli ='7626500' WHERE kode_barcode='00031411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5556000',harga_beli ='5556000' WHERE kode_barcode='00031413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00031414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5494500',harga_beli ='5494500' WHERE kode_barcode='00031416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8057000',harga_beli ='8057000' WHERE kode_barcode='00031454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7339500',harga_beli ='7339500' WHERE kode_barcode='00031461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8904500',harga_beli ='8904500' WHERE kode_barcode='00031492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7098500',harga_beli ='7098500' WHERE kode_barcode='00031493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5720000',harga_beli ='5720000' WHERE kode_barcode='00031494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4510500',harga_beli ='4510500' WHERE kode_barcode='00031495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5146000',harga_beli ='5146000' WHERE kode_barcode='00031496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6970500',harga_beli ='6970500' WHERE kode_barcode='00031498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6745000',harga_beli ='6745000' WHERE kode_barcode='00031502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6724500',harga_beli ='6724500' WHERE kode_barcode='00031504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5084500',harga_beli ='5084500' WHERE kode_barcode='00031514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6640500',harga_beli ='6640500' WHERE kode_barcode='00031516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4529000',harga_beli ='4529000' WHERE kode_barcode='00031517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='00031521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6309500',harga_beli ='6309500' WHERE kode_barcode='00031522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9566000',harga_beli ='9566000' WHERE kode_barcode='00031523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3075500',harga_beli ='3075500' WHERE kode_barcode='00031533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5012000',harga_beli ='5012000' WHERE kode_barcode='00031563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6487500',harga_beli ='6487500' WHERE kode_barcode='00031565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5622500',harga_beli ='5622500' WHERE kode_barcode='00031566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4223500',harga_beli ='4223500' WHERE kode_barcode='00031568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6519500',harga_beli ='6519500' WHERE kode_barcode='00031584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3977500',harga_beli ='3977500' WHERE kode_barcode='00031585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7683500',harga_beli ='7683500' WHERE kode_barcode='00031588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3403500',harga_beli ='3403500' WHERE kode_barcode='00031590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4203000',harga_beli ='4203000' WHERE kode_barcode='00031591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6396500',harga_beli ='6396500' WHERE kode_barcode='00031595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3664000',harga_beli ='3664000' WHERE kode_barcode='00031599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3358500',harga_beli ='3358500' WHERE kode_barcode='00031600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10507500',harga_beli ='10507500' WHERE kode_barcode='00031613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9451000',harga_beli ='9451000' WHERE kode_barcode='00031616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5597500',harga_beli ='5597500' WHERE kode_barcode='00031619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3813500',harga_beli ='3813500' WHERE kode_barcode='00031633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3895500',harga_beli ='3895500' WHERE kode_barcode='00031634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='17910500',harga_beli ='17910500' WHERE kode_barcode='00031636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3078500',harga_beli ='3078500' WHERE kode_barcode='00031637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5248500',harga_beli ='5248500' WHERE kode_barcode='00031658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7938000',harga_beli ='7938000' WHERE kode_barcode='00031747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6581000',harga_beli ='6581000' WHERE kode_barcode='00031754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='17118500',harga_beli ='17118500' WHERE kode_barcode='00031755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3444500',harga_beli ='3444500' WHERE kode_barcode='00031756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7022000',harga_beli ='7022000' WHERE kode_barcode='00031818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5699500',harga_beli ='5699500' WHERE kode_barcode='00031819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5928000',harga_beli ='5928000' WHERE kode_barcode='00031820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8904500',harga_beli ='8904500' WHERE kode_barcode='00031821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3239500',harga_beli ='3239500' WHERE kode_barcode='00031823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8090500',harga_beli ='8090500' WHERE kode_barcode='00031824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7175500',harga_beli ='7175500' WHERE kode_barcode='00031825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2595500',harga_beli ='2595500' WHERE kode_barcode='00031829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4387500',harga_beli ='4387500' WHERE kode_barcode='00031856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6666000',harga_beli ='6666000' WHERE kode_barcode='00031857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10405500',harga_beli ='10405500' WHERE kode_barcode='00031895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7565000',harga_beli ='7565000' WHERE kode_barcode='00031896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7319000',harga_beli ='7319000' WHERE kode_barcode='00031897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6232500',harga_beli ='6232500' WHERE kode_barcode='00031905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6970500',harga_beli ='6970500' WHERE kode_barcode='00031911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='21977500',harga_beli ='21977500' WHERE kode_barcode='00031914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3178000',harga_beli ='3178000' WHERE kode_barcode='00031968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='17467000',harga_beli ='17467000' WHERE kode_barcode='00031969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4715500',harga_beli ='4715500' WHERE kode_barcode='00032093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6683500',harga_beli ='6683500' WHERE kode_barcode='00032094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3813500',harga_beli ='3813500' WHERE kode_barcode='00032213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2214500',harga_beli ='2214500' WHERE kode_barcode='00032215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='25319000',harga_beli ='25319000' WHERE kode_barcode='00032356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='17364500',harga_beli ='17364500' WHERE kode_barcode='00032357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2727000',harga_beli ='2727000' WHERE kode_barcode='00032358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5064000',harga_beli ='5064000' WHERE kode_barcode='00032360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00032361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4510500',harga_beli ='4510500' WHERE kode_barcode='00032362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00032364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6273500',harga_beli ='6273500' WHERE kode_barcode='00032370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='16852000',harga_beli ='16852000' WHERE kode_barcode='00032375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3943500',harga_beli ='3943500' WHERE kode_barcode='00032376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2276000',harga_beli ='2276000' WHERE kode_barcode='00032377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3465000',harga_beli ='3465000' WHERE kode_barcode='00032379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10189500',harga_beli ='10189500' WHERE kode_barcode='00032381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6888500',harga_beli ='6888500' WHERE kode_barcode='00032498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8118500',harga_beli ='8118500' WHERE kode_barcode='00032499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11645000',harga_beli ='11645000' WHERE kode_barcode='00032501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6259000',harga_beli ='6259000' WHERE kode_barcode='00032504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='14222000',harga_beli ='14222000' WHERE kode_barcode='00032505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6513000',harga_beli ='6513000' WHERE kode_barcode='00032507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7938000',harga_beli ='7938000' WHERE kode_barcode='00032509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7378000',harga_beli ='7378000' WHERE kode_barcode='00032513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='30300500',harga_beli ='30300500' WHERE kode_barcode='00032523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11788500',harga_beli ='11788500' WHERE kode_barcode='00032649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7988500',harga_beli ='7988500' WHERE kode_barcode='00032667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9738500',harga_beli ='9738500' WHERE kode_barcode='00032670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='16588000',harga_beli ='16588000' WHERE kode_barcode='00033184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6888500',harga_beli ='6888500' WHERE kode_barcode='00033220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5658500',harga_beli ='5658500' WHERE kode_barcode='00033261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2665500',harga_beli ='2665500' WHERE kode_barcode='00033262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2501500',harga_beli ='2501500' WHERE kode_barcode='00033264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7938000',harga_beli ='7938000' WHERE kode_barcode='00033289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='22469500',harga_beli ='22469500' WHERE kode_barcode='00033485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4039000',harga_beli ='4039000' WHERE kode_barcode='00034068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3649500',harga_beli ='3649500' WHERE kode_barcode='00034069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4941000',harga_beli ='4941000' WHERE kode_barcode='00034070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4715500',harga_beli ='4715500' WHERE kode_barcode='00034071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3342000',harga_beli ='3342000' WHERE kode_barcode='00034073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3506000',harga_beli ='3506000' WHERE kode_barcode='00034075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1907000',harga_beli ='1907000' WHERE kode_barcode='00034076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3649500',harga_beli ='3649500' WHERE kode_barcode='00034080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5228000',harga_beli ='5228000' WHERE kode_barcode='00034142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7544500',harga_beli ='7544500' WHERE kode_barcode='00034164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3977500',harga_beli ='3977500' WHERE kode_barcode='00034166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3895500',harga_beli ='3895500' WHERE kode_barcode='00034167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='23802000',harga_beli ='23802000' WHERE kode_barcode='00034249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3075500',harga_beli ='3075500' WHERE kode_barcode='00034338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5474000',harga_beli ='5474000' WHERE kode_barcode='00034347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='00034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5576500',harga_beli ='5576500' WHERE kode_barcode='00034349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8467000',harga_beli ='8467000' WHERE kode_barcode='00034354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3157500',harga_beli ='3157500' WHERE kode_barcode='00034355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5187000',harga_beli ='5187000' WHERE kode_barcode='00034356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4592500',harga_beli ='4592500' WHERE kode_barcode='00034357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2091500',harga_beli ='2091500' WHERE kode_barcode='00034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4449000',harga_beli ='4449000' WHERE kode_barcode='00034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3239500',harga_beli ='3239500' WHERE kode_barcode='00034373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3198500',harga_beli ='3198500' WHERE kode_barcode='00034374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9553500',harga_beli ='9553500' WHERE kode_barcode='00034381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12362500',harga_beli ='12362500' WHERE kode_barcode='00034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4427000',harga_beli ='4427000' WHERE kode_barcode='00034661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4045500',harga_beli ='4045500' WHERE kode_barcode='00035018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2850000',harga_beli ='2850000' WHERE kode_barcode='00035045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7626500',harga_beli ='7626500' WHERE kode_barcode='00035046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3711000',harga_beli ='3711000' WHERE kode_barcode='00035171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11276000',harga_beli ='11276000' WHERE kode_barcode='00035278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6150500',harga_beli ='6150500' WHERE kode_barcode='00035477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4531000',harga_beli ='4531000' WHERE kode_barcode='00035519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1169000',harga_beli ='1169000' WHERE kode_barcode='00035951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10787500',harga_beli ='10787500' WHERE kode_barcode='00036172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='943500',harga_beli ='943500' WHERE kode_barcode='00036243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='861500',harga_beli ='861500' WHERE kode_barcode='00036245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2050500',harga_beli ='2050500' WHERE kode_barcode='00036432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3280500',harga_beli ='3280500' WHERE kode_barcode='00036686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='00036992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4285000',harga_beli ='4285000' WHERE kode_barcode='00037325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6171000',harga_beli ='6171000' WHERE kode_barcode='00037332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6704000',harga_beli ='6704000' WHERE kode_barcode='00037825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00037907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4325000',harga_beli ='4325000' WHERE kode_barcode='00038024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5617500',harga_beli ='5617500' WHERE kode_barcode='00038455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2870500',harga_beli ='2870500' WHERE kode_barcode='00038674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='00038843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3321500',harga_beli ='3321500' WHERE kode_barcode='00039179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2686000',harga_beli ='2686000' WHERE kode_barcode='00039180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2132500',harga_beli ='2132500' WHERE kode_barcode='00039181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6273500',harga_beli ='6273500' WHERE kode_barcode='00039192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5638000',harga_beli ='5638000' WHERE kode_barcode='00039193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3485500',harga_beli ='3485500' WHERE kode_barcode='00039194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='12041500',harga_beli ='12041500' WHERE kode_barcode='00039381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4018500',harga_beli ='4018500' WHERE kode_barcode='00039405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7947500',harga_beli ='7947500' WHERE kode_barcode='00040395' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11578500',harga_beli ='11578500' WHERE kode_barcode='00040869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5206000',harga_beli ='5206000' WHERE kode_barcode='00040871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3816500',harga_beli ='3816500' WHERE kode_barcode='00041095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4715500',harga_beli ='4715500' WHERE kode_barcode='00041096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3608500',harga_beli ='3608500' WHERE kode_barcode='00041097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6663000',harga_beli ='6663000' WHERE kode_barcode='00041099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7749500',harga_beli ='7749500' WHERE kode_barcode='00041100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00041101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5207500',harga_beli ='5207500' WHERE kode_barcode='00041102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='00041103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3711000',harga_beli ='3711000' WHERE kode_barcode='00041104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2870500',harga_beli ='2870500' WHERE kode_barcode='00041105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1620000',harga_beli ='1620000' WHERE kode_barcode='00041106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6929500',harga_beli ='6929500' WHERE kode_barcode='00041108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3813500',harga_beli ='3813500' WHERE kode_barcode='00041109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8221000',harga_beli ='8221000' WHERE kode_barcode='00041110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8344000',harga_beli ='8344000' WHERE kode_barcode='00041111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8118500',harga_beli ='8118500' WHERE kode_barcode='00041112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8180000',harga_beli ='8180000' WHERE kode_barcode='00041113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7667500',harga_beli ='7667500' WHERE kode_barcode='00041114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='15320500',harga_beli ='15320500' WHERE kode_barcode='00041180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9188500',harga_beli ='9188500' WHERE kode_barcode='00041280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8692500',harga_beli ='8692500' WHERE kode_barcode='00041414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5335500',harga_beli ='5335500' WHERE kode_barcode='00042238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3057000',harga_beli ='3057000' WHERE kode_barcode='00042487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3854500',harga_beli ='3854500' WHERE kode_barcode='00042503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7193000',harga_beli ='7193000' WHERE kode_barcode='00042736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7483000',harga_beli ='7483000' WHERE kode_barcode='00043558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4961500',harga_beli ='4961500' WHERE kode_barcode='00043942' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2470000','kasir','2026-06-04 13:11:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','13:13:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','13:20:54');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260604-0003','D','2026-06-04','13:26:38','kasir','REPARASI','SV08152','10094200','125000','10219200');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','13:28:33');
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-02367','ELLA','1','PER','CINCIN SR 05 SILVER','','','1.000','','925.00','1','100000','0','0','0','950000','CEWE SIZE 13 GRF KARDI','COWO SIZE 23 GRF EMI S UP SIZE 100K','CROM PUTIH KEDUANYA','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-260604-0019','2026-06-04','2026-06-04 13:44:47','PESANAN : DP-02367','.','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-260604-0020','D','2026-06-04','13:44:47','TBC','PESANAN','DP-02367','23298708014','950000','23299658014','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-02367','2026-06-04','2026-06-04','13:44:47','PLG0011745','ELLA','2026-06-25','kasir','2026-06-04 13:44:47','1.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-260604-0003','kasir','1',' TFA-21106 ','TOKO','TFABR','TFA-YBBD-24-0','GIWANG TFA-21106','','1.500','1','83.00','6389000','2480000','137','18100','7100000','0','0','0','7100000','ONLNANA','00034338','TFA','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFA-YBBD-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='TFA-YBBD-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFABR' 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-260604-0003','2026-06-04','1.500','2026-06-04','14:12:18','PLG0011746','7100000','7100000','0','7100000','0','kasir','2026-06-04 14:12:18','FJ-260604-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0003','2026-06-04','14:12:18','ONLNANA','7100000','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-260604-0020','2026-06-04','2026-06-04 14:12:18','PENJUALAN : FJ-260604-0003','.','TBC','7100000','7100000','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-260604-0021','D','2026-06-04','14:12:18','TBC','PENJUALAN BERLIAN','FJ-260604-0003','23299658014','7100000','23306758014','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='7100000' WHERE no_faktur_jual='FJ-260604-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','14:14:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','14:34:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','14:39:06');
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-260604-0004','sby','1',' DP-02252SB','TOKO','SBYPSN','PSGT-ZEBI-10-0','CINCIN EMAS ','','2.580','1','45.00','2902000','0','0','18100','4980000','0','0','0','4980000','VAN','00043836','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEBI-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.580',berat_jual_asli=berat_jual_asli+'2.580',stock_jual='1',berat_akhir=berat_akhir-'2.580',berat_akhir_asli=berat_akhir_asli-'2.580',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSGT-ZEBI-10-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-260604-0004','2026-06-04','2.580','2026-06-04','14:51:17','PLG0011747','4980000','4980000','0','4980000','0','sby','2026-06-04 14:51:16','FJ-260604-0004','DP-02252','3400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0004','2026-06-04','14:51:17','VAN','4980000','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-260604-0021','2026-06-04','2026-06-04 14:51:16','PENJUALAN : FJ-260604-0004','','TBC','1580000','1580000','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-260604-0022','D','2026-06-04','14:51:17','TBC','PENJUALAN','FJ-260604-0004','23306758014','1580000','23308338014','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='1580000' WHERE no_faktur_jual='FJ-260604-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-04 ','15:38:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','15:39:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-04 ','15:40:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','16:14:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','16:17:02');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-04',  status ='CLOS' WHERE no_service='SV-02054';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02054';
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-02368','DIL','1','GOLD','WEDD RING','','','2.500','','37.50','1','2450000','1500000','0','850000','4600000','PERMATA 9 BUTIR','SIZE 13 GRF: Y (INFINITY) M 18.10.26 (BERKSHIRE)','PUTIH (EMAS PUTIH)','90000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0022','2026-06-04','2026-06-04 16:35:30','PESANAN : DP-02368','-','TBC','3200000','3200000');
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-260604-0023','D','2026-06-04','16:35:30','TBC','PESANAN','DP-02368','23308338014','3200000','23311538014','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-02368','2026-06-04','2026-06-04','16:35:30','PLG0011748','DIL','2026-06-30','sby','2026-06-04 16:35:30','2.500','0','0','0','3200000','0','850000','4690000','4690000','1490000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-04 ','16:56:25');
DELETE FROM tm_otoritas WHERE user_id='kasirbip';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.01.1  Laporan Tambah Barang','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.01.4  Laporan Barang (Summary)','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.01.8  Laporan Terima Data Barang','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.2  Laporan Stock Terjual','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.3  Laporan Batal Penjualan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.4  Laporan Penjualan Sales','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.05.2  Laporan Stock Pesanan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.06.1  Laporan Transaksi Service','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.06.5  Laporan Stock Service','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.10.1  Laporan Bank Detail dan Summary','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.10.2  Laporan Transaksi Credit Card','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.10.3  Laporan Transaksi Debet Card','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.10.4  Laporan Data Pemilik Credit Card','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.10.5  Laporan Transaksi Transfer','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','11.8  Transfer Data','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','2.01  Terima Barang Pusat','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','2.07  Cari Data Barang','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','2.08  Cari Barang Berdasarkan Berat','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','3.01  Transaksi Penjualan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','3.02  Lihat Penjualan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','3.03  Pembatalan Penjualan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','3.04  Titip Uang','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','3.05  Pengambilan Barang Titipan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','3.06  Pembatalan Titip Uang','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','5.01  Transaksi Pesanan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','5.02  Lihat Transaksi Pesanan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','5.03  Pembatalan Pesanan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','5.04  Tambah Uang Pesanan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','5.05  Pesanan Selesai','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','5.06  Penyerahan Pesanan','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','6.01  Transaksi Service','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','6.02  Lihat Transaksi Service','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','6.03  Pembatalan Service','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','6.04  Service - Selesai','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','6.05  Service - Ambil','Nagatech','2026-06-04 16:56:54');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasirbip','9.01  Validasi Penjualan','Nagatech','2026-06-04 16:56:54');
DELETE FROM tm_otoritas WHERE user_id='kasir';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 2.0  Barang -----','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.03  Data Baki','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.05  Data Sales','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.11  Parameter Batu Berlian','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.1  Laporan Tambah Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.2  Laporan Timbang Baki','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.3  Laporan Barang (Detail)','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.4  Laporan Barang (Summary)','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.5  Laporan Barang Yang Hilang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.6  Laporan Barang Yang Di Hancur','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.7  Laporan Barang Yang Di Pindah','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.8  Laporan Terima Data Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.2  Laporan Stock Terjual','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.3  Laporan Batal Penjualan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.4  Laporan Penjualan Sales','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.1  Laporan Transaksi Titip Uang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.2  Laporan Pengambilan Barang Titipan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.3  Laporan Batal Titip Uang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.4  Laporan Stock Titip Uang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.1  Laporan Transaksi Barang Balik','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.10 Laporan Pembelian Umum Berlian','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.2  Laporan Stock Barang Balik','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.3  Laporan Batal Barang Balik','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.4  Laporan Barang Balik Sales','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.2  Laporan Stock Pesanan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.1  Laporan Transaksi Service','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.5  Laporan Stock Service','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.1  Laporan Transaksi','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.2  Laporan Cashier Jual','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.3  Laporan Cashier Beli','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.12  Buku Berlian','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.2  Harga Emas','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.4  Cetak Barcode','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.1  Tambah Uang Bank','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.2  Ambil Uang Bank','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Terima Barang Pusat','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.02  Ganti Data Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.03  Hilang Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.05  Pindah Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.06  Pindah Barang Satu Baki','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.07  Cari Data Barang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.01  Transaksi Penjualan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.02  Lihat Penjualan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.04  Titip Uang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.05  Pengambilan Barang Titipan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.01  Transaksi Barang Balik','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.02  Lihat Barang Balik','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.08  Transaksi Pembelian Umum Berlian','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.01  Transaksi Pesanan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.02  Lihat Transaksi Pesanan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.04  Tambah Uang Pesanan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.05  Pesanan Selesai','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.06  Penyerahan Pesanan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.01  Transaksi Service','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.02  Lihat Transaksi Service','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.04  Service - Selesai','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.05  Service - Ambil','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.01  Tambah Uang Kas','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.02  Ambil Uang Kas','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.01  Validasi Penjualan','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.02  Validasi Pembelian','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.03  Validasi Hutang','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','AMBIL POIN MANUAL','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','CARI POIN','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA HADIAH','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA MEMBER','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN DAFTAR MEMBER','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN TUKAR POIN','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LIHAT TRANSAKSI MEMBER','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','PARAMETER POIN','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TAMBAH POIN MANUAL','Nagatech','2026-06-04 16:57:16');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TUKAR POIN','Nagatech','2026-06-04 16:57:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','17:01:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','17:01:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-04 ','17:05:40');
DELETE FROM tm_otoritas WHERE user_id='kasir';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.03  Data Baki','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.05  Data Sales','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.11  Parameter Batu Berlian','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.1  Laporan Tambah Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.2  Laporan Timbang Baki','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.3  Laporan Barang (Detail)','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.4  Laporan Barang (Summary)','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.5  Laporan Barang Yang Hilang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.6  Laporan Barang Yang Di Hancur','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.7  Laporan Barang Yang Di Pindah','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.8  Laporan Terima Data Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.2  Laporan Stock Terjual','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.3  Laporan Batal Penjualan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.4  Laporan Penjualan Sales','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.1  Laporan Transaksi Titip Uang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.2  Laporan Pengambilan Barang Titipan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.3  Laporan Batal Titip Uang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.4  Laporan Stock Titip Uang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.1  Laporan Transaksi Barang Balik','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.10 Laporan Pembelian Umum Berlian','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.2  Laporan Stock Barang Balik','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.3  Laporan Batal Barang Balik','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.4  Laporan Barang Balik Sales','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.2  Laporan Stock Pesanan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.1  Laporan Transaksi Service','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.5  Laporan Stock Service','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.1  Laporan Transaksi','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.2  Laporan Cashier Jual','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.3  Laporan Cashier Beli','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.12  Buku Berlian','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.2  Harga Emas','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.4  Cetak Barcode','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.1  Tambah Uang Bank','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.2  Ambil Uang Bank','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Terima Barang Pusat','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.02  Ganti Data Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.03  Hilang Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.05  Pindah Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.06  Pindah Barang Satu Baki','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.07  Cari Data Barang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.01  Transaksi Penjualan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.02  Lihat Penjualan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.04  Titip Uang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.05  Pengambilan Barang Titipan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.01  Transaksi Barang Balik','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.02  Lihat Barang Balik','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.08  Transaksi Pembelian Umum Berlian','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.01  Transaksi Pesanan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.02  Lihat Transaksi Pesanan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.04  Tambah Uang Pesanan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.05  Pesanan Selesai','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.06  Penyerahan Pesanan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.01  Transaksi Service','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.02  Lihat Transaksi Service','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.04  Service - Selesai','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.05  Service - Ambil','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.01  Tambah Uang Kas','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.02  Ambil Uang Kas','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.01  Validasi Penjualan','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.02  Validasi Pembelian','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.03  Validasi Hutang','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','AMBIL POIN MANUAL','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','CARI POIN','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA HADIAH','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA MEMBER','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN DAFTAR MEMBER','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN TUKAR POIN','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LIHAT TRANSAKSI MEMBER','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','PARAMETER POIN','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TAMBAH POIN MANUAL','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TUKAR POIN','Nagatech','2026-06-04 17:06:00');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.8  Tutup Toko (Closing)','Nagatech','2026-06-04 17:06:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','17:06:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-04 ','17:06:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','17:07:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','17:07:37');
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-260604-0005','sby','1',' 500K-185-0','TOKO','SBYPER','PSBY-ZEXA-46-0','CINCIN SILVER 925 YL-01','','2.080','1','100.00','213000','0','0','18100','600000','0','0','0','600000','VAN','00043068','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSBY-ZEXA-46-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-260604-0005','2026-06-04','2.080','2026-06-04','17:10:13','PLG0011749','600000','600000','0','600000','0','sby','2026-06-04 17:10:12','FJ-260604-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0005','2026-06-04','17:10:13','VAN','600000','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-260604-0023','2026-06-04','2026-06-04 17:10:12','PENJUALAN : FJ-260604-0005','','TBC','600000','600000','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-260604-0024','D','2026-06-04','17:10:13','TBC','PENJUALAN','FJ-260604-0005','23311538014','600000','23312138014','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='600000' WHERE no_faktur_jual='FJ-260604-0005' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-04 ','17:11:12');
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-260604-0006','kasirbip','1',' DP-02165DU','TOKO','DUPSN','PSPRT-ZFXB-6-0','CINCIN PERAK ','','3.550','1','100.00','363000','0','0','18100','850000','0','0','0','850000','PUT','00043928','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFXB-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSPRT-ZFXB-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-260604-0006','2026-06-04','3.550','2026-06-04','17:17:05','PLG0011750','850000','850000','0','850000','0','kasirbip','2026-06-04 17:17:04','FJ-260604-0006','DP-02165','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0006','2026-06-04','17:17:05','PUT','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260604-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-260604-0007','kasirbip','1',' DP-02166DU','TOKO','DUPSN','PSPLT-ZEBE-27-0','CINCIN PALADIUM ','','3.120','1','32.00','1319000','0','0','18100','2500000','0','0','0','2500000','PUT','00043788','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBE-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSPLT-ZEBE-27-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-260604-0007','2026-06-04','3.120','2026-06-04','17:18:57','PLG0011751','2500000','2500000','0','2500000','0','kasirbip','2026-06-04 17:18:56','FJ-260604-0007','DP-02166','1952000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0007','2026-06-04','17:18:57','PUT','2500000','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-260604-0024','2026-06-04','2026-06-04 17:18:56','PENJUALAN : FJ-260604-0007','.','TBC','548000','548000','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-260604-0025','D','2026-06-04','17:18:57','TBC','PENJUALAN','FJ-260604-0007','23312138014','548000','23312686014','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='548000' WHERE no_faktur_jual='FJ-260604-0007' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','17:20:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','17:21:36');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0007';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02116','SULIS','1','CC PLD','CROM ROSEGOLD GLOSY KOMB PUTIH GLOSY','4.000','1','50000','50000');
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-260604-0025','2026-06-04','2026-06-04 17:30:13','SERVICE : SV-02116','..','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0026','D','2026-06-04','17:30:13','TBC','SERVICE','SV-02116','23312686014','50000','23312736014','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('..','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02116','2026-06-04','2026-06-04','17:30:13','PLG0011752','kasirbip','2026-06-14','kasirbip','2026-06-04 17:30:13','4.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','17:30:26');
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-260604-0008','sby','1',' 850K-155-0','TOKO','SBYPER','PSBY-ZEXA-38-0','CINCIN SILVER 925 ','','2.540','1','100.00','260000','0','0','18100','950000','0','0','0','950000','DIL','00043060','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSBY-ZEXA-38-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-260604-0008','2026-06-04','2.540','2026-06-04','17:38:37','PLG0011753','950000','950000','0','950000','0','sby','2026-06-04 17:38:37','FJ-260604-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0008','2026-06-04','17:38:37','DIL','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0026','2026-06-04','2026-06-04 17:38:37','PENJUALAN : FJ-260604-0008','','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0027','D','2026-06-04','17:38:37','TBC','PENJUALAN','FJ-260604-0008','23312736014','950000','23313686014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260604-0008' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','17:40:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','17:40:55');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0008';
UPDATE tt_service_head SET tgl_selesai='2026-06-04',  status ='DONE' WHERE no_service='SV-02099';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02099';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-04',  status ='CLOS' WHERE no_service='SV-02099';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02099';
UPDATE tt_service_head SET tgl_selesai='2026-06-04',  status ='DONE' WHERE no_service='SV-02111';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02111';
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-260604-0009','kasirbip','1',' DP-02133BI','TOKO','BIPPSN','PSPLT-ZFXA-27-0','CINCIN PALADIUM ','','2.650','1','17.00','596000','0','0','18100','1545000','0','0','0','1545000','SAL','00043907','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFXA-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSPLT-ZFXA-27-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-260604-0009','2026-06-04','2.650','2026-06-04','17:58:47','PLG0011754','1545000','1545000','0','1545000','0','kasirbip','2026-06-04 17:58:47','FJ-260604-0009','DP-02133','1320000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0009','2026-06-04','17:58:47','SAL','1545000','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-260604-0027','2026-06-04','2026-06-04 17:58:47','PENJUALAN : FJ-260604-0009','.','TBC','225000','225000','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-260604-0028','D','2026-06-04','17:58:47','TBC','PENJUALAN','FJ-260604-0009','23313686014','225000','23313911014','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='225000' WHERE no_faktur_jual='FJ-260604-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0009';
UPDATE tt_service_head SET tgl_selesai='2026-06-04',  status ='DONE' WHERE no_service='SV-02063';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02063';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-04',  status ='CLOS' WHERE no_service='SV-02063';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02063';
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-260604-0010','kasir','1',' 1.0K-9-753','TOKO','MMPER','PMM-ZAXI-46-0','CINCIN SILVER 925 ','','1.620','1','100.00','100000','0','0','18100','1150000','0','0','0','1150000','ALIKA','00040823','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXI-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PMM-ZAXI-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260604-0010','2026-06-04','1.620','2026-06-04','18:35:44','PLG0011755','1150000','1150000','0','1150000','0','kasir','2026-06-04 18:35:44','FJ-260604-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0010','2026-06-04','18:35:44','ALIKA','1150000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0028','2026-06-04','2026-06-04 18:35:44','PENJUALAN : FJ-260604-0010','.','TBC','1150000','1150000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0029','D','2026-06-04','18:35:44','TBC','PENJUALAN','FJ-260604-0010','23313911014','1150000','23315061014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1150000' WHERE no_faktur_jual='FJ-260604-0010' LIMIT 1;
UPDATE tt_service_head SET tgl_selesai='2026-06-04',  status ='DONE' WHERE no_service='SV-02076';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02076';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-06-04',  status ='CLOS' WHERE no_service='SV-02076';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02076';
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-260604-0011','kasirbip','1',' 750K-20-22','TOKO','BIPPER','PBDG-ZBXE-6-0','CINCIN SILVER 925 ','','4.020','1','100.00','411000','0','0','18100','850000','0','0','0','850000','KUR','00041329','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBXE-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PBDG-ZBXE-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260604-0011','2026-06-04','4.020','2026-06-04','18:51:37','PLG0011756','850000','850000','0','850000','0','kasirbip','2026-06-04 18:51:37','FJ-260604-0011','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0011','2026-06-04','18:51:37','KUR','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-260604-0029','2026-06-04','2026-06-04 18:51:37','PENJUALAN : FJ-260604-0011','.','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-260604-0030','D','2026-06-04','18:51:37','TBC','PENJUALAN','FJ-260604-0011','23315061014','850000','23315911014','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-260604-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-260604-0012','kasir','1',' 700K-22-92','TOKO','MMPER','PMM-ZBBG-35-0','CINCIN SILVER 925 ','','2.150','1','100.00','220000','0','0','18100','850000','0','0','0','850000','ALIKA','00042037','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBG-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PMM-ZBBG-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260604-0012','2026-06-04','2.150','2026-06-04','18:59:50','PLG0011757','850000','850000','0','850000','0','kasir','2026-06-04 18:59:50','FJ-260604-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0012','2026-06-04','18:59:50','ALIKA','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-260604-0030','2026-06-04','2026-06-04 18:59:50','PENJUALAN : FJ-260604-0012','0','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0031','D','2026-06-04','18:59:50','TBC','PENJUALAN','FJ-260604-0012','23315911014','850000','23316761014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260604-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-260604-0013','kasir',' 1',' 700K-27-00','TOKO','MMPER','LXPER-ZBAH-20-0','CINCIN SILVER 925 ','','3.070','1','100.00','314000','0','0','18100','850000','0','0','0','850000','ALIKA','00041638','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='LXPER-ZBAH-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260604-0013','2026-06-04','3.070','2026-06-04','18:59:50','PLG0011758','850000','850000','0','850000','0','kasir','2026-06-04 18:59:50','FJ-260604-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0013','2026-06-04','18:59:50','ALIKA','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-260604-0031','2026-06-04','2026-06-04 18:59:50','PENJUALAN : FJ-260604-0013','0','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0032','D','2026-06-04','18:59:50','TBC','PENJUALAN','FJ-260604-0013','23316761014','850000','23317611014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-260604-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0013';
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-260604-0014','kasirbip','1',' 900K-125-2','TOKO','BIPPER','PBDG-ZEBI-22-0','CINCIN SILVER 925 ','','1.260','1','100.00','129000','0','0','18100','1000000','0','0','0','1000000','SULIS','00043848','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBI-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PBDG-ZEBI-22-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-260604-0014','2026-06-04','1.260','2026-06-04','19:14:07','PLG0011759','1000000','1000000','0','1000000','0','kasirbip','2026-06-04 19:14:06','FJ-260604-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0014','2026-06-04','19:14:07','SULIS','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0032','2026-06-04','2026-06-04 19:14:06','PENJUALAN : FJ-260604-0014','.','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0033','D','2026-06-04','19:14:07','TBC','PENJUALAN','FJ-260604-0014','23317611014','1000000','23318611014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-260604-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-260604-0015','kasirbip','1',' DP-02178DU','TOKO','DUPSN','PSPRT-ZFXB-5-0','CINCIN PERAK ','','1.600','1','100.00','164000','0','0','18100','950000','0','0','0','950000','PUT','00043927','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFXB-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSPRT-ZFXB-5-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-260604-0015','2026-06-04','1.600','2026-06-04','19:20:37','PLG0011760','950000','950000','0','950000','0','kasirbip','2026-06-04 19:20:37','FJ-260604-0015','DP-02178','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-06-04','FJ-260604-0015','2026-06-04','19:20:37','PUT','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-260604-0015' 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-260604-0016','kasirbip',' 1',' DP-02177DU','TOKO','DUPSN','PSPRT-ZEBI-47-0','CINCIN PERAK ','','3.030','1','100.00','310000','0','0','18100','850000','0','0','0','850000','PUT','00043873','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PSPRT-ZEBI-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-260604-0016','2026-06-04','3.030','2026-06-04','19:20:37','PLG0011761','850000','850000','0','850000','0','kasirbip','2026-06-04 19:20:37','FJ-260604-0015','DP-02177','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0016','2026-06-04','19:20:37','PUT','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260604-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0014';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260604-0017','kasirbip','1',' 850K-10-25','TOKO','BIPPER','PBDG-ZEAB-44-0','CINCIN SILVER 925 ','','1.040','1','100.00','107000','0','0','18100','950000','0','0','0','950000','KUR','00043511','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEAB-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PBDG-ZEAB-44-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-260604-0017','2026-06-04','1.040','2026-06-04','19:23:30','PLG0011762','950000','950000','0','950000','0','kasirbip','2026-06-04 19:23:29','FJ-260604-0017','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-04','FJ-260604-0017','2026-06-04','19:23:30','KUR','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260604-0033','2026-06-04','2026-06-04 19:23:29','PENJUALAN : FJ-260604-0017','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0034','D','2026-06-04','19:23:30','TBC','PENJUALAN','FJ-260604-0017','23318611014','950000','23319561014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260604-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0017';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02369','ELLA','1','per','WEDDING RING','','','3.880','','925.00','1','100000','100000','0','700000','1088000','SIZE 14 5 GRF FITRIANA','TANPA MATA CROM PUTIH','MODEL SESUAI CONTOH','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-260604-0034','2026-06-04','2026-06-04 19:29:26','PESANAN : DP-02369','.','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0035','D','2026-06-04','19:29:26','TBC','PESANAN','DP-02369','23319561014','800000','23320361014','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-02369','2026-06-04','2026-06-04','19:29:26','PLG0011763','ELLA','2026-06-18','kasir','2026-06-04 19:29:26','3.880','0','0','0','800000','0','700000','1088000','1088000','288000');
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-02370','ELLA','1','PER','WEDDING RING','','','2.840','','925.00','1','100000','100000','0','700000','984000','SIZE 13 GRF TESYADAR','CRM PUTIH ZIRKON 1 MATA','MODEL SESUAI CONOH','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-260604-0035','2026-06-04','2026-06-04 19:37:58','PESANAN : DP-02370','.','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0036','D','2026-06-04','19:37:58','TBC','PESANAN','DP-02370','23320361014','800000','23321161014','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-02370','2026-06-04','2026-06-04','19:37:58','PLG0011764','ELLA','2026-06-18','kasir','2026-06-04 19:37:58','2.840','0','0','0','800000','0','700000','984000','984000','184000');
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-260604-0018','kasirbip','1',' 1.1K-165-2','TOKO','BIPPER','PBDG-ZDAC-12-0','CINCIN SILVER 925 ','','2.430','1','100.00','249000','0','0','18100','1200000','0','0','0','1200000','KUR','00042479','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAC-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PBDG-ZDAC-12-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-260604-0018','2026-06-04','2.430','2026-06-04','19:49:18','PLG0011765','1200000','1200000','0','1200000','0','kasirbip','2026-06-04 19:49:17','FJ-260604-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-06-04','FJ-260604-0018','2026-06-04','19:49:18','KUR','1200000','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-260604-0036','2026-06-04','2026-06-04 19:49:17','PENJUALAN : FJ-260604-0018','.','TBC','1200000','1200000','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-260604-0037','D','2026-06-04','19:49:18','TBC','PENJUALAN','FJ-260604-0018','23321161014','1200000','23322361014','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='1200000' WHERE no_faktur_jual='FJ-260604-0018' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260604-0019','kasirbip',' 1',' 750K-125-2','TOKO','BIPPER','PBDG-ZDAX-4-0','CINCIN SILVER 925 ','','2.870','1','100.00','293000','0','0','18100','850000','0','0','0','850000','KUR','00042441','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAX-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-06-04' AND kode_barang='PBDG-ZDAX-4-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-260604-0019','2026-06-04','2.870','2026-06-04','19:49:18','PLG0011766','850000','850000','0','850000','0','kasirbip','2026-06-04 19:49:17','FJ-260604-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-06-04','FJ-260604-0019','2026-06-04','19:49:18','KUR','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-260604-0037','2026-06-04','2026-06-04 19:49:17','PENJUALAN : FJ-260604-0019','.','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-260604-0038','D','2026-06-04','19:49:18','TBC','PENJUALAN','FJ-260604-0019','23322361014','850000','23323211014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2050000' WHERE no_faktur_jual='FJ-260604-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260604-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260604-0019';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-04 ','20:32:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-04 ','20:47:13');
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-02371','DIL','1','PLD','WEDD RING','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','SIZE 24 GRF : LE ?? ED (BERKSHIRE)','REQ LEBAR 4MM','CROM PUTIH DOFF MIX GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0038','2026-06-04','2026-06-04 21:30:43','PESANAN : DP-02371','-','TBC','1400000','1400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0039','D','2026-06-04','21:30:43','TBC','PESANAN','DP-02371','23323211014','1400000','23324611014','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-02371','2026-06-04','2026-06-04','21:30:43','PLG0011767','DIL','2026-06-30','sby','2026-06-04 21:30:43','4.000','0','0','0','1400000','0','700000','2100000','2100000','700000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02372','DIL','1','PLD','WEDD RING','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','SIZE 24 GRF : LE ?? ED (BERKSHIRE)','REQ LEBAR 4MM','CROM PUTIH DOFF MIX GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0039','2026-06-04','2026-06-04 21:30:56','PESANAN : DP-02372','-','TBC','1400000','1400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260604-0040','D','2026-06-04','21:30:56','TBC','PESANAN','DP-02372','23324611014','1400000','23326011014','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-02372','2026-06-04','2026-06-04','21:30:56','PLG0011768','DIL','2026-06-30','sby','2026-06-04 21:30:56','4.000','0','0','0','1400000','0','700000','2100000','2100000','700000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02373','DIL','1','PLD','WEDD RING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','PERMATA 1 BUTIR','SIZE 12 GRF : ED ?? LE (BERKSHIRE)','CROM PUTIH DOFF FULL BAGIAN TENGAH YG PINGGIR & DALAM GLOSSY','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260604-0040','2026-06-04','2026-06-04 21:38:42','PESANAN : DP-02373','-','TBC','1100000','1100000');
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-260604-0041','D','2026-06-04','21:38:42','TBC','PESANAN','DP-02373','23326011014','1100000','23327111014','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-02373','2026-06-04','2026-06-04','21:38:42','PLG0011769','DIL','2026-06-30','sby','2026-06-04 21:38:42','2.500','0','0','0','1100000','0','750000','1635000','1635000','535000');