Changeset 129 for www/finance/prepocet.php

Timestamp:

Jan 5, 2009, 7:31:45 AM (16 years ago)

Author:

george

Message:

• Odstraněno: Openwebmail. * Odstraněno: phpMyAdmin. * Upraveno: Mnoho malých úprav a oprav.

File:

• www/finance/prepocet.php (modified) (4 diffs)

www/finance/prepocet.php

@@ -164 +164 @@
   echo("Odečítám měsíční poplatek...<br>\n");
 
+  $BillingPeriodMonthCount = array('never' => 0, 'monthly' => 1, 'quarterly' => 3, 'half-yearly' => 6, 'yearly' => 12);
+
   // Generuj účetní položky
-  $DbResult = $Database->query("SELECT *,CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE role=2");
-  while($Row = $DbResult->fetch_array())
-  {
-    echo($Row['fullname'].': '.($Row['plus'] - $Row['monthly'])."<br>\n");
-
-    $BillId = $InvoiceGenerator->CreateBill($Row['id'], array(array('description' => 'Poplatek za připojení k síti', 'price' => ($Row['monthly'] - $Row['plus']), 'quantity' => 1)), time(), time() + (date("t", time()) - 1) * 24 * 3600);
-
-    $Database->insert('finance_operations',array('money' => ($Row['plus'] - $Row['monthly']), 'user' => $Row['id'], 'type' => 2, 'date' => 'NOW()', 'comment' => 'Poplatek za měsíc '.$Mesice[$Mesic], 'group' => 1, 'bill_id' => $BillId));
-  }
-
+  $DbResult = $Database->query("SELECT *, CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE (role = 2)");
+  while($User = $DbResult->fetch_array())
+  {
+    echo($User['fullname'].': ');
+    $MonthCount = $BillingPeriodMonthCount[$User['BillingPeriod']];
+    if(($MonthCount > 0) and (((($Mesic - 1) % 12) % $MonthCount) == 0) and ($User['inet_tarif_now'] != 6))
+    {
+      //echo($Mesic.'%'.$MonthCount.'='.($Mesic % $MonthCount).' ');
+      $PayPerMonth = -($User['plus'] - $User['monthly']);
+      $PayPerPeriod = $PayPerMonth * $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'));
+      $TimePeriodText = date('j.n.Y', $PeriodFrom).' - '.date('j.n.Y', $PeriodTo);
+      echo($TimePeriodText.': '.$PayPerMonth." * ".$MonthCount." = ".$PayPerPeriod."\n");
+      $BillId = $InvoiceGenerator->CreateBill($User['id'], array(array('description' => 'Připojení k síti', 'price' => $PayPerPeriod, 'quantity' => 1)), $PeriodFrom, $PeriodTo);
+      $Database->insert('finance_operations', array('money' => -$PayPerPeriod, 'user' => $User['id'], 'type' => 2, 'date' => 'NOW()', 'comment' => 'Připojení k síti za období '.$TimePeriodText, 'group' => 1, 'bill_id' => $BillId));
+    } else echo("\n");
+  }
   echo('Měním aktuální parametry sítě...<br>\n');
 
@@ -184 +194 @@
   $DbResult = $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']));
-  
+
   echo("Přidávám měsíční přehled...<br>\n");
 
-  $Database->insert('finance_monthly_overall', array('date' => 'NOW()', 'money' => $Internet, 'kWh' => $kWh, 'administration' => $Sprava, 'administration_total' => $SpravaCelkem, 'consumption_total' => $CelkemSpotreba, 'total_paid' => $TotalPaid, 'BaseTariffPrice' => $Charge['BaseTariffPrice'], 'TopTariffPrice' => $Charge['TopTariffPrice']));
-  
+  $Database->insert('finance_monthly_overall', array('date' => 'NOW()', 'money' => $Internet, 'kWh' => $kWh, 'administration' => $Sprava, 'administration_total' => $SpravaCelkem, 'consumption_total' => $CelkemSpotreba, 'total_paid' => $TotalPaid, 'BaseTariffPrice' => $Charge['BaseTariffPrice'], 'TopTariffPrice' => $Charge['TopTariffPrice'], 'member_count' => $InternetUsers));
+
   echo("Měním aktuální tarify....<br>\n");
 
@@ -199 +209 @@
       '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']));
   }
-  
+
   echo("Měním aktuální tarify uživatelů...<br>\n");
 
@@ -211 +221 @@
   RecalculateTariffs();
   RecalculateUsersFinance();
-  CreateMonthlyOverallBill();
+  //CreateMonthlyOverallBill();
   RecalculateUsersFinance();
-  
+
   // Restart traffic shaping
   $Database->update('services_restart', 'id=3', array('changed' => 1));