shenying/app/dao/message/TemplateMessageDao.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\dao\message;


use app\dao\BaseDao;
use app\model\message\TemplateMessage;

/**
 * 模板消息
 * Class TemplateMessageDao
 * @package app\dao\message
 */
class TemplateMessageDao extends BaseDao
{
    /**
     * 设置模型
     * @return string
     */
    protected function setModel(): string
    {
        return TemplateMessage::class;
    }

    /**
     * 获取一条数据
     * @param array $where
     * @param string $filed
     * @param bool $is_search
     * @return array|\think\Model|null
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getTemplateOne(array $where, string $filed = '*', bool $is_search = true)
    {
        if ($is_search) {
            return $this->search($where)->field($filed)->find();
        } else {
            return $this->getModel()->where($where)->find();
        }
    }

    /**
     * 获取模板消息列表
     * @param array $where
     * @param int $page
     * @param int $limit
     * @return \think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getTemplateList(array $where, int $page, int $limit)
    {

        return $this->getModel()->when(isset($where['name']) && $where['name'] != '', function ($query) use ($where) {
            $query->where('name', 'LIKE', "%$where[name]%");
        })->when(isset($where['status']) && $where['status'] != '', function ($query) use ($where) {
            $query->where('status', $where['status']);
        })->where('type', $where['type'])->page($page, $limit)->select()->toArray();
    }

}