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 ('F326290935491','input','1',' MEF2 X PM ','TOKO','PM-F','F2E-ZDXD-10-0','GL X PIPA MATA PM 56 8K ','','3.980','1','100.00','4239000','0','0','15000','4240000','0','0','0','4240000','FIT','00397710','F2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZDXD-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.980',berat_jual_asli=berat_jual_asli+'3.980',stock_jual='1',berat_akhir=berat_akhir-'3.980',berat_akhir_asli=berat_akhir_asli-'3.980',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='F2E-ZDXD-10-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 ('F326290935491','2026-06-29','3.980','2026-06-29','09:35:49','PLG0030042','4240000','4240000','0','4240000','4240000','input','2026-06-29 09:35:49','F32629093549');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290935491','2026-06-29','09:35:49','FIT','4240000','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-260629-0002','D','2026-06-29','09:35:49','input','PENJUALAN','F326290935491','6020296000','4240000','6024536000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4240000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326290935491' 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 ('F326290935492','input',' 1',' MEF1 X PM ','TOKO','PM-F','F1E-ZFAG-50-0','GL X OVAL DAUN SLEP PM 54 8K ','','4.950','1','100.00','5272000','0','0','15000','5272000','0','0','0','5272000','FIT','00408873','F1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFAG-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='F1E-ZFAG-50-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 ('F326290935492','2026-06-29','4.950','2026-06-29','09:35:49','PLG0030043','5272000','5272000','0','5272000','5272000','input','2026-06-29 09:35:49','F32629093549');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290935492','2026-06-29','09:35:49','FIT','5272000','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-260629-0003','D','2026-06-29','09:35:49','input','PENJUALAN','F326290935492','6024536000','5272000','6029808000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5272000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326290935492' 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 ('F326290935493','input',' 1',' MDE1 PM 10','TOKO','PM-E','E1D-ZDAC-109-0','CC MODEL DAUN VAR PM 10 8K ','','1.030','1','100.00','1076000','0','0','15000','1076000','0','0','0','1076000','FIT','00399279','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAC-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1D-ZDAC-109-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 ('F326290935493','2026-06-29','1.030','2026-06-29','09:35:49','PLG0030044','1076000','1076000','0','1076000','1076000','input','2026-06-29 09:35:49','F32629093549');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290935493','2026-06-29','09:35:49','FIT','1076000','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-260629-0004','D','2026-06-29','09:35:49','input','PENJUALAN','F326290935493','6029808000','1076000','6030884000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1076000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326290935493' 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-00019504','X-00019504','CC X MODEL DAUN SLEP UB 16 8K','GR','---','E1D','BELI','BELI001','897000','2026-06-29','0.960','1','kasir','2026-06-29 10:58:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019504','X-00019504');
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-260629-0001','F325171001231','SIN','1','BELI','BELI001','E1D', 'X-00019504', 'CC X MODEL DAUN SLEP UB 16 8K','0.960','0.960','100.00','965000','897000','934375','1045000','1','897000','897000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260629-0001','2026-06-29','2026-06-29','10:58:08','SIN','---','0.960','897000','897000','897000','897000','897000','kasir','2026-06-29 10:58:09','FB-260629-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0001','NURI','BULUKERTO','','','','kasir','2026-06-29 10:58:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0005','K','2026-06-29','10:58:08','kasir','PEMBELIAN UMUM','FB-260629-0001','6030884000','897000','6029987000');
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-00019505','X-00019505','GL HARLEY MODEL DAUN VAR HW 8K','GR','---','F3E','BELI','BELI001','1810000','2026-06-29','1.830','1','kasir','2026-06-29 10:59:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019505','X-00019505');
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-260629-0002','F326030849111','SIN','1','BELI','BELI001','F3E', 'X-00019505', 'GL HARLEY MODEL DAUN VAR HW 8K','1.830','1.830','100.00','2123000','1810000','989071','1075000','1','1810000','1810000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.830',berat_beli_asli=berat_beli_asli+'1.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.830',berat_akhir_asli=berat_akhir_asli+'1.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260629-0002','2026-06-29','2026-06-29','10:59:40','SIN','---','1.830','1810000','1810000','1810000','1810000','1810000','kasir','2026-06-29 10:59:41','FB-260629-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0002','TULUS','TINASAT KISMANTORO','','','081383945546','kasir','2026-06-29 10:59:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0006','K','2026-06-29','10:59:40','kasir','PEMBELIAN UMUM','FB-260629-0002','6029987000','1810000','6028177000');
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-00019506','X-00019506','GL XXX OVAL C GELOMBANG TD 60 8K','GR','---','F1E','BELI','BELI001','2887000','2026-06-29','2.920','1','kasir','2026-06-29 12:59:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019506','X-00019506');
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-260629-0003','F326181133051','AAT','1','BELI','BELI001','F1E', 'X-00019506', 'GL XXX OVAL C GELOMBANG TD 60 8K','2.920','2.920','100.00','3373000','2887000','988699','1075000','1','2887000','2887000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.920',berat_beli_asli=berat_beli_asli+'2.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.920',berat_akhir_asli=berat_akhir_asli+'2.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' 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-260629-0003','2026-06-29','2026-06-29','12:59:57','AAT','---','2.920','2887000','2887000','2887000','2887000','2887000','kasir','2026-06-29 12:59:57','FB-260629-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0003','ROSI','JERUK','','','','kasir','2026-06-29 12:59:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0007','K','2026-06-29','12:59:57','kasir','PEMBELIAN UMUM','FB-260629-0003','6028177000','2887000','6025290000');
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-00019507','X-00019507','GL ANAK MODEL C GELOMBANG YT D40 8K','GR','---','F1E','BELI','BELI001','2170000','2026-06-29','2.880','1','kasir','2026-06-29 12:59:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019507','X-00019507');
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-260629-0004','F325250203233','AAT','2','BELI','BELI001','F1E', 'X-00019507', 'GL ANAK MODEL C GELOMBANG YT D40 8K','2.900','2.880','100.00','2436000','2170000','753472','1075000','1','2170000','2170000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.880',berat_beli_asli=berat_beli_asli+'2.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.880',berat_akhir_asli=berat_akhir_asli+'2.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' 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-260629-0004','2026-06-29','2026-06-29','12:59:57','AAT','---','2.880','2170000','2170000','2170000','2170000','2170000','kasir','2026-06-29 12:59:57','FB-260629-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0004','DENA','JERUK','','','087757332105','kasir','2026-06-29 12:59:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0008','K','2026-06-29','12:59:57','kasir','PEMBELIAN UMUM','FB-260629-0004','6025290000','2170000','6023120000');
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 ('F326290101191','kasir','1',' MDE1D HW 1','TOKO','PM-E','E1D-ZFAI-95-0','CC MODEL SLEP HW 17 8K ','','1.100','1','100.00','1149000','0','0','15000','1150000','0','0','0','1150000','SIN','00409400','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-95-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-06-29' AND kode_barang='E1D-ZFAI-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 ('F326290101191','2026-06-29','1.100','2026-06-29','13:01:19','PLG0030045','1150000','1150000','0','1150000','1150000','kasir','2026-06-29 13:01:19','F32629010119');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290101191','2026-06-29','13:01:19','SIN','1150000','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-260629-0009','D','2026-06-29','13:01:19','kasir','PENJUALAN','F326290101191','6023120000','1150000','6024270000');
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-06-29 13:09:20');
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-06-29 13:10:11');
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='3030500',harga_beli ='3030500' WHERE kode_barcode='T0033728' 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='7141000',harga_beli ='7141000' WHERE kode_barcode='T0041183' 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='8067500',harga_beli ='8067500' WHERE kode_barcode='T0072988' 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='2991500',harga_beli ='2991500' WHERE kode_barcode='T0050484' 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='1891500',harga_beli ='1891500' WHERE kode_barcode='T0051745' 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='9785500',harga_beli ='9785500' WHERE kode_barcode='T0052841' 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='3532000',harga_beli ='3532000' WHERE kode_barcode='T0056729' 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='5636000',harga_beli ='5636000' WHERE kode_barcode='T0079725' 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-06-29 13:10:19');
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 ('F326290111361','input','1',' MDE2D 10K ','TOKO','PM-E','E2D-ZEBH-119-T','CC WEDDING MATA SLEP CM 18 8K ','','1.560','1','100.00','1630000','0','0','15000','1630000','0','10000','0','1640000','SIN','T0080060','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-119-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E2D-ZEBH-119-T' 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 ('F326290111361','2026-06-29','1.560','2026-06-29','13:11:36','PLG0030046','1630000','1630000','10000','1640000','1640000','input','2026-06-29 13:11:36','F32629011136');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290111361','2026-06-29','13:11:36','SIN','1640000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0010','D','2026-06-29','13:11:36','input','PENJUALAN','F326290111361','6024270000','1640000','6025910000');
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 ('F326290112051','input','1',' MEH1E UB 3','TOKO','PM-H','H1E-ZDXH-23-0','KL ANAK GUCCI UB 34CM 8K ','','1.060','1','100.00','1129000','0','0','15000','1130000','0','0','0','1130000','LIS','00398475','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXH-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='H1E-ZDXH-23-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 ('F326290112051','2026-06-29','1.060','2026-06-29','13:12:06','PLG0030047','1130000','1130000','0','1130000','1130000','input','2026-06-29 13:12:05','F32629011205');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290112051','2026-06-29','13:12:06','LIS','1130000','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-260629-0011','D','2026-06-29','13:12:06','input','PENJUALAN','F326290112051','6025910000','1130000','6027040000');
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='1774500',harga_beli ='1774500' WHERE kode_barcode='T0073762' 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-06-29 13:12:39');
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='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='2502000',harga_beli ='2502000' WHERE kode_barcode='T0051751' 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='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='591000',harga_beli ='591000' WHERE kode_barcode='T0075783' 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-06-29 13:12:49');
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-06-29 13:12:59');
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-06-29 13:13:04');
UPDATE tm_group SET harga='2030000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','2030000','input','2026-06-29 13:13:12');
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 ('F326290129051','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-WEXE-127-0','GL X BANGKOK TIMBUL SLEP UB 54 ','','4.100','1','100.00','4366000','0','0','15000','4365000','0','0','0','4365000','AAT','00230768','F1E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-WEXE-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.100',berat_jual_asli=berat_jual_asli+'4.100',stock_jual='1',berat_akhir=berat_akhir-'4.100',berat_akhir_asli=berat_akhir_asli-'4.100',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='F1E-WEXE-127-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 ('F326290129051','2026-06-29','4.100','2026-06-29','13:29:06','PLG0030048','4365000','4365000','0','4365000','4365000','input','2026-06-29 13:29:05','F32629012905');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290129051','2026-06-29','13:29:06','AAT','4365000','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-260629-0012','D','2026-06-29','13:29:06','input','PENJUALAN','F326290129051','6027040000','4365000','6031405000');
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-00019508','X-00019508','CC MODEL MATA VAR CM 12 8K','GR','---','E2E','BELI','BELI001','387000','2026-06-29','0.610','1','kasir','2026-06-29 14:05:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019508','X-00019508');
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-260629-0005','F324090218192','SIN','1','BELI','BELI001','E2E', 'X-00019508', 'CC MODEL MATA VAR CM 12 8K','0.610','0.610','100.00','370000','387000','634426','1075000','1','387000','387000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.610',berat_beli_asli=berat_beli_asli+'0.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.610',berat_akhir_asli=berat_akhir_asli+'0.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260629-0005','2026-06-29','2026-06-29','14:05:33','SIN','---','0.610','387000','387000','387000','387000','387000','kasir','2026-06-29 14:05:34','FB-260629-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0005','SURYANI','LOROK PACITAN 3/9','','','085203863672','kasir','2026-06-29 14:05:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0013','K','2026-06-29','14:05:33','kasir','PEMBELIAN UMUM','FB-260629-0005','6031405000','387000','6031018000');
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-00019509','X-00019509','CC X MODEL MATA CM 12 8K','GR','---','E2E','BELI','BELI001','775000','2026-06-29','1.150','1','kasir','2026-06-29 14:05:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019509','X-00019509');
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-260629-0006','F324090218193','SIN','2','BELI','BELI001','E2E', 'X-00019509', 'CC X MODEL MATA CM 12 8K','1.150','1.150','100.00','698000','775000','673913','1075000','1','775000','775000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.150',berat_beli_asli=berat_beli_asli+'1.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.150',berat_akhir_asli=berat_akhir_asli+'1.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260629-0006','2026-06-29','2026-06-29','14:05:33','SIN','---','1.150','775000','775000','775000','775000','775000','kasir','2026-06-29 14:05:34','FB-260629-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0006','SURYANI','LOROK PACITAN 3/9','','','085203863672','kasir','2026-06-29 14:05:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0014','K','2026-06-29','14:05:33','kasir','PEMBELIAN UMUM','FB-260629-0006','6031018000','775000','6030243000');
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-00019510','X-00019510','LT X SLOBOK HURUF BG K','GR','---','D1F','BELI','BELI001','425000','2026-06-29','0.620','1','kasir','2026-06-29 14:05:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00019510','X-00019510');
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-260629-0007','F324090218191','SIN','3','BELI','BELI001','D1F', 'X-00019510', 'LT X SLOBOK HURUF BG K','0.620','0.620','100.00','383000','425000','685484','1085000','1','425000','425000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.620',berat_beli_asli=berat_beli_asli+'0.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.620',berat_akhir_asli=berat_akhir_asli+'0.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260629-0007','2026-06-29','2026-06-29','14:05:33','SIN','---','0.620','425000','425000','425000','425000','425000','kasir','2026-06-29 14:05:34','FB-260629-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0007','SURYANI','LOROK PACITAN 3/9','','','085203863672','kasir','2026-06-29 14:05:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0015','K','2026-06-29','14:05:33','kasir','PEMBELIAN UMUM','FB-260629-0007','6030243000','425000','6029818000');
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 ('F326290206511','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-XKAA-29-0','CC X MODEL MATA CM 12 8K ','','1.250','1','100.00','1306000','0','0','15000','1305000','0','0','0','1305000','LIS','00325630','E2D','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-XKAA-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E2D-XKAA-29-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 ('F326290206511','2026-06-29','1.250','2026-06-29','14:06:51','PLG0030049','1305000','1305000','0','1305000','1305000','kasir','2026-06-29 14:06:51','F32629020651');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290206511','2026-06-29','14:06:51','LIS','1305000','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-260629-0016','D','2026-06-29','14:06:51','kasir','PENJUALAN','F326290206511','6029818000','1305000','6031123000');
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 ('F326290208051','kasir','1',' MDE2 X MG ','TOKO','PM-E','E2D-YFAC-139-0','CC X MODEL MATA MG 18 8K ','','1.260','1','100.00','1317000','0','0','15000','1318000','0','0','0','1318000','LIS','00357254','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAC-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E2D-YFAC-139-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 ('F326290208051','2026-06-29','1.260','2026-06-29','14:08:06','PLG0030050','1318000','1318000','0','1318000','1318000','kasir','2026-06-29 14:08:05','F32629020805');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-29','F326290208051','2026-06-29','14:08:06','LIS','1318000','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-260629-0017','D','2026-06-29','14:08:06','kasir','PENJUALAN','F326290208051','6031123000','1318000','6032441000');
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-00019511','X-00019511','CC X MODEL MATA CM 18 8K','GR','---','E2D','BELI','BELI001','1020000','2026-06-29','1.140','1','kasir','2026-06-29 14:10:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019511','X-00019511');
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-260629-0008','F325010145471','SIN','1','BELI','BELI001','E2D', 'X-00019511', 'CC X MODEL MATA CM 18 8K','1.140','1.140','100.00','1085000','1020000','894737','1045000','1','1020000','1020000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.140',berat_beli_asli=berat_beli_asli+'1.140',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.140',berat_akhir_asli=berat_akhir_asli+'1.140',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' 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-260629-0008','2026-06-29','2026-06-29','14:10:47','SIN','---','1.140','1020000','1020000','1020000','1020000','1020000','kasir','2026-06-29 14:10:48','FB-260629-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0008','NURIL','TINASAT GESING KISMANTORO','','','','kasir','2026-06-29 14:10:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0018','K','2026-06-29','14:10:47','kasir','PEMBELIAN UMUM','FB-260629-0008','6032441000','1020000','6031421000');
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-00019512','X-00019512','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','833000','2026-06-29','0.850','1','kasir','2026-06-29 14:11:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019512','X-00019512');
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-260629-0009','F326170218292','FIT','1','BELI','BELI001','E2D', 'X-00019512', 'CC X MODEL MATA CM 14 8K','0.850','0.850','100.00','910000','833000','980000','1045000','1','833000','833000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' 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-260629-0009','2026-06-29','2026-06-29','14:11:26','FIT','---','0.850','833000','833000','833000','833000','833000','kasir','2026-06-29 14:11:27','FB-260629-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0009','SELIN','GONDANG BULUKERTO','','','','kasir','2026-06-29 14:11:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0019','K','2026-06-29','14:11:26','kasir','PEMBELIAN UMUM','FB-260629-0009','6031421000','833000','6030588000');
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-00019513','X-00019513','CC X MODEL SLEP UB 14 8K','GR','---','E1E','BELI','BELI001','560000','2026-06-29','0.560','1','kasir','2026-06-29 14:11:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019513','X-00019513');
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-260629-0010','F326170218291','FIT','2','BELI','BELI001','E1E', 'X-00019513', 'CC X MODEL SLEP UB 14 8K','0.560','0.560','100.00','610000','560000','1000000','1075000','1','560000','560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260629-0010','2026-06-29','2026-06-29','14:11:27','FIT','---','0.560','560000','560000','560000','560000','560000','kasir','2026-06-29 14:11:27','FB-260629-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0010','SELIN','GONDANG BULUKERTO','','','','kasir','2026-06-29 14:11:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0020','K','2026-06-29','14:11:27','kasir','PEMBELIAN UMUM','FB-260629-0010','6030588000','560000','6030028000');
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-00019514','X-00019514','CC X MODEL SLEP AY 10 8K','GR','---','E1E','BELI','BELI001','600000','2026-06-29','0.600','1','kasir','2026-06-29 14:49:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019514','X-00019514');
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-260629-0011','F326181253132','LIS','1','BELI','BELI001','E1E', 'X-00019514', 'CC X MODEL SLEP AY 10 8K','0.600','0.600','100.00','738000','600000','1000000','1075000','1','600000','600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260629-0011','2026-06-29','2026-06-29','14:49:07','LIS','---','0.600','600000','600000','600000','600000','600000','kasir','2026-06-29 14:49:08','FB-260629-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0011','MILIN','PUCUNG KIAMANTORO','','','081399964038','kasir','2026-06-29 14:49:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0021','K','2026-06-29','14:49:07','kasir','PEMBELIAN UMUM','FB-260629-0011','6030028000','600000','6029428000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290101191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290101191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290101191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290111361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290111361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290111361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290112051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290112051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290112051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290129051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290129051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290129051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290206511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290206511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290206511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290208051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290208051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290208051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290935491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290935491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290935491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290935492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290935492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290935492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326290935493' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326290935493' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326290935493';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-30','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-29';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-29' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','15:09:55','SYSTEM','SALDO AWAL','SALDO AWAL','0','6029428000','6029428000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','15:09:55','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260630-0001','D','2026-06-30','15:09:55','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-260630-0001','D','2026-06-30','15:09:55','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
UPDATE tp_system SET tgl_system='2026-06-30';