jucai/app/Models/Category.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

/**
 * App\Models\Category
 *
 * @property int $id
 * @property string $alias 别名
 * @property string $demand 需求
 * @property string $category_name 分类名称
 * @property int $order 排序
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category query()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category whereAlias($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category whereCategoryName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category whereDemand($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category whereOrder($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Category whereUpdatedAt($value)
 * @mixin \Eloquent
 */
class Category extends Model
{
    protected $table = 'categorys';
    protected $guarded = [];

    public static function categoryType($type)
    {
        $arr = Category::select('id', 'demand')->where('alias', $type)->get()->toArray();
        $cateArr = [];
        foreach ($arr as $key => $value) {
            $cateArr[$value['id']] = $value['demand'];
        }
        return $cateArr;
    }

    public static function categoryTypeByDemand($type)
    {
        $arr = Category::select('id', 'demand')->where('alias', $type)->get()->toArray();
        $cateArr = [];
        foreach ($arr as $key => $value) {
            $cateArr[$value['demand']] = $value['id'];
        }
        return $cateArr;
    }

    static function getTableName()
    {
        $cate = new Category();
        return $cate->getTable();
    }

}