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.get($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($categoryUpradeBrandModelMap.get($modelWiseEntry.getKey()))
                                    <i class="far fa-arrow-alt-circle-up" style="color: green;"
                                       title="$nf.format($categoryUpradeBrandModelMap.get($modelWiseEntry.getKey())) Category Upgrade Additional Margin.">
                                    </i>
                                #end
                            </td>
                        #else
                            <td>--</td>
                        #end
                        #if($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getPendingAmount() > 0)
                            <td>$nf.format($modelWiseSchemeOutMarginsMap.get($modelWiseEntry.getKey()).getPendingAmount())</td>
                        #else
                            <td>--</td>
                        #end
                    #else
                        <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 () {
        datatableSum();
        var table = $('#brandWiseIncome').DataTable(
                {
                    "bPaginate": true,
                    "bLengthChange": true,
                    "bFilter": true,
                    "bInfo": false,
                    "bAutoWidth": false,
                    "scrollX": true,

                });

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

    });


    function datatableSum() {

        var col_two_sum = $('#brandWiseIncome').DataTable().column(2, {page: 'current'}).data().sum();
        $('#brand-purchase-total').html(numberToComma(col_two_sum));

        var col_four_sum = $('#brandWiseIncome').DataTable().column(4, {page: 'current'}).data().sum();
        console.log(col_four_sum)
        $('#brand-sale-total').html(numberToComma(col_four_sum));

        var col_five_sum = $('#brandWiseIncome').DataTable().column(5, {page: 'current'}).data().sum();
        $('#brand-pending-total').html(numberToComma(col_five_sum));


        var col_six_sum = $('#brandWiseIncome').DataTable().column(6, {page: 'current'}).data().sum();
        console.log(col_six_sum)
        $('#brand-sum-total').html(numberToComma(col_six_sum));

    }


</script>