<?php

use Phalcon\Mvc\Model\Migration;

class NewStranasDb2025Migration_542 extends Migration {
    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.str_periode_triwulan VALUES (25, 4, 1, 'B03', '2025-01-01 00:01:00', '2025-04-14 23:59:00', '2025-04-17 00:01:00', '2025-05-05 00:00:00', 2177, '2025-01-20 02:29:15');
            INSERT INTO jaga.str_periode_triwulan VALUES (26, 4, 2, 'B06', '2025-05-08 01:00:00', '2025-06-30 23:59:00', '2025-07-03 01:00:00', '2025-07-20 23:59:00', 2177, '2025-07-03 07:44:14');
            INSERT INTO jaga.str_periode_triwulan VALUES (27, 4, 3, 'B09', '2025-07-21 00:00:00', '2025-09-29 23:59:00', '2025-10-02 00:00:00', '2025-10-13 23:59:00', 2177, '2025-07-03 08:03:25');
            INSERT INTO jaga.str_periode_triwulan VALUES (28, 4, 4, 'B12', '2025-10-16 01:00:00', '2025-12-15 23:59:00', '2025-12-18 01:00:00', '2025-12-29 23:59:00', 2177, '2025-07-03 08:08:23');
            INSERT INTO jaga.str_periode_triwulan VALUES (29, 4, 5, 'B15', '2026-02-15 00:00:00', '2026-03-29 23:59:00', '2026-04-01 00:00:00', '2026-04-19 23:59:00', 2177, '2026-04-26 08:52:07');
            INSERT INTO jaga.str_periode_triwulan VALUES (30, 4, 6, 'B18', '2026-04-22 00:00:00', '2026-06-28 23:59:00', '2026-07-01 00:00:00', '2026-07-12 23:59:00', 2177, '2026-07-26 01:56:18');
            INSERT INTO jaga.str_periode_triwulan VALUES (31, 4, 7, 'B21', '2026-07-15 00:00:00', '2026-09-30 23:59:00', '2026-10-01 00:00:00', '2026-10-17 23:59:00', 2177, '2026-10-18 07:31:22');
            INSERT INTO jaga.str_periode_triwulan VALUES (32, 4, 8, 'B24', '2026-10-18 01:00:00', '2026-12-17 23:59:00', '2026-12-18 01:00:00', '2026-12-31 23:59:00', 2177, '2027-01-10 03:37:53');
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.str_periode WHERE id = 4;
            DELETE FROM jaga.str_periode_triwulan WHERE id IN (25, 26, 27, 28, 29, 30, 31, 32);
        ");
    }
}