Example #1
0
 public function getDonation()
 {
     try {
         if (!class_exists('Donator_Model_Donation') || !$this->__get('donation_id')) {
             return null;
         }
         return $this->getForeignRecordBreakNull('donation_id', Donator_Controller_Donation::getInstance());
     } catch (Exception $e) {
         return null;
     }
 }
Example #2
0
 public function getDonationAndMemberFeeSums($period, $definition, &$fixValues, &$resultValues)
 {
     $values = array('VOR' => array(), 'JETZT' => array(), 'NACH' => array());
     $fixValues = array('prev_period' => $period - 1, 'now_period' => $period, 'next_period' => $period + 1);
     $periods = array('VOR' => $period - 1, 'JETZT' => $period, 'NACH' => $period + 1);
     $result = array();
     // Mitgliederbeiträge nach Beitragsgruppen:
     $date = new Zend_Date();
     $date->setYear($period);
     $beginDate = $definition->getStartDate(new Zend_Date());
     $endDate = $definition->getEndDate(new Zend_Date());
     /*$beginDate = clone $date;
     		$endDate = clone $date;
     		
     		$beginDate->setMonth(1);
     		$beginDate->setDay(1);
     		
     		$endDate->setMonth(12);
     		$endDate->setDay(31);*/
     $baseOpFilter = array();
     $baseDonationFilter = array();
     $baseOpFilter[] = array('field' => 'payment_date', 'operator' => 'afterOrAt', 'value' => $beginDate->toString('yyyy-MM-dd'));
     $baseOpFilter[] = array('field' => 'payment_date', 'operator' => 'beforeOrAt', 'value' => $endDate->toString('yyyy-MM-dd'));
     $baseOpFilter[] = array('field' => 'state', 'operator' => 'not', 'value' => 'OPEN');
     $baseDonationFilter[] = array('field' => 'donation_date', 'operator' => 'afterOrAt', 'value' => $beginDate->toString('yyyy-MM-dd'));
     $baseDonationFilter[] = array('field' => 'donation_date', 'operator' => 'beforeOrAt', 'value' => $endDate->toString('yyyy-MM-dd'));
     $baseOpFilter = new Billing_Model_OpenItemFilter($baseOpFilter, 'AND');
     $baseDonationFilter = new Donator_Model_DonationFilter($baseDonationFilter, 'AND');
     $feeGroups = Membership_Controller_FeeGroup::getInstance()->getAllFeeGroups('key');
     $feeGroupSum = 0;
     $resultValues = array();
     $nowSum = $previousSum = $nextSum = $totalDonationSum = 0;
     foreach ($feeGroups as $feeGroup) {
         $opFilter = null;
         $opFilter = clone $baseOpFilter;
         $opFilter->addFilter($opFilter->createFilter('fee_group_id', 'equals', $feeGroup->__get('id'), 'rc'));
         $innerArray = array();
         $innerArray['bg_name'] = $feeGroup->__get('name');
         foreach ($values as $key => $value) {
             $innerOpFilter = null;
             $innerOpFilter = clone $opFilter;
             switch ($key) {
                 case 'VOR':
                     $innerOpFilter->addFilter($innerOpFilter->createFilter('period', 'less', $period, 'rc'));
                     $sums = Billing_Controller_OpenItem::getInstance()->getSummation($innerOpFilter);
                     $payedSum = $sums['payed_sum'];
                     $innerArray['previous'] = number_format($payedSum, 2, ',', '.');
                     $previousSum += $payedSum;
                     break;
                 case 'JETZT':
                     $innerOpFilter->addFilter($innerOpFilter->createFilter('period', 'equals', $period, 'rc'));
                     $sums = Billing_Controller_OpenItem::getInstance()->getSummation($innerOpFilter);
                     $payedSum = $sums['payed_sum'];
                     $innerArray['now'] = number_format($payedSum, 2, ',', '.');
                     $nowSum += $payedSum;
                     break;
                 case 'NACH':
                     $innerOpFilter->addFilter($innerOpFilter->createFilter('period', 'greater', $period, 'rc'));
                     $sums = Billing_Controller_OpenItem::getInstance()->getSummation($innerOpFilter);
                     $payedSum = $sums['payed_sum'];
                     $innerArray['next'] = number_format($payedSum, 2, ',', '.');
                     $nextSum += $payedSum;
                     break;
             }
         }
         $donationFilter = clone $baseDonationFilter;
         $donationFilter->addFilter($donationFilter->createFilter('fee_group_id', 'equals', $feeGroup->__get('id')));
         $donationFilter->addFilter($donationFilter->createFilter('period', 'equals', $period));
         // get Donation summation
         $sums = Donator_Controller_Donation::getInstance()->searchCount($donationFilter);
         $donationSum = $sums['sum'];
         $innerArray['donation'] = number_format($donationSum, 2, ',', '.');
         $totalDonationSum += $donationSum;
         $resultValues[] = $innerArray;
     }
     // Spenden verarbeiten:
     $SFeeGroupSum = 0;
     //$result['S'] = array();
     /*foreach($feeGroups as $feeGroup){
     			$donationFilter = clone $baseDonationFilter;
     			$donationFilter->addFilter($donationFilter->createFilter('fee_group_id','equals',$feeGroup->__get('id')));
     				$donationFilter->addFilter($donationFilter->createFilter('period','equals',$period));
     			// get Donation summation
     			$sums = Donator_Controller_Donation::getInstance()->searchCount($donationFilter);
     			$donationSum = $sums['sum'];
     			$result['SPENDE'.$feeGroup->__get('key')] = number_format($payedSum,2,',','.');
     			$SFeeGroupSum += $donationSum;
     		}*/
     //-->
     // Summe auslesen für Nichtmitglieder (Filter: is_member=false)
     //$group = new Tinebase_Model_Filter_FilterGroup(array(),'OR');
     $donationFilter = clone $baseDonationFilter;
     $donationFilter->addFilter($donationFilter->createFilter('is_member', 'equals', 0));
     $donationFilter->addFilter($donationFilter->createFilter('period', 'equals', $period));
     /*$group->addFilterGroup($donationFilter);
     		
     		$donationFilter2 = clone $baseDonationFilter;
     		$donationFilter2->addFilter($donationFilter->createFilter('fee_group_id','equals',''));
     		$donationFilter2->addFilter($donationFilter->createFilter('period','equals',$period));
     		
     		$group->addFilterGroup($donationFilter);*/
     $sums = Donator_Controller_Donation::getInstance()->searchCount($donationFilter);
     $donationSum = $sums['sum'];
     $totalDonationSum += $donationSum;
     $result['SPENDE' . 'NOMEMBER'] = number_format($donationSum, 2, ',', '.');
     //<--
     $resultValues[] = array('bg_name' => 'Nichtmitglieder', 'previous' => 0, 'now' => 0, 'next' => 0, 'donation' => number_format($donationSum, 2, ',', '.'));
     $fixValues['sum_prev'] = number_format($previousSum, 2, ',', '.');
     $fixValues['sum_now'] = number_format($nowSum, 2, ',', '.');
     $fixValues['sum_next'] = number_format($nextSum, 2, ',', '.');
     $fixValues['sum_donation'] = number_format($totalDonationSum, 2, ',', '.');
     return $resultValues;
 }