rev |
line source |
pascal@200
|
1 plugin="Calc"
|
pascal@203
|
2 description_fr="Feuille de calcul au format CSV"
|
pascal@200
|
3 description="CSV format spreadsheet"
|
pascal@200
|
4 help_fr="AideCalc"
|
pascal@200
|
5 help="HelpCalc"
|
pascal@200
|
6
|
pascal@200
|
7 case "$1" in
|
pascal@200
|
8 showhead) cat <<EOT
|
pascal@200
|
9 <!-- Based on http://jsfiddle.net/ondras/hYfN3/ by Ondřej Žára -->
|
pascal@200
|
10 <script type="text/javascript">
|
pascal@201
|
11 <!--
|
pascal@200
|
12 function csv(id,rows,cols) {
|
pascal@200
|
13 var data = "";
|
pascal@200
|
14 for (var i=1; i<=rows; i++) {
|
pascal@200
|
15 for (var j=1; j<=cols; j++) {
|
pascal@200
|
16 var letter = String.fromCharCode("A".charCodeAt(0)+j-1);
|
pascal@200
|
17 data += document.getElementById(id+letter+i).title+';';
|
pascal@200
|
18 }
|
pascal@200
|
19 data += "\\\\n";
|
pascal@200
|
20 }
|
pascal@200
|
21 alert(data);
|
pascal@200
|
22 }
|
pascal@200
|
23
|
pascal@200
|
24 var DATA={};
|
pascal@237
|
25 function sum(id,from,to) {
|
pascal@237
|
26 var result=0
|
pascal@237
|
27 for (var l=from.charCodeAt(0);;l++) {
|
pascal@237
|
28 for (var n=parseInt(from.substring(1));
|
pascal@237
|
29 n <= parseInt(to.substring(1));n++) {
|
pascal@237
|
30 var e=document.getElementById(id+String.fromCharCode(l)+n)
|
pascal@237
|
31 result+=parseFloat(e.value)
|
pascal@237
|
32 }
|
pascal@237
|
33 if (l == to.charCodeAt(0)) break
|
pascal@237
|
34 }
|
pascal@237
|
35 return result;
|
pascal@237
|
36 }
|
pascal@200
|
37 function buildCalc(id, rows, cols) {
|
pascal@200
|
38 DATA[id] = {};
|
pascal@203
|
39 var maths = [ "abs", "acos", "asin", "atan", "atan2", "ceil", "cos", "exp",
|
pascal@203
|
40 "floor", "log", "max", "min", "pow", "random", "round", "sin",
|
pascal@203
|
41 "tan", "sqrt", "PI", "E" ];
|
pascal@203
|
42 for (var i=0; v = maths[i]; i++)
|
pascal@203
|
43 eval("DATA[id]."+v+" = DATA[id]."+v.toUpperCase()+" = Math."+v);
|
pascal@203
|
44 DATA[id].rand = DATA[id].RAND = Math.random;
|
pascal@203
|
45 DATA[id].ln = DATA[id].LN = Math.log;
|
pascal@203
|
46 DATA[id].log10= DATA[id].LOG10= function(n){return Math.log(n)/Math.LN10;};
|
pascal@203
|
47 DATA[id].log2 = DATA[id].LOG2 = function(n){return Math.log(n)/Math.LN2;};
|
pascal@203
|
48 DATA[id].fact = DATA[id].FACT =
|
pascal@204
|
49 function(n){var x=1;while(n>1)x*=n--;return x;};
|
pascal@203
|
50 DATA[id].fib = DATA[id].FIB =
|
pascal@203
|
51 function(n){var c=0,p=1;while(n-->0){var x=c;c+=p;p=x};return c;};
|
pascal@237
|
52 DATA[id].sum = DATA[id].SUM = function(a,b){return sum(id,a,b);};
|
pascal@200
|
53 for (var i=0; i<=rows; i++) {
|
pascal@200
|
54 var row = document.getElementById(id).insertRow(-1);
|
pascal@200
|
55 for (var j=0; j<=cols && j<=26; j++) {
|
pascal@200
|
56 var letter = String.fromCharCode("A".charCodeAt(0)+j-1);
|
pascal@200
|
57 var cell = row.insertCell(-1);
|
pascal@200
|
58 if (i&&j) {
|
pascal@200
|
59 cell.className = "cellcalc";
|
pascal@200
|
60 cell.innerHTML = "<input id='"+ id+letter+i +"' class='inputcalc'/>";
|
pascal@200
|
61 }
|
pascal@200
|
62 else {
|
pascal@200
|
63 cell.className = "bordercalc";
|
pascal@200
|
64 cell.title = "Show CSV";
|
pascal@200
|
65 cell.onclick = function(){csv(id,rows,cols);};
|
pascal@200
|
66 cell.innerHTML = (i||j) ? i||letter : "√";
|
pascal@200
|
67 }
|
pascal@200
|
68 }
|
pascal@200
|
69 }
|
pascal@200
|
70 }
|
pascal@200
|
71
|
pascal@200
|
72 function getWidth(s)
|
pascal@200
|
73 {
|
pascal@200
|
74 var e = document.getElementById("widthcalc");
|
pascal@236
|
75 e.innerHTML = s;
|
pascal@200
|
76 return (e.offsetWidth < 80 || s.charAt(0) == "=") ? 80 : e.offsetWidth;
|
pascal@200
|
77 }
|
pascal@200
|
78
|
pascal@200
|
79 function setCell(e, v)
|
pascal@200
|
80 {
|
pascal@200
|
81 e.style.width = getWidth(v)+"px";
|
pascal@200
|
82 e.style.textAlign =
|
pascal@200
|
83 (isNaN(parseFloat(v)) && v.charAt(0) != "=") ? "left" : "right";
|
pascal@200
|
84 e.title = v;
|
pascal@200
|
85 }
|
pascal@201
|
86 //-->
|
pascal@200
|
87 </script>
|
pascal@200
|
88 <span id="widthcalc" class="cellcalc" style="visibility:hidden;"></span>
|
pascal@200
|
89 EOT
|
pascal@200
|
90 exit 0 ;;
|
pascal@200
|
91 showtail) cat <<EOT
|
pascal@200
|
92 <script type="text/javascript">
|
pascal@201
|
93 <!--
|
pascal@200
|
94 var INPUTS=[].slice.call(document.getElementsByClassName("inputcalc"));
|
pascal@200
|
95 INPUTS.forEach(function(elm) {
|
pascal@200
|
96 elm.onfocus = function(e) {
|
pascal@200
|
97 e.target.value = e.target.title || "";
|
pascal@200
|
98 };
|
pascal@200
|
99 elm.onblur = function(e) {
|
pascal@200
|
100 setCell(e.target, e.target.value);
|
pascal@200
|
101 computeAll();
|
pascal@200
|
102 };
|
pascal@200
|
103 var calcid = elm.id.substring(0,4), cellid = elm.id.substring(4);
|
pascal@200
|
104 var getter = function() {
|
pascal@200
|
105 var value = elm.title || "";
|
pascal@200
|
106 if (value.charAt(0) == "=")
|
pascal@200
|
107 with (DATA[calcid]) return eval(value.substring(1));
|
pascal@236
|
108 else return (value == "" || isNaN(value)) ? value : parseFloat(value);
|
pascal@200
|
109 };
|
pascal@200
|
110 Object.defineProperty(DATA[calcid], cellid, {get:getter});
|
pascal@200
|
111 Object.defineProperty(DATA[calcid], cellid.toLowerCase(), {get:getter});
|
pascal@200
|
112 });
|
pascal@200
|
113 (window.computeAll = function() {
|
pascal@200
|
114 INPUTS.forEach(function(elm) {
|
pascal@200
|
115 var calcid = elm.id.substring(0,4), cellid = elm.id.substring(4);
|
pascal@200
|
116 try { elm.value = DATA[calcid][cellid]; } catch(e) {} });
|
pascal@200
|
117 })();
|
pascal@201
|
118 //-->
|
pascal@200
|
119 </script>
|
pascal@200
|
120 EOT
|
pascal@200
|
121 exit 0 ;;
|
pascal@200
|
122 esac
|
pascal@200
|
123
|
pascal@200
|
124 formatEnd()
|
pascal@200
|
125 {
|
pascal@200
|
126 CONTENT=$(awk -v prg=$plugins_dir/wkp_$plugin.sh '
|
pascal@200
|
127 function showcalc()
|
pascal@200
|
128 {
|
pascal@200
|
129 if (lines > 1 && rows > 1) {
|
pascal@200
|
130 id="C" (100+cnt++)
|
pascal@203
|
131 print "<noscript><a href=\"http://www.enable-javascript.com/\" target=\"_blank\">Enable javascript to see the spreadsheet " id "</a></noscript>"
|
pascal@200
|
132 print "<table id=\"" id "\" class=\"tablecalc\"></table>"
|
pascal@200
|
133 print "<script type=\"text/javascript\">"
|
pascal@201
|
134 print "<!--"
|
pascal@200
|
135 print "buildCalc(\"" id "\"," lines "," rows ");"
|
pascal@200
|
136 for (i = 1; i <= lines; i++) {
|
pascal@200
|
137 gsub("<","<",line[i])
|
pascal@200
|
138 for (j = 1; j < split(line[i],tmp,";"); j++) {
|
pascal@200
|
139 if (tmp[j] == "") continue
|
pascal@200
|
140 gsub("\"","\\\\\"",tmp[j])
|
pascal@200
|
141 s = "setCell(document.getElementById(\"" id
|
pascal@200
|
142 c = substr("ABCDEFGHIJKLMNOPQRSTUVWXYZ",j,1)
|
pascal@200
|
143 print s c i "\"), \"" tmp[j] "\")";
|
pascal@200
|
144 }
|
pascal@200
|
145 }
|
pascal@201
|
146 print "//-->"
|
pascal@200
|
147 print "</script>"
|
pascal@200
|
148 }
|
pascal@200
|
149 else for (i = 1; i <= lines; i++) print line[i]
|
pascal@200
|
150 rows = lines = gotcalc = 0
|
pascal@200
|
151 }
|
pascal@200
|
152 {
|
pascal@200
|
153 if (/;<br \/>$/) {
|
pascal@200
|
154 gotcalc = 1
|
pascal@200
|
155 if (!headdone) {
|
pascal@200
|
156 headdone = 1
|
pascal@200
|
157 showtail = 1
|
pascal@200
|
158 system("/bin/sh " prg " showhead")
|
pascal@200
|
159 }
|
pascal@200
|
160 line[++lines] = $0
|
pascal@200
|
161 gsub("<","<",$0)
|
pascal@200
|
162 i = split($0,tmp,";")-1
|
pascal@200
|
163 if (lines == 1) rows = i
|
pascal@200
|
164 if (i != rows) rows = -1
|
pascal@200
|
165 }
|
pascal@200
|
166 else {
|
pascal@200
|
167 if (gotcalc) showcalc()
|
pascal@200
|
168 print
|
pascal@200
|
169 }
|
pascal@200
|
170 }
|
pascal@200
|
171 END {
|
pascal@200
|
172 if (gotcalc) showcalc()
|
pascal@200
|
173 if (showtail) system("/bin/sh " prg " showtail")
|
pascal@200
|
174 }
|
pascal@200
|
175 ' <<EOT
|
pascal@200
|
176 $CONTENT
|
pascal@200
|
177 EOT
|
pascal@200
|
178 )
|
pascal@200
|
179 }
|
pascal@200
|
180
|
pascal@200
|
181 template()
|
pascal@200
|
182 {
|
pascal@200
|
183 html=$(sed 's|</head>|\t<style type="text/css"> @import "plugins/wkp_Calc.css"; </style>\n&|' <<EOT
|
pascal@200
|
184 $html
|
pascal@200
|
185 EOT
|
pascal@200
|
186 )
|
pascal@200
|
187 }
|