' . \__('All available folders will be exported. The current structure is not lost during import - but check that there are no duplicate names in the import data, as these are not checked.', RML_TD) . '
' . \__('Importing data is only available in PRO version.', RML_TD) . ' ' . \__('Learn more about PRO', RML_TD) . '
'; } } /** * Output import button in options. */ public function html_rml_button_import_cats() { $hasMediaLibraryFolders = $this->hasMediaLibraryFolders(); $hasFileBird = $this->hasFileBird(); if (\count($this->getHierarchicalTaxos()) || $hasMediaLibraryFolders || $hasFileBird) { $disabled = $this->isPro() ? '' : 'disabled="disabled"'; foreach ($this->getHierarchicalTaxos() as $tax) { $name = isset(self::IMPORT_TAX_MATRIX[$tax]) ? self::IMPORT_TAX_MATRIX[$tax] : '' . $tax . '';
echo '' . \__('Import', RML_TD) . ' (' . $name . ') ';
}
// Media Library Folders plugin
if ($hasMediaLibraryFolders) {
echo '' . \__('Import', RML_TD) . ' (Media Library Folders) ';
}
// Filebird plugin
if ($hasFileBird) {
echo '' . \__('Import', RML_TD) . ' (FileBird) ';
}
echo '' . \__('Imports categories and post relations.', RML_TD) . '
'; } else { echo '' . \__('Nothing to import.', RML_TD) . '
'; } if (!$this->isPro()) { echo '' . \__('Importing categories from another plugin is only available in PRO version.', RML_TD) . ' ' . \__('Learn more about PRO', RML_TD) . '
'; } } /** * Get the folder tree for import process. * * @return array */ public function getFolders() { global $wpdb; // phpcs:disable WordPress.DB.PreparedSQL // Folders $table_name = $this->getTableName(); $folders = $wpdb->get_results('SELECT id,parent,' . \implode(',', $this->columns) . " FROM {$table_name}", ARRAY_A); // Metas $table_name = $this->getTableName('meta'); $metas = Util::getInstance()->group_by($wpdb->get_results("SELECT * FROM {$table_name}", ARRAY_A), 'realmedialibrary_id'); // phpcs:enable WordPress.DB.PreparedSQL // Group metas $grouped = []; foreach ($folders as $folder) { // Assign metas if (isset($metas[$folder['id']])) { $folder['__metas'] = []; foreach ($metas[$folder['id']] as $meta) { unset($meta['meta_id']); unset($meta['realmedialibrary_id']); $folder['__metas'][] = $meta; } } $grouped[] = $folder; } // Cast foreach ($grouped as &$row) { $row['parent'] = \intval($row['parent']); $row['id'] = \intval($row['id']); } // Create tree $tree = Util::getInstance()->buildTree($grouped, -1, 'parent', 'id', '__children'); return Util::getInstance()->clearTree($tree, ['id', 'parent'], '__children'); } /** * Get the hierarchical taxonomies for the media taxonomy. It also * returns taxonomies which are no longer registered * * @return string[] */ public function getHierarchicalTaxos() { global $wpdb; // Fetch the taxonomies which are able to filter $taxonomy_objects = \get_object_taxonomies('attachment', 'objects'); $taxos = []; foreach ($taxonomy_objects as $key => $value) { if ($value->hierarchical === \true) { $taxos[] = $key; } } // Read non-active ones // phpcs:disable WordPress.DB.PreparedSQL $taxonomy_sql = $wpdb->get_col("SELECT DISTINCT(wptt.taxonomy) FROM {$wpdb->term_taxonomy} AS wptt\n INNER JOIN {$wpdb->term_relationships} AS wptr ON wptt.term_taxonomy_id = wptr.term_taxonomy_id\n INNER JOIN {$wpdb->posts} AS wpp ON wptr.object_id = wpp.ID\n WHERE wpp.post_type = 'attachment'"); // phpcs:enable WordPress.DB.PreparedSQL return \array_diff(\array_unique(\array_merge($taxonomy_sql, $taxos)), self::IMPORT_TAX_IGNORE); } /** * Checks if the import notice in folder tree sidebar is dismissed. * * @param boolean $set * @return boolean */ public function isImportTaxNoticeDismissed($set = null) { $value = '1'; $expireOption = new ExpireOption(RML_OPT_PREFIX . '_importTaxNotice', \false, 365 * \constant('DAY_IN_SECONDS')); $expireOption->enableTransientMigration(ExpireOption::TRANSIENT_MIGRATION_SITE_WIDE); if ($set !== null) { $expireOption->set($set ? $value : 0); } return $expireOption->get() === $value; } /** * Checks if "Media Library Folders" was used previously. * * @see https://de.wordpress.org/plugins/media-library-plus/ */ public function hasMediaLibraryFolders() { global $wpdb; return \intval($wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$wpdb->posts} WHERE post_type=%s", self::MLF_POST_TYPE))) > 0; } /** * Checks if "Filebird" was used previously. */ public function hasFileBird() { global $wpdb; // Check if table exists // phpcs:disable WordPress.DB.PreparedSQL $table_name = $wpdb->prefix . self::FILE_BIRD_TABLE_NAME_POSTS; $exists = $wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") === $table_name; // phpcs:enable WordPress.DB.PreparedSQL return $exists; } /** * Get instance. * * @return ExImport */ public static function getInstance() { return self::$me === null ? self::$me = new \MatthiasWeb\RealMediaLibrary\comp\ExImport() : self::$me; } }