8889841cplugins/woocommerce/src/Database/Migrations/CustomOrderTable/PostToOrderOpTableMigrator.php000064400000007623150445211700035522 0ustar00home/clixcotz/gs.clix.co.tz/wp-contenttable_names = array( 'orders' => $wpdb->prefix . 'wc_orders', 'addresses' => $wpdb->prefix . 'wc_order_addresses', 'op_data' => $wpdb->prefix . 'wc_order_operational_data', 'meta' => $wpdb->prefix . 'wc_orders_meta', ); return array( 'source' => array( 'entity' => array( 'table_name' => $this->table_names['orders'], 'meta_rel_column' => 'id', 'destination_rel_column' => 'id', 'primary_key' => 'id', ), 'meta' => array( 'table_name' => $wpdb->postmeta, 'meta_key_column' => 'meta_key', 'meta_value_column' => 'meta_value', 'entity_id_column' => 'post_id', ), ), 'destination' => array( 'table_name' => $this->table_names['op_data'], 'source_rel_column' => 'order_id', 'primary_key' => 'id', 'primary_key_type' => 'int', ), ); } /** * Get columns config. * * @return \string[][] Config. */ protected function get_core_column_mapping(): array { return array( 'id' => array( 'type' => 'int', 'destination' => 'order_id', ), ); } /** * Get meta data config. * * @return \string[][] Config. */ public function get_meta_column_config(): array { return array( '_created_via' => array( 'type' => 'string', 'destination' => 'created_via', ), '_order_version' => array( 'type' => 'string', 'destination' => 'woocommerce_version', ), '_prices_include_tax' => array( 'type' => 'bool', 'destination' => 'prices_include_tax', ), '_recorded_coupon_usage_counts' => array( 'type' => 'bool', 'destination' => 'coupon_usages_are_counted', ), '_download_permissions_granted' => array( 'type' => 'bool', 'destination' => 'download_permission_granted', ), '_cart_hash' => array( 'type' => 'string', 'destination' => 'cart_hash', ), '_new_order_email_sent' => array( 'type' => 'bool', 'destination' => 'new_order_email_sent', ), '_order_key' => array( 'type' => 'string', 'destination' => 'order_key', ), '_order_stock_reduced' => array( 'type' => 'bool', 'destination' => 'order_stock_reduced', ), '_date_paid' => array( 'type' => 'date_epoch', 'destination' => 'date_paid_gmt', ), '_date_completed' => array( 'type' => 'date_epoch', 'destination' => 'date_completed_gmt', ), '_order_shipping_tax' => array( 'type' => 'decimal', 'destination' => 'shipping_tax_amount', ), '_order_shipping' => array( 'type' => 'decimal', 'destination' => 'shipping_total_amount', ), '_cart_discount_tax' => array( 'type' => 'decimal', 'destination' => 'discount_tax_amount', ), '_cart_discount' => array( 'type' => 'decimal', 'destination' => 'discount_total_amount', ), '_recorded_sales' => array( 'type' => 'bool', 'destination' => 'recorded_sales', ), ); } }