Advanced Web Server Manager
Complete File Manager & Terminal - Standalone Version
By Sid Gifari | Gifari Industries
Current path:
/
/
home
/
qtdcvxyp
/
karir.star4hire.com
/
database
/
seeders
✏️
Editing: CandidateSeeder.php
<?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' ] ] ); } }
💾 Save Changes
❌ Cancel