Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
30409 amit.gupta 1 
<section>
2 
    <div>
3 
        <table class="table table-border table-condensed table-bordered" id="brandWiseIncome">
31352 amit.gupta 4 
            <thead>
30055 manish 5 
            <tr style="color:black;">
30225 tejbeer 6 
                <th>Model Name</th>
31352 amit.gupta 7 
                <th>Prch Qty</th>
8 
                <th>Prch Margin</th>
9 
                <th>Booster Margin</th>
30409 amit.gupta 10 
                <th>Sale Qty</th>
11 
                <th>Sale Margin</th>
31352 amit.gupta 12 
                <th>Pending Margin</th>
13 
                <th>Addl Margin</th>
32232 amit.gupta 14 
                <th>Selling Price - DP</th>
30409 amit.gupta 15 
                <th>Total Amount</th>
30055 manish 16 
            </tr>
30409 amit.gupta 17 
            </thead>
30055 manish 18 
            <tbody>
30409 amit.gupta 19 
                #foreach($modelWiseEntry in $modelNameMap.entrySet())
20 
                <tr class="imei_wise_income" data-catalogitemid="$modelWiseEntry.getKey()"
21 
                    data-month="$month">
22 
                    <td>$modelWiseEntry.getValue()</td>
32232 amit.gupta 23 
                    <td>$modelPurchaseQtyMap.get($modelWiseEntry.getKey())</td>
30409 amit.gupta 24 
                    #if($modelWiseSchemeInMarginsMap.containsKey($modelWiseEntry.getKey()))
25 
                        <td>$nf.format($modelWiseSchemeInMarginsMap.get($modelWiseEntry.getKey()).getAmount())</td>
26 
                    #else
27 
                        <td>--</td>
28 
                    #end
31352 amit.gupta 29 
                    #if($additionalPurchasePayoutMap.containsKey($modelWiseEntry.getKey()))
30 
                        <td>$nf.format($additionalPurchasePayoutMap.get($modelWiseEntry.getKey()))</td>
31 
                    #else
32 
                        <td>--</td>
33 
                    #end
32232 amit.gupta 34 
                    #if($modelSaleQtyMap.containsKey($modelWiseEntry.getKey()))
35 
                        <td>$modelSaleQtyMap.get($modelWiseEntry.getKey())</td>
30409 amit.gupta 36 
                        #if($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getAmount() > 0)
37 
                            <td>$nf.format($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getAmount())
30414 amit.gupta 38 
                                #if($categoryUpgradeBrandModelMap.containsKey($modelWiseEntry.getKey()))
30409 amit.gupta 39 
                                    <i class="far fa-arrow-alt-circle-up" style="color: green;"
30414 amit.gupta 40 
                                       title="$nf.format($categoryUpgradeBrandModelMap.get($modelWiseEntry.getKey())) Category Upgrade Additional Margin.">
30409 amit.gupta 41 
                                    </i>
42 
                                #end
43 
                            </td>
44 
                        #else
45 
                            <td>--</td>
46 
                        #end
30414 amit.gupta 47 
                        #if($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getPendingSaleAmount() > 0)
48 
                            <td>$nf.format($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getPendingSaleAmount())</td>
30409 amit.gupta 49 
                        #else
50 
                            <td>--</td>
51 
                        #end
52 
                    #else
53 
                        <td>--</td>
54 
                        <td>--</td>
30414 amit.gupta 55 
                        <td>--</td>
30409 amit.gupta 56 
                    #end
31352 amit.gupta 57 
                    #if($additionalSalePayoutMap.containsKey($modelWiseEntry.getKey()))
58 
                        <td>$nf.format($additionalSalePayoutMap.get($modelWiseEntry.getKey()))</td>
59 
                    #else
60 
                        <td>--</td>
61 
                    #end
30409 amit.gupta 62 
 
32232 amit.gupta 63 
                    #if($modelWiseSalesMarginsMap.containsKey($modelWiseEntry.getKey()))
64 
                        <td>$modelWiseSalesMarginsMap.get($modelWiseEntry.getKey()).getAmount()</td>
30409 amit.gupta 65 
                    #else
32232 amit.gupta 66 
                        <td> -</td>
67 
                    #end
68 
                    #if($modelIncomeMap.containsKey($modelWiseEntry.getKey()))
69 
                        <td>$nf.format($modelIncomeMap.get($modelWiseEntry.getKey()))</td>
70 
                    #else
30409 amit.gupta 71 
                        <td>--</td>
72 
                    #end
73 
                </tr>
74 
                #end
31352 amit.gupta 75 
            </tbody>
30409 amit.gupta 76 
 
77 
            <tfoot>
31352 amit.gupta 78 
            <tr class="model-sum-footer">
79 
                <th>Total</th>
80 
                <th></th>
81 
                <th></th>
82 
                <th></th>
83 
                <th></th>
84 
                <th></th>
85 
                <th></th>
86 
                <th></th>
87 
                <th></th>
32232 amit.gupta 88 
                <th></th>
30409 amit.gupta 89 
            </tr>
90 
            </tfoot>
91 
        </table>
92 
    </div>
93 
</section>
94 
 
95 
<script type="text/javascript">
96 
 
97 
    $(document).ready(function () {
30225 tejbeer 98 
        var table = $('#brandWiseIncome').DataTable(
30055 manish 99 
                {
100 
                    "bPaginate": true,
101 
                    "bLengthChange": true,
102 
                    "bFilter": true,
103 
                    "bInfo": false,
104 
                    "bAutoWidth": false,
105 
                    "scrollX": true,
31380 amit.gupta 106 
                    "pageLength": 20
30409 amit.gupta 107 
 
108 
                });
30414 amit.gupta 109 
        datatableSum(table);
30409 amit.gupta 110 
        table.on('search.dt', function () {
111 
            console.log('Currently applied global search: ' + table.search());
30414 amit.gupta 112 
            datatableSum(table);
30225 tejbeer 113 
        });
30409 amit.gupta 114 
 
115 
    });
116 
 
117 
 
30414 amit.gupta 118 
    function datatableSum(datatable) {
32232 amit.gupta 119 
        for (let i = 1; i <= 9; i++) {
31352 amit.gupta 120 
            var col_sum = datatable.column(i, {page: 'current'}).data().sum();
121 
            $(datatable.column(i).footer()).html(numberToComma(Math.round(col_sum)));
122 
        }
30409 amit.gupta 123 
    }
124 
</script>
30055 manish 125 
 
30225 tejbeer 126 
 
127 
 
128 
 
129