<?php

[0] Fix | Delete

[1] Fix | Delete

namespace WPForms\Db\Payments;

[2] Fix | Delete

[3] Fix | Delete

use WPForms_DB;

[4] Fix | Delete

[5] Fix | Delete

/**

[6] Fix | Delete

* Class for the Payments database table.

[7] Fix | Delete

*

[8] Fix | Delete

* @since 1.8.2

[9] Fix | Delete

*/

[10] Fix | Delete

class Payment extends WPForms_DB {

[11] Fix | Delete

[12] Fix | Delete

/**

[13] Fix | Delete

* Primary class constructor.

[14] Fix | Delete

*

[15] Fix | Delete

* @since 1.8.2

[16] Fix | Delete

*/

[17] Fix | Delete

public function __construct() {

[18] Fix | Delete

[19] Fix | Delete

parent::__construct();

[20] Fix | Delete

[21] Fix | Delete

$this->table_name = self::get_table_name();

[22] Fix | Delete

$this->primary_key = 'id';

[23] Fix | Delete

$this->type = 'payment';

[24] Fix | Delete

}

[25] Fix | Delete

[26] Fix | Delete

/**

[27] Fix | Delete

* Get the table name.

[28] Fix | Delete

*

[29] Fix | Delete

* @since 1.8.2

[30] Fix | Delete

*

[31] Fix | Delete

* @return string

[32] Fix | Delete

*/

[33] Fix | Delete

public static function get_table_name() {

[34] Fix | Delete

[35] Fix | Delete

global $wpdb;

[36] Fix | Delete

[37] Fix | Delete

return $wpdb->prefix . 'wpforms_payments';

[38] Fix | Delete

}

[39] Fix | Delete

[40] Fix | Delete

/**

[41] Fix | Delete

* Get table columns.

[42] Fix | Delete

*

[43] Fix | Delete

* @since 1.8.2

[44] Fix | Delete

*

[45] Fix | Delete

* @return array

[46] Fix | Delete

*/

[47] Fix | Delete

public function get_columns() {

[48] Fix | Delete

[49] Fix | Delete

return [

[50] Fix | Delete

'id' => '%d',

[51] Fix | Delete

'form_id' => '%d',

[52] Fix | Delete

'status' => '%s',

[53] Fix | Delete

'subtotal_amount' => '%f',

[54] Fix | Delete

'discount_amount' => '%f',

[55] Fix | Delete

'total_amount' => '%f',

[56] Fix | Delete

'currency' => '%s',

[57] Fix | Delete

'entry_id' => '%d',

[58] Fix | Delete

'gateway' => '%s',

[59] Fix | Delete

'type' => '%s',

[60] Fix | Delete

'mode' => '%s',

[61] Fix | Delete

'transaction_id' => '%s',

[62] Fix | Delete

'customer_id' => '%s',

[63] Fix | Delete

'subscription_id' => '%s',

[64] Fix | Delete

'subscription_status' => '%s',

[65] Fix | Delete

'title' => '%s',

[66] Fix | Delete

'date_created_gmt' => '%s',

[67] Fix | Delete

'date_updated_gmt' => '%s',

[68] Fix | Delete

'is_published' => '%d',

[69] Fix | Delete

];

[70] Fix | Delete

}

[71] Fix | Delete

[72] Fix | Delete

/**

[73] Fix | Delete

* Default column values.

[74] Fix | Delete

*

[75] Fix | Delete

* @since 1.8.2

[76] Fix | Delete

*

[77] Fix | Delete

* @return array

[78] Fix | Delete

*/

[79] Fix | Delete

public function get_column_defaults() {

[80] Fix | Delete

[81] Fix | Delete

$date = gmdate( 'Y-m-d H:i:s' );

[82] Fix | Delete

[83] Fix | Delete

return [

[84] Fix | Delete

'form_id' => 0,

[85] Fix | Delete

'status' => '',

[86] Fix | Delete

'subtotal_amount' => 0,

[87] Fix | Delete

'discount_amount' => 0,

[88] Fix | Delete

'total_amount' => 0,

[89] Fix | Delete

'currency' => '',

[90] Fix | Delete

'entry_id' => 0,

[91] Fix | Delete

'gateway' => '',

[92] Fix | Delete

'type' => '',

[93] Fix | Delete

'mode' => '',

[94] Fix | Delete

'transaction_id' => '',

[95] Fix | Delete

'customer_id' => '',

[96] Fix | Delete

'subscription_id' => '',

[97] Fix | Delete

'subscription_status' => '',

[98] Fix | Delete

'title' => '',

[99] Fix | Delete

'date_created_gmt' => $date,

[100] Fix | Delete

'date_updated_gmt' => $date,

[101] Fix | Delete

'is_published' => 1,

[102] Fix | Delete

];

[103] Fix | Delete

}

[104] Fix | Delete

[105] Fix | Delete

/**

[106] Fix | Delete

* Insert a new payment into the database.

[107] Fix | Delete

*

[108] Fix | Delete

* @since 1.8.2

[109] Fix | Delete

*

[110] Fix | Delete

* @param array $data Column data.

[111] Fix | Delete

* @param string $type Optional. Data type context.

[112] Fix | Delete

*

[113] Fix | Delete

* @return int ID for the newly inserted payment. Zero otherwise.

[114] Fix | Delete

*/

[115] Fix | Delete

public function add( $data, $type = '' ) {

[116] Fix | Delete

[117] Fix | Delete

// Return early if the status is not allowed.

[118] Fix | Delete

// TODO: consider validating other properties as well or get rid of it.

[119] Fix | Delete

if ( isset( $data['status'] ) && ! ValueValidator::is_valid( $data['status'], 'status' ) ) {

[120] Fix | Delete

return 0;

[121] Fix | Delete

}

[122] Fix | Delete

[123] Fix | Delete

// Use database type identifier if a context is empty.

[124] Fix | Delete

$type = empty( $type ) ? $this->type : $type;

[125] Fix | Delete

[126] Fix | Delete

return parent::add( $data, $type );

[127] Fix | Delete

}

[128] Fix | Delete

[129] Fix | Delete

/**

[130] Fix | Delete

* Retrieve a payment from the database based on a given payment ID.

[131] Fix | Delete

*

[132] Fix | Delete

* @since 1.8.2

[133] Fix | Delete

*

[134] Fix | Delete

* @param int $payment_id Payment ID.

[135] Fix | Delete

* @param array $args Additional arguments.

[136] Fix | Delete

*

[137] Fix | Delete

* @return object|null

[138] Fix | Delete

*/

[139] Fix | Delete

public function get( $payment_id, $args = [] ) {

[140] Fix | Delete

[141] Fix | Delete

if ( ! $this->current_user_can( $payment_id, $args ) && wpforms()->obj( 'access' )->init_allowed() ) {

[142] Fix | Delete

return null;

[143] Fix | Delete

}

[144] Fix | Delete

[145] Fix | Delete

$payment = parent::get( $payment_id );

[146] Fix | Delete

[147] Fix | Delete

return $payment ? $this->cast_amounts_to_float( $payment ) : null;

[148] Fix | Delete

}

[149] Fix | Delete

[150] Fix | Delete

/**

[151] Fix | Delete

* Retrieve a row based on column value.

[152] Fix | Delete

*

[153] Fix | Delete

* @since 1.8.7

[154] Fix | Delete

*

[155] Fix | Delete

* @param string $column Column name.

[156] Fix | Delete

* @param int|string $value Column value.

[157] Fix | Delete

*

[158] Fix | Delete

* @return object|null Database query result, object or null on failure.

[159] Fix | Delete

*/

[160] Fix | Delete

public function get_by( $column, $value ) {

[161] Fix | Delete

[162] Fix | Delete

$payment = parent::get_by( $column, $value );

[163] Fix | Delete

[164] Fix | Delete

return $payment ? $this->cast_amounts_to_float( $payment ) : null;

[165] Fix | Delete

}

[166] Fix | Delete

[167] Fix | Delete

/**

[168] Fix | Delete

* Cast amounts to float in the given payment data object.

[169] Fix | Delete

*

[170] Fix | Delete

* @since 1.8.7

[171] Fix | Delete

*

[172] Fix | Delete

* @param object $payment Payment ID.

[173] Fix | Delete

*

[174] Fix | Delete

* @return object

[175] Fix | Delete

*/

[176] Fix | Delete

private function cast_amounts_to_float( $payment ) {

[177] Fix | Delete

[178] Fix | Delete

if ( empty( $payment ) || ! is_object( $payment ) ) {

[179] Fix | Delete

return $payment;

[180] Fix | Delete

}

[181] Fix | Delete

[182] Fix | Delete

// Amounts is stored in DB as decimal(26,8), but appear here as strings.

[183] Fix | Delete

// Therefore, they should be cast to float to avoid further multi-time currency conversion.

[184] Fix | Delete

$payment->subtotal_amount = $payment->subtotal_amount ? (float) $payment->subtotal_amount : 0;

[185] Fix | Delete

$payment->discount_amount = $payment->discount_amount ? (float) $payment->discount_amount : 0;

[186] Fix | Delete

$payment->total_amount = $payment->total_amount ? (float) $payment->total_amount : 0;

[187] Fix | Delete

[188] Fix | Delete

return $payment;

[189] Fix | Delete

}

[190] Fix | Delete

[191] Fix | Delete

/**

[192] Fix | Delete

* Update an existing payment in the database.

[193] Fix | Delete

*

[194] Fix | Delete

* @since 1.8.2

[195] Fix | Delete

*

[196] Fix | Delete

* @param string $payment_id Payment ID.

[197] Fix | Delete

* @param array $data Array of columns and associated data to update.

[198] Fix | Delete

* @param string $where Column to match against in the WHERE clause. If empty, $primary_key will be used.

[199] Fix | Delete

* @param string $type Data type context.

[200] Fix | Delete

* @param array $args Additional arguments.

[201] Fix | Delete

*

[202] Fix | Delete

* @return bool

[203] Fix | Delete

*/

[204] Fix | Delete

public function update( $payment_id, $data = [], $where = '', $type = '', $args = [] ) {

[205] Fix | Delete

[206] Fix | Delete

if ( ! $this->current_user_can( $payment_id, $args ) ) {

[207] Fix | Delete

return false;

[208] Fix | Delete

}

[209] Fix | Delete

[210] Fix | Delete

// TODO: consider validating other properties as well or get rid of it.

[211] Fix | Delete

if ( isset( $data['status'] ) && ! ValueValidator::is_valid( $data['status'], 'status' ) ) {

[212] Fix | Delete

return false;

[213] Fix | Delete

}

[214] Fix | Delete

[215] Fix | Delete

// Use database type identifier if a context is empty.

[216] Fix | Delete

$type = empty( $type ) ? $this->type : $type;

[217] Fix | Delete

[218] Fix | Delete

return parent::update( $payment_id, $data, $where, $type );

[219] Fix | Delete

}

[220] Fix | Delete

[221] Fix | Delete

/**

[222] Fix | Delete

* Delete a payment from the database, also removes payment meta.

[223] Fix | Delete

*

[224] Fix | Delete

* @since 1.8.2

[225] Fix | Delete

*

[226] Fix | Delete

* @param int $payment_id Payment ID.

[227] Fix | Delete

* @param array $args Additional arguments.

[228] Fix | Delete

*

[229] Fix | Delete

* @return bool False if the payment and meta could not be deleted, true otherwise.

[230] Fix | Delete

*/

[231] Fix | Delete

public function delete( $payment_id = 0, $args = [] ): bool {

[232] Fix | Delete

[233] Fix | Delete

if ( ! $this->current_user_can( $payment_id, $args ) ) {

[234] Fix | Delete

return false;

[235] Fix | Delete

}

[236] Fix | Delete

[237] Fix | Delete

$is_payment_deleted = parent::delete( $payment_id );

[238] Fix | Delete

$is_meta_deleted = wpforms()->obj( 'payment_meta' )->delete_by( 'payment_id', $payment_id );

[239] Fix | Delete

[240] Fix | Delete

return $is_payment_deleted && $is_meta_deleted;

[241] Fix | Delete

}

[242] Fix | Delete

[243] Fix | Delete

/**

[244] Fix | Delete

* Retrieve a list of payments.

[245] Fix | Delete

*

[246] Fix | Delete

* @since 1.8.2

[247] Fix | Delete

*

[248] Fix | Delete

* @param array $args Arguments.

[249] Fix | Delete

*

[250] Fix | Delete

* @return array

[251] Fix | Delete

*/

[252] Fix | Delete

public function get_payments( $args = [] ) {

[253] Fix | Delete

[254] Fix | Delete

global $wpdb;

[255] Fix | Delete

[256] Fix | Delete

$args = $this->sanitize_get_payments_args( $args );

[257] Fix | Delete

[258] Fix | Delete

if ( ! $this->current_user_can( 0, $args ) ) {

[259] Fix | Delete

return [];

[260] Fix | Delete

}

[261] Fix | Delete

[262] Fix | Delete

// Prepare query.

[263] Fix | Delete

$query[] = "SELECT p.* FROM {$this->table_name} as p";

[264] Fix | Delete

[265] Fix | Delete

/**

[266] Fix | Delete

* Filter the query for get_payments method before the WHERE clause.

[267] Fix | Delete

*

[268] Fix | Delete

* @since 1.8.2

[269] Fix | Delete

*

[270] Fix | Delete

* @param string $where Before the WHERE clause in DB query.

[271] Fix | Delete

* @param array $args Query arguments.

[272] Fix | Delete

*

[273] Fix | Delete

* @return string

[274] Fix | Delete

*/

[275] Fix | Delete

$query[] = apply_filters( 'wpforms_db_payments_payment_get_payments_query_before_where', '', $args );

[276] Fix | Delete

$query[] = 'WHERE 1=1';

[277] Fix | Delete

$query[] = $this->add_columns_where_conditions( $args );

[278] Fix | Delete

$query[] = $this->add_secondary_where_conditions( $args );

[279] Fix | Delete

[280] Fix | Delete

/**

[281] Fix | Delete

* Extend the query for the get_payments method after the WHERE clause.

[282] Fix | Delete

*

[283] Fix | Delete

* This hook provides the flexibility to modify the SQL query by appending custom conditions

[284] Fix | Delete

* right after the WHERE clause.

[285] Fix | Delete

*

[286] Fix | Delete

* @since 1.8.4

[287] Fix | Delete

*

[288] Fix | Delete

* @param string $where After the WHERE clause in the database query.

[289] Fix | Delete

* @param array $args Query arguments.

[290] Fix | Delete

*

[291] Fix | Delete

* @return string

[292] Fix | Delete

*/

[293] Fix | Delete

$query[] = apply_filters( 'wpforms_db_payments_payment_get_payments_query_after_where', '', $args );

[294] Fix | Delete

[295] Fix | Delete

// Order.

[296] Fix | Delete

$query[] = sprintf( 'ORDER BY %s', sanitize_sql_orderby( "{$args['orderby']} {$args['order']}" ) );

[297] Fix | Delete

[298] Fix | Delete

// Limit.

[299] Fix | Delete

$query[] = $wpdb->prepare( 'LIMIT %d, %d', $args['offset'], $args['number'] );

[300] Fix | Delete

[301] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[302] Fix | Delete

$result = $wpdb->get_results( implode( ' ', $query ), ARRAY_A );

[303] Fix | Delete

[304] Fix | Delete

// Get results.

[305] Fix | Delete

return ! $result ? [] : $result;

[306] Fix | Delete

}

[307] Fix | Delete

[308] Fix | Delete

/**

[309] Fix | Delete

* Create the table.

[310] Fix | Delete

*

[311] Fix | Delete

* @since 1.8.2

[312] Fix | Delete

*/

[313] Fix | Delete

public function create_table() {

[314] Fix | Delete

[315] Fix | Delete

global $wpdb;

[316] Fix | Delete

[317] Fix | Delete

$charset_collate = $wpdb->get_charset_collate();

[318] Fix | Delete

[319] Fix | Delete

/**

[320] Fix | Delete

* To avoid any possible issues during migration from entries to payments' table,

[321] Fix | Delete

* all data types are preserved.

[322] Fix | Delete

*

[323] Fix | Delete

* Note: there must be two spaces between the words PRIMARY KEY and the definition of primary key.

[324] Fix | Delete

*

[325] Fix | Delete

* @link https://codex.wordpress.org/Creating_Tables_with_Plugins#Creating_or_Updating_the_Table

[326] Fix | Delete

*/

[327] Fix | Delete

$query = "CREATE TABLE $this->table_name (

[328] Fix | Delete

id bigint(20) NOT NULL AUTO_INCREMENT,

[329] Fix | Delete

form_id bigint(20) NOT NULL,

[330] Fix | Delete

status varchar(10) NOT NULL DEFAULT '',

[331] Fix | Delete

subtotal_amount decimal(26,8) NOT NULL DEFAULT 0,

[332] Fix | Delete

discount_amount decimal(26,8) NOT NULL DEFAULT 0,

[333] Fix | Delete

total_amount decimal(26,8) NOT NULL DEFAULT 0,

[334] Fix | Delete

currency varchar(3) NOT NULL DEFAULT '',

[335] Fix | Delete

entry_id bigint(20) NOT NULL DEFAULT 0,

[336] Fix | Delete

gateway varchar(20) NOT NULL DEFAULT '',

[337] Fix | Delete

type varchar(12) NOT NULL DEFAULT '',

[338] Fix | Delete

mode varchar(4) NOT NULL DEFAULT '',

[339] Fix | Delete

transaction_id varchar(40) NOT NULL DEFAULT '',

[340] Fix | Delete

customer_id varchar(40) NOT NULL DEFAULT '',

[341] Fix | Delete

subscription_id varchar(40) NOT NULL DEFAULT '',

[342] Fix | Delete

subscription_status varchar(10) NOT NULL DEFAULT '',

[343] Fix | Delete

title varchar(255) NOT NULL DEFAULT '',

[344] Fix | Delete

date_created_gmt datetime NOT NULL,

[345] Fix | Delete

date_updated_gmt datetime NOT NULL,

[346] Fix | Delete

is_published tinyint(1) NOT NULL DEFAULT 1,

[347] Fix | Delete

PRIMARY KEY (id),

[348] Fix | Delete

KEY form_id (form_id),

[349] Fix | Delete

KEY status (status(8)),

[350] Fix | Delete

KEY total_amount (total_amount),

[351] Fix | Delete

KEY type (type(8)),

[352] Fix | Delete

KEY transaction_id (transaction_id(32)),

[353] Fix | Delete

KEY customer_id (customer_id(32)),

[354] Fix | Delete

KEY subscription_id (subscription_id(32)),

[355] Fix | Delete

KEY subscription_status (subscription_status(8)),

[356] Fix | Delete

KEY title (title(64))

[357] Fix | Delete

) $charset_collate;";

[358] Fix | Delete

[359] Fix | Delete

require_once ABSPATH . 'wp-admin/includes/upgrade.php';

[360] Fix | Delete

dbDelta( $query );

[361] Fix | Delete

}

[362] Fix | Delete

[363] Fix | Delete

/**

[364] Fix | Delete

* Check if the current user has capabilities to manage payments.

[365] Fix | Delete

*

[366] Fix | Delete

* @since 1.8.2

[367] Fix | Delete

*

[368] Fix | Delete

* @param int $payment_id Payment ID.

[369] Fix | Delete

* @param array $args Additional arguments.

[370] Fix | Delete

*

[371] Fix | Delete

* @return bool

[372] Fix | Delete

* @noinspection IfReturnReturnSimplificationInspection

[373] Fix | Delete

*/

[374] Fix | Delete

private function current_user_can( $payment_id, $args = [] ) {

[375] Fix | Delete

[376] Fix | Delete

$manage_cap = wpforms_get_capability_manage_options();

[377] Fix | Delete

[378] Fix | Delete

if ( ! isset( $args['cap'] ) ) {

[379] Fix | Delete

$args['cap'] = $manage_cap;

[380] Fix | Delete

}

[381] Fix | Delete

[382] Fix | Delete

if ( ! empty( $args['cap'] ) && ! wpforms_current_user_can( $args['cap'], $payment_id ) ) {

[383] Fix | Delete

return false;

[384] Fix | Delete

}

[385] Fix | Delete

[386] Fix | Delete

return true;

[387] Fix | Delete

}

[388] Fix | Delete

[389] Fix | Delete

/**

[390] Fix | Delete

* Construct where clauses for selected columns.

[391] Fix | Delete

*

[392] Fix | Delete

* @since 1.8.4

[393] Fix | Delete

*

[394] Fix | Delete

* @param array $args Query arguments.

[395] Fix | Delete

*

[396] Fix | Delete

* @return string

[397] Fix | Delete

*/

[398] Fix | Delete

public function add_columns_where_conditions( $args = [] ) {

[399] Fix | Delete

[400] Fix | Delete

// Allowed columns for filtering.

[401] Fix | Delete

$allowed_cols = [

[402] Fix | Delete

'form_id',

[403] Fix | Delete

'entry_id',

[404] Fix | Delete

'status',

[405] Fix | Delete

'subscription_status',

[406] Fix | Delete

'type',

[407] Fix | Delete

'gateway',

[408] Fix | Delete

];

[409] Fix | Delete

[410] Fix | Delete

$where = '';

[411] Fix | Delete

[412] Fix | Delete

// Determine if this is a table query.

[413] Fix | Delete

$is_table_query = ! empty( $args['table_query'] );

[414] Fix | Delete

$keys_to_validate = [ 'status', 'subscription_status', 'type', 'gateway' ];

[415] Fix | Delete

[416] Fix | Delete

foreach ( $args as $key => $value ) {

[417] Fix | Delete

if ( empty( $value ) || ! in_array( $key, $allowed_cols, true ) ) {

[418] Fix | Delete

continue;

[419] Fix | Delete

}

[420] Fix | Delete

[421] Fix | Delete

// Explode values if needed.

[422] Fix | Delete

$values = explode( '|', $value );

[423] Fix | Delete

[424] Fix | Delete

// Run some keys through the "ValueValidator" class to make sure they are valid.

[425] Fix | Delete

if ( in_array( $key, $keys_to_validate, true ) ) {

[426] Fix | Delete

$values = array_filter(

[427] Fix | Delete

$values,

[428] Fix | Delete

static function ( $v ) use ( $key ) {

[429] Fix | Delete

[430] Fix | Delete

return ValueValidator::is_valid( $v, $key );

[431] Fix | Delete

}

[432] Fix | Delete

);

[433] Fix | Delete

}

[434] Fix | Delete

[435] Fix | Delete

// Skip if no valid values found.

[436] Fix | Delete

if ( empty( $values ) ) {

[437] Fix | Delete

continue;

[438] Fix | Delete

}

[439] Fix | Delete

[440] Fix | Delete

// Merge "Partially Refunded" status with "Refunded" status.

[441] Fix | Delete

if ( $is_table_query && $key === 'status' && in_array( 'refunded', $values, true ) ) {

[442] Fix | Delete

$values[] = 'partrefund';

[443] Fix | Delete

}

[444] Fix | Delete

[445] Fix | Delete

$placeholders = wpforms_wpdb_prepare_in( $values );

[446] Fix | Delete

[447] Fix | Delete

// Prepare and add to WHERE clause.

[448] Fix | Delete

$where .= " AND {$key} IN ({$placeholders})";

[449] Fix | Delete

}

[450] Fix | Delete

[451] Fix | Delete

return $where;

[452] Fix | Delete

}

[453] Fix | Delete

[454] Fix | Delete

/**

[455] Fix | Delete

* Construct secondary where clauses.

[456] Fix | Delete

*

[457] Fix | Delete

* @since 1.8.2

[458] Fix | Delete

*

[459] Fix | Delete

* @param array $args Query arguments.

[460] Fix | Delete

*

[461] Fix | Delete

* @return string

[462] Fix | Delete

*/

[463] Fix | Delete

public function add_secondary_where_conditions( $args = [] ) {

[464] Fix | Delete

[465] Fix | Delete

global $wpdb;

[466] Fix | Delete

[467] Fix | Delete

/**

[468] Fix | Delete

* Filter arguments needed for all query.

[469] Fix | Delete

*

[470] Fix | Delete

* @since 1.8.2

[471] Fix | Delete

*

[472] Fix | Delete

* @param array $args Query arguments.

[473] Fix | Delete

*/

[474] Fix | Delete

$args = (array) apply_filters( 'wpforms_db_payments_payment_add_secondary_where_conditions_args', $args );

[475] Fix | Delete

$args = wp_parse_args(

[476] Fix | Delete

(array) $args,

[477] Fix | Delete

[

[478] Fix | Delete

'currency' => wpforms_get_currency(),

[479] Fix | Delete

'mode' => 'live',

[480] Fix | Delete

'is_published' => 1,

[481] Fix | Delete

]

[482] Fix | Delete

);

[483] Fix | Delete

[484] Fix | Delete

$where = '';

[485] Fix | Delete

[486] Fix | Delete

// If it's a valid mode, add it to a WHERE clause.

[487] Fix | Delete

if ( ValueValidator::is_valid( $args['mode'], 'mode' ) ) {

[488] Fix | Delete

$where .= $wpdb->prepare( ' AND mode = %s', $args['mode'] );

[489] Fix | Delete

}

[490] Fix | Delete

[491] Fix | Delete

$where .= $wpdb->prepare( ' AND currency = %s', $args['currency'] );

[492] Fix | Delete

$where .= $wpdb->prepare( ' AND is_published = %d', $args['is_published'] );

[493] Fix | Delete

[494] Fix | Delete

return $where;

[495] Fix | Delete

}

[496] Fix | Delete

[497] Fix | Delete

/**

[498] Fix | Delete

* Sanitize query arguments for get_payments() method.

[499] Fix | Delete