watercat_web/application/index/model/evaluatemodel.php

<?php
/**
 * Created by PhpStorm.
 * User: sicilon_IT
 * Date: 2021/11/30
 * Time: 19:44
 */
namespace app\index\model;

use think\Model;

class evaluatemodel extends Model
{
    protected $table = 't_evaluate';

    public function insinfo($arr)
    {
        $this->setAttr('id', null)->isUpdate(false)->allowField(true)->save($arr);
        return $this->id;
    }

    /*
     * 20211130
     * steelxu
     */
    public function selinfobyuidetype($evaluateuserid, $etype)
    {
        $where_arr['evaluateuserid'] = $evaluateuserid;
        $where_arr['evaluatetype'] = $etype;
        $rec = $this->where($where_arr)->find();
        return $rec;

    }

    /***
     * pc后台 获取列表
     * 20211214
     * wj
     */
    public function getlistforadmin($where, $count = false, $page = 1, $size = 10)
    {
        $sql = "select e.*,u.wname,u.telno from t_evaluate as e join t_userinfo as u on u.id = e.evaluateuserid";
        $whereUse = [];
        if (isset($where['wname']) && !empty($where['wname']) && is_string($where['wname'])) {
            $whereUse['u.wname'] = "u.wname like '%" . $where['wname'] . "%'";
        }
        if (isset($where['telno']) && !empty($where['telno']) && is_numeric($where['telno'])) {
            $whereUse['u.telno'] = "u.telno like '%" . $where['telno'] . "%'";
        }
        if (isset($where['sourcetype']) && !empty($where['sourcetype']) && in_array($where['sourcetype'], [1, 2])) {
            $whereUse['e.sourcetype'] = "e.sourcetype = '" . $where['sourcetype'] . "'";
            if (isset($where['code']) && !empty($where['code']) && is_string($where['code'])) {
                switch ($where['sourcetype']) {
                    case 1:
                        $sql .= " join t_invent as i on i.id = e.sourceid";
                        $whereUse['i.code'] = "i.code like '%" . $where['code'] . "%'";
                        break;
                    case 2:
                        $sql .= " join t_jobhunting as j on j.id = e.sourceid";
                        $whereUse['j.id'] = "j.id like '%" . $where['code'] . "%'";
                        break;
                }
            }
        }
        if (isset($where['evaluatetype']) && in_array($where['evaluatetype'], [1])) {
            $whereUse['e.evaluatetype'] = "e.evaluatetype='" . $where['evaluatetype'] . "'";
        }
        if (isset($where['evaluatememo']) && !empty($where['evaluatememo']) && is_string($where['evaluatememo'])) {
            $whereUse['e.evaluatememo'] = "e.evaluatememo like '%" . $where['evaluatememo'] . "%'";
        }
        if (isset($where['e.evaluatetime']) && is_array($where['evaluatetime'])) {
            $whereUse['e.evaluatetime'] = "e.evaluatetime between '" . $where['evaluatetime'][0] . "' and '" . $where['evaluatetime'][1] . "'";
        }
        $whereStr = implode(' and ', $whereUse);
        if (!empty($whereStr)) {
            $sql .= ' where ' . $whereStr;
        }
        $sql .= ' order by id desc';
        if ($count) {
            $list = $this->query("select count(*) count from (" . $sql . ") as t");
            $count = $list[0]['count'];
            return $count;
        }
        $index = ($page - 1) * $size;
        $list = $this->query("select * from (" . $sql . ") as t limit " . $index . "," . $size);
        return $list;
    }
}