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

[500] Fix | Delete

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

[501] Fix | Delete

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

[502] Fix | Delete

$record_arr = array();

[503] Fix | Delete

$record_arr['time_interval'] = $time_id;

[504] Fix | Delete

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

[505] Fix | Delete

$record_arr['date_end'] = $interval_end;

[506] Fix | Delete

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

[507] Fix | Delete

}

[508] Fix | Delete

$start_datetime = $next_start;

[509] Fix | Delete

}

[510] Fix | Delete

return $data;

[511] Fix | Delete

}

[512] Fix | Delete

[513] Fix | Delete

/**

[514] Fix | Delete

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

[515] Fix | Delete

* uses default from $defaults.

[516] Fix | Delete

*

[517] Fix | Delete

* @param array $query_args Array of query arguments.

[518] Fix | Delete

* @param array $defaults Array of default values.

[519] Fix | Delete

*/

[520] Fix | Delete

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

[521] Fix | Delete

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

[522] Fix | Delete

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

[523] Fix | Delete

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

[524] Fix | Delete

// Assume that unspecified timezone is a local timezone.

[525] Fix | Delete

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

[526] Fix | Delete

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

[527] Fix | Delete

$datetime->setTimezone( $local_tz );

[528] Fix | Delete

$query_args[ $query_arg_key ] = $datetime;

[529] Fix | Delete

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

[530] Fix | Delete

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

[531] Fix | Delete

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

[532] Fix | Delete

} else {

[533] Fix | Delete

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

[534] Fix | Delete

}

[535] Fix | Delete

}

[536] Fix | Delete

}

[537] Fix | Delete

[538] Fix | Delete

/**

[539] Fix | Delete

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

[540] Fix | Delete

*

[541] Fix | Delete

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

[542] Fix | Delete

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

[543] Fix | Delete

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

[544] Fix | Delete

* @param int $db_interval_count Database interval count.

[545] Fix | Delete

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

[546] Fix | Delete

* @param string $order_by Order by field.

[547] Fix | Delete

* @param string $order ASC or DESC.

[548] Fix | Delete

*/

[549] Fix | Delete

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

[550] Fix | Delete

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

[551] Fix | Delete

$offset = 0;

[552] Fix | Delete

} else {

[553] Fix | Delete

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

[554] Fix | Delete

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

[555] Fix | Delete

} else {

[556] Fix | Delete

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

[557] Fix | Delete

}

[558] Fix | Delete

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

[559] Fix | Delete

}

[560] Fix | Delete

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

[561] Fix | Delete

if ( $count < 0 ) {

[562] Fix | Delete

$count = 0;

[563] Fix | Delete

} elseif ( $count > $items_per_page ) {

[564] Fix | Delete

$count = $items_per_page;

[565] Fix | Delete

}

[566] Fix | Delete

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

[567] Fix | Delete

}

[568] Fix | Delete

[569] Fix | Delete

/**

[570] Fix | Delete

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

[571] Fix | Delete

*

[572] Fix | Delete

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

[573] Fix | Delete

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

[574] Fix | Delete

* @param int $page_no Page number.

[575] Fix | Delete

*

[576] Fix | Delete

* @return float|int

[577] Fix | Delete

*/

[578] Fix | Delete

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

[579] Fix | Delete

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

[580] Fix | Delete

if ( $page_no < $total_pages ) {

[581] Fix | Delete

return $items_per_page;

[582] Fix | Delete

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

[583] Fix | Delete

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

[584] Fix | Delete

} else {

[585] Fix | Delete

return 0;

[586] Fix | Delete

}

[587] Fix | Delete

}

[588] Fix | Delete

[589] Fix | Delete

/**

[590] Fix | Delete

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

[591] Fix | Delete

*

[592] Fix | Delete

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

[593] Fix | Delete

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

[594] Fix | Delete

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

[595] Fix | Delete

* @param int $page_no Page number.

[596] Fix | Delete

* @param string $order asc or desc.

[597] Fix | Delete

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

[598] Fix | Delete

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

[599] Fix | Delete

*

[600] Fix | Delete

* @return bool

[601] Fix | Delete

*/

[602] Fix | Delete

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

[603] Fix | Delete

if ( $expected_interval_count <= $db_records ) {

[604] Fix | Delete

return false;

[605] Fix | Delete

}

[606] Fix | Delete

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

[607] Fix | Delete

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

[608] Fix | Delete

return $intervals_count < $expected_intervals_on_page;

[609] Fix | Delete

}

[610] Fix | Delete

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

[611] Fix | Delete

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

[612] Fix | Delete

}

[613] Fix | Delete

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

[614] Fix | Delete

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

[615] Fix | Delete

}

[616] Fix | Delete

// Invalid ordering.

[617] Fix | Delete

return false;

[618] Fix | Delete

}

[619] Fix | Delete

[620] Fix | Delete

/**

[621] Fix | Delete

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

[622] Fix | Delete

*

[623] Fix | Delete

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

[624] Fix | Delete

* to fetch correct records.

[625] Fix | Delete

*

[626] Fix | Delete

* @param array $query_args Query arguments.

[627] Fix | Delete

* @param int $db_interval_count Database interval count.

[628] Fix | Delete

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

[629] Fix | Delete

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

[630] Fix | Delete

*/

[631] Fix | Delete

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

[632] Fix | Delete

if ( $db_interval_count === $expected_interval_count ) {

[633] Fix | Delete

return;

[634] Fix | Delete

}

[635] Fix | Delete

[636] Fix | Delete

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

[637] Fix | Delete

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

[638] Fix | Delete

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

[639] Fix | Delete

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

[640] Fix | Delete

// records are missing from the db.

[641] Fix | Delete

$start_iteration = 0;

[642] Fix | Delete

$end_iteration = 0;

[643] Fix | Delete

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

[644] Fix | Delete

// ORDER BY date ASC.

[645] Fix | Delete

$new_start_date = $query_args['after'];

[646] Fix | Delete

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

[647] Fix | Delete

$latest_end_date = $query_args['before'];

[648] Fix | Delete

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

[649] Fix | Delete

if ( $new_start_date > $latest_end_date ) {

[650] Fix | Delete

$new_start_date = $latest_end_date;

[651] Fix | Delete

$start_iteration = 0;

[652] Fix | Delete

break;

[653] Fix | Delete

}

[654] Fix | Delete

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

[655] Fix | Delete

$start_iteration ++;

[656] Fix | Delete

}

[657] Fix | Delete

[658] Fix | Delete

$new_end_date = clone $new_start_date;

[659] Fix | Delete

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

[660] Fix | Delete

if ( $new_end_date > $latest_end_date ) {

[661] Fix | Delete

break;

[662] Fix | Delete

}

[663] Fix | Delete

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

[664] Fix | Delete

$end_iteration ++;

[665] Fix | Delete

}

[666] Fix | Delete

if ( $new_end_date > $latest_end_date ) {

[667] Fix | Delete

$new_end_date = $latest_end_date;

[668] Fix | Delete

$end_iteration = 0;

[669] Fix | Delete

}

[670] Fix | Delete

if ( $end_iteration ) {

[671] Fix | Delete

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

[672] Fix | Delete

$new_end_date->setTimestamp( $new_end_date_timestamp );

[673] Fix | Delete

}

[674] Fix | Delete

} else {

[675] Fix | Delete

// ORDER BY date DESC.

[676] Fix | Delete

$new_end_date = $query_args['before'];

[677] Fix | Delete

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

[678] Fix | Delete

$earliest_start_date = $query_args['after'];

[679] Fix | Delete

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

[680] Fix | Delete

if ( $new_end_date < $earliest_start_date ) {

[681] Fix | Delete

$new_end_date = $earliest_start_date;

[682] Fix | Delete

$end_iteration = 0;

[683] Fix | Delete

break;

[684] Fix | Delete

}

[685] Fix | Delete

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

[686] Fix | Delete

$end_iteration ++;

[687] Fix | Delete

}

[688] Fix | Delete

[689] Fix | Delete

$new_start_date = clone $new_end_date;

[690] Fix | Delete

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

[691] Fix | Delete

if ( $new_start_date < $earliest_start_date ) {

[692] Fix | Delete

break;

[693] Fix | Delete

}

[694] Fix | Delete

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

[695] Fix | Delete

$start_iteration ++;

[696] Fix | Delete

}

[697] Fix | Delete

if ( $new_start_date < $earliest_start_date ) {

[698] Fix | Delete

$new_start_date = $earliest_start_date;

[699] Fix | Delete

$start_iteration = 0;

[700] Fix | Delete

}

[701] Fix | Delete

if ( $start_iteration ) {

[702] Fix | Delete

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

[703] Fix | Delete

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

[704] Fix | Delete

$new_start_date->setTimestamp( $new_start_date_timestamp );

[705] Fix | Delete

}

[706] Fix | Delete

}

[707] Fix | Delete

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

[708] Fix | Delete

$query_args['adj_after'] = $new_start_date;

[709] Fix | Delete

$query_args['adj_before'] = $new_end_date;

[710] Fix | Delete

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

[711] Fix | Delete

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

[712] Fix | Delete

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

[713] Fix | Delete

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

[714] Fix | Delete

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

[715] Fix | Delete

$this->clear_sql_clause( 'limit' );

[716] Fix | Delete

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

[717] Fix | Delete

} else {

[718] Fix | Delete

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

[719] Fix | Delete

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

[720] Fix | Delete

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

[721] Fix | Delete

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

[722] Fix | Delete

if ( $count < 0 ) {

[723] Fix | Delete

$count = 0;

[724] Fix | Delete

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

[725] Fix | Delete

$count = $params['per_page'];

[726] Fix | Delete

}

[727] Fix | Delete

[728] Fix | Delete

$this->clear_sql_clause( 'limit' );

[729] Fix | Delete

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

[730] Fix | Delete

}

[731] Fix | Delete

// Otherwise no change in limit clause.

[732] Fix | Delete

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

[733] Fix | Delete

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

[734] Fix | Delete

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

[735] Fix | Delete

}

[736] Fix | Delete

}

[737] Fix | Delete

[738] Fix | Delete

/**

[739] Fix | Delete

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

[740] Fix | Delete

*

[741] Fix | Delete

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

[742] Fix | Delete

* @return array|WP_Error

[743] Fix | Delete

*/

[744] Fix | Delete

protected function cast_numbers( $array ) {

[745] Fix | Delete

$retyped_array = array();

[746] Fix | Delete

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

[747] Fix | Delete

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

[748] Fix | Delete

if ( is_array( $value ) ) {

[749] Fix | Delete

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

[750] Fix | Delete

}

[751] Fix | Delete

[752] Fix | Delete

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

[753] Fix | Delete

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

[754] Fix | Delete

} else {

[755] Fix | Delete

$retyped_array[ $column_name ] = $value;

[756] Fix | Delete

}

[757] Fix | Delete

}

[758] Fix | Delete

return $retyped_array;

[759] Fix | Delete

}

[760] Fix | Delete

[761] Fix | Delete

/**

[762] Fix | Delete

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

[763] Fix | Delete

*

[764] Fix | Delete

* @param array $query_args User-supplied options.

[765] Fix | Delete

* @return string

[766] Fix | Delete

*/

[767] Fix | Delete

protected function selected_columns( $query_args ) {

[768] Fix | Delete

$selections = $this->report_columns;

[769] Fix | Delete

[770] Fix | Delete

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

[771] Fix | Delete

$keep = array();

[772] Fix | Delete

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

[773] Fix | Delete

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

[774] Fix | Delete

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

[775] Fix | Delete

}

[776] Fix | Delete

}

[777] Fix | Delete

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

[778] Fix | Delete

} else {

[779] Fix | Delete

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

[780] Fix | Delete

}

[781] Fix | Delete

return $selections;

[782] Fix | Delete

}

[783] Fix | Delete

[784] Fix | Delete

/**

[785] Fix | Delete

* Get the excluded order statuses used when calculating reports.

[786] Fix | Delete

*

[787] Fix | Delete

* @return array

[788] Fix | Delete

*/

[789] Fix | Delete

protected static function get_excluded_report_order_statuses() {

[790] Fix | Delete

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

[791] Fix | Delete

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

[792] Fix | Delete

return apply_filters( 'woocommerce_analytics_excluded_order_statuses', $excluded_statuses );

[793] Fix | Delete

}

[794] Fix | Delete

[795] Fix | Delete

/**

[796] Fix | Delete

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

[797] Fix | Delete

*

[798] Fix | Delete

* @param string $status Order status.

[799] Fix | Delete

* @return string

[800] Fix | Delete

*/

[801] Fix | Delete

protected static function normalize_order_status( $status ) {

[802] Fix | Delete

$status = trim( $status );

[803] Fix | Delete

return 'wc-' . $status;

[804] Fix | Delete

}

[805] Fix | Delete

[806] Fix | Delete

/**

[807] Fix | Delete

* Normalizes order_by clause to match to SQL query.

[808] Fix | Delete

*

[809] Fix | Delete

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

[810] Fix | Delete

* @return string

[811] Fix | Delete

*/

[812] Fix | Delete

protected function normalize_order_by( $order_by ) {

[813] Fix | Delete

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

[814] Fix | Delete

return 'time_interval';

[815] Fix | Delete

}

[816] Fix | Delete

[817] Fix | Delete

return $order_by;

[818] Fix | Delete

}

[819] Fix | Delete

[820] Fix | Delete

/**

[821] Fix | Delete

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

[822] Fix | Delete

*

[823] 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].

[824] Fix | Delete

*

[825] Fix | Delete

* @param DateTime $start_datetime Start date.

[826] Fix | Delete

* @param DateTime $end_datetime End date.

[827] Fix | Delete

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

[828] Fix | Delete

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

[829] Fix | Delete

*/

[830] Fix | Delete

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

[831] Fix | Delete

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

[832] Fix | Delete

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

[833] Fix | Delete

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

[834] Fix | Delete

[835] Fix | Delete

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

[836] Fix | Delete

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

[837] Fix | Delete

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

[838] Fix | Delete

$prev_start->setTimestamp( $prev_start_timestamp );

[839] Fix | Delete

if ( $start_datetime ) {

[840] Fix | Delete

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

[841] Fix | Delete

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

[842] Fix | Delete

} else {

[843] Fix | Delete

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

[844] Fix | Delete

}

[845] Fix | Delete

[846] Fix | Delete

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

[847] Fix | Delete

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

[848] Fix | Delete

$next_end->setTimestamp( $next_end_timestamp );

[849] Fix | Delete

if ( $end_datetime ) {

[850] Fix | Delete

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

[851] Fix | Delete

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

[852] Fix | Delete

} else {

[853] Fix | Delete

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

[854] Fix | Delete

}

[855] Fix | Delete

[856] Fix | Delete

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

[857] Fix | Delete

}

[858] Fix | Delete

}

[859] Fix | Delete

[860] Fix | Delete

/**

[861] Fix | Delete

* Change structure of intervals to form a correct response.

[862] Fix | Delete

*

[863] Fix | Delete

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

[864] Fix | Delete

*

[865] Fix | Delete

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

[866] Fix | Delete

*/

[867] Fix | Delete

protected function create_interval_subtotals( &$intervals ) {

[868] Fix | Delete

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

[869] Fix | Delete

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

[870] Fix | Delete

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

[871] Fix | Delete

// Move intervals result to subtotals object.

[872] Fix | Delete

$intervals[ $key ] = array(

[873] Fix | Delete

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

[874] Fix | Delete

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

[875] Fix | Delete

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

[876] Fix | Delete

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

[877] Fix | Delete

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

[878] Fix | Delete

);

[879] Fix | Delete

[880] Fix | Delete

unset( $interval['interval'] );

[881] Fix | Delete

unset( $interval['date_start'] );

[882] Fix | Delete

unset( $interval['date_end'] );

[883] Fix | Delete

unset( $interval['datetime_anchor'] );

[884] Fix | Delete

unset( $interval['time_interval'] );

[885] Fix | Delete

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

[886] Fix | Delete

}

[887] Fix | Delete

}

[888] Fix | Delete

[889] Fix | Delete

/**

[890] Fix | Delete

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

[891] Fix | Delete

*

[892] Fix | Delete

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

[893] Fix | Delete

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

[894] Fix | Delete

*/

[895] Fix | Delete

protected function add_time_period_sql_params( $query_args, $table_name ) {

[896] Fix | Delete

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

[897] Fix | Delete

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

[898] Fix | Delete

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

[899] Fix | Delete

}

[900] Fix | Delete

[901] Fix | Delete

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

[902] Fix | Delete

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

[903] Fix | Delete

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

[904] Fix | Delete

} else {

[905] Fix | Delete

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

[906] Fix | Delete

}

[907] Fix | Delete

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

[908] Fix | Delete

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

[909] Fix | Delete

} else {

[910] Fix | Delete

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

[911] Fix | Delete

}

[912] Fix | Delete

}

[913] Fix | Delete

[914] Fix | Delete

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

[915] Fix | Delete

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

[916] Fix | Delete

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

[917] Fix | Delete

} else {

[918] Fix | Delete

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

[919] Fix | Delete

}

[920] Fix | Delete

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

[921] Fix | Delete

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

[922] Fix | Delete

} else {

[923] Fix | Delete

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

[924] Fix | Delete

}

[925] Fix | Delete

}

[926] Fix | Delete

}

[927] Fix | Delete

[928] Fix | Delete

/**

[929] Fix | Delete

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

[930] Fix | Delete

*

[931] Fix | Delete

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

[932] Fix | Delete

* @return array

[933] Fix | Delete

*/

[934] Fix | Delete

protected function get_limit_sql_params( $query_args ) {

[935] Fix | Delete

global $wpdb;

[936] Fix | Delete

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

[937] Fix | Delete

[938] Fix | Delete

$this->clear_sql_clause( 'limit' );

[939] Fix | Delete

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

[940] Fix | Delete

return $params;

[941] Fix | Delete

}

[942] Fix | Delete

[943] Fix | Delete

/**

[944] Fix | Delete

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

[945] Fix | Delete

*

[946] Fix | Delete

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

[947] Fix | Delete

* @return array

[948] Fix | Delete

*/

[949] Fix | Delete

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

[950] Fix | Delete

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

[951] Fix | Delete

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

[952] Fix | Delete

} else {

[953] Fix | Delete

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

[954] Fix | Delete

}

[955] Fix | Delete

[956] Fix | Delete

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

[957] Fix | Delete

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

[958] Fix | Delete

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

[959] Fix | Delete

}

[960] Fix | Delete

[961] Fix | Delete

return $this->limit_parameters;

[962] Fix | Delete

}

[963] Fix | Delete

[964] Fix | Delete

/**

[965] Fix | Delete

* Generates a virtual table given a list of IDs.

[966] Fix | Delete

*

[967] Fix | Delete

* @param array $ids Array of IDs.

[968] Fix | Delete

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

[969] Fix | Delete

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

[970] Fix | Delete

* @return array

[971] Fix | Delete

*/

[972] Fix | Delete

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

[973] Fix | Delete

global $wpdb;

[974] Fix | Delete

$selects = array();

[975] Fix | Delete

foreach ( $ids as $id ) {

[976] Fix | Delete

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

[977] Fix | Delete

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

[978] Fix | Delete

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

[979] Fix | Delete

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

[980] Fix | Delete

}

[981] Fix | Delete

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

[982] Fix | Delete

array_push( $selects, $new_select );

[983] Fix | Delete

}

[984] Fix | Delete

return join( ' UNION ', $selects );

[985] Fix | Delete

}

[986] Fix | Delete

[987] Fix | Delete

/**

[988] Fix | Delete

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

[989] Fix | Delete

*

[990] Fix | Delete

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

[991] Fix | Delete

* @return array

[992] Fix | Delete

*/

[993] Fix | Delete

protected function get_fields( $query_args ) {

[994] Fix | Delete

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

[995] Fix | Delete

return $query_args['fields'];

[996] Fix | Delete

}

[997] Fix | Delete

return array_keys( $this->report_columns );

[998] Fix | Delete

}

[999] Fix | Delete