// +---------------------------------------------------------------------- namespace App\Services\Common; use App\Models\CoinLogModel; use App\Services\BaseService; use App\Services\RedisService; /** * 币种明细(提币、存币)-服务类 * Class CoinLogService * @package App\Services\Common */ class CoinLogService extends BaseService { // 静态对象 protected static $instance = null; /** * 构造函数 * @since 2020/11/10 * CoinLogService constructor. */ public function __construct() { $this->model = new CoinLogModel(); } /** * 静态入口 * @return static|null */ public static function make() { if (!self::$instance) { self::$instance = (new static()); } return self::$instance; } /** * 获取列表 * @param $params 参数 * @param int $pageSize 分页大小:默认 15 * @return array */ public function getDataList($params, $pageSize = 15) { $where = ['a.mark' => 1]; $type = isset($params['type'])? $params['type'] : 1; $changeType = isset($params['change_type'])? $params['change_type'] : 1; $contactType = isset($params['contact_type'])? $params['contact_type'] : 1; $coinType = isset($params['coin_type'])? $params['coin_type'] : 1; $userId = isset($params['user_id'])? $params['user_id'] : 0; if($type>0){ $where['a.type'] = $type; } if($contactType>0){ $where['a.contact_type'] = $contactType; } if($changeType>0){ $where['a.change_type'] = $changeType; } if($coinType>0){ $where['a.coin_type'] = $coinType; } if($userId>0){ $where['a.user_id'] = $userId; } $list = $this->model->from('coin_logs as a') ->leftJoin('member as m', 'm.id', '=', 'a.user_id') ->where($where) ->where(function ($query) use($params){ $keyword = isset($params['keyword'])? $params['keyword'] : ''; if($keyword){ $query->where('a.order_no','like',"{$keyword}")->orWhere('m.username','like',"%{$keyword}%"); } }) ->select(['a.*', 'm.username']) ->paginate($pageSize > 0 ? $pageSize : 9999999); $list = $list? $list->toArray() :[]; if($list){ foreach($list['data'] as &$item){ $item['time_text'] = $item['create_time']? datetime(strtotime($item['create_time']), 'm-d H:i'):''; } } return [ 'pageSize'=> $pageSize, 'total'=>isset($list['total'])? $list['total'] : 0, 'list'=> isset($list['data'])? $list['data'] : [] ]; } /** * 验证是否存在 * @param \App\Services\字段名 $field * @param \App\Services\字段值 $value * @param string $pk * @return mixed */ public function checkExists($field, $value, $pk = 'id') { $cacheKey = "caches:coinLogs:exists:{$field}_{$value}"; if($result = RedisService::get($cacheKey)){ return $result; } $result = parent::checkExists($field, $value, $pk); if($result){ RedisService::set($cacheKey, $result, rand(3,5)); } return $result; } }