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-4">
            <table class="table table-border table-condensed table-bordered" id="lmiCreditedIncome">

                <thead class="row htable">

                <tr style="color:black;">
                    <th>Brand</th>
                    <th>Purchase Qty</th>
                    <th>Purchase Margin</th>
                    <th>Sale Qty</th>
                    <th>Sale Margin</th>
                    <th>Pending Sale Margin</th>
                    <th>Total Income</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).getQty())
                            <td>$lastMonthPurchaseInMarginMap.get($key).getQty()</td>
                        #else
                            <td>0</td>
                        #end
                        #if($lastMonthPurchaseInMarginMap.get($key).getAmount())
                            <td>$nf.format($lastMonthPurchaseInMarginMap.get($key).getAmount())</td>
                        #else
                            <td>0</td>
                        #end
                        #if($lastMonthSaleMarginMap.get($key).getQty())
                            <td>$lastMonthSaleMarginMap.get($key).getQty()</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($totalAmountMap.get($key))

                            <td>$nf.format($totalAmountMap.get($key))</td>
                        #else
                            <td>0</td>
                        #end

                    </tr>
                    #end

                </tbody>
                <tfoot>
                <tr>
                    <th>Total</th>
                    <th>-</th>
                    <th id="purchase-total"></th>

                    <th>-</th>
                    <th id="sale-total"></th>
                    <th id="pending-total"></th>

                    <th id="sum-total"></th>

                </tr>
                </tfoot>


            </table>
        </div>


        <div class="col-lg-8 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() {

        var col_two_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(2, {page: 'current'}).data().sum());
        $('#purchase-total').html(`<b>${col_two_sum}</b>`);

        var col_four_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(4, {page: 'current'}).data().sum());
        console.log(col_four_sum)
        $('#sale-total').html(`<b>${col_four_sum}</b>`);

        var col_five_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(5, {page: 'current'}).data().sum());
        $('#pending-total').html(`<b>${col_five_sum}</b>`);


        var col_six_sum = numberToComma($('#lmiCreditedIncome').DataTable().column(6, {page: 'current'}).data().sum());
        console.log(col_six_sum)
        $('#sum-total').html(`<b>${col_six_sum}</b>`);

    }


</script>