= ".$min_timecode." AND timecode <= ".$max_timecode." LIMIT 1"; $data_arr = getDBData($query, $GLOBALS["nanoos_db"]); if (count($data_arr) > 0) $has_plots = true; return $has_plots; } function getFirstDateAfterDate($year, $month, $day) { $result_timecode = false; $timecode = mktime(0, 0, 0, $month, $day, $year); //echo $year."-".$month."-".$day." -- ".date("Y-m-d", $timecode)."
"; $query = "SELECT timecode FROM npb.npb_1_plots WHERE timecode >= ".$timecode." ORDER BY timecode ASC LIMIT 1"; $data_arr = getDBData($query, $GLOBALS["nanoos_db"]); if (count($data_arr) > 0) $result_timecode = $data_arr[0]["timecode"]; return $result_timecode; } ?> 0)? $data_arr[0]["timecode"]: time(); $end_date = date("Ymd", $end_timestamp); //"20120806"; $end_year = substr($end_date, 0, 4); $end_month = substr($end_date, 4, 2); $end_day = substr($end_date, 6, 2); $query = "SELECT timecode FROM npb.npb_1_plots ORDER BY timecode ASC LIMIT 1"; //get first timecode $data_arr = getDBData($query, $GLOBALS["nanoos_db"]); //$start_date = ($param_arr["start_date"])? $param_arr["start_date"]: $end_date; $start_timestamp = (count($data_arr) > 0)? $data_arr[0]["timecode"]: $end_timestamp; $start_date = date("Ymd", $start_timestamp); $start_year = substr($start_date, 0, 4); $start_month = substr($start_date, 4, 2); $start_day = substr($start_date, 6, 2); $selected_datecode = (!empty($_GET["datecode"]))? $_GET["datecode"]: null; //IS $_GET["datecode"] VALID FORMAT??? - IF NOT, SET TO $end_date $selected_date = ""; $selected_hour = ""; $show_most_recent = (empty($selected_datecode))? true: false; if (strlen($selected_datecode) > 8) { list($selected_date, $selected_hour) = explode("-", $selected_datecode); } else { $selected_date = $selected_datecode; } if (empty($selected_date)) $selected_date = $end_date; if ($selected_date < $start_date) $selected_date = $start_date; if ($selected_date > $end_date) $selected_date = $end_date; $selected_year = substr($selected_date, 0, 4); $selected_month = substr($selected_date, 4, 2); if ($selected_month == "00") { $next_timecode = getFirstDateAfterDate($selected_year, 1, 1); $selected_month = date("m", $next_timecode); } $selected_day = substr($selected_date, 6, 2); if ($selected_day == "00") { $next_timecode = getFirstDateAfterDate($selected_year, $selected_month, 1); $selected_day = date("d", $next_timecode); } ?>
": ""; $pre = ($i == $selected_year)? "": ""; $post = ""; echo $td_pre.$pre.$i.$post.$td_post; } ?>
"; $td_post = "
": ""; $pre = "

"; $post = "

"; if ($this_YYYYMM >= $start_YYYYMM && $this_YYYYMM <= $end_YYYYMM) { if (rangeHasPlots($selected_year, $this_MM, 1, $selected_year, $this_MM, numDaysInMonthYear($this_MM, $selected_year))) { $pre = ($i == $selected_month)? "": ""; $post = ""; } } echo $td_pre.$pre.monthIntToString($i, "shortstring").$post.$td_post; } ?>
"; $td_post = "
": ""; $pre = "

"; $post = "

"; if ($this_YYYYMMDD >= $start_YYYYMMDD && $this_YYYYMMDD <= $end_YYYYMMDD) { if (rangeHasPlots($selected_year, $selected_month, $i, $selected_year, $selected_month, $i)) { $pre = ($i == $selected_day)? "": ""; $post = ""; } } echo $td_pre.$pre.$i.$post.$td_post; } ?>
"; $td_post = "
= ".$min_timecode." AND timecode <= ".$max_timecode." GROUP BY timecode ORDER BY timecode"; //get first timecode $data_arr = getDBData($query, $GLOBALS["nanoos_db"]); foreach ($data_arr as $data) { $hours_arr[] = date("Hi", $data["timecode"]); } if (count($hours_arr) == 0) { echo ""; } else { for ($i = 0; $i < count($hours_arr); $i++) { $td_pre = ($i == count($hours_arr) - 1)? ""; $hour = $hours_arr[$i]; $hilite_hour = false; if ($show_most_recent) { if ($i == (count($hours_arr) - 1)) $hilite_hour = true; } else { if ($hour == $selected_hour || (empty($selected_hour) && $i == 0)) $hilite_hour = true; } if ($hilite_hour) { $selected_hour = $hour; $a_pre = ""; } else { $a_pre = ""; } $a_post = ""; echo $td_pre.$a_pre.substr($hour, 0, 2).":".substr($hour, 2, 2).$a_post.$td_post; } } ?>

No Data Available for the Selected Date

": ""; $td_post = "
\n"; $counter = 0; for ($i = 0; $i < $NUM_ROWS; $i++) { $html .= " \n"; for ($k = 0; $k < $NUM_COLUMNS; $k++) { if ($counter < count($variable_arr)) { $url = (isset($plot_arr[$variable_arr[$counter]]))? $plot_arr[$variable_arr[$counter]]: false; //if ($url && urlExists($url)) { if ($url) { $html .= ""; } else { $html .= ""; } } else { $html .= ""; } if ($k < $NUM_COLUMNS - 1) $html .= " \n"; $counter++; } $html .= " \n"; } $html .= " \n"; echo $html; } ?>