//********************************************************************************************************************************************************
// Statistische Auswertung
//********************************************************************************************************************************************************
function getstats(queryparam) {

    var querytype = queryparam;

    var anz4stat = document.getElementById("anz_toplisting").value;

    anz4stat=Number(anz4stat);

    if(isNaN(anz4stat) || anz4stat == "")
    {
/**traduction**/
     alert("You must enter a number!");
     return;
    }
    else {
     if (anz4stat<=0) {
/**traduction**/
          alert("The number must be greater than 0!");
          return;
     }
     else {
          queryparam = queryparam + "&anz4stats=" + anz4stat;
     }
    }

/**traduction**/
    document.getElementById("stat_result_container").innerHTML = 'Getting Statistics...';

    var getVars =  "?queryparam=" + queryparam;

	//tell the request where to retrieve data from.
	//request.open('GET', 'retrieveMarkers.php', true);
     if (xmlHttp.readyState == 4 || xmlHttp.readyState == 0){

	//open the request to map_data.php on your server
      	xmlHttp.open('GET', 'getstats.php' + getVars, true);

	//tell the request what to do when the state changes.
	xmlHttp.onreadystatechange = function() {
		if (xmlHttp.readyState == 4) {
                  if (xmlHttp.status == 200){

                    var xmlResponse = xmlHttp.responseXML.documentElement;
                    var xml = xmlHttp.responseXML;

                    if(xml)
                    {
                      var totAnzRecs = xml.getElementsByTagName("tot_recs")[0].firstChild.data;

                      if (querytype == 'anwender') {
                      //Namen entsprechen den Spaltennamen in der DB
                         statuser = xml.getElementsByTagName("stat_usr");
                         user = xml.getElementsByTagName("anwender");
                         anzahluser = xml.getElementsByTagName("anzahluser");

                        //Statistik User:
                        if(statuser.length>0) {
                          var totAnzusr = xml.getElementsByTagName("tot_usr")[0].firstChild.data;
//                          var usrhtml = 'Die folgenden Anwender (Total:' + totAnzusr + ') haben massgeblich an der Erfassung der Adressen mitgearbeitet (Gesamtzahl Adressen:' + totAnzRecs + '):<br><br>';
//                          var usrhtml = 'Die folgenden Anwender (Total:' + totAnzusr + ') haben massgeblich an der Erfassung der Adressen mitgearbeitet:<br><br>';
/**traduction**/
                          var usrhtml = 'The following users (Total: ' + totAnzusr + ') have significantly collaborated to capture the data (Total number of addresses: ' + totAnzRecs + '):<br><br>';
                          var usrhtml = usrhtml + '<table border="0" cellspacing="5" cellpadding="0">'
                                + '<tr><td><b>user: </b></td><td></td><td><b>Rating:</b></td><td></td><td><b>number of addresses: </b></td></tr>' ;
/*bis hierher*/
                          for(i=0;i<statuser.length;i++)
                          {
                            curuser = user[i].firstChild.data;
                            curanz = anzahluser[i].firstChild.data;

                            //Ermitteln, ob der Anwender einen oder mehrere Pins erhält
                            var htmlcode4pindisplay ="";
                            if (curanz>=100) {
                                htmlcode4pindisplay = check4pin(curanz);
                            }
                            usrhtml = usrhtml
  				+ '<tr><td>' + curuser + '<td>&#160;&#160;</td><td>' + htmlcode4pindisplay + '</td>' + '</td><td>&#160;&#160;</td><td>' + curanz + '</td></tr>';

                          } //for
                          //HTML nachführen:
//                          document.getElementById("users").innerHTML = usrhtml;
                          usrhtml = usrhtml + '</table>';

                          document.getElementById("stat_result_container").innerHTML = usrhtml;
                          document.getElementById("stat_result_container").style.visibility = 'visible';

                        } //if
                      } // if  (querytype == 'anwender')


                      if (querytype == 'ort') {

                      statorte = xml.getElementsByTagName("stat_places");
                      ort = xml.getElementsByTagName("ort");
                      anzahlorte = xml.getElementsByTagName("anzahlorte");

                      //Statistik Orte:
                      if(statorte.length>0) {
                        var totAnzort = xml.getElementsByTagName("tot_ort")[0].firstChild.data;
//                        var totAnzRecs = xml.getElementsByTagName("tot_recs")[0].firstChild.data;
//                        var usrhtml = 'Aus den folgenden Orten (Total:' + totAnzort + ') wurden bisher Adressen erfasst (Gesamtzahl Adressen:' + totAnzRecs + '):<br><br>';
/**traduction**/
                        var usrhtml = 'From the following locations (Total: ' + totAnzort + ') addresses have been captured (Total number of addresses: ' + totAnzRecs + '):<br><br>';
                        var usrhtml = usrhtml + '<table border="0" cellspacing="10" cellpadding="0">'
                              + '<tr><td><b>location: </b></td><td><b>number of addresses: </b></td></tr>';
/* bis hierher!!!*/

                        for(i=0;i<statorte.length;i++)
                        {
                          curort = ort[i].firstChild.data;
                          curanz = anzahlorte[i].firstChild.data;

                          usrhtml = usrhtml
				+ '<tr><td>' + curort + '</td><td>' + curanz + '</td></tr>';

                        } //for
                        //HTML nachführen:
                        document.getElementById("stat_result_container").innerHTML = usrhtml;
                        document.getElementById("stat_result_container").innerHTML = usrhtml;
                        document.getElementById("stat_result_container").style.visibility = 'visible';

                        } //if
                      } //  (querytype == 'ort')
                    } //if
	       } //if
	    } //if
	} //function

	xmlHttp.send(null);
     } //if
}

function check4pin(anzahl) {
var htmlcodewithpin = "";
var x = 0;
  //erhält der User überhaupt einen Pin?
  if (anzahl>=100) {
     if (anzahl>=1000) {
       if (anzahl>=10000) {
           if (anzahl>=100000) {
               do {
                    htmlcodewithpin = htmlcodewithpin + '<img src="img/pin_100000_kl.gif" alt="pin_100000">';
                    x = x + 100000;
                  } while (x + 100000 <= anzahl);
               return htmlcodewithpin;
           }  // if (anzahl>100000)
           do {
                htmlcodewithpin = htmlcodewithpin + '<img src="img/pin_10000_kl.gif" alt="pin_10000">';
                x = x + 10000;
              } while (x + 10000 <= anzahl);
           return htmlcodewithpin;
       }  // if (anzahl>10000)

       do {
            htmlcodewithpin = htmlcodewithpin + '<img src="img/pin_1000_kl.gif" alt="pin_1000">';
            x = x + 1000;
          } while (x + 1000 <= anzahl);
       return htmlcodewithpin;
     }  // if (anzahl>1000)

     do {
                htmlcodewithpin = htmlcodewithpin + '<img src="img/pin_100_kl.gif" alt="pin_100">';
          x = x + 100;
        } while (x + 100 <= anzahl);
     return htmlcodewithpin;
  }
  else {
       return;
  }    //end else if anz>100

}