jili2/application/common/model/PatrolForm.php

<?php
namespace app\common\model;

use think\Db;

class PatrolForm extends Base
{
    protected $createTime = 'create_time';
    protected $updateTime = 'update_time';
    public $table = 'patrol_form';
    protected $validateName = 'PatrolForm';
    public $type = [
        '选择框',
        '输入框'
    ];
    public function updates(){
        $data = request()->post();
        $data['org_id'] =cur_org_id();
        $result = validate($this->validateName)->check($data,[],'');
        if(true !== $result){
            $this->error = validate($this->validateName)->getError();
            return false;
        }
        $id = $data['id'];
        unset($data['id']);
        if($id > 0){
            $data['update_time'] = date('Y-m-d H:i:s');
            $ret = $this->allowField(true)->save($data,['id'=>$id]);
        }else{
            $data['create_time'] = date('Y-m-d H:i:s');
            $ret = $this->allowField(true)->save($data);
        }
        if(!$ret){
            $this->error = '操作失败';
            return false;
        }
        return true;
    }

    /**
     * 获取指定mode检查项
     *
     * @author wst
     * @date   2021/9/7 15:15
     * @return array
     */
    public function getByModeList($mode){
        $list =$this
            ->where('patrol_mode',$mode)
            ->where('org_id',cur_org_id())
            ->where('del',0)
            ->where('enable',1)
            ->select()
            ->toArray();
        return $list;
    }

    public function getByCateList($cate_id){
        if(empty($cate_id)){
           return [];

        }
        $where = '';
        foreach ($cate_id as $k=>$v){
            //$map[]=['','exp',Db::raw("FIND_IN_SET($v,cate_id)")];

            if($k>0){
                $where.='or ';
            }
            $where.='FIND_IN_SET('.$v.',cate_id)';
        }

        //
//        if($mode==4){
//            $map[] = ['cate_id','=',$cate_id];
//        }
        $list  = Db::name('patrol_form')
            ->where('org_id',cur_org_id())
            ->where('del',0)
            ->where('enable',1)
            //->where($map)
            ->whereRaw($where)
            ->select();
        return $list;
    }
}