$SubFamilia = genArraySubFamilias($IdFamilia); foreach ($SubFamilia as $key => $value) { echo "{$value}={$key}\n"; } break; case "tallas": $IdTallaje = CleanID($_GET["IdTallaje"]); $IdFamilia = CleanID($_GET["IdFamilia"]); $talla = genArrayTallas($IdTallaje, $IdFamilia); foreach ($talla as $key => $value) { echo "{$value}={$key}\n"; } break; case "colores": $idfamilia = CleanID($_GET["IdFamilia"]); $color = genArrayColores($idfamilia); foreach ($color as $key => $value) { echo "{$value}={$key}\n"; } break; case "alias": $idfamilia = CleanID($_GET["IdFamilia"]); $alias = genArrayProductoAlias($idfamilia); foreach ($alias as $key => $value) { echo "{$value}={$key}\n"; } break; case "contenedores": $contenedor = genArrayContenedores(); foreach ($contenedor as $key => $value) { echo "{$value}={$key}\n";
$sql = "SELECT IdColor FROM ges_modelos WHERE IdFamilia='{$idfamilia}' AND Color='{$color}' "; $row = queryrow($sql); if (!$row) { $sql = "SELECT Max(IdColor) as MaxCol FROM ges_modelos"; $xrow = queryrow($sql); $IdIdioma = getSesionDato("IdLenguajeDefecto"); $max = intval($xrow["MaxCol"]) + 1; $color = CleanRealMysql(CleanText($_GET["color"])); $sql = "INSERT INTO ges_modelos \n (IdColor, IdIdioma, Color, IdFamilia) \n VALUES ( '{$max}', '{$IdIdioma}', '{$color}', '{$idfamilia}' )"; query($sql, "Creando nuevo " . $txtModelo); } if ($row) { $max = $row["IdColor"]; } case "color": $familias = genArrayColores($idfamilia); $combo = ""; echo "<groupbox> <caption label='Buscar " . $txtModelo . "'/>"; echo "<vbox>"; echo "<textbox flex='1' id='buscapresentacion' style='text-transform:uppercase;' onkeyup='javascript:BuscarPresentacion(); if (event.which == 13) agnadirDirecto();' onkeypress='return soloAlfaNumerico(event)' />"; echo "<button label='" . _("Nuevo") . "' onkeypress='if (event.which == 13) UsarNuevo()' oncommand='UsarNuevo()'/>"; echo "</vbox>"; echo "</groupbox>"; echo "<groupbox> <caption label='" . $txtModelo . "'/>"; echo "<script>\n"; echo " var fam =new Object();\n"; foreach ($familias as $key => $value) { echo "fam[{$key}] = '{$value}';\n"; } if ($max) { echo "opener.changeNewColor('" . $max . "','" . $color . "');window.close();";