@extends('layouts.admin_default')
@section('title', 'Dst Time After 2022 Table')
@section('page', 'Dst Time After 2022 / List')
@section('content')
<div class="layout-px-spacing">
   <div class="row layout-top-spacing">
      <div class="col-xl-12 col-lg-12 col-sm-12  layout-spacing">
         <div class="widget-content widget-content-area br-6">
            <div id="delete_bd_ms"></div>
             @if(isset($errors) && $errors->any())
             @foreach($errors->all() as $error )
            <div class="alert alert-danger fade in alert-dismissible show" style="margin-bottom: 5px;">
               <button type="button" class="close" data-dismiss="alert" aria-label="Close">
               <span aria-hidden="true" style="font-size:20px">×</span>
               </button>
                {{$error}}
            </div>
            @endforeach
            @endif
            @if(session()->has('message'))
            <div class="alert alert-success fade in alert-dismissible show" style="margin-bottom: 5px;">
               <button type="button" class="close" data-dismiss="alert" aria-label="Close">
               <span aria-hidden="true" style="font-size:20px">×</span>
               </button>
               {{ session()->get('message') }}
            </div>
            @elseif(session()->has('error'))
            <div class="alert alert-danger fade in alert-dismissible show" style="margin-bottom: 5px;">
               <button type="button" class="close" data-dismiss="alert" aria-label="Close">
               <span aria-hidden="true" style="font-size:20px">×</span>
               </button>
               {{ session()->get('error') }}
            </div>
            @endif
            <div class="col-md-12 text-right">
               <a class="btn btn-success mb-2" href="javascript:void();" onclick="csvAddModal();">Import Dst Time</a>
               <a class="btn btn-success mb-2" href="{{ route('export-dst') }}">Export Dst Time</a>
               <a href="javascript:void();" onclick="addModal();" class="btn btn-primary mb-2">Add +</a>
            </div>
            <div class="col-md-12 text-left">
               <div class="" id="#error"></div>
               <div class="multiple-action">
                  <button type="button" onclick="multiple_del()" class="btn btn-danger del">Delete</button>
                  {{-- <button type="button" onclick="multiple_active()" class="btn btn-success active-status">Active</button>
                  <button type="button"  onclick="multiple_deactive()" class="btn btn-danger inactive-status">Inactive</button> --}}
               </div>
               <small>Apply action on checked record.</small>
            </div>

            <div class="mb-4 mt-4">
               <table id="multi-column-ordering" class="table table-hover">
                  <thead>
                     <tr>
                        <th><input type="checkbox" class="new-control-input" id="contact-check-all"></th>
                        <th>Country</th>
                        <th>Start Month</th>
                        <th>Weekday Code</th>
                        <th>Start Hr</th>
                        <th>Start Min</th>
                        <th>Forward Time by hr</th>
                        <th>End Month</th>
                        <!-- <th>Status</th> -->
                        <th>Created Date</th>
                        <th>Action</th>
                     </tr>
                  </thead>
                  <tbody id="tableItem">
                  </tbody>
                  <tfoot>
                     <tr>
                        <th></th>
                       <th>Country</th>
                        <th>Start Month</th>
                        <th>Weekday Code</th>
                        <th>Start Hr</th>
                        <th>Start Min</th>
                        <th>Forward Time by hr</th>
                        <th>End Month</th>
                        <!-- <th>Status</th> -->
                        <th>Created Date</th>
                        <th>Action</th>
                    </tr>
                  </tfoot>
               </table>
            </div>
         </div>
      </div>
   </div>
</div>
<!--end of listing -->
<!-- add modal start -->
<div class="modal fade" id="add_blog_modal">
   <div class="modal-dialog modal-lg">
      <div class="modal-content">
         <form id="zodiacForm" method="post" action="{{route('savedst')}}" enctype="multipart/form-data" novalidate>
            @csrf
            <div class="modal-header">
               <h5 class="modal-title">Add Dst Time After 2022</h5>
               <button type="button" class="close" data-dismiss="modal" aria-label="Close">
               <span aria-hidden="true">&times;</span>
               </button>
            </div>
            <div class="modal-body">
               <div class="row">
                  @php
                $countries = DB::table('all_countries')->whereNull('deleted_at')->get();
                  @endphp
                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">Country*</label>
                        <select name="country" id="role" class="form-control">
                            <option value="">--Select Countries--</option>
                            @foreach ($countries as $country )
                            <option value="{{ $country->country_name }}">{{ $country->country_name }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>

                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_name">Start Month*</label>
                        <input type="number" class="form-control" name="start_month" required id="sign_name">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">start momth day code*</label>
                        <select id="role" name="start_month_code" class="form-control">
                            <option value="">--Select Start month day code--</option>
                            <option value="L">L</option>
                            <option value="F">F</option>
                        </select>
                     </div>
                  </div>


                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_lord">weekday code*</label>
                        <input type="text" class="form-control" name="weekday_code" required id="sign_lord">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_type">start hr*</label>
                        <input type="number" class="form-control" name="start_hr" required id="sign_lord">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_element">start min*</label>
                        <input type="number" class="form-control" name="start_min" required id="sign_lord" >
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="s_degree">Forward Time by hr*</label>
                        <input type="number" class="form-control" name="forward_time" required id="s_degree">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end month*</label>
                        <input type="number" class="form-control" name="end_month" required id="s_degree">
                     </div>
                  </div>
                    <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end momth day code*</label>
                        <select id="role" name="end_month_code" class="form-control">
                            <option value="">--Select end month day code--</option>
                            <option value="L">L</option>
                            <option value="F">F</option>
                        </select>
                     </div>
                  </div>


                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end Weekday code*</label>
                        <input type="text" class="form-control" name="end_week" required id="l_degree">
                     </div>
                  </div>

                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end hr*</label>                                                <input type="number" class="form-control" name="end_hr" required id="l_degree">
                     </div>
                </div>

                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end min*</label>                                                <input type="number" class="form-control" name="end_min" required id="l_degree">
                     </div>
                </div>

                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">Backward time*</label>                                                <input type="number" class="form-control" name="backward_time" required id="l_degree">
                     </div>
                </div>

                </div>
            </div>
            <div class="modal-footer justify-content-between">
               <!-- <button type="button" class="btn btn-primary" data-dismiss="modal">No</button> -->
               <button type="submit" class="btn btn-primary" >Submit</button>
            </div>
         </form>
      </div>
      <!-- /.modal-content -->
   </div>
   <!-- /.modal-dialog -->
</div>
<!-- add modal end -->
<!-- edit modal start -->
<div class="modal fade" id="edit_blog_modal">
   <div class="modal-dialog modal-lg">
      <div class="modal-content">
         <form id="zodiacEditForm" method="post" action="{{route('savedst')}}" enctype="multipart/form-data" novalidate>
            @csrf
            <input type="hidden" name="id" id="id">
            <div class="modal-header">
               <h5 class="modal-title">Edit Dst Time After 2022</h5>
               <button type="button" class="close" data-dismiss="modal" aria-label="Close">
               <span aria-hidden="true">&times;</span>
               </button>
            </div>
            <div class="modal-body">
               <div class="row">
                @php
                $countries = DB::table('all_countries')->whereNull('deleted_at')->get();
                @endphp
                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">Country*</label>
                        <select name="country" id="country" class="form-control">
                            <option value="">--Select Countries--</option>
                            @foreach ($countries as $country )
                            <option value="{{ $country->country_name }}">{{ $country->country_name }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>

                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_name">Start Month*</label>
                        <input type="number" class="form-control" name="start_month" required id="start_month">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">start momth day code*</label>
                        <select id="start_month_code" name="start_month_code" class="form-control">
                            <option value="">--Select Start month day code--</option>
                            <option value="L">L</option>
                            <option value="F">F</option>
                        </select>
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_lord">weekday code*</label>
                        <input type="text" class="form-control" name="weekday_code" required id="weekday_code">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_type">start hr*</label>
                        <input type="number" class="form-control" name="start_hr" required id="start_hr">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="sign_element">start min*</label>
                        <input type="number" class="form-control" name="start_min" required id="start_min" >
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="s_degree">Forward Time by hr*</label>
                        <input type="text" class="form-control" name="forward_time" id="forwardtime" required step="any">
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end month*</label>
                        <input type="number" class="form-control" name="end_month" required id="end_month">
                     </div>
                  </div>
                    <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end momth day code*</label>
                        <select id="end_month_code" name="end_month_code" class="form-control">
                            <option value="">--Select end month day code--</option>
                            <option value="L">L</option>
                            <option value="F">F</option>
                        </select>
                     </div>
                  </div>


                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end Weekday code*</label>
                        <input type="text" class="form-control" name="end_week" required id="end_week">
                     </div>
                  </div>

                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end hr*</label>                                                <input type="number" class="form-control" name="end_hr" required id="end_hr">
                     </div>
                </div>

                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">end min*</label>                                                <input type="number" class="form-control" name="end_min" required id="end_min">
                     </div>
                </div>

                <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group">
                        <label for="l_degree">Backward time*</label>                                                <input type="text" class="form-control" name="backward_time" id="backwardtime" required>
                     </div>
                </div>
               </div>
            </div>
            <div class="modal-footer justify-content-between">
               <!-- <button type="button" class="btn btn-primary" data-dismiss="modal">No</button> -->
               <button type="submit" class="btn btn-primary" >Submit</button>
            </div>
         </form>
      </div>
      <!-- /.modal-content -->
   </div>
   <!-- /.modal-dialog -->
</div>
<!-- edit modal end -->
<!-- view modal start -->
<div class="modal fade" id="view_blog_modal">
   <div class="modal-dialog modal-lg">
      <div class="modal-content">
         <form method="post">
            <div class="modal-header">
               <h5 class="modal-title">Dst Time After 2022 Details</h5>
               <button type="button" class="close" data-dismiss="modal" aria-label="Close">
               <span aria-hidden="true">&times;</span>
               </button>
            </div>
            <div class="modal-body" id="detailContent">
            </div>
            <div class="modal-footer justify-content-between">
               <!-- <button type="button" class="btn btn-primary" data-dismiss="modal">No</button>
                  <button type="button" class="btn btn-danger" onclick="ajax_delete_item();" >Yes, Delete</button> -->
            </div>
         </form>
      </div>
      <!-- /.modal-content -->
   </div>
   <!-- /.modal-dialog -->
</div>
<!-- view modal end -->
<!-- import csv file to add zodiac start -->
<div class="modal fade" id="csv_add_blog_modal">
   <div class="modal-dialog modal-lg">
      <div class="modal-content">
         <form id="addCsvForm" method="post" action="{{route('importDst')}}" enctype="multipart/form-data" novalidate>
            @csrf
            <div class="modal-header">
               <h5 class="modal-title">Import Csv - Dst Time After 2022</h5>
               <button type="button" class="close" data-dismiss="modal" aria-label="Close">
               <span aria-hidden="true">&times;</span>
               </button>
            </div>
            <div class="modal-body">
               <div class="row">
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <div class="form-group mb-4">
                        <div class="custom-file text-left">
                           <input type="file" name="csv_file" class="custom-file-input" id="csv_file">
                           <label class="custom-file-label" for="csv_file">Choose file</label>
                        </div>
                     </div>
                  </div>
                  <div class="col-sm-6 col-md-6 col-lg-6 ">
                     <a class="btn btn-success csvSample" href="{{route('sample-file-download-dst')}}">Download Sample</a>
                  </div>
               </div>
            </div>
            <div class="modal-footer justify-content-between">
               <button type="submit" class="btn btn-primary" >Submit</button>
            </div>
         </form>
      </div>
      <!-- /.modal-content -->
   </div>
   <!-- /.modal-dialog -->
</div>
<!-- import csv file to add zodiac end -->
@endsection
@section('footer')
<script type="text/javascript">
   // function destroy(url){
   //   swal({
   //     title: "Are you sure?",
   //     text: "Do you want to delete this Zodiac!",
   //     type: "warning",
   //     showCancelButton: true,
   //     confirmButtonText: "Yes, delete it!",
   //     cancelButtonText: "No, cancel plx!",
   //     closeOnConfirm: false,
   //   }, function(isConfirm) {
   //     if (isConfirm) {
   //       document.location.href = url;
   //     }
   //   });
   // }

</script>
<script type="text/javascript">
   $(document).ready(function(){
     $('#multi-column-ordering').DataTable({
        processing: true,
        serverSide: true,
        stateSave: true,
        ajax: "{{route('getDstDetails')}}",
        columns: [
           { data: 'checkall', orderable: false, searchable: false },
           { data: 'country' },
           { data: 'start_month' },
           { data: 'weekday_code' },
           { data: 'start_hr' },
           { data: 'start_min' },
           { data: 'forward_time_by_hr' },
           { data: 'end_month' },
           // { data: 'status' },
           { data: 'created_at' },
           { data: 'action', orderable: false, searchable: false },
        ],
        order: [[1, 'asc']],
        drawCallback: function (settings) {

           var response = settings.json;
           // $('#totalRecords').text(response.totalRecords);
           // $('#activeRecords').text(response.activeRecords);
           // $('#inactiveRecords').text(response.inactiveRecords);
           // $('#deletedRecords').text(response.deletedRecords);
           console.log(response);
           updateIcon()

       },
     });


       /*ajax header setup*/
       $.ajaxSetup({
           headers: {
               'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
           }
       });
   });


   function addModal(){
        $("#add_blog_modal").modal('show');
   }
      function view_item(id){
       // var itemDetails = [];
       // getItemDetails(id);
       // setTimeout(() => {
       //   console.log("Delayed for 1 second.");
       //   console.log(itemDetails);
       // }, "1000");

       let _url = "{{route('getDstDetails')}}";
       let _token = $('meta[name="csrf-token"]').attr('content');
       $.ajax({
           url: _url,
           type: 'POST',
           data: {
               id: id,
               _token: _token
           },
           success: function(response) {
               console.log(response);
               let result = JSON.parse(response);
               if(result.status){
                   var itemDetails = result.data;
                   var d = new Date(itemDetails.created_at);
                   var created_at = d.toDateString() + ', '+d.getUTCHours() +':'+ d.getUTCMinutes()+':'+ d.getUTCSeconds();
                   // var created_at = d.toUTCString();

                   $('#detailContent').html('');
                   $('#detailContent').append('<div class="table-responsive"> <table class="table table-bordered"> <tr> <th>country</th> <td>'+itemDetails.country+'</td><th>Start month</th> <td>'+itemDetails.start_month+'</td></tr><tr><th>start month day code</th> <td>'+itemDetails.start_month_day_code+'</td><th>weekday code</th><td>'+itemDetails.weekday_code+'</td></tr><tr> <th>Start hr</th> <td>'+itemDetails.start_hr+'</td><th>Start min</th> <td>'+itemDetails.start_min+'</td></tr><tr> <th>forward_time_by_hr</th> <td>'+itemDetails.forward_time_by_hr+'</td><th>Created Date</th> <td>'+created_at+'</td></tr></table> </div>');

                   $("#view_blog_modal").modal('show');
               }else{
                   myFaildToast('Something went wrong.');
               }
           }
       });

   }

   function edit_item(id){
       let _url = "{{route('getDstEditDetails')}}";
       let _token = $('meta[name="csrf-token"]').attr('content');
       $.ajax({
           url: _url,
           type: 'POST',
           data: {
            id: id,
             _token: _token
           },
           success: function(response) {
               console.log(response);
               let result = JSON.parse(response);
               if(result.status){
                   // var itemDetails = result.data;
                   console.log(result.data.country);
                   $('#id').val(result.data.id);
                   $('#country').val(result.data.country);
                   $('#start_month').val(result.data.start_month);
                   $('#start_month_code').val(result.data.start_month_day_code)
                   $('#weekday_code').val(result.data.weekday_code);
                   $('#start_hr').val(result.data.start_hr);
                   $('#start_min').val(result.data.start_min);
                   $('#forwardtime').val(result.data.forward_time_by_hr);
                   $('#end_month').val(result.data.end_month);
                   $('#end_month_code').val(result.data.end_month_day_code);
                   $('#end_week').val(result.data.end_weekday_code);
                   $('#end_hr').val(result.data.end_hr);
                   $('#end_min').val(result.data.end_min);
                   $('#backwardtime').val(result.data.backward_time_by_hr);
                   $("#edit_blog_modal").modal('show');
               }else{
                   myFaildToast('Something went wrong.');
               }
           }
       });
   }


</script>
<!-- form validation start -->
<script>
   $( "#zodiacForm" ).validate({
     // rules: {
     //   field: {
     //     required: true,
     //   }
     // }
   });


   $( "#zodiacEditForm" ).validate({
     // rules: {
     //   field: {
     //     required: true,
     //   }
     // }
   });


   $( "#addCsvForm" ).validate({ });



</script>
<!-- form validation end -->
<!-- getting item details start -->
<!-- getting item details end -->
<!-- add csv modal start -->
<!-- getting item details end -->
<!-- add csv modal start -->
<script type="text/javascript">
   function csvAddModal(){
        $("#csv_add_blog_modal").modal('show');
   }
</script>
<script>
   // Add the following code if you want the name of the file appear on select
   $(".custom-file-input").on("change", function() {
     var fileName = $(this).val().split("\\").pop();
     $(this).siblings(".custom-file-label").addClass("selected").html(fileName);
   });
</script>


<!-- check all record start -->
<script type="text/javascript">
   $("#contact-check-all").click(function(){
       $('input:checkbox[name="multicheck[]"]').not(this).prop('checked', this.checked);
   });


   function multiple_del(){
      var multicheck = []
      $("input[name='multicheck[]']:checked").each(function ()
      {
          multicheck.push(parseInt($(this).val()));
      });
      if(multicheck.length > 0){
          Swal.fire({
           title: 'Are you sure?',
           text: "Do you want to delete selected zodiac!",
           icon: 'warning',
           showCancelButton: true,
           confirmButtonColor: '#3085d6',
           cancelButtonColor: '#d33',
           confirmButtonText: 'Yes'
           }).then((result) => {
           if (result.isConfirmed) {
               $.ajax({
                    url: "{{route('dst-multipleDel')}}",
                    method: 'post',
                    data: {ids: multicheck},
                })
                .done(function(obj) {
                    console.log(obj);
                    let result = JSON.parse(obj);
                    if(result.status){
                         mySuccessToast(result.message);
                         setTimeout(() => {
                           $('#contact-check-all').prop('checked', false);
                         }, 500);
                    }else{
                         myFaildToast('Something went wrong.');
                    }
                     $('#multi-column-ordering').DataTable().ajax.reload();
                });
           }else{
               // alert('false');
           }
       })
      }else{
         myFaildToast('Please select a record.');
      }


   }

   function multiple_active(){
      var multicheck = []
      $("input[name='multicheck[]']:checked").each(function ()
      {
          multicheck.push(parseInt($(this).val()));
      });
      if(multicheck.length > 0){
         Swal.fire({
           title: 'Are you sure?',
           text: "Do you want to make active selected zodiac!",
           icon: 'warning',
           showCancelButton: true,
           confirmButtonColor: '#3085d6',
           cancelButtonColor: '#d33',
           confirmButtonText: 'Yes'
           }).then((result) => {
           if (result.isConfirmed) {
                $.ajax({
                    url: "{{route('zodiac-multipleActive')}}",
                    method: 'post',
                    data: {ids: multicheck},
                })
                .done(function(obj) {
                    console.log(obj);
                    let result = JSON.parse(obj);
                    if(result.status){
                         mySuccessToast(result.message);
                         setTimeout(() => {
                           $('#contact-check-all').prop('checked', false);
                         }, 500);

                     }else{
                        myFaildToast('Something went wrong.');
                     }
                     $('#multi-column-ordering').DataTable().ajax.reload();
                });
           }
       })
      }else{
         myFaildToast('Please select a record.');
      }
   }

   function multiple_deactive(){
      var multicheck = []
      $("input[name='multicheck[]']:checked").each(function ()
      {
          multicheck.push(parseInt($(this).val()));
      });
      if(multicheck.length > 0){
         Swal.fire({
           title: 'Are you sure?',
           text: "Do you want to make deactive selected records!",
           icon: 'warning',
           showCancelButton: true,
           confirmButtonColor: '#3085d6',
           cancelButtonColor: '#d33',
           confirmButtonText: 'Yes'
           }).then((result) => {
           if (result.isConfirmed) {
              $.ajax({
                 url: "{{route('zodiac-multipleDeactive')}}",
                 method: 'post',
                 data: {ids: multicheck},
              })
              .done(function(obj) {
                  console.log(obj);
                  let result = JSON.parse(obj);
                  if(result.status){
                      mySuccessToast(result.message);
                      setTimeout(() => {
                        $('#contact-check-all').prop('checked', false);
                      }, 500);
                  }else{
                       myFaildToast('Something went wrong.');
                  }
                  $('#multi-column-ordering').DataTable().ajax.reload();
              });
           }
       })
      }else{
         myFaildToast('Please select a record.');
      }
   }
</script>
<!-- footer script if required -->
@endsection