@extends('layouts.website.website') @section('content')
Pharmacy Report
to
Sales Report
@php $purchase_price = 0 ; $total_price = 0 ; @endphp @foreach (App\MadicineSaleDetails::latest()->get()->unique('madicine_id') as $item) @php $purchase_price += $item->madicine_details->price; $total_price += App\MadicineSaleDetails::where('madicine_id',$item->madicine_id)->sum('madicine_qty') * App\MadicneList::where('id',$item->madicine_id)->sum('saleprice'); @endphp {{-- --}} @endforeach
Item Name Quantity Total Purchase Cost Total Sale Cost
{{ $item->madicine_details->name }} {{ App\MadicineSaleDetails::where('madicine_id',$item->madicine_id)->sum('madicine_qty') }} $ {{ $item->madicine_details->price }}{{ App\MadicineSale::sum('discount') }}$ {{ (float) ( App\MadicineSaleDetails::where('madicine_id',$item->madicine_id)->sum('madicine_qty') * App\MadicneList::where('id',$item->madicine_id)->sum('saleprice') ) - App\MadicineSale::where('id',$item->madicine_id)->sum('discount') }}

Sub Total

 $ {{ $purchase_price }} $ {{ $total_price - App\MadicineSale::sum('discount') }}
Total Discount
 $ {{ App\MadicineSale::sum('discount') }}
Sales
 $ {{ App\MadicineSale::sum('grand_total') }}
Expense Report
@foreach (App\Expense::where('status',1)->latest()->get() as $item) @endforeach
Category Amount
{{ $item->categoryDetails->name }} $ {{ $item->amount }}
Purchase Price
$ {{ number_format(App\MadicneList::where('status',1)->sum('price')) }}
Sale Price
$ {{ number_format( $total_price - App\MadicineSale::sum('discount') ) }}
Gross Expense
$ {{ number_format(App\Expense::where('status',1)->sum('amount')) }}
Profit
$ {{ number_format(App\MadicineSale::sum('grand_total')) }}
@endsection