AutoAssignCustomer.php

<?php

namespace App\Models;


use Illuminate\Database\Eloquent\Model;

class AutoAssignCustomer extends Model
{

    public $timestamps = false;
    protected $table = 'auto_assign_customer';

    const IS_NOW_YES = 1;
    const IS_NOW_NO = 0;

    public static function insertData($data)
    {
        return self::insertGetId($data);
    }

    //获取列表
    public static function getList()
    {
        $res = self::orderBy('sort', 'asc')->get();
        return ($res) ? $res->toArray() : [];
    }

    public static function getNowAssignInfo()
    {
        $res = self::where('is_now', self::IS_NOW_YES)->first();
        return ($res) ? $res->toArray() : [];
    }

    public static function getInfoByOrderSort($sort = 0)
    {
        $res = self::where('sort', ">", $sort)->orderBy("sort", "ASC")->first();
        return ($res) ? $res->toArray() : [];
    }

    public static function updateById($id, $update)
    {
        return self::where("id", $id)->update($update);
    }

    public static function updateAll($update)
    {
        return self::where([])->update($update);
    }

    public static function getInfoByDepartmentId($id)
    {
        $res = self::where('department_id', $id)->first();
        return ($res) ? $res->toArray() : [];
    }
}