Subversion Repositories SmartDukaan

<section>

    <div>

        <table class="table table-border table-condensed table-bordered" id="brandWiseIncome">

            <thead class="row htable">

            <tr style="color:black;">

                <th>Model Name</th>

                <th>Purchase Qty</th>

                <th>Purchase Margin</th>

                <th>Sale Qty</th>

                <th>Sale Margin</th>

                <th>Pending Sale Magin</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>

                    #if($modelWiseSchemeInMarginsMap.containsKey($modelWiseEntry.getKey()))

                        <td>$modelWiseSchemeInMarginsMap.get($modelWiseEntry.getKey()).getQty()</td>

                        <td>$nf.format($modelWiseSchemeInMarginsMap.get($modelWiseEntry.getKey()).getAmount())</td>

                    #else

                        <td>--</td>

                        <td>--</td>

                    #end

                    #if($modelWiseSchemeOutMarginsMap.containsKey($modelWiseEntry.getKey()))

                        <td>$modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getQty()</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($modelTotalIncomeMap.get($modelWiseEntry.getKey()))

                        <td>$nf.format($modelTotalIncomeMap.get($modelWiseEntry.getKey()))</td>

                    #else

                        <td>--</td>

                    #end

                </tr>

                #end

            <tbody>

            <tfoot>

            <tr>

                <td style="font-weight: bold;">Total</td>

                <td>-</td>

                <td id="brand-purchase-total"></td>

                <td>-</td>

                <td id="brand-sale-total"></td>

                <td id="brand-pending-total"></td>

                <td id="brand-sum-total"></td>

            </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,

                });

        datatableSum(table);

        table.on('search.dt', function () {

            console.log('Currently applied global search: ' + table.search());

            datatableSum(table);

        });

    });

    function datatableSum(datatable) {

        var col_two_sum = datatable.column(2, {page: 'current'}).data().sum();

        $(datatable.column(2).footer()).html(numberToComma(Math.round(col_two_sum)));

        var col_four_sum = datatable.column(4, {page: 'current'}).data().sum();

        $(datatable.column(4).footer()).html(numberToComma(Math.round(col_four_sum)));

        var col_five_sum = datatable.column(5, {page: 'current'}).data().sum();

        $(datatable.column(5).footer()).html(numberToComma(Math.round(col_five_sum)));

        var col_six_sum = datatable.column(6, {page: 'current'}).data().sum();

        $(datatable.column(6).footer()).html(numberToComma(Math.round(col_six_sum)));

    }

</script>