Backend - FOIPPA Sections Modal [#3313]

[sumathi-thirumani]

Sections Management: Master Data

• [x] Create migration script
• [x] Create model components
• [x] Create service components
• [x] Create API
• [x] Apply authentication
• [ ] Apply authorization {DOES NOT APPLY}

Annontations - Sections Management: Txn Data

• [x] Create migration script
• [x] Create model components
• [x] Create service components
• [x] Create API (Save annotation with sections)
• [x] Create API (Save sections for annotation)
• [x] Apply authentication
• [ ] Apply authorization {DOES NOT APPLY}

Sections - User Preference Handling

{TO BE WRITTEN}

General

• [x] Unit Testing
• [x] Logging

[sumathi-thirumani]

Use: To get sections at request level. Pattern: GET http://localhost:15500/api/sections/ministryrequest/ API#1 - GET http://localhost:15500/api/sections/ministryrequest/2

Response: [{"id": 1, "section": "s. 12", "description": "Cabinet and local public body confidences", "count": 0, "sortorder": 1}, {"id": 2, "section": "s. 13", "description": "Policy advice or recommendations", "count": 0, "sortorder": 2}, {"id": 3, "section": "s. 14", "description": "Legal advice", "count": 0, "sortorder": 3}, {"id": 4, "section": "s. 15", "description": "Disclosure harmful to law enforcement", "count": 0, "sortorder": 4}, {"id": 5, "section": "s. 16", "description": "Disclosure harmful to intergovernmental relations or negotiations", "count": 0, "sortorder": 5}, {"id": 6, "section": "s. 17", "description": "Disclosure harmful to the financial or economic interests of a public body", "count": 0, "sortorder": 6}, {"id": 7, "section": "s. 18", "description": "Disclosure harmful to the conservation of heritage sites", "count": 0, "sortorder": 7}, {"id": 8, "section": "s. 18.1", "description": "Disclosure harmful to interests of an Indigenous people", "count": 0, "sortorder": 8}, {"id": 9, "section": "s. 19", "description": "Disclosure harmful to individual or public safety", "count": 0, "sortorder": 9}, {"id": 10, "section": "s. 20", "description": "Information that will be published within 60 days", "count": 0, "sortorder": 10}, {"id": 11, "section": "s. 21", "description": "Disclosure harmful to the business interests of a third party", "count": 0, "sortorder": 11}, {"id": 12, "section": "s. 22", "description": "Disclosure harmful to personal privacy", "count": 0, "sortorder": 12}, {"id": 13, "section": "s. 22.1", "description": "Disclosure of information relating to abortion services", "count": 0, "sortorder": 13}, {"id": 14, "section": "s. 3", "description": "Scope of Act", "count": 0, "sortorder": 14}, {"id": 15, "section": "s. 3 - CFCSA s. 24", "description": "Confidentiality of information under CFCSA", "count": 0, "sortorder": 15}, {"id": 16, "section": "s. 3 - CFCSA s. 77(1)", "description": "Identity of a Reporter under CFCSA", "count": 0, "sortorder": 16}, {"id": 17, "section": "s. 3 - CFCSA s. 77(2)(a)", "description": "Jeopardize an investigation under CFCSA", "count": 0, "sortorder": 17}, {"id": 18, "section": "s. 3 - CFCSA s. 77(2)(b)", "description": "Information collected in confidence under CFCSA Investigation", "count": 0, "sortorder": 18}, {"id": 19, "section": "s. 3 - AA s. 73", "description": "Restriction on use and disclosure of certain information, Adoption Act", "count": 0, "sortorder": 19}, {"id": 20, "section": "s. 3 - AGA s. 46", "description": "Reporting abuse or neglect, Adult Guardianship Act", "count": 0, "sortorder": 20}, {"id": 21, "section": "s. 3 - CA s. 63", "description": "General prohibition against disclosure, Coroner's Act", "count": 0, "sortorder": 21}, {"id": 22, "section": "s. 3 - CA s. 64", "description": "Application of FOIPPA, Coroner's Act", "count": 0, "sortorder": 22}, {"id": 23, "section": "s. 3 - FMEA s. 43", "description": "Confidential Information, Family Maintenance Enforcement Act", "count": 0, "sortorder": 23}, {"id": 24, "section": "s. 3 - PA", "description": "Police Act", "count": 0, "sortorder": 24}, {"id": 25, "section": "s. 14",

[sumathi-thirumani]

Use: To save only annotation Pattern: POST http://localhost:15500/api/annotation//// API#2 : POST http://localhost:15500/api/annotation/15/1/0/cdba05ff-70f5-9a39-07b2-956b9cea9651

{"xml":"<?xml version=\"1.0\" encoding=\"UTF-8\" ?><xfdf xmlns=\"http://ns.adobe.com/xfdf/\" xml:space=\"preserve\"><redact page=\"0\" rect=\"72,379.205,531.778,447.279\" color=\"#FF0000\" flags=\"print\" name=\"cdba05ff-70f5-9a39-07b2-956b9cea9651\" title=\"foiedu foiedu\" subject=\"Redact\" date=\"D:20230228065232-08'00'\" interior-color=\"#000000\" width=\"1.5\" creationdate=\"D:20230228065231-08'00'\" coords=\"107.14500000000001,447.2785,531.7780000000005,447.2785,107.14500000000001,434.47450000000003,531.7780000000005,434.47450000000003,72,433.4685,514.2440000000001,433.4685,72,420.66450000000003,514.2440000000001,420.66450000000003,72,419.6486,513.6830000000001,419.6486,72,406.8446,513.6830000000001,406.8446,72,405.8286,523.9240000000004,405.8286,72,393.0246,523.9240000000004,393.0246,72,392.0086,267.75699999999995,392.0086,72,379.2046,267.75699999999995,379.2046\"><trn-custom-data bytes=\"{"trn-annot-preview":"adjustment and have to pay sum of $236. I am left with no choice other than\npaying this. I agreed to pay this. They transferred the call to payment team; but\nafter 3+ hours long conversation; they told again I need to pay $294.xx and the\nperson on the other end was so rude and she is the senior most in authorization. I\ncried because she told its my respo"}\"/>1 0 0 RG /Helvetica 9 Tf"}

Response: { "annotationid": "cdba05ff-70f5-9a39-07b2-956b9cea9651", "message": "Annotation is saved", "status": true }

[sumathi-thirumani]

Use: To save annotation with sections Pattern: POST http://localhost:15500/api/annotation//// POST http://localhost:15500/api/annotation/15/1/0/cdba05ff-70f5-9a39-07b2-956b9cea9651

{"xml":"<?xml version=\"1.0\" encoding=\"UTF-8\" ?><xfdf xmlns=\"http://ns.adobe.com/xfdf/\" xml:space=\"preserve\"><redact page=\"0\" rect=\"72,379.205,531.778,447.279\" color=\"#FF0000\" flags=\"print\" name=\"cdba05ff-70f5-9a39-07b2-956b9cea9651\" title=\"foiedu foiedu\" subject=\"Redact\" date=\"D:20230228065232-08'00'\" interior-color=\"#000000\" width=\"1.5\" creationdate=\"D:20230228065231-08'00'\" coords=\"107.14500000000001,447.2785,531.7780000000005,447.2785,107.14500000000001,434.47450000000003,531.7780000000005,434.47450000000003,72,433.4685,514.2440000000001,433.4685,72,420.66450000000003,514.2440000000001,420.66450000000003,72,419.6486,513.6830000000001,419.6486,72,406.8446,513.6830000000001,406.8446,72,405.8286,523.9240000000004,405.8286,72,393.0246,523.9240000000004,393.0246,72,392.0086,267.75699999999995,392.0086,72,379.2046,267.75699999999995,379.2046\"><trn-custom-data bytes=\"{"trn-annot-preview":"adjustment and have to pay sum of $236. I am left with no choice other than\npaying this. I agreed to pay this. They transferred the call to payment team; but\nafter 3+ hours long conversation; they told again I need to pay $294.xx and the\nperson on the other end was so rude and she is the senior most in authorization. I\ncried because she told its my respo"}\"/>1 0 0 RG /Helvetica 9 Tf", "sections": { "foiministryrequestid":4, "ids": [{"id":1 , "section": "s23" }, {"id":2 , "section": "s24" }], "redactannotation": "cdba05ff-70f5-9a39-07b2-956b9cea9651" }}

Response: { "annotationid": "cdba05ff-70f5-9a39-07b2-956b9cea9651", "message": "Annotation is saved", "status": true }

[sumathi-thirumani]

Use: To update sections only Pattern: POST http://localhost:15500/api/annotation/section/ API#4: POST http://localhost:15500/api/annotation/section/abcedefdj-70f5-9a39-07b2-956b9cea9651 { "foiministryrequestid":4, "ids": [{"id":1 , "section": "s23" }, {"id":2 , "section": "s24" }, {"id":3 , "section": "s25" }], "redactannotation": "cdba05ff-70f5-9a39-07b2-956b9cea9651" }

Response: { "annotationid": "abcedefdj-70f5-9a39-07b2-956b9cea9651", "message": "Annotation Section is saved", "status": true }

[sumathi-thirumani]

Use: Get Annotations Pattern: GET http://localhost:15500/api/annotation// GET http://localhost:15500/api/annotation/15/1

Response: " <?xml version=\"1.0\" encoding=\"UTF-8\" ?> <xfdf xmlns=\"http://ns.adobe.com/xfdf/\" xml:space=\"preserve\">

1 0 0 RG /Helvetica 9 Tf 1 0 0 RG /Helvetica 9 Tf 1 0 0 RG /Helvetica 9 Tf

"

[sumathi-thirumani]

Use: Get Annotation metadata Pattern: GET http://localhost:15500/api/annotation///info API#6: GET http://localhost:15500/api/annotation/15/1/info

Response: [{"annotationname": "67c423d0-ccc7-e1b8-3cc4-50c40d6fda7a"}, {"annotationname": "72b925a2-d068-46dc-0c77-918b33941fcf"}, {"annotationname": "cdba05ff-70f5-9a39-07b2-956b9cea9651", "sections": {"annotationname": "488fbb0c-cf28-e173-4112-0a1665cc657a"}}, {"annotationname": "8da339d5-d2f9-7ec0-411a-f1c5ef4cc951"}, {"annotationname": "6e38bfea-5922-e241-28ff-0472656b57ab"}]

[sumathi-thirumani]

Use: Delete Annotation only Pattern: GET http://localhost:15500/api/annotation/// DELETE http://localhost:15500/api/annotation/15/1/488fbb0c-cf28-e173-4112-0a1665cc657a

Response: { "annotationid": "488fbb0c-cf28-e173-4112-0a1665cc657a", "message": "Annotation deactivated", "status": true }