* @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; } }