migrations/Expediting/Version20200310163721_ExpeditingShippingSegment.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Expediting;
  7. use App\Doctrine\Type\Expediting\DeliveryPriority;
  8. use App\Doctrine\Type\Expediting\ExpeditingStatus;
  9. use App\Doctrine\Type\Expediting\ShippingSegmentStatus;
  10. use App\Doctrine\Type\Expediting\ShipmentType;
  11. use App\Doctrine\Type\Expediting\TransportMode;
  12. use App\Doctrine\Type\Expediting\TransportSpecification;
  13. use Doctrine\DBAL\Schema\Schema;
  14. use Doctrine\Migrations\AbstractMigration;
  16. /**
  17.  * Auto-generated Migration: Please modify to your needs!
  18.  */
  19. final class Version20200310163721_ExpeditingShippingSegment extends AbstractMigration
  20. {
  21.     public function getDescription(): string
  22.     {
  23.         return 'Add shipping segments table';
  24.     }
  26.     public function up(Schema $schema): void
  27.     {
  28.         $deliveryPriorityType = DeliveryPriority::getName();
  29.         $shippingSegmentStatusType = ShippingSegmentStatus::getName();
  30.         $transferTypeType = ShipmentType::getName(asArray: true);
  31.         $transportModeType = TransportMode::getName();
  32.         $transportSpecificationType = TransportSpecification::getName();
  33.         $defaultPriority = DeliveryPriority::NORMAL->value;
  34.         $defaultStatus = ExpeditingStatus::PLANNED->value;
  35.         $defaultTransportSpec = TransportSpecification::STANDARD->value;
  37.         $this->addSql("CREATE TABLE expediting_shipping_segment (
  38.             id                              SERIAL PRIMARY KEY,
  39.             identifier                      UUID                               NOT NULL,
  40.             shipping_plan_id                INTEGER                            NOT NULL REFERENCES public.expediting_shipping_plan (id),
  41.             status                          {$shippingSegmentStatusType}       NOT NULL DEFAULT '{$defaultStatus}',
  42.             types                           {$transferTypeType},
  43.             etd                             DATE,
  44.             eta                             DATE,
  47.             -- Shipping
  48.             shipper_id                      INTEGER                                REFERENCES public.company (id),
  49.             consignee_id                    INTEGER                                REFERENCES public.company (id),
  50.             notify_party_id                 INTEGER                                REFERENCES public.company (id),
  51.             place_of_loading_id             INTEGER                                REFERENCES public.place (id),
  52.             place_of_discharge_id           INTEGER                                REFERENCES public.place (id),
  53.             currency                        CHARACTER VARYING(3),
  54.             freight_value                   DECIMAL(18, 5),
  57.             -- Transport
  58.             bill_number                     CHARACTER VARYING,
  59.             booking_number                  CHARACTER VARYING,
  60.             vector_reference                CHARACTER VARYING,
  61.             transport_mode                  {$transportModeType}          NOT NULL,
  62.             transport_company_id            INTEGER                                REFERENCES public.company (id),
  63.             driver_id                       INTEGER                                REFERENCES public.fleet_driver (id),
  64.             vehicle_id                      INTEGER                                REFERENCES public.fleet_vehicle (id),
  65.             transport_specification         {$transportSpecificationType} NOT NULL DEFAULT '{$defaultTransportSpec}',
  68.             -- QA/QC
  69.             priority                        {$deliveryPriorityType}                DEFAULT '{$defaultPriority}',
  70.             high_value                      BOOLEAN                                DEFAULT false,
  71.             high_volume                     BOOLEAN                                DEFAULT false,
  72.             high_risk                       BOOLEAN                                DEFAULT false,
  73.             expeditable                     BOOLEAN                                DEFAULT false,
  74.             dangerous                       BOOLEAN                                DEFAULT false,
  75.             prohibited                      BOOLEAN                                DEFAULT false,
  76.             delayed                         BOOLEAN                                DEFAULT false,
  78.             created_by                      INTEGER                            NOT NULL REFERENCES public.user (id),
  79.             updated_by                      INTEGER                                     REFERENCES public.user (id),
  80.             created_at                      TIMESTAMP(0) WITH TIME ZONE        NOT NULL DEFAULT CURRENT_TIMESTAMP,
  81.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  82.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE,
  84.             CONSTRAINT expediting_shipping_segment_identifier_key UNIQUE (identifier)
  85.         )");
  87.         $this->addSql("COMMENT ON COLUMN expediting_shipping_segment.identifier IS '(DC2Type:ulid)'");
  88.         $this->addSql("CREATE INDEX expediting_shipping_segment_driver_id_idx ON expediting_shipping_segment (driver_id)");
  89.         $this->addSql("CREATE INDEX expediting_shipping_segment_vehicle_id_idx ON expediting_shipping_segment (vehicle_id)");
  90.         $this->addSql("CREATE INDEX expediting_shipping_segment_shipper_id_idx ON expediting_shipping_segment (shipper_id)");
  91.         $this->addSql("CREATE INDEX expediting_shipping_segment_consignee_id_idx ON expediting_shipping_segment (consignee_id)");
  92.         $this->addSql("CREATE INDEX expediting_shipping_segment_notify_party_id_idx ON expediting_shipping_segment (notify_party_id)");
  93.         $this->addSql("CREATE INDEX expediting_shipping_segment_transport_company_id_idx ON expediting_shipping_segment (transport_company_id)");
  94.         $this->addSql("CREATE INDEX expediting_shipping_segment_shipping_plan_id_idx ON expediting_shipping_segment (shipping_plan_id)");
  95.         $this->addSql("CREATE INDEX expediting_shipping_segment_place_of_loading_id_idx ON expediting_shipping_segment (place_of_loading_id)");
  96.         $this->addSql("CREATE INDEX expediting_shipping_segment_place_of_discharge_id_idx ON expediting_shipping_segment (place_of_discharge_id)");
  97.         $this->addSql("CREATE INDEX expediting_shipping_segment_created_by_idx ON expediting_shipping_segment (created_by)");
  98.         $this->addSql("CREATE INDEX expediting_shipping_segment_updated_by_idx ON expediting_shipping_segment (updated_by)");
  99.     }
  101.     public function down(Schema $schema): void
  102.     {
  103.         $this->addSql("DROP TABLE IF EXISTS expediting_shipping_segment");
  104.     }
  105. }