<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="et">
	<id>http://www.lambda.ee/w/index.php?action=history&amp;feed=atom&amp;title=Filtriga_kontrolli_n%C3%A4ide</id>
	<title>Filtriga kontrolli näide - Redigeerimiste ajalugu</title>
	<link rel="self" type="application/atom+xml" href="http://www.lambda.ee/w/index.php?action=history&amp;feed=atom&amp;title=Filtriga_kontrolli_n%C3%A4ide"/>
	<link rel="alternate" type="text/html" href="http://www.lambda.ee/w/index.php?title=Filtriga_kontrolli_n%C3%A4ide&amp;action=history"/>
	<updated>2026-10-28T14:13:23Z</updated>
	<subtitle>Selle lehekülje redigeerimiste ajalugu</subtitle>
	<generator>MediaWiki 1.43.11</generator>
	<entry>
		<id>http://www.lambda.ee/w/index.php?title=Filtriga_kontrolli_n%C3%A4ide&amp;diff=15510&amp;oldid=prev</id>
		<title>Tammet – 14. veebruar 2019, kell 17:58</title>
		<link rel="alternate" type="text/html" href="http://www.lambda.ee/w/index.php?title=Filtriga_kontrolli_n%C3%A4ide&amp;diff=15510&amp;oldid=prev"/>
		<updated>2019-02-14T17:58:47Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;et&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;←Vanem redaktsioon&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Redaktsioon: 14. veebruar 2019, kell 19:58&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l48&quot;&gt;48. rida:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;48. rida:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;   for(rownr=0; rownr&amp;lt;rows.length; rownr++) {     &lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;   for(rownr=0; rownr&amp;lt;rows.length; rownr++) {     &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;     row=rows[rownr];&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;     row=rows[rownr];&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;	if (!sisu || row[&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;1&lt;/del&gt;]==sisu) {&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;	if (!sisu || row[&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;0&lt;/ins&gt;]==sisu) {&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;		result=result+&amp;quot;\n&amp;lt;tr&amp;gt;&amp;quot;;	&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;		result=result+&amp;quot;\n&amp;lt;tr&amp;gt;&amp;quot;;	&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;		// loop over columns in one row&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;		// loop over columns in one row&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;

&lt;!-- diff cache key lambdadb:diff:1.41:old-15509:rev-15510:php=table --&gt;
&lt;/table&gt;</summary>
		<author><name>Tammet</name></author>
	</entry>
	<entry>
		<id>http://www.lambda.ee/w/index.php?title=Filtriga_kontrolli_n%C3%A4ide&amp;diff=15509&amp;oldid=prev</id>
		<title>Tammet: Uus lehekülg: &#039;&lt;pre&gt; &lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head&gt; &lt;title&gt;demo&lt;/title&gt; &lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=UTF-8&quot;&gt; &lt;!-- read in javascript libraries for parsing csv: htt...&#039;</title>
		<link rel="alternate" type="text/html" href="http://www.lambda.ee/w/index.php?title=Filtriga_kontrolli_n%C3%A4ide&amp;diff=15509&amp;oldid=prev"/>
		<updated>2019-02-14T17:06:14Z</updated>

		<summary type="html">&lt;p&gt;Uus lehekülg: &amp;#039;&amp;lt;pre&amp;gt; &amp;lt;!DOCTYPE html&amp;gt; &amp;lt;html&amp;gt; &amp;lt;head&amp;gt; &amp;lt;title&amp;gt;demo&amp;lt;/title&amp;gt; &amp;lt;meta http-equiv=&amp;quot;Content-Type&amp;quot; content=&amp;quot;text/html; charset=UTF-8&amp;quot;&amp;gt; &amp;lt;!-- read in javascript libraries for parsing csv: htt...&amp;#039;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Uus lehekülg&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;br /&gt;
&amp;lt;!DOCTYPE html&amp;gt;&lt;br /&gt;
&amp;lt;html&amp;gt;&lt;br /&gt;
&amp;lt;head&amp;gt;&lt;br /&gt;
&amp;lt;title&amp;gt;demo&amp;lt;/title&amp;gt;&lt;br /&gt;
&amp;lt;meta http-equiv=&amp;quot;Content-Type&amp;quot; content=&amp;quot;text/html; charset=UTF-8&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;!-- read in javascript libraries for parsing csv: https://github.com/okfn/csv.js  --&amp;gt;&lt;br /&gt;
&amp;lt;script src=&amp;quot;jquery.js&amp;quot;&amp;gt;&amp;lt;/script&amp;gt; &lt;br /&gt;
&amp;lt;script src=&amp;quot;csv.js&amp;quot;&amp;gt;&amp;lt;/script&amp;gt;&lt;br /&gt;
&amp;lt;/head&amp;gt;&lt;br /&gt;
&amp;lt;body&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;h1&amp;gt;See on csv faili töötlemise demo&amp;lt;/h1&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Sisesta esimese tulba otsiv väärtus:&lt;br /&gt;
&amp;lt;input type=&amp;quot;text&amp;quot; id=&amp;quot;filter&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;button type=&amp;quot;button&amp;quot; onclick=&amp;quot;filtreeri()&amp;quot;&amp;gt;filtreeri!&amp;lt;/button&amp;gt; &lt;br /&gt;
&lt;br /&gt;
Tulemus ilmub siia:&lt;br /&gt;
&amp;lt;p&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;div id=&amp;quot;result&amp;quot;&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;p&amp;gt;&lt;br /&gt;
Andmed võetakse csv failist &amp;lt;a href=&amp;quot;data.csv&amp;quot;&amp;gt;data.csv&amp;lt;/a&amp;gt;.&lt;br /&gt;
&amp;lt;p&amp;gt;&lt;br /&gt;
Programm kasutab &amp;lt;a href=&amp;quot;https://github.com/okfn/csv.js&amp;quot;&amp;gt;csv.js&amp;lt;/a&amp;gt; teeki csv faili parsimiseks ja siis siin&lt;br /&gt;
lehe lähtekoodis olev meie oma &amp;lt;tt&amp;gt;processdata&amp;lt;/tt&amp;gt; programm, mida saad ise edasi ehitada.&lt;br /&gt;
&amp;lt;script&amp;gt;&lt;br /&gt;
&lt;br /&gt;
// processdata takes data rows, builds html string and shows it in the div above&lt;br /&gt;
var sisu;&lt;br /&gt;
&lt;br /&gt;
function filtreeri() {  &lt;br /&gt;
  sisu=document.getElementById(&amp;quot;filter&amp;quot;).value;&lt;br /&gt;
  //alert(sisu);&lt;br /&gt;
  drawdata();&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
function processdata(rows) {&lt;br /&gt;
  &lt;br /&gt;
  var rownr, colnr, row, el;&lt;br /&gt;
  var result;&lt;br /&gt;
  &lt;br /&gt;
  // build the result html string&lt;br /&gt;
  result=&amp;quot;&amp;lt;table&amp;gt;&amp;quot;;&lt;br /&gt;
  // loop over all rows&lt;br /&gt;
  for(rownr=0; rownr&amp;lt;rows.length; rownr++) {    &lt;br /&gt;
    row=rows[rownr];&lt;br /&gt;
	if (!sisu || row[1]==sisu) {&lt;br /&gt;
		result=result+&amp;quot;\n&amp;lt;tr&amp;gt;&amp;quot;;	&lt;br /&gt;
		// loop over columns in one row&lt;br /&gt;
		for(colnr=0; colnr&amp;lt;row.length; colnr++) {&lt;br /&gt;
		  el=row[colnr];		  &lt;br /&gt;
		  if (rownr==0) {&lt;br /&gt;
			result=result+&amp;quot;&amp;lt;th&amp;gt;&amp;lt;b&amp;gt;&amp;quot;+el+&amp;quot;&amp;lt;/b&amp;gt;&amp;lt;/th&amp;gt;&amp;quot;; &lt;br /&gt;
		  } else {&lt;br /&gt;
			result=result+&amp;quot;&amp;lt;td&amp;gt;&amp;quot;+el+&amp;quot;&amp;lt;/td&amp;gt;&amp;quot;;&lt;br /&gt;
		  }				  &lt;br /&gt;
		}&lt;br /&gt;
		result=result+&amp;quot;&amp;lt;/tr&amp;gt;&amp;quot;;&lt;br /&gt;
    }		 &lt;br /&gt;
  }&lt;br /&gt;
  // put the result html string into the div on the page&lt;br /&gt;
  console.log(result);&lt;br /&gt;
  document.getElementById(&amp;quot;result&amp;quot;).innerHTML=result;  &lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
// take raw csv data, parse it into rows and then call processdata with the result&lt;br /&gt;
// we use the CSV library from https://github.com/okfn/csv.js &lt;br /&gt;
&lt;br /&gt;
function drawdata() {&lt;br /&gt;
	CSV.fetch({&lt;br /&gt;
		// several options to give input, by default we use the file data.csv&lt;br /&gt;
		//url: &amp;#039;data.csv&amp;#039;&lt;br /&gt;
		&lt;br /&gt;
		// alternatively put raw data here like this:&lt;br /&gt;
		data: //&amp;quot;esimene;teine\na;1\nb;2&amp;quot;&lt;br /&gt;
	&amp;quot;aaa,bb,cc,dd\n&amp;quot;+&lt;br /&gt;
	&amp;quot;a1,as2,d$$d,11\n&amp;quot;+&lt;br /&gt;
	&amp;quot;443,22,2,2ö$$öö\n&amp;quot;&lt;br /&gt;
		&lt;br /&gt;
		// also an alternative&lt;br /&gt;
		//file: an HTML 5 file object&lt;br /&gt;
&lt;br /&gt;
		// optional options about structure of the CSV file&lt;br /&gt;
		// following the CSV Dialect Description Format &lt;br /&gt;
		// https://frictionlessdata.io/specs/csv-dialect/&lt;br /&gt;
		/*&lt;br /&gt;
		dialect: {&lt;br /&gt;
		  ...&lt;br /&gt;
		}&lt;br /&gt;
		*/&lt;br /&gt;
	  }&lt;br /&gt;
	).done(function(dataset) {  &lt;br /&gt;
	  // console.log(dataset); // optional debugging    &lt;br /&gt;
	  var allrows;&lt;br /&gt;
	  // put the dataset field list and dataset records into one array of all rows&lt;br /&gt;
	  allrows=dataset.records;&lt;br /&gt;
	  allrows.unshift(dataset.fields);  &lt;br /&gt;
	  // call our program for building html&lt;br /&gt;
	  processdata(allrows);&lt;br /&gt;
	});&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
drawdata();&lt;br /&gt;
	&lt;br /&gt;
&amp;lt;/script&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/body&amp;gt;&lt;br /&gt;
&amp;lt;/html&amp;gt; &lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Tammet</name></author>
	</entry>
</feed>