$query = new ConnectQuery();
//get data
$dept_data = $query->all('call SELECT_DEPARTMENTS()');
$faculty_data = $query->all('call SELECT_FACULTY()');
$fellow_data = $query->all('call SELECT_FELLOWS()');
$staff_data = $query->all('call SELECT_STAFF()');
$research_data = $query->all('call SELECT_RESEARCH()');
$ghro_data = $query->all('call SELECT_GHRO()');
$lab_data = $query->all('call SELECT_LABORATORY()');
$vaccine_research_data = $query->all('call SELECT_VACCINE_REFUGEE()');
$hiv_data = $query->all('call SELECT_HIV()');
$kycare_data = $query->all('call SELECT_KYCARE()');
//create table object
$pdf = new Table('P', 'mm', 'Letter');
$pdf->SetMargins(5, 5, 5);
$pdf->AddPage();
//create individual tables in the pdf
$pdf->CreateTable('Main Numbers', $dept_header, $dept_data);
$pdf->CreateTable('ID Faculty', $team_header, $faculty_data);
$pdf->CreateTable('ID Fellows', $team_header, $fellow_data);
$pdf->CreateTable('Office Staff', $team_header, $staff_data);
$pdf->CreateTable('Research Staff', $team_header, $research_data);
$pdf->CreateTable('Global Health Research Organization', $team_header, $ghro_data);
$pdf->CreateTable('ID Laboratory/Biorepository Laboratory', $team_header, $lab_data);
$pdf->CreateTable('Vaccine and Refugee Program', $team_header, $vaccine_research_data);
$pdf->CreateTable('HIV Clinic', $team_header, $hiv_data);
$pdf->CreateTable('KY Care Coordination Program', $team_header, $kycare_data);
ob_end_clean();
//cleans cache so the data is retrieved from the database after each browser refresh
$pdf->Output();
//output the object