select_db($Config['Database']['Database']);
$Output = 'Výpis příspěvků
';
$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 .= ''.$html->PageList('page_index', $Page, $TotalCount, $Config['Web']['TableRowPerPage'], 10).'
';
$Output .= ''.
''.
'| Datum | '.
'Suma | '.
'Popis | '.
'Odměna | '.
'
';
$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 .= ''.
'| '.$date.' | '.
''.$plus.$row['Money'].' | '.
''.$operace[$row['Operation']].' '.$row['Description'].' | '.
''.$odmena.' | '.
'
';
}
$Output .= '
';
$Output .= ''.$html->PageList('page_index', $Page, $TotalCount, $Config['Web']['TableRowPerPage'], 10).'
';
echo($Output);
?>