|
11255
|
Close sidebar
Back
Forward
Chat
Cowork
Code
New ch Close sidebar
Back
Forward
Chat
Cowork
Code
New chat
New chat
⇧⌘O
Search
Search
⌘K
Customize
Customize
Chats
Chats
Projects
Projects
Artifacts
Artifacts
Starred
Starred
Bulgarian citizenship application process for EU residents
Bulgarian citizenship application process for EU residents
Dawarich location tracking project
Dawarich location tracking project
Recents Hide
Recents
Hide
Claude API 500 internal server error
Claude API 500 internal server error
More options for Claude API 500 internal server error
Screenpipe query capabilities and usage
Screenpipe query capabilities and usage
eGPU compatibility with Mac mini and Studio
eGPU compatibility with Mac mini and Studio
Understanding OpenRouter API gateway
Understanding OpenRouter API gateway
Screenpipe 14-day retention explained
Screenpipe 14-day retention explained
Reddit homepage feed overview
Reddit homepage feed overview
Docker container not visible in console
Docker container not visible in console
DIA browser RAM configuration
DIA browser RAM configuration
Screenpipe company background
Screenpipe company background
DSK Bank Bulgaria secure investing explained
DSK Bank Bulgaria secure investing explained
Building a comprehensive personal homelab system
Building a comprehensive personal homelab system
Importing Google Timeline data to Owntracks
Importing Google Timeline data to Owntracks
Chromecast remote volume buttons not working
Chromecast remote volume buttons not working
Screenpipe free version guide
Screenpipe free version guide
Self-hosted LLM alternatives to Claude Sonnet
Self-hosted LLM alternatives to Claude Sonnet
Screenpipe database query setup
Screenpipe database query setup
Running screenpipe for free
Running screenpipe for free
Mac Studio network switch setup
Mac Studio network switch setup
Claude extension in Vivaldi browser
Claude extension in Vivaldi browser
General information request
General information request
Red dots on neck causes
Red dots on neck causes
Change approval
Change approval
Querying Screenpipe with Claude AI
Querying Screenpipe with Claude AI
Setting up daily backups in Ugreen NAS
Setting up daily backups in Ugreen NAS
Upcoming reminders
Upcoming reminders
Accessing tools in Open WebUI
Accessing tools in Open WebUI
Laravel issue troubleshooting
Laravel issue troubleshooting
Reminder to take rodný list
Reminder to take rodný list
Setting up reminders in Open WebUI
Setting up reminders in Open WebUI
NAS reverse proxy access issues after UGOS update
NAS reverse proxy access issues after UGOS update
All chats
All chats
Updated to 1.2278.0
Relaunch to apply
Relaunch
Lukas Kovalik, Settings
LK
Lukas Kovalik
Pro plan
Get apps and extensions
Claude API 500 internal server error
Claude API 500 internal server error
More options for Claude API 500 internal server error
what is this in claude code API Error: 500 {"type":"error","error":{"type":"api_error","message":"Internal server error"},"request_id":"req_011Ca224nat8vsw4yXaxtFuR"}
18:39
Retry
Edit
Copy
A 500 Internal Server Error from the Anthropic API means the error is on Anthropic's side, not in your code. It's essentially "something went wrong on our servers."
Common causes:
Transient server hiccup — usually resolves on its own in seconds/minutes
The specific model or feature you're using hit an edge case on the backend
Occasionally happens under high load
What to do:
Retry with exponential backoff
— most 500s are temporary. A simple retry after 1–2 seconds usually works
Check
status.anthropic.com
status.anthropic.com
— if there's an ongoing incident, it'll show there
If it persists
, the
request_id
(
req_011Ca224nat8vsw4yXaxtFuR
) is useful — include it if you open a support ticket, as Anthropic can trace exactly what happened on their end
In Claude Code context specifically
, it can also happen when:
A tool call response is malformed in a way the API chokes on
The conversation context is very long and hits some internal limit
You're using a beta feature with less stability
It's almost never something you need to fix in your code — just retry.
Copy
Give positive feedback
Give negative feedback
Retry
how to search in screenpipe api using search within specific time and app
19:28
Retry
Edit
Copy
The Screenpipe API has a
/search
endpoint. Here's how to query by time range and app:
Basic search with time + app filter:
Copy to clipboard
bash
curl
"http://localhost:3030/search?q=your+query&start_time=2026-04-13T09:00:00Z&end_time=2026-04-13T17:00:00Z&app_name=Arc&limit=20"
Key query parameters:
Parameter
Format
Example
q
string
meeting notes
start_time
ISO 8601
2026-04-13T09:00:00Z
end_time
ISO 8601
2026-04-13T17:00:00Z
app_name
string
Arc
,
Code
,
Slack
content_type
ocr
/
audio
/
all
ocr
limit
number
50
offset
number
0
Parameter
q
start_time
end_time
app_name
content_type
limit
offset
Format
string
ISO 8601
ISO 8601
string
ocr
/
audio
/...
|
Claude
|
Claude
|
NULL
|
11255
|
|
11254
|
Close sidebar
Back
Forward
Chat
Cowork
Code
New ch Close sidebar
Back
Forward
Chat
Cowork
Code
New chat
New chat
⇧⌘O
Search
Search
⌘K
Customize
Customize
Chats
Chats
Projects
Projects
Artifacts
Artifacts
Starred
Starred
Bulgarian citizenship application process for EU residents
Bulgarian citizenship application process for EU residents
Dawarich location tracking project
Dawarich location tracking project
Recents Hide
Recents
Hide
Claude API 500 internal server error
Claude API 500 internal server error
More options for Claude API 500 internal server error
Screenpipe query capabilities and usage
Screenpipe query capabilities and usage
eGPU compatibility with Mac mini and Studio
eGPU compatibility with Mac mini and Studio
Understanding OpenRouter API gateway
Understanding OpenRouter API gateway
Screenpipe 14-day retention explained
Screenpipe 14-day retention explained
Reddit homepage feed overview
Reddit homepage feed overview
Docker container not visible in console
Docker container not visible in console
DIA browser RAM configuration
DIA browser RAM configuration
Screenpipe company background
Screenpipe company background
DSK Bank Bulgaria secure investing explained
DSK Bank Bulgaria secure investing explained
Building a comprehensive personal homelab system
Building a comprehensive personal homelab system
Importing Google Timeline data to Owntracks
Importing Google Timeline data to Owntracks
Chromecast remote volume buttons not working
Chromecast remote volume buttons not working
Screenpipe free version guide
Screenpipe free version guide
Self-hosted LLM alternatives to Claude Sonnet
Self-hosted LLM alternatives to Claude Sonnet
Screenpipe database query setup
Screenpipe database query setup
Running screenpipe for free
Running screenpipe for free
Mac Studio network switch setup
Mac Studio network switch setup
Claude extension in Vivaldi browser
Claude extension in Vivaldi browser
General information request
General information request
Red dots on neck causes
Red dots on neck causes
Change approval
Change approval
Querying Screenpipe with Claude AI
Querying Screenpipe with Claude AI
Setting up daily backups in Ugreen NAS
Setting up daily backups in Ugreen NAS
Upcoming reminders
Upcoming reminders
Accessing tools in Open WebUI
Accessing tools in Open WebUI
Laravel issue troubleshooting
Laravel issue troubleshooting
Reminder to take rodný list
Reminder to take rodný list
Setting up reminders in Open WebUI
Setting up reminders in Open WebUI
NAS reverse proxy access issues after UGOS update
NAS reverse proxy access issues after UGOS update
All chats
All chats
Updated to 1.2278.0
Relaunch to apply
Relaunch
Lukas Kovalik, Settings
LK
Lukas Kovalik
Pro plan
Get apps and extensions
Claude API 500 internal server error
Claude API 500 internal server error
More options for Claude API 500 internal server error
what is this in claude code API Error: 500 {"type":"error","error":{"type":"api_error","message":"Internal server error"},"request_id":"req_011Ca224nat8vsw4yXaxtFuR"}
18:39
Retry
Edit
Copy
A 500 Internal Server Error from the Anthropic API means the error is on Anthropic's side, not in your code. It's essentially "something went wrong on our servers."
Common causes:
Transient server hiccup — usually resolves on its own in seconds/minutes
The specific model or feature you're using hit an edge case on the backend
Occasionally happens under high load...
|
Claude
|
Claude
|
NULL
|
11254
|
|
11253
|
cl
iTerm2ShellEditViewSessionScriptsProfilesWindow cl
iTerm2ShellEditViewSessionScriptsProfilesWindowHelp• •DOCKERviews• ₴1DEV (docker)APP (-zsh)*3jiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: stoppedjiminny-worker-processing-2:jiminny-worker-procaccina2 aл.sing-delayed 00: stoppedjiminny-worker-processing-3: jiminny-worker-prjiminny-worker-processing-4:jiminny-worker-prjiminny-worker-processing-5:jiminny-worker-prworker-analytics:worker-analytics_00: stoppedworker-crm-update:worker-crm-update_00: stoppedworker-download:worker-download_00: stoppedworker-nudges:worker-nudges_00: stoppedworker-emails:worker-emails_00: stoppedworker-crm-sync:worker-crm-sync_00:stoppedjiminny-worker-processing-1:jiminny-worker-processing-1_00: stoppedworker-calendar:worker-calendar_00:stoppedworker-audio:worker-audio_00: stoppedworker-conferences:worker-conferences_00: stoppedworker:worker_00: stoppedworker-es-update:worker-es-update_00: stoppedartisan-schedule:artisan-schedule_00: stoppedartisan-schedule:artisan-schedule_00: startedjiminny-worker-processing-1:jiminny-worker-processing-1_00: startedjiminny-worker-processing-2:jiminny-worker-processing-2_00: startedjiminny-worker-processing-3:jiminny-worker-processing-3_00: startedjiminny-worker-processing-4:jiminny-worker-processing-4_00: startedjiminny-worker-processing-5:jiminny-worker-processing-5_00: startedjiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: startedworker:worker_00: startedworker-analytics:worker-analytics_00: startedworker-audio:worker-audio_00: startedworker-calendar:worker-calendar_00: startedworker-conferences:worker-conferences_00: startedworker-crm-sync:worker-crm-sync_00: startedworker-crm-update:worker-crm-update_00: startedworker-download:worker-download_00:startedworker-emails:worker-emails_00: startedworker-es-update:worker-es-update_00: startedworker-nudges:worker-nudges_00: startedroot@docker_lamp_1:/home/jiminny#php artisan automated-reports 265DEV (docker)ec2-user@ip-10-30-….X4-zsh$0(abl885Support Daily • in 2h 38 m-zsh86100% <47O 87Tue 14 Apr 12:22:29181* Unable to acce...O 88-zsh43.92ms DONEDEVNo arguments expected for "automated-reports" command, got "265".root@docker_lamp_1:/home/jiminny# ]...
|
Alfred
|
Alfred
|
NULL
|
11253
|
|
11252
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp• •DOCKERconfigcachecompiledeventsroutesviews• 81DEV (docker)APP (-zsh)X3jiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: stoppedjiminny-worker-processing-2:jiminny-worker-processing-2_00: stoppedjiminny-worker-processing-3:jiminny-worker-processing-3_00:stoppedjiminny-worker-processing-4:jiminny-worker-processing-4_00:stoppedjiminny-worker-processing-5:jiminny-worker-processing-5_00: stoppedworker-analytics:worker-analytics_00: stoppedworker-crm-update:worker-crm-update_00:stoppedworker-download:worker-download_00:stoppedworker-nudges:worker-nudges_00: stoppedworker-emails:worker-emails_00: stoppedworker-crm-sync:worker-crm-sync_00:stoppedjiminny-worker-processing-1:jiminny-worker-processing-1_00: stoppedworker-calendar:worker-calendar_00:stoppedworker-audio:worker-audio_00: stoppedworker-conferences:worker-conferences_00: stoppedworker:worker_00: stoppedworker-es-update:worker-es-update_00: stoppedartisan-schedule:artisan-schedule_00: stoppedartisan-schedule:artisan-schedule_00: startedjiminny-worker-processing-1:jiminny-worker-processing-1_00: startedjiminny-worker-processing-2:jiminny-worker-processing-2_00: startedjiminny-worker-processing-3:jiminny-worker-processing-3_00: startedjiminny-worker-processing-4:jiminny-worker-processing-4_00: startedjiminny-worker-processing-5:jiminny-worker-processing-5_00: startedjiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: startedworker:worker_00: startedworker-analytics:worker-analytics_00: startedworker-audio:worker-audio_00: startedworker-calendar:worker-calendar_00: startedworker-conferences:worker-conferences_00: startedworker-crm-sync:worker-crm-sync_00: startedworker-crm-update:worker-crm-update_00: startedworker-download:worker-download_00:startedworker-emails:worker-emails_00: startedworker-es-update:worker-es-update_00: startedworker-nudges:worker-nudges_00: startedroot@docker_lamp_1:/home/jiminny# php artisan automated-reports 265(ablSupport Daily - in 2 h 38 m100% <47DEV (docker)ec2-user@ip-10-30-…X4-zsh885-zsh86-zsh41.20ms DONE61.54ms DONE3.39ms DONE5.01ms DONE3.37ms DONE43.92ms DONEO 87Tue 14 Apr 12:22:27181* Unable to acce...O 88DEV...
|
NULL
|
NULL
|
NULL
|
11252
|
|
11251
|
PhpStormFileFditViewNavigateCodeLaravelPetactorToo PhpStormFileFditViewNavigateCodeLaravelPetactorToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny K vProject v(©) ReportController.php© JiminnyDebugCommand.phpC AutomatedReportsCommand.php XC) AutomatedReportsSendCommand.phpC AddLayoutEntities.php(C) Team.php= custom.loaC AutomatedReportsRepository.phpC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpC CreateActivityLoggedEvent.php= hubspot-iournal-poll.loo= laravel.log<» phpunit.xm.Is ttt.js= oauth-private.key© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php(©) AutomatedReportResult.phpclass AutomatedReportsCommand extends Command= oauth-public.key=storage= supervisoro,oid* dreturn intpubuic tunccion nandlel: int"rexceav.sonv Mtests> _ Feature5758$this->logger->info(self::LOG_PREFIX . ' Started');> Integration$now = Carbon::nowO:› _ ServicesW Unit>D Actions_ component$isMonday = Snow->isMondayO:SisFirstDay0fMonth = Snow->day === 1:$currentMonth = Snow->month;_ contigurationM ConsoleM ContractsM DomainMDTOEnums_Events• ExceptionsO fixturesHelpersHttp_ Integrations/ Check if the current month is a quarterly month (January, April, July, Uctober)s1sQuarterlyMonth = 1n_array($currentMonth, l1, 4, 7, 10J,strict: true)фuhis->logger->inro(selt::LUG_PREFLX •' Checking conditions', ["Istonday = s1sMonday,'isFirstDav0fMonth'= SisFirstdayutMonch,'currentMonth' => ScurrentMonth.'isQuarterlyMonth' => SisQuarterlyMonth.D :/ Process danly reportssthis->processReports trequency: AutomatedReportsservice::FREQUENCY_DAILYJ*_Interactionsv D Jobs>_ActivityM AiAutomation>M Audio// Process weekly reporus on MondaysIt (p1sMlonday)nunus-›orocesskeoorts, trequency: Auronaredreportsservce..rrcouaNcy weckLyonv _ AutomatedReports©) CreateResultsTest.p©) RequestGenerateAsh// Process monthly reports on the first day of the monthif SisFirstDay0fMonth)(C) RequestGenerateRersthis->processReports( frequency: AutomatedReportsService::FREQUENCY_MONTHLY):(c) SendReportJobTest.(ch SendRenortMailJobtcallendari1erm/ Process quarterly reports on the first day of January, April, July, and Uctoberif ($isFirstDay0fMonth && $isQuarterlyMonth) {DealRisksSnuns-orocessreoortsrecuencv: Autolaredke.ortscery ce.trk-ouENeY WUAKlEKLY|MalloOXM StreaminaselvicesТОGЛU Output:OOU0400000036t0MAC Xv DatabaseV AEU8 rowsvDid YDuuid (UUID with time-low and time-h.. Y : media_type YWstatus VW type uc consoev diminny@localhost265 926befa2-5d77-4ab3-a553-587a1d5d9f5ds ho local4SF 4 gV L PRODd consolev ¿ STAGNGpatodf4 ask jiminny266 656713b0-459c-4094-9823-ffe013dbc8084 ask iininnv26/ 319094f0-7368-4eC1-8f2b-a15b99bb5/ec269 d3037407-091e-438a-8c8e-6745c5bf8df9271 09fd931c-117a-47b7-8ccb-abe2e5fe01a124 01 00029-0050-4841-0342-7205070101d console 1s 153 ms,, Docker275 ff55bec0-961d-495f-b8fb-dbc2e1d252/9pdfpdfpdfpdfpdf1 ask_jiminny4 ask Timinny4 ask jiminny1 ask_jiminny3 ask_J1m1nnylests passed: 1 (13 minutes ago)Suobort Dailv • in 2h 38mTve 14 Aor12:22:25= custom.log#concole f.unl4 console [STAGING]C HistoryService.php(Ch RequestGenerateAsk.liminnvRenort.JohTest.nhoThe file size (7.86 MB) exceeds the configured limit (2.56 MB). Code insight features are not available.IZUZo-VFe Urarzol Tocur arror Tcncoyo cedrorenanaoer veneraqmo access corenr mode Tеdai12789147858ZY80Y298602986129862298652986629864780047807278/0ZY8/29872298732987429875298762987729878298791478802988129882298832988429888298892989014020-04-14 07.4120 LOCOL. LNrUrSocialAccountServicel Refreshing token from provider {"socialA12026-04-14 09:21:281 Zocal.ERROR: Failed to refresh HubSpot token {"account id":306.2026-04-14 09:21:28 local.INFO:Trying to refresh HubSpot token "account_ id":13722026-04-14 09:21:28 local.INFO:EncryptedTokenManager Generating access token. "mode":"Le2026-04-14SocialAccountService Refreshing token from provider12026-04-1409.91.90 ocal FRROr• SaTled to nornach Huhsnot token C'account 101.152)12026-04-14ncai Mner. Renainind Huhsnot tokens end c"totalles "tiyedied.n12026-04-14LocaL.INFO: Jiminny Console\Commands \Command::run Memory usage before starting command 1"17070-04-14Jiminny \console commands command::run Memory usage berore staruing command ?1070-04-1409:21:391|Jiminny\consoLe commanas (command::run Memory usage for commana i"command"."J1Г2026-04-1409:21:391Huosoor Journal rouunol bertno ottser tron caranase -"oti12026-04-1409:21:391 ZocalCommandl Starting polling service12026-04-14 09:21:391 ZocalPollinal Service starting {"me[2026-04-14 09:21:391Pollingl Acquired polling lock {"expi2026-04-14 09:21:39]Polling Getting offset from database2026-04-14 09:21:39]API. Fetching latest journal entry "urlmLuos. dol.nuvdo.L2026-04-14 09:21:39JAuth Requesting new client credentials token12026-04-14 09:21:39Jand• • nun Memony ucade Fon commandl[2026-04-14 09:21:39]Tocal. INF0:[HubSpot JournalAuth] Successfullyoptained new access token {"expires_in":18L2026-04-14 09:21:59J local. INF0:Hubsoot JournalPoluino No data{"correlation id"."316142e2-a958-41a5-8eef.[2026-04-14 09:21:441 Zocal. TNF0:Huosoor dournaliPollinal Getting offset from database[2026-04-14 09:21:441 Zocal. TNF0:Huosoor dournalirerchne arest ournal entryToS:ao.nuoaon12026-04-14 09:21:441 Zocal. INF0:HubSpot Journal2e2-a958-41a5-8eef-12026-04-14 09:21:461 Zocal. INF0:Jiminny Console Commands Command::run Memory usage before starting command {"(12026-04-14 09:21:461 Zocal. INF0:Jiminny Console Commands Command:: run Memory usage for command {"command". "crn2026-04-14 09:21:50 local.INFO:HubSpot Journal Polling Getting offset from database "offset":"""Jiminny12026-04-14 09:21:50 local.INFO:HubSpot Journal API. Fetching latest journal entry"url":"https:/api.hubapi2026-04-14 09:21:50 local.INFO:HubSpot JournalL2026-04-14 09:21:52) local.INFO:Jiminny Console \Commands \Command::run Memory usage before starting command 1"c12[PHONE]9-91.52 Ocal TNE0"Jiminny Console \Commands \Command::run Memory usage for command 1"command":"cr.[2026-04-14 09:22:05] Zocal.INF0: [HubSpot Journal Polling] Getting offset from database {"offset":"" "jiminny_Г2026-04-14 09:22:051 Zoca1.TNF0: [HubSpot Journal APTl Fetching latest iournal entry {"ur]"."httos: //ani hubaniГ2026-04-14 09:22-051 Zoca1. TNF0•fHubSpot JournallPolLuine ilSlol4er-ayn8-4la0-seet12026-04-14 09:22:151 Zocal. INF0:Commands/AsyncUpdateEsEntitiesl Starting ESupdate worker {"pid":37760. "workCsv | 2 L →| 0, 8W Windsurf Teams 29891:1 UTF-8 ( 4 spa...
|
NULL
|
NULL
|
NULL
|
11251
|
|
11250
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
PhpStormFileEditFV faVsco.s vProject v=.prettierignore= wino sunrulesphp_ide_helper.phppnpce neloermoces.onepnpalrsani composer.isoni composer.lockdependency-checker.jsonO dev.jsonEids.txt=infection.json.distM-INSALLmdM-INIERNAL WE.nOOK S-IUP.mojiminny_storageMvcenses.meMIMakerleO package-lock.json= phpstan.neon.distE phpstan-baseline.neon<phpunit.xmlTe raw_sql_query.sqlM.README.molsonar-project.properties= test.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› iib External Librariesv E® Scratches and Consolesv D Database Consoles> A EUv A jiminny@localhostA console [jiminny@localhost4 DI [jiminny@localhost]A HS_local [iminny@localhosA SF [jiminny@localhost]4 zoho_dev [jiminny@localha7CPRODÁ QA> L QAI4 QAI PRODA STAGINGA console [STAGING]A console_1 [STAGING]« uranus [STAGING]ViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.phpJiminnybeouecommana.ong© AutomatedReportsCommand.php x© AutomatedReportsRepository.phpC AutomatedReportsService.phpCreateHeldActivityEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© AutomatedReportResult.phpclass AutomatedReportsCommand extends Command© AutomatedReportsSendCommand.php• TrackProviderInstalledEvent.php© RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php• RequestGenerateReportJob.php* Oreturn intpublic function handle(): int$this->logger->info(self::LOG_PREFIX . ' Started');$now = Carbon: :now();$isMonday = $now->isMonday();$isFirstDay0fMonth = $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],strict: true);$this->logger->info(self::LOG_PREFIX' Checking conditions', I"isrondav"→ $1sronday,'isFirstDay0fMonth'→ $isFirstDay0fMonth,'currentMonth' => $currentMonth,'isQuarterlyMonth' => SisQuarterlyMonth.I);// Process daily reports$this->processReports( frequency: AutomatedReportsService::FREQUENCY_DAILY);// Process weekly reports on Mondaysif ($isMonday) {nunus-›orocesskeoorts, trequency: Auronaredreportsservce..rrcouaNcy weckLyon// Process monthly reports on the first day of the monthif ($isFirstDay0fMonth) {$this->processReports( frequency: AutomatedReportsService: :FREQUENCY_MONTHLY);// Process quarterly reports on the first day of January, April, July, and Octoberif ($isFirstDay0fMonth && $isQuarterLyMonth) {nuns-orocessre.ortsrecuencv:Autolaredrenoriscery..cer.Fk-OUENCY WUARIEKLYservicesv _ DatabasevdtuA consolev&jiminny@localhostc moocallASF 4:V A PRODs consoleV A STAGING4 console 1 s 153 msDockerOutput8 rowsMid Tf # 00UO400000pB6fpMAC500Iuuid UUID with time-low and time-h.265 926befa2-5d77-4ab3-a553-587a1d5d9f5d266 656 [CREDIT_CARD]-5F201500c808267 319094f0-7368-4ec1-8f2b-a15b99bb37ec269 d3037407-091e-438a-8c8e-6745c5bf8df9271 09fd931c-117a-47b7-8ccb-abe2e5fe01a174 [CREDIT_CARD]-8542-927050970101275 ff55bec0-961d-493f-b8fb-dbc2e1d25279T : media_type Y00TipdfpdfpdfpdfpdfI status Y• type Y4 ask jiminny4 ask_jiminny1 ask jiminny4 ask_jiminny4 ask_jiminny1lask jiminnv3 ask_jiminnyTests passed: 1 (13 minutes ago), 0f Support Daily • in 2h 38 mAAsk. JiminnvRenortActivitvServicet..Defaultsv100% C•Tue 14 Apr 12:22:22= custom.log= laravel.logA SF [jiminny@localhost]4 HS_local [jiminny@localhost]Al console [PROD]A console [EU]Á console [STAGING]Аsmnлукеpoнaсiмly serиice.рпр© ActivitySearch.phpcOnbemanavzcontroller.oneC HistoryService.php© FilterDefinitionCollection.php© Criteria.php© AskJiminnyReportActivityServiceTest.phpRequestGenerateAskJiminnyReportJobTest.phpX:Auto vPlaygroundMa lminnv v153SELECT * FROM activity_search_filters WHERE activity_search_id = 1982;010 A12 V.2 У.4 л154155156SELECT * FROM automated_reports where id = 68;SELECT * FROM automated_report_results where id = 275;157158SELECT * FROM automated_reports order by id desc;159SELECT * FROM automated_report_results order by id desc;160select * from activity_searches where user_id = 143;161Iselect * from ask anvthina promots:162163SELECT * FROM groups WHERE id = 1439;164SELECT * FROM users WHERE group_id = 1439;165166select * from permissions; # 158167select * from roles;168select * from permission_role169170171172select * from teams where id = 1;select * from groups g JOIN playbooks p 1.n<→>1: on g.playbook_id = p.id where g.team_id = 1;173174175176select * from playbook_categories where id = 1391;177178179180select * from crm_profiles where user_id = 143;select * from activities where crm_configuration_id = 39 and type ='conference'and crm_provider_id IS NOT NULL ORDER by id desc;select * from activities where id = 422003; # 00U0400000pB6fрМАC181182 v183184SELECT ar.ig, ar.uuig, ar.mediantyke, ar.status, a.LVRSIFROM automated report results anJOINautomated_reports a ON a.id = ar.cepontoid185186LIMIT 10;187188{"request_id": "edc47759-160a-4f61-82fc-c8cdf5e55464", "status": "completed", "timestamp" :"2026-03-31T15:52:05.82822189190|_191s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.MDs3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdf• : -esVySUM: 265 1:1 W Windsurf Teams184:17 UTF-8 4 spa...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11250
|
|
11249
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
iTerm2ShellEditViewSessionScriptsProfilesWindowHelp• 0DOCKERconfigcachecompiledeventsroutesviews981DEV (docker)APP (-zsh)X3jiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: stoppedjiminny-worker-processing-2:jiminny-worker-processing-2_00: stoppedjiminny-worker-processing-3:jiminny-worker-processing-3_00:stoppedjiminny-worker-processing-4:jiminny-worker-processing-4_00:stoppedjiminny-worker-processing-5:jiminny-worker-processing-5_00: stoppedworker-analytics:worker-analytics_00: stoppedworker-crm-update:worker-crm-update_00:stoppedworker-download:worker-download_00:stoppedworker-nudges:worker-nudges_00: stoppedworker-emails:worker-emails_00: stoppedworker-crm-sync:worker-crm-sync_00:stoppedjiminny-worker-processing-1:jiminny-worker-processing-1_00: stoppedworker-calendar:worker-calendar_00:stoppedworker-audio:worker-audio_00: stoppedworker-conferences:worker-conferences_00: stoppedworker:worker_00: stoppedworker-es-update:worker-es-update_00: stoppedartisan-schedule:artisan-schedule_00: stoppedartisan-schedule:artisan-schedule_00: startedjiminny-worker-processing-1:jiminny-worker-processing-1_00: startedjiminny-worker-processing-2:jiminny-worker-processing-2_00: startedjiminny-worker-processing-3:jiminny-worker-processing-3_00: startedjiminny-worker-processing-4:jiminny-worker-processing-4_00: startedjiminny-worker-processing-5:jiminny-worker-processing-5_00: startedjiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: startedworker:worker_00: startedworker-analytics:worker-analytics_00: startedworker-audio:worker-audio_00: startedworker-calendar:worker-calendar_00: startedworker-conferences:worker-conferences_00: startedworker-crm-sync:worker-crm-sync_00: startedworker-crm-update:worker-crm-update_00: startedworker-download:worker-download_00:startedworker-emails:worker-emails_00: startedworker-es-update:worker-es-update_00: startedworker-nudges:worker-nudges_00: startedroot@docker_lamp_1:/home/jiminny# php artisan automated-reports 265(ablSupport Daily - in 2 h 38 m100% <47DEV (docker)ec2-user@ip-10-30-…X4-zsh885-zsh86-zsh41.20ms DONE61.54ms DONE3.39ms DONE5.01ms DONE3.37ms DONE43.92ms DONEO 87Tue 14 Apr 12:22:22181* Unable to acce...O 88DEV...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11249
|
|
11248
|
PhpStormFileEditFV faVsco.s vProject vO package-lo PhpStormFileEditFV faVsco.s vProject vO package-lock.jsonE phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTa raw_sql_query.sqlM+R-ADME,moso sonar-proiect propertiesE test.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External Librariesv E° Scratches and Consoles~ D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp( #11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsRepository.phpC AutomatedReportsService.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportResult.phpclass AutomatedReportsCommand extends CommandAjiminny@localhost4 console [jiminny@localhost4 DI [jiminny@localhost]c noocaminnvolocanos4 SF [iiminny@localhost]s cono dev minny clocaine> A PRODservices~ D DatabaseV dEUA consolev djiminny@localhostansocallASF 4 sV A PRODconsoleV A STAGING&console Is losms& Docker© AutomatedReportsCommand.php x© AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.php* Oreturn intpublic function handle(): int58$this->logger->info(self::LOG_PREFIX . ' Started');$now = Carbon: :now();$isMonday = $now->isMonday();$isFirstDay0fMonth = $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],strict: true);$this->logger->info(self::LOG_PREFIX' Checking conditions', I"Istonday = $1sMonday,Output8 rowsDid Yf # 00UO400000pB6fpMAC x5 0,Muvid (UUID with time-low and time-h...265 926befa2-5d77-4ab3-a553-587a1d5d9$5d166 [CREDIT_CARD]-9895-77001560689%267 319094f0-7368-4ec1-8f2b-a15b99bb37ec269 d3037407-091e-438a-8c8e-6745c5bf8df9271 09fd931c-117a-47b7-8ccb-abe2e5fe01a1274 6f18db25-c836-4a21-8542-927b3b9f01bf275 ff55bec0-961d-493f-b8fb-dbc2e1d25279276 8617904b-71f4-485f-861c-c045e9cbf2a7I media_type Tpdfpdfpdfpdfpdfpdfpdfpdf; status Y" type Y4 ask_jiminny4 ask_jiminny1 ask_jiminny4 ask iiminnv4 ask_jiminny1 ask_jiminny3 ask_jiminny4 ask_J1m1nny, 0Support Daily - in 2h 38mAAskJiminnyReportActivityServiceT...Defaults v100% C•Tue 14 Apr 12:22:19= custom.logElaravel.logA SF ljiminny@localhost]4 HS_local [jiminny@localhost]Al console [PROD]A console [EU]Á console [STAGING]© AskJiminnyReportActivityService.php© ActivitySearch.phpOnbemanavzcontroller.onoC HistoryService.php© FilterDefinitionCollection.php© Criteria.php© AskJiminnyReportActivityServiceTest.phpRequestGenerateAskJiminnyReportJobTest.phpX:Auto vPlavaroundvMa lminnv vIselect * from activities where crm confiquration id = 39 and tvoe = 'conferencel010 A12 V.2 У.4 л179and crm_provider_id IS NOT NULL ORDER by id desc;1180select * from activities where id = 422003; # 00U0400000pB6fpМAC|181182v183184SELECT ar.id, ar.wid, ar.mediantype, ar.status, a.tyReFROM automated_report_results arJOIN automated_reports a ON a.ig = ar. repont.idWHERE a.tyRg = 'ask_jiminnx'186LIMIT 10;187188189f"request_id": "edc47759-160a-4f61-82fc-c8cdf5e55464", "status": "completed", "timestamp" : "2026-03-31T15:52:05.828229-191s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.MDs3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdfCSVTests passed: 1 (13 minutes ago)SUM: 265 1:1 W Windsurf Teams 184:17UTF-84 spa...
|
NULL
|
NULL
|
NULL
|
11248
|
|
11247
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp• •DOCKERconfigcachecompiledeventsroutesviews• 881DEV (docker)APP (-zsh)X3jiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: stoppedjiminny-worker-processing-2:jiminny-worker-processing-2_00: stoppedjiminny-worker-processing-3:jiminny-worker-processing-3_00:stoppedjiminny-worker-processing-4:jiminny-worker-processing-4_00:stoppedjiminny-worker-processing-5:jiminny-worker-processing-5_00: stoppedworker-analytics:worker-analytics_00: stoppedworker-crm-update:worker-crm-update_00:stoppedworker-download:worker-download_00:stoppedworker-nudges:worker-nudges_00: stoppedworker-emails:worker-emails_00: stoppedworker-crm-sync:worker-crm-sync_00:stoppedjiminny-worker-processing-1:jiminny-worker-processing-1_00: stoppedworker-calendar:worker-calendar_00:stoppedworker-audio:worker-audio_00: stoppedworker-conferences:worker-conferences_00: stoppedworker:worker_00: stoppedworker-es-update:worker-es-update_00: stoppedartisan-schedule:artisan-schedule_00: stoppedartisan-schedule:artisan-schedule_00: startedjiminny-worker-processing-1:jiminny-worker-processing-1_00: startedjiminny-worker-processing-2:jiminny-worker-processing-2_00: startedjiminny-worker-processing-3:jiminny-worker-processing-3_00: startedjiminny-worker-processing-4:jiminny-worker-processing-4_00: startedjiminny-worker-processing-5:jiminny-worker-processing-5_00: startedjiminny-worker-processing-delayed: jiminny-worker-processing-delayed_00: startedworker:worker_00: startedworker-analytics:worker-analytics_00: startedworker-audio:worker-audio_00: startedworker-calendar:worker-calendar_00: startedworker-conferences:worker-conferences_00: startedworker-crm-sync:worker-crm-sync_00: startedworker-crm-update:worker-crm-update_00: startedworker-download:worker-download_00:startedworker-emails:worker-emails_00: startedworker-es-update:worker-es-update_00: startedworker-nudges:worker-nudges_00: startedroot@docker_lamp_1:/home/jiminny# php artisan automated-reports 265(ablSupport Daily - in 2 h 38 m100% <47DEV (docker)ec2-user@ip-10-30-…X4-zsh885-zsh86-zsh41.20ms DONE61.54ms DONE3.39ms DONE5.01ms DONE3.37ms DONE43.92ms DONEO 87Tue 14 Apr 12:22:19181* Unable to acce...O 88DEV...
|
NULL
|
NULL
|
NULL
|
11247
|
|
11246
|
PhpStormFileEditFV faVsco.s vProject vO package-lo PhpStormFileEditFV faVsco.s vProject vO package-lock.jsonE phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTaraw_sqlLquery.sqlM+R-ADME,moso sonar-proiect propertiesE test.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External Librariesv E° Scratches and Consoles~ D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsRepository.phpC AutomatedReportsService.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportResult.phpclass AutomatedReportsCommand extends CommandAjiminny@localhost4 console [jiminny@localhost4 DI [jiminny@localhost]c nooca minnvolocanos4 SF [iiminny@localhost]s cono dev minny clocaine> A PRODservices~ D DatabaseV dEUA consolev djiminny@localhostansocallASF 4 sV A PRODconsoleV A STAGING&console Is losmsDocker© AutomatedReportsCommand.php x© AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.php* Oreturn intpublic function handle(): int58$this->logger->info(self::LOG_PREFIX . ' Started');$now = Carbon: :now();$isMonday = $now->isMonday();$isFirstDay0fMonth = $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],strict: true);$this->logger->info(self::LOG_PREFIX' Checking conditions', I"Istonday = s1sMonday,Output8 rowsDid Yf # 00UO400000pB6fpMAC x5 0,Muvid (UUID with time-low and time-h...265 926befa2-5d77-4ab3-a553-587a1d5d9$5d166 [CREDIT_CARD]-9895-77001560689%267 319094f0-7368-4ec1-8f2b-a15b99bb37ec269 d3037407-091e-438a-8c8e-6745c5bf8df9271 09fd931c-117a-47b7-8ccb-abe2e5fe01a1274 6f18db25-c836-4a21-8542-927b3b9f01bf275 ff55bec0-961d-493f-b8fb-dbc2e1d25279276 8617904b-71f4-485f-861c-c045e9cbf2a7ID media_type Tpdfpdfpdfpdfpdfpdfpdfpdf÷ Wstatus Y" type Y4 ask_jiminny4 ask_jiminny1 ask_jiminny4 ask iiminnv4 ask_jiminny1 ask_jiminny3 ask_jiminny4 ask iiminny, 0Support Daily - in 2h 38mAAskJiminnyReportActivityServiceT...Defaults v100% C•Tue 14 Apr 12:22:16= custom.logElaravel.logA SF [jiminny@localhost]4 HS_local [jiminny@localhost]Al console [PROD]A console [EU]Á console [STAGING]C AskJiminnyReportActivityService.php© ActivitySearch.phpc Onbemanavzcontroller.onoC HistoryService.php© FilterDefinitionCollection.php© Criteria.php© AskJiminnyReportActivityServiceTest.phpRequestGenerateAskJiminnyReportJobTest.phpX:Auto vPlaygroundMa lminnv vIselect * from activities where crm confiquration id = 39 and tvoe = 'conferencel010 A12 V.2 У.4 л179and crm_provider_id IS NOT NULL ORDER by id desc;1180select * from activities where id = 422003; # 00U0400000pB6fpМAC|181182v183184SELECT ar.id, ar.uid, ar.mediantype, ar.status, a.tyRsFROM automated_report_results arJOIN automated_reports a ON a.ig = ar. repontaidWHERE a.tyRg = 'ask_jiminnx'186LIMIT 10;187188189f"request_id": "edc47759-160a-4f61-82fc-c8cdf5e55464", "status": "completed", "timestamp" : "2026-03-31T15:52:05.828229-191s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.MDs3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdf=• : -CSV8 rows retrieved starting from 1 in 942 ms (execution: 105 ms, fetching: 837 ms)SUM: 265 1:1 W Windsurf TeamsUTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
11246
|
|
11245
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Code changed:
Hide
Sync Changes
Hide This Notification
10
12
2
4
Previous Highlighted Error
Next Highlighted Error
SELECT a.id, a.uuid, a.actual_start_time, o.id, o.uuid FROM opportunities o
JOIN activities a ON o.id = a.opportunity_id
WHERE a.crm_configuration_id = 39
AND a.actual_start_time > '2025-10-13'
AND a.type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM activities
WHERE crm_configuration_id = 39 and user_id = 143
and actual_start_time >= '2025-10-13'
AND type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM opportunities WHERE account_id IN (178);
select * from activities where id IN (620137, 620187, 620188, 620189, 620230);
# HS
SELECT * FROM opportunities WHERE id IN (238);
select * from activities where id IN (477,2076);
select * from users;
SELECT COUNT(*) FROM users;
SELECT COUNT(*) FROM activities;
SELECT COUNT(*) FROM opportunities;
UPDATE activities
SET
actual_start_time = '2025-12-19 09:00:00',
actual_end_time = '2025-12-19 10:30:00',
scheduled_start_time = '2025-12-19 09:00:00',
scheduled_end_time = '2025-12-19 10:30:00'
WHERE id IN (407509,407375);
select * from partners;
SELECT id, uuid, type, actual_start_time, user_id, crm_configuration_id
FROM activities
WHERE user_id = 143
AND actual_start_time >= '2025-10-13 00:00:00'
AND actual_start_time <= '2026-01-13 23:59:59'
ORDER BY actual_start_time DESC;
SELECT * FROM activities WHERE uuid_to_bin('78eda160-3086-435f-88a5-bb0c71b6008d') = uuid;
SELECT * FROM crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 282;
# lead_id
# account_id 177
# contact_id 3969
# opportunity_id
# stage_id 203
SELECT * FROM opportunities WHERE opportunities.crm_configuration_id = id = 282;
SELECT * FROM activities where crm_configuration_id = 39 AND type = 'conference'
AND user_id = 143 and actual_start_time >= '2025-10-13';
SELECT * FROM activities a
# JOIN opportunities o ON a.opportunity_id = o.id
WHERE a.crm_configuration_id = 39 AND a.type = 'conference'
and status = 'completed' and recording_state = 'recorded'
and a.actual_start_time >= '2025-10-13'
AND a.user_id = 143
;
select * from leads
where crm_configuration_id = 39; # 112 -> ac. 178, 109 => op. 1707
SELECT * FROM activities WHERE id IN (356013,616188,616202,616310,407509,407375,356001,356008);
SELECT * FROM activities WHERE id IN (356013,616188,616202,616310);
SELECT * FROM activities WHERE id IN (407509,407375); # leads: 112, 109 | status - 198
SELECT * FROM activities WHERE id IN (356001, 356008); # contacts:
SELECT * FROM opportunities WHERE id IN (1707);
SELECT * FROM stages where id IN (204, 198);
SELECT * FROM opportunities WHERE account_id IN (178);
SELECT * FROM opportunities WHERE crm_configuration_id = 39 AND created_at > '2025-01-01';
SELECT * FROM contacts WHERE account_id IN (178); # 4118 Musaibe, 4448 Ceco Personal
SELECT * FROM activities where crm_configuration_id = 39
AND opportunity_id IS NULL
AND is_internal = false
and status = 'completed' and recording_state = 'recorded'
AND actual_start_time >= '2025-10-13'
AND (lead_id IS NOT NULL OR contact_id IS NOT NULL OR account_id IS NOT NULL)
# AND lead_id IN (112, 109)
;
SELECT * FROM crm_profiles WHERE user_id = 143;
select * from inboxes; # 212
select * from users where id = 143; # 143
select * from inbox_email_batches where inbox_id = 212
and updated_at >= '2026-01-28 00:00:00' order by id desc;
select * from inbox_emails where inbox_id = 212
and batch_id = 95885 order by id desc;
select * from email_messages where origin_user_id = 143;
select * from activities where user_id = 143 and updated_at >= '2026-01-28 00:00:00';
select * from participants where activity_id = 620247;
select * from crm_profiles where user_id = 143;
SELECT * FROM activities WHERE uuid_to_bin('458cf915-b914-4000-b083-5687b32b2956') = uuid; # 356001
select * from transcription where activity_id = 356001; # 6943
select * from ai_prompts where transcription_id = 6943;
SELECT * FROM activity_summary_logs where activity_id = 356001;
SELECT * FROM social_accounts WHERE sociable_id = 143;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('0164a4fb-cb95-454e-9edd-4d804e4999bd') = uuid;
# 422515 softphone tr. 8100
SELECT * FROM activities WHERE uuid_to_bin('7520add8-8d87-41a5-98e5-fc4edf96f21e') = uuid;
# 407509 conference tr. 7670 crmId: 00UD1000002J9aTMAS
select * from ai_prompts where transcription_id IN (8100, 7670);
select * from activity_summary_logs where activity_id = 407509;
select * from sidekick_settings;
select * from default_activity_types;
SELECT * FROM contacts WHERE crm_configuration_id = 39 and email = '[EMAIL]';
SELECT * FROM leads WHERE crm_configuration_id = 39 and email = '[EMAIL]';
SELECT * FROM activity_searches where user_id = 143;
SELECT * FROM groups where team_id = 1;
select * from teams where id = 1;
select * from groups where team_id = 1; # 1150 - 7e75f8025c22
select id, name, group_id, status, deleted_at, email
from users where team_id = 1 order by group_id desc ;
select * from activity_searches where id in (1977, 1978, 1979);
select * from activity_search_filters where activity_search_id IN (1977, 1978, 1979);
select * from activity_search_filters where filter = 'group_id' and value = '443f26b8-8512-437e-a9f9-7e75f8025c22'; # 10268, 10272, 10277
select * from nudges where activity_search_id IN (1977, 1978, 1979); # 877, 878, 879
INSERT INTO `activity_search_filters`
(`activity_search_id`, `filter`, `value`) VALUES
(1977, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22'),
(1978, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22'),
(1979, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22')
;
select * from crm_configurations where id = 39;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from features;
SELECT * FROM activity_searches where id = 1982; # 1981
SELECT * FROM activity_search_filters WHERE activity_search_id = 1982;
SELECT * FROM automated_reports where id = 68;
SELECT * FROM automated_report_results where id = 275;
SELECT * FROM automated_reports order by id desc;
SELECT * FROM automated_report_results order by id desc;
select * from activity_searches where user_id = 143;
select * from ask_anything_prompts;
SELECT * FROM groups WHERE id = 1439;
SELECT * FROM users WHERE group_id = 1439;
select * from permissions; # 158
select * from roles;
select * from permission_role
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 = 28;
select * from playbooks where team_id = 1;
select * from playbooks where id = 179;
select * from playbook_categories where id = 1391;
select * from users where id = 143;
select * from crm_profiles where user_id = 143;
select * from activities where crm_configuration_id = 39 and type = 'conference'
and crm_provider_id IS NOT NULL ORDER by id desc;
select * from activities where id = 422003; # 00UO400000pB6fpMAC
SELECT ar.id, ar.uuid, ar.media_type, ar.status, a.type
FROM automated_report_results ar
JOIN automated_reports a ON a.id = ar.report_id
WHERE a.type = 'ask_jiminny'
LIMIT 10;
{"request_id":"edc47759-160a-4f61-82fc-c8cdf5e55464","status":"completed","timestamp":"2026-03-31T15:52:05.828229+00:00","s3_url":"s3:\/\/dev.jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/panorama-reports\/test_req_q_1.MD","report_type":"exec_summary","pdf_url":"s3:\/\/dev.jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/panorama-reports\/test_req_q_1.pdf"}
[URL_WITH_CREDENTIALS] string
*/
protected $signature = 'automated-reports
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly).
Use --report-id to manually trigger a specific report by ID or UUID.';
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");
$reportId = $this->option('report-id');
if ($reportId !== null) {
$reports = $this->getReportById($reportId);
} else {
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
}
$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);
}
}
private function getReportById(string $reportId): Collection
{
$report = $this->reportRepository->findByIdOrUuid($reportId);
if ($report === null) {
$this->logger->warning(self::LOG_PREFIX . ' Report not found for --report-id', ['reportId' => $reportId]);
$this->warn("Report not found: {$reportId}");
return collect();
}
if (! $report->getStatus()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is inactive, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
]);
$this->warn('Report is inactive — processing anyway (manual override).');
}
$team = $report->getTeam();
if ($team->getStatus() !== Team::STATUS_ACTIVE) {
$this->logger->warning(self::LOG_PREFIX . ' Team is not active, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'teamStatus' => $team->getStatus(),
]);
$this->warn("Team #{$report->getTeamId()} is not active — processing anyway (manual override).");
}
if ($report->isExpired()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is expired, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'expiresAt' => $report->getExpiresAt()?->toDateString(),
]);
$this->warn('Report is expired (expires_at: ' . $report->getExpiresAt()?->toDateString() . ') — processing anyway (manual override).');
}
return collect([$report]);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11245
|
|
11244
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Code changed:
Hide
Sync Changes
Hide This Notification
10
12
2
4
Previous Highlighted Error
Next Highlighted Error
SELECT a.id, a.uuid, a.actual_start_time, o.id, o.uuid FROM opportunities o
JOIN activities a ON o.id = a.opportunity_id
WHERE a.crm_configuration_id = 39
AND a.actual_start_time > '2025-10-13'
AND a.type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM activities
WHERE crm_configuration_id = 39 and user_id = 143
and actual_start_time >= '2025-10-13'
AND type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM opportunities WHERE account_id IN (178);
select * from activities where id IN (620137, 620187, 620188, 620189, 620230);
# HS
SELECT * FROM opportunities WHERE id IN (238);
select * from activities where id IN (477,2076);
select * from users;
SELECT COUNT(*) FROM users;
SELECT COUNT(*) FROM activities;
SELECT COUNT(*) FROM opportunities;
UPDATE activities
SET
actual_start_time = '2025-12-19 09:00:00',
actual_end_time = '2025-12-19 10:30:00',
scheduled_start_time = '2025-12-19 09:00:00',
scheduled_end_time = '2025-12-19 10:30:00'
WHERE id IN (407509,407375);
select * from partners;
SELECT id, uuid, type, actual_start_time, user_id, crm_configuration_id
FROM activities
WHERE user_id = 143
AND actual_start_time >= '2025-10-13 00:00:00'
AND actual_start_time <= '2026-01-13 23:59:59'
ORDER BY actual_start_time DESC;
SELECT * FROM activities WHERE uuid_to_bin('78eda160-3086-435f-88a5-bb0c71b6008d') = uuid;
SELECT * FROM crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 282;
# lead_id
# account_id 177
# contact_id 3969
# opportunity_id
# stage_id 203
SELECT * FROM opportunities WHERE opportunities.crm_configuration_id = id = 282;
SELECT * FROM activities where crm_configuration_id = 39 AND type = 'conference'
AND user_id = 143 and actual_start_time >= '2025-10-13';
SELECT * FROM activities a
# JOIN opportunities o ON a.opportunity_id = o.id
WHERE a.crm_configuration_id = 39 AND a.type = 'conference'
and status = 'completed' and recording_state = 'recorded'
and a.actual_start_time >= '2025-10-13'
AND a.user_id = 143
;
select * from leads
where crm_configuration_id = 39; # 112 -> ac. 178, 109 => op. 1707
SELECT * FROM activities WHERE id IN (356013,616188,616202,616310,407509,407375,356001,356008);
SELECT * FROM activities WHERE id IN (356013,616188,616202,616310);
SELECT * FROM activities WHERE id IN (407509,407375); # leads: 112, 109 | status - 198
SELECT * FROM activities WHERE id IN (356001, 356008); # contacts:
SELECT * FROM opportunities WHERE id IN (1707);
SELECT * FROM stages where id IN (204, 198);
SELECT * FROM opportunities WHERE account_id IN (178);
SELECT * FROM opportunities WHERE crm_configuration_id = 39 AND created_at > '2025-01-01';
SELECT * FROM contacts WHERE account_id IN (178); # 4118 Musaibe, 4448 Ceco Personal
SELECT * FROM activities where crm_configuration_id = 39
AND opportunity_id IS NULL
AND is_internal = false
and status = 'completed' and recording_state = 'recorded'
AND actual_start_time >= '2025-10-13'
AND (lead_id IS NOT NULL OR contact_id IS NOT NULL OR account_id IS NOT NULL)
# AND lead_id IN (112, 109)
;
SELECT * FROM crm_profiles WHERE user_id = 143;
select * from inboxes; # 212
select * from users where id = 143; # 143
select * from inbox_email_batches where inbox_id = 212
and updated_at >= '2026-01-28 00:00:00' order by id desc;
select * from inbox_emails where inbox_id = 212
and batch_id = 95885 order by id desc;
select * from email_messages where origin_user_id = 143;
select * from activities where user_id = 143 and updated_at >= '2026-01-28 00:00:00';
select * from participants where activity_id = 620247;
select * from crm_profiles where user_id = 143;
SELECT * FROM activities WHERE uuid_to_bin('458cf915-b914-4000-b083-5687b32b2956') = uuid; # 356001
select * from transcription where activity_id = 356001; # 6943
select * from ai_prompts where transcription_id = 6943;
SELECT * FROM activity_summary_logs where activity_id = 356001;
SELECT * FROM social_accounts WHERE sociable_id = 143;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('0164a4fb-cb95-454e-9edd-4d804e4999bd') = uuid;
# 422515 softphone tr. 8100
SELECT * FROM activities WHERE uuid_to_bin('7520add8-8d87-41a5-98e5-fc4edf96f21e') = uuid;
# 407509 conference tr. 7670 crmId: 00UD1000002J9aTMAS
select * from ai_prompts where transcription_id IN (8100, 7670);
select * from activity_summary_logs where activity_id = 407509;
select * from sidekick_settings;
select * from default_activity_types;
SELECT * FROM contacts WHERE crm_configuration_id = 39 and email = '[EMAIL]';
SELECT * FROM leads WHERE crm_configuration_id = 39 and email = '[EMAIL]';
SELECT * FROM activity_searches where user_id = 143;
SELECT * FROM groups where team_id = 1;
select * from teams where id = 1;
select * from groups where team_id = 1; # 1150 - 7e75f8025c22
select id, name, group_id, status, deleted_at, email
from users where team_id = 1 order by group_id desc ;
select * from activity_searches where id in (1977, 1978, 1979);
select * from activity_search_filters where activity_search_id IN (1977, 1978, 1979);
select * from activity_search_filters where filter = 'group_id' and value = '443f26b8-8512-437e-a9f9-7e75f8025c22'; # 10268, 10272, 10277
select * from nudges where activity_search_id IN (1977, 1978, 1979); # 877, 878, 879
INSERT INTO `activity_search_filters`
(`activity_search_id`, `filter`, `value`) VALUES
(1977, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22'),
(1978, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22'),
(1979, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22')
;
select * from crm_configurations where id = 39;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from features;
SELECT * FROM activity_searches where id = 1982; # 1981
SELECT * FROM activity_search_filters WHERE activity_search_id = 1982;
SELECT * FROM automated_reports where id = 68;
SELECT * FROM automated_report_results where id = 275;
SELECT * FROM automated_reports order by id desc;
SELECT * FROM automated_report_results order by id desc;
select * from activity_searches where user_id = 143;
select * from ask_anything_prompts;
SELECT * FROM groups WHERE id = 1439;
SELECT * FROM users WHERE group_id = 1439;
select * from permissions; # 158
select * from roles;
select * from permission_role
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 = 28;
select * from playbooks where team_id = 1;
select * from playbooks where id = 179;
select * from playbook_categories where id = 1391;
select * from users where id = 143;
select * from crm_profiles where user_id = 143;
select * from activities where crm_configuration_id = 39 and type = 'conference'
and crm_provider_id IS NOT NULL ORDER by id desc;
select * from activities where id = 422003; # 00UO400000pB6fpMAC
SELECT ar.id, ar.uuid, ar.media_type, ar.status, a.type
FROM automated_report_results ar
JOIN automated_reports a ON a.id = ar.report_id
WHERE a.type = 'ask_jiminny'
LIMIT 10;
{"request_id":"edc47759-160a-4f61-82fc-c8cdf5e55464","status":"completed","timestamp":"2026-03-31T15:52:05.828229+00:00","s3_url":"s3:\/\/dev.jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/panorama-reports\/test_req_q_1.MD","report_type":"exec_summary","pdf_url":"s3:\/\/dev.jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/panorama-reports\/test_req_q_1.pdf"}
s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.MD
s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdf...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11244
|
|
11243
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny# php artisan optimize:clear && supervisorctl restart all
INFO Clearing cached bootstrap files.
config [PASSWORD_DOTS] 41.20ms DONE
cache [PASSWORD_DOTS] 61.54ms DONE
compiled [PASSWORD_DOTS] 3.39ms DONE
events [PASSWORD_DOTS] 5.01ms DONE
routes [PASSWORD_DOTS] 3.37ms DONE
views [PASSWORD_DOTS] 43.92ms DONE
jiminny-worker-processing-delayed:jiminny-worker-processing-delayed_00: stopped
jiminny-worker-processing-2:jiminny-worker-processing-2_00: stopped
jiminny-worker-processing-3:jiminny-worker-processing-3_00: stopped
jiminny-worker-processing-4:jiminny-worker-processing-4_00: stopped
jiminny-worker-processing-5:jiminny-worker-processing-5_00: stopped
worker-analytics:worker-analytics_00: stopped
worker-crm-update:worker-crm-update_00: stopped
worker-download:worker-download_00: stopped
worker-nudges:worker-nudges_00: stopped
worker-emails:worker-emails_00: stopped
worker-crm-sync:worker-crm-sync_00: stopped
jiminny-worker-processing-1:jiminny-worker-processing-1_00: stopped
worker-calendar:worker-calendar_00: stopped
worker-audio:worker-audio_00: stopped
worker-conferences:worker-conferences_00: stopped
worker:worker_00: stopped
worker-es-update:worker-es-update_00: stopped
artisan-schedule:artisan-schedule_00: stopped
artisan-schedule:artisan-schedule_00: started
jiminny-worker-processing-1:jiminny-worker-processing-1_00: started
jiminny-worker-processing-2:jiminny-worker-processing-2_00: started
jiminny-worker-processing-3:jiminny-worker-processing-3_00: started
jiminny-worker-processing-4:jiminny-worker-processing-4_00: started
jiminny-worker-processing-5:jiminny-worker-processing-5_00: started
jiminny-worker-processing-delayed:jiminny-worker-processing-delayed_00: started
worker:worker_00: started
worker-analytics:worker-analytics_00: started
worker-audio:worker-audio_00: started
worker-calendar:worker-calendar_00: started
worker-conferences:worker-conferences_00: started
worker-crm-sync:worker-crm-sync_00: started
worker-crm-update:worker-crm-update_00: started
worker-download:worker-download_00: started
worker-emails:worker-emails_00: started
worker-es-update:worker-es-update_00: started
worker-nudges:worker-nudges_00: started
root@docker_lamp_1:/home/jiminny#
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11243
|
|
11242
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny# php artisan optimize:clear && supervisorctl restart all
INFO Clearing cached bootstrap files.
config [PASSWORD_DOTS] 41.20ms DONE
cache [PASSWORD_DOTS] 61.54ms DONE
compiled [PASSWORD_DOTS] 3.39ms DONE
events [PASSWORD_DOTS] 5.01ms DONE
routes [PASSWORD_DOTS] 3.37ms DONE
views [PASSWORD_DOTS] 43.92ms DONE
jiminny-worker-processing-delayed:jiminny-worker-processing-delayed_00: stopped
jiminny-worker-processing-2:jiminny-worker-processing-2_00: stopped
jiminny-worker-processing-3:jiminny-worker-processing-3_00: stopped
jiminny-worker-processing-4:jiminny-worker-processing-4_00: stopped
jiminny-worker-processing-5:jiminny-worker-processing-5_00: stopped
worker-analytics:worker-analytics_00: stopped
worker-crm-update:worker-crm-update_00: stopped
worker-download:worker-download_00: stopped
worker-nudges:worker-nudges_00: stopped
worker-emails:worker-emails_00: stopped
worker-crm-sync:worker-crm-sync_00: stopped
jiminny-worker-processing-1:jiminny-worker-processing-1_00: stopped
worker-calendar:worker-calendar_00: stopped
worker-audio:worker-audio_00: stopped
worker-conferences:worker-conferences_00: stopped
worker:worker_00: stopped
worker-es-update:worker-es-update_00: stopped
artisan-schedule:artisan-schedule_00: stopped
artisan-schedule:artisan-schedule_00: started
jiminny-worker-processing-1:jiminny-worker-processing-1_00: started
jiminny-worker-processing-2:jiminny-worker-processing-2_00: started
jiminny-worker-processing-3:jiminny-worker-processing-3_00: started
jiminny-worker-processing-4:jiminny-worker-processing-4_00: started
jiminny-worker-processing-5:jiminny-worker-processing-5_00: started
jiminny-worker-processing-delayed:jiminny-worker-processing-delayed_00: started
worker:worker_00: started
worker-analytics:worker-analytics_00: started
worker-audio:worker-audio_00: started
worker-calendar:worker-calendar_00: started
worker-conferences:worker-conferences_00: started
worker-crm-sync:worker-crm-sync_00: started
worker-crm-update:worker-crm-update_00: started
worker-download:worker-download_00: started
worker-emails:worker-emails_00: started
worker-es-update:worker-es-update_00: started
worker-nudges:worker-nudges_00: started
root@docker_lamp_1:/home/jiminny#
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11242
|
|
11241
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny# php artisan optimize:clear && supervisorctl restart all
INFO Clearing cached bootstrap files.
config [PASSWORD_DOTS] 41.20ms DONE
cache [PASSWORD_DOTS] 61.54ms DONE
compiled [PASSWORD_DOTS] 3.39ms DONE
events [PASSWORD_DOTS] 5.01ms DONE
routes [PASSWORD_DOTS] 3.37ms DONE
views [PASSWORD_DOTS] 43.92ms DONE
jiminny-worker-processing-delayed:jiminny-worker-processing-delayed_00: stopped
jiminny-worker-processing-2:jiminny-worker-processing-2_00: stopped
jiminny-worker-processing-3:jiminny-worker-processing-3_00: stopped
jiminny-worker-processing-4:jiminny-worker-processing-4_00: stopped
jiminny-worker-processing-5:jiminny-worker-processing-5_00: stopped
worker-analytics:worker-analytics_00: stopped
worker-crm-update:worker-crm-update_00: stopped
worker-download:worker-download_00: stopped
worker-nudges:worker-nudges_00: stopped
worker-emails:worker-emails_00: stopped
worker-crm-sync:worker-crm-sync_00: stopped
jiminny-worker-processing-1:jiminny-worker-processing-1_00: stopped
worker-calendar:worker-calendar_00: stopped
worker-audio:worker-audio_00: stopped
worker-conferences:worker-conferences_00: stopped
worker:worker_00: stopped
worker-es-update:worker-es-update_00: stopped
artisan-schedule:artisan-schedule_00: stopped
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11241
|
|
11240
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny# php artisan optimize:clear && supervisorctl restart all
INFO Clearing cached bootstrap files.
config [PASSWORD_DOTS] 41.20ms DONE
cache [PASSWORD_DOTS] 61.54ms DONE
compiled [PASSWORD_DOTS] 3.39ms DONE
events [PASSWORD_DOTS] 5.01ms DONE
routes [PASSWORD_DOTS] 3.37ms DONE
views [PASSWORD_DOTS] 43.92ms DONE
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11240
|
|
11239
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny# php artisan optimize:clear && supervisorctl restart all
INFO Clearing cached bootstrap files.
config [PASSWORD_DOTS] 41.20ms DONE
cache [PASSWORD_DOTS] 61.54ms DONE
compiled [PASSWORD_DOTS] 3.39ms DONE
events [PASSWORD_DOTS] 5.01ms DONE
routes [PASSWORD_DOTS] 3.37ms DONE
views [PASSWORD_DOTS] 43.92ms DONE
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11239
|
|
11238
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny# php artisan optimize:clear && supervisorctl restart all
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11238
|
|
11237
|
iTerm2ShellEditViewSession••DOCKER• 881DEV (docker iTerm2ShellEditViewSession••DOCKER• 881DEV (docker)Last login: Sat Apr 1112:38:35 on ttys006ScriptsProfilesWindowHelpDEV (docker)X.APP (-zsh)ec2-user@ip-10-30-... *4-zshPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentsPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ devroot@docker_lamp_1:/home/jiminny# php artisan automated-reports 265lhlSupport Daily - in 2h 39 m100% <-zsh86-zsh0 878Tue 14 Apr 12:21:03T81* Unable to acce...O 88DEVNo arguments expected for "automated-reports" command, got "265".root@docker_lamp_1:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
11237
|
|
11236
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny#
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11236
|
|
11235
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplhlSupport Daily - in 2 h 39 m100% <••DEV (docker)DOCKER₴81DEV (docker)Last login: Sat Apr 11 12:38:35 on ttys006APP (-zsh)ec2-user@ip-10-30-... 24-zshPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentsPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ devroot@docker_lamp_1:/home/jiminny# php artisan automated-reports 265-zsh86-zshO &78Tue 14 Apr 12:21:01T&1* Unable to acce...O 88DEVNo arguments expected for "automated-reports" command, got "265".root@docker_lamp_1:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
11235
|
|
11234
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny#
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11234
|
|
11233
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
No arguments expected for "automated-reports" command, got "265".
root@docker_lamp_1:/home/jiminny#
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11233
|
|
11232
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports 265
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11232
|
|
11231
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11231
|
|
11230
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11230
|
|
11229
|
PhpStormFileEditFV faVsco.s vProject vO package-lo PhpStormFileEditFV faVsco.s vProject vO package-lock.jsonE phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTaraw_sqlLquery.sqlM+R-ADME,moso sonar-proiect propertiesE test.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External Librariesv E° Scratches and Consoles~ D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsRepository.phpC AutomatedReportsService.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportResult.phpclass AutomatedReportsCommand extends CommandAjiminny@localhost4 console [jiminny@localhost4 DI [jiminny@localhost]c nooca minnvolocanos4 SF [iiminny@localhost]s cono dev minny clocaine> A PRODservices~ D DatabaseV dEUA consolev djiminny@localhostansocallASF 4 sV A PRODconsoleV A STAGING&console Is losmsDocker© AutomatedReportsCommand.php x© AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.php* Oreturn intpublic function handle(): int58$this->logger->info(self::LOG_PREFIX . ' Started');$now = Carbon: :now();$isMonday = $now->isMonday();$isFirstDay0fMonth = $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],strict: true);$this->logger->info(self::LOG_PREFIX' Checking conditions', I"Istonday = $1sMonday,Output8 rowsDid Yf # 00UO400000pB6fpMAC x5 0,Muvid (UUID with time-low and time-h...265 926befa2-5d77-4ab3-a553-587a1d5d9$5d166 [CREDIT_CARD]-9895-77001560689%267 319094f0-7368-4ec1-8f2b-a15b99bb37ec269 d3037407-091e-438a-8c8e-6745c5bf8df9271 09fd931c-117a-47b7-8ccb-abe2e5fe01a1274 6f18db25-c836-4a21-8542-927b3b9f01bf275 ff55bec0-961d-493f-b8fb-dbc2e1d25279276 8617904b-71f4-485f-861c-c045e9cbf2a7ID media_type Tpdfpdfpdfpdfpdfpdfpdfpdf÷ Wstatus Y" type Y4 ask_jiminny4 ask_jiminny1 ask_jiminny4 ask iiminnv4 ask_jiminny1 ask_jiminny3 ask_jiminny4 ask iiminny, 0Support Daily • in 2h 40 mAAskJiminnyReportActivityServiceT...Defaults v100% C•Tue 14 Apr 12:20:38= custom.logElaravel.logA SF [jiminny@localhost]4 HS_local [jiminny@localhost]Al console [PROD]A console [EU]Á console [STAGING]© AskJiminnyReportActivityService.php© ActivitySearch.phpc Onbemanavzcontroller.onoC HistoryService.php© FilterDefinitionCollection.php© Criteria.php© AskJiminnyReportActivityServiceTest.phpRequestGenerateAskJiminnyReportJobTest.phpX:Auto vPlaygroundMa lminnv vIselect * from activities where crm confiquration id = 39 and tvoe = 'conferencel010 A12 V.2 У.4 л179and crm_provider_id IS NOT NULL ORDER by id desc;1180select * from activities where id = 422003; # 00U0400000pB6fpМAC|181182v183184185186SELECT ar.id, ar.uuid, ar.media type, ar.status, a.tvReFbM automated_report_results arJOIN automated_reports a ON a.ig = ar. repontaidWHERE a.tyRg = 'ask_jiminnx'LIMIT 10;187188f"request_id": "edc47759-160a-4f61-82fc-c8cdf5e55464", "status": "completed", "timestamp" : "2026-03-31T15:52:05.828229-189191s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.MDs3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdf=• : -CSV8 rows retrieved starting from 1 in 942 ms (execution: 105 ms, fetching: 837 ms)SUM: 265 1:1 W Windsurf TeamsUTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
11229
|
|
11228
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp••0DEV (docker)DOCKER• 881DEV (docker)Last login: Sat Apr 11 12:38:35 on ttys006APP (-zsh)ec2-user@ip-10-30-... 24-zshPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentsPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ devroot@docker_1amp_1:/home/jiminny# php artisan automated-reports [(ablSupport Daily - in 2h 40 m100% <47-zsh86-zsh®O 87Tue 14 Apr 12:20:37T81* Unable to acce...O x8DEV...
|
NULL
|
NULL
|
NULL
|
11228
|
|
11227
|
PhpStormFileEditFV faVsco.s vProjectvO package-loc PhpStormFileEditFV faVsco.s vProjectvO package-lock.jsonE phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTaraw_sqlLquery.sqlM+R-ADME,moso sonar-proiect propertiesE test.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External Librariesv E° Scratches and Consoles~ D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.php© AutomatedReportsRepository.phpC AutomatedReportsService.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportResult.phpclass AutomatedReportsCommand extends CommandAjiminny@localhost4 console [jiminny@localhost4 DI [jiminny@localhost]c nooca minnvolocanos4 SF [iiminny@localhost]s cono dev minny clocaine> A PRODservices~ D DatabaseV dEUA consolev djiminny@localhostans ocallASF 4 sV A PRODconsoleV A STAGINGsconsole 1s los ms& Docker© AutomatedReportsCommand.php x© AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.php* Oreturn intpublic function handle(): int58$this->logger->info(self::LOG_PREFIX . ' Started');$now = Carbon: :now();$isMonday = $now->isMonday();$isFirstDay0fMonth = $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],strict: true);$this->logger->info(self::LOG_PREFIX' Checking conditions', I"Istonday = $1sMonday,Output8 rowsvDid Yf # 00UO400000pB6fpMAC x5 0,4 QMuvid (UUID with time-low and time-h...JosYodetar-sor-4aos-aos,-so allosdytol266 65671360-459c-4092-9823-ffe013dbc808267 319094f0-7368-4ec1-8f2b-a15b99bb37ec269 d3037407-091e-438a-8c8e-6745c5bf8df9271 09fd931c-117a-47b7-8ccb-abe2e5fe01a1274 6f18db25-c836-4a21-8542-927b3b9f01bf275 ff55bec0-961d-493f-b8fb-dbc2e1d25279276 8617904b-71f4-485f-861c-c045e9cbf2a7Imedia_type Tpdfpdfpdfpdfpdfpdfpdfpdf; status Y• type Y4 ask_jiminny4 ask_jiminny1 ask_jiminny4 ask iiminnv4 ask_jiminny1 ask_jiminny3 ask_jiminny4 ask_J1m1nny, 0Support Daily • in 2h 40 mAAskJiminnyReportActivityServiceT...Defaults v100% C•Tue 14 Apr 12:20:35= custom.logElaravel.logA SF [jiminny@localhost] >4 HS_local [jiminny@localhost]Al console [PROD]A console [EU]Á console [STAGING]© AskJiminnyReportActivityService.php© ActivitySearch.phpc Onbemanavzcontroller.onoC HistoryService.php© FilterDefinitionCollection.php© Criteria.php© AskJiminnyReportActivityServiceTest.phpRequestGenerateAskJiminnyReportJobTest.phpX:Auto vPlaygroundMa lminnv vIselect * from activities where crm confiquration id = 39 and tvoe = 'conferencel010 A12 V.2 У.4 л179and crm_provider_id IS NOT NULL ORDER by id desc;1180select * from activities where id = 422003; # 00U0400000pB6fpМAC|181182v183184185186SELECT ar.id, ar.uuid, ar.media type, ar.status, a.tvReFbM automated_report_results arJOIN automated_ reports a ON a.ig = ar.repontaidWHERE a.tyRg = 'ask_jiminnx'LIMIT 10;187188f"request_id": "edc47759-160a-4f61-82fc-c8cdf5e55464", "status": "completed", "timestamp" : "2026-03-31T15:52:05.828229-189191s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.MDs3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdf=• : -CSV8 rows retrieved starting from 1 in 942 ms (execution: 105 ms, fetching: 837 ms)W Windsurf Teams4 spaces...
|
NULL
|
NULL
|
NULL
|
11227
|
|
11226
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp••0DEV (docker)DOCKER• 881DEV (docker)Last login: Sat Apr 11 12:38:35 on ttys006APP (-zsh)ec2-user@ip-10-30-... 24-zshPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentsPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ devroot@docker_lamp_1:/home/jiminny# php artisan automated-reports П(ablSupport Daily - in 2h 40 m100% <47-zsh86-zsh®O 87Tue 14 Apr 12:20:35T81* Unable to acce...O x8DEV...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11226
|
|
11225
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Code changed:
Hide
Sync Changes
Hide This Notification
10
12
2
4
Previous Highlighted Error
Next Highlighted Error
SELECT a.id, a.uuid, a.actual_start_time, o.id, o.uuid FROM opportunities o
JOIN activities a ON o.id = a.opportunity_id
WHERE a.crm_configuration_id = 39
AND a.actual_start_time > '2025-10-13'
AND a.type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM activities
WHERE crm_configuration_id = 39 and user_id = 143
and actual_start_time >= '2025-10-13'
AND type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM opportunities WHERE account_id IN (178);
select * from activities where id IN (620137, 620187, 620188, 620189, 620230);
# HS
SELECT * FROM opportunities WHERE id IN (238);
select * from activities where id IN (477,2076);
select * from users;
SELECT COUNT(*) FROM users;
SELECT COUNT(*) FROM activities;
SELECT COUNT(*) FROM opportunities;
UPDATE activities
SET
actual_start_time = '2025-12-19 09:00:00',
actual_end_time = '2025-12-19 10:30:00',
scheduled_start_time = '2025-12-19 09:00:00',
scheduled_end_time = '2025-12-19 10:30:00'
WHERE id IN (407509,407375);
select * from partners;
SELECT id, uuid, type, actual_start_time, user_id, crm_configuration_id
FROM activities
WHERE user_id = 143
AND actual_start_time >= '2025-10-13 00:00:00'
AND actual_start_time <= '2026-01-13 23:59:59'
ORDER BY actual_start_time DESC;
SELECT * FROM activities WHERE uuid_to_bin('78eda160-3086-435f-88a5-bb0c71b6008d') = uuid;
SELECT * FROM crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 282;
# lead_id
# account_id 177
# contact_id 3969
# opportunity_id
# stage_id 203
SELECT * FROM opportunities WHERE opportunities.crm_configuration_id = id = 282;
SELECT * FROM activities where crm_configuration_id = 39 AND type = 'conference'
AND user_id = 143 and actual_start_time >= '2025-10-13';
SELECT * FROM activities a
# JOIN opportunities o ON a.opportunity_id = o.id
WHERE a.crm_configuration_id = 39 AND a.type = 'conference'
and status = 'completed' and recording_state = 'recorded'
and a.actual_start_time >= '2025-10-13'
AND a.user_id = 143
;
select * from leads
where crm_configuration_id = 39; # 112 -> ac. 178, 109 => op. 1707
SELECT * FROM activities WHERE id IN (356013,616188,616202,616310,407509,407375,356001,356008);
SELECT * FROM activities WHERE id IN (356013,616188,616202,616310);
SELECT * FROM activities WHERE id IN (407509,407375); # leads: 112, 109 | status - 198
SELECT * FROM activities WHERE id IN (356001, 356008); # contacts:
SELECT * FROM opportunities WHERE id IN (1707);
SELECT * FROM stages where id IN (204, 198);
SELECT * FROM opportunities WHERE account_id IN (178);
SELECT * FROM opportunities WHERE crm_configuration_id = 39 AND created_at > '2025-01-01';
SELECT * FROM contacts WHERE account_id IN (178); # 4118 Musaibe, 4448 Ceco Personal
SELECT * FROM activities where crm_configuration_id = 39
AND opportunity_id IS NULL
AND is_internal = false
and status = 'completed' and recording_state = 'recorded'
AND actual_start_time >= '2025-10-13'
AND (lead_id IS NOT NULL OR contact_id IS NOT NULL OR account_id IS NOT NULL)
# AND lead_id IN (112, 109)
;
SELECT * FROM crm_profiles WHERE user_id = 143;
select * from inboxes; # 212
select * from users where id = 143; # 143
select * from inbox_email_batches where inbox_id = 212
and updated_at >= '2026-01-28 00:00:00' order by id desc;
select * from inbox_emails where inbox_id = 212
and batch_id = 95885 order by id desc;
select * from email_messages where origin_user_id = 143;
select * from activities where user_id = 143 and updated_at >= '2026-01-28 00:00:00';
select * from participants where activity_id = 620247;
select * from crm_profiles where user_id = 143;
SELECT * FROM activities WHERE uuid_to_bin('458cf915-b914-4000-b083-5687b32b2956') = uuid; # 356001
select * from transcription where activity_id = 356001; # 6943
select * from ai_prompts where transcription_id = 6943;
SELECT * FROM activity_summary_logs where activity_id = 356001;
SELECT * FROM social_accounts WHERE sociable_id = 143;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('0164a4fb-cb95-454e-9edd-4d804e4999bd') = uuid;
# 422515 softphone tr. 8100
SELECT * FROM activities WHERE uuid_to_bin('7520add8-8d87-41a5-98e5-fc4edf96f21e') = uuid;
# 407509 conference tr. 7670 crmId: 00UD1000002J9aTMAS
select * from ai_prompts where transcription_id IN (8100, 7670);
select * from activity_summary_logs where activity_id = 407509;
select * from sidekick_settings;
select * from default_activity_types;
SELECT * FROM contacts WHERE crm_configuration_id = 39 and email = '[EMAIL]';
SELECT * FROM leads WHERE crm_configuration_id = 39 and email = '[EMAIL]';
SELECT * FROM activity_searches where user_id = 143;
SELECT * FROM groups where team_id = 1;
select * from teams where id = 1;
select * from groups where team_id = 1; # 1150 - 7e75f8025c22
select id, name, group_id, status, deleted_at, email
from users where team_id = 1 order by group_id desc ;
select * from activity_searches where id in (1977, 1978, 1979);
select * from activity_search_filters where activity_search_id IN (1977, 1978, 1979);
select * from activity_search_filters where filter = 'group_id' and value = '443f26b8-8512-437e-a9f9-7e75f8025c22'; # 10268, 10272, 10277
select * from nudges where activity_search_id IN (1977, 1978, 1979); # 877, 878, 879
INSERT INTO `activity_search_filters`
(`activity_search_id`, `filter`, `value`) VALUES
(1977, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22'),
(1978, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22'),
(1979, 'group_id', '443f26b8-8512-437e-a9f9-7e75f8025c22')
;
select * from crm_configurations where id = 39;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from features;
SELECT * FROM activity_searches where id = 1982; # 1981
SELECT * FROM activity_search_filters WHERE activity_search_id = 1982;
SELECT * FROM automated_reports where id = 68;
SELECT * FROM automated_report_results where id = 275;
SELECT * FROM automated_reports order by id desc;
SELECT * FROM automated_report_results order by id desc;
select * from activity_searches where user_id = 143;
select * from ask_anything_prompts;
SELECT * FROM groups WHERE id = 1439;
SELECT * FROM users WHERE group_id = 1439;
select * from permissions; # 158
select * from roles;
select * from permission_role
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 = 28;
select * from playbooks where team_id = 1;
select * from playbooks where id = 179;
select * from playbook_categories where id = 1391;
select * from users where id = 143;
select * from crm_profiles where user_id = 143;
select * from activities where crm_configuration_id = 39 and type = 'conference'
and crm_provider_id IS NOT NULL ORDER by id desc;
select * from activities where id = 422003; # 00UO400000pB6fpMAC
SELECT ar.id, ar.uuid, ar.media_type, ar.status, a.type
FROM automated_report_results ar
JOIN automated_reports a ON a.id = ar.report_id
WHERE a.type = 'ask_jiminny'
LIMIT 10;
{"request_id":"edc47759-160a-4f61-82fc-c8cdf5e55464","status":"completed","timestamp":"2026-03-31T15:52:05.828229+00:00","s3_url":"s3:\/\/dev.jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/panorama-reports\/test_req_q_1.MD","report_type":"exec_summary","pdf_url":"s3:\/\/dev.jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/panorama-reports\/test_req_q_1.pdf"}
[URL_WITH_CREDENTIALS] string
*/
protected $signature = 'automated-reports
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly).
Use --report-id to manually trigger a specific report by ID or UUID.';
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");
$reportId = $this->option('report-id');
if ($reportId !== null) {
$reports = $this->getReportById($reportId);
} else {
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
}
$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);
}
}
private function getReportById(string $reportId): Collection
{
$report = $this->reportRepository->findByIdOrUuid($reportId);
if ($report === null) {
$this->logger->warning(self::LOG_PREFIX . ' Report not found for --report-id', ['reportId' => $reportId]);
$this->warn("Report not found: {$reportId}");
return collect();
}
if (! $report->getStatus()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is inactive, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
]);
$this->warn('Report is inactive — processing anyway (manual override).');
}
$team = $report->getTeam();
if ($team->getStatus() !== Team::STATUS_ACTIVE) {
$this->logger->warning(self::LOG_PREFIX . ' Team is not active, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'teamStatus' => $team->getStatus(),
]);
$this->warn("Team #{$report->getTeamId()} is not active — processing anyway (manual override).");
}
if ($report->isExpired()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is expired, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'expiresAt' => $report->getExpiresAt()?->toDateString(),
]);
$this->warn('Report is expired (expires_at: ' . $report->getExpiresAt()?->toDateString() . ') — processing anyway (manual override).');
}
return collect([$report]);
}
}
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
Component
Acl, folder
ActionItems, folder
Activity, folder
ActivityAnalytics, folder
ActivitySearch, folder...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11225
|
|
11224
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
iTerm2ShellEditViewSessionScriptsProfilesWindowHelp••0DEV (docker)DOCKER• 881DEV (docker)Last login: Sat Apr 11 12:38:35 on ttys006APP (-zsh)ec2-user@ip-10-30-... 24-zshPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentsPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ devroot@docker_lamp_1:/home/jiminny# php artisan automated-reports П(ablSupport Daily - in 2h 40 m100% <47-zsh86-zsh®O 87Tue 14 Apr 12:20:26T81* Unable to acce...O x8DEV...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11224
|
|
11223
|
PhpStormFileEditFV faVsco.s vProject vw testuase.u PhpStormFileEditFV faVsco.s vProject vw testuase.uuy› _ vendorê .editorconfig= .env= .env.circleci=.env.circleci-nightly=.env.local=.env.migrate=.env.nikilocalE env.othenE env.productionE.env.production-eu=.env.aaE .env.qai=.env.rootE.env.staging= .gitattributes•.gitignore=.php-cs-fixer.cachephp.php-cs-fixer.dist.phpphp.phpstorm.meta.php=.phpunit.result.cacheE orettierianoreE .windsurfrulespip lue nelper.onephp_ide_helper_models.phpphp artisan0 composer.jsonO composer.lockO dependency-checker.json( dev.jsonEids.txtEinfection.ison.distM+INSALLMOIMJ INTERNAL_WEBHOOK_SETUP.mcEjiminny_storageM+licenses.mdM MakefileO package-lock.jsonEphpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTaraw_sqLquery.sqlM+ R-ADME,moso sonar-proiect propertiesEtest.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› ib External LibrariesE° Scratches and Consolesv D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.phpJiminnyDeouecommana.ong© AutomatedReportsCommand.php x© AutomatedReportsRepository.phpC AutomatedReportsService.phpCreateHeldActivityEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© AutomatedReportResult.phpAutomaleakeportoneJuse Jiminny\ModeLs\Team;use Jiminny\Repositories\AutomatedReportsRepository;use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;use Psr\Log\LoggerInterface;vd jiminny@localhost4 console [jiminny@localhost4 DI liiminnv@localhostlc noocaminnvolocanos4 SF [jiminny@localhost]s cono dev minny clocaine> 4 PRODTests passed: 1 (11 minutes ago)C) AutomatedReportsSendCommand.php• TrackProviderInstalledEvent.phpC RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.php19 Dclass Aurolareckeoor scoliialneextenos coniano31 G39 C43 Gt45* Log prefix for all log messages*/private const string LOG_PREFIX = '[automated-reports]';* The name and signature of the console command.* @var string*/protected Ssignature = 'automated-reports{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduLing)}':/*** The console command description.* Ovar stringprotected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly).Use --report-id to manually trigger a specific report by ID or UUID.':public function __construct(privace readonty Loggerintertace +logger,private readonly BusDispatcher $dispatcher,private readonly AutomatedReportsRepository $reportRepositoryparent: :__construct();* Execure cne console conmono.* Oreturn int*/public function handle(): int$this->logger->info(self::LOG_PREFIX .' Started');$now = Carbon: : now();$isMonday = $now->isMonday);$isFirstDay0fMonth = $now->day === 1;scurrencmonch = snow->month;1l check It the current monch is a quarterly monch lvanvary, April, suly, uccober$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 101,strict: true);$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [= custom.logÁ console [STAGING]© FilterDefinitionCollection.php, 0f Support Daily • in 2h 40 mAL AskJiminnyReportActivityServiceT...DefaultsElaravel.logA SF [jiminny@localhost] >4 HS_local [jiminny@localhost]Al console [PROD]© AskJiminnyReportActivityService.php© ActivitySearch.php© Criteria.php© AskJiminnyReportActivityServiceTest.phpX:Auto vPlavaroundv100% C•Tue 14 Apr 12:20:26A console [EU]Onbemanavzcontroller.onoC HistoryService.phpRequestGenerateAskJiminnyReportJobTest.php14214314414514611481149150151152153154155156157158159160162163164165166167168169170171172173174175177179180181182183184185180187188189190191Ma lminnv v( activity_search_id 1978,( activity_search_id 1979,filter 'group_id',filter 'group_id'," 443f26b8-8512-437e-a9f9-7e75f8025c22') ,'443f26b8-8512-437e-a9f9-7e75f8025c22')010 A12 V.1 ^select * from crm_configurations where id = 39;select * from teams where id = 1;select * from team_features where team_id = 1;select * from features;SELECT * FROM activity_searches where id = 1982; # 1981SELECT * FROM activity_search_filters WHERE activity_search_id = 1982;SELECT * FROM automated_reports where id = 68;SELECT * FROM automated_report_results where id = 275;SELECT * FROM automated_reports order by id desc;SELECT * FROM automated_report_results order by id desc;select * from playbooks where team_id = 1;select * from crm_profiles where user_id = 143;s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdf|4 spaces...
|
NULL
|
NULL
|
NULL
|
11223
|
|
11222
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
PhpStormFileEditFV faVsco.s vProject vw testuase.uuy› _ vendorê .editorconfig= .env= .env.circleci=.env.circleci-nightly=.env.local=.env.migrate=.env.nikilocalE env.othenE env.productionE.env.production-eu=.env.aaE .env.qai=.env.rootE.env.staging= .gitattributes•.gitignore=.php-cs-fixer.cachephp.php-cs-fixer.dist.phpphp.phpstorm.meta.php=.phpunit.result.cacheE orettierianoreE .windsurfrulespip lue nelper.onephp_ide_helper_models.phpphp artisan0 composer.jsonO composer.lockO dependency-checker.json( dev.jsonEids.txtEinfection.ison.distM+INSALLMOIMJ INTERNAL_WEBHOOK_SETUP.mcEjiminny_storageM+licenses.mdM MakefileO package-lock.jsonEphpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTaraw_sqLquery.sqlM+ R-ADME,moso sonar-proiect propertiesEtest.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› ib External LibrariesE° Scratches and Consolesv D Database ConsolesViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.phpJiminnyDeouecommana.ong© AutomatedReportsCommand.php x© AutomatedReportsRepository.phpC AutomatedReportsService.phpCreateHeldActivityEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© AutomatedReportResult.phpAutomaleakeportoneJuse Jiminny\ModeLs\Team;use Jiminny\Repositories\AutomatedReportsRepository;use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;use Psr\Log\LoggerInterface;vd jiminny@localhost4 console [jiminny@localhost4 DI liiminnv@localhostlc noocaminnvolocanos4 SF [jiminny@localhost]s cono dev minny clocaine> 4 PRODTests passed: 1 (11 minutes ago)C) AutomatedReportsSendCommand.php© TrackProviderInstalledEvent.phpC RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.php19 Dclass Aurolareckeoorsconlianoiextenos coniano31 G39 C43 Gt45* Log prefix for all log messages*/private const string LOG_PREFIX = '[automated-reports]';* The name and signature of the console command.* @var string*/protected Ssignature = 'automated-reports{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}':/*** The console command description.* Ovar stringprotected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly).Use --report-id to manually trigger a specific report by ID or UUID.':public function __construct(privace readonty Loggerintertace +logger,private readonly BusDispatcher $dispatcher,private readonly AutomatedReportsRepository $reportRepositoryparent: :__construct();* Execure cne console conmono.* Oreturn int*/public function handle(): int$this->logger->info(self::LOG_PREFIX. ' Started');$now = Carbon: : now();$isMonday = $now->isMonday);$isFirstDay0fMonth = $now->day === 1;scurrencmonch = snow->month;1l check It the current monch is a quarterly monch lvanvary, April, suly, uccober$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 101,strict: true);$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [, 0f Support Daily • in 2h 40 mAL AskJiminnyReportActivityServiceT….Defaults100% C•Tue 14 Apr 12:20:24= custom.logElaravel.logÁ console [STAGING]© FilterDefinitionCollection.phpA SF ljiminny@localhost]C AskJiminnyReportActivityService.php© Criteria.php4 HS_local [jiminny@localhost]© ActivitySearch.php© AskJiminnyReportActivityServiceTest.phpAl console [PROD]A console [EU]cOnbemanavzcontroller.oneC HistoryService.phpRequestGenerateAskJiminnyReportJobTest.phpX:Auto vPlaygroundMa lminnv vv 13813914014114211451441451140147148149150151152153INSERT INTO 'activity_search_filters'C'activity_search_id,filter',"value") VALUES( activity_search_id 1977,filter 'group_id',( activity_search_id 1978,filter 'group_id',( activity_search_id 1979,filter 'group_id',445t26D8-0512-45/e-ayty-/e/sro025Czz),*445T26D8-0512-457e-ayт7-/e/sto025022),'443f26b8-8512-437e-a9f9-7e75f8025c22')select * from crm_configurations where id = 39;select * from teams where id = 1;select * from team_features where team_id = 1;select * from features;SELECT * FROM activity_searches where id = 1982; # 1981SELECT * FROM activity_search_filters WHERE activity_search_id = 1982;155SELECT * FROM automated_reports where id = 68;SELECT * FROM automated_report_results where id = 275;157158159160161162163164116511.661681691701731741751761771781791801811821831841851861871881189LIMIT 10;{"request_id": "edc47759-160a-4f61-82fc-c8cdf5e55464", "status":"completed", "timestamp": "2026-03-31T15:52:05.828229-191s3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.MDs3://dev.jiminny.client-data/5f0f4810-7e77-4086-8f69-93429ae4d70b/panorama-reports/test_req_q_1.pdflW Windsurf Teams 191:100UTF-8...
|
PhpStorm
|
faVsco.js – SF [jiminny@localhost]
|
NULL
|
11222
|
|
11221
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp••0DEV (docker)DOCKER₴81DEV (docker)882Last login: Sat Apr 11 12:38:35 on ttys006APP (-zsh)ec2-user@ip-10-30-... 24-zshPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentsPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ devroot@docker_lamp_1:/home/jiminny# php artisan automated-reports П(ablSupport Daily - in 2h 40 m100% <47-zsh86-zshX7Tue 14 Apr 12:20:23181* Unable to acce...O x8DEV...
|
NULL
|
NULL
|
NULL
|
11221
|
|
11220
|
PhpStormViewNavigateLaravelRefactonWindowFV faVsco PhpStormViewNavigateLaravelRefactonWindowFV faVsco.js vProject vProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack_leamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpo Cearevaroaseusers.oc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand.|© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.php@ Imnortl|sercFromCcvEill© IterateUsersCommand.gcJiminnvcacheclearcom(e) lminnv Deouacommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php(©) PurgeSoftDeletedOppol© PurgeSyncBatchesCom© RecalculateDealRisksCaC) RemoveDeleteMarkersd© RemoveExpiredNudgest© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© ReportController.phpJiminnyDeouecommana.ongAulomaleakeporskeposilory.oneAutomatedReportsService.php© UserPilotActivityListener.php© AutomatedReportResult.php© ActivityLogged.phpc) Automatedkeport.one© AutomatedReportsCommand.php X| AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.phpJuse Jiminny\Models\Team;use Jiminny\Repositories\AutomatedReportsRepository;use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;use Psr\Log\LoggerInterface;19 Dclass Aurolareckeoorsconlianoiextends Command31 Ct373839 G5862* Log prefix for all log messages*/private const string LOG_PREFIX = '[automated-reports]';* The name and signature of the console command.* @var string*/protected Ssignature = 'automated-reports/**Use --report-id to manually trigger a specific report by ID or UUID.';public function __construct(private readonly BusDispatcher $dispatcher,private readonly AutomatedReportsRepository $reportRepositoryparent: :__construct();* Execute the console command.* Oreturn intpublic function handle(): int$this->logger->info(self::L0G_PREFIStarted');$now = Carbon: :now();$isMonday = $now->¡sMonday();SisFirstDay0fMonth = Snow->day === 1;$currentMonth = $now->month;$this->logger->info(self::LOG_PREFIX' Checking conditions', ISuooort Dailv . in 2h 40m= custom.logÁ console [STAGING]E laravel.logA SF ljiminny@localhost]A HS_local [jiminny@localhost]#concole DPOlbIE console (EU]© AskJiminyReporfActivitySerice,php© ActivitySearch.php© OnDemandV2Controller.php© HistoryService.phpFllterbetinitioncolllection.omv© Criteria.php x© AskJiminnyReportActivityServiceTest.php x© RequestGenerateAskJiminnyReportJobTest.phpclass AskJiminnyReportActivityServiceTest extends TestCaseA2 V3 ^i evale Loucer ncel таceoмockodcel srouee9usages29 @* >71% >100 % >117118 ₽ >156157 % >1184185 ₽>205206 ₽ >224225 %226227228230ZS1204233234235236237242243244245246247248249250251252 % >274275private AskJiminnyReportActivityService $service;protected function setUp(): voidf.}11 usagesprivate function makeFilter(string $key, ?string $value): SearchFilter&Mock0bject{...}8 usagesprivate function makeUser(): User&Mock0bjectf…o usaeesprivate function makeSavedSearch(array $filters): Search&Mock0bjectf...}public function testGetActivityIdsForSavedSearchReturnsIds(): voidf…;public function testGetActivityIdsForSavedSearchReturnsEmptyWhenNoResults(): voidf...}public function testGetActivityIdsFiltersOutDateFilters(): voidf..}public function testGetActivityIdsFilters0utClosingPeriodDateFilters(): voidf...}public function testGetActivityIdsHandLesArrayFilters(): void{...}public function testGetActivityIdsHandLesScalarFilters(): voidf…public function testGetActivityIdsPassesNonZeroSequenceNumberToDisableFirstRequestDefaults(): void$user = $this->makeUser();$savedSearch = $this->makeSavedSearch([1);$filterSet = $this->createMock( originalClassName: FilterDefinitionCollection::class);$this->activitySearch->method ( constraint: 'getArrayFilterKeys')->willReturn([]);$capturedCriteria = null;$this->activitySearch->expects($this->once())->method( constraint: 'getOnDemandPageFilterSet')->W1LLReturnCallback(function (Criteria scriteria) use (sfilterset, x capturedcriteria) 1...npuhis->elasticrepos1tory->mechod constraint: 'onuemandsearchlasunly )->wiLLreturncLJh$this->logger->method( constraint: 'info');$this->service->getActivityIdsForSavedSearch($savedSearch, $user);$this->assertNotNull($capturedCriteria);$this->assertFalse($capturedCriteria->isFirstRequest());public function testGetActivityIdsLogsWithCorrectContext(): void{...}gS 50:004 spaces...
|
NULL
|
NULL
|
NULL
|
11220
|
|
11219
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ dev
root@docker_lamp_1:/home/jiminny# php artisan automated-reports
DOCKER
Close Tab
DEV (docker)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (docker)...
|
iTerm2
|
DEV (docker)
|
NULL
|
11219
|
|
11218
|
Today
automated-reports
private function processRe Today
automated-reports
private function processReports(string $frequency): void…
[URL_WITH_CREDENTIALS] ~ $ curl -s -X POST [URL_WITH_CREDENTIALS] ~ $ curl -s -X POST http://localhost:3030/raw_sql \…...
|
Raycast
|
|
NULL
|
11218
|
|
11217
|
({)PhpStormViewNavigateLaravelRefactonWindowFV faV ({)PhpStormViewNavigateLaravelRefactonWindowFV faVsco.js vProject vProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack_leamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpo Cearevaroaseusers.oc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand.|© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantissues.p© FlushRolesPermissionsC© GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.php@ Imnortl|sercFromCcvEill© IterateUsersCommand.gcJiminnvcacheclearcom(e) lminnv Deouacommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php(©) PurgeSoftDeletedOppol© PurgeSyncBatchesCom© RecalculateDealRisksCaC) RemoveDeleteMarkersd© RemoveExpiredNudgest© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© ReportController.phpJiminnyDeouecommana.ongAulomaleakeporskeposilory.oneAutomatedReportsService.php© UserPilotActivityListener.php© AutomatedReportResult.php© ActivityLogged.phpc) Automatedkeport.one© AutomatedReportsCommand.php X| AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.phpJuse Jiminny\Models\Team;use Jiminny\Repositories\AutomatedReportsRepository;use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;use Psr\Log\LoggerInterface;19 Dclass Aurolareckeoorsconlianoiextends Command31 Ct39 G51 =* Log prefix for all log messages*/private const string LOG_PREFIX = '[automated-reports]';* The name and signature of the console command.* @var string*/protected Ssignature = 'automated-reports/**Use --report-id to manually trigger a specific report by ID or UUID.':public function __construct(private readonly BusDispatcher $dispatcher,private readonly AutomatedReportsRepository $reportRepositoryparent::__construct* Execute the console command.* Oreturn intpublic function handle(): int$this->logger->info(self::LOG_PREFIX'Started');$now = Carbon: :now();$isMonday = $now->isMonday();$isFirstDay0fMonth = $now->day === 1;$currentMonth = $now->month;Suooort Dailv . in 2h 40m100% 4= custom.logÁ console [STAGING]E laravel.logA SF ljiminny@localhost]A HS_local [jiminny@localhost]#concole DPOlbI#concole f.unl© AskJiminnyReportActivityService.php© ActivitySearch.php© OnDemandV2Controller.php© HistoryService.phpFllterbetinitioncolllection.omv© Criteria.php© AskJiminnyReportActivityServiceTest.php x|© RequestGenerateAskJiminnyReportJobTest.phpclass AskJiminnyReportActivityServiceTest extends TestCaseA2 V3 ^vievale Loucer tncer тасeхмockud cel sroueer9usages29 @* >71% >100 % >117118 ₽ >156157 % >1184185 ₽>205206 >224225 %226227228230ZS1204233234235236237242243244245246247248249250251252 % >274275private AskJiminnyReportActivityService $service;protected function setUp(): voidf.}11 usagesprivate function makeFilter(string $key, ?string $value): SearchFilter&Mock0bject{...}8 usagesprivate function makeUser(): User&Mock0bjectf…o usaeesprivate function makeSavedSearch(array $filters): Search&Mock0bjectf...}public function testGetActivityIdsForSavedSearchReturnsIds(): voidf…;public function testGetActivityIdsForSavedSearchReturnsEmptyWhenNoResults(): voidf...}public function testGetActivityIdsFiltersOutDateFilters(): voidf..}public function testGetActivityIdsFilters0utClosingPeriodDateFilters(): voidf...}public function testGetActivityIdsHandLesArrayFilters(): void{...}public function testGetActivityIdsHandLesScalarFilters(): voidf…public function testGetActivityIdsPassesNonZeroSequenceNumberToDisableFirstRequestDefaults(): void$user = $this->makeUser();$savedSearch = $this->makeSavedSearch([1);$filterSet = $this->createMock( originalClassName: FilterDefinitionCollection::class);$this->activitySearch->method ( constraint: 'getArrayFilterKeys')->willReturn([]);$capturedCriteria = null;$this->activitySearch->expects($this->once())->method( constraint: 'getOnDemandPageFilterSet')->willReturnCallback(function (Criteria $criteria) use ($filterSet, &$capturedCriteria) {...});puhis->elastickepos1tory->mechodl constraint: 'onbemandsearchlasunly)->wLtrecurnclJ:$this->logger->method( constraint: 'info');$this->service->getActivityIdsForSavedSearch($savedSearch, $user);$this->assertNotNull($capturedCriteria);$this->assertFalse($capturedCriteria->isFirstRequest());public function testGetActivityIdsLogsWithCorrectContext(): void{...}gs 40:79uir-of 4 spaces...
|
NULL
|
NULL
|
NULL
|
11217
|
|
11216
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplhlSupport Daily - in 2h 40 m100% <•DEV (-zsh)DOCKER• 881DEV (-zsh)Last login: Sat Apr 11 12:38:35 on ttys006APP (-zsh)ec2-user@ip-10-30-...X4-zshPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentsPoetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parentslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $-zsh86-zshO &78Tue 14 Apr 12:20:01T81* Unable to acce...O 88DEV...
|
NULL
|
NULL
|
NULL
|
11216
|
|
11215
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (-zsh)...
|
iTerm2
|
DEV (-zsh)
|
NULL
|
11215
|
|
11214
|
Last login: Sat Apr 11 12:38:35 on ttys006
Poetry Last login: Sat Apr 11 12:38:35 on ttys006
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
DEV (-zsh)...
|
iTerm2
|
DEV (-zsh)
|
NULL
|
11214
|
|
11213
|
Last login: Sat Apr 11 12:38:35 on ttys007
Poetry Last login: Sat Apr 11 12:38:35 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-18909-automated-reports-ask-jiminny) $ vstg
Warning: Permanently added 'jiminny-stage-ecs1' (ED25519) to the list of known hosts.
A newer release of "Amazon Linux" is available.
Version 2023.10.20260105:
Version 2023.10.20260120:
Version 2023.10.20260202:
Version 2023.10.20260216:
Version 2023.10.20260302:
Version 2023.10.20260325:
Version 2023.10.20260330:
Version 2023.11.20260406:
Version 2023.11.20260413:
Version 2023.8.20250707:
Version 2023.8.20250715:
Version 2023.8.20250721:
Version 2023.8.20250808:
Version 2023.8.20250818:
Version 2023.8.20250908:
Version 2023.8.20250915:
Version 2023.9.20250929:
Version 2023.9.20251014:
Version 2023.9.20251020:
Version 2023.9.20251027:
Version 2023.9.20251105:
Version 2023.9.20251110:
Version 2023.9.20251117:
Version 2023.9.20251208:
Run "/usr/bin/dnf check-release-update" for full release and version update info
, #_
~\_ ####_
~~ \_#####\
~~ \###|
~~ \#/ ___ Amazon Linux 2023 (ECS Optimized)
~~ V~' '->
~~~ /
~~._. _/
_/ _/
_/m/'
For documentation, visit [URL_WITH_CREDENTIALS] php artisan automated-reports
[2026-04-14 07:48:51] staging.INFO: [automated-reports] Started {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fb1ecfded81"}
[2026-04-14 07:48:51] staging.INFO: [automated-reports] Checking conditions {"isMonday":false,"isFirstDayOfMonth":false,"currentMonth":4,"isQuarterlyMonth":true} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fb1ecfded81"}
[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-5fb1ecfded81"}
[2026-04-14 07:48:51] staging.INFO: [automated-reports] Found 2 daily reports to process {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fb1ecfded81"}
[2026-04-14 07:48:51] staging.INFO: [automated-reports] Dispatching Generate Report job 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-5fb1ecfded81"}
[2026-04-14 07:48:51] staging.INFO: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054","teamId":1,"frequency":"daily","type":"ask_jiminny"} {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fb1ecfded81"}
[2026-04-14 07:48:51] staging.INFO: [automated-reports] Completed {"correlation_id":"4c37ea47-eebd-4122-8c35-9d6b9d707beb","trace_id":"bfe6b131-e3ad-4cfc-8954-5fb1ecfded81"}
root@fee51d2e1f17:/home/jiminny# [ec2-user@ip-10-30-93-249 ~]$ docker exec -it $(docker ps --format "{{.ID}}" --filter "name=ecs-worker" | head -1) /bin/bash -c "cd /home/jiminny && bash"
root@73b64f5d54a3:/home/jiminny# php artisan automated-reports
[2026-04-14 08:41:03] staging.INFO: [automated-reports] Started {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
[2026-04-14 08:41:03] staging.INFO: [automated-reports] Checking conditions {"isMonday":false,"isFirstDayOfMonth":false,"currentMonth":4,"isQuarterlyMonth":true} {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
[2026-04-14 08:41:03] staging.INFO: [automated-reports] Processing daily reports {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
[2026-04-14 08:41:03] staging.INFO: [automated-reports] Found 3 daily reports to process {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
[2026-04-14 08:41:03] staging.INFO: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"fa7417aa-538e-49ab-8827-77235637a6f9","teamId":1,"frequency":"daily","type":"ask_jiminny"} {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
[2026-04-14 08:41:03] staging.INFO: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"63e6d70b-b7cb-4dfa-8443-53453e6c4054","teamId":1,"frequency":"daily","type":"ask_jiminny"} {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
[2026-04-14 08:41:04] staging.INFO: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8","teamId":1,"frequency":"daily","type":"ask_jiminny"} {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
[2026-04-14 08:41:04] staging.INFO: [automated-reports] Completed {"correlation_id":"c858e03f-62bd-462d-add2-c1e12a4c4cf8","trace_id":"94b4fdcc-f609-42e7-b5b7-b6abfc67e02f"}
root@73b64f5d54a3:/home/jiminny# [ec2-user@ip-10-30-93-249 ~]$
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-93-249:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
⌥⌘1
ec2-user@ip-10-30-93-249:~...
|
iTerm2
|
ec2-user@ip-10-30-93-249:~
|
NULL
|
11213
|
|
11212
|
PhpStormProject vFileEditViewNavigateCodeLaravelRe PhpStormProject vFileEditViewNavigateCodeLaravelRefactorToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.phpJiminnyDeouecommana.ongProphetAiAutomatedReportsRepository.phpAutomatedReportsService.phpv D Reports© AutomatedReportsCl© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCommand.php X| AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php© AutomatedReportsRe© AutomatedReportResult.phpc) Automatedkeport.one© AutomatedReportsSt© CreateMockAskJimirJuse Jiminny\Models\Team;© DeleteReportCommause Jiminny\Repositories\AutomatedReportsRepository;© GenerateMarketingRuse Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;© Team.phpuse Psr\Log\LoggerInterface;© Usage.phpD Slack19 Dclass Aurolareckeoorsconlianoiextends Command_leamsD TracksO Transcription* Log prefix for all log messagesO Twilio*/D Usersprivate const string LOG_PREFIX = '[automated-reports]';VocabularyDZoom© CoachingFeedbacksUpr* The name and signature of the console command.© Command.phpo Cearevaroaseusers.o* @var stringc Daraoase oecountoi*/© DeleteOldAiCrmNotesC:31 Ctprotected Ssignature = 'automated-reports© DeleteS3LeftoversComiDevPostmanCommand.|/**© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php* Ovar string© FixCrossTenantissues.p© FlushRolesPermissionsC39 G© GeneratelnternalWebhoUse --report-id to manually trigger a specific report by ID or UUID.'il• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingCpublic function __construct(© HubspotWebhookServic© ImportRecording.php@ Imnortl|sercFromCcvEillprivate readonly BusDispatcher $dispatcher,private readonly AutomatedReportsRepository $reportRepository© IterateUsersCommand.gparent::__constructcJiminnvcacheclearcom(e) lminnv Deouacommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLiveCoaching* Execute the console command.© ManageScimForTeam.p© MarkBranchForEnvironn* Oreturn int© MuteOrganizerChannel.© PhpApm.phppublic function handle(): int© PropagateCoachingFeer© PurgeConferences.php$this->logger->info(self::LOG_PREFIX'Started');(©) PurgeSoftDeletedOppol© PurgeSyncBatchesCom© RecalculateDealRisksCaC) RemoveDeleteMarkersd© RemoveExpiredNudgest$now = Carbon: :now();$isMonday = $now->isMonday();$isFirstDay0fMonth = $now->day === 1;$currentMonth = $now->month;© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProvstrict: true);© RestoreActivityTypeCorTests passed: 1 (11 minutes ago)© AddLayoutEntities.php© Team.phpCreateActivityLoggedEvent.php© RequestGenerateReportJob.php$this->logger->info(self::LOG_PREFIX' Checking conditions', I• Suonort Dailv • in 2h 41 mA1EAsk JiminnvRenortActivitvServiceT. Defaults100% |45]Tue 14 Apr 12:19:56= custom.logÁ console [STAGING]E laravel.logA SF ljiminny@localhost]A HS_local [jiminny@localhost]Al console [PROD]A console [EU]© AskJiminnyReportActivityService.php© ActivitySearch.php© OnDemandV2Controller.php© HistoryService.php© FllterDefinitionCollection.phpC) Criteria.php© AskJiminnyReportActivityServiceTest.php X© RequestGenerateAskJiminnyReportJobTest.phpclass AskJiminnyReportActivityServiceTest extends TestCase42 X3 лvievale Loucer tncer тасeхмockud cel sroueer9usages29 @* >71 %>100 % >117118 ₽ >156157 % >1184185 ₽>205206 ₽ >224225 %226227228230ZS1204233234235236237242243244245246247248249250251252 % >274275private AskJiminnyReportActivityService $service;protected function setUp(): voidf...}11 usagesprivate function makeFilter(string $key, ?string $valve): SearchFilter&Mock0bjectf...}8 usagesprivate function makeUser(): User&Mock0bjectf…o usaeesprivate function makeSavedSearch(array $filters): Search&Mock0bject{……}public function testGetActivityIdsForSavedSearchReturnsIds(): voidf…;public function testGetActivityIdsForSavedSearchReturnsEmptyWhenNoResults(): voidk..}public function testGetActivityIdsFiltersOutDateFilters(): voidf..}public function testGetActivityIdsFilters0utClosingPeriodDateFilters(): voidf...}public function testGetActivityIdsHandLesArrayFilters(): void{...}public function testGetActivityIdsHandlesScalarFilters(): voidf..public function testGetActivityIdsPassesNonZeroSequenceNumberToDisableFirstRequestDefaults(): void$user = $this->makeUser():ssavedsearch = pchis->makesavedsearcncl..h$filterSet = $this->createMock( originalClassName: FilterDefinitionCollection::class);$this->activitySearch->method ( constraint: 'getArrayFilterKeys')->willReturn([]);$capturedCriteria = null;$this->activitySearch->expects($this->once())->method( constraint: 'getOnDemandPageFilterSet')->willReturnCallback(function (Criteria $criteria) use ($filterSet, &$capturedCriteria) {...});puhis->elastickepos1tory->mechodl constraint: 'onbemandsearchlasunly)->wLtrecurnclJ:$this->logger->method( constraint: 'info');$this->service->getActivityIdsForSavedSearch($savedSearch, $user);$this->assertNotNull($capturedCriteria);$this->assertFalse($capturedCriteria->isFirstRequest());public function testGetActivityIdsLogsWithCorrectContext(): void{...}Winasun leams40:79uir-of 4 spaces...
|
NULL
|
NULL
|
NULL
|
11212
|
|
11211
|
+SlackEDHomeDMSActivityFilesLater..•More+FileEditV +SlackEDHomeDMSActivityFilesLater..•More+FileEditViewGoHistoryWindowHelpJiminny ...# Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi…..Direct messagesAneliya Angelova, ...Steliyan GeorgievAdelina Petrova, Ili.... Adelina PetrovaO. Calea Dimitravo→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan GeorgievMessagesAdd canvas+Nikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтьрNikolay Yankov 11:01 AMДобреNikolay Yankov 11:39 AMя рьнни пак LukasLukas Kovalik 11:43 AMготовосьщотоCompetitive pitches беше втория нали такаNikolay Yankov 12:04 PMДа, там има 14 активитита, защо не сработи този пьт?Lukas Kovalik 12:05 PMпак изглежда sequenceгледам гоMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AalahlSupport Daily - in 2h 41 m100% <47Tue 14 Apr 12:19:548Today ~...
|
NULL
|
NULL
|
NULL
|
11211
|
|
11210
|
PhpStormProject vFileEditFV faVsco.js vViewNavigat PhpStormProject vFileEditFV faVsco.js vViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-iminny K vProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack• TeamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantissues.p© FlushRolesPermissionsC© GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic©ImportRecording.phpemnortcorc.romecv=llC IterateUsersCommand.cJiminnvcacheclearcom(c) minnv Deouacommanc(c)Jminnvser-ncrvotedio(c) Jiminny okenintocomm© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom(e RecalculatebealkiskscoC) RemoveDeleteMarkersd(C) RemoveExpiredNudaes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCorTests passed: 1 (11 minutes ago)© ReportController.php© AutomatedReportsSendCommand.php© JiminnyDebugCommand.php© AddLayoutEntities.php© AutomatedReportsService.phpC) CreateActivityLoggedEvent.phpAutomatedReportsCommand.php x© Team.php© CreateHeldActivityEvent.php© UserPilotActivityListener.php= custom.log= laravel.logA SF [jiminny@localhost]Hs local liminnyalocalnostconsole PRODL console [EUlC AutomatedReportsCallbackService.php(0) RequestGenerate.sk.liminnvRenor.ob.ohn© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpA2^¿ consoe STAGINGII© AskJiminnyReportActivityService.php© ActivitySearch.php•OnDemandV2Controller.phprilterDerinitioncollection.onpC Criteria.php© AskJiminnyReportActivityServiceTest.php x© RequestGenerateAskJiminnyReportJobTest.phpclass AskJiminnyReportActivityServiceTe0bject $logger;© HistoryService.phpBLMSAY19 D31 Ct39 G43 Ct52\Team;tories\AutomatedReportsRepository;es\Kiosk\AutomatedReports\AutomatedReportsService;Interface;iryserulcce oserucen29 6t >oidf.orscolliano extenos coniianol› tring $key, ?string $value): SearchFilter&Mock0bject(...}For all log messagesstring LOG_PREFIX = '[automated-reports]':› User&MockObjectf...}1 signature of the console command.› rch(array $filters): Search&MockObject{...}71 >tyIdsForSavedSearchReturnsIds(): voidf...}lature ='automated-reportsid= : Process a specific report by ID or UUID (bypasses frequency scheduling)}':100 % > tyIdsForSavedSearchReturnsEmptyWhenNoResults(): voidf...}command description.117118 % > tyIdsFiltersOutDateFilters(): voidf...}156157 %>tyIdsFilters0utClosingPeriodDateFilters(): voidf..}185 M >tyIdsHandLesArrayFilters(): voidf...3pription = 'Process automated reports based on their frequency (weekly, monthly, qU 206 86>'t-id to manually trigger a specific report by ID or UUID.':tyIdsHandlesScalarFilters(): void{...;tyIdsPassesNonZeroSequenceNumberToDisableFirstRequestDefaults__constructCadonly LoggerInterface $logger,adonly BusDispatcher $dispatcher,adonly AutomatedReportsRepository $reportRepository224225 ₽L40eSavedSearch([]):229230eMock( originalClassName: FilterDefinitionCollection::class);construct();chodl constraint: 'gecArrayrilterkeys )->wLLcreturnuLJ:1 To Lonmand234255console commandpects ($this->once())tOnDemandPageFilterSet')function (Criteria $criteria) use ($filterSet, &$capturedCrith handle(): intjer->info(self::LOG_PREFIX . ' Started'):bon::now();= snow->1SMondayO;VutMonun = snow-sdav sez iith = Snow->month:237242243244245246247248— 247200>method( constraint: 'onDemandSearchIdsOnly') ->willReturn([]);istraint: 'info');tyIdsForSavedSearch($savedSearch, $user);reourrerarnsrurstre.uest.252 8j Support Daily • in 2h 41 mAAskJiminnyReportActivityServiceT…Defaults100% C•Tue 14 Apr 12:19:53CascadeFixing ReportControllerAutomated Report MarFixing Ask Jiminny Rep+D ...Explain it to me again. Why is there issue with thhat? Where is it expected and why do I need to work with that. How is it used inclllanuvzconeroes vasee oll saveuoedichl. Une los m on celllane ane iiOnSkdILmlуnedoT LheLeveLyetVLceronorL44-00 snoule De sallleCascadeWLet me read the OnDemandV2Controller to understand how it builds criteria there:Read OnDemanavzcontNow look at the key difference. The controller's getContextForAskAnythingByFilter at OnDemandV2Controller.php: 90-93:0 phpVO Repository OnDemandActivitySearch\Criteria::createFromRequest(arrav meroesrequesoaluo.' umir => 00c0unt "oade$user->getTimezone()It passes Srequest->all() - which includes sequence_number from the URL (e.g. sequence_number=4 from your staging URL). So when a user has beenpaginating on the frontend, sequence_number is naturally non-zero.The full explanationyou didn't ask for them:hsiauist kecuestaouncskenererurns true wnen seauenceNumber === u wnenttsine "trstreduestneseumolci detauirs kickinauromaricalveventFiterDefault on first requestEffectActiv1tvburat zonkangelmin_duration = 1 minDroos 0-secono activitiesActivityRecordedonly_recorded = 1Recorded activities onlvOrganiserGroupInUser's own groupRestricts to user's groupFrontend hits /api/v1/page/on-demand?topic id(]=...&sequence number=4 → sequence number=4 → isFirstRequest = false → no implicit defaults →returns 15 activities.AskJiminnyReportActivityService (before the fix) built params from the saved search filters but never included sequence number → defaulted to 0 → isFirstRequest() = true → implicit defaults applied → 0 activities returned because the topic filter + recorded-onlv + duration>1 together matchednothing.Why sequence_number=1 is the right fixThe service is doing a deliberate, one-shot search - not a paginated session. It should never apply first-request defaults, because:1. The saved search already encodes the user's intent (those filters were chosen explicitly)2. Date filters are already intentionally stripped (that's existing logic in DATE_FILTER_KEYS )3. Adding implicit min_duration, only_recorded, and group scope on top would contradict what the saved search representsSetting sequence number=1 is the minimal, correct signal: "this is not a fresh session open, don't apply page-load defaults". The criteria is otherwise builtidentically to how the controller builds it - same Criteria::createFromRequest, same get0nDemandPageFilterSet, same onDemandSearchIds0nly - so theresults will now match.Ö ul ...Ask anything (2*L)+ <> CodeClaude Sonnet 4.6winasun leamsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
11210
|
|
11209
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
2
3
Previous Highlighted Error
Next Highlighted Error
<?php
declare(strict_types=1);
namespace Tests\Unit\Services\Kiosk\AutomatedReports;
use Jiminny\Component\ActivitySearch\FilterDefinition\ActivityActualDate;
use Jiminny\Component\ActivitySearch\FilterDefinition\ActivityUpdatedDate;
use Jiminny\Component\ActivitySearch\FilterDefinition\DealInsights\ClosingPeriodFilter;
use Jiminny\Component\ActivitySearch\FilterDefinitionCollection;
use Jiminny\Component\ActivitySearch\Service\ActivitySearch;
use Jiminny\Models\Activity\Search;
use Jiminny\Models\Activity\SearchFilter;
use Jiminny\Models\User;
use Jiminny\Repositories\ElasticActivityRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AskJiminnyReportActivityService;
use Jiminny\VO\Repository\OnDemandActivitySearch\Criteria;
use PHPUnit\Framework\MockObject\MockObject;
use PHPUnit\Framework\TestCase;
use Psr\Log\LoggerInterface;
class AskJiminnyReportActivityServiceTest extends TestCase
{
private ActivitySearch&MockObject $activitySearch;
private ElasticActivityRepository&MockObject $elasticRepository;
private LoggerInterface&MockObject $logger;
private AskJiminnyReportActivityService $service;
protected function setUp(): void
{
$this->activitySearch = $this->createMock(ActivitySearch::class);
$this->elasticRepository = $this->createMock(ElasticActivityRepository::class);
$this->logger = $this->createMock(LoggerInterface::class);
$this->service = new AskJiminnyReportActivityService(
$this->activitySearch,
$this->elasticRepository,
$this->logger,
);
}
private function makeFilter(string $key, ?string $value): SearchFilter&MockObject
{
$filter = $this->createMock(SearchFilter::class);
$filter->method('getFilterProperty')->willReturn($key);
$filter->method('getFilterValue')->willReturn($value);
return $filter;
}
private function makeUser(): User&MockObject
{
$tz = new \DateTimeZone('UTC');
$user = $this->createMock(User::class);
$user->method('getTimezone')->willReturn($tz);
$user->method('getId')->willReturn(1);
$user->method('getUuid')->willReturn('user-uuid');
return $user;
}
private function makeSavedSearch(array $filters): Search&MockObject
{
$savedSearch = $this->createMock(Search::class);
$savedSearch->method('getId')->willReturn(42);
$savedSearch->method('getFilters')->willReturn(new \Illuminate\Support\LazyCollection($filters));
return $savedSearch;
}
public function testGetActivityIdsForSavedSearchReturnsIds(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->expects($this->once())
->method('getArrayFilterKeys')
->with($user)
->willReturn([]);
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturn($filterSet);
$this->elasticRepository->expects($this->once())
->method('onDemandSearchIdsOnly')
->willReturn(['id-1', 'id-2', 'id-3']);
$this->logger->expects($this->once())
->method('info')
->with('[AskJiminnyReport] Fetched activity IDs for saved search');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-1', 'id-2', 'id-3'], $result);
}
public function testGetActivityIdsForSavedSearchReturnsEmptyWhenNoResults(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn([]);
$this->logger->expects($this->once())->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEmpty($result);
}
public function testGetActivityIdsFiltersOutDateFilters(): void
{
$user = $this->makeUser();
$nonDateFilter = $this->makeFilter('owner_id', '123');
$startDateFilter = $this->makeFilter(ActivityActualDate::PARAM_START_DATE, '2025-01-01 00:00:00');
$endDateFilter = $this->makeFilter(ActivityActualDate::PARAM_END_DATE, '2025-01-31 23:59:59');
$updatedFromFilter = $this->makeFilter(ActivityUpdatedDate::PARAM_UPDATED_FROM, '2025-01-01 00:00:00');
$updatedToFilter = $this->makeFilter(ActivityUpdatedDate::PARAM_UPDATED_TO, '2025-01-31 23:59:59');
$savedSearch = $this->makeSavedSearch([
$nonDateFilter,
$startDateFilter,
$endDateFilter,
$updatedFromFilter,
$updatedToFilter,
]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$capturedCriteria = null;
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturnCallback(function (Criteria $criteria) use ($filterSet, &$capturedCriteria) {
$capturedCriteria = $criteria;
return $filterSet;
});
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn([]);
$this->logger->method('info');
$this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertNotNull($capturedCriteria);
}
public function testGetActivityIdsFiltersOutClosingPeriodDateFilters(): void
{
$user = $this->makeUser();
$closingStartFilter = $this->makeFilter(ClosingPeriodFilter::KEY_START_DATE, '2025-01-01');
$closingEndFilter = $this->makeFilter(ClosingPeriodFilter::KEY_END_DATE, '2025-03-31');
$regularFilter = $this->makeFilter('rep_id', '99');
$savedSearch = $this->makeSavedSearch([
$closingStartFilter,
$closingEndFilter,
$regularFilter,
]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['id-1']);
$this->logger->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-1'], $result);
}
public function testGetActivityIdsHandlesArrayFilters(): void
{
$user = $this->makeUser();
$filter1 = $this->makeFilter('outcome', 'positive');
$filter2 = $this->makeFilter('outcome', 'negative');
$savedSearch = $this->makeSavedSearch([$filter1, $filter2]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn(['outcome']);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['id-1']);
$this->logger->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-1'], $result);
}
public function testGetActivityIdsHandlesScalarFilters(): void
{
$user = $this->makeUser();
$filter = $this->makeFilter('direction', 'inbound');
$savedSearch = $this->makeSavedSearch([$filter]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['id-5']);
$this->logger->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-5'], $result);
}
public function testGetActivityIdsPassesNonZeroSequenceNumberToDisableFirstRequestDefaults(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$capturedCriteria = null;
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturnCallback(function (Criteria $criteria) use ($filterSet, &$capturedCriteria) {
$capturedCriteria = $criteria;
return $filterSet;
});
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn([]);
$this->logger->method('info');
$this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertNotNull($capturedCriteria);
$this->assertFalse($capturedCriteria->isFirstRequest());
}
public function testGetActivityIdsLogsWithCorrectContext(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['a', 'b']);
$this->logger->expects($this->once())
->method('info')
->with(
'[AskJiminnyReport] Fetched activity IDs for saved search',
$this->callback(fn ($context) => $context['saved_search_id'] === 42
&& $context['user_id'] === 1
&& $context['activity_count'] === 2)
);
$this->service->getActivityIdsForSavedSearch($savedSearch, $user);
}
}
Code changed:
Hide
Sync Changes
Hide This Notification
2
Previous Highlighted Error
Next Highlighted Error
<?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 Illuminate\Support\Collection;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\Team;
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
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly).
Use --report-id to manually trigger a specific report by ID or UUID.';
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");
$reportId = $this->option('report-id');
if ($reportId !== null) {
$reports = $this->getReportById($reportId);
} else {
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
}
$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);
}
}
private function getReportById(string $reportId): Collection
{
$report = $this->reportRepository->findByIdOrUuid($reportId);
if ($report === null) {
$this->logger->warning(self::LOG_PREFIX . ' Report not found for --report-id', ['reportId' => $reportId]);
$this->warn("Report not found: {$reportId}");
return collect();
}
if (! $report->getStatus()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is inactive, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
]);
$this->warn('Report is inactive — processing anyway (manual override).');
}
$team = $report->getTeam();
if ($team->getStatus() !== Team::STATUS_ACTIVE) {
$this->logger->warning(self::LOG_PREFIX . ' Team is not active, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'teamStatus' => $team->getStatus(),
]);
$this->warn("Team #{$report->getTeamId()} is not active — processing anyway (manual override).");
}
if ($report->isExpired()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is expired, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'expiresAt' => $report->getExpiresAt()?->toDateString(),
]);
$this->warn('Report is expired (expires_at: ' . $report->getExpiresAt()?->toDateString() . ') — processing anyway (manual override).');
}
return collect([$report]);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
11209
|
|
11208
|
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
AskJiminnyReportActivityServiceT…Defaults
Run 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
Debug 'AskJiminnyReportActivityServiceTest.tes…uenceNumberToDisableFirstRequestDefaults'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
2
3
Previous Highlighted Error
Next Highlighted Error
<?php
declare(strict_types=1);
namespace Tests\Unit\Services\Kiosk\AutomatedReports;
use Jiminny\Component\ActivitySearch\FilterDefinition\ActivityActualDate;
use Jiminny\Component\ActivitySearch\FilterDefinition\ActivityUpdatedDate;
use Jiminny\Component\ActivitySearch\FilterDefinition\DealInsights\ClosingPeriodFilter;
use Jiminny\Component\ActivitySearch\FilterDefinitionCollection;
use Jiminny\Component\ActivitySearch\Service\ActivitySearch;
use Jiminny\Models\Activity\Search;
use Jiminny\Models\Activity\SearchFilter;
use Jiminny\Models\User;
use Jiminny\Repositories\ElasticActivityRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AskJiminnyReportActivityService;
use Jiminny\VO\Repository\OnDemandActivitySearch\Criteria;
use PHPUnit\Framework\MockObject\MockObject;
use PHPUnit\Framework\TestCase;
use Psr\Log\LoggerInterface;
class AskJiminnyReportActivityServiceTest extends TestCase
{
private ActivitySearch&MockObject $activitySearch;
private ElasticActivityRepository&MockObject $elasticRepository;
private LoggerInterface&MockObject $logger;
private AskJiminnyReportActivityService $service;
protected function setUp(): void
{
$this->activitySearch = $this->createMock(ActivitySearch::class);
$this->elasticRepository = $this->createMock(ElasticActivityRepository::class);
$this->logger = $this->createMock(LoggerInterface::class);
$this->service = new AskJiminnyReportActivityService(
$this->activitySearch,
$this->elasticRepository,
$this->logger,
);
}
private function makeFilter(string $key, ?string $value): SearchFilter&MockObject
{
$filter = $this->createMock(SearchFilter::class);
$filter->method('getFilterProperty')->willReturn($key);
$filter->method('getFilterValue')->willReturn($value);
return $filter;
}
private function makeUser(): User&MockObject
{
$tz = new \DateTimeZone('UTC');
$user = $this->createMock(User::class);
$user->method('getTimezone')->willReturn($tz);
$user->method('getId')->willReturn(1);
$user->method('getUuid')->willReturn('user-uuid');
return $user;
}
private function makeSavedSearch(array $filters): Search&MockObject
{
$savedSearch = $this->createMock(Search::class);
$savedSearch->method('getId')->willReturn(42);
$savedSearch->method('getFilters')->willReturn(new \Illuminate\Support\LazyCollection($filters));
return $savedSearch;
}
public function testGetActivityIdsForSavedSearchReturnsIds(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->expects($this->once())
->method('getArrayFilterKeys')
->with($user)
->willReturn([]);
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturn($filterSet);
$this->elasticRepository->expects($this->once())
->method('onDemandSearchIdsOnly')
->willReturn(['id-1', 'id-2', 'id-3']);
$this->logger->expects($this->once())
->method('info')
->with('[AskJiminnyReport] Fetched activity IDs for saved search');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-1', 'id-2', 'id-3'], $result);
}
public function testGetActivityIdsForSavedSearchReturnsEmptyWhenNoResults(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn([]);
$this->logger->expects($this->once())->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEmpty($result);
}
public function testGetActivityIdsFiltersOutDateFilters(): void
{
$user = $this->makeUser();
$nonDateFilter = $this->makeFilter('owner_id', '123');
$startDateFilter = $this->makeFilter(ActivityActualDate::PARAM_START_DATE, '2025-01-01 00:00:00');
$endDateFilter = $this->makeFilter(ActivityActualDate::PARAM_END_DATE, '2025-01-31 23:59:59');
$updatedFromFilter = $this->makeFilter(ActivityUpdatedDate::PARAM_UPDATED_FROM, '2025-01-01 00:00:00');
$updatedToFilter = $this->makeFilter(ActivityUpdatedDate::PARAM_UPDATED_TO, '2025-01-31 23:59:59');
$savedSearch = $this->makeSavedSearch([
$nonDateFilter,
$startDateFilter,
$endDateFilter,
$updatedFromFilter,
$updatedToFilter,
]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$capturedCriteria = null;
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturnCallback(function (Criteria $criteria) use ($filterSet, &$capturedCriteria) {
$capturedCriteria = $criteria;
return $filterSet;
});
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn([]);
$this->logger->method('info');
$this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertNotNull($capturedCriteria);
}
public function testGetActivityIdsFiltersOutClosingPeriodDateFilters(): void
{
$user = $this->makeUser();
$closingStartFilter = $this->makeFilter(ClosingPeriodFilter::KEY_START_DATE, '2025-01-01');
$closingEndFilter = $this->makeFilter(ClosingPeriodFilter::KEY_END_DATE, '2025-03-31');
$regularFilter = $this->makeFilter('rep_id', '99');
$savedSearch = $this->makeSavedSearch([
$closingStartFilter,
$closingEndFilter,
$regularFilter,
]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['id-1']);
$this->logger->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-1'], $result);
}
public function testGetActivityIdsHandlesArrayFilters(): void
{
$user = $this->makeUser();
$filter1 = $this->makeFilter('outcome', 'positive');
$filter2 = $this->makeFilter('outcome', 'negative');
$savedSearch = $this->makeSavedSearch([$filter1, $filter2]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn(['outcome']);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['id-1']);
$this->logger->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-1'], $result);
}
public function testGetActivityIdsHandlesScalarFilters(): void
{
$user = $this->makeUser();
$filter = $this->makeFilter('direction', 'inbound');
$savedSearch = $this->makeSavedSearch([$filter]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['id-5']);
$this->logger->method('info');
$result = $this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertEquals(['id-5'], $result);
}
public function testGetActivityIdsPassesNonZeroSequenceNumberToDisableFirstRequestDefaults(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$capturedCriteria = null;
$this->activitySearch->expects($this->once())
->method('getOnDemandPageFilterSet')
->willReturnCallback(function (Criteria $criteria) use ($filterSet, &$capturedCriteria) {
$capturedCriteria = $criteria;
return $filterSet;
});
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn([]);
$this->logger->method('info');
$this->service->getActivityIdsForSavedSearch($savedSearch, $user);
$this->assertNotNull($capturedCriteria);
$this->assertFalse($capturedCriteria->isFirstRequest());
}
public function testGetActivityIdsLogsWithCorrectContext(): void
{
$user = $this->makeUser();
$savedSearch = $this->makeSavedSearch([]);
$filterSet = $this->createMock(FilterDefinitionCollection::class);
$this->activitySearch->method('getArrayFilterKeys')->willReturn([]);
$this->activitySearch->method('getOnDemandPageFilterSet')->willReturn($filterSet);
$this->elasticRepository->method('onDemandSearchIdsOnly')->willReturn(['a', 'b']);
$this->logger->expects($this->once())
->method('info')
->with(
'[AskJiminnyReport] Fetched activity IDs for saved search',
$this->callback(fn ($context) => $context['saved_search_id'] === 42
&& $context['user_id'] === 1
&& $context['activity_count'] === 2)
);
$this->service->getActivityIdsForSavedSearch($savedSearch, $user);
}
}
Code changed:
Hide
Sync Changes
Hide This Notification
2
Previous Highlighted Error
Next Highlighted Error
<?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 Illuminate\Support\Collection;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\Team;
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
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly).
Use --report-id to manually trigger a specific report by ID or UUID.';
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");
$reportId = $this->option('report-id');
if ($reportId !== null) {
$reports = $this->getReportById($reportId);
} else {
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
}
$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);
}
}
private function getReportById(string $reportId): Collection
{
$report = $this->reportRepository->findByIdOrUuid($reportId);
if ($report === null) {
$this->logger->warning(self::LOG_PREFIX . ' Report not found for --report-id', ['reportId' => $reportId]);
$this->warn("Report not found: {$reportId}");
return collect();
}
if (! $report->getStatus()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is inactive, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
]);
$this->warn('Report is inactive — processing anyway (manual override).');
}
$team = $report->getTeam();
if ($team->getStatus() !== Team::STATUS_ACTIVE) {
$this->logger->warning(self::LOG_PREFIX . ' Team is not active, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'teamStatus' => $team->getStatus(),
]);
$this->warn("Team #{$report->getTeamId()} is not active — processing anyway (manual override).");
}
if ($report->isExpired()) {
$this->logger->warning(self::LOG_PREFIX . ' Report is expired, processing anyway (manual override)', [
'reportId' => $reportId,
'reportUuid' => $report->getUuid(),
'expiresAt' => $report->getExpiresAt()?->toDateString(),
]);
$this->warn('Report is expired (expires_at: ' . $report->getExpiresAt()?->toDateString() . ') — processing anyway (manual override).');
}
return collect([$report]);
}
}
Project...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
11208
|
|
11207
|
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
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
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...
|
Firefox
|
Jiminny — Work
|
app.staging.jiminny.com/ondemand?topic_id[]=e02f09 app.staging.jiminny.com/ondemand?topic_id[]=e02f0932-cb76-41b6-ac4f-6b8db1392146&include_internal_conversations=1&sequence_number=4...
|
11207
|
|
11206
|
PhpStormViewNavigatelaraveRefactonWindowFVravsco.i PhpStormViewNavigatelaraveRefactonWindowFVravsco.isv#11894 on.lY-18909-automated-renorts-ask-liminnvkProject vProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack_leamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantissues.p(C) FlushRolesPermissions(© GeneratelnternalWebho• GroupSetDefaultLanguaHelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic©ImportRecording.php@ Imnortli|sercFromCcvEilC IterateUsersCommand.cJiminnvcacheclearcom(c) minnv Deouacommanc(c)Jminnvser-ncrvotedio(c) Jiminny okenintocomm© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom(e RecalculatebealkiskscoC) RemoveDeleteMarkersd(C) RemoveExpiredNudaes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© ReportController.phpJiminnybeouecommana.ongAulomaleakeporissendcommand.ong© AddLayoutEntities.php) AutomatedReportsService.php©) CreateActivityLoggeaevent.onp© AutomatedReportsCommand.php x© Team.php© CreateHeldActivityEvent.php© UserPilotActivityListener.php= custom.log= laravel.logA SF [jiminny@localhost]Hs local liminnyalocalnostconsole PRODL console [EUlC AutomatedReportsCallbackService.phpRequestGenerateask.lminnvRenor.lob.onn© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpA2^¿ consoe STAGINGII© AskJiminnyReportActivityService.php© ActivitySearch.php•OnDemandV2Controller.phprilterDerinitioncollection.ongC Criteria.php© AskJiminnyReportActivityServiceTest.php x© RequestGenerateAskJiminnyReportJobTest.phpclass AskJiminnyReportActivityServiceTe0bject $logger;© HistoryService.phpBLMSAY19 D31 Ct39 G43 Ct\Team;tories\AutomatedReportsRepository;es\Kiosk\AutomatedReports\AutomatedReportsService;Interface;iryserulcce oserucen29 6t >oidf..}orscolliano extenos coniianoi› tring $key, ?string $value): SearchFilter&Mock0bject(...}For all log messagesstring LOG_PREFIX = '[automated-reports]':› User&MockObjectf...}1 signature of the console command.› rch(array $filters): Search&MockObject{...}71 >tyIdsForSavedSearchReturnsIds(): voidf...}lature = 'automated-reportsid= : Process a specific report by ID or UUID (bypasses frequency scheduling)}':100 % > tyIdsForSavedSearchReturnsEmptyWhenNoResults(): voidf...}command description.117118 % > tyIdsFiltersOutDateFilters(): voidf...}156157 %>tyIdsFilters0utClosingPeriodDateFilters(): voidf..185 M >tyIdsHandLesArrayFilters(): voidf...3pription = 'Process automated reports based on their frequency (weekly, monthly, qU 206 86>'t-id to manually trigger a specific report by ID or UUID.':tyIdsHandlesScalarFilters(): void{...}tyIdsPassesNonZeroSequenceNumberToDisableFirstRequestDefaults__constructCadonly LoggerInterface $logger,adonly BusDispatcher $dispatcher,adonly AutomatedReportsRepository $reportRepository224225 ₽L40eSavedSearch([]):229230eMock( originalClassName: FilterDefinitionCollection::class);construct();chodl constraint: 'gecArrayrilterkeys )->wLLcreturnuLJ:234255console commandpects ($this->once())tOnDemandPageFilterSet')function (Criteria $criteria) use ($filterSet, &$capturedCrith handle(): intjer->info(self::LOG_PREFIX . ' Started'):bon::now();= snow->1SMondayO;Vutmonun = show-sdav szsiuith = Snow->month:237242243244245246247248— 247200>method( constraint: 'onDemandSearchIdsOnly') ->willReturn([]);istraint: 'info');tyIdsForSavedSearch($savedSearch, $user);reourrera-nsrurstre.uesto.252 8Support Daily - in 2h 41mAskJiminnyReportActivityServiceT…Defaults100% C2Tue 14 Apr 12:19:47CascadeFixing ReportControllerAutomated Report MarFixing Ask Jiminny Rep+D ...Explain it to me again.. Why is there issue with thhat? Where is it expected and why do I need to work with that. How is it used [EMAIL] vasee oll saveuoedichl. Une los I on celllane ane ii.OnSkJLLmynedOT ACLeVeLyDetVacerpnorL44-00 snoule De salllewLet me read the OnDemandV2Controller to understand how it builds criteria there:Read OnDemanavzcoiNow look at the key difference. The controller's getContextForAskAnythingByFilter at OnDemandV2Controller.php: 90-93:0 phpVO Repository OnDemandActivitySearch\Criteria:: createFromRequest(arrav meroelsreques→>aluo.' Um1t =>"ropcount, pade$user->getTimezone()→ 11),It passes Srequest->all() - which includes sequence_number from the URL (e.g. sequence_number=4 from your staging URL). So when a user has beenpaginating on the frontend, sequence_number is naturally non-zero.The full explanationyou didn't ask for them:hsiauist kecuestaouncskenererurns true wnen seauenceNumber === u wnenttsine "trstreduestneseumolci detauirs kickinauromaricalveventFiterDefault on first requestEffectActiv1tvburat zonkangelmin_duration = 1 minDroos 0-secono activitiesActivityRecordedonly_recorded = 1Recorded activities onlvOrganiserGroupInUser's own groupRestricts to user's groupFrontend hits /api/v1/page/on-demand?topic id(]=...&sequence number=4 → sequence number=4 → isFirstRequest = false → no implicit defaults →returns 15 activities.AskJiminnyReportActivitySeervice (before the fix) built params from the saved search filters but never included sequence number → defaulted to 0 → isFirstRequest() = true → implicit defaults applied → 0 activities returned because the topic filter + recorded-onlv + duration>1 together matchednothing.Why sequence_number=1 is the right fixThe service is doing a deliberate, one-shot search - not a paginated session. It should never apply first-request defaults, because:1. The saved search already encodes the user's intent (those filters were chosen explicitly)2. Date filters are already intentionally stripped (that's existing logic in DATE_FILTER_KEYS )3. Adding implicit min_duration, only_recorded, and group scope on top would contradict what the saved search representsSetting sequence number=1 is the minimal, correct signal: "this is not a fresh session open, don't apply page-load defaults". The criteria is otherwise builtidentically to how the controller builds it - same Criteria:: createFromRequest, same get0nDemandPageFilterSet, same onDemandSearchIds0nly - so theresults will now match.Ö ul ..Ask anything (2*L)+ <> CodeClaude Sonnet 4.6winasun leUTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
11206
|