EVOLUTION-NINJA

Edit File: cancellation_details.php

<?php echo view('includes/header');?>
<link href="<?php echo base_url('public/assets/admin_dashboard/css/jquery-ui.css');?>" rel="stylesheet">
<script src="<?php echo base_url('public/assets/js/jquery-ui.js');?>"></script>

<h1> Cancellation details</h1>

</section>

<section class="content">
        
        <?php  if(!empty($detailss)) {  ?>
        
        <div class="row land_owner_a">
            <div class="form-group col-sm-12 col-md-6">
                <label class="col-sm-5">Customer Name :</label>
                <?php echo $detailss['customer_name'];?>
            </div>  
            <div class="form-group col-sm-12 col-md-6">
                <label class="col-sm-5">Project :</label>
                <?php echo $detailss['project_name'];?>
            </div>
        </div> 
        <div class="row land_owner_a">                          
            <div class="form-group col-sm-12 col-md-6">
                <label class="col-sm-5">Site No :</label>
                <?php echo $detailss['site_number'];?>
            </div>
            <div class="form-group col-sm-12 col-md-6">
                <label class="col-sm-5">Dimension :</label>
                 <?php echo $detailss['total_in_sqft'];?> Sqft                          
            </div>
        </div> 
        <div class="row land_owner_a">
            <div class="form-group col-sm-12 col-md-6">
                <label class="col-sm-5">Allocated To :</label>
                <?php echo $detailss['reference'];?>
            </div>
            <div class="form-group col-sm-12 col-md-6">
                <label class="col-sm-5">Associate :</label>
                <?php echo $detailss['associate'];?>
            </div>                  
        </div>

<h3 class="bok-details"> Booking Details </h3>  
            <div class="color1">            
                <div class="row land_owner_a">
                    <div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-5">Booking Date1 :</label>                             
                                <?php if($detailss['booking_date1'] == "" || $detailss['booking_date1'] == "0000-00-00"){echo "";}else {echo date("d-m-Y", strtotime($detailss['booking_date1']));}?>
                            </div>
            
                    <div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-5">Booking Amount1 :</label>
                                <?php $detailss['booking_amount1'];
            
                                $num=$detailss['booking_amount1'];$explrestunits = "" ;
                                if(strlen($num)>3) {
                                    $lastthree = substr($num, strlen($num)-3, strlen($num));
                                    $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                                    $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                                    $expunit = str_split($restunits, 2);
                                    for($i=0; $i<sizeof($expunit); $i++) {
                                        // creates each of the 2's group and adds a comma to the end
                                        if($i==0) {
                                            $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                                        } else {
                                            $explrestunits .= $expunit[$i].",";
                                        }
                                    }
                                    $thecash = $explrestunits.$lastthree;
                                } else {
                                    $thecash = $num;
                                }    echo 'Rs. '.$thecash.'/-';
            
            
                                ?>
                            </div>      
                </div> 
                
                <div class="row land_owner_a">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Payment type :</label>      
                        <?php if($detailss['booking_payment_type']=='Online Payment'){echo "NEFT/RTGS";}else if($detailss['booking_payment_type']=='Paytm Payment'){echo "UPI / Direct Payment";}else if($detailss['booking_payment_type']=='UPI Payment'){echo "Credit / Debit Payment";}else {echo $detailss['booking_payment_type'];}?>                      
                    </div>
                     <div class="form-group col-sm-12 col-md-6">
                <label class="col-sm-5">Confirming Type :</label>       
                <?//php if($detailss['confirming_party1']==='confirming_party'){echo "Confirming Party";}else {echo $detailss['confirming_party1'];}?>                     
            </div>
                </div>
        
                <?php
                if($detailss['booking_payment_type'] == "Cheque")
                {
                ?>
        
                    <div class="row land_owner_a" id="check_div">
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Cheque No :</label>                             
                            <?php echo $detailss['check_no'];?>
                        </div>
        
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Cheque Date :</label>                               
                            <?php if($detailss['check_date'] == "" || $detailss['check_date'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['check_date']));}?>
                        </div>
        
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Bank Name :</label>                             
                            <?php echo $detailss['bank_name'];?>
                        </div>
                    </div> 
        
                <?php
                }
                ?>
        
                <?php
                if($detailss['booking_payment_type'] == "DD")
                {
                ?>
        
                    <div class="row land_owner_a" id="check_div">
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">DD No :</label>                             
                            <?php echo $detailss['dd_no'];?>
                        </div>
        
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">DD Date :</label>                               
                            <?php if($detailss['dd_date'] == "" || $detailss['dd_date'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['dd_date']));}?>
                        </div>
        
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Bank Name :</label>                             
                            <?php echo $detailss['dd_bank'];?>
                        </div>
                    </div> 
        
                <?php
                }
                ?>
        
                <?php
                if($detailss['booking_payment_type'] == "Online Payment")
                {
                ?>
        
                <div class="row land_owner_a" id="onlinepayment_div">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">UTR No :</label>                                
                        <?php echo $detailss['vtr_no'];?>
                    </div>
        
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">NEFT/RTGS Date :</label>                                
                        <?php if($detailss['online_date'] == "" || $detailss['online_date'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['online_date']));}?>
                    </div>
                </div> 
        
                <?php
                }
                ?>
                <?php
                if($detailss['booking_payment_type'] == "Paytm Payment")
                {
                ?>
        
                <div class="row land_owner_a" id="paytmpayment_div">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Ref No :</label>                                
                        <?php echo $detailss['paytm_ref_no'];?>
                    </div>
        
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Date :</label>                              
                        <?php if($detailss['paytm_online_date'] == "" || $detailss['paytm_online_date'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['paytm_online_date']));}?>
                    </div>
                </div> 
        
                <?php
                }
                ?>
                <?php
                if($detailss['booking_payment_type'] == "UPI Payment")
                {
                ?>
        
                <div class="row land_owner_a" id="upipayment_div">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Ref No :</label>                                
                        <?php echo $detailss['upi_ref_no'];?>
                    </div>
        
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Date :</label>                              
                        <?php if($detailss['upi_online_date'] == "" || $detailss['upi_online_date'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['upi_online_date']));}?>
                    </div>
                </div> 
        
                <?php
                }
                ?>

</div>
            <div class="color2">
                <div class="row land_owner_a">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Booking Date2 :</label>                             
                        <?php if($detailss['booking_date2'] == "" || $detailss['booking_date2'] == "0000-00-00"){echo "";}else {echo date("d-m-Y", strtotime($detailss['booking_date2']));}?>
                    </div>
    
                    <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Booking Amount2 :</label>
                    <?php $detailss['booking_amount2'];
    
                    $num=$detailss['booking_amount2'];$explrestunits = "" ;
                    if(strlen($num)>3) {
                        $lastthree = substr($num, strlen($num)-3, strlen($num));
                        $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                        $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                        $expunit = str_split($restunits, 2);
                        for($i=0; $i<sizeof($expunit); $i++) {
                            // creates each of the 2's group and adds a comma to the end
                            if($i==0) {
                                $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                            } else {
                                $explrestunits .= $expunit[$i].",";
                            }
                        }
                        $thecash = $explrestunits.$lastthree;
                    } else {
                        $thecash = $num;
                    }    echo 'Rs. '.$thecash.'/-';
    
    
                    ?>
                </div>      
                </div> 
                <div class="row land_owner_a">

<div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Payment type :</label>      
                        <?php 
$type = $detailss['booking_payment_type2'] ?? '';

if ($type == '0') {
    echo "";
} else if ($type == 'Online Payment') {
    echo "NEFT/RTGS";
} else if ($type == 'Paytm Payment') {
    echo "UPI / Direct Payment";
} else if ($type == 'UPI Payment') {
    echo "Credit / Debit Payment";
} else {
    echo $type;
}
?>

</div>
                      <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Confirming Type :</label>       
                        <?php 
$party = $detailss['confirming_party2'] ?? '';
echo ($party == 'confirming_party') ? 'Confirming Party' : $party;
?>
              
                    </div>

</div>

<?php
                if($detailss['booking_payment_type2'] ?? ''== "Cheque")
                {
                ?>
                    <div class="row land_owner_a" id="check_div">
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Cheque No :</label>                             
                            <?php echo $detailss['check_no2'];?>
                        </div>

<div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Cheque Date :</label>                               
                            <?php if($detailss['check_date2'] == "" || $detailss['check_date2'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['check_date2']));}?>
                        </div>

<?php
                if($detailss['booking_payment_type2']?? '' == "DD")
                {
                ?>

<?php
                }
                ?>

<?php
                if($detailss['booking_payment_type2'] ?? '' == "Online Payment")
                {
                ?>

<?php
                }
                ?>

<?php if($detailss['booking_payment_type2'] ?? ''== "Paytm Payment") { ?>
            
                    <div class="row land_owner_a" id="paytmpayment_div">
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Ref No :</label>                                
                            <?php echo $detailss['paytm_ref_no2'];?>
                        </div>
            
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Date :</label>                              
                            <?php if($detailss['paytm_online_date2'] == "" || $detailss['paytm_online_date2'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['paytm_online_date2']));}?>
                        </div>
                    </div> 
            
                <?php } ?>
                <?php
                if($detailss['booking_payment_type2'] ?? '' == "UPI Payment")
                {
                ?>
        
                <div class="row land_owner_a" id="upipayment_div">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Ref No :</label>                                
                        <?php echo $detailss['upi_ref_no2'];?>
                    </div>
        
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Date :</label>                              
                        <?php if($detailss['upi_online_date2'] == "" || $detailss['upi_online_date2'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($detailss['upi_online_date2']));}?>
                    </div>
                </div> 
        
                <?php
                }
                ?>

</div>
            
            
            
            <?php if(!empty($agreement)) { ?>
            <div class="color1">
                <?php  foreach($agreement as $payments) { ?>
                    <div class="row land_owner_a">
                        
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Agreement Date:</label>
                            <?php echo date("d-m-Y", strtotime($payments->agreement_date));?>
                        </div>
                        
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Agreement Amount :</label>
                            <?php $payments->agreement_amount;
        
                            $num=$payments->agreement_amount;$explrestunits = "" ;
                            if(strlen($num)>3) {
                                $lastthree = substr($num, strlen($num)-3, strlen($num));
                                $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                                $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                                $expunit = str_split($restunits, 2);
                                for($i=0; $i<sizeof($expunit); $i++) {
                                    // creates each of the 2's group and adds a comma to the end
                                    if($i==0) {
                                        $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                                    } else {
                                        $explrestunits .= $expunit[$i].",";
                                    }
                                }
                                $thecash = $explrestunits.$lastthree;
                            } else {
                                $thecash = $num;
                            }    echo 'Rs. '.$thecash.'/-';
                            ?>
                        </div>  
                     </div>
                    <div class="row land_owner_a">
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Mode:</label>
                            <?php
        
                            if($payments->agreement_payment_mode == "Online Payment")
                            {
                                echo 'NEFT / RTGS'.'<br/>';
                            }
                           else if($payments->agreement_payment_mode == "Paytm Payment")
                            {
                                echo 'UPI / Direct Payment'.'<br/>';
                            }
                          else if($payments->agreement_payment_mode == "UPI Payment")
                            {
                                echo 'Credit / Debit Payment'.'<br/>';
                            }
                            else
                            {
                                echo $payments->agreement_payment_mode.'<br/>';
                            }
        
                            if($payments->agreement_payment_mode == "Cash")
                            {
                                echo "";
                            }
                            else if($payments->agreement_payment_mode == "Cheque")
                            {
                                echo '<label class="col-sm-5">Cheque no.:</label>'.$payments->agreement_cheque_no.'<br/>';
                                echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payments->agreement_cheque_date)).'<br/>';
                                echo '<label class="col-sm-5">Bank:</label>'.$payments->agreement_bank.'<br/>';
                            }
                            else if($payments->agreement_payment_mode == "Online Payment")
                            {
                                echo '<label class="col-sm-5">UTR no.:</label>'.$payments->agreement_vtr_no.'<br/>';
                                if($payments->agreement_online_date == "" || $payments->agreement_online_date == "0000-00-00")
                                {
                                    echo '<label class="col-sm-5">NEFT / RTGS date:</label>';
                                }
                                else
                                {
                                    echo '<label class="col-sm-5">NEFT / RTGS date:</label>'.date("d-m-Y", strtotime($payments->agreement_online_date)).'<br/>';
                                }
                            }
                            else if($payments->agreement_payment_mode == "Paytm Payment")
                            {
                                echo '<label class="col-sm-5">Ref no.:</label>'.$payments->agreementpaytm_ref_no.'<br/>';
                                if($payments->agreementpaytm_online_date1 == "" || $payments->agreementpaytm_online_date1 == "0000-00-00")
                                {
                                    echo '<label class="col-sm-5"> Date:</label>';
                                }
                                else
                                {
                                    echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payments->agreementpaytm_online_date1)).'<br/>';
                                }
                            }
        
                            else if($payments->agreement_payment_mode == "UPI Payment")
                            {
                                echo '<label class="col-sm-5">Ref no.:</label>'.$payments->agreementupi_ref_no.'<br/>';
                                if($payments->agreementupi_online_date1 == "" || $payments->agreementupi_online_date1 == "0000-00-00")
                                {
                                    echo '<label class="col-sm-5">Date:</label>';
                                }
                                else
                                {
                                    echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payments->agreementupi_online_date1)).'<br/>';
                                }
                            }
        
        
                            else if($payments->agreement_payment_mode == "DD")
                            {
                                echo '<label class="col-sm-5">DD no.</label>'.$payments->agreement_dd_no.'<br/>';
                                echo '<label class="col-sm-5">Date</label>'.date("d-m-Y", strtotime($payments->agreement_dd_date)).'<br/>';
                                echo '<label class="col-sm-5">Bank</label>'.$payments->agreement_dd_bank.'<br/>';
                            }
        
                            ?>
                        </div>
                    </div>
                    <div class="row land_owner_a">
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Confirming Type :</label>       
                            <?php if($payments->agreement_confirming_type=='confirming_party'){echo "Confirming Party";}else {echo $payments->agreement_confirming_type;}?>                     
                        </div>
</div>
                <?php } ?>
            </div>
            <?php } ?>

<?php $i = 1; $h=1; foreach($payment as $key=>$payment) { if($payment->installment_amount1 != 0 || $payment->installment_payment_mode1 != 0) { ?>
            <div class="<?php if(empty($agreement)) { if($key % 2 != 0){ echo 'color2'; } else { echo 'color1';} } else { if($key % 2 == 0){ echo 'color2'; } else { echo 'color1';} } ?>">
                <div class="row land_owner_a">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Instalment<?php echo $h; ?> Date:</label>
                        <?php echo date("d-m-Y", strtotime($payment->installment1_date));?>
                    </div>
                    <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Instalment Amount<?php echo $h; ?>:</label>
                    <?php $payment->installment_amount1;
                     $num=$payment->installment_amount1;

$explrestunits = "" ;
                    if(strlen($num)>3) {
                        $lastthree = substr($num, strlen($num)-3, strlen($num));
                        $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                        $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                        $expunit = str_split($restunits, 2);
                        for($i=0; $i<sizeof($expunit); $i++) {
                            // creates each of the 2's group and adds a comma to the end
                            if($i==0) {
                                $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                            } else {
                                $explrestunits .= $expunit[$i].",";
                            }
                        }
                        $thecash = $explrestunits.$lastthree;
                    } else {
                        $thecash = $num;
                    }    echo 'Rs. '.$thecash.'/-';
                    ?>
                    </div>
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Mode:</label>
                        <?php

if($payment->installment_payment_mode1 == "Online Payment")
                            {
                                echo 'NEFT / RTGS'.'<br/>';
                            }
                            else if($payment->installment_payment_mode1 == "Paytm Payment")
                            {
                                echo 'UPI / Direct Payment'.'<br/>';
                            }
                            else if($payment->installment_payment_mode1 == "UPI Payment")
                            {
                                echo 'Credit / Debit Payment'.'<br/>';
                            }
                            
                            else
                            {
                                echo $payment->installment_payment_mode1.'<br/>';
                            }

if($payment->installment_payment_mode1 == "Online Payment")
                            {
                                
                                echo '<label class="col-sm-5">UTR no.:</label>'.$payment->install_vtr_no1.'<br/>';
                                if($payment->install_online_date1 == "" || $payment->install_online_date1 == "0000-00-00")
                                {
                                    echo '<label class="col-sm-5">NEFT / RTGS date:</label>';
                                }
                                else
                                {
                                    echo '<label class="col-sm-5">NEFT / RTGS date:</label>'.date("d-m-Y", strtotime($payment->install_online_date1)).'<br/>';
                                }
                            }
                            else if($payment->installment_payment_mode1 == "Cash")
                            {
                                echo "";
                            }
                            else if($payment->installment_payment_mode1 == "Cheque")
                            {
                                echo '<label class="col-sm-5">Cheque no.:</label>'.$payment->install_cheque_no1.'<br/>';
                                echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payment->install_cheque_date1)).'<br/>';
                                echo '<label class="col-sm-5">Bank:</label>'.$payment->install_bank1.'<br/>';
                            }
                            else if($payment->installment_payment_mode1 == "Paytm Payment")
                            {
                                echo '<label class="col-sm-5">Ref no.:</label>'.$payment->paytm_ref_no.'<br/>';
                                if($payment->paytm_online_date1 == "" || $payment->paytm_online_date1 == "0000-00-00")
                                {
                                    echo '<label class="col-sm-5"> Date:</label>';
                                }
                                else
                                {
                                    echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payment->paytm_online_date1)).'<br/>';
                                }
                            }
                            else if($payment->installment_payment_mode1 == "UPI Payment")
                            {
                                echo '<label class="col-sm-5">Ref no.:</label>'.$payment->upi_ref_no.'<br/>';
                                if($payment->upi_online_date1 == "" || $payment->upi_online_date1 == "0000-00-00")
                                {
                                    echo '<label class="col-sm-5">Date:</label>';
                                }
                                else
                                {
                                    echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payment->upi_online_date1)).'<br/>';
                                }
                            }
                            else if($payment->installment_payment_mode1 == "DD")
                            {
                                echo '<label class="col-sm-5">DD no.</label>'.$payment->install_dd_no1.'<br/>';
                                echo '<label class="col-sm-5">Date</label>'.date("d-m-Y", strtotime($payment->install_dd_date1)).'<br/>';
                                echo '<label class="col-sm-5">Bank</label>'.$payment->install_dd_bank1.'<br/>';
                            }
                            else
                            {
                                echo $payment->installment_payment_mode1.'<br/>';
                            }
                        ?>  
                    </div>
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Confirming Type :</label>       
                        <?php if($payment->installment_confirming_type =='confirming_party'){echo "Confirming Party";} else {echo $payment->installment_confirming_type;}?>                     
                </div>
                </div>
            </div>
            <?php } if($payment->installment_amount2 != 0 || $payment->installment_payment_mode2 != 0) { ?>
            <div class="<?php if(empty($agreement)) { if($key % 2 != 0){ echo 'color2'; } else { echo 'color1';} } else { if($key % 2 == 0){ echo 'color2'; } else { echo 'color1';} } ?>">
                <div class="row land_owner_a">
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Instalment<?php echo $h; ?> Date:</label>
                        <?php echo date("d-m-Y", strtotime($payment->installment2_date));?>
                    </div>
                    
                    <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Instalment Amount2:</label>
                        <?php $payment->installment_amount2;

$num=$payment->installment_amount2;$explrestunits = "" ;
                        if(strlen($num)>3) {
                            $lastthree = substr($num, strlen($num)-3, strlen($num));
                            $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                            $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                            $expunit = str_split($restunits, 2);
                            for($i=0; $i<sizeof($expunit); $i++) {
                                // creates each of the 2's group and adds a comma to the end
                                if($i==0) {
                                    $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                                } else {
                                    $explrestunits .= $expunit[$i].",";
                                }
                            }
                            $thecash = $explrestunits.$lastthree;
                        } else {
                            $thecash = $num;
                        }    echo 'Rs. '.$thecash.'/-';

?>
                    </div>

<div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Mode:</label>
                        <?php

if($payment->installment_payment_mode2 == "Online Payment")
                        {
                            echo 'NEFT / RTGS'.'<br/>';
                        }
                        else if($payment->installment_payment_mode2 == "Paytm Payment")
                        {
                            echo 'UPI / Direct Payment'.'<br/>';
                        }
                        else if($payment->installment_payment_mode2 == "UPI Payment")
                        {
                            echo 'Credit / Debit Payment'.'<br/>';
                        }
                        else 
                        {
                            $payment->installment_payment_mode2.'<br>';
                        }
                        if($payment->installment_payment_mode2 == "Online Payment")
                        {
                            echo '<label class="col-sm-5">UTR no.:</label>'.$payment->install_vtr_no2.'<br/>';
                            if($payment->install_online_date2 == "" || $payment->install_online_date2 == "0000-00-00")
                            {
                                echo '<label class="col-sm-5">NEFT / RTGS date:</label>';
                            }
                            else
                            {
                                echo '<label class="col-sm-5">NEFT / RTGS date:</label>'.date("d-m-Y", strtotime($payment->install_online_date2)).'<br/>';
                            }
                        }

else if($payment->installment_payment_mode2 == "Cash")
                        {
                            echo "";
                        }
                        else if($payment->installment_payment_mode2 == "Cheque")
                        {
                            echo '<label class="col-sm-5">Cheque no.:</label>'.$payment->install_cheque_no2.'<br/>';
                            echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payment->install_cheque_date2)).'<br/>';
                            echo '<label class="col-sm-5">Bank:</label>'.$payment->install_bank2.'<br/>';
                        }
                        else if($payment->installment_payment_mode2 == "Paytm Payment")
                        {
                            echo '<label class="col-sm-5">Ref no.:</label>'.$payment->paytm_ref_no2.'<br/>';
                            if($payment->paytm_online_date2 == "" || $payment->paytm_online_date2 == "0000-00-00")
                            {
                                echo '<label class="col-sm-5"> Date:</label>';
                            }
                            else
                            {
                                echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($payment->paytm_online_date2)).'<br/>';
                            }
                        }

else if($payment->installment_payment_mode2 == "DD")
                        {
                            echo '<label class="col-sm-5">DD no.</label>'.$payment->install_dd_no2.'<br/>';
                            echo '<label class="col-sm-5">Date</label>'.date("d-m-Y", strtotime($payment->install_dd_date2)).'<br/>';
                            echo '<label class="col-sm-5">Bank</label>'.$payment->install_dd_bank2.'<br/>';
                        }
                        else
                        {
                            echo $payment->installment_payment_mode2.'<br/>';
                        }
                        ?>
                    </div>
                    
                    <div class="row land_owner_a">
                        <div class="form-group col-sm-12 col-md-6">
                        <label class="col-sm-5">Confirming Type :</label>       
                        <?php if($payment->installment_confirming_type=='confirming_party'){echo "Confirming Party";}else {echo $payment->installment_confirming_type;}?>                       
                        </div>
                    </div>
                </div>
            </div>
            <?php } $h++; } ?>

<?php if(!empty($total_amount)) {$installment_amount11=0;$installment_amount12=0; 
                foreach($total_amount as $total){  $booking_amount  = $total->booking_amount1+$total->booking_amount2;
                 $agreement_amount  = (int)$total->agreement_amount;
                  $installment_amount11 += (int)$total->installment_amount1;
                  $installment_amount12  += (int)$total->installment_amount2;
                  $total_res  = $booking_amount+$agreement_amount+$installment_amount11+$installment_amount12;  } 
                $num=$total_res;$explrestunits = "" ;
                if(strlen($num)>3) {
                    $lastthree = substr($num, strlen($num)-3, strlen($num));
                    $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                    $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                    $expunit = str_split($restunits, 2);
                    for($i=0; $i<sizeof($expunit); $i++) {
                        // creates each of the 2's group and adds a comma to the end
                        if($i==0) {
                            $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                        } else {
                            $explrestunits .= $expunit[$i].",";
                        }
                    }
                    $thecash = $explrestunits.$lastthree;
                } else {
                    $thecash = $num;
                } ?>
                <h4 class="total_paid1" style="background: green;color: white; display: inline-block; padding: 5px 10px 9px;">Total Paid:  <span style="color: white;"><?php echo 'Rs. '. $thecash. '/-'; ?></span></h4> 
                <?php } else{ } ?>
                
                            
                        
            <div class="row land_owner_a">
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Refunded ?</label>                              
                    <?php if($detailss['refunded'] == "Yes"){echo "Yes";}else {echo "No";}?>
                </div>
        
            </div> 
                
        <?php if($detailss['refunded'] == 'Yes') { $g=1; if(!empty($detailss['mul_refunds'])) { foreach($detailss['mul_refunds'] as $details){ ?>
        
            <div class="row land_owner_a">
                
                
               <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Refund Date <?php echo $g;?> :</label>                              
                    <?php if($details->refunded_date == "" || $details->refunded_date == "0000-00-00"){echo "";}else {echo date("d-m-Y", strtotime($details->refunded_date));} ?>
                </div>
                
                <div class="col-sm-12 col-md-6">
                    <label class="col-sm-5">Refunded Amount <?php echo $g;?> :</label>
                    
                    <?php $details->refunded_amount;
        
                        $num=$details->refunded_amount;$explrestunits = "" ;
                        if(strlen($num)>3) {
                            $lastthree = substr($num, strlen($num)-3, strlen($num));
                            $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                            $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                            $expunit = str_split($restunits, 2);
                            for($i=0; $i<sizeof($expunit); $i++) {
                                // creates each of the 2's group and adds a comma to the end
                                if($i==0) {
                                    $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                                } else {
                                    $explrestunits .= $expunit[$i].",";
                                }
                            }
                            $thecash = $explrestunits.$lastthree;
                        } else {
                            $thecash = $num;
                        }    echo 'Rs. '.$thecash.'/-';
        
                        ?>
                </div>
                
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Mode:</label>
                    <?php
    
                    if($details->refunded_payment_mode == "Online Payment")
                    {
                        echo 'NEFT / RTGS'.'<br/>';
                    }
                    else
                    {
                        echo $details->refunded_payment_mode.'<br/>';
                    }
    
                    if($details->refunded_payment_mode == "Cash")
                    {
                        echo "";
                    }
                    else if($details->refunded_payment_mode == "Cheque")
                    {
                        echo '<label class="col-sm-5">Cheque no.:</label>'.$details->cheque_no.'<br/>';
                        echo '<label class="col-sm-5">Date:</label>'.date("d-m-Y", strtotime($details->cheque_date)).'<br/>';
                        echo '<label class="col-sm-5">Bank:</label>'.$details->bank_name.'<br/>';
                    }
                    else if($details->refunded_payment_mode == "Online Payment")
                    {
                        echo '<label class="col-sm-5">UTR no.:</label>'.$details->vtr_no.'<br/>';
                        if($details->online_date == "" || $details->online_date == "0000-00-00")
                        {
                            echo '<label class="col-sm-5">NEFT / RTGS date:</label>';
                        }
                        else
                        {
                            echo '<label class="col-sm-5">NEFT / RTGS date:</label>'.date("d-m-Y", strtotime($details->online_date)).'<br/>';
                        }
                    }
                    
                    ?>
                </div>
                
                
            </div>  
            
        
            <div class="row land_owner_a">
            
                <div class="col-sm-12 col-md-6">
                    <label class="col-sm-5">Due Amount <?php echo $g;?> :</label>
                    
                    <?php $details->due_amount;
        
                        $num=$details->due_amount;$explrestunits = "" ;
                        if(strlen($num)>3) {
                            $lastthree = substr($num, strlen($num)-3, strlen($num));
                            $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                            $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                            $expunit = str_split($restunits, 2);
                            for($i=0; $i<sizeof($expunit); $i++) {
                                // creates each of the 2's group and adds a comma to the end
                                if($i==0) {
                                    $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                                } else {
                                    $explrestunits .= $expunit[$i].",";
                                }
                            }
                            $thecash = $explrestunits.$lastthree;
                        } else {
                            $thecash = $num;
                        }    echo 'Rs. '.$thecash.'/-';
        
                        ?>
                </div>
                
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Due With <?php echo $g;?> :</label>                             
                    <?php echo $details->due_with;?>
                </div>
  
            </div>  
            
                <hr style=" border: 1px solid black;">
            <?php $g++; } ?>
            <div class="row land_owner_a">
                            <div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-4 col-md-4">Refund Request Letter</label><br/><br/>
                                <?php $ext = pathinfo($detailss['refunded_request_letter'], PATHINFO_EXTENSION);
                                    if($ext == 'JPG' || $ext == 'jpg' || $ext == 'JPEG' || $ext == 'jpeg' || $ext == 'png' || $ext == 'PNG')
                                    {
                                    ?>
                                        <img style="height:400px;width:300px;"src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['refunded_request_letter'];?>"/>
                                    <?php
                                    }
                                    else if($ext == 'pdf')
                                    {
                                    ?>
                                        <embed src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['refunded_request_letter'];?>" style="height:500px;width:400px;"/>
                                    <?php
                                    }
                                ?>
                            </div>
                            
                            <div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-4 col-md-4">Cancellation Agreement</label><br/><br/>
                                <?php $ext = pathinfo($detailss['cancellation_agreement_image'], PATHINFO_EXTENSION);
                                    if($ext == 'JPG' || $ext == 'jpg' || $ext == 'JPEG' || $ext == 'jpeg' || $ext == 'png' || $ext == 'PNG')
                                    {
                                    ?>
                                        <img style="height:400px;width:300px;"src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['cancellation_agreement_image'];?>"/>
                                    <?php
                                    }
                                    else if($ext == 'pdf')
                                    {
                                    ?>
                                        <embed src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['cancellation_agreement_image'];?>" style="height:500px;width:400px;"/>
                                    <?php
                                    }
                                ?>
                            </div>                          
                        </div> 
        
        <?php  } else { ?>
        
         <div class="row land_owner_a">
             
             <div class="form-group col-sm-12 col-md-6"  style="background-color:#A7EEEE;">
                    <label class="col-sm-5">Total:</label>
                    <?php echo $detailss['total'];?>
    
                    
                </div>
                
                
               <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Refund Date :</label>                               
                    <?php if($detailss['refunded_date'] == "" || $detailss['refunded_date'] == "0000-00-00"){echo "";}else {echo date("d-m-Y", strtotime($detailss['refunded_date']));} ?>
                </div>
                
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Refunded Amount :</label>
                    
                    <?php $detailss['refunded_amount'];
        
                        $num=$detailss['refunded_amount'];$explrestunits = "" ;
                        if(strlen($num)>3) {
                            $lastthree = substr($num, strlen($num)-3, strlen($num));
                            $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                            $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                            $expunit = str_split($restunits, 2);
                            for($i=0; $i<sizeof($expunit); $i++) {
                                // creates each of the 2's group and adds a comma to the end
                                if($i==0) {
                                    $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                                } else {
                                    $explrestunits .= $expunit[$i].",";
                                }
                            }
                            $thecash = $explrestunits.$lastthree;
                        } else {
                            $thecash = $num;
                        }    echo 'Rs. '.$thecash.'/-';
        
                        ?>
                </div>
                
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Note:</label>
                    <?php echo $detailss['note'];?>
    
                    
                </div>
                
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Due Amount:</label>
                    <?php echo $detailss['due_amount'];?>
    
                    
                </div>
                
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Due With:</label>
                    <?php echo $detailss['due_with'];?>
    
                    
                </div>
                
                
                
            </div>
            
            <div class="row land_owner_a">
                            <div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-4 col-md-4">Refund Request Letter</label><br/><br/>
                                <?php $ext = pathinfo($detailss['refunded_request_letter'], PATHINFO_EXTENSION);
                                    if($ext == 'JPG' || $ext == 'jpg' || $ext == 'JPEG' || $ext == 'jpeg' || $ext == 'png' || $ext == 'PNG')
                                    {
                                    ?>
                                        <img style="height:400px;width:300px;"src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['refunded_request_letter'];?>"/>
                                    <?php
                                    }
                                    else if($ext == 'pdf')
                                    {
                                    ?>
                                        <embed src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['refunded_request_letter'];?>" style="height:500px;width:400px;"/>
                                    <?php
                                    }
                                ?>
                            </div>
                            
                            <div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-4 col-md-4">Cancellation Agreement</label><br/><br/>
                                <?php $ext = pathinfo($detailss['cancellation_agreement_image'], PATHINFO_EXTENSION);
                                    if($ext == 'JPG' || $ext == 'jpg' || $ext == 'JPEG' || $ext == 'jpeg' || $ext == 'png' || $ext == 'PNG')
                                    {
                                    ?>
                                        <img style="height:400px;width:300px;"src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['cancellation_agreement_image'];?>"/>
                                    <?php
                                    }
                                    else if($ext == 'pdf')
                                    {
                                    ?>
                                        <embed src="<?php echo base_url('public/cancellation_uploads');?>/<?php echo $detailss['cancellation_agreement_image'];?>" style="height:500px;width:400px;"/>
                                    <?php
                                    }
                                ?>
                            </div>                          
                        </div> 
        
        <?php } } } else { if(!empty($details)) {  ?>
            <div class="row land_owner_a">
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Customer Name :</label>
                    <?php echo $details['customer_name'];?>
                </div>  
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Project :</label>
                    <?php echo $details['project_name'];?>
                </div>
            </div> 
            <div class="row land_owner_a">                          
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Site No :</label>
                    <?php echo $details['site_number'];?>
                </div>
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Dimension :</label>
                     <?php echo $details['total_in_sqft'];?> Sqft                           
                </div>
            </div> 
            <div class="row land_owner_a">
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Allocated To :</label>
                    <?php echo $details['reference'];?>
                </div>
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Associate :</label>
                    <?php echo $details['associate'];?>
                </div>                  
            </div>

<h3 class="bok-details"> Booking Details </h3>  
                        
            <div class="color1">    
            <div class="row land_owner_a">
                <div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Booking Date1 :</label>                             
                    <?php if($details['booking_date1'] == "" || $details['booking_date1'] == "0000-00-00"){echo "";}else {echo date("d-m-Y", strtotime($details['booking_date1']));}?>
                </div>

<div class="form-group col-sm-12 col-md-6">
                    <label class="col-sm-5">Booking Amount1 :</label>
                    <?php $details['booking_amount1'];

$num=$details['booking_amount1'];$explrestunits = "" ;
                    if(strlen($num)>3) {
                        $lastthree = substr($num, strlen($num)-3, strlen($num));
                        $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
                        $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
                        $expunit = str_split($restunits, 2);
                        for($i=0; $i<sizeof($expunit); $i++) {
                            // creates each of the 2's group and adds a comma to the end
                            if($i==0) {
                                $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
                            } else {
                                $explrestunits .= $expunit[$i].",";
                            }
                        }
                        $thecash = $explrestunits.$lastthree;
                    } else {
                        $thecash = $num;
                    }    echo 'Rs. '.$thecash.'/-';

?>
                </div>      
            </div> 
                <div class="row land_owner_a">
                        <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Payment type :</label>      
                            <?php if($details['booking_payment_type']=='Online Payment'){echo "NEFT/RTGS";}else if($details['booking_payment_type']=='Paytm Payment'){echo "UPI / Direct Payment";}else if($details['booking_payment_type']=='UPI Payment'){echo "Credit / Debit payment";}else {echo $details['booking_payment_type'];}?>                      
                        </div>
                         <div class="form-group col-sm-12 col-md-6">
                            <label class="col-sm-5">Confirming Type :</label>       
                            <?php if($details['confirming_party1']=='confirming_party'){echo "Confirming Party";}else {echo $details['confirming_party1'];}?>                       
                        </div>
                    </div>
                    
                    <?php
                    if($details['booking_payment_type'] == "Cheque")
                    {
                    ?>

<div class="row land_owner_a" id="check_div">
                            <div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-5">Cheque No :</label>                             
                                <?php echo $details['check_no'];?>
                            </div>

<div class="form-group col-sm-12 col-md-6">
                                <label class="col-sm-5">Cheque Date :</label>                               
                                <?php if($details['check_date'] == "" || $details['check_date'] == "0000-00-00"){echo "";} else {echo date("d-m-Y", strtotime($details['check_date']));}?>
                            </div>