Subversion Repositories SmartDukaan

Rev

Rev 31380 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
30232 amit.gupta 1 
<section class="wrapper">
30055 manish 2 
    <div class="row">
3 
        <div class="col-lg-12">
4 
            <h3 class="page-header"><i class="icon_document_alt"></i>Credited Income</h3>
5 
            <ol class="breadcrumb">
6 
                <li><i class="fa fa-home"></i><a href="${rc.contextPath}/dashboard">Home</a></li>
7 
                <li><i class="icon_document_alt"></i>Credited Income</li>
8 
            </ol>
9 
        </div>
10 
    </div>
30232 amit.gupta 11 
 
30055 manish 12 
    <div class="row">
30232 amit.gupta 13 
        <div class="form-group">
14 
            <label class="control-label col-lg-1" for="months" style="color:green;">Select Month</label>
15 
            <div class="col-lg-2">
16 
                <select class="form-control input-sm" id="month-wise-income"
17 
                        style="font-weight: bold;margin:auto;" name="month-wise-income"
18 
                        placeholder="months">
19 
                    <option value="" disabled selected>Month</option>
20 
                    #foreach($mVM in $monthValueMap.entrySet())
21 
                        #if($mVM.getKey()== $month )
22 
                        <b>
23 
                            <option value="$mVM.getKey()" selected>$mVM.getValue()</option>
24 
                        #else
25 
                        <b>
26 
                            <option value="$mVM.getKey()">$mVM.getValue()</option>
27 
                        #end
28 
                    #end
29 
                </select>
30 
            </div>
31 
        </div>
32 
    </div>
30055 manish 33 
    <div class="row">
31352 amit.gupta 34 
        <div class="col-lg-5">
30232 amit.gupta 35 
            <table class="table table-border table-condensed table-bordered" id="lmiCreditedIncome">
31352 amit.gupta 36 
                <thead>
30232 amit.gupta 37 
                <tr style="color:black;">
38 
                    <th>Brand</th>
39 
                    <th>Purchase Margin</th>
31352 amit.gupta 40 
                    <th>Booster Margin</th>
30232 amit.gupta 41 
                    <th>Sale Margin</th>
31352 amit.gupta 42 
                    <th>Pending Margin</th>
43 
                    <th>Addnl Margin</th>
32232 amit.gupta 44 
                    <th>Selling Price - DP</th>
31352 amit.gupta 45 
                    <th>Total</th>
30232 amit.gupta 46 
                </tr>
47 
                </thead>
48 
                <tbody>
32232 amit.gupta 49 
                    #foreach($brand in $brandSet)
50 
                    <tr class="brand-wise-income" data-brand="$brand" data-month="$month" data-status="$status">
51 
                        <td>$brand</td>
30232 amit.gupta 52 
 
32232 amit.gupta 53 
                        #if($lastMonthPurchaseInMarginMap.containsKey($brand))
54 
                            <td>$nf.format($lastMonthPurchaseInMarginMap.get($brand).getAmount())</td>
30232 amit.gupta 55 
                        #else
56 
                            <td>0</td>
57 
                        #end
32232 amit.gupta 58 
                        #if($additionalPurchasePayoutMap.containsKey($brand))
59 
                            <td>$nf.format($additionalPurchasePayoutMap.get($brand))</td>
30232 amit.gupta 60 
                        #else
61 
                            <td>0</td>
62 
                        #end
32232 amit.gupta 63 
                        #if($lastMonthCategoryUpgradeMarginMap.containsKey($brand))
64 
                            #if($lastMonthSaleMarginMap.get($brand).getAmount())
30232 amit.gupta 65 
 
32232 amit.gupta 66 
                                <td>$nf.format($lastMonthSaleMarginMap.get($brand).getAmount()) <i
30232 amit.gupta 67 
                                        class='far fa-arrow-alt-circle-up' style="color: green;"
32232 amit.gupta 68 
                                        title="$nf.format($lastMonthCategoryUpgradeMarginMap.get($brand)) Category Upgrade Additional Margin."></i>
30232 amit.gupta 69 
                                </td>
70 
                            #else
71 
                                <td>0<i class='far fa-arrow-alt-circle-up' style="color: green;"
32232 amit.gupta 72 
                                        title="$nf.format($lastMonthCategoryUpgradeMarginMap.get($brand)) Category Upgrade Additional Margin."></i>
30232 amit.gupta 73 
                                </td>
74 
                            #end
75 
 
76 
 
77 
                        #else
32232 amit.gupta 78 
                            #if($lastMonthSaleMarginMap.get($brand).getAmount())
30232 amit.gupta 79 
 
32232 amit.gupta 80 
                                <td>$nf.format($lastMonthSaleMarginMap.get($brand).getAmount()) </td>
30232 amit.gupta 81 
                            #else
82 
                                <td>0</td>
83 
                            #end
84 
 
85 
                        #end
32232 amit.gupta 86 
                        #if($lastMonthPendingIncomeMap.get($brand).getAmount())
87 
                            <td>$nf.format($lastMonthPendingIncomeMap.get($brand).getAmount())</td>
30232 amit.gupta 88 
 
89 
                        #else
90 
                            <td>0</td>
91 
                        #end
32232 amit.gupta 92 
                        #if($additionalSalePayoutMap.containsKey($brand))
93 
                            <td>$nf.format($additionalSalePayoutMap.get($brand))</td>
31352 amit.gupta 94 
                        #else
95 
                            <td>0</td>
96 
                        #end
32232 amit.gupta 97 
                        <td>
98 
                            #if($lastMonthFrontEndIncomeMap.containsKey($brand))
99 
                                $lastMonthFrontEndIncomeMap.get($brand).getAmount()
100 
                            #else
101 
 
102 
                            #end
103 
                        </td>
104 
                        <td>
105 
                            #if($totalAmountMap.get($brand))
106 
                                $nf.format($totalAmountMap.get($brand))
107 
                            #else
108 
 
109 
                            #end
110 
                        </td>
30232 amit.gupta 111 
 
112 
                    </tr>
113 
                    #end
114 
 
115 
                </tbody>
116 
                <tfoot>
31352 amit.gupta 117 
                <tr class="footer">
31286 amit.gupta 118 
                    <th>Total</th>
31352 amit.gupta 119 
                    <th></th>
120 
                    <th></th>
121 
                    <th></th>
122 
                    <th></th>
123 
                    <th></th>
124 
                    <th></th>
32232 amit.gupta 125 
                    <th></th>
30232 amit.gupta 126 
                </tr>
127 
                </tfoot>
128 
 
129 
 
130 
            </table>
30055 manish 131 
        </div>
30232 amit.gupta 132 
 
133 
 
31352 amit.gupta 134 
        <div class="col-lg-7 brand-wise-income-container"></div>
30232 amit.gupta 135 
 
30055 manish 136 
    </div>
30232 amit.gupta 137 
 
138 
    <div class="imei-wise-income-container"></div>
139 
 
140 
 
141 
</section>
142 
 
143 
 
144 
<script type="text/javascript">
145 
    $(document).ready(function () {
31380 amit.gupta 146 
        var table = $('#lmiCreditedIncome').DataTable({
147 
            "pageLength": 20
148 
        });
30232 amit.gupta 149 
 
150 
        $('#lmiCreditedIncome tbody').on('click', 'tr', function () {
151 
            if ($(this).hasClass('selected')) {
152 
                $(this).removeClass('selected');
153 
            } else {
154 
                table.$('tr.selected').removeClass('selected');
155 
                $(this).addClass('selected');
156 
            }
157 
        });
158 
 
30225 tejbeer 159 
        datatableSum();
30232 amit.gupta 160 
        table.on('search.dt', function () {
30225 tejbeer 161 
            console.log('Currently applied global search: ' + table.search());
162 
            datatableSum();
163 
 
30232 amit.gupta 164 
 
30225 tejbeer 165 
        });
30232 amit.gupta 166 
 
167 
    });
168 
 
169 
 
170 
    function datatableSum() {
171 
 
31352 amit.gupta 172 
        let dataTable = $('#lmiCreditedIncome').DataTable();
173 
        let footerContainer = $('#lmiCreditedIncome').find('tr.footer')
174 
        var col_one_sum = numberToComma(dataTable.column(1, {page: 'current'}).data().sum());
175 
        footerContainer.find('th').eq(1).html(`<b>${col_one_sum}</b>`);
30232 amit.gupta 176 
 
31352 amit.gupta 177 
        var col_two_sum = numberToComma(dataTable.column(2, {page: 'current'}).data().sum());
178 
        footerContainer.find('th').eq(2).html(`<b>${col_two_sum}</b>`);
30232 amit.gupta 179 
 
31352 amit.gupta 180 
        var col_three_sum = numberToComma(dataTable.column(3, {page: 'current'}).data().sum());
181 
        footerContainer.find('th').eq(3).html(`<b>${col_three_sum}</b>`);
30232 amit.gupta 182 
 
183 
 
31352 amit.gupta 184 
        var col_four_sum = numberToComma(dataTable.column(4, {page: 'current'}).data().sum());
185 
        footerContainer.find('th').eq(4).html(`<b>${col_four_sum}</b>`);
186 
 
187 
        var col_five_sum = numberToComma(dataTable.column(5, {page: 'current'}).data().sum());
188 
        footerContainer.find('th').eq(5).html(`<b>${col_five_sum}</b>`);
189 
 
31281 amit.gupta 190 
        var col_six_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(6, {page: 'current'}).data().sum());
31352 amit.gupta 191 
        footerContainer.find('th').eq(6).html(`<b>${col_six_sum}</b>`);
32232 amit.gupta 192 
        var col_seven_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(7, {page: 'current'}).data().sum());
193 
        footerContainer.find('th').eq(7).html(`<b>${col_seven_sum}</b>`);
30232 amit.gupta 194 
 
32232 amit.gupta 195 
        /*var col_eight_sum = numberToComma(dataTable.column(8, {page: 'current'}).data().sum());
196 
        footerContainer.find('th').eq(8).html(`<b>${col_eight_sum}</b>`);
197 
    */
31352 amit.gupta 198 
 
30232 amit.gupta 199 
    }
200 
 
201 
 
202 
</script>
30055 manish 203