<?php
// Load JSON data from the two sources
$jsonStaffData = file_get_contents('https://bap.fau.edu/staff_directory');
$facultyData = file_get_contents('https://bap.fau.edu/faculty_directory');
$OverrideFile = json_decode(file_get_contents($_SERVER['DOCUMENT_ROOT'].'/medicine/directory/_includes/dept-override-json.js'), true);

// Decode JSON data into arrays
$jsonStaff = json_decode($jsonStaffData, true);
$faculty_json = json_decode($facultyData, true);

if ($jsonStaff === null || $faculty_json === null || $OverrideFile === null) {
    echo "We apologize but we are currently having connection issues. For assistance, please call 561-297-4828, our main number, and we will be more than happy to transfer you to the appropriate department.";
    exit;
}

// Merge employee and faculty data into a single array
$merged_data = array_merge($jsonStaff, $faculty_json);

// Create a mapping of names to additional data from jsonStaff
$nameToDataMapping = [];
foreach ($OverrideFile as $staffMember) {
    $staffName = $staffMember['email'];
    $nameToDataMapping[$staffName] = $staffMember;
	if($staffMember['add'] === 'yes'){$merged_data[] = $staffMember;}
}

// Evaluate employees and update their information from COM Directory data

foreach ($merged_data as &$f) {
    $nameCheck = $email = strtolower(trim($f['email']));

    // Check if the data is found in $nameToDataMapping
    if (isset($nameToDataMapping[$nameCheck])) {
        $additionalData = $nameToDataMapping[$nameCheck];

        // Update $f with additional data if found
        $f['department'] = $additionalData['department'];
		 // Only override if the value exists in additionalData
        if (isset($additionalData['override_email'])) {$f['override_email'] = $additionalData['override_email'];}
        if (isset($additionalData['override_full_name'])) {$f['override_full_name'] = $additionalData['override_full_name'];}
        if (isset($additionalData['override_prefix'])) {$f['override_prefix'] = $additionalData['override_prefix'];}
        if (isset($additionalData['override_suffix'])) {$f['override_suffix'] = $additionalData['override_suffix'];}
		if (isset($additionalData['custom_creds'])) {$f['custom_creds'] = $additionalData['custom_creds'];}
        if (isset($additionalData['override_degree'])) {$f['override_degree'] = $additionalData['override_degree'];}
        if (isset($additionalData['override_title'])) {$f['override_title'] = $additionalData['override_title'];}
        if (isset($additionalData['override_phone'])) {$f['override_phone'] = $additionalData['override_phone'];}
        if (isset($additionalData['override_dir_name'])) {$f['override_dir_name'] = $additionalData['override_dir_name'];}
 		if (isset($additionalData['custom_creds'])) {$f['custom_creds'] = $additionalData['custom_creds'];}

    } else { }
}

// Create an array to track employees by their email addresses
$uniqueEmployees = [];

// Iterate through the merged data and eliminate duplicates
$filteredData = [];
foreach ($merged_data as $employee) {
    $email = strtolower(trim($employee['email']));

    // Check if this email has already been added to $uniqueEmployees - NOTE: To allow for those 'add' special cases to be included from dept-override.js data, make sure to make their email unique and use override_email to remove if needed. We need a unique email per employee no matter what. Use person's first and last name. example: saimachaudhry as their $email key
    if (!isset($uniqueEmployees[$email])) {
   // Update department names based on $customDepartmentNames
        $departments = array_map('trim', explode(',', $employee["department"])); // Split department names by comma and trim spaces
        
        foreach ($departments as &$department) {
            // Check if the department name needs updating
            if ($department === "Emergency Medicine" || $department === "Surgery" || $department === "Medicine" || $department === "Women's and Children's Health" || $department === "Biomedical Science" || $department === "Clinical Neurosciences") {
                $department = "Department of " . $department;
            }  elseif ($department === "Simulation Center") {
					$department = "Clinical Skills Simulation Center - ATLS";
				}
				elseif ($department === "Population Health") {
					$department = "Department of Population Health";
				}
        }

        $employee["department"] = implode(', ', $departments);
		
		// Override field data if available
		if (isset($employee['override_dir_name']) && !empty($employee['override_dir_name'])) {$employee["name"] = $employee['override_dir_name'];} 
		if (isset($employee['override_title']) && !empty($employee['override_title'])) {$employee['description'] = $employee['override_title'];}
		if (isset($employee['override_phone'])) {$employee['phone'] = $employee['override_phone'];}
		if (isset($employee['override_email'])) {$employee['email'] = $employee['override_email'];}	
		if (isset($employee['custom_creds']) && !empty($employee['custom_creds'])) {$employee['custom_creds'] = $employee['custom_creds'];}	

        // Add the employee to the filtered data	
        $filteredData[] = $employee;


        // Mark this email as added to avoid duplicates
        $uniqueEmployees[$email] = true;
    }
}

// Define custom department names
$customDepartmentNames = [
    "Emergency Medicine" => "Department of Emergency Medicine",
    "Surgery" => "Department of Surgery",
    "Medicine" => "Department of Medicine",
    "Women's and Children's Health" => "Department of Women's and Children's Health",
    "Biomedical Science" => "Department of Biomedical Science",
    "Population Health" => "Department of Population Health",
    "Clinical Neurosciences" => "Department of Clinical Neurosciences",
];

// Extract and organize unique department names
$uniqueDepartments = [];
foreach ($filteredData as $f) {
    $departments = array_map('trim', explode(',', $f["department"])); // Split department names by comma and trim spaces

    // Update department names based on $customDepartmentNames
    $departments = array_map(function ($department) use ($customDepartmentNames) {
        return isset($customDepartmentNames[$department]) ? $customDepartmentNames[$department] : $department;
    }, $departments);

    foreach ($departments as $department) {
        if (!in_array($department, $uniqueDepartments)) {
            $uniqueDepartments[] = $department;
        }
    }
}

// Extract "Office of the Dean" from $uniqueDepartments
$officeOfTheDean = array_filter($uniqueDepartments, function ($department) {
    return $department === "Office of the Dean";
});

// Remove "Office of the Dean" from $uniqueDepartments
$uniqueDepartments = array_filter($uniqueDepartments, function ($department) {
    return $department !== "Office of the Dean";
});

// Sort the remaining department names
sort($uniqueDepartments);

// Merge "Office of the Dean" back to the sorted list
array_unshift($uniqueDepartments, reset($officeOfTheDean));

// Generate the select menu 
echo '<div id="faculty" class="faculty-main mt-6"><div class="faculty-wrapper"><div id="faculty-search-wrap"><label for="faculty-search">Search</label><input type="search" name="search" placeholder="Search by name" id="faculty-search"><div class="input-group"><label for="departmentSelect">Category</label>';
echo '<select id="departmentSelect">';
echo '<option value="" selected="selected">All Categories</option>';
foreach ($uniqueDepartments as $department) {
 if ($department !== "College of Medicine" && $department !== "Research and Graduate Programs" && $department !== "Not Found" && $department !== "") {
      echo '<option value="' . $department . '">' . $department . '</option>';
    }
  
}
echo '</select></div></div><div id="faculty-results" class="faculty-results">
					<table id="faculty-table" width="100%" cellspacing="0">
						<thead>
							<tr>
								<th class="name">Name</th>
								<th class="title">Title</th>
								<th class="phone">Phone</th>
								<th class="email">Email</th>
							</tr>
						</thead>
						<tbody class="list">';

// Sort the filtered data by last name
usort($filteredData, function ($a, $b) {
    return strcasecmp($a['name'], $b['name']);
});

// Process the filtered data
foreach ($filteredData as $f) {

    // Define an array of email addresses to exclude
    $emailsToExclude = [
        'davidgreen@fau.edu','ademner@health.fau.edu','sgografe@fau.edu','cwhitehair@health.fau.edu','doctor@neiledisonmd.com','nedison@health.fau.edu','yua@fau.edu','yua@health.fau.edu','ceitel@fau.edu','dixons@health.fau.edu','purviss@health.fau.edu' // Add the email addresses you want to exclude here
    ];

    $email = strtolower(trim($f['email']));

    // Skip employees with email addresses in the exclusion list
    if (in_array($email, $emailsToExclude)) {
        continue;
    }


  // Remove "Dr. " from the name field, if it's present
    $name = preg_replace('/\bDr\. \s*/i', '', $f["name"]);
	$nameDr = preg_replace('/\bDr\., \s*/i', ', ', $name);
	$namePhDPhD = preg_replace('/,\s*Ph\.D\.\s*,\s*Ph\.D\.\s*/i', ', Ph.D.', $nameDr);
	$name = preg_replace('/\s*,/', ',', $namePhDPhD);
echo '<tr>';
echo '<td class="name">';
if(isset($f["url"]) && !empty($f["url"]) && strpos($f["url"], 'https://www.fau.edu') !== false) {
echo '<a href="'.$f["url"].'">';
}elseif (isset($f["url"]) && !empty($f["url"]) && strpos($f["url"], 'https://www.fau.edu') !== true) {
    echo '<a href="'.$f["url"].'" target="_blank" rel="noopener">';
}else {

}
echo $name;
echo $f["custom_creds"];
if(isset($f["url"]) && !empty($f["url"]) && strpos($f["url"], 'https://www.fau.edu')  !== false) {
echo ' <i class="icon-fau icon-person-view" aria-hidden="true"></i></a>';
}elseif (isset($f["url"]) && !empty($f["url"]) && strpos($f["url"], 'https://www.fau.edu') !== true) {
   echo ' <i class="fa fa-external-link fa-xs" aria-hidden="true"></i></a>';
}else {

}
echo '</td>';
echo '<td class="title">'.$f["description"].'</td>';
echo '<td class="phone">';
$phone = $f["phone"];
// Only display allowed phone numbers
if(strpos($phone, "561-737-") === 0 || strpos($phone, "561-799-") === 0 || strpos($phone, "561-297-") === 0 || strpos($phone, "561-566-5328") === 0 || strpos($phone, "561-955-") === 0 || strpos($phone, "561-733-") === 0 || strpos($phone, "561-825-9699") === 0 || strpos($phone, "561-430-3629") === 0) {echo $f["phone"];}
echo '</td>';
echo '<td class="email"';
echo ' data-department="'.$f["department"].'"';
echo ' data-classification="'.$f["category"].'">';
if(isset($f["email"]) && !empty($f["email"])) {
echo '<a href="mailto:'.$f["email"].'"><span class="icon-fau icon-email-sign" aria-hidden="true"></span> <span class="sr-only">'.$f["email"].'</span></a>';
}
echo '</td>';
echo '</tr>';
}

echo '</tbody>
					</table>
					<div class="no-result hide">No faculty or staff matches your search.<p class="info">Try changing filters above or &nbsp;<a href="javascript:;" id="show-all">click here</a>&nbsp; to see all the results.</p></div>
				</div>
			</div>
		</div>';


?>