/** * @return \yii\db\ActiveQuery */ public function getJackpot() { return $this->hasOne(JackpotDetails::className(), ['id' => 'jackpot_id']); }
public function getJackpotDetails() { return $this->hasMany(JackpotDetails::className(), ['continent' => 'code']); }
/** * Upcoming Jackpot list Web Service * @return mixed */ public function actionApiJackpotUpcomingList() { $this->layout = false; $model = new JackpotDetails(); header('Content-type: application/json'); $json = file_get_contents('php://input'); //convert the string of data to an array $data['Jackpot'] = json_decode($json, true); //$data['Jackpot'] = Yii::$app->request->post(); $limit = empty($data['Jackpot']['limit']) ? '20' : $data['Jackpot']['limit']; $start = empty($data['Jackpot']['offset']) ? '0' : $data['Jackpot']['offset']; if ($start > 0) { $start = $start * $limit; } $jackpotListCount = JackpotDetails::find()->where(['>', 'end_date', date("Y-m-d H:i:s")])->asArray()->all(); $jackpotList = JackpotDetails::find()->where(['>', 'end_date', date("Y-m-d H:i:s")])->limit($limit)->offset($start)->asArray()->all(); if (!empty($jackpotList)) { $index = 0; foreach ($jackpotList as $list) { $time = strtotime($list['end_date']) + 3600; // Add 1 hour $jackpotListNew[$index]['lotteryName'] = $list['name']; $jackpotListNew[$index]['lotteryStartDate'] = $list['start_date']; $jackpotListNew[$index]['drawDate'] = date("Y-m-d H:i:s", $time); $jackpotListNew[$index]['jackpotPrize'] = $list['jackpot_price']; $jackpotListNew[$index]['ticketPrize'] = $list['ticket_price']; $jackpotListNew[$index]['lotteryImage'] = $list['jackpot_section_image']; $jackpotListNew[$index]['countryIcon'] = $list['countryid'] . '.png'; $index++; } $return['status'] = 1; $return['data'] = $jackpotListNew; $return['totalRecords'] = count($jackpotListCount); $return['message'] = "Data Retrieved Successfully."; return json_encode($return); } else { $return['status'] = 0; $return['message'] = "There is no Upcoming Jackpot."; return json_encode($return); } }
/** * Finds the JackpotDetails model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return JackpotDetails the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = JackpotDetails::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * Lists all Past Jackpots models. * @return mixed */ public function actionPast() { $lastMonth = time() - 3600 * 24 * 30; $last_month = date("Y-m-d H:i:s", $lastMonth); $dataProvider = new ActiveDataProvider(['query' => JackpotDetails::find()->where(['<', 'end_date', date("Y-m-d H:i:s", time() + 3600)])->andWhere(['>=', 'end_date', $last_month])]); return $this->render('past', ['dataProvider' => $dataProvider]); }
public function getJackpotDetailsCode() { return $this->hasMany(JackpotDetails::className(), ['countryid' => 'code']); }