|
12721
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProject v© EmailMessageRepository.p© GenericAiPromptRepositor:© GroupRepository.phpInboxEmailBatchRepositoryInboxRepository.php© InvitationRepository.php© JobRepository.php© LanguageRepository.php© MomentRepository.phpNotificationRepository.php©ParticipantRepository.php© ParticipantSpeechReposito© ParticipantStatsRepository© PlaybookCategoryRepositc© PlaybookRepository.php© PlaylistActivityRepository.f© PlaylistRepository.phpPlaylistShareRepository.ph© QuestionRepository.phpC) RoleChangeEventRepositol© RoleRepository.php© SearchRepository.php© SnapshotRepository.php© SocialAccountRepository.p© StageRepository.php© SubscriptionSetRepository.© TaskRepository.php© TeamAiContextRepository.© TeamDomainsRepository.p©TeamInsightsRepository.pt©TeamRepository.php©ThemeRepository.php© TimezoneRepository.php©TopicRepository.php© ToрicTriggerRepository.ph©TrackRepository.php© TranscriptionModelLocaleF© TranscriptionRepository.ph© TranscriptionSummaryRepr© UserRepository.php© VocabularyRepository.php› D Rulesv _ Services> D Activity> D AjReports> D AvatarCalendarC ConferenceD Crm› D Import> MInternalv MKioskv M AutomatedReports(C) ActivityTypeService.© AskJiminnyReportAc© AutomatedReportsCi© AutomatedReportsS:© DealStagesService.p© RecipientsService.ph© ReportController.php© SendReportJob.php©AutomatedReportsSendCommand.php›© AutomatedReportsRepository.phpAutomatedReportsCommand.phpAddLayoutchuitles.onp© Team.phpAutomatedReportsService.phpу Ігаскrrovlderinstalleacventone© CreateActivityLoqgedEvent.phpUserPilotAcuiviiyListener.ono© ActivityLogged.php© AutomatedReportsCallbackService.phpRequestGenerateReportJob.php(C) AutomatedReport.php© RequestGenerateAskJiminnyReportJob.php© AutomatedReportResult.php165216531654165716581659166016611662166316641665166616671668166916701671167216731674public function shouldSendReport(array $users, ?CarbonInterface $547if (empty($users)) {return talse.- 042550E551$earliestTz = collect($users)5525531676->mapWithKeys(function (array $user) {554$tz = new DateTimeZone(Suser['timezone' ]):1678$nowUtc = new DateTime( datetime: 'now', new DateTimeZo 5561679sottset = su2->geuurrsec(snowutc):1116861681return [$user['timezone'] => $offset]:[CREDIT_CARD]->sortDesc()->keys()->first():558559560561562563168616871688$now = Carbon::now($earliestTz);565$isScheduLedTime = (int) $now->format ( format: "H') =a= self:=6566168916901691if ($isScheduledTime) {return true;568 v169216931694return $this->hasPassedScheduledTime($generatedAt, SearliestT57216951696526class AuronaredrenortsservlceA 102 X3 X34 A V Q 527pubLic tunccion gecacciviclestouncrayloadlarray +inputraycoaa): c528'report_type' => $validatedData['type'],'from_date' => $fromDate->format( format: DateTimeInterface530'to_date' => $toDate->format( format: DateTimeInterface:: RF 531'call_deal_stage' →> $validatedData['deal_at_call_stages'532'current_deal_stage' => $validatedData['current_deal_stag533'deal_min_value' => $validatedData['deal_value_min'] ?? r534'deal_max_value' => $validatedData['deal_value_max'] ?? r535'call_types' => $validatedData['call_types'],536'call_duration_min_seconds' > $validatedData['call_durat537'call_duration_max_seconds' => $validatedData['call_durat538'special_requirements' => $validatedData['additional_prom539'Playbook_categories' => $validatedData['playbook_categor 540'request_id' => null,'callback_url' => null,542543544—5459 usagesousages1697Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)nublic function hasPassedScheduledTime(PCarbonInterface Saeneratelibl= custom.log= laravel.log4 HS_local [jiminny@localhost]A SF [jiminny@localhost]console PRODIx. AutovPlayground v< console LUiconsole slAGingSa jiminny ~017 A15 X 13 AJOIN users u on u.id = sa.sociable_idJOIN teams ton tld z U.tean lolWHERE U.team_id = 1 and sa.provider = 'salesforce';select x TroIrealls wnere 10 =1seLect x Trogroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id wselect * fromgroups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * fromusers where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * tron reacures.setect#id, uuid, type, provider, playbook_category_id, user_idLead 10, concac# crm_configuration_id, crm_provider_id, transcription_id,sldlusfrom 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 =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 =where crm_configuration_id = 1 and pl.playbook_id = 175;select * tron teans.SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r. Enequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expicescat >= now() OR r.expicesaat IS NULL):select * from automated_report_results where ceport.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 ig desc;select * from automated_report_results order by id desg;select * from automated_report_results where cepontaid IN (36);CascadeNew Cascadej Support Daily • in 28 mAAutomatedReportsCommandTestv100% [8Tue 14 Apr 14:32:46+D ...eCascade Code #0CKick off a new project. Make changesacross your entire codebaseAutomatedReportsService.php app/Service• Team.php a•AutomatedReport.php• AutomatedReportResult.php app/ModelsSendReportJob.php app/Jobs/AutomatedRepo..."Activitv ogaed.ono• AddLayoutEntities.php app/Console/Command..AutomatedReportsRepository.php app/ReposReportController.php app• RequestGenerateReportJob.php app/Jobs/Au• UserPilotActivityListener.phpWalk me through the logic for @file:< CodeClaude Sonnet 4.6W Windsurf Teams16/0:0luir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12721
|
|
12722
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahl• Support Daily • in 28 mlec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zsh-zsh100% 197Tue 14 Apr 14:32:4718186-zshO 87* Unable to acce...* *8],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12722
|
|
12723
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahl• Support Daily • in 28 mlec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh100% 197Tue 14 Apr 14:32:4918186-zshO 87* Unable to acce...*- *8],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12723
|
|
12724
|
PhpStormFileEditViewNavigateCodeLaravelRefactorFV PhpStormFileEditViewNavigateCodeLaravelRefactorFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProject v© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeam'sD TracksD TranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DelereoeAcimnorescc Deleress eroverscom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebhoGroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p© JiminnyCacheClearCom©JiminnyDebugCommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLivecoaching© Managescim-orleam.p(c Malkoanchrorenvironnc 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.phpAadLayoutchutles.onC) Team.php= custom.log= laravel.logC AutomatedReportsRepository.php< Hs local liminnyalocalnostA SF [jiminny@localhost]A console [PROD]© AutomatedReportsService.php) CreateActivityLoggedEvent.php© TrackProviderInstalledEvent.php© ActivityLogged.phpA console [EU]A console [STAGING]•Automareakeporscallbackservice.ongC RequestGenerateAskJiminnyReportJob.phpRequestGeneratereporJob.ong© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Commandx:Auto vmo liminnvvJOIN users u on U.id = s u017 M15 713 ^ VJOIN teams t1..n<->1: on t.id = u.team_idWHERE U.team_id = 1 and sa.provider = 'salesforg25 GT32 Gt35 C3941CдS Р S S* The name and sianature of the console command.* Ovar string*/protected $signature = 'automated-reports:send';* The console command description.* Ovar stringprotected Sdescription = 'Sends automated reports based on user timezone':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();$repo = app( abstract: AutomatedReportsRepository::class);5265285295305315495505515525535545555561--557foreach ($reportResults as $reportResult) {** @var AutomatedReportResult SreportResult */1568$validRecipients = $this->automatedReportsService-›getVaLidRecipientUsers (SreportReS! 561if ($this-›automatedReportsService->shouldS/endReport(SvalidRecipients, $reportResult 562$this->logger->info(self::LOG_PREFIX .' Dispatching job',563'uuid' => $reportResult->getUuid(),5641):565$this->dispatcher->dispatch(new SendReportJob($reportResult->getUvid))):sellect * Fron teans wnere lo aiiaselect * from groups g JOIN playbooks p 1..n<->1:select * from aroups where id = 565:select * from plavbooks where team id = 1:select * fromplaybooks where id = 175;select * from playbook_categories where playbookselect * fromusers where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uuid, type, provider, playbook_category_idtrom aotavitues whene cmn.Confagunation. t a 1%# and crm_provider_id IS NOT NULLand provider !='uploader' and actual_start_timeORDER by id desc;select * from activities where id = 54747783; #y select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc"->lan: on p.1d = pwhere p.team_id = 1 and p.activity_type = 'eventSELECT * FROM crm_fields WHERE crm_configurationSELECT * FROM crm_field_values WHERE crm_field_iselect * from crm_layouts cl join playbook_layeuwhere crm_configuration_id = 1 and pl.playbook_iselect * from teams;SELECT r.* FRON automated_reports rjoin teams t on r.team.ig = t.idWHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exRicanat >= now() OR r.exkinesnat IS NUselect * from automated_report_results where heR568 vselect * from activity_searches where id = 10932select * from activity_search_filters where actiselect * from automated_reports order by id descselect * from automated_report_results order byse lect * tron auronared redort resuutsiwhere ceg570return CommandALias: : SUCCESS;Pusnea 1 commit to oricin/Jy-loy0g-automated-repors-ask- iminny View pull request loday 13.29liblCascadeNew Cascadej Support Daily • in 28 mA100% (8Tue 14 Apr 14:32:49AutomatedReportsCommandTestv+0 •ewCascade Code #0CKick off a new project. Make changesacross your entire codebaseAutomatedReportsService.php• Team.php at•AutomatedReport.php• AutomatedReportResult.php app/Models• SendReportJob.php app/Jobs/AutomatedRepol"Activitv ogaed.onoAddLayoutEntities.php app/Console/Command.AutomatedReportsRepository.php app/ReposReportController.php app• RequestGenerateReportJob.php app/Jobs/Au• UserPilotActivityListener.phpWalk me through the logic for @file:< CodeClaude Sonnet 4.6W Winasunt leams57:56uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12724
|
|
12725
|
PhpStormFileEditViewProject vNavigateCodeLaravelRe PhpStormFileEditViewProject vNavigateCodeLaravelRefactorFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelp© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeamsD TracksTranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DelereoeAcimnorescc Deleress eroverscom(C DevPostmanCommand.© DiarizeViaAiParticipantk# id, vvid, type, provider, playbook_category_id, user_id,# crm_configuration_id, crm_provider_id, transcription_id.35 GTpublic function -_construct(from activities where crm_configuration_id = 1 and type = *,private readonly LoggerInterface $logger,539# and crm_provider_id IS NOT NULL© EngagementStatsRegenprivate readonly AutomatedReportsRepository $reportRepository,540and provider != 'uploader' and actual_start_time IS NOT NULI© FeatureFlagsHelper.phpprivate readonly AutomatedReportsService $automatedReportsService,541ORDER by id desc;© FixCrossTenantlssues.pprivate readonly BusDispatcher $dispatcher,542select * from activities where id = 54747783; # 00U0400000pl543© FlushRolesPermissionsCparent: :__construct();544© GeneratelnternalWebho545GroupSetDefaultLangua546© HelperTruncateCoachin© HubspotJournalPollingC/**547select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc1<->1..n: on p.id = pc.playbook_iwhere p.team_id = 1 and p.activity_type = 'event';* Execute the console command.548© HubspotWebhookServic© ImportRecording.php46549oclee * rror crn telos wibke crn contlouraion 1o = anoSELECT * FROM crm_field_values WHERE crm_field_id = 4;ImportUsersFromCsvFil© IterateUsersCommand.f48* Qreturn int*/550551public function handle(): intc.liminnveacheclearcom552(©) JiminnyDebugCommanc553v select * from crm_layouts cl join playbook_layouts pl 1<->1where crm_configuration_id = 1 and pl.playbook_id = 175;(©) JiminnySetEncryptedTo(C) .JiminnvTokeninfoComm$reportResults = $this->reportRepository->getGeneratedNotSentResults();$repo = app( abstract: AutomatedReportsRepository::class);554555556© MakeSlackLiveCoachins© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.545556foreach ($reportResults as $reportResult) {557/** @var AutomatedReportResult SreportResult */558$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->getReport());559© PhpApm.phpif ($this->automatedReportsService->shouldsendReport($validRecipients,$reportResult->getGeneratedAt())). 4560© PropagateCoachingFeer$this->logger->info(self::LOG_PREFIX . ' Dispatching job', Iselect * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.ig = t.idWHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.exhiresaat >= now() OR r.exkiceinat IS NULL):© PurgeConferences.php'uvid' => $reportResult->getUuid(),1):© PurgeSoftDeletedOppor© PurgeSyncBatchesComi© RecalculateDealRisksCo$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuid()));(C) RemoveDeleteMarkersd© RemoveExpiredNudgesi© RemoveUnusedParticip:© ResetElasticSearch.phpreturn CommandAlias::SUCCESS:67© RestoreActivityCrmProv© RestoreActivityTypeCor562563564565566567568 v569570571572select * from automated_report_results where cepontoid IN Cselect * from activity_searches where id = 10932;select * from activity_search_filters where activity_search.select * from automated_reports order by id desc;select * from automated_report_results order by id desc;select * from automated_report_results where reportaid IN t© SeedActivities.php© SyncActivity.php© ReportController.php• AddLayoutEntities.php© SendReportJob.phpC Team.phpAutomatedReportsCommand.phpC AutomatedReportsRepository.php© TrackProviderInstalledEvent.phpAutomaleakeporscallbackoervice.ong© CreateActivityLoggedEvent.php© RequestGenerateAskJiminnyReportJob.phpC AutomatedReport.php© AutomatedReportsSendCommand.php x© AutomatedReportsService.php© UserPilotActivityListener.php© ActivityLogged.php© RequestGenerateReportJob.phpE custom.logE laravel.logA SF [jiminny@localhost]© CreateHeldActivityEvent.php< Hs local liminnyalocalnostconsole PRODIÁ console (EU]A console [STAGING] XC AutomatedReportResult.phpclass Auronaredreoorssenoconiano extenos conmanoiA1 лX:Auto vPlaygroundJOIN users u on u.id = sa.sociable_: mDo jiminny v017 A15 V.13 ^JOIN teams t 1.n<->1: on t.id = u.team_idWHERE U.team_id = 1 and sa.provider = 'salesforce':25 Ct32 GT/*** The name and signature of the console command.521522523524* @var stringprotected $signature = 'automated-reports:send';* ne consore conmane deseriorlon* Ovar stringprotected $description = 'Sends automated reports based on user timezone':527528529530531532533534533536537select * trom teams where 10 = 1select * from groups g JOIN playbooks p 1..n<->1: on g.playbcselect * fromgroups where id = 565;select x Tolplavbooks where team id = 1seLect * TroMplaybooks where id = 175:select * from playbook_categories where playbook_id = 175;select * fromusers where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;selectPushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)CascadeNew Cascadeliblj Support Daily • in 28 mAAutomatedReportsCommandTestv100% [2Tue 14 Apr 14:32:51+D..ewCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.AutomatedReportsService.php• Team.phpAutomatedReport.php• Automateakeponkesuitono app Modelsi• SendReportJob.php ap11Activitv ogaed.ohrAddLayoutEntities.php app/Console/Command...AutomatedReportsRepository.php app/Repos.ReportController.php a• RequestGenerateReportJob.php• UserPilotActivityListener.phpWalk me through the logic for @file:+ <› CodeClaude Sonnet 4.6W Winasunt leams5/:00uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12725
|
|
12726
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahl• Support Daily • in 28 mlec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh100% 197Tue 14 Apr 14:32:5118186-zshO 87* Unable to acce...* *8],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12726
|
|
12727
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 27 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER→₴81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO 87Tue 14 Apr 14:33:08181* Unable to acce...*8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12727
|
|
12728
|
PhpStormFileEditViewProject vNavigateCodeLaravelRe PhpStormFileEditViewProject vNavigateCodeLaravelRefactorFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelp© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeam'sD TracksTranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DelereoeAcimnorescc Deleress eroverscom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebhoGroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p© JiminnyCacheClearCom©JiminnyDebugCommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLivecoaching© Managescim-orleam.p(c Malkoanchrorenvironnc 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.phpAadLayoutchutles.onC) Team.php= custom.logC AutomatedReportsRepository.phpconsole PROD© AutomatedReportsService.php) CreateActivityLoggedEvent.php© TrackProviderInstalledEvent.php© ActivityLogged.php•Automareakeporscallbackservice.ongC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ongE laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING] >Tx: Auto vFlaycroundvJOIN users u on u.id = sa.sociable_idNureans tI.n<->I: on t.1d = U.team_1dWHERE U.team_id = 1 and sa.provider = 'salesforce';A HS_local [iminny@localhost]fajiminny017 A15 Х 13 ^© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command25 GT32 Gt35 C3941CдS Р S SA1 A* The name and sianature of the console command.* Ovar string*/protected $signature = 'automated-reports:send';15241525115241525526527528529530531532* The console command description.1554* Ovar string550protected Sdescription = 'Sends automated reports based on user timezone':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(): int538539540541542543154415451540154/5485495505515525535545551554$reportResults = $this->reportRepository->getGeneratedNotSentResults();$repo = app( abstract: AutomatedReportsRepository::class);foreach ($reportResults as $reportResult) {560** @var AutomatedReportResult SreportResult */561$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->g562if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getG563$this->logger->info(self::LOG_PREFIX ' Dispatching job', [564'uuid' => $reportResult->getUuid(),5651):566567$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuidO)):568 vselect x trol realllswhere id = 1select * tromgroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id wheselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * trom reatures;setect# id, uuid, type, provider, playbook category id, user id, lead id, contact# 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 pmonoavoook carecones 0e1<->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 = '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 = plwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;ocLeur* rhur auronared redorusrjoin teams t on r.teamid = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r. expicescat >= now() OR r.expicesaat IS NULL):select * from automated_report_results where repont.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 id desc;select * from automated_report_results order by id deso;select * from automated_report_results where cepontaid IN (36);return CommandALias: : SUCCESS;570571572Pusnea 1 commit to oricin/Jy-loy0g-automated-repors-ask- iminny View pull request loday 13.29CascadeNew Cascade40halSupport Daily • in 27 mAAutomatedReportsCommandTestv100% [Tue 14 Apr 14:33:08+D ...wCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.AutomatedReportsService.phpb Team.phpAutomatedReport.php• Automateakeponkesuitono app Modelsi• SendReportJob.php apf"Activitv ogaed.onoAddLayoutEntities.php app/Console/Command...• AutomatedReportsRepository.php app/Repos.ReportController.php apr• RequestGenerateReportJob.php app/Jobs/Au• UserPilotActivityListener.phpWalk me through the logic for @file:+ <› CodeClaude Sonnet 4.6W Winasunt leams5/:00uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12728
|
|
12731
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 27 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER→₴81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO 87Tue 14 Apr 14:33:16181* Unable to acce...*8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12731
|
|
12732
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 27 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER3 281DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO 87Tue 14 Apr 14:33:32181* Unable to acce...*- 88> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12732
|
|
12733
|
PhpStormFileEditViewProject vNavigateCodeLaravelRe PhpStormFileEditViewProject vNavigateCodeLaravelRefactorFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelp© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeam'sD TracksTranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DelereoeAcimnorescc Deleress eroverscom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebhoGroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p© JiminnyCacheClearCom©JiminnyDebugCommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLivecoaching© Managescim-orleam.p(c Malkoanchrocnvronnlc Mureu canzercnanner© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComiC)RecalculateDealRiskscd© RemoveDeleteMarkersC© RemoveExpiredNudgesi© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAadLayoutchutles.onC) Team.php= custom.logC AutomatedReportsRepository.phpconsole PROD© AutomatedReportsService.php© TrackProviderInstalledEvent.php© ActivityLogged.php•Automareakeporscallbackservice.ongC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ongE laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING] >Tx: Auto vFlaycroundvJOIN users u on u.id = sa.sociable_idNureans tI.n<->I: on t.1d = U.team_1dWHERE U.team_id = 1 and sa.provider = 'salesforce';A HS_local [iminny@localhost]fajiminny017 A15 Х 13 ^© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command25 GT32 Gt35 C394041M28 9 9A1 A* The name and sianature of the console command.* Ovar string*/protected $signature = 'automated-reports:send';15241525115241525526527528529530531532* The console command description.1554* Ovar string550protected Sdescription = 'Sends automated reports based on user timezone':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.* @return int*/public function handle(): int538539540541542543154415451540154/5485495505515525535545551554$reportResults = $this->reportRepository->getGeneratedNotSentResults();$repo = app( abstract: AutomatedReportsRepository::class);foreach ($reportResults as $reportResult) {560** @var AutomatedReportResult SreportResult */561$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->g562if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getG563$this->logger->info(self::LOG_PREFIX'Dispatching job', I564'uuid' => $reportResult->getUuid(),5651):566567$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuidO)):568 vselect x trol realllswhere id = 1select * tromgroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id wheselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * trom reatures,setect# id, uuid, type, provider, playbook category id, user id, lead id, contact# 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 pmonoavoook carecones 0e1<->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 = '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 = plwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECI r.* FRUn aucomaced_reporus rjoin teams t on r.teamid = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r. expicescat >= now() OR r.expicesaat IS NULL):select * from automated_report_results where repont.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 id desc;select * from automated_report_results order by id deso;select * from automated_report_results where cepontaid IN (36);570571rerurn couliondAues.rouleroo.Pusnea 1 commit to oricin/Jy-loy0g-automated-repors-ask- iminny View pull request loday 13.2940halSupport Daily • in 27 mAAutomatedReportsCommandTestv100% [Tue 14 Apr 14:33:33CascadeNew Cascade+D ...eCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.• Fix Automated kepons commane lestrixing ask dimimny kepont acuvily couny( Automated Report Manual TriggerWalk me through the logic for @AutomatedReportsSendCommand.php | have 7 results found but nothing is sent.+ ‹> Code |Claude Sonnet 4.6W Winasunt leams57:56uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12733
|
|
12734
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 27 m100% <47ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER€ 881DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO 87Tue 14 Apr 14:33:39181* Unable to acce...*- 88> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12734
|
|
12735
|
PhpStormFileEditViewProject vNavigateCodeLaravelRe PhpStormFileEditViewProject vNavigateCodeLaravelRefactorFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelp© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackeam'sD TracksTranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DeleredoAcimnorescc Deleressterovescom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen€ FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebhoGroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p© JiminnyCacheClearCom©JiminnyDebugCommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLivecoaching(c) Manacescim-or eam.o(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.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAadLayoutchutles.onC) Team.php= custom.logA HS_local [iminny@localhost]C) AutomatedReportsRepository.phpconsole PROD© AutomatedReportsService.php) CreateActivityLoggedEvent.php© TrackProviderInstalledEvent.php© ActivityLogged.php•Automareakeporscallbackservice.ongC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command25 GT32 Gt35 C394160* The name and sianature of the console command.* Ovar string*/protected $signature = 'automated-reports:send';15241525115241525526527528529530531532* The console command description.1554* Ovar string550protected Sdescription = 'Sends automated reports based on user timezone':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 intpublic function handle(): int538539540541542543154415451540154/5485495505515525535545551554$reportResults = $this->reportRepository->getGeneratedNotSentResults();foreach ($reportResults as $reportResult) {/** @var AutomatedReportResult $reportResult */560$validRecipients = $this->automatedReportsService->getValidRecipienfusers(SreportResult->g561if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getG562$this->logger->info(self::LOG_PREFIX'Dispatching job',563I):'uvid' => $reportResult->getUuid(),564565566$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuid())):567568Vreturn connondacos..succros.570571572Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)E laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING] XTx: Auto vFlaycroundvJOIN users u on u.id = sa.sociable_idNureans t1.n<->1: on t.id = u.team_idWHERE U.team_id = 1 and sa.provider = 'salesforce';fajiminny017 A15 Х 13 ^select x trol realllswhere id = 1select * tromgroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id wheselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * trom reatures,setect# id, uuid, type, provider, playbook category id, user id, lead id, contact# 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 playdooks pmonoavoook carecones 0e1<->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 = '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 = plwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECI r.* FRUn aucomaced_reporus rjoin teams t on r.teamid = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r. expicescat >= now() OR r.expicesaat IS NULL):select * from automated_report_results where repont.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 id desc;select * from automated_report_results order by id deso;select * from automated_report_results where cepontana IN (36);halSupport Daily • in 27 mAAutomatedReportsCommandTestv100% [Tue 14 Apr 14:33:39CascadeNew Cascade+D..wCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.• Fix Automated kepons commane lestrixing ask dimimny keport acuvily couny( Automated Report Manual TriggerWalk me through the logic for @AutomatedReportsSendCommand.php | have 7 results found but nothing is sent.+ ‹> Code |Claude Sonnet 4.6winasun leamsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12735
|
|
12736
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 27 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER₴81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO ₴7Tue 14 Apr 14:33:44181* Unable to acce...K 888> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12736
|
|
12737
|
PhpStormFileEditViewProject vNavigateCodeLaravelRe PhpStormFileEditViewProject vNavigateCodeLaravelRefactorFV faVsco.s v#11894 on JY-18909-automated-reports-ask-liminny ~ToolsWindowHelp© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpISackeam'sD TracksTranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.p(e) Database aoecount.oic DeleredoAcimnorescc Deleress eroverscom(C DevPostmanCommand.© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebho© GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.f© JiminnyCacheClearCom(C) JiminnyDebugCommanc(©) JiminnySetEncryptedTo(cJminnv okenintocomm© MakeSlackLiveCoachins© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComiC)RecalculateDealRiskscd(C) RemoveDe leteMarkersa© RemoveExpiredNudgesiC) RemoveUnusedParticio.© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.php© AutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAadLayoutchuitles.onp= custom.logA HS_local [iminny@localhost]c leam.ongC AutomatedReportsRepository.phpconsole PROD© AutomatedReportsService.php) CreateActivityLoggedEvent.phpC AutomatedReportsCallbackService.phpCreateHeldActivityEvent.php© UserPilotActivityListener.phpC RequestGenerateAskJiminnyReportJob.php© TrackProviderInstalledEvent.php© ActivityLogged.phpRequestGeneratekeporJob.ong© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command15241525125 Ct32 635 Gt374243444554signature of the console command.auure - aurolareo-reoorrs.seno525526527528529530531532conmana desci docdon.1554550ription = 'Sends automated reports based on user timezone':539__construct(donly LoggerInterface $logger,donly AutomatedReportsRepository $reportRepository,donly AutomatedReportsService $automatedReportsService,donly BusDispatcher $dispatcher,onstruct();onsole command.handle(): int541542543154415451540154/5485495505515525535545551554lts = $this->reportRepository->getGeneratedNotSentResUlts();eportResults as $reportResult) {C AutomatedReportResult $reportResult */ecipients = $this-›automatedReportsService->getVal.iRecipierftUsers($reportResult->getReport());is->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getGeneratedAt())) €is->logger->info(self::LOG_PREFIX . ' Dispatching job', ['vuid' => $reportResult->getUuid(),560561562is->dispatcher->dispatch(new SendReportJob($reportResult->getUvid)):564565566567568VandAT TAs.• SWNEESS"570571572Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)E laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING] XTx: Auto vFlaycroundvJOIN users u on u.id = sa.sociable_idNureans tI.n<->I: on t.1d = U.team_1dWHERE U.team_id = 1 and sa.provider = 'salesforce';fajiminny017 A15 Х 13 ^select x trol realllswhere id = 1select * tromgroups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id wheselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * trom reatures;setect# id, uuid, type, provider, playbook category id, user id, lead id, contact# 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 pmonoavoook carecones 0e1<->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 = '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 = plwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;ocLeur* rhur auronared redorusrjoin teams t on r.teamid = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r. expicescat >= now() OR r.expicesaat IS NULL):select * from automated_report_results where repont.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 id desc;select * from automated_report_results order by id deso;select * from automated_report_results where cepontana IN (36);halSupport Daily • in 27 mAAutomatedReportsCommandTestv100% ["Tue 14 Apr 14:33:43CascadeNew Cascade+D..wCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.• Fix Automated kepons commane lestrixing ask dimimny keport acuvily couny( Automated Report Manual TriggerWalk me through the logic for @AutomatedReportsSendCommand.php | have 7 results found but nothing is sent.+ ‹> Code |Claude Sonnet 4.6W Windsur leams55:80uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12737
|
|
12738
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 27 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER2-881DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO 87Tue 14 Apr 14:33:48181* Unable to acce...*8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12738
|
|
12739
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny ~Projectv© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© EmailMessageRepository.p© AutomatedReportsSendCommand.phg© AddLayoutEntities.phpC) Team.phpC AutomatedReportsRepository.php© GenericAiPromptRepositor:© GroupRepository.phpCreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpInboxEmailBatchRepository© UserPilotActivityListener.php© ActivityLogged.php520InboxRepository.phpC RequestGenerateAskJiminnyReportJob.phpRequestGeneratereporJob.ong© InvitationRepository.php© AutomatedReportResult.php© AutomatedReport.php© JobRepository.php© LanguageRepository.phpclass AutomatedReportsService'IUL Y.3 Y.34© MomentRepository.phpNotificationRepository.php578private function buildRecipientUsers(array $recipients): array579© ParticipantRepository.php580$userIds = $recipients['users'] ?? [];© ParticipantSpeechReposito© ParticipantStatsRepositoryreturn collect($userIds)© PlaybookCategoryRepositc->map(fn ($id) => $this->userRepository->find((int) $id))© PlaybookRepository.php->filter()© PlaylistActivityRepository.f->map(fn (UserContract $user) => [© PlaylistRepository.php'email'=> $user->getEmailAddress(),152415251OJ 52452552652752852953053153215551554PlaylistShareRepository.ph'name'=> $user-›getName(),© QuestionRepository.php'timezone' => Suser-›getTimezone()->getName(),C) RoleChangeEventReposito550© RoleRepository.php© SearchRepository.php© SnapshotRepository.php© SocialAccountRepository.p© StageRepository.php© SubscriptionSetRepository.© TaskRepository.php© TeamAiContextRepository.© TeamDomainsRepository.p©TeamInsightsRepository.pt©TeamRepository.php©ThemeRepository.php5925935945955965975985996001)->values()->alL:538—53954054114 usages542public function getValidRecipientUsers(AutomatedReport $report, bool $includeJiminnx = false):.[CREDIT_CARD]© TimezoneRepository.php©TopicRepository.php© ToрicTriggerRepository.ph©TrackRepository.php© TranscriptionModelLocaleF605© TranscriptionRepository.ph©TranscriptionSummaryReprif ($report->isAskJiminnyReport)) {$recipients = $this->resolveAskJiminJyRecipients($report);1 else {Srecipients = $this->getRecipientUsers($report);=548if ($includeJiminny) {549Srecipients = array_merge($recipients, $this->getJiminnyRecipientUsers($report));=550551552553$emails = [];5545551554© UserRepository.php© VocabularyRepository.php› D Rulesv D Services609610611> D Activity> D AjReports> D Avatar0 CalendarC ConferenceD Crm› D Import0141015010617618> MInternalv MKioskv M AutomatedReports(C) ActivityTypeService.© AskJiminnyReportAc620621622return array_values(array_filter($recipients,static function ($recipient) use (&$emails) {if (empty($recipient['email']) || in_array($recipient['email'], Semails,strict: true) 559return false;560561$emails[] = $recipient['email'];562-563recurn uruer564)):_565566567568VTusdyeprivate function resolveAskJiminnyRecipients(AutomatedReport $report): arrayESTO—571$recipients = [];572© AutomatedReportsCi© AutomatedReportsS:© DealStagesService.p© RecipientsService.phnorearor = reoort-poercrearor.if ($creator !== null) {Krecinientsll = 1= custom.logconsole PRODPushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)= laravel.logA SF [jiminny@localhost]A HS_local [iminny@localhost]A console (EU]A console [STAGING]Tx: Auto vPlaygroundJOIN users u on u.id = sa.sociable_idfajiminny017 A15 Х 13 ^Nureans tI.n<->I: on t.1d = U.team_1dWHERE U.team_id = 1 and sa.provider = 'salesforce';select * TroITealll'swhere id = 1select * tromgroups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id wheselect * fromgroups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * fromreacures;setect# id, uuid, type, provider, playbook category id, user id, lead id, contact# 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_cacegories pe1<->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 = '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 = plwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;ocLeur* rhur auronared redorusrjoin teams t on r.teamid = t.idWHERE r. Erequency = 'daily'and r.status = 1AND t.status = 'active'AND (r. expicescat >= now() OR r.expicesaat IS NULL):select * from automated_report_results where repont.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 id desc;select * tromautomated_report_results order by id deso;select * from automated_report_results where cepontana IN (36);halSupport Daily • in 27 mAAutomatedReportsCommandTestv100% [Tue 14 Apr 14:33:48CascadeNew Cascade+D..wCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.• Fix Automated kepons commane lestrixing ask dimimny kepont acuvily couny( Automated Report Manual TriggerWalk me through the logic for @AutomatedReportsSendCommand.php | have 7 results found but nothing is sent.+ ‹> Code |Claude Sonnet 4.6Winasun leams594:2uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12739
|
|
12740
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 27 m100% 197Tue 14 Apr 14:33:59181ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER- 281DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO ₴7* Unable to acce... →- *8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12740
|
|
12741
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-iminny ~Project v© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackM TeamsD TracksD TranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.p(e) Database aoecount.oic DelereoeAcimnorescc Deleress eroverscom® DevPostmanCommand./© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebhoGroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.fc.liminnveacheclearcom(©) JiminnyDebugCommanc© JiminnySetEncryptedTo(C) .JiminnvTokeninfoComm© MakeSlackLiveCoachins© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComi© RecalculateDealRisksCo(C) RemoveDeleteMarkersd© RemoveExpiredNudgesi© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAadLayoutchutles.onc leam.ongC) AutomatedReportsRepository.php© AutomatedReportsService.phpTrackProviderInstalledEvent.php© ActivityLogged.php•Automareakeporscallbackservice.ongC RequestGenerateAskJiminnyReportJob.php© AutomatedReportResult.phpe AutomatedRenort.onnclass AutomatedReportsSendCommand extends CommandRequestGeneratekeporJob.ong25 Ct32 Ct3941445556*Ine nome one stondrure ot wne consore commana.*ovar scringprotected $signature = 'automated-reports:send';/*** The console command description.* Ovar stringprotected $description = 'Sends automated reports based on user timezone';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.* Qreturn intpublic function handle(): intforeach ($reportResults as SreportResult) {** ovar Automoredkedortresuur oredortkesur */$this->logger->info(self::LOG_PREFIX1):$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuid()));return CommandALias: : SUCCESS;Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)40halSupport Daily • in 27 mAAutomatedReportsCommandTestv100% [Tue 14 Apr 14:33:59CascadeNew Cascade+D..= custom.logA HS_local [iminny@localhost]console PROD52052152252415251154015275285295305315325335345351554155000%540541542543544545546547154815475505515525535545555561558562563564565566567568 v569570571572= laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.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';fajiminny017 A15 Х 13 ^select * tron reans where 1o =15select x tron groupsg suin playpooks p1.n<->1: on g.playbook_id = p.id winselect x Tolgroupsnere t =oo.select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vvid, type, provider, playbook_category_id, user_id, lead_id, contact* cri conmouracionorciri orovoer LorTranscruomion dor starusfrom 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 pc1<->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 = •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 = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'activelAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaig 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 order by id desc;select * from automated_report_results where repontaid IN (36);wCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.• Fix Automated kepons commane lestrixing ask dimimny keport acuvily couny( Automated Report Manual TriggerWalk me through the logic for @AutomatedReportsSendCommand.php | have 7 results found but nothing is sent.+ ‹> Code |Claude Sonnet 4.6w Windsunt leams5:/uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12741
|
|
12742
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ahl• Support Daily • in 26 mlDOCKER25981DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh100% 197Tue 14 Apr 14:34:0918186-zshO 87* Unable to acce...* *8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12742
|
|
12743
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProjectv© ReportController.php© EmailMessageRepository.p© GenericAiPromptRepositor:© GroupRepository.phpInboxEmailBatchRepositoryInboxRepository.php© InvitationRepository.php© JobRepository.php© LanguageRepository.php© MomentRepository.phpNotificationRepository.php©ParticipantRepository.php© ParticipantSpeechReposito© ParticipantStatsRepository© PlaybookCategoryRepositc© PlaybookRepository.php© PlaylistActivityRepository.f© PlaylistRepository.phpPlaylistShareRepository.ph© QuestionRepository.phpC) RoleChangeEventReposito© 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© ToрicTriggerRepository.ph©TrackRepository.php© TranscriptionModelLocaleF© TranscriptionRepository.ph© TranscriptionSummaryRepr© UserRepository.php© VocabularyRepository.php› D Rulesv _ Services> D Activity> D AjReports> D Avatar0 CalendarC ConferenceD Crm› D Import> MInternalv MKioskv M AutomatedReports(C) ActivityTypeService.© AskJiminnyReportAc© AutomatedReportsCi© AutomatedReportsS:© DealStagesService.p© RecipientsService.phAulomaleakeporissendcommand.ongCrealencuivityLoggeaeventone© SendReportJob.phpAutomatedReportsCommand.php© AddLayoutEntities.php© Team.phpAutomatedReportsRepository.phpCreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© ActivityLogged.phpC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsServiceBMSMS44public function getActivitiesCountPayload(array $inputPayload): array1654'to date' => StoDate->formatd format: DateTimeInterface::RFC3339),1655'call_deal_stage' => $validatedData['deal_at_call_stages'] ?? []1656'current_deal_stage' => $validatedData['current_deal_stages'] ?? [].1657'deal_min_value' => $validatedData['deal_value_min'] ?? null,1658'deal_max_value' => $validatedData['deal_value_max'] ?? null,'call_types' => $validatedData['call_types'],'call_duration_min_seconds' →> $validatedData['call_duration_min'] ?? null,'call_duration_max_seconds' →> $validatedData[ 'call_duration_max'] ?? null,'special_requirements' => $validatedData['additional_prompt_input'] ?? null,1663'playbook_categories' => $vaLidatedData['playbook_categories'] ?? [],1664'request_id' = null,1665'caLLDacK_UrL = nuLL,1666166716689 usages16691670167116721673167416751676167716781679168016811682public function (shouldSendReport(array $users, ?CarbonInterface $generatedAt = null): boolif (empty($users)) {return false;$earliestTz = collect($users)->mapWithKeys(function (array $user) {$tz = new DateTimeZone($user['timezone']);$nowutc = new DateTime( datetime: 'now', new DateTimeZone( timezone:) 'UTC'));$offset = $tz->getoffsI&t($nowutc);return [$user['timezone'] => $offset];->sortDesc()->keys()->firstO:16861687100816891690169116921693169416951696onow = caroon..nowneartrestiz.$isScheduLedTime = (int) $now->format( format: 'H') === self::SENT_REPORT_AT_HOURS;if ($isScheduledTime) {rerurn uruerreturn $this->hasPassedScheduledTime($generatedAt, $earliestTZ);5 usages16971716public function hasPassedScheduledTime(?CarbonInterface $generatedAt, string $timezone): boolf...7e117171171817196 usagespublic function calculateFromAndToDatePeriod(string $frequency,Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)liblj Support Daily • in 26 mAAutomatedReportsCommandTestv100% [Tue 14 Apr 14:34:09CascadeNew Cascade+D..520521522v 0J 523524= custom.logE laravel.logconsole PRODA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.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';A HS_local [iminny@localhost]1540152752852953053153253353453555 A—550539540541542543=545- 546=5471548=5495505515525535545555561558SO.566567568 v569fajiminny017 A15 Х 13 ^select * tron reans where 1o =15select x tron groupsg suin playpooks p1.n<->1: on g.playbook_id = p.id winselect * 1r0Igroupsnere t =oo.select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# 10, Uu1d, type, proviaer, playbook_cacegory-1a, user_la, Lead_ia, concact* cri conmouracionorcirn orovoer LorTanscruomon or starusfrom 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"->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 object_type = •SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status =aciveAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaig 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 * fromautomated_report_results order by id desd;select * from automated_report_results where repontaid IN (36);wCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.• Fix Automated kepons commane lestrixing ask dimimny kepont acuvily couny( Automated Report Manual TriggerWalk me through the logic for @AutomatedReportsSendCommand.php | have 7 results found but nothing is sent.+ ‹> Code |Claude Sonnet 4.6W Windsurf Teams1609.2uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12743
|
|
12744
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ahl• Support Daily • in 26 ml100% 197DOCKER€ 881DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO ₴7Tue 14 Apr 14:34:12181* Unable to acce...*8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12744
|
|
12745
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProjectv© ReportController.php© EmailMessageRepository.p© GenericAiPromptRepositor:© GroupRepository.phpInboxEmailBatchRepositoryInboxRepository.php© InvitationRepository.php© JobRepository.php© LanguageRepository.php© MomentRepository.phpNotificationRepository.php© ParticipantRepository.php© ParticipantSpeechReposito© ParticipantStatsRepository© PlaybookCategoryRepositc© PlaybookRepository.php© PlaylistActivityRepository.f© PlaylistRepository.phpPlaylistShareRepository.ph© QuestionRepository.phpC) RoleChangeEventReposito© 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© ToрicTriggerRepository.ph©TrackRepository.php© TranscriptionModelLocaleF© TranscriptionRepository.ph© TranscriptionSummaryRepr© UserRepository.php© VocabularyRepository.php› D Rulesv _ Services> D Activity> D AjReports> D Avatar0 CalendarC ConferenceD Crm› D Import> MInternalv MKioskv M AutomatedReports(C) ActivityTypeService.© AskJiminnyReportAc© AutomatedReportsCi© AutomatedReportsS:© DealStagesService.p© RecipientsService.phAulomaleakeporissendcommand.ong© SendReportJob.phpAutomatedReportsCommand.php© AddLayoutEntities.php© Team.phpAutomatedReportsRepository.phpCreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© ActivityLogged.phpC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsServiceBMSMS44public function getActivitiesCountPayload(array $inputPayload): array1654'to date' => StoDate->formatd format: DateTimeInterface::RFC3339),1655'call_deal_stage' => $validatedData['deal_at_call_stages'] ?? []1656'current_deal_stage' => $validatedData['current_deal_stages'] ?? [].1657'deal_min_value' => $validatedData['deal_value_min'] ?? null,1658'deal_max_value' => $validatedData['deal_value_max'] ?? null,'call_types' => $validatedData['call_types'],'call_duration_min_seconds' →> $validatedData['call_duration_min'] ?? null,'call_duration_max_seconds' →> $validatedData[ 'call_duration_max'] ?? null,'special_requirements' => $validatedData['additional_prompt_input'] ?? null,1663'playbook_categories' => $vaLidatedData['playbook_categories'] ?? [],1664'request_id' = null,1665'caLLDacK_UrL = nuLL,166616671668susaees100%16701671167216731674167516761677167816791680168116821683public function shouldSendReport(array $users, ?CarbonInterface $generatedAt = null): boolif (empty($users)) {return false;$earliestTz = collect($users)->mapWithKeys(function (array $user) {$tz = new DateTimeZone($user['timezone']);$nowUtc = new DateTime( datetime: 'now', new DateTimeZone(timezone:'UTC'));$offset = $tz->get0ffslet($nowUtc);return [$user['timezone'] => $offset];->sortDesc()->keys()->firstO:1686111687168816891690169116921693169416951696onow = caroon..nowneartrestiz.$isScheduLedTime = (int) $now->format( format: 'H') === self::SENT_REPORT_AT_HOURS;if ($isScheduledTime) {rerurn uruerreturn $this->hasPassedScheduledTime($generatedAt, $earliestTZ);5 usages16971716public function hasPassedScheduledTime(?CarbonInterface $generatedAt, string $timezone): boolf...7e117171171817196 usagespublic function calculateFromAndToDatePeriod(string $frequency,Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)liblj Support Daily • in 26 mAAutomatedReportsCommandTestv100% [Tue 14 Apr 14:34:12CascadeNew Cascade+D ..522v 0J 523= custom.logE laravel.logconsole PRODA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.owner_id FROM social_accounts sa520JOIN 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';A HS_local [iminny@localhost]1540152752852953053153253353453555 A=050539540541542543544-545- 546=5471548=5495505515525535545555561558SO.5665671568 v569fajiminny017 A15 Х 13 ^select * tron reans where 1o =15select x tron groupsg suin playpooks p1.n<->1: on g.playbook_id = p.id winselect * 1r0Igroupsnere t =oo.select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# 10, Uu1d, type, proviaer, playbook_cacegory-1a, user_la, Lead_ia, concact* cri conmouracionorciri orovoer LorTanscruomon or starusfrom 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"->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 object_type = •SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status =aciveAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaig 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 * fromautomated_report_results order by id desd;select * from automated_report_results where repontaid IN (36);wCascade Code x • .Kick off a new project. Make changesdeross your cnule couebase.• Fix Automated kepons commane lestrixing ask dimimny keport acuvily couny( Automated Report Manual TriggerWalk me through the logic for @AutomatedReportsSendCommand.php | have 7 results found but nothfgg is sent.+ ‹> Code |Claude Sonnet 4.6winasun leams16/9.38uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12745
|
|
12757
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER0 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 24 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zsh-zsh86-zshO ₴7Tue 14 Apr 14:36:33181* Unable to acce...*8],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12757
|
|
12762
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 24 m100% <47Tue 14 Apr 14:36:57181ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zsh-zsh86-zshO ₴7* Unable to acce...],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12762
|
|
12763
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER0 881DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahl• Support Daily • in 23 ml100% 147ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO 87Tue 14 Apr 14:37:02181* Unable to acce...€ *8],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12763
|
|
12764
|
PhpStormFileFditViewNavigateCodeLaravelPetactonToo PhpStormFileFditViewNavigateCodeLaravelPetactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny ~Project v© EmailMessageRepository.pC) GenericAiPromptRepositorg grouprepository.phpInboxEmailBatchRepositonC InboxRepository.php© InvitationRepository.pnpC) JobRepositorv.ohpC LanquageRepository.phpC MomentRepository.phpNotificationRepositorv.php© ParticipantRepository.phpC ParticipantSpeechRepositoC ParticipantStatsRepository© PlaybookCategoryRepositcg Playbookkepository.phpPlaylistActivityRepository.pPlaylistRepository.php(C) PlavlistShareRepositorv.ph© QuestionRepository.phpC) RoleChangeEventRepositol(C) RoleRepository.php(©) SearchRepository.php©) SnapshotRepository.php©) SocialAccountRepository.pC StageRepository.php© SubscriptionSetRepository.© TaskRepository.php© TeamAiContextRepository.© TeamDomainsRepository.pC) TeaminsiahtsRepositorv.phC TeamRepository.phpC) ThemeRepository.php(C) TimezoneRepository.phpC TopicRepository.phpC TopicTriggerRepository.ph© TrackRepository.php© TranscriptionModelLocaleF© TranscriptionRepository.ph© TranscriptionSummaryRepC UserRepository-php© VocabularyRepository.pnp› D Rulesv _ Services>→ Activity> D AjReports>D AvatarlcalendarConterenceM erm> D Import> MInternalv MKioskv M AutomatedReports(C) ActivityTypeService.(©) AskJiminnyReportAc(C) AutomatedReportsC(©) AutomatedReportsSi© DealStagesService.p(© RecipientsService.ph(©) ReportController.phpC SendReportJob.php(©) AutomatedReportsCommand.php= custom.loc= laravel.logc SF liminny@localhost« HS_local fiminny@localhostC AutomatedReportsSendCommand.phgC AddLayoutEntities.phpC) Team.phpC) AutomatedReportsRepository.php© AutomatedReportsService.php© CreateHeldActivityEvent.phpe) TrackProviderinstallled-vent.ono(©) CreateActivityLoggedEvent.phpC UserPilotActivityListener.phpC ActivityLogged.php© AutomatedReportsCallbackService.phpC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong© AutomatedReportResult.php© AutomatedReport.phpconsole PROD4 console [EU1L console [STAGING]Tx: Auto vFlaycroundvt.owner_1d FROM soc1al_accounts sa52015211JOIN users u on u.1d = sa.soclable_1dJOIN teams tI.n<->I: on t.1d = u.team_1dWHERE U.team_1d = 1 and sa.provider = salestorce :163616631664100516661100.166816691672116751677167816791680168116821683168416851686168716881689169016911692116941OYA117171718171917201721172217231724172411720class AutomatedReportsservicepublic function getActivit1escountPayload(array s1nputPayload): array'playdook_categories'= $vaLidacedbatal playdook_categories'J !! lJ.'request_1d = nuLl,'callback url = nuul,A 102 V3 V34 ^V0J 523susaeespublic function shouldsendReport(array susers, ?Carbonintertace sgeneratedAt = null): boou1f (empty(susers))return false;15452752852953053153253315.5411555155455 Anearuestz = coulectcsusers)->mapWithKeys(function (array $user) 1$tz = new DateTimeZone($user['timezone']):SnowUtc = new DateTime datetime: 'now', new DateTimeZone( timezone: "UTC':Soffset = stz->get0ffset(Snowtc):return [suserl'timezone' => soffsetl;=05053954054154215431544->sortbesc()->Keys)->first(O:lnnow = varoonr.noynearuresciz.$isScheduledTime = (int) $now->format( format: 'H') === self::SENT_RESORT_AT_HOURS;if (SisScheduledTime)return true:•54=5471548=549550551552553554555556return sthis->hasPassedScheduLedlime(SgeneratedAt, searliestiz):15585 usagespublic function hasPassedScheduledTime(?CarbonInterface Sgeneratedt, string $timezone): boolf.. 561b usagespublic function calculateFromAndToDatePeriodostring Sfrequency,?Carbon $fromDate = null,?Carbon stobate = nuul): array "ifüfrequencK seLfi: FREQUENCX ONE DEE)NEreturn"trombace = stromdate,'toDate' => stobate,—0045635645635665675o8 M=569—5/0Pusnea 1 commit to oricin/Jy-loy0g-automated-repors-ask- iminny View pull request loday 13.29liminny017 A 15 V13 ^select * tron reans wnere 1o =1select x tron groups g Juin playbooks p1..n<->1: on a.plavbook id = p.id wiselect * 1r0IOIrOUOSnere t =oo.select * from playbooks where team_ id = 1:select * from playbooks where id = 175:select * from playbook categories where playbook id = 175:select * from users where team_1d = 1:select * from users where 1d = 7160*select * from crm_profiles where user_1d = 7160*select * trom reatures,select*o, Uuno, tyoe, orovoer, oavoook careoory or user 0rleao o, contact* cri conmouracionorciri orovoer LorTranscrrocion orSTaTUSfrom activities where crm_confiquration id = 1 and type =# and crm_ provider id IS NOT NULLand provider != 'uploader' and actual start time IS NOT NULLORDER by id desc;select * from activities where 1d = 54/47785; # 0000400000pCZOJMAOselect p.1d, p.activity_type, pc.1d, pc.nameFRUM playdooks pjoin playpook_categories pe"->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 = !SELECT * FROM crm_ field values WHERE crm_ field id = 4select * from crm_layouts cl join playbook layouts pl 1<->i.n: on cl.id =pwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175:select * from teams:SELECI r.* FRUn aucomaced_reporus rjoin ceams t on r.ueam 10 = t.10WHERE r.trequency = "dally"and f.stauus-AND t.status = 'activelAND (r.expires at >= now) OR r.expires at IS NULD):select * from automated_report_results where report. id IN (18, 33);select * from activity_searches where 1d = 10952;select * from activity_search_filters where activity_search_1d = 10932:select * from automated_reports order by 1d desc;select * from automated_report_results order by id desc;select * from automated_report_results where report id IN (36);Support Daily • in 23 m100% [45)Tue 14 Apr 14:37:02AutomatedRenortsCommandTestCascadeDebug Automated RepLogic Walkthroughoteo l. derueneraceanorsentkesultsrerches AutomatedkenortResult recoros wnerergenerated_at IS NOT NULLsent_at Is NULLstatus = STATUS GENERATEDnas arelared revortYour 7 results pass this.Step 2: getValidRecipientUsers()For each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients(→ includes creator. For regular reports it goes through getRecipientUsers() . Either way, the creator has anemail, so validRecipients is not empty.vStenx. shouldSendRenorto - THISS WHERE ITFAILS•phppubLic const int SENI_REPORI_AI_HUURS = 5;The logic picks the earliest timezone (highest UTC offset = most ahead of UTC). For GMT+3, the offset is +1080• secondsIt then checks:• php$now = carbon::now($earliestiz);$isScheduledTime = (int) $now->format('H") === 5;// current time in GMT+3// is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIf it's not 5:00 AM right now in GMT+3, it falls through to hasPassedScheduledTime() :0 phppublic function hasPassedScheduledTime(?CarbonInterface SgeneratedAt, string $timezone): booltihis checksgeneratedat < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)soit onlv returns true If1. The report was generated before 05:00 GMT+3 today (l.e., before 02:00 UTC.2. AND current time is past 05:00 GMT+3 (past 02:00 UTC)Why Nothing Is SentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeutc, so hasPassedScheduledTime returns false• OR the current time is before 05:00 GMT+3 → nowUtc is NOT > scheduledTimeUtcciven vou 're running this at 2:35 PM UTic+3 14.35 ocaly 11:35 Unic). here's what hapoens.scheduledtame = tocav at 05:00 GMT+3 = 02:00 U10now = 11:35 UTC → past scheduled timevgeneratedat must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (atter 02:00 UTC) today, so generatedAtUtr.Iffcchedulentimellfr) stalse z hacPaccenSchenulerime returns talce → notina senosAsk anything (&+LClaude Sonnet 4.6winasun leam1685:23uir-oia 4 spacesw...
|
NULL
|
NULL
|
NULL
|
12764
|
|
12771
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 22 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER- 281DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO ₴7Tue 14 Apr 14:38:27181* Unable to acce...K 888> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12771
|
|
12772
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 22 mec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER-281DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh100% <47Tue 14 Apr 14:38:3018186-zshO 87* Unable to acce...*- *8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12772
|
|
12773
|
PhpStormFileFditViewNavigateCodelaraveRefactonTool PhpStormFileFditViewNavigateCodelaraveRefactonToolsWindowHelpFV faVsco.js v• :1894 on.lY-18909-automated-renorts-ask-liminnv vProject vc) ReportController.onpSendReportJob.php(©) AutomatedReportsCommand.php= custom.loc= laravel.logc SF liminny@localhost« HS_local fiminny@localhostC AutomatedReportsSendCommand.phgAadLayoutchutles.onleam.onoC AutomatedReportsRepository.phpIl AuthD eustomerApI JnternallI KlOSkU settings_lelepnonyMWebhook> Hubspot> _ IntegrationAppSubsc(C) ActivityProviderCont(C) ActivityTranscription(©) BaseController.phpCalendarController.p© ReportController.php• SoftphoneWebhookC(S AbstractController.php(1 CommentContextintena(C) Conferences@ptIn@utCcconTolerone(C ExportController.php(©) FrontendController.phpT FrontendControllerTraitC GeocodingController.ph(©) HealthCheckController.(C LiveCoachController.ph© Missing l eamcontroller.© Mobllecontroller.php© NotificationController.plc NottctonrovceronC) PlavbackController.php(C PlaylistController.php(©) PusherController.php(C SlackController.phpC SupportController.php(©) TeamSetupController.pl(C) UserAutomatedReports© WelcomeController.php→ Micclleware> D Requests> MResources> MResponses› Serializers> TransformersC Kernel.phpD PlaylistTrackResourceTraitT ValidateCrmConnectionRec>_ Integrations•linteractions• M.lobs>_ Activity> M AiAutomationM AiReports>M Audiov _ AutomatedReports(C) RequestGenerateAskJin(C) RequestGenerateRepori©) SendReportJob.php(©) SendReportMailJob.php→I CalendarrackProvicerinstalled-vent.ondconsole PROD< console LUiL console [STAGING]Tx: Auto vC ActivityLogged.phpC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong520521© AutomatedReportResult.php© AutomatedReport.phpclass SendReportJob 1mplements ShouldQueue, ShouldBeUniquepubLic tunction nandlelLoggerintertace slogger,Joousoarcherinvertace "oou1spatcher.AutomatedReportsService SautomatedReportsService: void -lltry "$report = $automatedReportsService->getReportResult(Sthis->reportUuid:scatch (Throwable $e) 1sLogger->error(self::LOG_PREFIX.Error getting report result', ['uuld' => sth1s->reportUu1d'exception' => se->getMessage),thnow $e;$logger->info(self::LOG_PREFIX . ' Processing report', ['uuid' => sthis->reportUuid,'status" => $report->getStatusLabel,1):sssPath = sautomatedReportsservice->getMed1aPath(sreport)// Verify the file exists in S3if (! Storage::disk( name: 'client-data-cloud')->exists($s3Path)) {$logger->error(self::LOG_PREFIX' Report file not found in S3', IUuld → scnis->reportuund's3Path' => $s3Path,1):throw new FileNotFoundException( message: 'Report file not found in S3');try"$VaL1dReciplents = saucomacedkeportsservice->getvaL1drec1plentusersфrероги-›дескерогт),includesiminny: true,if (empty($validRecipients) ‹Sloqger->error(self::LOG_PREFIXNo valid recipients found','uuid' => Sthis-›reportUuid,1525115401527528529530531153253300%540541542154354454515461547154815475505515525535545555561558SO.004563564565156615675o8 M10010110211051104105nmit to oricin/Jy-loy09-automated-repors-ask- minny View pull request loday 13.29throw new Runtimetxceptionl message: "No reciplents found for report: isth1s->reportuu15701Get report metadata (same for all recipients)SfileName = SautomatedReportsService->getReportFileName(Sreport):$typeName = Sreport->getReport(->getCustomName®Flaycroundvt.owner_1d FROM soc1al_accounts saJOIN users u on u.1d = sa.soclable_1dJOIN teams tI.n<->I: on t.ld = U.team_1dWHERE U.team_1d = 1 and sa.provider = salestorce :liminny017 A 15 V13 ^select * trom teams wnere 1d = 1,select x tron groups g Juin playbooks p1..n<->1: on a.plavbook id = p.id wiselect * TroIOIrOUOSnere t =oo.select * from playbooks where team_ id = 1:select * from playbooks where id = 175:select * from playbook categories where playbook 1d = 175:select * from users where team_1d = 1:select * from users where 1d = 7160*select * from crm_profiles where user_1d = 7160*select * trom reatures,select# 10, Uu10, type, proviaer, playbook_cacegory-1a, user_ia,leao o, contact* cri conmouracionorcirn orovoer 1o,Transcrrocion orSTaTUSfrom activities where crm_confiquration 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 1d = 54/47785; # 0000400000pCZOJMAOselect p.1d, p.activity_type, pc.1d, pc.nameFRUM playdooks pJoin playdook_cacegories pc"->l.n: on p.1d = pc.playbook_1dwhere p.team_id = 1 and p.activity_type = 'event':SELECT * FROM crm fields WHERE crm confiquration id = 1 and obiect tvpe = "SELECT * FROM crm field values WHERE crm_ field id = 4select * from crm_layouts cl join playbook layouts pl1<->1..n: on cl.id = pwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175:select * from teams:SELECI r.* FRUn aucomaced_reporus rjoin ceams t on r.ueam 10 = t.10WHERE r.trequency = "dally"and f. stauusAND t.status = 'activelAND (r.expires at >= now OR r.expires at IS NULD):select * from automated_report_results where report. id IN (18, 33);select * from activity_searches where 1d = 10952;select * from activity_search_filters where activity_search_1d = 10932:select * from automated_reports order by 1d desc;select * from automated_report_results order by id desc;select * from automated_report_results where report id IN (36);labl:Support Daily • in 22 m100% [45)Tue 14 Apr 14:38:30AutomatedRenortsCommandTestCascadeDebug Automated RepFetches AutomatedReportResult records where:generated at is NOT NULLsent at is NULLstatus = STATUS GENERATED• has a related reportYour 7 results pass this.Sten 2: getValidRecipientlsersoFor each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients7 Includes creator. ror recular reoorts t eoes tnrouen detkeclolentusers . cltner way, tne creator nas anemall, so validRecipients is not emotv.vStep 3: shouldSendReporto — hisls whEkEllraiLs# phppublic const int SENT REPORT AT HOURS = 5;The logic picks the earliest timezone (highest UTC ortset = most ahead of UTC). For GMT+s, the oftset is +10800 seconds.t then checks.•phosnow = larbon::nowsearllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;11 is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIfit's not 5:00 AM right now in GMT+3, it falls through to hasPassedSchedu ledTime() :® phppublic tunction hasPassedscheduledlimetrlarbonintertace sgeneratedAt, string stimezone): boounis checks.generatedAt < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC2. AND current time is past 05:00 GMT+3 (past 02:00 UTC.wny Nothing is sentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerurns Talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven vou're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:scheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtUtc.lt(scheduledTimeUtc) istalse→ hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (&+L+ <> Code Claude Sonnet 4.6wW Winasurt leams60:14uir-oia 4 spaces...
|
NULL
|
NULL
|
NULL
|
12773
|
|
12778
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp§ Support Daily • in 22 m100% <Tue 14 Apr 14:38:41T&1ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER₴81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,3,],}-zsh86-zshO ₴7* Unable to acce... ≥,* *8•Menu Bar item refreshed> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#...
|
NULL
|
NULL
|
NULL
|
12778
|
|
12779
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 22 m100% <47Tue 14 Apr 14:38:42181ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER3 281DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO 87* Unable to acce... →- *8Menu Bar item refreshed> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12779
|
|
12780
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 22 m100% 197ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER981DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx"team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO ₴7Tue 14 Apr 14:38:43181* Unable to acce...*8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12780
|
|
12781
|
PhpStormProject vFileFV faVsco.js vEditViewNavigat PhpStormProject vFileFV faVsco.js vEditViewNavigateCodeLaravelRefactorToolsWindowHelp• :1894 on.lY-18909-automated-renorts-ask-liminnv v© SendReportJob.php= custom.logA HS_local [iminny@localhost]ProphetAiv D Reports© AutomatedReportsC© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack• TeamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpcreateDatabaseusers.pc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantissues.p© FlushRolesPermissionsC© GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.php@ Imnortli|sercFromCcvEil© IterateUsersCommand.gcJiminnvcacheclearcom(c) minnv Deouacommanc© JiminnySetEncryptedTo© JiminnyTokenInfoComn© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom© RecalculateDealRisksCaC) RemoveDeleteMarkersd© RemoveExpiredNudgest© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCorAddLayoutchuitles.onoCreateHeldActivityEvent.phpAutomaleakeporscommana.ongAutomatedReportsSendCommand.phpC Team.phpC AutomatedReportsRepository.php© AutomatedReportsService.phpCreateActivityLoggedEvent.phpconsole PROD© RequestGenerateAskJiminnyReportJob.phpTrackProviderInstalledEvent.php© ActivityLogged.phpRequestGeneratekeporJob.onoC AutomatedReportResult.phpE laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.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';Sa jiminny v017 A15 X 13 A521© AutomatedReport.php522class AutomatedReportsCommand extends Command0 523524private function getReportById(string $reportId): Collection1525115401115/1158139140141142143144145146147148149150151152153154155156157158159160161162527$report = $this->reportRepository->findById0rUuid($reportId);528529if ($report === null) {530$this->logger->warning(self::LOG_PREFIX .' Report not found for --report-id',['reportld531$this->warn( string: "Report not found: {$reportId}");532533return collecto);534535if (! $report->getStatus()) {155455 A$this->logger->warning(self::LOG_PREFIX . ' Report is inactive, processing anyway (manual'reportId' = $reportId,539|'reportUuid' => $report->getUvid(),1);540541$this->warn( string: 'Report is inactive - processing anyway (manual override).');542543$team = $report->getTeam();if ($team->getStatus() !== Team::STATUS_ACTIVE) ($this->logger->warning(self::LOG_PREFIX'reportId' => $reportId,'reportUuid' => $report->getUuid(),'teamId' => $report->getTeamId(),'teamStatus' => $team->getStatus(),5445451546select * tron reans where 1o =15select x tron groups g Juin playbooks p1..n<->1: on a.plavbook id = p.id wiselect x t'ol arouoswhere id = 565:seleseledseledseledselect * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# 10, Uud, type, provider, playbooк_cаtegory-1o, user_1a,leao o, contact* cri conmouracionorcirn orovoer LorTranscrrocion orstatusfrom 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 pc1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event':15485495501);551552$this->warn( string: "Team #{$report->getTeamId()} is not active - processing anyway (manua"553554555if ($report->isExpired()) {$this->logger->warning(self::LOG_PREFIX . ' Report is expired, processing anyway (manual556557'reportId' => $reportId,'reportUuid' => $report->getUuid(),1558'expiresAt' => $report->getExpiresAt()?->toDateString(),SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = •SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl1<->1.n: on cl.id = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;1661671681691701711721731741751761177178179180I):select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'activelAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);$this->warn( string: 'Report is expired (expires_at:' . Sreport->getExpiresAt()?->toDateSti562563$this->info( string: self::LOG_PREFIX . ' Automated report found' . $report->getCustomName()) ;564565566return collect([$reportl);567568 Vselect * from automated_report_results where repontaig 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 * fromautomated_report_results order by id desd;select * from automated_report_results where repontaid IN (36);570572Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)> 0lablf Support Daily • in 22 mAL AutomatedReportsCommandTestv100% [45)Tue 14 Apr 14:38:43CascadeDebug Automated Rep+0 •Fetches AutomatedReportResult records where:generated at is NOT NULLsent_at is NULLstatus = STATUS_GENERATED• has a related reportYour 7 results pass this.VwStep 2: getValidRecipientUsers()ets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipientsialor. ror recular reoorts l eoes tnrouen detkeclolentusers . clner way, te creator nas ancipients is not empty. VStep 3: shouldSendReporto — Hisis whEkEllraILsD phppublic const int SENT_REPORT_AT_HOURS = 5;The logic picks the earliest timezone (highest UTC offset = most ahead of UTC). For GMT+3, the offset is +10800 seconds.t then checks.0 phpsnow = larbon::now searllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;// is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIf it's not 5:00 AM right now in GMT+3, it falls through to hasPassedScheduledTime() :• phppublic tunction naspassedschedu ledlimerrlarbonintertace sgeneratedAt, string stimezone): booyunis checks.generatedAt < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC)2. AND current time is past 05:00 GMT+3 (past 02:00 UTC.Why Nothing Is SentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerurns Talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven you're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:ScheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtutc. lt(scheduledTimeUtc) is false → hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (884L)+ <> Code Claude Sonnet 4.6uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12781
|
|
12782
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 22 m100% 197Tue 14 Apr 14:38:45181ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKERDEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO ₴7* Unable to acce...> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12782
|
|
12783
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(ah]Support Daily - in 22 m100% <47ec2-user@ip-10-30-93-249:~ec2-user@ip-10-30-...-zshDOCKER981DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx"team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}-zsh86-zshO ₴7Tue 14 Apr 14:38:47181* Unable to acce...*8> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12783
|
|
12784
|
PhpStormFileFditViewNavigateCodelaravelRefactonToo PhpStormFileFditViewNavigateCodelaravelRefactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny ~Project vD ProphetAiv → Reports(C AutomatedReportsC(C) AutomatedReportsRe© AutomatedReportss© CreateMockAsKJimirC DeleteReportcomma© GenerateMarketingR©leam.phpC Usage.phpM Slack→ Teams→ Tracks_ TranscriptionD TwilioD Users_ Vocabulary_ 4oom© coachingeedbacksupcg command.phpc Crearevaroaseusers.oc Daraoase oecountoiC DeleteOldAiCrmNotesC(©) DeleteS3LeftoversCom|DevPostmanCommand.|C DiarizeViaAiParticipantk(©) EncryptTokensCommar(©) EngagementStatsReger© FeatureFlagsHelper.php© FixCrossTenantlssues.pC) FlushRolesPermissions((C) GeneratelnternalWebho(C) GroupSetDefaultLanquaC) HelperTruncateCoachin(©) HubspotJournalPollingC(©) HubspotWebhookServic(©) ImportRecording.php@ Imnortli|sercFromCcvEil© IterateUsersCommand.gcJiminnvcacheclearcom(c) minnv Deouacommanc(C) JiminnvSetEncrvotedTcC) JiminnvTokenInfoComm(C) MakeSlackLiveCoachinc(C) ManageScimForTeam.o(©) MarkBranchForEnvironn(C) MuteOrganizerChannel.(C) PhpApm.php(C PropagateCoachingFee(©) PurgeConterences.php(©) PurgeSoftDeletedOppol© PurgeSyncBatchesCom(C) RecalculateDealRisksCdC) RemoveDeleteMarkersd(C) RemoveExpiredNudaes(C) RemoveUnusedParticio:C ResetElasticSearch.php(C) RestoreActivityCrmProv(C) RestoreActivityTypeCor• ReportController.php XC SendReportJob.php(©) AutomatedReportsCommand.php= custom.loc= laravel.logc SF liminny@localhost« HS_local fiminny@localhostC AutomatedReportsSendCommand.phpC AddLayoutEntities.phpC) Team.phpC AutomatedReportsRepository.phpAutomatedReportsService.php© CreateHeldActivityEvent.phpconsole PROD< console EUiL console [STAGING] :Tx: Auto vC UserPilotActivityListener.phpC ActivityLogged.phpC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong52015211© AutomatedReportResult.php© AutomatedReport.php524class Reportcontrouler extends Abstractcontrollerpublic function ready(Request srequest): Jsonkesponse1524'status' => sthis->callbackservice->getPrimarystatus(sreport, spayload),15251'response' => Spayload,15401generated_at= snow,5271):528// if a podcast is set, update it529"revorcroocastr->uooareui530starus → nuns-ocaluoackoeru ce-poetrodcasorarusoay coaou531response → spaycoad,532'generated at' => Snow.5331):1555$this->Logger->info(self::LOG_PREFIX •" Report has been processed', L'uuld' => sreportuuld,'child_uuld' => sreportPodcast?->getUu1do),1);53954090if (! $this->callbackService->isSuccess($payload)) {541$this->logger→>warning(self::LOG_PREFIX'Error creating report'. Spavload):54215431return response()->json(['status' => 'ok']):1544154511546// send the primary report154799101102103104105106107ITA8I11AO11191$this->dispatcher->dispatch(new SendReportJob($reportUuid));550551#I send the nodcast renort if it set and aenerated552if (SreportPodcast &s $reportPodcast->getStatus() === AutomatedReportResult:•STATUS 6553)Sthis->dispatcher->dispatch.new SendReportJobCreportUuid: SreportPod>aetUuid55455515561// Track Datadog metrics for automated reports1558$automatedReport = $report->getReport:$this->callbackService->pushToDatadog($automatedReport, $report):if ($reportPodcast) {004112Sthis->callbackService->pushToDatadog(SautomatedReport, sreportPodcast):563113564114563115Sthis->eventDispatcher->dispatch.new_AutomatedReportGeneratedSautomatedReport.Sreport)l 5661161177 catch (ModelNotFoundException $exception) &567sthis->Loqger->error(self::L06_PREFIX." Report not found',568 v118'uuid' => SreportUuid.1569119'error' => Sexception->getMessageO157011261):572122return response()->json(['status' => 'error', 'message' => 'Report not found']status: 4123} catch (Throwable $exception) {124-.---f-1c..LA AOPPTI PadnaddPushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)Flaycroundvt.owner_1d FROM soc1al_accounts saJOIN users u on u.1d = sa.soclable_1dJOIN teams tI.n<->I: on t.ld = U.team_1dliminny017 A15 У13 ^WHERE U.team_1d = 1 and sa.provider = salestorce :select * tron reans where 1o =15select x tron groupsg suin playpooks p1..n<->1: on a.plavbook id = p.id wiselect * TroIOIrOUOSnere t =oo.select * from playbooks where team_ id = 1:select * from playbooks where id = 175:select * from playbook categories where playbook 1d = 175:select * from users where team_1d = 1:select * from users where 1d = 7160;select * from crm_profiles where user_1d = 7160*select * trom reatures,select# 10, Uu10, type, proviaer, playbook_cacegory-1a, user_ia,leao o, contact* cri conmouracionorcirn orovoer 1oTranscrrocion orSTaTUSfrom activities where crm_confiquration 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 1d = 54/47785; # 0000400000pCZOJMAOselect p.1d, p.activity_type, pc.1d, pc.nameFRUM playdooks pJoin playdook_cacegories pc"->l.n: on p.1d = pc.playbook_1dwhere p.team_id = 1 and p.activity_type = 'event':SELECT * FROM crm fields WHERE crm confiquration id = 1 and obiect tvpe = "SELECT * FROM crm_ field values WHERE crm_ field id = 4select * from crm_layouts cl join playbook layouts pl1<->1..n: on cl.id = pwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175;select * from teams;SELECI r.* FRUn aucomaced_reporus rjoin ceams t on r.ueam 10 = t.10WHERE r.trequency = "dally"and f. stauusAND t.status = 'activelAND (r.expires at >= now OR r.expires at IS NULD):select * from automated_report_results where report.id IN (18, 33);select * from activity_searches where 1d = 10952;select * from activity_search_filters where activity_search_1d = 10932)select * from automated_reports order by 1d desc;select * tromautomated_report_results order by id desc;select * from automated_report_results where report id IN (36);labl• Support Daily • in 22 m100% [47]Tue 14 Apr 14:38:47AutomatedRenortsCommandTestCascadeDebug Automated Rep-1 ..rercnes Automaceakeporckesule recoras where.generated at is NOT NULLsent at is NULLstatus = STATUS GENERATED• has a related reportYour 7 results pass this.Sten 2: getValidRecipientlsersoFor each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients7 Includes creator. ror recular reoorts t eoes tnrouen detkeclolentusers . cltner way, tne creator nas anemall, so validRecipients is not emotv.vStep 3: shouldSendReporto — hisls whEkEllraiLs# phppublic const int SENT REPORT AT HOURS = 5;The logic picks the earliest timezone (highest UTC ortset = most ahead of UTC). For GMT+s, the oftset is +10800 seconds.t then checks.•phosnow = larbon::nowsearllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;11 is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIfit's not 5:00 AM right now in GMT+3, it falls through to hasPassedSchedu ledTime() :® phppublic tunction hasPassedscheduledlimetrlarbonintertace sgeneratedAt, string stimezone): boounis checks.generatedAt < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC2. AND current time is past 05:00 GMT+3 (past 02:00 UTC.wny Nothing is sentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerurns Talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven vou're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:scheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtUtc.lt(scheduledTimeUtc) Istalse→ hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (&+L+ <> Code Claude Sonnet 4.6w145:10uir-oia 4 spaces...
|
NULL
|
NULL
|
NULL
|
12784
|
|
12787
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 21 m100% 147ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO ₴7Tue 14 Apr 14:39:12181* Unable to acce...*- 88],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12787
|
|
12788
|
PhpStormProject vFileFV faVsco.js vViewNavigateCod PhpStormProject vFileFV faVsco.js vViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-iminny ~© ReportController.php x© SendReportJob.phpC AutomatedReportsSendCommand.phgAutomatedReportsCommand.php© AddLayoutEntities.phpleam.onoC AutomatedReportsRepository.php= custom.logA HS_local [iminny@localhost]© TranscriptionSum© UploadController.© ActionItemsControlle© ActivityController.phC) AiCrmNotesControllec baseconrolerona(C) ClientTokenControlle© CrmController.php© DealLevelPromptsCc© DealRiskController.pl© InstantMeetingContr© LanguageController.|© LayoutManagementc© LiveFeedController.p© MeetingsController.p© MessageController.pC) MetadataController.r© MobileSettingsContr© MomentController.ptNudgeController.phpNumberAllocatorConOrganizationLicense:OrganizationMember© OrganizationRetentic© OrganizationRolesCc© OrganizationSyncCol© PartnerController.ph|(c) PhoneNumberContrc© PlaybackController.p© PlaylistController.phpScimController.phpSidekickController.ptSoftphoneController.© SsoController.php© SubscriptionControll© TeamAiAutomationC© TeamAiContextContiTeamController.php© TeamInsightsControl© TranscriptionControl(C) TranslationControlle©UserController.phpVocabularyController> Auth> CustomerApi|C Internal• KioskD SettingsTelephonyWeshook.> MHubspot> MIntearationAopSubsc© ActivityProviderCont© ActivityTranscription© BaseController.phpCalendarController.p© ReportController.php© SoftphoneWebhookC© AbstractController.phpconsole PROD) AutomatedReportsService.php) CreateActivityLoggedEvent.phpC AutomatedReportsCallbackService.php© ActivityLogged.phpRequestGenerateaskJiminnykeportJob.onpRequestGeneratekeporJob.ong520521E laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.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';Sa jiminny017 A15 Х13 A© AutomatedReportResult.phpAutomatecRenort.ohnclass ReportController extends AbstractControllerpublic function ready(Request $request): JsonResponse'response' => Spayload,'generated_at'= show,15241):529$this->logger->info(self::LOG_PREFIX . ' Report has been processed', [530'uuid' => $reportUvid,531'child_uvid' => $reportPodcast?->getUvid(),5321):533534if (! $this->callbackService->isSuccess($payload)) {535$this->logger->warning(self::LOG_PREFIXError creating report', $payload);155455 Arewurn resconsel»> sonu'starus' s> 'ok538539540// If one-off, send the report immediately, if not leave it for the scheduler (automated-reports:541if ($report->getReport()->getFrequency() === AutomatedReportsService::FREQUENCY_ONE_OFF) {542// send the primary report543$this->dispatcher->dispatch(new SendReportJob($reportUvid));54415451// send the podcast report if it set and generated1546if (SreportPodcast && $reportPodcast->getStatus() === AutomatedReportResult::STATUS_GENERATEDSthis-›dispatcher-›dispatch(new SendReporggob(reportUuid: $reportPodcast->getUuid()));select * tron reans where 1o =15select x tron groupsg suin playpooks p1.n<->1: on g.playbook_id = p.id winselect * 1r0Igroupsnere t =oo.select * from playbooks where team_ id = 1:select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# 10, Uud, type, provider, playbook_category-1o, user_1a,leao o, contact* cri contouracionlorcirn orovoer 1oTranscrrocion orstatusfrom 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; # 00U0400000pCZojMAC1001011021031041051061071108109110111112113114115116117select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event':// Track Datadog metrics for automated reports$automatedReport = $report->getReport();$this->callbackService->pushToDatadog(SautomatedReport, $report);if ($reportPodcast) {$this->callbackService->pushToDatadog($automatedReport, $reportPodcast);1548549550551552553554555556557558SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = •SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl1<->1.n: on cl.id = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;$this->eventDispatcher->dispatch(new AutomatedReportGenerated($automatedReport, $report));} Catch (ModelNotFoundException $exception) {$this->logger->error(self::LOG_PREFIX"keport not round,lUuo => "redorcuulor'error' => $exception->getMessage(),select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'activelAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);119120121122123124125126127128129115011):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', ['vuid' = $reportUvid,'error' => $exception->getMessage(),[IBAN] v569570select * from automated_report_results where repontaig 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 * fromautomated_report_results order by id desd;select * from automated_report_results where reRontaid IN (36);1):retur resconse» sonustarus "error,'message' = 'Failed to update report status'], staPushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)loblSupport Daily • in 21mAL AutomatedReportsCommandTestv100% [45)Tue 14 Apr 14:39:12CascadeDebug Automated Rep+0 •rercnes Automaceakeporckesule recoras where.generated at is NOT NULLsent_at is NULLstatus = STATUS_GENERATED• has a related reportYour 7 results pass this.VwSten 2: getValidRecipientlsersoFor each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients7 Includes creator. ror recular reoorts t eoes tnrouen detkeclolentusers . cltner way, tne creator nas anemail, so validRecipients is not empty. VStep 3: shouldSendReporto — Hisis whEkEllraILs# phppublic const int SENT_REPORT_AT_HOURS = 5;The logic picks the earliest timezone (highest UTC offset = most ahead of UTC). For GMT+3, the offset is +10800 seconds.t then checks.O phpsnow = larbon::now searllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;// is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIf it's not 5:00 AM right now in GMT+3, it falls through to hasPassedScheduledTime() :• phppublic tunction naspassedschedu ledlimerrlarbonintertace sgeneratedAt, string stimezone): booyunis checks.generatedAt < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC)2. AND current time is past 05:00 GMT+3 (past 02:00 UTC)Why Nothing Is SentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerurns Talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven you're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:ScheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtutc. lt(scheduledTimeUtc) is false → hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (884L)+ <> Code Claude Sonnet 4.6W Winasunt leamsg9:ouir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12788
|
|
12790
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER0 881DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 21 m100% 147ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO 87Tue 14 Apr 14:39:18181* Unable to acce...*8],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12790
|
|
12792
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 21 m100% 147ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO ₴7Tue 14 Apr 14:39:21181* Unable to acce...*- 88],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12792
|
|
12793
|
PhpStormFileFditViewNavigateCodeLaravelRefactonToo PhpStormFileFditViewNavigateCodeLaravelRefactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny ~Project vProphetAiv → Reports(C AutomatedReportsC(C) AutomatedReportsRe(C) AutomatedReportsS© CreateMockAsKJimirC DeleteReportcomma© GenerateMarketingR©leam.phpC Usage.phpM Slack→ Teams→ Tracks_ TranscriptionD TwilioD Users_ Vocabulary_ 40om© coachingeedbacksupcg command.phpcreateDatabaseusers.pc Daraoase oecountoiC DeleteOldAiCrmNotesC(©) DeleteS3LeftoversCom|DevPostmanCommand./C DiarizeViaAiParticipantk(©) EncryptTokensCommar(©) EngagementStatsReger© FeatureFlagsHelper.php© FixCrossTenantlssues.pC) FlushRolesPermissions((C) GeneratelnternalWebho(C) GroupSetDefaultLanquaC) HelperTruncateCoachin(©) HubspotJournalPollingC(©) HubspotWebhookServic(©) ImportRecording.php@ Imnortli|sercFromCcvEil© IterateUsersCommand.gcJiminnvcacheclearcom(c) minnv Deouacommanc(C) JiminnvSetEncrvotedTcC) JiminnvTokenInfoComm(C) MakeSlackLiveCoachinc(C) ManageScimForTeam.o(©) MarkBranchForEnvironn(C) MuteOrganizerChannel.(C) PhpApm.php(C PropagateCoachingFee(©) PurgeConterences.php(©) PurgeSoftDeletedOppol© PurgeSyncBatchesCom(C) RecalculateDealRisksCdC) RemoveDeleteMarkersd(C) RemoveExpiredNudaes(C) RemoveUnusedParticio:C ResetElasticSearch.php(C) RestoreActivityCrmProv(C) RestoreActivityTypeCor(©) ReportController.phpC SendReportJob.php X(©) AutomatedReportsCommand.php X= custom.loc= laravel.logc SF liminny@localhost« HS_local [EMAIL]) AutomatedReportsRepository.phpAutomatedReportsService.php© CreateHeldActivityEvent.phpe) TrackProvidernstallled-vent.onoconsole PROD4 console [EU1L console [STAGING]Tx: Auto vFlaycroundvC ActivityLogged.php520C RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong15211© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportscommand extends commandv 0J 523115/11581391401411421431441451146|147148114915015115215315415515715815916016116211661167168169170171172173117417517611771178117918015251private function getReportByTdstring SreportId): Collection154527Sreport = $this->reportRepository->findById0rUuid($reportid):528529if (Sreport === nulb) 1530sthis->Logger->warning(self::LOG_PREFIX .• Report not found for --report-1d',L'reportid531sthis->warn( string: "Report not found: isreportia");return collecto);153253515.54115531554if @ Sreport->getStatuso)Sthis->logger->warning(self::LOG PREFTX . ' Report is inactive. processina anvwav manuali'reportid' => Sreportid.''reportluid' => $report->getluido.55 AI);sthis->warn( string: 'Report 1s 1nactive - processing anyway (manual override).')*$team = $report->getTeam():if ($team->getStatus() !== Team::STATUS_ACTIVE) {$this->logger->warning(self::LOG_PREFIX .'reportId' => SreportId.'reportluid' => Sreport-›getUuido.'teamId' => $report->getTeamId(),'teamStatus' => $team->getStatus(),1):5395405415421543154415451154615471548549550551552$this->warn( string: "Team #$report-›getleamidOr is not active - processing anyway (manua]553554if (Srenort->isFxpiredO) {55515561$this->logger->warning(self::LOG_PREFIX . ' Report is expired, processing anyway (manual'reportId' => SreportId.'reportluid' => Sreport-›getUuido.1558'expiresAt' => Sreport->getExpiresAtO?->toDateStringo.I):$this->warn( string: 'Report is expired (expires_at:" • Sreport->getexpiresAt(?->toDateSti562563$this->info( string: self::LOG_PREFIX . ' Automated report found' . $report->getCustomName()):564156515661return collect(lsreport5675o8 M15701572Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)t.owner_1d FROM soc1al_accounts saliminny017 A 15 V13 ^JolN users u on u.1d = sa.soclable_1dJOIN teams tI.n<->I: on t.1d = u.team_1dWHERE U.team_1d = 1 and sa.provider = salestorce :select * tron reans where 1o =15select x tron groups g Juin playbooks p1..n<->1: on a.plavbook id = p.id wiselect * 1r0Iorouosnere t =oo.select * from playbooks where team_ id = 1:select * from playbooks where id = 175:select * from playbook categories where playbook 1d = 175:select * from users where team_1d = 1:select * from users where 1d = 7160;select * from crm_profiles where user_1d = 7160*select * trom reatures,select# 10, Uud, type, provider, playbook_category-1o, user_1a,leao o, contact* cri conmouracionorcirn orovoer LorTranscrrocion orSTaTUSfrom activities where crm_confiquration 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 1d = 54/47783; # 0000400000pCZOJMACselect p.1d, p.activity_type, pc.1d, pc.nameFRUM playdooks pjoin playpook_categories pe"->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 tvoe = "SELECT * FROM crm_ field values WHERE crm_ field id = 4select * from crm_layouts cl join playbook layouts pl1<->1..n: on cl.id = pwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175:select * from teams:SELECI r.* FRUn aucomaced_reporus rjoin ceams t on r.ueam 10 = t.10WHERE r.trequency = "dally"and f.stauus-AND t.status = 'activelAND (r.expires at >= now OR r.expires at IS NULD):select * from automated_report_results where report.id IN (18, 33);select * from activity_searches where 1d = 10952;select * from activity_search_filters where activity_search_1d = 10932:select * from automated_reports order by 1d desc;select * tromautomated_report_results order by id desc;select * from automated_report_results where report id IN (36);lobl: Support Daily • in 21 m100% [47]Tue 14 Apr 14:39:21AutomatedRenortsCommandTestCascadeDebug Automated Reprercnes Automaceakeporckesule recoras where.generated at is NOT NULLsent at is NULLstatus = STATUS_GENERATED• has a related reportYour 7 results pass this.Sten 2: getValidRecipientlsersoFor each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients7 Includes creator. ror recular reoorts t eoes tnrouen detkeclolentusers . cltner way, tne creator nas anemall, so validRecipients is not emotv.vStep 3: shouldSendReporto — hisls whEkEllraiLs# phppublic const int SENT REPORT AT HOURS = 5;The logic picks the earliest timezone (highest UTC oftset = most ahead of UTC). For GMT+s, the offset is +10800 seconds.t then checks.•phosnow = larbon::nowsearllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;11 is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIfit's not 5:00 AM right now in GMT+3, it falls through to hasPassedSchedu ledTime() :® phppublic tunction hasPassedscheduledlimetrlarbonintertace sgeneratedAt, string stimezone): boounis checks.generatedAt < 65:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC2. AND current time is past 05:00 GMT+3 (past 02:00 UTC.wny Nothing is sentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerurns Talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven vou're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:scheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtUtc.lt(scheduledTimeUtc) istalse→ hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (&+L+ <> Code Claude Sonnet 4.6w145:10uir-oia 4 spaces...
|
NULL
|
NULL
|
NULL
|
12793
|
|
12794
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER• ₴1DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 21 m100% 147Tue 14 Apr 14:39:23181ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO ₴7* Unable to acce...],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12794
|
|
12795
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© 81DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 21 m100% 147ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO 87Tue 14 Apr 14:39:28181* Unable to acce...€ 888],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12795
|
|
12796
|
PhpStormProject vFileFV faVsco.js vEditViewNavigat PhpStormProject vFileFV faVsco.js vEditViewNavigateCodeLaravelRefactorTools#11894 on JY-18909-automated-reports-ask-iminny ~WindowHelp© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackM TeamsD TracksD TranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.p(e) Database aoecount.oic DelereoeAcimnorescc Deleress eroverscom® DevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebho© GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.fc.liminnveacheclearcom(©) JiminnyDebugCommanc(©) JiminnySetEncryptedTo(C) .JiminnvTokeninfoComm© MakeSlackLiveCoachins© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComi© RecalculateDealRisksCo(C) RemoveDeleteMarkersd(c) Remove-XoiredNuddes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAadLayoutchutles.onc leam.ongC) AutomatedReportsRepository.php= custom.logconsole PROD© AutomatedReportsService.phpTrackProviderInstalledEvent.php© ActivityLogged.php•Automareakeporscallbackservice.ongC RequestGenerateAskJiminnyReportJob.php© AutomatedReportResult.phpe AutomatedRenort.onnclass AutomatedReportsSendCommand extends CommandRequestGeneratekeporJob.ong521522= laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.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';A HS_local [iminny@localhost]Sa jiminny v017 A15 Х13 A25 Ct32 Ct35 Ct3941445556C&889988*ne nome one stendrure of tne console commond.*ovar scringprotected $signature = 'automated-reports:send';/*** The console command description.* Ovar string52415251154015275285295305315325335345351554protected $description = 'Sends automated reports based on user timezone';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.* Qreturn intpublic function handle(): int155000%54054154254354454554654715481547550551552553554555556foreach (SrenortResults as SrevortResult) {1558/** Ovar AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->g560if ($this->automatedReportsService->shouldSen|dReport($validRecipients, $reportResult->get$561$this->logger->info(self::LOG_PREFIX'Dispatching job',1);$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuid()));562563564565566567568 V569570571572select * tron reans where 1o =15select x tron groupsg suin playpooks p1.n<->1: on g.playbook_id = p.id winselect x Tolgroupsnere t =oo.select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vvid, type, provider, playbook_category_id, user_id,leao o, contact* cri conmouracionorcirn orovoer LorTranscrrocion orstatusfrom 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 pc1<->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 = •SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status ='active'AND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaig IN (18, 33);return CommandALias: : SUCCESS;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 order by id desc;select * from automated_report_results where repontaid IN (36);Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)loblSupport Daily • in 21mAL AutomatedReportsCommandTestv100% [45)Tue 14 Apr 14:39:28CascadeDebug Automated Rep+0 •rercnes Automaceakeporckesule recoras where.generated at is NOT NULLsent_at is NULLstatus = STATUS_GENERATED• has a related reportYour 7 results pass this.VwSten 2: getValidRecipientlsersoFor each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients7 Includes creator. ror recular reoorts t eoes tnrouen detkeclolentusers . cltner way, tne creator nas anemail, so validRecipients is not empty. VStep 3: shouldSendReporto — Hisis whEkEllraILsD phppublic const int SENT_REPORT_AT_HOURS = 5;The logic picks the earliest timezone (highest UTC offset = most ahead of UTC). For GMT+3, the offset is +10800 seconds.t then checks.0 phpsnow = larbon::nowsearllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;// is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIf it's not 5:00 AM right now in GMT+3, it falls through to hasPassedScheduledTime() :• phppublic tunction naspassedschedu ledlimerrlarbonintertace sgeneratedAt, string stimezone): booyunis checks.generatedAt < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC)2. AND current time is past 05:00 GMT+3 (past 02:00 UTC.Why Nothing Is SentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerumns Talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven you're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:ScheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtutc. lt(scheduledTimeUtc) is false → hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (884L)+ <> Code Claude Sonnet 4.6Winasun leams50:00uir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12796
|
|
12797
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKER© *1DEV (docker)282APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "["users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},WindowHelp(ahlSupport Daily - in 21 m100% 147Tue 14 Apr 14:39:40181ec2-user@ip-10-30-...ec2-user@ip-10-30-93-249:~-zsh-zsh86-zshO 87* Unable to acce... →- *8],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|...
|
NULL
|
NULL
|
NULL
|
12797
|
|
12798
|
PhpStormProject vFileFV faVsco.js vEditViewNavigat PhpStormProject vFileFV faVsco.js vEditViewNavigateCodeLaravelRefactorToolsWindowHelp#11894 on JY-18909-automated-reports-ask-iminny ~© AutomatedReportsCi© AutomatedReportsRr© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpIsackM TeamsD TracksD TranscriptionD TwilioO UsersVocabularyD Zoom© CoachingFeedbacksUpr© Command.php© CreateDatabaseUsers.pDatabaseTableCount.ptc DeleredoAcimnorescc Deleress eroverscom(C DevPostmanCommand.© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsC© GeneratelnternalWebhoGroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.fc.liminnveacheclearcom(©) JiminnyDebugCommanc(©) JiminnySetEncryptedTo(C) .JiminnvTokeninfoComm© MakeSlackLiveCoachins© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesComi© RecalculateDealRisksCo(C) RemoveDeleteMarkersd© RemoveExpiredNudgesi© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© SeedActivities.php© SyncActivity.php© ReportController.php© SendReportJob.php© AutomatedReport&.ommand.php x© AutomatedReportsSendCommand.phpAadLayoutchutles.onc leam.ong= custom.logC) AutomatedReportsRepository.phpconsole PROD© AutomatedReportsService.phpTrackProviderInstalledEvent.php© ActivityLogged.php•Automareakeporscallbackservice.ongC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command521522= laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.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';A HS_local [iminny@localhost]Sa jiminny v017 A15 Х13 A25 Ct32 Ct3941444554*ne nome one stendrure of tne console commond.*ovar scringprotected $signature = 'automated-reports:send';/*** The console command description.* Ovar string52415251154015275285295305315325335345351554protected $description = 'Sends automated reports based on user timezone';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.* Qreturn intpublic function handle(): int155000%54054154254354454554654715481547550551552553554555556foreach (SrenortResults as SrevortResult) {1558/** Ovar AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->g560if ($this->automatedReportsService->shouldSendReport($validRecipients, $reportResult->getG561$this->logger->info(self::LOG_PREFIXDispatching job',5621);563$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuid()));select * tron reans where 1o =15select x tron groupsg suin playpooks p1.n<->1: on g.playbook_id = p.id winselect * TroIgroupsnere t =oo.select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vuid, type, provider, playbook_category_id, user_id,leao o, contact* cri conmouracionorcirn orovoer LorTranscrrocion orstatusfrom 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 pc1<->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 = •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 = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status ='activeAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaig IN (18, 33);Cascade & TI568 Vreturn CommandALias: : SUCCESS;select * from activity_searches where id = 10932;om activity_search_filters where activity_search_id = 10932;Command 981om automated_reports order by id desc;select * from automated_report_results order by id desc;select * from automated_report_results where repontaid IN (36);571572Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)loblSupport Daily • in 21mAL AutomatedReportsCommandTestv100% [45)Tue 14 Apr 14:39:40CascadeDebug Automated Rep+0 •rercnes Automaceakeporckesule recoras where.generated at is NOT NULLsent_at is NULLstatus = STATUS_GENERATED• has a related reportYour 7 results pass this.VwSten 2: getValidRecipientlsersoFor each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients7 Includes creator. ror recular reoorts t eoes tnrouen detkeclolentusers . cltner way, tne creator nas anemail, so validRecipients is not empty. VStep 3: shouldSendReporto — Hisis whEkEllraILsD phppublic const int SENT_REPORT_AT_HOURS = 5;The logic picks the earliest timezone (highest UTC offset = most ahead of UTC). For GMT+3, the offset is +10800 seconds.t then checks.0 phpsnow = larbon::nowsearllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;// is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIf it's not 5:00 AM right now in GMT+3, it falls through to hasPassedScheduledTime() :• phppublic tunction naspassedschedu ledlimerrlarbonintertace sgeneratedAt, string stimezone): booyunis checks.generatedAt < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC)2. AND current time is past 05:00 GMT+3 (past 02:00 UTC.Why Nothing Is SentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerumns Talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven you're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:ScheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtutc. lt(scheduledTimeUtc) is false → hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (84L)+ <> Code Claude Sonnet 4.6winasun leams61:1/ 3 charsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12798
|
|
12803
|
SlackFileEditViewGoHistoryWindowHelpDOCKER0 81DEV SlackFileEditViewGoHistoryWindowHelpDOCKER0 81DEV (docker)882APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx",team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|*3ec2-userGec2-user@ip-10-30-...+EDHomeDMsActivityFilesLater.*•More(ahl• Support Daily • in 20 ml100% <47Tue 14 Apr 14:40:08Search Jiminny IncJiminny... vir scnicrol# infra-changes# jiminny-bg# platform-tickets# product_launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...• Direct messages€. Vasil Vasilev3 Aneliya Angelova, ...lo Steliyan Georgiev3Adelina Petrova, Ili...0. Adelina Petrova O. Galya Dimitrova *Rs Nikolay Nikolov "2 Galya Dimitrova, Ni...2 Galya Dimitrova, Ni...8. Nikolay Yankov::: AppsJira CloudToastGoogle Cale...# releases8 226 0• Messages• Files@ Bookmarks+1f99de0e313cToday ~8b256855f58e5bf1f5) - [JY-20571](https://jiminny.atlassian.net/browse/JY-20571): Panorama offline reports (#465)(steliyan-g)(8cf63ce)(https://github.com/jiminny/prophet/commit/8cf63cec5153b6e1320e84c67b03977ce6fe4c0c) - [JY-19982](https://jiminny.atlassian.net/browse/JY-19982): Allow multiple LLM evals with onecommand run (#464) (steliyan-g)NewCircleCl APP 2:15 PMNew commits deployed to Prophet Prod-EU:[Od2170f](https://github.com/jiminny/prophet/commit/0d2170fd4f25032fe37738e936a418512ca7b6e2) - [JY-20544](https://jiminny.atlassian.net/browse/JY-20544)eval changes (#459) (ilian-jiminny)New commits deployed to Prophet Prod-US:[0d2170f](https://github.com/jiminny/prophet/commit/0d2170fd4f25032fe37738e936a418512ca7b6e2) - JY-20544](https://jiminny.atlassian.net/browse/JY-20544)eval changes (#459) (flian-jiminny)Message #releases+ Аа......
|
NULL
|
NULL
|
NULL
|
12803
|
|
12804
|
SlackFileEditViewGoHistoryWindowHelpDOCKER3 281DEV SlackFileEditViewGoHistoryWindowHelpDOCKER3 281DEV (docker)882APP (-zsh)created_at:"2026-04-14 11:22:36"updated_at: "2026-04-14 11:23:04"report: Jiminny\Models\AutomatedReport {#15221id: 36,#uuid: b"Aß#ôq,»ö97i7eçªx"team_id: 1,type: "ask_jiminny",status: 1,frequency: "daily",from: null,to: null,deal_value_min: null,deal_value_max: null,call_types: "[]",media_types: "["pdf"]",call_duration_min: null,call_duration_max: null,groups: "[]",playbook_categories: null,deal_at_call_stages: null,current_deal_stages: null,recipients: "{"users": [7160]}",jiminny_recipients: null,additional_prompt_input: null,custom_name: "Tuesday report",activity_search_id: 26913,ask_anything_prompt_id: 62,expires_at: "2026-04-30",created_by: 7160,created_at: "2026-04-14 11:20:20",updated_at: "2026-04-14 11:20:20",deleted_at: null,3,},],}> Srepo->getGeneratedNotSentResults()->countO;> exitINFOGoodbye.root@b79a4bdd6905:/home/jiminny#|*3ec2-userGec2-user@ip-10-30-...+EDHomeDMsActivityFilesLater.*•More+(ahl• Support Daily • in 20 ml100% <47Tue 14 Apr 14:40:10Search Jiminny IncJiminny... vir scnicrol# infra-changes# jiminny-bg# platform-tickets# product_launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...• Direct messages€. Vasil Vasilev3 Aneliya Angelova, ...lo Steliyan Georgiev3Adelina Petrova, Ili...0. Adelina Petrova O. Galya Dimitrova *Rs Nikolay Nikolov "2 Galya Dimitrova, Ni...2 Galya Dimitrova, Ni...P. Nikolay Yankov::: AppsJira CloudToastGoogle Cale...# releases8 226 0• Messages• Files@ Bookmarks+1f99de0e313cToday ~8b256855f58e5bf1f5) - [JY-20571](https://jiminny.atlassian.net/browse/JY-20571): Panorama offline reports (#465)(steliyan-g)(8cf63ce)(https://github.com/jiminny/prophet/commit/8cf63cec5153b6e1320e84c67b03977ce6fe4c0c) - [JY-19982](https://jiminny.atlassian.net/browse/JY-19982): Allow multiple LLM evals with onecommand run (#464) (steliyan-g)NewCircleCl APP 2:15 PMNew commits deployed to Prophet Prod-EU:[Od2170f](https://github.com/jiminny/prophet/commit/0d2170fd4f25032fe37738e936a418512ca7b6e2) - [JY-20544](https://jiminny.atlassian.net/browse/JY-20544)eval changes (#459) (ilian-jiminny)New commits deployed to Prophet Prod-US:[0d2170f](https://github.com/jiminny/prophet/commit/0d2170fd4f25032fe37738e936a418512ca7b6e2) - JY-20544](https://jiminny.atlassian.net/browse/JY-20544)eval changes (#459) (flian-jiminny)Message #releases+ Аа......
|
NULL
|
NULL
|
NULL
|
12804
|
|
12805
|
PhpStormFileEditViewProject vNavigateCodeLaravelRe PhpStormFileEditViewProject vNavigateCodeLaravelRefactorFVtavsco.isv#11894 on JY-18909-automated-reports-ask-iminny ~ToolsWindowHelpProphetAiv D Reports© AutomatedReportsCi© AutomatedReportsRe© AutomatedReportsS:© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack• TeamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpcreateDatabaseusers.pc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantissues.p© FlushRolesPermissionsC© GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic© ImportRecording.php@ Imnortli|sercFromCcvEil© IterateUsersCommand.gcJiminnvcacheclearcom(e) lminnv Deouacommanc© JiminnySetEncryptedTo(c) Jiminny okenintocomm© MakeSlackLiveCoaching© ManageScimForTeam.p© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom© RecalculateDealRisksCaC) RemoveDeleteMarkersd© RemoveExpiredNudgest© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© ReportController.php© SendReportJob.phpAutomatedReportsCommand.php© AutomatedReportsSendCommand.phpAadLayoutchuitles.onpc leam.ongC) AutomatedReportsRepository.php= custom.logconsole PROD© AutomatedReportsService.phpTrackProviderInstalledEvent.php© ActivityLogged.phpC RequestGenerateAskJiminnyReportJob.phpRequestGeneratekeporJob.ong© AutomatedReportResult.php© AutomatedReport.phpclass AutomatedReportsSendCommand extends Command521522E laravel.logA console (EU]A SF [jiminny@localhost]A console [STAGING]Tx: Auto vFlaycroundvt.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';A HS_local [iminny@localhost]Sa jiminny v017 A15 X 13 A2425 GT2832 Ct35 Ct363839404142* The name and signature of the console command.* Ovar stringprotected $signature ='automated-reports:send';* The console command description.x ovar sarino52415251154015275285295305315325335345351554protected $description = 'Sends automated reports based on user timezone';public function __construct(private readonly LoggerInterface $logger,private readonly AutomatedReportsRepository $reportRepository,private readonly BusDispatcher $dispatcher,parent::__construct();/*** Execute the console command.* @return intpublic function handle(): int$reportResults = $this->reportRepository->getGeneratedNotSentResults();155000%54054154254354454554654715481547550551552553554555556foreach ($reportResults as $reportResult) {1558/** @var AutomatedReportResult $reportResult */$validRecipients = $this->automatedReportsService->getValidRecipientUsers($reportResult->g560if ($this->automatedReportsService->shouldSendReport($vaLidRecipients, $reportResult->getG561$this->logger->info(self::LOG_PREFIX'Dispatching job',562563I):564565$this->dispatcher->dispatch(new SendReportJob($reportResult->getUuid()));566567568 v569return CommandAZias::SUCCESS;570571572select * tron reans where 1o =15select x tron groupsg suin playpooks p1.n<->1: on g.playbook_id = p.id winselect * TroIgroupsnere t =oo.select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, vvid, type, provider, playbook_category_id, user_id,leao o, contact* cri contouracionlorcirn orovoer LorTranscrrocion orstatusfrom 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 pc1<->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 = •SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = piwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.teamid = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'activelAND (r.exRicesuat >= now() OR r.exeicesnat IS NULL);select * from automated_report_results where repontaig 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 order by id desc;select * from automated_report_results where reRontaid IN (36);Pushed 1 commit to origin/JY-18909-automated-reports-ask-jiminny // View pull request (today 13:29)Support Daily - in 20 mAL AutomatedReportsCommandTestv100% [45)Tue 14 Apr 14:40:10CascadeDebug Automated Rep+0 •Fetches AutomatedReportResult records where:generated at is NOT NULLsent_at is NULLstatus = STATUS_GENERATED• has a related reportYour 7 results pass this.VwSten 2: getValidRecipientlsersoFor each result, gets recipients. Since it's an AskJiminny report it goes through resolveAskJiminnyRecipients7 Includes creator. ror recular reoorts t eoes tnrouen detkeclolentusers . cltner way, tne creator nas anemail, so validRecipients is not empty. VStep 3: shouldSendReporto — Hisis whEkEllraILs# phppublic const int SENT_REPORT_AT_HOURS = 5;The logic picks the earliest timezone (highest UTC offset = most ahead of UTC). For GMT+3, the offset is +10800 seconds.t then checks.0 phpsnow = larbon::nowsearllestlzcurrent cime in GMI+3$isScheduledTime = (int) $now->format('H') == 5;// is it 05:00 in GMT+3?The report only sends if it's currently 5:00 AM in the creator's timezone (GMT+3). That means 02:00 UTCIf it's not 5:00 AM right now in GMT+3, it falls through to hasPassedScheduledTime() :• phppublic tunction naspassedschedu ledlimerrlarbonintertace sgeneratedAt, string stimezone): booyunis checks.generatedAt < 05:00 today (in GMT+3, converted to UTC) ANDnow > 05:00 today (in GMT+3, converted to UTC)So it only returns true if:1. The report was generated before 05:00 GMT+3 today (i.e., before 02:00 UTC)2. AND current time is past 05:00 GMT+3 (past 02:00 UTC)Why Nothing Is SentThe current time in GMT+3 is not 05:00 AM, and one of these is also true:• The report was generated after 05:00 GMT+3 (02:00 UTC) today → generatedAtUtc is NOT < scheduledTimeurc, so nasrasseascheduleolime rerurs talse• OR the current time is betore 05:00 GMI+3→ nowltc Is NO > schedul edtimeltcGiven you're running this at 2:35 PM UTC+3 (14:35 local / 11:35 UTC), here's what happens:ScheduledTime = today at 05:00 GMT+3 = 02:00 UTCnow = 11:35 UTC → past scheduled time VgeneratedAt must be before 02:00 UTC todayThe likely cause: the report was generated AFTER 05:00 GMT+3 (after 02:00 UTC) today, so generatedAtutc. lt(scheduledTimeUtc) is false → hasPassedScheduledTime returns false → nothing sends.In short: the report must have been generated before the scheduled send time (05:00 in the user'sTmezone rmlwas cenerarec aneroo0u cmito uwi ony de elcioe to senc omorrow ar0e0u cMilts,Ask anything (884L)+ <> Code Claude Sonnet 4.6winasun leamsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
12805
|