Changes for page Predoctoral staff: historical record

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -3,10 +3,10 @@
3	3
4	4	def sql = new Sql(services.igfaebbdddummy.getConnection())
5	5	println "(% class='doOddEven filterable grid sortable' id='tableid' %)"
6		- println "(% class='sortHeader' %)|= n|= FirstSurname|= SecondSurname|= Name|= IDCard|= StartDate|= EndDate|= Name"
	6	+ println "(% class='sortHeader' %)|= n|= FirstSurname|= SecondSurname|= Name|= StartDate|= EndDate|= Name"
7	7	sql.execute "SET @row_number = 0"
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}"
	8	+ sql.rows("SELECT (@row_number:=@row_number + 1) AS n,P.FirstSurname,P.SecondSurname,P.Name,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.FirstSurname REGEXP 'Borsato|Alejo|Calderón|Fariña')) order by PC.StartDate,C.Name,FirstSurname").each{
	9	+ println "|${it.n}|${it.FirstSurname}|${it.SecondSurname}|${it.Name}|${it.StartDate}|${it.EndDate}|${it.Name}"
10	10	}
11	11	sql.close()
12	12