Ignore:
Timestamp:
Oct 4, 2012, 9:01:28 AM (12 years ago)
Author:
chronos
Message:
  • Upraveno: Přejmenovaná tabulka network_device a hosts_topology.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/finance/inventory.php

    r157 r409  
    1212    $Output = 'Výpis skladových zásob:<br><table class="WideTable">';
    1313    $Output .= '<tr><th>Název</th><th>Datum<br />zakoupení</th><th>Cena [Kč]</th><th>Počet</th><th>Cena<br /> dohromady [Kč]</th></tr>';
    14     $DbResult = $this->Database->query("SELECT * FROM network_devices WHERE used=2");
     14    $DbResult = $this->Database->query("SELECT * FROM Product WHERE Used=2");
    1515    while($Row = $DbResult->fetch_array())
    1616    {
    17       $Output .= '<tr><td>'.$Row['name'].'</td><td align="right">'.HumanDate($Row['date']).'</td><td align="right">'.$Row['price'].'</td><td align="right">'.$Row['count'].'</td><td align="right">'.$Row['count'] * $Row['price'].'</td></tr>';
    18       $TotalPrice = $TotalPrice + $Row['count'] * $Row['price'];
     17      $Output .= '<tr><td>'.$Row['Name'].'</td><td align="right">'.HumanDate($Row['Date']).'</td><td align="right">'.$Row['Price'].'</td><td align="right">'.$Row['Count'].'</td><td align="right">'.$Row['Count'] * $Row['Price'].'</td></tr>';
     18      $TotalPrice = $TotalPrice + $Row['Count'] * $Row['Price'];
    1919    }
    2020
Note: See TracChangeset for help on using the changeset viewer.