migrations/Version20210721054416.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20210702054416 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  23.         $this->addSql('CREATE TABLE order_shipping_vehicle_feature (order_shipping_id INT NOT NULL, vehicle_feature_id INT NOT NULL, INDEX IDX_57FFB79253358C7E (order_shipping_id), INDEX IDX_57FFB792E57637E4 (vehicle_feature_id), PRIMARY KEY(order_shipping_id, vehicle_feature_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24.         $this->addSql('ALTER TABLE order_shipping_vehicle_feature ADD CONSTRAINT FK_57FFB79253358C7E FOREIGN KEY (order_shipping_id) REFERENCES order_shipping (id) ON DELETE CASCADE');
  25.         $this->addSql('ALTER TABLE order_shipping_vehicle_feature ADD CONSTRAINT FK_57FFB792E57637E4 FOREIGN KEY (vehicle_feature_id) REFERENCES vehicle_feature (id) ON DELETE CASCADE');
  26.         $this->addSql('DROP TABLE order_vehicle_feature');
  28.         $this->addSql('ALTER TABLE order_shipping ADD state VARCHAR(100) NOT NULL, ADD start_time TIME DEFAULT NULL, ADD end_time TIME DEFAULT NULL, CHANGE date date DATETIME DEFAULT NULL');
  29.         $this->addSql('CREATE INDEX idx_state ON order_shipping (state)');
  31.         // IMPORTANT: make sure to run this migration when all unfulfilled orders are still pending!!!
  33.         // update existing shipped orders
  34.         $this->addSql('UPDATE order_shipping LEFT JOIN orders ON orders.id=order_shipping.order_id SET 
  35.             order_shipping.start_time=orders.delivery_start_time,
  36.             order_shipping.end_time=orders.delivery_end_time,
  37.             order_shipping.date=orders.delivery_date,
  38.             order_shipping.state=\'state.delivered\'
  39.             WHERE orders.state=\'Entregado\'
  40.         ');
  42.         $this->addSql('UPDATE order_shipping LEFT JOIN orders ON orders.id=order_shipping.order_id SET 
  43.             order_shipping.start_time=orders.delivery_start_time,
  44.             order_shipping.end_time=orders.delivery_end_time,
  45.             order_shipping.date=orders.delivery_date,
  46.             order_shipping.state=\'state.returned\'
  47.             WHERE orders.state=\'Fallido\'
  48.         ');
  50.         $this->addSql('UPDATE order_shipping LEFT JOIN orders ON orders.id=order_shipping.order_id SET 
  51.             order_shipping.start_time=orders.delivery_start_time,
  52.             order_shipping.end_time=orders.delivery_end_time,
  53.             order_shipping.date=orders.delivery_date,
  54.             order_shipping.state=\'state.cancelled\'
  55.             WHERE orders.state=\'Anulado\'
  56.         ');
  58.         $this->addSql('UPDATE order_shipping LEFT JOIN orders ON orders.id=order_shipping.order_id SET 
  59.             order_shipping.start_time=orders.delivery_start_time,
  60.             order_shipping.end_time=orders.delivery_end_time,
  61.             order_shipping.date=orders.delivery_date,
  62.             order_shipping.state=\'state.preparing\'
  63.             WHERE orders.state=\'Preparing\'
  64.         ');
  66.         $this->addSql('UPDATE order_shipping LEFT JOIN orders ON orders.id=order_shipping.order_id SET 
  67.             order_shipping.start_time=orders.delivery_start_time,
  68.             order_shipping.end_time=orders.delivery_end_time,
  69.             order_shipping.date=orders.delivery_date,
  70.             order_shipping.state=\'state.transit\'
  71.             WHERE orders.state=\'Despachado\'
  72.         ');
  73.         
  74.         // create new shippings for pending orders
  75.         $this->addSql('INSERT INTO order_shipping(created_by_id, created_at, updated_by_id, updated_at, order_id, date, start_time, end_time, delivery_order, `state`)
  76.             SELECT 1, NOW(), 1, NOW(), orders.id, orders.delivery_date, orders.delivery_start_time, orders.delivery_end_time,0,\'state.pending\' FROM orders WHERE state=\'Pendiente\'
  77.         ');
  79.         $this->addSql('UPDATE orders SET state="state.open" WHERE state="Pendiente" OR state="Preparing" OR state="Despachado" OR state="Fallido"');
  80.         $this->addSql('UPDATE orders SET state="state.closed" WHERE state="Entregado"');
  81.         $this->addSql('UPDATE orders SET state="state.cancelled" WHERE state="Anulado"');
  83.         $this->addSql('ALTER TABLE orders DROP delivery_date, DROP delivery_start_time, DROP delivery_end_time');
  84.     }
  86.     public function down(Schema $schema): void
  87.     {
  88.         // this down() migration is auto-generated, please modify it to your needs
  89.         $this->addSql('CREATE TABLE order_vehicle_feature (order_id INT NOT NULL, vehicle_feature_id INT NOT NULL, INDEX IDX_CBADEB558D9F6D38 (order_id), INDEX IDX_CBADEB55E57637E4 (vehicle_feature_id), PRIMARY KEY(order_id, vehicle_feature_id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
  90.         $this->addSql('ALTER TABLE order_vehicle_feature ADD CONSTRAINT FK_CBADEB558D9F6D38 FOREIGN KEY (order_id) REFERENCES orders (id) ON DELETE CASCADE');
  91.         $this->addSql('ALTER TABLE order_vehicle_feature ADD CONSTRAINT FK_CBADEB55E57637E4 FOREIGN KEY (vehicle_feature_id) REFERENCES vehicle_feature (id) ON DELETE CASCADE');
  92.         $this->addSql('DROP TABLE order_shipping_vehicle_feature');
  94.         $this->addSql('ALTER TABLE order_shipping DROP start_time, DROP end_time, CHANGE date date DATETIME NOT NULL');
  95.         $this->addSql('ALTER TABLE orders ADD delivery_date DATETIME NOT NULL, ADD delivery_start_time TIME DEFAULT NULL, ADD delivery_end_time TIME DEFAULT NULL');
  97.         $this->addSql('DROP INDEX idx_state ON order_shipping');
  98.         $this->addSql('ALTER TABLE order_shipping DROP state');
  99.     }
  100.    
  102.     public function isTransactional(): bool
  103.     {
  104.         return false;
  105.     }
  106. }