Wiki source code of Talks per Category

Hide line numbers
  1: #includeMacros("Main.MacroSheet")
  2: #includeMacros("Talks.MacroSheet")
  3: #includeMacros("People.MacroSheet")
  4: 
  5: #### Setting author variables
  6: ##
  7: ## Two ways of asking for an author: using "authuser='APICEusername'", or "authname='AuthorName' & authsurname='AuthorSurname'"
  8: ##
  9: #set($userNamePar = $context.getRequest().getParameter("user"))
 10: #set($firstNamePar = $context.getRequest().getParameter("name"))
 11: #set($lastNamePar = $context.getRequest().getParameter("surname"))
 12: ##
 13: ## Set the full APICE user name of the Author required, if any
 14: ## in the $userNameFull variable
 15: ##
 16: #set( $userNameFull = "" ) ## initialisation
 17: ##
 18: ## if variable $userName is set, ignore parameters, otherwise get $userNameFull from them, if any
 19: ##
 20: #if($userName)
 21: 	#set($userNameFull = "#userXWiki($userName)") 
 22: #else
 23:   #if($userNamePar)
 24: 	#set($userNameFull = "#userXWiki($userNamePar)") 
 25:   #end
 26: #end
 27: ##
 28: ## if $userNameFull is not empty, or $firstNamePar & $lastNamePar are set, select just one author's talks
 29: ## if $userNameFull is not empty, the author is an APICe user, otherwise it is supposed to be an external author
 30: ##
 31: #set($oneAuthor = false)
 32: ##
 33: #if($userNameFull != "") 
 34: 	#set($oneAuthor = true)		## just one author
 35: 	#set($apiceAuthor = true)	## APICe author
 36: 	##
 37: 	#set($userdoc = $xwiki.getDocument($userNameFull))
 38: 	#set($authorFirstName = $userdoc.display("first_name"))
 39: 	#set($authorLastName = $userdoc.display("last_name"))
 40: #else
 41: 	#if($firstNamePar && $lastNamePar)
 42: 		#set($oneAuthor = true)		## just one author
 43: 		#set($apiceAuthor = false)	## non APICe author
 44: 		##
 45: 		#set($authorFirstName = $firstNamePar)
 46: 		#set($authorLastName = $lastNamePar)
 47: 	#end
 48: #end
 49: 
 50: #### Setting category variables
 51: ##
 52: #set($categoryRange = ['Talk','Invited','Seminar','Lecture','Tutorial','Project','Informal','Internal','PhD','Poster','Other'])
 53: ##
 54: #set($oneCategory = false)
 55: ##
 56: #set($categoryPar = $context.getRequest().getParameter("category"))
 57: ## 
 58: #if(!$categoryPar || $categoryPar.toLowerCase() =="all")
 59:   #set($categoryList = $categoryRange)
 60: #else
 61:   #if ($categoryRange.contains($categoryPar) )
 62:       #set($categoryList = [$categoryPar])
 63:       #set($oneCategory = true)
 64:   #end
 65: #end
 66: 
 67: #### Preparing the web page
 68: ##
 69: ## top anchor
 70: <a name="top"> </a>
 71: ##
 72: ## Page title
 73: ##
 74: #if($oneAuthor) 
 75: #if ($context.language=="it")
 76: 1 #if ($oneCategory) #talkCategoriesString($categoryPar) #else Presentazioni #end di $authorFirstName $authorLastName #if (!$oneCategory) per tipo #end 
 77: #else
 78: 1 #if ($oneCategory) #talkCategoriesString($categoryPar) #else Talks #end by $authorFirstName $authorLastName #if (!$oneCategory) by Category #end 
 79: #end
 80: #else
 81: #if ($context.language=="it")
 82: 1 #if ($oneCategory) #talkCategoriesString($categoryPar) #else Presentazioni #end nello spazio #apice() #if (!$oneCategory) per tipo #end
 83: #else
 84: 1 #if ($oneCategory) #talkCategoriesString($categoryPar) #else Talks #end in the #apice() Space #if (!$oneCategory) by Category #end
 85: #end
 86: #end
 87: 
 88: ##
 89: ## Page text
 90: ##
 91: #if (!$oneCategory)
 92: #if ($context.language=="it")
 93: Di seguito, le presentazioni #if($oneAuthor) di $authorFirstName $authorLastName #else nello spazio #apice() #end ordinate per tipo.
 94: ----
 95: #else
 96: Below, the talks #if($oneAuthor) by $authorFirstName $authorLastName #else in the #apice() space #end ordered by category.
 97: ----
 98: #end
 99: ##
100: ## Page index
101: ##
102: <div>
103: #foreach ($category in $categoryList)
104: 	#if ($velocityCount > 1) | #end [#talkCategoriesString($category) |#$category]
105: #end
106: </div>
107: ----
108: #end
109: ##
110: ## Document queries, one for each category
111: ##
112: #foreach ($category in $categoryList)
113: 	#if($oneAuthor) 
114: 		#if($apiceAuthor)	## one APICe author
115: 			#set ($sql = ", BaseObject as obj, DateProperty as prop, LargeStringProperty as prop1, StringProperty as prop2
116: 			where 
117: 				obj.name=doc.fullName and
118: 				obj.className='Talks.TalkClass' and
119: 				obj.name<>'Talks.TalkClassTemplate' and
120: 				prop.id.id=obj.id and
121: 				prop1.id.id=obj.id and
122: 				prop2.id.id=obj.id and 
123: 				prop.name='date' and 
124: 				prop1.name='authors' and 
125: 				prop1.value like '%$userNameFull%' and
126: 				prop2.name='category' and 
127: 				prop2.value='$category'
128:     		order by prop.value desc")
129:     	#else	## one non APICe author
130:  			#set ($sql = ", BaseObject as obj, DateProperty as prop, StringProperty as prop1, StringProperty as prop2
131: 			where 
132:     			obj.name=doc.fullName and 
133:     			obj.className='Talks.TalkClass' and 
134:     			obj.name<>'Talks.TalkClassTemplate' and 
135:     			prop.id.id=obj.id and
136:     			prop1.id.id=obj.id and
137:     			prop2.id.id=obj.id and 
138:     			prop.name='date' and 
139:     			prop1.name='externalAuthors' and 
140:     			prop1.value like '%$authorLastName, $authorFirstName%' and
141:     			prop2.name='category' and 
142:     			prop2.value='$category'
143:     		order by prop.value desc")
144:     	#end
145:     #else 	##all authors
146: 			#set ($sql = ", BaseObject as obj, DateProperty as prop, StringProperty as prop1
147: 			where 
148:     			obj.name=doc.fullName and 
149:     			obj.className='Talks.TalkClass' and  
150:     			obj.name<>'Talks.TalkClassTemplate' and 
151:     			prop.id.id=obj.id and
152:     			prop1.id.id=obj.id and 
153:     			prop.name='date' and 
154:     			prop1.name='category' and 
155:     			prop1.value='$category'
156:     		order by prop.value desc")
157:     #end
158:     ##
159:     #set($talkFound = $xwiki.searchDocuments($sql))
160:     ##
161:     #if ($talkFound.size() > 0)
162:     	#if (!$oneCategory)
163:     	##
164: <a name='$category' > </a>
165: 1.1 #talkCategoriesString($category)
166: 
167: 		##
168:     	#end
169:     	#foreach ($talk in $talkFound)
170:     	##
171: * #talkTDASInline($talk) 
172: 
173:     	##
174:     	#end
175:     #end
176: #end
Wiki source code of Talks per Category

Talks

Users

Views

Indexes

Other
