protected function action_run() { $stmt = $this->db->query('select * from query where query_id = :query_id', array('query_id' => $_POST['query_id'])); if ($row = $stmt->fetch()) { if (stripos($row['query'], 'file ') === 0) { $this->transfer(substr($row['query'], 5), array('dest' => $_POST['dest'])); } else { $stmt2 = $this->db->query($row['query']); $r = new Report(); if ($_POST['dest'] == 'screen') { $r->html($row['title'], $stmt2); } else { if ($_POST['dest'] == 'pdf') { $r->pdf($row['title'], $stmt2); } else { if ($_POST['dest'] == 'csv') { $r->csv($stmt2); } } } } } else { $this->message('Query not found'); } }
protected function action_report() { $stmt = $this->db->query('select name, count(specialty_id) as count from member join specialty using (specialty_id) group by specialty_id order by name'); if ($stmt->rowCount() == 0) { $this->message('No records found', true); } else { $r = new Report(); if ($_POST['dest'] == 'screen') { $r->html('Speciaties', $stmt); } else { if ($_POST['dest'] == 'pdf') { $r->pdf('Speciaties', $stmt); } } } }
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); } } } } }
protected function run($title, $sql) { echo '<div class=run>'; $stmt = $this->db->query($sql); $r = new Report(); $r->html($title, $stmt); echo '</div>'; }