|
10153
|
PhpStormFileFV faVsco.js vProject vEditViewNavigat PhpStormFileFV faVsco.js vProject vEditViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny K vToolsWindowHelp© ReportController.phpJiminnybeouecommana.ongProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack• TeamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpc Crearevaroaseusers.oc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsCC) GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic©ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p(©) JiminnyCacheClearCom(c) minnv Deouacommanc(c)Jminnvser-ncrvotedio(c) Jiminny okenintocomm© MakeSlackLiveCoaching(c Manacescimror eam.o© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom(e RecalculatebealkiskscoC) RemoveDeleteMarkersd(e) Remove-xoiredNudoes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCorAulomaleakeporissendcommand.onoC AutomatedReportsCommand.php X) AutomatedReportsService.phpу ІгаскrrovlderinstalleacventoneC ActivityLogged.php(e AutomatedRenortscalllbackService.onv© RequestGenerateAsKJiminnyReportJob.php(©) RequestGenerateReportJob.phpc) Automate reponkesuiconoclass AutomatedReportsCommand extends Command52public function handle(): intislonaay = oisMonady,'isFirstDay0fMonth' => $isFirstDay0fMonth,'currentMonth' => $currentMonth,'isQuarterLyMonth' => $isQuarterlyMonth,© AutomatedReport.php= custom.log= laravel.log< console PRODIL console [EUlA SF ljiminny@localhost]A HS_local [iminny@localhost]A console [STAGING] >© AskJiminnyReportActivityService.phpC RequestGenerateAskJiminnyReportJobTest.phpx:AutovPlaygroundma liminny vCONCAT(u.id, CASE WHEN U.id = t.owner_id THEN ' (owner i016 A13 V13 M V517518519520521-522523u.email,sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':5251520I);15Z8// Process daily reports,529$this->processReports( frequency: AutomatedReportsService::FREQUEIProcess weekly reports on Mondavs531if ($isMonday) {532533$this->processReports( frequency: AutomatedReportsService::FRI535// Process monthly reports on the first day of the month536if ($isFirstDay0fMonth) €537Sthis-›processReports ( frequency: AutomatedReportsService: :FR,538select * from teams where id = 1;select * from groups g JOIN playbooks p1..n<-›1: on g.playbook_id = p.id where g.tselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uvid, type, provider, playbook_category_id, user_id, lead_id, contact_id, ac# crm_confiquration id, crm_provider_1d, transcription_1d, stacusfrom activities where crm confiquration id = 1 and tvoe = 'conferencel# 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; # 00U0400000pCZojMAC8691// Process quarterly reports on the first day of January, April541if ($isFirstDay0fMonth && $isQuarterlyMonth) {542$this->processReports( frequency: AutomatedReportsService::FRI544545$this->logger->info(self::LOG_PREFIX . ' Completed');546547return 0;15481542select 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 = 'event";SELECT * FROM crm_field_values WHERE crm_field_id = 4;97100101102103104551552* Process reports for a specific frequency.553* @param string $frequency554555* Oreturn void5565575584 usaoesprivate function processReports(string $frequency): void559560$this->logger->info(self::LOG_PREFIX . " Processing $frequency561562select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * 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-exRinesaat >= now() OR r.expinesaat IS NULL);106107108109110111112(113Windsurf changelog 2.12.21: A new version is available. // View Changelog (42 minutes ago)// Get all enabled, not deleted reports with active teams for$reports = $this->reportRepository->getActiveReportsByFrequency564select * from automated_report_results where ceRontaid IN (18, 33);//$reports = collect([AutomatedReport:: find(68)]);565select * from automated_reports;566 vselect * from automated_report_results where cepontaia IN (34):$this->logger->info(self::L0G_PREFIX . " Found ($reports->count/** @var AutomatedReport $report */foreach ($reports as $report) {, 0lablf Support Daily • in 3h 45 mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 11:15:22CascadeFixing ReportControlleAutomated Report Faill+D ...Now let me also read RequestGenerateReportJob-php fully to get the complete picture:Read RequSAlus FArLED Is serov woloos-neresacomoere oreakeowniWhere STATUS_FATLED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):• RequestGenerateReportJob.php:236-244$count = (int) $content['response'];if ($count < self::MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIES);return TalserMIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Triager 2 - Any Throwable excention ( REASON PROPHET APT ERROR or REASON DEFAULT ):• RequestGenerateReportJob.php:125-151j catch (Throwable $exception) {sreason = sexcention instanceot ProphetExcention 7AutomatedReportResult::REASON_PROPHET_API_ERROR : AutomatedReportResult::REASON_DEFAULT;$this->tailReport(Sreason):if (sthis-sattempts() < sthis-atries) 1$this->release(30): // retry after 30s} else (sthis->tan Sexcent ion :ProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)• Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpoint returns no response key, DB errors, etc.)Ine job retries once (2 tries total) berore tinal fallureAlso: checkActivityCount throws ApiResponseException if the count API response is malformed — this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.php)Same pattern but MIN ACTIVITIES COUNT is 1:Trigger 1 - Fewer than 1 activity from the saved search → REASON_NOT_ ENOUGH_ACTIVITIESTrigger 2 - Any exception → REASON_PROPHET_API_ERROR if ProphetException, else REASON_DEFAULT . Retries once with 30s delay.Summary of Failure CausesReasoniREASON_NOT_ENOUGH_ACTIVITIESREASON_PROPHET_API_ERRORREASON_DEFAULTValueCauseDate range has < 10 activities (standard) or < 1 (Ask Jiminny)Prophet Al API threw an exceptionAny other exception (DB error, malformed API response, network, etc.)The reason field on the AutomatedReportResult record will tell you exactly which case applies.Oal *Ask anything (884L)+ <> CodeClaude Sonnet 4.6Winasun leamsS1:1ouir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
10153
|
|
10152
|
PhpStormFileFV faVsco.js vProject vEditViewNavigat PhpStormFileFV faVsco.js vProject vEditViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny K vToolsWindowHelp© ReportController.phpJiminnybeouecommana.ongProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack_leamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpc Crearevaroaseusers.oc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsCC) GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic©ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p(©) JiminnyCacheClearCom(c) minnv Deouacommanc(c)Jminnvser-ncrvotedio(c) Jiminny okenintocomm© MakeSlackLiveCoaching(c Manacescimror eam.o© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom(e RecalculatebealkiskscoC) RemoveDeleteMarkersd(e) Remove-xoiredNudoes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCorAulomaleakeporissendcommand.ongC AutomatedReportsCommand.php X) AutomatedReportsService.phpу ІгаскrrovlderinstalleacventoneC ActivityLogged.php(e AutomatedRenortscalllbackService.onv© RequestGenerateAsKJiminnyReportJob.php(©) RequestGenerateReportJob.phpc) Automate reponkesuiconoclass AutomatedReportsCommand extends Command52public function handle(): intislonaay = oisMonady,'isFirstDay0fMonth' => $isFirstDay0fMonth,'currentMonth' => $currentMonth,'isQuarterLyMonth' => $isQuarterlyMonth,© AutomatedReport.php= custom.log= laravel.log< console PRODIL console [EUlA SF ljiminny@localhost]A HS_local [iminny@localhost]A console [STAGING] >© AskJiminnyReportActivityService.phpC RequestGenerateAskJiminnyReportJobTest.phpx:AutovPlaygroundma liminny vCONCAT(u.id, CASE WHEN U.id = t.owner_id THEN ' (owner i016 A13 V13 M V517518519520521-522523u.email,sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':5251520I);15Z8// Process daily reports,529$this->processReports( frequency: AutomatedReportsService::FREQUEIProcess weekly reports on Mondavs531if ($isMonday) {532533$this->processReports( frequency: AutomatedReportsService::FRI535// Process monthly reports on the first day of the month536if ($isFirstDay0fMonth) €537Sthis-›processReports ( frequency: AutomatedReportsService: :FR,538select * from teams where id = 1;select * from groups g JOIN playbooks p1..n<-›1: on g.playbook_id = p.id where g.tselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uvid, type, provider, playbook_category_id, user_id, lead_id, contact_id, ac# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm confiquration id = 1 and tvoe = 'conferencel# 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; # 00U0400000pCZojMAC8691// Process quarterly reports on the first day of January, April541if ($isFirstDay0fMonth && $isQuarterlyMonth) {542$this->processReports( frequency: AutomatedReportsService::FRI544545$this->logger->info(self::LOG_PREFIX . ' Completed');546547return 0;15481542select 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 = 'event";SELECT * FROM crm_field_values WHERE crm_field_id = 4;97100101102103104551552* Process reports for a specific frequency.553* @param string $frequency554555* Oreturn void5565575584 usaoesprivate function processReports(string $frequency): void559560$this->logger->info(self::LOG_PREFIX . " Processing $frequency561562select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.ig = t.idWHERE r.frequencx ="daily'and r.status = 1AND t.status = 'active'AND (r-exRinesaat >= now() OR r.expinesaat IS NULL);106107108109110111112(113Windsurf changelog 2.12.21: A new version is available. // View Changelog (42 minutes ago)// Get all enabled, not deleted reports with active teams for$reports = $this->reportRepository->getActiveReportsByFrequency//$reports = collect([AutomatedReport:: find(68)]);select * from automated_report_results where ceRontaid IN (18, 33);565select * from automated_reports;566 vselect * from automated_report_results where cepontaia IN (34):$this->logger->info(self::L0G_PREFIX . " Found ($reports->count/** @var AutomatedReport $report */foreach ($reports as $report) {, 0lablf Support Daily • in 3h 45 mARequestGenerateAskJiminnyReportJobTestv100% C•8 • Tue 14 Apr 11:15:07CascadeFixing ReportControlleAutomated Report Faill+D ...Now let me also read RequestGenerateReportJob-php fully to get the complete picture:Read RequSAlus FArLED Is serov woloos-neresacomoere oreakeowniWhere STATUS_FATLED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):• RequestGenerateReportJob.php:236-244$count = (int) $content['response'];if ($count < self::MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIES);return TalserMIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Triager 2 - Any Throwable excention ( REASON PROPHET APT ERROR or REASON DEFAULT ):• RequestGenerateReportJob.php:125-151j catch (Throwable $exception) {sreason = sexcention instanceot ProphetExcention 7AutomatedReportResult::REASON_PROPHET_API_ERROR : AutomatedReportResult::REASON_DEFAULT;$this->tailReport(Sreason):if (sthis-sattempts() < sthis-atries) 1$this->release(30): // retry after 30s} else (sthis->tan Sexcent ion:ProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)• Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpoint returns no response key, DB errors, etc.)Ine job retries once (2 tries total) berore tinal fallureAlso: checkActivityCount throws ApiResponseException if the count API response is malformed — this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.php)Same pattern but MIN ACTIVITIES COUNT is 1:Trigger 1 - Fewer than 1 activity from the saved search → REASON_NOT_ ENOUGH_ACTIVITIESTrigger 2 - Any exception → REASON_PROPHET_API_ERROR if ProphetException, else REASON_DEFAULT . Retries once with 30s delay.Summary of Failure CausesReasonREASON_NOT_ENOUGH_ACTIVITIESREASON_PROPHET_API_ERRORREASON_DEFAULTValueCauseDate range has < 10 activities (standard) or < 1 (Ask Jiminny)Prophet Al API threw an exceptionAny other exception (DB error, malformed API response, network, etc.)The reason field on the AutomatedReportResult record will tell you exactly which case applies.Oal *Ask anything (84L)+ <> CodeClaude Sonnet 4.6Winasun leamsS1:1ouir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
10152
|
|
10151
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (34);
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
10151
|
|
10150
|
PhpStormFileFV faVsco.js vProject vEditViewNavigat PhpStormFileFV faVsco.js vProject vEditViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny K vToolsWindowHelp© ReportController.phpJiminnybeouecommana.ongProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack• TeamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpc Crearevaroaseusers.oc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsCC) GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic©ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p(©) JiminnyCacheClearCom(c) minnv Deouacommanc(c)Jminnvser-ncrvotedio(c) Jiminny okenintocomm© MakeSlackLiveCoaching(c Manacescimror eam.o© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom(e RecalculatebealkiskscoC) RemoveDeleteMarkersd(e) Remove-xoiredNudoes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCorAulomaleakeporissendcommand.onoC AutomatedReportsCommand.php X) AutomatedReportsService.phpу ІгаскrrovlderinstalleacventoneC ActivityLogged.php(e AutomatedRenortscalllbackService.onv© RequestGenerateAsKJiminnyReportJob.php(©) RequestGenerateReportJob.phpc) Automate reponkesuiconoclass AutomatedReportsCommand extends Command52public function handle(): intislonaay = oisMonady,'isFirstDay0fMonth' => $isFirstDay0fMonth,'currentMonth' => $currentMonth,'isQuarterLyMonth' => $isQuarterlyMonth,© AutomatedReport.php= custom.log= laravel.log< console PRODIL console [EUlA SF ljiminny@localhost]A HS_local [iminny@localhost]A console [STAGING] >© AskJiminnyReportActivityService.phpC RequestGenerateAskJiminnyReportJobTest.phpx:AutovPlaygroundma liminny vCONCAT(u.id, CASE WHEN U.id = t.owner_id THEN ' (owner i016 A13 V13 M V517518519520521-522523u.email,sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':5251520I);15Z8// Process daily reports,529$this->processReports( frequency: AutomatedReportsService::FREQUEIProcess weekly reports on Mondavs531if ($isMonday) {532533$this->processReports( frequency: AutomatedReportsService::FRI535// Process monthly reports on the first day of the month536if ($isFirstDay0fMonth) €537Sthis-›processReports ( frequency: AutomatedReportsService: :FR,538select * from teams where id = 1;select * from groups g JOIN playbooks p1..n<-›1: on g.playbook_id = p.id where g.tselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uvid, type, provider, playbook_category_id, user_id, lead_id, contact_id, ac# crm_confiquration id, crm_provider_1d, transcription_1d, stacusfrom activities where crm confiquration id = 1 and tvoe = 'conferencel# 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; # 00U0400000pCZojMAC8691// Process quarterly reports on the first day of January, April541if ($isFirstDay0fMonth && $isQuarterlyMonth) {542$this->processReports( frequency: AutomatedReportsService::FRI544545$this->logger->info(self::LOG_PREFIX . ' Completed');546547return 0;15481542select 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 = 'event";SELECT * FROM crm_field_values WHERE crm_field_id = 4;97100101102103104551552* Process reports for a specific frequency.553* @param string $frequency554555* Oreturn void5565575584 usaoesprivate function processReports(string $frequency): void559560$this->logger->info(self::LOG_PREFIX . " Processing $frequency561562select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * 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-exRinesaat >= now() OR r.expinesaat IS NULL);106107108109110111112Windsurf changelog 2.12.21: A new version is available. // View Changelog (41 minutes ago)// Get all enabled, not deleted reports with active teams for$reports = $this->reportRepository->getActiveReportsByFrequency564select * from automated_report_results where ceRontaid IN (18, 33);//$reports = collect([AutomatedReport:: find(68)]);565select * from automated_reports;566 vselect * from automated_report_results where cepontaia IN (34):$this->logger->info(self::L0G_PREFIX . " Found ($reports->count/** @var AutomatedReport $report */foreach ($reports as $report) {, 0lablf Support Daily • in 3h 46 mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 11:14:35CascadeFixing ReportControlleAutomated Report Faill+D ...Now let me also read RequestGenerateReportJob-php fully to get the complete picture:Read RequSAlus FArLED Is serov woloos-neresacomoere oreakeowniWhere STATUS_FATLED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):• RequestGenerateReportJob.php:236-244$count = (int) $content['response'];if ($count < self::MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIES);return TalserMIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Triager 2 - Any Throwable excention ( REASON PROPHET APT ERROR or REASON DEFAULT ):• RequestGenerateReportJob.php:125-151j catch (Throwable $exception) {sreason = sexcention instanceot ProphetExcention 7AutomatedReportResult::REASON_PROPHET_API_ERROR : AutomatedReportResult::REASON_DEFAULT;$this->tailReport(Sreason):if (sthis-sattempts() < sthis-atries) 1$this->release(30): // retry after 30s} else (sthis->tan Sexcent ion :ProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)• Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpoint returns no response key, DB errors, etc.)Ine job retries once (2 tries total) berore tinal fallureAlso: checkActivityCount throws ApiResponseException if the count API response is malformed — this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.php)Same pattern but MIN ACTIVITIES COUNT is 1:Trigger 1 - Fewer than 1 activity from the saved search → REASON_NOT_ ENOUGH_ACTIVITIESTrigger 2 - Any exception → REASON_PROPHET_API_ERROR if ProphetException, else REASON_DEFAULT . Retries once with 30s delay.Summary of Failure CausesReasoniREASON_NOT_ENOUGH_ACTIVITIESREASON_PROPHET_API_ERRORREASON_DEFAULTValueCauseDate range has < 10 activities (standard) or < 1 (Ask Jiminny)Prophet Al API threw an exceptionAny other exception (DB error, malformed API response, network, etc.)The reason field on the AutomatedReportResult record will tell you exactly which case applies.Oal *Ask anything (884L)+ <> CodeClaude Sonnet 4.6Winasun leamsS1:1ouir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
10150
|
|
10149
|
Notion CalendarEditViewWindowHelpallSupport Daily Notion CalendarEditViewWindowHelpallSupport Daily - in 3h 46 m100% <47Tue 14 Apr 11:14:33+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10149
|
|
10148
|
PhpStormProject vFileFV faVsco.js vEditViewNavigat PhpStormProject vFileFV faVsco.js vEditViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny K vToolsWindowHelpProphetAiv D Reports© AutomatedReportsCl© AutomatedReportsRe© AutomatedReportsSt© CreateMockAskJimir© DeleteReportComma© GenerateMarketingR© Team.php© Usage.phpD Slack• TeamsD TracksO TranscriptionO TwilioD UsersVocabularyDZoom© CoachingFeedbacksUpr© Command.phpc Crearevaroaseusers.oc Daraoase oecountoi© DeleteOldAiCrmNotesC:© DeleteS3LeftoversComiDevPostmanCommand./© DiarizeViaAiParticipantk© EncryptTokensComman© EngagementStatsRegen© FeatureFlagsHelper.php© FixCrossTenantlssues.p© FlushRolesPermissionsCC) GeneratelnternalWebho• GroupSetDefaultLangua© HelperTruncateCoachin© HubspotJournalPollingC© HubspotWebhookServic©ImportRecording.phpImportUsersFromCsvFil© IterateUsersCommand.p(©) JiminnyCacheClearCom(c) minnv Deouacommanc(c)Jminnvser-ncrvotedio(c) Jiminny okenintocomm© MakeSlackLiveCoaching(c Manacescimror eam.o© MarkBranchForEnvironn© MuteOrganizerChannel.© PhpApm.php© PropagateCoachingFeer© PurgeConferences.php© PurgeSoftDeletedOppor© PurgeSyncBatchesCom(e RecalculatebealkiskscoC) RemoveDeleteMarkersd(e) Remove-xoiredNudoes© RemoveUnusedParticip:© ResetElasticSearch.php© RestoreActivityCrmProv© RestoreActivityTypeCor© ReportController.phpJiminnybeouecommana.ongAulomaleakeporissendcommand.onoC AutomatedReportsCommand.php X) AutomatedReportsService.phpу ІгаскrrovlderinstalleacventoneC ActivityLogged.php(e AutomatedRenortscalllbackService.onv© RequestGenerateAsKJiminnyReportJob.php(©) RequestGenerateReportJob.phpc) Automate reponkesuiconoclass AutomatedReportsCommand extends Command52public function handle(): intislonaay = oisMonady,'isFirstDay0fMonth' => $isFirstDay0fMonth,'currentMonth' => $currentMonth,'isQuarterLyMonth' => $isQuarterlyMonth,© AutomatedReport.php= custom.log= laravel.log< console PRODIL console [EUlA SF ljiminny@localhost]A HS_local [iminny@localhost]A console [STAGING] >© AskJiminnyReportActivityService.phpC RequestGenerateAskJiminnyReportJobTest.phpx:AutovPlaygroundma liminny vCONCAT(u.id, CASE WHEN U.id = t.owner_id THEN ' (owner i016 A13 V13 M V517518519520521-522523u.email,sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE u.team_id = 1 and sa.provider = 'salesforce':8691971001011021031045251520I);15Z8// Process daily reports,529$this->processReports( frequency: AutomatedReportsService::FREQUEIProcess weekly reports on Mondavs531if ($isMonday) {532533$this->processReports( frequency: AutomatedReportsService::FRI535536// Process monthly reports on the first day of the monthif ($isFirstDay0fMonth) €537Sthis-›processReports ( frequency: AutomatedReportsService: :FR,538540// Process quarterly reports on the first day of January, April541if ($isFirstDay0fMonth && $isQuarterlyMonth) {542$this->processReports( frequency: AutomatedReportsService::FRI543544545$this->logger->info(self::LOG_PREFIX . ' Completed');546547return 0;15481542551552* Process reports for a specific frequency.553* @param string $frequency554555* Oreturn void5565575584 usaoesprivate function processReports(string $frequency): void559560$this->logger->info(self::LOG_PREFIX . " Processing $frequency561562select * from teams where id = 1;select * from groups g JOIN playbooks p1..n<-›1: on g.playbook_id = p.id where g.tselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;select * from playbook_categories where playbook_id = 175;select * from users where team_id = 1;select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uvid, type, provider, playbook_category_id, user_id, lead_id, contact_id, ac# crm_confiquration id, crm_provider_1d, transcription_1d, stacusfrom activities where crm confiquration id = 1 and tvoe = 'conferencel# 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 = 'event";SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl1<->1..n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * 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-exRinesaat >= now() OR r.expinesaat IS NULL);106107108109110111112Windsurf changelog 2.12.21: A new version is available. // View Changelog (41 minutes ago)// Get all enabled, not deleted reports with active teams for$reports = $this->reportRepository->getActiveReportsByFrequency564select * from automated_report_results where ceRontaid IN (18, 33);//$reports = collect([AutomatedReport:: find(68)]);565select * from automated_reports;566 vselect * from automated_report_results where cepontaia IN (34):$this->logger->info(self::L0G_PREFIX . " Found ($reports->count/** @var AutomatedReport $report */foreach ($reports as $report) {, 0lablf Support Daily • in 3h 46 mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 11:14:32CascadeFixing ReportControlleAutomated Report Faill+D ...Now let me also read RequestGenerateReportJob-php fully to get the complete picture:Read RequSAlus FArLED Is serov woloos-neresacomoere oreakeowniWhere STATUS_FATLED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):• RequestGenerateReportJob.php:236-244$count = (int) $content['response'];if ($count < self::MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIES);return TalserMIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Triager 2 - Any Throwable excention ( REASON PROPHET APT ERROR or REASON DEFAULT ):• RequestGenerateReportJob.php:125-151j catch (Throwable $exception) {sreason = sexcention instanceot ProphetExcention 7AutomatedReportResult::REASON_PROPHET_API_ERROR : AutomatedReportResult::REASON_DEFAULT;$this->tailReport(Sreason):if (sthis-sattempts() < sthis-atries) 1$this->release(30): // retry after 30s} else (sthis->tan Sexcent ion :ProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)• Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpoint returns no response key, DB errors, etc.)Ine job retries once (2 tries total) berore tinal fallureAlso: checkActivityCount throws ApiResponseException if the count API response is malformed — this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.php)Same pattern but MIN ACTIVITIES COUNT is 1:Trigger 1 - Fewer than 1 activity from the saved search → REASON_NOT_ ENOUGH_ACTIVITIESTrigger 2 - Any exception → REASON_PROPHET_API_ERROR if ProphetException, else REASON_DEFAULT . Retries once with 30s delay.Summary of Failure CausesReasoniREASON_NOT_ENOUGH_ACTIVITIESREASON_PROPHET_API_ERRORREASON_DEFAULTvalleCauseDate range has < 10 activities (standard) or < 1 (Ask Jiminny)Prophet Al API threw an exceptionAny other exception (DB error, malformed API response, network, etc.)The reason field on the AutomatedReportResult record will tell you exactly which case applies.Oal *Ask anything (884L)+ <> CodeClaude Sonnet 4.6Winasun leamsS1:1ouir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
10148
|
|
10147
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
10147
|
|
10146
|
Notion CalendarEditViewWindowHelpallSupport Daily Notion CalendarEditViewWindowHelpallSupport Daily - in 3h 46 m100% <47Tue 14 Apr 11:14:30+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10146
|
|
10145
|
PhpStormFileViewNavigateCodeLaravelRetactonToolsWi PhpStormFileViewNavigateCodeLaravelRetactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny kvProject vc) ReportController.onpJiminnyDeouecommana.ongAutomaleakeporssenacommana.ongAutomaleakeportscommana.ongProphetAiAulomaleakeporskeposilory.oneAulomaleakeporisservice.onpc CrealenelaAcuiviyevent.ono© TrackProviderInstalledEvent.phpv → Reports) CreateActivityLoggedevent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C AutomatedReportsC(©) AutomatedReportsR© AutomatedReportssC) RequestGenerateaskJiminnykepordob.onpC RequestGenerateReportJob.phpC) AutomatedReportResult.php(C) Automateakeportonpclass AutomatedReportsCommand extends Command© CreateMockAsKJimirC DeleteReportcomma© GenerateMarketingR©leam.phpC Usage.phpM Slack→ Teams→ Tracks_ TranscriptionD TwilioD Users_ Vocabulary_ 40om© coachingreedbacksupg command.phpcreateDatabaseusers.pc Daraoase oecountoiC DeleteOldAiCrmNotesC(©) DeleteS3LeftoversCom|(C DevPostmanCommand.C DiarizeViaAiParticipantl(©) EncryptTokensCommar(©) EngagementStatsRegerT FeatureFlagsHelper.php© rixcross|enantissues.p(c) -ushro espermissionsa(e) Generatelnterna wepho(C) GroupSetDefaultLanquaC) HelperTruncateCoachin(©) HubspotJournalPollingC(©) HubspotWebhookServic(©) ImportRecording.phpC ImportUsersFromCsvFilC IterateUsersCommand.(©) JiminnyCacheClearCom© JiminnyDebugCommanc© Jiminnysetencryptedlo(c) Jiminny okenintocommMakeslackLvecoaching(c Manacescimror eam.oc мarkbranchrorenvironh(C) MuteOrganizerChannel.(C) PhpApm.php(C PropagateCoachingFee(©) PurgeConterences.php9899119A1(©) PurgeSoftDeletedOppol© PurgeSyncBatchesCom(e Recalculatebealkisksco(c) Removebe eremarkersc1L02(e) Remove-xoiredNudoes1IOSc removeunusecrarcloC ResetElasticSearch.php(C) RestoreActivityCrmProv(C) RestoreActivityTypeCor1041051106107public function handleo: intpiow verbotechonednsmonday = show->istondavoSisFirstDav0fMonth = Snow->dav === 1:ScurrentMonth = Snow->nonth:Check if the current month is a quarterly month January. April, July. October)SisQuarterlyMonth = in_array$currentMonth, 1, 4, 7. 101.strict: true):sthis->Logger->1nfo(self::L06_PREFIX•' Checking conditions',"isMonday' => $1sMonday"1sFirscbayutlonch = s1srirstuayurmonch,"currentrlonch" = scurrencronch,"Isquarterlyronth" = pisquarcerlymonch,101Process daily reportssthis->processReports( frequency: AutomatedReportsService::FREQUENCY_DAILYO:/ Process weekly reports on Mondaysif (s1slonday)sth1s->processReports trequency: AutomatedReportsservice::FREQUENCY_WEEKLY)*// Process monthly reports on the first day of the monthif (SisFirstDav0fMonth) &nunus-porocessreoors trecuency. Aurolcreckeoorsseru cer.rrcuuciey murinsreProcess quarterly reports on the first day of January. April, July. and Octobenif SisFirstDay0fMonth &x SisQuarterlyMonth)sth1s->processReports trequency: AutomatedReportsservice::FREQUENCY_QUARTERLYJ*$this->logger->info(self::LOG_PREFIX . ' Completed');return 0:l/*** Process reports for a specific frequencu* @param string $frequency* dreturn void4 usagesonvate tuncrion orocesskeporus scrino otreduency. voo$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");Get all enabled, not deleted reports with active teams for the specified frequencySreports = Sthis->reportRepository->getActiveReportsByFrequency$frequency) :$reports = collect( AutomatedReport::find(68).0:Winasurt changelog 2.12.21: A new version is avallable. | View Changelog (41 minutes ago)hal• Support Daily • in 3h 46 m100% |45]Tue 14 Apr 11:14:16RequestGenerateAskJiminnyReportJobTest v= custom.log= laravel.logc SF (iminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGINGASkJIminnykeportActivilyservice.onoC RequestGenerateAskJiminnyReportJobTest.php51751815191579152111524152552415255265271539155315545365385395405411542154.51154415451154054754854955055155255355415551556155 A15575605615625631564So51p oIx. AUto VFlaycroundvliminnyCONCAT(U.1d, CASE WHEN U.1d = t.owner_1d THEN ' (owner)' ELSE '' END) AS User_1d016 413 V,13 ^U.emallsa.*t.owner_ld Frun soclal_accounts saauvusers u on urd = sa.socaole ..olJuI reansI.n<→>I: on t.1d = U.ceam_1dWHERE U.team_id = 1 and sa.provider = 'salesforce':select x Tron teams wnere 10 = 11select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * fromgroups where id = 565:select * from playbooks where team_id = 1select * from playbooks where 1d = 175;select * from playbook_categories where playbooK_1d = 175*select * from users where team_1d = 1;select * trom users where 10 = 7160;select * trom crm_proriles where user_1d = 7160;select * trom reatures,setect# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm confiquration id,crm_provider id, transcription id, statusfrom activities where crm_ confiquration id = 1 and type ="conference'# and crm_provider_1d IS NOT NULLand provider != 'uploader'and actual_start_time 1S NOT NULLORDER by 1d desc;select * trom aculvitles where 10 = 54/47/85; # 0000400006pCzoJMACselect p.1d, p.accivicy_type, pc.1d, pc.namerkoM playbooks pioin plavbook categories pc 1<->1.n: on p.id = pc.plavbook idwhere p.team_ id = 1 and p.activity type = 'event':SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event":SELECT * FROM crm_field_values WHERE crm_field_id = 4select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbook_1d = 175select * trom teams;SELECl r.* FRun automated_reports nmoun reais t on r.reall 10 = 1.10WHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD):select * from automated_report_results where report 1d IN (18, 35)*5o6 Mselect * trom automated_reports;select * from automated_report_results where report id IN (34);W Windsurf Teams 91:18UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
10145
|
|
10144
|
PhpStormFileFditViewNavigateCodeLaravelRefactonToo PhpStormFileFditViewNavigateCodeLaravelRefactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny K vProject v(©) ReportController.php©) JiminnyDebugCommand.phpc) AutomatedReorssenccommane.onoAutomaleakeporscommana.ongD ProphetAiAulomaleakeporskeposilory.oneAulomaleakeporisservice.onp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpv → Reports© CreateActivityLoggedevent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C AutomatedReportsC(©) AutomatedReportsR© AutomatedReportss(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.phpC) AutomatedReport.phpclass AutomatedReportsCommand extends Command© CreateMockAsKJimirpublic function handleo: intC DeleteReportcomma© GenerateMarketingR©leam.phpC Usage.phpM SlackProcess quarterly reports on the first day of January. April, July. and Octoberif SisFirstDay0fMonth &x SisQuarterlyMonth)sthis->processReports( frequency: AutomatedReportsService::FREQUENCY_OUARTERLYO:_leams→ Tracks_ Transcription$this->logger->info(self::L0G_PREFIX . ' Completed');D TwilioD Usersrecurn o;_ Vocabulary_ 4oom93© coachingeedbacksupcg command.php* Process reports for a specific freauencu.createDatabaseusers.pc Daraoase oecountoi* dparam string SfrequencyC DeleteOldAiCrmNotesC(©) DeleteS3LeftoversCom|* dreturn void(C DevPostmanCommand.lC DiarizeViaAiParticipantk4 usdyes(©) EncryptTokensCommar(©) EngagementStatsRegerT FeatureFlagsHelper.php101102ML05private function processreports(string sfrequency): vold$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");© rixcross|enantissues.p11041(c) -ushro espermissionsaGet all enabled. not deleted reports with active teams for the specified freauencv(e) Generatelnterna wepho106107Sreports = $this->reportRepository->qetActiveReportsByFrequency($frequency):$reports = collect( AutomatedReport:: find(68)0:Local ChangesShelfLOOconsoleLog x+ VChanges 9 files= .env.local appActivityController.php app/Http/Controllers/APITVO<→Side-by-side viewerDo not ignoreHighlight words -x 13 ?mb 0seou aoeconsoecomnanes/reoors Automarecre.orscommane.onealVralnCalle Telaalnn elatn ce© AutomatedReportsCommana.php app/console/Commands/Rersthis->logger->info(self::L0G_PREFIX ." Processing Sfrequency reports"):© JiminnyDebugCommand.php app/console/commandsphp logging.php contig(C) PlavbackService.php app/ServicesGet all enabled, not deleted reports with active teams for the specified frequencySreports = $this->reportRepository->getActiveReportsByFrequency($frequency)=© ReportController.php app/Http/Controllers/Webhook(C SyncTolntercom.php app/Jobs/Teamsthis->logger->1nfo(self::L0G_PREFIX •" Found isreports->countor strequency reports to process"):php web.php routes> Unversioned Files 8 files/** ovar Automacedкeport sreporс x/$job = Sreport->isAskJiminnyReport("new necuestuenerarerstoinnvreoortdoo oreoor-oeuurooo:new RequestGenerateReportJob(Sreport->getUuidO:sthis->dispatcher->dispatch(Sjob):, 0hal• Support Daily • in 3h 46 m100% [Tue 14 Apr 11:14:14RequestGenerateAskJiminnyReportJobTest v= custom.loc= laravel.logc SF (iminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGING© AskJiminnyReportActivityService.phpV5451540154/548549550551552553155415551556155 A1558155756056156215631564565C RequestGenerateAskJiminnyReportJobTest.phpP 0Tx: Auto vPlaygroundliminny016 413 V13 ^select p.1d, p.accivicy_type, pc.1d, pc.nameFRoM playbooks pJoin playbook_cacegories po1<->1..n: on p.id = pc.playbook_idwhere p.team id = 1 and p.activity type = 'event':SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event":SELECT * FROM crm_field_values WHERE crm_field_id = 4:select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175;select * trom teams;SELECI r.* FRUM aucomaced_reporcs rnoun realis i on rrreall 10 = 1.10WHERE r.frequency = 'daily'and f. stauusAND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD):select * from automated_report_results where report 1d IN (18, 35)*5o6 Mselect * trom aucomated_reports;select * from automated_report_results where report id IN (34):2 diffrHide t0Curent versionVviminny console commanes keooris › Aulomaleoreporscommane › processkeporssthis->Loqger->info(self::L0G_PREFIX . " Processing Sfrequency reports"):Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency):sreports = collect(lAutomatedReport::f1nd(68)|)$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process"):/** dvar AutomatedReport Sreport *Siob = Sreport->isAskJiminnvReportO? new RequestGenerateAskJiminnyReportJob($report->getUuidO):new RequestGenerateReportJob($report->getUvidO);Sthis->dispatcher->dispatch(Sjob);sth1s->d1spatcher->d1spatchsync(s7ob);Hide the active lool windowwinasun leamsJ1.lduir-oia 4 spaces...
|
NULL
|
NULL
|
NULL
|
10144
|
|
10143
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
10143
|
|
10142
|
PhpStormFileFditViewNavigateCodeLaravelRefactonToo PhpStormFileFditViewNavigateCodeLaravelRefactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny K vProject v(©) ReportController.php©) JiminnyDebugCommand.phpc) AutomatedReorssenccommane.onoAutomaleakeporscommana.ongD ProphetAiAulomaleakeporskeposilory.oneAulomaleakeporisservice.onp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpv → Reports© CreateActivityLoggedevent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C AutomatedReportsC(©) AutomatedReportsR© AutomatedReportss(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.phpC) AutomatedReport.phpclass AutomatedReportsCommand extends Command© CreateMockAsKJimirpublic function handleo: intC DeleteReportcomma© GenerateMarketingR©leam.phpC Usage.phpM SlackProcess quarterly reports on the first day of January. April, July. and Octoberif SisFirstDay0fMonth &x SisQuarterlyMonth)sthis->processReports( frequency: AutomatedReportsService::FREQUENCY_OUARTERLYO:_leams→ Tracks_ Transcription$this->logger->info(self::L0G_PREFIX . ' Completed');D TwilioD Usersrecurn o;_ Vocabulary_ 4oom93© coachingeedbacksupcg command.php* Process reports for a specific freauencu.createDatabaseusers.pc Daraoase oecountoi* dparam string SfrequencyC DeleteOldAiCrmNotesC(©) DeleteS3LeftoversCom|* dreturn void(C DevPostmanCommand.lC DiarizeViaAiParticipantk4 usdyes(©) EncryptTokensCommar(©) EngagementStatsRegerT FeatureFlagsHelper.php101102ML05private function processreports(string sfrequency): vold$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");© rixcross|enantissues.p11041(c) -ushro espermissionsaGet all enabled. not deleted reports with active teams for the specified freauencv(e) Generatelnterna wepho106107Sreports = $this->reportRepository->qetActiveReportsByFrequency($frequency):$reports = collect( AutomatedReport:: find(68)0:Local ChangesShelfLOOconsoleLog x+ VChanges 9 files= .env.local appActivityController.php app/Http/Controllers/APITVO<→Side-by-side viewerDo not ignoreHighlight words -x 13 ?mb 0seou aoeconsoecomnanes/reoors Automarecre.orscommane.oneuiminny console commanas ke© AutomatedReportsicommana.php app/console/Commands/Rsthis->logger->info(self::L0G_PREFIX ." Processing Sfrequency reports"):© JiminnyDebugCommand.php app/console/commandsphp logging.php contigC PlaybackService.php app/services© ReportController.php app/Http/Controllers/Webhook(C SyncTolntercom.php app/Jobs/TeamGet all enabled, not deleted reports with active teams for the specified frequencySreports = $this->reportRepository->getActiveReportsByFrequency($frequency)=sthis->logger->1nfo(self::L0G_PREFIX •" Found isreports->countor strequency reports to process"):php web.php routes> Unversioned Files 8 files/** ovar Automacedкeport sreporс x/$job = Sreport->isAskJiminnyReport("new necuestuenerarerstoinnvreoortdoo oreoor-oeuurooo:new RequestGenerateReportJob(Sreport->getUuidO:sthis->dispatcher->dispatch(Sjob):, 0hal• Support Daily • in 3h 46 m100% [Tue 14 Apr 11:14:06• RequestGenerateAskJiminnyReportJobTest v= custom.loc= laravel.logc SF (iminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGING© AskJiminnyReportActivityService.phpV5451540154/548549550551552553155415551556155 A1558155756056156215631564565C RequestGenerateAskJiminnyReportJobTest.phpP 0Tx: Auto vPlaygroundliminny016 413 V13 ^select p.1d, p.accivicy_type, pc.1d, pc.nameFRoM playbooks pJoin playbook_cacegories po1<->1..n: on p.id = pc.playbook_idwhere p.team id = 1 and p.activity type = 'event':SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event":SELECT * FROM crm_field_values WHERE crm_field_id = 4:select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175;select * trom teams;SELECI r.* FRUM aucomaced_reporcs rnoun realis i on rrreall 10 = 1.10WHERE r.frequency = 'daily'and f. stauusAND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD):select * from automated_report_results where report 1d IN (18, 35)*5o6 Mselect * trom automated_reports;select * from automated_report_results where report id IN (34):2 differencesCurent versionVviminny console commanes keooris › Aulomaleoreporscommane › processkeporssthis->Loqger->info(self::L0G_PREFIX . " Processing Sfrequency reports"):Get all enabled, not deleted reports with active teams for the specified frequency$reports = $this->reportRepository->getActiveReportsByFrequency($frequency):sreports = collect(lAutomatedReport::f1nd(68)|)$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process"):/** dvar AutomatedReport Sreport *Siob = Sreport->isAskJiminnvReportO? new RequestGenerateAskJiminnyReportJob($report->getUuidO):new RequestGenerateReportJob($report->getUvidO);Sthis->dispatcher->dispatch(Sjob);sth1s->d1spatcher->d1spatchsync(s7ob);Winasurt changelog 2.12.21: A new version is avallable. |/ View Changelog (40 minutes ago,winasun leamsJ1.lduir-oia 4 spaces...
|
NULL
|
NULL
|
NULL
|
10142
|
|
10141
|
Notion CalendarEditViewWindowHelpallSupport Daily Notion CalendarEditViewWindowHelpallSupport Daily - in 3h 46 m100% <47Tue 14 Apr 11:14:04+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10141
|
|
10140
|
PhpStormFileFditViewNavigateCodeLaravelRetactonToo PhpStormFileFditViewNavigateCodeLaravelRetactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny K vProject vD ProphetAiv → Reports(C AutomatedReportsC(©) AutomatedReportsR© AutomatedReportss© CreateMockAsKJimirC DeleteReportcomma© GenerateMarketingR©leam.phpC Usage.phpM Slack_leams→ Tracks_ TranscriptionD TwilioD Users_ Vocabulary_ 4oom© coachingreedbacksupg command.phpcreateDatabaseusers.pc Daraoase oecountoiC DeleteOldAiCrmNotesC(©) DeleteS3LeftoversCom|(C DevPostmanCommand.lC DiarizeViaAiParticipantk(©) EncryptTokensCommar(©) EngagementStatsRegerT FeatureFlagsHelper.php© rixcross|enantissues.p(c) -ushro espermissionsa(e) Generatelnterna wephoShelf(©) ReportController.php© JiminnyDebugCommand.phpc) AutomatedReporssenccommane.onoAutomatedReportsCommand.php XAulomaleakeporskeposilory.oneC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© CreateActivityLoggedevent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(©) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.php(C) Automateakeportonpclass AutomatedReportsCommand extends Commandpublic function handleo: intProcess quarterly reports on the first day of January. April, July, and Octobenif SisFirstDay0fMonth &x SisQuarterlyMonth)sthis->processReports( frequency: AutomatedReportsService::FREQUENCY_OUARTERLYO:$this->logger->info(self::L0G_PREFIX . ' Completed');recurn o;93* Process reports for a specific freauencu.* dparam string Sfrequency* dreturn void4 usdyesprivate function processreports(string sfrequency): vo1d102ML05$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");11041105Get all enabled. not deleted reports with active teams for the specified freauencv106Sreports = $this->reportRepository->qetActiveReportsByFrequency($frequency) :107$reports = collect( AutomatedReport:: find(68)0:Local ChangesLOOConsoleLog xChanges 91= .env.local appActivityController.php app/Http/Controllers/API© AutomatedReportsCommana.php app/console/Commands/Repc© JiminnyDebugCommand.php app/console/commandsphp logging.php contig(C) PlavbackService.php app/Services(C) ReportController.ohp app/Http/Controllers/Webhook(C SyncTolntercom.php app/Jobs/Teamphp web.php routesUnversioned Files 8 filesWinasurt changelog 2.12.21: A new version is avallable. # View Changelog (40 minutes ago,, 0hal• Support Daily • in 3h 46 m100% [Tue 14 Apr 11:14:03• RequestGenerateAskJiminnyReportJobTest v= custom.loc= laravel.logc SF (iminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGING© AskJiminnyReportActivityService.phpV5451540154/548549550551552553155415551556155 A1558155756056156215631564565C RequestGenerateAskJiminnyReportJobTest.phpP 0Tx: Auto vPlaygroundliminny016 413 V,13 ^select p.1d, p.accivicy_type, pc.1d, pc.nameFRoM playbooks pJoin playbook_cacegories po1<->1..n: on p.id = pc.playbook_idwhere p.team id = 1 and p.activity type = 'event':SELECT * FROM crm_ fields WHERE crm confiquration id = 1 and object type = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4:select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175;select * trom teams;SELECI P.* FRUM aUcomated_reports nnoun realis i on rrreall 10 = 1.10WHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD);select * from automated_report_results where cepantala IN (18, 55);So0vselect * trom automated_reports;select * from automated_report_results where report id IN (34):1567Nothing to showwinasur leams s1.louir-oia 4 spaces...
|
NULL
|
NULL
|
NULL
|
10140
|
|
10139
|
PhpStormFileEoitViewNavigateCodeLaravelRefactonToo PhpStormFileEoitViewNavigateCodeLaravelRefactonToolsWindowHelpFV faVsco.js v#11894 on JY-18909-automated-reports-ask-iminny K vProject vProphetAiv → Reports(C AutomatedReportsC(©) AutomatedReportsR© AutomatedReportss© CreateMockAsKJimirC DeleteReportcomma© GenerateMarketingR©leam.phpC Usage.phpM Slack_leams→ Tracks_ TranscriptionD TwilioD Users_ Vocabulary_ 4oom© coachingreedbacksupg command.phpc Crearevaroaseusers.oc Daraoase oecountoiC DeleteOldAiCrmNotesC(©) DeleteS3LeftoversCom|(C DevPostmanCommand.lC DiarizeViaAiParticipantk(©) EncryptTokensCommar(©) EngagementStatsRegerT FeatureFlagsHelper.php© rixcross|enantissues.p(c) -ushro espermissionsa(e) Generatelnterna wepho(C) GroupSetDefaultLanquaC) HelperTruncateCoachin(©) HubspotJournalPollingC(©) HubspotWebhookServic(©) ImportRecording.phpC ImportUsersFromCsvFilC IterateUsersCommand.g(©) JiminnyCacheClearCom© JiminnyDebugCommanc© Jiminnysetencryptedlo(c) Jiminny okenintocommMakeslackLivecoaching(c Manacescimror eam.o(©) MarkBranchForEnvironn(C) MuteOrganizerChannel.(C) PhpApm.php(C PropagateCoachingFee(©) PurgeConterences.php(©) PurgeSoftDeletedOppot© PurgeSyncBatchesCom(e Recalculatebealkisksco(c) Removebe eremarkersc(e) Remove-xoiredNudoesc removeunusecrarcloC ResetElasticSearch.php(C) RestoreActivityCrmProv(C) RestoreActivityTypeCor(©) ReportController.phpJiminnybeouecommana.ongc) AutomatedReorssenccommane.onoAutomaleakeportscommana.ongAulomaleakeporskeposilory.oneAulomaleakeporisservice.onp© CreateHeldActivityEvent.phpC TrackProviderInstalledEvent.php© CreateActivityLoggedevent.php© ActivityLogged.php© AutomatedReportsCallbackService.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC) AutomatedReportResult.php(C) Automateakeport.pnpclass AutomatedReportsCommand extends Command85101102ML051104110610710810911011111211411711811911201211221231124111261112.public function handleo: intProcess quarterly reports on the first day of January. April, July. and Octoberif SisFirstDay0fMonth &x SisQuarterlyMonth)sthis->processReports( frequency: AutomatedReportsService::FREQUENCY_OUARTERLYO:$this->logger->info(self::L0G_PREFIX . ' Completed');recurn o* Process reports for a specific freauencu.* dparam string Sfrequency* dreturn void4 usdyesprivate function processreports(string sfrequency): vold$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");Get all enabled. not deleted reports with active teams for the specified frequencvSreports = $this->reportRepository->qetActiveReportsByFrequency($frequency):$reports = collect( AutomatedReport::find(68).0:$this->logger->info(self::L0G_PREFIX. " Found (Sreports->countO} Sfrequency reports to process"):/** ovar Automatedreport sreport */foreach (sreports as sreport)$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [reporcuuld = фeроги-geсuula."teamid" = report-›gecleanta),Trequency"=> Sreport->getFrequencyO'tvoe' => Sreport->getTvpeo.I):$job = Sreport->isAskJiminnyReportO?new RequestGenerateASkJ1minnyReportJob(sreport->getuu1do):new RequestGenerateReportJob(sreport->getuu1d00*suhis->a1spaucher->a1spatcn(sjod);puhis->alspatcher->a1spauchsync(sjod);Winasurt changelog 2.12.21: A new version is avallable. | View Changelog (40 minutes ago,hal• Support Daily • in 3h 46 m100% |45]Tue 14 Apr 11:14:01RequestGenerateAskJiminnyReportJobTest v= custom.log= laravel.logc SF (iminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGINGASkJIminnykeportActivilyservice.onoC RequestGenerateAskJiminnyReportJobTest.php51751815191152111524152552415250405271539155315545365385395405411542154.5115451154054754854955A552555155415551556155 A15570005615625631564So51p oIx. AUto VFlaycroundvliminnyCONCAT(U.1d, CASE WHEN U.1d = t.owner_1d THEN ' (owner)' ELSE '' END) AS User_1d016 413 V,13 ^U.emallsa.*t.owner_ld Frun soclal_accounts saauvusers u on urd z sa.socaole .lolJuI reansI.n<→>I: on t.1d = U.team_1dWHERE U.team_id = 1 and sa.provider = 'salesforce':select x Tron teams wnere 10 = 11select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565;select * from playbooks where team_id = 1select * from playbooks where 1d = 175:select * from playbook_categories where playbooK_1d = 175*select * from users where team_1d = 1;select * trom users where 10 = 7160;select * trom crm_proriles where user_1d = 7160;select * trom reatures,select# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm confiquration id, crm provider id, transcription id, statusfrom activities where crm_ confiquration id = 1 and type ="conference'# and crm_provider_1d IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by 1d desc;select * trom aculvitles where 10 = 54/47/85; # 0000400006pCzoJMACselect p.1d, p.accivicy_type, pc.1d, pc.namerkoM playbooks pioin plavbook categories pc 1<->1.n: on p.id = pc.plavbook idwhere p.team_ id = 1 and p.activity type = 'event':SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl.Layout_1dwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175select * trom teams;SELECl r.* FRun automated_reports nmoun reais t on r.reall 10 = 1.10WHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD);select * from automated_report_results where report 1d IN (18, 35)*5o6 Mselect * trom aucomated_reports;select * from automated_report_results where report id IN (34);W Windsurf Teams 91:18UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
10139
|
|
10138
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:14:00+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10138
|
|
10137
|
PhpStormFileFditViewNavigateCodeLaravelRetactonToo PhpStormFileFditViewNavigateCodeLaravelRetactonToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny K vProject vC) AiPrompt.php(©) ReportController.php© JiminnyDebugCommand.phpc) AutomatedReorssenccommane.onoAutomatedkeportsComand.phpxC AutomatedReportsRepository.phpC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpC) AutomatedReport.php© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© AutomatedReportResult.phC) Calendar.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC AutomatedReportResult.php(C) Automateakeport.onpc) Callimport.phpclass AutomatedReportResult extends Model© CoachingFeedback.php© Coachingt-eedbackVisibilit© Coachingsection.php© CoachingSectionCriterion.pC) CoachinaSectionCriterionFC) CoachinaSectionFeedback© CommentAbstract.png1 Commentinterface.phpC) Contact.phpC Device.phpC EmailMessage.phpC) GenericAiPrompt.php© Group.phpC Inbox.php© InboxEmall.phpC InboxEmailBatch.pnpC Invitation.ohpC JobLog.phpC) JobTitle.phpC Lanquage.phpC LanguageDialect.phpC Lead.phpC MobileSetting.phpg Model.php© Moment.php© Nudge.php© NudgeRun.phpC) Opportunitv.phoC) Participant.pho© Partner.phpC) Permission.phpC) PhoneNumber.phpC PlaybackTheme.phpc Playbook.phpC PlaybookCategory.php© Playlist.php© RateLimit.php© Region.phpC) Role phpC) RoleChangeEvent.php(C) ScopeGroup.phpC) Session.phpC) SlackBot.php© SocialAccount.phpC Stage.phpC Task.phpg Team.php© leamAiContext.php© leamDomain.php© TeamFeature.phpC) TeamSettinas.phoC TextRelay.php© Track.phcC) TranscriptionModel.php53 Ct54555760 G6379d>o usaeespublic const int STATUS_DEFAULT = 0:o usagespublic const int STATUS_REQUESTED = 1116 usagespublic const int STATUS_GENERATED = 2,pubLic const 1nt SIATUS_SENI = 5:public const int STATUS_FAILED = 4;/*** keason conscantso usaeespublic const int REASON_DEFAULT = 0;4 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 15 usagesPUDLIC Const Int REASUN_PRUPHEI_APL_ERRUR = 21procecced stable = 'automaced_report_results:* The attributes that are mass assignable.* @var arrausint, string>*/protected sfillable = l'report_1d','name','status',"reason","meona twoe."Dalrent o.'payLoad "'response'.'requested at','generated_at","sent_at",*Ger the duroues tnr should de ciste* dreturn array<string, string>protected function casts(): arrayt.../*** Get the automated report that owns this result.* dreturn Belongstopublic function report(): BelongsTo{...}Windsurf changelog 2.12.21: A new version is available. // View Changelog (40 minutes ago)B8 м1м1^a Support Daily • in 3 h 47 m100% |45]Tue 14 Apr 11:14:00RequestGenerateAsk.JiminnvRenort.lobTestv= custom.loc= laravel.logc SF liminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGING© AskJiminnyReportActivityService.php517.5181519115211→5543505375385395405411542154.154454854915551556155 A-3005615625631564So51C RequestGenerateAskJiminnyReportJobTest.phpp oIx. AUto VFlaycroundvliminnyCONCAT(U.1d, CASE WHEN U.1d = t.owner_1d THEN ' (owner)' ELSE'' END) AS USer_1d016 413 ×,13 ^U.emall,sa.*t.owner_ld Frun soclal_accounts saauvusers u on urd z sa.socaole .lolJuI reansI.n<→>I: on t.1d = U.ceam_1dWHERE U.team_id = 1 and sa.provider = 'salesforce' ;select x Tron teams wnere 10 = 11select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565;select * from playbooks where team_id = 1select * from playbooks where 1d = 175:select * from playbook_categories where playbook_1d = 175select * from users where team_1d = 1;select * trom users where 10 = 7160;select * trom crm_proriles where user_1d = 7160;select * trom reatures,select# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm confiquration id,crm_provider id, transcription id, statusfrom activities where crm confiquration id = 1 and type ="conference'# and crm_provider_1d IS NOT NULLand provider != 'uploader' and actual_start_time 1S NOT NULLORDER by 1d desc;select * trom aculvitles where 10 = 54/4/785; # 0e00406006PCzOJMALselect p.1d, p.accivicy_type, pc.1d, pc.namerkoM playbooks pioin plavbook categories pc 1<->1.n: on p.id = pc.plavbook idwhere p.team id = 1 and p.activity type = 'event':SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175select * tron reans.SELECl r.* FRun automated_reports nnoun realis i on rrreall 10 = 1.10WHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD);select * from automated_report_results where report 1d IN (18, 35)*So0vselect * trom automated_reports;select * from automated_report_results where report id IN (34):W Windsurf Teams 57:7UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
10137
|
|
10136
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Sync Changes
Hide This Notification
Code changed:
Hide
<?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Process automated reports based on their frequency (weekly, monthly, quarterly)';
public function __construct(
private readonly LoggerInterface $logger,
private readonly BusDispatcher $dispatcher,
private readonly AutomatedReportsRepository $reportRepository
) {
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle(): int
{
$this->logger->info(self::LOG_PREFIX . ' Started');
$now = Carbon::now();
$isMonday = $now->isMonday();
$isFirstDayOfMonth = $now->day === 1;
$currentMonth = $now->month;
// Check if the current month is a quarterly month (January, April, July, October)
$isQuarterlyMonth = in_array($currentMonth, [1, 4, 7, 10], true);
$this->logger->info(self::LOG_PREFIX . ' Checking conditions', [
'isMonday' => $isMonday,
'isFirstDayOfMonth' => $isFirstDayOfMonth,
'currentMonth' => $currentMonth,
'isQuarterlyMonth' => $isQuarterlyMonth,
]);
// Process daily reports
$this->processReports(AutomatedReportsService::FREQUENCY_DAILY);
// Process weekly reports on Mondays
if ($isMonday) {
$this->processReports(AutomatedReportsService::FREQUENCY_WEEKLY);
}
// Process monthly reports on the first day of the month
if ($isFirstDayOfMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_MONTHLY);
}
// Process quarterly reports on the first day of January, April, July, and October
if ($isFirstDayOfMonth && $isQuarterlyMonth) {
$this->processReports(AutomatedReportsService::FREQUENCY_QUARTERLY);
}
$this->logger->info(self::LOG_PREFIX . ' Completed');
return 0;
}
/**
* Process reports for a specific frequency.
*
* @param string $frequency
*
* @return void
*/
private function processReports(string $frequency): void
{
$this->logger->info(self::LOG_PREFIX . " Processing $frequency reports");
// Get all enabled, not deleted reports with active teams for the specified frequency
$reports = $this->reportRepository->getActiveReportsByFrequency($frequency);
// $reports = collect([AutomatedReport::find(68)]);
$this->logger->info(self::LOG_PREFIX . " Found {$reports->count()} $frequency reports to process");
/** @var AutomatedReport $report */
foreach ($reports as $report) {
$this->logger->info(self::LOG_PREFIX . ' Dispatching Generate Report job for report', [
'reportUuid' => $report->getUuid(),
'teamId' => $report->getTeamId(),
'frequency' => $report->getFrequency(),
'type' => $report->getType(),
]);
$job = $report->isAskJiminnyReport()
? new RequestGenerateAskJiminnyReportJob($report->getUuid())
: new RequestGenerateReportJob($report->getUuid());
// $this->dispatcher->dispatch($job);
$this->dispatcher->dispatchSync($job);
}
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (34);
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – AutomatedReportsCommand.php
|
NULL
|
10136
|
|
10135
|
PhpStormFileFditViewNavigateCodeLaravelRetactonToo PhpStormFileFditViewNavigateCodeLaravelRetactonToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminny K vProject v(©) ReportController.phpC JiminnyDebugCommand.phpc) AutomatedReporssenccommane.ono(©) AutomatedReportsCommand.phpC) AiPrompt.phpC AutomatedReportsRepository.phpC AutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpC) AutomatedReport.php© CreateActivityLoggedevent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© AutomatedReportResult.phC) Calendar.php(C) RequestGenerateAskJiminnyReportJob.phpC RequestGenerateReportJob.phpC AutomatedReportResult.php(C) Automateakeportonpc) Callimport.phpclass AutomatedReportResult extends Model© CoachingFeedback.php© Coachingt-eedbackVisibilit© Coachingsection.php© CoachingSectionCriterion.pC) CoachinaSectionCriterionFC) CoachinaSectionFeedback© CommentAbstract.png1 Commentinterface.phpC) Contact.phpC Device.phpC EmailMessage.phpC) GenericAiPrompt.php© Group.phpC Inbox.php© InboxEmall.phpC InboxEmailBatch.pnpC Invitation.ohpC JobLog.phpC) JobTitle.phpC Lanquage.phpC LanguageDialect.phpC Lead.phpC MobileSetting.phpg Model.php© Moment.php© Nudge.php© NudgeRun.phpC) Opportunitv.phoC) Participant.pho© Partner.phpC) Permission.phpC) PhoneNumber.phpC PlaybackTheme.phpc Playbook.phpC PlaybookCategory.php© Playlist.php© RateLimit.php© Region.phpC) Role phpC) RoleChangeEvent.pho(C) ScopeGroup.phpC) Session.phpC) SlackBot.php© SocialAccount.phpC Stage.phpC Task.phpg Team.php© leamAiContext.php© leamDomain.php© TeamFeature.phpC) TeamSettinas.phoC TextRelay.php© Track.phcC) TranscriptionModel.php53 Ct55 E5760 G6379d>o usaeespublic const int STATUS_DEFAULT = 0:o usagespublic const int STATUS_REQUESTED = 1116 usagespublic const int STATUS_GENERATED = 2,pubLic const 1nt SIATUS_SENI = 5:public const int STATUS_FAILED = 4;/*** keason conscantso usaeespublic const int REASON_DEFAULT = 0;4 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 15 usagesPUDLIC Const Int REASUN_PRUPHEI_APL_ERRUR = 21procecced stable = 'automaced_report_results:* The attributes that are mass assignable.* @var arrausint, string>*/protected sfillable = l'report_1d','name','status',"reason","meona twoe."Dalrent o.'payLoad "'response'.'requested at','generated_at","sent_at",*Ger the duroues tnr should de ciste* dreturn array<string, string>protected function casts(): arrayt.../*** Get the automated report that owns this result.* dreturn Belongstopublic function report(): BelongsTo{...}Windsurf changelog 2.12.21: A new version is available. // View Changelog (40 minutes ago)B8 м1м1^a Support Daily • in 3 h 47 m100% |45]Tue 14 Apr 11:13:58RequestGenerateAsk.JiminnvRenort.lobTestv= custom.loc= laravel.logc SF liminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGINGI© AskJiminnyReportActivityService.php5175181519115211530531→55415555375385395405411542154.511544154/54815551556155 A-3005615625631564So51C RequestGenerateAskJiminnyReportJobTest.phpp oIx. AUto VFlaycroundvliminnyCONCAT(U.1d, CASE WHEN U.1d = t.owner_1d THEN ' (owner)' ELSE'' END) AS USer_1d016 413 ×,13 ^U.emall,sa.*t.owner_ld Frun soclal_accounts saauvusers u on urd z sa.socaole .lolJuI reansI.n<→>I: on t.1d = U.ceam_1dWHERE U.team_id = 1 and sa.provider = 'salesforce':select * from teams where id = 1:select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565:select * from playbooks where team_id = 1select * from playbooks where 1d = 175;select * from playbook_categories where playbook_1d = 175select * from users where team_1d = 1;select * trom users where 10 = 7160;select * trom crm_proriles where user_1d = 7160;select * trom reatures,select# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm confiquration id,crm_provider id, transcription id, statusfrom activities where crm confiquration id = 1 and type ="conference'# and crm_provider_1d IS NOT NULLand provider != 'uploader' and actual_start_time 1S NOT NULLORDER by 1d desc;select * trom aculvitles where 10 = 54/4/785; # 0e00406006PCzOJMALselect p.1d, p.accivicy_type, pc.1d, pc.namerkoM playbooks pioin plavbook categories pc 1<->1.n: on p.id = pc.plavbook idwhere p.team id = 1 and p.activity type = 'event':SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbooK_1d = 175select * tron reans.SELECl r.* FRun automated_reports nnoun realis i on r.reall 10 = 1.10WHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD):select * from automated_report_results where report 1d IN (18, 35)*So0vselect * trom automated_reports;select * from automated_report_results where report id IN (34);W Windsurf Teams 57:7UTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
10135
|
|
10134
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactorToolsWindowHelp#11804 on.lY-18909-automated-renorts-ask-liminnvkProjectvC) AiPrompt.php© AutomatedReport.php© AutomatedReportResult.ph© Calendar.php© Calllmport.php© CoachingFeedback.php© CoachingFeedbackVisibilit!© CoachingSection.php© CoachingSectionCriterion.f© CoachingSectionCriterionF© CoachingSectionFeedback© CommentAbstract.pngCommentInterface.php© Contact.php© Device.php© EmailMessage.php© GenericAiPrompt.php© Group.php© Inbox.php© InboxEmail.php© InboxEmailBatch.php© Invitation.php© JobLog.php© JobTitle.php© Language.php© LanguageDialect.php© Lead.php© MobileSetting.php© Model.php© Moment.php© Nudge.php© NudgeRun.php© Opportunity.phpC) Participant.pho© Partner.php© Permission.php©PhoneNumber.php© PlaybackTheme.php© Playbook.php© PlaybookCategory.php© Playlist.php© RateLimit.php© Region.phpC) Role php© RoleChangeEvent.php(C) ScopeGroup.php© Session.php© SlackBot.php© SocialAccount.php© Stage.php© Task.php© Team.php© TeamAiContext.php© TeamDomain.php© TeamFeature.php© TeamSettings.php© TextRelay.php© Track.php© TranscriptionModel.php© ReportController.phpAulomaleakeporskeposilory.ono© JiminnyDebugCommand.phpC AutomatedReportsService.php© AutomatedReportsSendCommand.php(©) AutomatedReportsCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(©) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php >© AutomatedReport.phpclass AutomatedReportResult extends Model53 Ct555660 G6379 Gt>o usaeespublic const int STATUS_DEFAULT = 0;o usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;public const int STATUS_SENT = 3;public const int STATUS_FAILED = 4;/*** keason conscantso usaees4 usages5 usagespublic const int REASON_DEFAULT = 0;public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;PUDLIC Const Int REASUN_PRUPHEI_APL_ERRUR = 21procecced stable = 'aucomated_report_results:* The attributes that are mass assignable.* @var array<int, string>protected $fillable = ['report_id','name','status',' reason',"meona twoe."Dalrent o.'payload','response',' requested_at','generated_at','sent_at',*Ger the crroures shoula de ciste* Oreturn array<string, string>protected function casts(): arrayf..}/*** Get the automated report that owns this result.* @return BelongsTopublic function report(): BelongsTof..,A8 X1 X1^j Support Daily • in 3h 47 mARequestGenerateAsk.liminnvRenort.lob Test100% |45]Tue 14 Apr 11:13:57= custom.logE laravel.logA SF [jiminny@localhost]© AskJiminnyReportActivityService.phpA HS_local [iminny@localhost]© RequestGenerateAskJiminnyReportJobTest.phpA console (PROD]р 0.Ix: AUtO VFlaycroundvCONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE "' END) AS user_id,517518519520521u.email,sa.*,t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJuI reans1..n<->1: on t.id = u.team_idWHERE U.team_id = 1 and sa.provider = 'salesforce';Al console (EU]A console [STAGING]Eajiminny v016 A 13 Х13 ^select x Tron teams wnere 10 = 11select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565;select * from playbooks where team_id = 1;Git Checkout Problem175;Your local changes to the following files would be overwritten by Checkout.Pnostomm can snelve tne chanoes, cneckout ana unsnelve tnem aner tnat.v DD app/Http/Controllers/Webhook 1 file© ReportController.php10, Lead 10, concact 1a, accounc 1a, opporcunicy 1a, stage 10,id, statuse = 'conference"IT NULL9000pCZojMACOOK7101 and object_type = 'event';1<->1.n: on cl.id = pl.layout_id555556557000561562563564565566 v1567Force CheckoutDon't CheckoutSmart Checkoutselect * tron reansSoin t ait FPon n.seretel = orto nWHERE r. Erequencx ='daily'and r.status = 1AND t.status = 'active'AND (r.expinesaat >= now() OR r.expinesat IS NULL);select * from automated_report_results where cepont.id IN (18, 33);select * from automated_reports;select * from automated_report_results where cepontaid IN (34);W Windsurf Teams50:50 2o charsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
10134
|
|
10133
|
Notion CalendarEditViewWindowHelp> 0ltl= Suppor Notion CalendarEditViewWindowHelp> 0ltl= Support Daily • in 3 h 47 m100% <47Tue 14 Apr 11:13:57+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10133
|
|
10132
|
PhpStormFileEditFV faVsco.js vViewNavigateCodeLara PhpStormFileEditFV faVsco.js vViewNavigateCodeLaravelRefactorToolsWindowHelp#11804 on.lY-18909-automated-renorts-ask-liminnvkProjectvC) AiPrompt.php© AutomatedReport.php© AutomatedReportResult.ph© Calendar.php© Calllmport.php© CoachingFeedback.php© CoachingFeedbackVisibilit!© CoachingSection.php© CoachingSectionCriterion.f© CoachingSectionCriterionF© CoachingSectionFeedback© CommentAbstract.pngCommentInterface.php© Contact.php© Device.php© EmailMessage.php© GenericAiPrompt.php© Group.php© Inbox.php© InboxEmail.php© InboxEmailBatch.php© Invitation.php© JobLog.php© JobTitle.php© Language.php© LanguageDialect.php© Lead.php© MobileSetting.php© Model.php© Moment.php© Nudge.php© NudgeRun.php© Opportunity.phpC) Participant.pho© Partner.php© Permission.php©PhoneNumber.php© PlaybackTheme.php© Playbook.php© PlaybookCategory.php© Playlist.php© RateLimit.php© Region.phpC) Role php© RoleChangeEvent.php(C) ScopeGroup.php© Session.php© SlackBot.php© SocialAccount.php© Stage.php© Task.php© Team.php© TeamAiContext.php© TeamDomain.php© TeamFeature.php© TeamSettings.php© TextRelay.php© Track.php© TranscriptionModel.php© ReportController.phpAulomaleakeporskeposilory.ono© JiminnyDebugCommand.phpC AutomatedReportsService.php© AutomatedReportsSendCommand.php(©) AutomatedReportsCommand.phpCreateHeldActivityEvent.php• TrackProviderInstalledEvent.php© CreateActivityLoggedEvent.php© UserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php(©) RequestGenerateAskJiminnyReportJob.php© RequestGenerateReportJob.php© AutomatedReportResult.php >© AutomatedReport.phpclass AutomatedReportResult extends Model53 Ct555660 G6379 6t >o usaeespublic const int STATUS_DEFAULT = 0;o usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;public const int STATUS_SENT = 3;public const int STATUS_FAILED = 4;/*** keason conscantso usaees4 usages5 usagespublic const int REASON_DEFAULT = 0;public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;PUDLIC Const Int REASUN_PRUPHEI_APL_ERRUR = 21procecced stable = 'automaced_report_results:* The attributes that are mass assignable.* @var array<int, string>protected $fillable = ['report_id','name','status',' reason',"meona twoe."oalrento.'payload','response',' requested_at','generated_at','sent_at',*Ger the crroures shoula de ciste* Oreturn array<string, string>protected function casts(): arrayf..}/*** Get the automated report that owns this result.* @return BelongsTopublic function report(): BelongsTof..,A8 X1 X1^j Support Daily • in 3 h 47 mARequestGenerateAsk.liminnvRenort.lob Test100% |45]Tue 14 Apr 11:13:55= custom.logE laravel.logA SF [jiminny@localhost]A HS_local [iminny@localhost]A console (PROD]© AskJiminnyReportActivityService.php© RequestGenerateAskJiminnyReportJobTest.phpр 0.Ix: AUtO VPlaygroundCONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE "' END) AS user_id,517518519520521u.email,sa.*,t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJuI reans1..n<->1: on t.id = u.team_idWHERE U.team_id = 1 and sa.provider = 'salesforce';Al console (EU]A console [STAGING]Eajiminny v016 A 13 Х13 ^select x Tron teams wnere 10 = 11select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565;select * from playbooks where team_id = 1;Git Checkout Problem175;Your local changes to the following files would be overwritten by Checkout.Pnostomm can snelve tne chanoes, cneckout ana unsnelve tnem aner tnat.v DD app/Http/Controllers/Webhook 1 file© ReportController.php10, Lead 10, concact 1a, accounc 1a, opporcunicy 1a, stage 10,id, statuse = 'conference"IT NULL9000pCZojMACOOK7101 and object_type = 'event';1<->1.n: on cl.id = pl.layout_id555556557000561562563564565566 v1567Force CheckoutDon't CheckoutSmart Checkoutselect * tron reansSELECl r.* FRun automated_reports nnoun realis i on rrreall 10 = 1.10WHERE r. Erequencx ='daily'and r.status = 1AND t.status = 'active'AND (r.expinesaat >= now() OR r.expinesat IS NULL);select * from automated_report_results where cepont.id IN (18, 33);select * from automated_reports;select * from automated_report_results where cepontaid IN (34);W Windsurf Teams50:50 2o charsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
10132
|
|
10131
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:13:53+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10131
|
|
10130
|
Checkout
New Branch from 'JY-20543-AJ-report-t Checkout
New Branch from 'JY-20543-AJ-report-tracking'…
Checkout and Rebase onto 'JY-18909-automated-reports-ask-jiminny'
Checkout and Update
Compare with 'JY-18909-automated-reports-ask-jiminny'
Show Diff with Working Tree
Rebase 'JY-18909-automated-reports-ask-jiminny' onto 'JY-20543-AJ-report-tracking'
Merge 'JY-20543-AJ-report-tracking' into 'JY-18909-automated-reports-ask-jiminny'
New Worktree from 'JY-20543-AJ-report-tracking'…
Update
Push…
Tracked Branch 'origin/JY-20543-AJ-report-tracking'
Rename…
F2
Delete...
|
PhpStorm
|
|
NULL
|
10130
|
|
10129
|
PhpStormFileFditViewNavigateCodeLaravelRefactonToo PhpStormFileFditViewNavigateCodeLaravelRefactonToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-iminnyProject vlebugCommand.phpc) AutomatedReporssenccommane.ono(©) AutomatedReportsCommand.php• Search for branches and actionsC) AiPromp(C) AutomalC AutomaAulomaleakeporisservice.onp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpK Update Project..C) CalendaC) Callimpo-0- Commit...7 Push...Show Pull Request in the Tool WindowUserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.phpb.phpC RequestGenerateReportJob.phpC AutomatedReportResult.php(C) Automateakeport.onpsult extends Model© coachinSubmit Review...Undate to Enable Review Mode...e coachine coachine) Coachin-- New branchT&NATUS DEFAULT = 0:C) CoachinC) CoachinC CommelCneckourao Orkev s onh.ATUS_REQUESTED = 1v Recent[ CommelC) ContactJY-18909-automated-reports-ask-..ATUS_GENERATED = 2)C Device.rC EmailMec) Generic*JY-20543-AJ-report-tracking* masterorigin/master ›T® JY-20384-handle-auto-sync-with-no-ar >P° JY-20458-ask-jiminny-user-definitions. >•LоcalIATUS_SENI = 51JATUS FATLED = 4:© Group.pC Inbox.pl• Remore.e)noox -m› lagsC InboxEmalisatcn.pnpC Invitation.ohpASON_DEFAULT = 0;C JobLog.phpC) JobTitle.php4 usages5 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 1PUDLIC Const Int REASUN_PRUPHEI_APL_ERRUR = 21C Lanquage.phpC LanguageDialect.php53 Ctprocecced stable = 'aucomated_report_results:C Lead.phpC MobileSetting.phpg Model.php© Moment.php5556* The attributes that are mass assignable.© Nudge.php© NudgeRun.php© Opportunity.phpC) Participant.pho* @var arrausint, string>60 Gprotected $fillable = [© Partner.phpC) Permission.php(C) PhoneNumber.php63C PlaybackTheme.php'report_1d',"name','status',"reason","meona twoe.c Playbook.php"oalrento.C PlaybookCategory.php© Playlist.php© RateLimit.php'payLoad "'response'.'requested at',© Region.phpC) Role phpC) RoleChangeEvent.php'generated_at","sent_at",(C) ScopeGroup.phpC) Session.phpC) SlackBot.php*Ger the crroues o should de cise© SocialAccount.phpC Stage.phpC Task.phpg Team.php© leamAiContext.php* dreturn array<string, string>79d>protected function casts(): arrayt...© leamDomain.php© TeamFeature.phpC) TeamSettinas.pho/*** Get the automated report that owns this result.C TextRelay.php© Track.phcC) TranscriptionModel.php* dreturn Belongsfopublic function report(): BelongsTo{...}Windsurf changelog 2.12.21: A new version is available. // View Changelog (40 minutes ago)B8 м1м1^a Support Daily • in 3 h 47 m100% |45]Tue 14 Apr 11:13:52RequestGenerateAsk.JiminnvRenort.lobTest= custom.loc= laravel.logc SF liminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGING© AskJiminnyReportActivityService.php5175181519115211530531532. 5345375385395405411542154.51154454554454754854915551556155 A0005615625631564So51C RequestGenerateAskJiminnyReportJobTest.phpp 0Ix. AUto VFlaycroundvliminnyCONCAT(U.1d, CASE WHEN U.1d = t.owner_1d THEN ' (owner)' ELSE'' END) AS USer_1d016 413 ×,13 ^U.emall,sa.*t.owner_ld Frun soclal_accounts saauvusers u on urd = sa.socaole ..olJuI reansI.n<→>I: on t.1d = U.ceam_1dWHERE U.team_id = 1 and sa.provider = 'salesforce':select * from teams where id = 1:select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565:select * from playbooks where team_id = 1select * from playbooks where 1d = 175:select * from playbook_categories where playbooK_1d = 175*select * from users where team_1d = 1;select * trom users where 10 = 7160;select * trom crm_proriles where user_1d = 7160;select * trom reatures,select# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm confiquration id,crm_provider id.LldliscrLocson. 1u,SLaLusfrom activities where crm confiquration id = 1 and type = 'conference'# and crm_provider_1d IS NOT NULLand provider != 'uploader" and actual_start_time IS NOT NULLORDER by 1d desc;select * trom aculvitles where 10 = 54/47/85; # 0000400006pCzoJMACselect p.1d, p.accivicy_type, pc.1d, pc.namerkoM playbooks pioin plavbook categories pc 1<->1.n: on p.id = pc.plavbook idwhere p.team id = 1 and p.activity type = 'event':SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event":SELECT * FROM crm_field_values WHERE crm_field_id = 4select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbook_1d = 175select * tron reans.SELECl r.* FRun automated_reports nnoun realis i on rrreall 10 = 1.10WHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD):select * from automated_report_results where report 1d IN (18, 35)*select * trom aucomated_reports;So0vselect * trom aucomated_report_results where report 1d IN (54).winasun leams50:50 2o charsUTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
10129
|
|
10128
|
Update Project...
Commit…
Push…
Show Pull Request Update Project...
Commit…
Push…
Show Pull Request in the Tool Window
Submit Review…
Update to Enable Review Mode…
New Branch…
Checkout Tag or Revision…
Recent
JY-18909-automated-reports-ask-jiminny
JY-20543-AJ-report-tracking
master
JY-20384-handle-auto-sync-with-no-access-to-event-type
JY-20458-ask-jiminny-user-definitions
JY-18909-automated-reports-ask-jiminny
JY-20543-AJ-report-tracking
master
JY-20384-handle-auto-sync-with-no-access-to-event-type
JY-20458-ask-jiminny-user-definitions
Local
Remote
Tags
Search
Fetch
Settings...
|
PhpStorm
|
|
NULL
|
10128
|
|
10127
|
PhpStormFileFditViewNavigateCodeLaravelRefactonToo PhpStormFileFditViewNavigateCodeLaravelRefactonToolsWindowHelpFV faVsco.s vC8 #11894 on JY-18909-automated-neports-ask-jiminny <Project vlebugCommand.phpc) AutomatedReporssenccommane.ono(©) AutomatedReportsCommand.php• Search for branches and actionsC) AiPromp(C) AutomalC AutomaC) CalendaAulomaleakeporisservice.onp© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpK Update Project..C) Callimpo-0- Commit...7 Push...Show Pull Request in the Tool WindowUserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.phpb.phpC RequestGenerateReportJob.phpC AutomatedReportResult.php(C) Automateakeport.pnpsult extends Model© coachinSubmit Review...Undate to Enable Review Mode...e coachine coachine) Coachin-- New branchT&NATUS DEFAULT = 0:C) CoachinC) CoachinC CommelCneckourao Orkev s onh.ATUS_REQUESTED = 1v Recent[ CommelC) ContactJY-18909-automated-reports-ask-...ATUS_GENERATED = 2)C Device.rC EmailMec) Generic© Group.pC Inbox.pl*JY-20543-AJ-report-tracking* masterk 99-origin... >origin/master ›T® JY-20384-handle-auto-sync-with-no-ar >P° JY-20458-ask-jiminny-user-definitions. >•LоcalIATUS_SENI = 51ATUS_FAILED = 4;• Remore.e)noox -m› lagsC InboxEmalisatcn.pnpC Invitation.ohpC JobLog.phpASON_DEFAULT = 0;C) JobTitle.php4 usages5 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 1PUDLIC Const Int REASUN_PRUPHEI_APL_ERRUR = 21C Lanquage.phpC LanguageDialect.phpC Lead.php53 Ctprocecced stable = 'aucomated_report_results:C MobileSetting.phpg Model.php© Moment.php5556* The attributes that are mass assignable.© Nudge.php© NudgeRun.php© Opportunity.phpC) Participant.pho* @var arrausint, string>60 Gprotected $fillable = [© Partner.phpC) Permission.php(C) PhoneNumber.php63C PlaybackTheme.php'report_1d',"name','status',"reason","meona twoe.c Playbook.php"oalrento.C PlaybookCategory.php© Playlist.php© RateLimit.php'payLoad "'response'.'requested at',© Region.phpC) Role phpC) RoleChangeEvent.php'generated_at","sent_at",(C) ScopeGroup.phpC) Session.phpC) SlackBot.php*Ger the crroues o should de cise© SocialAccount.phpC Stage.phpC Task.phpg Team.php© leamAiContext.php* dreturn array<string, string>79d>protected function casts(): arrayt...© leamDomain.php© TeamFeature.phpC) TeamSettinas.pho/*** Get the automated report that owns this result.C TextRelay.php© Track.phcC) TranscriptionModel.php* dreturn Belongsfopublic function report(): BelongsTo{...}Windsurf changelog 2.12.21: A new version is available. // View Changelog (40 minutes ago)B8 м1м1^a Support Daily • in 3 h 47 m100% |45]Tue 14 Apr 11:13:49RequestGenerateAsk.JiminnvRenort.lobTest= custom.loc= laravel.logc SF liminny@localhost« HS_local fiminny@localhoste console (PROD]e console (EU]L console [STAGINGI© AskJiminnyReportActivityService.php5175181519115211530531532. 5345375385395405411542154.51154454554454754854915551556155 A0005615625631564So51C RequestGenerateAskJiminnyReportJobTest.phpp 0Ix. AUto VFlaycroundvliminnyCONCAT(U.1d, CASE WHEN U.1d = t.owner_1d THEN ' (owner)' ELSE'' END) AS USer_1d016 413 ×,13 ^U.emall,sa.*t.owner_ld Frun soclal_accounts saauvusers u on urd = sa.socaole ..olJuI reansI.n<→>I: on t.1d = U.ceam_1dWHERE U.team_id = 1 and sa.provider = 'salesforce':select * from teams where id = 1:select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.team_id = 1;select * from groups where id = 565;select * from playbooks where team_id = 1select * from playbooks where 1d = 175:select * from playbook_categories where playbooK_1d = 175*select * from users where team_1d = 1;select * trom users where 10 = 7160;select * trom crm_proriles where user_1d = 7160;select * trom reatures,select# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,# crm confiquration id,crm_provider id.Llaliscrcucson. 1urSLaLusfrom activities where crm confiquration id = 1 and type = 'conference'# and crm_provider_1d IS NOT NULLand provider != 'uploader" and actual_start_time IS NOT NULLORDER by 1d desc;select * trom aculvitles where 10 = 54/47/85; # 0000400006pCzoJMACselect p.1d, p.accivicy_type, pc.1d, pc.namerkoM playbooks pioin plavbook categories pc 1<->1.n: on p.id = pc.plavbook idwhere p.team id = 1 and p.activity type = 'event':SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event":SELECT * FROM crm_field_values WHERE crm_field_id = 4select * from crm_layouts cl Jo1n playbook_layouts pl 1<->1.n: on cl.1d = pl. Layout_1dwhere crm_configuration_1d = 1 and pl.playbook_1d = 175select * tron reans.SELECl r.* FRun automated_reports nnoun realis i on rrreall 10 = 1.10WHERE r.frequency = 'daily'and r.status = 1AND t.status = 'active'AND (r.expiresat >= now) OR r.expires.at Is NULD);select * from automated_report_results where report 1d IN (18, 35)*select * trom automated_reports;So0vselect * trom aucomated_report_results where report 1d IN (54).winasun leams50:50 2o charsUTF-8f 4 spaces...
|
NULL
|
NULL
|
NULL
|
10127
|
|
10126
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Code changed:
Hide
Sync Changes
Hide This Notification
8
1
1
Previous Highlighted Error
Next Highlighted Error
<?php
namespace Jiminny\Models;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Carbon;
use Jiminny\Traits\RequiresUUID;
/**
* Jiminny\Models\AutomatedReportResult
*
* @property int $id
* @property string $uuid
* @property int $report_id
* @property string|null $name
* @property int $status
* @property int $reason
* @property string $media_type
* @property int|null $parent_id
* @property array|null $payload
* @property array|null $response
* @property Carbon|null $requested_at
* @property Carbon|null $generated_at
* @property Carbon|null $sent_at
* @property Carbon|null $created_at
* @property Carbon|null $updated_at
* @property-read \Jiminny\Models\AutomatedReport $report
* @property-read AutomatedReportResult|null $parent
* @property-read \Illuminate\Database\Eloquent\Collection<int, AutomatedReportResult> $children
*/
class AutomatedReportResult extends Model
{
use RequiresUUID;
/**
* Status constants
*/
public const int STATUS_DEFAULT = 0;
public const int STATUS_REQUESTED = 1;
public const int STATUS_GENERATED = 2;
public const int STATUS_SENT = 3;
public const int STATUS_FAILED = 4;
/**
* Reason constants
*/
public const int REASON_DEFAULT = 0;
public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;
public const int REASON_PROPHET_API_ERROR = 2;
protected $table = 'automated_report_results';
/**
* The attributes that are mass assignable.
*
* @var array<int, string>
*/
protected $fillable = [
'report_id',
'name',
'status',
'reason',
'media_type',
'parent_id',
'payload',
'response',
'requested_at',
'generated_at',
'sent_at',
];
/**
* Get the attributes that should be cast.
*
* @return array<string, string>
*/
protected function casts(): array
{
return [
'payload' => 'array',
'response' => 'array',
'requested_at' => 'datetime',
'generated_at' => 'datetime',
'sent_at' => 'datetime',
];
}
/**
* Get the automated report that owns this result.
*
* @return BelongsTo
*/
public function report(): BelongsTo
{
return $this->belongsTo(AutomatedReport::class, 'report_id')->withTrashed();
}
/**
* Get the parent report result.
*
* @return BelongsTo
*/
public function parent(): BelongsTo
{
return $this->belongsTo(self::class, 'parent_id');
}
/**
* Get the child report results.
*
* @return HasMany
*/
public function children(): HasMany
{
return $this->hasMany(self::class, 'parent_id');
}
/**
* Get the ID of the automated report result.
*
* @return int
*/
public function getId(): int
{
return $this->getAttribute('id');
}
/**
* Get the UUID of the automated report result.
*
* @return string
*/
public function getUuid(): string
{
return $this->getAttribute('id_string');
}
/**
* Get the report ID of the automated report result.
*
* @return int
*/
public function getReportId(): int
{
return $this->getAttribute('report_id');
}
/**
* Get the name of the automated report result.
*
* @return ?string
*/
public function getName(): ?string
{
return $this->getAttribute('name');
}
/**
* Get the status of the automated report result.
*
* @return int
*/
public function getStatus(): int
{
return $this->getAttribute('status');
}
/**
* Get the reason of the automated report result.
*
* @return int
*/
public function getReason(): int
{
return $this->getAttribute('reason');
}
/**
* Get the media type of the automated report result.
*
* @return string
*/
public function getMediaType(): ?string
{
return $this->getAttribute('media_type');
}
/**
* Get the parent ID of the automated report result.
*
* @return int|null
*/
public function getParentId(): ?int
{
return $this->getAttribute('parent_id');
}
/**
* Get the payload of the automated report result.
*
* @return array|null
*/
public function getPayload(): ?array
{
return $this->getAttribute('payload');
}
/**
* Get the response of the automated report result.
*
* @return array|null
*/
public function getResponse(): ?array
{
return $this->getAttribute('response');
}
/**
* Get the requested at date of the automated report result.
*
* @return Carbon|null
*/
public function getRequestedAt(): ?Carbon
{
return $this->getAttribute('requested_at');
}
/**
* Get the generated at date of the automated report result.
*
* @return Carbon|null
*/
public function getGeneratedAt(): ?Carbon
{
return $this->getAttribute('generated_at');
}
/**
* Get the sent at date of the automated report result.
*
* @return Carbon|null
*/
public function getSentAt(): ?Carbon
{
return $this->getAttribute('sent_at');
}
/**
* Get the created at date of the automated report result.
*
* @return Carbon
*/
public function getCreatedAt(): Carbon
{
return $this->getAttribute('created_at');
}
/**
* Get the updated at date of the automated report result.
*
* @return Carbon
*/
public function getUpdatedAt(): Carbon
{
return $this->getAttribute('updated_at');
}
/**
* Check if the report result is in requested status.
*
* @return bool
*/
public function isRequested(): bool
{
return $this->getStatus() === self::STATUS_REQUESTED;
}
/**
* Check if the report result is in generated status.
*
* @return bool
*/
public function isGenerated(): bool
{
return $this->getStatus() === self::STATUS_GENERATED;
}
/**
* Check if the report result is in sent status.
*
* @return bool
*/
public function isSent(): bool
{
return $this->getStatus() === self::STATUS_SENT;
}
/**
* Check if the report result is in failed status.
*
* @return bool
*/
public function isFailed(): bool
{
return $this->getStatus() === self::STATUS_FAILED;
}
public function getStatusLabel(): string
{
return match ($this->getStatus()) {
self::STATUS_REQUESTED => 'Requested',
self::STATUS_GENERATED => 'Generated',
self::STATUS_SENT => 'Sent',
self::STATUS_FAILED => 'Failed',
default => 'Default',
};
}
public function getReport(): AutomatedReport
{
return $this->getAttribute('report');
}
public function getFromDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['from_date'])) {
return null;
}
return Carbon::parse($payload['from_date']);
}
public function getToDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['to_date'])) {
return null;
}
return Carbon::parse($payload['to_date']);
}
public function getReportType(): ?string
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['report_type'])) {
return null;
}
return $payload['report_type'];
}
public function getGroups(): array
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['group_ids'])) {
return [];
}
return $payload['group_ids'];
}
public function getPdfUrl(): ?string
{
$response = $this->getResponse();
return $response['pdf_url'] ?? null;
}
public function getPodcastAudioUrl(): ?string
{
$response = $this->getResponse();
return $response['podcast_audio_url'] ?? null;
}
}
Execute
Explain Plan
Browse Query History...
|
PhpStorm
|
faVsco.js – AutomatedReportResult.php
|
NULL
|
10126
|
|
10125
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Code changed:
Hide
Sync Changes
Hide This Notification
8
1
1
Previous Highlighted Error
Next Highlighted Error
<?php
namespace Jiminny\Models;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Carbon;
use Jiminny\Traits\RequiresUUID;
/**
* Jiminny\Models\AutomatedReportResult
*
* @property int $id
* @property string $uuid
* @property int $report_id
* @property string|null $name
* @property int $status
* @property int $reason
* @property string $media_type
* @property int|null $parent_id
* @property array|null $payload
* @property array|null $response
* @property Carbon|null $requested_at
* @property Carbon|null $generated_at
* @property Carbon|null $sent_at
* @property Carbon|null $created_at
* @property Carbon|null $updated_at
* @property-read \Jiminny\Models\AutomatedReport $report
* @property-read AutomatedReportResult|null $parent
* @property-read \Illuminate\Database\Eloquent\Collection<int, AutomatedReportResult> $children
*/
class AutomatedReportResult extends Model
{
use RequiresUUID;
/**
* Status constants
*/
public const int STATUS_DEFAULT = 0;
public const int STATUS_REQUESTED = 1;
public const int STATUS_GENERATED = 2;
public const int STATUS_SENT = 3;
public const int STATUS_FAILED = 4;
/**
* Reason constants
*/
public const int REASON_DEFAULT = 0;
public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;
public const int REASON_PROPHET_API_ERROR = 2;
protected $table = 'automated_report_results';
/**
* The attributes that are mass assignable.
*
* @var array<int, string>
*/
protected $fillable = [
'report_id',
'name',
'status',
'reason',
'media_type',
'parent_id',
'payload',
'response',
'requested_at',
'generated_at',
'sent_at',
];
/**
* Get the attributes that should be cast.
*
* @return array<string, string>
*/
protected function casts(): array
{
return [
'payload' => 'array',
'response' => 'array',
'requested_at' => 'datetime',
'generated_at' => 'datetime',
'sent_at' => 'datetime',
];
}
/**
* Get the automated report that owns this result.
*
* @return BelongsTo
*/
public function report(): BelongsTo
{
return $this->belongsTo(AutomatedReport::class, 'report_id')->withTrashed();
}
/**
* Get the parent report result.
*
* @return BelongsTo
*/
public function parent(): BelongsTo
{
return $this->belongsTo(self::class, 'parent_id');
}
/**
* Get the child report results.
*
* @return HasMany
*/
public function children(): HasMany
{
return $this->hasMany(self::class, 'parent_id');
}
/**
* Get the ID of the automated report result.
*
* @return int
*/
public function getId(): int
{
return $this->getAttribute('id');
}
/**
* Get the UUID of the automated report result.
*
* @return string
*/
public function getUuid(): string
{
return $this->getAttribute('id_string');
}
/**
* Get the report ID of the automated report result.
*
* @return int
*/
public function getReportId(): int
{
return $this->getAttribute('report_id');
}
/**
* Get the name of the automated report result.
*
* @return ?string
*/
public function getName(): ?string
{
return $this->getAttribute('name');
}
/**
* Get the status of the automated report result.
*
* @return int
*/
public function getStatus(): int
{
return $this->getAttribute('status');
}
/**
* Get the reason of the automated report result.
*
* @return int
*/
public function getReason(): int
{
return $this->getAttribute('reason');
}
/**
* Get the media type of the automated report result.
*
* @return string
*/
public function getMediaType(): ?string
{
return $this->getAttribute('media_type');
}
/**
* Get the parent ID of the automated report result.
*
* @return int|null
*/
public function getParentId(): ?int
{
return $this->getAttribute('parent_id');
}
/**
* Get the payload of the automated report result.
*
* @return array|null
*/
public function getPayload(): ?array
{
return $this->getAttribute('payload');
}
/**
* Get the response of the automated report result.
*
* @return array|null
*/
public function getResponse(): ?array
{
return $this->getAttribute('response');
}
/**
* Get the requested at date of the automated report result.
*
* @return Carbon|null
*/
public function getRequestedAt(): ?Carbon
{
return $this->getAttribute('requested_at');
}
/**
* Get the generated at date of the automated report result.
*
* @return Carbon|null
*/
public function getGeneratedAt(): ?Carbon
{
return $this->getAttribute('generated_at');
}
/**
* Get the sent at date of the automated report result.
*
* @return Carbon|null
*/
public function getSentAt(): ?Carbon
{
return $this->getAttribute('sent_at');
}
/**
* Get the created at date of the automated report result.
*
* @return Carbon
*/
public function getCreatedAt(): Carbon
{
return $this->getAttribute('created_at');
}
/**
* Get the updated at date of the automated report result.
*
* @return Carbon
*/
public function getUpdatedAt(): Carbon
{
return $this->getAttribute('updated_at');
}
/**
* Check if the report result is in requested status.
*
* @return bool
*/
public function isRequested(): bool
{
return $this->getStatus() === self::STATUS_REQUESTED;
}
/**
* Check if the report result is in generated status.
*
* @return bool
*/
public function isGenerated(): bool
{
return $this->getStatus() === self::STATUS_GENERATED;
}
/**
* Check if the report result is in sent status.
*
* @return bool
*/
public function isSent(): bool
{
return $this->getStatus() === self::STATUS_SENT;
}
/**
* Check if the report result is in failed status.
*
* @return bool
*/
public function isFailed(): bool
{
return $this->getStatus() === self::STATUS_FAILED;
}
public function getStatusLabel(): string
{
return match ($this->getStatus()) {
self::STATUS_REQUESTED => 'Requested',
self::STATUS_GENERATED => 'Generated',
self::STATUS_SENT => 'Sent',
self::STATUS_FAILED => 'Failed',
default => 'Default',
};
}
public function getReport(): AutomatedReport
{
return $this->getAttribute('report');
}
public function getFromDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['from_date'])) {
return null;
}
return Carbon::parse($payload['from_date']);
}
public function getToDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['to_date'])) {
return null;
}
return Carbon::parse($payload['to_date']);
}
public function getReportType(): ?string
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['report_type'])) {
return null;
}
return $payload['report_type'];
}
public function getGroups(): array
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['group_ids'])) {
return [];
}
return $payload['group_ids'];
}
public function getPdfUrl(): ?string
{
$response = $this->getResponse();
return $response['pdf_url'] ?? null;
}
public function getPodcastAudioUrl(): ?string
{
$response = $this->getResponse();
return $response['podcast_audio_url'] ?? null;
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (34);...
|
PhpStorm
|
faVsco.js – AutomatedReportResult.php
|
NULL
|
10125
|
|
10124
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpgithub.com/jiminny/app/pull/11932~ Google Gemini.. XPlatform Sprint 1 Q2 - Platform TeaJY-20543 add AJ reports User XZ Configure SSH access to multipleConsole Home | Console Home | usSecurityGroup | EC2 |us-east-2JY-20543 add AJ reports User piloSRD-6779 | JY-20632 | Unable toJy 19798 evaluation for ai activity(8) Jiminny7 Ask Jiminny test report - 8 Aor 201- Service-Desk - Queues - Platform& JY-20543 add AJ reports User pilo(x) Configure SSH access to multipleCa CloudWatch | us-east-2+ New Tabwhy I can't see speakerdata on meemt in firefox.ho wto set it upShow thinking~Dealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.Since "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersPro vYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize pageC < 40 lbl l SupportDaily in 3h47m A 100% C Tue 14 Apr 11:13:39•*8? OpenJY-20543 add AJ reports User pilot tracking #11932LakyLak wants to merge 4 commits into JY-18909-automated-reports-ask-jiminny from JY-20543-AJ-report-tracking d• @ LakyLak requested review from Vasil-Jiminny, nikolaybiaivanov and yalokin-jiminny 5 days ago• nikolaybiaivanov approved these changes 5 days agoView reviewed changesyalokin-jiminny commented 5 days ago@claude© 01)claude bot commented 5 days ago • edited -...Claude finished @yalokin-jiminny's task in 1m 11s — View jobCode ReviewGather contextRead changed files• Analyze code and provide review feedbackOverall the implementation is clean and well-structured. Good use of the event/listener pattern, proper queuing viaShouldQueue, and solid test coverage. A few things worth flagging:Issues1. Silent error swallowing — no logging on GuzzleExceptionapp/Listeners/AutomatedReports/UserPilot/TrackAutomatedReportGeneratedEvent.php L44-45} catch (GuzzleException $e) {Sthis->release(3600);The exception is caught and silently discarded. If UserPilot APl calls start failing, there's no observable signal. Considerlogging the error before releasing:} catch (GuzzleException $e) {sthis->logger->warning('UserPilot tracking failed for automated report', l'exception' => $e->gethessdgSthis->release(3600);Fix this →2. Partial retry risk - duplicate tracking on queue retryapp/Listeners/AutomatedReports/UserPilot/TrackAutomatedReportGeneratedEvent.php L36-47If tracking succeeds for user #1 and fails for user #2 (throwing GuzzleException), the job is released and retried -which will re-track user #1. For exec_summary reports with multiple recipients this could cause duplicate UserPilotevents. This may be acceptable given the low stakes of analytics data, but worth being aware of.& Lock conversation...
|
NULL
|
NULL
|
NULL
|
10124
|
|
10123
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpgithub.com/jiminny/app/pull/11932~ Google Gemini.. XPlatform Sprint 1 Q2 - Platform TeaJY-20543 add AJ reports User XZ Configure SSH access to multipleConsole Home | Console Home | usSecurityGroup | EC2 |us-east-2why I can't see speakerdata on meemt in firefox.ho wto set it upJY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable toShow thinking~Jy 19798 evaluation for ai activity(8) Jiminny7 Ask Jiminny test report - 8 Aor 201- Service-Desk - Queues - PlatformDealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.& JY-20543 add AJ reports User pilo(x) Configure SSH access to multipleCa CloudWatch | us-east-2Since "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.+ New Tab1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersPro vYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize page40 hil l Support Daily- in 3h 47 m100% CSTue 14 Apr 11:13:33•*Q Type to searchjiminny / app 8‹> Code?? Pull requests 24Agents•Actions MD Wiki ® Security and quality 24Insights ộ SettingsOn April 24 we'll start using GitHub Copilot interaction data for Al model training unless you opt out. Review this update and manage your preferences in your GitHub account settings.JY-20543 add AJ reports User pilot tracking #11932 •81 OpenLakyLak wants to merge 4 commits into JY-18909-automated-reports-ask-jiminny from JY-20543-AJ-report-trackingV Conversation 4a Commits 4E Checks 7E Files changed 7LakyLak commented 5 days ago•.•No description provided.• Ready to mergeCode -+284 -1 mummoE LakyLak added 4 commits 5 days agoa @JY-20543 add AJ reports User pilot trackinga @JY-20543 code smellso @JY-20543 fix testa @Jy-20543 fix eventsonarqubecloud bot commented 5 days ago~ Quality Gate passedIssuesv O New issues© 0 Accepted issuesmeasuresv u secuilly molsoolsv 76.7% Coverage on New Codev U.U% bupllcation on New codenee anaivsis ceralis on sonarouoe ciouoX 609200aX 21ab308~ 93a69ebv 01241ae.••Reviewers@ nikolaybiaivanov€ Vasil-Jiminny• yalokin-jiminnyStill in progress? Convert to draftAsSioneesNo one—assign yourselfLabelsNone yetProjectsNone yetMllestoneno milestoneDevelopmentSuccessfully merging this pull request may closethese issues.None yetNotificationsCustomizeE UnsubscribeYou're receiving notifications because you'rewatching this repository.4 participants& Lock conversation• @ LakyLak requested review from Vasil-Jiminny, nikolaybiaivanov and yalokin-jiminny 5 days agov nikolaybiaivanov approved these changes 5 days agoyalokin-jiminny commented s days ago@claudeView reviewed chanaes...
|
NULL
|
NULL
|
NULL
|
10123
|
|
10122
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpgithub.com/jiminny/app/pull/11932~ Google Gemini.. Xj Support Daily • in 3h 47 mA100% C•Tue 14 Aor 11:13:30Platform Sprint 1 Q2 - Platform Tea•cunub.comminnyaop oulfitxZ Configure SSH access to multipleConsole Home | Console Home | usSecurityGroup | EC2 |us-east-2JY-20543 add AJ reports User pilo5 SRD-6779 | JY-20632 | Unable toJy 19798 evaluation for ai activity(8) Jiminny7 Ask Jiminny test report - 8 Aor 201- Service-Desk - Queues - PlatformJY-20543 add AJ reports User pilc(x) Configure SSH access to multipleCa CloudWatch | us-east-2+ New Tabwhy I can't see speakerdata on meemt in firefox.ho wto set it upShow thinking~Dealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.Since "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize page...
|
NULL
|
NULL
|
NULL
|
10122
|
|
10121
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindowHelpjiminny.atlassian.net/jira/software/c/projects/JY/boards/37?selectedlssue=JY-20543~ Google Gemini...Platform Sprint 1 Q2 - Platform& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcwhy I can't see speakerdata on meemt in firefox.ho wto set it upSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activityShow thinking~ Jiminnyg Ask Jiminny test report - 8 Apr 201≤ Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilcDealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.(x) Configure SSH access to multipleC CloudWatch I us-east-2+ New TabSince "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvO JIMINNY@ For you• Recent# Starred07 Apps8, SpacesJiminny (New)t **•lil Plattorm Teamuu sE KanbanIID Capture TeamII Enterprise Stability I...WD Processing Team(9 Service-Desk— More soaces= Filtersit DasnooarasOperations%) Confluence88 Teams¿= Customise sidebarYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize pagenoacesPlatfo® SunQ SeiREADYQ Search4 JY-19240 / D JDevelopment JY-20543AJ ReportsBranches Commits Pull requests Builds Deployments Feature flags Other linksv • jiminny/app (GitHub)v DescriptionWe want to be ablto use Userpilot tc• track each ger• for AJ reportswho has creat• for Exec reporparticipants lisAuthor#11932summaryJY-20543 add AJ reports User pilot trackingJY-20543-AJ-re...→ JY-18909-automated-reports-ask-jiminnystatusOPENnote: for UP you cSubtasksAdd subtaskLinked work itelAdd linked work itv ActivityAll CommenAdd a coSuggest a reply…Status update… Thanks..Pro tip: press (M to comment30Kolay NiKO 1 14:41BE: 1 dMIKO&V NIKOlOV30 March 2026 at 14:38Where public function pushToDatadog - push to• userrllor enury Tor une creatonhhlfSupport Daily - in 3h 47mA100% CS•Tue 14 Apr 11:13:29+ CreateAsk Rovo© Give feedbackX• SecurityMore 7RevIewerUpdated5 days ago5 days ago(OPENFix versionsNoneSprintPlatform Sprint 1 Q2DaysNeed CANoParent4 JY-19240 AJ ReportsCanny LinksOpen Canny Links> More fields Original estimate, Time tracking>Automation 4 Rule executions> featureOs Open featureOsGroup: QueriesDEPLOY 8Fix downtime during tofeature flag releaseveplovea1.5SFJY-20509Ml keview = wlGROWTH - MAINTAIN OUR CO...veplovea1@ •000=W JY-19982ino sucn column " Iyoeon entity 'Event"IPLATFORM STABIEONYDeployed0.5 /2 0000 =© JY-20384Missed deletion of staledeals risks(REDUCE CHURNclosed1 72 •000=HX JY-20619[Pipedrive] DI > statusnot abeled. dale daramissingIREDUCE CHURNIDeployed0.5 80 0000=# JY-20614OD/TI > Refresh theresuis wnen tne tele iScleared with the 'x'FE IMPROVEMENTSDeployedu.s eeee=...
|
NULL
|
NULL
|
NULL
|
10121
|
|
10120
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:13:29+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10120
|
|
10119
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindowHelpjiminny.atlassian.net/jira/software/c/projects/JY/boards/37?selectedlssue=JY-20543~ Google Gemini...Platform Sprint 1 Q2 - Platform& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcwhy I can't see speakerdata on meemt in firefox.ho wto set it upSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activityShow thinking~8 Jiminnyg Ask Jiminny test report - 8 Apr 201≤ Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilcDealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.(x) Configure SSH access to multipleC CloudWatch I us-east-2+ New TabSince "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvO JIMINNY@ For you• Recent# Starred07 Apps8, SpacesJiminny (New)t **•Iil Plattorm Teamuu sE KanbanIID Capture TeamII Enterprise Stability I...WD Processing Team(9 Service-Desk— More soaces= Filtersit DasnooarasOperations%) Confluence88 Teams¿= Customise sidebarYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize pagenoacesPlatfo® SunQ SeiREADYQ Search4 JY-19240 / D JDevelopment JY-20543AJ Reports Branches Commits Pull requests Builds Deployments Feature flags Other links+v • jiminny/app (GitHub)v DescriptionWe want to be ablto use Userpilot tc• track each ger• for AJ reportswho has creat• for Exec reporparticipants lisAuthorID#11932SummaryJY-20543 add AJ reports User pilot trackingJY-20543-AJ-re...→ JY-18909-automated-reports-ask-jiminnystatusOPENnote: for UP you cSubtasksAdd subtaskLinked work itelAdd linked work itv ActivityAll CommenAdd a coSuggest a reply…Status update… Thanks..Pro tip: press (M to comment30Kolay NiKO 1 14:41BE: 1 dMIKO&V NIKOlOV30 March 2026 at 14:38Where public function pushToDatadog - push to• userrllor enury Tor une creatonhhlfSupport Daily • in 3h 47 mA100% CS•Tue 14 Apr 11:13:26+ CreateAsk Rovo© Give feedbackX• SecurityMore 7RevIewerUpdated5 days ago5 days ago(OPENFix versionsNoneSprintPlatform Sprint 1 Q2DaysNeed CANoParent4 JY-19240 AJ ReportsCanny LinksOpen Canny Links> More fields Original estimate, Time tracking> Automation 4 Rule executions> featureOs Open featureOsGroup: QueriesDEPLOY 8Fix downtime during tofeature flag releaseveplovea1.5SFJY-20509Ml keview = wlGROWTH - MAINTAIN OUR CO...veplovea1@ •000=W JY-19982No such column 'Type'on entitv 'Event'IPLATFORM STABIEONYDeployed0.5 /2 0000 =© JY-20384Missed deletion of staledeals risks(REDUCE CHURNclosed1 72 •000=HX JY-20619[Pipedrive] DI > statusnot abeled. dale daramissingIREDUCE CHURNDeployed0.5 86 0000=# JY-20614OD/TI > Refresh theresuis wnen tne tele iScleared with the 'X"FE IMPROVEMENTSDeployedu.s eeee=...
|
NULL
|
NULL
|
NULL
|
10119
|
|
10118
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Close tab
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
CloudWatch | us-east-2
CloudWatch | us-east-2
New Tab
Customize sidebar
Close Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
AI Chat settings
Close
WORK, Google Account: [EMAIL]
Main menu
New Chat
Open menu for conversation actions.
Conversation with Gemini
Conversation with Gemini
Copy prompt
Edit
You said why I can't see speaker data on meemt in firefox. ho wto set it up
You said
why I can't see speaker data on meemt in firefox. ho wto set it up
Listen
Show more options
Show thinking
Gemini said
Gemini said
Dealing with missing features right when you need them is incredibly frustrating. Assuming "meemt" means Google Meet, the reason you can't see your speaker data comes down to how Firefox interacts with Google's platform compared to Chrome.
Since "speaker data" can mean a couple of different things in a meeting, here are the two most likely causes for your issue and exactly how to get things working.
1. You Need "Speaker Notes" for Google Slides
1. You Need "Speaker Notes" for Google Slides
The Reality:
Google Meet has a native feature that lets you see your presentation's speaker notes right inside the video call interface.
However, this relies on a specific "Present a Tab" technology built exclusively for Google Chrome. Firefox handles screen sharing differently, so that native integration simply won't load.
View source details for citation from Google Workspace Updates. Opens side panel.
How to set it up (The Firefox Workaround):
You can still present and read your notes in Firefox by manually managing your windows.
Open your Google Slides presentation in a standard Firefox window.
Click the dropdown arrow next to the
Slideshow
button in the top right corner.
Select
Presenter view
to pop your speaker notes out into a separate, smaller window.
View source details for citation from Skywork. Opens side panel.
Join your Google Meet in a different Firefox window.
Click
Present now
and choose the
Window
option.
Select the window displaying your main slides (do not select your separate speaker notes window).
Resize your windows on your monitor so you can comfortably read the notes window while keeping an eye on the Meet window.
2. You Need "Speaker Labels" or Transcripts
2. You Need "Speaker Labels" or Transcripts
The Reality:
If you are trying to use a third-party AI note-taker (like Otter.ai, Tactiq, or tl;dv) to capture transcriptions and see who is speaking, Firefox is likely the roadblock. Firefox has strict privacy guardrails that prevent extensions from capturing internal browser audio easily, so most developers only build these tools for Chrome.
How to set it up:
Turn on built-in captions:
Google Meet has its own live captions that natively identify who is speaking, even in Firefox. Click the
CC
button at the bottom of your Meet screen to toggle them on.
Search for a Firefox add-on:
Check the Mozilla Add-ons store to see if your preferred tool actually has a supported Firefox version (for example, Fellow.ai offers one).
View source details for citation from Fellow.ai. Opens side panel.
Switch browsers temporarily:
If your specific transcription tool is explicitly Chrome-only, you will unfortunately need to join that specific meeting using a Chromium-based browser like Chrome, Edge, or Brave to capture the data.
Using Meet's built-in closed captions or the manual Presenter view workaround will get your speaker data back on track without forcing you to completely abandon Firefox.
Sources
Sources
I men in dia (arc) I can see my headphones in both microphone and speakers
I men in dia (arc) I can see my headphones in both microphone and speakers
Open upload file menu
Tools
Open mode picker
Pro
Send message
Your Jiminny chats aren’t used to improve our models. Gemini is AI and can make mistakes, including about people.
Your privacy & Gemini Opens in a new window
Your privacy & Gemini
Opens in a new window
Summarize page
Summarize page
Skip to:
Top Bar
Top Bar
Sidebar...
|
Firefox
|
Platform Sprint 1 Q2 - Platform Team - Scrum Board Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira — Work...
|
jiminny.atlassian.net/jira/software/c/projects/JY/ jiminny.atlassian.net/jira/software/c/projects/JY/boards/37?selectedIssue=JY-20543...
|
10118
|
|
10117
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Close tab
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
CloudWatch | us-east-2
CloudWatch | us-east-2
New Tab
Customize sidebar
Close Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
AI Chat settings
Close
WORK, Google Account: [EMAIL]
Main menu
New Chat
Open menu for conversation actions.
Conversation with Gemini
Conversation with Gemini
Copy prompt
Edit
You said why I can't see speaker data on meemt in firefox. ho wto set it up
You said
why I can't see speaker data on meemt in firefox. ho wto set it up
Listen
Show more options
Show thinking
Gemini said
Gemini said
Dealing with missing features right when you need them is incredibly frustrating. Assuming "meemt" means Google Meet, the reason you can't see your speaker data comes down to how Firefox interacts with Google's platform compared to Chrome.
Since "speaker data" can mean a couple of different things in a meeting, here are the two most likely causes for your issue and exactly how to get things working.
1. You Need "Speaker Notes" for Google Slides
1. You Need "Speaker Notes" for Google Slides
The Reality:
Google Meet has a native feature that lets you see your presentation's speaker notes right inside the video call interface.
However, this relies on a specific "Present a Tab" technology built exclusively for Google Chrome. Firefox handles screen sharing differently, so that native integration simply won't load.
View source details for citation from Google Workspace Updates. Opens side panel.
How to set it up (The Firefox Workaround):
You can still present and read your notes in Firefox by manually managing your windows.
Open your Google Slides presentation in a standard Firefox window.
Click the dropdown arrow next to the
Slideshow
button in the top right corner.
Select
Presenter view
to pop your speaker notes out into a separate, smaller window.
View source details for citation from Skywork. Opens side panel.
Join your Google Meet in a different Firefox window.
Click
Present now
and choose the
Window
option.
Select the window displaying your main slides (do not select your separate speaker notes window).
Resize your windows on your monitor so you can comfortably read the notes window while keeping an eye on the Meet window.
2. You Need "Speaker Labels" or Transcripts
2. You Need "Speaker Labels" or Transcripts
The Reality:
If you are trying to use a third-party AI note-taker (like Otter.ai, Tactiq, or tl;dv) to capture transcriptions and see who is speaking, Firefox is likely the roadblock. Firefox has strict privacy guardrails that prevent extensions from capturing internal browser audio easily, so most developers only build these tools for Chrome.
How to set it up:
Turn on built-in captions:
Google Meet has its own live captions that natively identify who is speaking, even in Firefox. Click the
CC
button at the bottom of your Meet screen to toggle them on.
Search for a Firefox add-on:
Check the Mozilla Add-ons store to see if your preferred tool actually has a supported Firefox version (for example, Fellow.ai offers one).
View source details for citation from Fellow.ai. Opens side panel.
Switch browsers temporarily:
If your specific transcription tool is explicitly Chrome-only, you will unfortunately need to join that specific meeting using a Chromium-based browser like Chrome, Edge, or Brave to capture the data.
Using Meet's built-in closed captions or the manual Presenter view workaround will get your speaker data back on track without forcing you to completely abandon Firefox.
Sources
Sources
I men in dia (arc) I can see my headphones in both microphone and speakers
I men in dia (arc) I can see my headphones in both microphone and speakers
Open upload file menu
Tools
Open mode picker
Pro
Send message
Your Jiminny chats aren’t used to improve our models. Gemini is AI and can make mistakes, including about people.
Your privacy & Gemini Opens in a new window
Your privacy & Gemini
Opens in a new window
Summarize page
Summarize page
Skip to:
Top Bar...
|
Firefox
|
Platform Sprint 1 Q2 - Platform Team - Scrum Board Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira — Work...
|
jiminny.atlassian.net/jira/software/c/projects/JY/ jiminny.atlassian.net/jira/software/c/projects/JY/boards/37?selectedIssue=JY-20543...
|
10117
|
|
10116
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpjiminny.atlassian.net/jira/software/c/projects/JY/boards/37~ Google Gemini...Platform Sprint 1 Q2 - PlatformZ Configure SSH access to multiple@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcwhy I can't see speakerdata on meemt in firefox.ho wto set it upSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activityShow thinkingg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilcDealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.(x) Configure SSH access to multipleC CloudWatch I us-east-2+ New TabSince "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvJIMINNY@ For you• Recent# Starred0* Apps0, SpacesRecentJiminny (New)| Platform TeamIu se KanbaniIID Capture TeamIID Enterprise Stability I...ID Processing TeamService-Desk— More spaces= FiltersCB DashboardsC Operations% Confluence:: Teams2= Customise sidebarYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize pageSpaces / Jiminny (New)Platform Team&@ Summary & TimelineQ Search boardREADY FOR DEVQ Search |E BacklogWD Active sprintsEpic vIN DEV 4[Part2] Automatedreports with Ask JiminnyAJ REPORTSIn DevAI BE FE QA11.5 82 0.00 =[JY-18909Delays in CRM SyncPLATFORM STABILITYIn Dev3 0000=[JY-20553Experiment with AIworkflow for automatedDependabot fixesIMPROVEMENT OF OUR EFFICI...In Dev2 0000 =-20551|Fix and Stabilize MobileTest Suite for Androidand iOS using new...MAINTENANCEIn DevQA]3.000 =[ JY-20431• 80 lihl l Support Daily • in 3h 47 mA*100% C Tue 14 Apr 11:13:19+ CreateAsk Rovo@ Calendar L ReportsTesting Board List E Forms E Components % Development % CodeO Security More 7 +Typev|Label vQuick filtersComplete sprintGroup: QueriesCODE REVIEW 3BLOCKEDPO ACCEPTANCEDEPLOY 8Evaluation for AI ActivityTypesAUTO-DETECTED ACTIVITY TY...Code Review582000=E JY-19798AJ Reports > Tra... CAJ REPORTScoce keview1 il •0 Status.••Q JY-20543Prepare fallback withemall tor S50 torpersistent.REDUCE CHURNCode Review1!2•00=N JY-20632+ CreateFix downtime during tofeature flag releaseSUPPORT TICKETSDeployed1.5 % .000=#* JY-20565AI Review - Q1GROWTH - MAINTAIN OUR CO...Deployed100000=JY-19982No sucy colum Type*PLATFORM STABILITYDeployed0.5 %2 0000 =@JY-20384Missed deletion of staledeals risksREDUCE CHURNClosed1 820000=+X JY-20619[Pipedrive] DI > statusnot labeled, date datamissingREDUCE CHURNDeployed0.5 72 0000 =# JY-20614OD/TI > Refresh theresults when the field iscleared with the 'x'FE IMPROVEMENTSDeployed0.5 0.00 =...
|
NULL
|
NULL
|
NULL
|
10116
|
|
10115
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:13:19+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10115
|
|
10114
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Close tab
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
CloudWatch | us-east-2
CloudWatch | us-east-2
New Tab
Customize sidebar
Close Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
AI Chat settings
Close
WORK, Google Account: [EMAIL]
Main menu
New Chat
Open menu for conversation actions.
Conversation with Gemini
Conversation with Gemini
Copy prompt
Edit
You said why I can't see speaker data on meemt in firefox. ho wto set it up
You said
why I can't see speaker data on meemt in firefox. ho wto set it up
Listen
Show more options
Show thinking
Gemini said
Gemini said
Dealing with missing features right when you need them is incredibly frustrating. Assuming "meemt" means Google Meet, the reason you can't see your speaker data comes down to how Firefox interacts with Google's platform compared to Chrome.
Since "speaker data" can mean a couple of different things in a meeting, here are the two most likely causes for your issue and exactly how to get things working.
1. You Need "Speaker Notes" for Google Slides
1. You Need "Speaker Notes" for Google Slides
The Reality:
Google Meet has a native feature that lets you see your presentation's speaker notes right inside the video call interface.
However, this relies on a specific "Present a Tab" technology built exclusively for Google Chrome. Firefox handles screen sharing differently, so that native integration simply won't load.
View source details for citation from Google Workspace Updates. Opens side panel.
How to set it up (The Firefox Workaround):
You can still present and read your notes in Firefox by manually managing your windows.
Open your Google Slides presentation in a standard Firefox window.
Click the dropdown arrow next to the
Slideshow
button in the top right corner.
Select
Presenter view
to pop your speaker notes out into a separate, smaller window.
View source details for citation from Skywork. Opens side panel....
|
Firefox
|
Platform Sprint 1 Q2 - Platform Team - Scrum Board Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira — Work...
|
jiminny.atlassian.net/jira/software/c/projects/JY/ jiminny.atlassian.net/jira/software/c/projects/JY/boards/37...
|
10114
|
|
10113
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Close tab
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
CloudWatch | us-east-2
CloudWatch | us-east-2
New Tab
Customize sidebar
Close Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
AI Chat settings
Close
WORK, Google Account: [EMAIL]
Main menu
New Chat
Open menu for conversation actions.
Conversation with Gemini
Conversation with Gemini
Copy prompt
Edit
You said why I can't see speaker data on meemt in firefox. ho wto set it up
You said
why I can't see speaker data on meemt in firefox. ho wto set it up
Listen
Show more options
Show thinking
Gemini said
Gemini said
Dealing with missing features right when you need them is incredibly frustrating. Assuming "meemt" means Google Meet, the reason you can't see your speaker data comes down to how Firefox interacts with Google's platform compared to Chrome.
Since "speaker data" can mean a couple of different things in a meeting, here are the two most likely causes for your issue and exactly how to get things working.
1. You Need "Speaker Notes" for Google Slides
1. You Need "Speaker Notes" for Google Slides
The Reality:
Google Meet has a native feature that lets you see your presentation's speaker notes right inside the video call interface.
However, this relies on a specific "Present a Tab" technology built exclusively for Google Chrome. Firefox handles screen sharing differently, so that native integration simply won't load.
View source details for citation from Google Workspace Updates. Opens side panel.
How to set it up (The Firefox Workaround):
You can still present and read your notes in Firefox by manually managing your windows.
Open your Google Slides presentation in a standard Firefox window.
Click the dropdown arrow next to the
Slideshow
button in the top right corner.
Select
Presenter view
to pop your speaker notes out into a separate, smaller window.
View source details for citation from Skywork. Opens side panel.
Join your Google Meet in a different Firefox window.
Click
Present now
and choose the
Window
option.
Select the window displaying your main slides (do not select your separate speaker notes window).
Resize your windows on your monitor so you can comfortably read the notes window while keeping an eye on the Meet window.
2. You Need "Speaker Labels" or Transcripts
2. You Need "Speaker Labels" or Transcripts
The Reality:
If you are trying to use a third-party AI note-taker (like Otter.ai, Tactiq, or tl;dv) to capture transcriptions and see who is speaking, Firefox is likely the roadblock. Firefox has strict privacy guardrails that prevent extensions from capturing internal browser audio easily, so most developers only build these tools for Chrome.
How to set it up:
Turn on built-in captions:
Google Meet has its own live captions that natively identify who is speaking, even in Firefox. Click the
CC
button at the bottom of your Meet screen to toggle them on.
Search for a Firefox add-on:
Check the Mozilla Add-ons store to see if your preferred tool actually has a supported Firefox version (for example, Fellow.ai offers one).
View source details for citation from Fellow.ai. Opens side panel.
Switch browsers temporarily:
If your specific transcription tool is explicitly Chrome-only, you will unfortunately need to join that specific meeting using a Chromium-based browser like Chrome, Edge, or Brave to capture the data.
Using Meet's built-in closed captions or the manual Presenter view workaround will get your speaker data back on track without forcing you to completely abandon Firefox.
Sources
Sources
I men in dia (arc) I can see my headphones in both microphone and speakers
I men in dia (arc) I can see my headphones in both microphone and speakers
Open upload file menu
Tools
Open mode picker
Pro...
|
Firefox
|
Platform Sprint 1 Q2 - Platform Team - Scrum Board Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira — Work...
|
jiminny.atlassian.net/jira/software/c/projects/JY/ jiminny.atlassian.net/jira/software/c/projects/JY/boards/37...
|
10113
|
|
10112
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpjiminny.atlassian.net/jira/software/c/projects/JY/boards/37~ Google Gemini...« Plafarm Spint 1 2 - Platform& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activityg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformJY-20543 add AJ reports User pil(x) Configure SSH access to multipleC CloudWatch I us-east-2+ New Tab0,JIMINNYHomeJiraContluenceDlouckelJira Service ManagementIrello:8Teams3 moreJira Product Discovery JOINGoogle DriveRecommended for your team1 collection, 4 tools (NEWRun vour whole project seamlesslyMore Atlassian appsJiminny(New)Timelinewhy I can't see speakerdata on meemt in firefox.ho wto set it upShow thinking vDealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.Since "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize page0 +2Q SearchE BacklogWD Active sprintsEpic vIN DEV 4[Part2] Automatedreports with Ask JiminnyAJ REPORTSIn DevAI BE FE QA11.5 82 0.00 =AJY-18909Delays in CRM SyncPLATFORM STABILITYIn Dev3 0000 =[JY-20553Experiment with AIworkflow for automatedDependabot fixesIMPROVEMENT OF OUR EFFICI...In Dev2 ..00=-20551|Fix and Stabilize MobileTest Suite for Androidand iOS using new...MAINTENANCEIn DevQA]3.000 =[ JY-2043180 liil l Support Daily • in 3h 47 mA*100% C• Tue 14 Apr 11:13:14+ CreateAsk Rovo@ Calendar L Reports4 Testing Board E List # Forms E Components % Development % Code Security More 7 +Type vLabelvQuick filters vComplete sprintGroup: QueriesCODE REVIEW 3BLOCKEDPO ACCEPTANCEDEPLOY 8Evaluation for AI ActivityTypesAUTO-DETECTED ACTIVITY TY...Code Review582000=E JY-19798AJ Reports > TrackingAJ REPORTSCode Review1 %)•0=[ JY-20543Prepare fallback withemail for SSO forpersistent'...REDUCE CHURNCode Review1!2•00=N JY-20632Fix downtime during tofeature flag releaseSUPPORT TICKETSDeployed1.5 % .000=#* JY-20565AI Review - Q1GROWTH - MAINTAIN OUR CO...Deployed100000=JY-19982No sucy colum Type*PLATFORM STABILITYDeployed0.5 72 0000 =@JY-20384Missed deletion of staledeals risksREDUCE CHURNClosed1 820000=+X JY-20619[Pipedrive] DI > statusnot labeled, date datamissingREDUCE CHURNDeployed0.5 72 0000 =# JY-20614OD/TI > Refresh theresults when the field iscleared with the 'x'FE IMPROVEMENTSDeployed0.5 0.00 =...
|
NULL
|
NULL
|
NULL
|
10112
|
|
10111
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpus-east-2.console.aws.amazon.com/cloudwatch/home?region=us-east-2#home:~ Google Geminiyi Plafform Sprint 2 - Platform.& Configure SSH access to multiple ePlatform Sprint 1 Q2 - Platform Team - Scrumboard " Jifd@ Console Home | Console Home | u:SecurityGroup | EC2 | us-east-2speakerin firefox.JY-20543 add AJ reports User pilcSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activityShow thinkingvg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformJY-20543 add AJ reports User pilDealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.(x) Configure SSH access to multipleC CloudWatch I us-east-2+ New TabSince "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvQ Search[Option+5] ©]0 EC2Elastic Container Service s3 CodeDeploy C& CloudWatch ElastiCache oz) Aurora and RDS liêl Amazon OpenSearch Ser... ® CloudFront Ea MediaLivecloud WatchCloudWatchOverview infoOverviewravorites and recentsFilter by resource groupIngestionDashboardsAlarms A0 ©27 ©o• Al Operations• GenAl Observability• Application Signals (APM)• Infrastructure Monitoring• LogsLog ManagementLog Analytics PreviewLog AnomaliesLive TailLogs InsightsContributor InsightsAlarms by AWS service infoServicesECZSimple Queue ServiceIn alarm OInsufficient data 0 OK 2Default DashboardName any CloudWatch dashboard CloudWatch-Default to display it here. Create a new default dashboard• Metrics• Network MonitoringApplication Insights• SetupGet started with Application Insights infoSet up monitors and dashboards to detect issues and resolve problems with enterprise applications, databases, and workloads.• How it worksYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize pageE CloudShellFeedback>0 lhlj Support Daily • in 3h 47 m1wA100% CS•Tue 14 Apr 11:13:13United States (Ohio)Account ID: 4387-4037-0364STAGE]CustomUTC timezoneActions Vview recentalarms casnooaroi12hRecent alarms info• meeting-bots-ec2-cpu-utilizationPercent50%Cruurilizarion > b0 tor carapoints Witnin s minute27%4.04%05:0006:0007:00- ruutilization• meeting-bot-sqs-alarmLount4.42-304:0005:00 106:00- NumberOfMessagesReceived• NumberOfMessagesReceived (expected)07:00Configure Application Insights© 2026, Amazon Web Services, Inc. or its affiliates.PrivacyTermscookie preterences...
|
NULL
|
NULL
|
NULL
|
10111
|
|
10110
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:13:12+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10110
|
|
10109
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:13:12+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10109
|
|
10108
|
+Notion CalendarEditViewWindowHelpELHomeDMsActivit +Notion CalendarEditViewWindowHelpELHomeDMsActivityFilesJiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamPS> 0(alo)Support Daily - in 3 h 47 m•)).100% 247Tue 14 Apr 11:13:09Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev86 дMessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday ~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolav Yankov 10:41 AM$1N+Firefox# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product_launches# random# releases# sofia-office# support# thank-yousзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтьрNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+Aa...
|
NULL
|
NULL
|
NULL
|
10108
|
|
10107
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpus-east-2.console.aws.amazon.com/cloudwatch/home?region=us-east-2#home:~ Google GeminiPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcwhy I can't see speakerdata on meemt in firefox.ho wto set it upSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activityShow thinking~g Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformJY-20543 add AJ reports User pilDealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.(x) Configure SSH access to multipleC CloudWatch I us-east-2+ New TabSince "speaker data" can mean a couple ofdifferent things in a meeting, here are the twomost likely causes for your issue and exactlyhow to get things working.1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvQ Search[Option+5] ©]C EC2Elastic Container Service s3 CodeDeploy C& CloudWatch ElastiCache oz) Aurora and RDS liêl Amazon OpenSearch Ser... ® CloudFront Ea MediaLivecloud WatchCloudWatchOverview infoOverviewravorites and recentsFilter by resource groupIngestionDashboardsAlarms A0 ©27 ©o• Al Operations• GenAl Observability• Application Signals (APM)• Infrastructure Monitoring• LogsLog ManagementLog Analytics PreviewLog AnomaliesLive TailLogs InsightsContributor InsightsAlarms by AWS service infoServicesECZSimple Queue ServiceIn alarm OInsufficient data 0 OK 2Default DashboardName any CloudWatch dashboard CloudWatch-Default to display it here. Create a new default dashboard• Metrics• Network MonitoringApplication Insights• SetupGet started with Application Insights infoSet up monitors and dashboards to detect issues and resolve problems with enterprise applications, databases, and workloads.• How it works*Your Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize pageE CloudShellFeedback>0 lhlj Support Daily • in 3h 47 m1wA100% CS•Tue 14 Apr 11:13:07United States (Ohio)Account ID: 4387-4037-0364STAGE]CustomUTC timezoneActions Vview recentalarms casnooaroi12hRecent alarms info• meeting-bots-ec2-cpu-utilizationPercent50%Cruurilizarion > b0 tor carapoints Witnin s minute27%4.04%05:0006:0007:00- ruutilization• meeting-bot-sqs-alarmLount4.42-304:0005:00 106:00- NumderurMessageskecelved• NumberOfMessagesReceived (expected)07:00Configure Application Insights© 2026, Amazon Web Services, Inc. or its affiliates.PrivacyTermscookie preterences...
|
NULL
|
NULL
|
NULL
|
10107
|
|
10106
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:13:07+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10106
|
|
10105
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsFi FirefoxFileEoitViewHistoryBookmarksProfilesToolsFirefox about:preferencesWindow Help~ Google Gemini... XPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activity8 Ask Jiminny test report - 8 Apr 20.≤ Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilc(x) Configure SSH access to multipleC CloudWatch I us-east-2rộs Settings+ New Tabwhy I can't see speakerdata on meemt in firefox.ho wto set it upShow thinking~Dealing with missing features right when youneed them is incredibly frustrating. Assuming"meemt" means Google Meet, the reason youcan't see your speaker data comes down tohow Firefox interacts with Google's platformcompared to Chrome.Since "speaker data" can mean a couple ofdifferent things in a meeting, here are the twoSettingsid exactly1. You Need "Speaker Notes" for GoogleSlidesThe Reality: Google Meet has a native featurethat lets you see your presentation's speakernotes right inside the video call interface.However, this relies on a specific "Present aTab" technology built exclusively for GoogleChrome. Firefox handles screen sharingdifferently, so that native integration simplywon't load.How to set it up (The Firefox Workaround):You can still present and read your notes inFirefox by manually managing your windows.I men in dia (arc) | can see myheadphones in both microphone andspeakersProvYour Jiminny chats aren't used to improve our models. Gemini is Alane can make mistakes, Inciualne aoout peodleYour privacy & GeminiSummarize pageO3 GeneralA HomeQ Search8 Privacy & SecurityQ SyncAl ControlsC Firefox Labsm More from MozillaExtensions & ThemesFirefox Supportj Support Daily • in 3h 47mA100% CS•Tue 14 Apr 11:13:05Your browser is being managed by your organization.Q Find in SettingsGeneralDefault browserFirefox is your default browser. Good choice.Startup• Open previous windows and tabs• Always check if Firefox is your default browserImport browser dataBring your bookmarks, passwords, history, extensions, and autofill data from another browser.Import dataProfilesLearn moreEach profile has separate browsing data and settings, including history, passwords, and more.SettingsTabsUoenlne• Open links in tabs instead of new windows• When you open a link, image or media in a new tab, switch to it immediately_ Open links from apps next to your active tabInteraction• CtrI+Tab cycles through tabs in recently used orderShow an image preview when you hover on a tab• Use Al to suggest tabs and a name for tab groupsClosing• Ask before closing multiple tabsAsk before quitting with HQBrowser LayoutHorizontal tabslaos authe l0dvertical tabsTabs on the side. in the sidebarShow sidebarQuickly access bookmarks, tabs from your phone, Al chatbots, and more without leaving your main view.Language and AppearanceWebsite appearance...
|
NULL
|
NULL
|
NULL
|
10105
|
|
10104
|
Notion CalendarEditViewWindowHelp> 0ltlSupport Notion CalendarEditViewWindowHelp> 0ltlSupport Daily • in 3h 47 m100% <47Tue 14 Apr 11:13:05+HomeDMsActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousSearch Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+minoitymunnoзначи не сьздава веднага по принцип, в някакьв час на деня лиToday~Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result но e failedзначиREASON_NOT_ENOUGH_ACTIVITIESвиж дали има нещо в OD със този филтърNikolay Yankov 11:01 AMДобреMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaNew...
|
NULL
|
NULL
|
NULL
|
10104
|