Ben requested to merge feat/report-v2-e2664 into master Nov 08, 2023

Ticket(s) / Related Merge Requests

Issue cards: #2664 (closed) minds#4368 (closed)
Front MR: front!2476 (merged)

Summary of Changes

Engine changes for the V2 report system for Tenant networks.

Testing Considerations

URL for testing https://c81e728d9d4c2f636f067f89cc14862c.bens-networks-3.oke.minds.io/api/graphql

General

Calls can only be made on tenant networks.

Creation

Can create a report for NSFW with subreasons.
Can create a report for ILLEGAL with subreasons.
Can create a report for SECURITY with subreasons.
Can create a report for other reasons without subreasons.
Can create multiple reports for the same reason.
Only logged-in users can submit reports.

List of reports

Can get a list of reports.
Only admins can list reports.
The list of reports can be paginated.
Will only return PENDING reports when requested.

Verdicts

Get Reports Query

Query:

query GetReports(
  $first: Int!,
  $after: Int!,
  $status: ReportStatusEnum
) {
  reports(first: $first, after: $after, status: $status) {
    edges {
      node {
      	... on Report {
          tenantId
          reportGuid
          entityUrn
          entityGuid
          reportedByGuid
          moderatedByGuid
          createdTimestamp
          reason
          nsfwSubReason
          illegalSubReason
          securitySubReason
          createdTimestamp
          entityEdge {
            ... on ActivityEdge {
              node {
                legacy
              }
            }
            ... on UserEdge {
              node {
                legacy
              }
            }
            ... on GroupEdge {
	      node {
                legacy
              }
            }
            ... on CommentEdge {
              node {
                legacy
              }
            }
          }
        }
      }
      cursor
    } 
    pageInfo {
      hasNextPage
      startCursor
      endCursor
    }
  }
}

Variables:

{
  "first": 12,
  "after": 0,
  "status": "PENDING"
}

Create Report Query

Query:

mutation CreateNewReport(
  $entityUrn: String!
  $reason: ReportReasonEnum!
  $illegalSubReason: IllegalSubReasonEnum,
  $nsfwSubReason: NsfwSubReasonEnum,
  $securitySubReason: SecuritySubReasonEnum
) {
  createNewReport(
    reportInput: {
      entityUrn: $entityUrn,
      reason: $reason
      securitySubReason: $securitySubReason
    	illegalSubReason: $illegalSubReason
      nsfwSubReason: $nsfwSubReason
    }
  )
}

Variables:

{
    "entityUrn": "urn:comment:1569010495720001546:0:0:0:1569010529857441809",
    "reason": "NSFW",
    "nsfwSubReason": "NUDITY"
}

Provide Verdict

Query:

mutation ProvideVerdict(
  $reportGuid: String!,
  $action: ReportActionEnum!
) {
  provideVerdict(
    verdictInput: {
      reportGuid: $reportGuid,
      action: $action
    }
  )
}

Variables:

{
  "reportGuid": "1569056140593991681",
  "action": "BAN"
}

Deployment Considerations

Make sure to add the table


CREATE TABLE `minds_reports` (
  `tenant_id` int NOT NULL,
  `report_guid` bigint NOT NULL,
  `entity_guid` bigint NOT NULL,
  `entity_urn` varchar(256) NOT NULL,
  `reported_by_guid` bigint NOT NULL,
  `moderated_by_guid` bigint DEFAULT NULL,
  `reason` tinyint NOT NULL,
  `sub_reason` tinyint DEFAULT NULL,
  `status` tinyint NOT NULL,
  `action` tinyint DEFAULT NULL,
  `created_timestamp` timestamp DEFAULT CURRENT_TIMESTAMP,
  `updated_timestamp` timestamp DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`report_guid`),
  INDEX (tenant_id)
);