@php $profile = 'Home'; $start_date = date('Y-m-1'); $year_start_date = date('Y-01-1',strtotime("-1 year")); $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

View Projects

Project ID Title Source Name Client Name Project Origin Status Amount Project Type Writers Initial Deadline Deadline Total Words Remaining Words