$prev_end->setTimezone( $local_tz );

[500] Fix | Delete

$interval_end = $prev_end->format( 'Y-m-d H:i:s' );

[501] Fix | Delete

}

[502] Fix | Delete

if ( array_key_exists( $time_id, $time_ids ) ) {

[503] Fix | Delete

// For interval present in the db for this time frame, just fill in dates.

[504] Fix | Delete

$record = &$data->intervals[ $time_ids[ $time_id ] ];

[505] Fix | Delete

$record['date_start'] = $start_datetime->format( 'Y-m-d H:i:s' );

[506] Fix | Delete

$record['date_end'] = $interval_end;

[507] Fix | Delete

} elseif ( ! array_key_exists( $time_id, $db_intervals ) ) {

[508] Fix | Delete

// For intervals present in the db outside of this time frame, do nothing.

[509] Fix | Delete

// For intervals not present in the db, fabricate it.

[510] Fix | Delete

$record_arr = array();

[511] Fix | Delete

$record_arr['time_interval'] = $time_id;

[512] Fix | Delete

$record_arr['date_start'] = $start_datetime->format( 'Y-m-d H:i:s' );

[513] Fix | Delete

$record_arr['date_end'] = $interval_end;

[514] Fix | Delete

$data->intervals[] = array_merge( $record_arr, $totals_arr );

[515] Fix | Delete

}

[516] Fix | Delete

$start_datetime = $next_start;

[517] Fix | Delete

}

[518] Fix | Delete

return $data;

[519] Fix | Delete

}

[520] Fix | Delete

[521] Fix | Delete

/**

[522] Fix | Delete

* Converts input datetime parameters to local timezone. If there are no inputs from the user in query_args,

[523] Fix | Delete

* uses default from $defaults.

[524] Fix | Delete

*

[525] Fix | Delete

* @param array $query_args Array of query arguments.

[526] Fix | Delete

* @param array $defaults Array of default values.

[527] Fix | Delete

*/

[528] Fix | Delete

protected function normalize_timezones( &$query_args, $defaults ) {

[529] Fix | Delete

$local_tz = new \DateTimeZone( wc_timezone_string() );

[530] Fix | Delete

foreach ( array( 'before', 'after' ) as $query_arg_key ) {

[531] Fix | Delete

if ( isset( $query_args[ $query_arg_key ] ) && is_string( $query_args[ $query_arg_key ] ) ) {

[532] Fix | Delete

// Assume that unspecified timezone is a local timezone.

[533] Fix | Delete

$datetime = new \DateTime( $query_args[ $query_arg_key ], $local_tz );

[534] Fix | Delete

// In case timezone was forced by using +HH:MM, convert to local timezone.

[535] Fix | Delete

$datetime->setTimezone( $local_tz );

[536] Fix | Delete

$query_args[ $query_arg_key ] = $datetime;

[537] Fix | Delete

} elseif ( isset( $query_args[ $query_arg_key ] ) && is_a( $query_args[ $query_arg_key ], 'DateTime' ) ) {

[538] Fix | Delete

// In case timezone is in other timezone, convert to local timezone.

[539] Fix | Delete

$query_args[ $query_arg_key ]->setTimezone( $local_tz );

[540] Fix | Delete

} else {

[541] Fix | Delete

$query_args[ $query_arg_key ] = isset( $defaults[ $query_arg_key ] ) ? $defaults[ $query_arg_key ] : null;

[542] Fix | Delete

}

[543] Fix | Delete

}

[544] Fix | Delete

}

[545] Fix | Delete

[546] Fix | Delete

/**

[547] Fix | Delete

* Removes extra records from intervals so that only requested number of records get returned.

[548] Fix | Delete

*

[549] Fix | Delete

* @param stdClass $data Data from whose intervals the records get removed.

[550] Fix | Delete

* @param int $page_no Offset requested by the user.

[551] Fix | Delete

* @param int $items_per_page Number of records requested by the user.

[552] Fix | Delete

* @param int $db_interval_count Database interval count.

[553] Fix | Delete

* @param int $expected_interval_count Expected interval count on the output.

[554] Fix | Delete

* @param string $order_by Order by field.

[555] Fix | Delete

* @param string $order ASC or DESC.

[556] Fix | Delete

*/

[557] Fix | Delete

protected function remove_extra_records( &$data, $page_no, $items_per_page, $db_interval_count, $expected_interval_count, $order_by, $order ) {

[558] Fix | Delete

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

[559] Fix | Delete

$offset = 0;

[560] Fix | Delete

} else {

[561] Fix | Delete

if ( 'asc' === strtolower( $order ) ) {

[562] Fix | Delete

$offset = ( $page_no - 1 ) * $items_per_page;

[563] Fix | Delete

} else {

[564] Fix | Delete

$offset = ( $page_no - 1 ) * $items_per_page - $db_interval_count;

[565] Fix | Delete

}

[566] Fix | Delete

$offset = $offset < 0 ? 0 : $offset;

[567] Fix | Delete

}

[568] Fix | Delete

$count = $expected_interval_count - ( $page_no - 1 ) * $items_per_page;

[569] Fix | Delete

if ( $count < 0 ) {

[570] Fix | Delete

$count = 0;

[571] Fix | Delete

} elseif ( $count > $items_per_page ) {

[572] Fix | Delete

$count = $items_per_page;

[573] Fix | Delete

}

[574] Fix | Delete

$data->intervals = array_slice( $data->intervals, $offset, $count );

[575] Fix | Delete

}

[576] Fix | Delete

[577] Fix | Delete

/**

[578] Fix | Delete

* Returns expected number of items on the page in case of date ordering.

[579] Fix | Delete

*

[580] Fix | Delete

* @param int $expected_interval_count Expected number of intervals in total.

[581] Fix | Delete

* @param int $items_per_page Number of items per page.

[582] Fix | Delete

* @param int $page_no Page number.

[583] Fix | Delete

*

[584] Fix | Delete

* @return float|int

[585] Fix | Delete

*/

[586] Fix | Delete

protected function expected_intervals_on_page( $expected_interval_count, $items_per_page, $page_no ) {

[587] Fix | Delete

$total_pages = (int) ceil( $expected_interval_count / $items_per_page );

[588] Fix | Delete

if ( $page_no < $total_pages ) {

[589] Fix | Delete

return $items_per_page;

[590] Fix | Delete

} elseif ( $page_no === $total_pages ) {

[591] Fix | Delete

return $expected_interval_count - ( $page_no - 1 ) * $items_per_page;

[592] Fix | Delete

} else {

[593] Fix | Delete

return 0;

[594] Fix | Delete

}

[595] Fix | Delete

}

[596] Fix | Delete

[597] Fix | Delete

/**

[598] Fix | Delete

* Returns true if there are any intervals that need to be filled in the response.

[599] Fix | Delete

*

[600] Fix | Delete

* @param int $expected_interval_count Expected number of intervals in total.

[601] Fix | Delete

* @param int $db_records Total number of records for given period in the database.

[602] Fix | Delete

* @param int $items_per_page Number of items per page.

[603] Fix | Delete

* @param int $page_no Page number.

[604] Fix | Delete

* @param string $order asc or desc.

[605] Fix | Delete

* @param string $order_by Column by which the result will be sorted.

[606] Fix | Delete

* @param int $intervals_count Number of records for given (possibly shortened) time interval.

[607] Fix | Delete

*

[608] Fix | Delete

* @return bool

[609] Fix | Delete

*/

[610] Fix | Delete

protected function intervals_missing( $expected_interval_count, $db_records, $items_per_page, $page_no, $order, $order_by, $intervals_count ) {

[611] Fix | Delete

if ( $expected_interval_count <= $db_records ) {

[612] Fix | Delete

return false;

[613] Fix | Delete

}

[614] Fix | Delete

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

[615] Fix | Delete

$expected_intervals_on_page = $this->expected_intervals_on_page( $expected_interval_count, $items_per_page, $page_no );

[616] Fix | Delete

return $intervals_count < $expected_intervals_on_page;

[617] Fix | Delete

}

[618] Fix | Delete

if ( 'desc' === $order ) {

[619] Fix | Delete

return $page_no > floor( $db_records / $items_per_page );

[620] Fix | Delete

}

[621] Fix | Delete

if ( 'asc' === $order ) {

[622] Fix | Delete

return $page_no <= ceil( ( $expected_interval_count - $db_records ) / $items_per_page );

[623] Fix | Delete

}

[624] Fix | Delete

// Invalid ordering.

[625] Fix | Delete

return false;

[626] Fix | Delete

}

[627] Fix | Delete

[628] Fix | Delete

/**

[629] Fix | Delete

* Updates the LIMIT query part for Intervals query of the report.

[630] Fix | Delete

*

[631] Fix | Delete

* If there are less records in the database than time intervals, then we need to remap offset in SQL query

[632] Fix | Delete

* to fetch correct records.

[633] Fix | Delete

*

[634] Fix | Delete

* @param array $query_args Query arguments.

[635] Fix | Delete

* @param int $db_interval_count Database interval count.

[636] Fix | Delete

* @param int $expected_interval_count Expected interval count on the output.

[637] Fix | Delete

* @param string $table_name Name of the db table relevant for the date constraint.

[638] Fix | Delete

*/

[639] Fix | Delete

protected function update_intervals_sql_params( &$query_args, $db_interval_count, $expected_interval_count, $table_name ) {

[640] Fix | Delete

if ( $db_interval_count === $expected_interval_count ) {

[641] Fix | Delete

return;

[642] Fix | Delete

}

[643] Fix | Delete

[644] Fix | Delete

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

[645] Fix | Delete

$local_tz = new \DateTimeZone( wc_timezone_string() );

[646] Fix | Delete

if ( 'date' === strtolower( $query_args['orderby'] ) ) {

[647] Fix | Delete

// page X in request translates to slightly different dates in the db, in case some

[648] Fix | Delete

// records are missing from the db.

[649] Fix | Delete

$start_iteration = 0;

[650] Fix | Delete

$end_iteration = 0;

[651] Fix | Delete

if ( 'asc' === strtolower( $query_args['order'] ) ) {

[652] Fix | Delete

// ORDER BY date ASC.

[653] Fix | Delete

$new_start_date = $query_args['after'];

[654] Fix | Delete

$intervals_to_skip = ( $query_args['page'] - 1 ) * $params['per_page'];

[655] Fix | Delete

$latest_end_date = $query_args['before'];

[656] Fix | Delete

for ( $i = 0; $i < $intervals_to_skip; $i++ ) {

[657] Fix | Delete

if ( $new_start_date > $latest_end_date ) {

[658] Fix | Delete

$new_start_date = $latest_end_date;

[659] Fix | Delete

$start_iteration = 0;

[660] Fix | Delete

break;

[661] Fix | Delete

}

[662] Fix | Delete

$new_start_date = TimeInterval::iterate( $new_start_date, $query_args['interval'] );

[663] Fix | Delete

$start_iteration ++;

[664] Fix | Delete

}

[665] Fix | Delete

[666] Fix | Delete

$new_end_date = clone $new_start_date;

[667] Fix | Delete

for ( $i = 0; $i < $params['per_page']; $i++ ) {

[668] Fix | Delete

if ( $new_end_date > $latest_end_date ) {

[669] Fix | Delete

break;

[670] Fix | Delete

}

[671] Fix | Delete

$new_end_date = TimeInterval::iterate( $new_end_date, $query_args['interval'] );

[672] Fix | Delete

$end_iteration ++;

[673] Fix | Delete

}

[674] Fix | Delete

if ( $new_end_date > $latest_end_date ) {

[675] Fix | Delete

$new_end_date = $latest_end_date;

[676] Fix | Delete

$end_iteration = 0;

[677] Fix | Delete

}

[678] Fix | Delete

if ( $end_iteration ) {

[679] Fix | Delete

$new_end_date_timestamp = (int) $new_end_date->format( 'U' ) - 1;

[680] Fix | Delete

$new_end_date->setTimestamp( $new_end_date_timestamp );

[681] Fix | Delete

}

[682] Fix | Delete

} else {

[683] Fix | Delete

// ORDER BY date DESC.

[684] Fix | Delete

$new_end_date = $query_args['before'];

[685] Fix | Delete

$intervals_to_skip = ( $query_args['page'] - 1 ) * $params['per_page'];

[686] Fix | Delete

$earliest_start_date = $query_args['after'];

[687] Fix | Delete

for ( $i = 0; $i < $intervals_to_skip; $i++ ) {

[688] Fix | Delete

if ( $new_end_date < $earliest_start_date ) {

[689] Fix | Delete

$new_end_date = $earliest_start_date;

[690] Fix | Delete

$end_iteration = 0;

[691] Fix | Delete

break;

[692] Fix | Delete

}

[693] Fix | Delete

$new_end_date = TimeInterval::iterate( $new_end_date, $query_args['interval'], true );

[694] Fix | Delete

$end_iteration ++;

[695] Fix | Delete

}

[696] Fix | Delete

[697] Fix | Delete

$new_start_date = clone $new_end_date;

[698] Fix | Delete

for ( $i = 0; $i < $params['per_page']; $i++ ) {

[699] Fix | Delete

if ( $new_start_date < $earliest_start_date ) {

[700] Fix | Delete

break;

[701] Fix | Delete

}

[702] Fix | Delete

$new_start_date = TimeInterval::iterate( $new_start_date, $query_args['interval'], true );

[703] Fix | Delete

$start_iteration ++;

[704] Fix | Delete

}

[705] Fix | Delete

if ( $new_start_date < $earliest_start_date ) {

[706] Fix | Delete

$new_start_date = $earliest_start_date;

[707] Fix | Delete

$start_iteration = 0;

[708] Fix | Delete

}

[709] Fix | Delete

if ( $start_iteration ) {

[710] Fix | Delete

// @todo Is this correct? should it only be added if iterate runs? other two iterate instances, too?

[711] Fix | Delete

$new_start_date_timestamp = (int) $new_start_date->format( 'U' ) + 1;

[712] Fix | Delete

$new_start_date->setTimestamp( $new_start_date_timestamp );

[713] Fix | Delete

}

[714] Fix | Delete

}

[715] Fix | Delete

// @todo - Do this without modifying $query_args?

[716] Fix | Delete

$query_args['adj_after'] = $new_start_date;

[717] Fix | Delete

$query_args['adj_before'] = $new_end_date;

[718] Fix | Delete

$adj_after = $new_start_date->format( TimeInterval::$sql_datetime_format );

[719] Fix | Delete

$adj_before = $new_end_date->format( TimeInterval::$sql_datetime_format );

[720] Fix | Delete

$this->interval_query->clear_sql_clause( array( 'where_time', 'limit' ) );

[721] Fix | Delete

$this->interval_query->add_sql_clause( 'where_time', "AND {$table_name}.`{$this->date_column_name}` <= '$adj_before'" );

[722] Fix | Delete

$this->interval_query->add_sql_clause( 'where_time', "AND {$table_name}.`{$this->date_column_name}` >= '$adj_after'" );

[723] Fix | Delete

$this->clear_sql_clause( 'limit' );

[724] Fix | Delete

$this->add_sql_clause( 'limit', 'LIMIT 0,' . $params['per_page'] );

[725] Fix | Delete

} else {

[726] Fix | Delete

if ( 'asc' === $query_args['order'] ) {

[727] Fix | Delete

$offset = ( ( $query_args['page'] - 1 ) * $params['per_page'] ) - ( $expected_interval_count - $db_interval_count );

[728] Fix | Delete

$offset = $offset < 0 ? 0 : $offset;

[729] Fix | Delete

$count = $query_args['page'] * $params['per_page'] - ( $expected_interval_count - $db_interval_count );

[730] Fix | Delete

if ( $count < 0 ) {

[731] Fix | Delete

$count = 0;

[732] Fix | Delete

} elseif ( $count > $params['per_page'] ) {

[733] Fix | Delete

$count = $params['per_page'];

[734] Fix | Delete

}

[735] Fix | Delete

[736] Fix | Delete

$this->clear_sql_clause( 'limit' );

[737] Fix | Delete

$this->add_sql_clause( 'limit', 'LIMIT ' . $offset . ',' . $count );

[738] Fix | Delete

}

[739] Fix | Delete

// Otherwise no change in limit clause.

[740] Fix | Delete

// @todo - Do this without modifying $query_args?

[741] Fix | Delete

$query_args['adj_after'] = $query_args['after'];

[742] Fix | Delete

$query_args['adj_before'] = $query_args['before'];

[743] Fix | Delete

}

[744] Fix | Delete

}

[745] Fix | Delete

[746] Fix | Delete

/**

[747] Fix | Delete

* Casts strings returned from the database to appropriate data types for output.

[748] Fix | Delete

*

[749] Fix | Delete

* @param array $array Associative array of values extracted from the database.

[750] Fix | Delete

* @return array|WP_Error

[751] Fix | Delete

*/

[752] Fix | Delete

protected function cast_numbers( $array ) {

[753] Fix | Delete

$retyped_array = array();

[754] Fix | Delete

$column_types = apply_filters( 'woocommerce_rest_reports_column_types', $this->column_types, $array );

[755] Fix | Delete

foreach ( $array as $column_name => $value ) {

[756] Fix | Delete

if ( is_array( $value ) ) {

[757] Fix | Delete

$value = $this->cast_numbers( $value );

[758] Fix | Delete

}

[759] Fix | Delete

[760] Fix | Delete

if ( isset( $column_types[ $column_name ] ) ) {

[761] Fix | Delete

$retyped_array[ $column_name ] = $column_types[ $column_name ]( $value );

[762] Fix | Delete

} else {

[763] Fix | Delete

$retyped_array[ $column_name ] = $value;

[764] Fix | Delete

}

[765] Fix | Delete

}

[766] Fix | Delete

return $retyped_array;

[767] Fix | Delete

}

[768] Fix | Delete

[769] Fix | Delete

/**

[770] Fix | Delete

* Returns a list of columns selected by the query_args formatted as a comma separated string.

[771] Fix | Delete

*

[772] Fix | Delete

* @param array $query_args User-supplied options.

[773] Fix | Delete

* @return string

[774] Fix | Delete

*/

[775] Fix | Delete

protected function selected_columns( $query_args ) {

[776] Fix | Delete

$selections = $this->report_columns;

[777] Fix | Delete

[778] Fix | Delete

if ( isset( $query_args['fields'] ) && is_array( $query_args['fields'] ) ) {

[779] Fix | Delete

$keep = array();

[780] Fix | Delete

foreach ( $query_args['fields'] as $field ) {

[781] Fix | Delete

if ( isset( $selections[ $field ] ) ) {

[782] Fix | Delete

$keep[ $field ] = $selections[ $field ];

[783] Fix | Delete

}

[784] Fix | Delete

}

[785] Fix | Delete

$selections = implode( ', ', $keep );

[786] Fix | Delete

} else {

[787] Fix | Delete

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

[788] Fix | Delete

}

[789] Fix | Delete

return $selections;

[790] Fix | Delete

}

[791] Fix | Delete

[792] Fix | Delete

/**

[793] Fix | Delete

* Get the excluded order statuses used when calculating reports.

[794] Fix | Delete

*

[795] Fix | Delete

* @return array

[796] Fix | Delete

*/

[797] Fix | Delete

protected static function get_excluded_report_order_statuses() {

[798] Fix | Delete

$excluded_statuses = \WC_Admin_Settings::get_option( 'woocommerce_excluded_report_order_statuses', array( 'pending', 'failed', 'cancelled' ) );

[799] Fix | Delete

$excluded_statuses = array_merge( array( 'auto-draft', 'trash' ), array_map( 'esc_sql', $excluded_statuses ) );

[800] Fix | Delete

return apply_filters( 'woocommerce_analytics_excluded_order_statuses', $excluded_statuses );

[801] Fix | Delete

}

[802] Fix | Delete

[803] Fix | Delete

/**

[804] Fix | Delete

* Maps order status provided by the user to the one used in the database.

[805] Fix | Delete

*

[806] Fix | Delete

* @param string $status Order status.

[807] Fix | Delete

* @return string

[808] Fix | Delete

*/

[809] Fix | Delete

protected static function normalize_order_status( $status ) {

[810] Fix | Delete

$status = trim( $status );

[811] Fix | Delete

return 'wc-' . $status;

[812] Fix | Delete

}

[813] Fix | Delete

[814] Fix | Delete

/**

[815] Fix | Delete

* Normalizes order_by clause to match to SQL query.

[816] Fix | Delete

*

[817] Fix | Delete

* @param string $order_by Order by option requested by user.

[818] Fix | Delete

* @return string

[819] Fix | Delete

*/

[820] Fix | Delete

protected function normalize_order_by( $order_by ) {

[821] Fix | Delete

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

[822] Fix | Delete

return 'time_interval';

[823] Fix | Delete

}

[824] Fix | Delete

[825] Fix | Delete

return $order_by;

[826] Fix | Delete

}

[827] Fix | Delete

[828] Fix | Delete

/**

[829] Fix | Delete

* Updates start and end dates for intervals so that they represent intervals' borders, not times when data in db were recorded.

[830] Fix | Delete

*

[831] Fix | Delete

* E.g. if there are db records for only Tuesday and Thursday this week, the actual week interval is [Mon, Sun], not [Tue, Thu].

[832] Fix | Delete

*

[833] Fix | Delete

* @param DateTime $start_datetime Start date.

[834] Fix | Delete

* @param DateTime $end_datetime End date.

[835] Fix | Delete

* @param string $time_interval Time interval, e.g. day, week, month.

[836] Fix | Delete

* @param array $intervals Array of intervals extracted from SQL db.

[837] Fix | Delete

*/

[838] Fix | Delete

protected function update_interval_boundary_dates( $start_datetime, $end_datetime, $time_interval, &$intervals ) {

[839] Fix | Delete

$local_tz = new \DateTimeZone( wc_timezone_string() );

[840] Fix | Delete

foreach ( $intervals as $key => $interval ) {

[841] Fix | Delete

$datetime = new \DateTime( $interval['datetime_anchor'], $local_tz );

[842] Fix | Delete

[843] Fix | Delete

$prev_start = TimeInterval::iterate( $datetime, $time_interval, true );

[844] Fix | Delete

// @todo Not sure if the +1/-1 here are correct, especially as they are applied before the ?: below.

[845] Fix | Delete

$prev_start_timestamp = (int) $prev_start->format( 'U' ) + 1;

[846] Fix | Delete

$prev_start->setTimestamp( $prev_start_timestamp );

[847] Fix | Delete

if ( $start_datetime ) {

[848] Fix | Delete

$date_start = $prev_start < $start_datetime ? $start_datetime : $prev_start;

[849] Fix | Delete

$intervals[ $key ]['date_start'] = $date_start->format( 'Y-m-d H:i:s' );

[850] Fix | Delete

} else {

[851] Fix | Delete

$intervals[ $key ]['date_start'] = $prev_start->format( 'Y-m-d H:i:s' );

[852] Fix | Delete

}

[853] Fix | Delete

[854] Fix | Delete

$next_end = TimeInterval::iterate( $datetime, $time_interval );

[855] Fix | Delete

$next_end_timestamp = (int) $next_end->format( 'U' ) - 1;

[856] Fix | Delete

$next_end->setTimestamp( $next_end_timestamp );

[857] Fix | Delete

if ( $end_datetime ) {

[858] Fix | Delete

$date_end = $next_end > $end_datetime ? $end_datetime : $next_end;

[859] Fix | Delete

$intervals[ $key ]['date_end'] = $date_end->format( 'Y-m-d H:i:s' );

[860] Fix | Delete

} else {

[861] Fix | Delete

$intervals[ $key ]['date_end'] = $next_end->format( 'Y-m-d H:i:s' );

[862] Fix | Delete

}

[863] Fix | Delete

[864] Fix | Delete

$intervals[ $key ]['interval'] = $time_interval;

[865] Fix | Delete

}

[866] Fix | Delete

}

[867] Fix | Delete

[868] Fix | Delete

/**

[869] Fix | Delete

* Change structure of intervals to form a correct response.

[870] Fix | Delete

*

[871] Fix | Delete

* Also converts local datetimes to GMT and adds them to the intervals.

[872] Fix | Delete

*

[873] Fix | Delete

* @param array $intervals Time interval, e.g. day, week, month.

[874] Fix | Delete

*/

[875] Fix | Delete

protected function create_interval_subtotals( &$intervals ) {

[876] Fix | Delete

foreach ( $intervals as $key => $interval ) {

[877] Fix | Delete

$start_gmt = TimeInterval::convert_local_datetime_to_gmt( $interval['date_start'] );

[878] Fix | Delete

$end_gmt = TimeInterval::convert_local_datetime_to_gmt( $interval['date_end'] );

[879] Fix | Delete

// Move intervals result to subtotals object.

[880] Fix | Delete

$intervals[ $key ] = array(

[881] Fix | Delete

'interval' => $interval['time_interval'],

[882] Fix | Delete

'date_start' => $interval['date_start'],

[883] Fix | Delete

'date_start_gmt' => $start_gmt->format( TimeInterval::$sql_datetime_format ),

[884] Fix | Delete

'date_end' => $interval['date_end'],

[885] Fix | Delete

'date_end_gmt' => $end_gmt->format( TimeInterval::$sql_datetime_format ),

[886] Fix | Delete

);

[887] Fix | Delete

[888] Fix | Delete

unset( $interval['interval'] );

[889] Fix | Delete

unset( $interval['date_start'] );

[890] Fix | Delete

unset( $interval['date_end'] );

[891] Fix | Delete

unset( $interval['datetime_anchor'] );

[892] Fix | Delete

unset( $interval['time_interval'] );

[893] Fix | Delete

$intervals[ $key ]['subtotals'] = (object) $this->cast_numbers( $interval );

[894] Fix | Delete

}

[895] Fix | Delete

}

[896] Fix | Delete

[897] Fix | Delete

/**

[898] Fix | Delete

* Fills WHERE clause of SQL request with date-related constraints.

[899] Fix | Delete

*

[900] Fix | Delete

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

[901] Fix | Delete

* @param string $table_name Name of the db table relevant for the date constraint.

[902] Fix | Delete

*/

[903] Fix | Delete

protected function add_time_period_sql_params( $query_args, $table_name ) {

[904] Fix | Delete

$this->clear_sql_clause( array( 'from', 'where_time', 'where' ) );

[905] Fix | Delete

if ( isset( $this->subquery ) ) {

[906] Fix | Delete

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

[907] Fix | Delete

}

[908] Fix | Delete

[909] Fix | Delete

if ( isset( $query_args['before'] ) && '' !== $query_args['before'] ) {

[910] Fix | Delete

if ( is_a( $query_args['before'], 'WC_DateTime' ) ) {

[911] Fix | Delete

$datetime_str = $query_args['before']->date( TimeInterval::$sql_datetime_format );

[912] Fix | Delete

} else {

[913] Fix | Delete

$datetime_str = $query_args['before']->format( TimeInterval::$sql_datetime_format );

[914] Fix | Delete

}

[915] Fix | Delete

if ( isset( $this->subquery ) ) {

[916] Fix | Delete

$this->subquery->add_sql_clause( 'where_time', "AND {$table_name}.`{$this->date_column_name}` <= '$datetime_str'" );

[917] Fix | Delete

} else {

[918] Fix | Delete

$this->add_sql_clause( 'where_time', "AND {$table_name}.`{$this->date_column_name}` <= '$datetime_str'" );

[919] Fix | Delete

}

[920] Fix | Delete

}

[921] Fix | Delete

[922] Fix | Delete

if ( isset( $query_args['after'] ) && '' !== $query_args['after'] ) {

[923] Fix | Delete

if ( is_a( $query_args['after'], 'WC_DateTime' ) ) {

[924] Fix | Delete

$datetime_str = $query_args['after']->date( TimeInterval::$sql_datetime_format );

[925] Fix | Delete

} else {

[926] Fix | Delete

$datetime_str = $query_args['after']->format( TimeInterval::$sql_datetime_format );

[927] Fix | Delete

}

[928] Fix | Delete

if ( isset( $this->subquery ) ) {

[929] Fix | Delete

$this->subquery->add_sql_clause( 'where_time', "AND {$table_name}.`{$this->date_column_name}` >= '$datetime_str'" );

[930] Fix | Delete

} else {

[931] Fix | Delete

$this->add_sql_clause( 'where_time', "AND {$table_name}.`{$this->date_column_name}` >= '$datetime_str'" );

[932] Fix | Delete

}

[933] Fix | Delete

}

[934] Fix | Delete

}

[935] Fix | Delete

[936] Fix | Delete

/**

[937] Fix | Delete

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

[938] Fix | Delete

*

[939] Fix | Delete

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

[940] Fix | Delete

* @return array

[941] Fix | Delete

*/

[942] Fix | Delete

protected function get_limit_sql_params( $query_args ) {

[943] Fix | Delete

global $wpdb;

[944] Fix | Delete

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

[945] Fix | Delete

[946] Fix | Delete

$this->clear_sql_clause( 'limit' );

[947] Fix | Delete

$this->add_sql_clause( 'limit', $wpdb->prepare( 'LIMIT %d, %d', $params['offset'], $params['per_page'] ) );

[948] Fix | Delete

return $params;

[949] Fix | Delete

}

[950] Fix | Delete

[951] Fix | Delete

/**

[952] Fix | Delete

* Fills LIMIT parameters of SQL request based on user supplied parameters.

[953] Fix | Delete

*

[954] Fix | Delete

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

[955] Fix | Delete

* @return array

[956] Fix | Delete

*/

[957] Fix | Delete

protected function get_limit_params( $query_args = array() ) {

[958] Fix | Delete

if ( isset( $query_args['per_page'] ) && is_numeric( $query_args['per_page'] ) ) {

[959] Fix | Delete

$this->limit_parameters['per_page'] = (int) $query_args['per_page'];

[960] Fix | Delete

} else {

[961] Fix | Delete

$this->limit_parameters['per_page'] = get_option( 'posts_per_page' );

[962] Fix | Delete

}

[963] Fix | Delete

[964] Fix | Delete

$this->limit_parameters['offset'] = 0;

[965] Fix | Delete

if ( isset( $query_args['page'] ) ) {

[966] Fix | Delete

$this->limit_parameters['offset'] = ( (int) $query_args['page'] - 1 ) * $this->limit_parameters['per_page'];

[967] Fix | Delete

}

[968] Fix | Delete

[969] Fix | Delete

return $this->limit_parameters;

[970] Fix | Delete

}

[971] Fix | Delete

[972] Fix | Delete

/**

[973] Fix | Delete

* Generates a virtual table given a list of IDs.

[974] Fix | Delete

*

[975] Fix | Delete

* @param array $ids Array of IDs.

[976] Fix | Delete

* @param array $id_field Name of the ID field.

[977] Fix | Delete

* @param array $other_values Other values that must be contained in the virtual table.

[978] Fix | Delete

* @return array

[979] Fix | Delete

*/

[980] Fix | Delete

protected function get_ids_table( $ids, $id_field, $other_values = array() ) {

[981] Fix | Delete

global $wpdb;

[982] Fix | Delete

$selects = array();

[983] Fix | Delete

foreach ( $ids as $id ) {

[984] Fix | Delete

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

[985] Fix | Delete

$new_select = $wpdb->prepare( "SELECT %s AS {$id_field}", $id );

[986] Fix | Delete

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

[987] Fix | Delete

$new_select .= $wpdb->prepare( ", %s AS {$key}", $value );

[988] Fix | Delete

}

[989] Fix | Delete

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

[990] Fix | Delete

array_push( $selects, $new_select );

[991] Fix | Delete

}

[992] Fix | Delete

return join( ' UNION ', $selects );

[993] Fix | Delete

}

[994] Fix | Delete

[995] Fix | Delete

/**

[996] Fix | Delete

* Returns a comma separated list of the fields in the `query_args`, if there aren't, returns `report_columns` keys.

[997] Fix | Delete

*

[998] Fix | Delete

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

[999] Fix | Delete