Code à copier sur votre site internet pour afficher les ateliers. (code fonctionnel :D)

<script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>

<script type="text/javascript" src="http://ant-reunion.fr/ressources/inscriptionsAteliers/js/initAtelier.js"></script>

<script id="hr-template" type="text/x-handlebars-template">

  {{#if cells.EventId}}

 <div class="atelier mix fullblock mois{{{cells.MoisAtelier}}}">

   <h2 class="fg-Orange">{{{cells.EventTitle}}}</h2>

   <div class="col1 bd-Orange">

      <div class="description"><strong class="uppercase">Description :</strong> {{{cells.Description}}}</div>

      <div class="lieu"><strong class="uppercase">Lieu :</strong> {{{cells.Location}}} {{{cells.AdditionalGuests}}}</div>

      <div class="materiel op-Orange"><strong class="uppercase">Matériel à prévoir :</strong> {{{cells.matos}}}</div>

    </div>

    <div class="col2"><div class="date bg-Orange">{{{cells.DateFormatee}}}</div><div class="heures bg-Orange">{{{cells.Heures}}}</div></div>

    <div class="inscription bg-Orange">{{{cells.Button}}}</div>

   </div>

     {{else}}

    <div id="no_ateliers">Il n y a pas d ateliers de prévu pour le moment.</div>

  {{/if}}

<![CDATA[]]>

</script>

<div id="content">

    <h1 id="title_module">

        Ateliers de l'année

    </h1>

    <div id="content_ateliers"></div>

</div>

<script type="text/javascript">

// <![CDATA[

var $j = jQuery.noConflict();

var filtre = ""; 

// Define spreadsheet URL.

var mySpreadsheet = 'URL DU FICHIER ATELIER';

// Compile the Handlebars template for HR leaders.

var HRTemplate = Handlebars.compile($j('#hr-template').html());

var date = new Date();

var day = date.getDate();

var monthIndex = date.getMonth();

var year = date.getFullYear();

var query = "select * where (X = 'EVENT_IMPORTED' or X ='EVENT_FULL' or X='ALERT_1_SENT' or X='ALERT_2_SENT') order by O desc";

if(filtre != "")

  var query = "select * where (X = 'EVENT_IMPORTED' or X ='EVENT_FULL' or X=''ALERT_1_SENT' or X='ALERT_2_SENT' and V = '"+filtre+"') order by O desc";

// Load top five HR leaders.

$j('#content_ateliers').sheetrock({

  url: mySpreadsheet,

  sql: query,

  chunkSize: 0,

  headersOff: true,

  rowHandler: HRTemplate

});

if(monthIndex < 10)

  monthIndex = "0"+monthIndex;

$j('.mois'+monthIndex).css("display: block;");

$j(function(){

    document.getElementById('title_module').innerHTML = "Ateliers de l'année "+year;

    $j('.fancybox').fancybox();

});

//]]>

</script>