|
9742
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
My Recordings
My Recordings
Team Recordings
Team Recordings
Everyone's Recordings
Everyone's Recordings
Schedule
Schedule
Invite Notetaker
This Week
This Week
Team Schedule
Team Schedule
No Meetings
Trending this month
Trending this month
Live Feed
Live Feed
No Activity
You are currently impersonating Nikolay Yankov...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/dashboard
|
9742
|
|
9743
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
My Recordings
My Recordings
Team Recordings
Team Recordings
Everyone's Recordings
Everyone's Recordings
Nikolay Yankov at Jiminny (EU)
12 Feb, 10:22 AM
Nikolay Yankov at Jiminny (EU)
12 Feb, 10:13 AM
Nikolay Yankov at Jiminny (EU)
12 Feb, 9:43 AM
Unknown Customer
Notetaker added by Nikolay Yankov
26 Jan, 11:31 AM
Unknown Customer
Notetaker added by Nikolay Yankov
23 Jan, 4:26 PM
Unknown Customer
Notetaker added by Nikolay Yankov
23 Jan, 4:07 PM
Unknown Customer
Notetaker added by Nikolay Yankov
23 Jan, 4:04 PM
Unknown Customer
Notetaker added on 12-19-23 @ 10:04
19 Dec, 2023, 11:03 AM
Bob Arsenault at Planet
Notetaker added on 11-16-23 @ 17:14
Cold
16 Nov, 2023, 6:11 PM
Schedule
Schedule
Invite Notetaker
This Week
This Week
Team Schedule
Team Schedule
Unknown Customer
Refinement - Processing
Tomorrow, 10:30 AM
Unknown Customer
Processing tickets review
Tomorrow, 2:30 PM
Robinson Crusoe Cruises Limited
Sprint Review
Closed Lost
Tomorrow, 4:00 PM
Trending this month
Trending this month
Sort by Sort by: Most played
Sort by
Sort by:
Most played
Unknown Customer
Notetaker added by Veselin Kulov
Notetaker added by Veselin Kulov
1
times played
Unknown Customer
LLM models review for AI Call Scoring
LLM models review for AI Call Scoring
0
times played
Unknown Customer
Stefka / James Weekly
Stefka / James Weekly
0
times played
Aladin at Robinson Crusoe Cruises Limited
test A
test A
0
times played
Unknown Customer
Daily - Processing
Daily - Processing
0
times played
Unknown Customer
Retro - Processing
Retro - Processing
0
times played...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/dashboard
|
9743
|
|
9744
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
My Recordings
My Recordings
Team Recordings
Team Recordings
Everyone's Recordings
Everyone's Recordings
Nikolay Yankov at Jiminny (EU)
12 Feb, 10:22 AM
Nikolay Yankov at Jiminny (EU)
12 Feb, 10:13 AM
Nikolay Yankov at Jiminny (EU)
12 Feb, 9:43 AM
Unknown Customer
Notetaker added by Nikolay Yankov
26 Jan, 11:31 AM
Unknown Customer
Notetaker added by Nikolay Yankov
23 Jan, 4:26 PM
Unknown Customer
Notetaker added by Nikolay Yankov
23 Jan, 4:07 PM
Unknown Customer
Notetaker added by Nikolay Yankov
23 Jan, 4:04 PM
Unknown Customer
Notetaker added on 12-19-23 @ 10:04
19 Dec, 2023, 11:03 AM
Bob Arsenault at Planet
Notetaker added on 11-16-23 @ 17:14
Cold
16 Nov, 2023, 6:11 PM
Schedule
Schedule
Invite Notetaker
This Week
This Week
Team Schedule
Team Schedule
Unknown Customer
Refinement - Processing
Tomorrow, 10:30 AM
Unknown Customer
Processing tickets review
Tomorrow, 2:30 PM
Robinson Crusoe Cruises Limited
Sprint Review
Closed Lost
Tomorrow, 4:00 PM
Trending this month
Trending this month
Sort by Sort by: Most played
Sort by
Sort by:
Most played
Unknown Customer
Notetaker added by Veselin Kulov
Notetaker added by Veselin Kulov
1
times played
Unknown Customer
LLM models review for AI Call Scoring
LLM models review for AI Call Scoring
0
times played
Unknown Customer
Stefka / James Weekly
Stefka / James Weekly
0
times played
Aladin at Robinson Crusoe Cruises Limited
test A
test A
0
times played
Unknown Customer
Daily - Processing
Daily - Processing
0
times played
Unknown Customer
Retro - Processing
Retro - Processing
0
times played
Unknown Customer
Daily - Processing
Daily - Processing
0
times played
Unknown Customer
Daily - Processing
Daily - Processing
0
times played...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/dashboard
|
9744
|
|
9745
|
FirefoxFileEoitViewHistoryBookmarksProfilesWindowP FirefoxFileEoitViewHistoryBookmarksProfilesWindowPlatform Sprint 1 Q2 - Platform TeaZ Configure SSH access to multiple@ Console Home | Console Home | usSecurityGroup | EC2 |us-east-2JY-20543 add AJ reports User pilcSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activityJiminnyg Ask Jiminny test report - 8 Apr 201≤ Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilc(x) Configure SSH access to multiple+ New TabToolsHelpdoo.sideme.minny.com/cashoodra10My RecordingsTeam RecordingsNikolav Yankov at Jiminny (EU) M~12 Feb, 10:22 AMNikolay Yankov at Jiminny (EU) ® 112 Feh. 10:13 AMINikolay Yankov at Jiminny (EU) & 1p12 Feb, 9:43 AMUnknown Customer WNotetaker added by Nikolay Yankov26 Jan. 11:31 AMUnknown CustomerNotetaker added by Nikolay Yankov23 Jan, 4:26 PMUnknown Customer MNotetaker added by Nikolay Yankov23 Jan, 4:07 PMUnknown Customer MNotetaker added by Nikolay Yankov23 Jan, 4:04 PMUnknown Customer MNotetaker added on 12-19-23@10:0419 Dec, 2023, 11:03 AMBob Arsenault at Planet → 1Notetaker added on 11-16-23 @ 17:14Cold16 Nov, 2023, 6:11 PMYou are currently impersonating Nikolay Yankov <)Everyone's RecordingsTrending this monthSort by: Most playedScheduleThis WeekUnknown Customer MNotetaker added by Veselin Kulovsime atedTeam ScheduleAP22Unknown CustomerRefinement - ProcessingTomorrow, 10:30 AMUnknown CustomerProcessing tickets reviewTomorrow, 2:30 PMRobinson Crusoe Cruises Limited ®Sprint ReviewClosed LostTomorrow, 4:00 PMInvite Notetaker÷app.staging.jiminny.com/ai-reports k-iiminny = 869720)< 40 ll 0 1 SupportDaily • in 4h 11mA100% CS•Tue 14 Apr 10:49:29Live FeedMJWVeselin Kulov listened to call 6дactivity with unknown customerđ Held: 8 Apr, 12:36 AM|Nikolay Nikolov listened to call 6дWeb Demo with Martin Petkovđ Held: 13 Feb, 2:15 PM|Martin Petkov listened to call 6дDiscovery with Martin PetkovHeld: 21 Jan, 4:00 PMMartin Petkov listened to call 6dactivity with Jonathan HeatonHeld: 25 Sep, 2024, 1:33PMGalya Dimitrova listened to call 6activity with David EhrlichHeld: 9Oct, 2024, 3:31PMAneliya Angelova listened to call 60Cold call with Robinson Crusoe New 13333Held: 23 Jul, 2025, 5:43 PMJiminny Web SA shared in Slack 0Cold call with Robinson Crusoe New 13333Held: 23 Jul, 2025, 5:43 PM|Jiminny Web SA shared in Slack 28activity with Reward Gatewayđ Held: 19 Sep, 2024, 4:00 PMJiminny WebSA shared in Slackactivity with Robinson Crusoe New 13333đ Held: 17 Jul, 2025, 1:28 PM|Ỡ Duration: 7mO Duration: 11mlỞ Duration: 35mÔ Duration: 37mỞ Duration: 39mỞ Duration: 2mÔ Duration: 2mỞ Duration: 52mỞ Duration: 10s8 Apr, 12:51 AM≥ Value: $02/ Feb, 4:30 PM§ Value: $122 Jan, 1:30 PMÈ Value: $220 Jan, 11:42 AMÈ Value:€8,88626 Nov, 2025, 1:29 PM& Value: $23,00018 Aug, 2025, 8:45 PM≤ Value: $523 Jul, 2025, 5:48 PM§ Value: $523 Jul, 2025, 5:32 PM§ Value: $017 Jul, 2025, 1:32 PM§ Value: $5...
|
NULL
|
NULL
|
NULL
|
9745
|
|
9746
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
AI Reports
AI Reports
Ask Jiminny reports
Ask Jiminny reports
Report name
Period
Report Type Report Type
Report Type
Report Type
Clear all
NAME
FREQUENCY
SHARED
DATE
ACTIONS
No reports have been created yet
You are currently impersonating Nikolay Yankov
AI Reports
app.staging.jiminny.com/ai-reports...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports
|
9746
|
|
9747
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
AI Reports
AI Reports
Ask Jiminny reports
Ask Jiminny reports
Report name
Period
Report Type Report Type
Report Type
Report Type
Clear all
NAME
FREQUENCY
SHARED
DATE
ACTIONS
No reports have been created yet
You are currently impersonating Nikolay Yankov
AI Reports
app.staging.jiminny.com/ai-reports...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports
|
9747
|
|
9748
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
AI Reports
AI Reports
Ask Jiminny reports
Ask Jiminny reports
Report name
Period
Report Type Report Type
Report Type
Report Type
Clear all
NAME
FREQUENCY
SHARED
DATE
ACTIONS
No reports have been created yet
You are currently impersonating Nikolay Yankov
app.staging.jiminny.com/ai-reports/manage...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports
|
9748
|
|
9749
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
AI Reports
AI Reports
Ask Jiminny reports
Ask Jiminny reports
Report name
Period
Report Type Report Type
Report Type
Report Type
Clear all
NAME
FREQUENCY
SHARED
DATE
ACTIONS
No reports have been created yet
You are currently impersonating Nikolay Yankov
app.staging.jiminny.com/ai-reports/manage...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports
|
9749
|
|
9750
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
Ask Jiminny Reports
Ask Jiminny Reports
Create
Report name
Clear all
NAME
FREQUENCY
SHARED
EXPIRING
ACTIONS
Test 2
Daily
28/03/2026
Test 5
Daily
18/04/2026
You are currently impersonating Nikolay Yankov...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports/manage
|
9750
|
|
9751
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
Ask Jiminny Reports
Ask Jiminny Reports
Create
Report name
Prompt Prompt
Prompt
Prompt
Saved search Saved search
Saved search
Saved search
All statuses All statuses
All statuses
All statuses
Clear all
NAME
FREQUENCY
SHARED
EXPIRING
ACTIONS
Test 2
Daily
28/03/2026
Test 5
Daily
18/04/2026
You are currently impersonating Nikolay Yankov...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports/manage
|
9751
|
|
9752
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
Ask Jiminny Reports
Ask Jiminny Reports
Create
Report name
Prompt Prompt
Prompt
Prompt
Saved search Saved search
Saved search
Saved search
All statuses All statuses
All statuses
All statuses
Clear all
NAME
FREQUENCY
SHARED
EXPIRING
ACTIONS
Test 2
Daily
28/03/2026
Test 5
Daily
18/04/2026
You are currently impersonating Nikolay Yankov
AI Reports...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports/manage
|
9752
|
|
9753
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
Ask Jiminny Reports
Ask Jiminny Reports
Create
Report name
Prompt Prompt
Prompt
Prompt
Saved search Saved search
Saved search
Saved search
All statuses All statuses
All statuses
All statuses
Clear all
NAME
FREQUENCY
SHARED
EXPIRING
ACTIONS
Test 2
Daily
28/03/2026
Test 5
Daily
18/04/2026
You are currently impersonating Nikolay Yankov
AI Reports...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports/manage
|
9753
|
|
9754
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindowHelpdoo.sideme.minny.com/di-teoorlsC< 40 ll SupportDaily-in 4h11m A 100%C & Tue 14 Apr 10:49:59You are currently impersonating Nikolay Yankov <)Al ReportsS03 Ask Jiminny reportsPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activity8 Jiminnyg Ask Jiminny test report - 8 Apr 201≤ Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilo(x) Configure SSH access to multiple+ New Tab• Report namelPeriodiReport Type• Clear all|NAMEFREQUENCYSHAREDDATEACTIONS10JY-18909-automated-reports-ask-iiminny = 869720)...
|
NULL
|
NULL
|
NULL
|
9754
|
|
9755
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
AI Reports
AI Reports
Ask Jiminny reports
Ask Jiminny reports
Report name
Period
Report Type Report Type
Report Type
Report Type
Clear all
NAME
FREQUENCY
SHARED
DATE
ACTIONS
No reports have been created yet
You are currently impersonating Nikolay Yankov
app.staging.jiminny.com/ai-reports...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports
|
9755
|
|
9756
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Close tab
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
JY-18909-automated-reports-ask-jiminny ■ 869720
28
28
AI Reports
AI Reports
Ask Jiminny reports
Ask Jiminny reports
Report name
Period
Report Type Report Type
Report Type
Report Type
Clear all
NAME
FREQUENCY
SHARED
DATE
ACTIONS
No reports have been created yet
You are currently impersonating Nikolay Yankov...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ai-reports
|
9756
|
|
9757
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4 h 10 m100% <Tue 14 Apr 10:50:07DOCKERDriversBroadcastingCacheDatabaseLogsMailQueueSessionStoragepublic/storageSentryEnabledEnvironment- 881DEV (-zsh)282APP (-zsh)ec2-user@ip-10-30-93-249:~*3ec2-user@ip-10-30-...X4-zsh-zsh-zshO x7* Unable to acce...O x8pusherredismysqlerrorlogsessqsredisNOT LINKEDYESstaging$IPSNSlack2026-04-1407:48:51]staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51]fblecfded81"}staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INFO: [automated-reports] Found 2 daily reports to process{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cf[2026-04-14 07:48:51]daily"staging. INFO:[automated-reports]Dispatching Generate Report job for report {"reportUuid":"fa7417aa-538e-49ab-8827-77235637a6f9","teamId" :1, "frequency" :,"type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054*daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency" :[2026-04-14 07:48:51] staging.INFO: [automated-reports]Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny# U...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
9757
|
|
9758
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
PhpStormFileEditFV faVsco.s vViewNavigateCodeLaravelRefactor( #11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.phpToolsWindowHelpProject vC .circleci0 .cursorCa-githubDJ.sonarlint> D.vscode> D .windsurfv Dapp> M Actions› _ Component> D Configuration• ConsoleD Commands• ActivitiesD AnalyticsD CalendarsD CrmDeallnsiahts1 IDe• DialersD DTOS_ Elasticsearch• EngagementStats•J GeckoExportLivestream• Mailboxes• MigratePlaybackThemesD PlaybooksPlav istsPostmarkProphetAiReports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php©Usage.phpM SlackM TeamsD TracksD TranscriptionD TwilioO UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseusers.p(e) Database aoecount.oi(C) Delete@ldAiCrmNotesC© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.phpJiminnybeouecommana.ong© AutomatedReportsSendCommand.phpAulomaleakeporskeposilory.oneAulomaleakeporisservice.onpCreateHeldActivityEvent.php© AutomatedReportsCommand.php X© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): int$now = Carbon::nowO:$isMonday = $now->isMondayO);msrurstuavutionth = now->oav === 10$currentMonth = $now->month;// Check if the current month is a quarterly month (January, April, July, October)$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10],strict: true);$this->logger->info(self::LOG_PREFIX . ' Checking conditions', ['isMonday'→> $isMonday,'isFirstDay0fMonth' => $isFirstDay0fMonth,'currentMonth' = $currentMonth,"Isquarterlynonth" → sisquarterlymonch,1):Process daily reports$this->processReports( frequency: AutomatedReportsService::FREQUENCY_DAILY);// Process weekly reports on Mondaysif ($isMonday) {$this->processReports ( frequency: AutomatedReportsService::FREQUENCY_WEEKLY);// Process monthly reports on the first day of the monthif ($isFirstDay0fMonth) €pchis->processkeports( trequency: AUcomacedkeportsservice:.FREQUENCY_MUNIHLY):// Process quarterly reports on the first day of January, April, July, and Octoberif ($isFirstDay0fMonth && $isQuarterlyMonth) {$this->processReports( frequency: AutomatedReportsService::FREQUENCY_QUARTERLY);$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequencu.i* Oparam string $frequency* Oreturn void4 usages101102103104105106107private function processReports(string $frequency): void$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)]);Windsurf changelog 2.12.21: A new version is available. // View Changelog (17 minutes ago)40loblaSupport Daily • in 4h 10 mA" RequestGenerateAsk.JiminnvRenort.lobTestv100% GTue 14 Apr 10:50:08A console (PROD]Al console [EU]A console [STAGING]= custom.logE laravel.log© AskJiminnyReportActivityService.php<?phpA SF [jiminny@localhost]A HS_local [iminny@localhost]RequestGenerateAskJiminnyReportJobTest.php xnecare sumcr voes=urnamespace Tests\Unit\Jobs\AutomatedReports;› use ...21 %class RequestGenerateAskJiminnyReportJobTest extends TestCase28 đ >57 ₽ >64838 usages18 usages14 usages24 usagesprivace Aucomacedreporcsservicexlockubject +reportservice;onvate AskriunnvreoorAcomtyseru cexrockudecr sacrutserucerprivate ProphetClient&Mock0bject $prophetClient;private LoggerInterface&Mock0bject $logger;protected function setUp(): voidf...}13 usagesprivate function makeJob(string $uvid = 'report-uvid'): RequestGenerateAskJiminnyReportJob{..}11 usagesprivate function makeActiveReportstring $type = AutomatedReportsService::TYPE_ASK_JIMINNY,bool $status = true,string $teamStatus = Team::STATUS_ACTIVE,): AutomatedReport&MockObject {..,public function testUniqueIdReturnsReportUuid(): voidf...}public function testHandleSkipsWhenReportTypeIsNotAskJiminnx(): voidфrерогт = schis->mакеасиvекерогс(суре: "exeс_summary"):$this->reportService->expects($this->once())->method ( constraint: 'getReport')->willReturn($report);$this->logger->expects($this->once())->mathodil constrainti'info')->with($this->stringContains(string: 'Started')):nanu s-lodder-sexdecrsnsus-sonceru->iecnod consu'warning')-›with($this-›stringContains ( string: 'not an ask_iiminax report'));$this->reportService->expects($this->never())->method ( constraint: 'createReportResult');$job = $this->makeJob();$job->handLe($this->reportService, $this-›activityService, $this->prophetClient, $this->logger);86 %public function testHandleSkipsWhenReportIsInactive(): void88nrevort = "uhus->nakeAcuvereoort status. tauseu.A1 A14 X4 ^W Windsur leams95:48uir-o( 4 spaces...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
9758
|
|
9759
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4 h 10 m100% C4Tue 14 Apr 10:50:10•DOCKER• 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-... 24885-zsh86-zshO x7* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id":"bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports] Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9759
|
|
9760
|
PhpStormFileEditFV faVsco.s vViewNavigateCodeLarav PhpStormFileEditFV faVsco.s vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-jiminny k ~• ReportController.phpToolsWindowHelpProjectvUS CUIUICUII=.env= .env.circleci=.env.circleci-nightly= .env.local= env.migrate=.env.nikilocal=.env.otherE .env.productionE env.oroduction-euE env.oaE.env.gai=.env.root=.env.staging=.gitattributes• .gitignore=.php-cs-fixer.cachephp.php-cs-fixer.dist.phpphp.phpstorm.meta.phpE.phpunit.result.cacheE prettierignoreE windsurfrulespip _lde_nelper.pnppip _lae_nelper_models.pnpphp artisanO composer.jsonO composer.lock0 dependency-checker.jsonO dev.json=ids.txt=infection.json.distM+INS ALL.mdM- INIEKNALWEOHUUKSEIUP.MGjiminny_storageM+ lIcenses.moM Makefile© package-lock.jsonE phpstan.neon.distEphpstan-baseline.neon< phpunit.xmlTa raw_sqLquery.sqlMeR-ADME.moộ sonar-project.properties= test.ov<> Untitled Diagram.xmlus vetur.config.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consoles~ D Database ConsolesJiminnyDeouecommana.ong© AutomatedReportsSendCommand.phpAutomaleakeporscommana.ongAulomaleakeporskeposilory.oneAulomaleakeporisservice.onpc CrealenelaAcuiviyevent.ono© TrackProviderInstalledEvent.php© ActivityLogged.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.phpclass AutomatedReportsCommand extends Commandpublic function handle(): int$now = Carbon::nowO:$isMonday = $now->isMondayO);msrurstlavutionuh = now->oav sz=10$currentMonth = $now->month;© AutomatedReportsCallbackService.php© AutomatedReportResult.php© AutomatedReport.php100Ajiminny@localhost&PRODXDALPROUA STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]101102103104105106107// Check if the current month is a quarterly month (January, April, July, October)$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10],strict: true);$this->logger->info(self::LOG_PREFIX' Checking conditions', ['isMonday'→> $isMonday,'isFirstDay0fMonth' => $isFirstDay0fMonth,'currentMonth' = $currentMonth,'isQuarterLyMonth' => $isQuarterlyMonth,1);Process daily reports$this->processReports( frequency: AutomatedReportsService::FREQUENCY_DAILY);// Process weekly reports on Mondaysif ($isMonday) {$this->processReports ( frequency: AutomatedReportsService::FREQUENCY_WEEKLY);// Process monthly reports on the first day of the monthif ($isFirstDay0fMonth) €nunus-›orocesskeoorts, trequency: Auronaredreporusservce..rrcOu-Ncy MUNIHLYo// Process quarterly reports on the first day of January, April, July, and Octoberif ($isFirstDay0fMonth && $isQuarterLyMonth) {$this->processReports( frequency: AutomatedReportsService::FREQUENCY_QUARTERLY);$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequencu.* Oparam string $frequency* Oreturn void4 usagesprivate function processReports(string $frequency): void$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find (68)]);Windsurf changelog 2.12.21: A new version is available. // View Changelog (17 minutes ago){ Support Daily • in 4h 10 mARequestGenerateAskJiminnyReportJobTest v100% [45)Tue 14 Apr 10:50:11A console (PROD]Al console (EU]A console [STAGING] >= custom.logE laravel.logA SF [jiminny@localhost]A HS_local [iminny@localhost]ASkJIminnykeportActivilyservice.ono© RequestGenerateAskJiminnyReportJobTest.phpp oIx. AUto VPlaygroundselect * from migrations order by id desc;01410105165175185195205211525524152552753053153253315541555550537538539540541542543154415451546154/5485545555565571558560561562563564SELECTCONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,u.email,sa.*,t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJUIN ceams t n→>l on t.1d = U.ceam_1dWHERE U.team_id = 1 and sa.provider = 'salesforce';select * from teams where id = 1select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;setect#id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id,crm_provider_id,transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMACselect p.id, p.activity_type, pc.id, pc.namerkoM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p. team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * tron reansSELECl P.* FRon automated_reports rnoun realis i on rreall 10 = 1.10WHERE r. frequencx = 'daily'and r.status = 1AND t.status = 'active'AND (r.expires.at >= now() OR r.expines.at IS NULL);select * from automated_report_results where report. id IN (18, 33);Eajiminny vB1^W Windsurf Teams563:20UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9760
|
|
9761
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9761
|
|
9762
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9762
|
|
9763
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9763
|
|
9764
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp>$0Support Daily - in 4 h 10 m100% C4Tue 14 Apr 10:50:38•DOCKER• 81DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-..X4-zsh885-zsh86-zshO 87* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports] Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny# |...
|
NULL
|
NULL
|
NULL
|
9764
|
|
9765
|
Hidden BarFVravsco.isvProject vO dev.json= ids.txt Hidden BarFVravsco.isvProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.moIM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesAEU>A jiminny@localhost&PRODAQAL QAIA QAI PRODV L STAGING4 console [STAGING]A console_1 [STAGING]A uranus [STAGING]#11894 on JY-18909-automated-reports-ask-jiminny~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsRepository.phpC AutomatedReportsService.phpCreateHeldActivityEvent.php© AutomatedReportsCommand.php x© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)]);$this->logger->info(self::LOG_PREFIX . " Found ($reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+oe|×v _ Databasev AEU& consolev & lminnvallocalnosA HS_local4 SFV A PRODA consoleV A STAGING4 console 7 s— DockerOutput2A rowsDid Yf jiminny.automated_reports XTyr Auta•wuid (UUID with time-Low a.1 3d11073d-52b3-42ab-9bda-7b1281d6c85cQ GA®I team_ id T4 [CREDIT_CARD]-2001-296062017741Zdtotchor-1000-4<00-8h2h-22/4045014944 1aa711a5-2a80-48eb-80fb-9f66e85cc8dessbuurer-0n-4tto-051c-t6/021015701h49 12019-+860-4029-2501-89111 20656747 fa76bd0d-61bd-4fac-86c4-9cbf6f71ad268 f4fd1daa-4ee7-4657-9a96-2be267619464ymoasyoo-enoa-uu0a-ndae-00474701752010 96640+02-2928-4504-2999-41297604167011 8a63a8f1-b5c2-4d70-b04b-3c24c69e496b12 acce2c65-665b-48f6-b48c-d13b6bf686cd13 1eec5e26-1a75-4b08-ad2a-88c47c0e56711aen599+-1 x4a-40 e-2hed-01ac 2acdr5s15 8b79d9d8-fa16-4400-bbb8-1e2b0c74345216 f9334df3-6d16-47b4-b632-a2e95c62838317 3f846b8c-6e7c-483f-8135-764df9c62b16I type Yoo exec sunmary1 exec_summary1 product_feedback1 product feedback1052 exec_summary1 ask_J1m1nny1 ask_jiminny1 exec summarv1 exec summary1 exec_summary1 ask_jiminny1 ask iiminnv1 ask_jiminny1 ask_jiminny1 ask_jiminny1 ask iiminnv1 ask_jiminnyI status YI frequency1 weekly1 one_off1 one_off1 one_offo weeKLy1 dailyo daily1 one_off1 one_off1 one_off1 dailyUOaLу1 daily1 daily1 weekly1 weekly1 monthly= custom.logE laravel.log© AskJiminnyReportActivityService.phpv 5445451546154715481547550551552553554555556155815571S00SO1563564565 vA SF [jiminny@localhost]A HS_local [iminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtOVFlaycroundvSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"o>l.n: on p.1d = pc.playbook_10where p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);select * from automated_reports;{ Support Daily • in 4h 10 mARequestGenerateAsk.liminnvRenort.lob Test100% C•Tue 14 Apr 10:50:38A console (PROD]Al console (EU]A console [STAGING]Eajiminny v015 A 12 Х13 ^I from T<null>2026-02-01 00:00:002026-01-01 00:00:002026-02-01 00:00:00<nU LL<null><null>2024-09-05 00:00:007074--09 0000-0102024-03-14 00:00:00<null>ShULl<null>SNULL>ShULl<null>m to Y<null>3026-92-28 00-009 992026-02-28 00:00:002026-03-31 00:00:00IO deal_value_min Y<null>SHULLe2026-03-10 00:00:00070-05-12 0000-0.0.2026-03-19 00:00:00SNULL><null><null><hULl<null>I deal_value_max Y<hULE<null><null><null><null><nulil><null><null><nu l<nili<null>SnuLL<nULL<nulil><null><null><null>Ocall_types Y<null> ["conference", "dialer"]<null> ["conference", "dialer"]‹null>"conference" "dialer"]<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> []<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> ["conference", "dialer"]<null> []<null> []<null> []<null> []<null> []<null> []<null> []ACVw#media_types Y["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf", "podcast"]["pdf", "podcast"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]W Windsurf TeamsIO call_...
|
NULL
|
NULL
|
NULL
|
9765
|
|
9766
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp>$0Support Daily - in 4 h 10 m100% C4Tue 14 Apr 10:50:40•DOCKER• 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-..X4-zsh885-zsh86-zshO 87* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports] Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny# |...
|
NULL
|
NULL
|
NULL
|
9766
|
|
9767
|
Hidden BarFVravsco.isvProject vO dev.json= ids.txt Hidden BarFVravsco.isvProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesAEU>A jiminny@localhost&PRODAQAL QAIA QAI PRODV L STAGING4 console [STAGING]A console_1 [STAGING]A uranus [STAGING]#11894 on JY-18909-automated-reports-ask-jiminny~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsRepository.phpC AutomatedReportsService.phpCreateHeldActivityEvent.phpAutomatedReportsCommand.php x© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)]);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+oe|×v _ Databasev AEU& consolev & lminnvallocalnosA HS_local4 SFV A PRODA consoleV A STAGING4 console 7 s— DockerOutput2A rowsDid Yf jiminny.automated_reports XTyr Auta•wuid (UUID with time-Low a.1 3d11073d-52b3-42ab-9hda-7b1281d6c85cQ GA®I team_ id T4 [CREDIT_CARD]-2001-296062017741Zdtotchor-1000-4<00-8h2h-22/4045014944 1aa711a5-2a80-48eb-80fb-9f66e85cc8dessbuurer-0n-4tto-051c-t6/021015701h49 12019-+860-4029-2501-89111 20656747 fa76bd0d-61bd-4fac-86c4-9cbf6f71ad268 f4fd1daa-4ee7-4657-9a96-2be267619464ymoasyoo-enoa-uu0a-ndae-00474701752010 96640+02-2928-4504-2999-41297604167011 8a63a8f1-b5c2-4d70-b04b-3c24c69e496b12 acce2c65-665b-48f6-b48c-d13b6bf686cd13 1eec5e26-1a75-4b08-ad2a-88c47c0e567114a045499+-1 242-40 a-2h00-9120/200075515 8b79d9d8-fa16-4400-bbb8-1e2b0c74345216 f9334df3-6d16-47b4-b632-a2e95c62838317 3f846b8c-6e7c-483f-8135-764df9c62b16I type Yoo exec sunmary1 exec_summary1 product_feedback1 product feedback1052 exec_summary1 ask_J1m1nny1 ask_jiminny1 exec summarv1 exec summary1 exec_summary1 ask_jiminny1 ask iiminnv1 ask_jiminny1 ask_jiminny1 ask_jiminny1 ask iiminnv1 ask_jiminnyI status YI frequency1 weekly1 one_off1 one_off1 one_offo weeKLy1 dailyo daily1 one_off1 one_off1 one_off1 dailyUOaLу1 daily1 daily1 weekly1 weekly1 monthly{ Support Daily • in 4h 10 mARequestGenerateAsk.liminnvRenort.lob Test100% [47Tue 14 Apr 10:50:41DELL P3223DE= custom.logE laravel.log© AskJiminnyReportActivityService.phpA SF [jir@localhost]A console (PROD]Al console (EU]A console [STAGING] Xestonov 5445451546154715481547550551552553554555556155815571S00SO1563564565 vIx: AUtO Vsecect * Trom activities wnBuilt-in Retina DisplayNULUSIHUEajiminny v015 A 12 Х13 ^select p.id, p.activity_typiFROM playbooks pjoin playbook_categories pcwhere p.team_id = 1 and p.activity_type = 'event';idSELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);select * from automated_reports;I from T<null>2026-02-01 00:00:002026-01-01 00:00:002026-02-01 00:00:00<nU LL<null><null>2024-09-05 00:00:007074--09 0000-0102024-03-14 00:00:00<null>ShULl<null>SNULL>ShULl<null>m to Y<null>3026-92-28 00-009 992026-02-28 00:00:002026-03-31 00:00:00<null>SHULLe2026-03-10 00:00:00070-05-12 0000-0.0.2026-03-19 00:00:00SNULL><null><null><hULl<null>IO deal_value_min YI deal_value_max Y<hULE<null><null><null><null><nili><null><null><nu l<nili<null>SnuLL<nULL<nulil><null><null><null>Ocall_types Y<null> ["conference", "dialer"]<null> ["conference", "dialer"]‹null>"conference" "dialer"]<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> []<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> ["conference", "dialer"]<null> []<null> []<null> []<null> []<null> []<null> []<null> []ACVw#media_types Y["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf", "podcast"]["pdf", "podcast"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]W Windsurf TeamsIO call_...
|
NULL
|
NULL
|
NULL
|
9767
|
|
9768
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp>$0Support Daily - in 4 h 10 m100% C4Tue 14 Apr 10:50:43•DOCKER981DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-..X4-zsh885-zsh86-zshO 87* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports] Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny# |...
|
NULL
|
NULL
|
NULL
|
9768
|
|
9769
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp( #11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAulomaleakeporisservice.onpCreateHeldActivityEvent.php© AutomatedReportsCommand.php x© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes> A jiminny@localhost> A PRODAQAL QAIA QAI PRODV L STAGING4 console [STAGING]A console_1 [STAGING]A uranus [STAGING]101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)]);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+,o,c|v _ Databasev AEU& consolev & lminnvallocalnosA HS_local4 SFV A PRODA consoleV A STAGING4 console 7 sDockerOutputf jiminny.automated_reports X2 rOWSDid Y•wuid (UUID with time-Low a.1 3d11073d-52b3-42ab-9bda-7b1281d6c85cTyr AutaZQGAĐI team_ id T4 [CREDIT_CARD]-2001-82690261777413 dfe7cb95-2d9e-430e-8b2b-2a64065e17274 1aa711a5-2a80-48eb-80fb-9f66e85cc8dessbuurer-0n-4tto-051c-t6/021015701h49 12019-+860-4029-2501-89111 20656747 fa76bd0d-61bd-4fac-86c4-9cbf6f71ad268 f4fd1daa-4ee7-4657-9a96-2be267619464ymoasyoo-enoa-uu0a-ndae-00474701752010 9dd50f9a-a928-45e4-8992-4129f6e41c7011 8a63a8f1-b5c2-4d70-b04b-3c24c69e496b12 acce2c65-665b-48f6-b48c-d13b6bf686cd13 1eec5e26-1a75-4b08-ad2a-88c47c0e567114a045499+-1 242-40 a-2h00-9120/200075515 8b79d9d8-fa16-4400-bbb8-1e2b0c74345216 f9334df3-6d16-47b4-b632-a2e95c62838317 3f846b8c-6e7c-483f-8135-764df9c62b16I type Yoo exec sunmary1 exec_summary1 product_feedback1 product feedback1052 exec_summary1 ask_J1m1nny1 ask_jiminny1 exec summarv1 exec summary1 exec_summary1 ask_jiminny1 ask iiminnv1 ask_jiminny1 ask_jiminny1 ask_jiminny1 ask iiminnv1 ask_jiminnyI status YI frequency1 weekly1 one_off1 one_off1 one_offo weeKLy1 dailyo daily1 one_off1 one_off1 one_off1 dailyUOaLу1 daily1 daily1 weekly1 weekly1 monthly34 rows retrieved starting from 1 in1 s 723 ms (execution: 219 ms, fetching: 1 s 504 ms)= custom.logE laravel.log© AskJiminnyReportActivityService.phpA SF [jiminny@localhost]A HS_local [iminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpv 544545546154715481547550551552553554555556155815571S00SO1563564565 vIx: AUtOVHlaycroundSeLect * Trom aCtIVitIes wnere 10 = 94/4/783; # O0UU40000Up ZOJMLselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"o>l.n: on p.1d = pc.playbook_10where p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);select * from automated_reports;j Support Daily • in 4h 10 mA• RequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:50:44A console (PROD]Al console (EU]A console [STAGING] >Eajiminny v015 A 12 Х13 ^® 8,IO call_I from T<null>2026-02-01 00:00:002026-01-01 00:00:002026-02-01 00:00:00<nU LL<null><null>2024-09-05 00:00:007074--09 0000-0102024-03-14 00:00:00<null>ShULl<null>SNULL>ShULl<null>m to Y<null>3026-92-28 00-009 992026-02-28 00:00:002026-03-31 00:00:00IO deal_value_min Y<null>SHULLe2026-03-10 00:00:00070-05-12 0000-0.0.2026-03-19 00:00:00SNULL>ShULL<null><hULl<null>I deal_value_max Y<null><null><null><null><hULE<nulil><null><null><hULE<null><null>SIULL<null><null><null><null><null>I call_types Y<null> ["conference", "dialer"]<null> ["conference" "dialer"]<null> ["conference", "dialer"]<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> []<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> ["conference", "dialer"]<null> []<null> []<nULl> LJ<null> []<nulls []<null> []<null> []#media_types Y["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf", "podcast"]["pdf", "podcast"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]W Windsurf Teams5541UTF-8...
|
NULL
|
NULL
|
NULL
|
9769
|
|
9770
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4 h 10 m100% C4Tue 14 Apr 10:50:48•DOCKER• 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-... 24885-zsh86-zshO 87* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9770
|
|
9771
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.moIM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsCommand.php x© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes>A jiminny@localhost> A PRODAQAL QAIA QAI PRODV L STAGING4 console [STAGING]A console_1 [STAGING]A uranus [STAGING]101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)]);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+,o,c|v _ Databasev AEU& consolev & lminnvallocalnosA HS_local4 SFV A PRODA consoleV A STAGING4 console 7 sDockerOutputf jiminny.automated_reports X2 rOWSTyr AutaDid Y•uuid (UUID with time-Low a.A 1 3011073d-5253-42ab-9bda-7b1281d6c85c4 [CREDIT_CARD]-2001-296062017741ZQGAĐI team_ id TZdtotchor-1000-4<00-8h2h-22/4045014944 1aa711a5-2a80-48eb-80fb-9f66e85cc8dessbuurer-0n-4tto-051c-t6/021015701h49 12019-+860-4029-2501-89111 20656747 fa76bd0d-61bd-4fac-86c4-9cbf6f71ad268 f4fd1daa-4ee7-4657-9a96-2be267619464ymoasyoo-enoa-uu0a-ndae-00474701752010 96640+02-2928-4504-2999-41297604167011 8a63a8f1-b5c2-4d70-b04b-3c24c69e496b12 acce2c65-665b-48f6-b48c-d13b6bf686cd13 1eec5e26-1a75-4b08-ad2a-88c47c0e56711aen599+-1 x4a-40 e-2hed-01ac 2acdr5s15 8b79d9d8-fa16-4400-bbb8-1e2b0c74345216 f9334df3-6d16-47b4-b632-a2e95c62838317 3f846b8c-6e7c-483f-8135-764df9c62b16I type Yoo exec sunmary1 exec_summary1 product_feedback1 product feedback1052 exec_summary1 ask_J1m1nny1 ask_jiminny1 exec summarv1 exec summary1 exec_summary1 ask_jiminny1 ask iiminnv1 ask_jiminny1 ask_jiminny1 ask_jiminny1 ask iiminnv1 ask_jiminnyI status YI frequency1 weekly1 one_off1 one_off1 one_offo weeKLy1 dailyo daily1 one_off1 one_off1 one_off1 dailyUOaLу1 daily1 daily1 weekly1 weekly1 monthly34 rows retrieved starting from1 s 723 ms (execution: 219 ms, fetching: 1 s 504 ms){ Support Daily • in 4h 10 mA• RequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:50:47= custom.logE laravel.log© AskJiminnyReportActivityService.phpA console (PROD]Al console (EU]A console [STAGING] >v 5445451546154715481547550551552553554555556155815571S00SO1563564565 vA SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtO VHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAEajiminny v015 A 12 Х13 ^select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"o>l.n: on p.1d = pc.playbook_10where p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);select * from automated_reports;• 8,IO call_I from T<null>2026-02-01 00:00:002026-01-01 00:00:002026-02-01 00:00:00<nU LL<null><null>2024-09-05 00:00:007074--09 0000-0102024-03-14 00:00:00<null>ShULl<null>SNULL>ShULl<null>m to Y<null>3026-92-28 00-009 992026-02-28 00:00:002026-03-31 00:00:00I deal_value_min T<null>SHULLe2026-03-10 00:00:00070-05-12 0000-0.0.2026-03-19 00:00:00SNULL><null><null><hULl<null>I deal_value_max Y<null><null><null><null><hULE<null><null><null><null><null><null><null><null><null><null><null><null>I call_types Y<null> ["conference", "dialer"]<null> ["conference" "dialer"]<null> ["conference", "dialer"]<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> []<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> ["conference", "dialer"]<null> []<null> []<nULl> LJ<null> []<nulls []<null> []<null> []#media_types Y["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf", "podcast"]["pdf", "podcast"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]W Windsurf Teams554:1UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9771
|
|
9772
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4 h 10 m100% C4Tue 14 Apr 10:50:49•DOCKER- 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-... 24885-zsh86-zshO 87* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9772
|
|
9773
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9773
|
|
9774
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4h 9m100% C4Tue 14 Apr 10:51:11•DOCKER• 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-..X4885-zsh₴86-zshO x7* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9774
|
|
9775
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4h 9m100% C4Tue 14 Apr 10:51:14•DOCKER• 81DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-..X4885-zsh86-zshO 87* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9775
|
|
9776
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsCommand.php x© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?A QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]Services+,o,c|~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGINGsconsole 1sDocker$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)1);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Outputliii jiminny.automated reports X24 rOWS YIx. Auleyinny recipients Y@additional_prompt_input Y<hUILE<null>ZQGAĐs":[23525]}4 s":[11985]}5 s":[]}6 s": [11985]}7 s":[]}s":[11985]}s":[1}10 s":[10633]}libdj Support Daily • in 4h 9mA• RequestGenerateAskJiminnyReportJobTest v100%Tue 14 Apr 10:51:14= custom.logE laravel.log© AskJiminnyReportActivityService.phpA console (PROD]Al console (EU]A console [STAGING]v 5445451546154715481547550551552553554555556155815571S00SO1563564565 vA SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtOVHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAEajiminny v015 A 12 Х13 ^select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"o>l.n: on p.1d = pc.playbook_10where p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status =acalveAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from au-fnated neport.results where falectuld IN (18, 33) :select * from automated_reports;ShULL<hULE<null>ShULD<null>In custom name YTest 5Ask Jiminny test reportShared with groupweekly reoor - osaole Aurrolareo keoorts 1aa<nULEJiminny recipientRecipientJan ony nechorentCreator - Mobile userJiminny MobileExpires On - 6 AprilExpires on - 5 AprilExpires On - 4 AprilExpires on - 3 aprilExpires On - 2 aprilY - expires on - 1 aprilABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwuM activity_search_id Y1093326912SHULLe<null><nULE<null><null>ShULl<null><null>381143811438115140/1501438115ask_anything_prompt_id YIexpires_at Y62 2026-04-1862 2026-04-30<null> <null>ShuLeo shullchuue chuu<null> <null><null> <null><nul>chuue chuu<nuli> <nui53 2026-04-0658 2026-04-0518 2070-04-041 9026-94-9550 2026-04-0255 2026-04-0156 2024-05-5134 rows retrieved starting from 1 in 1 s 723 ms (execution: 219 ms, fetching: 1 s 504 ms)• :I created by YACVwI created_at Yupdated_at Y3248 2026-04-14 07:18:407070-04-40710.404160 12026-04-08 10.19947026-04-08 10.1995011985 2026-03-31 16:05:3611985 2026-03-31 16:00:0011985 2026-03-31 15:51:5511984 9026-04-41 1499899511985 2026-03-31 15:20:2711985 2026-03-31 15:19:1211985 2026-03-31 15:16:0211989 2026-96-91149929910633 2026-03-31 13:53:3210633 2026-03-31 13:52:500055 7070-05-9119.9711064412026-06-9115.5094210633 2026-03-31 13:48:4710633 2026-03-31 13:45:5210633 2026-03-31 13:42:58• 8,2026-03-31 16:08:062026-03-31 16:00:002026-03-31 15:51:550-9-911.79992026-03-31 15:28:072026-03-31 15:28:032026-03-31 15•27•597006-05-9119.11992026-03-31 14:07:542026-03-31 14:07:55Z0Vo-05-5140e0b-O-C116.29S2026-03-31 16:01:042026-03-31 14:07:542026-05-51 14:01107SUM: 10933 1:23 W Windsurf Teams 554:1 UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9776
|
|
9777
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4h 9m100% C4Tue 14 Apr 10:51:16ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-..X4DOCKER981DEV (-zsh)282APP (-zsh)*3885-zsh86-zshO 87* Unable to acce.O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9777
|
|
9778
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
Analyzing…
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (18, 33);
Project
Project
New File or Directory…...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9778
|
|
9779
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
Analyzing…
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (18, 33);...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9779
|
|
9780
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4h 9 m100% C4Tue 14 Apr 10:51:26•DOCKER- 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-..X4885-zsh₴86-zshO X7* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports] Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9780
|
|
9781
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.moIM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesAEU> A jiminny@localhostdPRODA QAViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsCommand.php x© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes4 QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)1);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+,o,c|~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGINGsconsole 1sDockerOutput34 rowsDid Yliii jiminny.automated reports XIx. AuleyZQGAĐW team_id Y•wuid (UUID with time-Low a.34 63e6d70b-b7cb-4dfa-8443-53453e6c405433 fa7417aa-538e-49ab-8827-77235637a6f932 5c8a4ca1-47d5-46a6-9ddc-f52f5ccf491131 33629f30-c73e-4607-b2d6-c7925573651930 02448e71-1409-4e1c-9075-5c409998578129 74fa30fe-4c67-4995-97c0-8dc7726947cf28 da2b2fba-a16d-4ff6-9282-14ec73083fa127 5804525C-8506-4/C2-0121-58c666278D2426 35054cfe-a74f-46b3-aae9-30732666f30925 1e9f9f11-4b52-491f-86d8-4d463cd8747624 5a98c597-756b-4809-b096-91bcbce273fa23 f264d0ba-3129-443a-9d82-7716cffb667f19 [CREDIT_CARD]-9824-08069620685221 f278e4f1-0f02-40e7-9461-6d18992c724120 2461bd36-1f8c-4162-b7dd-4c03ca39bd7819 439ada99-7374-41b9-95f2-32c4fa691d8818 18c857ec-f1e5-432d-a873-28913f9e6d4dI type Y1 ask_jiminny1 ask_jiminny1 exec summarvstatus Y1 exec_summary1 coaching_profiles1 exec_summary1 exec summarv1 exec summary1 exec_summary1 exec_summary1 ask iiminnv1 ask_jiminny1 ask_jiminny1 ask_jiminny1 ask iiminnv1 ask_jiminny1 ask_jiminnyWindsurf changelog 2.12.21: A new version is available. // View Changelog (18 minutes ago)In frequency Y1 daily1 daily1 one_off_WeeKLy1 weekly1 one_off1 one_off1 one_off1 one_off1 one_offO monthlyo dally1 monthly1 weekly1 dailyO monthly1 dailylibdj Support Daily • in 4h 9mA• RequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:51:25= custom.logE laravel.log© AskJiminnyReportActivityService.phpA console (PROD]Al console (EU]A console [STAGING] >v 5445451546154715481547550551552553554555556155815571S00SO1563564565 v566A SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtOVHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAEajiminny v016 A 13 Х13 ^select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"o>l.n: on p.1d = pc.playbook_10where p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);sflect * from automated_reports;select * from automated_report_results where repontaig IN de/s, 33));I from Y<null><null>2025-07-01 00:00:00<nU LL<null>2025-12-01 00:00:002025-12-01 00:00:00070-01-05 00-00-0109004-12-95 00-909902025-12-01 00:00:00ShULl<nU LL<null><null>ShULL<null><null>to Y<null><null>2026-04-15 00:00:00<null>2026-05-14 00:00:004020-04-90070-05-7 00-00-0.0.2026-01-31 00:00:002026-04-30ShULL<null><null>SIULL<null»<null>I deal_value_min TI deal_value_max T• 8,IO call_<null><null><null><nu l<null><null>SIULL<null><null>SHULLe<null><null><null><null>SIULL<null><null>I call_types Y<null> []<null> []<null> ["conference", "dialer"]<nuLl> L"conterence", "dlaler"J<null> ["conference", "dialer"]<null> ["conference", "dialer"]<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> ["conference", "dialen"]<null> ["conference", "dialer"]<null> []<null> []<null> []<nulls []<null> []<null> []<null> []media_types Y["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]W Windsurf Teams4 spaces...
|
NULL
|
NULL
|
NULL
|
9781
|
|
9782
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (34);
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide
app ~/jiminny/app
.circleci
.cursor
.github
.sonarlint
.vscode
.windsurf
app, sources root
Actions...
|
PhpStorm
|
faVsco.js – console [STAGING]
|
NULL
|
9782
|
|
9783
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.moIM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesAEU> A jiminny@localhostdPRODA QAViewNavigateCodeLaravelRefactorToolsWindowHelp( #11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsCommand.php x© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes4 QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)1);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+,o,c|~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGINGsconsole 1sDockerOutput34 rowsDid Ylini jiminny.automated reports XIx. AuleyZQGAĐ÷m team_id 7Duuid (UUID with time-low a.34 63e6d70b-b7cb-4dfa-8443-53453e6c405433 fa7417aa-538e-49ab-8827-77235637a6f932 5c8a4ca1-47d5-46a6-9ddc-f52f5ccf491131 33629f30-c73e-4607-b2d6-c7925573651930 02448e71-1409-4e1c-9075-5c409998578129 74fa30fe-4c67-4995-97c0-8dc7726947cf28 da2b2fba-a16d-4ff6-9282-14ec73083fa127 5804525C-8506-4/C2-0121-58c666278D2426 35054cfe-a74f-46b3-aae9-30732666f30925 1e9f9f11-4b52-491f-86d8-4d463cd8747624 5a98c597-756b-4809-b096-91bcbce273fa23 f264d0ba-3129-443a-9d82-7716cffb667f19 [CREDIT_CARD]-9824-08069620685221 f278e4f1-0f02-40e7-9461-6d18992c724120 2461bd36-1f8c-4162-b7dd-4c03ca39bd7819 439ada99-7374-41b9-95f2-32c4fa691d8818 18c857ec-f1e5-432d-a873-28913f9e6d4dtype Y1 ask_jiminny1 ask_jiminny1 exec summarvstatus Y1 exec_summary1 coaching_profiles1 exec_summary1 exec summarv1 exec summary1 exec_summary1 exec_summary1 ask iiminnv1 ask_jiminny1 ask_jiminny1 ask_jiminny1 ask iiminnv1 ask_jiminny1 ask_jiminnyWindsurf changelog 2.12.21: A new version is available. // View Changelog (18 minutes ago)In frequency Y1 daily1 daily1 one_off_WeeKLy1 weekly1 one_off1 one_off1 one_off1 one_off1 one_offO monthlyo dally1 monthly1 weekly1 dailyO monthly1 dailylibdj Support Daily • in 4h 9 mA• RequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:51:29= custom.logE laravel.log© AskJiminnyReportActivityService.phpA console (PROD]Al console (EU]A console [STAGING] >v 5445451546154715481547550551552553554555556155815571S00SO1563564565 v566A SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtOVHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAEajiminny v016 A 13 Х13 ^select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"o>l.n: on p.1d = pc.playbook_10where p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);select * from automated_reports;select * from automated_report_results whifre repont. id IN (34p:I from Y<null><null>2025-07-01 00:00:00<nU LL<null>2025-12-01 00:00:002025-12-01 00:00:00070-01-05 00-00-0109004-12-95 00-909902025-12-01 00:00:00ShULl<nU LL<null>SHULLeShULL<null><null>to Y<null><null>2026-04-15 00:00:00<null>2026-05-14 00:00:004020-04-90070-05-7 00-00-0.0.2026-01-31 00:00:002026-04-30ShULL<null><null>SIULL<null»<null>IO deal_value_min Y<null><null><null><null><nili><null><null><hULE<nili<null><null><null><null><null><null><null><nili>I deal_value_max YOcall_types Y<null> []<null> []<null> ["conference","dialer"]<null> ["conference", "dialer"]‹null> ["conference", "dialer"]<null> ["conference", "dialer"]<null> ["conference","dialer"]<null> ["conference", "dialer"]<null> ["conference" "dialer"]<null> ["conference", "dialer"]<null> []<null> []<null> []<null> []<null> []<null> []ACVw#media_types Y["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]["pdf"]W Windsurf TeamsU1F-8® B,IO call_...
|
NULL
|
NULL
|
NULL
|
9783
|
|
9784
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.moIM+INIERNAL WEbOOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.php© AutomatedReportsCommand.php x© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?> A jiminny@localhost> APRODAQA> 4OAA QAI PRODV L STAGING4 console [STAGING]A console_1 [STAGING]A uranus [STAGING]Services+,o,c|v _ Databasev AEU& consoled jiminny@localhostA HS_local4 SFV A PRODconsoleV A STAGING% console 1 s 43 ms& Docker$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX . " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)]);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Outputf jiminny.automated_report_results24 rOWS YDuvid TI report_id YTyr AutaI name TZQGAĐI media_type Y= custom.logE laravel.log© AskJiminnyReportActivityService.phpv 5445451546154715481547550551552553554555556155815571S00SO1563564565566 %A SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx. AUtO vHlaycroundseLect * Trom actIvities wnere 10 = 94/4/783; # UOUU400000pUZOJMALselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"o>l.n: on p.1d = pc.playbook_10where p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);sflect * from automated_reports;select * from automated_report_results where repont.id IN (34);j Support Daily • in 4h 9mA• RequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:51:31A console (PROD]Al console (EU]A console [STAGING] >Eajiminny v016 A 13 Х13 ^Iparent id Y ÷ IMstatus Y ÷Dreason T WpayLogaT = response T÷ Irequested at Y : IMgenerated at YI sent atYIO created_at YACVwI updated_at YWindsurf changelog 2.12.21: A new version is available. // View Changelog (18 minutes ago)W Windsurf Teams566:41UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9784
|
|
9785
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAL QAI4 QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]ViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.phpAutomatedReportsCommand.php x© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)1);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+,o,c|~ D DatabaseV dEU& consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGING4 console 1 s 517 msDockerOutputliii jiminny.automated report results X1 row yIx. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonIO payloadI responseI requested_atoeneraredau• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20snuLlpdf<null><null><null><null><nULL2026-04-14 07:48:572026-04-14 07:48:571 row retrieved starting from 1 in 735 ms (execution: 154 ms, fetching: 581 ms)= custom.logE laravel.log© AskJiminnyReportActivityService.phpv 5445451546154715481547550551552553554555556155815571S00SO1563564565566 v567A SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtO VHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"->l.n: on p.1d = pc.playbooK_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);sflect * from automated_reports;select * from automated_report_results where report.id IN (34);libdj Support Daily • in 4h 9mARequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:51:34A console (PROD]Al console (EU]A console [STAGING] >Eajiminny v016 A 13 Х13 ^=• 8,W Windsurf Teams566:41UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9785
|
|
9786
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4h 9 m100% C4Tue 14 Apr 10:51:36•DOCKER• 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-..X4885-zsh86-zshO x7* Unable to acce.O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports] Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9786
|
|
9787
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAL QAI4 QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]ViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.phpAutomatedReportsCommand.php x© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usaoes101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)1);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Services+,o,c|~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGINGs console lsol/ msDockerOutputliii jiminny.automated report results X1 row yIx. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonIO payloadI responseI requested_atIn generated at• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20snuLlpdf<null><null><null><null><null>2026-04-14 07:48:572026-04-14 07:48:571 row retrieved starting from 1 in 735 ms (execution: 154 ms, fetching: 581 ms)= custom.logE laravel.log© AskJiminnyReportActivityService.phpv 5445451546154715481547550551552553554555556155815571S00SO1563564565566 v567A SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtO VHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"->l.n: on p.1d = pc.playbooK_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);sflect * from automated_reports;select * from automated_report_results where report.id IN (34);libdj Support Daily • in 4h 9mARequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:51:36A console (PROD]Al console (EU]A console [STAGING] >Eajiminny v016 A 13 Х13 ^=• 8,W Windsurf Teams566:41UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9787
|
|
9788
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.phpAutomatedReportsCommand.php X© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?4 QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]Services+,o,c|~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGINGs console lsol/ msDocker$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;94 F* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usages101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)1);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Outputliii jiminny.automated report results X1 row yIx. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonIO payloadI responseI requested_atIn generated at• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20SIULLpdf<null><null><null><null><null>2026-04-14 07:48:572026-04-14 07:48:571 row retrieved starting from 1 in 735 ms (execution: 154 ms, fetching: 581 ms)= custom.logE laravel.log© AskJiminnyReportActivityService.phpv 5445451546154715481547550551552553554555556155815571S00SO1563564565566 v567A SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtOVHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"->l.n: on p.1d = pc.playbooK_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);sflect * from automated_reports;select * from automated_report_results where report.id IN (34);libdj Support Daily • in 4h 9mARequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:51:38A console (PROD]Al console (EU]A console [STAGING] :Eajiminny v016 A 13 Х13 ^=→, 0, 8,SUM: 4 7:1 W Windsurf Teams566:41UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9788
|
|
9789
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4h 9 m100% C4Tue 14 Apr 10:51:42•DOCKER• 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-..X4181885-zsh86-zshO x7* Unable to acce.O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports] Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9789
|
|
9790
|
PhpStormFileEditFV faVsco.s vProject vO dev.json= PhpStormFileEditFV faVsco.s vProject vO dev.json= ids.txtEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mojiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAulomaleakeporisservice.onoCreateHeldActivityEvent.phpAutomatedReportsCommand.php X© TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsCommand extends Commandpublic function handle(): intnunus-›orocesskeoorts, trequency: Auronaredreporusserv.ce..rrcUU-NCY UUARICKLY)?4 QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]Services+,o,c|~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGINGs console lsol/ msDocker$this->logger->info(self::LOG_PREFIX . ' Completed');return 0;94 F* Process reports for a specific frequency.97* @param string $frequency99* Oreturn void4 usages101102103104105106107108109110111private function processReports(string $frequency): void$this->Logger->info(self::LOG_PREFIX " Processing $frequency reports");// Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);$reports = collect([AutomatedReport: : find(68)1);$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");/** @var AutomatedReport $report */Outputliii jiminny.automated report results X1 row yIx. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonIO payloadI responseI requested_atIn generated at• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20SIULLpdf<null><null><null><null><null>2026-04-14 07:48:572026-04-14 07:48:571 row retrieved starting from 1 in 735 ms (execution: 154 ms, fetching: 581 ms)= custom.logE laravel.log© AskJiminnyReportActivityService.phpv 5445451546154715481547550551552553554555556155815571S00SO1563564565566 v567A SF [jiminny@localhost]# HS_local [jiminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpIx: AUtOVHlaycroundSELECt * TrOm aCcIvitIES whEre 10 = 54/4//80; # UUUU40000UPUZOJMAselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"->l.n: on p.1d = pc.playbooK_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team id = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaid IN (18, 33);sflect * from automated_reports;select * from automated_report_results where report.id IN (34);libdj Support Daily • in 4h 9mARequestGenerateAskJiminnyReportJobTest v100% C•Tue 14 Apr 10:51:42A console (PROD]Al console (EU]A console [STAGING] :Eajiminny v016 A 13 Х13 ^=→, 0, 8,SUM: 4 7:1 W Windsurf Teams566:41UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
9790
|
|
9791
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 4h 9m100% C4Tue 14 Apr 10:51:44•DOCKER• 881DEV (-zsh)282APP (-zsh)*3ec2-user@ip-10-30-93-249:-ec2-user@ip-10-30-..X4181885-zsh₴86-zshO x7* Unable to acce...O 88DriversBroadcastingCacheDatabaseLogsMailQueueSessionpusherredismysqlerrorlogsessqsredisStoragepublic/storageNOT LINKEDSentryEnabledEnvironmentLaravel SDKVersionPHP SDK VersionReleaseSample Rate ErrorsSample Rate Performance MonitoringSample Rate ProfilingSend Default PIIYESstaging4.13.04.13.0869720100%NOT SETNOT SETDISABLEDroot@fee51d2e1f17:/home/jiminny#phpartisanautomated-reports[2026-04-14 07:48:51] staging.INF0: [automated-reports]Started{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth": true}id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}{"correlation_[2026-04-14 07:48:51] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]c-8954-5fb1ecfded81"}staging. INF0: [automated-reports] Found 2 daily reports to process{"correlation_id": "4c37ea47-eebd-4122-8c35-9d6b9d707beb", "trace_id" : "bfe6b131-e3ad-4cf[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid": "fa7417aa-538e-49ab-8827-77235637a6f9", "teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}[2026-04-14 07:48:51]staging.INFO: [automated-reports]Dispatching Generate Reportjob for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054"daily", "type": "ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb"',"trace_id": "bfe6b131-e3ad-4cfc-8954-5fblecfded81"}"teamId" :1, "frequency":[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed{"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb""trace_id":"bfe6b131-e3ad-4cfc-8954-5fblecfded81"}root@fee51d2e1f17:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
9791
|