@extends('layouts.admin')

@section('content')

<div class="container-fluid">
    <div class="row">
        <div class="col-md-12">
            @include('admin.buy_packages.top_manue')
        </div>
        <div class="col-md-3">
        </div>
        <div class="col-md-6">
            <div class="card">
                <div class="card-header">
                    <div class="row">
                        <div class="col-md-6">
                            <h5>Buy New Package</h5>
                        </div>
                        <!-- <div class="col-md-6 text-right">
                            <a href="{{ route('buy_packages.index') }}" class="btn btn-secondary btn-sm">Buy Package List</a>
                        </div> -->
                    </div>

                </div>
                
                
                                
                
                
          
          
                                  @foreach ($members as $member)
                
                                     @endforeach
                
                Failed to connect to MySQL: Access denied for user 'fastserver1_db'@'localhost' (using password: YES)                
                
                
                
                
                
                
                
                
                
                
                <div class="card-body">
                    <form method="POST" action="{{ route('buy_packages.store') }}" enctype="multipart/form-data">
                        @csrf

                        <div class="row">
                            <div class="col-md-12">
                                <div class="form-group ">
                                    <label for="packageType" class="col-form-label pt-0">Select Customer</label>
                                    <select id="customer_id" class="select2 form-control mb-3 custom-select" name="customer_id" required>
                                        <option selected="" value="">Select Customer</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}"
                                                @if($member_id != null)
                                                    {{ $member_id == $member->id ? 'selected' : '' }}
                                                @elseif($member->id==old('customer_id'))
                                                
                                                selected
                                                @endif
                                            >
                                            
                                            
                                
                                            
                                            {{ $member->name }}  -{{$member->user_id}}
                                            
                                            
                                               
                                            
                                            </option>
                                            
                                            
                                         
                                            
                                            
                                        @endforeach
                                    </select>
                                </div>
                            </div>






                            <div class="col-md-12">
                                <div class="form-group ">
                                    <label for="packageAmount" class="col-form-label pt-0">Package Amount<span class="text-danger">*</span></label>
                                    <input class="form-control{{ $errors->has('package_amount') ? ' is-invalid' : '' }}" type="number" name="package_amount" id="packageAmount" placeholder="Package Amount" value="{{ old('package_amount') }}">
                                    @if ($errors->has('package_amount'))
                                        <span class="text-danger" role="alert">
                                            <strong>{{ $errors->first('package_amount') }}</strong>
                                        </span>
                                    @endif
                                    <b id="balance" class="d-none text-success">Available Balance : 0</b>
                                    <p id="my_error" class="text-danger" role="alert"></p>
                                </div>

                            </div>

                            <div class="col-md-12">
                                <div class="form-group ">
                                    <label for="reference" class="col-form-label pt-0">Reference<span class="text-danger">*</span></label>
                                    <select id="reference" class="select2 form-control mb-3 custom-select" name="reference" required>
                                        
                                        
                                        
                                        <option selected value='0'>  ()</option>
                                                                                
                                        
                                        
                                           </select>
                                                                            
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="packageType" class="col-form-label pt-0">Package Type<span class="text-danger">*</span></label>
                                    <select class="select2 form-control mb-3 custom-select {{ $errors->has('package_id') ? 'is-invalid' : '' }}" name="package_id" >
                                        <option disabled="" selected="" value="">Select Package Type</option>
                                        {{ create_option("packages","id","package_name",old('package_id')) }}
                                    </select>
                                    @if ($errors->has('package_id'))
                                        <span class="text-danger" role="alert">
                                            <strong>{{ $errors->first('package_id') }}</strong>
                                        </span>
                                    @endif
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="packageType" class="col-form-label pt-0">Class Name<span class="text-danger">*</span></label>
                                    <select class="select2 form-control mb-3 custom-select {{ $errors->has('class_name') ? 'is-invalid' : '' }}" name="class_name" >
                                        <option disabled="" selected="" value="">Select Class</option>
                                        {{ create_option("classes","value","name",old('class_name')) }}
                                    </select>
                                    @if ($errors->has('class_name'))
                                        <span class="text-danger" role="alert">
                                            <strong>{{ $errors->first('class_name') }}</strong>
                                        </span>
                                    @endif
                                </div>
                            </div>


                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="agent" class="col-form-label pt-0">Select Agent</label>
                                    <select class="select2 form-control mb-3 custom-select {{ $errors->has('agent_id') ? 'is-invalid' : '' }}" name="agent_id">
                                        <option selected="" value="">Select Agent</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('agent_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                    @if ($errors->has('agent_id'))
                                        <span class="text-danger" role="alert">
                                            <strong>{{ $errors->first('agent_id') }}</strong>
                                        </span>
                                    @endif
                                </div>
                            </div>


                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="SA" class="col-form-label pt-0">Select SA</label>
                                    <select class="select2 form-control mb-3 custom-select" name="sa_id" >
                                        <option selected="" value="">Select SA</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('sa_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="MA" class="col-form-label pt-0">Select MA</label>
                                    <select class="select2 form-control mb-3 custom-select" name="ma_id" >
                                        <option selected="" value="">Select MA</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('customer_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="CA" class="col-form-label pt-0">Select CA</label>
                                    <select class="select2 form-control mb-3 custom-select" name="ca_id" >
                                        <option selected="" value="">Select CA</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('ca_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="PA" class="col-form-label pt-0">Select PA</label>
                                    <select class="select2 form-control mb-3 custom-select" name="pa_id" >
                                        <option selected="" value="">Select PA</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('pa_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="AM" class="col-form-label pt-0">Select JME (Agy Chilo AM) </label>
                                    <select class="select2 form-control mb-3 custom-select" name="am_id" >
                                        <option selected="" value="">Select JME </option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('am_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="ZM" class="col-form-label pt-0">Select ME ( Agy Chilo ZM)</label>
                                    <select class="select2 form-control mb-3 custom-select" name="zm_id" >
                                        <option selected="" value="">Select ME </option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('zm_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>












                                 <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="Chairman" class="col-form-label pt-0">SME (New Working)</label>
                                    <select class="select2 form-control mb-3 custom-select" name="sme_id" >
                                        <option selected="" value="">Select SME </option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('chairman_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                              





               <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="Chairman" class="col-form-label pt-0">AMM (New Working)</label>
                                    <select class="select2 form-control mb-3 custom-select" name="amm_id" >
                                        <option selected="" value="">Select AMM </option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('chairman_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                              













                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="GM" class="col-form-label pt-0">Select MM</label>
                                    <select class="select2 form-control mb-3 custom-select" name="mm_id" >
                                        <option selected="" value="">Select MM</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('mm_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>










          <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="Chairman" class="col-form-label pt-0">DGM (New Working)</label>
                                    <select class="select2 form-control mb-3 custom-select" name="dgm_id" >
                                        <option selected="" value="">Select DGM </option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('chairman_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                              














                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="MM" class="col-form-label pt-0">Select GM</label>
                                    <select class="select2 form-control mb-3 custom-select" name="gm_id" >
                                        <option selected="" value="">Select GM</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('gm_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="MM" class="col-form-label pt-0">Select CEO</label>
                                    <select class="select2 form-control mb-3 custom-select" name="ceo_id" >
                                        <option selected="" value="">Select CEO</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('ceo_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="PD" class="col-form-label pt-0">Select PD</label>
                                    <select class="select2 form-control mb-3 custom-select" name="pd_id" >
                                        <option selected="" value="">Select PD</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('pd_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="Director" class="col-form-label pt-0">Select Director</label>
                                    <select class="select2 form-control mb-3 custom-select" name="director_id" >
                                        <option selected="" value="">Select Director</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('director_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="MD" class="col-form-label pt-0">Select MD</label>
                                    <select class="select2 form-control mb-3 custom-select" name="md_id" >
                                        <option selected="" value="">Select MD</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('md_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group ">
                                    <label for="Chairman" class="col-form-label pt-0">Select Chairman</label>
                                    <select class="select2 form-control mb-3 custom-select" name="chairman_id" >
                                        <option selected="" value="">Select Chairman</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" @if($member->id==old('chairman_id')) selected @endif>{{ $member->name }}-{{$member->user_id}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                    
                            
                            
                            
                            
                            
             
                    
                            
                            

                            <div class="col-md-12">
                                <div class="form-group ">
                                    <div class="form-group">
                                        <label for="comment">Comment</label>
                                        <textarea name="comment" class="form-control" id="comment" rows="3"></textarea>
                                      </div>
                                </div>
                            </div>

                            <div class="col-md-12 text-right mt-4">
                                <button type="submit" class="btn btn-dribbble">
                                    <i class="fas fa-save mr-2"></i> Save
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div> <!-- end col -->
    </div><!--end row-->

</div> <!-- container-fluid -->



@push('alljs')
<script src="{{asset('assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>
{{--<script>
    $(document).ready(function () {
        $("#customer_id").on('change', function () {
            var customer_id = $(this).val();
            $.ajax({
                url : "{{ route('admin.user_check_balance') }}",
                type : 'get',
                data : {customer_id:customer_id},

                success:function (res) {
                    $("#balance").removeClass('d-none');
                    $("#balance").text('Balance : '+res);
                }
            });
        });
    })
</script>--}}
<script>
    $(document).ready(function () {
        $("#packageAmount").on('keyup', function () {
            var customer_id = $("#customer_id").val();
            if(customer_id){
                $.ajax({
                    url : "{{ route('admin.user_check_balance') }}",
                    type : 'get',
                    data : {customer_id:customer_id},

                    success:function (res) {
                        $("#balance").removeClass('d-none');
                        $("#balance").text('Available Balance : '+res);
                        var packageAmount = $("#packageAmount").val();
                        if(parseInt(res) < parseInt(packageAmount)){
                            $("#my_error").text('Sorry, this customer balance is low');
                        }else{
                            $("#my_error").text('');
                        }
                    }
                });
            }else{
                toastr.error('Please select a customer')
            }
        });
    })
</script>
@endpush
@endsection