<?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');
$staffFiles = json_decode(file_get_contents($_SERVER['DOCUMENT_ROOT'].'/medicine/directory/_includes/staff.json'), true);
$facultyFiles = json_decode(file_get_contents($_SERVER['DOCUMENT_ROOT'].'/medicine/directory/_includes/faculty-com.json'), true);
$facultyFiles2 = json_decode(file_get_contents($_SERVER['DOCUMENT_ROOT'].'/medicine/directory/faculty.json'), true);

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

if ($jsonStaff === null || $faculty_json === null || $staffFiles === null || $facultyFiles === null || $facultyFiles2 === 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;
}

// *** Centralized Functions file call. This MUST be included for this script to work.
include_once $_SERVER['DOCUMENT_ROOT']. '/medicine/directory/_includes/functions-1.inc';

// Merge employee and faculty data department files into a single array
$department_data = array_merge($staffFiles, $facultyFiles, $facultyFiles2);

// 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 ($department_data as $staffMember) {
    $staffName = $staffMember['email'];
    $nameToDataMapping[$staffName] = $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'];
		
    } else {
    if($f['department'] == "Administration" || $f['department'] == "College of Medicine" || $f['department'] == "Not Found") {
echo "<!-- Not Found ";
	 echo '{"first_name":"' . $f['first_name'] . '","last_name":"' . $f['last_name'] . '","department":"' . $f['department'] . '","email":"' . $f["email"] . '","title":"' . $f['description'] . '","phone":"' . $f['phone'] . '","url":"' . $f['url'] . '","degree":"' . $f['suffix'] . '"},';
echo "-->";
		}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
    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 === "Population Health & Social Medicine" || $department === "Clinical Neurosciences") {
                $department = "Department of " . $department;
            }
        }

        $employee["department"] = implode(', ', $departments);

        // 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 & Social Medicine" => "Department of Population Health & Social Medicine",
    "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") {
      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">';


// $filteredData contains the merged data without duplicates

// ADD static employees

$Employee1 = [
    'name' => 'Casey, Robert, M.D.',
    'description' => 'Clinical Affiliate Assistant Professor and Pediatrics Clerkship Director',
	'department' => 'Department of Women\'s and Children\'s Health',
	'email' => '',
	'phone' => ''
];
$Employee2 = [
    'name' => 'Chaudhry, Saima, M.D., MSHS, FACP',
    'description' => 'Clinical Affiliate Professor of Medicine and Associate Dean for Academic Affairs/Memorial Healthcare System (MHS)',
	'department' => 'Department of Medicine',
	'email' => '',
	'phone' => ''
];
$Employee3 = [
    'name' => 'Fahmy, Samer, M.D.',
    'description' => 'Clinical Affiliate Assistant Professor of Medicine and Associate Dean for Academic Affairs/Boca Raton Regional Hospital (BRRH)',
	'department' => 'Department of Medicine',
	'email' => '',
	'phone' => ''
];
$Employee4 = [
    'name' => 'Edison, Neil, M.D.',
    'description' => 'Clinical Affiliate Assistant Professor',
	'department' => 'Department of Clinical Neurosciences',
	'email' => '',
	'phone' => '561-297-4150'
];
$Employee5 = [
    'name' => 'Goldman, Daniel S., M.D.',
    'description' => 'Associate Dean for Academic Affairs/Bethesda Memorial Hospital and Clinical Affiliate Associate Professor of Integrated Medical Science',
	'department' => 'Department of Medicine',
	'email' => '',
	'phone' => '561-297-4241'
];
$Employee6 = [
    'name' => 'Grodin, Tabata, M.D.',
    'description' => 'Clinical Affiliate Instructor of Obstetrics and Gynecology and Assistant Obstetrics and Gynecology Clerkship Director',
	'department' => 'Department of Women\'s and Children\'s Health',
	'email' => '',
	'phone' => '561-297-4366',
	'url' => 'https://www.fau.edu/medicine/directory/tabata-grodin/'
];
$Employee7 = [
    'name' => 'Kleinman, Joseph H., M.D.',
    'description' => 'Clinical Affiliate Assistant Professor of Radiology',
	'department' => 'Department of Medicine',
	'email' => '',
	'phone' => '561-297-4341'
];
$Employee10 = [
    'name' => 'Stucken, Carrie D., M.D.',
    'description' => 'Clinical Affiliate Assistant Professor and Assistant Pediatrics Clerkship Director',
	'department' => 'Department of Women\'s and Children\'s Health',
	'email' => 'cstucken@fau.edu',
	'phone' => '561-741-0000'
];

// Add to filtered data array
$filteredData[] = $Employee1;
$filteredData[] = $Employee2;
$filteredData[] = $Employee3;
$filteredData[] = $Employee4;
$filteredData[] = $Employee5;
$filteredData[] = $Employee6;
$filteredData[] = $Employee7;
$filteredData[] = $Employee10;

// 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' // 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', '', CollegeDirectory_customName($f));
	$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 CollegeDirectory_customCreds($f);
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">'. CollegeDirectory_customTitle($f) .'</td>';
echo '<td class="phone">';
$phone = CollegeDirectory_customPhone($f);
// 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") === 0 || strpos($phone, "561-955") === 0 || strpos($phone, "561-733") === 0) {echo $phone;}
echo '</td>';
//echo '<td class="phone">'. CollegeDirectory_customPhone($f) .'</td>';
echo '<td class="email"';
echo ' data-department="'. CollegeDirectory_customDept($f) .'"';
echo ' data-classification="'.$f["category"].'">';
if(isset($f["email"]) && !empty($f["email"])) {
echo '<a href="mailto:'. CollegeDirectory_customEmail($f) .'" title="'. CollegeDirectory_customEmail($f) .'"><span class="icon-fau icon-email-sign" aria-hidden="true"></span> <span class="sr-only">'. CollegeDirectory_customEmail($f) .'</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>';


?>