Subversion Repositories SmartDukaan

<section class="wrapper">

    <div class="row">

        <div class="col-lg-12">

            <h3 class="page-header"><i class="icon_document_alt"></i>Credited Income</h3>

            <ol class="breadcrumb">

                <li><i class="fa fa-home"></i><a href="${rc.contextPath}/dashboard">Home</a></li>

                <li><i class="icon_document_alt"></i>Credited Income</li>

            </ol>

        </div>

    </div>

    <div class="row">

        <div class="form-group">

            <label class="control-label col-lg-1" for="months" style="color:green;">Select Month</label>

            <div class="col-lg-2">

                <select class="form-control input-sm" id="month-wise-income"

                        style="font-weight: bold;margin:auto;" name="month-wise-income"

                        placeholder="months">

                    <option value="" disabled selected>Month</option>

                    #foreach($mVM in $monthValueMap.entrySet())

                        #if($mVM.getKey()== $month )

                        <b>

                            <option value="$mVM.getKey()" selected>$mVM.getValue()</option>

                        #else

                        <b>

                            <option value="$mVM.getKey()">$mVM.getValue()</option>

                        #end

                    #end

                </select>

            </div>

        </div>

    </div>

    <div class="row">

        <div class="col-lg-5">

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

                <thead>

                <tr style="color:black;">

                    <th>Brand</th>

                    <th>Purchase Margin</th>

                    <th>Booster Margin</th>

                    <th>Sale Margin</th>

                    <th>Pending Margin</th>

                    <th>Addnl Margin</th>

                    <th>Total</th>

                </tr>

                </thead>

                <tbody>

                    #foreach($key in $keySet)

                    <tr class="brand-wise-income" data-brand="$key" data-month="$month" data-status="$status">

                        <td>$key</td>

                        #if($lastMonthPurchaseInMarginMap.get($key).getAmount())

                            <td>$nf.format($lastMonthPurchaseInMarginMap.get($key).getAmount())</td>

                        #else

                            <td>0</td>

                        #end

                        #if($additionalPurchasePayoutMap.containsKey($key))

                            <td>$nf.format($additionalPurchasePayoutMap.get($key))</td>

                        #else

                            <td>0</td>

                        #end

                        #if($lastMonthCategoryUpgradeMarginMap.get($key))

                            #if($lastMonthSaleMarginMap.get($key).getAmount())

                                <td>$nf.format($lastMonthSaleMarginMap.get($key).getAmount()) <i

                                        class='far fa-arrow-alt-circle-up' style="color: green;"

                                        title="$nf.format($lastMonthCategoryUpgradeMarginMap.get($key)) Category Upgrade Additional Margin."></i>

                                </td>

                            #else

                                <td>0<i class='far fa-arrow-alt-circle-up' style="color: green;"

                                        title="$nf.format($lastMonthCategoryUpgradeMarginMap.get($key)) Category Upgrade Additional Margin."></i>

                                </td>

                            #end

                        #else

                            #if($lastMonthSaleMarginMap.get($key).getAmount())

                                <td>$nf.format($lastMonthSaleMarginMap.get($key).getAmount()) </td>

                            #else

                                <td>0</td>

                            #end

                        #end

                        #if($lastMonthPendingIncomeMap.get($key).getAmount())

                            <td>$nf.format($lastMonthPendingIncomeMap.get($key).getAmount())</td>

                        #else

                            <td>0</td>

                        #end

                        #if($additionalSalePayoutMap.containsKey($key))

                            <td>$nf.format($additionalSalePayoutMap.get($key))</td>

                        #else

                            <td>0</td>

                        #end

                        #if($totalAmountMap.get($key))

                            <td>$nf.format($totalAmountMap.get($key))</td>

                        #else

                            <td>0</td>

                        #end

                    </tr>

                    #end

                </tbody>

                <tfoot>

                <tr class="footer">

                    <th>Total</th>

                    <th></th>

                    <th></th>

                    <th></th>

                    <th></th>

                    <th></th>

                    <th></th>

                </tr>

                </tfoot>

            </table>

        </div>

        <div class="col-lg-7 brand-wise-income-container"></div>

    </div>

    <div class="imei-wise-income-container"></div>

</section>

<script type="text/javascript">

    $(document).ready(function () {

        var table = $('#lmiCreditedIncome').DataTable();

        $('#lmiCreditedIncome tbody').on('click', 'tr', function () {

            if ($(this).hasClass('selected')) {

                $(this).removeClass('selected');

            } else {

                table.$('tr.selected').removeClass('selected');

                $(this).addClass('selected');

            }

        });

        datatableSum();

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

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

            datatableSum();

        });

    });

    function datatableSum() {

        let dataTable = $('#lmiCreditedIncome').DataTable();

        let footerContainer = $('#lmiCreditedIncome').find('tr.footer')

        var col_one_sum = numberToComma(dataTable.column(1, {page: 'current'}).data().sum());

        footerContainer.find('th').eq(1).html(`<b>${col_one_sum}</b>`);

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

        footerContainer.find('th').eq(2).html(`<b>${col_two_sum}</b>`);

        var col_three_sum = numberToComma(dataTable.column(3, {page: 'current'}).data().sum());

        footerContainer.find('th').eq(3).html(`<b>${col_three_sum}</b>`);

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

        footerContainer.find('th').eq(4).html(`<b>${col_four_sum}</b>`);

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

        footerContainer.find('th').eq(5).html(`<b>${col_five_sum}</b>`);

        var col_six_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(6, {page: 'current'}).data().sum());

        footerContainer.find('th').eq(6).html(`<b>${col_six_sum}</b>`);

        /*

                var col_seven_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(7, {page: 'current'}).data().sum());

                footerContainer.find('th').eq(7).html(`<b>${col_seven_sum}</b>`);

        var col_eight_sum = numberToComma(dataTable.column(8, {page: 'current'}).data().sum());

        footerContainer.find('th').eq(8).html(`<b>${col_eight_sum}</b>`);*/

    }

</script>