UpdateSubKegiatan

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use DB;

class UpdateSubKegiatan extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        //
        $cid = 11;

        $data = DB::table('m_tkdn')->where('cid',$cid)->where('kode_kegiatan','like','0.00.06.2%')->get();

        foreach($data as $d){
            
            $originalKeg = $d->kode_kegiatan;
            $prefixKeg = substr($originalKeg, 4, 13);
            $kode_kegiatan = "2.10".$prefixKeg;

            $originalSub = $d->kode_subkegiatan;
            $prefixSub = substr($originalSub, 4, 30);
            $kode_subkegiatan = "2.10".$prefixSub;

            echo $kode_subkegiatan."\n";

            DB::table('m_tkdn')->where('id',$d->id)->where('cid',$cid)->update([
                'kode_kegiatan'=> $kode_kegiatan,
                'kode_subkegiatan' => $kode_subkegiatan
            ]);
        }

    }
}