Seed

ParliamentSeedApiController.php

<?php

namespace App\Http\Controllers\Api;

use App\Http\Controllers\Traits\APIResponser;
use App\Http\Controllers\Controller;
use App\Http\Resources\IncludedRepresentativeElectionRegion;
use App\Http\Resources\RepresentativeElectionRegionSeed;
use App\Models\Category;
use App\Models\Faq;
use App\Models\Party;
use App\Models\PyiThuElectionRegion;
use App\Models\Representative;
use Illuminate\Support\Facades\DB;

class ParliamentSeedApiController extends Controller
{
    use APIResponser;

    function getPyithuElectionSeed()
    {
        $parties = Party::with(['representatives' =>
            function ($query) {
                $query->where('election_region_type', "App\Models\PyiThuElectionRegion")
                    ->where('is_famous', 1);
            }
        ])->get()->sortByDesc(function ($query) {
            return $query->representatives->count();
        });

        $parties = $parties->values()->all();
        $representatives = [];

        foreach ($parties as $party) {
            foreach ($party->representatives as $representative) {
                $representative->party_id = $party['id'];
                $representative->party_color = $party['party_color'];
                $representative->english_name = $party['english_name'];

                array_push($representatives, $representative);
            }
        }

        return $this->respondCollection('success to get category.', RepresentativeElectionRegionSeed::collection($representatives));
    }
}