public static function getEvents()
{
$db = new DBConnection();
$link = $db->connect();
if ($link != null) {
$query = "SELECT event_name,start_date,end_date,start_time FROM event";
$result = $link->query($query);
$result_array = array();
$index = 0;
while ($row = mysqli_fetch_assoc($result)) {
$result_array[$index] = $row;
$index = $index + 1;
}
$db->closeConnection();
return $result_array;
}
$db->closeConnection();
return null;
}
/**
* Metodo para almacenar la informacion de los errores en los querys ejecutados.
*
* @param string $queryOperation
* @param string $result
*/
private static function storeError($queryOperation, $result)
{
if (DBUtil::$STORE_LOGS) {
$idUsuario = "NULL";
$time0 = time();
if (isset($_SESSION["usuario"])) {
$idUsuario = $_SESSION["usuario"]->getId();
}
$query = "INSERT INTO system_log (fecha, query, result, was_error, query_time, id_usuario)" . " VALUES(now(),'" . str_replace("'", "\\'", $queryOperation) . "','" . str_replace("'", "\\'", $result) . "','1'," . (time() - $time0) . "," . $idUsuario . ")";
$dbConObj = new DBConnection();
mysql_query($query, $dbConObj->getConnection());
$dbConObj->closeConnection();
} else {
echo $result;
}
}
public function restore()
{
// we need root database access to re-create tables
$rconn = DBConnection::getRootConnection();
if ($rconn->connect_error) {
throw new Exception("Cannot perform upgrade process: database::dbConnect()");
}
session_start();
unset($_SESSION['progress']);
session_write_close();
// phase 1: retrieve file from http request
$data = $this->retrieveDBFile();
// phase 2: verify received file
if (strpos(substr($data, 0, 25), "-- AgilityContest") === FALSE) {
throw new Exception("Provided file is not an AgilityContest backup file");
}
// phase 3: delete all tables and structures from database
$this->dropAllTables($rconn);
// phase 4: parse sql file and populate tables into database
$this->readIntoDB($rconn, $data);
// phase 5 final tests
DBConnection::closeConnection($rconn);
return "";
}
public static function getMemberDetail($id)
{
$db = new DBConnection();
$link = $db->connect();
if ($link != null) {
$query = "SELECT concat(first_name,\" \",last_name) AS name , gender , email ,mobile FROM member WHERE id ='" . $id . "'";
$result = $link->query($query);
$db->closeConnection();
return $result;
}
$db->closeConnection();
return null;
}
/**
* Metodo para almacenar la informacion de los errores en los querys ejecutados.
*
* @param string $queryOperation
* @param string $result
*/
private static function storeError($queryOperation, $result)
{
if (DBUtil::$storeErrors == true) {
$idUsuario = "NULL";
$time0 = time();
if (isset($_SESSION["usuario"])) {
$idUsuario = $_SESSION["usuario"]->getId();
}
$dbConObj = new DBConnection();
$query = "INSERT INTO system_log (fecha, query, result, was_error, query_time, id_usuario)" . " VALUES(now(),'" . mysql_real_escape_string($queryOperation, $dbConObj->getConnection()) . "','" . mysql_real_escape_string($result, $dbConObj->getConnection()) . "','1'," . (time() - $time0) . "," . $idUsuario . ")";
mysql_query($query, $dbConObj->getConnection());
$dbConObj->closeConnection();
}
}
$query .= "(SELECT vd1.idventa FROM vista_ventas_detalles vd1 WHERE vd1.fecha_venta='" . $_GET["date"] . "' GROUP BY vd1.idventa) vd2 ";
$query .= "WHERE vd.anulado = 0 AND vd.idventa = vd2.idventa ORDER BY vd.idventa, vd.idventa_detalle";
echo "En VentasDAO::calcularTicketGanador -> iniciando '" . $query . "'<br /><br />";
$resultArray = array();
$time0 = time();
$dbConObj = new DBConnection();
echo "Fecha: " . $_GET["date"] . "<br /><br />";
ini_set('memory_limit', '1024M');
try {
$result = mysql_query($query, $dbConObj->getConnectionV2());
if (!mysql_error()) {
while ($r = mysql_fetch_array($result)) {
$resultArray[] = $r;
}
echo "count(resultArray)= " . count($resultArray) . "<br /><br />";
} else {
echo "mysql_error(): " . mysql_error() . "<br /><br />";
}
} catch (Exception $e) {
echo "Error ejecutando consulta en base de datos" . $e . "<br /><br />";
}
$dbConObj->closeConnection();
echo mysql_error() . "<br />";
echo "En VentasDAO::calcularTicketGanador -> ejecutado '" . $query . "<br /><br />";
if (count($result) > 0) {
foreach ($result as $venta) {
print_r($venta);
}
} else {
echo "result esta vacio";
}
