@extends('layouts.admin_default')
@section('title', 'Zodiac Table')
@section('page', 'Zodiac Table / 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
                    {{-- ================================= my design code ================================== --}}
                    <div class="content pt-0">
                        <div class="card mt-4">
                            <div class="card-header">
                                <h5 class="card-title">Dashboard / Yoni</h5>
                            </div>

                            {{-- ================================= / my design code ================================== --}}
                            <div class="col-md-12 text-right">
                                <a class="btn btn-success mb-2" href="javascript:void();" onclick="csvAddModal();">Import
                                    Zodiac</a>
                                <a class="btn btn-success mb-2" href="{{ route('export-zodiac') }}">Export Zodiac</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>Sign Number</th>
                                            <th>Sign Name</th>
                                            <th>Sign Lord</th>
                                            <th>Sign Type</th>
                                            <th>Sign Element</th>
                                            <th>Starting Degree</th>
                                            <th>Last Degree</th>
                                            <th>Status</th>
                                            <th>Created Date</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody id="tableItem">
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th></th>
                                            <th>Sign Number</th>
                                            <th>Sign Name</th>
                                            <th>Sign Lord</th>
                                            <th>Sign Type</th>
                                            <th>Sign Element</th>
                                            <th>Starting Degree</th>
                                            <th>Last Degree</th>
                                            <th>Status</th>
                                            <th>Created Date</th>
                                            <th>Action</th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                            {{-- ================================= my design code ================================== --}}

                        </div>
                    </div>
                    {{-- ================================= /my design code ================================== --}}
                </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('saveZodiac') }}" enctype="multipart/form-data"
                    novalidate>
                    @csrf
                    <div class="modal-header">
                        <h5 class="modal-title">Add Zodiac</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">
                                    <label for="sign_number">Sign Number*</label>
                                    <input type="number" class="form-control" name="sign_number" required id="sign_number">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="sign_name">Sign Name*</label>
                                    <input type="text" class="form-control" name="sign_name" required id="sign_name">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="sign_lord">Sign Lord*</label>
                                    <input type="text" class="form-control" name="sign_lord" 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">Sign Type*</label>
                                    <input type="text" class="form-control" name="sign_type" required id="sign_type">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="sign_element">Sign Element*</label>
                                    <input type="text" class="form-control" name="sign_element" required
                                        id="sign_element">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="s_degree">Starting Degree*</label>
                                    <input type="number" class="form-control" name="s_degree" 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">Last Degree*</label>
                                    <input type="number" class="form-control" name="l_degree" 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('saveZodiac') }}"
                    enctype="multipart/form-data" novalidate>
                    @csrf
                    <input type="hidden" name="id" id="id">
                    <div class="modal-header">
                        <h5 class="modal-title">Edit Zodiac</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">
                                    <label for="sign_number">Sign Number*</label>
                                    <input type="number" class="form-control" name="sign_number" required
                                        id="sign_number1">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="sign_name">Sign Name*</label>
                                    <input type="text" class="form-control" name="sign_name" required
                                        id="sign_name1">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="sign_lord">Sign Lord*</label>
                                    <input type="text" class="form-control" name="sign_lord" required
                                        id="sign_lord1">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="sign_type">Sign Type*</label>
                                    <input type="text" class="form-control" name="sign_type" required
                                        id="sign_type1">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="sign_element">Sign Element*</label>
                                    <input type="text" class="form-control" name="sign_element" required
                                        id="sign_element1">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="s_degree">Starting Degree*</label>
                                    <input type="number" class="form-control" name="s_degree" required id="s_degree1">
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6 col-lg-6 ">
                                <div class="form-group">
                                    <label for="l_degree">Last Degree*</label>
                                    <input type="number" class="form-control" name="l_degree" required id="l_degree1">
                                </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">Zodiac 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('importZodiac') }}" enctype="multipart/form-data"
                    novalidate>
                    @csrf
                    <div class="modal-header">
                        <h5 class="modal-title">Import Csv - Zodiac</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-zodiac') }}">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('getZodiacList') }}",
                columns: [{
                        data: 'checkall',
                        orderable: false,
                        searchable: false
                    },
                    {
                        data: 'sign_number'
                    },
                    {
                        data: 'sign_name'
                    },
                    {
                        data: 'sign_lord'
                    },
                    {
                        data: 'sign_type'
                    },
                    {
                        data: 'sign_element'
                    },
                    {
                        data: 's_degree'
                    },
                    {
                        data: 'l_degree'
                    },
                    {
                        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('getZodiacDetails') }}";
            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;
                        if (itemDetails.status == 1) {
                            var status = 'Active';
                        } else {
                            var status = 'In-active';
                        }

                        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>Sign Number</th> <td>' +
                            itemDetails.sign_number + '</td><th>Sign Name</th> <td>' + itemDetails
                            .sign_name + '</td></tr><tr> <th>Sign Lord</th> <td>' + itemDetails.sign_lord +
                            '</td><th>Sign Type</th> <td>' + itemDetails.sign_type +
                            '</td></tr><tr> <th>Sign Element</th> <td>' + itemDetails.sign_element +
                            '</td><th>Starting Degree</th> <td>' + itemDetails.s_degree +
                            '</td></tr><tr> <th>Last Degree</th> <td>' + itemDetails.l_degree +
                            '</td><th>Status</th> <td>' + status +
                            '</td></tr><tr> <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('getZodiacDetails') }}";
            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.sign_name);
                        $('#id').val(result.data.id);
                        $('#sign_number1').val(result.data.sign_number);
                        $('#sign_name1').val(result.data.sign_name);
                        $('#sign_lord1').val(result.data.sign_lord);
                        $('#sign_type1').val(result.data.sign_type);
                        $('#sign_element1').val(result.data.sign_element);
                        $('#s_degree1').val(result.data.s_degree);
                        $('#l_degree1').val(result.data.l_degree);
                        $("#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 -->
    <script type="text/javascript">
        function getItemDetails(id) {
            let _url = "{{ route('getZodiacDetails') }}";
            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) {
                        itemDetails = result.data; // used in view item
                    } else {
                        myFaildToast('Something went wrong.');
                    }
                }
            });
        }
    </script>
    <!-- getting item details end -->
    <!-- add csv modal start -->
    <script type="text/javascript">
        function csvAddModal() {
            $("#csv_add_blog_modal").modal('show');
        }
    </script>
    <!-- add csv modal end -->
    <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('zodiac-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