<?php

use Phalcon\Mvc\Model\Migration;

class UpdateElhkpnWilayahMigration_538 extends Migration {
    public function up()
    {
        self::$connection->execute("
            UPDATE jaga.master_wilayah a SET parent_id = (SELECT id FROM jaga.master_wilayah b WHERE b.level = 'provinsi' AND b.active = 1 AND substring(a.code, 1, 2) = b.code) WHERE a.active = 1 AND a.level = 'kabupaten';
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (574, 'MALUKU UTARA @@ PULAU MOROTAI');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (460, 'SULAWESI TENGGARA @@ KENDARI');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (468, 'MALUKU @@ KEPULAUAN TANIMBAR');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (240, 'SUMATERA UTARA @@ KOTA PADANGSIDIMPUAN');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (633, 'SULAWESI BARAT @@ PASANGKAYU');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (224, 'SUMATERA UTARA @@ TOBA');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (227, 'SUMATERA UTARA @@ BATU BARA');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (658, 'PAPUA SELATAN @@ MAPPI');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (659, 'PAPUA SELATAN @@ ASMAT');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (657, 'PAPUA SELATAN @@ BOVEN DIGOEL');
            INSERT INTO jaga.elhkpn_wilayah (wilayah_id, join_name) VALUES (648, 'PAPUA SELATAN @@ MERAUKE');
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 574 AND join_name = 'MALUKU UTARA @@ PULAU MOROTAI';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 460 AND join_name = 'SULAWESI TENGGARA @@ KENDARI';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 468 AND join_name = 'MALUKU @@ KEPULAUAN TANIMBAR';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 240 AND join_name = 'SUMATERA UTARA @@ KOTA PADANGSIDIMPUAN';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 633 AND join_name = 'SULAWESI BARAT @@ PASANGKAYU';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 224 AND join_name = 'SUMATERA UTARA @@ TOBA';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 227 AND join_name = 'SUMATERA UTARA @@ BATU BARA';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 658 AND join_name = 'PAPUA SELATAN @@ MAPPI';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 659 AND join_name = 'PAPUA SELATAN @@ ASMAT';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 657 AND join_name = 'PAPUA SELATAN @@ BOVEN DIGOEL';
            DELETE FROM jaga.elhkpn_wilayah WHERE wilayah_id = 648 AND join_name = 'PAPUA SELATAN @@ MERAUKE';
        ");
    }
}