Subversion Repositories SmartDukaan

Rev

Rev 31286 | Rev 31380 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31286 Rev 31352
Line 29... Line 29...
29 
                </select>
 29 
                </select>
30 
            </div>
 30 
            </div>
31 
        </div>
 31 
        </div>
32 
    </div>
 32 
    </div>
33 
    <div class="row">
 33 
    <div class="row">
34 
        <div class="col-lg-4">
 34 
        <div class="col-lg-5">
35 
            <table class="table table-border table-condensed table-bordered" id="lmiCreditedIncome">
 35 
            <table class="table table-border table-condensed table-bordered" id="lmiCreditedIncome">
36 
 
 - 
 
37 
                <thead class="row htable">
 36 
                <thead>
38 
 
 - 
 
39 
                <tr style="color:black;">
 37 
                <tr style="color:black;">
40 
                    <th>Brand</th>
 38 
                    <th>Brand</th>
41 
                    <th>Purchase Qty</th>
 - 
 
42 
                    <th>Purchase Margin</th>
 39 
                    <th>Purchase Margin</th>
43 
                    <th>Sale Qty</th>
 40 
                    <th>Booster Margin</th>
44 
                    <th>Sale Margin</th>
 41 
                    <th>Sale Margin</th>
45 
                    <th>Pending Sale Margin</th>
 42 
                    <th>Pending Margin</th>
- 
 
 43 
                    <th>Addnl Margin</th>
46 
                    <th>Total Income</th>
 44 
                    <th>Total</th>
47 
                </tr>
 45 
                </tr>
48 
                </thead>
 46 
                </thead>
49 
                <tbody>
 47 
                <tbody>
50 
 
 - 
 
51 
                    #foreach($key in $keySet)
 48 
                    #foreach($key in $keySet)
52 
                    <tr class="brand-wise-income" data-brand="$key" data-month="$month" data-status="$status">
 49 
                    <tr class="brand-wise-income" data-brand="$key" data-month="$month" data-status="$status">
53 
                        <td>$key</td>
 50 
                        <td>$key</td>
54 
 
 51 
 
55 
                        #if($lastMonthPurchaseInMarginMap.get($key).getQty())
 - 
 
56 
                            <td>$lastMonthPurchaseInMarginMap.get($key).getQty()</td>
 - 
 
57 
                        #else
 - 
 
58 
                            <td>0</td>
 - 
 
59 
                        #end
 - 
 
60 
                        #if($lastMonthPurchaseInMarginMap.get($key).getAmount())
 52 
                        #if($lastMonthPurchaseInMarginMap.get($key).getAmount())
61 
                            <td>$nf.format($lastMonthPurchaseInMarginMap.get($key).getAmount())</td>
 53 
                            <td>$nf.format($lastMonthPurchaseInMarginMap.get($key).getAmount())</td>
62 
                        #else
 54 
                        #else
63 
                            <td>0</td>
 55 
                            <td>0</td>
64 
                        #end
 56 
                        #end
65 
                        #if($lastMonthSaleMarginMap.get($key).getQty())
 57 
                        #if($additionalPurchasePayoutMap.containsKey($key))
66 
                            <td>$lastMonthSaleMarginMap.get($key).getQty()</td>
 58 
                            <td>$nf.format($additionalPurchasePayoutMap.get($key))</td>
67 
                        #else
 59 
                        #else
68 
                            <td>0</td>
 60 
                            <td>0</td>
69 
                        #end
 61 
                        #end
70 
                        #if($lastMonthCategoryUpgradeMarginMap.get($key))
 62 
                        #if($lastMonthCategoryUpgradeMarginMap.get($key))
71 
 
 63 
 
Line 95... Line 87...
95 
                            <td>$nf.format($lastMonthPendingIncomeMap.get($key).getAmount())</td>
 87 
                            <td>$nf.format($lastMonthPendingIncomeMap.get($key).getAmount())</td>
96 
 
 88 
 
97 
                        #else
 89 
                        #else
98 
                            <td>0</td>
 90 
                            <td>0</td>
99 
                        #end
 91 
                        #end
- 
 
 92 
                        #if($additionalSalePayoutMap.containsKey($key))
- 
 
 93 
                            <td>$nf.format($additionalSalePayoutMap.get($key))</td>
- 
 
 94 
                        #else
- 
 
 95 
                            <td>0</td>
- 
 
 96 
                        #end
100 
 
 97 
 
101 
                        #if($totalAmountMap.get($key))
 98 
                        #if($totalAmountMap.get($key))
102 
 
 - 
 
103 
                            <td>$nf.format($totalAmountMap.get($key))</td>
 99 
                            <td>$nf.format($totalAmountMap.get($key))</td>
104 
                        #else
 100 
                        #else
105 
                            <td>0</td>
 101 
                            <td>0</td>
106 
                        #end
 102 
                        #end
107 
 
 103 
 
108 
                    </tr>
 104 
                    </tr>
109 
                    #end
 105 
                    #end
110 
 
 106 
 
111 
                </tbody>
 107 
                </tbody>
112 
                <tfoot>
 108 
                <tfoot>
113 
                <tr>
 109 
                <tr class="footer">
114 
                    <th>Total</th>
 110 
                    <th>Total</th>
115 
                    <th>-</th>
 111 
                    <th></th>
116 
                    <th id="purchase-total"></th>
 112 
                    <th></th>
117 
 
 - 
 
118 
                    <th>-</th>
 113 
                    <th></th>
119 
                    <th id="sale-total"></th>
 114 
                    <th></th>
120 
                    <th id="pending-total"></th>
 115 
                    <th></th>
121 
 
 - 
 
122 
                    <th id="sum-total"></th>
 116 
                    <th></th>
123 
 
 - 
 
124 
                </tr>
 117 
                </tr>
125 
                </tfoot>
 118 
                </tfoot>
126 
 
 119 
 
127 
 
 120 
 
128 
            </table>
 121 
            </table>
129 
        </div>
 122 
        </div>
130 
 
 123 
 
131 
 
 124 
 
132 
        <div class="col-lg-8 brand-wise-income-container"></div>
 125 
        <div class="col-lg-7 brand-wise-income-container"></div>
133 
 
 126 
 
134 
    </div>
 127 
    </div>
135 
 
 128 
 
136 
    <div class="imei-wise-income-container"></div>
 129 
    <div class="imei-wise-income-container"></div>
137 
 
 130 
 
Line 163... Line 156...
163 
    });
 156 
    });
164 
 
 157 
 
165 
 
 158 
 
166 
    function datatableSum() {
 159 
    function datatableSum() {
167 
 
 160 
 
- 
 
 161 
        let dataTable = $('#lmiCreditedIncome').DataTable();
- 
 
 162 
        let footerContainer = $('#lmiCreditedIncome').find('tr.footer')
- 
 
 163 
        var col_one_sum = numberToComma(dataTable.column(1, {page: 'current'}).data().sum());
- 
 
 164 
        footerContainer.find('th').eq(1).html(`<b>${col_one_sum}</b>`);
- 
 
 165 
 
168 
        var col_two_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(2, {page: 'current'}).data().sum());
 166 
        var col_two_sum = numberToComma(dataTable.column(2, {page: 'current'}).data().sum());
169 
        $('#purchase-total').html(`<b>${col_two_sum}</b>`);
 167 
        footerContainer.find('th').eq(2).html(`<b>${col_two_sum}</b>`);
170 
 
 168 
 
171 
        var col_four_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(4, {page: 'current'}).data().sum());
 169 
        var col_three_sum = numberToComma(dataTable.column(3, {page: 'current'}).data().sum());
172 
        console.log(col_four_sum)
 - 
 
173 
        $('#sale-total').html(`<b>${col_four_sum}</b>`);
 170 
        footerContainer.find('th').eq(3).html(`<b>${col_three_sum}</b>`);
174 
 
 171 
 
175 
        var col_five_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(5, {page: 'current'}).data().sum());
 - 
 
176 
        $('#pending-total').html(`<b>${col_five_sum}</b>`);
 - 
 
177 
 
 172 
 
- 
 
 173 
        var col_four_sum = numberToComma(dataTable.column(4, {page: 'current'}).data().sum());
- 
 
 174 
        footerContainer.find('th').eq(4).html(`<b>${col_four_sum}</b>`);
- 
 
 175 
 
- 
 
 176 
        var col_five_sum = numberToComma(dataTable.column(5, {page: 'current'}).data().sum());
- 
 
 177 
        footerContainer.find('th').eq(5).html(`<b>${col_five_sum}</b>`);
178 
 
 178 
 
179 
        var col_six_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(6, {page: 'current'}).data().sum());
 179 
        var col_six_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(6, {page: 'current'}).data().sum());
180 
        console.log(col_six_sum)
 180 
        footerContainer.find('th').eq(6).html(`<b>${col_six_sum}</b>`);
- 
 
 181 
        /*
- 
 
 182 
                var col_seven_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(7, {page: 'current'}).data().sum());
- 
 
 183 
                footerContainer.find('th').eq(7).html(`<b>${col_seven_sum}</b>`);
- 
 
 184 
 
- 
 
 185 
        var col_eight_sum = numberToComma(dataTable.column(8, {page: 'current'}).data().sum());
181 
        $('#sum-total').html(`<b>${col_six_sum}</b>`);
 186 
        footerContainer.find('th').eq(8).html(`<b>${col_eight_sum}</b>`);*/
182 
 
 187 
 
183 
    }
 188 
    }
184 
 
 189 
 
185 
 
 190 
 
186 
</script>
 191 
</script>