public function actionSearch()
{
$key = $_POST['key'];
$search_results = MoviesModel::model()->where(" `en_name` LIKE '%" . $key . "%' OR `ru_name` LIKE '%" . $key . "%' AND type = '2' ")->findAll();
$i = 0;
if (empty($key)) {
$message = 'Ключ поиска пустой!';
}
foreach ($search_results as $item) {
$seasons = SeasonModel::model()->where(" `serial_id` = '" . $item->id . "' ")->findAll();
$season_count = 0;
$series_count = 0;
foreach ($seasons as $season) {
$season_count++;
$series = SeriesModel::model()->where(" `season_id` = '" . $season->id . "' ")->countAll();
$series_count = $series_count + $series;
}
//echo 'season_count = '.$season_count.'<br/>';
//echo 'series_count = '.$series_count.'<br/>';
$result[$i]['title'] = $item->ru_name;
$result[$i]['poster'] = $item->poster;
$result[$i]['seo_url'] = $item->seo_url;
$result[$i]['title'] = $item->ru_name;
$result[$i]['poster'] = $item->poster;
$result[$i]['seo_url'] = $item->seo_url;
$result[$i]['rating'] = $item->rating;
$result[$i]['type'] = $item->type;
$result[$i]['en_name'] = $item->en_name;
//$result[$i]['seo_url'] = $item->seo_url;
$result[$i]['seasons_count'] = $this->declension($season_count, array("сезон", "сезона", "сезонов"));
$result[$i]['series_count'] = $this->declension($series_count, array("серии", "серии", "серий"));
$i++;
}
$this->view("search_result", array("search_result" => $result, "search_key" => $key, "message" => $message), false);
}
public function actionCatalog($symbol)
{
$symbol = urldecode($symbol);
$symbol = str_replace(array("'", '"'), array(""), $symbol);
$movies = MoviesModel::model()->where("`en_name` LIKE '{$symbol}%' OR `ru_name` LIKE '{$symbol}%'")->findAll();
$this->view("category/catalog", array("movies" => $movies, "symbol" => $symbol), false);
}
public static function fields($key)
{
$fields = array("id" => array("name" => "Id", "required" => false, "type" => "text"), "serial_id" => array("name" => "Сериал", "required" => true, "type" => "list", "data" => function () {
$data = array();
$serials = MoviesModel::model()->serials()->findAll();
foreach ($serials as $serial) {
$data[$serial->id] = $serial->en_name;
}
return $data;
}), "sort" => array("name" => "Номер сезона", "required" => true, "type" => "text"));
return isset($fields[$key]) ? $fields[$key] : false;
}
public function notificationNewSeries()
{
$subject = "http://" . $_SERVER['SERVER_NAME'] . " Здравствуйте, у нас есть обновления по вашим подпискам";
$headers = "Content-type: text/html; charset=utf-8 \r\n";
$headers .= "From: support@cpiki.com";
$users = UsersModel::model()->where(" `subscribe_new_series` = '1' ")->findAll();
foreach ($users as $user) {
echo $to = $user->email;
$body = "<table width='700'><tr><td style='background-color: black;color: white;font-size: 22px;line-height: 40px; color:#fff; padding-left: 20px;'>cpiki</td></tr><tr><td style=' font-size: 20px; line-height: 100px;padding-left: 50px;'>Здравствуйте, у нас есть обновления по вашим подпискам</td></tr><tr><td>";
$body .= "<table>";
$num = 0;
$serials = UserSubscribeModel::model()->where("`user_id` = {$user->id} ")->findAll();
foreach ($serials as $serial) {
$movie = MoviesModel::model()->where("`id` = {$serial->serial_id} ")->findRow();
$seasons = SeasonModel::model()->where("`serial_id` = '{$movie->id}'")->findAll();
foreach ($seasons as $season) {
$series = SeriesModel::model()->where(" `season_id` = {$season->id} ")->findAll();
foreach ($series as $single) {
if (SeriesModel::isNewSeries($single->date)) {
$sdSrc = $movie->poster;
if (!file_exists($_SERVER['DOCUMENT_ROOT'] . $sdSrc)) {
$sdSrc = "/assets/images/templates/no_image.png";
}
$body .= "<tr><td style=' line-height: 40px;'><img width='150' src='http://" . $_SERVER['SERVER_NAME'] . $sdSrc . "' /></td>";
$body .= "<td style=' vertical-align: top; padding-left: 20px;' ><p style=' line-height: 80px; font-size: 20px;'><a href='http://" . $_SERVER['SERVER_NAME'] . "/serials/" . $movie->seo_url . "' >" . $movie->en_name . "</a></p>";
$body .= "<p style=' font-size: 16px; color: rgb(126, 126, 126);'>" . $single->sort . " серия " . $season->sort . "-го сезона </p></td></tr>";
$num++;
}
}
}
}
$body .= "</table></td></tr></table>";
echo $body . "<br/>";
if ($num > 0) {
mail($to, $subject, $body, $headers);
}
}
}
public function perC($cur_time, $series_id)
{
$ser_timing = 0;
$percents = 0;
$serial_name = SeriesModel::model()->where("`id`='" . $series_id . " ' ")->findRow();
if (!empty($serial_name->id)) {
$ser_timing = $serial_name->timing;
}
if (empty($ser_timing) || $ser_timing == 0) {
$movies_b = MoviesModel::model()->get_series($series_id);
$ser_timing = MoviesModel::model()->getTimeToInt($movies_b->rating);
}
if ($cur_time < $ser_timing && !empty($ser_timing)) {
$percents = $cur_time / $ser_timing * 100;
$percents = (int) $percents;
} else {
$percents = 100;
}
return array($percents, $ser_timing);
}
?>
</div>
</div>
<div class="content-page-sidebar-block">
Жанр
<div><?php
echo CatsModel::getName(CatsModel::model()->where("`id`='{$movie->cat_id}'")->findRow());
?>
</div>
</div>
</div>
<div class="content-page-wrap content-page-text">
<h1>О фильме</h1>
<p><?php
echo MoviesModel::getDesc($movie);
?>
</p>
</div>
</div>
<style>
.bx-wrapper .bx-controls-direction a {
display: inline-block;
vertical-align: top;
width: 42px !important;
height: 42px !important;
background: #87a1e5 !important;
margin-right: 46px;
position: relative; float: left;
}
.bx-wrapper .bx-controls-direction a.bx-prev:before, .bx-wrapper .bx-controls-direction a.bx-next:before {
foreach ($movies as $movie) {
?>
<tr class="<?php
echo $movie->id % 2 == 0 ? 'odd' : 'even';
?>
">
<td><?php
echo $movie->id;
?>
</td>
<td><?php
echo $movie->en_name;
?>
</td>
<td><?php
echo MoviesModel::itemAlias($movie->type);
?>
</td>
<td>
<!-- <a href="/admin/pikibook/?movie=<?php
echo $movie->id;
?>
">PikiBook</a> -->
</td>
<td>
<!-- <a href="/admin/explanation/?movie=<?php
echo $movie->id;
?>
">Видеообъяснения</a> -->
</td>
<td class="button-column">
public function search()
{
$key = $_POST['key'];
$learned = $_POST['learned'];
$words = DictModel::model()->where(" (en_word LIKE '%" . $key . "%' OR ru_word LIKE '%" . $key . "%') AND `user_id` = '" . Auth::getUser()['id'] . "' ")->findAll();
$html = '<div class="dictionary_items_table" id="toPrint">
<table class="table">
<tr>
<td class="title">
Слово:
</td>
<td class="title">
Фраза:
</td>
<td class="title">
Добавлено:
</td>
</tr> ';
foreach ($words as $word) {
$moovie = MoviesModel::model()->where("`id`='" . $word->movie_id . "' ")->findRow();
$series = SeriesModel::model()->where("`id`='" . $word->series_id . "' ")->findRow();
$from = $moovie->en_name . " - " . $series->name;
/*$html .= '<tr>
<input type="hidden" id="learned_'.$word->id.'" />
<td><input type="checkbox" id="check_'.$word->id.'" onchange="check(\''.$word->id.'\');" /></td>
<td>'.$word->en_word.' - '.$word->ru_word.'</td>
<td>'.$word->phrase.'</td> <td>'.$from.'</td>
</tr>';*/
$html .= '<tr><input type="hidden" id="learned_' . $word->id . '" />
<td>
<div class="checkbox check_item">
<label><input type="checkbox" id="check_' . $word->id . '" onchange="check(\'' . $word->id . '\');" /></label>
</div> <i class="glyphicon glyphicon-volume-up"></i>
<div class="ttext">
' . $word->en_word . ' - ' . $word->ru_word . '
</div>
</td>
<td>
<i class="glyphicon glyphicon-volume-up"></i>
<div class="ttext">
' . $word->phrase . '.<br/>
<span class="grey_color">Кэрол вывезла свои вещи сегодня.</span>
</div>
</td>
<td>
<div class="ttext">
<span class="grey_color">Взято 20.05.2015 из:</span><br/>
' . $from . '
</div>
</td>
</tr>';
}
$html .= '</table>';
echo $html;
}
public function sendTextErrorSeries()
{
$userAdmin = UsersModel::model()->where(" `id` = '1' ")->findRow();
$user = UsersModel::model()->where(" `id` = '{$_SESSION['user']['id']}' ")->findRow();
$series = SeriesModel::model()->where(" `id` = '{$_POST['series_id']}' ")->findRow();
$movie = MoviesModel::model()->where(" `id` = '{$_POST['movie_id']}' ")->findRow();
$to = $userAdmin->email;
$subject = "http://" . $_SERVER['SERVER_NAME'] . " Сообщение об ошибке";
$body = "<p>Сериал: id: " . $movie->id . ", en_name: " . $movie->en_name . ", ru_name: " . $movie->ru_name . "</p>";
$body .= "<p>Сезон: id: " . $_POST['season_id'] . "</p>";
$body .= "<p>Серия: id: " . $series->id . ", name: " . $series->name . "</p>";
$body .= "<p>Пользователь: id: " . $user->id . " login: "******"</p>";
$body .= "<p>Ошибка: " . $_POST['text'] . "</p>";
$headers = "Content-type: text/html; charset=utf-8 \r\n";
$headers .= "From: support@cpiki.com";
echo "Отправлено";
mail($to, $subject, $body, $headers);
}
private function getMovies()
{
$sort = isset($_GET['sort']) ? $_GET['sort'] : 'id';
$type = isset($_GET['type']) ? $_GET['type'] : 'desc';
return MoviesModel::model()->order("{$sort} {$type}")->findAll();
}
private function advancedSearch()
{
$sort = $_GET['sortby'] . " " . strtoupper($_GET['resorder']);
if (isset($_GET['all_word_search'])) {
$q = $_GET['q'];
} else {
$q = "%" . $_GET['q'] . "%";
}
$where = "`en_name` LIKE '{$q}' OR `ru_name` LIKE '{$q}'";
if ((int) $_GET['cat'] != 0) {
$where .= " AND `cat_id` = '{$_GET['cat']}'";
}
return MoviesModel::model()->where($where)->order($sort)->findAll();
}
public function actionPikibookEdit($id)
{
if (isset($_POST['save'])) {
$model = new MovieWordModel();
$model->id = $_POST['id'];
$model->en_word = $_POST['en_word'];
$model->ru_word = $_POST['ru_word'];
$model->movie_id = $_POST['movie_id'];
$model->series_id = $_POST['series_id'];
$model->save();
$this->redirect("/admin/pikibook");
} else {
$movies = MoviesModel::model()->order(" ru_name asc ")->findAll();
$word = MovieWordModel::model()->where("`id`='{$id}'")->findRow();
$this->view("admin/pikibook/pikibook_edit", array("word" => $word, "movies" => $movies), false);
}
}
<a onclick="open_group_list();" role="button" data-toggle="modal"><img src="/assets/images/icons5.png" alt="" class="img-resp"></a>
<div class="arrow_tooltip">
<span class="arrow_grey "><i class="arrow_box arrow_box_top">Перенести в набор</i></span></div>
</li>
</ul>
</div>
</div>
<div class="table-wrap">
<table>
<?php
foreach ($words as $word) {
$ids .= $word->id . ',';
$moovie = MoviesModel::model()->where("`id`='" . $word->movie_id . "' ")->findRow();
$series = SeriesModel::model()->where("`id`='" . $word->series_id . "' ")->findRow();
if (!empty($moovie->en_name) && !empty($series->name)) {
$from = $moovie->en_name . " - " . $series->name;
}
?>
<tr><input type="hidden" id="row_<?php
echo $word->id;
?>
" />
<td class="checkbox t1" onselectstart="return false" onmousedown="return false"><input type="checkbox" id="check_<?php
echo $word->id;
?>
" onchange="check('<?php
echo $word->id;
?>
</div>
<?php
} else {
foreach ($viewed_series as $view) {
$serial_id = MoviesModel::model()->get_series($view->series_id);
$serial_name = MoviesModel::model()->get_seriesName($view->series_id);
//$season_table = MoviesModel::model()->get_seriesSeason($view->series_id);
$on = $view->series_id;
$newdate = strtotime($view->date);
$month = date('m', $newdate);
$month = MoviesModel::model()->getRusMonth($month);
//$userSV = UserSeriesViewedModel::model()->where(" `series_id` = '{$view->series_id}' AND `user_id`= '{$_SESSION['user']['id']}' ")->findRow();
if (!empty($view->id)) {
$v_time = $view->viewed;
if (!empty($v_time) && !empty($view->series_id)) {
$perc = MoviesModel::perC($v_time, $view->series_id);
if (!empty($perc[0])) {
$per = $perc[0];
} else {
$per = 0;
}
if (!empty($perc[1])) {
$time = $perc[1];
} else {
$time = 'N/A';
}
} else {
$v_time = 0;
}
}
?>
</h2>
<h3><?php
echo $collections->description;
?>
</h3>
</div>
</div>
<div class="">
<div class="col-md-12">
<div class="list_film_in_sezon serials_list">
<ul>
<?php
foreach ($content_collections as $collection) {
$issetFreeSeries = MoviesModel::issetFreeSeries($collection->serial_id);
$issetPikiBookSeries = MoviesModel::issetPikiBookSeries($collection->serial_id);
$movie = MoviesModel::model()->where("`id`='{$collection->serial_id}'")->findRow();
?>
<li>
<div class="img_block">
<img class="series-link-to-play single_id-1209" series_id="6" single_id="1209" id="series_id-6" data-target="#show-video" onclick="window.location.href='/serials/<?php
echo $movie->seo_url;
?>
';" src="<?php
if (file_exists($_SERVER['DOCUMENT_ROOT'] . $movie->poster)) {
echo $movie->poster;
} else {
echo '/assets/images/templates/no_image.png';
}
?>
" alt="<?php
echo $collection->ru_name;
<th class="button-column" id="city-grid_c2"> </th></tr>
</thead>
<tbody>
<?php
foreach ($explanations as $word) {
?>
<tr class="<?php
echo $word->id % 2 == 0 ? 'odd' : 'even';
?>
">
<td><?php
echo $word->id;
?>
</td>
<td><?php
$movie = MoviesModel::model()->where("`id` = '{$word->movie_id}' ")->findRow();
echo $movie->ru_name;
?>
</td>
<td><?php
echo $word->series_id;
?>
</td>
<td><?php
echo $word->link;
?>
</td>
<td><?php
echo $word->text;
?>
</td>
public function actionSeriesEdit($id)
{
$model = SeriesModel::model()->where("`id`='" . (int) $id . "'")->findRow();
if (isset($_POST['Series'])) {
$model->setAttrs($_POST['Series']);
$model->date = date("Y-m-d H:i:s");
if ($_FILES['en_sub']['name']) {
$model->en_sub = File::save($_FILES['en_sub'], "assets/subs");
}
if ($_FILES['ru_sub']['name']) {
$model->ru_sub = File::save($_FILES['ru_sub'], "assets/subs");
}
$model->save();
$movieId = SeasonModel::model()->where("`id`='" . (int) $model->season_id . "'")->findRow()->serial_id;
$movie_date = MoviesModel::model()->where("`id`='{$movieId}'")->findRow();
$movie_date->date = date("Y-m-d H:i:s");
$movie_date->save();
$this->redirect("/admin/series");
}
$this->view("admin/serial/series_form", array("model" => $model), false);
}
public function actionDict()
{
$userId = Auth::getUser()['id'];
$favors = FavoritesModel::model()->where("`user_id`='{$userId}'")->findAll();
$in = "(";
foreach ($favors as $favor) {
$in .= "'{$favor->video_id}'" . ", ";
}
$in = substr($in, 0, -2);
$in .= ")";
if ($in == ")") {
$movies = array();
} else {
$movies = MoviesModel::model()->where("`id` IN {$in}")->findAll();
}
$movies_count = MoviesModel::model()->where("`id` IN {$in}")->countAll();
$dicts = DictModel::model()->where("`user_id`='" . Auth::getUser()['id'] . "'")->countAll();
//echo $dicts;
$dict_groups = DictGroupsModel::model()->where("`user_id`='" . Auth::getUser()['id'] . "'")->findAll();
$this->view("profile/dict", array("dicts" => $dicts, "groups" => $dict_groups, "movies_count" => $movies_count), false);
}
if (sizeof($viewed_series) == 0) {
?>
<div class="col-xs-12 margin_top_30 margin_30_0">
На данный момент история просмотров пуста!
</div>
<?php
} else {
?>
<div class="col-xs-6 text-right mobile_align dop_info_history">
<i class="glyphicon glyphicon-star"></i><span>- просмотренные видео (<a id="hide_show_link">скрыть</a>)</span>
</div>
<div class="col-xs-12 margin_top_30 ">
<ul class="history_list">
<?php
foreach ($viewed_series as $view) {
$serial_id = MoviesModel::model()->get_series($view->series_id);
?>
<li>
<table class="table table_history_user">
<tr>
<td><i class="glyphicon glyphicon-star"></i></td>
<td><i class="glyphicon glyphicon-calendar"></i> <span><?php
echo $view->date;
?>
</span></td>
<td><i class="icon_mouse"></i> <span><?php
echo $serial_id->en_name;
?>
</span></td>
</tr>
</table>
">Колекция</a></th>
<th id="city-grid_c1"><a class="sort-link" href="<?php
echo Admin::makeSort("description");
?>
">Сериал</a></th>
<th class="button-column" id="city-grid_c2"> </th></tr>
</thead>
<tbody>
<?php
foreach ($model as $conentent) {
?>
<?php
$collectionName = CollectionsModel::model()->where("`id`=" . $conentent->collection_id)->findRow();
?>
<?php
$serialName = MoviesModel::model()->where("`type`='2' and `id`=" . $conentent->serial_id)->findRow();
?>
<tr class="<?php
echo $conentent->id % 2 == 0 ? 'odd' : 'even';
?>
">
<td><?php
echo $conentent->id;
?>
</td>
<td><?php
echo $collectionName->name;
?>
</td>
public function actionAllMovies()
{
if (isset($_POST['category']) && $_POST['category'] != "0") {
$query = " `cat_id` = '" . $_POST['category'] . "'";
}
if (isset($_POST['difficulty']) && $_POST['difficulty'] != "0") {
if (!empty($query)) {
$query .= " AND ";
}
$query .= " `in_roles` = '" . $_POST['difficulty'] . "' ";
}
if (empty($query)) {
$moovies_list = MoviesModel::model()->where(" `type` = '2' ")->findAll();
} else {
$query .= " AND `type` = '2' ";
$moovies_list = MoviesModel::model()->where($query)->findAll();
}
$i = 0;
//echo 'query = '.$query;
foreach ($moovies_list as $item) {
$seasons = SeasonModel::model()->where(" `serial_id` = '" . $item->id . "' ")->findAll();
$season_count = 0;
$series_count = 0;
foreach ($seasons as $season) {
$season_count++;
$series = SeriesModel::model()->where(" `season_id` = '" . $season->id . "' ")->countAll();
$series_count = $series_count + $series;
}
//echo 'season_count = '.$season_count.'<br/>';
//echo 'series_count = '.$series_count.'<br/>';
$result[$i]['id'] = $item->id;
$result[$i]['title'] = $item->ru_name;
$result[$i]['poster'] = $item->poster;
$result[$i]['seo_url'] = $item->seo_url;
$result[$i]['rating'] = $item->rating;
$result[$i]['type'] = $item->type;
$result[$i]['en_name'] = $item->en_name;
//$result[$i]['seo_url'] = $item->seo_url;
$result[$i]['seasons_count'] = $this->declension($season_count, array("сезон", "сезона", "сезонов"));
$result[$i]['series_count'] = $this->declension($series_count, array("серии", "серии", "серий"));
$i++;
}
$categories = CatsModel::model()->findAll();
$this->view("movies/moovies_list", array("moovies" => $result, "categories" => $categories, "chosed_category" => $_POST['category'], "chossed_difficulty" => $_POST['difficulty']), false);
}
