Файловый менеджер

Файловый менеджер - Редактировать - /home/harasnat/www/labour/wp-content/plugins/google-listings-and-ads/src/DB/Query/MerchantPriceBenchmarksQuery.php

Назад
<?php declare( strict_types=1 ); namespace Automattic\WooCommerce\GoogleListingsAndAds\DB\Query; use Automattic\WooCommerce\GoogleListingsAndAds\DB\Query; use Automattic\WooCommerce\GoogleListingsAndAds\DB\Table\MerchantPriceBenchmarksTable; use wpdb; defined( 'ABSPATH' ) \|\| exit; /** * Class MerchantPriceBenchmarksQuery * * @package Automattic\WooCommerce\GoogleListingsAndAds\DB\Query / class MerchantPriceBenchmarksQuery extends Query { /* * MerchantPriceBenchmarksQuery constructor. * * @param wpdb $wpdb * @param MerchantPriceBenchmarksTable $table / public function __construct( wpdb $wpdb, MerchantPriceBenchmarksTable $table ) { parent::__construct( $wpdb, $table ); $this->table = $table; } /* * Sanitize a value for a given column before inserting it into the DB. * * @param string $column The column name. * @param mixed $value The value to sanitize. * * @return mixed The sanitized value. / protected function sanitize_value( string $column, $value ) { return $value; } /* * Get count of products grouped by price_compared_with_benchmark value. * * @return array Returns an array with counts for each price comparison group. / public function get_price_benchmark_counts(): array { // Get the raw SQL query with GROUP BY $column = 'price_compared_with_benchmark'; $this->validate_column( $column ); $query = "SELECT `{$column}`, COUNT() as count FROM `{$this->table->get_name()}` GROUP BY `{$column}`"; return $this->wpdb->get_results( $query, // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, No user input. ARRAY_A ); } /** * Reload merchant price benchmarks data. * * @return void */ public function reload_data(): void { if ( $this->table->exists() ) { $this->table->truncate(); } } }

| ver. 1.4 | Github | .