<?php

namespace App\Model;

use Illuminate\Database\Eloquent\Model;

class ItemProgram extends Model
{
    protected $table = 'item_program';

    const INPUT_TYPE_VARIABLE = [
        'varchar1'=>['type' => 'text'],
        'varchar2'=>['type' => 'text'],
        'varchar3'=>['type' => 'text'],
        'varchar4'=>['type' => 'text'],
        'varchar5'=>['type' => 'text'],
        'varchar6'=>['type' => 'text'],
        'varchar7'=>['type' => 'text'],
        'varchar8'=>['type' => 'text'],
        'varchar9'=>['type' => 'text'],
        'varchar10'=>['type' => 'text'],
        'varchar11'=>['type' => 'text'],
        'varchar12'=>['type' => 'text'],
        'varchar13'=>['type' => 'text'],
        'varchar14'=>['type' => 'text'],
        'varchar15'=>['type' => 'text'],
        'varchar16'=>['type' => 'text'],
        'varchar17'=>['type' => 'text'],
        'varchar18'=>['type' => 'text'],
        'varchar19'=>['type' => 'text'],
        'varchar20'=>['type' => 'text'],
        'float1'=>['type' => 'number'],
        'float2'=>['type' => 'number'],
        'float3'=>['type' => 'number'],
        'float4'=>['type' => 'number'],
        'float5'=>['type' => 'number'],
        'float6'=>['type' => 'number'],
        'float7'=>['type' => 'number'],
        'float8'=>['type' => 'number'],
        'float9'=>['type' => 'number'],
        'float10'=>['type' => 'number'],
        'date1'=>['type' => 'date'],
        'date2'=>['type' => 'date'],
        'date3'=>['type' => 'date'],
        'date4'=>['type' => 'date'],
        'date5'=>['type' => 'date'],
        'date6'=>['type' => 'date'],
        'date7'=>['type' => 'date'],
        'date8'=>['type' => 'date'],
        'date9'=>['type' => 'date'],
        'date10'=>['type' => 'date'],
    ];

    const COLUMN_CLASSIFICATION_VARIABLE = [
        'file' => [
            'varchar1',
            'varchar2',
            'varchar3',
            'varchar4',
            'varchar5',
            'varchar6',
            'varchar7',
            'varchar8',
            'varchar9',
            'varchar10',
            'varchar11',
            'varchar12',
            'varchar13',
            'varchar14',
            'varchar15',
            'varchar16',
            'varchar17',
            'varchar18',
            'varchar19',
            'varchar20',
        ],
        'provinsi' => [
            'varchar1',
            'varchar2',
            'varchar3',
            'varchar4',
            'varchar5',
            'varchar6',
            'varchar7',
            'varchar8',
            'varchar9',
            'varchar10',
            'varchar11',
            'varchar12',
            'varchar13',
            'varchar14',
            'varchar15',
            'varchar16',
            'varchar17',
            'varchar18',
            'varchar19',
            'varchar20',
        ],
        'kabkot' => [
            'varchar1',
            'varchar2',
            'varchar3',
            'varchar4',
            'varchar5',
            'varchar6',
            'varchar7',
            'varchar8',
            'varchar9',
            'varchar10',
            'varchar11',
            'varchar12',
            'varchar13',
            'varchar14',
            'varchar15',
            'varchar16',
            'varchar17',
            'varchar18',
            'varchar19',
            'varchar20',
        ],
        'text' => [
            'varchar1',
            'varchar2',
            'varchar3',
            'varchar4',
            'varchar5',
            'varchar6',
            'varchar7',
            'varchar8',
            'varchar9',
            'varchar10',
            'varchar11',
            'varchar12',
            'varchar13',
            'varchar14',
            'varchar15',
            'varchar16',
            'varchar17',
            'varchar18',
            'varchar19',
            'varchar20',
        ],
        'select' => [
            'varchar1',
            'varchar2',
            'varchar3',
            'varchar4',
            'varchar5',
            'varchar6',
            'varchar7',
            'varchar8',
            'varchar9',
            'varchar10',
            'varchar11',
            'varchar12',
            'varchar13',
            'varchar14',
            'varchar15',
            'varchar16',
            'varchar17',
            'varchar18',
            'varchar19',
            'varchar20',
        ],
        'number' => [
            'float1',
            'float2',
            'float3',
            'float4',
            'float5',
            'float6',
            'float7',
            'float8',
            'float9',
            'float10',
        ],
        'date' => [
            'date1',
            'date2',
            'date3',
            'date4',
            'date5',
            'date6',
            'date7',
            'date8',
            'date9',
            'date10',
        ],
    ];

    protected $fillable = [
        'id_template',
        'id_template_program_detail',
        'kolom',
        'tipe_kolom',
        'order_by',
        'label',
        'status',
        'is_required',
        'id_master_option',
        'created_by',
        'modified_by'
    ];

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

    public function masterOption(){
        return $this->belongsTo('App\Model\MasterOption', 'id_master_option');
    }

    public function getTypeAttribute(){
        switch ($this->tipe_kolom) {
            case 'text':
                return 'text';
                break;

            case 'provinsi':
                return 'text';
                break;

            case 'kabkot':
                return 'text';
                break;

            case 'file':
                return 'file';
                break;

            case 'number':
                return 'number';
                break;

            case 'select':
                return 'select';
                break;

            case 'date':
                return 'date';
                break;
        }
    }
}