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 ('F326060857171','input','1',' MFE1F X LG','TOKO','PM-E','E1F-ZDBG-296-0','CC X MODEL KUPU LG 14 8K ','','0.350','1','100.00','378000','0','0','15000','378000','0','0','0','378000','LIS','00401539','E1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZDBG-296-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='E1F-ZDBG-296-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060857171','2026-07-06','0.350','2026-07-06','08:57:18','PLG0030159','378000','378000','0','378000','378000','input','2026-07-06 08:57:17','F32606085717');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060857171','2026-07-06','08:57:18','LIS','378000','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-260706-0002','D','2026-07-06','08:57:18','input','PENJUALAN','F326060857171','6150747000','378000','6151125000');
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 ('F326060928261','input','1',' MEF3E X MT','TOKO','PM-F','F3E-ZFXH-118-0','GL X HERLEY SLEP MT 8K ','','4.150','1','100.00','4399000','0','0','15000','4399000','0','0','0','4399000','AAT','00407979','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXH-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='F3E-ZFXH-118-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060928261','2026-07-06','4.150','2026-07-06','09:28:26','PLG0030160','4399000','4399000','0','4399000','4399000','input','2026-07-06 09:28:26','F32606092826');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060928261','2026-07-06','09:28:26','AAT','4399000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0003','D','2026-07-06','09:28:26','input','PENJUALAN','F326060928261','6151125000','4399000','6155524000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4399000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326060928261' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060928262','input',' 1',' MEH1 X KH ','TOKO','PM-H','H1E-ZFAG-80-0','KL X NORY SEMI KH 48 8K ','','5.010','1','100.00','5311000','0','0','15000','5311000','0','0','0','5311000','AAT','00408903','H1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAG-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.010',berat_jual_asli=berat_jual_asli+'5.010',stock_jual='1',berat_akhir=berat_akhir-'5.010',berat_akhir_asli=berat_akhir_asli-'5.010',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='H1E-ZFAG-80-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 ('F326060928262','2026-07-06','5.010','2026-07-06','09:28:26','PLG0030161','5311000','5311000','0','5311000','5311000','input','2026-07-06 09:28:26','F32606092826');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060928262','2026-07-06','09:28:26','AAT','5311000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0004','D','2026-07-06','09:28:26','input','PENJUALAN','F326060928262','6155524000','5311000','6160835000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5311000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326060928262' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060942061','input','1',' MDD2D CM ','TOKO','PM-D','D2D-ZDAE-222-0','LT MODEL MATA CM 8K ','','0.850','1','100.00','884000','0','0','15000','885000','0','0','0','885000','LIS','00399508','D2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZDAE-222-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='D2D-ZDAE-222-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 ('F326060942061','2026-07-06','0.850','2026-07-06','09:42:07','PLG0030162','885000','885000','0','885000','885000','input','2026-07-06 09:42:06','F32606094206');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060942061','2026-07-06','09:42:07','LIS','885000','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-260706-0005','D','2026-07-06','09:42:07','input','PENJUALAN','F326060942061','6160835000','885000','6161720000');
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 ('F326061015551','input','1',' MDE2D CM 2','TOKO','PM-E','E2D-ZFXB-95-0','CC MODEL MATA SLEP CM 20 8K ','','1.110','1','100.00','1154000','0','0','15000','1154000','0','0','0','1154000','FIT','00406487','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXB-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='E2D-ZFXB-95-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061015551','2026-07-06','1.110','2026-07-06','10:15:56','PLG0030163','1154000','1154000','0','1154000','1154000','input','2026-07-06 10:15:55','F32606101555');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061015551','2026-07-06','10:15:56','FIT','1154000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0006','D','2026-07-06','10:15:56','input','PENJUALAN','F326061015551','6161720000','1154000','6162874000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1154000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061015551' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061015552','input',' 1',' MEF3E HW ','TOKO','PM-F','F3E-ZEAH-98-0','GL CASTELI HATI SLEP HW 8K ','','2.130','1','100.00','2258000','0','0','15000','2258000','0','0','0','2258000','FIT','00404004','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAH-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='F3E-ZEAH-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061015552','2026-07-06','2.130','2026-07-06','10:15:56','PLG0030164','2258000','2258000','0','2258000','2258000','input','2026-07-06 10:15:55','F32606101555');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061015552','2026-07-06','10:15:56','FIT','2258000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0007','D','2026-07-06','10:15:56','input','PENJUALAN','F326061015552','6162874000','2258000','6165132000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2258000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061015552' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019569','X-00019569','KL ANAK SANTA HW 32CM 8K','GR','---','H1E','BELI','BELI001','1013000','2026-07-06','1.030','1','kasir','2026-07-06 10:41:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019569','X-00019569');
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-260706-0001','F326020830391','LIS','1','BELI','BELI001','H1E', 'X-00019569', 'KL ANAK SANTA HW 32CM 8K','1.030','1.030','100.00','1140000','1013000','983495','1070000','1','1013000','1013000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260706-0001','2026-07-06','2026-07-06','10:41:35','LIS','---','1.030','1013000','1013000','1013000','1013000','1013000','kasir','2026-07-06 10:41:35','FB-260706-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260706-0001','WAHYU','TALESAN','','','','kasir','2026-07-06 10:41:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-06' 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-260706-0008','K','2026-07-06','10:41:35','kasir','PEMBELIAN UMUM','FB-260706-0001','6165132000','1013000','6164119000');
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-00019570','X-00019570','CC X MODEL HATI MATA BM 14 8K','GR','---','E2D','BELI','BELI001','643000','2026-07-06','0.870','1','kasir','2026-07-06 10:42:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019570','X-00019570');
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-260706-0002','F325040815541','FIT','1','BELI','BELI001','E2D', 'X-00019570', 'CC X MODEL HATI MATA BM 14 8K','0.870','0.870','100.00','685000','643000','739080','1050000','1','643000','643000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.870',berat_beli_asli=berat_beli_asli+'0.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.870',berat_akhir_asli=berat_akhir_asli+'0.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-06' 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-260706-0002','2026-07-06','2026-07-06','10:42:54','FIT','---','0.870','643000','643000','643000','643000','643000','kasir','2026-07-06 10:42:54','FB-260706-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260706-0002','LIA','CONTO','','','','kasir','2026-07-06 10:42:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-06' 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-260706-0009','K','2026-07-06','10:42:54','kasir','PEMBELIAN UMUM','FB-260706-0002','6164119000','643000','6163476000');
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-00019571','X-00019571','CC MODEL BUNGA ARESO MATA VAR YT 16 8K','GR','---','E2D','BELI','BELI001','697000','2026-07-06','0.970','1','kasir','2026-07-06 10:42:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019571','X-00019571');
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-260706-0003','F325290945531','FIT','2','BELI','BELI001','E2D', 'X-00019571', 'CC MODEL BUNGA ARESO MATA VAR YT 16 8K','0.970','0.970','100.00','743000','697000','718557','1050000','1','697000','697000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-06' 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-260706-0003','2026-07-06','2026-07-06','10:42:54','FIT','---','0.970','697000','697000','697000','697000','697000','kasir','2026-07-06 10:42:55','FB-260706-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260706-0003','LIA','CONTO BULUKERTO','','','','kasir','2026-07-06 10:42:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-06' 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-260706-0010','K','2026-07-06','10:42:54','kasir','PEMBELIAN UMUM','FB-260706-0003','6163476000','697000','6162779000');
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-00019572','X-00019572','GL OVAL MODEL BUNGA ARESO VAR YT D54 8K','GR','---','F1E','BELI','BELI001','2092000','2026-07-06','2.800','1','kasir','2026-07-06 10:42:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019572','X-00019572');
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-260706-0004','F325290945532','FIT','3','BELI','BELI001','F1E', 'X-00019572', 'GL OVAL MODEL BUNGA ARESO VAR YT D54 8K','2.800','2.800','100.00','2185000','2092000','747143','1070000','1','2092000','2092000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.800',berat_beli_asli=berat_beli_asli+'2.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.800',berat_akhir_asli=berat_akhir_asli+'2.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260706-0004','2026-07-06','2026-07-06','10:42:54','FIT','---','2.800','2092000','2092000','2092000','2092000','2092000','kasir','2026-07-06 10:42:55','FB-260706-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260706-0004','LIA','CONTO BULUKERTO','','','','kasir','2026-07-06 10:42:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-06' 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-260706-0011','K','2026-07-06','10:42:54','kasir','PEMBELIAN UMUM','FB-260706-0004','6162779000','2092000','6160687000');
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-00019573','X-00019573','KL SANTA MODEL HATI MATA VAR KH 8K','GR','---','H1E','BELI','BELI001','2255000','2026-07-06','2.740','1','kasir','2026-07-06 10:43:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019573','X-00019573');
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-260706-0005','F325080123282','FIT','1','BELI','BELI001','H1E', 'X-00019573', 'KL SANTA MODEL HATI MATA VAR KH 8K','2.740','2.740','100.00','2425000','2255000','822993','1070000','1','2255000','2255000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.740',berat_beli_asli=berat_beli_asli+'2.740',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.740',berat_akhir_asli=berat_akhir_asli+'2.740',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260706-0005','2026-07-06','2026-07-06','10:43:11','FIT','---','2.740','2255000','2255000','2255000','2255000','2255000','kasir','2026-07-06 10:43:12','FB-260706-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260706-0005','LENI','SEMPU NAWANGAN','','','081249979108','kasir','2026-07-06 10:43:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-06' 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-260706-0012','K','2026-07-06','10:43:11','kasir','PEMBELIAN UMUM','FB-260706-0005','6160687000','2255000','6158432000');
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-00019574','X-00019574','AT GYPSY ANAK SLEP LG 8K','GR','---','A1E','BELI','BELI001','540000','2026-07-06','0.550','1','kasir','2026-07-06 10:43:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019574','X-00019574');
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-260706-0006','F326240240261','SIN','1','BELI','BELI001','A1E', 'X-00019574', 'AT GYPSY ANAK SLEP LG 8K','0.550','0.550','100.00','688000','540000','981818','1070000','1','540000','540000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260706-0006','2026-07-06','2026-07-06','10:43:30','SIN','---','0.550','540000','540000','540000','540000','540000','kasir','2026-07-06 10:43:30','FB-260706-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260706-0006','ULVA','GENENG BULUKERTO','','','082241464682','kasir','2026-07-06 10:43:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-06' 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-260706-0013','K','2026-07-06','10:43:30','kasir','PEMBELIAN UMUM','FB-260706-0006','6158432000','540000','6157892000');
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 ('F326061050171','kasir','1',' MEH1 KH 44','TOKO','PM-H','H1E-ZEBE-219-0','KL SANTA KH 8K 44 CM ','','4.060','1','100.00','4304000','0','0','15000','4304000','0','0','0','4304000','SIN','00404918','H1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBE-219-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='H1E-ZEBE-219-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 ('F326061050171','2026-07-06','4.060','2026-07-06','10:50:18','PLG0030165','4304000','4304000','0','4304000','4304000','kasir','2026-07-06 10:50:17','F32606105017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061050171','2026-07-06','10:50:18','SIN','4304000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0014','D','2026-07-06','10:50:18','kasir','PENJUALAN','F326061050171','6157892000','4304000','6162196000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4304000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061050171' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061050172','kasir',' 1',' MDD2D X CM','TOKO','PM-D','D2D-ZCCX-381-0','LT X MODEL MATA CM 8K ','','0.850','1','100.00','884000','0','0','15000','884000','0','0','0','884000','SIN','00397035','D2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZCCX-381-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='D2D-ZCCX-381-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 ('F326061050172','2026-07-06','0.850','2026-07-06','10:50:18','PLG0030166','884000','884000','0','884000','884000','kasir','2026-07-06 10:50:17','F32606105017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061050172','2026-07-06','10:50:18','SIN','884000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0015','D','2026-07-06','10:50:18','kasir','PENJUALAN','F326061050172','6162196000','884000','6163080000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='884000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061050172' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061105551','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZDBG-233-0','CC X MODEL MATA CM 10 8K ','','1.040','1','100.00','1082000','0','0','15000','1083000','0','0','0','1083000','SIN','00401476','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBG-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='E2D-ZDBG-233-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061105551','2026-07-06','1.040','2026-07-06','11:05:55','PLG0030167','1083000','1083000','0','1083000','1083000','kasir','2026-07-06 11:05:55','F32606110555');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061105551','2026-07-06','11:05:55','SIN','1083000','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-260706-0016','D','2026-07-06','11:05:55','kasir','PENJUALAN','F326061105551','6163080000','1083000','6164163000');
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 ('F326061129101','kasir','1',' MEF1 XX UB','TOKO','PM-F','F1E-ZBAD-150-0','GL XX OVAL C SLEP UB 56 8K ','','4.650','1','100.00','4929000','0','0','15000','4790000','0','0','0','4790000','AAT','00389756','F1E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZBAD-150-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.650',berat_jual_asli=berat_jual_asli+'4.650',stock_jual='1',berat_akhir=berat_akhir-'4.650',berat_akhir_asli=berat_akhir_asli-'4.650',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='F1E-ZBAD-150-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061129101','2026-07-06','4.650','2026-07-06','11:29:10','PLG0030168','4790000','4790000','0','4790000','4790000','kasir','2026-07-06 11:29:10','F32606112910');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061129101','2026-07-06','11:29:10','AAT','4790000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0017','D','2026-07-06','11:29:10','kasir','PENJUALAN','F326061129101','6164163000','4790000','6168953000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4790000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061129101' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061129102','kasir',' 1',' MGD1 5K BG','TOKO','PM-D','D1G-YIXD-204-0','LT SLOBOK BALOK BG S 8K ','GL TL','0.460','1','100.00','506000','0','0','15000','505000','0','35000','0','540000','AAT','00367961','D1G','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIXD-204-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='D1G-YIXD-204-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 ('F326061129102','2026-07-06','0.460','2026-07-06','11:29:10','PLG0030169','505000','505000','35000','540000','540000','kasir','2026-07-06 11:29:10','F32606112910');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061129102','2026-07-06','11:29:10','AAT','540000','35000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0018','D','2026-07-06','11:29:10','kasir','PENJUALAN','F326061129102','6168953000','540000','6169493000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='540000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061129102' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061132451','kasir','1',' MEF2 UB 56','TOKO','PM-F','F2E-ZGXA-281-0','GL OVAL PAKU MATA UB 56 8K ','','2.320','1','100.00','2459000','0','0','15000','2459000','0','0','0','2459000','LIS','00411805','F2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZGXA-281-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='F2E-ZGXA-281-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061132451','2026-07-06','2.320','2026-07-06','11:32:45','PLG0030170','2459000','2459000','0','2459000','2459000','kasir','2026-07-06 11:32:45','F32606113245');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061132451','2026-07-06','11:32:45','LIS','2459000','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-260706-0019','D','2026-07-06','11:32:45','kasir','PENJUALAN','F326061132451','6169493000','2459000','6171952000');
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 ('F326061133331','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZDBX-159-0','KL X GUCCI UB 44 8K ','','1.100','1','100.00','1166000','0','0','15000','1166000','0','0','0','1166000','LIS','00400096','H1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBX-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='H1E-ZDBX-159-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 ('F326061133331','2026-07-06','1.100','2026-07-06','11:33:33','PLG0030171','1166000','1166000','0','1166000','1166000','kasir','2026-07-06 11:33:33','F32606113333');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326061133331','2026-07-06','11:33:33','LIS','1166000','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-260706-0020','D','2026-07-06','11:33:33','kasir','PENJUALAN','F326061133331','6171952000','1166000','6173118000');
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 ('F326060126351','input','1',' MDE2 X UB ','TOKO','PM-E','E2D-ZGXA-67-0','CC X MODEL MATA UB 14 8K ','','1.920','1','100.00','1997000','0','0','15000','1998000','0','0','0','1998000','LIS','00411591','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXA-67-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='E2D-ZGXA-67-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060126351','2026-07-06','1.920','2026-07-06','13:26:35','PLG0030172','1998000','1998000','0','1998000','1998000','input','2026-07-06 13:26:35','F32606012635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060126351','2026-07-06','13:26:35','LIS','1998000','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-260706-0021','D','2026-07-06','13:26:35','input','PENJUALAN','F326060126351','6173118000','1998000','6175116000');
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-00019575','X-00019575','GL OVAL PAKU SLEP UB 54 8K','GR','---','F1E','BELI','BELI001','4375000','2026-07-06','4.870','1','kasir','2026-07-06 14:06:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019575','X-00019575');
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-260706-0007','F325191152511','AAT','1','BELI','BELI001','F1E', 'X-00019575', 'GL OVAL PAKU SLEP UB 54 8K','4.870','4.870','100.00','5148000','4375000','898357','1070000','1','4375000','4375000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.870',berat_beli_asli=berat_beli_asli+'4.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.870',berat_akhir_asli=berat_akhir_asli+'4.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260706-0007','2026-07-06','2026-07-06','14:06:32','AAT','---','4.870','4375000','4375000','4375000','4375000','4375000','kasir','2026-07-06 14:06:33','FB-260706-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260706-0007','DESI','PUHPELELM','','','081227841441','kasir','2026-07-06 14:06:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-06' 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-260706-0022','K','2026-07-06','14:06:32','kasir','PEMBELIAN UMUM','FB-260706-0007','6175116000','4375000','6170741000');
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 ('F326060210081','kasir','1',' MDB1D X CM','TOKO','PM-B','B1D-ZFBI-30-0','GW X ITALY SPECTRA VAR CM 8K ','','1.000','1','100.00','1040000','0','0','15000','1040000','0','0','0','1040000','AAT','00411022','B1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZFBI-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='B1D-ZFBI-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060210081','2026-07-06','1.000','2026-07-06','14:10:09','PLG0030173','1040000','1040000','0','1040000','1040000','kasir','2026-07-06 14:10:08','F32606021008');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060210081','2026-07-06','14:10:09','AAT','1040000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0023','D','2026-07-06','14:10:09','kasir','PENJUALAN','F326060210081','6170741000','1040000','6171781000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1040000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326060210081' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060210082','kasir',' 1',' MGA1G CM ','TOKO','PM-A','A1G-ZEBB-98-T','AT TINDIK ANAK SLEP CM 8K ','','0.250','1','100.00','275000','0','0','15000','275000','0','0','0','275000','AAT','T0079861','A1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEBB-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='A1G-ZEBB-98-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060210082','2026-07-06','0.250','2026-07-06','14:10:09','PLG0030174','275000','275000','0','275000','275000','kasir','2026-07-06 14:10:08','F32606021008');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060210082','2026-07-06','14:10:09','AAT','275000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260706-0024','D','2026-07-06','14:10:09','kasir','PENJUALAN','F326060210082','6171781000','275000','6172056000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='275000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326060210082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3625000',harga_beli ='3625000' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='11040000',harga_beli ='11040000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='10966500',harga_beli ='10966500' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9163500',harga_beli ='9163500' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='18400000',harga_beli ='18400000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='865000',harga_beli ='865000' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='11040000',harga_beli ='11040000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='11040000',harga_beli ='11040000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='11040000',harga_beli ='11040000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='14720000',harga_beli ='14720000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='18400000',harga_beli ='18400000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='12880000',harga_beli ='12880000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='12880000',harga_beli ='12880000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='12880000',harga_beli ='12880000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1932000',harga_beli ='1932000' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='920000',harga_beli ='920000' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='11077000',harga_beli ='11077000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7305000',harga_beli ='7305000' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1858500',harga_beli ='1858500' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3606500',harga_beli ='3606500' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='975500',harga_beli ='975500' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7305000',harga_beli ='7305000' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5483500',harga_beli ='5483500' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='14720000',harga_beli ='14720000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7360000',harga_beli ='7360000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='10304000',harga_beli ='10304000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2668000',harga_beli ='2668000' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5557000',harga_beli ='5557000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5557000',harga_beli ='5557000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3717000',harga_beli ='3717000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='957000',harga_beli ='957000' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3588000',harga_beli ='3588000' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5446500',harga_beli ='5446500' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2852000',harga_beli ='2852000' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1785000',harga_beli ='1785000' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2778500',harga_beli ='2778500' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3606500',harga_beli ='3606500' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5428000',harga_beli ='5428000' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1858500',harga_beli ='1858500' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9053000',harga_beli ='9053000' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3404000',harga_beli ='3404000' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7268000',harga_beli ='7268000' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5446500',harga_beli ='5446500' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='18418500',harga_beli ='18418500' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='18418500',harga_beli ='18418500' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='883500',harga_beli ='883500' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3698500',harga_beli ='3698500' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9237000',harga_beli ='9237000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7323500',harga_beli ='7323500' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='7323500',harga_beli ='7323500' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3698500',harga_beli ='3698500' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2668000',harga_beli ='2668000' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3680000',harga_beli ='3680000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='9237000',harga_beli ='9237000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5520000',harga_beli ='5520000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5557000',harga_beli ='5557000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='T0074546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='2981000',harga_beli ='2981000' WHERE kode_barcode='T0074549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5814500',harga_beli ='5814500' WHERE kode_barcode='T0074550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='1803500',harga_beli ='1803500' WHERE kode_barcode='T0076230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='3754000',harga_beli ='3754000' WHERE kode_barcode='T0076231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1840000',harga_jual='5428000',harga_beli ='5428000' WHERE kode_barcode='T0038726' LIMIT 1;
UPDATE tm_group SET harga='1840000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1840000','input','2026-07-06 14:19:23');
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2063000',harga_beli ='2063000' WHERE kode_barcode='T0076229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1967500',harga_beli ='1967500' WHERE kode_barcode='T0074492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2445000',harga_beli ='2445000' WHERE kode_barcode='T0075742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2483000',harga_beli ='2483000' WHERE kode_barcode='T0075743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2731500',harga_beli ='2731500' WHERE kode_barcode='T0075746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2674000',harga_beli ='2674000' WHERE kode_barcode='T0075751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3228000',harga_beli ='3228000' WHERE kode_barcode='T0075756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1738500',harga_beli ='1738500' WHERE kode_barcode='T0075757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2063000',harga_beli ='2063000' WHERE kode_barcode='T0075758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2674000',harga_beli ='2674000' WHERE kode_barcode='T0075759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3190000',harga_beli ='3190000' WHERE kode_barcode='T0075761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2827000',harga_beli ='2827000' WHERE kode_barcode='T0075762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3782000',harga_beli ='3782000' WHERE kode_barcode='T0075766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2598000',harga_beli ='2598000' WHERE kode_barcode='T0072972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3113500',harga_beli ='3113500' WHERE kode_barcode='T0076235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2827000',harga_beli ='2827000' WHERE kode_barcode='T0076236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0070411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3724500',harga_beli ='3724500' WHERE kode_barcode='T0076171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1967500',harga_beli ='1967500' WHERE kode_barcode='T0078281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3763000',harga_beli ='3763000' WHERE kode_barcode='T0078280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1738500',harga_beli ='1738500' WHERE kode_barcode='T0079713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2120500',harga_beli ='2120500' WHERE kode_barcode='T0079718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2943500',harga_beli ='2943500' WHERE kode_barcode='T0079721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2407000',harga_beli ='2407000' WHERE kode_barcode='T0079722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2941500',harga_beli ='2941500' WHERE kode_barcode='T0079723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3342500',harga_beli ='3342500' WHERE kode_barcode='T0065464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2387500',harga_beli ='2387500' WHERE kode_barcode='T0072983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3075500',harga_beli ='3075500' WHERE kode_barcode='T0062972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2483000',harga_beli ='2483000' WHERE kode_barcode='T0062984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3591000',harga_beli ='3591000' WHERE kode_barcode='T0063013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3916000',harga_beli ='3916000' WHERE kode_barcode='T0063014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2407000',harga_beli ='2407000' WHERE kode_barcode='T0072979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4584000',harga_beli ='4584000' WHERE kode_barcode='T0062985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4393000',harga_beli ='4393000' WHERE kode_barcode='T0072978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2216000',harga_beli ='2216000' WHERE kode_barcode='T0063000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='4546000',harga_beli ='4546000' WHERE kode_barcode='T0062997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3381000',harga_beli ='3381000' WHERE kode_barcode='T0062995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0065459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2216000',harga_beli ='2216000' WHERE kode_barcode='T0062981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2387500',harga_beli ='2387500' WHERE kode_barcode='T0065465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1394500',harga_beli ='1394500' WHERE kode_barcode='T0068921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2769500',harga_beli ='2769500' WHERE kode_barcode='T0070156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2636000',harga_beli ='2636000' WHERE kode_barcode='T0070157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3266500',harga_beli ='3266500' WHERE kode_barcode='T0070497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='8614500',harga_beli ='8614500' WHERE kode_barcode='T0070501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2387500',harga_beli ='2387500' WHERE kode_barcode='T0070504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1834000',harga_beli ='1834000' WHERE kode_barcode='T0070505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1681000',harga_beli ='1681000' WHERE kode_barcode='T0070508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2407000',harga_beli ='2407000' WHERE kode_barcode='T0070510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2712500',harga_beli ='2712500' WHERE kode_barcode='T0070512' LIMIT 1;
UPDATE tm_group SET harga='1910000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','1910000','input','2026-07-06 14:19:46');
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1505500',harga_beli ='1505500' WHERE kode_barcode='T0040093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2509000',harga_beli ='2509000' WHERE kode_barcode='T0027959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3049500',harga_beli ='3049500' WHERE kode_barcode='T0027952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1447500',harga_beli ='1447500' WHERE kode_barcode='T0027928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0025243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2567000',harga_beli ='2567000' WHERE kode_barcode='T0003111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4960500',harga_beli ='4960500' WHERE kode_barcode='T0003107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7141000',harga_beli ='7141000' WHERE kode_barcode='T0002687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3802500',harga_beli ='3802500' WHERE kode_barcode='T0003195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4825000',harga_beli ='4825000' WHERE kode_barcode='T0003210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3628500',harga_beli ='3628500' WHERE kode_barcode='T0003563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3127000',harga_beli ='3127000' WHERE kode_barcode='T0003573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1833500',harga_beli ='1833500' WHERE kode_barcode='T0029925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4169000',harga_beli ='4169000' WHERE kode_barcode='T0003161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2741000',harga_beli ='2741000' WHERE kode_barcode='T0003162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3686500',harga_beli ='3686500' WHERE kode_barcode='T0003163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1409000',harga_beli ='1409000' WHERE kode_barcode='T0003165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='907500',harga_beli ='907500' WHERE kode_barcode='T0003168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2509000',harga_beli ='2509000' WHERE kode_barcode='T0003169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2219500',harga_beli ='2219500' WHERE kode_barcode='T0003142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2644500',harga_beli ='2644500' WHERE kode_barcode='T0003146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3783000',harga_beli ='3783000' WHERE kode_barcode='T0003396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1833500',harga_beli ='1833500' WHERE kode_barcode='T0003411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1833500',harga_beli ='1833500' WHERE kode_barcode='T0003414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2162000',harga_beli ='2162000' WHERE kode_barcode='T0003417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6581500',harga_beli ='6581500' WHERE kode_barcode='T0003419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2818000',harga_beli ='2818000' WHERE kode_barcode='T0003433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6948000',harga_beli ='6948000' WHERE kode_barcode='T0003434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2741000',harga_beli ='2741000' WHERE kode_barcode='T0003440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5404000',harga_beli ='5404000' WHERE kode_barcode='T0003449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3899000',harga_beli ='3899000' WHERE kode_barcode='T0003453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3590000',harga_beli ='3590000' WHERE kode_barcode='T0003460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3474000',harga_beli ='3474000' WHERE kode_barcode='T0003461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3590000',harga_beli ='3590000' WHERE kode_barcode='T0003466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='15498000',harga_beli ='15498000' WHERE kode_barcode='T0072990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3146000',harga_beli ='3146000' WHERE kode_barcode='T0003481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2818000',harga_beli ='2818000' WHERE kode_barcode='T0003482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2934000',harga_beli ='2934000' WHERE kode_barcode='T0003594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4149500',harga_beli ='4149500' WHERE kode_barcode='T0003587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='13529500',harga_beli ='13529500' WHERE kode_barcode='T0003370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3609500',harga_beli ='3609500' WHERE kode_barcode='T0004022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1776000',harga_beli ='1776000' WHERE kode_barcode='T0004356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1737000',harga_beli ='1737000' WHERE kode_barcode='T0004351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2663500',harga_beli ='2663500' WHERE kode_barcode='T0006172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1872500',harga_beli ='1872500' WHERE kode_barcode='T0006175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2026500',harga_beli ='2026500' WHERE kode_barcode='T0006198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5500500',harga_beli ='5500500' WHERE kode_barcode='T0006197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2991500',harga_beli ='2991500' WHERE kode_barcode='T0006193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4053000',harga_beli ='4053000' WHERE kode_barcode='T0006190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3493500',harga_beli ='3493500' WHERE kode_barcode='T0006414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3899000',harga_beli ='3899000' WHERE kode_barcode='T0001870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1004000',harga_beli ='1004000' WHERE kode_barcode='T0008962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1100500',harga_beli ='1100500' WHERE kode_barcode='T0008964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3667000',harga_beli ='3667000' WHERE kode_barcode='T0009202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1602000',harga_beli ='1602000' WHERE kode_barcode='T0009232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3011000',harga_beli ='3011000' WHERE kode_barcode='T0009460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2316000',harga_beli ='2316000' WHERE kode_barcode='T0010055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2818000',harga_beli ='2818000' WHERE kode_barcode='T0010054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1119500',harga_beli ='1119500' WHERE kode_barcode='T0014657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1197000',harga_beli ='1197000' WHERE kode_barcode='T0014659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1197000',harga_beli ='1197000' WHERE kode_barcode='T0014661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2818000',harga_beli ='2818000' WHERE kode_barcode='T0014715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2374000',harga_beli ='2374000' WHERE kode_barcode='T0017794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2046000',harga_beli ='2046000' WHERE kode_barcode='T0017795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7102500',harga_beli ='7102500' WHERE kode_barcode='T0019180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4207500',harga_beli ='4207500' WHERE kode_barcode='T0019181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3049500',harga_beli ='3049500' WHERE kode_barcode='T0006407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2181000',harga_beli ='2181000' WHERE kode_barcode='T0013667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1640500',harga_beli ='1640500' WHERE kode_barcode='T0020102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3416500',harga_beli ='3416500' WHERE kode_barcode='T0022491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2837500',harga_beli ='2837500' WHERE kode_barcode='T0022487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2798500',harga_beli ='2798500' WHERE kode_barcode='T0022713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6272500',harga_beli ='6272500' WHERE kode_barcode='T0023410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3493500',harga_beli ='3493500' WHERE kode_barcode='T0026789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='15633000',harga_beli ='15633000' WHERE kode_barcode='T0027384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='38407000',harga_beli ='38407000' WHERE kode_barcode='T0027884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2277500',harga_beli ='2277500' WHERE kode_barcode='T0029673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2123000',harga_beli ='2123000' WHERE kode_barcode='T0029674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2181000',harga_beli ='2181000' WHERE kode_barcode='T0028822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2509000',harga_beli ='2509000' WHERE kode_barcode='T0031899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3783000',harga_beli ='3783000' WHERE kode_barcode='T0032995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2355000',harga_beli ='2355000' WHERE kode_barcode='T0032983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1737000',harga_beli ='1737000' WHERE kode_barcode='T0033052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7816500',harga_beli ='7816500' WHERE kode_barcode='T0033032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4786500',harga_beli ='4786500' WHERE kode_barcode='T0033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1351000',harga_beli ='1351000' WHERE kode_barcode='T0033647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1660000',harga_beli ='1660000' WHERE kode_barcode='T0034346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3397000',harga_beli ='3397000' WHERE kode_barcode='T0034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9553500',harga_beli ='9553500' WHERE kode_barcode='T0034743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='10847000',harga_beli ='10847000' WHERE kode_barcode='T0034735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1254500',harga_beli ='1254500' WHERE kode_barcode='T0035004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1254500',harga_beli ='1254500' WHERE kode_barcode='T0035014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1119500',harga_beli ='1119500' WHERE kode_barcode='T0035012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1216000',harga_beli ='1216000' WHERE kode_barcode='T0035010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1254500',harga_beli ='1254500' WHERE kode_barcode='T0035005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3320000',harga_beli ='3320000' WHERE kode_barcode='T0035430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2451500',harga_beli ='2451500' WHERE kode_barcode='T0035420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1698500',harga_beli ='1698500' WHERE kode_barcode='T0036248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2991500',harga_beli ='2991500' WHERE kode_barcode='T0036259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='T0037728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3011000',harga_beli ='3011000' WHERE kode_barcode='T0037995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1158000',harga_beli ='1158000' WHERE kode_barcode='T0039318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2567000',harga_beli ='2567000' WHERE kode_barcode='T0039315' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2991500',harga_beli ='2991500' WHERE kode_barcode='T0039621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3725000',harga_beli ='3725000' WHERE kode_barcode='T0040098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5211000',harga_beli ='5211000' WHERE kode_barcode='T0040632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7353500',harga_beli ='7353500' WHERE kode_barcode='T0040639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2046000',harga_beli ='2046000' WHERE kode_barcode='T0040631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7566000',harga_beli ='7566000' WHERE kode_barcode='T0041178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3030500',harga_beli ='3030500' WHERE kode_barcode='T0041170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2856500',harga_beli ='2856500' WHERE kode_barcode='T0041152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5018000',harga_beli ='5018000' WHERE kode_barcode='T0041163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3609500',harga_beli ='3609500' WHERE kode_barcode='T0041154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7681500',harga_beli ='7681500' WHERE kode_barcode='T0041182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4246000',harga_beli ='4246000' WHERE kode_barcode='T0041651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7585000',harga_beli ='7585000' WHERE kode_barcode='T0041681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1274000',harga_beli ='1274000' WHERE kode_barcode='T0042067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1254500',harga_beli ='1254500' WHERE kode_barcode='T0042068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1312500',harga_beli ='1312500' WHERE kode_barcode='T0042069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3667000',harga_beli ='3667000' WHERE kode_barcode='T0042203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4748000',harga_beli ='4748000' WHERE kode_barcode='T0042202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4207500',harga_beli ='4207500' WHERE kode_barcode='T0042199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2162000',harga_beli ='2162000' WHERE kode_barcode='T0042196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5616500',harga_beli ='5616500' WHERE kode_barcode='T0042192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2470500',harga_beli ='2470500' WHERE kode_barcode='T0042191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1583000',harga_beli ='1583000' WHERE kode_barcode='T0042186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2065500',harga_beli ='2065500' WHERE kode_barcode='T0042185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='13317000',harga_beli ='13317000' WHERE kode_barcode='T0042180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='13066500',harga_beli ='13066500' WHERE kode_barcode='T0042179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3763500',harga_beli ='3763500' WHERE kode_barcode='T0042177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9669500',harga_beli ='9669500' WHERE kode_barcode='T0067270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1640500',harga_beli ='1640500' WHERE kode_barcode='T0042537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1969000',harga_beli ='1969000' WHERE kode_barcode='T0042542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5404000',harga_beli ='5404000' WHERE kode_barcode='T0042530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3435500',harga_beli ='3435500' WHERE kode_barcode='T0042524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3049500',harga_beli ='3049500' WHERE kode_barcode='T0042514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19165000',harga_beli ='19165000' WHERE kode_barcode='T0067271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2412500',harga_beli ='2412500' WHERE kode_barcode='T0043098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3107500',harga_beli ='3107500' WHERE kode_barcode='T0043121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5500500',harga_beli ='5500500' WHERE kode_barcode='T0043107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5809500',harga_beli ='5809500' WHERE kode_barcode='T0043147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3281000',harga_beli ='3281000' WHERE kode_barcode='T0043628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4864000',harga_beli ='4864000' WHERE kode_barcode='T0043629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6079500',harga_beli ='6079500' WHERE kode_barcode='T0043721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5944500',harga_beli ='5944500' WHERE kode_barcode='T0044041' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3088000',harga_beli ='3088000' WHERE kode_barcode='T0044045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1949500',harga_beli ='1949500' WHERE kode_barcode='T0044166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7044500',harga_beli ='7044500' WHERE kode_barcode='T0044286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3011000',harga_beli ='3011000' WHERE kode_barcode='T0044278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5597000',harga_beli ='5597000' WHERE kode_barcode='T0044276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4053000',harga_beli ='4053000' WHERE kode_barcode='T0044274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9939500',harga_beli ='9939500' WHERE kode_barcode='T0044545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4497000',harga_beli ='4497000' WHERE kode_barcode='T0044564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1254500',harga_beli ='1254500' WHERE kode_barcode='T0045115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2046000',harga_beli ='2046000' WHERE kode_barcode='T0045117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2470500',harga_beli ='2470500' WHERE kode_barcode='T0045354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2162000',harga_beli ='2162000' WHERE kode_barcode='T0045355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2798500',harga_beli ='2798500' WHERE kode_barcode='T0045362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6002500',harga_beli ='6002500' WHERE kode_barcode='T0045384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4265500',harga_beli ='4265500' WHERE kode_barcode='T0045378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2470500',harga_beli ='2470500' WHERE kode_barcode='T0045367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2509000',harga_beli ='2509000' WHERE kode_barcode='T0045366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4304000',harga_beli ='4304000' WHERE kode_barcode='T0044947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4825000',harga_beli ='4825000' WHERE kode_barcode='T0045389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3320000',harga_beli ='3320000' WHERE kode_barcode='T0046089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5114500',harga_beli ='5114500' WHERE kode_barcode='T0046090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1447500',harga_beli ='1447500' WHERE kode_barcode='T0046370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1949500',harga_beli ='1949500' WHERE kode_barcode='T0047393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4304000',harga_beli ='4304000' WHERE kode_barcode='T0047396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1254500',harga_beli ='1254500' WHERE kode_barcode='T0047398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5230500',harga_beli ='5230500' WHERE kode_barcode='T0047416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4883000',harga_beli ='4883000' WHERE kode_barcode='T0047427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2219500',harga_beli ='2219500' WHERE kode_barcode='T0047423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0047418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4767500',harga_beli ='4767500' WHERE kode_barcode='T0047417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4092000',harga_beli ='4092000' WHERE kode_barcode='T0047414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3879500',harga_beli ='3879500' WHERE kode_barcode='T0047409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4632000',harga_beli ='4632000' WHERE kode_barcode='T0047408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='13240000',harga_beli ='13240000' WHERE kode_barcode='T0047429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5057000',harga_beli ='5057000' WHERE kode_barcode='T0047434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5693500',harga_beli ='5693500' WHERE kode_barcode='T0047436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2026500',harga_beli ='2026500' WHERE kode_barcode='T0048345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0048740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1833500',harga_beli ='1833500' WHERE kode_barcode='T0048741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='830000',harga_beli ='830000' WHERE kode_barcode='T0048987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1004000',harga_beli ='1004000' WHERE kode_barcode='T0049666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4381500',harga_beli ='4381500' WHERE kode_barcode='T0049688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3957000',harga_beli ='3957000' WHERE kode_barcode='T0049690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1409000',harga_beli ='1409000' WHERE kode_barcode='T0049701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1505500',harga_beli ='1505500' WHERE kode_barcode='T0049702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3957000',harga_beli ='3957000' WHERE kode_barcode='T0049674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4014500',harga_beli ='4014500' WHERE kode_barcode='T0049677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3416500',harga_beli ='3416500' WHERE kode_barcode='T0049686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9573000',harga_beli ='9573000' WHERE kode_barcode='T0049707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='8395500',harga_beli ='8395500' WHERE kode_barcode='T0049711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1853000',harga_beli ='1853000' WHERE kode_barcode='T0050453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3088000',harga_beli ='3088000' WHERE kode_barcode='T0050454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2837500',harga_beli ='2837500' WHERE kode_barcode='T0050457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2239000',harga_beli ='2239000' WHERE kode_barcode='T0050487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1640500',harga_beli ='1640500' WHERE kode_barcode='T0050486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3802500',harga_beli ='3802500' WHERE kode_barcode='T0050483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3377500',harga_beli ='3377500' WHERE kode_barcode='T0050482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3995500',harga_beli ='3995500' WHERE kode_barcode='T0050479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2219500',harga_beli ='2219500' WHERE kode_barcode='T0050478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2026500',harga_beli ='2026500' WHERE kode_barcode='T0050491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6002500',harga_beli ='6002500' WHERE kode_barcode='T0050492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2162000',harga_beli ='2162000' WHERE kode_barcode='T0050822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3397000',harga_beli ='3397000' WHERE kode_barcode='T0050826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3204000',harga_beli ='3204000' WHERE kode_barcode='T0051688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1312500',harga_beli ='1312500' WHERE kode_barcode='T0051691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2026500',harga_beli ='2026500' WHERE kode_barcode='T0051693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2605500',harga_beli ='2605500' WHERE kode_barcode='T0051694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3204000',harga_beli ='3204000' WHERE kode_barcode='T0051704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4535500',harga_beli ='4535500' WHERE kode_barcode='T0051735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0051741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='T0051742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3899000',harga_beli ='3899000' WHERE kode_barcode='T0051747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3590000',harga_beli ='3590000' WHERE kode_barcode='T0051719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6215000',harga_beli ='6215000' WHERE kode_barcode='T0051710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='10152000',harga_beli ='10152000' WHERE kode_barcode='T0051712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4246000',harga_beli ='4246000' WHERE kode_barcode='T0051714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4555000',harga_beli ='4555000' WHERE kode_barcode='T0051716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='23295500',harga_beli ='23295500' WHERE kode_barcode='T0051757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5153500',harga_beli ='5153500' WHERE kode_barcode='T0051760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5597000',harga_beli ='5597000' WHERE kode_barcode='T0051764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3957000',harga_beli ='3957000' WHERE kode_barcode='T0052826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2470500',harga_beli ='2470500' WHERE kode_barcode='T0052834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19339000',harga_beli ='19339000' WHERE kode_barcode='T0052839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3976000',harga_beli ='3976000' WHERE kode_barcode='T0052914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1988000',harga_beli ='1988000' WHERE kode_barcode='T0052917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1795000',harga_beli ='1795000' WHERE kode_barcode='T0052918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1004000',harga_beli ='1004000' WHERE kode_barcode='T0052920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5018000',harga_beli ='5018000' WHERE kode_barcode='T0052937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0052935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6658500',harga_beli ='6658500' WHERE kode_barcode='T0052925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2991500',harga_beli ='2991500' WHERE kode_barcode='T0052943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='8222000',harga_beli ='8222000' WHERE kode_barcode='T0052950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6369000',harga_beli ='6369000' WHERE kode_barcode='T0052951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1544000',harga_beli ='1544000' WHERE kode_barcode='T0054111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='38832000',harga_beli ='38832000' WHERE kode_barcode='T0054235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1467000',harga_beli ='1467000' WHERE kode_barcode='T0054302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1312500',harga_beli ='1312500' WHERE kode_barcode='T0054306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='T0054305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2355000',harga_beli ='2355000' WHERE kode_barcode='T0054307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4111000',harga_beli ='4111000' WHERE kode_barcode='T0054341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3899000',harga_beli ='3899000' WHERE kode_barcode='T0054340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='16694500',harga_beli ='16694500' WHERE kode_barcode='T0054337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2065500',harga_beli ='2065500' WHERE kode_barcode='T0054335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0054327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2702000',harga_beli ='2702000' WHERE kode_barcode='T0054322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5423500',harga_beli ='5423500' WHERE kode_barcode='T0054318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7527000',harga_beli ='7527000' WHERE kode_barcode='T0054359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5655000',harga_beli ='5655000' WHERE kode_barcode='T0054357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='T0056273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3377500',harga_beli ='3377500' WHERE kode_barcode='T0056286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2123000',harga_beli ='2123000' WHERE kode_barcode='T0056289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='T0056293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2316000',harga_beli ='2316000' WHERE kode_barcode='T0056294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3995500',harga_beli ='3995500' WHERE kode_barcode='T0056296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='38272000',harga_beli ='38272000' WHERE kode_barcode='T0056306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1061500',harga_beli ='1061500' WHERE kode_barcode='T0056710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4825000',harga_beli ='4825000' WHERE kode_barcode='T0056722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='38793000',harga_beli ='38793000' WHERE kode_barcode='T0056723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2046000',harga_beli ='2046000' WHERE kode_barcode='T0057085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4111000',harga_beli ='4111000' WHERE kode_barcode='T0057088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3570500',harga_beli ='3570500' WHERE kode_barcode='T0057099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2856500',harga_beli ='2856500' WHERE kode_barcode='T0057100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1640500',harga_beli ='1640500' WHERE kode_barcode='T0057101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2798500',harga_beli ='2798500' WHERE kode_barcode='T0057121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4941000',harga_beli ='4941000' WHERE kode_barcode='T0057123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2605500',harga_beli ='2605500' WHERE kode_barcode='T0057133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3107500',harga_beli ='3107500' WHERE kode_barcode='T0057136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3821500',harga_beli ='3821500' WHERE kode_barcode='T0057112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0057106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1293500',harga_beli ='1293500' WHERE kode_barcode='T0057107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2258500',harga_beli ='2258500' WHERE kode_barcode='T0057108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0057103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1795000',harga_beli ='1795000' WHERE kode_barcode='T0059333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2084500',harga_beli ='2084500' WHERE kode_barcode='T0059334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2065500',harga_beli ='2065500' WHERE kode_barcode='T0059376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1776000',harga_beli ='1776000' WHERE kode_barcode='T0059495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2162000',harga_beli ='2162000' WHERE kode_barcode='T0059500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5114500',harga_beli ='5114500' WHERE kode_barcode='T0059520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3377500',harga_beli ='3377500' WHERE kode_barcode='T0059519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3570500',harga_beli ='3570500' WHERE kode_barcode='T0059507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3493500',harga_beli ='3493500' WHERE kode_barcode='T0059506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5500500',harga_beli ='5500500' WHERE kode_barcode='T0059503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4979500',harga_beli ='4979500' WHERE kode_barcode='T0059502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='T0059527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1158000',harga_beli ='1158000' WHERE kode_barcode='T0071232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9997500',harga_beli ='9997500' WHERE kode_barcode='T0063031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7006000',harga_beli ='7006000' WHERE kode_barcode='T0063022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0071236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2856500',harga_beli ='2856500' WHERE kode_barcode='T0071237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7469500',harga_beli ='7469500' WHERE kode_barcode='T0065472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6523500',harga_beli ='6523500' WHERE kode_barcode='T0065473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0068753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3802500',harga_beli ='3802500' WHERE kode_barcode='T0068741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1158000',harga_beli ='1158000' WHERE kode_barcode='T0069499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1100500',harga_beli ='1100500' WHERE kode_barcode='T0070509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19744000',harga_beli ='19744000' WHERE kode_barcode='T0070514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9843000',harga_beli ='9843000' WHERE kode_barcode='T0072100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1081000',harga_beli ='1081000' WHERE kode_barcode='T0072977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5867500',harga_beli ='5867500' WHERE kode_barcode='T0072634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='868500',harga_beli ='868500' WHERE kode_barcode='T0072975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1061500',harga_beli ='1061500' WHERE kode_barcode='T0072976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7971000',harga_beli ='7971000' WHERE kode_barcode='T0074493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1100500',harga_beli ='1100500' WHERE kode_barcode='T0074484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1332000',harga_beli ='1332000' WHERE kode_barcode='T0075755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='10132500',harga_beli ='10132500' WHERE kode_barcode='T0075767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19300000',harga_beli ='19300000' WHERE kode_barcode='T0076239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1061500',harga_beli ='1061500' WHERE kode_barcode='T0072896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3706000',harga_beli ='3706000' WHERE kode_barcode='T0075727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1100500',harga_beli ='1100500' WHERE kode_barcode='T0078278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='11792500',harga_beli ='11792500' WHERE kode_barcode='T0078284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4979500',harga_beli ='4979500' WHERE kode_barcode='T0078283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19512500',harga_beli ='19512500' WHERE kode_barcode='T0078285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19319500',harga_beli ='19319500' WHERE kode_barcode='T0078282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='830000',harga_beli ='830000' WHERE kode_barcode='T0078494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1254500',harga_beli ='1254500' WHERE kode_barcode='T0078495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7913500',harga_beli ='7913500' WHERE kode_barcode='T0078498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1004000',harga_beli ='1004000' WHERE kode_barcode='T0079714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='984500',harga_beli ='984500' WHERE kode_barcode='T0079716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1100500',harga_beli ='1100500' WHERE kode_barcode='T0079717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6794000',harga_beli ='6794000' WHERE kode_barcode='T0079727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1119500',harga_beli ='1119500' WHERE kode_barcode='T0080403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='4169000',harga_beli ='4169000' WHERE kode_barcode='T0080404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0079775' LIMIT 1;
UPDATE tm_group SET harga='1930000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','1930000','input','2026-07-06 14:19:56');
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5187000',harga_beli ='5187000' WHERE kode_barcode='T0027903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='916500',harga_beli ='916500' WHERE kode_barcode='T0027962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='3959000',harga_beli ='3959000' WHERE kode_barcode='T0025250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4875000',harga_beli ='4875000' WHERE kode_barcode='T0025240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5947500',harga_beli ='5947500' WHERE kode_barcode='T0002681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5791500',harga_beli ='5791500' WHERE kode_barcode='T0002680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4290000',harga_beli ='4290000' WHERE kode_barcode='T0002702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5986500',harga_beli ='5986500' WHERE kode_barcode='T0002545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5265000',harga_beli ='5265000' WHERE kode_barcode='T0003215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4836000',harga_beli ='4836000' WHERE kode_barcode='T0003578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2437500',harga_beli ='2437500' WHERE kode_barcode='T0029910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='3237000',harga_beli ='3237000' WHERE kode_barcode='T0003883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='9672000',harga_beli ='9672000' WHERE kode_barcode='T0006181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='6298500',harga_beli ='6298500' WHERE kode_barcode='T0009249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1170000',harga_beli ='1170000' WHERE kode_barcode='T0062967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2340000',harga_beli ='2340000' WHERE kode_barcode='T0029909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='29191500',harga_beli ='29191500' WHERE kode_barcode='T0014667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='13279500',harga_beli ='13279500' WHERE kode_barcode='T0014724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='8015000',harga_beli ='8015000' WHERE kode_barcode='T0001396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1560000',harga_beli ='1560000' WHERE kode_barcode='T0022496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='994500',harga_beli ='994500' WHERE kode_barcode='T0022495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5401500',harga_beli ='5401500' WHERE kode_barcode='T0022928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4115000',harga_beli ='4115000' WHERE kode_barcode='T0023426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='8385000',harga_beli ='8385000' WHERE kode_barcode='T0023442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2788500',harga_beli ='2788500' WHERE kode_barcode='T0001914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='975000',harga_beli ='975000' WHERE kode_barcode='T0026797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4095000',harga_beli ='4095000' WHERE kode_barcode='T0026857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5908500',harga_beli ='5908500' WHERE kode_barcode='T0026861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1267500',harga_beli ='1267500' WHERE kode_barcode='T0029908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='29250000',harga_beli ='29250000' WHERE kode_barcode='T0029659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4134000',harga_beli ='4134000' WHERE kode_barcode='T0029880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='15736500',harga_beli ='15736500' WHERE kode_barcode='T0002012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='15405000',harga_beli ='15405000' WHERE kode_barcode='T0023388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='9964500',harga_beli ='9964500' WHERE kode_barcode='T0032844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2847000',harga_beli ='2847000' WHERE kode_barcode='T0032978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='6064500',harga_beli ='6064500' WHERE kode_barcode='T0033642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5382000',harga_beli ='5382000' WHERE kode_barcode='T0034358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='3802500',harga_beli ='3802500' WHERE kode_barcode='T0034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='7663500',harga_beli ='7663500' WHERE kode_barcode='T0034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2944500',harga_beli ='2944500' WHERE kode_barcode='T0034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1462500',harga_beli ='1462500' WHERE kode_barcode='T0034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='19129500',harga_beli ='19129500' WHERE kode_barcode='T0036272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1111500',harga_beli ='1111500' WHERE kode_barcode='T0036773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1657500',harga_beli ='1657500' WHERE kode_barcode='T0036774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='T0037911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1950000',harga_beli ='1950000' WHERE kode_barcode='T0038821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1696500',harga_beli ='1696500' WHERE kode_barcode='T0038822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4426500',harga_beli ='4426500' WHERE kode_barcode='T0038800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='916500',harga_beli ='916500' WHERE kode_barcode='T0038825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='13806000',harga_beli ='13806000' WHERE kode_barcode='T0040117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='9945000',harga_beli ='9945000' WHERE kode_barcode='T0040118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5479500',harga_beli ='5479500' WHERE kode_barcode='T0040627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4192500',harga_beli ='4192500' WHERE kode_barcode='T0041161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2847000',harga_beli ='2847000' WHERE kode_barcode='T0041674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4056000',harga_beli ='4056000' WHERE kode_barcode='T0041675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='19792500',harga_beli ='19792500' WHERE kode_barcode='T0041931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='T0042204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2944500',harga_beli ='2944500' WHERE kode_barcode='T0042533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1170000',harga_beli ='1170000' WHERE kode_barcode='T0043133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5733000',harga_beli ='5733000' WHERE kode_barcode='T0043381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1131000',harga_beli ='1131000' WHERE kode_barcode='T0044092' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2145000',harga_beli ='2145000' WHERE kode_barcode='T0044157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1267500',harga_beli ='1267500' WHERE kode_barcode='T0044158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5070000',harga_beli ='5070000' WHERE kode_barcode='T0045278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='9984000',harga_beli ='9984000' WHERE kode_barcode='T0045290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1072500',harga_beli ='1072500' WHERE kode_barcode='T0045374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='975000',harga_beli ='975000' WHERE kode_barcode='T0045369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5947500',harga_beli ='5947500' WHERE kode_barcode='T0047431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='6825000',harga_beli ='6825000' WHERE kode_barcode='T0047440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2632500',harga_beli ='2632500' WHERE kode_barcode='T0048974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2476500',harga_beli ='2476500' WHERE kode_barcode='T0049662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5752500',harga_beli ='5752500' WHERE kode_barcode='T0049721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='3959000',harga_beli ='3959000' WHERE kode_barcode='T0050466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4192500',harga_beli ='4192500' WHERE kode_barcode='T0051696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='994500',harga_beli ='994500' WHERE kode_barcode='T0051697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4095000',harga_beli ='4095000' WHERE kode_barcode='T0051699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1131000',harga_beli ='1131000' WHERE kode_barcode='T0051709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5284500',harga_beli ='5284500' WHERE kode_barcode='T0051773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1794000',harga_beli ='1794000' WHERE kode_barcode='T0052760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1306500',harga_beli ='1306500' WHERE kode_barcode='T0052761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1228500',harga_beli ='1228500' WHERE kode_barcode='T0052762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1423500',harga_beli ='1423500' WHERE kode_barcode='T0052763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='9808500',harga_beli ='9808500' WHERE kode_barcode='T0052845' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2632500',harga_beli ='2632500' WHERE kode_barcode='T0052910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1969500',harga_beli ='1969500' WHERE kode_barcode='T0052919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='4192500',harga_beli ='4192500' WHERE kode_barcode='T0054370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='6825000',harga_beli ='6825000' WHERE kode_barcode='T0054371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2827500',harga_beli ='2827500' WHERE kode_barcode='T0056798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='2047500',harga_beli ='2047500' WHERE kode_barcode='T0056814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1618500',harga_beli ='1618500' WHERE kode_barcode='T0056815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='7897500',harga_beli ='7897500' WHERE kode_barcode='T0056834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='7663500',harga_beli ='7663500' WHERE kode_barcode='T0057159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='3978000',harga_beli ='3978000' WHERE kode_barcode='T0071234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='T0071230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1423500',harga_beli ='1423500' WHERE kode_barcode='T0059377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='19402500',harga_beli ='19402500' WHERE kode_barcode='T0059529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='975000',harga_beli ='975000' WHERE kode_barcode='T0062988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='11563500',harga_beli ='11563500' WHERE kode_barcode='T0063020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1072500',harga_beli ='1072500' WHERE kode_barcode='T0066579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='5733000',harga_beli ='5733000' WHERE kode_barcode='T0072099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='975000',harga_beli ='975000' WHERE kode_barcode='T0072974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1365000',harga_beli ='1365000' WHERE kode_barcode='T0073763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1072500',harga_beli ='1072500' WHERE kode_barcode='T0074548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1950000',harga_jual='1462500',harga_beli ='1462500' WHERE kode_barcode='T0076232' LIMIT 1;
UPDATE tm_group SET harga='1950000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','1950000','input','2026-07-06 14:20:11');
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='2502000',harga_beli ='2502000' WHERE kode_barcode='T0051751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='6225500',harga_beli ='6225500' WHERE kode_barcode='T0040120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='827500',harga_beli ='827500' WHERE kode_barcode='T0045111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='1379000',harga_beli ='1379000' WHERE kode_barcode='T0045109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='6166500',harga_beli ='6166500' WHERE kode_barcode='T0053759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='1340000',harga_beli ='1340000' WHERE kode_barcode='T0047446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='4728000',harga_beli ='4728000' WHERE kode_barcode='T0048975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='7722500',harga_beli ='7722500' WHERE kode_barcode='T0049718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='6127000',harga_beli ='6127000' WHERE kode_barcode='T0050028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='5733000',harga_beli ='5733000' WHERE kode_barcode='T0050029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='9870000',harga_beli ='9870000' WHERE kode_barcode='T0039646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='8038000',harga_beli ='8038000' WHERE kode_barcode='T0051771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='985000',harga_beli ='985000' WHERE kode_barcode='T0060275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='9968500',harga_beli ='9968500' WHERE kode_barcode='T0063024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='4058500',harga_beli ='4058500' WHERE kode_barcode='T0063019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='5043500',harga_beli ='5043500' WHERE kode_barcode='T0066778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='512500',harga_beli ='512500' WHERE kode_barcode='T0072971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='7821000',harga_beli ='7821000' WHERE kode_barcode='T0033666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='5378500',harga_beli ='5378500' WHERE kode_barcode='T0065141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='2049000',harga_beli ='2049000' WHERE kode_barcode='T0078277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='5949500',harga_beli ='5949500' WHERE kode_barcode='T0033040' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='4039000',harga_beli ='4039000' WHERE kode_barcode='T0026463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='709500',harga_beli ='709500' WHERE kode_barcode='T0062982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='6028500',harga_beli ='6028500' WHERE kode_barcode='T0001778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='5063000',harga_beli ='5063000' WHERE kode_barcode='T0009257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='4629500',harga_beli ='4629500' WHERE kode_barcode='T0012680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='5634500',harga_beli ='5634500' WHERE kode_barcode='T0027564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='9259000',harga_beli ='9259000' WHERE kode_barcode='T0029906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='6836000',harga_beli ='6836000' WHERE kode_barcode='T0031229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='13790000',harga_beli ='13790000' WHERE kode_barcode='T0033026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='15563000',harga_beli ='15563000' WHERE kode_barcode='T0002535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='4866000',harga_beli ='4866000' WHERE kode_barcode='T0033038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='15957000',harga_beli ='15957000' WHERE kode_barcode='T0033027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='10086500',harga_beli ='10086500' WHERE kode_barcode='T0033650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='23463000',harga_beli ='23463000' WHERE kode_barcode='T0001409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='827500',harga_beli ='827500' WHERE kode_barcode='T0029798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='15661500',harga_beli ='15661500' WHERE kode_barcode='T0035449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='4235500',harga_beli ='4235500' WHERE kode_barcode='T0037440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='19739500',harga_beli ='19739500' WHERE kode_barcode='T0038811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1970000',harga_jual='7387500',harga_beli ='7387500' WHERE kode_barcode='T0039636' LIMIT 1;
UPDATE tm_group SET harga='1970000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','1970000','input','2026-07-06 14:20:23');
UPDATE tm_group SET harga='1990000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','1990000','input','2026-07-06 14:22:18');
UPDATE tm_barang SET harga_skrg ='2010000',harga_jual='4281500',harga_beli ='4281500' WHERE kode_barcode='T0078275' LIMIT 1;
UPDATE tm_group SET harga='2010000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','2010000','input','2026-07-06 14:22:25');
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 ('F326060228151','kasir','1',' MEH1E KH 4','TOKO','PM-H','H1E-ZFAI-115-0','KL JEDAR VAR MATA SLEP KH 42 8K ','','1.900','1','100.00','2014000','0','0','15000','2015000','0','0','0','2015000','LIS','00409420','H1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAI-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='H1E-ZFAI-115-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 ('F326060228151','2026-07-06','1.900','2026-07-06','14:28:16','PLG0030175','2015000','2015000','0','2015000','2015000','kasir','2026-07-06 14:28:15','F32606022815');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060228151','2026-07-06','14:28:16','LIS','2015000','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-260706-0025','D','2026-07-06','14:28:16','kasir','PENJUALAN','F326060228151','6172056000','2015000','6174071000');
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 ('F326060237551','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZFAG-78-0','KL X NORY KH 44 8K ','','4.020','1','100.00','4261000','0','0','15000','4260000','0','0','0','4260000','AAT','00408901','H1E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAG-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='H1E-ZFAG-78-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 ('F326060237551','2026-07-06','4.020','2026-07-06','14:37:56','PLG0030176','4260000','4260000','0','4260000','4260000','kasir','2026-07-06 14:37:55','F32606023755');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060237551','2026-07-06','14:37:56','AAT','4260000','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-260706-0026','D','2026-07-06','14:37:56','kasir','PENJUALAN','F326060237551','6174071000','4260000','6178331000');
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 ('F326060255491','input','1',' MEF2 X YT ','TOKO','PM-F','F2E-ZFXH-22-0','GL X OVAL MATA YT 56 8K ','OLW','2.120','1','100.00','2247000','0','0','15000','2260000','0','10000','0','2270000','SIN','00407883','F2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFXH-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='F2E-ZFXH-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060255491','2026-07-06','2.120','2026-07-06','14:55:50','PLG0030177','2260000','2260000','10000','2270000','0','input','2026-07-06 14:55:49','F32606025549');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060255491','2026-07-06','14:55:50','SIN','2270000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260706-0001','2026-07-06','2026-07-06 14:55:49','PENJUALAN : F326060255491','23456','BCA','2270000','2270000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260706-0002','D','2026-07-06','14:55:50','BCA','PENJUALAN','F326060255491','732522000','2270000','734792000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('23456','234567');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2270000' WHERE no_faktur_jual='F326060255491' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060256441','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZDXD-159-0','GL X SANTA HATI VAR HW 8K ','OLW','1.550','1','100.00','1643000','0','0','15000','1650000','0','10000','0','1660000','SIN','00397859','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXD-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='F3E-ZDXD-159-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060256441','2026-07-06','1.550','2026-07-06','14:56:45','PLG0030178','1650000','1650000','10000','1660000','0','input','2026-07-06 14:56:44','F32606025644');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060256441','2026-07-06','14:56:45','SIN','1660000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260706-0002','2026-07-06','2026-07-06 14:56:44','PENJUALAN : F326060256441','234567','BCA','1660000','1660000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260706-0003','D','2026-07-06','14:56:45','BCA','PENJUALAN','F326060256441','734792000','1660000','736452000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('234567','2345678');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060256441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060256441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060256441';
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 ('F326060259521','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZDXD-159-0','GL X SANTA HATI VAR HW 8K ','OLW','1.550','1','100.00','1643000','0','0','15000','1650000','0','10000','0','1660000','SIN','00397859','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXD-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='F3E-ZDXD-159-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060259521','2026-07-06','1.550','2026-07-06','14:59:52','PLG0030179','1650000','1650000','10000','1660000','0','kasir','2026-07-06 14:59:52','F32606025952');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060259521','2026-07-06','14:59:52','SIN','1660000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260706-0003','2026-07-06','2026-07-06 14:59:52','PENJUALAN : F326060259521','IUYWUYFHIFEU9I','BCA','1660000','1660000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260706-0004','D','2026-07-06','14:59:52','BCA','PENJUALAN','F326060259521','736452000','1660000','738112000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('IUYWUYFHIFEU9I','87RO3UFY3YUG3I7');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1660000' WHERE no_faktur_jual='F326060259521' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060300371','kasir','1',' MEE2 X YT ','TOKO','PM-E','E2E-YEAI-238-0','CC X MODEL MATA YT 14 8K ','OLW','0.530','1','100.00','562000','0','0','15000','568000','0','5000','0','573000','SIN','00354722','E2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YEAI-238-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-06' AND kode_barang='E2E-YEAI-238-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060300371','2026-07-06','0.530','2026-07-06','15:00:37','PLG0030180','568000','568000','5000','573000','0','kasir','2026-07-06 15:00:37','F32606030037');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-06','F326060300371','2026-07-06','15:00:37','SIN','573000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260706-0004','2026-07-06','2026-07-06 15:00:37','PENJUALAN : F326060300371','UI6U77O876IYGH','BCA','573000','573000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260706-0005','D','2026-07-06','15:00:37','BCA','PENJUALAN','F326060300371','738112000','573000','738685000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('UI6U77O876IYGH','O866RJHYI78I');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='573000' WHERE no_faktur_jual='F326060300371' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060126351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060126351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060126351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060210081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060210081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060210081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060210082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060210082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060210082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060228151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060228151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060228151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060237551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060237551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060237551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060255491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060255491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060255491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060259521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060259521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060259521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060300371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060300371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060300371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060857171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060857171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060857171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060928261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060928261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060928261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060928262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060928262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060928262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060942061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060942061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060942061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061015551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061015551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061015551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061015552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061015552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061015552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061050171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061050171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061050171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061050172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061050172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061050172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061105551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061105551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061105551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061129101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061129101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061129101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061129102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061129102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061129102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061132451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061132451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061132451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061133331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061133331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061133331';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260706-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260706-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260706-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260706-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260706-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260706-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260706-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260706-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260706-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260706-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260706-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260706-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260706-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260706-0007';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-06';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-06' 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-260707-0001','D','2026-07-07','15:36:44','SYSTEM','SALDO AWAL','SALDO AWAL','0','6178331000','6178331000');
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-260707-0001','D','2026-07-07','15:36:44','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
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-260707-0001','D','2026-07-07','15:36:44','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-260707-0001','D','2026-07-07','15:36:44','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-07';