Project

General

Profile

Actions

Feature #4816

open

Templates for QFQ Reports (Tables, Radios, ..)

Added by Benjamin Baer over 6 years ago. Updated about 4 years ago.

Status:
Some day maybe
Priority:
Normal
Assignee:
-
Target version:
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
}

Actions #1

Updated by Benjamin Baer over 6 years ago

  • Description updated (diff)
Actions #2

Updated by Benjamin Baer over 6 years ago

  • Description updated (diff)
Actions #3

Updated by Benjamin Baer about 6 years ago

  • Subject changed from Templates for Tables to Templates for QFQ Reports (Tables, Radios, ..)
Actions #4

Updated by Carsten Rose almost 6 years ago

  • Target version set to next7
Actions #5

Updated by Carsten Rose over 5 years ago

  • Tracker changed from Support to Feature
Actions #6

Updated by Carsten Rose over 4 years ago

  • Status changed from New to Some day maybe
Actions #7

Updated by Carsten Rose about 4 years ago

  • Target version changed from next7 to next9
Actions

Also available in: Atom PDF