private static function lookup_preview_harvests() { $mysqli =& $GLOBALS['mysqli_connection']; $GLOBALS['hierarchy_preview_harvest_event'] = array(); $result = $mysqli->query("SELECT r.hierarchy_id, max(he.id) as max FROM resources r JOIN harvest_events he ON (r.id=he.resource_id) GROUP BY r.hierarchy_id"); while ($result && ($row = $result->fetch_assoc())) { $harvest_event = HarvestEvent::find($row['max']); if (!$harvest_event->published_at) { $GLOBALS['hierarchy_preview_harvest_event'][$row['hierarchy_id']] = $row['max']; } } }
public function get_marine_stats() { if (!$this->worms_latest_harvest_event_id) { return false; } $latest_harvest_event = HarvestEvent::find($this->worms_latest_harvest_event_id); $result = $this->mysqli_slave->query("SELECT e.created_at FROM eol_statistics e ORDER BY e.id DESC LIMIT 1"); if ($result && ($row = $result->fetch_assoc())) { $latest_stats = $row['created_at']; } else { return true; } $latest_harvest = $latest_harvest_event->published_at; $date = new \DateTime($latest_harvest); $latest_harvest = $date->format('Y-m-d'); $date = new \DateTime($latest_stats); $latest_stats = $date->format('Y-m-d'); print "\n\n {$latest_stats} -- {$latest_harvest}"; if ($latest_harvest >= $latest_stats) { return true; } else { return false; } // No need to calculate marine stats }