// Make a visual page of HFC database content require "functions.php"; include "header.php"; include 'but_menu.php'; ?> <style type="text/css"> td.default { border:1px solid #dbd7d4; width:20%; padding: 3px; text-align: center;} </style> <?php echo '</head>'; echo '<h5 class="winA">HFC content</h5>'; //echo '<div style="text-align: right;"><span id="but_back_query"><a href="index.php">Back to query form</a></div>'; // Printing global date ranges for each type of feature $tab_id = array("fil" => "Filament", "pro" => "Prominence", "ar" => "Active region", "ch" => "Coronal hole", "sp" => "Sunspot", "t3" => "Type III", "rs" => "Radio source"); //$instru_by_date = get_minmaxdate_by_instrument(); $instru_by_date = get_minmaxdate_for_instrument_code_from_tstat(); //$query = "SELECT * FROM ASSOC_OBSERVATORY_FRC, OBSERVATORY, FRC_INFO WHERE OBSERVATORY_ID=ID_OBSERVATORY AND FRC_INFO_ID=ID_FRC_INFO"; //$instru_by_date = execute_query($query); //print_r($instru_by_date); echo '<div class="ui-widget-content ui-corner-all">'; echo '<p><span class="ui-icon ui-icon-info" style="float: left; margin-right: .3em;"></span>Date range</p>'; echo '<TABLE>' . "\n"; echo "<TR>\n"; echo "<TH>Feature</TH><TH>Observatory/Instrument/Telescop</TH><TH>FRC Code</TH><TH>First date</TH><TH>Last date</TH>\n"; echo "</TR>\n"; foreach ($tab_id as $feat_type => $feat_name) { foreach ($instru_by_date[$feat_type] as $data) { if (strlen($data['TELESCOP'][0])) { $obsname = $data['OBSERVAT'][0] . ' ' . $data['INSTRUME'][0] . ' ' . $data['TELESCOP'][0]; } else { $obsname = $data['OBSERVAT'][0] . ' ' . $data['INSTRUME'][0] . ' ' . $data['WAVEMIN'][0];
function print_feature_sel() { global $minmax_fil_val, $minmax_pro_val, $minmax_ar_val, $minmax_ch_val, $minmax_sp_val, $minmax_t3_val; //$tab_tables1 = array("Filament"=>"FILAMENTS", "Prominence"=>"PROMINENCES"); //$tab_tables2 = array("Active region"=>"ACTIVEREGIONS", "Coronal hole"=>"CORONALHOLES", "Sunspot"=>"SUNSPOTS", "Type III"=>"TYPE_III", /*"Type II"=>"TYPE_II",*/ "Radio source"=>"RADIOSOURCES"); $tab_id = array("fil" => "Filament", "pro" => "Prominence", "ar" => "Active region", "ch" => "Coronal hole", "sp" => "Sunspot", "t3" => "Type III", "rs" => "Radio source"); //$instru_by_date = get_minmaxdate_by_instrument(); $instru_by_date = get_minmaxdate_for_instrument_code_from_tstat(); echo "<TABLE><TR>\n"; echo "<TH>Feature type</TH><TH>Observatory</TH>\n"; echo "</TR>\n"; // for features with pre-processing foreach ($tab_id as $feat_type => $feat_name) { echo "<TR>\n"; echo '<TD NOWRAP class="feat_sel"><input type="checkbox" id="' . $feat_type . '" name="features[]" value="' . $feat_type . '" '; if (isset($_SESSION['par_post']['features']) && in_array($feat_type, $_SESSION['par_post']['features'])) { echo 'checked'; } echo ' /><label for="' . $feat_type . '">' . $feat_name . '</label></TD>'; echo '<TD class="feat_sel">'; echo '<SELECT name="obs_' . $feat_type . '[]" multiple size="2">'; foreach ($instru_by_date[$feat_type] as $data) { echo '<OPTION value="' . $data['ID_OBSERVATORY'][0] . '">' . $data['OBSERVAT'][0] . '/' . $data['INSTRUME'][0] . ' - ' . $data['CODE'][0] . ' ' . $data['MIN_DATE_OBS'][0] . ' ' . $data['MAX_DATE_OBS'][0]; } echo '</SELECT>'; echo '</TD><TD>'; print_ext_criteria_feat($feat_type); /*switch ($feat_type) { case 'fil'; print_ext_criteria_feat('fil', $minmax_fil_val); break; case 'pro'; print_ext_criteria_feat('pro', $minmax_pro_val); break; case 'ar'; print_ext_criteria_feat('ar', $minmax_ar_val); break; case 'ch'; print_ext_criteria_feat('ch', $minmax_ch_val); break; case 'sp'; print_ext_criteria_feat('sp', $minmax_sp_val); break; case 't3'; print_ext_criteria_feat('t3', $minmax_t3_val); break; }*/ echo "</TD></TR>\n"; } echo "</TABLE>\n"; }