public function project_part($districtkey, $projectkey, $projectpartid, $projectpartkey)
 {
     $project_part = Project_part::findOrFail($projectpartid);
     if ($project_part != null) {
         $project = $project_part->project;
         $project_parts = $project->project_parts()->where('active', 1)->where('type', 'E')->orderBy('priority')->get();
         $project_articles = $project->project_parts()->where('active', 1)->where('type', 'A')->orderBy('priority')->get();
         $project_images = $project->project_images()->where('active', 1)->where('path', '<>', $project->logo)->orderBy('priority')->take(5)->get();
         $other_projects = Project::where('active', 1)->orderBy('priority')->take(5)->get();
         $project_agents = $project->agents()->get();
         // metadata
         $site_title = $project->name . ' - ' . Config::findByKey('site_title')->first()->value;
         SEOMeta::setTitle($site_title);
         SEOMeta::setDescription($project->meta_description);
         SEOMeta::addKeyword([$project->meta_keywords]);
         SEOMeta::addMeta('project:published_time', $project->created_at->toW3CString(), 'property');
         if (isset($project->district->name)) {
             SEOMeta::addMeta('project:section', $project->district->name, 'property');
         }
         OpenGraph::setTitle($site_title);
         OpenGraph::setDescription($project->meta_description);
         OpenGraph::setUrl($project->getLink());
         OpenGraph::addProperty('type', 'project');
         OpenGraph::addProperty('locale', app()->getLocale());
         OpenGraph::addProperty('locale:alternate', ['vi-vn', 'en-us']);
         OpenGraph::addImage($project->logo);
         OpenGraph::addImage($project_images->lists('path'));
         OpenGraph::addImage(['url' => Image::url($project->logo, 300, 300, array('crop')), 'size' => 300]);
         // end metadata
         return view('frontend.sites.project_part', compact('project', 'project_parts', 'project_part', 'project_articles', 'project_images', 'other_projects', 'project_agents'));
     } else {
         return view('errors.404');
     }
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     dd('sao lại xóa ?');
     DB::transaction(function () use($id) {
         $user = Auth::user();
         $project_part = Project_part::findOrFail($id);
         $project_part->updated_by = $user->name;
         $project_part->deleted_by = $user->name;
         $project_part->key = $project_part->key . '-' . microtime(true);
         $project_part->save();
         // soft delete
         $project_part->delete();
     });
 }