@php $profile = 'Home'; $start_date = date('Y-m-1'); $end_date = date('Y-m-t'); // dd(App\Models\User::where('IsActive',1)->whereNotIn('RoleID',[16,17])->pluck('UserID','fullname')); $petty_cash_amounts = App\Models\PettyCashAmount::OrderBy('Sno', 'desc')->whereYear('Month', date('Y'))->get(); $this_month_petty_cash_amount = App\Models\PettyCashAmount::whereDate('Month', '>=', $start_date) ->whereDate('Month', '<=', $end_date) ->sum('Amount'); $petty_cash_expenses_count = App\Models\PettyCashExpense::whereDate('Date', '>=', $start_date) ->whereDate('Date', '<=', $end_date) ->count(); // dd( $petty_cash_expenses_count); $petty_cash_expenses = App\Models\PettyCashExpense::whereDate('Date', '>=', $start_date) ->whereDate('Date', '<=', $end_date) ->orderBy('Date', 'desc') ->get(); $attendances = App\Models\Attendance::where('UserID', Auth::user()->UserID) ->whereDate('AttendanceDate', '>=', $start_date) ->whereDate('AttendanceDate', '<=', $end_date) ->get(); $monday = date('Y-m-d', strtotime('monday this week')); $currentDate = date('Y-m-d'); $attendace_datas = App\Models\Attendance::where('UserID', Auth::user()->UserID) ->where('AttendanceDate', '>=', $monday) ->where('AttendanceDate', '<=', $currentDate) ->orderBy('AttendanceDate') ->get(); $today_attendance_count = App\Models\Attendance::where('UserID', Auth::user()->UserID) ->whereDate('AttendanceDate', date('Y-m-d')) ->count(); $today_attendance_check = App\Models\Attendance::where('UserID', Auth::user()->UserID) ->whereDate('AttendanceDate', date('Y-m-d')) ->first(); $yesterday_attendance_check = App\Models\Attendance::where('UserID', Auth::user()->UserID) ->whereDate('AttendanceDate', date('Y-m-d', strtotime('-1 day'))) ->first(); $yesterday_attendance_count = App\Models\Attendance::where('UserID', Auth::user()->UserID) ->whereDate('AttendanceDate', date('Y-m-d', strtotime('-1 day'))) ->count(); $leaves = App\Models\LeaveRequest::where('Date', '>=', $start_date) ->where('Date', '<=', $currentDate) ->where('UserID', Auth::user()->UserID) ->orderBy('id', 'desc') ->take(10) ->get(); @endphp
{{-- --}}
@php $profile = 'users/avater.png'; if (isset(Auth::user()->profile_pic)) { $profile = asset('users/' . Auth::user()->profile_pic); } @endphp
Logo
@if ($today_attendance_count > 0) @if ($today_attendance_check->TimeIN == null) @if ($yesterday_attendance_count > 0) @if ($yesterday_attendance_check->IsAttendanceCompleted == 1 || $yesterday_attendance_check->TimeIN == null) @endif @endif @endif @endif @if ($today_attendance_count > 0) @if ($today_attendance_check->TimeIN != null) @if ($yesterday_attendance_check->IsAttendanceCompleted == 1 || $yesterday_attendance_check->TimeIN == null) @if ($today_attendance_check->IsAttendanceCompleted != 1) @endif @endif @endif @endif @if ($yesterday_attendance_count > 0) @if ($yesterday_attendance_check->IsAttendanceCompleted != 1 && $yesterday_attendance_check->TimeIN != null) @endif @endif
@foreach ($attendace_datas as $attendace_data) @endforeach
Date Day Time In Time Out Total Time Status
{{ date('d F Y', strtotime($attendace_data->AttendanceDate)) }} {{ date('l', strtotime($attendace_data->AttendanceDate)) }} @if ($attendace_data->TimeIN != null) {{ date('h:i A', strtotime($attendace_data->TimeIN)) }} @else @endif @if ($attendace_data->TimeOUT != null) {{ date('h:i A', strtotime($attendace_data->TimeOUT)) }} @else @endif @if ($attendace_data->TotalTime != null) {{ date('h:i', strtotime($attendace_data->TotalTime)) }} @else @endif {{ $attendace_data->attendance_status->Status ?? '' }}
@php $totalProjects = DB::table('gcp_projects') ->join( 'gcp_projectassignments', 'gcp_projects.ProjectID', '=', 'gcp_projectassignments.ProjectID', ) ->where('gcp_projectassignments.WriterID', Auth::user()->UserID) ->where('gcp_projectassignments.IsAssigned', true) ->whereIn('gcp_projects.Status', [12, 13]) ->count(); $cancelProjects = DB::table('gcp_projects') ->join( 'gcp_projectassignments', 'gcp_projects.ProjectID', '=', 'gcp_projectassignments.ProjectID', ) ->where('gcp_projectassignments.WriterID', Auth::user()->UserID) ->where('gcp_projectassignments.IsAssigned', true) ->whereIn('gcp_projects.Status', [11]) ->count(); @endphp {{ number_format($totalProjects) }} Total Projects
@php $totalWords = DB::table('gcp_projectplannings') ->join( 'gcp_projects', 'gcp_projectplannings.ProjectID', '=', 'gcp_projects.ProjectID', ) ->whereIn('gcp_projects.Status', [12, 13]) ->where('gcp_projectplannings.WriterID', Auth::user()->UserID) ->sum('gcp_projectplannings.DoneAssignedWords'); @endphp @if ($totalWords != 0) {{ number_format(round($totalWords / 500)) }} @endif Total Pages
@php $successRate = 0; if (Auth::User()->roleID == 18 && $cancelProjects != 0 && $totalProjects != 0) { $successRate = round(100 - ($cancelProjects / $totalProjects) * 100, 1); } @endphp {{ number_format($successRate) }} Success Rate
@php $projectsTypesNums = DB::table('gcp_projects') ->join( 'gcp_projectassignments', 'gcp_projects.ProjectID', '=', 'gcp_projectassignments.ProjectID', ) ->where('gcp_projectassignments.WriterID', Auth::user()->UserID) ->where('gcp_projectassignments.IsAssigned', true) ->whereIn('gcp_projects.Status', [12, 13]) ->groupBy('gcp_projects.ProjectType') ->orderByRaw('COUNT(gcp_projects.ProjectType) DESC') ->limit(3) ->pluck('gcp_projects.ProjectType'); $projectsTypes = []; foreach ($projectsTypesNums as $key => $projectsTypesNum) { $projectsTypes[$key] = DB::table('gcp_projecttypes') ->where('id', $projectsTypesNum) ->pluck('ProjectType'); } @endphp @foreach ($projectsTypes as $projectsType) {{ preg_replace('/[^A-Za-z0-9\s]/', '', $projectsType) }} , @endforeach Project Type
{{-- attendance modal --}}
My Attendance
@foreach ($attendances as $attendance) @endforeach
ATTENDANCE DATE DAY TIME IN TIME OUT TOTAL TIME STATUS COMMENTS
{{ date('d F Y', strtotime($attendance->AttendanceDate)) }} {{ date('l', strtotime($attendance->AttendanceDate)) }} @if ($attendance->TimeIN == null) - @else {{ date('h:i A', strtotime($attendance->TimeIN)) }} @endif @if ($attendance->TimeOUT == null) - @else {{ date('h:i A', strtotime($attendance->TimeOUT)) }} @endif @if ($attendance->TotalTime == null) - @else {{ date('H:i', strtotime($attendance->TotalTime)) }} @endif {{ $attendance->attendance_status->Status }} {{ $attendance->Comment ?? 'Not Available' }}
{{-- attendance modal ended --}} {{-- petty cash modal start --}}
Petty Cash
@if ($petty_cash_expenses_count > 0) @foreach ($petty_cash_expenses as $petty_cash_expense) @php $this_month_petty_cash_amount = $this_month_petty_cash_amount - $petty_cash_expense->Amount; @endphp @endforeach @else @endif
DATE DESCRIPTION VENDOR PERSON AMOUNT NET AMOUNT
Opening Balance Rs. {{ $this_month_petty_cash_amount }}
{{ date('d F Y', strtotime($petty_cash_expense->Date)) }} {{ $petty_cash_expense->Description }} {{ $petty_cash_expense->Vendor }} {{ $petty_cash_expense->Person }} Rs. {{ $petty_cash_expense->Amount }}Rs. {{ $this_month_petty_cash_amount }} @if (date('Y-m-d', strtotime($petty_cash_expense->Date)) < date('Y-m-1')) Remove @else Remove @endif
No Record Found
{{-- petty cash modal ended --}} {{-- petty cash amount modal start --}}
Petty Cash Amount
@foreach ($petty_cash_amounts as $petty_cash_amount) @endforeach
DATE AMOUNT
{{ date('d F Y', strtotime($petty_cash_amount->Month)) }} Rs. {{ number_format($petty_cash_amount->Amount) }} @if (date('Y-m', strtotime($petty_cash_amount->Month)) == date('Y-m')) @endif
{{-- petty cash modal ended --}} {{-- user profile modal --}}
MY Profile
{{ ucfirst(Auth::user()->FullName) }}
{{ Auth::user()->username }}
{{ Auth::user()->email }}
{{ Auth::user()->Address }}
{{ Auth::user()->Contact }}
{{ Auth::user()->EmergencyContact }}
{{ date('d F Y', strtotime(Auth::user()->DOB)) }}
{{ Auth::user()->NIC }}
{{ Auth::user()->department->DepartmentName }}
{{ Auth::user()->designation->DesignationName }}
{{ Auth::user()->AccountNumber }}
Rs. {{ Auth::user()->Salary }}
@if (Auth::user()->Tax == 0) Does not fall in tax slab @else {{ Auth::user()->Tax }} @endif
{{ date('d F Y', strtotime(Auth::user()->DateOfJoining)) }}
@if (Auth::user()->ConfirmationDate != null) {{ date('d F Y', strtotime(Auth::user()->ConfirmationDate)) }} @else N/A @endif
@if (isset(Auth::user()->IsConfirmed) && Auth::user()->IsConfirmed == true) Confirmed @else Awaiting Confirmation @endif
{{ Auth::user()->CasualLeave }}
{{ Auth::user()->remcasual_Leave }}
{{ Auth::user()->SickLeave }}
{{ Auth::user()->remsick_Leave }}
{{ Auth::user()->AnnualLeave }}
{{ Auth::user()->remannual_Leave }}
{{-- user profile modal --}} {{-- watch salary modal --}}

Salary Slip

logo

Search To Populate data

{{-- basic info --}}
{{-- basic info --}}
{{-- basic pay --}}
Basic Salary

0.00000

{{-- basic pay --}}

ALLOWANCES AND ADJUSTMENTS

{{-- allowance --}}
CONVEYANCE ALLOWANCE

0.00000

RELIABILITY BONUS

0.00000

ADJUSTMENTS

0.00000

{{-- sllowance ended --}} {{-- performance related --}}

PERFORMANCE RELATED REWARD

performance text

0.0000

{{-- performance related --}} {{-- extra day section --}}

EXTRA DAY SALARY

extra day name

extra day count

0.00000

{{-- extra day section ended --}} {{-- gross salary --}}

GROSS SALARY

Gross Salary

0.00000

{{-- gross salary --}} {{-- loan salary --}}

LOAN

Loan Name

0.00000

{{-- loan salary --}} {{-- {{Provident Fund}} --}}

Provident Fund

Provident Fund

0.00000

{{-- {{Provident Fund}} --}} {{-- deduction salary --}}

DEDUCTION

0 LATE IN AND 0 EARLY OUT

0.00000

0 ABSENTEES

0.00000

0 HALF DAY

0.00000

{{-- deduction salary --}} {{-- performance base deduction salary --}}

Performance Based Deductions

0 ABSENT DUE TO LOW PERFORMANCE

0.00000

0 HALF DAY DUE TO LOW PERFORMANCE

0.00000

0 DEDUCTION DUE TO INCOMPLETE SHIFT

0.00000

Other Deducation

0.00000

{{-- performance base deduction salary --}} {{-- tax salary --}}

TAX

Tax

0.00000

{{-- tax salary --}} {{-- net salary --}}

LOAN

Net Salary

0.00000

{{-- net salary --}}
{{-- watch salary modal end --}} {{-- leave modal start --}}
Leave
@if (Auth::user()->remcasual_Leave != 0 && Auth::user()->remsick_Leave != 0 && Auth::user()->remannual_Leave != 0)
@else

Oh No !!!! You have already availed all your leaves

@endif
@if (isset($leaves) && count($leaves) > 0) @foreach ($leaves as $leave) @php $user = App\Models\User::where('UserID', $leave->ResponseBy) ->withTrashed() ->first(); $user_count = App\Models\User::where('UserID', $leave->ResponseBy) ->withTrashed() ->count(); $response_by = 'N/A'; if ($user_count > 0) { $response_by = $user->FullName; } @endphp @endforeach @else @endif
Reason Leave Type No of Days Date From Date To Status Decision By Application Date
{{ $leave->Text }} {{ leave_name($leave->Type) }} {{ $leave->Days }} Days {{ date('d F Y', strtotime($leave->DateFrom)) }} {{ date('d F Y', strtotime($leave->DateTo)) }} {{ leave_status($leave->Status) }} {{ $response_by }} {{ date('d F Y', strtotime($leave->Date)) }}
No Data Found
{{-- leave modal ended --}}