Query Data Between Two Date from Date column in Laravel

Question

I'm trying to query data from btween two date from my date column. I tested using api

http://127.0.0.1:8000/api/expense?start=2019-08-01&2019-08-04

but its give me all the records not from date range?

My Controller

  public function index(Request $request)
    {

        $user = auth()->user(); 

        $expenses = Expense::whereHas('user', function($subQuery) use($user){
            return $subQuery->where('shop_id', '=', $user->shop_id);
        })->with(['user'])->get();

        if($request->start && $request->end) {
            $expenses->where(function($q) use ($request) {
                $q->whereBetween('date', array($request->start, $request->end));
            });
        }

        return ExpenseResource::collection($expenses);

    }

i think i do something wrong with my Controller, but i cant still figure it out..

Thanks in advances...

try this : 127.0.0.1:8000/api/expense?start=2019-08-01&end=2019-08-04 — Sandeep Sudhakaran
– Sandeep Sudhakaran, Commented Aug 28, 2019 at 13:16
got this error "explode() expects parameter 2 to be string, object given" — latenight
– latenight, Commented Aug 28, 2019 at 13:18

Sandeep Sudhakaran · Accepted Answer · 2019-08-28 13:40:02Z

0

Hope this answer helps

public function index(Request $request)
{

    $user = auth()->user(); 

    $expenses = Expense::whereHas('user', function($subQuery) use($user){
        return $subQuery->where('shop_id', '=', $user->shop_id);
    })->with(['user']);

    if($request->start && $request->end) {
        $expenses->whereBetween('date', array($request->start, $request->end));
    }        
    return ExpenseResource::collection($expenses->get());

}

what you did was you get() the result first then you apply whereBetween(). Instead I applied whereBetween() first then if your if condition satisfied the get()

and change your URL to 127.0.0.1:8000/api/expense?start=2019-08-01&end=2019-08-04

edited Aug 28, 2019 at 13:40

answered Aug 28, 2019 at 13:18

Sandeep Sudhakaran

1,0982 gold badges10 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

latenight Over a year ago

suddenly, it got another error Call to undefined method Illuminate\Database\Eloquent\Builder::mapInto()

Sandeep Sudhakaran Over a year ago

made some edit in answer. in if clause. please try this one tooo

Sandeep Sudhakaran Over a year ago

ok. made one more change in answer. return ExpenseResource::collection($expenses->get());

Sandeep Sudhakaran Over a year ago

Thanks buddy. Happy coding

sandip bharadva · Accepted Answer · 2019-08-28 13:33:52Z

0

try something like this

$users = User::select("users.*")

            ->whereBetween('created', ['2018-02-01', '2018-02-10'])

            ->get();

answered Aug 28, 2019 at 13:33

sandip bharadva

6341 gold badge6 silver badges21 bronze badges

Collectives™ on Stack Overflow

Query Data Between Two Date from Date column in Laravel

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related