Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/celkcksm/hrms.ncriptech.com/storage/debugbar/ |
[ Home ] | [ C0mmand ] | [ Upload File ] |
---|
{"__meta":{"id":"Xe01930d2daf7ae24a701233b4ab4059b","datetime":"2025-04-10 18:53:41","utime":1744291421.768950939178466796875,"method":"POST","uri":"\/dashboard\/profileWiseDashboard","ip":"103.57.240.60"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":2,"messages":[{"message":"[18:53:41] LOG.warning: Creation of dynamic property App\\Repositories\\Hrm\\Employee\\AppoinmentRepository::$fileproposals is deprecated in \/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php on line 98","message_html":null,"is_string":false,"label":"warning","time":1744291421.7305281162261962890625,"xdebug_link":null,"collector":"log"},{"message":"[18:53:41] LOG.warning: Creation of dynamic property App\\Repositories\\Hrm\\Expense\\HrmExpenseRepository::$service is deprecated in \/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Expense\/HrmExpenseRepository.php on line 34","message_html":null,"is_string":false,"label":"warning","time":1744291421.7313539981842041015625,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744291421.52303409576416015625,"end":1744291421.76898097991943359375,"duration":0.2459468841552734375,"duration_str":"246ms","measures":[{"label":"Booting","start":1744291421.52303409576416015625,"relative_start":0,"end":1744291421.71500301361083984375,"relative_end":1744291421.71500301361083984375,"duration":0.1919689178466796875,"duration_str":"192ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744291421.715023040771484375,"relative_start":0.19198894500732421875,"end":1744291421.7689840793609619140625,"relative_end":3.0994415283203125e-6,"duration":0.0539610385894775390625,"duration_str":"53.96ms","memory":0,"memory_str":"0B","params":[],"collector":"time"}]},"memory":{"peak_usage":7280024,"peak_usage_str":"7MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":1,"templates":[{"name":"1x backend.dashboard.load_my_dashboard","param_count":null,"params":[],"start":1744291421.749475955963134765625,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/dashboard\/load_my_dashboard.blade.phpbackend.dashboard.load_my_dashboard","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fdashboard%2Fload_my_dashboard.blade.php&line=1","ajax":false,"filename":"load_my_dashboard.blade.php","line":"?"},"render_count":1,"name_original":"backend.dashboard.load_my_dashboard"}]},"route":{"uri":"POST dashboard\/profileWiseDashboard","middleware":"web, demo.mode, xss, admin, TimeZone","domain":"https:\/\/hrms.ncriptech.com","controller":"App\\Http\\Controllers\\Backend\\DashboardController@profileWiseDashboard","namespace":null,"prefix":"\/dashboard","where":[],"as":"dashboard.profileWiseDashboard","file":"<a href=\"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHttp%2FControllers%2FBackend%2FDashboardController.php&line=99\" onclick=\"\">app\/Http\/Controllers\/Backend\/DashboardController.php:99-135<\/a>"},"queries":{"nb_statements":18,"nb_visible_statements":18,"nb_excluded_statements":0,"nb_failed_statements":0,"accumulated_duration":0.0084999999999999971411757115902219084091484546661376953125,"accumulated_duration_str":"8.5ms","memory_usage":0,"memory_usage_str":null,"statements":[{"sql":"select * from `users` where `id` = 5 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[5],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":159},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","line":340},{"index":20,"namespace":"middleware","name":"admin","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/Admin.php","line":21}],"start":1744291421.73692607879638671875,"duration":0.0010100000000000000470457006684910084004513919353485107421875,"duration_str":"1.01ms","memory":0,"memory_str":null,"filename":"EloquentUserProvider.php:59","source":{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fvendor%2Flaravel%2Fframework%2Fsrc%2FIlluminate%2FAuth%2FEloquentUserProvider.php&line=59","ajax":false,"filename":"EloquentUserProvider.php","line":"59"},"connection":"celkcksm_hrms","explain":null,"start_percent":0,"width_percent":11.8819999999999996731503415503539144992828369140625},{"sql":"select * from `company_configs` where `key` = 'timezone' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["timezone",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180},{"index":18,"namespace":"middleware","name":"admin","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/Admin.php","line":25},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180},{"index":20,"namespace":"middleware","name":"xss","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/XSS.php","line":31}],"start":1744291421.73941898345947265625,"duration":0.0003200000000000000261769772524900190546759404242038726806640625,"duration_str":"320\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:783","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=783","ajax":false,"filename":"Helper.php","line":"783"},"connection":"celkcksm_hrms","explain":null,"start_percent":11.8819999999999996731503415503539144992828369140625,"width_percent":3.765000000000000124344978758017532527446746826171875},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":821},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744291421.7414119243621826171875,"duration":0.0014399999999999998738509088269665880943648517131805419921875,"duration_str":"1.44ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:821","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":821},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=821","ajax":false,"filename":"DashboardRepository.php","line":"821"},"connection":"celkcksm_hrms","explain":null,"start_percent":15.6470000000000002415845301584340631961822509765625,"width_percent":16.940999999999998948396751075051724910736083984375},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1","type":"query","params":[],"bindings":[5,1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":832},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744291421.743640899658203125,"duration":0.001469999999999999952537965697274557896889746189117431640625,"duration_str":"1.47ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:832","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":832},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=832","ajax":false,"filename":"DashboardRepository.php","line":"832"},"connection":"celkcksm_hrms","explain":null,"start_percent":32.58800000000000096633812063373625278472900390625,"width_percent":17.294000000000000483169060316868126392364501953125},{"sql":"select count(*) as aggregate from `visits` where `company_id` = 1 and `user_id` = 5","type":"query","params":[],"bindings":[1,5],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":840},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744291421.7457940578460693359375,"duration":0.0001799999999999999842313636033708235117956064641475677490234375,"duration_str":"180\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:840","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":840},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=840","ajax":false,"filename":"DashboardRepository.php","line":"840"},"connection":"celkcksm_hrms","explain":null,"start_percent":49.88199999999999789679350215010344982147216796875,"width_percent":2.117999999999999882760448599583469331264495849609375},{"sql":"select count(*) as aggregate from `appoinments` where `company_id` = 1 and `created_by` = 5","type":"query","params":[],"bindings":[1,5],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":846},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744291421.74666500091552734375,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:846","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":846},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=846","ajax":false,"filename":"DashboardRepository.php","line":"846"},"connection":"celkcksm_hrms","explain":null,"start_percent":52,"width_percent":3.41199999999999992184029906638897955417633056640625},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 28 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,28,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":701},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.7534139156341552734375,"duration":0.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:701","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":701},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=701","ajax":false,"filename":"DashboardRepository.php","line":"701"},"connection":"celkcksm_hrms","explain":null,"start_percent":55.41199999999999903366187936626374721527099609375,"width_percent":4.3529999999999997584154698415659368038177490234375},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 27 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,27,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":705},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.75463390350341796875,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:705","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":705},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=705","ajax":false,"filename":"DashboardRepository.php","line":"705"},"connection":"celkcksm_hrms","explain":null,"start_percent":59.7650000000000005684341886080801486968994140625,"width_percent":2.353000000000000202504679691628552973270416259765625},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 26 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,26,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":709},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.7556488513946533203125,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:709","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":709},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=709","ajax":false,"filename":"DashboardRepository.php","line":"709"},"connection":"celkcksm_hrms","explain":null,"start_percent":62.11800000000000210320649784989655017852783203125,"width_percent":2.353000000000000202504679691628552973270416259765625},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 25 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,25,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":713},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.7566549777984619140625,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:713","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":713},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=713","ajax":false,"filename":"DashboardRepository.php","line":"713"},"connection":"celkcksm_hrms","explain":null,"start_percent":64.47100000000000363797880709171295166015625,"width_percent":2.353000000000000202504679691628552973270416259765625},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 24 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,24,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":717},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.75765895843505859375,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:717","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":717},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=717","ajax":false,"filename":"DashboardRepository.php","line":"717"},"connection":"celkcksm_hrms","explain":null,"start_percent":66.8239999999999980673237587325274944305419921875,"width_percent":2.471000000000000085265128291212022304534912109375},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 28","type":"query","params":[],"bindings":[5,1,28],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":735},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.75868892669677734375,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:735","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":735},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=735","ajax":false,"filename":"DashboardRepository.php","line":"735"},"connection":"celkcksm_hrms","explain":null,"start_percent":69.2939999999999969304553815163671970367431640625,"width_percent":4},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 27","type":"query","params":[],"bindings":[5,1,27],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":739},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.7597439289093017578125,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:739","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":739},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=739","ajax":false,"filename":"DashboardRepository.php","line":"739"},"connection":"celkcksm_hrms","explain":null,"start_percent":73.2939999999999969304553815163671970367431640625,"width_percent":2.58800000000000007815970093361102044582366943359375},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 26","type":"query","params":[],"bindings":[5,1,26],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":743},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.7606580257415771484375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:743","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":743},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=743","ajax":false,"filename":"DashboardRepository.php","line":"743"},"connection":"celkcksm_hrms","explain":null,"start_percent":75.88200000000000500222085975110530853271484375,"width_percent":2.58800000000000007815970093361102044582366943359375},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 25","type":"query","params":[],"bindings":[5,1,25],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":747},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.7615659236907958984375,"duration":0.0003299999999999999981958875849841206218115985393524169921875,"duration_str":"330\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:747","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":747},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=747","ajax":false,"filename":"DashboardRepository.php","line":"747"},"connection":"celkcksm_hrms","explain":null,"start_percent":78.47100000000000363797880709171295166015625,"width_percent":3.882000000000000117239551400416530668735504150390625},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 24","type":"query","params":[],"bindings":[5,1,24],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":751},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.76257801055908203125,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:751","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":751},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=751","ajax":false,"filename":"DashboardRepository.php","line":"751"},"connection":"celkcksm_hrms","explain":null,"start_percent":82.3529999999999944293449516408145427703857421875,"width_percent":2.353000000000000202504679691628552973270416259765625},{"sql":"select * from `appoinments` where `company_id` = 1 and (`created_by` = 5) and `date` >= '2025-04-10' and `appoinments`.`company_id` = 1 order by `created_at` desc limit 6","type":"query","params":[],"bindings":[1,5,"2025-04-10",1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":764},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":111},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.7636039257049560546875,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:764","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":764},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=764","ajax":false,"filename":"DashboardRepository.php","line":"764"},"connection":"celkcksm_hrms","explain":null,"start_percent":84.7060000000000030695446184836328029632568359375,"width_percent":3.05900000000000016342482922482304275035858154296875},{"sql":"select * from `meetings` where `company_id` = 1 and `date` >= '2025-04-10' and `user_id` = 5 and exists (select * from `meeting_participants` where `meetings`.`id` = `meeting_participants`.`meeting_id` or (`user_id` = 5)) and `meetings`.`company_id` = 1 order by `created_at` desc limit 6","type":"query","params":[],"bindings":[1,"2025-04-10",5,5,1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":789},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":112},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744291421.765715122222900390625,"duration":0.001040000000000000125732757538798978202976286411285400390625,"duration_str":"1.04ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:789","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":789},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=789","ajax":false,"filename":"DashboardRepository.php","line":"789"},"connection":"celkcksm_hrms","explain":null,"start_percent":87.7650000000000005684341886080801486968994140625,"width_percent":12.2349999999999994315658113919198513031005859375}]},"models":{"data":{"App\\Models\\User":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FUser.php&line=1","ajax":false,"filename":"User.php","line":"?"}},"App\\Models\\coreApp\\Setting\\CompanyConfig":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FcoreApp%2FSetting%2FCompanyConfig.php&line=1","ajax":false,"filename":"CompanyConfig.php","line":"?"}}},"count":2,"is_counter":true},"symfonymailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"9jmMOnu4HQAdaWyg1CSmawYoXyfxCXcEprybsSOI","_previous":"array:1 [\n \"url\" => \"https:\/\/hrms.ncriptech.com\/dashboard\"\n]","_flash":"array:2 [\n \"old\" => []\n \"new\" => []\n]","login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d":"5"},"request":{"path_info":"\/dashboard\/profileWiseDashboard","status_code":"<pre class=sf-dump id=sf-dump-306286972 data-indent-pad=\" \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-306286972\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-357320628 data-indent-pad=\" \">[]\n<\/pre><script>Sfdump(\"sf-dump-357320628\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-1136708892 data-indent-pad=\" \"><span class=sf-dump-note>array:4<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n \"<span class=sf-dump-key>_token<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">9jmMOnu4HQAdaWyg1CSmawYoXyfxCXcEprybsSOI<\/span>\"\n \"<span class=sf-dump-key>userID<\/span>\" => \"<span class=sf-dump-str>5<\/span>\"\n \"<span class=sf-dump-key>dashboardType<\/span>\" => \"<span class=sf-dump-str title=\"12 characters\">My Dashboard<\/span>\"\n \"<span class=sf-dump-key>month<\/span>\" => \"<span class=sf-dump-str title=\"7 characters\">2025-04<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1136708892\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-1774259465 data-indent-pad=\" \"><span class=sf-dump-note>array:19<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n \"<span class=sf-dump-key>accept<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"33 characters\">application\/json, text\/plain, *\/*<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>accept-encoding<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"23 characters\">gzip, deflate, br, zstd<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>accept-language<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"14 characters\">en-US,en;q=0.9<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>content-type<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>content-length<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"2 characters\">97<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>cookie<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"720 characters\">XSRF-TOKEN=eyJpdiI6IjFrbEphVUpLc3lYTFU2RzZrY1JNeEE9PSIsInZhbHVlIjoiWjRJSXRsMGRjaGJ1RFlHVWVPSmNGWEJDTUxXc2tZK3FwYmh2L2VzcXM0R1VHNURHdGEvdDVsYUMzdmh3S0pDMzVZdytPUjdYWFV1Wnh4aTRvWXQrUTRJeFNKeVBua05KbndqY1VOR2ZnMmlQYkZJVlNQQmNncTluY1UrakhFa3EiLCJtYWMiOiI4ZWEyYmZjNzEzMjc4YWM3NzQ3NjA2NmQ0MWY1OTVmOTBlZWEyZGRhNjEwNjU2YmRjNTU4YmQxMWFhYWE1ZDhmIiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6InEyVjN3dXZUSXZXWVBvN1N0WmR5cGc9PSIsInZhbHVlIjoiT3M0R0hhNHd6MDNtSlFkN1FseGZGWUh0bmlRdkphMlJFRkZWcVp0ZEdGOUZ2RUxma29DNUlMS1ROYXhuMjVDMFZ0QmxIbkg3UUJBdGp5YjR5b0FaaVR2aEZwTHBXVTVMMlBDdTZVdTJ5TnNnNnNNcngwcEpOVmZoWExTYmVnWEUiLCJtYWMiOiJlMDJiMzEyYzExNGMyYzkyYzM4NThhNzFjNDE1ZDIzMDAwYzNkM2NiMDRhOWVkZjc5YzBiYTljMzI3MGRhMThjIiwidGFnIjoiIn0%3D<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>host<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"18 characters\">hrms.ncriptech.com<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>referer<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"36 characters\">https:\/\/hrms.ncriptech.com\/dashboard<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>user-agent<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"111 characters\">Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/135.0.0.0 Safari\/537.36<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>sec-ch-ua-platform<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"9 characters\">"Windows"<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>x-xsrf-token<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"340 characters\">eyJpdiI6IjFrbEphVUpLc3lYTFU2RzZrY1JNeEE9PSIsInZhbHVlIjoiWjRJSXRsMGRjaGJ1RFlHVWVPSmNGWEJDTUxXc2tZK3FwYmh2L2VzcXM0R1VHNURHdGEvdDVsYUMzdmh3S0pDMzVZdytPUjdYWFV1Wnh4aTRvWXQrUTRJeFNKeVBua05KbndqY1VOR2ZnMmlQYkZJVlNQQmNncTluY1UrakhFa3EiLCJtYWMiOiI4ZWEyYmZjNzEzMjc4YWM3NzQ3NjA2NmQ0MWY1OTVmOTBlZWEyZGRhNjEwNjU2YmRjNTU4YmQxMWFhYWE1ZDhmIiwidGFnIjoiIn0=<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>sec-ch-ua<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"64 characters\">"Google Chrome";v="135", "Not-A.Brand";v="8", "Chromium";v="135"<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>sec-ch-ua-mobile<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"2 characters\">?0<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>x-requested-with<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"14 characters\">XMLHttpRequest<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>origin<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"26 characters\">https:\/\/hrms.ncriptech.com<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>sec-fetch-site<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"11 characters\">same-origin<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>sec-fetch-mode<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"4 characters\">cors<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>sec-fetch-dest<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"5 characters\">empty<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>priority<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"6 characters\">u=1, i<\/span>\"\n <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1774259465\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-654499268 data-indent-pad=\" \"><span class=sf-dump-note>array:2<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n \"<span class=sf-dump-key>XSRF-TOKEN<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">9jmMOnu4HQAdaWyg1CSmawYoXyfxCXcEprybsSOI<\/span>\"\n \"<span class=sf-dump-key>ncriptech_hrms_session<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">N1Bhb9dPsJHEjpx2zN9N5fxmxyFyG6XGl216Dwpi<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-654499268\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-678220863 data-indent-pad=\" \"><span class=sf-dump-note>array:5<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n \"<span class=sf-dump-key>cache-control<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"17 characters\">no-cache, private<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>date<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"29 characters\">Thu, 10 Apr 2025 13:23:41 GMT<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>content-type<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>set-cookie<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"428 characters\">XSRF-TOKEN=eyJpdiI6Im5WR05SQVE2YjEyQndvMng5TEIwaEE9PSIsInZhbHVlIjoiVDRBd2dYZlIvMElpekRUWnNPeFdDUEpsYUtHZXUrZWVPSUlmZU9WRUJwbGpGU0JDQUtrMVdiMlIwRUdmeG9pTElkZUJkQkhxWDJ4VWc1Sk5WWFJzbGxSVUt6aU9kRk8wNzZVcHVIN1I4TVE4aEFpZWtWT09Cc3BMcHFORWJIYkEiLCJtYWMiOiI0MzEwYmZjOThkYTI3NmE5ZTFlYmQ5ZmM2ZDcxYTM1NmRlOTg0OGE5NWVjYWE4YTEyZDMxMzBlMDk1NWFkZjhjIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 15:23:41 GMT; Max-Age=7200; path=\/; samesite=lax<\/span>\"\n <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"450 characters\">ncriptech_hrms_session=eyJpdiI6ImsvNGNpQzVJU2hhVS9UeG1yTFhCbHc9PSIsInZhbHVlIjoiMVl0RVlwNnFqRUlNVTVMcTF5SDY2clRCTXVhZ1BXNHZqZSsxTEcxc25aZk9tNWQ3UFk5MjZTYkZpbG1PMlY3U2ZuSE94SGxXY0hpOEZYNCthM1lqN01rT2VnYW9FNkVGRUNHOStEMFdFNXpVekU3SFkxZ0w2M3pRV0xzSS8yNy8iLCJtYWMiOiI1YTc5OWI0YzQ0ODMwMTM5ZDE3ZGI5Y2Y1ZTc5MTU0MmY5NTJjMmVjODg5NDgzOWI2MmU3OTY5ZDdhYTg4NGMyIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 15:23:41 GMT; Max-Age=7200; path=\/; httponly; samesite=lax<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>Set-Cookie<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"400 characters\">XSRF-TOKEN=eyJpdiI6Im5WR05SQVE2YjEyQndvMng5TEIwaEE9PSIsInZhbHVlIjoiVDRBd2dYZlIvMElpekRUWnNPeFdDUEpsYUtHZXUrZWVPSUlmZU9WRUJwbGpGU0JDQUtrMVdiMlIwRUdmeG9pTElkZUJkQkhxWDJ4VWc1Sk5WWFJzbGxSVUt6aU9kRk8wNzZVcHVIN1I4TVE4aEFpZWtWT09Cc3BMcHFORWJIYkEiLCJtYWMiOiI0MzEwYmZjOThkYTI3NmE5ZTFlYmQ5ZmM2ZDcxYTM1NmRlOTg0OGE5NWVjYWE4YTEyZDMxMzBlMDk1NWFkZjhjIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 15:23:41 GMT; path=\/<\/span>\"\n <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6ImsvNGNpQzVJU2hhVS9UeG1yTFhCbHc9PSIsInZhbHVlIjoiMVl0RVlwNnFqRUlNVTVMcTF5SDY2clRCTXVhZ1BXNHZqZSsxTEcxc25aZk9tNWQ3UFk5MjZTYkZpbG1PMlY3U2ZuSE94SGxXY0hpOEZYNCthM1lqN01rT2VnYW9FNkVGRUNHOStEMFdFNXpVekU3SFkxZ0w2M3pRV0xzSS8yNy8iLCJtYWMiOiI1YTc5OWI0YzQ0ODMwMTM5ZDE3ZGI5Y2Y1ZTc5MTU0MmY5NTJjMmVjODg5NDgzOWI2MmU3OTY5ZDdhYTg4NGMyIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 15:23:41 GMT; path=\/; httponly<\/span>\"\n <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-678220863\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-274509708 data-indent-pad=\" \"><span class=sf-dump-note>array:4<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n \"<span class=sf-dump-key>_token<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">9jmMOnu4HQAdaWyg1CSmawYoXyfxCXcEprybsSOI<\/span>\"\n \"<span class=sf-dump-key>_previous<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n \"<span class=sf-dump-key>url<\/span>\" => \"<span class=sf-dump-str title=\"36 characters\">https:\/\/hrms.ncriptech.com\/dashboard<\/span>\"\n <\/samp>]\n \"<span class=sf-dump-key>_flash<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n \"<span class=sf-dump-key>old<\/span>\" => []\n \"<span class=sf-dump-key>new<\/span>\" => []\n <\/samp>]\n \"<span class=sf-dump-key>login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d<\/span>\" => <span class=sf-dump-num>5<\/span>\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-274509708\", {\"maxDepth\":0})<\/script>\n"}}