@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;">
                        Daily Attendance Report
                    </h3>
                </div>

                <div class="panel-body panelBodyView">

                    {!! Form::open([
                        'url' => './report/daily-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: ', ['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('date', 'Date : ', ['class' => 'control-label']) !!}

                                <input type="text" class="form-control input-sm" id="searchDate" name="searchDate"
                                    value="{{ request()->get('searchDate') }}" 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_reports))
                        <div class="table-responsive">
                            <table class="table table-striped table-bordered"
                                style="color:black; border-collapse: collapse;" border="1px solid ash;" width="100%">
                                <thead style="wordbreak: normal;">
                                    <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">Status</th>
                                        <th scope="col">Leave Status</th>
                                    </tr>
                                </thead>

                                <tbody style="color: black !important;">
                                    @php $sl = 1; @endphp
                                    @foreach($employeeInfo as $employee)
                                        @php
                                            $reportRowVisiable = true;
                                            $attendence = $attendence_reports->where('employee_id', $employee->id)
                                                                    ->where('attendenceDate', date('Y-m-d', strtotime($_GET['searchDate'])))
                                                                    ->first();

                                            if($generatedSource && !$attendence) {
                                                $reportRowVisiable = false;
                                            }
                                            else {
                                                $isHoliday = in_array($_GET['searchDate'], $holiDays);                                
                                                $leaveStatus = @$leaves->where('emp_id_fk', $attendence->employee_id)
                                                                ->where('from_date', '<=', date('Y-m-d', strtotime($_GET['searchDate'])))
                                                                ->where('to_date', '>=', date('Y-m-d', strtotime($_GET['searchDate'])))
                                                                ->first()->name;

                                                if($isHoliday) {
                                                    $status = 'Holiday';
                                                }

                                                if($setting_time && $attendence && $attendence->attendenceDate && $attendence->entryTime && $attendence->exitTime) {
                                                    $start = ($attendence->exitTime) ? Carbon\Carbon::parse($attendence->attendenceDate . ' ' . $attendence->exitTime) : '00:00:00';
                                                    $end = ($attendence->entryTime) ? Carbon\Carbon::parse($attendence->attendenceDate . ' ' . $attendence->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 = ($attendence->entryTime) ? Carbon\Carbon::createFromFormat('H:i:s', $attendence->entryTime) : '00:00:00';
                                                    $late = ($start != '00:00:00' && $end != '00:00:00') ? $start->diff($end)->format('%H:%I:%S') : '00:00:00';

                                                    if(!$isHoliday) {
                                                        if(strtotime($setting_time) > strtotime(date('h:i A', strtotime($attendence->entryTime)))) {
                                                            $status = 'Present';
                                                            $late = null;
                                                        } else {
                                                            $absent_time = strtotime($setting_time . '+3hours');
                                                            if (strtotime(date('h:i A', strtotime($attendence->entryTime))) > $absent_time) {
                                                                $status = 'Absent';
                                                            } else {
                                                                $status = 'Late';
                                                            }
                                                        }
                                                    }
                                                }
                                                else {
                                                    $isHoliday = $workingHour = $late = null;
                                                    if(!$leaveStatus) $leaveStatus = null;
                                                    $status = 'Absent';
                                                }
                                            }
                                        @endphp

                                        @if($reportRowVisiable)
                                        <tr>
                                            <td class="text-center">{{ $sl++ }}</td>
                                            <td class="text-center">{{ $employee->emp_id }}</td>
                                            <td>{{ $employee->emp_name_english }}</td>
                                            <td>{{ $employee->gender }}</td>
                                            <td>{{ $employee->designation }}</td>
                                            <td class="text-center">{{ date('d-m-Y', strtotime($_GET['searchDate'])) }}</td>
                                            <td class="text-center">{{ ($attendence && $attendence->entryTime && $attendence->entryTime != '00:00:00') ? date('h:i A', strtotime($attendence->entryTime)) : '--' }}</td>
                                            <td class="text-center">{{ ($attendence && $attendence->exitTime && $attendence->exitTime != '00:00:00') ? date('h:i A', strtotime($attendence->exitTime)) : '--' }}</td>
                                            <td class="text-center">{{ ($workingHour && $workingHour != '00:00:00') ? $workingHour : '--' }}</td>
                                            <td class="text-center">{{ ($late && $late != '00:00:00') ? $late : '--' }}</td>
                                            <td class="text-center">{{ ($attendence && $attendence->attendenceSource) ? $attendence->attendenceSource : '--' }}</td>
                                            <td class="text-center">{{ (!$generatedSource) ? $status : '' }}</td>
                                            <td class="text-center">{{ (!$generatedSource) ? $status : '' }}</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