Jun 21, 2016
0
Level 2
How to paginage the result of two Queries?
I have to collections of two queries and want to paginate in one pagination and don't know how to do this, any help. my queries:
$expenses = DB::table('expenses')
->join('units','units.unit_id','=','expenses.unit_id')
->join('currencies','currencies.cur_id','=','expenses.currency_id')
->join('expense_type','expense_type.exp_type_id','=','expenses.expense_type_id')
->select('expenses.*','units.unit_name','currencies.currency','expense_type.exp_type_name','expense_type.exp_type_id')
->orderBy('created_at','desc')
->paginate(10);
$purchases = DB::table('purchases')
->join('brands','brands.bid','=','purchases.brand_id')
->join('units','units.unit_id','=','purchases.unit_id')
->join('stock_item','stock_item.stm_id','=','purchases.item_id')
->join('categories','categories.cat_id','=','purchases.category_id')
->join('currencies','currencies.cur_id','=','purchases.currency_id')
->select('purchases.*','brands.brand_name','units.unit_name','stock_item.item_name','currencies.currency','categories.category_name')
->orderBy('purchases.created_at','desc')
->paginate(10);
The View :
<?php $i = 1;?>
@foreach($expenses as $expense)
<tr>
<td style="border-right: 1px solid #ddd;"><?php echo $i;?></td>
<td>{{ $expense->exp_name }}</td>
<td>{{ $expense->exp_type_name }}</td>
<td>{{ \Carbon::parse($expense->exp_date)->format('d/M/Y') }}</td>
<td>{{ $expense->currency }}</td>
<td>{{ $expense->quantity }}</td>
<td>{{ $expense->unit_name }}</td>
<td>{{ number_format($expense->price,2) }}</td>
<td>
<span class="symbol">$</span> {{ number_format($expense->c_price,2) }}
</td>
<td class="total">
{{ number_format($expense->total,2) }} <span class="symbol">AFN</span>
</td>
<td class="total">
<span class="symbol">$</span> <?php echo number_format($expense->c_total,2,'.','');?>
</td>
</tr>
<?php $i++; ?>
@endforeach
@foreach($purchases as $pr)
<tr>
<td style="border-right: 1px solid #ddd;"><?php echo $i;?></td>
<td>{{ $pr->item_name }}</td>
<td>{{ "Purchase" }}</td>
<td>{{ \Carbon::parse($pr->buy_date)->format('d/M/Y') }}</td>
<td>{{ $pr->currency }}</td>
<td>{{ $pr->quantity }}</td>
<td>{{ $pr->unit_name }}</td>
<td>{{ number_format($pr->unit_price,2) }}</td>
<td>
<span class="symbol">$</span> {{ number_format($pr->c_price,2) }}
</td>
<td class="total">
{{ number_format($pr->unit_price*$pr->quantity,2) }} <span class="symbol">AFN</span>
</td>
<td class="total">
<span class="symbol">$</span> <?php echo number_format($pr->c_price*$pr->quantity,2,'.','');?>
</td>
{{--<td>--}}
{{--<a href="/purchase/item" class="btn btn-xs btn-green mr-5"><i class="fa fa-search"> View</i></a>--}}
{{--<a href="#" class="btn btn-xs btn-lightred"><i class="fa fa-remove"> Delete</i></a>--}}
{{--</td>--}}
</tr>
<?php $i++; ?>
@endforeach
pagination .......................
Please or to participate in this conversation.