function compare_permissions($db_master, $db_test, $masterdb, $testdb, $dbusername, $webhost)
{
$master_details = get_grants($db_master, $dbusername, $masterdb, $webhost);
$master_grant_no = count($master_details);
$test_details = get_grants($db_test, $dbusername, $testdb, $webhost, $db_master);
$rows = array_keys($master_details);
echo "<table>\n";
foreach ($rows as $row) {
$error = false;
if (!isset($test_details[$row])) {
$error = true;
} else {
if ($master_details[$row] !== $test_details[$row]) {
$error = true;
}
}
if ($error) {
echo "<tr><td class=\"err\">" . $master_details[$row] . "</td><td class=\"err\">";
if (isset($test_details[$row])) {
echo $test_details[$row];
} else {
echo ' ';
}
echo "</td></tr>\n";
} else {
echo "<tr><td>" . $master_details[$row] . "</td><td>" . $test_details[$row] . "</td></tr>\n";
}
}
echo "</table>\n";
}
array_push($tech_arr, $rslt['tech']);
}
}
$rslt['tech'] = $tech_arr;
//change date timestamps
$rslt['date_started'] = date_format(date_create($rslt['date_started']), "F d, Y");
$rslt['date_completed'] = $rslt['date_completed'] ? date_format(date_create($rslt['date_completed']), "F d, Y") : "";
$rslt['researchers'] = get_researchers($pid, $con);
$rslt['grants'] = get_grants($pid, $con);
$rslt['contributing_users'] = get_users($pid, $con);
break;
case 'researchers':
$rslt = get_researchers($pid, $con);
break;
case 'grants':
$rslt = get_grants($pid, $con);
break;
case 'users':
$rslt['users'] = get_users($pid, $con);
//get the new hours since it might've been updated
$query = "SELECT\thours_used\n\t\t\t\t\t FROM\t\tproject_info\n\t\t\t\t\t WHERE\t\tproject_id = {$pid}";
$hours = $con->query($query);
$tmp = $hours->fetch(PDO::FETCH_ASSOC);
$rslt['hours'] = $tmp['hours_used'];
break;
}
echo json_encode($rslt);
function get_researchers($pid, $con)
{
//get info for researchers associated with the project
$query = "SELECT\tr.researcher_first_name as 'first_name',\n\t\t\t\t\t\t\tr.researcher_last_name as 'last_name',\n\t\t\t\t\t\t\trp.pi_flag as 'pi',\n\t\t\t\t\t\t\trp.idx as 'r_ind'\n\t\t\t\t FROM\t\tresearcher r,\n\t\t\t\t\t\t\tproject_researchers rp\n\t\t\t\t WHERE\t\trp.project_id = {$pid}\n\t\t\t\t\t\t\tAND r.researcher_id = rp.researcher_id";
