EVOLUTION-NINJA

Edit File: report_status_grid.php

<h1 style="text-align: center;"><p class="statustype"></p> </h1>
        <b><p class="executive" style="text-align: center;"></p></b>
         <b><p class="logistic" style="text-align: center;"></p></b>
        
        <input type="hidden" class="form-control col-sm-8 id" name="id"  required="required"> 
        
      </section>
      <section class="content">
          <div >
            <input type="button" class="btn btn-primary pull-left" value="Back" onclick="fun_back()" style="" >
             <button type="submit" id="payment_submit_export" style="margin-top:0px; margin-left:10px;" class="btn btn-primary payment_submit_export">Export</button>
             <button type="print_submit" id="payment_submit_print" style="margin-top:0px; margin-left:10px;" class="btn btn-primary payment_submit_print">Print</button>
          </div>  
          
                    
            <div class="" style="padding-left: 25px; padding-right: 25px; padding-top:40px !important;">
            <div class="row" class="regis-block">
             
                <div class="mode_of_payment" style="overflow:scroll;">
                
                    
                    <p class="total_balance_amount" style="color:red;display:none;"></p>
                    <p class="total_received_amount" style="color:green; margin-bottom:50px;display:none;" ></p>
                    <p id="dimension" style="color:black;display:none;"></p>
                    <p id="total_tsv" style="color:black;display:none;"></p>
                    <p id="booking_amount" style="color:black;display:none;"></p>

<div class='table-cont' id='table-cont'>
                     <table cellpadding="0" cellspacing="0"  class="dataTable d_mode_of_pay table" id="example">
                        
                        
                        <thead>
                            <tr>
                                <th>Sl_No</th>
                                <th>Project__Name</th>
                                <th>Booking__Date</th>
                                <th>Site_No</th>
                                <th class="dimensions">Dimension</th>
                                <th>Source</th>
                                <th>Name</th>
                                <th>TSV</th>
                               <th>Khata__Status</th>
                               <th>Booking__Amount</th>
                               <th>Agreements__Date</th>
                               <th>Agreements__Amount</th>
                               <th>Balance__Agreements</th>
                               <th>Installments__Date</th>
                               <th>Installments__Amount</th>
                               <th>Balance__Installments</th>
                               <th>Registrations__Date</th>
                               <th>Registrations__Amount</th>
                               <th>Balance__Registrations</th>
                               <th>Total__Balance</th>
                               <th>GSS__Amount</th>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
                            </tr>
                        </thead>
                        
                        <tbody class="payment_client_details">
                        </tbody>
                        
                        <tfoot><tr><th></th><th></th><th></th><th></th><th></th><th colspan="2"></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th></tr></tfoot>
                        
                    </table>
                    </div>
                </div>
                
                <div class="">
                   <div class="container-fluid export_payment_mode_table" style="padding-top:3%;">
                        <table border="1" id="export_payment_table" class="table export_payment_table">
                        
                        </table>
                    </div>
               </div>
                <div class="">
                   <div class="container-fluid print_payment_mode_table" style="padding-top:3%;">
                        <table border="1" id="print_payment_table" class="table print_payment_table">
                        
                        </table>
                    </div>
               </div>
            
             
            </div>  
        </div>
      </section> 
</div>

</style>

TotalBookedDimensions();
  function TotalBookedDimensions()
  {
    $.ajax({
          type   : 'post',
          url    : '<?php echo site_url("get-total-dimension-for-unbooked-sites")?>',   
          data   : {},                        
          success:function(response)
          {
            //   response=jQuery.parseJSON(response);
            //   console.log(response);
            //   alert(response);
              if(response.result == 1)
              {
                  $.each(response.total_marketing,function(index,val)
                  {
                      
                      $('#total_marketing_dimension').html('Total Given for Marketing : '+val.total_in_sqft);
                  });
                   $.each(response.booked_sqft,function(index,val)
                  {
                    
                  
                   $('#total_booked_dimension').html('Booked Sites Dimension : '+val.booked_sqft);

});
                 
              }
              else
              {
                  $('#total_marketing_dimension').html('Total Given for Marketing : 0');
                  $('#total_booked_dimension').html('Booked Sites Dimension : 0');
              }
              
             
          }
      });
  }
  
  CallGrid();
});

var key=i+1;

if(gss_amount != 0)
                 {
                    var x=gss_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                        lastThree = ',' + lastThree;
                    var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
                    var gss_amount =res+'/-';
                }
                else
                {
                     var gss_amount = 0+'/-';
                }
               // alert(gss_amount);
                 var booking_amount_wc = response[i].booking_amount;
                
                 var total_rec_agr = response[i].agreement_amount;

if(total_rec_agr != 0)
                {
                    var total_rec_agr = total_rec_agr;
                }
                else
                {
                    var total_rec_agr = 0;
                }
                
                 
                 var total_rec_ins = response[i].installment_amount;
               
                 if(total_rec_ins != undefined ||  total_rec_ins != '0')
                {
                    total_rec_ins = total_rec_ins;
                }
                else
                {
                    total_rec_ins = 0;
                }
                 
                var total_rec_reg = response[i].registration_amount;

if(total_rec_reg != 0 || total_rec_reg != '' || total_rec_reg != undefined ||  total_rec_reg != 'undefined')
                {
                    total_rec_reg = total_rec_reg;
                }
                else
                {
                    total_rec_reg = 0;
                }
                    
                if(response[i].booking_amount == 0)
                {
                    var booking_amount = '';
                }
                else
                {
                    var x=response[i].booking_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                        lastThree = ',' + lastThree;
                    var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
                    var booking_amount =res+'/-';
                }
                
                if(response[i].booking_date != "")
                {
                    var booking_date = response[i].booking_date;
                }
                else
                {
                    var booking_date = '';
                }
                
                if(response[i].agreement_amount_due_amount == 0)
                {
                    agreement_amount += '';
                   
                }
                else
                {
                    agreement_amount += response[i].agreement_amount_due_amount;
                     
                }
                
                if(response[i].agreement_date_due_date != "")
                {
                    agreement_date += response[i].agreement_date_due_date;
                }
                else
                {
                    agreement_date += '';
                }
                
                var balance_agr = response[i].balance_agreement_amount;
                if(balance_agr != 0 || balance_agr != '')
                {
                    balance_agr = balance_agr;
                }
                else
                {
                    balance_agr = 0;
                }
                
               
                
                if(response[i].balance_agreement_amount != 0 || response[i].balance_agreement_amount != '')
                {
                    var x=response[i].balance_agreement_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                        lastThree = ',' + lastThree;
                    var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
                    var balance_agreement_amount =res+'/-';
                    var balance_agreement = balance_agreement_amount;
                }
                else
                {
                    var balance_agreement = '0';
                }
                
                $.each( response[i].installment_details, function( key, value ) 
                {
                    var count = key+1;
                
                    if(value.installment_amount_due_amount == 0)
                    {

installment_amount += '';
                    }
                    else
                    {
                        installment_amount += 'Installment '+ count +':'+value.installment_amount_due_amount+'<hr style="height:2px;border-width:0;color:gray;background-color:gray;white-space: nowrap;">';

}
                   //agreement_date += '<br/> Installment : <br/> '+value.installment_date;
                   if(value.installment_date_due_date != "")
                    {
                        installment_date += 'Installment '+ count +':'+value.installment_date_due_date+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                    }
                    else
                    {
                        installment_date += '';
                    }
                });
                
                var balance_ins_wc = response[i].balance_installment;
                if(balance_ins_wc != 0 || balance_ins_wc != '')
                {
                    balance_ins_wc = balance_ins_wc;
                }
                else
                {
                    balance_ins_wc = 0;
                }
                
                if(response[i].balance_installment != 0 || response[i].balance_installment != '')
                {
                    var x=String(response[i].balance_installment);
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                        lastThree = ',' + lastThree;
                    var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
                    var balance_installment_amount =res+'/-';
                    var balance_installment = balance_installment_amount;
                }
                else
                {
                    var balance_installment = '0';
                }
                
                $.each( response[i].registration_details, function( key, value ) 
                {
                    var count = key+1;

if(value.registration_amount_due_amount == 0)
                    {
                        registration_amount += '';
                    }
                    else
                    {
                        registration_amount += 'Registration '+ count +':'+value.registration_amount_due_amount+'<hr style="height:2px;border-width:0;color:gray;background-color:gray;white-space: nowrap;">';
                    }
                   //agreement_date += '<br/> Installment : <br/> '+value.installment_date;
                   if(value.registration_date_due_date != "")
                    {
                        registration_date += 'Registration '+ count +':'+value.registration_date_due_date+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                    }
                    else
                    {
                        registration_date += '';
                    }

});
                
                var balance_reg_wc = response[i].balance_registration;
                if(balance_reg_wc != 0 || balance_reg_wc != '')
                {
                    balance_reg_wc = balance_reg_wc;
                }
                else
                {
                    balance_reg_wc = 0;
                }
                
                if(response[i].balance_registration != 0 || response[i].balance_registration != '')
                {
                  //alert(response[i].balance_registration);
                    var x=response[i].balance_registration.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                        lastThree = ',' + lastThree;
                    var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
                    var balance_reg_amount =res+'/-';
                    var balance_registration = balance_reg_amount;
                }
                else
                {
                    var balance_registration = '0';
                }
                if(dimension  != 0)
                {
                arrayReturn.push([id,project_name,booking_date,site_number,dimension,source,customer_name,tsv,khata_status,booking_amount,agreement_date,agreement_amount,balance_agreement,installment_date,installment_amount,balance_installment,registration_date,registration_amount,balance_registration,total_balance,gss_amount,tsv_wc,booking_amount_wc,total_rec_agr,balance_agr,total_rec_ins,balance_ins_wc,total_rec_reg,balance_reg_wc,balance_amount_total,gss_amount_wc]);
             }
             id++;
            }
            inittable(arrayReturn);
            }
          // alert(arrayReturn)
        }
    });
            
    function inittable(data) 
    {   
        
        $('#example thead th').each( function () {
        });
        
        $('#example').DataTable({
           
             
            destroy: true,
            "bInfo" : false,
            "aaData": data,
            "dom": 'lBfrtip',
            filter: 'applied',
           
    
    
            buttons: [
                
             ],
             
            "columnDefs": [
                
            {
                "targets": [ 21 ],
                "visible": false
            },
            {
                "targets": [ 22 ],
                "visible": false
            },
            {
                "targets": [ 23 ],
                "visible": false
            },
            {
                "targets": [ 24 ],
                "visible": false
            },
            {
                "targets": [ 25 ],
                "visible": false
            },
            {
                "targets": [ 26 ],
                "visible": false
            },
            {
                "targets": [ 27 ],
                "visible": false
            },
            {
                "targets": [ 28 ],
                "visible": false
            },
            {
                "targets": [ 29 ],
                "visible": false
            }
            ,
            {
                "targets": [ 30 ],
                "visible": false
            }
            ],
            
           
            
            "rowCallback" : function(row, data, index,full)
            {
                col13 = this.api().column(12).index('visible');
                col16 = this.api().column(15).index('visible');
                col19 = this.api().column(18).index('visible');
                col20 = this.api().column(19).index('visible');
                
                $('td', row).eq(col13).css('color', 'red');
                $('td', row).eq(col16).css('color', 'red');
                $('td', row).eq(col19).css('color', 'red');
                $('td', row).eq(col20).css('color', 'red');
            },
             
            "footerCallback": function ( row, data, start, end, display ) 
            {
                var api = this.api(), data;
                CalculateTableSummary(this,row, data, start, end, display);
            },

"fnRowCallback": function(nRow, aData, iDisplayIndex){
                $("td:first", nRow).html(iDisplayIndex +1);
               return nRow;
            },
            
            initComplete: function () 
            {
                this.api().columns(3).every( function () 
                {
                    var column = this;
                    var select = $('<select style="color: black;"><option value=""></option></select>')
                        .appendTo( $(column.header()).empty() )
                        .on( 'change', function () {
                            var val = $.fn.dataTable.util.escapeRegex(
                                $(this).val()
                            );
     
                            column
                                .search( val ? '^'+val+'$' : '', true, false )
                                .draw();
                        } );
     
                    //column.data().unique().sort().each( function ( d, j ) {
                     column.order('asc').draw(false).data().unique().each( function ( d, j ) {
                        select.append( '<option value="'+d+'">'+d+'</option>' )
                    } );
                });
            }
               
        });
    }
    
    function CalculateTableSummary(table,row, data, start, end, display)
    {
        try 
        {
            var intVal = function (i)
            {
                return typeof i === 'string' ?
                i.replace(/[\$,]/g, '') * 1 :
                typeof i === 'number' ?
                i : 0;
            };
            
            var api = table.api();
            
            api.columns(".dimensions").eq(0).each(function (index) 
            {
                var column = api.column(index,{page:'current'});
                var all_data=api.rows( { filter : 'applied'} ).data();
                api.on('search.dt', function() {
                    var all_data=api.rows( { filter : 'applied'} ).data();
                })  
                
                var count =api.rows( { filter : 'applied'} ).nodes().length;
                var dim=0;
                var tsv = 0;
                var booking_amt = 0;
                var total_rec_agr = 0;
                var balance_agr = 0;
                var total_rec_ins = 0;
                var balance_ins = 0;
                var total_rec_reg = 0;
                var balance_reg = 0;
                var total_balance = 0;
                var gss_amount = 0;
                for( i=0;i < count;i++)
                {
                    dim = parseFloat(dim) + parseFloat(all_data[i][4]);
                    tsv = parseFloat(tsv) + parseFloat(all_data[i][21]);
                    booking_amt = parseFloat(booking_amt) + parseFloat(all_data[i][22]);
                    total_rec_agr = parseFloat(total_rec_agr) + parseFloat(all_data[i][23]);
                    balance_agr = parseFloat(balance_agr) + parseFloat(all_data[i][24]);
                    total_rec_ins = parseFloat(total_rec_ins) + parseFloat(all_data[i][25]);
                    balance_ins = parseFloat(balance_ins) + parseFloat(all_data[i][26]);
                    total_rec_reg = parseFloat(total_rec_reg) + parseFloat(all_data[i][27]);
                    balance_reg = parseFloat(balance_reg) + parseFloat(all_data[i][28]);
                    total_balance = parseFloat(total_balance) + parseFloat(all_data[i][29]);
                    gss_amount = parseFloat(gss_amount) + parseFloat(all_data[i][30]);

}
                
                
                //tsv with comma
                var x=tsv.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOftsv = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOftsv =sumOftsv+'/-';
                //booking_amt with comma
                var x=booking_amt.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOfbooking_amt = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOfbooking_amt =sumOfbooking_amt+'/-';
                //total_rec_agr with comma
                var x=total_rec_agr.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOftotal_rec_agr = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOftotal_rec_agr =sumOftotal_rec_agr +'/-';
                //balance_agr with comma
                var x=balance_agr.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOfbalance_agr = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOfbalance_agr = sumOfbalance_agr+'/-'
                //total_rec_ins with comma
                var x=total_rec_ins.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOftotal_rec_ins = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOftotal_rec_ins = sumOftotal_rec_ins+'/-';
                //balance_ins with comma
                var x=balance_ins.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOfbalance_ins = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOfbalance_ins  = sumOfbalance_ins+'/-';
                //total_rec_reg with comma
                var x=total_rec_reg.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOftotal_rec_reg = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOftotal_rec_reg = sumOftotal_rec_reg+'/-';
                //balance_reg with comma
                var x=balance_reg.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOfbalance_reg = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOfbalance_reg = sumOfbalance_reg+'/-';
                //total_balance with comma
                var x=total_balance.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOftotal_balance = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOftotal_balance = sumOftotal_balance+'/-';
                //gss_amount with comma
                var x=gss_amount.toString();
                var lastThree = x.substring(x.length-3);
                var otherNumbers = x.substring(0,x.length-3);
                if(otherNumbers != '')
                lastThree = ',' + lastThree;
                var sumOfgss_amount = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                sumOfgss_amount  = sumOfgss_amount+'/-';
               // alert(gss_amount);
                $( api.column( 0 ).footer() ).html('');
                $( api.column( 1 ).footer() ).html('');
                $( api.column( 2 ).footer() ).html('');
                $( api.column( 3 ).footer() ).html('');
                $( api.column( 4 ).footer() ).html('Dim: '+dim.toFixed(2));               
                $( api.column( 5 ).footer() ).html('');
                $( api.column( 6 ).footer() ).html('');
                $( api.column( 7 ).footer() ).html('TSV:'+sumOftsv);
                $( api.column( 8 ).footer() ).html('');
                $( api.column( 9 ).footer() ).html('Tot Bkng Amt: '+sumOfbooking_amt);             
                $( api.column( 10 ).footer() ).html(''); 
                $( api.column( 11 ).footer() ).html('Tot Agr Recvd: '+sumOftotal_rec_agr).css("color", "green");
                $( api.column( 12 ).footer() ).html('Tot Agr Bal: '+sumOfbalance_agr).css("color", "red");
                $( api.column( 13 ).footer() ).html('');
                $( api.column( 14 ).footer() ).html('Tot Ins Recvd: '+sumOftotal_rec_ins).css("color", "green");             
                $( api.column( 15 ).footer() ).html('Tot Ins Bal: '+sumOfbalance_ins).css("color", "red");
                $( api.column( 16 ).footer() ).html('');
                $( api.column( 17 ).footer() ).html('Tot Reg Recvd: '+sumOftotal_rec_reg).css("color", "green");
                $( api.column( 18 ).footer() ).html('Tot Reg Bal: '+sumOfbalance_reg).css("color", "red");
                $( api.column( 19 ).footer() ).html('Tot Bal: '+sumOftotal_balance).css("color", "red");             
                $( api.column( 20 ).footer() ).html('GSS Amt: '+sumOfgss_amount); 
                $( api.column( 21 ).footer() ).html('');
                $( api.column( 22 ).footer() ).html('');
                $( api.column( 23 ).footer() ).html('');
                $( api.column( 24 ).footer() ).html('');
                $( api.column( 25 ).footer() ).html('');
                $( api.column( 26 ).footer() ).html('');
                $( api.column( 27 ).footer() ).html('');
                $( api.column( 28 ).footer() ).html('');
                $( api.column( 29 ).footer() ).html('');
                $( api.column( 30 ).footer() ).html('');

$('#dimension').html('Total Dim: '+dim.toFixed(2)); 
                $('#total_tsv').html('Total TSV : '+sumOftsv);
                $('#booking_amount').html('Total Bkng Amt : '+sumOfbooking_amt);
                $('#aggr_due_amount').html('Total Agr Due Amt : '+sumOftotal_rec_agr);
                $('#bal_aggr').html('Total Bal Agr : '+sumOfbalance_agr);
                $('#inst_due_amount').html('Total Inst Due Amt : '+sumOftotal_rec_ins);
                $('#bal_inst').html('Total Bal Inst : '+sumOfbalance_ins);
                $('#regn_due_amount').html('Total Regn Due Amt : '+sumOftotal_rec_reg);
                $('#bal_regn').html('Total Bal Regn : '+sumOfbalance_reg);
                $('#total_amount').html('Total  Amt : '+sumOftotal_balance);
                $('#total_gss_amount').html('Total GSS Amt : '+sumOfgss_amount);

});
        }
        catch (e) 
        {
            console.log('Error in CalculateTableSummary');
            console.log(e)
        }
    
        
    
        
    }
   
}

$('.payment_submit_export').click(function()
{
    
    $.ajax({
        type   : 'get',
        url    : '<?php echo site_url("get-status-reports-datewise-agree-done")?>',   
        data   : {},                                      
        success:function(response)
        {
            // response=jQuery.parseJSON(data);
            console.log(response);
               
                $('#example').show();

$('.export_payment_mode_table').hide();
                
                 $('.export_payment_table').empty();
                
                var count =1;
                var content = '';
                
                var booking_particulars='';
                
                content +='<tr>';
                content +='<td>SL No</td>';
                content +='<td>Project Name</td>';
                content +='<td>Booking Date</td>';
                content +='<td>Site No</td>';
                content +='<td>Dimension</td>';
                content +='<td>Name</td>';
                content +='<td>TSV</td>';
                content +='<td>Khata Status</td>';
                content +='<td>Booking Amount</td>';
                content +='<td>Agreement Due Date</td>';
                content +='<td>Agreement Due Amount</td>';
                content +='<td>Balance Agreement</td>';
                content +='<td>Installment Due Date</td>';
                content +='<td>Installment Due Amount</td>';
                content +='<td>Balance Installment</td>';
                content +='<td>Registration Due Date</td>';
                content +='<td>Registration Due Amount</td>';
                content +='<td>Balance Registration</td>';
                content +='<td>Total Balance</td>';
                content +='<td>GSS Amount</td>';
                content +='</tr>';
                
                var count = "1";
                var values_count = response.length;
                for (var i = 0, len = values_count; i < len; i++) 
                {
                    //tsv with comma
                    var x=response[i].tsv.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOftsv = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOftsv =sumOftsv +'/-';
                    //booking_amt with comma
                    var x=response[i].booking_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbooking_amt = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbooking_amt = sumOfbooking_amt+'/-';
                    
                    //balance_agr with comma
                    var x=response[i].balance_agreement_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbalance_agr = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbalance_agr = sumOfbalance_agr+'/-';
                   
                    //balance_ins with comma
                    var x=response[i].balance_installment.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbalance_ins = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbalance_ins = sumOfbalance_ins+'/-';
                   
                    //balance_reg with comma
                    var x=response[i].balance_registration.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbalance_reg = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbalance_reg = sumOfbalance_reg+'/-';
                    //total_balance with comma
                    var x=response[i].balance.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOftotal_balance = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOftotal_balance = sumOftotal_balance+'/-';
                    //gss_amount with comma
                    var x=response[i].gss_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfgss_amount = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfgss_amount = sumOfgss_amount+'/-';
                    content +='<tr>';
                    content +='<td rowspan="">'+count+'</td>';
                    content +='<td rowspan="">'+response[i].project_nick_name+'</td>';
                    content +='<td rowspan="">'+response[i].booking_date+'</td>';
                    content +='<td rowspan="">'+response[i].site_number+'</td>';
                    content +='<td rowspan="">'+response[i].dimension+'</td>';
                    content +='<td rowspan="">'+response[i].customer_name+'</td>';
                    content +='<td rowspan="">'+sumOftsv+'</td>';
                    content +='<td rowspan="">'+response[i].khata_status+'</td>';
                    content +='<td rowspan="">'+sumOfbooking_amt+'</td>';
                    content +='<td rowspan="">'+response[i].agreement_date_due_date+'</td>';
                    content +='<td rowspan="">'+response[i].agreement_amount_due_amount+'</td>';
                    content +='<td rowspan="">'+sumOfbalance_reg+'</td>';
                    content +='<td rowspan="">';
                    $.each( response[i].installment_details, function( key, values ) 
                    {
                        var id = key+1;
                        content +='Installment '+id+' :'+values.installment_date_due_date+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                    });
                    content +='</td>';
                    content +='<td rowspan="">';
                    $.each( response[i].installment_details, function( key, values ) 
                    {
                        var id = key+1;
                        content +='Installment '+id+' :'+values.installment_amount_due_amount+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                    });
                    content +='</td>';
                    content +='<td rowspan="">'+sumOfbalance_ins+'</td>';
                    
                    content +='<td rowspan="">';
                    $.each( response[i].registration_details, function( key, value ) 
                    {
                        var count = key+1;
                        if(value.registration_date_due_date != "")
                        {
                            content +='Registration '+ count +':'+value.registration_date_due_date+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                        }
                        else
                        {
                            content +='';
                        }
                    });
                    content +='</td>';
                    
                    content +='<td rowspan="">';
                    $.each( response[i].registration_details, function( key, value ) 
                    {
                        var count = key+1;
                        if(value.registration_amount_due_amount == 0)
                        {
                            content +='';
                        }
                        else
                        {
                            content +='Registration '+ count +':'+value.registration_amount_due_amount+'<hr style="height:2px;border-width:0;color:gray;background-color:gray;white-space: nowrap;">';
                        }
                    });
                    content +='</td>';
                    
                    content +='<td rowspan="">'+sumOfbalance_reg+'</td>';
                    content +='<td rowspan="">'+sumOftotal_balance+'</td>';
                    content +='<td rowspan="">'+sumOfgss_amount+'</td>';
                    content +='</tr>';
                    count++;
                }
                
                
                var dimension = $('#dimension').html();
                var total_tsv = $('#total_tsv').html();
                var booking_amount = $('#booking_amount').html();
                var aggr_due_amount = $('#aggr_due_amount').html();
                var bal_aggr = $('#bal_aggr').html();
                var inst_due_amount = $('#inst_due_amount').html();
                var bal_inst = $('#bal_inst').html();
                var regn_due_amount = $('#regn_due_amount').html();
                var bal_regn = $('#bal_regn').html();
                var total_amount = $('#total_amount').html();
                var total_gss_amount = $('#total_gss_amount').html();

content +='<tr>';
                content +='<td colspan="5" style="text-align:right;">'+dimension+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+total_tsv+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+booking_amount+'</td>';
                content +='<td colspan="" style="text-align:right;">'+aggr_due_amount+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+bal_aggr+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+inst_due_amount+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+bal_inst+'</td>';
                content +='<td colspan="" style="text-align:right;">'+regn_due_amount+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+bal_regn+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+total_amount+'</td>';
                content +='<td colspan="5" style="text-align:right;">'+total_gss_amount+'</td>';
                content +='</tr>';

$('.export_payment_table').append(content);
                payment_mode_export();
        }
    });
});

$('.print_payment_mode_table').hide();
                
                 $('.print_payment_table').empty();
                
                var count =1;
                var content = '';
                
                var booking_particulars='';
                
                content +='<tr>';
                content +='<td>SL No</td>';
                content +='<td>Project Name</td>';
                content +='<td>Booking Date</td>';
                content +='<td>Site No</td>';
                content +='<td>Dimension</td>';
                content +='<td>Name</td>';
                content +='<td>TSV</td>';
                content +='<td>Khata Status</td>';
                content +='<td>Booking Amount</td>';
                content +='<td>Agreement Due Date</td>';
                content +='<td>Agreement Due Amount</td>';
                content +='<td>Balance Agreement</td>';
                content +='<td>Installment Due Date</td>';
                content +='<td>Installment Due Amount</td>';
                content +='<td>Balance Installment</td>';
                content +='<td>Registration Due Date</td>';
                content +='<td>Registration Due Amount</td>';
                content +='<td>Balance Registration</td>';
                content +='<td>Total Balance</td>';
                content +='<td>GSS Amount</td>';
                content +='</tr>';
                
                var count = "1";
                var values_count = response.length;
                for (var i = 0, len = values_count; i < len; i++) 
                {
                    //tsv with comma
                    var x=response[i].tsv.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOftsv = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOftsv = sumOftsv+'/-';
                    //booking_amt with comma
                    var x=response[i].booking_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbooking_amt = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbooking_amt =sumOfbooking_amt+'/-';
                    
                    //balance_agr with comma
                    var x=response[i].balance_agreement_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbalance_agr = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbalance_agr = sumOfbalance_agr+'/-';
                   
                    //balance_ins with comma
                    var x=response[i].balance_installment.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbalance_ins = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbalance_ins = sumOfbalance_ins+'/-';
                   
                    //balance_reg with comma
                    var x=response[i].balance_registration.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfbalance_reg = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfbalance_reg = sumOfbalance_reg+'/-';
                    //total_balance with comma
                    var x=response[i].balance.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOftotal_balance = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOftotal_balance = sumOftotal_balance+'/-';
                    //gss_amount with comma
                    var x=response[i].gss_amount.toString();
                    var lastThree = x.substring(x.length-3);
                    var otherNumbers = x.substring(0,x.length-3);
                    if(otherNumbers != '')
                    lastThree = ',' + lastThree;
                    var sumOfgss_amount = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
                    sumOfgss_amount = sumOfgss_amount+'/-';
                    content +='<tr>';
                    content +='<td rowspan="">'+count+'</td>';
                    content +='<td rowspan="">'+response[i].project_nick_name+'</td>';
                    content +='<td rowspan="">'+response[i].booking_date+'</td>';
                    content +='<td rowspan="">'+response[i].site_number+'</td>';
                    content +='<td rowspan="">'+response[i].dimension+'</td>';
                    content +='<td rowspan="">'+response[i].customer_name+'</td>';
                    content +='<td rowspan="">'+sumOftsv+'</td>';
                    content +='<td rowspan="">'+response[i].khata_status+'</td>';
                    content +='<td rowspan="">'+sumOfbooking_amt+'</td>';
                    content +='<td rowspan="">'+response[i].agreement_date_due_date+'</td>';
                    content +='<td rowspan="">'+response[i].agreement_amount_due_amount+'</td>';
                    content +='<td rowspan="">'+sumOfbalance_reg+'</td>';
                    content +='<td rowspan="">';
                    $.each( response[i].installment_details, function( key, values ) 
                    {
                        var id = key+1;
                        content +='Installment '+id+' :'+values.installment_date_due_date+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                    });
                    content +='</td>';
                    content +='<td rowspan="">';
                    $.each( response[i].installment_details, function( key, values ) 
                    {
                        var id = key+1;
                        content +='Installment '+id+' :'+values.installment_amount_due_amount+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                    });
                    content +='</td>';
                    content +='<td rowspan="">'+sumOfbalance_ins+'</td>';
                    
                    content +='<td rowspan="">';
                    $.each( response[i].registration_details, function( key, value ) 
                    {
                        var count = key+1;
                        if(value.registration_date_due_date != "")
                        {
                            content +='Registration '+ count +':'+value.registration_date_due_date+'<hr style="height:2px;border-width:0;color:gray;background-color:gray">';
                        }
                        else
                        {
                            content +='';
                        }
                    });
                    content +='</td>';
                    
                    content +='<td rowspan="">';
                    $.each( response[i].registration_details, function( key, value ) 
                    {
                        var count = key+1;
                        if(value.registration_amount_due_amount == 0)
                        {
                            content +='';
                        }
                        else
                        {
                            content +='Registration '+ count +':'+value.registration_amount_due_amount+'<hr style="height:2px;border-width:0;color:gray;background-color:gray;white-space: nowrap;">';
                        }
                    });
                    content +='</td>';
                    
                    content +='<td rowspan="">'+sumOfbalance_reg+'</td>';
                    content +='<td rowspan="">'+sumOftotal_balance+'</td>';
                    content +='<td rowspan="">'+sumOfgss_amount+'</td>';
                    content +='</tr>';
                    count++;
                }
                
                
                var dimension = $('#dimension').html();
                var total_tsv = $('#total_tsv').html();
                var booking_amount = $('#booking_amount').html();
                var aggr_due_amount = $('#aggr_due_amount').html();
                var bal_aggr = $('#bal_aggr').html();
                var inst_due_amount = $('#inst_due_amount').html();
                var bal_inst = $('#bal_inst').html();
                var regn_due_amount = $('#regn_due_amount').html();
                var bal_regn = $('#bal_regn').html();
                var total_amount = $('#total_amount').html();
                var total_gss_amount = $('#total_gss_amount').html();
                
              
                content +='<tr>';
                content +='<td colspan="" style="text-align:right;"></td>';
                content +='<td colspan="" style="text-align:right;"></td>';
                content +='<td colspan="3" style="text-align:right;">'+dimension+'</td>';
                content +='<td colspan="2" style="text-align:right;">'+total_tsv+'</td>';
                content +='<td colspan="2" style="text-align:right;">'+booking_amount+'</td>';
                content +='<td colspan="2" style="text-align:right;">'+aggr_due_amount+'</td>';
                content +='<td colspan="1" style="text-align:right;">'+bal_aggr+'</td>';
                content +='<td colspan="2" style="text-align:right;">'+inst_due_amount+'</td>';
                content +='<td colspan="1" style="text-align:right;">'+bal_inst+'</td>';
                content +='<td colspan="2" style="text-align:right;">'+regn_due_amount+'</td>';
                content +='<td colspan="1" style="text-align:right;">'+bal_regn+'</td>';
                content +='<td colspan="1" style="text-align:right;">'+total_amount+'</td>';
                content +='<td colspan="1" style="text-align:right;">'+total_gss_amount+'</td>';
                content +='</tr>';

$('.print_payment_table').append(content);
                payment_mode_print();
        }
    });
});

</script>

.scroll 
{
    height:12px !important;
}
#gbox_list6_251_t
{
    height:auto !important;
}

#list6
{
    width: 1050px;
height: 0px !important;
}
#gbox_list6
{

height: auto !important;
}
#gview_list6
{

height: auto !important;
}

@media only screen and (min-width:320px) and (max-width:641px){
            .ui-jqgrid {
    margin-left: 1px !important;
}
            #jaytab{
                margin-top: 0 !important;
                margin-left: 0 !important;
                overflow-x: scroll;
                width: 100% !important;
                padding-left: 0 !important;
            }
            
            #editmodlist6
            {
                width:90% !important;
            }
            #sData span, #cData span {
                margin-left: 0 !important;
                }
        }
        @media only screen and (min-width:641px) and (max-width:991px){
            
            .ui-jqgrid {
            margin-left: 1px !important;
            }
            #jaytab{
                margin-top: 0 !important;
                margin-left: 0 !important;
                overflow-x: scroll;
                width: 100% !important;
                padding-left:0 !important;
                padding-right:9px !important;
            }

}
        
        @media only screen and (min-width:1601px) and (max-width:1920px){
            /*.ui-jqgrid-hdiv {
                width: 1610px !important;
            }
            .ui-jqgrid-bdiv, .ui-jqgrid-ftable {
                width: 1610px !important;
            }
            #list1, #list2, #list3, #list4, #list5, #list6, #list7, #list8, #list9, #list10, #list11, #list12, #list13 {
                width: 1610px !important;
            }*/
        }
#sData span, #cData span 
{
    margin-left: 3px;
}
#sData {
    height: 29px;
}
#cData {
    height: 29px;
}

.jqgfirstrow
    {
            height: 0px !important;
    }

.cancelled_on
{
    color : red;
}
.balance_sqft
{
    color : red;
}
.payment_balance
{
    color : red;
}
.agree_due_date
{
    color : red;
}
.reg_due_date
{
    color : red;
}

.reg_date
{
    color : green;
}
.payment_client_details td {
    border-bottom: 1px solid black;
    line-height:1.8;
    width: auto !important;
    border: 1px solid black;
}

.ui-jqgrid-bdiv{
    height: auto !important;
}
.ui-jqgrid .ui-jqgrid-caption {
    text-align: left;
    background: #AA0000;
    color: white;
    height: 30px;
}
#list13 td{
    font-size: 12px !important;
}
.ui-jqgrid-labels th{
    font-size: 13px !important;
}

table.dataTable tbody th, table.dataTable tbody td {
    padding: 8px 10px;
    font-size: 14px !important;
}

table.dataTable tfoot th, table.dataTable tfoot td {
    font-size : 13px !important;
}
#loader
{
    position: fixed;
    z-index: 9999999;
    left: 0px;
    top: 0px;
    width: 100%;
    height: 100%;
    background: url('../assets/images/ajax-loader.gif') 50% 50% no-repeat #f9f9f9;
}

</style>