Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/syn.corals.io/Corals/modules/CMS/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

$postClass = \Corals\Modules\CMS\Models\Post::class;

\DB::table('tags')->orderBy('tags.id')
    ->chunk(20, function ($oldTags) use ($postClass) {
        foreach ($oldTags as $oldTag) {
            $newTagId = \DB::table('utility_tags')->insertGetId([
                'name' => $oldTag->name,
                'slug' => $oldTag->slug,
                'module' => 'CMS',
                'status' => $oldTag->status
            ]);

            $oldPostTags = \DB::table('post_tag')->where('tag_id', $oldTag->id)->get();

            foreach ($oldPostTags as $postTag) {
                \DB::table('taggables')->insert([
                    'tag_id' => $newTagId,
                    'taggable_id' => $postTag->post_id,
                    'taggable_type' => $postClass
                ]);
            }
        }
    });

\Schema::dropIfExists('post_tag');
\Schema::dropIfExists('tags');