zyedu/application/admin/model/user/UserSign.php

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

namespace app\admin\model\user;

use traits\ModelTrait;
use basic\ModelBasic;


class UserSign extends ModelBasic
{
    use ModelTrait;

    public static function setWhere($where)
    {
        $model = self::alias('s')->join('User u', 's.uid=u.uid');
        if (isset($where['title']) && $where['title']) {
            $model = $model->where('s.uid|u.nickname', 'like', '%' . $where['title'] . '%');
        }
        return $model;
    }

    public static function getUserSignList($where)
    {

        $data = self::setWhere($where)->field('s.*,u.nickname')->page((int)$where['page'], (int)$where['limit'])->order('s.add_time DESC')->select();
        count($data) && $data = $data->toArray();
        foreach ($data as &$item) {
            $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
        }
        $count = self::setWhere($where)->count();
        return compact('data', 'count');
    }
}