Widget:LeväseurantataulukkoRotarit

<includeonly><div id="<!--{$id|default:JwAlgalTable|escape:'html'}-->_container">Ladataan tietoja</div>
<script type="text/javascript">

	function <!--{$id|default:JwAlgalTableRotary|escape:'html'}-->_jQueryTest() {
		if ( typeof window.jQuery == 'undefined' ) {
	    		setTimeout( function(){ <!--{$id|default:JwAlgalTableRotary|escape:'html'}-->_jQueryTest() }, 300);
	  	} else {
	  		<!--{$id|default:JwAlgalTableRotary|escape:'html'}-->_func();
	  	}
	}
	setTimeout( function(){ <!--{$id|default:JwAlgalTableRotary|escape:'html'}-->_jQueryTest() }, 300);

	function <!--{$id|default:JwAlgalTableRotary|escape:'html'}-->_func() {

		var lang = '<!--{$lang|default:fi|escape:'html'}-->';
		var ely = "<!--{$ely|default:ei|escape:'html'}-->";
		ely = decodeURI(ely).replace('ELY', 'elinkeino-, liikenne- ja ympäristökeskus');
		var meri = "<!--{$meri|default:2|escape:'html'}-->";
		if (meri == "Sisävedet") { meri = "0"; }
		else  if (meri == "Merialueet") { meri = "1"; }
		var rotPiiri = "<!--{$d|default:ei|escape:'html'}-->";
//var seuranta = "<!--{$seuranta|default:ei|escape:'html'}-->";

		var kunta = "<!--{$kunta|default:ei|escape:'html'}-->";

		var qtId = "<!--{$id|default:algalTable|escape:'html'}-->";

		var expert;
		var edit = "<!--{$edit|default:noedit|escape:'html'}-->";
		if (edit == 'edit') { expert = true; }
		else { expert = false; }

		var curDate = new Date();
		var curYear = curDate.getFullYear();
		var curWeek = curDate.getWeekNumber();
		var useYear = curYear;
		if (<!--{$vuosi|default:0|escape:'html'}--> != 0) {
			useYear = <!--{$vuosi|default:0|escape:'html'}-->;
		}

		var minWeek = <!--{$minWeek|default:23|escape:'html'}-->;		
		var maxWeek = <!--{$maxWeek|default:39|escape:'html'}-->;
		
		var meripaikkoja = false;
		var numberOfRows = 0;
		var maxRows;

		var exportCsv = "";

		var searchStr = "action=ask&query=[[Luokka:Paikka]]";
		searchStr += encodeURI("[[Luokka:Nykyinen leväseurannan havaintopaikka]][[Luokka:RotaryBalticSea havaintopaikka]]");
		if ( rotPiiri != 'ei' ) { searchStr += '[[Sub-campaign::Piiri ' + rotPiiri + ']]';}
		if (ely != "ei") { searchStr += encodeURI("[[ELY-keskus::" + ely + "]]"); }
		//if (kunta != "ei") { searchStr += encodeURI("[[Kunta::" + kunta + "]]"); }
		if (meri == "0") { searchStr += encodeURI("[[Vesistö::Järvi||Joki]]"); }
		else if (meri == "1") { searchStr += encodeURI("[[Vesistö::Meri]]"); }

		searchStr += encodeURI("|?SiteID|?Vesistö|?Järvi|?Vesistöalue|?Kunta|sort=Kunta,Alue|limit=10000"); //|sort=Vesistö,Järvi,Vesistöalue,Kunta
		searchStr += '&format=json';
		//console.log(searchStr);
		function progressIndicator(d) {
			jQuery('#<!--{$id|default:JwAlgalTable|escape:'html'}-->_container').html('Ladataan tietoja (' + (maxRows-d) + '/' + maxRows + ')');
		}

		function success(request) {

			reqSuccess = true;

			if (request.query.results != undefined) {

				var resultObj;
				var resultArr = new Array();

				zi = -1;						
				for (var i in request.query.results) {
					//console.log( request.query.results[i] );
					zi++;
					siteName = request.query.results[i].fulltext;
					resultItem = request.query.results[i].printouts;
					resultObj = new Object();
					resultObj.site = request.query.results[i].fulltext;
					resultObj.SiteID = resultItem.SiteID[0];
					resultObj.url = request.query.results[i].fullurl;
					resultObj.type = resultItem.Vesistö[0];
					if (resultItem.Järvi[0] != undefined ) {
						resultObj.wBody = resultItem.Järvi[0].fulltext;
						resultObj.wBodyUrl = resultItem.Järvi[0].fullurl;
					} else {
						resultObj.wBody = resultItem.Vesistöalue[0].fulltext;
						resultObj.wBodyUrl = resultItem.Vesistöalue[0].fullurl;
						if (resultObj.type == 'Meri') { meripaikkoja = true; }
					}				
					resultObj.mun = resultItem.Kunta[0].fulltext;
					resultObj.munUrl = resultItem.Kunta[0].fullurl;
					resultObj.weeks = new Array();

					resultArr[zi] = resultObj;

					var searchStr2 = "action=ask&query=";
					searchStr2 += encodeURI('[[SiteID::' + resultObj.SiteID + ']]');
					searchStr2 += encodeURI("[[Levätilanne::>0]]");
					searchStr2 += "[[Vuosi::" + useYear + "]]";
					searchStr2 += "[[Viikko::>" + minWeek.toString() + "]][[Viikko::<" + maxWeek.toString() + "]]";
					searchStr2 += encodeURI("|?Päivämäärä|?Viikko|?Levätilanne|sort=Päivämäärä|order=asc|limit=10000"); //|sort=Vesistö,Järvi,Vesistöalue,Kunta
					searchStr2 += '&format=json';

					numberOfRows++;

					function successRow(rowRequest) {			
						if (rowRequest.query.results != undefined) {

							for (var e in rowRequest.query.results) {
								week = rowRequest.query.results[e].printouts.Viikko[0];
								algalNum = rowRequest.query.results[e].printouts.Levätilanne[0];
								resultArr[this.index].weeks[week] = algalNum;
							}	
							for (var f=minWeek; f<(maxWeek+1); f++) {
								if (resultArr[this.index].weeks[f] == undefined) {
									resultArr[this.index].weeks[f] = -1;
								}
							}
						}

						numberOfRows--;
						progressIndicator(numberOfRows);
						if (numberOfRows < 1) { dataReady(); }
					}
					
					jQuery.ajax({
						type: 'GET',
						url: queryApi,
						data: searchStr2,
						success: successRow,
						error: function(e) { numberOfRows--; }, 
						dataType: 'jsonp',
						index: zi
					});

					function dataReady() {

						var output = "";
						output += '<div class="mw-content-ltr">'
						output += '<table width="100%" class="tablesorter sortable jquery-tablesorter wikitable smwtable smalltable2 tablecompact" id="<!--{$id|default:JwAlgalTable|escape:'html'}-->" >';
						output += '<thead><tr>';
						output += '<th class="headerSort" style="text-align: left;"></th>';
						output += '<th class="headerSort" style="text-align: left;">Vesistö</th>';
						output += '<th class="headerSort" style="text-align: left;">Nimi</th>';
						output += '<th class="headerSort" style="text-align: left;">Kunta</th>';
						
						for (var f=minWeek; f<(maxWeek+1); f++) {
							output += '<th class="headerSort headerSortSmall headerSort-compact" style="text-align: center;">' + f + '</th>';
						}
						
						output += '</tr></thead><tbody>';
						//exportCsv = "Havaintopaikka;Vesistö;Merialue;Kunta;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37;38;39";

						for (c = 0; c < resultArr.length; c++) {
							output += '<tr>';
							if (resultArr[c].type == 'Meri') {
								output += '<td data-sort-value="1" valign="middle" class="smwtype_qty">';
								output += '<a href="' + resultArr[c].url + '">';
								output += '<img alt="Merialue" src="//www.jarviwiki.fi/w/images/a/ac/Pm_hp_asiantuntija_1_27x27.png" width="27" height="27" style="vertical-align: middle" />';
								output += '</a></td>';
							} else {
								output += '<td data-sort-value="0" valign="middle" class="smwtype_qty">';
								output += '<a href="' + resultArr[c].url + '">';
								output += '<img alt="Sisävesi" src="//www.jarviwiki.fi/w/images/f/f3/Pm_hp_asiantuntija_2_27x27.png" width="27" height="27" style="vertical-align: middle" />';
								output += '</a></td>';
							}
							output += '<td class="smwtype_wpg"><a href="' +  resultArr[c].wBodyUrl + '">' + resultArr[c].wBody + '</a></td>';

							nimi = resultArr[c].site;
							nimi = nimi.substr(nimi.lastIndexOf('/'));
							if (nimi.indexOf('(') != -1) {
								nimi = nimi.substr(nimi.indexOf('('));
								nimi = nimi.substr(1);
								nimi = nimi.substr(0, nimi.length-1);
							} else {
								nimi = '';
							}
							output += '<td class="smwtype_wpg"><a href="' + resultArr[c].url + '">' + nimi + '</a></td>';
							output += '<td class="smwtype_wpg"><a href="' + resultArr[c].munUrl + '">' + resultArr[c].mun + '</a></td>';
							for (var d = minWeek; d < (maxWeek+1); d++) {
								switch (resultArr[c].weeks[d]) {
									case -1:
										if (expert && d == curWeek) {
											output += '<td data-sort-value="-1" class="smwtype_qty" style="text-align: center; vertical-align: middle; background-color:none;">';
											output += '<a href="//www.jarviwiki.fi/wiki/Toiminnot:Lomakemuokkaus/Lev%C3%A4havainto/' + encodeURI(resultArr[c].site) + '">[+]</a>';
											output += '</td>';
										} else {
											output += '<td data-sort-value="-1" class="smwtype_qty" style="text-align: center; vertical-align: middle; background-color:none;">-</td>';
										}
										break;
									case 0:
										output += '<td data-sort-value="0" class="smwtype_qty" style="text-align: center; vertical-align: middle; background-color:none;">0</td>';
										break;
									case 1:
										output += '<td data-sort-value="1" class="smwtype_qty" style="text-align: center; vertical-align: middle; background-color:#6a9d38;">1</td>';
										break;
									case 2:
										output += '<td data-sort-value="2" class="smwtype_qty" style="text-align: center; vertical-align: middle; background-color:#fd9f00;">2</td>';
										break;
									case 3:
										output += '<td data-sort-value="3" class="smwtype_qty" style="text-align: center; vertical-align: middle; background-color:#c80000;">3</td>';
										break;
								}

							}
							output += '</tr>';
						}
						output += '</tbody><tfoot></tfoot></table></div>';

						jQuery("#<!--{$id|default:JwAlgalTable|escape:'html'}-->_container").html(output);
						jQuery("#<!--{$id|default:JwAlgalTable|escape:'html'}-->").tablesorter();
					}
				}
				maxRows = zi+1;
			}
		}
		
		jQuery.ajax({
			type: 'GET',
			url: queryApi,
			data: searchStr,
			success: success,
			dataType: 'jsonp'
		});

		function lataaTiedot() {
		   var newWindow = window.open("","Lataa","width=300,height=300,scrollbars=1,resizable=1");

		    newWindow.document.open();
		    newWindow.document.write(exportCsv);
		    newWindow.document.close();

			//window.open('data:text/csv;charset=utf-8,' + escape(exportCsv));
		}

	}
</script></includeonly>