/** * Finds the Items model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Items the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Items::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function loadModel($id) { $model = Items::findOne($id); if ($model === null) { throw new \yii\web\HttpException(404, 'The requested page does not exist.'); } return $model; }
/** * Выборка для случайного концерта * @return string */ function actionConcert() { if ($user = Yii::$app->getRequest()->getQueryParam('user')) { if (!$user) { return 'Доступ запрещн!'; } // $user = Yii::$app->getRequest()->getQueryParam('user'); if (Items::find()->where(['is_next' => 1])->one()) { $item = Items::find()->where(['is_next' => 1])->one(); $song_id = $item->id; } else { $song_id = 100; } $songs = []; //return $song_id; $songs1 = Items::find()->where("(source_id = 6 or source_id = 40) and id < {$song_id} and published = 1")->limit(5)->orderBy('id DESC')->all(); $songs2 = Items::find()->where("(source_id = 19 or source_id = 41) and id < {$song_id} and published = 1")->limit(5)->orderBy('id DESC')->all(); $songs3 = Items::find()->where("source_id = 38 and id < {$song_id} and published = 1")->limit(5)->orderBy('id DESC')->all(); $songs4 = Items::find()->where("(source_id = 29 or source_id = 326 or source_id = 526) and id < {$song_id} and published = 1")->limit(1)->orderBy('id DESC')->all(); $songs = array_merge($songs1, $songs2, $songs3, $songs4); shuffle($songs); //return var_dump($songs); //$choosen_songs = []; foreach ($songs as $song) { try { $items_records = []; $tags = explode(',', $song->tags); $rand_tag = $tags[mt_rand(0, count($tags) - 1)]; $this->rand_tag[] = $rand_tag; $query = new Query(); // $search_result = $query_search->from('siteSearch')->match($q)->all(); // поиск осуществляется по средством метода match с переданной поисковой фразой. $query_items_ids = $query->from('items')->match($rand_tag)->all(); //return var_dump($query_items_ids); foreach ($query_items_ids as $arr_item_rec) { foreach ($arr_item_rec as $id) { $item = Items::findOne((int) $id); if ($item->cat_id == 93 || $item->cat_id == 104 || $item->cat_id == 105 || $item->cat_id == 143 || $item->cat_id == 136) { $items_records[] = Items::findOne((int) $id); } } } //return var_dump($items_records[mt_rand(0,count($items_records)-1)]->text); if (empty($items_records)) { continue; } $rand_index = mt_rand(0, count($items_records) - 1); $song->phrase = $items_records[$rand_index]->text; if (isset($items_records[$rand_index + 1]) && $song->phrase != $song->phrase2) { $song->phrase2 = $items_records[$rand_index + 1]->text; } else { $song->phrase2 = $items_records[0]->text; } //return $song->phrase.'<br>'.$song->phrase2; //return var_dump($song); $this->choosen_songs[] = $song; } catch (\ErrorException $e) { return $e->getMessage(); } } //exit; //return var_dump($this->choosen_songs); return $this->renderPartial('concert', ['songs' => $this->choosen_songs, 'tags' => $this->rand_tag]); } }
public function actionItemprice() { if (\filter_input(INPUT_POST, 'item')) { $item_id = filter_input(INPUT_POST, 'item'); $model = Items::findOne($item_id); if (!empty($model)) { return json_encode($model->price); } } }
/** * Генератор тэговых страниц */ public function actionGetTags() { $list = scandir('/home/romanych/www/vrs/pages/'); $list = array_diff($list, ['.', '..']); //var_dump($list); exit; $alphabet = fopen("/home/romanych/www/vrs/alphabet.html", "w"); fwrite($alphabet, self::$header); foreach ($list as $letter) { fwrite($alphabet, "<div class='letters'><a href='pages/" . $letter . "/tags.html'>" . $letter . "</a></div>"); $alfa_tags = fopen("/home/romanych/www/vrs/pages/" . $letter . "/tags.html", "w"); fwrite($alfa_tags, self::$header); fwrite($alfa_tags, self::$footer); fclose($alfa_tags); } fwrite($alphabet, self::$footer); fclose($alphabet); $tags = Tag::find()->orderBy('name')->all(); //var_dump($tags); exit; //$file = fopen("/home/romanych/www/vrs/tags.html", "w"); //fwrite($file, self::$header); foreach ($tags as $tag) { $first_letter = mb_substr($tag->name, 0, 1, 'UTF-8'); //var_dump($first_letter); exit; $big_first_letter = mb_strtoupper($first_letter, 'UTF-8'); $alfa_tags = fopen("/home/romanych/www/vrs/pages/" . $big_first_letter . "/tags.html", "a"); fwrite($alfa_tags, "<a href='" . TranslateHelper::translit($tag->name) . ".html'><button type='button' class='btn btn-default btn-lg'>{$tag->name}</button></a>"); fwrite($alfa_tags, self::$footer); fclose($alfa_tags); //fwrite($file, "<p><a href='pages/".$big_first_letter."/". TranslateHelper::translit($tag->name) .".html'>$tag->name</a></p>"); $page = fopen("/home/romanych/www/vrs/pages/" . $big_first_letter . "/" . TranslateHelper::translit($tag->name) . ".html", "w"); fwrite($page, '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="../../css/bootstrap.min.css"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <style>.item_head{font-weight: bold;} body{padding-left: 20px; padding-top: 20px;} </style>'); $items = explode(",", $tag->items); $r = 1; foreach ($items as $item) { try { $item = Items::findOne(['id' => (int) $item]); $source = Source::findOne(['id' => $item->source_id]); $author = Author::findOne(['id' => $source->author_id]); fwrite($page, "<p class='item_head'>{$r} {$item->title} ({$author->name} - {$source->title})</p>\n " . $this->renderPlayer($item->audio_link) . "\n " . nl2br("<p>{$item->text}</p>") . "\n\n "); } catch (\ErrorException $e) { echo $e->getMessage() . PHP_EOL; var_dump(Items::findOne(['id' => (int) $item])); } $r++; } fwrite($page, self::$footer); fclose($page); } //fwrite($file, self::$footer); //fclose($file); }