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;" name="month-wise-income" placeholder="months" style="margin:auto;">
                                                                    <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 class="col-lg-3" style="color: green;">
                                                    <h4>Category Upgrade Margin
                                                      <i class='far fa-arrow-alt-circle-up'></i>
                                                    </h4>
                                               </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>
               <td>Total</td>
               <td>-</td>
               <td id="purchase-total"></td>
               
                  <td>-</td>
                <td id="sale-total"></td>
               <td id="pending-total"></td>
               
                  <td id="sum-total"></td>
             
             </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 = $('#lmiCreditedIncome').DataTable().column(2,{page:'current'}).data().sum();
                 $('#purchase-total').html(col_two_sum);
              
               var col_four_sum = $('#lmiCreditedIncome').DataTable().column(4,{page:'current'}).data().sum();
                 console.log(col_four_sum)
                  $('#sale-total').html(col_four_sum);
                    
                   var col_five_sum = $('#lmiCreditedIncome').DataTable().column(5,{page:'current'}).data().sum();
                 $('#pending-total').html(col_five_sum);
              
              
               var col_six_sum = $('#lmiCreditedIncome').DataTable().column(6,{page:'current'}).data().sum();
                 console.log(col_six_sum)
                  $('#sum-total').html(col_six_sum);
                    
             }
        
    
    </script>