/**
* @param TblCompany $tblCompany
*
* @return TblResponsibility|bool
*/
public function addResponsibility(TblCompany $tblCompany)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblResponsibility')->findOneBy(array(TblResponsibility::SERVICE_TBL_COMPANY => $tblCompany->getId()));
if (null === $Entity) {
$Entity = new TblResponsibility();
$Entity->setServiceTblCompany($tblCompany);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
return $Entity;
}
return false;
}
/**
* @param TblCompany $tblCompany
* @param string $Name
*
* @return TblCompany
*/
public function updateCompany(TblCompany $tblCompany, $Name)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblCompany $Entity */
$Entity = $Manager->getEntityById('TblCompany', $tblCompany->getId());
$Protocol = clone $Entity;
if (null !== $Entity) {
$Entity->setName($Name);
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $Entity);
return true;
}
return false;
}
/**
* @param TblCompany|null $tblCompany
*/
public function setServiceTblCompany(TblCompany $tblCompany = null)
{
$this->serviceTblCompany = null === $tblCompany ? null : $tblCompany->getId();
}
/**
* @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 TblGroup $tblGroup
* @param TblCompany $tblCompany
*
* @return bool
*/
public function removeGroupCompany(TblGroup $tblGroup, TblCompany $tblCompany)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblMember $Entity */
$Entity = $Manager->getEntity('TblMember')->findOneBy(array(TblMember::ATTR_TBL_GROUP => $tblGroup->getId(), TblMember::SERVICE_TBL_COMPANY => $tblCompany->getId()));
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @param TblCompany $tblCompany
*
* @return bool|TblToCompany[]
*/
public function getCompanyRelationshipAllByCompany(TblCompany $tblCompany)
{
$EntityList = $this->Connection->getEntityManager()->getEntity('TblToCompany')->findBy(array(TblToCompany::SERVICE_TBL_COMPANY => $tblCompany->getId()));
return empty($EntityList) ? false : $EntityList;
}
/**
* @param TblCompany $tblCompany
* @param TblType $tblType
*
* @return TblSchool|bool
*/
public function addSchool(TblCompany $tblCompany, TblType $tblType)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblSchool')->findOneBy(array(TblSchool::SERVICE_TBL_COMPANY => $tblCompany->getId(), TblSchool::ATT_TBL_TYPE => $tblType->getId()));
if (null === $Entity) {
$Entity = new TblSchool();
$Entity->setServiceTblCompany($tblCompany);
$Entity->setTblType($tblType);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
return $Entity;
}
return false;
}
/**
* @param TblCompany $tblCompany
*
* @return bool|TblToCompany[]
*/
public function getAddressAllByCompany(TblCompany $tblCompany)
{
/** @var IApiInterface $Cache */
$Cache = (new Cache(new Memory()))->getCache();
if (!($Entity = $Cache->getValue(__METHOD__))) {
$EntityList = $this->Connection->getEntityManager()->getEntity('TblToCompany')->findBy(array(TblToCompany::SERVICE_TBL_COMPANY => $tblCompany->getId()));
$Cache->setValue(__METHOD__, empty($EntityList) ? false : $EntityList, 300);
}
return empty($EntityList) ? false : $EntityList;
}
