Changeset 639 for trunk/Modules/Finance/Manage.php

Timestamp:

Mar 16, 2014, 1:33:22 AM (11 years ago)

Author:

chronos

Message:

• Přidáno: Při úpravě ve formuláři pro typ OneToMany přidána možnost přidat novou vztaženou položku.
• Přidáno: Možnost předefinovat předvolené hodnoty nových položek formuláře. Použito především pro vztažené položky typu OneToMany.

File:

• trunk/Modules/Finance/Manage.php (modified) (19 diffs)

trunk/Modules/Finance/Manage.php

@@ -6 +6 @@
   var $ShortTitle = 'Správa financí';
   var $ParentClass = 'PageFinance';
-  
+
   function Show()
   {
     $Output = '';
-    if(!$this->System->User->CheckPermission('Finance', 'Manage')) 
+    if(!$this->System->User->CheckPermission('Finance', 'Manage'))
       return('Nemáte oprávnění');
 
-    if(array_key_exists('Operation', $_GET)) $Operation = $_GET['Operation']; 
+    if(array_key_exists('Operation', $_GET)) $Operation = $_GET['Operation'];
       else $Operation = '';
     switch($Operation)
@@ -39 +39 @@
     return($Output);
   }
-  
+
   function GetBillingPeriod($Period)
   {
@@ -46 +46 @@
     $PeriodTo = mktime(0, 0, 0, date('n') + $MonthCount - 1, date('t', mktime(0, 0, 0, date('n') + $MonthCount - 1, 1, date('Y'))) , date('Y'));
     return(array('From' => $PeriodFrom, 'To' => $PeriodTo, 'MonthCount' => $MonthCount));
-  } 
+  }
 
   function ShowMonthlyPayment()
@@ -62 +62 @@
       'FinanceBillingPeriod.Id=Member.BillingPeriodNext WHERE (Member.Blocked = 0)'.
       'AND (Member.BillingPeriodNext > 1) AND (MemberPayment.MonthlyTotal != 0)';
-    
+
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$SQL.') AS T');
     $DbRow = $DbResult->fetch_row();
-    $PageList = GetPageList($DbRow[0]);    
+    $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'), 
+      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);
@@ -82 +82 @@
 
     $Query = $SQL.' '.$Order['SQL'].$PageList['SQLLimit'];
-   
+
     $DbResult = $this->Database->query($Query);
-    while($Row = $DbResult->fetch_assoc()) 
-    { 
+    while($Row = $DbResult->fetch_assoc())
+    {
       $Output .= '<tr>'.
       '<td>'.$Row['SubjectName'].'</td>'.
@@ -100 +100 @@
     return($Output);
   }
-  
+
   function InsertInvoice($Subject, $TimeCreation, $TimeDue, $Items,
   $DocumentLine, $PeriodFrom, $PeriodTo)
   {
     global $LastInsertTime;
-    
+
     $Year = date('Y', $TimeCreation);
     $BillCode = $this->System->Modules['Finance']->GetNextDocumentLineNumber($DocumentLine, $Year);
@@ -124 +124 @@
     return($InvoiceId);
   }
-  
+
   function ProduceInvoices()
   {
     $Output = '';
-    
+
     // Generuj účetní položky
     $DbResult = $this->Database->query('SELECT Member.*, MemberPayment.MonthlyTotal AS MonthlyTotal, '.
@@ -169 +169 @@
           $MonthlyTotal -= $Member['MonthlyPlus'];
         }
-        $PayPerPeriod = $MonthlyTotal * $Period['MonthCount'];  
+        $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']);
-    
+          $this->InsertInvoice($Member['Subject'], time(), time() + 3600 * 24 * INVOICE_DUE_DAYS,
+            $InvoiceItems, DOC_LINE_INVOICE_OUT, $Period['From'], $Period['To']);
+
           $Output .= $this->SendPaymentEmail($Member['Id']);
         } else $Output .= '<br />';
-        $this->Database->update('Member', 'Id='.$Member['Id'], 
+        $this->Database->update('Member', 'Id='.$Member['Id'],
           array('BillingPeriodLastDate' => TimeToMysqlDateTime($Period['To'])));
       } else $Output .= '<br />';
-    }  
+    }
     return($Output);
   }
-  
+
   function TableUpdatePeriod($Table)
   {
@@ -212 +212 @@
     }
     $this->Database->delete($Table, '`Action` IS NOT NULL');
-  }  
-  
+  }
+
   function ProcessMonthlyPayment()
   {
@@ -221 +221 @@
     $Finance = &$this->System->Modules['Finance'];
     $Finance->LoadMonthParameters(0);
-    
+
     // Načti poslední měsíční přehled a nastavení
     $DbResult = $this->Database->select('FinanceMonthlyOverall', '*', '1 ORDER BY Date DESC LIMIT 1');
@@ -227 +227 @@
 
     $Output -= 'Datum: '.date('j.n.Y').'<br />';
-    
+
     $DateParts = explode('-', $Overall['Date']);
     $MonthLast = $DateParts[1];
@@ -242 +242 @@
     $TotalDeviceCost = $Row[0];
     $Output .= 'Celková cena zařízení: Zařízení('.$TotalDeviceCost;
-    
+
     $DbResult = $this->Database->query('SELECT SUM(Price) FROM NetworkSegment');
     $Row = $DbResult->fetch_row();
     $TotalSegmentDeviceCost = $Row[0];
     $Output .= '), Segmenty('.$TotalSegmentDeviceCost;
-    
+
     $DbResult = $this->Database->query('SELECT SUM(NetworkDevice) FROM MemberPayment');
     $Row = $DbResult->fetch_row();
     $TotalMemberDeviceCost = $Row[0];
     $Output .= '), Členové('.$TotalMemberDeviceCost.')<br />';
-    
+
     $DbResult = $this->Database->query('SELECT SUM(Cash) FROM MemberPayment');
     $Row = $DbResult->fetch_row();
     $TotalMemberCash = $Row[0];
-    $Output .= 'Stav pokladny: Členové('.$TotalMemberCash.')';   
+    $Output .= 'Stav pokladny: Členové('.$TotalMemberCash.')';
 
     $DbResult = $this->Database->query('SELECT SUM(Product.Consumption) AS Consumption FROM StockItem '.
@@ -272 +272 @@
     {
       $Output .= 'Odečítám měsíční poplatek...<br />';
-      $Output .= $this->ProduceInvoices();    
-      
+      $Output .= $this->ProduceInvoices();
+
       // Update finance charge
       $Output .= 'Měním aktuální parametry sítě...<br>';
@@ -281 +281 @@
       $DbResult = $this->Database->query('SELECT * FROM FinanceCharge WHERE Action IS NULL LIMIT 1');
       $Charge = $DbResult->fetch_assoc();
-      $this->Database->insert('FinanceMonthlyOverall', array('Date' => 'NOW()', 
-        'Money' => $Finance->Internet, 'kWh' => $Finance->kWh, 
-        'Administration' => $Finance->Sprava, 'AdministrationTotal' => $SpravaCelkem, 
-        'ConsumptionTotal' => $TotalConsumptionCost, 'TotalPaid' => $Finance->TotalPaid, 
-        'BaseTariffPrice' => $Charge['BaseTariffPrice'], 
+      $this->Database->insert('FinanceMonthlyOverall', array('Date' => 'NOW()',
+        'Money' => $Finance->Internet, 'kWh' => $Finance->kWh,
+        'Administration' => $Finance->Sprava, 'AdministrationTotal' => $SpravaCelkem,
+        'ConsumptionTotal' => $TotalConsumptionCost, 'TotalPaid' => $Finance->TotalPaid,
+        'BaseTariffPrice' => $Charge['BaseTariffPrice'],
         'TopTariffPrice' => $Charge['TopTariffPrice'], 'MemberCount' => $Finance->InternetUsers));
 
       // Update services
       $Output .= 'Aktualizuji služby....<br>';
-      $this->TableUpdatePeriod('Service');    
+      $this->TableUpdatePeriod('Service');
       // Update customer service selections
       $Output .= 'Aktualizuji výběr služeb zákazníků....<br>';
-      $this->TableUpdatePeriod('ServiceCustomerRel');     
-      
+      $this->TableUpdatePeriod('ServiceCustomerRel');
+
       $Finance->RecalculateMemberPayment();
       //CreateMonthlyOverallBill();
@@ -300 +300 @@
 
       // Restart traffic shaping
-      //$this->Database->update('NetworkConfiguration', 'Id = 3', array('Changed' => 1));     
+      //$this->Database->update('NetworkConfiguration', 'Id = 3', array('Changed' => 1));
       //flush();
       //$this->GenerateBills();
@@ -306 +306 @@
     return($Output);
   }
-  
+
   function SendPaymentEmail($MemberId, $FileId = '')
   {
     global $Config;
-    
+
     $DbResult = $this->Database->select('Member', '*', 'Id='.$MemberId);
     $Member = $DbResult->fetch_assoc();
 
     $DbResult = $this->Database->select('MemberPayment', '*', 'Member='.$MemberId);
-    $MemberPayment = $DbResult->fetch_assoc();   
+    $MemberPayment = $DbResult->fetch_assoc();
 
     $DbResult = $this->Database->select('Subject', 'Name', 'Id='.$Member['Subject']);
-    $Subject = $DbResult->fetch_assoc();      
-    
-    $DbResult = $this->Database->select('User', '*', 'Id='.$Member['ResponsibleUser']);    
+    $Subject = $DbResult->fetch_assoc();
+
+    $DbResult = $this->Database->select('User', '*', 'Id='.$Member['ResponsibleUser']);
     $User = $DbResult->fetch_assoc();
-    
+
     $DbResult = $this->Database->select('Subject', '*', '`Id`='.$Config['Finance']['MainSubjectId']);
-    $MainSubject = $DbResult->fetch_assoc();  
-    
+    $MainSubject = $DbResult->fetch_assoc();
+
     $DbResult = $this->Database->query('SELECT FinanceBankAccount.*, CONCAT(FinanceBankAccount.Number, "/", FinanceBank.Code) AS NumberFull FROM FinanceBankAccount '.
       'JOIN FinanceBank ON FinanceBank.Id=FinanceBankAccount.Bank '.
       'WHERE (FinanceBankAccount.`Subject`='.$Config['Finance']['MainSubjectId'].') AND (FinanceBankAccount.`Use`=1)');
     $MainSubjectAccount = $DbResult->fetch_assoc();
-        
+
     if($User['Email'] != '')
     {
@@ -357 +357 @@
       while($DbRow = $DbResult->fetch_assoc())
       {
-        $Text = $DbRow['Text'];        
+        $Text = $DbRow['Text'];
         $Content .= '<tr><td style="border-style: solid; border-width: 1px; padding: 1px 5px 1px 5px; text-align: center;">'.HumanDate($DbRow['Time']).'</td>'.
           '<td style="border-style: solid; border-width: 1px; padding: 1px 5px 1px 5px; text-align: center;">'.$Text.'</td>'.
@@ -364 +364 @@
       $Content .= '</table><br />'."\n".
       'Pro aktuální informace, prohlížení elektronických dokladů a možnost změny údajů se prosím přihlašte na stránkách <a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'">http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'</a>.<br /><br />'."\n";
-        
+
       $Content .= '<br />Tento email je generován automaticky. V případě zjištění nesrovnalostí napište zpět.';
-      $this->System->ModuleManager->Modules['EmailQueue']->AddItem($User['Name'].' <'.$User['Email'].'>', $Title, $Content, 
+      $this->System->ModuleManager->Modules['EmailQueue']->AddItem($User['Name'].' <'.$User['Email'].'>', $Title, $Content,
          $Config['Web']['Admin'].' <'.$Config['Web']['AdminEmail'].'>');
       $Output = '';
     } else $Output = 'Uživatel '.$User['Name'].' nemá email.';
   }
-  
+
   function GenerateBills()
   {
     $Output = '';
-    
+
     // FinanceInvoice
     $DbResult = $this->Database->query('SELECT * FROM `FinanceInvoice` WHERE (`BillCode` <> "") '.
@@ -420 +420 @@
         $Output .= '.';
       } else $Output .= 'Soubor "'.$FullFileName.'" se nepodařilo uložit.';
-    }    
+    }
     return($Output);
   }