xiaoshan/application/common/model/BillModel.php

<?php

namespace app\common\model;

use think\Db;
use think\Model;

/**
 * 群组
 */
class BillModel extends BaseModel
{
    // 表名
    protected $name = 'bill';
    // 开启自动写入时间戳字段
    protected $autoWriteTimestamp = false;
    // 定义时间戳字段名
    protected $createTime = false;
    protected $updateTime = false;
    protected $deleteTime = false;

    public function searchShopIdAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('shop_id', $value);
    }

    public function searchOrderNoAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('order_no', $value);
    }

    public function searchTableIdAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('table_id', $value);
    }
    public function searchTableNameAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('table_name', $value);
    }

    public function searchStatusAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('status', $value);
    }

    public function searchStatusInAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->whereIn('status', $value);
    }

    public function getArgsAttr($value, $data)
    {
        return json_decode($value, true);
    }

    public function hotelorder()
    {
        return $this->hasOne(HotelOrderModel::class, 'id', 'table_id');
    }

    public function hotelcanteenorder()
    {
        return $this->hasOne(HotelCanteenOrderModel::class, 'id', 'table_id');
    }

    public function offlineshoporder()
    {
        return $this->hasOne(OfflineShopOrderModel::class, 'id', 'table_id');
    }
}