ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / caimegroup.com / wp-content / plugins / mailpoet / lib / Migrations / App

<?php declare(strict_types = 1);

namespace MailPoet\Migrations\App;

if (!defined('ABSPATH')) exit;

use MailPoet\Entities\StatisticsWooCommercePurchaseEntity;
use MailPoet\Migrations\Db\Migration_20230824_054259_Db;
use MailPoet\Migrator\AppMigration;
use MailPoet\WooCommerce\Helper;

class Migration_20230825_093531_App extends AppMigration {
  const DEFAULT_STATUS = Migration_20230824_054259_Db::DEFAULT_STATUS;

public function run(): void {

$wooCommerceHelper = $this->container->get(Helper::class);

// If Woo is not active and the table doesn't exist, we can skip this migration
    if (!$wooCommerceHelper->isWooCommerceActive() && !$this->tableExists()) {
      return;
    }

$wooCommerceHelper->isWooCommerceCustomOrdersTableEnabled() ?
      $this->populateStatusColumnUsingHpos() : $this->populateStatusColumnUsingPost();
  }

private function populateStatusColumnUsingHpos(): void {
    global $wpdb;

$revenueTable = esc_sql($this->getTableName());
    $sql = "update " . $revenueTable . " as rev, " . $wpdb->prefix . "wc_orders as wc set rev.status=TRIM(Leading 'wc-' FROM wc.status) where wc.id = rev.order_id AND rev.status='" . self::DEFAULT_STATUS . "'";
    $wpdb->query($sql);
  }

private function populateStatusColumnUsingPost(): void {
    global $wpdb;

$revenueTable = esc_sql($this->getTableName());
    $sql = "update " . $revenueTable . " as rev, " . $wpdb->posts . " as wc set rev.status=TRIM(Leading 'wc-' FROM wc.post_status) where wc.id = rev.order_id AND rev.status='" . self::DEFAULT_STATUS . "'";
    $wpdb->query($sql);
  }

private function getTableName(): string {
    return $this->entityManager->getClassMetadata(StatisticsWooCommercePurchaseEntity::class)->getTableName();
  }

private function tableExists(): bool {
    global $wpdb;

$revenueTable = $this->getTableName();
    $query = $wpdb->prepare('SHOW TABLES LIKE %s', $wpdb->esc_like($revenueTable));

return $wpdb->get_var($query) === $revenueTable;
  }
}

[-] index.php [edit]
[+] ..
[-] Migration_20230825_093531_App.php [edit]
[-] Migration_20240322_110443_App.php [edit]
[-] Migration_20230419_080000.php [edit]
[-] Migration_20230712_180341.php [edit]
[-] Migration_20221028_105818_App.php [edit]
[-] Migration_20240207_105912_App.php [edit]
[-] Migration_20230109_144830.php [edit]
[-] Migration_20231128_120355_App.php [edit]
[-] Migration_20240202_130053_App.php [edit]
[-] Migration_20230425_211517.php [edit]
[-] Migration_20230803_200413_App.php [edit]
[-] Migration_20230131_121621.php [edit]