->get_total_unindexed() === 0 ) { $columns[ 'wpseo-' . self::COLUMN_LINKED ] = \sprintf( '%2$s', \esc_attr__( 'Number of internal links linking to this post. See "Yoast Columns" text in the help tab for more info.', 'wordpress-seo' ), \esc_html__( 'Received internal links', 'wordpress-seo' ) ); } return $columns; } /** * Modifies the query pieces to allow ordering column by links to post. * * @param array $pieces Array of Query pieces. * @param WP_Query $query The Query on which to apply. * * @return array */ public function order_by_linked( $pieces, $query ) { if ( $query->get( 'orderby' ) !== 'wpseo-' . self::COLUMN_LINKED ) { return $pieces; } return $this->build_sort_query_pieces( $pieces, $query, 'incoming_link_count' ); } /** * Modifies the query pieces to allow ordering column by links to post. * * @param array $pieces Array of Query pieces. * @param WP_Query $query The Query on which to apply. * * @return array */ public function order_by_links( $pieces, $query ) { if ( $query->get( 'orderby' ) !== 'wpseo-' . self::COLUMN_LINKS ) { return $pieces; } return $this->build_sort_query_pieces( $pieces, $query, 'link_count' ); } /** * Builds the pieces for a sorting query. * * @param array $pieces Array of Query pieces. * @param WP_Query $query The Query on which to apply. * @param string $field The field in the table to JOIN on. * * @return array Modified Query pieces. */ protected function build_sort_query_pieces( $pieces, $query, $field ) { // We only want our code to run in the main WP query. if ( ! $query->is_main_query() ) { return $pieces; } // Get the order query variable - ASC or DESC. $order = \strtoupper( $query->get( 'order' ) ); // Make sure the order setting qualifies. If not, set default as ASC. if ( ! \in_array( $order, [ 'ASC', 'DESC' ], true ) ) { $order = 'ASC'; } $table = Model::get_table_name( 'Indexable' ); $pieces['join'] .= " LEFT JOIN $table AS yoast_indexable ON yoast_indexable.object_id = {$this->wpdb->posts}.ID AND yoast_indexable.object_type = 'post' "; $pieces['orderby'] = "yoast_indexable.$field $order, FIELD( {$this->wpdb->posts}.post_status, 'publish' ) $order, {$pieces['orderby']}"; return $pieces; } /** * Displays the column content for the given column. * * @param string $column_name Column to display the content for. * @param int $post_id Post to display the column content for. */ public function column_content( $column_name, $post_id ) { $indexable = $this->admin_columns_cache->get_indexable( $post_id ); // Nothing to output if we don't have the value. if ( $indexable === false ) { return; } switch ( $column_name ) { case 'wpseo-' . self::COLUMN_LINKS: echo (int) $indexable->link_count; return; case 'wpseo-' . self::COLUMN_LINKED: if ( \get_post_status( $post_id ) === 'publish' ) { echo (int) $indexable->incoming_link_count; } } } /** * Sets the sortable columns. * * @param array $columns Array with sortable columns. * * @return array The extended array with sortable columns. */ public function column_sort( array $columns ) { $columns[ 'wpseo-' . self::COLUMN_LINKS ] = 'wpseo-' . self::COLUMN_LINKS; $columns[ 'wpseo-' . self::COLUMN_LINKED ] = 'wpseo-' . self::COLUMN_LINKED; return $columns; } } Нейросеть назвала города — лидеры по росту цен на жилье в 2022 году
Воскресенье, 29 января, 2023