public function actionExport()
{
$time = \App::$app->request->post()['time'];
$arr[0] = 0;
$arr[1] = 0;
if ($time) {
$arr = explode('至', \App::$app->request->post()['time']);
$arr[0] = strtotime($arr[0] . ' 00:00:00');
$arr[1] = strtotime($arr[1] . ' 23:59:59');
}
$users = $this->memberList($arr[0], $arr[1]);
Utils::exportExcel($users, ['ID', '用户名', '电话', '邮箱', '身份证', '真实姓名', '状态', '注册时间', '登陆IP'], '用户信息' . date('Y.m.d'));
}
public function actionIndex()
{
$uid = Yii::$app->user->id;
Utils::ensureOpenId();
$openId = Yii::$app->request->get('open_id');
if (($usermodel = UcenterMember::findOne(['openid' => $openId])) !== null) {
Yii::$app->user->login($usermodel);
} elseif (empty(Yii::$app->user->id)) {
return $this->redirect(['site/signin']);
}
$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;
}
//全部记录
$logs = AloneMethod::total_log($uid, 1, 15);
$logs_pages = Log::find()->select(['step', 'remark', 'status', 'create_at'])->where(['member_id' => $uid])->andWhere(['>', 'status', '0'])->andWhere(['<>', 'step', '0.00'])->asArray()->all();
$logs_pages = ceil(count($logs_pages) / 15);
//$logs = Log::find()->select(['step','create_at','status'])->where(['member_id'=>$uid])->andWhere(['in','status',[1,2,3,4]])->orderBy('id desc')->asArray()->all();
//充值
$recharge = AloneMethod::recharge_log($uid, 1, 15);
$recharge_pages = Log::find()->select(['step', 'remark', 'status', 'create_at'])->where(['member_id' => $uid, 'status' => Log::STATUS_RECHAR_SUC])->asArray()->all();
$recharge_pages = ceil(count($recharge_pages) / 15);
//投资
$invest = AloneMethod::invest_log($uid, 1, 15);
$invest_pages = Log::find()->select(['step', 'remark', 'status', 'create_at'])->where(['member_id' => $uid, 'status' => Log::STATUS_INVEST_SUC])->asArray()->all();
$invest_pages = ceil(count($invest_pages) / 15);
//赎回
$ransom = AloneMethod::redeem_log($uid, 1, 15);
$ransom_pages = Log::find()->select(['step', 'remark', 'status', 'create_at'])->where(['member_id' => $uid, 'status' => Log::STATUS_REDEM_SUC])->asArray()->all();
$ransom_pages = ceil(count($recharge_pages) / 15);
//提现
$withdraw = AloneMethod::withdrawals_log($uid, 1, 15);
$withdraw_pages = Log::find()->select(['step', 'remark', 'status', 'create_at'])->where(['member_id' => $uid, 'status' => Log::STATUS_WITHDRAW_SUC])->asArray()->all();
$withdraw_pages = ceil(count($recharge_pages) / 15);
return $this->view('index', compact('invest', 'recharge', 'withdraw', 'ransom', 'logs', 'logs_pages', 'recharge_pages', 'invest_pages', 'ransom_pages', 'withdraw_pages'));
}
public function actionLogout()
{
Utils::ensureOpenId();
$request = Yii::$app->request;
if ($request->isPost) {
if (($model = UcenterMember::findOne(['openid' => $request->post('open_id')])) !== null) {
/** @var MemberOther $model */
$model->openid = '';
$model->save();
}
Yii::$app->user->logout();
return $this->goBack(['info' => "解绑成功"], Url::to(['site/signin']));
}
return $this->view('logout');
}
/**
* Updates an existing Card model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
if ($model->load(\App::$app->request->post())) {
$model->rate = \App::$app->request->post()['Card']['rate'] * 0.01;
$model->use_start_at = strtotime(\App::$app->request->post()['Card']['use_start_at']);
$model->use_out_at = strtotime(\App::$app->request->post()['Card']['use_out_at']);
$model->validity_time = Utils::count_days($model->use_start_at, $model->use_out_at);
$model->save();
return $this->redirect(['view', 'id' => $model->id]);
} else {
$model['rate'] = $model['rate'] * 100;
$model['use_start_at'] = date("Y-m-d H:i", $model['use_start_at']);
$model['use_out_at'] = date("Y-m-d H:i", $model['use_out_at']);
return $this->render('update', ['model' => $model]);
}
}
public function actionGindex()
{
Utils::ensureOpenId();
$openId = Yii::$app->request->get('open_id');
if (($usermodel = UcenterMember::findOne(['openid' => $openId])) !== null) {
Yii::$app->user->login($usermodel);
} elseif (empty(Yii::$app->user->id)) {
return $this->redirect(['site/signin']);
}
$uid = yii::$app->user->id;
$gold = Gold::find()->select('uid,sum(money) as smoney')->where(['uid' => $uid])->asArray()->one();
$allgold = Gold::find()->select('uid,rid,sum(money) as smoney')->where(['uid' => $uid])->asArray()->groupBy('rid')->all();
$invitation_code = UcenterMember::findIdentity($uid)->invitation_code;
$goldincome = Income::find()->select('member_id,sum(goldincome) as sincome')->where(['member_id' => $uid])->asArray()->one();
$jssdk = new Jssdk('wx32814d588c44c17c', '23b0f218574551f18db1dc991dbee87f');
$signpack = $jssdk->getSignPackage();
return $this->view('gindex', compact('gold', 'allgold', 'goldincome', 'invitation_code', 'signpack'));
}
public function actionAjaxdata()
{
$betime = strtotime(date('Y-m-d' . ' 00:00:00', time()));
$endtime = strtotime(date('Y-m-d' . ' 23:59:59', time()));
$now = strftime('%Y-%m-%d', time());
list($wstart, $wend) = Utils::lastNWeek(time(), 1);
list($mstart, $mend) = Utils::lastMonth(time());
list($qstart, $qend) = Utils::lastQuarter(time());
$beginThismonth = mktime(0, 0, 0, date('m'), 1, date('Y'));
$endThismonth = mktime(23, 59, 59, date('m'), date('t'), date('Y'));
$today = [];
$week = [];
$month = [];
$quart = [];
$payment = SinaDeposit::find()->select('sum(amount) as smoney')->andWhere(['status' => SinaDeposit::STATUS_SUCCESS])->andWhere(['between', 'create_at', $betime, $endtime])->asArray()->one();
$withdraw = SinaWithdraw::find()->select('sum(money) as smoney')->andWhere(['status' => SinaWithdraw::STATUS_SINA_SUCCESS])->andWhere(['between', 'create_at', $betime, $endtime])->asArray()->one();
$wpayment = SinaDeposit::find()->select('sum(amount) as smoney')->andWhere(['status' => SinaDeposit::STATUS_SUCCESS])->andWhere(['between', 'create_at', strtotime($wstart), strtotime($wend)])->asArray()->one();
$wwithdraw = SinaWithdraw::find()->select('sum(money) as smoney')->andWhere(['status' => SinaWithdraw::STATUS_SINA_SUCCESS])->andWhere(['between', 'create_at', strtotime($wstart), strtotime($wend)])->asArray()->one();
$mpayment = SinaDeposit::find()->select('sum(amount) as smoney')->andWhere(['status' => SinaDeposit::STATUS_SUCCESS])->andWhere(['between', 'create_at', strtotime($mstart), strtotime($mend)])->asArray()->one();
$mwithdraw = SinaWithdraw::find()->select('sum(money) as smoney')->andWhere(['status' => SinaWithdraw::STATUS_SINA_SUCCESS])->andWhere(['between', 'create_at', strtotime($mstart), strtotime($mend)])->asArray()->one();
$qpayment = SinaDeposit::find()->select('sum(amount) as smoney')->andWhere(['status' => SinaDeposit::STATUS_SUCCESS])->andWhere(['between', 'create_at', strtotime($qstart), strtotime($qend)])->asArray()->one();
$qwithdraw = SinaWithdraw::find()->select('sum(money) as smoney')->andWhere(['status' => SinaWithdraw::STATUS_SINA_SUCCESS])->andWhere(['between', 'create_at', strtotime($qstart), strtotime($qend)])->asArray()->one();
$benpayment = SinaDeposit::find()->select('sum(amount) as smoney')->andWhere(['status' => SinaDeposit::STATUS_SUCCESS])->andWhere(['between', 'create_at', $beginThismonth, $endThismonth])->asArray()->one();
$benwithdraw = SinaWithdraw::find()->select('sum(money) as smoney')->andWhere(['status' => SinaWithdraw::STATUS_SINA_SUCCESS])->andWhere(['between', 'create_at', $beginThismonth, $endThismonth])->asArray()->one();
$oldpayment = SinaDeposit::find()->select('sum(amount) as smoney')->andWhere(['status' => SinaDeposit::STATUS_SUCCESS])->asArray()->one();
$oldwithdraw = SinaWithdraw::find()->select('sum(money) as smoney')->andWhere(['status' => SinaWithdraw::STATUS_SINA_SUCCESS])->asArray()->one();
$today = '今日提现' . ($withdraw['smoney'] ? $withdraw['smoney'] : '0') . '充值' . ($payment['smoney'] ? $payment['smoney'] : "0");
$week = '上周提现' . ($wwithdraw['smoney'] ? $wwithdraw['smoney'] : '0') . '充值' . ($wpayment['smoney'] ? $wpayment['smoney'] : '0');
$benmonth = '本月提现' . ($benwithdraw['smoney'] ? $benwithdraw['smoney'] : '0') . '充值' . ($benpayment['smoney'] ? $benpayment['smoney'] : "0");
$month = '上月提现' . ($mwithdraw['smoney'] ? $mwithdraw['smoney'] : '0') . '充值' . ($mpayment['smoney'] ? $mpayment['smoney'] : "0");
$quart = '上个季度提现' . ($qwithdraw['smoney'] ? $qwithdraw['smoney'] : '0') . '充值' . ($qpayment['smoney'] ? $qpayment['smoney'] : '0');
$oldtotal = '总提现' . ($oldwithdraw['smoney'] ? $oldwithdraw['smoney'] : '0') . '充值' . ($oldpayment['smoney'] ? $oldpayment['smoney'] : '0');
echo $today . ',' . $week . ',' . $benmonth . ',' . $month . ',' . $quart . ',' . $oldtotal;
}
public function actionDorepass()
{
$uid = Yii::$app->user->id;
if ($_POST) {
$member = member::changePassword($uid, $_POST['oldpass'], $_POST['password'], $_POST['repassword']);
if ($member['errorNum'] == 1) {
return $member['errorMsg'];
} else {
Utils::ensureOpenId();
$openId = Yii::$app->request->get('open_id');
if ($openId) {
$model = UcenterMember::findOne(['openid' => $openId]);
if ($model) {
$model->openid = '';
$model->save();
}
}
Yii::$app->user->logout();
return '修改成功';
}
}
}
public function actionSignup()
{
//判断注册URL中是否包含邀请码参数
if (isset($_GET['code'])) {
$code = $_GET['code'];
//$_code_source = UcenterMember::find()->where(['invitation_code'=>$code])->one();
//if(count($_code_source) != 1)
$flag = \frontend\actions\app\member::verify_code($code);
if (!$flag) {
header("Content-type: text/html; charset=utf-8");
echo "<script>alert('来源链接不合法！')</script>";
echo "<script>window.location.href='" . \yii\helpers\Url::to(['site/signup']) . "'</script>";
exit;
}
}
$model = new SignupForm();
//是否邀请注册
$test_invite = 1;
if ($model->load(Yii::$app->request->post())) {
if ($_POST['SignupForm']['username'] && $_POST['SignupForm']['validate_code'] && $_POST['SignupForm']['password'] && $_POST['SignupForm']['password_repeat']) {
$invite_code = $_POST["SignupForm"]['invitation_code'];
//使用测试邀请码
if ($test_invite) {
//使用测试邀请
$flag = \frontend\actions\app\member::verify_code($invite_code);
//验证码通过
if (!$flag) {
echo "<script>alert('" . '邀请码错误' . "')</script>";
}
}
$_phone = $_POST['SignupForm']['username'];
$_code = $_POST['SignupForm']['validate_code'];
try {
$result = Port::checkPhnoe($_phone, $_code);
if (is_bool($result)) {
}
} catch (ErrorException $e) {
header("Content-type: text/html; charset=utf-8");
echo "<script>alert('" . $e->getMessage() . "')</script>";
echo "<script>location.href='" . \yii\helpers\Url::to(['site/signup']) . "'</script>";
exit;
}
$user = new UcenterMember();
$user->username = $_POST["SignupForm"]['username'];
$user->phone = $_POST["SignupForm"]['username'];
$user->invitation_code = $_POST["SignupForm"]['invitation_code'];
$password = $_POST["SignupForm"]['password'];
$user->setPassword($password);
$user->create_ip = Yii::$app->request->userIp;
$app_pwd = md5(sha1($password) . time());
$user->app_pwd = $app_pwd;
try {
$area = self::get_area(Yii::$app->request->userIp);
$user->create_area = $area;
} catch (ErrorException $e) {
}
$user->generateAuthKey();
if ($user->save()) {
$uid = $user['id'];
if ($test_invite) {
//使用验证码
$flag = \frontend\actions\app\member::verify_code($invite_code);
$invite_flag = \frontend\actions\app\member::use_code($flag, $uid);
if (!$invite_flag) {
$return = array('errorNum' => '1', 'errorMsg' => '注册失败', 'data' => null);
return $return;
}
}
if (Yii::$app->getUser()->login($user)) {
$newModel = UcenterMember::find()->where(['id' => Yii::$app->user->id])->one();
//$newModel->invitation_id= \yii::$app->params['invitation_id'];
$invitation_code = Utils::createcode();
$newModel->invitation_code = $invitation_code;
$newModel->person_face = Setting::find()->where("code='img'")->one()->value;
if ($_POST['url_code']) {
$code_source = UcenterMember::find()->where(['invitation_code' => $_POST["url_code"]])->asArray()->one();
if ($code_source) {
$newModel->invitation_id = $code_source['id'];
}
//好友注册领取体验金
$rule = Rule::find()->where(['title' => '好友注册', 'status' => Rule::STATUS_ACTIVE])->one();
if ($rule) {
$rid = $rule->id;
$r_money = $rule->money;
$model_gold = new Gold();
$model_gold->rid = $rid;
$model_gold->money = $r_money;
$model_gold->uid = $code_source['id'];
$model_gold->created_at = strtotime("now");
$model_gold->save();
}
} elseif ($_POST['SignupForm']['invitation_code']) {
$code_source = UcenterMember::find()->where(['invitation_code' => $_POST["SignupForm"]["invitation_code"]])->asArray()->one();
if ($code_source) {
$newModel->invitation_id = $code_source['id'];
}
//好友注册领取体验金
$rule = Rule::find()->where(['title' => '好友注册', 'status' => Rule::STATUS_ACTIVE])->one();
if ($rule) {
$rid = $rule->id;
$r_money = $rule->money;
$model_gold = new Gold();
$model_gold->rid = $rid;
$model_gold->money = $r_money;
$model_gold->uid = $code_source['id'];
$model_gold->created_at = strtotime("now");
$model_gold->save();
}
}
$newModel->save(false);
$model_asset_info = new Info();
$model_asset_info->member_id = yii::$app->user->id;
$model_asset_info->create_at = strtotime("now");
$model_asset_info->save(false);
//手机号注册领取体验金
$rule = Rule::find()->where(['title' => '手机号注册', 'status' => Rule::STATUS_ACTIVE])->one();
if ($rule) {
$rid = $rule->id;
$r_money = $rule->money;
$model_gold = new Gold();
$model_gold->rid = $rid;
$model_gold->money = $r_money;
$model_gold->uid = $code_source['id'];
$model_gold->created_at = strtotime("now");
$model_gold->save();
}
return $this->goHome();
}
}
}
}
return $this->render('signup', compact("model", "code"));
}
public function actionLogout()
{
Utils::ensureOpenId();
$openId = Yii::$app->request->get('open_id');
if ($openId) {
$model = UcenterMember::findOne(['openid' => $openId]);
if ($model) {
$model->openid = '';
$model->save();
}
}
Yii::$app->user->logout();
return $this->redirect(['site/main']);
}
public function actionSend()
{
try {
Utils::sendEmail('*****@*****.**', '统计发送', '123');
} catch (\Exception $e) {
throw new ErrorException($e);
}
}
/**
* 获取用户信息
*/
public static function statistics()
{
$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'));
}
}
public function actionExport()
{
$time = \App::$app->request->post()['time'];
$arr[0] = 0;
$arr[1] = 0;
if ($time) {
$arr = explode('至', \App::$app->request->post()['time']);
$arr[0] = strtotime($arr[0] . ' 00:00:00');
$arr[1] = strtotime($arr[1] . ' 23:59:59');
}
$logs = $this->logList($arr[0], $arr[1]);
Utils::exportExcel($logs, ['ID', '金额', '状态', '银行卡', '创建时间', '用户名'], '资金记录导出' . date('Y.m.d'));
}