Feature #1574: Task 13897: Información para calendario - TS Jueces - Seedbury Square - Task Manager

Custom queries

Issues assigned to me
Reported issues
Updated issues
Watched issues

Actions

Copy link

Feature #1574

closed

Task 13897: Información para calendario

Added by Raúl Barroso 4 months ago. Updated 26 days ago.

Status:

OAT: Pass

Priority:

Normal

Assignee:

Jorge Pacheco

Category:

Target version:

OAT - TS | Propuesta | Jun-10-2026

Start date:

04/10/2026

Due date:

% Done:

100%

Estimated time:

150:00 h (Total: 400:00 h)

Description

Se implementará un calendario integral que permita gestionar y visualizar, de forma centralizada, las vistas, reuniones y otros
eventos importantes. Como parte de esta tarea, se configurarán notificaciones a las partes mediante correo electrónico, que
incluirán enlaces para confirmar citaciones y/o puntos importantes, y se habilitará la confirmación desde dichos enlaces

DevOps

Subtasks 3 (0 open — 3 closed)

Feature #1575: Reservación y disponibilidad de salas

OAT: Pass

Jorge Pacheco

04/10/2026

Actions

Feature #1576: Tipos de eventos y monitoreo

OAT: Pass

Jorge Pacheco

04/10/2026

Actions

Feature #1577: Disponibilidad de jueces y sustituciones

OAT: Pass

Jorge Pacheco

04/10/2026

Actions

History
Notes
Property changes

Actions

Copy link

Updated by Raúl Barroso 4 months ago

Subtask #1575 added

Actions

Copy link

Updated by Raúl Barroso 4 months ago

Subtask #1576 added

Actions

Copy link

Updated by Raúl Barroso 4 months ago

Subtask #1577 added

Actions

Copy link

Updated by Estefany Santiago Trinidad 4 months ago

Estimated time set to 150:00 h

Actions

Copy link

Updated by Estefany Santiago Trinidad 4 months ago

Assignee set to Jorge Pacheco
Target version changed from TS | Propuesta | Jun-10-2026 to TS | Propuesta | Jun- 03-2026

Discutir con Edwin y Raul antes de empezar.

Actions

Copy link

Updated by Jorge Pacheco 4 months ago

Status changed from Not Started to In Progress

Actions

Copy link

Updated by Kenneth Williams Garcia 2 months ago

sql
INSERT INTO catalogValues 
(
	catalogValueCode, 
	catalogValueDescription, 
	catalogTypeCode, 
	catalogTypeDescription, 
	dateCreated, 
	isDeleted, 
	isLocked
)
VALUES 
(
	dbo.getNewCatalogValueCode(),
	'Eventos Especiales',
	42,
	'privilegeCategory',
	GETDATE(),
	0,
	1
);

Actions

Copy link

Updated by Kenneth Williams Garcia 2 months ago

INSERT INTO catalogValues 
(
	catalogValueCode, 
	catalogValueDescription, 
	catalogTypeCode, 
	catalogTypeDescription, 
	dateCreated, 
	isDeleted, 
	isLocked
)
VALUES 
(
	dbo.getNewCatalogValueCode(),
	'Eventos Especiales',
	42,
	'privilegeCategory',
	GETDATE(),
	0,
	1
);

Actions

Copy link

Updated by Kenneth Williams Garcia 2 months ago

INSERT INTO [privileges]
(categoryCode, actionCode, privilegeCode, dateCreated)
VALUES
(
	888,
	253,
	125,
	GETDATE()
),
(
	888,
	217,
	126,
	GETDATE()
),
(
	888,
	216,
	127,
	GETDATE()
),
(
	888,
	215,
	128,
	GETDATE()
);

Actions

Copy link

#10

Updated by Estefany Santiago Trinidad 2 months ago

Target version changed from TS | Propuesta | Jun- 03-2026 to TS | Propuesta | Jun-10-2026

Actions

Copy link

#11

Updated by Repo Bot about 2 months ago

Status changed from In Progress to Pending Review

PR ready for review: JPR-Seedbury — Task 13897: Información para calendario → status: Pending Review

Actions

Copy link

#12

Updated by Jorge Pacheco about 2 months ago

-- Add rows in SUMACCatalogValueType

INSERT INTO SUMACCatalogValueType (Code, DescriptionES, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy)
VALUES
(18, 'Patrón de fecha de evento', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(20, 'Frecuencia de fecha de evento', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(24, 'Tribunal', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(25, 'Tipo de Evento', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E')

-- Add rows in SUMACCatalogValue

INSERT INTO SUMACCatalogValue (Code, DescriptionES, CatalogTypeCode, IsLocked, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy)
VALUES
(354, 'Fecha Fija', 18, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(355, 'Enésimo Día Semanal del Mes', 18, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(356, 'Lapso de Días', 18, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(357, 'Diariamente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(358, 'Semanalmente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(359, 'Mensualmente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(360, 'Anualmente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(381, 'Únicamente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(382, 'Tribunal de Primera Instancia', 24, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(383, 'Tribunal de Apelaciones', 24, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(384, 'Tribunal Supremo', 24, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(385, 'Feriado', 25, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
(386, 'Cierre', 25, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E')

-- Add table SUMACCalendarEntryEvents

CREATE TABLE SUMACCalendarEntryEvents (
calendarEntryEventId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
isDeleted BIT DEFAULT 0 NOT NULL,
deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
dateDeleted DATETIME
);

-- Add table SUMACCalendarEntryEventDetails

CREATE TABLE SUMACCalendarEntryEventDetails (
calendarEntryEventDetailsId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
calendarEntryEventId INT FOREIGN KEY REFERENCES SUMACCalendarEntryEvents(calendarEntryEventId),
title VARCHAR(100) NOT NULL,
typeCode INT FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
courtCode INT FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
colorHexCode VARCHAR(9) NOT NULL,
dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
isDeleted BIT DEFAULT 0 NOT NULL,
deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
dateDeleted DATETIME
);

-- Add table SUMACCalendarEntryEventRules

CREATE TABLE SUMACCalendarEntryEventRules(
calendarEntryEventRuleId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
calendarEntryEventId INT NOT NULL FOREIGN KEY REFERENCES SUMACCalendarEntryEvents(calendarEntryEventId),
datePatternTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
repetitionTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
fixedDate DATETIME,
floatingMonth INT,
floatingWeekDay INT,
nthFloatingDayOfMonth INT,
dateRangeStart DATETIME,
dateRangeEnd DATETIME,
ruleDurationStartDate DATETIME NOT NULL ,
ruleDurationEndDate DATETIME,
isWholeDay BIT NOT NULL,
dayStartTime TIME,
dayEndTime TIME,
dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
isDeleted BIT DEFAULT 0 NOT NULL,
deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
dateDeleted DATETIME
);

-- Add table SUMACCalendarEntryEventExceptions

CREATE TABLE SUMACCalendarEntryEventExceptions(
calendarEntryEventExceptionId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
calendarEntryEventId INT NOT NULL FOREIGN KEY REFERENCES SUMACCalendarEntryEvents(calendarEntryEventId),
datePatternTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
repetitionTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
fixedDate DATETIME,
floatingMonth INT,
floatingWeekDay INT,
nthFloatingDayOfMonth INT,
dateRangeStart DATETIME,
dateRangeEnd DATETIME,
exceptionDurationStartDate DATETIME NOT NULL,
exceptionDurationEndDate DATETIME NOT NULL,
isWholeDay BIT NOT NULL,
dayStartTime TIME,
dayEndTime TIME,
dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
isDeleted BIT DEFAULT 0 NOT NULL,
deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
dateDeleted DATETIME
);

Actions

Copy link

#13

Updated by Jorge Pacheco about 2 months ago

-----------------------------------------------------
-- Add rows in SUMACCatalogValueType
-----------------------------------------------------
INSERT INTO SUMACCatalogValueType (Code, DescriptionES, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy)
VALUES 
	(18, 'Patrón de fecha de evento', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(20, 'Frecuencia de fecha de evento', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(24, 'Tribunal', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(25, 'Tipo de Evento', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E')
-------------------------------------------------------
-- Add rows in SUMACCatalogValue
-------------------------------------------------------
 INSERT INTO SUMACCatalogValue (Code, DescriptionES, CatalogTypeCode, IsLocked, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy)
 VALUES 
	(354, 'Fecha Fija', 18, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(355, 'Enésimo Día Semanal del Mes', 18, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(356, 'Lapso de Días', 18, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(357, 'Diariamente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(358, 'Semanalmente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(359, 'Mensualmente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(360, 'Anualmente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(381, 'Únicamente', 20, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(382, 'Tribunal de Primera Instancia', 24, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(383, 'Tribunal de Apelaciones', 24, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(384, 'Tribunal Supremo', 24, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(385, 'Feriado', 25, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E'),
	(386, 'Cierre', 25, 1, GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E')
-------------------------------------------------------
-- Add table SUMACCalendarEntryEvents
-------------------------------------------------------
CREATE TABLE SUMACCalendarEntryEvents (
 	calendarEntryEventId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
 	dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
 	creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
 	isDeleted BIT DEFAULT 0 NOT NULL,
 	deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
 	dateDeleted DATETIME
 );
-------------------------------------------------------
-- Add table SUMACCalendarEntryEventDetails
-------------------------------------------------------
  CREATE TABLE SUMACCalendarEntryEventDetails (
  	calendarEntryEventDetailsId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
  	calendarEntryEventId INT FOREIGN KEY REFERENCES SUMACCalendarEntryEvents(calendarEntryEventId),
  	title VARCHAR(100) NOT NULL,
  	typeCode INT FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
  	courtCode INT FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
  	colorHexCode VARCHAR(9) NOT NULL,
  	dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
  	creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
  	isDeleted BIT DEFAULT 0 NOT NULL,
  	deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
  	dateDeleted DATETIME
  );
-------------------------------------------------------
-- Add table SUMACCalendarEntryEventRules
-------------------------------------------------------
 CREATE TABLE SUMACCalendarEntryEventRules(
 	calendarEntryEventRuleId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
 	calendarEntryEventId INT NOT NULL FOREIGN KEY REFERENCES SUMACCalendarEntryEvents(calendarEntryEventId),
 	datePatternTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
 	repetitionTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
 	fixedDate DATETIME,
 	floatingMonth INT,
 	floatingWeekDay INT,
 	nthFloatingDayOfMonth INT,
 	dateRangeStart DATETIME,
 	dateRangeEnd DATETIME,
 	ruleDurationStartDate DATETIME NOT NULL ,
 	ruleDurationEndDate DATETIME,
 	isWholeDay BIT NOT NULL,
 	dayStartTime TIME,
 	dayEndTime TIME,
 	dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
 	creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
 	isDeleted BIT DEFAULT 0 NOT NULL,
 	deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
 	dateDeleted DATETIME
 );
-------------------------------------------------------
-- Add table SUMACCalendarEntryEventExceptions
-------------------------------------------------------
 CREATE TABLE SUMACCalendarEntryEventExceptions(
 	calendarEntryEventExceptionId INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
 	calendarEntryEventId INT NOT NULL FOREIGN KEY REFERENCES SUMACCalendarEntryEvents(calendarEntryEventId),
 	datePatternTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
 	repetitionTypeCode INT NOT NULL FOREIGN KEY REFERENCES SUMACCatalogValue(Code),
 	fixedDate DATETIME,
 	floatingMonth INT,
 	floatingWeekDay INT,
 	nthFloatingDayOfMonth INT,
 	dateRangeStart DATETIME,
 	dateRangeEnd DATETIME,
 	exceptionDurationStartDate DATETIME NOT NULL,
 	exceptionDurationEndDate DATETIME NOT NULL,
 	isWholeDay BIT NOT NULL,
 	dayStartTime TIME,
 	dayEndTime TIME,
 	dateCreated DATETIME NOT NULL DEFAULT GETDATE(),
 	creatorPersonId INT NOT NULL FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
 	isDeleted BIT DEFAULT 0 NOT NULL,
 	deleterPersonId INT FOREIGN KEY REFERENCES SUMACPersonBase(PersonId),
 	dateDeleted DATETIME
 );