Design, tech, engineering and science. Head of Design and User Research.
currentUser = entries[currentUserId]
currentUserLanguages = currentUser ? languagesByUserId[currentUser.sys.id] || [] : []
currentUserOrgs = currentUser ? orgsByUserId[currentUser.sys.id] || [] : []
currentUserBookings = _.uniqBy(
[...currentUserOrgMemberBookings, ...currentUserParticipantBookings],
"sys.id"
)
currentUserOrgMemberBookings = currentUser ? bookingsByOrgUserId[currentUser.sys.id] || [] : []
currentUserParticipantBookings = currentUser ? bookingsByParticipantUserId[currentUser.sys.id] || [] : []
currentOrg = orgsBySlug[currentOrgSlug]
currentOrgBookings = currentOrg ? bookingsByOrgId[currentOrg.sys.id] || [] : []
currentOrgBookingTypes = currentOrg ? bookingTypesByOrgId[currentOrg.sys.id] || [] : []
currentOrgUsers = currentOrg ? usersByOrgId[currentOrg.sys.id] || [] : []
currentBookingType = currentOrgBookingTypes[currentBookingTypeIndex]
currentBookingTypePool = getParticipantPool(currentBookingType)
currentBooking = currentOrgBookings[currentBookingIndex]
currentBooking ? get(currentBooking.fields.bookingType) : undefined
currentBookingLanguages = currentBooking ? languagesByBookingId[currentBooking.sys.id] || [] : []
currentBookingParticipants = currentBooking ? participantsByBookingId[currentBooking.sys.id] || [] : []
currentBookingOrgUsers = currentBooking ? orgUsersByBookingId[currentBooking.sys.id] || [] : []
bookingsByOrgId = _.groupBy(bookings, (booking) => {
return booking.fields.org.sys.id
})
bookingsByBookingTypeId = _.groupBy(bookings, (booking) => {
return booking.fields.bookingType.sys.id
})
bookingsByOrgUserId = groupByMultiple(bookings, (booking) => {
return _.map(booking.fields.orgUsers, 'sys.id')
})
bookingsByParticipantUserId = groupByMultiple(bookings, (booking) => {
return _.map(booking.fields.participants, 'sys.id')
})
bookingTypesByOrgId = _.groupBy(bookingTypes, (bookingType) => {
return bookingType.fields.org.sys.id
})
languagesBySlug = _.keyBy(languages, 'fields.slug')
languagesByUserId = _.mapValues(_.keyBy(users, 'sys.id'), (user) => {
return get(user.fields.languages)
})
languagesByBookingId = _.mapValues(_.keyBy(bookings, "sys.id"), (booking) => {
return getSharedLanguages([...booking.fields.orgUsers, ...booking.fields.participants]);
})
orgsBySlug = _.keyBy(orgs, 'fields.slug')
platformsByUserId = _.mapValues(_.keyBy(users, 'sys.id'), (user) => {
return get(user.fields.platforms)
})
targetGroupsByUserId = _.mapValues(_.keyBy(users, 'sys.id'), (user) => {
return get(user.fields.targetGroups)
})
participantsByBookingId = _.mapValues(_.keyBy(bookings, 'sys.id'), (booking) => {
return get(booking.fields.participants)
})
orgUsersByBookingId = _.mapValues(_.keyBy(bookings, 'sys.id'), (booking) => {
return get(booking.fields.orgUsers)
})
usersByEmail = _.keyBy(users, 'fields.email')
usersByOrgId = _.mapValues(_.keyBy(orgs, 'sys.id'), (org) => {
return get(org.fields.users) || []
})
bookings = _.orderBy(entriesByType.booking || [], 'fields.scheduledFor')
bookingTypes = entriesByType.bookingType || []
languages = _.orderBy(entriesByType.language || [], 'fields.slug')
orgs = _.orderBy(entriesByType.org || [], 'fields.name')
platforms = entriesByType.platform || []
targetGroups = entriesByType.targetGroup || []
users = _.orderBy(entriesByType.user || [], 'fields.email')
function getParticipantPool(bookingType) {
// Filter out users who...
if (bookingType) {
return _.filter(users, (user) => {
// 1. Are in the same organisation
if (
user.fields.orgs &&
user.fields.orgs.length &&
_.find(user.fields.orgs, ["sys.id", bookingType.fields.org.sys.id])
) {
return false;
}
// 2. Are not on accepted platforms (if platforms have been set for booking type)
if (bookingType.fields.platforms && bookingType.fields.platforms.length) {
if (
_.intersectionBy(
bookingType.fields.platforms,
user.fields.platforms,
"sys.id"
).length
) {
return false;
}
}
// 3. Are not in at least one target group
if (
bookingType.fields.targetGroups &&
bookingType.fields.targetGroups.length
) {
if (
_.intersectionBy(
bookingType.fields.targetGroups,
user.fields.targetGroups,
"sys.id"
).length
) {
return false;
}
}
// 4. Already have bookings in the booking type
if (
_.find(bookingsByBookingTypeId[bookingType.sys.id], (booking) => {
return _.find(booking.fields.participants, ["sys.id", user.sys.id]);
})
) {
return false;
}
// 5. Do not share any language with required org users
if (
bookingType.fields.orgUsersRequired &&
bookingType.fields.orgUsersRequired.length &&
!getSharedLanguages(...bookingType.fields.orgUsersRequired, user).length
) {
return false;
}
return true;
});
}
return [];
}
function simplify(...args) {
const items = _.flattenDeep(args);
const simplified = items.map((obj) => {
if (obj) {
const f = _.mapValues(obj.fields, (value) => {
if (
_.isArray(value) &&
value.length &&
value[0] &&
value[0].sys &&
value[0].sys.id
) {
return _.map(value, "sys.id");
}
return value;
});
return {
...f,
...obj.sys,
contentType: obj.sys.contentType.sys.id,
environment: obj.sys.contentType.sys.id,
space: obj.sys.space.sys.id,
...(obj.metadata || {})
};
}
return {};
});
if (args.length === 1 && !_.isArray(args[0])) {
return simplified[0];
}
return simplified;
}
fetchEntries(...contentTypes)
fetchUserByEmail('jerryjappinen@lateralnord.com')
async function fetchUserByEmail (email) {
return fetchEntries({
content_type: 'user',
'fields.email': email
})
}
async function fetchOrgBySlug (slug) {
const ids = await fetchEntries({
content_type: 'org',
'fields.slug': slug
})
// Fetch content also, but don't wait
fetchOrgContent(ids[0])
return ids
}
fetchOrgContent('2gRTFFLiXGN6gkvi5jE5DR')
async function fetchOrgContent(orgId) {
return fetchEntries(
{
content_type: "booking",
"fields.org.sys.contentType.sys.id": "org",
"fields.org.sys.id": orgId
},
{
content_type: "bookingType",
"fields.org.sys.contentType.sys.id": "org",
"fields.org.sys.id": orgId
}
);
}
contentTypes = [
"booking",
"bookingType",
"language",
"org",
"platform",
"targetGroup",
"user"
]
tableData = simplify(entriesByType[tableDataType] || [])
entriesByType
import { formatKey } from "@jerryjappinen/ui"
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
