<?php

class SipdSkpd extends \Phalcon\Mvc\Model
{
    public function initialize()
    {
        $this->setSchema("jaga");
        $this->setSource("sipd_skpd");
        $this->hasManyToMany(
            "id",
            "SipdProgram",
            "id_skpd",
            "id_program",
            "SipdMasterProgram",
            "id"
        );
        $this->hasMany("id", "SipdProgram", "id_skpd");
        $this->belongsTo("kode_pemda", "KepadatanPendudukAll", "kode_pemda", ['alias' => 'kpa']);
        $this->belongsTo("kode_pemda", "KemdagriMkodeProv", "KODE", ['alias' => 'kmp']);
        $this->belongsTo("kode_pemda", "KemdagriMkodeKabkot", "KODE", ['alias' => 'kmk']);
    }

    public function toArray($columns = null)
    {
        $result = parent::toArray($columns);

        $result['provinsi'] = $this->kmp;

        return $result;
    }


    public function toDetail()
    {
        $result = $this->toArray();

        $result['programs'] = [];
        $result['penduduk'] = $this->kpa;
        $result['provinsi'] = $this->kmp;
        $result['kabkot'] = $this->kmk;

        foreach ($this->SipdProgram as $key => $program) {
            $result['programs'][] = $program->toDetail();
        }

        return $result;
    }
}