/**
* Display a listing of the resource.
* GET /project
*
* @return Response
*/
public function index()
{
$pagetitle = 'My Project List';
Input::flash();
if (Input::get('status') > 1) {
if (Input::get('s') != '') {
DB::table('projects')->where('project_name', Input::get('s'))->update(array('notif' => 2));
}
if (Session::get('role') == 1 || Session::get('role') == 2) {
$projects = Project::select_projects_all(Input::get('status', 1), Input::get('s'), Auth::id());
$projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links();
$project_stats = DB::table('project_status')->orderBy('id', 'desc')->get();
} else {
$projects = Project::select_projects(Auth::id(), Input::get('status', 1), Input::get('s'), Auth::id());
$projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links();
$project_stats = DB::table('project_status')->where('created_by', Auth::id())->orderBy('id', 'desc')->get();
}
return View::make('projects.index', compact('pagetitle', 'projects', 'project_stats'));
} else {
if (Session::get('role') == 1 || Session::get('role') == 2) {
$projects = Project::select_projects_all(Input::get('status', 1), Input::get('s'), Auth::id());
$projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links();
$project_stats = DB::table('project_status')->orderBy('id', 'desc')->get();
} else {
$projects = Project::select_projects(Auth::id(), Input::get('status', 1), Input::get('s'), Auth::id());
$projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links();
$project_stats = DB::table('project_status')->where('created_by', Auth::id())->orderBy('id', 'desc')->get();
}
// $company_status = DB::table('company_status')->get();
return View::make('projects.index', compact('pagetitle', 'projects', 'project_stats'));
}
// $projects = Project::select_projects(Input::get('status', 1),Input::get('s'),Auth::id());
// return View::make('projects.index', compact('pagetitle', 'projects'));
}
