migrations/Finance/Version20200511103553_FinanceTax.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Finance;
  7. use App\Doctrine\Type\Finance\ChargeableType;
  8. use App\Doctrine\Type\Finance\ExpenseType;
  9. use Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  */
  15. final class Version20200511103553_FinanceTax extends AbstractMigration
  16. {
  17.     public function getDescription() : string
  18.     {
  19.         return 'Add chargeable table';
  20.     }
  22.     public function up(Schema $schema) : void
  23.     {
  24.         $chargeableType = ChargeableType::getName();
  25.         $expenseType = ExpenseType::getName();
  27.         $this->addSql("CREATE TABLE finance_tax (
  28.             id                          SERIAL PRIMARY KEY,
  29.             bill_id                     INTEGER                              REFERENCES public.finance_bill (id),
  30.             invoice_id                  INTEGER                              REFERENCES public.finance_invoice (id),
  31.             chargeable_id               INTEGER                              REFERENCES public.finance_chargeable (id),
  33.             name                        CHARACTER VARYING           NOT NULL,
  34.             amount                      DECIMAL(18, 2)              NOT NULL,
  35.             rate                        DECIMAL(5, 2)               NOT NULL,
  37.             CONSTRAINT finance_tax_xor_taxable CHECK (
  38.                 (bill_id IS NOT NULL AND invoice_id IS     NULL AND chargeable_id IS     NULL) OR
  39.                 (bill_id IS     NULL AND invoice_id IS NOT NULL AND chargeable_id IS     NULL) OR
  40.                 (bill_id IS     NULL AND invoice_id IS     NULL AND chargeable_id IS NOT NULL)
  41.             )
  42.         )");
  44.         $this->addSql("CREATE INDEX finance_tax_bill_id_idx ON finance_tax (bill_id)");
  45.         $this->addSql("CREATE INDEX finance_tax_invoice_id_idx ON finance_tax (invoice_id)");
  46.         $this->addSql("CREATE INDEX finance_tax_chargeable_id_idx ON finance_tax (chargeable_id)");
  47.     }
  49.     public function down(Schema $schema) : void
  50.     {
  51.         $this->addSql("DROP TABLE IF EXISTS finance_tax");
  52.     }
  53. }