PHP Image::where方法代码示例

 /**
  * Display the instructor profile.
  *
  * @return Response
  */
 public function getProfile($id = Null)
 {
     if (isset($id)) {
         //The instructor with the given user_id
         $instructor = User::with('instructor')->has('instructor')->where('active', 1)->find($id);
         if (count($instructor) == 1) {
             //Instructor_id of the instructor
             $instructor_id = $instructor->instructor->instructor_id;
             //All reviews of the instructor
             $reviews = Instructor::find($instructor_id)->reviews()->orderBy('created_at', 'desc')->paginate(2);
             $reviews->setPath('/drive/instructor/profile/83/url');
             //Counting the number of reviews wrote by the current learner for the instructor
             // $no_of_review = Review::where('learner_id', Auth::user()->learner->learner_id)->where('Instructor_id', $instructor_id)->count();
             //Counting total number of reviews of the instructor
             $total_reviews = Instructor::find($instructor_id)->reviews()->count();
             //Calculating the average rating
             $avg_rating = Instructor::find($instructor_id)->reviews()->avg('rating');
             //
             $images = Image::where('instructor_id', $instructor_id)->get();
             //Returning the view with $instructors
             return view('instructor_profile', ['instructor' => $instructor, 'reviews' => $reviews, 'total_reviews' => $total_reviews, 'avg_rating' => $avg_rating, 'images' => $images]);
         } else {
             //If no result, redirect the user to the instructor_list
             //Flashed data contains message and alert-danger class
             return redirect()->action('InstructorController@getIndex')->with('message', 'No instructor profile found!')->with('alert-class', 'alert-danger');
         }
         //End of if statement
     } else {
         //If no id provided, redirect the user to the instructor_list
         return redirect()->action('InstructorController@getIndex');
     }
     //End of if statement
 }

 /**
  * Save product to database
  */
 public function save()
 {
     $data = ['item_id' => $this->item_id, 'shop_id' => $this->shop_id] + $this->data;
     if (!App\Product::where('shop_id', $this->shop_id)->where('item_id', $this->item_id)->update($this->data) && !App\Product::insert($data)) {
         return false;
     }
     $this->id = App\Product::where('shop_id', $this->shop_id)->where('item_id', $this->item_id)->first()->id;
     if (!$this->id) {
         return false;
     }
     foreach ($this->images as $image) {
         if (!App\Image::where('url', $image['url'])->update($image) && !App\Image::insert($image + ['product_id' => $this->id])) {
             return false;
         }
     }
     /*if( isset( $this->params ) )
     		{
     			foreach( $this->params as $param )
     			{
     				if( !App\Param::where( 'param', $param['param'] )->update( $param ) && 
     					!App\Param::insert( $param + [ 'product_id' => $this->id ] ) )
     					return false;
     			}
     		}*/
     return true;
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     //
     $images = Image::where('page_id', '=', $_GET)->get();
     $possible_photos = PossiblePhoto::orderBy('created_at', 'ASC')->get();
     return view('images.index', compact('images', 'possible_photos'));
 }

 public function getImages()
 {
     $user = Auth::User();
     $userID = $user->id;
     $getImages = Image::where('userID', $userID)->get();
     return $getImages;
 }

 protected function makeImage($file, $height, $width, $randomFilename, $thumbnail = null)
 {
     $md5 = md5_file($file->getRealPath());
     $img = Image::make($file)->fit($height, $width);
     $path = 'images/';
     if ($thumbnail != null) {
         $path = 'images/thumb/';
     }
     $image = Images::where('md5_hash', $md5)->first();
     if ($image === null or $image->thumbnail_file == null) {
         Clockwork::info('Storing on Filesystem');
         $img->save(storage_path() . '/app/' . $path . $randomFilename . '.png', 90);
     }
     if ($image === null and $thumbnail === null) {
         Clockwork::info('New Image');
         $image = new Images();
         $image->user_id = Auth::user()->id;
         $image->filename = $file->getClientOriginalName();
         $image->file = $randomFilename . '.png';
         $image->height = $height;
         $image->width = $width;
         $image->md5_hash = $md5;
     } elseif ($thumbnail != null and $image->thumbnail_file == null) {
         Clockwork::info('Thumbnail Updated');
         $image->thumbnail_file = $randomFilename . '.png';
     }
     $image->save();
     return $image;
 }

 function getExample3()
 {
     $images = \App\Image::where('date_taken', '<', '2000-00-00')->get();
     foreach ($images as $image) {
         echo $image->narrative . '<br>';
     }
     dump($images);
 }

 /**
  * Show a image based on on the filename
  * @param $filename
  * @return mixed
  */
 public function show($filename)
 {
     $file = Image::where('filename', $filename)->firstOrFail();
     if (!$file) {
         return $this->respondWithError();
     }
     return Fractal::item($file, new \App\Transformers\ImageTransformer())->responseJson(200);
 }

 /**
  * @return $this
  */
 public function meta()
 {
     $img_url = 'http://d14d0ey1pb5ifb.cloudfront.net/';
     $property = \App\Property::where(['meta_set' => 0, 'status' => '1'])->orderBy('package', 'DESC')->first();
     $address = \App\Address::where(['property_id' => $property->property_id])->first();
     $images = \App\Image::where(['property_id' => $property->property_id])->orderBy('pos', 'ASC')->get();
     return view('dashboard.meta')->with(compact(['property', 'address', 'images', 'img_url']));
 }

 public function kill()
 {
     $image = Image::where('model_name', '=', 'Article')->where('foreign_id', '=', $this->id)->first();
     if (!empty($image)) {
         $image->kill();
     }
     $this->delete();
 }

 public function afficher($id_image)
 {
     if (Image::find($id_image)) {
         return View::make('image', ['image' => Image::find($id_image), 'precedente' => Image::where('id_image', '<', Image::find($id_image)->id_image)->where('id_campagne', '=', Image::find($id_image)->id_campagne)->max('id_image'), 'suivante' => Image::where('id_image', '>', Image::find($id_image)->id_image)->where('id_campagne', '=', Image::find($id_image)->id_campagne)->min('id_image')]);
     } else {
         return Response('Image non trouvée');
     }
 }

 public function roomHistory($room_id)
 {
     $room_contracts = Contract::withTrashed()->where('room_id', $room_id)->select('id', 'contractor_name', 'phone', 'end_water_degree', 'end_electric_degree', 'start_time', 'end_time', 'real_end_time')->get();
     foreach ($room_contracts as &$contract) {
         $images = Image::where('r_id', $contract['id'])->select('path as img', 'imageable_id', 'r_id')->get();
         $contract['images'] = $images;
     }
     return $room_contracts;
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show(Family $family)
 {
     $id = $family->id;
     $mother = Person::latest('created_at')->where('id', '=', $family->mother_id)->first();
     $father = Person::latest('created_at')->where('id', '=', $family->father_id)->first();
     $kids = FamilyController::get_kids_of_family($family);
     $images = Image::where('family', $id)->orderBy('year', 'asc')->get();
     $featured_image = Image::latest('created_at')->orderBy('year', 'asc')->Where('family', $id)->Where('featured', 1)->get();
     return view('family.show', compact('family', 'kids', 'images', 'mother', 'father', 'featured_image'));
 }

 public function show(Person $person)
 {
     $logged_in_user = \Auth::user();
     $id = $person->id;
     $solo_images = Image::where('subject', $id)->orderBy('year', 'asc')->get();
     $featured_image = Image::where('subject', $id)->orderBy('year', 'asc')->Where('featured', 1)->get();
     $made_family = PeopleController::get_made_family($person);
     $notes = PeopleController::get_notes_about_person($person);
     $origin_family = Family::where('id', $person->family_of_origin)->first();
     return view('person.show', compact('person', 'solo_images', 'made_family', 'featured_image', 'origin_family', 'notes', 'logged_in_user'));
 }

 /**
  * Get image from storage
  * 
  * @param Request $request
  * @return file
  */
 public function getImage(Request $request)
 {
     /**
      * Check the cache
      */
     $cacheKey = 'image:' . $request->imageName . ':' . $request->imageExtension;
     /**
      * File cached
      */
     if (Cache::has($cacheKey)) {
         $imageMeta = Cache::get($cacheKey);
     } else {
         /**
          * Get META information
          */
         $imageMeta = Image::where(['url' => $request->imageName, 'image_extension' => $request->imageExtension])->first(['image_mime_type', 'image_size', 'id', 'updated_at', 'image_etag']);
         /**
          * File does not exist
          */
         if (empty($imageMeta) == TRUE) {
             App::abort(404);
         }
         /**
          * Save meta information to cache
          */
         Cache::forever($cacheKey, $imageMeta);
     }
     /**
      * Get filename
      */
     $filename = Helpers::getStorageFilename(env('APP_IMAGE_STORAGE_DIRECTORY', 'images'), $imageMeta->id);
     /**
      * Prepare stream
      */
     $stream = Storage::readStream($filename);
     /**
      * File headers
      */
     $headers = array('Content-Description' => 'File Transfer', 'Content-Type' => $imageMeta->image_mime_type, 'Content-Transfer-Encoding' => 'binary', 'Pragma' => 'public', 'Expires' => Carbon::createFromTimestamp(time() + 3600)->toRfc2822String(), 'Last-Modified' => $imageMeta->updated_at->toRfc2822String(), 'Etag' => $imageMeta->image_etag);
     /**
      * Response code cached
      */
     if (isset($_SERVER['HTTP_IF_NONE_MATCH']) && $_SERVER['HTTP_IF_NONE_MATCH'] == $imageMeta->image_etag || isset($_SERVER['HTTP_IF_MODIFIED_SINCE']) && $_SERVER['HTTP_IF_MODIFIED_SINCE'] == $imageMeta->updated_at->toRfc2822String()) {
         $responseCode = 304;
     } else {
         $responseCode = 200;
     }
     /**
      * Stream to browser
      */
     return Response::stream(function () use($stream) {
         fpassthru($stream);
     }, $responseCode, $headers);
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     // return the rental and urls for the images
     $rental = \App\Rental::find($id);
     $images = \App\Image::where('project_id', '=', $id)->get();
     $image_response = [];
     foreach ($images as $image) {
         array_push($image_response, ['url' => config('app.url') . "/images/" . $image->id]);
     }
     $rental['images'] = $image_response;
     return response()->json(['rental' => $rental]);
 }