@extends('layouts.frontend')
@section('js_after')
    <script>
        jQuery(document).ready(function(){
            jQuery('#save_cal_btn').click(function(e){
                e.preventDefault();
                $.ajaxSetup({
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="_token"]').attr('content')
                    }
                });
                var title = jQuery('#save_title').val();
                if(title.trim()==''){
                    jQuery('#save_cal_msg').removeClass('alert-success alert-danger');
                    jQuery('#save_cal_msg').addClass('alert-danger');
                    jQuery('#save_cal_msg').html('Please Enter Desired Download File Name');
                }else{
                    jQuery('#save_cal_msg').removeClass('alert-success alert-danger');
                    jQuery('#save_cal_msg').html('');
                    jQuery('#save_title').val('');
                    jQuery.ajax({
                        url: "{{ route('frontend.mylistOutputSave') }}",
                        method: 'get',
                        data: {
                            title: title
                        },
                        success: function(result){
                            jQuery('#save_cal_msg').removeClass('alert-success alert-danger');
                            jQuery('#save_cal_msg').addClass('alert-success');
                            jQuery('#save_cal_msg').html('Data Successfully Saved');
                            setTimeout(function () {
                                $('#saveOutput').modal('toggle');
                                jQuery('#save_cal_msg').removeClass('alert-success alert-danger');
                                jQuery('#save_cal_msg').html('');
                            },500);
                        }});
                }

            });
        });
    </script>

<script type="text/javascript">
function exportToExcel(tableID, filename = ''){
    var downloadurl;
    var dataFileType = 'application/vnd.ms-excel';
    var tableSelect = document.getElementById(tableID);
    /*var xx=$("#"+tableID).html();
    alert(xx);*/
    var tableHTMLData = tableSelect.outerHTML.replace(/ /g, '%20');
    
    // Specify file name
    filename = filename?filename+'.xls':'export_excel_data.xls';
    
    // Create download link element
    downloadurl = document.createElement("a");
    
    document.body.appendChild(downloadurl);
    
    if(navigator.msSaveOrOpenBlob){
        var blob = new Blob(['\ufeff', tableHTMLData], {
            type: dataFileType
        });
        navigator.msSaveOrOpenBlob( blob, filename);
    }else{
        // Create a link to the file
        downloadurl.href = 'data:' + dataFileType + ', ' + tableHTMLData;
    
        // Setting the file name
        downloadurl.download = filename;
        
        //triggering the function
        downloadurl.click();
    }
}
</script>

@endsection

@section('content')
    <div class="banner">
        <div class="container">
            <div class="row">
                <div class="col-md-12 text-center">
                    <h2 class="page-title">CALCULATORS CUM CLIENT PROPOSALS</h2>
                </div>
            </div>
        </div>
    </div>
    <section class="main-sec">
        <div class="container">
            <div class="row">
                @include('frontend.calculators.left_sidebar')
                <div class="col-md-12">
                    <div class="row">

                        <div class="col-md-12 mb-3">
                            <div class="stage">
                                <div class="row">
                                    <div class="col-md-12 mt-3">
                                        <a href="{{route('frontend.fundPerformanceCategorywise')}}" class="btn btn-success btn-round bounce-out d-block-sm" title="Go to My Save List" >
                                            Go to Category List
                                        </a>
                                        <a href="{{route('frontend.fundPerformanceMylist')}}" class="btn btn-primary btn-round d-block-sm" style="float: right;">Go to My Custom List</a>
                                        <div class="error-message text-danger ml-5"></div>
                                    </div>
                                </div>
                                <div class="row mb-3 text-center">
                                    <div class="col-md-12 mt-5">
                                        <h4 class="">CATEGORY WISE SCHEME LIST</h4>
                                    </div>
                                    
                                    <div class="col-md-12">
                                        <div class="table-responsive">
                                            @if(isset($list))
                                                @php
                                                    $duration = json_decode($list->duration);                                          
                                                @endphp
                                                

                                                <table id="myShowReportex" class="table table-bordered text-center less-padding">
                                                    <tbody>
                                                        <tr>
                                                            <th rowspan="2" style="vertical-align: middle;">S. No.</th>
                                                            <th rowspan="2" style="vertical-align: middle; text-align: left;">Scheme Name</th>
                                                            <th rowspan="2" style="vertical-align: middle;">AUM (CR)</th>
                                                            <th colspan="9" style="vertical-align: middle; text-align: center">Past Performance</th>
                                                        </tr>
                                                        <tr>
                                                            @if(in_array("1WEEKRET", $duration))
                                                                <th>7 Day</th>
                                                            @endif
                                                            @if(in_array("1MONTHRET", $duration))
                                                                <th>1 Mth</th>
                                                            @endif
                                                            @if(in_array("3MONTHRET", $duration))
                                                                <th>3 Mth</th>
                                                            @endif
                                                            @if(in_array("6MONTHRET", $duration))
                                                                <th>6 Mth</th>
                                                            @endif
                                                            @if(in_array("1YEARRET", $duration))
                                                                <th>1 Yr</th>
                                                            @endif
                                                            @if(in_array("3YEARRET", $duration))
                                                                <th>3 Yr</th>
                                                            @endif
                                                            @if(in_array("5YEARRET", $duration))
                                                                <th>5 Yr</th>
                                                            @endif
                                                            @if(in_array("10YEARRET", $duration))
                                                                <th>10 Yr</th>
                                                            @endif
                                                        </tr>
                                                        @if(isset($schemeData))
                                                            @php 
                                                            $scheme_cnt = 0;
                                                            
                                                            @endphp
                                                            @foreach($schemeData as $schemedetails)
                                                                @php
                                                                $scheme_cnt++;
                                                                $scheme = (array)json_decode($schemedetails->data);
                                                                //$scheme1 = (array)$scheme;
                                                                //echo $scheme['S_NAME'];
                                                                //print_r($scheme);
                                                                @endphp
                                                                <tr>
                                                                    <td>{{$scheme_cnt}}</td>
                                                                    <td style="text-align: left;">{{$scheme['S_NAME']}}</td>
                                                                    <td>{{$scheme['AUM']?number_format((float)$scheme['AUM'], 2, '.', ''):'N/A '}}</td>
                                                                    @if(in_array("1WEEKRET", $duration))
                                                                        <td>{{$scheme['1WEEKRET']?number_format((float)$scheme['1WEEKRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif
                                                                    @if(in_array("1MONTHRET", $duration)) 
                                                                        <td>{{$scheme['1MONTHRET']?number_format((float)$scheme['1MONTHRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif
                                                                    @if(in_array("3MONTHRET", $duration))
                                                                        <td>{{$scheme['3MONTHRET']?number_format((float)$scheme['3MONTHRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif  
                                                                    @if(in_array("6MONTHRET", $duration))
                                                                        <td>{{$scheme['6MONTHRET']?number_format((float)$scheme['6MONTHRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif
                                                                    @if(in_array("1YEARRET", $duration))
                                                                        <td>{{$scheme['1YEARRET']?number_format((float)$scheme['1YEARRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif
                                                                    @if(in_array("3YEARRET", $duration))
                                                                        <td>{{$scheme['3YEARRET']?number_format((float)$scheme['3YEARRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif
                                                                    @if(in_array("5YEARRET", $duration))
                                                                        <td>{{$scheme['5YEARRET']?number_format((float)$scheme['5YEARRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif
                                                                    @if(in_array("10YEARRET", $duration))
                                                                        <td>{{$scheme['10YEARRET']?number_format((float)$scheme['10YEARRET'], 2, '.', '').'%':'N/A '}}</td>
                                                                    @endif
                                                                </tr>

                                                            @endforeach
                                                        @endif

                                                    </tbody>
                                                </table>
                                                <p style="text-align: left; margin-top: 20px;">
                                                    *Returns over 1 year are annualized. Returns shown for 1 year and below are absolute. Past performance is a not a guarantee of future returns. Report Date : {{date('d/m/Y')}}. Performance data is as per last published NAV. Source : Accord Fintech.
                                                    <br>*Mutual funds investments are subject to market risk. Please read the offer documents carefully before investing.
                                                </p>
                                            @endif
                                        </div>
                                    </div>
                                    <a href="javascript:history.back()" class="btn btn-primary btn-round" ><i class="fa fa-angle-left"></i> Back </a>
                                    <!-- <button type="button" class="btn btn-primary btn-round save_only" data-toggle="modal" data-target="#myModal">Save</button> -->
                                    <!-- <a id="save_only" href="javascript:void(0)" class="btn btn-primary btn-round save_only" data-toggle="modal" data-target="#saveOutput">Save</a> -->
                                    <a href="{{url('calculators/fund-performance/categorywiselist-save-download')}}/{{$list->id}}" target="_blank"  id="cmd" class="btn btn-primary btn-round ml-2">Download / Print</a>

                                    <a id="excel_download" onclick="exportToExcel('myShowReportex', 'user-data')" href="javascript:void(0)" class="btn btn-primary btn-round">Download Excel</a>

                                </div>



                            </div>

                        </div>

                    </div>
                </div>
            </div>
        </div>
        <div class="btm-shape-prt">
            <img class="img-fluid" src="{{url('/')}}/f/images/shape2.png" alt="" />
        </div>
    </section>

    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <form action="{{route('frontend.categorywiselistOutputSave')}}" method="post" style="width: 100%;">
                @csrf

                    <div class="modal-header">
                        <h5 class="modal-title" >SAVE CATEGORY LIST</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="form-group">
                            <input type="text" class="form-control" id="title" name="title" autocomplete="off" placeholder="Enter List Title">
                        </div>
                        <div id="save_list_msg" class="alert ">

                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="submit" class="btn btn-primary btn-round" id="save_list_btn">Save</button>
                    </div>
                </form>

            </div>
        </div>

    </div>

@endsection