255?255:$r)); $g = dechex($g<0?0:($g>255?255:$g)); $b = dechex($b<0?0:($b>255?255:$b)); $color = (strlen($r) < 2?'0':'').$r; $color .= (strlen($g) < 2?'0':'').$g; $color .= (strlen($b) < 2?'0':'').$b; return '#'.$color; } // phpinfo(); // exit; $id_session = session_id(); $_SESSION["id_session"] = $id_session; $_SESSION["hourdif"] = date("Z"); //Extraer GET $seed = rand(100,10000); $dbconn = pg_pconnect("host=localhost port=5432 dbname=pams user=postgres password=vmac_postgres"); if( $dbconn == FALSE ) echo "Sin Conexion a DB"; //Selecccionar Variables Disponibles para el Usuario $sql = "SELECT tornado_variables.variable_name , tornado_variables.web_name , tornado_variables.web_class , tornado_variables.graph_color FROM motor.tornado_variables ORDER BY web_order ASC"; $result = pg_query($sql); if( $result == FALSE ) echo "Falla en la consulta a DB"; $i=0; while ( $row = pg_fetch_array($result) ) { $rows[$i] = trim( $row[ 0 ] ); $rowsweb[$i] = trim( $row[ 1 ] ); $row_class[$i] = trim( $row[ 2 ] ); $color = split( "," , trim( $row[ 3 ] )); $row_gcolor[$i] = rgb2html($color[ 0 ] , $color[ 1 ] , $color[ 2 ] ); $i++; } $_SESSION["variables"] = $rows ; //print_r($row); ///// $num_columnas = ceil( $i/3 ); //Calcular Matriz de Tabla $tablevars = ''; $contweb = 0; for( $i = 0 ; $i < $num_columnas ; $i++ ) { if( $contweb > count( $rowsweb ) ) break; $tablevars .= ''; for( $j=0; $j < 3 ;$j++ ) { if( $contweb < count( $rowsweb ) ) { $webvar = explode( ' ' ,$rowsweb[$contweb]); $nomWebBodega = $webvar[0]; $nomWebVar = substr( $rowsweb[$contweb] , 2 ); $idBodega = '__b'.$rows[$contweb]; $idVar = '__v'.$rows[$contweb]; /*$tablevars .= "$nomWebBodega$nomWebVar "; */ $tablevars .= "$nomWebBodega$nomWebVar "; } else $tablevars .= ' '; $contweb++; } $tablevars .= ''; } //echo $tablevars; $CalendarIni = time() - (24 * 60 * 60 ); $CalendarEnd = time(); ?> MOTOR CORPESCA2 2011