Ero sivun ”Widget:LeväseurantataulukkoALL” versioiden välillä
Järvi-meriwikistä
p (Tekstin korvaus – ”|limit=1000” muotoon ”|limit=2000”) |
|||
(18 välissä olevaa versiota samalta käyttäjältä ei näytetä) | |||
Rivi 69: | Rivi 69: | ||
else if (meri == "1") { searchStr += encodeURI("[[Vesistö::Meri]]"); } | else if (meri == "1") { searchStr += encodeURI("[[Vesistö::Meri]]"); } | ||
− | searchStr += encodeURI("|?SiteID|?Vesistö|?Järvi|?Päävesistö|?Vesistöalue|?Kunta|sort= | + | searchStr += encodeURI("|?SiteID|?KoordPohj|?KoordIta|?Vesistö|?Järvi|?Päävesistö|?Vesistöalue|?Kunta|sort=Päävesistö,Kunta|order=desc,asc|limit=20000"); //|sort=Vesistö,Järvi,Vesistöalue,Kunta |
searchStr += '&format=json'; | searchStr += '&format=json'; | ||
Rivi 77: | Rivi 77: | ||
function success(request) { | function success(request) { | ||
− | console.log(request); | + | //console.log(request); |
reqSuccess = true; | reqSuccess = true; | ||
Rivi 91: | Rivi 91: | ||
resultItem = request.query.results[i].printouts; | resultItem = request.query.results[i].printouts; | ||
resultObj = new Object(); | resultObj = new Object(); | ||
+ | resultObj.hasObses = false; | ||
resultObj.site = request.query.results[i].fulltext; | resultObj.site = request.query.results[i].fulltext; | ||
resultObj.SiteID = resultItem.SiteID[0]; | resultObj.SiteID = resultItem.SiteID[0]; | ||
Rivi 104: | Rivi 105: | ||
} | } | ||
resultObj.basin = resultItem["Päävesistö"][0].fulltext; | resultObj.basin = resultItem["Päävesistö"][0].fulltext; | ||
+ | //console.log( resultObj.basin.split( '(' ) ); | ||
+ | //console.log( resultObj.basin.split( '(' )[1] ); | ||
+ | basinNrTemp = resultObj.basin.split( '(' )[1]; | ||
+ | resultObj.basinNr = basinNrTemp.split( ')' )[0]; | ||
+ | |||
+ | console.log(resultObj.basinNr); | ||
+ | resultObj.lat = resultItem.KoordPohj[0]; | ||
+ | resultObj.lon = resultItem.KoordIta[0]; | ||
+ | //resultObj.order = (100-resultObj.basinNr*-1)*1000; | ||
+ | |||
resultObj.mun = resultItem.Kunta[0].fulltext; | resultObj.mun = resultItem.Kunta[0].fulltext; | ||
resultObj.munUrl = resultItem.Kunta[0].fullurl; | resultObj.munUrl = resultItem.Kunta[0].fullurl; | ||
Rivi 115: | Rivi 126: | ||
searchStr2 += "[[Vuosi::" + useYear + "]]"; | searchStr2 += "[[Vuosi::" + useYear + "]]"; | ||
searchStr2 += "[[Viikko::>" + minWeek.toString() + "]][[Viikko::<" + maxWeek.toString() + "]]"; | searchStr2 += "[[Viikko::>" + minWeek.toString() + "]][[Viikko::<" + maxWeek.toString() + "]]"; | ||
− | searchStr2 += encodeURI("|?Päivämäärä|?Viikko|?Levätilanne|sort=Päivämäärä|order=asc|limit= | + | searchStr2 += encodeURI("|?Päivämäärä|?Viikko|?Levätilanne|sort=Päivämäärä|order=asc|limit=20000"); //|sort=Vesistö,Järvi,Vesistöalue,Kunta |
searchStr2 += '&format=json'; | searchStr2 += '&format=json'; | ||
Rivi 127: | Rivi 138: | ||
algalNum = rowRequest.query.results[e].printouts.Levätilanne[0]; | algalNum = rowRequest.query.results[e].printouts.Levätilanne[0]; | ||
resultArr[this.index].weeks[week] = algalNum; | resultArr[this.index].weeks[week] = algalNum; | ||
+ | resultArr[this.index].hasObses = true; | ||
} | } | ||
for (var f=minWeek; f<(maxWeek+1); f++) { | for (var f=minWeek; f<(maxWeek+1); f++) { | ||
Rivi 151: | Rivi 163: | ||
function dataReady() { | function dataReady() { | ||
− | console.log( resultArr ); | + | |
+ | //console.log( resultArr ); | ||
+ | |||
var output = ""; | var output = ""; | ||
output += '<div class="mw-content-ltr">' | output += '<div class="mw-content-ltr">' | ||
Rivi 157: | Rivi 171: | ||
output += '<thead><tr>'; | output += '<thead><tr>'; | ||
output += '<th class="headerSort" style="text-align: left;"></th>'; | 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;">Vesistö</th>'; |
+ | output += '<th class="headerSort" style="text-align: left;">Nimi</th>'; | ||
output += '<th class="headerSort" style="text-align: left;">Päävesistö</th>'; | output += '<th class="headerSort" style="text-align: left;">Päävesistö</th>'; | ||
− | |||
output += '<th class="headerSort" style="text-align: left;">Kunta</th>'; | output += '<th class="headerSort" style="text-align: left;">Kunta</th>'; | ||
Rivi 169: | Rivi 183: | ||
//exportCsv = "Havaintopaikka;Vesistö;Merialue;Kunta;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37;38;39"; | //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++) { | + | for (c = 0; c < resultArr.length; c++) { |
− | output += '<tr>'; | + | |
− | + | if ( resultArr[ c ].hasObses ) { | |
− | + | ||
− | + | 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">' + nimi + '</td>'; | ||
+ | |||
+ | output += '<td data-sort-value="' + resultArr[c].basinNr + '" class="smwtype_qty">' + resultArr[c].basin + '</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>'; | output += '</tbody><tfoot></tfoot></table></div>'; | ||
Rivi 234: | Rivi 254: | ||
jQuery("#<!--{$id|default:JwAlgalTable|escape:'html'}-->_container").html(output); | jQuery("#<!--{$id|default:JwAlgalTable|escape:'html'}-->_container").html(output); | ||
jQuery("#<!--{$id|default:JwAlgalTable|escape:'html'}-->").tablesorter(); | jQuery("#<!--{$id|default:JwAlgalTable|escape:'html'}-->").tablesorter(); | ||
+ | jQuery("#<!--{$id|default:JwAlgalTable|escape:'html'}-->").find("th:contains(Päävesistö)").trigger("sort"); | ||
} | } | ||
} | } |