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; } }
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(); }