<?php

namespace Database\Seeders;

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

class BlockServiceSolutionTableSeeder extends Seeder
{
    private $entryBlockTable = 'block_service_solution';

    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        // Table already deleted in DatabaseSeeder

        DB::table($this->entryBlockTable)->insert(
            [
                // Capability D&E
                [
                    'service_solution_id'   => 1,
                    'block_id'              => 26,
                    'position'              => 1,
                ],
                [
                    'service_solution_id'   => 2,
                    'block_id'              => 26,
                    'position'              => 2,
                ],
                [
                    'service_solution_id'   => 3,
                    'block_id'              => 26,
                    'position'              => 3,
                ],
                [
                    'service_solution_id'   => 4,
                    'block_id'              => 26,
                    'position'              => 4,
                ],
                [
                    'service_solution_id'   => 5,
                    'block_id'              => 26,
                    'position'              => 5,
                ],
                [
                    'service_solution_id'   => 6,
                    'block_id'              => 26,
                    'position'              => 6,
                ],
                [
                    'service_solution_id'   => 7,
                    'block_id'              => 26,
                    'position'              => 7,
                ],

                    // Capability DSS
                [
                    'service_solution_id'   => 8,
                    'block_id'              => 27,
                    'position'              => 1,
                ],
                [
                    'service_solution_id'   => 9,
                    'block_id'              => 27,
                    'position'              => 2,
                ],
                [
                    'service_solution_id'   => 5,
                    'block_id'              => 27,
                    'position'              => 3,
                ],
                [
                    'service_solution_id'   => 10,
                    'block_id'              => 27,
                    'position'              => 4,
                ],
                [
                    'service_solution_id'   => 11,
                    'block_id'              => 27,
                    'position'              => 5,
                ],
                [
                    'service_solution_id'   => 3,
                    'block_id'              => 27,
                    'position'              => 6,
                ],
                [
                    'service_solution_id'   => 12,
                    'block_id'              => 27,
                    'position'              => 7,
                ],

                // Capability P&D
                [
                    'service_solution_id'   => 13,
                    'block_id'              => 28,
                    'position'              => 1,
                ],
                [
                    'service_solution_id'   => 14,
                    'block_id'              => 28,
                    'position'              => 2,
                ],
                [
                    'service_solution_id'   => 15,
                    'block_id'              => 28,
                    'position'              => 3,
                ],
                [
                    'service_solution_id'   => 16,
                    'block_id'              => 28,
                    'position'              => 4,
                ],
                [
                    'service_solution_id'   => 17,
                    'block_id'              => 28,
                    'position'              => 5,
                ],
                [
                    'service_solution_id'   => 18,
                    'block_id'              => 28,
                    'position'              => 6,
                ],
                [
                    'service_solution_id'   => 19,
                    'block_id'              => 28,
                    'position'              => 7,
                ],

                // Capability DD
                [
                    'service_solution_id'   => 20,
                    'block_id'              => 29,
                    'position'              => 1,
                ],
                [
                    'service_solution_id'   => 21,
                    'block_id'              => 29,
                    'position'              => 2,
                ],
                [
                    'service_solution_id'   => 22,
                    'block_id'              => 29,
                    'position'              => 3,
                ],
                [
                    'service_solution_id'   => 23,
                    'block_id'              => 29,
                    'position'              => 4,
                ],
                [
                    'service_solution_id'   => 24,
                    'block_id'              => 29,
                    'position'              => 5,
                ],
                [
                    'service_solution_id'   => 25,
                    'block_id'              => 29,
                    'position'              => 6,
                ],
                [
                    'service_solution_id'   => 26,
                    'block_id'              => 29,
                    'position'              => 7,
                ],
                [
                    'service_solution_id'   => 27,
                    'block_id'              => 29,
                    'position'              => 8,
                ],
                [
                    'service_solution_id'   => 28,
                    'block_id'              => 29,
                    'position'              => 9,
                ],

                // Capability DB
                [
                    'service_solution_id'   => 29,
                    'block_id'              => 30,
                    'position'              => 1,
                ],
                [
                    'service_solution_id'   => 30,
                    'block_id'              => 30,
                    'position'              => 2,
                ],
                [
                    'service_solution_id'   => 31,
                    'block_id'              => 30,
                    'position'              => 3,
                ],
                [
                    'service_solution_id'   => 32,
                    'block_id'              => 30,
                    'position'              => 4,
                ],
                [
                    'service_solution_id'   => 15,
                    'block_id'              => 30,
                    'position'              => 5,
                ],
                [
                    'service_solution_id'   => 17,
                    'block_id'              => 30,
                    'position'              => 6,
                ],

                // Capability DM
                [
                    'service_solution_id'   => 33,
                    'block_id'              => 31,
                    'position'              => 1,
                ],
                [
                    'service_solution_id'   => 34,
                    'block_id'              => 31,
                    'position'              => 2,
                ],
                [
                    'service_solution_id'   => 35,
                    'block_id'              => 31,
                    'position'              => 3,
                ],
                [
                    'service_solution_id'   => 36,
                    'block_id'              => 31,
                    'position'              => 4,
                ],
                [
                    'service_solution_id'   => 37,
                    'block_id'              => 31,
                    'position'              => 5,
                ],
                [
                    'service_solution_id'   => 38,
                    'block_id'              => 31,
                    'position'              => 6,
                ],
                [
                    'service_solution_id'   => 39,
                    'block_id'              => 31,
                    'position'              => 7,
                ],
                [
                    'service_solution_id'   => 40,
                    'block_id'              => 31,
                    'position'              => 7,
                ],

                // Grass4You Intro
                [
                    'service_solution_id'   => 41,
                    'block_id'              => 70,
                    'position'              => 1,
                ],
                [
                    'service_solution_id'   => 42,
                    'block_id'              => 70,
                    'position'              => 2,
                ],
                [
                    'service_solution_id'   => 43,
                    'block_id'              => 70,
                    'position'              => 3,
                ],
                [
                    'service_solution_id'   => 44,
                    'block_id'              => 70,
                    'position'              => 4,
                ],
                [
                    'service_solution_id'   => 45,
                    'block_id'              => 70,
                    'position'              => 5,
                ],
                [
                    'service_solution_id'   => 46,
                    'block_id'              => 70,
                    'position'              => 6,
                ],
            ]
        );
    }
}