Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/rrassociatevaluer.com/public_html/appltest/dashboard.7058/entries/pdf

Free Space:

3.96 TB

🔧 Quick Actions

✏️ Editing: BANK4_pdf.php

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <title><?=$uniqueId?></title>
    <?php 
// error_reporting(E_ALL);
// ini_set('display_errors', 1);

function getValue($table, $uniqueId)
	{
		$conn = new mysqli(SERVERNAME, USERNAME, PASSWORD, DATABASE);

if ($conn->connect_error) 
		{
		  die("Connection failed: " . $conn->connect_error);
		}
	    $select_query = "SELECT name FROM `$table` where deleted_at IS NULL and uniqueId  = '$uniqueId'";

$result = mysqli_query($conn,$select_query);
	    if ($result && mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_assoc($result);
	// print_r($row);
       
        return $row['name'];  // Return the value if found
    } else {
        return null; 
    }
	}
	function getValueaddress($table, $uniqueId)
	{
		$conn = new mysqli(SERVERNAME, USERNAME, PASSWORD, DATABASE);
	
		if ($conn->connect_error) {
			die("Connection failed: " . $conn->connect_error);
		}
	
		// Select multiple fields
		$select_query = "SELECT * FROM `$table` WHERE deleted_at IS NULL AND uniqueId = '$uniqueId'";
	
		$result = mysqli_query($conn, $select_query);
		if ($result && mysqli_num_rows($result) > 0) {
			return mysqli_fetch_assoc($result); 
		} else {
			return null; 
		}
	}
	function formatRupees($number) {
		$number = floatval($number);
	
		$decimal = number_format($number - floor($number), 2, '.', '');
		$number = floor($number);
	
		$numStr = (string)$number;
		$len = strlen($numStr);
	
		if ($len > 3) {
			$lastThree = substr($numStr, -3);
			$restUnits = substr($numStr, 0, $len - 3);
			$restUnits = preg_replace("/\B(?=(\d{2})+(?!\d))/", ",", $restUnits);
			$formattedNumber = $restUnits . "," . $lastThree;
		} else {
			$formattedNumber = $numStr;
		}
	
		return $formattedNumber . substr($decimal, 1);
	}
	
function roundToNearestThousand($value) {
    // Convert to float and round to nearest 1000
    return round(floatval($value), -3);
}

// echo "<pre>";
// print_r($details); 
// echo "<pre>"; print_r($details->order);
// print_r($row); ?>

/* body {
    font-family: 'MyCustomFont', sans-serif;
} */

/* @font-face {
    font-family: 'CustomFont'; 
    src: url('http://192.168.1.11/rr/assets/fonts/HoneySecrets-d9p6X.ttf') format('truetype'); 
    font-style: normal;
} */
    /*  
@font-face {font-family: 'Stagera'; 
	src: url('../../../assets/fonts/Stagera.ttf') format('opentype'); 
	font-weight: normal; font-style: normal;} */
    /* body {font-family: 'Stagera';} */
    /* body { margin: 5px; font-family: 'Stagera', sans-serif;} */
    /* h1 {font-family: 'Stagera', sans-serif;}
	p {font-family: 'Stagera', sans-serif;} */
    /* body { margin: 5px; font-weight:600; font-family: 'AlexBrush', sans-serif;} */

@page {
        margin-left: 20px;
        margin-right: 30px;
    }

body {
        font-weight: 600;
        font-family: "Dejavu Sans";
    }

.table_box {
        border: 1px solid rgb(231, 225, 225);
        border-collapse: collapse;
    }

.table_box td,
    .table_box th {
        border: 1px solid rgb(224, 222, 222);
        border-top: 1px solid rgb(224, 222, 222);
    }

.table_box_line td {
        border-left: none;
        border-right: none;
    }

.table_box td {
        padding: 5px;
    }

table td {
        padding: 0px;
    }

html {
        font-family: 'Dejavu Sans';
        font-size: 13px;
        line-height: 13px;
    }

.title {
        font-family: 'Dejavu Sans';
        font-size: 12px;
        color: #f50808;
        font-weight: bold;
    }

html {
        font-size: 13px;
        line-height: 13px;
    }

.title {
        font-size: 12px;
        color: rgb(200, 196, 196);
        font-weight: bold;
    }

.sub_tital {
        font-size: 13px;
        color: #3440cb;
        font-weight: 500;
        font-family: 'Dejavu Sans';
    }

.name {
        color: #f50808;
        font-weight: 600;
    }

/* #container {margin: 10px;} */
    .test {
        border-bottom: 4px double #333;
        padding: 10px 0;
    }

table {
        width: 100%;
    }

.main_title {
        font-size: 14px;
        font-weight: 500;
    }

.sub_to {
        margin-left: 0px;
        font-weight: 400;
        font-family: 'Dejavu Sans';
    }

.sub_to_tit {
        font-family: 'Dejavu Sans';
    }

.ml-35 {
        margin-left: 35px;
    }

.sub_tit {
        font-size: 16px;
        color: #000;
        font-weight: 600;
        margin-bottom: 1px;
        font-family: 'Dejavu Sans';
    }

td div {
        margin: 5px 0px 5px 0px !important
    }

.subtable table,
    .subtable th,
    .subtable td {
        border: 1px solid rgb(214, 211, 211);
        border-collapse: collapse;
        padding: 5px;
    }

.subtable table,
    .tab {
        width: 100%;
    }

.img {
        width: 90%;
        height: 90%;
        object-fit: contain;
        border: 2px solid black;
    }

.boundtable td {
        padding: 2px;
    }

.txt-center {
        text-align: center;
    }
    </style>
</head>

<body>

<table>
            <tr>
                <td>
                    <p style="font-size: 13px;color: #f50808;margin-bottom:1px;font-weight:700;">Er.S.SENTHIL VELAVAN.
                        B.E., MIE.AIV. M.Sc (Val)</p><br>
                    <p style="color: #003366;font-size:13px;font-weight:bold;margin-bottom:1px;margin-top:1px;">
                        CHARTERED ENGINEER & REGISTERED VALUER</p><br>
                    <p style="color: #f50808;font-size:20px;margin-bottom:1px;margin-top:1px;font-weight:bold;">RR
                        Associate</p>
                </td>
                <td align="right" style="color: #080cb8;font-size:12px;" class="sub_to">
                    95, SRI ADHITY SHOPPING PLAZA,<br />
                    (2nd Floor),<br />
                    NEAR St.MARRY'S HOSPITAL,<br />
                    ARISIPALAYAM MAIN ROAD,<br />
                    SALEM - 636009.<br />
                    CELL NO : 9994019700, 9080380040<br />
                </td>
            </tr>
        </table>
        <div class="test"></div>
        <br>

<table class="table">
            <tr>
                <td colspan="3" align="center">
                    <b style="font-size: 15px;color:#000;">STANDARD VALUATION REPORT</b>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    <div class="sub_to">Ref.No: <?=$details->ref_no?></div>
                </td>
                <td width="33%">
                    <p style="margin-left: 25px;" align="right" class="sub_to">Date :
                        <?=date("d.m.Y", strtotime($row['date']));?></p>
                </td>
            </tr>
            <tr>
                <?php 
				 $bankDetails = getValueaddress('address', HDFC);
				 ?>
                <td width="34%">
                    <div class="sub_to">To:<br />
                        <?php 
            if (is_array($bankDetails)) {
				echo $bankDetails['bank_name'] . '<br>';
				echo $bankDetails['name'] . '<br>';
				echo $bankDetails['branch_name'];
			} else {
				echo "No valid bank data returned.";
			}
        ?>
                    </div>
                </td>
                <td width="33%" colspan="2">
                    <div class="sub"></div>
                </td>
                
            </tr>
            <tr>
                <td colspan="3">
                    <div class="sub_to"><b>A. GENERAL DETAILS</b></div>
                </td>
            </tr>
        </table>

<table class="table_box">
            <tr>
                <td width="50%" align="left">
                    <div class="sub_to"><b>Type Of Property</b></div>
                </td>
                <td width="50%" align="left">
                    <div class="sub_to"><?= getValue('nature_of_the_properties',$details->nature_of_the_property);?>
                    </div>
                    <?php
$property = $row['nature_of_the_property'];
// echo $property."property";die();
				?>

</td>
            </tr>
            <tr>
                <td width="50%" align="left">
                    <div class="sub_to">1 Name of the Customer</div>
                </td>
                <td width="50%" align="left">
                    <div class="sub_to"><?=$details->name_of_the_borrower?></div>

</td>
            </tr>
            <tr>
                <td width="50%" align="left">
                    <div class="sub_to">2 Property Address with Pincode</div>
                </td>
                <td width="50%" align="left">
                    <div class="sub_to"><?=$details->postal_address?> - <?=$details->pincode??'';?>.</div>

</td>
            </tr>
            <tr>
                <td width="50%" align="left">
                    <div class="sub_to">3 Land Mark</div>
                </td>
                <td width="50%" align="left">
                    <div class="sub_to"><?= !empty($details->nearest_landmark) ? $details->nearest_landmark :'-';?>
                    </div>

</td>
            </tr>
            <tr>
                <td width="50%" align="left">
                    <div class="sub_to">4 Loan Application Number</div>
                </td>
                <td width="50%" align="left">
                    <div class="sub_to"><?=$details->loan_application_number??'';?></div>

</td>
            </tr>
            <tr>
                <td width="50%" align="left">
                    <div class="sub_to">5 Name of Document Holder</div>
                </td>
                <td width="50%" align="left">
                    <div class="sub_to"><?=$details->name_of_the_owner_and_details?></div>

</td>
            </tr>

<tr>
                <td width="50%" align="left">
                    <div class="sub_to	">List of Documents to Perusal </div>
                </td>
                <td width="50%" align="left">
                    <div class="sub_to"><?=$details->list_of_documents?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">6 Legal Address of Property : <br> (Hissa No/ Svy No / Khasara No)</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to">
                        <?=$details->door_no_street.','.$details->plot_no_survey_no.','.$details->ts_no_village.',<br>'.$details->ward_taluka.','.$details->ward_no_municpal_land.','.$details->mandal_district?>.
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">7 Date of Inspection</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=date("d.m.Y", strtotime($details->date_of_inspection));?></div>
                </td>
            </tr>
            
        </table>

<table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>B. SURROUNDING LOCALITY DETAILS</b></div>
                </td>
            </tr>
        </table>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">1 Ward No / Municipal Land No</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->ward_no_municpal_land??'';?></div>
                </td>
            </tr>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">2 Vicinity</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= getValue('vicinity',$details->vicinity)??'';?></div>
                </td>
            </tr>
            <?php 
        if($property == RESIDENTIAL || $property == AGRI_LAND || $property == VACANT_LAND || $property == AGRI_LAND_AND_BUILDING){
		?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">3 Locality Type</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= $details->residential_area?? '';?></div>
                </td>
            </tr>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">4 Approach Road Width</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= getValue('width-of-road',$details->width_of_road??'');?></div>
                </td>
            </tr>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">5 Plot Demarcated at Site</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->plot_demarcated_at_site??'';?></div>
                </td>
            </tr>
            <?php 
		}
		 if ($property == RESI_CUM_COMMERCIAL) {?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">3 Property Location</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->property_location??'';?></div>
                </td>
            </tr>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">4 Plot demarcated at Site</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->plot_demarcated_at_site??'';?></div>
                </td>
            </tr>
            
            <?php }?>
            <?php
		if($property != AGRI_LAND && $property != RESI_CUM_COMMERCIAL && $property != VACANT_LAND && $property != COMMERCIAL && $property != AGRI_LAND_AND_BUILDING){
		?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">6 Proximity to Civil Amenities</div>
                    <div class="sub_to">1.Nearest Railway Station</div>
                    <div class="sub_to">2.Nearest Bus Stop</div>
                    <div class="sub_to">3.Nearest Hospital</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to">
                        <?= $details->nearest_railway_station?? ''?>
                        <br><?= $details->nearest_bus_stop?? ''?>
                        <br><?= $details->nearest_hospital?? ''?>
                    </div>
                </td>
            </tr>
            <?php } 
		if($property == RESI_CUM_COMMERCIAL){
		?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">7 Property Identification</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->property_identification??'';?></div>
                </td>
            </tr>
            <?php } 
		if($property != AGRI_LAND && $property != RESI_CUM_COMMERCIAL && $property != VACANT_LAND && $property != AGRI_LAND_AND_BUILDING){?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">8 Proximity to necessities and facilities like Education,Medical and
                        Recreational</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= $details->feasibility_civic_amenties?? '' ;?></div>
                </td>
                
            </tr>

<?php 
		}
// }elseif ($property == RESI_CUM_COMMERCIAL || $property == COMMERCIAL || $property == INDUSTRIAL_BUILDINGS ) {?>

<?php 
        if($property != AGRI_LAND && $property != VACANT_LAND && $property != AGRI_LAND_AND_BUILDING){
		?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">9. Landmark Details</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"></div>
                </td>
            </tr>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">Nearest Railway Station</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->nearest_railway_station?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">Nearest Bus Stop</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->nearest_bus_stop?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">Nearest Hospital</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->nearest_hospital?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">Nearest Landmark</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->nearest_landmark?></div>
                </td>
            </tr>
            <?php } ?>
        </table>

<table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>C. PROPERTY DETAILS</b></div>
                </td>
            </tr>
        </table>

<table class="table_box">
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">1 Type of Usage of Entire Property</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?= getValue('nature_of_the_properties',$details->nature_of_the_property);?>
                    </div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">2 Additional Amenities</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?= getvalue('additional_amenities',$details->additional_amenitie??'');?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">3 Legal Status of Property</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->leagal_status_of_property??'';?></div>
                </td>
            </tr>
            <tr class="table_box_line">
                <td align="left" width="50%" colspan="2">
                    <div class="sub_to"></div>
                </td>
            </tr>
        </table>
        <?php 
if($property != AGRI_LAND && $property != VACANT_LAND && $property != AGRI_LAND_AND_BUILDING){
?>
        <table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>D. SUBJECT PROPERTY DETAILS</b></div>
                </td>
            </tr>
        </table>

<table class="table_box">
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">1 Type of Premises</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?= getValue('type_of_premises',$details->type_of_premise??'');?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">2 Occupied by</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->occupied_rent_details?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">3 Property Taxation/Maintenance Cost</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->taxation_or_maintance?? ''?></div>
                </td>
            </tr>

<?php 
	if($property == RESI_CUM_COMMERCIAL || $property == COMMERCIAL || $property == INDUSTRIAL_BUILDINGS ){
	?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">4 Renting Potential</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->renting_potential?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">5 Market Rentals / Sqft/Month (Rs.)</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->market_rentals?? ''?></div>
                </td>
            </tr>
            <?php }?>
        </table><br>
        <?php 
}
?>

<table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>Actual Boundary Details</b></div>
                </td>
            </tr>
        </table>
        <?php
for ($i = 0; $i < count($details->boundaries_manual_input); $i++) {
	$boundaryRow = $details->boundary[$i] ?? [];
	$thak1Row = $details->thak_1[$i] ?? [];

$allBoundaryEmpty = empty(array_filter($boundaryRow, fn($v) => trim($v) !== ''));
$allThak1Empty = empty(array_filter($thak1Row, fn($v) => trim($v) !== ''));
// print_r($boundaryRow);die();
// echo $allThak1Empty;die();

// if ($allBoundaryEmpty && $allThak1Empty) {
//     continue; 
// }

$thakCount = $details->thak_count[$i] ?? 0;

// if (empty($details->boundary[$i]) && empty($details->thak_1[$i])) {
//     continue;
// }  
    echo "<table class='table_box'>";
    $colspan = 2 + $thakCount;
echo "<tr><th colspan='{$colspan}' style='text-align:left;background-color:#DCDCDC;'>" . 
     htmlspecialchars($details->boundaries_manual_input[$i] ?? '') . "</th></tr>";

if (array_filter($boundaryRow) && array_filter($thak1Row)) {

echo "<tr>";
    echo "<th width='20%' align='left' class='sub'>&nbsp;Directions</th>";
    echo "<th align='left' class='sub'>&nbsp;Boundaries</th>";
    
    for ($t = 1; $t <= $thakCount; $t++) {
        $thakKey = "thak_$t";
        $measurementType = $details->boundaries_type[$i] ?? '';
        echo "<th style='padding:1px' class='sub'>Linear Measurement " . htmlspecialchars($measurementType) . "</th>";
    }
    echo "</tr>";

$directions = $details->direction[$i] ?? [];
    $boundaries = $details->boundary[$i] ?? [];

$rowCount = max(count($directions), count($boundaries));
    for ($j = 0; $j < $rowCount; $j++) {
        echo "<tr>";
        echo "<td class='sub_to' align='left' style='padding:3px;'>&nbsp;" . htmlspecialchars($directions[$j] ?? '') . "</td>";
        echo "<td class='sub_to'>" . htmlspecialchars($boundaries[$j] ?? '') . "</td>";

for ($t = 1; $t <= $thakCount; $t++) {
            $thakKey = "thak_$t";
            // $val = $details->$thakKey[$i][$j] ?? '';
			// $val = isset($details->$thakKey->$i->$j) ? $details->$thakKey->$i->$j : '';
			$val = '';

if (isset($details->$thakKey)) {
    $thakData = $details->$thakKey;

if (is_array($thakData)) {
        $val = $thakData[$i][$j] ?? '';
    } elseif (is_object($thakData)) {
        $val = $thakData->$i[$j] ?? '';
    }
}

echo "<td align='center' class='sub_to'>" . (is_numeric($val) ? number_format($val, 2) : htmlspecialchars($val)) . "</td>";
        }

echo "</tr>";
	}
$labelsObj = $details->total_extend_additional_info_label_[$i] ?? null;
$valuesObj = $details->total_extend_additional_info_value_[$i] ?? null;
$measurementsObj = $details->total_extend_of_the_land_additional_info_measurement_[$i] ?? null;

if ($labelsObj && is_object($labelsObj)) {
    foreach ($labelsObj as $key => $label) {
        $value = $valuesObj->$key ?? '';
        $measurementUnit = getValue('measurement_units', $measurementsObj->$key ?? '');

if (!empty($label) || !empty($value)) {
            $labelColspan = $colspan - 1;

echo "<tr>";
            echo "<td class='sub_to' colspan='{$labelColspan}' align='right'><b>" . htmlspecialchars($label) . "</b></td>";
            echo "<td class='sub_to' align='left'><b>" . htmlspecialchars($value);
            if (!empty($measurementUnit)) {
                echo " " . htmlspecialchars($measurementUnit);
            }
            echo "</b></td>";
            echo "</tr>";
        }
    }
}
}

$extendIndex = $i; // use table index directly
$extendValue = $details->extend_of_land_1[$extendIndex] ?? '';

if (!empty($extendValue)) {
    $measurement = getValue('measurement_units', $details->total_extend_of_the_land_measurement[$extendIndex] ?? '');
    $additionalArea = $details->total_extend_of_the_land_additional_info[$extendIndex] ?? '';
    $additionalMeasurement = getValue('measurement_units', $details->total_extend_of_the_land_additional_info_measurement[$extendIndex] ?? '');

echo '<tr>';
    $labelColspan = $colspan - 1;
    echo "<td class='sub_to' colspan='{$labelColspan}' align='right'><b>Extend of Land</b></td>";
    echo "<td class='sub_to' align='left'><b>";

if (!empty($extendValue) && $extendValue != 0) {
    echo htmlspecialchars($extendValue);

if (!empty($measurement)) {
        echo " " . htmlspecialchars($measurement);
    }

if (!empty($additionalArea) && $additionalArea != 0) {
        echo " " . number_format($additionalArea);
    }

if (!empty($additionalMeasurement)) {
        echo " " . htmlspecialchars($additionalMeasurement);
    }
}

echo "</b></td>";
    echo '</tr>';
}

echo "</table><br>";
}
if (!empty($details->additional_info_label_->{1})) { 
    echo "<table class='subtable' style='border-collapse: collapse;'>";
    echo "<tr><th>Label</th><th>Value</th></tr>";

foreach ($details->additional_info_label_ as $key => $label) {
        $value = isset($details->additional_info_value_->$key) ? $details->additional_info_value_->$key : '';

echo "<tr>";
        echo "<td style='text-align:center'>" . htmlspecialchars($label) . "</td>";
        echo "<td style='text-align:center'>" . htmlspecialchars($value) . "</td>";
        echo "</tr>";
    }
	
    echo "</table>";
}

?>
        <!-- </td>

</tr>
<tr>
	<td width = "100%"> -->
        <?php
$measurement1 = getValue('measurement_units', $details->measurement_type_guideline ?? '');

$rows = [
    'Total Extend of the Land as on Document'       => $details->extent_of_the_site ?? '',
    'Total Extend of the Land as on Site'           => $details->extend_valuation ?? '',
    'Total Extend of the Land as on Document/Site'  => $details->as_per_doc_site ?? '',
    'Total Extend of the Land as on Patta'          => $details->as_per_patta ?? '',
];

// Filter out empty or zero-equivalent values
$filteredRows = array_filter($rows, function($value) {
    return !empty($value) && $value != 0 && $value !== '0';
});

if (!empty($filteredRows)): ?>
        <table class="table_box" style="page-break-inside: avoid;">
            <?php foreach ($filteredRows as $label => $value): ?>
            <tr>
                <td class="sub_to" width="70%" style="text-align:right"><b><?= $label ?></b></td>
                <td class="sub_to" align="right"><?= $value . $measurement1 ?></td>
            </tr>
            <?php endforeach; ?>
        </table>
        <?php endif; ?>

<table class="table">
            <tr>
                <td>
                    <div class="sub_to">Latitude & Longitude <span
                            class="sub_to"><?= $details->latitude.', '.$details->longitude?></span></div>
                </td>
            </tr>
        </table>

<?php 
	if($property == AGRI_LAND || $property == AGRI_LAND_AND_BUILDING){
		
		?>
        <table>
            <tr>
                <td class="sub_to" width="70%">1 Classification of Land</td>
                <td class="sub_to"><?= getValue('classification_of_areas', $details->classification_of_the_area??'');?>
                </td>
            </tr><br>
            <tr>
                <td class="sub_to">2 Wet or Dry</td>
                <td class="sub_to"><?=$details->wet_or_dry?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">3 Kind of crop under Cultivation</td>
                <td class="sub_to"><?=$details->crop_under_cultivation?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">4 Number of Yields<span
                        style="text-align: right;"><?=$details->no_of_yields?? ''?></span></td>
                <td class="sub_to"><?=$details->no_of_yields?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">5 Special features of the land, quality And fertileness of land </td>
                <td class="sub_to"><?=$details->quality_and_fertileness?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">6 Mode of irrigation available
                    <br><span style="margin-left: 6%;">Canal</span>
                    <br><span style="margin-left: 6%;">Bore well with motor</span>
                    <br><span style="margin-left: 6%;">Open well with motor etc</span>
                </td>
                <td class="sub_to">
                    <br><?=$details->canal?? ''?>
                    <br><?=$details->bore_well_with_motor?? ''?>
                    <br><?=$details->open_well_with_motor?? ''?>
                </td>
            </tr><br>
            <tr>
                <td class="sub_to">7 Method of irrigation<br><span style="margin-left: 6%;">Drip / Channel /
                        Sprinkler</span></td>
                <td class="sub_to"><br><?=$details->method_of_irrigation?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">8 Availability of road and if so the width?</td>
                <td class="sub_to"><?=getValue('width-of-road', $details->width_of_road??''); ?></td>
            </tr><br>
            <tr>
                <td class="sub_to">9 Land is Freehold or Leasehold </td>
                <td class="sub_to"><?=$details->leagal_status_of_property?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">10 If leased out what is the lease income? </td>
                <td class="sub_to"><?=$details->lease_income?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">11 Other features which affect the value Of the land </td>
                <td class="sub_to"><?=$details->wet_or_dry?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">12 Other structures such as farm house Office, Pump room etc. are
                    available?</td>
                <td class="sub_to"><?=$details->wet_or_dry?? ''?></td>
            </tr><br>
            <tr>
                <td class="sub_to">13 Nearest town and distance</td>
                <td class="sub_to"><?=$details->nearest_landmark?? ''?></td>
            </tr>
            <?php 
	}
		?>
        </table>

<table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>E. STRUCTURAL DETAILS</b></div>
                </td>
            </tr>
        </table>

<table class="table_box" border=0>
            <?php
	        if($property == RESIDENTIAL || $property == RESI_CUM_COMMERCIAL  || $property == INDUSTRIAL_BUILDINGS || $property == COMMERCIAL )

{
		?>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">1 Type of Structure</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?= getValue('type_of_structure',$details->type_of_construction?? '');?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">2 No. of Floors</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->no_of_floor?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">3 No. of Wings</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->no_of_wings?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">4 No. of Flats on Each floor</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->flats_on_each_floor?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">5 Internal Composition of the Flat</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->internal_composition_of_flat?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">6 No. of Lifts in Each Wing</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->lifts_in_each_wings?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">7 Age of the Property</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?= $details->year_of_construction_or_age?? ''; ?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">8 Estimated Future Life</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->residual_life_of_building??'';?></div>
                </td>
            </tr>
        </table>

<table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>F. Quality of Construction</b></div>
                </td>
            </tr>
        </table>

<table class="table_box" border=0>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to"><br>a. Exteriors</div>
                </td>
                <td align="left" width="50%"></td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">i) Beam & Column Structure</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?= getValue('beam_structure',$details->beam_and_column??'');?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">ii) Quality of Constructions Appearance & <br>Maintenance of building</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to">
                        <?= getValue('quality_of_construction',$details->qty_of_construction_apprence??'');?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">iii) Common Area Remarks</div>
                </td>

<td align="left" width="50%">
                    <div class="sub_to"><?=$details->common_area_remarks??'';?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">b. Interiors</div>
                </td>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">iv) Flooring & Finishing</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= $details->flooring_skirting_dadoing_gf?? ''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">v) Roofing and Terracing</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= $details->rcc_works_gf?? ''.",". $details->rcc_works_ff??''?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">vi) No. of Lifts</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->no_of_lifts??'0';?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">vii) Quality of Fixtures & Settings</div>
                </td>
                <td align="left" width="50%" class="sub_to">
                    <div class=""><?= getValue('quality_of_fixtures', $details->qty_of_fixtures_and_settings??''); ?>
                    </div>
                </td>
            </tr>
        </table>
        <?php }
	        if($property == RESIDENTIAL || $property == RESI_CUM_COMMERCIAL  || $property == INDUSTRIAL_BUILDINGS || $property == COMMERCIAL ){

<table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>G. Plan Approvals</b></div>
                </td>
            </tr>
        </table>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">1 Construction as per approved</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->cons_as_per_approved??'';?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">2 Sanctioned Plans details of Approved Llan & Plans with Approval No & Dated
                    </div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= $details->furnish_type?? ''; ?> -
                        <?= $details->approved_map_issuing_authority??''; ?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">3 Construction Permission Number & Date</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?= $details->furnish_type?? ''; ?> - Dt:
                        <?=date("d.m.Y", strtotime($details->date_of_issue?? ''));?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">4 Violations Observed if any or is there any Risk of Demolition in Case of
                        Violation, the Structure Confirming to the Local Byelaws</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->violation_observed??'';?></div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">5 If plans not available then is the Structure Confirming to the Local Byelaws /
                        Other Documents Verified</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->local_byelaws_or_docs??'';?></div>
                </td>
            </tr>
            <?php 
		}
		?>
        </table>

<table class="table">
            <tr>
                <td>
                    <div class="sub_to"><b>For Land and Building Valuation<b></div>
                </td>
            </tr>
            <?php
		if($property == AGRI_LAND_AND_BUILDING){
		?>
            <tr>
                <td>
                    <div class="sub_to"><b>1 Total extent of Land
                            Area</b>&nbsp;&nbsp;<?=$details->guideline_value_of_land_agri_total? : '0';?></div>
                </td>
            </tr>
            <tr>
                <td>
                    <div class="sub_to"><b>2 Total Land Considered for
                            valuation</b>&nbsp;&nbsp;<?=$details->guideline_value_of_land_agri_total? : '0';?></div>
                </td>
            </tr>
            <?php } ?>
            </tr>
        </table>
        <?php
// if($property == AGRI_LAND || $property == AGRI_LAND_AND_BUILDING)
			if (!empty($details) && $details->agriLand == 1)

{

$properties = get_object_vars($details);
$land_sf_keys = array_filter(array_keys($properties), function($key) {
    return strpos($key, 'guideline_rate_sf_no_agri_') === 0;
});

$market_sf_keys = array_filter(array_keys($properties), function($key) {
    return strpos($key, 'prevailing_market_sf_no_agri_') === 0;
});
echo "<label class='sub_to'>3. Current Govt. approved rates of land.</label><br>";
echo "<table class='table_box subtable'>";
echo "<tr>
        <th class='sub_to'>Land S.F.No</th>
        <th class='sub_to'>Extent in Acre</th>
        <th class='sub_to'>Guide Line Rate in Acre</th>
        <th class='sub_to'>Guide Line Value in Rs.</th>
      </tr>";

foreach ($land_sf_keys as $index => $land_sf_key) {
    $index_number = substr($land_sf_key, -1);
    $land_sf_value = $details->$land_sf_key;
    // $extent_in_acre = !empty($details->extend_valuation) ? $details->extend_valuation : (isset($details->extent_of_the_site) ? $details->extent_of_the_site : '');
    $measurement_type_guideline = getValue('measurement_units', $details->{"measurement_type_guideline_" . $index_number} ?? '');
    // $measurement_type_guideline = isset($details->{"measurement_type_guideline_" . $index_number}) ? $details->{"measurement_type_guideline_" . $index_number} : '';
    $guide_line_rate = isset($details->{"guideline_rate_agri_" . $index_number}) ? $details->{"guideline_rate_agri_" . $index_number} : '';
    $guide_line_value = isset($details->{"guide_rate_estimate_result_" . $index_number}) ? $details->{"guide_rate_estimate_result_" . $index_number} : '';
    $guide_line_value_agri = isset($details->{"guideline_value_of_land_agri_" . $index_number}) ? $details->{"guideline_value_of_land_agri_" . $index_number} : '';

echo "<tr>
            <td class='sub_to'>" . $land_sf_value . "</td>
            <td class='sub_to' style='text-align:right'>" . $guide_line_value_agri . " / " . $measurement_type_guideline . "</td>
            <td class='sub_to' style='text-align:right'>" . $guide_line_rate . "</td>
            <td class='sub_to' style='text-align:right'>" . formatRupees($guide_line_value) . "</td>
          </tr>";
}
echo "<tr>
<td class='sub_to'>Total Extent</td>
<td class='sub_to' style='text-align:right'>" . $details->guideline_value_of_land_agri_total . "</td>
<td class='sub_to'>Total guide line value</td>
<td class='sub_to' style='text-align:right'>" . formatRupees($details->guideline_value_of_result_total) . "</td>
</tr>";

echo "</table><br>";

echo "<label class='sub_to'>4. Recommended rate and basis for recommendation</label><br>";
echo "<br><table class='table_box subtable'>";
echo "<tr>
        <th class='sub_to'>Land S.F.No:</th>
        <th class='sub_to'>Extent in acre</th>
        <th class='sub_to'>Market Rate in acre</th>
        <th class='sub_to'>Market value in Rs.</th>
      </tr>";

foreach ($market_sf_keys as $index => $market_sf_key) {
    $index_number = substr($market_sf_key, -1);
    $market_sf_value = $details->$market_sf_key;
    // $extent_in_acre = !empty($details->extend_valuation) ? $details->extend_valuation : (isset($details->extent_of_the_site) ? $details->extent_of_the_site : '');
    $measurement_type_market = getValue('measurement_units', $details->{"measurement_type_market_" . $index_number} ?? '');
    $prevailing_market_rate = isset($details->{"prevailing_market_rate_agri_" . $index_number}) ? $details->{"prevailing_market_rate_agri_" . $index_number} : '';
    $estimated_value_of_land = isset($details->{"prevailing_guideline_result_agri_" . $index_number}) ? $details->{"prevailing_guideline_result_agri_" . $index_number} : '';
    $estimated_value_of_land_agri = isset($details->{"estimated_value_of_land_agri_" . $index_number}) ? $details->{"estimated_value_of_land_agri_" . $index_number} : '';
	// $formatter = new NumberFormatter('en_GB',  NumberFormatter::CURRENCY);
	// echo 'UK: ', $formatter->formatCurrency($estimated_value_of_land, 'EUR'), PHP_EOL;
    echo "<tr>
            <td class='sub_to' >" . $market_sf_value . "</td>
            <td class='sub_to' style='text-align:right'>" . $estimated_value_of_land_agri . "</td>
            <td class='sub_to' style='text-align:right'>" . $prevailing_market_rate . "</td>
            <td class='sub_to' style='text-align:right'>" . formatRupees($estimated_value_of_land) . "</td>
          </tr>";
}
echo "<tr>
<td class='sub_to'>Total Extent</td>
<td class='sub_to' style='text-align:right'>" . $details->estimated_value_of_land_agri_total . "</td>
<td class='sub_to'>Total market value</td>
<td class='sub_to' style='text-align:right'>" . formatRupees($details->prevailing_guideline_result_total) . "</td>
</tr>";
echo "</table>";
	}
?>

<?php
if($property != AGRI_LAND && $property != AGRI_LAND_AND_BUILDING){ ?>

<table class="table_box" border=0>
            <tr>
                <td align="left" width="50%">
                    <div class="sub_to">1 Land Area</div>
                </td>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->guideline_value_of_land??'';?> Sq.ft</div>
                </td>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">2 Current Govt. Approved Rates for Land.</div>
                </td>
                <?php 
			if (!empty($details) && $details->agriLand == 1){
                $measurement_type_guideline_agri = getValue('measurement_units',$details->measurement_type_guideline_agri?? '');
                ?>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->guideline_value_of_land_agri_total?? '0';?> / <?= $measurement_type_guideline_agri;?></div>
                </td>
                <?php
			}else{
			?>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->guideline_rate?? '0';?> / Sq.ft</div>
                </td>
                <?php	
			}
			?>
            </tr>

<tr>
                <td align="left" width="50%">
                    <div class="sub_to">3 Recommended Rate & Basis for Recommendation</div>
                </td>
                <?php
			if (!empty($details) && $details->agriLand == 1){
                $measurement_type_market_agri = getValue('measurement_units',$details->measurement_type_market_agri?? '');
                ?>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->estimated_value_of_land_agri_total?? '0';?> / <?= $measurement_type_market_agri?></div>
                </td>
                <?php
			}else{
			?>
                <td align="left" width="50%">
                    <div class="sub_to"><?=$details->prevailing_market_rate?? '0';?> / Sq.ft</div>
                </td>
                <?php
	     	} 
			?>
            </tr>
        </table>
        <br>
        <?php
			if (!empty($details) && $details->agriLand != 1){
       ?>
        <table class="table_box" style="page-break-inside: avoid;">
            <tr>
                <td align="left" colspan="4">
                    <div class="sub_to">4 Land Value</div>
                </td>
            </tr>

<tr>
                <th align="left" class="sub_to"><b>Valuation of the Land</b></th>
                <th class="sub_to"><b>Extent of the Land Acre & Cent&nbsp;</b></th>
                <th align="right" class="sub_to"><b>Rate per Extent&nbsp;</b></th>
                <th align="right" class="sub_to"><b>Amount in Rs.&nbsp;</b></th>
            </tr>

<tr>
                <td align="left" class="sub_to">Guide Line Value of the Land</td>
                <td align="center" class="sub_to"><?=$details->guideline_value_of_land??'';?></td>
                <td align="right" class="sub_to"><?=formatRupees($details->guideline_rate??'');?></td>
                <td align="right" class="sub_to"><?=formatRupees($details->guide_rate_estimate_result??'');?></td>
            </tr>

<tr>
                <td align="left" class="sub_to">Present Market Value of the Land</td>
                <td align="center" class="sub_to"><?=$details->estimated_value_of_land??'';?></td>
                <td align="right" class="sub_to"><?=formatRupees($details->prevailing_market_rate??'');?></td>
                <td align="right" class="sub_to" width="100">
                    <?=formatRupees($details->prevailing_guideline_result??'');?></td>
            </tr>
        </table>
        <br>
        <?php
            }
}

if($property != AGRI_LAND && $property != VACANT_LAND){ ?>

<div class="sub_to"><b>Actual Built up Area</b></div>

<table class="table_box">
            <?php 
			$totalActual = 0;

foreach ($details->floor_and_area as $key => $floor) {
				$actualValue = isset($details->actual[$key]) ? $details->actual[$key] : '';  
				if ($actualValue === '') {
					continue;
				}

$totalActual += $actualValue;

echo "<tr>";
				echo "<td class='sub_to'>$floor</td>";
				echo "<td class='sub_to' align='center'>$actualValue </td>";
				echo "<td class='sub_to' align='center'> Sq.ft</td>";
				echo "</tr>";
			}
			?>

<tr>
                <td align="right"><b>Total BUA</b></td>
                <td align="center"><b><?php echo $totalActual; ?></b></td>
                <td align="center" class="sub_to"><b>Sq.ft</b></td>
            </tr>
            <tr>
                <td align="right"><b>FSI</b></td>
                <td align="center"><b><?= $details->fsi_build_up_areas??''; ?></b></td>
                <td align="center" class="sub_to"><b></b></td>
            </tr>
        </table>
        <br>
        <div class="sub_to"><b>Approved/Allowable Built up Area</b></div>

<?php 
	// $totalsanction = 0;

foreach ($details->floor_and_area as $key => $floor) {
		$sanction_plan = isset($details->sanction_plan[$key]) ? $details->sanction_plan[$key] : '';  
		if ($sanction_plan === '') {
			continue;
		}
		// $totalsanction += $sanction_plan;

echo "<tr>";
		echo "<td class='sub_to'>$floor</td>";
		echo "<td class='sub_to' align='center'>$sanction_plan</td>";
		echo "<td class='sub_to' align='center'>Sq.ft</td>";
		echo "</tr>";
	}
	?>
            <tr>
                <td align="right"><b>Total BUA</b></td>
                <td align="center"><b><?=$details->total_sanction_plan??'';?></b></td>
                <td align="center" class="sub_to"><b>Sq.ft</b></td>
            </tr>
            <tr>
                <td align="right"><b>FSI</b></td>
                <td align="center"><b><?= $details->fsi_sanction_plans??''; ?></b></td>
                <td align="center" class="sub_to"><b></b></td>
            </tr>

</table>

<br>

<div class="sub_to">5 Building Area & Value Details<br><br><b>Valuation</b></div>

<table class="table" cellspacing="5">
            
            <tr>
                
                <td class="sub_to"><b>Present costruction Cost - </b> &nbsp;
                    <?= $details->present_construction_cost_gfloor?? ''?>&nbsp;per sq.ft</td>
            </tr>
            <?php
			if(!empty($details->valuation_result)){
				$valuation_data = $details->valuation_result;
			}else{
				$valuation_data = '';
			}
			?>

</table>

<table class="table_box">
            <tr>
                <th colspan="8">Details of Present Construction Cost of the Building</th>
            </tr>

<tr>
                <th class="txt-center" style="font-size:x-small ;" width = "30%">Description of the Building</th>
                <th class="txt-center" style="font-size:x-small ;" width="10%">Area in Sq.ft</th>
                <th class="txt-center" style="font-size:x-small ;" width="10%">Rate/Sq.ft</th>
                <th class="txt-center" style="font-size:x-small ;" width="10%">Present Construction Cost</th>
                <th class="txt-center" style="font-size:x-small ;" width="7%">Age of the Building</th>
                <th class="txt-center" style="font-size:x-small ;" width="7%">Residual life of the Building</th>
                <th class="txt-center" style="font-size:x-small ;" width="7%">Depreciation Percentage Considered for Valuation</th>
                <th class="txt-center" style="font-size:x-small ;">Depreciated Value of the Building</th>
            </tr>

<?php if(isset($details) && !empty($details->describe_of_the_building)) { 
                      					foreach($details->describe_of_the_building as $key => $dob){
											 if (!empty($details->area_in_sq_ft[$key]) && !empty($details->rate_per_sq_ft[$key]) && !empty($details->present_construction_cost[$key])) {
                      	
			if ($valuation_data != 'Negative') {			
						?>

<tr>
                <td class="sub_to txt-center"><?php echo $dob; ?></td>
                <td class="sub_to txt-center">
                    <?= $details->area_in_sq_ft[$key]; ?>
                </td>
                <td class="sub_to txt-center">
                    <?= $details->rate_per_sq_ft[$key]; ?>
                </td>
                <td class="sub_to txt-center">
                    <?= $details->present_construction_cost[$key]; ?>
                </td>
                <td class="sub_to txt-center">
                    <?= $details->age_of_the_building[$key]; ?>
                </td>
                <td class="sub_to txt-center">
                    <?= $details->residual_life_of_the_building[$key]; ?>
                </td>
                <td class="sub_to txt-center">
                    <?= $details->depreciation_percentage[$key]; ?>
                </td>
                <td style="text-align: right;" class="sub_to">
                    <?= formatRupees($details->depreciation_value_building[$key]); ?>
                </td>
            </tr>
            <?php
			}
		} } } ?>

<tr>
                <td align="right" colspan="6" class="sub_to">Total Depreciated value of the Building&nbsp;</td>
                <td align="center" class="sub_to"><span style="font-family: DejaVu Sans, sans-serif;">₹</span></td>
                <td align="right" class="sub_to">
                    <?php 
    if ($valuation_data != 'Negative') {

$land_value = (float) ($details->prevailing_guideline_result ?? 0);
$total_depreciation_value = (float) ($details->total_depreciation_value ?? 0);
$forced_sale_percentage = (float) ($details->forced_sale_value_percentage ?? 0);

$realisable_sale_value = $land_value + $total_depreciation_value;

$total = ($realisable_sale_value * $forced_sale_percentage) / 100;

// echo $total . '<br>';

// $land_value         = (float) ($details->prevailing_guideline_result ?? 0);
        // $total_depreciation_value = (float) ($details->total_depreciation_value ?? 0);
        // $forced_sale_percentage = (float) ($details->forced_sale_value_percentage ?? 0);
        // $realisable_sale_value = (float) ($details->realisable_sale_value ?? 0);
        // $realisable_sale_value = 0;
        // $$realisable_sale_value = $land_value+$total_depreciation_value;

// $addtotal = $total_depreciation_value + $realisable_sale_value;
		// $total = ($realisable_sale_value*$forced_sale_percentage)/100;
        // echo $realisable_sale_value.'<br>';

// echo $total.'<br>';

// $rounded = roundToNearestThousand($value);
        echo formatRupees($total_depreciation_value);
    } 
    ?>&nbsp;
                </td>
            </tr>
            <?php 
            $amenities = $details->amenities_rate ?? '0.00';
            if($amenities != '0.00'){
            ?>
            <tr>
                <td align="right" colspan="6" class="sub_to">Amenities&nbsp;</td>
                <td align="center" class="sub_to"><span style="font-family: DejaVu Sans, sans-serif;">₹</span></td>
                <td align="right" class="sub_to">
                    <?php 
    if ($valuation_data != 'Negative') {
        // $value = $details->amenities_rate ?? '0.00';
        echo formatRupees($amenities);
    } 
    ?>&nbsp;
                </td>
            </tr>
            <?php
            }
            ?>
            <tr>
                <td align="right" colspan="6" class="sub_to">Realisable Sale Value of the Property&nbsp;(Land &
                    Building)</td>
                <td align="center" class="sub_to"><span style="font-family: DejaVu Sans, sans-serif;">₹</span></td>
                <td align="right" class="sub_to">
                    <?php 
    if ($valuation_data != 'Negative') {
        // $realisable_sale_value = $details->realisable_sale_value ?? '0.00';
        echo formatRupees($realisable_sale_value);
    } 
    ?>
                </td>
            </tr>
            <tr>
                <td align="right" colspan="6" class="sub_to">Forced Sale Value of the Property&nbsp;(Land & Building)
                </td>
                <td align="center" class="sub_to"><span style="font-family: DejaVu Sans, sans-serif;">₹</span></td>
                <td align="right" class="sub_to">
                    <?php 
    if ($valuation_data != 'Negative') {
        $forced_sale_value = $details->forced_sale_value ?? '0.00';
        echo formatRupees($forced_sale_value);
    } 
    ?>&nbsp;
                </td>
            </tr>

<!-- <tr>
				<td align="right" colspan="6" class="sub_to">Land Value + Depreciated value of the Building with Amenites&nbsp;</td>
				<?php
// 				$land_value         = (float) ($details->prevailing_guideline_result ?? 0);
// $depreciation_value = (float) ($details->total_depreciation_value ?? 0);
// $extra_items_rate   = (float) ($details->extra_items_rate ?? 0);
// $amenities_rate     = (float) ($details->amenities_rate ?? 0);
// $miscellaneous_rate = (float) ($details->miscellaneous_rate ?? 0);
// $services_rate      = (float) ($details->services_rate ?? 0);

// $total_value = $land_value + $depreciation_value ?: ($land_value ?: $depreciation_value);
// $total_value += $extra_items_rate + $amenities_rate + $miscellaneous_rate + $services_rate;

// $rounded_total = roundToNearestThousand($total_value);

?>
				<td align="center" class="sub_to"><span style="font-family: DejaVu Sans, sans-serif;">₹</span></td>
				<td align="right" class="sub_to"><?php if($valuation_data != 'Negative'){ echo formatRupees($total_value); }?>&nbsp;</td>

</tr> -->
            
        </table>
        <?php }
		?>
        <br>
        <table class="table">

<tr>
                <td align="left" width="50%" class="sub_to">Marketability</td>
                <td align="left" width="50%">
                    <div class="sub_to"><b><?= getValue('marketability',$details->marketability??'');?></b></div>
                </td>
            </tr>
            <tr>
                <td align="left" width="50%" class="sub_to">Valuation Result</td>
                <td align="left" width="50%">
                    <div class="sub_to"><b><?=$details->valuation_result??'';?></b></div>
                </td>
            </tr>
        </table>

<br>
        <?php 
	if(!empty($details->editornote)){
	?>
        <div class="sub_to"><b>I. Remarks if any</b></div>
        <div class="sub_to"><?= $details->editornote??'';?></div>
        
        <?php }?>
        <br>

<p class="sub_to"><b>Declaration</b></p>

<p class="sub_to">I Hear by declare that,</p>

<p class="sub_to">1. I have personally inspected the property on
            <?=date("d.m.Y", strtotime($details->date_of_inspection));?></p>

<p class="sub_to">2. I have no direct or indirect interest in the property valued</p>

<p class="sub_to">3. The information furnished in the report is true and correct to the best of my knowledge and
            belief.</p>

<p class="sub_to">4. The opinion given on valuation is based on rates in the market prior to demonetization. The
            actual impact of demonetization could not be gauged as there are no transaction references available in the
            interim. The Bank/HDFC is advised to take necessary precautions in this regard</p>

<p class="sub_to">5. This valuation report is valid provided the bank has followed the guidelines regarding
            documentation and also the post sanction parameters laid down by the bank in respect of advances
            scrupulously by its head office. This valuation report is valid provided there is no faulty documentation
            and there are no lapses in post sanction parameters in respect of advances.</p>
        </td>

<table class="table">
            <tr>
                <td class="sub_to" width="18%" align="left">Name of the Valuer</td>
                <td class="sub_to" width="2%" align="center">:</td>
                <td class="sub_to" width="41%" align="left"><b>Er.S.SENTHIL VELAVAN. B.E., AIV.M.Sc</b></td>
                <td align="left"></td>
                <td class="sub_to" align="left"><b>Signature of the Valuer</b></td>
            </tr>
            <tr>
                <td class="sub_to" width="18%" align="left">Date</td>
                <td align="center" width="2%">:</td>
                <td class="sub_to" align="left"><?= ': ' . date("d.m.Y", strtotime($details->date_val ?? '')); ?></td>
                <td align="left"></td>
                <td class="sub_to" align="left"></td>
            </tr>
        </table>

<!-- <table class="table" style="margin: 50px; margin-right:550px">
					<tr>
						<td class="sub_to">Name of the Valuer</td>
						<th>: Er.S.SENTHIL VELAVAN. B.E., MIE.AIV. M.Sc (Val)</th>
						<th>Signature of the Valuer</th>
					</tr>

<?php
if (!empty($details->image[0])) {
    $page_per_record = $details->page_per_image ?: 4;
    $image_count = count($details->image);
    $current_image_count = 0;

switch ($page_per_record) {
        case 2:
            $rows = 2; $cols = 1;
            $image_width = "570px"; $image_height = "450px"; $padding_lf = "10%";
            break;
        case 4:
            $rows = 2; $cols = 2;
            $image_width = "340px"; $image_height = "400px";
            break;
        case 6:
            $rows = 3; $cols = 2;
            $image_width = "330px"; $image_height = "280px";
            break;
        case 8:
            $rows = 4; $cols = 2;
            $image_width = "330px"; $image_height = "195px";
            break;
        default:
            $rows = 2; $cols = 2;
            $image_width = "340px"; $image_height = "300px";
            break;
    }

$max_images_per_page = $rows * $cols;
    $total_pages = ceil($image_count / $max_images_per_page);
    $page_counter = 0;
?>

<?php for ($i = 0; $i < $image_count; $i++): ?>

<?php if ($i % $max_images_per_page == 0): ?>
        <?php if ($i != 0): ?>
        
        <?php endif; ?>

<?php $page_counter++; ?>

<?php if ($current_image_count % $cols == 0): ?>
            <tr>
                <?php endif; ?>

<?php
        $imagePath = BASE_URL . '/uploads/entries/' . $details->image[$i];
        $imageData = base64_encode(file_get_contents($imagePath));
        $imageName = htmlspecialchars($details->image_name[$i]);
    ?>

<td
                    style="padding: 5px; text-align: center; background-color: white; border: 1px solid #ddd; box-shadow: 0 2px 5px rgba(0,0,0,0.1);">
                    <div style="width: <?= $image_width ?>; height: <?= $image_height ?>;">
                        <img src="data:image/jpeg;base64,<?= $imageData ?>" alt="Image <?= $i + 1 ?>"
                            style="object-fit: cover; max-width:100%; max-height:100%;" />
                    </div>
                    <p style="margin-top: 5px; margin-bottom:5px; font-weight: bold;"><?= $imageName ?></p>
                </td>

<?php $current_image_count++; ?>

<?php if ($current_image_count % $cols == 0): ?>
            </tr>
            <?php endif; ?>

<?php if ((($i + 1) % $max_images_per_page == 0) || ($i + 1 == $image_count)): ?>
            <?php if ($current_image_count % $cols != 0): ?>
            </tr>
            <?php endif; ?>
        </table>
        <?php endif; ?>

<?php endfor; ?>

<?php } ?>

<?php

if(!empty($details->site_image[0])){

?>
        <table class="tab"
            style="width: 100%; padding-top: 10%; border-spacing: 10px; page-break-before:always !important;">

<?php 
	foreach ($details->site_image as $index => $image_url_site): 
		$imagePath_site = BASE_URL.'/uploads/entries/'.$image_url_site;
		$imageData_site = base64_encode(file_get_contents($imagePath_site));
	
		?>
            <div style="width:100%; text-align: left; font-weight: bold; font-size: 14px;">
                Ref.No: <?= htmlspecialchars($details->ref_no) ?>
            </div>
            <tr>
                <td style="width: 100%; padding: 3%; text-align: center;">
                    <img src="data:image/jpeg;base64,<?= $imageData_site; ?>" alt="Image <?= $index + 1; ?>"
                        style="width: 650px; height: 850px; object-fit: cover;" class="img" />
                    <p><?= htmlspecialchars($details->site_name[$index]?? ''); ?></p>

</td>
            </tr>
            <?php 
	endforeach;
	?>
        </table>
        <?php 
	}
	
	if (!empty($details->tn_reginet_image[0])): ?>
        <?php
        $images = $details->tn_reginet_image;
        $names = $details->tn_reginet_name ?? [];
        $total = count($images);
    ?>

<?php for ($i = 0; $i < $total; $i += 2): ?>
        <?php if ($i != 0): ?>
        
        <?php endif; ?>

<?php if (isset($images[$i + $j])): ?>
            <?php
                            $imgUrl = BASE_URL . '/uploads/entries/' . $images[$i + $j];
                            $imgData = base64_encode(file_get_contents($imgUrl));
                            $imgName = htmlspecialchars($names[$i + $j] ?? '');
                        ?>
            <tr>

<td style="width: 50%; padding: 5px; text-align: center;">
                    <img src="data:image/jpeg;base64,<?= $imgData ?>" alt="Image <?= $i + $j + 1 ?>"
                        style="width: 650px; height: 440px; object-fit: cover;" />
                    <p><?= $imgName ?></p>
                </td>
            </tr>

<?php endif; ?>
            <?php endfor; ?>
        </table>
        <?php endfor; ?>
        <?php endif; ?>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: BANK4_pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation