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
