|
83185
|
2026-04-22T08:53:08.490583+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
9467259
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83212
|
2026-04-22T08:56:44.553672+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
9683316
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Search
|
findMapAccountId
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83318
|
2026-04-22T09:04:15.857857+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
10134569
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83340
|
2026-04-22T09:05:21.169861+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
10199879
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83359
|
2026-04-22T09:05:51.827690+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
10230536
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83374
|
2026-04-22T09:06:54.443953+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
10293150
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83390
|
2026-04-22T09:13:49.334710+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
10708028
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for InternalAccountsMapTrait.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Services\Crm\IntegrationApp\ServiceTraits;
use Jiminny\Repositories\Crm\CrmEntityRepository;
trait InternalAccountsMapTrait
{
private static ?array $internalAccountToContactMap = null;
/**
* Returns a map of internal account crm_provider_id's pointing to their contact crm_provider_id.
*
* @return array<int|string, int|string>
*/
protected function getInternalAccountToContactMap(): array
{
if (self::$internalAccountToContactMap === null) {
/** @var CrmEntityRepository $crmEntityRepo */
$crmEntityRepo = app(CrmEntityRepository::class);
self::$internalAccountToContactMap = $crmEntityRepo->getInternalAccountToContactMap($this->config);
}
return self::$internalAccountToContactMap;
}
}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83398
|
2026-04-22T09:15:47.530360+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
10826220
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for InternalAccountsMapTrait.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Services\Crm\IntegrationApp\ServiceTraits;
use Jiminny\Repositories\Crm\CrmEntityRepository;
trait InternalAccountsMapTrait
{
private static ?array $internalAccountToContactMap = null;
/**
* Returns a map of internal account crm_provider_id's pointing to their contact crm_provider_id.
*
* @return array<int|string, int|string>
*/
protected function getInternalAccountToContactMap(): array
{
if (self::$internalAccountToContactMap === null) {
/** @var CrmEntityRepository $crmEntityRepo */
$crmEntityRepo = app(CrmEntityRepository::class);
self::$internalAccountToContactMap = $crmEntityRepo->getInternalAccountToContactMap($this->config);
}
return self::$internalAccountToContactMap;
}
}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83403
|
2026-04-22T09:20:21.295699+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11099978
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for InternalAccountsMapTrait.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Services\Crm\IntegrationApp\ServiceTraits;
use Jiminny\Repositories\Crm\CrmEntityRepository;
trait InternalAccountsMapTrait
{
private static ?array $internalAccountToContactMap = null;
/**
* Returns a map of internal account crm_provider_id's pointing to their contact crm_provider_id.
*
* @return array<int|string, int|string>
*/
protected function getInternalAccountToContactMap(): array
{
if (self::$internalAccountToContactMap === null) {
/** @var CrmEntityRepository $crmEntityRepo */
$crmEntityRepo = app(CrmEntityRepository::class);
self::$internalAccountToContactMap = $crmEntityRepo->getInternalAccountToContactMap($this->config);
}
return self::$internalAccountToContactMap;
}
}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83420
|
2026-04-22T09:20:53.641313+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11132322
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for InternalAccountsMapTrait.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Services\Crm\IntegrationApp\ServiceTraits;
use Jiminny\Repositories\Crm\CrmEntityRepository;
trait InternalAccountsMapTrait
{
private static ?array $internalAccountToContactMap = null;
/**
* Returns a map of internal account crm_provider_id's pointing to their contact crm_provider_id.
*
* @return array<int|string, int|string>
*/
protected function getInternalAccountToContactMap(): array
{
if (self::$internalAccountToContactMap === null) {
/** @var CrmEntityRepository $crmEntityRepo */
$crmEntityRepo = app(CrmEntityRepository::class);
self::$internalAccountToContactMap = $crmEntityRepo->getInternalAccountToContactMap($this->config);
}
return self::$internalAccountToContactMap;
}
}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83427
|
2026-04-22T09:22:24.628108+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11223306
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83432
|
2026-04-22T09:23:12.621978+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11271299
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83441
|
2026-04-22T09:24:06.951529+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11325627
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83477
|
2026-04-22T09:25:43.310861+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11421983
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83489
|
2026-04-22T09:25:53.317663+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11431990
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83508
|
2026-04-22T09:29:52.663466+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
11671328
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXOutline
|
Changes
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83537
|
2026-04-22T09:35:29.832910+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12008454
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXList
|
list
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83552
|
2026-04-22T09:37:18.574646+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12117193
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXList
|
list
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83567
|
2026-04-22T09:40:43.643479+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12322256
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXOutline
|
Changes
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83576
|
2026-04-22T09:41:11.224883+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12349836
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83583
|
2026-04-22T09:41:52.229501+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12390840
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83593
|
2026-04-22T09:42:14.916703+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12413526
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83612
|
2026-04-22T09:46:53.091210+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12691692
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83618
|
2026-04-22T09:47:52.991501+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
12751581
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83653
|
2026-04-22T09:52:57.086882+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
13055665
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83727
|
2026-04-22T10:02:12.398494+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
13610960
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
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 = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at 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 = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83806
|
2026-04-22T10:16:09.600050+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
14448119
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for CrmEntityRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories\Crm;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Jiminny\Models\Account;
use Jiminny\Models\Contact;
use Jiminny\Models\Crm\BusinessProcess;
use Jiminny\Models\Crm\Configuration;
use Jiminny\Models\Crm\Profile;
use Jiminny\Models\Crm\RecordType;
use Jiminny\Models\Lead;
use Jiminny\Models\Opportunity;
use Jiminny\Models\Stage;
class CrmEntityRepository
{
public function getExternalContactMap(Configuration $configuration): array
{
$configurationId = $configuration->getId();
$contacts = [];
$m1 = memory_get_usage();
Log::info(
'ExternalContactMap before',
[
'current' => $m1,
'peak' => memory_get_peak_usage(),
'config_id' => $configurationId,
]
);
$results = DB::select(
'select id, crm_provider_id from con......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
83852
|
2026-04-22T10:24:00.639548+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
14919147
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for api.php
|
<?php
declare(strict_types=1);
/**
* API rou <?php
declare(strict_types=1);
/**
* API routes.
*
* @see \Jiminny\Providers\RouteServiceProvider
*
* @var Router $router
*/
use Illuminate\Routing\Router;
use Illuminate\Support\Collection;
use Jiminny\Component\DealInsights\Forecast\Forecast;
use Jiminny\Component\Router\Routes;
use Jiminny\Contracts\Acl\PermissionEnum;
use Jiminny\Http\Controllers;
use Jiminny\Http\Controllers\API\ActivityController;
use Jiminny\Http\Controllers\API\AiCrmNotesController;
use Jiminny\Http\Controllers\API\ClientTokenController;
use Jiminny\Http\Controllers\API\CrmController;
use Jiminny\Http\Controllers\API\TeamInsights\TeamInsightsAiCallScoringController;
use Jiminny\Http\Controllers\ConferencesOptInOutController;
use Jiminny\Http\Controllers\API\DealRiskController;
use Jiminny\Http\Controllers\API\InstantMeetingController;
use Jiminny\Http\Controllers\API\LanguageController;
use Jiminny\Http\Controllers\API\LiveFeedController;
use Jiminny\Http\Controllers\API\MeetingsController;
use Jimi......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84122
|
2026-04-22T10:54:45.949682+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
16764409
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for AutomatedReportsRepository.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Repositories;
use Carbon\CarbonImmutable;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Carbon;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Facades\DB;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\AutomatedReportResult;
use Jiminny\Models\Team;
use Jiminny\Models\User;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Jiminny\Services\Kiosk\AutomatedReports\ReportSort;
use Jiminny\Services\Kiosk\AutomatedReports\ReportSortDirection;
class AutomatedReportsRepository
{
/**
* Create a new automated report
*
* @param array $data
*
* @return AutomatedReport
*/
public function create(array $data): AutomatedReport
{
return AutomatedReport::create($data);
}
/**
* Find an automated report by UUID
*
* @param string $uuid
*
* @return Aut......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84127
|
2026-04-22T10:55:10.022901+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
16788482
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for JiminnyDebugCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands;
use Carbon\Carbon;
use Illuminate\Console\Command;
use InvalidArgumentException;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\SendReportMailJob;
use Jiminny\Jobs\JobDispatcherInterface;
use Jiminny\Models\Activity;
use Jiminny\Models\AutomatedReportResult;
use Jiminny\Models\Team;
use Jiminny\Services\Activity\CrmOwnerResolver;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
/**
* Class JiminnyDebugCommand
*
* @package Jiminny\Console\Commands
*/
class JiminnyDebugCommand extends Command
{
public const string FREQUENCY_DAILY = 'daily';
public const string FREQUENCY_WEEKLY = 'weekly';
public const string FREQUENCY_MONTHLY = 'monthly';
public const string FREQUENCY_QUARTERLY = 'quarterly';
public const string FREQUENCY_ONE_OFF = 'one_off';
protected $signature = 'jiminny:debug';
public function handle(Jo......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84195
|
2026-04-22T11:04:22.134332+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
17340752
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for SF.sql
|
SELECT a.id, a.uuid, a.actual_start_time, o.id, o. SELECT a.id, a.uuid, a.actual_start_time, o.id, o.uuid FROM opportunities o
JOIN activities a ON o.id = a.opportunity_id
WHERE a.crm_configuration_id = 39
AND a.actual_start_time > '2025-10-13'
AND a.type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM activities
WHERE crm_configuration_id = 39 and user_id = 143
and actual_start_time >= '2025-10-13'
AND type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM opportunities WHERE account_id IN (178);
select * from activities where id IN (620137, 620187, 620188, 620189, 620230);
# HS
SELECT * FROM opportunities WHERE id IN (238);
select * from activities where id IN (477,2076);
select * from users;
SELECT COUNT(*) FROM users;
SELECT COUNT(*) FROM activities;
SELECT COUNT(*) FROM opportunities;
UPDATE activities
SET
actual_start_time = '2025-12-19 09:00:00',
actual_end_time = '2025-12-19 10:30:00',
scheduled_start_time = '2025-12-19 09:00:00',
scheduled_end_t......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84280
|
2026-04-22T11:13:15.379202+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
17874029
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for SF.sql
|
SELECT a.id, a.uuid, a.actual_start_time, o.id, o. SELECT a.id, a.uuid, a.actual_start_time, o.id, o.uuid FROM opportunities o
JOIN activities a ON o.id = a.opportunity_id
WHERE a.crm_configuration_id = 39
AND a.actual_start_time > '2025-10-13'
AND a.type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM activities
WHERE crm_configuration_id = 39 and user_id = 143
and actual_start_time >= '2025-10-13'
AND type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM opportunities WHERE account_id IN (178);
select * from activities where id IN (620137, 620187, 620188, 620189, 620230);
# HS
SELECT * FROM opportunities WHERE id IN (238);
select * from activities where id IN (477,2076);
select * from users;
SELECT COUNT(*) FROM users;
SELECT COUNT(*) FROM activities;
SELECT COUNT(*) FROM opportunities;
UPDATE activities
SET
actual_start_time = '2025-12-19 09:00:00',
actual_end_time = '2025-12-19 10:30:00',
scheduled_start_time = '2025-12-19 09:00:00',
scheduled_end_t......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84299
|
2026-04-22T11:13:54.727564+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
17913379
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for AutomatedReportsCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Illuminate\Support\Collection;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\Team;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The consol......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84314
|
2026-04-22T11:14:14.287155+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
17932940
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for AutomatedReportsCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Illuminate\Support\Collection;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\Team;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The consol......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84353
|
2026-04-22T11:17:21.707304+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
18120371
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for SF.sql
|
SELECT a.id, a.uuid, a.actual_start_time, o.id, o. SELECT a.id, a.uuid, a.actual_start_time, o.id, o.uuid FROM opportunities o
JOIN activities a ON o.id = a.opportunity_id
WHERE a.crm_configuration_id = 39
AND a.actual_start_time > '2025-10-13'
AND a.type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM activities
WHERE crm_configuration_id = 39 and user_id = 143
and actual_start_time >= '2025-10-13'
AND type IN ('conference', 'softphone-inbound', 'softphone-outbound')
;
SELECT * FROM opportunities WHERE account_id IN (178);
select * from activities where id IN (620137, 620187, 620188, 620189, 620230);
# HS
SELECT * FROM opportunities WHERE id IN (238);
select * from activities where id IN (477,2076);
select * from users;
SELECT COUNT(*) FROM users;
SELECT COUNT(*) FROM activities;
SELECT COUNT(*) FROM opportunities;
UPDATE activities
SET
actual_start_time = '2025-12-19 09:00:00',
actual_end_time = '2025-12-19 10:30:00',
scheduled_start_time = '2025-12-19 09:00:00',
scheduled_end_t......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84380
|
2026-04-22T11:18:34.991479+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
18193660
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for AutomatedReportsCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Illuminate\Support\Collection;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\Team;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The consol......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84432
|
2026-04-22T11:22:45.857772+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
18444244
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for RequestGenerateAskJiminnyReportJob.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Jobs\AutomatedReports;
use Carbon\Carbon;
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldBeUnique;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Contracts\Routing\UrlGenerator;
use Illuminate\Queue\InteractsWithQueue;
use Jiminny\Component\ProphetAi\Exceptions\ProphetException;
use Jiminny\Component\ProphetAi\ProphetClient;
use Jiminny\Component\Queue\Constants;
use Jiminny\Jobs\JobDispatcherInterface;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\AutomatedReportResult;
use Jiminny\Models\Team;
use Jiminny\Services\Kiosk\AutomatedReports\AskJiminnyReportActivityService;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
use Throwable;
class RequestGenerateAskJiminnyReportJob implements ShouldQueue, ShouldBeUnique
{
use InteractsWithQueue;
use Queueable;
private const string LOG_PREFIX = '[AskJiminnyReport:Generate]';
private ......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84446
|
2026-04-22T11:22:57.964605+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
18456350
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for JiminnyDebugCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands;
use Carbon\Carbon;
use Illuminate\Console\Command;
use InvalidArgumentException;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\SendReportMailJob;
use Jiminny\Jobs\JobDispatcherInterface;
use Jiminny\Models\Activity;
use Jiminny\Models\AutomatedReportResult;
use Jiminny\Models\Team;
use Jiminny\Services\Activity\CrmOwnerResolver;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
/**
* Class JiminnyDebugCommand
*
* @package Jiminny\Console\Commands
*/
class JiminnyDebugCommand extends Command
{
public const string FREQUENCY_DAILY = 'daily';
public const string FREQUENCY_WEEKLY = 'weekly';
public const string FREQUENCY_MONTHLY = 'monthly';
public const string FREQUENCY_QUARTERLY = 'quarterly';
public const string FREQUENCY_ONE_OFF = 'one_off';
protected $signature = 'jiminny:debug';
public function handle(Jo......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84465
|
2026-04-22T11:23:35.267125+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
18493651
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
[2026-04-22 11:23:14] local.INFO: $payload
Array
[2026-04-22 11:23:14] local.INFO: $payload
Array
(
[user_question] => Are these activities and give me the most insightful information about them
[call_ids] => Array
(
[0] => 1
[1] => 2
[2] => 3
)
[team_id] => 1
[request_id] => d3037407-091e-438a-8c8e-6745c5bf8df9
[callback_url] => https://qatest:[EMAIL]/webhook/reports/ready
[report_period] => 21 Apr 2026
[report_name] => Search One
)
{"correlation_id":"c786229a-00f6-4af1-b4ec-7553791bafe4","trace_id":"d4cfff0e-85bf-4b35-a8c0-d0752235ffc4"}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84535
|
2026-04-22T11:32:08.543711+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19006913
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for JiminnyDebugCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands;
use Carbon\Carbon;
use Illuminate\Console\Command;
use InvalidArgumentException;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\SendReportMailJob;
use Jiminny\Jobs\JobDispatcherInterface;
use Jiminny\Models\Activity;
use Jiminny\Models\AutomatedReportResult;
use Jiminny\Models\Team;
use Jiminny\Services\Activity\CrmOwnerResolver;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
/**
* Class JiminnyDebugCommand
*
* @package Jiminny\Console\Commands
*/
class JiminnyDebugCommand extends Command
{
public const string FREQUENCY_DAILY = 'daily';
public const string FREQUENCY_WEEKLY = 'weekly';
public const string FREQUENCY_MONTHLY = 'monthly';
public const string FREQUENCY_QUARTERLY = 'quarterly';
public const string FREQUENCY_ONE_OFF = 'one_off';
protected $signature = 'jiminny:debug';
public function handle(Jo......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84577
|
2026-04-22T11:37:33.364499+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19331683
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for RequestGenerateAskJiminnyReportJob.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Jobs\AutomatedReports;
use Carbon\Carbon;
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldBeUnique;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Contracts\Routing\UrlGenerator;
use Illuminate\Queue\InteractsWithQueue;
use Jiminny\Component\ProphetAi\Exceptions\ProphetException;
use Jiminny\Component\ProphetAi\ProphetClient;
use Jiminny\Component\Queue\Constants;
use Jiminny\Jobs\JobDispatcherInterface;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\AutomatedReportResult;
use Jiminny\Models\Team;
use Jiminny\Services\Kiosk\AutomatedReports\AskJiminnyReportActivityService;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
use Throwable;
class RequestGenerateAskJiminnyReportJob implements ShouldQueue, ShouldBeUnique
{
use InteractsWithQueue;
use Queueable;
private const string LOG_PREFIX = '[AskJiminnyReport:Generate]';
private ......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84587
|
2026-04-22T11:37:49.155485+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19347474
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for laravel.log
|
[2026-04-22 11:37:44] local.INFO: [AskJiminnyRepo
[2026-04-22 11:37:44] local.INFO: [AskJiminnyReport:Generate] Started {"automatedReportUuid":"e916569b-086c-4bd1-94d7-5e3802c27ccf"} {"correlation_id":"80ec3d57-0b9a-4ab1-9f9c-9990466e23e0","trace_id":"5c026b67-ced9-4fba-85bd-eafe4207a56b"}
[2026-04-22 11:37:45] local.ERROR: [AskJiminnyReport:Generate] Error {"automatedReportUuid":"e916569b-086c-4bd1-94d7-5e3802c27ccf","reportUuid":null,"code":0,"message":"Report not found"} {"correlation_id":"80ec3d57-0b9a-4ab1-9f9c-9990466e23e0","trace_id":"5c026b67-ced9-4fba-85bd-eafe4207a56b"}
[2026-04-22 11:37:45] local.INFO: [AskJiminnyReport:Generate] Retry scheduled {"attempts":1} {"correlation_id":"80ec3d57-0b9a-4ab1-9f9c-9990466e23e0","trace_id":"5c026b67-ced9-4fba-85bd-eafe4207a56b"}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84720
|
2026-04-22T11:45:19.511837+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19797816
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84736
|
2026-04-22T11:46:52.938320+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19891240
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84760
|
2026-04-22T11:47:36.497447+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19934798
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for JiminnyDebugCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands;
use Carbon\Carbon;
use Illuminate\Console\Command;
use InvalidArgumentException;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\SendReportMailJob;
use Jiminny\Jobs\JobDispatcherInterface;
use Jiminny\Models\Activity;
use Jiminny\Models\AutomatedReportResult;
use Jiminny\Models\Team;
use Jiminny\Services\Activity\CrmOwnerResolver;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
/**
* Class JiminnyDebugCommand
*
* @package Jiminny\Console\Commands
*/
class JiminnyDebugCommand extends Command
{
public const string FREQUENCY_DAILY = 'daily';
public const string FREQUENCY_WEEKLY = 'weekly';
public const string FREQUENCY_MONTHLY = 'monthly';
public const string FREQUENCY_QUARTERLY = 'quarterly';
public const string FREQUENCY_ONE_OFF = 'one_off';
protected $signature = 'jiminny:debug';
public function handle(Jo......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84775
|
2026-04-22T11:47:52.786152+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19951086
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84794
|
2026-04-22T11:48:37.056436+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19995355
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for AutomatedReportsCommand.php
|
<?php
declare(strict_types=1);
namespace Jimi <?php
declare(strict_types=1);
namespace Jiminny\Console\Commands\Reports;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Contracts\Bus\Dispatcher as BusDispatcher;
use Illuminate\Support\Collection;
use Jiminny\Jobs\AutomatedReports\RequestGenerateAskJiminnyReportJob;
use Jiminny\Jobs\AutomatedReports\RequestGenerateReportJob;
use Jiminny\Models\AutomatedReport;
use Jiminny\Models\Team;
use Jiminny\Repositories\AutomatedReportsRepository;
use Jiminny\Services\Kiosk\AutomatedReports\AutomatedReportsService;
use Psr\Log\LoggerInterface;
class AutomatedReportsCommand extends Command
{
/**
* Log prefix for all log messages
*/
private const string LOG_PREFIX = '[automated-reports]';
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'automated-reports
{--report-id= : Process a specific report by ID or UUID (bypasses frequency scheduling)}';
/**
* The consol......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84818
|
2026-04-22T11:49:01.507140+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
20019805
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for laravel.log
|
[2026-04-22 11:48:28] local.ERROR: Class "Jim
[2026-04-22 11:48:28] local.ERROR: Class "Jiminny\Console\Commands\AutomatedReport" not found {"exception":"[object] (Error(code: 0): Class \"Jiminny\\Console\\Commands\\AutomatedReport\" not found at /home/jiminny/app/Console/Commands/JiminnyDebugCommand.php:35)
[stacktrace]
#0 /home/jiminny/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Jiminny\\Console\\Commands\\JiminnyDebugCommand->handle(Object(Jiminny\\Jobs\\JobDispatcher), Object(Jiminny\\Services\\Kiosk\\AutomatedReports\\AutomatedReportsService))
#1 /home/jiminny/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#2 /home/jiminny/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#3 /home/jiminny/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84827
|
2026-04-22T11:49:11.016290+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
20029314
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for laravel.log
|
[2026-04-22 11:49:01] local.INFO: [Commands/Async
[2026-04-22 11:49:01] local.INFO: [Commands/AsyncUpdateEsEntities] Starting ES update worker {"pid":38932,"workerId":"","target":"activities"} {"correlation_id":"1426fc7c-a656-46c4-bdfc-17c424cb712a","trace_id":"971762c9-30b5-4778-a142-adb8978fda7c"}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84878
|
2026-04-22T11:50:46.280188+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
20124575
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|