<?php

use Phalcon\Mvc\Model\Migration;

class InfoAlokasiBoptnMigration_345 extends Migration
{
    public function up()
    {
        $this->down(); 
        
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."info_alokasi_boptn"
            (
                id SERIAL PRIMARY KEY,
                tahun INTEGER,
                kode_output VARCHAR(10),
                nama_output VARCHAR(255),
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        self::$connection->execute("
            INSERT INTO jaga.info_alokasi_boptn (id, tahun, kode_output, nama_output, created_at)
            VALUES 
                (1, 2019, '001', 'Layanan Perkantoran Satker', now()),
                (2, 2019, '002', 'Layanan Pembelajaran', now()),
                (3, 2019, '003', 'Buku Pustaka', now()),
                (4, 2019, '004', 'Laporan Kegiatan Mahasiswa', now()),
                (5, 2019, '005', 'Tidak Tersedia', now()),
                (6, 2019, '006', 'Tidak Tersedia', now()),
                (7, 2019, '007', 'Layanan Pengembangan Sistem Tata Kelola, Kelembagaan, dan SDM', now()),
                (8, 2019, '008', 'Sarana dan Prasarana Pembelajaran', now()),
                (9, 2020, '001', 'Dukungan Operasional PTN', now()),
                (10, 2020, '002', 'Layanan Pembelajaran', now()),
                (11, 2020, '003', 'Buku Pustaka', now()),
                (12, 2020, '004', 'Laporan Kegiatan Mahasiswa', now()),
                (13, 2020, '005', 'Tidak Tersedia', now()),
                (14, 2020, '006', 'Tidak Tersedia', now()),
                (15, 2020, '007', 'Layanan Pengembangan Sistem Tata Kelola, Kelembagaan, dan SDM', now()),
                (16, 2020, '008', 'Sarana dan Prasarana Pembelajaran', now()),
                (17, 2021, '001', 'Dukungan Operasional (BOPTN)', now()),
                (18, 2021, '002', 'Pembelajaran (BOPTN)', now()),
                (19, 2021, '003', 'Buku Pustaka (BOPTN)', now()),
                (20, 2021, '004', 'Kegiatan Mahasiswa (BOPTN)', now()),
                (21, 2021, '005', 'Pengembangan Sistem Tata Kelola, Kelembagaan, dan SDM (BOPTN)', now()),
                (22, 2021, '006', 'Operasional Rumah Sakit Pendidikan (BOPTN)', now()),
                (23, 2021, '007', 'Sarana dan Prasarana Pembelajaran (BOPTN)', now())
            ON CONFLICT DO NOTHING;
        ");
    }

    public function down()
    {
        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."info_alokasi_boptn";
        ');
    }
}