snipt

Ctrl+h for KB shortcuts

JavaScript

Table totals

javascript:(function() {
    var number_re = /([0-9.+-]+)/;
    $('table').each(function() {
        var $table = $(this);
        var totals = $.map($('table:first tr:first').find('td,th'), function() { return '' });
        $table.find('tr').each(function() {
            $(this).children('td,th').each(function(i) {
                var match = number_re.exec($(this).text().replace(',', ''));
                if (match) {
                    var value = parseFloat(match[1]);
                    if (!isNaN(value)) {
                        if (totals[i] == '') {
                            totals[i] = value;
                        }
                        else {
                            totals[i] += value;
                        }
                    }
                }
            });
        });
        $('<tr/>').html($.map(totals, function(value) { return '<td>' + value + '</td>' }).join('')).appendTo($table);
        $table.find('tr:last td').css('border-top', '2px solid #EEEEEE').css('font-weight', 'bold').eq(0).text('TOTAL');
    })
})()
https://snipt.net/embed/e6f1653f810a7c43838348bce563fa1f/
/raw/e6f1653f810a7c43838348bce563fa1f/
e6f1653f810a7c43838348bce563fa1f
js
JavaScript
26
2019-08-18T15:35:34
True
False
False
/api/public/snipt/28670/
table-totals
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="nx">javascript</span><span class="o">:</span><span class="p">(</span><span class="kd">function</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-2"><a name="L-2"></a> <span class="kd">var</span> <span class="nx">number_re</span> <span class="o">=</span> <span class="sr">/([0-9.+-]+)/</span><span class="p">;</span> </span><span id="L-3"><a name="L-3"></a> <span class="nx">$</span><span class="p">(</span><span class="s1">&#39;table&#39;</span><span class="p">).</span><span class="nx">each</span><span class="p">(</span><span class="kd">function</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-4"><a name="L-4"></a> <span class="kd">var</span> <span class="nx">$table</span> <span class="o">=</span> <span class="nx">$</span><span class="p">(</span><span class="k">this</span><span class="p">);</span> </span><span id="L-5"><a name="L-5"></a> <span class="kd">var</span> <span class="nx">totals</span> <span class="o">=</span> <span class="nx">$</span><span class="p">.</span><span class="nx">map</span><span class="p">(</span><span class="nx">$</span><span class="p">(</span><span class="s1">&#39;table:first tr:first&#39;</span><span class="p">).</span><span class="nx">find</span><span class="p">(</span><span class="s1">&#39;td,th&#39;</span><span class="p">),</span> <span class="kd">function</span><span class="p">()</span> <span class="p">{</span> <span class="k">return</span> <span class="s1">&#39;&#39;</span> <span class="p">});</span> </span><span id="L-6"><a name="L-6"></a> <span class="nx">$table</span><span class="p">.</span><span class="nx">find</span><span class="p">(</span><span class="s1">&#39;tr&#39;</span><span class="p">).</span><span class="nx">each</span><span class="p">(</span><span class="kd">function</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-7"><a name="L-7"></a> <span class="nx">$</span><span class="p">(</span><span class="k">this</span><span class="p">).</span><span class="nx">children</span><span class="p">(</span><span class="s1">&#39;td,th&#39;</span><span class="p">).</span><span class="nx">each</span><span class="p">(</span><span class="kd">function</span><span class="p">(</span><span class="nx">i</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-8"><a name="L-8"></a> <span class="kd">var</span> <span class="nx">match</span> <span class="o">=</span> <span class="nx">number_re</span><span class="p">.</span><span class="nx">exec</span><span class="p">(</span><span class="nx">$</span><span class="p">(</span><span class="k">this</span><span class="p">).</span><span class="nx">text</span><span class="p">().</span><span class="nx">replace</span><span class="p">(</span><span class="s1">&#39;,&#39;</span><span class="p">,</span> <span class="s1">&#39;&#39;</span><span class="p">));</span> </span><span id="L-9"><a name="L-9"></a> <span class="k">if</span> <span class="p">(</span><span class="nx">match</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-10"><a name="L-10"></a> <span class="kd">var</span> <span class="nx">value</span> <span class="o">=</span> <span class="nb">parseFloat</span><span class="p">(</span><span class="nx">match</span><span class="p">[</span><span class="mi">1</span><span class="p">]);</span> </span><span id="L-11"><a name="L-11"></a> <span class="k">if</span> <span class="p">(</span><span class="o">!</span><span class="nb">isNaN</span><span class="p">(</span><span class="nx">value</span><span class="p">))</span> <span class="p">{</span> </span><span id="L-12"><a name="L-12"></a> <span class="k">if</span> <span class="p">(</span><span class="nx">totals</span><span class="p">[</span><span class="nx">i</span><span class="p">]</span> <span class="o">==</span> <span class="s1">&#39;&#39;</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-13"><a name="L-13"></a> <span class="nx">totals</span><span class="p">[</span><span class="nx">i</span><span class="p">]</span> <span class="o">=</span> <span class="nx">value</span><span class="p">;</span> </span><span id="L-14"><a name="L-14"></a> <span class="p">}</span> </span><span id="L-15"><a name="L-15"></a> <span class="k">else</span> <span class="p">{</span> </span><span id="L-16"><a name="L-16"></a> <span class="nx">totals</span><span class="p">[</span><span class="nx">i</span><span class="p">]</span> <span class="o">+=</span> <span class="nx">value</span><span class="p">;</span> </span><span id="L-17"><a name="L-17"></a> <span class="p">}</span> </span><span id="L-18"><a name="L-18"></a> <span class="p">}</span> </span><span id="L-19"><a name="L-19"></a> <span class="p">}</span> </span><span id="L-20"><a name="L-20"></a> <span class="p">});</span> </span><span id="L-21"><a name="L-21"></a> <span class="p">});</span> </span><span id="L-22"><a name="L-22"></a> <span class="nx">$</span><span class="p">(</span><span class="s1">&#39;&lt;tr/&gt;&#39;</span><span class="p">).</span><span class="nx">html</span><span class="p">(</span><span class="nx">$</span><span class="p">.</span><span class="nx">map</span><span class="p">(</span><span class="nx">totals</span><span class="p">,</span> <span class="kd">function</span><span class="p">(</span><span class="nx">value</span><span class="p">)</span> <span class="p">{</span> <span class="k">return</span> <span class="s1">&#39;&lt;td&gt;&#39;</span> <span class="o">+</span> <span class="nx">value</span> <span class="o">+</span> <span class="s1">&#39;&lt;/td&gt;&#39;</span> <span class="p">}).</span><span class="nx">join</span><span class="p">(</span><span class="s1">&#39;&#39;</span><span class="p">)).</span><span class="nx">appendTo</span><span class="p">(</span><span class="nx">$table</span><span class="p">);</span> </span><span id="L-23"><a name="L-23"></a> <span class="nx">$table</span><span class="p">.</span><span class="nx">find</span><span class="p">(</span><span class="s1">&#39;tr:last td&#39;</span><span class="p">).</span><span class="nx">css</span><span class="p">(</span><span class="s1">&#39;border-top&#39;</span><span class="p">,</span> <span class="s1">&#39;2px solid #EEEEEE&#39;</span><span class="p">).</span><span class="nx">css</span><span class="p">(</span><span class="s1">&#39;font-weight&#39;</span><span class="p">,</span> <span class="s1">&#39;bold&#39;</span><span class="p">).</span><span class="nx">eq</span><span class="p">(</span><span class="mi">0</span><span class="p">).</span><span class="nx">text</span><span class="p">(</span><span class="s1">&#39;TOTAL&#39;</span><span class="p">);</span> </span><span id="L-24"><a name="L-24"></a> <span class="p">})</span> </span><span id="L-25"><a name="L-25"></a><span class="p">})()</span> </span></pre></div> </td></tr></table>
bookmarklet, sum, table, total