Esempio n. 1
0
 public function design()
 {
     $roles = Role::all();
     $users = User::all();
     $userroles = DB::table('role_user')->get();
     $jobstable = Job::all();
     $userjobs = Userjobs::all();
     $permissions = DB::table('permissions')->get();
     $permissionroles = DB::table('permission_role')->get();
     $skills = Skill::all();
     $jobskills = JobSkill::all();
     $userskills = UserSkill::all();
     return View('design')->withJobs($jobstable)->withJobsusers($userjobs)->withusers($users)->withroles($roles)->withuserroles($userroles)->withpermissions($permissions)->withpermissionroles($permissionroles)->withskills($skills)->withjobskills($jobskills)->withuserskills($userskills);
 }
Esempio n. 2
0
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $faker = Faker::create();
     for ($i = 1; $i < 200; $i++) {
         $name = $faker->shuffle($faker->word());
         $recodeID = $faker->boolean(50) ? rand(0, $i) : NULL;
         Character::create(['name' => $name, 'savename' => $name, 'class' => $faker->randomElement($array = array('A', 'B', 'C', 'D', 'S', 'SS', 'Z')), 'race' => $faker->boolean(50), 'pot' => $faker->boolean(50), 'pof' => $faker->boolean(50), 'adventurer' => $faker->boolean(50), 'recode_id' => NULL]);
         for ($t = 1; $t < 4; $t++) {
             Job::create(['name' => $faker->shuffle($faker->name()), 'number' => $t, 'element' => $faker->randomElement($array = array('None', 'Fire', 'Ice', 'Darkness', 'Lightning', 'Heal', 'Remedy')), 'weapon' => $faker->randomElement($array = array('Sword', 'Bow', 'Spear', 'Staff')), 'minHP' => $faker->numberBetween(0, 130), 'maxHP' => $faker->numberBetween(200, 900), 'minATK' => $faker->numberBetween(0, 130), 'maxATK' => $faker->numberBetween(200, 900), 'minDEF' => $faker->numberBetween(0, 130), 'maxDEF' => $faker->numberBetween(200, 900), 'minMATK' => $faker->numberBetween(0, 130), 'maxMATK' => $faker->numberBetween(200, 900), 'minMDEF' => $faker->numberBetween(0, 130), 'maxMDEF' => $faker->numberBetween(200, 900), 'character_id' => $i]);
             for ($s = 1; $s < 5; $s++) {
                 $skillcount = Skill::all()->count();
                 $skill = Skill::where('id', rand(0, $skillcount - 1))->first();
                 JobSkill::create(['lvl' => rand(0, 15 * $s), 'skill_name' => $skill->name, 'affection' => $faker->word(), 'frequency' => rand(0, 101), 'job_id' => $t * $i]);
                 $itemcount = Item::all()->count();
                 $item = Item::where('id', rand(0, $itemcount - 1))->first();
                 JobItem::create(['quantity' => rand(0, 51), 'item_name' => $item->name, 'job_id' => $t * $i]);
             }
         }
         for ($j = 0; $j < rand(1, 5); $j++) {
             Iteration::create(['trigger' => $faker->word(), 'content' => $faker->text(), 'character_id' => $i, 'trigger_id' => NULL]);
         }
     }
 }
Esempio n. 3
0
 /**
  * Update the specified resource in storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function update($company_id, $id, Request $request)
 {
     //dd($request->all());
     $job = Job::find($id);
     $job->job_title = $request->input('job_title');
     $job->creative_field = $request->input('creative_fields');
     $job->location = $request->input('location');
     $job->exp_date = $request->input('exp_date');
     $job->pre_lang = $request->input('pre_lang');
     $job->res_lang = $request->input('res_lang');
     $job->salary = $request->input('salary');
     $job->salary_from = $request->input('salary_from');
     $job->salary_to = $request->input('salary_to');
     $job->contact_gender = $request->input('contact_gender');
     $job->contact_name = $request->input('contact_name');
     $job->apply_email = $request->input('apply_email');
     $job->job_desc = $request->input('description');
     $job->apply_reason = $request->input('apply_reason');
     $job->save();
     /* Update job level */
     $levels = $request->input('job_level');
     $count_lev = sizeof($levels);
     for ($i = 0; $i < $count_lev; $i++) {
         $job_level = new JobLevel();
         $job_level->job_id = $job->id;
         $job_level->level_id = $levels[$i];
         $job_level->save();
     }
     /* Update job types */
     $edit_types = $request->input('job_type');
     // stored in array
     $created_types = $job->job_types->list('type_id');
     // compare 2 arrays
     $add_types = array_value(array_diff($edit_types, $created_types));
     $delete_types = array_value(array_diff($created_types, $edit_types));
     // add new types
     $count_typ = sizeof($add_types);
     for ($i = 0; $i < $count_typ; $i++) {
         $job_type = new JobType();
         $job_type->job_id = $id;
         $job_type->type_id = $add_types[$i];
         $job_type->save();
     }
     // delete types
     $count_del = sizeof($delete_types);
     for ($i = 0; $i < $count_del; $i++) {
         $job_type = JobType::where('type_id', '=', $delete_types[$id])->first();
         $job_type->delete();
     }
     /* Update job skills */
     $names = $request->input('skillnames');
     $descs = $request->input('skilldescs');
     $count_ski = sizeof($names);
     for ($i = 0; $i < $count_ski; $i++) {
         $jobskill = new JobSkill();
         $jobskill->job_id = $job->id;
         $jobskill->name = $names[$i];
         $jobskill->description = $descs[$i];
         $jobskill->save();
     }
     $company = Company::find($company_id);
     return view('jobs.show', compact('job', 'company'));
 }
Esempio n. 4
0
 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     $job = Job::find($id);
     $jobskills = JobSkill::where('job_id', $id)->get();
     return view('jobs.show')->withJob($job)->withSkills($jobskills);
 }