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 $modelWiseMap.entrySet())
           
            #if($modelWiseEntry.getValue().getCatalogItemId())
               <tr class="imei_wise_income" data-catalogitemid="$modelWiseEntry.getValue().getCatalogItemId()" data-month="$month">
            #else
               <tr class="imei_wise_income" data-catalogitemid="$purchaseWiseMap.get($modelWiseEntry.getKey()).getCatalogItemId()" data-month="$month">
            #end
              
              #if($modelWiseEntry.getValue().getModelName())
                <td>$modelWiseEntry.getValue().getModelName() $modelWiseEntry.getKey()</td>
                #else
                <td>$modelWiseEntry.getKey()</td>
              #end
           
              #if($purchaseWiseMap.get($modelWiseEntry.getKey()).getQty())
                 <td>$purchaseWiseMap.get($modelWiseEntry.getKey()).getQty()</td>
              #else
                 <td>--</td>
              #end
              #if($purchaseWiseMap.get($modelWiseEntry.getKey()).getAmount())
                 <td>$nf.format($purchaseWiseMap.get($modelWiseEntry.getKey()).getAmount())</td>
              #else
                 <td>--</td>
              #end
              
              #if($modelWiseEntry.getValue().getQty() )
                  <td>$modelWiseEntry.getValue().getQty()</td>
              #else
                   <td>--</td>
              #end
              
             #if($categoryUpradeBrandModelMap.get($modelWiseEntry.getKey()))
          
               #if($modelWiseEntry.getValue().getAmount())
                  <td>$nf.format($modelWiseEntry.getValue().getAmount()) <i class='far fa-arrow-alt-circle-up' style="color: green;" title="$nf.format($categoryUpradeBrandModelMap.get($modelWiseEntry.getKey())) Category Upgrade Additional Margin."></i></td>
              #else
                  <td> --  <i class='far fa-arrow-alt-circle-up' style="color: green;" title="$nf.format($categoryUpradeBrandModelMap.get($modelWiseEntry.getKey())) Category Upgrade Additional Margin."></i></td>
              #end
              #else
              #if($modelWiseEntry.getValue().getAmount())
                  <td>$nf.format($modelWiseEntry.getValue().getAmount()) </td>
              #else
                  <td>--</td>
              #end
              
              #end
              
              #if($modelWiseEntry.getValue().getPendingSaleAmount())
              <td>$modelWiseEntry.getValue().getPendingSaleAmount()</td>
              #else
                <td>--</td>
              #end
              
              #if($modelWiseTotalAmount.get($modelWiseEntry.getKey()))
                  <td>$nf.format($modelWiseTotalAmount.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() {
        var table = $('#brandWiseIncome').DataTable(
                {
                    "bPaginate": true,
                    "bLengthChange": true,
                    "bFilter": true,
                    "bInfo": false,
                    "bAutoWidth": false,
                    "scrollX": true,
                   
            });
            
           datatableSum();
                    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(col_two_sum);
              
               var col_four_sum = $('#brandWiseIncome').DataTable().column(4,{page:'current'}).data().sum();
                 console.log(col_four_sum)
                  $('#brand-sale-total').html(col_four_sum);
                    
                   var col_five_sum = $('#brandWiseIncome').DataTable().column(5,{page:'current'}).data().sum();
                 $('#brand-pending-total').html(col_five_sum);
              
              
               var col_six_sum = $('#brandWiseIncome').DataTable().column(6,{page:'current'}).data().sum();
                 console.log(col_six_sum)
                  $('#brand-sum-total').html(col_six_sum);
                    
             }
   
    
    </script>