huizhen/app/admin/model/user/UserCard.php

<?php

/**
 *
 * @author: xaboy<365615158@qq.com>
 * @day: 2017/11/02
 */

namespace app\admin\model\user;

use app\admin\model\store\StoreProduct;
use app\admin\model\system\SystemAdmin;
use app\models\article\ArticleContent;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;

/**
 * 图文管理 Model
 * Class WechatNews
 * @package app\admin\model\wechat
 */
class UserCard extends BaseModel
{

    use ModelTrait;

    protected $pk = 'id';

    protected $name = 'user_card';

    protected $autoWriteTimestamp = true;

    public static function list($where)
    {
        $model = self::alias('a')
            ->field('a.*,b.nickname,c.name')
            ->leftJoin('user b', 'a.uid = b.uid')
            ->leftJoin('card c', 'c.id = a.card_id')
            ->order('a.id DESC');

        if ($where['name'])$model->where('b.nickname|a.uid' , 'like', '%'.$where['name'].'%');
        if ($where['status']){
            if ($where['status'] == 1) $model->where('a.status', 0);
            if ($where['status'] == 2) $model->where('a.status', 1);
        }
        if ($where['use']){
            if ($where['use'] == 1) $model->where('a.use', 0);
            if ($where['use'] == 2) $model->where('a.use', 1);
            if ($where['use'] == 3) $model->where('a.use', -1);
        }


        $data['count'] = $model->count();
        if ($where['page'] && $where['limit']){
            $model->page($where['page'], $where['limit']);
        }else{
            $model->page(20, 1);
        }
        $list = $model->select()->toArray();
        foreach ($list as &$item)
        {
            if ($item['start_time'] == 0){
                $item['start_time'] = '未使用';
            }else{
                $item['start_time'] = date('Y-m-d H:i:s', $item['start_time']);
            }

            if ($item['end_time'] == 0){
                $item['end_time'] = '未使用';
            }else{
                $item['end_time'] = date('Y-m-d H:i:s', $item['end_time']);
            }

        }

        $data['data'] = $list;
        return $data;

    }
}