如何在Laravel进行一年中的独特检查

Question

Here is a table named installments which has date_of_receipt and user_id columns. I need to check if a date date_of_receipt = 27-01-2019 has present according to a user so I have to validate this entity already exists here for any January 2019 day. How can I do that in Laravel5.7 with MySQL?

Answer 1

Because you are storing it as a string in a particular format, you could achieve this with something like this:

$start = \Carbon\Carbon::parse($request->date_of_receipt)->startOfMonth()->format('d-m-Y');
$end   = \Carbon\Carbon::parse($request->date_of_receipt)->endOfMonth()->endOfDay()->format('d-m-Y');

return DB::table('installments')
    ->where('user_id', $user_id)
    ->whereBetween('date_of_receipt', [$start, $end])
    ->exists();