<?php
// Report all PHP errors (see changelog)
error_reporting(E_ALL);
global $wpdb;
?>
        <script src="../wp-content/plugins/atalantini/js/atalantiniplug.js" type="text/javascript"></script>
        <script src="../wp-content/plugins/atalantini/js/atalantinifunctions.js?v=1.0" type="text/javascript"></script>
        <link href="../wp-content/plugins/atalantini/css/local.css" rel="stylesheet" type="text/css">
        <link type="text/css" href="../wp-content/plugins/atalantini/css/jquery-ui-1.8.8.custom.css" rel="stylesheet" />
        <script>

                pageSize = 30;

        </script>

<div class="icon32" id="icon-generic"><br></div><h2>Area Riservata Atalantini</h2>
<br />
<h3 class="colore_arancio">Gestione Team</h3>

<div class="container" id="grigliaTeam">
<div style="float:right">
<input type="text" id="search_team"><input type="button" value="Cerca" id="confirm_search_team">
</div>
<a href="#" onClick="creaTeam();" style="float:left;">Aggiungi Team</a>&nbsp;&nbsp;<div id="paginator" style="float:left;"></div><br><br />
<table class="wp-list-table widefat fixed posts">
         <thead>
           <tr>
             <th>Id</th>
             <th>Team 1</th>
             <th>Foto</th>
             <th>Team 2</th>
             <th>Foto</th>
             <th>Risultato</th>
	     <th>Girone</th>
             <th>Attivo</th>
             <th>Votanti</th>
             <th>Azioni</th>
           </tr>
         </thead>
         <tbody id="lista_team">
         </tbody>
       </table>
</div>

<div class="container" id="formTeam">
<form method="post"  enctype="multipart/form-data" onSubmit="return validateFormTeam();">
<div id="post-body">
<div id="post-body-content">
<div id="titlediv">
<div style="float:right" id="spotTeamImmagine">
<table>
<?php
$ruoli = array();
$ruoli[] = "PORTIERE";
$ruoli[] = "DIFENSORE";
$ruoli[] = "CENTROCAMPISTA";
$ruoli[] = "ATTACCANTE";
$ruoli[] = "ALLENATORE";


foreach ($ruoli as $ruolo) {
	$sql = "select id, numero, nominativo, ruolo from wp_plugin_atalantini_player where inrosa = 'SI' and ruolo = '" . $ruolo . "';";
	$players = $wpdb->get_results($sql);
	foreach ( $players as $player )  {
        ?>
          <tr>
              <td><input id="team_player_<?= $player->id?>" type="checkbox" name="ids[]" value="<?= $player->id?>"></b></td>
              <td><b><?= $player->numero ?></b></td>
              <td><?= $player->nominativo ?></td>
              <td><?= $player->ruolo ?></td>
	<?php
	}
}
?>
</table>
</div>
<div id="idPrivatePanel" style="display:block;">
<div id="titlewrap">
   Squadra 1<br>
   <select id="sq1" name="sq1" class="span3" onChange="setImage(this.options[this.selectedIndex].value,'file_team1');">
	<option value="">Seleziona Squadra</option>
	<?php
        $sql = "select sq from wp_plugin_atalantini_squadre;";
        $players = $wpdb->get_results($sql);
        foreach ( $players as $player )  {
	?>
                <option value="<?= $player->sq ?>"><?= $player->sq ?></option>
	<?php
	}
	?>
   </select>
</div>
<input type="hidden" id="file_team1" name="file_team1">
<div id="titlewrap">
   Squadra 2<br>
   <select id="sq2" name="sq2" class="span3" onChange="setImage(this.options[this.selectedIndex].value,'file_team2');">
        <option value="">Seleziona Squadra</option>
        <?php
        $sql = "select sq from wp_plugin_atalantini_squadre;";
        $players = $wpdb->get_results($sql);
        foreach ( $players as $player )  {
        ?>
                <option value="<?= $player->sq ?>"><?= $player->sq ?></option>
        <?php
        }
        ?>
   </select>
</div>
<input type="hidden" id="file_team2" name="file_team2">
<div id="titlewrap">
   Risultato:<br><input type="text" style="width:40px;" id="resultsq1" name="resultsq1" size="4" class="span3"> - <input type="text" id="resultsq2" name="resultsq2" style="width:40px;" class="span3">
</div>
<div id="titlewrap">
   Girone<br>
                <select id="girone" name="girone"class="span3">
                        <option value="ANDATA">ANDATA</option>
                        <option value="RITORNO">RITORNO</option>
                </select>
</div>
<div id="titlewrap"> 
   Attivo<br>
                <select id="attivo" name="attivo"class="span3">
                        <option value="SI">SI</option>
                        <option value="NO">NO</option>
                        <option value="CHIUSO">CHIUSO</option>
                </select>
</div>
<div id="titlewrap">
   Tipo<br>
                <select id="tipo" name="tipo"class="span3">
                        <option value="0">Campionato</option>
                        <option value="1">Champions League</option>
                        <option value="2">Coppa italia</option>
                </select>
</div>
<div style="display:none;" id="idPublicPanel">
</div>
<div id="titlewrap">
   <button type="submit" class="btn" id="btnSaveTeam">Salva</button>
   <button type="button" class="btn" id="btnEsciTeam">Esci</button>
   <input type="hidden" name="teamId" id="teamId" value="">
   <input type="hidden" name="azione" id="azione" value="">
   <input type="hidden" name="actionSite" value="UPLOAD_TEAM">
   <input type="hidden" name="tipo_accesso" value="N">
</div>
</form>
</div></div></div>
</div>
<script>

listaTeam(1);

var photos = new Array();
<?php
$sql = "select sq,immagine from wp_plugin_atalantini_squadre;";
$players = $wpdb->get_results($sql);
foreach ( $players as $player )  {
?>
photos['<?= str_replace("'","", $player->sq) ?>'] = "<?= str_replace('"','',$player->immagine) ?>";
<?php
}
?>

function setImage(team, element) {
	jQuery('#' + element).val(photos[team]);
}

</script>