i try to do sample... with my github

don't kill me, certainly many error but..
i think my cisco call-to-click is best of the best

namespace Espo\Modules\PropertyManagement\SelectManagers;
class ServiceTicket extends \Espo\Core\SelectManagers\Base
{
protected function boolFilterOpen(&$result)
{
$this->filterOpen($result);
}
protected function filterOpen(&$result)
{
$result['whereClause'][] = array('status!=' => ['Completed', 'Canceled', 'Deferred', 'Rejected']);
}
}
namespace Espo\Modules\PropertyManagement\Classes\Select\ServiceTicket\PrimaryFilters;
use Espo\ORM\Query\SelectBuilder;
use Espo\ORM\Query\Part\Condition as Cond;
use Espo\Core\Select\Primary\Filter;
class Open implements Filter
{
public function apply(SelectBuilder $queryBuilder): void
{
$notOpenList = ['Completed', 'Canceled', 'Deferred', 'Rejected'];
$queryBuilder->where(
Cond::notIn(
Cond::column('status'),
$notOpenList
)
);
}
}
namespace Espo\Modules\PropertyManagement\Classes\Select\Ser viceTicket\BoolFilters;
use Espo\Core\Select\Bool\Filter;
use Espo\ORM\Query\SelectBuilder;
use Espo\ORM\Query\Part\Where\OrGroupBuilder;
use Espo\ORM\Query\Part\Condition as Cond;
class Open implements Filter
{
public function apply(SelectBuilder $queryBuilder, OrGroupBuilder $orGroupBuilder): void
{
$notOpenList = ['Completed', 'Canceled', 'Deferred', 'Rejected'];
$orGroupBuilder->add(
Cond::notIn(
Cond::column('status'),
$notOpenList
)
);
}
}
{ "primaryFilterClassNameMap": { "open": "Espo\\Modules\\PropertyManagement\\Classes\\Selec t\\ServiceTicket\\PrimaryFilters\\Open" }, "boolFilterClassNameMap": { "open": "Espo\\Modules\\PropertyManagement\\Classes\\Selec t\\ServiceTicket\\BoolFilters\\Open" } }
<?php
namespace Espo\Custom\SelectManagers;
class Patient extends \Espo\Core\SelectManagers\Base
{
protected function boolFilterOnlyUsers(&$result)
{
$wherePart = null;
if ($this->getSeed()->hasRelation('assignedsUsers')) {
$this->setDistinct(true, $result);
$this->addLeftJoin(['assignedsUsers', 'assignedsUsersOnlyMyFilter'], $result);
$wherePart = [
'assignedsUsersOnlyMyFilter.id' => $this->getUser()->id
];
}
return $wherePart;
}
}
Leave a comment: