<html> <body> <h1>Test Functions</h1> <pre> <?php require_once 'db_functions.php'; echo build_mon_dataset_sql("MON_CRYSTAL_CONSISTENCY_DAT", "task_status = :ts"), "\n"; $data = fetch_mon_dataset_data("MON_CRYSTAL_CONSISTENCY_DAT", 75, "task_status != 0"); echo " data "; var_dump($data); $headers = fetch_mon_dataset_headers("MON_CRYSTAL_CONSISTENCY_DAT"); echo " headers "; var_dump($headers); $t_meta = fetch_table_meta("MON_CRYSTAL_CONSISTENCY_DAT"); echo " table meta "; var_dump($t_meta); $f_meta = fetch_field_meta("MON_CRYSTAL_CONSISTENCY_DAT"); echo " field meta "; var_dump($f_meta); $c_meta = fetch_channel_meta("EB_crystal_number"); echo " channel meta "; var_dump($c_meta); ?> </pre> </body> </html>
function fetch_mon_dataset_headers($table) { global $conn; $headers = array(); $headers['RUN'] = 'Run'; $table_meta = fetch_table_meta($table); $field_meta = fetch_field_meta($table); $chan_meta = fetch_channel_meta($table_meta['LOGIC_ID_NAME']); foreach (array('ID1NAME' => 'ID1', 'ID2NAME' => 'ID2', 'ID3NAME' => 'ID3') as $name => $col) { if ($chan_meta[$name]) { $headers[$col] = $chan_meta[$name]; } } foreach ($field_meta as $field => $meta) { $headers[$field] = $meta['LABEL']; } return $headers; }