migrations/Version20251018212519.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 Version20251018212519 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql("INSERT INTO tourapp.log_types (id, log_type_name) VALUES
  23.             (58, 'Utworzenie zwrotu Tpay'),
  24.             (59, 'Zmiana statusu płatności Tpay'),
  25.             (60, 'Zmiana statusu zwrotu Tpay');
  26.         ");
  28.         $this->addSql('
  29.             CREATE OR REPLACE FUNCTION tourapp.func_ins_travel(_travel_focus_id integer, _travel_name character varying, _school character varying, _teacher character varying, _teacher_email character varying, _travel_date_start date, _travel_date_end date, _travel_date_terminate_pay date, _travel_costofthetour numeric, _reference character varying)
  30.              RETURNS integer
  31.              LANGUAGE plpgsql
  32.             AS $function$
  33.             declare
  34.                 _ret_id integer;
  35.             
  36.             BEGIN
  37.             
  38.                 INSERT INTO tourapp.travel(
  39.                     travel_focus_id, 
  40.                     travel_name, 
  41.                     school, 
  42.                     teacher, 
  43.                     teacher_email, 
  44.                     travel_date_start, 
  45.                     travel_date_end, 
  46.                     travel_costofthetour,
  47.                     travel_date_terminate_pay,
  48.                     reference
  49.                 )
  50.                 VALUES (
  51.                     _travel_focus_id, 
  52.                     _travel_name, 
  53.                     _school, 
  54.                     _teacher, 
  55.                     _teacher_email, 
  56.                     _travel_date_start, 
  57.                     _travel_date_end, 
  58.                     _travel_costofthetour,
  59.                     _travel_date_terminate_pay,
  60.                     _reference
  61.                 ) returning travel_id into _ret_id;
  62.                 RETURN _ret_id;
  63.             
  64.             EXCEPTION
  65.                 WHEN OTHERS THEN RETURN 0;
  66.             END;
  67.             
  68.             $function$
  69.             ;
  70.         ');
  71.     }
  73.     public function down(Schema $schema): void
  74.     {
  75.     }
  76. }