@extends('layouts.template')

@section('template')
<style type="text/css" media="print">
    @page 
    {
        size: auto;   /* auto is the initial value */
        margin: 10mm 0 20mm 0;
    }
    .print-margin{
        margin: 5%;
    }
    .no-print{
        display: none;
    }
</style>
<style type="text/css">
    td{
        text-align: center;
    }
    th,td{
        padding: 3px;
    }
    .row_total th{
        text-align: center;
    }
</style>

<section class="content-header">

    <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
        <li class="active">Item Inventory History</li>
    </ol>
    <br>
</section>

<section class="content print-margin">
    <div class="row">
        <div class="col-md-12 text-center" >
            <h3>{{ $globalSettings->company_name }}</h3>
            <h5><strong>Item: {{ $item_name }}</strong></h5>
            @php date_default_timezone_set("Asia/Dhaka"); @endphp
             Date: {{ date('F j, Y') }} {{ date('h:i:s a') }}

             <div class="no-print">
                <button id="printBtn" onclick='window.print()' class="btn btn-primary btn-sm pull-right"> Print</button>
                <br><br>
            </div>
        </div>
        <div class="col-md-6">
            <div class="panel panel-default">
                <div class="panel-body">
                    <div class="table-responsive">
                        <h5 style="border: 1px solid black;border-radius: 25px; padding: 5px;background-color: #4CAF50; color:#fff">IN - PURCHASE</h5>
                        <table class="table-bordered table-striped" id="" width="100%">
                            <thead>
                                <tr>
                                    <!-- <th height="25">Srl</th> -->
                                    <th height="25" style="width: 30%;text-align: center;">Purchase Invoice</th>
                                    <th style="width: 30%;text-align: center;">Date</th>
                                    <th style="width: 20%;text-align: center;">Qty</th>
                                    <th style="width: 20%;text-align: center;">Rate</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if(isset($inventory_history_in))
                                    @php $total_stock_in = 0; $total_stock_out = 0; @endphp
                                    @foreach($inventory_history_in as $key => $single_data)
                                    <tr>
                                        <!-- <td height="25">{{ ++$key }}</td> -->
                                        <td height="25" style="text-align: left;" class="">{{ $single_data->purchase_master_id}}</td>
                                        <td>{{ $single_data->stock_change_date }}</td>
                                        <td>{{ $single_data->stock_in }}</td>
                                        <td>{{ number_format($single_data->purchase_price,2) }}</td>
                                    </tr>
                                    @php $total_stock_in+=$single_data->stock_in; @endphp
                                    @endforeach
                                @endif
                                    <tr class="row_total">
                                        <th colspan="2">Total</th>
                                        <th>{{ $total_stock_in }}</th>
                                        <th></th>
                                    </tr>
                            </tbody>

                        </table>
                    </div>
                </div>
            </div>
            
            <div class="panel panel-default">
                <div class="panel-body">
                    <div class="table-responsive">
                        <h5 style="border: 1px solid black;border-radius: 25px; padding: 5px;background-color: #4CAF50; color:#fff">IN - SALES RETURN</h5>
                        <table class="table-bordered table-striped" id="" width="100%">
                            <thead>
                                <tr>
                                    <!-- <th height="25">Srl</th> -->
                                    <th height="25" style="width: 30%;text-align: center;">Return Reference</th>
                                    <th style="width: 30%;text-align: center;">Date</th>
                                    <th style="width: 20%;text-align: center;">Qty</th>
                                    <th style="width: 20%;text-align: center;">Rate</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if(isset($sales_return))
                                    @php $total_stock_in = 0; $total_stock_out = 0; @endphp
                                    @foreach($sales_return as $key => $single_data)
                                    <tr>
                                        <!-- <td height="25">{{ ++$key }}</td> -->
                                        <td height="25" style="text-align: left;" class="">{{ $single_data->voucher_ref}}</td>
                                        <td>{{ $single_data->date }}</td>
                                        <td>{{ $single_data->quantity }}</td>
                                        <td>{{ number_format($single_data->rate,2) }}</td>
                                    </tr>
                                    @php $total_stock_in+=$single_data->quantity; @endphp
                                    @endforeach
                                @endif
                                    <tr class="row_total">
                                        <th colspan="2">Total</th>
                                        <th>{{ $total_stock_in }}</th>
                                        <th></th>
                                    </tr>
                            </tbody>

                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-md-6">
            <div class="panel panel-default">
                <div class="panel-body">
                    <div class="table-responsive">
                        <h5 style="border: 1px solid black;border-radius: 25px; padding: 5px;background-color: #D9534F; color:#fff">OUT - SALES</h5>
                        <table class="table-bordered table-striped" id="" width="100%">
                            <thead>
                                <tr>
                                    <!-- <th height="25">Srl</th> -->
                                    <th height="25" style="width: 30%;text-align: center;">Sales Invoice</th>
                                    <th style="width: 30%;text-align: center;">Date</th>
                                    <th style="width: 20%;text-align: center;">Qty</th>
                                    <th style="width: 20%;text-align: center;">Rate</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if(isset($inventory_history_in))
                                    @php $total_stock_in = 0; $total_stock_out = 0; @endphp
                                    @foreach($inventory_history_out as $key => $single_data)
                                    <tr>
                                        <!-- <td height="25">{{ ++$key }}</td> -->
                                        <td height="25" style="text-align: left;" class="">{{ $globalSettings->invoice_prefix."-BI-".str_pad($single_data->sales_master_id, 8, '0', STR_PAD_LEFT) }}</td>
                                        <td>{{ $single_data->stock_change_date }}</td>
                                        <td>{{ $single_data->stock_out }}</td>
                                        <td>{{ number_format($single_data->sales_price,2) }}</td>
                                    </tr>
                                    @php $total_stock_out+=$single_data->stock_out; @endphp
                                    @endforeach
                                    <tr class="row_total">
                                        <th colspan="2">Total</th>
                                        <th>{{ $total_stock_out }}</th>
                                        <th></th>
                                    </tr>
                                @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection