public function index() { if (Auth::user()->check()) { $page = Input::has('page') ? Input::get('page') : 1; $take = Input::has('take') ? Input::get('take') : 20; $skip = ($page - 1) * $take; $data = VIImage::select('images.id', 'image_details.detail_id', 'image_details.width', 'image_details.height', 'image_details.dpi', 'image_details.size', 'image_details.size_type', 'image_details.path', 'images.name', 'images.short_name', 'images.description', 'images.store')->leftJoin('image_details', function ($join) { $join->on('image_details.image_id', '=', 'images.id'); })->where('images.author_id', Auth::user()->get()->id)->orderBy('images.id', 'desc')->groupBy('images.id'); $total_image = $data->get()->count(); $total_page = ceil($total_image / $take); $from = $page - 2 > 0 ? $page - 2 : 1; $to = $page + 2 <= $total_page ? $page + 2 : $total_page; $data = $data->skip($skip)->take($take)->get(); $arrImages = array(); if ($data->count() > 0) { $i = 0; foreach ($data as $key => $value) { $arrImages[$i]['image_id'] = $value->id; $arrImages[$i]['detail_id'] = $value->detail_id; $arrImages[$i]['name'] = $value->name; $arrImages[$i]['short_name'] = $value->short_name; $arrImages[$i]['description'] = $value->description; $arrImages[$i]['store'] = $value->store; $arrImages[$i]['path'] = '/pic/with-logo/' . $value->short_name . '-' . $value->id . '.jpg'; $i++; } } $this->layout->metaTitle = Auth::user()->get()->first_name . '\'s Uploads'; $this->layout->content = View::make('frontend.upload.index', ['files' => $arrImages, 'categories' => Category::getSource(), 'total_image' => $total_image, 'total_page' => $total_page, 'current' => $page, 'from' => $from, 'to' => $to]); return; } return Redirect::route('account-sign-in'); }
public function index() { if (!Input::has('page')) { $pageNum = 1; } else { $pageNum = (int) Input::get('page'); } $admin_id = Auth::admin()->get()->id; $arrCategories = []; $name = ''; $take = $this->take; $skip = floor(($pageNum - 1) * $take); $images = VIImage::select('id', 'name', 'short_name', 'description', 'keywords', 'artist', 'model', 'gender', 'age_from', 'age_to', 'number_people', DB::raw('(SELECT COUNT(*) FROM notifications WHERE notifications.item_id = images.id AND notifications.item_type = "Image" AND notifications.admin_id = ' . $admin_id . ' AND notifications.read = 0 ) as new'))->withType('main')->with('categories')->with('collections'); if (Input::has('categories')) { $arrCategories = (array) Input::get('categories'); $images->whereHas('categories', function ($query) use($arrCategories) { $query->whereIn('id', $arrCategories); }); } if (Input::has('name')) { $name = Input::get('name'); $nameStr = '*' . $name . '*'; $images->search($nameStr); } $images = $images->take($take)->skip($skip)->orderBy('id', 'desc')->get(); $arrImages = []; if (!$images->isempty()) { $arrImages = $arrRemoveNew = []; foreach ($images as $image) { $image->path = URL . '/pic/large-thumb/' . $image->short_name . '-' . $image->id . '.jpg'; $image->dimension = $image->width . 'x' . $image['height']; if ($image->new) { $arrRemoveNew[] = $image->id; } $arrImages[$image->id] = $image; foreach (['arrCategories' => ['name' => 'categories', 'id' => 'id'], 'arrCollections' => ['name' => 'collections', 'id' => 'id']] as $key => $value) { $arr = []; foreach ($image->{$value}['name'] as $v) { $arr[] = $v[$value['id']]; } $arrImages[$image->id][$key] = $arr; } unset($arr); } if (!empty($arrRemoveNew)) { Notification::whereIn('item_id', $arrRemoveNew)->where('item_type', 'Image')->where('admin_id', $admin_id)->update(['read' => 1]); } } if (Request::ajax()) { return $arrImages; } $this->layout->title = 'Images'; $this->layout->content = View::make('admin.images-all')->with(['images' => $arrImages, 'pageNum' => $pageNum, 'categories' => Category::getSource(), 'name' => $name, 'arrCategories' => $arrCategories, 'collections' => Collection::getSource(), 'apiKey' => Configure::getApiKeys()]); }
public function getImages() { if (!Request::ajax()) { return App::abort(404); } $id = Input::has('id') ? Input::get('id') : 0; if (!Input::has('page')) { $pageNum = 1; } else { $pageNum = (int) Input::get('page'); } $name = ''; $take = 25; $skip = floor(($pageNum - 1) * $take); $images = VIImage::select('id', 'name', 'short_name')->withType('main')->whereRaw('id NOT IN (SELECT image_id FROM collections_images WHERE collection_id = ?)', [$id]); if (Input::has('categories')) { $arrCategories = (array) Input::get('categories'); $images->whereHas('categories', function ($query) use($arrCategories) { $query->whereIn('id', $arrCategories); }); } if (Input::has('name')) { $name = Input::get('name'); $nameStr = '*' . $name . '*'; $images->search($nameStr); } $total = $images->count(); $images = $images->take($take)->skip($skip)->orderBy('id', 'desc')->get(); $arrReturn = []; $arrReturn['total_page'] = ceil($total / $take); $arrReturn['page'] = $pageNum; if (!$images->isEmpty()) { foreach ($images as $image) { if ($image->ratio > 1) { $width = 150; $height = $width / $image->ratio; } else { $height = 150; $width = $height * $image->ratio; } $arrReturn['data'][] = ['id' => $image->id, 'name' => $image->name, 'short_name' => $image->short_name, 'path' => URL . '/pic/thumb/' . $image->short_name . '-' . $image->id . '.jpg', 'width' => $width, 'height' => $height, 'ratio' => $image->ratio]; } } return $arrReturn; }
public function getSimilarImage($arr_image_id = array(), $viewAll = false, $skip = 0, $takes = 7) { $similar_images = array(); $total_image = 0; if (count($arr_image_id)) { $arr_keyword = array(); $keywords = VIImage::select(DB::raw(" GROUP_CONCAT(`keywords` SEPARATOR ',') as 'keyword' "))->whereIn('id', $arr_image_id)->get()->toArray(); $keywords = explode(',', $keywords[0]['keyword']); foreach ($keywords as $key => $keyword) { if (!isset($arr_keyword[$keyword])) { $arr_keyword[$keyword] = 1; } else { $arr_keyword[$keyword] += 1; } } // pr($keywords); // pr(DB::getQueryLog());die; shuffle($arr_keyword); arsort($arr_keyword); $arr_keyword = array_keys($arr_keyword); $take = count($arr_keyword) < 5 ? count($arr_keyword) - 1 : 5; $query = VIImage::select('name', 'short_name', 'images.id')->withType('main'); for ($i = 0; $i < $take; $i++) { $query->orWhereRaw("MATCH(images.name,images.description,images.keywords) AGAINST('" . $arr_keyword[$i] . "' IN BOOLEAN MODE)"); } $query->whereNotIn('images.id', $arr_image_id); $query->groupBy('images.id'); $total_image = $query->get()->count(); $similar_images = $query->skip($skip)->take($takes)->get()->toArray(); } $arrSimilarImages = array(); foreach ($similar_images as $value) { $arrSimilarImages[$i]['image_id'] = $value['id']; $arrSimilarImages[$i]['name'] = $value['name']; $arrSimilarImages[$i]['short_name'] = $value['short_name']; $arrSimilarImages[$i]['width'] = $value['width']; $arrSimilarImages[$i]['height'] = $value['height']; //$arrSimilarImages[$i]['path'] = $value['path']; $arrSimilarImages[$i]['path'] = '/pic/small-thumb/' . $value['short_name'] . '-' . $value['id'] . '.jpg'; $i++; } if (Request::ajax()) { $html = View::make('frontend.images.similar-images')->with(['arrSimilarImages' => $arrSimilarImages, 'id_image' => isset($arr_image_id[0]) ? $arr_image_id[0] : 0])->render(); $arrReturn = ['status' => 'ok', 'message' => '', 'html' => $html]; $response = Response::json($arrReturn); $response->header('Content-Type', 'application/json'); return $response; } if (!$viewAll) { return View::make('frontend.images.similar-images')->with(['arrSimilarImages' => $arrSimilarImages, 'id_image' => isset($arr_image_id[0]) ? $arr_image_id[0] : 0])->render(); } return ['arrSimilarImages' => $arrSimilarImages, 'total_image' => $total_image]; }
public function searchImage() { $keyword = Input::has('keyword') ? Input::get('keyword') : ''; //for recently searched images $keyword_searched = $keyword; $short_name = Input::has('short_name') ? Input::get('short_name') : ''; $sort_method = Input::has('sort_method') ? Input::get('sort_method') : 'new'; $sort_style = Input::has('sort_style') ? Input::get('sort_style') : 'mosaic'; if (trim($keyword) != '') { $keyword = '*' . trim($keyword) . '*'; } $page = Input::has('page') ? Input::get('page') : 1; $take = Input::has('take') ? Input::get('take') : 30; $type = Input::has('type') ? intval(Input::get('type')) : 0; $orientation = Input::has('orientation') ? Input::get('orientation') : 'any'; $skip = ($page - 1) * $take; $category = Input::has('category') ? intval(Input::get('category')) : 0; $search_type = Input::has('search_type') ? Input::get('search_type') : 'search'; $exclude_keyword = Input::has('exclude_keyword') ? '*' . Input::get('exclude_keyword') . '*' : ''; $exclude_people = Input::has('exclude_people'); $include_people = Input::has('include_people'); $gender = Input::has('gender') ? Input::get('gender') : 'any'; $age = Input::has('age') ? Input::get('age') : 'any'; $ethnicity = Input::has('ethnicity') ? Input::get('ethnicity') : 'any'; $number_people = Input::has('number_people') ? Input::get('number_people') : 'any'; $color = Input::has('color') ? Input::get('color') : ''; $images = VIImage::select('images.short_name', 'images.id', 'images.name', 'images.main_color', DB::raw('count(lightbox_images.id) as count_favorite'))->leftJoin('lightbox_images', 'images.id', '=', 'lightbox_images.image_id')->groupBy('images.id')->with('downloads'); switch ($sort_method) { case 'new': $images = $images->with('statistic')->orderBy('images.id', 'desc')->withType('main')->withOrientation($orientation); break; case 'relevant': $images = $images->with('statistic')->orderBy('images.id', 'desc')->withType('main')->withOrientation($orientation); break; case 'popular': $images = $images->join('statistic_image', 'statistic_image.image_id', '=', 'images.id')->with('statistic')->orderBy('view', 'desc')->orderBy('download', 'desc')->withType('main')->withOrientation($orientation); break; case 'undiscovered': $images = $images->join('statistic_image', 'statistic_image.image_id', '=', 'images.id')->with('statistic')->orderBy('view', 'asc')->orderBy('download', 'asc')->withType('main')->withOrientation($orientation); break; default: $images = $images->with('statistic')->orderBy('images.id', 'desc')->withType('main')->withOrientation($orientation); break; } if ($search_type == 'search' && $keyword != '') { $images = $images->search($keyword); } if ($exclude_keyword != '') { $images = $images->notSearchKeyWords($exclude_keyword); } if ($exclude_people) { $images = $images->where('number_people', '=', 0); } if ($include_people) { if ($gender != 'any') { $images = $images->where('gender', '=', $gender); } if ($age != 'any') { $age = explode('-', $age); $from = intval($age[0]); $to = intval($age[1]); $images = $images->where('age_from', '<=', $to)->where('age_to', '>=', $from); } if ($ethnicity != 'any') { $images = $images->where('ethnicity', '=', $ethnicity); } if ($number_people != 'any') { if ($number_people < 4) { $images = $images->where('number_people', '=', $number_people); } else { $images = $images->where('number_people', '>=', $number_people); } } } if (!(Input::has('editorial') && Input::has('non_editorial'))) { if (Input::has('editorial')) { $images = $images->where('editorial', '=', 1); } if (Input::has('non_editorial')) { $images = $images->where('editorial', '=', 0); } } if ($type != 0) { $images = $images->where('type_id', '=', $type); } if ($category != 0) { $images = $images->join('images_categories', 'images_categories.image_id', '=', 'images.id')->where('images_categories.category_id', '=', $category); } $total_image = $images->count(); $images = $images->get()->toArray(); $images = $this->searchColorFromArray($color, $images); $total_image = count($images); $images = array_slice($images, $skip, $take); //pr(DB::getQueryLog());die; $total_page = ceil($total_image / $take); //for recently searched images if ((trim($keyword_searched) != '' || $short_name != '') && count($images) > 0) { if ($keyword_searched == '') { $keyword_searched = str_replace('-', ' ', $short_name); } if (Auth::user()->check()) { BackgroundProcess::actionSearch(['type' => 'recently-search', 'keyword' => $keyword_searched, 'image_id' => $images[0]['id'], 'user_id' => Auth::user()->get()->id, 'query' => Request::server('REQUEST_URI')]); } BackgroundProcess::actionSearch(['type' => 'popular-search', 'keyword' => $keyword_searched, 'image_id' => $images[0]['id'], 'query' => Request::server('REQUEST_URI')]); } $lightboxes = array(); if (Auth::user()->check()) { $lightboxes = Lightbox::where('user_id', '=', Auth::user()->get()->id)->get()->toArray(); foreach ($lightboxes as $key => $lightbox) { $lightboxes[$key]['total'] = LightboxImages::where('lightbox_id', '=', $lightbox['id'])->count(); } } $image_action_title = 'Like this item'; if (Auth::user()->check()) { $image_action_title = 'Save to lightbox'; } $arr_sort_method = array('new' => 'New', 'popular' => 'Popular', 'relevant' => 'Relevant', 'undiscovered' => 'Undiscovered'); $arrReturn = array('images' => $images, 'total_page' => $total_page, "total_image" => $total_image, "sort_style" => $sort_style, "search_type" => $search_type, "categories" => $this->layout->categories, "lightboxes" => $lightboxes, "image_action_title" => $image_action_title, "arr_sort_method" => $arr_sort_method, "sort_method" => $sort_method, 'mod_download' => Configure::GetValueConfigByKey('mod_download'), 'mod_order' => Configure::GetValueConfigByKey('mod_download')); if (Request::ajax()) { return $arrReturn; } $this->layout->in_search = 1; $this->layout->content = View::make('frontend.search')->with($arrReturn); }