<?php

use Phalcon\Mvc\Model\Migration;
class UpdateIndikatorPancekMigration_398 extends Migration
{
    public function up()
    {
        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'pancek_quiz.sql');
        self::$connection->execute($sql);

        self::$connection->execute("
            ALTER TABLE jaga.pancek_jenis_instansi ADD COLUMN IF NOT EXISTS formulir_type integer NOT NULL default 1;
            ALTER TABLE jaga.pancek_konsep_sistem_pencegahan ADD COLUMN IF NOT EXISTS formulir_type integer NOT NULL default 1;
            ALTER TABLE jaga.pancek_indikator ADD COLUMN IF NOT EXISTS formulir_type integer NOT NULL default 1;
            ALTER TABLE jaga.pancek_komponen_indikator ADD COLUMN IF NOT EXISTS formulir_type integer NOT NULL default 1;
            UPDATE jaga.pancek_jenis_instansi SET formulir_type = 2 WHERE id = 3;

            ALTER TABLE jaga.pancek_quiz_question ADD COLUMN IF NOT EXISTS view_order integer NOT NULL default 1;
            UPDATE jaga.pancek_quiz_question SET view_order = 1 WHERE id = 4;
            UPDATE jaga.pancek_quiz_question SET view_order = 2 WHERE id = 3;
            UPDATE jaga.pancek_quiz_question SET view_order = 3 WHERE id = 5;
            UPDATE jaga.pancek_quiz_question SET view_order = 4 WHERE id = 7;
            UPDATE jaga.pancek_quiz_question SET view_order = 5 WHERE id = 8;
            UPDATE jaga.pancek_quiz_question SET view_order = 6 WHERE id = 6;
            UPDATE jaga.pancek_quiz_question SET view_order = 7 WHERE id = 2;
            UPDATE jaga.pancek_quiz_question SET view_order = 8 WHERE id = 1;
        ");
        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'indikator_bumn_update.sql');
        self::$connection->execute($sql);

        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'indikator_swasta_insert.sql');
        self::$connection->execute($sql);
    }

    public function down()
    {

        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'indikator_bumn.sql');
        self::$connection->execute($sql);

        self::$connection->execute("
            DELETE FROM jaga.pancek_konsep_sistem_pencegahan WHERE formulir_type = 2;
            DELETE FROM jaga.pancek_indikator WHERE formulir_type = 2;
            DELETE FROM jaga.pancek_komponen_indikator WHERE formulir_type = 2;
            ALTER TABLE jaga.pancek_jenis_instansi DROP COLUMN IF EXISTS formulir_type;
            ALTER TABLE jaga.pancek_konsep_sistem_pencegahan DROP COLUMN IF EXISTS formulir_type;
            ALTER TABLE jaga.pancek_indikator DROP COLUMN IF EXISTS formulir_type;
            ALTER TABLE jaga.pancek_komponen_indikator DROP COLUMN IF EXISTS formulir_type;

            DROP TABLE IF EXISTS jaga.pancek_quiz;
            DROP TABLE IF EXISTS jaga.pancek_quiz_question;
            DROP TABLE IF EXISTS jaga.pancek_quiz_answer;
            DROP TABLE IF EXISTS jaga.pancek_quiz_exam;
            DROP TABLE IF EXISTS jaga.pancek_quiz_exam_answer;
        ");
    }
}