1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / familytree_ / familytree /
Filename : view_pending.php
back
<?php
include "config.php";
login_check();
admin_check();
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width,initial-scale=1.0" />
  <title>Family Tree</title>
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>
<style>
    table {
          border-radius: 9px;
    background-color: #8ac09b;
      border-collapse: collapse;
      text-align: left;
    }

    th, td {
	  
      padding: 10px;
      border-bottom: 1px solid #ddd;
    }

    th {
      background-color: #333;
      color: black;
    }

    th, td {
      text-align: left;
    }

    tr:hover {
      background-color: #f5f5f5;
    }
  </style>
</head>
<body style="background-color:#d5feff;">

<?php include "menu.php"; ?>

<div class="container">
<a href="families.php" class="btn mt-5" style="background-color: #2979bb; color:#ffffff;">Families</a>
<div class="row mt-3">
<div class="container">
<?php
$id = $_GET['id'];

$query = sprintf("select * from members where id = '%s'",$conn->real_escape_string($id));
$result = $conn->query($query);


//echo "<pre>";
if($result->num_rows > 0){
    $record = $result->fetch_assoc();
   

    // Filter out records with "new" value equal to "A"
    $filteredRecords = array_filter(json_decode($record['familyjson']), function ($record) {
        return $record->data->new !== "A";
    });
    //echo "<pre>";
    //print_r(json_decode($record['familyjson']));
    //echo "</pre>";
}


// Function to find relationships based on the provided ID
function find_rels_by_id($data_array, $id)
{
    foreach ($data_array as $item) {
        if ($item['id'] === $id) {
            return $item['rels'];
        }
    }
    return null; // Return null if the ID is not found
}

function get_relative($data_array, $id){
  
  foreach ($data_array as $item) {    
      if ($item['id'] === $id) {
          return $item['data']['first name']." ".$item['data']['last name'];
      }
  }

}



if(isset($filteredRecords) && !empty($filteredRecords)){

    $data_array = json_decode($record['familyjson'], true);

    echo "<table width='100%' border='1' class='table'>";
    echo "<tr><th>Image</th><th>Name</th><th>Birthday</th><th>Gender</th><th>Relationship</th><th>Action</th></tr>";
    foreach($filteredRecords as $record){
        $fname = 'first name';
        $lname = 'last name';
        echo "<tr>";
        
            echo "<td><img src='".($record->data->avatar)."' width='75px' height='75px'></td>";
            echo "<td>".($record->data->$fname.' '.$record->data->$lname)."</td>";
            
            echo "<td>".($record->data->birthday)."</td>";
            echo "<td>".($record->data->gender)."</td>";


            $rels = find_rels_by_id($data_array, $record->id);
            echo "<td>";
            foreach($rels as $key=>$rel){
                echo strtoupper($key).": ";
                if(is_array($rel)){
                  foreach($rel as $rel_id){
                    echo get_relative($data_array, $rel_id);
                  }
                }else{
                  echo get_relative($data_array, $rel);
                }
                echo "<br>";
            }
            echo "</td>";

            echo "<td><a href='approve_member.php?id=".$record->id."&family_id=$id'>Approve</a> | <a href='reject_member.php?id=".$record->id."&family_id=$id'>Deny</a></td>";

        echo "</tr>";
    }
    echo "</table>";
}

?>

</div>
</div>
</div>


</body>
</html>