All Questions

I have a JavaScript project that consumes an API which sends a specific responseCode and returns the role, according to that role, it is redirected to the page that the user should see, but I need that when placing the URL it does not allow him to see unless logged in, if not logged in, return to login.

if (code == 0) {

    console.log('Usuario existe con rol: ' + rol, ' El mensaje del API fue: ' + message);

    if (rol == 'Administrador') {
        window.location.href = 'support/management/dashboard.html';
    } else {
        window.location.href = 'support/user/home.html?auth=true';
    }
} else {
    console.log('No permisos');

    Swal.fire({
        icon: 'error',
        title: 'Oops...',
        text: 'Usuario y/o Contraseña Incorrecto, verifique.'
    });
}

This would be basic JavaScript logic, and I'd like any page other than index.html not to be accessible unless logged in.

I'm filling a pivot table with an array, but I can't add the delete button in another column of the table

my arrangement

const response =  [
   "elemento1",
   "elemento2"];

So I fill the table

 load("files", function (response) {
    
            var botones = document.getElementsByClassName('eliminaFile');
        
            multipleFileUploadError.style.display = "none";
            var content = "<p>Archivos Cargados: </p>";
        
        
            response.forEach((file, index) => rollCall(file, index));
        
            response.sort();
        
            let table = document.getElementById("tabla");
        //aquí recorro mi arreglo
            for (var i = 0; i < response.length; i++) {

        //aquí lleno la primer columna
                table.innerHTML += "<tr><td><a href='" + response[i] + "' target='_blank'>" response[i]+ "</a></td></tr>";
        
//aqui intento crear la otra columna con el botón eliminar
        // content += "<p>Descargar Archivo : <a href='" + response[i] + "' target='_blank'>" + response[i] + "</a></p>" + "<input class='eliminaFile' type='button' id='" + response[i] + "' value='Eliminar'>";
    
            }
            multipleFileUploadSuccess.innerHTML = content;
            multipleFileUploadSuccess.style.display = "block";
        });

this is the html of the table

<table class="demo">
                <thead>
                    <tr>
                        <th>Archivo</th>
                        <th>Acciones</th>
                    </tr>
                </thead>
                <tbody id="cuerpoTabla">
                </tbody>
            </table>

I want to add the delete button and delete the element that was selected but I can't

I have a problem, I have an array that has certain null values, I would like to change all the null values ​​to 0, I tried with .replace but it didn't work. I appreciate any help.

This is my code, I bring the original array from PHP, I would need to go through the array and replace the null values ​​with 0

    $.ajax({
    url: 'STATS/metas.php',
    type: 'GET',
    dateType: 'text',
    success: function(response){
        console.log(response)
        let metas = JSON.parse(response)
        console.log(metas)
        let cultivo = metas[0].totalCultivado
        let cosecha = metas[0].totalCosechado
        let diferencia = metas[0].diferencia
        let metasChicas = metas[0].metasChicas
        let metasMedianas = metas[0].metasMedianas
        let cultivoKG = metas[0].KGcultivados
        let cultivoATADO = metas[0].ATADOScultivados
        let cultivoUNIDAD = metas[0].UNIDADEScultivadas
        let cosechaKG = metas[0].KGcosechados
        let cosechaATADO = metas[0].ATADOScosechados
        let cosechaUNIDAD = metas[0].UNIDADEScosechadas
        
        $('#m1').html(cultivo)
        $('#kgCultivos').html(cultivoKG + " kg")
        $('#atadoCultivos').html(cultivoATADO + " atados")
        $('#unidadCultivos').html(cultivoUNIDAD + " unidades")
        $('#m2').html(cosecha)
        $('#kgCosechado').html(cosechaKG + " kg")
        $('#atadoCosechado').html(cosechaATADO + " atados")
        $('#unidadCosechado').html(cosechaUNIDAD + " unidades")

    }
})

I have three containers in which I am inserting buttons with different names, I need to obtain the name of each button inserted in each container and that everything is inside an array for example:

Rows container: insert the company btn Columns container: insert the soles btn Values ​​container: insert the date btn

The array should be like this: ['company', 'soles', 'date']

My question is: how can I know the name of each button that I insert in each container, without having to click on the container or the button that I am inserting.

import React, { useState } from "react";
import "../assets/styles/Container.css";
import { ReactSortable } from "react-sortablejs";
import ButtonApp from "./ButtonApp";
import { getData } from "../services/api_aralsoft";

const Container = () => {
  
  const [row, setRow] = useState([]);
  const [column, setColumn] = useState([]);
  const [values, setValues] = useState([]);

  return (
    <>
      <div className="bottomContainer">
        <section className="itemsSelected">
          <div className="containerVertical">
            <div className="containerR">
              Filas
              <ReactSortable list={row} setList={setRow} group="selectedButton">
                {!row
                  ? "Cargando..."
                  : row.map((item, index) => (
                      <button className="btnSelect" key={index}>
                        {item}
                      </button>
                    ))}
              </ReactSortable>
            </div>
          </div>
          <article className="container_col_val">
            <div className="containerHorizontal">
              <div className="containerR">
                Columnas
                <ReactSortable
                  list={column}
                  setList={setColumn}
                  group="selectedButton"
                >
                  {!column
                    ? "Cargando..."
                    : column.map((item, index) => (
                        <button className="btnSelect" key={index}>
                          {item}
                        </button>
                      ))}
                </ReactSortable>
              </div>
            </div>
            <div className="containerHorizontal">
              <div className="containerR">
                Valores
                <ReactSortable
                  list={values}
                  setList={setValues}
                  group="selectedButton"
                >
                  {!values
                    ? "Cargando..."
                    : values.map((item, index) => (
                        <button className="btnSelect" key={index}>
                          {item}
                        </button>
                      ))}
                </ReactSortable>
              </div>
            </div>
          </article>
        </section>
        <section>
          <ButtonApp name="Generar Reporte" />
        </section>
      </div>
    </>
  );
};

export default Container;

I am trying to insert a record with 3 digits, example: if it is the first one that comes out 001 and the consecutive one is 002, when reaching 10! let 010 come out.

in my code what I achieve is that I insert it without the two zeros

declare @Resultado int
SELECT @Resultado = SUBSTRING(MAX(Agente), CHARINDEX('V', MAX(Agente)) + 1, 4) + 1
FROM Agente
WHERE Agente LIKE '%204%'
AND Tipo = 'Agente'

print @Resultado

    insert into Agente
        (Agente, Nombre, Estatus, Conciliar, Nomina, Logico1, Logico2, Equipo)
    values
        ('204V'  + Convert(varchar, @Resultado), 'Lalo Garcia', 'ALTA', 1, 1, 0, 0, 0)
end

I hope you can support me.