/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $data['user'] = User::find($id); $data['users_menu'] = 1; $data['staff'] = Staff::select(\DB::raw('concat (fname," ",lname) as full_name, id'))->lists('full_name', 'id'); $data['roles'] = Role::noncoder()->lists('name', 'id'); //get the id(s) of the roles of this user in an array $roles = array(); foreach ($data['user']->roles as $value) { $roles[] = $value->id; } $data['user_roles'] = $roles; $data['permissions'] = []; return view('settings.users.modal_edit_user', $data); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { // $post = Post::findOrFail($id); //Populate the select(dropdowns) //$department_options = Department::lists('name', 'id'); //$department_id = $post->department_id; $department_options = Department::lists('name', 'id'); $department_selected = $post->departments->lists('id'); //$project_options = Project::lists('name', 'id'); //$project_id = $post->project_id; $source_options = Source::lists('name', 'id'); $source_selected = $post->sources->lists('id'); $staff_options = Staff::select('Id', DB::raw('CONCAT(first_name, " ", last_name) AS full_name'))->orderBy('first_name')->lists('full_name', 'Id'); $staff_selected = $post->staffs->lists('id'); // Show the page return view('posts.forms.edit', compact('post', 'department_options', 'department_selected', 'source_options', 'source_selected', 'staff_options', 'staff_selected')); }
/** * Display a listing of the resource. * * @return Response */ public function postCategory(Request $request) { Input::flash(); $detail = Input::get('detail'); $staff_options = Staff::select('Id', DB::raw('CONCAT(first_name, " ", last_name) AS full_name'))->orderBy('first_name')->lists('full_name', 'Id')->toArray(); $posts = Post::with(array('departments' => function ($query) { $query->addSelect(array('name')); }))->with(array('staffs' => function ($query) { $query->addSelect(array(DB::raw("concat(staff.first_name, ' ', staff.last_name) as `name`"))); })); if (Input::has('media_mention')) { $posts = $posts->mediamention(); } if (Input::has('presentation')) { $posts = $posts->presentation(); } if (Input::has('meeting')) { $posts = $posts->meeting(); } if (Input::has('testimonial')) { $posts = $posts->testimonial(); } if (Input::has('sponsored_event')) { $posts = $posts->sponsoredevent(); } if (Input::has('on_campus_collaboration')) { $posts = $posts->orWhere('on_campus_collaboration', 1); } if (Input::has('off_campus_collaboration')) { $posts = $posts->offcampuscollaboration(); } if (Input::has('achievement')) { $posts = $posts->achievement(); } if (Input::has('satifaction_survey')) { $posts = $posts->satifactionsurvey(); } if (Input::has('other')) { $posts = $posts->orWhere('other', 1); } if (Input::has('staff')) { if (Input::get('staff') != 0) { $posts = $posts->whereHas('staffs', function ($query) { $query->where('id', '=', Input::get('staff')); }); } } if (Input::has('publish_date_from') || Input::has('publish_date_to')) { $from = date('Y-m-d', strtotime(Input::get('publish_date_from'))); if (Input::has('publish_date_to')) { $to = date('Y-m-d', strtotime(Input::get('publish_date_to'))); } else { $to = date('Y-m-d', strtotime(Carbon::now())); } $posts = $posts->whereBetween('publish_date', array($from, $to)); } $posts = $posts->get(); //dd($posts); /*$posts = $posts->with(['departments' => function($query) { $query->select('name'); }])->get();*/ // I do this mapping to flatten the nested arrays // $posts = array_map(function($val) // { // return array_dot($val); // }, $posts); $action = Input::get('action', 'none'); if ($action == 'query') { return view('posts.report_category', compact('posts', 'staff_options', 'detail'))->withInput(Input::all()); } else { if ($action == 'excel') { if ($detail == 1) { Excel::create('Export', function ($excel) use($posts) { $excel->sheet('Data', function ($sheet) use($posts) { //$sheet->fromArray($posts); $sheet->loadView('posts.category_full')->with('posts', $posts); }); })->export('xls'); } else { Excel::create('Export', function ($excel) use($posts) { $excel->sheet('Data', function ($sheet) use($posts) { //$sheet->fromArray($posts); $sheet->loadView('posts.category')->with('posts', $posts); }); })->export('xls'); } } } /* Excel::create('posts', function($excel) use($posts) { $excel->sheet('Category', function($sheet) use($posts) { $sheet->fromArray($posts); }); })->export('xls'); */ }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $data['title'] = 'Edit Class'; $data['classes_menu'] = 1; $data['staffs'] = Staff::select(\DB::raw('concat (fname," ",lname) as full_name, id'))->where('staff_type_id', 1)->lists('full_name', 'id')->prepend('Please Select'); $data['subjects'] = Subject::lists('subject', 'id')->prepend('Please Select'); $data['class'] = StudentClass::find($id); $data['staffs'] = Staff::select(\DB::raw('concat (fname," ",lname) as full_name, id'))->where('staff_type_id', 1)->lists('full_name', 'id'); return view('settings.class.edit', $data); }