<?php

namespace App\Models;

use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * b端控制， c端显示的导航
 * @author：dc
 * @time 2023/5/8 16:14
 * Class BNav
 * @package App\Models
 */
class BNav extends Base
{

    protected $table = 'gl_web_nav';

    use SoftDeletes;

    public $hidden = ['deleted_at','project_id'];


    /**
     * 显示
     */
    const STATUS_ACTIVE = 1;

    /**
     * 隐藏
     */
    const STATUS_DISABLED = 0;



    /**
     * 查询当前项目下的所有栏目信息
     * @param int $project_id
     * @return mixed
     * @author：dc
     * @time 2023/5/8 16:29
     */
    public static function _all(int $project_id, string $location = null)
    {
        return static::where(function ($query) use ($project_id,$location){
            // 那个公司
            $query->where('project_id',$project_id);
            // 显示位置
            $location && $query->where('location',$location);
        })
            ->orderBy('sort')
            ->get();
    }




    /**
     * 是否有下级
     * @param int $id
     * @param int $project_id
     * @return mixed
     * @author：dc
     * @time 2023/5/9 9:23
     */
    public static function isChild(int $id,int $project_id=0)
    {
        return static::where(['pid'=>$id,'project_id'=>$project_id])->limit(1)->count();
    }
}