123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269 |
- truncate table USERS;
- INSERT INTO USERS (ID, USER_NAME, PASSWORD, USER_TYPE, EMAIL, STATUS, ENABLED, FIRST_NAME, LAST_NAME) VALUES (1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'super', 'admin@admin.com', '1', '1', 'tigo', 'admin');
- truncate table NOTIFICATION_TEMPLATE;
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (1, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>¡Bienvenido a TIGO!</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;"><strong>Hola ${(user.firstName)!} ${(user.lastName)!}</strong></p><p style="font-size: 12.8px;">Te damos la más cordial bienvenida, tu usuario fue creado exitosamente.</p>
- <p style="font-size: 12.8px;">Datos de ingreso:</p><ul style="font-size: 12.8px;"><li>User: ${(user.userName)!}</li><li>Email: ${(user.email)!}</li><li>Password: ${(user.password)!}</li></ul>
-
- </div>
- </div>
- </div>
- </div>',
- 'ususario.nuevo', 0, 1, 'Credenciales Acceso TIGO', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (2, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>¡Bienvenido a TIGO!</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;"><strong>Hola ${(provider.name)!} </strong></p><p style="font-size: 12.8px;">Te damos la más cordial bienvenida a la familia de proveedores TIGO.</p><p style="font-size: 12.8px;"></p><p></p><p style="font-size: 12.8px;"> Se Adjunta bienvenida</p>
-
- </div>
- </div>
- </div>
- </div>'
- , 'provider.new', 0, 1, 'Bienvenido a proveedores TIGO', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (3, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Evaluaciones</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Tiene una evaluación para revisión y aprobación
-
- </div>
- </div>
- </div>
- </div>',
- 'new.new', 0, 1, 'Cambio de estado evalucion', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (4, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Evaluaciones</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Tiene una evaluación para revisión y aprobación
-
- </div>
- </div>
- </div>
- </div>'
- , 'gere.new', 0, 1, 'Nueva evaluacion para direccion', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (5, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Evaluaciones</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Tiene una evaluación para revisión y aprobación
-
- </div>
- </div>
- </div>
- </div>',
- 'gere.new', 0, 1, 'Nueva Evalucion ingresada para gerencia', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (6, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Evaluaciones</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Tiene una evaluación <strong>Rechazada</strong> para revisión y aprobación
-
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Nueva evaluacion rechazada para revision', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (7, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Evaluaciones</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Nueva Evaluación <strong>Aprobada</strong>
-
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Nueva Evaluacion APROBADA', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (8, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Evaluaciones</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Nueva Evaluación <strong>Publicada</strong> para visualización.
-
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Evalucion lista para visualizar', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (9, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Recordatorio</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Debe realizar una evaluación asignada del siguiente proveedor: ${(nombre)!}
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Evalucion lista para visualizar', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (10, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Recordatorio</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Debe realizar una evaluación asignada del siguiente proveedor: ${(nombre)!}
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Evalucion lista para visualizar', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (11, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Recordatorio</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Debe realizar una evaluación <strong>vencida</strong> del siguiente proveedor: ${(nombre)!}
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Evalucion lista para visualizar', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (12, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Recordatorio</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Tiene un punto de acción <strong>vencido</strong>: ${(userName)!}
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Recordatorio tiene un punto de accion vencido', 'javamail');
- INSERT INTO NOTIFICATION_TEMPLATE (ID, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, VERSION, BODY, NAME, SCOPE, STATUS, SUBJECT, TYPE) VALUES (13, 'admin', null, 'admin', null, 0,
- '<div style="background-color: rgb(242,243,245);padding: 20.0px;">
- <div style="max-width: 600.0px;margin: 0 auto;">
- <div style="background: rgb(255,255,255);font: 14.0px sans-serif;color: rgb(104,111,122);border-top: 4.0px solid rgb(0,0,128);margin-bottom: 20.0px;">
- <div style="border-bottom: 1.0px solid rgb(242,243,245);padding: 20.0px 30.0px;">
- <p style="margin: 0;color: rgb(51,51,51);">
- <b> <h3>Recordatorio</h3></b>
- </p>
- </div>
- <div style="padding: 20.0px 30.0px;">
- <div style="font-size: 16.0px;line-height: 1.5em;border-bottom: 1.0px solid rgb(242,243,245);padding-bottom: 10.0px;margin-bottom: 20.0px;">
-
- <p style="font-size: 12.8px;">Se ha actualizado un punto de accion: ${(userName)!}
- </div>
- </div>
- </div>
- </div>'
- , 'contract_rej.new', 0, 1, 'Punto de accion modificado por proveedor', 'javamail');
|