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