/**
* @param TblTestPicture $tblTestPicture
*
* @return bool
*/
public function removeTestPicture(TblTestPicture $tblTestPicture)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntityById('TblTestPicture', $tblTestPicture->getId());
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @return Stage
*/
public function frontendProtocol()
{
$Stage = new Stage('Protokoll', 'Aktivit?ten');
$ProtocolList = Protocol::useService()->getProtocolAll();
// foreach($ProtocolList as $Key => &$Protocol)
// {
// $Protocol->Editor = 0;
// }
$Stage->setContent(new TableData($ProtocolList, null, array('Id' => '#', 'Editor' => 'Editor', 'Origin' => 'Origin', 'Commit' => 'Commit'), array("order" => array(array(0, 'desc')), "columnDefs" => array(array("orderable" => false, "targets" => 1), array("orderable" => false, "targets" => 2), array("orderable" => false, "targets" => 3)))));
return $Stage;
}
/**
* @param TblScoreType $tblScoreType
*
* @return bool
*/
public function removeScoreTypeByEntity(TblScoreType $tblScoreType)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblScoreType')->findOneBy(array('Id' => $tblScoreType->getId()));
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
return true;
}
return false;
}
/**
* @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 string $Acronym
* @param string $Name
*
* @return TblConsumer
*/
public function createConsumer($Acronym, $Name)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblConsumer')->findOneBy(array(TblConsumer::ATTR_ACRONYM => $Acronym));
if (null === $Entity) {
$Entity = new TblConsumer($Acronym);
$Entity->setName($Name);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
}
return $Entity;
}
/**
* @param $Name
* @param $Description
*
* @return null|object|TblType
*/
public function createType($Name, $Description = '')
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblType')->findOneBy(array(TblType::ATTR_NAME => $Name));
if (null === $Entity) {
$Entity = new TblType();
$Entity->setName($Name);
$Entity->setDescription($Description);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
}
return $Entity;
}
/**
* @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;
}
public static function registerApplication()
{
/**
* Register Module
*/
Protocol::registerModule();
Database::registerModule();
Cache::registerModule();
Test::registerModule();
/**
* Register Navigation
*/
Main::getDisplay()->addApplicationNavigation(new Link(new Link\Route(__NAMESPACE__), new Link\Name('System'), new Link\Icon(new Cog())));
Main::getDispatcher()->registerRoute(Main::getDispatcher()->createRoute(__NAMESPACE__, __CLASS__ . '::frontendDashboard'));
}
/**
* @param TblCustody $tblCustody
* @param string $Remark
* @param string $Occupation
* @param string $Employment
*
* @return TblCustody
*/
public function updateCustody(TblCustody $tblCustody, $Remark, $Occupation, $Employment)
{
$Manager = $this->Connection->getEntityManager();
/** @var null|TblCustody $Entity */
$Entity = $Manager->getEntityById('TblCustody', $tblCustody->getId());
if (null !== $Entity) {
$Protocol = clone $Entity;
$Entity->setRemark($Remark);
$Entity->setOccupation($Occupation);
$Entity->setEmployment($Employment);
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $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 TblPerson $tblPerson
* @param TblSalutation $tblSalutation
* @param string $Title
* @param string $FirstName
* @param string $SecondName
* @param string $LastName
*
* @return bool
*/
public function updatePerson(TblPerson $tblPerson, TblSalutation $tblSalutation, $Title, $FirstName, $SecondName, $LastName)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblPerson $Entity */
$Entity = $Manager->getEntityById('TblPerson', $tblPerson->getId());
$Protocol = clone $Entity;
if (null !== $Entity) {
$Entity->setTblSalutation($tblSalutation);
$Entity->setTitle($Title);
$Entity->setFirstName($FirstName);
$Entity->setSecondName($SecondName);
$Entity->setLastName($LastName);
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $Entity);
return true;
}
return false;
}
public function actionEditDebtor(TblDebtor $tblDebtor, $Description, $PaymentType, $Owner, $IBAN, $BIC, $CashSign, $BankName, $LeadTimeFirst, $LeadTimeFollow)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblDebtor $Entity */
$Entity = $Manager->getEntityById('TblDebtor', $tblDebtor->getId());
$Protocol = clone $Entity;
if (null !== $Entity) {
$Entity->setDescription($Description);
$Entity->setPaymentType(Banking::useService()->entityPaymentTypeById($PaymentType));
$Entity->setOwner($Owner);
$Entity->setIBAN($IBAN);
$Entity->setBIC($BIC);
$Entity->setCashSign($CashSign);
$Entity->setBankName($BankName);
$Entity->setLeadTimeFirst($LeadTimeFirst);
$Entity->setLeadTimeFollow($LeadTimeFollow);
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $Entity);
return true;
}
return false;
}
/**
* @param TblCategory $tblCategory
* @param TblSubject $tblSubject
*
* @return bool
*/
public function removeCategorySubject(TblCategory $tblCategory, TblSubject $tblSubject)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblCategorySubject $Entity */
$Entity = $Manager->getEntity('TblCategorySubject')->findOneBy(array(TblCategorySubject::ATTR_TBL_CATEGORY => $tblCategory->getId(), TblCategorySubject::ATTR_TBL_SUBJECT => $tblSubject->getId()));
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($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 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 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 TblLevel $tblLevel
* @param TblPrivilege $tblPrivilege
*
* @return bool
*/
public function removeLevelPrivilege(TblLevel $tblLevel, TblPrivilege $tblPrivilege)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblLevelPrivilege $Entity */
$Entity = $Manager->getEntity('TblLevelPrivilege')->findOneBy(array(TblLevelPrivilege::ATTR_TBL_LEVEL => $tblLevel->getId(), TblLevelPrivilege::ATTR_TBL_PRIVILEGE => $tblPrivilege->getId()));
if (null !== $Entity) {
Protocol::useService()->createDeleteEntry($this->Connection->getDatabase(), $Entity);
$Manager->killEntity($Entity);
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 TblStudentMedicalRecord $tblStudentMedicalRecord
* @param string $Disease
* @param string $Medication
* @param null|TblPerson $tblPersonAttendingDoctor
* @param int $InsuranceState
* @param string $Insurance
*
* @return TblStudentMedicalRecord
*/
public function updateStudentMedicalRecord(TblStudentMedicalRecord $tblStudentMedicalRecord, $Disease, $Medication, TblPerson $tblPersonAttendingDoctor, $InsuranceState, $Insurance)
{
$Manager = $this->Connection->getEntityManager();
/** @var null|TblStudentMedicalRecord $Entity */
$Entity = $Manager->getEntityById('TblStudentMedicalRecord', $tblStudentMedicalRecord->getId());
if (null !== $Entity) {
$Protocol = clone $Entity;
$Entity->setDisease($Disease);
$Entity->setMedication($Medication);
$Entity->setServiceTblPersonAttendingDoctor($tblPersonAttendingDoctor);
$Entity->setInsuranceState($InsuranceState);
$Entity->setInsurance($Insurance);
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $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 $PaymentType
*
* @return TblPaymentType|null|object
*/
public function actionCreatePaymentType($PaymentType)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblPaymentType')->findOneBy(array(TblPaymentType::ATTR_NAME => $PaymentType));
if (null === $Entity) {
$Entity = new TblPaymentType();
$Entity->setName($PaymentType);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
}
return $Entity;
}
/**
* @param $Id
*
* @return bool
*/
public function actionDeactivateAccount($Id)
{
$Manager = $this->Connection->getEntityManager();
/** @var TblAccount $Entity */
$Entity = $Manager->getEntityById('TblAccount', $Id);
$Protocol = clone $Entity;
if (null !== $Entity) {
$Entity->setIsActive('0');
$Manager->saveEntity($Entity);
Protocol::useService()->createUpdateEntry($this->Connection->getDatabase(), $Protocol, $Entity);
return true;
}
return false;
}
/**
* @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 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 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;
}
