Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleMunicipio
-- Inicializa variables
SET @i_estado_id = 0;

-- Obtiene información de Estado
select e.estado_id into @i_estado_id
from estado as e
where e.pais_id = @i_pais_id
and e.estado_clave = 'ASU';

INSERT INTO municipio (estado_id, municipio_clave, municipio, municipio_orden)
SELECT @i_estado_id AS estado_id, 
       'ASU-CAPI' as municipio_clave, 
       'Capital' as municipio, 
       100 as municipio_orden
from municipio
  where municipio_id = 0
        and 'ASU-CAPI' not in
    (select municipio_clave
     from municipio
     where estado_id = @i_estado_id)
  and 'Capital' not in
    (select municipio
     from municipio
     where estado_id = @i_municipioestado_id);


  • Niveles
Code Block
titleNivel
INSERT INTO nivel (pais_id, nivel_clave, nivel, nivel_orden, abreviatura, fecha_actualizacion, persona_rol_id, version)
SELECT @i_pais_id as pais_id,
'001' as nivel_clave,
'Inicial' as nivel,
100 as nivel_orden,
'I' as abreviatura,
now() as fecha_actualizacion,
@i_persona_rol_id as persona_rol_id,
0 as version
from nivel
where nivel_id = 0
and '001' not in (select nivel_clave from nivel where pais_id = @i_pais_id)
and 'Inicial' not in (select nivel from nivel where pais_id = @i_pais_id);

Colocar el persona_rol_id o utilizar variable. De igual forma pais_id.

  • Grados
Code Block
firstlineGrado
-- Inicializa variables
SET @i_nivel_id = 0;

-- Obtiene información de Estado
select n.nivel_id into @i_nivel_id
from nivel as n
where n.pais_id = @i_pais_id
and n.nivel_clave = '001';

INSERT INTO grado (nivel_id, grado_clave, grado, grado_orden, activo, fecha_actualizacion, persona_rol_id, version)
SELECT @i_nivel_id as nivel_id,
'3EI' as grado_clave,
'Pre-Jardín' as grado,
100 as grado_orden,
1 as activo,
now() as fecha_actualizacion,
@i_persona_rol_id as persona_rol_id,
0 as version
from grado
where grado_id = 0
and '3EI' not in (select grado_clave from grado where nivel_id = @i_nivel_id)
and 'Pre-Jardín' not in (select grado from grado where nivel_id = @i_nivel_id);



  • Grupos
  • Turnos

Alta de empresa

...