@extends('layouts.frontend')
@section('js_after')
    <script>

    jQuery(document).on('click', '#schemelist', function(event) {

        var ischecked= jQuery(this).is(':checked');
         if(ischecked){
             jQuery(".schemecode-list-data").prop( "checked", true );
             jQuery('#schemelist').prop( "checked", true );
         }else{
             jQuery(".schemecode-list-data").prop( "checked", false );
             jQuery('#schemelist').prop( "checked", false );
         }
        //alert("success");
    });

        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>
                                     @php
                                        $duration = json_decode($list->duration);
                                        $schemecode = json_decode($list->schemecode);          
                                     @endphp

                                    <form action="{{route('frontend.categorywiselistOutputUpdate',['id'=> $list->id])}}" id="categorywiselistOutputUpdate" method="post" style="width: 100%;">
                                        @csrf
                                    <div class="col-md-12">

                                        <div class="col-lg-6">
                                            <div class="form-group">
                                           <!--  <label>Title</label> -->
                                                <input type="text" class="form-control" name="title" value="{{$list->title}}">
                                            </div>
                                        </div>

                                        <div class="table-responsive mt-3" id="suggested-scheme-details">
                                                <table class="table table-bordered suggested-scheme-details" id="suggested-scheme-details-table">
                                                    <tr>
                                                        <th style="width: 30%;"><input type="checkbox" id="schemelist" class="rcheck_a" value="schemelist" checked></th>
                                                            <th style="width: 10%;"><input type="checkbox" class="rcheck_a" name="duration[]" value="AUM" @if(in_array("AUM", $duration)) checked @endif></th>
                                                            <th>
                                                            <input class="rcheck_a" type="checkbox" name="duration[]" value="1WEEKRET" @if(in_array("1WEEKRET", $duration)) checked @endif> 
                                                            </th>
                                                            <th><input class="rcheck_a" type="checkbox" name="duration[]" value="1MONTHRET" @if(in_array("1MONTHRET", $duration)) checked @endif> </th>
                                                            <th><input class="rcheck_a" type="checkbox" name="duration[]" value="3MONTHRET" @if(in_array("3MONTHRET", $duration)) checked @endif> </th>
                                                            <th><input class="rcheck_a" type="checkbox" name="duration[]" value="6MONTHRET" @if(in_array("6MONTHRET", $duration)) checked @endif> </th>
                                                            <th><input class="rcheck_a" type="checkbox" name="duration[]" value="1YEARRET" @if(in_array("1YEARRET", $duration)) checked @endif> </th>
                                                            <th><input class="rcheck_a" type="checkbox" name="duration[]" value="3YEARRET" @if(in_array("3YEARRET", $duration)) checked @endif> </th>
                                                            <th><input class="rcheck_a" type="checkbox" name="duration[]" value="5YEARRET" @if(in_array("5YEARRET", $duration)) checked @endif> </th>
                                                            <th><input class="rcheck_a" type="checkbox" name="duration[]" value="10YEARRET" @if(in_array("10YEARRET", $duration)) checked @endif> </th>
                                                    </tr>
                                                </table>
                                                <table id="myShowReportTable" class="table table-bordered suggested-scheme-details">
                                                    <thead>
                                                        <tr>
                                                            <th style="width: 30%;">Scheme Name</th><th style="width: 10%;">AUM <br>(₹ Cr)</th>
                                                            <th> 7 Day<br>(%) </th>
                                                            <th> 1 mth<br>(%) </th>
                                                            <th> 3 mth<br>(%) </th>
                                                            <th> 6 mth<br>(%) </th>
                                                            <th> 1 Yr<br>(%) </th>
                                                            <th> 3 Yr<br>(%) </th>
                                                            <th> 5 Yr<br>(%) </th>
                                                            <th> 10 Yr<br>(%) </th>
                                                        </tr>
                                                    </thead>
                                                    <tbody id="scheme-info">
                                                   
                                                    @foreach($schemeData_main as $schemedetails_main)
                                                                                                            <tr>
                                                        <td align="left"><input type="checkbox" class="schemecode-list-data" name="schemecode[]" value="{{$schemedetails_main_arr['Schemecode']}}" @if(in_array($schemedetails_main_arr['Schemecode'], $schemecode)) checked @endif> &nbsp;&nbsp;<strong>{{$schemedetails_main_arr['S_NAME']}}</strong></td>
                                                        @php
                                                        if($schemedetails_main_arr['AUM']=="")
                                                        {
                                                            $AUM='0.00';
                                                        }else{
                                                            $AUM=$schemedetails_main_arr['AUM'];
                                                        }
                                                        @endphp
                                                        <td>{{custome_money_format($AUM)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['1WEEKRET']=="")
                                                        {
                                                            $PERCHANGE='0.00';
                                                        }else{
                                                            $PERCHANGE=$schemedetails_main_arr['1WEEKRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($PERCHANGE,2)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['1MONTHRET']=="")
                                                        {
                                                            $MONTHRET1='0.00';
                                                        }else{
                                                            $MONTHRET1=$schemedetails_main_arr['1MONTHRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($MONTHRET1,2)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['3MONTHRET']=="")
                                                        {
                                                            $MONTHRET3='0.00';
                                                        }else{
                                                            $MONTHRET3=$schemedetails_main_arr['3MONTHRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($MONTHRET3,2)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['6MONTHRET']=="")
                                                        {
                                                            $MONTHRET6='0.00';
                                                        }else{
                                                            $MONTHRET6=$schemedetails_main_arr['6MONTHRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($MONTHRET6,2)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['1YEARRET']=="")
                                                        {
                                                            $YEARRET1='0.00';
                                                        }else{
                                                            $YEARRET1=$schemedetails_main_arr['1YEARRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($YEARRET1,2)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['3YEARRET']=="")
                                                        {
                                                            $YEARRET3='0.00';
                                                        }else{
                                                            $YEARRET3=$schemedetails_main_arr['3YEARRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($YEARRET3,2)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['5YEARRET']=="")
                                                        {
                                                            $YEARRET5='0.00';
                                                        }else{
                                                            $YEARRET5=$schemedetails_main_arr['5YEARRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($YEARRET5,2)}}</td>
                                                        @php
                                                        if($schemedetails_main_arr['10YEARRET']=="")
                                                        {
                                                            $YEARRET10='0.00';
                                                        }else{
                                                            $YEARRET10=$schemedetails_main_arr['10YEARRET'];
                                                        }
                                                        @endphp
                                                        <td>{{number_format($YEARRET10,2)}}</td>
                                                        </tr>
                                                    @endforeach
                                                    </tbody>
                                            </table>
                                            </div>

                                        <!-- <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>
                                    <input type="submit" value="Update" class="btn btn-primary btn-round" name="update">
                                    </form>
                                    <!-- <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> -->
                                    

                                </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

@section('js_after')
<script>
    
</script>
@endsection