/** * Previous Imports list */ public function index() { $get = $this->input->get(array('s' => '', 'order_by' => 'id', 'order' => 'DESC', 'pagenum' => 1, 'perPage' => 25)); $get['pagenum'] = absint($get['pagenum']); extract($get); $this->data += $get; if (!in_array($order_by, array('registered_on', 'id', 'name'))) { $order_by = 'registered_on'; } if (!in_array($order, array('DESC', 'ASC'))) { $order = 'DESC'; } $list = new PMXE_Export_List(); $by = null; if ('' != $s) { $like = '%' . preg_replace('%\\s+%', '%', preg_replace('/[%?]/', '\\\\$0', $s)) . '%'; $by[] = array(array('name LIKE' => $like, 'type LIKE' => $like, 'path LIKE' => $like), 'OR'); } $this->data['list'] = $list->setColumns($list->getTable() . '.*')->getBy($by, "{$order_by} {$order}", $pagenum, $perPage, $list->getTable() . '.id'); $this->data['page_links'] = paginate_links(array('base' => add_query_arg('pagenum', '%#%', $this->baseUrl), 'add_args' => array('page' => 'pmxe-admin-manage'), 'format' => '', 'prev_text' => __('«', 'PMXE_plugin'), 'next_text' => __('»', 'PMXE_plugin'), 'total' => ceil($list->total() / $perPage), 'current' => $pagenum)); PMXE_Plugin::$session->clean_session(); $this->render(); }