QFQ

Feature #4816

Updated by Benjamin Baer over 6 years ago

Easy way to create bootstrap tables and other template based fluff. tables. 

 Now: 
 <pre> 
 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> 
 } 
 </pre> 

 Then: 

 <pre> 
 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> 
 } 
 </pre>

Back