@extends('Reports.template')

<!--Title-->
@section('title')
@if($type == "supplier")
@php
$reportTitle = "Purchase Detail - Supplier Wise Report";    
@endphp
@else
@php
$reportTitle = "Purchase Detail - Item Wise Report";    
@endphp
@endif
{{$reportTitle}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@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="2" class="borderNone borderBottom" style="vertical-align:center;">
                @if($businessEntityMasterData[0]->logo != null)
                <!--Image--> 
                <img class="img-responsive" alt="Pharmacy Logo" src="{{"data:image/jpeg;base64,".base64_encode( $businessEntityMasterData[0]->logo )}}"/>
                @endif
            </th>
            <th colspan="15" 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="8" class="th borderNone borderBottom reportTitle">{{$reportTitle}}</th>
            <th colspan="4" class="txtRight th borderNone borderBottom">Store : {{$storeName}}</th>
            <th colspan="5" class="txtRight th borderNone borderBottom">Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}</th>
        </tr>
        <tr>
            @if($type == "supplier")
            <th colspan="3" class="th noPadding alignTop borderTop borderBottomGray">Supplier Name</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray">Product Name</th>
            @else
            <th colspan="3" class="th noPadding alignTop borderTop borderBottomGray">Product Name</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray">Supplier Name</th>
            @endif
            <th colspan="5" class="th noPadding alignTop borderTop borderBottomGray">Mfg</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">Category</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">PUOM</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">Pack Size</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">Stock Qty</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight">SUOM</th>
        </tr>
        <tr>
            <th class="th noPadding alignTop borderTopBottom txtRight">Vou No&nbsp;&nbsp;</th>
            <th class="th noPadding alignTop borderTopBottom">Vou Date</th>
            <th class="th noPadding alignTop borderTopBottom">Supp Bill No</th>
            <th class="th noPadding alignTop borderTopBottom">Supp Bill Date</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Qty</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">FQty&nbsp;&nbsp;</th>
            <th class="th noPadding alignTop borderTopBottom">Batch</th>
            <th class="th noPadding alignTop borderTopBottom">Exp</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Sch Amt</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">MRP</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Rate</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Disc Amt</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Taxable</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">IGST?</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">GST %</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">GST</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Total</th>
        </tr>
    </thead>
    <tbody>
        @php
        $oldSuppProID = '';
        $totalQty = 0;
        $totalFQty = 0;
        $totalTaxable = 0;
        $totalGst = 0;
        $total = 0;
        @endphp
        @foreach($purchaseData as $purchase)
        @if($type == "supplier")
        @php
        $suppProID = $purchase->supplier_id.$purchase->product_id;
        @endphp
        @else
        @php
        $suppProID = $purchase->product_id.$purchase->supplier_id;
        @endphp
        @endif
        @if($suppProID != $oldSuppProID)
        @if($totalQty != 0 && $oldSuppProID != '')
        <tr>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom txtRight">Total : </th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$totalQty}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$totalFQty}}&nbsp;&nbsp;</th>
            <td colspan="6" class="td bold noPadding alignTop borderTopBottom"></th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalTaxable)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight"></th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight"></th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalGst)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($total)}}</th>
        </tr>
        @endif
        @php
        $totalQty = 0;    
        $totalFQty = 0;  
        $totalTaxable = 0;
        $totalGst = 0;
        $total = 0;  
        $currentStockQty = 0;    
        @endphp
        @foreach ($productStockData as $productStock)
        @if($productStock->product_id == $purchase->product_id)
        @php
        $currentStockQty = $productStock->currentStock;    
        @endphp
        @endif    
        @endforeach
        <tr>
            @if($type == "supplier")
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">{{$purchase->supplier_name}}</th>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom">{{$purchase->product_name}}</th>
                @else
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">{{$purchase->product_name}}</th>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom">{{$purchase->supplier_name}}</th>
                @endif
            <td colspan="5" class="td bold noPadding alignTop borderTopBottom">{{$purchase->manufacturer_name}}</th>
            <td class="td bold noPadding alignTop borderTopBottom">{{$purchase->category_abbrev}}</th>
            <td class="td bold noPadding alignTop borderTopBottom">{{$purchase->PUOM}}</th>
            <td class="td bold noPadding alignTop borderTopBottom">{{"1x".$purchase->conversion_factor}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$currentStockQty}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$purchase->SUOM}}</th>
        </tr>
        @endif
        @php
        $totalQty += $purchase->quantity;    
        $totalFQty += $purchase->free_quantity;  
        $totalTaxable += $purchase->taxable_amt;
        $totalGst += $purchase->gst_amt;
        $total += $purchase->total;  
        @endphp
        @if($purchase->supplier_supply_type == "inter_state")
        @php
        $isIgstApplicable = "Yes";    
        @endphp
        @else
        @php
        $isIgstApplicable = "";    
        @endphp
        @endif
        <tr>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{$trnType."/".$purchase->trn_fyear."/".$purchase->trn_id}}&nbsp;&nbsp;</th>
            <td class="td noPadding alignTop borderTopBottomGray">{{\Helper::getDisplayDate($purchase->trn_date)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray">{{$purchase->purchase_bill_no}}</th>
            <td class="td noPadding alignTop borderTopBottomGray">{{\Helper::getDisplayDate($purchase->purchase_bill_date)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{$purchase->quantity}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{$purchase->free_quantity}}&nbsp;&nbsp;</th>
            <td class="td noPadding alignTop borderTopBottomGray">{{$purchase->batch_no}}</th>
            <td class="td noPadding alignTop borderTopBottomGray">{{\Helper::getMonthYearFromDate($purchase->batch_exp)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($purchase->sch_amt)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($purchase->mrp)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat4($purchase->price)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($purchase->discount_amt)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($purchase->taxable_amt)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{$isIgstApplicable}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($purchase->gst)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($purchase->gst_amt)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($purchase->total)}}</th>
        </tr>
        @php
        $oldSuppProID = $suppProID;    
        @endphp
        @endforeach
        <tr>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom txtRight">Total : </th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$totalQty}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{$totalFQty}}&nbsp;&nbsp;</th>
            <td colspan="6" class="td bold noPadding alignTop borderTopBottom"></th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalTaxable)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight"></th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight"></th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalGst)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($total)}}</th>
        </tr>
    </tbody>
    <tfoot>
    <td colspan="17" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>    
</tfoot>
</table>
<br/><br/>

<!--Print--> 
<div class="col-xs-12" 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="{{$reportTitle}}">
            <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>
        @if($trnType == "P")
        <a href="{{ url('Item/PurchaseDetailReportInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
        @else
        <a href="{{ url('StoreItem/PurchaseDetailReportInput') }}" class="no-print btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> Back
        </a>
        @endif
    </div>
</div>

@endsection

<!--Bootstrap Modals-->      
@section('BootstrapModals')
@endsection
<!--Bootstrap Modals Close-->

<!--External JS-->
@section('ExternalJs')
<script src="{{ asset ("/js/export_to_excel.js?$releaseVersion") }}"></script>
@endsection
<!--External JS Close-->