[platal.git] / templates / csv-importer.tpl

{**************************************************************************}
{*                                                                        *}
{*  Copyright (C) 2003-2011 Polytechnique.org                             *}
{*  http://opensource.polytechnique.org/                                  *}
{*                                                                        *}
{*  This program is free software; you can redistribute it and/or modify  *}
{*  it under the terms of the GNU General Public License as published by  *}
{*  the Free Software Foundation; either version 2 of the License, or     *}
{*  (at your option) any later version.                                   *}
{*                                                                        *}
{*  This program is distributed in the hope that it will be useful,       *}
{*  but WITHOUT ANY WARRANTY; without even the implied warranty of        *}
{*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *}
{*  GNU General Public License for more details.                          *}
{*                                                                        *}
{*  You should have received a copy of the GNU General Public License     *}
{*  along with this program; if not, write to the Free Software           *}
{*  Foundation, Inc.,                                                     *}
{*  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA               *}
{*                                                                        *}
{**************************************************************************}

{if $form_title}
<h1>{$form_title}</h1>
{/if}

<script type="text/javascript">//<![CDATA[
{literal}
  function showValue(key, box)
  {
    var span_value = document.getElementById('csv_user_value_span[' + key + ']');
    var span_cond  = document.getElementById('csv_cond_value_span[' + key + ']');
    var i    = box.selectedIndex;
    if (box.options[i].value == "user_value") {
      span_value.style.display = "";
      span_cond.style.display = "none";
    } else if(box.options[i].value == "cond_value") {
      span_value.style.display = "none";
      span_cond.style.display = "";
    } else {
      span_value.style.display = "none";
      span_conf.style.display = "none";
    }
  }
  function showCond(key, box)
  {
    var line = document.getElementById('csv_cond_value[' + key + ']');
    var i    = box.selectedIndex;
    if (box.options[i].value == "defined") {
      line.style.display = "none";
    } else {
      line.style.display = "";
    }
  }
  function gotoPage(page)
  {
    document.getElementById('csv_next_page').value = page;
    document.getElementById('csv_form').submit();
    return false;
  }
{/literal}
//]]></script>
<form action="{$csv_path}" method="post" id="csv_form">
  {xsrf_token_field}
  <div class="center" style="padding-bottom: 1em">
    Import d'un CSV&nbsp;:
    {if $csv_page eq 'source'}
    <span class="erreur">Choisir la source</span>
    {else}
    <a href="{$csv_path}" onclick="return gotoPage('source');">Choisir la source</a>
    {/if}
    »
    {if $csv_page eq 'values'}
    <span class="erreur">Définir les valeurs</span>
    {elseif $smarty.session.csv}
    <a href="{$csv_path}" onclick="return gotoPage('values');">Définir les valeurs</a>
    {else}
    Définir les valeurs
    {/if}
    »
    {if $csv_page eq 'valid'}
    <span class="erreur">Vérifier et valider</span>
    {elseif $csv_action}
    <a href="{$csv_path}" onclick="return gotoPage('valid');">Vérifier et valider</a>
    {else}
    Vérifier et valider
    {/if}
  </div>
  {if $csv_page eq 'source'}
  <div>
    <textarea name="csv_source" rows="20" cols="80">{$smarty.session.csv|default:$smarty.session.csv_source}</textarea><br />
    Entrez les données sous la forme suivante (avec
    <input type="text" name="csv_separator" value="{$smarty.session.csv_separator|default:";"}" maxlength="1" size="1" />
    comme séparateur)&nbsp;:<br/>
    <pre class="center">TITRE1{$smarty.session.csv_separator|default:";"}TITRE2{$smarty.session.csv_separator|default:";"}...
val1_1{$smarty.session.csv_separator|default:";"}val1_2{$smarty.session.csv_separator|default:";"}...
val2_1{$smarty.session.csv_separator|default:";"}val2_2{$smarty.session.csv_separator|default:";"}...
val3_1{$smarty.session.csv_separator|default:";"}val3_2{$smarty.session.csv_separator|default:";"}...</pre>
  </div>
  {elseif $csv_page eq 'values'}
  <div class="center">
    Action à effectuer si l'entrée existe&nbsp;:
    <select name="csv_action" onchange="this.form.submit()">
      <option value="insert" {if $smarty.session.csv_action eq 'insert'}selected="selected"{/if}>
        ne rien faire
      </option>
      <option value="replace" {if $smarty.session.csv_action eq 'replace'}selected="selected"{/if}>
        remplacer par la nouvelle entrée
      </option>
      {if $csv_key}
      <option value="update" {if $smarty.session.csv_action eq 'update'}selected="selected"{/if}>
        mettre à jour les champs sélectionnés
      </option>
      {/if}
    </select>
  </div>
  <table class="bicol">
    <tr>
      <th>Champ</th>
      <th colspan="2">Valeur</th>
      {if $smarty.session.csv_action eq 'update'}
      <th>MàJ</th>
    {/if}
    </tr>
    {foreach from=$csv_fields item=f}
    <tr class="{cycle values="pair,impair"}">
      <td>{$csv_field_desc[$f]|default:$f}</td>
      <td>
        <select name="csv_value[{$f}]" onchange="showValue('{$f}', this);">
          <option value="" {if !$smarty.session.csv_value[$f]}selected="selected"{/if}>
            Vide
          </option>
          <option value="user_value" {if $smarty.session.csv_value[$f] eq "user_value"}selected="selected"{/if}>
            Entrer la valeur
          </option>
          <option value="cond_value" {if $smarty.session.csv_value[$f] eq "cond_value"}selected="selected"{/if}>
            Valeur conditionnelle
          </option>
          <optgroup label="Colonnes du CSV">
            {foreach from=$csv_index item=col}
            <option value="{$col}" {if $smarty.session.csv_value[$f] eq $col}selected="selected"{/if}>{$col}</option>
            {/foreach}
          </optgroup>
          {if $csv_functions|count}
          <optgroup label="Fonctions">
            {foreach from=$csv_functions key=func item=desc}
            <option value="{$func}" {if $smarty.session.csv_value[$f] eq $func}selected="selected"{/if}>{$desc.desc}</option>
            {/foreach}
          </optgroup>
          {/if}
        </select>
      </td>
      <td>
        <span id="csv_user_value_span[{$f}]" {if $smarty.session.csv_value[$f] neq "user_value"}style="display: none"{/if}>
          <input type="text" name="csv_user_value[{$f}]" value="{$smarty.session.csv_user_value[$f]}" />
        </span>
        <span id="csv_cond_value_span[{$f}]" {if $smarty.session.csv_value[$f] neq "cond_value"}style="display: none"{/if}>
          Si
          <select name="csv_cond_field[{$f}]">
            {foreach from=$csv_index item=col}
            <option value="{$col}" {if $smarty.session.csv_cond_field_value[$f] eq $col}selected="selected"{/if}>
              {$col}
            </option>
            {/foreach}
          </select>
          <select name="csv_cond[{$f}]" onchange="showCond('{$f}', this)">
            <option value="defined" {if $smarty.session.csv_cond[$f] eq "defined"}selected="selected"{/if}>
              défini
            </option>
            <option value="equals" {if $smarty.session.csv_cond[$f] eq "equals"}selected="selected"{/if}>
              est égale à
            </option>
            <option value="contains" {if $smarty.session.csv_cond[$f] eq "contains"}selected="selected"{/if}>
              contient
            </option>
            <option value="contained" {if $smarty.session.csv_cond[$f] eq "contained"}selected="selected"{/if}>
              est contenu dans
            </option>
            <option value="greater" {if $smarty.session.csv_cond[$f] eq "greater"}selected="selected"{/if}>
              supérieur à
            </option>
            <option value="greater_or_equal" {if $smarty.session.csv_cond[$f] eq "greater_or_equal"}selected="selected"{/if}>
              supérieur ou égal à
            </option>
            <option value="lower" {if $smarty.session.csv_cond[$f] eq "lower"}selected="selected"{/if}>
              inférieur à
            </option>
            <option value="lower_or_equal" {if $smarty.session.csv_cond[$f] eq "lower_or_equal"}selected="selected"{/if}>
              inférieur ou égal à
            </option>
          </select>
          <span id="csv_cond_value[{$f}]" {if $smarty.session.csv_cond[$f] eq "defined" || !$smarty.session.csv_cond[$f]}style="display: none"{/if}>
            <input type="text" name="csv_cond_value[{$f}]" value="{$smarty.session.csv_cond_value[$f]}" />
          </span>
          <br />Alors <input type="text" name="csv_cond_then[{$f}]" value="{$smarty.session.csv_cond_then[$f]}" />
          <br />Sinon <input type="text" name="csv_cond_else[{$f}]" value="{$smarty.session.csv_cond_else[$f]}" />
        </span>
      </td>
      {if $smarty.session.csv_action eq 'update'}
      <td class="center">
        <input type="checkbox" name="csv_update[{$f}]" {if $smarty.session.csv_update[$f]}checked="checked"{/if} />
      </td>
      {/if}
    </tr>
    {/foreach}
  </table>
  {elseif $csv_page eq 'valid'}
  {if !$csv_done}
  <table class="bicol">
    <tr>
      {foreach from=$csv_fields item=f}
      <th>{$csv_field_desc[$f]|default:$f}</th>
      {/foreach}
    </tr>
    {foreach from=$csv_preview item=assoc}
    <tr class="{cycle values="pair,impair"}">
      {foreach from=$csv_fields item=f}
      <td>{$assoc[$f]}</td>
      {/foreach}
    <tr>
    {/foreach}
  </table>
  {else}
  <p>Les données ont été ajoutées.</p>
  {/if}
  {/if}

  {if !$csv_done}
  <div class="center">
    <input type="hidden" name="csv_page" value="{$csv_page}" />
    <input type="hidden" id="csv_next_page" name="csv_next_page" value="{$csv_page}" />
    {if $csv_page eq 'source'}
    <input type="submit" name="csv_valid" value="Changer le CSV" />
    {elseif $csv_page eq 'values'}
    <input type="submit" name="csv_valid" value="Aperçu" />
    {elseif $csv_page eq 'valid'}
    <input type="submit" name="csv_valid" value="Valider" />
    {/if}
  </div>
  {/if}
</form>

{* vim:set et sws=2 sts=2 sw=2 fenc=utf-8: *}
Commit	Line	Data
7cb40d85 FB	1	{**************************************************************************}
7cb40d85 FB	2	{* *}
e92ecb8c	3	{* Copyright (C) 2003-2011 Polytechnique.org *}
7cb40d85 FB	4	{* http://opensource.polytechnique.org/ *}
	5	{* *}
	6	{* This program is free software; you can redistribute it and/or modify *}
	7	{* it under the terms of the GNU General Public License as published by *}
	8	{* the Free Software Foundation; either version 2 of the License, or *}
	9	{* (at your option) any later version. *}
	10	{* *}
	11	{* This program is distributed in the hope that it will be useful, *}
	12	{* but WITHOUT ANY WARRANTY; without even the implied warranty of *}
	13	{* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *}
	14	{* GNU General Public License for more details. *}
	15	{* *}
	16	{* You should have received a copy of the GNU General Public License *}
	17	{* along with this program; if not, write to the Free Software *}
	18	{* Foundation, Inc., *}
	19	{* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *}
	20	{* *}
	21	{**************************************************************************}
	22
	23	{if $form_title}
	24	<h1>{$form_title}</h1>
	25	{/if}
	26
	27	<script type="text/javascript">//<![CDATA[
	28	{literal}
	29	function showValue(key, box)
	30	{
	31	var span_value = document.getElementById('csv_user_value_span[' + key + ']');
	32	var span_cond = document.getElementById('csv_cond_value_span[' + key + ']');
	33	var i = box.selectedIndex;
	34	if (box.options[i].value == "user_value") {
	35	span_value.style.display = "";
	36	span_cond.style.display = "none";
	37	} else if(box.options[i].value == "cond_value") {
	38	span_value.style.display = "none";
	39	span_cond.style.display = "";
	40	} else {
	41	span_value.style.display = "none";
	42	span_conf.style.display = "none";
	43	}
	44	}
	45	function showCond(key, box)
	46	{
	47	var line = document.getElementById('csv_cond_value[' + key + ']');
	48	var i = box.selectedIndex;
	49	if (box.options[i].value == "defined") {
	50	line.style.display = "none";
	51	} else {
	52	line.style.display = "";
	53	}
	54	}
	55	function gotoPage(page)
	56	{
	57	document.getElementById('csv_next_page').value = page;
	58	document.getElementById('csv_form').submit();
	59	return false;
	60	}
	61	{/literal}
	62	//]]></script>
	63	<form action="{$csv_path}" method="post" id="csv_form">
	64	{xsrf_token_field}
	65	<div class="center" style="padding-bottom: 1em">
	66	Import d'un CSV :
	67	{if $csv_page eq 'source'}
68	<span class="erreur">Choisir la source</span>
69	{else}
70	<a href="{$csv_path}" onclick="return gotoPage('source');">Choisir la source</a>
71	{/if}
72	»
73	{if $csv_page eq 'values'}
74	<span class="erreur">Définir les valeurs</span>
75	{elseif $smarty.session.csv}
76	<a href="{$csv_path}" onclick="return gotoPage('values');">Définir les valeurs</a>
77	{else}
78	Définir les valeurs
79	{/if}
80	»
81	{if $csv_page eq 'valid'}
82	<span class="erreur">Vérifier et valider</span>
83	{elseif $csv_action}
84	<a href="{$csv_path}" onclick="return gotoPage('valid');">Vérifier et valider</a>
85	{else}
86	Vérifier et valider
87	{/if}
88	</div>
89	{if $csv_page eq 'source'}
90	<div>
91	<textarea name="csv_source" rows="20" cols="80">{$smarty.session.csv\|default:$smarty.session.csv_source}</textarea><br />
92	Entrez les données sous la forme suivante (avec
93	<input type="text" name="csv_separator" value="{$smarty.session.csv_separator\|default:";"}" maxlength="1" size="1" />
94	comme séparateur) :<br/>
95	<pre class="center">TITRE1{$smarty.session.csv_separator\|default:";"}TITRE2{$smarty.session.csv_separator\|default:";"}...
96	val1_1{$smarty.session.csv_separator\|default:";"}val1_2{$smarty.session.csv_separator\|default:";"}...
97	val2_1{$smarty.session.csv_separator\|default:";"}val2_2{$smarty.session.csv_separator\|default:";"}...
98	val3_1{$smarty.session.csv_separator\|default:";"}val3_2{$smarty.session.csv_separator\|default:";"}...</pre>
99	</div>
100	{elseif $csv_page eq 'values'}
101	<div class="center">
ef138fdc	102	Action à effectuer si l'entrée existe :
7cb40d85 FB	103	<select name="csv_action" onchange="this.form.submit()">
	104	<option value="insert" {if $smarty.session.csv_action eq 'insert'}selected="selected"{/if}>
	105	ne rien faire
	106	</option>
	107	<option value="replace" {if $smarty.session.csv_action eq 'replace'}selected="selected"{/if}>
	108	remplacer par la nouvelle entrée
	109	</option>
	110	{if $csv_key}
	111	<option value="update" {if $smarty.session.csv_action eq 'update'}selected="selected"{/if}>
	112	mettre à jour les champs sélectionnés
	113	</option>
	114	{/if}
	115	</select>
	116	</div>
	117	<table class="bicol">
	118	<tr>
	119	<th>Champ</th>
	120	<th colspan="2">Valeur</th>
	121	{if $smarty.session.csv_action eq 'update'}
	122	<th>MàJ</th>
	123	{/if}
	124	</tr>
	125	{foreach from=$csv_fields item=f}
	126	<tr class="{cycle values="pair,impair"}">
	127	<td>{$csv_field_desc[$f]\|default:$f}</td>
	128	<td>
	129	<select name="csv_value[{$f}]" onchange="showValue('{$f}', this);">
	130	<option value="" {if !$smarty.session.csv_value[$f]}selected="selected"{/if}>
	131	Vide
	132	</option>
	133	<option value="user_value" {if $smarty.session.csv_value[$f] eq "user_value"}selected="selected"{/if}>
	134	Entrer la valeur
	135	</option>
	136	<option value="cond_value" {if $smarty.session.csv_value[$f] eq "cond_value"}selected="selected"{/if}>
	137	Valeur conditionnelle
	138	</option>
	139	<optgroup label="Colonnes du CSV">
	140	{foreach from=$csv_index item=col}
	141	<option value="{$col}" {if $smarty.session.csv_value[$f] eq $col}selected="selected"{/if}>{$col}</option>
	142	{/foreach}
	143	</optgroup>
	144	{if $csv_functions\|count}
	145	<optgroup label="Fonctions">
	146	{foreach from=$csv_functions key=func item=desc}
	147	<option value="{$func}" {if $smarty.session.csv_value[$f] eq $func}selected="selected"{/if}>{$desc.desc}</option>
	148	{/foreach}
	149	</optgroup>
	150	{/if}
	151	</select>
	152	</td>
	153	<td>
	154	<span id="csv_user_value_span[{$f}]" {if $smarty.session.csv_value[$f] neq "user_value"}style="display: none"{/if}>
	155	<input type="text" name="csv_user_value[{$f}]" value="{$smarty.session.csv_user_value[$f]}" />
	156	</span>
	157	<span id="csv_cond_value_span[{$f}]" {if $smarty.session.csv_value[$f] neq "cond_value"}style="display: none"{/if}>
	158	Si
	159	<select name="csv_cond_field[{$f}]">
	160	{foreach from=$csv_index item=col}
	161	<option value="{$col}" {if $smarty.session.csv_cond_field_value[$f] eq $col}selected="selected"{/if}>
	162	{$col}
	163	</option>
	164	{/foreach}
	165	</select>
	166	<select name="csv_cond[{$f}]" onchange="showCond('{$f}', this)">
167	<option value="defined" {if $smarty.session.csv_cond[$f] eq "defined"}selected="selected"{/if}>
168	défini
169	</option>
170	<option value="equals" {if $smarty.session.csv_cond[$f] eq "equals"}selected="selected"{/if}>
171	est égale à
172	</option>
173	<option value="contains" {if $smarty.session.csv_cond[$f] eq "contains"}selected="selected"{/if}>
174	contient
175	</option>
176	<option value="contained" {if $smarty.session.csv_cond[$f] eq "contained"}selected="selected"{/if}>
177	est contenu dans
178	</option>
179	<option value="greater" {if $smarty.session.csv_cond[$f] eq "greater"}selected="selected"{/if}>
180	supérieur à
181	</option>
182	<option value="greater_or_equal" {if $smarty.session.csv_cond[$f] eq "greater_or_equal"}selected="selected"{/if}>
183	supérieur ou égal à
184	</option>
185	<option value="lower" {if $smarty.session.csv_cond[$f] eq "lower"}selected="selected"{/if}>
186	inférieur à
187	</option>
188	<option value="lower_or_equal" {if $smarty.session.csv_cond[$f] eq "lower_or_equal"}selected="selected"{/if}>
189	inférieur ou égal à
190	</option>
191	</select>
192	<span id="csv_cond_value[{$f}]" {if $smarty.session.csv_cond[$f] eq "defined" \|\| !$smarty.session.csv_cond[$f]}style="display: none"{/if}>
193	<input type="text" name="csv_cond_value[{$f}]" value="{$smarty.session.csv_cond_value[$f]}" />
194	</span>
195	<br />Alors <input type="text" name="csv_cond_then[{$f}]" value="{$smarty.session.csv_cond_then[$f]}" />
196	<br />Sinon <input type="text" name="csv_cond_else[{$f}]" value="{$smarty.session.csv_cond_else[$f]}" />
197	</span>
198	</td>
199	{if $smarty.session.csv_action eq 'update'}
200	<td class="center">
201	<input type="checkbox" name="csv_update[{$f}]" {if $smarty.session.csv_update[$f]}checked="checked"{/if} />
202	</td>
203	{/if}
204	</tr>
205	{/foreach}
206	</table>
207	{elseif $csv_page eq 'valid'}
208	{if !$csv_done}
209	<table class="bicol">
210	<tr>
211	{foreach from=$csv_fields item=f}
212	<th>{$csv_field_desc[$f]\|default:$f}</th>
213	{/foreach}
214	</tr>
215	{foreach from=$csv_preview item=assoc}
216	<tr class="{cycle values="pair,impair"}">
217	{foreach from=$csv_fields item=f}
218	<td>{$assoc[$f]}</td>
219	{/foreach}
220	<tr>
221	{/foreach}
222	</table>
223	{else}
4836f918	224	<p>Les données ont été ajoutées.</p>
7cb40d85 FB	225	{/if}
	226	{/if}
	227
	228	{if !$csv_done}
	229	<div class="center">
	230	<input type="hidden" name="csv_page" value="{$csv_page}" />
	231	<input type="hidden" id="csv_next_page" name="csv_next_page" value="{$csv_page}" />
	232	{if $csv_page eq 'source'}
	233	<input type="submit" name="csv_valid" value="Changer le CSV" />
	234	{elseif $csv_page eq 'values'}
	235	<input type="submit" name="csv_valid" value="Aperçu" />
	236	{elseif $csv_page eq 'valid'}
	237	<input type="submit" name="csv_valid" value="Valider" />
	238	{/if}
	239	</div>
	240	{/if}
	241	</form>
	242
fa7ffd66	243	{* vim:set et sws=2 sts=2 sw=2 fenc=utf-8: *}