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:2373 | 1 | 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:2378 | 1 | 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) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2428 | 1 | 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))) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2443 | 1 | 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))) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2458 | 1 | 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))) |
| /application/Espo/Core/Authentication/Oidc/Login.php:222 | 1 | curl_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, ]) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2404 | 1 | $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:2417 | 1 | $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:2393 | 1 | $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:2398 | 1 | $this->_retvalue = '<?php ob_start();?>' . $this->compiler->compileTag($this->yystack[$this->yyidx + -2]->minor, $this->yystack[$this->yyidx + 0]->minor) . '<?php echo ' |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2373 | 1 | $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:2378 | 1 | $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:2363 | 2 | $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:2368 | 1 | $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:2353 | 2 | $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:2358 | 1 | $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_compile_for.php:72 | 1 | $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:170 | 1 | $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_compile_block.php:158 | 1 | $_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:67 | 1 | $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_block.php:86 | 1 | self::$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}" |
| /application/Espo/Services/RecordTree.php:369 | 1 | $subQuery = $this->selectBuilderFactory->create( )->from($this->entityType)->withStrictAccessControl( )->buildQueryBuilder( )->where(['parentId' => $entity->getId( ), ])->build( ) |
| /application/Espo/Services/User.php:245 | 1 | $entity = $this->getRepository( )->clone(SelectBuilder::create( )->from(UserEntity::ENTITY_TYPE)->withDeleted( )->build( ))->where(['id' => $id])->findOne( ) |
| /application/Espo/Services/RecordTree.php:184 | 1 | $query = $this->selectBuilderFactory->create( )->from($entityType)->withStrictAccessControl( )->withWhere(WhereItem::fromRaw(['type' => 'inCategory', 'attribute' => $this->getCategoryField( ), 'value' => $entity->getId( ), ]))->build( ) |
| /application/Espo/Services/RecordTree.php:345 | 1 | $query = $this->selectBuilderFactory->create( )->from($this->entityType)->withStrictAccessControl( )->buildQueryBuilder( )->where(['parentId' => $parentId, ])->build( ) |
| /application/Espo/Services/EmailTemplate.php:75 | 1 | $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/Entities/Note.php:165 | 1 | $collection = $this->entityManager->getRDBRepository(Attachment::ENTITY_TYPE)->select(['id', 'name', 'type'])->order('createdAt')->where(['id' => $attachmentsIds])->find( ) |
| /application/Espo/Controllers/InboundEmail.php:56 | 2 | $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:75 | 2 | $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/SubmitPopupReminders.php:135 | 1 | $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/SendEmailReminders.php:67 | 1 | $collection = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->where(['type' => Reminder::TYPE_EMAIL, 'remindAt<=' => $now, 'startAt>' => $nowShifted, ])->limit(0, $maxPortionSize)->find( ) |
| /application/Espo/Controllers/EmailAccount.php:78 | 2 | $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/Services/RecordTree.php:114 | 1 | $selectBuilder = $this->selectBuilderFactory->create( )->from($this->entityType)->withStrictAccessControl( )->withSearchParams($searchParams)->buildQueryBuilder( )->where(['parentId' => $parentId, ]) |
| /application/Espo/Controllers/ExternalAccount.php:109 | 1 | return (object) ['clientId' => $entity->get('clientId'), 'redirectUri' => $this->config->get('siteUrl') . '?entryPoint=oauthCallback', 'isConnected' => $this->getExternalAccount( )->ping($integration, $userId)] |
| /application/Espo/Controllers/EmailAccount.php:56 | 2 | $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/EntryPoints/Avatar.php:167 | 1 | $image = $avatar->width($width)->height($width)->color($textColor)->fontSize(0.56)->preferBold( )->font($this->fontFile)->background($color)->generate( ) |
| /application/Espo/ORM/Mapper/BaseMapper.php:844 | 1 | $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:69 | 1 | $updateQuery2 = $this->entityManager->getQueryBuilder( )->update( )->in(Portal::ENTITY_TYPE)->set(['layoutSetId' => null, ])->where(['layoutSetId' => $entity->getId( ), ])->build( ) |
| /application/Espo/EntryPoints/ChangePassword.php:67 | 1 | $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/Hooks/Attachment/RemoveFile.php:58 | 1 | $duplicateCount = $this->entityManager->getRDBRepositoryByClass(Attachment::class)->where(['OR' => ['sourceId' => $entity->getSourceId( ), 'id' => $entity->getSourceId( ), ]])->count( ) |
| /application/Espo/Hooks/LayoutSet/Removal.php:53 | 1 | $updateQuery1 = $this->entityManager->getQueryBuilder( )->update( )->in(Team::ENTITY_TYPE)->set(['layoutSetId' => null, ])->where(['layoutSetId' => $entity->getId( ), ])->build( ) |
| /application/Espo/Repositories/Preferences.php:127 | 1 | $select = $this->entityManager->getQueryBuilder( )->select( )->from(PreferencesEntity::ENTITY_TYPE)->select(['id', 'data'])->where(['id' => $id, ])->limit(0, 1)->build( ) |
| /application/Espo/Repositories/Preferences.php:260 | 1 | $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/EmailAddress.php:197 | 1 | $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:262 | 1 | $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/Repositories/EmailAddress.php:128 | 1 | $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/EmailAddress.php:146 | 1 | $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/PhoneNumber.php:174 | 1 | $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:223 | 1 | $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/PhoneNumber.php:116 | 1 | $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/PhoneNumber.php:134 | 1 | $item = (object) ['phoneNumber' => $number->get('name'), 'type' => $number->get('type'), 'primary' => $number->get('primary'), 'optOut' => $number->get('optOut'), 'invalid' => $number->get('invalid'), ] |
| /application/Espo/Repositories/ArrayValue.php:150 | 1 | $list = $this->select(['id'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), 'attribute' => $attribute, ])->forUpdate( )->find( ) |
| /application/Espo/Repositories/ArrayValue.php:85 | 1 | $existingList = $this->select(['id', 'value'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), 'attribute' => $attribute, ])->forUpdate( )->find( ) |
| /application/Espo/Repositories/Import.php:161 | 1 | $delete2 = $this->entityManager->getQueryBuilder( )->delete( )->from(ImportError::ENTITY_TYPE)->where(['importId' => $entity->getId( ), ])->build( ) |
| /application/Espo/Repositories/Import.php:150 | 1 | $delete1 = $this->entityManager->getQueryBuilder( )->delete( )->from(ImportEntityEntity::ENTITY_TYPE)->where(['importId' => $entity->getId( ), ])->build( ) |
| /application/Espo/Resources/defaults/config.php:30 | 1 | return ['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' => 'Light', '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', 'cleanupAppLog' => true, 'cleanupAppLogPeriod' => '30 days', 'appLogAdminAllowed' => false, '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', 'notePinnedMaxCount' => 5, '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'], 'oidcAuthorizationPrompt' => 'consent', 'listViewSettingsDisabled' => false, 'cleanupDeletedRecords' => true, 'phoneNumberNumericSearch' => true, 'phoneNumberInternational' => true, 'phoneNumberExtensions' => false, 'phoneNumberPreferredCountryList' => ['us', 'de'], 'adminUpgradeDisabled' => false, 'wysiwygCodeEditorDisabled' => false, 'customPrefixDisabled' => false, 'listPagination' => true, 'starsLimit' => 500, 'quickSearchFullTextAppendWildcard' => false, 'authIpAddressCheck' => false, 'authIpAddressWhitelist' => [ ], 'authIpAddressCheckExcludedUsersIds' => [ ], 'authIpAddressCheckExcludedUsersNames' => (object) [ ], 'isInstalled' => false, ] |
| /application/Espo/Classes/FieldConverters/RelationshipRole.php:78 | 1 | return $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/FieldProcessing/Email/UserColumnsLoader.php:55 | 1 | $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/FieldProcessing/Email/IcsDataLoader.php:172 | 1 | $emailSameEvent = $this->entityManager->getRDBRepository(Email::ENTITY_TYPE)->where(['icsEventUid' => $espoEvent->getUid( ), 'id!=' => $entity->getId( )])->findOne( ) |
| /application/Espo/Classes/FieldProcessing/User/LastAccessLoader.php:65 | 1 | $authToken = $this->entityManager->getRDBRepository(AuthToken::ENTITY_TYPE)->select(['id', 'lastAccess'])->where(['userId' => $entity->getId( ), ])->order('lastAccess', 'DESC')->findOne( ) |
| /application/Espo/Classes/Jobs/Cleanup.php:710 | 1 | $arrayValueList = $this->entityManager->getRDBRepository(ArrayValue::ENTITY_TYPE)->sth( )->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), ])->find( ) |
| /application/Espo/Classes/Jobs/Cleanup.php:667 | 1 | $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:521 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Email::ENTITY_TYPE)->where(['deleted' => true, 'id' => $id, ])->build( ) |
| /application/Espo/Classes/Jobs/Cleanup.php:495 | 1 | $emailList = $this->entityManager->getRDBRepository(Email::ENTITY_TYPE)->clone($query)->sth( )->select(['id'])->where(['createdAt<' => $dateBefore, 'deleted' => true, ])->find( ) |
| /application/Espo/Classes/Jobs/Cleanup.php:471 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Attachment::ENTITY_TYPE)->where(['deleted' => true, 'createdAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_TIME_FORMAT), ])->build( ) |
| /application/Espo/Classes/Jobs/Cleanup.php:458 | 1 | $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:435 | 1 | $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:260 | 1 | $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:281 | 1 | $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:311 | 1 | $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:417 | 1 | $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:171 | 1 | $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:194 | 1 | $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:218 | 1 | $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:241 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(ActionHistoryRecord::ENTITY_TYPE)->where(['DATE:createdAt<' => $datetime->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ])->build( ) |
| /application/Espo/Classes/Select/Email/Where/ItemConverters/InFolder.php:71 | 1 | $whereClause = [Email::ALIAS_INBOX . '.inTrash' => false, Email::ALIAS_INBOX . '.folderId' => null, Email::ALIAS_INBOX . '.userId' => $this->user->getId( ), ['status' => [Email::STATUS_ARCHIVED, Email::STATUS_SENT, ], 'groupFolderId' => null, ], ] |
| /application/Espo/Classes/Select/Email/Where/ItemConverters/InFolder.php:110 | 1 | return WhereClause::fromRaw(['OR' => ['fromEmailAddressId' => $this->getEmailAddressIdList( ), ['status' => Email::STATUS_SENT, 'createdById' => $this->user->getId( ), ]], ['status!=' => Email::STATUS_DRAFT, ], Email::ALIAS_INBOX . '.inTrash' => false, ]) |
| /application/Espo/Classes/Jobs/Cleanup.php:147 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Job::ENTITY_TYPE)->where(['DATE:modifiedAt<' => $this->getCleanupJobFromDate( ), 'status!=' => JobStatus::PENDING, ])->build( ) |
| /application/Espo/Classes/Jobs/Cleanup.php:157 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Job::ENTITY_TYPE)->where(['DATE:modifiedAt<' => $this->getCleanupJobFromDate( ), 'status=' => JobStatus::PENDING, 'deleted' => true, ])->build( ) |
| /application/Espo/Classes/Cleanup/Subscribers.php:97 | 1 | $query = $this->entityManager->getQueryBuilder( )->delete( )->from(StreamSubscription::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/AssignmentNotificators/Email.php:279 | 1 | $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/Select/User/OrderItemConverters/UserNameOwnFirst.php:52 | 1 | return 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/Select/Email/AccessControlFilters/OnlyTeam.php:47 | 1 | $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, Email::ALIAS_INBOX, [Email::ALIAS_INBOX . '.emailId:' => 'id', Email::ALIAS_INBOX . '.deleted' => false, Email::ALIAS_INBOX . '.userId' => $this->user->getId( ), ])->where(['OR' => ['entityTeam.teamId' => $this->user->getTeamIdList( ), Email::ALIAS_INBOX . '.userId' => $this->user->getId( ), ]])->build( ) |
| /application/Espo/Classes/Cleanup/Reminders.php:61 | 1 | $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:67 | 1 | $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/Cleanup/WebhookQueue.php:76 | 1 | $query2 = $this->entityManager->getQueryBuilder( )->delete( )->from('WebhookEventQueueItem')->where(['DATE:(createdAt)<' => $from, 'OR' => ['isProcessed' => true, 'deleted' => true, ], ])->build( ) |
| /application/Espo/Classes/Cleanup/WebhookQueue.php:61 | 1 | $query1 = $this->entityManager->getQueryBuilder( )->delete( )->from('WebhookQueueItem')->where(['DATE:(createdAt)<' => $from, 'OR' => ['status!=' => 'Pending', 'deleted' => true, ], ])->build( ) |
| /application/Espo/Classes/AppParams/Extensions.php:74 | 1 | $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/Classes/AppParams/TemplateEntityTypeList.php:68 | 1 | $query = $this->selectBuilderFactory->create( )->from(Template::ENTITY_TYPE)->withAccessControlFilter( )->buildQueryBuilder( )->select(['entityType'])->group(['entityType'])->build( ) |
| /application/Espo/Classes/FieldValidators/CurrencyType.php:45 | 1 | return $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:52 | 1 | $collection = $this->entityManager->getRDBRepositoryByClass(EmailAccount::class)->join('assignedUser', 'assignedUserAdditional')->where(['status' => EmailAccount::STATUS_ACTIVE, 'useImap' => true, 'assignedUserAdditional.isActive' => true, ])->find( ) |
| /application/Espo/Core/Authentication/Oidc/UserProvider/Sync.php:120 | 1 | return ['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/Ldap/LdapLogin.php:323 | 1 | return $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->where(['userName' => $username, 'password' => $hash, 'type' => [User::TYPE_ADMIN, User::TYPE_SUPER_ADMIN], ])->findOne( ) |
| /application/Espo/Core/Acl/DefaultAssignmentChecker.php:79 | 1 | return $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/Helper/UserFinder.php:44 | 1 | return $this->entityManager->getRDBRepositoryByClass(User::class)->where(['userName' => $username, 'password' => $hash, 'type!=' => [User::TYPE_API, User::TYPE_SYSTEM], ])->findOne( ) |
| /application/Espo/Core/Authentication/TwoFactor/Email/Util.php:241 | 1 | $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/Email/Util.php:177 | 1 | return $this->entityManager->getRDBRepository(TwoFactorCode::ENTITY_TYPE)->where(['method' => EmailLogin::NAME, 'userId' => $user->getId( ), 'isActive' => true, ])->findOne( ) |
| /application/Espo/Core/Authentication/Ldap/LdapLogin.php:227 | 1 | $user = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->where(['userName' => $username, 'type!=' => [User::TYPE_API, User::TYPE_SYSTEM, User::TYPE_SUPER_ADMIN, ], ])->findOne( ) |
| /application/Espo/Core/Authentication/TwoFactor/Email/Util.php:298 | 1 | $query = $this->entityManager->getQueryBuilder( )->update( )->in(TwoFactorCode::ENTITY_TYPE)->where(['userId' => $user->getId( ), 'method' => EmailLogin::NAME, ])->set(['isActive' => false, ])->build( ) |
| /application/Espo/Modules/Crm/Hooks/MassEmail/DeleteQueue.php:48 | 1 | $deleteQuery = $this->entityManager->getQueryBuilder( )->delete( )->from(EmailQueueItem::ENTITY_TYPE)->where(['massEmailId' => $entity->getId( )])->build( ) |
| /application/Espo/Modules/Crm/Hooks/Meeting/EmailCreatedEvent.php:55 | 1 | $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/Business/Event/Ics.php:93 | 1 | $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/Hooks/Contact/Accounts.php:76 | 1 | $accountContact = $this->entityManager->getRDBRepository('AccountContact')->select(['role'])->where(['accountId' => $accountId, 'contactId' => $entity->getId( ), 'deleted' => false, ])->findOne( ) |
| /application/Espo/Modules/Crm/EntryPoints/EventConfirmation.php:166 | 1 | $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/Jobs/SubmitPopupReminders.php:71 | 1 | $reminderList = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->where(['type' => Reminder::TYPE_POPUP, 'remindAt<=' => $now, 'startAt>' => $nowShifted, 'isSubmitted' => false, ])->find( ) |
| /application/Espo/Modules/Crm/Hooks/CaseObj/Contacts.php:98 | 1 | $portalUser = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id'])->where(['contactId' => $contactId, 'type' => User::TYPE_PORTAL, 'isActive' => true, ])->findOne( ) |
| /application/Espo/Modules/Crm/EntryPoints/EventConfirmation.php:143 | 1 | $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/Classes/FieldProcessing/Campaign/StatsLoader.php:104 | 1 | $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:137 | 1 | $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:70 | 1 | $sentCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_SENT, 'isTest' => false, ])->count( ) |
| /application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:85 | 1 | $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:214 | 1 | $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/Business/Event/Invitations.php:280 | 1 | $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:152 | 1 | $optedOutCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_OPTED_OUT, 'isTest' => false, ])->count( ) |
| /application/Espo/Modules/Crm/Classes/FieldProcessing/Campaign/StatsLoader.php:174 | 1 | $bouncedCount = $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['campaignId' => $entity->getId( ), 'action' => CampaignLogRecord::ACTION_BOUNCED, 'isTest' => false, ])->count( ) |
| /application/Espo/Modules/Crm/Tools/Case/Service.php:222 | 2 | $query = $this->selectBuilderFactory->create( )->from(Contact::ENTITY_TYPE)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'emailAddress', 'name', ])->where(['id' => $contactIdList, ])->build( ) |
| /application/Espo/Modules/Crm/Tools/Activities/PopupNotificationsProvider.php:134 | 1 | $data = (object) ['id' => $entity->getId( ), 'entityType' => $entityType, 'name' => $entity->get('name'), 'dateField' => $dateField, 'attributes' => (object) [$dateField => $entity->get($dateField), $dateField . 'Date' => $entity->get($dateField . 'Date'), ], ] |
| /application/Espo/Modules/Crm/Tools/Activities/PopupNotificationsProvider.php:80 | 1 | $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/Activities/Service.php:1066 | 1 | $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/Classes/FieldProcessing/Meeting/AcceptanceStatusLoader.php:67 | 1 | $user = $this->entityManager->getRDBRepository($entity->getEntityType( ))->getRelation($entity, 'users')->where(['id' => $this->user->getId( ), ])->select([$attribute])->findOne( ) |
| /application/Espo/Modules/Crm/Classes/Select/Meeting/Where/DateTimeItemTransformer.php:93 | 1 | $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/RecordHooks/TargetList/AfterCreate.php:106 | 1 | $queryBuilder = $this->entityManager->getQueryBuilder( )->select( )->from(CampaignLogRecord::ENTITY_TYPE)->select(['id', 'parentId', 'parentType'])->where(['isTest' => false, 'campaignId' => $sourceCampaignId, ]) |
| /application/Espo/Modules/Crm/Classes/FormulaFunctions/ExtGroup/AccountGroup/FindByEmailAddressType.php:110 | 1 | $account = $em->getRDBRepository(Account::ENTITY_TYPE)->join('contacts')->where(['emailAddress*' => '%@' . $domain, 'contacts.id' => $contact->getId( ), ])->findOne( ) |
| /application/Espo/Modules/Crm/Tools/Activities/Service.php:114 | 1 | $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:113 | 1 | $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/KnowledgeBase/Service.php:344 | 1 | $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:285 | 1 | $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:468 | 1 | $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:331 | 1 | $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/Activities/Service.php:263 | 1 | $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:182 | 1 | $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/TargetList/RecordService.php:64 | 1 | $updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in($linkEntityType)->set(['deleted' => true])->where(['targetListId' => $entity->getId( )])->build( ) |
| /application/Espo/Modules/Crm/Tools/MassEmail/Service.php:74 | 1 | $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/MassEmail/SendingProcessor.php:374 | 1 | return $this->entityManager->getRDBRepositoryByClass(EmailQueueItem::class)->where(['status' => EmailQueueItem::STATUS_PENDING, 'massEmailId' => $massEmail->getId( ), 'isTest' => false, ])->count( ) |
| /application/Espo/Modules/Crm/Tools/MassEmail/SendingProcessor.php:420 | 1 | return $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/QueueCreator.php:59 | 1 | $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/MassEmail/QueueCreator.php:131 | 1 | $recordList = $this->entityManager->getRDBRepositoryByClass(TargetList::class)->getRelation($targetList, $link)->select(['id', 'emailAddress'])->sth( )->where(['@relation.optedOut' => false])->find( ) |
| /application/Espo/Modules/Crm/Tools/KnowledgeBase/Service.php:161 | 1 | $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:223 | 1 | $query = $this->selectBuilderFactory->create( )->from(KnowledgeBaseArticle::ENTITY_TYPE)->withStrictAccessControl( )->withSearchParams($params)->buildQueryBuilder( )->where(['order>' => $currentIndex, ])->order([['order', 'ASC'], ])->build( ) |
| /application/Espo/Modules/Crm/Tools/Calendar/Service.php:241 | 1 | $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:278 | 1 | $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:367 | 2 | return $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:433 | 2 | return $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:499 | 1 | $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:617 | 1 | $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:896 | 1 | $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:225 | 1 | return $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/ORM/QueryComposer/PostgresqlQueryComposer.php:247 | 1 | return "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/Query/SelectBuilder.php:309 | 1 | $resultList[] = $item->getAlias( ) ? [$item->getExpression( )->getValue( ), $item->getAlias( )] : [$item->getExpression( )->getValue( )] |
| /application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:431 | 1 | $builder = UpdateBuilder::create( )->in($query->getIn( ))->set($query->getSet( ))->where(Cond::in(Cond::column('id'), $subQueryBuilder->build( ))) |
| /application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:386 | 1 | $builder = DeleteBuilder::create( )->from($query->getFrom( ), $query->getFromAlias( ))->where(Cond::in(Cond::column('id'), $subQueryBuilder->build( ))) |
| /application/Espo/ORM/QueryComposer/BaseQueryComposer.php:3422 | 1 | $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/ORM/QueryComposer/BaseQueryComposer.php:3343 | 1 | $sql = "{$prefixPart}JOIN " . $this->quoteIdentifier($relTable) . " AS " . $this->quoteIdentifier($midAlias) . "$indexPart " . "ON $leftKeyColumn = $middleKeyColumn" . " AND " . "$middleDeletedColumn = " . $this->quote(false) |
| /application/Espo/Modules/Crm/Tools/Calendar/Service.php:161 | 1 | $eventList[] = new Event($row['dateStart'] ? DateTimeField::fromString($row['dateStart']) : null, $row['dateEnd'] ? DateTimeField::fromString($row['dateEnd']) : null, $row['scope'], $row) |
| /application/Espo/Modules/Crm/Tools/Opportunity/Service.php:152 | 2 | $query = $this->selectBuilderFactory->create( )->from(Contact::ENTITY_TYPE)->withStrictAccessControl( )->buildQueryBuilder( )->select(['id', 'emailAddress', 'name', ])->where(['id' => $contactIdList, ])->build( ) |
| /application/Espo/ORM/Mapper/BaseMapper.php:882 | 1 | $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:860 | 1 | $query = UpdateBuilder::create( )->in($entityType)->where([self::ATTR_ID => $entity->getId( ), self::ATTR_DELETED => false, ])->set([$key => $relEntity->getId( )])->build( ) |
| /application/Espo/ORM/Mapper/BaseMapper.php:919 | 1 | $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:910 | 1 | $query1 = UpdateBuilder::create( )->in($relEntity->getEntityType( ))->where([$foreignKey => $entity->getId( ), self::ATTR_DELETED => false, ])->set([$foreignKey => null])->build( ) |
| /application/Espo/ORM/Mapper/BaseMapper.php:1266 | 1 | $query = InsertBuilder::create( )->into($entity->getEntityType( ))->columns($this->getInsertColumnList($entity))->values($this->getInsertValueMap($entity))->updateSet($update ?? [ ])->build( ) |
| /application/Espo/ORM/Mapper/BaseMapper.php:958 | 1 | $query = UpdateBuilder::create( )->in($relEntity->getEntityType( ))->where([self::ATTR_ID => $id, self::ATTR_DELETED => false, ])->set($set)->build( ) |
| /application/Espo/ORM/Mapper/BaseMapper.php:1489 | 1 | $query = UpdateBuilder::create( )->in($entityType)->where([self::ATTR_ID => $id])->set([self::ATTR_DELETED => false])->build( ) |
| /application/Espo/ORM/Mapper/BaseMapper.php:1428 | 1 | $query = UpdateBuilder::create( )->in($entity->getEntityType( ))->set($valueMap)->where([self::ATTR_ID => $entity->getId( ), self::ATTR_DELETED => false, ])->build( ) |
| /application/Espo/Core/Job/Preparator/Preparators/ProcessJobGroupPreparator.php:82 | 1 | $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/Job/Preparator/Preparators/ProcessJobGroupPreparator.php:52 | 1 | $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/CollectionHelper.php:85 | 1 | $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/CollectionHelper.php:67 | 1 | $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/AsyncPoolFactory.php:48 | 1 | return Pool::create( )->autoload(getcwd( ) . '/vendor/autoload.php')->concurrency($this->config->get('jobPoolConcurrencyNumber'))->timeout($this->config->get('jobPeriodForActiveProcess')) |
| /application/Espo/Core/Job/JobScheduler.php:180 | 1 | return $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/QueueUtil.php:464 | 1 | $jobCollection = $this->entityManager->getRDBRepositoryByClass(JobEntity::class)->select(['id', 'attempts', 'failedAttempts', ])->where(['status' => Status::FAILED, 'executeTime<=' => DateTimeUtil::getSystemNowString( ), 'attempts>' => 0, ])->find( ) |
| /application/Espo/Core/ORM/DatabaseParamsFactory.php:80 | 1 | return 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:51 | 1 | $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:52 | 1 | return $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:131 | 1 | $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:113 | 1 | $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:149 | 1 | $data = ['id' => $this->getProcessId( ), 'name' => trim($manifest['name']), 'isInstalled' => true, 'version' => $manifest['version'], 'fileList' => $fileList, 'description' => $manifest['description'], ] |
| /application/Espo/Core/Upgrades/Migrations/V7_2/AfterUpgrade.php:183 | 1 | $query = $this->entityManager->getQueryBuilder( )->update( )->in(KnowledgeBaseArticle::ENTITY_TYPE)->where(['type' => null])->set(['type' => 'Article'])->build( ) |
| /application/Espo/Core/Api/Auth.php:207 | 1 | $bodyData = ['status' => $result->getStatus( ), 'message' => $result->getMessage( ), 'view' => $result->getView( ), 'token' => $result->getToken( ), 'data' => $result->getData( ), ] |
| /application/Espo/Core/Job/QueueUtil.php:152 | 1 | $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/Job/QueueUtil.php:83 | 1 | $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:239 | 1 | $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:192 | 1 | $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/Formula/Parser.php:746 | 1 | return substr($string, $i, 4) === 'else' && $this->isWhiteSpaceCharOrBraceOpen(substr($string, $i + 4, 1)) && $this->isWhiteSpaceCharOrBraceClose(substr($string, $i - 1, 1)) |
| /application/Espo/Core/Formula/Parser.php:731 | 1 | return substr($string, $i, 2) === 'if' && ($i === 0 || $this->isWhiteSpace($before) || $before === ';') && ($this->isWhiteSpace($after) || $after === '(') |
| /application/Espo/Core/Formula/Parser.php:1148 | 1 | $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:756 | 1 | return substr($string, $i, 5) === 'while' && ($i === 0 || $this->isWhiteSpace($before) || $before === ';') && ($this->isWhiteSpace($after) || $after === '(') |
| /application/Espo/Core/Job/QueueUtil.php:427 | 1 | $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:308 | 1 | $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:276 | 1 | $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:396 | 1 | $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:359 | 1 | $updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in(JobEntity::ENTITY_TYPE)->set(['status' => Status::FAILED, 'attempts' => 0, ])->where(['id' => $jobIdList, ])->build( ) |
| /application/Espo/Core/Repositories/CategoryTree.php:66 | 1 | $subSelect2 = $em->getQueryBuilder( )->select( )->select(["'" . $entity->getId( ) . "'", "'" . $entity->getId( ) . "'"])->build( ) |
| /application/Espo/Core/Repositories/CategoryTree.php:90 | 1 | $insert = $em->getQueryBuilder( )->insert( )->into($pathEntityType)->columns(['ascendorId', 'descendorId'])->values(['ascendorId' => $entity->getId( ), 'descendorId' => $entity->getId( ), ])->build( ) |
| /application/Espo/Core/Repositories/CategoryTree.php:109 | 1 | $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:136 | 1 | $select = $em->getQueryBuilder( )->select( )->from($pathEntityType)->select(['ascendorId', 's.descendorId'])->join($pathEntityType, 's')->where(['s.ascendorId' => $entity->getId( ), 'descendorId' => $parentId, ])->build( ) |
| /application/Espo/Core/Utils/Address/CountryDataProvider.php:89 | 1 | $collection = $this->entityManager->getRDBRepositoryByClass(AddressCountry::class)->sth( )->select(['name', 'isPreferred'])->order('name', Order::ASC)->limit(0, self::LIMIT)->find( ) |
| /application/Espo/Core/Repositories/Event.php:117 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(Reminder::ENTITY_TYPE)->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( ) |
| /application/Espo/Core/Repositories/Event.php:162 | 1 | return array_merge($this->metadata->get("scopes.$this->entityType.completedStatusList") ?? [ ], $this->metadata->get("scopes.$this->entityType.canceledStatusList") ?? [ ], ) |
| /application/Espo/Core/Repositories/CategoryTree.php:57 | 1 | $subSelect1 = $em->getQueryBuilder( )->select( )->from($pathEntityType)->select(['ascendorId', "'" . $entity->getId( ) . "'"])->where(['descendorId' => $parentId, ])->build( ) |
| /application/Espo/Core/ExternalAccount/ClientManager.php:234 | 1 | $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/Duplicate/Finder.php:133 | 1 | $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:231 | 1 | $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/Formula/Parser.php:145 | 1 | return ($string[$i - 1] ?? null) !== "\\" || (($string[$i - 2] ?? null) === "\\" && ($string[$i - 3] ?? null) !== "\\") |
| /application/Espo/Core/Field/PhoneNumber/PhoneNumberGroupAttributeExtractor.php:58 | 1 | $dataList[] = (object) ['phoneNumber' => $phoneNumber->getNumber( ), 'type' => $phoneNumber->getType( ), 'primary' => $primaryNumber && $phoneNumber->getNumber( ) === $primaryNumber, 'optOut' => $phoneNumber->isOptedOut( ), 'invalid' => $phoneNumber->isInvalid( ), ] |
| /application/Espo/Core/Field/Address/AddressFactory.php:46 | 1 | return (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:50 | 1 | return (object) [$field . 'Street' => $value->getStreet( ), $field . 'City' => $value->getCity( ), $field . 'Country' => $value->getCountry( ), $field . 'State' => $value->getState( ), $field . 'PostalCode' => $value->getPostalCode( ), ] |
| /application/Espo/Core/Field/EmailAddress/EmailAddressGroupAttributeExtractor.php:58 | 1 | $dataList[] = (object) ['emailAddress' => $emailAddress->getAddress( ), 'lower' => strtolower($emailAddress->getAddress( )), 'primary' => $primaryAddress && $emailAddress->getAddress( ) === $primaryAddress, 'optOut' => $emailAddress->isOptedOut( ), 'invalid' => $emailAddress->isInvalid( ), ] |
| /application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:348 | 1 | $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:248 | 1 | $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:213 | 1 | $changed = $hash->{$key}['optOut'] != $hashPrevious->{$key}['optOut'] || $hash->{$key}['invalid'] != $hashPrevious->{$key}['invalid'] || $hash->{$key}['emailAddress'] !== $hashPrevious->{$key}['emailAddress'] |
| /application/Espo/Core/FieldProcessing/NextNumber/BeforeSaveProcessor.php:108 | 1 | $nextNumber = $this->entityManager->getRDBRepository(NextNumber::ENTITY_TYPE)->where(['fieldName' => $field, 'entityType' => $entity->getEntityType( ), ])->forUpdate( )->findOne( ) |
| /application/Espo/Core/Loaders/DateTime.php:43 | 1 | return new DateTimeService($this->config->get('dateFormat'), $this->config->get('timeFormat'), $this->config->get('timeZone'), $this->config->get('language')) |
| /application/Espo/Core/Controllers/RecordTree.php:92 | 1 | return (object) ['list' => $collection->getValueMapList( ), 'path' => $this->getRecordTreeService( )->getTreeItemPath($parentId), 'data' => $this->getRecordTreeService( )->getCategoryData($parentId), ] |
| /application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:507 | 1 | $updateQuery = $this->entityManager->getQueryBuilder( )->update( )->in('EntityEmailAddress')->set(['primary' => true])->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'emailAddressId' => $emailAddressNew->getId( ), ])->build( ) |
| /application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:363 | 1 | $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/Authentication/Authentication.php:505 | 1 | $concurrentAuthTokenList = $this->entityManager->getRDBRepository(AuthTokenEntity::ENTITY_TYPE)->select(['id'])->where(['userId' => $user->getId( ), 'isActive' => true, 'id!=' => $authToken->getId( ), ])->find( ) |
| /application/Espo/Core/Authentication/Authentication.php:486 | 1 | $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:327 | 1 | $authLogRecord = $this->entityManager->getRDBRepository(AuthLogRecord::ENTITY_TYPE)->select(['id'])->where(['authTokenId' => $authToken->getId( )])->order('requestTime', true)->findOne( ) |
| /application/Espo/Core/Loaders/Language.php:49 | 2 | return $this->injectableFactory->createWith(LanguageService::class, ['language' => LanguageService::detectLanguage($this->config, $this->preferences), 'useCache' => $this->config->get('useCache') ?? false, ]) |
| /application/Espo/Core/Authentication/TwoFactor/Sms/Util.php:286 | 1 | $query = $this->entityManager->getQueryBuilder( )->update( )->in(TwoFactorCode::ENTITY_TYPE)->where(['userId' => $user->getId( ), 'method' => self::METHOD, ])->set(['isActive' => false, ])->build( ) |
| /application/Espo/Core/Authentication/TwoFactor/Sms/Util.php:235 | 1 | $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:171 | 1 | return $this->entityManager->getRDBRepository(TwoFactorCode::ENTITY_TYPE)->where(['method' => self::METHOD, 'userId' => $user->getId( ), 'isActive' => true, ])->findOne( ) |
| /application/Espo/Core/Authentication/Jwt/SignatureVerifiers/Rsa.php:118 | 1 | $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/Select/Where/ItemGeneralConverter.php:1640 | 1 | $sq = QueryBuilder::create( )->from($this->entityType)->select('id')->leftJoin($link)->where([$link . 'Middle.' . $key => $targetId, ])->build( ) |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1659 | 1 | $sq = QueryBuilder::create( )->from($this->entityType)->select('id')->leftJoin($link)->where([$link . '.id' => $targetId])->build( ) |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1562 | 1 | return 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:1586 | 1 | return 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/Reminder/Saver.php:132 | 2 | $collection = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->select(['seconds', 'type'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), 'userId' => $this->user->getId( ), ])->distinct( )->order('seconds')->find( ) |
| /application/Espo/Core/FieldProcessing/Reminder/Saver.php:174 | 1 | return $entity->isNew( ) || $this->toReCreate($entity) || $entity->isAttributeChanged('assignedUserId') || ($entity->hasLinkMultipleField('assignedUsers') && $entity->isAttributeChanged('assignedUsersIds')) || ($entity->hasLinkMultipleField('users') && $entity->isAttributeChanged('usersIds')) || $entity->isAttributeChanged($dateAttribute) |
| /application/Espo/Core/FieldProcessing/Relation/Saver.php:178 | 1 | $anotherEntity = $this->entityManager->getRDBRepository($entityType)->select(['id'])->where([$idAttribute => $entity->get($idAttribute), 'id!=' => $entity->getId( ), ])->findOne( ) |
| /application/Espo/Core/FieldProcessing/Reminder/Loader.php:76 | 2 | $collection = $this->entityManager->getRDBRepository(Reminder::ENTITY_TYPE)->select(['seconds', 'type'])->where(['entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), 'userId' => $this->user->getId( ), ])->distinct( )->order('seconds')->find( ) |
| /application/Espo/Core/FieldProcessing/Reminder/Saver.php:366 | 1 | $query = $this->entityManager->getQueryBuilder( )->insert( )->into(Reminder::ENTITY_TYPE)->columns(['id', 'entityId', 'entityType', 'type', 'userId', 'remindAt', 'startAt', 'seconds', ])->values(['id' => $this->idGenerator->generate( ), 'entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'type' => $type, 'userId' => $userId, 'remindAt' => $remindAt->toString( ), 'startAt' => $start->toString( ), 'seconds' => $seconds, ])->build( ) |
| /application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:218 | 1 | $changed = $hash->{$key}['type'] != $hashPrevious->{$key}['type'] || $hash->{$key}['optOut'] != $hashPrevious->{$key}['optOut'] || $hash->{$key}['invalid'] != $hashPrevious->{$key}['invalid'] |
| /application/Espo/Core/FieldProcessing/Reminder/Saver.php:210 | 1 | $query = $this->entityManager->getQueryBuilder( )->delete( )->from(Reminder::ENTITY_TYPE)->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( ) |
| /application/Espo/Core/FieldProcessing/Reminder/Saver.php:225 | 1 | $query = $this->entityManager->getQueryBuilder( )->delete( )->from(Reminder::ENTITY_TYPE)->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), 'userId' => $this->user->getId( ), ])->build( ) |
| /application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:371 | 1 | $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:555 | 1 | $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/PhoneNumber/Saver.php:253 | 1 | $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:356 | 1 | $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/Select/Where/ItemGeneralConverter.php:1142 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1123 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1197 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1166 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1235 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1216 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1292 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1263 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1347 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1319 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1394 | 1 | $subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($link, $alias)->where([$alias . '.id' => null])->build( ) |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1375 | 1 | $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:1446 | 1 | $subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($link, $alias)->where([$alias . '.id!=' => null])->build( ) |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1427 | 1 | $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:1516 | 1 | $subQuery = QueryBuilder::create( )->select('id')->from($this->entityType)->leftJoin($link, $alias)->where([$alias . '.id' => $value])->build( ) |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1492 | 1 | return 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/ORM/QueryComposer/QueryComposerFactory.php:73 | 1 | $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/Select/SelectManager.php:1583 | 2 | $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:1598 | 2 | $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/Order/ItemConverters/AddressType.php:45 | 1 | return OrderList::create([Order::fromString($orderBy . 'Country')->withDirection($order), Order::fromString($orderBy . 'City')->withDirection($order), Order::fromString($orderBy . 'Street')->withDirection($order), ]) |
| /application/Espo/Core/Select/AccessControl/Filters/OnlyTeam.php:56 | 1 | $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/AccessControl/Filters/OnlyOwn.php:58 | 1 | $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/Bool/Filters/OnlyMy.php:76 | 1 | $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/Where/ItemGeneralConverter.php:411 | 1 | return [$key => Select::fromRaw(['select' => ['id'], 'from' => $this->entityType, 'whereClause' => $whereClause, 'leftJoins' => $rawParams['leftJoins'] ?? [ ], 'joins' => $rawParams['joins'] ?? [ ], ]), ] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:554 | 1 | $subQuery = QueryBuilder::create( )->select('entityId')->from(ArrayValue::ENTITY_TYPE)->where(['entityType' => $arrayEntityType, 'attribute' => $arrayAttribute, 'value' => $value, ])->build( ) |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:572 | 1 | return 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:589 | 1 | return 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:629 | 1 | $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:1007 | 2 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<=' => $today->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1028 | 2 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<=' => $today->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1049 | 1 | return ['AND' => [$attribute . '>=' => $today->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<=' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Core/Select/Where/ItemGeneralConverter.php:1104 | 11 | return ['AND' => [$attribute . '>=' => $from->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), $attribute . '<' => $to->toDateTime( )->format(DateTimeUtil::SYSTEM_DATE_FORMAT), ]] |
| /application/Espo/Tools/Email/EmailAddressEntityPair.php:61 | 1 | return (object) ['emailAddress' => $this->emailAddress->getAddress( ), 'name' => $this->entity->get('name'), 'entityId' => $this->entity->getId( ), 'entityType' => $this->entity->getEntityType( ), ] |
| /application/Espo/Tools/WorkingTime/TeamCalendar.php:218 | 3 | $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/InboxService.php:213 | 1 | $update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['inTrash' => true])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( ) |
| /application/Espo/Tools/Email/InboxService.php:140 | 1 | $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/WorkingTime/UserCalendar.php:302 | 3 | $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:261 | 1 | $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/WorkingTime/Extractor.php:381 | 1 | $list[] = [DateTime::fromDateTime($pointer->setTime($start->getHour( ), $start->getMinute( ))), DateTime::fromDateTime($pointer->setTime($end->getHour( ), $end->getMinute( )))] |
| /application/Espo/Tools/WorkingTime/GlobalCalendar.php:197 | 3 | $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/Import/Service.php:219 | 1 | $importEntityList = $this->entityManager->getRDBRepository(ImportEntityEntity::ENTITY_TYPE)->sth( )->where(['importId' => $import->getId( ), 'isImported' => true, ])->find( ) |
| /application/Espo/Tools/Import/Service.php:189 | 1 | return $this->factory->create( )->setEntityType($entityType)->setAttributeList($attributeList)->setAttachmentId($attachmentId)->setParams($params)->setId($id)->run( ) |
| /application/Espo/Tools/Import/Service.php:496 | 1 | $errorList = $this->entityManager->getRDBRepositoryByClass(ImportEntity::class)->getRelation($import, 'errors')->sth( )->select(['exportRowIndex', 'rowIndex'])->order('rowIndex')->find( ) |
| /application/Espo/Tools/Import/Service.php:371 | 1 | $importEntityList = $this->entityManager->getRDBRepository(ImportEntityEntity::ENTITY_TYPE)->sth( )->where(['importId' => $import->getId( ), 'isDuplicate' => true, ])->find( ) |
| /application/Espo/Tools/Import/Params.php:345 | 1 | return 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:306 | 2 | $label = $this->language->translateLabel($fieldData->getLink( ), 'links', $entityType) . '.' . $this->language->translateLabel($fieldData->getField( ), 'fields', $fieldData->getEntityType( )) |
| /application/Espo/Tools/Import/Import.php:387 | 1 | return 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:371 | 1 | return ['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/Core/Webhook/Queue.php:99 | 1 | $webhookList = $this->entityManager->getRDBRepository(Webhook::ENTITY_TYPE)->where(['event' => $item->get('event'), 'isActive' => true, ])->order('createdAt')->find( ) |
| /application/Espo/Core/Webhook/Queue.php:125 | 1 | $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:159 | 1 | $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/Core/Webhook/Queue.php:337 | 1 | $itemList = $this->entityManager->getRDBRepository(WebhookQueueItem::ENTITY_TYPE)->where(['status' => WebhookQueueItem::STATUS_PENDING, 'webhookId' => $webhook->getId( ), ])->order('number')->find( ) |
| /application/Espo/Tools/Email/InboxService.php:457 | 1 | $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:326 | 1 | $list = $this->entityManager->getRDBRepository(InboundEmail::ENTITY_TYPE)->select(['id', 'name', 'emailAddress', ])->where(['emailAddress*' => $query . '%', ])->order('name')->find( ) |
| /application/Espo/Tools/GlobalSearch/Service.php:189 | 1 | $queryBuilder = $this->entityManager->getQueryBuilder( )->select( )->clone($query)->limit(0, $offset + $maxSize + 1)->select($selectList)->order([ ]) |
| /application/Espo/Core/ApplicationUser.php:56 | 1 | $user = $this->entityManagerProxy->getRDBRepository(User::ENTITY_TYPE)->select(['id', 'name', 'userName', 'type', 'isActive', 'firstName', 'lastName', 'deleted', ])->where(['userName' => SystemUser::NAME])->findOne( ) |
| /application/Espo/Tools/Email/InboxService.php:352 | 1 | $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:371 | 1 | $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:385 | 1 | $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:405 | 1 | $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/Email/InboxService.php:234 | 1 | $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:273 | 1 | $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:294 | 1 | $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:333 | 1 | $update = $this->entityManager->getQueryBuilder( )->update( )->in(Email::RELATIONSHIP_EMAIL_USER)->set(['isImportant' => true])->where(['deleted' => false, 'userId' => $userId, 'emailId' => $id, ])->build( ) |
| /application/Espo/Tools/EmailFolder/Service.php:106 | 1 | $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/EmailTemplate/Api/PostPrepare.php:57 | 1 | $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/EmailTemplate/Processor.php:249 | 1 | $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/EntityManager/Rename/Renamer.php:601 | 1 | $query = $this->entityManager->getQueryBuilder( )->update( )->in($entityType)->set([$typeAttribute => $to])->where([$typeAttribute => $from])->build( ) |
| /application/Espo/Tools/EntityManager/Rename/Renamer.php:554 | 1 | $query3 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityPhoneNumber')->set(['entityType' => $to])->where(['entityType' => $from])->build( ) |
| /application/Espo/Tools/EntityManager/Rename/Renamer.php:544 | 1 | $query2 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityEmailAddress')->set(['entityType' => $to])->where(['entityType' => $from])->build( ) |
| /application/Espo/Tools/EntityManager/Rename/Renamer.php:534 | 1 | $query1 = $this->entityManager->getQueryBuilder( )->update( )->in('EntityTeam')->set(['entityType' => $to])->where(['entityType' => $from])->build( ) |
| /application/Espo/Tools/LinkManager/Hook/Hooks/TargetListDelete.php:59 | 2 | [$entityType, $link, $foreignLink] = $params->getEntityType( ) === TargetList::ENTITY_TYPE ? [$params->getForeignEntityType( ), $params->getForeignLink( ), $params->getLink( ), ] : [$params->getEntityType( ), $params->getLink( ), $params->getForeignLink( ), ] |
| /application/Espo/Tools/LinkManager/Hook/Hooks/TargetListCreate.php:58 | 2 | [$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:941 | 1 | $linkParams = LinkParams::createBuilder( )->setType($type)->setName($name)->setEntityType($entity)->setForeignEntityType($entityForeign)->setLink($link)->setForeignLink($linkForeign)->build( ) |
| /application/Espo/Tools/LinkManager/LinkManager.php:694 | 1 | $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:663 | 1 | $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:535 | 1 | $dataLeft = ['fields' => [$link => ['type' => 'linkParent', 'entityList' => $params['parentEntityTypeList'] ?? null, ], ], 'links' => [$link => ['type' => Entity::BELONGS_TO_PARENT, 'foreign' => $linkForeign, 'isCustom' => true, ], ], ] |
| /application/Espo/Tools/LinkManager/LinkManager.php:500 | 1 | $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:474 | 1 | $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:446 | 1 | $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/Export/Export.php:292 | 1 | $builder = $this->selectBuilderFactory->create( )->forUser($this->user)->from($entityType)->withAdditionalApplierClassNameList($this->applierClassNameListProvider->get($entityType))->withSearchParams($searchParams) |
| /application/Espo/Tools/Export/Format/Xlsx/OpenSpoutProcessor.php:144 | 2 | $label = $this->language->translateLabel($fieldData->getLink( ), 'links', $entityType) . '.' . $this->language->translateLabel($fieldData->getField( ), 'fields', $fieldData->getEntityType( )) |
| /application/Espo/Tools/UserSecurity/Password/Sender.php:169 | 1 | $portalList = $this->entityManager->getRDBRepositoryByClass(Portal::class)->distinct( )->join('users')->where(['isActive' => true, 'users.id' => $user->getId( ), ])->find( ) |
| /application/Espo/Tools/ExportCustom/ExportCustom.php:238 | 1 | $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/RecoveryService.php:464 | 1 | $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/UserSecurity/Password/Service.php:181 | 1 | $u = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->where(['id' => $user->getId( ), 'password' => $this->passwordHash->hash($currentPassword ?? ''), ])->findOne( ) |
| /application/Espo/Tools/UserSecurity/Service.php:122 | 1 | $allow = $this->config->get('auth2FA') && ($user->isAdmin( ) || $user->isRegular( ) || $user->isPortal( ) && $this->config->get('auth2FAInPortal')) |
| /application/Espo/Tools/UserSecurity/Password/RecoveryService.php:413 | 1 | $portal = $this->entityManager->getRDBRepository(Portal::ENTITY_TYPE)->distinct( )->join('users')->where(['isActive' => true, 'users.id' => $user->getId( ), ])->findOne( ) |
| /application/Espo/Tools/Kanban/OrdererProcessor.php:140 | 1 | $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:178 | 1 | $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/Kanban/OrdererProcessor.php:107 | 1 | $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:122 | 1 | $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/Kanban.php:196 | 1 | $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:72 | 1 | return $this->createKanban( )->setEntityType($entityType)->setSearchParams($searchParams)->setCountDisabled($disableCount)->setOrderDisabled($orderDisabled)->setUserId($this->user->getId( ))->setMaxOrderNumber($maxOrderNumber)->getResult( ) |
| /application/Espo/Tools/EmailFolder/Service.php:186 | 1 | $previousEntity = $this->entityManager->getRDBRepositoryByClass(EmailFolder::class)->where(['order<' => $currentIndex, 'assignedUserId' => $entity->get('assignedUserId'), ])->order('order', true)->findOne( ) |
| /application/Espo/Tools/EmailFolder/Service.php:229 | 1 | $nextEntity = $this->entityManager->getRDBRepositoryByClass(EmailFolder::class)->where(['order>' => $currentIndex, 'assignedUserId' => $entity->get('assignedUserId'), ])->order('order', false)->findOne( ) |
| /application/Espo/Core/Utils/Database/Orm/LinkConverters/EmailEmailAddress.php:62 | 3 | return 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:60 | 1 | return 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/HasOne.php:60 | 1 | $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/HasMany.php:73 | 1 | return 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/FieldConverters/Email.php:122 | 1 | return ['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, "LIKE:(emailAddress.lower, LOWER:({value})):" => null, ], ], ], ], 'NOT LIKE' => ['whereClause' => ['id!=s' => ['from' => 'EntityEmailAddress', 'select' => ['entityId'], 'joins' => [['emailAddress', 'emailAddress', ['emailAddress.id:' => 'emailAddressId', 'emailAddress.deleted' => false, ], ]], 'whereClause' => ['deleted' => false, 'entityType' => $entityType, "LIKE:(emailAddress.lower, LOWER:({value})):" => null, ], ], ], ], '=' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ["EQUAL:(emailAddressesMultiple.lower, LOWER:({value})):" => null, ]], '<>' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ["NOT_EQUAL:(emailAddressesMultiple.lower, LOWER:({value})):" => null, ], 'distinct' => true, ], 'IN' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ["EQUAL:(emailAddressesMultiple.lower, LOWER:({value})):" => null, ], 'distinct' => true, ], 'NOT IN' => ['leftJoins' => [['emailAddresses', 'emailAddressesMultiple']], 'whereClause' => ["NOT_EQUAL:(emailAddressesMultiple.lower, LOWER:({value})):" => null, ], '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/FieldConverters/Email.php:85 | 1 | $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:319 | 1 | return ['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:259 | 1 | return ['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/LinkConverters/ManyMany.php:77 | 3 | return 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:64 | 1 | $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/Database/Orm/LinkConverters/BelongsToParent.php:60 | 1 | return 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:50 | 1 | return 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:49 | 1 | $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:66 | 1 | $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/LinkConverters/EntityUser.php:50 | 1 | return 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:56 | 3 | return 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/FieldConverters/Currency.php:276 | 1 | $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/PersonName.php:113 | 1 | $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/Phone.php:96 | 1 | $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/Utils/Database/Orm/FieldConverters/Phone.php:134 | 1 | return ['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}', ]], '<>' => ['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:271 | 1 | return ['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:331 | 1 | return ['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:391 | 1 | return ['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/Utils/DateTime/DateTimeFactory.php:62 | 1 | return $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/LinkMultiple.php:48 | 1 | $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:58 | 1 | $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/LinkParent.php:68 | 1 | $nameDefs = AttributeDefs::create($nameName)->withType(AttributeType::VARCHAR)->withNotStorable( )->withParamsMerged(['relation' => $name, 'isParentName' => true, 'attributeRole' => 'name', 'fieldType' => 'linkParent', ]) |
| /application/Espo/Core/Utils/Database/Orm/FieldConverters/AttachmentMultiple.php:45 | 1 | return 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/LinkOne.php:44 | 1 | return 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/Currency.php:123 | 1 | $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/Currency.php:132 | 1 | $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/Currency.php:143 | 1 | $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/Mail/Account/SendingAccountProvider.php:96 | 1 | $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:73 | 1 | $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/Fetcher.php:380 | 1 | $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:279 | 1 | $importerData = ImporterData::create( )->withTeamIdList($teamIdList)->withFilterList($filterList)->withFetchOnlyHeader($fetchOnlyHeader)->withFolderData($folderData)->withUserIdList($userIdList)->withAssignedUserId($assignedUserId)->withGroupEmailFolderId($groupEmailFolderId) |
| /application/Espo/Core/Mail/Account/GroupAccount/Account.php:116 | 1 | $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/SendingAccountProvider.php:230 | 1 | $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/SendingAccountProvider.php:172 | 1 | $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( ) |
| /application/Espo/Core/Mail/Account/SendingAccountProvider.php:129 | 1 | $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/Record/Service.php:521 | 1 | $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:366 | 1 | $builder = $this->selectBuilderFactory->create( )->from($this->entityType)->withSearchParams(SearchParams::create( )->withSelect(['*'])->withPrimaryFilter(One::NAME))->withAdditionalApplierClassNameList($this->createSelectApplierClassNameListProvider( )->get($this->entityType)) |
| /application/Espo/Core/Portal/Loaders/Language.php:49 | 2 | return $this->injectableFactory->createWith(LanguageService::class, ['language' => LanguageService::detectLanguage($this->config, $this->preferences), 'useCache' => $this->config->get('useCache') ?? false, ]) |
| /application/Espo/Core/Webhook/Manager.php:106 | 1 | $list = $this->entityManager->getRDBRepository(Webhook::ENTITY_TYPE)->select(['event'])->group(['event'])->where(['isActive' => true, 'event!=' => null, ])->find( ) |
| /application/Espo/Core/Mail/Importer/DefaultParentFinder.php:164 | 1 | return !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:673 | 1 | $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/Record/Service.php:1076 | 1 | $query = $this->entityManager->getQueryBuilder( )->select( )->from($this->entityType)->where(['id' => $id, ])->withDeleted( )->build( ) |
| /application/Espo/Core/Record/Service.php:1033 | 1 | $query = $selectBuilder->from($this->entityType)->withStrictAccessControl( )->withSearchParams($preparedSearchParams)->withAdditionalApplierClassNameList($this->createSelectApplierClassNameListProvider( )->get($this->entityType))->build( ) |
| /application/Espo/Core/Utils/EmailFilterManager.php:105 | 1 | $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/ScheduledJob.php:108 | 1 | $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/FieldValidation/Exceptions/ValidationError.php:64 | 1 | $exception = self::createWithBody('validationFailure', Body::create( )->withMessageTranslation('validationFailure', null, ['field' => $failure->getField( ), 'type' => $failure->getType( ), ])->encode( )) |
| /application/Espo/Core/Utils/ClientManager.php:193 | 1 | $data = ['applicationId' => $this->applicationId, '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, 'faviconAlternate' => $faviconAlternate, 'favicon' => $favicon, 'faviconType' => $faviconType, '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/Database/Orm/Converter.php:456 | 1 | $toUnset = !in_array('', $this->metadata->get(['fields', $type, 'actualFields']) ?? [ ]) && !in_array('', $this->metadata->get(['fields', $type, 'notActualFields']) ?? [ ]) |
| /application/Espo/Core/Utils/Database/Orm/Converter.php:950 | 1 | return ['type' => $indexDefs->isUnique( ) ? self::INDEX_TYPE_UNIQUE : self::INDEX_TYPE_INDEX, 'columns' => $indexDefs->getColumnList( ), 'flags' => $indexDefs->getFlagList( ), 'key' => $indexDefs->getKey( ), ] |
| /application/Espo/Core/Utils/ScheduledJob.php:148 | 1 | $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/Utils/Database/Orm/Converter.php:373 | 1 | $output = ['id' => ['type' => Entity::ID, ], 'name' => ['type' => $entityMetadata['fields']['name']['type'] ?? Entity::VARCHAR, 'notStorable' => true, ], 'deleted' => ['type' => Entity::BOOL, 'default' => false, ], ] |
| /application/Espo/Core/Mail/Account/GroupAccount/Hooks/AfterFetch.php:187 | 1 | $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:384 | 1 | $params = ['caseDistribution' => $inboundEmail->getCaseDistribution( ), 'teamId' => $inboundEmail->get('teamId'), 'userId' => $inboundEmail->get('assignToUserId'), 'targetUserPosition' => $inboundEmail->getTargetUserPosition( ), 'inboundEmailId' => $inboundEmail->getId( ), ] |
| /application/Espo/Core/Mail/Account/GroupAccount/StorageFactory.php:63 | 1 | $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:78 | 1 | $rawParams = ['host' => $params->getHost( ), 'port' => $params->getPort( ), 'username' => $params->getUsername( ), 'password' => $params->getPassword( ), 'imapHandler' => $params->getImapHandlerClassName( ), 'id' => $params->getId( ), ] |
| /application/Espo/Core/Mail/Account/PersonalAccount/StorageFactory.php:92 | 1 | $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/Event/EventFactory.php:58 | 1 | return 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/Mail/Account/Util/NotificationHelper.php:85 | 1 | $one = $this->entityManager->getRDBRepositoryByClass(Notification::class)->where(['relatedId' => $id, 'relatedType' => $entityType, 'userId' => $userId, 'createdAt>' => DateTime::createNow( )->modify('-' . self::PERIOD)->toString( ), ])->findOne( ) |
| /application/Espo/Core/Mail/Account/PersonalAccount/StorageFactory.php:75 | 1 | $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/Tools/App/AppService.php:316 | 1 | $emailAccountCollection = $this->entityManager->getRDBRepositoryByClass(EmailAccountEntity::class)->select(['id', 'emailAddress'])->where(['assignedUserId' => $user->getId( ), 'useSmtp' => true, 'status' => EmailAccountEntity::STATUS_ACTIVE, ])->find( ) |
| /application/Espo/Tools/App/AppService.php:355 | 1 | $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/AdminNotifications/Manager.php:196 | 1 | $extension = $this->entityManager->getRDBRepository(Extension::ENTITY_TYPE)->select(['version'])->where(['name' => $extensionName, 'isInstalled' => true, ])->order('createdAt', true)->findOne( ) |
| /application/Espo/Tools/AdminNotifications/Jobs/CheckNewExtensionVersion.php:60 | 1 | $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/ActionHistory/Service.php:67 | 1 | $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/App/SettingsService.php:205 | 1 | $ignoreItemList = array_merge($this->access->getSystemParamList( ), $this->access->getReadOnlyParamList( ), $this->isRestrictedMode( ) && !$user->isSuperAdmin( ) ? $this->access->getSuperAdminParamList( ) : [ ]) |
| /application/Espo/Tools/App/AppService.php:113 | 1 | return ['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:145 | 1 | $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/Notification/Service.php:77 | 1 | $related = $this->entityManager->getRDBRepository(Email::ENTITY_TYPE)->select(['id', 'sentById', 'createdById'])->where(['id' => $note->getRelatedId( )])->findOne( ) |
| /application/Espo/Tools/EmailNotification/AssignmentProcessor.php:148 | 1 | $templateData = ['userName' => $user->get('name'), 'assignerUserName' => $assignerUser->get('name'), 'recordUrl' => $recordUrl, 'entityType' => $this->language->translateLabel($entity->getEntityType( ), 'scopeNames'), ] |
| /application/Espo/Tools/EmailNotification/Processor.php:215 | 1 | $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/Tools/Notification/NoteHookProcessor.php:223 | 1 | $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/Notification/HookProcessor.php:153 | 1 | $query = $this->entityManager->getQueryBuilder( )->delete( )->from(Notification::ENTITY_TYPE)->where(['OR' => [['relatedId' => $entity->getId( ), 'relatedType' => $entity->getEntityType( ), ], ['relatedParentId' => $entity->getId( ), 'relatedParentType' => $entity->getEntityType( ), ], ], ])->build( ) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2468 | 1 | $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:2490 | 1 | $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:2458 | 1 | $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:2463 | 1 | $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:2443 | 1 | $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:2453 | 1 | $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:2428 | 1 | $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:2438 | 1 | $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:2632 | 1 | $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:2689 | 1 | $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:2575 | 1 | $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:2627 | 1 | $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:2565 | 1 | $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_templateparser.php:2570 | 1 | $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:2495 | 1 | $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:2500 | 1 | $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/core/actions/saveSettings.php:38 | 1 | $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/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2947 | 1 | $this->_retvalue = '$' . $this->yystack[$this->yyidx + -2]->minor . $this->yystack[$this->yyidx + -1]->minor . $this->yystack[$this->yyidx + 0]->minor |
| /install/core/actions/step2.php:46 | 1 | $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_templateparser.php:2922 | 1 | $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/core/actions/setupConfirmation.php:36 | 1 | $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_templateparser.php:2853 | 1 | $this->_retvalue = '->{\'' . $this->yystack[$this->yyidx + -4]->minor . '\'.' . $this->yystack[$this->yyidx + -2]->minor . $this->yystack[$this->yyidx + 0]->minor . '}' |
| /install/core/actions/step4.php:33 | 1 | $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/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2810 | 1 | $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/core/actions/step5.php:32 | 1 | $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/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2808 | 1 | $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/core/Installer.php:532 | 1 | $user = $this->getEntityManager( )->getRDBRepositoryByClass(User::class)->clone(SelectBuilder::create( )->from(User::ENTITY_TYPE)->withDeleted( )->build( ))->where(['userName' => $userName])->findOne( ) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2782 | 1 | $this->_retvalue = '[' . $this->compiler->compileTag('private_special_variable', array( ), '[\'section\'][\'' . $this->yystack[$this->yyidx + -3]->minor . '\'][\'' . $this->yystack[$this->yyidx + -1]->minor . '\']') . ']' |
| /install/core/Installer.php:494 | 1 | $updateQuery = $em->getQueryBuilder( )->update( )->in($entityType)->set(['deleted' => false])->where(['id' => $id])->build( ) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2711 | 1 | $this->_retvalue = $this->compileVariable($this->yystack[$this->yyidx + 0]->minor['var']) . $this->yystack[$this->yyidx + 0]->minor['smarty_internal_index'] |
| /install/core/Installer.php:388 | 1 | $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'] ?? 'Light', ] |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templateparser.php:2691 | 1 | $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 |
| /upgrades/7.0/scripts/AfterUpgrade.php:217 | 1 | $updateQuery = $entityManager->getQueryBuilder( )->update( )->in($entityType)->set(['monitoredFolders' => $foldersJsonString])->where(['id' => $id])->build( ) |
| /install/core/Installer.php:310 | 1 | $systemRequirementManager = $this->app->getContainer( )->getByClass(InjectableFactory::class)->createWithBinding(SystemRequirements::class, BindingContainerBuilder::create( )->bindInstance(ConfigDataProvider::class, $dbConfigDataProvider)->build( )) |
| /upgrades/7.2/scripts/AfterUpgrade.php:168 | 1 | $query = $entityManager->getQueryBuilder( )->update( )->in(\Espo\Modules\Crm\Entities\KnowledgeBaseArticle::ENTITY_TYPE)->where(['type' => null])->set(['type' => 'Article'])->build( ) |
| /install/vendor/smarty/libs/plugins/shared.make_timestamp.php:26 | 1 | return 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_template.php:153 | 1 | $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/sysplugins/smarty_cacheresource_keyvaluestore.php:56 | 1 | $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_config.php:146 | 1 | $this->mustCompile = ($this->smarty->force_compile || $this->getCompiledTimestamp( ) === false || $this->smarty->compile_check && $this->getCompiledTimestamp( ) < $this->source->timestamp) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_config.php:145 | 1 | return $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_config.php:131 | 1 | return $this->compiled_timestamp === null ? ($this->compiled_timestamp = (file_exists($this->getCompiledFilepath( ))) ? filemtime($this->getCompiledFilepath( )) : false) : $this->compiled_timestamp |
| /application/Espo/Tools/Pdf/Dompdf/HtmlComposer.php:129 | 2 | $renderer = $this->templateRendererFactory->create( )->setApplyAcl($params->applyAcl( ))->setEntity($entity)->setSkipInlineAttachmentHandling( )->setData($data->getAdditionalTemplateData( )) |
| /application/Espo/Tools/Pdf/Dompdf/HtmlComposer.php:162 | 2 | $renderer = $this->templateRendererFactory->create( )->setApplyAcl($params->applyAcl( ))->setEntity($entity)->setSkipInlineAttachmentHandling( )->setData($data->getAdditionalTemplateData( )) |
| /application/Espo/Tools/Stars/StarService.php:53 | 1 | return (bool) $this->entityManager->getRDBRepository(StarSubscription::ENTITY_TYPE)->select(['id'])->where(['userId' => $user->getId( ), 'entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), ])->findOne( ) |
| /application/Espo/Tools/Stars/StarService.php:111 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(StarSubscription::ENTITY_TYPE)->where(['userId' => $user->getId( ), 'entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( ) |
| /application/Espo/Tools/LeadCapture/ConfirmationSender.php:160 | 1 | $emailData = $this->emailTemplateProcessor->process($emailTemplate, EmailTemplateParams::create( ), EmailTemplateData::create( )->withEntityHash([Person::TEMPLATE_TYPE => $lead, Lead::ENTITY_TYPE => $lead, ])) |
| /application/Espo/Tools/LeadCapture/Service.php:110 | 1 | $inboundEmailList = $this->entityManager->getRDBRepositoryByClass(InboundEmail::class)->where(['useSmtp' => true, 'status' => InboundEmail::STATUS_ACTIVE, ['emailAddress!=' => ''], ['emailAddress!=' => null], ])->find( ) |
| /application/Espo/Tools/LinkManager/LinkManager.php:158 | 1 | $linkParams = LinkParams::createBuilder( )->setType($linkType)->setEntityType($entity)->setForeignEntityType($entityForeign)->setLink($link)->setForeignLink($linkForeign)->setName($relationName)->build( ) |
| /application/Espo/Tools/LinkManager/LinkManager.php:328 | 1 | $dataLeft = ['fields' => [$link => ['type' => 'link', 'isCustom' => true, ], ], 'links' => [$link => ['type' => Entity::BELONGS_TO, 'foreign' => $linkForeign, 'entity' => $entityForeign, 'isCustom' => true, ], ], ] |
| /install/core/actions/saveSettings.php:53 | 1 | $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:345 | 1 | $dataRight = ['fields' => [$linkForeign => ['type' => 'linkOne', 'isCustom' => true, ], ], 'links' => [$linkForeign => ['type' => Entity::HAS_ONE, 'foreign' => $link, 'entity' => $entity, 'isCustom' => true, ], ], ] |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_function_call_handler.php:41 | 1 | $_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/vendor/smarty/libs/sysplugins/smarty_internal_compile_if.php:163 | 1 | $_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:88 | 1 | $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:780 | 1 | $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])) . '" ' |
| /application/Espo/Tools/LinkManager/LinkManager.php:375 | 1 | $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:429 | 1 | $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:400 | 1 | $dataRight = ['fields' => [$linkForeign => ['type' => 'link', ], ], 'links' => [$linkForeign => ['type' => Entity::BELONGS_TO, 'foreign' => $link, 'entity' => $entity, 'audited' => $audited, 'isCustom' => true, ], ], ] |
| /application/Espo/Tools/Notification/RecordService.php:148 | 1 | $query = $this->entityManager->getQueryBuilder( )->update( )->in(Notification::ENTITY_TYPE)->set(['read' => true])->where(['id' => $ids])->build( ) |
| /application/Espo/Tools/Notification/RecordService.php:273 | 1 | $update = $this->entityManager->getQueryBuilder( )->update( )->in(Notification::ENTITY_TYPE)->set(['read' => true])->where(['userId' => $userId, 'read' => false, ])->build( ) |
| /application/Espo/Tools/Notification/RecordService.php:75 | 1 | $queryBuilder = $this->selectBuilderFactory->create( )->from(Notification::ENTITY_TYPE)->withSearchParams($searchParams)->buildQueryBuilder( )->where(['userId' => $userId])->order('number', SearchParams::ORDER_DESC) |
| /application/Espo/Tools/Stream/Service.php:167 | 1 | return (bool) $this->entityManager->getRDBRepository(StreamSubscription::ENTITY_TYPE)->select(['id'])->where(['userId' => $userId, 'entityType' => $entity->getEntityType( ), 'entityId' => $entity->getId( ), ])->findOne( ) |
| /application/Espo/Tools/Stream/Service.php:241 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(StreamSubscription::ENTITY_TYPE)->where(['userId' => $userIdList, 'entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( ) |
| /application/Espo/Tools/Attachment/Service.php:73 | 1 | return new FileData($attachment->getName( ), $attachment->getType( ), $this->getAttachmentRepository( )->getStream($attachment), $this->getAttachmentRepository( )->getSize($attachment)) |
| /application/Espo/Tools/Attachment/Api/GetFile.php:56 | 1 | $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:678 | 1 | $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/Stream/Service.php:718 | 1 | $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:323 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(StreamSubscription::ENTITY_TYPE)->where(['userId' => $userId, 'entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( ) |
| /application/Espo/Tools/Stream/Service.php:344 | 1 | $delete = $this->entityManager->getQueryBuilder( )->delete( )->from(StreamSubscription::ENTITY_TYPE)->where(['entityId' => $entity->getId( ), 'entityType' => $entity->getEntityType( ), ])->build( ) |
| /application/Espo/Tools/Stream/Service.php:1126 | 1 | $builder = $this->entityManager->getQueryBuilder( )->select( )->from(StreamSubscription::ENTITY_TYPE)->select('userId')->where(['entityId' => $parentId, 'entityType' => $parentType, ]) |
| /application/Espo/Tools/Stream/UserRecordService.php:102 | 2 | $baseBuilder = $this->queryHelper->buildBaseQueryBuilder($searchParams)->select($this->queryHelper->getUserQuerySelect( ))->leftJoin('createdBy')->order('number', Order::DESC)->limit(0, $offset + $maxSize + 1) |
| /application/Espo/Tools/Stream/Service.php:977 | 1 | $userList = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id'])->join(StreamSubscription::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:1068 | 1 | $userList = $this->entityManager->getRDBRepository(User::ENTITY_TYPE)->select(['id', 'name'])->join(StreamSubscription::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/RecordService.php:256 | 1 | $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:175 | 1 | $where = $this->user->isPortal( ) ? ['parentType' => $scope, 'parentId' => $id, 'isInternal' => false, ] : ['OR' => [['parentType' => $scope, 'parentId' => $id, ], ['superParentType' => $scope, 'superParentId' => $id, ], ]] |
| /application/Espo/Tools/Stream/GlobalRecordService.php:76 | 1 | $baseBuilder = $this->queryHelper->buildBaseQueryBuilder($searchParams)->select($this->queryHelper->getUserQuerySelect( ))->order('number', Order::DESC)->limit(0, $maxSize + 1) |
| /application/Espo/Tools/Stream/UserRecordService.php:145 | 2 | $baseBuilder = $this->queryHelper->buildBaseQueryBuilder($searchParams)->select($this->queryHelper->getUserQuerySelect( ))->leftJoin('createdBy')->order('number', Order::DESC)->limit(0, $offset + $maxSize + 1) |
| /application/Espo/Tools/Stream/RecordService/QueryHelper.php:161 | 1 | return (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:144 | 1 | return (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:116 | 1 | return (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:72 | 1 | $builder = $this->selectBuilderFactory->create( )->from(Note::ENTITY_TYPE)->withComplexExpressionsForbidden( )->withWherePermissionCheck( )->withSearchParams($searchParams->withOffset(null)->withMaxSize(null))->buildQueryBuilder( )->order([ ]) |
| /application/Espo/Tools/Stream/Api/PostNotePin.php:107 | 1 | $count = $this->entityManager->getRDBRepositoryByClass(Note::class)->where(['parentId' => $entity->getParentId( ), 'parentType' => $entity->getParentType( ), 'isPinned' => true, ])->count( ) |
| /application/Espo/Tools/Stream/NoteAcl/Processor.php:195 | 1 | return $this->entityManager->getRDBRepository(Note::ENTITY_TYPE)->sth( )->where(['OR' => [['relatedId' => $entity->getId( ), 'relatedType' => $entityType, ], ['parentId' => $entity->getId( ), 'parentType' => $entityType, 'superParentId!=' => null, 'relatedId' => null, ], ]])->where(['createdAt>=' => $aclThreshold->toString( )])->select(['id', 'parentType', 'parentId', 'superParentType', 'superParentId', 'isInternal', 'relatedType', 'relatedId', 'createdAt', ])->order('number', Order::DESC)->limit(0, $limit)->find( ) |
| /application/Espo/Tools/Stream/RecordService/QueryHelper.php:226 | 1 | return (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:188 | 1 | return (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/Pdf/Dompdf/HtmlComposer.php:77 | 1 | return " <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:55 | 1 | $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:117 | 1 | $insert = $this->entityManager->getQueryBuilder( )->insert( )->into($pathEntityType)->columns(['ascendorId', 'descendorId'])->values(['ascendorId' => $entity->getId( ), 'descendorId' => $entity->getId( ), ])->build( ) |
| /application/Espo/Tools/CategoryTree/RebuildPaths.php:96 | 1 | $subSelect1 = $this->entityManager->getQueryBuilder( )->select( )->from($pathEntityType)->select(['ascendorId', "'" . $entity->getId( ) . "'"])->where(['descendorId' => $parentId, ])->build( ) |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_templatelexer.php:1348 | 24 | if($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_templatecompilerbase.php:372 | 1 | if(!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_templatelexer.php:1358 | 24 | if($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:1368 | 24 | if($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:2675 | 1 | if(!$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_templateparser.php:2864 | 1 | if(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_security.php:327 | 1 | if((!$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_internal_template.php:447 | 1 | elseif(((!$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_internal_template.php:471 | 1 | if($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:1076 | 24 | if($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:1087 | 24 | if($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:1098 | 24 | if($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:1109 | 24 | if($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:1120 | 3 | if($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:1238 | 24 | if($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:1247 | 24 | if($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:1256 | 24 | if($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:813 | 24 | if($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:315 | 3 | if($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:835 | 24 | if($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:824 | 24 | if($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:857 | 3 | if($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:846 | 24 | if($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:950 | 24 | if($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:940 | 24 | if($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:242 | 24 | if($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:233 | 24 | if($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:261 | 24 | if($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:251 | 24 | if($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:283 | 24 | if($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:272 | 24 | if($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:305 | 24 | if($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:294 | 24 | if($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/Core/FieldProcessing/PhoneNumber/Saver.php:310 | 1 | if($phoneNumber->get('type') != $hash->{$number}['type'] || $phoneNumber->get('optOut') != $hash->{$number}['optOut'] || $phoneNumber->get('invalid') != $hash->{$number}['invalid']) { /**/ } |
| /application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:420 | 1 | if($entity->has('phoneNumberIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsOptedOut') && $entity->get('phoneNumberIsOptedOut') !== $entity->getFetched('phoneNumberIsOptedOut')))) { /**/ } |
| /application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:148 | 1 | if($entity->has('phoneNumberIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsOptedOut') && $entity->get('phoneNumberIsOptedOut') !== $entity->getFetched('phoneNumberIsOptedOut'))) && $phoneNumberValue) { /**/ } |
| /application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:165 | 1 | if($entity->has('phoneNumberIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsInvalid') && $entity->get('phoneNumberIsInvalid') !== $entity->getFetched('phoneNumberIsInvalid'))) && $phoneNumberValue) { /**/ } |
| /application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:159 | 1 | if($entity->has('emailAddressIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsInvalid') && $entity->get('emailAddressIsInvalid') !== $entity->getFetched('emailAddressIsInvalid'))) && $emailAddressValue) { /**/ } |
| /application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:304 | 1 | if($emailAddress->get('optOut') != $hash->{$address}['optOut'] || $emailAddress->get('invalid') != $hash->{$address}['invalid'] || $emailAddress->get('emailAddress') != $hash->{$address}['emailAddress']) { /**/ } |
| /application/Espo/Core/FieldProcessing/PhoneNumber/Saver.php:433 | 1 | if($entity->has('phoneNumberIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('phoneNumberIsInvalid') && $entity->get('phoneNumberIsInvalid') !== $entity->getFetched('phoneNumberIsInvalid')))) { /**/ } |
| /application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:141 | 1 | if($entity->has('emailAddressIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsOptedOut') && $entity->get('emailAddressIsOptedOut') !== $entity->getFetched('emailAddressIsOptedOut'))) && $emailAddressValue) { /**/ } |
| /application/Espo/Core/Formula/Parser.php:972 | 1 | if($expression[0] === "'" && $expression[strlen($expression) - 1] === "'" || $expression[0] === "\"" && $expression[strlen($expression) - 1] === "\"") { /**/ } |
| /application/Espo/Core/Formula/AttributeFetcher.php:59 | 1 | if(!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/Action/Actions/Merge/Merger.php:177 | 1 | if(!$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:569 | 1 | if($statement->getState( ) === IfRef::STATE_ELSE_MET && !$isLast && $parenthesisCounter === 0 && $braceCounter === 0 && $this->isWhiteSpace($string[$i - 1]) && $this->isOnIf($string, $i)) { /**/ } |
| /application/Espo/Core/Select/SelectManager.php:2610 | 1 | if(mb_strlen($textFilter) >= $textFilterContainsMinLength && ($attributeType == 'text' || in_array($field, $this->textFilterUseContainsAttributeList) || $attributeType == 'varchar' && $this->getConfig( )->get('textFilterUseContainsForVarchar'))) { /**/ } else { /**/ } |
| /application/Espo/Core/Select/Select/Applier.php:88 | 1 | if($this->metadataProvider->hasAttribute($this->entityType, $item) && $this->metadataProvider->getAttributeType($this->entityType, $item) === Entity::TEXT && !$this->metadataProvider->isAttributeNotStorable($this->entityType, $item)) { /**/ } |
| /application/Espo/Core/Job/QueueProcessor.php:104 | 1 | if(!$skip && $job->getScheduledJobId( ) && $this->queueUtil->isScheduledJobRunning($job->getScheduledJobId( ), $job->getTargetId( ), $job->getTargetType( ), $job->getTargetGroup( ))) { /**/ } |
| /application/Espo/Core/Select/SelectManager.php:2406 | 1 | if($isAuxiliaryUse && mb_strpos($textFilter, '*') === false || mb_strpos($textFilter, ' ') === false && mb_strpos($textFilter, '+') === false && mb_strpos($textFilter, '-') === false && mb_strpos($textFilter, '*') === false) { /**/ } else { /**/ } |
| /application/Espo/Tools/Import/Import.php:873 | 1 | if(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/Tools/Export/Format/Xlsx/AdditionalFieldsLoader.php:61 | 1 | if((($entity->getRelationType($link) === Entity::BELONGS_TO && $entity->getRelationParam($link, 'noJoin')) || $entity->getRelationType($link) === Entity::HAS_ONE) && $entity->hasAttribute($link . 'Name')) { /**/ } |
| /application/Espo/Tools/UserSecurity/Service.php:247 | 1 | if($userData->get('auth2FA') && $userData->get('auth2FAMethod') && ($userData->isAttributeChanged('auth2FA') || $userData->isAttributeChanged('auth2FAMethod')) && (!$user->isPortal( ) || $this->config->get('auth2FAInPortal'))) { /**/ } |
| /application/Espo/Tools/LinkManager/LinkManager.php:421 | 2 | if($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/Core/Repositories/Database.php:430 | 1 | if(empty($options[SaveOption::SKIP_CREATED_BY]) && (empty($options[SaveOption::IMPORT]) || !$entity->has(self::ATTR_CREATED_BY_ID)) && $this->applicationState->hasUser( )) { /**/ } |
| /application/Espo/Core/FieldValidation/FieldValidationManager.php:125 | 1 | if(!$entity->isNew( ) && $dataIsSet && !$entityDefs->tryGetField($field)?->getParam('forceValidation') && !$this->isFieldSetInData($entity->getEntityType( ), $field, $data)) { /**/ } |
| /application/Espo/Core/Mail/Sender.php:653 | 1 | if(stripos($e->getMessage( ), 'password') !== false || stripos($e->getMessage( ), 'credentials') !== false || stripos($e->getMessage( ), '5.7.8') !== false) { /**/ } |
| /application/Espo/Core/Record/Access/LinkCheck.php:586 | 1 | if(!in_array($relationDefs->getType( ), $typeList) || !$entityDefs->hasAttribute($attribute) || !$entity->isAttributeChanged($attribute) || $entity->get($attribute) === null) { /**/ } |
| /install/vendor/smarty/libs/sysplugins/smarty_cacheresource.php:351 | 1 | if($this->valid && $_template->caching === Smarty::CACHING_LIFETIME_SAVED && $_template->properties['cache_lifetime'] >= 0 && (time( ) > ($_template->cached->timestamp + $_template->properties['cache_lifetime']))) { /**/ } |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_compile_include.php:92 | 1 | if($compiler->template->caching && ((!$compiler->inheritance && !$compiler->nocache && !$compiler->tag_nocache) || ($compiler->inheritance && ($compiler->nocache || $compiler->tag_nocache)))) { /**/ } |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_compile_include.php:134 | 1 | if($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:144 | 1 | if(!((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_templatecompilerbase.php:415 | 1 | if($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:693 | 1 | if((!($this->template->source->recompiled) || $this->forceNocache) && $this->template->caching && !$this->suppressNocacheProcessing && ($this->nocache || $this->tag_nocache)) { /**/ } else { /**/ } |
| /install/vendor/smarty/libs/sysplugins/smarty_internal_utility.php:245 | 1 | if((!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_compile_private_modifier.php:122 | 1 | if(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_parsetree.php:283 | 1 | if($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_parsetree.php:287 | 1 | if(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_templatebase.php:300 | 1 | if((!$this->caching || $_template->has_nocache_code || $_template->source->recompiled) && !$no_output_filter && (isset($this->smarty->autoload_filters['output']) || isset($this->smarty->registered_filters['output']))) { /**/ } |
| /application/Espo/Core/Acl/DefaultAccessChecker.php:173 | 1 | if(!$this->config->get('aclAllowDeleteCreated') || !$entity->has(self::ATTR_CREATED_BY_ID) || $entity->get(self::ATTR_CREATED_BY_ID) !== $user->getId( )) { /**/ } |
| /application/Espo/Core/Acl/OwnerUserFieldProvider.php:68 | 1 | if($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/FieldProcessing/EmailAddress/Saver.php:429 | 1 | if($entity->has('emailAddressIsOptedOut') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsOptedOut') && $entity->get('emailAddressIsOptedOut') !== $entity->getFetched('emailAddressIsOptedOut')))) { /**/ } |
| /application/Espo/Core/FieldProcessing/EmailAddress/Saver.php:442 | 1 | if($entity->has('emailAddressIsInvalid') && ($entity->isNew( ) || ($entity->hasFetched('emailAddressIsInvalid') && $entity->get('emailAddressIsInvalid') !== $entity->getFetched('emailAddressIsInvalid')))) { /**/ } |
| /application/Espo/Core/Console/CommandManager.php:64 | 1 | if($command === null && ($params->hasFlag(self::DEFAULT_COMMAND_FLAG) || count($params->getFlagList( )) === 0 && count($params->getOptions( )) === 0 && count($params->getArgumentList( )) === 0)) { /**/ } |
| /application/Espo/Classes/DefaultLayouts/DefaultSidePanelType.php:50 | 1 | if($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/Acl/OwnerUserFieldProvider.php:77 | 1 | if($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:86 | 1 | if($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/Classes/RecordHooks/Note/AssignmentCheck.php:97 | 1 | if($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/RecordHooks/Role/BeforeSaveValidate.php:181 | 1 | if(!$this->metadata->get("scopes.$scope.entity") || !$this->metadata->get("scopes.$scope.$key") || $this->metadata->get("scopes.$scope.$disabledKey")) { /**/ } |
| /application/Espo/Classes/DuplicateWhereBuilders/General.php:151 | 2 | if(($entity->get($field) || $entity->get($field . 'Data')) && ($entity->isNew( ) || $entity->isAttributeChanged($field) || $entity->isAttributeChanged($field . 'Data'))) { /**/ } |
| /application/Espo/Classes/DuplicateWhereBuilders/General.php:188 | 2 | if(($entity->get($field) || $entity->get($field . 'Data')) && ($entity->isNew( ) || $entity->isAttributeChanged($field) || $entity->isAttributeChanged($field . 'Data'))) { /**/ } |
| /application/Espo/Classes/RecordHooks/User/BeforeUpdate.php:160 | 1 | if($entity->isSuperAdmin( ) || !$entity->isAttributeChanged('type') || !$entity->getType( ) || in_array($entity->getType( ), $this->util->getAllowedUserTypeList( ))) { /**/ } |
| /application/Espo/Classes/RecordHooks/User/AfterUpdate.php:84 | 1 | if(!$entity->isPortal( ) || !$entity->getContactId( ) || !$entity->isAttributeChanged('firstName') && !$entity->isAttributeChanged('lastName') && !$entity->isAttributeChanged('salutationName')) { /**/ } |
| /application/Espo/Classes/RecordHooks/User/BeforeUpdate.php:85 | 1 | if($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/User/BeforeUpdate.php:117 | 1 | if($portalUserLimit && !$this->user->isSuperAdmin( ) && (($entity->isActive( ) && $entity->isAttributeChanged('isActive') && $entity->isPortal( )) || ($entity->isPortal( ) && $entity->isAttributeChanged('type')))) { /**/ } |
| /application/Espo/Repositories/Email.php:511 | 1 | if(($entity->getStatus( ) === EmailEntity::STATUS_ARCHIVED || $entity->getStatus( ) === EmailEntity::STATUS_SENT) && ($entity->isAttributeChanged('status') || $entity->isNew( ))) { /**/ } |
| /application/Espo/Classes/Acl/Email/AccessChecker.php:142 | 1 | if($entity->getStatus( ) === Email::STATUS_DRAFT && $entity->getCreatedBy( ) && $entity->getCreatedBy( )->getId( ) === $user->getId( )) { /**/ } |
| /application/Espo/Classes/TemplateHelpers/GoogleMaps.php:81 | 1 | if(!$field && !$data->hasOption('street') && !$data->hasOption('city') && !$data->hasOption('country') && !$data->hasOption('state') && !$data->hasOption('postalCode')) { /**/ } |
| /application/Espo/Classes/FieldProcessing/Email/StringDataLoader.php:73 | 1 | if(in_array($entity->get('fromEmailAddressId'), $userEmailAddressIdList) || $entity->get('createdById') === $this->user->getId( ) && $entity->getStatus( ) === Email::STATUS_SENT) { /**/ } |
| /application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:403 | 2 | if($query->getJoins( ) !== [ ] || $query->getLeftJoins( ) !== [ ] || $query->getLimit( ) !== null || $query->getOrder( ) !== [ ]) { /**/ } |
| /application/Espo/ORM/QueryComposer/PostgresqlQueryComposer.php:359 | 2 | if($query->getJoins( ) !== [ ] || $query->getLeftJoins( ) !== [ ] || $query->getLimit( ) !== null || $query->getOrder( ) !== [ ]) { /**/ } |
| /application/Espo/ORM/Query/Select.php:194 | 1 | if((!empty($params['joins']) || !empty($params['leftJoins']) || !empty($params['whereClause']) || !empty($params['orderBy'])) && empty($params['from']) && empty($params['fromQuery'])) { /**/ } |
| /application/Espo/ORM/Mapper/BaseMapper.php:1526 | 1 | if($onlyStorable && ($this->getAttributeParam($entity, $attribute, 'notStorable') || $this->getAttributeParam($entity, $attribute, 'autoincrement') || ($this->getAttributeParam($entity, $attribute, 'source') && $this->getAttributeParam($entity, $attribute, 'source') !== 'db'))) { /**/ } |
| /application/Espo/Modules/Crm/Tools/Campaign/LogService.php:309 | 1 | if($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/Campaign/LogService.php:254 | 1 | if($this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['queueItemId' => $queueItem->getId( ), 'action' => CampaignLogRecord::ACTION_OPENED, 'isTest' => $queueItem->isTest( ), ])->findOne( )) { /**/ } |
| /application/Espo/Modules/Crm/Tools/Campaign/LogService.php:206 | 1 | if($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:154 | 1 | if($queueItem && $this->entityManager->getRDBRepository(CampaignLogRecord::ENTITY_TYPE)->where(['queueItemId' => $queueItem->getId( ), 'action' => CampaignLogRecord::ACTION_OPTED_IN, 'isTest' => $queueItem->isTest( ), ])->findOne( )) { /**/ } |
| /application/Espo/Controllers/Layout.php:170 | 1 | if(!is_string($scope) || !is_string($name) || !is_string($type) || !is_string($label) || !$scope || !$name || !$type || !$label) { /**/ } |
| /application/Espo/Modules/Crm/Tools/Activities/UpcomingService.php:107 | 1 | if(!$this->acl->checkScope($entityType, Table::ACTION_READ) || !$this->metadata->get(['entityDefs', $entityType, 'fields', 'dateStart']) || !$this->metadata->get(['entityDefs', $entityType, 'fields', 'dateEnd'])) { /**/ } |
| /application/Espo/Modules/Crm/Tools/Activities/ComposeEmailService.php:125 | 1 | if($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/Tools/Stream/Service.php:443 | 1 | if($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/LinkManager/LinkManager.php:278 | 2 | if($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:286 | 2 | if($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:367 | 2 | if($this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign) || $this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign . 'Id') || $this->metadata->get('entityDefs.' . $entityForeign . '.fields.' . $linkForeign . 'Name')) { /**/ } |
| /install/vendor/smarty/libs/sysplugins/smarty_resource.php:533 | 1 | if($_file_is_dotted && isset($_template) && $_template->parent instanceof Smarty_Internal_Template && ($_template->parent->source->type == 'file' || $_template->parent->source->type == 'extends')) { /**/ } else { /**/ } |
| /application/Espo/Tools/Stream/HookProcessor.php:89 | 1 | if($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:356 | 1 | if(!$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/Stream/HookProcessor.php:491 | 1 | if((method_exists($entity, $methodName) && $entity->$methodName( )) || (!method_exists($entity, $methodName) && ($entity->isAttributeChanged('assignedUserId') || $entity->isAttributeChanged('teamsIds') || $entity->isAttributeChanged('assignedUsersIds')))) { /**/ } |