'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