Validate if input date is before the date stored in db

I want to check if an Event Registration is still available at the selected input date.

I store the expiration_date in the column date_end, table events.

In my EventSignupRequest I tried this, but it won't validate any date now.

'date' => 'required|date|after:yesterday|before_or_equal:events,date_end',
// returns
The date must be a date before or equal to events.

I found a workaround and added a separate manual validation before I store the data, but I would like to have all the code in EventSignupRequest.

Thank you!

Aforeg

7 years ago

Best Answer

Level 1

You could use withValidator in your Request.

public function withValidator($validator) {
    $validator->after(function ($validator) {
        $event == Event::find($this->input('event_id'))->first();
        if($event->date_end < $this->input('registration_date')) {
            $validator->errors()->add('event_id', 'Sorry, registration for this event has expired');
        }
    });
}

tehcoder

7 years ago

Level 1

Awesome! I didn't know about withValidator function. Thanks for help!

PS: there is a syntax error, make sure you close after();

Aforeg

7 years ago

Level 1

Right, thanks.. Updated... :-)

Please or to participate in this conversation.