@extends('layouts.default', ['appTopMenu' => true])
@php

use App\Models\inventory\Issue_model;
use App\Models\inventory\Purchase_model;


@endphp
@section('title','Dashboard') 
@push('scripts')

<link rel="stylesheet" href="{{ asset('css/jquery-ui.css')}}" />
<script src="{{ asset('js/jquery-ui.js') }}"></script>

<script src="{{ asset('js/hcrti/application.js')}}"></script>
 
 <meta name="csrf-token" content="{{ csrf_token() }}" />
 <link href="/assets/plugins/select2/dist/css/select2.min.css" rel="stylesheet" />

<script src="/assets/plugins/select2/dist/js/select2.min.js" defer></script>
<link href="/assets/plugins/bootstrap-datepicker/dist/css/bootstrap-datepicker.css" rel="stylesheet" />
<script src="/assets/plugins/bootstrap-datepicker/dist/js/bootstrap-datepicker.js" defer></script>

<script src="/assets/plugins/sweetalert/dist/sweetalert.min.js"></script>


<link href="/assets/plugins/datatables.net-bs5/css/dataTables.bootstrap5.min.css" rel="stylesheet" />
<link href="/assets/plugins/datatables.net-responsive-bs5/css/responsive.bootstrap5.min.css" rel="stylesheet" />
<script src="/assets/plugins/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="/assets/plugins/datatables.net-bs5/js/dataTables.bootstrap5.min.js"></script>
<script src="/assets/plugins/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="/assets/plugins/datatables.net-responsive-bs5/js/responsive.bootstrap5.min.js"></script>
<script type="text/javascript">
$(".dtp").datepicker({
  todayHighlight: true,
    autoclose: true,
	opens: "right",
    dateFormat: "dd-mm-yy"
  });

 
  $.ajaxSetup({
    headers: {
        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
    }
});
            function getAMCRecordDateWise() {

                var selectedDate = $('#till_date').val();

                $.ajax({
                    type: "POST",
                    dataType: 'JSON',
                    url: "{{ url('reports/get_amc_records') }}",
                    data: {'till_date': selectedDate, 'filter_by': 'DATE'},
                    beforeSend: function (request) {
                        return request.setRequestHeader('X-CSRF-Token', $("meta[name='csrf-token']").attr('content'));
                    },
                    success: function (data) {

                        $('#show_result_div').show();

                        var html = '';
                        var i = 0;
                        $.each(data, function (key, value) {

                            var warranty_year = value.warranty;
                            var parts = value.item_receiving_date.split("-");

                            var day = parts[2] && parseInt(parts[2], 10);
                            var month = parts[1] && parseInt(parts[1], 10);
                            var year = parts[0] && parseInt(parts[0], 10);

                            if (day <= 31 && day >= 1 && month <= 12 && month >= 1) {
                                var date_of_expiry = new Date(year, month - 1, 0);
                                var day = ('0' + date_of_expiry.getDate()).slice(-2);
                                var month = ('0' + (date_of_expiry.getMonth() + 1)).slice(-2);
                                var year = date_of_expiry.getFullYear() + warranty_year;
                                var warranty_exp_date = day + '-' + month + '-' + year;

                            }

                            var warranty_expiry_dt = warranty_exp_date.split('-');
                            var today_date = selectedDate.split('-');

                            var warranty_expiry_date = new Date(warranty_expiry_dt[2], warranty_expiry_dt[0], warranty_expiry_dt[1]);
                            var today_date = new Date(today_date[2], today_date[0], today_date[1]);
                         

                            if (warranty_expiry_date < today_date) {

                                i = i + 1;
                                html += '<tr>';
                                html += '<td>' + i + '</td>';
                                html += '<td>' + value.pur_order_no + '</td>';
                                html += '<td>' + value.pur_order_date.toString('d-m-Y') + '</td>';
                                html += '<td>' + value.pname + '</td>';
                                html += '<td>' + value.cname + '</td>';
                                html += '<td>' + value.model_no + '</td>';
                                html += '<td>' + value.sr_no + '</td>';
                                html += '<td>' + value.warranty + '</td>';
                                html += '<td>' + value.item_receiving_date + '</td>';
                                html += '<td><a href="#"><span class="badge bg-danger">Warranty Expired</span></a></td>';
                                html += '</tr>';
                            } else {
                                html += '<tr>';
                                html += '<td  colspan="10">No data available in table.</td>';
                                html += '</tr>';
                            }

                        });
                        $('#results').html(html);

                    }, error: function (data) {
                        $('.text-danger').text('');
                        if (data.status === 401) {
                            $(location).prop('/', 'login');
                        } else if (data.status === 422) {
                            $.each(data.responseJSON.errors, function (field_name, error) {
                                toastr.error(error);
                            })

                        }
                    }
                });
            }

            function getAMCRecordProductWise(filter_by) {

                var selectedValues = $('#product').val();
                $.ajax({
                    type: "POST",
                    dataType: 'JSON',
                    url: "{{ url('reports/get_amc_records') }}",
                    data: {'product_id': selectedValues, 'filter_by': filter_by},
                    beforeSend: function (request) {
                        return request.setRequestHeader('X-CSRF-Token', $("meta[name='csrf-token']").attr('content'));
                    },
                    success: function (data) {

                        $('#show_result_div').show();

                        var html = '';
                        var i = 0;
                        $.each(data, function (key, value) {

                            var warranty_year = value.warranty;
                            var parts = value.item_receiving_date.split("-");

                            var day = parts[2] && parseInt(parts[2], 10);
                            var month = parts[1] && parseInt(parts[1], 10);
                            var year = parts[0] && parseInt(parts[0], 10);

                            if (day <= 31 && day >= 1 && month <= 12 && month >= 1) {
                                var date_of_expiry = new Date(year, month - 1, 0);
                                var day = ('0' + date_of_expiry.getDate()).slice(-2);
                                var month = ('0' + (date_of_expiry.getMonth() + 1)).slice(-2);
                                var year = date_of_expiry.getFullYear() + warranty_year;
                                var warranty_exp_date = day + '-' + month + '-' + year;

                            }
                            var d = new Date();
                            var currentDate = d.getDate() + '-' + (d.getMonth() + 1) + '-' + d.getFullYear();

                            var warranty_expiry_dt = warranty_exp_date.split('-');
                            var today_date = currentDate.split('-');

                            var warranty_expiry_date = new Date(warranty_expiry_dt[2], warranty_expiry_dt[0], warranty_expiry_dt[1]);
                            var today_date = new Date(today_date[2], today_date[0], today_date[1]);

                            if (warranty_expiry_date < today_date) {

                                i = i + 1;
                                html += '<tr>';
                                html += '<td>' + i + '</td>';
                                html += '<td>' + value.pur_order_no + '</td>';
                                html += '<td>' + value.pur_order_date.toString('d-m-Y') + '</td>';
                                html += '<td>' + value.pname + '</td>';
                                html += '<td>' + value.cname + '</td>';
                                html += '<td>' + value.model_no + '</td>';
                                html += '<td>' + value.sr_no + '</td>';
                                html += '<td>' + value.warranty + '</td>';
                                html += '<td>' + value.item_receiving_date + '</td>';
                                html += '<td><a href="#"><span class="badge bg-danger">Warranty Expired</span></a></td>';
                                html += '</tr>';
                            } else {
                                html += '<tr>';
                                html += '<td  colspan="10">No data available in table.</td>';
                                html += '</tr>';
                            }

                        });
                        $('#results').html(html);

                    }, error: function (data) {
                        $('.text-danger').text('');
                        if (data.status === 401) {
                            $(location).prop('/', 'login');
                        } else if (data.status === 422) {
                            $.each(data.responseJSON.errors, function (field_name, error) {
                                toastr.error(error);
                            })

                        }
                    }
                });

            }

            function getAMCRecord(id, filter_by) {

                $.ajax({
                    type: "POST",
                    dataType: 'JSON',
                    url: "{{ url('reports/get_amc_records') }}",
                    data: {'district_id': id, 'product_id': id, 'filter_by': filter_by},
                    beforeSend: function (request) {
                        return request.setRequestHeader('X-CSRF-Token', $("meta[name='csrf-token']").attr('content'));
                    },
                    success: function (data) {

                        $('#show_result_div').show();
                        if (filter_by == 'DISTT') {
                            if ($("#district option:selected").text() == 'All') {
                                $('#distt_name').html('All District and Taluka and High Courts');
                            } else {
                                $('#distt_name').html($("#district option:selected").text());
                            }
                        } else if (filter_by == 'PRODUCT') {
                            if ($("#district option:selected").text() == 'All') {
                                $('#distt_name').html('All District and Taluka and High Courts');
                            } else {
                                $('#distt_name').html($("#district option:selected").text());
                            }
                        }
                        var html = '';
                        var i = 0;
                        $.each(data, function (key, value) {

                            var warranty_year = value.warranty;
                            var parts = value.item_receiving_date.split("-");

                            var day = parts[2] && parseInt(parts[2], 10);
                            var month = parts[1] && parseInt(parts[1], 10);
                            var year = parts[0] && parseInt(parts[0], 10);

                            if (day <= 31 && day >= 1 && month <= 12 && month >= 1) {
                                var date_of_expiry = new Date(year, month - 1, 0);
                                var day = ('0' + date_of_expiry.getDate()).slice(-2);
                                var month = ('0' + (date_of_expiry.getMonth() + 1)).slice(-2);
                                var year = date_of_expiry.getFullYear() + warranty_year;
                                var warranty_exp_date = day + '-' + month + '-' + year;

                            }
                            var d = new Date();
                            var currentDate = d.getDate() + '-' + (d.getMonth() + 1) + '-' + d.getFullYear();

                            var warranty_expiry_dt = warranty_exp_date.split('-');
                            var today_date = currentDate.split('-');

                            var warranty_expiry_date = new Date(warranty_expiry_dt[2], warranty_expiry_dt[0], warranty_expiry_dt[1]);
                            var today_date = new Date(today_date[2], today_date[0], today_date[1]);

                            if (warranty_expiry_date < today_date) {

                                i = i + 1;
                                html += '<tr>';
                                html += '<td>' + i + '</td>';
                                html += '<td>' + value.pur_order_no + '</td>';
                                html += '<td>' + value.pur_order_date.toString('d-m-Y') + '</td>';
                                html += '<td>' + value.pname + '</td>';
                                html += '<td>' + value.cname + '</td>';
                                html += '<td>' + value.model_no + '</td>';
                                html += '<td>' + value.sr_no + '</td>';
                                html += '<td>' + value.warranty + '</td>';
                                html += '<td>' + value.item_receiving_date + '</td>';
                                html += '<td><a href="#"><span class="badge bg-danger">Warranty Expired</span></a></td>';
                                html += '</tr>';
                            } else {
                                html += '<tr>';
                                html += '<td  colspan="10">No data available in table.</td>';
                                html += '</tr>';
                            }

                        });
                        $('#results').html(html);

                    }, error: function (data) {
                        $('.text-danger').text('');
                        if (data.status === 401) {
                            $(location).prop('/', 'login');
                        } else if (data.status === 422) {
                            $.each(data.responseJSON.errors, function (field_name, error) {
                                toastr.error(error);
                            })
                        }
                    }
                });
            }
        </script>
		@endpush

@section('content') 
                <div class="container">
    @if (session('status'))

    <div class="alert alert-success alert-dismissible" >
        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        {!! session('status') !!}
    </div>
    @elseif(session('failed'))
    <div class="alert alert-danger alert-dismissible" >
        <button type="button" class="btn-close" ddata-bs-dismiss="alert"></button>
        <strong>{{ session('failed') }}	</strong>
    </div>
    @endif
	
	
	
	
             

@if(\Session::has('success'))
<div class="alert alert-success message_box" id="message_box">
{{\Session::get('success')}}
</div>
@endif



<div class="card mb-6" id="google_translate_element">
<div class="card-header bg-dark ">AMC Report</div>


<div class="card-body">
<div class="row mb-3">
{{ Form::open(array('name'=>'reportsHistoryForm','id'=>'reportsHistoryForm', 'url'=>'/reports/history', 'class'=>'form-horizontal' ,'method' => 'POST')) }}
<div class="form-group row">
<div class="col-sm-4">
{!! Form::Label('District', 'Search By District') !!}
<select id="district" name="district" onchange="getAMCRecord(this.value, 'DISTT')" class="form-control select2bs4" style="width: 100%;">
<option value="all">All</option>
 {!! App\Models\inventory\Purchase_model::ShowDistrictDropDownAMC(old('district')) !!}
</select>
<span class="text-danger">{{ $errors->first('district') }}</span>
</div>

<div class="col-sm-4">
{!! Form::Label('product', 'Search By Product') !!}
<select id="product" name="product[]" onchange="getAMCRecordProductWise('PRODUCT')" multiple="" class="form-control select2bs4" data-placeholder="Select product" style="width: 100%;">

{!!  App\Models\inventory\Purchase_model::ShowProductDropDown(old('product')) !!}
</select>
<span class="text-danger">{{ $errors->first('product') }}</span>
</div>

                                    <div class="col-sm-4">
                                        {!! Form::Label('date', 'Search By Till Date') !!}
                                        <div class="input-group date_picker" id="reservationdate" data-target-input="nearest">
                                            <input type="text" id="till_date" name="till_date" placeholder="DD-MM-YYYY" onchange="getAMCRecordDateWise()" class="form-control dtp" data-target="#till_date"/>
                                           
                                        </div>
                                        <span class="text-danger">{{ $errors->first('till_date') }}</span>
                                    </div>
                                </div>
                                {{ Form::close() }}

                            </div>
                        </div>
                        <div class="card card-primary" id="show_result_div" style="display: none">
                            <div class="card-header">
                                <h3 class="card-title">AMC Report</h3>
                            </div>
                            <div class="card-body">
                                <table id="example1" class="table table-bordered table-striped">
                                    <thead>
                                        <tr><th colspan=10 align=center style='text-align:center;'>AMC Report of : <span id="distt_name">All District and Taluka and High Courts</span></th></tr>
                                        <tr>
                                            <th>#</th>
                                            <th>Purchase Order No</th>
                                            <th>Purchase Date</th>
                                            <th>Product</th>
                                            <th>Company</th>
                                            <th>Model No</th>
                                            <th>Serial No</th>
                                            <th>Warranty</th>
                                            <th>item receiving date</th>
                                            <th>Warranty Status</th>
                                        </tr>
                                    </thead>
                                    <tbody id="results"></tbody>
                                </table>
                            </div>
</div>
</div>

</div>
<input type="button" value="Print" id="print" onclick="printElem('result')" class="btn btn-success btn-flat" /> 
</div>

@endsection