FicheCollegev2.xslt 56 KB

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