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 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 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 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);
}
public function actionSeriesDelete($id)
{
SeriesModel::model()->where("`id`='" . (int) $id . "'")->delete();
$this->redirect("/admin/series");
}
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);
}
<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;
?>
');" /></td>
$sdWordCount = MovieWordModel::model()->where("`movie_id`='{$movie->id}' AND `series_id`='{$single->id}'")->countAll();
if ($user_major || $single->is_free == 1 || $_SESSION['user']['admin'] == 1) {
$userSingleAdminS = 0;
} else {
$userSingleAdminS = 1;
}
$onclickSeriesPlay = "scriptNextSeriesPlayUpdate2(" . $single->id . "); scrPlayPr(); playVideo('" . $single->url . "', '" . $single->en_sub . "', '" . $single->ru_sub . "','" . $single->sort . "'," . $season->sort . ",'" . $sdSrc . "','" . $single->id . "'," . $single->season_id . "," . $movie->id . ", '" . $sdWordCount . "', '" . $explanationCount . "'," . $userSingleAdminS . "," . $user->id . ");";
?>
<div class="film-item <?php
if (!empty($userSeriesViewsed->id)) {
echo 'viewed';
}
?>
<?php
if (SeriesModel::isNewSeries($single->date) && empty($userSeriesViewsed->id)) {
echo 'new';
}
?>
" style="background-image: url(<?php
echo $sdSrc;
?>
)">
<a href="#" class="series-link-to-play <?php
echo $sdIdFirst;
?>
single_id-<?php
echo $single->id;
?>
" series_id="<?php
echo $sdNum;
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);
}
