public function closedproject_information($id)
 {
     $pagetitle = 'Closed Project Information';
     $project = Project::selectnfo_fordetails($id);
     $my_projectstatus = DB::table('statuses')->where('id', $project->project_status)->first();
     if (count($my_projectstatus) > 0) {
         $projectstatus = $my_projectstatus->status;
     } else {
         $projectstatus = 'N/A';
     }
     $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', 0)->get();
     $project_files = DB::table('project_files')->where('project_id', $id)->where('status', 0)->get();
     if (Session::get('role') == 1 || Session::get('role') == 2) {
         $project_thread = Project::getall_closedproject_thread($project->id);
         $project_status = DB::table('projects')->select('id', 'status')->where('id', $id)->first();
     } elseif (Session::get('role') == 3) {
         $project_thread = Project::get_closed_bdoproject_thread($project->approved_by, $project->id);
         $project_status = DB::table('projects')->select('id', 'status')->where('id', $id)->first();
     } elseif (Session::get('role') == 4) {
         $project_thread = Project::get_closed_ccproject_thread($project->id, $project->bdo_id);
         $project_status = DB::table('projects')->select('id', 'status')->where('id', $id)->first();
     }
     return View::make('projects.closed-project', 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'));
 }