|
12554
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 36 mA100% CTue 14 Apr 14:24:35•ec2-user@ip-10-30-93-249:~L₴81DOCKER0 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12554
|
|
12555
|
PhpStormFileFditViewNavigateCodeLaravelPetactonToo PhpStormFileFditViewNavigateCodeLaravelPetactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny ~Project v(C) BaseController.php(C) CalendarController.p© ReportController.phpSoftphoneWebhookCC AbstractController.phpCommentContextinterfac Conterencesoot noureg controller.phpC) ExportController.phprrontenacontroller.phpT) FrontendControllerTraitC GeocodingController.ph(©) HealthCheckController.C LiveCoachController.phi(©) MissingTeamController.(©) MobileController.php©) NotificationController.pl© NotificationProviderconC PlavbackController.phpC PlavlistController.phpPusnercontroller.php(C SlackController.pnp(C SupportController.php(©) TeamSetupController.pl(C) UserAutomatedReportsC WelcomeController.php>_ Middleware> D Requests›_ Resources_Responses> MSerializers> M TransformersC Kernel.phpT, PlavlistTrackResourceTraitT ValidateCrmConnectionRec› _ IntegrationsInteractionslllohs_ Activity• AlAutomationD AjReports> MAudiov M AutomatedReportsc recuestoenerreask.in(c reuestcenertereoone senareoonJoo.ono(©) SendReportMailJob.php• CalendarD Crm_ DealRisksMailbox_ MeetingBot→ Micclleware_ Streaming>MTeam> M Telephonv> D UserC BaseProcessingJob.phpc) DummyJob.php© ReportController.php XAutomaleakeporscommana.ongC AutomatedReportsSendCommand.php©) AddLayoutEntities.php(C) Team.phpC AutomatedReportsRepository.phpAulomaleakeporisservice.onp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php) CreateActivityLoggedevent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.php(C) Automateakeportonpclass ReportController extends AbstractControllerpublic function ready Request Srequest): JsonResponse100110410310410510610710810911011211511151161171181191201211122110 51112411251261127128112913013113211541115%'child_uuld' => sreportPodcast?->getuu1d),1):if (! $this->callbackService->isSuccess($payload)) ‹$this->logger->warning(self::LOG_PREFIX . ' Error creating report', $payload):return responseO->ison(l'status' => 'ok'):/ If one-off, send the report immediately, lf not leave 1t for the scheduler (automated-reports:send)if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {send the primary reportstnas->a15patcher-saaspagen tnew sendreportuoblereportuusad)i1/ send the podcast report it it set and generacedif SreportPodcast && SreportPodcast->getStatusO === AutomatedReportResult::STATUS GENERATED) «Sthis->dispatcher->dispatchnew SendReportJobCreportUuid: SreportPodcast->getU[URL_WITH_CREDENTIALS] HS_local fiminny@localhost)Tx: Auto vPlayground vU.ellan teSa.xt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t l..n<->1: on t.1d = u.team_1dWHERE U.team_1d = 1 and sa.provider = 'salesforce':select * trom teams where 10 = 1;select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1;select * tron crouos wnere 1o = 505.select * troiplaybooks wnere team_1d = 1;select x ToIoavoooks Vnere 10 =1o.seLect x TrOlpLaydook cacecorles where playbook 10 = 1/51select * from users where team id = 1:select * from users where id = 7160:select * from crm_profiles where user_id = 7160;select * from features:select# 1a, uuid, type, provider, playbook_category_1a, user_1a, Lead_1a, contact_ia, account_ia, opportunity_1a, stage_1a,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm provider id IS NOT NULLIand provider l= 'uploader' and actual start time IS NOT NULUORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzo7MACselect p.1d, p.activity_type, pc.1d, pc.nameFROM playbooks pJo1n playbook_categories pc 1<->l.n: on p.1d = pc.playbook_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm fields WHERE crm configuration id = 1 and obiect tvpe = 'event'•SELECT * FROM crm field values WHERE crm field id = 4:select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm confiquration id = 1 and pl.playbook id = 175;select * from teams;SELECT r.* FROM automated_reports rjoln teams t on r.team 1d = t.1dWHERE r.frequency = 'daily"and r.Stauus = 1AND t.status = 'active'AND (r.expires at >= now) OR r.expires at IS NULL):select * from automated_report_results where report id IN (18, 33);select * from activity searches where id = 10932:select * from activity search_filters where activity search_ id = 10932:select * from automated_reports order by 1d desc:select * from automated_report_results where report 1d IN (36)*569570select * trom acuivity_searcnes where 1d = 109521select * from activity_ search_ filters where activity search id = 10932:select * trom aucomaced_reports order dy 1d desc;select * fromautomated report results where report id IN (36):W Windsurf Teams112:40UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
12555
|
|
12557
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol= Support Daily • in 36 mA100% CTue 14 Apr 14:24:47•ec2-user@ip-10-30-93-249:~L₴81DOCKERC *1DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce..88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"'}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12557
|
|
12558
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 36 mA100% CTue 14 Apr 14:24:53ec2-user@ip-10-30-93-249:~L₴81DOCKER© 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce...*8[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12558
|
|
12560
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol= Support Daily • in 36 mA100% CTue 14 Apr 14:24:56•ec2-user@ip-10-30-93-249:~L₴81DOCKER0 *1DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce... →88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily", "type": "ask_jiminny"} {"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12560
|
|
12561
|
PhpStormFileFditViewNavigateCodeLaravelRetactonToo PhpStormFileFditViewNavigateCodeLaravelRetactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-liminny ~Project v(C) BaseController.php(C) CalendarController.pSoftphoneWebhookCC AbstractController.phpCommentContextinterfac Conterencesoot noureg controller.phpC ExportController.phprrontenacontroller.phpT) FrontendControllerTraitC GeocodingController.ph(©) HealthCheckController.(C LiveCoachController.phi(©) MissingTeamController.(©) MobileController.php©) NotificationController.pl© NotificationProviderconC PlavbackController.phpC PlavlistController.phpPusnercontroller.php(C SlackController.pnp(C SupportController.php(©) TeamSetupController.pl(C) UserAutomatedReportsC WelcomeController.php>_ Middleware> D Requests›_ Resources_Responses> MSerializers> M TransformersC Kernel.phpT, PlavlistTrackResourceTraitT ValidateCrmConnectionRec› _ IntegrationsInteractionsJ Jobs_ ActivityA AutomationC AjReports> M Audiov M AutomatedReportsc recuestceneareask.in(c reuestcenertereoon(©) SendReportJob.php(©) SendReportMailJob.php• CalendarD Crm_ DealRisksMailbox_ MeetingBotMidd leware_ Streaming>MTeam> M Telephonv> D UserC BaseProcessingJob.phpc) DummyJob.php© ReportController.php XAutomaleakeporscommana.ongC AutomatedReportsSendCommand.php©) AddLayoutEntities.php(©) Team.phpC AutomatedReportsRepository.phpAulomaleakeporisservice.onp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© CreateActivityLoggedevent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.php(C) Automateakeportonpclass ReportController extends AbstractControllerpublic function ready Request Srequest): JsonResponse991001031104105106107108109111113114115116117118119120121112511124112011L/128'denerared at"1):// if a podcast is set, update itSreportPodcast?->updatedf"Suacus → schis->calloackservice-›getroacascoracussoay loaa)''response' => Spayload.'generated at' => Snow.I);$this->logger->info(self::LOG_PREFIX . ' Report has been processed', ['UUld' => $reportuuid,'child_uuid' => $reportPodcast?->getUuid(),1);if @ Sthis->callbackService->isSuccess(Spavload))<$this->logger->warning(self::LOG_PREFIX . ' Error creating report', $payload):return responseO->ison(l'status' => 'ok'):// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:send)1f (sreport->getReporto->getFrequency === AutomatedReportsservice::FREQUENCY_ONE_OFF)%1/ send the primary reporuSthis->dispatcher->dispatchnew SendReportJob(Sreportuu1d))hsend the podcast report ifit set and generatedif (SreportPodcast && $reportPodcast->getStatus( === AutomatedReportResult::STATUS_GENERATED) *Sthis->dispatcher->dispatch(new SendReportJob(reportUuid: SreportPodcast->qetUuidO:// Track Datadog metrics for automated reportssautomatedRenort = srenort->detrenodo.sth1s->callbackservice->pushlobatadog(sautomatedReport, sreport):if (SreportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast);sthis->eventDispatcher->dispatch.new AutomatedReportGeneratedSautomatedReport, $reporto:catch (ModelNotFoundException Sexception <sthis->loqger->error(self::L06_PREFIX .Report not found','uuld' = sreportuuld'error' => sexception->getMessageo,return responsel)->ysonul'stacus → "error,messade' so 'reoort nor tound", starus: 4044} catch (Throwable $exception) 1$this->logger->error(self::LOG_PREFIX . ' Failed to update report status', ['uuid' => SreportUuid.''error' => Sexception->qetMessage0.1):netunn racnonsele>contctatus' => 'ennon'"mASSANA => "FATleN tA undaTe nenont Status'lSupport Daily • in 36 m100% |45]Tue 14 Apr 14:24:56AutomatedReportsCommandTestv& console PROD& console (EU]L console [STAGING XSo jiminny v:16 14 V.13= custom.log= aravel.loe510519|5205215225235265285305315345395565385571540541542543544545546—541548154955055100455455555655755855915605611D045635641000566567568 VL SF (iminny@localhostc HS_local fiminny@localhost)Tx: Auto vPlayground vU,ellant.Sa.xt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t l..n<->1: on t.1d = u.team_1dWHERE U.team_1d = 1 and sa.provider = 'salesforce':select * trom teams where 10 = 1;select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1;select * tron crouos wnere 1o = 505.select * troiplaybooks wnere team_1d = 1;select x Trol•avoooks Vnere 10 =1o.seLect x TrompLaydook cacecorles where playbook 10 = 1/51select * from users where team id = 1:select * from users where id = 7160:select * from crm_profiles where user_id = 7160;select * from features:select# 1a, uuid, type, provider, playbook_category_1d, user_1a, Lead_1a, contact_ia, account_ia, opportunity_1a, stage_1a,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm provider id IS NOT NULLIand provider l= 'uploader' and actual start time IS NOT NULIORDER by id desc:select * from activities where id = 54747783; # 00U0400000pCzo7MACselect p.1d, p.activity_type, pc.1d, pc.nameFROM playbooks pJoln playbook_categories pc 1<->l.n: on p.1d = pc.playbook_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm fields WHERE crm configuration id = 1 and obiect tvpe = 'event'•SELECT * FROM crm field values WHERE crm field id = 4:select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm confiquration id = 1 and pl.playbook id = 175;select * from teams;SELECT r.* FROM automated_reports rjoln teams t on r.team 1d = t.1dWHERE r.frequency = 'daily"and r.Stauus = 1AND t.status = 'active'AND (r.expires at >= now OR r.expires at IS NULL):select * from automated_report_results where report id IN (18, 33);select * from activity_searches where id = 10932;select * from activity search_ filters where activity search_id = 10932:select * from automated_reports order by 1d desc:select * from automated_report_results where report 1d IN (36)*569select * trom acuivity_searcnes where 1d = 109521select * from activitv search filters where activity search id = 10932:select * trom aucomaced_reports order dy 1d desc;select * from automated report results where report id IN (36):W Windsurf Teamsg//sUTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
12561
|
|
12562
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol= Support Daily • in 36 mA100% CTue 14 Apr 14:24:58•ec2-user@ip-10-30-93-249:~181DOCKER© 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...-88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily", "type": "ask_jiminny"} {"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12562
|
|
12563
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol= Support Daily • in 35 mlA100% CTue 14 Apr 14:25:03•ec2-user@ip-10-30-93-249:~L881DOCKER0 *1DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily", "type": "ask_jiminny"} {"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12563
|
|
12564
|
PhpStormFileFV faVsco.js vViewNavigateCodeLaravelR PhpStormFileFV faVsco.js vViewNavigateCodeLaravelRefactorToolsWindow#11894 on JY-18909-automated-reports-ask-iminny ~HelpProject v© BaseController.php© CalendarController.p© ReportController.php© SoftphoneWebhookC© AbstractController.php• CommentContextlnterfa© ConferencesOptlnOutCr© Controller.phpExportController.phprrontenacontroller.phpT) FrontendControllerTrait© GeocodingController.ph© HealthCheckController.;LiveCoachController.phj© MissingTeamController.© MobileController.php© NotificationController.pt© NotificationProviderConPlaybackController.phpPlaylistController.phpc rusnercontoleroneSlackController.phpSupportController.php© TeamSetupController.pt© UserAutomatedReports© WelcomeController.php> C Middleware> D Requests> D Resources> D Responses> MSerializers> M TransformersC Kernel.php€ PlaylistTrackResourceTrait€ ValidateCrmConnectionRes> D IntegrationsD InteractionsO JobsD Activity( AiAutomationC AjReports> M Audiov M AutomatedReportsc recuestceneareask.in(c reuestcenertereoone senareoonJoo.ono© SendReportMailJob.phpD CalendarD CrmDealRisks• MailboxMeetingBotMid dlleware_ Streaming>MTeam> M Telephonv> D User© BaseProcessingJob.php© DummyJob.php© ReportController.php xAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpC AutomatedReportsRepository.phpAulomaleakeporisservice.onp© AddLayoutEntities.php© TrackProviderInstalledEvent.php© Team.php) CreateActivityLoggedEvent.php) ActivityLogged.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportsCallbackService.php© AutomatedReportResult.php© AutomatedReport.phpclass ReportController extends AbstractControllerpublic function ready(Request $request): JsonResponse'status' => $this->callbackService->getPrimaryStatus($report, $payload),''response' => Spayload.'generated_at' => $now,100101102103104105106107108109110111112113114115116118119120121122123124125126I);// if a podcast is set, update it$reportPodcast?->update(['status' = $this->callbackService->getPodcastStatus($payload),'response' = $payload,'generated_at'= $now,1):$this->logger->info(self::LOG_PREFIX . ' Report has been processed', ['uuid' => SreportUuid,'child_uvid' => $reportPodcast?->getUvid(),I);if (! $this->callbackService-›isSuccess($payload)) €$this->logger->warning(self::LOG_PREFIX' Error creating report', $payload);return response()->json(['status' →> 'ok']);// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:send)if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {// send the primary reportSthis-›dispatcher- dispatch Gaew SendReportJob (Sreportuuid));// send the podcast report if it set and generatedif (SreportPodcast && $reportPodcast->getStatus() === AutomatedReportResult: : STATUS_GENERATED) €Sthis->dispatcher->dispatch(new SendReportJob(reportUvid: $reportPodcast->getUvid()));// Track Datadog metrics for automated reportsSautomatedReport = Sreport->getReportO:$this->callbackService->pushToDatadog($automatedReport, $report);if ($reportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast):$this->eventDispatcher-›dispat|ch(new AutomatedReportGenerated($automatedReport, $report));} catch (ModelNotFoundException $exception) {$this->logger->error(self::LOG_PREFIX' Report not found', ["Uuo = Dredorcuurlor'error' => Sexception->getMessageO.I):return response()->json(['status' => 'error','message' => 'Report not found'], status: 404);} catch (Throwable $exception) {$this->logger-›error(self::LOG_PREFIX . ' Failed to update report status', ['uuid' = $reportUuid,'error' = $exception->getMessage(),ew pull request (55 minutes ago)Support Daily • in 35 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:25:03A HS_local [jiminny@localhost]A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logE laravel.log518519520521522523524525526527528524530531533534535536537538539540541542543544545546547548549550551004554556557558559560561D04563564-565566567568 v569570A SF [jiminny@localhost]Tx: Auto vPlaygroundvU,ellant.Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;select * fromplaybookswhere team_ld = 1;select x ToIoavoooks Vnere 10 =1o.seLect x TrOlpLaydook cacecorles wnere playbook 10 = 1/51select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<-›1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * fromautomated_report_results where report_id IN (36);W Windsurf Teams115:45UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12564
|
|
12565
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol= Support Daily • in 35 mlA100% CTue 14 Apr 14:25:05•ec2-user@ip-10-30-93-249:~L₴81DOCKER0 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily", "type": "ask_jiminny"} {"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12565
|
|
12566
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol= Support Daily • in 35 mlA100% CTue 14 Apr 14:25:14•ec2-user@ip-10-30-93-249:~181DOCKER0 881DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily", "type": "ask_jiminny"} {"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12566
|
|
12567
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProject v© BaseController.php© CalendarController.p© ReportController.php© SoftphoneWebhookC© AbstractController.php• CommentContextlnterfa© ConferencesOptlnOutCr© Controller.phpExportController.phprrontenacontroller.phpT) FrontendControllerTrait© GeocodingController.ph© HealthCheckController.;LiveCoachController.ph/© MissingTeamController.© MobileController.php© NotificationController.pt© NotificationProviderConPlaybackController.phpPlaylistController.phpc rusnercontoleroneSlackController.phpSupportController.php© TeamSetupController.pt© UserAutomatedReports© WelcomeController.php> C Middleware> D Requests> D Resources> D Responses> MSerializers> M Transformers© Kernel.php€ PlaylistTrackResourceTrait€ ValidateCrmConnectionRes> D IntegrationsD InteractionsO JobsD Activity(J AiAutomationC AjReports> MAudiov M AutomatedReportsc recuestceneareask.in(c reuestcenertereoone senareoonJoo.ono© SendReportMailJob.phpD CalendarD CrmDealRisks• MailboxMeetingBotMid dlleware_ Streaming>MTeam> M Telephonv> D User© BaseProcessingJob.php© DummyJob.php• AutomatedReportsCommand.php© ReportController.php xC AutomatedReportsRepository.phpAulomaleakeporisservice.onp© AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php© AddLayoutEntities.php© TrackProviderInstalledEvent.php) CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass ReportController extends AbstractControllerpublic function ready(Request $request): JsonResponse'status' => $this->callbackService->getPrimaryStatus($report, $payload),'response' => $payload,'generated_at' => $now,© Team.php100101102103104105106107108109110111112113114115116117118119120121122123124125126I);// if a podcast is set, update it$reportPodcast?->update(['status' = $this->callbackService->getPodcastStatus($payload),'response' = $payload,'generated_at'= $now,1):$this->logger->info(self::LOG_PREFIX . ' Report has been processed', ['uuid' => SreportUuid,'child_uvid' => $reportPodcast?->getUvid(),I);if (! $this->callbackService-›isSuccess($payload)) €$this->logger->warning(self::LOG_PREFIX' Error creating report', $payload);return response()->json(['status' →> 'ok']);// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:send)if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {send the primary reportSthis→>dispatcher→>dispatch(new SendReportJob(Srepggtuvid):|// send the podcast report if it set and generatedif (SreportPodcast && $reportPodcast->getStatus() === AutomatedReportResult: : STATUS_GENERATED) €Sthis->dispatcher->dispatch(new SendReportJob(reportUvid: $reportPodcast->getUvid()));// Track Datadog metrics for automated reportsSautomatedReport = Sreport->getReportO:$this->callbackService->pushToDatadog($automatedReport, $report);if ($reportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast):$this->eventDispatcher-›dispatch(new AutomatedReportGenerated($automatedReport, $report));} catch (ModelNotFoundException $exception) {$this->logger->error(self::LOG_PREFIX' Report not found', ["Uuo = Dredorcuurlor'error' => Sexception->getMessageO.I):return response()->json(['status' => 'error','message' => 'Report not found'], status: 404);} catch (Throwable $exception) {$this->logger-›error(self::LOG_PREFIX . ' Failed to update report status', ['uuid' = $reportUuid,'error' = $exception->getMessage(),I/ View pull request (56 minutes ago)Support Daily • in 35 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:25:14A HS_local [jiminny@localhost]A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logE laravel.log5185195205215225235245255265275285245305315335345355365375385571540541542543544545546547548549550551004553554556557558559560561D04563564- 565566567568 v569570A SF [jiminny@localhost]Tx: Auto vPlaygroundvU.ellan teSa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;select * fromplaybookswhere team_ld = 1;select x ToIoavoooks Vnere 10 =1o.seLect x TrOlpLaydook cacecorles wnere playbook 10 = 1/51select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<-›1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.teamaid = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * fromautomated_report_results where report_id IN (36);W Windsurf TeamsUTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12567
|
|
12569
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProject v© BaseController.php© CalendarController.p© ReportController.php© SoftphoneWebhookC© AbstractController.php• CommentContextlnterfa© ConferencesOptlnOutCr© Controller.phpExportController.phpC FrontendController.phpT) FrontendControllerTrait© GeocodingController.ph© HealthCheckController.;LiveCoachController.ph/© MissingTeamController.© MobileController.php© NotificationController.pt© NotificationProviderConPlaybackController.phpPlaylistController.phpc rusnercontoleroneSlackController.phpSupportController.php© TeamSetupController.pt© UserAutomatedReports© WelcomeController.php> C Middleware> D Requests> D Resources> D Responses> MSerializers> M Transformers© Kernel.php€ PlaylistTrackResourceTrait€ ValidateCrmConnectionRes> D IntegrationsD InteractionsO JobsD Activity( AiAutomationC AjReports> MAudiov M AutomatedReportsc recuestceneareask.in(c reuestcenertereoone senareoonJoo.ono© SendReportMailJob.phpD CalendarD Crm_ DealRisks• MailboxMeetingBotMiddlleware_ Streaming>MTeam> M Telephonv> D User© BaseProcessingJob.php© DummyJob.php© ReportController.php x• AutomatedReportsCommand.php© AutomatedReportsSendCommand.phpC AutomatedReportsRepository.phpAulomaleakeporisservice.onpc CrealenelaAcuiviyevent.ono© AddLayoutEntities.php© TrackProviderInstalledEvent.php© Team.php) CreateActivityLoggedEvent.php© ActivityLogged.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportsCallbackService.php© AutomatedReportResult.php© AutomatedReport.phpclass ReportController extends AbstractControllerpublic function ready(Request $request): JsonResponse'status' => $this->callbackService->getPrimaryStatus($report, $payload),'response' => $payload,'generated_at' => $now,99100101102103104105106107108109110111112113114115116117118119120121122123124125126I);// if a podcast is set, update it$reportPodcast?->update(['status' = $this->callbackService->getPodcastStatus($payload),'response' = $payload,'generated_at'= $now,1):$this->logger->info(self::LOG_PREFIX . ' Report has been processed', ['uuid' => SreportUuid,'child_uvid' => $reportPodcast?->getUvid(),I);if (! $this->callbackService-›isSuccess($payload)) €$this->logger->warning(self::LOG_PREFIX' Error creating report', $payload);return response()->json(['status' →> 'ok']);// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:send)if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {send the primary report$this->dispatcher->dispatch(new SendReportJob($reportUvid));// send the podcast report if it set and generatedif (SreportPodcast && $reportPodcast->getStatus() === AutomatedReportResult: : STATUS_GENERATED) €Sthis->dispatcher->dispatch(new SendReportJob(reportUvid: $reportPodcast->getUvid()));// Track Datadog metrics for automated reportsSautomatedReport = Sreport->getReportO:$this->callbackService->pushToDatadog($automatedReport, $report);if ($reportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast):$this->eventDispatcher-›dispatch(new AutomatedReportGenerated($automatedReport, $report));} catch (ModelNotFoundException $exception) {$this->logger->error(self::LOG_PREFIX' Report not found', ["Uuo = Dredorcuurlor'error' => Sexception->getMessageO.I):return response()->json(['status' => 'error','message' => 'Report not found'], status: 404);} catch (Throwable $exception) {$this->logger-›error(self::LOG_PREFIX . ' Failed to update report status', ['uuid' = $reportUuid,'error' = $exception->getMessage(),I/ View pull request (56 minutes ago)Support Daily • in 35 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:25:20A HS_local [jiminny@localhost]A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.log5185195205215225235245255265275285245305315335345355365375385571540541542543544545546547548549550551004553554555556557558559560561D04563564- 565566567568 v569570= laravel.logA SF [jiminny@localhost]Tx: Auto vPlaygroundvU,ellant.Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;select * fromplaybookswhere team_ld = 1select x ToIoavoooks Vnere 10 =1o.seLect x TrOlpLaydook cacecorles wnere playbook 10 = 1/51select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * fromautomated_report_results where report_id IN (36);W Windsurf Teams99:55UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12569
|
|
12570
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 35 mA100% CTue 14 Apr 14:25:21•ec2-user@ip-10-30-93-249:~L₴81DOCKER0 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...- *8[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12570
|
|
12571
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 35 mA100% CTue 14 Apr 14:25:24•ec2-user@ip-10-30-93-249:~L₴81DOCKER0 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce...÷ 88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12571
|
|
12572
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProject v© BaseController.php© CalendarController.p© ReportController.php© SoftphoneWebhookC© AbstractController.php• CommentContextlnterfa© ConferencesOptlnOutCr© Controller.phpExportController.phprrontenacontroller.phpT) FrontendControllerTrait© GeocodingController.ph© HealthCheckController.;LiveCoachController.ph/© MissingTeamController.© MobileController.php© NotificationController.pt© NotificationProviderConPlaybackController.phpPlaylistController.phpc rusnercontoleroneSlackController.phpSupportController.php© TeamSetupController.pt© UserAutomatedReports© WelcomeController.php> C Middleware> D Requests> D Resources> D Responses> MSerializers> M Transformers© Kernel.php€ PlaylistTrackResourceTrait€ ValidateCrmConnectionRes> D IntegrationsD InteractionsO JobsD Activity(J AiAutomationC AjReports> MAudiov M AutomatedReportsc recuestceneareask.in(c reuestcenertereoone senareoonJoo.ono© SendReportMailJob.phpD CalendarD CrmDealRisks• MailboxMeetingBotMid dlleware_ Streaming>MTeam> M Telephonv> D User© BaseProcessingJob.php© DummyJob.php• AutomatedReportsCommand.php© ReportController.php xC AutomatedReportsRepository.phpAulomaleakeporisservice.onp© AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php© AddLayoutEntities.php© TrackProviderInstalledEvent.php) CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass ReportController extends AbstractControllerpublic function ready(Request $request): JsonResponse'status' => $this->callbackService->getPrimaryStatus($report, $payload),'response' => $payload,'generated_at' => $now,© Team.php100101102103104105106107108109110111112113114115116117118119120121122123124125126I);// if a podcast is set, update it$reportPodcast?->update(['status' = $this->callbackService->getPodcastStatus($payload),'response' = $payload,'generated_at'= $now,1):$this->logger->info(self::LOG_PREFIX . ' Report has been processed', ['uuid' => SreportUuid,'child_uvid' => $reportPodcast?->getUvid(),I);if (! $this->callbackService-›isSuccess($payload)) €$this->logger->warning(self::LOG_PREFIX' Error creating report', $payload);return response()->json(['status' →> 'ok']);// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:send)if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {send the primary report$this->dispatcher->dispatch(new SendReportJob($reportUvid)):|// send the podcast report if it set and generatedif (SreportPodcast && $reportPodcast->getStatus() === AutomatedReportResult: : STATUS_GENERATED) €Sthis->dispatcher->dispatch(new SendReportJob(reportUvid: $reportPodcast->getUvid()));// Track Datadog metrics for automated reportsSautomatedReport = Sreport->getReportO:$this->callbackService->pushToDatadog($automatedReport, $report);if ($reportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast):$this->eventDispatcher-›dispatch(new AutomatedReportGenerated($automatedReport, $report));} catch (ModelNotFoundException $exception) {$this->logger->error(self::LOG_PREFIX' Report not found', ["Uuo = Dredorcuurlor'error' => Sexception->getMessageO.I):return response()->json(['status' => 'error','message' => 'Report not found'], status: 404);} catch (Throwable $exception) {$this->logger-›error(self::LOG_PREFIX . ' Failed to update report status', ['uuid' = $reportUuid,'error' = $exception->getMessage(),I/ View pull request (56 minutes ago)Support Daily • in 35 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:25:24A HS_local [jiminny@localhost]A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logE laravel.log5185195205215225235245255265275285245305315335345355365375385571540541542543544545546547548549550551004553554556557558559560561D04563564- 565566567568 v569570A SF [jiminny@localhost]Tx: Auto vPlaygroundvU.ellan teSa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;select * fromplaybookswhere team_ld = 1;select x ToIoavoooks Vnere 10 =1o.seLect x TrOlpLaydook cacecorles wnere playbook 10 = 1/51select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<-›1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.teamaid = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * fromautomated_report_results where report_id IN (36);W Windsurf TeamsUTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12572
|
|
12573
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 35 mA100% CTue 14 Apr 14:25:25•ec2-user@ip-10-30-93-249:~L₴81DOCKER0 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce...-*8[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12573
|
|
12575
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol= Support Daily • in 35 mlA100% CTue 14 Apr 14:25:28•ec2-user@ip-10-30-93-249:~L₴81DOCKER© *1DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily", "type": "ask_jiminny"} {"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12575
|
|
12576
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProject v© BaseController.php© CalendarController.p© ReportController.php© SoftphoneWebhookC© AbstractController.php• CommentContextlnterfa© ConferencesOptlnOutCr© Controller.phpExportController.phprrontenacontroller.phpT) FrontendControllerTraitC GeocodingController.ph© HealthCheckController.;LiveCoachController.ph/© MissingTeamController.© MobileController.php© NotificationController.pt© NotificationProviderConPlaybackController.phpPlaylistController.phpPusnercontroller.phpSlackController.phpSupportController.php© TeamSetupController.pt© UserAutomatedReports© WelcomeController.php> C Middleware> D Requests> D Resources> D Responses> MSerializers> M Transformers© Kernel.php€ PlaylistTrackResourceTrait€ ValidateCrmConnectionRes> D IntegrationsD InteractionsO JobsD ActivityA AutomationC AjReports> MAudiov M AutomatedReportsc recuestceneareask.in(c reuestcenertereoone senareoonJoo.ono© SendReportMailJob.phpD CalendarD CrmDealRisks• MailboxMeetingBotMiddlleware_ Streaming>MTeam> M Telephonv> D User© BaseProcessingJob.phpc) DummyJob.php© ReportController.php xAutomaleakeporscommana.ong© AutomatedReportsSendCommand.phpC AutomatedReportsRepository.phpAulomaleakeporisservice.onpCreateHeldActivityEvent.php© AddLayoutEntities.php© TrackProviderInstalledEvent.php) CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass ReportController extends AbstractControllerpublic function ready(Request $request): JsonResponse'status' => $this->callbackService->getPrimaryStatus($report, $payload),''response' => Spayload.'generated_at' => $now,© Team.php100101102103104105106108109110111112113114115116117118119120121122123124125126I);// if a podcast is set, update it$reportPodcast?->update(['status' = $this->callbackService->getPodcastStatus($payload),'response' = $payload,'generated_at'= $now,1):$this->logger->info(self::LOG_PREFIX . ' Report has been processed', ['uuid' => SreportUuid,'child_uvid' => $reportPodcast?->getUvid(),I);if (! $this->callbackService-›isSuccess($payload)) €$this->logger->warning(self::LOG_PREFIX' Error creating report', $payload);return response()->json(['status' →> 'ok']);// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:send)if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {// send the primary reportSthis→>dispatcher→>dispatch(new SendReportJob (Sreportuvid));// send the podcast report if it set and generatedif (SreportPodcast && $reportPodcast->getStatus() === AutomatedReportResult: : STATUS_GENERATED) €Sthis->dispatcher->dispatch(new SendReportJob(reportUvid: $reportPodcast->getUvid()));// Track Datadog metrics for automated reportsSautomatedReport = Sreport->getReportO:$this->callbackService->pushToDatadog($automatedReport, $report);if ($reportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast):$this->eventDispatcher-›dispatch(new AutomatedReportGenerated($automatedReport, $report));} catch (ModelNotFoundException $exception) €$this->logger->error(self::LOG_PREFIX' Report not found', ["Uuo = Dredorcuurlor'error' => Sexception->getMessageO.I):return response()->json(['status' => 'error','message' => 'Report not found'], status: 404);} catch (Throwable $exception) {$this->logger-›error(self::LOG_PREFIX . ' Failed to update report status', ['uuid' = $reportUuid,'error' = $exception->getMessage(),I/ View pull request (56 minutes ago)Support Daily • in 35 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:25:29A HS_local [jiminny@localhost]A console [PROD]A console (EU]Al console [STAGING] XGajiminny:16 14 V.13= custom.log5185195205215225235245255265275285245305315335345355365375385571540541542543544545546547548549550551004554555556557558559560561D04563564-565566567568 v569570= laravel.logA SF [jiminny@localhost]Tx: Auto vPlaygroundvU,ellant.Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;select * fromplaybookswhere team_ld = 1select x ToIoavoooks Vnere 10 =1o.seLect x TrOlpLaydook cacecorles wnere playbook 10 = 1/51select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * fromautomated_report_results where report_id IN (36);W Windsurf Teams99:58UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12576
|
|
12578
|
iTerm2Shell|EditViewSessionScriptsProfilesWindowHe iTerm2Shell|EditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 35 mA100% CTue 14 Apr 14:25:58ec2-user@ip-10-30-93-249:~181DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...-88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12578
|
|
12579
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProject v© BaseController.php© CalendarController.p© ReportController.php© SoftphoneWebhookC© AbstractController.php• CommentContextlnterfa© ConferencesOptlnOutCi© Controller.phpExportController.phprrontenacontroller.phpT) FrontendControllerTraitC GeocodingController.ph© HealthCheckController.;LiveCoachController.ph/© MissingTeamController.© MobileController.php© NotificationController.pt© NotificationProviderConPlaybackController.phpPlaylistController.phpPusnercontroller.phpSlackController.phpSupportController.php© TeamSetupController.pt© UserAutomatedReports© WelcomeController.php> C Middleware> D Requests> D Resources> D Responses> MSerializers> M TransformersC Kernel.php€ PlaylistTrackResourceTrait€ ValidateCrmConnectionRes> D IntegrationsD InteractionsO JobsD ActivityA AutomationC AjReports> MAudiov M AutomatedReportsc recuestoenerreask.in(c reuestcenertereoone senareoonJoo.ono© SendReportMailJob.phpD CalendarD CrmDealRisks• MailboxMeetingBotMiddlleware_ Streaming>MTeam> M Telephonv> D User© BaseProcessingJob.phpc) DummyJob.php• AutomatedReportsCommand.php© ReportController.php xC AutomatedReportsRepository.phpAulomaleakeporisservice.onp© AutomatedReportsSendCommand.phpCreateHeldActivityEvent.php© AddLayoutEntities.php© TrackProviderInstalledEvent.php) CreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass ReportController extends AbstractControllerpublic function ready(Request $request): JsonResponse'status' => $this->callbackService->getPrimaryStatus($report, $payload),''response' => Spayload.'generated_at' => $now,© Team.php99100101102103104105106108109110111112113114115116117118120121122123124125126I);// if a podcast is set, update it$reportPodcast?->update(['status' = $this->callbackService->getPodcastStatus($payload),'response' = $payload,'generated_at'= $now,1):$this->logger->info(self::LOG_PREFIX . ' Report has been processed', ['uuid' => SreportUuid,'child_uvid' => $reportPodcast?->getUvid(),I);if (! $this->callbackService-›isSuccess($payload)) €$this->logger->warning(self::LOG_PREFIX'Error creating report', $payload);return response()->json(['status' →> 'ok']);// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:send)if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {send the primary reportSthis- dispatcher- dispatch (new SendRegertJob (Sreportuuid));// send the podcast report if it set and generatedif (SreportPodcast && $reportPodcast->getStatus() === AutomatedReportResult: : STATUS_GENERATED) €Sthis->dispatcher->dispatch(new SendReportJob(reportUvid: $reportPodcast->getUvid()));// Track Datadog metrics for automated reportsSautomatedReport = Sreport->getReportO:$this->callbackService->pushToDatadog($automatedReport, $report);if ($reportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast):$this->eventDispatcher-›dispatch(new AutomatedReportGenerated($automatedReport, $report));} catch (ModelNotFoundException $exception) {$this->logger->error(self::LOG_PREFIX' Report not found', ["Uuo = Dredorcuurlor'error' => Sexception->getMessageO.I):return response()->json(['status' => 'error','message' => 'Report not found'], status: 404);} catch (Throwable $exception) {$this->logger-›error(self::LOG_PREFIX . ' Failed to update report status', ['uuid' = $reportUuid,'error' = $exception->getMessage(),I/ View pull request (56 minutes ago)Support Daily - in 35mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:25:57A HS_local [jiminny@localhost]A console [PROD]A console (EU]Al console [STAGING] XGajiminny:16 14 V.13= custom.log5185195205215225235245255265275285245305315335345355365375385571540541542543544545546547548549550551004554555556557558559560561D04563564= laravel.logA SF [jiminny@localhost]Tx: Auto vPlaygroundvU,ellant.Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;select * fromplaybookswhere team_ld = 1select x ToIoavoooks Vnere 10 =1o.seLect x TrOlpLaydook cacecorles wnere playbook 10 = 1/51select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);566567568 v569570select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * fromautomated_report_results where report_id IN (36);W Windsurf Teams99:58UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12579
|
|
12580
|
iTerm2Shell|EditViewSessionScriptsProfilesWindowHe iTerm2Shell|EditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 35 mA100% CTue 14 Apr 14:26:00ec2-user@ip-10-30-93-249:~L₴81DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12580
|
|
12581
|
iTerm2Shell|EditViewSessionScriptsProfilesWindowHe iTerm2Shell|EditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:04ec2-user@ip-10-30-93-249:~L₴81DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12581
|
|
12582
|
PhpStormFileFditViewNavigateCodelaraveRefactonTool PhpStormFileFditViewNavigateCodelaraveRefactonToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~Project v(©) ReportController.phpC SendReportJob.php X(©) AutomatedReportsCommand.phpcAutomatedRenorssenocommana.onAddLayoutEntities.php(C) BaseController.phpC Team.phpC AutomatedReportsRepository.phpC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php(C) CalendarController.p© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C ReportController.phpSoftphoneWebhookC(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.phpC Automatedkeport.onpC AbstractController.phpclass SendReportJob implements ShouldQueue, ShouldBeUnique1 Commentconteyfintenac Conterencesoot noureg controller.phpC) ExportController.phpC FrontendController.phpT) FrontendControllerTraitC GeocodingController.ph(©) HealthCheckController.C LiveCoachController.phi(©) MissingTeamController.(©) MobileController.php©) NotificationController.pl© NotificationProviderconC PlavbackController.phpC PlavlistController.phpc rusnercontolerone(C) SlackController.ohp(C SupportController.php(©) TeamSetupController.pl(C) UserAutomatedReportsC WelcomeController.php>_ Middleware> D Requests›_ Resources>_Responses> MSerializers> M TransformersC Kernel.phpT, PlavlistTrackResourceTraitT ValidateCrmConnectionRe› _ IntegrationsInteractionsJ Jobs>D Activity> M AiAutomationCJ AjReports> MAudiov M AutomatedReportsc recuestcenerareask.in(c reuestcenertereoone senareoonJoo.ono(©) SendReportMailJob.php164Calendar165D Crm166l Dea RicksMailbox11081_ MeetingBot111621• MiddllewareStreaming>MTeam1175> M Telephonv> D UselC BaseProcessingJob.phpc) DummyJob.phpuse usparchaole.use Irerac smcnuveueruse uueveable/*** Log prefix for all loq messageso usagesprivate const string LOG_PREFIX = '[Send ReportJ':* Ine number of times the joo may be actempred.* @var intpublic int Stries = 2:/*** The maximum number of seconds the job should be allowed to run.* avar 1nupuouc inr saneour = 120* Create a new job instance.* dparam string SreportUuid The UUID of the report to sendpublic function L_construct(private readonly string sreportuu1d)puhis->onquevel queue: constants::QUEUE_ANALYIICS_LUW):public function handledLoggerincerrace ologger,JobDispatcherInterface S7obDispatcher.AutomatedReportsService sautomatedReportsService): void m* Get a unique Ib for the job.* dreturh suringououc runcmon un oueron, sumnos...n44 M1 ASupport Daily • in 34 m100% |45]Tue 14 Apr 14:26:04AutomatedReportsCommandTestv& console PROD& console (EU]L console [STAGING XSo jiminny v916 A14 V 13= custom.log= aravel.loeL SF (iminny@localhostc HS_local fiminny@localhost)510-51952152257315265220050558557154054154254355055115045535545585595605611D04563564565566567568 VTx: Auto vPlayground vu.email.Sa.xt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t l..n<->1: on t.1d = u.team_1dWHERE U.team_1d = 1 and sa.provider = 'salesforce':select * trom teams where 10 = 1;select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1;select * tron crouos wnere 1o = 505.seLect * trom playbooks where ceam_1d = 1:select x t'oi oavoooks Vnere 10 =1o.select x Tron playbook cacecorles where playbook 10 = 1/5.select * from users where team id = 1:select * from users where id = 7160:select * from crm_profiles where user_id = 7160;select * from features:select# 1a, uuid, type, provider, playbook_category_1a, user_1a, Lead_1a, contact_ia, account_ia, opportunity_1a, stage_1a,# crm_contiguration_1d, crm_provider_1d, cranscripcion_1a, suatusfrom activities where crm confiquration id = 1 and tvoe = 'conference'# and crm provider id IS NOT NULLIand provider l= 'uploader'and actual start time IS NOT NULIORDER by id desc:select * from activities where 1d = 54747783: # 00U0400000pCzo7MACselect p.1d, p.activity_type, pc.1d, pc.nameFROM playbooks pJoln playbook_categories pc 1<->l.n: on p.1d = pc.playbook_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm field values WHERE crm field id = 4:select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm confiquration id = 1 and pl.playbook id = 175:select * from teams;SELECT r.* FROM automated_reports rjoln teams t on r.team 1d = t.1dWHERE r.frequency = 'daily"and r.Stauus = 1AND t.status = 'active'AND (r.expires at >= now) OR r.expires at IS NULL):select * from automated_report_results where report id IN (18, 33);select * from activity searches where id = 10932:select * from activity search_filters where activity search_ id = 10932:select * from automated_reports order by 1d desc:select * from automated_report_results where report 1d IN (36)*569576select * trom acuivity_searcnes where 1d = 109521select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where report_id IN (36);winasun leams512UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
12582
|
|
12583
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:09ec2-user@ip-10-30-93-249:~L₴81DOCKER- 281DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce...- *8[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]9-b635-2aa52627f c27"}Found 1 daily reports to process{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12583
|
|
12584
|
PhpStormFileFditViewNavigateCodelaravelRefactonToo PhpStormFileFditViewNavigateCodelaravelRefactonToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~Project vc) RenortController.ongysenakeporsoo.onp x(©) AutomatedReportsCommand.php© AutomatedRep|ytsSendCommand.php >AddLayoutEntities.php(C) BaseController.phpC Team.phpC AutomatedReportsRepository.phpC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php(C) CalendarController.p© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C ReportController.phpSoftphoneWebhookC(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.php(C) Automateakeport.onpC AbstractController.phpclass SendReportJob implements ShouldQueue, ShouldBeUnique44 M1 A1 Commentconteyfintenac Conterencesoot noureg controller.phpC) ExportController.phprrontenacontroller.phpT) FrontendControllerTraitC GeocodingController.ph(©) HealthCheckController.C LiveCoachController.ph(©) MissingTeamController.(©) MobileController.php©) NotificationController.pl© NotificationProviderconC PlavbackController.phpC PlavlistController.phpPusnercontroller.php(C) SlackController.ohp(C SupportController.php(©) TeamSetupController.pl(C) UserAutomatedReportsC WelcomeController.php>_ Middleware> D Requests›_ Resources>_Responses> MSerializers> M TransformersC Kernel.phpT, PlavlistTrackResourceTraitT ValidateCrmConnectionRec› _ IntegrationsInteractions→ Jobs_ ActivityA AutomationD AjReports> MAudiov M AutomatedReportsc recuestceneareask.in(c reuestcenertereoone senareoonJoo.ono(©) SendReportMailJob.php• CalendarD Crm_ DealRisks| Mailbox_ MeetingBotMiddlleware_ Streaming> MTeamM Telephonv> D UserC BaseProcessingJob.phpc) DummyJob.phpprivate const string LOG_PREFIX = '[Send Reportl';* Ine number of times the joo may be actempred.*ovar Inupublic int Stries = 2* The maximum number of seconds the job should be allowed to run* avar int*/muo uent saneour =10* Create a new iob instance.* @param string $reportUuid The UUID of the report to sendpublic function -_construct(private readonly string $reportUuid)sthis->onQueuel queue: Constants::QUEUE_ANALYTICS_LOW)*ouo uc tuncton nandueuiLoggerintertace slogger,Jobuispaccherincertace +Jobuispaccher,Auronareoreoor soeruce naurolateoredortsoervceD: void Hlltry "$report = $automatedReportsService->getReportResult(Sthis->reportUuid:scatch (Throwable se)sLogger->error(self::LOG_PREFIX.Error getting report result', [= sthis->reportuuid,"excepcion" = se-›gecMessage).uanow фe,$Loqger->info(self::LOG_PREFIX.Processing report', l'uuid' => sthis->reportUuid,'status" => Sreport->getStatusLabelo,I);$s3Path = sautomatedReportsservice->getMediaPath(sreport):// verity the tile exisus in ssif « Storage::diskd name: 'client-data-cloud')->exists($s3Path) <$logger->error(self::LOG_PREFIX . ' Report file not found in S3', [→ sunls->repor cuura,Support Daily • in 34 m100%Tue 14 Apr 14:26:09AutomatedReportsCommandTestv& console PROD& console (EU]L console [STAGING XSo jiminny v:16 14 V.13= custom.log= aravel.loeL SF (iminny@localhostc HS_local fiminny@localhost)510519|52152252352452652205285305335385571540541542543544— 543546547548-556551553554556558559560561562563564565566567568 V569570Tx: Auto vPlayground vu.email.Sa.xt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t l..n<->1: on t.1d = u.team_1dWHERE U.team_1d = 1 and sa.provider = 'salesforce':select * trom teams where 10 = 1;select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1;select * tron crouos wnere 1o = 505.seLect * trom playbooks where ceam_1d = 1:select x troi oavoooks Vnere 1o =1o.select x Tron playbook cacecorles where playbook 10 = 1/5.select * from users where team id = 1:select * from users where id = 7160:select * from crm_profiles where user_id = 7160;select * from features:select# 1a, uuid, type, provider, playbook_category_1a, user_1a, Lead_1a, contact_ia, account_ia, opportunity_1a, stage_1a,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm configuration id = 1 and tvoe = 'conference'# and crm provider id IS NOT NULLIand provider l= 'uploader'and actual start time IS NOT NULIORDER by id desc:select * from activities where id = 54747783; # 00U0400000pCzo7MACselect p.1d, p.activity_type, pc.1d, pc.nameFROM playbooks pJoln playbook_categories pc 1<->l.n: on p.1d = pc.playbook_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm fields WHERE crm configuration id = 1 and obiect tvpe = 'event'•SELECT * FROM crm field values WHERE crm field id = 4:select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm confiquration id = 1 and pl.playbook id = 175;select * from teams;SELECT r.* FROM automated_reports rjoln teams t on r.team 1d = t.1dWHERE r.frequency = 'daily"and r.stauus = 1AND t.status = 'active'AND (r.expires at >= now) OR r.expires at IS NULL):select * from automated_report_results where report id IN (18, 33);select * from activity searches where id = 10932:select * from activity search_ filters where activity search_id = 10932:select * from automated_reports order by 1d desc:select * from automated_report_results where report 1d IN (36)*select * trom acuivity_searcnes where 1d = 109521select * trom activity_search_filters where activity search_id = 10932:select * from automated_reports order by id desc;select * fromautomated report results where report id IN (36):W Windsurf Teams60:14UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
12584
|
|
12585
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:12ec2-user@ip-10-30-93-249:~L₴81DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]9-b635-2aa52627f c27"}Found 1 daily reports to process{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12585
|
|
12586
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:14ec2-user@ip-10-30-93-249:~L₴81DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]9-b635-2aa52627f c27"}Found 1 daily reports to process{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12586
|
|
12587
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~HelpProject v© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeamsD TracksD TranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DeleredoAcimnorescc Deleressterovescom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebho© GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p© JiminnyCacheClearCom©JiminnyDebugCommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLivecoaching© Managescim-orleam.p(c мalkoanchrorenvironi© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComiC)RecalculateDealRiskscd© RemoveDeleteMarkersC© RemoveExpiredNudgesi© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.php© AutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAddLayoutEntities.php• Team.php© AutomatedReportsRepository.phpAutomatedReportsService.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command1925 GT303132 Gt35 C476566Pusnea 1 commit to oricin/Jy-loy0g-automared-repors-ask* The name and sianature of the console command.* Ovar stringprotected $signature = 'automated-reports:send';/*** The console command description.* @var stringororecreo moescrprion = senos curoliared reoors paseo on user mlezone".public function __construct(private readonly LoggerInterface $logger,private readonly AutomatedReportsRepository $reportRepository,private readonly AutomatedReportsService $automatedReportsService,private readonly BusDispatcher $dispatcher,parent::__construct();/*** Execute the console command.* Oreturn int*/public function handle(): intsreportresults = $this->reportRepository->getGeneratedNotsentresults:foreach ($reportResults as $reportResult) {/** Ovar AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->getReport());if ($this->automatedReportsService->shouldSendReport(SvalidRecipients, $reportResult->getGeneratedAt())) €sunls->loccer->lnto selt..Luo racrLxuispacchine ob,'uuid' => SreportResult->getUuid(),1):$this->dispatcher->dispatch(new SenoeportJob($reportResult->getUvid()));return connondacos. sucueosnj Support Daily • in 34 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:26:14A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logE laravel.logA HS_local [jiminny@localhost]510519-52052152252352452552652205285305355365375385571540541542543545546541548549550551004553554558559560561562563564565566567568 v569570A SF [jiminny@localhost]Tx: Auto vPlaygroundvu.email,Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;seLect * trom playbooks where ceam_1d = 1:select x troi oavoooks Vnere 1o =1o.select x Tron playbook cacecorles where playbook 10 = 1/5.select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCzojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where report_id IN (36);w Winasurt leams61:03UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12587
|
|
12589
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~HelpProject v© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeamsD TracksTranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DeleredoAcimnorescc Deleress eroverscom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebho© GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p© JiminnyCacheClearCom© JiminnyDebugCommanc© JiminnySetEncryptedTo(cJminnv okenintocomm© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComiC)RecalculateDealRiskscd(C) RemoveDe leteMarkersa© RemoveExpiredNudgesi© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAddLayoutEntities.php• Team.php© AutomatedReportsRepository.phpAutomatedReportsService.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command1925 GT303132 Gt35 C384147586566* The name and sianature of the console command.* Ovar stringprotected $signature = 'automated-reports:send';/*** The console command description.* @var stringororecreo moescrprion = senos curoliared reoors paseo on user mlezone".public function __construct(private readonly LoggerInterface $logger,private readonly AutomatedReportsRepository $reportRepository,private readonly AutomatedReportsService $automatedReportsService,private readonly BusDispatcher $dispatcher,parent::__construct();/*** Execute the console command.* Oreturn int*/public function handle(): intsreportresults = $this->reportRepository->getGeneratedNotsentresults:foreach ($reportResults as $reportResult) {/** Ovar AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->getReport());if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getGeneratedAt())){$this->logger->info(self::LOG_PREFIXuispacchine ob,'uuid' => $reportResult->getUuid(),1):Ethis->dispatcher->dispatch(new SendReportJo6|С$reportResult->getUuid()));Cascade 2 XICommand Slreturn connondacos..succeoo.Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (57 minutes ago)j Support Daily • in 34 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:26:22A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logE laravel.logA HS_local [jiminny@localhost]510519-5205215225235245255265285305355365375385571540541542543545546541548549550551004553558559560561D04563564565566567568 vA SF [jiminny@localhost]Tx: Auto vPlayground vu.email,Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;seLect * trom playbooks where ceam_1d = 1:select x troi oavoooks Vnere 1o =1o.select x Tron playbook cacecorles where playbook 10 = 1/5.select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event' ;SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);570select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where report_id IN (36);w Winasurt leamsblb2 13 charsUTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12589
|
|
12591
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~HelpProject v© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeamsD TracksD TranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DeleredoAcimnorescc Deleressterovescom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebho© GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p© JiminnyCacheClearCom©JiminnyDebugCommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLivecoaching© Managescim-orleam.p(c мalkoanchrocnvironic Mureu canzercnanner© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComiC)RecalculateDealRiskscd© RemoveDeleteMarkersC© RemoveExpiredNudgesi© RemoveUnusedParticip:C ResetElasticSearch.pnp© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAddLayoutEntities.php• Team.php© AutomatedReportsRepository.phpAutomatedReportsService.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command1925 GT27 E303132 Gt35 C4765* The name and sianature of the console command.* Ovar stringprotected $signature = 'automated-reports:send';/*** The console command description.* @var stringororecreo moescrprion = senos curoliared reoors paseo on user mlezone".public function __construct(private readonly LoggerInterface $logger,private readonly AutomatedReportsRepository $reportRepository,private readonly AutomatedReportsService $automatedReportsService,private readonly BusDispatcher $dispatcher,parent::__construct();/*** Execute the console command.* Oreturn int*/public function handle(): int$reportResults = $this->reportRepository->getGeneratedNotSentResults();foreach ($reportResults as $reportResult) {/** Ovar AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->getReport());if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getGeneratedAt())){$this->logger->info(self::LOG_PREFIX . ' Dispatching job', ['uuid' => SreportResult->getUuid(),1):$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuidO)) :|ExtractSurround/Cascade 2 XICommand Slreturn connondacos..succeoo.Pusnea 1 commit to oricin/Jy-loy0g-automared-repors-ask-iminnyVij Support Daily • in 34 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:26:30A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logE laravel.logA HS_local [jiminny@localhost]510519-52052152252352452552652205285305355365375385571540541542543545546548549550551004553558559560561562563564565566567568 v569570A SF [jiminny@localhost]Tx: Auto vPlayground vu.email,Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;seLect * trom playbooks where ceam_1d = 1:select x troi oavoooks Vnere 1o =1o.select x Tron playbook cacecorles where playbook 10 = 1/5.select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm provider id IS NOT NULLIand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event' ;SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<-›1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where report_id IN (36);W Windsurf Teams61:90 (73 chars)UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12591
|
|
12592
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:33ec2-user@ip-10-30-93-249:~L₴81DOCKER₴81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...€ *8[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]Found 1 daily reports to process9-b635-2aa52627f c27"}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12592
|
|
12594
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:35ec2-user@ip-10-30-93-249:~L₴81DOCKER-281DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce... →[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]9-b635-2aa52627f c27"}Found 1 daily reports to process{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12594
|
|
12595
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~HelpProject v© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeamsD TracksTranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DeleredoAcimnorescc Deleress eroverscom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebhoGroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.f© JiminnyCacheClearCom© JiminnyDebugCommanc© JiminnySetEncryptedTo(cJminnv okenintocomm© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComiC)RecalculateDealRiskscd(C) RemoveDe leteMarkersa(c) Remove-XoiredNuddes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAddLayoutEntities.php• Team.php© AutomatedReportsRepository.phpAutomatedReportsService.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command1925 GT303132 Gt35 C47575865* The name and sianature of the console command.* Ovar stringprotected $signature = 'automated-reports:send';/*** The console command description.* @var stringororecreo moescrprion = senos curoliared reoors paseo on user mlezone".public function __construct(private readonly LoggerInterface $logger,private readonly AutomatedReportsRepository $reportRepository,private readonly AutomatedReportsService $automatedReportsService,private readonly BusDispatcher $dispatcher,parent::__construct();/*** Execute the console command.* Oreturn int*/public function handle(): int$reportResults = $this->reportRepository->getGeneratedNotSentResults();foreach ($reportResults as SreportResult) {/** Ovar AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->getReport());if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getGeneratedAt())){$this->logger->info(self::LOG_PREFIX.' Dispatching job', ['uuid' => SreportResult->getUuid(),1):$this->dispatcher->dispatch(new SendReportJob($reportResult>g{tuuid()));Cascade 2 TICommand &1return connondacos..succeoo.Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (57 minutes ago)j Support Daily • in 34 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:26:35A console [PROD]A console (EU]Al console [STAGING] XGajiminny16 414 V.13= custom.logE laravel.logA HS_local [jiminny@localhost]510519-52052152252352452552652205285305355365375385571540541542543545546547548549550551004553554555556557T558.55$-56€561563564565566567568 vA SF [jiminny@localhost]Tx: Auto vPlaygroundvu.email,Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;seLect * trom playbooks where ceam_1d = 1:select x t'oi oavoooks Vnere 10 =1o.select x Tron playbook cacecorles where playbook 10 = 1/5.select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event' ;SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<-›1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);570select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where report_id IN (36);w Winasurt leams61:/6 13 charsUTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12595
|
|
12596
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:36ec2-user@ip-10-30-93-249:~L₴81DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...84-zsh|885-zsh86-zsh0 87* Unable to acce...*8[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]9-b635-2aa52627f c27"}Found 1 daily reports to process{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12596
|
|
12597
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplalol• Support Daily • in 34 mA100% CTue 14 Apr 14:26:47ec2-user@ip-10-30-93-249:~L₴81DOCKER- 281DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...₴4-zsh|885-zsh86-zsh0 87* Unable to acce...88[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId" :1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth" : true}{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automated report found Test 6[2026-04-1410:48:42]staging. INFO: [automated-reports]9-b635-2aa52627f c27"}Found 1 daily reports to process{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] staging.INF0: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8".,"teamId" :1, "frequency" :"daily","type": "ask_jiminny"} {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports] Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 dailyreports to process5-acd0-86c51b5659a5"'}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b"|',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#l...
|
NULL
|
NULL
|
NULL
|
12597
|
|
12598
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~HelpProject v© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeamsD TracksD TranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.p© DatabaseTableCount.ptc DeleredoAcimnorescc Deleress eroverscom(C DevPostmanCommand.l© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebho© GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.f© JiminnyCacheClearCom(©) JiminnyDebugCommanc© JiminnySetEncryptedTo(cJminnv okenintocomm© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComiC)RecalculateDealRiskscd(C) RemoveDe leteMarkersa(e) Remove-YoiredNuddesi© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAddLayoutEntities.php• Team.php© AutomatedReportsRepository.phpAutomatedReportsService.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command1925 GT303132 Gt35 C39404147485052536566* The name and sianature of the console command.* Ovar stringprotected $signature =Jutomated-reports:send';/*** The console command description.* @var stringororecreo moescrprion = senos curoliared reoors paseo on user mlezone".public function __construct(private readonly LoggerInterface $logger,private readonly AutomatedReportsRepository $reportRepository,private readonly AutomatedReportsService $automatedReportsService,private readonly BusDispatcher $dispatcher,/*** Execute the console command.* Oreturn int*/public function handle(): int$reportResults = $this->reportRepository->getGeneratedNotSentResults();foreach ($reportResults as $reportResult) {/** Ovar AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->getReport());if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getGeneratedAt))) €$this->logger->info(self::LOG_PREFIX'Dispatching job', ['uuid' => $reportResult->getUuid(),I):$this->dispatcher->dispatch(new SendRepoftJob($reportResult-›getUuid()));return CommandALias: : SUCCESS;Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (57 minutes ago)j Support Daily • in 34 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:26:47A console [PROD]A console (EU]Al console [STAGING] XGajiminny v16 414 V.13= custom.logE laravel.logA HS_local [jiminny@localhost]510519-52052152252352452552652205285305355365375385571540541542543545546541548549550551004553554558559560561562563564565566567568 v569570A SF [jiminny@localhost]Tx: Auto vPlaygroundvu.email,Sa.xt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':select * 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;select * from groups where id = 565;seLect * trom playbooks where ceam_1d = 1:select x t'oi oavoooks Vnere 10 =1o.select x Tron playbook cacecorles where playbook 10 = 1/5.select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event' ;SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<-›1..n: on cl.id = pl. layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency = 'daily"and r.status = 1AND t.status = 'active'AND (r.exRines.at >= now() OR r.expires.at IS NULL):select * from automated_ report_results where ceRontaid IN (18, 33);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where cepont.ig IN (36);select * from activity_searches where id = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where report_id IN (36);w Winasurt leam61:0/UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12598
|
|
12601
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpablSupport Daily - in 34 m100% C47Tue 14 Apr 14:26:51ec2-user@ip-10-30-93-249:~L₴1DOCKERS 981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-...-zsh-zsh86-zsh0 87* Unable to acce... * *8[2026-04-1410:46:087staging. INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-cDea-4040-88f4-0ae14b66ade8"daily", "type": "ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0","trace_id" :"185df6f6-4327-4609-9cZe-2ab83a0f5432"'}"teamId":1,"frequency" :"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"}root@c78a087b1345:/home/jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42] staging.INFO: [automated-reports] Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88","trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INF0: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth" :4,"isQuarterlyMonth":true}id":"246alala-7076-458c-bd7d-49d2f5a2db88","trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"'}{"correlation_[2026-04-14 10:48:42]aa52627fc27"}staging.INFO: [automated-reports]Processing daily reports{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports][2026-04-1410:48:42]9-b635-2aa52627fc27"}Automated report found Test 6staging. INFO: [automated-reports]Found 1 daily reports to process{"correlation_id":"246alala-7076-458c-bd7d-49d2f5a2db88""trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42] 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":"246a1ala-7076-458c-bd7d-49d2f5a2db88"',"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"})[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246ala1a-7076-458c-bd7d-49d2f5a2db88", "trace_id" : "1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/home/jiminny# [ec2-user@ip-10-30-93-249 ~]S docker exec -it S(docker ps --format "{f.ID}}" --filter "name=ecs-worker" | head -1) fbin/bash -c "cd /home/jiminny && bash"root@b79a4bdd6905:/home/jiminny# phpartisan automated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33] staging.INFO: [automated-reports]Started{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging.INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth":false, "currentMonth":4, "isQuarterlyMonth":true} {"correlation_id": "90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-4475-acd0-86c51b5659a5" }[2026-04-14 11:22:33] staging.INF0: [automated-reports] Processing daily reports{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-14 11:22:33] staging.INFO: [automated-reports] Found 1 daily5-acd0-86c51b5659a5"}reports to process{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-447[2026-04-14 11:22:33]staging.INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency": "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cf ce711b"',"trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"})[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"})root@b79a4bdd6905:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
12601
|
|
12605
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpall• Support Daily • in 33 ml100% C 8Tue 14 Apr 14:27:08ec2-user@ip-10-30-93-249:~DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-... 884-zsh885-zsh86-zshO 87* Unable to acce...-*8[2026-04-1410:46:08]staging.INF0:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily","type":"ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0"',"trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'},"teamId" : 1, "frequency" : "[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed["correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id" : "185df6f6-4327-4609-9c2e-2ab83a0f5432"}root@c78a087b1345:/home/Jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42]staging.INFO: [automated-reports]Started {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88","trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27" }[2026-04-1410:48:427staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true} 'id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"{"correlation_"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INFO: [automated-reports]Processing daily reportsaa52627fc27"}{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automatedreportfound Test[2026-04-1410:48:42]staging.INFO: [automated-reports]9-b635-2aa52627fc27"}Found 1 daily reports to process{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42]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":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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"rooteb79a4bdd6905:/home/Jiminny#phpartisanautomated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33]staging.INFO: [automated-reports]Started {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true}id": "90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}{"correlation_[2026-04-14 11:22:33]staging.INFO: [automated-reports] Processing daily reports {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-1411:22:33] staging.INFO: [automated-reports] Found 1 daily reports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-447[2026-04-14 11:22:33]staging. INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5" }rooteb79a4bdd6905:/home/Jiminny# phpartisan automated-reports:sendroot@b79a4bdd6905:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
12605
|
|
12610
|
PhpStormFileFditViewNavigateCodeLaravelRetactonRun PhpStormFileFditViewNavigateCodeLaravelRetactonRunToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny vProject vw rаuрanьрy© Partner.phpC Permission.php© PhoneNumber.phpg Playback lheme.phpC Playbook.phpPlaybookcategory.phpC) Plavlist.phoC RateLimit.phpC) Region.phoC) Role.phpC RoleChangeEvent.phpC) ScopeGroup.php(C) Session.phpg SlackBot.phpsocialAccount.php© Stage.php© Task.phpC Team.phpC) TeamAiContext.phpC) TeamDomain.phpC) TeamFeature.php©) TeamSettings.phpC TextRelay.php© Track.php© TranscriptionModel.php© TranscriptionModelLocale.|© TranscriptionProvider.phpC User oho© UserSettings.phpc) Vocabularv.ohp© VocabularyPronunciation.pC) VoiceAccess.php(C) VoiceConsentPrefix.php> _ Notifications• _ Observers› _ Policies>D Providers,_ Queuev | Repositories> MAi> AutoScoring> Calendar>DCrm> → Geography© ActiveStreamsRepository.p(C) ActivityCommentRepositor(©) ActivityLogRepository.phpC) ActivityMessageRepositors© ActivityMomentRepository© ActivityProviderRepository.C) ActivitvRepositorv.phpC) ActivitvSearchFilterReposil(C) ActivitvShareRepositorv.ohC) ActivityUploadSettingRepoC) AiPromptRepository.phpC) AskAnythingRepository.phiC AutomatedReportsReposit©) CallimportRepository.phpC) CoachingFeedbackReposit(©) ReportController.phpC SendReportJob.php(©) AutomatedReportsCommand.phpcAutomatedRenorssenocommana.onAddLayoutEntities.phpC Team.phpC AutomatedReportsRepository.pnp xC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.phpC) Automatedkeport.onpclass Aucomaceareporcskepostcory1162111651164|16516611671168169170117411751185111751941951961971981992002022032042052062072082092102112142162492602612621205126426526615 V 41* Find an automated report result by vuu.* @param string Suuid The UUID to find the automated report result with.* dreturn AutomatedReportResult null The automated report result if found, otherwise null.*/10 usagespublic function findResultByUuid(string $uuid): ?AutomatedReportResult{...}public function findResultByUuidForUser(string $uvid, User $user): ?AutomatedReportResult{...}public function findChildResult(AutomatedReportResult $result, string $type): ?AutomatedReportResult{...hpublic function getGeneratedNotSentResultso: Collectionreturn AutomatedReportResult::query)->WhereNotyul columns'generated_at')- >Vnerenuuu columnst"sent_at")- >Vnerel colu"status',-> nereras relation:'report')=>Wahun relations'report')operator: AUtonatedkeporcResuLt..SIA/US_GENERA/EU)-paer.lusaeepublic function getPaginatedUserReports(JsArSuserReportsort$sort,ReportsortDirection $sortDirection,1nuSLnIEruaroon"alroonфresultsPerrage,spage,+trombace,ntolare.anravarray?string Sname,+ceamlas,Sreportlypes.: LengthAwarePaginator ...Lusagespublic function countuserreports(User suser): intr...* Get report IDs for a specific team* ood ranedllloreulh* dreturn Illuminate Support Collectiono usagesSupport Daily • in 33 m100% |45]Tue 14 Apr 14:27:21AutomatedReportsCommandTestv& console PROD& console (EU]L console [STAGING XSo jiminny v:16 14 V.13= custom.log= aravel.loeL SF (iminny@localhostc HS_local fiminny@localhost)510-519v O 526521522523523526528-530531534533556538— 539540541— 542543544545546547548549551-504553554555556557558559560561504563565—566567568 V569576Tx: Auto vPlayground vU,ellant.Sa.xt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t l..n<->1: on t.1d = u.team_1dWHERE U.team_1d = 1 and sa.provider = 'salesforce':select * trom teams where 10 = 1;select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1;select * tron crouos wnere 1o = 505.select * troiplaybooks where ceam_1d = 1:select x ToIoavoooks Vnere 10 =1o.seLect x TromoLaydook cacecorles where playbook 10 = 1/51select * from users where team id = 1:select * from users where id = 7160:select * from crm_profiles where user_id = 7160;select * from features:select# 1a, uuid, type, provider, playbook_category_1a, user_1a, Lead_1a, contact_ia, account_ia, opportunity_1a, stage_1a,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'# and crm provider id IS NOT NULLIand provider l= 'uploader' and actual start time IS NOT NULIORDER by id desc:select * from activities where id = 54747783; # 00U0400000pCzo7MACselect p.1d, p.activity_type, pc.1d, pc.nameFROM playbooks pJoln playbook_categories pc 1<->l.n: on p.1d = pc.playbook_1dwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm fields WHERE crm confiquration id = 1 and obiect tvpe = 'event':SELECT * FROM crm field values WHERE crm field id = 4:select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl.layout_idwhere crm confiquration id = 1 and pl.playbook id = 175;select * from teams;SELECT r.* FROM automated_reports rjoln teams t on r.team 1d = t.1dWHERE r.frequency = 'daily"and r.stauus = 1AND t.status = 'active'AND (r.expires at >= now) OR r.expires at IS NULL):select * from automated_report_results where report id IN (18, 33);select * from activity searches where id = 10932:select * from activity search_ filters where activity search_id = 10932:select * from automated!_reports order by 1d desc:esults where nepomtara IN (56):ao v to comolerew wind sumselect * trom acuivity_searcnes where 1d = 109521select * from activity_search_filters where activity_search_id = 10932;select * trom aucomaced_reports order dy 1d desc;select * from automated_report_results where report_id IN (36);W Windsurf Teams194:21UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
12610
|
|
12613
|
PhpStormFileEditFV faVsco.jsProjectvuefrawM+ READM PhpStormFileEditFV faVsco.jsProjectvuefrawM+ README.mdsonar-project.properties=test.py‹> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› ih External Librariesv E® Scratches and Consolesv D Database Consoles> AEUv A jiminny@localhostA console [jiminny@localhostDI [jiminny@localhost]4 HS_local [jiminny@localhosSF [jiminny@localhost]A zoho_dev [jiminny@localho& PROD> ÁQA4 QAIA QAI PRODV A STAGINGA console [STAGING]A console_1 [STAGING]A uranus [STAGING]ViewNavigateCodeLaravelRefactorToolsWindowHelp• #11894 on JY-18909-automated-reports-ask-jiminny ~© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.php© AddLayoutEntities.php• Team.php© AutomatedReportsRepository.php XAutomatedReportsService.phpCreateHeldActivityEvent.php(c lrackProviderinstallea.vencono© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(©) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsRepository#15 V41 0liblj Support Daily • in 33 mAL AutomatedReportsCommandTest100% |45]Tue 14 Apr 14:27:33= custom.log= laravel.logA SF [jiminny@localhost]A HS_local [jiminny@localhost]Tx: Auto vPlaygroundA console [PROD]A console (EU]Al console [STAGING] x|555556v @557162163/**558-5591164|* Find an automated report result by UUID.165166* @param string $uvid The UUID to find the automated report result with.167168* Oreturn AutomatedReportResult|null The automated report result if found, otherwise null.169=561562563—564select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRices.at >= now() OR r.expines.at IS NULL);select * from automated_ report_results where ceRontaid IN (18, 33);170174*/10 usagespublic function findResultByUuid(string $uvid): ?AutomatedReportResultf..1751851 usagepublic function findResultByUuidForUser(string $uvid, User $user): ?AutomatedReportResultf...}select * from activity_searches where id = 10932;566select * from activity_search_filters where activity_search_id = 10932;567sflect * from automreports order by id desc;7568 vselect * from automated_report_results| where report.id IN (36);I569570public function findChildResult(AutomatedReportResult $result, string $type): ?AutomatedReportResult{...}1931 usage194195public function getGeneratedNotSentResults(): CollectionservicesOutputfiB jiminny.automated_report_results Xv Database1row v5. 0.Tx: AutoV LEUc consoed jiminny@localhostc ho local4 SF 1 s 140 msV A PRODA consoleV A STAGING4, console 1 s 286 msDockerDidO uuid (UUID with time-low and time-high swapped)report_idI nameI media_typeI parent_idI statusreason1QE4®51CT000074-4005-40115-Ytoe-aoat45enoTuesday report - 13 Apr 2026pdfCnuLLGajiminny016 A 14 X13 ^•: t+08,oay LoadI response• requested_atI generated_atIn sent atI created_at• updated_at{"user_question":"test", "call_ids": ["54214348", "54747783", "54792639", "54355211", "54214356", "54579532", "54214362", "54795501", "54373257", "54566775", "54179068", "54691680", "54702966", "54186485", "54547166", "54357434", "54439335"{"request_id":"cfd6bb99-4853-4C13-9f8e-a6af43e1727b", "status": "completed", "timestamp":"2026-04-14T11:23:03.951289+00:00", "s3_url": "s3: \/\/stage. jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/panorama-reports\/c2026-04-14 11:22:362026-04-14 11:23:04shuLl2026-04-14 11:22:362026-04-14 11:23:04Hide the active tool windowW Windsurt Teams 568:33U11F-8...
|
NULL
|
NULL
|
NULL
|
12613
|
|
12614
|
PhpStormFileFditViewNavigateCodeLaravelRetactonToo PhpStormFileFditViewNavigateCodeLaravelRetactonToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~Project v= .env.production-euE.env.qaE env.dailE env.rootE.env.staging=.gitattributes.gitignore=.php-cs-fixer.cachephp.php-cs-fixer.dist.phpphp.phpstorm.meta.php=.phpunit.result.cache=.prettierignore= wino sunrulespnp_Ide_helper.phppip_lde_nelper_models.pnppnp aruisani composer.isoni composer.lockI dependency-checker.ison" dev.json= ids.txt= infection.json.distM-INSALL.mdM-INIERNAL WE.nOOK S-IUP.moE jiminny_storageMvcenses.meM MakefileU package-lock.ison= phostan.neon.dist=phostan-baseline.neon<» phpunit.xmlleraw_sql_query.sqlM.README.molsonar-project.properties= test.py<> Untitled Diagram.xmlosvetur.config.jsM+ WEBHOOK FILTERING IMPLEME› iib External Libraries=Scratches and Consolesv _ Database Consoles> LEUv d iminny@localhostd console liminny@localhost« Di Liminny@localhost]d Hs_local Jiminny@localhosd sr yiminny@localhost)« zoho dev lminnva ocalho7CPROD> LQAL QAI PRODV L STAGINGd console STAGINGd console_1 STAGINGd uranus STAGING_Extensions> M Scratchesc) ReportController.onpC SendReportJob.php(©) AutomatedReportsCommand.phpcAutomatedRenorssenocommana.onAddLayoutEntities.phpC Team.php© AutomatedReportsRepository-pnp xAutomatedkeportsservice.pnp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.phpC) Automatedkeport.onpclass AutomatedReportsRepository1162111651164|165166116711681691701174118511193194196197119811992002022032042052062072082092102112142152162492602621205126426526615 V 41* Find an automated report result by vulu.* @param string Suuid The UUID to find the automated report result with.* dreturn AutomatedReportResult null The automated report result if found, otherwise null.*/10 usagespublic function findResultByUuid(string $uuid): ?AutomatedReportResult{...hpublic function findResultByUuidForUser(string $uvid, User $user): ?AutomatedReportResult{...}public function findChildResult(AutomatedReportResult $result, string $type): ?AutomatedReportResult{...}public function getGeneratedNotSentResultso: Collectionreturn AutomatedReportResult::query)->WhereNotwulu ci'generated_at')= >Vnerewu uu columns"sent_at")- >Vnerel colu->Vnereras relation.report")operator: AUtonatedkeporcResuLt..SIA/US_GENERA/EU)=>Wahun relationsreoort)-paer.lusaeepublic function getPaginatedUserReports(JsArsuserReportsort$sort,ReportsortDirection ssortDirection,1nu$resultsPerPage,SLnIE$page,ruaroon+trombace,ncovare."alroonanrayarray?string Sname,+ceamlas,Sreportlypes.: LengthAwarePaginator ...hLusagespublic function countUserReports(User $user): intf...}* Get report IDs for a specific team* ood ranedllloreulh* dreturn Illuminate Support CollectionView pull request (58 minutes ago)Support Daily • in 33 m100% |45]Tue 14 Apr 14:27:34AutomatedReportsCommandTestv& console PROD& console (EU]L console [STAGING XSo jiminny v916 A14 V 13= custom.log= laravel.logL SF (iminny@localhostc HS_local fiminny@localhost)540-521v 0 522523524525521528529550551-5321533536537558540— 541|542543— 544545546547548549550551755?553555556558559566564563504Ty: Auto vPlayground vt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t1..n<->1: on t.id = u.team idWHERE U.team_id = 1 and sa.provider = 'salesforce";select * fromteams Where 1d = 1;select * frongroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * trongroups where 1d = 565;select * fromplaydooks where team_1d = 1;select * troi•Lavoooks Wnere 10 = 15.select * troiplaybook_cacegories where playdook_1d = 1/5;select x ToIusers Mere teali 1o =seLect x Tromusers where id = 7160:select * from crm profiles where user id = 7160:select * from features:select# 1d, uuld, type, provider, playbook_category_1d, user_1d, Lead_1d, contact_1d, account_1d, opportunity_1d, stage_1d,# crm_configuration_1d, crm_provider_1d, transcription_1d, statustron aculviules where cri_contiguracion_1d = 1 and type =# and erm nroviden id TS NOT NULLI"conterenceand provider != 'uploader' and actual_start_time IS NOT NULLUkurk ov no deschselect * from activities where id = 54747783: # 00U0400000pCzoiMACselect p.id, p.activity type, pc.id, pc.nameFROM playbooks pJoln playbook_categories pc 1<->l.n: on p.1d = pc.playbook_1dwhere p.team_1d = 1 and p.activity_type = 'event'*SELECI * FROM CrM_TIeLaS wHERE crm_contiguration_1d = 1 and object_type = event,SELECI * FROM CrM_TIELd_VALUES WHERE crm_TLeLd_1d = 41select x Tron cri_layouts cl Join playbook_layouts pl s-sln on cl.la - pL.layout_1awhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams:SELECT r.* FROM automated reports rjoin teams t on r.team.id = t.idWHERE r.frequency ='dally"and r.status = 1AND t.status = 'active'AND (r.exptres ar >= now uk r.expires au Is NULL):select * from automated_report_results where report id IN (18, 33);565566567-568 v5695705711select x ToIactivity_searches where id = 10932;select * from activity search_ filters where activity search_ id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where ceport.id IN (36);W Windsurt Teams568:39UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12614
|
|
12615
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpall• Support Daily • in 33 ml100% C 8Tue 14 Apr 14:27:39ec2-user@ip-10-30-93-249:~DOCKER0 81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-... 884-zsh885-zsh86-zshO ₴7.* Unable to acce...88[2026-04-1410:46:08Jstaging.INF0:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily","type":"ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0"',"trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'},"teamId" : 1, "frequency" : "[2026-04-14 10:46:08]staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id" : "185df6f6-4327-4609-9c2e-2ab83a0f5432"}root@c78a087b1345:/home/Jiminny# php artisan automated-reports --report-id 35[2026-04-1410:48:42]staging.INFO: [automated-reports]Started {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88","trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27" }[2026-04-1410:48:427staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true} 'id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"{"correlation_"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27" }[2026-04-1410:48:42]staging.INFO: [automated-reports]Processing daily reportsaa52627fc27"}{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automatedreportfound Test[2026-04-1410:48:42]9-b635-2aa52627fc27"}staging.INFO: [automated-reports]Found 1 daily reports to process{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42]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":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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"rooteb79a4bdd6905:/home/Jiminny#phpartisanautomated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33]staging.INFO: [automated-reports]Started {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true}id": "90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}{"correlation_[2026-04-14 11:22:33]staging.INFO: [automated-reports] Processing daily reports {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-1411:22:33] staging.INFO: [automated-reports] Found 1 daily reports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-447[2026-04-14 11:22:33]staging. INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5" }rooteb79a4bdd6905:/home/Jiminny# phpartisan automated-reports:sendroot@b79a4bdd6905:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
12615
|
|
12616
|
PhpStormFileFditViewNavigateCodeLaravelRetactonToo PhpStormFileFditViewNavigateCodeLaravelRetactonToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~Project v= .env.production-euE.env.qaE env.dailE env.rootE.env.staging=.gitattributes.gitignore=.php-cs-fixer.cachephp.php-cs-fixer.dist.phpphp.phpstorm.meta.php=.phpunit.result.cache=.prettierignore= wino sunrulespnp_Ide_helper.phppip_lde_nelper_models.pnppnp aruisani composer.isoni composer.lockI dependency-checker.ison" dev.json= ids.txt= infection.json.distM-INSALL.mdM-INIERNAL WE.nOOK S-IUP.moE jiminny_storageMvcenses.meM MakefileU package-lock.ison= phostan.neon.dist=phostan-baseline.neon<» phpunit.xmlleraw_sql_query.sqlM.README.molsonar-project.properties= test.py<> Untitled Diagram.xmlosvetur.config.jsM+ WEBHOOK FILTERING IMPLEME› iib External Libraries=Scratches and Consolesv _ Database Consoles> LEUv d iminny@localhostd console liminny@localhost« Di Liminny@localhost]d Hs_local Jiminny@localhosd sr yiminny@localhost)« zoho dev lminnva ocalho7CPROD> LQAL QAI PRODV L STAGINGd console STAGINGd console_1 STAGINGd uranus STAGING_ExtensionsMScratchesc) ReportController.onpC SendReportJob.php(©) AutomatedReportsCommand.phpcAutomatedRenorssenocommana.onAddLayoutEntities.phpC Team.php© AutomatedReportsRepository-pnp xAutomatedkeportsservice.pnp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.phpC) Automatedkeport.onpclass AutomatedReportsRepository1162111651164|1651661167116816917011741185111931941961971198119920020220320420520620720820921021121421521624926026126212051264265266#15 V4* Find an automated report result by vulu.* @param string Suuid The UUID to find the automated report result with.* dreturn AutomatedReportResult null The automated report result if found, otherwise null.*/10 usagespublic function findResultByUuid(string $uuid): ?AutomatedReportResult{...}public function findResultByUuidForUser(string $uvid, User $user): ?AutomatedReportResult{...}public function findChildResult(AutomatedReportResult $result, string $type): ?AutomatedReportResult{...}public function getGeneratedNotSentResultso: Collectionreturn AutomatedReportResult::query)->WhereNotwulu ci'generated_at')= Vnerenu uu coll"sent_at")- >Vnerel colu->Vnereras relation.report")operator: AUtonatedkeporcResuLt..SIA/US_GENERA/EU)=>Wahun relationsreoort)-paer.lusaeepublic function getPaginatedUserReports(JsArsuserReportsort$sort,ReportsortDirection ssortDirection,1nusresultsPerrage,SLnIEфрage,ruaroon+trombace,ntolare."alroonanravarray?string Sname,+ceamlas,Sreportlypes.: LengthAwarePaginator ...Lusagespublic function countUserReports(User $user): intf...}* Get report IDs for a specific team* ood ranedllloreulh* dreturn Illuminate Support CollectionView pull request (58 minutes ago)Support Daily • in 33 m100% |45]Tue 14 Apr 14:27:39AutomatedReportsCommandTestv& console PROD& console (EU]L console [STAGING XSo jiminny v916 A14 V 13= custom.log= aravel.loeL SF (iminny@localhostc HS_local fiminny@localhost)540-521v 0 522523524525521528529550551-5321533536537558540—541542543— 544545546547548549550551553555556558559566562563504Ty: Auto vPlayground vt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t1..n<->1: on t.id = u.team idWHERE U.team_id = 1 and sa.provider = 'salesforce";select * fromteams Where 1d = 1;select * frongroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * trongroups where 1d = 505;select * fromplaydooks where team_1d = 1;select * troi•Lavoooks Wnere 10 = 15.select * troiplaybook_cacegories where playdook_1d = 1/5;select x ToIusers Mere teali 1o =seLect x TrOlusers where id = 7160:select * from crm profiles where user id = 7160:select * from features:select# 1d, uuld, type, provider, playbook_category_1d, user_1d, Lead_1d, contact_1d, account_1d, opportunity_1d, stage_1d,# crm_configuration_1d, crm_provider_1d, transcription_1d, statustron aculviules where cri_contiguracion_1d = 1 and type =# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULL"conterenceUkurk ov no deschselect * from activities where id = 54747783: # 00U0400000pCzoiMACselect p.id, p.activity type, pc.id, pc.nameFROM playbooks pJoln playbook_categories pc 1<->l.n: on p.1d = pc.playbook_1dwhere p.team_1d = 1 and p.activity_type = 'event'*SELECI * FROM CrM_TIeLaS wHERE crm_contiguration_1d = 1 and object_type = event,SELECI * FROM CrM_TIELd_VALUES WHERE crm_TLeLd_1d = 41select x Tron cri_layouts cl Join playbook_layouts pl s-sln on cl.la - pL.layout_1awhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams:SELECT r.* FROM automated reports rjoin teams t on r.team.id = t.idWHERE r.frequency ='dally"and r.status = 1AND t.status = 'active'AND (r.exptres ar >= now uk r.expires au Is NULL):select * from automated_report_results where report id IN (18, 33);565566567-568 v5695705711select x ToIactivity_searches where id = 10932;select * from activity search_ filters where activity search_ id = 10932;select * from automated_reports order by id desc;select * from automated_report_results where ceport.id IN (36);W Windsurt Teams568:39UTF-84 spaces...
|
NULL
|
NULL
|
NULL
|
12616
|
|
12617
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp> 0.lalol= Support Daily • in 33 m100% C 8Tue 14 Apr 14:27:45ec2-user@ip-10-30-93-249:~DOCKER© *1DEV (docker)882APP (-zsh)83ec2-ukar@ip-10-30-... 984-zsh885-zsh86-zshO 87* Unable to acce...88[2026-04-1410:46:08]staging.INFO:[automated-reports]DispatchingGenerate Report job forreport {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily","type":"ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0"',"trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'},"teamId" : 1, "frequency" : "[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id" : "185df6f6-4327-4609-9c2e-2ab83a0f5432"}root@c78a087b1345:/home/Jiminny# php artisan automated-reports --report-id 35[2026-04-1410:48:42]staging.INFO: [automated-reports]Started{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88,"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:427staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true}id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"{"correlation_"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INFO: [automated-reports]Processing daily reportsaa52627fc27"}{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automatedreportfound Test[2026-04-1410:48:42]9-b635-2aa52627fc27"}staging.INFO: [automated-reports]Found 1 daily reports to process{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42]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":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"'}root@c78a087b1345:/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"rooteb79a4bdd6905:/home/Jiminny#phpartisanautomated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33]staging.INFO: [automated-reports]Started {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true}id": "90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}{"correlation_[2026-04-14 11:22:33]staging.INFO: [automated-reports] Processing daily reports6c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-8[automated-reports] Automated report found Tuesday report[2026-04-1411:22:33] staging.INFO: [automated-reports] Found 1 daily reports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-447[2026-04-14 11:22:33]staging. INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5" }rooteb79a4bdd6905:/home/Jiminny# phpartisan automated-reports:sendroot@b79a4bdd6905:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
12617
|
|
12618
|
PhpStormFileEditFVtavsco.isvViewNavigateCodeLarave PhpStormFileEditFVtavsco.isvViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-iminny ~Projectv© AiPromptRepository.php© AskAnythingRepository.phj© AutomatedReportsReposits© CallImportRepository.php© CoachingFeedbackReposit© CrmTemplateFilterRepositc© CrmTemplateRepository.pt© CrmTemplateRunRepositor© DeviceRepository.php© ElasticActivityRepository.pl© EmailMessageRepository.p© GenericAiPromptRepositor© GroupRepository.phpInboxEmailBatchRepositoryInboxRepository.php© InvitationRepository.php© JobRepository.php© LanguageRepository.php© MomentRepository.php© NotificationRepository.php© ParticipantRepository.php© ParticipantSpeechReposito© ParticipantStatsRepository© PlaybookCategoryRepositc© PlaybookRepository.php© PlaylistActivityRepository.f©PlaylistRepository.php© PlaylistShareRepository.ph© QuestionRepository.php© RoleChangeEventRepositor© RoleRepository.php©SearchRepository.php© SnapshotRepository.php© SocialAccountRepository.p(C) StageRepository.php© SubscriptionSetRepository.©TaskRepository.php© TeamAiContextRepository.© TeamDomainsRepository.p© TeamInsightsRepository.pr© TeamRepository.php© ThemeRepository.php© TimezoneRepository.php© TopicRepository.php© TopicTriggerRepository.ph© TrackRepository.php© TranscriptionModelLocaleF© TranscriptionRepository.ph© TranscriptionSummaryRepr© UserRepository.php© VocabularyRepository.php› CRulesv D Services>@ Activity> M AiReports> M Avatar> CalendarD ConferenceD Crm© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php• AutomatedReportsSendCommand.phpAddLayoutEntities.php• Team.phpAutomatedReportsRepository.php xAutomatedReportsService.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsRepository15 V 411621631641651661671681691701741751185119311741951961971981992002012022032042052062072082092102112122132142162492602612621205264265266* Find an automated report result by UUID.* @param string $uvid The UUID to find the automated report result with.* Oreturn AutomatedReportResult|null The automated report result if found, otherwise null.*/10 usagespublic function findResultByUuid(string $uvid): ?AutomatedReportResultf...}public function findResultByUuidForUser(string $uvid, User $user): ?AutomatedReportResult{..}public function findChildResult(AutomatedReportResult $result, string $type): ?AutomatedReportResult{...}public function getGeneratedNotSentResults(): Collectionreturn AutomatedReportResult: : query()->whereNotNull( colu'generated_at')->whereNull( columns:'sent_at')->where( co,'status',>Wnereras relation.l'report')->with( relations: "report')->get();operator: AutomatedReportResult::STATUS_GEMERATED)lusaeepublic function getPaginatedUserReports(User$user,ReportSort$sort,ReportSortDirection $sortDirection,int$resultsPerPage,SLnIE$page,ruaroon$fromDate,"alroonntolare.anray+ceamlas,array$reportTypes,?string $name,): LengthAwarePaginator {...}Lusagespublic function countUserReports(User $user): intf...}* Get report IDs for a specific team* ood ranedllloreulh* Oreturn (Illuminate|Support\Collection*/o usagesj Support Daily • in 33 mAAutomatedReportsCommandTestv100% |45]Tue 14 Apr 14:27:45A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logA HS_local [jiminny@localhost]540-521~ 0522523524525526527528529530-532536537538539540-541542543-54454554654754854955055177552553555556559560561562563564565566567-568 v569570571E laravel.logA SF [jiminny@localhost]Tx: Auto vPlaygroundvt.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE U. team_id = 1 and sa.provider = 'salesferce':select * from teams where id = 1;select * fromgroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * fromgroups where id = 565;select * from playbooks where team_id = 1;select * from•Lavoooks Wnere 10 = 15.select * troiplaybook_cacegories where playdook_1d = 1/5;select x ToIusers Mere teali 1o =seLect * Tromusers where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uvid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type ='conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLUkurk ov no deschselect * from activities where id = 54747783; # 00U0400000pCZojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * trol criavours cl oun oavoook avours or K"n on CL.0 = OL.avOUT 1where crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team. id = t.idWHERE r.frequency ='daily'and r.status = 1AND t.status = 'active'AND (r.expinescat >= now() OR r.expinesaat IS NULL):select * from automated_report_results where ceportaid IN (18, 33);select x ToIactivity_searches whereid = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_ reports order by id desc;select * from automated_ report_results where ceRontaid IN (36);Winasun leams199:64UTF-8( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12618
|
|
12620
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpall• Support Daily • in 33 ml100% C 8Tue 14 Apr 14:27:49ec2-user@ip-10-30-93-249:~DOCKER981DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-... 884-zsh885-zsh86-zshO 87* Unable to acce...-*8[2026-04-1410:46:08]staging.INF0:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily","type":"ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0"',"trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'},"teamId" : 1, "frequency" : "[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed["correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id" : "185df6f6-4327-4609-9c2e-2ab83a0f5432"}root@c78a087b1345:/home/Jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42]staging.INFO: [automated-reports]Started {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88","trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27" }[2026-04-1410:48:427staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true} 'id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"{"correlation_"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INFO: [automated-reports]Processing daily reportsaa52627fc27"}{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automatedreportfound Test[2026-04-1410:48:42]staging.INFO: [automated-reports]9-b635-2aa52627fc27"}Found 1 daily reports to process{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42]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":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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"rooteb79a4bdd6905:/home/Jiminny#phpartisanautomated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33]staging.INFO: [automated-reports]Started {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true}id": "90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}{"correlation_[2026-04-14 11:22:33]staging.INFO: [automated-reports] Processing daily reports {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-1411:22:33] staging.INFO: [automated-reports] Found 1 daily reports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-447[2026-04-14 11:22:33]staging. INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5" }rooteb79a4bdd6905:/home/Jiminny# phpartisan automated-reports:sendroot@b79a4bdd6905:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
12620
|
|
12621
|
18PhpStormFileEditFVtavsco.isvViewNavigateCodeLara 18PhpStormFileEditFVtavsco.isvViewNavigateCodeLaravelRefactorRunToolsWindowHelp#11894 on JY-18909-automated-reports-ask-iminny ~Projectv© AiPromptRepository.php© AskAnythingRepository.phj© AutomatedReportsReposits© CallImportRepository.php© CoachingFeedbackReposit© CrmTemplateFilterRepositc© CrmTemplateRepository.pt© CrmTemplateRunRepositor© DeviceRepository.php©ElasticActivityRepository.pl© EmailMessageRepository.p© GenericAiPromptRepositor© GroupRepository.phpInboxEmailBatchRepositoryInboxRepository.php© InvitationRepository.php© JobRepository.php© LanguageRepository.php© MomentRepository.php© NotificationRepository.php© ParticipantRepository.php© ParticipantSpeechReposito© ParticipantStatsRepository© PlaybookCategoryRepositc© PlaybookRepository.php© PlaylistActivityRepository.f©PlaylistRepository.php© PlaylistShareRepository.ph© QuestionRepository.php© RoleChangeEventRepositol© RoleRepository.php©SearchRepository.php© SnapshotRepository.php© SocialAccountRepository.p© StageRepository.php© SubscriptionSetRepository.©TaskRepository.php© TeamAiContextRepository.© TeamDomainsRepository.p© TeamInsightsRepository.pr© TeamRepository.php© ThemeRepository.php© TimezoneRepository.php© TopicRepository.php© TopicTriggerRepository.ph© TrackRepository.php© TranscriptionModelLocaleF© TranscriptionRepository.ph© TranscriptionSummaryRepr© UserRepository.php© VocabularyRepository.php› CRulesv D Services>@ Activity> M AiReports> M Avatar> CalendarD ConferenceD Crm© ReportController.php© SendPeportJob,php xAutomatedReportsCommand.php• AutomatedReportsSendCommand.phpAddLayoutEntities.php• Team.php© AutomatedReportsRepository.php XAutomatedReportsService.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsRepository15 V 41166* @param string $uuid The UUID to find the automated report result with.167168* @return AutomatedReportResult|null The automated report result if found, otherwise null.16917017417518518611741951961971981992002012022032042052062072082092102112122132142102482602612622632642651400267400272273274275*/10 usagespublic function findResultByUuid(string $uuid): ?AutomatedReportResult{...}Tusdyepublic function findResultByUuidForUser(string $uuid, User $user): ?AutomatedReportResult{..}3 usagespublic function findChildResult(AutomatedReportResult $result, string $type): ?AutomatedReportResultf...}public function getGeneratedNotSentResults(): Collectionreturn AutomatedReportResult: : query()->whereNotNUll( columns: 'generated_at')->whereNull( columns: 'sent_at')->where( column: 'status',operator: AutomatedReportResult:: STATUS_GEMERATED)->whereHas ( relation:'report')->with ( relations: 'report')->get();1 usagepublic function getPaginatedUserReports(User$user,ReportSort$sort,ReportSortDirection $sortDirection,int$resultsPerPage,int$page,?Carbon$fromDate,?Carbon$toDate,array$teamIds,arraynreport voes."suruno nnallle.): LengthAwarePaginator {...}Lusagespublic function countUserReports(User $user): intf.../*** Get report IDs for a specific team* @param Team $team* Oreturn (Illuminate|Support\Collection5 usagespublic function getReportIdsByTeam(Team $team): \Illuminate|Support\Collectionf...}/*** Get all reports for a specific teamnny // View pull request (58 minutes ago)j Support Daily • in 33 mAAutomatedReportsCommandTestv100% [45)Tue 14 Apr 14:27:50A console [PROD]A console (EU]Al console [STAGING] XGajiminny v:16 14 V.13= custom.logA HS_local [jiminny@localhost]540-521~ 0522523524525526527528529530531-532536537538539540—541542543-544545546547548549550551552.1553555556558559560561562563564565T 566567-568 v569570571E laravel.logA SF [jiminny@localhost]Tx: Auto vPlayground vt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t1..n<->1: on t.id = u.team_idWHERE U. team_id = 1 and sa.provider = 'salesferce':select * from teams where id = 1;select * fromgroups g JOIN playbooks p 1.n<-›1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565;select * fromplaybooks where team_id = 1;select * from•Lavoooks Wnere 10 = 15.select * troiplaybook_cacegories where playdook_1d = 1/5;select x ToIusers Mere teali 1o =seLect x TrOlusers where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uvid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type ='conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLUkurk ov no deschselect * from activities where id = 54747783; # 00U0400000pCZojMACselect p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * trol criavours cl oun oavoook avours or K"n on CL.0 = OL.avOUT 1where crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.frequency ='daily'and r.status = 1AND t.status = 'active'AND (r.expinescat >= now() OR r.expinesaat IS NULL):select * from automated_report_results where ceportaid IN (18, 33);select x ToIactivity_searches whereid = 10932;select * from activity_search_filters where activity_search_id = 10932;select * from automated_ reports order by id desc;select * from automated_report_results where cepontand IN (36);Winasun leams199:64UTF-8( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12621
|
|
12622
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpall• Support Daily • in 33 ml100% C 8Tue 14 Apr 14:27:54ec2-user@ip-10-30-93-249:~DOCKER₴81DEV (docker)882APP (-zsh)83ec2-user@ip-10-30-... 884-zsh885-zsh86-zshO 87* Unable to acce...*8[2026-04-14 10:46:08]staging.INFO:[automated-reports]DispatchingGenerate Report job for report {"reportUuid":"7e7846e2-c0ea-4040-88f4-0ae14b66ade8"daily","type":"ask_jiminny"} {"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0"',"trace_id":"185df6f6-4327-4609-9cZe-2ab83a0f5432"'},"teamId" : 1, "frequency":"[2026-04-14 10:46:08] staging.INFO: [automated-reports]Completed{"correlation_id":"5c23e861-2ca9-4f92-9f67-773d6bc80ca0", "trace_id" : "185df6f6-4327-4609-9c2e-2ab83a0f5432"}root@c78a087b1345:/home/Jiminny# php artisan automated-reports --report-id 35[2026-04-14 10:48:42]staging.INFO: [automated-reports]Started {"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88","trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27" }[2026-04-1410:48:427staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true} 'id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88"{"correlation_"trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-1410:48:42]staging.INFO: [automated-reports]Processing daily reportsaa52627fc27"}{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2[automated-reports]Automatedreportfound Test[2026-04-1410:48:42]staging.INFO: [automated-reports]9-b635-2aa52627fc27"}Found 1 daily reports to process{"correlation_id":"246a1a1a-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e9[2026-04-14 10:48:42]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":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}[2026-04-14 10:48:42] staging.INFO: [automated-reports]Completed{"correlation_id":"246a1ala-7076-458c-bd7d-49d2f5a2db88", "trace_id":"1f894bf6-e50d-4e99-b635-2aa52627fc27"}root@c78a087b1345:/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"rooteb79a4bdd6905:/home/Jiminny#phpartisanautomated-reports --report-id 71b8bbf5-23f4-41df-b637-693765e7aa78[2026-04-14 11:22:33]staging.INFO: [automated-reports]Started {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33]staging. INFO: [automated-reports]Checking conditions {"isMonday":false,"isFirstDay0fMonth": false, "currentMonth":4, "isQuarterlyMonth":true}id": "90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}{"correlation_[2026-04-14 11:22:33]staging.INFO: [automated-reports] Processing daily reports {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b","trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5"}[automated-reports] Automated report found Tuesday report[2026-04-1411:22:33] staging.INFO: [automated-reports] Found 1 daily reports to process5-acd0-86c51b5659a5"}{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id" : "8e05a574-88d0-447[2026-04-14 11:22:33]staging. INFO: [automated-reports]Dispatching Generate Report job for report {"reportUuid":"71b8bbf5-23f4-41df-b637-693765e7aa78","teamId" :1, "frequency" : "daily", "type": "ask_jiminny"} {"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id": "8e05a574-88d0-4475-acd0-86c51b5659a5"}[2026-04-14 11:22:33] staging.INFO: [automated-reports]Completed{"correlation_id":"90a98201-fc6a-45b9-b3bd-2055cfce711b", "trace_id":"8e05a574-88d0-4475-acd0-86c51b5659a5" }rooteb79a4bdd6905:/home/Jiminny# phpartisan automated-reports:sendroot@b79a4bdd6905:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
12622
|
|
12623
|
PhpStormFileFditViewNavigateCodelaraveRetactonTool PhpStormFileFditViewNavigateCodelaraveRetactonToolsWindowHelnFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny ~Project v(C) RequestGenerateAskJin(C) RequestGenerateRepori© SendReportJob.php(©) SendReportMailJob.php>D CalendarDerm• DealkisksMalloox> M MeetinaBot› M Middleware> M Streamina→ Team› _ Telephony>D UserC BaseProcessingJob.phpc DummyJob.phpC ImportRecallAlRecordingsJ© ImportRemotelrackJob.phC Job.phpC JobDispatcher.phpD JobDispatcherInterface.phiC) PurdeSoftDeleted@pporturT SqsVisibilityControl.php› _ Listeners› _ Mailv D Models•J Activity>DAi>_ AskAnything> M Calendar> M Connection> M Contracts> MCrm> M ElasticSearch→ Feature› Opportunity> _ Participant›_ PlaybackTheme_ PlaylistScorecard_WebhookC Account.ond© Activity.phpC) Address.ohoC) AiPrompt.phpC) AutomatedReport.phpC) AutomatedReportResult.phC) Calendar.php© Callimport.phpC) CoachingFeedback.phpC) CoachingFeedbackVisibilitg CoachingSection.php© CoachingsectionCriterion.r© CoachingSectionCriterionFC) CoachinaSectionFeedbackC CommentAbstract.php• Commentinterface.phpC) Contact.php© Device.phr(©) ReportController.phpysenakeporsoo.onp x© AutomatedRepoA$Command.phpcAutomatedRenorssenocommana.onC) AddLayoutEntities.phpC Team.phpC AutomatedReportsRepository.phpC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.phpC Automatedkeport.onpclass SendReportJob implements ShouldQueue, ShouldBeUnique44 ×1public function handled11711811191201211122123124125126112/112811291115011311321331341351361371138139114011421431441451461471481491501151115/41541551561571581591601611162111651041651661671168169170new sencreportrarl0ourevortuulo. uhis->reoortuurosoraulr nsoraunhrecipientEmail: Srecipientl'email'].recipientName: Srecipient'name' ?? null.fileName: SfileName,typeName: $typeNameteamsName: SteamsNameperiodName: $periodName,1SASKJ1m1nny: $1SASKJ1m1nny,SdispatchCount++Sloqger->info(self::LOG PREFTXDispatched mail job', I'uuid' => Sthis->reportUuid'email' => Srecipientl'email'.1):$logger->info(self::LOG_PREFIX . ' Successfully dispatched mail jobs'. ["UU1d" = suhls->reporcuuld"count" = palspauchcount,1);} catch (Throwable $e) 1$loager->error(self::LOG PREFIX' Error processing report'. I'uuid' => $this->reportUuid''error' => $e->getMessageo'trace' => $e->getiraceAsStringO,I);/ Get current attempt (1-1ndexed)sattempt = sthis->attemptso;if (Sattemot < Sthis->tries) {$delay = 30 * (2 ** ($attempt - 1)): // Exponential backoff: 30s, 60sSloqger->info(self::LOG PREFTX"retry iob. attemots:'.$attempt, ['delay' => $delay.1):sthis->release(sdelay);selse ?sthis->fall(se);* Get a unique ID for the job.* dreturn string*/public function uniqueldo: stringl...Support Daily • in 33 m100% [45)Tue 14 Apr 14:27:54AutomatedReportsCommandTestv& console PROD& console (EU]L console [STAGING XSo jiminny v:16 14 V.13= custom.log= laravel.logL SF (iminny@localhostc HS_local fiminny@localhost)520-521522523524525526528529550531540541542543544545546— 547548549559-552553054555556557558566564563565566567568V569570Ty: Auto vPlayground vt.owner id FROM social accounts saJOIN users u on u.id = sa.sociable idJOIN teams t 1..n‹->1: on t.id = u.team idWHERE U.team_id = 1 and sa.provider = 'salesforce";select * from teams where 1d = 1:select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1select * trom groups where 10 = 505;select * trom playdooks wnere team_1d = 1;select * tron •lavoooks Wnere 10 = 15.select * troiplaybook_cacegories where playdook_1d = 1/5;select * fronusers Mere teaio =select * fromusers where id = 7160;select * from crm profiles where user id = 7160:select * from features:select# 1d, uuld, type, provider, playbook_category_1d, user_1d, Lead_1d, contact_1d, account_1d, opportunity_1d, stage_1d,# crm_configuration_1d, crm_provider_1d, transcription_1d, statustron aculviules where cri_contiguracion_1d = 1 and type =# and crm nroviden id TS NOT NULLI"conterenceand provider != 'uploader'and actual start time IS NOT NULIUkurk ov no deschselect * from activities where id = 54747783: # 00U0400000pCzoiMACselect p.id, p.activity type, pc.id, pc.nameFROM playbooks pJoln playbook_categories pc 1<->l.n: on p.1d = pc.playbooK_1dwhere p.team_1d = 1 and p.activity_type = 'event'*SELECI * FROM CrM_TLeLaS wHERE crm_contiguration_1d = 1 and object_type = event?SELECI * FROM CrM_TIeLd_VaLUES wHERE crM_TLeLd_1d = 4;select * trol criavours cl oun oavoook avours or K"n on CL.0 = OL.avOUT 1where crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams:SELECT r.* FROM automated reports rjoin teams t on r.team id = t.idWHERE r.frequency ='dally"and r.status = 1AND t.status = 'active'AND (r.exptres ar >= now uk r.exptres au Is NULL):select * from automated_report_results where report id IN (18, 33);select x ToIactivity searches whereid = 10932:select * from activity search_filters where activity search_ id = 10932:select * from automated_reports order by id desc;select * from automated_report_results where cepont.id IN (36);571W Windsurf Teams60:14UTF-8ia 4 spaces...
|
NULL
|
NULL
|
NULL
|
12623
|