PHP File::where方法代码示例

 public function listFiles($target, $target_action, $target_id)
 {
     $resource_type = 'App\\Models\\' . ucfirst(str_singular($target));
     $uploader_id = Auth::user()->active_contact->id;
     if ($target == "posts") {
         if ($target_action == "create") {
             $post = Post::where('author_id', $uploader_id)->where("status_id", "=", POST_DRAFT_STATUS_ID)->where("ticket_id", $target_id)->first();
         } elseif ($target_action == "edit") {
             $post = Post::where("id", $target_id)->first();
         }
         $id = isset($post->id) ? $post->id : null;
     } elseif ($target == "tickets") {
         if ($target_action == "create") {
             $ticket = Ticket::where('status_id', TICKET_DRAFT_STATUS_ID)->where('creator_id', $uploader_id)->first();
         } else {
             $ticket = Ticket::where("id", $target_id)->first();
         }
         $id = isset($ticket->id) ? $ticket->id : null;
     } elseif ($target == "people") {
         $target_id = is_null($target_id) ? Auth::user()->owner->id : $target_id;
         $person = Person::find($target_id);
         $id = $person->id;
     }
     $files = is_null($id) ? [] : File::where('resource_type', $resource_type)->where("resource_id", $id)->get();
     foreach ($files as $file) {
         $file->size = filesize(RESOURCES . DS . $file->file_path . DS . $file->file_name);
     }
     return $files;
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     $filecount = \App\Models\File::where('file_type_id', $id)->count();
     if ($filecount > 0) {
         return back()->withMsg('There are files in the category');
     }
     FileType::findOrFail($id)->delete();
     return back();
 }

 public function delete(Request $request, $banqueId, $fileId)
 {
     // verify request inputs
     if (is_null($fileId)) {
         return response()->json(['error' => 'Bad request'], HttpResponse::HTTP_BAD_REQUEST);
     } else {
         $item = File::where('id_File', '=', $fileId)->delete();
         return is_null($item) ? response()->json(['error' => 'Bad request'], HttpResponse::HTTP_BAD_REQUEST) : $item;
     }
 }

 public function index()
 {
     $fields = Field::all();
     $fileTitles = File::distinct()->groupBy('parsed_title')->select('parsed_title')->get();
     $fileArray = [];
     foreach ($fileTitles as $title) {
         $file = File::where('parsed_title', '=', $title->parsed_title)->select('parsed_date', 'full_title')->orderBy('parsed_date', 'desc');
         $fileData = $file->get();
         foreach ($file->get() as $multiFile) {
             $fileArray[$title->parsed_title][] = $multiFile;
         }
     }
     return view("home.index")->with('fileArray', $fileArray);
 }

 /**
  * API - get list of files, optionally filtered by category
  */
 public function APIindex($category = null)
 {
     // get all files of this category
     if ($category) {
         if ($category == 'newest') {
             // Recently added files
             $files = File::orderBy('id', 'desc')->paginate(18);
         } else {
             $files = File::where('file_category_id', $category)->paginate(18);
         }
     } else {
         $files = File::paginate(18);
     }
     return response()->json($files);
 }

 public function addComments(Request $request)
 {
     $name = $request->name;
     $end = isset($request->end) ? strtotime($request->end) : time();
     $start = isset($request->start) ? strtotime($request->start) : $end - 86400 * 180;
     $site = isset($request->site) ? $request->site : '';
     $mode = isset($request->mode) ? $request->mode : '';
     $f = $s = 0;
     if (empty($name) || empty($site) || empty($mode)) {
         return AJAX::argumentError();
     }
     $file = File::where(array('name' => $name))->first();
     if (empty($file) || empty($file->path)) {
         return AJAX::notExist();
     }
     $list = $this->getFileContents($file->path);
     switch ($mode) {
         case 'insertComments':
             $result = $this->checkCommentsFile($list, 4);
             break;
         case 'insertCommentsWithTid':
             $result = $this->checkCommentsFile($list, 5);
             break;
         default:
             $result['code'] = 500;
             $result['data'] = 'arguments error';
             break;
     }
     if ($result['code'] != 200) {
         return AJAX::badData(array('message' => $result['message']));
     }
     $commentModule = new CommentModule($site);
     foreach ($list as $line) {
         $comment_time = $this->getCommentRandTime($start, $end);
         $res = $commentModule->addCommentByLine($line, $comment_time, $mode);
         if ($res['code'] != 200) {
             Log::error($site . ':' . $name . $res['message']);
             $f++;
             continue;
         }
         $s++;
     }
     return AJAX::success(array('success' => $s, 'fail' => $f));
 }

 public function detail($banqueId = null)
 {
     if (is_null($banqueId)) {
         // display the hole banque
         return view('banque', ['banqueItems' => Banque::all(), 'contexteItems' => Contexte::all(), 'critereItems' => Critere::all(), 'domaineItems' => Domaine::all(), 'systemeItems' => Systeme::all(), 'competenceItems' => Competence::all(), 'enseignantList' => Enseignant::all()]);
     } else {
         // display specific banque
         $banque = $this->gestSession->getBanque($banqueId);
         $items = Item::join('TitreGItem', 'TitreGItem.id_TitreGItem', '=', 'Item.id_TitreGItem')->where('Item.id_Banque', '=', $banqueId)->join('Competence', 'Item.id_Competence', '=', 'Competence.id_Competence')->get();
         $auteurs = Banque_Enseignant::where('id_Banque', '=', $banqueId)->get();
         $files = File::where('id_Banque', '=', $banqueId)->get();
         return view("banqueDetail")->with("banque", $banque)->with("items", $items)->with("files", $files)->with("auteurs", $auteurs);
     }
 }

 public function getFilesByTypeId($id)
 {
     $file = File::where('file_type_id', $id)->get();
     return response()->json($file);
 }

 public function files($user)
 {
     $files = File::where("folder_id", $this->id)->where("created_by", $user->id)->orderBy("name")->get();
     return $files;
 }

 /**
  * Function Remove
  * Process Delete the Brand Data
  *
  * @return \Illuminate\Http\JsonResponse
  */
 public function onDelete()
 {
     $id = Input::get('id');
     $Model = \App\Models\File::select(['id', 'name'])->where('id', $id)->first();
     $path = base_path() . '/public/uploads/';
     if ($Model) {
         File::delete($path . $Model->name);
         \App\Models\File::where('id', $id)->delete();
         \App\Models\FileUser::where('file_id', $id)->delete();
         $param['message'] = Lang::get('message.has deleted');
         $param['error'] = false;
     } else {
         $param['message'] = Lang::get('message.has error');
         $param['error'] = true;
     }
     return json_encode($param);
 }