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

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>






<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/>

 <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')
    }
});



 $('#data-table-default').DataTable({
    responsive: true
  });

  </script>
  
  
   <script type="text/javascript">

                function getChequeDetails(values) {

                    $.ajax({
                        type: "POST",
                        dataType: 'JSON',
                        url: "{{ url('budget/getChequeDetails') }}",
                        data: {'cheque_no': values},
                        beforeSend: function (request) {
                            return request.setRequestHeader('X-CSRF-Token', $("meta[name='csrf-token']").attr('content'));
                        },
                        success: function (data) {
                            var html = '';
                            $.each(data, function (key, value) {

                                html += '<tr data-widget="expandable-table" aria-expanded="false">';
                                html += '<td>1</td>';
                                html += '<td>100001</td>';
                                html += '<td>500000</td>';
                                html += '<td>1 || 23-02-2022</td>';
                                html += '<td>HP Laptop 15</td>';
                                html += '<td>100000</td>';
                                html += '<td>1500000</td>';
                                html += '<td>1400000</td>';
                                html += '<td>Purchase HP Laptop 15 INCH</td>';
                                html += '</tr>';
                                html += '<tr class="expandable-body">';
                                html += '<td colspan="8"> <p style="display: none;">Purchase HP Laptop 15 INCH  </p>';

                                html += '</td></tr>';
                            });
                            $('table tbody').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) {
                                    $(document).find('[name=' + field_name + ']').after('<span class="text-danger">' + error + '</span>')
                                })

                            }
                        }
                    });

                }
            </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       
     
                                
                          
{{ Form::open(array('name'=>'budgetReportForm','url' => 'budget/report', 'class'=>'form-horizontal' ,'method' => 'POST')) }}
<div class="card mb-3" id="google_translate_element">
<div class="card-header bg-dark ">Search Budget Details Form</div>
<div class="card-body">
<div class="row mb-3">                            


						    <div class="col-md-6 mb-3">
                                  
									<b> {!! Form::Label('Cheque / Bank Ref No.', 'Cheque / Bank Ref No.') !!}</b>
                                  
                                        <select id="cheque_no" name="cheque_no" class="form-select">
                                            <option value="">Select Cheque / Bank Ref No.</option>
                                            @foreach($cheque_list as $lists)
                                            <option value="{{$lists->cheque_no}}" {{ ( $lists->cheque_no == Request::input('cheque_no')) ? 'selected' : '' }} >{{$lists->cheque_no}}</option>
                                            @endforeach
                                        </select>
                                        <span class="text-danger">{{ $errors->first('cheque_no') }}</span>
                                   </div>
                                     <div class="col-md-6 mb-3">
									 <b> {!! Form::Label('', '') !!}</b>
                                        <input type="submit" class="btn btn-success form-control" value="Search" style="width:105px;margin-top:14px;"/>
                                    </div>
                               
                          
                         
</div>
</div>
</div> 
{{ Form::close() }}
 
@if (!empty($cheque_details))                        
<div class="card mb-3" id="google_translate_element">
<div class="card-header bg-dark ">Cheque /Bank Ref No. Details</div>
<div class="card-body">
<div class="row mb-3">
                                <table id="example1" class="table table-bordered table-striped">
                                    <thead>
                                        <tr><th colspan="9" style ='text-align:center;'>Cheque /Bank Ref No.--- <b>{{Request::input('cheque_no')}} </b></th></tr>
                                        <tr>
                                            <th>#</th>
                                            <th>Cheque /Bank Ref No</th>
                                            <th>Amount</th>
                                            <th>Sanction Letter No & Date</th>
                                            <th>Purpose</th>
											<th>Purpose Amount</th>
                                            <th>Utilized Amount</th>
                                            <th>Balance Amount</th>
                                            <th>Remark</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($cheque_details as $data)
										{{$balance_amount=$data->budget-$data->p_amount}}	
                                        <tr>
                                            <td>{{ $loop->iteration }}</td>
                                            <td>{{ $data->cheque_no }}</td>
                                            <td>{{ $data->c_amount }}</td>
                                            <td>{{ $data->letter_no }}  ||  {{ \Carbon\Carbon::parse($data->letter_date)->format('d-m-Y') }}</td>
                                            <td>{{ $data->pname }}</td>
											<td>{{ $data->budget}}</td>
                                            <td>{{ $data->p_amount }}</td>
                                            <td>{{ $balance_amount }}</td>
                                            <td>{{ $data->remark }}</td>
                                        </tr>
                                        @endforeach
                                    </tbody>
                                </table>
 </div>
</div>
</div>
					
					
					
   
                       
                        @endif

</div>

          @endsection