Laravel Project - Adding Day Reports
Author: Al-mamun Sarkar
Date: 2020-09-27 08:29:28
এই লেসনে আমরা Day Reports দেখাবো। যেখানে একই পেজে সব রিপোর্ট (Sales, Purchase, Payments, Receipts) দেখানো হয়েছে।
Source Code:
Routes:
Route::get('reposts/days', 'Reports\DayReportsController@index')->name('reports.days');
DayReportsController.php
namespace App\Http\Controllers\Reports;
use App\Http\Controllers\Controller;
use App\Payment;
use App\PurchaseItem;
use App\Receipt;
use App\SaleItem;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class DayReportsController extends Controller
{
public function __construct()
{
parent::__construct();
$this->data['main_manu'] = 'Reports';
$this->data['sub_manu'] = 'Days';
}
public function index( Request $request )
{
$this->data['start_date'] = $request->get('start_date', date('Y-m-d'));
$this->data['end_date'] = $request->get('end_date', date('Y-m-d'));
$this->data['sales'] = SaleItem::select( 'products.title', DB::raw( 'SUM(sale_items.quantity) as quantity, AVG(sale_items.price) AS price, SUM(sale_items.total) as total') )
->join('products', 'sale_items.product_id', '=', 'products.id')
->join('sale_invoices', 'sale_items.sale_invoice_id', '=', 'sale_invoices.id')
->whereBetween('sale_invoices.date', [ $this->data['start_date'], $this->data['end_date'] ])
->where('products.has_stock', 1)
->groupBy('products.id')
->get();
$this->data['purchases'] = PurchaseItem::select( 'products.title', DB::raw( 'SUM(purchase_items.quantity) as quantity, AVG(purchase_items.price) AS price, SUM(purchase_items.total) as total') )
->join('products', 'purchase_items.product_id', '=', 'products.id')
->join('purchase_invoices', 'purchase_items.purchase_invoice_id', '=', 'purchase_invoices.id')
->whereBetween('purchase_invoices.date', [ $this->data['start_date'], $this->data['end_date'] ])
->where('products.has_stock', 1)
->groupBy('products.id')
->get();
$this->data['receipts'] = Receipt::select('users.name', 'users.phone', DB::raw('SUM(receipts.amount) as amount') )
->join('users', 'receipts.user_id', '=', 'users.id')
->whereBetween('date', [ $this->data['start_date'], $this->data['end_date'] ])
->groupBy('user_id')
->get();
$this->data['payments'] = Payment::select('users.name', 'users.phone', DB::raw('SUM(payments.amount) as amount') )
->join('users', 'payments.user_id', '=', 'users.id')
->whereBetween('date', [ $this->data['start_date'], $this->data['end_date'] ])
->groupBy('user_id')
->get();
return view('reports.days', $this->data);
}
}
reports/days.blade.php
@extends('layout.main')
@section('main_content')
<div class="row clearfix page_header">
<div class="col-md-4">
<h2> Day Reports </h2>
</div>
<div class="col-md-8 text-right">
{!! Form::open([ 'route' => ['reports.days'], 'method' => 'get' ]) !!}
<div class="form-row align-items-center">
<div class="col-auto">
<label class="sr-only" for="inlineFormInput">Start Date</label>
{{ Form::date('start_date', $start_date, [ 'class'=>'form-control', 'id' => 'date', 'placeholder' => 'Start Date' ]) }}
</div>
<div class="col-auto">
<label class="sr-only" for="inlineFormInputGroup">End Date</label>
<div class="input-group mb-2">
{{ Form::date('end_date', $end_date, [ 'class'=>'form-control', 'id' => 'date', 'placeholder' => 'End Date' ]) }}
</div>
</div>
<div class="col-auto">
<button type="submit" class="btn btn-primary mb-2">Submit</button>
</div>
</div>
{!! Form::close() !!}
</div>
</div>
<div class="row">
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-primary shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-primary text-uppercase mb-1"> Total Sales </div>
<div class="h5 mb-0 font-weight-bold text-gray-800"> {{ number_format($sales->sum('total'), 2) }} </div>
</div>
<div class="col-auto">
<i class="fas fa-calendar fa-2x text-gray-300"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-primary shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-primary text-uppercase mb-1"> Total Purchases </div>
<div class="h5 mb-0 font-weight-bold text-gray-800"> {{ number_format($purchases->sum('total'), 2) }} </div>
</div>
<div class="col-auto">
<i class="fas fa-calendar fa-2x text-gray-300"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-primary shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-primary text-uppercase mb-1"> Total Receipts </div>
<div class="h5 mb-0 font-weight-bold text-gray-800"> {{ number_format($receipts->sum('amount'), 2) }} </div>
</div>
<div class="col-auto">
<i class="fas fa-calendar fa-2x text-gray-300"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-primary shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-primary text-uppercase mb-1"> Total Payments </div>
<div class="h5 mb-0 font-weight-bold text-gray-800"> {{ number_format($payments->sum('amount'), 2) }} </div>
</div>
<div class="col-auto">
<i class="fas fa-calendar fa-2x text-gray-300"></i>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Sales Report From <strong>{{ $start_date }}</strong> to <strong>{{ $end_date }}</strong> </h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-striped table-borderless table-sm" cellspacing="0">
<thead>
<tr>
<th>Products</th>
<th class="text-right">Quantity</th>
<th class="text-right">Price</th>
<th class="text-right">Total</th>
</tr>
</thead>
<tbody>
@foreach ($sales as $sale)
<tr>
<td> {{ $sale->title }} </td>
<td class="text-right"> {{ $sale->quantity }} </td>
<td class="text-right"> {{ number_format($sale->price, 2) }} </td>
<td class="text-right"> {{ number_format($sale->total, 2) }} </td>
</tr>
@endforeach
</tbody>
<tfoot>
<tr>
<th class="text-right">Ttoal Items:</th>
<th class="text-right"> {{ $sales->sum('quantity') }} </th>
<th class="text-right">Total:</th>
<th class="text-right"> {{ number_format($sales->sum('total'), 2) }} </th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
{{-- Purchases Reports --}}
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Purchases Report From <strong>{{ $start_date }}</strong> to <strong>{{ $end_date }}</strong> </h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-striped table-borderless table-sm" cellspacing="0">
<thead>
<tr>
<th>Products</th>
<th class="text-right">Quantity</th>
<th class="text-right">Price</th>
<th class="text-right">Total</th>
</tr>
</thead>
<tbody>
@foreach ($purchases as $purchase)
<tr>
<td> {{ $purchase->title }} </td>
<td class="text-right"> {{ $purchase->quantity }} </td>
<td class="text-right"> {{ number_format($purchase->price, 2) }} </td>
<td class="text-right"> {{ number_format($purchase->total, 2) }} </td>
</tr>
@endforeach
</tbody>
<tfoot>
<tr>
<th class="text-right">Ttoal Items:</th>
<th class="text-right"> {{ $purchases->sum('quantity') }} </th>
<th class="text-right">Total:</th>
<th class="text-right"> {{ number_format($purchases->sum('total'), 2) }} </th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
{{-- Receipts Report --}}
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Receipts Report From <strong>{{ $start_date }}</strong> to <strong>{{ $end_date }}</strong> </h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-striped table-borderless table-sm" cellspacing="0">
<thead>
<tr>
<th>User</th>
<th>Phone</th>
<th class="text-right">Amount</th>
</tr>
</thead>
<tbody>
@foreach ($receipts as $receipt)
<tr>
<td> {{ $receipt->name }} </td>
<td> {{ $receipt->phone }} </td>
<td class="text-right"> {{ number_format($receipt->amount, 2) }} </td>
</tr>
@endforeach
</tbody>
<tfoot>
<tr>
<th colspan="2" class="text-right">Total:</th>
<th class="text-right"> {{ number_format($receipts->sum('amount'), 2) }} </th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
{{-- Reports for payments --}}
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Payments Report From <strong>{{ $start_date }}</strong> to <strong>{{ $end_date }}</strong> </h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-striped table-borderless table-sm" cellspacing="0">
<thead>
<tr>
<th>User</th>
<th>Phone</th>
<th class="text-right">Amount</th>
</tr>
</thead>
<tbody>
@foreach ($payments as $payment)
<tr>
<td> {{ $payment->name }} </td>
<td> {{ $payment->phone }} </td>
<td class="text-right"> {{ number_format($payment->amount, 2) }} </td>
</tr>
@endforeach
</tbody>
<tfoot>
<tr>
<th colspan="2" class="text-right">Total:</th>
<th class="text-right"> {{ number_format($payments->sum('amount'), 2) }} </th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
@stop