public function myproject_status($id)
 {
     $pagetitle = 'Project Thread';
     $project = Project::selectnfo_fordetails($id);
     if ($project->status == 0) {
         return Redirect::route('project.list')->with('class', 'error')->with('message', 'This project was already closed.');
     } else {
         $my_projectstatus = DB::table('statuses')->where('id', $project->project_status)->first();
         if (count($my_projectstatus) > 0) {
             $projectstatus = $my_projectstatus->status;
         } else {
             $projectstatus = 'N/A';
         }
         // if($project->developer)
         // {
         //  $project_detail_dev = DB::table('contacts')->select('category')->where('id', $project->developer)->first();
         //  if($project_detail_dev->category == 1)
         //  {
         //    $dev = Project::get_developer($project);
         //  }else{
         //    $dev = Project::get_developer_ind($project);
         //  }
         // }
         // if($project->general_contractor)
         // {
         //  $project_detail_gencon = DB::table('contacts')->select('category')->where('id', $project->general_contractor)->first();
         //  if($project_detail_gencon->category == 1)
         //  {
         //    $gencon = Project::get_generalcontractor($project);
         //  }else{
         //    $gencon = Project::get_generalcontractor_ind($project);
         //  }
         // }
         // if($project->project_mgr_designer)
         // {
         //  $project_detail_projmgrdesigner = DB::table('contacts')->select('category')->where('id', $project->project_mgr_designer)->first();
         //  if($project_detail_projmgrdesigner->category == 1)
         //  {
         //    $projmgrdes = Project::get_projectmgrdesigner($project);
         //  }else{
         //    $projmgrdes = Project::get_projectmgrdesigner_ind($project);
         //  }
         // }
         // if($project->architect)
         // {
         //  $project_detail_architect = DB::table('contacts')->select('category')->where('id', $project->architect)->first();
         //  if($project_detail_architect->category == 1)
         //  {
         //    $arch = Project::get_architect($project);
         //  }else{
         //    $arch = Project::get_architect_ind($project);
         //  }
         // }
         // if($project->applicator)
         // {
         //  $project_detail_applicator = DB::table('contacts')->select('category')->where('id', $project->applicator)->first();
         //  if($project_detail_applicator->category == 1)
         //  {
         //    $app = Project::get_applicator($project);
         //  }else{
         //    $app = Project::get_applicator_ind($project);
         //  }
         // }
         // if($project->dealer_supplier)
         // {
         //  $project_detail_dealersupplier = DB::table('contacts')->select('category')->where('id', $project->dealer_supplier)->first();
         //  if($project_detail_dealersupplier->category == 1)
         //  {
         //    $dealsupp = Project::get_dealersupplier($project);
         //  }else{
         //    $dealsupp = Project::get_dealersupplier_ind($project);
         //  }
         // }
         $dev = Project::s_get_developer($id);
         $sub_dev = Project::s_get_sub_developer($id);
         $gencon = Project::s_get_generalcontractor($id);
         $sub_gencon = Project::s_get_sub_generalcontractor($id);
         $projmgrdes = Project::s_get_projectmgrdesigner($id);
         $sub_projmgrdes = Project::s_get_sub_projectmgrdesigner($id);
         $arch = Project::s_get_architect($id);
         $sub_arch = Project::s_get_sub_architect($id);
         $app = Project::s_get_applicator($id);
         $sub_app = Project::s_get_sub_applicator($id);
         $dealsupp = Project::s_get_dealersupplier($id);
         $sub_dealsupp = Project::s_get_sub_dealersupplier($id);
         // $almost_sameproj = Project::selectsameinfo_fordetails($project);
         $project_img = DB::table('project_images')->where('project_id', $id)->where('status', 2)->get();
         $project_files = DB::table('project_files')->where('project_id', $id)->where('status', 2)->get();
         if (Session::get('role') == 1 || Session::get('role') == 2) {
             $project_thread = Project::get_allproject_thread($project->id);
             $project_status = DB::table('projects')->select('id', 'status')->where('id', $id)->first();
         } elseif (Session::get('role') == 3) {
             $project_thread = Project::get_bdoproject_thread($project->approved_by, $project->id);
             $project_status = DB::table('project_users')->select('id', 'status')->where('project_id', $id)->where('user_id', Auth::id())->first();
         } elseif (Session::get('role') == 4) {
             $project_thread = Project::get_ccproject_thread($project->id, $project->bdo_id);
             $project_status = DB::table('projects')->select('id', 'status')->where('id', $id)->first();
         }
         return View::make('projects.myprojects-status', compact('pagetitle', 'project', 'dev', 'sub_dev', 'gencon', 'sub_gencon', 'projmgrdes', 'sub_projmgrdes', 'arch', 'sub_arch', 'app', 'sub_app', 'dealsupp', 'sub_dealsupp', 'almost_sameproj', 'project_img', 'project_files', 'project_thread', 'project_status', 'projectstatus'));
     }
 }