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

        
     
            

 




                function assignInput(ele) {
                    if (ele == '2') {
                        $('#neft_form').show();
                        $('#cheque_form').hide();
                    } else {
                        $('#neft_form').hide();
                        $('#cheque_form').show();
                    }
                }

                var payment_method = $('#payment_method').val();
                if (payment_method == 2) {
                    var neft_state_id = $('#neft_state_id').val();
                    if (neft_state_id != '') {
                        getDistrict(neft_state_id, 'NEFT');
                    }
                } else {
                    var state_id = $('#state_id').val();
                    if (state_id != '') {
                        getDistrict(state_id, 'CHEQUE');
                    }
                }


               
                function getPurposeList(budget_head) {

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

                            $("#neft_purpose_of_budget").empty();
                            $("#neft_purpose_of_budget").append('<option>Select Purpose</option>');
                            $.each(data, function (key, value) {
                                $("#neft_purpose_of_budget").append('<option value="' + key + '">' + value + '</option>');
                            });
                        },
                        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);
                                })

                            }
                        }
                    });

                }
                

                    $('#cheque_date').inputmask('DD-MM-YYYY', {'placeholder': 'DD-MM-YYYY'})
                    //$('#datemask').inputmask('dd/mm/yyyy', {'placeholder': 'dd/mm/yyyy'})

                   // $('body').on('click', '#details_modal_show', function (event) 
					function show_data(bid)
					{
                        //event.preventDefault();
                        
						//alert(bid)
                        $.ajax({
                            type: "POST",
                            dataType: 'JSON',
                            url: "{{ url('budget/show_data') }}",
                            data: {'id': bid},
                            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>' + value.ent_date + '</td>';
                                    html += '<td>' + value.invoice_no + '</td>';
                                    html += '<td>' + value.invoice_date + '</td>';
                                    html += '<td>' + value.amt_rel_dt + '</td>';
                                    html += '<td>' + value.remark.substr(0, 20) + '... </td>';
                                    html += '</tr>';
                                    html += '<tr class="expandable-body"><td colspan="6"> <p style="display: none;">' + value.remark + ' </p></td></tr>';

                                });
                                $('#installation_details').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'=>'budgetForm', 'url' => 'budget/add', 'class'=>'form-horizontal' ,'method' => 'POST')) }}
@if( !empty($budget_details->bid)) <input type="hidden" name="budget_id" value="{{ $budget_details->bid ?? '' }}"> @endif

<div class="card mb-3" id="google_translate_element">
<div class="card-header bg-dark ">Add Budget Form</div>


<div class="card-body">
<div class="row mb-3">                                                      
							
							
							
                                                            <div class="col-md-4 mb-3">
                                            {!! Form::Label('Cheque-No', 'Cheque No') !!}
                                            <input type="text" id="cheque_no" name="cheque_no" value="{{ $budget_details->cheque_no ?? old('cheque_no') }}"  class="form-control rounded-0" tabindex="1" placeholder="Cheque No.">
                                            <span class="text-danger">{{ $errors->first('cheque_no') }}</span>
                                        </div>
										
										<div class="col-md-4 mb-3">
                                        
                                            {!! Form::Label('Cheque-Date', 'Cheque Date') !!}
                                            
                                                <input type="text" id="cheque_date" name="cheque_date" value="{{ !empty($budget_details->cheque_date) ? \Carbon\Carbon::parse($budget_details->cheque_date)->format('d-m-Y'):old('cheque_date') }}" placeholder="DD-MM-YYYY" class="form-control dtp" tabindex="2" data-target="#cheque_date"/>
                                               
                                            
                                            <span class="text-danger">{{ $errors->first('cheque_date') }}</span>
                                        </div>
										
										 <div class="col-md-4 mb-3">
                                       
                                            {!! Form::Label('Cheque-Amount', 'Cheque Amount ') !!}
                                            <input type="text" id="cheque_amount" name="cheque_amount"  value="{{ $budget_details->amount ?? old('cheque_amount')}}" tabindex="3" class="form-control rounded-0" placeholder="Cheque Amount">
                                            <span class="text-danger">{{ $errors->first('cheque_amount') }}</span>
                                        </div>
										
                                       <div class="col-md-4 mb-3">
                                            {!! Form::Label('Letter-No', 'Letter No') !!}
                                            <input type="text" id="letter_no" name="letter_no" value="{{ $budget_details->letter_no ?? old('letter_no') }}"  class="form-control rounded-0" tabindex="4"  placeholder="Letter No">
                                            <span class="text-danger">{{ $errors->first('letter_no') }}</span>
                                        </div>

                                  
                                  

                                       <div class="col-md-4 mb-3">
                                            {!! Form::Label('Letter-Date', 'Letter Date') !!}
                                            
                                                <input type="text" id="letter_date" name="letter_date" value="{{ !empty($budget_details->letter_date) ? \Carbon\Carbon::parse($budget_details->letter_date)->format('d-m-Y'):old('letter_date') }}" placeholder="DD-MM-YYYY" class="form-control dtp" tabindex="5" data-target="#letter_date"/>
                                                
                                            <span class="text-danger">{{ $errors->first('letter_date') }}</span>
                                        </div>

                                 
                                  
                                       <div class="col-md-4 mb-3">
                                            {!! Form::Label('Purpose', 'Purpose') !!}
                                            <select id="purpose_id" name="purpose_id" class="form-control select2bs4" tabindex="6" style="width: 100%;">
                                                <option value="">Select Purpose</option>
                                                @foreach($product_list as $lists)
                                                <option value="{{$lists->pname}}" @if(!empty($budget_details->purpose)) {{  $budget_details->purpose == $lists->pname ? 'selected="selected"' : ''}} @else if {{  old('purpose_id') == $lists->pname ? 'selected="selected"' : ''}} @endif>{{$lists->pname}}</option>
                                                @endforeach
                                            </select>
                                            <span class="text-danger">{{ $errors->first('purpose_id') }}</span>
                                        </div>
                                    
                                   <div class="col-md-4 mb-3">
                                        
                                            {!! Form::Label('Purpose-amt', 'Purpose Amount') !!}
                                            <input type="text" id="purpose_amount" name="purpose_amount"  value="{{ $budget_details->budget ?? old('purpose_amount')}}" tabindex="7" class="form-control rounded-0" placeholder="Purpose Amount">
                                            <span class="text-danger">{{ $errors->first('purpose_amount') }}</span>
                                        </div>
                                       <div class="col-md-4 mb-3">
                                            {!! Form::Label('Installation-Date', 'Installation Date') !!}
                                            
                                                <input type="text" id="installation_date" name="installation_date" value="{{ !empty($budget_details->ent_date) ? \Carbon\Carbon::parse($budget_details->ent_date)->format('d-m-Y'):old('installation_date') }}" placeholder="DD-MM-YYYY" class="form-control dtp" tabindex="10" data-target="#installation_date"/>
                                                
                                           
                                            <span class="text-danger">{{ $errors->first('installation_date') }}</span>
                                        </div>
                                   
                                    <div class="col-md-4 mb-3">
                                        
                                            {!! Form::Label('Invoice-no', 'Invoice No') !!}
                                            <input type="text" id="invoice_no" name="invoice_no"  value="{{ $budget_details->invoice_no ?? old('invoice_no')}}" tabindex="8" class="form-control rounded-0" placeholder="Invoice No">
                                            <span class="text-danger">{{ $errors->first('invoice_no') }}</span>
                                        </div>
										
										<div class="col-md-4 mb-3">
                                       
                                            {!! Form::Label('Invoice-date', 'Invoice Date') !!}
                                          
                                                <input type="text" id="invoice_date" name="invoice_date"  value="{{ !empty($budget_details->invoice_date) ? \Carbon\Carbon::parse($budget_details->invoice_date)->format('d-m-Y'):old('invoice_date') }}" placeholder="DD-MM-YYYY" class="form-control dtp" tabindex="9" data-target="#invoice_date"/>
                                      
                                            <span class="text-danger">{{ $errors->first('invoice_date') }}</span>
                                        </div>
                                        <div class="col-md-4 mb-3">
                                            {!! Form::Label('Amount-Released-Date', 'Amount Released Date') !!}
                                           
                                                <input type="text" id="amt_released_date" name="amt_released_date" value="{{ !empty($budget_details->amt_rel_dt) ? \Carbon\Carbon::parse($budget_details->amt_rel_dt)->format('d-m-Y'):old('amt_released_date') }}" placeholder="DD-MM-YYYY" class="form-control dtp" tabindex="11" data-target="#amt_released_date"/>
                                               
                                            <span class="text-danger">{{ $errors->first('amt_released_date') }}</span>
                                        </div>
                                 
                                    
                                       <div class="col-md-4 mb-3">
                                            {!! Form::Label('remark', 'remark') !!}
                                            <input type="text" id="remark" name="remark"  value="{{ $budget_details->remark ?? old('remark')}}" tabindex="12" class="form-control rounded-0" placeholder="Remark..">
                                            <span class="text-danger">{{ $errors->first('remark') }}</span>
                                        </div>
                                    
                               
                           
                           <div class="col-md-4 mb-3">
                                <button type="submit" id="save_eng_data" class="btn btn-success btn-flat save_eng_details" tabindex="13"><span id="save_eng_details">SAVE</span> </button>
                                <a class="btn btn-info btn-flat" href="{{ url('budget/add') }}">CANCEL</a>
                            </div>
                           
</div>
</div>
</div> 
 {{ Form::close() }}
 
<div class="card mb-3" id="google_translate_element">
<div class="card-header bg-dark ">Vendor Details</div>
<div class="card-body">
<div class="row mb-3">
                                <table id="example1" class="table table-bordered table-striped">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Cheque /Bank Ref No Details</th>
                                           
                                           
                                            <th>Sanction Letter No / Date</th>
                                            <th>Cheque Amount</th>
                                            <th>Purpose</th>									
                                            <th>Purpose Amount</th>
											<th>Remark</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                        $total_amount =0;
                                        @endphp

                                        @foreach ($results as $data)


                                        @php
                                        $total_amount += is_numeric($data->amount);

                                        @endphp
                                        <tr>
                                            <td>{{ $loop->iteration }}</td>
                                            <td>
                                                @if(!empty($data->cheque_no)) Cheque / Bank Ref. No. : <a data-bs-toggle="modal" id="details_modal_show"  href="#details_modal" data-id="{{ $data->bid }}" onclick="show_data({{$data->bid}});">{{ $data->cheque_no }} </a><br>@endif
                                                @if(!empty($data->cheque_date)) Cheque / Transfer Date: {{ (!empty($data->cheque_date)) ? Carbon\Carbon::parse($data->cheque_date)->format('d-m-Y'):'NA'}}@endif
                                            </td>
                                         
                                           
                                            <td>{{ $data->letter_no}} <br> {{ Carbon\Carbon::parse($data->letter_date)->format('d-m-Y')}}</td>
											<td>{{ $data->amount }}</td>
											<td>{{ $data->pname }}</td>
											<td>{{ $data->budget }}</td>											
                                            <td>{{ $data->remark}}</td>
                                            
                                            
                                            
                                            <td><a href="{{ url('/budget/edit', $data->bid) }}" ><span class="badge bg-info"><i class="nav-icon fas fa-edit"></i></span> </a>
                                                <a href="{{ route('budget.delete_budget', ['id' => $data->bid]) }}" onclick="return confirm('You want to delete this records ?')"><span class="badge bg-danger"><i class="nav-icon fas fa-trash"></i></span></a>
                                              
                                            </td>
                                        </tr>
                                        @endforeach
                                    </tbody>

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





         <div class="modal fade" id="details_modal">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h4 class="modal-title">Installation Details</h4>
                           
                        </div>
                        <div class="modal-body">
                            <div class="card-body">
                                <table class="table table-bordered table-hover">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Installation Date</th>
                                            <th>Invoice No</th>
                                            <th>Invoice Date</th>
                                            <th>Amount Released Date</th>
                                            <th>Reason</th>
                                        </tr>
                                    </thead>
                                    <tbody id="installation_details"></tbody>
                                </table>
                            </div>
                        </div>
                        <div class="modal-footer">
                            
							 <button type="button" class="btn btn-default text-right" data-bs-dismiss="modal" aria-hidden="true">Close</button>
                        </div>
                    </div>
                </div>
            </div>

@endsection