public function details($id)
{
$pagetitle = 'My Project Details';
$project_detail = Project::select_projectdetails($id);
$cities = Project::get_city($id);
$my_projectstatus = DB::table('statuses')->where('id', $project_detail->project_status)->first();
if (count($my_projectstatus) > 0) {
$projectstatus = $my_projectstatus->status;
} else {
$projectstatus = 'N/A';
}
$dev = Project::get_developer($id);
$sub_dev = Project::get_sub_developer($id);
$gencon = Project::get_generalcontractor($id);
$sub_gencon = Project::get_sub_generalcontractor($id);
$projmgrdes = Project::get_projectmgrdesigner($id);
$sub_projmgrdes = Project::get_sub_projectmgrdesigner($id);
$arch = Project::get_architect($id);
$sub_arch = Project::get_sub_architect($id);
$app = Project::get_applicator($id);
$sub_app = Project::get_sub_applicator($id);
$dealsupp = Project::get_dealersupplier($id);
$sub_dealsupp = Project::get_sub_dealersupplier($id);
$project_img = DB::table('project_images')->where('project_id', $id)->get();
$project_files = DB::table('project_files')->where('project_id', $id)->get();
return View::make('projects.details', compact('pagetitle', 'project_detail', 'dev', 'sub_dev', 'gencon', 'sub_gencon', 'projmgrdes', 'sub_projmgrdes', 'arch', 'sub_arch', 'app', 'sub_app', 'dealsupp', 'sub_dealsupp', 'project_img', 'project_files', 'cities', 'projectstatus'));
}
