Complex expressions

Here is the list of the most complex expressions used in the code. A complex expression is an expression that requires more than 20 tokens to be build.

Literal arrays are omitted.

File Count Expression
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23731array_merge(array(array('value' => $this->yystack[$this->yyidx + -1]->minor), array('var' => "'" . $this->yystack[$this->yyidx + -3]->minor . "'")), $this->yystack[$this->yyidx + 0]->minor)
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24581array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('from' => $this->yystack[$this->yyidx + -7]->minor), array('item' => $this->yystack[$this->yyidx + -1]->minor), array('key' => $this->yystack[$this->yyidx + -4]->minor)))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24431array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('start' => $this->yystack[$this->yyidx + -5]->minor), array('to' => $this->yystack[$this->yyidx + -3]->minor), array('step' => $this->yystack[$this->yyidx + -1]->minor)))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24281array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('start' => $this->yystack[$this->yyidx + -9]->minor), array('ifexp' => $this->yystack[$this->yyidx + -6]->minor), array('var' => $this->yystack[$this->yyidx + -2]->minor), array('step' => $this->yystack[$this->yyidx + -1]->minor)))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23781array_merge(array(array('value' => $this->yystack[$this->yyidx + -1]->minor), array('var' => $this->yystack[$this->yyidx + -3]->minor['var'])), $this->yystack[$this->yyidx + 0]->minor)
/application/Espo/Core/Authentication/Oidc/Login.php:2221curl_setopt_array($curl, [CURLOPT_URL => $endpoint, CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => self::REQUEST_TIMEOUT, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'POST', CURLOPT_POSTFIELDS => http_build_query($params), CURLOPT_HTTPHEADER => ['content-type: application/x-www-form-urlencoded'], CURLOPT_PROTOCOLS => CURLPROTO_HTTPS | CURLPROTO_HTTP, ])
/application/Espo/Core/Record/Service.php:10451$query = $this->entityManager->getQueryBuilder( )->select( )->from($this->entityType)->where(['id' => $id, ])->withDeleted( )->build( )
/application/Espo/Core/Record/Service.php:10021$query = $selectBuilder->from($this->entityType)->withStrictAccessControl( )->withSearchParams($preparedSearchParams)->withAdditionalApplierClassNameList($this->createSelectApplierClassNameListProvider( )->get($this->entityType))->build( )
/application/Espo/Core/Record/Service.php:5171$linkCheck = $this->injectableFactory->createWithBinding(LinkCheck::class, BindingContainerBuilder::create( )->bindInstance(Acl::class, $this->acl)->bindInstance(User::class, $this->user)->inContext(LinkCheck::class, function (ContextualBinder $binder) { /**/ } )->build( ))
/application/Espo/Core/Record/Service.php:3651$builder = $this->selectBuilderFactory->create( )->from($this->entityType)->withSearchParams(SearchParams::create( )->withSelect(['*'])->withPrimaryFilter(One::NAME))->withAdditionalApplierClassNameList($this->createSelectApplierClassNameListProvider( )->get($this->entityType))
/application/Espo/Core/Mail/Account/Fetcher.php:3761$builder = $this->entityManager->getRDBRepository(EmailFilter::ENTITY_TYPE)->where(['action' => $actionList, 'OR' => [['parentType' => $account->getEntityType( ), 'parentId' => $account->getId( ), 'action' => $actionList, ], ['parentId' => null, 'action' => EmailFilter::ACTION_SKIP, ], ]])
/application/Espo/Core/Mail/Account/Fetcher.php:2751$importerData = ImporterData::create( )->withTeamIdList($teamIdList)->withFilterList($filterList)->withFetchOnlyHeader($fetchOnlyHeader)->withFolderData($folderData)->withUserIdList($userIdList)->withAssignedUserId($assignedUserId)->withGroupEmailFolderId($groupEmailFolderId)
/application/Espo/Core/Mail/Importer/DefaultParentFinder.php:1641return !in_array($entityType, [Account::ENTITY_TYPE, Contact::ENTITY_TYPE, Lead::ENTITY_TYPE]) && in_array($this->metadata->get(['scopes', $entityType, 'type']), [Company::TEMPLATE_TYPE, Person::TEMPLATE_TYPE])
/application/Espo/Core/Mail/Sender.php:6741$messageId = $email->getParentType( ) && $email->getParentId( ) ? sprintf("%s/%s/%s/%s@espo", $email->getParentType( ), $email->getParentId( ), time( ), $rand) : sprintf("%s/%s/%s@espo", md5($email->get('name')), time( ), $rand)
/application/Espo/Core/Webhook/Queue.php:1251$groupedItemList = $this->entityManager->getRDBRepository(WebhookQueueItem::ENTITY_TYPE)->select(['webhookId', 'number'])->where(Cond::in(Cond::column('number'), $this->entityManager->getQueryBuilder( )->select('MIN:(number)')->from(WebhookQueueItem::ENTITY_TYPE)->where(['status' => WebhookQueueItem::STATUS_PENDING, 'OR' => [['processAt' => null], ['processAt<=' => DateTimeUtil::getSystemNowString( )], ], ])->group('webhookId')->build( )))->limit(0, $portionSize)->order('number')->find( )
/application/Espo/Core/Webhook/Queue.php:991$webhookList = $this->entityManager->getRDBRepository(Webhook::ENTITY_TYPE)->where(['event' => $item->get('event'), 'isActive' => true, ])->order('createdAt')->find( )
/application/Espo/Core/ApplicationUser.php:561$user = $this->entityManagerProxy->getRDBRepository(User::ENTITY_TYPE)->select(['id', 'name', 'userName', 'type', 'isActive', 'firstName', 'lastName', 'deleted', ])->where(['userName' => SystemUser::NAME])->findOne( )
/application/Espo/Tools/GlobalSearch/Service.php:1891$queryBuilder = $this->entityManager->getQueryBuilder( )->select( )->clone($query)->limit(0, $offset + $maxSize + 1)->select($selectList)->order([ ])
/application/Espo/Core/Portal/Loaders/Language.php:492return $this->injectableFactory->createWith(LanguageService::class, ['language' => LanguageService::detectLanguage($this->config, $this->preferences), 'useCache' => $this->config->get('useCache') ?? false, ])
/application/Espo/Core/Webhook/Manager.php:1061$list = $this->entityManager->getRDBRepository(Webhook::ENTITY_TYPE)->select(['event'])->group(['event'])->where(['isActive' => true, 'event!=' => null, ])->find( )
/application/Espo/Core/Webhook/Queue.php:3371$itemList = $this->entityManager->getRDBRepository(WebhookQueueItem::ENTITY_TYPE)->where(['status' => WebhookQueueItem::STATUS_PENDING, 'webhookId' => $webhook->getId( ), ])->order('number')->find( )
/application/Espo/Core/Webhook/Queue.php:1591$itemList = $this->entityManager->getRDBRepository(WebhookQueueItem::ENTITY_TYPE)->where(['webhookId' => $webhookId, 'status' => WebhookQueueItem::STATUS_PENDING, 'OR' => [['processAt' => null], ['processAt<=' => DateTimeUtil::getSystemNowString( )], ], ])->order('number')->limit(0, $batchSize)->find( )
/application/Espo/Tools/Email/InboxService.php:3521$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['isImportant' => false])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( )
/application/Espo/Tools/Email/InboxService.php:3711$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['isRead' => true])->where(['deleted' => false, 'userId' => $userId, 'isRead' => false, ])->build( )
/application/Espo/Tools/Email/InboxService.php:2941$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['isRead' => false])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( )
/application/Espo/Tools/Email/InboxService.php:3331$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['isImportant' => true])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( )
/application/Espo/Tools/Email/InboxService.php:4571$groupFolderList = $this->entityManager->getRDBRepositoryByClass(GroupEmailFolder::class)->distinct( )->leftJoin('teams')->where($this->user->isAdmin( ) ? ['id!=' => null] : ['teams.id' => $this->user->getTeamIdList( )])->find( )
/application/Espo/Tools/Email/AddressService.php:3261$list = $this->entityManager->getRDBRepository(InboundEmail::ENTITY_TYPE)->select(['id', 'name', 'emailAddress', ])->where(['emailAddress*' => $query . '%', ])->order('name')->find( )
/application/Espo/Tools/Email/InboxService.php:3851$update = $this->entityManager->getQueryBuilder( )->update( )->in(Notification::ENTITY_TYPE)->set(['read' => true])->where(['deleted' => false, 'userId' => $userId, 'relatedType' => Email::ENTITY_TYPE, 'read' => false, 'type' => Notification::TYPE_EMAIL_RECEIVED, ])->build( )
/application/Espo/Tools/Email/InboxService.php:4051$update = $this->entityManager->getQueryBuilder( )->update( )->in(Notification::ENTITY_TYPE)->set(['read' => true])->where(['deleted' => false, 'userId' => $userId, 'relatedType' => Email::ENTITY_TYPE, 'relatedId' => $id, 'read' => false, 'type' => Notification::TYPE_EMAIL_RECEIVED, ])->build( )
/application/Espo/Tools/WorkingTime/TeamCalendar.php:2183$collection = $this->entityManager->getRDBRepositoryByClass(WorkingTimeRange::class)->leftJoin('calendars')->where(Condition::equal(Expression::column('calendars.id'), $this->workingTimeCalendar->getId( )))->where(OrGroup::create(Condition::greaterOrEqual(Expression::column('dateEnd'), $from->toString( )), Condition::lessOrEqual(Expression::column('dateStart'), $to->toString( )), ))->find( )
/application/Espo/Tools/Email/EmailAddressEntityPair.php:611return (object) ['emailAddress' => $this->emailAddress->getAddress( ), 'name' => $this->entity->get('name'), 'entityId' => $this->entity->getId( ), 'entityType' => $this->entity->getEntityType( ), ]
/application/Espo/Tools/WorkingTime/GlobalCalendar.php:1973$collection = $this->entityManager->getRDBRepositoryByClass(WorkingTimeRange::class)->leftJoin('calendars')->where(Condition::equal(Expression::column('calendars.id'), $this->workingTimeCalendar->getId( )))->where(OrGroup::create(Condition::greaterOrEqual(Expression::column('dateEnd'), $from->toString( )), Condition::lessOrEqual(Expression::column('dateStart'), $to->toString( )), ))->find( )
/application/Espo/Tools/WorkingTime/Extractor.php:3811$list[] = [DateTime::fromDateTime($pointer->setTime($start->getHour( ), $start->getMinute( ))), DateTime::fromDateTime($pointer->setTime($end->getHour( ), $end->getMinute( )))]
/application/Espo/Tools/Email/InboxService.php:2341$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['inTrash' => false])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( )
/application/Espo/Tools/Email/InboxService.php:2731$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['isRead' => true])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( )
/application/Espo/Tools/Email/InboxService.php:1401$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['folderId' => $folderId, 'inTrash' => false, ])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( )
/application/Espo/Tools/Email/InboxService.php:2131$update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['inTrash' => true])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( )
/application/Espo/Tools/Import/Import.php:3851return Result::create( )->withId($import->getId( ))->withCountCreated(count($result->importedIds))->withCountUpdated(count($result->updatedIds))->withCountDuplicate(count($result->duplicateIds))->withCountError(count($result->errorIndexes))
/application/Espo/Tools/Import/Params.php:3711return ['action' => $this->action, 'currency' => $this->currency, 'dateFormat' => $this->dateFormat, 'decimalMark' => $this->decimalMark, 'defaultValues' => $this->defaultValues, 'delimiter' => $this->delimiter, 'headerRow' => $this->headerRow, 'idleMode' => $this->idleMode, 'manualMode' => $this->manualMode, 'personNameFormat' => $this->personNameFormat, 'silentMode' => $this->silentMode, 'skipDuplicateChecking' => $this->skipDuplicateChecking, 'startFromLastIndex' => $this->startFromLastIndex, 'textQualifier' => $this->textQualifier, 'phoneNumberCountry' => $this->phoneNumberCountry, 'timeFormat' => $this->timeFormat, 'timezone' => $this->timezone, 'updateBy' => $this->updateBy, ]
/application/Espo/Tools/Import/Service.php:2191$importEntityList = $this->entityManager->getRDBRepository(ImportEntityEntity::ENTITY_TYPE)->sth( )->where(['importId' => $import->getId( ), 'isImported' => true, ])->find( )
/application/Espo/Tools/Import/Service.php:1891return $this->factory->create( )->setEntityType($entityType)->setAttributeList($attributeList)->setAttachmentId($attachmentId)->setParams($params)->setId($id)->run( )
/application/Espo/Tools/Import/Service.php:4961$errorList = $this->entityManager->getRDBRepositoryByClass(ImportEntity::class)->getRelation($import, 'errors')->sth( )->select(['exportRowIndex', 'rowIndex'])->order('rowIndex')->find( )
/application/Espo/Tools/Import/Service.php:3711$importEntityList = $this->entityManager->getRDBRepository(ImportEntityEntity::ENTITY_TYPE)->sth( )->where(['importId' => $import->getId( ), 'isDuplicate' => true, ])->find( )
/application/Espo/Tools/WorkingTime/UserCalendar.php:3023$collection = $this->entityManager->getRDBRepositoryByClass(WorkingTimeRange::class)->leftJoin('calendars')->where(Condition::equal(Expression::column('calendars.id'), $this->workingTimeCalendar->getId( )))->where(OrGroup::create(Condition::greaterOrEqual(Expression::column('dateEnd'), $from->toString( )), Condition::lessOrEqual(Expression::column('dateStart'), $to->toString( )), ))->find( )
/application/Espo/Tools/WorkingTime/UserCalendar.php:2611$collection = $this->entityManager->getRDBRepositoryByClass(WorkingTimeRange::class)->leftJoin('users')->where(Condition::equal(Expression::column('users.id'), $this->user->getId( )))->where(OrGroup::create(Condition::greaterOrEqual(Expression::column('dateEnd'), $from->toString( )), Condition::lessOrEqual(Expression::column('dateStart'), $to->toString( )), ))->find( )
/application/Espo/Tools/UserSecurity/Password/Service.php:1811$u = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->where(['id' => $user->getId( ), 'password' => $this->passwordHash->hash($currentPassword ?? ''), ])->findOne( )
/application/Espo/Tools/UserSecurity/Password/RecoveryService.php:4641$smtpParams = SmtpParams::create($server, $port)->withAuth($this->config->get('internalSmtpAuth'))->withUsername($this->config->get('internalSmtpUsername'))->withPassword($this->config->get('internalSmtpPassword'))->withSecurity($this->config->get('internalSmtpSecurity'))->withFromName($this->config->get('outboundEmailFromName'))
/application/Espo/Tools/ExportCustom/ExportCustom.php:2381$defs = (object) ['name' => $params->getName( ), 'version' => $params->getVersion( ), 'author' => $params->getAuthor( ), 'skipBackup' => true, 'releaseDate' => DateTime::getSystemTodayString( ), 'description' => $params->getDescription( ), 'acceptableVersions' => ['>=' . $this->minVersion]]
/application/Espo/Tools/UserSecurity/Password/Sender.php:1691$portalList = $this->entityManager->getRDBRepositoryByClass(Portal::class)->distinct( )->join('users')->where(['isActive' => true, 'users.id' => $user->getId( ), ])->find( )
/application/Espo/Tools/Export/Format/Xlsx/OpenSpoutProcessor.php:1442$label = $this->language->translateLabel($fieldData->getLink( ), 'links', $entityType) . '.' . $this->language->translateLabel($fieldData->getField( ), 'fields', $fieldData->getEntityType( ))
/application/Espo/Tools/Export/Export.php:2921$builder = $this->selectBuilderFactory->create( )->forUser($this->user)->from($entityType)->withAdditionalApplierClassNameList($this->applierClassNameListProvider->get($entityType))->withSearchParams($searchParams)
/application/Espo/Tools/Import/Params.php:3451return self::create( )->withAction($raw->action ?? null)->withCurrency($raw->currency ?? null)->withDateFormat($raw->dateFormat ?? null)->withDecimalMark($raw->decimalMark ?? null)->withDefaultValues($raw->defaultValues ?? null)->withDelimiter($raw->delimiter ?? null)->withHeaderRow($raw->headerRow ?? false)->withIdleMode($raw->idleMode ?? false)->withManualMode($raw->manualMode ?? false)->withPersonNameFormat($raw->personNameFormat ?? null)->withPhoneNumberCountry($raw->phoneNumberCountry ?? null)->withSilentMode($raw->silentMode ?? false)->withSkipDuplicateChecking($raw->skipDuplicateChecking ?? false)->withStartFromLastIndex($raw->startFromLastIndex ?? false)->withTextQualifier($raw->textQualifier ?? null)->withTimeFormat($raw->timeFormat ?? false)->withTimezone($raw->timezone ?? null)->withUpdateBy($raw->updateBy ?? [ ])
/application/Espo/Tools/Export/Format/Xlsx/PhpSpreadsheetProcessor.php:3062$label = $this->language->translateLabel($fieldData->getLink( ), 'links', $entityType) . '.' . $this->language->translateLabel($fieldData->getField( ), 'fields', $fieldData->getEntityType( ))
/application/Espo/Tools/Kanban/Kanban.php:1961$itemQuery = $this->entityManager->getQueryBuilder( )->select( )->clone($itemQuery)->order($newOrder)->leftJoin('KanbanOrder', 'kanbanOrder', ['kanbanOrder.entityType' => $this->entityType, 'kanbanOrder.entityId:' => 'id', 'kanbanOrder.group' => $group, 'kanbanOrder.userId' => $this->userId, ])->build( )
/application/Espo/Tools/Kanban/KanbanService.php:721return $this->createKanban( )->setEntityType($entityType)->setSearchParams($searchParams)->setCountDisabled($disableCount)->setOrderDisabled($orderDisabled)->setUserId($this->user->getId( ))->setMaxOrderNumber($maxOrderNumber)->getResult( )
/application/Espo/Tools/Kanban/OrdererProcessor.php:1071$deleteQuery1 = $this->entityManager->getQueryBuilder( )->delete( )->from(KanbanOrder::ENTITY_TYPE)->where(['entityType' => $this->entityType, 'userId' => $this->userId, 'entityId' => $ids, ])->build( )
/application/Espo/Tools/Kanban/OrdererProcessor.php:1221$first = $this->entityManager->getRDBRepository(KanbanOrder::ENTITY_TYPE)->select(['id', 'order'])->where(['entityType' => $this->entityType, 'userId' => $this->userId, 'group' => $this->group, ])->order('order')->findOne( )
/application/Espo/Tools/Kanban/OrdererProcessor.php:1401$updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in(KanbanOrder::ENTITY_TYPE)->where(['entityType' => $this->entityType, 'group' => $this->group, 'userId' => $this->userId, ])->set(['order:' => 'ADD:(order, ' . strval($offset) . ')'])->build( )
/application/Espo/Tools/Kanban/OrdererProcessor.php:1781$deleteQuery2 = $this->entityManager->getQueryBuilder( )->delete( )->from(KanbanOrder::ENTITY_TYPE)->where(['entityType' => $this->entityType, 'group' => $this->group, 'userId' => $this->userId, 'order>' => $this->maxNumber, ])->build( )
/application/Espo/Tools/UserSecurity/Service.php:1221$allow = $this->config->get('auth2FA') && ($user->isAdmin( ) || $user->isRegular( ) || $user->isPortal( ) && $this->config->get('auth2FAInPortal'))
/application/Espo/Tools/UserSecurity/Password/RecoveryService.php:4131$portal = $this->entityManager->getRDBRepository(Portal::ENTITY_TYPE)->distinct( )->join('users')->where(['isActive' => true, 'users.id' => $user->getId( ), ])->findOne( )
/application/Espo/Tools/EntityManager/Rename/Renamer.php:5481$query2 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityEmailAddress')->set(['entityType' => $to])->where(['entityType' => $from])->build( )
/application/Espo/Tools/EntityManager/Rename/Renamer.php:5581$query3 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityPhoneNumber')->set(['entityType' => $to])->where(['entityType' => $from])->build( )
/application/Espo/Tools/EntityManager/Rename/Renamer.php:6051$query = $this->entityManager->getQueryBuilder( )->update( )->in($entityType)->set([$typeAttribute => $to])->where([$typeAttribute => $from])->build( )
/application/Espo/Tools/EmailTemplate/Processor.php:2491$forbiddenAttributeList = array_merge($this->aclManager->getScopeForbiddenAttributeList($user, $entity->getEntityType( )), $this->aclManager->getScopeRestrictedAttributeList($entity->getEntityType( ), [GlobalRestriction::TYPE_FORBIDDEN, GlobalRestriction::TYPE_INTERNAL, GlobalRestriction::TYPE_ONLY_ADMIN, ]))
/application/Espo/Tools/EmailTemplate/Api/PostPrepare.php:571$data = Data::create( )->withRelatedType($body->relatedType ?? null)->withRelatedId($body->relatedId ?? null)->withParentType($body->parentType ?? null)->withParentId($body->parentId ?? null)->withEmailAddress($body->emailAddress ?? null)
/application/Espo/Tools/EmailFolder/Service.php:1061$groupFolderList = $this->entityManager->getRDBRepositoryByClass(GroupEmailFolder::class)->distinct( )->leftJoin('teams')->where($user->isAdmin( ) ? ['id!=' => null] : ['teams.id' => $user->getTeamIdList( )])->order('order')->limit(0, $limit)->find( )
/application/Espo/Tools/EmailFolder/Service.php:1861$previousEntity = $this->entityManager->getRDBRepositoryByClass(EmailFolder::class)->where(['order<' => $currentIndex, 'assignedUserId' => $entity->get('assignedUserId'), ])->order('order', true)->findOne( )
/application/Espo/Tools/EmailFolder/Service.php:2291$nextEntity = $this->entityManager->getRDBRepositoryByClass(EmailFolder::class)->where(['order>' => $currentIndex, 'assignedUserId' => $entity->get('assignedUserId'), ])->order('order', false)->findOne( )
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Currency.php:1231$expr = Expr::multiply(Expr::column($name), Expr::if(Expr::equal(Expr::column($currencyAttribute), $defaultCurrency), 1.0, $this->buildExpression($currencyAttribute, $rates)))->getValue( )
/application/Espo/Core/Utils/Database/Orm/FieldConverters/LinkOne.php:441return EntityDefs::create( )->withAttribute(AttributeDefs::create($name . 'Id')->withType(AttributeType::VARCHAR)->withNotStorable( )->withParamsMerged(['attributeRole' => 'id', 'fieldType' => 'linkOne', ]))->withAttribute(AttributeDefs::create($name . 'Name')->withType(AttributeType::VARCHAR)->withNotStorable( )->withParamsMerged(['attributeRole' => 'name', 'fieldType' => 'linkOne', ]))
/application/Espo/Core/Utils/Database/Orm/FieldConverters/AttachmentMultiple.php:451return EntityDefs::create( )->withAttribute(AttributeDefs::create($name . 'Ids')->withType(AttributeType::JSON_ARRAY)->withNotStorable( )->withParamsMerged(['orderBy' => [['createdAt', Order::ASC], ['name', Order::ASC], ], 'isLinkMultipleIdList' => true, 'relation' => $name, ]))->withAttribute(AttributeDefs::create($name . 'Names')->withType(AttributeType::JSON_OBJECT)->withNotStorable( )->withParamsMerged(['isLinkMultipleNameMap' => true, ]))
/application/Espo/Core/Utils/Database/Orm/FieldConverters/LinkParent.php:681$nameDefs = AttributeDefs::create($nameName)->withType(AttributeType::VARCHAR)->withNotStorable( )->withParamsMerged(['relation' => $name, 'isParentName' => true, 'attributeRole' => 'name', 'fieldType' => 'linkParent', ])
/application/Espo/Core/Utils/Database/Orm/FieldConverters/LinkMultiple.php:481$idsDefs = AttributeDefs::create($idsName)->withType(AttributeType::JSON_ARRAY)->withNotStorable( )->withParamsMerged(['isLinkMultipleIdList' => true, 'relation' => $name, 'isUnordered' => true, 'attributeRole' => 'idList', 'fieldType' => 'linkMultiple', ])
/application/Espo/Core/Utils/Database/Orm/FieldConverters/LinkParent.php:581$typeDefs = AttributeDefs::create($typeName)->withType(AttributeType::FOREIGN_TYPE)->withParam('notNull', false)->withParam('index', $name)->withLength(self::TYPE_LENGTH)->withParamsMerged(['attributeRole' => 'type', 'fieldType' => 'linkParent', ])
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Email.php:2601return ['select' => ['select' => "emailAddresses.optOut", 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], ], 'selectForeign' => ['select' => "$foreignJoinAlias.optOut", 'leftJoins' => [['EntityEmailAddress', $foreignJoinMiddleAlias, ["$foreignJoinMiddleAlias.entityId:" => "{alias}.id", "$foreignJoinMiddleAlias.primary" => true, "$foreignJoinMiddleAlias.deleted" => false, ]], [EmailAddress::ENTITY_TYPE, $foreignJoinAlias, ["$foreignJoinAlias.id:" => "$foreignJoinMiddleAlias.emailAddressId", "$foreignJoinAlias.deleted" => false, ]]], ], 'where' => ['= TRUE' => ['whereClause' => [['emailAddresses.optOut=' => true], ['emailAddresses.optOut!=' => null], ], 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], ], '= FALSE' => ['whereClause' => ['OR' => [['emailAddresses.optOut=' => false], ['emailAddresses.optOut=' => null], ]], 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], ]], 'order' => ['order' => [['emailAddresses.optOut', '{direction}'], ], 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], 'additionalSelect' => ['emailAddresses.optOut'], ], ]
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Email.php:3201return ['select' => ['select' => "emailAddresses.invalid", 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], ], 'selectForeign' => ['select' => "$foreignJoinAlias.invalid", 'leftJoins' => [['EntityEmailAddress', $foreignJoinMiddleAlias, ["$foreignJoinMiddleAlias.entityId:" => "{alias}.id", "$foreignJoinMiddleAlias.primary" => true, "$foreignJoinMiddleAlias.deleted" => false, ]], [EmailAddress::ENTITY_TYPE, $foreignJoinAlias, ["$foreignJoinAlias.id:" => "$foreignJoinMiddleAlias.emailAddressId", "$foreignJoinAlias.deleted" => false, ]]], ], 'where' => ['= TRUE' => ['whereClause' => [['emailAddresses.invalid=' => true], ['emailAddresses.invalid!=' => null], ], 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], ], '= FALSE' => ['whereClause' => ['OR' => [['emailAddresses.invalid=' => false], ['emailAddresses.invalid=' => null], ]], 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], ]], 'order' => ['order' => [['emailAddresses.invalid', '{direction}'], ], 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], 'additionalSelect' => ['emailAddresses.invalid'], ], ]
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Email.php:851$relationDefs = RelationDefs::create('emailAddresses')->withType(RelationType::MANY_MANY)->withForeignEntityType(EmailAddress::ENTITY_TYPE)->withRelationshipName('entityEmailAddress')->withMidKeys('entityId', 'emailAddressId')->withConditions(['entityType' => $entityType])->withAdditionalColumn(AttributeDefs::create('entityType')->withType(AttributeType::VARCHAR)->withLength(self::COLUMN_ENTITY_TYPE_LENGTH))->withAdditionalColumn(AttributeDefs::create('primary')->withType(AttributeType::BOOL)->withDefault(false))
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Email.php:1221return ['select' => ["select" => "emailAddresses.name", 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], ], 'selectForeign' => ["select" => "$foreignJoinAlias.name", 'leftJoins' => [['EntityEmailAddress', $foreignJoinMiddleAlias, ["$foreignJoinMiddleAlias.entityId:" => "{alias}.id", "$foreignJoinMiddleAlias.primary" => true, "$foreignJoinMiddleAlias.deleted" => false, ]], [EmailAddress::ENTITY_TYPE, $foreignJoinAlias, ["$foreignJoinAlias.id:" => "$foreignJoinMiddleAlias.emailAddressId", "$foreignJoinAlias.deleted" => false, ]]], ], 'fieldType' => 'email', 'where' => ['LIKE' => ['whereClause' => ['id=s' => ['from' => 'EntityEmailAddress', 'select' => ['entityId'], 'joins' => [['emailAddress', 'emailAddress', ['emailAddress.id:' => 'emailAddressId', 'emailAddress.deleted' => false, ], ]], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, 'emailAddress.lower*' => '{value}', ], ], ], ], 'NOT LIKE' => ['whereClause' => ['id!=s' => ['from' => 'EntityEmailAddress', 'select' => ['entityId'], 'joins' => [['emailAddress', 'emailAddress', ['emailAddress.id:' => 'emailAddressId', 'emailAddress.deleted' => false, ], ]], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, 'emailAddress.lower*' => '{value}', ], ], ], ], '=' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ['emailAddressesMultiple.lower=' => '{value}', ], 'distinct' => true, ], '<>' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ['emailAddressesMultiple.lower!=' => '{value}', ], 'distinct' => true, ], 'IN' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ['emailAddressesMultiple.lower=' => '{value}', ], 'distinct' => true, ], 'NOT IN' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ['emailAddressesMultiple.lower!=' => '{value}', ], 'distinct' => true, ], 'IS NULL' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ['emailAddressesMultiple.lower=' => null, ], 'distinct' => true, ], 'IS NOT NULL' => ['whereClause' => ['id=s' => ['from' => 'EntityEmailAddress', 'select' => ['entityId'], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, ], ], ], ], ], 'order' => ['order' => [['emailAddresses.lower', '{direction}'], ], 'leftJoins' => [['emailAddresses', 'emailAddresses', ['primary' => true]]], 'additionalSelect' => ['emailAddresses.lower'], ], ]
/application/Espo/Core/Utils/Database/Orm/LinkConverters/HasMany.php:731return EntityDefs::create( )->withAttribute(AttributeDefs::create($name . 'Ids')->withType(AttributeType::JSON_ARRAY)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withAttribute(AttributeDefs::create($name . 'Names')->withType(AttributeType::JSON_OBJECT)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withRelation(RelationDefs::create($name)->withType($type)->withForeignEntityType($foreignEntityType)->withForeignKey($foreignRelationName . 'Id')->withForeignRelationName($foreignRelationName))
/application/Espo/Core/Utils/Database/Orm/LinkConverters/HasOne.php:601$nameAttributeDefs = !$noForeignName ? (AttributeDefs::create($nameName)->withType($noJoin ? AttributeType::VARCHAR : AttributeType::FOREIGN)->withNotStorable( )->withParam('relation', $name)->withParam('foreign', $foreignName)) : null
/application/Espo/Core/Utils/Database/Orm/LinkConverters/EntityUser.php:501return EntityDefs::create( )->withRelation(RelationDefs::create($name)->withType(RelationType::MANY_MANY)->withForeignEntityType(User::ENTITY_TYPE)->withRelationshipName($relationshipName)->withMidKeys('entityId', 'userId')->withConditions(['entityType' => $entityType])->withAdditionalColumn(AttributeDefs::create('entityType')->withType(AttributeType::VARCHAR)->withLength(self::ENTITY_TYPE_LENGTH)))
/application/Espo/Core/Utils/Database/Orm/LinkConverters/HasChildren.php:563return EntityDefs::create( )->withAttribute(AttributeDefs::create($name . 'Ids')->withType(AttributeType::JSON_ARRAY)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withAttribute(AttributeDefs::create($name . 'Names')->withType(AttributeType::JSON_OBJECT)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withRelation($relationDefs)
/application/Espo/Core/Utils/Database/Orm/LinkConverters/EmailEmailAddress.php:623return EntityDefs::create( )->withAttribute(AttributeDefs::create($name . 'Ids')->withType(AttributeType::JSON_ARRAY)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withAttribute(AttributeDefs::create($name . 'Names')->withType(AttributeType::JSON_OBJECT)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withRelation($relationDefs)
/application/Espo/Core/Utils/Database/Orm/LinkConverters/SmsPhoneNumber.php:601return EntityDefs::create( )->withAttribute(AttributeDefs::create($name . 'Ids')->withType(AttributeType::JSON_ARRAY)->withNotStorable( ))->withAttribute(AttributeDefs::create($name . 'Names')->withType(AttributeType::JSON_OBJECT)->withNotStorable( ))->withRelation($relationDefs)
/application/Espo/Core/Utils/Database/Orm/LinkConverters/BelongsToParent.php:601return EntityDefs::create( )->withAttribute(AttributeDefs::create($idName)->withType(AttributeType::FOREIGN_ID)->withParam('index', $name))->withAttribute(AttributeDefs::create($typeName)->withType(AttributeType::FOREIGN_TYPE)->withParam('notNull', false)->withParam('index', $name)->withLength(self::TYPE_LENGTH))->withAttribute(AttributeDefs::create($nameName)->withType(AttributeType::VARCHAR)->withNotStorable( ))->withRelation($relationDefs)
/application/Espo/Core/Utils/Database/Orm/LinkConverters/EntityTeam.php:501return EntityDefs::create( )->withRelation(RelationDefs::create($name)->withType(RelationType::MANY_MANY)->withForeignEntityType(Team::ENTITY_TYPE)->withRelationshipName($relationshipName)->withMidKeys('entityId', 'teamId')->withConditions(['entityType' => $entityType])->withAdditionalColumn(AttributeDefs::create('entityType')->withType(AttributeType::VARCHAR)->withLength(self::ENTITY_TYPE_LENGTH)))
/application/Espo/Core/Utils/Database/Orm/LinkConverters/HasChildren.php:491$relationDefs = RelationDefs::create($name)->withType(RelationType::HAS_CHILDREN)->withForeignEntityType($foreignEntityType)->withForeignKey($foreignRelationName . 'Id')->withParam('foreignType', $foreignRelationName . 'Type')->withForeignRelationName($foreignRelationName)
/application/Espo/Core/Utils/Database/Orm/LinkConverters/BelongsTo.php:661$nameAttributeDefs = !$noForeignName ? ($noJoin ? AttributeDefs::create($nameName)->withType(AttributeType::VARCHAR)->withNotStorable( )->withParam('relation', $name)->withParam('foreign', $foreignName) : AttributeDefs::create($nameName)->withType(AttributeType::FOREIGN)->withNotStorable(true)->withParam('relation', $name)->withParam('foreign', $foreignName)) : null
/application/Espo/Core/Utils/Database/Orm/Converter.php:9381return ['type' => $indexDefs->isUnique( ) ? self::INDEX_TYPE_UNIQUE : self::INDEX_TYPE_INDEX, 'columns' => $indexDefs->getColumnList( ), 'flags' => $indexDefs->getFlagList( ), 'key' => $indexDefs->getKey( ), ]
/application/Espo/Core/Utils/Database/Orm/Converter.php:4561$toUnset = !in_array('', $this->metadata->get(['fields', $type, 'actualFields']) ?? [ ]) && !in_array('', $this->metadata->get(['fields', $type, 'notActualFields']) ?? [ ])
/application/Espo/Core/Utils/Database/Orm/LinkConverters/ManyMany.php:773return EntityDefs::create( )->withAttribute(AttributeDefs::create($name . 'Ids')->withType(AttributeType::JSON_ARRAY)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withAttribute(AttributeDefs::create($name . 'Names')->withType(AttributeType::JSON_OBJECT)->withNotStorable( )->withParam('isLinkStub', !$hasField))->withRelation($relationDefs)
/application/Espo/Core/Utils/Database/Orm/LinkConverters/ManyMany.php:641$relationDefs = RelationDefs::create($name)->withType(RelationType::MANY_MANY)->withForeignEntityType($foreignEntityType)->withRelationshipName($relationshipName)->withKey('id')->withForeignKey('id')->withMidKeys($key1, $key2)->withForeignRelationName($foreignRelationName)
/application/Espo/Core/Utils/ScheduledJob.php:1081$data = ['PHP-BINARY' => $this->systemUtil->getPhpBinary( ), 'CRON-FILE' => $this->cronFile, 'DOCUMENT_ROOT' => $this->systemUtil->getRootDir( ), 'FULL-CRON-PATH' => Util::concatPath($this->systemUtil->getRootDir( ), $this->cronFile), ]
/application/Espo/Core/Utils/EmailFilterManager.php:1051$collection = $this->entityManager->getRDBRepository(EmailFilter::ENTITY_TYPE)->where(['parentId' => $userId, 'parentType' => User::ENTITY_TYPE, ])->order(Order::createByPositionInList(Expression::column('action'), [EmailFilter::ACTION_SKIP, EmailFilter::ACTION_MOVE_TO_FOLDER, EmailFilter::ACTION_NONE, ]))->find( )
/application/Espo/Core/Utils/Database/Orm/Converter.php:3731$output = ['id' => ['type' => Entity::ID, ], 'name' => ['type' => $entityMetadata['fields']['name']['type'] ?? Entity::VARCHAR, 'notStorable' => true, ], 'deleted' => ['type' => Entity::BOOL, 'default' => false, ], ]
/application/Espo/Core/Utils/ScheduledJob.php:1481$selectParams = ['select' => ['id'], 'leftJoins' => ['scheduledJob'], 'whereClause' => ['OR' => [[['executedAt>=' => $r2From->format($format)], ['executedAt<=' => $r2To->format($format)], ], [['executeTime>=' => $r1From->format($format)], ['executeTime<=' => $r1To->format($format)], 'scheduledJob.job' => 'Dummy', ]]]]
/application/Espo/Core/Mail/Event/EventFactory.php:581return Event::create( )->withUid($event->uid ?? null)->withIsAllDay($isAllDay)->withDateStart($dateStart)->withDateEnd($dateEnd)->withName($event->summary ?? null)->withLocation($event->location ?? null)->withDescription($event->description ?? null)->withTimezone($ical->calendarTimeZone( ) ?? null)->withOrganizer($event->organizer ?? null)->withAttendees($event->attendee ?? null)
/application/Espo/Core/FieldValidation/Exceptions/ValidationError.php:641$exception = self::createWithBody('validationFailure', Body::create( )->withMessageTranslation('validationFailure', null, ['field' => $failure->getField( ), 'type' => $failure->getType( ), ])->encode( ))
/application/Espo/Core/Utils/ClientManager.php:1921$data = ['applicationId' => 'espocrm-application-id', 'apiUrl' => $this->apiUrl, 'applicationName' => $this->config->get('applicationName', 'EspoCRM'), 'cacheTimestamp' => $cacheTimestamp, 'appTimestamp' => $appTimestamp, 'loaderCacheTimestamp' => Json::encode($loaderCacheTimestamp), 'stylesheet' => $this->themeManager->getStylesheet( ), 'runScript' => $runScript, 'basePath' => $this->basePath, 'useCache' => $useCache ? 'true' : 'false', 'appClientClassName' => 'app', 'scriptsHtml' => $scriptsHtml, 'additionalStyleSheetsHtml' => $additionalStyleSheetsHtml, 'linksHtml' => $linksHtml, 'favicon196Path' => $favicon196Path, 'faviconPath' => $faviconPath, 'ajaxTimeout' => $this->config->get('ajaxTimeout') ?? 60000, 'internalModuleList' => Json::encode($internalModuleList), 'bundledModuleList' => Json::encode($this->getBundledModuleList( )), 'applicationDescription' => $this->config->get('applicationDescription') ?? self::APP_DESCRIPTION, 'nonce' => $this->nonce, 'loaderParams' => Json::encode(['basePath' => $this->basePath, 'cacheTimestamp' => $loaderCacheTimestamp, 'internalModuleList' => $internalModuleList, 'transpiledModuleList' => $this->getTranspiledModuleList( ), 'libsConfig' => $this->loaderParamsProvider->getLibsConfig( ), 'aliasMap' => $this->loaderParamsProvider->getAliasMap( ), ]), ]
/application/Espo/Core/Utils/AdminNotificationManager.php:1761$extension = $this->entityManager->getRDBRepository('Extension')->select(['version'])->where(['name' => $extensionName, 'isInstalled' => true, ])->order('createdAt', true)->findOne( )
/application/Espo/Core/Mail/Account/GroupAccount/Hooks/AfterFetch.php:2131$sentCount = $this->entityManager->getRDBRepository(Email::ENTITY_TYPE)->where(['toEmailAddresses.id' => $emailAddress->getId( ), 'dateSent>' => $threshold, 'status' => Email::STATUS_SENT, 'createdById' => $this->systemUser->getId( ), ])->join('toEmailAddresses')->count( )
/application/Espo/Core/Mail/Account/GroupAccount/Hooks/AfterFetch.php:4091$params = ['caseDistribution' => $inboundEmail->getCaseDistribution( ), 'teamId' => $inboundEmail->get('teamId'), 'userId' => $inboundEmail->get('assignToUserId'), 'targetUserPosition' => $inboundEmail->getTargetUserPosition( ), 'inboundEmailId' => $inboundEmail->getId( ), ]
/application/Espo/Core/Mail/Account/PersonalAccount/StorageFactory.php:741$params = Params::createBuilder( )->setHost($imapParams->getHost( ))->setPort($imapParams->getPort( ))->setSecurity($imapParams->getSecurity( ))->setUsername($imapParams->getUsername( ))->setPassword($imapParams->getPassword( ))->setEmailAddress($account->getEmailAddress( ))->setUserId($userId)->setId($account->getId( ))->setImapHandlerClassName($account->getImapHandlerClassName( ))->build( )
/application/Espo/Core/Mail/Account/PersonalAccount/StorageFactory.php:911$rawParams = ['host' => $params->getHost( ), 'port' => $params->getPort( ), 'username' => $params->getUsername( ), 'password' => $params->getPassword( ), 'emailAddress' => $params->getEmailAddress( ), 'userId' => $params->getUserId( ), 'imapHandler' => $params->getImapHandlerClassName( ), 'id' => $params->getId( ), ]
/application/Espo/Core/Mail/Account/SendingAccountProvider.php:2301$entity = $this->entityManager->getRDBRepositoryByClass(InboundEmailEntity::class)->where(['status' => InboundEmailEntity::STATUS_ACTIVE, 'useSmtp' => true, ])->where(Condition::equal(Expression::lowerCase(Expression::column('emailAddress')), strtolower($address)))->findOne( )
/application/Espo/Core/Mail/Account/GroupAccount/Account.php:1081$userList = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id'])->distinct( )->join('teams')->where(['isActive' => true, 'teamsMiddle.teamId' => $this->entity->getTeams( )->getIdList( ), ])->find( )
/application/Espo/Core/Mail/Account/GroupAccount/StorageFactory.php:611$params = Params::createBuilder( )->setHost($imapParams->getHost( ))->setPort($imapParams->getPort( ))->setSecurity($imapParams->getSecurity( ))->setUsername($imapParams->getUsername( ))->setPassword($imapParams->getPassword( ))->setId($account->getId( ))->setImapHandlerClassName($account->getImapHandlerClassName( ))->build( )
/application/Espo/Core/Mail/Account/GroupAccount/StorageFactory.php:761$rawParams = ['host' => $params->getHost( ), 'port' => $params->getPort( ), 'username' => $params->getUsername( ), 'password' => $params->getPassword( ), 'imapHandler' => $params->getImapHandlerClassName( ), 'id' => $params->getId( ), ]
/application/Espo/Core/Mail/Account/SendingAccountProvider.php:731$entity = $this->entityManager->getRDBRepositoryByClass(InboundEmailEntity::class)->select(['id'])->distinct( )->join('teams')->where(['status' => InboundEmailEntity::STATUS_ACTIVE, 'useSmtp' => true, 'smtpIsShared' => true, 'teamsMiddle.teamId' => $teamIdList, ])->where(Condition::equal(Expression::lowerCase(Expression::column('emailAddress')), strtolower($emailAddress)))->findOne( )
/application/Espo/Core/Mail/Account/SendingAccountProvider.php:961$entity = $this->entityManager->getRDBRepositoryByClass(InboundEmailEntity::class)->select(['id'])->where(['status' => InboundEmailEntity::STATUS_ACTIVE, 'useSmtp' => true, 'smtpIsShared' => true, ])->where(Condition::equal(Expression::lowerCase(Expression::column('emailAddress')), strtolower($emailAddress)))->findOne( )
/application/Espo/Core/Mail/Account/SendingAccountProvider.php:1291$entity = $this->entityManager->getRDBRepositoryByClass(InboundEmailEntity::class)->select(['id'])->where(['status' => InboundEmailEntity::STATUS_ACTIVE, 'useSmtp' => true, 'smtpHost!=' => null, ])->where(Condition::equal(Expression::lowerCase(Expression::column('emailAddress')), strtolower($emailAddress)))->findOne( )
/application/Espo/Core/Mail/Account/SendingAccountProvider.php:1721$entity = $this->entityManager->getRDBRepositoryByClass(EmailAccountEntity::class)->select(['id'])->where(['assignedUserId' => $user->getId( ), 'status' => EmailAccountEntity::STATUS_ACTIVE, 'useSmtp' => true, ])->where(Condition::equal(Expression::lowerCase(Expression::column('emailAddress')), strtolower($emailAddress)))->findOne( )
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:26911$this->_retvalue = $this->compileVariable($this->yystack[$this->yyidx + -2]->minor['var']) . $this->yystack[$this->yyidx + -2]->minor['smarty_internal_index'] . '::' . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:27111$this->_retvalue = $this->compileVariable($this->yystack[$this->yyidx + 0]->minor['var']) . $this->yystack[$this->yyidx + 0]->minor['smarty_internal_index']
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:26321$this->_retvalue = $this->yystack[$this->yyidx + -5]->minor . ' ? ' . $this->yystack[$this->yyidx + -2]->minor . ' : ' . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:26891$this->_retvalue = $this->compiler->compileTag('private_special_variable', array( ), $this->yystack[$this->yyidx + -2]->minor['smarty_internal_index']) . '::' . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:28101$this->_retvalue = $this->compileVariable($this->yystack[$this->yyidx + -1]->minor['var']) . $this->yystack[$this->yyidx + -1]->minor['smarty_internal_index'] . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:28531$this->_retvalue = '->{\'' . $this->yystack[$this->yyidx + -4]->minor . '\'.' . $this->yystack[$this->yyidx + -2]->minor . $this->yystack[$this->yyidx + 0]->minor . '}'
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:27821$this->_retvalue = '[' . $this->compiler->compileTag('private_special_variable', array( ), '[\'section\'][\'' . $this->yystack[$this->yyidx + -3]->minor . '\'][\'' . $this->yystack[$this->yyidx + -1]->minor . '\']') . ']'
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:28081$this->_retvalue = $this->compiler->compileTag('private_special_variable', array( ), $this->yystack[$this->yyidx + -1]->minor['smarty_internal_index']) . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_config.php:1311return $this->compiled_timestamp === null ? ($this->compiled_timestamp = (file_exists($this->getCompiledFilepath( ))) ? filemtime($this->getCompiledFilepath( )) : false) : $this->compiled_timestamp
/install/vendor/smarty/libs/sysplugins/smarty_internal_config.php:1451return $this->mustCompile === null ? $this->mustCompile = ($this->smarty->force_compile || $this->getCompiledTimestamp( ) === false || $this->smarty->compile_check && $this->getCompiledTimestamp( ) < $this->source->timestamp) : $this->mustCompile
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:29221$this->_retvalue = array_merge($this->yystack[$this->yyidx + -2]->minor, array(array_merge($this->yystack[$this->yyidx + -1]->minor, $this->yystack[$this->yyidx + 0]->minor)))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:29471$this->_retvalue = '$' . $this->yystack[$this->yyidx + -2]->minor . $this->yystack[$this->yyidx + -1]->minor . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_template.php:1531$this->mustCompile = (!$this->source->uncompiled && ($this->smarty->force_compile || $this->source->recompiled || $this->compiled->timestamp === false || ($this->smarty->compile_check && $this->compiled->timestamp < $this->source->timestamp)))
/install/vendor/smarty/libs/plugins/shared.make_timestamp.php:261return mktime(substr($string, 8, 2), substr($string, 10, 2), substr($string, 12, 2), substr($string, 4, 2), substr($string, 6, 2), substr($string, 0, 4))
/install/vendor/smarty/libs/sysplugins/smarty_internal_config.php:1461$this->mustCompile = ($this->smarty->force_compile || $this->getCompiledTimestamp( ) === false || $this->smarty->compile_check && $this->getCompiledTimestamp( ) < $this->source->timestamp)
/install/vendor/smarty/libs/sysplugins/smarty_cacheresource_keyvaluestore.php:561$cached->filepath = $_template->source->uid . '#' . $this->sanitize($cached->source->name) . '#' . $this->sanitize($cached->cache_id) . '#' . $this->sanitize($cached->compile_id)
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24381$this->_retvalue = $this->compiler->compileTag('for', array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('start' => $this->yystack[$this->yyidx + -3]->minor), array('to' => $this->yystack[$this->yyidx + -1]->minor))), 0)
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24281$this->_retvalue = $this->compiler->compileTag('for', array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('start' => $this->yystack[$this->yyidx + -9]->minor), array('ifexp' => $this->yystack[$this->yyidx + -6]->minor), array('var' => $this->yystack[$this->yyidx + -2]->minor), array('step' => $this->yystack[$this->yyidx + -1]->minor))), 1)
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24171$this->_retvalue = $this->compiler->compileTag(($tag == 'else if') ? 'elseif' : $tag, $this->yystack[$this->yyidx + 0]->minor, array('if condition' => $this->yystack[$this->yyidx + -1]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24041$this->_retvalue = '<?php ob_start();?>' . $this->compiler->compileTag($this->yystack[$this->yyidx + -4]->minor, $this->yystack[$this->yyidx + 0]->minor, array('object_methode' => $this->yystack[$this->yyidx + -2]->minor)) . '<?php echo '
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24631$this->_retvalue = $this->compiler->compileTag('setfilter', array( ), array('modifier_list' => array(array_merge(array($this->yystack[$this->yyidx + -1]->minor), $this->yystack[$this->yyidx + 0]->minor))))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24581$this->_retvalue = $this->compiler->compileTag('foreach', array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('from' => $this->yystack[$this->yyidx + -7]->minor), array('item' => $this->yystack[$this->yyidx + -1]->minor), array('key' => $this->yystack[$this->yyidx + -4]->minor))))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24531$this->_retvalue = $this->compiler->compileTag('foreach', array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('from' => $this->yystack[$this->yyidx + -4]->minor), array('item' => $this->yystack[$this->yyidx + -1]->minor))))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24431$this->_retvalue = $this->compiler->compileTag('for', array_merge($this->yystack[$this->yyidx + 0]->minor, array(array('start' => $this->yystack[$this->yyidx + -5]->minor), array('to' => $this->yystack[$this->yyidx + -3]->minor), array('step' => $this->yystack[$this->yyidx + -1]->minor))), 0)
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:25001$this->_retvalue = $this->compiler->compileTag($this->yystack[$this->yyidx + -3]->minor . 'close', array( ), array('object_methode' => $this->yystack[$this->yyidx + -1]->minor, 'modifier_list' => $this->yystack[$this->yyidx + 0]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24951$this->_retvalue = $this->compiler->compileTag($this->yystack[$this->yyidx + -2]->minor . 'close', array( ), array('object_methode' => $this->yystack[$this->yyidx + 0]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24901$this->_retvalue = $this->compiler->compileTag($this->yystack[$this->yyidx + -1]->minor . 'close', array( ), array('modifier_list' => $this->yystack[$this->yyidx + 0]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:24681$this->_retvalue = $this->compiler->compileTag('setfilter', array( ), array('modifier_list' => array_merge(array(array_merge(array($this->yystack[$this->yyidx + -2]->minor), $this->yystack[$this->yyidx + -1]->minor)), $this->yystack[$this->yyidx + 0]->minor)))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:26271$this->_retvalue = $this->yystack[$this->yyidx + -6]->minor . ' ? ' . $this->compileVariable("'" . $this->yystack[$this->yyidx + -2]->minor . "'") . ' : ' . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:25751$this->_retvalue = $this->yystack[$this->yyidx + -2]->minor . $this->yystack[$this->yyidx + -1]->minor . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:25701$this->_retvalue = $this->compiler->compileTag('private_modifier', array( ), array('value' => $this->yystack[$this->yyidx + -1]->minor, 'modifierlist' => $this->yystack[$this->yyidx + 0]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:25651$this->_retvalue = $this->yystack[$this->yyidx + -2]->minor . trim($this->yystack[$this->yyidx + -1]->minor) . $this->yystack[$this->yyidx + 0]->minor
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_if.php:1631$_output = "<?php } else {?>{$tmp}<?php if (!isset(\$_smarty_tpl->tpl_vars[" . $parameter['if condition']['var']['var'] . "]) || !is_array(\$_smarty_tpl->tpl_vars[" . $parameter['if condition']['var']['var'] . "]->value)) \$_smarty_tpl->createLocalArrayVariable(" . $parameter['if condition']['var']['var'] . "$_nocache);\n"
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_include.php:881$merge_compiled_includes = ($compiler->smarty->merge_compiled_includes || ($compiler->inheritance && $compiler->smarty->inheritance_merge_compiled_includes) || $_attr['inline'] === true) && !$compiler->template->source->recompiled
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatecompilerbase.php:7801$error_text = 'Syntax error in template "' . (empty($this->trace_filepath) ? $this->template->source->filepath : $this->trace_filepath) . '" on line ' . ($line + $this->trace_line_offset) . ' "' . trim(preg_replace('![\t\r\n]+!', ' ', $match[$line - 1])) . '" '
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_block.php:861self::$block_data[$_name]['source'] = "{$compiler->smarty->left_delimiter}private_child_block name={$_attr['name']} file='{$compiler->template->source->filepath}'" . " uid='{$compiler->template->source->uid}' line={$compiler->lex->line}"
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_block.php:1581$_tpl = new Smarty_Internal_template('string:' . $compiler->template->block_data[$_name]['source'], $compiler->smarty, $compiler->template, $compiler->template->cache_id, $compiler->template->compile_id, $compiler->template->caching, $compiler->template->cache_lifetime)
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_for.php:671$output .= "\$_smarty_tpl->tpl_vars[$_statement[var]]->total = (int) min(ceil((\$_smarty_tpl->tpl_vars[$_statement[var]]->step > 0 ? $_attr[to]+1 - ($_statement[value]) : $_statement[value]-($_attr[to])+1)/abs(\$_smarty_tpl->tpl_vars[$_statement[var]]->step)),$_attr[max]);\n"
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_for.php:721$output .= "for (\$_smarty_tpl->tpl_vars[$_statement[var]]->value = $_statement[value], \$_smarty_tpl->tpl_vars[$_statement[var]]->iteration = 1;\$_smarty_tpl->tpl_vars[$_statement[var]]->iteration <= \$_smarty_tpl->tpl_vars[$_statement[var]]->total;\$_smarty_tpl->tpl_vars[$_statement[var]]->value += \$_smarty_tpl->tpl_vars[$_statement[var]]->step, \$_smarty_tpl->tpl_vars[$_statement[var]]->iteration++) {\n"
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:1701$yy_global_pattern = "/\G(\\{\\})|\G(" . $this->ldel . "\\s*\\*([\S\s]*?)\\*\\s*" . $this->rdel . ")|\G(" . $this->ldel . "\\s*strip\\s*" . $this->rdel . ")|\G(" . $this->ldel . "\\s*\/strip\\s*" . $this->rdel . ")|\G(" . $this->ldel . "\\s*literal\\s*" . $this->rdel . ")|\G(" . $this->ldel . "\\s*(if|elseif|else if|while)\\s+)|\G(" . $this->ldel . "\\s*for\\s+)|\G(" . $this->ldel . "\\s*foreach(?![^\s]))|\G(" . $this->ldel . "\\s*setfilter\\s+)|\G(" . $this->ldel . "\\s*\/)|\G(" . $this->ldel . "\\s*)|\G(<\\?(?:php\\w+|=|[a-zA-Z]+)?)|\G(\\?>)|\G(\\s*" . $this->rdel . ")|\G(<%)|\G(%>)|\G([\S\s])/iS"
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23532$this->_retvalue = $this->compiler->compileTag('private_print_expression', $this->yystack[$this->yyidx + 0]->minor, array('value' => $this->yystack[$this->yyidx + -2]->minor, 'modifierlist' => $this->yystack[$this->yyidx + -1]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23581$this->_retvalue = $this->compiler->compileTag('private_print_expression', $this->yystack[$this->yyidx + 0]->minor, array('value' => $this->yystack[$this->yyidx + -1]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23632$this->_retvalue = $this->compiler->compileTag('private_print_expression', $this->yystack[$this->yyidx + 0]->minor, array('value' => $this->yystack[$this->yyidx + -2]->minor, 'modifierlist' => $this->yystack[$this->yyidx + -1]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23681$this->_retvalue = $this->compiler->compileTag('assign', array(array('value' => $this->yystack[$this->yyidx + 0]->minor), array('var' => "'" . $this->yystack[$this->yyidx + -2]->minor . "'")))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23731$this->_retvalue = $this->compiler->compileTag('assign', array_merge(array(array('value' => $this->yystack[$this->yyidx + -1]->minor), array('var' => "'" . $this->yystack[$this->yyidx + -3]->minor . "'")), $this->yystack[$this->yyidx + 0]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23781$this->_retvalue = $this->compiler->compileTag('assign', array_merge(array(array('value' => $this->yystack[$this->yyidx + -1]->minor), array('var' => $this->yystack[$this->yyidx + -3]->minor['var'])), $this->yystack[$this->yyidx + 0]->minor), array('smarty_internal_index' => $this->yystack[$this->yyidx + -3]->minor['smarty_internal_index']))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23931$this->_retvalue = $this->compiler->compileTag($this->yystack[$this->yyidx + -3]->minor, $this->yystack[$this->yyidx + 0]->minor, array('object_methode' => $this->yystack[$this->yyidx + -1]->minor))
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:23981$this->_retvalue = '<?php ob_start();?>' . $this->compiler->compileTag($this->yystack[$this->yyidx + -2]->minor, $this->yystack[$this->yyidx + 0]->minor) . '<?php echo '
/install/core/actions/saveSettings.php:381$database = ['dbname' => $_SESSION['install']['db-name'], 'user' => $_SESSION['install']['db-user-name'], 'password' => $_SESSION['install']['db-user-password'], 'platform' => $_SESSION['install']['db-platform'] ?? 'Mysql', ]
/install/core/actions/step2.php:461$fields = ['db-platform' => ['default' => $config->get('database.platform', 'Mysql'), ], 'db-driver' => ['default' => $config->get('database.driver', ''), ], 'db-name' => ['default' => $config->get('database.dbname', ''), ], 'host-name' => ['default' => $config->get('database.host', '') . ($config->get('database.port') ? ':' . $config->get('database.port') : ''), ], 'db-user-name' => ['default' => $config->get('database.user', ''), ], 'db-user-password' => [ ], ]
/install/vendor/smarty/libs/sysplugins/smarty_internal_function_call_handler.php:411$_code .= preg_replace(array("!<\?php echo \\'/\*%%SmartyNocache:{$_template->smarty->template_functions[$_name]['nocache_hash']}%%\*/|/\*/%%SmartyNocache:{$_template->smarty->template_functions[$_name]['nocache_hash']}%%\*/\\';\?>!", "!\\\'!"), array('', "'"), $_template->smarty->template_functions[$_name]['compiled'])
/install/core/actions/saveSettings.php:531$saveData = ['database' => $database, 'language' => !empty($_SESSION['install']['user-lang']) ? $_SESSION['install']['user-lang'] : 'en_US', 'siteUrl' => !empty($_SESSION['install']['site-url']) ? $_SESSION['install']['site-url'] : null, ]
/application/Espo/Tools/LinkManager/LinkManager.php:4361$dataRight = ['fields' => [$linkForeign => ['type' => 'linkMultiple', 'layoutDetailDisabled' => !$linkMultipleFieldForeign, 'layoutMassUpdateDisabled' => !$linkMultipleFieldForeign, 'layoutListDisabled' => !$linkMultipleFieldForeign, 'noLoad' => !$linkMultipleFieldForeign, 'importDisabled' => !$linkMultipleFieldForeign, 'exportDisabled' => !$linkMultipleFieldForeign, 'customizationDisabled' => !$linkMultipleField, 'isCustom' => true, ]], 'links' => [$linkForeign => ['type' => Entity::HAS_MANY, 'foreign' => $link, 'entity' => $entity, 'audited' => $audited, 'isCustom' => true, ], ], ]
/application/Espo/Tools/LinkManager/LinkManager.php:4641$dataLeft = ['fields' => [$link => ['type' => 'linkMultiple', 'layoutDetailDisabled' => !$linkMultipleField, 'layoutMassUpdateDisabled' => !$linkMultipleField, 'layoutListDisabled' => !$linkMultipleField, 'noLoad' => !$linkMultipleField, 'importDisabled' => !$linkMultipleField, 'exportDisabled' => !$linkMultipleField, 'customizationDisabled' => !$linkMultipleField, 'isCustom' => true, ]], 'links' => [$link => ['type' => Entity::HAS_MANY, 'relationName' => $relationName, 'foreign' => $linkForeign, 'entity' => $entityForeign, 'audited' => $auditedForeign, 'isCustom' => true, ], ], ]
/application/Espo/Tools/LinkManager/LinkManager.php:3901$dataRight = ['fields' => [$linkForeign => ['type' => 'link', ], ], 'links' => [$linkForeign => ['type' => Entity::BELONGS_TO, 'foreign' => $link, 'entity' => $entity, 'audited' => $audited, 'isCustom' => true, ], ], ]
/application/Espo/Tools/LinkManager/LinkManager.php:4191$dataLeft = ['fields' => [$link => ['type' => 'link', ], ], 'links' => [$link => ['type' => Entity::BELONGS_TO, 'foreign' => $linkForeign, 'entity' => $entityForeign, 'audited' => $auditedForeign, 'isCustom' => true, ], ], ]
/application/Espo/Tools/LinkManager/LinkManager.php:3351$dataRight = ['fields' => [$linkForeign => ['type' => 'linkOne', 'isCustom' => true, ], ], 'links' => [$linkForeign => ['type' => Entity::HAS_ONE, 'foreign' => $link, 'entity' => $entity, 'isCustom' => true, ], ], ]
/application/Espo/Tools/LinkManager/LinkManager.php:3651$dataLeft = ['fields' => [$link => ['type' => 'linkMultiple', 'layoutDetailDisabled' => !$linkMultipleField, 'layoutMassUpdateDisabled' => !$linkMultipleField, 'layoutListDisabled' => !$linkMultipleField, 'noLoad' => !$linkMultipleField, 'importDisabled' => !$linkMultipleField, 'exportDisabled' => !$linkMultipleField, 'customizationDisabled' => !$linkMultipleField, 'isCustom' => true, ], ], 'links' => [$link => ['type' => Entity::HAS_MANY, 'foreign' => $linkForeign, 'entity' => $entityForeign, 'audited' => $auditedForeign, 'isCustom' => true, ], ], ]
/application/Espo/Tools/LinkManager/LinkManager.php:1561$linkParams = LinkParams::createBuilder( )->setType($linkType)->setEntityType($entity)->setForeignEntityType($entityForeign)->setLink($link)->setForeignLink($linkForeign)->setName($relationName)->build( )
/application/Espo/Tools/LinkManager/LinkManager.php:3181$dataLeft = ['fields' => [$link => ['type' => 'link', 'isCustom' => true, ], ], 'links' => [$link => ['type' => Entity::BELONGS_TO, 'foreign' => $linkForeign, 'entity' => $entityForeign, 'isCustom' => true, ], ], ]
/application/Espo/Tools/LinkManager/Hook/Hooks/TargetListDelete.php:592[$entityType, $link, $foreignLink] = $params->getEntityType( ) === TargetList::ENTITY_TYPE ? [$params->getForeignEntityType( ), $params->getForeignLink( ), $params->getLink( ), ] : [$params->getEntityType( ), $params->getLink( ), $params->getForeignLink( ), ]
/application/Espo/Tools/EntityManager/Rename/Renamer.php:5381$query1 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityTeam')->set(['entityType' => $to])->where(['entityType' => $from])->build( )
/application/Espo/Tools/LinkManager/LinkManager.php:9291$linkParams = LinkParams::createBuilder( )->setType($type)->setName($name)->setEntityType($entity)->setForeignEntityType($entityForeign)->setLink($link)->setForeignLink($linkForeign)->build( )
/application/Espo/Tools/LinkManager/Hook/Hooks/TargetListCreate.php:582[$entityType, $link, $foreignLink] = $params->getEntityType( ) === TargetList::ENTITY_TYPE ? [$params->getForeignEntityType( ), $params->getForeignLink( ), $params->getLink( ), ] : [$params->getEntityType( ), $params->getLink( ), $params->getForeignLink( ), ]
/application/Espo/Tools/LinkManager/LinkManager.php:6531$dataLeft = ['fields' => [$link => ['type' => 'linkMultiple', 'layoutDetailDisabled' => !$linkMultipleField, 'layoutMassUpdateDisabled' => !$linkMultipleField, 'layoutListDisabled' => !$linkMultipleField, 'noLoad' => !$linkMultipleField, 'importDisabled' => !$linkMultipleField, 'exportDisabled' => !$linkMultipleField, 'customizationDisabled' => !$linkMultipleField, 'isCustom' => true, ]]]
/application/Espo/Tools/LinkManager/LinkManager.php:6841$dataRight = ['fields' => [$linkForeign => ['type' => 'linkMultiple', 'layoutDetailDisabled' => !$linkMultipleFieldForeign, 'layoutMassUpdateDisabled' => !$linkMultipleFieldForeign, 'layoutListDisabled' => !$linkMultipleFieldForeign, 'noLoad' => !$linkMultipleFieldForeign, 'importDisabled' => !$linkMultipleFieldForeign, 'exportDisabled' => !$linkMultipleFieldForeign, 'customizationDisabled' => !$linkMultipleFieldForeign, 'isCustom' => true, ]]]
/application/Espo/Tools/LinkManager/LinkManager.php:4901$dataRight = ['fields' => [$linkForeign => ['type' => 'linkMultiple', 'layoutDetailDisabled' => !$linkMultipleFieldForeign, 'layoutMassUpdateDisabled' => !$linkMultipleFieldForeign, 'layoutListDisabled' => !$linkMultipleFieldForeign, 'noLoad' => !$linkMultipleFieldForeign, 'importDisabled' => !$linkMultipleFieldForeign, 'exportDisabled' => !$linkMultipleFieldForeign, 'customizationDisabled' => !$linkMultipleField, 'isCustom' => true, ]], 'links' => [$linkForeign => ['type' => Entity::HAS_MANY, 'relationName' => $relationName, 'foreign' => $link, 'entity' => $entity, 'audited' => $audited, 'isCustom' => true, ]]]
/application/Espo/Tools/LinkManager/LinkManager.php:5251$dataLeft = ['fields' => [$link => ['type' => 'linkParent', 'entityList' => $params['parentEntityTypeList'] ?? null, ], ], 'links' => [$link => ['type' => Entity::BELONGS_TO_PARENT, 'foreign' => $linkForeign, 'isCustom' => true, ], ], ]
/application/Espo/Tools/Stream/RecordService/QueryHelper.php:2251return (clone $baseBuilder)->where(['type' => Note::TYPE_POST, 'targetType' => Note::TARGET_ALL, 'parentId' => null, 'createdById!=' => $user->getId( ), 'isGlobal' => true, ])->build( )
/application/Espo/Tools/Stream/RecordService/QueryHelper.php:1871return (clone $baseBuilder)->where(['parentId' => null, 'type' => Note::TYPE_POST, 'targetType' => Note::TARGET_TEAMS, 'createdById!=' => $user->getId( ), 'isGlobal' => false, ])->where(Cond::in(Expr::column('id'), SelectBuilder::create( )->select('noteId')->from('NoteTeam')->where(['teamId' => $user->getTeamIdList( )])->build( )))->build( )
/application/Espo/Tools/Stream/RecordService/QueryHelper.php:1601return (clone $baseBuilder)->where(['parentId' => null, 'type' => Note::TYPE_POST, 'targetType' => Note::TARGET_PORTALS, 'createdById!=' => $user->getId( ), 'isGlobal' => false, ])->where(Cond::in(Expr::column('id'), SelectBuilder::create( )->select('noteId')->from('NotePortal')->where(['portalId' => $portalIdList])->build( )))->build( )
/application/Espo/Tools/Stream/RecordService/QueryHelper.php:1431return (clone $baseBuilder)->where(['parentId' => null, 'type' => Note::TYPE_POST, 'targetType' => Note::TARGET_PORTALS, 'createdById!=' => $user->getId( ), 'isGlobal' => false, ])->build( )
/application/Espo/Tools/Stream/RecordService/QueryHelper.php:1151return (clone $baseBuilder)->where(['type' => Note::TYPE_POST, 'targetType' => Note::TARGET_USERS, 'parentId' => null, 'createdById!=' => $user->getId( ), 'isGlobal' => false, ])->where(Cond::in(Expr::column('id'), SelectBuilder::create( )->select('noteId')->from('NoteUser')->where(['userId' => $user->getId( )])->build( )))->build( )
/application/Espo/Tools/Stream/RecordService/QueryHelper.php:711$builder = $this->selectBuilderFactory->create( )->from(Note::ENTITY_TYPE)->withComplexExpressionsForbidden( )->withWherePermissionCheck( )->withSearchParams($searchParams->withOffset(null)->withMaxSize(null))->buildQueryBuilder( )->order([ ])
/application/Espo/Tools/Stream/RecordService.php:2181$where[] = ['OR' => ['OR' => [['relatedId!=' => null, 'relatedType!=' => array_merge($onlyTeamEntityTypeList, $onlyOwnEntityTypeList, ), ], ['relatedId=' => null, 'superParentId' => $id, 'superParentType' => $scope, 'parentId!=' => null, 'parentType!=' => array_merge($onlyTeamEntityTypeList, $onlyOwnEntityTypeList, ), ], ['relatedId=' => null, 'parentType=' => $scope, 'parentId=' => $id, ]], ['OR' => [['relatedId!=' => null, 'relatedType=' => $onlyTeamEntityTypeList, ], ['relatedId=' => null, 'parentType=' => $onlyTeamEntityTypeList, ]], ['OR' => ['teamsMiddle.teamId' => $this->user->getTeamIdList( ), 'usersMiddle.userId' => $this->user->getId( ), ]]], ['OR' => [['relatedId!=' => null, 'relatedType=' => $onlyOwnEntityTypeList, ], ['relatedId=' => null, 'parentType=' => $onlyOwnEntityTypeList, ]], 'usersMiddle.userId' => $this->user->getId( ), ]]]
/application/Espo/Tools/Stream/RecordService.php:1371$where = $this->user->isPortal( ) ? ['parentType' => $scope, 'parentId' => $id, 'isInternal' => false, ] : ['OR' => [['parentType' => $scope, 'parentId' => $id, ], ['superParentType' => $scope, 'superParentId' => $id, ], ]]
/application/Espo/Tools/LeadCapture/Service.php:1171$inboundEmailList = $this->entityManager->getRDBRepositoryByClass(InboundEmail::class)->where(['useSmtp' => true, 'status' => InboundEmail::STATUS_ACTIVE, ['emailAddress!=' => ''], ['emailAddress!=' => null], ])->find( )
/application/Espo/Tools/LeadCapture/ConfirmationSender.php:1601$emailData = $this->emailTemplateProcessor->process($emailTemplate, EmailTemplateParams::create( ), EmailTemplateData::create( )->withEntityHash([Person::TEMPLATE_TYPE => $lead, Lead::ENTITY_TYPE => $lead, ]))
/application/Espo/Tools/Pdf/Dompdf/HtmlComposer.php:1622$renderer = $this->templateRendererFactory->create( )->setApplyAcl($params->applyAcl( ))->setEntity($entity)->setSkipInlineAttachmentHandling( )->setData($data->getAdditionalTemplateData( ))
/application/Espo/Tools/Pdf/Dompdf/HtmlComposer.php:1292$renderer = $this->templateRendererFactory->create( )->setApplyAcl($params->applyAcl( ))->setEntity($entity)->setSkipInlineAttachmentHandling( )->setData($data->getAdditionalTemplateData( ))
/application/Espo/Tools/Pdf/Dompdf/HtmlComposer.php:771return " <head> {$titleHtml} </head> <style> @page { margin: {$topMargin}mm {$rightMargin}mm {$bottomMargin}mm {$leftMargin}mm; } body { font-size: {$fontSize}pt; } table.bordered, table.bordered td, table.bordered th { border: 1px solid; } > header { position: fixed; margin-top: -{$topMargin}mm; margin-left: -{$rightMargin}mm; margin-right: -{$leftMargin}mm; top: {$headerPosition}mm; left: {$leftMargin}mm; right: {$rightMargin}mm; } > footer { position: fixed; margin-bottom: -{$bottomMargin}mm; margin-left: -{$leftMargin}mm; margin-right: -{$rightMargin}mm; height: {$footerPosition}mm; bottom: 0; left: {$leftMargin}mm; right: {$rightMargin}mm; } > header .page-number:after, > footer .page-number:after { content: counter(page); } $templateStyle </style> "
/application/Espo/Tools/Pdf/Dompdf/DompdfInitializer.php:551$size = $template->getPageFormat( ) === Template::PAGE_FORMAT_CUSTOM ? [0.0, 0.0, $template->getPageWidth( ) * self::PT, $template->getPageHeight( ) * self::PT] : $template->getPageFormat( )
/application/Espo/Tools/CategoryTree/RebuildPaths.php:1171$insert = $this->entityManager->getQueryBuilder( )->insert( )->into($pathEntityType)->columns(['ascendorId', 'descendorId'])->values(['ascendorId' => $entity->getId( ), 'descendorId' => $entity->getId( ), ])->build( )
/application/Espo/Tools/CategoryTree/RebuildPaths.php:961$subSelect1 = $this->entityManager->getQueryBuilder( )->select( )->from($pathEntityType)->select(['ascendorId', "'" . $entity->getId( ) . "'"])->where(['descendorId' => $parentId, ])->build( )
/application/Espo/Tools/Stream/Service.php:2571$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Subscription::ENTITY_TYPE)->where(['userId' => $userIdList, 'entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( )
/application/Espo/Tools/Stream/Service.php:3391$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Subscription::ENTITY_TYPE)->where(['userId' => $userId, 'entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( )
/application/Espo/Tools/Stream/Service.php:3601$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Subscription::ENTITY_TYPE)->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( )
/application/Espo/Tools/Stream/Service.php:6891$existing = $this->entityManager->getRDBRepository(Note::ENTITY_TYPE)->select(['id'])->where(['type' => Note::TYPE_RELATE, 'parentId' => $parentId, 'parentType' => $parentType, 'relatedId' => $entity->getId( ), 'relatedType' => $entityType, ])->findOne( )
/application/Espo/Tools/Notification/RecordService.php:2731$update = $this->entityManager->getQueryBuilder( )->update( )->in(Notification::ENTITY_TYPE)->set(['read' => true])->where(['userId' => $userId, 'read' => false, ])->build( )
/application/Espo/Tools/Attachment/Service.php:731return new FileData($attachment->getName( ), $attachment->getType( ), $this->getAttachmentRepository( )->getStream($attachment), $this->getAttachmentRepository( )->getSize($attachment))
/application/Espo/Tools/Attachment/Api/GetFile.php:561$response = ResponseComposer::empty( )->setHeader('Content-Disposition', 'attachment; filename="' . $fileData->getName( ) . '"')->setHeader('Content-Length', (string) $fileData->getSize( ))->setBody($fileData->getStream( ))
/application/Espo/Tools/Stream/Service.php:1831return (bool) $this->entityManager->getRDBRepository(Subscription::ENTITY_TYPE)->select(['id'])->where(['userId' => $userId, 'entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), ])->findOne( )
/application/Espo/Tools/Stream/Service.php:12601$noteList = $this->entityManager->getRDBRepository(Note::ENTITY_TYPE)->where(['OR' => [['relatedId' => $entity->getId( ), 'relatedType' => $entityType, ], ['parentId' => $entity->getId( ), 'parentType' => $entityType, 'superParentId!=' => null, 'relatedId' => null, ]]])->select(['id', 'parentType', 'parentId', 'superParentType', 'superParentId', 'isInternal', 'relatedType', 'relatedId', 'createdAt', ])->order('number', 'DESC')->limit(0, $limit)->find( )
/application/Espo/Tools/Stream/UserRecordService.php:1022$baseBuilder = $this->queryHelper->buildBaseQueryBuilder($searchParams)->select($this->queryHelper->getUserQuerySelect( ))->leftJoin('createdBy')->order('number', Order::DESC)->limit(0, $offset + $maxSize + 1)
/application/Espo/Tools/Stream/UserRecordService.php:1452$baseBuilder = $this->queryHelper->buildBaseQueryBuilder($searchParams)->select($this->queryHelper->getUserQuerySelect( ))->leftJoin('createdBy')->order('number', Order::DESC)->limit(0, $offset + $maxSize + 1)
/application/Espo/Tools/Stream/GlobalRecordService.php:761$baseBuilder = $this->queryHelper->buildBaseQueryBuilder($searchParams)->select($this->queryHelper->getUserQuerySelect( ))->order('number', Order::DESC)->limit(0, $maxSize + 1)
/application/Espo/Tools/Stream/Service.php:7291$existing = $this->entityManager->getRDBRepository(Note::ENTITY_TYPE)->select(['id'])->where(['type' => Note::TYPE_UNRELATE, 'parentId' => $parentId, 'parentType' => $parentType, 'relatedId' => $entity->getId( ), 'relatedType' => $entityType, ])->findOne( )
/application/Espo/Tools/Stream/Service.php:9901$userList = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id'])->join(Subscription::ENTITY_TYPE, 'subscription', ['subscription.userId=:' => 'user.id', 'subscription.entityId' => $entity->getId( ), 'subscription.entityType' => $entity->getEntityType( ), ])->where(['isActive' => true])->find( )
/application/Espo/Tools/Stream/Service.php:10811$userList = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id', 'name'])->join(Subscription::ENTITY_TYPE, 'subscription', ['subscription.userId=:' => 'user.id', 'subscription.entityId' => $entity->getId( ), 'subscription.entityType' => $entity->getEntityType( )])->limit($offset, $limit)->where(['isActive' => true, ])->order(Order::createByPositionInList(Expr::column('id'), [$this->user->getId( )]))->order('name')->find( )
/application/Espo/Tools/Stream/Service.php:11391$builder = $this->entityManager->getQueryBuilder( )->select( )->from(Subscription::ENTITY_TYPE)->select('userId')->where(['entityId' => $parentId, 'entityType' => $parentType, ])
/application/Espo/Tools/App/AppService.php:1431$appParams = ['maxUploadSize' => $this->getMaxUploadSize( ) / 1024.0 / 1024.0, 'isRestrictedMode' => $this->config->get('restrictedMode'), 'passwordChangeForNonAdminDisabled' => $passwordChangeForNonAdminDisabled, 'timeZoneList' => $timeZoneList, 'auth2FARequired' => $auth2FARequired, 'logoutWait' => $logoutWait, 'systemUserId' => $this->systemUser->getId( ), ]
/application/Espo/Tools/App/AppService.php:1111return ['user' => $this->getUserDataForFrontend( ), 'acl' => $this->getAclDataForFrontend( ), 'preferences' => $preferencesData, 'token' => $this->user->get('token'), 'settings' => $settings, 'language' => $language, 'appParams' => $this->getAppParams( ), ]
/application/Espo/Tools/App/AppService.php:3501$inboundEmailList = $this->entityManager->getRDBRepositoryByClass(InboundEmailEntity::class)->where(['status' => InboundEmailEntity::STATUS_ACTIVE, 'useSmtp' => true, 'smtpIsShared' => true, 'teamsMiddle.teamId' => $teamIdList, ])->join('teams')->distinct( )->find( )
/application/Espo/Tools/App/AppService.php:3111$emailAccountCollection = $this->entityManager->getRDBRepositoryByClass(EmailAccountEntity::class)->select(['id', 'emailAddress'])->where(['assignedUserId' => $user->getId( ), 'useSmtp' => true, 'status' => EmailAccountEntity::STATUS_ACTIVE, ])->find( )
/upgrades/7.0/scripts/AfterUpgrade.php:2171$updateQuery = $entityManager->getQueryBuilder( )->update( )->in($entityType)->set(['monitoredFolders' => $foldersJsonString])->where(['id' => $id])->build( )
/upgrades/7.2/scripts/AfterUpgrade.php:1681$query = $entityManager->getQueryBuilder( )->update( )->in(\Espo\Modules\Crm\Entities\KnowledgeBaseArticle::ENTITY_TYPE)->where(['type' => null])->set(['type' => 'Article'])->build( )
/application/Espo/Tools/App/SettingsService.php:2051$ignoreItemList = array_merge($this->access->getSystemParamList( ), $this->access->getReadOnlyParamList( ), $this->isRestrictedMode( ) && !$user->isSuperAdmin( ) ? $this->access->getSuperAdminParamList( ) : [ ])
/application/Espo/Tools/ActionHistory/Service.php:671$collection = $this->entityManager->getRDBRepositoryByClass(ActionHistoryRecord::class)->where(['userId' => $this->user->getId( ), 'action' => Action::READ, 'targetType' => $targetTypeList, ])->order('MAX:createdAt', 'DESC')->select(['targetId', 'targetType', 'MAX:number', ['MAX:createdAt', 'createdAt'], ])->group(['targetId', 'targetType'])->limit($offset, $maxSize + 1)->find( )
/application/Espo/Tools/Notification/Service.php:771$related = $this->entityManager->getRDBRepository(Email::ENTITY_TYPE)->select(['id', 'sentById', 'createdById'])->where(['id' => $note->getRelatedId( )])->findOne( )
/application/Espo/Tools/Notification/HookProcessor.php:1471$query = $this->entityManager->getQueryBuilder( )->delete( )->from(Notification::ENTITY_TYPE)->where(['OR' => [['relatedId' => $entity->getId( ), 'relatedType' => $entity->getEntityType( ), ], ['relatedParentId' => $entity->getId( ), 'relatedParentType' => $entity->getEntityType( ), ], ], ])->build( )
/application/Espo/Tools/Notification/RecordService.php:1481$query = $this->entityManager->getQueryBuilder( )->update( )->in(Notification::ENTITY_TYPE)->set(['read' => true])->where(['id' => $ids])->build( )
/application/Espo/Tools/Notification/RecordService.php:751$queryBuilder = $this->selectBuilderFactory->create( )->from(Notification::ENTITY_TYPE)->withSearchParams($searchParams)->buildQueryBuilder( )->where(['userId' => $userId])->order('number', SearchParams::ORDER_DESC)
/application/Espo/Tools/EmailNotification/AssignmentProcessor.php:1481$templateData = ['userName' => $user->get('name'), 'assignerUserName' => $assignerUser->get('name'), 'recordUrl' => $recordUrl, 'entityType' => $this->language->translateLabel($entity->getEntityType( ), 'scopeNames'), ]
/application/Espo/Tools/AdminNotifications/Jobs/CheckNewExtensionVersion.php:721$query = $this->entityManager->getQueryBuilder( )->select( )->from(Extension::ENTITY_TYPE)->select(['id', 'name', 'version', 'checkVersionUrl'])->where(['deleted' => false, 'isInstalled' => true, ])->order(['createdAt'])->build( )
/application/Espo/Tools/Notification/NoteHookProcessor.php:2231$existing = $this->entityManager->getRDBRepository(Notification::ENTITY_TYPE)->select(['id'])->where(['type' => Notification::TYPE_NOTE, 'relatedType' => Note::ENTITY_TYPE, 'relatedId' => $note->getId( ), 'userId' => $userId, ])->findOne( )
/application/Espo/Tools/EmailNotification/Processor.php:2151$builder = $this->entityManager->getQueryBuilder( )->select( )->from(Notification::ENTITY_TYPE)->join(Note::ENTITY_TYPE, 'note', ['note.id:' => 'relatedId'])->where(['type' => Notification::TYPE_NOTE, 'relatedType' => Note::ENTITY_TYPE, 'note.type' => $noteNotificationTypeList, ])
/application/Espo/Classes/Jobs/Cleanup.php:4951$emailList = $this->entityManager->getRDBRepository(Email::ENTITY_TYPE)->clone($query)->sth( )->select(['id'])->where(['createdAt<' => $dateBefore, 'deleted' => true, ])->find( )
/application/Espo/Classes/Jobs/Cleanup.php:5211$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Email::ENTITY_TYPE)->where(['deleted' => true, 'id' => $id, ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:6671$noteList = $this->entityManager->getRDBRepository(Note::ENTITY_TYPE)->clone($query)->sth( )->where(['OR' => [['relatedType' => $scope, 'relatedId' => $entity->getId( ), ], ['parentType' => $scope, 'parentId' => $entity->getId( ), ]]])->find( )
/application/Espo/Classes/Jobs/Cleanup.php:7101$arrayValueList = $this->entityManager->getRDBRepository(ArrayValue::ENTITY_TYPE)->sth( )->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), ])->find( )
/application/Espo/Classes/FieldProcessing/User/LastAccessLoader.php:651$authToken = $this->entityManager->getRDBRepository(AuthToken::ENTITY_TYPE)->select(['id', 'lastAccess'])->where(['userId' => $entity->getId( ), ])->order('lastAccess', 'DESC')->findOne( )
/application/Espo/Classes/FieldProcessing/Email/IcsDataLoader.php:1721$emailSameEvent = $this->entityManager->getRDBRepository(Email::ENTITY_TYPE)->where(['icsEventUid' => $espoEvent->getUid( ), 'id!=' => $entity->getId( )])->findOne( )
/application/Espo/Classes/FieldProcessing/Email/UserColumnsLoader.php:551$emailUser = $this->entityManager->getRDBRepository(Email::RELATIONSHIP_EMAIL_USER)->select([Email::USERS_COLUMN_IS_READ, Email::USERS_COLUMN_IS_IMPORTANT, Email::USERS_COLUMN_IN_TRASH, ])->where(['deleted' => false, 'userId' => $this->user->getId( ), 'emailId' => $entity->getId( ), ])->findOne( )
/application/Espo/Classes/FieldConverters/RelationshipRole.php:781return $attributeDefs->withParamsMerged(['where' => ['=' => ['whereClause' => ['id=s' => ['from' => $midTable, 'select' => [$nearKey], 'whereClause' => ['deleted' => false, $column => '{value}', ], ], ], ], '<>' => ['whereClause' => ['id!=s' => ['from' => $midTable, 'select' => [$nearKey], 'whereClause' => ['deleted' => false, $column => '{value}', ], ], ], ], 'IN' => ['whereClause' => ['id=s' => ['from' => $midTable, 'select' => [$nearKey], 'whereClause' => ['deleted' => false, $column => '{value}', ], ], ], ], 'NOT IN' => ['whereClause' => ['id!=s' => ['from' => $midTable, 'select' => [$nearKey], 'whereClause' => ['deleted' => false, $column => '{value}', ], ], ], ], 'LIKE' => ['whereClause' => ['id=s' => ['from' => $midTable, 'select' => [$nearKey], 'whereClause' => ['deleted' => false, "$column*" => '{value}', ], ], ], ], 'NOT LIKE' => ['whereClause' => ['id!=s' => ['from' => $midTable, 'select' => [$nearKey], 'whereClause' => ['deleted' => false, "$column*" => '{value}', ], ], ], ], 'IS NULL' => ['whereClause' => ['NOT' => ['EXISTS' => ['from' => $entityType, 'fromAlias' => 'sq', 'select' => ['id'], 'leftJoins' => [[$link, 'm', null, ['onlyMiddle' => true]]], 'whereClause' => ["m.$column!=" => null, 'sq.id:' => lcfirst($entityType) . '.id', ], ], ], ], ], 'IS NOT NULL' => ['whereClause' => ['EXISTS' => ['from' => $entityType, 'fromAlias' => 'sq', 'select' => ['id'], 'leftJoins' => [[$link, 'm', null, ['onlyMiddle' => true]]], 'whereClause' => ["m.$column!=" => null, 'sq.id:' => lcfirst($entityType) . '.id', ], ], ], ], ], ])
/application/Espo/Classes/Jobs/Cleanup.php:2411$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(ActionHistoryRecord::ENTITY_TYPE)->where(['DATE:createdAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:2601$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(AuthToken::ENTITY_TYPE)->where(['DATE:modifiedAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_FORMAT), 'isActive' => false, ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:2811$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(AuthLogRecord::ENTITY_TYPE)->where(['DATE:createdAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:3111$collection = $this->entityManager->getRDBRepository(Attachment::ENTITY_TYPE)->sth( )->where(['OR' => [['role' => [Attachment::ROLE_EXPORT_FILE, 'Mail Merge', 'Mass Pdf', ]]], 'createdAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), ])->limit(0, 5000)->find( )
/application/Espo/Classes/Jobs/Cleanup.php:4171$query = $this->entityManager->getQueryBuilder( )->select( )->from($scope)->withDeleted( )->where(['deleted' => true, 'modifiedAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), 'modifiedAt>' => $datetimeFrom->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:4351$attachmentToRemoveList = $this->entityManager->getRDBRepository(Attachment::ENTITY_TYPE)->sth( )->where(['OR' => [['relatedType' => $scope, 'relatedId' => $deletedEntity->getId( ), ], ['parentType' => $scope, 'parentId' => $deletedEntity->getId( ), ]]])->find( )
/application/Espo/Classes/Jobs/Cleanup.php:4581$isBeingUploadedCollection = $this->entityManager->getRDBRepository(Attachment::ENTITY_TYPE)->sth( )->where(['isBeingUploaded' => true, 'createdAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), ])->find( )
/application/Espo/Classes/Jobs/Cleanup.php:4711$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Attachment::ENTITY_TYPE)->where(['deleted' => true, 'createdAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), ])->build( )
/application/Espo/Repositories/EmailAddress.php:1281$emailAddressList = $this->select(['name', 'lower', 'invalid', 'optOut', ['ee.primary', 'primary']])->join(EmailAddressEntity::RELATION_ENTITY_EMAIL_ADDRESS, 'ee', ['ee.emailAddressId:' => 'id', ])->where(['ee.entityId' => $entity->getId( ), 'ee.entityType' => $entity->getEntityType( ), 'ee.deleted' => false, ])->order('ee.primary', true)->find( )
/application/Espo/Repositories/PhoneNumber.php:2231$collection = $this->entityManager->getRDBRepository(PhoneNumberEntity::RELATION_ENTITY_PHONE_NUMBER)->sth( )->select(['entityType', 'entityId'])->where($where)->limit(0, self::LOOKUP_SMALL_MAX_SIZE)->order([['LIST:entityType:' . implode(',', $order)], ['primary', 'DESC'], ])->find( )
/application/Espo/Repositories/EmailAddress.php:1971$itemList = $this->entityManager->getRDBRepository(EmailAddressEntity::RELATION_ENTITY_EMAIL_ADDRESS)->sth( )->select(['entityType', 'entityId'])->where($where)->limit(0, self::LOOKUP_MAX_SIZE)->find( )
/application/Espo/Repositories/EmailAddress.php:1461$item = (object) ['emailAddress' => $emailAddress->get('name'), 'lower' => $emailAddress->get('lower'), 'primary' => $emailAddress->get('primary'), 'optOut' => $emailAddress->get('optOut'), 'invalid' => $emailAddress->get('invalid'), ]
/application/Espo/Repositories/Preferences.php:1271$select = $this->entityManager->getQueryBuilder( )->select( )->from(PreferencesEntity::ENTITY_TYPE)->select(['id', 'data'])->where(['id' => $id, ])->limit(0, 1)->build( )
/application/Espo/Repositories/EmailAddress.php:2621$itemList = $this->entityManager->getRDBRepository(EmailAddressEntity::RELATION_ENTITY_EMAIL_ADDRESS)->sth( )->select(['entityType', 'entityId'])->where($where)->limit(0, self::LOOKUP_SMALL_MAX_SIZE)->order([['primary', 'DESC'], ['LIST:entityType:User,Contact,Lead,Account'], ])->find( )
/application/Espo/Hooks/Attachment/RemoveFile.php:581$duplicateCount = $this->entityManager->getRDBRepositoryByClass(Attachment::class)->where(['OR' => ['sourceId' => $entity->getSourceId( ), 'id' => $entity->getSourceId( ), ]])->count( )
/application/Espo/Repositories/Preferences.php:2601$insert = $this->entityManager->getQueryBuilder( )->insert( )->into(PreferencesEntity::ENTITY_TYPE)->columns(['id', 'data'])->values(['id' => $entity->getId( ), 'data' => $dataString, ])->updateSet(['data' => $dataString, ])->build( )
/application/Espo/Repositories/Import.php:1501$delete1 = $this->entityManager->getQueryBuilder( )->delete( )->from(ImportEntityEntity::ENTITY_TYPE)->where(['importId' => $entity->getId( ), ])->build( )
/application/Espo/Resources/defaults/config.php:301return ['database' => ['host' => 'localhost', 'port' => null, 'charset' => null, 'dbname' => '', 'user' => '', 'password' => '', ], 'useCache' => true, 'jobMaxPortion' => 15, 'jobRunInParallel' => false, 'jobPoolConcurrencyNumber' => 8, 'daemonMaxProcessNumber' => 5, 'daemonInterval' => 10, 'daemonProcessTimeout' => 36000, 'jobForceUtc' => false, 'recordsPerPage' => 20, 'recordsPerPageSmall' => 5, 'recordsPerPageSelect' => 10, 'recordsPerPageKanban' => 5, 'applicationName' => 'EspoCRM', 'version' => '@@version', 'timeZone' => 'UTC', 'dateFormat' => 'DD.MM.YYYY', 'timeFormat' => 'HH:mm', 'weekStart' => 0, 'thousandSeparator' => ',', 'decimalMark' => '.', 'exportDelimiter' => ',', 'currencyList' => ['USD'], 'defaultCurrency' => 'USD', 'baseCurrency' => 'USD', 'currencyRates' => [ ], 'currencyNoJoinMode' => false, 'outboundEmailIsShared' => true, 'outboundEmailFromName' => 'EspoCRM', 'outboundEmailFromAddress' => null, 'smtpServer' => null, 'smtpPort' => 587, 'smtpAuth' => true, 'smtpSecurity' => 'TLS', 'smtpUsername' => null, 'smtpPassword' => null, 'language' => 'en_US', 'logger' => ['path' => 'data/logs/espo.log', 'level' => 'WARNING', 'rotation' => true, 'maxFileNumber' => 30, 'printTrace' => false, ], 'authenticationMethod' => 'Espo', 'globalSearchEntityList' => ['Account', 'Contact', 'Lead', 'Opportunity', ], 'tabList' => [(object) ['type' => 'divider', 'id' => '342567', 'text' => '$CRM'], 'Account', 'Contact', 'Lead', 'Opportunity', (object) ['type' => 'divider', 'text' => '$Activities', 'id' => '219419'], 'Email', 'Meeting', 'Call', 'Task', 'Calendar', (object) ['type' => 'divider', 'id' => '655187', 'text' => '$Support'], 'Case', 'KnowledgeBaseArticle', (object) ['type' => 'divider', 'text' => NULL, 'id' => '137994'], '_delimiter_', (object) ['type' => 'divider', 'text' => '$Marketing', 'id' => '463280'], 'Campaign', 'TargetList', (object) ['type' => 'divider', 'text' => '$Business', 'id' => '518202'], 'Document', (object) ['type' => 'divider', 'text' => '$Organization', 'id' => '566592'], 'User', 'Team', 'WorkingTimeCalendar', (object) ['type' => 'divider', 'text' => NULL, 'id' => '898671'], 'EmailTemplate', 'Template', 'Import', ], 'quickCreateList' => ["Account", "Contact", "Lead", "Opportunity", "Meeting", "Call", "Task", "Case", "Email"], 'exportDisabled' => false, 'adminNotifications' => true, 'adminNotificationsNewVersion' => true, 'adminNotificationsCronIsNotConfigured' => true, 'adminNotificationsNewExtensionVersion' => true, 'assignmentEmailNotifications' => false, 'assignmentEmailNotificationsEntityList' => ['Lead', 'Opportunity', 'Task', 'Case'], 'assignmentNotificationsEntityList' => ['Call', 'Email'], "portalStreamEmailNotifications" => true, 'streamEmailNotificationsEntityList' => ['Case'], 'streamEmailNotificationsTypeList' => ['Post', 'Status', 'EmailReceived'], 'emailNotificationsDelay' => 30, 'emailMessageMaxSize' => 10, 'emailRecipientAddressMaxCount' => 100, 'notificationsCheckInterval' => 10, 'popupNotificationsCheckInterval' => 15, 'maxEmailAccountCount' => 2, 'followCreatedEntities' => false, 'b2cMode' => false, 'restrictedMode' => false, 'theme' => 'Violet', 'themeParams' => (object) ['navbar' => 'side'], 'massEmailMaxPerHourCount' => 100, 'massEmailMaxPerBatchCount' => null, 'massEmailVerp' => false, 'personalEmailMaxPortionSize' => 50, 'inboundEmailMaxPortionSize' => 50, 'emailAddressLookupEntityTypeList' => ['User'], 'emailAddressSelectEntityTypeList' => ['User', 'Contact', 'Lead', 'Account'], 'emailAddressEntityLookupDefaultOrder' => ['User', 'Contact', 'Lead', 'Account'], 'phoneNumberEntityLookupDefaultOrder' => ['User', 'Contact', 'Lead', 'Account'], 'authTokenLifetime' => 0, 'authTokenMaxIdleTime' => 48, 'userNameRegularExpression' => '[^a-z0-9\-@_\.\s]', 'addressFormat' => 1, 'displayListViewRecordCount' => true, 'dashboardLayout' => [(object) ['name' => 'My Espo', 'layout' => [(object) ['id' => 'default-activities', 'name' => 'Activities', 'x' => 2, 'y' => 2, 'width' => 2, 'height' => 4], (object) ['id' => 'default-stream', 'name' => 'Stream', 'x' => 0, 'y' => 0, 'width' => 2, 'height' => 4]]]], 'calendarEntityList' => ['Meeting', 'Call', 'Task'], 'activitiesEntityList' => ['Meeting', 'Call'], 'historyEntityList' => ['Meeting', 'Call', 'Email'], 'busyRangesEntityList' => ['Meeting', 'Call'], 'emailAutoReplySuppressPeriod' => '2 hours', 'emailAutoReplyLimit' => 5, 'cleanupJobPeriod' => '1 month', 'cleanupActionHistoryPeriod' => '15 days', 'cleanupAuthTokenPeriod' => '1 month', 'cleanupSubscribers' => true, 'cleanupAudit' => true, 'cleanupAuditPeriod' => '3 months', 'currencyFormat' => 2, 'currencyDecimalPlaces' => 2, 'aclAllowDeleteCreated' => false, 'aclAllowDeleteCreatedThresholdPeriod' => '24 hours', 'attachmentAvailableStorageList' => null, 'attachmentUploadMaxSize' => 256, 'attachmentUploadChunkSize' => 4, 'inlineAttachmentUploadMaxSize' => 20, 'textFilterUseContainsForVarchar' => false, 'tabColorsDisabled' => false, 'massPrintPdfMaxCount' => 50, 'emailKeepParentTeamsEntityList' => ['Case'], 'streamEmailWithContentEntityTypeList' => ['Case'], 'recordListMaxSizeLimit' => 200, 'noteDeleteThresholdPeriod' => '1 month', 'noteEditThresholdPeriod' => '7 days', 'emailForceUseExternalClient' => false, 'useWebSocket' => false, 'webSocketMessager' => 'ZeroMQ', 'auth2FAMethodList' => ['Totp'], 'auth2FAInPortal' => false, 'personNameFormat' => 'firstLast', 'newNotificationCountInTitle' => false, 'pdfEngine' => 'Dompdf', 'smsProvider' => null, 'mapProvider' => 'Google', 'defaultFileStorage' => 'EspoUploadDir', 'ldapUserNameAttribute' => 'sAMAccountName', 'ldapUserFirstNameAttribute' => 'givenName', 'ldapUserLastNameAttribute' => 'sn', 'ldapUserTitleAttribute' => 'title', 'ldapUserEmailAddressAttribute' => 'mail', 'ldapUserPhoneNumberAttribute' => 'telephoneNumber', 'ldapUserObjectClass' => 'person', 'ldapPortalUserLdapAuth' => false, 'passwordGenerateLength' => 10, 'massActionIdleCountThreshold' => 100, 'exportIdleCountThreshold' => 1000, 'clientSecurityHeadersDisabled' => false, 'clientCspDisabled' => false, 'clientCspScriptSourceList' => ['https://maps.googleapis.com', ], 'oidcJwtSignatureAlgorithmList' => ['RS256'], 'oidcUsernameClaim' => 'sub', 'oidcFallback' => true, 'oidcScopes' => ['profile', 'email', 'phone'], 'listViewSettingsDisabled' => false, 'cleanupDeletedRecords' => true, 'phoneNumberNumericSearch' => true, 'phoneNumberInternational' => true, 'phoneNumberPreferredCountryList' => ['us', 'de'], 'adminUpgradeDisabled' => false, 'wysiwygCodeEditorDisabled' => false, 'customPrefixDisabled' => false, 'isInstalled' => false, ]
/application/Espo/Repositories/ArrayValue.php:851$existingList = $this->select(['id', 'value'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), 'attribute' => $attribute, ])->forUpdate( )->find( )
/application/Espo/Repositories/Import.php:1611$delete2 = $this->entityManager->getQueryBuilder( )->delete( )->from(ImportError::ENTITY_TYPE)->where(['importId' => $entity->getId( ), ])->build( )
/application/Espo/Repositories/PhoneNumber.php:1161$numberList = $this->select(['name', 'type', 'invalid', 'optOut', ['en.primary', 'primary']])->join(PhoneNumberEntity::RELATION_ENTITY_PHONE_NUMBER, 'en', ['en.phoneNumberId:' => 'id', ])->where(['en.entityId' => $entity->getId( ), 'en.entityType' => $entity->getEntityType( ), 'en.deleted' => false, ])->order('en.primary', true)->find( )
/application/Espo/Repositories/ArrayValue.php:1501$list = $this->select(['id'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), 'attribute' => $attribute, ])->forUpdate( )->find( )
/application/Espo/Repositories/PhoneNumber.php:1741$itemList = $this->entityManager->getRDBRepository(PhoneNumberEntity::RELATION_ENTITY_PHONE_NUMBER)->sth( )->select(['entityType', 'entityId'])->where($where)->limit(0, self::LOOKUP_MAX_SIZE)->find( )
/application/Espo/Repositories/PhoneNumber.php:1341$item = (object) ['phoneNumber' => $number->get('name'), 'type' => $number->get('type'), 'primary' => $number->get('primary'), 'optOut' => $number->get('optOut'), 'invalid' => $number->get('invalid'), ]
/application/Espo/Core/Authentication/Ldap/LdapLogin.php:3111return $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->where(['userName' => $username, 'password' => $hash, 'type' => [User::TYPE_ADMIN, User::TYPE_SUPER_ADMIN], ])->findOne( )
/application/Espo/Core/Authentication/Oidc/UserProvider/Sync.php:1201return ['emailAddress' => $payload->get('email'), 'phoneNumber' => $payload->get('phone_number'), 'emailAddressData' => null, 'phoneNumberData' => null, 'firstName' => $payload->get('given_name'), 'lastName' => $payload->get('family_name'), 'middle_name' => $payload->get('middle_name'), 'gender' => in_array($payload->get('gender'), ['male', 'female']) ? ucfirst($payload->get('gender') ?? '') : null, ]
/application/Espo/Core/Authentication/TwoFactor/Email/Util.php:2981$query = $this->entityManager->getQueryBuilder( )->update( )->in(TwoFactorCode::ENTITY_TYPE)->where(['userId' => $user->getId( ), 'method' => EmailLogin::NAME, ])->set(['isActive' => false, ])->build( )
/application/Espo/Core/Authentication/Ldap/LdapLogin.php:2181$user = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->where(['userName' => $username, 'type!=' => [User::TYPE_API, User::TYPE_SYSTEM, User::TYPE_SUPER_ADMIN, ], ])->findOne( )
/application/Espo/Classes/AppParams/TemplateEntityTypeList.php:681$query = $this->selectBuilderFactory->create( )->from(Template::ENTITY_TYPE)->withAccessControlFilter( )->buildQueryBuilder( )->select(['entityType'])->group(['entityType'])->build( )
/application/Espo/Classes/AppParams/Extensions.php:741$list[] = (object) ['name' => $extension->getName( ), 'version' => $extension->getVersion( ), 'licenseStatus' => $extension->getLicenseStatus( ), 'licenseStatusMessage' => $extension->getLicenseStatusMessage( ), 'isInstalled' => $extension->isInstalled( ), 'notify' => in_array($extension->getLicenseStatus( ), [Extension::LICENSE_STATUS_INVALID, Extension::LICENSE_STATUS_EXPIRED, ])]
/application/Espo/Core/Authentication/Helper/UserFinder.php:441return $this->entityManager->getRDBRepositoryByClass(User::class)->where(['userName' => $username, 'password' => $hash, 'type!=' => [User::TYPE_API, User::TYPE_SYSTEM], ])->findOne( )
/application/Espo/Core/Acl/DefaultAssignmentChecker.php:791return $entityDefs->hasField(self::FIELD_ASSIGNED_USERS) && $entityDefs->getField(self::FIELD_ASSIGNED_USERS)->getType( ) === 'linkMultiple' && $entityDefs->hasRelation(self::FIELD_ASSIGNED_USERS) && $entityDefs->getRelation(self::FIELD_ASSIGNED_USERS)->getForeignEntityType( ) === 'User'
/application/Espo/Core/Authentication/Jwt/SignatureVerifiers/Rsa.php:1181$publicKey = PublicKeyLoader::load(['n' => new BigInteger('0x' . bin2hex(Util::base64UrlDecode($key->getN( ))), 16), 'e' => new BigInteger('0x' . bin2hex(Util::base64UrlDecode($key->getE( ))), 16), ])
/application/Espo/Core/Authentication/TwoFactor/Sms/Util.php:1711return $this->entityManager->getRDBRepository(TwoFactorCode::ENTITY_TYPE)->where(['method' => self::METHOD, 'userId' => $user->getId( ), 'isActive' => true, ])->findOne( )
/application/Espo/Core/Authentication/Authentication.php:4731$authTokenData = AuthTokenData::create(['hash' => $password, 'ipAddress' => $ipAddress, 'userId' => $user->getId( ), 'portalId' => $this->isPortal( ) ? $this->getPortal( )->getId( ) : null, 'createSecret' => $createSecret, ])
/application/Espo/Core/Authentication/Authentication.php:4921$concurrentAuthTokenList = $this->entityManager->getRDBRepository(AuthTokenEntity::ENTITY_TYPE)->select(['id'])->where(['userId' => $user->getId( ), 'isActive' => true, 'id!=' => $authToken->getId( ), ])->find( )
/application/Espo/Core/Authentication/TwoFactor/Email/Util.php:1771return $this->entityManager->getRDBRepository(TwoFactorCode::ENTITY_TYPE)->where(['method' => EmailLogin::NAME, 'userId' => $user->getId( ), 'isActive' => true, ])->findOne( )
/application/Espo/Core/Authentication/TwoFactor/Email/Util.php:2411$count = $this->entityManager->getRDBRepository(TwoFactorCode::ENTITY_TYPE)->where(Cond::and(Cond::equal(Cond::column('method'), 'Email'), Cond::equal(Cond::column('userId'), $user->getId( )), Cond::greaterOrEqual(Cond::column('createdAt'), $from), Cond::lessOrEqual(Cond::column('attemptsLeft'), 0), ))->count( )
/application/Espo/Core/Authentication/TwoFactor/Sms/Util.php:2351$count = $this->entityManager->getRDBRepository(TwoFactorCode::ENTITY_TYPE)->where(Cond::and(Cond::equal(Cond::column('method'), self::METHOD), Cond::equal(Cond::column('userId'), $user->getId( )), Cond::greaterOrEqual(Cond::column('createdAt'), $from), Cond::lessOrEqual(Cond::column('attemptsLeft'), 0), ))->count( )
/application/Espo/Core/Authentication/TwoFactor/Sms/Util.php:2861$query = $this->entityManager->getQueryBuilder( )->update( )->in(TwoFactorCode::ENTITY_TYPE)->where(['userId' => $user->getId( ), 'method' => self::METHOD, ])->set(['isActive' => false, ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:1471$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Job::ENTITY_TYPE)->where(['DATE:modifiedAt<' => $this->getCleanupJobFromDate( ), 'status!=' => JobStatus::PENDING, ])->build( )
/application/Espo/Classes/Select/Email/Where/ItemConverters/InFolder.php:1101return WhereClause::fromRaw(['OR' => ['fromEmailAddressId' => $this->getEmailAddressIdList( ), ['status' => Email::STATUS_SENT, 'createdById' => $this->user->getId( ), ]], ['status!=' => Email::STATUS_DRAFT, ], 'emailUser.inTrash' => false, ])
/application/Espo/Classes/Select/Email/AccessControlFilters/OnlyTeam.php:471$subQuery = QueryBuilder::create( )->select('id')->from(Email::ENTITY_TYPE)->leftJoin(Team::RELATIONSHIP_ENTITY_TEAM, 'entityTeam', ['entityTeam.entityId:' => 'id', 'entityTeam.entityType' => Email::ENTITY_TYPE, 'entityTeam.deleted' => false, ])->leftJoin(Email::RELATIONSHIP_EMAIL_USER, 'emailUser', ['emailUser.emailId:' => 'id', 'emailUser.deleted' => false, 'emailUser.userId' => $this->user->getId( ), ])->where(['OR' => ['entityTeam.teamId' => $this->user->getTeamIdList( ), 'emailUser.userId' => $this->user->getId( ), ]])->build( )
/application/Espo/Classes/Select/User/OrderItemConverters/UserNameOwnFirst.php:521return OrderList::create([Order::create(Expr::notEqual(Expr::column('id'), $this->user->getId( )))->withDirection($item->getOrder( )), Order::create(Expr::column('userName'))->withDirection($item->getOrder( )), ])
/application/Espo/Classes/Jobs/Cleanup.php:2181$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(ScheduledJobLogRecord::ENTITY_TYPE)->where(['scheduledJobId' => $scheduledJobId, 'DATE:createdAt<' => $this->getCleanupJobFromDate( ), 'id!=' => $ignoreIdList, ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:1941$ignoreLogRecordList = $this->entityManager->getRDBRepository(ScheduledJobLogRecord::ENTITY_TYPE)->select(['id'])->where(['scheduledJobId' => $scheduledJobId, ])->order('createdAt', 'DESC')->limit(0, 10)->find( )
/application/Espo/Classes/Jobs/Cleanup.php:1711$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(UniqueId::ENTITY_TYPE)->where(['terminateAt!=' => null, 'terminateAt<' => date(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), ])->build( )
/application/Espo/Classes/Jobs/Cleanup.php:1571$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Job::ENTITY_TYPE)->where(['DATE:modifiedAt<' => $this->getCleanupJobFromDate( ), 'status=' => JobStatus::PENDING, 'deleted' => true, ])->build( )
/application/Espo/Classes/Cleanup/Reminders.php:611$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Reminder::ENTITY_TYPE)->where(['remindAt<' => $dt->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), ])->build( )
/application/Espo/Classes/Cleanup/Audit.php:671$query = $this->entityManager->getQueryBuilder( )->delete( )->from(Note::ENTITY_TYPE)->where(['parentType' => $entityType, 'createdAt<' => $this->getBefore( )->toString( ), 'type' => [Note::TYPE_UPDATE, Note::TYPE_STATUS], ])->build( )
/application/Espo/Classes/FieldValidators/CurrencyType.php:451return $entity->has($field) && $entity->get($field) !== null && $entity->has($field . 'Currency') && $entity->get($field . 'Currency') !== null && $entity->get($field . 'Currency') !== ''
/application/Espo/Classes/JobPreparators/CheckEmailAccounts.php:521$collection = $this->entityManager->getRDBRepositoryByClass(EmailAccount::class)->join('assignedUser', 'assignedUserAdditional')->where(['status' => EmailAccount::STATUS_ACTIVE, 'useImap' => true, 'assignedUserAdditional.isActive' => true, ])->find( )
/application/Espo/Classes/AssignmentNotificators/Email.php:2791$existing = $this->entityManager->getRDBRepository(Notification::ENTITY_TYPE)->where(['type' => Notification::TYPE_EMAIL_RECEIVED, 'userId' => $userId, 'relatedId' => $entity->getId( ), 'relatedType' => EmailEntity::ENTITY_TYPE, ])->select(['id'])->findOne( )
/application/Espo/Classes/Cleanup/Subscribers.php:1051$query = $this->entityManager->getQueryBuilder( )->delete( )->from(Subscription::ENTITY_TYPE, 'subscription')->join($entityType, 'entity', Cond::equal(Cond::column('entity.id'), Cond::column('entityId')))->where(Cond::and(Cond::equal(Cond::column('entityType'), $entityType), Cond::less(Cond::column('entity.' . $dateField), $before->toString( )), Cond::in(Cond::column('entity.' . $statusField), $statusList)))->build( )
/application/Espo/Classes/Cleanup/WebhookQueue.php:761$query2 = $this->entityManager->getQueryBuilder( )->delete( )->from('WebhookEventQueueItem')->where(['DATE:(createdAt)<' => $from, 'OR' => ['isProcessed' => true, 'deleted' => true, ], ])->build( )
/application/Espo/Classes/Cleanup/WebhookQueue.php:611$query1 = $this->entityManager->getQueryBuilder( )->delete( )->from('WebhookQueueItem')->where(['DATE:(createdAt)<' => $from, 'OR' => ['status!=' => 'Pending', 'deleted' => true, ], ])->build( )
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:4811$queryBuilder = $builder->buildQueryBuilder( )->select($select)->where(['OR' => [['dateEnd' => null, 'dateStart>=' => $from, 'dateStart<' => $to, ], ['dateEnd>=' => $from, 'dateEnd<' => $to, ], ['dateEndDate!=' => null, 'dateEndDate>=' => $from, 'dateEndDate<' => $to, ], ], ])
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:5951$userList = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id', 'name'])->leftJoin('teams')->where(['isActive' => true, 'teamsMiddle.teamId' => $teamIdList, ])->distinct( )->find( )
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:8731$itemList = $fetchParams->workingTimeRangesInverted( ) ? ($fetchParams->isAgenda( ) ? $extractor->extractInversion($calendar, $from, $to) : $extractor->extractAllDayInversion($calendar, $from, $to)) : ($fetchParams->isAgenda( ) ? $extractor->extract($calendar, $from, $to) : $extractor->extractAllDay($calendar, $from, $to))
/application/Espo/Modules/Crm/Tools/TargetList/OptOutService.php:2251return $this->entityManager->getQueryBuilder( )->select( )->from($entityType)->select(['id', 'name', 'createdAt', ["'$entityType'", 'entityType'], ])->join($linkEntityType, 'j', ["j.$key:" => 'id', 'j.deleted' => false, 'j.optedOut' => true, 'j.targetListId' => $id, ])->order('createdAt', Order::DESC)->build( )
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:2391$select = [['"' . $scope . '"', 'scope'], 'id', 'name', ['dateStart', 'dateStart'], ['dateEnd', 'dateEnd'], ($seed->hasAttribute('status') ? ['status', 'status'] : ['null', 'status']), ($seed->hasAttribute('dateStartDate') ? ['dateStartDate', 'dateStartDate'] : ['null', 'dateStartDate']), ($seed->hasAttribute('dateEndDate') ? ['dateEndDate', 'dateEndDate'] : ['null', 'dateEndDate']), ($seed->hasAttribute('parentType') ? ['parentType', 'parentType'] : ['null', 'parentType']), ($seed->hasAttribute('parentId') ? ['parentId', 'parentId'] : ['null', 'parentId']), 'createdAt', ]
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:2751$queryBuilder = $builder->buildQueryBuilder( )->select($select)->where(['OR' => $orGroup, ['OR' => [['dateEnd' => null, 'dateStart>=' => $from, 'dateStart<' => $to, ], ['dateStart>=' => $from, 'dateStart<' => $to, ], ['dateEnd>=' => $from, 'dateEnd<' => $to, ], ['dateStart<=' => $from, 'dateEnd>=' => $to, ], ['dateEndDate!=' => null, 'dateEndDate>=' => $from, 'dateEndDate<' => $to, ], ], ], ])
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:3592return $builder->buildQueryBuilder( )->select($select)->leftJoin('users')->where(['usersMiddle.userId' => $userId, 'usersMiddle.status!=' => Meeting::ATTENDEE_STATUS_DECLINED, 'OR' => [['dateStart>=' => $from, 'dateStart<' => $to, ], ['dateEnd>=' => $from, 'dateEnd<' => $to, ], ['dateStart<=' => $from, 'dateEnd>=' => $to, ], ], ])->build( )
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:4202return $builder->buildQueryBuilder( )->select($select)->leftJoin('users')->where(['usersMiddle.userId' => $userId, 'usersMiddle.status!=' => Meeting::ATTENDEE_STATUS_DECLINED, 'OR' => [['dateStart>=' => $from, 'dateStart<' => $to, ], ['dateEnd>=' => $from, 'dateEnd<' => $to, ], ['dateStart<=' => $from, 'dateEnd>=' => $to, ], ], ])->build( )
/application/Espo/ORM/QueryComposer/BaseQueryComposer.php:33331$sql = "{$prefixPart}JOIN " . $this->quoteIdentifier($relTable) . " AS " . $this->quoteIdentifier($midAlias) . "$indexPart " . "ON $leftKeyColumn = $middleKeyColumn" . " AND " . "$middleDeletedColumn = " . $this->quote(false)
/application/Espo/ORM/QueryComposer/BaseQueryComposer.php:34121$sql = "{$prefixPart}JOIN " . $this->quoteIdentifier($distantTable) . " AS " . $this->quoteIdentifier($alias) . " ON " . "$leftIdColumn = $rightIdColumn AND " . "$leftTypeColumn = " . $this->quote($entity->getEntityType( )) . " AND " . "$leftDeletedColumn = " . $this->quote(false)
/application/Espo/Modules/Crm/Tools/Opportunity/Service.php:1522$query = $this->selectBuilderFactory->create( )->from(Contact::ENTITY_TYPE)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'emailAddress', 'name', ])->where(['id' => $contactIdList, ])->build( )
/application/Espo/Modules/Crm/Tools/Calendar/Service.php:1601$eventList[] = new Event($row['dateStart'] ? DateTimeField::fromString($row['dateStart']) : null, $row['dateEnd'] ? DateTimeField::fromString($row['dateEnd']) : null, $row['scope'], $row)
/application/Espo/ORM/Query/SelectBuilder.php:3091$resultList[] = $item->getAlias( ) ? [$item->getExpression( )->getValue( ), $item->getAlias( )] : [$item->getExpression( )->getValue( )]
/application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:2471return "CASE WHEN EXTRACT(MONTH FROM $part) >= $fiscalFirstMonth " . "THEN " . "CONCAT(" . "EXTRACT(YEAR FROM $part), '_', " . "FLOOR((EXTRACT(MONTH FROM $part) - $fiscalFirstMonth) / 3) + 1" . ") " . "ELSE " . "CONCAT(" . "EXTRACT(YEAR FROM $part) - 1, '_', " . "CEIL((EXTRACT(MONTH FROM $part) + $fiscalDistractedMonth) / 3)" . ") " . "END"
/application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:3861$builder = DeleteBuilder::create( )->from($query->getFrom( ), $query->getFromAlias( ))->where(Cond::in(Cond::column('id'), $subQueryBuilder->build( )))
/application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:4311$builder = UpdateBuilder::create( )->in($query->getIn( ))->set($query->getSet( ))->where(Cond::in(Cond::column('id'), $subQueryBuilder->build( )))
/application/Espo/Modules/Crm/Tools/Activities/Service.php:2631$builder = $this->selectBuilderFactory->create( )->from(Email::ENTITY_TYPE)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'name', ['dateSent', 'dateStart'], ['null', 'dateEnd'], ['null', 'dateStartDate'], ['null', 'dateEndDate'], ['"Email"', '_scope'], 'assignedUserId', 'assignedUserName', 'parentType', 'parentId', 'status', 'createdAt', 'hasAttachment', ])->leftJoin('EmailUser', 'usersLeftMiddle', ['usersLeftMiddle.emailId:' => 'email.id', ])->where(['usersLeftMiddle.userId' => $entity->getId( ), ])
/application/Espo/Modules/Crm/Tools/Activities/Service.php:1821$builder = $this->selectBuilderFactory->create( )->from(Call::ENTITY_TYPE)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'name', ['dateStart', 'dateStart'], ['dateEnd', 'dateEnd'], ($seed->hasAttribute('dateStartDate') ? ['dateStartDate', 'dateStartDate'] : ['null', 'dateStartDate']), ($seed->hasAttribute('dateEndDate') ? ['dateEndDate', 'dateEndDate'] : ['null', 'dateEndDate']), ['"Call"', '_scope'], 'assignedUserId', 'assignedUserName', 'parentType', 'parentId', 'status', 'createdAt', ['null', 'hasAttachment'], ])->leftJoin('CallUser', 'usersLeftMiddle', ['usersLeftMiddle.callId:' => 'call.id', ])
/application/Espo/Modules/Crm/Tools/Activities/Service.php:4841$baseBuilder = $this->selectBuilderFactory->create( )->from('Email')->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'name', ['dateSent', 'dateStart'], ['null', 'dateEnd'], ['null', 'dateStartDate'], ['null', 'dateEndDate'], ['"Email"', '_scope'], 'assignedUserId', 'assignedUserName', 'parentType', 'parentId', 'status', 'createdAt', 'hasAttachment', ])
/application/Espo/Modules/Crm/Tools/Activities/Service.php:3311$baseBuilder = $this->selectBuilderFactory->create( )->from($targetEntityType)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'name', ['dateStart', 'dateStart'], ['dateEnd', 'dateEnd'], ($seed->hasAttribute('dateStartDate') ? ['dateStartDate', 'dateStartDate'] : ['null', 'dateStartDate']), ($seed->hasAttribute('dateEndDate') ? ['dateEndDate', 'dateEndDate'] : ['null', 'dateEndDate']), ['"' . $targetEntityType . '"', '_scope'], 'assignedUserId', 'assignedUserName', 'parentType', 'parentId', 'status', 'createdAt', ['false', 'hasAttachment'], ])
/application/Espo/Modules/Crm/Tools/KnowledgeBase/Service.php:3441$query = $this->selectBuilderFactory->create( )->from(KnowledgeBaseArticle::ENTITY_TYPE)->withStrictAccessControl( )->withSearchParams($params)->buildQueryBuilder( )->where(['order>' => $currentIndex, ])->order([['order', 'DESC'], ])->build( )
/application/Espo/Modules/Crm/Tools/KnowledgeBase/Service.php:2851$query = $this->selectBuilderFactory->create( )->from(KnowledgeBaseArticle::ENTITY_TYPE)->withStrictAccessControl( )->withSearchParams($params)->buildQueryBuilder( )->where(['order<' => $currentIndex, ])->order([['order', 'ASC'], ])->build( )
/application/Espo/Modules/Crm/Tools/Activities/Service.php:1141$builder = $this->selectBuilderFactory->create( )->from(Meeting::ENTITY_TYPE)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'name', ['dateStart', 'dateStart'], ['dateEnd', 'dateEnd'], ['dateStartDate', 'dateStartDate'], ['dateEndDate', 'dateEndDate'], ['"Meeting"', '_scope'], 'assignedUserId', 'assignedUserName', 'parentType', 'parentId', 'status', 'createdAt', ['null', 'hasAttachment'], ])->leftJoin('MeetingUser', 'usersLeftMiddle', ['usersLeftMiddle.meetingId:' => 'meeting.id', ])
/application/Espo/Modules/Crm/Tools/Meeting/Service.php:1131$actionData = ['eventName' => $entity->get('name'), 'eventType' => $entity->getEntityType( ), 'eventId' => $entity->getId( ), 'dateStart' => $entity->get('dateStart'), 'status' => $status, 'link' => 'users', 'inviteeType' => User::ENTITY_TYPE, 'inviteeId' => $this->user->getId( ), ]
/application/Espo/Modules/Crm/Tools/MassEmail/QueueCreator.php:1311$recordList = $this->entityManager->getRDBRepositoryByClass(TargetList::class)->getRelation($targetList, $link)->select(['id', 'emailAddress'])->sth( )->where(['@relation.optedOut' => false])->find( )
/application/Espo/Modules/Crm/Tools/MassEmail/QueueCreator.php:591$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(EmailQueueItem::ENTITY_TYPE)->where(['massEmailId' => $massEmail->getId( ), 'status' => [EmailQueueItem::STATUS_PENDING, EmailQueueItem::STATUS_FAILED, ], ])->build( )
/application/Espo/Modules/Crm/Tools/KnowledgeBase/Service.php:2231$query = $this->selectBuilderFactory->create( )->from(KnowledgeBaseArticle::ENTITY_TYPE)->withStrictAccessControl( )->withSearchParams($params)->buildQueryBuilder( )->where(['order>' => $currentIndex, ])->order([['order', 'ASC'], ])->build( )
/application/Espo/Modules/Crm/Tools/KnowledgeBase/Service.php:1611$query = $this->selectBuilderFactory->create( )->from(KnowledgeBaseArticle::ENTITY_TYPE)->withStrictAccessControl( )->withSearchParams($params)->buildQueryBuilder( )->where(['order<' => $currentIndex, ])->order([['order', 'DESC'], ])->build( )
/application/Espo/Modules/Crm/Tools/MassEmail/Service.php:741$inboundEmailList = $this->entityManager->getRDBRepository(InboundEmail::ENTITY_TYPE)->where(['useSmtp' => true, 'status' => InboundEmail::STATUS_ACTIVE, 'smtpIsForMassEmail' => true, ['emailAddress!=' => ''], ['emailAddress!=' => null], ])->find( )
/application/Espo/Modules/Crm/Tools/TargetList/RecordService.php:641$updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in($linkEntityType)->set(['deleted' => true])->where(['targetListId' => $entity->getId( )])->build( )
/application/Espo/Modules/Crm/Tools/MassEmail/SendingProcessor.php:4201return $this->entityManager->getRDBRepositoryByClass(EmailQueueItem::class)->sth( )->where(['status' => EmailQueueItem::STATUS_PENDING, 'massEmailId' => $massEmail->getId( ), 'isTest' => $isTest, ])->limit(0, $maxSize)->find( )
/application/Espo/Modules/Crm/Tools/MassEmail/SendingProcessor.php:3741return $this->entityManager->getRDBRepositoryByClass(EmailQueueItem::class)->where(['status' => EmailQueueItem::STATUS_PENDING, 'massEmailId' => $massEmail->getId( ), 'isTest' => false, ])->count( )
/application/Espo/EntryPoints/ChangePassword.php:671$strengthParams = ['passwordGenerateLength' => $this->config->get('passwordGenerateLength'), 'passwordGenerateLetterCount' => $this->config->get('passwordGenerateLetterCount'), 'generateNumberCount' => $this->config->get('generateNumberCount'), 'passwordStrengthLength' => $this->config->get('passwordStrengthLength'), 'passwordStrengthLetterCount' => $this->config->get('passwordStrengthLetterCount'), 'passwordStrengthNumberCount' => $this->config->get('passwordStrengthNumberCount'), 'passwordStrengthBothCases' => $this->config->get('passwordStrengthBothCases'), ]
/application/Espo/ORM/Mapper/BaseMapper.php:8421$query0 = UpdateBuilder::create( )->in($entityType)->where([self::ATTR_ID . '!=' => $entity->getId( ), $key => $id, self::ATTR_DELETED => false, ])->set([$key => null])->build( )
/application/Espo/Hooks/LayoutSet/Removal.php:531$updateQuery1 = $this->entityManager->getQueryBuilder( )->update( )->in(Team::ENTITY_TYPE)->set(['layoutSetId' => null, ])->where(['layoutSetId' => $entity->getId( ), ])->build( )
/application/Espo/Hooks/LayoutSet/Removal.php:691$updateQuery2 = $this->entityManager->getQueryBuilder( )->update( )->in(Portal::ENTITY_TYPE)->set(['layoutSetId' => null, ])->where(['layoutSetId' => $entity->getId( ), ])->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:14831$query = UpdateBuilder::create( )->in($entityType)->where([self::ATTR_ID => $id])->set([self::ATTR_DELETED => false])->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:14221$query = UpdateBuilder::create( )->in($entity->getEntityType( ))->set($valueMap)->where([self::ATTR_ID => $entity->getId( ), self::ATTR_DELETED => false, ])->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:12621$query = InsertBuilder::create( )->into($entity->getEntityType( ))->columns($this->getInsertColumnList($entity))->values($this->getInsertValueMap($entity))->updateSet($update ?? [ ])->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:9561$query = UpdateBuilder::create( )->in($relEntity->getEntityType( ))->where([self::ATTR_ID => $id, self::ATTR_DELETED => false, ])->set($set)->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:9171$query2 = UpdateBuilder::create( )->in($relEntity->getEntityType( ))->where([self::ATTR_ID => $id, self::ATTR_DELETED => false, ])->set([$foreignKey => $entity->getId( )])->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:9081$query1 = UpdateBuilder::create( )->in($relEntity->getEntityType( ))->where([$foreignKey => $entity->getId( ), self::ATTR_DELETED => false, ])->set([$foreignKey => null])->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:8801$query = UpdateBuilder::create( )->in($entityType)->where([self::ATTR_ID => $entity->getId( ), self::ATTR_DELETED => false, ])->set([$key => $relEntity->getId( ), $typeKey => $relEntity->getEntityType( ), ])->build( )
/application/Espo/ORM/Mapper/BaseMapper.php:8581$query = UpdateBuilder::create( )->in($entityType)->where([self::ATTR_ID => $entity->getId( ), self::ATTR_DELETED => false, ])->set([$key => $relEntity->getId( )])->build( )
/application/Espo/Core/Job/QueueUtil.php:3031$runningJobList = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id', 'scheduledJobId', 'executeTime', 'targetId', 'targetType', 'pid', 'startedAt'])->where(['status' => Status::RUNNING, 'executeTime<' => $dateTimeThreshold, ])->find( )
/application/Espo/Core/Job/QueueUtil.php:2711$failedJobList = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id', 'scheduledJobId', 'executeTime', 'targetId', 'targetType', 'pid', 'startedAt', ])->where(['status' => Status::READY, 'startedAt<' => $dateTimeThreshold, ])->find( )
/application/Espo/Core/Job/QueueUtil.php:3911$duplicateJobList = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['scheduledJobId'])->leftJoin('scheduledJob')->where(['scheduledJobId!=' => null, 'status' => Status::PENDING, 'executeTime<=' => DateTimeUtil::getSystemNowString( ), 'scheduledJob.job!=' => $this->metadataProvider->getPreparableJobNameList( ), 'targetId' => null, ])->group(['scheduledJobId'])->having(['COUNT:id>' => 1, ])->order('MAX:executeTime')->find( )
/application/Espo/Core/Job/QueueUtil.php:3541$updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in(JobEntity::ENTITY_TYPE)->set(['status' => Status::FAILED, 'attempts' => 0, ])->where(['id' => $jobIdList, ])->build( )
/application/Espo/Core/Job/QueueUtil.php:4221$toRemoveJobList = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id'])->where(['scheduledJobId' => $scheduledJobId, 'status' => Status::PENDING, ])->order('executeTime')->limit(0, 1000)->find( )
/application/Espo/Core/Job/QueueUtil.php:4591$jobCollection = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id', 'attempts', 'failedAttempts', ])->where(['status' => Status::FAILED, 'executeTime<=' => DateTimeUtil::getSystemNowString( ), 'attempts>' => 0, ])->find( )
/application/Espo/Core/Job/JobScheduler.php:1801return $this->entityManager->createEntity(JobEntity::ENTITY_TYPE, ['name' => $this->className, 'className' => $this->className, 'queue' => $this->queue, 'group' => $this->group, 'targetType' => $data->getTargetType( ), 'targetId' => $data->getTargetId( ), 'data' => $data->getRaw( ), 'executeTime' => $time->format(DateTime::SYSTEM_DATE_TIME_FORMAT), ])
/application/Espo/Core/Job/AsyncPoolFactory.php:481return Pool::create( )->autoload(getcwd( ) . '/vendor/autoload.php')->concurrency($this->config->get('jobPoolConcurrencyNumber'))->timeout($this->config->get('jobPeriodForActiveProcess'))
/application/Espo/Core/Job/Preparator/CollectionHelper.php:671$running = $this->entityManager->getRDBRepository(Job::ENTITY_TYPE)->select('id')->where(['scheduledJobId' => $data->getId( ), 'status' => [Status::RUNNING, Status::READY, ], 'targetType' => $entity->getEntityType( ), 'targetId' => $entity->getId( ), ])->findOne( )
/application/Espo/Core/Job/Preparator/CollectionHelper.php:851$countPending = $this->entityManager->getRDBRepository(Job::ENTITY_TYPE)->where(['scheduledJobId' => $data->getId( ), 'status' => Status::PENDING, 'targetType' => $entity->getEntityType( ), 'targetId' => $entity->getId( ), ])->count( )
/application/Espo/Core/Job/Preparator/Preparators/ProcessJobGroupPreparator.php:521$query = $this->entityManager->getQueryBuilder( )->select('group')->from(JobEntity::ENTITY_TYPE)->where(['status' => Status::PENDING, 'queue' => null, 'group!=' => null, 'executeTime<=' => $executeTime->format(DateTime::SYSTEM_DATE_TIME_FORMAT), ])->group('group')->build( )
/application/Espo/Core/Job/Preparator/Preparators/ProcessJobGroupPreparator.php:821$existingJob = $this->entityManager->getRDBRepository(JobEntity::ENTITY_TYPE)->select('id')->where(['scheduledJobId' => $data->getId( ), 'targetGroup' => $group, 'status' => [Status::RUNNING, Status::READY, Status::PENDING, ], ])->findOne( )
/application/Espo/Core/Utils/Database/Orm/FieldConverters/PersonName.php:1111$attributeDefs = AttributeDefs::create($name)->withType(AttributeType::VARCHAR)->withNotStorable( )->withParamsMerged(['select' => ['select' => $selectExpression, ], 'selectForeign' => ['select' => $selectForeignExpression, ], 'where' => ['LIKE' => ['whereClause' => ['OR' => array_fill_keys(array_map(fn ($item) => $item . '*', $whereItems), '{value}'), ], ], 'NOT LIKE' => ['whereClause' => ['AND' => array_fill_keys(array_map(fn ($item) => $item . '!*', $whereItems), '{value}'), ], ], '=' => ['whereClause' => ['OR' => array_fill_keys($whereItems, '{value}'), ], ], ], 'order' => ['order' => [[$orderBy1Field, '{direction}'], [$orderBy2Field, '{direction}'], ], ], ])
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Currency.php:2761$convertedDefs = AttributeDefs::create($name . 'Converted')->withType(AttributeType::FLOAT)->withParamsMerged(['select' => ['select' => $mulExpression, 'leftJoins' => $leftJoins, ], 'selectForeign' => ['select' => "MUL:({alias}.{$name}, {$foreignCurrencyAlias}.rate)", 'leftJoins' => [['Currency', $foreignCurrencyAlias, [$foreignCurrencyAlias . '.id:' => "{alias}.{$name}Currency"]]], ], 'where' => ["=" => ['whereClause' => [$mulExpression . '=' => '{value}'], 'leftJoins' => $leftJoins, ], ">" => ['whereClause' => [$mulExpression . '>' => '{value}'], 'leftJoins' => $leftJoins, ], "<" => ['whereClause' => [$mulExpression . '<' => '{value}'], 'leftJoins' => $leftJoins, ], ">=" => ['whereClause' => [$mulExpression . '>=' => '{value}'], 'leftJoins' => $leftJoins, ], "<=" => ['whereClause' => [$mulExpression . '<=' => '{value}'], 'leftJoins' => $leftJoins, ], "<>" => ['whereClause' => [$mulExpression . '!=' => '{value}'], 'leftJoins' => $leftJoins, ], "IS NULL" => ['whereClause' => [$name . '=' => null], ], "IS NOT NULL" => ['whereClause' => [$name . '!=' => null], ], ], 'notStorable' => true, 'order' => ['order' => [[$mulExpression, '{direction}'], ], 'leftJoins' => $leftJoins, 'additionalSelect' => ["{$alias}.rate"], ], 'attributeRole' => 'valueConverted', 'fieldType' => 'currency', ])
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Currency.php:1431$convertedDefs = AttributeDefs::create($name . 'Converted')->withType(AttributeType::FLOAT)->withParamsMerged(['select' => ['select' => $expr, ], 'selectForeign' => ['select' => $exprForeign, ], 'where' => ["=" => ['whereClause' => [$expr . '=' => '{value}', ], ], ">" => ['whereClause' => [$expr . '>' => '{value}', ], ], "<" => ['whereClause' => [$expr . '<' => '{value}', ], ], ">=" => ['whereClause' => [$expr . '>=' => '{value}', ], ], "<=" => ['whereClause' => [$expr . '<=' => '{value}', ], ], "<>" => ['whereClause' => [$expr . '!=' => '{value}', ], ], "IS NULL" => ['whereClause' => [$expr . '=' => null, ], ], "IS NOT NULL" => ['whereClause' => [$expr . '!=' => null, ], ], ], 'notStorable' => true, 'order' => ['order' => [[$expr, '{direction}'], ], ], 'attributeRole' => 'valueConverted', 'fieldType' => 'currency', ])
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Currency.php:1321$exprForeign = Expr::multiply(Expr::column("ALIAS.{$name}"), Expr::if(Expr::equal(Expr::column("ALIAS.{$name}Currency"), $defaultCurrency), 1.0, $this->buildExpression("ALIAS.{$name}Currency", $rates)))->getValue( )
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Phone.php:3321return ['select' => ['select' => 'phoneNumbers.invalid', 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], ], 'selectForeign' => ['select' => "$foreignJoinAlias.invalid", 'leftJoins' => [['EntityPhoneNumber', $foreignJoinMiddleAlias, ["$foreignJoinMiddleAlias.entityId:" => "{alias}.id", "$foreignJoinMiddleAlias.primary" => true, "$foreignJoinMiddleAlias.deleted" => false, ]], [PhoneNumber::ENTITY_TYPE, $foreignJoinAlias, ["$foreignJoinAlias.id:" => "$foreignJoinMiddleAlias.phoneNumberId", "$foreignJoinAlias.deleted" => false, ]]], ], 'where' => ['= TRUE' => ['whereClause' => [['phoneNumbers.invalid=' => true], ['phoneNumbers.invalid!=' => null], ], 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], ], '= FALSE' => ['whereClause' => ['OR' => [['phoneNumbers.invalid=' => false], ['phoneNumbers.invalid=' => null], ]], 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], ]], 'order' => ['order' => [['phoneNumbers.invalid', '{direction}'], ], 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], 'additionalSelect' => ['phoneNumbers.invalid'], ], ]
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Phone.php:2721return ['select' => ['select' => 'phoneNumbers.optOut', 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], ], 'selectForeign' => ['select' => "$foreignJoinAlias.optOut", 'leftJoins' => [['EntityPhoneNumber', $foreignJoinMiddleAlias, ["$foreignJoinMiddleAlias.entityId:" => "{alias}.id", "$foreignJoinMiddleAlias.primary" => true, "$foreignJoinMiddleAlias.deleted" => false, ]], [PhoneNumber::ENTITY_TYPE, $foreignJoinAlias, ["$foreignJoinAlias.id:" => "$foreignJoinMiddleAlias.phoneNumberId", "$foreignJoinAlias.deleted" => false, ]]], ], 'where' => ['= TRUE' => ['whereClause' => [['phoneNumbers.optOut=' => true], ['phoneNumbers.optOut!=' => null], ], 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], ], '= FALSE' => ['whereClause' => ['OR' => [['phoneNumbers.optOut=' => false], ['phoneNumbers.optOut=' => null], ]], 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], ]], 'order' => ['order' => [['phoneNumbers.optOut', '{direction}'], ], 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], 'additionalSelect' => ['phoneNumbers.optOut'], ], ]
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Phone.php:1341return ['select' => ["select" => "phoneNumbers.name", 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], ], 'selectForeign' => ["select" => "$foreignJoinAlias.name", 'leftJoins' => [['EntityPhoneNumber', $foreignJoinMiddleAlias, ["$foreignJoinMiddleAlias.entityId:" => "{alias}.id", "$foreignJoinMiddleAlias.primary" => true, "$foreignJoinMiddleAlias.deleted" => false, ]], [PhoneNumber::ENTITY_TYPE, $foreignJoinAlias, ["$foreignJoinAlias.id:" => "$foreignJoinMiddleAlias.phoneNumberId", "$foreignJoinAlias.deleted" => false, ]]], ], 'fieldType' => 'phone', 'where' => ['LIKE' => ['whereClause' => ['id=s' => ['from' => 'EntityPhoneNumber', 'select' => ['entityId'], 'joins' => [['phoneNumber', 'phoneNumber', ['phoneNumber.id:' => 'phoneNumberId', 'phoneNumber.deleted' => false, ], ], ], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, 'phoneNumber.name*' => '{value}', ], ], ], ], 'NOT LIKE' => ['whereClause' => ['id!=s' => ['from' => 'EntityPhoneNumber', 'select' => ['entityId'], 'joins' => [['phoneNumber', 'phoneNumber', ['phoneNumber.id:' => 'phoneNumberId', 'phoneNumber.deleted' => false, ], ], ], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, 'phoneNumber.name*' => '{value}', ], ], ], ], '=' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.name=' => '{value}', ], 'distinct' => true, ], '<>' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.name!=' => '{value}', ], 'distinct' => true, ], 'IN' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.name=' => '{value}', ], 'distinct' => true, ], 'NOT IN' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.name!=' => '{value}', ], 'distinct' => true, ], 'IS NULL' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.name=' => null, ], 'distinct' => true, ], 'IS NOT NULL' => ['whereClause' => ['id=s' => ['from' => 'EntityPhoneNumber', 'select' => ['entityId'], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, ], ], ], ], ], 'order' => ['order' => [['phoneNumbers.name', '{direction}'], ], 'leftJoins' => [['phoneNumbers', 'phoneNumbers', ['primary' => true]]], 'additionalSelect' => ['phoneNumbers.name'], ], ]
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Phone.php:961$relationDefs = RelationDefs::create('phoneNumbers')->withType(RelationType::MANY_MANY)->withForeignEntityType(PhoneNumber::ENTITY_TYPE)->withRelationshipName('entityPhoneNumber')->withMidKeys('entityId', 'phoneNumberId')->withConditions(['entityType' => $entityType])->withAdditionalColumn(AttributeDefs::create('entityType')->withType(AttributeType::VARCHAR)->withLength(self::COLUMN_ENTITY_TYPE_LENGTH))->withAdditionalColumn(AttributeDefs::create('primary')->withType(AttributeType::BOOL)->withDefault(false))
/application/Espo/Core/Repositories/Event.php:1621return array_merge($this->metadata->get("scopes.$this->entityType.completedStatusList") ?? [ ], $this->metadata->get("scopes.$this->entityType.canceledStatusList") ?? [ ], )
/application/Espo/Core/Repositories/Event.php:1171$delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Reminder::ENTITY_TYPE)->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( )
/application/Espo/Core/Utils/DateTime/DateTimeFactory.php:621return $this->injectableFactory->createWith(DateTime::class, ['timeZone' => $timeZone, 'dateFormat' => $this->config->get('dateFormat'), 'timeFormat' => $this->config->get('timeFormat'), 'language' => $this->config->get('language'), ])
/application/Espo/Core/Utils/Database/Orm/FieldConverters/Phone.php:3921return ['notExportable' => true, 'where' => ['LIKE' => ['whereClause' => ['id=s' => ['from' => 'EntityPhoneNumber', 'select' => ['entityId'], 'joins' => [['phoneNumber', 'phoneNumber', ['phoneNumber.id:' => 'phoneNumberId', 'phoneNumber.deleted' => false, ], ], ], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, 'phoneNumber.numeric*' => '{value}', ], ], ], ], 'NOT LIKE' => ['whereClause' => ['id!=s' => ['from' => 'EntityPhoneNumber', 'select' => ['entityId'], 'joins' => [['phoneNumber', 'phoneNumber', ['phoneNumber.id:' => 'phoneNumberId', 'phoneNumber.deleted' => false, ], ]], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, 'phoneNumber.numeric*' => '{value}', ], ], ], ], '=' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.numeric=' => '{value}', ], 'distinct' => true], '<>' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.numeric!=' => '{value}', ], 'distinct' => true], 'IN' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.numeric=' => '{value}', ], 'distinct' => true], 'NOT IN' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.numeric!=' => '{value}', ], 'distinct' => true], 'IS NULL' => ['leftJoins' => [['phoneNumbers', 'phoneNumbersMultiple']], 'whereClause' => ['phoneNumbersMultiple.numeric=' => null, ], 'distinct' => true], 'IS NOT NULL' => ['whereClause' => ['id=s' => ['from' => 'EntityPhoneNumber', 'select' => ['entityId'], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, ], ], ], ], ], ]
/application/Espo/Core/Repositories/CategoryTree.php:1091$delete = $em->getQueryBuilder( )->delete( )->from($pathEntityType, 'a')->join($pathEntityType, 'd', ['d.descendorId:' => 'a.descendorId', ])->leftJoin($pathEntityType, 'x', ['x.ascendorId:' => 'd.descendorId', 'x.descendorId:' => 'a.ascendorId', ])->where(['d.descendorId' => $entity->getId( ), 'x.ascendorId' => null, ])->build( )
/application/Espo/Core/Repositories/CategoryTree.php:901$insert = $em->getQueryBuilder( )->insert( )->into($pathEntityType)->columns(['ascendorId', 'descendorId'])->values(['ascendorId' => $entity->getId( ), 'descendorId' => $entity->getId( ), ])->build( )
/application/Espo/Core/Repositories/CategoryTree.php:661$subSelect2 = $em->getQueryBuilder( )->select( )->select(["'" . $entity->getId( ) . "'", "'" . $entity->getId( ) . "'"])->build( )
/application/Espo/Core/Repositories/CategoryTree.php:571$subSelect1 = $em->getQueryBuilder( )->select( )->from($pathEntityType)->select(['ascendorId', "'" . $entity->getId( ) . "'"])->where(['descendorId' => $parentId, ])->build( )
/application/Espo/Core/Field/Address/AddressFactory.php:461return (new AddressBuilder( ))->setStreet($entity->get($field . 'Street'))->setCity($entity->get($field . 'City'))->setCountry($entity->get($field . 'Country'))->setState($entity->get($field . 'State'))->setPostalCode($entity->get($field . 'PostalCode'))->build( )
/application/Espo/Core/Field/Address/AddressAttributeExtractor.php:501return (object) [$field . 'Street' => $value->getStreet( ), $field . 'City' => $value->getCity( ), $field . 'Country' => $value->getCountry( ), $field . 'State' => $value->getState( ), $field . 'PostalCode' => $value->getPostalCode( ), ]
/application/Espo/Core/Repositories/CategoryTree.php:1361$select = $em->getQueryBuilder( )->select( )->from($pathEntityType)->select(['ascendorId', 's.descendorId'])->join($pathEntityType, 's')->where(['s.ascendorId' => $entity->getId( ), 'descendorId' => $parentId, ])->build( )
/application/Espo/Core/Field/PhoneNumber/PhoneNumberGroupAttributeExtractor.php:581$dataList[] = (object) ['phoneNumber' => $phoneNumber->getNumber( ), 'type' => $phoneNumber->getType( ), 'primary' => $primaryNumber && $phoneNumber->getNumber( ) === $primaryNumber, 'optOut' => $phoneNumber->isOptedOut( ), 'invalid' => $phoneNumber->isInvalid( ), ]
/application/Espo/Core/Duplicate/Finder.php:1331$query = $this->selectBuilderFactory->create( )->from($entityType)->withStrictAccessControl( )->buildQueryBuilder( )->where($where)->select(['id'])->limit(0, self::LIMIT)->build( )
/application/Espo/Core/Action/Actions/Merge/Merger.php:2311$updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in('Note')->set(['parentId' => $targetEntity->getId( ), 'parentType' => $targetEntity->getEntityType( ), ])->where(['type' => ['Post', 'EmailSent', 'EmailReceived'], 'parentId' => $sourceEntity->getId( ), 'parentType' => $sourceEntity->getEntityType( ), ])->build( )
/application/Espo/Core/Field/EmailAddress/EmailAddressGroupAttributeExtractor.php:581$dataList[] = (object) ['emailAddress' => $emailAddress->getAddress( ), 'lower' => strtolower($emailAddress->getAddress( )), 'primary' => $primaryAddress && $emailAddress->getAddress( ) === $primaryAddress, 'optOut' => $emailAddress->isOptedOut( ), 'invalid' => $emailAddress->isInvalid( ), ]
/application/Espo/Core/ExternalAccount/ClientManager.php:2341$params = ['endpoint' => $this->metadata->get("integrations.{$integration}.params.endpoint"), 'tokenEndpoint' => $this->metadata->get("integrations.{$integration}.params.tokenEndpoint"), 'clientId' => $integrationEntity->get('clientId'), 'clientSecret' => $integrationEntity->get('clientSecret'), 'redirectUri' => $redirectUri, 'accessToken' => $externalAccountEntity->get('accessToken'), 'refreshToken' => $externalAccountEntity->get('refreshToken'), 'tokenType' => $externalAccountEntity->get('tokenType'), 'expiresAt' => $externalAccountEntity->get('expiresAt'), ]
/application/Espo/Core/Formula/Parser.php:7491return substr($string, $i, 5) === 'while' && ($i === 0 || $this->isWhiteSpace($before) || $before === ';') && ($this->isWhiteSpace($after) || $after === '(')
/application/Espo/Core/Formula/Parser.php:11151$parsedPart = $statement->getElseKeywordEnd( ) ? new Node('ifThenElse', [$this->split($conditionPart), $this->split($thenPart, true), $this->split($elsePart ?? '', true)]) : new Node('ifThen', [$this->split($conditionPart), $this->split($thenPart, true)])
/application/Espo/Core/Formula/Parser.php:7241return substr($string, $i, 2) === 'if' && ($i === 0 || $this->isWhiteSpace($before) || $before === ';') && ($this->isWhiteSpace($after) || $after === '(')
/application/Espo/Core/Formula/Parser.php:7391return substr($string, $i, 4) === 'else' && $this->isWhiteSpaceCharOrBraceOpen(substr($string, $i + 4, 1)) && $this->isWhiteSpaceCharOrBraceClose(substr($string, $i - 1, 1))
/application/Espo/Core/Job/QueueUtil.php:1871$job = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id'])->where(['scheduledJobId' => $scheduledJobId, 'status' => [Status::PENDING, Status::READY, Status::RUNNING, Status::SUCCESS, ], 'executeTime>=' => $fromString, 'executeTime<=' => $toString, ])->findOne( )
/application/Espo/Core/Job/QueueUtil.php:2341$runningJobList = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id', 'scheduledJobId', 'executeTime', 'targetId', 'targetType', 'pid', 'startedAt', ])->where(['status' => Status::RUNNING, 'startedAt<' => $dateTimeThreshold, ])->find( )
/application/Espo/Core/Job/QueueUtil.php:781$builder = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id', 'scheduledJobId', 'scheduledJobJob', 'executeTime', 'targetId', 'targetType', 'targetGroup', 'methodName', 'serviceName', 'className', 'job', 'data', ])->where(['status' => Status::PENDING, 'executeTime<=' => DateTimeUtil::getSystemNowString( ), 'queue' => $queue, 'group' => $group, ])->order('number')
/application/Espo/Core/Job/QueueUtil.php:1471$jobList = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['scheduledJobId'])->leftJoin('scheduledJob')->where(['status' => [Status::RUNNING, Status::READY, ], 'scheduledJobId!=' => null, 'scheduledJob.job!=' => $this->metadataProvider->getPreparableJobNameList( ), ])->order('executeTime')->find( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:14921return Cond::in(Cond::column('id'), QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin(Join::create($link, $alias)->withConditions(Cond::equal(Cond::column("$alias.$nearKey"), Cond::column('id')))->withOnlyMiddle( ))->where(["$alias.$key" => $value])->build( ))->getRaw( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:14461$subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($link, $alias)->where([$alias . '.id!=' => null])->build( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:15621return Cond::not(Cond::exists(QueryBuilder::create( )->from($this->entityType, 'sq')->join(Join::create($link, $alias)->withOnlyMiddle( ))->where(["$alias.$key" => $value])->where(Cond::equal(Cond::column('sq.id'), Cond::column(lcfirst($this->entityType) . '.id')))->build( )))->getRaw( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:15161$subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($link, $alias)->where([$alias . '.id' => $value])->build( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:13751$subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($middleEntityType, $alias, ["$alias.$nearKey:" => 'id', "$alias.deleted" => false, ])->where(["$alias.$key" => null])->build( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:134711return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:14271$subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($middleEntityType, $alias, ["$alias.$nearKey:" => 'id', "$alias.deleted" => false, ])->where(["$alias.$key!=" => null])->build( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:13941$subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($link, $alias)->where([$alias . '.id' => null])->build( )
/application/Espo/Core/FieldProcessing/Reminder/Saver.php:821$toProcess = $entity->isNew( ) || $entity->isAttributeChanged('assignedUserId') || ($entity->hasLinkMultipleField('assignedUsers') && $entity->isAttributeChanged('assignedUsersIds')) || ($entity->hasLinkMultipleField('users') && $entity->isAttributeChanged('usersIds')) || $entity->isAttributeChanged($dateAttribute) || $entity->has('reminders')
/application/Espo/Core/FieldProcessing/Reminder/Loader.php:751$collection = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->select(['seconds', 'type'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), ])->distinct( )->order('seconds')->find( )
/application/Espo/Core/FieldProcessing/Reminder/Saver.php:1711$query = $this->entityManager->getQueryBuilder( )->insert( )->into(Reminder::ENTITY_TYPE)->columns(['id', 'entityId', 'entityType', 'type', 'userId', 'remindAt', 'startAt', 'seconds', ])->values(['id' => $reminderId, 'entityId' => $entity->getId( ), 'entityType' => $entityType, 'type' => $type, 'userId' => $userId, 'remindAt' => $remindAt->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), 'startAt' => $dateValue, 'seconds' => $seconds, ])->build( )
/application/Espo/Core/FieldProcessing/Reminder/Saver.php:1051$query = $this->entityManager->getQueryBuilder( )->delete( )->from(Reminder::ENTITY_TYPE)->where(['entityId' => $entity->getId( ), 'entityType' => $entityType, 'deleted' => false, ])->build( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:16401$sq = QueryBuilder::create( )->from($this->entityType)->select('id')->leftJoin($link)->where([$link . 'Middle.' . $key => $targetId, ])->build( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:15861return Cond::not(Cond::exists(QueryBuilder::create( )->select('id')->from($this->entityType, 'sq')->join($link, $alias)->where(["$alias.id" => $value])->where(['sq.id:' => lcfirst($this->entityType) . '.id'])->build( )))->getRaw( )
/application/Espo/Core/FieldProcessing/Relation/Saver.php:1781$anotherEntity = $this->entityManager->getRDBRepository($entityType)->select(['id'])->where([$idAttribute => $entity->get($idAttribute), 'id!=' => $entity->getId( ), ])->findOne( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:16591$sq = QueryBuilder::create( )->from($this->entityType)->select('id')->leftJoin($link)->where([$link . '.id' => $targetId])->build( )
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:3711$update2 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityPhoneNumber')->set(['primary' => true])->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'phoneNumberId' => $phoneNumber->getId( ), 'deleted' => false, ])->build( )
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:5551$update = $this->entityManager->getQueryBuilder( )->update( )->in('EntityPhoneNumber')->set(['primary' => true])->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'phoneNumberId' => $phoneNumberNew->getId( ), ])->build( )
/application/Espo/Core/FieldProcessing/NextNumber/BeforeSaveProcessor.php:1081$nextNumber = $this->entityManager->getRDBRepository(NextNumber::ENTITY_TYPE)->where(['fieldName' => $field, 'entityType' => $entity->getEntityType( ), ])->forUpdate( )->findOne( )
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:2131$changed = $hash->{$key}['optOut'] != $hashPrevious->{$key}['optOut'] || $hash->{$key}['invalid'] != $hashPrevious->{$key}['invalid'] || $hash->{$key}['emailAddress'] !== $hashPrevious->{$key}['emailAddress']
/application/Espo/Core/FieldProcessing/Reminder/Saver.php:2091$reminderCollection = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->select(['seconds', 'type'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), ])->distinct( )->order('seconds')->find( )
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:2181$changed = $hash->{$key}['type'] != $hashPrevious->{$key}['type'] || $hash->{$key}['optOut'] != $hashPrevious->{$key}['optOut'] || $hash->{$key}['invalid'] != $hashPrevious->{$key}['invalid']
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:2531$delete = $this->entityManager->getQueryBuilder( )->delete( )->from('EntityPhoneNumber')->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'phoneNumberId' => $phoneNumber->getId( ), ])->build( )
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:3561$update1 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityPhoneNumber')->set(['primary' => false])->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'primary' => true, 'deleted' => false, ])->build( )
/application/Espo/Core/Controllers/RecordTree.php:921return (object) ['list' => $collection->getValueMapList( ), 'path' => $this->getRecordTreeService( )->getTreeItemPath($parentId), 'data' => $this->getRecordTreeService( )->getCategoryData($parentId), ]
/application/Espo/Core/Loaders/DateTime.php:431return new DateTimeService($this->config->get('dateFormat'), $this->config->get('timeFormat'), $this->config->get('timeZone'), $this->config->get('language'))
/application/Espo/Core/Loaders/Language.php:492return $this->injectableFactory->createWith(LanguageService::class, ['language' => LanguageService::detectLanguage($this->config, $this->preferences), 'useCache' => $this->config->get('useCache') ?? false, ])
/application/Espo/Core/Authentication/Authentication.php:3211$authLogRecord = $this->entityManager->getRDBRepository(AuthLogRecord::ENTITY_TYPE)->select(['id'])->where(['authTokenId' => $authToken->getId( )])->order('requestTime', true)->findOne( )
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:2481$delete = $this->entityManager->getQueryBuilder( )->delete( )->from('EntityEmailAddress')->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'emailAddressId' => $emailAddress->getId( ), ])->build( )
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:3481$update1 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityEmailAddress')->set(['primary' => false])->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'primary' => true, 'deleted' => false, ])->build( )
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:3631$update2 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityEmailAddress')->set(['primary' => true])->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'emailAddressId' => $emailAddress->getId( ), 'deleted' => false, ])->build( )
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:5071$updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in('EntityEmailAddress')->set(['primary' => true])->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'emailAddressId' => $emailAddressNew->getId( ), ])->build( )
/application/Espo/Core/ORM/QueryComposer/QueryComposerFactory.php:731$bindingContainer = BindingContainerBuilder::create( )->bindInstance(PDO::class, $this->pdoProvider->get( ))->bindInstance(OrmMetadata::class, $this->ormMetadata)->bindInstance(EntityFactory::class, $this->entityFactory)->bindInstance(FunctionConverterFactory::class, $this->functionConverterFactory)->bindInstance(EventDispatcher::class, $this->eventDispatcher)->build( )
/application/Espo/Core/ORM/DatabaseParamsFactory.php:801return DatabaseParams::create( )->withHost($params['host'] ?? $configParams->getHost( ))->withPort(isset($params['port']) ? (int) $params['port'] : $configParams->getPort( ))->withName($params['dbname'] ?? $configParams->getName( ))->withUsername($params['user'] ?? $configParams->getUsername( ))->withPassword($params['password'] ?? $configParams->getPassword( ))->withCharset($params['charset'] ?? $configParams->getCharset( ))->withPlatform($params['platform'] ?? $configParams->getPlatform( ))->withSslCa($params['sslCA'] ?? $configParams->getSslCa( ))->withSslCert($params['sslCert'] ?? $configParams->getSslCert( ))->withSslKey($params['sslKey'] ?? $configParams->getSslKey( ))->withSslCaPath($params['sslCAPath'] ?? $configParams->getSslCaPath( ))->withSslCipher($params['sslCipher'] ?? $configParams->getSslCipher( ))->withSslVerifyDisabled($params['sslVerifyDisabled'] ?? $configParams->isSslVerifyDisabled( ))
/application/Espo/Core/ORM/DatabaseParamsFactory.php:511$databaseParams = DatabaseParams::create( )->withHost($config->get('database.host'))->withPort($config->get('database.port') ? (int) $config->get('database.port') : null)->withName($config->get('database.dbname'))->withUsername($config->get('database.user'))->withPassword($config->get('database.password'))->withCharset($config->get('database.charset'))->withPlatform($config->get('database.platform'))->withSslCa($config->get('database.sslCA'))->withSslCert($config->get('database.sslCert'))->withSslKey($config->get('database.sslKey'))->withSslCaPath($config->get('database.sslCAPath'))->withSslCipher($config->get('database.sslCipher'))->withSslVerifyDisabled($config->get('database.sslVerifyDisabled') ?? false)
/application/Espo/Core/ORM/RepositoryFactory.php:521return $this->injectableFactory->createWithBinding($className, BindingContainerBuilder::create( )->bindInstance(EntityFactoryInterface::class, $this->entityFactory)->bindInstance(EntityFactory::class, $this->entityFactory)->inContext($className, function (ContextualBinder $binder) use ($entityType) { /**/ } )->build( ))
/application/Espo/Core/ORM/EntityManagerFactory.php:1311$binding = BindingContainerBuilder::create( )->bindInstance(DatabaseParams::class, $databaseParams)->bindInstance(Metadata::class, $metadata)->bindInstance(QueryComposerFactoryInterface::class, $queryComposerFactory)->bindInstance(RepositoryFactoryInterface::class, $repositoryFactory)->bindInstance(EntityFactoryInterface::class, $entityFactory)->bindInstance(ValueFactoryFactoryInterface::class, $valueFactoryFactory)->bindInstance(AttributeExtractorFactoryInterface::class, $attributeExtractorFactory)->bindInstance(EventDispatcher::class, $this->eventDispatcher)->bindInstance(PDOProvider::class, $pdoProvider)->bindInstance(FunctionConverterFactoryInterface::class, $functionConverterFactory)->bindInstance(SqlExecutor::class, $sqlExecutor)->build( )
/application/Espo/Core/ORM/EntityManagerFactory.php:1131$queryComposerFactory = $this->injectableFactory->createWithBinding(QueryComposerFactory::class, BindingContainerBuilder::create( )->bindInstance(PDOProvider::class, $pdoProvider)->bindInstance(Metadata::class, $metadata)->bindInstance(EventDispatcher::class, $this->eventDispatcher)->bindInstance(EntityFactoryInterface::class, $entityFactory)->bindInstance(FunctionConverterFactoryInterface::class, $functionConverterFactory)->build( ))
/application/Espo/Core/Upgrades/Actions/Extension/Install.php:1801$data = ['id' => $this->getProcessId( ), 'name' => trim($manifest['name']), 'isInstalled' => true, 'version' => $manifest['version'], 'fileList' => $fileList, 'description' => $manifest['description'], ]
/application/Espo/Core/Api/Auth.php:2071$bodyData = ['status' => $result->getStatus( ), 'message' => $result->getMessage( ), 'view' => $result->getView( ), 'token' => $result->getToken( ), 'data' => $result->getData( ), ]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:5541$subQuery = QueryBuilder::create( )->select('entityId')->from(ArrayValue::ENTITY_TYPE)->where(['entityType' => $arrayEntityType, 'attribute' => $arrayAttribute, 'value' => $value, ])->build( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:4111return [$key => Select::fromRaw(['select' => ['id'], 'from' => $this->entityType, 'whereClause' => $whereClause, 'leftJoins' => $rawParams['leftJoins'] ?? [ ], 'joins' => $rawParams['joins'] ?? [ ], ]), ]
/application/Espo/Core/Select/Bool/Filters/OnlyMy.php:761$subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($middleEntityType, 'assignedUsersMiddle', ["assignedUsersMiddle.$key1:" => 'id', 'assignedUsersMiddle.deleted' => false, ])->where(["assignedUsersMiddle.$key2" => $this->user->getId( )])->build( )
/application/Espo/Core/Select/AccessControl/Filters/OnlyOwn.php:581$subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($middleEntityType, 'assignedUsersMiddle', ["assignedUsersMiddle.{$key1}:" => 'id', 'assignedUsersMiddle.deleted' => false, ])->where(["assignedUsersMiddle.{$key2}" => $this->user->getId( )])->build( )
/application/Espo/Core/Select/AccessControl/Filters/OnlyTeam.php:561$subQueryBuilder = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin(Team::RELATIONSHIP_ENTITY_TEAM, 'entityTeam', ['entityTeam.entityId:' => 'id', 'entityTeam.entityType' => $this->entityType, 'entityTeam.deleted' => false, ])
/application/Espo/Core/Select/Order/ItemConverters/AddressType.php:451return OrderList::create([Order::fromString($orderBy . 'Country')->withDirection($order), Order::fromString($orderBy . 'City')->withDirection($order), Order::fromString($orderBy . 'Street')->withDirection($order), ])
/application/Espo/Core/Select/SelectManager.php:15972$part['AND'] = [$attribute . '>=' => $dt->add(new DateInterval('P' . (($quarter - 1) * 3) . 'M'))->format('Y-m-d'), $attribute . '<' => $dt->add(new DateInterval('P3M'))->format('Y-m-d'), ]
/application/Espo/Core/Select/SelectManager.php:15822$part['AND'] = [$attribute . '>=' => $dt->add(new DateInterval('P' . (($quarter - 1) * 3) . 'M'))->format('Y-m-d'), $attribute . '<' => $dt->add(new DateInterval('P3M'))->format('Y-m-d'), ]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:110411return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:112311return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:10282return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<=' => $today->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:10491return ['AND' => [$attribute . '>=' => $today->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<=' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:6291$whereList[] = [$idPart . '=s' => QueryBuilder::create( )->from(ArrayValue::ENTITY_TYPE)->select('entityId')->where(['value' => $arrayValue, 'attribute' => $arrayAttribute, 'entityType' => $arrayEntityType, 'deleted' => false, ])->build( )]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:10072return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<=' => $today->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:5721return Cond::not(Cond::exists(QueryBuilder::create( )->select('entityId')->from(ArrayValue::ENTITY_TYPE)->where(['entityType' => $arrayEntityType, 'attribute' => $arrayAttribute, 'value' => $value, 'entityId:' => lcfirst($arrayEntityType) . '.id'])->build( )))->getRaw( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:5891return Cond::not(Cond::exists(QueryBuilder::create( )->select('entityId')->from(ArrayValue::ENTITY_TYPE)->where(['entityType' => $arrayEntityType, 'attribute' => $arrayAttribute, 'entityId:' => lcfirst($arrayEntityType) . '.id'])->build( )))->getRaw( )
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:129211return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:131911return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:123511return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:126311return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:119711return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:121611return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:114211return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Core/Select/Where/ItemGeneralConverter.php:116611return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]]
/application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:851$openedCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_OPENED, 'isTest' => false, ])->count( )
/application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:1041$clickedCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_CLICKED, 'isTest' => false, 'id=s' => SelectBuilder::create( )->select('MIN:id')->from(CampaignLogRecord::ENTITY_TYPE)->where(['action' => CampaignLogRecord::ACTION_CLICKED, 'isTest' => false, 'campaignId' => $entity->getId( ), ])->group('queueItemId')->build( )->getRaw( ), ])->count( )
/application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:1371$optedInCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_OPTED_IN, 'isTest' => false, ])->count( )
/application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:1521$optedOutCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_OPTED_OUT, 'isTest' => false, ])->count( )
/application/Espo/Modules/Crm/Classes/RecordHooks/TargetList/AfterCreate.php:1061$queryBuilder = $this->entityManager->getQueryBuilder( )->select( )->from(CampaignLogRecord::ENTITY_TYPE)->select(['id', 'parentId', 'parentType'])->where(['isTest' => false, 'campaignId' => $sourceCampaignId, ])
/application/Espo/Modules/Crm/Classes/Select/Meeting/Where/DateTimeItemTransformer.php:931$raw = ['type' => Item::TYPE_OR, 'value' => [$datePartRaw, ['type' => Item::TYPE_AND, 'value' => [$transformedItem->getRaw( ), ['type' => Item\Type::IS_NULL, 'attribute' => $attributeDate, ]]]]]
/application/Espo/Modules/Crm/Classes/FieldProcessing/Meeting/AcceptanceStatusLoader.php:671$user = $this->entityManager->getRDBRepository($entity->getEntityType( ))->getRelation($entity, 'users')->where(['id' => $this->user->getId( ), ])->select([$attribute])->findOne( )
/application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:701$sentCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_SENT, 'isTest' => false, ])->count( )
/application/Espo/Modules/Crm/Tools/Activities/Service.php:10821$builder = $this->selectBuilderFactory->create( )->from($scope)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'name', ($seed->hasAttribute('dateStart') ? ['dateStart', 'dateStart'] : ['null', 'dateStart']), ($seed->hasAttribute('dateEnd') ? ['dateEnd', 'dateEnd'] : ['null', 'dateEnd']), ($seed->hasAttribute('dateStartDate') ? ['dateStartDate', 'dateStartDate'] : ['null', 'dateStartDate']), ($seed->hasAttribute('dateEndDate') ? ['dateEndDate', 'dateEndDate'] : ['null', 'dateEndDate']), ['"' . $scope . '"', '_scope'], ($seed->hasAttribute('assignedUserId') ? ['assignedUserId', 'assignedUserId'] : ['null', 'assignedUserId']), ($seed->hasAttribute('assignedUserName') ? ['assignedUserName', 'assignedUserName'] : ['null', 'assignedUserName']), ($seed->hasAttribute('parentType') ? ['parentType', 'parentType'] : ['null', 'parentType']), ($seed->hasAttribute('parentId') ? ['parentId', 'parentId'] : ['null', 'parentId']), 'status', 'createdAt', ['false', 'hasAttachment'], ])
/application/Espo/Modules/Crm/Tools/Activities/PopupNotificationsProvider.php:801$reminderCollection = $this->entityManager->getRDBRepositoryByClass(Reminder::class)->select(['id', 'entityType', 'entityId', ])->where(['type' => Reminder::TYPE_POPUP, 'userId' => $userId, 'remindAt<=' => $now, 'startAt>' => $nowShifted, ])->find( )
/application/Espo/Modules/Crm/Tools/Case/Service.php:2222$query = $this->selectBuilderFactory->create( )->from(Contact::ENTITY_TYPE)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'emailAddress', 'name', ])->where(['id' => $contactIdList, ])->build( )
/application/Espo/Modules/Crm/Classes/FormulaFunctions/ExtGroup/AccountGroup/FindByEmailAddressType.php:1101$account = $em->getRDBRepository(Account::ENTITY_TYPE)->join('contacts')->where(['emailAddress*' => '%@' . $domain, 'contacts.id' => $contact->getId( ), ])->findOne( )
/application/Espo/Entities/Note.php:1651$collection = $this->entityManager->getRDBRepository(Attachment::ENTITY_TYPE)->select(['id', 'name', 'type'])->order('createdAt')->where(['id' => $attachmentsIds])->find( )
/application/Espo/Services/User.php:2451$entity = $this->getRepository( )->clone(SelectBuilder::create( )->from(UserEntity::ENTITY_TYPE)->withDeleted( )->build( ))->where(['id' => $id])->findOne( )
/application/Espo/Services/EmailTemplate.php:751$data = Data::create( )->withEmailAddress($params['emailAddress'] ?? null)->withEntityHash($params['entityHash'] ?? [ ])->withParent($params['parent'] ?? null)->withParentId($params['parentId'] ?? null)->withParentType($params['parentType'] ?? null)->withRelatedId($params['relatedId'] ?? null)->withRelatedType($params['relatedType'] ?? null)->withUser($this->user)
/application/Espo/Services/RecordTree.php:3451$query = $this->selectBuilderFactory->create( )->from($this->entityType)->withStrictAccessControl( )->buildQueryBuilder( )->where(['parentId' => $parentId, ])->build( )
/application/Espo/Services/RecordTree.php:3691$subQuery = $this->selectBuilderFactory->create( )->from($this->entityType)->withStrictAccessControl( )->buildQueryBuilder( )->where(['parentId' => $entity->getId( ), ])->build( )
/application/Espo/Services/RecordTree.php:1141$selectBuilder = $this->selectBuilderFactory->create( )->from($this->entityType)->withStrictAccessControl( )->withSearchParams($searchParams)->buildQueryBuilder( )->where(['parentId' => $parentId, ])
/application/Espo/Services/RecordTree.php:1841$query = $this->selectBuilderFactory->create( )->from($entityType)->withStrictAccessControl( )->withWhere(WhereItem::fromRaw(['type' => 'inCategory', 'attribute' => $this->getCategoryField( ), 'value' => $entity->getId( ), ]))->build( )
/application/Espo/Controllers/EmailAccount.php:562$params = StorageParams::createBuilder( )->setHost($data->host ?? null)->setPort($data->port ?? null)->setSecurity($data->security ?? null)->setUsername($data->username ?? null)->setPassword($data->password ?? null)->setId($data->id ?? null)->setEmailAddress($data->emailAddress ?? null)->setUserId($data->userId ?? null)->build( )
/application/Espo/Controllers/EmailAccount.php:782$params = StorageParams::createBuilder( )->setHost($data->host ?? null)->setPort($data->port ?? null)->setSecurity($data->security ?? null)->setUsername($data->username ?? null)->setPassword($data->password ?? null)->setId($data->id ?? null)->setEmailAddress($data->emailAddress ?? null)->setUserId($data->userId ?? null)->build( )
/application/Espo/Controllers/ExternalAccount.php:1091return (object) ['clientId' => $entity->get('clientId'), 'redirectUri' => $this->config->get('siteUrl') . '?entryPoint=oauthCallback', 'isConnected' => $this->getExternalAccount( )->ping($integration, $userId)]
/application/Espo/Controllers/InboundEmail.php:732$params = StorageParams::createBuilder( )->setHost($data->host ?? null)->setPort($data->port ?? null)->setSecurity($data->security ?? null)->setUsername($data->username ?? null)->setPassword($data->password ?? null)->setId($data->id ?? null)->build( )
/application/Espo/Controllers/InboundEmail.php:542$params = StorageParams::createBuilder( )->setHost($data->host ?? null)->setPort($data->port ?? null)->setSecurity($data->security ?? null)->setUsername($data->username ?? null)->setPassword($data->password ?? null)->setId($data->id ?? null)->build( )
/application/Espo/Modules/Crm/Jobs/SendEmailReminders.php:671$collection = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->where(['type' => Reminder::TYPE_EMAIL, 'remindAt<=' => $now, 'startAt>' => $nowShifted, ])->limit(0, $maxPortionSize)->find( )
/application/Espo/Modules/Crm/Jobs/SubmitPopupReminders.php:1341$submitData[$userId][] = ['id' => $reminder->getId( ), 'data' => (object) ['id' => $entity->getId( ), 'entityType' => $entityType, $dateAttribute => $entity->get($dateAttribute), 'name' => $entity->get('name'), ], ]
/application/Espo/Modules/Crm/Jobs/SubmitPopupReminders.php:711$reminderList = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->where(['type' => Reminder::TYPE_POPUP, 'remindAt<=' => $now, 'startAt>' => $nowShifted, 'isSubmitted' => false, ])->find( )
/application/Espo/Modules/Crm/EntryPoints/EventConfirmation.php:1661$actionData = ['eventName' => $event->get('name'), 'eventType' => $event->getEntityType( ), 'eventId' => $event->getId( ), 'dateStart' => $event->get('dateStart'), 'action' => $action, 'status' => $status, 'link' => $link, 'inviteeType' => $invitee->getEntityType( ), 'inviteeId' => $invitee->getId( ), ]
/application/Espo/Modules/Crm/EntryPoints/EventConfirmation.php:1431$actionData = ['eventName' => $event->get('name'), 'translatedEntityType' => $this->language->translateLabel($eventType, 'scopeNames'), 'translatedStatus' => $this->language->translateOption($eventStatus, 'status', $eventType), 'style' => $this->metadata->get(['entityDefs', $eventType, 'fields', 'status', 'style', $eventStatus]), ]
/application/Espo/Modules/Crm/Hooks/CaseObj/Contacts.php:981$portalUser = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id'])->where(['contactId' => $contactId, 'type' => User::TYPE_PORTAL, 'isActive' => true, ])->findOne( )
/application/Espo/Modules/Crm/Hooks/Meeting/EmailCreatedEvent.php:551$updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in(Email::ENTITY_TYPE)->set(['createdEventId' => null, 'createdEventType' => null, ])->where(['createdEventId' => $entity->getId( ), 'createdEventType' => $entity->getEntityType( )])->limit(1)->build( )
/application/Espo/Modules/Crm/Hooks/MassEmail/DeleteQueue.php:481$deleteQuery = $this->entityManager->getQueryBuilder( )->delete( )->from(EmailQueueItem::ENTITY_TYPE)->where(['massEmailId' => $entity->getId( )])->build( )
/application/Espo/Modules/Crm/Hooks/Contact/Accounts.php:761$accountContact = $this->entityManager->getRDBRepository('AccountContact')->select(['role'])->where(['accountId' => $accountId, 'contactId' => $entity->getId( ), 'deleted' => false, ])->findOne( )
/application/Espo/Modules/Crm/Business/Event/Ics.php:931$this->output = "BEGIN:VCALENDAR\r\n" . "VERSION:2.0\r\n" . "PRODID:-" . $this->prodid . "\r\n" . "METHOD:" . $this->method . "\r\n" . "BEGIN:VEVENT\r\n" . "DTSTART:" . $this->formatTimestamp($this->startDate) . "\r\n" . "DTEND:" . $this->formatTimestamp($this->endDate) . "\r\n" . "SUMMARY:" . $this->escapeString($this->summary) . "\r\n" . "LOCATION:" . $this->escapeString($this->address) . "\r\n" . "ORGANIZER;CN=" . $this->escapeString($this->who) . ":MAILTO:" . $this->escapeString($this->email) . "\r\n" . "DESCRIPTION:" . $this->escapeString($this->formatMultiline($this->description)) . "\r\n" . "UID:" . $this->uid . "\r\n" . "SEQUENCE:0\r\n" . "DTSTAMP:" . $this->formatTimestamp(time( )) . "\r\n" . "STATUS:" . $this->status . "\r\n" . "END:VEVENT\r\n" . "END:VCALENDAR"
/application/Espo/Modules/Crm/Business/Event/Invitations.php:2801$ics = new Ics('//EspoCRM//EspoCRM Calendar//EN', ['method' => $method, 'startDate' => strtotime($entity->get('dateStart')), 'endDate' => strtotime($entity->get('dateEnd')), 'uid' => $entity->getId( ), 'summary' => $entity->get('name'), 'who' => $who, 'email' => $email, 'description' => $entity->get('description'), 'status' => $status, ])
/application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:2141$query = $this->entityManager->getQueryBuilder( )->select( )->from(Opportunity::ENTITY_TYPE)->select(['SUM:amountConverted'])->where(['stage' => Opportunity::STAGE_CLOSED_WON, 'campaignId' => $entity->getId( ), ])->group('opportunity.campaignId')->build( )
/application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:1741$bouncedCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_BOUNCED, 'isTest' => false, ])->count( )
/install/core/Installer.php:3101$systemRequirementManager = $this->app->getContainer( )->getByClass(InjectableFactory::class)->createWithBinding(SystemRequirements::class, BindingContainerBuilder::create( )->bindInstance(ConfigDataProvider::class, $dbConfigDataProvider)->build( ))
/install/core/Installer.php:3881$data = ['database' => array_merge($databaseDefaults, $saveData['database']), 'language' => $saveData['language'] ?? 'en_US', 'siteUrl' => $siteUrl, 'passwordSalt' => $this->getPasswordHash( )->generateSalt( ), 'cryptKey' => Util::generateSecretKey( ), 'hashSecretKey' => Util::generateSecretKey( ), 'theme' => $saveData['theme'] ?? 'Violet', ]
/install/core/Installer.php:4941$updateQuery = $em->getQueryBuilder( )->update( )->in($entityType)->set(['deleted' => false])->where(['id' => $id])->build( )
/install/core/Installer.php:5321$user = $this->getEntityManager( )->getRDBRepositoryByClass(User::class)->clone(SelectBuilder::create( )->from(User::ENTITY_TYPE)->withDeleted( )->build( ))->where(['userName' => $userName])->findOne( )
/install/core/actions/step5.php:321$fields = array('smtpServer' => array('default' => $config->get('smtpServer'), ), 'smtpPort' => array('default' => $config->get('smtpPort', 25), ), 'smtpAuth' => array('default' => false, ), 'smtpSecurity' => array('default' => $config->get('smtpSecurity'), ), 'smtpUsername' => array('default' => $config->get('smtpUsername'), ), 'smtpPassword' => array('default' => $config->get('smtpPassword'), ), 'outboundEmailFromName' => array('default' => $config->get('outboundEmailFromName'), ), 'outboundEmailFromAddress' => array('default' => $config->get('outboundEmailFromAddress'), ), 'outboundEmailIsShared' => array('default' => $config->get('outboundEmailIsShared', false), ), )
/install/core/actions/step4.php:331$fields = ['dateFormat' => ['default' => $config->get('dateFormat'), 'options' => $metadata->get(['app', 'dateTime', 'dateFormatList']) ?? [ ], ], 'timeFormat' => ['default' => $config->get('timeFormat'), 'options' => $metadata->get(['app', 'dateTime', 'timeFormatList']) ?? [ ], ], 'timeZone' => ['default' => $config->get('timeZone', 'UTC'), ], 'weekStart' => ['default' => $config->get('weekStart', 0), ], 'defaultCurrency' => ['default' => $config->get('defaultCurrency', 'USD'), ], 'thousandSeparator' => ['default' => $config->get('thousandSeparator', ','), ], 'decimalMark' => ['default' => $config->get('decimalMark', '.'), ], 'language' => ['default' => (!empty($_SESSION['install']['user-lang'])) ? $_SESSION['install']['user-lang'] : $config->get('language', 'en_US'), ], ]
/install/core/actions/setupConfirmation.php:361$dbConfig = ['host' => $hostData[0] ?? '', 'port' => $hostData[1] ?? '', 'dbname' => $installData['db-name'], 'user' => $installData['db-user-name'], 'password' => $installData['db-user-password'], 'platform' => $installData['db-platform'] ?? null, ]
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:23324if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatebase.php:3001if((!$this->caching || $_template->has_nocache_code || $_template->source->recompiled) && !$no_output_filter && (isset($this->smarty->autoload_filters['output']) || isset($this->smarty->registered_filters['output']))) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_parsetree.php:2871if(substr($this->subtrees[$key]->data, -1) == '<' && $this->subtrees[$key + 1]->data == '' && substr($this->subtrees[$key + 2]->data, -1) == '?') { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_parsetree.php:2831if($this->subtrees[$key] instanceof _smarty_linebreak && $this->subtrees[$key + 1] instanceof _smarty_tag && $this->subtrees[$key + 1]->data == '' && $this->subtrees[$key + 2] instanceof _smarty_linebreak) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_private_modifier.php:1221if(isset($compiler->template->required_plugins['nocache'][$modifier][Smarty::PLUGIN_MODIFIER]['file']) || isset($compiler->template->required_plugins['compiled'][$modifier][Smarty::PLUGIN_MODIFIER]['file'])) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_utility.php:2451if((!isset($_compile_id) || (isset($_filepath[$_compile_id_part_length]) && !strncmp($_filepath, $_compile_id_part, $_compile_id_part_length))) && (!isset($resource_name) || (isset($_filepath[$_resource_part_1_length]) && substr_compare($_filepath, $_resource_part_1, -$_resource_part_1_length, $_resource_part_1_length) == 0) || (isset($_filepath[$_resource_part_2_length]) && substr_compare($_filepath, $_resource_part_2, -$_resource_part_2_length, $_resource_part_2_length) == 0))) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatecompilerbase.php:6931if((!($this->template->source->recompiled) || $this->forceNocache) && $this->template->caching && !$this->suppressNocacheProcessing && ($this->nocache || $this->tag_nocache)) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatecompilerbase.php:4151if($plugin_type == Smarty::PLUGIN_COMPILER && $this->smarty->loadPlugin('smarty_compiler_' . $tag) && (!isset($this->smarty->security_policy) || $this->smarty->security_policy->isTrustedTag($tag, $this))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatecompilerbase.php:3721if(!in_array($methode, $this->smarty->registered_objects[$tag][3]) && (empty($this->smarty->registered_objects[$tag][1]) || in_array($methode, $this->smarty->registered_objects[$tag][1]))) { /**/ } elseif(in_array($methode, $this->smarty->registered_objects[$tag][3])) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_include.php:1441if(!((substr_count($_attr['compile_id'], '"') == 2 || substr_count($_attr['compile_id'], "'") == 2)) || substr_count($_attr['compile_id'], '(') != 0 || substr_count($_attr['compile_id'], '$_smarty_tpl->') != 0) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_include.php:1341if($compiler->has_variable_string || !((substr_count($include_file, '"') == 2 || substr_count($include_file, "'") == 2)) || substr_count($include_file, '(') != 0 || substr_count($include_file, '$_smarty_tpl->') != 0) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_compile_include.php:921if($compiler->template->caching && ((!$compiler->inheritance && !$compiler->nocache && !$compiler->tag_nocache) || ($compiler->inheritance && ($compiler->nocache || $compiler->tag_nocache)))) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:8573if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : ($this->getStrpos($this->value, $this->ldel_length, 1) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:94024if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:95024if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:107624if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:81324if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:82424if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:83524if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:84624if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:28324if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:29424if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:30524if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:3153if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : ($this->getStrpos($this->value, $this->ldel_length, 1) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:24224if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:25124if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:26124if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:27224if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_template.php:4471elseif(((!$cache && $this->smarty->compile_check && empty($this->compiled->_properties) && !$this->compiled->isCompiled) || $cache && ($this->smarty->compile_check === true || $this->smarty->compile_check === Smarty::COMPILECHECK_ON)) && !empty($this->properties['file_dependency'])) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_security.php:3271if((!$this->_template_dir || $this->_template_dir !== $_template_dir) || (!$this->_config_dir || $this->_config_dir !== $_config_dir) || (!empty($this->secure_dir) && (!$this->_secure_dir || $this->_secure_dir !== $this->secure_dir))) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_resource.php:5331if($_file_is_dotted && isset($_template) && $_template->parent instanceof Smarty_Internal_Template && ($_template->parent->source->type == 'file' || $_template->parent->source->type == 'extends')) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_template.php:4711if($this->caching === Smarty::CACHING_LIFETIME_SAVED && $this->properties['cache_lifetime'] >= 0 && (time( ) > ($this->cached->timestamp + $this->properties['cache_lifetime']))) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:136824if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:135824if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:28641if(strcasecmp($this->yystack[$this->yyidx + -3]->minor, 'isset') === 0 || strcasecmp($this->yystack[$this->yyidx + -3]->minor, 'empty') === 0 || strcasecmp($this->yystack[$this->yyidx + -3]->minor, 'array') === 0 || is_callable($this->yystack[$this->yyidx + -3]->minor)) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:26751if(!$this->security || isset($this->smarty->registered_classes[$this->yystack[$this->yyidx + -2]->minor]) || $this->smarty->security_policy->isTrustedStaticClass($this->yystack[$this->yyidx + -2]->minor, $this->compiler)) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:124724if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:123824if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:134824if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:125624if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:109824if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:108724if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:11203if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : ($this->getStrpos($this->value, $this->ldel_length, 1) !== false))) { /**/ } else { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:110924if($this->smarty->auto_literal && ($this->mbstring_overload ? (mb_strpos(" \n\t\r", mb_substr($this->value, $this->ldel_length, 1, 'latin1'), 0, 'latin1') !== false) : (strpos(" \n\t\r", substr($this->value, $this->ldel_length, 1)) !== false))) { /**/ } else { /**/ }
/application/Espo/Tools/Import/Import.php:8641if(str_starts_with($attribute, 'emailAddress') && $attribute !== 'emailAddress' && $entity->hasAttribute('emailAddress') && $entity->hasAttribute('emailAddressData') && is_numeric(substr($attribute, 12)) && intval(substr($attribute, 12)) >= 2 && intval(substr($attribute, 12)) <= 4 && !empty($value)) { /**/ }
/application/Espo/Core/Record/SearchParamsFetcher.php:1881if($q !== null && !str_contains($q, '*') && !str_contains($q, '"') && !str_contains($q, '+') && !str_contains($q, '-') && $this->hasFullTextSearch($request)) { /**/ }
/application/Espo/Tools/UserSecurity/Service.php:2471if($userData->get('auth2FA') && $userData->get('auth2FAMethod') && ($userData->isAttributeChanged('auth2FA') || $userData->isAttributeChanged('auth2FAMethod')) && (!$user->isPortal( ) || $this->config->get('auth2FAInPortal'))) { /**/ }
/application/Espo/Tools/Export/Format/Xlsx/AdditionalFieldsLoader.php:611if((($entity->getRelationType($link) === Entity::BELONGS_TO && $entity->getRelationParam($link, 'noJoin')) || $entity->getRelationType($link) === Entity::HAS_ONE) && $entity->hasAttribute($link . 'Name')) { /**/ }
/application/Espo/Core/Mail/Sender.php:6541if(stripos($e->getMessage( ), 'password') !== false || stripos($e->getMessage( ), 'credentials') !== false || stripos($e->getMessage( ), '5.7.8') !== false) { /**/ }
/application/Espo/Core/FieldValidation/FieldValidationManager.php:1251if(!$entity->isNew( ) && $dataIsSet && !$entityDefs->tryGetField($field)?->getParam('forceValidation') && !$this->isFieldSetInData($entity->getEntityType( ), $field, $data)) { /**/ }
/application/Espo/Core/Record/Access/LinkCheck.php:5521if(!in_array($relationDefs->getType( ), $typeList) || !$entityDefs->hasAttribute($attribute) || !$entity->isAttributeChanged($attribute) || $entity->get($attribute) === null) { /**/ }
/application/Espo/Core/Record/Defaults/DefaultPopulator.php:641if(!$this->user->isPortal( ) && $entity instanceof CoreEntity && $entity->hasLinkMultipleField('teams') && $this->user->getDefaultTeam( ) && !$this->acl->checkField($entityType, 'teams', AclTable::ACTION_EDIT)) { /**/ }
/application/Espo/Tools/Stream/HookProcessor.php:4901if((method_exists($entity, $methodName) && $entity->$methodName( )) || (!method_exists($entity, $methodName) && ($entity->isAttributeChanged('assignedUserId') || $entity->isAttributeChanged('teamsIds') || $entity->isAttributeChanged('assignedUsersIds')))) { /**/ }
/application/Espo/Tools/Stream/Service.php:4601if($this->entityManager->getRDBRepository(Note::ENTITY_TYPE)->where(['type' => Note::TYPE_EMAIL_RECEIVED, 'parentId' => $entity->getId( ), 'parentType' => $entityType, 'relatedId' => $email->getId( ), 'relatedType' => Email::ENTITY_TYPE, ])->findOne( )) { /**/ }
/application/Espo/Tools/Stream/HookProcessor.php:891if($entity->isNew( ) && empty($options[self::OPTION_NO_STREAM]) && empty($options[SaveOption::SILENT]) && $this->metadata->get(['scopes', $entity->getEntityType( ), 'object'])) { /**/ }
/application/Espo/Tools/Stream/HookProcessor.php:3561if(!$this->user->isSystem( ) && !$this->user->isApi( ) && $createdById && $createdById === $this->user->getId( ) && ($this->user->isPortal( ) || $this->preferences->get('followCreatedEntities') || in_array($entityType, $this->preferences->get('followCreatedEntityTypeList') ?? [ ]))) { /**/ }
/application/Espo/Tools/LinkManager/LinkManager.php:3572if($this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign) || $this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign . 'Id') || $this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign . 'Name')) { /**/ }
/application/Espo/Tools/LinkManager/LinkManager.php:4112if($this->metadata->get('entityDefs.' . $entity . '.fields.' . $link) || $this->metadata->get('entityDefs.' . $entity . '.fields.' . $link . 'Id') || $this->metadata->get('entityDefs.' . $entity . '.fields.' . $link . 'Name')) { /**/ }
/application/Espo/Tools/LinkManager/LinkManager.php:2682if($this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign) || $this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign . 'Id') || $this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign . 'Name')) { /**/ }
/application/Espo/ORM/Query/Select.php:1941if((!empty($params['joins']) || !empty($params['leftJoins']) || !empty($params['whereClause']) || !empty($params['orderBy'])) && empty($params['from']) && empty($params['fromQuery'])) { /**/ }
/application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:3592if($query->getJoins( ) !== [ ] || $query->getLeftJoins( ) !== [ ] || $query->getLimit( ) !== null || $query->getOrder( ) !== [ ]) { /**/ }
/application/Espo/Repositories/Email.php:5111if(($entity->getStatus( ) === EmailEntity::STATUS_ARCHIVED || $entity->getStatus( ) === EmailEntity::STATUS_SENT) && ($entity->isAttributeChanged('status') || $entity->isNew( ))) { /**/ }
/application/Espo/ORM/Mapper/BaseMapper.php:15141if($onlyStorable && ($this->getAttributeParam($entity, $attribute, 'notStorable') || $this->getAttributeParam($entity, $attribute, 'autoincrement') || ($this->getAttributeParam($entity, $attribute, 'source') && $this->getAttributeParam($entity, $attribute, 'source') !== 'db'))) { /**/ }
/application/Espo/Classes/TemplateHelpers/GoogleMaps.php:811if(!$field && !$data->hasOption('street') && !$data->hasOption('city') && !$data->hasOption('country') && !$data->hasOption('state') && !$data->hasOption('postalCode')) { /**/ }
/application/Espo/Classes/Acl/Email/AccessChecker.php:1421if($entity->getStatus( ) === Email::STATUS_DRAFT && $entity->getCreatedBy( ) && $entity->getCreatedBy( )->getId( ) === $user->getId( )) { /**/ }
/application/Espo/Classes/RecordHooks/User/AfterUpdate.php:841if(!$entity->isPortal( ) || !$entity->getContactId( ) || !$entity->isAttributeChanged('firstName') && !$entity->isAttributeChanged('lastName') && !$entity->isAttributeChanged('salutationName')) { /**/ }
/application/Espo/Classes/FieldProcessing/Email/StringDataLoader.php:731if(in_array($entity->get('fromEmailAddressId'), $userEmailAddressIdList) || $entity->get('createdById') === $this->user->getId( ) && $entity->getStatus( ) === Email::STATUS_SENT) { /**/ }
/application/Espo/Modules/Crm/Tools/Activities/UpcomingService.php:1081if(!$this->acl->checkScope($entityType, Table::ACTION_READ) || !$this->metadata->get(['entityDefs', $entityType, 'fields', 'dateStart']) || !$this->metadata->get(['entityDefs', $entityType, 'fields', 'dateEnd'])) { /**/ }
/application/Espo/Controllers/Layout.php:1701if(!is_string($scope) || !is_string($name) || !is_string($type) || !is_string($label) || !$scope || !$name || !$type || !$label) { /**/ }
/application/Espo/Modules/Crm/Tools/Campaign/LogService.php:3091if($this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['queueItemId' => $queueItem->getId( ), 'action' => CampaignLogRecord::ACTION_CLICKED, 'objectId' => $trackingUrl->getId( ), 'objectType' => $trackingUrl->getEntityType( ), 'isTest' => $queueItem->isTest( ), ])->findOne( )) { /**/ }
/application/Espo/Modules/Crm/Tools/Activities/ComposeEmailService.php:1251if($foreignEntityType !== Account::ENTITY_TYPE && $foreignEntityType !== Contact::ENTITY_TYPE && $foreignEntityType !== Lead::ENTITY_TYPE && $this->metadata->get("scopes.$foreignEntityType.type") !== Person::TEMPLATE_TYPE && $this->metadata->get("scopes.$foreignEntityType.type") !== Company::TEMPLATE_TYPE) { /**/ }
/application/Espo/Modules/Crm/Tools/Campaign/LogService.php:2061if($queueItem && $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['queueItemId' => $queueItem->getId( ), 'action' => CampaignLogRecord::ACTION_OPTED_OUT, 'isTest' => $queueItem->isTest( ), ])->findOne( )) { /**/ }
/application/Espo/Modules/Crm/Tools/Campaign/LogService.php:2541if($this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['queueItemId' => $queueItem->getId( ), 'action' => CampaignLogRecord::ACTION_OPENED, 'isTest' => $queueItem->isTest( ), ])->findOne( )) { /**/ }
/application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:4032if($query->getJoins( ) !== [ ] || $query->getLeftJoins( ) !== [ ] || $query->getLimit( ) !== null || $query->getOrder( ) !== [ ]) { /**/ }
/application/Espo/Modules/Crm/Tools/Campaign/LogService.php:1541if($queueItem && $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['queueItemId' => $queueItem->getId( ), 'action' => CampaignLogRecord::ACTION_OPTED_IN, 'isTest' => $queueItem->isTest( ), ])->findOne( )) { /**/ }
/application/Espo/Core/Console/CommandManager.php:601if($command === null && ($params->hasFlag(self::DEFAULT_COMMAND_FLAG) || count($params->getFlagList( )) === 0 && count($params->getOptions( )) === 0 && count($params->getArgumentList( )) === 0)) { /**/ }
/application/Espo/Core/Acl/OwnerUserFieldProvider.php:861if($defs->hasField(self::FIELD_CREATED_BY) && $defs->getField(self::FIELD_CREATED_BY)->getType( ) === 'link' && $defs->hasRelation(self::FIELD_CREATED_BY) && $defs->getRelation(self::FIELD_CREATED_BY)->getForeignEntityType( ) === 'User') { /**/ }
/application/Espo/Core/Acl/OwnerUserFieldProvider.php:771if($defs->hasField(self::FIELD_ASSIGNED_USER) && $defs->getField(self::FIELD_ASSIGNED_USER)->getType( ) === 'link' && $defs->hasRelation(self::FIELD_ASSIGNED_USER) && $defs->getRelation(self::FIELD_ASSIGNED_USER)->getForeignEntityType( ) === 'User') { /**/ }
/application/Espo/Core/Acl/OwnerUserFieldProvider.php:681if($defs->hasField(self::FIELD_ASSIGNED_USERS) && $defs->getField(self::FIELD_ASSIGNED_USERS)->getType( ) === 'linkMultiple' && $defs->hasRelation(self::FIELD_ASSIGNED_USERS) && $defs->getRelation(self::FIELD_ASSIGNED_USERS)->getForeignEntityType( ) === 'User') { /**/ }
/application/Espo/Core/Acl/DefaultAccessChecker.php:1731if(!$this->config->get('aclAllowDeleteCreated') || !$entity->has(self::ATTR_CREATED_BY_ID) || $entity->get(self::ATTR_CREATED_BY_ID) !== $user->getId( )) { /**/ }
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:4421if($entity->has('emailAddressIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsInvalid') && $entity->get('emailAddressIsInvalid') !== $entity->getFetched('emailAddressIsInvalid')))) { /**/ }
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:4291if($entity->has('emailAddressIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsOptedOut') && $entity->get('emailAddressIsOptedOut') !== $entity->getFetched('emailAddressIsOptedOut')))) { /**/ }
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:3041if($emailAddress->get('optOut') != $hash->{$address}['optOut'] || $emailAddress->get('invalid') != $hash->{$address}['invalid'] || $emailAddress->get('emailAddress') != $hash->{$address}['emailAddress']) { /**/ }
/application/Espo/Classes/RecordHooks/User/BeforeUpdate.php:1601if($entity->isSuperAdmin( ) || !$entity->isAttributeChanged('type') || !$entity->getType( ) || in_array($entity->getType( ), $this->util->getAllowedUserTypeList( ))) { /**/ }
/application/Espo/Classes/RecordHooks/User/BeforeUpdate.php:1171if($portalUserLimit && !$this->user->isSuperAdmin( ) && (($entity->isActive( ) && $entity->isAttributeChanged('isActive') && $entity->isPortal( )) || ($entity->isPortal( ) && $entity->isAttributeChanged('type')))) { /**/ }
/application/Espo/Classes/RecordHooks/User/BeforeUpdate.php:851if($userLimit && !$this->user->isSuperAdmin( ) && (($entity->isActive( ) && $entity->isAttributeChanged('isActive') && !$entity->isPortal( ) && !$entity->isApi( )) || (!$entity->isPortal( ) && !$entity->isApi( ) && $entity->isAttributeChanged('type') && ($entity->isRegular( ) || $entity->isAdmin( )) && ($entity->getFetched('type') == UserEntity::TYPE_PORTAL || $entity->getFetched('type') == UserEntity::TYPE_API)))) { /**/ }
/application/Espo/Classes/RecordHooks/Role/BeforeSaveValidate.php:1811if(!$this->metadata->get("scopes.$scope.entity") || !$this->metadata->get("scopes.$scope.$key") || $this->metadata->get("scopes.$scope.$disabledKey")) { /**/ }
/application/Espo/Classes/RecordHooks/Note/AssignmentCheck.php:961if($targetType !== Note::TARGET_SELF && $targetType !== Note::TARGET_PORTALS && !($targetType === Note::TARGET_USERS && count($userIdList) === 1 && $userIdList[0] === $this->user->getId( )) && !($targetType === Note::TARGET_USERS && $allTargetUsersArePortal)) { /**/ }
/application/Espo/Classes/DuplicateWhereBuilders/General.php:1882if(($entity->get($field) || $entity->get($field . 'Data')) && ($entity->isNew( ) || $entity->isAttributeChanged($field) || $entity->isAttributeChanged($field . 'Data'))) { /**/ }
/application/Espo/Classes/DuplicateWhereBuilders/General.php:1512if(($entity->get($field) || $entity->get($field . 'Data')) && ($entity->isNew( ) || $entity->isAttributeChanged($field) || $entity->isAttributeChanged($field . 'Data'))) { /**/ }
/application/Espo/Classes/DefaultLayouts/DefaultSidePanelType.php:501if($this->metadata->get(['entityDefs', $scope, 'fields', 'assignedUser', 'type']) === 'link' && $this->metadata->get(['entityDefs', $scope, 'links', 'assignedUser', 'entity']) === 'User' || $this->metadata->get(['entityDefs', $scope, 'fields', 'assignedUsers', 'type']) === 'linkMultiple' && $this->metadata->get(['entityDefs', $scope, 'links', 'assignedUsers', 'entity']) === 'User') { /**/ }
/application/Espo/Core/Formula/AttributeFetcher.php:591if(!array_key_exists($key, $this->relatedEntitiesCacheMap) && $entity->hasRelation($relationName) && !in_array($entity->getRelationType($relationName), [Entity::MANY_MANY, Entity::HAS_MANY, Entity::HAS_CHILDREN])) { /**/ }
/application/Espo/Core/Job/QueueProcessor.php:851if(!$skip && $job->getScheduledJobId( ) && $this->queueUtil->isScheduledJobRunning($job->getScheduledJobId( ), $job->getTargetId( ), $job->getTargetType( ), $job->getTargetGroup( ))) { /**/ }
/application/Espo/Core/Select/SelectManager.php:24051if($isAuxiliaryUse && mb_strpos($textFilter, '*') === false || mb_strpos($textFilter, ' ') === false && mb_strpos($textFilter, '+') === false && mb_strpos($textFilter, '-') === false && mb_strpos($textFilter, '*') === false) { /**/ } else { /**/ }
/application/Espo/Core/Select/SelectManager.php:26091if(mb_strlen($textFilter) >= $textFilterContainsMinLength && ($attributeType == 'text' || in_array($field, $this->textFilterUseContainsAttributeList) || $attributeType == 'varchar' && $this->getConfig( )->get('textFilterUseContainsForVarchar'))) { /**/ } else { /**/ }
/application/Espo/Core/Repositories/Database.php:4301if(empty($options[SaveOption::SKIP_CREATED_BY]) && (empty($options[SaveOption::IMPORT]) || !$entity->has(self::ATTR_CREATED_BY_ID)) && $this->applicationState->hasUser( )) { /**/ }
/application/Espo/Core/Action/Actions/Merge/Merger.php:1771if(!$this->acl->check($sourceEntity, Table::ACTION_READ) || !$this->acl->check($sourceEntity, Table::ACTION_EDIT) || !$this->acl->check($sourceEntity, Table::ACTION_DELETE)) { /**/ }
/application/Espo/Core/Formula/Parser.php:5621if($statement->getState( ) === IfRef::STATE_ELSE_MET && !$isLast && $parenthesisCounter === 0 && $braceCounter === 0 && $this->isWhiteSpace($string[$i - 1]) && $this->isOnIf($string, $i)) { /**/ }
/application/Espo/Core/Formula/Parser.php:9741if($expression[0] === "'" && $expression[strlen($expression) - 1] === "'" || $expression[0] === "\"" && $expression[strlen($expression) - 1] === "\"") { /**/ }
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:4201if($entity->has('phoneNumberIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsOptedOut') && $entity->get('phoneNumberIsOptedOut') !== $entity->getFetched('phoneNumberIsOptedOut')))) { /**/ }
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:4331if($entity->has('phoneNumberIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsInvalid') && $entity->get('phoneNumberIsInvalid') !== $entity->getFetched('phoneNumberIsInvalid')))) { /**/ }
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:1411if($entity->has('emailAddressIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsOptedOut') && $entity->get('emailAddressIsOptedOut') !== $entity->getFetched('emailAddressIsOptedOut'))) && $emailAddressValue) { /**/ }
/application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:1591if($entity->has('emailAddressIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsInvalid') && $entity->get('emailAddressIsInvalid') !== $entity->getFetched('emailAddressIsInvalid'))) && $emailAddressValue) { /**/ }
/application/Espo/Core/Select/Select/Applier.php:881if($this->metadataProvider->hasAttribute($this->entityType, $item) && $this->metadataProvider->getAttributeType($this->entityType, $item) === Entity::TEXT && !$this->metadataProvider->isAttributeNotStorable($this->entityType, $item)) { /**/ }
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:1481if($entity->has('phoneNumberIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsOptedOut') && $entity->get('phoneNumberIsOptedOut') !== $entity->getFetched('phoneNumberIsOptedOut'))) && $phoneNumberValue) { /**/ }
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:1651if($entity->has('phoneNumberIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsInvalid') && $entity->get('phoneNumberIsInvalid') !== $entity->getFetched('phoneNumberIsInvalid'))) && $phoneNumberValue) { /**/ }
/application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:3101if($phoneNumber->get('type') != $hash->{$number}['type'] || $phoneNumber->get('optOut') != $hash->{$number}['optOut'] || $phoneNumber->get('invalid') != $hash->{$number}['invalid']) { /**/ }
/install/vendor/smarty/libs/sysplugins/smarty_cacheresource.php:3511if($this->valid && $_template->caching === Smarty::CACHING_LIFETIME_SAVED && $_template->properties['cache_lifetime'] >= 0 && (time( ) > ($_template->cached->timestamp + $_template->properties['cache_lifetime']))) { /**/ }
/application/Espo/Tools/LinkManager/LinkManager.php:2762if($this->metadata->get('entityDefs.' . $entity . '.fields.' . $link) || $this->metadata->get('entityDefs.' . $entity . '.fields.' . $link . 'Id') || $this->metadata->get('entityDefs.' . $entity . '.fields.' . $link . 'Name')) { /**/ }