The only consideration for this question is, at the moment, I’m not using jQuery. Here’s the code:
JavaScript
x
83
83
1
//I think here is where the problem relies, in the function I'm using to calculate the sum of the values under 'Valor' column:2
var t1 = document.getElementById("emp-table");3
getSum();4
function getSum() {5
var sumVal = 0;6
for(var i = 1; i < t1.rows.length; i++){7
sumVal = sumVal + parseInt(t1.rows[i].cells[6].innerHTML);8
document.getElementById("sumV").innerHTML = "Sum Value = "+sumVal;9
}10
};11
12
function getUniqueValuesFromColumn() {13
var unique_col_values_dict = {}14
allFilters = document.querySelectorAll(".table-filter")15
allFilters.forEach((filter_i) => {16
col_index = filter_i.parentElement.getAttribute("col-index");17
const rows = document.querySelectorAll("#emp-table > tbody > tr")18
rows.forEach((row) => {19
cell_value = row.querySelector("td:nth-child("+col_index+")").innerHTML;20
if (col_index in unique_col_values_dict) {21
if (unique_col_values_dict[col_index].includes(cell_value)) {22
//console.log("already exists");23
} else {24
unique_col_values_dict[col_index].push(cell_value)25
}26
} else {27
unique_col_values_dict[col_index] = new Array(cell_value)28
}29
}); 30
});31
updateSelectOptions(unique_col_values_dict)32
};33
34
function updateSelectOptions(unique_col_values_dict) {35
allFilters = document.querySelectorAll(".table-filter")36
allFilters.forEach((filter_i) => {37
col_index = filter_i.parentElement.getAttribute('col-index')38
unique_col_values_dict[col_index].forEach((i) => {39
filter_i.innerHTML = filter_i.innerHTML + `n<option value="${i}">${i}</option>`40
});41
42
});43
};44
45
function filter_rows() {46
allFilters = document.querySelectorAll(".table-filter")47
var filter_value_dict = {}48
allFilters.forEach((filter_i) => {49
col_index = filter_i.parentElement.getAttribute('col-index')50
value = filter_i.value51
if (value != "all") {52
filter_value_dict[col_index] = value;53
}54
});55
var col_cell_value_dict = {};56
const rows = document.querySelectorAll("#emp-table tbody tr");57
rows.forEach((row) => {58
var display_row = true;59
allFilters.forEach((filter_i) => {60
col_index = filter_i.parentElement.getAttribute('col-index')61
col_cell_value_dict[col_index] = row.querySelector("td:nth-child(" + col_index+ ")").innerHTML62
})63
for (var col_i in filter_value_dict) {64
filter_value = filter_value_dict[col_i]65
row_cell_value = col_cell_value_dict[col_i]66
if (row_cell_value.indexOf(filter_value) == -1 && filter_value != "all") {67
display_row = false;68
break;69
}70
}71
if (display_row == true) {72
row.style.display = "table-row"73
} else {74
row.style.display = "none"75
}76
})77
};78
79
//And finally, the 'onload' part to update the content:80
window.onload = () => {81
console.log(document.querySelector("#emp-table > tbody > tr:nth-child(1) > td:nth-child(2) ").innerHTML);82
};83
getUniqueValuesFromColumn()JavaScript
1
125
125
1
<body>2
<div class="container">3
<div class="card">4
<div class="card-header">5
Lista Pagos6
</div>7
<div class="card-body">8
<table id="emp-table" class="table">9
<thead>10
<tr>11
<th>id</th>12
<th col-index = 2>Persona13
<select class="table-filter" onchange="filter_rows()">14
<option value="all"></option>15
</select>16
</th>17
<th col-index = 3>Servicio18
<select class="table-filter" onchange="filter_rows()">19
<option value="all"></option>20
</select>21
</th>22
<th col-index = 4>Año23
<select class="table-filter" onchange="filter_rows()">24
<option value="all"></option>25
</select>26
</th>27
<th col-index = 5>Mes28
<select class="table-filter" onchange="filter_rows()">29
<option value="all"></option>30
</select>31
</th>32
<th>id Recibo</th>33
<th>Valor</th>34
</tr>35
</thead>36
<tbody>37
<tr>38
<td> 33 </td>39
<td> David Camacho </td>40
<td> Gas </td>41
<td> 2022 </td>42
<td> 4 </td>43
<td> 7 </td>44
<td> 10000 </td>45
</tr>46
47
<tr>48
<td> 32 </td>49
<td> Héctor Camacho </td>50
<td> Gas </td>51
<td> 2022 </td>52
<td> 4 </td>53
<td> 7 </td>54
<td> 15075 </td>55
</tr>56
57
<tr>58
<td> 30 </td>59
<td> Héctor Camacho </td>60
<td> Seguro exequial </td>61
<td> 2022 </td>62
<td> 4 </td>63
<td> 6 </td>64
<td> 11100 </td>65
</tr>66
67
<tr>68
<td> 29 </td>69
<td> María Camacho </td>70
<td> Seguro exequial </td>71
<td> 2022 </td>72
<td> 4 </td>73
<td> 6 </td>74
<td> 11100 </td>75
</tr>76
77
<tr>78
<td> 28 </td>79
<td> Mateo León </td>80
<td> Internet </td>81
<td> 2022 </td>82
<td> 4 </td>83
<td> 1 </td>84
<td> 20000 </td>85
</tr>86
87
<tr>88
<td> 27 </td>89
<td> David Camacho </td>90
<td> Internet </td>91
<td> 2022 </td>92
<td> 4 </td>93
<td> 1 </td>94
<td> 11600 </td>95
</tr>96
97
<tr>98
<td> 24 </td>99
<td> Alba Camacho </td>100
<td> Internet </td>101
<td> 2022 </td>102
<td> 4 </td>103
<td> 1 </td>104
<td> 11600 </td>105
</tr>106
107
<tr>108
<td> 23 </td>109
<td> María Camacho </td>110
<td> Internet </td>111
<td> 2022 </td>112
<td> 4 </td>113
<td> 1 </td>114
<td> 11600 </td>115
</tr>116
</tbody>117
</table>118
</div>119
</div>120
121
<p id="sumV"></p>122
<br/>123
<br/>124
</div>125
</body>So, at the moment, whenever I load the page, the <span> tag already has the total amount if we consider all rows. But, whenever I filter the table, the value there doesn’t change. At first, I tried to do it with a button using onclick, but every time I clicked it, it changed from the total value to ‘undefined’. That’s why I removed that button, and I’m considering to update the content in the <span> tag with the onload segment of my code, but I’ve been unable to achieve it so far.
Any help is greatly appreciated, cheers!
Advertisement
Answer
You could replace your getSum function with the following
JavaScript
1
13
13
1
function getSum() {2
const rows = [document.querySelectorAll('#emp-table tr').values()];3
const visibleRows = rows.filter(row => {4
return row.style.display !== 'none';5
});6
7
let sumVal = 0;8
for (let visibleRow of visibleRows){9
sumVal += parseInt(visibleRow.cells[6].innerHTML);10
}11
document.getElementById("sumV").innerHTML = "Sum Value = " + sumVal;12
};13
Basically you first filter the rows based on their display value to get just the visibleRows and then sum up the values.