OrganizationsForMembersAttendingEventsViewHandler: Handler
| Item | Value |
|---|---|
| Briefly | Brief description missing. |
| Definition Path | ImprovingApp.OrganizationsForMembersAttendingEventsProjections.OrganizationsForMembersAttendingEventsView.OrganizationsForMembersAttendingEventsViewHandler |
| View Source Link | organizationsForMembersAttendingEventsProjection.riddl(18:13) |
\n"create row in org table with orgId set to OrganizationEstablished.info.orgId""set row's attendingMemberOrgName to OrganizationEstablished.info.name"\n
\n"remove row from table"\n
\n"create rows in member table with attendingMember set to MemberRegistered.id""set previous row's attendingMemberName to concatenated MemberRegistered.info.firstName and MemberRegistered.info.lastName""create row in org-member table with attendingMemberOrgId set to MemberRegistered.info.organizationMembership.head""set attendingMemberId to MemberRegistered.memberId"\n
\n"create row in event table with event id set to to EventScheduled.eventId""set event_name to EventScheduled.info.eventName"\n
\n"if product is ticket, create row in ticket-event table with sku as ticketSku & productDetails.eventId as event"\n
\n"update row in ticket-event table with the Active status"\n
\n"update row in ticket-event table with the Inactive status"\n
\n"remove row in ticket-event table"\n
\n"for each OrderCreated.orderInfo.lineItem that has a SKU in event-ticket table, create row in ticket-member table with OrderCreated.meta.memberId as attendingMember & sku as ticketSku"\n
\n"create row in ticket-member table with ticketSku set to LineItemOrdered.productId""set attendingMemberId to LineItemOrdered.forMemberId""set orderId to LineItemOrdered.orderId"\n
\n"remove row in ticket-member table"\n
\n"left join event table filtered by FindOrgsByMembersForEvents.events to ticket-event table""left join table found in previous operation to ticket-member, org-member, org, member tables""return OrgsByMembersForEvents containing results in the form of events keyed by members keyed by orgs"\n