/**
* the singleton pattern
*
* @return SoEventManager_Controller_SoEvent
*/
public static function getInstance()
{
if (self::$_instance === NULL) {
self::$_instance = new self();
}
return self::$_instance;
}
public function getSepaMandate()
{
// ensure loading sepa mandate from DB
$sepaMandateId = $this->getForeignId('sepa_mandate_id');
return Billing_Controller_SepaMandate::getInstance()->get($sepaMandateId);
//return $this->getForeignRecordBreakNull('sepa_mandate_id', Billing_Controller_SepaMandate::getInstance());
}
public function getSepaMandateByContextAndPurpose($context, $purpose, $bankAccountId, $objId = null)
{
$result = $this->getByContextAndPurpose($context, $purpose, $bankAccountId, $objId);
// @todo: check whether count(result) is possible -> recordset?
if (!$result || count($result) == 0) {
return null;
}
return $result->getForeignRecordBreakNull('sepa_mandate_id', Billing_Controller_SepaMandate::getInstance());
}
/**
* export timesheets to csv file
*
* @param Membership_Model_ContactFilter $_filter
* @return string filename
*/
public function generate($filters, $data)
{
if (!is_array($filters)) {
$filters = Zend_Json::decode($filters);
}
$pagination = new Tinebase_Model_Pagination(array('start' => 0, 'limit' => 0, 'sort' => 'signature_date', 'dir' => 'ASC'));
//if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' ' . print_r($_filter->toArray(), true));
$this->controller = Billing_Controller_SepaMandate::getInstance();
$filter = new Billing_Model_SepaMandateFilter($filters, 'AND');
$mandateIds = $this->controller->search($filter, $pagination, FALSE, TRUE, 'export');
return $this->doExport($mandateIds, $data);
}
public function markLastUsage(Zend_Date $lastUsageDate = null)
{
if (is_null($lastUsageDate)) {
$lastUsageDate = new Zend_Date();
}
$this->__set('last_usage_date', $lastUsageDate);
Billing_Controller_SepaMandate::getInstance()->update($this);
}
public function exportSepaMandateDATEV($filters, $data)
{
error_reporting(E_ALL);
ini_set('display_errors', 'on');
Billing_Controller_SepaMandate::getInstance()->exportSepaMandateDATEV($filters, $data);
}
public function removeAllSepaMandatesForContactId($contactId)
{
try {
$deleted = Billing_Controller_SepaMandate::getInstance()->removeAllSepaMandatesForContactId($contactId);
return array('state' => 'success', 'deleted' => $deleted);
} catch (Exception $e) {
return array('state' => 'failure', 'errorInfo' => $e->__toString());
}
}
public function prepareDebitDtaExport(Billing_Model_BatchJob $job)
{
error_reporting(E_ALL);
set_time_limit(0);
try {
$dueDate = new Zend_Date();
$db = Tinebase_Core::getDb();
$tm = Tinebase_TransactionManager::getInstance();
$tId = $tm->startTransaction($db);
$job = Billing_Api_BatchJobManager::getInstance()->loadBatchJob($job->getId());
// Billing_Api_BatchJobManager::getInstance()->startBatchJob();
$data = $job->getData();
$filters = $data['filters'];
$aContexts = $data['contexts'];
if (!is_array($aContexts)) {
$aContexts = Zend_Json::decode($aContexts);
}
$pagination = new Tinebase_Model_Pagination();
//require_once 'Payment/DTA.php';
if (!is_array($filters)) {
$filters = Zend_Json::decode($filters);
}
// get all open items (for debit)
// grouped by debitors
/*$filters[] = array(
'field' => 'banking_exp_date',
'operator' => 'isnull',
'value' => ''
);*/
$filters[] = array('field' => 'state', 'operator' => 'not', 'value' => 'DONE');
$filters[] = array('field' => 'type', 'operator' => 'equals', 'value' => 'DEBIT');
$filters[] = array('field' => 'is_cancelled', 'operator' => 'equals', 'value' => 0);
$filters[] = array('field' => 'is_cancellation', 'operator' => 'equals', 'value' => 0);
//$contextFilters = array('ERP');
$contextFilters = array();
foreach ($aContexts as $context => $flag) {
if ($flag) {
$contextFilters[] = $context;
}
}
$filters[] = array('field' => 'erp_context_id', 'operator' => 'in', 'value' => $contextFilters);
$rawFilters = $filters;
$paymentTypeCount = count($paymentTypeKeys);
$filter = new Billing_Model_OpenItemFilter($filters, 'AND');
// due date: means date of execution of debit -> necessary for determination of sepa mandates
// Telefonat: Rudat, hhartl 14.05.2014
// "wenn im Filter angegeben, dann verwenden, ansonsten Tagesdatum"
if ($filter->isFilterSet("due_date")) {
$dueDate = new Zend_Date($filter->getFilter("due_date")->getValue());
}
// count membership matching filters
$openItemIds = Billing_Controller_OpenItem::getInstance()->search($filter, new Tinebase_Model_Pagination(array('sort' => 'id', 'dir' => 'ASC')), false, true);
//ob_start();
$debitorOpenItemIds = array();
$limit = 0;
//echo "global count: ".count($openItemIds);
foreach ($openItemIds as $openItemId) {
/*if($limit++ > 250){
break;
}*/
$openItem = Billing_Controller_OpenItem::getInstance()->get($openItemId);
$debitorId = $openItem->getForeignId('debitor_id');
if (!array_key_exists($debitorId, $debitorOpenItemIds)) {
$debitorOpenItemIds[$debitorId] = array();
}
$debitorOpenItemIds[$debitorId][] = $openItemId;
}
$addFilters = array();
$addFilters[] = array('field' => 'membership_type', 'operator' => 'notin', 'value' => array('MEMBER_EX', 'MEMBER_GESCHENK', 'SCHENKER'));
foreach ($debitorOpenItemIds as $debitorId => $debitorOpenItems) {
$debitor = null;
$contact = null;
$contactId = null;
$isError = false;
try {
$debitor = Billing_Controller_Debitor::getInstance()->get($debitorId);
$contactId = $debitor->getForeignId('contact_id');
$contact = $debitor->getForeignRecord('contact_id', Addressbook_Controller_Contact::getInstance());
$valid = 'UNKNOWN';
$activeMembershipIds = Membership_Controller_SoMember::getInstance()->getActiveMembershipsByContactId($contact->getId(), $dueDate, $addFilters);
$mandate = null;
$count = count($activeMembershipIds);
if (count($activeMembershipIds) == 1) {
$membership = Membership_Controller_SoMember::getInstance()->getSoMember($activeMembershipIds[0]);
if ($membership->allowsSepaDirectDebit($dueDate)) {
//echo "has::";
$hasMandate = true;
$mandate = $membership->getForeignRecordBreakNull('sepa_mandate_id', Billing_Controller_SepaMandate::getInstance());
$valid = 'YES';
}
$bankAccount = $membership->getForeignRecordBreakNull('bank_account_id', Billing_Controller_BankAccount::getInstance());
} elseif (count($activeMembershipIds) == 0) {
$regularDonations = Donator_Controller_RegularDonation::getInstance()->getByContactId($contact->getId());
foreach ($regularDonations as $regDon) {
if ($regDon->allowsSepaDirectDebit()) {
$mandate = $regDon->getForeignRecordBreakNull('sepa_mandate_id', Billing_Controller_SepaMandate::getInstance());
$valid = 'YES';
//echo "has::";
break;
}
}
}
$bankAccountName = '';
$bankName = '';
//echo "adr $contactId - count: $count\r\n";
if (is_null($mandate)) {
$bankAccount = null;
$valid = 'NO';
$sepaMandateId = null;
$bankAccountId = null;
$receipt = $openItem->getForeignRecordBreakNull('receipt_id', Billing_Controller_Receipt::getInstance());
$text = 'Kein gültiges Sepa-Mandat';
if ($receipt->getForeignId('payment_method_id') != 'DEBIT') {
continue;
}
} else {
$text = 'Sepa-Lastschrift';
$bankAccountId = $mandate->getForeignIdBreakNull('bank_account_id');
$sepaMandateId = $mandate->getId();
}
$errorInfo = '';
// REMARK[HH, 2013-08-23]: now set saldation contexts chosen by checkbox in start dialog:
// fixes quickhack hardcoded array('MEMBERSHIP','DONATOR')
//
$aSaldation = Billing_Controller_DebitorAccount::getInstance()->getSummationByDebitorId($debitorId, $contextFilters);
$saldation = $aSaldation['sum'];
$actionState = 'OPEN';
} catch (Exception $e) {
$isError = true;
$valid = "NO";
$text = "Fehler - Debitor {$debitorId} kann nicht verarbeitet werden.";
$em = "";
if (is_null($debitor)) {
$em .= "Debitor konnte nicht geladen werden " . $debitorId . " ";
}
if (is_null($contact) || is_null($contactId)) {
$em .= "Kontakt konnte nicht geladen werden. Debitor.Nr.:" . $debitorId;
}
$errorInfo = "Fehler: " . $em . " <br/>\r\n Original-Meldung: " . $e->__toString();
$bankAccountId = null;
$mandate = null;
$actionState = 'ERROR';
$bankAccountName = "";
$bankName = "";
$sepaMandateId = null;
$contactId = $debitorId;
}
$batchJobDta = new Billing_Model_BatchJobDta(null, true);
$batchJobDta->setFromArray(array('job_id' => $job->getId(), 'contact_id' => $contactId, 'debitor_id' => $debitorId, 'bank_account_id' => $bankAccountId, 'bank_account_usage_id' => 1, 'sepa_mandate_id' => $sepaMandateId, 'bank_valid' => $valid, 'bank_account_number' => 0, 'bank_code' => 0, 'bank_account_name' => $bankAccountName, 'bank_name' => $bankName, 'total_sum' => 0, 'total_saldation' => $saldation, 'diff_saldation' => 0, 'count_pos' => 0, 'skip' => !is_null($mandate), 'action_text' => $text, 'action_data' => null, 'action_type' => 'DRYRUN', 'action_state' => $actionState, 'error_info' => $errorInfo, 'created_datetime' => Zend_Date::now(), 'valid_datetime' => Zend_Date::now(), 'to_process_datetime' => Zend_Date::now(), 'process_datetime' => Zend_Date::now(), 'usage' => ''));
$batchJobDta = $this->create($batchJobDta);
if (!$isError) {
$batchJobDtaId = $batchJobDta->getId();
$posCount = count($debitorOpenItems);
$totalSum = 0;
$usages = array();
foreach ($debitorOpenItems as $openItemId) {
$openItem = Billing_Controller_OpenItem::getInstance()->get($openItemId);
$sum = (double) $openItem->__get('open_sum');
$batchJobDtaItem = new Billing_Model_BatchJobDtaItem(null, true);
$batchJobDtaItem->setFromArray(array('batch_dta_id' => $batchJobDtaId, 'open_item_id' => $openItem->getId(), 'erp_context_id' => $openItem->__get('erp_context_id'), 'total_sum' => $sum, 'skip' => false, 'usage' => $openItem->__get('usage')));
$usages[] = $openItem->__get('usage');
$totalSum += $sum;
Billing_Controller_BatchJobDtaItem::getInstance()->create($batchJobDtaItem);
}
$usage = implode(' ', $usages);
$batchJobDta->__set('usage', $usage);
$batchJobDta->__set('total_sum', $totalSum);
$batchJobDta->__set('diff_saldation', $totalSum + $saldation);
if ($totalSum + $saldation != 0) {
$batchJobDta->__set('action_text', $batchJobDta->__get('action_text') . ' Differenz überprüfen');
}
$batchJobDta->__set('count_pos', $posCount);
$this->update($batchJobDta);
}
}
//$log = ob_get_clean();
//Billing_Api_BatchJobManager::getInstance()->finishError($log);
Billing_Api_BatchJobManager::getInstance()->finish();
$tm->commitTransaction($tId);
return array('state' => 'success', 'result' => null);
} catch (Exception $e) {
echo $e->__toString();
$tm->rollback($tId);
Billing_Api_BatchJobManager::getInstance()->finishError($e->__toString());
return array('state' => 'failure', 'result' => null, 'errorInfo' => array('message' => $e->getMessage(), 'trace' => $e->getTrace()));
}
}
private static function doSepa($contact)
{
try {
$memberships = Membership_Controller_SoMember::getInstance()->getByContactId($contact->getId());
foreach ($memberships as $membership) {
$memKind = $membership->__get('membership_type');
if ($memKind == 'MEMBER_EX' || $memKind == 'INTERESTED') {
continue;
}
if ($memKind == 'MEMBER_GESCHENK') {
$parentMembership = $membership->getForeignRecord('parent_member_id', Membership_Controller_SoMember::getInstance());
$bankAccount = Billing_Api_BankAccount::getFromSoMember($parentMembership);
} else {
$bankAccount = Billing_Api_BankAccount::getFromSoMember($membership);
}
$objBankAccount = $bankAccount->convertSepa();
if (!is_null($objBankAccount)) {
$usage = $objBankAccount->addUsageMembership($membership);
$membership->__set('bank_account_id', $objBankAccount->getId());
$membership->__set('bank_account_usage_id', $usage->getId());
Membership_Controller_SoMember::getInstance()->update($membership);
$paymentMethod = $bankAccount->getPaymentMethod();
if ($paymentMethod == 'DEBIT' || $paymentMethod == 'DEBIT_GM') {
Billing_Controller_SepaMandate::getInstance()->generateSepaMandateForBankAccountUsage($usage);
}
}
}
$fundMasters = Donator_Controller_FundMaster::getInstance()->getAllByContactIdBreakNull($contact->getId());
if (!is_null($fundMasters)) {
foreach ($fundMasters as $fundMaster) {
if ($fundMaster instanceof Donator_Model_FundMaster) {
//regular donations
$regularDonations = Donator_Controller_RegularDonation::getInstance()->getByFundMasterId($fundMaster->getId());
foreach ($regularDonations as $regDon) {
if (!$regDon->__get('terminated') && !$regDon->__get('on_hold')) {
$bankAccount = Billing_Api_BankAccount::getFromRegularDonation($regDon);
$objBankAccount = $bankAccount->convertSepa();
if (!is_null($objBankAccount)) {
$usage = $objBankAccount->addUsageRegularDonation($regDon);
$regDon->__set('bank_account_id', $objBankAccount->getId());
$regDon->__set('bank_account_usage_id', $usage->getId());
Donator_Controller_RegularDonation::getInstance()->update($regDon);
$paymentMethod = $bankAccount->getPaymentMethod();
if ($paymentMethod == 'DEBIT' || $paymentMethod == 'DEBIT_GM') {
Billing_Controller_SepaMandate::getInstance()->generateSepaMandateForBankAccountUsage($usage);
}
}
}
}
}
}
}
//$bankAccount = Billing_Api_BankAccount::getFromFundMaster($fundMaster);
//$bankAccountCollection->attach($bankAccount);
$bankAccount = Billing_Api_BankAccount::getFromContact($contact);
$objBankAccount = $bankAccount->convertSepa();
if (!is_null($objBankAccount)) {
$objBankAccount->addUsageAll();
}
} catch (Exception $e) {
\org\sopen\dev\DebugLogger::log('error ' . self::$errorCounter++ . ' contactId: ' . $contact->getId() . $e->getMessage());
return;
}
}
