Changeset 408 for trunk/finance/zarizeni.php
- Timestamp:
- Oct 4, 2012, 8:29:32 AM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/finance/zarizeni.php
r195 r408 11 11 // Seznam segmentů a zařízení 12 12 $Output = 'Seznam segmentů a zařízení:<br><table style="font-size: smaller;" class="WideTable"><tr><th>Název</th><th>Spotřeba<br>[W]</th><th>Datum<br>zakoupení</th><th>Cena [Kč]</th></tr>'; 13 $DbResult = $this->Database->query('SELECT * FROM network_segments');13 $DbResult = $this->Database->query('SELECT * FROM NetworkSegment'); 14 14 while($Row = $DbResult->fetch_array()) 15 15 { 16 $Output .= '<tr><td style="text-align: left" colspan="3"><strong>Segment: '.$Row[' name'].' ('.$Row['users'].')</strong></td><td style="font-weight: Bold;" align="right">'.$Row['price'].'</td></tr>';17 $DbResult2 = $this->Database->query('SELECT * FROM network_devices WHERE segment='.$Row[' id'].' AND used=1');16 $Output .= '<tr><td style="text-align: left" colspan="3"><strong>Segment: '.$Row['Name'].' ('.$Row['Users'].')</strong></td><td style="font-weight: Bold;" align="right">'.$Row['Price'].'</td></tr>'; 17 $DbResult2 = $this->Database->query('SELECT * FROM network_devices WHERE segment='.$Row['Id'].' AND used=1'); 18 18 while($Row = $DbResult2->fetch_array()) 19 19 { 20 $Output .= '<tr><td style="text-align: left; padding-left: 20px;">'.$Row[' name'].'</td><td align="right">'.$Row['consumption'].'</td><td align="right">'.HumanDate($Row['date']).'</td><td align="right">'.$Row['price'].'</td></tr>';20 $Output .= '<tr><td style="text-align: left; padding-left: 20px;">'.$Row['Name'].'</td><td align="right">'.$Row['consumption'].'</td><td align="right">'.HumanDate($Row['Date']).'</td><td align="right">'.$Row['Price'].'</td></tr>'; 21 21 } 22 22 }
Note:
See TracChangeset
for help on using the changeset viewer.