app/DoctrineMigrations/Version20241023101344.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 Version20241023101344 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // 1 of 1: UPDATE `plg_zeus_payment_config`.
  23.         $env_params = [
  24.             'default' => [
  25.                 'id' => 1,
  26.                 // 'credit_payment_id' => NULL,
  27.                 'cvs_payment_id' => NULL,
  28.                 'edy_payment_id' => NULL,
  29.                 'ebank_payment_id' => NULL,
  30.                 'clientip' => NULL,
  31.                 'clientauthkey' => NULL,
  32.                 'cvvflg' => NULL,
  33.                 'quickchargeflg' => NULL,
  34.                 'saletype' => 0,
  35.                 'secure3dflg' => NULL,
  36.                 'detailname' => NULL,
  37.                 'clientip_cvs' => NULL,
  38.                 'siteurl' => NULL,
  39.                 'sitestr' => NULL,
  40.                 'clientip_edy' => NULL,
  41.                 'success_url' => NULL,
  42.                 'success_str' => NULL,
  43.                 'failure_url' => NULL,
  44.                 'failure_str' => NULL,
  45.                 'clientip_ebank' => NULL,
  46.                 'ebank_siteurl' => NULL,
  47.                 'ebank_sitestr' => NULL,
  48.                 'cvs_key' => NULL,
  49.                 'edy_key' => NULL,
  50.                 'ebank_key' => NULL,
  51.             ],
  52.             'prod' => [
  53.                 'credit_payment_id' => 5,
  54.                 'clientip' => '31662',
  55.                 'clientauthkey' => '843CE23498251E784FCEC6BE4183F9439BB32067',
  56.                 'cvvflg' => 4,
  57.                 'quickchargeflg' => 1,
  58.                 'saletype' => 0,
  59.                 'secure3dflg' => 0,
  60.                 'detailname' => 'Uniform Town',
  61.             ],
  62.             'dev' => [
  63.                 'credit_payment_id' => 5,
  64.                 'clientip' => '2019001640',
  65.                 'clientauthkey' => '370ae87be6e873947d84fe8a10f0bd03837c0f45',
  66.                 'cvvflg' => 4,
  67.                 'quickchargeflg' => 1,
  68.                 'saletype' => 0,
  69.                 'secure3dflg' => 0,
  70.                 'detailname' => 'Uniform Town（テスト）',
  71.             ],
  72.         ];
  73.         $params = array_merge($env_params['default'], $env_params[env('APP_ENV')]);
  74.         $sql = "INSERT INTO `plg_zeus_payment_config` (
  75.                     `id`
  76.                 ,   `credit_payment_id`
  77.                 ,   `cvs_payment_id`
  78.                 ,   `edy_payment_id`
  79.                 ,   `ebank_payment_id`
  80.                 ,   `clientip`
  81.                 ,   `clientauthkey`
  82.                 ,   `cvvflg`
  83.                 ,   `quickchargeflg`
  84.                 ,   `saletype`
  85.                 ,   `secure3dflg`
  86.                 ,   `detailname`
  87.                 ,   `clientip_cvs`
  88.                 ,   `siteurl`
  89.                 ,   `sitestr`
  90.                 ,   `clientip_edy`
  91.                 ,   `success_url`
  92.                 ,   `success_str`
  93.                 ,   `failure_url`
  94.                 ,   `failure_str`
  95.                 ,   `clientip_ebank`
  96.                 ,   `ebank_siteurl`
  97.                 ,   `ebank_sitestr`
  98.                 ,   `cvs_key`
  99.                 ,   `edy_key`
  100.                 ,   `ebank_key`
  101.                 ) VALUES (
  102.                     :id
  103.                 ,   :credit_payment_id
  104.                 ,   :cvs_payment_id
  105.                 ,   :edy_payment_id
  106.                 ,   :ebank_payment_id
  107.                 ,   :clientip
  108.                 ,   :clientauthkey
  109.                 ,   :cvvflg
  110.                 ,   :quickchargeflg
  111.                 ,   :saletype
  112.                 ,   :secure3dflg
  113.                 ,   :detailname
  114.                 ,   :clientip_cvs
  115.                 ,   :siteurl
  116.                 ,   :sitestr
  117.                 ,   :clientip_edy
  118.                 ,   :success_url
  119.                 ,   :success_str
  120.                 ,   :failure_url
  121.                 ,   :failure_str
  122.                 ,   :clientip_ebank
  123.                 ,   :ebank_siteurl
  124.                 ,   :ebank_sitestr
  125.                 ,   :cvs_key
  126.                 ,   :edy_key
  127.                 ,   :ebank_key
  128.                 )
  129.                 ON DUPLICATE KEY UPDATE
  130.                     `credit_payment_id` = VALUES( `credit_payment_id` )
  131.                 ,   `clientip` = VALUES( `clientip` )
  132.                 ,   `clientauthkey` = VALUES( `clientauthkey` )
  133.                 ,   `cvvflg` = VALUES( `cvvflg` )
  134.                 ,   `quickchargeflg` = VALUES( `quickchargeflg` )
  135.                 ,   `saletype` = VALUES( `saletype` )
  136.                 ,   `secure3dflg` = VALUES( `secure3dflg` )
  137.                 ,   `detailname` = VALUES( `detailname` )";
  138.         $this->addSql($sql, $params);
  140.     }
  142.     public function down(Schema $schema): void
  143.     {
  144.         // this down() migration is auto-generated, please modify it to your needs
  146.     }
  147. }