public function directDebit($paymentTypeKeys, $filters) { $db = Tinebase_Core::getDb(); $tm = Tinebase_TransactionManager::getInstance(); try { require_once 'Payment/DTA.php'; if (!is_array($filters)) { $filters = Zend_Json::decode($filters); } if (!is_array($paymentTypeKeys)) { $paymentTypeKeys = Zend_Json::decode($paymentTypeKeys); } $filters[] = array('field' => 'banking_exp_date', 'operator' => 'isnull', 'value' => ''); $rawFilters = $filters; $paymentTypeCount = count($paymentTypeKeys); $filters[] = array('field' => 'payment_method_id', 'operator' => 'equals', 'value' => $paymentTypeKeys[1]); $filter1 = new Billing_Model_OpenItemFilter($filters, 'AND'); $filter = new Tinebase_Model_Filter_FilterGroup(array(), 'OR'); $filter->addFilterGroup($filter1); if ($paymentTypeCount > 1) { unset($paymentTypeKeys[1]); foreach ($paymentTypeKeys as $paymentTypeKey) { $newFilters = $rawFilters; $newFilters[] = array('field' => 'payment_method_id', 'operator' => 'equals', 'value' => $paymentTypeKey); $pFilterGroup = new Billing_Model_OpenItemFilter($newFilters, 'AND'); $filter->addFilterGroup($pFilterGroup); } } // start transaction $tId = $tm->startTransaction($db); // count membership matching filters $openItemIds = $this->search($filter, new Tinebase_Model_Pagination(array('sort' => 'due_date', 'dir' => 'ASC')), false, true); $tempFilePath = CSopen::instance()->getCustomerPath() . '/customize/data/documents/temp/'; $mandators = \Tinebase_Config::getInstance()->getConfig('mandators', NULL, TRUE)->value; $mandator = $mandators[1]['bankdata']; $hash = md5(serialize($mandator) . microtime()); $dtaFile = new DTA(DTA_DEBIT); $dtaFile->setAccountFileSender(array("name" => $mandator['account_holder'], "bank_code" => $mandator['bank_code'], "account_number" => $mandator['account_number'])); // create DTA file foreach ($openItemIds as $openItemId) { $openItem = $this->get($openItemId); // value $val = (double) $openItem->__get('open_sum'); $usage = $openItem->__get('usage'); $u = explode(',', $usage); $u1 = $u2 = ''; if (count($u) > 0) { $u1 = $u[0]; $u2 = $u[1]; } else { $u1 = $usage; } if ($val > 0) { $debitor = $openItem->getForeignRecordBreakNull('debitor_id', Billing_Controller_Debitor::getInstance()); if (!$debitor) { continue; } $contact = $debitor->getForeignRecordBreakNull('contact_id', Addressbook_Controller_Contact::getInstance()); if (!$contact) { continue; } $receipt = $openItem->getForeignRecordBreakNull('receipt_id', Billing_Controller_Receipt::getInstance()); $dtaFile->addExchange(array("name" => $contact->__get('bank_account_name'), "bank_code" => $contact->__get('bank_code'), "account_number" => $contact->__get('bank_account_number')), (string) $val, array($u1, $u2)); } $openItem->__set('banking_exp_date', new Zend_Date()); $this->update($openItem); } $dtaFile->saveFile($tempFilePath . 'DTAUS0' . $hash); $meta = $dtaFile->getMetaData(); $date = strftime("%d.%m.%y", $meta["date"]); $execDate = strftime("%d.%m.%y", $meta["exec_date"]); $count = $meta["count"]; $sumEUR = $meta["sum_amounts"]; $sumKto = $meta["sum_accounts"]; $sumBankCodes = $meta["sum_bankcodes"]; $sender = $mandator['account_holder']; $senderBank = $mandator['bank']; $senderBankCode = $mandator['bank_code']; $senderAccount = $mandator['account_number']; $handoutContent = "Datenträger-Begleitzettel\n\tErstellungsdatum: {$date} \n\tAusführungsdatum: {$execDate}\n\tAnzahl der Lastschriften: {$count}\n\tSumme der Beträge in EUR: {$sumEUR}\n\tKontrollsumme Kontonummern: {$sumKto}\n\tKontrollsumme Bankleitzahlen: {$sumBankCodes}\n\tAuftraggeber: {$sender}\n\tBeauftragtes Bankinstitut: {$senderBank}\n\tBankleitzahl: {$senderBankCode}\n\tKontonummer: {$senderAccount}"; $zip = new ZipArchive(); $filename = "{$tempFilePath}/DTAUS0-{$ogNr}.zip"; if ($zip->open($filename, ZIPARCHIVE::CREATE) !== TRUE) { exit("cannot open <{$filename}>\n"); } $zip->addFromString("begleitzettel.txt", $handoutContent); $zip->addFile($tempFilePath . 'DTAUS0' . $hash, 'DTAUS0'); $zip->close(); header("Content-type: application/zip;\n"); header("Content-Transfer-Encoding: binary"); $len = filesize($filename); header("Content-Length: {$len};\n"); $outname = "DTAUS0-{$ogNr}.zip"; header("Content-Disposition: attachment; filename=\"{$outname}\";\n\n"); readfile($filename); unlink($filename); $tm->commitTransaction($tId); } catch (Exception $e) { $tm->rollback($tId); } }
* @license http://www.debian.org/misc/bsd.license BSD License (3 Clause) * @version SVN: $Id: example_begleitzettel.php 316502 2011-09-11 19:51:04Z mschuett $ * @link http://pear.php.net/package/Payment_DTA */ require_once 'Payment_DTA/DTA.php'; $dtaus = new DTA(DTA_CREDIT); $DTA_test_account = array('name' => "Michael Mustermann", 'bank_code' => "16050000", 'account_number' => "3503007767"); $dtaus->setAccountFileSender($DTA_test_account); $dtaus->addExchange(array('name' => "Emil Empfänger", 'bank_code' => "16050000", 'account_number' => "3503007767"), (double) 123.45, "Ein Verwendungszweck"); /* * some more transactions ... * * $dtaus->saveFile($filename) * */ $meta = $dtaus->getMetaData(); ?> <!doctype html> <head> <title>Example DTA Begleitzettel</title> </head> <body> <h1>Datenträger-Begleitzettel</h1> <table> <tr> <td>Erstellungsdatum:</td> <td><?php print strftime("%d.%m.%y", $meta["date"]); ?> </td>
print "<ol>"; foreach ($errors as $e) { if (get_class($e) == "Payment_DTA_FatalParseException") { print "<li class='status error'>Schwerer Fehler: " . $e->getMessage() . "</li></ol></body></html>"; die; } elseif (get_class($e) == "Payment_DTA_ParseException") { print "<li class='status error'>Fehler: " . $e->getMessage() . "<br/>Ursache: " . $e->getCause()->getMessage() . "</li>"; } elseif (get_class($e) == "Payment_DTA_ChecksumException") { print "<li class='status error'>Datei enthält falsche Prüfsumme: " . $e->getMessage() . "</li>"; } else { print "<li class='status error'>Unerwarteter Fehler: " . $e->getMessage() . "</li>"; } } print "</ol>"; } $meta = $dta->getMetaData(); ?> <h2>Begleitdaten:</h2> <table> <tr> <td class="label">Datei-Art:</td> <td class="value"><?php print $meta["type"] == "DEBIT" ? "Lastschrift" : "Gutschrift/Überweisung"; ?> </td> </tr> <tr> <td class="label">Erstellungsdatum:</td> <td class="value"><?php