Khudadad's avatar

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"> &nbsp; View</i></a>--}}
                                                {{--<a href="#" class="btn btn-xs btn-lightred"><i class="fa fa-remove"> &nbsp; Delete</i></a>--}}
                                                {{--</td>--}}
                                            </tr>
                                            <?php $i++; ?>
                                        @endforeach
                                 

pagination .......................

0 likes
0 replies

Please or to participate in this conversation.