Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

[2] Fix | Delete

namespace NetworkPosts\Components\db;

[3] Fix | Delete

[4] Fix | Delete

[5] Fix | Delete

use NetworkPosts\db\NetsPostsDbHelper;

[6] Fix | Delete

[7] Fix | Delete

class NetsPostsMetaQueryBuilder {

[8] Fix | Delete

[9] Fix | Delete

private $blogs;

[10] Fix | Delete

private $prefix;

[11] Fix | Delete

private $current_blog_id = 1;

[12] Fix | Delete

[13] Fix | Delete

protected $primary_acf_field = '';

[14] Fix | Delete

[15] Fix | Delete

protected $acf_order = '';

[16] Fix | Delete

[17] Fix | Delete

protected $acf_date = '';

[18] Fix | Delete

protected $before_acf_date = '';

[19] Fix | Delete

protected $after_acf_date = '';

[20] Fix | Delete

[21] Fix | Delete

public function __construct( string $db_prefix ) {

[22] Fix | Delete

$this->prefix = $db_prefix;

[23] Fix | Delete

}

[24] Fix | Delete

[25] Fix | Delete

public function include_blogs( array $blogs ): void {

[26] Fix | Delete

$this->blogs = $blogs;

[27] Fix | Delete

}

[28] Fix | Delete

[29] Fix | Delete

/**

[30] Fix | Delete

* @param string $primary_acf_field

[31] Fix | Delete

[32] Fix | Delete

public function set_primary_acf_field( string $primary_acf_field ): void {

[33] Fix | Delete

$this->primary_acf_field = $primary_acf_field;

[34] Fix | Delete

}

[35] Fix | Delete

[36] Fix | Delete

/**

[37] Fix | Delete

* @param string $acf_date

[38] Fix | Delete

[39] Fix | Delete

public function filter_acf_date( string $acf_date ): void {

[40] Fix | Delete

$this->acf_date = $this->format_date( $acf_date );

[41] Fix | Delete

}

[42] Fix | Delete

[43] Fix | Delete

private function format_date( string $date ): string {

[44] Fix | Delete

$date = str_replace( '-', '', $date );

[45] Fix | Delete

$date = str_replace( '/', '', $date );

[46] Fix | Delete

[47] Fix | Delete

return $date;

[48] Fix | Delete

}

[49] Fix | Delete

[50] Fix | Delete

/**

[51] Fix | Delete

* @param string $before_acf_date

[52] Fix | Delete

[53] Fix | Delete

public function filter_before_acf_date( string $before_acf_date ): void {

[54] Fix | Delete

$this->before_acf_date = $this->format_date( $before_acf_date );

[55] Fix | Delete

}

[56] Fix | Delete

[57] Fix | Delete

/**

[58] Fix | Delete

* @param string $after_acf_date

[59] Fix | Delete

[60] Fix | Delete

public function filter_after_acf_date( string $after_acf_date ): void {

[61] Fix | Delete

$this->after_acf_date = $this->format_date( $after_acf_date );

[62] Fix | Delete

}

[63] Fix | Delete

[64] Fix | Delete

public function order_by_acf( string $order ): void {

[65] Fix | Delete

$this->acf_order = $order;

[66] Fix | Delete

}

[67] Fix | Delete

[68] Fix | Delete

public function get_primary_acf__field(): string {

[69] Fix | Delete

return $this->primary_acf_field;

[70] Fix | Delete

}

[71] Fix | Delete

[72] Fix | Delete

public function is_acf_needed(): bool {

[73] Fix | Delete

return ! empty( $this->primary_acf_field );

[74] Fix | Delete

}

[75] Fix | Delete

[76] Fix | Delete

public function has_filters(): bool {

[77] Fix | Delete

return $this->acf_date || $this->before_acf_date || $this->after_acf_date;

[78] Fix | Delete

}

[79] Fix | Delete

[80] Fix | Delete

public function has_order(): bool {

[81] Fix | Delete

return ! empty( $this->acf_order );

[82] Fix | Delete

}

[83] Fix | Delete

[84] Fix | Delete

public function set_current_blog( int $blog_id ): void {

[85] Fix | Delete

$this->current_blog_id = $blog_id;

[86] Fix | Delete

}

[87] Fix | Delete

[88] Fix | Delete

[89] Fix | Delete

public function get_columns(): array {

[90] Fix | Delete

return array(

[91] Fix | Delete

'meta_key',

[92] Fix | Delete

'meta_value' => $this->primary_acf_field

[93] Fix | Delete

);

[94] Fix | Delete

}

[95] Fix | Delete

[96] Fix | Delete

public function build_join( string $posts_table, string $post_id_column ): string {

[97] Fix | Delete

$meta_table = $this->get_post_meta_table();

[98] Fix | Delete

return " INNER JOIN $meta_table ON ($meta_table.post_id = $posts_table.$post_id_column)";

[99] Fix | Delete

}

[100] Fix | Delete

[101] Fix | Delete

protected function get_post_meta_table(): string {

[102] Fix | Delete

return NetsPostsDbHelper::make_table_name( $this->prefix, 'postmeta', $this->current_blog_id );

[103] Fix | Delete

}

[104] Fix | Delete

[105] Fix | Delete

public function build_where_condition(): string {

[106] Fix | Delete

$condition = array();

[107] Fix | Delete

[108] Fix | Delete

$condition[] = $this->build_acf_date_meta_query();

[109] Fix | Delete

if ( $this->acf_date ) {

[110] Fix | Delete

$condition[] = $this->build_filter_acf_date();

[111] Fix | Delete

}

[112] Fix | Delete

if ( $this->before_acf_date ) {

[113] Fix | Delete

$condition[] = $this->build_filter_before_acf_date();

[114] Fix | Delete

} elseif ( $this->after_acf_date ) {

[115] Fix | Delete

$condition[] = $this->build_filter_after_acf_date();

[116] Fix | Delete

}

[117] Fix | Delete

[118] Fix | Delete

if ( $condition ) {

[119] Fix | Delete

return join( ' AND ', $condition );

[120] Fix | Delete

}

[121] Fix | Delete

[122] Fix | Delete

return '';

[123] Fix | Delete

}

[124] Fix | Delete

[125] Fix | Delete

protected function build_acf_date_meta_query(): string {

[126] Fix | Delete

$meta_table = $this->get_post_meta_table();

[127] Fix | Delete

return '(' . $meta_table . '.meta_key="' . $this->primary_acf_field . '" AND ' . $meta_table . '.meta_value <> "")';

[128] Fix | Delete

}

[129] Fix | Delete

[130] Fix | Delete

protected function build_filter_acf_date(): string {

[131] Fix | Delete

$meta_table = $this->get_post_meta_table();

[132] Fix | Delete

$date = esc_sql( $this->acf_date );

[133] Fix | Delete

[134] Fix | Delete

return "($meta_table.meta_value = $date)";

[135] Fix | Delete

}

[136] Fix | Delete

[137] Fix | Delete

protected function build_filter_before_acf_date(): string {

[138] Fix | Delete

$meta_table = $this->get_post_meta_table();

[139] Fix | Delete

$date = esc_sql( $this->before_acf_date );

[140] Fix | Delete

[141] Fix | Delete

return "($meta_table.meta_value < $date)";

[142] Fix | Delete

}

[143] Fix | Delete

[144] Fix | Delete

protected function build_filter_after_acf_date(): string {

[145] Fix | Delete

$meta_table = $this->get_post_meta_table();

[146] Fix | Delete

$date = esc_sql( $this->after_acf_date );

[147] Fix | Delete

[148] Fix | Delete

return "($meta_table.meta_value >= $date)";

[149] Fix | Delete

}

[150] Fix | Delete

[151] Fix | Delete

public function build_order_by(): string {

[152] Fix | Delete

$order = $this->acf_order;

[153] Fix | Delete

$field_name = $this->primary_acf_field;

[154] Fix | Delete

return "ORDER BY $field_name $order";

[155] Fix | Delete

}

[156] Fix | Delete

}

[157] Fix | Delete