@extends('hr_main')
@section('title', '| Attendance Report')
@section('content')
    @include('convert_word')

    <div class="row">
        <div class="col-md-12">
            <div class="panel panel-default" style="background-color:#708090;">
                <div class="panel-heading" style="padding-bottom:0px">
                    <div class="panel-options">
                        <button id="printIcon" class="btn btn-info pull-right print-icon" target="_blank" style="">
                            <i class="fa fa-print fa-lg" aria-hidden="true"> Print</i>
                        </button>

                        <button id="btnExportExcel" class="btn btn-info pull-center print-icon" target="_blank"
                            style="">
                            <i class="fa-file-excel-o fa-lg" aria-hidden="true"> Excel</i>
                        </button>
                    </div>
                    <h3 style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">
                        Branch Wise Attendance Report
                    </h3>
                </div>

                <div class="panel-body panelBodyView">

                    {!! Form::open([
                        'url' => './report/branch-wise-attendance-report',
                        'role' => 'form',
                        'class' => 'form-horizontal form-groups',
                        'id' => 'filterFormId',
                        'method' => 'get',
                    ]) !!}

                    <div class="row">
                        <div class="col-md-12">
                            <div class="col-md-2">
                                {!! Form::label('branchName', 'Branch Name : ', ['class' => 'control-label']) !!}

                                {!! Form::select('branchName', $branchList, request()->get('branchName'), [
                                    'class' => 'form-control select2',
                                    'id' => 'branchName',
                                    'name' => 'branchName',
                                    'required' => 'true',
                                    'autocomplete' => 'off',
                                ]) !!}
                            </div>

                            <div class="col-md-2">
                                {!! Form::label('project', 'Project', ['class' => 'control-label']) !!}
                                {!! Form::select('project_id', $projects, $searchProject, [
                                    'class' => 'form-control select2',
                                    'id' => 'project_id',
                                    'name' => 'project_id',
                                ]) !!}
                            </div>

                            @if(isset($generatedSourceTypes))
                            <div class="col-md-2">
                                <label>Attendence Source</label>
                                <select class='form-control' name='generated_source_type' id='generated_source_type'>
                                    @foreach($generatedSourceTypes as $generatedSourceType)
                                        <option value='{{ $generatedSourceType }}' {{ (isset($_GET['generated_source_type']) && $_GET['generated_source_type'] == $generatedSourceType) ? 'selected' : '' }}>{{ $generatedSourceType }}</option>
                                    @endforeach
                                </select>
                            </div>
                            @endif

                            <div class="col-md-2">
                                {!! Form::label('fromDate', 'From Date : ', ['class' => 'control-label']) !!}

                                <input type="text" class="form-control input-sm searchDate" name="fromDate"
                                    value="{{ request()->get('fromDate') }}" autocomplete="off" required>
                            </div>

                            <div class="col-md-2">
                                {!! Form::label('toDate', 'To Date : ', ['class' => 'control-label']) !!}

                                <input type="text" class="form-control input-sm searchDate" name="toDate"
                                    value="{{ request()->get('toDate') }}" autocomplete="off" required>
                            </div>

                            <div class="col-md-2">
                                <div class="form-group">
                                    <input class="btn btn-primary" style="margin-top: 25px;" type="submit" name="Show"
                                        value="Search">
                                </div>
                            </div>
                        </div>
                    </div>

                    {!! Form::close() !!}
                </div>

                <div id="printDiv">

                    @if(isset($_GET['branchName']))
                        <div class="row" style="color: black;">
                            <div class="row"
                                style="padding-bottom: 0px; text-align: center; vertical-align: middle; color: black; font-weight: bold; ">
                                <span style="font-size:14px;">
                                    <br>{{ $report_headers['company'] }}<br>{{ $report_headers['branch'] }}</span><br />
                                <span style="font-size:11px;">{{ $report_headers['company_address'] }}</span><br />
                            </div>
                        </div>
                        <br>

                        <div class="row">
                            <div class="col-md-12" style="font-size: 12px;">
                                <span>
                                    <span style="color: black; float: left;">
                                        <span style="font-weight: bold;">Branch: </span>
                                        <span>{{ $report_headers['branch'] }}</span>
                                    </span>
                                    <span style="color: black; float: right;">
                                        <span style="font-weight: bold;">Reporting Date: </span>
                                        <span>{{ $report_headers['reportOn'] }}</span>
                                    </span>
                                </span>
                                <br>
                                <span>
                                    <span style="color: black; float: left;">
                                        <span style="font-weight: bold;">Project: </span>
                                        <span>{{ $report_headers['project'] }}</span>
                                    </span>
                                    <span style="color: black; float: right;">
                                        <span style="font-weight: bold;">Print Date: </span>
                                        <span>{{ date('d-m-Y H:i A') }}</span>
                                    </span>
                                </span>
                                <br>
                            </div>
                        </div>
                    @endif

                    @if(isset($attendence_infos))
                        <div class="table-responsive">
                            <table class="table table-striped table-bordered" style="color:black; border-collapse: collapse;" border="1px solid ash;" width="100%">
                                <thead>
                                    <tr>
                                        <th scope="col">#</th>
                                        <th scope="col">Emp. No.</th>
                                        <th scope="col">Emp. Name</th>
                                        <th scope="col">Gender</th>
                                        <th scope="col">Designation</th>
                                        <th scope="col">Att. Date</th>
                                        <th scope="col">In Time</th>
                                        <th scope="col">Out Time</th>
                                        <th scope="col">Working Hour</th>
                                        <th scope="col">Late</th>
                                        <th scope="col">Attendence Source</th>
                                        <th scope="col">Branch</th>
                                        <th scope="col">Device</th>
                                        <th scope="col">Status</th>
                                        <th scope="col">Leave Status</th>
                                    </tr>
                                </thead>
                                <tbody style="color: black !important;">
                                    @php $serial = 1; @endphp
                                    @foreach($employees as $employee)
                                        @php $rowGenerateCount = $totalLateCount = $totalLeaveCount = 0; @endphp
                                        @foreach($dates as $key => $date)
                                            @php 
                                                $reportRowVisiable = true;
                                                $dateWiseAttendenceInfo = $attendence_infos->where('employee_id', $employee->emp_id_fk)
                                                                                ->where('attendenceDate', $date)->first();

                                                if($generated_source != 'All' && !$dateWiseAttendenceInfo) {
                                                    $reportRowVisiable = false;
                                                }
                                            @endphp

                                            @if($reportRowVisiable)
                                            @php
                                                $rowGenerateCount = $rowGenerateCount + 1;
                                                $device = $workingHour = $late = $leaveStatus = null;
                                                $status = 'Absent';
                                                
                                                $leaveStatus = @$leaves->where('emp_id_fk', $employee->emp_id_fk)
                                                                    ->where('from_date', '<=', date('Y-m-d', strtotime($date)))
                                                                    ->where('to_date', '>=', date('Y-m-d', strtotime($date)))
                                                                    ->first()->name;

                                                if($dateWiseAttendenceInfo) {
                                                    $device = $devices->whereIn('id', $dateWiseAttendenceInfo->attendenceDeviceId)->first();

                                                    if($setting_time && $dateWiseAttendenceInfo->attendenceDate && $dateWiseAttendenceInfo->entryTime && $dateWiseAttendenceInfo->exitTime) {
                                                        $start = ($dateWiseAttendenceInfo->exitTime) ? Carbon\Carbon::parse($dateWiseAttendenceInfo->attendenceDate . ' ' . $dateWiseAttendenceInfo->exitTime) : '00:00:00';
                                                        $end = ($dateWiseAttendenceInfo->entryTime) ?  Carbon\Carbon::parse($dateWiseAttendenceInfo->attendenceDate . ' ' . $dateWiseAttendenceInfo->entryTime) : '00:00:00';
                                                        $workingHour = ($start != '00:00:00' && $end != '00:00:00') ? $start->diff($end)->format('%H:%I:%S') : '00:00:00';

                                                        $start = ($setting_time) ? Carbon\Carbon::createFromFormat('H:i:s', $setting_time) : '00:00:00';
                                                        $end = ($dateWiseAttendenceInfo->entryTime) ? Carbon\Carbon::createFromFormat('H:i:s', $dateWiseAttendenceInfo->entryTime) : '00:00:00';
                                                        $late = ($start != '00:00:00' && $end != '00:00:00') ? $start->diff($end)->format('%H:%I:%S') : '00:00:00';
                                                        
                                                        if(strtotime($setting_time) > strtotime(date('h:i A', strtotime($dateWiseAttendenceInfo->entryTime)))) {
                                                            $status = 'Present';
                                                            $late = null;
                                                        } else {
                                                            $absent_time = strtotime($setting_time . '+3hours');
                                                            if (strtotime(date('h:i A', strtotime($dateWiseAttendenceInfo->entryTime))) > $absent_time) {
                                                                $status = 'Absent';
                                                            } else {
                                                                $status = 'Late';
                                                            }
                                                        }  
                                                    }
                                                }

                                                if($late != null) $totalLateCount = $totalLateCount + 1;
                                                if($leaveStatus) $totalLeaveCount = $totalLeaveCount + 1;
                                            @endphp
                                            <tr>
                                                <td style='text-align: center'>{{ $serial++ }}</td>
                                                <td style='text-align: center'>{{ @$employee->emp_id }}</td>
                                                <td style='text-align: left'>{{ @$employee->emp_name_english }}</td>
                                                <td style='text-align: left'>{{ @$employee->gender }}</td>
                                                <td style='text-align: left'>{{ @$employee->designation }}</td>
                                                <td style='text-align: center'>{{ date('d-m-Y', strtotime($date)) }}</td>
                                                <td style='text-align: center'>
                                                    {{ ($dateWiseAttendenceInfo && isset($dateWiseAttendenceInfo->entryTime) && $dateWiseAttendenceInfo->entryTime != '00:00:00') 
                                                    ? date('h:i A', strtotime($dateWiseAttendenceInfo->entryTime)) : '--' }}
                                                </td>
                                                <td style='text-align: center'>
                                                    {{ ($dateWiseAttendenceInfo && isset($dateWiseAttendenceInfo->exitTime) && $dateWiseAttendenceInfo->exitTime != '00:00:00') 
                                                    ? date('h:i A', strtotime($dateWiseAttendenceInfo->exitTime)) : '--' }}
                                                </td>
                                                <td style='text-align: center'>{{ (isset($workingHour)) ? $workingHour : '' }}</td>
                                                <td style='text-align: center'>{{ (isset($late)) ? $late : '' }}</td>
                                                <td style='text-align: center'>{{ ($dateWiseAttendenceInfo && isset($dateWiseAttendenceInfo->attendenceSource)) ? $dateWiseAttendenceInfo->attendenceSource : '' }}</td>
                                                <td style='text-align: left'>{{ @$employee->branch }}</td>
                                                <td style='text-align: center'>{{ (isset($device)) ? $device->device_serial_number : '' }}</td>
                                                <td style='text-align: center'>{{ (isset($status) && $generated_source == 'All') ? $status : '' }}</td>
                                                <td style='text-align: center'>{{ (isset($leaveStatus) && $generated_source == 'All') ? $leaveStatus : '' }}</td>
                                            </tr>
                                            @endif
                                        @endforeach

                                        @if($rowGenerateCount != 0)
                                        <tr style="background-color: #FFDCD1;">
                                            <td colspan='9' style='text-align: center'>Total Count</td>
                                            <td style='text-align: center'>{{ $totalLateCount }}</td>
                                            <td colspan='4'></td>
                                            <td style='text-align: center'>{{ $totalLeaveCount }}</td>
                                        </tr>
                                        @endif

                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @endif
                    
                </div>
            </div>
        </div>
    </div>

    <script>
        $(function() {
            $(".searchDate").datepicker({
                format: "dd-mm-yyyy",
                showOtherMonths: true,
                selectOtherMonths: true,
                changeMonth: true,
                changeYear: true,
                yearRange: "-50:+0",
                maxDate: "dateToday"
            }).val();

            $("#printIcon").click(function(event) {
                var printStyle =
                    '<style>#reportingTable{float:left;height:auto;padding:0px;width:100%;font-size:11px;border:1pt solid ash;page-break-inside:auto;font-family: arial!important;} tr:last-child { font-weight: bold;} thead tr th{ text-align:center;vertical-align: middle;padding:3px;font-size:11px;} tbody tr td { text-align:center;vertical-align: middle;padding:3px ;font-size:10px;} tr{ page-break-inside:avoid; page-break-after:auto } </style><style media="print">@page{size:portrait;margin:10mm 10mm;}</style><style>@media print {.element-that-contains-table { overflow: visible !important; }}</style><style>@page:first{tr:nth-of-type(4n){page-break-after: always;}}</style>';
                var mainContents = document.getElementById("printDiv").innerHTML;
                var headerContents = '';
                var footerContents =
                    "<div class='row' style='font-size:12px; padding-left:5px; padding-top:20px;'>Prepared By <span style='display:inline-block; width: 35%; padding-top:40px;'></span> Checked By <span style='display:inline-block; width: 34%; padding-right:15px; padding-top:40px;'></span>Approved By</div>";
                var printContents = '<div id="order-details-wrapper" style="padding: 10px;">' +
                    headerContents + printStyle + mainContents /*+ paddingDiv*/ + footerContents + '</div>';
                var win = window.open('', 'printwindow');
                win.document.write(printContents);
                win.print();
                win.close();
            });
        })
    </script>

    <script type="text/javascript">
        $(document).ready(function() {

            $("#branchName").change(function(e) {
                $('#project_id').select2('val', '');
            });
            
            $("#btnExportExcel").click(function(e) {
                var today = new Date();
                var dd = today.getDate();

                var mm = today.getMonth() + 1;
                var yyyy = today.getFullYear();
                if (dd < 10) {
                    dd = '0' + dd;
                }

                if (mm < 10) {
                    mm = '0' + mm;
                }
                today = dd + '-' + mm + '-' + yyyy;

                let file = new Blob([$('#printDiv').html()], {
                    type: "application/vnd.ms-excel"
                });
                let url = URL.createObjectURL(file);
                let a = $("<a />", {
                    href: url,
                    download: "Daily Attendance Report _" + today + ".xls"
                }).appendTo("body").get(0).click();
                e.preventDefault();
            });
        });
    </script>
@endsection