<?php

use Phalcon\Mvc\Model\Migration;

class RumahSakit2Migration_317 extends Migration
{
    public function up()
    {
        $this->down();

        //NOTE: Add columns
        self::$connection->execute("
        ALTER TABLE jaga.rumah_sakit 
            ADD COLUMN kls_rs smallint,
            ADD COLUMN kode_prop smallint,
            ADD COLUMN kode_kab smallint,
            ADD COLUMN kodepos character varying (20),
            ADD COLUMN penyelenggara character varying (255),
            ADD COLUMN blu character varying (50),
            ADD COLUMN fax_rs character varying (50),
            ADD COLUMN telp_humas character varying (50),
            ADD COLUMN tgl_surat_ijin DATE,
            ADD COLUMN sifat_surat_ijin character varying (50),
            ADD COLUMN masa_berlaku_surat_ijin DATE, --NOTE, dari API sananya bentuknya dd/MM/yyyy, sebelum simpan, ubah dulu formatnya
            ADD COLUMN tahap_akreditasi character varying (255),
            ADD COLUMN ambulan character varying (100),
            ADD COLUMN simrs character varying (100),
            ADD COLUMN bank_darah character varying (50),
            ADD COLUMN masa_berlaku_akreditasi DATE,
            ADD COLUMN tahun_berdiri character varying(5),
            ADD COLUMN tgl_update DATE;
        ");

        //NOTE: Alter Column
        self::$connection->execute("
        ALTER TABLE jaga.rumah_sakit 
            ALTER COLUMN luas_tanah TYPE numeric,
            ALTER COLUMN luas_bangunan TYPE numeric;
        ");

        //TODO: ubah luas tanah jeung luas bangunan jadi numeric
    }

    public function down()
    {
        self::$connection->execute('
            ALTER TABLE jaga.rumah_sakit
                DROP COLUMN IF EXISTS kls_rs,
                DROP COLUMN IF EXISTS kode_prop,
                DROP COLUMN IF EXISTS kode_kab,
                DROP COLUMN IF EXISTS kodepos,
                DROP COLUMN IF EXISTS penyelenggara,
                DROP COLUMN IF EXISTS blu,
                DROP COLUMN IF EXISTS fax_rs,
                DROP COLUMN IF EXISTS telp_humas,
                DROP COLUMN IF EXISTS tgl_surat_ijin,
                DROP COLUMN IF EXISTS sifat_surat_ijin,
                DROP COLUMN IF EXISTS masa_berlaku_surat_ijin,
                DROP COLUMN IF EXISTS tahap_akreditasi,
                DROP COLUMN IF EXISTS ambulan,
                DROP COLUMN IF EXISTS simrs,
                DROP COLUMN IF EXISTS bank_darah,
                DROP COLUMN IF EXISTS masa_berlaku_akreditasi,
                DROP COLUMN IF EXISTS tahun_berdiri,
                DROP COLUMN IF EXISTS tgl_update;
        ');

        //TODO: Flooring 2 column di bawah supaya pembulaan, balik ke ineger

        //NOTE: Alter Column
        self::$connection->execute("
        ALTER TABLE jaga.rumah_sakit 
            ALTER COLUMN luas_tanah TYPE int,
            ALTER COLUMN luas_bangunan TYPE int;
        ");
    }
}