$days = 30; } for ($i = 0; $i < $days; $i++) { $today = time() - $i * 24 * 60 * 60; $date = date("Y-m-d", $today); $occ = $doc->createElement('content'); $occ = $root->appendChild($occ); addNode($doc, $occ, 'date', $date); addNode($doc, $occ, 'datestring', date("l, F j, Y", $today)); $signals = array(); if ($i == 0) { getAlerts(&$signals); } // getSignals( &$signals, $date ); getBuys(&$signals, $date); getSells(&$signals, $date); foreach ($signals as $detail) { $det = $doc->createElement('detail'); $det = $occ->appendChild($det); addNode($doc, $det, 'signal', $detail); } } echo $doc->saveXML(); // --------- Functions ------------------------- function getAlerts($signals) { // System Alert - GM 47% Price Change // System Alert - GM is in multiple funds $sql = "select symbol, price, day10, ( 100 * (price - day10) / price) gain from stocks where enabled = 'Y' and ( ( 100 * (price - day10) / price) > 35 or ( 100 * (price - day10) / price) < -35 )"; $rows = mysql_query($sql); while ($cols = mysql_fetch_array($rows)) {
} break; case '4': $date = $_GET[d]; if (getSignals($date) == false) { $rc = '4'; $message = "Error getting signals."; break; } cleanSignals(); if (getBuys($date) == false) { $rc = '4'; $message = "Error getting buys."; break; } if (getSells($date) == false) { $rc = '4'; $message = "Error getting sells."; break; } break; } $result = $doc->createElement('result'); $result = $root->appendChild($result); addNode($doc, $result, 'code', $rc); addNode($doc, $result, 'message', $message); echo $doc->saveXML(); // ------------------ Functions ----------------------------------------------------------------- function cleanSignals() { $sql = "select stock, count(*) from signals group by stock having count(*) > 3";