<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2210062002 extends AbstractMigration
{
    private $dePara = [
        1241 => 1337,
        1249 => 1338,
        1250 => 1339,
        1253 => 1340,
        1256 => 1341,
        1265 => 1342,
        1270 => 1343,
        1277 => 1344,
        1280 => 1345,
        1288 => 1346,
        1289 => 1347,
        1293 => 1348,
        1296 => 1349,
        1299 => 1350,
        1301 => 1351,
        1303 => 1352,
        1261 => 1353,
        1309 => 1354,
        1311 => 1355,
        1316 => 1356,
        1332 => 1357,
        1318 => 1358,
        1319 => 1359,
        1322 => 1360,
        1324 => 1361,
        1326 => 1362,
        1325 => 1363,
        1327 => 1364,
        1328 => 1365,
        1329 => 1366,
        1244 => 1367,
        1245 => 1368,
        1247 => 1369,
        1335 => 1370,
        1251 => 1371,
        1258 => 1372,
        1262 => 1373,
        1266 => 1374,
        1267 => 1375,
        1273 => 1376,
        1279 => 1377,
        1281 => 1378,
        1285 => 1379,
        1291 => 1380,
        1295 => 1381,
        1297 => 1382,
        1242 => 1383,
        1243 => 1384,
        1264 => 1385,
        1271 => 1386,
        1275 => 1387,
        1283 => 1388,
        1286 => 1389,
        1294 => 1390,
        1300 => 1391,
        1304 => 1393,
        1305 => 1394,
        1306 => 1395,
        1312 => 1396,
        1314 => 1397,
        1317 => 1398,
        1248 => 1399,
        1252 => 1400,
        1257 => 1401,
        1260 => 1402,
        1334 => 1403,
        1269 => 1404,
        1274 => 1405,
        1292 => 1406,
        1298 => 1407,
        1302 => 1408,
        1307 => 1409,
        1310 => 1410,
        1313 => 1411,
        1315 => 1412,
        1320 => 1414,
        1323 => 1415,
        1254 => 1416,
        1255 => 1417,
        1259 => 1418,
        1263 => 1419,
        1268 => 1420,
        1272 => 1421,
        1278 => 1422,
        1282 => 1423,
        1284 => 1424,
        1287 => 1425,
    ];

    public function up(): void
    {
        foreach ($this->dePara as $idProduto2022 => $idProduto2023) {         
            $this->execute("
                UPDATE produto.produtos new
                   SET ds_frase_padrao_orcamento = old.ds_frase_padrao_orcamento,
                       ds_frase_restricoes = old.ds_frase_restricoes,
                       ds_frase_risco = old.ds_frase_risco
                  FROM produto.produtos old
                 WHERE old.id = {$idProduto2022}
                   AND new.id = {$idProduto2023}
            ");
        }
    }

    public function down(): void
    {
        $idsProduto2023 = implode(", ", $this->dePara);
        $this->execute("
            UPDATE produto.produtos
               SET ds_frase_padrao_orcamento = '',
                   ds_frase_restricoes = '',
                   ds_frase_risco = ''
             WHERE id IN ({$idsProduto2023})
        ");
    }
}