@extends('layouts.admin')

@push('styles')
    <link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">
    <style type="text/css">
        .btn_mt {
            margin-top: 31px;
        }
    </style>
@endpush

@section('content')
    <!-- Main content -->
    <section class="content">
        <div class="container-fluid mt-4">
            <div class="col-md-12">
                <!-- general form elements -->
                <div class="card card-info">

                    <!-- form start -->
                    <form method="GET" action="{{ route('salary.create') }}">
                        <div class="card-body">

                            <div class="row">

                                <div class="col-sm-2">
                                    <div class="form-group">
                                        <label for="department_id">Department</label>

                                        <select name="department_id" id="department_id" class="form-control form-control-sm select2" value=""
                                            style="width: 100%;">
                                            <option value="">Select Department</option>
                                            @foreach ($departments as $v)
                                                <option value="{{ $v->id }}"
                                                    {{ isset($department_id) && ($department_id == $v->id) ? 'selected' : '' }} >
                                                    {{ $v->department_name }}</option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>

                                <div class="col-sm-2">
                                    <div class="form-group">
                                        <label for="designation_id">Designation</label>

                                        <select name="designation_id" id="designation_id" class="form-control form-control-sm select2" value=""
                                            style="width: 100%;">
                                            <option value="">Select Designation</option>
                                            @foreach ($designations as $v)
                                                <option value="{{ $v->id }}"
                                                    {{ isset($designation_id) && ($designation_id == $v->id) ? 'selected' : '' }}>
                                                    {{ $v->designation }}</option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>

                                <div class="col-sm-2">
                                    <div class="form-group">
                                        <label for="emp_id">Employee</label>

                                        <select id="emp_id" name="emp_id" class="form-control form-control-sm select2"
                                            value="" style="width: 100%;">
                                            <option value="">Select Employee</option>
                                            @foreach ($employees as $v)
                                                <option value="{{ $v->id }}"
                                                    {{ isset($emp_id) && $emp_id == $v->id ? 'selected' : '' }}>
                                                    {{ $v->emp_name }}</option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>

                                <div class="col-sm-2">
                                    <div class="form-group">
                                        <label for="emp_id">Salary Month:</label>

                                        <select class="form-control form-control-sm" id="month" name="month" required>

                                           @php
                                               
                                            $monthNames = [
                                                ["short" => "",   "full" => "Select Month"],
                                                ["short" => "01", "full" => "January"],
                                                ["short" => "02", "full" => "February"],
                                                ["short" => "03", "full" => "March"],
                                                ["short" => "04", "full" => "April"],
                                                ["short" => "05", "full" => "May"],
                                                ["short" => "06", "full" => "June"],
                                                ["short" => "07", "full" => "July"],
                                                ["short" => "08", "full" => "August"],
                                                ["short" => "09", "full" => "September"],
                                                ["short" => "10", "full" => "October"],
                                                ["short" => "11", "full" => "November"],
                                                ["short" => "12", "full" => "December"],
                                            ];

                                            @endphp

                                            @foreach ($monthNames as $mon)
                                                <option value="{{ $mon['short'] }}" {{ isset($month) && ($mon['short'] == $month) ? 'selected' : '' }}>
                                                    {{ $mon['full'] }}
                                                </option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>

                                <div class="col-sm-2">
                                    <div class="form-group">
                                        <label for="emp_id">Salary Year:</label>

                                        <select class="form-control form-control-sm" name="year" id="year" required>
                                            @php
                                                $startYear = 2023; // Change to your desired start year
                                                $endYear = date('Y'); // Current year
                                            @endphp

                                            @for ($yer = $endYear; $yer >= $startYear; $yer--)
                                                <option value="{{ $yer }}" {{ isset($year) && ($yer == $year ) ? 'selected' : '' }}>
                                                    {{ $yer }}
                                                </option>
                                            @endfor
                                        </select>

                                    </div>
                                </div>

                                <div class="col-sm-2">
                                    <div class="form-group">
                                        <label for="search"></label>
                                        <button type="submit" class="btn btn-info btn-sm btn_mt">Generate</button>
                                        <a href="{{ route('salary.create') }}"
                                            class="btn btn-secondary btn-sm btn_mt">Refresh</a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <div class="row">
                <!-- left column -->
                <div class="col-md-12">
                    <!-- jquery validation -->
                    <div class="card card-info">
                        <div class="card-header">
                            <h3 class="card-title">Create Salary</h3>

                            <a href="{{ route('salary.index') }}" style="float: right;padding: 3px 26px;"
                                class="btn btn-outline-dark btn-flat">Salary List</a>

                        </div>
                        <!-- /.card-header -->
                        <!-- form start -->

                        <form id="employeeForm" method="POST" action="{{ route('salary.store') }}" enctype="multipart/form-data">

                            @csrf

                            <input type="hidden" value="{{ $month }}" id="salary_month" name="salary_month" required>
                            <input type="hidden" value="{{ $year }}" id="salary_year" name="salary_year" required>

                            <div class="card-body" style="padding: 0 20px;display: none;">
                                <div class="table-responsive">

                                    <table class="table table-stripe">
                                        <tr>
                                            <td> Pay Date: </td>
                                            <td>
                                                <input type="date" class="form-control form-control-sm" name="pay_date" value="{{ old('pay_date.0') ? old('pay_date.0') : date('Y-m-d') }}" placeholder="Pay Date.." tabindex="1" required>
                                            </td>


                                          <td>Note: </td>
                                            <td>
                                                
                                             <textarea class="form-control" id="note" name="note" rows="1" placeholder="Note"></textarea>


                                            </td>


                                        </tr>

                                    </table>
                                    
                                </div>
                            </div>

                            <div class="card-body">
                                <div class="table-responsive">
                                     <table class="table table-bordered table-sm">
                                        <thead>
                                            <tr>
                                                <th rowspan="2">SL</th>
                                                <th rowspan="2">Emp.ID</th>
                                                <th rowspan="2">Emp.Name</th>
                                                <th rowspan="2">Department</th>
                                                <th rowspan="2">Designation</th>
                                                <th rowspan="2">Mobile No</th>
                                                <th rowspan="2">Joining Date </th>
                                                <th rowspan="2">Gross Salary</th>
                                                <th rowspan="2">Basic</th>
                                                <th rowspan="2">House Rent</th>
                                                <th rowspan="2">Medical</th>
                                                <th rowspan="2">Travel Allowance</th>
                                                <th rowspan="2">Food Allowance</th>

                                                <th colspan="3" style="text-align: center;">Work Day</th>

                                                <th colspan="3" style="text-align: center;">Overtime</th>

                                                <th rowspan="2">Absent (Deda. Amt.)</th>
                                                <th rowspan="2">Allownce</th>
                                                <th rowspan="2">Payable Net Salary</th>

                                                <th rowspan="2">Loan given</th>
                                                <th rowspan="2">Loan Adj.</th>
                                                <th rowspan="2">Stamp Deduc</th>
                                                <th rowspan="2">Payable Net Amount</th>
                                                <th rowspan="2">Signature</th>
                                                <th rowspan="2">Comments</th>
                                                <th rowspan="2">Paid Date</th>
                                                <th rowspan="2"> Action</th>

                                            </tr>

                                            <tr>

                                                <th>Days</th>
                                                <th>Absent</th>
                                                <th>Total</th>

                                                <th>Hr</th>
                                                <th>Rt</th>
                                                <th>Total</th>
                                                
                                            </tr>

                                        </thead>
                                        <tbody>
                                            @if ( count($empList) > 0 )
                                                @php
                                                    $sl = 1;

                                                @endphp

                                                @foreach ($empList as $key => $emp)

                                                    @php

                                                    $where = [];
                                                    $where[] = ['salaries.emp_id','=',$emp->id];
                                                    $where[] = ['salaries.salary_month', '=', $month];
                                                    $where[] = ['salaries.salary_year', '=', $year];

                                                    $check = Helper::findData('salaries', $where);

                                                    if ($check) {

                                                        continue;

                                                    }

                                                    $gross_salary = $emp->salary;


                                                    if(isset($month) && isset($year) && !empty($month) && !empty($year)){


                                                        $uinc = Helper::updateIncrement($month,$year,$emp->id);

                                                        if($uinc){

                                                          $current_salary = $uinc->current_salary;
                                                          $inc_salary = $uinc->inc_salary;

                                                          $gross_salary = $emp->salary + $inc_salary;

                
                                                        }

                                                    }


                                                    $medical = 600;
                                                    $travelAllowance = 350;
                                                    $foodAllowance = 900;

                                                    $basic = ($gross_salary - $medical - $travelAllowance - $foodAllowance) / 1.5;
                                                    $basic = round($basic);

                                                    $houseRent = $basic * 0.5;
                                                    $houseRent = round($houseRent);

                                                    $workDay = 30;

                                                    $absent = 0;

                                                    $total_overtime = 0;
                                                    $hr = 0;
                                                    $rt = 0;

                                                    $abs_deda_amt = ($gross_salary / 30) * $absent;

                                                    $allownce = 0;

                                                    $payable_net_salary = $gross_salary + $total_overtime -  $abs_deda_amt + $allownce;

                                                    $loan_given = 0;
                                                    $loan_adj = 0;
                                                    $stamp_deduc = 0;

                                                    $payable_net_amount = 0;
                                                    $signature = '';

                                                    $payable_net_amt = $payable_net_salary + $loan_given - $loan_adj - $stamp_deduc;

                                                    @endphp


                                                    <tr>
                                                        <td>

                                                        <input type="hidden" name="emp_id[]" value="{{ $emp->id }}">
                                                        <input type="hidden" name="dpt_id[]" value="{{ $emp->dpt_id }}">
                                                        <input type="hidden" name="designation_id[]" value="{{ $emp->designation_id }}">

                                                    <input type="hidden" name="medical[]" value="{{ $medical }}">
                                                    <input type="hidden" name="travelAllowance[]" value="{{ $travelAllowance }}">
                                                    <input type="hidden" name="foodAllowance[]" value="{{ $foodAllowance }}">
                                                    <input type="hidden" name="houseRent[]" value="{{ $houseRent }}">

                                                        {{ $sl++ }}
                                                        </td>
                                                        <td> {{ $emp->emp_id }} </td>
                                                        <td>{{ $emp->emp_name }}</td>
                                                        <td>{{ $emp->department_name }}</td>
                                                        <td>{{ $emp->designation }}</td>
                                                        <td>{{ $emp->phone }}</td>
                                                        <td>{{ Helper::dateFormate($emp->joining_date) }}</td>
                                                        <td>
                                                            <input type="hidden" name="gross_salary[]" class="gross_salary" value="{{ $gross_salary }}">
                                                            {{ $gross_salary }} 
                                                      </td>
                                                        <td>

                                                        <input type="hidden" name="basic[]" class="basic" value="{{ $basic }}">

                                                        {{ $basic }} 

                                                    </td>
                                                        <td>{{ $houseRent }} </td>
                                                        <td>{{ $medical }} </td>
                                                        <td>{{ $travelAllowance }} </td>
                                                        <td>{{ $foodAllowance }} </td>
                                                  

                                                        <td style="width: 55px;">
                                                            <input type="number" style="width: 55px" value="{{ $workDay }}" class="form-control form-control-sm days" step="any" name="days[]" readonly>
                                                        </td>
                                                        <td style="width: 55px;">
                                                            <input type="number" style="width: 55px"  value="{{ $absent }}" class="form-control form-control-sm absent" step="any" name="absent[]">
                                                        </td>
                                                        <td style="width: 55px;"> 
                                                            <input type="number" style="width: 55px" value="{{ $workDay }}"  class="form-control form-control-sm workdays" step="any" name="workdays[]" readonly> 
                                                        </td>


                                                        <td style="width: 75px;">
                                                            <input type="number" style="width: 75px" step="any" value="{{$hr}}"  class="form-control form-control-sm hr" name="hr[]">
                                                        </td>
                                                        <td style="width: 75px;">
                                                            <input type="number" style="width: 75px" step="any" value="{{$rt}}"  class="form-control form-control-sm rt" name="rt[]">
                                                        </td>

                                                        <td style="width: 75px;"> 
                                                            <input type="number" style="width: 75px" value="{{$total_overtime}}"  class="form-control form-control-sm total_overtime" step="any" name="total_overtime[]" readonly> 
                                                        </td>
                                                        
                                                        <td style="width: 75px;"> 
                                                            <input type="number" style="width: 75px" value="{{$abs_deda_amt}}"  class="form-control form-control-sm abs_deda_amt" step="any" name="abs_deda_amt[]"> 
                                                        </td>
                                                        
                                                        <td style="width: 75px;"> 
                                                            <input type="number" style="width: 75px" value="{{$allownce}}"  class="form-control form-control-sm allownce" step="any" name="allownce[]"> 
                                                        </td>
                                                        
                                                        <td style="width: 95px;"> 
                                                            <input type="number" style="width: 95px" value="{{$payable_net_salary}}"  class="form-control form-control-sm payable_net_salary" step="any" name="payable_net_salary[]" readonly> 
                                                        </td>


                                                        <td style="width: 85px;"> 
                                                            <input type="number" style="width: 85px" value="{{$loan_given}}"  class="form-control form-control-sm loan_given" step="any" name="loan_given[]"> 
                                                        </td>

                                                        <td style="width: 85px;"> 
                                                            <input type="number" style="width: 85px" value="{{$loan_adj}}"  class="form-control form-control-sm loan_adj" step="any" name="loan_adj[]"> 
                                                        </td>

                                                        <td style="width: 85px;"> 
                                                            <input type="number" style="width: 85px" value="{{$stamp_deduc}}"  class="form-control form-control-sm stamp_deduc" step="any" name="stamp_deduc[]"> 
                                                        </td>


                                                        <td style="width: 85px;"> 
                                                            <input type="number" style="width: 85px" value="{{$payable_net_amt}}"  class="form-control form-control-sm payable_net_amt" step="any" name="payable_net_amt[]" readonly> 
                                                        </td>


                                                        <td style="width: 100px;"> 
                                                            <input type="text" style="width: 100px" value="{{$signature}}"  class="form-control form-control-sm signature" step="any" name="signature[]"> 
                                                        </td>

                                                        <td>
                                                            <textarea class="form-control" name="comments[]" rows="1" placeholder="Comment"></textarea>
                                                        </td> 


                                                        <td>
                                                            <input type="date" style="width: 120px" value=""  class="form-control form-control-sm paid_date" step="any" name="paid_date[]"> 
                                                        </td> 

                                                        <td>
                                                            <button type="button" class="remove btn btn-danger btn-sm"> X </button>
                                                        </td>

                                                    </tr>
                                                @endforeach
                                            @endif
                                        </tbody>
                                    </table>
                                </div>
                                <div class="row float-right">
                                    <button type="submit" class="btn btn-info mt-3 mr-3">Submit</button>
                                </div>
                            </div>
                            <!-- /.card-body -->
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- /.content -->
@endsection

@push('scripts')

    <script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>
    <script src="{{ asset('plugins/moment/moment.min.js') }}"></script>
    <script src="{{ asset('plugins/inputmask/jquery.inputmask.min.js') }}"></script>

@if(isset($month) && !empty($month) && isset($year) && !empty($year) )
<script type="text/javascript">

    function toggleDisable() {

        const selectEleMonth = document.getElementById('month');
        const selectEleYear = document.getElementById('year');
        selectEleMonth.disabled = !selectEleMonth.disabled;
        selectEleYear.disabled = !selectEleYear.disabled;
    }

  //toggleDisable();


</script>
@endif


<script type="text/javascript">


        // Function to calculate net salary
        function calculateNetSalary($row) {

            var gross_salary = parseFloat($row.find('.gross_salary').val()) || 0; 
            var total_overtime = parseFloat($row.find('.total_overtime').val()) || 0; 
            var abs_deda_amt = parseFloat($row.find('.abs_deda_amt').val()) || 0; 
            var allownce = parseFloat($row.find('.allownce').val()) || 0; 

            var loan_given = parseFloat($row.find('.loan_given').val()) || 0; 
            var loan_adj = parseFloat($row.find('.loan_adj').val()) || 0; 
            var stamp_deduc = parseFloat($row.find('.stamp_deduc').val()) || 0; 


            var payable_net_salary = gross_salary + total_overtime - abs_deda_amt + allownce;

            $row.find('.payable_net_salary').val(Math.round(Number(payable_net_salary.toFixed(2)))); 

            var payable_net_amt = payable_net_salary + loan_given - loan_adj - stamp_deduc;

             $row.find('.payable_net_amt').val(Math.round(Number(payable_net_amt.toFixed(2))));


             return true;


        }



        $(function() {

            //Initialize Select2 Elements
            // $('.select2').select2();
            $('.myselect2').select2();

            //Initialize Select2 Elements
            $('.select2bs4').select2({
                theme: 'bootstrap4'
            });

            $(".remove").on("click", function () {
                if (confirm("Are you sure you want to remove this record?")) {
                    $(this).closest('tr').remove(); // Remove the closest table row
                }
            });

            $("#month, #year").change(function(){

                var month = $("#month").val();
                var year = $("#year").val();

                $("#salary_month").val(month);
                $("#salary_year").val(year);

            });


            $(document).on('select2:open', () => {
                document.querySelector('.select2-search__field').focus();
            });


            $("#department_id").change(function(){

                if($(this).val()){

                    let department_id = $(this).val();

                    let route = "{{ route('emp.deptemp') }}";

                    $("#designation_id").html('');

                    $.get( route, { department_id: department_id } )
                      .done(function( data ) {

                        if(data){

                            $("#designation_id").html(data);

                        }

                    });

                }

            });


            $("#designation_id").change(function(){

                if($(this).val()){

                    let designation_id = $(this).val();

                    let route = "{{ route('emp.disemp') }}";

                    $("#emp_id").html('');

                    $.get( route, { designation_id: designation_id } )
                      .done(function( data ) {

                        if(data){

                            $("#emp_id").html(data);

                        }

                    });

                }

            });


            $(".absent").click(function () {

                $(this).select();
                $(this).focus();

            });


            $(".absent").on("input", function () {
                var DEFAULT_WORKDAYS = 30; // Define a constant for default workdays

                var $row = $(this).closest('tr'); // Cache the closest row
                var absentDays = parseInt($(this).val()) || 0; // Parse absent days, default to 0
                var days = parseInt($row.find('.days').val()) || DEFAULT_WORKDAYS; // Parse total days, default to 30

                var gross_salary = parseInt($row.find('.gross_salary').val()) || 0;

                if (absentDays > 0) {

                    var workdays = Math.max(0, days - absentDays); // Ensure workdays is non-negative
                    $row.find('.workdays').val(workdays);

                    var abs_deda_amt = (gross_salary / DEFAULT_WORKDAYS) * absentDays;

                } else {
                     var abs_deda_amt = 0;
                    $(this).val(0); // Reset invalid input to 0
                    $row.find('.workdays').val(DEFAULT_WORKDAYS); // Reset to default workdays
                }

                $row.find('.abs_deda_amt').val(Math.round(Number(abs_deda_amt.toFixed(2))));

                calculateNetSalary($row);


            });


            $(".hr, .rt").on("keyup", function () {
                var $row = $(this).closest('tr'); // Cache the closest row for reuse
                var hr = parseFloat($row.find('.hr').val()) || 0; // Convert to number, default to 0
                var rt = parseFloat($row.find('.rt').val()) || 0; // Convert to number, default to 0

                if (hr > 0 && rt > 0) {
                    var totalOvertime = hr * rt; // Calculate total overtime
                    $row.find('.total_overtime').val(Math.round(Number(totalOvertime.toFixed(2)))); // Update and format
                } else {
                    //$(this).val(0); // Reset invalid input to 0
                    $row.find('.total_overtime').val(0); // Reset total overtime
                    var totalOvertime = 0;
                }

                 calculateNetSalary($row);


            });


            $(".allownce").on("keyup", function () {

                var $row = $(this).closest('tr'); 

                 calculateNetSalary($row);


            });



            $(".loan_given, .loan_adj, .stamp_deduc").on("keyup", function () {


                var $row = $(this).closest('tr');

                 calculateNetSalary($row);


            });



        });
    </script>
@endpush