RincianUpdateSeeder

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Str;

class RincianUpdateSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {

        ini_set('memory_limit', '-1');





        $res = DB::table('rincian_belanja_aktivitas')->get()->toArray();


        foreach ($res as $key => $v) {
            $v = (array)$v;
            $jarr = json_decode($v['json'],true);

            $up = [
                'pagu' => intval(preg_replace("/([^0-9,\\,])/i", "", $jarr['pagu'])),
            ];
            DB::table('rincian_belanja_aktivitas')->where('id', $v['id'])->update($up);
            echo "Rincian Belanja Aktivitas -".$key." \033[32mSuccess ✔"."\033[37m.\n";
        }



        $res = DB::table('rincian_belanja_rincian')->get()->toArray();

        foreach ($res as $key => $v) {
            $v = (array)$v;
            $jarr = json_decode($v['json'],true);

            $up = [
                'harga' => $jarr['harga'],
                'jumlah' => intval(preg_replace("/([^0-9,\\,])/i", "", $jarr['jumlah'])) ,
                'kode_rekening' => substr_replace($jarr['kode_rekening'],'',4,1),
                'nmrek6' => $jarr['nmrek6'],
                'full_rekening' => substr_replace($jarr['kode_rekening'],'',4,1)." ".$jarr['nmrek6'],
            ];
            DB::table('rincian_belanja_rincian')->where('id', $v['id'])->update($up);

            echo "Rincian Belanja Rincian -".$key." \033[32mSuccess ✔"."\033[37m.\n";
        }


    }
}