示例#1
0
 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;
 }
示例#2
0
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;
    }
}
示例#3
0
<?php

include "../model/DatabaseConectorStatic.php";
$conector = new DatabaseConectorStat();
$conexion = $conector->openConexion();
$idTecnico = $_REQUEST["id"];
if (isset($idTecnico)) {
    var_dump($_REQUEST);
    $planeado = $_REQUEST["planeado"];
    $trabajando = $_REQUEST["trabajando"];
    //var_dump($id);
    //var_dump($planeado);
    //var_dump($trabajando);
    $query = "UPDATE tablero_control  SET h0800=null, h0830=null, h0900=null, h0930=null," . "h1000=null, h1030=null, h1100=null, h1130=null, h1200=null, h1230=null, h1300=null," . "h1330=null, h1400=null, h1430=null, h1500=null, h1530=null, h1600=null, h1630=null," . "h1700=null, h1730=null, h1800=null, h1830=null, h1900=null, h1930=null, h2000=null," . "lavado=null, control_calidad=null, terminado=null, tot=null, partes=null, " . "aut=null WHERE status=1 OR status=2";
    $resultado = $conector->executeQueryDefine($query, $conexion);
    foreach ($planeado as $plan => $value) {
        if ($value != "-") {
            $tipoElemento = $value["id"];
            $texto = $value["text"];
            echo "{$plan} {$tipoElemento} {$texto} \n ";
            switch ($tipoElemento) {
                case 'blue':
                    $tipoElemento = 1;
                    break;
                case "white":
                    $tipoElemento = 2;
                    break;
                case "yellow":
                    $tipoElemento = 3;
                    break;
                case "red":