@extends('Reports.template')

<!--Title-->
@section('title')
Pharmacy Purchase, Sales & Collection Report
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
<style type="text/css">
    @media print {
        @page{
            size: A4 landscape;
        }
    }
</style>
@endsection
<!--External CSS Close--> 

@section('Content')
<!-- Your Page Content Here -->
<table class="table table-responsive" style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
    <thead>
        <tr>
            <th colspan="3" class="borderNone borderBottom" style="vertical-align:center;">
                <!--Image--> 
                @if($businessEntityMasterData[0]->logo != null)
                <img class="img-responsive" alt="Pharmacy Logo" src="{{"data:image/jpeg;base64,".base64_encode( $businessEntityMasterData[0]->logo )}}"/>
                @endif
            </th>
            <th colspan="20" class="borderNone borderBottom txtLeft">
                <div style="line-height:1.0;" class="heading">{{ $businessEntityMasterData[0]->name }}</div>
                <div style="line-height:1.0;">{{$businessEntityMasterData[0]->add1. " " .$businessEntityMasterData[0]->add2 ." ".$businessEntityMasterData[0]->city." : " .$businessEntityMasterData[0]->pincode }}</div>
                <div style="line-height:1.0;">{{"Phone : ".$businessEntityMasterData[0]->tel1}}</div>
            </th>
        </tr>
        @php 
        $currentTime  = \Carbon\Carbon::now(); 
        @endphp
        <tr>
            <th colspan="12" class="th borderNone borderBottom reportTitle">
                Pharmacy Purchase, Sales & Collection Report
            </th>
            <th colspan="11" class="txtRight th borderNone borderBottom">
                Period : {{ \Helper::getDisplayDate($fromDate) . " TO " . \Helper::getDisplayDate($toDate) }}
            </th>
        </tr>
        <tr>
            <th rowspan="2" width="6%" class="th noPadding borderRight borderTopBottom alignTop txtCenter">Date</th>
            <th colspan="2" class="th noPadding borderTopBottom borderRight alignTop txtCenter"> Purchase </th>
            <th colspan="2" class="th noPadding borderTopBottom borderRight alignTop txtCenter"> Purchase Return</th>
            <th rowspan="2" class="th noPadding borderTopBottom borderRight alignTop txtCenter"> Net <br/> Purchase</th>
            <th colspan="3" class="th noPadding borderTopBottom borderRight alignTop txtCenter"> Sales Cash </th>
            <th colspan="3" class="th noPadding borderTopBottom borderRight alignTop txtCenter"> Sales Cash Return</th>
            <th colspan="3" class="th noPadding borderTopBottom borderRight alignTop txtCenter">Receipt</th>
            <th colspan="2" class="th noPadding borderTopBottom borderRight alignTop txtCenter">Tatal Cash / Bank</th>
            <th colspan="2" class="th noPadding borderTopBottom borderRight alignTop txtCenter">Sales CR</th>
            <th colspan="2" class="th noPadding borderTopBottom borderRight alignTop txtCenter">Sales CR Return</th>
            <th rowspan="2" class="th noPadding borderTopBottom borderRight alignTop txtRight">Total Credit <br/>(K=I-J)</th>
            <th rowspan="2" class="th noPadding borderTopBottom alignTop txtRight">Grand Total <br/>(A-C)+(B-D)+(K)</th>
        </tr>
        <tr>
            <th class="th noPadding borderTopBottom alignTop txtRight">#Bill</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">Amount</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">#Bill</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">Amount</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">#Bill</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">Cash <br/>(A)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">Bank <br/>(B)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">#Bill</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">Cash <br/>(C)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">Bank <br/>(D)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">#Rcpt</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">Cash <br/>(E)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">Bank <br/>(F)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">Cash <br/>(G=A+E-C)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">Bank <br/>(H=B+F-D)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">#Bill </th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">Amount <br/>(I)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">#Bill</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">Amount <br/>(J)</th>
<!--        <tr>
            <th class="th noPadding borderTopBottom alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom alignTop txtRight">(A)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">(B)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom alignTop txtRight">(C)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">(D)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom alignTop txtRight">(E)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">(F)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">(G=A+E-C)</th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">(H=B+F-D)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">(I)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight"></th>
            <th class="th noPadding borderTopBottom borderRight alignTop txtRight">(J)</th>
            <th class="th noPadding borderTopBottom alignTop borderRight txtRight">(K=I-J)</th>
            <th class="th noPadding borderTopBottom alignTop txtRight">(A-C)+(B-D)+(K)</th>
        </tr>-->
        </tr>

    </thead>
    <tbody>
        @php
        $receiptCash = $receiptBank = $totalSalesCashBillCount = $totalSalesCRBillCount = $totalReceiptCount = $totalSalseCreditBillCount = $totalSalseCreditReturnBillCount = $purchaseBill = $purchaseAmount = $purchaseReturnBill = $purchaseReturnAmount = 0;
        $column_A = $column_B = $column_C = $column_D = $column_E = $column_F = $column_G = $column_H = $column_I = $column_J = $column_K = $column_L = 0;
        $sumOf_A = $sumOf_B = $sumOf_C = $sumOf_D = $sumOf_E = $sumOf_F = $sumOf_G = $sumOf_H = $sumOf_I = $sumOf_J = $sumOf_K = $sumOf_L = $sumOf_M = $totalPBill = $totalPamount = $totalPRbill = $totalPRamount = $totalNet = 0;
        @endphp
        @foreach ($data as $key =>$value)
        @php
        $receiptCash = $value["receiptCash"] - $value["refundReceiptCash"];
        $receiptBank = $value["receiptBank"] - $value["refundReceiptBank"];
        $purchaseBill = $value["pCount"];
        $purchaseAmount = $value["puchaseAmount"];
        $purchaseReturnBill = $value["prCount"];
        $purchaseReturnAmount = $value["prAmount"];
        $purchaseNet = $purchaseAmount - $purchaseReturnAmount;
        $column_A = $value["cashSaleBill"];
        $column_B = $value["bankSaleBill"];
        $column_C = $value["cashSaleReturnBill"];
        $column_D = $value["bankSaleReturnBill"];
        $column_E = $receiptCash;
        $column_F = $receiptBank;
        $column_G = $column_A + $column_E - $column_C;
        $column_H = $column_B + $column_F - $column_D;
        $column_I = $value["totalSaleBill"];
        $column_J = $value["totalSaleReturnBill"];
        $column_K = $column_I - $column_J;
        $column_L = ($column_A - $column_C) + ($column_B - $column_D) + ($column_K);
        @endphp
        <tr>
            <td class="td notBold alignTop borderTop borderRight">{{ \Helper::getDisplayDate($key) }}</td>
            <td class="td notBold alignTop borderTop txtRight">{{ \Helper::zeroValueToNbspSpace($purchaseBill) }}</td>
            <td class="td notBold alignTop borderTop txtRight borderRight">{{ \Helper::customAmountFormat($purchaseAmount) }}</td>
            <td class="td notBold alignTop borderTop txtRight">{{ \Helper::zeroValueToNbspSpace($purchaseReturnBill) }}</td>
            <td class="td notBold alignTop borderTop txtRight borderRight">{{ \Helper::customAmountFormat($purchaseReturnAmount) }}</td>
            <td class="td notBold alignTop borderTop txtRight borderRight">{{ \Helper::customAmountFormat($purchaseNet) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($value["noSaleBill"]) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($column_A) }}</td>
            <td class="td notBold alignTop borderTop borderRight txtRight">{{ \Helper::customAmountFormat($column_B) }}</td>
            <td class="td notBold alignTop borderTop txtRight">{{ \Helper::zeroValueToNbspSpace($value["noSaleReturnBill"]) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight ">{{ \Helper::customAmountFormat($column_C) }}</td>
            <td class="td notBold alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($column_D) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($value["totalReceipt"]) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($column_E) }}</td>
            <td class="td notBold alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($column_F) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($column_G) }}</td>
            <td class="td notBold alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($column_H) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($value["totalSaleBillCount"]) }}</td>
            <td class="td notBold alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($column_I) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($value["totalSaleReturnBillCount"]) }}</td>
            <td class="td notBold alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($column_J) }}</td>
            <td class="td notBold alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($column_K) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($column_L) }}</td>
        </tr>
        @php
        $totalSalesCashBillCount += $value["noSaleBill"];
        $totalSalesCRBillCount += $value["noSaleReturnBill"];
        $totalReceiptCount += $value["totalReceipt"];
        $totalSalseCreditBillCount += $value["totalSaleBillCount"];
        $totalSalseCreditReturnBillCount += $value["totalSaleReturnBillCount"];
        $sumOf_A += $column_A;
        $sumOf_B += $column_B;
        $sumOf_C += $column_C;
        $sumOf_D += $column_D;
        $sumOf_E += $column_E;
        $sumOf_F += $column_F;
        $sumOf_G += $column_G;
        $sumOf_H += $column_H;
        $sumOf_I += $column_I;
        $sumOf_J += $column_J;
        $sumOf_K += $column_K;
        $sumOf_L += $column_L;
        $totalPBill += $purchaseBill;
        $totalPamount += $purchaseAmount;
        $totalPRbill +=  $purchaseReturnBill;
        $totalPRamount += $purchaseReturnAmount;
        $totalNet += $purchaseNet;
        @endphp
        @endforeach
        <tr>
            <th class="th alignTop borderTop borderRight">Total</th>
            <th class="th alignTop borderTop txtRight">{{ \Helper::zeroValueToNbspSpace($totalPBill) }}</th>
            <th class="th alignTop borderTop borderRight txtRight">{{ \Helper::customAmountFormat($totalPamount) }}</th>
            <th class="th alignTop borderTop txtRight">{{ \Helper::zeroValueToNbspSpace($totalPRbill) }}</th>
            <th class="th alignTop borderTop borderRight txtRight">{{ \Helper::customAmountFormat($totalPRamount) }}</th>
            <th class="th alignTop borderTop borderRight txtRight">{{ \Helper::customAmountFormat($totalNet) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($totalSalesCashBillCount) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($sumOf_A) }}</th>
            <th class="th alignTop borderTop borderRight txtRight">{{ \Helper::customAmountFormat($sumOf_B) }}</th>
            <th class="th alignTop borderTop txtRight">{{ \Helper::zeroValueToNbspSpace($totalSalesCRBillCount) }}</th>
            <th class="th alignTop borderTopBottom txtRight ">{{ \Helper::customAmountFormat($sumOf_C) }}</th>
            <th class="th alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($sumOf_D) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($totalReceiptCount) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($sumOf_E) }}</th>
            <th class="th alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($sumOf_F) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($sumOf_G) }}</th>
            <th class="th alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($sumOf_H) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($totalSalseCreditBillCount) }}</th>
            <th class="th alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($sumOf_I) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::zeroValueToNbspSpace($totalSalseCreditReturnBillCount) }}</th>
            <th class="th alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($sumOf_J) }}</th>
            <th class="th alignTop borderTopBottom borderRight txtRight">{{ \Helper::customAmountFormat($sumOf_K) }}</th>
            <th class="th alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($sumOf_L) }}</th>
        </tr>
    </tbody>
    <tfoot>
    <td colspan="23" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
</tfoot>
</table>

<!--Print--> 
<div class="col-xs-12 no-print" style="margin-bottom:15px;">
    <div class="col-xs-5 col-lg-offset-5 no-print">
        <button class="btn btn-sm btn-info" id="btnexport" data-myval="Pharmacy Purchase, Sales & Collection Report">
            <span class="glyphicon glyphicon-download-alt"></span> Excel
        </button>
        <button onclick="print()" class="btn btn-sm btn-success no-print">
            <span class="glyphicon glyphicon-print"></span> Print
        </button>
        <a href="{{ url('Item/medicalStoreCollectionReportInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
    </div>
</div>
@endsection