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'];