Changeset 508 for trunk/finance/manage.php

Timestamp:

Apr 1, 2013, 8:36:27 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Negenerovat faktury pokud fakturovaná částka je nula.
• Přidáno: Zobrazení akcí při prohlížení položek správy dat.
• Přidáno: V tabulce Subjektů se nyní zobrazují související platby.

File:

• trunk/finance/manage.php (modified) (2 diffs)

trunk/finance/manage.php

@@ -320 +320 @@
       'ON Subject.Id=Member.Subject LEFT JOIN FinanceBillingPeriod ON '.
       'FinanceBillingPeriod.Id=Member.BillingPeriodNext WHERE (Member.Blocked = 0)'.
-      'AND (Member.BillingPeriodNext > 1)';
+      'AND (Member.BillingPeriodNext > 1) AND (MemberPayment.MonthlyTotal != 0)';
     
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$SQL.') AS T');
@@ -404 +404 @@
           $MonthlyTotal -= $Member['MonthlyPlus'];
         }
-        $PayPerPeriod = $MonthlyTotal * $Period['MonthCount'];
-    
-        $TimePeriodText = date('j.n.Y', $Period['From']).' - '.date('j.n.Y', $Period['To']);
-        $Output .= $TimePeriodText.': '.$MonthlyTotal.' * '.$Period['MonthCount'].' = '.$PayPerPeriod.'<br />';
-        $this->InsertInvoice($Member['Subject'], time(), time() + 3600 * 24 * INVOICE_DUE_DAYS, 
-          $InvoiceItems, INVOICE_OUT_DOC_LINE, $Period['From'], $Period['To']);
-    
-        $Output .= $this->SendPaymentEmail($Member['Id']);
+        $PayPerPeriod = $MonthlyTotal * $Period['MonthCount'];  
+        if($PayPerPeriod != 0)
+        {
+          $TimePeriodText = date('j.n.Y', $Period['From']).' - '.date('j.n.Y', $Period['To']);
+          $Output .= $TimePeriodText.': '.$MonthlyTotal.' * '.$Period['MonthCount'].' = '.$PayPerPeriod.'<br />';
+          $this->InsertInvoice($Member['Subject'], time(), time() + 3600 * 24 * INVOICE_DUE_DAYS, 
+            $InvoiceItems, INVOICE_OUT_DOC_LINE, $Period['From'], $Period['To']);
+    
+          $Output .= $this->SendPaymentEmail($Member['Id']);
+        } else $Output .= '<br />';
         $this->Database->update('Member', 'Id='.$Member['Id'], 
           array('BillingPeriodLastDate' => TimeToMysqlDateTime($Period['To'])));