@extends('layouts.frontend')
@section('css_after')
    <link rel="stylesheet" href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css">
@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="text-center">
                                    <button class="btn btn-success btn-round create-list-btn d-block-sm" >
                                        <i class="fa fa-plus" aria-hidden="true"></i> Create New Category List
                                    </button>
                                     <a href="{{route('frontend.fundPerformanceMylist')}}" class="btn btn-primary btn-round d-block-sm">Go to My Custom List</a>
                                    @if(isset($instruction))
                                        <a class="btn btn-info btn-round d-block-sm" href="javascript:void(0)" data-toggle="modal" data-target="#myCategorywiseInstruction">Instructions</a>
                                @endif
                                </div>
                                
                                {{--<a href="#categorywiselist" class="btn btn-primary mb-3" title="" style="float: right;">
                                    Go to Category List
                                </a>--}}
                                <div class="row mb-3 text-center create-list-container" style="display: none">
                                    <div class="col-md-12">
                                        <h4 class="mt-5">CREATE CATEGORY LIST</h4>
                                    </div>

                                    <form action="{{route('frontend.fundPerformanceCategorywiselistOutput')}}" id="fundPerformanceCategorywiselistOutput" method="post" style="width: 100%;">
                                        @csrf

                                        <div class="col-md-12">
                                            <div class="table-responsive">
                                                <table class="table table-bordered">
                                                    <tbody>
                                                    <tr>
                                                        <td style="width: 10%;">Direct&nbsp;/&nbsp;Regular</td>
                                                        <td style="width: 15%;">Asset&nbsp;Type</td>
                                                        <td style="width: 12%;">Category</td>
                                                        <td style="width: 12%;">Option</td>
                                                    </tr>
                                                    <tr>
                                                        <td>
                                                            <select class="form-control" name="option" id="option">
                                                                <option value="regular"> Regular </option>
                                                                <option value="direct"> Direct </option>
                                                            </select>
                                                        </td>
                                                        <td>
                                                        <select class="form-control" name="asset" id="asset" onchange="getCategory()">

                                                            <option value="">All</option>
                                                            @foreach($assetTypes->Table as $assetType)
                                                                <option value="{{$assetType->asset_code}}">{{$assetType->asset_type}}</option>
                                                            @endforeach

                                                        </select>
                                                        </td>
                                                        <td>
                                                                                                                        <input type="hidden" id="fund" value="">
                                                            <select class="form-control" name="category" id="category" onchange="GetSchemeDirregcategory()">
                                                                <option value="">All</option>
                                                                @foreach($categories->Table as $category)
                                                                    <option value="{{$category->CLASSCODE}}">{{$category->CLASSNAME}}</option>
                                                                @endforeach

                                                            </select>
                                                        </td>

                                                        <td>
                                                            <select class="form-control" name="type" id="type" onchange="GetSchemeDirregcategory()">
                                                                <option value="growth">Growth</option>
                                                                <option value="dividend">Dividend</option>
                                                            </select>
                                                        </td>
                                                    </tr>
                                                    </tbody>
                                                </table>
                                                
                                                <div id="loadingmessage">Loading...</div>
                                                
                                            </div>
                                        </div>
                                    
                                        <div class="col-md-12">
                                            
                                            <div class="table-responsive mt-3" id="suggested-scheme-details">
                                                
                                            </div>
                                            
                                        </div>
                                        <p></p>
                                        <div class="col-md-12 mb-3 text-center">
                                            <input type="hidden" name="category_name" id="category_name">
                                            <a href="javascript:void(0)" class="btn btn-primary btn-round" id="refresh-report">Refresh Report</a>
                                            <button class="btn btn-primary btn-round" type="submit" id="show-report">Publish Report</button>
                                            <!-- <button class="btn btn-primary btn-round" id="refresh">Refresh</button> -->
                                            <!-- <button class="btn btn-primary btn-round" id="save">Save</button>
                                            <button class="btn btn-primary btn-round" id="download-or-print">Download / Print</button> -->
                                        </div>
                                    </form>
                                </div>

                                <div class="col-md-12 text-center" id="categorywiselist">
                                    <h4 class="mt-3">CATEGORY WISE LIST</h4>
                                    @if ($message = Session::get('success'))
                                    <div class="alert alert-success alert-block">
                                        <button type="button" class="close" data-dismiss="alert">×</button>	
                                            <strong>{{ $message }}</strong>
                                    </div>
                                    @endif

                                    @if ($message = Session::get('error'))
                                    <div class="alert alert-danger alert-block">
                                        <button type="button" class="close" data-dismiss="alert">×</button>	
                                            <strong>{{ $message }}</strong>
                                    </div>
                                    @endif
                                </div>
                                <div class="table-responsive">
                                    <table class="table table-bordered text-center">
                                        <thead>
                                        <tr>
                                            <th scope="col" style="width: 25%;">DATE</th>
                                            <th scope="col" style="width: 40%; text-align: left;">CATEGORY LIST NAME</th>
                                            <th scope="col" style="width: 35%;">ACTION</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @if(isset($savelist) && !empty($savelist))
                                            @php $count = 0  @endphp
                                            @foreach($savelist as $list)
                                            @php $count++  @endphp
                                                <tr>
                                                    <td>{{$list->created_at->format('d/m/Y')}}</td>
                                                    <td style="text-align: left;">{{$list->title}}</td>
                                                    <td>
                                                        <a href="{{url('calculators/fund-performance/categorywiselist-save-show')}}/{{$list->id}}" class="btn btn-success btn-sm" title="View">
                                                            <i class="fas fa-eye"></i>
                                                        </a>
                                                        <a href="{{url('calculators/fund-performance/categorywiselist-save-download')}}/{{$list->id}}" class="btn btn-primary btn-sm" title="Download">
                                                            <i class="fas fa-download"></i>
                                                        </a>
                                                        <a href="{{url('calculators/fund-performance/categorywiselist-save-delete')}}/{{$list->id}}" class="btn btn-danger btn-sm" title="Delete">
                                                            <i class="fas fa-trash-alt"></i>
                                                        </a>

                                                    </td>
                                                </tr>
                                            @endforeach
                                            
                                        @endif
                                        @if($count < 1)
                                            <tr>
                                                <td colspan="3">No data found!</td>
                                            </tr>
                                        @endif
                                        </tbody>
                                    </table>
                                </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>
    @if(isset($instruction))
        <div id="myCategorywiseInstruction" class="modal fade bd-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
            <div class="modal-dialog modal-lg">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" >{{$instruction['title']}}</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        {!! $instruction['content'] !!}
                    </div>
                </div>
            </div>
        </div>
    @endif
    <style>
    #loadingmessage{
        display:none;
    }
    </style>

@endsection

@section('js_after')
    <script src="//cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.flash.min.js"></script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.print.min.js"></script>
    
<script>

    $(".create-list-btn").click(function(){
        $(".create-list-container").toggle();
    });

    $('#show-report').hide();
    $('#refresh-report').hide();
    /*$('#refresh').hide();
    $('#save').hide();
    $('#download-or-print').hide();*/

    function GetSchemeDirregcategory(){
        $('#loadingmessage').show();
        $('#show-report').hide();
        $('#refresh-report').hide();
        var category_name = $('#category option:selected').text();
        $.ajax({
            url: "{{ url('calculators/fund-performance/categorywiseschemedetails') }}",
            method: 'get',
            data: {
                asset: $('#asset').val(),
                fund: $('#fund').val(),
                category: $('#category').val(),
                option: $('#option').val(),
                type: $('#type').val()
            },
            success: function (result) {
                //console.log(result);
                

                if(result.length>0) {
                    var trdata = '<table class="table table-bordered suggested-scheme-details" id="suggested-scheme-details-table"><tr>'+
                        '<th style="width: 30%;"> </th><th style="width: 10%;"></th>'+
                        '<th><input type="checkbox" name="duration[]" value="1WEEKRET" checked> </th>'+
                        '<th><input type="checkbox" name="duration[]" value="1MONTHRET" checked> </th>'+
                        '<th><input type="checkbox" name="duration[]" value="3MONTHRET" checked> </th>'+
                        '<th><input type="checkbox" name="duration[]" value="6MONTHRET" checked> </th>'+
                        '<th><input type="checkbox" name="duration[]" value="1YEARRET" checked> </th>'+
                        '<th><input type="checkbox" name="duration[]" value="3YEARRET" checked> </th>'+
                        '<th><input type="checkbox" name="duration[]" value="5YEARRET" checked> </th>'+
                        '<th><input type="checkbox" name="duration[]" value="10YEARRET" checked> </th>'+
                        '</tr></table>';
                    trdata += '<table id="myShowReportTable" class="table table-bordered suggested-scheme-details"><thead><tr>'+
                    '<th style="width: 30%;">Scheme Name</th><th style="width: 10%;">AUM (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>';

                    $.each(result, function (index, value) {
                        var details = JSON.parse(value);

                        trdata += '<tr>'+
                        '<td align="left"><input type="checkbox" name="schemecode[]" value="'+details['Schemecode']+'" checked> &nbsp;&nbsp;<strong>'+details['S_NAME']+'</strong></td>';
                        if(details['AUM'] == ''){
                            AUM = '0.00';
                        }else{
                            AUM = parseInt(details['AUM']/100);
                        }
                        trdata +='<td> '+AUM+'</td>';
                        if(details['1WEEKRET'] == ''){
                            WEEKRET1 = '0.00';
                        }else{
                            WEEKRET1 = parseFloat(details['1WEEKRET']).toFixed(2);
                        }
                        trdata +='<td> '+WEEKRET1+'</td>';
                        if(details['1MONTHRET'] == ''){
                            MONTHRET1 = '0.00';
                        }else{
                            MONTHRET1 = parseFloat(details['1MONTHRET']).toFixed(2);
                        }
                        trdata +='<td> '+MONTHRET1+'</td>';
                        if(details['3MONTHRET'] == ''){
                            MONTHRET3 = '0.00';
                        }else{
                            MONTHRET3 = parseFloat(details['3MONTHRET']).toFixed(2);
                        }
                        trdata +='<td> '+MONTHRET3+'</td>';
                        if(details['6MONTHRET'] == ''){
                            MONTHRET6 = '0.00';
                        }else{
                            MONTHRET6 = parseFloat(details['6MONTHRET']).toFixed(2);
                        }
                        trdata +='<td> '+MONTHRET6+'</td>';
                        if(details['1YEARRET'] == ''){
                            YEARRET1 = '0.00';
                        }else{
                            YEARRET1 = parseFloat(details['1YEARRET']).toFixed(2);
                        }
                        trdata +='<td> '+YEARRET1+'</td>';
                        if(details['3YEARRET'] == ''){
                            YEARRET3 = '0.00';
                        }else{
                            YEARRET3 = parseFloat(details['3YEARRET']).toFixed(2);
                        }
                        trdata +='<td> '+YEARRET3+'</td>';
                        if(details['5YEARRET'] == ''){
                            YEARRET5 = '0.00';
                        }else{
                            YEARRET5 = parseFloat(details['5YEARRET']).toFixed(2);
                        }
                        trdata +='<td> '+YEARRET5+'</td>';

                        if(details['10YEARRET'] == ''){
                            YEARRET10 = '0.00';
                        }else{
                            YEARRET10 = parseFloat(details['10YEARRET']).toFixed(2);
                        }

                        trdata +='<td> '+YEARRET10+'</td>'+
                        //'<td> '+parseFloat(details['10YEARRET']).toFixed(2)+'%</td>'+
                     '</tr>';

                    });


                    trdata += '</tbody></table>';

                    $("#suggested-scheme-details").html(trdata);
                    $("#category_name").val(category_name);
                    $('#show-report').show();
                    $('#refresh-report').show();
                    //$('#myShowReportTable').DataTable({searching: false, paging: false, info: false});
                    //$('#myShowReportTable').DataTable({searching: false, paging: false, info: false, dom: 'Bfrtip', buttons: 'csvHtml5'});

                    $('#myShowReportTable').DataTable( {
                        searching: false, 
                        paging: false, 
                        info: false
                    } );

                    $('.filter').on('click', function(e){
                        e.stopPropagation();
                    });
                    
                }else{
                    $("#suggested-scheme-details").html('<h3>No scheme found!</h3>');
                    
                }
                
                $('#loadingmessage').hide();
                
            }
        });
        
    }
    
    $("#refresh-report").click(function(){
        $('#loadingmessage').show();
        var duration = [];
        var schemecode = [];
        
        $("input[name='duration[]']:checked").each(function () {
            duration.push($(this).val());
        });
        $("input[name='schemecode[]']:checked").each(function () {
            schemecode.push($(this).val());
        });
        //console.log(duration);
        console.log(schemecode);
        $.ajax({
            url: "{{ url('calculators/fund-performance/categorywiseschemedetailsrefreshreport') }}",
            method: 'get',
            data: {
                duration: duration,
                schemecode: schemecode
            },
            success: function (result) {
                //console.log(result);
                //console.log(duration);

                if(result.length>0) {
                    var trdata = '<table class="table table-bordered suggested-scheme-details"><tr>'+
                        '<th style="width: 30%;"> </th><th style="width: 10%;"></th>';
                        if($.inArray( "1WEEKRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="1WEEKRET" checked> </th>';
                        }
                        if($.inArray( "1MONTHRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="1MONTHRET" checked> </th>';
                        }
                        if($.inArray( "3MONTHRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="3MONTHRET" checked> </th>';
                        }
                        if($.inArray( "6MONTHRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="6MONTHRET" checked> </th>';
                        }
                        if($.inArray( "1YEARRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="1YEARRET" checked> </th>';
                        }
                        if($.inArray( "3YEARRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="3YEARRET" checked> </th>';
                        }
                        if($.inArray( "5YEARRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="5YEARRET" checked> </th>';
                        }
                        if($.inArray( "10YEARRET", duration ) !== -1 ){
                            trdata +='<th><input type="checkbox" name="duration[]" value="10YEARRET" checked> </th>';
                        }
                        trdata +='</tr></table>';
                    trdata += '<table id="myShowReportTable" class="table table-bordered suggested-scheme-details"><thead><tr>'+
                    '<th style="width: 30%;">Scheme Name</th><th style="width: 10%;">AUM (CR)</th>';
                    if($.inArray( "1WEEKRET", duration ) !== -1 ){
                        trdata +='<th> 7 Day </th>';
                    }
                    if($.inArray( "1MONTHRET", duration ) !== -1 ){
                        trdata +='<th> 1 mth </th>';
                    }
                    if($.inArray( "3MONTHRET", duration ) !== -1 ){
                        trdata +='<th> 3 mth </th>';
                    }
                    if($.inArray( "6MONTHRET", duration ) !== -1 ){
                        trdata +='<th> 6 mth </th>';
                    }
                    if($.inArray( "1YEARRET", duration ) !== -1 ){
                        trdata +='<th> 1 Yr </th>';
                    }
                    if($.inArray( "3YEARRET", duration ) !== -1 ){
                        trdata +='<th> 3 Yr </th>';
                    }
                    if($.inArray( "5YEARRET", duration ) !== -1 ){
                        trdata +='<th> 5 Yr </th>';
                    }
                    if($.inArray( "10YEARRET", duration ) !== -1 ){
                        trdata +='<th> 10 Yr </th>';
                    }
    
                    trdata +='</tr></thead><tbody>';

                    $.each(result, function (index, value) {
                        var details = JSON.parse(value);

                        trdata += '<tr>'+
                        '<td align="left"><input type="checkbox" name="schemecode[]" value="'+details['Schemecode']+'" checked> &nbsp;&nbsp;<strong>'+details['S_NAME']+'</strong></td>';
                        if(details['AUM'] == ''){
                            AUM = '0.00';
                        }else{
                            AUM = parseInt(details['AUM']/100);
                        }
                        trdata +='<td> '+AUM+'</td>';
                        if(details['1WEEKRET'] == ''){
                            WEEKRET1 = '0.00';
                        }else{
                            WEEKRET1 = parseFloat(details['1WEEKRET']).toFixed(2);
                        }

                        if($.inArray( "1WEEKRET", duration ) !== -1 ){
                            trdata +='<td> '+WEEKRET1+'</td>';
                        }

                        if(details['1MONTHRET'] == ''){
                            MONTHRET1 = '0.00';
                        }else{
                            MONTHRET1 = parseFloat(details['1MONTHRET']).toFixed(2);
                        }
                        if($.inArray( "1MONTHRET", duration ) !== -1 ){
                            trdata +='<td> '+MONTHRET1+'</td>';
                        }
                        
                        if(details['3MONTHRET'] == ''){
                            MONTHRET3 = '0.00';
                        }else{
                            MONTHRET3 = parseFloat(details['3MONTHRET']).toFixed(2);
                        }
                        if($.inArray( "3MONTHRET", duration ) !== -1 ){
                            trdata +='<td> '+MONTHRET3+'</td>';
                        }
                        
                        if(details['6MONTHRET'] == ''){
                            MONTHRET6 = '0.00';
                        }else{
                            MONTHRET6 = parseFloat(details['6MONTHRET']).toFixed(2);
                        }
                        if($.inArray( "6MONTHRET", duration ) !== -1 ){
                            trdata +='<td> '+MONTHRET6+'</td>';
                        }
                        
                        if(details['1YEARRET'] == ''){
                            YEARRET1 = '0.00';
                        }else{
                            YEARRET1 = parseFloat(details['1YEARRET']).toFixed(2);
                        }
                        if($.inArray( "1YEARRET", duration ) !== -1 ){
                            trdata +='<td> '+YEARRET1+'</td>';
                        }
                        
                        if(details['3YEARRET'] == ''){
                            YEARRET3 = '0.00';
                        }else{
                            YEARRET3 = parseFloat(details['3YEARRET']).toFixed(2);
                        }
                        if($.inArray( "3YEARRET", duration ) !== -1 ){
                            trdata +='<td> '+YEARRET3+'</td>';
                        }
                        
                        if(details['5YEARRET'] == ''){
                            YEARRET5 = '0.00';
                        }else{
                            YEARRET5 = parseFloat(details['5YEARRET']).toFixed(2);
                        }
                        if($.inArray( "5YEARRET", duration ) !== -1 ){
                            trdata +='<td> '+YEARRET5+'</td>';
                        }
                        

                        if(details['10YEARRET'] == ''){
                            YEARRET10 = '0.00';
                        }else{
                            YEARRET10 = parseFloat(details['10YEARRET']).toFixed(2);
                        }
                        if($.inArray( "10YEARRET", duration ) !== -1 ){
                            trdata +='<td> '+YEARRET10+'</td>';
                        }
                        
                        //'<td> '+parseFloat(details['10YEARRET']).toFixed(2)+'%</td>'+
                        trdata +='</tr>';

                    });


                    trdata += '</tbody></table>';

                    $("#suggested-scheme-details").html(trdata);
                    $('#loadingmessage').hide();
                    //$('#myShowReportTable').DataTable({searching: false, paging: false, info: false});
                    $('#myShowReportTable').DataTable( {
                        searching: false, 
                        paging: false, 
                        info: false
                    } );
                    $('.filter').on('click', function(e){
                        e.stopPropagation();
                    });
                }
            }
        });
    });
</script>

@endsection