'Need a function or logic to sum all textbox values, where multiple selects where generated dynamicly, and has the same value, in jQuery
I'm new to jQuery and dealing with the following, i need to sum all text input values (qtya + qtyb) or (qtyc + qtyd), where selected value in the first two columns with select input are the same value, which is the employee id.
for example, if i set select input with id managera1,managera3 and managerb14 to employee40, its value will be 40, so i need to sum (qtya1 + qtya3 + qtyb14) and display in stot40
same logic for plannera2, plannerb11, plannerb22 has employee46 is selected gtot46 = sum(qtyc11 + qtyd11 + qtyd22)
stot## = sum(all qtya##) + sum(qtyb##) where same value/person in managera or managerb is selected
gtot## = sum(all qtya##) + sum(qtyb##) where same value/person in plannera or plannerb is selected
Example of table: https://jsfiddle.net/monzi/68kt0m2h/10/
code:
<table>
<thead>
<tr><td>managera</td><td>qtya</td><td>managerb</td><td>qtyb</td><td></td><td>plannera</td><td>qtyc</td><td>plannerb</td><td>qrtyd</td><tr>
</thead>
<tr>
<td>
<select name="managera[]" id="managera1" class="ddman" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtya[]" id="qtya1" type="number" value="2" min="0" class="manager"/></td>
<td>
<select name="managerb[]" id="managerb1" class="ddman" required>
<option value="40">employee 40</option>
<option value="46" selected>employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyb[]" id="qtyb1" type="number" value="4" min="0" class="manager"/>
</td>
<td>...</td>
<td>
<select name="plannera[]" id="plannera1" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48" selected>employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtyc[]" id="qtyc1" type="number" value="2" min="0" class="planner"/></td>
<td>
<select name="plannerb[]" id="plannerb1" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyd[]" id="qtyd1" type="number" value="3" min="0" class="planner"/>
</td>
</tr>
<tr>
<td>
<select name="managera[]" id="managera2" class="ddman" required>
<option value="40">employee 40</option>
<option value="46" selected>employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtya[]" id="qtya2" value="2" type="number" min="0" class="manager"/></td>
<td>
<select name="managerb[]" id="managerb2" class="ddman" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48" selected>employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyb[]" id="qtyb2" value="2" type="number" min="0" class="manager"/>
</td>
<td>...</td>
<td>
<select name="plannera[]" id="plannera2" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtyc[]" id="qtyc2" value="2" type="number" min="0" class="planner"/></td>
<td>
<select name="plannerb[]" id="plannerb2" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyd[]" id="qtyd2" value="2" type="number" min="0" class="planner"/>
</td>
</tr>
<tr>
<td>
<select name="managera[]" id="managera3" class="ddman" required>
<option value="40" selected>employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtya[]" id="qtya3" value="2" type="number" min="0" class="manager"/></td>
<td>
<select name="managerb[]" id="managerb3" class="ddman" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48" selected>employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyb[]" id="qtyb3" value="1" type="number" min="0" class="manager"/>
</td>
<td>...</td>
<td>
<select name="plannera[]" id="plannera3" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtyc[]" id="qtyc3" value="3" type="number" min="0" class="planner"/></td>
<td>
<select name="plannerb[]" id="plannerb3" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyd[]" id="qtyd3" value="1" type="number" min="0" class="planner"/>
</td>
</tr>
<tr>
<td>
<select name="managera[]" id="managera4" class="ddman" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48" selected>employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtya[]" id="qtya4" value="1" type="number" min="0" class="manager"/></td>
<td>
<select name="managerb[]" id="managerb4" class="ddman" required>
<option value="40" selected>employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyb[]" id="qtyb4" value="1" type="number" min="0" class="manager"/>
</td>
<td>...</td>
<td>
<select name="plannera[]" id="plannera4" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtyc[]" id="qtyc4" value="1" type="number" min="0" class="planner"/></td>
<td>
<select name="plannerb[]" id="plannerb4" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyd[]" id="qtyd4" value="1" type="number" min="0" class="planner"/>
</td>
</tr>
<tr>
<td>
<select name="managera[]" id="managera5" class="ddman" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48" selected>employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtya[]" id="qtya5" value="1" type="number" min="0" class="manager"/></td>
<td>
<select name="managerb[]" id="managerb5" class="ddman" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49" selected>employee 49</option>
</select>
</td>
<td>
<input name="qtyb[]" id="qtyb5" value="1" type="number" min="0" class="manager"/>
</td>
<td>...</td>
<td>
<select name="plannera[]" id="plannera5" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49" selected>employee 49</option>
</select>
<td><input name="qtyc[]" id="qtyc5" value="1" type="number" min="0" class="planner"/></td>
<td>
<select name="plannerb[]" id="plannerb5" class="ddplan" required>
<option value="40" selected>employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyd[]" id="qtyd5" value="1" type="number" min="0" class="planner"/>
</td>
</tr>
<tr>
<td>
<select name="managera[]" id="managera6" class="ddman" required>
<option value="40" selected>employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtya[]" id="qtya6" value="1" type="number" min="0" class="manager"/></td>
<td>
<select name="managerb[]" id="managerb6" class="ddman" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48">employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyb[]" id="qtyb6" value="1" type="number" min="0" class="manager"/>
</td>
<td>...</td>
<td>
<select name="plannera[]" id="plannera6" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48" selected>employee 48</option>
<option value="49">employee 49</option>
</select>
<td><input name="qtyc[]" id="qtyc6" value="1" type="number" min="0" class="planner"/></td>
<td>
<select name="plannerb[]" id="plannerb6" class="ddplan" required>
<option value="40">employee 40</option>
<option value="46">employee 46</option>
<option value="48" selected>employee 48</option>
<option value="49">employee 49</option>
</select>
</td>
<td>
<input name="qtyd[]" id="qtyd6" value="1" type="number" min="0" class="planner"/>
</td>
</tr>
</table>
<table>
<thead><td></td><td>STOT## = sum(qtya#) + sum(qtyb#)</td><td>GTOT## = sum(qtyc#) + sum(qtyd#)</td></thead>
<tr>
<td>employee 40</td>
<td>
<input name="stot[]" id="stot40" type="number" min="0" class="stot" value="7" placeholder="id = stot + employee id"/>
</td>
<td>
<input name="gtot[]" id="gtot40" type="number" min="0" value="14" class="gtot" placeholder="id = gtot + employee id"/>
</td>
</tr>
<tr>
<td>employee 46</td>
<td>
<input name="stot[]" id="stot46" value="6" type="number" min="0" class="stot" placeholder="id = stot + employee id"/>
</td>
<td>
<input name="gtot[]" id="gtot46" value="0" type="number" min="0" class="gtot" placeholder="id = gtot + employee id"/>
</td>
</tr>
<tr>
<td>employee 48</td>
<td>
<input name="stot[]" id="stot48" value="5" type="number" min="0" class="stot" placeholder="id = stot + employee id"/>
</td>
<td>
<input name="gtot[]" id="gtot48" value="4" type="number" min="0" class="gtot" placeholder="id = gtot + employee id"/>
</td>
</tr>
<tr>
<td>employee 49</td>
<td>
<input name="stot[]" id="stot49" value="1" type="number" min="0" class="stot" placeholder="id = stot + employee id"/>
</td>
<td>
<input name="gtot[]" id="gtot49" value="0" type="number" min="0" class="gtot" placeholder="id = gtot + employee id"/>
</td>
</tr>
</table>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
