/** * Show the form for editing the specified resource. * GET /project/{id}/edit * * @param int $id * @return Response */ public function edit($id) { $pagetitle = 'Update Project'; $project_detail = Project::select_projectdetails($id); $mybdo = DB::table('assigned_areas')->select(DB::raw('concat(users.first_name, " " ,users.last_name) as fullname, assigned_areas.user_id'))->join('users', 'users.id', '=', 'assigned_areas.user_id')->where('assigned_areas.user_id', $project_detail->bdo_id)->first(); $myarea = DB::table('areas')->where('id', $project_detail->area_id)->first(); $bdo = Project::selectbdo_list(); // $recordlist = Project::select_contactandcompany_list(); $classification = Project::select_projclassification_list(); $category = Project::select_projcategory_list(); $stage = Project::select_projstage_list(); $my_projectstatus = DB::table('statuses')->where('id', $project_detail->project_status)->first(); if (count($my_projectstatus) > 0) { $projectstatus_id = $my_projectstatus->id; $projectstatus = $my_projectstatus->status; } else { $projectstatus_id = ''; $projectstatus = 'CHOOSE PROJECT STATUS HERE'; } $status = Project::select_projstatus_list(); $cities = Project::get_city($id); // if($project_detail->developer != 0) // { // $project_detail_dev = DB::table('contacts')->select('category')->where('id', $project_detail->developer)->first(); // if($project_detail_dev->category == 1) // { // $dev = Project::get_developer($project_detail); // }else{ // $dev = Project::get_developer_ind($project_detail); // } // $bdo_dev = DB::table('project_users')->where('project_id', $id)->where('user_id', $dev->id)->first(); // } // if($project_detail->general_contractor != 0) // { // $project_detail_gencon = DB::table('contacts')->select('category')->where('id', $project_detail->general_contractor)->first(); // if($project_detail_gencon->category == 1) // { // $gencon = Project::get_generalcontractor($project_detail); // }else{ // $gencon = Project::get_generalcontractor_ind($project_detail); // } // $bdo_gencon = DB::table('project_users')->where('project_id', $id)->where('user_id', $gencon->id)->first(); // } // if($project_detail->project_mgr_designer != 0) // { // $project_detail_projmgrdesigner = DB::table('contacts')->select('category')->where('id', $project_detail->project_mgr_designer)->first(); // if($project_detail_projmgrdesigner->category == 1) // { // $projmgrdes = Project::get_projectmgrdesigner($project_detail); // }else{ // $projmgrdes = Project::get_projectmgrdesigner_ind($project_detail); // } // $bdo_projmgrdes = DB::table('project_users')->where('project_id', $id)->where('user_id', $projmgrdes->id)->first(); // } // if($project_detail->architect != 0) // { // $project_detail_architect = DB::table('contacts')->select('category')->where('id', $project_detail->architect)->first(); // if($project_detail_architect->category == 1) // { // $arch = Project::get_architect($project_detail); // }else{ // $arch = Project::get_architect_ind($project_detail); // } // $bdo_arch = DB::table('project_users')->where('project_id', $id)->where('user_id', $arch->id)->first(); // } // if($project_detail->applicator != 0) // { // $project_detail_applicator = DB::table('contacts')->select('category')->where('id', $project_detail->applicator)->first(); // if($project_detail_applicator->category == 1) // { // $app = Project::get_applicator($project_detail); // }else{ // $app = Project::get_applicator_ind($project_detail); // } // $bdo_app = DB::table('project_users')->where('project_id', $id)->where('user_id', $app->id)->first(); // } // if($project_detail->dealer_supplier != 0) // { // $project_detail_dealersupplier = DB::table('contacts')->select('category')->where('id', $project_detail->dealer_supplier)->first(); // if($project_detail_dealersupplier->category == 1) // { // $dealsupp = Project::get_dealersupplier($project_detail); // }else{ // $dealsupp = Project::get_dealersupplier_ind($project_detail); // } // $bdo_dealsupp = DB::table('project_users')->where('project_id', $id)->where('user_id', $dealsupp->id)->first(); // } // $developers = Project::select_developer(); // $gencons = Project::select_gencon(); // $proj_mngrdesigners = Project::select_project_managerdesigner(); // $architects = Project::select_architect(); // $applicators = Project::select_applicator(); // $dealersuppliers = Project::select_dealersupplier(); $dev = Project::get_developer($id); $sub_dev = Project::get_sub_developer($id); $gencons = Project::get_generalcontractor($id); $sub_gencons = 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); $developer = Project::select_developer_forcompany(); $sub_developer = Project::select_developer_forindiv(); $gencon = Project::select_gencon_forcompany(); $sub_gencon = Project::select_gencon_forindiv(); $proj_mngrdesigner = Project::select_project_managerdesigner_forcompany(); $sub_proj_mngrdesigner = Project::select_project_managerdesigner_forindiv(); $architect = Project::select_architect_forcompany(); $sub_architect = Project::select_architect_forindiv(); $applicator = Project::select_applicator(); $sub_applicator = Project::select_sub_applicator(); $dealersupplier = Project::select_dealersupplier(); $sub_dealersupplier = Project::select_sub_dealersupplier(); $cities = City::selectCity(); $mycity = DB::table('cities')->where('id', $project_detail->city)->where('id', '>', '0')->first(); $provinces = Province::selectProvince(); $myprovince = DB::table('provinces')->where('id', $project_detail->province)->where('id', '>', '0')->first(); $projimg = DB::table('project_images')->where('project_id', $id)->get(); $projfiles = DB::table('project_files')->where('project_id', $id)->get(); return View::make('projects.edit', compact('pagetitle', 'project_detail', 'mybdo', 'bdo', 'myarea', 'mydeveloper', 'classification', 'category', 'stage', 'status', 'developer', 'sub_developer', 'gencon', 'sub_gencon', 'proj_mngrdesigner', 'sub_proj_mngrdesigner', 'architect', 'sub_architect', 'applicator', 'sub_applicator', 'dealersupplier', 'sub_dealersupplier', 'dev', 'sub_dev', 'gencons', 'sub_gencons', 'projmgrdes', 'sub_projmgrdes', 'arch', 'sub_arch', 'app', 'sub_app', 'dealsupp', 'sub_dealsupp', 'projimg', 'projfiles', 'mycity', 'cities', 'provinces', 'myprovince', 'projectstatus_id', 'projectstatus')); }