<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* API\Reports\Coupons\DataStore class file.

[2] Fix | Delete

*/

[3] Fix | Delete

[4] Fix | Delete

namespace Automattic\WooCommerce\Admin\API\Reports\Coupons;

[5] Fix | Delete

[6] Fix | Delete

defined( 'ABSPATH' ) || exit;

[7] Fix | Delete

[8] Fix | Delete

use Automattic\WooCommerce\Admin\API\Reports\DataStore as ReportsDataStore;

[9] Fix | Delete

use Automattic\WooCommerce\Admin\API\Reports\DataStoreInterface;

[10] Fix | Delete

use Automattic\WooCommerce\Admin\API\Reports\TimeInterval;

[11] Fix | Delete

use Automattic\WooCommerce\Admin\API\Reports\SqlQuery;

[12] Fix | Delete

use Automattic\WooCommerce\Admin\API\Reports\Cache as ReportsCache;

[13] Fix | Delete

[14] Fix | Delete

/**

[15] Fix | Delete

* API\Reports\Coupons\DataStore.

[16] Fix | Delete

*/

[17] Fix | Delete

class DataStore extends ReportsDataStore implements DataStoreInterface {

[18] Fix | Delete

[19] Fix | Delete

/**

[20] Fix | Delete

* Table used to get the data.

[21] Fix | Delete

*

[22] Fix | Delete

* @override ReportsDataStore::$table_name

[23] Fix | Delete

*

[24] Fix | Delete

* @var string

[25] Fix | Delete

*/

[26] Fix | Delete

protected static $table_name = 'wc_order_coupon_lookup';

[27] Fix | Delete

[28] Fix | Delete

/**

[29] Fix | Delete

* Cache identifier.

[30] Fix | Delete

*

[31] Fix | Delete

* @override ReportsDataStore::$cache_key

[32] Fix | Delete

*

[33] Fix | Delete

* @var string

[34] Fix | Delete

*/

[35] Fix | Delete

protected $cache_key = 'coupons';

[36] Fix | Delete

[37] Fix | Delete

/**

[38] Fix | Delete

* Mapping columns to data type to return correct response types.

[39] Fix | Delete

*

[40] Fix | Delete

* @override ReportsDataStore::$column_types

[41] Fix | Delete

*

[42] Fix | Delete

* @var array

[43] Fix | Delete

*/

[44] Fix | Delete

protected $column_types = array(

[45] Fix | Delete

'coupon_id' => 'intval',

[46] Fix | Delete

'amount' => 'floatval',

[47] Fix | Delete

'orders_count' => 'intval',

[48] Fix | Delete

);

[49] Fix | Delete

[50] Fix | Delete

/**

[51] Fix | Delete

* Data store context used to pass to filters.

[52] Fix | Delete

*

[53] Fix | Delete

* @override ReportsDataStore::$context

[54] Fix | Delete

*

[55] Fix | Delete

* @var string

[56] Fix | Delete

*/

[57] Fix | Delete

protected $context = 'coupons';

[58] Fix | Delete

[59] Fix | Delete

/**

[60] Fix | Delete

* Assign report columns once full table name has been assigned.

[61] Fix | Delete

*

[62] Fix | Delete

* @override ReportsDataStore::assign_report_columns()

[63] Fix | Delete

*/

[64] Fix | Delete

protected function assign_report_columns() {

[65] Fix | Delete

$table_name = self::get_db_table_name();

[66] Fix | Delete

$this->report_columns = array(

[67] Fix | Delete

'coupon_id' => 'coupon_id',

[68] Fix | Delete

'amount' => 'SUM(discount_amount) as amount',

[69] Fix | Delete

'orders_count' => "COUNT(DISTINCT {$table_name}.order_id) as orders_count",

[70] Fix | Delete

);

[71] Fix | Delete

}

[72] Fix | Delete

[73] Fix | Delete

// This method was already available as non-final, marking it as final now would make it backwards-incompatible.

[74] Fix | Delete

// phpcs:disable WooCommerce.Functions.InternalInjectionMethod.MissingFinal

[75] Fix | Delete

[76] Fix | Delete

/**

[77] Fix | Delete

* Set up all the hooks for maintaining and populating table data.

[78] Fix | Delete

*

[79] Fix | Delete

* @internal

[80] Fix | Delete

*/

[81] Fix | Delete

public static function init() {

[82] Fix | Delete

add_action( 'woocommerce_analytics_delete_order_stats', array( __CLASS__, 'sync_on_order_delete' ), 5 );

[83] Fix | Delete

}

[84] Fix | Delete

[85] Fix | Delete

// phpcs:enable WooCommerce.Functions.InternalInjectionMethod.MissingFinal

[86] Fix | Delete

[87] Fix | Delete

/**

[88] Fix | Delete

* Returns an array of ids of included coupons, based on query arguments from the user.

[89] Fix | Delete

*

[90] Fix | Delete

* @param array $query_args Parameters supplied by the user.

[91] Fix | Delete

* @return array

[92] Fix | Delete

*/

[93] Fix | Delete

protected function get_included_coupons_array( $query_args ) {

[94] Fix | Delete

if ( isset( $query_args['coupons'] ) && is_array( $query_args['coupons'] ) && count( $query_args['coupons'] ) > 0 ) {

[95] Fix | Delete

return $query_args['coupons'];

[96] Fix | Delete

}

[97] Fix | Delete

return array();

[98] Fix | Delete

}

[99] Fix | Delete

[100] Fix | Delete

/**

[101] Fix | Delete

* Updates the database query with parameters used for Products report: categories and order status.

[102] Fix | Delete

*

[103] Fix | Delete

* @param array $query_args Query arguments supplied by the user.

[104] Fix | Delete

*/

[105] Fix | Delete

protected function add_sql_query_params( $query_args ) {

[106] Fix | Delete

global $wpdb;

[107] Fix | Delete

$order_coupon_lookup_table = self::get_db_table_name();

[108] Fix | Delete

[109] Fix | Delete

$this->add_time_period_sql_params( $query_args, $order_coupon_lookup_table );

[110] Fix | Delete

$this->get_limit_sql_params( $query_args );

[111] Fix | Delete

[112] Fix | Delete

$included_coupons = $this->get_included_coupons( $query_args, 'coupons' );

[113] Fix | Delete

if ( $included_coupons ) {

[114] Fix | Delete

$this->subquery->add_sql_clause( 'where', "AND {$order_coupon_lookup_table}.coupon_id IN ({$included_coupons})" );

[115] Fix | Delete

[116] Fix | Delete

$this->add_order_by_params( $query_args, 'outer', 'default_results.coupon_id' );

[117] Fix | Delete

} else {

[118] Fix | Delete

$this->add_order_by_params( $query_args, 'inner', "{$order_coupon_lookup_table}.coupon_id" );

[119] Fix | Delete

}

[120] Fix | Delete

[121] Fix | Delete

$this->add_order_status_clause( $query_args, $order_coupon_lookup_table, $this->subquery );

[122] Fix | Delete

}

[123] Fix | Delete

[124] Fix | Delete

/**

[125] Fix | Delete

* Fills ORDER BY clause of SQL request based on user supplied parameters.

[126] Fix | Delete

*

[127] Fix | Delete

* @param array $query_args Parameters supplied by the user.

[128] Fix | Delete

* @param string $from_arg Target of the JOIN sql param.

[129] Fix | Delete

* @param string $id_cell ID cell identifier, like `table_name.id_column_name`.

[130] Fix | Delete

*/

[131] Fix | Delete

protected function add_order_by_params( $query_args, $from_arg, $id_cell ) {

[132] Fix | Delete

global $wpdb;

[133] Fix | Delete

[134] Fix | Delete

// Sanitize input: guarantee that the id cell in the join is quoted with backticks.

[135] Fix | Delete

$id_cell_segments = explode( '.', str_replace( '`', '', $id_cell ) );

[136] Fix | Delete

$id_cell_identifier = '`' . implode( '`.`', $id_cell_segments ) . '`';

[137] Fix | Delete

[138] Fix | Delete

$lookup_table = self::get_db_table_name();

[139] Fix | Delete

$order_by_clause = $this->add_order_by_clause( $query_args, $this );

[140] Fix | Delete

$join = "JOIN {$wpdb->posts} AS _coupons ON {$id_cell_identifier} = _coupons.ID";

[141] Fix | Delete

$this->add_orderby_order_clause( $query_args, $this );

[142] Fix | Delete

[143] Fix | Delete

if ( 'inner' === $from_arg ) {

[144] Fix | Delete

$this->subquery->clear_sql_clause( 'join' );

[145] Fix | Delete

if ( false !== strpos( $order_by_clause, '_coupons' ) ) {

[146] Fix | Delete

$this->subquery->add_sql_clause( 'join', $join );

[147] Fix | Delete

}

[148] Fix | Delete

} else {

[149] Fix | Delete

$this->clear_sql_clause( 'join' );

[150] Fix | Delete

if ( false !== strpos( $order_by_clause, '_coupons' ) ) {

[151] Fix | Delete

$this->add_sql_clause( 'join', $join );

[152] Fix | Delete

}

[153] Fix | Delete

}

[154] Fix | Delete

}

[155] Fix | Delete

[156] Fix | Delete

/**

[157] Fix | Delete

* Maps ordering specified by the user to columns in the database/fields in the data.

[158] Fix | Delete

*

[159] Fix | Delete

* @override ReportsDataStore::normalize_order_by()

[160] Fix | Delete

*

[161] Fix | Delete

* @param string $order_by Sorting criterion.

[162] Fix | Delete

* @return string

[163] Fix | Delete

*/

[164] Fix | Delete

protected function normalize_order_by( $order_by ) {

[165] Fix | Delete

if ( 'date' === $order_by ) {

[166] Fix | Delete

return 'time_interval';

[167] Fix | Delete

}

[168] Fix | Delete

if ( 'code' === $order_by ) {

[169] Fix | Delete

return '_coupons.post_title';

[170] Fix | Delete

}

[171] Fix | Delete

return $order_by;

[172] Fix | Delete

}

[173] Fix | Delete

[174] Fix | Delete

/**

[175] Fix | Delete

* Enriches the coupon data with extra attributes.

[176] Fix | Delete

*

[177] Fix | Delete

* @param array $coupon_data Coupon data.

[178] Fix | Delete

* @param array $query_args Query parameters.

[179] Fix | Delete

*/

[180] Fix | Delete

protected function include_extended_info( &$coupon_data, $query_args ) {

[181] Fix | Delete

foreach ( $coupon_data as $idx => $coupon_datum ) {

[182] Fix | Delete

$extended_info = new \ArrayObject();

[183] Fix | Delete

if ( $query_args['extended_info'] ) {

[184] Fix | Delete

$coupon_id = $coupon_datum['coupon_id'];

[185] Fix | Delete

$coupon = new \WC_Coupon( $coupon_id );

[186] Fix | Delete

[187] Fix | Delete

if ( 0 === $coupon->get_id() ) {

[188] Fix | Delete

// Deleted or otherwise invalid coupon.

[189] Fix | Delete

$extended_info = array(

[190] Fix | Delete

'code' => __( '(Deleted)', 'woocommerce' ),

[191] Fix | Delete

'date_created' => '',

[192] Fix | Delete

'date_created_gmt' => '',

[193] Fix | Delete

'date_expires' => '',

[194] Fix | Delete

'date_expires_gmt' => '',

[195] Fix | Delete

'discount_type' => __( 'N/A', 'woocommerce' ),

[196] Fix | Delete

);

[197] Fix | Delete

} else {

[198] Fix | Delete

$gmt_timzone = new \DateTimeZone( 'UTC' );

[199] Fix | Delete

[200] Fix | Delete

$date_expires = $coupon->get_date_expires();

[201] Fix | Delete

if ( is_a( $date_expires, 'DateTime' ) ) {

[202] Fix | Delete

$date_expires = $date_expires->format( TimeInterval::$iso_datetime_format );

[203] Fix | Delete

$date_expires_gmt = new \DateTime( $date_expires );

[204] Fix | Delete

$date_expires_gmt->setTimezone( $gmt_timzone );

[205] Fix | Delete

$date_expires_gmt = $date_expires_gmt->format( TimeInterval::$iso_datetime_format );

[206] Fix | Delete

} else {

[207] Fix | Delete

$date_expires = '';

[208] Fix | Delete

$date_expires_gmt = '';

[209] Fix | Delete

}

[210] Fix | Delete

[211] Fix | Delete

$date_created = $coupon->get_date_created();

[212] Fix | Delete

if ( is_a( $date_created, 'DateTime' ) ) {

[213] Fix | Delete

$date_created = $date_created->format( TimeInterval::$iso_datetime_format );

[214] Fix | Delete

$date_created_gmt = new \DateTime( $date_created );

[215] Fix | Delete

$date_created_gmt->setTimezone( $gmt_timzone );

[216] Fix | Delete

$date_created_gmt = $date_created_gmt->format( TimeInterval::$iso_datetime_format );

[217] Fix | Delete

} else {

[218] Fix | Delete

$date_created = '';

[219] Fix | Delete

$date_created_gmt = '';

[220] Fix | Delete

}

[221] Fix | Delete

[222] Fix | Delete

$extended_info = array(

[223] Fix | Delete

'code' => $coupon->get_code(),

[224] Fix | Delete

'date_created' => $date_created,

[225] Fix | Delete

'date_created_gmt' => $date_created_gmt,

[226] Fix | Delete

'date_expires' => $date_expires,

[227] Fix | Delete

'date_expires_gmt' => $date_expires_gmt,

[228] Fix | Delete

'discount_type' => $coupon->get_discount_type(),

[229] Fix | Delete

);

[230] Fix | Delete

}

[231] Fix | Delete

}

[232] Fix | Delete

$coupon_data[ $idx ]['extended_info'] = $extended_info;

[233] Fix | Delete

}

[234] Fix | Delete

}

[235] Fix | Delete

[236] Fix | Delete

/**

[237] Fix | Delete

* Get coupon ID for an order.

[238] Fix | Delete

*

[239] Fix | Delete

* Tries to get the ID from order item meta, then falls back to a query of published coupons.

[240] Fix | Delete

*

[241] Fix | Delete

* @param \WC_Order_Item_Coupon $coupon_item The coupon order item object.

[242] Fix | Delete

* @return int Coupon ID on success, 0 on failure.

[243] Fix | Delete

*/

[244] Fix | Delete

public static function get_coupon_id( \WC_Order_Item_Coupon $coupon_item ) {

[245] Fix | Delete

// First attempt to get coupon ID from order item data.

[246] Fix | Delete

$coupon_info = $coupon_item->get_meta( 'coupon_info', true );

[247] Fix | Delete

if ( $coupon_info ) {

[248] Fix | Delete

return json_decode( $coupon_info, true )[0];

[249] Fix | Delete

}

[250] Fix | Delete

[251] Fix | Delete

$coupon_data = $coupon_item->get_meta( 'coupon_data', true );

[252] Fix | Delete

[253] Fix | Delete

// Normal checkout orders should have this data.

[254] Fix | Delete

// See: https://github.com/woocommerce/woocommerce/blob/3dc7df7af9f7ca0c0aa34ede74493e856f276abe/includes/abstracts/abstract-wc-order.php#L1206.

[255] Fix | Delete

if ( isset( $coupon_data['id'] ) ) {

[256] Fix | Delete

return $coupon_data['id'];

[257] Fix | Delete

}

[258] Fix | Delete

[259] Fix | Delete

// Try to get the coupon ID using the code.

[260] Fix | Delete

return wc_get_coupon_id_by_code( $coupon_item->get_code() );

[261] Fix | Delete

}

[262] Fix | Delete

[263] Fix | Delete

/**

[264] Fix | Delete

* Get the default query arguments to be used by get_data().

[265] Fix | Delete

* These defaults are only partially applied when used via REST API, as that has its own defaults.

[266] Fix | Delete

*

[267] Fix | Delete

* @override ReportsDataStore::get_default_query_vars()

[268] Fix | Delete

*

[269] Fix | Delete

* @return array Query parameters.

[270] Fix | Delete

*/

[271] Fix | Delete

public function get_default_query_vars() {

[272] Fix | Delete

$defaults = parent::get_default_query_vars();

[273] Fix | Delete

$defaults['orderby'] = 'coupon_id';

[274] Fix | Delete

$defaults['coupons'] = array();

[275] Fix | Delete

$defaults['extended_info'] = false;

[276] Fix | Delete

[277] Fix | Delete

return $defaults;

[278] Fix | Delete

}

[279] Fix | Delete

[280] Fix | Delete

[281] Fix | Delete

/**

[282] Fix | Delete

* Returns the report data based on normalized parameters.

[283] Fix | Delete

* Will be called by `get_data` if there is no data in cache.

[284] Fix | Delete

*

[285] Fix | Delete

* @override ReportsDataStore::get_noncached_data()

[286] Fix | Delete

*

[287] Fix | Delete

* @see get_data

[288] Fix | Delete

* @param array $query_args Query parameters.

[289] Fix | Delete

* @return stdClass|WP_Error Data object `{ totals: *, intervals: array, total: int, pages: int, page_no: int }`, or error.

[290] Fix | Delete

*/

[291] Fix | Delete

public function get_noncached_data( $query_args ) {

[292] Fix | Delete

global $wpdb;

[293] Fix | Delete

[294] Fix | Delete

$table_name = self::get_db_table_name();

[295] Fix | Delete

[296] Fix | Delete

$this->initialize_queries();

[297] Fix | Delete

[298] Fix | Delete

$data = (object) array(

[299] Fix | Delete

'data' => array(),

[300] Fix | Delete

'total' => 0,

[301] Fix | Delete

'pages' => 0,

[302] Fix | Delete

'page_no' => 0,

[303] Fix | Delete

);

[304] Fix | Delete

[305] Fix | Delete

$selections = $this->selected_columns( $query_args );

[306] Fix | Delete

$included_coupons = $this->get_included_coupons_array( $query_args );

[307] Fix | Delete

$limit_params = $this->get_limit_params( $query_args );

[308] Fix | Delete

$this->subquery->add_sql_clause( 'select', $selections );

[309] Fix | Delete

$this->add_sql_query_params( $query_args );

[310] Fix | Delete

[311] Fix | Delete

if ( count( $included_coupons ) > 0 ) {

[312] Fix | Delete

$total_results = count( $included_coupons );

[313] Fix | Delete

$total_pages = (int) ceil( $total_results / $limit_params['per_page'] );

[314] Fix | Delete

[315] Fix | Delete

$fields = $this->get_fields( $query_args );

[316] Fix | Delete

$ids_table = $this->get_ids_table( $included_coupons, 'coupon_id' );

[317] Fix | Delete

[318] Fix | Delete

$this->add_sql_clause( 'select', $this->format_join_selections( $fields, array( 'coupon_id' ) ) );

[319] Fix | Delete

$this->add_sql_clause( 'from', '(' );

[320] Fix | Delete

$this->add_sql_clause( 'from', $this->subquery->get_query_statement() );

[321] Fix | Delete

$this->add_sql_clause( 'from', ") AS {$table_name}" );

[322] Fix | Delete

$this->add_sql_clause(

[323] Fix | Delete

'right_join',

[324] Fix | Delete

"RIGHT JOIN ( {$ids_table} ) AS default_results

[325] Fix | Delete

ON default_results.coupon_id = {$table_name}.coupon_id"

[326] Fix | Delete

);

[327] Fix | Delete

[328] Fix | Delete

$coupons_query = $this->get_query_statement();

[329] Fix | Delete

} else {

[330] Fix | Delete

if ( in_array( $query_args['orderby'], array( 'amount', 'orders_count' ), true ) ) {

[331] Fix | Delete

$this->subquery->add_sql_clause( 'order_by', $this->get_sql_clause( 'order_by' ) . ', coupon_id' );

[332] Fix | Delete

} else {

[333] Fix | Delete

$this->subquery->add_sql_clause( 'order_by', $this->get_sql_clause( 'order_by' ) );

[334] Fix | Delete

}

[335] Fix | Delete

$this->subquery->add_sql_clause( 'limit', $this->get_sql_clause( 'limit' ) );

[336] Fix | Delete

$coupons_query = $this->subquery->get_query_statement();

[337] Fix | Delete

[338] Fix | Delete

$this->subquery->clear_sql_clause( array( 'select', 'order_by', 'limit' ) );

[339] Fix | Delete

$this->subquery->add_sql_clause( 'select', 'coupon_id' );

[340] Fix | Delete

$coupon_subquery = "SELECT COUNT(*) FROM (

[341] Fix | Delete

{$this->subquery->get_query_statement()}

[342] Fix | Delete

) AS tt";

[343] Fix | Delete

[344] Fix | Delete

$db_records_count = (int) $wpdb->get_var(

[345] Fix | Delete

$coupon_subquery // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[346] Fix | Delete

);

[347] Fix | Delete

[348] Fix | Delete

$total_results = $db_records_count;

[349] Fix | Delete

$total_pages = (int) ceil( $db_records_count / $limit_params['per_page'] );

[350] Fix | Delete

if ( $query_args['page'] < 1 || $query_args['page'] > $total_pages ) {

[351] Fix | Delete

return $data;

[352] Fix | Delete

}

[353] Fix | Delete

}

[354] Fix | Delete

[355] Fix | Delete

$coupon_data = $wpdb->get_results(

[356] Fix | Delete

$coupons_query, // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[357] Fix | Delete

ARRAY_A

[358] Fix | Delete

);

[359] Fix | Delete

if ( null === $coupon_data ) {

[360] Fix | Delete

return $data;

[361] Fix | Delete

}

[362] Fix | Delete

[363] Fix | Delete

$this->include_extended_info( $coupon_data, $query_args );

[364] Fix | Delete

[365] Fix | Delete

$coupon_data = array_map( array( $this, 'cast_numbers' ), $coupon_data );

[366] Fix | Delete

$data = (object) array(

[367] Fix | Delete

'data' => $coupon_data,

[368] Fix | Delete

'total' => $total_results,

[369] Fix | Delete

'pages' => $total_pages,

[370] Fix | Delete

'page_no' => (int) $query_args['page'],

[371] Fix | Delete

);

[372] Fix | Delete

[373] Fix | Delete

return $data;

[374] Fix | Delete

}

[375] Fix | Delete

[376] Fix | Delete

/**

[377] Fix | Delete

* Create or update an an entry in the wc_order_coupon_lookup table for an order.

[378] Fix | Delete

*

[379] Fix | Delete

* @since 3.5.0

[380] Fix | Delete

* @param int $order_id Order ID.

[381] Fix | Delete

* @return int|bool Returns -1 if order won't be processed, or a boolean indicating processing success.

[382] Fix | Delete

*/

[383] Fix | Delete

public static function sync_order_coupons( $order_id ) {

[384] Fix | Delete

global $wpdb;

[385] Fix | Delete

[386] Fix | Delete

$order = wc_get_order( $order_id );

[387] Fix | Delete

[388] Fix | Delete

if ( ! $order ) {

[389] Fix | Delete

return -1;

[390] Fix | Delete

}

[391] Fix | Delete

[392] Fix | Delete

// Refunds don't affect coupon stats so return successfully if one is called here.

[393] Fix | Delete

if ( 'shop_order_refund' === $order->get_type() ) {

[394] Fix | Delete

return true;

[395] Fix | Delete

}

[396] Fix | Delete

[397] Fix | Delete

$table_name = self::get_db_table_name();

[398] Fix | Delete

$existing_items = $wpdb->get_col(

[399] Fix | Delete

$wpdb->prepare(

[400] Fix | Delete

// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[401] Fix | Delete

"SELECT coupon_id FROM {$table_name} WHERE order_id = %d",

[402] Fix | Delete

$order_id

[403] Fix | Delete

)

[404] Fix | Delete

);

[405] Fix | Delete

$existing_items = array_flip( $existing_items );

[406] Fix | Delete

$coupon_items = $order->get_items( 'coupon' );

[407] Fix | Delete

$coupon_items_count = count( $coupon_items );

[408] Fix | Delete

$num_updated = 0;

[409] Fix | Delete

$num_deleted = 0;

[410] Fix | Delete

[411] Fix | Delete

foreach ( $coupon_items as $coupon_item ) {

[412] Fix | Delete

$coupon_id = self::get_coupon_id( $coupon_item );

[413] Fix | Delete

unset( $existing_items[ $coupon_id ] );

[414] Fix | Delete

[415] Fix | Delete

if ( ! $coupon_id ) {

[416] Fix | Delete

// Insert a unique, but obviously invalid ID for this deleted coupon.

[417] Fix | Delete

++$num_deleted;

[418] Fix | Delete

$coupon_id = -1 * $num_deleted;

[419] Fix | Delete

}

[420] Fix | Delete

[421] Fix | Delete

$result = $wpdb->replace(

[422] Fix | Delete

self::get_db_table_name(),

[423] Fix | Delete

array(

[424] Fix | Delete

'order_id' => $order_id,

[425] Fix | Delete

'coupon_id' => $coupon_id,

[426] Fix | Delete

'discount_amount' => $coupon_item->get_discount(),

[427] Fix | Delete

'date_created' => $order->get_date_created( 'edit' )->date( TimeInterval::$sql_datetime_format ),

[428] Fix | Delete

),

[429] Fix | Delete

array(

[430] Fix | Delete

'%d',

[431] Fix | Delete

'%d',

[432] Fix | Delete

'%f',

[433] Fix | Delete

'%s',

[434] Fix | Delete

)

[435] Fix | Delete

);

[436] Fix | Delete

[437] Fix | Delete

/**

[438] Fix | Delete

* Fires when coupon's reports are updated.

[439] Fix | Delete

*

[440] Fix | Delete

* @param int $coupon_id Coupon ID.

[441] Fix | Delete

* @param int $order_id Order ID.

[442] Fix | Delete

*/

[443] Fix | Delete

do_action( 'woocommerce_analytics_update_coupon', $coupon_id, $order_id );

[444] Fix | Delete

[445] Fix | Delete

// Sum the rows affected. Using REPLACE can affect 2 rows if the row already exists.

[446] Fix | Delete

$num_updated += 2 === intval( $result ) ? 1 : intval( $result );

[447] Fix | Delete

}

[448] Fix | Delete

[449] Fix | Delete

if ( ! empty( $existing_items ) ) {

[450] Fix | Delete

$existing_items = array_flip( $existing_items );

[451] Fix | Delete

$format = array_fill( 0, count( $existing_items ), '%d' );

[452] Fix | Delete

$format = implode( ',', $format );

[453] Fix | Delete

array_unshift( $existing_items, $order_id );

[454] Fix | Delete

$wpdb->query(

[455] Fix | Delete

$wpdb->prepare(

[456] Fix | Delete

// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[457] Fix | Delete

"DELETE FROM {$table_name} WHERE order_id = %d AND coupon_id in ({$format})",

[458] Fix | Delete

$existing_items

[459] Fix | Delete

)

[460] Fix | Delete

);

[461] Fix | Delete

}

[462] Fix | Delete

[463] Fix | Delete

return ( $coupon_items_count === $num_updated );

[464] Fix | Delete

}

[465] Fix | Delete

[466] Fix | Delete

/**

[467] Fix | Delete

* Clean coupons data when an order is deleted.

[468] Fix | Delete

*

[469] Fix | Delete

* @param int $order_id Order ID.

[470] Fix | Delete

*/

[471] Fix | Delete

public static function sync_on_order_delete( $order_id ) {

[472] Fix | Delete

global $wpdb;

[473] Fix | Delete

[474] Fix | Delete

$wpdb->delete( self::get_db_table_name(), array( 'order_id' => $order_id ) );

[475] Fix | Delete

/**

[476] Fix | Delete

* Fires when coupon's reports are removed from database.

[477] Fix | Delete

*

[478] Fix | Delete

* @param int $coupon_id Coupon ID.

[479] Fix | Delete

* @param int $order_id Order ID.

[480] Fix | Delete

*/

[481] Fix | Delete

do_action( 'woocommerce_analytics_delete_coupon', 0, $order_id );

[482] Fix | Delete

[483] Fix | Delete

ReportsCache::invalidate();

[484] Fix | Delete

}

[485] Fix | Delete

[486] Fix | Delete

/**

[487] Fix | Delete

* Gets coupons based on the provided arguments.

[488] Fix | Delete

*

[489] Fix | Delete

* @todo Upon core merge, including this in core's `class-wc-coupon-data-store-cpt.php` might make more sense.

[490] Fix | Delete

* @param array $args Array of args to filter the query by. Supports `include`.

[491] Fix | Delete

* @return array Array of results.

[492] Fix | Delete

*/

[493] Fix | Delete

public function get_coupons( $args ) {

[494] Fix | Delete

global $wpdb;

[495] Fix | Delete

$query = "SELECT ID, post_title FROM {$wpdb->posts} WHERE post_type='shop_coupon'";

[496] Fix | Delete

[497] Fix | Delete

$included_coupons = $this->get_included_coupons( $args, 'include' );

[498] Fix | Delete

if ( ! empty( $included_coupons ) ) {

[499] Fix | Delete