mattrguerra.comHouston area
Matt Guerra
  1. 01AI & Automation
  2. 02Photography
  3. 03Design
  4. 04About
  5. 05Notes
  6. 06Contact
Back to the systems

mattrguerra/meridian-ops-boardmainPrivate on GitHub, published here in full

plinth-seed.ts

TypeScript7.8 KB249 lines

apps/dashboard/src/plinth-seed.ts

  1. /**
  2. * Plinth orders for demos and tests: invented, in the shape of the "Order Product
  3. * Detail" report, covering 01 Jul - 07 Aug 2026.
  4. *
  5. * Order level, because that is the report's shape: it carries order-level
  6. * columns, including production_owner and account_owner, and no product
  7. * status.
  8. *
  9. * Deduplication: the export emits one row per product line but carries only order-level
  10. * columns, so a four-item order appears four times with identical values.
  11. * Collapsing is only safe if the duplicates really are byte-identical on every
  12. * field, so that is checked before rows are merged, not assumed.
  13. *
  14. * "--" in the export means unassigned; it is stored as null here.
  15. *
  16. * Static by design. This is seed data for demos and for testing the render path
  17. * without credentials, not a cache. `pnpm dashboard` (no --fixtures) reads live.
  18. *
  19. * Ages are measured against `SEED_EXPORTED_AT`, not against today. `placedAt`
  20. * is frozen, so an age computed from `Date.now()` would grow one day per real
  21. * day: the fixture would get steadily more alarming while nothing changed, and
  22. * the whole queue would eventually flag as "aging", which trains anyone
  23. * reviewing the demo to ignore the flag that matters most. So the clock is
  24. * pinned to the export date, and every age here is fixed.
  25. */
  26. /**
  27. * A date, not a precise instant. Midnight UTC is the conventional encoding for
  28. * "this calendar day" and it is what this means. Display it by slicing the
  29. * date part: running it through localDay() moves it to the day before,
  30. * because midnight UTC is 7 PM the evening before in Chicago. A timezone sweep
  31. * that "fixes" this would make it wrong.
  32. */
  33. export const SEED_EXPORTED_AT = '2026-08-09T00:00:00Z'
  35. export interface SeedOrder {
  36. displayNumber: string
  37. orderId: number | null
  38. orderStatus: string
  39. placedAt: string | null
  40. /** Customer deadline. The one date that makes a queue urgent rather than long. */
  41. inHandDate: string | null
  42. userGroup: string | null
  43. /** Plinth account label, e.g. "Marco-Acct7-Desk". Map via config/plinth-people.ts. */
  44. productionOwner: string | null
  45. accountOwner: string | null
  46. }
  48. export const PLINTH_SEED: SeedOrder[] = [
  49. {
  50. "displayNumber": "MD2639511",
  51. "orderId": 39511,
  52. "orderStatus": "Proof Signed Off",
  53. "placedAt": "2026-07-09T13:09:25",
  54. "inHandDate": "2026-07-21T00:00:00",
  55. "userGroup": "Retail",
  56. "productionOwner": "Marco-Acct7-Desk",
  57. "accountOwner": "Hazel (Desk 2)"
  58. },
  59. {
  60. "displayNumber": "MD2639517",
  61. "orderId": 39517,
  62. "orderStatus": "Design Requested",
  63. "placedAt": "2026-07-10T08:04:52",
  64. "inHandDate": "2026-07-22T00:00:00",
  65. "userGroup": "Retail",
  66. "productionOwner": null,
  67. "accountOwner": null
  68. },
  69. {
  70. "displayNumber": "MD2639541",
  71. "orderId": 39541,
  72. "orderStatus": "Design Requested",
  73. "placedAt": "2026-07-13T16:06:23",
  74. "inHandDate": "2026-07-22T00:00:00",
  75. "userGroup": "Retail",
  76. "productionOwner": "Marco-Acct7-Desk",
  77. "accountOwner": "Hazel (Desk 2)"
  78. },
  79. {
  80. "displayNumber": "MD2639554",
  81. "orderId": 39554,
  82. "orderStatus": "File Check",
  83. "placedAt": "2026-07-14T17:03:58",
  84. "inHandDate": "2026-07-24T00:00:00",
  85. "userGroup": null,
  86. "productionOwner": "Marco-Acct7-Desk",
  87. "accountOwner": "Hazel (Desk 2)"
  88. },
  89. {
  90. "displayNumber": "MD2639578",
  91. "orderId": 39578,
  92. "orderStatus": "Proof Out",
  93. "placedAt": "2026-07-15T16:13:02",
  94. "inHandDate": "2026-08-06T00:00:00",
  95. "userGroup": "Retail",
  96. "productionOwner": "Rafael-Prod-Desk",
  97. "accountOwner": "Hazel (Desk 2)"
  98. },
  99. {
  100. "displayNumber": "MD2639585",
  101. "orderId": 39585,
  102. "orderStatus": "Proof Signed Off",
  103. "placedAt": "2026-07-15T09:27:26",
  104. "inHandDate": "2026-08-04T00:00:00",
  105. "userGroup": "Retail",
  106. "productionOwner": "Rafael-Prod-Desk",
  107. "accountOwner": "Sam-Accounts-Desk"
  108. },
  109. {
  110. "displayNumber": "MD2639595",
  111. "orderId": 39595,
  112. "orderStatus": "File Check",
  113. "placedAt": "2026-07-17T09:15:05",
  114. "inHandDate": "2026-07-31T00:00:00",
  115. "userGroup": "Retail",
  116. "productionOwner": "Marco-Acct7-Desk",
  117. "accountOwner": "Hazel (Desk 2)"
  118. },
  119. {
  120. "displayNumber": "MD2639635",
  121. "orderId": 39635,
  122. "orderStatus": "File Check",
  123. "placedAt": "2026-07-23T16:27:03",
  124. "inHandDate": "2026-07-31T00:00:00",
  125. "userGroup": "Platinum Partner",
  126. "productionOwner": "Marco-Acct7-Desk",
  127. "accountOwner": "Hazel (Desk 2)"
  128. },
  129. {
  130. "displayNumber": "MD2639640",
  131. "orderId": 39640,
  132. "orderStatus": "Proof Signed Off",
  133. "placedAt": "2026-07-23T17:07:14",
  134. "inHandDate": "2026-08-07T00:00:00",
  135. "userGroup": "Retail",
  136. "productionOwner": "Rafael-Prod-Desk",
  137. "accountOwner": "Hazel (Desk 2)"
  138. },
  139. {
  140. "displayNumber": "MD2639645",
  141. "orderId": 39645,
  142. "orderStatus": "Proof Signed Off",
  143. "placedAt": "2026-07-23T17:03:36",
  144. "inHandDate": "2026-08-18T00:00:00",
  145. "userGroup": "Platinum Partner",
  146. "productionOwner": "Marco-Acct7-Desk",
  147. "accountOwner": "Hazel (Desk 2)"
  148. },
  149. {
  150. "displayNumber": "MD2639701",
  151. "orderId": 39701,
  152. "orderStatus": "Proof Signed Off",
  153. "placedAt": "2026-07-30T17:25:03",
  154. "inHandDate": "2026-08-11T00:00:00",
  155. "userGroup": null,
  156. "productionOwner": "Marco-Acct7-Desk",
  157. "accountOwner": "Hazel (Desk 2)"
  158. },
  159. {
  160. "displayNumber": "MD2639718",
  161. "orderId": 39718,
  162. "orderStatus": "Proof Out",
  163. "placedAt": "2026-07-31T11:02:35",
  164. "inHandDate": "2026-08-14T00:00:00",
  165. "userGroup": "Platinum Partner",
  166. "productionOwner": "Rafael-Prod-Desk",
  167. "accountOwner": "Sam-Accounts-Desk"
  168. },
  169. {
  170. "displayNumber": "MD2639738",
  171. "orderId": 39738,
  172. "orderStatus": "Proof Out",
  173. "placedAt": "2026-08-04T10:18:26",
  174. "inHandDate": "2026-08-19T00:00:00",
  175. "userGroup": null,
  176. "productionOwner": "Rafael-Prod-Desk",
  177. "accountOwner": "Sam-Accounts-Desk"
  178. },
  179. {
  180. "displayNumber": "MD2639752",
  181. "orderId": 39752,
  182. "orderStatus": "File Check",
  183. "placedAt": "2026-08-05T10:34:07",
  184. "inHandDate": "2026-08-20T00:00:00",
  185. "userGroup": null,
  186. "productionOwner": "Marco-Acct7-Desk",
  187. "accountOwner": "Hazel (Desk 2)"
  188. },
  189. {
  190. "displayNumber": "MD2639761",
  191. "orderId": 39761,
  192. "orderStatus": "Proof Out",
  193. "placedAt": "2026-08-05T17:19:35",
  194. "inHandDate": "2026-08-14T00:00:00",
  195. "userGroup": "Platinum Partner",
  196. "productionOwner": "Rafael-Prod-Desk",
  197. "accountOwner": "Sam-Accounts-Desk"
  198. },
  199. {
  200. "displayNumber": "MD2639767",
  201. "orderId": 39767,
  202. "orderStatus": "Proof Out",
  203. "placedAt": "2026-08-06T10:06:37",
  204. "inHandDate": "2026-08-18T00:00:00",
  205. "userGroup": "Retail",
  206. "productionOwner": "Rafael-Prod-Desk",
  207. "accountOwner": "Sam-Accounts-Desk"
  208. },
  209. {
  210. "displayNumber": "MD2639770",
  211. "orderId": 39770,
  212. "orderStatus": "Proof Signed Off",
  213. "placedAt": "2026-08-06T17:40:12",
  214. "inHandDate": "2026-08-18T00:00:00",
  215. "userGroup": "Retail",
  216. "productionOwner": "Rafael-Prod-Desk",
  217. "accountOwner": "Sam-Accounts-Desk"
  218. },
  219. {
  220. "displayNumber": "MD2639773",
  221. "orderId": 39773,
  222. "orderStatus": "Proof Out",
  223. "placedAt": "2026-08-06T13:06:35",
  224. "inHandDate": "2026-08-19T00:00:00",
  225. "userGroup": "Platinum Partner",
  226. "productionOwner": "Marco-Acct7-Desk",
  227. "accountOwner": "Hazel (Desk 2)"
  228. },
  229. {
  230. "displayNumber": "MD2639779",
  231. "orderId": 39779,
  232. "orderStatus": "Proof Out",
  233. "placedAt": "2026-08-07T09:36:03",
  234. "inHandDate": "2026-08-20T00:00:00",
  235. "userGroup": "Retail",
  236. "productionOwner": "Rafael-Prod-Desk",
  237. "accountOwner": "Sam-Accounts-Desk"
  238. },
  239. {
  240. "displayNumber": "MD2639780",
  241. "orderId": 39780,
  242. "orderStatus": "Proof Signed Off",
  243. "placedAt": "2026-08-07T17:13:31",
  244. "inHandDate": "2026-08-21T00:00:00",
  245. "userGroup": "Platinum Partner",
  246. "productionOwner": "Marco-Acct7-Desk",
  247. "accountOwner": "Hazel (Desk 2)"
  248. }
  249. ]