FicheCollegev2.xslt 56 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  3. <xsl:decimal-format name="europe" decimal-separator=',' grouping-separator='.' />
  4. <xsl:output method="xml" encoding="UTF-8" omit-xml-declaration="yes" />
  5. <xsl:template match="college">
  6. <div id="conteneur">
  7. <img id="logo" src="images/bandeau-fiche-college.png" alt="Logo du CD67"></img>
  8. <div id="header_fiche">
  9. <div id="entete_fiche">
  10. <h1 id="fiche">
  11. <!-- <xsl:value-of select="Etablissement/NomCollegePourPresentation"/> -->
  12. <xsl:variable name="fullNom" select="Etablissement/NomCollegePourPresentation" />
  13. <xsl:variable name="ville" select="substring-before($fullNom,' - ')" />
  14. <xsl:value-of select="$ville"/>
  15. <br />
  16. <xsl:variable name="college" select="substring-after($fullNom, ' - ')" />
  17. <xsl:value-of select="$college" />
  18. </h1>
  19. <div id="coordonnees_college">
  20. <xsl:value-of select="Etablissement/Adresse"/>
  21. <xsl:text> </xsl:text>
  22. <xsl:value-of select="Etablissement/ComplementAdresse"/>
  23. <xsl:text> </xsl:text>
  24. <xsl:value-of select="Etablissement/CodePostal"/>
  25. <xsl:text> </xsl:text>
  26. <xsl:value-of select="Etablissement/Ville"/>
  27. <br/>
  28. <xsl:text>Tél : </xsl:text>
  29. <a href="tel:{Etablissement/Telephone}"/>
  30. <xsl:value-of select="Etablissement/Telephone"/>
  31. <a/>
  32. <xsl:text> Fax : </xsl:text>
  33. <a href="tel:{Etablissement/Fax}"/>
  34. <xsl:value-of select="Etablissement/Fax"/>
  35. <a/>
  36. <br/>
  37. <xsl:text>Email : </xsl:text>
  38. <a href="mailto:{Etablissement/Email}">
  39. <xsl:value-of select="Etablissement/Email"/>
  40. </a>
  41. </div>
  42. </div>
  43. </div>
  44. <div id="photo">
  45. <xsl:if test ="Etablissement/LienPhoto !=''">
  46. <img id="photo_college" alt="Photo du collège" width="500px">
  47. <xsl:attribute name="src">
  48. photo/<xsl:value-of select="Etablissement/LienPhoto"/>
  49. </xsl:attribute>
  50. </img>
  51. </xsl:if>
  52. </div>
  53. <div id="info_fiche">
  54. <h2>1. Fiche d'identité du collège</h2>
  55. <table>
  56. <colgroup>
  57. <col class="libelle"></col>
  58. <col class="information"></col>
  59. </colgroup>
  60. <tr>
  61. <td class="td_head">Code RNE du collège</td>
  62. <td>
  63. <xsl:value-of select="Etablissement/CodeRNE"/>
  64. </td>
  65. </tr>
  66. <tr>
  67. <td class="td_head">Type d'établissement</td>
  68. <td>
  69. <table>
  70. <colgroup>
  71. <col class="typeCollege"></col>
  72. <col class="public"></col>
  73. </colgroup>
  74. <tr>
  75. <xsl:value-of select="Etablissement/TypeEtablissement"/>
  76. <xsl:if test ="Etablissement/IsPrive='True'">
  77. privé
  78. </xsl:if>
  79. <xsl:if test ="Etablissement/IsPrive='False'">
  80. public
  81. </xsl:if>
  82. <xsl:if test ="Etablissement/DispositifEtablissement='2'">
  83. REP
  84. </xsl:if>
  85. <xsl:if test ="Etablissement/DispositifEtablissement='3'">
  86. REP+
  87. </xsl:if>
  88. </tr>
  89. </table>
  90. </td>
  91. </tr>
  92. <table>
  93. <colgroup>
  94. <col class="libelle"></col>
  95. <col class="information"></col>
  96. </colgroup>
  97. <tr>
  98. <xsl:if test ="Etablissement/CodeRNE!='0673079H'">
  99. <td class="td_head">Principal</td>
  100. </xsl:if>
  101. <xsl:if test ="Etablissement/CodeRNE='0673079H'">
  102. <td class="td_head">Directeur</td>
  103. </xsl:if>
  104. <td>
  105. <xsl:value-of select="Etablissement/Principal"></xsl:value-of>
  106. <br>
  107. <xsl:text>Email </xsl:text>
  108. <a href="mailto:{Etablissement/PrincipalEmail}">
  109. <xsl:value-of select="Etablissement/PrincipalEmail"/>
  110. </a>
  111. </br>
  112. </td>
  113. </tr>
  114. <tr>
  115. <xsl:if test ="Etablissement/CodeRNE!='0673079H'">
  116. <td class="td_head">Principal Adjoint</td>
  117. </xsl:if>
  118. <xsl:if test ="Etablissement/CodeRNE='0673079H'">
  119. <td class="td_head">Directeur adjoint secondaire</td>
  120. </xsl:if>
  121. <td>
  122. <xsl:if test ="Etablissement/PrincipalAdjoint!=''">
  123. <xsl:value-of select="Etablissement/PrincipalAdjoint"></xsl:value-of>
  124. <br>
  125. <xsl:text>Email </xsl:text>
  126. <a href="mailto:{Etablissement/PrincipalAdjointEmail}">
  127. <xsl:value-of select="Etablissement/PrincipalAdjointEmail"/>
  128. </a>
  129. </br>
  130. </xsl:if>
  131. <xsl:if test ="Etablissement/PrincipalAdjoint=''">
  132. </xsl:if>
  133. </td>
  134. </tr>
  135. <tr>
  136. <td class="td_head">Gestionnaire</td>
  137. <td>
  138. <xsl:value-of select="Etablissement/Gestionnaire"></xsl:value-of>
  139. <br>
  140. <xsl:text>Email </xsl:text>
  141. <a href="mailto:{Etablissement/GestionnaireEmail}">
  142. <xsl:value-of select="Etablissement/GestionnaireEmail"/>
  143. </a>
  144. </br>
  145. </td>
  146. </tr>
  147. <xsl:if test ="Etablissement/Gestionnaire2!=''">
  148. <tr>
  149. <td class="td_head">Gestionnaire 2</td>
  150. <td>
  151. <xsl:value-of select="Etablissement/Gestionnaire2"></xsl:value-of>
  152. <br>
  153. <xsl:text>Email </xsl:text>
  154. <a href="mailto:{Etablissement/Gestionnaire2Email}">
  155. <xsl:value-of select="Etablissement/Gestionnaire2Email"/>
  156. </a>
  157. </br>
  158. </td>
  159. </tr>
  160. </xsl:if>
  161. <tr>
  162. <td class="td_head">Conseillers Départementaux siégeant au CA </td>
  163. <td>
  164. <xsl:if test ="Etablissement/ConseillerGeneral!=''">
  165. <xsl:value-of select="Etablissement/ConseillerGeneral"></xsl:value-of>
  166. </xsl:if>
  167. <xsl:if test ="Etablissement/ConseillerGeneral=''">
  168. <!-- Vacant -->
  169. </xsl:if>
  170. <xsl:if test ="Etablissement/ConseillerGeneralSuppleant!=''">
  171. <xsl:text> - </xsl:text>
  172. <xsl:value-of select="Etablissement/ConseillerGeneralSuppleant"></xsl:value-of>
  173. </xsl:if>
  174. <xsl:if test ="Etablissement/ConseillerGeneralSuppleant=''">
  175. <!-- Vacant -->
  176. </xsl:if>
  177. <!-- <xsl:if test="count(Etablissement/LstCanton/Canton[Fonction = '6']) =0">
  178. Vacant
  179. </xsl:if>
  180. <xsl:if test="count(Etablissement/LstCanton/Canton[Fonction = '6']) >0">
  181. <xsl:for-each select="Etablissement/LstCanton/Canton[Fonction = '6']">
  182. <xsl:value-of select="Civilite"/>
  183. <xsl:text> </xsl:text>
  184. <xsl:value-of select="PrenomConseiller"/>
  185. <xsl:text> </xsl:text>
  186. <xsl:value-of select="NomConseiller"/>
  187. <xsl:text> - </xsl:text>
  188. </xsl:for-each>
  189. </xsl:if> -->
  190. </td>
  191. </tr>
  192. <!-- <tr>
  193. <td class="td_head">Conseillers Départementaux suppléants</td>
  194. <td>
  195. <xsl:if test ="Etablissement/ConseillerGeneralSuppleant!=''">
  196. <xsl:value-of select="Etablissement/ConseillerGeneralSuppleant"></xsl:value-of>
  197. </xsl:if>
  198. <xsl:if test ="Etablissement/ConseillerGeneralSuppleant=''">
  199. Vacant
  200. </xsl:if>
  201. <xsl:if test="count(Etablissement/LstCanton/Canton[Fonction = '91']) =0">
  202. Vacant
  203. </xsl:if>
  204. <xsl:if test="count(Etablissement/LstCanton/Canton[Fonction = '91']) >0">
  205. <xsl:for-each select="Etablissement/LstCanton/Canton[Fonction = '91']">
  206. <xsl:value-of select="Civilite"/>
  207. <xsl:text> </xsl:text>
  208. <xsl:value-of select="PrenomConseiller"/>
  209. <xsl:text> </xsl:text>
  210. <xsl:value-of select="NomConseiller"/>
  211. <xsl:text> - </xsl:text>
  212. </xsl:for-each>
  213. </xsl:if>
  214. </td>
  215. </tr>
  216. -->
  217. </table>
  218. <table>
  219. <colgroup>
  220. <col class="libelle"></col>
  221. <col class="information"></col>
  222. </colgroup>
  223. <tr>
  224. <td class="td_head">
  225. Territoire de rattachement et<br/>Délégué de la Direction Générale (DDG)
  226. </td>
  227. <td>
  228. <xsl:value-of select="Etablissement/MCG/Ville"/>
  229. <br/>
  230. <xsl:value-of select="Etablissement/MCG/NomPresident"/>
  231. <xsl:text> </xsl:text>
  232. <xsl:value-of select="Etablissement/MCG/PrenomPresident"/>
  233. </td>
  234. </tr>
  235. <tr>
  236. <td class="td_head">
  237. Référent MESJ
  238. </td>
  239. <td>
  240. <xsl:value-of select="Etablissement/MCG/NomReferentPEP"/>
  241. <xsl:text> </xsl:text>
  242. <xsl:value-of select="Etablissement/MCG/PrenomReferentPEP"/>
  243. </td>
  244. </tr>
  245. <tr>
  246. <td class="td_head">
  247. Canton de rattachement
  248. </td>
  249. <td>
  250. <xsl:if test="count(Etablissement/LstCanton/child::*) >0">
  251. <xsl:value-of select="Etablissement/LstCanton/Canton/NomCanton"/>
  252. </xsl:if>
  253. </td>
  254. </tr>
  255. <tr>
  256. <td class="td_head">Effectifs</td>
  257. <xsl:if test="count(Etablissement/LstEffectifDetail/child::*)=1">
  258. <td>
  259. <xsl:value-of select="Etablissement/Effectif"/>
  260. </td>
  261. </xsl:if>
  262. <xsl:if test="count(Etablissement/LstEffectifDetail/child::*)>1">
  263. <td>
  264. <table>
  265. <colgroup>
  266. <col class="titre"></col>
  267. <col class="totaleffectif"></col>
  268. <col class="colonnevide"></col>
  269. </colgroup>
  270. <xsl:for-each select="Etablissement/LstEffectifDetail/EffectifDetail">
  271. <tr>
  272. <td class="sansbordure">
  273. <xsl:value-of select="Filiere"/>
  274. </td>
  275. <td class="sansborduredroite">
  276. <xsl:value-of select="DetailEffectif"/>
  277. </td>
  278. <td class="sansbordure"></td>
  279. </tr>
  280. </xsl:for-each>
  281. <tr>
  282. <td class="totalsansbordure">
  283. Nombre d'élèves
  284. </td>
  285. <td class="totalbordure">
  286. <xsl:value-of select="sum(Etablissement/LstEffectifDetail/EffectifDetail/DetailEffectif)"/>
  287. </td>
  288. </tr>
  289. </table>
  290. </td>
  291. </xsl:if>
  292. </tr>
  293. <tr>
  294. <td class="td_head">dont effectif bilingue</td>
  295. <td>
  296. <xsl:if test ="count(Etablissement/LstBilingue/Bilinguisme)=0">
  297. Non
  298. </xsl:if>
  299. <xsl:if test ="count(Etablissement/LstBilingue/Bilinguisme)!=0">
  300. <table>
  301. <colgroup>
  302. <col class="classe"></col>
  303. <col class="nbEleves"></col>
  304. <col class="vide"></col>
  305. </colgroup>
  306. <xsl:for-each select="Etablissement/LstBilingue/Bilinguisme">
  307. <tr>
  308. <td class="sansbordure">
  309. <xsl:text> Classe de </xsl:text>
  310. <xsl:value-of select="Niveaux"/>
  311. </td>
  312. <td class="sansborduredroite">
  313. <xsl:value-of select ="NbrEleves"/>
  314. <xsl:text> élèves</xsl:text>
  315. </td>
  316. <td class="sansbordure"></td>
  317. </tr>
  318. </xsl:for-each>
  319. <tr>
  320. <td class="totalsansbordure">
  321. Effectif total
  322. </td>
  323. <td class="totalbordure">
  324. <xsl:value-of select="sum(Etablissement/LstBilingue/Bilinguisme/NbrEleves)"/>
  325. <xsl:text> élèves</xsl:text>
  326. </td>
  327. <td class="sansbordure"></td>
  328. </tr>
  329. </table>
  330. </xsl:if>
  331. </td>
  332. </tr>
  333. </table>
  334. <tr>
  335. <h2>2. Restauration</h2>
  336. <td>
  337. <table>
  338. <colgroup>
  339. <col class="libelle"></col>
  340. <col class="information"></col>
  341. </colgroup>
  342. <xsl:if test ="Etablissement/Restauration/NbrRepas > 0">
  343. <td class="td_head">Nombre moyen de repas par jour</td>
  344. <td>
  345. <!--<xsl:value-of select="format-number((Etablissement/Restauration/NbrRepas div 140),'###.##0','europe')"></xsl:value-of>-->
  346. <xsl:value-of select="format-number((Etablissement/Restauration/NbrRepas div Etablissement/Restauration/NbrRepasJourRestauration),'###.##0','europe')"></xsl:value-of>
  347. </td>
  348. </xsl:if>
  349. <xsl:if test ="Etablissement/Restauration/NbrRepas = 0">
  350. <td class="td_head">Nombre moyen de repas par jour</td>
  351. <td> </td>
  352. </xsl:if>
  353. <xsl:if test ="Etablissement/Restauration/NbrRepas > 0">
  354. <tr>
  355. <td class="td_head">Nombre de repas annuel</td>
  356. <td>
  357. <xsl:value-of select="format-number(Etablissement/Restauration/NbrRepas,'###.##0','europe')"></xsl:value-of>
  358. </td>
  359. </tr>
  360. </xsl:if>
  361. <xsl:if test ="Etablissement/Restauration/Production='True'">
  362. <tr>
  363. <td class="td_head">Production</td>
  364. <td>Oui</td>
  365. </tr>
  366. </xsl:if>
  367. <xsl:if test ="Etablissement/Restauration/Production='False'">
  368. <tr>
  369. <td class="td_head">Production</td>
  370. <td>Non</td>
  371. </tr>
  372. </xsl:if>
  373. <xsl:if test ="Etablissement/Restauration/DélégationSP != ''">
  374. <tr>
  375. <td class="td_head">Délégation de service public</td>
  376. <td>
  377. <xsl:value-of select="Etablissement/Restauration/DélégationSP"></xsl:value-of>
  378. </td>
  379. </tr>
  380. </xsl:if>
  381. <xsl:if test ="Etablissement/Restauration/Heberge != ''">
  382. <tr>
  383. <td class="td_head">Etablissements hébergés</td>
  384. <td>
  385. <xsl:value-of select="Etablissement/Restauration/Heberge"></xsl:value-of>
  386. </td>
  387. </tr>
  388. </xsl:if>
  389. <xsl:if test ="Etablissement/Restauration/EstHebergePar != ''">
  390. <tr>
  391. <td class="td_head">Hébergé par</td>
  392. <td>
  393. <xsl:value-of select="Etablissement/Restauration/EstHebergePar"></xsl:value-of>
  394. </td>
  395. </tr>
  396. </xsl:if>
  397. <xsl:if test ="Etablissement/Restauration/Telerestaure != ''">
  398. <tr>
  399. <td class="td_head">Etablissements télérestaurés</td>
  400. <td>
  401. <xsl:value-of select="Etablissement/Restauration/Telerestaure"></xsl:value-of>
  402. </td>
  403. </tr>
  404. </xsl:if>
  405. <xsl:if test ="Etablissement/Restauration/EstTelerestaurePar != ''">
  406. <tr>
  407. <td class="td_head">Est télérestauré par</td>
  408. <td>
  409. <xsl:value-of select="Etablissement/Restauration/EstTelerestaurePar"></xsl:value-of>
  410. </td>
  411. </tr>
  412. </xsl:if>
  413. </table>
  414. </td>
  415. </tr>
  416. </table>
  417. <h2>3. Structure Immobilière</h2>
  418. <table>
  419. <colgroup>
  420. <col class="libelle"></col>
  421. <col class="information"></col>
  422. </colgroup>
  423. <tr>
  424. <td class="td_head">Propriétaire</td>
  425. <td>
  426. <xsl:value-of select="Etablissement/NomProprietaire"/>
  427. </td>
  428. </tr>
  429. <tr>
  430. <td class="td_head">Année de construction</td>
  431. <td>
  432. <xsl:value-of select="Etablissement/AnneeConstruction"/>
  433. </td>
  434. </tr>
  435. <tr>
  436. <td class="td_head">Année de restructuration lourde</td>
  437. <td>
  438. <xsl:value-of select="Etablissement/PhraseRestructuration"/>
  439. </td>
  440. </tr>
  441. <tr>
  442. <td class="td_head">Surface</td>
  443. <td>
  444. <xsl:value-of select="format-number(Etablissement/Surface,'###.##0','europe')"/> m2
  445. </td>
  446. </tr>
  447. <!--
  448. <tr>
  449. <td>Aménagements particuliers</td>
  450. <td>
  451. <xsl:value-of select="Etablissement/CommentaireAmenagementParticulier"/> m2
  452. </td>
  453. </tr>
  454. -->
  455. <tr>
  456. <td class="td_head">Logements de fonction</td>
  457. <td>
  458. <xsl:text>Nombre de logements </xsl:text><xsl:value-of select="Etablissement/Logement/NbrLogements"/>
  459. <xsl:text> dont </xsl:text>
  460. <xsl:value-of select="Etablissement/Logement/NbrAgentsLoges"/> agent(s) du CD logé(s)
  461. </td>
  462. </tr>
  463. <tr>
  464. <td class="td_head">Internat</td>
  465. <td>
  466. <xsl:if test ="Etablissement/IsInternat='True'">
  467. Oui
  468. </xsl:if>
  469. <xsl:if test ="Etablissement/IsInternat='False'">
  470. Non
  471. </xsl:if>
  472. </td>
  473. </tr>
  474. <!--<tr>
  475. <td class="td_head">Ascensseur</td>
  476. <td>
  477. <xsl:if test ="Etablissement/Ascenseur='True'">
  478. Oui
  479. </xsl:if>
  480. <xsl:if test ="Etablissement/Ascenseur='False'">
  481. Non
  482. </xsl:if>
  483. </td>
  484. </tr>-->
  485. <tr>
  486. <td class="td_head">Accessibilité</td>
  487. <td>
  488. <xsl:if test ="Etablissement/Accessibilite=0">
  489. Pas d’accès
  490. </xsl:if>
  491. <xsl:if test ="Etablissement/Accessibilite=1">
  492. Accès partiel
  493. </xsl:if>
  494. <xsl:if test ="Etablissement/Accessibilite=2">
  495. Accès complet
  496. </xsl:if>
  497. </td>
  498. </tr>
  499. <tr>
  500. <table>
  501. <br></br>
  502. <h3>Restructuration lourde </h3>
  503. </table>
  504. </tr>
  505. <xsl:if test="count(Etablissement/LstInvestissement/child::*) >0">
  506. <table id="restructuration">
  507. <colgroup>
  508. <col class="travannee"></col>
  509. <col class="typetravaux"></col>
  510. <col class="libellerestruct"></col>
  511. <col class="llibellerestruct"></col>
  512. <col class="travmontant"></col>
  513. <col class="travmontant"></col>
  514. <col class="travmontant"></col>
  515. <col class="travmontant"></col>
  516. </colgroup>
  517. <tr>
  518. <th class="bordurecentre">Année</th>
  519. <th class="bordurecentre">Type d'opération</th>
  520. <th class="bordurecentre">Stade d'avancement</th>
  521. <th class="bordurecentre">Prévu année n+1</th>
  522. <th class="bordurecentre">Coût de l'opération en €</th>
  523. <th class="bordurecentre">Montant CP en €</th>
  524. <th class="bordurecentre">Statut</th>
  525. <th class="bordurecentre">Date de livraison</th>
  526. </tr>
  527. <xsl:for-each select="Etablissement/LstInvestissement/Investissement">
  528. <tr>
  529. <td class="bordure">
  530. <xsl:value-of select="Annee"/>
  531. </td>
  532. <td class="bordure">
  533. <xsl:value-of select="Type"/>
  534. </td>
  535. <td class="bordure">
  536. <xsl:value-of select ="Avancement"/>
  537. </td>
  538. <td class="bordure">
  539. <xsl:value-of select="Commentaire"/>
  540. </td>
  541. <td class="bordure">
  542. <xsl:value-of select="format-number(MontantOp,'###.###.##0','europe')"/>
  543. </td>
  544. <td class="bordure">
  545. <xsl:value-of select="format-number(MontantCP,'###.###.##0','europe')"/>
  546. </td>
  547. <td class="bordure">
  548. <xsl:value-of select="Status"/>
  549. </td>
  550. <td class="bordure">
  551. <xsl:value-of select="DateLivraison"/>
  552. </td>
  553. </tr>
  554. </xsl:for-each>
  555. </table>
  556. </xsl:if>
  557. <xsl:if test="count(Etablissement/LstInvestissement/child::*)=0">
  558. Néant
  559. </xsl:if>
  560. <tr>
  561. <table>
  562. <br></br>
  563. <h3>Travaux de maintenance réalisés et prévus</h3>
  564. </table>
  565. <xsl:if test="count(Etablissement/LstFichiersTravaux/child::*)>0">
  566. <xsl:for-each select="Etablissement/LstFichiersTravaux/FichierTravaux">
  567. veuillez cliquer sur ce
  568. <!--<a href="file.download?file={Fichier}">-->
  569. <!--<a href="/FichiersPPM/{Fichier}"> -->
  570. <a href="/FichiersPPM/{Fichier}">
  571. lien
  572. </a>
  573. <br></br>
  574. </xsl:for-each>
  575. </xsl:if>
  576. <xsl:if test="count(Etablissement/LstFichiersTravaux/child::*)=0">
  577. Néant
  578. </xsl:if>
  579. <!-- Données
  580. accessibles en Février 2014
  581. <br></br>
  582. <xsl:element name="a">
  583. <xsl:attribute name="href">
  584. ..\xls\<xsl:value-of select="Etablissement/LienFichier"/>
  585. </xsl:attribute>
  586. Plan pluriannuel de programmation des travaux de maintenance
  587. <xsl:value-of select="Etablissement/LienFichier"/>
  588. </xsl:element>
  589. <br></br>
  590. <td>
  591. <xsl:if test="count(Etablissement/LstTravaux/child::*) >0">
  592. <table id="travaux">
  593. <colgroup>
  594. <col class="travannee"></col>
  595. <col class="typetravaux"></col>
  596. <col class="travlibelle"></col>
  597. <col class="travmontant"></col>
  598. <col class="travstatus"></col>
  599. <col class="travimprevu"></col>
  600. </colgroup>
  601. <tr>
  602. <th class="bordurecentre">Année</th>
  603. <th class="bordurecentre">Type</th>
  604. <th class="bordurecentre">Libelle</th>
  605. <th class="bordurecentre">Montant</th>
  606. <th class="bordurecentre">Statut</th>
  607. <th class="bordurecentre">Prévu</th>
  608. </tr>
  609. <xsl:for-each select="Etablissement/LstTravaux/ProgTravaux">
  610. <tr>
  611. <td class="bordurecentre">
  612. <xsl:value-of select="Annee"/>
  613. </td>
  614. <td class="bordure">
  615. <xsl:value-of select="TypeOperation"/>
  616. </td>
  617. <td class="bordure">
  618. <xsl:value-of select ="Libelle"/>
  619. </td>
  620. <td class="borduredroite">
  621. <xsl:value-of select="Montant"/>
  622. <xsl:text> €</xsl:text>
  623. </td>
  624. <td class="bordurecentre">
  625. <xsl:value-of select="StatutOp"/>
  626. </td>
  627. <td class="bordurecentre">
  628. <xsl:if test ="PrevuOp= 0">
  629. Oui
  630. </xsl:if>
  631. <xsl:if test ="PrevuOp != 0">
  632. Non
  633. </xsl:if>
  634. </td>
  635. </tr>
  636. </xsl:for-each>
  637. </table>
  638. </xsl:if>
  639. <xsl:if test="count(Etablissement/LstTravaux/child::*) =0">
  640. Néant
  641. </xsl:if>
  642. </td> -->
  643. </tr>
  644. <tr>
  645. <br/>
  646. <td>
  647. <xsl:value-of select="Etablissement/CommentaireProgTravaux"/>
  648. </td>
  649. </tr>
  650. </table>
  651. <br></br>
  652. <h2>4. Sectorisation des collèges - évolution des effectifs</h2>
  653. <table>
  654. <colgroup>
  655. <col class="libelle"></col>
  656. <col class="information"></col>
  657. </colgroup>
  658. <tr>
  659. <td class="td_head">Secteur de recrutement</td>
  660. <td>
  661. <xsl:value-of select="Etablissement/PhraseSecteurRecrutement"/>
  662. </td>
  663. </tr>
  664. <tr>
  665. <td class="td_head">Prévisions sur les 5 prochaines années</td>
  666. <td>
  667. <xsl:value-of select="Etablissement/PhrasePrevision5Ans"></xsl:value-of>
  668. </td>
  669. </tr>
  670. <tr>
  671. <td class="td_head">Capacité Théorique </td>
  672. <td>
  673. <xsl:value-of select="Etablissement/EffectifTheorique"/>
  674. <xsl:text> élèves</xsl:text>
  675. </td>
  676. </tr>
  677. <tr>
  678. <table id="TitreGraph">
  679. <br></br>
  680. <tr>
  681. <h3 id="TitreGraph">
  682. <xsl:value-of select="Etablissement/Commentaires/TitreGraph"/>
  683. </h3>
  684. <!-- <h3>Effectifs réels et prévisionnels - inclus SEGPA, UPI, CLA, DIMA, 4e dispo aménagée ou 3e insertion</h3> -->
  685. </tr>
  686. </table>
  687. <br></br>
  688. <table id="sansbordurecentre">
  689. <td colspan="2" id="graphique">
  690. <xsl:apply-templates select="Etablissement/LstEffectif">
  691. <xsl:with-param name="capacitetheorique" select="Etablissement/EffectifTheorique" />
  692. </xsl:apply-templates>
  693. </td>
  694. </table>
  695. </tr>
  696. <tr>
  697. <td colspan="2">
  698. <!--<td>Observations sur le secteur de recrutement</td>-->
  699. <xsl:value-of select="Etablissement/CommentaireSecteurRecrutement"/>
  700. <br>
  701. <xsl:value-of select="Etablissement/CommentaireGraphique"/>
  702. </br>
  703. </td>
  704. </tr>
  705. </table>
  706. <h2>5. Financement du collège par le Département</h2>
  707. <table>
  708. <colgroup>
  709. <col class="libelle"></col>
  710. <col class="information"></col>
  711. </colgroup>
  712. <!--
  713. <tr>
  714. <td>Equipement en mobilier et matériel</td>
  715. <td>
  716. <ul>
  717. <xsl:for-each select ="Etablissement/lstEquipements/Equipement">
  718. <li>
  719. <xsl:value-of select="Phrase" />
  720. </li>
  721. </xsl:for-each>
  722. </ul>
  723. </td>
  724. </tr>
  725. -->
  726. <tr>
  727. <td class="td_head">Dotation annuelle de fonctionnement</td>
  728. <td>
  729. <table id="dotation">
  730. <colgroup>
  731. <col class="typedotation"></col>
  732. <col class="mtn"></col>
  733. <col class="mtn1"></col>
  734. <col class="ecart"></col>
  735. </colgroup>
  736. <tr>
  737. <th class="bordurecentre td_head">Type de dotation</th>
  738. <th class="bordurecentre td_head">
  739. <xsl:value-of select="Etablissement/Dotation[2]/Annee" />
  740. </th>
  741. <th class="bordurecentre td_head">
  742. <xsl:value-of select="Etablissement/Dotation[1]/Annee" />
  743. </th>
  744. <th class="bordurecentre td_head">Ecart</th>
  745. </tr>
  746. <tr>
  747. <td class="bordure">Viabilisation</td>
  748. <td class="bordure">
  749. <xsl:value-of select="format-number(Etablissement/Dotation[2]/Viabilisation,'###.###.##0','europe')" />
  750. <xsl:text> €</xsl:text>
  751. </td>
  752. <td class="bordure">
  753. <xsl:value-of select="format-number(Etablissement/Dotation[1]/Viabilisation,'###.###.##0','europe')" />
  754. <xsl:text> €</xsl:text>
  755. </td>
  756. <td class="bordure">
  757. <xsl:value-of select="format-number(Etablissement/Dotation[1]/Viabilisation+(-Etablissement/Dotation[2]/Viabilisation),'###.###.##0','europe')"/>
  758. <xsl:text> €</xsl:text>
  759. </td>
  760. </tr>
  761. <tr>
  762. <td class="bordure">Entretien</td>
  763. <td class="bordure">
  764. <xsl:value-of select="format-number(Etablissement/Dotation[2]/Entretien,'###.###.##0','europe')" />
  765. <xsl:text> €</xsl:text>
  766. </td>
  767. <td class="bordure">
  768. <xsl:value-of select="format-number(Etablissement/Dotation[1]/Entretien,'###.###.##0','europe')" />
  769. <xsl:text> €</xsl:text>
  770. </td>
  771. <td class="bordure">
  772. <xsl:value-of select="format-number(Etablissement/Dotation[1]/Entretien+(-Etablissement/Dotation[2]/Entretien),'###.###.##0','europe')"/>
  773. <xsl:text> €</xsl:text>
  774. </td>
  775. </tr>
  776. <tr>
  777. <td class="bordure">Autres Depenses</td>
  778. <td class="bordure">
  779. <xsl:value-of select="format-number(Etablissement/Dotation[2]/AutresDepenses,'###.###.##0','europe')" />
  780. <xsl:text> €</xsl:text>
  781. </td>
  782. <td class="bordure">
  783. <xsl:value-of select="format-number(Etablissement/Dotation[1]/AutresDepenses,'###.###.##0','europe')" />
  784. <xsl:text> €</xsl:text>
  785. </td>
  786. <td class="bordure">
  787. <xsl:value-of select="format-number(Etablissement/Dotation[1]/AutresDepenses+(-Etablissement/Dotation[2]/AutresDepenses),'###.###.##0','europe')"/>
  788. <xsl:text> €</xsl:text>
  789. </td>
  790. </tr>
  791. <tr>
  792. <td class="bordure">Total dotation</td>
  793. <td class="bordure">
  794. <xsl:value-of select="format-number((Etablissement/Dotation[2]/Viabilisation)+(Etablissement/Dotation[2]/Entretien)+(Etablissement/Dotation[2]/AutresDepenses),'###.###.##0','europe')" />
  795. <xsl:text> €</xsl:text>
  796. </td>
  797. <td class="bordure">
  798. <xsl:value-of select="format-number((Etablissement/Dotation[1]/Viabilisation)+(Etablissement/Dotation[1]/Entretien)+(Etablissement/Dotation[1]/AutresDepenses),'###.###.##0','europe')" />
  799. <xsl:text> €</xsl:text>
  800. </td>
  801. <td class="bordure">
  802. <xsl:value-of select="format-number(((Etablissement/Dotation[1]/Viabilisation)+(Etablissement/Dotation[1]/Entretien)+(Etablissement/Dotation[1]/AutresDepenses))-(((Etablissement/Dotation[2]/Viabilisation)+(Etablissement/Dotation[2]/Entretien)+(Etablissement/Dotation[2]/AutresDepenses))),'###.###.##0','europe')"/>
  803. <xsl:text> €</xsl:text>
  804. </td>
  805. </tr>
  806. </table>
  807. </td>
  808. </tr>
  809. <tr>
  810. <!--<xsl:if test ="count(Etablissement/LstInvestissementDCE[Annee=2011]/child::*)>0"> -->
  811. <xsl:variable name="annee" select="entete/chiffresgeneraux/annee">
  812. </xsl:variable>
  813. <xsl:if test ="count(Etablissement/LstInvestissementDCE/child::*[Annee=$annee])>0">
  814. <td class="td_head">
  815. <xsl:text >Autres subventions - Année </xsl:text>
  816. <xsl:value-of select="Etablissement/LstInvestissementDCE/InvestissementDCE/Annee"/>
  817. </td>
  818. </xsl:if>
  819. <td>
  820. <xsl:if test ="count(Etablissement/LstInvestissementDCE/child::*[Annee=$annee])>0">
  821. <table class="sanbordure">
  822. <colgroup>
  823. <col class="libInv"></col>
  824. <col class="espacevide"></col>
  825. <col class="nombre"></col>
  826. <col class="colonnevide"></col>
  827. </colgroup>
  828. <xsl:for-each select="Etablissement/LstInvestissementDCE/InvestissementDCE[Annee=$annee]">
  829. <tr>
  830. <td class="sansbordure">
  831. <xsl:value-of select="Libelle"/>
  832. </td>
  833. <td class="sansbordure"></td>
  834. <td class="sansborduredroite">
  835. <xsl:value-of select="format-number(Montant,'###.###.##0','europe')"/>
  836. <xsl:text> €</xsl:text>
  837. </td>
  838. <td class="sansbordure"></td>
  839. </tr>
  840. </xsl:for-each>
  841. <td class="totalsansbordure">Total dotation</td>
  842. <td class="sansbordure"></td>
  843. <td class="totalbordure">
  844. <xsl:value-of select="format-number(sum(Etablissement/LstInvestissementDCE/InvestissementDCE[Annee=$annee]/Montant),'###.###.##0','europe')" />
  845. <xsl:text> €</xsl:text>
  846. </td>
  847. </table>
  848. </xsl:if>
  849. </td>
  850. </tr>
  851. <tr>
  852. <xsl:variable name="anneePlus1">
  853. <xsl:value-of select="entete/chiffresgeneraux/annee + 1"/>
  854. </xsl:variable>
  855. <xsl:if test ="count(Etablissement/LstInvestissementDCE/child::*[Annee=$anneePlus1])>0">
  856. <td class="td_head">
  857. <xsl:text>Autres subventions - Annee </xsl:text>
  858. <xsl:value-of select="Etablissement/LstInvestissementDCE/InvestissementDCE[Annee=$anneePlus1]/Annee"/>
  859. </td>
  860. </xsl:if>
  861. <td>
  862. <xsl:if test ="count(Etablissement/LstInvestissementDCE/child::*[Annee=$anneePlus1])>0">
  863. <table class="sanbordure">
  864. <colgroup>
  865. <col class="libInv"></col>
  866. <col class="espacevide"></col>
  867. <col class="nombre"></col>
  868. <col class="colonnevide"></col>
  869. </colgroup>
  870. <xsl:for-each select="Etablissement/LstInvestissementDCE/InvestissementDCE[Annee=$anneePlus1]">
  871. <tr>
  872. <td class="sansbordure">
  873. <xsl:value-of select="Libelle"/>
  874. </td>
  875. <td class="sansbordure"></td>
  876. <td class="sansborduredroite">
  877. <xsl:value-of select="format-number(Montant,'###.###.##0','europe')"/>
  878. <xsl:text> €</xsl:text>
  879. </td>
  880. <td class="sansbordure"></td>
  881. </tr>
  882. </xsl:for-each>
  883. <td class="totalsansbordure">Total dotation</td>
  884. <td class="sansbordure"></td>
  885. <td class="totalbordure">
  886. <xsl:value-of select="format-number(sum(Etablissement/LstInvestissementDCE/InvestissementDCE[Annee=$anneePlus1]/Montant),'###.###.##0','europe')" />
  887. <xsl:text> €</xsl:text>
  888. </td>
  889. </table>
  890. </xsl:if>
  891. <!-- <xsl:if test ="count(Etablissement/LstInvestissementDCE/child::*[Annee=$anneePlus1])=0">
  892. pas de valeur
  893. </xsl:if> -->
  894. </td>
  895. </tr>
  896. <!--
  897. <tr>
  898. <td>Investissement sur 5 ans</td>
  899. <td>
  900. <xsl:if test ="count(Etablissement/LstInvestissement/Investissement)>0">
  901. <table>
  902. <xsl:for-each select="Etablissement/LstInvestissement/Investissement">
  903. <tr>
  904. <td><xsl:value-of select="Type"/></td>
  905. <td><xsl:value-of select="Montant"/><xsl:text> €</xsl:text></td>
  906. <td><xsl:value-of select="Commentaire"/></td>
  907. </tr>
  908. </xsl:for-each>
  909. </table>
  910. </xsl:if>
  911. </td>
  912. </tr>
  913. <tr>
  914. <td>Etat des réserves du collège</td>
  915. <td>
  916. <xsl:value-of select="format-number(Etablissement/Reserve,'###.###.##0','europe')"/><xsl:text> €</xsl:text>
  917. </td>
  918. </tr>
  919. <tr>
  920. <td>Interventions remarquables du département sur les 5 dernières années</td>
  921. <td></td>
  922. </tr>
  923. -->
  924. </table>
  925. <h2>6. Gestion des adjoints techniques des collèges (ATC)</h2>
  926. <h3>Liste nominative des agents ATC du département</h3>
  927. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut!='PERSONNEL NON CG'])>0">
  928. <table id="listeagentscg">
  929. <colgroup>
  930. <col class="atcnom"></col>
  931. <col class="atcprenom"></col>
  932. <col class="atcfonction"></col>
  933. <!--
  934. <col class="atcqtew"></col>
  935. <col class="atcstatut"></col>
  936. <col class="atcgrade"></col>
  937. -->
  938. </colgroup>
  939. <tr>
  940. <th class="bordurecentre td_head">Nom</th>
  941. <th class="bordurecentre td_head">Prénom</th>
  942. <th class="bordurecentre td_head">Intitulé de poste</th>
  943. <!--
  944. <th class="bordurecentre">Quotité de travail</th>
  945. <th class="bordurecentre">Statut</th>
  946. <th class="bordurecentre">Grade</th>
  947. -->
  948. </tr>
  949. <xsl:for-each select="Etablissement/LstATC/ATC[Statut!='PERSONNEL NON CG']">
  950. <tr>
  951. <td class="bordure">
  952. <xsl:value-of select="Nom"/>
  953. </td>
  954. <td class="bordure">
  955. <xsl:value-of select="Prenom"/>
  956. </td>
  957. <td class="bordure">
  958. <xsl:value-of select="FichePoste"/>
  959. </td>
  960. </tr>
  961. </xsl:for-each>
  962. </table>
  963. </xsl:if>
  964. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut!='PERSONNEL NON CG'])=0">
  965. Néant
  966. </xsl:if>
  967. <br/>
  968. <table>
  969. <colgroup>
  970. <col class="libelle"></col>
  971. <col class="information"></col>
  972. </colgroup>
  973. <tr>
  974. <td class="td_head">Nombre total d'ATC</td>
  975. <td>
  976. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut!='PERSONNEL NON CG'])=0">
  977. Néant
  978. </xsl:if>
  979. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut!='PERSONNEL NON CG'])>0">
  980. <xsl:value-of select="count(Etablissement/LstATC/ATC[Statut!='PERSONNEL NON CG'])"></xsl:value-of>
  981. <xsl:text> agent(s)</xsl:text>
  982. </xsl:if>
  983. </td>
  984. </tr>
  985. </table>
  986. <h3>Liste nominative des agents en contrat aidé</h3>
  987. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut='PERSONNEL NON CG'])>0">
  988. <table id="listeagentscg">
  989. <colgroup>
  990. <col class="atcnom"></col>
  991. <col class="atcprenom"></col>
  992. <col class="atcfonction"></col>
  993. <!--
  994. <col class="atcqtew"></col>
  995. <col class="atcstatut"></col>
  996. <col class="atcgrade"></col>
  997. -->
  998. </colgroup>
  999. <tr>
  1000. <th class="bordurecentre td_head">Nom</th>
  1001. <th class="bordurecentre td_head">Prénom</th>
  1002. <th class="bordurecentre td_head">Intitulé de poste</th>
  1003. <!--
  1004. <th class="bordurecentre">Quotité de travail</th>
  1005. <th class="bordurecentre">Statut</th>
  1006. <th class="bordurecentre">Grade</th>
  1007. -->
  1008. </tr>
  1009. <xsl:for-each select="Etablissement/LstATC/ATC[Statut='PERSONNEL NON CG']">
  1010. <tr>
  1011. <td class="bordure">
  1012. <xsl:value-of select="Nom"/>
  1013. </td>
  1014. <td class="bordure">
  1015. <xsl:value-of select="Prenom"/>
  1016. </td>
  1017. <td class="bordure">
  1018. <xsl:value-of select="FichePoste"/>
  1019. </td>
  1020. </tr>
  1021. </xsl:for-each>
  1022. </table>
  1023. </xsl:if>
  1024. <!--
  1025. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut='PERSONNEL NON CG'])=0">
  1026. néant
  1027. </xsl:if>
  1028. -->
  1029. <br/>
  1030. <table>
  1031. <colgroup>
  1032. <col class="libelle"></col>
  1033. <col class="information"></col>
  1034. </colgroup>
  1035. <tr>
  1036. <td class="td_head">Nombre total de contrats aidés</td>
  1037. <td>
  1038. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut='PERSONNEL NON CG'])=0">
  1039. néant
  1040. </xsl:if>
  1041. <xsl:if test ="count(Etablissement/LstATC/ATC[Statut='PERSONNEL NON CG'])>0">
  1042. <xsl:value-of select="count(Etablissement/LstATC/ATC[Statut='PERSONNEL NON CG'])"></xsl:value-of>
  1043. <xsl:text> agent(s)</xsl:text>
  1044. </xsl:if>
  1045. </td>
  1046. </tr>
  1047. </table>
  1048. <h2>7. Actions éducatives, sportives et culturelles</h2>
  1049. <h3>Actions de la Direction des Collèges (DC)</h3>
  1050. <table>
  1051. <colgroup>
  1052. <col class="libelle"></col>
  1053. <col class="information"></col>
  1054. </colgroup>
  1055. <td class="td_head">Classes de découvertes</td>
  1056. <td>
  1057. <xsl:if test ="count(Etablissement/LstClasseDecouverte/ClasseDecouverte)=0">
  1058. Non
  1059. </xsl:if>
  1060. <xsl:if test ="count(Etablissement/LstClasseDecouverte/ClasseDecouverte)!=0">
  1061. <table id="decouverte">
  1062. <colgroup>
  1063. <col class="Zone"></col>
  1064. <col class="Nb_Eleves"></col>
  1065. <col class="Montant_Subvention"></col>
  1066. </colgroup>
  1067. <th class="bordurecentre td_head">ZONE</th>
  1068. <th class="bordurecentre td_head">Nombre d'élèves</th>
  1069. <th class="bordurecentre td_head">Montant subvention</th>
  1070. <xsl:for-each select="Etablissement/LstClasseDecouverte/ClasseDecouverte">
  1071. <tr>
  1072. <td class="bordure">
  1073. <xsl:value-of select="Libelle"/>
  1074. </td>
  1075. <td class="bordure">
  1076. <xsl:value-of select="NbEleves"/>
  1077. </td>
  1078. <td class="bordure">
  1079. <xsl:value-of select ="Subvention"/>
  1080. <xsl:text> €</xsl:text>
  1081. </td>
  1082. </tr>
  1083. </xsl:for-each>
  1084. </table>
  1085. </xsl:if>
  1086. </td>
  1087. <!-- <tr>
  1088. <td>Complément scolaire par internet </td>
  1089. <xsl:if test ="count(Etablissement/SoutienScolaireEnLigne/NbrEleves)=0">
  1090. <td> Non</td>
  1091. </xsl:if>
  1092. <xsl:if test ="count(Etablissement/SoutienScolaireEnLigne/NbrEleves)!=0">
  1093. <td>
  1094. <xsl:value-of select ="Etablissement/SoutienScolaireEnLigne/NbrEleves"/>
  1095. <xsl:text> élèves</xsl:text>
  1096. </td>
  1097. </xsl:if>
  1098. </tr> -->
  1099. <xsl:if test ="count(Etablissement/LstActionEducatives/ActionEducative[TypeAction='DCE'])>0">
  1100. <table>
  1101. <colgroup>
  1102. <col class="libelle"></col>
  1103. <col class="infoAction"></col>
  1104. </colgroup>
  1105. <xsl:for-each select="Etablissement/LstActionEducatives/ActionEducative[TypeAction='DCE']">
  1106. <tr>
  1107. <td class="td_head">
  1108. <xsl:value-of select="Libelle"/>
  1109. </td>
  1110. <td>
  1111. <xsl:if test ="Participe='True'">
  1112. Oui
  1113. </xsl:if>
  1114. <xsl:if test ="Participe='False'">
  1115. Non
  1116. </xsl:if>
  1117. </td>
  1118. <td>
  1119. <xsl:if test="NbrEleves!= 0">
  1120. Le nombre d'élèves concernés est de <xsl:value-of select="NbrEleves"/><br/>
  1121. </xsl:if>
  1122. <xsl:if test="Partenaire!=''">
  1123. <xsl:value-of select="Partenaire"/>
  1124. </xsl:if>
  1125. </td>
  1126. </tr>
  1127. </xsl:for-each>
  1128. </table>
  1129. </xsl:if>
  1130. </table>
  1131. <h3>Actions de la Direction des Politiques Éducatives, Sportives et Culturelles (DPESC)</h3>
  1132. <table>
  1133. <colgroup>
  1134. <col class="libelle"></col>
  1135. <col class="infoAction"></col>
  1136. </colgroup>
  1137. <xsl:if test ="count(Etablissement/LstActionEducatives/ActionEducative[TypeAction='DJS'])>0">
  1138. <xsl:for-each select="Etablissement/LstActionEducatives/ActionEducative[TypeAction='DJS']">
  1139. <tr>
  1140. <td class="td_head">
  1141. <xsl:value-of select="Libelle"/>
  1142. </td>
  1143. <td>
  1144. <xsl:if test ="Participe='True'">
  1145. Oui
  1146. </xsl:if>
  1147. <xsl:if test ="Participe='False'">
  1148. Non
  1149. </xsl:if>
  1150. </td>
  1151. <br/>
  1152. <td>
  1153. <xsl:if test="NbrEleves!= 0">
  1154. Le nombre d'élèves concernés est de <xsl:value-of select="NbrEleves"/><br/>
  1155. </xsl:if>
  1156. <xsl:if test="Partenaire!=''">
  1157. <xsl:value-of select="Partenaire"/>
  1158. <br/>
  1159. </xsl:if>
  1160. <xsl:if test="MontantSubvention!= 0">
  1161. Le financement est de <xsl:value-of select ="MontantSubvention"/><xsl:text> €</xsl:text>
  1162. </xsl:if>
  1163. </td>
  1164. </tr>
  1165. </xsl:for-each>
  1166. </xsl:if>
  1167. <!-- <tr>
  1168. <td>Prévention des conduites à risque </td>
  1169. <td>Non</td>
  1170. <td></td>
  1171. </tr>
  1172. -->
  1173. </table>
  1174. <h3>Actions du Service Développement Artistique (SDA)</h3>
  1175. <table>
  1176. <colgroup>
  1177. <col class="libelle"></col>
  1178. <col class="infoAction"></col>
  1179. </colgroup>
  1180. <xsl:if test ="count(Etablissement/LstActionEducatives/ActionEducative[TypeAction='DCP'])=0">
  1181. Néant
  1182. </xsl:if>
  1183. <xsl:if test ="count(Etablissement/LstActionEducatives/ActionEducative[TypeAction='DCP'])>0">
  1184. <xsl:for-each select="Etablissement/LstActionEducatives/ActionEducative[TypeAction='DCP']">
  1185. <tr>
  1186. <td class="td_head">
  1187. <xsl:value-of select="Libelle"/>
  1188. </td>
  1189. <td>
  1190. <xsl:if test ="Participe='True'">
  1191. Oui
  1192. </xsl:if>
  1193. <xsl:if test ="Participe='False'">
  1194. Non
  1195. </xsl:if>
  1196. </td>
  1197. <br/>
  1198. <td>
  1199. <xsl:if test="NbrEleves!= 0">
  1200. Le nombre d'élèves concernés est de <xsl:value-of select="NbrEleves"/><br/>
  1201. </xsl:if>
  1202. <xsl:if test="Partenaire!=''">
  1203. <xsl:value-of select="Partenaire"/>
  1204. <br/>
  1205. </xsl:if>
  1206. <xsl:if test="MontantSubvention!= 0">
  1207. Le financement est de <xsl:value-of select ="MontantSubvention"/><xsl:text> €</xsl:text>
  1208. </xsl:if>
  1209. </td>
  1210. </tr>
  1211. </xsl:for-each>
  1212. </xsl:if>
  1213. </table>
  1214. <!-- <h2>8. Programmes expérimentaux de l'Education Nationale</h2>
  1215. <xsl:if test ="count(Etablissement/LstProjetPilote/ProjetPilote[Initiateur='EN'])=0">
  1216. Néant
  1217. </xsl:if>
  1218. <table>
  1219. <colgroup>
  1220. <col class="libelle"></col>
  1221. <col class="information"></col>
  1222. </colgroup>
  1223. <xsl:for-each select="Etablissement/LstProjetPilote/ProjetPilote[Initiateur='EN']">
  1224. <tr>
  1225. <td>
  1226. <xsl:value-of select="Libelle"/>
  1227. </td>
  1228. <td>
  1229. <xsl:if test ="Participe='True'">
  1230. Oui
  1231. </xsl:if>
  1232. <xsl:if test ="Participe='False'">
  1233. Non
  1234. </xsl:if>
  1235. </td>
  1236. </tr>
  1237. </xsl:for-each>
  1238. </table>
  1239. -->
  1240. <h2>8. Participation à des projets pilotes de la DC</h2>
  1241. <table>
  1242. <colgroup>
  1243. <col class="libelle"></col>
  1244. <col class="information"></col>
  1245. </colgroup>
  1246. <xsl:for-each select="Etablissement/LstProjetPilote/ProjetPilote[Initiateur='DCE']">
  1247. <tr>
  1248. <td class="td_head">
  1249. <xsl:value-of select="Libelle"/>
  1250. </td>
  1251. <td>
  1252. <xsl:value-of select="Participe"/>
  1253. <!-- <xsl:if test ="Participe='True'">
  1254. Oui
  1255. </xsl:if>
  1256. <xsl:if test ="Participe='False'">
  1257. Non
  1258. </xsl:if>-->
  1259. </td>
  1260. </tr>
  1261. </xsl:for-each>
  1262. </table>
  1263. <h2>9. Quelques indicateurs d’activité de la DC</h2>
  1264. <table>
  1265. <colgroup>
  1266. <col class="libelle"></col>
  1267. <col class="information"></col>
  1268. </colgroup>
  1269. <tr>
  1270. <td class="td_head">Nombre total d’adjoints des collèges</td>
  1271. <td>
  1272. <xsl:value-of select="entete/chiffresgeneraux/nbATC"/>
  1273. <xsl:text> agents</xsl:text>
  1274. </td>
  1275. </tr>
  1276. <tr>
  1277. <td class="td_head">Nombre total de repas produits par an</td>
  1278. <td>
  1279. <xsl:value-of select="entete/chiffresgeneraux/nbRepasAnnuel"/>
  1280. </td>
  1281. </tr>
  1282. <tr>
  1283. <td class="td_head">Surface totale des bâtiments</td>
  1284. <td>
  1285. <xsl:value-of select="entete/chiffresgeneraux/surfaceBatiments"/>
  1286. </td>
  1287. </tr>
  1288. <tr>
  1289. <td class="td_head">Surface totale des espaces extérieurs</td>
  1290. <td>
  1291. <xsl:value-of select="entete/chiffresgeneraux/surfaceExterieur"/>
  1292. </td>
  1293. </tr>
  1294. </table>
  1295. <h2>10. Quelques chiffres significatifs sur l'ensemble des collèges</h2>
  1296. <table>
  1297. <colgroup>
  1298. <col class="libelle"></col>
  1299. <col class="information"></col>
  1300. </colgroup>
  1301. <!--
  1302. <tr>
  1303. <td>Montant total des financements du département aux 90 collèges</td>
  1304. <td>
  1305. <xsl:value-of select="entete/chiffresgeneraux/financements"/>
  1306. <xsl:value-of select="ChiffresSignificatifs/MontantTotalFinancements"/><xsl:text> €</xsl:text>
  1307. </td>
  1308. </tr> -->
  1309. <tr>
  1310. <td class="td_head">Nombre total d'élèves</td>
  1311. <td>
  1312. <xsl:value-of select="format-number(ChiffresSignificatifs/NbTotalEleves,'###.###.##0','europe')"/>
  1313. <xsl:text> élèves</xsl:text>
  1314. </td>
  1315. </tr>
  1316. <tr>
  1317. <td class="td_head">Montant total des investissements</td>
  1318. <td>
  1319. <!--
  1320. <xsl:value-of select="ChiffresSignificatifs/MontantTotalInvestissement"/><xsl:text> €</xsl:text>
  1321. -->
  1322. <xsl:value-of select="entete/chiffresgeneraux/investissement"/>
  1323. </td>
  1324. </tr>
  1325. <tr>
  1326. <td class="td_head">Montant total des dotations de fonctionnement</td>
  1327. <td>
  1328. <!--
  1329. <xsl:value-of select="ChiffresSignificatifs/MontantTotalInvestissement"/><xsl:text> €</xsl:text>
  1330. -->
  1331. <xsl:value-of select="entete/chiffresgeneraux/fonctionnement"/>
  1332. </td>
  1333. </tr>
  1334. <tr>
  1335. <td class="td_head">Montant total des transports scolaires (Hors CUS, pour écoles, collèges et lycées)</td>
  1336. <td>
  1337. <xsl:value-of select="entete/chiffresgeneraux/transport"/>
  1338. <!--<xsl:value-of select="format-number(ChiffresSignificatifs/MontantTotalTransportScolaire,'###.###.##0,00','europe')"/><xsl:text> €</xsl:text> -->
  1339. </td>
  1340. </tr>
  1341. </table>
  1342. </div>
  1343. <div id="catouche">
  1344. <xsl:text>Editeur : </xsl:text>
  1345. <xsl:value-of select="entete/suiviepar/direction"/>
  1346. <br/>
  1347. <xsl:text>Contact : </xsl:text>
  1348. <xsl:value-of select="entete/suiviepar/nomprenom"/>
  1349. <xsl:text> Tél : </xsl:text>
  1350. <xsl:value-of select="entete/suiviepar/tel"/>
  1351. <br/>
  1352. <xsl:text>Crédit photo : </xsl:text>
  1353. <xsl:value-of select="entete/suiviepar/photo"/>
  1354. <br/>
  1355. <xsl:text>Mise à jour :</xsl:text>
  1356. <xsl:value-of select="entete/suiviepar/maj"/>
  1357. </div>
  1358. </div>
  1359. </xsl:template>
  1360. <xsl:template match="Etablissement/LstEffectif">
  1361. <img alt="Evolution des effectifs">
  1362. <xsl:variable name="capacitetheorique" select ="/college/Etablissement/EffectifTheorique" />
  1363. <xsl:attribute name="src">
  1364. vide.histo?nbCt=<xsl:value-of select="$capacitetheorique"/>&amp;l=600&amp;h=400&amp;f=-64&amp;nb=<xsl:value-of select="count(Effectif)"></xsl:value-of>
  1365. <!-- vide.histo?nbCt=400&amp;l=600&amp;h=400&amp;f=-64&amp;nb=<xsl:value-of select="count(Effectif)"></xsl:value-of> -->
  1366. <xsl:for-each select="Effectif">
  1367. <xsl:if test="TypeEffectif='R'">
  1368. &amp;v<xsl:value-of select ="position()"></xsl:value-of>=<xsl:value-of select="EffectifTotal"/>&amp;c<xsl:value-of select ="position()"></xsl:value-of>=-16776961&amp;t<xsl:value-of select ="position()"></xsl:value-of>=<xsl:value-of select="Annee"/>
  1369. </xsl:if>
  1370. <xsl:if test="TypeEffectif='P'">
  1371. &amp;v<xsl:value-of select ="position()"></xsl:value-of>=<xsl:value-of select="EffectifTotal"/>&amp;c<xsl:value-of select ="position()"></xsl:value-of>=-65536&amp;t<xsl:value-of select ="position()"></xsl:value-of>=<xsl:value-of select="Annee"/>
  1372. </xsl:if>
  1373. </xsl:for-each>
  1374. </xsl:attribute>
  1375. </img>
  1376. </xsl:template>
  1377. </xsl:stylesheet>