示例#1
0
 public function actionLottery()
 {
     ini_set('max_execution_time', 0);
     $request = Yii::$app->request;
     if ($request->isAjax) {
         $que_id = intval($request->get('id'));
         $answer = QueModel::find()->select(['que_answer'])->where(['id' => $que_id])->asArray()->scalar();
         if ($answer == '') {
             return '请填写答案,请先填写答案';
         }
         $init_user_tump = QueInitModel::find()->select(['id', 'user_id', 'money', 'par_person', 'f_par_persons', 'que_answer'])->where(['que_id' => $que_id, 'lottery_state' => 0])->asArray()->all();
         if (!$init_user_tump) {
             return '没有发起者';
         }
         $answer_arr = $answer ? [1, 0, 0, 1] : [0, 0, 1, 1];
         $part_user_tump = QuePartModel::find()->select(['id' => 'sl_que_part.id', 'init_id', 'init_option', 'user_id' => 'sl_que_part.user_id'])->join('LEFT JOIN', 'sl_que_init', 'sl_que_init.id=init_id')->where(['and', 'sl_que_init.que_id=' . $que_id, '1=1'])->asArray()->all();
         //获取参与者=
         if (!$part_user_tump) {
             return '没有参与者,请取消该问题';
         }
         $init_user = $this->_ZhiZhuanJian($init_user_tump, 'id');
         $part_user = $this->_GroupArray($part_user_tump, 'init_id');
         foreach ($part_user as $k => $v) {
             foreach ($v as $key => $val) {
                 if ($val['init_option'] == 0) {
                     $part_user_zan_fan[$k][0][] = $val;
                 } else {
                     $part_user_zan_fan[$k][1][] = $val;
                 }
             }
         }
         //将没有参与者的剔除来
         $data_tump = $this->_TiChuLiuPai($init_user, $part_user_zan_fan, $answer_arr);
         //将流拍的返回积分;
         if (!$data_tump[0] == '') {
             // var_dump($data_tump[0]);die;
             $part_id_tump = QuePartModel::find()->select(['id', 'init_id', 'user_id'])->where(['init_id' => $data_tump[0]])->asArray()->all();
             $init_id_tump = QueInitModel::find()->select(['id', 'money', 'user_id'])->where(['id' => $data_tump[0]])->asArray()->all();
             $this->_FanHuiJiFen($part_id_tump, $init_id_tump);
         }
         //发送积分
         $this->_FenFaJiFen($data_tump[1], $answer_arr, $init_user);
         QueModel::updateAll(['lottery_state' => 1], ['id' => $que_id]);
         return true;
     }
 }
示例#2
0
 public function actionTime6190()
 {
     //        $field = [''];
     $where = ['and', 'time_option=-3', 'start_time <> 0', 'match_time-' . time() . '< 90'];
     $match_id = QueModel::find()->select('match_id')->distinct()->where($where)->asArray()->column();
 }