public function actionIndex() { $uid = Yii::$app->user->id; $isAuthentic = member::isAuthentic(yii::$app->user->id); if ($isAuthentic['errorNum'] != 0) { header("Content-type: text/html; charset=utf-8"); echo "<script>alert('您还没有实名制认证')</script>"; echo "<script>window.location.href='" . \yii\helpers\Url::to(['site/step2']) . "'</script>"; exit; } //判断用户是否绑定银行卡 $is_bind = sinapay::isBinding($uid); $model = UcenterMember::find()->where(['id' => $uid])->one(); if ($is_bind['errorNum'] != 0) { header("Content-type: text/html; charset=utf-8"); echo "<script>alert('您还没有绑定银行卡');</script>"; echo "<script>location.href='" . \yii\helpers\Url::to(['site/bindcard']) . "'</script>"; exit; } $limitConfig = sinapay::getsiteConfig(); if ($limitConfig) { $ransom_max = $limitConfig->ransom_max; $ransom_min = $limitConfig->ransom_min; $ransom_times = $limitConfig->ransom_num; } $collect = AloneMethod::user_collect($uid)[data]; //在投金额和在投收益 $red_packet = member::get_user_red_packet($uid)[data]; //个人账户 $model_asset = Info::find()->where('member_id=' . Yii::$app->user->id)->one(); //投资总额 $invest_total = 0; $model_order = Order::find()->where('member_id=' . Yii::$app->user->id . " AND status=1")->all(); if (count($model_order) > 0) { foreach ($model_order as $K => $V) { $invest_total += $V->money; } } $invest_total += $model_asset->profit; return $this->view('index', compact('invest_total', 'ransom_max', 'ransom_min', 'ransom_times', 'collect', 'red_packet')); }
/** * Authre:langxi * * 用户赎回操作 */ public static function User_redeem($member_id, $money, $update = 0) { ini_set('max_execution_time', 60); //判断用户是否可进行赎回操作 $is_go = Info::find()->select(['status'])->where(['member_id' => $member_id])->asArray()->one(); if ($is_go['status'] > 0) { $result = array('errorNum' => '1', 'errorMsg' => '处理中,请稍后再试', 'data' => null); return $result; } Info::updateAll(['status' => Info::GO_THREE], ['member_id' => $member_id]); //进行操作,状态变为处理中 //检查用户一日赎回 $check_redeem = self::check_redeem($member_id, $money); if ($check_redeem) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); // $result = array('errorNum' => '1', 'errorMsg' => $check_redeem, 'data' => null); return $check_redeem; } //判断赎回金额是否小于新浪账户与网站账户余额的差值,若小于则网站端进行赎回操作,先赎回利息,然后赎回订单中的金额。 //若大于求取差值获取到网站需要赎回的金额和新浪部分需要赎回的金额,然后两端分别进行赎回操作,先赎回利息,然后赎回订单中的金额 $asset = Info::find()->where(['member_id' => $member_id])->asArray()->one(); $bank_card = $asset['bank_card']; //获取用户在投收益 $profit = $asset['profit']; //判断用户赎回金额是否可赎回。 $order_money = (new \yii\db\Query())->select(['money'])->from('fund_orders')->where(['member_id' => $member_id])->andWhere(['>', 'money', '0'])->sum('money'); //增加了活动红包begin if ($update) { $red_money = member::get_user_red_packet($member_id, $update); if (!$red_money['errorNum']) { $red = $red_money['data']['red_sum']; $order_money = $order_money + $red; } } ////活动红包end if ($order_money + $profit < $money) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '1', 'errorMsg' => '赎回金额大于可赎回金额,请重新输入', 'data' => null); return $result; } $w_blance = self::showBlance($member_id); //网站余额 $s_blance = sinapay::querySinaBalance($member_id); //调用第三方接口查看新浪账户可用余额(含货币基金 if ($s_blance['errorNum']) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '1', 'errorMsg' => $s_blance['errorMsg'], 'data' => null); return $result; } if ($w_blance > $s_blance['data']['available_balance']) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '1', 'errorMsg' => '账户异常请联系客服', 'data' => null); return $result; } $m_fund = $s_blance['data']['available_balance'] - $w_blance; //新浪账户比网站账户多的钱--新浪的货币基金 $red_packet = 0; $red = 0; //如果赎回和活动红包有关系 TODO if ($update) { //赎回时必须有在投金额 $invest = $asset['invest']; if ($invest && $invest >= 1) { //获取那个时间点的金额 $red_money = member::get_user_red_packet($member_id, $update); if (!$red_money['errorNum']) { $red = $red_money['data']['red_sum']; if ((double) $red > (double) $money) { //如果只是提取一部分红包 $return = array('errorNum' => '1', 'errorMsg' => '红包必须全部赎回', 'data' => null); return $return; } } else { $return = array('errorNum' => '1', 'errorMsg' => $red_money['errorMsg'], 'data' => null); return $return; } } } //应该扣除红包的金额 $red_packet = $red; //$m_fund ---新浪的货币基金 //货币基金大于用户要赎回的资金--发上几率比较小 if ($m_fund > $money) { //事物回滚 $transaction = \Yii::$app->db->beginTransaction(); try { //赎回金额小于新浪账户与网站账户的差值,仅网站端进行赎回操作 $profit = (new \yii\db\Query())->select(['profit'])->from('asset_info')->where(['member_id' => $member_id])->one(); //TODO --添加了红包++++++$red_packet; $profit = $profit['profit'] + $red_packet; //用户的可用收益 // money 减去红包 if ($money <= $profit) { // 红包表的处理 if ($update) { $info = Info::findOne($member_id); $info->profit = $info['profit'] + $red_packet; $info = $info->save(); if (!$info) { throw new ErrorException('红包赎回失败', 6001); } $flag = member::draw_red_packet($member_id, $update); if ($flag['errorNum']) { throw new ErrorException('红包赎回失败', 6001); } } //赎回金额小于等于用户可用收益 $info = Info::findOne($member_id); $info->profit = $info['profit'] - $money; $info = $info->save(); if (!$info) { throw new ErrorException('赎回失败', 6001); } $info = Info::findOne(['member_id' => $member_id]); $info->balance = $info->balance + $money; $info = $info->save(); if (!$info) { throw new ErrorException('赎回金额放入余额失败', 4002); } //由网站设定好的支付利息的账户进行利息支付 $sina_config = SinaConfig::find()->select(['sinapay_give_accrual'])->asArray()->one(); $profit_id = $sina_config['sinapay_give_accrual']; $profit_info = Info::findOne($profit_id); $profit_info->balance = $profit_info['balance'] - $money; $profit_info = $profit_info->save(); if (!$profit_info) { throw new ErrorException('支付利息账户资金减少失败'); } //写入职员账户记录表中 $clerk = new ClerkLog(); $clerk->member_id = $member_id; $clerk->clerk_id = $profit_id; $clerk->behav = ClerkLog::CLERK_BEHAV_TWO; $clerk->step = $money; $clerk->remark = '支付利息职员'; $clerk = $clerk->save(); if (!$clerk) { throw new ErrorException('写入职员账户记录失败'); } //赎回成功进行提现记录 $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RSUCCEED; //赎回成功 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回成功'; $assetlog->save(); } else { //赎回金额大于用户可用收益 $info = Info::findOne($member_id); $info->profit = 0; $info = $info->save(); if (!$info) { throw new ErrorException('赎回收益失败', 6001); } if ($update) { $flag = member::draw_red_packet($member_id, $update); if ($flag['errorNum']) { throw new ErrorException('红包赎回失败', 6001); } } //由网站设定好的支付利息的账户进行利息支付 $sina_config = SinaConfig::find()->select(['sinapay_give_accrual'])->asArray()->one(); $profit_id = $sina_config['sinapay_give_accrual']; $profit_info = Info::findOne($profit_id); $profit_info->balance = $profit_info['balance'] - $profit; $profit_info = $profit_info->save(); if (!$profit_info) { throw new ErrorException('支付利息账户资金减少失败'); } //写入职员账户记录表中 $clerk = new ClerkLog(); $clerk->member_id = $member_id; $clerk->clerk_id = $profit_id; $clerk->behav = ClerkLog::CLERK_BEHAV_TWO; $clerk->step = $profit; $clerk->remark = '支付利息职员'; $clerk = $clerk->save(); if (!$clerk) { throw new ErrorException('写入职员账户记录失败'); } $redeem_money = $money - $profit; // TODO $Redeem = self::Redeem($member_id, $redeem_money); if (!$Redeem) { throw new ErrorException('生成赎回字典失败', 4002); } else { $Redeem = self::Set_redeem($Redeem); if (!$Redeem) { throw new ErrorException('赎回失败'); } else { $info = Info::findOne(['member_id' => $member_id]); $info->balance = $info->balance + $money; $info->invest = $info['invest'] - $redeem_money; $info = $info->save(); if (!$info) { throw new ErrorException('赎回金额放入余额失败', 4002); } //赎回成功进行提现记录 $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $redeem_money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RSUCCEED; //赎回成功 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回成功'; $assetlog->save(); } } } $transaction->commit(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => null); return $result; } catch (\Exception $e) { $transaction->rollBack(); //对提现失败信息进行记录 $remark = $e->getMessage(); \Yii::error($e->getTraceAsString(), 'app'); $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RERROR; //赎回失败 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回失败' . $remark; $assetlog->save(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '1', 'errorMsg' => $remark, 'data' => null); return $result; } } else { //赎回金额大于新浪账户与网站账户的差值,取得新浪端赎回金额,网站与新浪都进行赎回操作 //---新浪货币基金不足以支撑赎回操作---$s_money ---除去新浪货币基金后要进行的赎回金额 $s_money = $money - $m_fund; //新浪端赎回金额 $profit = (new \yii\db\Query())->select(['profit'])->from('asset_info')->where(['member_id' => $member_id])->one(); $profit = $profit['profit']; //用户的可用收益 ///进行收益的赎回----假定把红包加到用户收益内 //++++用户收益足以满足用户的赎回操作---用户直接赎回投资的收益就可以了 if ($s_money <= $profit + $red_packet) { //事物回滚 赎回收益 $transaction = \Yii::$app->db->beginTransaction(); try { //红包处理---加用户收益 TODO if ($update) { $info = Info::findOne($member_id); $info->profit = $info['profit'] + $red_packet; $info = $info->save(); if (!$info) { throw new ErrorException('红包赎回失败', 6001); } $flag = member::draw_red_packet($member_id, $update); if ($flag['errorNum']) { throw new ErrorException('红包赎回失败', 6001); } } //用户收益足以满足用户的赎回操作---用户直接赎回投资的收益就可以了 $info = Info::findOne($member_id); $info->profit = $info['profit'] - $s_money; $info = $info->save(); if (!$info) { throw new ErrorException('赎回失败', 6001); } //用户只是赎回在投收益---网站给只利息就行了 $sina_config = SinaConfig::find()->select(['sinapay_give_accrual'])->asArray()->one(); $profit_id = $sina_config['sinapay_give_accrual']; $profit_info = Info::findOne($profit_id); $profit_info->balance = $profit_info['balance'] - $s_money; $profit_info = $profit_info->save(); if (!$profit_info) { throw new ErrorException('支付利息账户资金减少失败'); } //写入职员账户记录表中 $clerk = new ClerkLog(); $clerk->member_id = $member_id; $clerk->clerk_id = $profit_id; $clerk->behav = ClerkLog::CLERK_BEHAV_TWO; $clerk->step = $money; $clerk->remark = '支付利息职员'; $clerk = $clerk->save(); if (!$clerk) { throw new ErrorException('写入职员账户记录失败'); } //--网站账户处理成功了----调用第三方新浪接口赎回收益 $sina_ransom = sinapay::giveInterest($member_id, $s_money); //赎回收益 if ($sina_ransom['errorNum']) { throw new ErrorException($sina_ransom['errorMsg'], 7002); } //更新网站中账户的余额和收益---涉及到货币基金--用户更新数据用$money---实际给付是$s_money $info = Info::findOne(['member_id' => $member_id]); $info->balance = $info->balance + $money; $info = $info->save(); if (!$info) { throw new ErrorException('赎回金额放入余额失败', 4002); } //赎回成功进行赎回记录 $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RSUCCEED; //赎回成功 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回成功'; $assetlog->save(); $transaction->commit(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => null); return $result; } catch (\Exception $e) { $transaction->rollBack(); //对提现失败信息进行记录 $remark = $e->getMessage(); \Yii::error($e->getTraceAsString(), 'app'); $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RERROR; //赎回失败 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回失败' . $remark; $assetlog->save(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '1', 'errorMsg' => $remark, 'data' => null); return $result; } } else { //用户的赎回金额大于用户可用收益---需要进行债权赎回操作 $rh_money = 0; //赎回金额 //如果有活动红包奖励--进行红包加到收益里操作 //收益大于0,首先赎回收益 if ($profit + $red_packet > 0) { //事物回滚 赎回收益 $transaction = \Yii::$app->db->beginTransaction(); try { //红包操作---增加用户的账户再投收益 $profit = $profit + $red_packet; if ($update) { $flag = member::draw_red_packet($member_id, $update); if ($flag['errorNum']) { throw new ErrorException('红包赎回失败', 6001); } } //$s_money 是大于用户当前账户中的再投收益的--已经怎加活动奖励红包 $info = Info::findOne($member_id); $info->profit = 0; $info = $info->save(); if (!$info) { throw new ErrorException('赎回收益失败', 6001); } //由网站设定好的支付利息的账户进行利息支付---再投收益全部赎回了 $sina_config = SinaConfig::find()->select(['sinapay_give_accrual'])->asArray()->one(); $profit_id = $sina_config['sinapay_give_accrual']; $profit_info = Info::findOne($profit_id); $profit_info->balance = $profit_info['balance'] - $profit; $profit_info = $profit_info->save(); if (!$profit_info) { throw new ErrorException('支付利息账户资金减少失败'); } //写入职员账户记录表中 $clerk = new ClerkLog(); $clerk->member_id = $member_id; $clerk->clerk_id = $profit_id; $clerk->behav = ClerkLog::CLERK_BEHAV_TWO; $clerk->step = $profit; $clerk->remark = '支付利息职员'; $clerk = $clerk->save(); if (!$clerk) { throw new ErrorException('写入职员账户记录失败'); } $info = Info::findOne(['member_id' => $member_id]); $info->balance = $info->balance + $profit; $info = $info->save(); if (!$info) { throw new ErrorException('赎回收益放入余额失败', 4002); } $sina_ransom = sinapay::giveInterest($member_id, (string) $profit); //调用第三方接口赎回收益 if ($sina_ransom['errorNum']) { throw new ErrorException($sina_ransom['errorMsg'], 7002); } //记录用户的赎回金额 $rh_money = $profit; $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); //对提现失败信息进行记录 $remark = $e->getMessage(); \Yii::error($e->getTraceAsString(), 'app'); $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RERROR; //赎回失败 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回失败' . $remark; $assetlog->save(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '1', 'errorMsg' => $remark, 'data' => null); return $result; } } //用户已经赎回了所有的再投收益---计算还需要进行多少的债权赎回操作 $money = $money - $profit; $redeem_dic = self::Redeem($member_id, $money); //获取债权字典--进行债权的赎回操作 foreach ($redeem_dic as $k => $v) { if ($v['thirdmoney'] == 0) { continue; } //事物回滚 $transaction = \Yii::$app->db->beginTransaction(); try { //网站赎回部分 //order表金额赎回 $order = Order::findOne($v['order_id']); $order->money = $order['money'] - $v['thirdmoney']; if ($order['money'] == '0') { $order->status = Order::STATUS_DELETE; } $order = $order->save(); if (!$order) { throw new ErrorException('赎回转让债权失败'); } //thirdorder表金额赎回 $thirdorder = Thirdorder::findOne($v['thirdorder_id']); $thirdorder->money = $thirdorder['money'] - $v['thirdmoney']; if ($thirdorder['money'] == '0') { $thirdorder->status = Thirdorder::STATUS_DELETED; } $thirdorder->mcmoney = $thirdorder['mcmoney'] + $v['thirdmoney']; //用户赎回,最大债权人支付此金额,记录 $thirdorder->ocmoney = $thirdorder['ocmoney'] - $v['thirdmoney']; //用户赎回,原始债权人金额减少,记录 $thirdorder = $thirdorder->save(); if (!$thirdorder) { throw new ErrorException('赎回第三方转让债权失败'); } //thirdproduct第三方债权已投金额减少 $thirdproduct = Thirdproduct::findOne($v['thirdproduct_id']); $thirdproduct->invest_sum = $thirdproduct['invest_sum'] - $v['thirdmoney']; $thirdproduct->mcmoney = $thirdproduct['mcmoney'] + $v['thirdmoney']; //赎回导致最大债权人金额增加 $thirdproduct = $thirdproduct->save(); if (!$thirdproduct) { throw new ErrorException('赎回第三方债权已投金额失败'); } //获取债权的最大债权人id,将用户赎回的钱从最大债权人的账户中减去 $maxcreditor = Thirdproduct::find()->select(['maxcreditor'])->where(['id' => $v['thirdproduct_id']])->asArray()->one(); $maxcreditor = $maxcreditor['maxcreditor']; $is_max = Catmiddle::find()->where(['cid' => '1', 'uid' => $maxcreditor])->asArray()->one(); if (!$is_max) { throw new ErrorException('最大债权人异常'); } $max_info = Info::findOne($maxcreditor); $max_info->balance = $max_info['balance'] - $v['thirdmoney']; $max_info = $max_info->save(); if (!$max_info) { throw new ErrorException('消减最大债权人账户金额失败'); } //写入职员账户记录表中 $clerk = new ClerkLog(); $clerk->member_id = $member_id; $clerk->clerk_id = $maxcreditor; $clerk->behav = ClerkLog::CLERK_BEHAV_TWO; $clerk->step = $v['thirdmoney']; $clerk->remark = '最大债权人'; $clerk = $clerk->save(); if (!$clerk) { throw new ErrorException('写入职员账户记录失败'); } //新浪赎回部分??? $k_money = $s_money - $v['thirdmoney']; //赎回金额 if ($k_money > 0) { $s_money = $k_money; //获取最大债权人 $maxcreditor = (new \yii\db\Query())->select(['maxcreditor'])->from('fund_thirdproduct')->where(['id' => $v['thirdproduct_id']])->one(); $maxcreditor = $maxcreditor['maxcreditor']; //调用第三方新浪接口赎回 // $money_sina = sprintf("%.2f", $v['thirdmoney']); if ($money_sina > 0) { $sina_ransom = sinapay::sinaRansom($member_id, $money_sina, $maxcreditor); //暂定38为支付利息的用户id if ($sina_ransom['errorNum']) { throw new ErrorException($sina_ransom['errorMsg'], 7002); } } $info = Info::findOne(['member_id' => $member_id]); $info->balance = $info->balance + $v['thirdmoney']; $info->invest = $info['invest'] - $v['thirdmoney']; $info = $info->save(); if (!$info) { $money_log = $money - $s_money + $v['thirdmoney']; throw new ErrorException('成功赎回' . $money_log . '元', 4002); } $rh_money = $rh_money + $v['thirdmoney']; //赎回金额 } else { //获取最大债权人 $maxcreditor = (new \yii\db\Query())->select(['maxcreditor'])->from('fund_thirdproduct')->where(['id' => $v['thirdproduct_id']])->one(); $maxcreditor = $maxcreditor['maxcreditor']; //调用第三方新浪接口赎回 $money_sina = sprintf("%.2f", $s_money); if ($money_sina) { $sina_ransom = sinapay::sinaRansom($member_id, $money_sina, $maxcreditor); //暂定38为支付利息的用户id if ($sina_ransom['errorNum']) { throw new ErrorException($sina_ransom['errorMsg'], 7002); } } $info = Info::findOne(['member_id' => $member_id]); $info->balance = $info->balance + $s_money + $m_fund; $info->invest = $info['invest'] - $s_money - $m_fund; $info = $info->save(); if (!$info) { $money_log = $money - $s_money + $m_fund; throw new ErrorException('赎回' . $money_log . '元', 4002); } $rh_money = $rh_money + $s_money + $m_fund; //赎回金额 } $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); //对提现失败信息进行记录 $remark = $e->getMessage(); \Yii::error($e->getTraceAsString(), 'app'); $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $s_money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RERROR; //赎回失败 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回失败' . $remark; $assetlog->save(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); $result = array('errorNum' => '1', 'errorMsg' => $remark, 'data' => null); return $result; break; } } $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $rh_money; $assetlog->action = 'Withdrawals/Redeem'; $assetlog->status = self::RSUCCEED; //赎回成功 $assetlog->bankcard = $bank_card; $assetlog->remark = '赎回' . $rh_money . '元'; //赎回金额 $assetlog->save(); } Info::updateAll(['status' => '0'], ['member_id' => $member_id]); //赎回结束,操作状态变回常态 $result = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => null); return $result; } }
/** * 获取用户当前红包金额 * @return array|string */ public static function actionGetuserredpacket() { $result = App::AppGet(); try { if ($result['errorNum']) { $result = array('errorNum' => $result['errorNum'], 'errorMsg' => $result['errorMsg'], 'data' => null); } else { $data = $result['data']; if (array_key_exists('uid', $data)) { $uid = $data['uid']; $result = member::get_user_red_packet($uid); } else { $result = array('errorNum' => '1', 'errorMsg' => '参数错误', 'data' => null); } } } catch (ErrorException $e) { Yii::error(" 获取轮播图---异常 方法:actionGetuserredpacket 参数:" . json_encode($result['data']), "app"); Yii::trace($e->getMessage(), "app"); $result = array('errorNum' => '7', 'errorMsg' => '服务器异常,请联系管理员', 'data' => null); } $result = App::AppReturn($result); return $result; }
public function actionExportuser() { $users = UcenterMember::find()->asArray()->all(); $data = array(); if ($users !== null) { foreach ($users as $key => $value) { $data[$key]['id'] = $value['id']; $data[$key]['phone'] = $value['phone']; $data[$key]['real_name'] = $value['real_name']; $data[$key]['created_at'] = date('Y-m-d :H-m-s', $value['created_at']); $data[$key]['create_area'] = $value['create_area']; $status = $value['status']; if ($status == UcenterMember::STATUS_ACTIVE) { $data[$key]['status'] = '注册用户'; } elseif ($status == UcenterMember::STATUS_REAL) { $data[$key]['status'] = '实名用户'; } elseif ($status == UcenterMember::STATUS_BIND) { $data[$key]['status'] = '绑卡用户'; } //账户信息 $info = Info::find()->where(['member_id' => $value['id']])->one(); //账户余额 $data[$key]['balance'] = $info['balance']; //在投资金 $data[$key]['invest'] = $info['invest']; //可用收益 $data[$key]['profit'] = $info['profit']; //累计收益 $data[$key]['total_revenue'] = $info['total_revenue']; //充值--投资--赎回--提现 //首次充值 $rechar_at = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_RECHAR_SUC])->orderBy('id asc')->one(); //充值总金额 $rechar_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_RECHAR_SUC])->sum('step'); //首次投资时间 $invest_at = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_INVEST_SUC])->orderBy('id asc')->one(); //投资总额 $invest_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_INVEST_SUC])->sum('step'); //赎回总额 $redem_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_REDEM_SUC])->sum('step'); //提现总额 $withdraw_sum = Log::find()->where(['member_id' => $value['id'], 'status' => Log::STATUS_WITHDRAW_SUC])->sum('step'); //首次充值时间 $data[$key]['rechar_at'] = $rechar_at ? date('Y-m-d :H-m-s', $rechar_at['create_at']) : 0; $data[$key]['rechar_sum'] = $rechar_sum; //首次投资时间 $data[$key]['invest_at'] = $invest_at ? date('Y-m-d :H-m-s', $invest_at['create_at']) : 0; $data[$key]['invest_sum'] = $invest_sum; //赎回 $data[$key]['redem_sum'] = $redem_sum; //提现 $data[$key]['withdraw_sum'] = $withdraw_sum; //未领取红包奖励 $red = member::get_user_red_packet($value['id']); $data[$key]['red_usable'] = $red['data']['red_sum']; //总的红包奖励 $red1 = member::get_rad_list($value['id']); $data[$key]['red_sum'] = $red1['data']['sum']; } return Utils::exportExcel($data, array('用户id', '用户手机号', '用户真实姓名', '用户注册时间', '用户注册地区', '用户状态', '用户账户余额', '在投资金', '可用收益', '累计收益', '首次充值时间', '充值总金额', '首次投资时间', '投资总额', '赎回总额', '提现总额', '未领取红包', '红包奖励总额'), '数据分析' . date('Y-m-d-H-m-s')); } }
/** * 获取用户的详细信息--认证信息--账户信息 * @param $uid * @return array|null|\yii\db\ActiveRecord */ public static function getUserInfo($uid) { $year_rate = '0.08'; //活动期间利率调整TODO date_default_timezone_set('PRC'); //活动开始时间 $begin_time = strtotime('2015-9-24'); //活动结束时间 $end_time = strtotime('2015-9-30'); //当前时间 $now_time = time(); if ($now_time > $begin_time && $now_time < $end_time) { $year_rate = '0.0815'; } $yes_money = 0; $info = UcenterMember::find()->joinWith('info')->select(['id', 'ucenter_member.status', 'lock', 'invitation_code', 'phone', 'idcard', 'real_name', 'bank_card', 'bank_card_phone', 'balance', 'total_invest', 'invest', 'profit', 'total_revenue'])->where(['id' => $uid])->asArray()->one(); if ($info == null) { $return = array('errorNum' => '1', 'errorMsg' => '用户不存在', 'data' => null); return $return; } //获取网站配置信息 $config = AssetConfig::find()->select(['id', 'deposit_num', 'deposit_min', 'deposit_max', 'deposit_time', 'invest_num', 'invest_min', 'invest_max', 'invest_time', 'withdraw_num', 'withdraw_min', 'withdraw_max', 'withdraw_time', 'ransom_num', 'ransom_min', 'ransom_max', 'ransom_time'])->where(['id' => '2'])->asArray()->one(); //获取用户昨日收益金额 //今日零时时间 $zero_time = strtotime(date("Y-m-d")); //获取昨日收益 $get_yes_money = Income::find()->where(['>', 'created_at', $zero_time])->andWhere(['member_id' => $uid])->one(); //获取昨日收益金额--利率 $yes_experience_money = 0; if ($get_yes_money) { $yes_money = $get_yes_money->smoney ? $get_yes_money->smoney : 0; $year_rate = $get_yes_money->rate ? $get_yes_money->rate : 0; $yes_experience_money = $get_yes_money->goldincome ? $get_yes_money->goldincome : 0; } //获取体验金 $experience_money = 0; $money = Gold::find()->where(['<', 'created_at', time()])->andWhere(['>', 'end_at', time()])->andWhere(['uid' => $uid, 'status' => Gold::STATUS_ACTIVE])->sum('money'); if ($money) { $experience_money = sprintf("%.2f", $money); } //获取活动红包可用金额 $red_packet_money = 0; $red_money = member::get_user_red_packet($uid); if (!$red_money['errorNum']) { $red_packet_money = $red_money['data']['red_sum']; } $activity_invite = ''; //用户再投资金大于一元,可以进行分享 // $invest = $info['invest'] ? $info['invest'] : 0; // if($invest >= 1){ // $activity_invite = AloneMethod::encrypt($info['phone']); // } $activity_invite = AloneMethod::encrypt($info['phone']); $data = array('phone' => $info['phone'], 'idcard' => $info['idcard'], 'real_name' => $info['real_name'], 'status' => $info['status'], 'lock' => $info['lock'], 'invitation_code' => $info['invitation_code'], 'bank_card' => $info['bank_card'], 'bank_card_phone' => $info['bank_card_phone'], 'balance' => $info['balance'], 'total_invest' => $info['total_invest'], 'total_revenue' => $info['total_revenue'], 'invest' => $info['invest'], 'profit' => $info['profit'], 'yesterday_rate' => sprintf("%.4f", $year_rate), 'yesterday_money' => $yes_money, 'experience_money' => $experience_money, 'yes_experience_money' => $yes_experience_money, 'red_packet_money' => $red_packet_money, 'activity_invite' => $activity_invite, 'config' => $config); $return = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => $data); return $return; }