FicheCollegev2.xslt 55 KB

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