<?php
namespace Database\Seeders;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;
use Modules\Candidate\Models\Category;
use Modules\Location\Models\Location;
use Modules\Media\Models\MediaFile;
use Modules\Review\Models\Review;
use Modules\Review\Models\ReviewMeta;
class CandidateSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $categories = [
            [
                'name'        => 'Accounting / Finance',
                'slug'        => Str::slug('Accounting Finance', '-'),
                'icon'        => 'icon flaticon-money-1',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Marketing',
                'slug'        => Str::slug('Marketing', '-'),
                'icon'        => 'icon flaticon-promotion',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Design',
                'slug'        => Str::slug('Design', '-'),
                'icon'        => 'icon flaticon-vector',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Development',
                'slug'        => Str::slug('Development', '-'),
                'icon'        => 'icon flaticon-web-programming',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Human Resource',
                'slug'        => Str::slug('Human Resource', '-'),
                'icon'        => 'icon flaticon-headhunting',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Project Management',
                'slug'        => Str::slug('Project Management', '-'),
                'icon'        => 'icon flaticon-rocket-ship',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Customer Service',
                'slug'        => Str::slug('Customer Service', '-'),
                'icon'        => 'icon flaticon-support-1',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Health and Care',
                'slug'        => Str::slug('Health and Care', '-'),
                'icon'        => 'icon flaticon-first-aid-kit-1',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ],
            [
                'name'        => 'Automotive Jobs',
                'slug'        => Str::slug('Automotive Jobs', '-'),
                'icon'        => 'icon flaticon-car',
                'status'      => 'publish',
                'created_at'  => date("Y-m-d H:i:s")
            ]
        ];

        foreach ($categories as $category){
                $row = new Category( $category );
                $row->save();
        }


        $medias = MediaFile::query()->where('file_name', 'LIKE', '%portfolio%')->limit(4)->pluck('id')->toArray();
        $gallery_images = implode(",", $medias);

        $gender = ['male', 'female'];
        $salaryType = ['hourly', 'daily', 'weekly', 'monthly'];
        $educationLevel = ['certificate', 'diploma', 'associate', 'bachelor', 'master', 'professional'];
        $maps = [
            'map_lat' => ['40.94401669296697','40.77055783505125','40.7427837','40.70437865245596','40.641311','41.080938','41.079386'],
            'map_lng' => ['-74.16938781738281','-74.26002502441406','-73.11445617675781','-73.98674011230469','-73.778139','-73.535957','-73.519478']
        ];

        $dataArr = \App\User::where('role_id', 3)->take(9)->get();
        $i = 1;
        foreach($dataArr as $data){
            $location = Location::find(rand(1, 5));
            DB::table('bc_candidates')->insert(
                [
                    'id' => $data->id,
                    'title' => 'UI Designer at Invision',
                    'gender'   => $gender[array_rand($gender)],
                    'allow_search'   => 'publish',
                    'create_user'   => $data->id,
                    'gallery'  => $gallery_images,
                    'video'     => 'https://www.youtube.com/watch?v=bhOiLfkChPo',
                    'video_cover_id' => MediaFile::findMediaByName('video-img')->id,
                    'created_at' =>  date("Y-m-d H:i:s"),
                    'slug' => Str::slug('UI Designer at Invision '.$i, '-'),
                    'expected_salary' => rand(100, 1000),
                    'salary_type' => $salaryType[array_rand($salaryType)],
                    'city' => $location->name,
                    'country' => 'US',
                    'languages' => 'English, German, Spanish',
                    'education_level' => $educationLevel[array_rand($educationLevel)],
                    'experience_year' => rand(0,5),
                    'map_lat' => $maps['map_lat'][$i - 1],
                    'map_lng' => $maps['map_lng'][$i - 1],
                    'map_zoom' => '16',
                    'location_id' => $location->id,
                    'education' => '[{"from":"2015","to":"2019","location":"Harvard University","reward":"MBA from Harvard Business School","information": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a ipsum tellus.<br/> Interdum et malesuada fames ac anteipsum primis in faucibus."},{"from":"2011","to":"2015","location":"Tomms College","reward":"Bachlors in Fine Arts","information": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a ipsum tellus.<br/> Interdum et malesuada fames ac anteipsum primis in faucibus."}]',
                    'experience' => '[{"from":"2015","to":"2019","location":"Google","position":"Web Designer","information": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a ipsum tellus.<br/> Interdum et malesuada fames ac anteipsum primis in faucibus."},{"from":"2011","to":"2015","location":"Facebook","position":"CEO Founder","information": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a ipsum tellus.<br/> Interdum et malesuada fames ac anteipsum primis in faucibus."},{"from":"2011","to":"2015","location":"Tomms College","position":"CEO Founder","information": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a ipsum tellus.<br/> Interdum et malesuada fames ac anteipsum primis in faucibus."}]',
                    'award' => '[{"from":"2015","to":"2019","location":"Harvard University","reward":"Perfect Attendance Programs","information": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a ipsum tellus.<br/> Interdum et malesuada fames ac anteipsum primis in faucibus."},{"from":"2011","to":"2015","location":"Tomms College","reward":"Top Performer Recognition","information": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a ipsum tellus.<br/> Interdum et malesuada fames ac anteipsum primis in faucibus."}]',
                    'social_media' => '{"skype":"superio.test","facebook":"https:\/\/superio.test\/","twitter":"https:\/\/superio.test\/","instagram":"https:\/\/superio.test\/","pinterest":"https:\/\/superio.test\/","dribbble":"https:\/\/superio.test\/","google":"https:\/\/superio.test\/","linkedin":"https:\/\/superio.test\/"}'
                ]
            );

            DB::table('bc_candidate_cvs')->insert(
                [
                    'file_id' => MediaFile::findMediaByName("resume_".$i)->id,
                    'origin_id' => $data->id,
                    'is_default' => 1,
                    'create_user' => $data->id,
                    'created_at' =>  date("Y-m-d H:i:s")
                ]
            );

            DB::table('bc_candidate_skills')->insert(
                [
                    [
                        'origin_id' => $data->id,
                        'skill_id' => rand(1,2),
                        'created_at'  => date("Y-m-d H:i:s")
                    ],
                    [
                        'origin_id' => $data->id,
                        'skill_id' => rand(3,4),
                        'created_at'  => date("Y-m-d H:i:s")
                    ],
                    [
                        'origin_id' => $data->id,
                        'skill_id' => rand(5,6),
                        'created_at'  => date("Y-m-d H:i:s")
                    ],
                    [
                        'origin_id' => $data->id,
                        'skill_id' => rand(7,8),
                        'created_at'  => date("Y-m-d H:i:s")
                    ]
                ]
            );

            DB::table('bc_candidate_categories')->insert(
                [
                    [
                        'origin_id' => $data->id,
                        'cat_id' => rand(1,5),
                        'created_at'  => date("Y-m-d H:i:s")
                    ],
                    [
                        'origin_id' => $data->id,
                        'cat_id' => rand(6,9),
                        'created_at'  => date("Y-m-d H:i:s")
                    ]
                ]
            );

            $i++;
        }



        // Settings
        DB::table('core_settings')->insert(
            [
                [
                    'name' => 'candidate_page_search_title',
                    'val' => 'Find Candidates',
                ],
                [
                    'name' => 'candidate_page_search_title_ja',
                    'val' => '仕事を探す',
                ],
                [
                    'name' => 'candidate_list_layout',
                    'val' => 'v1',
                ],
                [
                    'name' => 'candidate_single_layout',
                    'val' => 'v1',
                ],
                [
                    'name' => 'candidate_sidebar_search_fields',
                    'val' => '[
                        {"title":"Search by Keywords","type":"keyword","position":"1"},
                        {"title":"Location","type":"location","position":"2"},
                        {"title":"Category","type":"category","position":"3"},
                        {"title":"Skills","type":"skill","position":"4"},
                        {"title":"Date Posted","type":"date_posted","position":"5"},
                        {"title":"Experience Level","type":"experience","position":"6"},
                        {"title":"Education Levels","type":"education","position":"7"}

                    ]',
                ],
                [
                    'name' => 'candidate_location_search_style',
                    'val' => 'autocomplete'
                ]
            ]
        );

    }
}