Changeset 156 for www/finance/user_state.php

Timestamp:

Feb 17, 2009, 10:00:28 PM (16 years ago)

Author:

george

Message:

• Opraveno: Některé soubory financí aktualizovány na nové rozvržení tabulek User, Member, Subject.

File:

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

www/finance/user_state.php

@@ -18 +18 @@
     $UserId = $this->System->Modules['User']->User['Id'];
     if(!array_key_exists('show', $_GET)) $_GET['show'] = '';
-    $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id=(SELECT Subject FROM Member WHERE Id=(SELECT Member FROM User='.$UserId.'))');
-    $Row2 = $DbResult->fetch_array();
-    $TarifName = $Tarify[$Row2['inet_tarif_next']]['name'];
+    $DbResult = $this->Database->query('SELECT Id FROM Subject WHERE Id=(SELECT Subject FROM Member WHERE Id=(SELECT Member FROM User WHERE Id='.$UserId.'))');
+    $Subject = $DbResult->fetch_assoc();
+    $DbResult = $this->Database->query('SELECT InternetTariffCurrentMonth FROM Member WHERE Id=(SELECT Member FROM User WHERE Id='.$UserId.')');
+    $Member = $DbResult->fetch_assoc();
+    $TarifName = $Tarify[$Member['InternetTariffCurrentMonth']]['name'];
+        $TarifPrice = $Tarify[$Member['InternetTariffCurrentMonth']]['price'];
     $Output = '<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">';
 
     // Tabulka operaci
-    $Output .= 'Výpis operací pro účastníka '.$Row2['Name'].':<br>';
+    $DbResult = $this->Database->query('SELECT CONCAT(SecondName, " ", FirstName) as Name FROM User WHERE Id='.$UserId);
+    $User = $DbResult->fetch_assoc();
+    $Output .= 'Výpis operací pro účastníka '.$User['Name'].':<br>';
     $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3"><tr><th>Datum</th><th>Popis</th><th>Částka</th><th>Doklad</th></tr>';
     $Operations = array();
-    $DbResult = $this->Database->query('(SELECT Time, Value, Text, Bill FROM FinanceCashFlow WHERE Subject='.$UserId.') UNION ALL '.
-      '(SELECT TimeCreation as Time, -Value as Value, Text, Bill FROM FinanceClaimsLiabilities WHERE Subject='.$UserId.') ORDER BY Time DESC');
+    $DbResult = $this->Database->query('(SELECT Time, Value, Text, Bill FROM FinanceCashFlow WHERE Subject='.$Subject['Id'].') UNION ALL '.
+      '(SELECT TimeCreation as Time, -Value as Value, Text, Bill FROM FinanceClaimsLiabilities WHERE Subject='.$Subject['Id'].') ORDER BY Time DESC');
     while($DbRow = $DbResult->fetch_array())
       $Operations[] = $DbRow;
@@ -40 +45 @@
     //echo('<tr><td>&nbsp;</td><td>-'.$Row2['network_device'].'</td><td>Proměnná cena za zařízení</td></tr>
     $Output .= '</table>';
-    $DbResult = $this->Database->query('SELECT ((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject='.$UserId.') + '.
-      '(SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject='.$UserId.')) as Total');
+    $DbResult = $this->Database->query('SELECT ((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject='.$Subject['Id'].') + '.
+      '(SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject='.$Subject['Id'].')) as Total');
     $DbRow = $DbResult->fetch_array();
     $Total = $DbRow['Total'];
@@ -47 +52 @@
     $Output .= '</td><td valign="top">';
 
-    if($Row2['role'] == 2)
+    $Output .= 'Variabilní symbol pro platby: <strong>'.$Subject['Id'].'</strong><br><br>';
+
+    $DbResult = $this->Database->query('SELECT SUM(consumption) AS Total FROM network_devices WHERE user='.$UserId.' AND used=1');
+        $ConsumptionBonus = $DbResult->fetch_assoc();
+        $ConsumptionBonus = W2Kc($ConsumptionBonus['Total']);
+
+        $Total = 0;
+    $Output .= 'Rozpis měsíčního poplatku:<br><table border="1" cellspacing="0" cellpadding="3">'.
+      '<tr><th>Část</th><th>Cena [Kč]</th></tr>'.
+      '<tr><td>Internet - tarif '.$TarifName.'</td><td>'.$TarifPrice.'</td></tr>';
+        $Total += $TarifPrice;
+        if($ConsumptionBonus != 0)
+      $Output .= '<tr><td>Příjem za spotřebu</td><td>'.(-$ConsumptionBonus)  .'</td></tr>';
+        $Total += -$ConsumptionBonus;
+    $Output .= '<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td></tr></table>';
+    //echo('Tarif pro příští měsíc: '.$Tarify[$Row2['inet_tarif_next']]['name'].'<br><br>');
+    $Output .= '<br />';
+    
+    if($ConsumptionBonus != 0)
     {
-      $Output .= 'Variabilní symbol pro platby: <strong>'.$Row2['id'].'</strong><br><br>';
-
-      // Měsíční bilance
-      if($Row2['inet'] == 1) $InternetPrice = round($Row2['monthly_inet']); else $InternetPrice = 0;
-      if($Row2['overheads'] == 0) 
-      {
-        $PoplatekSprava = 0;
-        $PoplatekSpotreba = 0;
-        $PrijemSpotreba = $Row2['plus'];
-      } else {
-        $PoplatekSprava = $Sprava;
-        $PoplatekSpotreba = $Row2['consumption'];
-        $PrijemSpotreba = $Row2['plus'];
-      }
-      $Output .= 'Rozpis měsíčního poplatku:<br><table border="1" cellspacing="0" cellpadding="3">'.
-      '<tr><th>Část</th><th>Cena [Kč]</th></tr>'.
-      '<tr><td>Internet - tarif '.$TarifName.'</td><td>'.$InternetPrice.'</td></tr>'.
-      //'<tr><td>Správa</td><td>'.$PoplatekSprava.'</td></tr>'.
-      //'<tr><td>Poplatek za spotřebu</td><td>'.$PoplatekSpotreba.'</td></tr>'.
-      '<tr><td>Příjem za spotřebu</td><td>'.(-1*$PrijemSpotreba)  .'</td></tr>'.
-      '<tr><td><strong>Celkem</strong></td><td><strong>'.($InternetPrice // + $PoplatekSprava + $PoplatekSpotreba
-        - $PrijemSpotreba).'</strong></td></tr></table>';
-      //echo('Tarif pro příští měsíc: '.$Tarify[$Row2['inet_tarif_next']]['name'].'<br><br>');
-      $Output .= '<br>';
-    
-    /*
-
-    // Rozpis ceny za zařízení
-    echo('Výpis podílu na zařízení segmentů:');
-    echo('<table border="1" cellspacing="0" cellpadding="3"><tr><th>Název segmentu</th><th>Cena [Kč]</th><th>Uživatelů</th><th>Podíl [Kč]</th></tr>');
-    $ID = $Row2['network_segment'];
-    $Money = 0;
-    while($ID > 0)
-    {
-      $DbResult = $Database->query("SELECT * FROM network_segments WHERE id=".$ID);
-      $Row = $DbResult->fetch_array();
-      if(!(($Row2['inet_hw'] == 0) and ($ID == $InternetSegmentId)))
-      {     
-        $Money += $Row['price']/$Row['users'];
-        echo('<tr><td>'.$Row['name'].'</td><td>'.$Row['price'].'</td><td>'.$Row['users'].'&nbsp;</td><td>'.round($Row['price']/$Row['users']).'</td></tr>');
-      }
-      $ID = $Row['parent'];
-    }
-    echo('<tr><td><strong>Celkem</strong></td><td>&nbsp;</td><td>&nbsp;</td><td><strong>'.round($Money).'</strong></td></tr>');
-    echo('</table><br>');
-
-    // Rozpis platba spotřeby segmentů
-    echo('Výpis podílu na spotřebě segmentů:');
-    echo('<table border="1" cellspacing="0" cellpadding="3"><tr><th>Název segmentu</th><th>Cena [Kč]</th><th>Uživatelů</th><th>Podíl [Kč]</th></tr>');
-    $ID = $Row2['network_segment'];
-    $Money = 0;
-    while($ID>0)
-    {
-      $DbResult = $Database->query("SELECT * FROM network_segments WHERE id=".$ID);
-      $Row = $DbResult->fetch_array();
-      $Money += round(W2Kc($Row['consumption'])/$Row['users_overheads']);
-      echo('<tr><td>'.$Row['name'].'</td><td>'.W2Kc($Row['consumption']).'</td><td>'.$Row['users_overheads'].'&nbsp;</td><td>'.round(W2Kc($Row['consumption'])/$Row['users_overheads']).'</td></tr>');
-      $ID = $Row['parent'];
-    }
-    echo('<tr><td><strong>Celkem</strong></td><td>&nbsp;</td><td>&nbsp;</td><td><strong>'.round($Money).'</strong></td></tr>');
-    echo('</table><br>');
-    */
-
-      $Output .= 'Měsíční příjem za spotřebu zařízení umístěných u uživatele:<br>';
+          $Output .= 'Měsíční příjem za spotřebu zařízení umístěných u uživatele:<br>';
       $Output .= '<table border="1" cellspacing="0" cellpadding="3"><tr><th>Název zařízení</th><th>Spotřeba [W]</th><th>Příjem [Kč]</th></tr>';
-      $DbResult = $this->Database->query("SELECT * FROM network_devices WHERE user=".$UserId." AND used=1");
+      $DbResult = $this->Database->query('SELECT * FROM network_devices WHERE user='.$UserId.' AND used=1');
       $TotalW = 0;
       $TotalPrice = 0;
-      while($Row = $DbResult->fetch_array())
+      while($Row = $DbResult->fetch_assoc())
       {
         $Output .= '<tr><td>'.$Row['name'].'</td><td>'.$Row['consumption'].'</td><td>'.W2Kc($Row['consumption']).'</td></tr>';
@@ -125 +85 @@
       $Output .= '<tr><td><strong>Celkem</strong></td><td><strong>'.$TotalW.'</strong></td><td><strong>'.$TotalPrice.'</strong></td></tr>';
       $Output .= '</table>';
-    }
+        }
     $Output .= '</td></tr></table>';
     return($Output);
   }
-
 }