@extends('admin.admin_master')
@section('admin')
    <div class="page-content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0">Sales Reports</h4>
                    </div>
                </div>
            </div>
            <div class="row">             
                <form method="GET" action="#" class="user_report_form">
                    @csrf
                    <div class="row">
                        <div class="col-md-2">
                            <div class="mb-3">
                                <select class="form-control search_type" name="search_type">
                                    <option selected="" value="">Search Type</option>
                                    <option value="1" {{(old("search_type")==1 || $search_type==1)?"selected":""}}>Month Wise Sales</option>
                                    {{-- <option value="2" {{($search_type==2)?"selected":""}}>Weekly Sales</option> --}}
                                    <option value="3" {{(old("search_type")==3 || $search_type==3)?"selected":""}}>Quaterly Sales</option>
                                    <option value="4" {{(old("search_type")==4 || $search_type==4)?"selected":""}}>Yearly Sales</option>
                                    <option value="5" {{(old("search_type")==5 || $search_type==5)?"selected":""}}>Country Wise</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2 country_wise" style={{(old("search_type")==5 || $search_type==5)?"display:block":"display:none"}}>
                            <div class="mb-3">
                                <select class="form-control country_value" name="countryid">
                                    <option selected="" value="">Select Country</option>
                                    @foreach($countries as $country)
                                        <option value="{{$country->id}}" {{(old("countryid") == $country->id ||$country_id==$country->id)?"selected":""}}>{{$country->name}}</option>
                                    @endforeach
                                </select>
                            </div>
                            <p class="text-danger fs-14 country_shown" style="display:none;"></p>
                        </div> 
                        <div class="col-md-2 monthly_wise" style={{($search_type==1 || $search_type==5)?"display:block":"display:none"}}>
                            <div class="mb-3">
                                <select class="form-control month_value" name="month_id">
                                    <option selected="" value="">Select Month</option>
                                    <option value="1" {{(old("month_id")==1 || $month_id=="1")?"selected":""}}>January</option>
                                    <option value="2" {{(old("month_id")==2 || $month_id=="2")?"selected":""}}>February</option>
                                    <option value="3" {{(old("month_id")==3 || $month_id=="3")?"selected":""}}>March</option>
                                    <option value="4" {{(old("month_id")==4 || $month_id=="4")?"selected":""}}>April</option>
                                    <option value="5" {{(old("month_id")==5 || $month_id=="5")?"selected":""}}>May</option>
                                    <option value="6" {{(old("month_id")==6 || $month_id=="6")?"selected":""}}>June</option>
                                    <option value="7" {{(old("month_id")==7 || $month_id=="7")?"selected":""}}>July</option>
                                    <option value="8" {{(old("month_id")==8 || $month_id=="8")?"selected":""}}>August</option>
                                    <option value="9" {{(old("month_id")==9 || $month_id=="9")?"selected":""}}>September</option>
                                    <option value="10" {{(old("month_id")==10 || $month_id=="10")?"selected":""}}>October</option>
                                    <option value="11" {{(old("month_id")==11 || $month_id=="11")?"selected":""}}>November</option>
                                    <option value="12" {{(old("month_id")==12 || $month_id=="12")?"selected":""}}>December</option>
                                </select>
                            </div>
                            <p class="text-danger fs-14 month_shown" style="display:none;"></p>
                        </div>

                        <div class="col-md-2 quat_wise" style={{(old("search_type")==3 || $search_type==3)?"display:block":"display:none"}}>
                            <div class="mb-3">
                                <select class="form-control quaterly_value" name="quaterly">
                                    <option selected="" value="">Select Quaterly</option>
                                    <option value="1" {{(old("quaterly")==1 || $quaterly==1)?"selected":""}}>Jan- Mar</option>
                                    <option value="2" {{(old("quaterly")==2 || $quaterly==2)?"selected":""}}>Apr - June</option>
                                    <option value="3" {{(old("quaterly")==3 || $quaterly==3)?"selected":""}}>July - Sep</option>
                                    <option value="4" {{(old("quaterly")==4 || $quaterly==4)?"selected":""}}>Oct -  Dec</option>
                                </select>
                            </div>
                            <p class="text-danger fs-14 quaterly_shown" style="display:none;"></p>
                        </div>
                        <div class="col-md-2 year_wise">
                            <div class="mb-3">
                                <select class="form-control year_value" name="year">
                                    <option selected="" value="">Select Year</option>
                                    @for($i=2022 ;$i<=2073;$i++)
                                        <option value="{{$i}}" {{(old("year") == $i || $i==$year)?"selected":""}}>{{$i}}</option>
                                    @endfor
                                </select>
                            </div>
                            <p class="text-danger fs-14 year_shown" style="display:none;"></p>
                        </div> 
                    
                        <div class="col-md-2">
                            <button class="btn btn-primary submit_form" type="button">Submit</button>
                            <a class="btn btn-primary ms-4" href="{{route("salesexport.pdf"). '?' . $query_string}}">Export PDF</a>
                        </div>
                    </div>
                </form>
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">                    
                            <div id="container"></div>
                            <table id="datatable" class="table table-bordered dt-responsive nowrap"
                                style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                <thead>
                                    <tr>
                                        <th>Sl</th>
                                        <th>Name</th>
                                        <th>Email</th>
                                        <th>Phone</th>
                                        <th>Register Date</th>
                                        <th>Payment Date</th>
                                        <th>Status</th>
                                        <th>Payment/Refund Amount</th>
                                </thead>
    
                                <tbody>
                                    @php($i = 1)
                                    @foreach($payments as $payment)
                                        <tr>
                                            <td> {{ $i++}} </td>
                                            <td> {{ $payment->user->name }} </td>
                                            <td>
                                                @if($payment->payment_status!=4 && $payment->payment_status==1)
                                                    <span class="text-success">{{ $payment->user->email }}</span>
                                                @elseif($payment->payment_status==4)
                                                    <span class="text-danger">{{ $payment->user->email }}</span>
                                                @else
                                                    <span style="color:orange">{{ $payment->user->email }}</span>
                                                @endif
                                            </td>
                                            <td> {{ $payment->user->mobile_number }} </td>
                                            <td>
                                                {{Carbon\Carbon::parse($payment->user->created_at)->format("Y-m-d")}}
                                            </td>
                                            <td>
                                                @if($payment->payment_status==1)
                                                    {{Carbon\Carbon::parse($payment->updated_at)->format("Y-m-d")}}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td>
                                                @if($payment->payment_status==1)
                                                    <button class="btn btn-success">Payment Completed</button>
                                                @elseif($payment->payment_status!=4)
                                                    <button class="btn btn-primary">Payment Attempted</button>
                                                @elseif($payment->payment_status==4)
                                                    <button class="btn btn-danger">Payment Refunded</button>
                                                @endif
                                            </td>
                                            <td>
                                                {{$payment->currency." ".$payment->amount }}
                                                {{-- <a href="{{ route('user.payments',$payment->id)}}" class="btn btn-outline-primary">view</a> --}}
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div> 
            </div>
        </div>
    </div>
@endsection
@push("script")
<script>
    $(document).ready(function(){
        $(".search_type").on("click change",function(){
            var value=this.value;
            console.log(value);
            $(".country_value").val("");
            $(".month_value").val("");
            $(".week_value").val("");
            $(".quaterly_value").val("");
            $(".year_value").val("");
            if(value==1)
            {
                $(".monthly_wise").css("display","block");
                $(".year_wise").css("display","block");
                $(".weekly_wise").css("display","none");
                $(".quat_wise").css("display","none");
                $(".country_wise").css("display","none");
            }else if(value==2){
                $(".monthly_wise").css("display","none");
                $(".year_wise").css("display","none");
                $(".weekly_wise").css("display","block");
                $(".quat_wise").css("display","none");
                $(".country_wise").css("display","none");
            }else if(value==3)
            {
                $(".monthly_wise").css("display","none");
                $(".year_wise").css("display","block");
                $(".weekly_wise").css("display","none");
                $(".quat_wise").css("display","block");
                $(".country_wise").css("display","none");
            }else if(value==4)
            {
                $(".monthly_wise").css("display","none");
                $(".year_wise").css("display","block");
                $(".weekly_wise").css("display","none");
                $(".quat_wise").css("display","none");
                $(".country_wise").css("display","none");
            }else if(value==5){
                $(".monthly_wise").css("display","block");
                $(".year_wise").css("display","block");
                $(".weekly_wise").css("display","none");
                $(".quat_wise").css("display","none");
                $(".country_wise").css("display","block");
            }
        })
    })
</script>
<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>
<script src="https://code.highcharts.com/modules/accessibility.js"></script>
<script>
    var count=@js($count);
    var payment_dates=@js($payment_dates);
    console.log(count);
    console.log(payment_dates);
    if(payment_dates.length>0)
    {
        console.log(1);
        Highcharts.chart('container', {
            title: {
                text: 'Sales'
            },
    
            accessibility: {
                point: {
                    valueDescriptionFormat:
                        '{xDescription}{separator}{value} million(s)'
                }
            },
    
            xAxis: {
                title: {
                    text: 'Year'
                },
                categories: payment_dates,
            },
    
            yAxis: {
                type: 'logarithmic',
                title: {
                    text: 'Number of Sales Occurs'
                }
            },
        
            tooltip: {
                headerFormat: '<b>{series.name}</b><br />',
                pointFormat: '{point.y} sales(s)'
            },
    
            series: [{
                name: 'Sales count',
                keys: ['y', 'color'],
                data: count,
                color: {
                    linearGradient: {
                        x1: 0,
                        x2: 0,
                        y1: 1,
                        y2: 0
                    },
                    stops: [
                        [0, '#0000ff'],
                        [1, '#ff0000']
                    ]
                }
            }]
        });
    }else if(count.length>0){
        Highcharts.setOptions({
            colors: Highcharts.map(Highcharts.getOptions().colors, function (color) {
                return {
                    radialGradient: {
                        cx: 0.5,
                        cy: 0.3,
                        r: 0.7
                    },
                    stops: [
                        [0, color],
                        [1, Highcharts.color(color).brighten(-0.3).get('rgb')] // darken
                    ]
                };
            })
        });
        Highcharts.chart('pie_chart_container', {
            chart: {
                plotBackgroundColor: null,
                plotBorderWidth: null,
                plotShadow: false,
                type: 'pie'
            },
            title: {
                text: 'Sales and Predictions',
                align: 'left'
            },
            tooltip: {
                pointFormat: '{series.name}: <b>{point.y}</b>'
            },
            accessibility: {
                point: {
                    valueSuffix: '%'
                }
            },
            plotOptions: {
                pie: {
                    allowPointSelect: true,
                    cursor: 'pointer',
                    dataLabels: {
                        enabled: true,
                        format: '<span style="font-size: 1.2em"><b>{point.name}</b>' +
                            '</span><br>' +
                            '<span style="opacity: 0.6">{point.percentage:.1f} ' +
                            '%</span>',
                        connectorColor: 'rgba(128,128,128,0.5)'
                    }
                }
            },
            series: [{
                name: 'Payments',
                data: count
            }]
        });
    }

    $(".submit_form").on("click",function(){
        var search_type=$(".search_type").val();
        var action=0;
        var action1=0;
        var year=0;
        if(search_type==1)
        {
            if($(".month_value").val()=="")
            {
                action=0;
                $(".month_shown").html('Month is required*');
                $(".month_shown").css('display','block');
            }else{
                action=1;
                $(".month_shown").html('');
                $(".month_shown").css('display','none');
            }

            if($(".year_value").val()=="")
            {
                action1=0;
                $(".year_shown").html('Year is required*');
                $(".year_shown").css('display','block');
            }else{
                action1=1;
                $(".year_shown").html('');
                $(".year_shown").css('display','none');
            }
        }else if(search_type==3)
        {
            if($(".quaterly_value").val()=="")
            {
                action=0;
                $(".quaterly_shown").html('Quaterly is required*');
                $(".quaterly_shown").css('display','block');
            }else{
                action=1;
                $(".quaterly_shown").html('');
                $(".quaterly_shown").css('display','none');
            }

            if($(".year_value").val()=="")
            {
                action1=0;
                $(".year_shown").html('Year is required*');
                $(".year_shown").css('display','block');
            }else{
                action1=1;
                $(".year_shown").html('');
                $(".year_shown").css('display','none');
            }
        }else if(search_type==4)
        {
            if($(".year_value").val()=="")
            {
                year=0;
                $(".year_shown").html('Year is required*');
                $(".year_shown").css('display','block');
            }else{
                year=1;
                $(".year_shown").html('');
                $(".year_shown").css('display','none');
            }
        }else if(search_type==5)
        {
            if($(".country_value").val()=="")
            {
                action=0;
                $(".country_shown").html('Country is required*');
                $(".country_shown").css('display','block');
            }else{
                action=1;
                $(".country_shown").html('');
                $(".country_shown").css('display','none');
            }

            if($(".year_value").val()=="")
            {
                action1=0;
                $(".year_shown").html('Year is required*');
                $(".year_shown").css('display','block');
            }else{
                action1=1;
                $(".year_shown").html('');
                $(".year_shown").css('display','none');
            }
        }
        if((action==1 && action1==1) || (year==1))
        {
            $(".user_report_form").submit();
        }
    })
</script>
@endpush