function getData($lastID) { global $db; $SELECT = "SELECT *, UNIX_TIMESTAMP(log_fecha) as timestamp_unix from log"; $SELECT .= " WHERE log_descripcion != 'login' AND log_descripcion != 'logout' "; if ($lastID >= 0) { $SELECT .= " AND log_id > '" . $lastID . "' "; } $SELECT .= " ORDER BY log_id DESC LIMIT 0 , 40 "; $result = $db->get_results($SELECT); if ($result) { $row = 0; array_multisort($result, SORT_ASC, $result); while (isset($result[$row]->log_id)) { $fecha = timestamp_to_fecha($result[$row]->timestamp_unix); echo $result[$row]->log_id . " ---"; echo $result[$row]->log_usuario_login . " ---"; echo $result[$row]->log_descripcion . " ---"; echo $fecha . " ---"; echo $result[$row]->log_tipo . " ---"; // --- is being used to separete the fields in the output $row++; } } }
function ordenes_en_cola() { global $db, $config; echo "<div>Órdenes en cola</div>"; echo "<div><a href=\"http://bolsaphp.sukiweb.net/index.php?ordenes=todas\">Todas las órdenes</a></div>"; echo "<div id=\"datos-ticker\">"; echo "<fieldset><legend>Compras</legend>"; echo "<div class=\"cuatrocolumnas\">"; echo "<div class=\"col4izq\"><strong>Ticker</strong></div>"; echo "<div class=\"col4cen1\"><strong>Acc. / Precio</strong></div>"; echo "<div class=\"col4cen2\"><strong>Usuario</strong></div>"; echo "<div class=\"col4der\"><strong>Fecha</strong></div>"; $SELECT = "SELECT *, UNIX_TIMESTAMP(timestamp) as timestamp_unix FROM ordenes "; $SELECT .= " WHERE intencion='COMPRA' "; if ($_GET["ordenes"] != "todas") { $SELECT .= " AND usuario='" . $_SESSION["usuario"] . "' "; } $SELECT .= " ORDER BY timestamp ASC"; $compra = $db->get_results($SELECT); $row = 0; while (isset($compra[$row]->id)) { $fecha = timestamp_to_fecha($compra[$row]->timestamp_unix); echo "<div class=\"col4izq\"><a href=\"index.php?ticker=" . $compra[$row]->ticker . "\">" . $compra[$row]->ticker . "</a></div>"; echo "<div class=\"col4cen1\">" . $compra[$row]->acciones . " / " . $compra[$row]->valor . " €</div>"; echo "<div class=\"col4cen2\"><a href=\"index.php?usuario=" . $compra[$row]->usuario . "\">" . $compra[$row]->usuario . "</a></div>"; echo "<div class=\"col4der\">" . $fecha . "</div>"; $row++; } echo "</div>"; echo "</fieldset>"; echo "</div>"; echo "<div id=\"datos-ticker-cartera\">"; echo "<fieldset><legend>Ventas</legend>"; echo "<div class=\"cuatrocolumnas\">"; echo "<div class=\"col4izq\"><strong>Ticker</strong></div>"; echo "<div class=\"col4cen1\"><strong>Acc. / Precio</strong></div>"; echo "<div class=\"col4cen2\"><strong>Usuario</strong></div>"; echo "<div class=\"col4der\"><strong>Fecha</strong></div>"; $SELECT = "SELECT *, UNIX_TIMESTAMP(timestamp) as timestamp_unix FROM ordenes "; $SELECT .= " WHERE intencion='VENTA' "; if ($_GET["ordenes"] != "todas") { $SELECT .= " AND usuario='" . $_SESSION["usuario"] . "' "; } $SELECT .= " ORDER BY timestamp ASC"; $venta = $db->get_results($SELECT); $row = 0; while (isset($venta[$row]->id)) { $fecha = timestamp_to_fecha($venta[$row]->timestamp_unix); echo "<div class=\"col4izq\"><a href=\"index.php?ticker=" . $venta[$row]->ticker . "\">" . $venta[$row]->ticker . "</a></div>"; echo "<div class=\"col4cen1\">" . $venta[$row]->acciones . " / " . $venta[$row]->valor . " €</div>"; echo "<div class=\"col4cen2\"><a href=\"index.php?usuario=" . $venta[$row]->usuario . "\">" . $venta[$row]->usuario . "</a></div>"; echo "<div class=\"col4der\">" . $fecha . "</div>"; $row++; } echo "</div>"; echo "</fieldset>"; echo "</div>"; }