时间戳

首页 > 解决方案 > Laravel - 表单选择日期 - 只允许用户在从数据库发送的两个日期之间进行选择

php - Laravel - 表单选择日期 - 只允许用户在从数据库发送的两个日期之间进行选择

问题描述

我有两张桌子——“旅行”和“活动”。一次旅行可以有很多事件。我有一个表单，允许用户将事件添加到他们的旅行中。在选择事件的开始日期和结束日期时，我只想允许用户选择一个日期，即行程开始日期和行程结束日期。

例如，如果从 3 月 1 日到 3 月 14 日创建了前往纽约的旅行，则用户应该只能在这些日期之间添加事件。有没有好的方法来做到这一点？

行程表 事件表

addEvent.blade.php `

<div class="form-group">
    <div class="form-group">
        {!! Form::label('trip_id', 'Your Destinations:') !!}
        <select class="form-control" name="trip_id">
          @foreach($trips as $trip)
            <option value='{{ $trip->id}}'>{{$trip->destination}}</option>
          @endforeach
        </select>
      </div>
    </div>

<div class="form-group">
  <div class="form-group">
    {!! Form::label('event_name', 'Add Event:') !!}
    <div class="">
      {!! Form::text('event_name', null, ['class' => 'form-control']) !!}
      {!! $errors->first('event_name', '<p class="alert alert-danger">:message</p>') !!}
    </div>
  </div>
</div>

<div class="form-group">
  <div class="form-group">
    {!! Form::label('start_date', 'Start Date:') !!}
    <div class="">
      {!! Form::date('start_date', \Carbon\Carbon::now(), ['class' => 'form-control']) !!}
      {!! $errors->first('start_date', '<p class="alert alert-danger">:message</p>') !!}
    </div>
  </div>
</div>


<div class="form-group">
  <div class="form-group">
    {!! Form::label('end_date', 'End Date:') !!}
    <div class="">
      {!! Form::date('end_date', null, ['class' => 'form-control']) !!}
      {!! $errors->first('end_date', '<p class="alert alert-danger">:message</p>') !!}
    </div>
  </div>
</div>

<div class="form-group" &nbsp;<br/>
{!! Form::submit('Add Event', ['class' => 'btn btn-primary']) !!}

`

事件控制器

public function addEvent(Request $request)
{
  $validator = Validator::make($request->all(),[
    'event_name' => 'required',
    'start_date' => 'required',
    'end_date' => 'required',
    'trip_id'=> 'required',
  ]);

  if($validator->fails()) {
    \Session::flash('warning', 'Please enter the valid details');
    return redirect('/events')->with('input', Input::all());
  }

  $events = new Events;
  $trips = Trip::all();
  $events->event_name = $request['event_name'];
  $events->start_date = $request['start_date'];
  $events->end_date = $request['end_date'];
  $events->trip_id = $request['trip_id'];
  $events->save();

return redirect('trips')->with('success', 'The new event has been added to your trip')->with('trips', $trips);
}

trip.blade.php

<div class="form-group">
      <input type="text" name="destination" class="form-control" value="{{$trip->destination}}" placeholder="Destination" />
    </div>
    <h7>Trip Start Date: </h7>
    <div class="form-group">
      <input type="date" name="startdate" class="form-control" value="{{$trip->startdate}}" placeholder="Start Date" />
    </div>
    <h7>Trip End Date: </h7>
    <div class="form-group">
      <input type="date" name="enddate" class="form-control" value="{{$trip->enddate}}" placeholder="End Date" />
    </div>
    <div>

行程控制器

public function submit(Request $request){
  $this->validate($request, [
    'name'          => 'required',
    'email'         => 'required',
    'destination'   => 'required',
    'startdate'     => 'required',
    'enddate'       => 'required'
  ]);

  //Create new trips
  $trip = new Trip;
  $trip->name = $request->input('name');
  $trip->email = $request->input('email');
  $trip->destination = $request->input('destination');
  $trip->startdate = $request->input('startdate');
  $trip->enddate = $request->input('enddate');
  $trip->user_id = auth()->user()->id;

  //save trips
  $trip->save();

  //Rredirect
  return redirect('/home')->with('status', 'Trip Created Sucessfully');

}

标签： phplaraveldatetime

解决方案

在 addEvent.blade.php 文件中，您可以根据现有行程日期将“min”和“max”属性添加到 start_date 和 end_date

{!! Form::date('start_date', \Carbon\Carbon::now(), ['class' => 'form-control', 'min' => $trip->startdate, 'max' => $trip->enddate]) !!}


{!! Form::date('end_date', null, ['class' => 'form-control', 'min' => $trip->startdate, 'max' => $trip->enddate]) !!}

并且在 addEvent 函数中，您必须为 start_date 和 end_date 添加验证，以便它们不超过行程表的日期

public function addEvent(Request $request)
{

  // first take data from the trip table
  $trip = Trip::find($request->trip_id);

  // if trip not found then error
  if( !$trip ){
    return redirect('trips')->with('fail', 'Trip not found');
  }

  // add validations for start_date and end_date so that they do not exceed the dates of the trip table
  // gte is for grather than equal
  // lte is  for less than equal
  // or you can use min max

  $validator = Validator::make($request->all(),[
    'event_name' => 'required',
    'start_date' => 'required|date|min:'.$trip->startdate.'|max:'.$trip->enddate, //
    'end_date' => 'required|date|gte:start_date|max:'.$trip->enddate,
    'trip_id'=> 'required',
  ]);

  if($validator->fails()) {
    \Session::flash('warning', 'Please enter the valid details');
    return redirect('/events')->with('input', Input::all());
  }

  $events = new Events;
  $trips = Trip::all();
  $events->event_name = $request['event_name'];
  $events->start_date = $request['start_date'];
  $events->end_date = $request['end_date'];
  $events->trip_id = $request['trip_id'];
  $events->save();

return redirect('trips')->with('success', 'The new event has been added to your trip')->with('trips', $trips);
}

推荐阅读