public function myprojectlist()
 {
     $pagetitle = 'My Assigned-Project List';
     if (Session::get('role') == 1 || Session::get('role') == 2) {
         if (Input::get('status') == 4) {
             $myprojectlist = Project::get_allprojects(Input::get('status'), Input::get('s'));
             $myprojectlist_count = Project::get_allproject_counts(Input::get('status'), Input::get('s'));
         } elseif (Input::get('status') == 0) {
             $myprojectlist = Project::get_allprojectclosed(Input::get('s'));
             $myprojectlist_count = Project::get_allprojectclosed_count(Input::get('s'));
         } else {
             $myprojectlist = Project::get_allproject(Input::get('status', 2), Input::get('s'));
             $myprojectlist_count = Project::get_allproject_count(Input::get('status', 2), Input::get('s'));
         }
     } elseif (Session::get('role') == 3) {
         if (Input::get('status') == 4) {
             $myprojectlist = Project::get_bdoprojects(Input::get('status'), Input::get('s'), Auth::id());
             $myprojectlist_count = Project::get_bdoproject_counts(Input::get('status'), Input::get('s'), Auth::id());
         } else {
             $myprojectlist = Project::get_bdoproject(Input::get('status', 2), Input::get('s'), Auth::id());
             $myprojectlist_count = Project::get_bdoproject_count(Input::get('status', 2), Input::get('s'), Auth::id());
         }
     } elseif (Session::get('role') == 4) {
         if (Input::get('status') == 4) {
             $myprojectlist = Project::get_ccprojects(Input::get('status'), Input::get('s'), Auth::id());
             $myprojectlist_count = Project::get_ccproject_counts(Input::get('status'), Input::get('s'), Auth::id());
         } else {
             $myprojectlist = Project::get_ccproject(Input::get('status', 2), Input::get('s'), Auth::id());
             $myprojectlist_count = Project::get_ccproject_count(Input::get('status', 2), Input::get('s'), Auth::id());
         }
     }
     // $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();
     return View::make('projects.myprojects', compact('pagetitle', 'myprojectlist', 'myprojectlist_count'));
 }