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 ('F325040933431','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-YCBD-88-0','KL X SANTA KH 42 9K','','1.980','1','100.00','2188000','0','0','15000','2188000','0','0','0','2188000','SIN','00344881','H2I','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YCBD-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='H2I-YCBD-88-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 ('F325040933431','2025-12-04','1.980','2025-12-04','09:33:43','PLG0026026','2188000','2188000','0','2188000','2188000','input','2025-12-04 09:33:43','F32504093343');
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-12-04','F325040933431','2025-12-04','09:33:43','SIN','2188000','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-251204-0002','D','2025-12-04','09:33:43','input','PENJUALAN','F325040933431','992249000','2188000','994437000');
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 ('F325040934251','input','1',' MED1 X 5K ','TOKO','PM-D','D1E-YKXC-326-0','LT X MODEL APEL CAT VAR LG 8K ','','0.520','1','100.00','533000','0','0','15000','535000','0','5000','0','540000','SIN','00376254','D1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YKXC-326-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='D1E-YKXC-326-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 ('F325040934251','2025-12-04','0.520','2025-12-04','09:34:26','PLG0026027','535000','535000','5000','540000','540000','input','2025-12-04 09:34:25','F32504093425');
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-12-04','F325040934251','2025-12-04','09:34:26','SIN','540000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251204-0003','D','2025-12-04','09:34:26','input','PENJUALAN','F325040934251','994437000','540000','994977000');
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 ('F325041147271','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-YKXD-150-0','KL X NORY UB 44 8K ','','3.000','1','100.00','3075000','0','0','15000','3075000','0','0','0','3075000','SIN','00376686','H1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXD-150-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='H1E-YKXD-150-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 ('F325041147271','2025-12-04','3.000','2025-12-04','11:47:27','PLG0026028','3075000','3075000','0','3075000','3075000','input','2025-12-04 11:47:27','F32504114727');
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-12-04','F325041147271','2025-12-04','11:47:27','SIN','3075000','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-251204-0004','D','2025-12-04','11:47:27','input','PENJUALAN','F325041147271','994977000','3075000','998052000');
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-00017605','X-00017605','CC X MODEL SOLITAIRE MATA HW 13 8K','GR','---','E2D','BELI','BELI001','1470000','2025-12-04','1.560','1','kasir','2025-12-04 12:09:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017605','X-00017605');
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-251204-0001','F325170837241','FIT','1','BELI','BELI001','E2D', 'X-00017605', 'CC X MODEL SOLITAIRE MATA HW 13 8K','1.560','1.560','100.00','1660000','1470000','942308','1015000','1','1470000','1470000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.560',berat_beli_asli=berat_beli_asli+'1.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.560',berat_akhir_asli=berat_akhir_asli+'1.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-04' 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-251204-0001','2025-12-04','2025-12-04','12:09:14','FIT','---','1.560','1470000','1470000','1470000','1470000','1470000','kasir','2025-12-04 12:09:15','FB-251204-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251204-0001','NEISYA','SLOGOHIMO','','','','kasir','2025-12-04 12:09:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-04' 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-251204-0005','K','2025-12-04','12:09:14','kasir','PEMBELIAN UMUM','FB-251204-0001','998052000','1470000','996582000');
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-00017606','X-00017606','GL RANTAI SERUT MODEL HATI VAR UB 8K','GR','---','F3F','BELI','BELI001','882000','2025-12-04','1.330','1','kasir','2025-12-04 12:10:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00017606','X-00017606');
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-251204-0002','F324051051261','FIT','1','BELI','BELI001','F3F', 'X-00017606', 'GL RANTAI SERUT MODEL HATI VAR UB 8K','1.330','1.330','100.00','820000','882000','663158','1045000','1','882000','882000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.330',berat_beli_asli=berat_beli_asli+'1.330',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.330',berat_akhir_asli=berat_akhir_asli+'1.330',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-251204-0002','2025-12-04','2025-12-04','12:10:25','FIT','---','1.330','882000','882000','882000','882000','882000','kasir','2025-12-04 12:10:25','FB-251204-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251204-0002','GENDIS','TEGALREJO','','','','kasir','2025-12-04 12:10:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-04' 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-251204-0006','K','2025-12-04','12:10:25','kasir','PEMBELIAN UMUM','FB-251204-0002','996582000','882000','995700000');
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-00017607','X-00017607','GL X TIFF SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1560000','2025-12-04','1.730','1','kasir','2025-12-04 12:10:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017607','X-00017607');
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-251204-0003','F325010113421','AAT','1','BELI','BELI001','F3E', 'X-00017607', 'GL X TIFF SLEP VAR HW 8K','1.730','1.730','100.00','1680000','1560000','901734','1035000','1','1560000','1560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.730',berat_beli_asli=berat_beli_asli+'1.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.730',berat_akhir_asli=berat_akhir_asli+'1.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-04' 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-251204-0003','2025-12-04','2025-12-04','12:10:43','AAT','---','1.730','1560000','1560000','1560000','1560000','1560000','kasir','2025-12-04 12:10:43','FB-251204-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251204-0003','LIDA','TEGALREJO PURWANTORO','','','','kasir','2025-12-04 12:10:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-04' 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-251204-0007','K','2025-12-04','12:10:43','kasir','PEMBELIAN UMUM','FB-251204-0003','995700000','1560000','994140000');
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-00017608','X-00017608','KL X SIEM COBRA ANAK KH 34 8K','GR','---','H2J','BELI','BELI001','1117000','2025-12-04','1.060','1','kasir','2025-12-04 13:15:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017608','X-00017608');
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-251204-0004','F325180142381','AAT','1','BELI','BELI001','H2J', 'X-00017608', 'KL X SIEM COBRA ANAK KH 34 8K','1.060','1.060','100.00','1235000','1117000','1053774','1125000','1','1117000','1117000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-251204-0004','2025-12-04','2025-12-04','13:15:34','AAT','---','1.060','1117000','1117000','1117000','1117000','1117000','kasir','2025-12-04 13:15:34','FB-251204-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251204-0004','SHOFIYA','GESING TINASAT KISMANTORO','','','085725865978','kasir','2025-12-04 13:15:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-04' 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-251204-0008','K','2025-12-04','13:15:34','kasir','PEMBELIAN UMUM','FB-251204-0004','994140000','1117000','993023000');
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-00017609','X-00017609','GL X RANTAI P3 SLEP KH 8K','GR','---','F3E','BELI','BELI001','1840000','2025-12-04','2.180','1','kasir','2025-12-04 13:23:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017609','X-00017609');
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-251204-0005','F325030143401','SIN','1','BELI','BELI001','F3E', 'X-00017609', 'GL X RANTAI P3 SLEP KH 8K','2.180','2.180','100.00','2115000','1840000','844037','1035000','1','1840000','1840000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.180',berat_beli_asli=berat_beli_asli+'2.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.180',berat_akhir_asli=berat_akhir_asli+'2.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-04' 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-251204-0005','2025-12-04','2025-12-04','13:23:29','SIN','---','2.180','1840000','1840000','1840000','1840000','1840000','kasir','2025-12-04 13:23:29','FB-251204-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251204-0005','PANEN','PUH IJO','','','','kasir','2025-12-04 13:23:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-04' 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-251204-0009','K','2025-12-04','13:23:29','kasir','PEMBELIAN UMUM','FB-251204-0005','993023000','1840000','991183000');
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 ('F325040243371','kasir','1',' MEH1 15K L','TOKO','PM-H','H1E-YGXE-175-0','KL SIEM ANAK BONEKA CAT MATA VAR LG 8K ','','1.700','1','100.00','1742000','0','0','15000','1743000','0','15000','0','1758000','FIT','00359814','H1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-12-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YGXE-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2025-12-04' AND kode_barang='H1E-YGXE-175-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 ('F325040243371','2025-12-04','1.700','2025-12-04','14:43:37','PLG0026029','1743000','1743000','15000','1758000','1758000','kasir','2025-12-04 14:43:37','F32504024337');
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-12-04','F325040243371','2025-12-04','14:43:37','FIT','1758000','15000');
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-251204-0010','D','2025-12-04','14:43:37','kasir','PENJUALAN','F325040243371','991183000','1758000','992941000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040243371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040243371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040243371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040933431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040933431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040933431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040934251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040934251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040934251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325041147271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325041147271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325041147271';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251204-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251204-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251204-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251204-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251204-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251204-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251204-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251204-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251204-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251204-0005';
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3507000',harga_beli ='3507000' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='10680000',harga_beli ='10680000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='10609000',harga_beli ='10609000' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8864500',harga_beli ='8864500' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='17800000',harga_beli ='17800000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='837000',harga_beli ='837000' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0003950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0004083' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0004149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='10680000',harga_beli ='10680000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='10680000',harga_beli ='10680000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='10680000',harga_beli ='10680000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='14240000',harga_beli ='14240000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='17800000',harga_beli ='17800000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='12460000',harga_beli ='12460000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='14240000',harga_beli ='14240000' WHERE kode_barcode='T0004186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='12460000',harga_beli ='12460000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='12460000',harga_beli ='12460000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1869000',harga_beli ='1869000' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0027570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='10716000',harga_beli ='10716000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1744500',harga_beli ='1744500' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7067000',harga_beli ='7067000' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1798000',harga_beli ='1798000' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1744500',harga_beli ='1744500' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3489000',harga_beli ='3489000' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='943500',harga_beli ='943500' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7067000',harga_beli ='7067000' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5304500',harga_beli ='5304500' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='14240000',harga_beli ='14240000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='9968000',harga_beli ='9968000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5376000',harga_beli ='5376000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5376000',harga_beli ='5376000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3596000',harga_beli ='3596000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0043855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0043854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='926000',harga_beli ='926000' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0044194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3471000',harga_beli ='3471000' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0044175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2759000',harga_beli ='2759000' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1727000',harga_beli ='1727000' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2688000',harga_beli ='2688000' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0048353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3489000',harga_beli ='3489000' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1691000',harga_beli ='1691000' WHERE kode_barcode='T0048357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5251000',harga_beli ='5251000' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1744500',harga_beli ='1744500' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1798000',harga_beli ='1798000' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3596000',harga_beli ='3596000' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3524500',harga_beli ='3524500' WHERE kode_barcode='T0052776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8758000',harga_beli ='8758000' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3293000',harga_beli ='3293000' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7031000',harga_beli ='7031000' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='17818000',harga_beli ='17818000' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='17818000',harga_beli ='17818000' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='854500',harga_beli ='854500' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3578000',harga_beli ='3578000' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3489000',harga_beli ='3489000' WHERE kode_barcode='T0056820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8936000',harga_beli ='8936000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7084500',harga_beli ='7084500' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7084500',harga_beli ='7084500' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3578000',harga_beli ='3578000' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1744500',harga_beli ='1744500' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1744500',harga_beli ='1744500' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='1780000',harga_beli ='1780000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0069558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0069559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='3560000',harga_beli ='3560000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='7120000',harga_beli ='7120000' WHERE kode_barcode='T0069565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='8936000',harga_beli ='8936000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5340000',harga_beli ='5340000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5376000',harga_beli ='5376000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0074541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='801000',harga_beli ='801000' WHERE kode_barcode='T0074542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='890000',harga_beli ='890000' WHERE kode_barcode='T0074543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='819000',harga_beli ='819000' WHERE kode_barcode='T0074544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='854500',harga_beli ='854500' WHERE kode_barcode='T0074545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='819000',harga_beli ='819000' WHERE kode_barcode='T0074546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='2884000',harga_beli ='2884000' WHERE kode_barcode='T0074549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1780000',harga_jual='5625000',harga_beli ='5625000' WHERE kode_barcode='T0074550' LIMIT 1;
UPDATE tm_group SET harga='1780000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1780000','input','2025-12-04 15:03:18');
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='8343500',harga_beli ='8343500' WHERE kode_barcode='T0070501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3644500',harga_beli ='3644500' WHERE kode_barcode='T0070766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3626000',harga_beli ='3626000' WHERE kode_barcode='T0070765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3700000',harga_beli ='3700000' WHERE kode_barcode='T0070513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2627000',harga_beli ='2627000' WHERE kode_barcode='T0070512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2331000',harga_beli ='2331000' WHERE kode_barcode='T0070510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1628000',harga_beli ='1628000' WHERE kode_barcode='T0070508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1776000',harga_beli ='1776000' WHERE kode_barcode='T0070505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2312500',harga_beli ='2312500' WHERE kode_barcode='T0070504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3756000',harga_beli ='3756000' WHERE kode_barcode='T0071248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='5328000',harga_beli ='5328000' WHERE kode_barcode='T0070500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3719000',harga_beli ='3719000' WHERE kode_barcode='T0070498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3163500',harga_beli ='3163500' WHERE kode_barcode='T0070497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2405000',harga_beli ='2405000' WHERE kode_barcode='T0070496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1961000',harga_beli ='1961000' WHERE kode_barcode='T0070491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2553000',harga_beli ='2553000' WHERE kode_barcode='T0070157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2682500',harga_beli ='2682500' WHERE kode_barcode='T0070156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1776000',harga_beli ='1776000' WHERE kode_barcode='T0068925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1850000',harga_beli ='1850000' WHERE kode_barcode='T0071527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2460500',harga_beli ='2460500' WHERE kode_barcode='T0071528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1813000',harga_beli ='1813000' WHERE kode_barcode='T0071651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2183000',harga_beli ='2183000' WHERE kode_barcode='T0072609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1942500',harga_beli ='1942500' WHERE kode_barcode='T0072610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1942500',harga_beli ='1942500' WHERE kode_barcode='T0072612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1813000',harga_beli ='1813000' WHERE kode_barcode='T0072613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1905500',harga_beli ='1905500' WHERE kode_barcode='T0072615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2516000',harga_beli ='2516000' WHERE kode_barcode='T0072972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2923000',harga_beli ='2923000' WHERE kode_barcode='T0072973' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1535500',harga_beli ='1535500' WHERE kode_barcode='T0073760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2923000',harga_beli ='2923000' WHERE kode_barcode='T0073759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2275500',harga_beli ='2275500' WHERE kode_barcode='T0073765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1924000',harga_beli ='1924000' WHERE kode_barcode='T0074491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1905500',harga_beli ='1905500' WHERE kode_barcode='T0074492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3793000',harga_beli ='3793000' WHERE kode_barcode='T0063014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1757500',harga_beli ='1757500' WHERE kode_barcode='T0063006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3959000',harga_beli ='3959000' WHERE kode_barcode='T0062325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='4255000',harga_beli ='4255000' WHERE kode_barcode='T0072978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='4440000',harga_beli ='4440000' WHERE kode_barcode='T0062985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1850000',harga_beli ='1850000' WHERE kode_barcode='T0072986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2460500',harga_beli ='2460500' WHERE kode_barcode='T0072985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2238500',harga_beli ='2238500' WHERE kode_barcode='T0072982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2331000',harga_beli ='2331000' WHERE kode_barcode='T0072979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1813000',harga_beli ='1813000' WHERE kode_barcode='T0063003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3478000',harga_beli ='3478000' WHERE kode_barcode='T0063013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2405000',harga_beli ='2405000' WHERE kode_barcode='T0062984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0062972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2312500',harga_beli ='2312500' WHERE kode_barcode='T0072983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3182000',harga_beli ='3182000' WHERE kode_barcode='T0062987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='5827500',harga_beli ='5827500' WHERE kode_barcode='T0063011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='4495500',harga_beli ='4495500' WHERE kode_barcode='T0063012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2146000',harga_beli ='2146000' WHERE kode_barcode='T0062981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2146000',harga_beli ='2146000' WHERE kode_barcode='T0063000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1868500',harga_beli ='1868500' WHERE kode_barcode='T0062999' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='4403000',harga_beli ='4403000' WHERE kode_barcode='T0062997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='5272500',harga_beli ='5272500' WHERE kode_barcode='T0062996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3274500',harga_beli ='3274500' WHERE kode_barcode='T0062995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1850000',harga_beli ='1850000' WHERE kode_barcode='T0062992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1757500',harga_beli ='1757500' WHERE kode_barcode='T0065456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3700000',harga_beli ='3700000' WHERE kode_barcode='T0065459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3644500',harga_beli ='3644500' WHERE kode_barcode='T0065461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3478000',harga_beli ='3478000' WHERE kode_barcode='T0065463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3237500',harga_beli ='3237500' WHERE kode_barcode='T0065464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2312500',harga_beli ='2312500' WHERE kode_barcode='T0065465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='2775000',harga_beli ='2775000' WHERE kode_barcode='T0065466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='3700000',harga_beli ='3700000' WHERE kode_barcode='T0068147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='1350500',harga_beli ='1350500' WHERE kode_barcode='T0068921' LIMIT 1;
UPDATE tm_group SET harga='1850000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','1850000','input','2025-12-04 15:03:34');
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1459000',harga_beli ='1459000' WHERE kode_barcode='T0040093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2431000',harga_beli ='2431000' WHERE kode_barcode='T0027959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2955000',harga_beli ='2955000' WHERE kode_barcode='T0027952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1402500',harga_beli ='1402500' WHERE kode_barcode='T0027928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1833000',harga_beli ='1833000' WHERE kode_barcode='T0025243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3179000',harga_beli ='3179000' WHERE kode_barcode='T0029887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2487500',harga_beli ='2487500' WHERE kode_barcode='T0003111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4806000',harga_beli ='4806000' WHERE kode_barcode='T0003107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6919000',harga_beli ='6919000' WHERE kode_barcode='T0002687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3684000',harga_beli ='3684000' WHERE kode_barcode='T0003195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4675000',harga_beli ='4675000' WHERE kode_barcode='T0003210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1926500',harga_beli ='1926500' WHERE kode_barcode='T0050962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3516000',harga_beli ='3516000' WHERE kode_barcode='T0003563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3029500',harga_beli ='3029500' WHERE kode_barcode='T0003573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='T0029925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0003177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2655500',harga_beli ='2655500' WHERE kode_barcode='T0003180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2805000',harga_beli ='2805000' WHERE kode_barcode='T0003159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4039500',harga_beli ='4039500' WHERE kode_barcode='T0003161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2655500',harga_beli ='2655500' WHERE kode_barcode='T0003162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3572000',harga_beli ='3572000' WHERE kode_barcode='T0003163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1365500',harga_beli ='1365500' WHERE kode_barcode='T0003165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='879000',harga_beli ='879000' WHERE kode_barcode='T0003168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2431000',harga_beli ='2431000' WHERE kode_barcode='T0003169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2150500',harga_beli ='2150500' WHERE kode_barcode='T0003142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2562000',harga_beli ='2562000' WHERE kode_barcode='T0003146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3665500',harga_beli ='3665500' WHERE kode_barcode='T0003396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='T0003411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='T0003414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='935000',harga_beli ='935000' WHERE kode_barcode='T0003415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='T0003417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6377000',harga_beli ='6377000' WHERE kode_barcode='T0003419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2730500',harga_beli ='2730500' WHERE kode_barcode='T0003433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6732000',harga_beli ='6732000' WHERE kode_barcode='T0003434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2655500',harga_beli ='2655500' WHERE kode_barcode='T0003440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5236000',harga_beli ='5236000' WHERE kode_barcode='T0003449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3777500',harga_beli ='3777500' WHERE kode_barcode='T0003453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3478500',harga_beli ='3478500' WHERE kode_barcode='T0003460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3366000',harga_beli ='3366000' WHERE kode_barcode='T0003461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3478500',harga_beli ='3478500' WHERE kode_barcode='T0003466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='15016500',harga_beli ='15016500' WHERE kode_barcode='T0072990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3048500',harga_beli ='3048500' WHERE kode_barcode='T0003481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2730500',harga_beli ='2730500' WHERE kode_barcode='T0003482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2842500',harga_beli ='2842500' WHERE kode_barcode='T0003594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4020500',harga_beli ='4020500' WHERE kode_barcode='T0003587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='13109000',harga_beli ='13109000' WHERE kode_barcode='T0003370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1720500',harga_beli ='1720500' WHERE kode_barcode='T0004087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3497000',harga_beli ='3497000' WHERE kode_barcode='T0004022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7854000',harga_beli ='7854000' WHERE kode_barcode='T0072989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2655500',harga_beli ='2655500' WHERE kode_barcode='T0004055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1720500',harga_beli ='1720500' WHERE kode_barcode='T0004356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1683000',harga_beli ='1683000' WHERE kode_barcode='T0004351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7798000',harga_beli ='7798000' WHERE kode_barcode='T0025231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='T0006172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1814000',harga_beli ='1814000' WHERE kode_barcode='T0006175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1963500',harga_beli ='1963500' WHERE kode_barcode='T0006198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5329500',harga_beli ='5329500' WHERE kode_barcode='T0006197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2898500',harga_beli ='2898500' WHERE kode_barcode='T0006193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3927000',harga_beli ='3927000' WHERE kode_barcode='T0006190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3385000',harga_beli ='3385000' WHERE kode_barcode='T0006414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3777500',harga_beli ='3777500' WHERE kode_barcode='T0001870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='972500',harga_beli ='972500' WHERE kode_barcode='T0008962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='T0008964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9219500',harga_beli ='9219500' WHERE kode_barcode='T0072987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3553000',harga_beli ='3553000' WHERE kode_barcode='T0009202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2450000',harga_beli ='2450000' WHERE kode_barcode='T0009209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0009247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1552500',harga_beli ='1552500' WHERE kode_barcode='T0009232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2917500',harga_beli ='2917500' WHERE kode_barcode='T0009460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2244000',harga_beli ='2244000' WHERE kode_barcode='T0010055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2730500',harga_beli ='2730500' WHERE kode_barcode='T0010054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1085000',harga_beli ='1085000' WHERE kode_barcode='T0014657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1159500',harga_beli ='1159500' WHERE kode_barcode='T0014659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1159500',harga_beli ='1159500' WHERE kode_barcode='T0014661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2730500',harga_beli ='2730500' WHERE kode_barcode='T0014715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2300500',harga_beli ='2300500' WHERE kode_barcode='T0017794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0017795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6882000',harga_beli ='6882000' WHERE kode_barcode='T0019180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4077000',harga_beli ='4077000' WHERE kode_barcode='T0019181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2955000',harga_beli ='2955000' WHERE kode_barcode='T0006407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2113500',harga_beli ='2113500' WHERE kode_barcode='T0013667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1589500',harga_beli ='1589500' WHERE kode_barcode='T0020102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3310000',harga_beli ='3310000' WHERE kode_barcode='T0022491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='T0022487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2711500',harga_beli ='2711500' WHERE kode_barcode='T0022713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5142500',harga_beli ='5142500' WHERE kode_barcode='T0023419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6077500',harga_beli ='6077500' WHERE kode_barcode='T0023410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='T0026794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1833000',harga_beli ='1833000' WHERE kode_barcode='T0026793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3385000',harga_beli ='3385000' WHERE kode_barcode='T0026789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='15147000',harga_beli ='15147000' WHERE kode_barcode='T0027384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7312000',harga_beli ='7312000' WHERE kode_barcode='T0027889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='37213000',harga_beli ='37213000' WHERE kode_barcode='T0027884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2207000',harga_beli ='2207000' WHERE kode_barcode='T0029673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='T0029674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2113500',harga_beli ='2113500' WHERE kode_barcode='T0028822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2431000',harga_beli ='2431000' WHERE kode_barcode='T0031899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3665500',harga_beli ='3665500' WHERE kode_barcode='T0032995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2281500',harga_beli ='2281500' WHERE kode_barcode='T0032983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1029000',harga_beli ='1029000' WHERE kode_barcode='T0032982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1683000',harga_beli ='1683000' WHERE kode_barcode='T0033052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7573500',harga_beli ='7573500' WHERE kode_barcode='T0033032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3104500',harga_beli ='3104500' WHERE kode_barcode='T0033506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4638000',harga_beli ='4638000' WHERE kode_barcode='T0033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1309000',harga_beli ='1309000' WHERE kode_barcode='T0033647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2936000',harga_beli ='2936000' WHERE kode_barcode='T0033728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1608500',harga_beli ='1608500' WHERE kode_barcode='T0034346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='T0034362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3291500',harga_beli ='3291500' WHERE kode_barcode='T0034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1926500',harga_beli ='1926500' WHERE kode_barcode='T0034754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9256500',harga_beli ='9256500' WHERE kode_barcode='T0034743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='10509500',harga_beli ='10509500' WHERE kode_barcode='T0034735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0035004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0035014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1085000',harga_beli ='1085000' WHERE kode_barcode='T0035012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1178500',harga_beli ='1178500' WHERE kode_barcode='T0035010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0035005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3216500',harga_beli ='3216500' WHERE kode_barcode='T0035430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2375000',harga_beli ='2375000' WHERE kode_barcode='T0035420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='13109000',harga_beli ='13109000' WHERE kode_barcode='T0035441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='T0036248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2898500',harga_beli ='2898500' WHERE kode_barcode='T0036259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5105500',harga_beli ='5105500' WHERE kode_barcode='T0037728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2917500',harga_beli ='2917500' WHERE kode_barcode='T0037995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1907500',harga_beli ='1907500' WHERE kode_barcode='T0038795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3272500',harga_beli ='3272500' WHERE kode_barcode='T0038788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1122000',harga_beli ='1122000' WHERE kode_barcode='T0039318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2487500',harga_beli ='2487500' WHERE kode_barcode='T0039315' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2898500',harga_beli ='2898500' WHERE kode_barcode='T0039621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3609500',harga_beli ='3609500' WHERE kode_barcode='T0040098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1963500',harga_beli ='1963500' WHERE kode_barcode='T0040647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5049000',harga_beli ='5049000' WHERE kode_barcode='T0040632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7125000',harga_beli ='7125000' WHERE kode_barcode='T0040639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0040631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7330500',harga_beli ='7330500' WHERE kode_barcode='T0041178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2936000',harga_beli ='2936000' WHERE kode_barcode='T0041170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2768000',harga_beli ='2768000' WHERE kode_barcode='T0041152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4862000',harga_beli ='4862000' WHERE kode_barcode='T0041163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3497000',harga_beli ='3497000' WHERE kode_barcode='T0041154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3740000',harga_beli ='3740000' WHERE kode_barcode='T0041153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='15203500',harga_beli ='15203500' WHERE kode_barcode='T0041179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6919000',harga_beli ='6919000' WHERE kode_barcode='T0041183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7443000',harga_beli ='7443000' WHERE kode_barcode='T0041182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4114500',harga_beli ='4114500' WHERE kode_barcode='T0041651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1814000',harga_beli ='1814000' WHERE kode_barcode='T0041676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7349500',harga_beli ='7349500' WHERE kode_barcode='T0041681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1346500',harga_beli ='1346500' WHERE kode_barcode='T0042066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1234500',harga_beli ='1234500' WHERE kode_barcode='T0042067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0042068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1272000',harga_beli ='1272000' WHERE kode_barcode='T0042069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3553000',harga_beli ='3553000' WHERE kode_barcode='T0042203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4600500',harga_beli ='4600500' WHERE kode_barcode='T0042202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4077000',harga_beli ='4077000' WHERE kode_barcode='T0042199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4899500',harga_beli ='4899500' WHERE kode_barcode='T0042197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='T0042196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5442000',harga_beli ='5442000' WHERE kode_barcode='T0042192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='T0042191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1533500',harga_beli ='1533500' WHERE kode_barcode='T0042186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2001000',harga_beli ='2001000' WHERE kode_barcode='T0042185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='12903000',harga_beli ='12903000' WHERE kode_barcode='T0042180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='12660000',harga_beli ='12660000' WHERE kode_barcode='T0042179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3646500',harga_beli ='3646500' WHERE kode_barcode='T0042177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9369000',harga_beli ='9369000' WHERE kode_barcode='T0067270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3646500',harga_beli ='3646500' WHERE kode_barcode='T0042541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1589500',harga_beli ='1589500' WHERE kode_barcode='T0042537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1907500',harga_beli ='1907500' WHERE kode_barcode='T0042542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5236000',harga_beli ='5236000' WHERE kode_barcode='T0042530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3329000',harga_beli ='3329000' WHERE kode_barcode='T0042524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2955000',harga_beli ='2955000' WHERE kode_barcode='T0042514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3852500',harga_beli ='3852500' WHERE kode_barcode='T0071233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2431000',harga_beli ='2431000' WHERE kode_barcode='T0042830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='18569500',harga_beli ='18569500' WHERE kode_barcode='T0067271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='T0043129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2337500',harga_beli ='2337500' WHERE kode_barcode='T0043098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3011000',harga_beli ='3011000' WHERE kode_barcode='T0043121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5329500',harga_beli ='5329500' WHERE kode_barcode='T0043107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5573000',harga_beli ='5573000' WHERE kode_barcode='T0043105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5629000',harga_beli ='5629000' WHERE kode_barcode='T0043147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5329500',harga_beli ='5329500' WHERE kode_barcode='T0043150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3179000',harga_beli ='3179000' WHERE kode_barcode='T0043628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4712500',harga_beli ='4712500' WHERE kode_barcode='T0043629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5890500',harga_beli ='5890500' WHERE kode_barcode='T0043721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5760000',harga_beli ='5760000' WHERE kode_barcode='T0044041' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2992000',harga_beli ='2992000' WHERE kode_barcode='T0044045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9387500',harga_beli ='9387500' WHERE kode_barcode='T0044032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6321000',harga_beli ='6321000' WHERE kode_barcode='T0044034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7817000',harga_beli ='7817000' WHERE kode_barcode='T0072988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1889000',harga_beli ='1889000' WHERE kode_barcode='T0044166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1870000',harga_beli ='1870000' WHERE kode_barcode='T0044165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1833000',harga_beli ='1833000' WHERE kode_barcode='T0044164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='T0044162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9443500',harga_beli ='9443500' WHERE kode_barcode='T0044195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6825500',harga_beli ='6825500' WHERE kode_barcode='T0044286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2917500',harga_beli ='2917500' WHERE kode_barcode='T0044278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5423000',harga_beli ='5423000' WHERE kode_barcode='T0044276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3927000',harga_beli ='3927000' WHERE kode_barcode='T0044274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9630500',harga_beli ='9630500' WHERE kode_barcode='T0044545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4357500',harga_beli ='4357500' WHERE kode_barcode='T0044564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0045115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0045117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1365500',harga_beli ='1365500' WHERE kode_barcode='T0045127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2150500',harga_beli ='2150500' WHERE kode_barcode='T0045283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3291500',harga_beli ='3291500' WHERE kode_barcode='T0045348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='T0045354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='T0045355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2711500',harga_beli ='2711500' WHERE kode_barcode='T0045362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5816000',harga_beli ='5816000' WHERE kode_barcode='T0045384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4133000',harga_beli ='4133000' WHERE kode_barcode='T0045378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='T0045367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2431000',harga_beli ='2431000' WHERE kode_barcode='T0045366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4170500',harga_beli ='4170500' WHERE kode_barcode='T0044947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4675000',harga_beli ='4675000' WHERE kode_barcode='T0045389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1515000',harga_beli ='1515000' WHERE kode_barcode='T0046053' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3871000',harga_beli ='3871000' WHERE kode_barcode='T0046088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3216500',harga_beli ='3216500' WHERE kode_barcode='T0046089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4955500',harga_beli ='4955500' WHERE kode_barcode='T0046090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1402500',harga_beli ='1402500' WHERE kode_barcode='T0046370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1122000',harga_beli ='1122000' WHERE kode_barcode='T0047389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1889000',harga_beli ='1889000' WHERE kode_barcode='T0047393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4170500',harga_beli ='4170500' WHERE kode_barcode='T0047396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0047398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5068000',harga_beli ='5068000' WHERE kode_barcode='T0047416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4731500',harga_beli ='4731500' WHERE kode_barcode='T0047427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2150500',harga_beli ='2150500' WHERE kode_barcode='T0047423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2824000',harga_beli ='2824000' WHERE kode_barcode='T0047418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4619000',harga_beli ='4619000' WHERE kode_barcode='T0047417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3964500',harga_beli ='3964500' WHERE kode_barcode='T0047414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3759000',harga_beli ='3759000' WHERE kode_barcode='T0047409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4488000',harga_beli ='4488000' WHERE kode_barcode='T0047408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='12828500',harga_beli ='12828500' WHERE kode_barcode='T0047429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4899500',harga_beli ='4899500' WHERE kode_barcode='T0047434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='T0047435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5516500',harga_beli ='5516500' WHERE kode_barcode='T0047436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0047728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1963500',harga_beli ='1963500' WHERE kode_barcode='T0048345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1870000',harga_beli ='1870000' WHERE kode_barcode='T0048740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='T0048741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='804500',harga_beli ='804500' WHERE kode_barcode='T0048987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2169500',harga_beli ='2169500' WHERE kode_barcode='T0048992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='972500',harga_beli ='972500' WHERE kode_barcode='T0049666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4245000',harga_beli ='4245000' WHERE kode_barcode='T0049688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='T0049690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='T0049691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1365500',harga_beli ='1365500' WHERE kode_barcode='T0049701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1459000',harga_beli ='1459000' WHERE kode_barcode='T0049702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='T0049674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3890000',harga_beli ='3890000' WHERE kode_barcode='T0049677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5666500',harga_beli ='5666500' WHERE kode_barcode='T0049679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='T0049682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='T0049684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3310000',harga_beli ='3310000' WHERE kode_barcode='T0049686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9275500',harga_beli ='9275500' WHERE kode_barcode='T0049707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='8135000',harga_beli ='8135000' WHERE kode_barcode='T0049711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1085000',harga_beli ='1085000' WHERE kode_barcode='T0049951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3871000',harga_beli ='3871000' WHERE kode_barcode='T0050016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3590500',harga_beli ='3590500' WHERE kode_barcode='T0049966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='17597000',harga_beli ='17597000' WHERE kode_barcode='T0050021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1795500',harga_beli ='1795500' WHERE kode_barcode='T0050453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2992000',harga_beli ='2992000' WHERE kode_barcode='T0050454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='T0050457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2169500',harga_beli ='2169500' WHERE kode_barcode='T0050487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1589500',harga_beli ='1589500' WHERE kode_barcode='T0050486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2898500',harga_beli ='2898500' WHERE kode_barcode='T0050484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3684000',harga_beli ='3684000' WHERE kode_barcode='T0050483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3272500',harga_beli ='3272500' WHERE kode_barcode='T0050482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3871000',harga_beli ='3871000' WHERE kode_barcode='T0050479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2150500',harga_beli ='2150500' WHERE kode_barcode='T0050478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1870000',harga_beli ='1870000' WHERE kode_barcode='T0050469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1963500',harga_beli ='1963500' WHERE kode_barcode='T0050491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5816000',harga_beli ='5816000' WHERE kode_barcode='T0050492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='T0050822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3291500',harga_beli ='3291500' WHERE kode_barcode='T0050826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3104500',harga_beli ='3104500' WHERE kode_barcode='T0051688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1272000',harga_beli ='1272000' WHERE kode_barcode='T0051691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1963500',harga_beli ='1963500' WHERE kode_barcode='T0051693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2524500',harga_beli ='2524500' WHERE kode_barcode='T0051694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3104500',harga_beli ='3104500' WHERE kode_barcode='T0051704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2524500',harga_beli ='2524500' WHERE kode_barcode='T0051705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1122000',harga_beli ='1122000' WHERE kode_barcode='T0051708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3272500',harga_beli ='3272500' WHERE kode_barcode='T0051739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4394500',harga_beli ='4394500' WHERE kode_barcode='T0051735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2113500',harga_beli ='2113500' WHERE kode_barcode='T0051738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3740000',harga_beli ='3740000' WHERE kode_barcode='T0051741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2076000',harga_beli ='2076000' WHERE kode_barcode='T0051742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2618000',harga_beli ='2618000' WHERE kode_barcode='T0051743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1833000',harga_beli ='1833000' WHERE kode_barcode='T0051745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='T0051746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3777500',harga_beli ='3777500' WHERE kode_barcode='T0051747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3478500',harga_beli ='3478500' WHERE kode_barcode='T0051719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6021500',harga_beli ='6021500' WHERE kode_barcode='T0051710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9836500',harga_beli ='9836500' WHERE kode_barcode='T0051712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4114500',harga_beli ='4114500' WHERE kode_barcode='T0051714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4413500',harga_beli ='4413500' WHERE kode_barcode='T0051716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='22571000',harga_beli ='22571000' WHERE kode_barcode='T0051757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='17297500',harga_beli ='17297500' WHERE kode_barcode='T0051759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4993000',harga_beli ='4993000' WHERE kode_barcode='T0051760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5423000',harga_beli ='5423000' WHERE kode_barcode='T0051764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='T0052826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1552500',harga_beli ='1552500' WHERE kode_barcode='T0052831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='T0052834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='15334500',harga_beli ='15334500' WHERE kode_barcode='T0052836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='18737500',harga_beli ='18737500' WHERE kode_barcode='T0052839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='18831000',harga_beli ='18831000' WHERE kode_barcode='T0052840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9481000',harga_beli ='9481000' WHERE kode_barcode='T0052841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6545000',harga_beli ='6545000' WHERE kode_barcode='T0052843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3852500',harga_beli ='3852500' WHERE kode_barcode='T0052914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1926500',harga_beli ='1926500' WHERE kode_barcode='T0052917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1739500',harga_beli ='1739500' WHERE kode_barcode='T0052918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='972500',harga_beli ='972500' WHERE kode_barcode='T0052920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='T0052922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4862000',harga_beli ='4862000' WHERE kode_barcode='T0052937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2824000',harga_beli ='2824000' WHERE kode_barcode='T0052935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6451500',harga_beli ='6451500' WHERE kode_barcode='T0052925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2898500',harga_beli ='2898500' WHERE kode_barcode='T0052943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='18793500',harga_beli ='18793500' WHERE kode_barcode='T0052947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7966500',harga_beli ='7966500' WHERE kode_barcode='T0052950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6171000',harga_beli ='6171000' WHERE kode_barcode='T0052951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6395500',harga_beli ='6395500' WHERE kode_barcode='T0052952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1496000',harga_beli ='1496000' WHERE kode_barcode='T0054111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1496000',harga_beli ='1496000' WHERE kode_barcode='T0054112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='37624500',harga_beli ='37624500' WHERE kode_barcode='T0054235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='T0054302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='T0054303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1272000',harga_beli ='1272000' WHERE kode_barcode='T0054306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2076000',harga_beli ='2076000' WHERE kode_barcode='T0054305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2281500',harga_beli ='2281500' WHERE kode_barcode='T0054307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3983500',harga_beli ='3983500' WHERE kode_barcode='T0054341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3777500',harga_beli ='3777500' WHERE kode_barcode='T0054340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2674500',harga_beli ='2674500' WHERE kode_barcode='T0054339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='16175500',harga_beli ='16175500' WHERE kode_barcode='T0054337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2001000',harga_beli ='2001000' WHERE kode_barcode='T0054335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3927000',harga_beli ='3927000' WHERE kode_barcode='T0054332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2824000',harga_beli ='2824000' WHERE kode_barcode='T0054327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2618000',harga_beli ='2618000' WHERE kode_barcode='T0054322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3646500',harga_beli ='3646500' WHERE kode_barcode='T0054320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5255000',harga_beli ='5255000' WHERE kode_barcode='T0054318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7199500',harga_beli ='7199500' WHERE kode_barcode='T0054361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7293000',harga_beli ='7293000' WHERE kode_barcode='T0054359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5479500',harga_beli ='5479500' WHERE kode_barcode='T0054357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2076000',harga_beli ='2076000' WHERE kode_barcode='T0056273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1029000',harga_beli ='1029000' WHERE kode_barcode='T0056279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3272500',harga_beli ='3272500' WHERE kode_barcode='T0056286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='T0056288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='T0056289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3179000',harga_beli ='3179000' WHERE kode_barcode='T0056291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2450000',harga_beli ='2450000' WHERE kode_barcode='T0056292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2076000',harga_beli ='2076000' WHERE kode_barcode='T0056293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2244000',harga_beli ='2244000' WHERE kode_barcode='T0056294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3871000',harga_beli ='3871000' WHERE kode_barcode='T0056296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2281500',harga_beli ='2281500' WHERE kode_barcode='T0056297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9350000',harga_beli ='9350000' WHERE kode_barcode='T0056298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='37082500',harga_beli ='37082500' WHERE kode_barcode='T0056306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5834500',harga_beli ='5834500' WHERE kode_barcode='T0056310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1029000',harga_beli ='1029000' WHERE kode_barcode='T0056710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4675000',harga_beli ='4675000' WHERE kode_barcode='T0056722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='37587000',harga_beli ='37587000' WHERE kode_barcode='T0056723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1963500',harga_beli ='1963500' WHERE kode_barcode='T0056726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3422500',harga_beli ='3422500' WHERE kode_barcode='T0056729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7761000',harga_beli ='7761000' WHERE kode_barcode='T0056734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0057085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2861500',harga_beli ='2861500' WHERE kode_barcode='T0057087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3983500',harga_beli ='3983500' WHERE kode_barcode='T0057088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='T0057099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2768000',harga_beli ='2768000' WHERE kode_barcode='T0057100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1589500',harga_beli ='1589500' WHERE kode_barcode='T0057101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2711500',harga_beli ='2711500' WHERE kode_barcode='T0057121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4787500',harga_beli ='4787500' WHERE kode_barcode='T0057123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1402500',harga_beli ='1402500' WHERE kode_barcode='T0057125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2524500',harga_beli ='2524500' WHERE kode_barcode='T0057133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3011000',harga_beli ='3011000' WHERE kode_barcode='T0057136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3703000',harga_beli ='3703000' WHERE kode_barcode='T0057112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='935000',harga_beli ='935000' WHERE kode_barcode='T0057106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1253000',harga_beli ='1253000' WHERE kode_barcode='T0057107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2188000',harga_beli ='2188000' WHERE kode_barcode='T0057108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3740000',harga_beli ='3740000' WHERE kode_barcode='T0057103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5348500',harga_beli ='5348500' WHERE kode_barcode='T0057147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='15334500',harga_beli ='15334500' WHERE kode_barcode='T0057155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2150500',harga_beli ='2150500' WHERE kode_barcode='T0057146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9443500',harga_beli ='9443500' WHERE kode_barcode='T0057141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7686000',harga_beli ='7686000' WHERE kode_barcode='T0057560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0058798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1159500',harga_beli ='1159500' WHERE kode_barcode='T0071231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2319000',harga_beli ='2319000' WHERE kode_barcode='T0059280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2936000',harga_beli ='2936000' WHERE kode_barcode='T0059276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1739500',harga_beli ='1739500' WHERE kode_barcode='T0059333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2020000',harga_beli ='2020000' WHERE kode_barcode='T0059334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4600500',harga_beli ='4600500' WHERE kode_barcode='T0059337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2001000',harga_beli ='2001000' WHERE kode_barcode='T0059376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1720500',harga_beli ='1720500' WHERE kode_barcode='T0059495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='T0059500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4955500',harga_beli ='4955500' WHERE kode_barcode='T0059520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3272500',harga_beli ='3272500' WHERE kode_barcode='T0059519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='T0059517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3759000',harga_beli ='3759000' WHERE kode_barcode='T0059516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='T0059507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3385000',harga_beli ='3385000' WHERE kode_barcode='T0059506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3179000',harga_beli ='3179000' WHERE kode_barcode='T0059505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5329500',harga_beli ='5329500' WHERE kode_barcode='T0059503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4825000',harga_beli ='4825000' WHERE kode_barcode='T0059502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5105500',harga_beli ='5105500' WHERE kode_barcode='T0059527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6545000',harga_beli ='6545000' WHERE kode_barcode='T0042036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1122000',harga_beli ='1122000' WHERE kode_barcode='T0071232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5573000',harga_beli ='5573000' WHERE kode_barcode='T0063029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5348500',harga_beli ='5348500' WHERE kode_barcode='T0063030' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9687000',harga_beli ='9687000' WHERE kode_barcode='T0063031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6788500',harga_beli ='6788500' WHERE kode_barcode='T0063022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5610000',harga_beli ='5610000' WHERE kode_barcode='T0071236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2768000',harga_beli ='2768000' WHERE kode_barcode='T0071237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='T0064224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3927000',harga_beli ='3927000' WHERE kode_barcode='T0064225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6564000',harga_beli ='6564000' WHERE kode_barcode='T0064227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7237000',harga_beli ='7237000' WHERE kode_barcode='T0065472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6321000',harga_beli ='6321000' WHERE kode_barcode='T0065473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1963500',harga_beli ='1963500' WHERE kode_barcode='T0066779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1833000',harga_beli ='1833000' WHERE kode_barcode='T0068753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='991500',harga_beli ='991500' WHERE kode_barcode='T0068752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9387500',harga_beli ='9387500' WHERE kode_barcode='T0068740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3684000',harga_beli ='3684000' WHERE kode_barcode='T0068741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3740000',harga_beli ='3740000' WHERE kode_barcode='T0068739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2842500',harga_beli ='2842500' WHERE kode_barcode='T0068948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1122000',harga_beli ='1122000' WHERE kode_barcode='T0069499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1178500',harga_beli ='1178500' WHERE kode_barcode='T0069500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='954000',harga_beli ='954000' WHERE kode_barcode='T0069501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2001000',harga_beli ='2001000' WHERE kode_barcode='T0069934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='3721500',harga_beli ='3721500' WHERE kode_barcode='T0069936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9369000',harga_beli ='9369000' WHERE kode_barcode='T0070158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9107000',harga_beli ='9107000' WHERE kode_barcode='T0070159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='T0070509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='19130500',harga_beli ='19130500' WHERE kode_barcode='T0070514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4862000',harga_beli ='4862000' WHERE kode_barcode='T0070515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='22403000',harga_beli ='22403000' WHERE kode_barcode='T0070516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7274500',harga_beli ='7274500' WHERE kode_barcode='T0071525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4656500',harga_beli ='4656500' WHERE kode_barcode='T0071526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5778500',harga_beli ='5778500' WHERE kode_barcode='T0071529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='9537000',harga_beli ='9537000' WHERE kode_barcode='T0072100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='879000',harga_beli ='879000' WHERE kode_barcode='T0072605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4451000',harga_beli ='4451000' WHERE kode_barcode='T0072606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1047500',harga_beli ='1047500' WHERE kode_barcode='T0072977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5685000',harga_beli ='5685000' WHERE kode_barcode='T0072634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='841500',harga_beli ='841500' WHERE kode_barcode='T0072975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1029000',harga_beli ='1029000' WHERE kode_barcode='T0072976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7386500',harga_beli ='7386500' WHERE kode_barcode='T0073721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1141000',harga_beli ='1141000' WHERE kode_barcode='T0073761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='7723500',harga_beli ='7723500' WHERE kode_barcode='T0074493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='T0074484' LIMIT 1;
UPDATE tm_group SET harga='1870000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','1870000','input','2025-12-04 15:03:43');
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5027500',harga_beli ='5027500' WHERE kode_barcode='T0027903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='888500',harga_beli ='888500' WHERE kode_barcode='T0027962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3837000',harga_beli ='3837000' WHERE kode_barcode='T0025250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='T0025240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='9563500',harga_beli ='9563500' WHERE kode_barcode='T0002682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5764500',harga_beli ='5764500' WHERE kode_barcode='T0002681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5613500',harga_beli ='5613500' WHERE kode_barcode='T0002680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7579000',harga_beli ='7579000' WHERE kode_barcode='T0002701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4158500',harga_beli ='4158500' WHERE kode_barcode='T0002702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5802500',harga_beli ='5802500' WHERE kode_barcode='T0002545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5103000',harga_beli ='5103000' WHERE kode_barcode='T0003215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4687500',harga_beli ='4687500' WHERE kode_barcode='T0003578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2362500',harga_beli ='2362500' WHERE kode_barcode='T0029910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3137500',harga_beli ='3137500' WHERE kode_barcode='T0003883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='9374500',harga_beli ='9374500' WHERE kode_barcode='T0006181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='6105000',harga_beli ='6105000' WHERE kode_barcode='T0009249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1134000',harga_beli ='1134000' WHERE kode_barcode='T0062967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3402000',harga_beli ='3402000' WHERE kode_barcode='T0027964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2268000',harga_beli ='2268000' WHERE kode_barcode='T0029909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='28293500',harga_beli ='28293500' WHERE kode_barcode='T0014667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='12871000',harga_beli ='12871000' WHERE kode_barcode='T0014724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7768000',harga_beli ='7768000' WHERE kode_barcode='T0001396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4177000',harga_beli ='4177000' WHERE kode_barcode='T0021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1512000',harga_beli ='1512000' WHERE kode_barcode='T0022496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='964000',harga_beli ='964000' WHERE kode_barcode='T0022495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5235500',harga_beli ='5235500' WHERE kode_barcode='T0022928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3988000',harga_beli ='3988000' WHERE kode_barcode='T0023426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='8127000',harga_beli ='8127000' WHERE kode_barcode='T0023442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2703000',harga_beli ='2703000' WHERE kode_barcode='T0001914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='945000',harga_beli ='945000' WHERE kode_barcode='T0026797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3969000',harga_beli ='3969000' WHERE kode_barcode='T0026857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5727000',harga_beli ='5727000' WHERE kode_barcode='T0026861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1228500',harga_beli ='1228500' WHERE kode_barcode='T0029908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='28350000',harga_beli ='28350000' WHERE kode_barcode='T0029659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4007000',harga_beli ='4007000' WHERE kode_barcode='T0029880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4007000',harga_beli ='4007000' WHERE kode_barcode='T0031224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='15252500',harga_beli ='15252500' WHERE kode_barcode='T0002012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='14931000',harga_beli ='14931000' WHERE kode_barcode='T0023388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='9658000',harga_beli ='9658000' WHERE kode_barcode='T0032844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2759500',harga_beli ='2759500' WHERE kode_barcode='T0032978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5878000',harga_beli ='5878000' WHERE kode_barcode='T0033642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5216500',harga_beli ='5216500' WHERE kode_barcode='T0034358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3685500',harga_beli ='3685500' WHERE kode_barcode='T0034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7428000',harga_beli ='7428000' WHERE kode_barcode='T0034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2854000',harga_beli ='2854000' WHERE kode_barcode='T0034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1417500',harga_beli ='1417500' WHERE kode_barcode='T0034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4101500',harga_beli ='4101500' WHERE kode_barcode='T0035428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='18541000',harga_beli ='18541000' WHERE kode_barcode='T0036272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1077500',harga_beli ='1077500' WHERE kode_barcode='T0036773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1606500',harga_beli ='1606500' WHERE kode_barcode='T0036774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3534500',harga_beli ='3534500' WHERE kode_barcode='T0037241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='13513500',harga_beli ='13513500' WHERE kode_barcode='T0037438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='983000',harga_beli ='983000' WHERE kode_barcode='T0037911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1890000',harga_beli ='1890000' WHERE kode_barcode='T0038821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1644500',harga_beli ='1644500' WHERE kode_barcode='T0038822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1833500',harga_beli ='1833500' WHERE kode_barcode='T0038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4290500',harga_beli ='4290500' WHERE kode_barcode='T0038800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='888500',harga_beli ='888500' WHERE kode_barcode='T0038825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='18446500',harga_beli ='18446500' WHERE kode_barcode='T0038814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3912500',harga_beli ='3912500' WHERE kode_barcode='T0039187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2986500',harga_beli ='2986500' WHERE kode_barcode='T0040115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='13381500',harga_beli ='13381500' WHERE kode_barcode='T0040117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='9639000',harga_beli ='9639000' WHERE kode_barcode='T0040118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4914000',harga_beli ='4914000' WHERE kode_barcode='T0040624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5311000',harga_beli ='5311000' WHERE kode_barcode='T0040627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5897000',harga_beli ='5897000' WHERE kode_barcode='T0040626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7579000',harga_beli ='7579000' WHERE kode_barcode='T0040623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4063500',harga_beli ='4063500' WHERE kode_barcode='T0041161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3988000',harga_beli ='3988000' WHERE kode_barcode='T0041160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2759500',harga_beli ='2759500' WHERE kode_barcode='T0041674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3931500',harga_beli ='3931500' WHERE kode_barcode='T0041675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='19183500',harga_beli ='19183500' WHERE kode_barcode='T0041931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='983000',harga_beli ='983000' WHERE kode_barcode='T0042204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5764500',harga_beli ='5764500' WHERE kode_barcode='T0071235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='11283500',harga_beli ='11283500' WHERE kode_barcode='T0042400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2854000',harga_beli ='2854000' WHERE kode_barcode='T0042533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1134000',harga_beli ='1134000' WHERE kode_barcode='T0043133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5557000',harga_beli ='5557000' WHERE kode_barcode='T0043381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1096500',harga_beli ='1096500' WHERE kode_barcode='T0044092' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2079500',harga_beli ='2079500' WHERE kode_barcode='T0044157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1228500',harga_beli ='1228500' WHERE kode_barcode='T0044158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='964000',harga_beli ='964000' WHERE kode_barcode='T0044160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4914000',harga_beli ='4914000' WHERE kode_barcode='T0045278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='9677000',harga_beli ='9677000' WHERE kode_barcode='T0045290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1040000',harga_beli ='1040000' WHERE kode_barcode='T0045374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='945000',harga_beli ='945000' WHERE kode_barcode='T0045369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3742500',harga_beli ='3742500' WHERE kode_barcode='T0046373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1777000',harga_beli ='1777000' WHERE kode_barcode='T0072991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2892000',harga_beli ='2892000' WHERE kode_barcode='T0047403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1040000',harga_beli ='1040000' WHERE kode_barcode='T0047406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5764500',harga_beli ='5764500' WHERE kode_barcode='T0047431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='6615000',harga_beli ='6615000' WHERE kode_barcode='T0047440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2551500',harga_beli ='2551500' WHERE kode_barcode='T0048974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2400500',harga_beli ='2400500' WHERE kode_barcode='T0049662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1228500',harga_beli ='1228500' WHERE kode_barcode='T0049706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5575500',harga_beli ='5575500' WHERE kode_barcode='T0049721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3837000',harga_beli ='3837000' WHERE kode_barcode='T0050466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7749500',harga_beli ='7749500' WHERE kode_barcode='T0050927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4063500',harga_beli ='4063500' WHERE kode_barcode='T0051696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='964000',harga_beli ='964000' WHERE kode_barcode='T0051697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3969000',harga_beli ='3969000' WHERE kode_barcode='T0051699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1096500',harga_beli ='1096500' WHERE kode_barcode='T0051709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5122000',harga_beli ='5122000' WHERE kode_barcode='T0051773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1739000',harga_beli ='1739000' WHERE kode_barcode='T0052760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1266500',harga_beli ='1266500' WHERE kode_barcode='T0052761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1191000',harga_beli ='1191000' WHERE kode_barcode='T0052762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1380000',harga_beli ='1380000' WHERE kode_barcode='T0052763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='8788500',harga_beli ='8788500' WHERE kode_barcode='T0052782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='9507000',harga_beli ='9507000' WHERE kode_barcode='T0052845' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2098000',harga_beli ='2098000' WHERE kode_barcode='T0052907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2551500',harga_beli ='2551500' WHERE kode_barcode='T0052910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1984500',harga_beli ='1984500' WHERE kode_barcode='T0052915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1909000',harga_beli ='1909000' WHERE kode_barcode='T0052919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7276500',harga_beli ='7276500' WHERE kode_barcode='T0054364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4063500',harga_beli ='4063500' WHERE kode_barcode='T0054370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='6615000',harga_beli ='6615000' WHERE kode_barcode='T0054371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2079500',harga_beli ='2079500' WHERE kode_barcode='T0056709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3515500',harga_beli ='3515500' WHERE kode_barcode='T0056728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1984500',harga_beli ='1984500' WHERE kode_barcode='T0056814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1569000',harga_beli ='1569000' WHERE kode_barcode='T0056815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7654500',harga_beli ='7654500' WHERE kode_barcode='T0056834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='7428000',harga_beli ='7428000' WHERE kode_barcode='T0057159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3856000',harga_beli ='3856000' WHERE kode_barcode='T0071234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='983000',harga_beli ='983000' WHERE kode_barcode='T0071230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='11623500',harga_beli ='11623500' WHERE kode_barcode='T0059340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1380000',harga_beli ='1380000' WHERE kode_barcode='T0059377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='18805500',harga_beli ='18805500' WHERE kode_barcode='T0059529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='945000',harga_beli ='945000' WHERE kode_barcode='T0062988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='11208000',harga_beli ='11208000' WHERE kode_barcode='T0063020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='9658000',harga_beli ='9658000' WHERE kode_barcode='T0063023' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1040000',harga_beli ='1040000' WHERE kode_barcode='T0066579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='2665000',harga_beli ='2665000' WHERE kode_barcode='T0068917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='3875000',harga_beli ='3875000' WHERE kode_barcode='T0070154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1285500',harga_beli ='1285500' WHERE kode_barcode='T0070764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5613500',harga_beli ='5613500' WHERE kode_barcode='T0071515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5557000',harga_beli ='5557000' WHERE kode_barcode='T0072099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5538000',harga_beli ='5538000' WHERE kode_barcode='T0072636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='945000',harga_beli ='945000' WHERE kode_barcode='T0072974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1720000',harga_beli ='1720000' WHERE kode_barcode='T0073762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1323000',harga_beli ='1323000' WHERE kode_barcode='T0073763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='1040000',harga_beli ='1040000' WHERE kode_barcode='T0074548' LIMIT 1;
UPDATE tm_group SET harga='1890000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','1890000','input','2025-12-04 15:04:02');
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9665000',harga_beli ='9665000' WHERE kode_barcode='T0063024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1337000',harga_beli ='1337000' WHERE kode_barcode='T0045109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5978500',harga_beli ='5978500' WHERE kode_barcode='T0053759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1299000',harga_beli ='1299000' WHERE kode_barcode='T0047446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4584000',harga_beli ='4584000' WHERE kode_barcode='T0048975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7487500',harga_beli ='7487500' WHERE kode_barcode='T0049718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='6819000',harga_beli ='6819000' WHERE kode_barcode='T0050025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5940500',harga_beli ='5940500' WHERE kode_barcode='T0050028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5558500',harga_beli ='5558500' WHERE kode_barcode='T0050029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2426000',harga_beli ='2426000' WHERE kode_barcode='T0051751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7793000',harga_beli ='7793000' WHERE kode_barcode='T0051771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9321000',harga_beli ='9321000' WHERE kode_barcode='T0057162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='6265000',harga_beli ='6265000' WHERE kode_barcode='T0059521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0060275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='802500',harga_beli ='802500' WHERE kode_barcode='T0045111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3935000',harga_beli ='3935000' WHERE kode_barcode='T0063019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4890000',harga_beli ='4890000' WHERE kode_barcode='T0066778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2808000',harga_beli ='2808000' WHERE kode_barcode='T0069579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0069580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2827000',harga_beli ='2827000' WHERE kode_barcode='T0069582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2731500',harga_beli ='2731500' WHERE kode_barcode='T0069583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2827000',harga_beli ='2827000' WHERE kode_barcode='T0069584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3877500',harga_beli ='3877500' WHERE kode_barcode='T0070517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7755000',harga_beli ='7755000' WHERE kode_barcode='T0065449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3686500',harga_beli ='3686500' WHERE kode_barcode='T0069911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5749500',harga_beli ='5749500' WHERE kode_barcode='T0072632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='497000',harga_beli ='497000' WHERE kode_barcode='T0072971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='573000',harga_beli ='573000' WHERE kode_barcode='T0074547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='11613000',harga_beli ='11613000' WHERE kode_barcode='T0033028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3916000',harga_beli ='3916000' WHERE kode_barcode='T0026463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='688000',harga_beli ='688000' WHERE kode_barcode='T0062982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5845000',harga_beli ='5845000' WHERE kode_barcode='T0001778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4909000',harga_beli ='4909000' WHERE kode_barcode='T0009257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4488500',harga_beli ='4488500' WHERE kode_barcode='T0012680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5463000',harga_beli ='5463000' WHERE kode_barcode='T0027564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='8977000',harga_beli ='8977000' WHERE kode_barcode='T0029906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='6207500',harga_beli ='6207500' WHERE kode_barcode='T0031228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='6628000',harga_beli ='6628000' WHERE kode_barcode='T0031229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4049500',harga_beli ='4049500' WHERE kode_barcode='T0031706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='13370000',harga_beli ='13370000' WHERE kode_barcode='T0033026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5768500',harga_beli ='5768500' WHERE kode_barcode='T0033040' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4718000',harga_beli ='4718000' WHERE kode_barcode='T0033038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='15089000',harga_beli ='15089000' WHERE kode_barcode='T0002535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='15471000',harga_beli ='15471000' WHERE kode_barcode='T0033027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9779500',harga_beli ='9779500' WHERE kode_barcode='T0033650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3973000',harga_beli ='3973000' WHERE kode_barcode='T0033858' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='22748500',harga_beli ='22748500' WHERE kode_barcode='T0001409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='802500',harga_beli ='802500' WHERE kode_barcode='T0029798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='15184500',harga_beli ='15184500' WHERE kode_barcode='T0035449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4106500',harga_beli ='4106500' WHERE kode_barcode='T0037440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='19138500',harga_beli ='19138500' WHERE kode_barcode='T0038811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7162500',harga_beli ='7162500' WHERE kode_barcode='T0039636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9569500',harga_beli ='9569500' WHERE kode_barcode='T0039646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='6036000',harga_beli ='6036000' WHERE kode_barcode='T0040120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9741000',harga_beli ='9741000' WHERE kode_barcode='T0042655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0043700' LIMIT 1;
UPDATE tm_group SET harga='1910000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','1910000','input','2025-12-04 15:04:15');
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='23411000',harga_beli ='23411000' WHERE kode_barcode='T0038815' LIMIT 1;
UPDATE tm_group SET harga='1930000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','1930000','input','2025-12-04 15:04:24');
UPDATE tm_group SET harga='1950000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','1950000','input','2025-12-04 15:04:37');
UPDATE tm_group SET harga='1970000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','1970000','input','2025-12-04 15:04:46');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-04';
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-12-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-04' 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-251205-0001','D','2025-12-05','15:15:27','SYSTEM','SALDO AWAL','SALDO AWAL','0','992941000','992941000');
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-251205-0001','D','2025-12-05','15:15:27','BCA','SALDO AWAL','SALDO AWAL','0','694074000','694074000');
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-251205-0001','D','2025-12-05','15:15:27','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-251205-0001','D','2025-12-05','15:15:27','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-12-05';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','A1E-YKAA-314-0','1','0.510','0.510','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YKAA-314-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YKAA-314-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-05 16:55:03' WHERE kode_barang='A1E-YKAA-314-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YKAA-314-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:03','TOKO','PM-A','A1E','A1E-YKAA-314-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YKAA-314-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YKAA-314-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','A1E-YKAG-35-0','1','0.510','0.510','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YKAG-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YKAG-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-05 16:55:03' WHERE kode_barang='A1E-YKAG-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YKAG-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:03','TOKO','PM-A','A1E','A1E-YKAG-35-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YKAG-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YKAG-35-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251205-0001','2025-12-05','16:54','1.020','admpindah','2025-12-04 16:55:02');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','F1E-YLXD-60-0','1','1.950','1.950','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXD-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXD-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-05 16:55:20' WHERE kode_barang='F1E-YLXD-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXD-60-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:20','TOKO','PM-F','F1E','F1E-YLXD-60-0','1','1.950','1.950','1','1.950','1.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YLXD-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXD-60-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','F1E-YLXD-61-0','1','2.600','2.600','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXD-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXD-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-05 16:55:20' WHERE kode_barang='F1E-YLXD-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXD-61-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:20','TOKO','PM-F','F1E','F1E-YLXD-61-0','1','2.600','2.600','1','2.600','2.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YLXD-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXD-61-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','F1E-YLXD-62-0','1','2.460','2.460','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXD-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXD-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-05 16:55:20' WHERE kode_barang='F1E-YLXD-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXD-62-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:20','TOKO','PM-F','F1E','F1E-YLXD-62-0','1','2.460','2.460','1','2.460','2.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YLXD-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXD-62-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','F1E-YLXD-63-0','1','1.010','1.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXD-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXD-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-05 16:55:20' WHERE kode_barang='F1E-YLXD-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXD-63-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:20','TOKO','PM-F','F1E','F1E-YLXD-63-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YLXD-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXD-63-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','F1E-YLXD-64-0','1','1.010','1.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXD-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXD-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-05 16:55:20' WHERE kode_barang='F1E-YLXD-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXD-64-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:20','TOKO','PM-F','F1E','F1E-YLXD-64-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YLXD-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXD-64-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251205-0001','2025-12-05','16:55','9.030','admpindah','2025-12-04 16:55:20');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','H1E-YKXA-209-0','1','3.100','3.100','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YKXA-209-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YKXA-209-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-05 16:55:37' WHERE kode_barang='H1E-YKXA-209-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YKXA-209-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:37','TOKO','PM-H','H1E','H1E-YKXA-209-0','1','3.100','3.100','1','3.100','3.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YKXA-209-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YKXA-209-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251205-0001','1','H1E-YLXD-16-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLXD-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLXD-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-05 16:55:37' WHERE kode_barang='H1E-YLXD-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLXD-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-05 16:55:37','TOKO','PM-H','H1E','H1E-YLXD-16-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YLXD-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLXD-16-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251205-0001','2025-12-05','16:55','5.150','admpindah','2025-12-04 16:55:37');