public function ra_details($id) { $pagetitle = 'Project Details'; $project = Project::selectnfo_fordetails($id); $cities = Project::get_city($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'; } // if($project->developer != 0) // { // $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 != 0) // { // $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 != 0) // { // $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 != 0) // { // $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 != 0) // { // $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 != 0) // { // $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::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(); $almost_sameproj = Project::selectsameinfo_fordetails($project); return View::make('projects.ra-details', compact('pagetitle', 'project', 'dev', 'sub_dev', 'gencon', 'sub_gencon', 'projmgrdes', 'sub_projmgrdes', 'arch', 'sub_arch', 'app', 'sub_app', 'dealsupp', 'sub_dealsupp', 'project_img', 'project_files', 'cities', 'almost_sameproj', 'projectstatus')); }