public function obtenerElemento($idElemento)
{
$elemento = "";
if (isset($idElemento)) {
$conector = new DatabaseConectorStat();
$conexion = $conector->openConexion();
$query = "SELECT * FROM elemento_control where id={$idElemento}";
$resultado = $conector->executeQueryDefine($query, $conexion);
$filas = pg_fetch_all($resultado);
$conector->closeConexionDef($conexion);
$sizeElement = sizeof($filas);
$tipo = $filas[0]["tipo"];
$contenido = $filas[0]["contenido"];
//$referencia=$filas["referencia"];
switch ($tipo) {
case 1:
$elemento = "<div class='redips-drag blue moved' id='blue' name='blue'></div>";
break;
case 2:
$elemento = "<div class='white redips-drag moved' id='whitec' name='white'{$num} style='border-style: none; cursor: move;'>{$contenido}</div>";
break;
case 3:
$elemento = "<div class='yellow redips-drag moved' id='yellow' name='yellow' style='border-style: none; cursor: move;'>{$contenido}</div>";
break;
case 4:
$elemento = "<div class='redips-drag red moved' id='red' name='red' height='40px' width='40px'>{$contenido}</div>";
break;
case 5:
$elemento = "<div class='redips-drag birthday moved' id='birthdayc'{$num} name='birthday'{$num} style='border-style: none; cursor: move;'>" . "<img src='../../../static/images/admin/birthday.jpg' alt='' height='40px' width='40px'>" . "</div>";
break;
case 6:
$elemento = "<div class=' redips-drag food moved' id='foodc'{$num} name='food'{$num} style='border-style: none; cursor: move;'>" . "<img src='../../../static/images/admin/comida.jpg' alt='' height='40px' width='40px'>" . "</div>";
break;
default:
# code...
break;
}
}
return $elemento;
}
function checarElemento($elemento, $num)
{
$result = "";
if (isset($elemento) || !is_null($elemento)) {
$conector = new DatabaseConectorStat();
$conexion = $conector->openConexion();
$query = "SELECT * FROM elemento_control where id={$elemento} ";
$resultado = $conector->executeQueryDefine($query, $conexion);
$filas = pg_fetch_all($resultado);
$conector->closeConexionDef($conexion);
$tipo = $filas[0]["tipo"];
$contenido = $filas[0]["contenido"];
$referencia = $filas[0]["referencia"];
switch ($tipo) {
case 1:
$result = "<div class='blue' id='bluec'{$num} name='blue'{$num} style='border-style: none; cursor: move;'>{$contenido}</div>";
break;
case 2:
$result = "<div class='white' id='whitec'{$num} name='white'{$num} style='border-style: none; cursor: move;'>{$contenido}</div>";
break;
case 3:
$result = "<div class='yellow' id='yellow'{$num} name='yellow'{$num} style='border-style: none; cursor: move;'>{$contenido}</div>";
break;
case 4:
$result = "<div class='redips-drag redips-clone red' id='red' name='red' height='40px' width='40px'>{$contenido}</div>";
break;
case 5:
$result = "<div class='birthday' id='birthdayc'{$num} name='birthday'{$num} style='border-style: none; cursor: move;'>" . "<img src='../../../static/images/admin/birthday.jpg' alt='' height='40px' width='40px'>" . "</div>";
break;
case 6:
$result = "<div class='food' id='foodc'{$num} name='food'{$num} style='border-style: none; cursor: move;'>" . "<img src='../../../static/images/admin/comida.jpg' alt='' height='40px' width='40px'>" . "</div>";
break;
default:
break;
}
return $result;
} else {
return $result;
}
}
<?php include "../../admin/model/DatabaseConectorStatic.php"; include "../controller/GestorTablero.php"; $conector = new DatabaseConectorStat(); $conexion = $conector->openConexion(); $query = "SELECT * FROM tablero_control ORDER BY tecnico,status ASC"; $resultado = $conector->executeQueryDefine($query, $conexion); $filas = pg_fetch_all($resultado); $conector->closeConexionDef($conexion); $sizeElement = sizeof($filas); ?> <html> <head> <script src="../../../static/javascript/jquery-1.11.3.min.js"></script> <script src="../../../static/javascript/admin/gestor_tablero.js"></script> <link rel="stylesheet" href="../../../static/css/bootstrap/css/bootstrap.min.css"> <link rel="stylesheet" href="../../../static/css/bootstrap/css/bootstrap-theme.min.css"> <!-- Latest compiled and minified JavaScript --> <script src="../../../static/css/bootstrap/js/bootstrap.min.js"></script> <link rel="stylesheet" href="../../../static/css/style.css" type="text/css" media="screen"/> <script type="text/javascript"> var redipsURL = '../../../static/javascript/drag-and-drop-table-row/'; </script> <script type="text/javascript" src="../../../static/javascript/redips-drag-min.js"></script>
