[{"_1":2,"_1204":-5,"_1205":-5},"loaderData",{"_3":4,"_93":94,"_925":926},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2f1b7933526c99d174f6c4b9fb9d1854a177ff5c","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":22,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":22,"_92":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":22,"_21":22,"_84":74,"_85":86,"_87":74,"_88":47,"_89":22,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_95":96,"_97":98,"_99":45,"_100":101,"_102":103,"_104":105,"_155":156,"_900":901,"_902":903,"_914":915,"_284":916,"_919":-5,"_920":-5,"_921":22,"_922":22,"_923":924},"handle","trevormunoz","name","lakeland-timesheet","branchName","path",".git/objects/d8","version",126,"project",{"_106":107,"_97":98,"_108":109,"_110":-5,"_111":22,"_112":113,"_114":74,"_115":-5,"_14":116,"_117":-5,"_118":22,"_119":-5,"_120":-5,"_121":33,"_16":122,"_123":-5,"_124":-5,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":134,"_137":138,"_142":143,"_154":22},"id","5c0c02e4-130a-11f1-9411-42dde27851f2","createdAt",["D",1772107064004],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","7ec577df-7957-4760-a4d3-81e05cef3345","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","48ae43c1-9cce-4f57-9abb-f1491d51acfb","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_135":136},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yWm5xQUFoY280MXptMVB2Tk9ad0ptV3gyNWUifQ","org",{"_95":96,"_139":136,"_14":116,"_140":141},"avatar","tier","free","branch",{"_102":144,"_97":45,"_106":145,"_146":107,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},168,"5c0c68ec-130a-11f1-9411-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[157,596,659,693,755,780,834,843,852,862,873,882,891],{"_106":158,"_97":159,"_160":161,"_162":-5,"_163":145,"_164":165,"_166":167,"_108":168,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":175,"_100":595},"56abeb72-132b-11f1-af4c-42dde27851f2",".git","fileId","56abec58-132b-11f1-af4c-42dde27851f2","parentId","branchId","branchVersion",68,"latest",true,["D",1772121228376],"fileType","directory","content","deleted","label","children",[176,184,192,216,556,578,586],{"_106":177,"_97":178,"_160":179,"_162":161,"_163":145,"_164":180,"_166":167,"_108":181,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":182,"_100":183},"570129de-132b-11f1-b6c9-42dde27851f2","hooks","57012ab0-132b-11f1-b6c9-42dde27851f2",73,["D",1772121228932],[],[159,178],{"_106":185,"_97":186,"_160":187,"_162":161,"_163":145,"_164":188,"_166":167,"_108":189,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":190,"_100":191},"56daf994-132b-11f1-8e0b-42dde27851f2","info","56dafa66-132b-11f1-8e0b-42dde27851f2",71,["D",1772121228678],[],[159,186],{"_106":193,"_97":194,"_160":195,"_162":161,"_163":145,"_164":196,"_166":167,"_108":197,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":198,"_100":215},"56f05168-132b-11f1-8b48-42dde27851f2","logs","56f0524e-132b-11f1-8b48-42dde27851f2",72,["D",1772121228821],[199],{"_106":200,"_97":201,"_160":202,"_162":195,"_163":145,"_164":203,"_166":167,"_108":204,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":205,"_100":214},"596f05ce-132b-11f1-954f-42dde27851f2","refs","596f06aa-132b-11f1-954f-42dde27851f2",112,["D",1772121233009],[206],{"_106":207,"_97":208,"_160":209,"_162":202,"_163":145,"_164":210,"_166":167,"_108":211,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":212,"_100":213},"599e7926-132b-11f1-8fb2-42dde27851f2","heads","599e79f8-132b-11f1-8fb2-42dde27851f2",115,["D",1772121233320],[],[159,194,201,208],[159,194,201],[159,194],{"_106":217,"_97":218,"_160":219,"_162":161,"_163":145,"_164":220,"_166":167,"_108":221,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":222,"_100":555},"56c7743c-132b-11f1-8b48-42dde27851f2","objects","56c7750e-132b-11f1-8b48-42dde27851f2",70,["D",1772121228555],[223,231,239,247,255,263,271,289,297,314,322,330,338,346,354,362,370,378,395,403,411,428,436,444,452,460,468,476,484,492,500,508,516,524,532,540,547],{"_106":224,"_97":225,"_160":226,"_162":219,"_163":145,"_164":227,"_166":167,"_108":228,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":229,"_100":230},"582407a0-132b-11f1-b93a-42dde27851f2","00","58240872-132b-11f1-b93a-42dde27851f2",91,["D",1772121230837],[],[159,218,225],{"_106":232,"_97":233,"_160":234,"_162":219,"_163":145,"_164":235,"_166":167,"_108":236,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":237,"_100":238},"576b12a4-132b-11f1-b163-42dde27851f2","0b","576b134e-132b-11f1-b163-42dde27851f2",80,["D",1772121229626],[],[159,218,233],{"_106":240,"_97":241,"_160":242,"_162":219,"_163":145,"_164":243,"_166":167,"_108":244,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":245,"_100":246},"577a4aee-132b-11f1-b6c9-42dde27851f2","0e","577a4bc0-132b-11f1-b6c9-42dde27851f2",81,["D",1772121229726],[],[159,218,241],{"_106":248,"_97":249,"_160":250,"_162":219,"_163":145,"_164":251,"_166":167,"_108":252,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":253,"_100":254},"57e3a6d8-132b-11f1-b93a-42dde27851f2","20","57e3a782-132b-11f1-b93a-42dde27851f2",87,["D",1772121230417],[],[159,218,249],{"_106":256,"_97":257,"_160":258,"_162":219,"_163":145,"_164":259,"_166":167,"_108":260,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":261,"_100":262},"595d7c1e-132b-11f1-b6c9-42dde27851f2","22","595d7cc8-132b-11f1-b6c9-42dde27851f2",111,["D",1772121232893],[],[159,218,257],{"_106":264,"_97":265,"_160":266,"_162":219,"_163":145,"_164":267,"_166":167,"_108":268,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":269,"_100":270},"5924024a-132b-11f1-8e0b-42dde27851f2","2c","59240326-132b-11f1-8e0b-42dde27851f2",107,["D",1772121232516],[],[159,218,265],{"_106":272,"_97":273,"_160":274,"_162":219,"_163":145,"_164":275,"_166":167,"_108":276,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":277,"_100":288},"5951c716-132b-11f1-af4c-42dde27851f2","2e","5951c7c0-132b-11f1-af4c-42dde27851f2",110,["D",1772121232820],[278],{"_106":279,"_97":280,"_160":281,"_162":274,"_163":145,"_164":282,"_166":167,"_108":283,"_102":33,"_169":284,"_171":285,"_172":22,"_173":-5,"_174":286,"_100":287},"59d80286-132b-11f1-ad1d-42dde27851f2","c5d78c8f686dc02b926ad52c78cb0e899f1ab9","59d80362-132b-11f1-ad1d-42dde27851f2",124,["D",1772121233687],"file","x\u0001u�MK�0\u0010�=�W�\u001c��Q��T(�\u0001�MD�t\\�MfBf�\u000b��d��*x��d\u001e��T_\\�\u001f}Vum,��\u000e�}Pd\u0012sU�8\u0003\u001d�\n4�M�؞��9��\u0001�]*��cJ4g��hD[�\u001a\u0013,:�۝p ��7\u001c��\u0007��z�~�@��y !�=�\u0011�q��J(yH�Q�b��\\�n�P�\u001e\u0018d��\u0006��\u001d�z!��,i��Ks��l��9Q1/;\u0002�\u001fB<��8\u0019W��\u000b�0l_",[],[159,218,273,280],[159,218,273],{"_106":290,"_97":291,"_160":292,"_162":219,"_163":145,"_164":293,"_166":167,"_108":294,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":295,"_100":296},"581438b6-132b-11f1-b163-42dde27851f2","2f","5814397e-132b-11f1-b163-42dde27851f2",90,["D",1772121230735],[],[159,218,291],{"_106":298,"_97":299,"_160":300,"_162":219,"_163":145,"_164":301,"_166":167,"_108":302,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":303,"_100":313},"57306f0a-132b-11f1-af4c-42dde27851f2","3e","57306fd2-132b-11f1-af4c-42dde27851f2",76,["D",1772121229245],[304],{"_106":305,"_97":306,"_160":307,"_162":300,"_163":145,"_164":308,"_166":167,"_108":309,"_102":33,"_169":284,"_171":310,"_172":22,"_173":-5,"_174":311,"_100":312},"59d0566c-132b-11f1-b6c9-42dde27851f2","26b701f07d511c4f1a8e160f25e4adcf5c8137","59d0572a-132b-11f1-b6c9-42dde27851f2",123,["D",1772121233612],"x\u0001�U�n�@\u0010圯\u0018�&�\u001bH\u0010��BE�*�\u0004��8l�cw��\r��\u0012��:��\u0010bl\"%��޼��]dv\u0001�ӓ�Ot��a\r\n]Lz�\u0011h\u001f\u0001�Xb��\u0011\u0012�9��8\u001f5�KI\u000e/U��[��Ҩ&v�L��S�8~TÎ�^��`<��\u0017�\u001e\u0001�V\u0011\u000e�R�$��\u0005�@�j��4>j�\b�\n��\u0003�'��vޒF'�&\u0013�\n��W�\u000b�� c��9\u0003�\u0018̇�s&?n%HJ�\u0019|>��\u0005\u001e'�\u001c~�kII\u001a\u000f��Al\u0015B0��\u001c\u0007\u0015�\u0001\u0011ﮮ�o>\u001d�O��Of\u0002�3�\u0010:��\fe�S��ct\u0003k-�YO]�.M��]��۠:C\u0002�\u000f�4F�tX�*��\u0006�D�ܮ\u0010\u0006�l��\u0016��iO�p�\u0019�q_+E\u0019�9�\u0015\\=�Ȳ��\r��#��\u0003]��A\u001e@��-�\u0005��l��W.I�\u000b�)��\u0001aκ�\u0001�\u001fE�%�YBӒ�\u000e�X0��\\5�솧v��\u000f�\f��b�ck\u0012��S�\u0017��n��\u0004fhT��\u0015J�r�s5\u0018�$\u0019N\u001b�\u001aښ��g\t}A�\u0001\u0012Y��!�mj�OT�Ty9��^)\u000b��x��=jRݚKޖO;�H��E�\u0014>\u0012�/<�\u0011�7�\"\b��/��p�o�>�\fq��7��h�",[],[159,218,299,306],[159,218,299],{"_106":315,"_97":316,"_160":317,"_162":219,"_163":145,"_164":318,"_166":167,"_108":319,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":320,"_100":321},"5933f92a-132b-11f1-b163-42dde27851f2","48","5933f9c0-132b-11f1-b163-42dde27851f2",108,["D",1772121232621],[],[159,218,316],{"_106":323,"_97":324,"_160":325,"_162":219,"_163":145,"_164":326,"_166":167,"_108":327,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":328,"_100":329},"573e69e8-132b-11f1-8089-42dde27851f2","50","573e6aba-132b-11f1-8089-42dde27851f2",77,["D",1772121229337],[],[159,218,324],{"_106":331,"_97":332,"_160":333,"_162":219,"_163":145,"_164":334,"_166":167,"_108":335,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":336,"_100":337},"574dd806-132b-11f1-8b48-42dde27851f2","57","574dd8c4-132b-11f1-8b48-42dde27851f2",78,["D",1772121229434],[],[159,218,332],{"_106":339,"_97":340,"_160":341,"_162":219,"_163":145,"_164":342,"_166":167,"_108":343,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":344,"_100":345},"5723ed34-132b-11f1-8089-42dde27851f2","59","5723ee1a-132b-11f1-8089-42dde27851f2",75,["D",1772121229144],[],[159,218,340],{"_106":347,"_97":348,"_160":349,"_162":219,"_163":145,"_164":350,"_166":167,"_108":351,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":352,"_100":353},"58600624-132b-11f1-b93a-42dde27851f2","65","586006e2-132b-11f1-b93a-42dde27851f2",95,["D",1772121231232],[],[159,218,348],{"_106":355,"_97":356,"_160":357,"_162":219,"_163":145,"_164":358,"_166":167,"_108":359,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":360,"_100":361},"58342572-132b-11f1-b163-42dde27851f2","6e","5834263a-132b-11f1-b163-42dde27851f2",92,["D",1772121230945],[],[159,218,356],{"_106":363,"_97":364,"_160":365,"_162":219,"_163":145,"_164":366,"_166":167,"_108":367,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":368,"_100":369},"5804efaa-132b-11f1-8fb2-42dde27851f2","89","5804f086-132b-11f1-8fb2-42dde27851f2",89,["D",1772121230638],[],[159,218,364],{"_106":371,"_97":372,"_160":373,"_162":219,"_163":145,"_164":374,"_166":167,"_108":375,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":376,"_100":377},"5945fc6a-132b-11f1-8089-42dde27851f2","8d","5945fd28-132b-11f1-8089-42dde27851f2",109,["D",1772121232742],[],[159,218,372],{"_106":379,"_97":380,"_160":381,"_162":219,"_163":145,"_164":382,"_166":167,"_108":383,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":384,"_100":394},"58502ff6-132b-11f1-b163-42dde27851f2","91","585030b4-132b-11f1-b163-42dde27851f2",94,["D",1772121231128],[385],{"_106":386,"_97":387,"_160":388,"_162":381,"_163":145,"_164":389,"_166":167,"_108":390,"_102":33,"_169":284,"_171":391,"_172":22,"_173":-5,"_174":392,"_100":393},"59cccbc8-132b-11f1-8b48-42dde27851f2","fdceae0689483bd1542e8f56c67442447a655b","59ccccb8-132b-11f1-8b48-42dde27851f2",122,["D",1772121233623],"x\u0001]R�j�@\u0010̳�bȓ\fFI\u001fBA�]�Z�\u0002G\u000e�C(�8'i�\u001e�N�݊8\u0018�{�:��\u0007qڙ�ٝSZT)�^^��rWi\u0006��\b\u0007L\u0004�T\u0018�\u0011O�*q\u001e\u0004\u0017yz�P\u0013�9��X1i�\u001f��&-O|��0o*�S�2��՚\u0007��#�N�{@��\u001f�\f��a��NF�=j��H*A�;;�4t�6^��8XbV)��d�1�x\u0015��E@{�j&�q��K\u0011�q\u0011M��K��\u0014\"{�Ԇ�F��^A��\u001a��\u0001��[�&\u0006\u0003�\u0001\u001e~G󨧴��̖�\u0013�5?��x��\u0013��\u001f�5aY҆ژ,�ס5��Ƅ�\b��=��FM�[��`�\u000b$��i�Ӡs��'�\u001c?��vp�?��\u0001��&��v��;Y;�8��oM\\��M?�ի\tJ��}=�h\f��&�{�s��Ы�5�9��'�\\\u001d��\u0003[\u0007kq��\u0001m��\u0016",[],[159,218,380,387],[159,218,380],{"_106":396,"_97":397,"_160":398,"_162":219,"_163":145,"_164":399,"_166":167,"_108":400,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":401,"_100":402},"575c6010-132b-11f1-8089-42dde27851f2","9b","575c60e2-132b-11f1-8089-42dde27851f2",79,["D",1772121229533],[],[159,218,397],{"_106":404,"_97":405,"_160":406,"_162":219,"_163":145,"_164":407,"_166":167,"_108":408,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":409,"_100":410},"57887efc-132b-11f1-af4c-42dde27851f2","9c","57887fba-132b-11f1-af4c-42dde27851f2",82,["D",1772121229822],[],[159,218,405],{"_106":412,"_97":413,"_160":414,"_162":219,"_163":145,"_164":415,"_166":167,"_108":416,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":417,"_100":427},"58d4d800-132b-11f1-954f-42dde27851f2","a1","58d4d8aa-132b-11f1-954f-42dde27851f2",102,["D",1772121231997],[418],{"_106":419,"_97":420,"_160":421,"_162":414,"_163":145,"_164":422,"_166":167,"_108":423,"_102":33,"_169":284,"_171":424,"_172":22,"_173":-5,"_174":425,"_100":426},"59dfea14-132b-11f1-8f1f-42dde27851f2","4a05f7473970bb341c58a869b8d994a8ab287b","59dfead2-132b-11f1-8f1f-42dde27851f2",125,["D",1772121233670],"x\u0001Ւ�n�0\u0010�{�S\f|��TN\u000e�(M�\"�\u0004\b�6?��\u0007�Y5,(�!Wu\fC�^��\u000b�7��p?�ֶ��هw�][��A:\u0012L�Z��\u0013�vM�5\u000f\u001cjm��G�l��'�j��W2\r.γ� \tv�\u0011,j�i?_�bǗ��l�Z.3,q��<��2�[j��۝b��X\u0007&��,��ɓ�<\u001e\u001b�/h��\u001a\\*<��UFoi3�F��de͸�c��װ��qz�%v\u0019 ��aG\\��;tNWX�b\u0017�� tĝ3�\u0003\u0018��dǔ�v��ؚ\"\u001c�Ns�\u0010\u001b��r&\t6�\u0014�pfQ� ��Z�Љ��x?\t�\u001a��C7^�V��\u0015��ė�\u0017I.\u000bݑ\u000f�b��4�M�{��Q-<�\u001aO��F\u001d��긺��#8�\u001f�\u0003�Z�|I�\u0014�C��\u0006�~��;��}�1\u000e\u001cs\u001c�MH\u0012��%��p�[�ŸlB\u001cp��\u001f�dF�",[],[159,218,413,420],[159,218,413],{"_106":429,"_97":430,"_160":431,"_162":219,"_163":145,"_164":432,"_166":167,"_108":433,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":434,"_100":435},"58836d8a-132b-11f1-8e0b-42dde27851f2","a7","58836e8e-132b-11f1-8e0b-42dde27851f2",97,["D",1772121231463],[],[159,218,430],{"_106":437,"_97":438,"_160":439,"_162":219,"_163":145,"_164":440,"_166":167,"_108":441,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":442,"_100":443},"58b21e3c-132b-11f1-954f-42dde27851f2","a8","58b21f22-132b-11f1-954f-42dde27851f2",100,["D",1772121231769],[],[159,218,438],{"_106":445,"_97":446,"_160":447,"_162":219,"_163":145,"_164":448,"_166":167,"_108":449,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":450,"_100":451},"58c18da4-132b-11f1-8fb2-42dde27851f2","b0","58c18e76-132b-11f1-8fb2-42dde27851f2",101,["D",1772121231874],[],[159,218,446],{"_106":453,"_97":454,"_160":455,"_162":219,"_163":145,"_164":456,"_166":167,"_108":457,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":458,"_100":459},"589296d4-132b-11f1-b163-42dde27851f2","b1","589297c4-132b-11f1-b163-42dde27851f2",98,["D",1772121231562],[],[159,218,454],{"_106":461,"_97":462,"_160":463,"_162":219,"_163":145,"_164":464,"_166":167,"_108":465,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":466,"_100":467},"57d4253c-132b-11f1-b163-42dde27851f2","c1","57d425f0-132b-11f1-b163-42dde27851f2",86,["D",1772121230315],[],[159,218,462],{"_106":469,"_97":470,"_160":471,"_162":219,"_163":145,"_164":472,"_166":167,"_108":473,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":474,"_100":475},"58e315aa-132b-11f1-b6c9-42dde27851f2","c3","58e31654-132b-11f1-b6c9-42dde27851f2",103,["D",1772121232090],[],[159,218,470],{"_106":477,"_97":478,"_160":479,"_162":219,"_163":145,"_164":480,"_166":167,"_108":481,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":482,"_100":483},"5906a7a4-132b-11f1-8e0b-42dde27851f2","c5","5906a844-132b-11f1-8e0b-42dde27851f2",105,["D",1772121232322],[],[159,218,478],{"_106":485,"_97":486,"_160":487,"_162":219,"_163":145,"_164":488,"_166":167,"_108":489,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":490,"_100":491},"586fdb3a-132b-11f1-b163-42dde27851f2","d3","586fdbee-132b-11f1-b163-42dde27851f2",96,["D",1772121231331],[],[159,218,486],{"_106":493,"_97":494,"_160":495,"_162":219,"_163":145,"_164":496,"_166":167,"_108":497,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":498,"_100":499},"5796ce4e-132b-11f1-b93a-42dde27851f2","d8","5796cef8-132b-11f1-b93a-42dde27851f2",83,["D",1772121229913],[],[159,218,494],{"_106":501,"_97":502,"_160":503,"_162":219,"_163":145,"_164":504,"_166":167,"_108":505,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":506,"_100":507},"589ec364-132b-11f1-8fb2-42dde27851f2","db","589ec47c-132b-11f1-8fb2-42dde27851f2",99,["D",1772121231646],[],[159,218,502],{"_106":509,"_97":510,"_160":511,"_162":219,"_163":145,"_164":512,"_166":167,"_108":513,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":514,"_100":515},"57c0057a-132b-11f1-b93a-42dde27851f2","e4","57c0064c-132b-11f1-b93a-42dde27851f2",85,["D",1772121230165],[],[159,218,510],{"_106":517,"_97":518,"_160":519,"_162":219,"_163":145,"_164":520,"_166":167,"_108":521,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":522,"_100":523},"58f61588-132b-11f1-b163-42dde27851f2","ea","58f6163c-132b-11f1-b163-42dde27851f2",104,["D",1772121232194],[],[159,218,518],{"_106":525,"_97":526,"_160":527,"_162":219,"_163":145,"_164":528,"_166":167,"_108":529,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":530,"_100":531},"57ac915c-132b-11f1-b163-42dde27851f2","eb","57ac9210-132b-11f1-b163-42dde27851f2",84,["D",1772121230053],[],[159,218,526],{"_106":533,"_97":534,"_160":535,"_162":219,"_163":145,"_164":536,"_166":167,"_108":537,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":538,"_100":539},"5915b23a-132b-11f1-b163-42dde27851f2","f6","5915b2d0-132b-11f1-b163-42dde27851f2",106,["D",1772121232423],[],[159,218,534],{"_106":541,"_97":186,"_160":542,"_162":219,"_163":145,"_164":543,"_166":167,"_108":544,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":545,"_100":546},"5840b10c-132b-11f1-8fb2-42dde27851f2","5840b1ac-132b-11f1-8fb2-42dde27851f2",93,["D",1772121231030],[],[159,218,186],{"_106":548,"_97":549,"_160":550,"_162":219,"_163":145,"_164":551,"_166":167,"_108":552,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":553,"_100":554},"57f68d66-132b-11f1-a19c-42dde27851f2","pack","57f68e06-132b-11f1-a19c-42dde27851f2",88,["D",1772121230540],[],[159,218,549],[159,218],{"_106":557,"_97":201,"_160":558,"_162":161,"_163":145,"_164":559,"_166":167,"_108":560,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":561,"_100":577},"5711f886-132b-11f1-b163-42dde27851f2","5711f980-132b-11f1-b163-42dde27851f2",74,["D",1772121229041],[562,569],{"_106":563,"_97":208,"_160":564,"_162":558,"_163":145,"_164":565,"_166":167,"_108":566,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":567,"_100":568},"597d9eae-132b-11f1-b93a-42dde27851f2","597d9f80-132b-11f1-b93a-42dde27851f2",113,["D",1772121233103],[],[159,201,208],{"_106":570,"_97":571,"_160":572,"_162":558,"_163":145,"_164":573,"_166":167,"_108":574,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":575,"_100":576},"598ddd46-132b-11f1-af4c-42dde27851f2","tags","598dddfa-132b-11f1-af4c-42dde27851f2",114,["D",1772121233213],[],[159,201,571],[159,201],{"_106":579,"_97":580,"_160":581,"_162":161,"_163":145,"_164":103,"_166":167,"_108":582,"_102":33,"_169":284,"_171":583,"_172":22,"_173":-5,"_174":584,"_100":585},"59e2b8f2-132b-11f1-9db5-42dde27851f2","HEAD","59e2b9e2-132b-11f1-9db5-42dde27851f2",["D",1772121233753],"ref: refs/heads/main\n",[],[159,580],{"_106":587,"_97":588,"_160":589,"_162":161,"_163":145,"_164":590,"_166":167,"_108":591,"_102":33,"_169":284,"_171":592,"_172":22,"_173":-5,"_174":593,"_100":594},"59c26d40-132b-11f1-b163-42dde27851f2","config","59c26dd6-132b-11f1-b163-42dde27851f2",120,["D",1772121233554],"[core]\n\trepositoryformatversion = 0\n\tfilemode = true\n\tbare = false\n\tlogallrefupdates = true\n\tignorecase = true\n\tprecomposeunicode = true\n",[],[159,588],[159],{"_106":597,"_97":502,"_160":598,"_162":-5,"_163":145,"_164":599,"_166":167,"_108":600,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":601,"_100":658},"9e9b1bb2-130b-11f1-a4f6-42dde27851f2","9e9b1c5c-130b-11f1-a4f6-42dde27851f2",2,["D",1772107605164],[602,613,622,631,640,649],{"_106":603,"_97":604,"_160":605,"_162":598,"_163":145,"_164":606,"_166":167,"_108":607,"_102":608,"_169":609,"_171":610,"_172":22,"_173":-5,"_174":611,"_100":612},"4733f76a-130e-11f1-8d42-42dde27851f2","queries.test.ts","9ee5d0e4-130b-11f1-aee3-42dde27851f2",28,["D",1772108747000],1,"script","import { describe, it, expect, beforeEach } from \"vitest\";\nimport type { Database } from \"./types.ts\";\nimport { createTestDb } from \"./test-helpers.ts\";\nimport { migrate } from \"./schema.ts\";\nimport {\n addProject,\n getActiveProjects,\n deactivateProject,\n addGrant,\n getActiveGrants,\n deactivateGrant,\n addTaskType,\n getActiveTaskTypes,\n deactivateTaskType,\n createTimeEntry,\n getTimeEntryById,\n updateTimeEntry,\n softDeleteTimeEntry,\n getRecentEntries,\n addIntern,\n removeIntern,\n getInterns,\n setConfig,\n getConfig,\n getReportData,\n} from \"./queries.ts\";\nimport type { TimeEntryInput } from \"./queries.ts\";\n\ndescribe(\"Lookup table CRUD\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n // --- Projects ---\n\n it(\"adds and retrieves active projects\", async () => {\n await addProject(db, \"Lakeland Archive\");\n await addProject(db, \"Timesheet App\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(2);\n expect(projects[0].name).toBe(\"Lakeland Archive\");\n expect(projects[1].name).toBe(\"Timesheet App\");\n });\n\n it(\"deactivates a project without deleting it\", async () => {\n await addProject(db, \"Old Project\");\n await deactivateProject(db, \"Old Project\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(0);\n });\n\n // --- Grants ---\n\n it(\"adds and retrieves active grants\", async () => {\n await addGrant(db, \"NEH-123\", \"NEH Digital Humanities\");\n\n const grants = await getActiveGrants(db);\n expect(grants).toHaveLength(1);\n expect(grants[0].code).toBe(\"NEH-123\");\n expect(grants[0].name).toBe(\"NEH Digital Humanities\");\n });\n\n it(\"deactivates a grant\", async () => {\n await addGrant(db, \"NEH-123\", \"NEH Digital Humanities\");\n await deactivateGrant(db, \"NEH-123\");\n\n const grants = await getActiveGrants(db);\n expect(grants).toHaveLength(0);\n });\n\n // --- Task Types ---\n\n it(\"adds and retrieves active task types\", async () => {\n await addTaskType(db, \"Development\");\n await addTaskType(db, \"Research\");\n\n const types = await getActiveTaskTypes(db);\n expect(types).toHaveLength(2);\n });\n\n it(\"deactivates a task type\", async () => {\n await addTaskType(db, \"Development\");\n await deactivateTaskType(db, \"Development\");\n\n const types = await getActiveTaskTypes(db);\n expect(types).toHaveLength(0);\n });\n});\n\ndescribe(\"Time entry CRUD\", () => {\n let db: Database;\n let taskTypeId: number;\n let projectId: number;\n let grantId: number;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Development\");\n const types = await getActiveTaskTypes(db);\n taskTypeId = types[0].id;\n await addProject(db, \"Test Project\");\n const projects = await getActiveProjects(db);\n projectId = projects[0].id;\n await addGrant(db, \"G-001\", \"Test Grant\");\n const grants = await getActiveGrants(db);\n grantId = grants[0].id;\n });\n\n it(\"creates entry and retrieves it\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 120,\n taskTypeId,\n projectId,\n grantId,\n comment: \"Worked on feature X\",\n };\n const id = await createTimeEntry(db, input);\n const entry = await getTimeEntryById(db, id);\n\n expect(entry).not.toBeNull();\n expect(entry!.minutes).toBe(120);\n expect(entry!.slackUsername).toBe(\"alice\");\n expect(entry!.comment).toBe(\"Worked on feature X\");\n });\n\n it(\"creates entry with optional fields null\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: null,\n };\n const id = await createTimeEntry(db, input);\n const entry = await getTimeEntryById(db, id);\n\n expect(entry).not.toBeNull();\n expect(entry!.projectId).toBeNull();\n expect(entry!.grantId).toBeNull();\n expect(entry!.comment).toBeNull();\n });\n\n it(\"updates an existing entry\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: \"initial\",\n };\n const id = await createTimeEntry(db, input);\n await updateTimeEntry(db, id, { minutes: 90, comment: \"updated\" });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry!.minutes).toBe(90);\n expect(entry!.comment).toBe(\"updated\");\n });\n\n it(\"soft-deletes and excludes from getRecentEntries\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: null,\n };\n const id = await createTimeEntry(db, input);\n await softDeleteTimeEntry(db, id);\n\n const entries = await getRecentEntries(db, \"U123\", 10);\n expect(entries).toHaveLength(0);\n\n const entry = await getTimeEntryById(db, id);\n expect(entry).toBeNull();\n });\n\n it(\"retrieves recent entries limited and ordered\", async () => {\n for (let i = 1; i <= 5; i++) {\n await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: `2026-02-0${i}`,\n minutes: i * 30,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: null,\n });\n }\n // soft-delete the last one\n await softDeleteTimeEntry(db, 5);\n\n const entries = await getRecentEntries(db, \"U123\", 3);\n expect(entries).toHaveLength(3);\n // most recent first\n expect(entries[0].date).toBe(\"2026-02-04\");\n expect(entries[1].date).toBe(\"2026-02-03\");\n expect(entries[2].date).toBe(\"2026-02-02\");\n });\n});\n\ndescribe(\"Intern management\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"adds and lists interns\", async () => {\n await addIntern(db, \"U001\", \"alice\");\n await addIntern(db, \"U002\", \"bob\");\n\n const interns = await getInterns(db);\n expect(interns).toHaveLength(2);\n // ordered by username\n expect(interns[0].slackUsername).toBe(\"alice\");\n expect(interns[1].slackUsername).toBe(\"bob\");\n });\n\n it(\"removes an intern\", async () => {\n await addIntern(db, \"U001\", \"alice\");\n await removeIntern(db, \"U001\");\n\n const interns = await getInterns(db);\n expect(interns).toHaveLength(0);\n });\n});\n\ndescribe(\"Config key-value store\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"sets and gets config values\", async () => {\n await setConfig(db, \"reminder_channel\", \"C12345\");\n const value = await getConfig(db, \"reminder_channel\");\n expect(value).toBe(\"C12345\");\n });\n\n it(\"upserts config on conflict\", async () => {\n await setConfig(db, \"reminder_channel\", \"C12345\");\n await setConfig(db, \"reminder_channel\", \"C99999\");\n\n const value = await getConfig(db, \"reminder_channel\");\n expect(value).toBe(\"C99999\");\n });\n\n it(\"returns null for missing config keys\", async () => {\n const value = await getConfig(db, \"nonexistent\");\n expect(value).toBeNull();\n });\n});\n\ndescribe(\"report query\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n await addTaskType(db, \"Metadata Editing\");\n await addGrant(db, \"NEH-PW-290261\", \"NEH\");\n });\n\n it(\"aggregates hours by user, task, and grant for a date range\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 120, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-25\",\n minutes: 60, taskTypeId: 2, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-25\",\n minutes: 90, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", null);\n expect(data).toHaveLength(3);\n // Ordered by username then task name\n expect(data[0].slackUsername).toBe(\"james\");\n expect(data[0].totalMinutes).toBe(90);\n });\n\n it(\"filters by user when specified\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", \"U123\");\n expect(data).toHaveLength(1);\n expect(data[0].slackUsername).toBe(\"maria\");\n });\n});\n",[],[502,604],{"_106":614,"_97":615,"_160":616,"_162":598,"_163":145,"_164":617,"_166":167,"_108":618,"_102":608,"_169":609,"_171":619,"_172":22,"_173":-5,"_174":620,"_100":621},"477f0552-130e-11f1-abac-42dde27851f2","queries.ts","9eebf1f4-130b-11f1-bab2-42dde27851f2",40,["D",1772108747167],"import type { Database } from \"./types.ts\";\n\n// --- Lookup table types ---\n\nexport interface Project {\n id: number;\n name: string;\n}\n\nexport interface Grant {\n id: number;\n code: string;\n name: string;\n}\n\nexport interface TaskType {\n id: number;\n name: string;\n}\n\n// --- Project CRUD ---\n\nexport async function addProject(db: Database, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO projects (name) VALUES (?)\", args: [name] });\n}\n\nexport async function getActiveProjects(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM projects WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n name: row[1] as string,\n }));\n}\n\nexport async function deactivateProject(db: Database, name: string): Promise {\n await db.execute({\n sql: \"UPDATE projects SET active = 0 WHERE name = ?\",\n args: [name],\n });\n}\n\n// --- Grant CRUD ---\n\nexport async function addGrant(db: Database, code: string, name: string): Promise {\n await db.execute({\n sql: \"INSERT INTO grants (code, name) VALUES (?, ?)\",\n args: [code, name],\n });\n}\n\nexport async function getActiveGrants(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, code, name FROM grants WHERE active = 1 ORDER BY code\",\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n code: row[1] as string,\n name: row[2] as string,\n }));\n}\n\nexport async function deactivateGrant(db: Database, code: string): Promise {\n await db.execute({\n sql: \"UPDATE grants SET active = 0 WHERE code = ?\",\n args: [code],\n });\n}\n\n// --- TaskType CRUD ---\n\nexport async function addTaskType(db: Database, name: string): Promise {\n await db.execute({\n sql: \"INSERT INTO task_types (name) VALUES (?)\",\n args: [name],\n });\n}\n\nexport async function getActiveTaskTypes(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM task_types WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n name: row[1] as string,\n }));\n}\n\nexport async function deactivateTaskType(db: Database, name: string): Promise {\n await db.execute({\n sql: \"UPDATE task_types SET active = 0 WHERE name = ?\",\n args: [name],\n });\n}\n\n// --- Time entry types ---\n\nexport interface TimeEntryInput {\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\nexport interface TimeEntry {\n id: number;\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n createdAt: string;\n}\n\n// --- Time entry CRUD ---\n\nexport async function createTimeEntry(db: Database, input: TimeEntryInput): Promise {\n const result = await db.execute({\n sql: `INSERT INTO time_entries (slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n input.slackUserId,\n input.slackUsername,\n input.date,\n input.minutes,\n input.taskTypeId,\n input.projectId,\n input.grantId,\n input.comment,\n ],\n });\n return Number(result.lastInsertRowid);\n}\n\nexport async function getTimeEntryById(db: Database, id: number): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries WHERE id = ? AND deleted_at IS NULL`,\n args: [id],\n });\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row[0] as number,\n slackUserId: row[1] as string,\n slackUsername: row[2] as string,\n date: row[3] as string,\n minutes: row[4] as number,\n taskTypeId: row[5] as number,\n projectId: row[6] as number | null,\n grantId: row[7] as number | null,\n comment: row[8] as string | null,\n createdAt: row[9] as string,\n };\n}\n\nexport async function updateTimeEntry(\n db: Database,\n id: number,\n updates: Partial>\n): Promise {\n const setClauses: string[] = [];\n const args: unknown[] = [];\n\n const columnMap: Record = {\n minutes: \"minutes\",\n taskTypeId: \"task_type_id\",\n projectId: \"project_id\",\n grantId: \"grant_id\",\n comment: \"comment\",\n date: \"date\",\n };\n\n for (const [key, value] of Object.entries(updates)) {\n const column = columnMap[key];\n if (column) {\n setClauses.push(`${column} = ?`);\n args.push(value);\n }\n }\n\n if (setClauses.length === 0) return;\n\n setClauses.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n await db.execute({\n sql: `UPDATE time_entries SET ${setClauses.join(\", \")} WHERE id = ?`,\n args,\n });\n}\n\nexport async function softDeleteTimeEntry(db: Database, id: number): Promise {\n await db.execute({\n sql: \"UPDATE time_entries SET deleted_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n}\n\nexport async function getRecentEntries(\n db: Database,\n slackUserId: string,\n limit: number\n): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries\n WHERE slack_user_id = ? AND deleted_at IS NULL\n ORDER BY date DESC, created_at DESC\n LIMIT ?`,\n args: [slackUserId, limit],\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n slackUserId: row[1] as string,\n slackUsername: row[2] as string,\n date: row[3] as string,\n minutes: row[4] as number,\n taskTypeId: row[5] as number,\n projectId: row[6] as number | null,\n grantId: row[7] as number | null,\n comment: row[8] as string | null,\n createdAt: row[9] as string,\n }));\n}\n\n// --- Intern types ---\n\nexport interface Intern {\n slackUserId: string;\n slackUsername: string;\n}\n\n// --- Intern management ---\n\nexport async function addIntern(\n db: Database,\n slackUserId: string,\n slackUsername: string\n): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO interns (slack_user_id, slack_username) VALUES (?, ?)\",\n args: [slackUserId, slackUsername],\n });\n}\n\nexport async function removeIntern(db: Database, slackUserId: string): Promise {\n await db.execute({\n sql: \"DELETE FROM interns WHERE slack_user_id = ?\",\n args: [slackUserId],\n });\n}\n\nexport async function getInterns(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT slack_user_id, slack_username FROM interns ORDER BY slack_username\",\n });\n return result.rows.map((row) => ({\n slackUserId: row[0] as string,\n slackUsername: row[1] as string,\n }));\n}\n\n// --- Report queries ---\n\nexport interface ReportRow {\n slackUserId: string;\n slackUsername: string;\n taskTypeName: string;\n grantCode: string | null;\n totalMinutes: number;\n}\n\nexport async function getReportData(\n db: Database,\n startDate: string,\n endDate: string,\n slackUserId: string | null\n): Promise {\n const args: unknown[] = [startDate, endDate];\n let userFilter = \"\";\n if (slackUserId) {\n userFilter = \"AND te.slack_user_id = ?\";\n args.push(slackUserId);\n }\n\n const result = await db.execute({\n sql: `SELECT te.slack_user_id, te.slack_username, tt.name as task_type_name,\n g.code as grant_code, SUM(te.minutes) as total_minutes\n FROM time_entries te\n JOIN task_types tt ON te.task_type_id = tt.id\n LEFT JOIN grants g ON te.grant_id = g.id\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL ${userFilter}\n GROUP BY te.slack_user_id, te.slack_username, tt.name, g.code\n ORDER BY te.slack_username, tt.name`,\n args,\n });\n\n return result.rows.map((r) => ({\n slackUserId: r[0] as string,\n slackUsername: r[1] as string,\n taskTypeName: r[2] as string,\n grantCode: r[3] as string | null,\n totalMinutes: r[4] as number,\n }));\n}\n\n// --- Config key-value store ---\n\nexport async function setConfig(db: Database, key: string, value: string): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO config (key, value) VALUES (?, ?)\",\n args: [key, value],\n });\n}\n\nexport async function getConfig(db: Database, key: string): Promise {\n const result = await db.execute({\n sql: \"SELECT value FROM config WHERE key = ?\",\n args: [key],\n });\n if (result.rows.length === 0) return null;\n return result.rows[0][0] as string;\n}\n",[],[502,615],{"_106":623,"_97":624,"_160":625,"_162":598,"_163":145,"_164":626,"_166":167,"_108":627,"_102":608,"_169":609,"_171":628,"_172":22,"_173":-5,"_174":629,"_100":630},"4740380e-130e-11f1-8d42-42dde27851f2","schema.test.ts","9efeb7da-130b-11f1-8e57-42dde27851f2",30,["D",1772108747083],"import { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"./test-helpers.ts\";\nimport { migrate } from \"./schema.ts\";\nimport type { Database } from \"./types.ts\";\n\ndescribe(\"schema migration\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n });\n\n it(\"creates all required tables\", async () => {\n await migrate(db);\n\n const result = await db.execute({\n sql: \"SELECT name FROM sqlite_master WHERE type='table' ORDER BY name\",\n });\n const tables = result.rows.map((r) => r[0]);\n\n expect(tables).toContain(\"projects\");\n expect(tables).toContain(\"grants\");\n expect(tables).toContain(\"task_types\");\n expect(tables).toContain(\"time_entries\");\n expect(tables).toContain(\"interns\");\n expect(tables).toContain(\"config\");\n });\n\n it(\"is idempotent — running twice does not error\", async () => {\n await migrate(db);\n await expect(migrate(db)).resolves.not.toThrow();\n });\n});\n",[],[502,624],{"_106":632,"_97":633,"_160":634,"_162":598,"_163":145,"_164":635,"_166":167,"_108":636,"_102":608,"_169":609,"_171":637,"_172":22,"_173":-5,"_174":638,"_100":639},"476555e4-130e-11f1-9770-42dde27851f2","schema.ts","9edb2680-130b-11f1-bab2-42dde27851f2",36,["D",1772108746988],"import type { Database } from \"./types.ts\";\n\nconst SCHEMA = [\n `CREATE TABLE IF NOT EXISTS projects (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS grants (\n id INTEGER PRIMARY KEY,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS task_types (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS time_entries (\n id INTEGER PRIMARY KEY,\n slack_user_id TEXT NOT NULL,\n slack_username TEXT NOT NULL,\n date TEXT NOT NULL,\n minutes INTEGER NOT NULL,\n project_id INTEGER REFERENCES projects(id),\n grant_id INTEGER REFERENCES grants(id),\n task_type_id INTEGER NOT NULL REFERENCES task_types(id),\n comment TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now')),\n deleted_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS interns (\n slack_user_id TEXT PRIMARY KEY,\n slack_username TEXT NOT NULL,\n added_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS config (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n];\n\nexport async function migrate(db: Database): Promise {\n await db.batch(SCHEMA);\n}\n",[],[502,633],{"_106":641,"_97":642,"_160":643,"_162":598,"_163":145,"_164":644,"_166":22,"_108":645,"_102":608,"_169":609,"_171":646,"_172":22,"_173":-5,"_174":647,"_100":648},"47453c00-130e-11f1-9855-42dde27851f2","test-helpers.ts","9ef4db84-130b-11f1-8f11-42dde27851f2",31,["D",1772108747126],"import { createClient } from \"@libsql/client\";\nimport type { Database } from \"./types.ts\";\n\n/**\n * Creates an in-memory SQLite database for testing.\n * Uses @libsql/client with file::memory: URL.\n */\nexport async function createTestDb(): Promise {\n const client = createClient({ url: \"file::memory:\" });\n return {\n async execute(query) {\n const result = await client.execute(query);\n return {\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n };\n },\n async batch(queries) {\n const results = await client.batch(\n queries.map((q) => (typeof q === \"string\" ? q : q))\n );\n return results.map((result) => ({\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n }));\n },\n };\n}\n",[],[502,642],{"_106":650,"_97":651,"_160":652,"_162":598,"_163":145,"_164":653,"_166":167,"_108":654,"_102":33,"_169":609,"_171":655,"_172":22,"_173":-5,"_174":656,"_100":657},"9ef9bbae-130b-11f1-8d22-42dde27851f2","types.ts","9ef9bc9e-130b-11f1-8d22-42dde27851f2",12,["D",1772107605783],"export interface DbResult {\n columns: string[];\n rows: unknown[][];\n rowsAffected: number;\n lastInsertRowid: bigint | number;\n}\n\nexport interface Database {\n execute(query: { sql: string; args?: unknown[] }): Promise;\n batch(queries: Array): Promise;\n}\n",[],[502,651],[502],{"_106":660,"_97":661,"_160":662,"_162":-5,"_163":145,"_164":663,"_166":167,"_108":664,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":665,"_100":692},"569b8d22-132b-11f1-8fb2-42dde27851f2","docs","569b8e1c-132b-11f1-8fb2-42dde27851f2",67,["D",1772121228268],[666],{"_106":667,"_97":668,"_160":669,"_162":662,"_163":145,"_164":670,"_166":167,"_108":671,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":672,"_100":691},"56b8af88-132b-11f1-8e0b-42dde27851f2","plans","56b8b096-132b-11f1-8e0b-42dde27851f2",69,["D",1772121228458],[673,682],{"_106":674,"_97":675,"_160":676,"_162":669,"_163":145,"_164":677,"_166":167,"_108":678,"_102":33,"_169":284,"_171":679,"_172":22,"_173":-5,"_174":680,"_100":681},"59b4a7aa-132b-11f1-b93a-42dde27851f2","2026-02-26-timesheet-app-design.md","59b4a872-132b-11f1-b93a-42dde27851f2",117,["D",1772121233427],"# Lakeland Timesheet — Slack App Design\n\n## Overview\n\nA Slack app for interns working on Lakeland Digital Archive projects to log their hours in 15-minute increments, with optional project/grant/task categorization. Managers and interns can run reports of hours worked over configurable time periods.\n\n**Platform:** Val Town (HTTP val + cron val)\n**Storage:** Val Town built-in SQLite (Turso)\n**Team size:** 4–10 interns across multiple projects/grants\n\n## Data Model\n\n### Lookup Tables (managed via `/timesheet-admin`)\n\n```sql\nCREATE TABLE projects (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n);\n\nCREATE TABLE grants (\n id INTEGER PRIMARY KEY,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1\n);\n\nCREATE TABLE task_types (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n);\n```\n\n### Core Tables\n\n```sql\nCREATE TABLE time_entries (\n id INTEGER PRIMARY KEY,\n slack_user_id TEXT NOT NULL,\n slack_username TEXT NOT NULL,\n date TEXT NOT NULL,\n minutes INTEGER NOT NULL,\n project_id INTEGER REFERENCES projects(id),\n grant_id INTEGER REFERENCES grants(id),\n task_type_id INTEGER NOT NULL REFERENCES task_types(id),\n comment TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now')),\n deleted_at TEXT\n);\n\nCREATE TABLE interns (\n slack_user_id TEXT PRIMARY KEY,\n slack_username TEXT NOT NULL,\n added_at TEXT NOT NULL DEFAULT (datetime('now'))\n);\n\nCREATE TABLE config (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n);\n```\n\n### Design Decisions\n\n- `slack_user_id` is the stable identity key; `slack_username` is cached for display and refreshed on each interaction.\n- `minutes` stored as integer (multiples of 15). The 15-minute increment constraint is enforced in the modal UI, not the database.\n- `project_id` and `grant_id` are nullable — an intern may log general work. `task_type_id` is required.\n- Soft deletes via `deleted_at` on time entries and `active` flag on lookup tables — preserves audit trail for grant reporting.\n- `interns` table defines who receives weekly reminders and scopes the default report population.\n- `config` table stores reminder settings (day, time, enabled).\n\n## Interaction Flows\n\n### `/logtime` — Log Time Entry\n\n1. Intern types `/logtime`.\n2. Slack POSTs to the Val Town HTTP endpoint with a `trigger_id`.\n3. App calls `views.open` with a Block Kit modal:\n - **Date** — dropdown of last 7 days, defaults to today\n - **Time** — dropdown of 15-minute increments from 15m to 8h\n - **Task** — required dropdown (Transcription, Metadata Editing, Oral History, etc.)\n - **Project** — optional dropdown\n - **Grant** — optional dropdown\n - **Comment** — optional free-form text input\n4. Intern submits. Slack POSTs `view_submission` to the same endpoint.\n5. App saves to SQLite, responds with ephemeral confirmation:\n `\"Logged 1h of Transcription on Feb 26 (NEH-PW-290261) [Edit] [Delete]\"`\n\n### `/logtime list` — View Recent Entries\n\nShows the intern's last 5 entries with Edit and Delete buttons on each.\n\n### Edit/Delete\n\n- **Edit** button reopens the modal pre-filled with the entry's values. Submission updates the row.\n- **Delete** button shows a confirmation dialog, then soft-deletes (`deleted_at` set).\n\n### `/timesheet` — Run Reports\n\n```\n/timesheet → This week, all registered interns\n/timesheet @intern → This week, specific intern\n/timesheet 2026-02-01 2026-02-28 → Custom date range, all interns\n/timesheet @intern 2026-02-01 2026-02-28 → Custom range, specific intern\n```\n\nOutput as ephemeral message:\n\n```\nTimesheet Report: Feb 24 – Feb 28, 2026\n\n@Maria — 20h\n Transcription 12h (NEH-PW-290261)\n Metadata Editing 6h (Mellon-41500)\n Oral History 2h\n\n@James — 15h 30m\n Transcription 8h (NEH-PW-290261)\n Metadata Editing 7h 30m\n\nTotal: 35h 30m across 2 interns\n```\n\nDefault period is the current week (Monday–Sunday). Report groups by intern, then by task type, with grant shown where applicable.\n\n### `/timesheet-admin` — Manage Configuration\n\n```\n/timesheet-admin add project \"Community Oral Histories\"\n/timesheet-admin add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"\n/timesheet-admin add task \"Scanning\"\n/timesheet-admin remove task \"Scanning\"\n/timesheet-admin list\n\n/timesheet-admin intern add @maria\n/timesheet-admin intern remove @james\n\n/timesheet-admin reminder day friday\n/timesheet-admin reminder time 15:00\n/timesheet-admin reminder off\n/timesheet-admin reminder on\n```\n\nText-based rather than modal — config changes are infrequent and a simple syntax is faster.\n\n### Weekly Reminder (Cron)\n\nA separate Val Town cron val runs at the configured day/time (default: Friday 3:00 PM ET).\n\n1. Query registered interns with no `time_entries` for the current week.\n2. DM each via Slack: \"You haven't logged any time this week. Use /logtime to log your hours.\"\n\nConfigurable via `/timesheet-admin reminder` commands. Can be toggled on/off.\n\n## Architecture\n\n### Request Flow\n\n```\nSlack Platform\n |\n | POST (slash commands, interactions)\n v\nMain HTTP Val (request router)\n |\n ├── Verify Slack signature (HMAC-SHA256)\n ├── Parse payload type\n └── Route to handler:\n ├── command=/logtime → open modal / list entries\n ├── command=/timesheet → generate report\n ├── command=/timesheet-admin → CRUD lookup tables\n └── type=view_submission → save/update time entry\n └── type=block_actions → edit/delete button clicks\n\nSQLite (Val Town built-in)\n\nCron Val (weekly reminder)\n └── Queries same SQLite, sends DMs via Slack API\n```\n\n### Code Organization\n\n```\nlakeland-timesheet/\n├── main.ts # HTTP handler + router\n├── cron.ts # Weekly reminder cron val\n├── slack/\n│ ├── verify.ts # Request signature verification\n│ ├── modals.ts # Block Kit modal definitions\n│ └── api.ts # Slack Web API calls\n├── handlers/\n│ ├── logtime.ts # Open modal, list entries\n│ ├── submission.ts # Modal submission → save/update entry\n│ ├── report.ts # Report generation + formatting\n│ └── admin.ts # Admin CRUD for lookup tables + config\n├── db/\n│ ├── schema.ts # CREATE TABLE statements + migration\n│ └── queries.ts # Parameterized SQL queries\n└── lib/\n └── format.ts # Duration formatting, date helpers\n```\n\n### Slack App Configuration\n\n**OAuth Scopes (Bot Token):**\n\n| Scope | Purpose |\n|-------|---------|\n| `commands` | Register slash commands |\n| `chat:write` | Ephemeral confirmations and reports |\n| `users:read` | Resolve @mentions in report arguments |\n| `im:write` | DM interns for weekly reminders |\n\n**Slash Commands** — all three point to the same Val Town HTTP endpoint URL. The router distinguishes by the `command` field.\n\n**Interactivity Request URL** — same endpoint. Receives `view_submission` and `block_actions` payloads.\n\n**Environment Variables (Val Town Secrets):**\n- `SLACK_BOT_TOKEN` — xoxb-... from OAuth install\n- `SLACK_SIGNING_SECRET` — for request signature verification\n\n### Key Constraints\n\n- **3-second rule:** Slack requires acknowledgement within 3 seconds. `/logtime` calls `views.open` and returns 200 immediately. `/timesheet` may need to acknowledge first and post the report as a follow-up via `response_url` if generation takes too long.\n- **Val Town cron is UTC-based.** The reminder schedule must account for ET (UTC-5 or UTC-4 depending on DST).\n- **10MB SQLite on free tier.** Thousands of timesheet entries fit easily — this is not a constraint at this scale.\n\n## Future Features (post-v1)\n\n- Inline slash command parsing (`/logtime 1h transcription`) for power users\n- CSV export (`/timesheet export 2026-02`) for grant reporting\n- App Home tab with persistent view of recent entries and weekly totals\n",[],[661,668,675],{"_106":683,"_97":684,"_160":685,"_162":669,"_163":145,"_164":686,"_166":167,"_108":687,"_102":33,"_169":284,"_171":688,"_172":22,"_173":-5,"_174":689,"_100":690},"59c789d8-132b-11f1-8f1f-42dde27851f2","2026-02-26-timesheet-implementation.md","59c78a8c-132b-11f1-8f1f-42dde27851f2",121,["D",1772121233546],"# Lakeland Timesheet Implementation Plan\n\n> **For Claude:** REQUIRED SUB-SKILL: Use superpowers:executing-plans to implement this plan task-by-task.\n\n**Goal:** Build a Slack timesheet app on Val Town for interns to log hours and managers to run reports.\n\n**Architecture:** Single HTTP val as request router + cron val for weekly reminders. Pure TypeScript business logic tested locally with Vitest; Val Town SQLite for persistence; Slack Block Kit for UI.\n\n**Tech Stack:** Val Town (HTTP + cron vals), TypeScript, Vitest, Val Town SQLite (`@libsql/client`), Slack Block Kit, `vt` CLI for local dev.\n\n**TDD approach:** All business logic is pure functions — tested locally with Vitest. Platform boundaries (SQLite, Slack API) are injected as dependencies so tests use in-memory fakes.\n\n---\n\n## Development Environment\n\n**Val Town CLI (`vt`):**\n```bash\ndeno install -grAf jsr:@valtown/vt\nvt # authenticate with API key from val.town/settings/api\n```\n\n**Val Town MCP (for Claude Code):**\n```bash\nclaude mcp add --transport http val-town https://api.val.town/v3/mcp\n```\n\n**Local testing:** Vitest runs against pure business logic. No Val Town runtime needed for tests.\n\n---\n\n## Task 1: Project Scaffold & Tooling\n\n**Files:**\n- Create: `package.json`\n- Create: `tsconfig.json`\n- Create: `vitest.config.ts`\n- Create: `.gitignore`\n- Create: `src/db/types.ts`\n\n**Step 1: Initialize npm project**\n\n```bash\ncd /Users/trevormunoz/Code/lakeland-timesheet\nnpm init -y\n```\n\n**Step 2: Install dev dependencies**\n\n```bash\nnpm install -D vitest typescript @libsql/client\n```\n\nNote: `@libsql/client` is both a dev dependency (for types in tests) and the runtime import on Val Town. Val Town provides it at `https://esm.town/v/std/sqlite`.\n\n**Step 3: Create tsconfig.json**\n\n```json\n{\n \"compilerOptions\": {\n \"target\": \"ES2022\",\n \"module\": \"ES2022\",\n \"moduleResolution\": \"bundler\",\n \"strict\": true,\n \"esModuleInterop\": true,\n \"outDir\": \"dist\",\n \"rootDir\": \"src\",\n \"declaration\": true,\n \"sourceMap\": true,\n \"forceConsistentCasingInFileNames\": true,\n \"skipLibCheck\": true\n },\n \"include\": [\"src/**/*\"],\n \"exclude\": [\"node_modules\", \"dist\"]\n}\n```\n\n**Step 4: Create vitest.config.ts**\n\n```typescript\nimport { defineConfig } from \"vitest/config\";\n\nexport default defineConfig({\n test: {\n include: [\"src/**/*.test.ts\"],\n },\n});\n```\n\n**Step 5: Create .gitignore**\n\n```\nnode_modules/\ndist/\n.env\n```\n\n**Step 6: Create the database abstraction type**\n\nThis is the key to testability. All database operations go through this interface — Val Town SQLite in production, an in-memory fake in tests.\n\n```typescript\n// src/db/types.ts\nexport interface DbResult {\n columns: string[];\n rows: unknown[][];\n rowsAffected: number;\n lastInsertRowid: bigint | number;\n}\n\nexport interface Database {\n execute(query: { sql: string; args?: unknown[] }): Promise;\n batch(queries: Array): Promise;\n}\n```\n\n**Step 7: Add test script to package.json**\n\nAdd to scripts: `\"test\": \"vitest\", \"test:run\": \"vitest run\"`\n\n**Step 8: Commit**\n\n```bash\ngit add package.json tsconfig.json vitest.config.ts .gitignore src/db/types.ts\ngit commit -m \"chore: project scaffold with Vitest and database abstraction\"\n```\n\n---\n\n## Task 2: Database Schema & Migration\n\n**Files:**\n- Create: `src/db/schema.ts`\n- Create: `src/db/schema.test.ts`\n- Create: `src/db/test-helpers.ts`\n\n**Step 1: Create the test helper — in-memory SQLite fake**\n\n```typescript\n// src/db/test-helpers.ts\nimport { Database as LibSqlDatabase, createClient } from \"@libsql/client\";\nimport type { Database, DbResult } from \"./types.js\";\n\n/**\n * Creates an in-memory SQLite database for testing.\n * Uses @libsql/client with file::memory: URL.\n */\nexport async function createTestDb(): Promise {\n const client = createClient({ url: \"file::memory:\" });\n return {\n async execute(query) {\n const result = await client.execute(query);\n return {\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n };\n },\n async batch(queries) {\n const results = await client.batch(\n queries.map((q) => (typeof q === \"string\" ? q : q))\n );\n return results.map((result) => ({\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n }));\n },\n };\n}\n```\n\n**Step 2: Write the failing test**\n\n```typescript\n// src/db/schema.test.ts\nimport { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"./test-helpers.js\";\nimport { migrate } from \"./schema.js\";\nimport type { Database } from \"./types.js\";\n\ndescribe(\"schema migration\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n });\n\n it(\"creates all required tables\", async () => {\n await migrate(db);\n\n const result = await db.execute({\n sql: \"SELECT name FROM sqlite_master WHERE type='table' ORDER BY name\",\n });\n const tables = result.rows.map((r) => r[0]);\n\n expect(tables).toContain(\"projects\");\n expect(tables).toContain(\"grants\");\n expect(tables).toContain(\"task_types\");\n expect(tables).toContain(\"time_entries\");\n expect(tables).toContain(\"interns\");\n expect(tables).toContain(\"config\");\n });\n\n it(\"is idempotent — running twice does not error\", async () => {\n await migrate(db);\n await expect(migrate(db)).resolves.not.toThrow();\n });\n});\n```\n\n**Step 3: Run test to verify it fails**\n\nRun: `npx vitest run src/db/schema.test.ts`\nExpected: FAIL — `migrate` is not exported from `./schema.js`\n\n**Step 4: Implement schema.ts**\n\n```typescript\n// src/db/schema.ts\nimport type { Database } from \"./types.js\";\n\nconst SCHEMA = [\n `CREATE TABLE IF NOT EXISTS projects (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS grants (\n id INTEGER PRIMARY KEY,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS task_types (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS time_entries (\n id INTEGER PRIMARY KEY,\n slack_user_id TEXT NOT NULL,\n slack_username TEXT NOT NULL,\n date TEXT NOT NULL,\n minutes INTEGER NOT NULL,\n project_id INTEGER REFERENCES projects(id),\n grant_id INTEGER REFERENCES grants(id),\n task_type_id INTEGER NOT NULL REFERENCES task_types(id),\n comment TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now')),\n deleted_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS interns (\n slack_user_id TEXT PRIMARY KEY,\n slack_username TEXT NOT NULL,\n added_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS config (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n];\n\nexport async function migrate(db: Database): Promise {\n await db.batch(SCHEMA);\n}\n```\n\n**Step 5: Run test to verify it passes**\n\nRun: `npx vitest run src/db/schema.test.ts`\nExpected: PASS (2 tests)\n\n**Step 6: Commit**\n\n```bash\ngit add src/db/\ngit commit -m \"feat(db): schema migration with all tables\"\n```\n\n---\n\n## Task 3: Database Queries — Lookup Table CRUD\n\n**Files:**\n- Create: `src/db/queries.ts`\n- Create: `src/db/queries.test.ts`\n\n**Step 1: Write failing tests for lookup CRUD**\n\n```typescript\n// src/db/queries.test.ts\nimport { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"./test-helpers.js\";\nimport { migrate } from \"./schema.js\";\nimport {\n addProject,\n addGrant,\n addTaskType,\n getActiveProjects,\n getActiveGrants,\n getActiveTaskTypes,\n deactivateProject,\n deactivateGrant,\n deactivateTaskType,\n} from \"./queries.js\";\nimport type { Database } from \"./types.js\";\n\ndescribe(\"lookup table CRUD\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n describe(\"projects\", () => {\n it(\"adds and retrieves active projects\", async () => {\n await addProject(db, \"Lakeland Digital Archive\");\n await addProject(db, \"Community Oral Histories\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(2);\n expect(projects[0].name).toBe(\"Community Oral Histories\");\n expect(projects[1].name).toBe(\"Lakeland Digital Archive\");\n });\n\n it(\"deactivates a project without deleting it\", async () => {\n await addProject(db, \"Old Project\");\n await deactivateProject(db, \"Old Project\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(0);\n });\n });\n\n describe(\"grants\", () => {\n it(\"adds and retrieves active grants\", async () => {\n await addGrant(db, \"NEH-PW-290261\", \"NEH Preservation & Access\");\n\n const grants = await getActiveGrants(db);\n expect(grants).toHaveLength(1);\n expect(grants[0].code).toBe(\"NEH-PW-290261\");\n expect(grants[0].name).toBe(\"NEH Preservation & Access\");\n });\n\n it(\"deactivates a grant\", async () => {\n await addGrant(db, \"NEH-PW-290261\", \"NEH Preservation\");\n await deactivateGrant(db, \"NEH-PW-290261\");\n\n expect(await getActiveGrants(db)).toHaveLength(0);\n });\n });\n\n describe(\"task types\", () => {\n it(\"adds and retrieves active task types\", async () => {\n await addTaskType(db, \"Transcription\");\n await addTaskType(db, \"Metadata Editing\");\n\n const types = await getActiveTaskTypes(db);\n expect(types).toHaveLength(2);\n });\n\n it(\"deactivates a task type\", async () => {\n await addTaskType(db, \"Scanning\");\n await deactivateTaskType(db, \"Scanning\");\n\n expect(await getActiveTaskTypes(db)).toHaveLength(0);\n });\n });\n});\n```\n\n**Step 2: Run test to verify it fails**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: FAIL — functions not exported\n\n**Step 3: Implement lookup CRUD in queries.ts**\n\n```typescript\n// src/db/queries.ts\nimport type { Database } from \"./types.js\";\n\n// --- Lookup types ---\n\nexport interface Project {\n id: number;\n name: string;\n}\n\nexport interface Grant {\n id: number;\n code: string;\n name: string;\n}\n\nexport interface TaskType {\n id: number;\n name: string;\n}\n\n// --- Projects ---\n\nexport async function addProject(db: Database, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO projects (name) VALUES (?)\", args: [name] });\n}\n\nexport async function getActiveProjects(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM projects WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((r) => ({ id: r[0] as number, name: r[1] as string }));\n}\n\nexport async function deactivateProject(db: Database, name: string): Promise {\n await db.execute({ sql: \"UPDATE projects SET active = 0 WHERE name = ?\", args: [name] });\n}\n\n// --- Grants ---\n\nexport async function addGrant(db: Database, code: string, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO grants (code, name) VALUES (?, ?)\", args: [code, name] });\n}\n\nexport async function getActiveGrants(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, code, name FROM grants WHERE active = 1 ORDER BY code\",\n });\n return result.rows.map((r) => ({ id: r[0] as number, code: r[1] as string, name: r[2] as string }));\n}\n\nexport async function deactivateGrant(db: Database, code: string): Promise {\n await db.execute({ sql: \"UPDATE grants SET active = 0 WHERE code = ?\", args: [code] });\n}\n\n// --- Task Types ---\n\nexport async function addTaskType(db: Database, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO task_types (name) VALUES (?)\", args: [name] });\n}\n\nexport async function getActiveTaskTypes(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM task_types WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((r) => ({ id: r[0] as number, name: r[1] as string }));\n}\n\nexport async function deactivateTaskType(db: Database, name: string): Promise {\n await db.execute({ sql: \"UPDATE task_types SET active = 0 WHERE name = ?\", args: [name] });\n}\n```\n\n**Step 4: Run test to verify it passes**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: PASS (6 tests)\n\n**Step 5: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts\ngit commit -m \"feat(db): lookup table CRUD for projects, grants, task types\"\n```\n\n---\n\n## Task 4: Database Queries — Time Entries\n\n**Files:**\n- Modify: `src/db/queries.ts`\n- Modify: `src/db/queries.test.ts`\n\n**Step 1: Write failing tests for time entry operations**\n\nAdd to `src/db/queries.test.ts`:\n\n```typescript\nimport {\n // ... existing imports ...\n createTimeEntry,\n updateTimeEntry,\n softDeleteTimeEntry,\n getRecentEntries,\n getTimeEntryById,\n} from \"./queries.js\";\n\ndescribe(\"time entries\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n await addProject(db, \"Lakeland\");\n await addGrant(db, \"NEH-PW-290261\", \"NEH\");\n });\n\n it(\"creates a time entry and retrieves it\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId: 1,\n projectId: 1,\n grantId: 1,\n comment: \"Worked on interviews\",\n });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry).not.toBeNull();\n expect(entry!.minutes).toBe(60);\n expect(entry!.slackUsername).toBe(\"maria\");\n expect(entry!.comment).toBe(\"Worked on interviews\");\n });\n\n it(\"creates entry with optional fields null\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 30,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry!.projectId).toBeNull();\n expect(entry!.grantId).toBeNull();\n });\n\n it(\"updates an existing entry\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n\n await updateTimeEntry(db, id, { minutes: 90, comment: \"Updated\" });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry!.minutes).toBe(90);\n expect(entry!.comment).toBe(\"Updated\");\n });\n\n it(\"soft-deletes an entry\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n\n await softDeleteTimeEntry(db, id);\n\n const recent = await getRecentEntries(db, \"U123\", 5);\n expect(recent).toHaveLength(0);\n });\n\n it(\"retrieves recent entries excluding deleted\", async () => {\n for (let i = 0; i < 7; i++) {\n await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: `2026-02-${20 + i}`,\n minutes: 60,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n }\n\n const recent = await getRecentEntries(db, \"U123\", 5);\n expect(recent).toHaveLength(5);\n // Most recent first\n expect(recent[0].date).toBe(\"2026-02-26\");\n });\n});\n```\n\n**Step 2: Run test to verify it fails**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: FAIL — new functions not exported\n\n**Step 3: Add time entry operations to queries.ts**\n\nAdd to `src/db/queries.ts`:\n\n```typescript\n// --- Time Entry types ---\n\nexport interface TimeEntryInput {\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\nexport interface TimeEntry {\n id: number;\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n createdAt: string;\n}\n\n// --- Time Entries ---\n\nexport async function createTimeEntry(db: Database, input: TimeEntryInput): Promise {\n const result = await db.execute({\n sql: `INSERT INTO time_entries (slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [input.slackUserId, input.slackUsername, input.date, input.minutes, input.taskTypeId, input.projectId, input.grantId, input.comment],\n });\n return Number(result.lastInsertRowid);\n}\n\nexport async function getTimeEntryById(db: Database, id: number): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries WHERE id = ? AND deleted_at IS NULL`,\n args: [id],\n });\n if (result.rows.length === 0) return null;\n const r = result.rows[0];\n return {\n id: r[0] as number,\n slackUserId: r[1] as string,\n slackUsername: r[2] as string,\n date: r[3] as string,\n minutes: r[4] as number,\n taskTypeId: r[5] as number,\n projectId: r[6] as number | null,\n grantId: r[7] as number | null,\n comment: r[8] as string | null,\n createdAt: r[9] as string,\n };\n}\n\nexport async function updateTimeEntry(\n db: Database,\n id: number,\n updates: Partial>\n): Promise {\n const setClauses: string[] = [];\n const args: unknown[] = [];\n\n for (const [key, value] of Object.entries(updates)) {\n const columnMap: Record = {\n date: \"date\",\n minutes: \"minutes\",\n taskTypeId: \"task_type_id\",\n projectId: \"project_id\",\n grantId: \"grant_id\",\n comment: \"comment\",\n };\n const col = columnMap[key];\n if (col) {\n setClauses.push(`${col} = ?`);\n args.push(value);\n }\n }\n\n setClauses.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n await db.execute({\n sql: `UPDATE time_entries SET ${setClauses.join(\", \")} WHERE id = ?`,\n args,\n });\n}\n\nexport async function softDeleteTimeEntry(db: Database, id: number): Promise {\n await db.execute({\n sql: \"UPDATE time_entries SET deleted_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n}\n\nexport async function getRecentEntries(db: Database, slackUserId: string, limit: number): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries WHERE slack_user_id = ? AND deleted_at IS NULL\n ORDER BY date DESC, created_at DESC LIMIT ?`,\n args: [slackUserId, limit],\n });\n return result.rows.map((r) => ({\n id: r[0] as number,\n slackUserId: r[1] as string,\n slackUsername: r[2] as string,\n date: r[3] as string,\n minutes: r[4] as number,\n taskTypeId: r[5] as number,\n projectId: r[6] as number | null,\n grantId: r[7] as number | null,\n comment: r[8] as string | null,\n createdAt: r[9] as string,\n }));\n}\n```\n\n**Step 4: Run test to verify it passes**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: PASS (all tests)\n\n**Step 5: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts\ngit commit -m \"feat(db): time entry CRUD with soft delete\"\n```\n\n---\n\n## Task 5: Database Queries — Intern Management & Config\n\n**Files:**\n- Modify: `src/db/queries.ts`\n- Modify: `src/db/queries.test.ts`\n\n**Step 1: Write failing tests**\n\nAdd to `src/db/queries.test.ts`:\n\n```typescript\nimport {\n // ... existing imports ...\n addIntern,\n removeIntern,\n getInterns,\n setConfig,\n getConfig,\n} from \"./queries.js\";\n\ndescribe(\"intern management\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"adds and lists interns\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n const interns = await getInterns(db);\n expect(interns).toHaveLength(2);\n });\n\n it(\"removes an intern\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await removeIntern(db, \"U123\");\n\n expect(await getInterns(db)).toHaveLength(0);\n });\n});\n\ndescribe(\"config\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"sets and gets config values\", async () => {\n await setConfig(db, \"reminder_day\", \"friday\");\n expect(await getConfig(db, \"reminder_day\")).toBe(\"friday\");\n });\n\n it(\"upserts config on conflict\", async () => {\n await setConfig(db, \"reminder_day\", \"friday\");\n await setConfig(db, \"reminder_day\", \"thursday\");\n expect(await getConfig(db, \"reminder_day\")).toBe(\"thursday\");\n });\n\n it(\"returns null for missing keys\", async () => {\n expect(await getConfig(db, \"nonexistent\")).toBeNull();\n });\n});\n```\n\n**Step 2: Run to verify failure, implement, run to verify pass**\n\nAdd to `src/db/queries.ts`:\n\n```typescript\n// --- Intern types ---\n\nexport interface Intern {\n slackUserId: string;\n slackUsername: string;\n}\n\n// --- Interns ---\n\nexport async function addIntern(db: Database, slackUserId: string, slackUsername: string): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO interns (slack_user_id, slack_username) VALUES (?, ?)\",\n args: [slackUserId, slackUsername],\n });\n}\n\nexport async function removeIntern(db: Database, slackUserId: string): Promise {\n await db.execute({ sql: \"DELETE FROM interns WHERE slack_user_id = ?\", args: [slackUserId] });\n}\n\nexport async function getInterns(db: Database): Promise {\n const result = await db.execute({ sql: \"SELECT slack_user_id, slack_username FROM interns ORDER BY slack_username\" });\n return result.rows.map((r) => ({ slackUserId: r[0] as string, slackUsername: r[1] as string }));\n}\n\n// --- Config ---\n\nexport async function setConfig(db: Database, key: string, value: string): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO config (key, value) VALUES (?, ?)\",\n args: [key, value],\n });\n}\n\nexport async function getConfig(db: Database, key: string): Promise {\n const result = await db.execute({ sql: \"SELECT value FROM config WHERE key = ?\", args: [key] });\n return result.rows.length > 0 ? (result.rows[0][0] as string) : null;\n}\n```\n\n**Step 3: Run tests**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: PASS (all tests)\n\n**Step 4: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts\ngit commit -m \"feat(db): intern management and config key-value store\"\n```\n\n---\n\n## Task 6: Duration & Date Formatting\n\n**Files:**\n- Create: `src/lib/format.ts`\n- Create: `src/lib/format.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/lib/format.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { formatDuration, formatDateRange, getWeekBounds, getLast7Days } from \"./format.js\";\n\ndescribe(\"formatDuration\", () => {\n it(\"formats minutes as hours and minutes\", () => {\n expect(formatDuration(60)).toBe(\"1h\");\n expect(formatDuration(90)).toBe(\"1h 30m\");\n expect(formatDuration(15)).toBe(\"15m\");\n expect(formatDuration(480)).toBe(\"8h\");\n expect(formatDuration(0)).toBe(\"0m\");\n });\n});\n\ndescribe(\"formatDateRange\", () => {\n it(\"formats a date range for display\", () => {\n expect(formatDateRange(\"2026-02-24\", \"2026-02-28\")).toBe(\"Feb 24 – Feb 28, 2026\");\n });\n\n it(\"handles cross-month ranges\", () => {\n expect(formatDateRange(\"2026-01-28\", \"2026-02-03\")).toBe(\"Jan 28 – Feb 3, 2026\");\n });\n});\n\ndescribe(\"getWeekBounds\", () => {\n it(\"returns Monday–Sunday for a given date\", () => {\n // Feb 26 2026 is a Thursday\n const { start, end } = getWeekBounds(\"2026-02-26\");\n expect(start).toBe(\"2026-02-23\"); // Monday\n expect(end).toBe(\"2026-03-01\"); // Sunday\n });\n});\n\ndescribe(\"getLast7Days\", () => {\n it(\"returns last 7 days in descending order\", () => {\n const days = getLast7Days(\"2026-02-26\");\n expect(days).toHaveLength(7);\n expect(days[0]).toBe(\"2026-02-26\");\n expect(days[6]).toBe(\"2026-02-20\");\n });\n});\n```\n\n**Step 2: Run to verify failure, implement, run to verify pass**\n\n```typescript\n// src/lib/format.ts\n\nexport function formatDuration(minutes: number): string {\n const hours = Math.floor(minutes / 60);\n const mins = minutes % 60;\n if (hours === 0) return `${mins}m`;\n if (mins === 0) return `${hours}h`;\n return `${hours}h ${mins}m`;\n}\n\nconst MONTHS = [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"];\n\nexport function formatDateRange(start: string, end: string): string {\n const s = new Date(start + \"T00:00:00\");\n const e = new Date(end + \"T00:00:00\");\n return `${MONTHS[s.getMonth()]} ${s.getDate()} – ${MONTHS[e.getMonth()]} ${e.getDate()}, ${e.getFullYear()}`;\n}\n\nexport function getWeekBounds(dateStr: string): { start: string; end: string } {\n const date = new Date(dateStr + \"T00:00:00\");\n const day = date.getDay(); // 0=Sun, 1=Mon...\n const diffToMonday = day === 0 ? -6 : 1 - day;\n const monday = new Date(date);\n monday.setDate(date.getDate() + diffToMonday);\n const sunday = new Date(monday);\n sunday.setDate(monday.getDate() + 6);\n return {\n start: monday.toISOString().slice(0, 10),\n end: sunday.toISOString().slice(0, 10),\n };\n}\n\nexport function getLast7Days(fromDate: string): string[] {\n const days: string[] = [];\n const date = new Date(fromDate + \"T00:00:00\");\n for (let i = 0; i < 7; i++) {\n const d = new Date(date);\n d.setDate(date.getDate() - i);\n days.push(d.toISOString().slice(0, 10));\n }\n return days;\n}\n```\n\n**Step 3: Run tests**\n\nRun: `npx vitest run src/lib/format.test.ts`\nExpected: PASS\n\n**Step 4: Commit**\n\n```bash\ngit add src/lib/\ngit commit -m \"feat(lib): duration and date formatting utilities\"\n```\n\n---\n\n## Task 7: Admin Command Parser\n\n**Files:**\n- Create: `src/handlers/admin.ts`\n- Create: `src/handlers/admin.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/handlers/admin.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { parseAdminCommand } from \"./admin.js\";\n\ndescribe(\"parseAdminCommand\", () => {\n it(\"parses add project\", () => {\n expect(parseAdminCommand('add project \"Community Oral Histories\"'))\n .toEqual({ action: \"add\", entity: \"project\", args: [\"Community Oral Histories\"] });\n });\n\n it(\"parses add grant with code and name\", () => {\n expect(parseAdminCommand('add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"'))\n .toEqual({ action: \"add\", entity: \"grant\", args: [\"NEH-PW-290261\", \"NEH Preservation & Access\"] });\n });\n\n it(\"parses add task\", () => {\n expect(parseAdminCommand('add task \"Scanning\"'))\n .toEqual({ action: \"add\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses remove task\", () => {\n expect(parseAdminCommand('remove task \"Scanning\"'))\n .toEqual({ action: \"remove\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses list\", () => {\n expect(parseAdminCommand(\"list\"))\n .toEqual({ action: \"list\", entity: null, args: [] });\n });\n\n it(\"parses intern add with user mention\", () => {\n expect(parseAdminCommand(\"intern add <@U123|maria>\"))\n .toEqual({ action: \"add\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses intern remove\", () => {\n expect(parseAdminCommand(\"intern remove <@U123|maria>\"))\n .toEqual({ action: \"remove\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses reminder config\", () => {\n expect(parseAdminCommand(\"reminder day friday\"))\n .toEqual({ action: \"reminder\", entity: \"day\", args: [\"friday\"] });\n expect(parseAdminCommand(\"reminder off\"))\n .toEqual({ action: \"reminder\", entity: \"off\", args: [] });\n });\n\n it(\"returns error for unrecognized commands\", () => {\n expect(parseAdminCommand(\"do something weird\"))\n .toEqual({ action: \"error\", entity: null, args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"] });\n });\n});\n```\n\n**Step 2: Run to verify failure, implement, run to verify pass**\n\n```typescript\n// src/handlers/admin.ts\n\nexport interface AdminCommand {\n action: string;\n entity: string | null;\n args: string[];\n}\n\nexport function parseAdminCommand(text: string): AdminCommand {\n const trimmed = text.trim();\n\n // \"list\"\n if (trimmed === \"list\") {\n return { action: \"list\", entity: null, args: [] };\n }\n\n // \"reminder day friday\" / \"reminder off\" / \"reminder on\" / \"reminder time 15:00\"\n const reminderMatch = trimmed.match(/^reminder\\s+(\\S+)(?:\\s+(.+))?$/);\n if (reminderMatch) {\n const subcommand = reminderMatch[1];\n const value = reminderMatch[2];\n return { action: \"reminder\", entity: subcommand, args: value ? [value] : [] };\n }\n\n // \"intern add <@U123|maria>\" / \"intern remove <@U123|maria>\"\n const internMatch = trimmed.match(/^intern\\s+(add|remove)\\s+<@(\\w+)\\|([^>]+)>/);\n if (internMatch) {\n return { action: internMatch[1], entity: \"intern\", args: [internMatch[2], internMatch[3]] };\n }\n\n // \"add project \"Name\"\" / \"remove task \"Name\"\"\n const crudMatch = trimmed.match(/^(add|remove)\\s+(project|grant|task)\\s+(.+)$/);\n if (crudMatch) {\n const action = crudMatch[1];\n const entity = crudMatch[2];\n const rawArgs = crudMatch[3];\n\n // Extract quoted strings\n const quoted = [...rawArgs.matchAll(/\"([^\"]+)\"/g)].map((m) => m[1]);\n if (quoted.length > 0) {\n return { action, entity, args: quoted };\n }\n return { action, entity, args: [rawArgs.trim()] };\n }\n\n return { action: \"error\", entity: null, args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"] };\n}\n```\n\n**Step 3: Run tests**\n\nRun: `npx vitest run src/handlers/admin.test.ts`\nExpected: PASS\n\n**Step 4: Commit**\n\n```bash\ngit add src/handlers/\ngit commit -m \"feat(handlers): admin command parser for timesheet-admin\"\n```\n\n---\n\n## Task 8: Report Generation\n\n**Files:**\n- Create: `src/handlers/report.ts`\n- Create: `src/handlers/report.test.ts`\n- Modify: `src/db/queries.ts` (add report query)\n\n**Step 1: Write failing test for report query**\n\nAdd to `src/db/queries.test.ts`:\n\n```typescript\nimport {\n // ... existing ...\n getReportData,\n} from \"./queries.js\";\n\ndescribe(\"report query\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n await addTaskType(db, \"Metadata Editing\");\n await addGrant(db, \"NEH-PW-290261\", \"NEH\");\n });\n\n it(\"aggregates hours by user, task, and grant for a date range\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 120, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-25\",\n minutes: 60, taskTypeId: 2, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-25\",\n minutes: 90, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", null);\n expect(data).toHaveLength(3);\n expect(data[0].slackUsername).toBe(\"james\");\n expect(data[0].totalMinutes).toBe(90);\n });\n\n it(\"filters by user when specified\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", \"U123\");\n expect(data).toHaveLength(1);\n expect(data[0].slackUsername).toBe(\"maria\");\n });\n});\n```\n\n**Step 2: Add report query to queries.ts**\n\n```typescript\n// Add to src/db/queries.ts\n\nexport interface ReportRow {\n slackUserId: string;\n slackUsername: string;\n taskTypeName: string;\n grantCode: string | null;\n totalMinutes: number;\n}\n\nexport async function getReportData(\n db: Database,\n startDate: string,\n endDate: string,\n slackUserId: string | null\n): Promise {\n const args: unknown[] = [startDate, endDate];\n let userFilter = \"\";\n if (slackUserId) {\n userFilter = \"AND te.slack_user_id = ?\";\n args.push(slackUserId);\n }\n\n const result = await db.execute({\n sql: `SELECT te.slack_user_id, te.slack_username, tt.name as task_type_name,\n g.code as grant_code, SUM(te.minutes) as total_minutes\n FROM time_entries te\n JOIN task_types tt ON te.task_type_id = tt.id\n LEFT JOIN grants g ON te.grant_id = g.id\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL ${userFilter}\n GROUP BY te.slack_user_id, te.slack_username, tt.name, g.code\n ORDER BY te.slack_username, tt.name`,\n args,\n });\n\n return result.rows.map((r) => ({\n slackUserId: r[0] as string,\n slackUsername: r[1] as string,\n taskTypeName: r[2] as string,\n grantCode: r[3] as string | null,\n totalMinutes: r[4] as number,\n }));\n}\n```\n\n**Step 3: Write failing test for report formatting**\n\n```typescript\n// src/handlers/report.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { formatReport } from \"./report.js\";\nimport type { ReportRow } from \"../db/queries.js\";\n\ndescribe(\"formatReport\", () => {\n it(\"formats a multi-user report\", () => {\n const data: ReportRow[] = [\n { slackUserId: \"U456\", slackUsername: \"james\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 480 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Metadata Editing\", grantCode: null, totalMinutes: 360 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 720 },\n ];\n\n const output = formatReport(data, \"2026-02-24\", \"2026-02-28\");\n\n expect(output).toContain(\"Feb 24 – Feb 28, 2026\");\n expect(output).toContain(\"james\");\n expect(output).toContain(\"maria\");\n expect(output).toContain(\"8h\"); // james total\n expect(output).toContain(\"18h\"); // maria total\n expect(output).toContain(\"26h\"); // grand total\n expect(output).toContain(\"NEH-PW-290261\");\n });\n\n it(\"handles empty data\", () => {\n const output = formatReport([], \"2026-02-24\", \"2026-02-28\");\n expect(output).toContain(\"No time entries\");\n });\n});\n```\n\n**Step 4: Implement report formatter**\n\n```typescript\n// src/handlers/report.ts\nimport type { ReportRow } from \"../db/queries.js\";\nimport { formatDuration, formatDateRange } from \"../lib/format.js\";\n\nexport function formatReport(data: ReportRow[], startDate: string, endDate: string): string {\n const header = `*Timesheet Report: ${formatDateRange(startDate, endDate)}*\\n`;\n\n if (data.length === 0) {\n return header + \"\\nNo time entries found for this period.\";\n }\n\n // Group by user\n const byUser = new Map();\n for (const row of data) {\n if (!byUser.has(row.slackUserId)) {\n byUser.set(row.slackUserId, { username: row.slackUsername, rows: [], total: 0 });\n }\n const user = byUser.get(row.slackUserId)!;\n user.rows.push(row);\n user.total += row.totalMinutes;\n }\n\n let grandTotal = 0;\n const lines: string[] = [header];\n\n for (const [, user] of byUser) {\n grandTotal += user.total;\n lines.push(`*@${user.username}* — ${formatDuration(user.total)}`);\n for (const row of user.rows) {\n const grant = row.grantCode ? ` (${row.grantCode})` : \"\";\n lines.push(` ${row.taskTypeName} ${formatDuration(row.totalMinutes)}${grant}`);\n }\n lines.push(\"\");\n }\n\n lines.push(`*Total: ${formatDuration(grandTotal)} across ${byUser.size} intern${byUser.size === 1 ? \"\" : \"s\"}*`);\n\n return lines.join(\"\\n\");\n}\n```\n\n**Step 5: Run all tests**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n**Step 6: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts src/handlers/report.ts src/handlers/report.test.ts\ngit commit -m \"feat(reports): report data query and text formatter\"\n```\n\n---\n\n## Task 9: Report Command Argument Parser\n\n**Files:**\n- Modify: `src/handlers/report.ts`\n- Modify: `src/handlers/report.test.ts`\n\n**Step 1: Write failing tests for argument parsing**\n\nAdd to `src/handlers/report.test.ts`:\n\n```typescript\nimport { parseReportArgs } from \"./report.js\";\n\ndescribe(\"parseReportArgs\", () => {\n it(\"defaults to current week, all users\", () => {\n const result = parseReportArgs(\"\", \"2026-02-26\");\n expect(result.userId).toBeNull();\n expect(result.startDate).toBe(\"2026-02-23\"); // Monday\n expect(result.endDate).toBe(\"2026-03-01\"); // Sunday\n });\n\n it(\"parses user mention\", () => {\n const result = parseReportArgs(\"<@U123|maria>\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n });\n\n it(\"parses date range\", () => {\n const result = parseReportArgs(\"2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n\n it(\"parses user + date range\", () => {\n const result = parseReportArgs(\"<@U123|maria> 2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n});\n```\n\n**Step 2: Implement parser, run tests, commit**\n\n```typescript\n// Add to src/handlers/report.ts\nimport { getWeekBounds } from \"../lib/format.js\";\n\nexport interface ReportArgs {\n userId: string | null;\n startDate: string;\n endDate: string;\n}\n\nexport function parseReportArgs(text: string, today: string): ReportArgs {\n const trimmed = text.trim();\n let userId: string | null = null;\n\n // Extract user mention\n let remaining = trimmed;\n const userMatch = remaining.match(/<@(\\w+)\\|[^>]+>/);\n if (userMatch) {\n userId = userMatch[1];\n remaining = remaining.replace(userMatch[0], \"\").trim();\n }\n\n // Extract dates\n const dateMatch = remaining.match(/(\\d{4}-\\d{2}-\\d{2})\\s+(\\d{4}-\\d{2}-\\d{2})/);\n if (dateMatch) {\n return { userId, startDate: dateMatch[1], endDate: dateMatch[2] };\n }\n\n // Default: current week\n const { start, end } = getWeekBounds(today);\n return { userId, startDate: start, endDate: end };\n}\n```\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n```bash\ngit add src/handlers/report.ts src/handlers/report.test.ts\ngit commit -m \"feat(reports): argument parser for /timesheet command\"\n```\n\n---\n\n## Task 10: Slack Signature Verification\n\n**Files:**\n- Create: `src/slack/verify.ts`\n- Create: `src/slack/verify.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/slack/verify.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { verifySlackSignature } from \"./verify.js\";\n\nconst SIGNING_SECRET = \"test_secret_12345\";\n\ndescribe(\"verifySlackSignature\", () => {\n it(\"returns true for valid signature\", async () => {\n const timestamp = Math.floor(Date.now() / 1000).toString();\n const body = \"token=xyzz0WbapA4vBCDEFaYZlElrm&command=%2Flogtime\";\n\n // Compute expected signature\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\", encoder.encode(SIGNING_SECRET), { name: \"HMAC\", hash: \"SHA-256\" }, false, [\"sign\"]\n );\n const sig = await crypto.subtle.sign(\"HMAC\", key, encoder.encode(`v0:${timestamp}:${body}`));\n const hex = Array.from(new Uint8Array(sig)).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n const signature = `v0=${hex}`;\n\n const result = await verifySlackSignature(body, timestamp, signature, SIGNING_SECRET);\n expect(result).toBe(true);\n });\n\n it(\"returns false for invalid signature\", async () => {\n const result = await verifySlackSignature(\"body\", \"12345\", \"v0=invalid\", SIGNING_SECRET);\n expect(result).toBe(false);\n });\n\n it(\"returns false for stale timestamp (>5 min)\", async () => {\n const staleTimestamp = (Math.floor(Date.now() / 1000) - 600).toString();\n const result = await verifySlackSignature(\"body\", staleTimestamp, \"v0=anything\", SIGNING_SECRET);\n expect(result).toBe(false);\n });\n});\n```\n\n**Step 2: Implement**\n\n```typescript\n// src/slack/verify.ts\n\nexport async function verifySlackSignature(\n body: string,\n timestamp: string,\n signature: string,\n signingSecret: string\n): Promise {\n // Reject stale requests (>5 minutes)\n const now = Math.floor(Date.now() / 1000);\n if (Math.abs(now - Number(timestamp)) > 300) {\n return false;\n }\n\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(signingSecret),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n\n const baseString = `v0:${timestamp}:${body}`;\n const sig = await crypto.subtle.sign(\"HMAC\", key, encoder.encode(baseString));\n const hex = Array.from(new Uint8Array(sig))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n const expected = `v0=${hex}`;\n\n // Constant-time comparison\n if (expected.length !== signature.length) return false;\n let mismatch = 0;\n for (let i = 0; i < expected.length; i++) {\n mismatch |= expected.charCodeAt(i) ^ signature.charCodeAt(i);\n }\n return mismatch === 0;\n}\n```\n\n**Step 3: Run tests, commit**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n```bash\ngit add src/slack/\ngit commit -m \"feat(slack): request signature verification with replay protection\"\n```\n\n---\n\n## Task 11: Block Kit Modal Builder\n\n**Files:**\n- Create: `src/slack/modals.ts`\n- Create: `src/slack/modals.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/slack/modals.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./modals.js\";\nimport type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.js\";\n\ndescribe(\"buildLogtimeModal\", () => {\n const taskTypes: TaskType[] = [{ id: 1, name: \"Transcription\" }, { id: 2, name: \"Metadata Editing\" }];\n const projects: Project[] = [{ id: 1, name: \"Lakeland\" }];\n const grants: Grant[] = [{ id: 1, code: \"NEH-PW-290261\", name: \"NEH\" }];\n\n it(\"builds a valid Block Kit modal with all dropdowns\", () => {\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\");\n\n expect(modal.type).toBe(\"modal\");\n expect(modal.title.text).toBe(\"Log Time\");\n expect(modal.submit!.text).toBe(\"Submit\");\n // Should have blocks for: date, time, task, project, grant, comment\n expect(modal.blocks.length).toBeGreaterThanOrEqual(6);\n });\n\n it(\"builds modal pre-filled for editing\", () => {\n const existing = {\n id: 42,\n date: \"2026-02-25\",\n minutes: 90,\n taskTypeId: 1,\n projectId: 1,\n grantId: 1,\n comment: \"Test\",\n };\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\", existing);\n\n // private_metadata should contain the entry ID for update\n expect(modal.private_metadata).toContain(\"42\");\n });\n});\n\ndescribe(\"buildConfirmationBlocks\", () => {\n it(\"builds confirmation message with edit/delete buttons\", () => {\n const blocks = buildConfirmationBlocks(42, \"1h\", \"Transcription\", \"Feb 26\", \"NEH-PW-290261\");\n\n // Should contain text and action buttons\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"edit\");\n expect(text).toContain(\"delete\");\n });\n});\n\ndescribe(\"buildRecentEntriesBlocks\", () => {\n it(\"builds blocks for recent entries with edit/delete buttons\", () => {\n const entries: Array = [\n {\n id: 1, slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-26\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n createdAt: \"2026-02-26T10:00:00\", taskTypeName: \"Transcription\", grantCode: null,\n },\n ];\n\n const blocks = buildRecentEntriesBlocks(entries);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"1h\");\n });\n\n it(\"shows message when no entries\", () => {\n const blocks = buildRecentEntriesBlocks([]);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"No recent entries\");\n });\n});\n```\n\n**Step 2: Implement modals.ts**\n\nThis is the largest file — Block Kit JSON is verbose. The implementation builds Slack Block Kit view objects as plain objects (no SDK dependency).\n\n```typescript\n// src/slack/modals.ts\nimport type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.js\";\nimport { formatDuration, getLast7Days } from \"../lib/format.js\";\n\ninterface ModalView {\n type: \"modal\";\n callback_id: string;\n title: { type: \"plain_text\"; text: string };\n submit?: { type: \"plain_text\"; text: string };\n blocks: unknown[];\n private_metadata?: string;\n}\n\ninterface EditPrefill {\n id: number;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\nexport function buildLogtimeModal(\n taskTypes: TaskType[],\n projects: Project[],\n grants: Grant[],\n today: string,\n prefill?: EditPrefill\n): ModalView {\n const days = getLast7Days(today);\n const timeOptions = [];\n for (let m = 15; m <= 480; m += 15) {\n timeOptions.push({ text: { type: \"plain_text\", text: formatDuration(m) }, value: String(m) });\n }\n\n return {\n type: \"modal\",\n callback_id: prefill ? \"edit_time_entry\" : \"log_time_entry\",\n title: { type: \"plain_text\", text: \"Log Time\" },\n submit: { type: \"plain_text\", text: \"Submit\" },\n private_metadata: prefill ? JSON.stringify({ entryId: prefill.id }) : undefined,\n blocks: [\n {\n type: \"input\",\n block_id: \"date_block\",\n label: { type: \"plain_text\", text: \"Date\" },\n element: {\n type: \"static_select\",\n action_id: \"date_select\",\n options: days.map((d) => ({ text: { type: \"plain_text\", text: d }, value: d })),\n ...(prefill?.date ? { initial_option: { text: { type: \"plain_text\", text: prefill.date }, value: prefill.date } } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"time_block\",\n label: { type: \"plain_text\", text: \"Time Worked\" },\n element: {\n type: \"static_select\",\n action_id: \"time_select\",\n options: timeOptions,\n ...(prefill?.minutes ? { initial_option: timeOptions.find((o) => o.value === String(prefill.minutes)) } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"task_block\",\n label: { type: \"plain_text\", text: \"Task\" },\n element: {\n type: \"static_select\",\n action_id: \"task_select\",\n options: taskTypes.map((t) => ({ text: { type: \"plain_text\", text: t.name }, value: String(t.id) })),\n ...(prefill?.taskTypeId ? { initial_option: { text: { type: \"plain_text\", text: taskTypes.find((t) => t.id === prefill.taskTypeId)?.name ?? \"\" }, value: String(prefill.taskTypeId) } } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"project_block\",\n label: { type: \"plain_text\", text: \"Project\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"project_select\",\n options: projects.map((p) => ({ text: { type: \"plain_text\", text: p.name }, value: String(p.id) })),\n },\n },\n {\n type: \"input\",\n block_id: \"grant_block\",\n label: { type: \"plain_text\", text: \"Grant\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"grant_select\",\n options: grants.map((g) => ({ text: { type: \"plain_text\", text: `${g.code} — ${g.name}` }, value: String(g.id) })),\n },\n },\n {\n type: \"input\",\n block_id: \"comment_block\",\n label: { type: \"plain_text\", text: \"Comment\" },\n optional: true,\n element: { type: \"plain_text_input\", action_id: \"comment_input\", multiline: true },\n },\n ],\n };\n}\n\nexport function buildConfirmationBlocks(\n entryId: number,\n duration: string,\n taskName: string,\n dateDisplay: string,\n grantCode: string | null\n): unknown[] {\n const grantSuffix = grantCode ? ` (${grantCode})` : \"\";\n return [\n {\n type: \"section\",\n text: { type: \"mrkdwn\", text: `Logged *${duration}* of *${taskName}* on ${dateDisplay}${grantSuffix}` },\n },\n {\n type: \"actions\",\n elements: [\n { type: \"button\", text: { type: \"plain_text\", text: \"Edit\" }, action_id: \"edit_entry\", value: String(entryId) },\n { type: \"button\", text: { type: \"plain_text\", text: \"Delete\" }, action_id: \"delete_entry\", value: String(entryId), style: \"danger\" },\n ],\n },\n ];\n}\n\nexport function buildRecentEntriesBlocks(\n entries: Array\n): unknown[] {\n if (entries.length === 0) {\n return [{ type: \"section\", text: { type: \"mrkdwn\", text: \"No recent entries found.\" } }];\n }\n\n const blocks: unknown[] = [\n { type: \"section\", text: { type: \"mrkdwn\", text: \"*Your recent entries:*\" } },\n ];\n\n for (const entry of entries) {\n const grant = entry.grantCode ? ` (${entry.grantCode})` : \"\";\n blocks.push({\n type: \"section\",\n text: { type: \"mrkdwn\", text: `${entry.date} — ${formatDuration(entry.minutes)} ${entry.taskTypeName}${grant}` },\n accessory: {\n type: \"overflow\",\n action_id: `entry_overflow_${entry.id}`,\n options: [\n { text: { type: \"plain_text\", text: \"Edit\" }, value: `edit:${entry.id}` },\n { text: { type: \"plain_text\", text: \"Delete\" }, value: `delete:${entry.id}` },\n ],\n },\n });\n }\n\n return blocks;\n}\n```\n\n**Step 3: Run all tests**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n**Step 4: Commit**\n\n```bash\ngit add src/slack/modals.ts src/slack/modals.test.ts\ngit commit -m \"feat(slack): Block Kit modal builder for time entry and confirmations\"\n```\n\n---\n\n## Task 12: Slack API Client\n\n**Files:**\n- Create: `src/slack/api.ts`\n\nThis is thin glue — no tests needed for HTTP calls. Tested via integration in Task 14.\n\n**Step 1: Implement**\n\n```typescript\n// src/slack/api.ts\n\nexport interface SlackClient {\n openModal(triggerId: string, view: unknown): Promise;\n postEphemeral(channel: string, userId: string, text: string, blocks?: unknown[]): Promise;\n sendDm(userId: string, text: string): Promise;\n}\n\nexport function createSlackClient(botToken: string): SlackClient {\n async function slackApi(method: string, body: unknown): Promise {\n const response = await fetch(`https://slack.com/api/${method}`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(body),\n });\n const data = await response.json();\n if (!data.ok) {\n throw new Error(`Slack API error (${method}): ${data.error}`);\n }\n return data;\n }\n\n return {\n async openModal(triggerId, view) {\n await slackApi(\"views.open\", { trigger_id: triggerId, view });\n },\n async postEphemeral(channel, userId, text, blocks) {\n await slackApi(\"chat.postEphemeral\", { channel, user: userId, text, blocks });\n },\n async sendDm(userId, text) {\n // Open DM channel, then send\n const conv = (await slackApi(\"conversations.open\", { users: userId })) as { channel: { id: string } };\n await slackApi(\"chat.postMessage\", { channel: conv.channel.id, text });\n },\n };\n}\n```\n\n**Step 2: Commit**\n\n```bash\ngit add src/slack/api.ts\ngit commit -m \"feat(slack): API client for modals, ephemeral messages, and DMs\"\n```\n\n---\n\n## Task 13: HTTP Router (main.ts)\n\n**Files:**\n- Create: `src/main.ts`\n\nThis wires everything together. It's the Val Town HTTP val entry point. Tested manually against Slack (Task 15).\n\n**Step 1: Implement the router**\n\n```typescript\n// src/main.ts\nimport { verifySlackSignature } from \"./slack/verify.js\";\nimport { createSlackClient, type SlackClient } from \"./slack/api.js\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./slack/modals.js\";\nimport { parseAdminCommand } from \"./handlers/admin.js\";\nimport { formatReport, parseReportArgs } from \"./handlers/report.js\";\nimport { migrate } from \"./db/schema.js\";\nimport * as queries from \"./db/queries.js\";\nimport { formatDuration } from \"./lib/format.js\";\nimport type { Database } from \"./db/types.js\";\n\n// Val Town provides these — injected at runtime\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\nlet db: Database;\nlet slack: SlackClient;\nlet migrated = false;\n\nasync function getDb(): Promise {\n if (!db) {\n // Dynamic import for Val Town runtime\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n db = sqlite;\n }\n if (!migrated) {\n await migrate(db);\n migrated = true;\n }\n return db;\n}\n\nfunction getSlack(): SlackClient {\n if (!slack) {\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) throw new Error(\"SLACK_BOT_TOKEN not set\");\n slack = createSlackClient(token);\n }\n return slack;\n}\n\nexport default async function handler(req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const body = await req.text();\n const timestamp = req.headers.get(\"x-slack-request-timestamp\") ?? \"\";\n const signature = req.headers.get(\"x-slack-signature\") ?? \"\";\n const signingSecret = Deno.env.get(\"SLACK_SIGNING_SECRET\") ?? \"\";\n\n const valid = await verifySlackSignature(body, timestamp, signature, signingSecret);\n if (!valid) {\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n // Slack sends either URL-encoded (slash commands) or JSON (interactions)\n const contentType = req.headers.get(\"content-type\") ?? \"\";\n\n if (contentType.includes(\"application/x-www-form-urlencoded\")) {\n const params = new URLSearchParams(body);\n const payload = params.get(\"payload\");\n\n if (payload) {\n // Interaction payload (modal submission, button click)\n return handleInteraction(JSON.parse(payload));\n }\n\n // Slash command\n const command = params.get(\"command\");\n const text = params.get(\"text\") ?? \"\";\n const triggerId = params.get(\"trigger_id\") ?? \"\";\n const userId = params.get(\"user_id\") ?? \"\";\n const userName = params.get(\"user_name\") ?? \"\";\n const channelId = params.get(\"channel_id\") ?? \"\";\n\n switch (command) {\n case \"/logtime\":\n return handleLogtime(text, triggerId, userId, userName, channelId);\n case \"/timesheet\":\n return handleTimesheet(text, userId, channelId);\n case \"/timesheet-admin\":\n return handleAdmin(text, userId, channelId);\n default:\n return new Response(\"Unknown command\", { status: 200 });\n }\n }\n\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleLogtime(\n text: string, triggerId: string, userId: string, userName: string, channelId: string\n): Promise {\n const database = await getDb();\n\n if (text.trim() === \"list\") {\n const entries = await queries.getRecentEntries(database, userId, 5);\n // Enrich with task type names and grant codes\n const enriched = [];\n for (const entry of entries) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const grants = await queries.getActiveGrants(database);\n const taskType = taskTypes.find((t) => t.id === entry.taskTypeId);\n const grant = entry.grantId ? grants.find((g) => g.id === entry.grantId) : null;\n enriched.push({ ...entry, taskTypeName: taskType?.name ?? \"Unknown\", grantCode: grant?.code ?? null });\n }\n\n const blocks = buildRecentEntriesBlocks(enriched);\n await getSlack().postEphemeral(channelId, userId, \"Your recent entries:\", blocks);\n return new Response(\"\", { status: 200 });\n }\n\n // Open the modal\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = new Date().toISOString().slice(0, 10);\n\n const modal = buildLogtimeModal(taskTypes, projects, grants, today);\n await getSlack().openModal(triggerId, modal);\n\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleTimesheet(text: string, userId: string, channelId: string): Promise {\n const database = await getDb();\n const today = new Date().toISOString().slice(0, 10);\n const args = parseReportArgs(text, today);\n\n const data = await queries.getReportData(database, args.startDate, args.endDate, args.userId);\n const report = formatReport(data, args.startDate, args.endDate);\n\n await getSlack().postEphemeral(channelId, userId, report);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleAdmin(text: string, userId: string, channelId: string): Promise {\n const database = await getDb();\n const cmd = parseAdminCommand(text);\n let response = \"\";\n\n switch (cmd.action) {\n case \"add\":\n if (cmd.entity === \"project\") {\n await queries.addProject(database, cmd.args[0]);\n response = `Added project: ${cmd.args[0]}`;\n } else if (cmd.entity === \"grant\") {\n await queries.addGrant(database, cmd.args[0], cmd.args[1]);\n response = `Added grant: ${cmd.args[0]} (${cmd.args[1]})`;\n } else if (cmd.entity === \"task\") {\n await queries.addTaskType(database, cmd.args[0]);\n response = `Added task type: ${cmd.args[0]}`;\n } else if (cmd.entity === \"intern\") {\n await queries.addIntern(database, cmd.args[0], cmd.args[1]);\n response = `Registered intern: @${cmd.args[1]}`;\n }\n break;\n case \"remove\":\n if (cmd.entity === \"project\") await queries.deactivateProject(database, cmd.args[0]);\n else if (cmd.entity === \"grant\") await queries.deactivateGrant(database, cmd.args[0]);\n else if (cmd.entity === \"task\") await queries.deactivateTaskType(database, cmd.args[0]);\n else if (cmd.entity === \"intern\") await queries.removeIntern(database, cmd.args[0]);\n response = `Removed ${cmd.entity}: ${cmd.args[0]}`;\n break;\n case \"list\": {\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const taskTypes = await queries.getActiveTaskTypes(database);\n const interns = await queries.getInterns(database);\n response = [\n `*Projects:* ${projects.map((p) => p.name).join(\", \") || \"none\"}`,\n `*Grants:* ${grants.map((g) => `${g.code} (${g.name})`).join(\", \") || \"none\"}`,\n `*Task Types:* ${taskTypes.map((t) => t.name).join(\", \") || \"none\"}`,\n `*Interns:* ${interns.map((i) => `@${i.slackUsername}`).join(\", \") || \"none\"}`,\n ].join(\"\\n\");\n break;\n }\n case \"reminder\":\n if (cmd.entity === \"on\" || cmd.entity === \"off\") {\n await queries.setConfig(database, \"reminder_enabled\", cmd.entity === \"on\" ? \"true\" : \"false\");\n response = `Reminders ${cmd.entity}`;\n } else if (cmd.entity === \"day\" || cmd.entity === \"time\") {\n await queries.setConfig(database, `reminder_${cmd.entity}`, cmd.args[0]);\n response = `Reminder ${cmd.entity} set to: ${cmd.args[0]}`;\n }\n break;\n case \"error\":\n response = cmd.args[0];\n break;\n }\n\n await getSlack().postEphemeral(channelId, userId, response);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleInteraction(payload: Record): Promise {\n const type = payload.type as string;\n const database = await getDb();\n\n if (type === \"view_submission\") {\n const view = payload.view as Record;\n const callbackId = view.callback_id as string;\n const values = view.state as { values: Record> };\n const user = payload.user as { id: string; username: string };\n\n const date = values.values.date_block.date_select.selected_option!.value;\n const minutes = Number(values.values.time_block.time_select.selected_option!.value);\n const taskTypeId = Number(values.values.task_block.task_select.selected_option!.value);\n const projectId = values.values.project_block.project_select.selected_option?.value\n ? Number(values.values.project_block.project_select.selected_option.value) : null;\n const grantId = values.values.grant_block.grant_select.selected_option?.value\n ? Number(values.values.grant_block.grant_select.selected_option.value) : null;\n const comment = values.values.comment_block.comment_input.value || null;\n\n if (callbackId === \"edit_time_entry\") {\n const meta = JSON.parse(view.private_metadata as string);\n await queries.updateTimeEntry(database, meta.entryId, { date, minutes, taskTypeId, projectId, grantId, comment });\n } else {\n await queries.createTimeEntry(database, {\n slackUserId: user.id, slackUsername: user.username,\n date, minutes, taskTypeId, projectId, grantId, comment,\n });\n }\n\n return new Response(JSON.stringify({ response_action: \"clear\" }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (type === \"block_actions\") {\n const actions = payload.actions as Array<{ action_id: string; value: string }>;\n const action = actions[0];\n const user = payload.user as { id: string; username: string };\n const channel = (payload.channel as { id: string })?.id;\n\n if (action.action_id === \"delete_entry\") {\n await queries.softDeleteTimeEntry(database, Number(action.value));\n if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry deleted.\");\n }\n } else if (action.action_id === \"edit_entry\") {\n const entry = await queries.getTimeEntryById(database, Number(action.value));\n if (entry) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = new Date().toISOString().slice(0, 10);\n const triggerId = (payload as Record).trigger_id;\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, {\n id: entry.id, date: entry.date, minutes: entry.minutes,\n taskTypeId: entry.taskTypeId, projectId: entry.projectId, grantId: entry.grantId, comment: entry.comment,\n });\n await getSlack().openModal(triggerId, modal);\n }\n }\n }\n\n return new Response(\"\", { status: 200 });\n}\n```\n\n**Step 2: Commit**\n\n```bash\ngit add src/main.ts\ngit commit -m \"feat: HTTP router wiring all handlers together\"\n```\n\n---\n\n## Task 14: Weekly Reminder Cron\n\n**Files:**\n- Create: `src/cron.ts`\n- Create: `src/handlers/reminder.ts`\n- Create: `src/handlers/reminder.test.ts`\n\n**Step 1: Write failing test for reminder logic**\n\n```typescript\n// src/handlers/reminder.test.ts\nimport { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"../db/test-helpers.js\";\nimport { migrate } from \"../db/schema.js\";\nimport { addIntern, addTaskType, createTimeEntry } from \"../db/queries.js\";\nimport { getInternsWithoutEntries } from \"./reminder.js\";\nimport type { Database } from \"../db/types.js\";\n\ndescribe(\"getInternsWithoutEntries\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n });\n\n it(\"returns interns who have not logged time in the date range\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n // Only maria logs time\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(1);\n expect(missing[0].slackUserId).toBe(\"U456\");\n });\n\n it(\"returns all interns when nobody logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(2);\n });\n\n it(\"returns empty when all interns logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(0);\n });\n});\n```\n\n**Step 2: Implement reminder logic**\n\n```typescript\n// src/handlers/reminder.ts\nimport type { Database } from \"../db/types.js\";\nimport type { Intern } from \"../db/queries.js\";\n\nexport async function getInternsWithoutEntries(\n db: Database,\n startDate: string,\n endDate: string\n): Promise {\n const result = await db.execute({\n sql: `SELECT i.slack_user_id, i.slack_username\n FROM interns i\n WHERE i.slack_user_id NOT IN (\n SELECT DISTINCT te.slack_user_id FROM time_entries te\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL\n )\n ORDER BY i.slack_username`,\n args: [startDate, endDate],\n });\n return result.rows.map((r) => ({ slackUserId: r[0] as string, slackUsername: r[1] as string }));\n}\n```\n\n**Step 3: Implement cron.ts (Val Town cron val)**\n\n```typescript\n// src/cron.ts\nimport { getConfig, getInterns } from \"./db/queries.js\";\nimport { getInternsWithoutEntries } from \"./handlers/reminder.js\";\nimport { getWeekBounds } from \"./lib/format.js\";\nimport { createSlackClient } from \"./slack/api.js\";\nimport { migrate } from \"./db/schema.js\";\nimport type { Database } from \"./db/types.js\";\n\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\nexport default async function reminder() {\n // Dynamic import for Val Town runtime\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n const db: Database = sqlite;\n await migrate(db);\n\n const enabled = await getConfig(db, \"reminder_enabled\");\n if (enabled === \"false\") return;\n\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) return;\n const slack = createSlackClient(token);\n\n const today = new Date().toISOString().slice(0, 10);\n const { start, end } = getWeekBounds(today);\n const missing = await getInternsWithoutEntries(db, start, end);\n\n for (const intern of missing) {\n await slack.sendDm(\n intern.slackUserId,\n `Hey! You haven't logged any time this week. Use /logtime to log your hours before end of day.`\n );\n }\n}\n```\n\n**Step 4: Run tests, commit**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n```bash\ngit add src/handlers/reminder.ts src/handlers/reminder.test.ts src/cron.ts\ngit commit -m \"feat(cron): weekly reminder for interns without time entries\"\n```\n\n---\n\n## Task 15: Val Town Deployment & Slack App Setup\n\n**This task is manual — no TDD. It's configuration and integration testing.**\n\n**Step 1: Install Val Town CLI**\n\n```bash\ndeno install -grAf jsr:@valtown/vt\nvt # authenticate\n```\n\n**Step 2: Create Val Town project**\n\n```bash\ncd /Users/trevormunoz/Code/lakeland-timesheet\nvt create lakeland-timesheet\n# Or if project already exists:\n# vt clone /lakeland-timesheet\n```\n\n**Step 3: Push code to Val Town**\n\n```bash\nvt push\n```\n\n**Step 4: Create Slack App at api.slack.com/apps**\n\n1. Create new app → \"From scratch\"\n2. Name: \"Lakeland Timesheet\"\n3. Select your workspace\n\n**Step 5: Configure OAuth scopes**\n\nBot Token Scopes: `commands`, `chat:write`, `users:read`, `im:write`\n\n**Step 6: Register slash commands**\n\nAll three point to your Val Town HTTP URL:\n- `/logtime` — \"Log time worked\"\n- `/timesheet` — \"Run a timesheet report\"\n- `/timesheet-admin` — \"Manage timesheet configuration\"\n\n**Step 7: Enable interactivity**\n\nRequest URL: same Val Town HTTP URL\n\n**Step 8: Install to workspace**\n\nCopy the Bot User OAuth Token (`xoxb-...`)\n\n**Step 9: Set Val Town environment variables**\n\nIn Val Town project settings:\n- `SLACK_BOT_TOKEN` = `xoxb-...`\n- `SLACK_SIGNING_SECRET` = (from Slack app Basic Information page)\n\n**Step 10: Set up cron val**\n\nIn Val Town, set `cron.ts` to run on schedule: `0 20 * * 5` (Friday 8pm UTC = 3pm ET)\n\n**Step 11: Seed initial data**\n\nIn Slack:\n```\n/timesheet-admin add task \"Transcription\"\n/timesheet-admin add task \"Metadata Editing\"\n/timesheet-admin add task \"Oral History\"\n/timesheet-admin add project \"Lakeland Digital Archive\"\n/timesheet-admin add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"\n/timesheet-admin reminder on\n```\n\n**Step 12: Smoke test**\n\n1. `/logtime` → verify modal opens with all dropdowns populated\n2. Submit an entry → verify confirmation with Edit/Delete buttons\n3. `/logtime list` → verify recent entries appear\n4. Edit an entry → verify modal pre-fills\n5. Delete an entry → verify it disappears from list\n6. `/timesheet` → verify report shows your entry\n7. `/timesheet-admin list` → verify all config displays\n\n**Step 13: Commit any deployment adjustments**\n\n```bash\ngit add -A && git commit -m \"chore: deployment configuration adjustments\"\n```\n\n---\n\n## Summary\n\n| Task | What | Tests |\n|------|------|-------|\n| 1 | Project scaffold, Vitest, DB abstraction | — |\n| 2 | Schema migration | 2 tests |\n| 3 | Lookup table CRUD | 6 tests |\n| 4 | Time entry CRUD | 5 tests |\n| 5 | Intern management + config | 5 tests |\n| 6 | Duration/date formatting | ~8 tests |\n| 7 | Admin command parser | 9 tests |\n| 8 | Report query + formatter | 4 tests |\n| 9 | Report argument parser | 4 tests |\n| 10 | Slack signature verification | 3 tests |\n| 11 | Block Kit modal builder | 4 tests |\n| 12 | Slack API client (thin glue) | — |\n| 13 | HTTP router (main.ts) | — |\n| 14 | Weekly reminder cron | 3 tests |\n| 15 | Deployment + Slack app setup | Manual smoke test |\n\n**Total: ~53 automated tests, 15 tasks, ~15 commits**\n",[],[661,668,684],[661,668],[661],{"_106":694,"_97":695,"_160":696,"_162":-5,"_163":145,"_164":697,"_166":167,"_108":698,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":699,"_100":754},"9eba3b46-130b-11f1-8d22-42dde27851f2","handlers","9eba3bfa-130b-11f1-8d22-42dde27851f2",4,["D",1772107605369],[700,709,718,727,736,745],{"_106":701,"_97":702,"_160":703,"_162":696,"_163":145,"_164":704,"_166":167,"_108":705,"_102":608,"_169":609,"_171":706,"_172":22,"_173":-5,"_174":707,"_100":708},"4779535a-130e-11f1-bb59-42dde27851f2","admin.test.ts","9f4014c8-130b-11f1-aa87-42dde27851f2",39,["D",1772108747466],"import { describe, it, expect } from \"vitest\";\nimport { parseAdminCommand } from \"./admin.ts\";\n\ndescribe(\"parseAdminCommand\", () => {\n it(\"parses add project\", () => {\n expect(parseAdminCommand('add project \"Community Oral Histories\"'))\n .toEqual({ action: \"add\", entity: \"project\", args: [\"Community Oral Histories\"] });\n });\n\n it(\"parses add grant with code and name\", () => {\n expect(parseAdminCommand('add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"'))\n .toEqual({ action: \"add\", entity: \"grant\", args: [\"NEH-PW-290261\", \"NEH Preservation & Access\"] });\n });\n\n it(\"parses add task\", () => {\n expect(parseAdminCommand('add task \"Scanning\"'))\n .toEqual({ action: \"add\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses remove task\", () => {\n expect(parseAdminCommand('remove task \"Scanning\"'))\n .toEqual({ action: \"remove\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses list\", () => {\n expect(parseAdminCommand(\"list\"))\n .toEqual({ action: \"list\", entity: null, args: [] });\n });\n\n it(\"parses intern add with user mention\", () => {\n expect(parseAdminCommand(\"intern add <@U123|maria>\"))\n .toEqual({ action: \"add\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses intern remove\", () => {\n expect(parseAdminCommand(\"intern remove <@U123|maria>\"))\n .toEqual({ action: \"remove\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses reminder config\", () => {\n expect(parseAdminCommand(\"reminder day friday\"))\n .toEqual({ action: \"reminder\", entity: \"day\", args: [\"friday\"] });\n expect(parseAdminCommand(\"reminder off\"))\n .toEqual({ action: \"reminder\", entity: \"off\", args: [] });\n });\n\n it(\"returns error for unrecognized commands\", () => {\n expect(parseAdminCommand(\"do something weird\"))\n .toEqual({ action: \"error\", entity: null, args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"] });\n });\n});\n",[],[695,702],{"_106":710,"_97":711,"_160":712,"_162":696,"_163":145,"_164":713,"_166":167,"_108":714,"_102":608,"_169":609,"_171":715,"_172":22,"_173":-5,"_174":716,"_100":717},"d63358a4-1320-11f1-96f1-42dde27851f2","admin.ts","9f3025f4-130b-11f1-bab2-42dde27851f2",54,["D",1772116717865],"export interface AdminCommand {\n action: string;\n entity: string | null;\n args: string[];\n}\n\nexport function parseAdminCommand(text: string): AdminCommand {\n const trimmed = text.trim();\n\n // \"list\"\n if (trimmed === \"list\") {\n return { action: \"list\", entity: null, args: [] };\n }\n\n // \"reminder day friday\" / \"reminder off\" / \"reminder on\" / \"reminder time 15:00\"\n const reminderMatch = trimmed.match(/^reminder\\s+(\\S+)(?:\\s+(.+))?$/);\n if (reminderMatch) {\n const subcommand = reminderMatch[1];\n const value = reminderMatch[2];\n return { action: \"reminder\", entity: subcommand, args: value ? [value] : [] };\n }\n\n // \"intern add <@U123|maria>\" / \"intern remove <@U123|maria>\"\n const internMatch = trimmed.match(/^intern\\s+(add|remove)\\s+<@(\\w+)\\|([^>]+)>/);\n if (internMatch) {\n return { action: internMatch[1], entity: \"intern\", args: [internMatch[2], internMatch[3]] };\n }\n\n // \"add project \"Name\"\" / \"remove task \"Name\"\"\n const crudMatch = trimmed.match(/^(add|remove)\\s+(project|grant|task)\\s+(.+)$/);\n if (crudMatch) {\n const action = crudMatch[1];\n const entity = crudMatch[2];\n const rawArgs = crudMatch[3];\n\n // Extract quoted strings (handle straight and smart/curly quotes from Slack)\n const normalized = rawArgs.replace(/[\\u201c\\u201d\\u2018\\u2019]/g, '\"');\n const quoted = [...normalized.matchAll(/\"([^\"]+)\"/g)].map((m) => m[1]);\n if (quoted.length > 0) {\n return { action, entity, args: quoted };\n }\n return { action, entity, args: [rawArgs.trim()] };\n }\n\n return {\n action: \"error\",\n entity: null,\n args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"],\n };\n}\n",[],[695,711],{"_106":719,"_97":720,"_160":721,"_162":696,"_163":145,"_164":722,"_166":167,"_108":723,"_102":599,"_169":609,"_171":724,"_172":22,"_173":-5,"_174":725,"_100":726},"9837f044-130e-11f1-a0d0-42dde27851f2","reminder.test.ts","9f2ae922-130b-11f1-aa87-42dde27851f2",44,["D",1772108882845],"import { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"../db/test-helpers.ts\";\nimport { migrate } from \"../db/schema.ts\";\nimport { addIntern, addTaskType, createTimeEntry } from \"../db/queries.ts\";\nimport { getInternsWithoutEntries } from \"./reminder.ts\";\nimport type { Database } from \"../db/types.ts\";\n\ndescribe(\"getInternsWithoutEntries\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n });\n\n it(\"returns interns who have not logged time in the date range\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(1);\n expect(missing[0].slackUserId).toBe(\"U456\");\n });\n\n it(\"returns all interns when nobody logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(2);\n });\n\n it(\"returns empty when all interns logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(0);\n });\n});\n",[],[695,720],{"_106":728,"_97":729,"_160":730,"_162":696,"_163":145,"_164":731,"_166":167,"_108":732,"_102":599,"_169":609,"_171":733,"_172":22,"_173":-5,"_174":734,"_100":735},"98ea8844-130e-11f1-89cd-42dde27851f2","reminder.ts","9f1deff6-130b-11f1-8acc-42dde27851f2",47,["D",1772108882817],"import type { Database } from \"../db/types.ts\";\nimport type { Intern } from \"../db/queries.ts\";\n\nexport async function getInternsWithoutEntries(\n db: Database,\n startDate: string,\n endDate: string\n): Promise {\n const result = await db.execute({\n sql: `SELECT i.slack_user_id, i.slack_username\n FROM interns i\n WHERE i.slack_user_id NOT IN (\n SELECT DISTINCT te.slack_user_id FROM time_entries te\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL\n )\n ORDER BY i.slack_username`,\n args: [startDate, endDate],\n });\n return result.rows.map((r) => ({ slackUserId: r[0] as string, slackUsername: r[1] as string }));\n}\n",[],[695,729],{"_106":737,"_97":738,"_160":739,"_162":696,"_163":145,"_164":740,"_166":167,"_108":741,"_102":599,"_169":609,"_171":742,"_172":22,"_173":-5,"_174":743,"_100":744},"98934dea-130e-11f1-adc1-42dde27851f2","report.test.ts","9f39052a-130b-11f1-8acc-42dde27851f2",46,["D",1772108882901],"import { describe, it, expect } from \"vitest\";\nimport { formatReport, parseReportArgs } from \"./report.ts\";\nimport type { ReportRow } from \"../db/queries.ts\";\n\ndescribe(\"formatReport\", () => {\n it(\"formats a multi-user report\", () => {\n const data: ReportRow[] = [\n { slackUserId: \"U456\", slackUsername: \"james\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 480 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Metadata Editing\", grantCode: null, totalMinutes: 360 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 720 },\n ];\n\n const output = formatReport(data, \"2026-02-24\", \"2026-02-28\");\n\n expect(output).toContain(\"Feb 24 – Feb 28, 2026\");\n expect(output).toContain(\"james\");\n expect(output).toContain(\"maria\");\n expect(output).toContain(\"8h\"); // james total\n expect(output).toContain(\"18h\"); // maria total\n expect(output).toContain(\"26h\"); // grand total\n expect(output).toContain(\"NEH-PW-290261\");\n });\n\n it(\"handles empty data\", () => {\n const output = formatReport([], \"2026-02-24\", \"2026-02-28\");\n expect(output).toContain(\"No time entries\");\n });\n});\n\ndescribe(\"parseReportArgs\", () => {\n it(\"defaults to current week, all users\", () => {\n const result = parseReportArgs(\"\", \"2026-02-26\");\n expect(result.userId).toBeNull();\n expect(result.startDate).toBe(\"2026-02-23\"); // Monday\n expect(result.endDate).toBe(\"2026-03-01\"); // Sunday\n });\n\n it(\"parses user mention\", () => {\n const result = parseReportArgs(\"<@U123|maria>\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n });\n\n it(\"parses date range\", () => {\n const result = parseReportArgs(\"2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n\n it(\"parses user + date range\", () => {\n const result = parseReportArgs(\"<@U123|maria> 2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n});\n",[],[695,738],{"_106":746,"_97":747,"_160":748,"_162":696,"_163":145,"_164":749,"_166":167,"_108":750,"_102":599,"_169":609,"_171":751,"_172":22,"_173":-5,"_174":752,"_100":753},"982461a0-130e-11f1-adc1-42dde27851f2","report.ts","9f2180d0-130b-11f1-bab2-42dde27851f2",43,["D",1772108882809],"import type { ReportRow } from \"../db/queries.ts\";\nimport { formatDuration, formatDateRange, getWeekBounds } from \"../lib/format.ts\";\n\nexport interface ReportArgs {\n userId: string | null;\n startDate: string;\n endDate: string;\n}\n\nexport function parseReportArgs(text: string, today: string): ReportArgs {\n const trimmed = text.trim();\n let userId: string | null = null;\n\n // Extract user mention\n let remaining = trimmed;\n const userMatch = remaining.match(/<@(\\w+)\\|[^>]+>/);\n if (userMatch) {\n userId = userMatch[1];\n remaining = remaining.replace(userMatch[0], \"\").trim();\n }\n\n // Extract dates\n const dateMatch = remaining.match(/(\\d{4}-\\d{2}-\\d{2})\\s+(\\d{4}-\\d{2}-\\d{2})/);\n if (dateMatch) {\n return { userId, startDate: dateMatch[1], endDate: dateMatch[2] };\n }\n\n // Default: current week\n const { start, end } = getWeekBounds(today);\n return { userId, startDate: start, endDate: end };\n}\n\nexport function formatReport(data: ReportRow[], startDate: string, endDate: string): string {\n const header = `*Timesheet Report: ${formatDateRange(startDate, endDate)}*\\n`;\n\n if (data.length === 0) {\n return header + \"\\nNo time entries found for this period.\";\n }\n\n // Group by user\n const byUser = new Map();\n for (const row of data) {\n if (!byUser.has(row.slackUserId)) {\n byUser.set(row.slackUserId, { username: row.slackUsername, rows: [], total: 0 });\n }\n const user = byUser.get(row.slackUserId)!;\n user.rows.push(row);\n user.total += row.totalMinutes;\n }\n\n let grandTotal = 0;\n const lines: string[] = [header];\n\n for (const [, user] of byUser) {\n grandTotal += user.total;\n lines.push(`*@${user.username}* — ${formatDuration(user.total)}`);\n for (const row of user.rows) {\n const grant = row.grantCode ? ` (${row.grantCode})` : \"\";\n lines.push(` ${row.taskTypeName} ${formatDuration(row.totalMinutes)}${grant}`);\n }\n lines.push(\"\");\n }\n\n lines.push(`*Total: ${formatDuration(grandTotal)} across ${byUser.size} intern${byUser.size === 1 ? \"\" : \"s\"}*`);\n\n return lines.join(\"\\n\");\n}\n",[],[695,747],[695],{"_106":756,"_97":757,"_160":758,"_162":-5,"_163":145,"_164":608,"_166":167,"_108":759,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":760,"_100":779},"9e8bb942-130b-11f1-a4f6-42dde27851f2","lib","9e8bba00-130b-11f1-a4f6-42dde27851f2",["D",1772107605064],[761,770],{"_106":762,"_97":763,"_160":764,"_162":758,"_163":145,"_164":765,"_166":22,"_108":766,"_102":608,"_169":609,"_171":767,"_172":22,"_173":-5,"_174":768,"_100":769},"47499caa-130e-11f1-bb59-42dde27851f2","format.test.ts","9f33d7bc-130b-11f1-882b-42dde27851f2",32,["D",1772108746989],"import { describe, it, expect } from \"vitest\";\nimport { formatDuration, formatDateRange, getWeekBounds, getLast7Days, todayInTimezone } from \"./format.ts\";\n\ndescribe(\"todayInTimezone\", () => {\n it(\"returns a valid ISO date string\", () => {\n const today = todayInTimezone(\"America/New_York\");\n expect(today).toMatch(/^\\d{4}-\\d{2}-\\d{2}$/);\n });\n});\n\ndescribe(\"formatDuration\", () => {\n it(\"formats minutes as hours and minutes\", () => {\n expect(formatDuration(60)).toBe(\"1h\");\n expect(formatDuration(90)).toBe(\"1h 30m\");\n expect(formatDuration(15)).toBe(\"15m\");\n expect(formatDuration(480)).toBe(\"8h\");\n expect(formatDuration(0)).toBe(\"0m\");\n });\n});\n\ndescribe(\"formatDateRange\", () => {\n it(\"formats a date range for display\", () => {\n expect(formatDateRange(\"2026-02-24\", \"2026-02-28\")).toBe(\"Feb 24 – Feb 28, 2026\");\n });\n\n it(\"handles cross-month ranges\", () => {\n expect(formatDateRange(\"2026-01-28\", \"2026-02-03\")).toBe(\"Jan 28 – Feb 3, 2026\");\n });\n});\n\ndescribe(\"getWeekBounds\", () => {\n it(\"returns Monday–Sunday for a given date\", () => {\n // Feb 26 2026 is a Thursday\n const { start, end } = getWeekBounds(\"2026-02-26\");\n expect(start).toBe(\"2026-02-23\"); // Monday\n expect(end).toBe(\"2026-03-01\"); // Sunday\n });\n});\n\ndescribe(\"getLast7Days\", () => {\n it(\"returns last 7 days in descending order\", () => {\n const days = getLast7Days(\"2026-02-26\");\n expect(days).toHaveLength(7);\n expect(days[0]).toBe(\"2026-02-26\");\n expect(days[6]).toBe(\"2026-02-20\");\n });\n});\n",[],[757,763],{"_106":771,"_97":772,"_160":773,"_162":758,"_163":145,"_164":774,"_166":22,"_108":775,"_102":33,"_169":609,"_171":776,"_172":22,"_173":-5,"_174":777,"_100":778},"9ed083ba-130b-11f1-8e57-42dde27851f2","format.ts","9ed0848c-130b-11f1-8e57-42dde27851f2",6,["D",1772107605513],"export function todayInTimezone(tz: string = \"America/New_York\"): string {\n return new Intl.DateTimeFormat(\"en-CA\", { timeZone: tz }).format(new Date());\n // en-CA locale gives YYYY-MM-DD format\n}\n\nexport function formatDuration(minutes: number): string {\n const hours = Math.floor(minutes / 60);\n const mins = minutes % 60;\n if (hours === 0) return `${mins}m`;\n if (mins === 0) return `${hours}h`;\n return `${hours}h ${mins}m`;\n}\n\nconst MONTHS = [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"];\n\nexport function formatDateRange(start: string, end: string): string {\n const s = new Date(start + \"T00:00:00\");\n const e = new Date(end + \"T00:00:00\");\n return `${MONTHS[s.getMonth()]} ${s.getDate()} \\u2013 ${MONTHS[e.getMonth()]} ${e.getDate()}, ${e.getFullYear()}`;\n}\n\nexport function getWeekBounds(dateStr: string): { start: string; end: string } {\n const date = new Date(dateStr + \"T00:00:00\");\n const day = date.getDay(); // 0=Sun, 1=Mon...\n const diffToMonday = day === 0 ? -6 : 1 - day;\n const monday = new Date(date);\n monday.setDate(date.getDate() + diffToMonday);\n const sunday = new Date(monday);\n sunday.setDate(monday.getDate() + 6);\n return {\n start: monday.toISOString().slice(0, 10),\n end: sunday.toISOString().slice(0, 10),\n };\n}\n\nexport function getLast7Days(fromDate: string): string[] {\n const days: string[] = [];\n const date = new Date(fromDate + \"T00:00:00\");\n for (let i = 0; i < 7; i++) {\n const d = new Date(date);\n d.setDate(date.getDate() - i);\n days.push(d.toISOString().slice(0, 10));\n }\n return days;\n}\n",[],[757,772],[757],{"_106":781,"_97":782,"_160":783,"_162":-5,"_163":145,"_164":784,"_166":167,"_108":785,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":786,"_100":833},"9ead4e86-130b-11f1-8d22-42dde27851f2","slack","9ead4f62-130b-11f1-8d22-42dde27851f2",3,["D",1772107605282],[787,796,805,815,824],{"_106":788,"_97":789,"_160":790,"_162":783,"_163":145,"_164":791,"_166":22,"_108":792,"_102":608,"_169":609,"_171":793,"_172":22,"_173":-5,"_174":794,"_100":795},"8591f1c8-1323-11f1-ae64-42dde27851f2","api.ts","9f0e25c6-130b-11f1-8e57-42dde27851f2",57,["D",1772117871080],"export interface SlackClient {\n openModal(triggerId: string, view: unknown): Promise;\n postEphemeral(channel: string, userId: string, text: string, blocks?: unknown[]): Promise;\n sendDm(userId: string, text: string): Promise;\n}\n\nexport function createSlackClient(botToken: string): SlackClient {\n async function slackApi(method: string, body: unknown): Promise {\n const response = await fetch(`https://slack.com/api/${method}`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(body),\n });\n const data = await response.json();\n if (!data.ok) {\n console.error(`Slack API error (${method}):`, JSON.stringify(data));\n throw new Error(`Slack API error (${method}): ${data.error}`);\n }\n return data;\n }\n\n return {\n async openModal(triggerId, view) {\n await slackApi(\"views.open\", { trigger_id: triggerId, view });\n },\n async postEphemeral(channel, userId, text, blocks) {\n await slackApi(\"chat.postEphemeral\", { channel, user: userId, text, blocks });\n },\n async sendDm(userId, text) {\n const conv = (await slackApi(\"conversations.open\", { users: userId })) as { channel: { id: string } };\n await slackApi(\"chat.postMessage\", { channel: conv.channel.id, text });\n },\n };\n}\n",[],[782,789],{"_106":797,"_97":798,"_160":799,"_162":783,"_163":145,"_164":800,"_166":167,"_108":801,"_102":599,"_169":609,"_171":802,"_172":22,"_173":-5,"_174":803,"_100":804},"98895470-130e-11f1-ba19-42dde27851f2","modals.test.ts","9f19dac4-130b-11f1-aa87-42dde27851f2",45,["D",1772108882814],"import { describe, it, expect } from \"vitest\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./modals.ts\";\nimport type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.ts\";\n\ndescribe(\"buildLogtimeModal\", () => {\n const taskTypes: TaskType[] = [{ id: 1, name: \"Transcription\" }, { id: 2, name: \"Metadata Editing\" }];\n const projects: Project[] = [{ id: 1, name: \"Lakeland\" }];\n const grants: Grant[] = [{ id: 1, code: \"NEH-PW-290261\", name: \"NEH\" }];\n\n it(\"builds a valid Block Kit modal with all dropdowns\", () => {\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\");\n\n expect(modal.type).toBe(\"modal\");\n expect(modal.title.text).toBe(\"Log Time\");\n expect(modal.submit!.text).toBe(\"Submit\");\n // Should have blocks for: date, time, task, project, grant, comment\n expect(modal.blocks.length).toBeGreaterThanOrEqual(6);\n });\n\n it(\"builds modal pre-filled for editing\", () => {\n const existing = {\n id: 42,\n date: \"2026-02-25\",\n minutes: 90,\n taskTypeId: 1,\n projectId: 1,\n grantId: 1,\n comment: \"Test\",\n };\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\", existing);\n\n // private_metadata should contain the entry ID for update\n expect(modal.private_metadata).toContain(\"42\");\n });\n});\n\ndescribe(\"buildConfirmationBlocks\", () => {\n it(\"builds confirmation message with edit/delete buttons\", () => {\n const blocks = buildConfirmationBlocks(42, \"1h\", \"Transcription\", \"Feb 26\", \"NEH-PW-290261\");\n\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"edit\");\n expect(text).toContain(\"delete\");\n });\n});\n\ndescribe(\"buildRecentEntriesBlocks\", () => {\n it(\"builds blocks for recent entries with edit/delete buttons\", () => {\n const entries: Array = [\n {\n id: 1, slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-26\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n createdAt: \"2026-02-26T10:00:00\", taskTypeName: \"Transcription\", grantCode: null,\n },\n ];\n\n const blocks = buildRecentEntriesBlocks(entries);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"1h\");\n });\n\n it(\"shows message when no entries\", () => {\n const blocks = buildRecentEntriesBlocks([]);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"No recent entries\");\n });\n});\n",[],[782,798],{"_106":806,"_97":807,"_160":808,"_162":783,"_163":145,"_164":809,"_166":22,"_108":810,"_102":811,"_169":609,"_171":812,"_172":22,"_173":-5,"_174":813,"_100":814},"4da7e3fe-1327-11f1-b368-42dde27851f2","modals.ts","9f08bdb6-130b-11f1-8d22-42dde27851f2",66,["D",1772119495245],7,"import type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.ts\";\nimport { formatDuration } from \"../lib/format.ts\";\n\ninterface ModalView {\n type: \"modal\";\n callback_id: string;\n title: { type: \"plain_text\"; text: string };\n submit?: { type: \"plain_text\"; text: string };\n blocks: unknown[];\n private_metadata?: string;\n}\n\ninterface EditPrefill {\n id: number;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\ninterface UserDefaults {\n projectId: number | null;\n grantId: number | null;\n}\n\nexport function buildLogtimeModal(\n taskTypes: TaskType[],\n projects: Project[],\n grants: Grant[],\n today: string,\n prefill?: EditPrefill,\n defaults?: UserDefaults\n): ModalView {\n const timeOptions = [];\n for (let h = 0; h <= 12; h++) {\n for (const m of [0, 15, 30, 45]) {\n const total = h * 60 + m;\n if (total === 0) continue;\n timeOptions.push({\n text: { type: \"plain_text\", text: formatDuration(total) },\n value: String(total),\n });\n }\n }\n\n return {\n type: \"modal\",\n callback_id: prefill ? \"edit_time_entry\" : \"log_time_entry\",\n title: { type: \"plain_text\", text: \"Log Time\" },\n submit: { type: \"plain_text\", text: \"Submit\" },\n private_metadata: prefill ? JSON.stringify({ entryId: prefill.id }) : undefined,\n blocks: [\n {\n type: \"input\",\n block_id: \"date_block\",\n label: { type: \"plain_text\", text: \"Date\" },\n element: {\n type: \"datepicker\",\n action_id: \"date_select\",\n initial_date: prefill?.date ?? today,\n placeholder: { type: \"plain_text\", text: \"Choose a date\" },\n },\n },\n {\n type: \"input\",\n block_id: \"time_block\",\n label: { type: \"plain_text\", text: \"Time Worked\" },\n element: {\n type: \"static_select\",\n action_id: \"time_select\",\n options: timeOptions,\n placeholder: { type: \"plain_text\", text: \"Select duration\" },\n ...(prefill?.minutes ? { initial_option: timeOptions.find((o) => o.value === String(prefill.minutes)) } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"task_block\",\n label: { type: \"plain_text\", text: \"Task\" },\n element: {\n type: \"static_select\",\n action_id: \"task_select\",\n options: taskTypes.map((t) => ({ text: { type: \"plain_text\", text: t.name }, value: String(t.id) })),\n ...(prefill?.taskTypeId ? { initial_option: { text: { type: \"plain_text\", text: taskTypes.find((t) => t.id === prefill.taskTypeId)?.name ?? \"\" }, value: String(prefill.taskTypeId) } } : {}),\n },\n },\n ...(projects.length > 0 ? [(() => {\n const selectedProjectId = prefill?.projectId ?? defaults?.projectId;\n const selectedProject = selectedProjectId ? projects.find((p) => p.id === selectedProjectId) : null;\n return {\n type: \"input\",\n block_id: \"project_block\",\n label: { type: \"plain_text\", text: \"Project\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"project_select\",\n options: projects.map((p) => ({ text: { type: \"plain_text\", text: p.name }, value: String(p.id) })),\n ...(selectedProject ? { initial_option: { text: { type: \"plain_text\", text: selectedProject.name }, value: String(selectedProject.id) } } : {}),\n },\n };\n })()] : []),\n ...(grants.length > 0 ? [(() => {\n const selectedGrantId = prefill?.grantId ?? defaults?.grantId;\n const selectedGrant = selectedGrantId ? grants.find((g) => g.id === selectedGrantId) : null;\n return {\n type: \"input\",\n block_id: \"grant_block\",\n label: { type: \"plain_text\", text: \"Grant\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"grant_select\",\n options: grants.map((g) => ({ text: { type: \"plain_text\", text: `${g.code} — ${g.name}` }, value: String(g.id) })),\n ...(selectedGrant ? { initial_option: { text: { type: \"plain_text\", text: `${selectedGrant.code} — ${selectedGrant.name}` }, value: String(selectedGrant.id) } } : {}),\n },\n };\n })()] : []),\n {\n type: \"input\",\n block_id: \"comment_block\",\n label: { type: \"plain_text\", text: \"Comment\" },\n optional: true,\n element: {\n type: \"plain_text_input\",\n action_id: \"comment_input\",\n multiline: true,\n placeholder: { type: \"plain_text\", text: \"What did you work on?\" },\n ...(prefill?.comment ? { initial_value: prefill.comment } : {}),\n },\n },\n ],\n };\n}\n\nexport function buildConfirmationBlocks(\n entryId: number,\n duration: string,\n taskName: string,\n dateDisplay: string,\n grantCode: string | null\n): unknown[] {\n const grantSuffix = grantCode ? ` (${grantCode})` : \"\";\n return [\n {\n type: \"section\",\n text: { type: \"mrkdwn\", text: `Logged *${duration}* of *${taskName}* on ${dateDisplay}${grantSuffix}` },\n },\n {\n type: \"actions\",\n elements: [\n { type: \"button\", text: { type: \"plain_text\", text: \"Edit\" }, action_id: \"edit_entry\", value: String(entryId) },\n { type: \"button\", text: { type: \"plain_text\", text: \"Delete\" }, action_id: \"delete_entry\", value: String(entryId), style: \"danger\" },\n ],\n },\n ];\n}\n\nexport function buildRecentEntriesBlocks(\n entries: Array\n): unknown[] {\n if (entries.length === 0) {\n return [{ type: \"section\", text: { type: \"mrkdwn\", text: \"No recent entries found.\" } }];\n }\n\n const blocks: unknown[] = [\n { type: \"section\", text: { type: \"mrkdwn\", text: \"*Your recent entries:*\" } },\n ];\n\n for (const entry of entries) {\n const grant = entry.grantCode ? ` (${entry.grantCode})` : \"\";\n blocks.push({\n type: \"section\",\n text: { type: \"mrkdwn\", text: `${entry.date} — ${formatDuration(entry.minutes)} ${entry.taskTypeName}${grant}` },\n accessory: {\n type: \"overflow\",\n action_id: `entry_overflow_${entry.id}`,\n options: [\n { text: { type: \"plain_text\", text: \"Edit\" }, value: `edit:${entry.id}` },\n { text: { type: \"plain_text\", text: \"Delete\" }, value: `delete:${entry.id}` },\n ],\n },\n });\n }\n\n return blocks;\n}\n",[],[782,807],{"_106":816,"_97":817,"_160":818,"_162":783,"_163":145,"_164":819,"_166":167,"_108":820,"_102":608,"_169":609,"_171":821,"_172":22,"_173":-5,"_174":822,"_100":823},"4760902c-130e-11f1-a952-42dde27851f2","verify.test.ts","9f263710-130b-11f1-8f11-42dde27851f2",35,["D",1772108747272],"import { describe, it, expect } from \"vitest\";\nimport { verifySlackSignature } from \"./verify.ts\";\n\nconst SIGNING_SECRET = \"test_secret_12345\";\n\ndescribe(\"verifySlackSignature\", () => {\n it(\"returns true for valid signature\", async () => {\n const timestamp = Math.floor(Date.now() / 1000).toString();\n const body = \"token=xyzz0WbapA4vBCDEFaYZlElrm&command=%2Flogtime\";\n\n // Compute expected signature\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(SIGNING_SECRET),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n const sig = await crypto.subtle.sign(\n \"HMAC\",\n key,\n encoder.encode(`v0:${timestamp}:${body}`)\n );\n const hex = Array.from(new Uint8Array(sig))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n const signature = `v0=${hex}`;\n\n const result = await verifySlackSignature(\n body,\n timestamp,\n signature,\n SIGNING_SECRET\n );\n expect(result).toBe(true);\n });\n\n it(\"returns false for invalid signature\", async () => {\n const result = await verifySlackSignature(\n \"body\",\n String(Math.floor(Date.now() / 1000)),\n \"v0=invalid\",\n SIGNING_SECRET\n );\n expect(result).toBe(false);\n });\n\n it(\"returns false for stale timestamp (>5 min)\", async () => {\n const staleTimestamp = (Math.floor(Date.now() / 1000) - 600).toString();\n const result = await verifySlackSignature(\n \"body\",\n staleTimestamp,\n \"v0=anything\",\n SIGNING_SECRET\n );\n expect(result).toBe(false);\n });\n});\n",[],[782,817],{"_106":825,"_97":826,"_160":827,"_162":783,"_163":145,"_164":828,"_166":167,"_108":829,"_102":33,"_169":609,"_171":830,"_172":22,"_173":-5,"_174":831,"_100":832},"9f123e86-130b-11f1-bab2-42dde27851f2","verify.ts","9f123fe4-130b-11f1-bab2-42dde27851f2",16,["D",1772107605833],"export async function verifySlackSignature(\n body: string,\n timestamp: string,\n signature: string,\n signingSecret: string\n): Promise {\n // Reject stale requests (>5 minutes)\n const now = Math.floor(Date.now() / 1000);\n if (Math.abs(now - Number(timestamp)) > 300) {\n return false;\n }\n\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(signingSecret),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n\n const baseString = `v0:${timestamp}:${body}`;\n const sig = await crypto.subtle.sign(\"HMAC\", key, encoder.encode(baseString));\n const hex = Array.from(new Uint8Array(sig))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n const expected = `v0=${hex}`;\n\n // Constant-time comparison\n if (expected.length !== signature.length) return false;\n let mismatch = 0;\n for (let i = 0; i < expected.length; i++) {\n mismatch |= expected.charCodeAt(i) ^ signature.charCodeAt(i);\n }\n return mismatch === 0;\n}\n",[],[782,826],[782],{"_106":835,"_97":836,"_160":837,"_162":-5,"_163":145,"_164":838,"_166":167,"_108":839,"_102":33,"_169":284,"_171":840,"_172":22,"_173":-5,"_174":841,"_100":842},"d9114d04-131d-11f1-99f1-42dde27851f2",".env.example","d9114dfe-131d-11f1-99f1-42dde27851f2",51,["D",1772115434189],"# Slack App Credentials — get these from https://api.slack.com/apps\n# Bot User OAuth Token (OAuth & Permissions → Install to Workspace)\nSLACK_BOT_TOKEN=xoxb-your-token-here\n\n# Signing Secret (Basic Information → App Credentials)\nSLACK_SIGNING_SECRET=your-signing-secret-here\n\n# Comma-separated Slack user IDs allowed to use /admin-timesheet\n# Find your ID: Slack profile → \"...\" → Copy member ID\nADMIN_USER_IDS=U0000000000\n",[],[836],{"_106":844,"_97":845,"_160":846,"_162":-5,"_163":145,"_164":847,"_166":22,"_108":848,"_102":33,"_169":284,"_171":849,"_172":22,"_173":-5,"_174":850,"_100":851},"d9075a24-131d-11f1-8e84-42dde27851f2",".gitignore","d9075cd6-131d-11f1-8e84-42dde27851f2",50,["D",1772115434124],".env\n.vt/\n",[],[845],{"_106":853,"_97":854,"_160":855,"_162":-5,"_163":145,"_164":856,"_166":167,"_108":857,"_102":608,"_169":858,"_171":859,"_172":22,"_173":-5,"_174":860,"_100":861},"472ee950-130e-11f1-a952-42dde27851f2","cron.ts","9ed4376c-130b-11f1-8f11-42dde27851f2",27,["D",1772108746979],"interval","// src/cron.ts\nimport { getConfig } from \"./db/queries.ts\";\nimport { getInternsWithoutEntries } from \"./handlers/reminder.ts\";\nimport { getWeekBounds, todayInTimezone } from \"./lib/format.ts\";\nimport { createSlackClient } from \"./slack/api.ts\";\nimport { migrate } from \"./db/schema.ts\";\nimport type { Database } from \"./db/types.ts\";\n\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\nexport default async function reminder() {\n // Val Town provides SQLite via this import\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n const db: Database = sqlite;\n await migrate(db);\n\n const enabled = await getConfig(db, \"reminder_enabled\");\n if (enabled === \"false\") return;\n\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) return;\n const slack = createSlackClient(token);\n\n const today = todayInTimezone();\n const { start, end } = getWeekBounds(today);\n const missing = await getInternsWithoutEntries(db, start, end);\n\n for (const intern of missing) {\n try {\n await slack.sendDm(\n intern.slackUserId,\n `Hey! You haven't logged any time this week. Use /logtime to log your hours before end of day.`\n );\n } catch (error) {\n console.error(`Failed to send reminder to ${intern.slackUsername}:`, error);\n }\n }\n}\n",[],[854],{"_106":863,"_97":864,"_160":865,"_162":-5,"_163":145,"_164":866,"_166":22,"_108":867,"_102":868,"_169":869,"_171":870,"_172":22,"_173":-5,"_174":871,"_100":872},"4da44708-1327-11f1-8e31-42dde27851f2","main.ts","9ecb8054-130b-11f1-8d22-42dde27851f2",65,["D",1772119495232],11,"http","// src/main.ts\nimport { verifySlackSignature } from \"./slack/verify.ts\";\nimport { createSlackClient, type SlackClient } from \"./slack/api.ts\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./slack/modals.ts\";\nimport { parseAdminCommand } from \"./handlers/admin.ts\";\nimport { formatReport, parseReportArgs } from \"./handlers/report.ts\";\nimport { migrate } from \"./db/schema.ts\";\nimport * as queries from \"./db/queries.ts\";\nimport { formatDuration, todayInTimezone } from \"./lib/format.ts\";\nimport type { Database } from \"./db/types.ts\";\n\n// Val Town runtime globals\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\n// Environment variables:\n// SLACK_BOT_TOKEN - Slack bot OAuth token\n// SLACK_SIGNING_SECRET - Slack request signing secret\n// ADMIN_USER_IDS - Comma-separated Slack user IDs allowed to use /timesheet-admin\nconst ADMIN_USER_IDS = new Set(\n (Deno.env.get(\"ADMIN_USER_IDS\") ?? \"\").split(\",\").filter(Boolean)\n);\n\nlet db: Database;\nlet slack: SlackClient;\nlet migrated = false;\n\nasync function getDb(): Promise {\n if (!db) {\n // Val Town's sqlite.execute takes (sql, args) not {sql, args}\n // Wrap it to match our Database interface\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n db = {\n execute(query: { sql: string; args?: unknown[] }) {\n console.log(\">>> DB execute:\", query.sql, \"args:\", JSON.stringify(query.args));\n return sqlite.execute({ sql: query.sql, args: query.args ?? [] });\n },\n batch(queries: Array) {\n return sqlite.batch(\n queries.map((q) => (typeof q === \"string\" ? q : { sql: q.sql, args: q.args ?? [] }))\n );\n },\n };\n }\n if (!migrated) {\n await migrate(db);\n migrated = true;\n }\n return db;\n}\n\nfunction getSlack(): SlackClient {\n if (!slack) {\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) throw new Error(\"SLACK_BOT_TOKEN not set\");\n slack = createSlackClient(token);\n }\n return slack;\n}\n\nexport default async function handler(req: Request): Promise {\n console.log(\">>> REQUEST RECEIVED:\", req.method, req.url);\n console.log(\">>> Headers:\", JSON.stringify(Object.fromEntries(req.headers.entries())));\n\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const body = await req.text();\n const timestamp = req.headers.get(\"x-slack-request-timestamp\") ?? \"\";\n const signature = req.headers.get(\"x-slack-signature\") ?? \"\";\n const signingSecret = Deno.env.get(\"SLACK_SIGNING_SECRET\");\n if (!signingSecret) {\n console.error(\"SLACK_SIGNING_SECRET not configured\");\n return new Response(\"Server misconfiguration\", { status: 500 });\n }\n\n const valid = await verifySlackSignature(body, timestamp, signature, signingSecret);\n if (!valid) {\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n const contentType = req.headers.get(\"content-type\") ?? \"\";\n\n try {\n if (contentType.includes(\"application/x-www-form-urlencoded\")) {\n const params = new URLSearchParams(body);\n const payload = params.get(\"payload\");\n\n if (payload) {\n return handleInteraction(JSON.parse(payload));\n }\n\n const command = params.get(\"command\");\n const text = params.get(\"text\") ?? \"\";\n const triggerId = params.get(\"trigger_id\") ?? \"\";\n const userId = params.get(\"user_id\") ?? \"\";\n const userName = params.get(\"user_name\") ?? \"\";\n const channelId = params.get(\"channel_id\") ?? \"\";\n\n switch (command) {\n case \"/logtime\":\n return handleLogtime(text, triggerId, userId, userName, channelId);\n case \"/timesheet\":\n return handleTimesheet(text, userId, channelId);\n case \"/admin-timesheet\":\n return handleAdmin(text, userId, channelId);\n default:\n return new Response(\"Unknown command\", { status: 200 });\n }\n }\n\n return new Response(\"\", { status: 200 });\n } catch (error) {\n console.error(\"Handler error:\", error);\n // Return 200 so Slack doesn't retry\n return new Response(JSON.stringify({\n response_type: \"ephemeral\",\n text: \"Something went wrong. Please try again or contact an admin.\",\n }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n}\n\nasync function handleLogtime(\n text: string, triggerId: string, userId: string, userName: string, channelId: string\n): Promise {\n const database = await getDb();\n\n if (text.trim() === \"list\") {\n const entries = await queries.getRecentEntries(database, userId, 5);\n const taskTypes = await queries.getActiveTaskTypes(database);\n const grants = await queries.getActiveGrants(database);\n const enriched = entries.map((entry) => {\n const taskType = taskTypes.find((t) => t.id === entry.taskTypeId);\n const grant = entry.grantId ? grants.find((g) => g.id === entry.grantId) : null;\n return { ...entry, taskTypeName: taskType?.name ?? \"Unknown\", grantCode: grant?.code ?? null };\n });\n\n const blocks = buildRecentEntriesBlocks(enriched);\n await getSlack().postEphemeral(channelId, userId, \"Your recent entries:\", blocks);\n return new Response(\"\", { status: 200 });\n }\n\n const taskTypes = await queries.getActiveTaskTypes(database);\n\n if (taskTypes.length === 0) {\n await getSlack().postEphemeral(channelId, userId,\n \"No task types configured yet. Ask an admin to run: /timesheet-admin add task \\\"Task Name\\\"\");\n return new Response(\"\", { status: 200 });\n }\n\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = todayInTimezone();\n\n // Look up user's last project/grant selections as defaults\n const lastProjectStr = await queries.getConfig(database, `user:${userId}:last_project_id`);\n const lastGrantStr = await queries.getConfig(database, `user:${userId}:last_grant_id`);\n const userDefaults = (lastProjectStr || lastGrantStr) ? {\n projectId: lastProjectStr ? Number(lastProjectStr) : null,\n grantId: lastGrantStr ? Number(lastGrantStr) : null,\n } : undefined;\n\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, undefined, userDefaults);\n await getSlack().openModal(triggerId, modal);\n\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleTimesheet(text: string, userId: string, channelId: string): Promise {\n const database = await getDb();\n const today = todayInTimezone();\n const args = parseReportArgs(text, today);\n\n const data = await queries.getReportData(database, args.startDate, args.endDate, args.userId);\n const report = formatReport(data, args.startDate, args.endDate);\n\n await getSlack().postEphemeral(channelId, userId, report);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleAdmin(text: string, userId: string, channelId: string): Promise {\n if (!ADMIN_USER_IDS.has(userId)) {\n await getSlack().postEphemeral(channelId, userId, \"You don't have permission to use this command.\");\n return new Response(\"\", { status: 200 });\n }\n\n const database = await getDb();\n console.log(\">>> Admin raw text:\", JSON.stringify(text));\n console.log(\">>> Admin text chars:\", [...text].map(c => c.charCodeAt(0)));\n const cmd = parseAdminCommand(text);\n console.log(\">>> Admin parsed:\", JSON.stringify(cmd));\n let response = \"\";\n\n switch (cmd.action) {\n case \"add\":\n if (cmd.entity === \"project\") {\n await queries.addProject(database, cmd.args[0]);\n response = `Added project: ${cmd.args[0]}`;\n } else if (cmd.entity === \"grant\") {\n await queries.addGrant(database, cmd.args[0], cmd.args[1]);\n response = `Added grant: ${cmd.args[0]} (${cmd.args[1]})`;\n } else if (cmd.entity === \"task\") {\n await queries.addTaskType(database, cmd.args[0]);\n response = `Added task type: ${cmd.args[0]}`;\n } else if (cmd.entity === \"intern\") {\n await queries.addIntern(database, cmd.args[0], cmd.args[1]);\n response = `Registered intern: @${cmd.args[1]}`;\n }\n break;\n case \"remove\":\n if (cmd.entity === \"project\") await queries.deactivateProject(database, cmd.args[0]);\n else if (cmd.entity === \"grant\") await queries.deactivateGrant(database, cmd.args[0]);\n else if (cmd.entity === \"task\") await queries.deactivateTaskType(database, cmd.args[0]);\n else if (cmd.entity === \"intern\") await queries.removeIntern(database, cmd.args[0]);\n response = `Removed ${cmd.entity}: ${cmd.args[0]}`;\n break;\n case \"list\": {\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const taskTypes = await queries.getActiveTaskTypes(database);\n const interns = await queries.getInterns(database);\n response = [\n `*Projects:* ${projects.map((p) => p.name).join(\", \") || \"none\"}`,\n `*Grants:* ${grants.map((g) => `${g.code} (${g.name})`).join(\", \") || \"none\"}`,\n `*Task Types:* ${taskTypes.map((t) => t.name).join(\", \") || \"none\"}`,\n `*Interns:* ${interns.map((i) => `@${i.slackUsername}`).join(\", \") || \"none\"}`,\n ].join(\"\\n\");\n break;\n }\n case \"reminder\": {\n const VALID_REMINDER_SETTINGS = new Set([\"on\", \"off\", \"day\", \"time\"]);\n if (!VALID_REMINDER_SETTINGS.has(cmd.entity)) {\n response = `Invalid reminder setting. Use: on, off, day, or time`;\n break;\n }\n if (cmd.entity === \"on\" || cmd.entity === \"off\") {\n await queries.setConfig(database, \"reminder_enabled\", cmd.entity === \"on\" ? \"true\" : \"false\");\n response = `Reminders ${cmd.entity}`;\n } else {\n await queries.setConfig(database, `reminder_${cmd.entity}`, cmd.args[0]);\n response = `Reminder ${cmd.entity} set to: ${cmd.args[0]}`;\n }\n break;\n }\n case \"error\":\n response = cmd.args[0];\n break;\n }\n\n await getSlack().postEphemeral(channelId, userId, response);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleInteraction(payload: Record): Promise {\n const type = payload.type as string;\n const database = await getDb();\n\n if (type === \"view_submission\") {\n const view = payload.view as Record;\n const callbackId = view.callback_id as string;\n const values = view.state as { values: Record> };\n const user = payload.user as { id: string; username: string };\n\n const date = values.values.date_block.date_select.selected_date!;\n const minutes = Number(values.values.time_block.time_select.selected_option!.value);\n const taskTypeId = Number(values.values.task_block.task_select.selected_option!.value);\n const projectId = values.values.project_block?.project_select?.selected_option?.value\n ? Number(values.values.project_block.project_select.selected_option.value) : null;\n const grantId = values.values.grant_block?.grant_select?.selected_option?.value\n ? Number(values.values.grant_block.grant_select.selected_option.value) : null;\n const comment = values.values.comment_block.comment_input.value || null;\n\n if (callbackId === \"edit_time_entry\") {\n const meta = JSON.parse(view.private_metadata as string);\n const existing = await queries.getTimeEntryById(database, meta.entryId);\n if (!existing || existing.slackUserId !== user.id) {\n return new Response(JSON.stringify({\n response_action: \"errors\",\n errors: { date_block: \"Entry not found or not yours.\" },\n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n await queries.updateTimeEntry(database, meta.entryId, { date, minutes, taskTypeId, projectId, grantId, comment });\n } else {\n await queries.createTimeEntry(database, {\n slackUserId: user.id, slackUsername: user.username,\n date, minutes, taskTypeId, projectId, grantId, comment,\n });\n }\n\n // Remember user's project/grant selections for next time\n if (projectId) await queries.setConfig(database, `user:${user.id}:last_project_id`, String(projectId));\n if (grantId) await queries.setConfig(database, `user:${user.id}:last_grant_id`, String(grantId));\n\n return new Response(JSON.stringify({ response_action: \"clear\" }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (type === \"block_actions\") {\n const actions = payload.actions as Array<{ action_id: string; value: string }>;\n const action = actions[0];\n const user = payload.user as { id: string; username: string };\n const channel = (payload.channel as { id: string })?.id;\n\n if (action.action_id === \"delete_entry\") {\n const entryId = Number(action.value);\n const entry = await queries.getTimeEntryById(database, entryId);\n if (entry && entry.slackUserId === user.id) {\n await queries.softDeleteTimeEntry(database, entryId);\n if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry deleted.\");\n }\n } else if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry not found or not yours.\");\n }\n } else if (action.action_id === \"edit_entry\") {\n const entry = await queries.getTimeEntryById(database, Number(action.value));\n if (entry && entry.slackUserId === user.id) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = todayInTimezone();\n const triggerId = (payload as Record).trigger_id;\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, {\n id: entry.id, date: entry.date, minutes: entry.minutes,\n taskTypeId: entry.taskTypeId, projectId: entry.projectId, grantId: entry.grantId, comment: entry.comment,\n });\n await getSlack().openModal(triggerId, modal);\n }\n }\n\n // Handle overflow menu actions (from recent entries list)\n if (action.action_id.startsWith(\"entry_overflow_\")) {\n const [actionType, entryId] = action.value?.split(\":\") ?? [];\n if (actionType === \"delete\") {\n const entry = await queries.getTimeEntryById(database, Number(entryId));\n if (entry && entry.slackUserId === user.id) {\n await queries.softDeleteTimeEntry(database, Number(entryId));\n if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry deleted.\");\n }\n } else if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry not found or not yours.\");\n }\n } else if (actionType === \"edit\") {\n const entry = await queries.getTimeEntryById(database, Number(entryId));\n if (entry && entry.slackUserId === user.id) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = todayInTimezone();\n const triggerId = (payload as Record).trigger_id;\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, {\n id: entry.id, date: entry.date, minutes: entry.minutes,\n taskTypeId: entry.taskTypeId, projectId: entry.projectId, grantId: entry.grantId, comment: entry.comment,\n });\n await getSlack().openModal(triggerId, modal);\n }\n }\n }\n }\n\n return new Response(\"\", { status: 200 });\n}\n",[],[864],{"_106":874,"_97":875,"_160":876,"_162":-5,"_163":145,"_164":877,"_166":167,"_108":878,"_102":33,"_169":284,"_171":879,"_172":22,"_173":-5,"_174":880,"_100":881},"59b9adea-132b-11f1-b163-42dde27851f2","package.json","59b9ae9e-132b-11f1-b163-42dde27851f2",118,["D",1772121233484],"{\n \"name\": \"lakeland-timesheet\",\n \"version\": \"1.0.0\",\n \"private\": true,\n \"scripts\": {\n \"test\": \"vitest\",\n \"test:run\": \"vitest run\",\n \"check\": \"tsc --noEmit\"\n },\n \"devDependencies\": {\n \"@libsql/client\": \"^0.17.0\",\n \"typescript\": \"^5.9.3\",\n \"vitest\": \"^4.0.18\"\n }\n}\n",[],[875],{"_106":883,"_97":884,"_160":885,"_162":-5,"_163":145,"_164":886,"_166":167,"_108":887,"_102":33,"_169":284,"_171":888,"_172":22,"_173":-5,"_174":889,"_100":890},"59bed89c-132b-11f1-b93a-42dde27851f2","tsconfig.json","59bed93c-132b-11f1-b93a-42dde27851f2",119,["D",1772121233531],"{\n \"compilerOptions\": {\n \"target\": \"ES2022\",\n \"module\": \"ES2022\",\n \"moduleResolution\": \"bundler\",\n \"strict\": true,\n \"esModuleInterop\": true,\n \"allowImportingTsExtensions\": true,\n \"noEmit\": true,\n \"forceConsistentCasingInFileNames\": true,\n \"skipLibCheck\": true\n },\n \"include\": [\"**/*.ts\"],\n \"exclude\": [\"node_modules\"]\n}\n",[],[884],{"_106":892,"_97":893,"_160":894,"_162":-5,"_163":145,"_164":895,"_166":167,"_108":896,"_102":33,"_169":609,"_171":897,"_172":22,"_173":-5,"_174":898,"_100":899},"59ae7fb0-132b-11f1-b163-42dde27851f2","valtown.d.ts","59ae8082-132b-11f1-b163-42dde27851f2",116,["D",1772121233422],"// Type declarations for Val Town runtime modules\ndeclare module \"https://esm.town/v/std/sqlite\" {\n interface SqliteResult {\n columns: string[];\n rows: unknown[][];\n rowsAffected: number;\n lastInsertRowid: bigint | number;\n }\n interface SqliteClient {\n execute(query: { sql: string; args?: unknown[] }): Promise;\n batch(queries: Array): Promise;\n }\n export const sqlite: SqliteClient;\n}\n",[],[893],"files",[157,176,184,192,199,206,216,223,231,239,247,255,263,271,278,289,297,304,314,322,330,338,346,354,362,370,378,385,395,403,411,418,428,436,444,452,460,468,476,484,492,500,508,516,524,532,540,547,556,562,569,578,586,596,602,613,622,631,640,649,659,666,673,682,693,700,709,718,727,736,745,755,761,770,780,787,796,805,815,824,834,843,852,862,873,882,891],"counts",{"_904":33,"_905":608,"_906":33,"_907":908,"_911":912},"pulls","branches","forks","envVars",{"_909":784,"_910":33},"count","emptyCount","connections",{"_909":33,"_913":33},"unfilledCount","contents",[],{"_106":493,"_97":494,"_160":495,"_162":219,"_163":145,"_164":496,"_166":167,"_108":917,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_100":918},["D",1772121229913],[159,218,494],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_95":96,"_97":98,"_99":45,"_102":103,"_100":101,"_104":927,"_155":932,"_900":1194,"_284":1195,"_914":1197,"_1198":-5,"_1199":-5,"_1200":-5,"_1201":-5,"_1202":1203,"_907":-5},{"_106":107,"_97":98,"_108":928,"_110":-5,"_111":22,"_112":113,"_114":74,"_115":-5,"_14":116,"_117":-5,"_118":22,"_119":-5,"_120":-5,"_121":33,"_16":122,"_123":-5,"_124":-5,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":929,"_137":930,"_142":931,"_154":22},["D",1772107064004],{"_95":96,"_135":136},{"_95":96,"_139":136,"_14":116,"_140":141},{"_102":144,"_97":45,"_106":145,"_146":107,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},[933,1092,1113,1125,1146,1155,1173,1176,1179,1182,1185,1188,1191],{"_106":158,"_97":159,"_160":161,"_162":-5,"_163":145,"_164":165,"_166":167,"_108":168,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":934,"_100":1091},[935,938,941,950,1076,1085,1088],{"_106":177,"_97":178,"_160":179,"_162":161,"_163":145,"_164":180,"_166":167,"_108":181,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":936,"_100":937},[],[159,178],{"_106":185,"_97":186,"_160":187,"_162":161,"_163":145,"_164":188,"_166":167,"_108":189,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":939,"_100":940},[],[159,186],{"_106":193,"_97":194,"_160":195,"_162":161,"_163":145,"_164":196,"_166":167,"_108":197,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":942,"_100":949},[943],{"_106":200,"_97":201,"_160":202,"_162":195,"_163":145,"_164":203,"_166":167,"_108":204,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":944,"_100":948},[945],{"_106":207,"_97":208,"_160":209,"_162":202,"_163":145,"_164":210,"_166":167,"_108":211,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":946,"_100":947},[],[159,194,201,208],[159,194,201],[159,194],{"_106":217,"_97":218,"_160":219,"_162":161,"_163":145,"_164":220,"_166":167,"_108":221,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":951,"_100":1075},[952,955,958,961,964,967,970,976,979,985,988,991,994,997,1000,1003,1006,1009,1015,1018,1021,1027,1030,1033,1036,1039,1042,1045,1048,1051,1054,1057,1060,1063,1066,1069,1072],{"_106":224,"_97":225,"_160":226,"_162":219,"_163":145,"_164":227,"_166":167,"_108":228,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":953,"_100":954},[],[159,218,225],{"_106":232,"_97":233,"_160":234,"_162":219,"_163":145,"_164":235,"_166":167,"_108":236,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":956,"_100":957},[],[159,218,233],{"_106":240,"_97":241,"_160":242,"_162":219,"_163":145,"_164":243,"_166":167,"_108":244,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":959,"_100":960},[],[159,218,241],{"_106":248,"_97":249,"_160":250,"_162":219,"_163":145,"_164":251,"_166":167,"_108":252,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":962,"_100":963},[],[159,218,249],{"_106":256,"_97":257,"_160":258,"_162":219,"_163":145,"_164":259,"_166":167,"_108":260,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":965,"_100":966},[],[159,218,257],{"_106":264,"_97":265,"_160":266,"_162":219,"_163":145,"_164":267,"_166":167,"_108":268,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":968,"_100":969},[],[159,218,265],{"_106":272,"_97":273,"_160":274,"_162":219,"_163":145,"_164":275,"_166":167,"_108":276,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":971,"_100":975},[972],{"_106":279,"_97":280,"_160":281,"_162":274,"_163":145,"_164":282,"_166":167,"_108":283,"_102":33,"_169":284,"_171":285,"_172":22,"_173":-5,"_174":973,"_100":974},[],[159,218,273,280],[159,218,273],{"_106":290,"_97":291,"_160":292,"_162":219,"_163":145,"_164":293,"_166":167,"_108":294,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":977,"_100":978},[],[159,218,291],{"_106":298,"_97":299,"_160":300,"_162":219,"_163":145,"_164":301,"_166":167,"_108":302,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":980,"_100":984},[981],{"_106":305,"_97":306,"_160":307,"_162":300,"_163":145,"_164":308,"_166":167,"_108":309,"_102":33,"_169":284,"_171":310,"_172":22,"_173":-5,"_174":982,"_100":983},[],[159,218,299,306],[159,218,299],{"_106":315,"_97":316,"_160":317,"_162":219,"_163":145,"_164":318,"_166":167,"_108":319,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":986,"_100":987},[],[159,218,316],{"_106":323,"_97":324,"_160":325,"_162":219,"_163":145,"_164":326,"_166":167,"_108":327,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":989,"_100":990},[],[159,218,324],{"_106":331,"_97":332,"_160":333,"_162":219,"_163":145,"_164":334,"_166":167,"_108":335,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":992,"_100":993},[],[159,218,332],{"_106":339,"_97":340,"_160":341,"_162":219,"_163":145,"_164":342,"_166":167,"_108":343,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":995,"_100":996},[],[159,218,340],{"_106":347,"_97":348,"_160":349,"_162":219,"_163":145,"_164":350,"_166":167,"_108":351,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":998,"_100":999},[],[159,218,348],{"_106":355,"_97":356,"_160":357,"_162":219,"_163":145,"_164":358,"_166":167,"_108":359,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1001,"_100":1002},[],[159,218,356],{"_106":363,"_97":364,"_160":365,"_162":219,"_163":145,"_164":366,"_166":167,"_108":367,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1004,"_100":1005},[],[159,218,364],{"_106":371,"_97":372,"_160":373,"_162":219,"_163":145,"_164":374,"_166":167,"_108":375,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1007,"_100":1008},[],[159,218,372],{"_106":379,"_97":380,"_160":381,"_162":219,"_163":145,"_164":382,"_166":167,"_108":383,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1010,"_100":1014},[1011],{"_106":386,"_97":387,"_160":388,"_162":381,"_163":145,"_164":389,"_166":167,"_108":390,"_102":33,"_169":284,"_171":391,"_172":22,"_173":-5,"_174":1012,"_100":1013},[],[159,218,380,387],[159,218,380],{"_106":396,"_97":397,"_160":398,"_162":219,"_163":145,"_164":399,"_166":167,"_108":400,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1016,"_100":1017},[],[159,218,397],{"_106":404,"_97":405,"_160":406,"_162":219,"_163":145,"_164":407,"_166":167,"_108":408,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1019,"_100":1020},[],[159,218,405],{"_106":412,"_97":413,"_160":414,"_162":219,"_163":145,"_164":415,"_166":167,"_108":416,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1022,"_100":1026},[1023],{"_106":419,"_97":420,"_160":421,"_162":414,"_163":145,"_164":422,"_166":167,"_108":423,"_102":33,"_169":284,"_171":424,"_172":22,"_173":-5,"_174":1024,"_100":1025},[],[159,218,413,420],[159,218,413],{"_106":429,"_97":430,"_160":431,"_162":219,"_163":145,"_164":432,"_166":167,"_108":433,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1028,"_100":1029},[],[159,218,430],{"_106":437,"_97":438,"_160":439,"_162":219,"_163":145,"_164":440,"_166":167,"_108":441,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1031,"_100":1032},[],[159,218,438],{"_106":445,"_97":446,"_160":447,"_162":219,"_163":145,"_164":448,"_166":167,"_108":449,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1034,"_100":1035},[],[159,218,446],{"_106":453,"_97":454,"_160":455,"_162":219,"_163":145,"_164":456,"_166":167,"_108":457,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1037,"_100":1038},[],[159,218,454],{"_106":461,"_97":462,"_160":463,"_162":219,"_163":145,"_164":464,"_166":167,"_108":465,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1040,"_100":1041},[],[159,218,462],{"_106":469,"_97":470,"_160":471,"_162":219,"_163":145,"_164":472,"_166":167,"_108":473,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1043,"_100":1044},[],[159,218,470],{"_106":477,"_97":478,"_160":479,"_162":219,"_163":145,"_164":480,"_166":167,"_108":481,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1046,"_100":1047},[],[159,218,478],{"_106":485,"_97":486,"_160":487,"_162":219,"_163":145,"_164":488,"_166":167,"_108":489,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1049,"_100":1050},[],[159,218,486],{"_106":493,"_97":494,"_160":495,"_162":219,"_163":145,"_164":496,"_166":167,"_108":497,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1052,"_100":1053},[],[159,218,494],{"_106":501,"_97":502,"_160":503,"_162":219,"_163":145,"_164":504,"_166":167,"_108":505,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1055,"_100":1056},[],[159,218,502],{"_106":509,"_97":510,"_160":511,"_162":219,"_163":145,"_164":512,"_166":167,"_108":513,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1058,"_100":1059},[],[159,218,510],{"_106":517,"_97":518,"_160":519,"_162":219,"_163":145,"_164":520,"_166":167,"_108":521,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1061,"_100":1062},[],[159,218,518],{"_106":525,"_97":526,"_160":527,"_162":219,"_163":145,"_164":528,"_166":167,"_108":529,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1064,"_100":1065},[],[159,218,526],{"_106":533,"_97":534,"_160":535,"_162":219,"_163":145,"_164":536,"_166":167,"_108":537,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1067,"_100":1068},[],[159,218,534],{"_106":541,"_97":186,"_160":542,"_162":219,"_163":145,"_164":543,"_166":167,"_108":544,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1070,"_100":1071},[],[159,218,186],{"_106":548,"_97":549,"_160":550,"_162":219,"_163":145,"_164":551,"_166":167,"_108":552,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1073,"_100":1074},[],[159,218,549],[159,218],{"_106":557,"_97":201,"_160":558,"_162":161,"_163":145,"_164":559,"_166":167,"_108":560,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1077,"_100":1084},[1078,1081],{"_106":563,"_97":208,"_160":564,"_162":558,"_163":145,"_164":565,"_166":167,"_108":566,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1079,"_100":1080},[],[159,201,208],{"_106":570,"_97":571,"_160":572,"_162":558,"_163":145,"_164":573,"_166":167,"_108":574,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1082,"_100":1083},[],[159,201,571],[159,201],{"_106":579,"_97":580,"_160":581,"_162":161,"_163":145,"_164":103,"_166":167,"_108":582,"_102":33,"_169":284,"_171":583,"_172":22,"_173":-5,"_174":1086,"_100":1087},[],[159,580],{"_106":587,"_97":588,"_160":589,"_162":161,"_163":145,"_164":590,"_166":167,"_108":591,"_102":33,"_169":284,"_171":592,"_172":22,"_173":-5,"_174":1089,"_100":1090},[],[159,588],[159],{"_106":597,"_97":502,"_160":598,"_162":-5,"_163":145,"_164":599,"_166":167,"_108":600,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1093,"_100":1112},[1094,1097,1100,1103,1106,1109],{"_106":603,"_97":604,"_160":605,"_162":598,"_163":145,"_164":606,"_166":167,"_108":607,"_102":608,"_169":609,"_171":610,"_172":22,"_173":-5,"_174":1095,"_100":1096},[],[502,604],{"_106":614,"_97":615,"_160":616,"_162":598,"_163":145,"_164":617,"_166":167,"_108":618,"_102":608,"_169":609,"_171":619,"_172":22,"_173":-5,"_174":1098,"_100":1099},[],[502,615],{"_106":623,"_97":624,"_160":625,"_162":598,"_163":145,"_164":626,"_166":167,"_108":627,"_102":608,"_169":609,"_171":628,"_172":22,"_173":-5,"_174":1101,"_100":1102},[],[502,624],{"_106":632,"_97":633,"_160":634,"_162":598,"_163":145,"_164":635,"_166":167,"_108":636,"_102":608,"_169":609,"_171":637,"_172":22,"_173":-5,"_174":1104,"_100":1105},[],[502,633],{"_106":641,"_97":642,"_160":643,"_162":598,"_163":145,"_164":644,"_166":22,"_108":645,"_102":608,"_169":609,"_171":646,"_172":22,"_173":-5,"_174":1107,"_100":1108},[],[502,642],{"_106":650,"_97":651,"_160":652,"_162":598,"_163":145,"_164":653,"_166":167,"_108":654,"_102":33,"_169":609,"_171":655,"_172":22,"_173":-5,"_174":1110,"_100":1111},[],[502,651],[502],{"_106":660,"_97":661,"_160":662,"_162":-5,"_163":145,"_164":663,"_166":167,"_108":664,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1114,"_100":1124},[1115],{"_106":667,"_97":668,"_160":669,"_162":662,"_163":145,"_164":670,"_166":167,"_108":671,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1116,"_100":1123},[1117,1120],{"_106":674,"_97":675,"_160":676,"_162":669,"_163":145,"_164":677,"_166":167,"_108":678,"_102":33,"_169":284,"_171":679,"_172":22,"_173":-5,"_174":1118,"_100":1119},[],[661,668,675],{"_106":683,"_97":684,"_160":685,"_162":669,"_163":145,"_164":686,"_166":167,"_108":687,"_102":33,"_169":284,"_171":688,"_172":22,"_173":-5,"_174":1121,"_100":1122},[],[661,668,684],[661,668],[661],{"_106":694,"_97":695,"_160":696,"_162":-5,"_163":145,"_164":697,"_166":167,"_108":698,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1126,"_100":1145},[1127,1130,1133,1136,1139,1142],{"_106":701,"_97":702,"_160":703,"_162":696,"_163":145,"_164":704,"_166":167,"_108":705,"_102":608,"_169":609,"_171":706,"_172":22,"_173":-5,"_174":1128,"_100":1129},[],[695,702],{"_106":710,"_97":711,"_160":712,"_162":696,"_163":145,"_164":713,"_166":167,"_108":714,"_102":608,"_169":609,"_171":715,"_172":22,"_173":-5,"_174":1131,"_100":1132},[],[695,711],{"_106":719,"_97":720,"_160":721,"_162":696,"_163":145,"_164":722,"_166":167,"_108":723,"_102":599,"_169":609,"_171":724,"_172":22,"_173":-5,"_174":1134,"_100":1135},[],[695,720],{"_106":728,"_97":729,"_160":730,"_162":696,"_163":145,"_164":731,"_166":167,"_108":732,"_102":599,"_169":609,"_171":733,"_172":22,"_173":-5,"_174":1137,"_100":1138},[],[695,729],{"_106":737,"_97":738,"_160":739,"_162":696,"_163":145,"_164":740,"_166":167,"_108":741,"_102":599,"_169":609,"_171":742,"_172":22,"_173":-5,"_174":1140,"_100":1141},[],[695,738],{"_106":746,"_97":747,"_160":748,"_162":696,"_163":145,"_164":749,"_166":167,"_108":750,"_102":599,"_169":609,"_171":751,"_172":22,"_173":-5,"_174":1143,"_100":1144},[],[695,747],[695],{"_106":756,"_97":757,"_160":758,"_162":-5,"_163":145,"_164":608,"_166":167,"_108":759,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1147,"_100":1154},[1148,1151],{"_106":762,"_97":763,"_160":764,"_162":758,"_163":145,"_164":765,"_166":22,"_108":766,"_102":608,"_169":609,"_171":767,"_172":22,"_173":-5,"_174":1149,"_100":1150},[],[757,763],{"_106":771,"_97":772,"_160":773,"_162":758,"_163":145,"_164":774,"_166":22,"_108":775,"_102":33,"_169":609,"_171":776,"_172":22,"_173":-5,"_174":1152,"_100":1153},[],[757,772],[757],{"_106":781,"_97":782,"_160":783,"_162":-5,"_163":145,"_164":784,"_166":167,"_108":785,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":1156,"_100":1172},[1157,1160,1163,1166,1169],{"_106":788,"_97":789,"_160":790,"_162":783,"_163":145,"_164":791,"_166":22,"_108":792,"_102":608,"_169":609,"_171":793,"_172":22,"_173":-5,"_174":1158,"_100":1159},[],[782,789],{"_106":797,"_97":798,"_160":799,"_162":783,"_163":145,"_164":800,"_166":167,"_108":801,"_102":599,"_169":609,"_171":802,"_172":22,"_173":-5,"_174":1161,"_100":1162},[],[782,798],{"_106":806,"_97":807,"_160":808,"_162":783,"_163":145,"_164":809,"_166":22,"_108":810,"_102":811,"_169":609,"_171":812,"_172":22,"_173":-5,"_174":1164,"_100":1165},[],[782,807],{"_106":816,"_97":817,"_160":818,"_162":783,"_163":145,"_164":819,"_166":167,"_108":820,"_102":608,"_169":609,"_171":821,"_172":22,"_173":-5,"_174":1167,"_100":1168},[],[782,817],{"_106":825,"_97":826,"_160":827,"_162":783,"_163":145,"_164":828,"_166":167,"_108":829,"_102":33,"_169":609,"_171":830,"_172":22,"_173":-5,"_174":1170,"_100":1171},[],[782,826],[782],{"_106":835,"_97":836,"_160":837,"_162":-5,"_163":145,"_164":838,"_166":167,"_108":839,"_102":33,"_169":284,"_171":840,"_172":22,"_173":-5,"_174":1174,"_100":1175},[],[836],{"_106":844,"_97":845,"_160":846,"_162":-5,"_163":145,"_164":847,"_166":22,"_108":848,"_102":33,"_169":284,"_171":849,"_172":22,"_173":-5,"_174":1177,"_100":1178},[],[845],{"_106":853,"_97":854,"_160":855,"_162":-5,"_163":145,"_164":856,"_166":167,"_108":857,"_102":608,"_169":858,"_171":859,"_172":22,"_173":-5,"_174":1180,"_100":1181},[],[854],{"_106":863,"_97":864,"_160":865,"_162":-5,"_163":145,"_164":866,"_166":22,"_108":867,"_102":868,"_169":869,"_171":870,"_172":22,"_173":-5,"_174":1183,"_100":1184},[],[864],{"_106":874,"_97":875,"_160":876,"_162":-5,"_163":145,"_164":877,"_166":167,"_108":878,"_102":33,"_169":284,"_171":879,"_172":22,"_173":-5,"_174":1186,"_100":1187},[],[875],{"_106":883,"_97":884,"_160":885,"_162":-5,"_163":145,"_164":886,"_166":167,"_108":887,"_102":33,"_169":284,"_171":888,"_172":22,"_173":-5,"_174":1189,"_100":1190},[],[884],{"_106":892,"_97":893,"_160":894,"_162":-5,"_163":145,"_164":895,"_166":167,"_108":896,"_102":33,"_169":609,"_171":897,"_172":22,"_173":-5,"_174":1192,"_100":1193},[],[893],[933,935,938,941,943,945,950,952,955,958,961,964,967,970,972,976,979,981,985,988,991,994,997,1000,1003,1006,1009,1011,1015,1018,1021,1023,1027,1030,1033,1036,1039,1042,1045,1048,1051,1054,1057,1060,1063,1066,1069,1072,1076,1078,1081,1085,1088,1092,1094,1097,1100,1103,1106,1109,1113,1115,1117,1120,1125,1127,1130,1133,1136,1139,1142,1146,1148,1151,1155,1157,1160,1163,1166,1169,1173,1176,1179,1182,1185,1188,1191],{"_106":493,"_97":494,"_160":495,"_162":219,"_163":145,"_164":496,"_166":167,"_108":917,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_100":1196},[159,218,494],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]