Example #1
0
 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);
 }
Example #2
0
 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);
 }
Example #3
0
 /**
  * @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;
 }