source: www/finance/clenove.php@ 143

<?php
include('../style.php');
include('include.php');
include('bills.php');
RecalculateTariffs(1);

if(array_key_exists('id',$_GET)) $UserID = $_GET['id'];
if(!array_key_exists('show',$_GET)) $_GET['show'] = '';
switch($_GET['show'])
{
  case 'user':
    ShowHeader('Seznam účastníků sítě', 'Seznam účastníků');
    $DbResult = $Database->query("SELECT *,CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE id=".$UserID);
    $Row2 = $DbResult->fetch_array();
    $TarifName = $Tarify[$Row2['inet_tarif_next']]['name'];
    echo('<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">');
  
    // Tabulka operaci
    echo('Výpis operací pro účastníka '.$Row2['fullname'].':<br>');
    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3"><tr><th>Datum</th><th>Popis</th><th>Částka [Kč]</th><th>Doklad</th></tr>');
    $Operations = array();
    $DbResult = $Database->query('(SELECT Time, Value, Text, Bill FROM FinanceCashFlow WHERE Subject='.$_GET['id'].') UNION ALL '.
      '(SELECT TimeCreation as Time, (-Value) as Value, Text, Bill FROM FinanceClaimsLiabilities WHERE Subject='.$_GET['id'].') ORDER BY Time DESC');
    while($DbRow = $DbResult->fetch_array())
      $Operations[] = $DbRow;
    foreach($Operations as $Row)
    {
      if($Row['Value'] > 0) $Row['Value'] = '+'.$Row['Value'];
      if($Row['Bill'] > 0) $Invoice = '<a href="?show=bill&amp;id='.$Row['Bill'].'">PDF</a>'; else $Invoice = '&nbsp;';
      echo('<tr><td align="right">'.HumanDate($Row['Time']).'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Invoice.'</td></tr>');
    }
    //echo('<tr><td>&nbsp;</td><td>-'.$Row2['network_device'].'</td><td>Proměnná cena za zařízení</td></tr>
    echo('</table>');
    $DbResult = $Database->query('SELECT ((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject='.$_GET['id'].') + '.
      '(SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject='.$_GET['id'].')) as Total');
    $DbRow = $DbResult->fetch_array();
    $Total = $DbRow['Total'];
    echo('<h3><strong>Stav účtu: </strong>'.$Total.' Kč</h3><br>');
    echo('</td><td valign="top">');

    if($Row2['role'] == 2)
    {
      echo('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'];
      }
      echo('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>');
      echo('<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>');
    */

      echo('Měsíční příjem za spotřebu zařízení umístěných u uživatele:<br>');
      echo('<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 = $Database->query("SELECT * FROM network_devices WHERE user=".$UserID." AND used=1");
      $TotalW = 0;
      $TotalPrice = 0;
      while($Row = $DbResult->fetch_array())
      {
        echo('<tr><td>'.$Row['name'].'</td><td>'.$Row['consumption'].'</td><td>'.W2Kc($Row['consumption']).'</td></tr>');
        $TotalW += $Row['consumption'];
        $TotalPrice += W2Kc($Row['consumption']);
      }
      echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$TotalW.'</strong></td><td><strong>'.$TotalPrice.'</strong></td></tr>');
      echo('</table>');
    }
    echo('</td></tr></table>');
    ShowFooter();
    break;
  case 'bill':
    $InvoiceGenerator->ShowStoredBill($_GET['id']);
    break;
  default:
    ShowHeader('Seznam účastníků sítě', 'Seznam účastníků');
    // Seznam členů
    echo('Seznam účastníků:<br>'.
    '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">'.
    '<tr><th>Jméno</th>');
    //<th>Cena za zařízení [Kč]</th>
    echo('<th>Měsíční poplatek [Kč]</th><th>Stav účtu [Kč]</th><th>Běžící tarif</th><th>Příští tarif</th><th>Poznámky</th></tr>');
    $TotalDevice = 0;
    $TotalMonth = 0;
    $TotalCash = 0;
    $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Fullname, ((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject=users.id) + '.
      '(SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject=users.id)) as Cash FROM users WHERE role=2 ORDER BY fullname');

    //$DbResult = $Database->query("SELECT *,CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE role=2 ORDER BY fullname");
    while($Row = $DbResult->fetch_array())
    {
      $Monthly = $Row['monthly'] - $Row['plus'];
      if($Row['hw'] == 0) $Monthly = '(trvale nepřipojen) '.(-$Row['plus']);
      else {     
        if($Row['overheads'] == 0) $Monthly = '(dočasně nepřipojen) '.$Monthly;
        else {
          if($Row['inet'] == 0) $Monthly = '(bez internetu) '.$Monthly;
          else $Monthly = $Monthly;
        }
      } 
      //$Row['cash'] = $Row['AdvancesIn'] - $Row['AdvancesOut'] + $Row['Liabilities'] - $Row['Claims'];
      $TotalCash += $Row['Cash'];
      if($Row['Cash'] < 0) $Row['Cash'] = '<span style="color: red;">'.$Row['Cash'].'</span>';
      $Tarif = $Tarify[$Row['inet_tarif_now']]['name'];
      $PristiTarif = $Tarify[$Row['inet_tarif_next']]['name'];
      echo('<tr><td><a href="?show=user&amp;id='.$Row['id'].'">'.$Row['Fullname'].'</a></td>');
//<td align="right">'.$Row['network_device'].'</td>
      echo('<td align="right">'.$Monthly.'</td><td align="right">'.$Row['Cash'].'</td><td align="center">'.$Tarif.'</td><td align="center">'.$PristiTarif.'</td><td>'.$Row['notice'].'&nbsp;</td></tr>');
      $TotalDevice += $Row['network_device'];
      $TotalMonth += ($Row['monthly'] - $Row['plus']);
    }
    echo('<tr><td><strong>Celkem</strong></td>');
    //<td align="right"><strong>'.$TotalDevice.'</strong></td>
    echo('<td align="right"><strong>'.$TotalMonth.'</strong></td><td align="right"><strong>'.$TotalCash.'</strong></td><td align="right">&nbsp;</td><td align="right">&nbsp;</td><td align="right">&nbsp;</td></tr>');
    echo('</table>');
    ShowFooter();
  }

?>