Laravel query multiple usage

Question

How can I using same query and just change the where statement like this:

$query = Transaction::ofBranch($this->merchant_id)->where(DB::raw('MONTH(created_at)'), Carbon::now()->subMonths($value)->format('m'));
$count = $query->count();
$total_paid = $query->where('status',1)->sum('amount');
$total_unpaid = $query->where('status',0)->sum('amount');

I got all result except $total_unpaid.

When I check, it appears the query has been replaced by total_paid. So the $total_unpaid has no results.

Is there any way I can make it work or any idea to make it more efficient and no repeating the base query?

Thanks

Try to clone a $query before fetching $total_paid and $total_unpaid (You'll get, for example, $query and $query2). Then use $query for $total_paid and $query2 for $total_unpaid. Here I presume that "cloning" is not "repeating". — Gino Pane
– Gino Pane, Commented Jan 5, 2016 at 9:40

mymiracl · Accepted Answer · 2017-04-21 01:53:59Z

1

$query = Transaction::ofBranch($this->merchant_id)->where(DB::raw('MONTH(created_at)'), Carbon::now()->subMonths($value)->format('m'));

Solution is to use clone, by which your original query will remain same and will not change, when you will extend this query.

E.g

$clone = clone $query;

You can use this instead $query Use this

$count = $clone ->count();

Not this:

$count = $query->count();

Others will be like

$total_paid = $clone->where('status',1)->sum('amount');

$total_unpaid = $clone->where('status',0)->sum('amount');

edited Apr 21, 2017 at 1:53

mymiracl

5791 gold badge16 silver badges24 bronze badges

answered Apr 20, 2017 at 19:24

Ali Aqdas

73 bronze badges

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

Comments

AddWeb Solution Pvt Ltd · Accepted Answer · 2017-04-21 07:34:30Z

0

You can try:

$query = Transaction::ofBranch($this->merchant_id)->where(DB::raw('MONTH(created_at)'), Carbon::now()->subMonths($value)->format('m'));
 $count = $query->count();
 $total_paid = $query->where('status',1)->sum('amount');
 $total_unpaid = $query->orWhere('status',0)->sum('amount');

answered Apr 21, 2017 at 7:34

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

Collectives™ on Stack Overflow

Laravel query multiple usage

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related