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 ('F325190858361','input','1',' MFB1F HW ','TOKO','PM-B','B1F-WEBG-172-0','GW ITALY ARESO VAR HW ','','0.570','1','100.00','528000','0','0','15000','530000','0','0','0','530000','SIN','00234847','B1F','0','0','-','0','927000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-WEBG-172-0' 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='2025-09-19' AND kode_barang='B1F-WEBG-172-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325190858361','2025-09-19','0.570','2025-09-19','08:58:36','PLG0024929','530000','530000','0','530000','530000','input','2025-09-19 08:58:36','F32519085836');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325190858361','2025-09-19','08:58:36','SIN','530000','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-250919-0002','D','2025-09-19','08:58:36','input','PENJUALAN','F325190858361','61694000','530000','62224000');
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 ('F325190932111','input','1',' MEF1 TD D5','TOKO','PM-F','F1E-YHBE-31-0','GL OVAL MODEL C TD D52 8K ','','2.900','1','100.00','2639000','0','0','15000','2640000','0','0','0','2640000','AAT','00366841','F1E','0','0','-','0','910000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHBE-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='F1E-YHBE-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325190932111','2025-09-19','2.900','2025-09-19','09:32:12','PLG0024930','2640000','2640000','0','2640000','2640000','input','2025-09-19 09:32:11','F32519093211');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325190932111','2025-09-19','09:32:12','AAT','2640000','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-250919-0003','D','2025-09-19','09:32:12','input','PENJUALAN','F325190932111','62224000','2640000','64864000');
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 ('F325190943281','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-YEAD-474-0','KL X MILANO PANJANG UB 58 9K ','','4.730','1','100.00','4706000','0','0','15000','4705000','0','0','0','4705000','FIT','00353673','H2J','0','0','-','1','995000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YEAD-474-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.730',berat_jual_asli=berat_jual_asli+'4.730',stock_jual='1',berat_akhir=berat_akhir-'4.730',berat_akhir_asli=berat_akhir_asli-'4.730',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='H2J-YEAD-474-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325190943281','2025-09-19','4.730','2025-09-19','09:43:28','PLG0024931','4705000','4705000','0','4705000','4705000','input','2025-09-19 09:43:28','F32519094328');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325190943281','2025-09-19','09:43:28','FIT','4705000','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-250919-0004','D','2025-09-19','09:43:28','input','PENJUALAN','F325190943281','64864000','4705000','69569000');
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-00017011','X-00017011','GL SANTA SERUT MODEL HATI MATA VAR UB 8K','GR','---','F3E','BELI','BELI001','975000','2025-09-19','1.760','1','kasir','2025-09-19 11:03:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017011','X-00017011');
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-250919-0001','F324170259391','FIT','1','BELI','BELI001','F3E', 'X-00017011', 'GL SANTA SERUT MODEL HATI MATA VAR UB 8K','1.860','1.760','100.00','1196000','975000','553977','910000','1','975000','975000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.760',berat_beli_asli=berat_beli_asli+'1.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.760',berat_akhir_asli=berat_akhir_asli+'1.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-250919-0001','2025-09-19','2025-09-19','11:02:59','FIT','---','1.760','975000','975000','975000','975000','975000','kasir','2025-09-19 11:03:00','FB-250919-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0001','MAY','GIRIHARJO PUHPELEM','','','082282720336','kasir','2025-09-19 11:03:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0005','K','2025-09-19','11:02:59','kasir','PEMBELIAN UMUM','FB-250919-0001','69569000','975000','68594000');
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-00017012','X-00017012','GL X FANCY MODEL BOLA MATA VAR UB 17K','GR','---','F3TE','BELI','BELI001','6270000','2025-09-19','4.730','1','kasir','2025-09-19 11:03:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00017012','X-00017012');
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-250919-0002','F325071254581','SIN','1','BELI','BELI001','F3TE', 'X-00017012', 'GL X FANCY MODEL BOLA MATA VAR UB 17K','4.730','4.730','100.00','6670000','6270000','1325581','1605000','1','6270000','6270000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.730',berat_beli_asli=berat_beli_asli+'4.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.730',berat_akhir_asli=berat_akhir_asli+'4.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-250919-0002','2025-09-19','2025-09-19','11:03:43','SIN','---','4.730','6270000','6270000','6270000','6270000','6270000','kasir','2025-09-19 11:03:44','FB-250919-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0002','ADELIA','KENTENG','','','','kasir','2025-09-19 11:03:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0006','K','2025-09-19','11:03:43','kasir','PEMBELIAN UMUM','FB-250919-0002','68594000','6270000','62324000');
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-00017013','X-00017013','CC MODEL MATA VAR MG 24 8K','GR','---','E2D','BELI','BELI001','865000','2025-09-19','1.100','1','kasir','2025-09-19 11:04:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017013','X-00017013');
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-250919-0003','F325201252012','FIT','1','BELI','BELI001','E2D', 'X-00017013', 'CC MODEL MATA VAR MG 24 8K','1.100','1.100','100.00','940000','865000','786364','893000','1','865000','865000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250919-0003','2025-09-19','2025-09-19','11:04:09','FIT','---','1.100','865000','865000','865000','865000','865000','kasir','2025-09-19 11:04:09','FB-250919-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0003','ENDAH','POHIJO SAMPUNG','','','','kasir','2025-09-19 11:04:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0007','K','2025-09-19','11:04:09','kasir','PEMBELIAN UMUM','FB-250919-0003','62324000','865000','61459000');
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-00017014','X-00017014','CC MODEL SPECTRA HITAM TD 12 8K','GR','---','E1E','BELI','BELI001','330000','2025-09-19','0.530','1','kasir','2025-09-19 11:04:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017014','X-00017014');
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-250919-0004','F324291114341','AAT','1','BELI','BELI001','E1E', 'X-00017014', 'CC MODEL SPECTRA HITAM TD 12 8K','0.530','0.530','100.00','358000','330000','622642','910000','1','330000','330000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-250919-0004','2025-09-19','2025-09-19','11:04:24','AAT','---','0.530','330000','330000','330000','330000','330000','kasir','2025-09-19 11:04:24','FB-250919-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0004','YENI','PAKIS','','','','kasir','2025-09-19 11:04:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0008','K','2025-09-19','11:04:24','kasir','PEMBELIAN UMUM','FB-250919-0004','61459000','330000','61129000');
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-00017015','X-00017015','CC MODEL KUPU MATA VAR UB 14 8K','GR','---','E2D','BELI','BELI001','510000','2025-09-19','0.860','1','kasir','2025-09-19 11:04:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017015','X-00017015');
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-250919-0005','F324010302381','AAT','1','BELI','BELI001','E2D', 'X-00017015', 'CC MODEL KUPU MATA VAR UB 14 8K','0.860','0.860','100.00','550000','510000','593023','893000','1','510000','510000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.860',berat_beli_asli=berat_beli_asli+'0.860',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.860',berat_akhir_asli=berat_akhir_asli+'0.860',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250919-0005','2025-09-19','2025-09-19','11:04:53','AAT','---','0.860','510000','510000','510000','510000','510000','kasir','2025-09-19 11:04:53','FB-250919-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0005','YENI','PAKIS BARU PACITAN','','','','kasir','2025-09-19 11:04:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0009','K','2025-09-19','11:04:53','kasir','PEMBELIAN UMUM','FB-250919-0005','61129000','510000','60619000');
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-00017016','X-00017016','AT COR 8K','GR','---','A1G','BELI','BELI001','615000','2025-09-19','0.980','1','kasir','2025-09-19 11:06:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1G','X-00017016','X-00017016');
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-250919-0006','F323260853361','SIN','1','BELI','BELI001','A1G', 'X-00017016', 'AT COR 8K','1.020','0.980','100.00','520000','615000','627551','944000','1','615000','615000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1G' 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-250919-0006','2025-09-19','2025-09-19','11:06:18','SIN','---','0.980','615000','615000','615000','615000','615000','kasir','2025-09-19 11:06:19','FB-250919-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0006','YULITA','KISMANTORO','','','','kasir','2025-09-19 11:06:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0010','K','2025-09-19','11:06:18','kasir','PEMBELIAN UMUM','FB-250919-0006','60619000','615000','60004000');
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 ('F325191143311','kasir','1',' MDE1 X YT ','TOKO','PM-E','E1D-YEAE-375-0','CC X MODEL SLEP YT 12 8K ','','1.080','1','100.00','964000','0','0','15000','965000','0','0','0','965000','AAT','00354147','E1D','0','0','-','0','893000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YEAE-375-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E1D-YEAE-375-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325191143311','2025-09-19','1.080','2025-09-19','11:43:32','PLG0024932','965000','965000','0','965000','965000','kasir','2025-09-19 11:43:31','F32519114331');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325191143311','2025-09-19','11:43:32','AAT','965000','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-250919-0011','D','2025-09-19','11:43:32','kasir','PENJUALAN','F325191143311','60004000','965000','60969000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191143311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191143311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191143311';
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 ('F325191145181','kasir','1',' MDE1 X YT ','TOKO','PM-E','E1D-YEAE-375-0','CC X MODEL SLEP YT 12 8K ','','1.080','1','100.00','964000','0','0','15000','965000','0','0','0','965000','AAT','00354147','E1D','0','0','-','0','893000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YEAE-375-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E1D-YEAE-375-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325191145181','2025-09-19','1.080','2025-09-19','11:45:19','PLG0024933','965000','965000','0','965000','965000','kasir','2025-09-19 11:45:18','F32519114518');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325191145181','2025-09-19','11:45:19','AAT','965000','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-250919-0013','D','2025-09-19','11:45:19','kasir','PENJUALAN','F325191145181','60004000','965000','60969000');
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3024000',harga_beli ='3024000' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='9210000',harga_beli ='9210000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='9149000',harga_beli ='9149000' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7644500',harga_beli ='7644500' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='15350000',harga_beli ='15350000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='721500',harga_beli ='721500' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0003984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0003950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0004083' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0004149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='9210000',harga_beli ='9210000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='9210000',harga_beli ='9210000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='9210000',harga_beli ='9210000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='12280000',harga_beli ='12280000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='15350000',harga_beli ='15350000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='10745000',harga_beli ='10745000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='12280000',harga_beli ='12280000' WHERE kode_barcode='T0004186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='10745000',harga_beli ='10745000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='10745000',harga_beli ='10745000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1612000',harga_beli ='1612000' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0027570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='9241000',harga_beli ='9241000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1504500',harga_beli ='1504500' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6094000',harga_beli ='6094000' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1550500',harga_beli ='1550500' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1504500',harga_beli ='1504500' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3009000',harga_beli ='3009000' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='814000',harga_beli ='814000' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0033060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6094000',harga_beli ='6094000' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4574500',harga_beli ='4574500' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='12280000',harga_beli ='12280000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='8596000',harga_beli ='8596000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2226000',harga_beli ='2226000' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4636000',harga_beli ='4636000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0043875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4636000',harga_beli ='4636000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3101000',harga_beli ='3101000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0043855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0043854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='798500',harga_beli ='798500' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0044194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2993500',harga_beli ='2993500' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4544000',harga_beli ='4544000' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0044175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2379500',harga_beli ='2379500' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1489000',harga_beli ='1489000' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2318000',harga_beli ='2318000' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0048353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3009000',harga_beli ='3009000' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1458500',harga_beli ='1458500' WHERE kode_barcode='T0048357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='737000',harga_beli ='737000' WHERE kode_barcode='T0052755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4528500',harga_beli ='4528500' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1504500',harga_beli ='1504500' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1550500',harga_beli ='1550500' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3101000',harga_beli ='3101000' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3039500',harga_beli ='3039500' WHERE kode_barcode='T0052776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7552500',harga_beli ='7552500' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2840000',harga_beli ='2840000' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6063500',harga_beli ='6063500' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4544000',harga_beli ='4544000' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='15365500',harga_beli ='15365500' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='15365500',harga_beli ='15365500' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3085500',harga_beli ='3085500' WHERE kode_barcode='T0052942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0056347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0056349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='737000',harga_beli ='737000' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3085500',harga_beli ='3085500' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7675000',harga_beli ='7675000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3009000',harga_beli ='3009000' WHERE kode_barcode='T0056820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7706000',harga_beli ='7706000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6109500',harga_beli ='6109500' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6109500',harga_beli ='6109500' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3085500',harga_beli ='3085500' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2226000',harga_beli ='2226000' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1504500',harga_beli ='1504500' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1504500',harga_beli ='1504500' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0069558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='767500',harga_beli ='767500' WHERE kode_barcode='T0069559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='3070000',harga_beli ='3070000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='6140000',harga_beli ='6140000' WHERE kode_barcode='T0069565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='7706000',harga_beli ='7706000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1535000',harga_jual='4636000',harga_beli ='4636000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_group SET harga='1535000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1535000','input','2025-09-19 12:40:31');
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='4588000',harga_beli ='4588000' WHERE kode_barcode='T0070500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3122500',harga_beli ='3122500' WHERE kode_barcode='T0070765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3186000',harga_beli ='3186000' WHERE kode_barcode='T0070513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2262500',harga_beli ='2262500' WHERE kode_barcode='T0070512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2007500',harga_beli ='2007500' WHERE kode_barcode='T0070510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1402000',harga_beli ='1402000' WHERE kode_barcode='T0070508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0070505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1991500',harga_beli ='1991500' WHERE kode_barcode='T0070504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='T0070503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='7184500',harga_beli ='7184500' WHERE kode_barcode='T0070501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3138500',harga_beli ='3138500' WHERE kode_barcode='T0070766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3202000',harga_beli ='3202000' WHERE kode_barcode='T0070498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2724500',harga_beli ='2724500' WHERE kode_barcode='T0070497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2071000',harga_beli ='2071000' WHERE kode_barcode='T0070496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1689000',harga_beli ='1689000' WHERE kode_barcode='T0070491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2198500',harga_beli ='2198500' WHERE kode_barcode='T0070157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2310000',harga_beli ='2310000' WHERE kode_barcode='T0070156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1832000',harga_beli ='1832000' WHERE kode_barcode='T0069931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1832000',harga_beli ='1832000' WHERE kode_barcode='T0068927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0068925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1434000',harga_beli ='1434000' WHERE kode_barcode='T0072608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2517000',harga_beli ='2517000' WHERE kode_barcode='T0072973' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2167000',harga_beli ='2167000' WHERE kode_barcode='T0072972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='T0072615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1689000',harga_beli ='1689000' WHERE kode_barcode='T0072614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1561500',harga_beli ='1561500' WHERE kode_barcode='T0072613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1673000',harga_beli ='1673000' WHERE kode_barcode='T0072612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='T0072611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1673000',harga_beli ='1673000' WHERE kode_barcode='T0072610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1880000',harga_beli ='1880000' WHERE kode_barcode='T0072609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2023500',harga_beli ='2023500' WHERE kode_barcode='T0068923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2119000',harga_beli ='2119000' WHERE kode_barcode='T0072323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1561500',harga_beli ='1561500' WHERE kode_barcode='T0071651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1593000',harga_beli ='1593000' WHERE kode_barcode='T0071533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1657000',harga_beli ='1657000' WHERE kode_barcode='T0071532' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2119000',harga_beli ='2119000' WHERE kode_barcode='T0071528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1593000',harga_beli ='1593000' WHERE kode_barcode='T0071527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3234000',harga_beli ='3234000' WHERE kode_barcode='T0071248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3552500',harga_beli ='3552500' WHERE kode_barcode='T0070767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3266000',harga_beli ='3266000' WHERE kode_barcode='T0063014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3409500',harga_beli ='3409500' WHERE kode_barcode='T0062325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1466000',harga_beli ='1466000' WHERE kode_barcode='T0072980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3664000',harga_beli ='3664000' WHERE kode_barcode='T0072978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2342000',harga_beli ='2342000' WHERE kode_barcode='T0072984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3823500',harga_beli ='3823500' WHERE kode_barcode='T0062985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1593000',harga_beli ='1593000' WHERE kode_barcode='T0072986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2119000',harga_beli ='2119000' WHERE kode_barcode='T0072985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1928000',harga_beli ='1928000' WHERE kode_barcode='T0072982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2007500',harga_beli ='2007500' WHERE kode_barcode='T0072979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1513500',harga_beli ='1513500' WHERE kode_barcode='T0063006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2995000',harga_beli ='2995000' WHERE kode_barcode='T0063013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2071000',harga_beli ='2071000' WHERE kode_barcode='T0062984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2565000',harga_beli ='2565000' WHERE kode_barcode='T0062972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1991500',harga_beli ='1991500' WHERE kode_barcode='T0072983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1848000',harga_beli ='1848000' WHERE kode_barcode='T0072981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2740000',harga_beli ='2740000' WHERE kode_barcode='T0062987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='5018000',harga_beli ='5018000' WHERE kode_barcode='T0063011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3871500',harga_beli ='3871500' WHERE kode_barcode='T0063012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1752500',harga_beli ='1752500' WHERE kode_barcode='T0062970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1625000',harga_beli ='1625000' WHERE kode_barcode='T0062991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1163000',harga_beli ='1163000' WHERE kode_barcode='T0068921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3186000',harga_beli ='3186000' WHERE kode_barcode='T0068147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2389500',harga_beli ='2389500' WHERE kode_barcode='T0065466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1991500',harga_beli ='1991500' WHERE kode_barcode='T0065465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2788000',harga_beli ='2788000' WHERE kode_barcode='T0065464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2995000',harga_beli ='2995000' WHERE kode_barcode='T0065463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3138500',harga_beli ='3138500' WHERE kode_barcode='T0065461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3186000',harga_beli ='3186000' WHERE kode_barcode='T0065459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1513500',harga_beli ='1513500' WHERE kode_barcode='T0065456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1848000',harga_beli ='1848000' WHERE kode_barcode='T0062981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1593000',harga_beli ='1593000' WHERE kode_barcode='T0062992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0062994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='2820000',harga_beli ='2820000' WHERE kode_barcode='T0062995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='4540500',harga_beli ='4540500' WHERE kode_barcode='T0062996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='3791500',harga_beli ='3791500' WHERE kode_barcode='T0062997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1609000',harga_beli ='1609000' WHERE kode_barcode='T0062999' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1848000',harga_beli ='1848000' WHERE kode_barcode='T0063000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1593000',harga_jual='1561500',harga_beli ='1561500' WHERE kode_barcode='T0063003' LIMIT 1;
UPDATE tm_group SET harga='1593000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','1593000','input','2025-09-19 12:40:54');
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1256000',harga_beli ='1256000' WHERE kode_barcode='T0040093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2093000',harga_beli ='2093000' WHERE kode_barcode='T0027959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0025242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2544000',harga_beli ='2544000' WHERE kode_barcode='T0027952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1207500',harga_beli ='1207500' WHERE kode_barcode='T0027928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='T0025243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2737000',harga_beli ='2737000' WHERE kode_barcode='T0029887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2141500',harga_beli ='2141500' WHERE kode_barcode='T0003111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4138000',harga_beli ='4138000' WHERE kode_barcode='T0003107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5957000',harga_beli ='5957000' WHERE kode_barcode='T0002687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3172000',harga_beli ='3172000' WHERE kode_barcode='T0003195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4025000',harga_beli ='4025000' WHERE kode_barcode='T0003210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1658500',harga_beli ='1658500' WHERE kode_barcode='T0050962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3027000',harga_beli ='3027000' WHERE kode_barcode='T0003563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2608500',harga_beli ='2608500' WHERE kode_barcode='T0003573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0029925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0003177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2286500',harga_beli ='2286500' WHERE kode_barcode='T0003180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2415000',harga_beli ='2415000' WHERE kode_barcode='T0003159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3478000',harga_beli ='3478000' WHERE kode_barcode='T0003161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2286500',harga_beli ='2286500' WHERE kode_barcode='T0003162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3075500',harga_beli ='3075500' WHERE kode_barcode='T0003163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1175500',harga_beli ='1175500' WHERE kode_barcode='T0003165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='757000',harga_beli ='757000' WHERE kode_barcode='T0003168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2093000',harga_beli ='2093000' WHERE kode_barcode='T0003169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1852000',harga_beli ='1852000' WHERE kode_barcode='T0003142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2206000',harga_beli ='2206000' WHERE kode_barcode='T0003146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3156000',harga_beli ='3156000' WHERE kode_barcode='T0003396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0003411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0003414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='805000',harga_beli ='805000' WHERE kode_barcode='T0003415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0003417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5490500',harga_beli ='5490500' WHERE kode_barcode='T0003419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2351000',harga_beli ='2351000' WHERE kode_barcode='T0003433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5796000',harga_beli ='5796000' WHERE kode_barcode='T0003434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2286500',harga_beli ='2286500' WHERE kode_barcode='T0003440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4508000',harga_beli ='4508000' WHERE kode_barcode='T0003449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3252500',harga_beli ='3252500' WHERE kode_barcode='T0003453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2995000',harga_beli ='2995000' WHERE kode_barcode='T0003460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2898000',harga_beli ='2898000' WHERE kode_barcode='T0003461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2995000',harga_beli ='2995000' WHERE kode_barcode='T0003466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='12928500',harga_beli ='12928500' WHERE kode_barcode='T0072990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2624500',harga_beli ='2624500' WHERE kode_barcode='T0003481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2351000',harga_beli ='2351000' WHERE kode_barcode='T0003482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2447500',harga_beli ='2447500' WHERE kode_barcode='T0003594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3461500',harga_beli ='3461500' WHERE kode_barcode='T0003587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='11286500',harga_beli ='11286500' WHERE kode_barcode='T0003370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1481500',harga_beli ='1481500' WHERE kode_barcode='T0004087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3011000',harga_beli ='3011000' WHERE kode_barcode='T0004022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6762000',harga_beli ='6762000' WHERE kode_barcode='T0072989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2286500',harga_beli ='2286500' WHERE kode_barcode='T0004055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1481500',harga_beli ='1481500' WHERE kode_barcode='T0004356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1449000',harga_beli ='1449000' WHERE kode_barcode='T0004351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6714000',harga_beli ='6714000' WHERE kode_barcode='T0025231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2222000',harga_beli ='2222000' WHERE kode_barcode='T0006172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1562000',harga_beli ='1562000' WHERE kode_barcode='T0006175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1690500',harga_beli ='1690500' WHERE kode_barcode='T0006198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4588500',harga_beli ='4588500' WHERE kode_barcode='T0006197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='T0006193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3381000',harga_beli ='3381000' WHERE kode_barcode='T0006190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0006414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3252500',harga_beli ='3252500' WHERE kode_barcode='T0001870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='837500',harga_beli ='837500' WHERE kode_barcode='T0008962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='918000',harga_beli ='918000' WHERE kode_barcode='T0008964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='T0008977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='7937500',harga_beli ='7937500' WHERE kode_barcode='T0072987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3059000',harga_beli ='3059000' WHERE kode_barcode='T0009202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2109500',harga_beli ='2109500' WHERE kode_barcode='T0009209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0009247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1336500',harga_beli ='1336500' WHERE kode_barcode='T0009232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2512000',harga_beli ='2512000' WHERE kode_barcode='T0009460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1932000',harga_beli ='1932000' WHERE kode_barcode='T0010055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2351000',harga_beli ='2351000' WHERE kode_barcode='T0010054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='934000',harga_beli ='934000' WHERE kode_barcode='T0014657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='998500',harga_beli ='998500' WHERE kode_barcode='T0014659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='998500',harga_beli ='998500' WHERE kode_barcode='T0014661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2351000',harga_beli ='2351000' WHERE kode_barcode='T0014715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1980500',harga_beli ='1980500' WHERE kode_barcode='T0017794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0017795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5925000',harga_beli ='5925000' WHERE kode_barcode='T0019180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3510000',harga_beli ='3510000' WHERE kode_barcode='T0019181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2544000',harga_beli ='2544000' WHERE kode_barcode='T0006407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1819500',harga_beli ='1819500' WHERE kode_barcode='T0013667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1368500',harga_beli ='1368500' WHERE kode_barcode='T0020102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2850000',harga_beli ='2850000' WHERE kode_barcode='T0022491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2367000',harga_beli ='2367000' WHERE kode_barcode='T0022487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2334500',harga_beli ='2334500' WHERE kode_barcode='T0022713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='T0023419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5232500',harga_beli ='5232500' WHERE kode_barcode='T0023410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0026794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='T0026793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0026789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='13041000',harga_beli ='13041000' WHERE kode_barcode='T0027384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6295500',harga_beli ='6295500' WHERE kode_barcode='T0027889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='32039500',harga_beli ='32039500' WHERE kode_barcode='T0027884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1900000',harga_beli ='1900000' WHERE kode_barcode='T0029673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1771500',harga_beli ='1771500' WHERE kode_barcode='T0029674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1819500',harga_beli ='1819500' WHERE kode_barcode='T0028822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2093000',harga_beli ='2093000' WHERE kode_barcode='T0031899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3156000',harga_beli ='3156000' WHERE kode_barcode='T0032995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1964500',harga_beli ='1964500' WHERE kode_barcode='T0032983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='886000',harga_beli ='886000' WHERE kode_barcode='T0032982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1449000',harga_beli ='1449000' WHERE kode_barcode='T0033052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6520500',harga_beli ='6520500' WHERE kode_barcode='T0033032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2673000',harga_beli ='2673000' WHERE kode_barcode='T0033506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1642500',harga_beli ='1642500' WHERE kode_barcode='T0033496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3993000',harga_beli ='3993000' WHERE kode_barcode='T0033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1127000',harga_beli ='1127000' WHERE kode_barcode='T0033647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='T0033728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1385000',harga_beli ='1385000' WHERE kode_barcode='T0034346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0034362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1449000',harga_beli ='1449000' WHERE kode_barcode='T0034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2834000',harga_beli ='2834000' WHERE kode_barcode='T0034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1658500',harga_beli ='1658500' WHERE kode_barcode='T0034754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='7969500',harga_beli ='7969500' WHERE kode_barcode='T0034743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='9048500',harga_beli ='9048500' WHERE kode_barcode='T0034735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0035004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0035014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='934000',harga_beli ='934000' WHERE kode_barcode='T0035012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1014500',harga_beli ='1014500' WHERE kode_barcode='T0035010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0035005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2769500',harga_beli ='2769500' WHERE kode_barcode='T0035430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2045000',harga_beli ='2045000' WHERE kode_barcode='T0035420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='11286500',harga_beli ='11286500' WHERE kode_barcode='T0035441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1417000',harga_beli ='1417000' WHERE kode_barcode='T0036248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='T0036259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4395500',harga_beli ='4395500' WHERE kode_barcode='T0037728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2512000',harga_beli ='2512000' WHERE kode_barcode='T0037995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1642500',harga_beli ='1642500' WHERE kode_barcode='T0038795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2817500',harga_beli ='2817500' WHERE kode_barcode='T0038788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1948500',harga_beli ='1948500' WHERE kode_barcode='T0037363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='966000',harga_beli ='966000' WHERE kode_barcode='T0039318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2141500',harga_beli ='2141500' WHERE kode_barcode='T0039315' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='T0039621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3107500',harga_beli ='3107500' WHERE kode_barcode='T0040098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1690500',harga_beli ='1690500' WHERE kode_barcode='T0040647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4347000',harga_beli ='4347000' WHERE kode_barcode='T0040632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6134500',harga_beli ='6134500' WHERE kode_barcode='T0040639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0040631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6311500',harga_beli ='6311500' WHERE kode_barcode='T0041178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='T0041170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2383000',harga_beli ='2383000' WHERE kode_barcode='T0041152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4186000',harga_beli ='4186000' WHERE kode_barcode='T0041163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3236500',harga_beli ='3236500' WHERE kode_barcode='T0041155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3011000',harga_beli ='3011000' WHERE kode_barcode='T0041154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3220000',harga_beli ='3220000' WHERE kode_barcode='T0041153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='13089500',harga_beli ='13089500' WHERE kode_barcode='T0041179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5957000',harga_beli ='5957000' WHERE kode_barcode='T0041183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6408000',harga_beli ='6408000' WHERE kode_barcode='T0041182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='902000',harga_beli ='902000' WHERE kode_barcode='T0041660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3542500',harga_beli ='3542500' WHERE kode_barcode='T0041651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1562000',harga_beli ='1562000' WHERE kode_barcode='T0041676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6327500',harga_beli ='6327500' WHERE kode_barcode='T0041681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1159500',harga_beli ='1159500' WHERE kode_barcode='T0042066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1063000',harga_beli ='1063000' WHERE kode_barcode='T0042067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0042068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1095000',harga_beli ='1095000' WHERE kode_barcode='T0042069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3059000',harga_beli ='3059000' WHERE kode_barcode='T0042203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3961000',harga_beli ='3961000' WHERE kode_barcode='T0042202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3510000',harga_beli ='3510000' WHERE kode_barcode='T0042199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4218500',harga_beli ='4218500' WHERE kode_barcode='T0042197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0042196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4685500',harga_beli ='4685500' WHERE kode_barcode='T0042192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2061000',harga_beli ='2061000' WHERE kode_barcode='T0042191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1320500',harga_beli ='1320500' WHERE kode_barcode='T0042186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1723000',harga_beli ='1723000' WHERE kode_barcode='T0042185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='11109000',harga_beli ='11109000' WHERE kode_barcode='T0042180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='10900000',harga_beli ='10900000' WHERE kode_barcode='T0042179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3139500',harga_beli ='3139500' WHERE kode_barcode='T0042177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3333000',harga_beli ='3333000' WHERE kode_barcode='T0042175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8066500',harga_beli ='8066500' WHERE kode_barcode='T0067270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3139500',harga_beli ='3139500' WHERE kode_barcode='T0042541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1368500',harga_beli ='1368500' WHERE kode_barcode='T0042537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1642500',harga_beli ='1642500' WHERE kode_barcode='T0042542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4508000',harga_beli ='4508000' WHERE kode_barcode='T0042530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2866000',harga_beli ='2866000' WHERE kode_barcode='T0042524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2544000',harga_beli ='2544000' WHERE kode_barcode='T0042514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4878500',harga_beli ='4878500' WHERE kode_barcode='T0042547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3317000',harga_beli ='3317000' WHERE kode_barcode='T0071233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2093000',harga_beli ='2093000' WHERE kode_barcode='T0042830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='15987500',harga_beli ='15987500' WHERE kode_barcode='T0067271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='918000',harga_beli ='918000' WHERE kode_barcode='T0043129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2012500',harga_beli ='2012500' WHERE kode_barcode='T0043098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2592500',harga_beli ='2592500' WHERE kode_barcode='T0043121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2125500',harga_beli ='2125500' WHERE kode_barcode='T0043110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4588500',harga_beli ='4588500' WHERE kode_barcode='T0043107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4798000',harga_beli ='4798000' WHERE kode_barcode='T0043105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4846500',harga_beli ='4846500' WHERE kode_barcode='T0043147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4588500',harga_beli ='4588500' WHERE kode_barcode='T0043150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2737000',harga_beli ='2737000' WHERE kode_barcode='T0043628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4057500',harga_beli ='4057500' WHERE kode_barcode='T0043629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5071500',harga_beli ='5071500' WHERE kode_barcode='T0043721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4959000',harga_beli ='4959000' WHERE kode_barcode='T0044041' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2576000',harga_beli ='2576000' WHERE kode_barcode='T0044045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8082500',harga_beli ='8082500' WHERE kode_barcode='T0044032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5442000',harga_beli ='5442000' WHERE kode_barcode='T0044034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6730000',harga_beli ='6730000' WHERE kode_barcode='T0072988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='805000',harga_beli ='805000' WHERE kode_barcode='T0044091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1626500',harga_beli ='1626500' WHERE kode_barcode='T0044166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1610000',harga_beli ='1610000' WHERE kode_barcode='T0044165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='T0044164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1771500',harga_beli ='1771500' WHERE kode_barcode='T0044162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8130500',harga_beli ='8130500' WHERE kode_barcode='T0044195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5876500',harga_beli ='5876500' WHERE kode_barcode='T0044286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2512000',harga_beli ='2512000' WHERE kode_barcode='T0044278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4669000',harga_beli ='4669000' WHERE kode_barcode='T0044276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4556500',harga_beli ='4556500' WHERE kode_barcode='T0044275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3381000',harga_beli ='3381000' WHERE kode_barcode='T0044274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3494000',harga_beli ='3494000' WHERE kode_barcode='T0044544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8292000',harga_beli ='8292000' WHERE kode_barcode='T0044545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3751500',harga_beli ='3751500' WHERE kode_barcode='T0044564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0045115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0045117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0045123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1175500',harga_beli ='1175500' WHERE kode_barcode='T0045127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1852000',harga_beli ='1852000' WHERE kode_barcode='T0045283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2834000',harga_beli ='2834000' WHERE kode_barcode='T0045348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2061000',harga_beli ='2061000' WHERE kode_barcode='T0045354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0045355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2334500',harga_beli ='2334500' WHERE kode_barcode='T0045362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5007500',harga_beli ='5007500' WHERE kode_barcode='T0045384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3558500',harga_beli ='3558500' WHERE kode_barcode='T0045378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2061000',harga_beli ='2061000' WHERE kode_barcode='T0045367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2093000',harga_beli ='2093000' WHERE kode_barcode='T0045366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3590500',harga_beli ='3590500' WHERE kode_barcode='T0044947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4025000',harga_beli ='4025000' WHERE kode_barcode='T0045389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1304500',harga_beli ='1304500' WHERE kode_barcode='T0046053' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3333000',harga_beli ='3333000' WHERE kode_barcode='T0046088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2769500',harga_beli ='2769500' WHERE kode_barcode='T0046089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4266500',harga_beli ='4266500' WHERE kode_barcode='T0046090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1207500',harga_beli ='1207500' WHERE kode_barcode='T0046370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='966000',harga_beli ='966000' WHERE kode_barcode='T0047389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2190000',harga_beli ='2190000' WHERE kode_barcode='T0047390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1626500',harga_beli ='1626500' WHERE kode_barcode='T0047393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3590500',harga_beli ='3590500' WHERE kode_barcode='T0047396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0047398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2012500',harga_beli ='2012500' WHERE kode_barcode='T0047401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4363500',harga_beli ='4363500' WHERE kode_barcode='T0047416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4073500',harga_beli ='4073500' WHERE kode_barcode='T0047427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1852000',harga_beli ='1852000' WHERE kode_barcode='T0047423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2431500',harga_beli ='2431500' WHERE kode_barcode='T0047418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3977000',harga_beli ='3977000' WHERE kode_barcode='T0047417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3413500',harga_beli ='3413500' WHERE kode_barcode='T0047414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3236500',harga_beli ='3236500' WHERE kode_barcode='T0047409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3864000',harga_beli ='3864000' WHERE kode_barcode='T0047408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='11045000',harga_beli ='11045000' WHERE kode_barcode='T0047429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4218500',harga_beli ='4218500' WHERE kode_barcode='T0047434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0047435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4749500',harga_beli ='4749500' WHERE kode_barcode='T0047436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0047728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1690500',harga_beli ='1690500' WHERE kode_barcode='T0048345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1610000',harga_beli ='1610000' WHERE kode_barcode='T0048740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0048741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='692500',harga_beli ='692500' WHERE kode_barcode='T0048987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1868000',harga_beli ='1868000' WHERE kode_barcode='T0048992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='837500',harga_beli ='837500' WHERE kode_barcode='T0049666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3655000',harga_beli ='3655000' WHERE kode_barcode='T0049688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0049690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2061000',harga_beli ='2061000' WHERE kode_barcode='T0049691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1175500',harga_beli ='1175500' WHERE kode_barcode='T0049701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1256000',harga_beli ='1256000' WHERE kode_barcode='T0049702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4878500',harga_beli ='4878500' WHERE kode_barcode='T0049669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0049674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4669000',harga_beli ='4669000' WHERE kode_barcode='T0049676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3349000',harga_beli ='3349000' WHERE kode_barcode='T0049677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4878500',harga_beli ='4878500' WHERE kode_barcode='T0049679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0049682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0049684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2850000',harga_beli ='2850000' WHERE kode_barcode='T0049686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='7986000',harga_beli ='7986000' WHERE kode_barcode='T0049707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='7004000',harga_beli ='7004000' WHERE kode_barcode='T0049711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='934000',harga_beli ='934000' WHERE kode_barcode='T0049951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3333000',harga_beli ='3333000' WHERE kode_barcode='T0050016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3091500',harga_beli ='3091500' WHERE kode_barcode='T0049966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='15150500',harga_beli ='15150500' WHERE kode_barcode='T0050021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1546000',harga_beli ='1546000' WHERE kode_barcode='T0050453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2576000',harga_beli ='2576000' WHERE kode_barcode='T0050454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2367000',harga_beli ='2367000' WHERE kode_barcode='T0050457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1868000',harga_beli ='1868000' WHERE kode_barcode='T0050487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1368500',harga_beli ='1368500' WHERE kode_barcode='T0050486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='T0050484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3172000',harga_beli ='3172000' WHERE kode_barcode='T0050483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2817500',harga_beli ='2817500' WHERE kode_barcode='T0050482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3333000',harga_beli ='3333000' WHERE kode_barcode='T0050479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1852000',harga_beli ='1852000' WHERE kode_barcode='T0050478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1610000',harga_beli ='1610000' WHERE kode_barcode='T0050469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1690500',harga_beli ='1690500' WHERE kode_barcode='T0050491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5007500',harga_beli ='5007500' WHERE kode_barcode='T0050492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0050822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2834000',harga_beli ='2834000' WHERE kode_barcode='T0050826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2673000',harga_beli ='2673000' WHERE kode_barcode='T0051688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1095000',harga_beli ='1095000' WHERE kode_barcode='T0051691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1690500',harga_beli ='1690500' WHERE kode_barcode='T0051693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0051694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2673000',harga_beli ='2673000' WHERE kode_barcode='T0051704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0051705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='966000',harga_beli ='966000' WHERE kode_barcode='T0051708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2817500',harga_beli ='2817500' WHERE kode_barcode='T0051739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3783500',harga_beli ='3783500' WHERE kode_barcode='T0051735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1819500',harga_beli ='1819500' WHERE kode_barcode='T0051738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3220000',harga_beli ='3220000' WHERE kode_barcode='T0051741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1787500',harga_beli ='1787500' WHERE kode_barcode='T0051742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2254000',harga_beli ='2254000' WHERE kode_barcode='T0051743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='T0051745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2367000',harga_beli ='2367000' WHERE kode_barcode='T0051746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3252500',harga_beli ='3252500' WHERE kode_barcode='T0051747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2995000',harga_beli ='2995000' WHERE kode_barcode='T0051719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5184500',harga_beli ='5184500' WHERE kode_barcode='T0051710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8469000',harga_beli ='8469000' WHERE kode_barcode='T0051712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3542500',harga_beli ='3542500' WHERE kode_barcode='T0051714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3800000',harga_beli ='3800000' WHERE kode_barcode='T0051716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='19433000',harga_beli ='19433000' WHERE kode_barcode='T0051757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='14892500',harga_beli ='14892500' WHERE kode_barcode='T0051759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4299000',harga_beli ='4299000' WHERE kode_barcode='T0051760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4669000',harga_beli ='4669000' WHERE kode_barcode='T0051764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0052826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1336500',harga_beli ='1336500' WHERE kode_barcode='T0052831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1658500',harga_beli ='1658500' WHERE kode_barcode='T0052833' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2061000',harga_beli ='2061000' WHERE kode_barcode='T0052834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='13202500',harga_beli ='13202500' WHERE kode_barcode='T0052836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='16132500',harga_beli ='16132500' WHERE kode_barcode='T0052839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='16213000',harga_beli ='16213000' WHERE kode_barcode='T0052840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8163000',harga_beli ='8163000' WHERE kode_barcode='T0052841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5635000',harga_beli ='5635000' WHERE kode_barcode='T0052843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3317000',harga_beli ='3317000' WHERE kode_barcode='T0052914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1658500',harga_beli ='1658500' WHERE kode_barcode='T0052917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1497500',harga_beli ='1497500' WHERE kode_barcode='T0052918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='837500',harga_beli ='837500' WHERE kode_barcode='T0052920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0052922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4186000',harga_beli ='4186000' WHERE kode_barcode='T0052937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2431500',harga_beli ='2431500' WHERE kode_barcode='T0052935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='T0052930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5554500',harga_beli ='5554500' WHERE kode_barcode='T0052925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='T0052943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='16181000',harga_beli ='16181000' WHERE kode_barcode='T0052947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6859000',harga_beli ='6859000' WHERE kode_barcode='T0052950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5313000',harga_beli ='5313000' WHERE kode_barcode='T0052951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5506500',harga_beli ='5506500' WHERE kode_barcode='T0052952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1288000',harga_beli ='1288000' WHERE kode_barcode='T0054111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1288000',harga_beli ='1288000' WHERE kode_barcode='T0054112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='32393500',harga_beli ='32393500' WHERE kode_barcode='T0054235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1224000',harga_beli ='1224000' WHERE kode_barcode='T0054302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0054303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1095000',harga_beli ='1095000' WHERE kode_barcode='T0054306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1787500',harga_beli ='1787500' WHERE kode_barcode='T0054305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1964500',harga_beli ='1964500' WHERE kode_barcode='T0054307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3429500',harga_beli ='3429500' WHERE kode_barcode='T0054341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3252500',harga_beli ='3252500' WHERE kode_barcode='T0054340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2302500',harga_beli ='2302500' WHERE kode_barcode='T0054339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='13926500',harga_beli ='13926500' WHERE kode_barcode='T0054337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1723000',harga_beli ='1723000' WHERE kode_barcode='T0054335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3381000',harga_beli ='3381000' WHERE kode_barcode='T0054332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2431500',harga_beli ='2431500' WHERE kode_barcode='T0054327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2254000',harga_beli ='2254000' WHERE kode_barcode='T0054322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3139500',harga_beli ='3139500' WHERE kode_barcode='T0054320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4524500',harga_beli ='4524500' WHERE kode_barcode='T0054318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6198500',harga_beli ='6198500' WHERE kode_barcode='T0054361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6279000',harga_beli ='6279000' WHERE kode_barcode='T0054359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4717500',harga_beli ='4717500' WHERE kode_barcode='T0054357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1868000',harga_beli ='1868000' WHERE kode_barcode='T0055401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1787500',harga_beli ='1787500' WHERE kode_barcode='T0056273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='886000',harga_beli ='886000' WHERE kode_barcode='T0056279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5989500',harga_beli ='5989500' WHERE kode_barcode='T0056283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2817500',harga_beli ='2817500' WHERE kode_barcode='T0056286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0056288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1771500',harga_beli ='1771500' WHERE kode_barcode='T0056289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2737000',harga_beli ='2737000' WHERE kode_barcode='T0056291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2109500',harga_beli ='2109500' WHERE kode_barcode='T0056292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1787500',harga_beli ='1787500' WHERE kode_barcode='T0056293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1932000',harga_beli ='1932000' WHERE kode_barcode='T0056294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3333000',harga_beli ='3333000' WHERE kode_barcode='T0056296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1964500',harga_beli ='1964500' WHERE kode_barcode='T0056297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8050000',harga_beli ='8050000' WHERE kode_barcode='T0056298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='31926500',harga_beli ='31926500' WHERE kode_barcode='T0056306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5023500',harga_beli ='5023500' WHERE kode_barcode='T0056310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='886000',harga_beli ='886000' WHERE kode_barcode='T0056710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2930500',harga_beli ='2930500' WHERE kode_barcode='T0056717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4025000',harga_beli ='4025000' WHERE kode_barcode='T0056722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='32361500',harga_beli ='32361500' WHERE kode_barcode='T0056723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1690500',harga_beli ='1690500' WHERE kode_barcode='T0056726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2946500',harga_beli ='2946500' WHERE kode_barcode='T0056729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6682000',harga_beli ='6682000' WHERE kode_barcode='T0056734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0057085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2463500',harga_beli ='2463500' WHERE kode_barcode='T0057087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3429500',harga_beli ='3429500' WHERE kode_barcode='T0057088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0057099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2383000',harga_beli ='2383000' WHERE kode_barcode='T0057100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1368500',harga_beli ='1368500' WHERE kode_barcode='T0057101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2334500',harga_beli ='2334500' WHERE kode_barcode='T0057121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4122000',harga_beli ='4122000' WHERE kode_barcode='T0057123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='T0057124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1207500',harga_beli ='1207500' WHERE kode_barcode='T0057125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0057133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2592500',harga_beli ='2592500' WHERE kode_barcode='T0057136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3188000',harga_beli ='3188000' WHERE kode_barcode='T0057112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='805000',harga_beli ='805000' WHERE kode_barcode='T0057106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1079000',harga_beli ='1079000' WHERE kode_barcode='T0057107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1884000',harga_beli ='1884000' WHERE kode_barcode='T0057108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5104000',harga_beli ='5104000' WHERE kode_barcode='T0057111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3220000',harga_beli ='3220000' WHERE kode_barcode='T0057103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0057147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6392000',harga_beli ='6392000' WHERE kode_barcode='T0057156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='13202500',harga_beli ='13202500' WHERE kode_barcode='T0057155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='7937500',harga_beli ='7937500' WHERE kode_barcode='T0057137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1852000',harga_beli ='1852000' WHERE kode_barcode='T0057146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8130500',harga_beli ='8130500' WHERE kode_barcode='T0057141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='7325500',harga_beli ='7325500' WHERE kode_barcode='T0057140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6617500',harga_beli ='6617500' WHERE kode_barcode='T0057560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0058798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='998500',harga_beli ='998500' WHERE kode_barcode='T0071231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1996500',harga_beli ='1996500' WHERE kode_barcode='T0059280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='T0059276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1497500',harga_beli ='1497500' WHERE kode_barcode='T0059333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1739000',harga_beli ='1739000' WHERE kode_barcode='T0059334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3961000',harga_beli ='3961000' WHERE kode_barcode='T0059337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1723000',harga_beli ='1723000' WHERE kode_barcode='T0059376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1481500',harga_beli ='1481500' WHERE kode_barcode='T0059495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2141500',harga_beli ='2141500' WHERE kode_barcode='T0059498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0059500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4266500',harga_beli ='4266500' WHERE kode_barcode='T0059520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2817500',harga_beli ='2817500' WHERE kode_barcode='T0059519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1771500',harga_beli ='1771500' WHERE kode_barcode='T0059517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3236500',harga_beli ='3236500' WHERE kode_barcode='T0059516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0059507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0059506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2737000',harga_beli ='2737000' WHERE kode_barcode='T0059505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4588500',harga_beli ='4588500' WHERE kode_barcode='T0059503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4154000',harga_beli ='4154000' WHERE kode_barcode='T0059502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4395500',harga_beli ='4395500' WHERE kode_barcode='T0059527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5635000',harga_beli ='5635000' WHERE kode_barcode='T0042036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='966000',harga_beli ='966000' WHERE kode_barcode='T0071232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4798000',harga_beli ='4798000' WHERE kode_barcode='T0063029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='T0063030' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8340000',harga_beli ='8340000' WHERE kode_barcode='T0063031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5844500',harga_beli ='5844500' WHERE kode_barcode='T0063022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4830000',harga_beli ='4830000' WHERE kode_barcode='T0071236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2383000',harga_beli ='2383000' WHERE kode_barcode='T0071237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3301000',harga_beli ='3301000' WHERE kode_barcode='T0064224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3381000',harga_beli ='3381000' WHERE kode_barcode='T0064225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5651500',harga_beli ='5651500' WHERE kode_barcode='T0064227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='11302500',harga_beli ='11302500' WHERE kode_barcode='T0065471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6231000',harga_beli ='6231000' WHERE kode_barcode='T0065472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='5442000',harga_beli ='5442000' WHERE kode_barcode='T0065473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1690500',harga_beli ='1690500' WHERE kode_barcode='T0066779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='T0068753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='853500',harga_beli ='853500' WHERE kode_barcode='T0068752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8082500',harga_beli ='8082500' WHERE kode_barcode='T0068740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3172000',harga_beli ='3172000' WHERE kode_barcode='T0068741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4927000',harga_beli ='4927000' WHERE kode_barcode='T0068754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3220000',harga_beli ='3220000' WHERE kode_barcode='T0068739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='2447500',harga_beli ='2447500' WHERE kode_barcode='T0068948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='966000',harga_beli ='966000' WHERE kode_barcode='T0069499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1014500',harga_beli ='1014500' WHERE kode_barcode='T0069500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='821500',harga_beli ='821500' WHERE kode_barcode='T0069501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3268500',harga_beli ='3268500' WHERE kode_barcode='T0069932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1723000',harga_beli ='1723000' WHERE kode_barcode='T0069934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3252500',harga_beli ='3252500' WHERE kode_barcode='T0069935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3204000',harga_beli ='3204000' WHERE kode_barcode='T0069936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4910500',harga_beli ='4910500' WHERE kode_barcode='T0069938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8066500',harga_beli ='8066500' WHERE kode_barcode='T0070158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='7841000',harga_beli ='7841000' WHERE kode_barcode='T0070159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6585000',harga_beli ='6585000' WHERE kode_barcode='T0070160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='982500',harga_beli ='982500' WHERE kode_barcode='T0070495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='918000',harga_beli ='918000' WHERE kode_barcode='T0070509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='16470500',harga_beli ='16470500' WHERE kode_barcode='T0070514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4186000',harga_beli ='4186000' WHERE kode_barcode='T0070515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='19288000',harga_beli ='19288000' WHERE kode_barcode='T0070516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1127000',harga_beli ='1127000' WHERE kode_barcode='T0070763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='1046500',harga_beli ='1046500' WHERE kode_barcode='T0071530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='6263000',harga_beli ='6263000' WHERE kode_barcode='T0071525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='T0071526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4975000',harga_beli ='4975000' WHERE kode_barcode='T0071529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='8211500',harga_beli ='8211500' WHERE kode_barcode='T0072100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='757000',harga_beli ='757000' WHERE kode_barcode='T0072605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='757000',harga_beli ='757000' WHERE kode_barcode='T0072637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3832000',harga_beli ='3832000' WHERE kode_barcode='T0072606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='902000',harga_beli ='902000' WHERE kode_barcode='T0072977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='3413500',harga_beli ='3413500' WHERE kode_barcode='T0072633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='4894500',harga_beli ='4894500' WHERE kode_barcode='T0072634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='724500',harga_beli ='724500' WHERE kode_barcode='T0072975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1610000',harga_jual='886000',harga_beli ='886000' WHERE kode_barcode='T0072976' LIMIT 1;
UPDATE tm_group SET harga='1610000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','1610000','input','2025-09-19 12:41:09');
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4328000',harga_beli ='4328000' WHERE kode_barcode='T0027903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='765000',harga_beli ='765000' WHERE kode_barcode='T0027962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3303000',harga_beli ='3303000' WHERE kode_barcode='T0025250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4067500',harga_beli ='4067500' WHERE kode_barcode='T0025240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='8233000',harga_beli ='8233000' WHERE kode_barcode='T0002682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4962500',harga_beli ='4962500' WHERE kode_barcode='T0002681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4832500',harga_beli ='4832500' WHERE kode_barcode='T0002680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6524500',harga_beli ='6524500' WHERE kode_barcode='T0002701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3579500',harga_beli ='3579500' WHERE kode_barcode='T0002702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4995000',harga_beli ='4995000' WHERE kode_barcode='T0002545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='813500',harga_beli ='813500' WHERE kode_barcode='T0062974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4393000',harga_beli ='4393000' WHERE kode_barcode='T0003215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4035000',harga_beli ='4035000' WHERE kode_barcode='T0003578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2034000',harga_beli ='2034000' WHERE kode_barcode='T0029910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2701000',harga_beli ='2701000' WHERE kode_barcode='T0003883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='8070000',harga_beli ='8070000' WHERE kode_barcode='T0006181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5255500',harga_beli ='5255500' WHERE kode_barcode='T0009249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5304500',harga_beli ='5304500' WHERE kode_barcode='T0027907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='976500',harga_beli ='976500' WHERE kode_barcode='T0062967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2929000',harga_beli ='2929000' WHERE kode_barcode='T0027964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1952500',harga_beli ='1952500' WHERE kode_barcode='T0029909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='24356500',harga_beli ='24356500' WHERE kode_barcode='T0014667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='11080000',harga_beli ='11080000' WHERE kode_barcode='T0014724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6687000',harga_beli ='6687000' WHERE kode_barcode='T0001396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5564500',harga_beli ='5564500' WHERE kode_barcode='T0021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3596000',harga_beli ='3596000' WHERE kode_barcode='T0021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1302000',harga_beli ='1302000' WHERE kode_barcode='T0022496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='830000',harga_beli ='830000' WHERE kode_barcode='T0022495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4507000',harga_beli ='4507000' WHERE kode_barcode='T0022928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3433000',harga_beli ='3433000' WHERE kode_barcode='T0023426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6996500',harga_beli ='6996500' WHERE kode_barcode='T0023442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2327000',harga_beli ='2327000' WHERE kode_barcode='T0001914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='813500',harga_beli ='813500' WHERE kode_barcode='T0026797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3417000',harga_beli ='3417000' WHERE kode_barcode='T0026857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4930000',harga_beli ='4930000' WHERE kode_barcode='T0026861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='T0029908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='24405000',harga_beli ='24405000' WHERE kode_barcode='T0029659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3449500',harga_beli ='3449500' WHERE kode_barcode='T0029880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3449500',harga_beli ='3449500' WHERE kode_barcode='T0031224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='13130000',harga_beli ='13130000' WHERE kode_barcode='T0002012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='12853500',harga_beli ='12853500' WHERE kode_barcode='T0023388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='8314000',harga_beli ='8314000' WHERE kode_barcode='T0032844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2375500',harga_beli ='2375500' WHERE kode_barcode='T0032978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5060000',harga_beli ='5060000' WHERE kode_barcode='T0033642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4491000',harga_beli ='4491000' WHERE kode_barcode='T0034358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3173000',harga_beli ='3173000' WHERE kode_barcode='T0034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6394500',harga_beli ='6394500' WHERE kode_barcode='T0034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='T0034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1220500',harga_beli ='1220500' WHERE kode_barcode='T0034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3531000',harga_beli ='3531000' WHERE kode_barcode='T0035428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='15961000',harga_beli ='15961000' WHERE kode_barcode='T0036272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='927500',harga_beli ='927500' WHERE kode_barcode='T0036773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1383000',harga_beli ='1383000' WHERE kode_barcode='T0036774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3043000',harga_beli ='3043000' WHERE kode_barcode='T0037241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='11633500',harga_beli ='11633500' WHERE kode_barcode='T0037438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='T0037911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1627000',harga_beli ='1627000' WHERE kode_barcode='T0038821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1416000',harga_beli ='1416000' WHERE kode_barcode='T0038822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1578500',harga_beli ='1578500' WHERE kode_barcode='T0038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3693500',harga_beli ='3693500' WHERE kode_barcode='T0038800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='765000',harga_beli ='765000' WHERE kode_barcode='T0038825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='15880000',harga_beli ='15880000' WHERE kode_barcode='T0038814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3368000',harga_beli ='3368000' WHERE kode_barcode='T0039187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2571000',harga_beli ='2571000' WHERE kode_barcode='T0040115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='11519500',harga_beli ='11519500' WHERE kode_barcode='T0040117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='8298000',harga_beli ='8298000' WHERE kode_barcode='T0040118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4230500',harga_beli ='4230500' WHERE kode_barcode='T0040624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4572000',harga_beli ='4572000' WHERE kode_barcode='T0040627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5076500',harga_beli ='5076500' WHERE kode_barcode='T0040626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6524500',harga_beli ='6524500' WHERE kode_barcode='T0040623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3498500',harga_beli ='3498500' WHERE kode_barcode='T0041161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3433000',harga_beli ='3433000' WHERE kode_barcode='T0041160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2375500',harga_beli ='2375500' WHERE kode_barcode='T0041674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3384500',harga_beli ='3384500' WHERE kode_barcode='T0041675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='16514500',harga_beli ='16514500' WHERE kode_barcode='T0041931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='T0042204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4962500',harga_beli ='4962500' WHERE kode_barcode='T0071235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='9713500',harga_beli ='9713500' WHERE kode_barcode='T0042400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='T0042533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='976500',harga_beli ='976500' WHERE kode_barcode='T0043133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4783500',harga_beli ='4783500' WHERE kode_barcode='T0043381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='944000',harga_beli ='944000' WHERE kode_barcode='T0044092' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1790000',harga_beli ='1790000' WHERE kode_barcode='T0044157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='T0044158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='830000',harga_beli ='830000' WHERE kode_barcode='T0044160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4230500',harga_beli ='4230500' WHERE kode_barcode='T0045278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='8330500',harga_beli ='8330500' WHERE kode_barcode='T0045290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='895000',harga_beli ='895000' WHERE kode_barcode='T0045374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='813500',harga_beli ='813500' WHERE kode_barcode='T0045369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3221500',harga_beli ='3221500' WHERE kode_barcode='T0046373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1529500',harga_beli ='1529500' WHERE kode_barcode='T0072991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2489500',harga_beli ='2489500' WHERE kode_barcode='T0047403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='895000',harga_beli ='895000' WHERE kode_barcode='T0047406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4962500',harga_beli ='4962500' WHERE kode_barcode='T0047431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5694500',harga_beli ='5694500' WHERE kode_barcode='T0047440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2196500',harga_beli ='2196500' WHERE kode_barcode='T0048974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2066500',harga_beli ='2066500' WHERE kode_barcode='T0049662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='T0049706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='T0049721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3303000',harga_beli ='3303000' WHERE kode_barcode='T0050466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6671000',harga_beli ='6671000' WHERE kode_barcode='T0050927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3498500',harga_beli ='3498500' WHERE kode_barcode='T0051696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='830000',harga_beli ='830000' WHERE kode_barcode='T0051697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1904000',harga_beli ='1904000' WHERE kode_barcode='T0051698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3417000',harga_beli ='3417000' WHERE kode_barcode='T0051699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='944000',harga_beli ='944000' WHERE kode_barcode='T0051709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4409500',harga_beli ='4409500' WHERE kode_barcode='T0051773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1497000',harga_beli ='1497000' WHERE kode_barcode='T0052760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1090500',harga_beli ='1090500' WHERE kode_barcode='T0052761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1025500',harga_beli ='1025500' WHERE kode_barcode='T0052762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1188000',harga_beli ='1188000' WHERE kode_barcode='T0052763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='7566000',harga_beli ='7566000' WHERE kode_barcode='T0052782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5044000',harga_beli ='5044000' WHERE kode_barcode='T0052784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='8184000',harga_beli ='8184000' WHERE kode_barcode='T0052845' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='T0052907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2196500',harga_beli ='2196500' WHERE kode_barcode='T0052910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1708500',harga_beli ='1708500' WHERE kode_barcode='T0052915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='T0052919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4523500',harga_beli ='4523500' WHERE kode_barcode='T0052938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6264000',harga_beli ='6264000' WHERE kode_barcode='T0054364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3498500',harga_beli ='3498500' WHERE kode_barcode='T0054370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='5694500',harga_beli ='5694500' WHERE kode_barcode='T0054371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1790000',harga_beli ='1790000' WHERE kode_barcode='T0056709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3026500',harga_beli ='3026500' WHERE kode_barcode='T0056728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1708500',harga_beli ='1708500' WHERE kode_barcode='T0056814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1350500',harga_beli ='1350500' WHERE kode_barcode='T0056815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6589500',harga_beli ='6589500' WHERE kode_barcode='T0056834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='6394500',harga_beli ='6394500' WHERE kode_barcode='T0057159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3319500',harga_beli ='3319500' WHERE kode_barcode='T0071234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='T0071230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='911500',harga_beli ='911500' WHERE kode_barcode='T0065973' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='10006500',harga_beli ='10006500' WHERE kode_barcode='T0059340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1188000',harga_beli ='1188000' WHERE kode_barcode='T0059377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='16189000',harga_beli ='16189000' WHERE kode_barcode='T0059529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='813500',harga_beli ='813500' WHERE kode_barcode='T0062988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='9648500',harga_beli ='9648500' WHERE kode_barcode='T0063020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='8314000',harga_beli ='8314000' WHERE kode_barcode='T0063023' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='895000',harga_beli ='895000' WHERE kode_barcode='T0066579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2294500',harga_beli ='2294500' WHERE kode_barcode='T0068917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3384500',harga_beli ='3384500' WHERE kode_barcode='T0068933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='3335500',harga_beli ='3335500' WHERE kode_barcode='T0070154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='2522000',harga_beli ='2522000' WHERE kode_barcode='T0070155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='813500',harga_beli ='813500' WHERE kode_barcode='T0070492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='813500',harga_beli ='813500' WHERE kode_barcode='T0070494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1985000',harga_beli ='1985000' WHERE kode_barcode='T0070507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='1106500',harga_beli ='1106500' WHERE kode_barcode='T0070764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4832500',harga_beli ='4832500' WHERE kode_barcode='T0071515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4783500',harga_beli ='4783500' WHERE kode_barcode='T0072099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='4767500',harga_beli ='4767500' WHERE kode_barcode='T0072636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1627000',harga_jual='813500',harga_beli ='813500' WHERE kode_barcode='T0072974' LIMIT 1;
UPDATE tm_group SET harga='1627000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','1627000','input','2025-09-19 12:41:30');
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3387000',harga_beli ='3387000' WHERE kode_barcode='T0063019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='1151000',harga_beli ='1151000' WHERE kode_barcode='T0045109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5146000',harga_beli ='5146000' WHERE kode_barcode='T0053759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='1118000',harga_beli ='1118000' WHERE kode_barcode='T0047446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3946000',harga_beli ='3946000' WHERE kode_barcode='T0048975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='6445000',harga_beli ='6445000' WHERE kode_barcode='T0049718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5869500',harga_beli ='5869500' WHERE kode_barcode='T0050025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5113000',harga_beli ='5113000' WHERE kode_barcode='T0050028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='4784500',harga_beli ='4784500' WHERE kode_barcode='T0050029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='2088000',harga_beli ='2088000' WHERE kode_barcode='T0051751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='6708000',harga_beli ='6708000' WHERE kode_barcode='T0051771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='8023000',harga_beli ='8023000' WHERE kode_barcode='T0057162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5392500',harga_beli ='5392500' WHERE kode_barcode='T0059521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='822000',harga_beli ='822000' WHERE kode_barcode='T0060275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='8319000',harga_beli ='8319000' WHERE kode_barcode='T0063024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='691000',harga_beli ='691000' WHERE kode_barcode='T0045111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5507500',harga_beli ='5507500' WHERE kode_barcode='T0065474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='4209000',harga_beli ='4209000' WHERE kode_barcode='T0066778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='2417000',harga_beli ='2417000' WHERE kode_barcode='T0069579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='2466000',harga_beli ='2466000' WHERE kode_barcode='T0069580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0069582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='2351000',harga_beli ='2351000' WHERE kode_barcode='T0069583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='T0069584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3337500',harga_beli ='3337500' WHERE kode_barcode='T0070517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='674500',harga_beli ='674500' WHERE kode_barcode='T0070519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='6675000',harga_beli ='6675000' WHERE kode_barcode='T0065449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3173000',harga_beli ='3173000' WHERE kode_barcode='T0069911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='4948500',harga_beli ='4948500' WHERE kode_barcode='T0072632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='427500',harga_beli ='427500' WHERE kode_barcode='T0072971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='13316500',harga_beli ='13316500' WHERE kode_barcode='T0033027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3370500',harga_beli ='3370500' WHERE kode_barcode='T0026463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='592000',harga_beli ='592000' WHERE kode_barcode='T0062982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5031000',harga_beli ='5031000' WHERE kode_barcode='T0001778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='4225500',harga_beli ='4225500' WHERE kode_barcode='T0009257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3863500',harga_beli ='3863500' WHERE kode_barcode='T0012680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='4702000',harga_beli ='4702000' WHERE kode_barcode='T0027564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='7727000',harga_beli ='7727000' WHERE kode_barcode='T0029906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5343000',harga_beli ='5343000' WHERE kode_barcode='T0031228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5705000',harga_beli ='5705000' WHERE kode_barcode='T0031229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3485500',harga_beli ='3485500' WHERE kode_barcode='T0031706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='11508000',harga_beli ='11508000' WHERE kode_barcode='T0033026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='4965000',harga_beli ='4965000' WHERE kode_barcode='T0033040' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='4061000',harga_beli ='4061000' WHERE kode_barcode='T0033038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='9996000',harga_beli ='9996000' WHERE kode_barcode='T0033028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='12988000',harga_beli ='12988000' WHERE kode_barcode='T0002535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='8417500',harga_beli ='8417500' WHERE kode_barcode='T0033650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3420000',harga_beli ='3420000' WHERE kode_barcode='T0033858' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='19580500',harga_beli ='19580500' WHERE kode_barcode='T0001409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='691000',harga_beli ='691000' WHERE kode_barcode='T0029798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='13070000',harga_beli ='13070000' WHERE kode_barcode='T0035449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3535000',harga_beli ='3535000' WHERE kode_barcode='T0037440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='11508000',harga_beli ='11508000' WHERE kode_barcode='T0038313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='16473000',harga_beli ='16473000' WHERE kode_barcode='T0038811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='6165000',harga_beli ='6165000' WHERE kode_barcode='T0039636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='8236500',harga_beli ='8236500' WHERE kode_barcode='T0039646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='5195500',harga_beli ='5195500' WHERE kode_barcode='T0040120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='8384500',harga_beli ='8384500' WHERE kode_barcode='T0042655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1644000',harga_jual='3288000',harga_beli ='3288000' WHERE kode_barcode='T0043700' LIMIT 1;
UPDATE tm_group SET harga='1644000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','1644000','input','2025-09-19 12:41:46');
UPDATE tm_barang SET harga_skrg ='1661000',harga_jual='20148000',harga_beli ='20148000' WHERE kode_barcode='T0038815' LIMIT 1;
UPDATE tm_group SET harga='1661000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','1661000','input','2025-09-19 12:41:57');
UPDATE tm_group SET harga='1678000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','1678000','input','2025-09-19 12:42:08');
UPDATE tm_group SET harga='1695000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','1695000','input','2025-09-19 12:42:16');
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 ('F325191245561','input','1',' MFF1 XX UB','TOKO','PM-F','F1F-YGAI-118-0','GL XX PIPA TINJU ANAK UB 42 8K ','','2.180','1','100.00','2021000','0','0','15000','1955000','0','0','0','1955000','SIN','00361871','F1F','0','0','-','1','927000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1F-YGAI-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='F1F-YGAI-118-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325191245561','2025-09-19','2.180','2025-09-19','12:45:57','PLG0024934','1955000','1955000','0','1955000','1955000','input','2025-09-19 12:45:56','F32519124556');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325191245561','2025-09-19','12:45:57','SIN','1955000','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-250919-0014','D','2025-09-19','12:45:57','input','PENJUALAN','F325191245561','60969000','1955000','62924000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1955000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191245561' 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 ('F325191245562','input',' 1',' MED1E X LG','TOKO','PM-D','D1E-YFBH-24-0','LT X MODEL BONEKA CAT LG 8K ','','0.550','1','100.00','501000','0','0','15000','495000','0','0','0','495000','SIN','00358732','D1E','0','0','-','1','910000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YFBH-24-0' 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='2025-09-19' AND kode_barang='D1E-YFBH-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325191245562','2025-09-19','0.550','2025-09-19','12:45:57','PLG0024935','495000','495000','0','495000','495000','input','2025-09-19 12:45:56','F32519124556');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325191245562','2025-09-19','12:45:57','SIN','495000','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-250919-0015','D','2025-09-19','12:45:57','input','PENJUALAN','F325191245562','62924000','495000','63419000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='495000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191245562' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190943281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190943281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190943281';
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-00017017','X-00017017','GL COR T 8K','GR','---','F1E','BELI','BELI001','1695000','2025-09-19','2.610','1','kasir','2025-09-19 13:43:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017017','X-00017017');
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-250919-0007','F323231050381','SIN','1','BELI','BELI001','F1E', 'X-00017017', 'GL COR T 8K','2.610','2.610','100.00','1182000','1695000','649425','910000','1','1695000','1695000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.610',berat_beli_asli=berat_beli_asli+'2.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.610',berat_akhir_asli=berat_akhir_asli+'2.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-250919-0007','2025-09-19','2025-09-19','13:43:27','SIN','---','2.610','1695000','1695000','1695000','1695000','1695000','kasir','2025-09-19 13:43:28','FB-250919-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0007','KIMBERLY KEINARA','GELANG KENTENG','','','','kasir','2025-09-19 13:43:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0017','K','2025-09-19','13:43:27','kasir','PEMBELIAN UMUM','FB-250919-0007','58714000','1695000','57019000');
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-00017018','X-00017018','KL X NORY UB 44 8K','GR','---','H1E','BELI','BELI001','1660000','2025-09-19','2.020','1','kasir','2025-09-19 13:44:20');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017018','X-00017018');
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-250919-0008','F325030938001','FIT','1','BELI','BELI001','H1E', 'X-00017018', 'KL X NORY UB 44 8K','2.020','2.020','100.00','1785000','1660000','821782','910000','1','1660000','1660000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-250919-0008','2025-09-19','2025-09-19','13:44:20','FIT','---','2.020','1660000','1660000','1660000','1660000','1660000','kasir','2025-09-19 13:44:20','FB-250919-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0008','AJENG','GONDANG','','','','kasir','2025-09-19 13:44:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0018','K','2025-09-19','13:44:20','kasir','PEMBELIAN UMUM','FB-250919-0008','57019000','1660000','55359000');
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-00017019','X-00017019','CC X MODEL MATA HW 16 8K','GR','---','E2D','BELI','BELI001','1065000','2025-09-19','1.460','1','kasir','2025-09-19 14:28:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017019','X-00017019');
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-250919-0009','F325290227511','FIT','1','BELI','BELI001','E2D', 'X-00017019', 'CC X MODEL MATA HW 16 8K','1.460','1.460','100.00','1223000','1065000','729452','893000','1','1065000','1065000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.460',berat_beli_asli=berat_beli_asli+'1.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.460',berat_akhir_asli=berat_akhir_asli+'1.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250919-0009','2025-09-19','2025-09-19','14:28:47','FIT','---','1.460','1065000','1065000','1065000','1065000','1065000','kasir','2025-09-19 14:28:47','FB-250919-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0009','SRI WAHYUNI','POHIJO','','','','kasir','2025-09-19 14:28:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0019','K','2025-09-19','14:28:47','kasir','PEMBELIAN UMUM','FB-250919-0009','55359000','1065000','54294000');
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 ('F325190315071','kasir','1',' MEF3E HW ','TOKO','PM-F','F3E-YDBF-103-0','GL SANTA RIBBON SLEP VAR HW 8K ','','1.560','1','100.00','1420000','0','0','15000','1420000','0','0','0','1420000','SIN','00351052','F3E','0','0','-','0','910000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YDBF-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='F3E-YDBF-103-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325190315071','2025-09-19','1.560','2025-09-19','15:15:08','PLG0024936','1420000','1420000','0','1420000','1420000','kasir','2025-09-19 15:15:07','F32519031507');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325190315071','2025-09-19','15:15:08','SIN','1420000','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-250919-0020','D','2025-09-19','15:15:08','kasir','PENJUALAN','F325190315071','54294000','1420000','55714000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1420000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325190315071' 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 ('F325190315072','kasir',' 1',' MFA1 UB ','TOKO','PM-A','A1F-YGAH-281-0','AT KLIP ARESO UB 8K ','','0.700','1','100.00','649000','0','0','15000','650000','0','0','0','650000','SIN','00361689','A1F','0','0','-','0','927000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YGAH-281-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='A1F-YGAH-281-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325190315072','2025-09-19','0.700','2025-09-19','15:15:08','PLG0024937','650000','650000','0','650000','650000','kasir','2025-09-19 15:15:07','F32519031507');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325190315072','2025-09-19','15:15:08','SIN','650000','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-250919-0021','D','2025-09-19','15:15:08','kasir','PENJUALAN','F325190315072','55714000','650000','56364000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325190315072' 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 ('F325190315073','kasir',' 1',' MDE2 5K CM','TOKO','PM-E','E2D-YEBX-8-0','CC MODEL MATA VAR CM 16 8K ','','0.980','1','100.00','875000','0','0','15000','875000','0','5000','0','880000','SIN','00354770','E2D','0','0','-','0','893000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEBX-8-0' 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='2025-09-19' AND kode_barang='E2D-YEBX-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325190315073','2025-09-19','0.980','2025-09-19','15:15:08','PLG0024938','875000','875000','5000','880000','880000','kasir','2025-09-19 15:15:07','F32519031507');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F325190315073','2025-09-19','15:15:08','SIN','880000','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-250919-0022','D','2025-09-19','15:15:08','kasir','PENJUALAN','F325190315073','56364000','880000','57244000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='880000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325190315073' LIMIT 1;
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-00017020','X-00017020','CC X MODEL MATA CAT BM 18 8K','GR','---','E2D','BELI','BELI001','755000','2025-09-19','1.220','1','kasir','2025-09-19 15:17:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017020','X-00017020');
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-250919-0010','F324251053011','SIN','1','BELI','BELI001','E2D', 'X-00017020', 'CC X MODEL MATA CAT BM 18 8K','1.220','1.220','100.00','803000','755000','618852','893000','1','755000','755000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.220',berat_beli_asli=berat_beli_asli+'1.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.220',berat_akhir_asli=berat_akhir_asli+'1.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250919-0010','2025-09-19','2025-09-19','15:17:40','SIN','---','1.220','755000','755000','755000','755000','755000','kasir','2025-09-19 15:17:41','FB-250919-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0010','NOVITA','JETIS LOR NAWANGAN','','','','kasir','2025-09-19 15:17:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0023','K','2025-09-19','15:17:40','kasir','PEMBELIAN UMUM','FB-250919-0010','57244000','755000','56489000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190315071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190315071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190315071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190315072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190315072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190315072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190315073' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190315073' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190315073';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190858361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190858361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190858361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190932111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190932111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190932111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191145181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191145181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191145181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191245561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191245561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191245561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191245562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191245562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191245562';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-0010';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-19';
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='2025-09-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-19' 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-250920-0001','D','2025-09-20','15:32:09','SYSTEM','SALDO AWAL','SALDO AWAL','0','56489000','56489000');
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-250920-0001','D','2025-09-20','15:32:09','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-250920-0001','D','2025-09-20','15:32:09','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-250920-0001','D','2025-09-20','15:32:09','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-09-20';