public function videoPass(Swf2VidEvent $event)
{
/** @var Video $video */
if ($data = $event->getEventData()) {
if ($video = @Video::find($data['video']['video_id'])) {
if ($user = $event->getUser()) {
if (Video::count(['conditions' => ['project_id = ? and vid_status = "pass" and updated_at > DATE_SUB(NOW(), INTERVAL 10 MINUTE)', $video->project_id]])) {
//redo
return;
}
$minLevel = Swf2Vid::getInstance()->getUserVideoLevel();
$levels = $user->user_level;
/** @var UserLevel $level */
foreach ($levels as $level) {
if ($level->credits > 0) {
if (AccessLevels::getInstance()->checkAccess($level->level, $minLevel)) {
$level->credits = $level->credits - 1;
$level->save_direct();
return;
}
}
}
}
$video->vid_status = 'fail';
$video->save_direct();
}
App::getInstance()->dispatch(Swf2VidEvent::VIDEO_NO_CREDITS, $event);
}
}
public static function generate()
{
// Там еще в сайтмепе есть приоритетность. Для главной ставим самую высокую, для всех категорий чуть ниже и последняя приоритетность для постов
//Создает XML-строку и XML-документ при помощи DOM
$dom = new DomDocument('1.0');
//добавление корня - <books>
$urlset = $dom->appendChild($dom->createElement('urlset'));
$urlset->setAttribute('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9');
// Главная страница
$url = $urlset->appendChild($dom->createElement('url'));
$loc = $url->appendChild($dom->createElement('loc'));
$loc->appendChild($dom->createTextNode("http://" . $_SERVER['SERVER_NAME']));
$priority = $url->appendChild($dom->createElement('priority'));
$priority->appendChild($dom->createTextNode('1.0'));
// Категории фото
$categoryPhoto = CategoryPhoto::find()->all();
foreach ($categoryPhoto as $category) {
$url = $urlset->appendChild($dom->createElement('url'));
$loc = $url->appendChild($dom->createElement('loc'));
$loc->appendChild($dom->createTextNode("http://" . $_SERVER['SERVER_NAME'] . "/category/photo/" . $category->url));
$priority = $url->appendChild($dom->createElement('priority'));
$priority->appendChild($dom->createTextNode('0.7'));
}
// Категории видео
$categoryVideo = Category::find()->all();
foreach ($categoryVideo as $category) {
$url = $urlset->appendChild($dom->createElement('url'));
$loc = $url->appendChild($dom->createElement('loc'));
$loc->appendChild($dom->createTextNode("http://" . $_SERVER['SERVER_NAME'] . "/category/video/" . $category->url));
$priority = $url->appendChild($dom->createElement('priority'));
$priority->appendChild($dom->createTextNode('0.7'));
}
// Страницы фото
$photoCatalog = PhotoCatalog::find()->where('publish = 1')->all();
foreach ($photoCatalog as $photo) {
$url = $urlset->appendChild($dom->createElement('url'));
$loc = $url->appendChild($dom->createElement('loc'));
$loc->appendChild($dom->createTextNode("http://" . $_SERVER['SERVER_NAME'] . "/photo/" . $photo->category->url . "/" . $photo->url));
$priority = $url->appendChild($dom->createElement('priority'));
$priority->appendChild($dom->createTextNode('0.5'));
}
// Страницы видео
$videos = Video::find()->where('publish = 1')->all();
foreach ($videos as $video) {
$url = $urlset->appendChild($dom->createElement('url'));
$loc = $url->appendChild($dom->createElement('loc'));
$loc->appendChild($dom->createTextNode("http://" . $_SERVER['SERVER_NAME'] . "/video/" . $video->category->url . "/" . $video->url));
$priority = $url->appendChild($dom->createElement('priority'));
$priority->appendChild($dom->createTextNode('0.5'));
}
//генерация xml
$dom->formatOutput = true;
// установка атрибута formatOutput
// domDocument в значение true
// save XML as string or file
//$test1 = $dom->saveXML(); // передача строки в test1
$dom->save('../web/sitemap.xml');
// сохранение файла
}
public function init()
{
parent::init();
if ($this->latestVideos === null) {
$User = OvcUser::getCurrentUser();
$courseIds = OvcCourse::getUserCourseIds($User->id);
$this->latestVideos = \app\models\Video::find()->where(['course_id' => $courseIds])->orderBy('id DESC')->limit(16)->all();
}
}
public function preview($vidId)
{
$video = Video::find($vidId);
if ($video) {
$category = VideoCategories::find($video->category_id);
return view('videos.preview')->with('video', $video)->with('category', $category);
}
return redirect("/videos");
}
public function run()
{
if ($this->type == 'video') {
$model = Video::find()->orderBy('hits DESC')->limit(5)->all();
}
if ($this->type == 'photo') {
$model = PhotoCatalog::find()->orderBy('hits DESC')->limit(5)->all();
}
return $this->render('teaser', ['model' => $model, 'type' => $this->type]);
}
/**
* Lists all Video models.
* @return mixed
*/
public function actionIndex()
{
$query = Video::find();
if (!Yii::$app->user->can('admin')) {
$query->andFilterWhere(['block_edit' => 0]);
}
$query->orderBy('id DESC');
$dataProvider = new ActiveDataProvider(['query' => $query]);
return $this->render('index', ['dataProvider' => $dataProvider]);
}
public function run()
{
$model = null;
if ($this->type == 'video') {
$model = Video::find()->where('id <> :id && publish = 1', [':id' => $this->currentId])->orderBy('RAND()')->limit(3)->all();
} else {
$model = PhotoCatalog::find()->where('id <> :id && publish = 1', [':id' => $this->currentId])->orderBy('RAND()')->limit(4)->all();
}
return $this->render($this->type == 'video' ? 'randomize_video' : 'randomize_photo', ['model' => $model]);
}
public function actionView($category = null, $url = null)
{
$video = Video::find()->where("url = :url && publish = 0", [":url" => $url])->one();
if ($video == null) {
throw new HttpException(404);
}
// счетчик показов
$video->updateCounters(['hits' => 1]);
return $this->render('/video/view', ['video' => $video]);
}
public function beforeDelete()
{
//echo "test"; die();
//Video::deleteAll('category_id = :category_id', [':category_id'=>$this->id]);
$videos = Video::find()->where('category_id = :category_id', [':category_id' => $this->id])->all();
foreach ($videos as $v) {
$v->delete();
}
return parent::beforeDelete();
// TODO: Change the autogenerated stub
}
public function actionIndex()
{
$query = Video::find()->where("publish = 1");
// делаем копию выборки
$countQuery = clone $query;
// подключаем класс Pagination, выводим по 10 пунктов на страницу
$pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => 24]);
// приводим параметры в ссылке к ЧПУ
$pages->pageSizeParam = false;
$videos = $query->offset($pages->offset)->orderBy('id DESC')->limit($pages->limit)->all();
return $this->render('index', ['videos' => $videos, 'pages' => $pages]);
}
public function getTarget()
{
$target_type = $this->target_type;
switch ($target_type) {
case 'user':
return User::find($this->target_id);
case 'comment':
return Comment::find($this->target_id);
case 'video':
return Video::find($this->target_id);
default:
return null;
}
}
public function destroy($id)
{
$v = Video::find($id);
if ($v) {
$res = $v->delete();
if ($res) {
return ['error' => false, 'message' => 'Video successfully deleted!'];
} else {
return ['error' => true, 'message' => 'Failed to delete!'];
}
} else {
return ['error' => true, 'message' => 'Video not available!'];
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Video::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'created' => $this->created]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'url', $this->url])->andFilterWhere(['like', 'video', $this->video])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'content', $this->content]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Video::find();
$query->joinWith(['editor']);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->sort->attributes['editor'] = ['asc' => ['bnm_users.name' => SORT_ASC]];
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['ID' => $this->ID, 'user' => $this->user, 'date' => $this->date, 'type' => $this->type]);
$query->andFilterWhere(['like', 'bnm_media.name', $this->name])->andFilterWhere(['like', 'desp', $this->desp])->andFilterWhere(['like', 'author', $this->author])->andFilterWhere(['like', 'url', $this->url])->andFilterWhere(['like', 'bnm_users.name', $this->editor])->andFilterWhere(['like', 'thumbnail', $this->thumbnail]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $paramss
*
* @return ActiveDataProvider
*/
public function search($params)
{
$userCourseIds = \app\components\OvcCourse::getUserCourseIds();
$commentCount = "(SELECT COUNT(*) AS nos FROM comment AS c WHERE c.video_id = video.id)";
$query = Video::find()->select("video.*, course.name, {$commentCount} as commentCount")->innerJoin('course', '`video`.`course_id` = `course`.`id`')->where(['video.course_id' => $userCourseIds]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => Yii::$app->params['pageSize']]]);
/**
* additional columns to be sorted
*/
$dataProvider->sort->attributes['courseName'] = ['asc' => ['course.name' => SORT_ASC], 'desc' => ['course.name' => SORT_DESC]];
$dataProvider->sort->attributes['commentCount'] = ['asc' => ['commentCount' => SORT_ASC], 'desc' => ['commentCount' => SORT_DESC]];
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['video.id' => $this->id, 'video.course_id' => $this->course_id, 'video.user_id' => $this->user_id, 'video.created_at' => $this->created_at, 'video.modified_at' => $this->modified_at, $commentCount => $this->commentCount]);
$query->andFilterWhere(['like', 'video.title', $this->title])->andFilterWhere(['like', 'video.description', $this->description])->andFilterWhere(['like', 'video.path', $this->path])->andFilterWhere(['like', 'course.name', $this->courseName]);
return $dataProvider;
}
public function actionIndex($type, $url)
{
if ($type != 'photo' && $type != 'video') {
throw new HttpException(404);
}
if ($type == 'video') {
$category = Category::find()->where('url = :url', [':url' => $url])->one();
}
if ($type == 'photo') {
$category = CategoryPhoto::find()->where('url = :url', [':url' => $url])->one();
}
if ($category == null) {
throw new HttpException(404);
}
if ($type == 'video') {
$videos = Video::find()->where('category_id = :category_id && publish = :publish', [':category_id' => $category->id, ':publish' => 1])->orderBy('id DESC')->all();
return $this->render('video', ['videos' => $videos, 'category' => $category]);
}
if ($type == 'photo') {
$photo = PhotoCatalog::find()->where('category_id = :category_id && publish = :publish', [':category_id' => $category->id, ':publish' => 1])->orderBy('id DESC')->all();
return $this->render('photo', ['photos' => $photo, 'category' => $category]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Video::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 5]]);
$_column = [Video::tableName() . '.id', Video::tableName() . '.video_url', Video::tableName() . '.title_' . Yii::$app->language, Video::tableName() . '.description_' . Yii::$app->language, Video::tableName() . '.create_date', Video::tableName() . '.created_by', Video::tableName() . '.status'];
$query->joinWith(['createdBy']);
$query->select($_column)->distinct();
if ($this->filter) {
$query->joinWith(['videoTags']);
}
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'create_date' => $this->create_date]);
$query->andFilterWhere(['like', 'search', $this->search])->andFilterWhere(['like', 'video_code', $this->video_code])->andFilterWhere(['like', 'video_url', $this->video_url])->andFilterWhere(['like', 'title_ar', $this->title_ar])->andFilterWhere(['like', 'title_en', $this->title_en])->andFilterWhere(['like', 'description_ar', $this->description_ar])->andFilterWhere(['like', 'description_en', $this->description_en])->andFilterWhere(['like', 'status', $this->status]);
if ($this->filter) {
$query->andFilterWhere(['IN', VideoTag::tableName() . '.tag_id', $this->video_tag]);
}
$query->orderBy('create_date DESC');
return $dataProvider;
}
/**
* Lists all Video models.
* @return mixed
*/
public function actionIndex()
{
$dataProvider = new ActiveDataProvider(['query' => Video::find()]);
return $this->render('index', ['dataProvider' => $dataProvider]);
}
public function actionIndex()
{
return $this->render('index', ['video' => Video::find()->one(), 'concerts' => Concert::find()->where(['>=', 'date', date('Y-m-d')])->orderBy('date desc')->all(), 'showArchives' => Concert::find()->where(['<=', 'date', date('Y-m-d')])->count() > 0]);
}
/**
* Delete and Image of a Product
* AJAX
*
* @param Request $request
* @return JSON
*/
public function deleteMedium(Request $request)
{
if ($request->ajax()) {
if ($request->mediaType == 'image') {
$image = Image::find($request->mediaId);
// Check if file exists in the storage
if (Storage::disk('public')->exists('/images/product/' . $image->name)) {
$fullFilePath = '/images/product/' . $image->name;
Storage::disk('public')->delete($fullFilePath);
}
$image->delete();
} else {
if ($request->mediaType = 'video') {
$video = Video::find($request->mediaId);
// Check if file exists in the storage
if (Storage::disk('public')->exists('/videos/product/' . $video->name)) {
$fullFilePath = '/videos/product/' . $video->name;
Storage::disk('public')->delete($fullFilePath);
}
$video->delete();
}
}
return response()->json('File deleted', 200);
}
}
// ],
//
// ]);
?>
</div>
</div>
</div>
<div class="g w1140 main">
<!-- slider -->
<!-- main -->
<div class="c-c">
<div class="c">
<?php
$countVideo = \app\models\Video::find()->count('*');
?>
<p class="fs24 fw300 text-center opensans"><a class="pink" href="/video" title="Эксклюзивные порно фото и видео в HD качестве!">Смотреть <span class="fw700"><?php
echo $countVideo;
?>
+</span> видео в <span class="fw700">HD качестве</span></a></p>
</div>
<?php
echo \app\components\widgets\CategoryWidget::widget(['type' => 'video']);
?>
<!-- intro text -->
<div class="c text-center">
<h1 class="fs22 fw400 opensans"><?php
echo $dataPage->title_video;
/**
* Remove the specified Video from storage.
*
* @param int $id
*
* @return Response
*/
public function destroy($id)
{
$video = Video::find($id);
if (empty($video)) {
Flash::error('Video not found');
return redirect(route('videos.index'));
}
$video->delete();
Flash::success('Video deleted successfully.');
return redirect(route('videos.index'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Response
*/
public function destroy(Request $request, $id)
{
$user = auth()->check() ? auth()->user() : null;
if (is_null($user)) {
return new JsonResponse(['error' => 'not_logged_in']);
}
if (!$request->has('reason') || trim($request->get('reason')) == '') {
return new JsonResponse(['error' => 'invalid_request']);
}
$reason = trim($request->get('reason'));
if ($user->can('delete_video')) {
$warnings = [];
$vid = Video::find($id);
if (!$vid) {
return new JsonResponse(['error' => 'video_not_found']);
}
foreach ($vid->comments as $comment) {
$comment->delete();
// delete associated comments
}
$vid->faved()->detach();
if (!\File::move(public_path() . '/b/' . $vid->file, storage_path() . '/deleted/' . $vid->file)) {
$warnings[] = 'Could not move file';
}
$vid->delete();
$receiver = $vid->user;
if ($user->id != $receiver->id) {
Message::send(1, $receiver->id, 'A moderator deleted your video', view('messages.moderation.videodelete', ['video' => $vid, 'reason' => $reason, 'videoinfo' => ['artist' => $vid->interpret, 'songtitle' => $vid->songtitle, 'video_source' => $vid->imgsource, 'category' => $vid->category->name]]));
}
$log = new ModeratorLog();
$log->user()->associate($user);
$log->type = 'delete';
$log->target_type = 'video';
$log->target_id = $id;
$log->reason = $reason;
$log->save();
return new JsonResponse(['error' => 'null', 'warnings' => $warnings]);
}
return new JsonResponse(['error' => 'insufficient_permissions']);
}
public function actionIndex()
{
$videos = Video::find()->where('publish = :publish', [":publish" => 1])->orderBy('id DESC')->limit(9)->all();
$photos = PhotoCatalog::find()->where('publish = :publish', [":publish" => 1])->orderBy('id DESC')->limit(12)->all();
return $this->render('index', ['videos' => $videos, 'photos' => $photos]);
}
public function actionMedia($type, $cat = 0, $order = 'date', $asc = 'desc', $name = "", $desp = "", $author = "")
{
$query;
$typeid;
if ($type == 'album') {
$query = Album::find();
$typeid = 0;
} else {
if ($type == 'video') {
$query = Video::find();
$typeid = 1;
} else {
$query = Message::find();
$typeid = 2;
}
}
$pagination = new Pagination(['defaultPageSize' => 30, 'totalCount' => $query->count()]);
$query->distinct();
$catArr = [];
if ($cat) {
$query->joinWith("category");
$catArr = explode(',', $cat);
$query->andWhere(['or', ['bnm_category_relationships.category' => $catArr]]);
}
$query->joinWith("editor");
$query->andFilterWhere(['like', 'bnm_media.name', $name]);
$query->andFilterWhere(['like', 'bnm_media.desp', $desp]);
$query->orderBy($order . ' ' . $asc)->offset($pagination->offset)->limit($pagination->limit);
//->asArray()
//
$catQuery = Category::find()->joinWith("categoryRelationship")->andWhere(['bnm_category_relationships.type' => $typeid])->distinct();
return $this->render('media', ['media' => $query->all(), 'categories' => $catQuery->all(), 'pagination' => $pagination, 'catArr' => $catArr, 'catUrl' => $cat, 'oldCat' => ['cat' => $cat], 'oldOrder' => ['order' => $order, 'asc' => $asc], 'oldSearch' => ['name' => $name, 'desp' => $desp, 'author' => $author], 'type' => $type, 'typeid' => $typeid, 'asc' => $asc, 'order' => $order, 'name' => $name, 'desp' => $desp, 'author' => $author]);
}
/**
* Return unconverted videos
*
* @param int $limit
* @param string $orderBy
* @return array|\yii\db\ActiveRecord[]
*/
public static function getUnconvertedVideo($limit = 5, $orderBy = 'created_at ASC')
{
return Video::find()->where(['status' => Video::STATUS_ENCODE_WAIT])->orderBy($orderBy)->limit($limit)->all();
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function publish($slug)
{
$video = Video::find($slug);
$video->update(['is_published' => $video->is_published ? 0 : 1]);
return Redirect::route('videos.admin');
}
public function postAddFavorite($video_id)
{
if (Auth::guest()) {
return ['status' => 'red', 'message' => 'You have to be logged to add this video in your favorites'];
} else {
$favorited = DB::table('favorited')->where('user_id', Auth::user()->id)->where('video_id', $video_id)->first();
if (is_null($favorited)) {
DB::table('favorited')->insert(['user_id' => Auth::user()->id, 'video_id' => $video_id]);
Video::find($video_id)->increment('nb_favorited');
return ['status' => 'green', 'message' => 'This video is in you favorites now'];
} else {
return ['status' => 'red', 'message' => 'This video is already in your favorites'];
}
}
}
public function actionIndex()
{
$videos = Video::find()->where("create_at > (now() - interval 7 day) && publish = 1")->orderBy('id DESC')->all();
$photos = PhotoCatalog::find()->where("create_at > (now() - interval 7 day) && publish = 1")->orderBy('id DESC')->all();
return $this->render('index', ['videos' => $videos, 'photos' => $photos]);
}
public function postFastDelete($elements, Request $request)
{
switch ($elements) {
case 'videos':
$elements = $request->input('elements');
$elements = explode(' ', $elements);
PHPRedis::delete($elements);
foreach ($elements as $element) {
// delete video from database
$elemId = Video::find($element);
if (!is_null($elemId)) {
$elemId->delete();
}
// delete folder
$destination = public_path("users_content/videos/{$element}");
if (File::exists($destination)) {
File::deleteDirectory($destination);
}
// delete comments from database
Comment::where('video_id', $element)->delete();
}
return redirect()->back()->with('message_success', 'Elements have been deleted');
break;
case 'users':
$elements = $request->input('elements');
$elements = explode(' ', $elements);
foreach ($elements as $element) {
$elem = User::find($element);
if (!is_null($elem)) {
$elem->delete();
}
}
return redirect()->back()->with('message_success', 'Elements have been deleted');
break;
default:
$elements = $request->input('elements');
$elements = explode(' ', $elements);
foreach ($elements as $element) {
$elem = Comment::find($element);
if (!is_null($elem)) {
$elem->delete();
}
}
return redirect()->back()->with('message_success', 'Elements have been deleted');
break;
}
}
