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); }
public function action_create() { $post_page = Input::get('postpage') ? 1 : 0; $page = Page::where('page_name', '=', str_replace('-', '', Input::get('sub')))->first(); $order = Page::order_by('created_at', 'desc')->first(); $level = Input::get('subpage') ? $page->level + 1 : 0; $parent = Input::get('subpage') ? $page->slug : 'none'; $slug = $this->slugger(Input::get('title')); $input = array('page_name' => Input::get('title'), 'page_content' => Input::get('content'), 'level' => $level, 'order' => $order->order + 1, 'slug' => $slug, 'parent' => $parent, 'has_child' => 0, 'post_page' => $post_page); $success = Page::create($input); if (Input::get('subpage')) { $p = Page::where('page_name', '=', str_replace('-', '', Input::get('sub')))->first(); $p->has_child = '1'; $p->save(); } if (!$success) { Log::write('admin.pages.create', 'Page was not created, page->create() returned false.'); return Redirect::to('/admin/pages/new')->with('error_create', 'Unable to create page!'); } return Redirect::to('/admin/pages/new')->with('status_create', 'New Page Created')->with('id', $success->id); }
/** * @author chenliujin <*****@*****.**> * @since 2016-10-09 */ public static function GetAllProducts() { $sql = "\n\t\t\tSELECT \n\t\t\t\tp.products_type, \n\t\t\t\tp.products_id, \n\t\t\t\tpd.products_name, \n\t\t\t\tp.products_image, \n\t\t\t\tp.products_price, \n\t\t\t\tp.products_tax_class_id, \n\t\t\t\tp.products_date_added, \n\t\t\t\tm.manufacturers_name, \n\t\t\t\tp.products_model, \n\t\t\t\tp.products_quantity, \n\t\t\t\tp.products_weight, \n\t\t\t\tp.product_is_call, \n\t\t\t\tp.product_is_always_free_shipping, \n\t\t\t\tp.products_qty_box_status, \n\t\t\t\tp.master_categories_id \n\t\t\tFROM " . self::GetTableName() . " p LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd \n\t\t\tWHERE \n\t\t\t\tp.products_status = 1 AND \n\t\t\t\tp.products_id = pd.products_id AND \n\t\t\t\tpd.language_id = ? \n\t\t\t"; $params = [$_SESSION['languages_id']]; $page = new \Page($sql, $params); $page->per_page_rows(15); $page->order_by('ORDER BY products_id DESC'); return $page; }