Project

General

Profile

Feature #4816

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

Added by Benjamin Baer over 2 years ago. Updated 4 months ago.

Status:
Some day maybe
Priority:
Normal
Assignee:
-
Target version:
Start date:
25.10.2017
Due date:
% Done:

0%

Estimated time:
Discuss:

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
}

History

#1 Updated by Benjamin Baer over 2 years ago

  • Description updated (diff)

#2 Updated by Benjamin Baer over 2 years ago

  • Description updated (diff)

#3 Updated by Benjamin Baer over 2 years ago

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

#4 Updated by Carsten Rose about 2 years ago

  • Target version set to next2

#5 Updated by Carsten Rose over 1 year ago

  • Tracker changed from Support to Feature

#6 Updated by Carsten Rose 6 months ago

  • Status changed from New to Some day maybe

#7 Updated by Carsten Rose 4 months ago

  • Target version changed from next2 to next4

Also available in: Atom PDF