Grouper Custom UI example consent to T&C

create or replace
view penn_covid_accept_terms_v as
select
    subject_id as penn_id,
    to_timestamp(value_integer / 1000) as terms_accepted_timestamp
from
    grouper_aval_asn_mship_v gaamv
where
    gaamv.group_id = '3f70d4f1214f40f899cca9d707ddb9df'
    and source_id = 'pennperson'
    and gaamv.attribute_def_name_name = 'penn:isc:ait:apps:covidScheduling:service:attributes:covidAcceptTerms'
    and subject_id is not null
    and value_integer is not null

CREATE TABLE AUTHZADM.penn_covid_accept_terms
(
  penn_id                   VARCHAR2(20 CHAR)   NOT NULL,
  terms_accepted_timestamp  TIMESTAMP(6)        NOT NULL
);
 
ALTER TABLE penn_covid_accept_terms ADD (
  CONSTRAINT penn_covid_accept_terms_PK
  PRIMARY KEY
  (penn_id, terms_accepted_timestamp)
  ENABLE VALIDATE);
 
 
CREATE INDEX AUTHZADM.PENN_COVID_AC_TRM_pkey_idx ON AUTHZADM.PENN_COVID_ACCEPT_TERMS
(PENN_ID);
 
--NOTE: grant to user that SELECTs for snowflake

grouperClient.syncTable.covidTerms.databaseFrom=grouper
grouperClient.syncTable.covidTerms.databaseTo=warehouse
grouperClient.syncTable.covidTerms.tableFrom=penn_covid_accept_terms_v
grouperClient.syncTable.covidTerms.tableTo=penn_covid_accept_terms
grouperClient.syncTable.covidTerms.columns=penn_id, terms_accepted_timestamp
grouperClient.syncTable.covidTerms.primaryKeyColumns=penn_id, terms_accepted_timestamp

otherJob.covidTerms.quartzCron=51 56 10,14,23 * * ?
otherJob.covidTerms.class=edu.internet2.middleware.grouper.app.tableSync.TableSyncOtherJob
otherJob.covidTerms.syncType=fullSyncFull
otherJob.covidTerms.grouperClientTableSyncConfigKey=covidTerms

penn_covid_header = <h1>2020 Fall Semester: Who Must Be Tested</h1><ul><li>Students, faculty, postdoctoral trainees, and staff who are present on campus for at least eight hours every week and whose activities are done in a congregate setting that involves at least 10 people.</li><li>Students, faculty, postdoctoral trainees, and staff who share a residential space with three or more individuals with whom they are not related, including those who live in College Houses.</li><li>All residents including faculty staff and students living in College Housing (CHAS)</li></ul>
 
 
penn_covid_enrollmentLabel = <h1>Consent to Testing</h1>The University of Pennsylvania is asking members of the Penn community to participate in screening testing, which involves diagnostic testing on a periodic basis, even in the absence of symptoms or exposure to COVID-19.<br /><br />COVID-19 diagnostic tests require the collection of an appropriate sample by a healthcare worker through saliva collection, a nasal swab, oral swab, or other recommended collection procedures. There are risks and benefits associated with undergoing a diagnostic test for COVID-19. The swab may cause sneezing and/or watering of the eyes.  There is also the potential for false positive or false negative test results. Participants in screening testing will not incur any costs for the COVID-19 diagnostic tests that are performed. <br /><br />The University of Pennsylvania, Penn Medicine and the Hospital of the University of Pennsylvania may use and share the information gathered in connection with screening testing for the following purposes:<ul><li>To minimize the risk of COVID-19 exposure to the community and direct individuals to appropriate care.</li><li>To facilitate evaluation, additional testing, treatment, and/or follow-up related to COVID-19;</li><li>To identify patterns of infection that may warrant additional public health interventions and/or resources;</li><li>To facilitate disclosure based on participants' documented express consent; or</li><li>As otherwise required or permitted by law.</li></ul>Test results and any other personal information obtained during testing will be maintained securely, with access limited to those with a need to know to respond to the COVID-19 pandemic as described above.  This includes people working in healthcare, as well as employees' supervisors, students' resident advisors and other University officials when necessary for COVID-19 mitigation.  Such information may also be shared with federal, state and/or local public health authorities.<br /><br />Participants in screening testing are responsible for taking action with regards to their test results as directed.  <br /><br />By marking the box below, which is intended to be the equivalent of my signature:<ul><li>I acknowledge that I have read the content of this form in its entirety, that my questions have been answered, and I consent to participate in the University of Pennsylvania's COVID-19 screening testing program;</li><li>I authorize the University of Pennsylvania to conduct collection, testing, and analysis for the purposes of COVID-19 diagnostic testing as described above, and I understand how the results may be used;</li><li>I have been informed about the purpose of the COVID-19 diagnostic test, procedures to be performed, and potential risks and benefits; and</li><li>I understand it is my responsibility to take appropriate action with respect to my test results.</li></ul>
 
penn_covid_enrollmentButtonText = I Agree

# no help link
{"endIfMatches":true,"customUiTextType":"helpLink","index":0,"text":" "}
 
# this is the logo we put in the container
{"endIfMatches":true,"customUiTextType":"logo","index":0,"text":"../../grouperExternal/public/penn/images/pennCares.png"}
 
# header text (who must get tested)
{"endIfMatches":true,"customUiTextType":"header","index":10,"defaultText":true,"text":"${textContainer.text['penn_covid_header']}"}
 
# body text (terms and conditions)
{"endIfMatches":true,"customUiTextType":"enrollmentLabel","index":0,"defaultText":true,"text":"${textContainer.text['penn_covid_enrollmentLabel']}"}
 
# button text
{"endIfMatches":true,"customUiTextType":"enrollButtonText","index":0,"defaultText":true,"text":"${textContainer.text['penn_covid_enrollmentButtonText']}"}
 
# show the button irrespective of membership in group (since if in group they still need to press button).  The unenroll button isnt really used.
{"endIfMatches":true,"customUiTextType":"unenrollButtonShow","index":0,"defaultText":true,"text":"false"}
{"endIfMatches":true,"customUiTextType":"enrollButtonShow","index":0,"defaultText":true,"text":"true"}

{"endIfMatches":true,"customUiTextType":"redirectToUrl","index":0,"text":"https://upenn-covid19-scheduling-accommodate.symplicity.com/","script":"${ cu_joinGroupButtonPressed }"}

{"endIfMatches":true,"customUiTextType":"gshScript","index":0,"text":"${textContainer.text['penn_covid_gsh']}","script":"${ cu_joinGroupButtonPressed }"}
 
 
Externalized text:
 
 
penn_covid_gsh = group.addMember(subject, false);$newline$Membership membership = MembershipFinder.findImmediateMembership(grouperSession, group, subject, true);$newline$membership.getAttributeValueDelegate().addValueTimestamp("penn:isc:ait:apps:covidScheduling:service:attributes:covidAcceptTerms", new java.sql.Timestamp(System.currentTimeMillis()));
 
 
Note, you put $newline$ in between lines so it is in one line in externalized text, so the GSH is actually:
 
 
group.addMember(subject, false);
Membership membership = MembershipFinder.findImmediateMembership(grouperSession, group, subject, true);
membership.getAttributeValueDelegate().addValueTimestamp("penn:isc:ait:apps:covidScheduling:service:attributes:covidAcceptTerms", new java.sql.Timestamp(System.currentTimeMillis()));