public function getPDF()
{
$valores = Skill::where('type', 'Valor')->get();
$habilidades = Skill::where('type', 'Habilidad')->get();
$conocimientos = Skill::where('type', 'Conocimiento')->get();
$vista = view('perfil-trabajador.pdf', compact('valores', 'habilidades', 'conocimientos'))->render();
$pdf = app('dompdf.wrapper');
$pdf->loadHTML($vista);
return $pdf->stream();
// return $pdf->download();
}
/**
* Define your route model bindings, pattern filters, etc.
*
* @param \Illuminate\Routing\Router $router
* @return void
*/
public function boot(Router $router)
{
parent::boot($router);
// bind skill, course, and project wildcards the the alias in the database.
$router->bind('skill', function ($alias) {
return Skill::where('alias', $alias)->firstOrFail();
});
$router->bind('course', function ($alias) {
return Course::where('alias', $alias)->firstOrFail();
});
$router->bind('project', function ($alias) {
return Project::where('alias', $alias)->firstOrFail();
});
}
public function edit()
{
$user = User::findOrFail(Auth::user()->id);
$entity = Entity::where('user_id', Auth::user()->id)->firstOrFail();
$about = About::where('user_id', Auth::user()->id)->firstOrFail();
$contact = Contact::where('user_id', Auth::user()->id)->firstOrFail();
$home = Home::where('user_id', Auth::user()->id)->firstOrFail();
$quote = Quote::where('user_id', Auth::user()->id)->get();
$quote_count = $quote->count();
$skill = Skill::where('user_id', Auth::user()->id)->get();
$skill_count = $skill->count();
$skill_slider = SkillSlider::where('user_id', Auth::user()->id)->get();
$skill_slider_count = $skill_slider->count();
$portfolio_piece = PortfolioPiece::where('user_id', Auth::user()->id)->get();
$portfolio_piece_count = $portfolio_piece->count();
return view('edit')->with('user', $user)->with('home', $home)->with('entity', $entity)->with('contact', $contact)->with('about', $about)->with('skill', $skill)->with('skill_count', $skill_count)->with('quote', $quote)->with('quote_count', $quote_count)->with('skill_slider', $skill_slider)->with('skill_slider_count', $skill_slider_count)->with('portfolio_piece', $portfolio_piece)->with('portfolio_piece_count', $portfolio_piece_count);
}
public function addSkill()
{
$user = Auth::user();
$name = Input::get('skill');
$stars = Input::get('level');
$skill = Skill::where('user', '=', $user->id)->where('name', '=', $name);
if ($skill->count() > 0) {
$skill = $skill->first();
$rep = 'old';
} else {
$skill = new Skill();
$rep = 'new';
}
$skill->user = $user->id;
$skill->name = $name;
$skill->level = $stars;
$skill->save();
return response()->json(array('response' => $rep, 'skill' => $skill->toArray()));
}
/**
* 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]);
}
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
//
$card = Card::find($id);
if (!$card) {
// 无对应卡片数据
}
$skill = null;
if ($card->skill_id != 0) {
$skill = Skill::where("skill_id", $card->skill_id)->first();
}
$lskill = null;
if ($card->lskill_id != 0) {
$lskill = Lskill::where("lskill_id", $card->lskill_id)->first();
}
$objEvoTargetCard = null;
$objMaterial1Card = null;
$objMaterial2Card = null;
$objMaterial3Card = null;
$objMaterial4Card = null;
if ($card->evo_id != 0) {
$objEvoTargetCard = Card::where("card_id", $card->evo_id)->first();
if ($card->material_id1 > 0) {
$objMaterial1Card = Card::where("card_id", $card->material_id1)->first();
}
if ($card->material_id2 > 0) {
$objMaterial2Card = Card::where("card_id", $card->material_id2)->first();
}
if ($card->material_id3 > 0) {
$objMaterial3Card = Card::where("card_id", $card->material_id3)->first();
}
if ($card->material_id4 > 0) {
$objMaterial4Card = Card::where("card_id", $card->material_id4)->first();
}
}
return view('card.show')->withCard($card)->withSkill($skill)->withLskill($lskill)->withTitle($card->name_jp)->withAbilities(Ability::all())->withType1s(Type1::all())->withType2s(Type2::all())->withEvoTargetCard($objEvoTargetCard)->withMaterial1Card($objMaterial1Card)->withMaterial2Card($objMaterial2Card)->withMaterial3Card($objMaterial3Card)->withMaterial4Card($objMaterial4Card)->withAttrs(Attr::all());
}
public function showUserEditSkillsForm()
{
$skill_categories = SkillCategories::all();
$user_id = Auth::user()->id;
$skillsByCategory = array();
$userSkills = User::find($user_id)->skill;
$i = 0;
foreach ($skill_categories as $category) {
$skillsByCategory[$i++] = Skill::where('skill_category_id', '=', $category->id)->get();
}
return view('addskills')->with('skill_categories', $skill_categories)->with('userSkills', $userSkills)->with('skillsByCategory', $skillsByCategory);
}
public function showIndividual($id)
{
$profile = \App\Profile::where('id', '=', $id)->get()->first();
if (count($profile) != 1) {
return view('error.404');
}
$availableFrom = $profile->available_from;
$availableTo = $profile->available_to;
$availableFrom = explode('-', $availableFrom);
$availableTo = explode('-', $availableTo);
$availableFrom = $availableFrom[2] . '-' . $availableFrom[1] . '-' . $availableFrom[0];
$availableTo = $availableTo[2] . '-' . $availableTo[1] . '-' . $availableTo[0];
$profile->available_from = $availableFrom;
$profile->available_to = $availableTo;
$skills = \App\Skill::where('profile_id', '=', $profile->id)->get();
// return $skills;
$arr = [];
foreach ($skills as $skill) {
$hard = \App\Hardskill::where('id', '=', $skill->skill_id)->get()->first();
array_push($arr, $hard);
}
$skills = $arr;
// return $arr;
$profile->skills = $skills;
return view('profile.view')->with('pro', $profile);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$card = Card::where('card_id', $id);
$objEvoTargetCard = null;
$objMaterial1Card = null;
$objMaterial2Card = null;
$objMaterial3Card = null;
$objMaterial4Card = null;
if ($card->evo_id != 0) {
$objEvoTargetCard = Card::find($card->evo_id);
if ($card->material_id1 > 0) {
$objMaterial1Card = Card::find($card->material_id1);
}
if ($card->material_id2 > 0) {
$objMaterial2Card = Card::find($card->material_id2);
}
if ($card->material_id3 > 0) {
$objMaterial3Card = Card::find($card->material_id3);
}
if ($card->material_id4 > 0) {
$objMaterial4Card = Card::find($card->material_id4);
}
}
return view('admin.card.show')->withCard($card)->withSkill(Skill::where('skill_id', $card->skill_id))->withLskill(Lskill::where('lskill_id', $card->lskill_id))->withAttr(Attr::where('attr', $card->attr1))->withType1(Type1::where('type1', $card->type1))->withType2(Type2::where('type2', $card->type2))->withAbility1(Ability::where('ability_id', $card->ability1))->withAbility2(Ability::where('ability_id', $card->ability2))->withAbility3(Ability::where('ability_id', $card->ability3))->withEvoTargetCard($objEvoTargetCard)->withMaterial1Card($objMaterial1Card)->withMaterial2Card($objMaterial2Card)->withMaterial3Card($objMaterial3Card)->withMaterial4Card($objMaterial4Card)->withCards(Card::where('skill_id', $card->skill_id));
}
/**
* Get all of the Skills for a given user.
*
* @param User $user
* @return Collection
*/
public function forUser(User $user)
{
return Skill::where('user_id', $user->id)->orderBy('created_at', 'asc')->get();
}
