<?php

[0] Fix | Delete

namespace Automattic\WooCommerce\Blocks;

[1] Fix | Delete

[2] Fix | Delete

/**

[3] Fix | Delete

* Installer class.

[4] Fix | Delete

* Handles installation of Blocks plugin dependencies.

[5] Fix | Delete

*

[6] Fix | Delete

* @internal

[7] Fix | Delete

*/

[8] Fix | Delete

class Installer {

[9] Fix | Delete

/**

[10] Fix | Delete

* Initialize class features.

[11] Fix | Delete

*/

[12] Fix | Delete

public function init() {

[13] Fix | Delete

add_action( 'admin_init', array( $this, 'install' ) );

[14] Fix | Delete

add_filter( 'woocommerce_create_pages', array( $this, 'create_pages' ) );

[15] Fix | Delete

}

[16] Fix | Delete

[17] Fix | Delete

/**

[18] Fix | Delete

* Installation tasks ran on admin_init callback.

[19] Fix | Delete

*/

[20] Fix | Delete

public function install() {

[21] Fix | Delete

$this->maybe_create_tables();

[22] Fix | Delete

}

[23] Fix | Delete

[24] Fix | Delete

/**

[25] Fix | Delete

* Modifies default page content replacing it with classic shortcode block.

[26] Fix | Delete

* We check for shortcode as default because after WooCommerce 8.3, block-based checkout is used by default.

[27] Fix | Delete

* This only runs on Tools > Create Pages as the filter is not applied on WooCommerce plugin activation.

[28] Fix | Delete

*

[29] Fix | Delete

* @param array $pages Default pages.

[30] Fix | Delete

* @return array

[31] Fix | Delete

*/

[32] Fix | Delete

public function create_pages( $pages ) {

[33] Fix | Delete

[34] Fix | Delete

if ( '<!-- wp:shortcode -->[woocommerce_cart]<!-- /wp:shortcode -->' === ( $pages['cart']['content'] ?? null ) ) {

[35] Fix | Delete

$pages['cart']['content'] = '<!-- wp:woocommerce/classic-shortcode {"shortcode":"cart"} /-->';

[36] Fix | Delete

}

[37] Fix | Delete

[38] Fix | Delete

if ( '<!-- wp:shortcode -->[woocommerce_checkout]<!-- /wp:shortcode -->' === ( $pages['checkout']['content'] ?? null ) ) {

[39] Fix | Delete

$pages['checkout']['content'] = '<!-- wp:woocommerce/classic-shortcode {"shortcode":"checkout"} /-->';

[40] Fix | Delete

}

[41] Fix | Delete

[42] Fix | Delete

return $pages;

[43] Fix | Delete

}

[44] Fix | Delete

[45] Fix | Delete

/**

[46] Fix | Delete

* Set up the database tables which the plugin needs to function.

[47] Fix | Delete

*/

[48] Fix | Delete

public function maybe_create_tables() {

[49] Fix | Delete

global $wpdb;

[50] Fix | Delete

[51] Fix | Delete

$schema_version = 260;

[52] Fix | Delete

$db_schema_version = (int) get_option( 'wc_blocks_db_schema_version', 0 );

[53] Fix | Delete

[54] Fix | Delete

if ( $db_schema_version >= $schema_version && 0 !== $db_schema_version ) {

[55] Fix | Delete

return;

[56] Fix | Delete

}

[57] Fix | Delete

[58] Fix | Delete

$show_errors = $wpdb->hide_errors();

[59] Fix | Delete

$table_name = $wpdb->prefix . 'wc_reserved_stock';

[60] Fix | Delete

$collate = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : '';

[61] Fix | Delete

$exists = $this->maybe_create_table(

[62] Fix | Delete

$wpdb->prefix . 'wc_reserved_stock',

[63] Fix | Delete

"

[64] Fix | Delete

CREATE TABLE {$wpdb->prefix}wc_reserved_stock (

[65] Fix | Delete

`order_id` bigint(20) NOT NULL,

[66] Fix | Delete

`product_id` bigint(20) NOT NULL,

[67] Fix | Delete

`stock_quantity` double NOT NULL DEFAULT 0,

[68] Fix | Delete

`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

[69] Fix | Delete

`expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

[70] Fix | Delete

PRIMARY KEY (`order_id`, `product_id`)

[71] Fix | Delete

) $collate;

[72] Fix | Delete

"

[73] Fix | Delete

);

[74] Fix | Delete

[75] Fix | Delete

if ( $show_errors ) {

[76] Fix | Delete

$wpdb->show_errors();

[77] Fix | Delete

}

[78] Fix | Delete

[79] Fix | Delete

if ( ! $exists ) {

[80] Fix | Delete

return $this->add_create_table_notice( $table_name );

[81] Fix | Delete

}

[82] Fix | Delete

[83] Fix | Delete

// Update succeeded. This is only updated when successful and validated.

[84] Fix | Delete

// $schema_version should be incremented when changes to schema are made within this method.

[85] Fix | Delete

update_option( 'wc_blocks_db_schema_version', $schema_version );

[86] Fix | Delete

}

[87] Fix | Delete

[88] Fix | Delete

/**

[89] Fix | Delete

* Create database table, if it doesn't already exist.

[90] Fix | Delete

*

[91] Fix | Delete

* Based on admin/install-helper.php maybe_create_table function.

[92] Fix | Delete

*

[93] Fix | Delete

* @param string $table_name Database table name.

[94] Fix | Delete

* @param string $create_sql Create database table SQL.

[95] Fix | Delete

* @return bool False on error, true if already exists or success.

[96] Fix | Delete

*/

[97] Fix | Delete

protected function maybe_create_table( $table_name, $create_sql ) {

[98] Fix | Delete

global $wpdb;

[99] Fix | Delete

[100] Fix | Delete

if ( in_array( $table_name, $wpdb->get_col( $wpdb->prepare( 'SHOW TABLES LIKE %s', $table_name ), 0 ), true ) ) {

[101] Fix | Delete

return true;

[102] Fix | Delete

}

[103] Fix | Delete

[104] Fix | Delete

$wpdb->query( $create_sql ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[105] Fix | Delete

[106] Fix | Delete

return in_array( $table_name, $wpdb->get_col( $wpdb->prepare( 'SHOW TABLES LIKE %s', $table_name ), 0 ), true );

[107] Fix | Delete

}

[108] Fix | Delete

[109] Fix | Delete

/**

[110] Fix | Delete

* Add a notice if table creation fails.

[111] Fix | Delete

*

[112] Fix | Delete

* @param string $table_name Name of the missing table.

[113] Fix | Delete

*/

[114] Fix | Delete

protected function add_create_table_notice( $table_name ) {

[115] Fix | Delete

add_action(

[116] Fix | Delete

'admin_notices',

[117] Fix | Delete

function() use ( $table_name ) {

[118] Fix | Delete

echo '<div class="error"><p>';

[119] Fix | Delete

printf(

[120] Fix | Delete

/* translators: %1$s table name, %2$s database user, %3$s database name. */

[121] Fix | Delete

esc_html__( 'WooCommerce %1$s table creation failed. Does the %2$s user have CREATE privileges on the %3$s database?', 'woocommerce' ),

[122] Fix | Delete

'<code>' . esc_html( $table_name ) . '</code>',

[123] Fix | Delete

'<code>' . esc_html( DB_USER ) . '</code>',

[124] Fix | Delete

'<code>' . esc_html( DB_NAME ) . '</code>'

[125] Fix | Delete

);

[126] Fix | Delete

echo '</p></div>';

[127] Fix | Delete

}

[128] Fix | Delete

);

[129] Fix | Delete

}

[130] Fix | Delete

}

[131] Fix | Delete

[132] Fix | Delete