@include('components/header')
@include('components/sidebar')
<div id="content" class="main-content">
    <div class="topbar_content mt-3">
        @php 
            $month = date('m');
            if($month > 3){
                $cur_yr = date('Y');
                $end_yr = $cur_yr + 1;
            }
            else{
                $end_yr = date('Y');
                $cur_yr = $end_yr - 1;
            }
        @endphp
        @if(Session::get('date') != null)
            <h2>Employee Transition Tracker Of {{Session::get('date')-1}} - {{Session::get('date')}} </h2>
        @else
            <h2>Employee Transition Tracker Of {{$cur_yr}}-{{$end_yr}}</h2>
            @endif
        <div class="viewAll mr-4">
            <a href="/admin_dashboard" class="viewAllBtn">
                <button class="btn btn-danger mr-2">
                <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24"
                viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-left"><line x1="19" y1="12" x2="5" y2="12"></line><polyline points="12 19 5 12 12 5"></polyline></svg> Back</button>
            </a>
        </div>
    </div>

    <div class="layout-px-spacing layout-top-spacing mb-4">
        <div class="modal-footer"></div>
        <div class="row">
            <div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                <div class="card">
                    <div class="card-body search-filter">
                        <div class="d-flex">
                            <div class="col-2">
                                <select class="form-select" onchange="exportTable(this.value)">
                                    <option>Select Export Format</option>
                                    <option value="excel">Excel</option>
                                    <option value="pdf">PDF</option>
                                </select>
                            </div>
                            <div class="col-10">
                                <form action="/admin_candidate_list" method="post" class="form-group">
                                    {{csrf_field()}}
                                    <div class="row emp-filter-area pr-0 justify-content-end">
                                        <div class="col-3">
                                            <div class="input-group">
                                                @php $date = date("Y"); @endphp
                                                <select class="form-control" name="date">
                                                    @for($i=2021;$i<=$date;)
                                                        @for($j=$i+1; ;$j++)
                                                            @if(Session::get('date') != null)
                                                                @if(Session::get('date') == $j)
                                                                    <option selected value="{{$j}}">
                                                                        @php echo $i ."-". $j;
                                                                            $i++;
                                                                            break;
                                                                        @endphp
                                                                    </option>
                                                                @else
                                                                    <option value="{{$j}}">
                                                                        @php echo $i ."-". $j;
                                                                        $i++;
                                                                        break;
                                                                        @endphp
                                                                    </option>
                                                                @endif
                                                            @else
                                                                <option selected value="{{$j}}">
                                                                    @php echo $i ."-". $j;
                                                                    $i++;
                                                                    break;
                                                                    @endphp
                                                                </option>
                                                            @endif
                                                        @endfor
                                                    @endfor
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-4">
                                            <div class = "row">
                                                <div class="col-xl-5">
                                                    <div class="form-group p-0"> 
                                                    <button class="btn btn-primary btn-block searchBtn" value="joining_list" name="joining_list" type="submit">Joining List</button>
                                                    </div>
                                                </div>
                                                <div class="col-xl-5">
                                                    <div class="form-group p-0"> 
                                                    <button class="btn btn-danger btn-block searchBtn" value="leaving_list" name="leaving_list" type="submit">Leaving List</button>
                                                    </div>
                                                </div>
                                                @if(Session::get('date') != null)
                                                    <div class="col-xl-2 listfilter d-flex justify-content-center">
                                                        <div class="clear-filter-icon form-group mb-0">
                                                            <a href="/admin_candidate_list"><img src="{{asset('design/img/clearfiltericon.svg')}}"></a>
                                                        </div>
                                                    </div>
                                                @endif
                                            </div>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                    
                    <div class="card-body punch-card pt-0">
                        <div class="table-responsive">
                            <table id="zero-config" class="table table-striped dt-table-hover" id="standard_holiday">
                                <thead>
                                    <tr>
                                        <th>
                                            <div class="th-content text-center">Sr No.</div>
                                        </th>
                                        <th>
                                            <div class="th-content text-center">Employee ID</div>
                                        </th>
                                        <th>
                                            <div class="th-content text-center">Employee Name</div>
                                        </th>
                                        <th>
                                            <div class="th-content text-center">Department</div>
                                        </th>
                                        <th>
                                            <div class="th-content text-center">Designation</div>
                                        </th>
                                        @if(Session::get('type') == 'joining_list')
                                            <th>
                                                <div class="th-content text-center">Joining Date</div>
                                            </th>
                                        @else
                                            <th>
                                                <div class="th-content text-center">Leaving Date</div>
                                            </th>
                                            <th>
                                                <div class="th-content text-center reason">Exit reason</div>
                                            </th>
                                            <th>
                                                <div class="th-content text-center">Exit Dues</div>
                                            </th>

                                        @endif
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $i=0 @endphp
                                    @foreach($employee_data as $r)
                                    <tr class="text-center">
                                        @php $i = $i+1 @endphp
                                        @for($i=$i;$i<=count($employee_data);)
                                        <td>
                                            {{$i}}
                                        </td>
                                        @break
                                        @endfor
                                        <td>
                                            {{$r->id}}
                                        </td>
                                        <td>
                                            {{$r->first_name}} {{$r->last_name}}
                                        </td>
                                        <td>
                                            {{$r->departments->department}}
                                        </td>
                                        <td>
                                            {{$r->domains->domain}}
                                        </td>
                                        @if(Session::get('type') == 'joining_list')
                                            <td>
                                                @php $date = date('d-m-Y',strtotime($r->joining_date))  @endphp
                                                {{$date}}
                                            </td>
                                        @else
                                            <td>
                                                @php $date = date('d-m-Y',strtotime($r->leaving_date))  @endphp
                                                {{$date}}
                                            </td>
                                            <td class="reason">
                                                {{$r->exit_reason}}
                                            </td>
                                            <td>
                                                {{$r->exit_dues}}
                                            </td>
                                        @endif
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@include('components/footer')
<script>
    function exportTable(format) {
        const table = document.getElementById('zero-config');
        var tabledata = new DataTable('#zero-config');
        tabledata.destroy();
        const clonedTable = table.cloneNode(true);
        const rows = clonedTable.getElementsByTagName('tr');

        const data = $(".topbar_content").find('h2').text();
        if (format === 'pdf') {
            const options = {
              margin: 10,
              filename: 'EmployeeList.pdf',
              image: { type: 'jpeg', quality: 0.98 },
              html2canvas: { scale: 2 },
              jsPDF: { unit: 'mm', format: 'a4', orientation: 'landscape' }
            };
            const tableHTML = clonedTable.outerHTML; 
            const combinedHTML = `<div>${data}</div><div>${tableHTML}</div>`;

            html2pdf()
              .set(options)
              .from(combinedHTML)
              .save();
        } else if (format === 'csv') {
            let csv = [];

            clonedTable.querySelectorAll('tr').forEach(function(row) {
                let rowData = [];
                row.querySelectorAll('th, td').forEach(function(cell) {
                    console.log(cell);
                rowData.push(cell.innerText);
                });
                csv.push(rowData.join(','));
            });
            const csvContent = 'data:text/csv;charset=utf-8,' + csv.join(',');
            const encodedUri = encodeURI(csvContent);
            const link = document.createElement('a');
            link.setAttribute('href', encodedUri);
            link.setAttribute('download', 'table.csv');
            document.body.appendChild(link);
            link.click();
        } else if (format === 'excel') {
            var filename = "{{ Session::get('type') }}";
            var downloadLink;
            var dataType = 'application/vnd.ms-excel';
            var tableSelect = clonedTable;
            var tableHTML = tableSelect.outerHTML.replace(/ /g, '%20');
            
            filename = filename?filename+'.xls':'excel_data.xls';
            downloadLink = document.createElement("a");
            
            document.body.appendChild(downloadLink);
            
            if(navigator.msSaveOrOpenBlob){
                var blob = new Blob(['\ufeff', tableHTML], {
                    type: dataType
                });
                navigator.msSaveOrOpenBlob( blob, filename);
            }else{
                downloadLink.href = 'data:' + dataType + ', ' + tableHTML;
                downloadLink.download = filename;
                downloadLink.click();
            }
            window.location.reload(true);
        }
    }

</script>