<?php

use Phalcon\Mvc\Model\Migration;

class PPJMigration_368 extends Migration
{
    public function up()
    {
        // remove data duplikat pada table ppj_hal1, ppj_hal2, ppj_piutang_pemda
        self::$connection->execute("
            DELETE FROM
                ppj_hal1 a USING ppj_hal1 b 
            WHERE
                a.id < b.id
                AND a.thbllap = b.thbllap
                AND a.namaunitpln = b.namaunitpln
                AND a.kd_kabmendagri = b.kd_kabmendagri
                AND a.nama_kabmendagri = b.nama_kabmendagri
                AND a.goltarif = b.goltarif
                AND a.daya = b.daya
                AND a.lbr_sorek = b.lbr_sorek
                AND a.plg_sorek = b.plg_sorek
                AND a.pal_taglis = b.pal_taglis
                AND a.ts_taglis = b.ts_taglis
                AND a.ppj_taglis = b.ppj_taglis;
            DELETE FROM
                ppj_hal2 a USING ppj_hal2 b 
            WHERE
                a.id < b.id
                AND a.thbllap = b.thbllap
                AND a.namaunitpln = b.namaunitpln
                AND a.kd_kabmendagri = b.kd_kabmendagri
                AND a.nama_kabmendagri = b.nama_kabmendagri
                AND a.goltarif = b.goltarif
                AND a.daya = b.daya
                AND a.lbr_taglis = b.lbr_taglis
                AND a.plg_taglis = b.plg_taglis
                AND a.ppj_total = b.ppj_total;
            
            DELETE FROM
                ppj_piutang_pemda a USING ppj_piutang_pemda b 
            WHERE
                a.id < b.id
                AND a.thbllap = b.thbllap
                AND a.namaunitpln = b.namaunitpln
                AND a.kd_kabmendagri = b.kd_kabmendagri
                AND a.nama_kabmendagri = b.nama_kabmendagri
                AND a.pemda = b.pemda
                AND a.namapemda = b.namapemda
                AND a.tagihan_pemda_ini = b.tagihan_pemda_ini
                AND a.rpptl_309_kab = b.rpptl_309_kab
                AND a.pemkwh_309_kab = b.pemkwh_309_kab;
        ");
    }

    public function down()
    {
        // cannot be rollback
    }
}