<?php

namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use App\Model\TahunProgramDetailUpt;
use Auth;

class MetadataProgram extends Model
{
    use SoftDeletes;
    
    protected $table = 'metadata_program';
    protected $fillable = [
        'id',
        'id_tb_tahun_program_detail',
        'periode',
        'id_upt',
        'float1',
        'float2',
        'float3',
        'float4',
        'float5',
        'float6',
        'float7',
        'float8',
        'float9',
        'float10',
        'varchar1',
        'varchar2',
        'varchar3',
        'varchar4',
        'varchar5',
        'varchar6',
        'varchar7',
        'varchar8',
        'varchar9',
        'varchar10',
        'varchar11',
        'varchar12',
        'varchar13',
        'varchar14',
        'varchar15',
        'varchar16',
        'varchar17',
        'varchar18',
        'varchar19',
        'varchar20',
        'date1',
        'date2',
        'date3',
        'date4',
        'date5',
        'date6',
        'date7',
        'date8',
        'date9',
        'date10',
        'created_by',
        'updated_by'
    ];

    public function templateProgram(){
        return $this->belongsTo('App\Model\TemplateProgram', 'id_template_program');
    }

    public function tbTahunProgramDetail(){
        return $this->belongsTo('App\Model\TahunProgramDetail', 'id_tb_tahun_program_detail');
    }

    public function upt(){
        return $this->hasMany('App\Model\UPTSModel','office_id','id_upt');
    }

    public function getPeriodeAttribute(){
        $periode = 1;
        $jml = MetadataProgram::where('id_tb_tahun_program_detail',$this->id_tb_tahun_program_detail)
        ->where('id_upt',$this->id_upt)
        ->orderBy('id','asc')
        ->pluck('id');
        return (array_search($this->id, $jml->toArray()))+1;
    }

    public function getTargetPeriodeAttribute(){
        $target = 0;
        
        $periode = $this->getPeriodeAttribute();
        if(!empty($periode)){
            $tahunProgramDetailUpt = TahunProgramDetailUpt::where('id_tahun_program_detail',$this->id_tb_tahun_program_detail)->where('id_upt',$this->id_upt)->where('periode',$periode)->first();
            $target = !empty($tahunProgramDetailUpt)?$tahunProgramDetailUpt->target.' '.$tahunProgramDetailUpt->satuan:0;
        }
        return $target;
        

    }
}