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 ('F325080825361','input','1',' MEF3 UB ','TOKO','PM-F','F3E-YKXC-321-0','GL SANTA SERUT BOLA ARESO VAR UB 8K ','','2.000','1','100.00','2054000','0','0','15000','2055000','0','0','0','2055000','AAT','00376249','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXC-321-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F3E-YKXC-321-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 ('F325080825361','2025-12-08','2.000','2025-12-08','08:25:37','PLG0026077','2055000','2055000','0','2055000','2055000','input','2025-12-08 08:25:36','F32508082536');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325080825361','2025-12-08','08:25:37','AAT','2055000','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-251208-0002','D','2025-12-08','08:25:37','input','PENJUALAN','F325080825361','1050811000','2055000','1052866000');
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-00017632','X-00017632','KL X GUCCI UB 44 9K','GR','---','H2J','BELI','BELI001','2595000','2025-12-08','3.050','1','kasir','2025-12-08 09:34:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017632','X-00017632');
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-251208-0001','F325220215241','AAT','1','BELI','BELI001','H2J', 'X-00017632', 'KL X GUCCI UB 44 9K','3.050','3.050','100.00','2791000','2595000','850820','1137000','1','2595000','2595000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.050',berat_beli_asli=berat_beli_asli+'3.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.050',berat_akhir_asli=berat_akhir_asli+'3.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251208-0001','2025-12-08','2025-12-08','09:34:31','AAT','---','3.050','2595000','2595000','2595000','2595000','2595000','kasir','2025-12-08 09:34:32','FB-251208-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251208-0001','NURHAYATI','JERUK','','','','kasir','2025-12-08 09:34:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-08' 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-251208-0003','K','2025-12-08','09:34:31','kasir','PEMBELIAN UMUM','FB-251208-0001','1052866000','2595000','1050271000');
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-00017633','X-00017633','LT XXX MODEL MATA UB 8K','GR','---','D2E','BELI','BELI001','1105000','2025-12-08','1.200','1','kasir','2025-12-08 09:36:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00017633','X-00017633');
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-251208-0002','F325040826192','AAT','1','BELI','BELI001','D2E', 'X-00017633', 'LT XXX MODEL MATA UB 8K','1.200','1.200','100.00','1190000','1105000','920833','1037000','1','1105000','1105000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.200',berat_beli_asli=berat_beli_asli+'1.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.200',berat_akhir_asli=berat_akhir_asli+'1.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251208-0002','2025-12-08','2025-12-08','09:36:18','AAT','---','1.200','1105000','1105000','1105000','1105000','1105000','kasir','2025-12-08 09:36:18','FB-251208-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251208-0002','TIARA','BAKALAN','','','','kasir','2025-12-08 09:36:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-08' 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-251208-0004','K','2025-12-08','09:36:18','kasir','PEMBELIAN UMUM','FB-251208-0002','1050271000','1105000','1049166000');
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-00017634','X-00017634','KL X NORY KH 44 8K','GR','---','H1E','BELI','BELI001','3682000','2025-12-08','4.000','1','kasir','2025-12-08 09:40:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017634','X-00017634');
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-251208-0003','F325040826191','AAT','1','BELI','BELI001','H1E', 'X-00017634', 'KL X NORY KH 44 8K','4.000','4.000','100.00','3960000','3682000','920500','1037000','1','3682000','3682000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.000',berat_beli_asli=berat_beli_asli+'4.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.000',berat_akhir_asli=berat_akhir_asli+'4.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251208-0003','2025-12-08','2025-12-08','09:40:03','AAT','---','4.000','3682000','3682000','3682000','3682000','3682000','kasir','2025-12-08 09:40:04','FB-251208-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251208-0003','TIARA','BAKALAN','','','','kasir','2025-12-08 09:40:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-08' 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-251208-0005','K','2025-12-08','09:40:03','kasir','PEMBELIAN UMUM','FB-251208-0003','1049166000','3682000','1045484000');
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 ('F325081010591','kasir','1',' MDE2 20K Y','TOKO','PM-E','E2D-YAXG-114-0','CC METRO MATA BIRU VAR YT 21 8K ','','2.520','1','100.00','2538000','0','0','15000','2538000','0','20000','0','2558000','SIN','00332928','E2D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YAXG-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='E2D-YAXG-114-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 ('F325081010591','2025-12-08','2.520','2025-12-08','10:11:00','PLG0026078','2538000','2538000','20000','2558000','2558000','kasir','2025-12-08 10:10:59','F32508101059');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081010591','2025-12-08','10:11:00','SIN','2558000','20000');
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-251208-0006','D','2025-12-08','10:11:00','kasir','PENJUALAN','F325081010591','1045484000','2558000','1048042000');
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 ('F325081013271','kasir','1',' MFF1 X UB ','TOKO','PM-F','F1F-YIBD-156-0','GL X OVAL TINJU PASIR UB 56 8K ','','4.600','1','100.00','4816000','0','0','15000','4815000','0','0','0','4815000','SIN','00370577','F1F','0','0','-','1','1057000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1F-YIBD-156-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.600',berat_jual_asli=berat_jual_asli+'4.600',stock_jual='1',berat_akhir=berat_akhir-'4.600',berat_akhir_asli=berat_akhir_asli-'4.600',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F1F-YIBD-156-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 ('F325081013271','2025-12-08','4.600','2025-12-08','10:13:27','PLG0026079','4815000','4815000','0','4815000','4815000','kasir','2025-12-08 10:13:27','F32508101327');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081013271','2025-12-08','10:13:27','SIN','4815000','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-251208-0007','D','2025-12-08','10:13:27','kasir','PENJUALAN','F325081013271','1048042000','4815000','1052857000');
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 ('F325081055561','kasir','1',' TEF3 X HW ','TOKO','PT-F','F3TE-XBBF-62-T','GL X MODEL CAPELA PLAT ARESO VAR HW ','','3.850','1','100.00','7219000','0','0','15000','7220000','0','0','0','7220000','FIT','T0054361','F3TE','0','0','-','0','1875000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-XBBF-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.850',berat_jual_asli=berat_jual_asli+'3.850',stock_jual='1',berat_akhir=berat_akhir-'3.850',berat_akhir_asli=berat_akhir_asli-'3.850',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F3TE-XBBF-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325081055561','2025-12-08','3.850','2025-12-08','10:55:57','PLG0026080','7220000','7220000','0','7220000','7220000','kasir','2025-12-08 10:55:56','F32508105556');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081055561','2025-12-08','10:55:57','FIT','7220000','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-251208-0008','D','2025-12-08','10:55:57','kasir','PENJUALAN','F325081055561','1052857000','7220000','1060077000');
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 ('F325081109441','kasir','1',' MEF3E X SW','TOKO','PM-F','F3E-YKBD-80-0','GL X FANCY MATA VAR SWS 8K ','','3.750','1','100.00','3851000','0','0','15000','3850000','0','0','0','3850000','AAT','00378489','F3E','0','0','-','1','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBD-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.750',berat_jual_asli=berat_jual_asli+'3.750',stock_jual='1',berat_akhir=berat_akhir-'3.750',berat_akhir_asli=berat_akhir_asli-'3.750',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F3E-YKBD-80-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 ('F325081109441','2025-12-08','3.750','2025-12-08','11:09:45','PLG0026081','3850000','3850000','0','3850000','3850000','kasir','2025-12-08 11:09:44','F32508110944');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081109441','2025-12-08','11:09:45','AAT','3850000','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-251208-0009','D','2025-12-08','11:09:45','kasir','PENJUALAN','F325081109441','1060077000','3850000','1063927000');
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 ('F325081138251','kasir','1',' MEF2 XX LT','TOKO','PM-F','F2E-YIXD-100-0','GL XX OVAL C MATA LT 56 8K ','','6.180','1','100.00','6347000','0','0','15000','6348000','0','0','0','6348000','FIT','00367857','F2E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YIXD-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.180',berat_jual_asli=berat_jual_asli+'6.180',stock_jual='1',berat_akhir=berat_akhir-'6.180',berat_akhir_asli=berat_akhir_asli-'6.180',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F2E-YIXD-100-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 ('F325081138251','2025-12-08','6.180','2025-12-08','11:38:25','PLG0026082','6348000','6348000','0','6348000','6348000','kasir','2025-12-08 11:38:25','F32508113825');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081138251','2025-12-08','11:38:25','FIT','6348000','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-251208-0010','D','2025-12-08','11:38:25','kasir','PENJUALAN','F325081138251','1063927000','6348000','1070275000');
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 ('F325081149521','kasir','1',' MEB1 X LG ','TOKO','PM-B','B1E-XIBG-26-0','GW X MODEL MATA LG PE 8K ','','0.560','1','100.00','575000','0','0','15000','575000','0','0','0','575000','AAT','00319285','B1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-XIBG-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='B1E-XIBG-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325081149521','2025-12-08','0.560','2025-12-08','11:49:52','PLG0026083','575000','575000','0','575000','575000','kasir','2025-12-08 11:49:52','F32508114952');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081149521','2025-12-08','11:49:52','AAT','575000','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-251208-0011','D','2025-12-08','11:49:52','kasir','PENJUALAN','F325081149521','1070275000','575000','1070850000');
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 ('F325081155231','kasir','1',' TDE2 X LG ','TOKO','PT-E','E2TD-XLBG-114-T','CC X MODEL MATA VAR LG 12 17K ','','1.500','1','100.00','2775000','0','0','15000','2783000','0','0','0','2783000','FIT','T0065466','E2TD','0','0','-','0','1850000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-XLBG-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='E2TD-XLBG-114-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325081155231','2025-12-08','1.500','2025-12-08','11:55:24','PLG0026084','2783000','2783000','0','2783000','2783000','kasir','2025-12-08 11:55:23','F32508115523');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081155231','2025-12-08','11:55:24','FIT','2783000','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-251208-0012','D','2025-12-08','11:55:24','kasir','PENJUALAN','F325081155231','1070850000','2783000','1073633000');
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='T0054890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='T0041707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1489500',harga_beli ='1489500' WHERE kode_barcode='T0053497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='T0064776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='688500',harga_beli ='688500' WHERE kode_barcode='T0075085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='T0075086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='T0075096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='678000',harga_beli ='678000' WHERE kode_barcode='T0075095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='709000',harga_beli ='709000' WHERE kode_barcode='T0074908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='T0073872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1140000',harga_beli ='1140000' WHERE kode_barcode='T0072059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='T0075180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4283000',harga_beli ='4283000' WHERE kode_barcode='T0074862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1006500',harga_beli ='1006500' WHERE kode_barcode='00052974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='832000',harga_beli ='832000' WHERE kode_barcode='00064198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1212000',harga_beli ='1212000' WHERE kode_barcode='00070948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1499500',harga_beli ='1499500' WHERE kode_barcode='00087214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1191500',harga_beli ='1191500' WHERE kode_barcode='00090365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7117500',harga_beli ='7117500' WHERE kode_barcode='00091472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00092124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5145500',harga_beli ='5145500' WHERE kode_barcode='00093062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1284000',harga_beli ='1284000' WHERE kode_barcode='00093636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00093639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00096890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1386500',harga_beli ='1386500' WHERE kode_barcode='00099591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2167000',harga_beli ='2167000' WHERE kode_barcode='00100589' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1150500',harga_beli ='1150500' WHERE kode_barcode='00102954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00103630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00119795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2208500',harga_beli ='2208500' WHERE kode_barcode='00120910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00120913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='00132364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00132895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00133009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1119500',harga_beli ='1119500' WHERE kode_barcode='00138354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='10219000',harga_beli ='10219000' WHERE kode_barcode='00141171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00142644' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1212000',harga_beli ='1212000' WHERE kode_barcode='00142650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1161000',harga_beli ='1161000' WHERE kode_barcode='00149726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1068500',harga_beli ='1068500' WHERE kode_barcode='00155944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1150500',harga_beli ='1150500' WHERE kode_barcode='00156105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1674500',harga_beli ='1674500' WHERE kode_barcode='00156899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3153000',harga_beli ='3153000' WHERE kode_barcode='00160815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='976000',harga_beli ='976000' WHERE kode_barcode='00165309' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='00166158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00168498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1181500',harga_beli ='1181500' WHERE kode_barcode='00175403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1407500',harga_beli ='1407500' WHERE kode_barcode='00180742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1417500',harga_beli ='1417500' WHERE kode_barcode='00181466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1243000',harga_beli ='1243000' WHERE kode_barcode='00182849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00187806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='832000',harga_beli ='832000' WHERE kode_barcode='00194266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3060500',harga_beli ='3060500' WHERE kode_barcode='00194622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='986000',harga_beli ='986000' WHERE kode_barcode='00195794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1376500',harga_beli ='1376500' WHERE kode_barcode='00195846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='668000',harga_beli ='668000' WHERE kode_barcode='00201184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1520000',harga_beli ='1520000' WHERE kode_barcode='00209127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='00209522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1448500',harga_beli ='1448500' WHERE kode_barcode='00209700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00213359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1746000',harga_beli ='1746000' WHERE kode_barcode='00213369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1150500',harga_beli ='1150500' WHERE kode_barcode='00213405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1119500',harga_beli ='1119500' WHERE kode_barcode='00213686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00213848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3749000',harga_beli ='3749000' WHERE kode_barcode='00216509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00221400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2064500',harga_beli ='2064500' WHERE kode_barcode='00223055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='996500',harga_beli ='996500' WHERE kode_barcode='00227840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1448500',harga_beli ='1448500' WHERE kode_barcode='00229047' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1407500',harga_beli ='1407500' WHERE kode_barcode='00229143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1181500',harga_beli ='1181500' WHERE kode_barcode='00229297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4211000',harga_beli ='4211000' WHERE kode_barcode='00230768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='8144500',harga_beli ='8144500' WHERE kode_barcode='00231510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1438000',harga_beli ='1438000' WHERE kode_barcode='00231736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00232223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1150500',harga_beli ='1150500' WHERE kode_barcode='00233756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3749000',harga_beli ='3749000' WHERE kode_barcode='00234146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1695000',harga_beli ='1695000' WHERE kode_barcode='00235731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1335500',harga_beli ='1335500' WHERE kode_barcode='00235947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00237045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2023500',harga_beli ='2023500' WHERE kode_barcode='00237945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5145500',harga_beli ='5145500' WHERE kode_barcode='00240295' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1130000',harga_beli ='1130000' WHERE kode_barcode='00240727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6111000',harga_beli ='6111000' WHERE kode_barcode='00241193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5207000',harga_beli ='5207000' WHERE kode_barcode='00241197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1551000',harga_beli ='1551000' WHERE kode_barcode='00242997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00243028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00243065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1417500',harga_beli ='1417500' WHERE kode_barcode='00243157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1315000',harga_beli ='1315000' WHERE kode_barcode='00243242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1335500',harga_beli ='1335500' WHERE kode_barcode='00243446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='986000',harga_beli ='986000' WHERE kode_barcode='00243900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1294500',harga_beli ='1294500' WHERE kode_barcode='00243916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2855500',harga_beli ='2855500' WHERE kode_barcode='00247320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1910500',harga_beli ='1910500' WHERE kode_barcode='00249771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2413500',harga_beli ='2413500' WHERE kode_barcode='00251708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3235500',harga_beli ='3235500' WHERE kode_barcode='00253027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6111000',harga_beli ='6111000' WHERE kode_barcode='00254124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2855500',harga_beli ='2855500' WHERE kode_barcode='00254363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1119500',harga_beli ='1119500' WHERE kode_barcode='00255506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3276500',harga_beli ='3276500' WHERE kode_barcode='00255678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2311000',harga_beli ='2311000' WHERE kode_barcode='00256394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1089000',harga_beli ='1089000' WHERE kode_barcode='00256496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1161000',harga_beli ='1161000' WHERE kode_barcode='00257782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1386500',harga_beli ='1386500' WHERE kode_barcode='00258005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1530500',harga_beli ='1530500' WHERE kode_barcode='00258745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00258749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00259322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00260039' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2362500',harga_beli ='2362500' WHERE kode_barcode='00260570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00261890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1109500',harga_beli ='1109500' WHERE kode_barcode='00262510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1243000',harga_beli ='1243000' WHERE kode_barcode='00262939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1479000',harga_beli ='1479000' WHERE kode_barcode='00263068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2003000',harga_beli ='2003000' WHERE kode_barcode='00264622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00265415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1695000',harga_beli ='1695000' WHERE kode_barcode='00265735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1469000',harga_beli ='1469000' WHERE kode_barcode='00266289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1181500',harga_beli ='1181500' WHERE kode_barcode='00266588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1161000',harga_beli ='1161000' WHERE kode_barcode='00268791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='996500',harga_beli ='996500' WHERE kode_barcode='00268802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='00268957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1089000',harga_beli ='1089000' WHERE kode_barcode='00269112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00269135' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00270520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1130000',harga_beli ='1130000' WHERE kode_barcode='00272416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7220000',harga_beli ='7220000' WHERE kode_barcode='00272894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00273013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='986000',harga_beli ='986000' WHERE kode_barcode='00273105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3410000',harga_beli ='3410000' WHERE kode_barcode='00273818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='873000',harga_beli ='873000' WHERE kode_barcode='00273907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1674500',harga_beli ='1674500' WHERE kode_barcode='00273949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00274396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1253000',harga_beli ='1253000' WHERE kode_barcode='00275015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00275799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00277691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2064500',harga_beli ='2064500' WHERE kode_barcode='00277693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00277878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='894000',harga_beli ='894000' WHERE kode_barcode='00281431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2116000',harga_beli ='2116000' WHERE kode_barcode='00281716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3440500',harga_beli ='3440500' WHERE kode_barcode='00283283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='10835000',harga_beli ='10835000' WHERE kode_barcode='00283322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='832000',harga_beli ='832000' WHERE kode_barcode='00284337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1109500',harga_beli ='1109500' WHERE kode_barcode='00284344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='924500',harga_beli ='924500' WHERE kode_barcode='00284364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1284000',harga_beli ='1284000' WHERE kode_barcode='00284430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1458500',harga_beli ='1458500' WHERE kode_barcode='00284994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5176500',harga_beli ='5176500' WHERE kode_barcode='00285379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='00285674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1130000',harga_beli ='1130000' WHERE kode_barcode='00285792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00285979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00286016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00286148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2321500',harga_beli ='2321500' WHERE kode_barcode='00286322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00287251' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='986000',harga_beli ='986000' WHERE kode_barcode='00288392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='894000',harga_beli ='894000' WHERE kode_barcode='00288452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2013000',harga_beli ='2013000' WHERE kode_barcode='00288619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00290272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00290282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00290322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00290441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1089000',harga_beli ='1089000' WHERE kode_barcode='00290448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1335500',harga_beli ='1335500' WHERE kode_barcode='00290451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1212000',harga_beli ='1212000' WHERE kode_barcode='00290617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='894000',harga_beli ='894000' WHERE kode_barcode='00290730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1099000',harga_beli ='1099000' WHERE kode_barcode='00290955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2290500',harga_beli ='2290500' WHERE kode_barcode='00290962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='976000',harga_beli ='976000' WHERE kode_barcode='00290980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='945000',harga_beli ='945000' WHERE kode_barcode='00290982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='924500',harga_beli ='924500' WHERE kode_barcode='00291018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='00291024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00292788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4016000',harga_beli ='4016000' WHERE kode_barcode='00293298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3132500',harga_beli ='3132500' WHERE kode_barcode='00293351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00294259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='924500',harga_beli ='924500' WHERE kode_barcode='00294260' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3666500',harga_beli ='3666500' WHERE kode_barcode='00294757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='8350000',harga_beli ='8350000' WHERE kode_barcode='00295141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='986000',harga_beli ='986000' WHERE kode_barcode='00295193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='986000',harga_beli ='986000' WHERE kode_barcode='00295525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1489500',harga_beli ='1489500' WHERE kode_barcode='00297474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1232500',harga_beli ='1232500' WHERE kode_barcode='00297551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00297627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2023500',harga_beli ='2023500' WHERE kode_barcode='00297756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00297949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1181500',harga_beli ='1181500' WHERE kode_barcode='00297951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00297985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3338000',harga_beli ='3338000' WHERE kode_barcode='00298269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2434500',harga_beli ='2434500' WHERE kode_barcode='00298345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00298456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1469000',harga_beli ='1469000' WHERE kode_barcode='00298488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1253000',harga_beli ='1253000' WHERE kode_barcode='00299014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1099000',harga_beli ='1099000' WHERE kode_barcode='00299663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1315000',harga_beli ='1315000' WHERE kode_barcode='00300475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2824500',harga_beli ='2824500' WHERE kode_barcode='00300881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2259500',harga_beli ='2259500' WHERE kode_barcode='00301304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00301362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2547000',harga_beli ='2547000' WHERE kode_barcode='00302645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1448500',harga_beli ='1448500' WHERE kode_barcode='00302736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1181500',harga_beli ='1181500' WHERE kode_barcode='00302955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='00303154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1232500',harga_beli ='1232500' WHERE kode_barcode='00303862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1253000',harga_beli ='1253000' WHERE kode_barcode='00303915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='976000',harga_beli ='976000' WHERE kode_barcode='00304212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5402500',harga_beli ='5402500' WHERE kode_barcode='00304341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1797500',harga_beli ='1797500' WHERE kode_barcode='00304486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00304543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00304544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00304774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='935000',harga_beli ='935000' WHERE kode_barcode='00305005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2927000',harga_beli ='2927000' WHERE kode_barcode='00305436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1068500',harga_beli ='1068500' WHERE kode_barcode='00305485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00305493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1951500',harga_beli ='1951500' WHERE kode_barcode='00305517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00305542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6111000',harga_beli ='6111000' WHERE kode_barcode='00306050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00306186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1315000',harga_beli ='1315000' WHERE kode_barcode='00306428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1089000',harga_beli ='1089000' WHERE kode_barcode='00306465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00306938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5361000',harga_beli ='5361000' WHERE kode_barcode='00307180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00307506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='976000',harga_beli ='976000' WHERE kode_barcode='00307837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3040000',harga_beli ='3040000' WHERE kode_barcode='00308223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2876000',harga_beli ='2876000' WHERE kode_barcode='00308301' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1161000',harga_beli ='1161000' WHERE kode_barcode='00308327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3594500',harga_beli ='3594500' WHERE kode_barcode='00309100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='894000',harga_beli ='894000' WHERE kode_barcode='00309432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2876000',harga_beli ='2876000' WHERE kode_barcode='00309648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2157000',harga_beli ='2157000' WHERE kode_barcode='00309651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3759000',harga_beli ='3759000' WHERE kode_barcode='00309802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3625500',harga_beli ='3625500' WHERE kode_barcode='00309805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3030000',harga_beli ='3030000' WHERE kode_barcode='00309836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00309991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='945000',harga_beli ='945000' WHERE kode_barcode='00309992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='935000',harga_beli ='935000' WHERE kode_barcode='00310563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00310566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1664000',harga_beli ='1664000' WHERE kode_barcode='00311565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4868500',harga_beli ='4868500' WHERE kode_barcode='00312520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6213500',harga_beli ='6213500' WHERE kode_barcode='00313257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3369000',harga_beli ='3369000' WHERE kode_barcode='00313273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3471500',harga_beli ='3471500' WHERE kode_barcode='00313442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00314218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2680500',harga_beli ='2680500' WHERE kode_barcode='00314865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2208500',harga_beli ='2208500' WHERE kode_barcode='00315117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3204500',harga_beli ='3204500' WHERE kode_barcode='00315145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6491000',harga_beli ='6491000' WHERE kode_barcode='00315992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='739500',harga_beli ='739500' WHERE kode_barcode='00316165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='678000',harga_beli ='678000' WHERE kode_barcode='00316201' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='00316576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2598500',harga_beli ='2598500' WHERE kode_barcode='00316606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00317399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2116000',harga_beli ='2116000' WHERE kode_barcode='00317438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5114500',harga_beli ='5114500' WHERE kode_barcode='00317470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1859000',harga_beli ='1859000' WHERE kode_barcode='00318645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00319010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00319073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2218500',harga_beli ='2218500' WHERE kode_barcode='00319599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5104500',harga_beli ='5104500' WHERE kode_barcode='00320181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7056000',harga_beli ='7056000' WHERE kode_barcode='00320719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00320960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3851500',harga_beli ='3851500' WHERE kode_barcode='00321078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3060500',harga_beli ='3060500' WHERE kode_barcode='00322075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='678000',harga_beli ='678000' WHERE kode_barcode='00322385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6860500',harga_beli ='6860500' WHERE kode_barcode='00323272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00323774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6265000',harga_beli ='6265000' WHERE kode_barcode='00323870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3235500',harga_beli ='3235500' WHERE kode_barcode='00323928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2742500',harga_beli ='2742500' WHERE kode_barcode='00324242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00324623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3389500',harga_beli ='3389500' WHERE kode_barcode='00324824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='00325479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3482000',harga_beli ='3482000' WHERE kode_barcode='00325490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00326747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2208500',harga_beli ='2208500' WHERE kode_barcode='00327149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00327926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00328366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='00329335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1777000',harga_beli ='1777000' WHERE kode_barcode='00331623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5186500',harga_beli ='5186500' WHERE kode_barcode='00333208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2208500',harga_beli ='2208500' WHERE kode_barcode='00333691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='832000',harga_beli ='832000' WHERE kode_barcode='00334287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00334313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00334827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00336492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7805500',harga_beli ='7805500' WHERE kode_barcode='00336675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2003000',harga_beli ='2003000' WHERE kode_barcode='00336721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00336800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00337009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2352000',harga_beli ='2352000' WHERE kode_barcode='00337578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00337715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5207000',harga_beli ='5207000' WHERE kode_barcode='00337736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00337822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00338009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4077500',harga_beli ='4077500' WHERE kode_barcode='00338085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7189000',harga_beli ='7189000' WHERE kode_barcode='00338088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1571500',harga_beli ='1571500' WHERE kode_barcode='00338969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5186500',harga_beli ='5186500' WHERE kode_barcode='00339259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='976000',harga_beli ='976000' WHERE kode_barcode='00339417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00339478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00339609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2218500',harga_beli ='2218500' WHERE kode_barcode='00340149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5022500',harga_beli ='5022500' WHERE kode_barcode='00340450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00340726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00340746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00341878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='00341892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00341894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00342070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00342078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00342085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5197000',harga_beli ='5197000' WHERE kode_barcode='00342185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00343205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00343206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3677000',harga_beli ='3677000' WHERE kode_barcode='00343376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6244500',harga_beli ='6244500' WHERE kode_barcode='00344205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1972000',harga_beli ='1972000' WHERE kode_barcode='00344589' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00344610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='822000',harga_beli ='822000' WHERE kode_barcode='00344624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00344626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2126000',harga_beli ='2126000' WHERE kode_barcode='00344637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00344643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2116000',harga_beli ='2116000' WHERE kode_barcode='00344647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00344648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5135000',harga_beli ='5135000' WHERE kode_barcode='00344796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='996500',harga_beli ='996500' WHERE kode_barcode='00344918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2003000',harga_beli ='2003000' WHERE kode_barcode='00346125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2208500',harga_beli ='2208500' WHERE kode_barcode='00346126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1962000',harga_beli ='1962000' WHERE kode_barcode='00346336' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2167000',harga_beli ='2167000' WHERE kode_barcode='00346576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00346808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='00346936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='00347526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00347558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00347559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00347617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2372500',harga_beli ='2372500' WHERE kode_barcode='00347662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00347810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='729500',harga_beli ='729500' WHERE kode_barcode='00347905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00347920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00348349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2136500',harga_beli ='2136500' WHERE kode_barcode='00348814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00348844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00348853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2588500',harga_beli ='2588500' WHERE kode_barcode='00349218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00349231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3091500',harga_beli ='3091500' WHERE kode_barcode='00349277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='10270000',harga_beli ='10270000' WHERE kode_barcode='00349472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3235500',harga_beli ='3235500' WHERE kode_barcode='00349485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1150500',harga_beli ='1150500' WHERE kode_barcode='00349780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2948000',harga_beli ='2948000' WHERE kode_barcode='00349819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2239000',harga_beli ='2239000' WHERE kode_barcode='00349850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00349851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00349915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1951500',harga_beli ='1951500' WHERE kode_barcode='00349921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1972000',harga_beli ='1972000' WHERE kode_barcode='00349947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='729500',harga_beli ='729500' WHERE kode_barcode='00350163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00350362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1705000',harga_beli ='1705000' WHERE kode_barcode='00350365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00350714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00350716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00350734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='668000',harga_beli ='668000' WHERE kode_barcode='00351042' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00351242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1037500',harga_beli ='1037500' WHERE kode_barcode='00351247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='10291000',harga_beli ='10291000' WHERE kode_barcode='00351402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00351568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00351570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00351665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='00351768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2413500',harga_beli ='2413500' WHERE kode_barcode='00352115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00352578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1664000',harga_beli ='1664000' WHERE kode_barcode='00352613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='647500',harga_beli ='647500' WHERE kode_barcode='00352778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00352779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6275000',harga_beli ='6275000' WHERE kode_barcode='00352862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00352891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='15508000',harga_beli ='15508000' WHERE kode_barcode='00353157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='00353247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00353392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4827000',harga_beli ='4827000' WHERE kode_barcode='00353460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7045500',harga_beli ='7045500' WHERE kode_barcode='00353473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00353488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00353513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7251000',harga_beli ='7251000' WHERE kode_barcode='00353773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2003000',harga_beli ='2003000' WHERE kode_barcode='00353826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00353828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2393000',harga_beli ='2393000' WHERE kode_barcode='00353831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2496000',harga_beli ='2496000' WHERE kode_barcode='00353844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00354498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00354511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5156000',harga_beli ='5156000' WHERE kode_barcode='00354537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3574000',harga_beli ='3574000' WHERE kode_barcode='00354547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2567500',harga_beli ='2567500' WHERE kode_barcode='00354615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00354722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00355579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='8195500',harga_beli ='8195500' WHERE kode_barcode='00355788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6018500',harga_beli ='6018500' WHERE kode_barcode='00355862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6193000',harga_beli ='6193000' WHERE kode_barcode='00355872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4139000',harga_beli ='4139000' WHERE kode_barcode='00355876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2003000',harga_beli ='2003000' WHERE kode_barcode='00355954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1335500',harga_beli ='1335500' WHERE kode_barcode='00355959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2321500',harga_beli ='2321500' WHERE kode_barcode='00356347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3143000',harga_beli ='3143000' WHERE kode_barcode='00356357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3369000',harga_beli ='3369000' WHERE kode_barcode='00356713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00356731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00356767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5258500',harga_beli ='5258500' WHERE kode_barcode='00356771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3317500',harga_beli ='3317500' WHERE kode_barcode='00356951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00357277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00357563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1777000',harga_beli ='1777000' WHERE kode_barcode='00357585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00357587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00357601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1294500',harga_beli ='1294500' WHERE kode_barcode='00357631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00358033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2773000',harga_beli ='2773000' WHERE kode_barcode='00358194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00358200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5803000',harga_beli ='5803000' WHERE kode_barcode='00358213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00358263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1191500',harga_beli ='1191500' WHERE kode_barcode='00358371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2146500',harga_beli ='2146500' WHERE kode_barcode='00358564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5145500',harga_beli ='5145500' WHERE kode_barcode='00358772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3317500',harga_beli ='3317500' WHERE kode_barcode='00358774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7374000',harga_beli ='7374000' WHERE kode_barcode='00358792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1951500',harga_beli ='1951500' WHERE kode_barcode='00358793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3964500',harga_beli ='3964500' WHERE kode_barcode='00358820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00358821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1931000',harga_beli ='1931000' WHERE kode_barcode='00358826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00359237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00359239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00359250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2906500',harga_beli ='2906500' WHERE kode_barcode='00359334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00359337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1006500',harga_beli ='1006500' WHERE kode_barcode='00359463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='555000',harga_beli ='555000' WHERE kode_barcode='00359695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00359696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00359980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00359981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00360102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2670500',harga_beli ='2670500' WHERE kode_barcode='00360426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4283000',harga_beli ='4283000' WHERE kode_barcode='00360435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00360601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1068500',harga_beli ='1068500' WHERE kode_barcode='00360662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2136500',harga_beli ='2136500' WHERE kode_barcode='00361054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00361064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00361065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4745000',harga_beli ='4745000' WHERE kode_barcode='00361161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00361186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00361344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00361424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7168500',harga_beli ='7168500' WHERE kode_barcode='00361562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3410000',harga_beli ='3410000' WHERE kode_barcode='00361566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2865500',harga_beli ='2865500' WHERE kode_barcode='00361568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='729500',harga_beli ='729500' WHERE kode_barcode='00361650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3112000',harga_beli ='3112000' WHERE kode_barcode='00361747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3297000',harga_beli ='3297000' WHERE kode_barcode='00361873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2773000',harga_beli ='2773000' WHERE kode_barcode='00361874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2270000',harga_beli ='2270000' WHERE kode_barcode='00361876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5135000',harga_beli ='5135000' WHERE kode_barcode='00362405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4950500',harga_beli ='4950500' WHERE kode_barcode='00362408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2619000',harga_beli ='2619000' WHERE kode_barcode='00362735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='411000',harga_beli ='411000' WHERE kode_barcode='00362777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='472500',harga_beli ='472500' WHERE kode_barcode='00363237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00363239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6193000',harga_beli ='6193000' WHERE kode_barcode='00363352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00363429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00363476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='452000',harga_beli ='452000' WHERE kode_barcode='00363634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1674500',harga_beli ='1674500' WHERE kode_barcode='00363819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2444500',harga_beli ='2444500' WHERE kode_barcode='00363925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00363962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='00363968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='739500',harga_beli ='739500' WHERE kode_barcode='00363969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='688500',harga_beli ='688500' WHERE kode_barcode='00363970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5145500',harga_beli ='5145500' WHERE kode_barcode='00364062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2033500',harga_beli ='2033500' WHERE kode_barcode='00364071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00364371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3625500',harga_beli ='3625500' WHERE kode_barcode='00364429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1479000',harga_beli ='1479000' WHERE kode_barcode='00364467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00364470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5053000',harga_beli ='5053000' WHERE kode_barcode='00364669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00364682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='698500',harga_beli ='698500' WHERE kode_barcode='00364804' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00364833' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7086500',harga_beli ='7086500' WHERE kode_barcode='00364924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2896500',harga_beli ='2896500' WHERE kode_barcode='00364928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2044000',harga_beli ='2044000' WHERE kode_barcode='00364933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='00365078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00365368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5299500',harga_beli ='5299500' WHERE kode_barcode='00365416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3605000',harga_beli ='3605000' WHERE kode_barcode='00365431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2311000',harga_beli ='2311000' WHERE kode_barcode='00365482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00365570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00365762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='729500',harga_beli ='729500' WHERE kode_barcode='00365767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00365789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5063500',harga_beli ='5063500' WHERE kode_barcode='00365906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='555000',harga_beli ='555000' WHERE kode_barcode='00366044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00366094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3112000',harga_beli ='3112000' WHERE kode_barcode='00366100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1972000',harga_beli ='1972000' WHERE kode_barcode='00366121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00366143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00366229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1161000',harga_beli ='1161000' WHERE kode_barcode='00366248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3030000',harga_beli ='3030000' WHERE kode_barcode='00366676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00367014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00367310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00367462' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='10249500',harga_beli ='10249500' WHERE kode_barcode='00367478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5073500',harga_beli ='5073500' WHERE kode_barcode='00367480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5453500',harga_beli ='5453500' WHERE kode_barcode='00367481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4108000',harga_beli ='4108000' WHERE kode_barcode='00367488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3030000',harga_beli ='3030000' WHERE kode_barcode='00367489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1119500',harga_beli ='1119500' WHERE kode_barcode='00367495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2465000',harga_beli ='2465000' WHERE kode_barcode='00367540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7158500',harga_beli ='7158500' WHERE kode_barcode='00367805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3050500',harga_beli ='3050500' WHERE kode_barcode='00367852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6162000',harga_beli ='6162000' WHERE kode_barcode='00367861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2208500',harga_beli ='2208500' WHERE kode_barcode='00367880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00367882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00367883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2598500',harga_beli ='2598500' WHERE kode_barcode='00367886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00367903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00368156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00368406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5135000',harga_beli ='5135000' WHERE kode_barcode='00368581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4057000',harga_beli ='4057000' WHERE kode_barcode='00368582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00368596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00368759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00368809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00368843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2064500',harga_beli ='2064500' WHERE kode_barcode='00368895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00369329' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='503500',harga_beli ='503500' WHERE kode_barcode='00369350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='739500',harga_beli ='739500' WHERE kode_barcode='00369352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00369360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='698500',harga_beli ='698500' WHERE kode_barcode='00369364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='781000',harga_beli ='781000' WHERE kode_barcode='00369446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='852500',harga_beli ='852500' WHERE kode_barcode='00369466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='442000',harga_beli ='442000' WHERE kode_barcode='00369528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='668000',harga_beli ='668000' WHERE kode_barcode='00369533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00369545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5248000',harga_beli ='5248000' WHERE kode_barcode='00369610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5032500',harga_beli ='5032500' WHERE kode_barcode='00369614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00369633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1243000',harga_beli ='1243000' WHERE kode_barcode='00369684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2783500',harga_beli ='2783500' WHERE kode_barcode='00369705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00369890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00370010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00370183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2937500',harga_beli ='2937500' WHERE kode_barcode='00370374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00370387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1150500',harga_beli ='1150500' WHERE kode_barcode='00370405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00370507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00370556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00370557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7035000',harga_beli ='7035000' WHERE kode_barcode='00370572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1951500',harga_beli ='1951500' WHERE kode_barcode='00370576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3122500',harga_beli ='3122500' WHERE kode_barcode='00370578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='8052000',harga_beli ='8052000' WHERE kode_barcode='00370579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='8278000',harga_beli ='8278000' WHERE kode_barcode='00370580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2270000',harga_beli ='2270000' WHERE kode_barcode='00370587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5433000',harga_beli ='5433000' WHERE kode_barcode='00370596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5166000',harga_beli ='5166000' WHERE kode_barcode='00370600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00370604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1900000',harga_beli ='1900000' WHERE kode_barcode='00370609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00370612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3143000',harga_beli ='3143000' WHERE kode_barcode='00370618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1232500',harga_beli ='1232500' WHERE kode_barcode='00370622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00370637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2311000',harga_beli ='2311000' WHERE kode_barcode='00370675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00370748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='00370817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00370818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00370827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='657500',harga_beli ='657500' WHERE kode_barcode='00370829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='709000',harga_beli ='709000' WHERE kode_barcode='00370830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='852500',harga_beli ='852500' WHERE kode_barcode='00371009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='852500',harga_beli ='852500' WHERE kode_barcode='00371035' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00371036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00371043' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00371044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00371046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1417500',harga_beli ='1417500' WHERE kode_barcode='00371513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00371665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00371668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00371685' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00371741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00371743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='688500',harga_beli ='688500' WHERE kode_barcode='00371744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00371798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2958000',harga_beli ='2958000' WHERE kode_barcode='00371812' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='00371825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5258500',harga_beli ='5258500' WHERE kode_barcode='00371849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='472500',harga_beli ='472500' WHERE kode_barcode='00371889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00372039' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2249500',harga_beli ='2249500' WHERE kode_barcode='00372233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00372257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00372265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00372267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00372274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00372286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00372288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00372292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00372293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1962000',harga_beli ='1962000' WHERE kode_barcode='00372325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00372331' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00372332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='668000',harga_beli ='668000' WHERE kode_barcode='00372335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1489500',harga_beli ='1489500' WHERE kode_barcode='00372364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4005500',harga_beli ='4005500' WHERE kode_barcode='00372401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5566500',harga_beli ='5566500' WHERE kode_barcode='00372404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00372564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00372582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00372604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00372660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1571500',harga_beli ='1571500' WHERE kode_barcode='00372682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00372752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4447000',harga_beli ='4447000' WHERE kode_barcode='00372805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1458500',harga_beli ='1458500' WHERE kode_barcode='00372873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00372889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00372891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1366000',harga_beli ='1366000' WHERE kode_barcode='00372898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00372915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3091500',harga_beli ='3091500' WHERE kode_barcode='00373085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7117500',harga_beli ='7117500' WHERE kode_barcode='00373147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4642500',harga_beli ='4642500' WHERE kode_barcode='00373150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2537000',harga_beli ='2537000' WHERE kode_barcode='00373154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5002000',harga_beli ='5002000' WHERE kode_barcode='00373156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='678000',harga_beli ='678000' WHERE kode_barcode='00373501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='668000',harga_beli ='668000' WHERE kode_barcode='00373508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1951500',harga_beli ='1951500' WHERE kode_barcode='00373546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1725500',harga_beli ='1725500' WHERE kode_barcode='00373672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2095500',harga_beli ='2095500' WHERE kode_barcode='00373735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00373737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00373738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00373744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00373746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00373749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00373751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00373752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1561500',harga_beli ='1561500' WHERE kode_barcode='00373780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1592000',harga_beli ='1592000' WHERE kode_barcode='00373781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2506000',harga_beli ='2506000' WHERE kode_barcode='00373789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00373823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00373824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00373825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00373980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00373995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00374028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2362500',harga_beli ='2362500' WHERE kode_barcode='00374054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00374063' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4087500',harga_beli ='4087500' WHERE kode_barcode='00374067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2136500',harga_beli ='2136500' WHERE kode_barcode='00374098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4817000',harga_beli ='4817000' WHERE kode_barcode='00374177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4991500',harga_beli ='4991500' WHERE kode_barcode='00374186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3594500',harga_beli ='3594500' WHERE kode_barcode='00374225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3461500',harga_beli ='3461500' WHERE kode_barcode='00374242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3646000',harga_beli ='3646000' WHERE kode_barcode='00374245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2927000',harga_beli ='2927000' WHERE kode_barcode='00374254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1653500',harga_beli ='1653500' WHERE kode_barcode='00374259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00374273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='688500',harga_beli ='688500' WHERE kode_barcode='00374362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00374446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00374495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='00374502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2116000',harga_beli ='2116000' WHERE kode_barcode='00374562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00374570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='729500',harga_beli ='729500' WHERE kode_barcode='00374572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00374575' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00374576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00374578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='00374583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4262500',harga_beli ='4262500' WHERE kode_barcode='00374697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='657500',harga_beli ='657500' WHERE kode_barcode='00374909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00374943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2424000',harga_beli ='2424000' WHERE kode_barcode='00374990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1674500',harga_beli ='1674500' WHERE kode_barcode='00375233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00375248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00375249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00375250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00375253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1109500',harga_beli ='1109500' WHERE kode_barcode='00375356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3019500',harga_beli ='3019500' WHERE kode_barcode='00375365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00375460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00375482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00375505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00375594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00375658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4170000',harga_beli ='4170000' WHERE kode_barcode='00375740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6727000',harga_beli ='6727000' WHERE kode_barcode='00375752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5382000',harga_beli ='5382000' WHERE kode_barcode='00375753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3122500',harga_beli ='3122500' WHERE kode_barcode='00375759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00375765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5104500',harga_beli ='5104500' WHERE kode_barcode='00375770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5032500',harga_beli ='5032500' WHERE kode_barcode='00375772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3091500',harga_beli ='3091500' WHERE kode_barcode='00375779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00375780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1561500',harga_beli ='1561500' WHERE kode_barcode='00375819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2188000',harga_beli ='2188000' WHERE kode_barcode='00375838' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00375969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='472500',harga_beli ='472500' WHERE kode_barcode='00375991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='606000',harga_beli ='606000' WHERE kode_barcode='00375993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00376090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00376107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1109500',harga_beli ='1109500' WHERE kode_barcode='00376143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00376147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00376208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='976000',harga_beli ='976000' WHERE kode_barcode='00376216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00376217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='760500',harga_beli ='760500' WHERE kode_barcode='00376219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00376223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00376233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00376234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='431500',harga_beli ='431500' WHERE kode_barcode='00376241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2188000',harga_beli ='2188000' WHERE kode_barcode='00376251' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00376252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='503500',harga_beli ='503500' WHERE kode_barcode='00376253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00376261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='472500',harga_beli ='472500' WHERE kode_barcode='00376277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00376288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5186500',harga_beli ='5186500' WHERE kode_barcode='00376293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2064500',harga_beli ='2064500' WHERE kode_barcode='00376297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00376299' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3163500',harga_beli ='3163500' WHERE kode_barcode='00376302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6224000',harga_beli ='6224000' WHERE kode_barcode='00376303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='00376311' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00376313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2475500',harga_beli ='2475500' WHERE kode_barcode='00376340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00376365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1499500',harga_beli ='1499500' WHERE kode_barcode='00376375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5289500',harga_beli ='5289500' WHERE kode_barcode='00376527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7353500',harga_beli ='7353500' WHERE kode_barcode='00376542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2639500',harga_beli ='2639500' WHERE kode_barcode='00376543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2208500',harga_beli ='2208500' WHERE kode_barcode='00376545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00376579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='739500',harga_beli ='739500' WHERE kode_barcode='00376585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1900000',harga_beli ='1900000' WHERE kode_barcode='00376602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00376616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4026000',harga_beli ='4026000' WHERE kode_barcode='00376622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4026000',harga_beli ='4026000' WHERE kode_barcode='00376636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3369000',harga_beli ='3369000' WHERE kode_barcode='00376638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1623000',harga_beli ='1623000' WHERE kode_barcode='00376640' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00376702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='935000',harga_beli ='935000' WHERE kode_barcode='00376711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00376792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00376793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00376811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='442000',harga_beli ='442000' WHERE kode_barcode='00376812' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00376820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00376821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00376822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00376823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00376824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5320000',harga_beli ='5320000' WHERE kode_barcode='00376835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3266000',harga_beli ='3266000' WHERE kode_barcode='00376840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3420000',harga_beli ='3420000' WHERE kode_barcode='00376860' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1551000',harga_beli ='1551000' WHERE kode_barcode='00376871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1489500',harga_beli ='1489500' WHERE kode_barcode='00376873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2732000',harga_beli ='2732000' WHERE kode_barcode='00376902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2824500',harga_beli ='2824500' WHERE kode_barcode='00376903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='791000',harga_beli ='791000' WHERE kode_barcode='00376957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='760500',harga_beli ='760500' WHERE kode_barcode='00376958' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00376959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00376964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00376966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00376970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00376977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00376980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='00377033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6213500',harga_beli ='6213500' WHERE kode_barcode='00377049' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4796500',harga_beli ='4796500' WHERE kode_barcode='00377052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3697500',harga_beli ='3697500' WHERE kode_barcode='00377054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3215000',harga_beli ='3215000' WHERE kode_barcode='00377055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1551000',harga_beli ='1551000' WHERE kode_barcode='00377101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3985000',harga_beli ='3985000' WHERE kode_barcode='00377138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00377256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00377257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00377263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00377264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00377266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00377267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00377280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='7189000',harga_beli ='7189000' WHERE kode_barcode='00377317' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00377373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00377376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2722000',harga_beli ='2722000' WHERE kode_barcode='00377377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2773000',harga_beli ='2773000' WHERE kode_barcode='00377378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1725500',harga_beli ='1725500' WHERE kode_barcode='00377379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00377380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00377410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00377417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3132500',harga_beli ='3132500' WHERE kode_barcode='00377471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3594500',harga_beli ='3594500' WHERE kode_barcode='00377481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='935000',harga_beli ='935000' WHERE kode_barcode='00377490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='8237000',harga_beli ='8237000' WHERE kode_barcode='00377497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3040000',harga_beli ='3040000' WHERE kode_barcode='00377509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00377559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='606000',harga_beli ='606000' WHERE kode_barcode='00377560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='442000',harga_beli ='442000' WHERE kode_barcode='00377561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00377572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='442000',harga_beli ='442000' WHERE kode_barcode='00377573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3204500',harga_beli ='3204500' WHERE kode_barcode='00377574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2557500',harga_beli ='2557500' WHERE kode_barcode='00377576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00377610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00377611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1130000',harga_beli ='1130000' WHERE kode_barcode='00377636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='729500',harga_beli ='729500' WHERE kode_barcode='00377679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00377682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3317500',harga_beli ='3317500' WHERE kode_barcode='00377750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1469000',harga_beli ='1469000' WHERE kode_barcode='00377752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6080000',harga_beli ='6080000' WHERE kode_barcode='00377756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2506000',harga_beli ='2506000' WHERE kode_barcode='00377758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2372500',harga_beli ='2372500' WHERE kode_barcode='00377759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1787500',harga_beli ='1787500' WHERE kode_barcode='00377761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2239000',harga_beli ='2239000' WHERE kode_barcode='00377894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1448500',harga_beli ='1448500' WHERE kode_barcode='00377895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2146500',harga_beli ='2146500' WHERE kode_barcode='00378100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3235500',harga_beli ='3235500' WHERE kode_barcode='00378102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='863000',harga_beli ='863000' WHERE kode_barcode='00378104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='945000',harga_beli ='945000' WHERE kode_barcode='00378105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='863000',harga_beli ='863000' WHERE kode_barcode='00378106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00378113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00378114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00378174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3102000',harga_beli ='3102000' WHERE kode_barcode='00378178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4129000',harga_beli ='4129000' WHERE kode_barcode='00378179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4129000',harga_beli ='4129000' WHERE kode_barcode='00378180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3215000',harga_beli ='3215000' WHERE kode_barcode='00378181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00378182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2455000',harga_beli ='2455000' WHERE kode_barcode='00378184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1078500',harga_beli ='1078500' WHERE kode_barcode='00378185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00378196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00378198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00378199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2516500',harga_beli ='2516500' WHERE kode_barcode='00378336' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00378341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1725500',harga_beli ='1725500' WHERE kode_barcode='00378350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00378353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4344500',harga_beli ='4344500' WHERE kode_barcode='00378354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00378377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00378378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00378379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='678000',harga_beli ='678000' WHERE kode_barcode='00378380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00378442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00378451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00378454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2239000',harga_beli ='2239000' WHERE kode_barcode='00378465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='6932500',harga_beli ='6932500' WHERE kode_barcode='00378473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3030000',harga_beli ='3030000' WHERE kode_barcode='00378478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00378479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00378487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2270000',harga_beli ='2270000' WHERE kode_barcode='00378490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00378525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00378592' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00378613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='10763000',harga_beli ='10763000' WHERE kode_barcode='00378698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00378705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2116000',harga_beli ='2116000' WHERE kode_barcode='00378761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2064500',harga_beli ='2064500' WHERE kode_barcode='00378836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1972000',harga_beli ='1972000' WHERE kode_barcode='00378837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1962000',harga_beli ='1962000' WHERE kode_barcode='00378838' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00378839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2116000',harga_beli ='2116000' WHERE kode_barcode='00378840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00378846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='781000',harga_beli ='781000' WHERE kode_barcode='00378847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3030000',harga_beli ='3030000' WHERE kode_barcode='00378890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2537000',harga_beli ='2537000' WHERE kode_barcode='00378945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='647500',harga_beli ='647500' WHERE kode_barcode='00378946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00378947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5217500',harga_beli ='5217500' WHERE kode_barcode='00378949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4591000',harga_beli ='4591000' WHERE kode_barcode='00378950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2588500',harga_beli ='2588500' WHERE kode_barcode='00378951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2157000',harga_beli ='2157000' WHERE kode_barcode='00378952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2136500',harga_beli ='2136500' WHERE kode_barcode='00378953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2033500',harga_beli ='2033500' WHERE kode_barcode='00378954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00378955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1263500',harga_beli ='1263500' WHERE kode_barcode='00378956' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2126000',harga_beli ='2126000' WHERE kode_barcode='00378957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1715500',harga_beli ='1715500' WHERE kode_barcode='00378958' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1715500',harga_beli ='1715500' WHERE kode_barcode='00378959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1037500',harga_beli ='1037500' WHERE kode_barcode='00378960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1037500',harga_beli ='1037500' WHERE kode_barcode='00378961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='00379047' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1777000',harga_beli ='1777000' WHERE kode_barcode='00379125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3132500',harga_beli ='3132500' WHERE kode_barcode='00379126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1428000',harga_beli ='1428000' WHERE kode_barcode='00379127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1366000',harga_beli ='1366000' WHERE kode_barcode='00379128' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1499500',harga_beli ='1499500' WHERE kode_barcode='00379129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2157000',harga_beli ='2157000' WHERE kode_barcode='00379130' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00379131' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='657500',harga_beli ='657500' WHERE kode_barcode='00379132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00379142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='719000',harga_beli ='719000' WHERE kode_barcode='00379147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00379148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00379149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1448500',harga_beli ='1448500' WHERE kode_barcode='00379156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3091500',harga_beli ='3091500' WHERE kode_barcode='00379157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1006500',harga_beli ='1006500' WHERE kode_barcode='00379160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1006500',harga_beli ='1006500' WHERE kode_barcode='00379161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5556500',harga_beli ='5556500' WHERE kode_barcode='00379162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00379163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='472500',harga_beli ='472500' WHERE kode_barcode='00379164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00379165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00379167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00379168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='483000',harga_beli ='483000' WHERE kode_barcode='00379169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='801500',harga_beli ='801500' WHERE kode_barcode='00379173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='472500',harga_beli ='472500' WHERE kode_barcode='00379174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00379175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00379176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00379177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00379178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2639500',harga_beli ='2639500' WHERE kode_barcode='00379319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2362500',harga_beli ='2362500' WHERE kode_barcode='00379320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00379321' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1212000',harga_beli ='1212000' WHERE kode_barcode='00379322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00379323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='00379324' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1715500',harga_beli ='1715500' WHERE kode_barcode='00379325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='709000',harga_beli ='709000' WHERE kode_barcode='00379376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00379379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00379381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00379386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00379387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00379389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='616500',harga_beli ='616500' WHERE kode_barcode='00379415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00379417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00379541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00379548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='637000',harga_beli ='637000' WHERE kode_barcode='00379556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00379557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='626500',harga_beli ='626500' WHERE kode_barcode='00379558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00379559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4570500',harga_beli ='4570500' WHERE kode_barcode='00379573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2218500',harga_beli ='2218500' WHERE kode_barcode='00379598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00379611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='5032500',harga_beli ='5032500' WHERE kode_barcode='00379613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2003000',harga_beli ='2003000' WHERE kode_barcode='00379646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2670500',harga_beli ='2670500' WHERE kode_barcode='00379647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2526500',harga_beli ='2526500' WHERE kode_barcode='00379648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1037500',harga_beli ='1037500' WHERE kode_barcode='00379649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1037500',harga_beli ='1037500' WHERE kode_barcode='00379650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='00379720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1058000',harga_beli ='1058000' WHERE kode_barcode='00379721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00379798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2105500',harga_beli ='2105500' WHERE kode_barcode='00379799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00379800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1109500',harga_beli ='1109500' WHERE kode_barcode='00379801' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1099000',harga_beli ='1099000' WHERE kode_barcode='00379802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1674500',harga_beli ='1674500' WHERE kode_barcode='00379803' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00379804' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00379805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00379806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='462500',harga_beli ='462500' WHERE kode_barcode='00379807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00379808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='524000',harga_beli ='524000' WHERE kode_barcode='00379809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='534500',harga_beli ='534500' WHERE kode_barcode='00379810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='976000',harga_beli ='976000' WHERE kode_barcode='00379811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='996500',harga_beli ='996500' WHERE kode_barcode='00379812' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1417500',harga_beli ='1417500' WHERE kode_barcode='00379813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1715500',harga_beli ='1715500' WHERE kode_barcode='00379814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='00379815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='575500',harga_beli ='575500' WHERE kode_barcode='00379816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='544500',harga_beli ='544500' WHERE kode_barcode='00379966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='565000',harga_beli ='565000' WHERE kode_barcode='00379976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00379977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='411000',harga_beli ='411000' WHERE kode_barcode='00379998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='493000',harga_beli ='493000' WHERE kode_barcode='00380021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='513500',harga_beli ='513500' WHERE kode_barcode='00380022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00380032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3163500',harga_beli ='3163500' WHERE kode_barcode='00380035' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='4509000',harga_beli ='4509000' WHERE kode_barcode='00380040' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='00380043' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1777000',harga_beli ='1777000' WHERE kode_barcode='00380057' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='2413500',harga_beli ='2413500' WHERE kode_barcode='00380066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='1191500',harga_beli ='1191500' WHERE kode_barcode='00380068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1027000',harga_jual='3040000',harga_beli ='3040000' WHERE kode_barcode='00380069' LIMIT 1;
UPDATE tm_group SET harga='1027000' WHERE kode_group = 'ME' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('ME','1027000','input','2025-12-08 12:11:45');
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 ('F325081212431','input','1',' MEA1E X BW','TOKO','PM-A','A1E-YLXF-161-0','AT X ITALY SLEP VAR BW 8K ','','0.580','1','100.00','596000','0','0','15000','595000','0','0','0','595000','SIN','00379977','A1E','0','0','-','1','1027000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXF-161-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='A1E-YLXF-161-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325081212431','2025-12-08','0.580','2025-12-08','12:12:44','PLG0026085','595000','595000','0','595000','595000','input','2025-12-08 12:12:43','F32508121243');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081212431','2025-12-08','12:12:44','SIN','595000','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-251208-0013','D','2025-12-08','12:12:44','input','PENJUALAN','F325081212431','1073633000','595000','1074228000');
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 ('F325081213101','input','1',' MEH1 X LG ','TOKO','PM-H','H1E-YKXH-119-0','KL X TIFF DAUN SLEP LG 8K ','','2.660','1','100.00','2732000','0','0','15000','2733000','0','0','0','2733000','SIN','00376902','H1E','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXH-119-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.660',berat_jual_asli=berat_jual_asli+'2.660',stock_jual='1',berat_akhir=berat_akhir-'2.660',berat_akhir_asli=berat_akhir_asli-'2.660',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='H1E-YKXH-119-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 ('F325081213101','2025-12-08','2.660','2025-12-08','12:13:10','PLG0026086','2733000','2733000','0','2733000','2733000','input','2025-12-08 12:13:10','F32508121310');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081213101','2025-12-08','12:13:10','SIN','2733000','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-251208-0014','D','2025-12-08','12:13:10','input','PENJUALAN','F325081213101','1074228000','2733000','1076961000');
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 ('F325081213401','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-YKBH-104-0','CC MODEL DAUN VAR CM 14 8K ','','0.860','1','100.00','866000','0','0','15000','865000','0','0','0','865000','SIN','00378965','E1D','0','0','-','1','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBH-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='E1D-YKBH-104-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 ('F325081213401','2025-12-08','0.860','2025-12-08','12:13:40','PLG0026087','865000','865000','0','865000','865000','input','2025-12-08 12:13:40','F32508121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081213401','2025-12-08','12:13:40','SIN','865000','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-251208-0015','D','2025-12-08','12:13:40','input','PENJUALAN','F325081213401','1076961000','865000','1077826000');
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 ('F325081214031','input','1',' MEF3E X HW','TOKO','PM-F','F3E-XJXA-198-0','GL X CAPELLA ARESO PASIR HW 8K ','','2.160','1','100.00','2218000','0','0','15000','2220000','0','0','0','2220000','FIT','00319599','F3E','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-XJXA-198-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F3E-XJXA-198-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 ('F325081214031','2025-12-08','2.160','2025-12-08','12:14:04','PLG0026088','2220000','2220000','0','2220000','2220000','input','2025-12-08 12:14:03','F32508121403');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081214031','2025-12-08','12:14:04','FIT','2220000','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-251208-0016','D','2025-12-08','12:14:04','input','PENJUALAN','F325081214031','1077826000','2220000','1080046000');
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 ('F325081235031','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-YLXD-12-0','KL X MILANO UB 42 8K ','','2.160','1','100.00','2218000','0','0','15000','2220000','0','0','0','2220000','SIN','00379598','H1E','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLXD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='H1E-YLXD-12-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 ('F325081235031','2025-12-08','2.160','2025-12-08','12:35:04','PLG0026089','2220000','2220000','0','2220000','2220000','input','2025-12-08 12:35:03','F32508123503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081235031','2025-12-08','12:35:04','SIN','2220000','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-251208-0017','D','2025-12-08','12:35:04','input','PENJUALAN','F325081235031','1080046000','2220000','1082266000');
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-00017635','X-00017635','GL LEMES 8K','GR','---','F3E','BELI','BELI001','2590000','2025-12-08','3.710','1','kasir','2025-12-08 12:47:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017635','X-00017635');
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-251208-0004','00293143','AAT','1','BELI','BELI001','F3E', 'X-00017635', 'GL LEMES 8K','3.710','3.710','100.00','2226000','2590000','698113','1027000','1','2590000','2590000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.710',berat_beli_asli=berat_beli_asli+'3.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.710',berat_akhir_asli=berat_akhir_asli+'3.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-08' 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-251208-0004','2025-12-08','2025-12-08','12:47:45','AAT','---','3.710','2590000','2590000','2590000','2590000','2590000','kasir','2025-12-08 12:47:45','FB-251208-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251208-0004','YUNI','BITING','','','','kasir','2025-12-08 12:47:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-08' 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-251208-0018','K','2025-12-08','12:47:45','kasir','PEMBELIAN UMUM','FB-251208-0004','1082266000','2590000','1079676000');
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-00017636','X-00017636','AT BABY TINDIK SLEP DG 8K','GR','---','A1H','BELI','BELI001','235000','2025-12-08','0.270','1','kasir','2025-12-08 12:48:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1H','X-00017636','X-00017636');
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-251208-0005','F325210820381','FIT','1','BELI','BELI001','A1H', 'X-00017636', 'AT BABY TINDIK SLEP DG 8K','0.270','0.270','100.00','263000','235000','870370','1097000','1','235000','235000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.270',berat_beli_asli=berat_beli_asli+'0.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.270',berat_akhir_asli=berat_akhir_asli+'0.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1H' 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-251208-0005','2025-12-08','2025-12-08','12:48:48','FIT','---','0.270','235000','235000','235000','235000','235000','kasir','2025-12-08 12:48:48','FB-251208-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251208-0005','VELYN','KEPYAR','','','','kasir','2025-12-08 12:48:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-08' 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-251208-0019','K','2025-12-08','12:48:48','kasir','PEMBELIAN UMUM','FB-251208-0005','1079676000','235000','1079441000');
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 ('F325081259381','kasir','1',' MIH2 X KH ','TOKO','PM-H','H2I-YKAA-169-0','KL X SANTA KH 44 9K ','','1.500','1','100.00','1660000','0','0','15000','1660000','0','0','0','1660000','SIN','00377135','H2I','0','0','-','0','1117000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YKAA-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='H2I-YKAA-169-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 ('F325081259381','2025-12-08','1.500','2025-12-08','12:59:39','PLG0026090','1660000','1660000','0','1660000','1660000','kasir','2025-12-08 12:59:38','F32508125938');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325081259381','2025-12-08','12:59:39','SIN','1660000','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-251208-0020','D','2025-12-08','12:59:39','kasir','PENJUALAN','F325081259381','1079441000','1660000','1081101000');
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 ('F325080100091','kasir','1',' MED2E X LG','TOKO','PM-D','D2E-YKXH-38-0','LT X MODEL MATA LG 8K ','','0.520','1','100.00','534000','0','0','15000','535000','0','0','0','535000','SIN','00376821','D2E','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YKXH-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='D2E-YKXH-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325080100091','2025-12-08','0.520','2025-12-08','13:00:10','PLG0026091','535000','535000','0','535000','535000','kasir','2025-12-08 13:00:09','F32508010009');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325080100091','2025-12-08','13:00:10','SIN','535000','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-251208-0021','D','2025-12-08','13:00:10','kasir','PENJUALAN','F325080100091','1081101000','535000','1081636000');
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 ('F325080101521','kasir','1',' MEF3 HW ','TOKO','PM-F','F3E-YKBI-160-0','GL RANTAI HOLLOW MODEL DAUN VAR HW 8K ','','3.050','1','100.00','3132000','0','0','15000','3133000','0','0','0','3133000','AAT','00379126','F3E','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBI-160-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F3E-YKBI-160-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 ('F325080101521','2025-12-08','3.050','2025-12-08','13:01:53','PLG0026092','3133000','3133000','0','3133000','3133000','kasir','2025-12-08 13:01:52','F32508010152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325080101521','2025-12-08','13:01:53','AAT','3133000','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-251208-0022','D','2025-12-08','13:01:53','kasir','PENJUALAN','F325080101521','1081636000','3133000','1084769000');
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-00017637','X-00017637','GL MODEL GENIA UB 8K','GR','---','F3E','BELI','BELI001','437000','2025-12-08','0.520','1','kasir','2025-12-08 14:19:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017637','X-00017637');
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-251208-0006','F325270139331','FIT','1','BELI','BELI001','F3E', 'X-00017637', 'GL MODEL GENIA UB 8K','0.520','0.520','100.00','528000','437000','840385','1027000','1','437000','437000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-08' 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-251208-0006','2025-12-08','2025-12-08','14:19:02','FIT','---','0.520','437000','437000','437000','437000','437000','kasir','2025-12-08 14:19:02','FB-251208-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251208-0006','EKA','BUGELAN KISMANTORO','','','','kasir','2025-12-08 14:19:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-08' 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-251208-0023','K','2025-12-08','14:19:02','kasir','PEMBELIAN UMUM','FB-251208-0006','1084769000','437000','1084332000');
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 ('F325080225351','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-YKAG-182-0','GL SANTA SERUT MODEL SLEP VAR UB 8K ','','2.310','1','100.00','2372000','0','0','15000','2373000','0','0','0','2373000','FIT','00377759','F3E','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2025-12-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKAG-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2025-12-08' AND kode_barang='F3E-YKAG-182-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 ('F325080225351','2025-12-08','2.310','2025-12-08','14:25:35','PLG0026093','2373000','2373000','0','2373000','2373000','kasir','2025-12-08 14:25:35','F32508022535');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-08','F325080225351','2025-12-08','14:25:35','FIT','2373000','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-251208-0024','D','2025-12-08','14:25:35','kasir','PENJUALAN','F325080225351','1084332000','2373000','1086705000');
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-00017638','X-00017638','GL TIFF SLEP UB 8K','GR','---','F3E','BELI','BELI001','480000','2025-12-08','0.510','1','kasir','2025-12-08 14:33:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017638','X-00017638');
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-251208-0007','F325170939081','AAT','1','BELI','BELI001','F3E', 'X-00017638', 'GL TIFF SLEP UB 8K','0.510','0.510','100.00','523000','480000','941176','1027000','1','480000','480000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-08' 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-251208-0007','2025-12-08','2025-12-08','14:33:23','AAT','---','0.510','480000','480000','480000','480000','480000','kasir','2025-12-08 14:33:24','FB-251208-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251208-0007','ANINDIA','SIDOWAYAH','','','','kasir','2025-12-08 14:33:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-08' 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-251208-0025','K','2025-12-08','14:33:23','kasir','PEMBELIAN UMUM','FB-251208-0007','1086705000','480000','1086225000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251208-0001','1','F3E-YKAI-181-0','1','3.150','3.150','TOKO','PM-F','TOKO','SBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-F' WHERE kode_barang='F3E-YKAI-181-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-08','TOKO','SBK-F','F3E','F3E-YKAI-181-0','100.00','1','3.150','3.150','1','3.150','3.150');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.150',berat_out_asli=berat_out_asli+'3.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-08' AND kode_barang='F3E-YKAI-181-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251208-0001','2025-12-08','2025-12-08','14:37','3.15','input','2025-12-08 14:38:23');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251208-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251208-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251208-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251208-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251208-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251208-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251208-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251208-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251208-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251208-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251208-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251208-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251208-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251208-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080100091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080100091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080100091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080101521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080101521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080101521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080225351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080225351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080225351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325080825361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325080825361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325080825361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081010591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081010591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081010591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081013271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081013271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081013271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081055561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081055561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081055561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081109441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081109441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081109441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081138251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081138251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081138251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081149521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081149521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081149521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081155231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081155231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081155231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081212431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081212431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081212431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081213101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081213101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081213101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081213401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081213401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081213401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081214031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081214031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081214031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081235031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081235031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081235031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325081259381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325081259381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325081259381';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-08';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-08';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-08' 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-251209-0001','D','2025-12-09','15:25:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','1086225000','1086225000');
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-251209-0001','D','2025-12-09','15:25:14','BCA','SALDO AWAL','SALDO AWAL','0','694074000','694074000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251209-0001','D','2025-12-09','15:25:14','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-251209-0001','D','2025-12-09','15:25:14','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-12-09';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','A1E-YKXA-81-0','1','0.520','0.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YKXA-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YKXA-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-09 17:07:25' WHERE kode_barang='A1E-YKXA-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YKXA-81-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:25','TOKO','PM-A','A1E','A1E-YKXA-81-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YKXA-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YKXA-81-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','A1E-YLXC-58-0','1','0.580','0.580','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLXC-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLXC-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-09 17:07:25' WHERE kode_barang='A1E-YLXC-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLXC-58-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:25','TOKO','PM-A','A1E','A1E-YLXC-58-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YLXC-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLXC-58-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251209-0001','2025-12-09','17:07','1.100','admpindah','2025-12-08 17:07:24');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2E-YLXH-25-0','1','0.840','0.840','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YLXH-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YLXH-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2E-YLXH-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YLXH-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2E','E2E-YLXH-25-0','1','0.840','0.840','1','0.840','0.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YLXH-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YLXH-25-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2E-YLXH-26-0','1','0.940','0.940','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YLXH-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YLXH-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2E-YLXH-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YLXH-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2E','E2E-YLXH-26-0','1','0.940','0.940','1','0.940','0.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YLXH-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YLXH-26-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2D-YLXH-30-0','1','0.970','0.970','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YLXH-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YLXH-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2D-YLXH-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YLXH-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2D','E2D-YLXH-30-0','1','0.970','0.970','1','0.970','0.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YLXH-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXH-30-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2D-YLXH-48-0','1','1.080','1.080','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YLXH-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YLXH-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2D-YLXH-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YLXH-48-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2D','E2D-YLXH-48-0','1','1.080','1.080','1','1.080','1.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YLXH-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXH-48-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2D-YLXH-50-0','1','1.050','1.050','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YLXH-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YLXH-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2D-YLXH-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YLXH-50-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2D','E2D-YLXH-50-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YLXH-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXH-50-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2E-YLXH-76-0','1','1.060','1.060','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YLXH-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YLXH-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2E-YLXH-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YLXH-76-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2E','E2E-YLXH-76-0','1','1.060','1.060','1','1.060','1.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YLXH-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YLXH-76-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2E-YLXH-77-0','1','0.730','0.730','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YLXH-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YLXH-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2E-YLXH-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YLXH-77-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2E','E2E-YLXH-77-0','1','0.730','0.730','1','0.730','0.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YLXH-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YLXH-77-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2D-YLXH-79-0','1','0.850','0.850','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YLXH-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YLXH-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2D-YLXH-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YLXH-79-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2D','E2D-YLXH-79-0','1','0.850','0.850','1','0.850','0.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YLXH-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXH-79-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2E-YLXH-94-0','1','0.690','0.690','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YLXH-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YLXH-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2E-YLXH-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YLXH-94-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2E','E2E-YLXH-94-0','1','0.690','0.690','1','0.690','0.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YLXH-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YLXH-94-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2E-YLXH-96-0','1','0.710','0.710','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YLXH-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YLXH-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2E-YLXH-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YLXH-96-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2E','E2E-YLXH-96-0','1','0.710','0.710','1','0.710','0.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YLXH-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YLXH-96-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E2D-YLXH-97-0','1','0.810','0.810','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YLXH-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YLXH-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E2D-YLXH-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YLXH-97-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E2D','E2D-YLXH-97-0','1','0.810','0.810','1','0.810','0.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YLXH-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXH-97-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1E-YLXH-110-0','1','0.720','0.720','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-110-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-110-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1E-YLXH-110-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-110-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1E','E1E-YLXH-110-0','1','0.720','0.720','1','0.720','0.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-110-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-110-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1E-YLXH-112-0','1','0.580','0.580','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-112-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-112-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1E-YLXH-112-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-112-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1E','E1E-YLXH-112-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-112-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-112-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1E-YLXH-113-0','1','0.670','0.670','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-113-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-113-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1E-YLXH-113-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-113-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1E','E1E-YLXH-113-0','1','0.670','0.670','1','0.670','0.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-113-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-113-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1D-YLXH-114-0','1','0.900','0.900','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLXH-114-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLXH-114-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1D-YLXH-114-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLXH-114-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1D','E1D-YLXH-114-0','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YLXH-114-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLXH-114-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1E-YLXH-115-0','1','0.420','0.420','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-115-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-115-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1E-YLXH-115-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-115-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1E','E1E-YLXH-115-0','1','0.420','0.420','1','0.420','0.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-115-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-115-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1E-YLXH-116-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-116-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-116-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1E-YLXH-116-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-116-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1E','E1E-YLXH-116-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-116-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-116-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1E-YLXH-117-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-117-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-117-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1E-YLXH-117-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-117-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1E','E1E-YLXH-117-0','1','0.460','0.460','1','0.460','0.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-117-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-117-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1D-YLXH-119-0','1','1.410','1.410','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLXH-119-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLXH-119-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1D-YLXH-119-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLXH-119-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1D','E1D-YLXH-119-0','1','1.410','1.410','1','1.410','1.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YLXH-119-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLXH-119-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1D-YLXH-125-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLXH-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLXH-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1D-YLXH-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLXH-125-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1D','E1D-YLXH-125-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YLXH-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLXH-125-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1D-YLXH-126-0','1','1.010','1.010','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLXH-126-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLXH-126-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1D-YLXH-126-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLXH-126-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1D','E1D-YLXH-126-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YLXH-126-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLXH-126-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','E1D-YLXH-142-0','1','2.060','2.060','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLXH-142-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLXH-142-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-09 17:07:43' WHERE kode_barang='E1D-YLXH-142-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLXH-142-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:07:43','TOKO','PM-E','E1D','E1D-YLXH-142-0','1','2.060','2.060','1','2.060','2.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YLXH-142-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLXH-142-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251209-0001','2025-12-09','17:07','20.010','admpindah','2025-12-08 17:07:42');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','H2J-YLXF-287-0','1','1.970','1.970','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YLXF-287-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YLXF-287-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-09 17:08:09' WHERE kode_barang='H2J-YLXF-287-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YLXF-287-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:08:09','TOKO','PM-H','H2J','H2J-YLXF-287-0','1','1.970','1.970','1','1.970','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YLXF-287-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YLXF-287-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251209-0001','1','H1E-YLXF-295-0','1','1.560','1.560','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLXF-295-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLXF-295-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-09 17:08:09' WHERE kode_barang='H1E-YLXF-295-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLXF-295-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-09 17:08:09','TOKO','PM-H','H1E','H1E-YLXF-295-0','1','1.560','1.560','1','1.560','1.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YLXF-295-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLXF-295-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251209-0001','2025-12-09','17:07','3.530','admpindah','2025-12-08 17:08:08');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251209-0001','1','F3E-YKAI-181-0','1','3.150','TOKO','SBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKAI-181-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YKAI-181-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-F';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3E-YKAI-181-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.150',berat_out_asli='3.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.150',berat_akhir_asli =berat_akhir_asli-'3.150' WHERE kode_barang='F3E-YKAI-181-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251209-0001','2025-12-09','2025-12-09','17:08','3.150','admpindah','251209');