migrations/Version20240218220000.php line 1

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace DoctrineMigrations;
  5. use Doctrine\DBAL\Schema\Schema;
  6. use Doctrine\Migrations\AbstractMigration;
  8. final class Version20240218220000 extends AbstractMigration
  9. {
  10.     public function getDescription(): string
  11.     {
  12.         return 'Adds Galati SMS Offline configuration';
  13.     }
  15.     public function up(Schema $schema): void
  16.     {
  17.         $this->addSql(
  18.             <<<SQL
  19.                 INSERT INTO clients (id, success_return_url, failed_return_url, checkout_button_text, webhook_url, created_at, name,
  20.                                      is_active, updated_at, webhook_api_key, secret_key)
  21.                 VALUES ('3fb08a08-9cb6-4b91-b3c7-1871efc88871', null, null, null,
  22.                         'https://api.v2.amparcat.ro/hooks/offline-sms-webhook/27', NOW(), 'SMS Offline Galati', 1,
  23.                         NOW(), null, null);
  25.                 INSERT INTO processor_credentials (id, created_at, discriminator, publishable_key, secret_key,
  26.                                                                    webhook_secret, url, apikey, base_url, merchant_id, merchant_key,
  27.                                                                    soap_username, soap_password, signature, public_cert, private_key,
  28.                                                                    sandbox, sms_city_code, sms_config, sms_response_messages, sms_regexp_pattern)
  29.                 VALUES ('d9edfcd8-a4b9-44a5-a62c-fc37a1295251', NOW(), 'SmsOffline', null, null, null, null, null,
  30.                         'http://www4.web2sms.ro/api/service.php?wsdl', null, null, null, null, null, null, null, null, 'gl', '{"1":{"schedule":{"Friday":{"to":20,"from":8},"Monday":{"to":20,"from":8},"Sunday":{"to":20,"from":8},"Tuesday":{"to":20,"from":8},"Saturday":{"to":20,"from":8},"Thursday":{"to":20,"from":8},"Wednesday":{"to":20,"from":8}},"periodUom":60,"productPrice":0.6,"productNumber":"881273-232745-519903","productKeyword":"GLA"},"1ZI":{"schedule":{"Friday":{"to":20,"from":8},"Monday":{"to":20,"from":8},"Sunday":{"to":20,"from":8},"Tuesday":{"to":20,"from":8},"Saturday":{"to":20,"from":8},"Thursday":{"to":20,"from":8},"Wednesday":{"to":20,"from":8}},"periodUom":1440,"productPrice":3.3,"productNumber":"593918-639935-417925","productKeyword":"GLB"}}', '{
  31.                     "new_sms_intent": "Doresti rezervare parcare pentru %registrationPlate%. Trimite mesajul %confirmationKey% cost %smsPrice% %smsCurrency% (fara TVA).",
  32.                     "out_of_service": "Momentan sistemul nu accepta plati prin SMS in afara programului de lucru. Nu ati fost taxat! https://AmParcat.ro",
  33.                     "service_not_active": "Momentan sistemul nu accepta plati prin SMS. Incercati mai tarziu sau utilizati aplicatia pentru mobil https://AmParcat.ro",
  34.                     "intent_already_confirmed": "Aceasta rezervare a fost deja confirmata. Nu ati fost taxat! Pentru un proces mai usor utilizati aplicatia pentru mobil https://AmParcat.ro",
  35.                     "invalid_format_specified": "Codul introdus este incorect! Verificati mesajul precedent si retrimiteti codul pentru confirmarea rezervarii. Nu ati fost taxat! https://AmParcat.ro",
  36.                     "invalid_confirmation_code": "Codul introdus este incorect! Verificati mesajul precedent si retrimiteti codul pentru confirmarea rezervarii. Nu ati fost taxat! https://AmParcat.ro",
  37.                     "invalid_parameters_specified": "Ati gresit formatul mesajului! Verificati materialele de informare si retransmiteti mesajul corectat! Nu ati fost taxat! https://AmParcat.ro",
  38.                     "intent_confirmed_successfully": "Multumim, rezervarea ta pentru %registrationPlate% fost confirmata! Cost %smsPrice% %smsCurrency% (fara TVA). https://AmParcat.ro"
  39.                   }', 'L14oPzxjaXR5SWQ+Z2wpXHMrKD88c2VydmljZUtleXdvcmQ+MXwxWkkpKD88cGFya2luZ0xvdElkPlswLTldezAsfSlccysoPzxyZWdpc3RyYXRpb25QbGF0ZT5bYS16MC05XXszLDE2fSkkL21p');
  41.                 INSERT INTO payment_processors (id, project_id, processor_credentials_id, code, created_at)
  42.                 VALUES ('09a97f5d-71ef-4c95-9d29-462d7e730c43', '3fb08a08-9cb6-4b91-b3c7-1871efc88871',
  43.                         'd9edfcd8-a4b9-44a5-a62c-fc37a1295251', 'sms-offline-galati', NOW());
  45.                 UPDATE processor_credentials SET sms_regexp_pattern = 'L14oPzxjaXR5SWQ+c2kpXHMrKD88c2VydmljZUtleXdvcmQ+WzEtM10oQXxaSXxNfE1aSSl8MkJVUykoPzxwYXJraW5nTG90SWQ+WzAtOV17MCx9KVxzKyg/PHJlZ2lzdHJhdGlvblBsYXRlPlthLXowLTldezMsMTZ9KSQvbWk=' WHERE id = '5ec19562-ede9-4472-a9e5-655258e5f63a'
  46.             SQL
  47.         );
  48.     }
  50.     public function down(Schema $schema): void
  51.     {
  52.         $this->addSql('DELETE FROM payment_processors WHERE id = "09a97f5d-71ef-4c95-9d29-462d7e730c43"');
  53.         $this->addSql('DELETE FROM processor_credentials WHERE id = "d9edfcd8-a4b9-44a5-a62c-fc37a1295251"');
  54.         $this->addSql('DELETE FROM clients WHERE id = "3fb08a08-9cb6-4b91-b3c7-1871efc88871"');
  55.         $this->addSql('UPDATE processor_credentials SET sms_regexp_pattern = NULL WHERE id = "5ec19562-ede9-4472-a9e5-655258e5f63a"');
  56.     }
  57. }