Subversion Repositories SmartDukaan

<section>
    <div>
        <table class="table table-border table-condensed table-bordered" id="brandWiseIncome">
            <thead>
            <tr style="color:black;">
                <th>Model Name</th>
                <th>Prch Qty</th>
                <th>Prch Margin</th>
                <th>Booster Margin</th>
                <th>Sale Qty</th>
                <th>Sale Margin</th>
                <th>Pending Margin</th>
                <th>Addl Margin</th>
                <th>Selling Price - DP</th>
                <th>Total Amount</th>
            </tr>
            </thead>
            <tbody>
                #foreach($modelWiseEntry in $modelNameMap.entrySet())
                <tr class="imei_wise_income" data-catalogitemid="$modelWiseEntry.getKey()"
                    data-month="$month">
                    <td>$modelWiseEntry.getValue()</td>
                    <td>$modelPurchaseQtyMap.get($modelWiseEntry.getKey())</td>
                    #if($modelWiseSchemeInMarginsMap.containsKey($modelWiseEntry.getKey()))
                        <td>$nf.format($modelWiseSchemeInMarginsMap.get($modelWiseEntry.getKey()).getAmount())</td>
                    #else
                        <td>--</td>
                    #end
                    #if($additionalPurchasePayoutMap.containsKey($modelWiseEntry.getKey()))
                        <td>$nf.format($additionalPurchasePayoutMap.get($modelWiseEntry.getKey()))</td>
                    #else
                        <td>--</td>
                    #end
                    #if($modelSaleQtyMap.containsKey($modelWiseEntry.getKey()))
                        <td>$modelSaleQtyMap.get($modelWiseEntry.getKey())</td>
                        #if($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getAmount() > 0)
                            <td>$nf.format($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getAmount())
                                #if($categoryUpgradeBrandModelMap.containsKey($modelWiseEntry.getKey()))
                                    <i class="far fa-arrow-alt-circle-up" style="color: green;"
                                       title="$nf.format($categoryUpgradeBrandModelMap.get($modelWiseEntry.getKey())) Category Upgrade Additional Margin.">
                                    </i>
                                #end
                            </td>
                        #else
                            <td>--</td>
                        #end
                        #if($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getPendingSaleAmount() > 0)
                            <td>$nf.format($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getPendingSaleAmount())</td>
                        #else
                            <td>--</td>
                        #end
                    #else
                        <td>--</td>
                        <td>--</td>
                        <td>--</td>
                    #end
                    #if($additionalSalePayoutMap.containsKey($modelWiseEntry.getKey()))
                        <td>$nf.format($additionalSalePayoutMap.get($modelWiseEntry.getKey()))</td>
                    #else
                        <td>--</td>
                    #end

                    #if($modelWiseSalesMarginsMap.containsKey($modelWiseEntry.getKey()))
                        <td>$modelWiseSalesMarginsMap.get($modelWiseEntry.getKey()).getAmount()</td>
                    #else
                        <td> -</td>
                    #end
                    #if($modelIncomeMap.containsKey($modelWiseEntry.getKey()))
                        <td>$nf.format($modelIncomeMap.get($modelWiseEntry.getKey()))</td>
                    #else
                        <td>--</td>
                    #end
                </tr>
                #end
            </tbody>

            <tfoot>
            <tr class="model-sum-footer">
                <th>Total</th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
            </tr>
            </tfoot>
        </table>
    </div>
</section>

<script type="text/javascript">

    $(document).ready(function () {
        var table = $('#brandWiseIncome').DataTable(
                {
                    "bPaginate": true,
                    "bLengthChange": true,
                    "bFilter": true,
                    "bInfo": false,
                    "bAutoWidth": false,
                    "scrollX": true,
                    "pageLength": 20

                });
        datatableSum(table);
        table.on('search.dt', function () {
            console.log('Currently applied global search: ' + table.search());
            datatableSum(table);
        });

    });


    function datatableSum(datatable) {
        for (let i = 1; i <= 9; i++) {
            var col_sum = datatable.column(i, {page: 'current'}).data().sum();
            $(datatable.column(i).footer()).html(numberToComma(Math.round(col_sum)));
        }
    }
</script>