68 lines
2.0 KiB
TypeScript
68 lines
2.0 KiB
TypeScript
/**
|
|
* Per-field-most-recent prefill walk.
|
|
*
|
|
* Loads all `Org Engagement Submission` activities for an organization,
|
|
* sorted DESC by activity_date_time. For each field name we care about,
|
|
* walk the list and take the first non-null value found.
|
|
*
|
|
* This closes the v1 prefill gap that Webform CiviCRM cannot express in
|
|
* its admin UI: load latest values per-field across multiple activities,
|
|
* without coupling to update-mode.
|
|
*/
|
|
|
|
import { civi } from "./civicrm";
|
|
import type { FieldConfig } from "@/types/form";
|
|
|
|
interface ActivityRow {
|
|
id: number;
|
|
activity_date_time: string;
|
|
// CiviCRM returns custom fields under their machine names like
|
|
// `custom_42` or `Stage_0_Core.peer_group_participation`.
|
|
[key: string]: unknown;
|
|
}
|
|
|
|
export interface PrefillResult {
|
|
/** Form-side keys → most-recent non-null value. */
|
|
values: Record<string, unknown>;
|
|
/** Number of submission activities walked. */
|
|
activityCount: number;
|
|
}
|
|
|
|
/**
|
|
* Walk Org Engagement Submission activities for the org, returning per-field
|
|
* most-recent values keyed by FieldConfig.name. Only fields with a `civiField`
|
|
* are looked up; transient fields are ignored.
|
|
*/
|
|
export async function loadPrefill(
|
|
orgId: number,
|
|
fields: FieldConfig[],
|
|
activityTypeName = "Org Engagement Submission",
|
|
): Promise<PrefillResult> {
|
|
const civiSelected = fields.filter((f) => f.civiField);
|
|
const select = ["id", "activity_date_time", ...new Set(civiSelected.map((f) => f.civiField!))];
|
|
|
|
const res = await civi<ActivityRow>("Activity", "get", {
|
|
select,
|
|
where: [
|
|
["activity_type_id:name", "=", activityTypeName],
|
|
["target_contact_id", "=", orgId],
|
|
],
|
|
orderBy: { activity_date_time: "DESC" },
|
|
limit: 200,
|
|
});
|
|
const rows = res.values ?? [];
|
|
|
|
const out: Record<string, unknown> = {};
|
|
for (const f of civiSelected) {
|
|
for (const row of rows) {
|
|
const v = row[f.civiField!];
|
|
if (v !== null && v !== undefined && v !== "") {
|
|
out[f.name] = v;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
return { values: out, activityCount: rows.length };
|
|
}
|