Changeset 185 for trunk/finance/finance.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/finance.php (modified) (3 diffs)

trunk/finance/finance.php

@@ -23 +23 @@
   var $ExternalSubject = 96;
   var $MainSubject = 71;
+        var $BillingPeriods;
   
   function RecalculateTariffs($Period = 1)
@@ -98 +99 @@
   function LoadMonthParameters($Period = 1) // 0 - now, 1 - next month
   {   
-    $DbResult = $this->Database->query("SELECT * FROM finance_charge WHERE period=".$Period);
+                $DbResult = $this->Database->query('SELECT * FROM FinanceBillingPeriod');
+                while($BillingPeriod = $DbResult->fetch_assoc())
+                  $this->BillingPeriods[$BillingPeriod['Id']] = $BillingPeriod;
+                
+    $DbResult = $this->Database->query('SELECT * FROM finance_charge WHERE period='.$Period);
     $Row = $DbResult->fetch_array();
     $this->kWh = $Row['kWh'];
@@ -140 +145 @@
     return($Result);
   }
+  
+  function RecalculateMemberPayment()
+  {
+    $Output = 'Aktualizuju finance členů...<br />';
+    $this->Database->query('TRUNCATE TABLE MemberPayment');
+    $DbResult = $this->Database->query('SELECT * FROM Member');
+    while($Member = $DbResult->fetch_assoc())
+    {
+      $DbResult2 = $this->Database->query('SELECT ((SELECT COALESCE(SUM(Value), 0) FROM FinanceOperation WHERE Subject='.$Member['Subject'].') + (SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject='.$Member['Subject'].')) as Cash');
+      $Cash = $DbResult2->fetch_row();
+      $Cash = $Cash[0];
+          
+      $DbResult2 = $this->Database->query('SELECT SUM(consumption) FROM network_devices WHERE (user='.$Member['Id'].') AND (used = 1)');
+      $ConsumptionPlus = $DbResult2->fetch_row();
+      $ConsumptionPlus = $ConsumptionPlus[0];
+
+      $NetworkDevice = 0;
+      $Consumption = 0;
+      $ID = $Member['NetworkSegment'];
+      while($ID != 0)
+      {
+        $DbResult2 = $this->Database->query('SELECT * FROM network_segments WHERE id='.$ID);
+        $Device = $DbResult2->fetch_assoc();
+        $NetworkDevice += $Device['price'] / $Device['users'];
+        $Consumption += $Device['consumption'] / $Device['users_overheads'];
+        //echo($ID.' '.$InternetSegment.' '.$InternetSegmentId.' '.$Row['inet_hw'].' '.$Price.'<br>');
+        $ID = $Device['parent'];
+      }
+          
+      $Monthly = 0;
+      $MonthlyInet = $this->Tarify[$Member['InternetTariffNextMonth']]['price'];
+      //if($Row['inet'] == 1)
+      $Monthly += $MonthlyInet; 
+      $Monthly -= $this->W2Kc($ConsumptionPlus); 
+      //if($Row['overheads'] == 1) $Monthly += $Sprava; // + W2Kc($Consumption); 
+      //echo($Row['fullname'].' '.$Row['inet'].' '.$Monthly.'<br>');
+      $Monthly = round($Monthly);
+      //echo($Row['fullname'].' '.$Row['inet'].' '.$Monthly.'<br>');
+                
+      $this->Database->insert('MemberPayment', array('Member' => $Member['Id'], 'NetworkDevice' => $NetworkDevice, 'MonthlyInternet' => $MonthlyInet, 'MonthlyTotal' => $Monthly, 'MonthlyConsumption' => $this->W2Kc($Consumption), 'Cash' => $Cash, 'MonthlyPlus' => $this->W2Kc($ConsumptionPlus)));
+    }
+                $this->System->Modules['Log']->NewRecord('Finance', 'RecalculateMemberPayment');        
+    return($Output);
+  } 
+  
+  function RecalculateSegmentParameters()
+  {
+    $Output = 'Aktualizuju parametry segmentů...<br />';
+    $this->Database->query('UPDATE network_segments SET users = 0, users_overheads = 0');               // Vynulovat počty uživatelů
+    $DbResult = $this->Database->query('SELECT * FROM network_segments');
+    while($NetworkSegment = $DbResult->fetch_array())
+    {
+      //echo('Segment '.$Row['name'].'<br>');
+      $DbResult2 = $this->Database->query('SELECT users FROM network_segments WHERE id='.$NetworkSegment['id']);
+      $RowP = $DbResult2->fetch_array();
+      $DbResult2 = $this->Database->query('SELECT users_overheads FROM network_segments WHERE id='.$NetworkSegment['id']);
+      $RowP2 = $DbResult2->fetch_array();
+
+      $DbResult2 = $this->Database->query('SELECT SUM(price) as Price, SUM(consumption) as Consumption FROM network_devices WHERE segment='.$NetworkSegment['id'].' AND used=1');
+      $Row2 = $DbResult2->fetch_array();
+      $DbResult2 = $this->Database->query('SELECT COUNT(*) FROM Member WHERE NetworkSegment='.$NetworkSegment['id']);
+      $Row3 = $DbResult2->fetch_array();
+      $ID = $NetworkSegment['parent'];
+      while($ID != 0)
+      {
+        //echo($ID.', ');
+        $DbResult2 = $this->Database->query('SELECT * FROM network_segments WHERE id='.$ID);
+        $Row4 = $DbResult2->fetch_array();
+        $this->Database->update('network_segments', 'id='.$Row4['id'], array('users' => ($Row4['users'] + $Row3[0]), 'users_overheads' => ($Row4['users_overheads'] + $Row3[0])));
+        $ID = $Row4['parent'];
+      }
+      //echo('Pocet '.$Row3[0].','.$Row['hosts'].'<br>');
+      $this->Database->update('network_segments', 'id='.$NetworkSegment['id'], array('price' => $Row2['Price'], 'users' => ($Row3[0] + $RowP['users']), 'consumption' => $Row2['Consumption'], 'users_overheads' => ($Row3[0] + $RowP2['users_overheads'])));
+    }
+
+    // Zkorigovat segment Internet
+    $DbResult = $this->Database->select('Member', 'COUNT(*)');
+    $Row = $DbResult->fetch_array();
+    $DbResult = $this->Database->update('network_segments','id='.$this->InternetSegmentId, array('users' => $Row[0], 'users_overheads' => $Row[0]));
+                $this->System->Modules['Log']->NewRecord('Finance', 'RecalculateSegmentParameters');
+    return($Output);
+  }  
 }