Many-to-One, One-to-One Right, One-to-One Left, Children-to-Parent
One-to-Many, Many-to-Many
Tweet
ifThen(
entity\isAttributeChanged('assignedUserId') && assignedUser.jeObchodnik == true && assignedUser.pocetLeaduAktualniKvartal >= 100,
assignedUserId = entity\attributeFetched('assignedUserId')
);
we are using: Current version: 7.3.3 at the moment but I will upgrade to 7.4 soon.
<?php
namespace Espo\Custom\Classes\RecordHooks\Lead;
use Espo\Core\Record\Hook\UpdateHook;
use Espo\Core\Exceptions\ConflictSilent;
use Espo\Core\Exceptions\Error;
use Espo\Core\Utils\Json;
use Espo\Core\Record\UpdateParams;
use Espo\ORM\Entity;
use Espo\Modules\Crm\Entities\Lead as LeadEntity;
use Espo\ORM\EntityManager;
/**
* @implements UpdateHook<LeadEntity>
*/
class BeforeUpdateUserAssignment implements UpdateHook
{
public function __construct(private EntityManager $entityManager){}
public function process(Entity $entity, UpdateParams $params): void
{
/** @var LeadEntity $entity */
if (!$entity->isAttributeChanged('assignedUserId')) {
return;
}
$this->processAssignment($entity);
}
private function processAssignment(Entity $entity): void
{
$assignedUser = $entity->get('assignedUser');
// Get the number of leads' count for the assigned user - based on what you have in formula
$numberofLeads = $assignedUser->get('pocetLeaduAktualniKvartal');
// Get the jeObchodnik boolean - based on what you have on formula
$jeObchodnik = $assignedUser->get('jeObchodnik');
// Check the condition and if it is true create an error and send it to the frontend
if ($numberofLeads >= 100 && $jeObchodnik === true) {
throw Error::createWithBody(
'leadAssignment',
Json::encode([
'assignedUserName' => $entity->get('assignedUserName'),
'count' => $numberofLeads,
])
);
}
}
}
{
"beforeUpdateHookClassNameList": [
"__APPEND__",
"Espo\\Custom\\Classes\\RecordHooks\\Lead\\BeforeUp dateUserAssignment"
]
}
{
"saveErrorHandlers": {
"leadAssignment": "custom:handlers/lead/lead-assignment-handler"
}
}
define('custom:handlers/lead/lead-assignment-handler', [], function () {
return class {
constructor(view) {
/** @type {module:views/record/detail.Class} */
this.view = view;
}
process(data) {
let assigneduser = data.assignedUserName;
let count = data.count;
// If you want you can display a warning instead which will be displayed for few second and disapear - see commented code
// Espo.Ui.warning(assigneduser + ' has more than ' + count + ' Leads please reassign lead to another user', true);
Espo.Ui.error(assigneduser + ' has more than ' + count + ' Leads please reassign lead to another user', true);
}
}
});
{
"kanbanViewMode": true,
"color": "#d6a2c9",
"iconClass": "fas fa-address-card",
"saveErrorHandlers": {
"leadAssignment": "custom:handlers/lead/lead-assignment-handler"
},
"dynamicLogic": {
"fields": {
"faktAdresa": {
"visible": {
"conditionGroup": [
{
"type": "isFalse",
"attribute": "adresaAkoFakturacna"
}
]
}
},
"gpsAdrStupne": {
"visible": {
"conditionGroup": [
{
"type": "isNotEmpty",
"attribute": "gpsAdr"
}
]
}
},
"name": {
"required": {
"conditionGroup": [
{
"type": "isEmpty",
"attribute": "accountName"
},
{
"type": "isEmpty",
"attribute": "emailAddress"
},
{
"type": "isEmpty",
"attribute": "phoneNumber"
}
]
}
},
"firmaVytvorena": {
"visible": null
},
"phoneNumber": {
"required": {
"conditionGroup": [
{
"type": "isEmpty",
"attribute": "emailAddress"
}
]
}
},
"emailAddress": {
"required": {
"conditionGroup": [
{
"type": "isEmpty",
"attribute": "phoneNumber"
}
]
}
},
"convertedAt": {
"visible": {
"conditionGroup": [
{
"type": "and",
"value": [
{
"type": "equals",
"attribute": "status",
"value": "Converted"
},
{
"type": "isNotEmpty",
"attribute": "convertedAt"
}
]
}
]
}
},
"datumNeberieHovor": {
"visible": {
"conditionGroup": [
{
"type": "equals",
"attribute": "status",
"value": "New"
},
{
"type": "isTrue",
"attribute": "neberieHovorPredPrir"
}
]
}
},
"neberieHovorPredPrir": {
"visible": {
"conditionGroup": [
{
"type": "equals",
"attribute": "status",
"value": "New"
}
]
}
},
"gpsApp": {
"visible": {
"conditionGroup": [
{
"type": "isNotEmpty",
"attribute": "gpsAdr"
}
]
}
},
"addressState": {
"required": {
"conditionGroup": [
{
"type": "equals",
"attribute": "status",
"value": "Assigned"
}
]
}
},
"faktAdresaState": {
"required": {
"conditionGroup": [
{
"type": "notEquals",
"attribute": "status",
"value": "New"
}
]
}
}
}
}
}
return class {
constructor(view) {
/** @type {module:views/record/detail.Class} */
this.view = view;
}
return class {
constructor(view) {
/* @type {module:views/record/detail.Class} */
this.view = view;
}
Comment