Wiki source code of Predoctoral staff
Version 59.1 by Ricardo Julio Rodríguez Fernández on 2025/07/12 23:12
Hide last authors
| 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' %)" |
| 6 | println "(% class='sortHeader' %)|=n|=Pid|= Surname|= Name|= Category" | ||
| |
18.2 | 7 | sql.execute "SET @row_number = 0" |
| |
59.1 | 8 | sql.rows("SELECT (@row_number:=@row_number + 1) AS n,P.FirstSurname,P.SecondSurname,P.Name,P.IDCard,PC.StartDate,PC.EndDate,C.Name FROM Personnel AS P NATURAL JOIN PersonnelContract AS PC JOIN Contract AS C ON (PC.ContractID=C.ContractID) WHERE (C.Name REGEXP 'predoc X|FPI|FPU|Caixa' AND NOT(C.Name REGEXP 'ext') AND NOT(P.IDCard REGEXP 'Y6681655P|44090923S|12420839B|77409868X')) order by PC.StartDate,C.Name,FirstSurname").each{ |
| 9 | println "|${it.n}|${it.FirstSurname}|${it.SecondSurname}|${it.Name}|${it.IDCard}|${it.StartDate}|${it.EndDate}|${it.Name}" | ||
| |
1.1 | 10 | } |
| 11 | sql.close() | ||
| 12 | |||
| 13 | {{/groovy}} |