<?php

class LitbangKajian extends \Phalcon\Mvc\Model
{
    public $id;
    public $sektor_id;
    public $jenis_id;
    public $kode;
    public $judul;
    public $tahun;
    public $deskripsi;
    public $potensi_penyelamatan_keuangan;
    public $daftar_pustaka;
    public $created_at;
    public $updated_at;
    public $deleted_at;
    public $attachment_id;

    /**
     * Initialize method for model.
     */
    public function initialize()
    {
        $this->setSchema("jaga");
        $this->setSource("litbang_kajian");

        $this->belongsTo('id_area_intervensi', 'KorsupgahAreaIntervensi', 'id');
        $this->hasMany(
            'id',
            'LitbangKajianKlpd',
            'kajian_id',
            [
                'params'   => [
                    'conditions' => 'src = :src:',
                    'bind'       => [
                        'src' => LitbangKajianKlpd::SRC_KAJIAN,
                    ]
                ]
            ]
        );
        $this->belongsTo('attachment_id', 'Attachments', 'id');
    }

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

        $result['klpd_list'] = LitbangKajianKlpd::find([
            'conditions' => 'kajian_id=:kajian_id: AND src = :src: AND deleted_at is null',
            'bind' => [
                'kajian_id' => $this->id,
                'src' => LitbangKajianKlpd::SRC_KAJIAN
            ]
        ]);

        $attachment = $this->attachments;
        $result['attachment'] = empty($attachment) ? null : $attachment;

        return $result;
    }
}