/**
* @return bool|TblPerson
*/
public function getServiceManagementPerson()
{
if (null === $this->serviceManagement_Person) {
return false;
} else {
return Management::servicePerson()->entityPersonById($this->serviceManagement_Person);
}
}
/**
* @param TblBasket $tblBasket
* @param $Date
*
* @return bool
*/
public function actionCreateInvoiceListFromBasket(TblBasket $tblBasket, $Date)
{
$Manager = $this->Connection->getEntityManager();
$tblTempInvoiceList = $this->entityTempInvoiceAllByBasket($tblBasket);
/**@var TblTempInvoice $tblTempInvoice */
foreach ($tblTempInvoiceList as $tblTempInvoice) {
$tblDebtor = $tblTempInvoice->getServiceBillingDebtor();
$tblPersonDebtor = Management::servicePerson()->entityPersonById($tblDebtor->getServiceManagementPerson());
$tblPerson = $tblTempInvoice->getServiceManagementPerson();
$Entity = new TblInvoice();
$Entity->setIsPaid(false);
$Entity->setIsVoid(false);
$Entity->setNumber("40000000");
$Entity->setBasketName($tblBasket->getName());
$Entity->setServiceBillingBankingPaymentType($tblDebtor->getPaymentType());
$leadTimeByDebtor = Banking::useService()->entityLeadTimeByDebtor($tblDebtor);
$invoiceDate = (new \DateTime($Date))->sub(new \DateInterval('P' . $leadTimeByDebtor . 'D'));
$now = new \DateTime();
if ($invoiceDate->format('y.m.d') >= $now->format('y.m.d')) {
$Entity->setInvoiceDate($invoiceDate);
$Entity->setPaymentDate(new \DateTime($Date));
$Entity->setIsPaymentDateModified(false);
} else {
$Entity->setInvoiceDate(new \DateTime('now'));
$Entity->setPaymentDate($now->add(new \DateInterval('P' . $leadTimeByDebtor . 'D')));
$Entity->setIsPaymentDateModified(true);
}
$Entity->setDiscount(0);
$Entity->setDebtorFirstName($tblPersonDebtor->getFirstName());
$Entity->setDebtorLastName($tblPersonDebtor->getLastName());
$Entity->setDebtorSalutation($tblPersonDebtor->getTblPersonSalutation()->getName());
$Entity->setDebtorNumber($tblDebtor->getDebtorNumber());
$Entity->setServiceManagementPerson($tblPerson);
if ($address = Management::servicePerson()->entityAddressAllByPerson($tblPersonDebtor)) {
// TODO address type invoice
$Entity->setServiceManagementAddress($address[0]);
}
$Manager->saveEntity($Entity);
$Entity->setNumber((int) $Entity->getNumber() + $Entity->getId());
$Manager->saveEntity($Entity);
Protocol::useService()->createInsertEntry($this->Connection->getDatabase(), $Entity);
$tblTempInvoiceCommodityList = $this->entityTempInvoiceCommodityAllByTempInvoice($tblTempInvoice);
foreach ($tblTempInvoiceCommodityList as $tblTempInvoiceCommodity) {
$tblCommodity = $tblTempInvoiceCommodity->getServiceBillingCommodity();
$tblBasketItemAllByBasketAndCommodity = Basket::useService()->entityBasketItemAllByBasketAndCommodity($tblBasket, $tblCommodity);
/**@var TblBasketItem $tblBasketItem */
foreach ($tblBasketItemAllByBasketAndCommodity as $tblBasketItem) {
$tblItem = $tblBasketItem->getServiceBillingCommodityItem()->getTblItem();
if (!$tblItem->getServiceManagementCourse() && !$tblItem->getServiceManagementStudentChildRank()) {
$this->actionCreateInvoiceItem($tblCommodity, $tblItem, $tblBasket, $tblBasketItem, $Entity);
} else {
if ($tblItem->getServiceManagementCourse() && !$tblItem->getServiceManagementStudentChildRank()) {
if (($tblStudent = Management::serviceStudent()->entityStudentByPerson($tblPerson)) && $tblItem->getServiceManagementCourse()->getId() == $tblStudent->getServiceManagementCourse()->getId()) {
$this->actionCreateInvoiceItem($tblCommodity, $tblItem, $tblBasket, $tblBasketItem, $Entity);
}
} else {
if (!$tblItem->getServiceManagementCourse() && $tblItem->getServiceManagementStudentChildRank()) {
if (($tblStudent = Management::serviceStudent()->entityStudentByPerson($tblPerson)) && $tblItem->getServiceManagementStudentChildRank()->getId() == $tblStudent->getTblChildRank()->getId()) {
$this->actionCreateInvoiceItem($tblCommodity, $tblItem, $tblBasket, $tblBasketItem, $Entity);
}
} else {
if ($tblItem->getServiceManagementCourse() && $tblItem->getServiceManagementStudentChildRank()) {
if (($tblStudent = Management::serviceStudent()->entityStudentByPerson($tblPerson)) && $tblItem->getServiceManagementCourse()->getId() == $tblStudent->getServiceManagementCourse()->getId() && $tblItem->getServiceManagementStudentChildRank()->getId() == $tblStudent->getTblChildRank()->getId()) {
$this->actionCreateInvoiceItem($tblCommodity, $tblItem, $tblBasket, $tblBasketItem, $Entity);
}
}
}
}
}
}
}
}
return true;
}
/**
* @param $Id
*
* @return Stage
*/
public function frontendInvoiceAddressSelect($Id)
{
$Stage = new Stage();
$Stage->setTitle('Rechnung');
$Stage->setDescription('Rechnungsadresse Auswählen');
$Stage->addButton(new Primary('Zurück', '/Billing/Bookkeeping/Invoice/IsNotConfirmed/Edit', new ChevronLeft(), array('Id' => $Id)));
$tblInvoice = Invoice::useService()->entityInvoiceById($Id);
$tblAddressAll = Management::servicePerson()->entityAddressAllByPerson(Banking::useService()->entityDebtorByDebtorNumber($tblInvoice->getDebtorNumber())->getServiceManagementPerson());
$layoutGroup = self::layoutAddress($tblAddressAll, $tblInvoice->getServiceManagementAddress(), $tblInvoice);
$Stage->setContent(new Layout(array(new LayoutGroup(array(new LayoutRow(array(new LayoutColumn(array(new Panel('Rechnungsnummer', $tblInvoice->getNumber(), Panel::PANEL_TYPE_SUCCESS)), 3), new LayoutColumn(array(new Panel('Empfänger', $tblInvoice->getDebtorFullName(), Panel::PANEL_TYPE_SUCCESS)), 3))))))) . $layoutGroup);
return $Stage;
}
/**
* @param IFormInterface $Stage
* @param $Debtor
* @param $Id
*
* @return IFormInterface|string
*/
public function executeAddDebtor(IFormInterface &$Stage = null, $Debtor, $Id)
{
/**
* Skip to Frontend
*/
if (null === $Debtor) {
return $Stage;
}
$Error = false;
if (isset($Debtor['DebtorNumber']) && empty($Debtor['DebtorNumber'])) {
$Stage->setError('Debtor[DebtorNumber]', 'Bitte geben sie die Debitorennummer an');
$Error = true;
}
if (isset($Debtor['DebtorNumber']) && Banking::useService()->entityDebtorByDebtorNumber($Debtor['DebtorNumber'])) {
$Stage->setError('Debtor[DebtorNumber]', 'Die Debitorennummer exisitiert bereits. Bitte geben Sie eine andere Debitorennummer an');
$Error = true;
}
if (isset($Debtor['LeadTimeFirst']) && empty($Debtor['LeadTimeFirst'])) {
$Stage->setError('Debtor[LeadTimeFirst]', 'Bitte geben sie den Ersteinzug an.');
$Error = true;
}
if (isset($Debtor['LeadTimeFirst']) && !is_numeric($Debtor['LeadTimeFirst'])) {
$Stage->setError('Debtor[LeadTimeFirst]', 'Bitte geben sie eine Zahl an.');
$Error = true;
}
if (isset($Debtor['LeadTimeFollow']) && empty($Debtor['LeadTimeFollow'])) {
$Stage->setError('Debtor[LeadTimeFollow]', 'Bitte geben sie den Folgeeinzug an.');
$Error = true;
}
if (isset($Debtor['LeadTimeFollow']) && !is_numeric($Debtor['LeadTimeFollow'])) {
$Stage->setError('Debtor[LeadTimeFollow]', 'Bitte geben sie eine Zahl an.');
$Error = true;
}
if (isset($Debtor['Reference']) && Banking::useService()->entityReferenceByReference($Debtor['Reference'])) {
$Stage->setError('Debtor[Reference]', 'Die Mandatsreferenz exisitiert bereits. Bitte geben Sie eine andere an');
$Error = true;
}
if (!$Error) {
(new Data($this->Binding))->actionAddDebtor($Debtor['DebtorNumber'], $Debtor['LeadTimeFirst'], $Debtor['LeadTimeFollow'], $Debtor['BankName'], $Debtor['Owner'], $Debtor['CashSign'], $Debtor['IBAN'], $Debtor['BIC'], $Debtor['Description'], $Debtor['PaymentType'], Management::servicePerson()->entityPersonById($Id));
//todo
if (!empty($Debtor['Reference'])) {
(new Data($this->Binding))->actionAddReference($Debtor['Reference'], $Debtor['DebtorNumber'], $Debtor['ReferenceDate'], Commodity::useService()->entityCommodityById($Debtor['Commodity']));
}
return new Success('Der Debitor ist erfasst worden') . new Redirect('/Billing/Accounting/Banking', 2);
}
return $Stage;
}
/**
* @param TblPerson $tblPerson
*
* @return TblDebtor[]|bool
*/
public function checkDebtorExistsByPerson(TblPerson $tblPerson)
{
$tblDebtorAllList = array();
$debtorPersonAll = Banking::useService()->entityDebtorAllByPerson($tblPerson);
if (!empty($debtorPersonAll)) {
foreach ($debtorPersonAll as $debtor) {
array_push($tblDebtorAllList, $debtor);
}
}
$tblPersonRelationshipList = Management::servicePerson()->entityPersonRelationshipAllByPerson($tblPerson);
if (!empty($tblPersonRelationshipList)) {
foreach ($tblPersonRelationshipList as $tblPersonRelationship) {
if ($tblPerson->getId() === $tblPersonRelationship->getTblPersonA()) {
$tblDebtorList = Banking::useService()->entityDebtorAllByPerson($tblPersonRelationship->getTblPersonB());
} else {
$tblDebtorList = Banking::useService()->entityDebtorAllByPerson($tblPersonRelationship->getTblPersonA());
}
if (!empty($tblDebtorList)) {
foreach ($tblDebtorList as $tblDebtor) {
array_push($tblDebtorAllList, $tblDebtor);
}
}
}
}
if (empty($tblDebtorAllList)) {
return false;
} else {
return $tblDebtorAllList;
}
}
/**
* @return Stage
*/
public function frontendBankingPerson()
{
$Stage = new Stage();
$Stage->setTitle('Debitorensuche');
$Stage->addButton(new Primary('Zurück', '/Billing/Accounting/Banking', new ChevronLeft()));
// $tblPerson = Management::servicePerson()->entityPersonAll(); // todo
$tblPerson = false;
// todo
if (!empty($tblPerson)) {
foreach ($tblPerson as $Person) {
$PersonType = Management::servicePerson()->entityPersonById($Person->getId())->getTblPersonType();
$Person->Option = (new Primary('Debitor erstellen', '/Billing/Accounting/Banking/Person/Select', new Edit(), array('Id' => $Person->getId())))->__toString();
$Person->PersonType = $PersonType->getName();
}
}
$Stage->setContent(new Layout(array(new LayoutGroup(array(new LayoutRow(array(new LayoutColumn(array(new TableData($tblPerson, null, array('FirstName' => 'Vorname', 'MiddleName' => 'Zweitname', 'LastName' => 'Nachname', 'PersonType' => 'Persontyp', 'Option' => 'Debitor hinzufügen')))))))))));
return $Stage;
}
