migrations/Version20241203205251.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 Version20241203205251 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql('ALTER VIEW report_total_or_installments_count AS
  23. select a.academic_year AS academic_year, a.title AS title, count(*) AS total
  24. from (SELECT e.academic_year AS academic_year,
  25.              CASE
  26.                  WHEN i.title IN (\'U cjelosti\', \'Uplata u cjelosti\')
  27.                      THEN \'Uplata u cjelosti\'
  28.                  ELSE \'Rate\'
  29.                  END         AS title,
  30.              COUNT(s.id)     AS total
  31.       FROM students s
  32.                LEFT JOIN udg_fms.profiles p ON s.id = p.student_id
  33.                LEFT JOIN udg_fms.enrollment_events e ON e.profile_id = p.id
  34.                left join tuition_modality_templates t on e.tuition_modality_template_id = t.id
  35.                LEFT JOIN udg_fms.tuition_installments i ON e.id = i.enrollment_id
  36.       WHERE e.academic_year IS NOT NULL
  37.         AND e.tuition_modality_template_id IS NOT NULL
  38.         AND i.payed_on IS NOT NULL
  39.       GROUP BY e.academic_year,
  40.                CASE
  41.                    WHEN i.title IN (\'U cjelosti\', \'Uplata u cjelosti\')
  42.                        THEN \'Uplata u cjelosti\'
  43.                    ELSE \'Rate\'
  44.                    END,
  45.                s.faculty, s.first_name, s.last_name, p.index_no, p.current_semester, t.title) a
  46. group by a.academic_year, a.title');
  47.     }
  49.     public function down(Schema $schema): void
  50.     {
  51.         // this down() migration is auto-generated, please modify it to your needs
  52.         $this->addSql('ALTER VIEW report_total_or_installments_count AS
  53.     select a.academic_year, a.title, count(a.id) as total
  54.     from (SELECT DISTINCT s.id    AS id,
  55.                           CASE
  56.                               WHEN i.title IN (\'U cjelosti\', \'Uplata u cjelosti\')
  57.                      THEN \'Uplata u cjelosti\'
  58.                               ELSE \'Rate\'
  59.                               END AS title,
  60.                           e.academic_year
  61.           FROM students s
  62.                    LEFT JOIN udg_fms.profiles p ON s.id = p.student_id
  63.                    LEFT JOIN enrollment_events e ON e.profile_id = p.id
  64.                    LEFT JOIN tuition_installments i ON e.id = i.enrollment_id
  65.           where e.academic_year is not null
  66.             and e.tuition_modality_template_id is not null) a
  67.     group by a.academic_year, a.title;');
  68.     }
  69. }