public static function GetDB() { if (!self::$_db) { $creds = self::GetDBCreds(); self::$_db = new PDO("mysql:host=" . $creds["DB_HOST"] . ";dbname=" . self::_DATABASE, $creds["DB_USER"], $creds["DB_PASS"], array(PDO::ATTR_TIMEOUT, 1)); } return self::$_db; }
public static function GenerateStats(PerformanceMetric $pm, $criteria = null) { $result = $pm->getValues(); $result["ho baby"] = "yeah"; return $result; }
/** * @brief Saves all reports to database. * * ## Overview * This will loop through each report and save it to the database as `PerformanceMetrics` in * the `performance_audit`.`metrics` table. * * @uses PerformanceAuditor->save() * @see PerformanceAuditManager->generateReport(); * * @return {Array} Metrics derived from audit reports' data. * * @author <*****@*****.**> * @date 02/19/2014 */ public function generateReport($criteria) { $caller = get_called_class(); $entries = array(); $results = array(); $db = PerformanceMetric::GetDB(); if ($db) { $query = "SELECT `id` FROM `" . PerformanceMetric::_TABLE . "` WHERE `source` = '" . $caller::ID . "'"; $where = array(); if (is_array($criteria)) { if (isset($criteria["from"])) { $where["`created` >= ?"] = date("Y-m-d H:i:s", strtotime($criteria["from"])); } if (isset($criteria["to"])) { $where["`created` <= ?"] = date("Y-m-d H:i:s", strtotime($criteria["to"])); } if (count($where)) { $query .= " AND " . implode(" AND ", array_keys($where)); } } // error_log("Executing query: " . $query); // error_log("Executing keys: " . implode(",", array_values($where))); $statement = $db->prepare($query); $statement->execute(array_values($where)); $entries = $statement->fetchAll(PDO::FETCH_ASSOC); } else { } foreach ($entries as $entry) { $results[] = new PerformanceMetric($entry["id"]); } return array("total" => count($results), "reports" => $results); }
/** * @brief Increment the account audit counter. * * @uses PerformanceMetricController * @uses PerformanceMetricController->save() * * @return {Null} * * @author <*****@*****.**> * @date 02/19/2014 */ public static function Save($report) { $ah = class_exists("Ontraport") ? Ontraport::GetAccountHandle() : $_SESSION["accountHandle"]; if ($ah) { $report["aid"] = $ah->accountID(); try { $metric = new PerformanceMetric(); $metric->save($report); } catch (Exception $e) { self::Warn("perf_metric_save_exception", array("message" => $e->getMessage(), "code" => $e->getCode(), "report" => $report)); } } else { if (class_exists("Ontraport")) { } } }