INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-29 ','08:08:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-29 ','08:53:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-29 ','09:40:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-29 ','11:29: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-260629-0001','kasirbip','1',' DP-02506DU','TOKO','DUPSN','PSPRT-ZFBF-26-0','CINCIN PERAK SR-03 YL-01 ','','3.170','1','100.00','324000','0','0','17800','950000','0','0','0','950000','PUT','00044768','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBF-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFBF-26-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-260629-0001','2026-06-29','3.170','2026-06-29','12:32:34','PLG0012614','950000','950000','0','950000','0','kasirbip','2026-06-29 12:32:34','FJ-260629-0001','DP-02506','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-29','FJ-260629-0001','2026-06-29','12:32:34','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-260629-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-29 ','13:13:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-29 ','13:30:26');
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8180500',harga_beli ='8180500' WHERE kode_barcode='00017312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7388000',harga_beli ='7388000' WHERE kode_barcode='00017383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8103500',harga_beli ='8103500' WHERE kode_barcode='00017542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5473000',harga_beli ='5473000' WHERE kode_barcode='00017624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8780000',harga_beli ='8780000' WHERE kode_barcode='00017626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8606000',harga_beli ='8606000' WHERE kode_barcode='00017628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6962500',harga_beli ='6962500' WHERE kode_barcode='00017636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4912500',harga_beli ='4912500' WHERE kode_barcode='00017662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5937500',harga_beli ='5937500' WHERE kode_barcode='00017663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11584500',harga_beli ='11584500' WHERE kode_barcode='00017681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11410500',harga_beli ='11410500' WHERE kode_barcode='00017697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5396000',harga_beli ='5396000' WHERE kode_barcode='00017698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5570000',harga_beli ='5570000' WHERE kode_barcode='00017717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2843000',harga_beli ='2843000' WHERE kode_barcode='00017759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2804500',harga_beli ='2804500' WHERE kode_barcode='00017760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11816500',harga_beli ='11816500' WHERE kode_barcode='00017900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='45679000',harga_beli ='45679000' WHERE kode_barcode='00017913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3965000',harga_beli ='3965000' WHERE kode_barcode='00017959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7736000',harga_beli ='7736000' WHERE kode_barcode='00017982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11719500',harga_beli ='11719500' WHERE kode_barcode='00018019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8073500',harga_beli ='8073500' WHERE kode_barcode='00018036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00018073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='17908000',harga_beli ='17908000' WHERE kode_barcode='00018112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6537000',harga_beli ='6537000' WHERE kode_barcode='00018284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6614000',harga_beli ='6614000' WHERE kode_barcode='00018285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5318500',harga_beli ='5318500' WHERE kode_barcode='00018302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2630500',harga_beli ='2630500' WHERE kode_barcode='00018312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2591500',harga_beli ='2591500' WHERE kode_barcode='00018337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8606000',harga_beli ='8606000' WHERE kode_barcode='00018371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9051000',harga_beli ='9051000' WHERE kode_barcode='00018463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12590000',harga_beli ='12590000' WHERE kode_barcode='00018491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5125000',harga_beli ='5125000' WHERE kode_barcode='00018517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5589000',harga_beli ='5589000' WHERE kode_barcode='00018519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6948500',harga_beli ='6948500' WHERE kode_barcode='00018718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3926000',harga_beli ='3926000' WHERE kode_barcode='00018891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4680500',harga_beli ='4680500' WHERE kode_barcode='00018924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3674500',harga_beli ='3674500' WHERE kode_barcode='00018925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3887500',harga_beli ='3887500' WHERE kode_barcode='00018937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3945500',harga_beli ='3945500' WHERE kode_barcode='00019018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9592500',harga_beli ='9592500' WHERE kode_barcode='00019120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3616500',harga_beli ='3616500' WHERE kode_barcode='00019123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3771500',harga_beli ='3771500' WHERE kode_barcode='00019148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4777000',harga_beli ='4777000' WHERE kode_barcode='00019153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6730000',harga_beli ='6730000' WHERE kode_barcode='00019234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5086500',harga_beli ='5086500' WHERE kode_barcode='00019236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6749500',harga_beli ='6749500' WHERE kode_barcode='00019283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8316000',harga_beli ='8316000' WHERE kode_barcode='00019360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4235500',harga_beli ='4235500' WHERE kode_barcode='00019451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4912500',harga_beli ='4912500' WHERE kode_barcode='00019510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6382000',harga_beli ='6382000' WHERE kode_barcode='00019562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6053500',harga_beli ='6053500' WHERE kode_barcode='00019563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5782500',harga_beli ='5782500' WHERE kode_barcode='00019564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7852000',harga_beli ='7852000' WHERE kode_barcode='00019652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6130500',harga_beli ='6130500' WHERE kode_barcode='00019655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4274000',harga_beli ='4274000' WHERE kode_barcode='00019656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9089500',harga_beli ='9089500' WHERE kode_barcode='00019742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3848500',harga_beli ='3848500' WHERE kode_barcode='00019840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5531000',harga_beli ='5531000' WHERE kode_barcode='00019911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5860000',harga_beli ='5860000' WHERE kode_barcode='00020018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6885000',harga_beli ='6885000' WHERE kode_barcode='00020068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6498000',harga_beli ='6498000' WHERE kode_barcode='00020069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6711000',harga_beli ='6711000' WHERE kode_barcode='00020070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6150000',harga_beli ='6150000' WHERE kode_barcode='00020071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7349000',harga_beli ='7349000' WHERE kode_barcode='00020074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6459500',harga_beli ='6459500' WHERE kode_barcode='00020075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6653000',harga_beli ='6653000' WHERE kode_barcode='00020076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5318500',harga_beli ='5318500' WHERE kode_barcode='00020077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6382000',harga_beli ='6382000' WHERE kode_barcode='00020080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6266000',harga_beli ='6266000' WHERE kode_barcode='00020166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7658500',harga_beli ='7658500' WHERE kode_barcode='00020168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5550500',harga_beli ='5550500' WHERE kode_barcode='00020179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5666500',harga_beli ='5666500' WHERE kode_barcode='00020186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7678000',harga_beli ='7678000' WHERE kode_barcode='00020191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5628000',harga_beli ='5628000' WHERE kode_barcode='00020200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='44526500',harga_beli ='44526500' WHERE kode_barcode='00020223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6150000',harga_beli ='6150000' WHERE kode_barcode='00020259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6711000',harga_beli ='6711000' WHERE kode_barcode='00020365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4603000',harga_beli ='4603000' WHERE kode_barcode='00020492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5492500',harga_beli ='5492500' WHERE kode_barcode='00020616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5067000',harga_beli ='5067000' WHERE kode_barcode='00020834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5183000',harga_beli ='5183000' WHERE kode_barcode='00020846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7426500',harga_beli ='7426500' WHERE kode_barcode='00021113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8374000',harga_beli ='8374000' WHERE kode_barcode='00021253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6111500',harga_beli ='6111500' WHERE kode_barcode='00021254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5879500',harga_beli ='5879500' WHERE kode_barcode='00021280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8645000',harga_beli ='8645000' WHERE kode_barcode='00021405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5015500',harga_beli ='5015500' WHERE kode_barcode='00021475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4037000',harga_beli ='4037000' WHERE kode_barcode='00021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='23242000',harga_beli ='23242000' WHERE kode_barcode='00021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12869000',harga_beli ='12869000' WHERE kode_barcode='00021506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9248000',harga_beli ='9248000' WHERE kode_barcode='00021585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3719000',harga_beli ='3719000' WHERE kode_barcode='00021609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10642500',harga_beli ='10642500' WHERE kode_barcode='00021630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7927000',harga_beli ='7927000' WHERE kode_barcode='00021635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5937500',harga_beli ='5937500' WHERE kode_barcode='00021755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8122500',harga_beli ='8122500' WHERE kode_barcode='00021756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6305000',harga_beli ='6305000' WHERE kode_barcode='00021758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8374000',harga_beli ='8374000' WHERE kode_barcode='00021759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5202500',harga_beli ='5202500' WHERE kode_barcode='00021781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9089500',harga_beli ='9089500' WHERE kode_barcode='00021782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7523000',harga_beli ='7523000' WHERE kode_barcode='00021783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='15046000',harga_beli ='15046000' WHERE kode_barcode='00021815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10753000',harga_beli ='10753000' WHERE kode_barcode='00021835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11894000',harga_beli ='11894000' WHERE kode_barcode='00021844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3939000',harga_beli ='3939000' WHERE kode_barcode='00021867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3939000',harga_beli ='3939000' WHERE kode_barcode='00021876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4599500',harga_beli ='4599500' WHERE kode_barcode='00021878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='14098500',harga_beli ='14098500' WHERE kode_barcode='00021882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10753000',harga_beli ='10753000' WHERE kode_barcode='00021905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4719000',harga_beli ='4719000' WHERE kode_barcode='00021976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5744000',harga_beli ='5744000' WHERE kode_barcode='00021977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5318500',harga_beli ='5318500' WHERE kode_barcode='00021979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5048000',harga_beli ='5048000' WHERE kode_barcode='00021980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6421000',harga_beli ='6421000' WHERE kode_barcode='00022044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5628000',harga_beli ='5628000' WHERE kode_barcode='00022045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7252500',harga_beli ='7252500' WHERE kode_barcode='00022046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5183000',harga_beli ='5183000' WHERE kode_barcode='00022071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5937500',harga_beli ='5937500' WHERE kode_barcode='00022114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7233000',harga_beli ='7233000' WHERE kode_barcode='00022140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5608500',harga_beli ='5608500' WHERE kode_barcode='00022141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00022142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5241000',harga_beli ='5241000' WHERE kode_barcode='00022143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10056500',harga_beli ='10056500' WHERE kode_barcode='00022144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6703500',harga_beli ='6703500' WHERE kode_barcode='00022173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8783000',harga_beli ='8783000' WHERE kode_barcode='00022174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9590500',harga_beli ='9590500' WHERE kode_barcode='00022176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6948500',harga_beli ='6948500' WHERE kode_barcode='00022180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6899500',harga_beli ='6899500' WHERE kode_barcode='00022227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9882500',harga_beli ='9882500' WHERE kode_barcode='00022322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12918000',harga_beli ='12918000' WHERE kode_barcode='00022356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7097500',harga_beli ='7097500' WHERE kode_barcode='00022433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6924000',harga_beli ='6924000' WHERE kode_barcode='00022442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4873500',harga_beli ='4873500' WHERE kode_barcode='00022450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5241000',harga_beli ='5241000' WHERE kode_barcode='00022468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7910000',harga_beli ='7910000' WHERE kode_barcode='00022517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='18006500',harga_beli ='18006500' WHERE kode_barcode='00022649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5554000',harga_beli ='5554000' WHERE kode_barcode='00022758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6973000',harga_beli ='6973000' WHERE kode_barcode='00022759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7462000',harga_beli ='7462000' WHERE kode_barcode='00022765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11229500',harga_beli ='11229500' WHERE kode_barcode='00022774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10324500',harga_beli ='10324500' WHERE kode_barcode='00022806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6826000',harga_beli ='6826000' WHERE kode_barcode='00022808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9174500',harga_beli ='9174500' WHERE kode_barcode='00022809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8734500',harga_beli ='8734500' WHERE kode_barcode='00022867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6801500',harga_beli ='6801500' WHERE kode_barcode='00022883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3655500',harga_beli ='3655500' WHERE kode_barcode='00022912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5222000',harga_beli ='5222000' WHERE kode_barcode='00022950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7001000',harga_beli ='7001000' WHERE kode_barcode='00023060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8856500',harga_beli ='8856500' WHERE kode_barcode='00023123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4873500',harga_beli ='4873500' WHERE kode_barcode='00023126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9167000',harga_beli ='9167000' WHERE kode_barcode='00023146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6266000',harga_beli ='6266000' WHERE kode_barcode='00023437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7560000',harga_beli ='7560000' WHERE kode_barcode='00023488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10501500',harga_beli ='10501500' WHERE kode_barcode='00023490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='42910500',harga_beli ='42910500' WHERE kode_barcode='00023493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='21959500',harga_beli ='21959500' WHERE kode_barcode='00023537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00023549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5763500',harga_beli ='5763500' WHERE kode_barcode='00023563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7117000',harga_beli ='7117000' WHERE kode_barcode='00023572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9805000',harga_beli ='9805000' WHERE kode_barcode='00023585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3771500',harga_beli ='3771500' WHERE kode_barcode='00023590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6216000',harga_beli ='6216000' WHERE kode_barcode='00023593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6144000',harga_beli ='6144000' WHERE kode_barcode='00023594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6096000',harga_beli ='6096000' WHERE kode_barcode='00023595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6788500',harga_beli ='6788500' WHERE kode_barcode='00023596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9744000',harga_beli ='9744000' WHERE kode_barcode='00023600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9696000',harga_beli ='9696000' WHERE kode_barcode='00023602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6936000',harga_beli ='6936000' WHERE kode_barcode='00023604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7536000',harga_beli ='7536000' WHERE kode_barcode='00023605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12312000',harga_beli ='12312000' WHERE kode_barcode='00023606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8040000',harga_beli ='8040000' WHERE kode_barcode='00023607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9792000',harga_beli ='9792000' WHERE kode_barcode='00023608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6960000',harga_beli ='6960000' WHERE kode_barcode='00023609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10896000',harga_beli ='10896000' WHERE kode_barcode='00023611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10176000',harga_beli ='10176000' WHERE kode_barcode='00023612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8112000',harga_beli ='8112000' WHERE kode_barcode='00023613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10200000',harga_beli ='10200000' WHERE kode_barcode='00023614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6168000',harga_beli ='6168000' WHERE kode_barcode='00023617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5260500',harga_beli ='5260500' WHERE kode_barcode='00023622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00023623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='13073500',harga_beli ='13073500' WHERE kode_barcode='00023626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6614000',harga_beli ='6614000' WHERE kode_barcode='00023629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2940000',harga_beli ='2940000' WHERE kode_barcode='00023632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3887500',harga_beli ='3887500' WHERE kode_barcode='00023666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2224500',harga_beli ='2224500' WHERE kode_barcode='00023679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5125000',harga_beli ='5125000' WHERE kode_barcode='00023691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7001000',harga_beli ='7001000' WHERE kode_barcode='00023692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8296500',harga_beli ='8296500' WHERE kode_barcode='00023693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8296500',harga_beli ='8296500' WHERE kode_barcode='00023697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='17279500',harga_beli ='17279500' WHERE kode_barcode='00023704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9437500',harga_beli ='9437500' WHERE kode_barcode='00023760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11712000',harga_beli ='11712000' WHERE kode_barcode='00023815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4042000',harga_beli ='4042000' WHERE kode_barcode='00023830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10733500',harga_beli ='10733500' WHERE kode_barcode='00023843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4320000',harga_beli ='4320000' WHERE kode_barcode='00023848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5705500',harga_beli ='5705500' WHERE kode_barcode='00023857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6266000',harga_beli ='6266000' WHERE kode_barcode='00023907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6072500',harga_beli ='6072500' WHERE kode_barcode='00023913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5280000',harga_beli ='5280000' WHERE kode_barcode='00023917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5928000',harga_beli ='5928000' WHERE kode_barcode='00023920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6189000',harga_beli ='6189000' WHERE kode_barcode='00023934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2998000',harga_beli ='2998000' WHERE kode_barcode='00023964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7678000',harga_beli ='7678000' WHERE kode_barcode='00023965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8496000',harga_beli ='8496000' WHERE kode_barcode='00023979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5202500',harga_beli ='5202500' WHERE kode_barcode='00023985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8780000',harga_beli ='8780000' WHERE kode_barcode='00023991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6498000',harga_beli ='6498000' WHERE kode_barcode='00023997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7097500',harga_beli ='7097500' WHERE kode_barcode='00023998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6827000',harga_beli ='6827000' WHERE kode_barcode='00024000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9031500',harga_beli ='9031500' WHERE kode_barcode='00024004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5202500',harga_beli ='5202500' WHERE kode_barcode='00024013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8304000',harga_beli ='8304000' WHERE kode_barcode='00024038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5067000',harga_beli ='5067000' WHERE kode_barcode='00024062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7291000',harga_beli ='7291000' WHERE kode_barcode='00024069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3152500',harga_beli ='3152500' WHERE kode_barcode='00024077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5164000',harga_beli ='5164000' WHERE kode_barcode='00024085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5028500',harga_beli ='5028500' WHERE kode_barcode='00024086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4104000',harga_beli ='4104000' WHERE kode_barcode='00024095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7446000',harga_beli ='7446000' WHERE kode_barcode='00024096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6730000',harga_beli ='6730000' WHERE kode_barcode='00024104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7755000',harga_beli ='7755000' WHERE kode_barcode='00024148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5995500',harga_beli ='5995500' WHERE kode_barcode='00024186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5898500',harga_beli ='5898500' WHERE kode_barcode='00024189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11120000',harga_beli ='11120000' WHERE kode_barcode='00024193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4293500',harga_beli ='4293500' WHERE kode_barcode='00024194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6053500',harga_beli ='6053500' WHERE kode_barcode='00024363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6962500',harga_beli ='6962500' WHERE kode_barcode='00025284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7426500',harga_beli ='7426500' WHERE kode_barcode='00025286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='14098500',harga_beli ='14098500' WHERE kode_barcode='00025510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='17947000',harga_beli ='17947000' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='15383500',harga_beli ='15383500' WHERE kode_barcode='00026302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8064500',harga_beli ='8064500' WHERE kode_barcode='00026725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5376500',harga_beli ='5376500' WHERE kode_barcode='00026884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3075000',harga_beli ='3075000' WHERE kode_barcode='00026926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5492500',harga_beli ='5492500' WHERE kode_barcode='00026927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9515000',harga_beli ='9515000' WHERE kode_barcode='00026952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5318500',harga_beli ='5318500' WHERE kode_barcode='00027033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10656000',harga_beli ='10656000' WHERE kode_barcode='00027034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5570000',harga_beli ='5570000' WHERE kode_barcode='00027038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5164000',harga_beli ='5164000' WHERE kode_barcode='00027050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4951000',harga_beli ='4951000' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3442500',harga_beli ='3442500' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='16786500',harga_beli ='16786500' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4506500',harga_beli ='4506500' WHERE kode_barcode='00027229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5086500',harga_beli ='5086500' WHERE kode_barcode='00027334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4344000',harga_beli ='4344000' WHERE kode_barcode='00027480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12609500',harga_beli ='12609500' WHERE kode_barcode='00027482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2050000',harga_beli ='2050000' WHERE kode_barcode='00027795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7948500',harga_beli ='7948500' WHERE kode_barcode='00027945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6432000',harga_beli ='6432000' WHERE kode_barcode='00028046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4835000',harga_beli ='4835000' WHERE kode_barcode='00028107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11681000',harga_beli ='11681000' WHERE kode_barcode='00028220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11544000',harga_beli ='11544000' WHERE kode_barcode='00028368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7872000',harga_beli ='7872000' WHERE kode_barcode='00028381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10559500',harga_beli ='10559500' WHERE kode_barcode='00028442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3504000',harga_beli ='3504000' WHERE kode_barcode='00028566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7581000',harga_beli ='7581000' WHERE kode_barcode='00028582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6401500',harga_beli ='6401500' WHERE kode_barcode='00028682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5357000',harga_beli ='5357000' WHERE kode_barcode='00028692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9048000',harga_beli ='9048000' WHERE kode_barcode='00028772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4989500',harga_beli ='4989500' WHERE kode_barcode='00029136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4224000',harga_beli ='4224000' WHERE kode_barcode='00029506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9786000',harga_beli ='9786000' WHERE kode_barcode='00029526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5280000',harga_beli ='5280000' WHERE kode_barcode='00029662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12576000',harga_beli ='12576000' WHERE kode_barcode='00030349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4622500',harga_beli ='4622500' WHERE kode_barcode='00030671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7104000',harga_beli ='7104000' WHERE kode_barcode='00030672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6000000',harga_beli ='6000000' WHERE kode_barcode='00030674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3552000',harga_beli ='3552000' WHERE kode_barcode='00030709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3528000',harga_beli ='3528000' WHERE kode_barcode='00030714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4320000',harga_beli ='4320000' WHERE kode_barcode='00030716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4200000',harga_beli ='4200000' WHERE kode_barcode='00030719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3912000',harga_beli ='3912000' WHERE kode_barcode='00030721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6168000',harga_beli ='6168000' WHERE kode_barcode='00030821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4545000',harga_beli ='4545000' WHERE kode_barcode='00030827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2031000',harga_beli ='2031000' WHERE kode_barcode='00031061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2011500',harga_beli ='2011500' WHERE kode_barcode='00031062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1934000',harga_beli ='1934000' WHERE kode_barcode='00031064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3230000',harga_beli ='3230000' WHERE kode_barcode='00031066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3887500',harga_beli ='3887500' WHERE kode_barcode='00031069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3558500',harga_beli ='3558500' WHERE kode_barcode='00031070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3520000',harga_beli ='3520000' WHERE kode_barcode='00031071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5821500',harga_beli ='5821500' WHERE kode_barcode='00031112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8142000',harga_beli ='8142000' WHERE kode_barcode='00031113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6150000',harga_beli ='6150000' WHERE kode_barcode='00031114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3442500',harga_beli ='3442500' WHERE kode_barcode='00031115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3094500',harga_beli ='3094500' WHERE kode_barcode='00031116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8424000',harga_beli ='8424000' WHERE kode_barcode='00031117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='20809000',harga_beli ='20809000' WHERE kode_barcode='00031126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='19242500',harga_beli ='19242500' WHERE kode_barcode='00031175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6691500',harga_beli ='6691500' WHERE kode_barcode='00031182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7440000',harga_beli ='7440000' WHERE kode_barcode='00031184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6600000',harga_beli ='6600000' WHERE kode_barcode='00031187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12072000',harga_beli ='12072000' WHERE kode_barcode='00031190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5688000',harga_beli ='5688000' WHERE kode_barcode='00031191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='33359000',harga_beli ='33359000' WHERE kode_barcode='00031203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='17639500',harga_beli ='17639500' WHERE kode_barcode='00031204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5840500',harga_beli ='5840500' WHERE kode_barcode='00031267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5028500',harga_beli ='5028500' WHERE kode_barcode='00031268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7600500',harga_beli ='7600500' WHERE kode_barcode='00031269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7446000',harga_beli ='7446000' WHERE kode_barcode='00031270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4409500',harga_beli ='4409500' WHERE kode_barcode='00031272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5086500',harga_beli ='5086500' WHERE kode_barcode='00031274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5434500',harga_beli ='5434500' WHERE kode_barcode='00031276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6633500',harga_beli ='6633500' WHERE kode_barcode='00031277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4970500',harga_beli ='4970500' WHERE kode_barcode='00031278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5028500',harga_beli ='5028500' WHERE kode_barcode='00031279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4699500',harga_beli ='4699500' WHERE kode_barcode='00031280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6382000',harga_beli ='6382000' WHERE kode_barcode='00031282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6285500',harga_beli ='6285500' WHERE kode_barcode='00031283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6653000',harga_beli ='6653000' WHERE kode_barcode='00031284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3152500',harga_beli ='3152500' WHERE kode_barcode='00031286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3481500',harga_beli ='3481500' WHERE kode_barcode='00031287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6401500',harga_beli ='6401500' WHERE kode_barcode='00031333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7194500',harga_beli ='7194500' WHERE kode_barcode='00031335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3829500',harga_beli ='3829500' WHERE kode_barcode='00031337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5744000',harga_beli ='5744000' WHERE kode_barcode='00031382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00031383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4100000',harga_beli ='4100000' WHERE kode_barcode='00031385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4081000',harga_beli ='4081000' WHERE kode_barcode='00031386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2707500',harga_beli ='2707500' WHERE kode_barcode='00031387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6769000',harga_beli ='6769000' WHERE kode_barcode='00031390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4912500',harga_beli ='4912500' WHERE kode_barcode='00031391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3172000',harga_beli ='3172000' WHERE kode_barcode='00031392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4854500',harga_beli ='4854500' WHERE kode_barcode='00031394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7020500',harga_beli ='7020500' WHERE kode_barcode='00031396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5821500',harga_beli ='5821500' WHERE kode_barcode='00031397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6421000',harga_beli ='6421000' WHERE kode_barcode='00031399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8238500',harga_beli ='8238500' WHERE kode_barcode='00031401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6305000',harga_beli ='6305000' WHERE kode_barcode='00031402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4622500',harga_beli ='4622500' WHERE kode_barcode='00031404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5086500',harga_beli ='5086500' WHERE kode_barcode='00031406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5067000',harga_beli ='5067000' WHERE kode_barcode='00031407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6440000',harga_beli ='6440000' WHERE kode_barcode='00031409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5898500',harga_beli ='5898500' WHERE kode_barcode='00031410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7194500',harga_beli ='7194500' WHERE kode_barcode='00031411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5241000',harga_beli ='5241000' WHERE kode_barcode='00031413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00031414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5183000',harga_beli ='5183000' WHERE kode_barcode='00031416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7600500',harga_beli ='7600500' WHERE kode_barcode='00031454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6923500',harga_beli ='6923500' WHERE kode_barcode='00031461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8400000',harga_beli ='8400000' WHERE kode_barcode='00031492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6696000',harga_beli ='6696000' WHERE kode_barcode='00031493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5396000',harga_beli ='5396000' WHERE kode_barcode='00031494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4255000',harga_beli ='4255000' WHERE kode_barcode='00031495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4854500',harga_beli ='4854500' WHERE kode_barcode='00031496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6575500',harga_beli ='6575500' WHERE kode_barcode='00031498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6363000',harga_beli ='6363000' WHERE kode_barcode='00031502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6343500',harga_beli ='6343500' WHERE kode_barcode='00031504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4796500',harga_beli ='4796500' WHERE kode_barcode='00031514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6264000',harga_beli ='6264000' WHERE kode_barcode='00031516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4272000',harga_beli ='4272000' WHERE kode_barcode='00031517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6792000',harga_beli ='6792000' WHERE kode_barcode='00031521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5952000',harga_beli ='5952000' WHERE kode_barcode='00031522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9024000',harga_beli ='9024000' WHERE kode_barcode='00031523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2901000',harga_beli ='2901000' WHERE kode_barcode='00031533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4728000',harga_beli ='4728000' WHERE kode_barcode='00031563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6120000',harga_beli ='6120000' WHERE kode_barcode='00031565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='00031566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3984000',harga_beli ='3984000' WHERE kode_barcode='00031568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6150000',harga_beli ='6150000' WHERE kode_barcode='00031584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3752000',harga_beli ='3752000' WHERE kode_barcode='00031585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7248000',harga_beli ='7248000' WHERE kode_barcode='00031588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3210500',harga_beli ='3210500' WHERE kode_barcode='00031590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3965000',harga_beli ='3965000' WHERE kode_barcode='00031591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6034000',harga_beli ='6034000' WHERE kode_barcode='00031595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3456000',harga_beli ='3456000' WHERE kode_barcode='00031599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3168000',harga_beli ='3168000' WHERE kode_barcode='00031600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9912000',harga_beli ='9912000' WHERE kode_barcode='00031613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8915500',harga_beli ='8915500' WHERE kode_barcode='00031616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5280000',harga_beli ='5280000' WHERE kode_barcode='00031619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3597500',harga_beli ='3597500' WHERE kode_barcode='00031633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3674500',harga_beli ='3674500' WHERE kode_barcode='00031634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='16895500',harga_beli ='16895500' WHERE kode_barcode='00031636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2904000',harga_beli ='2904000' WHERE kode_barcode='00031637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4951000',harga_beli ='4951000' WHERE kode_barcode='00031658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7488000',harga_beli ='7488000' WHERE kode_barcode='00031747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6208000',harga_beli ='6208000' WHERE kode_barcode='00031754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='16148500',harga_beli ='16148500' WHERE kode_barcode='00031755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3249000',harga_beli ='3249000' WHERE kode_barcode='00031756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6624000',harga_beli ='6624000' WHERE kode_barcode='00031818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5376500',harga_beli ='5376500' WHERE kode_barcode='00031819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5592000',harga_beli ='5592000' WHERE kode_barcode='00031820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8400000',harga_beli ='8400000' WHERE kode_barcode='00031821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3056000',harga_beli ='3056000' WHERE kode_barcode='00031823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7632000',harga_beli ='7632000' WHERE kode_barcode='00031824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6769000',harga_beli ='6769000' WHERE kode_barcode='00031825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2448000',harga_beli ='2448000' WHERE kode_barcode='00031829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4139000',harga_beli ='4139000' WHERE kode_barcode='00031856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6288000',harga_beli ='6288000' WHERE kode_barcode='00031857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9816000',harga_beli ='9816000' WHERE kode_barcode='00031895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7136500',harga_beli ='7136500' WHERE kode_barcode='00031896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6904500',harga_beli ='6904500' WHERE kode_barcode='00031897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5879500',harga_beli ='5879500' WHERE kode_barcode='00031905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6575500',harga_beli ='6575500' WHERE kode_barcode='00031911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='20731500',harga_beli ='20731500' WHERE kode_barcode='00031914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2998000',harga_beli ='2998000' WHERE kode_barcode='00031968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='16477000',harga_beli ='16477000' WHERE kode_barcode='00031969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4448000',harga_beli ='4448000' WHERE kode_barcode='00032093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6305000',harga_beli ='6305000' WHERE kode_barcode='00032094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3597500',harga_beli ='3597500' WHERE kode_barcode='00032213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2089000',harga_beli ='2089000' WHERE kode_barcode='00032215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='23884000',harga_beli ='23884000' WHERE kode_barcode='00032356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='16380500',harga_beli ='16380500' WHERE kode_barcode='00032357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2572500',harga_beli ='2572500' WHERE kode_barcode='00032358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4777000',harga_beli ='4777000' WHERE kode_barcode='00032360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00032361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4255000',harga_beli ='4255000' WHERE kode_barcode='00032362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00032364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5918000',harga_beli ='5918000' WHERE kode_barcode='00032370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='15897000',harga_beli ='15897000' WHERE kode_barcode='00032375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3720000',harga_beli ='3720000' WHERE kode_barcode='00032376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2147000',harga_beli ='2147000' WHERE kode_barcode='00032377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3268500',harga_beli ='3268500' WHERE kode_barcode='00032379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9612000',harga_beli ='9612000' WHERE kode_barcode='00032381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6498000',harga_beli ='6498000' WHERE kode_barcode='00032498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7658500',harga_beli ='7658500' WHERE kode_barcode='00032499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10985000',harga_beli ='10985000' WHERE kode_barcode='00032501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5904000',harga_beli ='5904000' WHERE kode_barcode='00032504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='13415500',harga_beli ='13415500' WHERE kode_barcode='00032505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6144000',harga_beli ='6144000' WHERE kode_barcode='00032507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7488000',harga_beli ='7488000' WHERE kode_barcode='00032509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6960000',harga_beli ='6960000' WHERE kode_barcode='00032513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='28583000',harga_beli ='28583000' WHERE kode_barcode='00032523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11120000',harga_beli ='11120000' WHERE kode_barcode='00032649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7536000',harga_beli ='7536000' WHERE kode_barcode='00032667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9186500',harga_beli ='9186500' WHERE kode_barcode='00032670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='15647500',harga_beli ='15647500' WHERE kode_barcode='00033184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6498000',harga_beli ='6498000' WHERE kode_barcode='00033220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5338000',harga_beli ='5338000' WHERE kode_barcode='00033261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2514500',harga_beli ='2514500' WHERE kode_barcode='00033262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2359500',harga_beli ='2359500' WHERE kode_barcode='00033264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7488000',harga_beli ='7488000' WHERE kode_barcode='00033289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='21196000',harga_beli ='21196000' WHERE kode_barcode='00033485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3810000',harga_beli ='3810000' WHERE kode_barcode='00034068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3442500',harga_beli ='3442500' WHERE kode_barcode='00034069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4661000',harga_beli ='4661000' WHERE kode_barcode='00034070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4448000',harga_beli ='4448000' WHERE kode_barcode='00034071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3152500',harga_beli ='3152500' WHERE kode_barcode='00034073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3307000',harga_beli ='3307000' WHERE kode_barcode='00034075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1799000',harga_beli ='1799000' WHERE kode_barcode='00034076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3442500',harga_beli ='3442500' WHERE kode_barcode='00034080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4931500',harga_beli ='4931500' WHERE kode_barcode='00034142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7117000',harga_beli ='7117000' WHERE kode_barcode='00034164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3752000',harga_beli ='3752000' WHERE kode_barcode='00034166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3674500',harga_beli ='3674500' WHERE kode_barcode='00034167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5164000',harga_beli ='5164000' WHERE kode_barcode='00034347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3036500',harga_beli ='3036500' WHERE kode_barcode='00034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5260500',harga_beli ='5260500' WHERE kode_barcode='00034349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7987500',harga_beli ='7987500' WHERE kode_barcode='00034354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00034355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4893000',harga_beli ='4893000' WHERE kode_barcode='00034356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4332000',harga_beli ='4332000' WHERE kode_barcode='00034357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4197000',harga_beli ='4197000' WHERE kode_barcode='00034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3056000',harga_beli ='3056000' WHERE kode_barcode='00034373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3017000',harga_beli ='3017000' WHERE kode_barcode='00034374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9012000',harga_beli ='9012000' WHERE kode_barcode='00034381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11661500',harga_beli ='11661500' WHERE kode_barcode='00034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4176000',harga_beli ='4176000' WHERE kode_barcode='00034661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3816000',harga_beli ='3816000' WHERE kode_barcode='00035018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2688500',harga_beli ='2688500' WHERE kode_barcode='00035045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7194500',harga_beli ='7194500' WHERE kode_barcode='00035046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3500500',harga_beli ='3500500' WHERE kode_barcode='00035171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10636500',harga_beli ='10636500' WHERE kode_barcode='00035278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5802000',harga_beli ='5802000' WHERE kode_barcode='00035477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4274000',harga_beli ='4274000' WHERE kode_barcode='00035519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1102500',harga_beli ='1102500' WHERE kode_barcode='00035951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10176000',harga_beli ='10176000' WHERE kode_barcode='00036172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='00036243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='812500',harga_beli ='812500' WHERE kode_barcode='00036245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1934000',harga_beli ='1934000' WHERE kode_barcode='00036432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3094500',harga_beli ='3094500' WHERE kode_barcode='00036686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4390000',harga_beli ='4390000' WHERE kode_barcode='00036992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4042000',harga_beli ='4042000' WHERE kode_barcode='00037325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5821500',harga_beli ='5821500' WHERE kode_barcode='00037332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6324000',harga_beli ='6324000' WHERE kode_barcode='00037825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00037907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4080000',harga_beli ='4080000' WHERE kode_barcode='00038024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00038455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2707500',harga_beli ='2707500' WHERE kode_barcode='00038674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4970500',harga_beli ='4970500' WHERE kode_barcode='00038843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3133000',harga_beli ='3133000' WHERE kode_barcode='00039179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2533500',harga_beli ='2533500' WHERE kode_barcode='00039180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2011500',harga_beli ='2011500' WHERE kode_barcode='00039181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5918000',harga_beli ='5918000' WHERE kode_barcode='00039192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5318500',harga_beli ='5318500' WHERE kode_barcode='00039193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3288000',harga_beli ='3288000' WHERE kode_barcode='00039194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11359000',harga_beli ='11359000' WHERE kode_barcode='00039381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3790500',harga_beli ='3790500' WHERE kode_barcode='00039405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7497000',harga_beli ='7497000' WHERE kode_barcode='00040395' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10922000',harga_beli ='10922000' WHERE kode_barcode='00040869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4911000',harga_beli ='4911000' WHERE kode_barcode='00040871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='00041095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4448000',harga_beli ='4448000' WHERE kode_barcode='00041096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3404000',harga_beli ='3404000' WHERE kode_barcode='00041097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6285500',harga_beli ='6285500' WHERE kode_barcode='00041099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7310500',harga_beli ='7310500' WHERE kode_barcode='00041100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00041101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4912500',harga_beli ='4912500' WHERE kode_barcode='00041102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6792000',harga_beli ='6792000' WHERE kode_barcode='00041103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3500500',harga_beli ='3500500' WHERE kode_barcode='00041104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2707500',harga_beli ='2707500' WHERE kode_barcode='00041105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1528000',harga_beli ='1528000' WHERE kode_barcode='00041106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6537000',harga_beli ='6537000' WHERE kode_barcode='00041108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3597500',harga_beli ='3597500' WHERE kode_barcode='00041109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7755000',harga_beli ='7755000' WHERE kode_barcode='00041110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7871000',harga_beli ='7871000' WHERE kode_barcode='00041111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7658500',harga_beli ='7658500' WHERE kode_barcode='00041112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7716500',harga_beli ='7716500' WHERE kode_barcode='00041113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7233000',harga_beli ='7233000' WHERE kode_barcode='00041114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='14452000',harga_beli ='14452000' WHERE kode_barcode='00041180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8668000',harga_beli ='8668000' WHERE kode_barcode='00041280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8200000',harga_beli ='8200000' WHERE kode_barcode='00041414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5033000',harga_beli ='5033000' WHERE kode_barcode='00042238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2883500',harga_beli ='2883500' WHERE kode_barcode='00042487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3636000',harga_beli ='3636000' WHERE kode_barcode='00042503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6785000',harga_beli ='6785000' WHERE kode_barcode='00042736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7059000',harga_beli ='7059000' WHERE kode_barcode='00043558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4680500',harga_beli ='4680500' WHERE kode_barcode='00043942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='20279500',harga_beli ='20279500' WHERE kode_barcode='00044442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='14312500',harga_beli ='14312500' WHERE kode_barcode='00044446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='22472000',harga_beli ='22472000' WHERE kode_barcode='00044723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2959000',harga_beli ='2959000' WHERE kode_barcode='00044730' LIMIT 1;
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2330000','kasir','2026-06-29 13:31:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-29 ','14:22:10');
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-260629-0002','kasir','1',' 500K-165-1','TOKO','MMPER','PMM-ZFAG-1-0','CINCIN SILVER 925 YL-01 ','','1.910','1','100.00','195000','0','0','17800','600000','0','0','0','600000','ALIKA','00044487','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFAG-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PMM-ZFAG-1-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-260629-0002','2026-06-29','1.910','2026-06-29','15:08:48','PLG0012615','600000','600000','0','600000','0','kasir','2026-06-29 15:08:47','FJ-260629-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-29','FJ-260629-0002','2026-06-29','15:08:48','ALIKA','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-260629-0001','2026-06-29','2026-06-29 15:08:47','PENJUALAN : FJ-260629-0002','0','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-260629-0002','D','2026-06-29','15:08:48','TBC','PENJUALAN','FJ-260629-0002','24278759064','600000','24279359064','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='600000' WHERE no_faktur_jual='FJ-260629-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260629-0003','kasir',' 1',' 950K-13-10','TOKO','MMPER','PMM-ZFBD-39-0','CINCIN SILVER 925 ','','1.920','1','100.00','196000','0','0','17800','1050000','0','0','0','1050000','ALIKA','00044694','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFBD-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PMM-ZFBD-39-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-260629-0003','2026-06-29','1.920','2026-06-29','15:08:48','PLG0012616','1050000','1050000','0','1050000','0','kasir','2026-06-29 15:08:47','FJ-260629-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-29','FJ-260629-0003','2026-06-29','15:08:48','ALIKA','1050000','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-260629-0002','2026-06-29','2026-06-29 15:08:47','PENJUALAN : FJ-260629-0003','0','TBC','1050000','1050000','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-260629-0003','D','2026-06-29','15:08:48','TBC','PENJUALAN','FJ-260629-0003','24279359064','1050000','24280409064','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='1650000' WHERE no_faktur_jual='FJ-260629-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-29 ','15:32:04');
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-02703','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','950000','0','950000','cowo size 17 grf Ridi model yl01','cewe size12 grf Zaki model SR 02 sirkon 1 dof semprot','font vladimir','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-260629-0003','2026-06-29','2026-06-29 15:45:31','PESANAN : DP-02703','.','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-260629-0004','D','2026-06-29','15:45:31','TBC','PESANAN','DP-02703','24280409064','950000','24281359064','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-02703','2026-06-29','2026-06-29','15:45:31','PLG0012617','KUR','2026-07-18','kasirbip','2026-06-29 15:45:31','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-29 ','15:54:31');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02704','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','SIZE: 19','GRF: Anam ?? Fina FONT: VINTAGE ROTTER','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-260629-0004','2026-06-29','2026-06-29 15:59:09','PESANAN : DP-02704','-','TBC','1700000','1700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260629-0005','D','2026-06-29','15:59:09','TBC','PESANAN','DP-02704','24281359064','1700000','24283059064','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-02704','2026-06-29','2026-06-29','15:59:09','PLG0012618','VAN','2026-08-27','sby','2026-06-29 15:59:09','4.000','0','0','0','1700000','0','750000','2950000','2950000','1250000');
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-02705','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','SIZE: 19','GRF: Anam ?? Fina FONT: VINTAGE ROTTER','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-260629-0005','2026-06-29','2026-06-29 15:59:11','PESANAN : DP-02705','-','TBC','1700000','1700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260629-0006','D','2026-06-29','15:59:11','TBC','PESANAN','DP-02705','24283059064','1700000','24284759064','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-02705','2026-06-29','2026-06-29','15:59:11','PLG0012619','VAN','2026-08-27','sby','2026-06-29 15:59:11','4.000','0','0','0','1700000','0','750000','2950000','2950000','1250000');
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-260629-0004','kasirbip','1',' DP-02504BI','TOKO','BIPPSN','PSPRT-ZFAI-4-0','CINCIN PERAK YL-01 ','','3.170','1','100.00','324000','0','0','17800','850000','0','0','0','850000','SULIS','00044592','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFAI-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFAI-4-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-260629-0004','2026-06-29','3.170','2026-06-29','16:03:54','PLG0012620','850000','850000','0','850000','0','kasirbip','2026-06-29 16:03:53','FJ-260629-0004','DP-02504','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-29','FJ-260629-0004','2026-06-29','16:03:54','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260629-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0004';
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-260629-0005','kasirbip','1',' DP-02388BI','TOKO','BIPPSN','PSPRT-ZFBD-41-0','CINCIN PERAK YL-01 ','','2.830','1','100.00','289000','0','0','17800','850000','0','0','0','850000','SULIS','00044696','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.830',berat_jual_asli=berat_jual_asli+'2.830',stock_jual='1',berat_akhir=berat_akhir-'2.830',berat_akhir_asli=berat_akhir_asli-'2.830',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFBD-41-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-260629-0005','2026-06-29','2.830','2026-06-29','16:10:53','PLG0012621','850000','850000','0','850000','0','kasirbip','2026-06-29 16:10:52','FJ-260629-0005','DP-02388','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-29','FJ-260629-0005','2026-06-29','16:10:53','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260629-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260629-0006','kasirbip','1',' DP-02403BI','TOKO','BIPPSN','PSPRT-ZFBD-48-0','CINCIN PERAK ','','3.660','1','100.00','374000','0','0','17800','950000','0','0','0','950000','SULIS','00044703','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.660',berat_jual_asli=berat_jual_asli+'3.660',stock_jual='1',berat_akhir=berat_akhir-'3.660',berat_akhir_asli=berat_akhir_asli-'3.660',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFBD-48-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-260629-0006','2026-06-29','3.660','2026-06-29','16:13:31','PLG0012622','950000','950000','0','950000','0','kasirbip','2026-06-29 16:13:30','FJ-260629-0006','DP-02403','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-29','FJ-260629-0006','2026-06-29','16:13:31','SULIS','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-260629-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-260629-0007','kasirbip',' 1',' DP-02402BI','TOKO','BIPPSN','PSPRT-ZFBD-59-0','CINCIN PERAK ','','1.710','1','100.00','175000','0','0','17800','1100000','0','0','0','1100000','SULIS','00044714','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFBD-59-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-260629-0007','2026-06-29','1.710','2026-06-29','16:13:31','PLG0012623','1100000','1100000','0','1100000','0','kasirbip','2026-06-29 16:13:30','FJ-260629-0006','DP-02402','1100000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','FJ-260629-0007','2026-06-29','16:13:31','SULIS','1100000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260629-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0007';
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-260629-0008','kasirbip','1',' DP-02270BI','TOKO','BIPPSN','PSPRT-ZFBF-13-0','CINCIN PERAK ','','2.330','1','100.00','238000','0','0','17800','850000','0','0','0','850000','SAL','00044755','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBF-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFBF-13-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-260629-0008','2026-06-29','2.330','2026-06-29','16:16:00','PLG0012624','850000','850000','0','850000','0','kasirbip','2026-06-29 16:15:59','FJ-260629-0008','DP-02270','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-29','FJ-260629-0008','2026-06-29','16:16:00','SAL','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-260629-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260629-0009','kasirbip',' 1',' DP-02269BI','TOKO','BIPPSN','PSPRT-ZFBF-14-0','CINCIN PERAK ','','2.260','1','100.00','232000','0','0','17800','1250000','0','0','0','1250000','SAL','00044756','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBF-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFBF-14-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-260629-0009','2026-06-29','2.260','2026-06-29','16:16:00','PLG0012625','1250000','1250000','0','1250000','0','kasirbip','2026-06-29 16:15:59','FJ-260629-0008','DP-02269','1250000');
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-29','FJ-260629-0009','2026-06-29','16:16:00','SAL','1250000','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-260629-0009' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02146','SULIS','1','CCN SILVER','KROM PUTIH GLOSSY 1 ZIRKON','2.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-260629-0006','2026-06-29','2026-06-29 16:19:00','SERVICE : SV-02146','.','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-260629-0007','D','2026-06-29','16:19:00','TBC','SERVICE','SV-02146','24284759064','50000','24284809064','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-02146','2026-06-29','2026-06-29','16:19:00','PLG0012626','kasirbip','2026-07-15','kasirbip','2026-06-29 16:19:00','2.000','0','0','0','50000','0','50000','50000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-29 ','16:41:59');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-06-29 16:42:09');
CREATE TABLE th_20260629_164209 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260629_164209_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BIPPSN' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-06-29',jam_taking= '16:42:17',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BIPPSN' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-06-29',jam_taking= '16:42:29',input_by='kasir';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02147','SAL','1','SEPASANG CCN SILVER','CWE SIZE 6 5 FONT VLADIMIR','4.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-02147','2026-06-29','2026-06-29','17:37:51','PLG0012627','kasirbip','2026-06-30','kasirbip','2026-06-29 17:37:51','4.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-260629-0010','kasirbip','1',' 600K-15-00','TOKO','DUPERBDG','LXPER-ZDAF-56-0','CINCIN SILVER 925 ','','1.540','1','100.00','158000','0','0','17800','700000','0','0','0','700000','KUR','00042651','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDAF-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='LXPER-ZDAF-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260629-0010','2026-06-29','1.540','2026-06-29','17:46:56','PLG0012628','700000','700000','0','700000','0','kasirbip','2026-06-29 17:46:55','FJ-260629-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-29','FJ-260629-0010','2026-06-29','17:46:56','KUR','700000','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-260629-0007','2026-06-29','2026-06-29 17:46:55','PENJUALAN : FJ-260629-0010','.','TBC','700000','700000','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-260629-0008','D','2026-06-29','17:46:56','TBC','PENJUALAN','FJ-260629-0010','24284809064','700000','24285509064','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='700000' WHERE no_faktur_jual='FJ-260629-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0010';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260629-0011','kasirbip','1',' DP-02519BI','TOKO','BIPPSN','PSPLT-ZFBF-44-0','CINCIN PALADIUM ','','4.330','1','17.00','972000','0','0','17800','2315500','0','0','0','2315500','KUR','00044786','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.330',berat_jual_asli=berat_jual_asli+'4.330',stock_jual='1',berat_akhir=berat_akhir-'4.330',berat_akhir_asli=berat_akhir_asli-'4.330',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPLT-ZFBF-44-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-260629-0011','2026-06-29','4.330','2026-06-29','18:17:48','PLG0012629','2315500','2315500','0','2315500','0','kasirbip','2026-06-29 18:17:48','FJ-260629-0011','DP-02519','2240000');
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-29','FJ-260629-0011','2026-06-29','18:17:48','KUR','2315500','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-260629-0008','2026-06-29','2026-06-29 18:17:48','PENJUALAN : FJ-260629-0011','.','TBC','75500','75500','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-260629-0009','D','2026-06-29','18:17:48','TBC','PENJUALAN','FJ-260629-0011','24285509064','75500','24285584564','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='75500' WHERE no_faktur_jual='FJ-260629-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0011';
UPDATE tt_service_head SET tgl_selesai='2026-06-29',  status ='DONE' WHERE no_service='SV-02133';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02133';
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-29',  status ='CLOS' WHERE no_service='SV-02133';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02133';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02148','SULIS','1','CCN SILVER','SZ 10 5 TAMBAH BAHAN JGN DIBUAT TIPIS GRF JGN HILANG FONT VINTAGE ROTTER','2.000','1','100000','100000');
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-260629-0009','2026-06-29','2026-06-29 18:49:38','SERVICE : SV-02148','.','TBC','100000','100000','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-260629-0010','D','2026-06-29','18:49:38','TBC','SERVICE','SV-02148','24285584564','100000','24285684564','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-02148','2026-06-29','2026-06-29','18:49:38','PLG0012630','kasirbip','2026-07-14','kasirbip','2026-06-29 18:49:38','2.000','0','0','0','100000','0','100000','100000','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-260629-0012','sby','1',' DP-02307SB','TOKO','SBYPSN','PSPLT-ZFBD-21-0','CINCIN PALADIUM ','','4.830','1','32.00','2041000','0','0','17800','3417000','0','0','0','3417000','DIL','00044676','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBD-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.830',berat_jual_asli=berat_jual_asli+'4.830',stock_jual='1',berat_akhir=berat_akhir-'4.830',berat_akhir_asli=berat_akhir_asli-'4.830',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPLT-ZFBD-21-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-260629-0012','2026-06-29','4.830','2026-06-29','19:26:01','PLG0012631','3417000','3417000','0','3417000','0','sby','2026-06-29 19:26:00','FJ-260629-0012','DP-02307','2400000');
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-29','FJ-260629-0012','2026-06-29','19:26:01','DIL','3417000','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-260629-0010','2026-06-29','2026-06-29 19:26:00','PENJUALAN : FJ-260629-0012','','TBC','1017000','1017000','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-260629-0011','D','2026-06-29','19:26:01','TBC','PENJUALAN','FJ-260629-0012','24285684564','1017000','24286701564','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='1017000' WHERE no_faktur_jual='FJ-260629-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-260629-0013','kasir','1',' 750K-115-1','TOKO','MMPER','PMM-ZFBD-33-0','CINCIN SILVER 925 ','','1.680','1','100.00','172000','0','0','17800','850000','0','0','0','850000','ELLA','00044688','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFBD-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PMM-ZFBD-33-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-260629-0013','2026-06-29','1.680','2026-06-29','19:33:43','PLG0012632','850000','850000','0','850000','0','kasir','2026-06-29 19:33:43','FJ-260629-0013','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','FJ-260629-0013','2026-06-29','19:33:43','ELLA','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260629-0011','2026-06-29','2026-06-29 19:33:43','PENJUALAN : FJ-260629-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-260629-0012','D','2026-06-29','19:33:43','TBC','PENJUALAN','FJ-260629-0013','24286701564','850000','24287551564','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-260629-0013' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260629-0014','kasir',' 1',' 700K-12-00','TOKO','MMPER','PMM-YIXH-26-0','CINCIN SILVER 925 ','','1.710','1','100.00','44000','0','0','17800','800000','0','0','0','800000','ELLA','00038620','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIXH-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PMM-YIXH-26-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-260629-0014','2026-06-29','1.710','2026-06-29','19:33:43','PLG0012633','800000','800000','0','800000','0','kasir','2026-06-29 19:33:43','FJ-260629-0013','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','FJ-260629-0014','2026-06-29','19:33:43','ELLA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260629-0012','2026-06-29','2026-06-29 19:33:43','PENJUALAN : FJ-260629-0014','0','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260629-0013','D','2026-06-29','19:33:43','TBC','PENJUALAN','FJ-260629-0014','24287551564','800000','24288351564','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='1650000' WHERE no_faktur_jual='FJ-260629-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-260629-0015','kasirbip','1',' DP-02513BI','TOKO','BIPPSN','PSPRT-ZFBD-57-0','CINCIN PERAK SR-03 YL-01 ','','3.390','1','100.00','346000','0','0','17800','1050000','0','0','0','1050000','SULIS','00044712','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.390',berat_jual_asli=berat_jual_asli+'3.390',stock_jual='1',berat_akhir=berat_akhir-'3.390',berat_akhir_asli=berat_akhir_asli-'3.390',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='PSPRT-ZFBD-57-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-260629-0015','2026-06-29','3.390','2026-06-29','19:47:38','PLG0012634','1050000','1050000','0','1050000','0','kasirbip','2026-06-29 19:47:37','FJ-260629-0015','DP-02513','1050000');
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-29','FJ-260629-0015','2026-06-29','19:47:38','SULIS','1050000','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-260629-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260629-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260629-0015';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-30','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-29';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-29' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','TBC','SALDO AWAL','SALDO AWAL','0','24288351564','24288351564');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','','SALDO AWAL','SALDO AWAL','0','250000','250000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','21:18:12','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
UPDATE tp_system SET tgl_system='2026-06-30';