FicheCollege.xslt 56 KB

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