# HG changeset patch
# User Pascal Bellard <pascal.bellard@slitaz.org>
# Date 1385666713 0
# Node ID 136be2b3c08581be175338e7cfa902fb54a8f574
# Parent  63b1f79f8bd9b92ec46ee04b5bafe68d48b736fe
wikiss: add Calc plugin

diff -r 63b1f79f8bd9 -r 136be2b3c085 wikiss/stuff/plugins/wkp_Calc.css
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/wikiss/stuff/plugins/wkp_Calc.css	Thu Nov 28 19:25:13 2013 +0000
@@ -0,0 +1,31 @@
+.bordercalc {
+    background-color: #ccc;
+    font-weight: bold;
+    text-align: center;
+    border: 1px solid #999;
+    padding: 0;
+}
+
+.inputcalc {
+    border: none;
+    width: 80px;
+    font-size: 14px;
+    padding: 2px;
+}
+
+.inputcalc:hover {
+    background-color: #eee;
+}
+
+.inputcalc:focus {
+    background-color: #ccf;
+}
+
+.tablecalc {
+    border-collapse: collapse;  
+}
+
+.cellcalc {
+    border: 1px solid #999;
+    padding: 0;
+}
diff -r 63b1f79f8bd9 -r 136be2b3c085 wikiss/stuff/plugins/wkp_Calc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/wikiss/stuff/plugins/wkp_Calc.php	Thu Nov 28 19:25:13 2013 +0000
@@ -0,0 +1,173 @@
+<?php # coding: utf-8
+
+class Calc
+{
+   public $description = "Feuille de calcul au format CSV";
+   
+   var $lines = 0, $rows = 0, $cnt = 0, $gotcalc = 0, $line = array();
+   var $newCONTENT;
+   function showcalc()
+   {
+      if ($this->lines > 1 && $this->rows > 1) {
+         $id = "C".(100+$this->cnt++); 
+         $this->newCONTENT .= "<noscript><a href=\"http://www.enable-javascript.com/\" target=\"_blank\">Enable javascript to see the spreadsheet ".$id."</a></noscript>\n";
+         $this->newCONTENT .= "<table id=\"".$id."\" class=\"tablecalc\"></table>\n";
+         $this->newCONTENT .= "<script type=\"text/javascript\">\n";
+         $this->newCONTENT .= "<!--\n";
+         $this->newCONTENT .= "buildCalc(\"".$id."\",".$this->lines.",".$this->rows.");\n";
+         for ($i = 1; $i <= $this->lines; $i++) {
+            $this->line[$i] = preg_replace("/&lt;/","<",$this->line[$i]);
+            for ($tmp = explode(";",$this->line[$i]), $j = 0; $j < count($tmp) -1; $j++) {
+               if ($tmp[$j] == "") continue;
+               $tmp[$j] = preg_replace("/\"/","\\\\\"",$tmp[$j]);
+               $s = "setCell(document.getElementById(\"".$id;
+               $this->newCONTENT .= $s.chr(ord('A')+$j).$i."\"), \"".$tmp[$j]."\")\n";
+            }
+         }
+         $this->newCONTENT .= "//-->\n";
+         $this->newCONTENT .= "</script>\n";
+      }
+      else for ($i = 1; $i <= $this->lines; $i++)
+         $this->newCONTENT .= $this->line[$i]."\n";
+      $this->rows = $this->lines = $this->gotcalc = 0;
+   }
+
+   function formatEnd()
+   {
+      global $CONTENT;
+      $headdone = $gotcalc = $showtail = $this->lines = 0;
+      $this->newCONTENT = "";
+      $CONTENT = preg_replace("/<br \/>/","<br />\n",$CONTENT);
+      foreach (explode("\n", $CONTENT) as $current) {
+      	 if ($current == "") continue;
+         if (preg_match("/;<br \/>$/", $current)) {
+            $gotcalc = 1;
+            if (!$headdone) {
+               $headdone = 1;
+               $showtail = 1;
+               $this->newCONTENT .= <<<EOT
+<!-- Based on http://jsfiddle.net/ondras/hYfN3/ by Ondřej Žára -->
+<script type="text/javascript">
+<!--
+function csv(id,rows,cols) {
+    var data = "";
+    for (var i=1; i<=rows; i++) {
+	for (var j=1; j<=cols; j++) {
+            var letter = String.fromCharCode("A".charCodeAt(0)+j-1);
+	    data += document.getElementById(id+letter+i).title+';';
+	}
+	data += "\\n";
+    }
+    alert(data);
+}
+
+var DATA={};
+function buildCalc(id, rows, cols) {
+    DATA[id] = {};
+    var maths = [ "abs", "acos", "asin", "atan", "atan2", "ceil", "cos", "exp",
+		  "floor", "log", "max", "min", "pow", "random", "round", "sin",
+		  "tan", "sqrt", "PI", "E" ];
+    for (var i=0; v = maths[i]; i++)
+	eval("DATA[id]."+v+" = DATA[id]."+v.toUpperCase()+" = Math."+v);
+    DATA[id].rand = DATA[id].RAND = Math.random;
+    DATA[id].ln   = DATA[id].LN   = Math.log;
+    DATA[id].log10= DATA[id].LOG10= function(n){return Math.log(n)/Math.LN10;};
+    DATA[id].log2 = DATA[id].LOG2 = function(n){return Math.log(n)/Math.LN2;};
+    DATA[id].fact = DATA[id].FACT = 
+	function(n){var x=1;while(n>1)x*=n--;return x;};
+    DATA[id].fib  = DATA[id].FIB  = 
+	function(n){var c=0,p=1;while(n-->0){var x=c;c+=p;p=x};return c;};
+    for (var i=0; i<=rows; i++) {
+        var row = document.getElementById(id).insertRow(-1);
+        for (var j=0; j<=cols && j<=26; j++) {
+            var letter = String.fromCharCode("A".charCodeAt(0)+j-1);
+	    var cell = row.insertCell(-1);
+	    if (i&&j) {
+		cell.className = "cellcalc";
+		cell.innerHTML = "<input id='"+ id+letter+i +"' class='inputcalc'/>";
+	    }
+	    else {
+		cell.className = "bordercalc";
+		cell.title = "Show CSV";
+		cell.onclick = function(){csv(id,rows,cols);};
+		cell.innerHTML = (i||j) ? i||letter : "&radic;";
+	    }
+        }
+    }
+}
+
+function getWidth(s)
+{
+	var e = document.getElementById("widthcalc");
+	e.innerHTML = s+" :";
+	return (e.offsetWidth < 80 || s.charAt(0) == "=") ? 80 : e.offsetWidth;
+}
+
+function setCell(e, v)
+{
+    e.style.width = getWidth(v)+"px";
+    e.style.textAlign = 
+	(isNaN(parseFloat(v)) && v.charAt(0) != "=") ? "left" : "right";
+    e.title = v;
+}
+//-->
+</script>
+<span id="widthcalc" class="cellcalc" style="visibility:hidden;"></span>
+EOT;
+            }
+            $this->line[++$this->lines] = $current;
+            $current = preg_replace("/&lt;/","<",$current);
+            $i = count(explode(";", $current))-1;
+            if ($this->lines == 1) $this->rows = $i;
+            if ($i != $this->rows) $this->rows = -1;
+         }
+         else {
+            if ($gotcalc) $this->showcalc();
+            $this->newCONTENT .= $current."\n";
+         }
+      }
+      if ($gotcalc) $this->showcalc();
+      if ($showtail) {
+         $this->newCONTENT .= <<<EOT
+<script type="text/javascript">
+<!--
+var INPUTS=[].slice.call(document.getElementsByClassName("inputcalc"));
+INPUTS.forEach(function(elm) {
+    elm.onfocus = function(e) {
+        e.target.value = e.target.title || "";
+    };
+    elm.onblur = function(e) {
+	setCell(e.target, e.target.value);
+        computeAll();
+    };
+    var calcid = elm.id.substring(0,4), cellid = elm.id.substring(4);
+    var getter = function() {
+        var value = elm.title || "";
+        if (value.charAt(0) == "=")
+		with (DATA[calcid]) return eval(value.substring(1));
+        else return isNaN(parseFloat(value)) ? value : parseFloat(value);
+    };
+    Object.defineProperty(DATA[calcid], cellid, {get:getter});
+    Object.defineProperty(DATA[calcid], cellid.toLowerCase(), {get:getter});
+});
+(window.computeAll = function() {
+    INPUTS.forEach(function(elm) {
+	var calcid = elm.id.substring(0,4), cellid = elm.id.substring(4);
+	try { elm.value = DATA[calcid][cellid]; } catch(e) {} });
+})();
+//-->
+</script>
+EOT;
+      }
+      $CONTENT = $this->newCONTENT;
+   }
+
+   function template()
+   {
+      global $html;
+      $html = preg_replace("/<\/head>/",
+      "\t<style type=\"text/css\"> @import \"plugins/wkp_Calc.css\"; </style>\n</head>",
+      $html);
+   }
+}
+?>