/** * Display a listing of the resource. * * @return Response */ public function index() { parent::show(); $menus = Page::where("slug", "!=", "")->orderBy("menu_sort_order")->get(); $banner = $this->banner; return $this->respond($menus, 'menus.index', compact('menus', 'banner')); }
public function tim_viec_danh_muc($id, $phanloai, $title) { $data['post'] = Page::where('loai', $id)->where('phanloai', $phanloai)->orderBy('id', 'desc')->paginate(11); $data['loai'] = $id; $data['phan_loai'] = '.phan-loai-' . $phanloai; if ($id == 1) { $data['title'] = 'Việc làm Gia Sư Đà Nẵng - Tìm việc Gia Sư dành cho sinh viên'; } elseif ($id == 2) { $data['title'] = 'Việc làm nhân viên bán hàng - Tuyển dụng nhân viên bán hàng'; } elseif ($id == 3) { $data['title'] = 'Tuyển dụng, tìm việc làm giữ xe, phát tờ rơi, nhân viên bảo vệ'; } elseif ($id == 4) { $data['title'] = 'Việc Làm Nhân Viên Phục Vụ - Tìm việc làm phục vụ cafe ĐN'; } elseif ($id == 5) { $data['title'] = 'Việc làm PG, Tiếp Thị | Tìm việc làm Tiếp Thị, PG tại Đà Nẵng'; } elseif ($id == 6) { $data['title'] = 'Việc Làm Tạp Vụ, Giúp Việc - Tìm việc làm tạp vụ, giúp việc ĐN'; } elseif ($id == 7) { $data['title'] = 'Việc Làm Thực Tập - Tìm việc làm thực tập sinh viên Đà Nẵng'; } elseif ($id == 8) { $data['title'] = 'Việc Làm Cộng Tác Viên - Tuyển cộng tác viên - Tìm việc CTV'; } elseif ($id == 9) { $data['title'] = 'Việc Làm Freelancer Đà Nẵng- Tìm việc freelancer - Freelancer '; } else { $data['title'] = 'Việc làm đa cấp | Website viec lam sinh vien so 1 tai Da Nang'; } return View::make('template.content', $data); }
public function tim_viec_danh_muc($id, $phanloai, $title) { $data['post'] = Page::where('loai', $id)->where('phanloai', $phanloai)->orderBy('id', 'desc')->paginate(11); $data['loai'] = $id; $data['phan_loai'] = '.phan-loai-' . $phanloai; if ($id == 1) { $data['title'] = 'Gia sư sinh viên | Website viec lam sinh vien uy tin tai da nang'; } elseif ($id == 2) { $data['title'] = 'Nhân viên bán hàng | Website viec lam sinh vien uy tin tai da nang'; } elseif ($id == 3) { $data['title'] = 'Việc làm phát tờ rơi, giữ xe, bảo vệ dành cho sinh viên tại Đà Nẵng'; } elseif ($id == 4) { $data['title'] = 'Việc làm nhà hàng, cafe, tiệc cưới dành cho sinh viên tại Đà Nẵng'; } elseif ($id == 5) { $data['title'] = 'PG-PB, Tiếp thị, Khảo sát thị trường | Website viec lam uy tin so 1'; } elseif ($id == 6) { $data['title'] = 'Giúp việc nhà, trông coi cửa hàng| Website viec lam sinh vien uy tin'; } elseif ($id == 7) { $data['title'] = 'Việc làm sinh viên thực tập | Website viec lam uy tin tai Da Nang'; } elseif ($id == 8) { $data['title'] = 'Việc làm cộng tác viên | Website viec lam sinh vien uy tin tai Da Nang'; } elseif ($id == 9) { $data['title'] = 'Việc làm freelancer | Website viec lam sinh vien uy tin tai Da Nang'; } else { $data['title'] = 'Việc làm đa cấp | Website viec lam sinh vien so 1 tai Da Nang'; } return View::make('template.content', $data); }
/** * Gets a list of languages that the page has not been translated to or originates from * * @param integer $pageId * @param array $languages * @return array */ public function getUnUsedLanguageList($pageId, $languages) { $existingLangages = $this->Page->where(function ($query) use($pageId) { $query->where('id', $pageId)->orWhere('translated_from_page_id', $pageId); })->lists('title', 'language_id'); return array_diff_key($languages, $existingLangages->toArray()); }
/** * Get total page count. * * @param bool $all * * @return mixed */ protected function totalPages($all = false) { if (!$all) { return $this->page->where('is_published', 1)->where('lang', $this->getLang())->count(); } return $this->page->where('lang', $this->getLang())->count(); }
/** * Creates a compressed cache file for the chapter * * @author Woxxy * @return url to compressed file */ function compress($comic, $language = 'en', $volume = null, $chapter = null, $subchapter = 0) { require_once FCPATH . 'assets/pclzip/pclzip.lib.php'; $files = array(); if (get_setting('fs_dl_volume_enabled') && $volume !== null && $chapter === null) { if ($volume == 0) { show_404(); } $chapters = new Chapter(); $chapters->where('comic_id', $comic->id)->where('volume', $volume)->order_by('volume', 'asc')->order_by('chapter', 'asc')->order_by('subchapter', 'asc')->get(); if ($chapters->result_count() == 0) { show_404(); } $volume_id = $volume; $chapter_id = $chapters->id; $filepath = $comic->directory(); $filename = $this->filename_chapters_compressed($chapters); foreach ($chapters as $chaptere) { $pages = new Page(); $pages->where('chapter_id', $chaptere->id)->get(); foreach ($pages as $page) { $files[] = array(PCLZIP_ATT_FILE_NAME => 'content/comics/' . $comic->directory() . '/' . $chaptere->directory() . '/' . $page->filename, PCLZIP_ATT_FILE_NEW_FULL_NAME => $this->filename_chapter_compressed($chaptere) . '/' . $page->filename); } } } else { $chaptere = new Chapter(); $chaptere->where('comic_id', $comic->id)->where('language', $language)->where('volume', $volume)->where('chapter', $chapter)->where('subchapter', $subchapter); $chaptere->get(); if ($chaptere->result_count() == 0) { show_404(); } $volume_id = 0; $chapter_id = $chaptere->id; $filepath = $comic->directory() . '/' . $chaptere->directory(); $filename = $this->filename_chapter_compressed($chaptere); $pages = new Page(); $pages->where('chapter_id', $chaptere->id)->get(); foreach ($pages as $page) { $files[] = 'content/comics/' . $comic->directory() . '/' . $chaptere->directory() . '/' . $page->filename; } } $this->where('comic_id', $comic->id)->where('volume_id', $volume_id)->where('chapter_id', $chapter_id)->get(); if ($this->result_count() == 0 || !file_exists('content/comics/' . $filepath . '/' . $this->filename)) { $this->remove_old(); $archive = new PclZip('content/comics/' . $filepath . '/' . $filename . '.zip'); $archive->create($files, PCLZIP_OPT_REMOVE_ALL_PATH, PCLZIP_OPT_NO_COMPRESSION); $this->comic_id = $comic->id; $this->volume_id = $volume_id; $this->chapter_id = $chapter_id; $this->filename = $filename . '.zip'; $this->size = filesize('content/comics/' . $filepath . '/' . $filename . '.zip'); $this->lastdownload = date('Y-m-d H:i:s', time()); $this->save(); } else { $this->lastdownload = date('Y-m-d H:i:s', time()); $this->save(); } return array("url" => site_url() . 'content/comics/' . $filepath . '/' . urlencode($this->filename), "server_path" => FCPATH . 'content/comics/' . $filepath . '/' . $this->filename); }
public function getMappedPage() { $page = Page::where('uri', $this->uri)->first(); if (!$page) { return false; } return $page; }
/** * Setup the layout used by the controller. * * @return void */ public function view($slug) { if ($page = Page::where('slug', $slug)->first()) { return View::make('pages.index')->with('page', $page)->with('custom', '0'); } else { App::abort('404'); } }
public static function boot() { parent::boot(); //删除时先删除相关文档、单页 self::deleting(function (User $user) { Article::where('uid', '=', $user->id)->delete(); Page::where('uid', '=', $user->id)->delete(); }); }
function index() { $pages = new Page(); if (@$_GET['search']) { $pages->where("title like '%" . $_GET['search'] . "%'"); } $data['pages'] = $pages->order_by('id', 'desc')->get_page(); $this->template->build('admin/page_index', $data); }
/** * Display the specified resource. * * @param string $slug * @return Response */ public function show($slug) { // Check if the page exists if (is_null($page = Page::where('slug', $slug)->first())) { // Put a 404 in ur face, yo ! return App::abort(404); } return View::make('modules.page.show')->with('page', Page::where('slug', $slug)->first()); }
/** * Display customer profile * * @param $profile * @return Response */ public function show($profile) { $p = User::where('profile_url', '=', $profile)->where('approved', '=', '0')->first(); $page = Page::where('title', '=', 'faq-customer')->first(); $follow = Follow::where('user', $p->id)->where('hub', '=', 0)->get(); $follow_hub = Follow::where('user', $p->id)->where('artist', '=', 0)->get(); $wall = new \Illuminate\Database\Eloquent\Collection(); $events = new \Illuminate\Database\Eloquent\Collection(); $comments = Comment::where('user', '=', $p->id)->orderBy('created_at', 'desc')->get(); $hidden = unserialize(Cookie::get('hide')); //dd( Cookie::get('hide') ); if (count($follow) > 0) { foreach ($follow as $f) { $s = Song::where('artist', '=', $f->artist)->where('completed', '=', '1')->get(); $e = ArtistEvent::where('artist', '=', $f->artist)->where('date', '>', \Carbon\Carbon::now())->get(); $wall = $wall->merge($s); $events = $events->merge($e); } } if (count($follow_hub) > 0) { foreach ($follow_hub as $h) { $hub = Hub::where('id', '=', $h->hub)->first(); if (!is_null($hub)) { $artists = User::where('type', '=', 'artist')->where('hub', '=', $hub->id)->get(); $artists_list = []; $songs = []; $events = []; foreach ($artists as $a) { $artists_list[] = $a->id; } if (count($artists_list) > 0) { $songs = Song::where('completed', '=', '1')->whereIn('artist', $artists_list)->orderBy('created_at', 'desc')->get(); $events = ArtistEvent::whereIn('artist', $artists_list)->get(); } $news = News::where('hub', '=', $hub->id)->take(3)->get(); $wall = $wall->merge($songs); $events = $events->merge($events); } } } $purchased = Purchase::where('customer', '=', $p->id)->get(); foreach ($purchased as $pp) { $song_purchased = Song::withTrashed()->where('id', '=', $pp->song)->get(); $download = Download::where('customer', '=', $p->id)->where('song', '=', $pp->song)->first(); $song_purchased[0]->purchased = true; if (isset($download)) { $song_purchased[0]->link = $download->url; } $wall = $wall->merge($song_purchased); } $wall->sortByDesc('created_at'); if (!isset($news)) { $news = null; } return View::make('customer.profile-new', ['profile' => $p, 'wall' => $wall, 'page' => $page, 'events' => $events, 'comments' => $comments, 'hidden' => $hidden, 'news' => $news]); }
/** @test **/ public function it_returns_the_fresh_model_fetched_from_the_database() { $this->createComponent('pages'); $this->insertOn('pages', ['title' => 'Psych!', 'content' => 'GUUUS!!!']); $page = Page::where('title', 'Psych!')->first(); $page->title = 'House'; $page = $page->fresh(); $this->assertEquals('Psych!', $page->title); $this->assertEquals('GUUUS!!!', $page->content); }
public static function getPageid() { $route = AppHelper::curPageURL(); $pageId = Page::where('route', '=', $route)->get(); //return $user; foreach ($pageId as $value) { $id = $value['id']; } return $id; }
public function getPage($slug) { $page = Page::where('slug', $slug)->first(); if (empty($page)) { $page = new Page(); $page->slug = $slug; $page->content = "Empty Page -> Please Edit in Admin Section"; $page->save(); } return View::make('site.pages.index', compact('page')); }
/** * Display the specified post. * * @param int $id * @return Response */ public function index($slug) { $page = Page::where('slug', '=', $slug)->first(); //Make sure page is active if (!Auth::guest() && Auth::user()->role == 'admin' || $page->active) { $author = User::find($page->user_id); $data = array('page' => $page, 'author' => $author, 'menu' => Menu::orderBy('order', 'ASC')->get(), 'video_categories' => VideoCategory::all(), 'post_categories' => PostCategory::all(), 'theme_settings' => ThemeHelper::getThemeSettings(), 'pages' => Page::all()); return View::make('Theme::page', $data); } else { return Redirect::to('pages')->with(array('note' => 'Sorry, this page is no longer active.', 'note_type' => 'error')); } }
/** * Returns the comic * * Available filters: id (required) * * @author Woxxy */ function comic_get() { if ($this->get('id')) { //// check that the id is at least a valid number $this->_check_id(); // get the comic $comic = new Comic(); $comic->where('id', $this->get('id'))->limit(1)->get(); } else { if ($this->get('stub')) { // mostly used for load balancer $comic = new Comic(); $comic->where('stub', $this->get('stub')); // back compatibility with version 0.7.6, though stub is already an unique key if ($this->get('uniqid')) { $comic->where('uniqid', $this->get('uniqid')); } $comic->limit(1)->get(); } else { $this->response(array('error' => _('You didn\'t use the necessary parameters')), 404); } } if ($comic->result_count() == 1) { $chapters = new Chapter(); $chapters->where('comic_id', $comic->id)->get(); $chapters->get_teams(); $result = array(); $result["comic"] = $comic->to_array(); // order in the beautiful [comic][chapter][teams][page] $result["chapters"] = array(); foreach ($chapters->all as $key => $chapter) { $result['chapters'][$key]['comic'] = $result["comic"]; $result['chapters'][$key]['chapter'] = $chapter->to_array(); // if it's requested, throw in also the pages (for load balancer) if ($this->get('chapter_stub') == $chapter->stub && $this->get('chapter_uniqid') == $chapter->uniqid) { $pages = new Page(); $pages->where('chapter_id', $chapter->id)->get(); $result["chapters"][$key]["chapter"]["pages"] = $pages->all_to_array(); } // teams is a normal array, can't use $team->all_to_array() foreach ($chapter->teams as $team) { $result['chapters'][$key]['teams'][] = $team->to_array(); } } // all good $this->response($result, 200); // 200 being the HTTP response code } else { // there's no comic with that id $this->response(array('error' => _('Comic could not be found')), 404); } }
public function viewPage($urlString) { try { $page = Page::where('urlString', $urlString)->first(); if (!$page) { return Response::notFound(); } $page = Page::decodePageJson($page); return View::make('pages/viewPage')->with(array('page' => $page, 'currentPage' => 'viewPage', 'ogImage' => $page['ogData']['ogImage'], 'ogTitle' => $page['ogData']['ogTitle'], 'title' => $page['title'] ? $page['title'] : '', 'ogDescription' => $page['ogData']['ogDescription'], 'description' => $page['description'] ? $page['description'] : '')); } catch (Illuminate\Database\Eloquent\ModelNotFoundException $e) { return Response::notFound('Quiz not found'); } }
public static function register() { // register home page Registry::set('home_page', Page::home()); // register posts page Registry::set('posts_page', Page::posts()); if (!is_admin()) { // register menu items $pages = Page::where('show_in_menu', '=', '1')->sort('menu_order')->get(); $pages = new Items($pages); Registry::set('menu', $pages); Registry::set('total_menu_items', $pages->length()); } }
/** * This method checks to see if a view exists and if it does loads it along with any * associated data from the database. It then checks to see if a function exists for * the passed in page name (substituting dashes for underscores and runs that) if it exists. * @param string $page The page name * @param string $variable Allows us to pass a second variable to things * @return view Ideally a view of some kind */ public function get_index($page = 'home', $variable = false) { $this->data['page'] = Page::where('slug', '=', $page)->first(); $function = strtolower(Request::method() . '_' . str_replace('-', '_', $page)); if (method_exists($this, $function)) { $this->{$function}($variable); } else { if (View::exists('site.' . $page)) { return View::make('site.' . $page, $this->data); } else { return Response::error('404'); } } }
/** * Initializer. * * @return void */ public function __construct() { // CSRF Protection $this->beforeFilter('csrf', array('on' => 'post')); // Initialization of the MessageBag $this->messageBag = new Illuminate\Support\MessageBag(); if (Route::currentRouteName() != 'setLang') { if (Session::get('locale')) { App::setLocale(Session::get('locale')); } else { Session::put('locale', 'fr'); App::setLocale('fr'); } } View::share('locale', Session::get('locale') ? Session::get('locale') : App::getLocale()); View::share('menu_pages', Schema::hasTable('pages') ? Page::where('draft', '0')->where('in_menu', '1')->where('lang', Session::get('locale'))->get(array('title', 'slug')) : null); }
/** * [isValidInputForNewPage description] * @param [type] $input * @return boolean */ protected function isValidInputForNewPage($input) { // validate the input given before we create the page $this->validator = $this->Validator->make($input, $this->Page->createRules, $this->Page->messages); $fails = $this->validator->fails(); if ($fails) { $this->errors = $this->validator->errors()->all(); $this->message = "There were validation errors."; } // check to make sure that there is no duplicate slug/method out there $duplicatePage = $this->Page->where('http_verb', $input['http_verb'])->where('slug', $input['slug'])->first(); if ($duplicatePage) { $this->errors = $this->validator->errors()->all(); $this->errors['slug'] = 'There is already a page with this slug/verb pair'; $this->message = "There were validation errors."; } return count($this->errors) == 0; }
public static function register() { // register home page Registry::set('home_page', Page::home()); // register posts page Registry::set('posts_page', Page::posts()); if (!is_admin()) { // register categories foreach (Category::get() as $itm) { $categories[$itm->id] = $itm; } Registry::set('all_categories', $categories); // register menu items $pages = Page::where('status', '=', 'published')->where('show_in_menu', '=', '1')->sort('menu_order')->get(); $pages = new Items($pages); Registry::set('menu', $pages); Registry::set('total_menu_items', $pages->length()); } }
/** * Show charity profile * * @param int $charity * * @return Response * */ public function show($charity) { $profile = User::where('profile_url', '=', $charity)->where('approved', '=', '0')->first(); if ($profile->charity) { $page = Page::where('title', '=', 'faq-charity')->first(); $songs = Song::where('charity', $profile->charity->id)->where('charity_approved', '=', 1)->orderBy('created_at', 'desc')->get(); $songs_in = []; $approval = Song::where('charity', $profile->charity->id)->where('charity_approved', '=', 0)->get(); foreach ($songs as $s) { $songs_in[] = $s->id; } if (count($songs_in) > 0) { $comments = Comment::whereIn('song', $songs_in)->orderBy('id', 'desc')->take(3)->get(); } else { $comments = ""; } return View::make('charity.profile-new', ['profile' => $profile, 'wall' => $songs, 'page' => $page, 'comments' => $comments, 'approval' => $approval]); } else { return Redirect::to('charity/settings'); } }
function __construct() { if (SECOND_PARAMETER === 'new') { $this->newPage(); } if (!SECOND_PARAMETER || !Validate::slug(SECOND_PARAMETER)) { Base::redirect('/oops'); } $this->page = Page::where('slug', SECOND_PARAMETER)->findOne(); if (!$this->page) { Base::redirect('/oops'); } // Page title View::set('page_title', $this->page->title); if (ctype_lower(THIRD_PARAMETER) && method_exists($this, THIRD_PARAMETER)) { $func = THIRD_PARAMETER; $this->{$func}(); } else { $this->page(); } }
/** * Function to create a new page from a $filedata array. It deals with * processing the image data, checks if it's an image, puts values like * height in the variables, sends to database function and file function. * * This function fails silently for the user. For now. * * @author Woxxy * @param array|$filedata It's an array of data produced by CodeIgniter * upload function * @param int|$chapter_id The ID of the chapter * @param int|$hidden NOT USED * @param string|$description NOT USED * @return boolean true on success, false on failure. */ public function add_page($filedata, $chapter_id, $hidden = 0, $description = "") { // Check if that file is actually an image if (!$imagedata = @getimagesize($filedata["server_path"])) { log_message('error', 'add_page: uploaded file doesn\'t seem to be an image'); return false; } // Let's set some variables $this->chapter_id = $chapter_id; // Load the chapter and comic as soon as possible. if (!$this->get_chapter()) { log_message('error', 'add_page: couldn\'t find related chapter'); return false; } if ($hidden == 1) $this->hidden = 1; else $this->hidden = 0; $this->description = $description; // Decide if it should overwrite. Normally files get overwritten. $overwrite = $filedata["overwrite"]; // Throw the image to the folder with this function // While we aren't looking, this also creates the thumbnails if (!$this->add_page_file($filedata)) { log_message('error', 'add_page: failed creating file'); return false; } // We need the dir to the chapter $dir = "content/comics/" . $this->chapter->comic->directory() . "/" . $this->chapter->directory() . "/"; // $imagedata = @getimagesize($filedata["server_path"]); // We had set $imagedata before // We already have the thumbnail! Get data for that too. $thumbdata = @getimagesize($dir . "thumb_" . $filedata["name"]); // If a page in this chapter with the same filename exists, pick its ID and start updating it // This makes so everything gets overwritten with no error $page = new Page(); $page->where('chapter_id', $this->chapter_id)->where('filename', $filedata["name"])->get(); if ($page->result_count() > 0) { $this->id = $page->id; } // Prepare the variables $this->filename = $filedata["name"]; $this->thumbnail = "thumb_"; $this->width = $imagedata["0"]; $this->height = $imagedata["1"]; $this->size = filesize($dir . $filedata["name"]); $this->mime = image_type_to_mime_type($imagedata["2"]); $this->thumbwidth = $thumbdata["0"]; $this->thumbheight = $thumbdata["1"]; $this->thumbsize = filesize($dir . "thumb_" . $filedata["name"]); // Check from the thumbnail if the image is in colors or not $is_bw = $this->is_bw(); if ($is_bw == "bw") $this->grayscale = 1; else if ($is_bw == "rgb") $this->grayscale = 0; else { log_message('error', 'add_page: error while determining if black and white or RGB'); return false; } // Finally, save everything to database, and, in case of failure, remove the image files if (!$this->update_page_db()) { log_message('error', 'add_page: failed writing to database'); $this->remove_page_file(); return false; } // All good return true; }
private function createTree($pages) { foreach ($pages as $page) { $slug = $page->slug; if ($page->has_child) { if ($page->level == 0) { $final[] = $page->page_name; } $children = Page::where('parent', '=', $slug)->get(); foreach ($children as $sub) { $slug2 = $sub->slug; if ($sub->level == 1) { $g = "-"; $g .= $sub->page_name; $final[] = $g; } if ($sub->has_child) { $children2 = Page::where('parent', '=', $slug2)->get(); foreach ($children2 as $sub2) { if ($sub2->level == 2) { $g = "--"; } $g .= $sub2->page_name; $final[] = $g; } } } } else { if ($page->level == 0) { $final[] = $page->page_name; } } } return $final; }
public function post_delete_user() { $user = User::find(Input::get('id')); $user->delete(); $post = Post::where('user_id', Input::get('id')); $post->delete(); $page = Page::where('user_id', Input::get('id')); $page->delete(); return Redirect::to(Input::get('url_full'))->with('delete_user', 'Xóa tài khoản thành công'); }
/** * Function to create a new page from a $filedata array. It deals with * processing the image data, checks if it's an image, puts values like * height in the variables, sends to database function and file function. * * This function fails silently for the user. For now. * * @author Woxxy * @param array|$filedata It's an array of data produced by CodeIgniter * upload function * @param int|$chapter_id The ID of the chapter * @param int|$hidden NOT USED * @param string|$description NOT USED * @return boolean true on success, false on failure. */ public function add_page($path, $filename, $chapter) { // Check if that file is actually an image if (!($imagedata = @getimagesize($path))) { log_message('error', 'add_page: uploaded file doesn\'t seem to be an image'); return false; } // Let's set some variables $this->chapter_id = $chapter->id; // Load the chapter and comic as soon as possible. if (!$this->get_chapter()) { log_message('error', 'add_page: couldn\'t find related chapter'); return false; } // Throw the image to the folder with this function // While we aren't looking, this also creates the thumbnails if (!$this->add_page_file($path, $filename)) { log_message('error', 'add_page: failed creating file'); return false; } // We need the dir to the chapter $dir = "content/comics/" . $this->chapter->comic->directory() . "/" . $this->chapter->directory() . "/"; // If a page in this chapter with the same filename exists, pick its ID and start updating it // This makes so everything gets overwritten with no error $page = new Page(); $page->where('chapter_id', $this->chapter_id)->where('filename', $filename)->get(); if ($page->result_count() > 0) { $this->id = $page->id; } // Prepare the variables $this->filename = $filename; $this->width = $imagedata["0"]; $this->height = $imagedata["1"]; $this->size = filesize($dir . $filename); $this->mime = image_type_to_mime_type($imagedata["2"]); // Finally, save everything to database, and, in case of failure, remove the image files if (!$this->update_page_db()) { log_message('error', 'add_page: failed writing to database'); $this->remove_page_file(); return false; } $this->on_change($chapter); // All good return true; }
public function searchable($searchterm) { $searchresults = array(); // Search posts table $posts = Post::where('title', 'LIKE', '%' . $searchterm . '%')->orWhere('content', 'LIKE', '%' . $searchterm . '%')->published()->get(); if ($posts->count()) { foreach ($posts as $post) { $searchresults[] = array('type' => 'artikel', 'type_category' => $post->category->title, 'title' => $post->title, 'link' => 'posts/' . $post->slug, 'content' => $post->excerpt != NULL ? $post->excerpt : str_limit(strip_tags($post->content), 300), 'image' => $post->image, 'original_updated_at' => $post->updated_at, 'updated_at' => $post->translateDate($post->updated_at)); } } // Search pages table $pages = Page::where('title', 'LIKE', '%' . $searchterm . '%')->orWhere('content', 'LIKE', '%' . $searchterm . '%')->published()->get(); if ($pages->count()) { foreach ($pages as $page) { $searchresults[] = array('type' => 'halaman', 'type_category' => NULL, 'title' => $page->title, 'link' => 'pages/' . $page->slug, 'content' => $page->excerpt != NULL ? $page->excerpt : str_limit(strip_tags($page->content), 300), 'image' => NULL, 'original_updated_at' => $page->updated_at, 'updated_at' => $page->translateDate($page->updated_at)); } } // print_r($searchresults); // array_sort($searchresults,'updated_at',SORT_DESC); // sort by latest updated return $searchresults; }