File manager - Edit - /home/verseaumee/blueversion/wp-content/plugins/give/includes/admin/tools/data/class-give-tools-reset-stats.php
Back
<?php /** * Recount income and stats * * This class handles batch processing of resetting donations and income stats. * * @subpackage Admin/Tools/Give_Tools_Reset_Stats * @copyright Copyright (c) 2016, GiveWP * @license https://opensource.org/licenses/gpl-license GNU Public License * @since 1.5 */ // Exit if accessed directly. if ( ! defined( 'ABSPATH' ) ) { exit; } /** * Give_Tools_Reset_Stats Class * * @since 1.5 */ class Give_Tools_Reset_Stats extends Give_Batch_Export { /** * Our export type. Used for export-type specific filters/actions * * @var string * @since 1.5 */ public $export_type = ''; /** * Allows for a non-form batch processing to be run. * * @since 1.5 * @var boolean */ public $is_void = true; /** * Sets the number of items to pull on each step * * @since 1.5 * @var integer */ public $per_step = 30; /** * Constructor. */ public function __construct( $_step = 1 ) { parent::__construct( $_step ); $this->is_writable = true; } /** * Get the Export Data * * @access public * @since 1.5 * @global object $wpdb Used to query the database using the WordPress * Database API * @return bool $data The data for the CSV file */ public function get_data() { global $wpdb; $items = $this->get_stored_data( 'give_temp_reset_ids' ); if ( ! is_array( $items ) ) { return false; } $offset = ( $this->step - 1 ) * $this->per_step; $step_items = array_slice( $items, $offset, $this->per_step ); if ( $step_items ) { $step_ids = [ 'customers' => [], 'forms' => [], 'other' => [], ]; foreach ( $step_items as $item ) { switch ( $item['type'] ) { case 'customer': $step_ids['customers'][] = $item['id']; break; case 'forms': $step_ids['give_forms'][] = $item['id']; break; default: $item_type = apply_filters( 'give_reset_item_type', 'other', $item ); $step_ids[ $item_type ][] = $item['id']; break; } } $sql = []; $meta_table = __give_v20_bc_table_details( 'form' ); foreach ( $step_ids as $type => $ids ) { if ( empty( $ids ) ) { continue; } $ids = implode( ',', $ids ); switch ( $type ) { case 'customers': // Delete all the Give related donor and its meta. $sql[] = "DELETE FROM {$wpdb->donors}"; $sql[] = "DELETE FROM {$wpdb->donormeta}"; break; case 'forms': $sql[] = "UPDATE {$meta_table['name']} SET meta_value = 0 WHERE meta_key = '_give_form_sales' AND {$meta_table['column']['id']} IN ($ids)"; $sql[] = "UPDATE {$meta_table['name']} SET meta_value = 0.00 WHERE meta_key = '_give_form_earnings' AND {$meta_table['column']['id']} IN ($ids)"; break; case 'other': // Delete main entries of forms and donations exists in posts table. $sql[] = "DELETE FROM {$wpdb->posts} WHERE id IN ($ids)"; // Delete all the meta rows of form exists in form meta table. $sql[] = "DELETE FROM {$wpdb->formmeta}"; // Delete all the meta rows of donation exists in donation meta table. $sql[] = "DELETE FROM {$wpdb->prefix}give_donationmeta"; // Delete all the Give related sequential ordering entries for donations. $sql[] = "DELETE FROM {$wpdb->prefix}give_sequential_ordering WHERE payment_id IN ($ids)"; // Delete all the Give related comments and its meta. $sql[] = "DELETE FROM {$wpdb->give_comments}"; $sql[] = "DELETE FROM {$wpdb->give_commentmeta}"; // Delete all the Give sessions data. $sql[] = "DELETE FROM {$wpdb->prefix}give_sessions"; // Delete Give related categories and tags data from taxonomy tables. $sql[] = $wpdb->prepare( " DELETE FROM $wpdb->terms WHERE $wpdb->terms.term_id IN ( SELECT $wpdb->term_taxonomy.term_id FROM $wpdb->term_taxonomy WHERE $wpdb->term_taxonomy.taxonomy = %s OR $wpdb->term_taxonomy.taxonomy = %s ) ", [ 'give_forms_category', 'give_forms_tag' ] ); $sql[] = $wpdb->prepare( " DELETE FROM $wpdb->term_taxonomy WHERE $wpdb->term_taxonomy.taxonomy = %s OR $wpdb->term_taxonomy.taxonomy = %s ", [ 'give_forms_category', 'give_forms_tag' ] ); break; } if ( ! in_array( $type, [ 'customers', 'forms', 'other' ] ) ) { // Allows other types of custom post types to filter on their own post_type // and add items to the query list, for the IDs found in their post type. $sql = apply_filters( "give_reset_add_queries_{$type}", $sql, $ids ); } } if ( is_array( $sql ) && count( $sql ) > 0 ) { foreach ( $sql as $query ) { $wpdb->query( $query ); } } return true; }// End if(). return false; } /** * Return the calculated completion percentage. * * @since 1.5 * @return int */ public function get_percentage_complete() { $items = $this->get_stored_data( 'give_temp_reset_ids' ); $total = count( $items ); $percentage = 100; if ( $total > 0 ) { $percentage = ( ( $this->per_step * $this->step ) / $total ) * 100; } if ( $percentage > 100 ) { $percentage = 100; } return $percentage; } /** * Set the properties specific to the payments export. * * @since 1.5 * * @param array $request The Form Data passed into the batch processing. */ public function set_properties( $request ) { } /** * Process a step * * @since 1.5 * @return bool */ public function process_step() { if ( ! $this->can_export() ) { wp_die( esc_html__( 'You do not have permission to reset data.', 'give' ), esc_html__( 'Error', 'give' ), [ 'response' => 403, ] ); } $had_data = $this->get_data(); if ( $had_data ) { $this->done = false; return true; } else { update_option( 'give_earnings_total', 0, false ); Give_Cache::delete( Give_Cache::get_key( 'give_estimated_monthly_stats' ) ); $this->delete_data( 'give_temp_reset_ids' ); $this->done = true; $this->message = esc_html__( 'Donation forms, revenue, donations counts, and logs successfully reset.', 'give' ); return false; } } /** * Headers */ public function headers() { give_ignore_user_abort(); } /** * Perform the export * * @access public * @since 1.5 * @return void */ public function export() { // Set headers $this->headers(); give_die(); } /** * Pre Fetch */ public function pre_fetch() { if ( $this->step == 1 ) { $this->delete_data( 'give_temp_reset_ids' ); } $items = get_option( 'give_temp_reset_ids', false ); if ( false === $items ) { $items = []; $give_types_for_reset = [ 'give_forms', 'give_payment' ]; $give_types_for_reset = apply_filters( 'give_reset_store_post_types', $give_types_for_reset ); $args = apply_filters( 'give_tools_reset_stats_total_args', [ 'post_type' => $give_types_for_reset, 'post_status' => 'any', 'posts_per_page' => - 1, ] ); $posts = get_posts( $args ); foreach ( $posts as $post ) { $items[] = [ 'id' => (int) $post->ID, 'type' => $post->post_type, ]; } $donor_args = [ 'number' => - 1, ]; $donors = Give()->donors->get_donors( $donor_args ); foreach ( $donors as $donor ) { $items[] = [ 'id' => (int) $donor->id, 'type' => 'customer', ]; } // Allow filtering of items to remove with an unassociative array for each item // The array contains the unique ID of the item, and a 'type' for you to use in the execution of the get_data method $items = apply_filters( 'give_reset_items', $items ); $this->store_data( 'give_temp_reset_ids', $items ); }// End if(). } /** * Given a key, get the information from the Database Directly. * * @since 1.5 * * @param string $key The option_name * * @return mixed Returns the data from the database. */ private function get_stored_data( $key ) { global $wpdb; $value = $wpdb->get_var( $wpdb->prepare( "SELECT option_value FROM $wpdb->options WHERE option_name = %s", $key ) ); if ( empty( $value ) ) { return false; } $maybe_json = json_decode( $value ); if ( ! is_null( $maybe_json ) ) { $value = json_decode( $value, true ); } return (array) $value; } /** * Give a key, store the value. * * @since 1.5 * * @param string $key The option_name. * @param mixed $value The value to store. * * @return void */ private function store_data( $key, $value ) { global $wpdb; $value = is_array( $value ) ? wp_json_encode( $value ) : esc_attr( $value ); $data = [ 'option_name' => $key, 'option_value' => $value, 'autoload' => 'no', ]; $formats = [ '%s', '%s', '%s', ]; $wpdb->replace( $wpdb->options, $data, $formats ); } /** * Delete an option * * @since 1.5 * * @param string $key The option_name to delete * * @return void */ private function delete_data( $key ) { global $wpdb; $wpdb->delete( $wpdb->options, [ 'option_name' => $key, ] ); } /** * Unset the properties specific to the donors export. * * @since 2.3.0 * * @param array $request * @param Give_Batch_Export $export */ public function unset_properties( $request, $export ) { if ( $export->done ) { // Delete all the donation ids. $this->delete_data( 'give_temp_reset_ids' ); } } }
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings