Migration_37.php — Independent Analytics – WordPress Analytics Plugin 2.15.0

independent-analytics / IAWP / Migrations / Migration_37.php

independent-analytics / IAWP / Migrations Last commit date

Migration_37.php

44 lines

1	<?php
2
3	namespace IAWP\Migrations;
4
5	use IAWP\Query;
6	/** @internal */
7	class Migration_37 extends \IAWP\Migrations\Step_Migration
8	{
9	/**
10	* @return int
11	*/
12	protected function database_version() : int
13	{
14	return 37;
15	}
16	/**
17	* @return array
18	*/
19	protected function queries() : array
20	{
21	return [$this->remove_duplicate_woocommerce_orders(), $this->remove_duplicate_surecart_orders(), $this->add_unique_index_for_woocommerce_order_id(), $this->add_unique_index_for_surecart_order_id()];
22	}
23	private function remove_duplicate_woocommerce_orders() : string
24	{
25	$orders_table = Query::get_table_name(Query::ORDERS);
26	return "\n DELETE orders\n FROM\n {$orders_table} orders\n JOIN (\n SELECT\n woocommerce_order_id,\n MIN(order_id) AS first_order_id\n FROM\n {$orders_table}\n GROUP BY\n woocommerce_order_id\n ) first_orders ON orders.woocommerce_order_id = first_orders.woocommerce_order_id\n AND orders.order_id > first_orders.first_order_id; \n ";
27	}
28	private function remove_duplicate_surecart_orders() : string
29	{
30	$orders_table = Query::get_table_name(Query::ORDERS);
31	return "\n DELETE orders\n FROM\n {$orders_table} orders\n JOIN (\n SELECT\n surecart_order_id,\n MIN(order_id) AS first_order_id\n FROM\n {$orders_table}\n GROUP BY\n surecart_order_id\n ) first_orders ON orders.surecart_order_id = first_orders.surecart_order_id\n AND orders.order_id > first_orders.first_order_id;\n ";
32	}
33	private function add_unique_index_for_woocommerce_order_id() : string
34	{
35	$orders_table = Query::get_table_name(Query::ORDERS);
36	return "\n CREATE UNIQUE INDEX orders_woocommerce_order_id_index ON {$orders_table} (woocommerce_order_id)\n ";
37	}
38	private function add_unique_index_for_surecart_order_id() : string
39	{
40	$orders_table = Query::get_table_name(Query::ORDERS);
41	return "\n CREATE UNIQUE INDEX orders_surecart_order_id_index ON {$orders_table} (surecart_order_id)\n ";
42	}
43	}
44