prefix . 'terms'; } public function get_title_column() { return 'name'; } public function save( $row_id, array $changes ) { $term = $this->get_columns_to_change( $changes ); if ( count( $term ) > 0 ) { $update = []; global $wpdb; $existing = $wpdb->get_row( $wpdb->prepare( "SELECT t.term_id, t.name, t.slug, tt.taxonomy FROM {$wpdb->terms} t INNER JOIN {$wpdb->term_taxonomy} tt ON t.term_id = tt.term_id WHERE t.term_id = %d LIMIT 1", $row_id ) ); if ( $existing === null ) { return new \WP_Error( 'searchregex', 'Term not found.' ); } if ( isset( $term['name'] ) ) { $update['name'] = (string) $term['name']; } if ( isset( $term['slug'] ) ) { $update['slug'] = (string) $term['slug']; } if ( isset( $term['description'] ) ) { $update['description'] = (string) $term['description']; } $this->log_save( 'term', array_merge( [ 'term_id' => $row_id ], $term ) ); // This does all the sanitization $result = true; if ( Plugin\Settings::init()->can_save() && count( $update ) > 0 ) { $result = wp_update_term( $row_id, $existing->taxonomy, $update ); } if ( $result ) { return true; } return new \WP_Error( 'searchregex', 'Failed to update term.' ); } return true; } public function delete_row( $row_id ) { $this->log_save( 'delete term', $row_id ); if ( Plugin\Settings::init()->can_save() ) { $term = get_term( $row_id ); if ( $term instanceof \WP_Term && wp_delete_term( $row_id, $term->taxonomy ) ) { return true; } return new \WP_Error( 'searchregex_delete', 'Failed to delete term', 401 ); } return true; } public function autocomplete( array $column, $value ) { global $wpdb; if ( $column['column'] === 'name' ) { // phpcs:ignore return $wpdb->get_results( $wpdb->prepare( "SELECT DISTINCT name as id,name as value FROM {$this->get_table_name()} WHERE name LIKE %s LIMIT %d", '%' . $wpdb->esc_like( $value ) . '%', self::AUTOCOMPLETE_LIMIT ) ); } if ( $column['column'] === 'slug' ) { // phpcs:ignore return $wpdb->get_results( $wpdb->prepare( "SELECT DISTINCT slug as id,slug as value FROM {$this->get_table_name()} WHERE slug LIKE %s LIMIT %d", '%' . $wpdb->esc_like( $value ) . '%', self::AUTOCOMPLETE_LIMIT ) ); } if ( $column['column'] === 'description' ) { // phpcs:ignore return $wpdb->get_results( $wpdb->prepare( "SELECT DISTINCT tt.description as id,tt.description as value FROM {$wpdb->term_taxonomy} AS tt WHERE tt.description LIKE %s AND tt.description != '' LIMIT %d", '%' . $wpdb->esc_like( $value ) . '%', self::AUTOCOMPLETE_LIMIT ) ); } return []; } public function get_schema() { global $wpdb; $taxonomies = []; $taxes = get_taxonomies( [], 'objects' ); foreach ( $taxes as $tax ) { // @phpstan-ignore function.alreadyNarrowedType if ( is_object( $tax ) ) { $taxonomies[] = [ 'value' => $tax->name, 'label' => $tax->label, ]; } } return [ 'name' => __( 'Terms', 'search-regex' ), 'table' => $wpdb->prefix . 'terms', 'columns' => [ [ 'column' => 'term_id', 'type' => 'integer', 'title' => __( 'ID', 'search-regex' ), 'options' => 'api', 'modify' => false, ], [ 'column' => 'name', 'type' => 'string', 'title' => __( 'Name', 'search-regex' ), 'options' => 'api', 'global' => true, ], [ 'column' => 'slug', 'type' => 'string', 'title' => __( 'Slug', 'search-regex' ), 'options' => 'api', 'global' => true, ], [ 'column' => 'description', 'type' => 'string', 'title' => __( 'Description', 'search-regex' ), 'options' => 'api', 'join' => 'description', 'global' => true, ], [ 'column' => 'taxonomy', 'type' => 'member', 'title' => __( 'Taxonomy', 'search-regex' ), 'options' => $taxonomies, 'join' => 'taxonomy', 'modify' => false, ], ], ]; } }