@extends('Admin/layout')
@section('title','Team Wise Business')
@section('content')
@if(has_permission('Report','Team Wise Business'))
<div class="container-fluid">
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header">
                <h4 class="card-title mb-0 flex-grow-1">Team Wise Business</h4>
                <form action="{{route('visitportal.team_wise_business')}}" class="g-3" id="formId" method="post" >
                        {{csrf_field()}}
                        <div class="row" >
                        <div class="col-md-4">
                                <div class="mb-3">
                                    <label for="Nameinput" class="form-label">Search By Associate Email/Phone/Rear No </label>
                                    <select class="form-control single-select" id="associates_id" name="associates_id">
                                        <option value="" >Select Associates Name</option>
                                        @if(!empty($tblassociates))
                                            @foreach($tblassociates as $key => $value)
                                                <option value="{{$value->id}}" {{$associates_id == $value->id ? 'selected' : ''}}>{{$value->name}}, {{$value->phone_1}}, {{$value->rera_no}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-2" >
                                <label for="validationDefault01" class="form-label">From Date</label>
                                <input type="date" class="form-control flatpickr-input active" name="from_date" placeholder="From Date" data-provider="flatpickr" data-date-format="F j, Y" id="from_date" readonly="readonly" value="{{old('from_date')}}" required> 
                            </div>
                            <div class="col-md-2" >
                                <label for="validationDefault01" class="form-label">To Date</label>
                                <input type="date" class="form-control flatpickr-input active" name="to_date" placeholder="To Date" data-provider="flatpickr" data-date-format="F j, Y" id="to_date" readonly="readonly" value="{{old('to_date')}}" required> 
                            </div>
                           
                            <div class="col-md-1">
                                <div class="form-group" style="margin-top: 6px;">
                                    <input id="btnsearch" type="button" name="submitbtn" onclick="submitDetailsForm()" class="form-control btn btn-primary"  style="margin-top: 20px;width:100%" value="Filter">
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="form-group" style="margin-top: 6px;">
                                    <input id="btnsearch" type="button"  onclick="downloadTableData()" class="form-control  btn btn-success"  style="margin-top: 20px;width:100%" value="Export CSV">
                                </div>
                            </div>
                        </div>
                        </form>
                </div>
            </div>
        </div>
        <div class="col-xl-12">
            <div class="card">
                <div class="card-body">
                    <div class="live-preview">
                        <div class="table-responsive table-card mb-1" style="margin: 1px;">
                            <table class="table table-sm align-middle table-nowrap mb-0" id="example" style="width:100%">
                                <thead class="table-dark">
                                    <tr>

                                        <th scope="col">S.No</th>
                                        <th scope="col">Scheme-Plot</th>
                                        <th scope="col">Scheme Name</th>
                                        <th scope="col">Plot Name</th>

                                        <th scope="col">Booking Date</th>
                                        <th scope="col">Allotment Date</th>
                                        <th scope="col">Brokergeable Size</th>
                                        
                                        <th scope="col">Associate Name</th>
                                        <th scope="col">Gk Code</th>
                                        <th scope="col">rera_no</th>
                                        
                                        <th scope="col">is ReSale</th>
                                        <th scope="col">is CompanySale</th>
                                        
                                    </tr>
                                </thead>
                                <tbody id="table1">
                                    @if(!empty($totaltemawisebusinessdata))
                                        @foreach($totaltemawisebusinessdata as $key => $value)
                                            <tr>
                                                <td>{{$key + 1}}</td>
                                                <td>{{$value->SchemeAndPlot}}</td>
                                                <td>{{$value->SchemeName}}</td>
                                                <td>{{$value->plot_name}}</td>
                                                <td>{{$value->BookingDate}}</td>
                                                <td>{{$value->AllotmentDate}}</td>
                                                <td>{{$value->brokergeable_size}}</td>
                                                <td>{{$value->AssociateName}}</td>
                                                <td>{{$value->gk_code}}</td>
                                                <td>{{$value->rera_no}}</td>
                                                <td>{{$value->isReSale}}</td>
                                                <td>{{$value->isCompanySale}}</td>
                                            </tr>
                                        @endforeach
                                    @endif
                                </tbody>
                                
                            </table>
                            <!-- end table -->
                        </div>
                        <!-- end table responsive -->
                    </div>
                    
                </div><!-- end card-body -->
            </div><!-- end card -->
        </div><!-- end col -->
    </div>
</div>



<link href="https://cdn.datatables.net/2.0.8/css/dataTables.dataTables.css" rel="stylesheet" type="text/css" />
<script src="{{ URL::asset('assets/js/jquery.min.js') }}"></script>
<script src="https://cdn.datatables.net/2.0.8/js/dataTables.js"></script>

<script>
 new DataTable('#example');

 function downloadTableData(){
           var filedata = [];
           var myTab = document.getElementById('table1');
           $("#overlay1").fadeIn(300);
            // LOOP THROUGH EACH ROW OF THE TABLE AFTER HEADER.
            for (i = 0; i < myTab.rows.length; i++) {
                
                // GET THE CELLS COLLECTION OF THE CURRENT ROW.
                var objCells = myTab.rows.item(i).cells;
                var tempData = [];
                // LOOP THROUGH EACH CELL OF THE CURENT ROW TO READ CELL VALUES.
                for (var j = 0; j < objCells.length; j++) {
                    // info.innerHTML = info.innerHTML + ' ' + objCells.item(j).innerHTML;
                    tempData[j] = objCells.item(j).innerHTML;
                }
                filedata.push(tempData);
                // info.innerHTML = info.innerHTML + '<br />';     // ADD A BREAK (TAG).
            }
            var associates_id = $("#associates_id").val();
            var from_date = $("#from_date").val();
            var to_date = $("#to_date").val();
            if(associates_id == ""){
                setTimeout(function(){
                            $("#overlay1").fadeOut(300);
                        },500);
                Toastify({
                            text: "Associate Name Missing",
                            className: "danger",
                            style: {
                            background: "linear-gradient(to right, #f06548, #f06548)",
                            }
                        }).showToast();
                        
                        return
            }

                var searchModel = {errordata : filedata,associates_id : associates_id,from_date : from_date, to_date : to_date,  'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')};
                
                
                event.preventDefault();
                $.ajax({
                    url:"{{route('visitportal.downloadteamwisebusinessReport')}}",
                    method:"POST",
                    data:JSON.stringify(searchModel),
                    dataType:'json',
                    // contentType:'text/csv',
                    headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
                    // cache:false,
                    // processData:false,
                    beforeSend: function() {
                        $("#overlay1").fadeIn(300);
                    },
                    success:function(data)
                    {
                        
                    
                    },
                    complete: function(data){
                        
                        var responseText = data.responseText;
                        console.log(responseText);
                        
                         /*
                        * Make CSV downloadable
                        */
                        var downloadLink = document.createElement("a");
                        var fileData = ['\ufeff'+responseText];

                        var blobObject = new Blob(fileData,{
                            type: "text/csv;charset=utf-8;"
                        });

                        var url = URL.createObjectURL(blobObject);
                        downloadLink.href = url;
                        downloadLink.download = "TeamWiseBusinessData.csv";

                        /*
                        * Actually download CSV
                        */
                        document.body.appendChild(downloadLink);
                        downloadLink.click();
                        document.body.removeChild(downloadLink);
                        setTimeout(function(){
                            $("#overlay1").fadeOut(300);
                        },500);
                    },
                });
            // console.log(filedata);
        }

        function submitDetailsForm() {
            var associates_id = $("#associates_id").val();
            var from_date = $("#from_date").val();
            var to_date = $("#to_date").val();
            if(associates_id == ""){
                setTimeout(function(){
                            $("#overlay1").fadeOut(300);
                        },500);
                Toastify({
                            text: "Associate Name Missing",
                            className: "danger",
                            style: {
                            background: "linear-gradient(to right, #f06548, #f06548)",
                            }
                        }).showToast();
                        
                        return
            }
            $("#overlay1").fadeIn(300);
            $("#formId").submit();
            if({{count($totaltemawisebusinessdata)}}){
                setTimeout(function(){
                    $("#overlay1").fadeOut(300);
                },500);
            }
            
        }
</script>
@endif

@endsection