@extends('layout')
@section('content')
@if (session('status'))
<div class="alert alert-success" role="alert">
    <button type="button" class="close" data-dismiss="alert">×</button>
    {{ session('status') }}
</div>
@elseif(session('failed'))
<div class="alert alert-danger" role="alert">
    <button type="button" class="close" data-dismiss="alert">×</button>
    {{ session('failed') }}
</div>
@endif
<!--Content Header (Page header)-->
<div class="content-header row align-items-center m-0">
    <nav aria-label="breadcrumb" class="col-sm-4 order-sm-last mb-3 mb-sm-0 p-0 ">
        <ol class="breadcrumb d-inline-flex font-weight-600 fs-13 bg-white mb-0 float-sm-right">
            <li class="breadcrumb-item"><a href="#">Dashboard</a></li>
            <li class="breadcrumb-item active">UDD</li>
        </ol>
    </nav>
    <div class="col-sm-8 header-title p-0">
        <div class="media">
            <div class="header-icon text-success mr-3"><i class="typcn typcn-spiral"></i></div>
            <div class="media-body">
                <h1 class="font-weight-bold">UDD History</h1>
                <small>With new package</small>
            </div>
        </div>
    </div>
</div>
<div class="body-content">
    <div class="row">
        <div class="col-lg-12">
            <!--<form action="{{ URL('udd-history') }}" method="post">-->
            <!--    @csrf-->
            <!--    <div class="form-group row">-->
            <!--        <div class="col-sm-3">-->
            <!--        <label>From</label>-->
            <!--        <input type="date" class="form-control" name="from" @if($from!='') value="{{ $from }}" @endif required>-->
            <!--        </div>-->
            <!--        <div class="col-sm-3">-->
            <!--        <label>To</label>-->
            <!--        <input type="date" class="form-control" name="to" @if($to!='') value="{{ $to }}" @endif required>-->
            <!--        </div>-->
            <!--        <div class="col-sm-3">-->
            <!--        <label>Type</label>-->
            <!--        <select class="form-control" name="type" required>-->
            <!--            <option value="all" @if($type=='all') selected @endif>All</option>-->
            <!--            <option value="new" @if($type=='new') selected @endif>New</option>-->
            <!--            <option value="customize" @if($type=='customize') selected @endif>Customize</option>-->
            <!--            <option value="downgrade" @if($type=='downgrade') selected @endif>Downgrade</option>-->
            <!--            <option value="upgrade" @if($type=='upgrade') selected @endif>Upgrade</option>-->
            <!--            <option value="temporary_upgrade" @if($type=='temporary_upgrade') selected @endif>Temporary Upgrade</option>-->
            <!--            <option value="temporary_downgrade" @if($type=='temporary_downgrade') selected @endif>Temporary Downgrade</option>-->
            <!--            <option value="discontinue" @if($type=='discontinue') selected @endif>Discontinue</option>-->
            <!--        </select>-->
            <!--        </div>-->

            <!--        <div class="col-sm-3">-->
            <!--            <label style="padding-top:44px;"></label>-->
            <!--            <input type="submit" class="btn btn-primary" name="submit" value="Search">-->
            <!--        </div>-->
            <!--    </div>-->
            <!--</form>-->
            
            <form action="{{ URL('udd-history') }}" method="post">
                @csrf
                <div class="form-group row">
                    <div class="col-sm-3">
                        <label>From</label>
                        <input type="date" class="form-control" name="from" @if($from!='') value="{{ $from }}" @endif required>
                    </div>
                    <div class="col-sm-3">
                        <label>To</label>
                        <input type="date" class="form-control" name="to" @if($to!='') value="{{ $to }}" @endif required>
                    </div>
                    <div class="col-sm-3">
                        <label>Type</label>
                        <select class="form-control" name="type" required>
                            <option value="all" @if($type=='all') selected @endif>All</option>
                            <option value="new" @if($type=='new') selected @endif>New</option>
                            <option value="customize" @if($type=='customize') selected @endif>Customize</option>
                            <option value="downgrade" @if($type=='downgrade') selected @endif>Downgrade</option>
                            <option value="upgrade" @if($type=='upgrade') selected @endif>Upgrade</option>
                            <option value="temporary_upgrade" @if($type=='temporary_upgrade') selected @endif>Temporary Upgrade</option>
                            <option value="temporary_downgrade" @if($type=='temporary_downgrade') selected @endif>Temporary Downgrade</option>
                            <option value="discontinue" @if($type=='discontinue') selected @endif>Discontinue</option>
                        </select>
                    </div>
                    <div class="col-sm-3">
                        <label>Customer Type</label>
                        <select class="form-control" name="customer_type" required>
                            <option value="all" @if($customer_type=='all') selected @endif>All</option>
                            <option value="home" @if($customer_type=='home') selected @endif>Home</option>
                            <option value="corporate" @if($customer_type=='corporate') selected @endif>Corporate</option>
                            <option value="reseller" @if($customer_type=='reseller') selected @endif>Reseller</option>
                            <option value="mac_reseller" @if($customer_type=='mac_reseller') selected @endif>Mac Reseller</option>
                            <option value="data_link" @if($customer_type=='data_link') selected @endif>Data Link</option>
                        </select>
                    </div>

                    <div class="col-sm-3">
                        <label style="padding-top:44px;"></label>
                        <input type="submit" class="btn btn-primary" name="submit" value="Search">
                    </div>
                </div>
            </form>

            <div class="card">
                <div class="card-body">

                    <div class="table-responsive">
                        <table class="table display table-bordered table-striped table-hover basic dataTable no-footer" id="DataTables_Table_0" role="grid" aria-describedby="DataTables_Table_0_info">
                            <thead>
                                <tr>
                                    <th>SL</th>
                                    <th>Name</th>
                                    <th>Request Date</th>
                                    <th>Internet(MB) <br />Request/Existing </th>
                                    <th>Youtube(MB) <br />Request/Existing </th>
                                    <th>Facebook(MB) <br />Request/Existing </th>
                                    <th>Bdix(MB) <br />Request/Existing </th>
                                    <th>Data(MB) <br />Request/Existing </th>
                                    <th>Package Type</th>
                                    <th>UDD Type</th>
                                    <th>Remarks for support</th>
                                    @if(Auth::user()->getRoleNames()[0] =='Account' || Auth::user()->getRoleNames()[0] =='Marketing' || Auth::user()->getRoleNames()[0] =='Admin'  || Auth::user()->getRoleNames()[0] =='Super Admin')
                                    <th>Remarks for accounts</th>
                                    @endif
                                    <th>Discontinue Date</th>
                                    <th>Effective Date</th>

                                    <th>Tem.Date</th>
                                    <th>KAM</th>
                                    <th>Accounts</th>
                                    <th>Support</th>
                                    <th></th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $sl=0;
                                    $requestBWMBDGDCCD=0;
                                    $requestYTMBDGDCCD=0;
                                    $requestFBMBDGDCCD=0;
                                    $requestDAMBDGDCCD=0;
                                    $requestBXMBDGDCCD=0;

                                    $requestBWMB=0; $existingBWMB=0;
                                    $requestYTMB=0; $existingYTMB=0;
                                    $requestFBMB=0; $existingFBMB=0;
                                    $requestDAMB=0; $existingDAMB=0;
                                    $requestBXMB=0; $existingBXMB=0;
                                @endphp
                                @foreach ($result as $client)
                                @php
                                $sl++;
                                $requestBWMB+= $client->cu_bandwith;
                                $existingBWMB+= $client->exiting_bandwith;

                                $requestYTMB+= $client->cu_youtube;
                                $existingYTMB+= $client->exiting_youtube;

                                $requestFBMB+= $client->cu_facebook;
                                $existingFBMB+= $client->exiting_facebook;

                                $requestDAMB+= $client->cu_data;
                                $existingDAMB+= $client->exiting_data;

                                $requestBXMB+= $client->cu_bdix;
                                $existingBXMB+= $client->exiting_bdix;

                                if($client->flag=='downgrade' || $client->flag=='discontinue'  || ($client->flag=='customize' && $client->type_bandwith))
                                {
                                    $requestBWMBDGDCCD += $client->cu_bandwith;
                                    $requestYTMBDGDCCD += $client->cu_youtube;
                                    $requestFBMBDGDCCD += $client->cu_facebook;
                                    $requestDAMBDGDCCD += $client->cu_data;
                                    $requestBXMBDGDCCD += $client->cu_bdix;
                                }

                                @endphp
                                <tr id="div_id{{ $client->id }}">
                                    <td>{{ $sl }}</td>
                                    <td><a href="javaScript:void(0)" data-id="{{ $client->cu_id }}" data-toggle="modal" data-target='#practice_modal' onClick="active_customer({{$client->cu_id}});"> {{ $client->company_name }} </a></td>
                                    <td>{{ $client->create_dt }}</td>
                                    <td>
                                        @if($client->cu_bandwith!='')
                                        {{ $client->cu_bandwith.'/'.$client->exiting_bandwith}}
                                        @else
                                        {{ '0/'.$client->exiting_bandwith}}
                                        @endif

                                        @if($client->flag=='customize')
                                        <br />
                                        <b style="text-transform: capitalize;"> {{ $client->type_bandwith }} </b>
                                        @endif

                                        @if(Auth::user()->getRoleNames()[0]=='Account')
                                        <br /> {{ $client->cu_bandwith_price.'/'.$client->exiting_bandwith_price}}
                                        @endif
                                    </td>
                                    <td>
                                        @if($client->cu_youtube!='')
                                        {{ $client->cu_youtube.'/'.$client->exiting_youtube }}
                                        @else
                                        {{ '0/'.$client->exiting_youtube}}
                                        @endif

                                        @if($client->flag=='customize')
                                        <br />
                                        <b style="text-transform: capitalize;"> {{ $client->type_youtube }} </b>
                                        @endif

                                        @if(Auth::user()->getRoleNames()[0]=='Account')
                                        <br /> {{ $client->cu_youtube_price.'/'.$client->exiting_youtube_price}}
                                        @endif
                                    </td>
                                    <td>
                                        @if($client->cu_facebook!='')
                                        {{ $client->cu_facebook.'/'.$client->exiting_facebook }}
                                        @else
                                        {{ '0/'.$client->exiting_facebook}}
                                        @endif

                                        @if($client->flag=='customize')
                                        <br />
                                        <b style="text-transform: capitalize;"> {{ $client->type_facebook }} </b>
                                        @endif

                                        @if(Auth::user()->getRoleNames()[0]=='Account')
                                        <br /> {{ $client->cu_facebook_price.'/'.$client->exiting_facebook_price}}
                                        @endif
                                    </td>
                                    <td>
                                        @if($client->cu_bdix!='')
                                        {{ $client->cu_bdix.'/'.$client->exiting_bdix}}
                                        @else
                                        {{ '0/'.$client->exiting_bdix}}
                                        @endif

                                        @if($client->flag=='customize')
                                        <br />
                                        <b style="text-transform: capitalize;"> {{ $client->type_bdix }} </b>
                                        @endif

                                        @if(Auth::user()->getRoleNames()[0]=='Account')
                                        <br /> {{ $client->cu_bdix_price.'/'.$client->exiting_bdix_price}}
                                        @endif
                                    </td>
                                    <td>
                                        @if($client->cu_data!='')
                                        {{ $client->cu_data.'/'.$client->exiting_data}}
                                        @else
                                        {{ '0/'.$client->exiting_data}}
                                        @endif

                                        @if($client->flag=='customize')
                                        <br />
                                        <b style="text-transform: capitalize;"> {{ $client->type_data }} </b>
                                        @endif

                                        @if(Auth::user()->getRoleNames()[0]=='Account')
                                        <br /> {{ $client->cu_data_price.'/'.$client->exiting_data_price}}
                                        @endif
                                    </td>
                                    <th>{{ $client->package_type }}</th>
                                    <td>
                                        @if($client->flag=='new')
                                        New
                                        @elseif($client->flag=='customize')
                                        Customize
                                        @elseif($client->flag=='upgrade')
                                        Up Grade
                                        @elseif($client->flag=='downgrade')
                                        Down Grade
                                        @elseif($client->flag=='discontinue')
                                        Discontinue
                                        @elseif($client->flag=='temporary_upgrade')
                                        Temporary Up Grade
                                        @elseif($client->flag=='temporary_downgrade')
                                        Temporary Down Grade
                                        @endif
                                    </td>
                                    <th>{{ $client->remarks_for_support }}</th>
                                    @if(Auth::user()->getRoleNames()[0] =='Account' || Auth::user()->getRoleNames()[0] =='Marketing' || Auth::user()->getRoleNames()[0] =='Admin'  || Auth::user()->getRoleNames()[0] =='Super Admin')
                                    <th>{{ $client->remarks }}</th>
                                    @endif
                                    <th>{{ $client->discontinue_date }}</th>
                                    <th>{{ $client->effective_date }}</th>

                                    <td>{{ $client->temporary_date_start }}<br />
                                        {{ $client->temporary_date_end }}
                                    </td>

                                    <td> {{ $client->kamName }} </td>
                                    <td> {{ $client->accUser }} </td>
                                    <td>{{ $client->doneUser }}</td>
                                    <td>Done</td>
                                </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="3" class="text-right">Grand Total</th>
                                    <th>

                                        {{ $type=='all' ? ($requestBWMB-$requestBWMBDGDCCD).'/'.$existingBWMB : ($requestBWMB).'/'.$existingBWMB }}

                                        {{-- {{ ($requestBWMB-$requestBWMBDGDCCD).'/'.$existingBWMB}} --}}
                                    </th>
                                    <th>
                                        {{ $type=='all' ? ($requestYTMB-$requestYTMBDGDCCD).'/'.$existingYTMB : ($requestYTMB).'/'.$existingYTMB }}

                                        {{-- {{ ($requestYTMB-$requestYTMBDGDCCD).'/'.$existingYTMB}} --}}
                                    </th>
                                    <th>
                                        {{ $type=='all' ? ($requestFBMB-$requestFBMBDGDCCD).'/'.$existingFBMB : ($requestFBMB).'/'.$existingFBMB }}

                                        {{-- {{ ($requestFBMB-$requestFBMBDGDCCD).'/'.$existingFBMB}} --}}
                                    </th>
                                    <th>
                                        {{ $type=='all' ? ($requestBXMB-$requestBXMBDGDCCD).'/'.$existingBXMB : ($requestBXMB).'/'.$existingBXMB }}

                                        {{-- {{ ($requestBXMB-$requestBXMBDGDCCD).'/'.$existingBXMB}} --}}
                                    </th>
                                    <th>
                                        {{ $type=='all' ? ($requestDAMB-$requestDAMBDGDCCD).'/'.$existingDAMB : ($requestDAMB).'/'.$existingDAMB }}

                                        {{-- {{ ($requestDAMB-$requestDAMBDGDCCD).'/'.$existingDAMB}} --}}
                                    </th>
                                    <th colspan="8"></th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<!--/.body content-->
</div>
<div class="card"></div>
<div class="modal fade" id="serveyDetails" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-body">
        <div class="modal-dialog modal-xl" role="document">
            <div class="modal-content" style="padding: 15px;">
                <div id="modalContent"></div>
            </div>
        </div>
    </div>
</div>
<script type="text/javascript">
function approved(id,status,type)
{
    //alert(id+"---"+status+"---"+type);

    if (confirm("Are you sure you want do this?") == true) {

        $("#div_id"+id).hide();

        Toastify({
          text: "Changed has been successfully done.",
          duration: 4000,
          destination: "https://github.com/apvarun/toastify-js",
          newWindow: true,
          close: true,
          gravity: "top", // `top` or `bottom`
          positionRight: true, // `true` or `false`
          backgroundColor: "linear-gradient(to right, #00b09b, #96c93d)",
        }).showToast();

        $.ajax({
            url:'{{ url('request-customer-approved') }}',
            type: 'GET',
            data: { id:id, status:status, type:type },
            success: function(data)
            {
                //window.location.reload();
            }
        });
    }
}

// active customer list data view
function active_customer(cu_id) {
    $.ajax({
        url: '{{ url('details') }}',
        type: 'GET',
        data: { id: cu_id },
        success: function(data) {
            $("#serveyDetails").modal('show');
            $("#modalContent").html(data);
        }
    });
}

</script>
@endsection