/**
* @param string $DatabaseName
* @param null|TblAccount $tblAccount
* @param null|TblConsumer $tblConsumer
* @param null|Element $FromEntity
* @param null|Element $ToEntity
*
* @return false|TblProtocol
*/
public function createProtocolEntry($DatabaseName, TblAccount $tblAccount = null, TblConsumer $tblConsumer = null, Element $FromEntity = null, Element $ToEntity = null)
{
// Skip if nothing changed
if (null !== $FromEntity && null !== $ToEntity) {
$From = $FromEntity->__toArray();
sort($From);
$To = $ToEntity->__toArray();
sort($To);
if ($From === $To) {
return false;
}
}
$Manager = $this->Connection->getEntityManager();
$Entity = new TblProtocol();
$Entity->setProtocolDatabase($DatabaseName);
$Entity->setProtocolTimestamp(time());
if ($tblAccount) {
$Entity->setServiceTblAccount($tblAccount);
$Entity->setAccountUsername($tblAccount->getUsername());
}
if ($tblConsumer) {
$Entity->setServiceTblConsumer($tblConsumer);
$Entity->setConsumerName($tblConsumer->getName());
$Entity->setConsumerAcronym($tblConsumer->getAcronym());
}
$Entity->setEntityFrom($FromEntity ? serialize($FromEntity) : null);
$Entity->setEntityTo($ToEntity ? serialize($ToEntity) : null);
$Manager->saveEntity($Entity);
return $Entity;
}
/**
* @param integer $Id
*
* @return bool|TblCompany
*/
public function getCompanyById($Id)
{
/** @var IApiInterface $Cache */
$Cache = (new Cache(new Memcached()))->getCache();
if (!($Entity = $Cache->getValue(__METHOD__ . '::' . $Id))) {
$Entity = $this->Connection->getEntityManager()->getEntityById('TblCompany', $Id);
$Cache->setValue(__METHOD__ . '::' . $Id, null === $Entity ? false : $Entity, 500);
}
return null === $Entity ? false : $Entity;
}
/**
* @param TblResponsibility $tblResponsibility
*
* @return bool
*/
public function removeResponsibility(TblResponsibility $tblResponsibility)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblResponsibility $Entity */
$Entity = $Manager->getEntityById('TblResponsibility', $tblResponsibility->getId());
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @param \SPHERE\Application\Platform\Gatekeeper\Authorization\Token\Service\Entity\TblToken $tblToken
*/
public function destroyToken(TblToken $tblToken)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntityById('TblToken', $tblToken->getId());
if (null !== $Entity) {
$Manager->killEntity($Entity);
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
}
}
/**
*
* @param TblRole $tblRole
*
* @return bool|TblRoleLevel[]
*/
public function getLevelAllByRole(TblRole $tblRole)
{
/** @var TblRoleLevel[] $EntityList */
$EntityList = $this->Connection->getEntityManager()->getEntity('TblRoleLevel')->findBy(array(TblRoleLevel::ATTR_TBL_ROLE => $tblRole->getId()));
array_walk($EntityList, function (TblRoleLevel &$V) {
$V = $V->getTblLevel();
});
return null === $EntityList ? false : $EntityList;
}
/**
*
* @param TblRole $tblRole
*
* @return bool|TblRoleLevel[]
*/
public function getLevelAllByRole(TblRole $tblRole)
{
$EntityList = $this->getCachedEntityListBy(__METHOD__, $this->Connection->getEntityManager(), 'TblRoleLevel', array(TblRoleLevel::ATTR_TBL_ROLE => $tblRole->getId()));
if ($EntityList) {
array_walk($EntityList, function (TblRoleLevel &$V) {
$V = $V->getTblLevel();
});
}
return $EntityList;
}
/**
* @param string $DatabaseName
* @param null|TblAccount $tblAccount
* @param null|TblConsumer $tblConsumer
* @param null|Element $Entity
* @param int $Type
*
* @return false|TblArchive
*/
public function createArchiveEntry($DatabaseName, TblAccount $tblAccount = null, TblConsumer $tblConsumer = null, Element $Entity = null, $Type = TblArchive::ARCHIVE_TYPE_CREATE)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Entity ? serialize($this->persistData($Entity)) : null;
$Archive = new TblArchive($Type);
$Archive->setArchiveDatabase($DatabaseName);
$Archive->setArchiveTimestamp(time());
if ($tblAccount) {
$Archive->setServiceTblAccount($tblAccount);
$Archive->setAccountUsername($tblAccount->getUsername());
}
if ($tblConsumer) {
$Archive->setServiceTblConsumer($tblConsumer);
$Archive->setConsumerName($tblConsumer->getName());
$Archive->setConsumerAcronym($tblConsumer->getAcronym());
}
$Archive->setEntity($Entity);
$Manager->saveEntity($Archive);
return $Archive;
}
/**
* @param $Name
*
* @return TblCommodityType
*/
public function actionCreateCommodityType($Name)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblCommodityType')->findOneBy(array('Name' => $Name));
if (null === $Entity) {
$Entity = new TblCommodityType();
$Entity->setName($Name);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
}
return $Entity;
}
/**
* @param TblGroup $tblGroup
*
* @return bool
*/
public function destroyGroup(TblGroup $tblGroup)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblMember $Entity */
$Entity = $Manager->getEntityById('TblGroup', $tblGroup->getId());
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @param TblAccount $tblAccount
* @param TblPerson $tblPerson
*
* @return bool
*/
public function removeAccountPerson(TblAccount $tblAccount, TblPerson $tblPerson)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblUser $Entity */
$Entity = $Manager->getEntity('TblUser')->findOneBy(array(TblUser::ATTR_TBL_ACCOUNT => $tblAccount->getId(), TblUser::SERVICE_TBL_PERSON => $tblPerson->getId()));
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @param TblItemAccount $tblItemAccount
*
* @return bool
*/
public function actionRemoveItemAccount(TblItemAccount $tblItemAccount)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblItemAccount')->findOneBy(array('Id' => $tblItemAccount->getId()));
if (null !== $Entity) {
/** @var Element $Entity */
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @param TblCompany $tblCompany
* @param TblPerson $tblPerson
* @param TblType $tblType
* @param string $Remark
*
* @return TblToCompany
*/
public function addCompanyRelationshipToPerson(TblCompany $tblCompany, TblPerson $tblPerson, TblType $tblType, $Remark)
{
$Manager = $this->Connection->getEntityManager();
$Entity = new TblToCompany();
$Entity->setServiceTblCompany($tblCompany);
$Entity->setServiceTblPerson($tblPerson);
$Entity->setTblType($tblType);
$Entity->setRemark($Remark);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
return $Entity;
}
/**
* @param TblProspect $tblProspect
* @param string $Remark
*
* @return TblProspect
*/
public function updateProspect(TblProspect $tblProspect, $Remark)
{
$Manager = $this->Connection->getEntityManager();
/** @var null|TblProspect $Entity */
$Entity = $Manager->getEntityById('TblProspect', $tblProspect->getId());
if (null !== $Entity) {
$Protocol = clone $Entity;
$Entity->setRemark($Remark);
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $Entity);
return true;
}
return false;
}
/**
* @param TblCompany $tblCompany
* @param TblMail $tblMail
* @param TblType $tblType
* @param string $Remark
*
* @return TblToCompany
*/
public function addMailToCompany(TblCompany $tblCompany, TblMail $tblMail, TblType $tblType, $Remark)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblToCompany')->findOneBy(array(TblToCompany::SERVICE_TBL_COMPANY => $tblCompany->getId(), TblToCompany::ATT_TBL_MAIL => $tblMail->getId(), TblToCompany::ATT_TBL_TYPE => $tblType->getId()));
if (null === $Entity) {
$Entity = new TblToCompany();
$Entity->setServiceTblCompany($tblCompany);
$Entity->setTblMail($tblMail);
$Entity->setTblType($tblType);
$Entity->setRemark($Remark);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
}
return $Entity;
}
/**
* @param TblConsumer $tblConsumer
* @param TblAccount $tblAccount
*
* @return bool
*/
public function changeConsumer(TblConsumer $tblConsumer, TblAccount $tblAccount = null)
{
if (null === $tblAccount) {
$tblAccount = $this->getAccountBySession();
}
$Manager = $this->Connection->getEntityManager();
/** @var TblAccount $Entity */
$Entity = $Manager->getEntityById('TblAccount', $tblAccount->getId());
$Protocol = clone $Entity;
if (null !== $Entity) {
$Entity->setServiceTblConsumer($tblConsumer);
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $Entity);
return true;
}
return false;
}
/**
* @param Entity\TblCommodity $tblCommodity
*
* @return bool
*/
public function actionRemoveCommodity(TblCommodity $tblCommodity)
{
$Manager = $this->Connection->getEntityManager();
$EntityItems = $Manager->getEntity('TblCommodityItem')->findBy(array(TblCommodityItem::ATTR_TBL_COMMODITY => $tblCommodity->getId()));
if (null !== $EntityItems) {
foreach ($EntityItems as $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
}
}
$Entity = $Manager->getEntity('TblCommodity')->findOneBy(array('Id' => $tblCommodity->getId()));
if (null !== $Entity) {
/** @var Element $Entity */
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @param TblBasket $tblBasket
*
* @return bool
*/
public function actionDestroyTempInvoice(TblBasket $tblBasket)
{
if ($tblBasket !== null) {
$Manager = $this->Connection->getEntityManager();
/** @var TblTempInvoice[] $EntityList */
$EntityList = $Manager->getEntity('TblTempInvoice')->findBy(array(TblTempInvoice::ATTR_SERVICE_BILLING_BASKET => $tblBasket->getId()));
foreach ($EntityList as $Entity) {
$EntitySubList = $Manager->getEntity('TblTempInvoiceCommodity')->findBy(array(TblTempInvoiceCommodity::ATTR_TBL_TEMP_INVOICE => $Entity->getId()));
foreach ($EntitySubList as $SubEntity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $SubEntity);
$Manager->bulkKillEntity($SubEntity);
}
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->bulkKillEntity($Entity);
}
$Manager->flushCache();
return true;
}
return false;
}
/**
* @param TblBasket $tblBasket
*
* @return bool
*/
public function actionDestroyBasketCommodity(TblBasket $tblBasket)
{
if ($tblBasket !== null) {
$Manager = $this->Connection->getEntityManager();
/** @var TblBasketCommodity[] $EntityList */
$EntityList = $Manager->getEntity('TblBasketCommodity')->findBy(array(TblBasketCommodity::ATTR_TBL_BASKET => $tblBasket->getId()));
foreach ($EntityList as $Entity) {
$EntitySubList = $Manager->getEntity('TblBasketCommodityDebtor')->findBy(array(TblBasketCommodityDebtor::ATTR_TBL_BASKET_COMMODITY => $Entity->getId()));
foreach ($EntitySubList as $SubEntity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $SubEntity);
$Manager->bulkKillEntity($SubEntity);
}
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->bulkKillEntity($Entity);
}
$Manager->flushCache();
return true;
}
return false;
}
/**
*
* @param TblPerson $tblPerson
*
* @return bool|TblCommon
*/
public function getCommonByPerson(TblPerson $tblPerson)
{
/** @var TblCommon $Entity */
$Entity = $this->Connection->getEntityManager()->getEntity('TblCommon')->findOneBy(array(TblCommon::SERVICE_TBL_PERSON => $tblPerson->getId()));
return null === $Entity ? false : $Entity;
}
/**
* @return TblConsumer[]|bool
*/
public function getConsumerAll()
{
return $this->getCachedEntityList(__METHOD__, $this->Connection->getEntityManager(), 'TblConsumer');
}
/**
* @param int $Id
*
* @return bool|TblStudentTransferProcess
*/
public function getStudentTransferProcessById($Id)
{
return $this->getCachedEntityById(__METHOD__, $this->Connection->getEntityManager(), 'TblStudentTransferProcess', $Id);
}
/**
* @return array|bool|TblAccountType[]
*/
public function entityAccountTypeAll()
{
$Entity = $this->Connection->getEntityManager()->getEntity('TblAccountType')->findAll();
return null === $Entity ? false : $Entity;
}
/**
* @return bool|TblTestPicture[]
*/
public function getTestPictureAll()
{
$EntityList = $this->Connection->getEntityManager()->getEntity('TblTestPicture')->findAll();
return empty($EntityList) ? false : $EntityList;
}
/**
* @return bool|TblScoreType[]
*/
public function getScoreTypeAll()
{
$EntityList = $this->Connection->getEntityManager()->getEntity('TblScoreType')->findAll();
return empty($EntityList) ? false : $EntityList;
}
/**
* @param integer $Id
*
* @return bool|TblSalutation
*/
public function getSalutationById($Id)
{
return $this->getCachedEntityById(__METHOD__, $this->Connection->getEntityManager(), 'TblSalutation', $Id);
}
/**
* @param int $Id
*
* @return bool|TblCustody
*/
public function getCustodyById($Id)
{
return $this->getCachedEntityById(__METHOD__, $this->Connection->getEntityManager(), 'TblCustody', $Id);
}
/**
* @param integer $Id
*
* @return bool|TblCompany
*/
public function getCompanyById($Id)
{
$Entity = $this->Connection->getEntityManager()->getEntityById('TblCompany', $Id);
return null === $Entity ? false : $Entity;
}
/**
* @param $Id
*
* @return bool|TblPaymentType
*/
public function entityPaymentTypeById($Id)
{
$Entity = $this->Connection->getEntityManager()->getEntityById('TblPaymentType', $Id);
return null === $Entity ? false : $Entity;
}
/**
* @return \SPHERE\Application\Platform\Gatekeeper\Authorization\Consumer\Service\Entity\TblConsumer[]|bool
*/
public function getConsumerAll()
{
$EntityList = $this->Connection->getEntityManager()->getEntity('TblConsumer')->findAll();
return empty($EntityList) ? false : $EntityList;
}