PHP Pages::where方法代码示例

 public function render($args = NULL)
 {
     parent::render($args);
     $this->template->content = $this->pages->where('code', $this->actual)->fetch();
     $this->template->setFile(__DIR__ . "/Page.latte");
     $this->template->render();
 }

 public function getOrder()
 {
     $pages = Pages::where('id_parent', '=', 0)->orderBy('order', 'ASC')->get();
     foreach ($pages as $item) {
         # code...
         $item->label = $item->title;
     }
     $args = array('route' => $this->route, 'pages' => $pages, 'json' => json_encode($pages));
     return View::make('backend.pages.order')->with($args);
 }

 public function getCadastro()
 {
     $page = Pages::where('name', '=', 'cadastro')->take(1)->get();
     if (isset($page[0])) {
         $page = $page[0];
     } else {
         $page = false;
     }
     $args = array('route' => self::$route, 'page' => $page);
     return View::make('auth.cadastro')->with($args);
 }

 public function login($language)
 {
     // Définition de la langue :
     if (!$this->setupLanguage($language)) {
         App::abort(404);
     }
     try {
         $languages = Language::where('_url', '=', $language)->firstOrFail();
         $page = Pages::where('_language', $languages->_id)->where("_name", "=", "user/login")->get()->first();
     } catch (Exception $e) {
         App::abort(500);
     }
     // Redirection de l'utilisateur s'il est déjà connecté :
     if (Auth::check()) {
         return Redirect::to(URL::to($language . '/home'));
     }
     // Variables :
     // Details :
     $data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => ""));
     // Message :
     $message = "";
     // Inputs :
     $login = "";
     $password = "";
     // Envoi du formulaire de connexion :
     if (count(Input::all()) > 0) {
         // récupération des inputs :
         $login = htmlentities(Input::get('your-login'));
         $password = htmlentities(Input::get('your-password'));
         // validation des formulaire :
         $validator = Validator::make(array('email' => $login, 'password' => $password), array('email' => 'required|email', 'password' => 'required'), array('email.required' => Lang::get('libelle.CONNEXION_ERROR_IDENTIFIANT_RQ'), 'email.email' => Lang::get('libelle.CONNEXION_ERROR_IDENTIFIANT_INV'), 'password.required' => Lang::get('libelle.CONNEXION_ERROR_PASSWORD_RQ')));
         // retour en cas d'erreur :
         if ($validator->fails()) {
             $message = $validator->messages();
         } else {
             // connexion en cas de succès :
             $auth = Users::where('_email', '=', $login)->where('_password', '=', md5($password))->first();
             // si utilisateur trouvé, redirection :
             if ($auth) {
                 Auth::login($auth);
                 Auth::user()->_ipLastConnection = Request::getClientIp(true);
                 Auth::user()->_dateLastConnection = date("Y-m-d H:i:s");
                 Auth::user()->save();
                 return Redirect::to(URL::to($language . '/home'));
             } else {
                 $message = Lang::get("libelle.CONNEXION_ERROR");
             }
         }
     }
     // Renvoi de la vue avec les message(s) d'erreurs :
     $page = $this->layout->content = View::make('pages.users.login', array("data" => $data, "page" => $page, "message" => $message));
     return Response::make($page, '200');
 }

 public function index()
 {
     if (CNF_FRONT == 'false' && Request::segment(1) == '') {
         return Redirect::to('dashboard');
     }
     if (is_null(Input::get('p'))) {
         $page = Request::segment(1);
     } else {
         $page = Input::get('p');
     }
     if ($page != '') {
         $content = Pages::where('alias', '=', $page)->where('status', '=', 'enable');
         if ($content->count() >= 1) {
             $content = $content->get();
             $row = $content[0];
             $this->data['pageTitle'] = $row->title;
             $this->data['pageNote'] = $row->note;
             $this->data['breadcrumb'] = 'active';
             if ($row->access != '') {
                 $access = json_decode($row->access, true);
             } else {
                 $access = array();
             }
             // If guest not allowed
             if ($row->allow_guest != 1) {
                 $group_id = Session::get('gid');
                 $isValid = isset($access[$group_id]) && $access[$group_id] == 1 ? 1 : 0;
                 if ($isValid == 0) {
                     return Redirect::to('')->with('message', SiteHelpers::alert('error', Lang::get('core.note_restric')));
                 }
             }
             if ($row->template == 'backend') {
                 $this->layout = View::make("layouts.main");
             }
             $filename = public_path() . "protected/app/views/pages/template/" . $row->filename . ".blade.php";
             if (file_exists($filename)) {
                 $page = 'pages.template.' . $row->filename;
             } else {
                 return Redirect::to('')->with('message', SiteHelpers::alert('error', Lang::get('core.note_noexists')));
             }
         } else {
             return Redirect::to('')->with('message', SiteHelpers::alert('error', Lang::get('core.note_noexists')));
         }
     } else {
         $this->data['pageTitle'] = 'Home';
         $this->data['pageNote'] = 'Welcome To Our Site';
         $this->data['breadcrumb'] = 'inactive';
         $page = 'pages.template.home';
     }
     $page = SiteHelpers::renderHtml($page);
     $this->layout->nest('content', $page, $this->data)->with('menus', $this->menus)->with('page', $this->data);
 }

 public function news($language)
 {
     // Définition de la langue :
     if (!$this->setupLanguage($language)) {
         App::abort(404);
     }
     // Variables :
     // News (dans un try catch pour gérer les erreurs) :
     try {
         $languages = Language::where('_url', '=', $language)->firstOrFail();
         $page = Pages::where('_language', $languages->_id)->where("_name", "=", "news")->get()->first();
         $news = News::where('_langue', '=', $languages->_id)->get();
         $news = $news->sortBy('_date')->take(15);
     } catch (Exception $e) {
         App::abort(500);
     }
     // Details :
     $data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => ""));
     // Renvoi de la vue avec les news :
     $page = $this->layout->content = View::make('pages.news.news', array("data" => $data, "page" => $page, "news" => $news));
     return Response::make($page);
 }

 public function search($language)
 {
     if (!$this->setupLanguage($language)) {
         App::abort(404);
     }
     // VARIABLES :
     // Pages :
     try {
         $languages = Language::where('_url', '=', $language)->firstOrFail();
         $page = Pages::where('_language', $languages->_id)->where("_name", "=", "search")->get()->first();
     } catch (Exception $e) {
         App::abort(500);
     }
     // Request :
     $accentARemplacer = array('Š' => 'S', 'š' => 's', 'Ž' => 'Z', 'ž' => 'z', 'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Ä' => 'A', 'Å' => 'A', 'Æ' => 'A', 'Ç' => 'C', 'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E', 'Ì' => 'I', 'Í' => 'I', 'Î' => 'I', 'Ï' => 'I', 'Ñ' => 'N', 'Ò' => 'O', 'Ó' => 'O', 'Ô' => 'O', 'Õ' => 'O', 'Ö' => 'O', 'Ø' => 'O', 'Ù' => 'U', 'Ú' => 'U', 'Û' => 'U', 'Ü' => 'U', 'Ý' => 'Y', 'Þ' => 'B', 'ß' => 'Ss', 'à' => 'a', 'á' => 'a', 'â' => 'a', 'ã' => 'a', 'ä' => 'a', 'å' => 'a', 'æ' => 'a', 'ç' => 'c', 'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ì' => 'i', 'í' => 'i', 'î' => 'i', 'ï' => 'i', 'ð' => 'o', 'ñ' => 'n', 'ò' => 'o', 'ó' => 'o', 'ô' => 'o', 'õ' => 'o', 'ö' => 'o', 'ø' => 'o', 'ù' => 'u', 'ú' => 'u', 'û' => 'u', 'ý' => 'y', 'ý' => 'y', 'þ' => 'b', 'ÿ' => 'y');
     $request = trim(Input::get("q"));
     $requestWithoutAccent = strtr($request, $accentARemplacer);
     $requestWithAccent = $request;
     $request_explode = array_unique(array_merge(explode(" ", $requestWithoutAccent), explode(" ", $requestWithAccent)));
     // Details :
     $data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => " ", $request => ""));
     //
     $results = array();
     if (count($request_explode) > 0) {
         foreach ($request_explode as $key => $value) {
             $pages = Pages::where("_keywords", "LIKE", '%' . $value . '%')->orWhere('_title', "LIKE", '%' . $value . '%')->orWhere('_name', "LIKE", '%' . $value . '%')->orWhere('_description', "LIKE", '%' . $value . '%')->get();
             $news = News::where('_langue', '=', $languages->_id)->where("_extract", "LIKE", '%' . $value . '%')->orWhere('_content', "LIKE", '%' . $value . '%')->orWhere('_title', "LIKE", '%' . $value . '%')->get();
             if (count($pages) > 0) {
                 $results["pages"] = $pages;
             }
             if (count($news) > 0) {
                 $results["news"] = $news;
             }
         }
     } else {
         App::abort(404);
     }
     $this->layout->content = View::make('pages.search.search', array('data' => $data, "page" => $page, "language" => $languages, 'request' => $request, 'results' => $results));
 }

        $page->page_section = Input::get('page_section');
        $page->page_link_value = $section->shortname . "/" . Input::get('page_shortname');
        $page->color_code = Input::get('color_code');
        $page->page_shortname = Input::get('page_shortname');
        $page->page_url = $xmlFileName;
        //
        $page->save();
    }
    return Redirect::to('/add')->withMessage('Page created successfully');
});
Route::post('addPageDetails', function () {
    if (Input::hasFile('image')) {
        $image = Input::file('image');
        $name = $image->getClientOriginalName();
    }
    $oldPage = Pages::where('id', '=', Input::get('id'))->first();
    if (File::exists($oldPage->page_url)) {
        File::delete($oldPage->page_url);
    }
    $rule = array('page_description' => 'required', 'page_name' => 'required', 'page_title' => 'required', 'page_subtitle' => 'required', 'type_of_page' => 'required', 'page_section' => 'required', 'page_shortname' => 'required');
    $validator = Validator::make(Input::all(), $rule);
    if ($validator->fails()) {
        return Redirect::to('/forms')->with('flash_error', 'true')->withInput()->withErrors($validator);
    } else {
        $first_action_cnt = Input::get('first_action_cnt');
        $second_action_cnt = Input::get('second_action_cnt');
        $transport_action_cnt = Input::get('transport_cnt');
        $action_cnt = Input::get('action_cnt');
        $question_cnt = Input::get('question_cnt');
        $layout_cnt = Input::get('layout_cnt');
        $noreferral_cnt = Input::get('noreferral_cnt');

                            <div class="captionCustomize">
                                <a class="captionCustomize" alt="QLM Label Makers" title="QLM Label Makers">coming soon</a>
                            </div>
                        </div>
                    </div>
                @endfor
            @endif
    </div>
    <!-- end of Part 1 -->
    @endif
    <?php 
//-- sub menu va co danh sach con detail type la 2.
$_resultPageDetail = Pages::where('detailURL', $_page->detailParent)->where('detailType', '2')->get();
if (count($_resultPageDetail) > 0) {
    $_detailParent2 = $_resultPageDetail[0]->detailParent;
    $lst_buttons_level2 = Pages::where('detailParent', $_detailParent2)->where('detailType', '2')->get();
    if (count($lst_buttons_level2) > 0) {
        $cnt_buttons_level2 = count($lst_buttons_level2);
        $afterCheck = 1;
        $preCheck = 1;
        //-- neu so luong khong chia het cho 4.
        if ($cnt_buttons_level2 % 4 != 0) {
            while (($cnt_buttons_level2 + $preCheck) % 4 > 0) {
                $preCheck++;
            }
            $afterCheck = $preCheck + 1;
        }
    }
}
?>

 public function addMission($language)
 {
     // Définition de la langue :
     if (!$this->setupLanguage($language)) {
         App::abort(404);
     }
     // Redirection de l'utilisateur s'il est pas connecté et s'il n'est pas Admin:
     if (!Auth::check()) {
         return Redirect::to(URL::to($language . '/home'));
     } elseif (Auth::User()->_level != "admin") {
         return Redirect::to(URL::to($language . '/missions'));
     }
     // Variables :
     // Missions :
     $languages = Language::where('_url', '=', $language)->firstOrFail();
     $page = Pages::where('_language', $languages->_id)->where("_name", "=", "missions")->get()->first();
     $missions = Missions::where("_dateEnd", ">=", date("Y-m-d 00:00:00"))->orderBy('_dateStart')->orderBy('_dateEnd')->get();
     // Form :
     $inputs = Input::all();
     $result = array();
     // Details :
     $data = array("situation" => array("title" => $page->_title, "description" => $page->_description), "position" => array($page->_title => ""));
     // Envoi du formulaire d'ajout de mission :
     if (count(Input::all()) > 0) {
         // validation des formulaire :
         $validator = Validator::make($inputs, array('professor-name' => 'required|max:60', 'professor-email' => 'required|email|max:60', 'manager-name' => 'required|max:60', 'manager-email' => 'required|email|max:60', 'professor-mission-start' => 'required|date_format:"Y-m-d"|after:"now -1 day"', 'professor-mission-end' => 'required|date_format:"Y-m-d"|after:"' . strtotime("professor-mission-start") . '"', 'your-message' => 'required', 'liaison-file' => 'mimes:jpg,jpeg,png,doc,docx,pdf'), array('professor-name.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_NAME_RQ'), 'professor-name.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_NAME_MAX'), 'professor-email.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_EMAIL_RQ'), 'professor-email.email' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_EMAIL_INV'), 'professor-email.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_EMAIL_MAX'), 'manager-name.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_NAME_RQ'), 'manager-name.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_NAME_MAX'), 'manager-email.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_EMAIL_RQ'), 'manager-email.email' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_EMAIL_INV'), 'manager-email.max' => Lang::get('libelle.MISSIONS_FORM_ERROR_MANAGER_EMAIL_MAX'), 'professor-mission-start.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_START_RQ'), 'professor-mission-start.date_format' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_START_INV'), 'professor-mission-start.after' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_START_INV'), 'professor-mission-end.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_END_RQ'), 'professor-mission-end.date_format' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_END_INV'), 'professor-mission-end.after' => Lang::get('libelle.MISSIONS_FORM_ERROR_PROFESSEUR_MISSION_END_INV'), 'your-message.required' => Lang::get('libelle.MISSIONS_FORM_ERROR_MESSAGE'), 'liaison-file.mimes' => Lang::get('libelle.MISSIONS_FORM_ERROR_LIAISON_FILE')));
         // retour en cas d'erreur :
         if ($validator->fails()) {
             $result["errors"] = $validator->messages();
         } else {
             // traitement du texte en paragraphe
             $texte = explode('<br />', nl2br(trim(htmlentities($inputs['your-message']))));
             $inputs['your-message'] = "";
             foreach ($texte as $key => $value) {
                 $inputs['your-message'] .= "<p>" . $value . "</p>";
             }
             // ajout en cas de succès :
             $mission = new Missions();
             $mission->_author = 1;
             $mission->_dateStart = trim(htmlentities($inputs['professor-mission-start']));
             $mission->_dateEnd = trim(htmlentities($inputs['professor-mission-end']));
             $mission->_profName = trim(htmlentities($inputs['professor-name']));
             $mission->_profMail = trim(htmlentities($inputs['professor-email']));
             $mission->_ctdName = trim(htmlentities($inputs['manager-name']));
             $mission->_ctdMail = trim(htmlentities($inputs['manager-email']));
             $mission->_description = $inputs['your-message'];
             if (Input::hasFile('liaison-file')) {
                 $filename = date("YmdHis") . "-" . Input::file('liaison-file')->getClientOriginalName();
                 Input::file('liaison-file')->move(dirname("app/storage/uploads/missions/") . "/missions/", $filename);
                 $mission->_file = "storage/uploads/missions/" . $filename;
             }
             // enrgistrement en base de données.
             if ($mission->save()) {
                 // actualisation des missions :
                 $missions = Missions::where("_dateEnd", ">=", date("Y-m-d 00:00:00"))->orderBy('_dateStart')->orderBy('_dateEnd')->get();
                 // vidage du formulaire  :
                 foreach ($inputs as $key => $value) {
                     $inputs[$key] = "";
                 }
                 // affichage du message de reussite :
                 $result["success"] = Lang::get("libelle.MISSIONS_FORM_SUCCESS");
             } else {
                 $result["errors"] = Lang::get("libelle.MISSIONS_FORM_ERROR");
             }
         }
     }
     // Affichage de la vue avec retour du résultat de l'ajout :
     $this->layout->content = View::make('pages.missions.missions', array("data" => $data, "page" => $page, "missions" => $missions, "inputs" => $inputs, "result" => $result));
 }

 static function page($slug)
 {
     $page = Pages::where('slug', '=', $slug)->first();
     $page = Pages::find($page->id);
     return $page;
 }

 public function update_page()
 {
     try {
         $_arData = array();
         $total_files = null;
         $detailType = Input::get("detailType");
         $detailName = Input::get("detailName");
         $detailTitle = Input::get("detailTitle");
         $detailUrl = Input::get("detailUrl");
         $detailParent = Input::get("detailParent");
         $detailContent = Input::get("detailContent");
         $detailVisible = Input::get("detailVisible");
         if ($detailVisible == '1') {
             $detailVisible = '1';
         } else {
             $detailVisible = '0';
         }
         $destinationPath_TextImage = 'asserts/images/FeatureText';
         $destinationPath_BannerImage = 'asserts/images/SecondPage';
         $_countFiles = count(Input::file("fileTextImage"));
         $_number = 1;
         if (Input::hasfile('fileTextImage')) {
             foreach (Input::file("fileTextImage") as $file) {
                 $filename = $file->getClientOriginalName();
                 if ($_number == $_countFiles) {
                     $total_files .= $filename;
                 } else {
                     $total_files .= $filename . ';';
                 }
                 $upload_success = $file->move($destinationPath_TextImage, $filename);
                 $_number++;
             }
         }
         if ($detailType == 1) {
             $filename_Banner = null;
             if (Input::hasfile('fileBannerImage')) {
                 $file_Banner = Input::file("fileBannerImage");
                 $filename_Banner = $file_Banner->getClientOriginalName();
                 $upload_success_banner = $file_Banner->move($destinationPath_BannerImage, $filename_Banner);
             }
             $detailBannerTitle = Input::get("detailBannerTitle");
             $detailBannerDescription = Input::get("detailBannerDescription");
             if ($filename_Banner == null && $total_files == null) {
                 $_arData = array('detailName' => $detailName, 'detailTitle' => $detailTitle, 'detailUrl' => $detailUrl, 'detailParent' => $detailParent, 'detailBannerTitle' => $detailBannerTitle, 'detailBannerDescription' => $detailBannerDescription, 'detailContent' => $detailContent, 'detailVisible' => $detailVisible);
             } else {
                 if ($filename_Banner == null && $total_files != null) {
                     $_arData = array('detailName' => $detailName, 'detailTitle' => $detailTitle, 'detailUrl' => $detailUrl, 'detailParent' => $detailParent, 'detailBannerTitle' => $detailBannerTitle, 'detailBannerDescription' => $detailBannerDescription, 'detailContent' => $detailContent, 'detailTextImage' => $total_files, 'detailVisible' => $detailVisible);
                 } else {
                     if ($filename_Banner != null && $total_files == null) {
                         $_arData = array('detailName' => $detailName, 'detailTitle' => $detailTitle, 'detailUrl' => $detailUrl, 'detailParent' => $detailParent, 'detailBannerTitle' => $detailBannerTitle, 'detailBannerDescription' => $detailBannerDescription, 'detailContent' => $detailContent, 'detailBannerImage' => $filename_Banner, 'detailVisible' => $detailVisible);
                     } else {
                         if ($filename_Banner != null && $total_files != null) {
                             $_arData = array('detailName' => $detailName, 'detailTitle' => $detailTitle, 'detailUrl' => $detailUrl, 'detailParent' => $detailParent, 'detailBannerTitle' => $detailBannerTitle, 'detailBannerDescription' => $detailBannerDescription, 'detailContent' => $detailContent, 'detailTextImage' => $total_files, 'detailBannerImage' => $filename_Banner, 'detailVisible' => $detailVisible);
                         }
                     }
                 }
             }
         } else {
             if ($total_files == null) {
                 $_arData = array('detailName' => $detailName, 'detailTitle' => $detailTitle, 'detailUrl' => $detailUrl, 'detailContent' => $detailContent, 'detailParent' => $detailParent, 'detailVisible' => $detailVisible);
             } else {
                 $_arData = array('detailName' => $detailName, 'detailTitle' => $detailTitle, 'detailUrl' => $detailUrl, 'detailContent' => $detailContent, 'detailParent' => $detailParent, 'detailTextImage' => $total_files, 'detailVisible' => $detailVisible);
             }
         }
         $_page_update = Pages::where('detailId', Input::get("detailId"))->update($_arData);
     } catch (Exception $_ex) {
         Session::flash('error', '$$$ --- Error (' . $_ex->getMessage() . ') --- $$$');
     }
     Session::flash('success', '$$$ --- Update Page Successfully  --- $$$');
     return Redirect::to('qlm-admin/pages/' . Input::get("detailId"));
 }

 public function delete_image_1()
 {
     try {
         $sequence = 0;
         $id = Input::get('id');
         $_arrayImages = explode(";", Input::get('images'));
         $images = $_arrayImages;
         $image = Input::get('image');
         $new_image = '';
         foreach ($images as $_image) {
             if ($_image != $image) {
                 if ($sequence == count($images) - 1) {
                     $new_image .= $_image;
                 } else {
                     $new_image .= $_image . ';';
                 }
             }
             $sequence++;
         }
         if (ends_with($new_image, ';')) {
             $_arrayImages = '';
             $_arrayImages = explode(";", $new_image);
             $new_image = '';
             $sequence = 0;
             foreach ($_arrayImages as $_image) {
                 $sequence++;
                 if ($sequence < count($images) - 1) {
                     $new_image .= $_image . ';';
                 } else {
                     if ($sequence == count($images) - 1) {
                         $new_image .= $_image;
                     }
                 }
             }
         }
         $isUpdate = Pages::where('detailId', $id)->update(array('detailTextImage' => $new_image));
         Log::error('$page.' . $isUpdate);
         return Response::json(['status' => 'success', 'msg' => 'Đăng nhập thành công!']);
     } catch (Exception $_ex) {
         Log::error('Error: ' . $_ex);
         return Response::json(['status' => 'error', 'msg' => 'Đăng nhập thành công!']);
     }
 }

 public function siteMap_xml()
 {
     try {
         $page = Pages::where("_name", "=", "sitemap")->get()->first();
         $pages = Pages::where('_dependsOn', "=", NULL)->where("_public", "=", "1")->orderBy('_priority', 'DESC')->get();
         $news = News::orderBy('_date', 'DESC')->get();
     } catch (Exception $e) {
         App::abort(500);
     }
     $header = '<?xml version="1.0" encoding="UTF-8"?>';
     // Renvoi de la vue avec les news et l'en-tête :
     $page = $this->layout->content = View::make('pages.sitemap.sitemap_xml', array("news" => $news, "pages" => $pages, "header" => $header));
     return Response::make($page, '200')->header('Content-Type', 'text/xml');
 }

 public function bottomMenu()
 {
     $pages = Pages::where('published_at', '<', date('Y-m-d H:i:s'))->where('is_published', 1)->with('parent')->get(['id', 'published_at', 'parent_id', 'is_published', 'alias', 'menu_title']);
     return (string) View::make('widgets.menu.bottom', compact('pages'))->render();
 }