/**
* 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();
}
/**
* convert imports options
* compatibility with version 3.2.3
*/
public function _fix_options()
{
global $wpdb;
$imports = new PMXI_Import_List();
$post = new PMXI_Post_Record();
$templates = new PMXI_Template_List();
$template = new PMXI_Template_Record();
$is_migrated = get_option('pmxi_is_migrated');
$uploads = wp_upload_dir();
if (empty($is_migrated) or version_compare($is_migrated, PMXI_VERSION) < 0) {
//PMXI_VERSION
$commit_migration = true;
if (empty($is_migrated)) {
// plugin version less than 4.0.0
wp_all_import_rmdir($uploads['basedir'] . '/wpallimport_history');
wp_all_import_rmdir($uploads['basedir'] . '/wpallimport_logs');
foreach ($imports->setColumns($imports->getTable() . '.*')->getBy(array('id !=' => ''))->convertRecords() as $imp) {
$imp->getById($imp->id);
if (!$imp->isEmpty() and !empty($imp->template)) {
$options = array_merge($imp->options, $imp->template);
$this->__ver_4_transition_fix($options);
$imp->set(array('options' => $options))->update();
if ($imp->type == 'file') {
$imp->set(array('path' => $uploads['basedir'] . DIRECTORY_SEPARATOR . self::FILES_DIRECTORY . DIRECTORY_SEPARATOR . basename($imp->path)))->update();
}
}
}
foreach ($templates->setColumns($templates->getTable() . '.*')->getBy(array('id !=' => ''))->convertRecords() as $tpl) {
$tpl->getById($tpl->id);
if (!$tpl->isEmpty() and !empty($tpl->title)) {
$opt = empty($tpl->options) ? array() : $tpl->options;
$options = array_merge($opt, array('title' => $tpl->title, 'content' => $tpl->content, 'is_keep_linebreaks' => $tpl->is_keep_linebreaks, 'is_leave_html' => $tpl->is_leave_html, 'fix_characters' => $tpl->fix_characters));
$this->__ver_4_transition_fix($options);
$tpl->set(array('options' => $options))->update();
}
}
$commit_migration = $this->__fix_db_schema();
// feature to version 4.0.0
} else {
// migration fixes for vesions
switch ($is_migrated) {
case '4.0.0-beta1':
case '4.0.0-beta2':
case '4.0.0 RC1':
case '4.0.0':
case '4.0.1':
$commit_migration = $this->__fix_db_schema();
// feature to version 4.0.0
break;
case '4.0.2':
case '4.0.3':
case '4.0.4':
break;
default:
# code...
break;
}
foreach ($imports->setColumns($imports->getTable() . '.*')->getBy(array('id !=' => ''))->convertRecords() as $imp) {
$imp->getById($imp->id);
if (!$imp->isEmpty()) {
$options = $imp->options;
$this->__ver_4x_transition_fix($options, $is_migrated);
$imp->set(array('options' => $options))->update();
}
}
foreach ($templates->setColumns($templates->getTable() . '.*')->getBy(array('id !=' => ''))->convertRecords() as $tpl) {
$tpl->getById($tpl->id);
if (!$tpl->isEmpty()) {
$options = empty($tpl->options) ? array() : $tpl->options;
$this->__ver_4x_transition_fix($options, $is_migrated);
$tpl->set(array('options' => $options))->update();
}
}
}
if ($commit_migration) {
update_option('pmxi_is_migrated', PMXI_VERSION);
}
}
}
/**
* convert imports options
* compatibility with version 3.3
*/
public function _fix_options()
{
$imports = new PMXI_Import_List();
$post = new PMXI_Post_Record();
foreach ($imports->setColumns($imports->getTable() . '.*')->getBy(array('large_import' => 'Yes'))->convertRecords() as $imp) {
$imp->getById($imp->id);
if (!$imp->isEmpty() and empty($imp->options['converted_options'])) {
$options = $imp->options;
$options['update_all_data'] = 'no';
$options['create_new_records'] = !empty($options['not_create_records']) ? 0 : 1;
$options['is_update_status'] = !empty($options['is_keep_status']) ? 0 : 1;
$options['is_update_content'] = !empty($options['is_keep_content']) ? 0 : 1;
$options['is_update_title'] = !empty($options['is_keep_title']) ? 0 : 1;
$options['is_update_excerpt'] = !empty($options['is_keep_excerpt']) ? 0 : 1;
$options['is_update_categories'] = !empty($options['is_keep_categories']) ? 0 : 1;
$options['is_update_attachments'] = !empty($options['is_keep_attachments_on_update']) ? 0 : 1;
$options['is_update_images'] = !empty($options['is_keep_images']) ? 0 : 1;
$options['is_update_dates'] = !empty($options['is_keep_dates']) ? 0 : 1;
$options['is_update_menu_order'] = !empty($options['is_keep_menu_order']) ? 0 : 1;
$options['is_update_parent'] = !empty($options['is_keep_parent']) ? 0 : 1;
$options['is_update_custom_fields'] = !empty($options['keep_custom_fields']) ? 0 : 1;
if ("" != $options['keep_custom_fields_specific'] or "" != $options['keep_custom_fields_except']) {
$options['custom_fields_list'] = !empty($options['keep_custom_fields']) ? explode(',', $options['keep_custom_fields_except']) : explode(',', $options['keep_custom_fields_specific']);
$options['update_custom_fields_logic'] = !empty($options['is_update_custom_fields']) ? 'only' : 'all_except';
}
if (!empty($options['is_keep_categories']) and !empty($options['is_add_newest_categories'])) {
$options['is_update_categories'] = 1;
$options['update_categories_logic'] = 'add_new';
}
$options['converted_options'] = 1;
$imp->set(array('options' => $options))->update();
}
}
}
