// +---------------------------------------------------------------------- namespace App\Services\Common; use App\Models\CapitalLogModel; use App\Models\MemberModel; use App\Models\UserModel; use App\Services\BaseService; /** * 资产交易明细-服务类 * Class CapitalLogService * @package App\Services\Common */ class CapitalLogService extends BaseService { // 静态对象 protected static $instance = null; /** * 构造函数 * @since 2020/11/10 * CapitalLogService constructor. */ public function __construct() { $this->model = new CapitalLogModel(); $this->userModel = new UserModel(); $this->memberModel = new MemberModel(); } /** * 静态入口 * @return static|null */ public static function make() { if (!self::$instance) { self::$instance = (new static()); } return self::$instance; } // 保证金缴纳/退保 public function edit() { $data = request()->all(); $id = isset($data['id'])? $data['id'] : 0; $userId = isset($data['user_id'])? $data['user_id'] : 0; $money = isset($data['num'])? floatval($data['num']) : 0; if($userId<=0){ return returnJson('承兑商用户参数错误,请刷新后重试'); } if($money<=0){ return returnJson('请输入正确的金额'); } $info = $this->userModel->getInfo($id); if(empty($info) || empty($info['user_id'])){ return returnJson('用户不存在'); } if($info['user_type'] != 2){ returnJson('用户类型错误,非承兑商用户'); } $changeType = isset($data['change_type'])? $data['change_type'] : 0; $changeType = $changeType==1? $changeType : 2; if($changeType==2 && $info['bond'] < $money){ return returnJson('退保金额超出账户保证金余额:'.$info['bond']); } $data = [ 'order_no'=> get_order_num('CT'), 'user_id'=> $info['user_id'], 'num'=> $money, 'type'=> 8, 'change_type'=> $changeType, 'trade_type'=> 4, 'total'=> $money, 'create_time'=> isset($data['datetime'])&&$data['datetime']? strtotime($data['datetime']) : time(), 'balance'=> $changeType==2? ($info['bond'] - $money) : ($info['bond']+ $money), 'remark'=> isset($data['remark'])? $data['remark'] : '', ]; $result = parent::edit($data); $success = isset($result['success'])? $result['success'] : false; if($success){ if($changeType == 1){ $this->userModel->where(['id'=> $id])->increment('bond', $money); }else{ $this->userModel->where(['id'=> $id])->decrement('bond', $money); } } return $result; } /** * 获取列表 * @param $params 参数 * @param int $pageSize 分页大小:默认 15 * @return array */ public function getDataList($params, $pageSize = 15) { $where = ['a.mark' => 1]; $type = isset($params['type'])? $params['type'] : 0; $changeType = isset($params['change_type'])? $params['change_type'] : 0; $userId = isset($params['user_id'])? $params['user_id'] : 0; if($type>0){ $where['a.type'] = $type; } if($changeType>0){ $where['a.change_type'] = $changeType; } if($userId>0){ $where['a.user_id'] = $userId; } $list = $this->model->from('capital_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}%"); } // 日期 $date = isset($params['date']) ? $params['date'] : []; $start = isset($date[0])? $date[0] : ''; $end = isset($date[1])? $date[1] : ''; $end = $start>=$end? '' : $end; if ($start) { $query->where('a.create_time','>=', strtotime($start)); } if($end){ $query->where('a.create_time','<', strtotime($end)); } }) ->select(['a.*', 'm.username']) ->orderBy('a.create_time','desc') ->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'] : [] ]; } }