buildStaffTimecardSummaryParameterDiscovery (staff-timecard-summary.ts)

kitchen-plugin-yot · analytics

YoureOnTime StaffTimeCardSummary Telerik report adapter. Telerik report type: "YoureOnTime.Web.TelerikReports.StaffTimeCardSummary, YoureOnTime.Reports" Sheet name: "StaffTimeCard" (NOT "StaffTimeCardSummary" — the plan placeholder was wrong; confirmed from the captured XLSX fixt

// YoureOnTime StaffTimeCardSummary Telerik report adapter.
//
// Telerik report type:
//   "YoureOnTime.Web.TelerikReports.StaffTimeCardSummary, YoureOnTime.Reports"
//
// Sheet name: "StaffTimeCard" (NOT "StaffTimeCardSummary" — the plan placeholder was wrong;
// confirmed from the captured XLSX fixture in sample-staff-timecard-findings.md).
//
// The workbook is 26 columns wide. Layout repeats for each location → each staff member:
//
//   [location header row]  col[0] = location name, other cols empty
//   [staff name row]       col[0] = '', col[1] = staff name, other cols empty
//   [subheader A row]      col[11] = "Scheduled" (skip)
//   [subheader B row]      empty / merge row (skip)
//   [column header row]    col[0] = "Date" (skip)
//   [shift data rows...]   col[0] matches /^\d{4

... (truncated -- full source via MCP)

See the full source, get the GitHub permalink, and search 40K more like it.

Get a free API key