PHP Project::where方法代码示例

 public function showDashboard()
 {
     $projects = new Project();
     $projectCount = $projects->count();
     $published = $projects->where('published', 1)->count();
     $unpublished = $projects->where('published', 0)->count();
     $illustrations = Illustration::count();
     $logos = Logo::count();
     return view('dashboard/dashboard', compact('projectCount', 'published', 'unpublished', 'illustrations', 'logos'));
 }

 public function show()
 {
     $title = Input::get('title');
     $projects = Project::where('title', 'LIKE', '%' . $title . '%')->get();
     $data = array('projects' => $projects, 'users' => User::all());
     return view('projectresult', $data);
 }

 /**
  * Store a newly created resource in storage.
  *
  * @return Response
  */
 public function store(Requests\BeneficiatyCreateRequest $request)
 {
     $proyecto = Project::find($request->get('project_id'));
     if ($proyecto == null) {
         return redirect()->back()->with('errors', 'El proyecto no existe');
     }
     $homes = Beneficiary::where('project_id', '=', $proyecto->id)->get();
     if (count($homes) >= $proyecto->quantity) {
         Session::flash('message', 'Este proyecto tiene el maximo numero de beneficiarios');
         return redirect()->to('admin/proyectos');
     } else {
         $beneficiario = Beneficiary::create($request->all());
         $beneficiario->birthdate = Carbon::parse($request->get('birthdate'));
         $beneficiario->save();
         $etapas_project = Project::where('projects.id', '=', $proyecto->id)->join('designs', 'designs.id', '=', 'projects.desing_id')->join('desing_stage', 'desing_stage.desing_id', '=', 'designs.id')->join('stages', 'stages.id', '=', 'desing_stage.stage_id')->join('activity_stage', 'activity_stage.stage_id', '=', 'stages.id')->join('activities', 'activities.id', '=', 'activity_stage.activity_id')->groupBy('activities.id')->get(['activities.id as id']);
         foreach ($etapas_project as $e) {
             $avance = new Advanced();
             $avance->porcent = 0.0;
             $avance->state = 4;
             $avance->beneficiary_id = $beneficiario->id;
             $avance->save();
             $avance->actividades()->attach($e->id);
         }
         Session::flash('message', 'Beneficiario creado de forma correcta');
         return redirect()->to('admin/beneficiarios');
     }
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     //
     $tags = Tag::where('user_id', Auth::user()->id)->orderBy('created_at', 'asc')->get();
     $projects = Project::where('user_id', Auth::user()->id)->orderBy('created_at', 'asc')->get();
     return view('portfolioAdmin', ['tags' => $tags, 'projects' => $projects]);
 }

 /**
  * Define your route model bindings, pattern filters, etc.
  *
  * @param  \Illuminate\Routing\Router  $router
  * @return void
  */
 public function boot(Router $router)
 {
     Route::bind('slug', function ($value) {
         return Project::where('slug', '=', $value)->firstOrFail();
     });
     parent::boot($router);
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(ProjectUpdateRequest $request, $id)
 {
     $project = new Project($request->all());
     Project::where('id', $id)->update($project->getAttributes());
     flash()->success(trans('project.label.name'), trans('project.message_alert.update_success'));
     return redirect('/projects');
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  * Request $request, $id
  */
 public function update()
 {
     $id = Request::get('pid');
     $inp = Request::get('project');
     Project::where('id', $id)->update(['project' => $inp]);
     return redirect('project');
 }

 public function show($name)
 {
     if (\Auth::check() && \Auth::user()->permission->name == 'admin') {
         if (is_numeric($name)) {
             $p = Project::where('id', '=', $name)->where('trash', '=', '0')->first();
             if (is_null($p)) {
                 return \Redirect::to('404');
             }
             return \View::make('projects.show')->with('entry', $p);
         } else {
             $p = Project::where('name', '=', $name)->where('trash', '=', '0')->first();
             if (is_null($p)) {
                 return \Redirect::to('404');
             }
             return \View::make('projects.show')->with('entry', $p);
         }
     } else {
         if (is_numeric($name)) {
             $p = Project::where('id', '=', $name)->where('trash', '=', '0')->where('state', '=', '1')->first();
             if (is_null($p)) {
                 return \Redirect::to('404');
             }
             return \View::make('projects.show')->with('entry', $p);
         } else {
             $p = Project::where('name', '=', $name)->where('trash', '=', '0')->where('state', '=', '1')->first();
             if (is_null($p)) {
                 return \Redirect::to('404');
             }
             return \View::make('projects.show')->with('entry', $p);
         }
     }
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     $project = Project::where('id', $id)->get()->first();
     if (!$project) {
         return Response::json(['message' => 'Project not found'], 404);
     }
     return Response::json($project);
 }

 /**
  * reads Project table by unique index
  *  - if not found, emit a not found message.
  *  - if found return the $project record to the caller.
  *
  * @param [in] $text
  * @return a record.
  */
 public static function checkIfExists($text)
 {
     $project = Project::where('name', '=', $text)->first();
     if (!is_null($project)) {
         appGlobals::existsMessage(appGlobals::getProjectTableName(), $project->name, $project->id);
     }
     return $project;
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     //
     $modules = Module::where('project_id', '=', $_GET)->get();
     $existing_modules_count = Module::where('project_id', '=', $_GET)->count();
     $projected_modules = Project::where('id', '=', $_GET)->pluck('projected_total_modules');
     $modules_count = $projected_modules - $existing_modules_count;
     return view('modules.index', compact('modules', 'modules_count'));
 }

 public function projectList()
 {
     $projects_member_id = Member::where("Developer_id", auth()->User()->id)->get()->pluck("project_id");
     $project_owner_id = Project::where("developer_id", auth()->User()->id)->get()->pluck("id");
     $projects_id = array_merge($projects_member_id->toArray(), $project_owner_id->toArray());
     $project = Project::whereIn("id", $projects_id)->get();
     $developer = DB::table('Developer')->get();
     return view("project.list")->with('project', $project)->with('developer', $developer);
 }

 /**
  * 取得給定使用者name的所有project include tags。
  *
  * @param  String $name
  * @return Collection
  */
 public function getProjectsByName($name)
 {
     $user = User::where('name', $name)->first();
     if ($user == null) {
         return null;
     }
     $projects = Project::where('user_id', $user->id)->get();
     return $projects;
 }

 /**
  * Bootstrap any application services.
  *
  * @return void
  */
 public function boot()
 {
     view()->composer('layouts.app', function ($view) {
         $production = \App\Project::where('status_id', 1)->get();
         $design = \App\Project::where('status_id', 2)->get();
         $prospect = \App\Project::where('status_id', 3)->get();
         $view->with(compact('production', 'design', 'prospect'));
     });
 }

 public function renderHome()
 {
     $first_featured = Project::where('featured_pos', 1)->first();
     $second_featured = Project::where('featured_pos', 2)->first();
     $third_featured = Project::where('featured_pos', 3)->first();
     $fourth_featured = Project::where('featured_pos', 4)->first();
     $fifth_featured = Project::where('featured_pos', 5)->first();
     return view('home', ['first_featured' => $first_featured, 'second_featured' => $second_featured, 'third_featured' => $third_featured, 'fourth_featured' => $fourth_featured, 'fifth_featured' => $fifth_featured]);
 }