@extends('Admin/layout')
@section('title','Total Sale')
@section('content')
@if(has_permission('Report','Total Sale'))
<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">Total Sale</h4>
                <form action="{{route('visitportal.totalSaleReport')}}" class="g-3" id="formId" method="post" >
                        {{csrf_field()}}
                        <div class="row" >
                            
                            <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">Associate Name</th>
                                        <th scope="col">Rera No</th>
                                        <th scope="col">Gk Code</th>
                                        <th scope="col">Curr Range Direct Qty</th>
                                        <th scope="col">Curr Range InDirect Qty</th>
                                        <th scope="col">Total Direct Qty</th>
                                        <th scope="col">Total InDirect Qty</th>
                                        <th scope="col">Total OverAll Qty</th>
                                        <th scope="col">Opening Stock</th>
                                        <th scope="col">OverAll Qty (With Opening Stock)</th>
                                        <th scope="col">PL Downline Name</th>
                                        <th scope="col">PL Total oveer all qty</th>
                                        <th scope="col">PL GK Code</th>
                                        <th scope="col">PL Rera No</th>
                                        
                                    </tr>
                                </thead>
                                <tbody id="table1">
                                    @if(!empty($totalsalesdata))
                                        @foreach($totalsalesdata as $key => $value)
                                            <tr>
                                                <td>{{$key + 1}}</td>
                                                <td>{{$value->name}}</td>
                                                <td>{{$value->rera_no}}</td>
                                                <td>{{$value->gk_code}}</td>
                                                <td>{{$value->curDtRangeDirectQty}}</td>
                                                <td>{{$value->curDtRangeInDirectQty}}</td>
                                                <td>{{$value->TotalDirectQty}}</td>
                                                <td>{{$value->TotalInDirectQty}}</td>
                                                <td>{{$value->TotalOverAllQty}}</td>
                                                <td>{{$value->OpeningStock}}</td>
                                                <td>{{$value->TotalOverAllQtyWithOpeningStock}}</td>
                                                <td>{{$value->Pl1AssociateName}}</td>
                                                <td>{{$value->Pl1TotalOverAllQty}}</td>
                                                <td>{{$value->Pl1DownlineGkCode}}</td>
                                                <td>{{$value->Pl1DownlineReraNo}}</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 from_date = $("#from_date").val();
            var to_date = $("#to_date").val();
            if(from_date == "" || to_date == ""){
                setTimeout(function(){
                            $("#overlay1").fadeOut(300);
                        },500);
                Toastify({
                            text: "From Date and To Date Missing",
                            className: "danger",
                            style: {
                            background: "linear-gradient(to right, #f06548, #f06548)",
                            }
                        }).showToast();
                        
                        return
            }

                var searchModel = {errordata : filedata,from_date : from_date, to_date : to_date,  'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')};
                
                
                event.preventDefault();
                $.ajax({
                    url:"{{route('visitportal.downloadtotalSaleReport')}}",
                    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 = "TotalSalesData.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 from_date = $("#from_date").val();
            var to_date = $("#to_date").val();
            if(from_date == "" || to_date == ""){
                setTimeout(function(){
                            $("#overlay1").fadeOut(300);
                        },500);
                Toastify({
                            text: "From Date and To Date Missing",
                            className: "danger",
                            style: {
                            background: "linear-gradient(to right, #f06548, #f06548)",
                            }
                        }).showToast();
                        
                        return
            }
            $("#overlay1").fadeIn(300);
            $("#formId").submit();
            if({{count($totalsalesdata)}}){
                setTimeout(function(){
                    $("#overlay1").fadeOut(300);
                },500);
            }
            
        }
</script>
@endif

@endsection