PHP common\models QuizVote示例

示例#1

文件： Quiz.php 项目： BoBRoID/new.k-z

 public function getAnswersByDay()
 {
     $answers = [];
     $query = QuizVote::find()->select(['answerID', 'votes' => 'COUNT(*)', 'answersDate' => 'FROM_UNIXTIME(`date`,\'%Y-%m-%d\')'])->where(['quizID' => $this->id])->groupBy(['answerID', 'answersDate'])->asArray();
     foreach ($query->each() as $answer) {
         $answers[$answer['answersDate']][$answer['answerID']] = $answer['votes'];
     }
     ksort($answers);
     return $answers;
 }

示例#2

文件： Quiz.php 项目： BoBRoID/new.k-z

 /**
  * @return \yii\db\ActiveQuery
  */
 public function getVotes()
 {
     return $this->hasMany(QuizVote::className(), ['quizID' => 'id']);
 }

示例#3

文件： QuizVote.php 项目： BoBRoID/new.k-z

 public function init()
 {
     $this->ip = \Yii::$app->request->userIP;
     return parent::init();
 }

示例#4

文件： m160719_140558_migrate_quizVotes.php 项目： BoBRoID/new.k-z

 public function down()
 {
     Yii::$app->db->createCommand()->truncateTable(\common\models\QuizVote::tableName())->execute();
 }