source: trunk/pages/finance-vypis.php

<?php

$db->select_db($Config['Database']['Database']);

$Output = '<h2 class="PageTitle">Výpis příspěvků</h2>';

$operace = array(
  'buy' => 'Nákup',
  'sell' => 'Prodej',
  'consumption' => 'Spotřeba',
  'internet' => 'Internet',
  'contribution' => 'Příspěvek od',
  'hosting' => 'Server hosting',
);

if(array_key_exists('page_index', $_GET)) $Page = $_GET['page_index'];
  else $Page = 0; 
$DbResult = $db->query('SELECT COUNT(*) FROM `Finance`');
$DbRow = $DbResult->fetch_row();
$TotalCount = $DbRow[0];

$Output .= '<div class="Center">'.$html->PageList('page_index', $Page, $TotalCount, $Config['Web']['TableRowPerPage'], 10).'</div>';
$Output .= '<table class="BaseTable">'.
  '<tr>'.
  '<th>Datum</th>'.
  '<th>Suma</th>'.
  '<th>Popis</th>'.
  '<th>Odměna</th>'.
  '</tr>'; 

$load_dotation = $db->query('SELECT * FROM `Finance` ORDER BY `Time` DESC LIMIT '.($Page * $Config['Web']['TableRowPerPage']).','.$Config['Web']['TableRowPerPage']);
while($row = $load_dotation->fetch_assoc())
{
  $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>';
}
$Output .= '</table>';
$Output .= '<div class="Center">'.$html->PageList('page_index', $Page, $TotalCount, $Config['Web']['TableRowPerPage'], 10).'</div>';

echo($Output); 

?>