/** * 获取用户的详细信息--认证信息--账户信息 * @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; }
/** * 获取用户推荐关系列表 * @param $uid * @param $page * @param $num * @return array|\yii\db\ActiveRecord[] */ public static function get_recommend_relation($uid, $page = 1, $num = 10) { //获取推荐列表 $page = ($page - 1) * $num; //一级推荐人列表 $leval_one_list = UserRecommend::find()->select(['sender_phone', 'is_grant', 'sender_register_time', 'update_at', 'red_packet', 'red_packet_name'])->where(['owner_uid' => $uid, 'level' => 1])->orderBy('is_grant desc')->limit($num)->offset($page)->asArray()->all(); //一级推荐人的总人数 $leval_one_count = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 1])->count(); //一级推荐人中,用户尚未领取的人数 $leval_one_count_get_false = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 1, 'is_grant' => UserRecommend::GRANT_FALSE])->count(); //一级推荐人中--用户尚未领取的红包总金额 $leval_one_money_get_false = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 1, 'is_grant' => UserRecommend::GRANT_FALSE])->sum('red_packet'); //推荐人--已经领取的人数 $leval_one_count_get_true = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 1, 'is_grant' => UserRecommend::GRANT_TRUE])->count(); //推荐人--已经领取的红包金额 $leval_one_money_get_true = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 1, 'is_grant' => UserRecommend::GRANT_TRUE])->sum('red_packet'); //二级推荐总的人数 $leval_two_count = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 2])->count(); //二级推荐人中,用户尚未领取的人数 $leval_two_count_get_false = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 2, 'is_grant' => UserRecommend::GRANT_FALSE])->count(); //二级推荐人中,用户尚未领取的红包总额度 $leval_two_money_get_false = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 2, 'is_grant' => UserRecommend::GRANT_FALSE])->sum('red_packet'); //二级推荐人中--已经领取的人数 $leval_two_count_get_true = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 2, 'is_grant' => UserRecommend::GRANT_TRUE])->count(); //二级推荐人中 --已经放到红包表里面了的红包总金额 $leval_two_money_get_true = UserRecommend::find()->where(['owner_uid' => $uid, 'level' => 2, 'is_grant' => UserRecommend::GRANT_TRUE])->sum('red_packet'); ///获取用户手机号 $user_phone = '186****1725'; $user = UcenterMember::findOne(['id' => $uid]); if ($user !== null) { $user_phone = $user->phone; $user_code = \frontend\actions\App\AloneMethod::encrypt($user_phone); } $user_phone = substr_replace($user_phone, '****', 3, 4); $data = array(array('level' => 1, 'people_sum' => $leval_one_count, 'get_num' => $leval_one_count_get_true, 'get_money' => $leval_one_money_get_true ? $leval_one_money_get_true : 0, 'not_get_num' => $leval_one_count_get_false, 'not_get_money' => $leval_one_money_get_false ? $leval_one_money_get_false : 0, 'people_list' => $leval_one_list), array('level' => 2, 'people_sum' => $leval_two_count, 'get_num' => $leval_two_count_get_true, 'get_money' => $leval_two_money_get_true ? $leval_two_money_get_true : 0, 'not_get_num' => $leval_two_count_get_false, 'not_get_money' => $leval_two_money_get_false ? $leval_two_money_get_false : 0, 'people_list' => null), 'share' => array('share_link' => 'https://www.huoqiwang.com/events/festival20151015?code=' . $user_code, 'share_title' => '活琪王壕送大礼啦!', 'share_info' => '您的朋友' . $user_phone . '给您送来了8888元大红包,快来看看吧~~~', 'share_logo' => 'http://static.huoqiwang.com/imgs/logo180180.png')); $return_array = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => $data); return $return_array; }