public function parentName()
 {
     $categoryLanguages = \App\CategoryLanguage::where('locale', \Lang::getLocale())->where('category_id', $this->parent_id)->first();
     if (!$categoryLanguages) {
         $categoryLanguages = \App\CategoryLanguage::where('locale', 'en')->where('category_id', $this->parent_id)->first();
     }
     return $categoryLanguages ? $categoryLanguages->title : '-';
 }
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     //
     $category = \App\Category::create(['route' => 'villa', 'parent_id' => 0, 'order' => 1]);
     \App\CategoryLanguage::create(['category_id' => $category->id, 'locale' => 'en', 'title' => 'villas']);
     $category = \App\Category::create(['route' => 'land', 'parent_id' => 0, 'order' => 2]);
     \App\CategoryLanguage::create(['category_id' => $category->id, 'locale' => 'en', 'title' => 'lands']);
     $category = \App\Category::create(['route' => 'beachfront-property', 'parent_id' => 1, 'order' => 2]);
     \App\CategoryLanguage::create(['category_id' => $category->id, 'locale' => 'en', 'title' => 'beachfront property']);
     $category = \App\Category::create(['route' => 'home-and-retirement', 'parent_id' => 1, 'order' => 2]);
     \App\CategoryLanguage::create(['category_id' => $category->id, 'locale' => 'en', 'title' => 'home and retirement']);
 }
 public function storeTranslate(Request $request)
 {
     DB::beginTransaction();
     foreach ($request->title as $key => $title) {
         $categoryLang = \App\CategoryLanguage::where('category_id', $request->edit_translate)->where('locale', $key)->first();
         if ($categoryLang) {
             $categoryLang->title = $title ? $title : '';
             $categoryLang->description = $request->description[$key] ? $request->description[$key] : '';
             $categoryLang->save();
         } else {
             $categoryLang = new \App\CategoryLanguage();
             if ($title) {
                 $categoryLang->title = $title;
             }
             if ($request->description[$key]) {
                 $categoryLang->description = $request->description[$key];
             }
             if ($title || $request->description[$key]) {
                 $categoryLang->locale = $key;
                 $categoryLang->category_id = $request->edit_translate;
                 $categoryLang->save();
             }
         }
     }
     DB::commit();
     return response()->json(array('status' => 200, 'monolog' => array('title' => 'update translation success', 'message' => 'Translation has been updated')));
 }