Code source wiki de Predoctoral staff: historical record
Modifié par Ricardo Julio Rodríguez Fernández le 2025/07/12 23:01
Masquer les derniers auteurs
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | {{groovy}} |
| 2 | import groovy.sql.Sql | ||
| 3 | |||
| |
54.1 | 4 | def sql = new Sql(services.igfaebbdddummy.getConnection()) |
| |
40.1 | 5 | println "(% class='doOddEven filterable grid sortable' id='tableid' %)" |
| |
71.1 | 6 | println "(% class='sortHeader' %)|=n|=Pid|= Surname|= Name|= Category" |
| |
18.2 | 7 | sql.execute "SET @row_number = 0" |
| |
71.1 | 8 | sql.rows("SELECT (@row_number:=@row_number + 1) AS n,PersonnelID,Surname,Name,CASE WHEN Category LIKE '%management%' THEN 'Rm&T staff' ELSE Category END AS Category FROM IGFAE_Personnel ORDER BY RAND() LIMIT 10").each{ |
| 9 | println "|${it.n}|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" | ||
| |
1.1 | 10 | } |
| 11 | sql.close() | ||
| 12 | |||
| 13 | {{/groovy}} |