<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use \App\Models\traits\SetConnection;

class MstLine extends Model
{
    protected $guarded = [];

    use SetConnection;

    const CREATED_AT = null;
    const UPDATED_AT = null;

    //
    public static function getDataAll()
    {
        $res = MstLine::get()->toArray();
        return $res;
    }
    public static function getData()
    {
        $res = MstLine::ownCompany()->orderBy('id', 'ASC')->get();
        $arrResult = array();
            foreach($res as $row){
                 $arrResult[] = ['code' => $row->id, 'name' => $row->name];
            }
        return $arrResult;
    }

    public static function getDataById($id)
    {
        $res = MstLine::where('id', '=', $name)->first();
        return $res;
    }

    public static function getDataByName($name)
    {
        $res = MstLine::where('name', 'LIKE', '%'.$name.'%')->first();
        return $res;
    }

    public function scopeOwnCompany($query)
    {
        return $query->where("company_id", auth()->user()->company_id);
    }

    public static function convertLineName($name) {
        if ($name == '湖西線') {
            $name = 'JR湖西線';
        }

        if ($name == '東海道線') {
            $name = 'JR東海道・山陽本線';
        }

        if ($name == '奈良線') {
            $name = 'JR奈良線';
        }

        if ($name == '山陰線') {
            $name = 'JR山陰本線・嵯峨野線';
        }

        if ($name == '京都市営地下鉄東西線') {
            $name = '京都地下鉄東西線';
        }

        if ($name == '京都市営地下鉄烏丸線') {
            $name = '京都地下鉄烏丸線';
        }

        if ($name == '京福電鉄嵐山本線') {
            $name = '京福嵐山本線';
        }

        if ($name == '京福電鉄北野線') {
            $name = '京福北野本線';
        }

        if ($name == '嵯峨野観光鉄道') {
            $name = '嵯峨野観光線';
        }

        return $name;
    }
}