Changeset 157 for www/finance/finance.php

Timestamp:

Feb 18, 2009, 11:19:12 AM (15 years ago)

Author:

george

Message:

• Upraveno: Soubor include.php ve financích přepracován na třídy ve finance.php.

File:

• www/finance/finance.php (modified) (1 diff)

www/finance/finance.php

@@ -3 +3 @@
 class Finance extends Module
 {
+  var $kWh;
+  var $Internet;
+  var $Sprava;
+  var $DatumOdecteni;
+  var $InternetUsers;
+  var $SpravaUsers;
+  var $InternetSegmentId = 21;
+  var $MaxSpeed;
+  var $RealMaxSpeed;
+  var $SpeedReserve;
+  var $BaseSpeedElement;
+  var $TotalConsumption;
+  var $UserIdNetwork = 46;
+  var $BaseTariffPrice;
+  var $TopTariffPrice;
+  var $TotalPaid;
+  var $TotalInternetPaid;
+  var $Tarify;
+  
+  function RecalculateTariffs($Period = 1)
+  {
+    $ResidualPrice = $this->Internet;
+    $ResidualSpeed = $this->MaxSpeed;
+  
+    $Tarify = array();
+    $DbResult = $this->Database->select('finance_tariffs', '*', 'period='.$Period.' ORDER BY id,speed_factor');
+    while($Tariff = $DbResult->fetch_array())
+    {
+      $Tarify[$Tariff['id']] = $Tariff;
+    }  
 
+    if($Period == 0) $Column = 'now'; else $Column = 'next';
+    $TotalUserCount = 0;
+    $TotalUnits = 0;
+    $TotalTarifUnits = 0;
+    $TotalTarifSpeedUnits = 0;
+    foreach($Tarify as $Index => $Tarif)
+    {
+      $DbResult = $this->Database->select('users', 'COUNT(*)', 'inet_tarif_'.$Column.'='.$Index.' AND inet=1 AND role=2');
+      $Row = $DbResult->fetch_array();
+      $Tarify[$Index]['user_count'] = $Row[0];    
+      switch($Tarif['group_id'])
+      {
+        case 1:
+          $TotalUserCount = $TotalUserCount + $Tarify[$Index]['user_count'];
+          $Tarify[$Index]['total_units'] = $Tarify[$Index]['price_units'] * $Tarify[$Index]['user_count'];
+          $TotalTarifUnits = $TotalTarifUnits + $Tarify[$Index]['total_units'];
+    
+          if($Index == 3) // Zarizeni site v tarifu 3 neplati penize, ale ma internet
+            $Tarify[$Index]['total_speed_factor'] = $Tarify[$Index]['speed_factor'] * ($Tarify[$Index]['user_count']+1);
+            else $Tarify[$Index]['total_speed_factor'] = $Tarify[$Index]['speed_factor'] * $Tarify[$Index]['user_count'];
+          $TotalTarifSpeedUnits = $TotalTarifSpeedUnits + $Tarify[$Index]['total_speed_factor'];
+          break;
+        case 2:
+          $ResidualPrice -= $Tarif['price'] * $Tarify[$Index]['user_count'];
+          $ResidualSpeed -= $Tarif['min_speed'] * $Tarify[$Index]['user_count'];
+          $Tarify[$Index]['total_units'] = $Tarify[$Index]['price_units'] * $Tarify[$Index]['user_count'];
+          break;
+        case 3:
+          $Tarify[$Index]['total_units'] = $Tarify[$Index]['price_units'] * $Tarify[$Index]['user_count'];
+          break;
+      }
+    }
+    //$PricePerUnit = $TopTariffPrice / ;  // $ResidualPrice / $TotalTarifUnits;
+    $SpeedPerUnit = $ResidualSpeed * 1024 / $TotalTarifSpeedUnits;
+  
+    // Recalculate price
+    foreach($Tarify as $Index => $Tarif)
+    {
+      switch($Tarif['group_id'])
+      {
+        case 1:
+          $Tarify[$Index]['price'] = $this->BaseTariffPrice + round($this->TopTariffPrice * $Tarif['price_units'] / 10) * 10;
+          $Tarify[$Index]['min_speed'] = round($Tarif['speed_factor'] * $SpeedPerUnit);
+          $Tarify[$Index]['max_speed'] = round($Tarify[$Index]['speed_factor'] * $this->BaseSpeedElement * 1024);
+          break;
+        case 2:
+          $Tarify[$Index]['min_speed'] = $Tarify[$Index]['min_speed'] * 1024;
+          $Tarify[$Index]['max_speed'] = $Tarify[$Index]['max_speed'] * 1024;
+          break;
+        case 3:
+          $Tarify[$Index]['price'] = $this->BaseTariffPrice + round($this->TopTariffPrice * $Tarif['price_units']);
+          $Tarify[$Index]['min_speed'] = $Tarify[$Index]['min_speed'] * 1024;
+          $Tarify[$Index]['max_speed'] = $Tarify[$Index]['max_speed'] * 1024;
+          break;
+      }
+      $Tarify[$Index]['aggregation'] = '1:'.round($Tarify[$Index]['max_speed'] / $Tarify[$Index]['min_speed']);
+    }
+        $this->Tarify = $Tarify;
+  }
+
+  function LoadMonthParameters($Period = 1) // 0 - now, 1 - next month
+  {   
+    $DbResult = $this->Database->query("SELECT * FROM finance_charge WHERE period=".$Period);
+    $Row = $DbResult->fetch_array();
+    $this->kWh = $Row['kWh'];
+    $this->Internet = $Row['internet'];
+    $this->Sprava = $Row['administration_per_user'];
+    $this->RealMaxSpeed = $Row['internet_speed'];
+    $this->SpeedReserve = $Row['internet_speed_reserve'];
+    $this->BaseSpeedElement = $Row['base_speed_element'];
+    $this->MaxSpeed = $this->RealMaxSpeed - $this->SpeedReserve;
+    $this->TopTariffPrice = $Row['TopTariffPrice'];
+    $this->BaseTariffPrice = $Row['BaseTariffPrice'];
+
+    $DbResult = $this->Database->query("SELECT COUNT(*) FROM users WHERE inet=1 AND role=2");
+    $Row = $DbResult->fetch_array();
+    $this->InternetUsers = $Row[0];
+ 
+    $DbResult = $this->Database->query("SELECT COUNT(*) FROM users WHERE overheads=1 AND role=2");
+    $SpravaUsers = $DbResult->fetch_array();
+    $this->SpravaUsers = $SpravaUsers[0];
+    $DbResult = $this->Database->query("SELECT SUM(consumption) FROM network_segments");
+    $TotalConsumption = $DbResult->fetch_array();
+    $this->TotalConsumption = $TotalConsumption[0];
+
+    $DbResult = $this->Database->query("SELECT SUM(`monthly`) as `internet`, SUM(`monthly` - `plus`) as `real` FROM users WHERE role=2");
+    $Row = $DbResult->fetch_array();
+    $this->TotalInternetPaid = $Row['internet'];
+    $this->TotalPaid = $Row['real'];
+  
+    $this->RecalculateTariffs($Period);
+  }
+
+  function W2Kc($Spotreba)
+  {
+    return(round($Spotreba * 0.72 * $this->kWh));
+  }
+
+  function GetNextDocumentLineNumber($Id)
+  {    
+    $DbResult = $this->Database->query('SELECT Shortcut, NextNumber FROM DocumentLine WHERE Id='.$Id);
+    $DbRow = $DbResult->fetch_assoc();
+    $Result = $DbRow['Shortcut'].$DbRow['NextNumber'];
+    $this->Database->query('UPDATE DocumentLine SET NextNumber = NextNumber + 1 WHERE Id='.$Id);
+    return($Result);
+  }
 }