/**
  * 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'));
 }