{{ View::make('layout.header') }}

<style>

    .table thead th {

        /* padding: 8px 10px !important; */

    }



    a.disable {

        pointer-events: none;

    }

</style>



<!-- BEGIN: Content-->

<div class="app-content content ">

    <div class="content-overlay"></div>

    <div class="header-navbar-shadow"></div>

    <div class="content-wrapper">

        <div class="content-header row">

            <div class="content-header-left col-md-9 col-12 mb-2">

                <div class="row breadcrumbs-top">

                    <div class="col-12">

                        <div class="breadcrumb-wrapper">

                            <ol class="breadcrumb mt-3">

                                <li class="breadcrumb-item">HR



                                </li>

                                <li class="breadcrumb-item ">Reports

                                </li>

                                <li class="breadcrumb-item active"><a href="{{ route('reports.time-card') }}">Electronic

                                        Time Card</a>

                                </li>

                            </ol>

                        </div>

                    </div>

                </div>

            </div>

        </div>

        <div class="content-body">

            <section id="dashboard-ecommerce">

                <div class="row match-height">

                    <div class="col-md-12">

                        <div class="card">

                            <div class="card-header" style="">

                                <div class="">



                                </div>



                                <div class="d-flex align-items-right">

                                    <div class="btn-group btn-align-right MiniRightnav">



                                        <a onclick="exportpdf()" class="text-danger"><i

                                                class="fa fa-file-pdf-o report-download-btn"

                                                style="font-size:25px;"></i><span>Download PDF</span></a>

                                        &nbsp;&nbsp;

                                        <a onclick="exportexcel()" class="text-success"><i

                                                class="fa fa-file-excel-o report-download-btn"

                                                style="font-size:25px;"></i><span>Download Excel</span></a>

                                    </div>

                                </div>



                                <div class="card activity filter-container"

                                    style="margin: 0px 15px; background-color:#e6e5e5; padding:10px 20px 20px 20px; display:none !important;"

                                    id="empleavetoday">

                                    <div class="row">

                                        <div class="col-md-12" style="padding:0px;">

                                            <button id="spanclose" onclick="more_filter()"

                                                style="float:right;border:0px;background-color:transparent;color:white;padding: 3px 8px 5px;">

                                                <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"

                                                    viewBox="0 0 24 24" fill="none" stroke="currentColor"

                                                    stroke-width="2" stroke-linecap="round" stroke-linejoin="round"

                                                    class="feather feather-x cursor-pointer font-large-1"

                                                    data-repeater-delete="">

                                                    <line x1="18" y1="6" x2="6" y2="18">

                                                    </line>

                                                    <line x1="6" y1="6" x2="18" y2="18">

                                                    </line>

                                                </svg>

                                            </button>

                                        </div>

                                    </div>

                                    <div class="row">

                                        <div class="col-sm-3 filter-form-group mb-1">

                                            Department &nbsp;:&nbsp;

                                            <select name="department" id="department" class="form-control">

                                                <option value="">Department</option>

                                                @foreach ($departments as $department)

                                                    <option value="{{ $department->id }}">{{ $department->name }}

                                                    </option>

                                                @endforeach

                                            </select>

                                        </div>

                                        <div class="col-sm-3 filter-form-group mb-1">

                                            Branch &nbsp;:&nbsp;

                                            <select name="branch" id="branch" class="form-control">

                                                <option value="">Branch</option>

                                                @foreach ($branches as $branch)

                                                    <option value="{{ $branch->id }}">{{ $branch->name }}</option>

                                                @endforeach

                                            </select>

                                        </div>

                                        <div class="col-sm-3 filter-form-group mb-1">

                                            Category &nbsp;:&nbsp;

                                            <select name="category" id="category" class="form-control">

                                                <option value="">Category</option>

                                                @foreach ($categories as $category)

                                                    <option value="{{ $category->id }}">{{ $category->name }}</option>

                                                @endforeach

                                            </select>

                                        </div>

                                        <div class="col-sm-3 filter-form-group mb-1">

                                            Date From &nbsp;:

                                            <input type="date" name="sdatefrom" id="sdatefrom"

                                                class="tcal form-control flatpickr-basic" placeholder="DD-MM-YYYY"

                                                data-dateformat="dd-mm-yy">

                                        </div>

                                        <div class="col-sm-3 filter-form-group mb-1">

                                            Date To &nbsp;:<span class="red">*</span>&nbsp;

                                            <input type="date" name="sdateto" id="sdateto"

                                                class="tcal form-control flatpickr-basic" placeholder="DD-MM-YYYY"

                                                data-dateformat="dd-mm-yy">

                                        </div>

                                        <div class="col-sm-3 filter-form-group mb-1">

                                            Schedule &nbsp;:&nbsp;

                                            <select name="schedule" id="schedule" class="form-control">

                                                <option value="">Schedule</option>

                                                @foreach ($schedules as $schedule)

                                                    <option value="{{ $schedule->id }}">{{ $schedule->name }}</option>

                                                @endforeach

                                            </select>

                                        </div>

                                        <div class="col-sm-3 filter-form-group mb-1">

                                            Day Type &nbsp;:&nbsp;

                                            <select name="day_type" id="day_type" class="form-control">

                                                <option value="">Day Type</option>

                                                <option value="Work">Work</option>

                                                <option value="Rest">Rest</option>

                                                <option value="Flexi">Flexi</option>

                                            </select>

                                        </div>

                                        <div class="col-sm-6 filter-form-group" style="margin-top:19px;">

                                            <input type="button" value="Apply" onclick="getfilterdata();"

                                                class="filter-apply btn btn-info" />

                                        </div>

                                    </div>

                                </div>



                            </div>





                            <div class="p-2">

                                <h1>Electronic Time Card</h1>

                            </div>



                            @foreach ($pageData as $data)

                                <table width="100%" style="text-align: center">

                                    <tr>

                                        <td width="25%">Name = {{ $data['personname'] }}</td>

                                        <td width="25%">Emp No. = {{ $data['employee_no'] }}</td>

                                        <td width="25%">√ = Excused</td>

                                        <td width="25%">Date : {{ date('d-m-Y', strtotime($data['start_date'])) }}

                                            -

                                            {{ date('d-m-Y', strtotime($data['end_date'])) }}

                                        </td>

                                    </tr>

                                </table>



                                <div class="card-body" style="padding-top:0px !important; ">

                                    <div class="table-responsive " style="overflow-x: scroll !important;">

                                        <table class="table" id="reporttable" style=" font-size:12px;">

                                            <thead>

                                                <tr>

                                                    <th>Date</th>

                                                    <th>Day</th>

                                                    <th>Type</th>

                                                    <th>Schedule</th>



                                                    <th>In</th>

                                                    <th>Break</th>

                                                    <th>Resume</th>

                                                    <th>Out</th>



                                                    <th>Work</th>

                                                    <th>Overtime</th>

                                                    <th>Short</th>

                                                    <th>Request</th>

                                                    <th>Leave</th>



                                                    <th>Remark</th>

                                                </tr>

                                            </thead>

                                            <tbody>



                                                @foreach ($data['att'] as $attData)

                                                    @if ($attData)

                                                        <tr

                                                            @if ($attData['day_type'] == 'Rest') style="background-color: #F5F5F5;" @endif>

                                                            <td style="padding:0px !important;">

                                                                {{ date('d-m-Y', strtotime($attData['date'])) ?? null }}

                                                            </td>

                                                            <td>

                                                                {{ \Carbon\Carbon::parse($attData['date'])->format('l') ?? null }}

                                                            </td>

                                                            <td>{{ $attData['day_type'] ?? null }}</td>

                                                            <td>{!! html_entity_decode($attData['sche']) ?? null !!}</td>

                                                            <td><span

<span style="color: {{ $attData['in_color'] ?? 'black' }}; font-weight: {{ $attData['in_font_weight'] ?? 'normal' }};">{{ $attData['in_time'] ?? null }}</span>

                                                            </td>



                                                            <td><span

<span style="color: {{ $attData['lunch_color'] ?? 'black' }}; font-weight: {{ $attData['break_font_weight'] ?? 'normal' }};">{{ $attData['break_time'] ?? null }}</span>

                                                            </td>

                                                            <td><span

<span style="color: {{ $attData['lunch_color'] ?? 'black' }}; font-weight: {{ $attData['resume_font_weight'] ?? 'normal' }};">{{ $attData['resume_time'] ?? null }}</span>

                                                            </td>



                                                            <td><span

<span style="color: {{ $attData['out_color'] ?? 'black' }}; font-weight: {{ $attData['out_font_weight'] ?? 'normal' }};">{{ $attData['out_time'] ?? null }}</span>

                                                            </td>

                                                            <td>{{ $attData['work'] ?? null }}</td>

                                                            <td>{{ $attData['overtime'] == '00:00' ? null : $attData['overtime'] }}

                                                            </td>

                                                            <td style="color: red">{{(isset($attData['short'])&&$attData['short']!="00:00") ?$attData['short']:""}}

                                                            </td>

                                                            <td>{{ $attData['ot_approved']!="00:00" ? $attData['ot_approved']:"" }}</td>

                                                            <td>{{ $attData['leave_taken'] ?? null }}</td>

                                                            <td>{{ $attData['remark'] ?? null }}</td>

                                                        </tr>

                                                    @endif

                                                @endforeach



                                            </tbody>

                                        </table>

                                    </div>

                                </div>



                                @php

                                    $workDays = 0;

                                    $flexiDays = 0;

                                    $holidays = 0;

                                    $holiday = 0;

                                    $workDayPresent = 0;

                                    $flexiDayPresent = 0;

                                    $holidayPresent = 0;

                                    $holidayPresents = 0;

                                    $workDayHours = 0;

                                    $flexiDayHours = 0;

                                    $holidayHours = 0;

                                    $holidayHour = 0;

                                    $workDayOvertimeHours = 0;

                                    $flexiOvertimeHours = 0;

                                    $holiOvertimeHours = 0;

                                    $workDayShortHours = 0;

                                    $flexiShortHours = 0;

                                    $holiShortHours = 0;

                                @endphp


                                @php
                                $rest_day_overtime = 0;
                                $holiday_day_overtime = 0;
                                @endphp
                                @foreach ($data['att'] as $attData)

                                    @php
                                        
                                        if (isset($attData['day_type']) && $attData['day_type'] == 'Work') {

                                            $workDays += 1;

                                            if ((isset($attData['in_time']) && $attData['in_time'] != '00:00' && $attData['in_time'] != null) || $attData['break_time'] || $attData['resume_time'] || $attData['out_time']) {

                                                $workDayPresent += 1;

                                            }



                                            if (isset($attData['work'])) {

                                                $workDayHours = second_to_hhmm(explode_time($workDayHours) + explode_time($attData['work']));



                                                $glbSettingType = DB::table('settings')

                                                    ->where('field', 'workday_round_type')

                                                    ->first();

                                                $glbSettingMin = DB::table('settings')

                                                    ->where('field', 'workday_round_min')

                                                    ->first();

                                                if ($glbSettingType && $glbSettingMin && isset($workDayHours) && $workDayHours != '' && $workDayHours != null && $workDayHours != '00:00') {

                                                    if ($glbSettingType->value == 'up') {

                                                        $workDayHours = roundUpNearestMinuteInterval($workDayHours, $glbSettingMin->value);

                                                    } elseif ($glbSettingType->value == 'down') {

                                                        $workDayHours = roundDownNearestMinuteInterval($workDayHours, $glbSettingMin->value);

                                                    }

                                                }

                                            }



                                            if (isset($attData['overtime'])) {

                                                $workDayOvertimeHours = second_to_hhmm(explode_time($workDayOvertimeHours) + explode_time($attData['overtime']));

                                            }



                                            if (isset($attData['short'])) {

                                                $workDayShortHours = second_to_hhmm(explode_time($workDayShortHours) + explode_time($attData['short']));

                                            }

                                        }



                                        if (isset($attData['day_type']) && $attData['day_type'] == 'Flexi') {

                                            $flexiDays += 1;

                                            if ((isset($attData['in_time']) && $attData['in_time'] != '00:00' && $attData['in_time'] != null) || $attData['break_time'] || $attData['resume_time'] || $attData['out_time']) {

                                                $flexiDayPresent += 1;

                                            }



                                            if (isset($attData['work'])) {

                                                $flexiDayHours = second_to_hhmm(explode_time($flexiDayHours) + explode_time($attData['work']));

                                            }



                                            if (isset($attData['overtime'])) {

                                                $flexiOvertimeHours = second_to_hhmm(explode_time($flexiOvertimeHours) + explode_time($attData['overtime']));

                                            }



                                            if (isset($attData['short'])) {

                                                $flexiShortHours = second_to_hhmm(explode_time($flexiShortHours) + explode_time($attData['short']));

                                            }

                                        }



                                        if ((isset($attData['day_type']) && $attData['day_type'] == 'Rest')) {

                                            $holidays += 1;

                                            if ((isset($attData['in_time']) && $attData['in_time'] != '00:00' && $attData['in_time'] != null) || $attData['break_time'] || $attData['resume_time'] || $attData['out_time']) {

                                                $holidayPresent += 1;

                                            }

                                            

                                            if (isset($attData['work'])) {
                                                if(isset($attData['overtime']) && ($attData['overtime']!='') && ($attData['overtime']!='00:00')){
                                                    $rest_day_overtime=$rest_day_overtime+abs(explode_time($attData['overtime']));
                                                }
                                                
                                                $holidayHours = second_to_hhmm(explode_time($holidayHours) + abs(explode_time($attData['work'])));
                                                


                                                $glbSettingType = DB::table('settings')

                                                    ->where('field', 'restday_round_type')

                                                    ->first();

                                                $glbSettingMin = DB::table('settings')

                                                    ->where('field', 'restday_round_min')

                                                    ->first();

                                                if ($glbSettingType && $glbSettingMin && isset($holidayHours) && $holidayHours != '' && $holidayHours != null && $holidayHours != '00:00') {

                                                    if ($glbSettingType->value == 'up') {

                                                        $holidayHours = roundUpNearestMinuteInterval($holidayHours, $glbSettingMin->value);

                                                    } elseif ($glbSettingType->value == 'down') {

                                                        $holidayHours = roundDownNearestMinuteInterval($holidayHours, $glbSettingMin->value);

                                                    }

                                                }

                                            }



                                            if (isset($attData['overtime'])) {

                                                $holiOvertimeHours = second_to_hhmm(explode_time($holiOvertimeHours) + explode_time($attData['overtime']));

                                            }



                                            if (isset($attData['short'])) {

                                                $holiShortHours = second_to_hhmm(explode_time($holiShortHours) + explode_time($attData['short']));

                                            }

                                        }



                                        if ((isset($attData['day_type']) && $attData['day_type'] == "Holiday")) {

                                            

                                            $holiday += 1;

                                            if ((isset($attData['in_time']) && $attData['in_time'] != '00:00' && $attData['in_time'] != null) || $attData['break_time'] || $attData['resume_time'] || $attData['out_time']) {

                                                $holidayPresents += 1;

                                            }



                                            if (isset($attData['work'])) {
                                                if(isset($attData['overtime']) && ($attData['overtime']!='') && ($attData['overtime']!='00:00')){
                                                    $holiday_day_overtime=$holiday_day_overtime+abs(explode_time($attData['overtime']));
                                                }
                                                $holidayHour = second_to_hhmm(explode_time($holidayHour) + abs(explode_time($attData['work'])));



                                                $glbSettingType = DB::table('settings')

                                                    ->where('field', 'restday_round_type')

                                                    ->first();

                                                $glbSettingMin = DB::table('settings')

                                                    ->where('field', 'restday_round_min')

                                                    ->first();

                                                if ($glbSettingType && $glbSettingMin && isset($holidayHour) && $holidayHour != '' && $holidayHour != null && $holidayHour != '00:00') {

                                                    if ($glbSettingType->value == 'up') {

                                                        $holidayHour = roundUpNearestMinuteInterval($holidayHour, $glbSettingMin->value);

                                                    } elseif ($glbSettingType->value == 'down') {

                                                        $holidayHour = roundDownNearestMinuteInterval($holidayHour, $glbSettingMin->value);

                                                    }

                                                }

                                            }



                                            if (isset($attData['overtime'])) {

                                                $holiOvertimeHours = second_to_hhmm(explode_time($holiOvertimeHours) + explode_time($attData['overtime']));

                                            }



                                            if (isset($attData['short'])) {

                                                $holiShortHours = second_to_hhmm(explode_time($holiShortHours) + explode_time($attData['short']));

                                            }

                                        }

                                    @endphp

                                @endforeach



                                <br>

                                <div class="card-body row" style="padding-top:0px !important; ">

                                    <div class="col-md-6">

                                        <div class="table-responsive" style="overflow-x: scroll !important;">

                                            <table class="table" id="reporttable" style=" font-size:12px;">

                                                <thead>

                                                    <tr>

                                                        <th>Day Type</th>

                                                        <th>Total Days</th>

                                                        <th>Present</th>

                                                        <th>Work</th>

                                                        <th>Overtime</th>

                                                        <th>Short</th>

                                                    </tr>

                                                </thead>



                                                <tbody>

                                                    <tr>

                                                        <td>Workday</td>

                                                        <td>{{ $workDays }}</td>

                                                        <td>{{ $workDayPresent }}</td>

                                                        <td> {{ $workDayHours == '00:00' ? 0 : $workDayHours }}</td>

                                                        <td> {{ $workDayOvertimeHours == '00:00' ? 0 : $workDayOvertimeHours }}

                                                        </td>

                                                        <td> {{ $workDayShortHours == '00:00' ? 0 : $workDayShortHours }}

                                                        </td>

                                                    </tr>

                                                    <tr>

                                                        <td>FlexiDay</td>

                                                        <td>{{ $flexiDays }}</td>

                                                        <td>{{ $flexiDayPresent }}</td>

                                                        <td>{{ $flexiDayHours == '00:00' ? 0 : $flexiDayHours }}</td>

                                                        <td>{{ $flexiOvertimeHours == '00:00' ? 0 : $flexiOvertimeHours }}

                                                        </td>

                                                        <td>{{ $flexiShortHours == '00:00' ? 0 : $flexiShortHours }}

                                                        </td>

                                                    </tr>

                                                    <tr>

                                                        <td>RestDay</td>

                                                        <td>{{ $holidays }}</td>

                                                        <td>{{ $holidayPresent }}</td>

                                                        <td>{{ $holidayHours == '00:00' ? 0 : $holidayHours }}</td>

                                                        <!-- <td>{{ $holiOvertimeHours == '00:00' ? 0 : $holiOvertimeHours }} -->
                                                        <td>{{ second_to_hhmm($rest_day_overtime) == '00:00' ? 0 : second_to_hhmm($rest_day_overtime) }}

                                                        </td>

                                                        <td>{{ $holiShortHours == '00:00' ? 0 : $holiShortHours }}

                                                        </td>

                                                    </tr>

                                                    <tr>

                                                        <td>HoliDay</td>

                                                        <td>{{ $holiday }}</td>

                                                        <td>{{ $holidayPresents }}</td>

                                                        <td>{{ $holidayHour == '00:00' ? 0 : $holidayHour }}</td>

                                                        <!-- <td>{{ $holiOvertimeHours == '00:00' ? 0 : $holiOvertimeHours }} -->
                                                        <td>{{ second_to_hhmm($holiday_day_overtime) == '00:00' ? 0 : second_to_hhmm($holiday_day_overtime) }}

                                                        </td>

                                                        <td>{{ $holiShortHours == '00:00' ? 0 : $holiShortHours }}

                                                        </td>

                                                    </tr>

                                                </tbody>



                                                <tbody>

                                                    <tr>

                                                        <td>Total</td>

                                                        <td>{{ $workDays + $flexiDays + $holidays + $holiday }}</td>

                                                        <td>{{ $workDayPresent + $flexiDayPresent + $holidayPresent + $holidayPresents }}

                                                        </td>

                                                        <td>

                                                            @php

                                                                $totalWorkDayHrs = second_to_hhmm(explode_time($workDayHours) + explode_time($flexiDayHours) + explode_time($holidayHours));

                                                            @endphp

                                                            {{ $totalWorkDayHrs == '00:00' ? 0 : $totalWorkDayHrs }}

                                                        </td>

                                                        <td>

                                                            @php

                                                                $totalWorkDayOvertimeHrs = second_to_hhmm(explode_time($workDayOvertimeHours) + explode_time($flexiOvertimeHours) + explode_time($holiOvertimeHours));

                                                            @endphp

                                                            {{ $totalWorkDayOvertimeHrs == '00:00' ? 0 : $totalWorkDayOvertimeHrs }}

                                                        </td>

                                                        <td>

                                                            @php

                                                                $totalWorkDayShortHR = second_to_hhmm(explode_time($workDayShortHours) + explode_time($flexiShortHours) + explode_time($holiShortHours));

                                                            @endphp

                                                            {{ $totalWorkDayShortHR == '00:00' ? 0 : $totalWorkDayShortHR }}

                                                        </td>

                                                    </tr>

                                                </tbody>

                                            </table>

                                        </div>

                                    </div>

                                    <div class="col-md-6">

                                        <div class="table-responsive row" style="overflow-x: scroll !important;">



                                            <table class="table" id="reporttable" style=" font-size:12px;">

                                                <thead>

                                                    <tr>

                                                        <th>Leave Type</th>

                                                        <th>Total</th>



                                                    </tr>

                                                </thead>



                                                <tbody>

                                                    @php

                                                        $leaveCount = 0;

                                                    @endphp

                                                    @foreach ($leaveNames as $lv)

                                                                        <tr>

                                                            @php

                                                                $leaveType = $lv->type;

                                                                $leaveName = $lv->name;

                                                            @endphp

                                                            <td>{{ $leaveName }}</td>

                                                            <td>

                                                                @php

                                                                    $leaveList = array_filter($data['att'], function ($value) use ($leaveType) {

                                                                        if (isset($value['leave_taken'])) {

                                                                            return $leaveType == $value['leave_taken'];

                                                                        }

                                                                    });



                                                                    $leaveCount += count($leaveList);

                                                                @endphp

                                                                {{ count($leaveList) }}

                                                            </td>

                                                        </tr>

                                                    @endforeach

                                                </tbody>



                                                <tbody>

                                                    <tr>

                                                        <td>Total</td>

                                                        <td>{{ $leaveCount }}</td>

                                                    </tr>

                                                </tbody>

                                            </table>

                                        </div>

                                    </div>

                                </div>



                                <br>

                            @endforeach



                        </div>

                    </div>

                </div>

            </section>

        </div>

    </div>

</div>

<!-- END: Content-->

{{ View::make('layout.footer') }}

@include('E-Attendance.edit_attendance')

<script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script>

<script type="text/javascript"></script>

<script type="text/javascript">

    // var base_url = $('body').attr('data-baseurl') + '/e-attendance';

    // $(document).ready(function() {

    //     getfilterdata();

    // });







    // excel download option



    function exportexcel() {

        var exportdata = [];

        $('.singleSelectBox').each(function() {

            if ($(this).is(":checked")) {

                exportdata.push($(this).val());

            }

        });

        exportdata = exportdata.toString();



        var branch = $("#branch").val();

        var department = $("#department").val();

        var category = $("#category").val();

        let url = "time-card-excel";

        var curl = window.location.toString();

        var nurl = location.href.replace('/view-time-card?', '/time-card-excel?');



        window.location.href = nurl;



    }



    // pdf download option



    function exportpdf() {

        var exportdata = [];

        $('.singleSelectBox').each(function() {

            if ($(this).is(":checked")) {

                exportdata.push($(this).val());

            }

        });

        exportdata = exportdata.toString();

        var branch = $("#branch").val();

        var department = $("#department").val();

        var category = $("#category").val();

        let url = "time-card-pdf";

        var curl = window.location.toString();

        var nurl = location.href.replace('/view-time-card?', '/time-card-pdf?');



        window.location.href = nurl;



    }



    // pdf download option







    var x = document.getElementById("empleavetoday");

    x.style.display = "none";



    function more_filter() {

        var x = document.getElementById("empleavetoday");

        if (x.style.display === "none") {

            x.style.display = "block";

        } else {

            x.style.display = "none";

        }

    }

</script>