public function actionIndex() { $uid = yii::$app->user->id; $model = UcenterMember::find()->where(['id' => $uid])->one(); //用户签到记录 $model_sign = SignIn::find()->where(['uid' => $uid]); $pages_sign = new Pagination(['totalCount' => $model_sign->count(), 'pageSize' => '8']); $sign_Infos = $model_sign->offset($pages_sign->offset)->limit($pages_sign->limit)->all(); $infos_rar = $this->Ucenter(); //用户数据包 return $this->render('index', compact("infos_rar", "pages_sign", "sign_Infos", "model")); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = SignIn::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'uid' => $this->uid, 'sign_in_time' => $this->sign_in_time, 'sign_in_money' => $this->sign_in_money, 'create_at' => $this->create_at, 'update_at' => $this->update_at]); $query->andFilterWhere(['like', 'sign_in_ip', $this->sign_in_ip])->andFilterWhere(['like', 'sign_in_from', $this->sign_in_from]); return $dataProvider; }
public function actionCheckin() { if (!yii::$app->user->isGuest) { $uid = yii::$app->user->id; $checkin_total = count(SignIn::find()->where('sign_in_time >=' . strtotime(date("Y-m-d")))->all()); //本日签到总人数 try { $info = member::signIn(yii::$app->user->id, ''); echo json_encode($info); exit; } catch (ErrorException $e) { echo $e->getMessage(); exit; } echo $checkin_total; exit; } }
$("#signin")[CLICK](function(){ $.post( "<?php echo yii\helpers\Url::to(['member/checkin']); ?> ", {'_csrf':"<?php echo Yii::$app->request->getCsrfToken(); ?> "}, function (data){ //回传函数 var jsonobj = eval('('+data+')'); if(jsonobj.errorNum == 0) { var totalPerson = <?php echo count(SignIn::find()->where('sign_in_time >=' . strtotime(date("Y-m-d")))->all()); ?> ; $("#countPeson").empty(); $("#countPeson").text(totalPerson * 1 + 1); $(this).css("border-color","#ffa200"); $(this).find("span").css("background","#ffa200"); $(this).find("span").html("已签到"); } else if(jsonobj.errorNum == 1 && jsonobj.errorMsg != '在投资金小于1000') { $(".spanti-c2").html(jsonobj.errorMsg); $(".spanti-c2").show(); setTimeout(function(){$(".spanti-c2").fadeOut(500);},2600); } if(jsonobj.errorMsg == '在投资金小于1000')
public function actionCheckin() { if (!yii::$app->user->isGuest) { $uid = yii::$app->user->id; //$invest_total = \common\models\fund\Order::find()->where(['member_id'=>$uid,'status'=>1])->sum('money'); $checkin_total = count(SignIn::find()->where('sign_in_time >=' . strtotime(date("Y-m-d")))->all()); //本日签到总人数 /* $model = new RaiseCard(); $model->member_id = Yii::$app->user->id; $model->create_at = strtotime("now"); $coupon_id = Setting::find()->where(['code'=>'checkrate'])->asArray()->one()['value']; $model_activity_card = Card::find()->where('id='.$coupon_id)->asArray()->one(); $model->coupon_id = $coupon_id; $model->status = 0; $model->rate = $model_activity_card['rate']; $model->validity_start_at = $model_activity_card['use_start_at']; $model->validity_out_at = $model_activity_card['use_out_at']; $model->save(false); */ try { $info = \frontend\actions\app\member::signIn(yii::$app->user->id, '1'); echo json_encode($info); exit; } catch (ErrorException $e) { echo $e->getMessage(); exit; } echo $checkin_total; exit; } }
public function actionIndex() { error_reporting(0); //取出后台设置最大红包 $maxincome = Setting::getCode('maxincome'); //取出后台设置的每人最大红白 $maxpeople = Setting::getCode('maxpeople'); //后台设置体验金利率 $goldrate = Setting::getCode('goldrate'); //设定时区 date_default_timezone_set('PRC'); //取出当前时间 $btime = date('Y-m-d' . '00:00:00', time()); //转换成“开始”的时间戳 $btimestr = strtotime($btime); // //判定今日是否已经计算了收益---防止收益被多次计算 $count = Income::find()->where(['>', 'created_at', $btimestr])->count(); if ($count) { return '收益已经计算过了'; } //查询昨天以前所有的投资订单,查询order表 $order = Order::find()->select('member_id,sum(money) as smoney,product_id')->andWhere(['<', 'start_at', Utils::alldaytostr($btimestr)[1]])->andWhere(['status' => 1])->groupBy(['member_id', 'product_id'])->asArray()->all(); $arrnew = array(); //循环所有投资 // $test = 0; foreach ($order as $k => $v) { //查询订单下对应项目 $product = Product::findOne($v['product_id']); //查询昨天的生成的利息 $income = Income::find()->andWhere(['member_id' => $v['member_id']])->andWhere(['between', 'created_at', Utils::alldaytostr($btimestr)[0], Utils::alldaytostr($btimestr)[1]])->one(); //查询增值卡昨天信息 // $railscard = RaiseCard::find() // ->select('member_id,sum(rate) as srate') // ->andWhere(['member_id'=>$v['member_id']]) // ->andWhere(['<', 'use_at',Utils::alldaytostr($btimestr)[1]]) // ->andWhere(['>', 'use_end_time',Utils::alldaytostr($btimestr)[1]]) // ->andWhere(['status'=>RaiseCard::STATUS_USE]) // ->groupBy(['member_id']) // ->asArray() // ->one(); //昨日签到人数 $count = SignIn::find()->joinWith(['info' => function ($query) { /** @var \yii\db\ActiveQuery $query */ $query->andWhere(['>', 'asset_info.invest', '1000']); }])->andWhere(['between', 'sign_in.sign_in_time', Utils::alldaytostr($btimestr)[0], Utils::alldaytostr($btimestr)[1]])->asArray()->count(); //每人赠送利息,如果每人分的利息大于设置的每人获得的最大利息,就用设置的每人利息,如果小于就用分的利息 $everyincome = 0; if ($count) { $everyincome = $maxincome / $count > $maxpeople ? $maxpeople : $maxincome / $count; } //取出昨天这个人有没有签到 $rails = SignIn::find()->andWhere(['uid' => $v['member_id']])->andWhere(['between', 'sign_in_time', Utils::alldaytostr($btimestr)[0], Utils::alldaytostr($btimestr)[1]])->asArray()->one(); //判断订单是否有总金额 $smoney = isset($v['smoney']) ? $v['smoney'] : 0; //查询该用户体验金 // $all = Gold::find()->select('experience_gold.id,experience_gold.rid,sum(experience_gold.money) as gmoney')->andWhere(['uid'=>$v['member_id']])->joinWith(['rule' => function ($query) { // /** @var \yii\db\ActiveQuery $query */ // $query->andWhere(['experience_rule.status'=>Rule::STATUS_ACTIVE]); // }])->asArray()->all(); // // //查询发放给该用户体验金昨天信息 // $sendgold = RaiseCard::find() // ->select('member_id,sum(rate) as srate') // ->andWhere(['member_id'=>$v['member_id']]) // ->andWhere(['<', 'validity_start_at',Utils::alldaytostr($btimestr)[1]]) // ->andWhere(['>', 'validity_out_at',Utils::alldaytostr($btimestr)[1]]) // ->andWhere(['status'=>RaiseCard::STATUS_USE]) // ->asArray() // ->one(); //查询该用户体验金-----TODO $all = Gold::find()->select('uid,sum(money) as smoney')->andWhere(['uid' => $v['member_id'], 'status' => Gold::STATUS_ACTIVE])->andWhere(['<', 'created_at', time()])->andWhere(['>', 'end_at', time()])->asArray()->one(); // $summoney = 0; // foreach($all as $kmmy=>$vmmy){ // $newbetime = strtotime(date('Y-m-d'.' 00:00:00',time())); // $endtime = $vmmy['created_at'] + 3600 * 24 * $vmmy['time']; // if($vmmy['created_at']<$newbetime && $endtime>$newbetime){ // $summoney +=$all[$kmmy]['money']; // } // } // var_dump($summoney); // var_dump($all); //查询发放给该用户体验金昨天信息 // $sendgold = RaiseCard::find() // ->select('member_id,sum(rate) as srate') // ->andWhere(['member_id'=>$v['member_id']]) // ->andWhere(['<', 'validity_start_at',Utils::alldaytostr($btimestr)[1]]) // ->andWhere(['>', 'validity_out_at',Utils::alldaytostr($btimestr)[1]]) // ->groupBy(['member_id']) // ->asArray() // ->one(); //计算利率,增息卡的利率+项目的利率 // $railscardrate = isset($railscard)? $railscard['srate']+$product->rate/365:$product->rate/365; //TODO $railscardrate = isset($railscard) ? $railscard['srate'] + $product->rate : $product->rate; //活动期间利率调整TODO date_default_timezone_set('PRC'); //活动开始时间 $begin_time = strtotime('2015-10-1'); //活动结束时间 $end_time = strtotime('2015-10-7'); //当前时间 $now_time = time(); if ($now_time > $begin_time && $now_time < $end_time) { $railscardrate = '0.101'; } $railscardrate = '0.08'; //组成新数组,用户的id $arrnew[$v['member_id']]['member_id'] = $v['member_id']; //用户昨日利息,因利息也会产生利息,所以昨日利息乘以利率 // $arrnew[$v['member_id']]['smoney'] += isset($income)?($smoney+$income->smoney)*Utils::moneyFormat($railscardrate) :$smoney*Utils::moneyFormat($railscardrate); //投资总额---记录当前再投资金 $arrnew[$v['member_id']]['money'] += $v['smoney']; //计算收益--TODO $arrnew[$v['member_id']]['smoney'] += ceil($smoney * $railscardrate * 100 / 365) / 100; //取不包含红包体验金收益 $arrnew[$v['member_id']]['iincome'] += ceil($smoney * $railscardrate * 100 / 365) / 100; //用户的昨日之前的累计利息 // isset($income)? $arrnew[$v['member_id']]['newmoney'] = $arrnew[$v['member_id']]['smoney']+$income->newmoney : $arrnew[$v['member_id']]['newmoney'] += $smoney*Utils::moneyFormat($railscardrate); // TODO isset($income) ? $arrnew[$v['member_id']]['newmoney'] = $arrnew[$v['member_id']]['smoney'] + $income->newmoney : ($arrnew[$v['member_id']]['newmoney'] += ceil($smoney * $railscardrate * 100 / 365) / 100); //签到获取的利息 $arrnew[$v['member_id']]['railscard'] = $rails ? $everyincome : 0; //在投金额大于1元--计算体验金收益 if ($smoney >= 1) { //计算该用户体验金获取的利息 $arrnew[$v['member_id']]['goldincome'] = ceil($all['smoney'] * $railscardrate * 100 / 365) / 100; } //每人的利率 $arrnew[$v['member_id']]['rate'] = $railscardrate; } foreach ($arrnew as $k => &$v) { //求出每个用户的昨日利率 $v['rate'] = Utils::moneyFormat(($v['smoney'] + $v['railscard']) * 365 / $v['money']); //总利息加上签到获取的利息 $v['newmoney'] = $v['railscard'] + $v['newmoney'] + $v['goldincome']; //利息加上签到获取的利息 $v['smoney'] = $v['railscard'] + $v['smoney'] + $v['goldincome']; //利息计算时的投资--- // $v['money'] = $v['money'] + $v['goldincome'] + $v['railscard']; // -- 计算在投金额不应该增加利息产生的金额 $v['money'] = $v['money']; } //循环数组 foreach ($arrnew as $vs) { $_model = new Income(); //查出用户表的余额 $Info = Info::find()->where(['member_id' => $vs['member_id']])->one(); if ($Info) { $Info->profit = $Info->profit + $vs['smoney']; $Info->total_revenue = $Info->total_revenue + $vs['smoney']; $Info->save(); } //取出昨天这个人有没有签到 $signin = SignIn::find()->andWhere(['uid' => $vs['member_id']])->andWhere(['between', 'sign_in_time', Utils::alldaytostr($btimestr)[0], Utils::alldaytostr($btimestr)[1]])->one(); if ($signin && $vs['money'] >= 1000) { $signin->sign_in_money = $vs['railscard']; $signin->status = SignIn::STATUS_FINISH; $signin->save(); $_model->railscard = $vs['railscard']; } $_model->member_id = $vs['member_id']; $_model->smoney = $vs['smoney']; $_model->money = $vs['money']; $_model->rate = $vs['rate']; $_model->newmoney = $vs['newmoney']; $_model->goldincome = $vs['goldincome']; $_model->iincome = $vs['iincome']; //生成每日利息表的数据 $_model->save(); } //推荐大师活动 //获取所有用户信息 $users = UcenterMember::find()->select(['id'])->asArray()->all(); if ($users !== null) { //获取所有用户id值 foreach ($users as $key => $value) { //循环用户信息--判定其推荐人中是否有符合奖励规则的人--有进行推荐表中状态更改 AloneMethod::produce_red_packet($value['id']); } } //判定推荐表中用户是否符合拿取奖励规则 if ($users !== null) { foreach ($users as $key => $value) { AloneMethod::send_red_packet($value['id']); } } echo "成功"; }
/** * 获取网站签到情况 * @return array */ public static function get_sign_in() { //今日零时时间 $zero_time = strtotime(date("Y-m-d")); //昨日零时时间 $yes_zero_time = $zero_time - 86400; //明日零时时间 $tom_zero_time = $zero_time + 86400; //昨日签到人数 $get_sign_count = SignIn::find()->where(['between', 'sign_in_time', $yes_zero_time, $zero_time])->andWhere(['status' => SignIn::STATUS_FINISH])->count(); //昨日红包总额 $get_sign_money = SignIn::find()->where(['between', 'sign_in_time', $yes_zero_time, $zero_time])->andWhere(['status' => SignIn::STATUS_FINISH])->sum('sign_in_money'); //今日签到人数 $get_today_sign_count = SignIn::find()->where(['between', 'sign_in_time', $zero_time, $tom_zero_time])->count(); $data = array('yes_count' => $get_sign_count, 'yes_money' => $get_sign_money, 'today_count' => $get_today_sign_count); $result = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => $data); return $result; }