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,status_otorisasi,harga_skrg) VALUES ('F226240824171','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-YLAE-92-0','GL X TIFF SLEP VAR HW 8K ','','1.650','1','100.00','1897000','0','0','15000','1898000','0','0','0','1898000','NS','00381070','F3E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAE-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='F3E-YLAE-92-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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) VALUES ('F226240824171','2026-04-24','1.650','2026-04-24','08:24:17','PLG0079355','1898000','1898000','0','1898000','1898000','kasir','2026-04-24 08:24:17','F22624082417');
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-04-24','F226240824171','2026-04-24','08:24:17','NS','1898000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0002','D','2026-04-24','08:24:17','kasir','PENJUALAN','F226240824171','8824605000','1898000','8826503000');
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,status_otorisasi,harga_skrg) VALUES ('F226240832181','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZDBC-77-T','LT SLOBOK BULAT HURUF BG N 8K ','OL','0.680','1','100.00','796000','0','0','15000','806000','0','5000','0','811000','TIN','T0078958','D1F','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDBC-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='D1F-ZDBC-77-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F226240832181','2026-04-24','0.680','2026-04-24','08:32:18','PLG0079356','806000','806000','5000','811000','811000','kasir','2026-04-24 08:32:18','F22624083218');
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-04-24','F226240832181','2026-04-24','08:32:18','TIN','811000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0003','D','2026-04-24','08:32:18','kasir','PENJUALAN','F226240832181','8826503000','811000','8827314000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='811000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240832181' 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,status_otorisasi,harga_skrg) VALUES ('F226240832182','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZDBA-6-T','GW TRIXIE PANJANG MODEL MATA LG 8K ','OL','0.480','1','100.00','552000','0','0','15000','559000','0','5000','0','564000','TIN','T0078777','B1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBA-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='B1E-ZDBA-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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) VALUES ('F226240832182','2026-04-24','0.480','2026-04-24','08:32:18','PLG0079357','559000','559000','5000','564000','564000','kasir','2026-04-24 08:32:18','F22624083218');
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-04-24','F226240832182','2026-04-24','08:32:18','TIN','564000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0004','D','2026-04-24','08:32:18','kasir','PENJUALAN','F226240832182','8827314000','564000','8827878000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='564000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240832182' 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,status_otorisasi,harga_skrg) VALUES ('F226240832183','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZDAC-26-T','KL SIEM COBRA KH 42CM 8K ','OL','1.280','1','100.00','1472000','0','0','15000','1485000','0','6000','0','1491000','TIN','T0078645','H1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAC-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='H1E-ZDAC-26-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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) VALUES ('F226240832183','2026-04-24','1.280','2026-04-24','08:32:18','PLG0079358','1485000','1485000','6000','1491000','1491000','kasir','2026-04-24 08:32:18','F22624083218');
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-04-24','F226240832183','2026-04-24','08:32:18','TIN','1491000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0005','D','2026-04-24','08:32:18','kasir','PENJUALAN','F226240832183','8827878000','1491000','8829369000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1491000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240832183' 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,status_otorisasi,harga_skrg) VALUES ('F226240909391','kasir','1',' TEH1 X HW ','TOKO','TBK-H','H1TE-ZDXD-168-T','KL X SANTA HW 42CM 17K ','OLS DXVQQ','2.080','1','100.00','4368000','0','0','15000','4369000','0','224000','0','4593000','RHM','T0078455','H1TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZDXD-168-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='H1TE-ZDXD-168-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' 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) VALUES ('F226240909391','2026-04-24','2.080','2026-04-24','09:09:39','PLG0079359','4369000','4369000','224000','4593000','4593000','kasir','2026-04-24 09:09:39','F22624090939');
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-04-24','F226240909391','2026-04-24','09:09:39','RHM','4593000','224000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0006','D','2026-04-24','09:09:39','kasir','PENJUALAN','F226240909391','8829369000','4593000','8833962000');
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,status_otorisasi,harga_skrg) VALUES ('F226240910361','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YGBI-99-T','LT SLOBOK BULAT HURUF BG F 8K ','OLS S8KT2','0.550','1','100.00','654000','0','0','15000','666000','0','108000','0','774000','RHM','T0071632','D1G','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YGBI-99-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='D1G-YGBI-99-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F226240910361','2026-04-24','0.550','2026-04-24','09:10:36','PLG0079360','666000','666000','108000','774000','774000','kasir','2026-04-24 09:10:36','F22624091036');
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-04-24','F226240910361','2026-04-24','09:10:36','RHM','774000','108000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0007','D','2026-04-24','09:10:36','kasir','PENJUALAN','F226240910361','8833962000','774000','8834736000');
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11840500',harga_beli ='11840500' WHERE kode_barcode='T0003259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='15820500',harga_beli ='15820500' WHERE kode_barcode='T0003262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3681500',harga_beli ='3681500' WHERE kode_barcode='T0003283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0003285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9850500',harga_beli ='9850500' WHERE kode_barcode='T0003292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9910500',harga_beli ='9910500' WHERE kode_barcode='T0003293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11980000',harga_beli ='11980000' WHERE kode_barcode='T0003304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003330' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0003819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9751000',harga_beli ='9751000' WHERE kode_barcode='T0003820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7462500',harga_beli ='7462500' WHERE kode_barcode='T0003829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='4119500',harga_beli ='4119500' WHERE kode_barcode='T0003841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5990000',harga_beli ='5990000' WHERE kode_barcode='T0003842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3940500',harga_beli ='3940500' WHERE kode_barcode='T0003846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2925500',harga_beli ='2925500' WHERE kode_barcode='T0003847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2905500',harga_beli ='2905500' WHERE kode_barcode='T0003851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0005809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='13771000',harga_beli ='13771000' WHERE kode_barcode='T0014670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9850500',harga_beli ='9850500' WHERE kode_barcode='T0022027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0016549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0016550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0016552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0032890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0034703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0036020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3940500',harga_beli ='3940500' WHERE kode_barcode='T0036741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0036748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7860500',harga_beli ='7860500' WHERE kode_barcode='T0038725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0041548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9910500',harga_beli ='9910500' WHERE kode_barcode='T0041584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9990000',harga_beli ='9990000' WHERE kode_barcode='T0041591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0041593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='15920000',harga_beli ='15920000' WHERE kode_barcode='T0041600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9890500',harga_beli ='9890500' WHERE kode_barcode='T0041601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='13930000',harga_beli ='13930000' WHERE kode_barcode='T0041604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11940000',harga_beli ='11940000' WHERE kode_barcode='T0041605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='19900000',harga_beli ='19900000' WHERE kode_barcode='T0041606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0042437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0042438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='19900000',harga_beli ='19900000' WHERE kode_barcode='T0044138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0044139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0044142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0044147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11940000',harga_beli ='11940000' WHERE kode_barcode='T0044148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5791000',harga_beli ='5791000' WHERE kode_barcode='T0048326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0048337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3940500',harga_beli ='3940500' WHERE kode_barcode='T0052735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0056329' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0056331' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0056336' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0056344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1950500',harga_beli ='1950500' WHERE kode_barcode='T0056663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0056667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0056668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3920500',harga_beli ='3920500' WHERE kode_barcode='T0056671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0056676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0056680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0056799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7920500',harga_beli ='7920500' WHERE kode_barcode='T0059362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0068704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0068706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0069572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0071250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='T0074495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1015000',harga_beli ='1015000' WHERE kode_barcode='T0074496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='T0074497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0074498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='T0074499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1015000',harga_beli ='1015000' WHERE kode_barcode='T0074501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1015000',harga_beli ='1015000' WHERE kode_barcode='T0074503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0074506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='T0074507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1015000',harga_beli ='1015000' WHERE kode_barcode='T0074508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0074510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1094500',harga_beli ='1094500' WHERE kode_barcode='T0074512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1035000',harga_beli ='1035000' WHERE kode_barcode='T0074513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0074514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0074515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1015000',harga_beli ='1015000' WHERE kode_barcode='T0074516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0074517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3880500',harga_beli ='3880500' WHERE kode_barcode='T0074528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0074529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0074531' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0074532' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0074533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0076175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1015000',harga_beli ='1015000' WHERE kode_barcode='T0076177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0076179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0076182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0076183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='935500',harga_beli ='935500' WHERE kode_barcode='T0076191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0076192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0076207' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1930500',harga_beli ='1930500' WHERE kode_barcode='T0076208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0076209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0076210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5930500',harga_beli ='5930500' WHERE kode_barcode='T0076211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3920500',harga_beli ='3920500' WHERE kode_barcode='T0076212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0076213' LIMIT 1;
UPDATE tm_group SET harga='1990000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1990000','admin','2026-04-24 09:33:40');
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2815500',harga_beli ='2815500' WHERE kode_barcode='T0072901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='T0072910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1925500',harga_beli ='1925500' WHERE kode_barcode='T0072914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2380500',harga_beli ='2380500' WHERE kode_barcode='T0072908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3167500',harga_beli ='3167500' WHERE kode_barcode='T0062918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3353500',harga_beli ='3353500' WHERE kode_barcode='T0062921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='5858500',harga_beli ='5858500' WHERE kode_barcode='T0062929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3705500',harga_beli ='3705500' WHERE kode_barcode='T0064209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4554000',harga_beli ='4554000' WHERE kode_barcode='T0065414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3829500',harga_beli ='3829500' WHERE kode_barcode='T0065420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4161000',harga_beli ='4161000' WHERE kode_barcode='T0065975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2960500',harga_beli ='2960500' WHERE kode_barcode='T0067225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2070000',harga_beli ='2070000' WHERE kode_barcode='T0067226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4720000',harga_beli ='4720000' WHERE kode_barcode='T0067241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='T0078250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1904500',harga_beli ='1904500' WHERE kode_barcode='T0078244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='5382000',harga_beli ='5382000' WHERE kode_barcode='T0068870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2380500',harga_beli ='2380500' WHERE kode_barcode='T0069895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3001500',harga_beli ='3001500' WHERE kode_barcode='T0069921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2318500',harga_beli ='2318500' WHERE kode_barcode='T0070410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3478000',harga_beli ='3478000' WHERE kode_barcode='T0070449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2836000',harga_beli ='2836000' WHERE kode_barcode='T0070455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='5175000',harga_beli ='5175000' WHERE kode_barcode='T0070460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4078000',harga_beli ='4078000' WHERE kode_barcode='T0070757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3126000',harga_beli ='3126000' WHERE kode_barcode='T0078252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2256500',harga_beli ='2256500' WHERE kode_barcode='T0071212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2070000',harga_beli ='2070000' WHERE kode_barcode='T0071227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4243500',harga_beli ='4243500' WHERE kode_barcode='T0071502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3933000',harga_beli ='3933000' WHERE kode_barcode='T0072931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2691000',harga_beli ='2691000' WHERE kode_barcode='T0072928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2898000',harga_beli ='2898000' WHERE kode_barcode='T0072926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0072590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2008000',harga_beli ='2008000' WHERE kode_barcode='T0072596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4927000',harga_beli ='4927000' WHERE kode_barcode='T0072618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3540000',harga_beli ='3540000' WHERE kode_barcode='T0072958' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2587500',harga_beli ='2587500' WHERE kode_barcode='T0072961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3105000',harga_beli ='3105000' WHERE kode_barcode='T0073003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2380500',harga_beli ='2380500' WHERE kode_barcode='T0078251' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4968000',harga_beli ='4968000' WHERE kode_barcode='T0078238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2236000',harga_beli ='2236000' WHERE kode_barcode='T0078245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4616500',harga_beli ='4616500' WHERE kode_barcode='T0073683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4202500',harga_beli ='4202500' WHERE kode_barcode='T0073686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2070000',harga_beli ='2070000' WHERE kode_barcode='T0073688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3064000',harga_beli ='3064000' WHERE kode_barcode='T0073691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4057500',harga_beli ='4057500' WHERE kode_barcode='T0073726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4078000',harga_beli ='4078000' WHERE kode_barcode='T0073727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3146500',harga_beli ='3146500' WHERE kode_barcode='T0073743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='8218000',harga_beli ='8218000' WHERE kode_barcode='T0074527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3788500',harga_beli ='3788500' WHERE kode_barcode='T0078247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2277000',harga_beli ='2277000' WHERE kode_barcode='T0078248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3892000',harga_beli ='3892000' WHERE kode_barcode='T0078236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0078237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2919000',harga_beli ='2919000' WHERE kode_barcode='T0075667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2380500',harga_beli ='2380500' WHERE kode_barcode='T0075669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3001500',harga_beli ='3001500' WHERE kode_barcode='T0075676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4264500',harga_beli ='4264500' WHERE kode_barcode='T0075683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2691000',harga_beli ='2691000' WHERE kode_barcode='T0075684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4099000',harga_beli ='4099000' WHERE kode_barcode='T0075686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4306000',harga_beli ='4306000' WHERE kode_barcode='T0075687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3829500',harga_beli ='3829500' WHERE kode_barcode='T0075690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2794500',harga_beli ='2794500' WHERE kode_barcode='T0075697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3126000',harga_beli ='3126000' WHERE kode_barcode='T0075698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2153000',harga_beli ='2153000' WHERE kode_barcode='T0075700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4140000',harga_beli ='4140000' WHERE kode_barcode='T0075703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1966500',harga_beli ='1966500' WHERE kode_barcode='T0075705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4140000',harga_beli ='4140000' WHERE kode_barcode='T0076202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4057500',harga_beli ='4057500' WHERE kode_barcode='T0076203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1925500',harga_beli ='1925500' WHERE kode_barcode='T0076204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1966500',harga_beli ='1966500' WHERE kode_barcode='T0076206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2091000',harga_beli ='2091000' WHERE kode_barcode='T0076758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3167500',harga_beli ='3167500' WHERE kode_barcode='T0076761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3892000',harga_beli ='3892000' WHERE kode_barcode='T0076762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4161000',harga_beli ='4161000' WHERE kode_barcode='T0076772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4181500',harga_beli ='4181500' WHERE kode_barcode='T0076773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2008000',harga_beli ='2008000' WHERE kode_barcode='T0078249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2111500',harga_beli ='2111500' WHERE kode_barcode='T0078393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2484000',harga_beli ='2484000' WHERE kode_barcode='T0078394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='T0078395' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2380500',harga_beli ='2380500' WHERE kode_barcode='T0078397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2380500',harga_beli ='2380500' WHERE kode_barcode='T0078409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2753500',harga_beli ='2753500' WHERE kode_barcode='T0078410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1966500',harga_beli ='1966500' WHERE kode_barcode='T0078412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1718500',harga_beli ='1718500' WHERE kode_barcode='T0078413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='1697500',harga_beli ='1697500' WHERE kode_barcode='T0078414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2629000',harga_beli ='2629000' WHERE kode_barcode='T0078415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='T0078416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2505000',harga_beli ='2505000' WHERE kode_barcode='T0078423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4802500',harga_beli ='4802500' WHERE kode_barcode='T0078428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='4471500',harga_beli ='4471500' WHERE kode_barcode='T0078429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2587500',harga_beli ='2587500' WHERE kode_barcode='T0078430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3146500',harga_beli ='3146500' WHERE kode_barcode='T0078438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2070000',harga_beli ='2070000' WHERE kode_barcode='T0078439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2029000',harga_beli ='2029000' WHERE kode_barcode='T0078464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2132500',harga_beli ='2132500' WHERE kode_barcode='T0078466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='T0078477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0078478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2029000',harga_beli ='2029000' WHERE kode_barcode='T0078479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='2091000',harga_beli ='2091000' WHERE kode_barcode='T0078480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3167500',harga_beli ='3167500' WHERE kode_barcode='T0078481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3105000',harga_beli ='3105000' WHERE kode_barcode='T0078483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2070000',harga_jual='3622500',harga_beli ='3622500' WHERE kode_barcode='T0078484' LIMIT 1;
UPDATE tm_group SET harga='2070000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','2070000','admin','2026-04-24 09:34:03');
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2508000',harga_beli ='2508000' WHERE kode_barcode='T0001219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='41904500',harga_beli ='41904500' WHERE kode_barcode='T0001397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2341000',harga_beli ='2341000' WHERE kode_barcode='T0003166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1985500',harga_beli ='1985500' WHERE kode_barcode='T0008353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='T0008357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='T0012058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='T0015578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2403500',harga_beli ='2403500' WHERE kode_barcode='T0040036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1484000',harga_beli ='1484000' WHERE kode_barcode='T0027957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3720500',harga_beli ='3720500' WHERE kode_barcode='T0029930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2236500',harga_beli ='2236500' WHERE kode_barcode='T0034478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2403500',harga_beli ='2403500' WHERE kode_barcode='T0034479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1296000',harga_beli ='1296000' WHERE kode_barcode='T0034489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='T0034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1317000',harga_beli ='1317000' WHERE kode_barcode='T0034492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1191500',harga_beli ='1191500' WHERE kode_barcode='T0037257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='T0037655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3511500',harga_beli ='3511500' WHERE kode_barcode='T0037708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2821500',harga_beli ='2821500' WHERE kode_barcode='T0038063' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4034000',harga_beli ='4034000' WHERE kode_barcode='T0038064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4075500',harga_beli ='4075500' WHERE kode_barcode='T0040939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='13480500',harga_beli ='13480500' WHERE kode_barcode='T0041108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2362000',harga_beli ='2362000' WHERE kode_barcode='T0041488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4201000',harga_beli ='4201000' WHERE kode_barcode='T0045140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1484000',harga_beli ='1484000' WHERE kode_barcode='T0041808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1630500',harga_beli ='1630500' WHERE kode_barcode='T0041884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='982500',harga_beli ='982500' WHERE kode_barcode='T0042082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4096500',harga_beli ='4096500' WHERE kode_barcode='T0042141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='9886000',harga_beli ='9886000' WHERE kode_barcode='T0042168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4911500',harga_beli ='4911500' WHERE kode_barcode='T0042862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3616000',harga_beli ='3616000' WHERE kode_barcode='T0043167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1923000',harga_beli ='1923000' WHERE kode_barcode='T0043446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2006500',harga_beli ='2006500' WHERE kode_barcode='T0043447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='14776500',harga_beli ='14776500' WHERE kode_barcode='T0043497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='21004500',harga_beli ='21004500' WHERE kode_barcode='T0043498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1463000',harga_beli ='1463000' WHERE kode_barcode='T0043536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='T0043539' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2403500',harga_beli ='2403500' WHERE kode_barcode='T0044004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6395500',harga_beli ='6395500' WHERE kode_barcode='T0078255' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='T0045061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2717000',harga_beli ='2717000' WHERE kode_barcode='T0045361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='5497000',harga_beli ='5497000' WHERE kode_barcode='T0045441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='19479000',harga_beli ='19479000' WHERE kode_barcode='T0045473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='16615500',harga_beli ='16615500' WHERE kode_barcode='T0045476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4201000',harga_beli ='4201000' WHERE kode_barcode='T0046025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1379500',harga_beli ='1379500' WHERE kode_barcode='T0046035' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2947000',harga_beli ='2947000' WHERE kode_barcode='T0046593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3469500',harga_beli ='3469500' WHERE kode_barcode='T0048156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1526000',harga_beli ='1526000' WHERE kode_barcode='T0048379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2048500',harga_beli ='2048500' WHERE kode_barcode='T0048717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4180000',harga_beli ='4180000' WHERE kode_barcode='T0049361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4180000',harga_beli ='4180000' WHERE kode_barcode='T0049362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3302500',harga_beli ='3302500' WHERE kode_barcode='T0049588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='12122000',harga_beli ='12122000' WHERE kode_barcode='T0050434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4932500',harga_beli ='4932500' WHERE kode_barcode='T0050859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3720500',harga_beli ='3720500' WHERE kode_barcode='T0050949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1944000',harga_beli ='1944000' WHERE kode_barcode='T0051654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='14003000',harga_beli ='14003000' WHERE kode_barcode='T0052837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1254000',harga_beli ='1254000' WHERE kode_barcode='T0052864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3030500',harga_beli ='3030500' WHERE kode_barcode='T0053132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='T0054076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2236500',harga_beli ='2236500' WHERE kode_barcode='T0054257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1985500',harga_beli ='1985500' WHERE kode_barcode='T0054761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6165500',harga_beli ='6165500' WHERE kode_barcode='T0056238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8172000',harga_beli ='8172000' WHERE kode_barcode='T0056761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1317000',harga_beli ='1317000' WHERE kode_barcode='T0057062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1170500',harga_beli ='1170500' WHERE kode_barcode='T0058703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2717000',harga_beli ='2717000' WHERE kode_barcode='T0058776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1338000',harga_beli ='1338000' WHERE kode_barcode='T0059284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4452000',harga_beli ='4452000' WHERE kode_barcode='T0059319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1149500',harga_beli ='1149500' WHERE kode_barcode='T0059389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2947000',harga_beli ='2947000' WHERE kode_barcode='T0059417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='T0059422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3030500',harga_beli ='3030500' WHERE kode_barcode='T0059436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3051500',harga_beli ='3051500' WHERE kode_barcode='T0059443' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='T0060254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6291000',harga_beli ='6291000' WHERE kode_barcode='T0061866' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1693000',harga_beli ='1693000' WHERE kode_barcode='T0062347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4075500',harga_beli ='4075500' WHERE kode_barcode='T0062552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4096500',harga_beli ='4096500' WHERE kode_barcode='T0062553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4138500',harga_beli ='4138500' WHERE kode_barcode='T0062554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='5225000',harga_beli ='5225000' WHERE kode_barcode='T0078265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3198000',harga_beli ='3198000' WHERE kode_barcode='T0065489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='21172000',harga_beli ='21172000' WHERE kode_barcode='T0078268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1609500',harga_beli ='1609500' WHERE kode_barcode='T0067228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4661000',harga_beli ='4661000' WHERE kode_barcode='T0067256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6897000',harga_beli ='6897000' WHERE kode_barcode='T0078266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='14588500',harga_beli ='14588500' WHERE kode_barcode='T0068897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4744500',harga_beli ='4744500' WHERE kode_barcode='T0078256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6333000',harga_beli ='6333000' WHERE kode_barcode='T0078272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6061000',harga_beli ='6061000' WHERE kode_barcode='T0069479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1254000',harga_beli ='1254000' WHERE kode_barcode='T0078239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='14839000',harga_beli ='14839000' WHERE kode_barcode='T0078262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4243000',harga_beli ='4243000' WHERE kode_barcode='T0069930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6500000',harga_beli ='6500000' WHERE kode_barcode='T0070139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10492000',harga_beli ='10492000' WHERE kode_barcode='T0070146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4117500',harga_beli ='4117500' WHERE kode_barcode='T0070482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6103000',harga_beli ='6103000' WHERE kode_barcode='T0070484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4075500',harga_beli ='4075500' WHERE kode_barcode='T0070537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='T0070876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='T0071214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='T0071225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='T0071226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='21004500',harga_beli ='21004500' WHERE kode_barcode='T0071496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='5538500',harga_beli ='5538500' WHERE kode_barcode='T0071664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='12644500',harga_beli ='12644500' WHERE kode_barcode='T0078261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='16615500',harga_beli ='16615500' WHERE kode_barcode='T0078263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1505000',harga_beli ='1505000' WHERE kode_barcode='T0072995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='20733000',harga_beli ='20733000' WHERE kode_barcode='T0073694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='T0073734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1400500',harga_beli ='1400500' WHERE kode_barcode='T0073735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='T0073751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='9405000',harga_beli ='9405000' WHERE kode_barcode='T0073766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2926000',harga_beli ='2926000' WHERE kode_barcode='T0073777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3260500',harga_beli ='3260500' WHERE kode_barcode='T0073778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8611000',harga_beli ='8611000' WHERE kode_barcode='T0078254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10763500',harga_beli ='10763500' WHERE kode_barcode='T0074485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1170500',harga_beli ='1170500' WHERE kode_barcode='T0074483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4243000',harga_beli ='4243000' WHERE kode_barcode='T0074536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='14651000',harga_beli ='14651000' WHERE kode_barcode='T0074539' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3260500',harga_beli ='3260500' WHERE kode_barcode='T0074551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='2989000',harga_beli ='2989000' WHERE kode_barcode='T0078270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1149500',harga_beli ='1149500' WHERE kode_barcode='T0075661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='T0075663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='T0075664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='T0075673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='T0075674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='T0075679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6416500',harga_beli ='6416500' WHERE kode_barcode='T0075710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6291000',harga_beli ='6291000' WHERE kode_barcode='T0075711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8276500',harga_beli ='8276500' WHERE kode_barcode='T0075712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3971000',harga_beli ='3971000' WHERE kode_barcode='T0075713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='12080500',harga_beli ='12080500' WHERE kode_barcode='T0075714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='16720000',harga_beli ='16720000' WHERE kode_barcode='T0075720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='21130000',harga_beli ='21130000' WHERE kode_barcode='T0075722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='16783000',harga_beli ='16783000' WHERE kode_barcode='T0075725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4389000',harga_beli ='4389000' WHERE kode_barcode='T0075726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='5915000',harga_beli ='5915000' WHERE kode_barcode='T0075733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='11390500',harga_beli ='11390500' WHERE kode_barcode='T0075734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8924500',harga_beli ='8924500' WHERE kode_barcode='T0075735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6667500',harga_beli ='6667500' WHERE kode_barcode='T0075740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6709000',harga_beli ='6709000' WHERE kode_barcode='T0075790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='7775000',harga_beli ='7775000' WHERE kode_barcode='T0075798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='11453500',harga_beli ='11453500' WHERE kode_barcode='T0075804' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8527500',harga_beli ='8527500' WHERE kode_barcode='T0075805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='7022500',harga_beli ='7022500' WHERE kode_barcode='T0075809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='961500',harga_beli ='961500' WHERE kode_barcode='T0076174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10262000',harga_beli ='10262000' WHERE kode_barcode='T0076216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='12122000',harga_beli ='12122000' WHERE kode_barcode='T0076217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6228500',harga_beli ='6228500' WHERE kode_barcode='T0076220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6625500',harga_beli ='6625500' WHERE kode_barcode='T0076757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='3114500',harga_beli ='3114500' WHERE kode_barcode='T0076759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6542000',harga_beli ='6542000' WHERE kode_barcode='T0078463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='T0078388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='T0078398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='T0078399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='T0078401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1254000',harga_beli ='1254000' WHERE kode_barcode='T0078402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1588500',harga_beli ='1588500' WHERE kode_barcode='T0078403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1170500',harga_beli ='1170500' WHERE kode_barcode='T0078404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1630500',harga_beli ='1630500' WHERE kode_barcode='T0078405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='982500',harga_beli ='982500' WHERE kode_barcode='T0078406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1630500',harga_beli ='1630500' WHERE kode_barcode='T0078419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1317000',harga_beli ='1317000' WHERE kode_barcode='T0078420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='T0078421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='T0078422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1505000',harga_beli ='1505000' WHERE kode_barcode='T0078433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1317000',harga_beli ='1317000' WHERE kode_barcode='T0078436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4243000',harga_beli ='4243000' WHERE kode_barcode='T0078441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4326500',harga_beli ='4326500' WHERE kode_barcode='T0078442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10408500',harga_beli ='10408500' WHERE kode_barcode='T0078443' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='7628500',harga_beli ='7628500' WHERE kode_barcode='T0078444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='7357000',harga_beli ='7357000' WHERE kode_barcode='T0078445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='5894000',harga_beli ='5894000' WHERE kode_barcode='T0078446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='7315000',harga_beli ='7315000' WHERE kode_barcode='T0078447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='5476000',harga_beli ='5476000' WHERE kode_barcode='T0078448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4284500',harga_beli ='4284500' WHERE kode_barcode='T0078449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6270000',harga_beli ='6270000' WHERE kode_barcode='T0078450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4180000',harga_beli ='4180000' WHERE kode_barcode='T0078451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10471000',harga_beli ='10471000' WHERE kode_barcode='T0078452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8569000',harga_beli ='8569000' WHERE kode_barcode='T0078453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4284500',harga_beli ='4284500' WHERE kode_barcode='T0078454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10659000',harga_beli ='10659000' WHERE kode_barcode='T0078456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8506500',harga_beli ='8506500' WHERE kode_barcode='T0078457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8360000',harga_beli ='8360000' WHERE kode_barcode='T0078458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6312000',harga_beli ='6312000' WHERE kode_barcode='T0078459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10450000',harga_beli ='10450000' WHERE kode_barcode='T0078460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='4347500',harga_beli ='4347500' WHERE kode_barcode='T0078474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='T0078476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10680000',harga_beli ='10680000' WHERE kode_barcode='T0078486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='6291000',harga_beli ='6291000' WHERE kode_barcode='T0078487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8485500',harga_beli ='8485500' WHERE kode_barcode='T0078488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='8464500',harga_beli ='8464500' WHERE kode_barcode='T0078490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2090000',harga_jual='10387500',harga_beli ='10387500' WHERE kode_barcode='T0078491' LIMIT 1;
UPDATE tm_group SET harga='2090000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','2090000','admin','2026-04-24 09:34:15');
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1688000',harga_beli ='1688000' WHERE kode_barcode='T0000044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='31355000',harga_beli ='31355000' WHERE kode_barcode='T0001415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='T0002468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1625000',harga_beli ='1625000' WHERE kode_barcode='T0002469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='T0002494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6182500',harga_beli ='6182500' WHERE kode_barcode='T0012557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4325500',harga_beli ='4325500' WHERE kode_barcode='T0012620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4494500',harga_beli ='4494500' WHERE kode_barcode='T0013082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='T0014678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='10487000',harga_beli ='10487000' WHERE kode_barcode='T0017016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8229000',harga_beli ='8229000' WHERE kode_barcode='T0023440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='T0032937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='10655500',harga_beli ='10655500' WHERE kode_barcode='T0033573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6077000',harga_beli ='6077000' WHERE kode_barcode='T0033671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='31692500',harga_beli ='31692500' WHERE kode_barcode='T0034311' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='53088000',harga_beli ='53088000' WHERE kode_barcode='T0034312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1920500',harga_beli ='1920500' WHERE kode_barcode='T0034698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4325500',harga_beli ='4325500' WHERE kode_barcode='T0034737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6246000',harga_beli ='6246000' WHERE kode_barcode='T0037228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4325500',harga_beli ='4325500' WHERE kode_barcode='T0037454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8714500',harga_beli ='8714500' WHERE kode_barcode='T0037627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4241500',harga_beli ='4241500' WHERE kode_barcode='T0037699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='T0037893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='15002500',harga_beli ='15002500' WHERE kode_barcode='T0038298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1625000',harga_beli ='1625000' WHERE kode_barcode='T0039590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4747500',harga_beli ='4747500' WHERE kode_barcode='T0039612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='12491500',harga_beli ='12491500' WHERE kode_barcode='T0041140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1793500',harga_beli ='1793500' WHERE kode_barcode='T0041492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='T0041557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='T0041810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1815000',harga_beli ='1815000' WHERE kode_barcode='T0041814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='T0041819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1604000',harga_beli ='1604000' WHERE kode_barcode='T0042026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8482500',harga_beli ='8482500' WHERE kode_barcode='T0042126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5507500',harga_beli ='5507500' WHERE kode_barcode='T0042504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='T0042808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5929500',harga_beli ='5929500' WHERE kode_barcode='T0042838' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='T0042916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='T0042918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='42348000',harga_beli ='42348000' WHERE kode_barcode='T0045326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2469000',harga_beli ='2469000' WHERE kode_barcode='T0045357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='T0045758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1013000',harga_beli ='1013000' WHERE kode_barcode='T0047314' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='T0049385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8567000',harga_beli ='8567000' WHERE kode_barcode='T0049654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1899000',harga_beli ='1899000' WHERE kode_barcode='T0049970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3967000',harga_beli ='3967000' WHERE kode_barcode='T0049980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5908000',harga_beli ='5908000' WHERE kode_barcode='T0050008' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6541000',harga_beli ='6541000' WHERE kode_barcode='T0050444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6119000',harga_beli ='6119000' WHERE kode_barcode='T0050811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6013500',harga_beli ='6013500' WHERE kode_barcode='T0051681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='16943500',harga_beli ='16943500' WHERE kode_barcode='T0052702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6330000',harga_beli ='6330000' WHERE kode_barcode='T0054298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6224500',harga_beli ='6224500' WHERE kode_barcode='T0054299' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='T0054785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5613000',harga_beli ='5613000' WHERE kode_barcode='T0056246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='T0056745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2047000',harga_beli ='2047000' WHERE kode_barcode='T0057060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='20931500',harga_beli ='20931500' WHERE kode_barcode='T0057545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='25320000',harga_beli ='25320000' WHERE kode_barcode='T0057546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='12660000',harga_beli ='12660000' WHERE kode_barcode='T0059273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1899000',harga_beli ='1899000' WHERE kode_barcode='T0059357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1688000',harga_beli ='1688000' WHERE kode_barcode='T0059358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1266000',harga_beli ='1266000' WHERE kode_barcode='T0059393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5950500',harga_beli ='5950500' WHERE kode_barcode='T0059464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='10487000',harga_beli ='10487000' WHERE kode_barcode='T0059474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='T0060831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6035000',harga_beli ='6035000' WHERE kode_barcode='T0062956' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6119000',harga_beli ='6119000' WHERE kode_barcode='T0065438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='T0065947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4283500',harga_beli ='4283500' WHERE kode_barcode='T0067233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8545500',harga_beli ='8545500' WHERE kode_barcode='T0068455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='T0068717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1519500',harga_beli ='1519500' WHERE kode_barcode='T0068718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='T0068863' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4895500',harga_beli ='4895500' WHERE kode_barcode='T0068911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3798000',harga_beli ='3798000' WHERE kode_barcode='T0068913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='T0070417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5127500',harga_beli ='5127500' WHERE kode_barcode='T0070487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='T0070522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='12660000',harga_beli ='12660000' WHERE kode_barcode='T0071517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1477000',harga_beli ='1477000' WHERE kode_barcode='T0071669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1139500',harga_beli ='1139500' WHERE kode_barcode='T0072098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6478000',harga_beli ='6478000' WHERE kode_barcode='T0072947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5212000',harga_beli ='5212000' WHERE kode_barcode='T0072968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='10339000',harga_beli ='10339000' WHERE kode_barcode='T0073702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1519500',harga_beli ='1519500' WHERE kode_barcode='T0073741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1477000',harga_beli ='1477000' WHERE kode_barcode='T0073742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2975500',harga_beli ='2975500' WHERE kode_barcode='T0073757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2954000',harga_beli ='2954000' WHERE kode_barcode='T0073758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='21269000',harga_beli ='21269000' WHERE kode_barcode='T0073781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1266000',harga_beli ='1266000' WHERE kode_barcode='T0074523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5676000',harga_beli ='5676000' WHERE kode_barcode='T0075796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2279000',harga_beli ='2279000' WHERE kode_barcode='T0076194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1709500',harga_beli ='1709500' WHERE kode_barcode='T0076196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1435000',harga_beli ='1435000' WHERE kode_barcode='T0076198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='T0076200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='24814000',harga_beli ='24814000' WHERE kode_barcode='T0076223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='T0078467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1329500',harga_beli ='1329500' WHERE kode_barcode='T0078468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1793500',harga_beli ='1793500' WHERE kode_barcode='T0078469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1287500',harga_beli ='1287500' WHERE kode_barcode='T0078470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='T0078471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='886500',harga_beli ='886500' WHERE kode_barcode='T0078475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='10803500',harga_beli ='10803500' WHERE kode_barcode='00295403' LIMIT 1;
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','2110000','admin','2026-04-24 09:34:32');
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3365500',harga_beli ='3365500' WHERE kode_barcode='T0062321' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4004500',harga_beli ='4004500' WHERE kode_barcode='T0066570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3110000',harga_beli ='3110000' WHERE kode_barcode='T0066568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3216500',harga_beli ='3216500' WHERE kode_barcode='T0065981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4324000',harga_beli ='4324000' WHERE kode_barcode='T0065968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4324000',harga_beli ='4324000' WHERE kode_barcode='T0065181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1384500',harga_beli ='1384500' WHERE kode_barcode='T0065158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='T0078241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2982000',harga_beli ='2982000' WHERE kode_barcode='T0062323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4388000',harga_beli ='4388000' WHERE kode_barcode='T0066774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='937500',harga_beli ='937500' WHERE kode_barcode='T0061868' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='937500',harga_beli ='937500' WHERE kode_barcode='T0061867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7583000',harga_beli ='7583000' WHERE kode_barcode='T0061257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1065000',harga_beli ='1065000' WHERE kode_barcode='T0060259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4494500',harga_beli ='4494500' WHERE kode_barcode='T0059473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1597500',harga_beli ='1597500' WHERE kode_barcode='T0059328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3259000',harga_beli ='3259000' WHERE kode_barcode='T0059327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3088500',harga_beli ='3088500' WHERE kode_barcode='T0058739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3344500',harga_beli ='3344500' WHERE kode_barcode='T0071243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='852000',harga_beli ='852000' WHERE kode_barcode='T0078462' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='852000',harga_beli ='852000' WHERE kode_barcode='T0078461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='639000',harga_beli ='639000' WHERE kode_barcode='T0075783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='T0075731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2045000',harga_beli ='2045000' WHERE kode_barcode='T0073711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1810500',harga_beli ='1810500' WHERE kode_barcode='T0073709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2151500',harga_beli ='2151500' WHERE kode_barcode='T0073708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6390000',harga_beli ='6390000' WHERE kode_barcode='T0073707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1406000',harga_beli ='1406000' WHERE kode_barcode='T0056784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4345500',harga_beli ='4345500' WHERE kode_barcode='T0071213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3791500',harga_beli ='3791500' WHERE kode_barcode='T0069941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3791500',harga_beli ='3791500' WHERE kode_barcode='T0069940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4366500',harga_beli ='4366500' WHERE kode_barcode='T0069910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4004500',harga_beli ='4004500' WHERE kode_barcode='T0068910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3238000',harga_beli ='3238000' WHERE kode_barcode='T0068454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3259000',harga_beli ='3259000' WHERE kode_barcode='T0067263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1406000',harga_beli ='1406000' WHERE kode_barcode='T0011816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1512500',harga_beli ='1512500' WHERE kode_barcode='T0031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1321000',harga_beli ='1321000' WHERE kode_barcode='T0027088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1619000',harga_beli ='1619000' WHERE kode_barcode='T0024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1960000',harga_beli ='1960000' WHERE kode_barcode='T0024921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1512500',harga_beli ='1512500' WHERE kode_barcode='T0024478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='12780000',harga_beli ='12780000' WHERE kode_barcode='T0020109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2023500',harga_beli ='2023500' WHERE kode_barcode='T0017824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1278000',harga_beli ='1278000' WHERE kode_barcode='T0016447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1555000',harga_beli ='1555000' WHERE kode_barcode='T0031470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6496500',harga_beli ='6496500' WHERE kode_barcode='T0002699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1299500',harga_beli ='1299500' WHERE kode_barcode='T0002646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='14803500',harga_beli ='14803500' WHERE kode_barcode='T0002534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1619000',harga_beli ='1619000' WHERE kode_barcode='T0001636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1406000',harga_beli ='1406000' WHERE kode_barcode='T0001633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1427500',harga_beli ='1427500' WHERE kode_barcode='T0001632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1597500',harga_beli ='1597500' WHERE kode_barcode='T0001631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2492500',harga_beli ='2492500' WHERE kode_barcode='T0001626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1065000',harga_beli ='1065000' WHERE kode_barcode='T0048970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6582000',harga_beli ='6582000' WHERE kode_barcode='T0055807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='12205000',harga_beli ='12205000' WHERE kode_barcode='T0052955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3152500',harga_beli ='3152500' WHERE kode_barcode='T0051842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='32056500',harga_beli ='32056500' WHERE kode_barcode='T0051687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3131500',harga_beli ='3131500' WHERE kode_barcode='T0050888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3877000',harga_beli ='3877000' WHERE kode_barcode='T0050814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2236500',harga_beli ='2236500' WHERE kode_barcode='T0049861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2620000',harga_beli ='2620000' WHERE kode_barcode='T0049859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2556000',harga_beli ='2556000' WHERE kode_barcode='T0001324' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1065000',harga_beli ='1065000' WHERE kode_barcode='T0048969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1917000',harga_beli ='1917000' WHERE kode_barcode='T0048968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4473000',harga_beli ='4473000' WHERE kode_barcode='T0044770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6560500',harga_beli ='6560500' WHERE kode_barcode='T0037980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='11182500',harga_beli ='11182500' WHERE kode_barcode='T0037977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='10863000',harga_beli ='10863000' WHERE kode_barcode='T0037976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1321000',harga_beli ='1321000' WHERE kode_barcode='T0032927' LIMIT 1;
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','2130000','admin','2026-04-24 09:34:53');
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3365500',harga_beli ='3365500' WHERE kode_barcode='T0062321' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4004500',harga_beli ='4004500' WHERE kode_barcode='T0066570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3110000',harga_beli ='3110000' WHERE kode_barcode='T0066568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3216500',harga_beli ='3216500' WHERE kode_barcode='T0065981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4324000',harga_beli ='4324000' WHERE kode_barcode='T0065968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4324000',harga_beli ='4324000' WHERE kode_barcode='T0065181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1384500',harga_beli ='1384500' WHERE kode_barcode='T0065158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='T0078241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2982000',harga_beli ='2982000' WHERE kode_barcode='T0062323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4388000',harga_beli ='4388000' WHERE kode_barcode='T0066774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='937500',harga_beli ='937500' WHERE kode_barcode='T0061868' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='937500',harga_beli ='937500' WHERE kode_barcode='T0061867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7583000',harga_beli ='7583000' WHERE kode_barcode='T0061257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1065000',harga_beli ='1065000' WHERE kode_barcode='T0060259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4494500',harga_beli ='4494500' WHERE kode_barcode='T0059473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1597500',harga_beli ='1597500' WHERE kode_barcode='T0059328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3259000',harga_beli ='3259000' WHERE kode_barcode='T0059327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3088500',harga_beli ='3088500' WHERE kode_barcode='T0058739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3344500',harga_beli ='3344500' WHERE kode_barcode='T0071243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='852000',harga_beli ='852000' WHERE kode_barcode='T0078462' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='852000',harga_beli ='852000' WHERE kode_barcode='T0078461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='639000',harga_beli ='639000' WHERE kode_barcode='T0075783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='T0075731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2045000',harga_beli ='2045000' WHERE kode_barcode='T0073711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1810500',harga_beli ='1810500' WHERE kode_barcode='T0073709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2151500',harga_beli ='2151500' WHERE kode_barcode='T0073708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6390000',harga_beli ='6390000' WHERE kode_barcode='T0073707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1406000',harga_beli ='1406000' WHERE kode_barcode='T0056784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4345500',harga_beli ='4345500' WHERE kode_barcode='T0071213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3791500',harga_beli ='3791500' WHERE kode_barcode='T0069941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3791500',harga_beli ='3791500' WHERE kode_barcode='T0069940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4366500',harga_beli ='4366500' WHERE kode_barcode='T0069910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4004500',harga_beli ='4004500' WHERE kode_barcode='T0068910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3238000',harga_beli ='3238000' WHERE kode_barcode='T0068454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3259000',harga_beli ='3259000' WHERE kode_barcode='T0067263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1406000',harga_beli ='1406000' WHERE kode_barcode='T0011816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1512500',harga_beli ='1512500' WHERE kode_barcode='T0031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1321000',harga_beli ='1321000' WHERE kode_barcode='T0027088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1619000',harga_beli ='1619000' WHERE kode_barcode='T0024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1960000',harga_beli ='1960000' WHERE kode_barcode='T0024921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1512500',harga_beli ='1512500' WHERE kode_barcode='T0024478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='12780000',harga_beli ='12780000' WHERE kode_barcode='T0020109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2023500',harga_beli ='2023500' WHERE kode_barcode='T0017824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1278000',harga_beli ='1278000' WHERE kode_barcode='T0016447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1555000',harga_beli ='1555000' WHERE kode_barcode='T0031470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6496500',harga_beli ='6496500' WHERE kode_barcode='T0002699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1299500',harga_beli ='1299500' WHERE kode_barcode='T0002646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='14803500',harga_beli ='14803500' WHERE kode_barcode='T0002534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1619000',harga_beli ='1619000' WHERE kode_barcode='T0001636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1406000',harga_beli ='1406000' WHERE kode_barcode='T0001633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1427500',harga_beli ='1427500' WHERE kode_barcode='T0001632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1597500',harga_beli ='1597500' WHERE kode_barcode='T0001631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2492500',harga_beli ='2492500' WHERE kode_barcode='T0001626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1065000',harga_beli ='1065000' WHERE kode_barcode='T0048970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6582000',harga_beli ='6582000' WHERE kode_barcode='T0055807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='12205000',harga_beli ='12205000' WHERE kode_barcode='T0052955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3152500',harga_beli ='3152500' WHERE kode_barcode='T0051842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='32056500',harga_beli ='32056500' WHERE kode_barcode='T0051687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3131500',harga_beli ='3131500' WHERE kode_barcode='T0050888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3877000',harga_beli ='3877000' WHERE kode_barcode='T0050814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2236500',harga_beli ='2236500' WHERE kode_barcode='T0049861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2620000',harga_beli ='2620000' WHERE kode_barcode='T0049859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2556000',harga_beli ='2556000' WHERE kode_barcode='T0001324' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1065000',harga_beli ='1065000' WHERE kode_barcode='T0048969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1917000',harga_beli ='1917000' WHERE kode_barcode='T0048968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4473000',harga_beli ='4473000' WHERE kode_barcode='T0044770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6560500',harga_beli ='6560500' WHERE kode_barcode='T0037980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='11182500',harga_beli ='11182500' WHERE kode_barcode='T0037977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='10863000',harga_beli ='10863000' WHERE kode_barcode='T0037976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1321000',harga_beli ='1321000' WHERE kode_barcode='T0032927' LIMIT 1;
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','2130000','admin','2026-04-24 09:35:41');
UPDATE tm_group SET harga='2150000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','2150000','admin','2026-04-24 09:36:55');
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='2995000',harga_beli ='2995000' WHERE kode_barcode='T0044775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='6944000',harga_beli ='6944000' WHERE kode_barcode='T0051841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='5685500',harga_beli ='5685500' WHERE kode_barcode='T0051851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='15342000',harga_beli ='15342000' WHERE kode_barcode='T0056780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='7400000',harga_beli ='7400000' WHERE kode_barcode='T0056781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='2452500',harga_beli ='2452500' WHERE kode_barcode='T0066772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='4796000',harga_beli ='4796000' WHERE kode_barcode='T0067265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='12911500',harga_beli ='12911500' WHERE kode_barcode='T0067267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='6684000',harga_beli ='6684000' WHERE kode_barcode='T0078273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='5121500',harga_beli ='5121500' WHERE kode_barcode='T0078274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='586000',harga_beli ='586000' WHERE kode_barcode='T0071238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2170000',harga_jual='6467000',harga_beli ='6467000' WHERE kode_barcode='T0073704' LIMIT 1;
UPDATE tm_group SET harga='2170000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','2170000','admin','2026-04-24 09:37:19');
UPDATE tm_barang SET harga_skrg ='2190000',harga_jual='6417000',harga_beli ='6417000' WHERE kode_barcode='T0036633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2190000',harga_jual='5563000',harga_beli ='5563000' WHERE kode_barcode='T0065165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2190000',harga_jual='5497000',harga_beli ='5497000' WHERE kode_barcode='T0065166' LIMIT 1;
UPDATE tm_group SET harga='2190000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','2190000','admin','2026-04-24 09:37:59');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226240949441','kasir','1',' MEE2 CM 14','TOKO','SMBK-E','E2E-ZDXG-16-T','CC MODEL PITA MATA CM 14 8K ','','0.420','1','100.00','483000','0','0','15000','483000','0','0','0','483000','TIN','T0078556','E2E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDXG-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='E2E-ZDXG-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F226240949441','2026-04-24','0.420','2026-04-24','09:49:44','PLG0079361','483000','483000','0','483000','483000','kasir','2026-04-24 09:49:44','F22624094944');
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-04-24','F226240949441','2026-04-24','09:49:44','TIN','483000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0008','D','2026-04-24','09:49:44','kasir','PENJUALAN','F226240949441','8834736000','483000','8835219000');
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,status_otorisasi,harga_skrg) VALUES ('F226240954251','kasir','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZDBB-71-T','CC MODEL BOLA TINJU KRAWANG LG 16 8K ','OL','0.760','1','100.00','874000','0','0','15000','882000','0','5000','0','887000','NS','T0078861','E1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBB-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='E1E-ZDBB-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F226240954251','2026-04-24','0.760','2026-04-24','09:54:25','PLG0079362','882000','882000','5000','887000','887000','kasir','2026-04-24 09:54:25','F22624095425');
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-04-24','F226240954251','2026-04-24','09:54:25','NS','887000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0009','D','2026-04-24','09:54:25','kasir','PENJUALAN','F226240954251','8835219000','887000','8836106000');
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,status_otorisasi,harga_skrg) VALUES ('F226240955041','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZDBC-54-T','AT TINDIK BABY LG 8K ','OL','0.450','1','100.00','517000','0','0','15000','525000','0','5000','0','530000','NS','T0078935','A1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBC-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='A1E-ZDBC-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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) VALUES ('F226240955041','2026-04-24','0.450','2026-04-24','09:55:05','PLG0079363','525000','525000','5000','530000','530000','kasir','2026-04-24 09:55:04','F22624095504');
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-04-24','F226240955041','2026-04-24','09:55:05','NS','530000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0010','D','2026-04-24','09:55:05','kasir','PENJUALAN','F226240955041','8836106000','530000','8836636000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240955041' 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,status_otorisasi,harga_skrg) VALUES ('F226240955042','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZCXB-25-T','LT SLOBOK BALOK HURUF BG F 8K ','OL','0.330','1','100.00','393000','0','0','15000','398000','0','5000','0','403000','NS','T0077659','D1G','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCXB-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='D1G-ZCXB-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F226240955042','2026-04-24','0.330','2026-04-24','09:55:05','PLG0079364','398000','398000','5000','403000','403000','kasir','2026-04-24 09:55:04','F22624095504');
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-04-24','F226240955042','2026-04-24','09:55:05','NS','403000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0011','D','2026-04-24','09:55:05','kasir','PENJUALAN','F226240955042','8836636000','403000','8837039000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='403000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240955042' 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,status_otorisasi,harga_skrg) VALUES ('F226241032201','kasir','1',' MGD1G X UB','TOKO','SMBK-D','D1G-ZDBX-276-0','LT X MODEL ARESO SLEP UB 8K ','','0.360','1','100.00','428000','0','0','15000','421000','0','0','0','421000','TIN','00400213','D1G','0','0','-','1','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZDBX-276-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='D1G-ZDBX-276-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F226241032201','2026-04-24','0.360','2026-04-24','10:32:20','PLG0079365','421000','421000','0','421000','421000','kasir','2026-04-24 10:32:20','F22624103220');
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-04-24','F226241032201','2026-04-24','10:32:20','TIN','421000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0012','D','2026-04-24','10:32:20','kasir','PENJUALAN','F226241032201','8837039000','421000','8837460000');
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,status_otorisasi,harga_skrg) VALUES ('F226241040201','kasir','1',' TDA1 X LG ','TOKO','TBK-A','A1TD-YBBA-3-T','AT X MODEL MATA VAR LG 17K ','','1.000','1','100.00','2070000','0','0','15000','2070000','0','10000','0','2080000','NS','T0067226','A1TD','0','0','-','0','2070000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-YBBA-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='A1TD-YBBA-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' 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) VALUES ('F226241040201','2026-04-24','1.000','2026-04-24','10:40:21','PLG0079366','2070000','2070000','10000','2080000','2080000','kasir','2026-04-24 10:40:20','F22624104020');
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-04-24','F226241040201','2026-04-24','10:40:21','NS','2080000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0013','D','2026-04-24','10:40:21','kasir','PENJUALAN','F226241040201','8837460000','2080000','8839540000');
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,status_otorisasi,harga_skrg) VALUES ('F226240205081','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZDBA-3-T','GW TRIXIE PANJANG MODEL MATA LG 8K ','OL ','0.570','1','100.00','655000','0','0','15000','658000','0','5000','0','663000','RHM','T0078774','B1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBA-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='B1E-ZDBA-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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) VALUES ('F226240205081','2026-04-24','0.570','2026-04-24','14:05:09','PLG0079367','658000','658000','5000','663000','0','kasir','2026-04-24 14:05:08','F22624020508');
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-04-24','F226240205081','2026-04-24','14:05:09','RHM','663000','5000');
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-260424-0001','2026-04-24','2026-04-24 14:05:08','PENJUALAN : F226240205081','33373347364734737','BCA','663000','663000','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-260424-0002','D','2026-04-24','14:05:09','BCA','PENJUALAN','F226240205081','4372053888','663000','4372716888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('33373347364734737','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='663000' WHERE no_faktur_jual='F226240205081' 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,status_otorisasi,harga_skrg) VALUES ('F226240207121','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZDBC-12-T','AT JERSY POLOS CM 8K ','OL ','0.550','1','100.00','632000','0','0','15000','638000','0','5000','0','643000','RHM','T0078893','A1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBC-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='A1E-ZDBC-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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) VALUES ('F226240207121','2026-04-24','0.550','2026-04-24','14:07:13','PLG0079368','638000','638000','5000','643000','643000','kasir','2026-04-24 14:07:12','F22624020712');
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-04-24','F226240207121','2026-04-24','14:07:13','RHM','643000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0014','D','2026-04-24','14:07:13','kasir','PENJUALAN','F226240207121','8839540000','643000','8840183000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='643000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240207121' 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,status_otorisasi,harga_skrg) VALUES ('F226240207122','kasir',' 1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDBC-65-T','GW TUSUK MODEL KUPU PASIR BW 8K ','OL ','0.470','1','100.00','540000','0','0','15000','545000','0','5000','0','550000','RHM','T0078946','B1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='B1E-ZDBC-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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) VALUES ('F226240207122','2026-04-24','0.470','2026-04-24','14:07:13','PLG0079369','545000','545000','5000','550000','550000','kasir','2026-04-24 14:07:12','F22624020712');
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-04-24','F226240207122','2026-04-24','14:07:13','RHM','550000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0015','D','2026-04-24','14:07:13','kasir','PENJUALAN','F226240207122','8840183000','550000','8840733000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240207122' 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,status_otorisasi,harga_skrg) VALUES ('F226240207123','kasir',' 1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDBC-67-T','GW TUSUK MODEL KUPU PASIR BW 8K ','OL ','0.470','1','100.00','540000','0','0','15000','545000','0','5000','0','550000','RHM','T0078948','B1E','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='B1E-ZDBC-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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) VALUES ('F226240207123','2026-04-24','0.470','2026-04-24','14:07:13','PLG0079370','545000','545000','5000','550000','550000','kasir','2026-04-24 14:07:12','F22624020712');
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-04-24','F226240207123','2026-04-24','14:07:13','RHM','550000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0016','D','2026-04-24','14:07:13','kasir','PENJUALAN','F226240207123','8840733000','550000','8841283000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240207123' 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,status_otorisasi,harga_skrg) VALUES ('F226240251361','kasir','1',' TDE1 X YS ','TOKO','TBK-E','E1TD-YLAA-42-T','CC COR VELG KACA 13 YS 17K','','1.040','1','100.00','2153000','0','0','15000','2153000','0','0','0','2153000','NS','T0075700','E1TD','0','0','-','0','2070000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLAA-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='E1TD-YLAA-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' 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) VALUES ('F226240251361','2026-04-24','1.040','2026-04-24','14:51:37','PLG0079371','2153000','2153000','0','2153000','2153000','kasir','2026-04-24 14:51:36','F22624025136');
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-04-24','F226240251361','2026-04-24','14:51:37','NS','2153000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0017','D','2026-04-24','14:51:37','kasir','PENJUALAN','F226240251361','8841283000','2153000','8843436000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240205081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240205081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240205081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240207121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240207121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240207121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240207122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240207122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240207122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240207123' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240207123' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240207123';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240251361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240251361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240251361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240824171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240824171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240824171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240832181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240832181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240832181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240832182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240832182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240832182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240832183' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240832183' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240832183';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240909391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240909391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240909391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240910361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240910361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240910361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240949441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240949441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240949441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240954251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240954251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240954251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240955041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240955041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240955041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240955042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240955042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240955042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241032201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241032201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241032201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241040201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241040201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241040201';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005297','X-00005297','LT MODEL MATA VAR LG 8K','GR','---','D2E','BELI','BELI001','543000','2026-04-24','0.580','1','kasir','2026-04-24 15:08:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00005297','X-00005297');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260424-0001','F225290956171','TIN','1','BELI','BELI001','D2E', 'X-00005297', 'LT MODEL MATA VAR LG 8K','0.580','0.580','100.00','603000','543000','936207','1150000','1','543000','543000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260424-0001','2026-04-24','2026-04-24','15:08:24','TIN','---','0.580','543000','543000','543000','543000','543000','kasir','2026-04-24 15:08:24','FB-260424-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260424-0001','LIYA','JL PILANGSARI 24B PURBOSUMAN','','','','kasir','2026-04-24 15:08:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-24' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260424-0018','K','2026-04-24','15:08:24','kasir','PEMBELIAN UMUM','FB-260424-0001','8843436000','543000','8842893000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005298','X-00005298','AT X HUGGIES KLIP MATA LG 8K','GR','---','A1D','BELI','BELI001','970000','2026-04-24','1.320','1','kasir','2026-04-24 15:08:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005298','X-00005298');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260424-0002','F225011229391','TIN','1','BELI','BELI001','A1D', 'X-00005298', 'AT X HUGGIES KLIP MATA LG 8K','1.320','1.320','100.00','1056000','970000','734848','1130000','1','970000','970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.320',berat_beli_asli=berat_beli_asli+'1.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.320',berat_akhir_asli=berat_akhir_asli+'1.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260424-0002','2026-04-24','2026-04-24','15:08:40','TIN','---','1.320','970000','970000','970000','970000','970000','kasir','2026-04-24 15:08:40','FB-260424-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260424-0002','KHOIR','KADIPATEN','','','082302122666','kasir','2026-04-24 15:08:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-24' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260424-0019','K','2026-04-24','15:08:40','kasir','PEMBELIAN UMUM','FB-260424-0002','8842893000','970000','8841923000');
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,status_otorisasi,harga_skrg) VALUES ('F226240312081','kasir','1',' MEE2 5K CM','TOKO','SMBK-E','E2E-ZDBB-78-T','CC MODEL MATA VAR CM 12 8K ','','0.670','1','100.00','770000','0','0','15000','767000','0','5000','0','772000','RTA','T0078868','E2E','0','0','-','1','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBB-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='E2E-ZDBB-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F226240312081','2026-04-24','0.670','2026-04-24','15:12:09','PLG0079372','767000','767000','5000','772000','772000','kasir','2026-04-24 15:12:08','F22624031208');
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-04-24','F226240312081','2026-04-24','15:12:09','RTA','772000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0020','D','2026-04-24','15:12:09','kasir','PENJUALAN','F226240312081','8841923000','772000','8842695000');
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,status_otorisasi,harga_skrg) VALUES ('F226240314531','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCXE-33-T','CC MODEL SOLITAIRE MATA VAR CM 12 8K ','','1.350','1','100.00','1525000','0','0','15000','1520000','0','10000','0','1530000','RTA','T0077709','E2D','0','0','-','1','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXE-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='E2D-ZCXE-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F226240314531','2026-04-24','1.350','2026-04-24','15:14:53','PLG0079373','1520000','1520000','10000','1530000','1530000','kasir','2026-04-24 15:14:53','F22624031453');
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-04-24','F226240314531','2026-04-24','15:14:53','RTA','1530000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0021','D','2026-04-24','15:14:53','kasir','PENJUALAN','F226240314531','8842695000','1530000','8844225000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240314531' 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,status_otorisasi,harga_skrg) VALUES ('F226240314532','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDBC-5-T','GL TRIXIE SERUT BUNGA CLOVER SLEP UB 8K ','','1.630','1','100.00','1875000','0','0','15000','1866000','0','0','0','1866000','RTA','T0078886','F3E','0','0','-','1','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBC-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='F3E-ZDBC-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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) VALUES ('F226240314532','2026-04-24','1.630','2026-04-24','15:14:53','PLG0079374','1866000','1866000','0','1866000','1866000','kasir','2026-04-24 15:14:53','F22624031453');
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-04-24','F226240314532','2026-04-24','15:14:53','RTA','1866000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0022','D','2026-04-24','15:14:53','kasir','PENJUALAN','F226240314532','8844225000','1866000','8846091000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1866000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240314532' 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,status_otorisasi,harga_skrg) VALUES ('F226240316101','kasir','1',' TEF3 UB ','TOKO','TBK-F','F3TE-ZDXF-12-T','GL RANTAI HOLLOW PLAT UB 17K ','','2.080','1','100.00','4347000','0','0','15000','4347000','0','0','0','4347000','RTA','T0078474','F3TE','0','0','-','0','2090000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZDXF-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='F3TE-ZDXF-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' 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) VALUES ('F226240316101','2026-04-24','2.080','2026-04-24','15:16:10','PLG0079375','4347000','4347000','0','4347000','4347000','kasir','2026-04-24 15:16:10','F22624031610');
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-04-24','F226240316101','2026-04-24','15:16:10','RTA','4347000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0023','D','2026-04-24','15:16:10','kasir','PENJUALAN','F226240316101','8846091000','4347000','8850438000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240312081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240312081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240312081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240314531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240314531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240314531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240314532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240314532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240314532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240316101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240316101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240316101';
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,status_otorisasi,harga_skrg) VALUES ('F226240336011','kasir','1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZDAF-33-T','KL NORY UB 45CM 8K ','','0.980','1','100.00','1127000','0','0','15000','1122000','0','0','0','1122000','NS','T0078699','H1E','0','0','-','1','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAF-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='H1E-ZDAF-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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) VALUES ('F226240336011','2026-04-24','0.980','2026-04-24','15:36:02','PLG0079376','1122000','1122000','0','1122000','1122000','kasir','2026-04-24 15:36:01','F22624033601');
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-04-24','F226240336011','2026-04-24','15:36:02','NS','1122000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0024','D','2026-04-24','15:36:02','kasir','PENJUALAN','F226240336011','8850438000','1122000','8851560000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1122000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240336011' 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,status_otorisasi,harga_skrg) VALUES ('F226240336012','kasir',' 1',' MFD1F X YT','TOKO','SMBK-D','D1F-ZDAX-77-0','LT X MODEL SPECTRA HIATM YT 8K ','','0.480','1','100.00','562000','0','0','15000','560000','0','5000','0','565000','NS','00398847','D1F','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDAX-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='D1F-ZDAX-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F226240336012','2026-04-24','0.480','2026-04-24','15:36:02','PLG0079377','560000','560000','5000','565000','565000','kasir','2026-04-24 15:36:01','F22624033601');
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-04-24','F226240336012','2026-04-24','15:36:02','NS','565000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260424-0025','D','2026-04-24','15:36:02','kasir','PENJUALAN','F226240336012','8851560000','565000','8852125000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240336012' 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,status_otorisasi,harga_skrg) VALUES ('F226240353031','kasir','1',' TEF3 X UB ','TOKO','TBK-F','F3TE-YLAB-8-T','GL X LADY G SLEP UB 17K ','','5.780','1','100.00','12080000','0','0','15000','12080000','0','0','0','12080000','NS','T0075714','F3TE','0','0','-','0','2090000');
UPDATE tm_barang SET tgl_last_jual='2026-04-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLAB-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.780',berat_jual_asli=berat_jual_asli+'5.780',stock_jual='1',berat_akhir=berat_akhir-'5.780',berat_akhir_asli=berat_akhir_asli-'5.780',stock_akhir='0' WHERE tanggal='2026-04-24' AND kode_barang='F3TE-YLAB-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' 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) VALUES ('F226240353031','2026-04-24','5.780','2026-04-24','15:53:03','PLG0079378','12080000','12080000','0','12080000','12080000','kasir','2026-04-24 15:53:03','F22624035303');
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-04-24','F226240353031','2026-04-24','15:53:03','NS','12080000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260424-0026','D','2026-04-24','15:53:03','kasir','PENJUALAN','F226240353031','8852125000','12080000','8864205000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005299','X-00005299','AT MODEL HATI MATA CM 8K','GR','---','A1E','BELI','BELI001','473000','2026-04-24','0.460','1','kasir','2026-04-24 15:54:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005299','X-00005299');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260424-0003','F226191100421','RTA','1','BELI','BELI001','A1E', 'X-00005299', 'AT MODEL HATI MATA CM 8K','0.460','0.460','100.00','547000','473000','1028261','1150000','1','473000','473000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260424-0003','2026-04-24','2026-04-24','15:54:58','RTA','---','0.460','473000','473000','473000','473000','473000','kasir','2026-04-24 15:54:59','FB-260424-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260424-0003','ARUM','JL. IMAM BONJOL','','','0846463826','kasir','2026-04-24 15:54:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-24' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260424-0027','K','2026-04-24','15:54:58','kasir','PEMBELIAN UMUM','FB-260424-0003','8864205000','473000','8863732000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240336011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240336011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240336011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240336012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240336012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240336012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240353031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240353031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240353031';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260424-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260424-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260424-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260424-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260424-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260424-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-24';
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-04-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-24' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260425-0001','D','2026-04-25','16:06:26','SYSTEM','SALDO AWAL','SALDO AWAL','0','8863732000','8863732000');
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-260425-0001','D','2026-04-25','16:06:26','BCA','SALDO AWAL','SALDO AWAL','0','4372716888','4372716888');
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-260425-0001','D','2026-04-25','16:06:26','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260425-0001','D','2026-04-25','16:06:26','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
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-260425-0001','D','2026-04-25','16:06:26','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
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-260425-0001','D','2026-04-25','16:06:26','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-04-25';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1F-YABE-37-0','1','0.980','0.980','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-YABE-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-YABE-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1F-YABE-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-YABE-37-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1F','D1F-YABE-37-0','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-YABE-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-YABE-37-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1F-YHBB-35-0','1','0.660','0.660','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-YHBB-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-YHBB-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1F-YHBB-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-YHBB-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1F','D1F-YHBB-35-0','1','0.660','0.660','1','0.660','0.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-YHBB-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-YHBB-35-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1G-YIXC-48-0','1','0.320','0.320','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-YIXC-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-YIXC-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1G-YIXC-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-YIXC-48-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1G','D1G-YIXC-48-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-YIXC-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-YIXC-48-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1F-ZCAH-427-0','1','0.600','0.600','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZCAH-427-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZCAH-427-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1F-ZCAH-427-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZCAH-427-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1F','D1F-ZCAH-427-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZCAH-427-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZCAH-427-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1F-ZDXA-201-0','1','0.470','0.470','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZDXA-201-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZDXA-201-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1F-ZDXA-201-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZDXA-201-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1F','D1F-ZDXA-201-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZDXA-201-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZDXA-201-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1F-ZDAD-118-0','1','0.580','0.580','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZDAD-118-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZDAD-118-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1F-ZDAD-118-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZDAD-118-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1F','D1F-ZDAD-118-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZDAD-118-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZDAD-118-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1F-ZDAH-17-0','1','0.550','0.550','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZDAH-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZDAH-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1F-ZDAH-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZDAH-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1F','D1F-ZDAH-17-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZDAH-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZDAH-17-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1F-ZDAH-20-0','1','0.630','0.630','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZDAH-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZDAH-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:54:40' WHERE kode_barang='D1F-ZDAH-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZDAH-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:54:40','TOKO','SMBK-D','D1F','D1F-ZDAH-20-0','1','0.630','0.630','1','0.630','0.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZDAH-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZDAH-20-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260425-0001','2026-04-25','16:54','4.790','input','2026-04-24 16:54:40');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260425-0001','1','D1E-YKBI-165-0','1','0.570','0.570','TOKO','SBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-YKBI-165-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-YKBI-165-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-25 16:57:22' WHERE kode_barang='D1E-YKBI-165-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-YKBI-165-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-25 16:57:22','TOKO','SMBK-D','D1E','D1E-YKBI-165-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-YKBI-165-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-YKBI-165-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260425-0001','2026-04-25','16:57','0.570','input','2026-04-24 16:57:22');