Home / user-258448

jano's questions

Martin Hope
jano
Asked: 2022-10-25 08:00:28 +0800 CST
  • 0

As they are, I have a list of diseases that is shown in my DropDownList and when selecting it, it is loaded in the textarea, so far without problems; but if I select another disease again, it is replaced in the Textarea and I want the new selected disease to be added, I hope you can help me

$(document).on('change', '#idenfermedad', function (event) {
            $('#diagnos').val($("#idenfermedad option:selected").text());
        });
<div class="form-group col-md-6">
                <label asp-for="diagnostico" class="control-label"></label>                
                @Html.DropDownList("idenfermedad", listaEnfermedad, new { @class = "form form control" })
                <textarea asp-for="diagnostico" class="form-control col-md-12" rows="7" id="diagnos"></textarea>                
</div>

javascript
Martin Hope
jano
Asked: 2022-10-13 17:23:56 +0800 CST
  • 0

I am working in SQL, I have 3 tables as you can see in the image, in the TipoAddressEntidad table I have if it is email or home address, what I require is to show the name (in entity), the email address and the home address.

I have the code separately but I need it to return 4 columns: ID, Name, Address, Email, in a single query. I hope you can understand and help me

select distinct en.Id, en.Nombre, de.Nombre Direccion from Persona.Entidad as en
inner join Persona.DireccionEntidad as de on de.EntidadId=en.Id
where de.TipoDireccionEntidadId=1

select distinct en.Id, en.Nombre, de.Nombre Email from Persona.Entidad as en
inner join Persona.DireccionEntidad as de on de.EntidadId=en.Id
where de.TipoDireccionEntidadId=2

Table Design

sql
Martin Hope
jano
Asked: 2022-10-12 09:04:28 +0800 CST
  • 1

document.addEventListener('DOMContentLoaded', (event) => {
    const inputFecha = document.querySelector("#fechaNac");
    const inputEdad = document.getElementById("edad");

    inputFecha.addEventListener('change', Edad);

    Edad();

    function Edad() {
        var fechaNacimiento = inputFecha.value;
        const fechaActual = new Date();
        const anoActual = parseInt(fechaActual.getFullYear());
        const mesActual = parseInt(fechaActual.getMonth()) + 1;
        const diaActual = parseInt(fechaActual.getDay());
        //01-01-2010  2010-01-01
        const anoNacimiento = parseInt(String(fechaNacimiento).substring(0, 4));
        const mesNacimiento = parseInt(String(fechaNacimiento).substring(5, 7));
        const diaNacimiento = parseInt(String(fechaNacimiento).substring(8, 10));

        let edad = anoActual - anoNacimiento;
        console.log(anoNacimiento);
        if (mesActual < mesNacimiento) {
            edad--;
        } else if (mesActual == mesNacimiento) {
            if (diaActual < diaNacimiento) {
                edad--;
            }
        }
        inputEdad.value = edad;
    }
});
<table class="table">
    <thead class="thead-dark">
        <tr>
            <th hidden>
                @Html.DisplayNameFor(model => model.idEntidad)
            </th>
            <th>
                @Html.DisplayNameFor(model => model.nombre)
            </th>           
            <th>
                @Html.DisplayNameFor(model => model.fechaConsulta)
            </th>
            <th></th>
        </tr>
    </thead>
    <tbody id="tbDatos">
        @foreach (var item in Model)
        {
            <tr>
                <th hidden>
                    @Html.DisplayFor(model => item.idEntidad)
                </th>
                <th>
                    @Html.DisplayFor(model => item.nombre)
                </th>               
                <th>
                    @Html.DisplayFor(model => item.fechaConsulta)
                </th>
                <th>
                    <a class="fa-solid fa-user-doctor fa-2x" aria-hidden="true" asp-controller="Consulta" asp-action="Atencion" asp-route-id="@item.idEntidad"></a>
                </th>
            </tr>
        }
    </tbody>
</table>


<form>
    <div class="form-group row">
        <input asp-for="idEntidad" class="form-control" type="hidden" id="idEntidad"/>
        <input asp-for="fechaNac" class="form-control" id="fechaNac" min="01-01-1930" type="hidden" />
        <div class="col-10">
            <label asp-for="nombre" class="control-label"></label>
            <input asp-for="nombre" class="form-control" id="nombre" readonly />
        </div>
        <div class="col">
            <label asp-for="edad" class="control-label"></label>
            <input asp-for="edad" class="form-control" id="edad" disabled />
        </div>
    </div>
</form>

I have a list, where a list of names are loaded from a database, this list has a button that references the user by id, which takes me to a form loading the user's data, such as name, date of birth and Age should be automatically filled in with the date of birth. In the form, the input where the date of birth and the user's id are loaded are of type hidden and for this reason the age is not calculated. I tested it by removing the hidden from the date of birth input and it calculates the age without problems. I hope now you can understand me

javascript
Martin Hope
jano
Asked: 2022-04-25 12:15:54 +0800 CST
  • 0

I have a problem with a script which should calculate my age when I put the date of birth but I get the error NaN or that it is out of range. I declared age as int and DateNac I put [DataType(DataType.Date)], and the format in which it shows me to place the date is dd-MM-yyyy, I don't know if they could help me find the problem

function Edad() {
  const fechaNacimiento = document.getElementById("fechaNac");
  const edad = document.getElementById("edad");
  const calcularEdad = (fechaNacimiento) => {
    const fechaActual = new Date();
    const anoActual = parseInt(fechaActual.getFullYear());
    const mesActual = parseInt(fechaActual.getMonth()) + 1;
    const diaActual = parseInt(fechaActual.getDay());

    //01-01-2010
    const anoNacimiento = parseInt(String(fechaNacimiento).substring(6, 10));
    const mesNacimiento = parseInt(String(fechaNacimiento).substring(3, 5));
    const diaNacimiento = parseInt(String(fechaNacimiento).substring(0, 2));

    let edad = anoActual - anoNacimiento;
    if (mesActual < mesNacimiento) {
      edad--;
    } else if (mesActual == mesNacimiento) {
      if (diaActual < diaNacimiento) {
        edad--;
      }
    }
    return edad;
  }
  document.getElementById("edad").value = calcularEdad(this.value);
}
<div class="form-group col-md-4 mb-4">
  <label asp-for="fechaNac" class="control-label"></label>
  <input asp-for="fechaNac" class="form-control" id="fechaNac" min="1930-01-01" oninput="Edad()" />
  <span asp-validation-for="fechaNac" class="text-danger"></span>
</div>
<div class="form-group col-md-2 mb-4">
  <label asp-for="edad" class="control-label"></label>
  <input asp-for="edad" class="form-control" id="edad" />
  <span asp-validation-for="edad" class="text-danger"></span>
</div>

javascript
Martin Hope
jano
Asked: 2022-04-18 18:37:57 +0800 CST
  • 0

How are you friends, I have a problem when trying to load a text in an input. I want that when I load the value of the indMasaCorp input in situationIMC, "Low weight" or "Normal weight" should appear. The value of indMasaCorp is filled in automatically when entering the height and weight with the calculateIMC function, that can be done, but it does not load the situationIMC value, the code I have is the following:

 function calcularIMC() {            
            var talla = document.getElementById("txttalla").value;
            var peso = document.getElementById("txtpeso").value;
            var result = peso / (talla * talla);
            if (result == NaN || result == Infinity) {
                document.getElementById("txtimc").value = "";
            } else {
                document.getElementById("txtimc").value = result.toFixed(5);
            }            
        }

        
        function tablaIMC() {
            var imc = document.getElementById("txtimc");
            var situacion = document.getElementById("txtsituacionIMC");                        
            if (imc.value < 18.5) {
                situacion.innerHTML = "Peso Bajo";
            } else {
                situacion.innerHTML = "Peso Normal";
            }
            
        }
<div class="form-row mt-4">
        <div class="col-1 pl-1 mr-4">
            <label asp-for="peso" class="control-label"></label>
            <input asp-for="peso" class="form-control" id="txtpeso" oninput="calcularIMC()" />
            <span asp-validation-for="peso" class="text-danger"></span>
        </div>
        <div class="col-1 pl-1 mr-4">
            <label asp-for="talla" class="control-label"></label>
            <input asp-for="talla" class="form-control" id="txttalla" oninput="calcularIMC()" />
            <span asp-validation-for="talla" class="text-danger"></span>
        </div>
        <div class="col-2 pl-1 mr-4">
            <label asp-for="indMasaCorp" class="control-label"></label>
            <input asp-for="indMasaCorp" class="form-control"  id="txtimc" oninput="tablaIMC()" disabled/>
            <span asp-validation-for="indMasaCorp" class="text-danger"></span>
        </div>
        <div class="col-4 pl-1">
            <label asp-for="situacionIMC" class="control-label"></label>
            <input asp-for="situacionIMC" class="form-control" id="txtsituacionIMC" disabled/>
            <span asp-validation-for="situacionIMC" class="text-danger"></span>
        </div>
    </div>

javascript