DerDu/SPHERE-Framework

<?php
namespace SPHERE\Application\People\Meta\Common\Service;

use SPHERE\Application\People\Meta\Common\Service\Entity\TblCommon;
use SPHERE\Application\People\Meta\Common\Service\Entity\TblCommonBirthDates;
use SPHERE\Application\People\Meta\Common\Service\Entity\TblCommonGender;
use SPHERE\Application\People\Meta\Common\Service\Entity\TblCommonInformation;
use SPHERE\Application\People\Meta\Common\Service\Entity\ViewPeopleMetaCommon;
use SPHERE\Application\People\Person\Service\Entity\TblPerson;
use SPHERE\Application\Platform\System\Protocol\Protocol;
use SPHERE\System\Database\Binding\AbstractData;

/**
 * Class Data
 *
 * @package SPHERE\Application\People\Meta\Common\Service
 */
class Data extends AbstractData
{

    /**
     * @return false|ViewPeopleMetaCommon[]
     */
    public function viewPeopleMetaCommon()
    {

        return $this->getCachedEntityList(
            __METHOD__, $this->getConnection()->getEntityManager(), 'ViewPeopleMetaCommon'
        );
    }
    
    public function setupDatabaseContent()
    {
        $this->createCommonGender( 'Männlich' );
        $this->createCommonGender( 'Weiblich' );
    }

    /**
     *
     * @param TblPerson $tblPerson
     * @param bool      $IsForced
     *
     * @return bool|TblCommon
     */
    public function getCommonByPerson(TblPerson $tblPerson, $IsForced = false)
    {

        if($IsForced){
            return $this->getForceEntityBy(__METHOD__, $this->getConnection()->getEntityManager(), 'TblCommon', array(
                TblCommon::SERVICE_TBL_PERSON => $tblPerson->getId()
            ));
        } else {
            return $this->getCachedEntityBy(__METHOD__, $this->getConnection()->getEntityManager(), 'TblCommon', array(
                TblCommon::SERVICE_TBL_PERSON => $tblPerson->getId()
            ));
        }

    }

    /**
     * @param string $Name
     *
     * @return TblCommonGender
     */
    public function createCommonGender($Name)
    {

        $Manager = $this->getConnection()->getEntityManager();
        $Entity = $Manager->getEntity('TblCommonGender')->findOneBy(array(TblCommonGender::ATTR_NAME => $Name));
        if (null === $Entity) {
            $Entity = new TblCommonGender();
            $Entity->setName( $Name );
            $Manager->saveEntity($Entity);
            Protocol::useService()->createInsertEntry($this->getConnection()->getDatabase(), $Entity);
        }
        return $Entity;
    }

    /**
     * @param string $Birthday
     * @param string $Birthplace
     * @param int    $Gender
     *
     * @return TblCommonBirthDates
     */
    public function createCommonBirthDates(
        $Birthday,
        $Birthplace,
        $Gender
    ) {

        $Manager = $this->getConnection()->getEntityManager();

        $Entity = new TblCommonBirthDates();
        $Entity->setBirthday(( $Birthday ? new \DateTime($Birthday) : null ));
        $Entity->setBirthplace($Birthplace);
        $Entity->setGender($Gender);
        $Manager->saveEntity($Entity);
        Protocol::useService()->createInsertEntry($this->getConnection()->getDatabase(), $Entity);

        return $Entity;
    }

    /**
     * @param string $Nationality
     * @param string $Denomination
     * @param int    $IsAssistance
     * @param string $AssistanceActivity
     *
     * @return TblCommonInformation
     */
    public function createCommonInformation(
        $Nationality,
        $Denomination,
        $IsAssistance,
        $AssistanceActivity
    ) {

        $Manager = $this->getConnection()->getEntityManager();

        $Entity = new TblCommonInformation();
        $Entity->setNationality($Nationality);
        $Entity->setDenomination($Denomination);
        $Entity->setAssistance($IsAssistance);
        $Entity->setAssistanceActivity($AssistanceActivity);
        $Manager->saveEntity($Entity);
        Protocol::useService()->createInsertEntry($this->getConnection()->getDatabase(), $Entity);

        return $Entity;
    }

    /**
     * @param TblPerson            $tblPerson
     * @param TblCommonBirthDates  $tblCommonBirthDates
     * @param TblCommonInformation $tblCommonInformation
     * @param string               $Remark
     *
     * @return TblCommon
     */
    public function createCommon(
        TblPerson $tblPerson,
        TblCommonBirthDates $tblCommonBirthDates,
        TblCommonInformation $tblCommonInformation,
        $Remark
    ) {

        $Manager = $this->getConnection()->getEntityManager();

        $Entity = new TblCommon();
        $Entity->setServiceTblPerson($tblPerson);
        $Entity->setTblCommonBirthDates($tblCommonBirthDates);
        $Entity->setTblCommonInformation($tblCommonInformation);
        $Entity->setRemark($Remark);
        $Manager->saveEntity($Entity);
        Protocol::useService()->createInsertEntry($this->getConnection()->getDatabase(), $Entity);

        return $Entity;
    }

    /**
     * @param int $Id
     *
     * @return bool|TblCommon
     */
    public function getCommonById($Id)
    {

        return $this->getCachedEntityById(__METHOD__, $this->getConnection()->getEntityManager(), 'TblCommon', $Id);
    }

    /**
     * @param int $Id
     *
     * @return bool|TblCommonGender
     */
    public function getCommonGenderById($Id)
    {

        return $this->getCachedEntityById(__METHOD__, $this->getConnection()->getEntityManager(), 'TblCommonGender', $Id);
    }

    /**
     * @return bool|TblCommonGender[]
     */
    public function getCommonGenderAll()
    {

        return $this->getCachedEntityList(__METHOD__, $this->getConnection()->getEntityManager(), 'TblCommonGender');
    }

    /**
     * @param int $Id
     *
     * @return bool|TblCommonBirthDates
     */
    public function getCommonBirthDatesById($Id)
    {

        return $this->getCachedEntityById(__METHOD__, $this->getConnection()->getEntityManager(), 'TblCommonBirthDates',
            $Id);
    }

    /**
     * @param int $Id
     *
     * @return bool|TblCommonInformation
     */
    public function getCommonInformationById($Id)
    {

        return $this->getCachedEntityById(__METHOD__, $this->getConnection()->getEntityManager(),
            'TblCommonInformation',
            $Id);
    }

    /**
     * @return bool|TblCommonInformation[]
     */
    public function getCommonInformationAll()
    {

        return $this->getCachedEntityList(__METHOD__, $this->getConnection()->getEntityManager(),
            'TblCommonInformation');
    }

    /**
     * @return bool|TblCommonBirthDates[]
     */
    public function getCommonBirthDatesAll()
    {

        return $this->getCachedEntityList(__METHOD__, $this->getConnection()->getEntityManager(),
            'TblCommonBirthDates');
    }

    /**
     * @param TblCommonBirthDates $tblCommonBirthDates
     * @param string              $Birthday
     * @param string              $Birthplace
     * @param int                 $Gender
     *
     * @return bool
     */
    public function updateCommonBirthDates(
        TblCommonBirthDates $tblCommonBirthDates,
        $Birthday,
        $Birthplace,
        $Gender
    ) {

        $Manager = $this->getConnection()->getEntityManager();
        /** @var null|TblCommonBirthDates $Entity */
        $Entity = $Manager->getEntityById('TblCommonBirthDates', $tblCommonBirthDates->getId());
        if (null !== $Entity) {
            $Protocol = clone $Entity;
            $Entity->setBirthday(( $Birthday ? new \DateTime($Birthday) : null ));
            $Entity->setBirthplace($Birthplace);
            $Entity->setGender($Gender);
            $Manager->saveEntity($Entity);
            Protocol::useService()->createUpdateEntry($this->getConnection()->getDatabase(), $Protocol, $Entity);
            return true;
        }
        return false;
    }

    /**
     * @param TblCommonInformation $tblCommonInformation
     * @param string               $Nationality
     * @param string               $Denomination
     * @param int                  $IsAssistance
     * @param string               $AssistanceActivity
     *
     * @return bool
     */
    public function updateCommonInformation(
        TblCommonInformation $tblCommonInformation,
        $Nationality,
        $Denomination,
        $IsAssistance,
        $AssistanceActivity
    ) {

        $Manager = $this->getConnection()->getEntityManager();
        /** @var null|TblCommonInformation $Entity */
        $Entity = $Manager->getEntityById('TblCommonInformation', $tblCommonInformation->getId());
        if (null !== $Entity) {
            $Protocol = clone $Entity;
            $Entity->setNationality($Nationality);
            $Entity->setDenomination($Denomination);
            $Entity->setAssistance($IsAssistance);
            $Entity->setAssistanceActivity($AssistanceActivity);
            $Manager->saveEntity($Entity);
            Protocol::useService()->createUpdateEntry($this->getConnection()->getDatabase(), $Protocol, $Entity);
            return true;
        }
        return false;
    }

    /**
     * @param TblCommon $tblCommon
     * @param string    $Remark
     *
     * @return bool
     */
    public function updateCommon(
        TblCommon $tblCommon,
        $Remark
    ) {

        $Manager = $this->getConnection()->getEntityManager();
        /** @var null|TblCommon $Entity */
        $Entity = $Manager->getEntityById('TblCommon', $tblCommon->getId());
        if (null !== $Entity) {
            $Protocol = clone $Entity;
            $Entity->setRemark($Remark);
            $Manager->saveEntity($Entity);
            Protocol::useService()->createUpdateEntry($this->getConnection()->getDatabase(), $Protocol, $Entity);
            return true;
        }

        return false;
    }

    /**
     * @param TblCommon $tblCommon
     * @param bool $IsSoftRemove
     *
     * @return bool
     */
    public function destroyCommon(TblCommon $tblCommon, $IsSoftRemove = false)
    {

        $Manager = $this->getConnection()->getEntityManager();
        /** @var TblCommon $Entity */
        $Entity = $Manager->getEntityById('TblCommon', $tblCommon->getId());
        if (null !== $Entity) {
            Protocol::useService()->createDeleteEntry($this->getConnection()->getDatabase(), $Entity);
            if ($IsSoftRemove) {
                $Manager->removeEntity($Entity);
            } else {
                $Manager->killEntity($Entity);
            }
            return true;
        }
        return false;
    }

    /**
     * @param $Name
     *
     * @return false|TblCommonGender
     */
    public function getCommonGenderByName($Name)
    {

        return $this->getCachedEntityBy(__METHOD__, $this->getConnection()->getEntityManager(), 'TblCommonGender', array(
           TblCommonGender::ATTR_NAME => $Name
        ));
    }

    /**
     * @param TblCommon $tblCommon
     *
     * @return bool
     */
    public function restoreCommon(TblCommon $tblCommon)
    {

        $Manager = $this->getConnection()->getEntityManager();
        /** @var TblPerson $Entity */
        $Entity = $Manager->getEntityById('TblCommon', $tblCommon->getId());
        $Protocol = clone $Entity;
        if (null !== $Entity) {
            $Entity->setEntityRemove(null);
            $Manager->saveEntity($Entity);
            Protocol::useService()->createUpdateEntry($this->getConnection()->getDatabase(), $Protocol, $Entity);
            return true;
        }
        return false;
    }
}