watercat_web/application/index/model/groupmodel.php

<?php
/**
 * Created by PhpStorm.
 * User: sicilon_IT
 * Date: 2021/10/7
 * Time: 22:55
 */
namespace app\index\model;

use think\Model;

class groupmodel extends Model
{
    protected $table = 't_groupinfo';

    /*
     * 20211007
     */
    public function insinfo($arr)
    {
        $this->setAttr('id', null)->isUpdate(false)->allowField(true)->save($arr);
        return $this->id;
    }
    public function getinfo($where)
    {
        $info = $this->where($where)->find();
        return $info;
    }
    /***
     * 获取列表数据
     * 20211012
     * wj
     */
    public function getList($where = [], $field = "*", $page = 1, $size = 10, $order = "id desc", $group = "", $row = false)
    {
        $sqlObj = $this->where($where);
        if ("count" != $field) {
            $sqlObj = $sqlObj->field($field)->order($order)->group($group)->page($page, $size);
            if ($row) {
                $data = $sqlObj->find();
            } else {
                $data = $sqlObj->select();
            }
        } else {
            $data = $sqlObj = $sqlObj->count();
        }
        return $data;
    }
    /***
     * 获取列表数据 join t_groupinfo
     * 20211012
     * wj
     */
    public function getpartinlist($where = [], $field = "*", $page = 1, $size = 10, $order = "id desc", $group = "", $row = false)
    {
        $sqlObj = $this->alias('g')->where($where)->join("t_groupuser gu", "gu.groupid=g.id", 'left');
        if ("count" != $field) {
            $sqlObj = $sqlObj->field($field)->order($order)->group($group)->page($page, $size);
            if ($row) {
                $data = $sqlObj->find();
            } else {
                $data = $sqlObj->select();
            }
        } else {
            $data = $sqlObj = $sqlObj->count();
        }
        return $data;
    }
}