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);
}
public function myjobs()
{
$userid = Auth::user()->id;
$userjobs = Userjobs::where('user_id', $userid)->pluck('job_id');
$jobs = Job::simpleWhereIn_1($userjobs);
return view('jobs.myjobs')->withJobs($jobs);
}