Changeset 480 for trunk/finance/manage.php

Timestamp:

Feb 5, 2013, 10:25:54 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Zobrazení měsíčních plateb v tabulce pro kontrolu před jejich generováním.

Location:

trunk

Files:

• . (modified) (1 prop)
• finance/manage.php (modified) (3 diffs)

trunk

@@ -9 +9 @@
 .buildpath
 .settings
+nbproject

@@ -9 +9 @@
 .buildpath
 .settings
+nbproject

trunk/finance/manage.php

@@ -55 +55 @@
         $Output .= $this->System->Modules['Finance']->RecalculateMemberPayment();
         break;
-      case 'MonthlyPayment':
+      case 'ShowMonthlyPayment':
         $Output = $this->ShowMonthlyPayment();
+        break;
+      case 'ProcessMonthlyPayment':
+        $Output = $this->ProcessMonthlyPayment();
         break;
       case 'GenerateBills':
@@ -69 +72 @@
         $Output .= '<a href="?Operation=Bills">Správa dokladů</a><br />';
         $Output .= '<a href="?Operation=Recalculate">Přepočet financí</a><br />';
-        $Output .= '<a href="?Operation=MonthlyPayment">Měsíční vyúčtování</a><br />';
+        $Output .= '<a href="?Operation=ShowMonthlyPayment">Měsíční vyúčtování</a><br />';
         $Output .= '<a href="clenove.php">Seznam členů</a><br />';
         $Output .= '<a href="zivnost.php">Živnost</a><br />';
@@ -288 +291 @@
 
   function ShowMonthlyPayment()
+  {
+    if(!$this->System->Modules['User']->CheckPermission('Finance', 'Manage')) return('Nemáte oprávnění');
+    $SQL = 'SELECT Member.*, MemberPayment.MonthlyTotal AS Monthly, '.
+      'MemberPayment.Cash AS Cash, '.
+      '(SELECT GROUP_CONCAT(Service.Name) FROM ServiceCustomerRel LEFT JOIN Service '.
+      'ON Service.Id=ServiceCustomerRel.Service WHERE ServiceCustomerRel.Customer=Member.Id AND ServiceCustomerRel.Period=1) AS ServicesNextMonth, '.
+      'UNIX_TIMESTAMP(Member.BillingPeriodLastDate) AS LastDate, Subject.Name AS SubjectName, '.
+      'FinanceBillingPeriod.Name AS BillingPeriodName '.
+      'FROM MemberPayment JOIN Member ON Member.Id=MemberPayment.Member JOIN Subject '.
+      'ON Subject.Id=Member.Subject LEFT JOIN FinanceBillingPeriod ON '.
+      'FinanceBillingPeriod.Id=Member.BillingPeriodNext';
+    
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$SQL.') AS T');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);    
+
+    $Output = $PageList['Output'];
+    $Output .= '<table class="WideTable" style="font-size: small;">';
+   
+    $TableColumns = array(
+      array('Name' => 'SubjectName', 'Title' => 'Jméno'), 
+      array('Name' => 'Monthly', 'Title' => 'Platba'), 
+      array('Name' => 'Cash', 'Title' => 'Kredit'), 
+      array('Name' => 'LastDate', 'Title' => 'Poslední fakturace'), 
+      array('Name' => 'ServicesNextMonth', 'Title' => 'Služby'), 
+      array('Name' => 'BillingPeriodName', 'Title' => 'Perioda'), 
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'SubjectName', 0);
+    $Output .= $Order['Output'];
+
+    $Query = $SQL.' '.$Order['SQL'].$PageList['SQLLimit'];
+   
+    $DbResult = $this->Database->query($Query);
+    while($Row = $DbResult->fetch_assoc()) 
+    { 
+      $Output .= '<tr>'.
+      '<td>'.$Row['SubjectName'].'</td>'.
+      '<td>'.$Row['Monthly'].'</td>'.
+      '<td>'.$Row['Cash'].'</td>'.
+      '<td>'.date('j.n.Y', $Row['LastDate']).'</td>'.
+      '<td>'.$Row['ServicesNextMonth'].'</td>'.
+      '<td>'.$Row['BillingPeriodName'].'</td>'.
+      '</tr>';
+    }
+    $Output .= '</table>';
+    $Output .= $PageList['Output'];
+    $Output .= '<a href="?Operation=ProcessMonthlyPayment">Generovat faktury</a>';
+    return($Output);
+  }
+  
+  function ProcessMonthlyPayment()
   {
     if(!$this->System->Modules['User']->CheckPermission('Finance', 'Manage')) return('Nemáte oprávnění');

@@ -9 +9 @@
 .buildpath
 .settings
+nbproject