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>Selling Price - DP</th>
                    <th>Total</th>
                </tr>
                </thead>
                <tbody>
                    #foreach($brand in $brandSet)
                    <tr class="brand-wise-income" data-brand="$brand" data-month="$month" data-status="$status">
                        <td>$brand</td>

                        #if($lastMonthPurchaseInMarginMap.containsKey($brand))
                            <td>$nf.format($lastMonthPurchaseInMarginMap.get($brand).getAmount())</td>
                        #else
                            <td>0</td>
                        #end
                        #if($additionalPurchasePayoutMap.containsKey($brand))
                            <td>$nf.format($additionalPurchasePayoutMap.get($brand))</td>
                        #else
                            <td>0</td>
                        #end
                        #if($lastMonthCategoryUpgradeMarginMap.containsKey($brand))
                            #if($lastMonthSaleMarginMap.get($brand).getAmount())

                                <td>$nf.format($lastMonthSaleMarginMap.get($brand).getAmount()) <i
                                        class='far fa-arrow-alt-circle-up' style="color: green;"
                                        title="$nf.format($lastMonthCategoryUpgradeMarginMap.get($brand)) 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($brand)) Category Upgrade Additional Margin."></i>
                                </td>
                            #end


                        #else
                            #if($lastMonthSaleMarginMap.get($brand).getAmount())

                                <td>$nf.format($lastMonthSaleMarginMap.get($brand).getAmount()) </td>
                            #else
                                <td>0</td>
                            #end

                        #end
                        #if($lastMonthPendingIncomeMap.get($brand).getAmount())
                            <td>$nf.format($lastMonthPendingIncomeMap.get($brand).getAmount())</td>

                        #else
                            <td>0</td>
                        #end
                        #if($additionalSalePayoutMap.containsKey($brand))
                            <td>$nf.format($additionalSalePayoutMap.get($brand))</td>
                        #else
                            <td>0</td>
                        #end
                        <td>
                            #if($lastMonthFrontEndIncomeMap.containsKey($brand))
                                $lastMonthFrontEndIncomeMap.get($brand).getAmount()
                            #else
                                0
                            #end
                        </td>
                        <td>
                            #if($totalAmountMap.get($brand))
                                $nf.format($totalAmountMap.get($brand))
                            #else
                                0
                            #end
                        </td>

                    </tr>
                    #end

                </tbody>
                <tfoot>
                <tr class="footer">
                    <th>Total</th>
                    <th></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({
            "pageLength": 20
        });

        $('#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>