Changeset 634 for trunk

Timestamp:

Sep 14, 2009, 7:53:21 AM (15 years ago)

Author:

george

Message:

• Upraveno: Stránka s výpisem dotací osamostatněna a doplněna o stránkování.
• Přidáno: Zobrazení ročních příjmů a nákladů na stránce financí.

Location:

trunk

Files:

• inc/config.sample.php (modified) (1 diff)
• inc/html.php (modified) (1 diff)
• inc/module.php (modified) (1 diff)
• inc/realm.php (modified) (1 diff)
• inc/server.php (modified) (1 diff)
• index.php (modified) (1 diff)
• pages/dotation.php (modified) (1 diff)
• pages/dotation_dump.php (added)
• pages/guilda.php (modified) (1 diff)
• pages/guildy.php (modified) (1 diff)
• styles/style.css (modified) (1 diff)

trunk/inc/config.sample.php

@@ -69 +69 @@
     'ServerFounded' => '1.1.2000',
     'BankAccount' => '670100-2202937132/6210',
+    'TableRowPerPage' => 20,
     'ServerList' => array(
       1 => array(

trunk/inc/html.php

@@ -301 +301 @@
     }
   }  
+  
+  function GetQueryStringArray()
+  {
+    $Result = array();
+    $Parts = explode('&', $_SERVER['QUERY_STRING']);
+    foreach($Parts as $Part)
+    {
+      if($Part != '')
+      {
+        $Item = explode('=', $Part);
+        $Result[$Item[0]] = $Item[1];
+      }
+    }
+    return($Result);
+  }
+
+  function SetQueryStringArray($QueryStringArray)
+  {
+    $Parts = array();
+    foreach($QueryStringArray as $Index => $Item)
+    {
+      $Parts[] = $Index.'='.$Item;
+    }
+    return(implode('&', $Parts));
+  }
+
+  // Zobrazení číselný seznamu stránek
+  function PageList($QueryStringVar, $Page, $TotalCount, $CountPerPage, $Around = 10)
+  { 
+    $QueryStringArray = $this->GetQueryStringArray();
+    $Count = ceil($TotalCount / $CountPerPage);
+    $Result = '';
+    if($Count > 1)
+    {
+      if($Page > 0) 
+      {
+        $QueryStringArray[$QueryStringVar] = 0;
+        $Result .= '<a href="?'.$this->SetQueryStringArray($QueryStringArray).'">&lt;&lt;</a> ';
+        $QueryStringArray[$QueryStringVar] = $Page - 1;
+        $Result .= '<a href="?'.$this->SetQueryStringArray($QueryStringArray).'">&lt;</a> ';
+      }
+      $PagesMax = $Count - 1;
+      $PagesMin = 0;
+      if($PagesMax > ($Page + $Around)) $PagesMax = $Page + $Around;
+      if($PagesMin < ($Page - $Around))
+      {
+        $Result .= ' .. ';
+        $PagesMin = $Page - $Around;
+      }
+      for($i = $PagesMin; $i <= $PagesMax; $i++)
+      {
+        if($i == $Page) $Result .= '<strong>';
+        $QueryStringArray[$QueryStringVar] = $i;
+        $Result .= '<a href="?'.$this->SetQueryStringArray($QueryStringArray).'">'.($i + 1).'</a> ';
+        if($i == $Page) $Result .= '</strong>';
+      }
+      if($PagesMax < ($Count - 1)) $Result .= ' .. ';
+      if($Page < ($Count - 1)) 
+      {
+        $QueryStringArray[$QueryStringVar] = $Page + 1;
+        $Result .= '<a href="?'.$this->SetQueryStringArray($QueryStringArray).'">&gt;</a> ';
+        $QueryStringArray[$QueryStringVar] = $Count - 1;
+        $Result .= '<a href="?'.$this->SetQueryStringArray($QueryStringArray).'">&gt;&gt;</a>';
+      }
+    }
+    return($Result);
+  }
 }
 

trunk/inc/module.php

@@ -10 +10 @@
   {
     $this->Database = $System->Database;
-    $this->Config = $System->Config;
+    $this->Config = &$System->Config;
     $this->System = $System;
   }

trunk/inc/realm.php

@@ -1 +1 @@
 <?php
+
+include_once(dirname(__FILE__).'/module.php');
 
 class Realm extends Module

trunk/inc/server.php

@@ -1 +1 @@
 <?php
+
+include_once(dirname(__FILE__).'/module.php');
 
 function NullErrorHandler()

trunk/index.php

@@ -30 +30 @@
 include_once('inc/error.php');
 include_once('inc/database.php');
-include_once('inc/module.php');
 include_once('inc/html.php');
 include_once('inc/system.php');

trunk/pages/dotation.php

@@ -23 +23 @@
 </p>';
 
-$operace = array(
-  'buy' => 'Nákup',
-  'sell' => 'Prodej',
-  'consumption' => 'Spotřeba',
-  'internet' => 'Internet',
-  'contribution' => 'Příspěvek od',
-);
-
 $load_money = $db->query('SELECT SUM(`Money`) FROM `Finance`;')->fetch_row();
 
 $Output .= '<p><strong>Aktuální stav financí: '.$load_money[0].' Kč</strong></p>';
+
+$Output .= '<h4 class="Center">Roční přehledy financování</h4>';
 $Output .= '<table class="BaseTable">'.
-  '<tr>'.
-  '<th>Datum</th>'.
-  '<th>Suma</th>'.
-  '<th>Popis</th>'.
-  '<th>Odměna</th>'.
-  '</tr>'; 
+  '<tr><th>Rok</th><th>Příjmy</th><th>Výdaje</th><th>Rozdíl</th></tr>';
+$DbResult = $db->query('SELECT MAX(Time), MIN(Time) FROM Finance');
+$TimeRange = $DbResult->fetch_array();
 
-$load_dotation = $db->query('SELECT * FROM `Finance` ORDER BY `Id` DESC');
-while($row = $load_dotation->fetch_assoc())
+$StartDateTimeParts = explode(' ',$TimeRange['MIN(Time)']);
+$StartDateParts = explode('-',$StartDateTimeParts[0]);
+$EndDateTimeParts = explode(' ',$TimeRange['MAX(Time)']);
+$EndDateParts = explode('-',$EndDateTimeParts[0]);
+
+$TotalIncome = 0;
+$TotalExpense = 0;
+for($Year = $EndDateParts[0]; $Year >= $StartDateParts[0]; $Year--)
 {
-  $odmena = $row['Reward'];
-  
-  if($row['Time'] != '')
-  {
-    $date = $server->HumanDate($row['Time'], 0);
-    //$date = $row['time'];
-  } else $date = '';
-  if($row['Money'] > 0) $plus = '+';
-    else $plus = '';
-  $Output .= '<tr>'.
-    '<td>'.$date.'</td>'.
-    '<td>'.$plus.$row['Money'].'</td>'.
-    '<td>'.$operace[$row['Operation']].' '.$row['Description'].'</td>'.
-    '<td>'.$odmena.'</td>'.
-    '</tr>';
+  $DbResult = $db->query('SELECT SUM(Money) AS Income FROM Finance WHERE (Money > 0) AND (Time >= "'.$Year.'-01-01") AND (Time < DATE_ADD("'.$Year.'-01-01", INTERVAL 1 YEAR))');
+  $Income = $DbResult->fetch_assoc();
+  $Income = $Income['Income'];
+  $TotalIncome += $Income;
+  $DbResult = $db->query('SELECT -SUM(Money) AS Expense FROM Finance WHERE (Money < 0) AND (Time >= "'.$Year.'-01-01") AND (Time < DATE_ADD("'.$Year.'-01-01", INTERVAL 1 YEAR))');
+  $Expense = $DbResult->fetch_assoc();
+  $Expense = $Expense['Expense'];
+  $TotalExpense += $Expense;
+  $Output .= '<tr><td>'.$Year.'</td><td>'.$Income.'</td><td>'.$Expense.'</td><td>'.($Income - $Expense).'</td></tr>';
 }
+$Output .= '<tr><th>Celkem</th><th>'.$TotalIncome.'</th><th>'.$TotalExpense.'</th><th>'.($TotalIncome - $TotalExpense).'</th></tr>';
 $Output .= '</table>';
+
+$Output .= '<br/><div class="Center"><a href="?page=dotation_dump">Výpis jednotlivých příspěvků</a></div>';
 
 echo($Output); 

trunk/pages/guilda.php

@@ -43 +43 @@
       <td>'.$total_members.' (Online : '.$online_mem['online_mem'].')</td>
     </tr>');
-  $DbResult = $db->query('SELECT Homepage FROM GuildInfo WHERE Guild='.$guild_id);
+  $DbResult = $db->query('SELECT Homepage FROM GuildInfo WHERE Guild='.$guild_id.' AND Realm='.$Realm->Id);
   $DbRow = $DbResult->fetch_assoc();
   $Homepage = $DbRow['Homepage'];

trunk/pages/guildy.php

@@ -52 +52 @@
   $DbResult = $db2->query('SELECT COUNT(*) AS online_mem  FROM `guild_member`, `characters`, `guild` WHERE guild.guildid = '.$row['guildid'].' AND guild_member.guildid = guild.guildid AND guild_member.guid = characters.guid AND characters.online = 1');
   $online_mem = $DbResult->fetch_assoc();
-  $DbResult = $db->query('SELECT Homepage FROM GuildInfo WHERE Guild='.$row['guildid']);
+  $DbResult = $db->query('SELECT Homepage FROM GuildInfo WHERE Guild='.$row['guildid'].' AND Realm='.$Realm->Id);
   $DbRow = $DbResult->fetch_assoc();
   $Homepage = $DbRow['Homepage'];

trunk/styles/style.css

@@ -305 +305 @@
 }
 
+.Center
+{
+  margin-left: auto;
+  margin-right: auto;
+  text-align: center;
+}
+