Changeset 185 for trunk/finance/manage.php

Timestamp:

Apr 3, 2009, 10:32:35 AM (16 years ago)

Author:

george

Message:

• Opraveno: Přepočítávání stavu financí členů a generování periodických plateb.

File:

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

trunk/finance/manage.php

@@ -48 +48 @@
         $Output = $this->ShowNewInvoiceForm();
         break;
+      case 'Recalculate':
+        $Output = $this->System->Modules['Finance']->RecalculateSegmentParameters();
+        $Output .= $this->System->Modules['Finance']->RecalculateMemberPayment();
+        break;
+      case 'MonthlyPayment':
+        $Output = $this->ShowMonthlyPayment();
+        break;
       default:
         $Output = '<a href="?Operation=NewDeviceForm">Přidat nové zařízení</a><br />';
@@ -53 +60 @@
         $Output .= '<a href="?Operation=NewPaymentForm">Přidat novou platbu</a><br />';
         $Output .= '<a href="?Operation=NewInvoiceForm">Přidat novou fakturu</a><br />';
-        $Output .= '<a href="?Operation=ImportOldData">Importovat stará data</a><br />';
+        //$Output .= '<a href="?Operation=ImportOldData">Importovat stará data</a><br />';
         $Output .= '<a href="?Operation=ConvertPDFToFile">Převést data z databáze do souborů</a><br />';
         $Output .= '<a href="?Operation=Bills">Správa dokladů</a><br />';
         //$Output .= '<a href="?Operation=ConvertData">Převést tabulky</a><br />';
-                    $Output .= '<a href="prepocet.php">Přepočet financí</a><br />';
-                    $Output .= '<a href="clenove.php">Seznam členů</a><br />';
-                    $Output .= '<a href="zivnost.php">Živnost</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="clenove.php">Seznam členů</a><br />';
+        $Output .= '<a href="zivnost.php">Živnost</a><br />';
     }
     return($Output);
@@ -229 +237 @@
   }
 
+  /*
   function ImportOldData()
   {
-    die();
-    
     $Output = '';
     $this->Database->query('TRUNCATE TABLE FinanceCashFlow');
@@ -355 +362 @@
     return($Output);
   }
-
+  */
+  
   function ConvertPDFDataToFiles()
   {
@@ -378 +386 @@
   }
 
+  /*
   function ConvertData()
   {
-    die();
-    
     $Finance = $this->System->Modules['Finance'];
           $Output = '';
@@ -440 +447 @@
         return($Output);
   }
+  */
+
+        
+        function GetBillingPeriod($Period)
+        {
+    $MonthCount = $this->System->Modules['Finance']->BillingPeriods[$Period]['MonthCount'];
+    $PeriodFrom = mktime(0, 0, 0, date('n'), 1, date('Y'));
+    $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()
+  {
+    if(!$this->System->Modules['User']->CheckPermission('Finance', 'Manage')) return('Nemáte oprávnění');
+          $Output = '';
+
+    $Finance = &$this->System->Modules['Finance'];
+          
+    // Načti poslední měsíční přehled a nastavení
+    $DbResult = $this->Database->select('finance_monthly_overall', '*', '1 ORDER BY date DESC LIMIT 1');
+    $Overall = $DbResult->fetch_array();
+
+    $Output -= 'Datum: '.date('j.n.Y').'<br />';
+    
+    $Datum = explode('-', $Overall['date']);
+    $Mesic = date('m') + 0;
+
+    $Output .= $Finance->RecalculateSegmentParameters();
+    $Output .= $Finance->RecalculateTariffs();
+    //$InvoiceGenerator->CustomGenerate();
+    $Output .= $Finance->RecalculateMemberPayment();
+
+    // Celkovy prehled
+    $DbResult = $this->Database->query('SELECT SUM(price) FROM network_devices WHERE used = 1');
+    $Row = $DbResult->fetch_row();
+                $TotalDeviceCost = $Row[0];
+    $Output .= 'Celková cena zařízení: Zařízení('.$TotalDeviceCost;
+                
+    $DbResult = $this->Database->query('SELECT SUM(price) FROM network_segments');
+    $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.')';   
+
+    $DbResult = $this->Database->query('SELECT SUM(consumption) FROM network_devices WHERE used=1');
+    $Row = $DbResult->fetch_row();
+                $TotalConsumption = $Row[0];
+    $TotalConsumptionCost = $Finance->W2Kc($TotalConsumption);
+
+    $SpravaCelkem = $Finance->Sprava * $Finance->SpravaUsers;
+    $Output .= 'Kontrola placení (Zaplaceno-Sprava-Internet): '.$Finance->TotalPaid.'-'.$SpravaCelkem.'-'.$Finance->Internet.'='.($Finance->TotalPaid - $SpravaCelkem - $Finance->Internet).'<br />';
+
+    // Zkontrolovat odečtení měsíčního poplatku
+    //$Mesic = '1';
+    $Output .= 'Kontrola odečtení poplatků: Poslední měsíc-'.round($Datum[1]).' Aktuální měsíc-'.$Mesic.'<br />';
+    //if($Mesic != $Datum[1])
+    {
+      $Output .= 'Odečítám měsíční poplatek...<br />';
+
+      // Generuj účetní položky
+      $DbResult = $this->Database->query('SELECT Member.*, MemberPayment.MonthlyTotal, UNIX_TIMESTAMP(Member.BillingPeriodLastDate), Subject.Name AS SubjectName FROM MemberPayment JOIN Member ON Member.Id=MemberPayment.Member JOIN Subject ON Subject.Id=Member.Subject');
+      while($Member = $DbResult->fetch_array())
+      {
+        $Output .= $Member['SubjectName'].': ';
+                                $Period = $this->GetBillingPeriod($Member['BillingPeriodNext']);
+                                if($Period['From'] > $Member['UNIX_TIMESTAMP(Member.BillingPeriodLastDate)'])
+                                {
+                                        $this->Database->update('Member', 'Id='.$Member['Id'], array('BillingPeriod' => $Member['BillingPeriodNext'], 'InternetTariffCurrentMonth' => $Member['InternetTariffNextMonth']));
+                                        $Member['BillingPeriod'] = $Member['BillingPeriodNext'];
+                                }
+                                $Period = $this->GetBillingPeriod($Member['BillingPeriod']);
+                                $PayPerPeriod = $Member['MonthlyTotal'] * $Period['MonthCount'];
+        if(($Period['From'] > $Member['UNIX_TIMESTAMP(Member.BillingPeriodLastDate)']) and ($Member['InternetTariffCurrentMonth'] != 6) and ($PayPerPeriod > 0))
+        {
+          //echo($Mesic.'%'.$MonthCount.'='.($Mesic % $MonthCount).' ');                                                
+          $TimePeriodText = date('j.n.Y', $Period['From']).' - '.date('j.n.Y', $Period['To']);
+          $Output .= $TimePeriodText.': '.$Member['MonthlyTotal'].' * '.$Period['MonthCount'].' = '.$PayPerPeriod.'<br />';
+          $BillCode = $Finance->GetNextDocumentLineNumber(6); // Faktury vydané
+          $BillId = $this->System->Modules['Bill']->CreateBill($Member['Subject'], array(array('Description' => 'Připojení k síti', 'Price' => $PayPerPeriod, 'Quantity' => 1)), $Period['From'], $Period['To'], $BillCode);
+          $this->Database->insert('FinanceClaimsLiabilities', array('Value' => $PayPerPeriod, 'Subject' => $Member['Subject'], 'TimeCreation' => 'NOW()', 'Text' => 'Připojení k síti za období '.$TimePeriodText, 'Bill' => $BillId, 'BillCode' => $BillCode));
+                                        $this->Database->update('Member', 'Id='.$Member['Id'], array('BillingPeriodLastDate' => TimeToMysqlDateTime($Period['To'])));
+        } else $Output .= '<br />';
+      }
+                        
+      // Update finance charge
+      $Output .= 'Měním aktuální parametry sítě...<br>';
+      $this->Database->delete('finance_charge', 'period = 0');
+      $DbResult = $this->Database->select('finance_charge', '*', 'period = 1');
+      $Charge = $DbResult->fetch_assoc();
+      //print_r($Charge);
+      $DbResult = $this->Database->insert('finance_charge', array('period' => 0, 'internet' => $Charge['internet'], 'internet_speed' => $Charge['internet_speed'], 'internet_speed_reserve' => $Charge['internet_speed_reserve'], 'administration_per_user' => $Charge['administration_per_user'], 'kWh' => $Charge['kWh'], 'base_speed_element' => $Charge['base_speed_element'], 'BaseTariffPrice' => $Charge['BaseTariffPrice'], 'TopTariffPrice' => $Charge['TopTariffPrice']));
+
+      $Output .= 'Přidávám měsíční přehled...<br />';
+      $this->Database->insert('finance_monthly_overall', array('date' => 'NOW()', 'money' => $Finance->Internet, 'kWh' => $Finance->kWh, 'administration' => $Finance->Sprava, 'administration_total' => $SpravaCelkem, 'consumption_total' => $TotalConsumptionCost, 'total_paid' => $Finance->TotalPaid, 'BaseTariffPrice' => $Charge['BaseTariffPrice'], 'TopTariffPrice' => $Charge['TopTariffPrice'], 'member_count' => $Finance->InternetUsers));
+
+      $Output .= 'Měním aktuální tarify....<br>';
+      // Update tarrifs
+      $this->Database->delete('finance_tariffs', 'period=0');
+      $DbResult = $this->Database->select('finance_tariffs', '*', 'period = 1');
+      while($Tariff = $DbResult->fetch_array())
+      {
+        $this->Database->insert('finance_tariffs', array('period' => 0, 'name' => $Tariff['name'], 'id' => $Tariff['id'],'speed_factor' => $Tariff['speed_factor'], 'price_units' => $Tariff['price_units'], 'group_id' => $Tariff['group_id'], 'min_speed' => $Tariff['min_speed'], 'max_speed' => $Tariff['max_speed'], 'price' => $Tariff['price']));
+      }
+
+      $Output .= $Finance->RecalculateTariffs();
+            $Finance->RecalculateMemberPayment();
+      //CreateMonthlyOverallBill();
+      //$Finance->RecalculateUsersFinance();
+
+      // Restart traffic shaping
+      $this->Database->update('services_restart', 'id = 3', array('changed' => 1));
+    }
+    return($Output);
+  }
 }