AddressSeeder

Complexity

Total Complexity

6

Size/Duplication

Total Lines	81
Duplicated Lines	14.81 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	run()	12	70	6

<?php

use Illuminate\Database\Seeder;
use Yajra\Address\Entities\City;
use Yajra\Address\Entities\Region;
use Yajra\Address\Entities\Barangay;
use Yajra\Address\Entities\Province;
use Rap2hpoutre\FastExcel\FastExcel;

class AddressSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     * @throws \Box\Spout\Common\Exception\IOException
     * @throws \Box\Spout\Common\Exception\UnsupportedTypeException
     * @throws \Box\Spout\Reader\Exception\ReaderNotOpenedException
     */
    public function run()
    {
        $publication = config('address.publication.path', __DIR__ . '/publication/PSGC_Publication_Dec2019.xlsx');
        $sheet       = config('address.publication.sheet', 4);

        $regions   = [];
        $provinces = [];
        $cities    = [];
        $barangays = [];

        $this->command->info(sprintf('Parsing PSA official PSGC publication (%s).', $publication));
        (new FastExcel)
            ->sheet($sheet)
            ->import($publication, function ($line) use (&$regions, &$provinces, &$cities, &$barangays) {
                $attributes              = [];
                $attributes['code']      = $line['Code'];
                $attributes['name']      = $line['Name'];
                $attributes['region_id'] = substr($attributes['code'], 0, 2);

                switch ($line['Geographic Level']) {
                    case 'Reg':
                        $regions[] = $attributes;
                        break;

                    case 'Dist':
                    case 'Prov':
                    case '':
                        $attributes['province_id'] = substr($attributes['code'], 0, 4);

                        $provinces[] = $attributes;
                        break;

                    case 'Bgy':

This code seems to be duplicated across your project.

                        $attributes['province_id'] = substr($attributes['code'], 0, 4);
                        $attributes['city_id']     = substr($attributes['code'], 0, 6);

                        $barangays[] = $attributes;
                        break;

                    default: // City, SubMun, Mun

This code seems to be duplicated across your project.

                        $attributes['province_id'] = substr($attributes['code'], 0, 4);
                        $attributes['city_id']     = substr($attributes['code'], 0, 6);

                        $cities[] = $attributes;
                        break;
                }
            });

        $this->command->info(sprintf('Seeding %s regions.', count($regions)));
        $region = config('address.models.region', Region::class);
        $region::query()->insert($regions);

        $this->command->info(sprintf('Seeding %s provinces.', count($provinces)));
        $province = config('address.models.province', Province::class);
        collect($provinces)->chunk(100)->each(function ($chunk) use ($province) {
            $province::query()->insert($chunk->toArray());
        });

        $city = config('address.models.city', City::class);
        $this->command->info(sprintf('Seeding %s cities & municipalities.', count($cities)));
        collect($cities)->chunk(100)->each(function ($chunk) use ($city) {
            $city::query()->insert($chunk->toArray());
        });

        $this->command->info(sprintf('Seeding %s barangays.', count($barangays)));
        $barangay = config('address.models.barangay', Barangay::class);
        collect($barangays)->chunk(100)->each(function ($chunk) use ($barangay) {
            $barangay::query()->insert($chunk->toArray());
        });
    }
}