@extends('layouts.organization.app')
@section('content')
<style>
    .table-condensed th, .table-condensed td{
        padding: 0.9375rem 0.75rem;
    }
    .modal-lg, .modal-xl {
        max-width: 1000px;
    }
    .lable-buttons{
        background: #3f9abd;
        color: white;
        padding: 2px 10px;
        border-radius: 4px;
    }
</style>
<div id="myModal1" class="modal fade" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">
        <div class="modal-header">
            <h4 class="modal-title d-flex"><div id="user_details"></div>&nbsp;&nbsp; <span id="full_name"></span></h4>
            <button type="button" class="close" data-dismiss="modal">&times;</button>
        </div>
            <div class="modal-body" id="reason_for_leav_comp_desc">
            <section style="background-color: #eee;">
                <div class="container py-3">
                    <div class="row">
                        <ul id="update_users"></ul>
                    </div>
                </div>
            </section>
            </div>
            <div class="modal-footer">
                <span class="btn btn-danger btn-sm" data-dismiss="modal">Close</span>
            </div>
        </div>
    </div>
</div>
<div class="main-panel">
    <div class="content-wrapper">
        <div class="row">
            <div class="col-12 grid-margin stretch-card">
                <div class="card">
                    <div class="card-header">
                        <h5 class="">JBP COMMERCIAL BROKERS LLC</h5>
                    </div>
                    <div class="card-body">
                        <div class="row">
                        @if(!empty($user_profile))
                            @php $users_data = json_decode($user_profile->datas); @endphp
                            <div class="col-md-4 mb-3">
                                <div class="card">
                                    <div class="card-body text-center">
                                        @if(!empty($users_data->profile))
                                            <img src="{{asset($users_data->profile)}}" style="width:200px;height:200px;border-radius: 150px;object-fit:cover">
                                        @else
                                            <img src="{{asset('images/avatar.png')}}" style="width:200px;height:200px;border-radius: 150px;object-fit:cover">
                                        @endif
                                    </div>
                                    <hr/>
                                    <div class="card-body text-left">
                                        @if(!empty($user))
                                            <h3>{{$user->name}}</h3>
                                        @endif
                                        @if(!empty($users_data->employee_code))
                                            <p><i class="fa fa-id-card-o"></i>&nbsp;  {{$users_data->employee_code}}</p>
                                        @endif
                                        @if(!empty($user->email))
                                            <p><i class="fa fa-envelope"></i>&nbsp;  {{$user->email}}</p>
                                        @endif
                                        @if(!empty($user->alternate_email))
                                            <p><i class="fa fa-envelope"></i>&nbsp;  {{$user->alternate_email}} <span class="label label-success bg-success" onclick="make_primary({{$user->id}},'{{$user->alternate_email}}','{{$user->email}}')">Make Primary</span> </p>
                                        @endif
                                        @if(!empty($user->mobile))
                                            <p><i class="fa fa-phone"></i>&nbsp;  {{$user->mobile}}</p>
                                        @endif
                                        @if(!empty($users_data->dob))
                                            <p><i class="fa fa-birthday-cake"></i>&nbsp; {{date('d-M-Y',strtotime($users_data->dob))}}</p>
                                        @endif
                                    </div>
                                    <div class="card-body text-left">
                                        <a href="#" data-toggle="modal" data-target="#myModal1" @if(!empty($user->name)) data-name="{{$user->name}}" @endif onclick="get_users_id({{$user_id}})" class="btn btn-primary dx_{{$user_id}}"><i class="fa fa-edit"></i> Edit</a>
                                        
                                        @if($user->status == 'Active')
                                            <a href="{{url('employee-exit',$user_id)}}" class="btn btn-danger delete-button"><i class="fa fa-trash"></i> Deactivate</a>
                                        @endif 

                                        <!-- <a href="{{url('delete-employees',$user_id)}}" class="btn btn-danger delete-button"><i class="fa fa-trash"></i> Delete</a> -->


                                    </div>
                                </div>
                            </div>
                        @endif
                        @foreach($form_category as $formcategory)
                            @php 
                                $form_datas = DB::select("SELECT b.form_name,b.form_column,b.data_type FROM `map_form_orgs` as a INNER JOIN form_engines as b on a.form_name=b.form_column WHERE organisation_id=$organisation->user_id AND b.form_category_id=$formcategory->id ORDER BY b.order_id ASC");
                                $data = App\Models\EmployeeInfo::select('datas')->where('organisation_id',$organisation->user_id)->where('user_id',$user_id)->where('from_cat_id',$formcategory->id)->first(); $emp = @json_decode($data->datas);
                            @endphp
                        @if($formcategory->is_multiple==1)
                            <div class="col-md-12 mb-3">
                                <div class="card mb-4 mb-md-0">
                                    <div class="card-body">
                                        <h5 class="mb-2"> {{$formcategory->name}} </h5>
                                        <div class="row">
                                            <table class="table table-condensed">
                                                <thead>
                                                    <tr>
                                                    @if(!empty($emp)) @foreach($emp as $x => $val)
                                                        @php $form = App\Models\FormEngine::select('form_name')->where('form_column',$x)->first();@endphp
                                                        <td><b>{{$form->form_name}}</b></td>
                                                    @endforeach @endif
                                                    </tr>
                                                </thead>
                                                <tbody><tr>
                                                    @if(!empty($emp)) @foreach($emp as $x => $val)
                                                        @php $form = App\Models\FormEngine::select('form_name','data_type')->where('form_column',$x)->first();
                                                        $count = count($val); @endphp
                                                        <td>
                                                        @for($i=0;$i < $count;$i++)
                                                            @if($form->data_type=='file')
                                                                @if(!empty($val[$i]))
                                                                    <p><a href="{{url($val[$i])}}" download>Download</a></p>
                                                                @endif
                                                            @elseif($form->data_type=='date')
                                                                @if(!empty($val[$i]))
                                                                    <p>{{date('d-M-Y',strtotime($val[$i]))}}</p>
                                                                @endif
                                                            @else
                                                                @if(!empty($val[$i]))
                                                                    <p>{{$val[$i]}}</p>
                                                                @endif
                                                            @endif
                                                        @endfor
                                                        </td>
                                                    @endforeach @else
                                                        <tr>
                                                            <td colspan="2">No {{$formcategory->name}} Found</td>
                                                        </tr>
                                                    @endif</tr>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        @else 
                        <div class="col-md-4 mb-3">
                            <div class="card mb-4 mb-md-0">
                                <div class="card-body">
                                    <h5 class="mb-2"> {{$formcategory->name}} </h5>
                                    <div class="row">
                                    <table class="table table-condensed">
                                        <tbody>
                                        @if(!empty($form_datas[0])) @foreach($form_datas as $forms)
                                            @php $form =  DB::select("SELECT REPLACE(json_extract(datas,'$.$forms->form_column'),'\"','') as data FROM `employee_infos` where organisation_id=$organisation->user_id AND user_id=$user_id AND from_cat_id=$formcategory->id"); $possition=null; @endphp
                                            @if(!empty($form[0]))
                                                <tr>
                                                    <td><b>{{$forms->form_name}}</b></td>
                                                    <td>@if($forms->data_type=='file')
                                                            @if(!empty($form[0]->data))
                                                            <p><a href="{{url($form[0]->data)}}" download>Download</a></p>
                                                            @endif
                                                        @elseif($forms->data_type=='date')
                                                            @if(!empty($form[0]->data))
                                                                <p>{{date('d-M-Y',strtotime($form[0]->data))}}</p>
                                                            @endif
                                                        @else
                                                            @if(!empty($form[0]->data))
                                                                @if($formcategory->id==1)
                                                                    @if($forms->form_column=='department')
                                                                        @php $designation_id =  DB::select("SELECT REPLACE(json_extract(update_data,'$.$forms->form_column'),'\"','') as data FROM `employee_infos` where organisation_id=$organisation->user_id AND user_id=$user_id AND from_cat_id=1 LIMIT 1"); 
                                                                        if(!empty($designation_id[0])){
                                                                            $designation = $designation_id[0]->data;
                                                                            $possition = DB::select("SELECT a.id,c.department_name,a.sub_position FROM `position_masters` AS a INNER JOIN department_masters AS c ON c.id=a.department_id WHERE a.orgnization_id=$organisation->user_id AND a.id = $designation LIMIT 1");
                                                                        }
                                                                        @endphp
                                                                    @endif
                                                                @endif
                                                                <p>{{$form[0]->data}}  @if(!empty($possition[0])) - {{$possition[0]->sub_position}} @endif</p> 
                                                            @endif
                                                        @endif
                                                    </td>
                                                </tr>
                                                @if($formcategory->name=='Employee Details')
                                                    @if($loop->iteration==3)
                                                        @if(!empty($line_manager->name))
                                                        <tr>
                                                            <td>
                                                                <b>Line Manager</b>
                                                            </td>
                                                            <td>
                                                                {{$line_manager->name}}
                                                            </td>
                                                        </tr>
                                                        @endif
                                                    @endif
                                                @endif
                                            @endif
                                        @endforeach @else
                                            <tr><td colspan="2">No {{$formcategory->name}} Found</td></tr>
                                        @endif
                                        </tbody>
                                    </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                        @endif @endforeach
                        <div class="col-md-12 mb-3">
                            <div class="card mb-4 mb-md-0">
                                <div class="card-body">
                                    <h5 class="mb-2">Leave Details</h5>
                                    @if(count($leaves) != 0)
                                        <table class="table table-condensed">
                                            <tbody>
                                                <tr>
                                                    <th>Sr No.</th>
                                                    <th>Start Date</th>
                                                    <th>End Date</th>
                                                    <th>Duration</th>
                                                    <th>Leave Type</th>
                                                    <th>Status</th>
                                                </tr>
                                                @foreach ($leaves as $leave)
                                                <tr>
                                                    <td>{{$loop->iteration}}</td>
                                                    <td>{{date('d M, Y', strtotime($leave->start_date))}}</td>
                                                    <td>{{date('d M, Y', strtotime($leave->end_date))}}</td>
                                                    <td>{{$leave->duration}}</td>
                                                    <td>{{$leave->name}}</td>
                                                    <td>{{$leave->status}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    @else
                                        <p style="text-align: center;">No leave history found</p>
                                    @endif
                                </div>
                            </div>
                        </div>
                        <div class="col-md-12 mb-3">
                            <div class="card mb-4 mb-md-0">
                                <div class="card-body">
                                <h5 class="mb-2">Salary Deatils</h5>
                                @php 
                                $salaries_details = \DB::table('salary_history')->where('user_id',$user->id)->orderBy('id','DESC')->get();
                                @endphp
                                @if(!empty($salaries_details)) 
                                    <table class="table table-condensed">
                                        <tbody>
                                            <tr>
                                                <th>Sr No.</th>
                                                <th>Current Salary</th>
                                                <th>Date</th>
                                            </tr>
                                            @foreach($salaries_details as $sal)
                                            <tr>
                                                <td>{{$loop->iteration}}</td>
                                                <td>{{number_format($sal->current_salary,2)}}</td>
                                                <td>{{date('d M Y', strtotime($sal->created_at))}}</td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                @else
                                    <p style="text-align: center;">No salary deatils found</p>
                                @endif
                            </div>
                            </div>
                        </div>
                        <div class="col-md-12 mb-3">
                            <div class="card mb-4 mb-md-0">
                                <div class="card-body">
                                <h5 class="mb-2">Salary Slips</h5>
                                @if(count($salaries) != 0)
                                    <table class="table table-condensed">
                                        <tbody>
                                            <tr>
                                                <th>Sr No.</th>
                                                <th>Month</th>
                                                <th>Action</th>
                                            </tr>
                                            @foreach ($salaries as $salari)
                                            <tr>
                                                <td>{{$loop->iteration}}</td>
                                                <td>{{date('M, Y', strtotime($salari->month_year))}}</td>
                                                <td><a href="{{route('export-salary-slip', $salari->id)}}">Download</a></td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                @else
                                    <p style="text-align: center;">No salary slip found</p>
                                @endif
                            </div>
                            </div>
                        </div>
                        <div class="col-md-12 mb-3">
                            <div class="card mb-4 mb-md-0">
                                <div class="card-body">
                                <div class="d-flex" style="justify-content: space-between;">
                                    <h5 class="mb-2">Assets Item</h5>
                                    <a href="{{url('add-emp-assets',$user_id)}}" class="btn btn-primary btn-sm"><i class="fa fa-plus"></i> Assign Assets</a>
                                </div>
                                @if(!empty($assets))
                                    <table class="table table-condensed">
                                        <tbody>
                                            <tr>
                                                <th>S.No</th>
                                                <th>Assets Type</th>
                                                <th>Model Number</th>
                                                <th>Serial No</th>
                                                <th>Assign Date</th>
                                                <th>Action</th>
                                            </tr>
                                            @foreach($assets as $row)
                                            <tr>
                                                <td>{{$loop->iteration}}</td>
                                                <td>{{$row->assets_name}}</td>
                                                <td>{{$row->model_number}}</td>
                                                <td>{{$row->serial_no}}</td>
                                                <td>{{date_format(date_create($row->created_at),"d M Y")}}</td>
                                                <td>
                                                    <a href="{{url('view-assets-item',$row->id)}}"><i class="fa fa-eye"></i></a>
                                                </td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                @else
                                    <p style="text-align: center;">No data found</p>
                                @endif
                            </div>
                            </div>
                        </div>
                        @if($employee_exit)
                        <div class="col-md-12 mb-3">
                            <div class="card mb-4 mb-md-0">
                                <div class="card-body">
                                <div class="d-flex" style="justify-content: space-between;">
                                    <h5 class="mb-2">Employee Exit</h5>
                                </div>
                                <table class="table table-condensed">
                                    @if($employee_exit->resignations_type == 1)
                                    <tbody>
                                        <tr>
                                            <th>Exit reason</th>
                                            <th>Email Account Inactive</th>
                                            <th>Control Panel Changed</th>
                                            <th>Resignation Date</th>
                                            <th>Resignation Acceptance Date</th>
                                            <th>Relieving Date</th>
                                            <th>Handover Done</th>
                                        </tr>
                                        <tr>
                                            <td>Resigned</td>
                                            <td>@if($employee_exit->email_active==1) Yes @else No @endif</td>
                                            <td>@if($employee_exit->control_panel==1) Yes @else No @endif</td>
                                            <td>{{ date('d M, Y', strtotime($employee_exit->resignation_date)) }}</td>
                                            <td>{{ date('d M, Y', strtotime($employee_exit->resignation_acceptance_date)) }}</td>
                                            <td>{{ date('d M, Y', strtotime($employee_exit->relieving_date)) }}</td>
                                            <td>@if($employee_exit->handover==1) Yes @else No @endif</td>
                                        </tr>
                                        <tr>
                                            <td colspan="7" style="text-align: center;"><strong>Uploaded  Document</strong></td>
                                        </tr>
                                        @if(!empty($employee_exit->no_dues_certificate))
                                        <tr>
                                            <td colspan="2">No Dues Certificate</td>
                                            <td colspan="2"><a href="{{asset($employee_exit->no_dues_certificate)}}" Download>Download</a></td>  
                                        </tr>
                                        @endif
                                        @if(!empty($employee_exit->relieving_letter))
                                        <tr>
                                            <td colspan="2">Relieving Letter</td>
                                            <td colspan="2"><a href="{{asset($employee_exit->relieving_letter)}}" Download>Download</a></td>  
                                        </tr>
                                        @endif
                                        @if(!empty($employee_exit->fnf))
                                        <tr>
                                            <td colspan="2">FNF Statement</td>
                                            <td colspan="2"><a href="{{asset($employee_exit->fnf)}}" Download>Download</a></td>  
                                        </tr>
                                        @endif
                                    </tbody>
                                    @endif
                                    @if($employee_exit->resignations_type == 2)
                                    <tbody>
                                        <tr>
                                            <th>Exit reason</th>
                                            <th>Email Account Inactive</th>
                                            <th>Control Panel Changed</th>
                                            <th>Handover Done</th>
                                            <th>Reason To Terminate</th>
                                        </tr>
                                        <tr>
                                            <td>Terminated</td>
                                            <td>@if($employee_exit->email_active==1) Yes @else No @endif</td>
                                            <td>@if($employee_exit->control_panel==1) Yes @else No @endif</td>
                                            <td>@if($employee_exit->handover==1) Yes @else No @endif</td>
                                            <td>@if($employee_exit->reason_terminate==1) Behavioral Issue @else Work Related Issue @endif</td>
                                        </tr>
                                        <tr>
                                            <td colspan="7" style="text-align: center;"><strong>Uploaded  Document</strong></td>
                                        </tr>
                                        @if(!empty($employee_exit->no_dues_certificate))
                                        <tr>
                                            <td colspan="2">No Dues Certificate</td>
                                            <td colspan="2"><a href="{{asset($employee_exit->no_dues_certificate)}}" Download>Download</a></td>  
                                        </tr>
                                        @endif
                                        @if(!empty($employee_exit->relieving_letter))
                                        <tr>
                                            <td colspan="2">Relieving Letter</td>
                                            <td colspan="2"><a href="{{asset($employee_exit->relieving_letter)}}" Download>Download</a></td>  
                                        </tr>
                                        @endif
                                        @if(!empty($employee_exit->fnf))
                                        <tr>
                                            <td colspan="2">FNF Statement</td>
                                            <td colspan="2"><a href="{{asset($employee_exit->fnf)}}" Download>Download</a></td>  
                                        </tr>
                                        @endif
                                    </tbody>
                                    @endif
                                    @if($employee_exit->resignations_type == 3)
                                    <tbody>
                                        <tr>
                                            <th>Exit reason</th>
                                            <th>Date Of Abscoding</th>
                                            <th>Last Reminder</th>
                                            <th>Brief Explain</th>
                                        </tr>
                                        <tr>
                                            <td>Absconding</td>
                                            <td>{{ date('d M, Y', strtotime($employee_exit->date_of_abscoding)) }}</td>
                                            <td>{{ date('d M, Y', strtotime($employee_exit->last_reminder)) }}</td>
                                            <td>{{ $employee_exit->comment }}</td>
                                        </tr>
                                    </tbody>
                                    @endif
                                    @if($employee_exit->resignations_type == 4)
                                    <tbody>
                                        <tr>
                                            <th>Exit reason</th>
                                            <th>Leaving Date</th>
                                            <th>Comment</th>
                                            <th>Exit Survey/Interview</th>
                                        </tr>
                                        <tr>
                                            <td>
                                                @if($employee_exit->resignations_type == 1) Resigned @endif
                                                @if($employee_exit->resignations_type == 2) Terminated @endif
                                                @if($employee_exit->resignations_type == 3) Absconding @endif
                                                @if($employee_exit->resignations_type == 4) Other Reason @endif
                                            </td>
                                            <td>{{ date('d M, Y', strtotime($employee_exit->leaving_date)) }}</td>
                                            <td>{{ $employee_exit->comment }}</td>
                                            <td>{{ $employee_exit->interview_comment }}</td>
                                        </tr>
                                        @if(count($ExitDocument) != 0)
                                        <tr>
                                            <td colspan="4" style="text-align: center;"><strong>Uploaded  Document</strong></td>
                                        </tr>
                                            @foreach($ExitDocument as $ExitDocum) 
                                            <tr>
                                                <td colspan="2">{{ $ExitDocum->title }}</td>
                                                <td colspan="2"><a href="{{ asset('/uploads/status_document/'.$ExitDocum->document) }}" Download>Download</a></td>  
                                            </tr>
                                            @endforeach
                                        @endif
                                    </tbody>
                                    @endif
                                </table>
                                </div>
                            </div>
                        </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script>
    $(document).ready(function () {
        var datatable = $('#exampleemp').dataTable({
            dom: 'Bfrtip',
            buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
            ],
        });
    });
</script>
<script>
    function get_users_data(id){
        var spinner = $('#loader');
        spinner.show();
        $.get("{{url('ajax/get-employee-all-details')}}/"+id+"",function(xhr){
            $('#all_employee_data').html(xhr);
            spinner.hide();
        });
    }
    function get_users_id(id){
        $('#update_users').empty();
        var spinner = $('#loader');
        spinner.show();
        $.get("{{url('ajax/get-orgnisation-category')}}/"+id+"",function(xhr){
            $('#user_details').text('Update '+$('.dx_'+id).attr("data-name"));
            var datas = xhr.data;
            for (var i = 0; i < datas.length; i++) {
                $('#update_users').append('<li style="list-style: none"><a class="lable-buttons" href="{{url('update-employeess')}}/'+datas[i].id+'/'+id+'">Update '+datas[i].name+'</a></li>');
            }
            spinner.hide();
        });
    }
</script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.3/sweetalert.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.3/sweetalert.min.css">
<script>
    $(document).on('click','.status_checks',function(){
        var status = ($(this).hasClass("btn-outline-success")) ? 'Inactive' : 'Active';
        var msg = (status=='Active')? 'Active' : 'Inactive';
        var current_element = $(this);
        swal({
            title: "Are you sure?",
            text: "Do you want to change status "+msg,
            type: "warning",
            showCancelButton: true,
            confirmButtonColor: "#DD6B55",
            confirmButtonText: "Yes, change status!",
            closeOnConfirm: false
        }, function (isConfirm) {
            if (isConfirm) {
                $.ajax({
                    headers: {'X-CSRF-TOKEN': $('meta[name="csrf_token"]').attr('content')},
                    url: "{{url('ajax/update-users-status')}}",
                    type: "POST",
                    data: {id:$(current_element).attr('data'),status:status},
                    success: function(xhr){
                        if(xhr.data.status=='Inactive'){
                            $('#inds'+xhr.data.id).addClass('btn-outline-danger');
                            $('#inds'+xhr.data.id).removeClass('btn-outline-success');
                            $('#inds'+xhr.data.id).text('Inactive');
                            // toastr.success("Inactive");
                        }else{
                            $('#inds'+xhr.data.id).addClass('btn-outline-success');
                            $('#inds'+xhr.data.id).removeClass('btn-outline-danger');
                            $('#inds'+xhr.data.id).text('Active');
                            // toastr.success("Active");
                        }
                        swal(xhr.data.status, "Succesfully "+xhr.data.status, "success");
                        
                    },
                    error: function (xhr, ajaxOptions, thrownError) {
                        swal("Something Went to Wrong!", "Please try again", "error");
                    }
                });
            }
        });
    });
    function make_primary(userId, currentPrimaryEmail, newPrimaryEmail) {
            $.ajax({
                headers: {'X-CSRF-TOKEN': $('meta[name="csrf_token"]').attr('content')},
                url: "{{url('ajax/primary-email')}}",
                method: 'POST',
                data: {
                    userId: userId,
                    currentPrimaryEmail: currentPrimaryEmail,
                    newPrimaryEmail: newPrimaryEmail
                },
                success: function(response) {
                    swal({
                        title: 'Success',
                        text: 'Successfully Updated',
                        icon: 'success'
                    });
                    setTimeout(() => {
                        location.reload();
                    }, 2000);
                },
                error: function(xhr, status, error) {
                    alert("An error occurred while updating the primary email.");
                }
            });
        }
</script>
@endsection('content')