123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210 |
- <?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\wap\model\user;
- use basic\ModelBasic;
- use service\WechatTemplateService;
- use think\Url;
- use traits\ModelTrait;
- use app\wap\model\routine\RoutineTemplate;
- use app\wap\model\merchant\Merchant as MerchantModel;
- use app\wap\model\merchant\MerchantBill;
- use service\SystemConfigService;
- /**佣金提现
- * Class UserExtract
- * @package app\wap\model\user
- */
- class UserExtract extends ModelBasic
- {
- use ModelTrait;
- //审核中
- const AUDIT_STATUS = 0;
- //未通过
- const FAIL_STATUS = -1;
- //已提现
- const SUCCESS_STATUS = 1;
- protected static $extractType = ['alipay', 'bank', 'weixin', 'yue'];
- protected static $extractTypeMsg = ['alipay' => '支付宝', 'bank' => '银行卡', 'weixin' => '微信', 'yue' => '余额'];
- public static function getPartnerTradeNoId()
- {
- $count = (int)self::where('add_time', ['>=', strtotime(date("Y-m-d"))], ['<', strtotime(date("Y-m-d", strtotime('+1 day')))])->count();
- return 'tk' . date('YmdHis', time()) . (10000 + $count + 1);
- }
- protected static $status = array(
- -1 => '未通过',
- 0 => '审核中',
- 1 => '已提现'
- );
- /**
- * 用户自主提现记录提现记录,后台执行审核
- * @param array $userInfo 用户个人信息
- * @param array $data 提现详细信息
- * @return bool
- */
- public static function userExtract($userInfo, $data)
- {
- if (!in_array($data['extract_type'], self::$extractType)) return self::setErrorInfo('提现方式不存在');
- $userInfo = User::get($userInfo['uid']);
- $extractPrice = $userInfo['brokerage_price'];
- if ($extractPrice < 0) return self::setErrorInfo('提现佣金不足' . $data['money']);
- if ($data['money'] > $extractPrice) return self::setErrorInfo('提现佣金不足' . $data['money']);
- if ($data['money'] <= 0) return self::setErrorInfo('提现佣金大于0');
- $balance = bcsub($userInfo['brokerage_price'], $data['money'], 2);
- if ($balance < 0) $balance = 0;
- $insertData = [
- 'uid' => $userInfo['uid'],
- 'extract_type' => $data['extract_type'],
- 'extract_price' => $data['money'],
- 'add_time' => time(),
- 'balance' => $balance,
- 'status' => self::AUDIT_STATUS
- ];
- if (isset($data['name']) && strlen(trim($data['name']))) $insertData['real_name'] = $data['name'];
- else $insertData['real_name'] = $userInfo['nickname'];
- if (isset($data['cardnum'])) $insertData['bank_code'] = $data['cardnum'];
- else $insertData['bank_code'] = '';
- if (isset($data['bankname'])) $insertData['bank_address'] = $data['bankname'];
- else $insertData['bank_address'] = '';
- if (isset($data['weixin'])) $insertData['wechat'] = $data['weixin'];
- else $insertData['wechat'] = $userInfo['nickname'];
- if ($data['extract_type'] == 'alipay') {
- if (!$data['alipay_code']) return self::setErrorInfo('请输入支付宝账号');
- $insertData['alipay_code'] = $data['alipay_code'];
- $mark = '使用支付宝提现' . $insertData['extract_price'] . '元';
- } else if ($data['extract_type'] == 'bank') {
- if (!$data['cardnum']) return self::setErrorInfo('请输入银行卡账号');
- if (!$data['bankname']) return self::setErrorInfo('请输入开户行信息');
- $mark = '使用银联卡' . $insertData['bank_code'] . '提现' . $insertData['extract_price'] . '元';
- } else if ($data['extract_type'] == 'weixin') {
- if (!$data['weixin']) return self::setErrorInfo('请输入微信账号');
- $mark = '使用微信提现' . $insertData['extract_price'] . '元';
- } else if ($data['extract_type'] == 'yue') {
- $mark = '使用余额提现' . $insertData['extract_price'] . '元';
- }
- self::beginTrans();
- try {
- $res1 = self::create($insertData);
- if (!$res1) return self::setErrorInfo('提现失败');
- $res2 = User::edit(['brokerage_price' => $balance], $userInfo['uid'], 'uid');
- $res3 = UserBill::expend('佣金提现', $userInfo['uid'], 'now_money', 'extract', $data['money'], $res1['id'], $balance, $mark);
- $res = $res2 && $res3;
- if ($res) {
- self::commitTrans();
- return true;
- } else return self::setErrorInfo('提现失败!');
- } catch (\Exception $e) {
- self::rollbackTrans();
- return self::setErrorInfo('提现失败!');
- }
- }
- /**
- * 用户自主提现记录提现记录,后台执行审核
- * @param array $userInfo 用户个人信息
- * @param array $data 提现详细信息
- * @return bool
- */
- public static function userMerExtract($userInfo, $data)
- {
- if (!$userInfo['business']) return self::setErrorInfo('您不是讲师,不能走讲师提现');
- if (!in_array($data['extract_type'], self::$extractType)) return self::setErrorInfo('提现方式不存在');
- $merchant = MerchantModel::where(['uid' => $userInfo['uid']])->find();
- $extractPrice = $merchant['now_money'];
- if ($extractPrice < 0) return self::setErrorInfo('您没有余额');
- if ($data['money'] > $extractPrice) return self::setErrorInfo('提现余额不足' . $data['money']);
- if ($data['money'] <= 0) return self::setErrorInfo('提现佣金大于0');
- $balance = bcsub($merchant['now_money'], $data['money'], 2);
- if ($balance < 0) $balance = 0;
- $insertData = [
- 'uid' => $merchant['uid'],
- 'mer_id' => $merchant['id'],
- 'extract_type' => $data['extract_type'],
- 'extract_price' => $data['money'],
- 'add_time' => time(),
- 'balance' => $balance,
- 'status' => self::AUDIT_STATUS
- ];
- if (isset($data['name']) && strlen(trim($data['name']))) $insertData['real_name'] = $data['name'];
- else $insertData['real_name'] = $merchant['mer_name'];
- if (isset($data['cardnum'])) $insertData['bank_code'] = $data['cardnum'];
- else $insertData['bank_code'] = '';
- if (isset($data['bankname'])) $insertData['bank_address'] = $data['bankname'];
- else $insertData['bank_address'] = '';
- if (isset($data['weixin'])) $insertData['wechat'] = $data['weixin'];
- else $insertData['wechat'] = $merchant['mer_name'];
- if ($data['extract_type'] == 'alipay') {
- if (!$data['alipay_code']) return self::setErrorInfo('请输入支付宝账号');
- $insertData['alipay_code'] = $data['alipay_code'];
- $mark = '使用支付宝提现' . $insertData['extract_price'] . '元';
- } else if ($data['extract_type'] == 'bank') {
- if (!$data['cardnum']) return self::setErrorInfo('请输入银行卡账号');
- if (!$data['bankname']) return self::setErrorInfo('请输入开户行信息');
- $mark = '使用银联卡' . $insertData['bank_code'] . '提现' . $insertData['extract_price'] . '元';
- } else if ($data['extract_type'] == 'weixin') {
- if (!$data['weixin']) return self::setErrorInfo('请输入微信账号');
- $mark = '使用微信提现' . $insertData['extract_price'] . '元';
- }
- self::beginTrans();
- try {
- $res1 = self::create($insertData);
- if (!$res1) return self::setErrorInfo('提现失败');
- $res2 = MerchantModel::edit(['now_money' => $balance], $merchant['id'], 'id');
- $res3 = MerchantBill::expend('余额提现', 0, $merchant['id'], 'now_money', 'extract', $insertData['extract_price'], $balance, $mark);
- $res = $res2 && $res3;
- if ($res) {
- self::commitTrans();
- return true;
- } else return self::setErrorInfo('提现失败!');
- } catch (\Exception $e) {
- self::rollbackTrans();
- return self::setErrorInfo('提现失败!');
- }
- }
- /**
- * 获得用户最后一次提现信息
- * @param $openid
- * @return mixed
- */
- public static function userLastInfo($uid)
- {
- return self::where(compact('uid'))->order('add_time DESC')->find();
- }
- /**
- * 获得用户提现总金额
- * @param $uid
- * @return mixed
- */
- public static function userExtractTotalPrice($uid)
- {
- return self::where('uid', $uid)->where('status', self::SUCCESS_STATUS)->value('SUM(extract_price)') ?: 0;
- }
- /**
- * 获得讲师提现总金额
- * @param $uid
- * @return mixed
- */
- public static function userMerExtractTotalPrice($mer_id)
- {
- return self::where('mer_id', $mer_id)->where('status', self::SUCCESS_STATUS)->value('SUM(extract_price)') ?: 0;
- }
- }
|