Ziskanie nazvov stlpcov z vysledku databazoveho dotazu
- kiri
- Člen | 13
Ahojte.
Uz par dni hladam a neviem nic najst.
Ak v presenteri priamo pomocou Query vytvorim dotaz,
a to napriklad aj s vlastnym pomenovatim stlpcov, viem sa v latte nejak dostak
k nazvom stlpcov z nejakych metadat $result ?
Chcel by som s nimi napriklad vypnit zahlavie tabulky. Aby som po prerobeni
Query nemusel znovu opravovat nazvy stlpcov v zahlavi tabulky v latte.
$result = $this->database->query('
SELECT
DAYNAME(datum) as den,
DATE_FORMAT(datum, \'%d.%m.%Y\') AS datum,
DATE_FORMAT(cas, \'%H.%i\') AS cas,
zakaznik,
case tel_obj
when 0 then \'WEB\'
else \'TEL\'
end as tel_obj,
telefon,
typ_auta,
znacka_auta,
spz,
case tk
when 0 then NULL
else \'TK\'
end as tk,
case ek
when 0 then NULL
else \'EK\'
end as ek,
email
FROM test;
');
$this->template->rows = $result;
...
<table class='zoznam'>
<tr>
<th>den</th>
<th>datum</th>
<th>cas</th>
<th>zakaznik</th>
<th>sposob objednania</th>
<th>telefon</th>
<th>druh vozidla</th>
<th>vyrobca</th>
<th>SPZ</th>
<th>TK</th>
<th>EK</th>
<th>e-mail</th>
</tr>
{foreach $rows as $row}
<tr>
<td>{$row->den}</td>
<td>{$row->datum }</td>
<td>{$row->cas}</td>
<td>{$row->zakaznik}</td>
<td>{$row->tel_obj}</td>
<td>{$row->telefon}</td>
<td>{$row->typ_auta}</td>
<td>{$row->znacka_auta}</td>
<td>{$row->spz}</td>
<td>{$row->tk}</td>
<td>{$row->ek}</td>
<td>{$row->email}</td>
</tr>
{/foreach}
...
- Kamil Valenta
- Člen | 844
<table class='zoznam'>
{foreach $rows as $row}
{if $iterator->isFirst()}
<tr>
{foreach $row as $col => $val}
<th>{$col}</th>
{/foreach}
</tr>
{/if}
<tr>
<td>{$row->den}</td>
<td>{$row->datum }</td>
<td>{$row->cas}</td>
<td>{$row->zakaznik}</td>
<td>{$row->tel_obj}</td>
<td>{$row->telefon}</td>
<td>{$row->typ_auta}</td>
<td>{$row->znacka_auta}</td>
<td>{$row->spz}</td>
<td>{$row->tk}</td>
<td>{$row->ek}</td>
<td>{$row->email}</td>
</tr>
{/foreach}