function checkReports($staff_id, $super_chain = "", $recursion = 0)
{
global $all_supers;
$indent = "";
$data = "";
$q = "SELECT staff_id, CONCAT( fname, ' ', lname ) AS fullname, email, CONCAT( street_address, ' ', city, ' ', state, ' ', zip) as full_address\n , home_phone, cell_phone,\n emergency_contact_name, emergency_contact_relation,emergency_contact_phone, supervisor_id, lname, fname\n FROM staff\n WHERE supervisor_id = '" . $staff_id . "'\n AND active = 1\n ORDER BY lname, fname";
//print $q . "<br /><br />";
$db = new Querier();
$r = $db->query($q);
if (!$r) {
return $data;
}
$row_count = count($r);
foreach ($r as $myrow) {
if ($recursion == 1) {
$q2 = "select lname, staff_id from staff where staff_id = " . $myrow[9] . " ORDER BY lname, fname";
$supername = $db->query($q2);
$superbits = explode("-", $super_chain);
if (!in_array($supername[1], $superbits)) {
$super_chain = $super_chain . "-" . $supername[1];
array_push($all_supers, $supername[1]);
}
$superbits = explode("-", $super_chain);
// need to reset this after the alteration
$num_supervisors = count($superbits);
//$row_colour = ($row_count % 2) ? $colour1 : $colour2;
if ($num_supervisors > 2) {
$indent = "margin-left:" . 1 * ($num_supervisors * 1) . "em";
} else {
$indent = "font-weight: bold;";
}
}
//$data .= makeExcelData($myrow);
//$data = str_replace( "\r" , "" , $data );
$data .= makeTR($myrow, $indent);
if ($recursion == 1) {
$data .= checkReports($myrow[0], $super_chain, 1);
}
}
//print "<pre>";
// print_r($typeArray);
//return $typeArray;
return $data;
}
$result = $savedReportBean->db->query($savedReportQuery, true, "");
$row = $savedReportBean->db->fetchByAssoc($result);
while ($row != null) {
$saved_report_seed = new SavedReport();
$saved_report_seed->retrieve($row['id'], false);
$report = new Report($saved_report_seed->content);
$display_columns = $report->report_def['display_columns'];
$filters_def = $report->report_def['filters_def'];
$group_defs = $report->report_def['group_defs'];
if (!empty($report->report_def['order_by'])) {
$order_by = $report->report_def['order_by'];
} else {
$order_by = array();
}
$summary_columns = $report->report_def['summary_columns'];
$full_table_list = $report->report_def['full_table_list'];
$owner_user = new User();
$owner_user->retrieve($row['assigned_user_id']);
checkEachColInArr($display_columns, $full_table_list, $row['id'], $row['name'], $owner_user->name);
checkEachColInArr($group_defs, $full_table_list, $row['id'], $row['name'], $owner_user->name);
checkEachColInArr($order_by, $full_table_list, $row['id'], $row['name'], $owner_user->name);
checkEachColInArr($summary_columns, $full_table_list, $row['id'], $row['name'], $owner_user->name);
foreach ($filters_def as $filters_def_row) {
checkEachColInArr($filters_def_row, $full_table_list, $row['id'], $row['name'], $owner_user->name);
}
$row = $savedReportBean->db->fetchByAssoc($result);
}
}
checkReports();
//displayBadReportsList();
echo $mod_strings['LBL_DIAGNOSTIC_DONE'];
