Installer.php
<?php
namespace Automattic\WooCommerce\Blocks;
class Installer {
public function init() {
add_action( 'admin_init', array( $this, 'install' ) );
add_filter( 'woocommerce_create_pages', array( $this, 'create_pages' ) );
}
public function install() {
$this->maybe_create_tables();
}
public function create_pages( $pages ) {
if ( '<!-- wp:shortcode -->[woocommerce_cart]<!-- /wp:shortcode -->' === ( $pages['cart']['content'] ?? null ) ) {
$pages['cart']['content'] = '<!-- wp:woocommerce/classic-shortcode {"shortcode":"cart"} /-->';
}
if ( '<!-- wp:shortcode -->[woocommerce_checkout]<!-- /wp:shortcode -->' === ( $pages['checkout']['content'] ?? null ) ) {
$pages['checkout']['content'] = '<!-- wp:woocommerce/classic-shortcode {"shortcode":"checkout"} /-->';
}
return $pages;
}
public function maybe_create_tables() {
global $wpdb;
$schema_version = 260;
$db_schema_version = (int) get_option( 'wc_blocks_db_schema_version', 0 );
if ( $db_schema_version >= $schema_version && 0 !== $db_schema_version ) {
return;
}
$show_errors = $wpdb->hide_errors();
$table_name = $wpdb->prefix . 'wc_reserved_stock';
$collate = $wpdb->has_cap( 'collation' ) ? $wpdb->get_charset_collate() : '';
$exists = $this->maybe_create_table(
$wpdb->prefix . 'wc_reserved_stock',
"
CREATE TABLE {$wpdb->prefix}wc_reserved_stock (
`order_id` bigint(20) NOT NULL,
`product_id` bigint(20) NOT NULL,
`stock_quantity` double NOT NULL DEFAULT 0,
`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`order_id`, `product_id`)
) $collate;
"
);
if ( $show_errors ) {
$wpdb->show_errors();
}
if ( ! $exists ) {
return $this->add_create_table_notice( $table_name );
}
update_option( 'wc_blocks_db_schema_version', $schema_version );
}
protected function maybe_create_table( $table_name, $create_sql ) {
global $wpdb;
if ( in_array( $table_name, $wpdb->get_col( $wpdb->prepare( 'SHOW TABLES LIKE %s', $table_name ), 0 ), true ) ) {
return true;
}
$wpdb->query( $create_sql );
return in_array( $table_name, $wpdb->get_col( $wpdb->prepare( 'SHOW TABLES LIKE %s', $table_name ), 0 ), true );
}
protected function add_create_table_notice( $table_name ) {
add_action(
'admin_notices',
function() use ( $table_name ) {
echo '<div class="error"><p>';
printf(
esc_html__( 'WooCommerce %1$s table creation failed. Does the %2$s user have CREATE privileges on the %3$s database?', 'woocommerce' ),
'<code>' . esc_html( $table_name ) . '</code>',
'<code>' . esc_html( DB_USER ) . '</code>',
'<code>' . esc_html( DB_NAME ) . '</code>'
);
echo '</p></div>';
}
);
}
}