Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

class WPML_Inactive_Content {

[2] Fix | Delete

[3] Fix | Delete

/** @var wpdb $wpdb */

[4] Fix | Delete

private $wpdb;

[5] Fix | Delete

[6] Fix | Delete

/** @var string $current_language */

[7] Fix | Delete

private $current_language;

[8] Fix | Delete

[9] Fix | Delete

/** @var array $content_types */

[10] Fix | Delete

private $content_types;

[11] Fix | Delete

[12] Fix | Delete

/** @var array $inactive */

[13] Fix | Delete

private $inactive;

[14] Fix | Delete

[15] Fix | Delete

public function __construct( wpdb $wpdb, $current_language ) {

[16] Fix | Delete

$this->wpdb = $wpdb;

[17] Fix | Delete

$this->current_language = $current_language;

[18] Fix | Delete

}

[19] Fix | Delete

[20] Fix | Delete

/** @return bool */

[21] Fix | Delete

public function has_entries() {

[22] Fix | Delete

return (bool) $this->get_inactive();

[23] Fix | Delete

}

[24] Fix | Delete

[25] Fix | Delete

/** @return array */

[26] Fix | Delete

public function get_content_types() {

[27] Fix | Delete

[28] Fix | Delete

foreach ( $this->get_inactive() as $types ) {

[29] Fix | Delete

[30] Fix | Delete

foreach ( $types as $type => $slugs ) {

[31] Fix | Delete

[32] Fix | Delete

foreach ( $slugs as $slug => $count ) {

[33] Fix | Delete

$this->content_types[ $type ][ $slug ] = $this->get_label( $type, $slug );

[34] Fix | Delete

}

[35] Fix | Delete

}

[36] Fix | Delete

}

[37] Fix | Delete

[38] Fix | Delete

return $this->content_types;

[39] Fix | Delete

}

[40] Fix | Delete

[41] Fix | Delete

/** @return array */

[42] Fix | Delete

public function get_languages() {

[43] Fix | Delete

return array_keys( $this->get_inactive() );

[44] Fix | Delete

}

[45] Fix | Delete

[46] Fix | Delete

/** @return array */

[47] Fix | Delete

public function get_language_counts_rows() {

[48] Fix | Delete

$counts = array();

[49] Fix | Delete

[50] Fix | Delete

foreach ( $this->get_languages() as $language ) {

[51] Fix | Delete

[52] Fix | Delete

foreach ( $this->get_content_types() as $type => $slugs ) {

[53] Fix | Delete

[54] Fix | Delete

foreach ( $slugs as $slug => $label ) {

[55] Fix | Delete

[56] Fix | Delete

$counts[ $language ][] = $this->count( $language, $type, $slug );

[57] Fix | Delete

}

[58] Fix | Delete

}

[59] Fix | Delete

}

[60] Fix | Delete

[61] Fix | Delete

return $counts;

[62] Fix | Delete

}

[63] Fix | Delete

[64] Fix | Delete

/** @return array */

[65] Fix | Delete

public function get_total_counts() {

[66] Fix | Delete

$total_counts = array();

[67] Fix | Delete

[68] Fix | Delete

foreach ( $this->get_language_counts_rows() as $lang_counts ) {

[69] Fix | Delete

[70] Fix | Delete

for ( $i = 0; $i < count( $lang_counts ); $i++ ) {

[71] Fix | Delete

[72] Fix | Delete

if ( ! isset( $total_counts[ $i ] ) ) {

[73] Fix | Delete

$total_counts[ $i ] = 0;

[74] Fix | Delete

}

[75] Fix | Delete

[76] Fix | Delete

$total_counts[ $i ] += $lang_counts[ $i ];

[77] Fix | Delete

}

[78] Fix | Delete

}

[79] Fix | Delete

[80] Fix | Delete

return $total_counts;

[81] Fix | Delete

}

[82] Fix | Delete

[83] Fix | Delete

/**

[84] Fix | Delete

* @param string $lang

[85] Fix | Delete

* @param string $type

[86] Fix | Delete

* @param string $slug

[87] Fix | Delete

[88] Fix | Delete

* @return int

[89] Fix | Delete

[90] Fix | Delete

private function count( $lang, $type, $slug ) {

[91] Fix | Delete

[92] Fix | Delete

if ( isset( $this->inactive[ $lang ][ $type ][ $slug ] ) ) {

[93] Fix | Delete

return (int) $this->inactive[ $lang ][ $type ][ $slug ];

[94] Fix | Delete

}

[95] Fix | Delete

[96] Fix | Delete

return 0;

[97] Fix | Delete

}

[98] Fix | Delete

[99] Fix | Delete

/** @return array */

[100] Fix | Delete

private function get_inactive() {

[101] Fix | Delete

[102] Fix | Delete

if ( null === $this->inactive ) {

[103] Fix | Delete

$this->inactive = array();

[104] Fix | Delete

$post_query = $this->wpdb->prepare( "

[105] Fix | Delete

SELECT COUNT(posts.ID) AS c, posts.post_type, languages_translations.name AS language

[106] Fix | Delete

FROM {$this->wpdb->prefix}icl_translations translations

[107] Fix | Delete

JOIN {$this->wpdb->posts} posts

[108] Fix | Delete

ON translations.element_id = posts.ID AND translations.element_type LIKE %s

[109] Fix | Delete

JOIN {$this->wpdb->prefix}icl_languages languages

[110] Fix | Delete

ON translations.language_code = languages.code AND languages.active = 0

[111] Fix | Delete

JOIN {$this->wpdb->prefix}icl_languages_translations languages_translations

[112] Fix | Delete

ON languages_translations.language_code = languages.code

[113] Fix | Delete

AND languages_translations.display_language_code = %s

[114] Fix | Delete

GROUP BY posts.post_type, translations.language_code

[115] Fix | Delete

", array( wpml_like_escape( 'post_' ) . '%', $this->current_language )

[116] Fix | Delete

);

[117] Fix | Delete

[118] Fix | Delete

$post_results = $this->wpdb->get_results( $post_query );

[119] Fix | Delete

[120] Fix | Delete

if ( $post_results ) {

[121] Fix | Delete

foreach ( $post_results as $r ) {

[122] Fix | Delete

$this->inactive[ $r->language ]['post'][ $r->post_type ] = $r->c;

[123] Fix | Delete

}

[124] Fix | Delete

}

[125] Fix | Delete

[126] Fix | Delete

$tax_query = $this->wpdb->prepare( "

[127] Fix | Delete

SELECT COUNT(posts.term_taxonomy_id) AS c, posts.taxonomy, languages_translations.name AS language

[128] Fix | Delete

FROM {$this->wpdb->prefix}icl_translations translations

[129] Fix | Delete

JOIN {$this->wpdb->term_taxonomy} posts

[130] Fix | Delete

ON translations.element_id = posts.term_taxonomy_id

[131] Fix | Delete

JOIN {$this->wpdb->prefix}icl_languages languages

[132] Fix | Delete

ON translations.language_code = languages.code AND languages.active = 0

[133] Fix | Delete

JOIN {$this->wpdb->prefix}icl_languages_translations languages_translations

[134] Fix | Delete

ON languages_translations.language_code = languages.code

[135] Fix | Delete

AND languages_translations.display_language_code = %s

[136] Fix | Delete

WHERE translations.element_type LIKE %s

[137] Fix | Delete

GROUP BY posts.taxonomy, translations.language_code

[138] Fix | Delete

", $this->current_language, wpml_like_escape( 'tax_') . '%' );

[139] Fix | Delete

[140] Fix | Delete

$tax_results = $this->wpdb->get_results( $tax_query );

[141] Fix | Delete

[142] Fix | Delete

if ( $tax_results ) {

[143] Fix | Delete

foreach ( $tax_results as $r ) {

[144] Fix | Delete

if ( ! $this->is_only_default_category( $r ) ) {

[145] Fix | Delete

$this->inactive[ $r->language ]['taxonomy'][ $r->taxonomy ] = $r->c;

[146] Fix | Delete

}

[147] Fix | Delete

}

[148] Fix | Delete

}

[149] Fix | Delete

}

[150] Fix | Delete

[151] Fix | Delete

return $this->inactive;

[152] Fix | Delete

}

[153] Fix | Delete

[154] Fix | Delete

/**

[155] Fix | Delete

* @param stdClass $r

[156] Fix | Delete

[157] Fix | Delete

* @return bool

[158] Fix | Delete

[159] Fix | Delete

private function is_only_default_category( $r ) {

[160] Fix | Delete

return $r->taxonomy === 'category' && $r->c == 1;

[161] Fix | Delete

}

[162] Fix | Delete

[163] Fix | Delete

[164] Fix | Delete

/**

[165] Fix | Delete

* @param string $type

[166] Fix | Delete

* @param string $slug

[167] Fix | Delete

[168] Fix | Delete

* @return null|string

[169] Fix | Delete

[170] Fix | Delete

private function get_label( $type, $slug ) {

[171] Fix | Delete

if ( 'post' === $type ) {

[172] Fix | Delete

$type_object = get_post_type_object( $slug );

[173] Fix | Delete

} else {

[174] Fix | Delete

$type_object = get_taxonomy( $slug );

[175] Fix | Delete

}

[176] Fix | Delete

[177] Fix | Delete

if ( isset( $type_object->label ) ) {

[178] Fix | Delete

return $type_object->label;

[179] Fix | Delete

}

[180] Fix | Delete

[181] Fix | Delete

return null;

[182] Fix | Delete

}

[183] Fix | Delete

}

[184] Fix | Delete

[185] Fix | Delete