vendor/boldr/shop-bundle/migrations/Version1_15_4.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Boldr\Shop\ShopBundle\Migrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Boldr\Cms\CmsBundle\BoldrCmsMigration;
  10. final class Version1_15_4 extends BoldrCmsMigration
  11. {
  12.     public function getBundle(): string { return 'boldr/shop-bundle'; }
  13.     public function getVersion(): ?string { return '1.15.4'; }
  15.     public function up(Schema $schema): void
  16.     {
  17.         $this->addSql('ALTER TABLE shop_order ADD item_count INT UNSIGNED NOT NULL, ADD total_price DOUBLE PRECISION NULL');
  18.         $this->addSql('UPDATE shop_order o SET o.item_count = (SELECT COALESCE(SUM(oi.quantity), 0) FROM shop_order_item oi WHERE oi.order_id = o.id), o.total_price = (SELECT SUM(oii.total_price) FROM shop_invoice_item oii WHERE oii.order_id = o.id)');
  19.         $this->addSql('CREATE INDEX idx_state ON shop_order (state)');
  20.     }
  21.     
  22. }