$f->button('action_report', 'Report', false);
$f->end();
}
protected function action_report()
{
$hdgs = array('Number', 'Date', 'Start', 'Stop', 'Title');
$ttl = "{$_POST['year']} Panels";
$stmt = $this->db->query('select number, date_held,
time_start, time_stop, title from panelcwa
where year = :year order by number', array('year' => $_POST['year']));
if ($stmt->rowCount() == 0) {
$this->message('No records found', true);
} else {
$r = new Report();
if ($_POST['dest'] == 'screen') {
$r->html($ttl, $stmt, $hdgs);
} else {
if ($_POST['dest'] == 'pdf') {
$r->pdf($ttl, $stmt, array(50, 50, 50, 50), $hdgs);
} else {
if ($_POST['dest'] == 'csv') {
$r->csv($stmt);
}
}
}
}
}
}
$page = new MyPage('Panels Report', true, 'panels-view');
$page->go();
