/**
* Previous Imports list
*/
public function index()
{
$get = $this->input->get(array('s' => '', 'order_by' => 'registered_on', '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 PMXI_Import_List();
$post = new PMXI_Post_Record();
$by = array('parent_import_id' => 0);
if ('' != $s) {
$like = '%' . preg_replace('%\\s+%', '%', preg_replace('/[%?]/', '\\\\$0', $s)) . '%';
$by[] = array(array('name LIKE' => $like, 'type LIKE' => $like, 'path LIKE' => $like, 'friendly_name LIKE' => $like), 'OR');
}
$this->data['list'] = $list->join($post->getTable(), $list->getTable() . '.id = ' . $post->getTable() . '.import_id', 'LEFT')->setColumns($list->getTable() . '.*', 'COUNT(' . $post->getTable() . '.post_id' . ') AS post_count')->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' => 'pmxi-admin-manage'), 'format' => '', 'prev_text' => __('«', 'wp_all_import_plugin'), 'next_text' => __('»', 'wp_all_import_plugin'), 'total' => ceil($list->total() / $perPage), 'current' => $pagenum));
//pmxi_session_unset();
PMXI_Plugin::$session->clean_session();
$this->render();
}
