public_html/prova.js

   1 function update(event)
   2 {
   3         var str;
   4         if (event==null)
   5                 str='all';
   6     else{
   7                 var object=event.target;
   8                 str=object.getAttribute("esercizio");
   9         }
  10         var query="./serverRequest.php";
  11         var request=new Object();
  12         request.name=str;
  13         var sendstr=JSON.stringify(request);
  14         $.ajax({
  15                 url:query,
  16                 type:"POST",
  17                 async: "true",
  18                 dataType: "json",
  19                 data:sendstr,
  20                 contentType: "application/json; charset=utf-8",
  21                 success:function(val)
  22                 {
  23                         $("#tabella").empty();
  24                         $("#tabella").append("<tr><th>Nome Esercizio</th><th>Studente</th><th>voto</th><th>ora</th>");
  25                         $.each(val.esercizi, function(i, item) {
  26                                 var id="es"+i;
  27                                 if(item.risultati[0].id!=null)
  28                                 {
  29                                         for(j=0;j<item.risultati.length;j++)
  30                                         {
  31                                                 var id_i=id+j;
  32                                                 var tmpel='<input class="elimina" type="submit" risultato='+item.risultati[j].id+' value="elimina">';
  33                                                 var date= new Date(item.risultati[j].time*1000/1000);
  34                                                 var data_ora=date.getDate()+"/"+date.getMonth()+"/"+date.getFullYear()+"\t"+date.getHours()+":"+date.getMinutes();
  35                                                 $("#tabella").append($('<tr>').attr('id',id_i));
  36                                                 id_i="#"+id_i;
  37                                                 $(id_i).append($('<td>').text(item.esercizio));
  38                                                 $(id_i).append($('<td>').text(item.risultati[j].utente));
  39                                                 $(id_i).append($('<td>').text(item.risultati[j].click));
  40                                                 $(id_i).append($('<td>').text(data_ora));
  41                                                 $(id_i).append($('<td>').append(tmpel));
  42                                         }
  43                                 }
  44                         });
  45                         $(".elimina").click(function(event){elimina(event);});
  46                 },
  47         });
  48 }
  49
  50 function updateUsr(event)
  51 {
  52         var str;
  53         if (event==null)
  54                 str='all';
  55     else{
  56                 var object=event.target;
  57                 str=object.getAttribute("utente");
  58         }
  59         var query="./esForUsr.php";
  60         var request=new Object();
  61         request.name=str;
  62         var sendstr=JSON.stringify(request);
  63         $.ajax({
  64                 url:query,
  65                 type:"POST",
  66                 async: "true",
  67                 dataType: "json",
  68                 data:sendstr,
  69                 contentType: "application/json; charset=utf-8",
  70                 success:function(val)
  71                 {
  72                         $("#tab").empty();
  73                         $("#tab").append("<tr><th>Studente</th><th>Nome Esercizio</th><th>voto</th><th>ora</th>");
  74                         $.each(val.esercizi, function(i, item) {
  75                                 var id="ut"+i;
  76                                 if(item.risultati[0].id!=null)
  77                                 {
  78                                         for(j=0;j<item.risultati.length;j++)
  79                                         {
  80                                                 var id_i=id+j;
  81                                                 var tmpel='<input class="elimina" type="submit" risultato='+item.risultati[j].id+' value="elimina">';
  82                                                 var date= new Date(item.risultati[j].time*1000/1000);
  83                                                 var data_ora=date.getDate()+"/"+date.getMonth()+"/"+date.getFullYear()+"\t"+date.getHours()+":"+date.getMinutes();
  84                                                 $("#tab").append($('<tr>').attr('id',id_i));
  85                                                 id_i="#"+id_i;
  86                                                 $(id_i).append($('<td>').text(item.risultati[j].utente));
  87                                                 $(id_i).append($('<td>').text(item.esercizio));
  88                                                 $(id_i).append($('<td>').text(item.risultati[j].click));
  89                                                 $(id_i).append($('<td>').text(data_ora));
  90                                                 $(id_i).append($('<td>').append(tmpel));
  91                                         }
  92                                 }
  93                         });
  94                         $(".elimina").click(function(event){elimina(event);});
  95                 },
  96         });
  97 }
  98
  99 function esList()
 100 {
 101         var query="./xmlPharse.php";
 102         $.ajax({
 103                 url:query,
 104                 type:"GET",
 105                 async: "true",
 106                 dataType: "json",
 107                 accepts: {json:"application/json"},
 108                 success:function(val)
 109                 {
 110                         var ok=0;
 111                         $("#esTable").empty();
 112                         $("#esTable").append("<tr><th>Nome Esercizio</th>");
 113                         $.each(val.esercizi, function(i, item) {
 114                                 if(item!=null)
 115                                 {
 116                                         ok=1;
 117                                         var id="ex"+i;
 118                                         var tmpel='<input class="elimina" type="submit" esercizio='+item+' risultato="0" value="elimina">';
 119                                         var tmpsel='<input class="seleziona" type="submit" esercizio='+item+' risultato="0" value="seleziona">';
 120                                         $("#esTable").append($('<tr>').attr('id',id));
 121                                         $("#ex"+i).append($('<td>').text(item));
 122                                         $("#ex"+i).append($('<td></td>').append(tmpsel));
 123                                         $("#ex"+i).append($('<td></td>').append(tmpel));
 124                                 }
 125                         });
 126                         if(ok==1)
 127                                 $("#esTable").append('<button type="button" esercizio="all" class="seleziona">seleziona tutti</button>');
 128                         $(".seleziona").click(function(event){update(event);});
 129                         $(".elimina").click(function(event){elimina(event);});
 130                 },
 131         });
 132 }
 133
 134 function usrList()
 135 {
 136         var query="./utenti.php";
 137         $.ajax({
 138                 url:query,
 139                 type:"GET",
 140                 async: "true",
 141                 dataType: "json",
 142                 accepts: {json:"application/json"},
 143                 success:function(val)
 144                 {
 145                         var ok=0;
 146                         $("#esTa").empty();
 147                         $("#esTa").append("<tr><th>Nome Studente</th>");
 148                         $.each(val.utenti, function(i, item) {
 149                                 if(item!=null)
 150                                 {
 151                                         ok=1;
 152                                         var id="ut"+i;
 153                                         var tmpel='<input class="elimina" type="submit" utente='+item+' risultato="-1" value="elimina">';
 154                                         var tmpsel='<input class="selezionaUT" type="submit" utente='+item+' risultato="-1" value="seleziona">';
 155                                         $("#esTa").append($('<tr>').attr('id',id));
 156                                         $("#ut"+i).append($('<td>').text(item));
 157                                         $("#ut"+i).append($('<td></td>').append(tmpsel));
 158                                         $("#ut"+i).append($('<td></td>').append(tmpel));
 159                                 }
 160                         });
 161                         if(ok==1)
 162                                 $("#esTa").append('<button type="button" utente="all" class="selezionaUT">seleziona tutti</button>');
 163                         $(".selezionaUT").click(function(event){updateUsr(event);});
 164                         $(".elimina").click(function(event){elimina(event);});
 165                 },
 166         });
 167 }
 168
 169 function elimina(event)
 170 {
 171         var object=event.target;
 172         var query="./elimina_esercizio.php";
 173         var request=new Object();
 174         request.id=object.getAttribute("risultato");
 175         if(request.id==0)
 176                 request.esercizio=object.getAttribute("esercizio");
 177         else if(request.id<0)
 178                 request.utente=object.getAttribute("utente");
 179         var sendstr=JSON.stringify(request);
 180         $.ajax({
 181                 url:query,
 182                 type:"POST",
 183                 async: "true",
 184                 dataType: "json",
 185                 data:sendstr,
 186                 contentType: "application/json; charset=utf-8",
 187                 success:function(val)
 188                 {
 189                                 esList();
 190                                 update();
 191                                 usrList();
 192                                 updateUsr();
 193                 }
 194         });
 195 }
 196
 197 $(document).ready(function(){
 198                 esList();
 199                 usrList();
 200                 update();
 201                 updateUsr();
 202                 $(".seleziona").click(function(event){update(event);});
 203 });