Project

General

Profile

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 salasOAT: PassJorge Pacheco04/10/2026

Actions
Feature #1576: Tipos de eventos y monitoreoOAT: PassJorge Pacheco04/10/2026

Actions
Feature #1577: Disponibilidad de jueces y sustitucionesOAT: PassJorge Pacheco04/10/2026

Actions
Actions
Copy link
 #1

Updated by Raúl Barroso 4 months ago

  • Subtask #1575 added
Actions
Copy link
 #2

Updated by Raúl Barroso 4 months ago

  • Subtask #1576 added
Actions
Copy link
 #3

Updated by Raúl Barroso 4 months ago

  • Subtask #1577 added
Actions
Copy link
 #4

Updated by Estefany Santiago Trinidad 4 months ago

  • Estimated time set to 150:00 h
Actions
Copy link
 #5

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
 #6

Updated by Jorge Pacheco 4 months ago

  • Status changed from Not Started to In Progress
Actions
Copy link
 #7

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
 #8

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
 #9

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
 );
Actions
Copy link
 #14

Updated by Repo Bot about 2 months ago

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

Actions
Copy link
 #15

Updated by Repo Bot about 2 months ago

Changes requested by EBS-SEEDBURY on PR #156

Actions
Copy link
 #16

Updated by Repo Bot about 2 months ago

Changes requested by EBS-SEEDBURY on PR #137

Actions
Copy link
 #17

Updated by Repo Bot about 2 months ago

Changes requested by EBS-SEEDBURY on PR #156

Actions
Copy link
 #18

Updated by Repo Bot about 2 months ago

  • Status changed from Pending Review to Approved

Approved by EBS-SEEDBURY on PR #156 → status: Approved

Actions
Copy link
 #19

Updated by Repo Bot about 2 months ago

Approved by EBS-SEEDBURY on PR #137 → status: Approved

Actions
Copy link
 #20

Updated by Repo Bot about 2 months ago

  • Status changed from Approved to Test Internally

Merged into Development via PR #156 → status: Test Internally

Actions
Copy link
 #21

Updated by Repo Bot about 2 months ago

Merged into Development via PR #137 → status: Test Internally

Actions
Copy link
 #22

Updated by Estefany Santiago Trinidad 26 days ago

  • Status changed from Test Internally to OAT: Pass
Actions
Copy link

Also available in: Atom PDF