@extends('dashboard_connect.dash_master')
@section('pagescontents')
<script src="https://cdn.jsdelivr.net/npm/chart.js@3.7.0/dist/chart.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chartjs-plugin-datalabels@2.0.0/dist/chartjs-plugin-datalabels.min.js"></script>
	<!-- PAGE-HEADER -->
	<div class="page-header">
		<div>
			<h1 class="page-title">Consumable Stock Register</h1>
		</div>
		<div class="ms-auto pageheader-btn">
			<ol class="breadcrumb">
				<li class="breadcrumb-item"><a href="javascript:void(0);">Dashboard</a></li>
				<li class="breadcrumb-item active" aria-current="page">Consumable Stock</li>
			</ol>
		</div>
	</div>
	<!-- PAGE-HEADER END -->
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header border-bottom">
                    <h3 class="card-title">Consumable Stock Register Report</b></h3>
                    <div class="card-options">
                        <a href="{{ route('consumable.excel.download') }}" class="btn btn-danger btn-sm ms-2"><i class="fa fa-file-excel-o" aria-hidden="true"></i> Download Consumable Stock Report</a>&nbsp;&nbsp;
                        <a href="{{ route('consrepoledger.excel.download') }}" class="btn btn-info btn-sm ms-2"><i class="fa fa-file-excel-o" aria-hidden="true"></i> Download Consumable Stock Ledger</a>
                    </div>                    
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="table-responsive">
                                <table class="table text-nowrap table-bordered border-bottom w-100" id="responsive-datatable-3">
                                    <thead>
                                        <tr>
                                            <th class="wd-15p border-bottom-0">S. No.</th>
                                            <th class="wd-15p border-bottom-0">Date</th>
                                            <th class="wd-15p border-bottom-0">Item Name</th>
                                            <th class="wd-15p border-bottom-0">Bill Number & Date</th>
                                            <th class="wd-25p border-bottom-0">Receipt Quant.</th>
                                            <th class="wd-25p border-bottom-0">Issue Voucher No.</th>
                                            <th class="wd-25p border-bottom-0">Issue Date</th>
                                            <th class="wd-25p border-bottom-0">Issue Quant.</th>
                                            <th class="wd-25p border-bottom-0">Unit Price</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $intcount = 1;
                                        @endphp
                                        @foreach($fixassetsuppldt as $keyone => $itemone)
                                            <tr>
                                                <td>{{ $intcount }}</td>
                                                <td>{{ Carbon\Carbon::parse($itemone->consuadate)->format('d-M-Y') }}</td>
                                                <td>
                                                    <b>{{ getitemname($itemone->prosupplid) }}&nbsp;&nbsp;[Total Receipt: <font style="font-size: 16px;">{{ Round(totalcomisrept($itemone->prosupplid, "RECEIPT"),0) }}</font>&nbsp;/&nbsp;Total Issue: <font style="font-size: 16px;">{{ Round(totalcomisrept($itemone->prosupplid, "ISSUE"),0) }}</font>&nbsp;/&nbsp;Current Balance: <font style="font-size: 16px;">{{ Round(getcurrbalance($itemone->prosupplid),0) }}</font>]</b>
                                                </td>
                                                <td>{{ $itemone->billnumber }}<br>{{ Carbon\Carbon::parse($itemone->billdate)->format('d-M-Y') }}</td>
                                                <td>{{ Round($itemone->recpquant,2) }}</td>
                                                <td>{{ $itemone->issvouchnum }}</td>
                                                <td>{{ Carbon\Carbon::parse($itemone->issuedate)->format('d-M-Y') }}</td>
                                                <td>{{ Round($itemone->issuequant,2) }}</td>
                                                <td>{{ $itemone->unitprice }}</td>
                                            </tr>
                                        @php
                                            $intcount++;
                                        @endphp                                                
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>                    
            </div>
        </div>
    </div>

    <script>
        function isNumberKey(evt){
            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode > 31 && (charCode != 46 &&(charCode < 48 || charCode > 57)))
                return false;
            return true;
        }
    </script>

@endsection