Actions
Feature #4816
openTemplates for QFQ Reports (Tables, Radios, ..)
Start date:
25.10.2017
Due date:
% Done:
0%
Estimated time:
Discuss:
Prio Planung:
Vote:
Description
Easy way to create bootstrap tables and other template based fluff.
Now:
10 { sql = SELECT v.id AS _id, m.nr, CONCAT(v.name, ' (', v.gr_id, ')'), CONCAT('p:cassignment&grId=', v.gr_id, '&semId=', v.sem_id, '|S|s') AS _link, CONCAT('p:exercisesheets&vId=', v.id, '&gr_id=', v.gr_id, '&semId=', v.sem_id, '|E|s') AS _link FROM vorlesung AS v, gruppe_member AS gm, modul AS m WHERE v.sem_id = 35 AND v.v_typ = 'VL' AND v.id = gm.x_id2 AND gm.gr_id = 896 AND m.id = gm.x_id head = <table class="table table-condensed table-striped"> <thead> <tr> <th width="70">Modul</th> <th>Name</th> <th width="50"></th> <th width="50"></th> </tr> </thead> <tbody> rbeg = <tr> rend = </tr> fbeg = <td> fend = </td> tail = </tbody></table> }
Then:
10 { sql = SELECT v.id AS _id, m.nr, CONCAT(v.name, ' (', v.gr_id, ')'), CONCAT('p:cassignment&grId=', v.gr_id, '&semId=', v.sem_id, '|S|s') AS _link, CONCAT('p:exercisesheets&vId=', v.id, '&gr_id=', v.gr_id, '&semId=', v.sem_id, '|E|s') AS _link FROM vorlesung AS v, gruppe_member AS gm, modul AS m WHERE v.sem_id = 35 AND v.v_typ = 'VL' AND v.id = gm.x_id2 AND gm.gr_id = 896 AND m.id = gm.x_id type = table head = <th width="70">Modul</th> <th>Name</th> <th width="50"></th> <th width="50"></th> }
list
Now:
10 { sql = SELECT p.name, ', ', p.vorname FROM person AS p WHERE .... head = <ul> rbeg = <li> rend = </li> tail = </ul> }
Then:
10 { sql = SELECT p.name, ', ', p.vorname FROM person AS p WHERE .... type = list }
Updated by Benjamin Baer about 6 years ago
- Subject changed from Templates for Tables to Templates for QFQ Reports (Tables, Radios, ..)
Updated by Carsten Rose over 5 years ago
- Tracker changed from Support to Feature
Updated by Carsten Rose over 4 years ago
- Status changed from New to Some day maybe
Updated by Carsten Rose about 4 years ago
- Target version changed from next7 to next9
Actions