/**
* @param TblDebtor $tblDebtor
* @param TblCommodity $tblCommodity
*
* @return bool|TblReference
*/
public function entityReferenceByDebtorAndCommodity(TblDebtor $tblDebtor, TblCommodity $tblCommodity)
{
$Entity = $this->Connection->getEntityManager()->getEntity('TblReference')->findOneBy(array(TblReference::ATTR_TBL_DEBTOR => $tblDebtor->getId(), TblReference::ATTR_SERVICE_BILLING_COMMODITY => $tblCommodity->getId(), TblReference::ATTR_IS_VOID => false));
return null === $Entity ? false : $Entity;
}
/**
* @param TblBasket $tblBasket
* @param TblPerson $tblPerson
* @param TblDebtor $tblDebtor
*
* @return TblTempInvoice|null
*/
public function actionCreateTempInvoice(TblBasket $tblBasket, TblPerson $tblPerson, TblDebtor $tblDebtor)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblTempInvoice')->findOneBy(array(TblTempInvoice::ATTR_SERVICE_BILLING_BASKET => $tblBasket->getId(), TblTempInvoice::ATTR_SERVICE_MANAGEMENT_PERSON => $tblPerson->getId(), TblTempInvoice::ATTR_SERVICE_BILLING_DEBTOR => $tblDebtor->getId()));
if (null === $Entity) {
$Entity = new TblTempInvoice();
$Entity->setServiceBillingBasket($tblBasket);
$Entity->setServiceManagementPerson($tblPerson);
$Entity->setServiceBillingDebtor($tblDebtor);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
}
return $Entity;
}
/**
* @param TblDebtor $serviceBilling_Banking
* @param TblInvoice $serviceBilling_Invoice
* @param $ExportDate
*
* @return bool
*/
public function actionCreateBalance(TblDebtor $serviceBilling_Banking, TblInvoice $serviceBilling_Invoice, $ExportDate)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblBalance')->findOneBy(array(TblBalance::ATTR_SERVICE_BILLING_BANKING => $serviceBilling_Banking->getId(), TblBalance::ATTR_SERVICE_BILLING_INVOICE => $serviceBilling_Invoice->getId()));
if (null === $Entity) {
$Entity = new TblBalance();
$Entity->setServiceBillingBanking($serviceBilling_Banking);
$Entity->setServiceBillingInvoice($serviceBilling_Invoice);
if ($ExportDate !== null) {
$Entity->setExportDate($ExportDate);
}
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
return true;
}
return false;
}
/**
* @param IFormInterface $Stage
* @param TblDebtor $Debtor
* @param $Reference
*
* @return IFormInterface|string
*/
public function executeAddReference(IFormInterface &$Stage = null, TblDebtor $Debtor, $Reference)
{
/**
* Skip to Frontend
*/
if (null === $Reference) {
return $Stage;
}
$Error = false;
if (isset($Reference['Reference']) && empty($Reference['Reference'])) {
$Stage->setError('Reference[Reference]', 'Bitte geben sie eine Mandatsreferenz an');
$Error = true;
}
if (isset($Reference['Reference']) && Banking::useService()->entityReferenceByReferenceActive($Reference['Reference'])) {
$Stage->setError('Reference[Reference]', 'Die Mandatsreferenz exisitiert bereits. Bitte geben Sie eine andere an');
$Error = true;
}
if (!$Error) {
(new Data($this->Binding))->actionAddReference($Reference['Reference'], $Debtor->getDebtorNumber(), $Reference['ReferenceDate'], Commodity::useService()->entityCommodityById($Reference['Commodity']));
return new Success('Die Referenz ist erfasst worden') . new Redirect('/Billing/Accounting/Banking/Debtor/Reference', 0, array('Id' => $Debtor->getId()));
}
return $Stage;
}
/**
* @param TblDebtor $serviceBilling_Banking
*/
public function setServiceBillingBanking(TblDebtor $serviceBilling_Banking = null)
{
$this->serviceBilling_Banking = null === $serviceBilling_Banking ? null : $serviceBilling_Banking->getId();
}
/**
* @param TblDebtor $tblDebtor
*/
public function setServiceBillingDebtor(TblDebtor $tblDebtor = null)
{
$this->serviceBilling_Debtor = null === $tblDebtor ? null : $tblDebtor->getId();
}
/**
* @param TblBasketCommodity $tblBasketCommodity
* @param TblDebtor $tblDebtor
*
* @return TblBasketCommodityDebtor|null
*/
public function actionCreateBasketCommodityDebtor(TblBasketCommodity $tblBasketCommodity, TblDebtor $tblDebtor)
{
$Manager = $this->Connection->getEntityManager();
$Entity = $Manager->getEntity('TblBasketCommodityDebtor')->findOneBy(array(TblBasketCommodityDebtor::ATTR_TBL_BASKET_COMMODITY => $tblBasketCommodity->getId(), TblBasketCommodityDebtor::ATTR_SERVICE_BILLING_DEBTOR => $tblDebtor->getId()));
if (null === $Entity) {
$Entity = new TblBasketCommodityDebtor();
$Entity->setTblBasketCommodity($tblBasketCommodity);
$Entity->setServiceBillingDebtor($tblDebtor);
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
}
return $Entity;
}
/**
* @param null|TblDebtor $tblDebtor
*/
public function setTblDebtor(TblDebtor $tblDebtor)
{
$this->tblDebtor = null === $tblDebtor ? null : $tblDebtor->getId();
}
/**
* @param null|TblDebtor $serviceTblDebtor
*/
public function setServiceTblDebtor(TblDebtor $serviceTblDebtor)
{
$this->tblDebtor = null === $serviceTblDebtor ? null : $serviceTblDebtor->getId();
}
