<?php

namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Collection;

class Column extends Model
{
    protected $table = 'columns';
    public function colshow(){
        return  $this->where('status','=','0')->select(
            'columnid','name','keys','rank','parentid','url','class','status'
        )->first();
    }
    public function rankshow($id,$colid){
        return $this->where([
            ['rank','=',$id],
            ['columnid','=',$colid]
        ])->select('name','id')->get();
    }

    public function colsave($data){
        return $this->insert([$data]);
    }

    public function colshows($id){
        return  $this->where([['status','=','0'],['columnid','=',$id]])->select(
            'id','name','keys','rank','parentid','url','class','status'
        )->get();
    }

    public function showrank($id){
        return  $this->where([['status','=','0'],['rank','=',$id]])->select(
            'id','name','keys','rank','parentid','url','class','status'
        )->get();
    }

    public function showall(){
        return  $this->where('status','=','0')->select(
            'id','name','keys','rank','parentid','url','class','status'
        )->get();
    }

    public function  updates($k,$data){
        return $this->where('id','=',$k)->update($data);
    }
    public function  updatess($k,$data,$parentid=0){
        return $this->where('id','=',$k)->update([$data,$parentid]);
    }
    public function  updates1($k,$data){
        return $this->where('id','=',$k)->update($data);
    }

    public function test($a=1,$result=array()){
        $result=$this->showrank($a);
        if (!$result->isEmpty()){
            $a++;
            $this->test($a);
        }
        return  $result;
    }

    public function showsel(){
        return $this->where('status','=','0')->select('id','name')->get();
    }

    public function showid($name){
        return $this->where('keys','=',$name)->select('id','type')->get();
    }

}