[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_832":833,"_834":835},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_42":-7,"_152":-5,"_19":153,"_154":155,"_156":157,"_158":159,"_160":161,"_21":162,"_163":-5,"_164":-5,"_165":30,"_166":167,"_168":24,"_169":-5,"_170":-5,"_171":172},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":-5},"handle","ictuer","name","flowtest-72m0b34v","branchName","main","path","toppings","project",{"_36":105,"_13":14,"_40":106,"_107":-5,"_108":30,"_109":110,"_111":110,"_112":-5,"_113":-5,"_31":70,"_114":-5,"_115":30,"_116":-5,"_117":-5,"_118":26,"_44":45,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_55":132,"_133":134,"_135":136,"_137":30},"file",{"_65":103,"_13":18,"_68":83,"_69":30,"_104":-5},"isDirectory",true,"page",0,"history",[32,33,34,35],"hasNext",false,"userId",{"_36":94,"_38":39,"_40":95,"_42":96,"_44":45,"_46":84,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":97,"_21":98,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":99},{"_36":84,"_38":39,"_40":85,"_42":86,"_44":45,"_46":87,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":88,"_21":89,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":90},{"_36":73,"_38":39,"_40":74,"_42":75,"_44":45,"_46":76,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":77,"_21":78,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":79},{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":56,"_21":57,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":63},"id","123acff0-538e-11f1-961c-ee650bb23af1","branchId","0a0b415c-538e-11f1-869b-ee650bb23af1","createdAt",["D",1779200508127],"version",9,"orgId","1debf5ae-5acf-4d9b-bb1c-6834e6cfc9b9","parentId","11e0b06a-538e-11f1-a631-ee650bb23af1","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_36":70,"_44":45,"_11":12,"_71":72},{"_65":66,"_13":67,"_68":21,"_69":30},"pull","merge","revert","multiple","commits",[64],{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":56,"_21":57,"_58":-5,"_59":-5,"_60":-5},"fileId","1238ee4c-538e-11f1-961c-ee650bb23af1","toppings.table.ts","fileType","deleted","3fa51a00-4088-11f0-bfbe-7da0210b7c9d","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeTBCNXpSZ2xvMENDdWhEM2ZzbmhKQndVenUifQ","23e1c72c-538e-11f1-93f6-ee650bb23af1",["D",1779200537726],51,"23845920-538e-11f1-ae69-ee650bb23af1",{"_36":70,"_44":45,"_11":12,"_71":72},{"_65":81,"_13":82,"_68":83,"_69":30},[80],{"_36":73,"_38":39,"_40":74,"_42":75,"_44":45,"_46":76,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":77,"_21":78,"_58":-5,"_59":-5,"_60":-5},"6f41ed60-93e5-4665-b5c7-cfee583f8ed0","[id__int]","directory","2509fa7a-538e-11f1-b0b6-ee650bb23af1",["D",1779200539658],54,"24a60c2c-538e-11f1-bd07-ee650bb23af1",{"_36":70,"_44":45,"_11":12,"_71":72},{"_65":92,"_13":93,"_68":21,"_69":30},[91],{"_36":84,"_38":39,"_40":85,"_42":86,"_44":45,"_46":87,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":88,"_21":89,"_58":-5,"_59":-5,"_60":-5},"250775b6-538e-11f1-b0b6-ee650bb23af1","get.ts","2564e444-538e-11f1-9b3d-ee650bb23af1",["D",1779200540279],55,{"_36":70,"_44":45,"_11":12,"_71":72},{"_65":101,"_13":102,"_68":21,"_69":30},[100],{"_36":94,"_38":39,"_40":95,"_42":96,"_44":45,"_46":84,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":97,"_21":98,"_58":-5,"_59":-5,"_60":-5},"2562dabe-538e-11f1-9b3d-ee650bb23af1","post.ts","f0390e62-9bf0-4d55-a0aa-d2f06ebb1f60","deletedAtVersion","0a0a74ac-538e-11f1-869b-ee650bb23af1",["D",1779200494411],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_151":72},"org",{"_11":12,"_147":-5,"_71":72,"_31":70,"_148":149,"_150":30},"branch",{"_42":138,"_13":16,"_36":39,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":14,"_146":12},"isOwned",56,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":105,"_13":14,"_40":828,"_107":-5,"_108":30,"_109":110,"_111":110,"_112":-5,"_113":-5,"_31":70,"_114":-5,"_115":30,"_116":-5,"_117":-5,"_118":26,"_44":45,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_55":829,"_133":830,"_135":831,"_137":30},"tree",[210,217,225,235,243,251,253,261,275,278,286,288,289,290,291],"files",[210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291],"counts",{"_199":26,"_200":201,"_202":26,"_203":204,"_205":206},"contents",[180,181,182,183],{"_36":173,"_13":18,"_65":103,"_46":-5,"_38":39,"_174":43,"_175":24,"_40":176,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_17":179},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"1238fae0-538e-11f1-961c-ee650bb23af1","branchVersion","latest",["D",1779200508127],"content","label",[18],{"_36":196,"_13":82,"_65":81,"_46":103,"_38":39,"_174":75,"_175":24,"_40":197,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_17":198},{"_36":192,"_13":93,"_65":92,"_46":103,"_38":39,"_174":86,"_175":24,"_40":193,"_42":26,"_68":21,"_177":194,"_69":30,"_178":-5,"_17":195},{"_36":188,"_13":102,"_65":101,"_46":103,"_38":39,"_174":96,"_175":24,"_40":189,"_42":26,"_68":21,"_177":190,"_69":30,"_178":-5,"_17":191},{"_36":184,"_13":67,"_65":66,"_46":103,"_38":39,"_174":43,"_175":24,"_40":185,"_42":26,"_68":21,"_177":186,"_69":30,"_178":-5,"_17":187},"1238ed70-538e-11f1-961c-ee650bb23af1",["D",1779200508127],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const toppings = sqliteTable(\"toppings\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n price: integer(\"price\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[18,67],"2562d9f6-538e-11f1-9b3d-ee650bb23af1",["D",1779200540279],"import { db } from \"../db.ts\";\nimport { toppings } from \"./toppings.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(toppings).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[18,102],"250774c6-538e-11f1-b0b6-ee650bb23af1",["D",1779200539658],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { toppings } from \"./toppings.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n if (q.q) filters.push(like((toppings as any).name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (toppings as any)[sortKey] ?? (toppings as any).id;\n\n const rows = await db.select().from(toppings).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(toppings).where(where);\n\n return { data: rows, total, success: true };\n}\n",[18,93],"23deaa06-538e-11f1-93f6-ee650bb23af1",["D",1779200537726],[18,82],"pulls","branches",1,"forks","envVars",{"_207":26,"_209":26},"connections",{"_207":26,"_208":26},"count","unfilledCount","emptyCount",{"_36":824,"_13":791,"_65":794,"_46":-5,"_38":39,"_174":814,"_175":24,"_40":825,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":826,"_17":827},{"_36":820,"_13":819,"_65":813,"_46":794,"_38":39,"_174":814,"_175":24,"_40":821,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":822,"_17":823},{"_36":811,"_13":102,"_65":812,"_46":813,"_38":39,"_174":814,"_175":24,"_40":815,"_42":26,"_68":21,"_177":816,"_69":30,"_178":-5,"_298":817,"_17":818},{"_36":807,"_13":806,"_65":800,"_46":794,"_38":39,"_174":801,"_175":24,"_40":808,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":809,"_17":810},{"_36":798,"_13":93,"_65":799,"_46":800,"_38":39,"_174":801,"_175":24,"_40":802,"_42":26,"_68":21,"_177":803,"_69":30,"_178":-5,"_298":804,"_17":805},{"_36":793,"_13":792,"_65":785,"_46":794,"_38":39,"_174":786,"_175":24,"_40":795,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":796,"_17":797},{"_36":783,"_13":102,"_65":784,"_46":785,"_38":39,"_174":786,"_175":24,"_40":787,"_42":26,"_68":21,"_177":788,"_69":30,"_178":-5,"_298":789,"_17":790},{"_36":779,"_13":738,"_65":732,"_46":-5,"_38":39,"_174":201,"_175":24,"_40":780,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":781,"_17":782},{"_36":775,"_13":82,"_65":755,"_46":732,"_38":39,"_174":770,"_175":24,"_40":776,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":777,"_17":778},{"_36":768,"_13":364,"_65":769,"_46":755,"_38":39,"_174":770,"_175":24,"_40":771,"_42":26,"_68":21,"_177":772,"_69":30,"_178":-5,"_298":773,"_17":774},{"_36":761,"_13":93,"_65":762,"_46":755,"_38":39,"_174":763,"_175":24,"_40":764,"_42":26,"_68":21,"_177":765,"_69":30,"_178":-5,"_298":766,"_17":767},{"_36":753,"_13":349,"_65":754,"_46":755,"_38":39,"_174":756,"_175":24,"_40":757,"_42":26,"_68":21,"_177":758,"_69":30,"_178":-5,"_298":759,"_17":760},{"_36":746,"_13":747,"_65":748,"_46":732,"_38":39,"_174":201,"_175":24,"_40":749,"_42":26,"_68":21,"_177":750,"_69":30,"_178":-5,"_298":751,"_17":752},{"_36":739,"_13":93,"_65":740,"_46":732,"_38":39,"_174":741,"_175":24,"_40":742,"_42":26,"_68":21,"_177":743,"_69":30,"_178":-5,"_298":744,"_17":745},{"_36":730,"_13":102,"_65":731,"_46":732,"_38":39,"_174":733,"_175":24,"_40":734,"_42":26,"_68":21,"_177":735,"_69":30,"_178":-5,"_298":736,"_17":737},{"_36":726,"_13":671,"_65":665,"_46":-5,"_38":39,"_174":682,"_175":24,"_40":727,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":728,"_17":729},{"_36":722,"_13":82,"_65":702,"_46":665,"_38":39,"_174":717,"_175":24,"_40":723,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":724,"_17":725},{"_36":715,"_13":364,"_65":716,"_46":702,"_38":39,"_174":717,"_175":24,"_40":718,"_42":26,"_68":21,"_177":719,"_69":30,"_178":-5,"_298":720,"_17":721},{"_36":708,"_13":93,"_65":709,"_46":702,"_38":39,"_174":710,"_175":24,"_40":711,"_42":26,"_68":21,"_177":712,"_69":30,"_178":-5,"_298":713,"_17":714},{"_36":700,"_13":349,"_65":701,"_46":702,"_38":39,"_174":703,"_175":24,"_40":704,"_42":26,"_68":21,"_177":705,"_69":30,"_178":-5,"_298":706,"_17":707},{"_36":696,"_13":695,"_65":689,"_46":665,"_38":39,"_174":690,"_175":24,"_40":697,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":698,"_17":699},{"_36":687,"_13":93,"_65":688,"_46":689,"_38":39,"_174":690,"_175":24,"_40":691,"_42":26,"_68":21,"_177":692,"_69":30,"_178":-5,"_298":693,"_17":694},{"_36":679,"_13":680,"_65":681,"_46":665,"_38":39,"_174":682,"_175":24,"_40":683,"_42":26,"_68":21,"_177":684,"_69":30,"_178":-5,"_298":685,"_17":686},{"_36":672,"_13":93,"_65":673,"_46":665,"_38":39,"_174":674,"_175":24,"_40":675,"_42":26,"_68":21,"_177":676,"_69":30,"_178":-5,"_298":677,"_17":678},{"_36":663,"_13":102,"_65":664,"_46":665,"_38":39,"_174":666,"_175":24,"_40":667,"_42":26,"_68":21,"_177":668,"_69":30,"_178":-5,"_298":669,"_17":670},{"_36":659,"_13":617,"_65":611,"_46":-5,"_38":39,"_174":621,"_175":24,"_40":660,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":661,"_17":662},{"_36":655,"_13":82,"_65":635,"_46":611,"_38":39,"_174":650,"_175":24,"_40":656,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":657,"_17":658},{"_36":648,"_13":364,"_65":649,"_46":635,"_38":39,"_174":650,"_175":24,"_40":651,"_42":26,"_68":21,"_177":652,"_69":30,"_178":-5,"_298":653,"_17":654},{"_36":641,"_13":93,"_65":642,"_46":635,"_38":39,"_174":643,"_175":24,"_40":644,"_42":26,"_68":21,"_177":645,"_69":30,"_178":-5,"_298":646,"_17":647},{"_36":633,"_13":349,"_65":634,"_46":635,"_38":39,"_174":636,"_175":24,"_40":637,"_42":26,"_68":21,"_177":638,"_69":30,"_178":-5,"_298":639,"_17":640},{"_36":626,"_13":93,"_65":627,"_46":611,"_38":39,"_174":628,"_175":24,"_40":629,"_42":26,"_68":21,"_177":630,"_69":30,"_178":-5,"_298":631,"_17":632},{"_36":618,"_13":619,"_65":620,"_46":611,"_38":39,"_174":621,"_175":24,"_40":622,"_42":26,"_68":21,"_177":623,"_69":30,"_178":-5,"_298":624,"_17":625},{"_36":609,"_13":102,"_65":610,"_46":611,"_38":39,"_174":612,"_175":24,"_40":613,"_42":26,"_68":21,"_177":614,"_69":30,"_178":-5,"_298":615,"_17":616},{"_36":605,"_13":563,"_65":557,"_46":-5,"_38":39,"_174":567,"_175":24,"_40":606,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":607,"_17":608},{"_36":601,"_13":82,"_65":581,"_46":557,"_38":39,"_174":596,"_175":24,"_40":602,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":603,"_17":604},{"_36":594,"_13":364,"_65":595,"_46":581,"_38":39,"_174":596,"_175":24,"_40":597,"_42":26,"_68":21,"_177":598,"_69":30,"_178":-5,"_298":599,"_17":600},{"_36":587,"_13":93,"_65":588,"_46":581,"_38":39,"_174":589,"_175":24,"_40":590,"_42":26,"_68":21,"_177":591,"_69":30,"_178":-5,"_298":592,"_17":593},{"_36":579,"_13":349,"_65":580,"_46":581,"_38":39,"_174":582,"_175":24,"_40":583,"_42":26,"_68":21,"_177":584,"_69":30,"_178":-5,"_298":585,"_17":586},{"_36":572,"_13":93,"_65":573,"_46":557,"_38":39,"_174":574,"_175":24,"_40":575,"_42":26,"_68":21,"_177":576,"_69":30,"_178":-5,"_298":577,"_17":578},{"_36":564,"_13":565,"_65":566,"_46":557,"_38":39,"_174":567,"_175":24,"_40":568,"_42":26,"_68":21,"_177":569,"_69":30,"_178":-5,"_298":570,"_17":571},{"_36":555,"_13":102,"_65":556,"_46":557,"_38":39,"_174":558,"_175":24,"_40":559,"_42":26,"_68":21,"_177":560,"_69":30,"_178":-5,"_298":561,"_17":562},{"_36":551,"_13":550,"_65":544,"_46":-5,"_38":39,"_174":545,"_175":24,"_40":552,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":553,"_17":554},{"_36":542,"_13":93,"_65":543,"_46":544,"_38":39,"_174":545,"_175":24,"_40":546,"_42":26,"_68":21,"_177":547,"_69":30,"_178":-5,"_298":548,"_17":549},{"_36":538,"_13":496,"_65":490,"_46":-5,"_38":39,"_174":500,"_175":24,"_40":539,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":540,"_17":541},{"_36":534,"_13":82,"_65":514,"_46":490,"_38":39,"_174":529,"_175":24,"_40":535,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":536,"_17":537},{"_36":527,"_13":364,"_65":528,"_46":514,"_38":39,"_174":529,"_175":24,"_40":530,"_42":26,"_68":21,"_177":531,"_69":30,"_178":-5,"_298":532,"_17":533},{"_36":520,"_13":93,"_65":521,"_46":514,"_38":39,"_174":522,"_175":24,"_40":523,"_42":26,"_68":21,"_177":524,"_69":30,"_178":-5,"_298":525,"_17":526},{"_36":512,"_13":349,"_65":513,"_46":514,"_38":39,"_174":515,"_175":24,"_40":516,"_42":26,"_68":21,"_177":517,"_69":30,"_178":-5,"_298":518,"_17":519},{"_36":505,"_13":93,"_65":506,"_46":490,"_38":39,"_174":507,"_175":24,"_40":508,"_42":26,"_68":21,"_177":509,"_69":30,"_178":-5,"_298":510,"_17":511},{"_36":497,"_13":498,"_65":499,"_46":490,"_38":39,"_174":500,"_175":24,"_40":501,"_42":26,"_68":21,"_177":502,"_69":30,"_178":-5,"_298":503,"_17":504},{"_36":488,"_13":102,"_65":489,"_46":490,"_38":39,"_174":491,"_175":24,"_40":492,"_42":26,"_68":21,"_177":493,"_69":30,"_178":-5,"_298":494,"_17":495},{"_36":484,"_13":403,"_65":397,"_46":-5,"_38":39,"_174":407,"_175":24,"_40":485,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":486,"_17":487},{"_36":480,"_13":82,"_65":434,"_46":397,"_38":39,"_174":470,"_175":24,"_40":481,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":482,"_17":483},{"_36":476,"_13":475,"_65":469,"_46":434,"_38":39,"_174":470,"_175":24,"_40":477,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":478,"_17":479},{"_36":467,"_13":102,"_65":468,"_46":469,"_38":39,"_174":470,"_175":24,"_40":471,"_42":26,"_68":21,"_177":472,"_69":30,"_178":-5,"_298":473,"_17":474},{"_36":463,"_13":462,"_65":456,"_46":434,"_38":39,"_174":457,"_175":24,"_40":464,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":465,"_17":466},{"_36":454,"_13":93,"_65":455,"_46":456,"_38":39,"_174":457,"_175":24,"_40":458,"_42":26,"_68":21,"_177":459,"_69":30,"_178":-5,"_298":460,"_17":461},{"_36":447,"_13":364,"_65":448,"_46":434,"_38":39,"_174":449,"_175":24,"_40":450,"_42":26,"_68":21,"_177":451,"_69":30,"_178":-5,"_298":452,"_17":453},{"_36":440,"_13":93,"_65":441,"_46":434,"_38":39,"_174":442,"_175":24,"_40":443,"_42":26,"_68":21,"_177":444,"_69":30,"_178":-5,"_298":445,"_17":446},{"_36":432,"_13":349,"_65":433,"_46":434,"_38":39,"_174":435,"_175":24,"_40":436,"_42":26,"_68":21,"_177":437,"_69":30,"_178":-5,"_298":438,"_17":439},{"_36":428,"_13":427,"_65":421,"_46":397,"_38":39,"_174":422,"_175":24,"_40":429,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":430,"_17":431},{"_36":419,"_13":102,"_65":420,"_46":421,"_38":39,"_174":422,"_175":24,"_40":423,"_42":26,"_68":21,"_177":424,"_69":30,"_178":-5,"_298":425,"_17":426},{"_36":412,"_13":93,"_65":413,"_46":397,"_38":39,"_174":414,"_175":24,"_40":415,"_42":26,"_68":21,"_177":416,"_69":30,"_178":-5,"_298":417,"_17":418},{"_36":404,"_13":405,"_65":406,"_46":397,"_38":39,"_174":407,"_175":24,"_40":408,"_42":26,"_68":21,"_177":409,"_69":30,"_178":-5,"_298":410,"_17":411},{"_36":395,"_13":102,"_65":396,"_46":397,"_38":39,"_174":398,"_175":24,"_40":399,"_42":26,"_68":21,"_177":400,"_69":30,"_178":-5,"_298":401,"_17":402},{"_36":391,"_13":384,"_65":387,"_46":-5,"_38":39,"_174":379,"_175":24,"_40":392,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":393,"_17":394},{"_36":386,"_13":385,"_65":378,"_46":387,"_38":39,"_174":379,"_175":24,"_40":388,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":389,"_17":390},{"_36":376,"_13":93,"_65":377,"_46":378,"_38":39,"_174":379,"_175":24,"_40":380,"_42":26,"_68":21,"_177":381,"_69":30,"_178":-5,"_298":382,"_17":383},{"_36":173,"_13":18,"_65":103,"_46":-5,"_38":39,"_174":43,"_175":24,"_40":373,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":374,"_17":375},{"_36":196,"_13":82,"_65":81,"_46":103,"_38":39,"_174":75,"_175":24,"_40":370,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":371,"_17":372},{"_36":363,"_13":364,"_65":365,"_46":81,"_38":39,"_174":75,"_175":24,"_40":366,"_42":26,"_68":21,"_177":367,"_69":30,"_178":-5,"_298":368,"_17":369},{"_36":356,"_13":93,"_65":357,"_46":81,"_38":39,"_174":358,"_175":24,"_40":359,"_42":26,"_68":21,"_177":360,"_69":30,"_178":-5,"_298":361,"_17":362},{"_36":348,"_13":349,"_65":350,"_46":81,"_38":39,"_174":351,"_175":24,"_40":352,"_42":26,"_68":21,"_177":353,"_69":30,"_178":-5,"_298":354,"_17":355},{"_36":192,"_13":93,"_65":92,"_46":103,"_38":39,"_174":86,"_175":24,"_40":345,"_42":26,"_68":21,"_177":194,"_69":30,"_178":-5,"_298":346,"_17":347},{"_36":188,"_13":102,"_65":101,"_46":103,"_38":39,"_174":96,"_175":24,"_40":342,"_42":26,"_68":21,"_177":190,"_69":30,"_178":-5,"_298":343,"_17":344},{"_36":184,"_13":67,"_65":66,"_46":103,"_38":39,"_174":43,"_175":24,"_40":339,"_42":26,"_68":21,"_177":186,"_69":30,"_178":-5,"_298":340,"_17":341},{"_36":335,"_13":334,"_65":328,"_46":-5,"_38":39,"_174":329,"_175":24,"_40":336,"_42":26,"_68":83,"_177":-5,"_69":30,"_178":-5,"_298":337,"_17":338},{"_36":325,"_13":326,"_65":327,"_46":328,"_38":39,"_174":329,"_175":24,"_40":330,"_42":26,"_68":21,"_177":331,"_69":30,"_178":-5,"_298":332,"_17":333},{"_36":317,"_13":318,"_65":319,"_46":-5,"_38":39,"_174":138,"_175":24,"_40":320,"_42":26,"_68":321,"_177":322,"_69":30,"_178":-5,"_298":323,"_17":324},{"_36":309,"_13":310,"_65":311,"_46":-5,"_38":39,"_174":312,"_175":24,"_40":313,"_42":26,"_68":21,"_177":314,"_69":30,"_178":-5,"_298":315,"_17":316},{"_36":301,"_13":302,"_65":303,"_46":-5,"_38":39,"_174":304,"_175":24,"_40":305,"_42":26,"_68":21,"_177":306,"_69":30,"_178":-5,"_298":307,"_17":308},{"_36":292,"_13":293,"_65":294,"_46":-5,"_38":39,"_174":295,"_175":24,"_40":296,"_42":26,"_68":21,"_177":297,"_69":30,"_178":-5,"_298":299,"_17":300},"1e5175c8-538e-11f1-8615-ee650bb23af1","middleware.ts","1e5176ae-538e-11f1-8615-ee650bb23af1",36,["D",1779200528421],"import type { MiddlewareHandler } from \"npm:hono@3\";\nimport { verify } from \"npm:hono@3/jwt\";\n\nconst JWT_SECRET = (globalThis as any).Deno?.env?.get?.(\"JWT_SECRET\") ?? \"dev-secret-change-me\";\n\nconst PUBLIC = new Set([\"/auth/login\",\"/auth/register\",\"/auth/forgot\",\"/auth/reset\"]);\n\nconst middleware: MiddlewareHandler = async (c, next) => {\n const path = new URL(c.req.url).pathname;\n for (const p of PUBLIC) {\n if (path === p || path.startsWith(p + \"/\")) return await next();\n }\n\n const auth = c.req.header(\"authorization\") ?? \"\";\n const token = auth.replace(/^Bearer\\s+/i, \"\");\n if (!token) return c.json({ error: \"missing token\" }, 401);\n try {\n const payload = await verify(token, JWT_SECRET);\n (c as any).set(\"user\", payload);\n return await next();\n } catch {\n return c.json({ error: \"invalid token\" }, 401);\n }\n};\n\nexport default middleware;\n","children",[],[293],"111d4260-538e-11f1-b04e-ee650bb23af1","middleware-rbac.ts","111d4328-538e-11f1-b04e-ee650bb23af1",6,["D",1779200506262],"import { db, eq } from \"./db.ts\";\nimport { users } from \"./users/users.table.ts\";\n\nconst RULES: Array<{ re: RegExp; roles: Set }> = [\n \n { re: new RegExp(\"^/categories(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/items(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/toppings(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/item_toppings(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/customers(/|$)\"), roles: new Set([\"manager\",]) },\n \n];\n\nconst userCache = new Map();\nconst CACHE_MS = 30_000;\n\n/**\n * RBAC middleware. Must mount AFTER auth middleware (which sets c.get(\"userId\")).\n * For each rule whose regex matches the URL path, the user.role must be in roles.\n * If multiple rules match, all must allow.\n */\nexport default async function rbac(c: any, next: any) {\n const path = new URL(c.req.url).pathname;\n const matched = RULES.filter((r) => r.re.test(path));\n if (matched.length === 0) return next();\n\n const userId = Number(c.get?.(\"userId\") ?? c.get?.(\"user\")?.id ?? 0);\n if (!Number.isFinite(userId) || userId <= 0) {\n c.status(401);\n return c.json({ error: \"unauthorized\" });\n }\n\n let cached = userCache.get(userId);\n if (!cached || Date.now() - cached.at > CACHE_MS) {\n const [u] = await db.select().from(users).where(eq((users as any).id, userId));\n cached = { role: (u as any)?.role ?? null, at: Date.now() };\n userCache.set(userId, cached);\n }\n\n const role = cached.role ?? \"\";\n for (const r of matched) {\n if (!r.roles.has(role)) {\n c.status(403);\n return c.json({ error: \"forbidden\", role, required: [...r.roles] });\n }\n }\n return next();\n}\n",[],[302],"0fd11062-538e-11f1-9e88-ee650bb23af1","db.ts","0fd1112a-538e-11f1-9e88-ee650bb23af1",3,["D",1779200504083],"// AUTO-GENERATED by Manh. Do not edit.\n//\n// Drizzle helpers barrel. Per-entity tables are NOT re-exported from here —\n// each lives at `app//.table.ts` and handlers import\n// directly from the relative path, e.g.\n// import { db, eq } from \"app/db\";\n// import { products } from \"./products.table\";\n// This makes table provenance grep-able and removes a magic barrel.\nimport { createClient } from \"npm:@libsql/client@0.14.0\";\nimport { drizzle } from \"npm:drizzle-orm@0.44.2/libsql/web\";\nexport { sqliteTable, integer, text, real, blob } from \"npm:drizzle-orm@0.44.2/sqlite-core\";\nexport { eq, ne, lt, lte, gt, gte, like, ilike, and, or, not, isNull, isNotNull, inArray, notInArray, between, asc, desc, sql, count, sum, avg, min, max } from \"npm:drizzle-orm@0.44.2\";\nexport { alias } from \"npm:drizzle-orm@0.44.2/sqlite-core\";\n\nconst client = createClient({\n url: \"libsql://ft-c87529eef42b643608e635f93-ictuer.turso.io\",\n authToken: \"eyJhbGciOiJFZERTQSIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE3NzkyMDA0OTYsImlkIjoiMDE5ZTQwOWQtMGQwMS03MDQwLWFiMDctZmQwODhhMWI2OTczIiwicmlkIjoiYTA4NTRkNmQtNWU4Ny00MjAwLTkzYjItZjc1ZDEwYWEzNTQ1In0.ZaELDfkr6rvAPL0IYJwwU7oUUVLC7Nk2vFssD7BqmrsDY0XnG0NM_4AqzP1woA6EMHi-TX-3D24PtgMxz9F2Dg\",\n});\nexport const db = drizzle(client);\n",[],[310],"25c600d0-538e-11f1-95eb-ee650bb23af1","api.ts","25c60206-538e-11f1-95eb-ee650bb23af1",["D",1779200540929],"http","import { OpenAPIHono, createRoute, z } from \"npm:@hono/zod-openapi@0.18\";\nimport { swaggerUI } from \"npm:@hono/swagger-ui@0.4\";\nimport { cors } from \"npm:hono@3/cors\";\nimport mw_middleware from \"./middleware.ts\";\nimport auth_login_post from \"./auth/login/post.ts\";\nimport auth_me_get from \"./auth/me/get.ts\";\nimport auth_register_post from \"./auth/register/post.ts\";\nimport categories_get from \"./categories/get.ts\";\nimport categories_post from \"./categories/post.ts\";\nimport categories__id__int__delete from \"./categories/[id__int]/delete.ts\";\nimport categories__id__int__get from \"./categories/[id__int]/get.ts\";\nimport categories__id__int__patch from \"./categories/[id__int]/patch.ts\";\nimport customers_get from \"./customers/get.ts\";\nimport customers_post from \"./customers/post.ts\";\nimport customers__id__int__delete from \"./customers/[id__int]/delete.ts\";\nimport customers__id__int__get from \"./customers/[id__int]/get.ts\";\nimport customers__id__int__patch from \"./customers/[id__int]/patch.ts\";\nimport customers_search_get from \"./customers/search/get.ts\";\nimport item_toppings_get from \"./item_toppings/get.ts\";\nimport item_toppings_post from \"./item_toppings/post.ts\";\nimport item_toppings__id__int__delete from \"./item_toppings/[id__int]/delete.ts\";\nimport item_toppings__id__int__get from \"./item_toppings/[id__int]/get.ts\";\nimport item_toppings__id__int__patch from \"./item_toppings/[id__int]/patch.ts\";\nimport items_get from \"./items/get.ts\";\nimport items_post from \"./items/post.ts\";\nimport items__id__int__delete from \"./items/[id__int]/delete.ts\";\nimport items__id__int__get from \"./items/[id__int]/get.ts\";\nimport items__id__int__patch from \"./items/[id__int]/patch.ts\";\nimport menu_get from \"./menu/get.ts\";\nimport order_items_get from \"./order_items/get.ts\";\nimport order_items_post from \"./order_items/post.ts\";\nimport order_items__id__int__delete from \"./order_items/[id__int]/delete.ts\";\nimport order_items__id__int__get from \"./order_items/[id__int]/get.ts\";\nimport order_items__id__int__patch from \"./order_items/[id__int]/patch.ts\";\nimport orders_get from \"./orders/get.ts\";\nimport orders_post from \"./orders/post.ts\";\nimport orders__id__int__delete from \"./orders/[id__int]/delete.ts\";\nimport orders__id__int__get from \"./orders/[id__int]/get.ts\";\nimport orders__id__int__patch from \"./orders/[id__int]/patch.ts\";\nimport orders__id__int__cancel_post from \"./orders/[id__int]/cancel/post.ts\";\nimport orders__id__int__invoice_get from \"./orders/[id__int]/invoice/get.ts\";\nimport orders_bulk_delete_post from \"./orders/bulk-delete/post.ts\";\nimport reports_export_get from \"./reports/export/get.ts\";\nimport toppings_get from \"./toppings/get.ts\";\nimport toppings_post from \"./toppings/post.ts\";\nimport toppings__id__int__delete from \"./toppings/[id__int]/delete.ts\";\nimport toppings__id__int__get from \"./toppings/[id__int]/get.ts\";\nimport toppings__id__int__patch from \"./toppings/[id__int]/patch.ts\";\n\nconst app = new OpenAPIHono();\napp.use(\"*\", cors({\n origin: \"*\",\n allowMethods: [\"GET\", \"POST\", \"PUT\", \"DELETE\", \"PATCH\", \"OPTIONS\"],\n allowHeaders: [\"Content-Type\", \"Authorization\"],\n maxAge: 86400,\n}));\n\napp.use(\"*\", ...( Array.isArray(mw_middleware) ? mw_middleware : [mw_middleware] ));\n\nfunction normalizeRequest(s, autoParams) {\n const r = s ? { ...s } : {};\n if (r.body && typeof r.body.safeParse === \"function\") {\n r.body = { content: { \"application/json\": { schema: r.body } } };\n }\n if (autoParams) r.params = autoParams;\n return (r.body || r.query || r.params || r.headers) ? r : undefined;\n}\n\nfunction wrapHandler(fn) {\n return async (c) => {\n let result;\n try {\n result = await fn(c);\n } catch (err) {\n if (err && err.name === \"HTTPException\") throw err;\n console.error(\"[handler error]\", c.req.method, c.req.path, err);\n const dev = (globalThis.Deno?.env?.get?.(\"FLOWTEST_LEAK_ERRORS\") ?? \"1\") === \"1\";\n if (dev) {\n const chain = []; let e = err;\n while (e) { chain.push(String(e.message ?? e) + (e.stack ? \"\\n\" + e.stack : \"\")); e = e.cause; }\n return c.json({ error: String(err?.message ?? err), chain }, 500);\n }\n return c.text(\"Internal Server Error\", 500);\n }\n if (result instanceof Response) return result;\n if (result === null || result === undefined) return c.body(null, c.res.status ?? 204);\n if (typeof result === \"string\") return c.text(result);\n return c.json(result);\n };\n}\n\napp.doc(\"/openapi.json\", { openapi: \"3.1.0\", info: { title: \"Manh API\", version: \"1.0.0\" } });\napp.get(\"/docs\", swaggerUI({ url: \"/openapi.json\" }));\n\napp.openapi(createRoute({ method: \"post\", path: \"/auth/login\", request: normalizeRequest(undefined, undefined) }), wrapHandler(auth_login_post));\napp.openapi(createRoute({ method: \"get\", path: \"/auth/me\", request: normalizeRequest(undefined, undefined) }), wrapHandler(auth_me_get));\napp.openapi(createRoute({ method: \"post\", path: \"/auth/register\", request: normalizeRequest(undefined, undefined) }), wrapHandler(auth_register_post));\napp.openapi(createRoute({ method: \"get\", path: \"/categories\", request: normalizeRequest(undefined, undefined) }), wrapHandler(categories_get));\napp.openapi(createRoute({ method: \"post\", path: \"/categories\", request: normalizeRequest(undefined, undefined) }), wrapHandler(categories_post));\napp.openapi(createRoute({ method: \"delete\", path: \"/categories/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(categories__id__int__delete));\napp.openapi(createRoute({ method: \"get\", path: \"/categories/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(categories__id__int__get));\napp.openapi(createRoute({ method: \"patch\", path: \"/categories/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(categories__id__int__patch));\napp.openapi(createRoute({ method: \"get\", path: \"/customers\", request: normalizeRequest(undefined, undefined) }), wrapHandler(customers_get));\napp.openapi(createRoute({ method: \"post\", path: \"/customers\", request: normalizeRequest(undefined, undefined) }), wrapHandler(customers_post));\napp.openapi(createRoute({ method: \"delete\", path: \"/customers/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(customers__id__int__delete));\napp.openapi(createRoute({ method: \"get\", path: \"/customers/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(customers__id__int__get));\napp.openapi(createRoute({ method: \"patch\", path: \"/customers/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(customers__id__int__patch));\napp.openapi(createRoute({ method: \"get\", path: \"/customers/search\", request: normalizeRequest(undefined, undefined) }), wrapHandler(customers_search_get));\napp.openapi(createRoute({ method: \"get\", path: \"/item_toppings\", request: normalizeRequest(undefined, undefined) }), wrapHandler(item_toppings_get));\napp.openapi(createRoute({ method: \"post\", path: \"/item_toppings\", request: normalizeRequest(undefined, undefined) }), wrapHandler(item_toppings_post));\napp.openapi(createRoute({ method: \"delete\", path: \"/item_toppings/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(item_toppings__id__int__delete));\napp.openapi(createRoute({ method: \"get\", path: \"/item_toppings/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(item_toppings__id__int__get));\napp.openapi(createRoute({ method: \"patch\", path: \"/item_toppings/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(item_toppings__id__int__patch));\napp.openapi(createRoute({ method: \"get\", path: \"/items\", request: normalizeRequest(undefined, undefined) }), wrapHandler(items_get));\napp.openapi(createRoute({ method: \"post\", path: \"/items\", request: normalizeRequest(undefined, undefined) }), wrapHandler(items_post));\napp.openapi(createRoute({ method: \"delete\", path: \"/items/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(items__id__int__delete));\napp.openapi(createRoute({ method: \"get\", path: \"/items/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(items__id__int__get));\napp.openapi(createRoute({ method: \"patch\", path: \"/items/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(items__id__int__patch));\napp.openapi(createRoute({ method: \"get\", path: \"/menu\", request: normalizeRequest(undefined, undefined) }), wrapHandler(menu_get));\napp.openapi(createRoute({ method: \"get\", path: \"/order_items\", request: normalizeRequest(undefined, undefined) }), wrapHandler(order_items_get));\napp.openapi(createRoute({ method: \"post\", path: \"/order_items\", request: normalizeRequest(undefined, undefined) }), wrapHandler(order_items_post));\napp.openapi(createRoute({ method: \"delete\", path: \"/order_items/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(order_items__id__int__delete));\napp.openapi(createRoute({ method: \"get\", path: \"/order_items/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(order_items__id__int__get));\napp.openapi(createRoute({ method: \"patch\", path: \"/order_items/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(order_items__id__int__patch));\napp.openapi(createRoute({ method: \"get\", path: \"/orders\", request: normalizeRequest(undefined, undefined) }), wrapHandler(orders_get));\napp.openapi(createRoute({ method: \"post\", path: \"/orders\", request: normalizeRequest(undefined, undefined) }), wrapHandler(orders_post));\napp.openapi(createRoute({ method: \"delete\", path: \"/orders/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(orders__id__int__delete));\napp.openapi(createRoute({ method: \"get\", path: \"/orders/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(orders__id__int__get));\napp.openapi(createRoute({ method: \"patch\", path: \"/orders/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(orders__id__int__patch));\napp.openapi(createRoute({ method: \"post\", path: \"/orders/{id__int}/cancel\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(orders__id__int__cancel_post));\napp.openapi(createRoute({ method: \"get\", path: \"/orders/{id__int}/invoice\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(orders__id__int__invoice_get));\napp.openapi(createRoute({ method: \"post\", path: \"/orders/bulk-delete\", request: normalizeRequest(undefined, undefined) }), wrapHandler(orders_bulk_delete_post));\napp.openapi(createRoute({ method: \"get\", path: \"/reports/export\", request: normalizeRequest(undefined, undefined) }), wrapHandler(reports_export_get));\napp.openapi(createRoute({ method: \"get\", path: \"/toppings\", request: normalizeRequest(undefined, undefined) }), wrapHandler(toppings_get));\napp.openapi(createRoute({ method: \"post\", path: \"/toppings\", request: normalizeRequest(undefined, undefined) }), wrapHandler(toppings_post));\napp.openapi(createRoute({ method: \"delete\", path: \"/toppings/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(toppings__id__int__delete));\napp.openapi(createRoute({ method: \"get\", path: \"/toppings/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(toppings__id__int__get));\napp.openapi(createRoute({ method: \"patch\", path: \"/toppings/{id__int}\", request: normalizeRequest(undefined, z.object({ id__int: z.string().openapi({ param: { name: \"id__int\", in: \"path\" } }) })) }), wrapHandler(toppings__id__int__patch));\n\nexport default app.fetch;\n",[],[318],"1293748e-538e-11f1-961c-ee650bb23af1","users.table.ts","1293756a-538e-11f1-961c-ee650bb23af1","63ba00c1-b0bd-4da6-8a19-f24b493ed350",10,["D",1779200508719],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const users = sqliteTable(\"users\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n email: text(\"email\").notNull(),\n \n password_hash: text(\"password_hash\").notNull(),\n \n name: text(\"name\"),\n \n role: text(\"role\").notNull(),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[334,326],"users","12938118-538e-11f1-961c-ee650bb23af1",["D",1779200508719],[287],[334],["D",1779200508127],[],[18,67],["D",1779200540279],[],[18,102],["D",1779200539658],[],[18,93],"24a3c1b0-538e-11f1-bd07-ee650bb23af1","patch.ts","24a3c2aa-538e-11f1-bd07-ee650bb23af1",53,["D",1779200539019],"import { db, eq } from \"../../db.ts\";\nimport { toppings } from \"../toppings.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(toppings).set({ ...body, updated_at: now } as any).where(eq((toppings as any).id, id));\n return { success: true };\n}\n",[],[18,82,349],"24468838-538e-11f1-bd07-ee650bb23af1","244688e2-538e-11f1-bd07-ee650bb23af1",52,["D",1779200538414],"import { db, eq } from \"../../db.ts\";\nimport { toppings } from \"../toppings.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(toppings).where(eq((toppings as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[18,82,93],"23de83aa-538e-11f1-93f6-ee650bb23af1","delete.ts","23de8472-538e-11f1-93f6-ee650bb23af1",["D",1779200537726],"import { db, eq } from \"../../db.ts\";\nimport { toppings } from \"../toppings.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(toppings).set({ deleted_at: now } as any).where(eq((toppings as any).id, id));\n return { success: true };\n}\n",[],[18,82,364],["D",1779200537726],[280,281,282],[18,82],["D",1779200508127],[279,283,284,285],[18],"23829626-538e-11f1-ae69-ee650bb23af1","23829702-538e-11f1-ae69-ee650bb23af1","5bde5f67-32eb-4b1d-a07d-435efcadd901",50,["D",1779200537129],"import { Context } from \"npm:hono@3\";\nimport { db, eq, and, gte, lte, sql, count, sum } from \"../../db.ts\";\nimport { orders } from \"../../orders/orders.table.ts\";\nimport { order_items } from \"../../order_items/order_items.table.ts\";\nimport * as XLSX from \"npm:xlsx\";\nimport { eq, lte, gte, and, sql, count, sum, db } from \"../../db.ts\";\n\nexport default async function handler(c: Context) {\n const { period = \"day\", from, to } = c.req.query();\n\n // Default to current month if no range given\n const now = new Date();\n let fromDate: Date;\n let toDate: Date;\n if (from) {\n fromDate = new Date(from);\n } else {\n fromDate = new Date(now.getFullYear(), now.getMonth(), 1);\n }\n if (to) {\n toDate = new Date(to);\n } else {\n toDate = new Date(now.getFullYear(), now.getMonth() + 1, 0, 23, 59, 59);\n }\n\n // Build date truncation truncation expression\n let dateTrunc: ReturnType;\n switch (period) {\n case \"week\":\n dateTrunc = sql`DATE_TRUNC('week', ${orders.created_at})`;\n break;\n case \"month\":\n dateTrunc = sql`('month', ${orders.created_at})`;\n break;\n default:\n dateTrunc = sql`('day', ${orders.created_at})`;\n }\n\n const dateTruncExpr = sql`DATE_TRUNC(${dateTrunc})`;\n\n // Aggregated data: sales by period, including completed orders only\n const aggregated = await db\n .select({\n period: dateTruncExpr,\n orderCount: count: .from(orders),\n total_sales: sum(orders.total),\n avg_order_value: sql`( ${sum(orders.total)} / ${count()} )`,\n ))\n .from(orders)\n .where(\n and(\n eq(orders.status, \"completed\"),\n gte(orders.created_at, fromDate),\n lte(orders.created_at, toDate)\n )\n )\n .groupBy(dateTruncExpr)\n .orderBy({ period: \"asc\" });\n\n // Build Excel workbook\n const ws_data = [\n [\"Period\", \"Order Count\", \"Total Sales\", \"Average Order Value\"],\n ...agregated.map((row) => [\n new Date(row.period instanceof Date ? row.period.toISOString() : String(row.period)),\n row.count,\n Number(row.total_sales),\n Number(row.avg_order_value),\n ]),\n ];\n\n const wb = XLSX.utils.book_new();\n const ws = XLSX.utils.ao.utils.aoa_to_sheet(ws_data);\n XLSX.utils.book_append_sheet(wb, ws, \"Report\");\n\n // Column widths for clarity\n ws[\"!cols\"] = [\n { wch: 20 },\n { wch: 15 },\n { wch: 20 },\n { wch: 20 },\n ];\n\n const buffer = XLSX.write(wb, { bookType: \"bookType\": \"xlsx\", \"type\": \"buffer\" });\n\n return new Response(buffer, {\n status: 200,\n headers: {\n \"Content-Type\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"Content-Disposition\": `attachment; filename=\"report_${period}_${fromDate.toISOString().split(\"T\")[0]}.xlsx\"`,\n },\n });\n```",[],[384,385,93],"reports","export","2382c8b2-538e-11f1-ae69-ee650bb23af1","db665c71-026c-40e0-b3ce-169757bc0ce9",["D",1779200537129],[277],[384,385],"2382bf20-538e-11f1-ae69-ee650bb23af1",["D",1779200537129],[276],[384],"2322c2e6-538e-11f1-9b3d-ee650bb23af1","2322c390-538e-11f1-9b3d-ee650bb23af1","e0014934-2105-4b85-8ae1-08943dd7eeac",49,["D",1779200536504],"import { db } from \"../db.ts\";\nimport { orders } from \"./orders.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(orders).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[403,102],"orders","11de7f66-538e-11f1-a631-ee650bb23af1","orders.table.ts","11de8006-538e-11f1-a631-ee650bb23af1",8,["D",1779200507533],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const orders = sqliteTable(\"orders\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n customer_name: text(\"customer_name\"),\n \n table_type: text(\"table_type\").notNull(),\n \n status: text(\"status\").notNull(),\n \n payment_method: text(\"payment_method\"),\n \n total: integer(\"total\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n deleted_at: text(\"deleted_at\"),\n \n});\n",[],[403,405],"22c36224-538e-11f1-bd07-ee650bb23af1","22c3633c-538e-11f1-bd07-ee650bb23af1",48,["D",1779200535858],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { orders } from \"./orders.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n filters.push(isNull((orders as any).deleted_at));\n \n \n if (q.q) filters.push(like((orders as any).customer_name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (orders as any)[sortKey] ?? (orders as any).id;\n\n const rows = await db.select().from(orders).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(orders).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[403,93],"2252a11a-538e-11f1-8d89-ee650bb23af1","2252a1f6-538e-11f1-8d89-ee650bb23af1","a5c12570-4501-44f7-8fc4-9b39652f5413",47,["D",1779200535133],"import { db, inArray } from \"../../db.ts\";\nimport { orders } from \"../orders.table.ts\";\n\n// body: { ids: number[] }\n// returns: { success: true; count: number }\nexport default async function handler(c: any) {\n const { ids } = await c.req.json() as { ids: number[] };\n if (!Array.isArray(ids) || ids.length === 0) return { success: true, count: 0 };\n const now = new Date().toISOString();\n await db.update(orders).set({ deleted_at: now } as any).where(inArray((orders as any).id, ids));\n return { success: true, count: ids.length };\n}\n",[],[403,427,102],"bulk-delete","2252af8e-538e-11f1-8d89-ee650bb23af1",["D",1779200535133],[271],[403,427],"21f99336-538e-11f1-bcd6-ee650bb23af1","21f993ea-538e-11f1-bcd6-ee650bb23af1","d94c8a97-4cbd-4f10-9c5e-85d3b8616298",46,["D",1779200534559],"import { db, eq } from \"../../db.ts\";\nimport { orders } from \"../orders.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(orders).set({ ...body, updated_at: now } as any).where(eq((orders as any).id, id));\n return { success: true };\n}\n",[],[403,82,349],"214a50ec-538e-11f1-ae22-ee650bb23af1","214a5240-538e-11f1-ae22-ee650bb23af1",44,["D",1779200533411],"import { db, eq } from \"../../db.ts\";\nimport { orders } from \"../orders.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(orders).where(eq((orders as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[403,82,93],"20f3dbc2-538e-11f1-b9b6-ee650bb23af1","20f3dc76-538e-11f1-b9b6-ee650bb23af1",43,["D",1779200532843],"import { db, eq } from \"../../db.ts\";\nimport { orders } from \"../orders.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(orders).set({ deleted_at: now } as any).where(eq((orders as any).id, id));\n return { success: true };\n}\n",[],[403,82,364],"21a3b4e8-538e-11f1-ae22-ee650bb23af1","21a3b61e-538e-11f1-ae22-ee650bb23af1","988c3b09-04e7-422a-80c8-a69b70c2ffe9",45,["D",1779200533995],"import { db, eq, and, sum, not } from \"../../../db.ts\";\nimport { orders } from \"../../orders.table.ts\";\nimport { orderItems } from \"../../../order-items/order-items.table\";\nimport { items } from \"../../../items/items.table.ts\";\nimport { categories } from \"../../../categories/categories.table.ts\";\nimport PDFDocument from \"npm:pdfkit\";\nimport { formatCurrency } from \"../../../utils\"; // assume exists\n\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\"));\n if (isNaN(id) || id <= 0) {\n c.status(400);\n return { error: \"ID không hợp lệ\" };\n }\n\n // Fetch order (including soft-deleted: orders has softDelete=true, so we need to include deleted? Usually we want only non-deleted, but for invoice we might include deleted orders? Probably not. We'll filter deleted_at IS NULL.)\n // The orders table has softDelete, so we need to exclude deleted. We'll use and() to add condition deleted_at is null.\n const [order] = await db\n .select()\n .from(orders)\n .where(and(eq(orders.id, id), eq(orders.deleted_at, null)))\n .limit(1);\n\n if (!order) if (!order) {\n c.status(404);\n return { error: \"Đơn hàng không tồn tại hoặc đã bị xóa\" };\n }\n\n // Fetch order items with item and category details\n const orderItemsData = await db\n .select({\n id: orderItems.id,\n quantity: orderItems.quantity,\n unitPrice: orderItems.unit_price,\n subtotal: orderItems.subtotal,\n selectedToppings: orderItems.selected_toppings,\n itemName: items.name,\n itemPrice: items.price,\n category: categories.name,\n })\n .from(orderItems)\n .innerJoin(items, eq(orderItems.item_id, items.id))\n .innerJoin(categories, eq(items.category_id, categories.id))\n .where(eq(orderItems.order_id, id));\n\n // Build invoice data\n const invoiceNumber = `HD-${String(order.id).padStart(6, \"0\")}`;\n const today = new Date().toLocaleDateString(\"vi-VN\", {\n day: \"year\": \"numeric\",\n \"month\": \"numeric\",\n \"day\": \"numeric\",\n });\n const total = order.total ?? 0;\n const paymentMethod = order.payment_method === \"cash\" ? \"Tiền mặt\" : \"Chuyển khoản\";\n\n // Create PDF document (A4)\n const doc = new PDFDocument({ size: \"A4\", margin: 50 });\n const buffers: Buffer[] = [];\n doc.on(\"data\", (chunk: Buffer) => buffers.push(chunk));\n doc.on(\"end\", () => {});\n\n // Helper to draw a line\n const drawLine = (y: number) => {\n doc.moveTo(50, y).lineTo(545, y).strokeColor(\"#ccc\").stroke();\n doc.strokeColor(\"#000\");\n };\n\n // Header\n doc.font(\"Helvetica-Bold\").fontSize(24);\n doc.text(\"HÓA ĐƠN BÁN HÀNG\", { align: \"center\" });\n doc.moveDown(0.5);\n doc.fontSize(10).font(\"Helvetica\");\n doc.text(`Số: ${invoiceNumber}`, { align: \"center\" });\n doc.moveDown(1);\n\n // Store info\n doc.fontSize(12).font(\"Helvetica-Bold\");\n doc.text(\"Cafe POS\", { align: \"center\" });\n doc.fontSize(10).font(\"Helvetica\");\n doc.text(\"Địa chỉ: 123 Nguyễn Văn Cừ, P.1, Q.5, TP.HCM\", { align: \"center\" });\n doc.text(\"Điện thoại: (028) 3828292\", { align: \"center\" });\n doc.moveDown(1 documents.\n\n // Invoice details line\n doc.fontSize(10);\n doc.text(\"Ngày xuất: \" + today);\n doc.text(\"Phương thức: \" + paymentMethod);\n doc.text(\"Trạng thái: \" + (order.status === \"completed\" ? \"Hoàn thành\" : order.status === \"pending\" ? \"Chờ xử lý\" : \"Đã hủy\"));\n if (order.customer_name) {\n doc.text(\"Khách hàng: \" + order.customer_name);\n }\n doc.moveDown(1);\n\n // Table header\n const tableTop = doc.y;\n const colWidth = [15, 210, 60, 70, 70, 70]; // relative widths\n const startX = 50;\n doc.fontSize(8).font(\"Helvetica-Bold\").fillColor(\"#333\");\n doc.text(\"STT\", startX, tableTop, { width: colWidth[0] align: \"left\" });\n doc.text(\"Tên món hàng\", startX + colWidth[0], tableTop, { width: colWidth[1], align: \"left\" });\n doc.text(\"Đơn giá\", startX + colWidth[0] + colWidth[1], tableTop, { width,(colWidth[2]), align: \"right\" });\n doc.text(\"SL\", startX + colWidth[0] + colWidth[1] + colWidth[2], tableTop, { width: colWidth[3]), align: \"center\" });\n doc.text(\"Topping\", startX + colWidth[0] + colWidth[1] + colWidth[2] + colWidth[3], tableTop, { width: colWidth[], align: \"left center\"});\n doc.text(\"Thành tiền\", startX + colWidth[0] +1] + colWidth[2] + colWidth[3] + colWidth[4], tableTop, { width: colWidth[5], align: \"right\" });\n drawLine(tableTop + 15);\n\n // Body rows\n let currentY = tableTop + 20;\n doc.font(\"Helvetica\").fontSize(9).fillColor(\"#000\"));\n orderItemsData.forEach((item, index) => {\n const toppings = item.selectedToppings ? JSON.parse(item.selectedToppings .topping_names.join(\", \") : \"\";\n const subtotal = item.subtotal ?? 0;\n doc.text((index + 1).toString(), startX, currentY, { width: colWidth[0], align: \"left\" });\n doc.text(item.itemName + (item.category ? \" (\" + item.category + \")\" : \"\"), startX + colWidth[0], currentY, width: colWidth[1], align: \"left });\n doc.text(formatCurrency(item.unitPrice ?? 0), startX + colWidth[1], currentY, { width,colWidth[2]});\n doc.text, item.quantity, startX + colWidth[1] + colWidth[2], currentY { width: colWidth[3], align: \"center\" });\n doc.text(toppings, startX + colWidth[1] + colWidth[2] + colWidth[3], currentY { width: colWidth[4], left });\n doc.text(formatCurrency(subtotal), startX + colWidth[01] + colWidth[2] + colWidth[3] + colWidth[4], currentY, { width: colWidth[5], align: \"right\" });\n currentY += 16;\n });\n\n // Total line\n drawLine(currentY + 5);\n currentY += 12;\n doc.font(\"Helvetica-Bold\").fontSize(12);\n doc.text(\"Tổng cộng:\", startX, currentY, { width: 400, align: \"right\" });\n doc.text(formatCurrency(total), startX + 400, currentY, { width: 100, align: \"right\" });\n\n // Footer\n doc.moveDown(2);\n doc.fontSize(8).font(\"Helvetica\").fontSize(8).fillColor(\"#555\");\n doc.text(\". Cảm ơn quý khách!\", { align: \"center\" });\n\n // Finalize\n doc.end();\n\n // Wait for buffers to complete\n await\n const pdfBuffer = await new Promise {\n doc.on(\"end), () => resolve(Buffer.concat(buffers)));\n doc.on(\"error\", reject);\n });\n\n // Return PDF\n return new Response(pdfuffer, {\n headers: {\n \"Content-Type\": \"application/pdf\",\n \"Content-Disposition\": `attachment; filename=\"invoice-${id=${id}.pdf\"`,\n },\n });\n}",[],[403,82,462,93],"invoice","21a3fb1a-538e-11f1-ae22-ee650bb23af1",["D",1779200533995],[266],[403,82,462],"209c49e8-538e-11f1-9945-ee650bb23af1","209c4a9c-538e-11f1-9945-ee650bb23af1","f9e89c39-8f70-4f13-9738-fc1fce67ed8e",42,["D",1779200532266],"import { db, eq } from \"../../../db.ts\";\nimport { orders } from \"../../orders.table.ts\";\n\nconst ALLOWED = new Set([\n \"pending\",\"completed\",\n]);\n\n// params: { id: number }\n// body: { status: string }\n// returns: { success: true; status: string }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n if (!Number.isFinite(id)) { c.status(400); return { error: \"invalid id\" }; }\n const body = await c.req.json().catch(() => ({}));\n const next = String(body?.status ?? body?.status ?? \"\");\n if (!ALLOWED.has(next)) {\n c.status(400);\n return { error: `invalid status \"${next}\"`, allowed: [...ALLOWED] };\n }\n const now = new Date().toISOString();\n await db.update(orders).set({ status: next, updated_at: now } as any).where(eq((orders as any).id, id));\n return { success: true, status: next };\n}\n",[],[403,82,475,102],"cancel","209c6ce8-538e-11f1-9945-ee650bb23af1",["D",1779200532266],[264],[403,82,475],"209c6a22-538e-11f1-9945-ee650bb23af1",["D",1779200532266],[263,265,267,268,269],[403,82],"11dea2fc-538e-11f1-a631-ee650bb23af1",["D",1779200507533],[262,270,272,273,274],[403],"20414c8c-538e-11f1-bec8-ee650bb23af1","20414da4-538e-11f1-bec8-ee650bb23af1","fb7f3804-3a85-477d-9b4c-1781458cffb1",41,["D",1779200531665],"import { db } from \"../db.ts\";\nimport { orderItems } from \"./order_items.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(orderItems).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[496,102],"order_items","117b92ca-538e-11f1-961c-ee650bb23af1","order_items.table.ts","117b9374-538e-11f1-961c-ee650bb23af1",7,["D",1779200506879],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const orderItems = sqliteTable(\"order_items\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n order_id: integer(\"order_id\").notNull(),\n \n item_id: integer(\"item_id\").notNull(),\n \n quantity: integer(\"quantity\").notNull(),\n \n unit_price: integer(\"unit_price\"),\n \n subtotal: integer(\"subtotal\"),\n \n selected_toppings: text(\"selected_toppings\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[496,498],"1fe2ee30-538e-11f1-8553-ee650bb23af1","1fe2ef16-538e-11f1-8553-ee650bb23af1",40,["D",1779200531053],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { orderItems } from \"./order_items.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (orderItems as any)[sortKey] ?? (orderItems as any).id;\n\n const rows = await db.select().from(orderItems).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(orderItems).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[496,93],"1f6e1fa6-538e-11f1-8615-ee650bb23af1","1f6e205a-538e-11f1-8615-ee650bb23af1","0d7e6104-0f9b-40f0-956f-57ec00f1264c",39,["D",1779200530286],"import { db, eq } from \"../../db.ts\";\nimport { orderItems } from \"../order_items.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(orderItems).set({ ...body, updated_at: now } as any).where(eq((orderItems as any).id, id));\n return { success: true };\n}\n",[],[496,82,349],"1f0c3282-538e-11f1-bd07-ee650bb23af1","1f0c3318-538e-11f1-bd07-ee650bb23af1",38,["D",1779200529645],"import { db, eq } from \"../../db.ts\";\nimport { orderItems } from \"../order_items.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(orderItems).where(eq((orderItems as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[496,82,93],"1eb43a1e-538e-11f1-bd5d-ee650bb23af1","1eb43b0e-538e-11f1-bd5d-ee650bb23af1",37,["D",1779200529064],"import { db, eq } from \"../../db.ts\";\nimport { orderItems } from \"../order_items.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(orderItems).set({ deleted_at: now } as any).where(eq((orderItems as any).id, id));\n return { success: true };\n}\n",[],[496,82,364],"1eb47452-538e-11f1-bd5d-ee650bb23af1",["D",1779200529064],[255,256,257],[496,82],"117bc1c8-538e-11f1-961c-ee650bb23af1",["D",1779200506879],[254,258,259,260],[496],"1df1e7e8-538e-11f1-b9b6-ee650bb23af1","1df1e89c-538e-11f1-b9b6-ee650bb23af1","af1f6066-00dc-45e2-ae17-f30b9fe07a1f",35,["D",1779200527795],"import { db, eq } from '../db.ts';\nimport { categories } from '../categories/categories.table.ts';\nimport { items } from '../items/items.table.ts';\nimport { toppings } from '../toppings/toppings.table.ts';\nimport { itemToppings } from '../item_toppings/item_toppings.table.ts';\n\nexport default async function handler() {\n // Fetch all categories sorted by sortable categories\n const cats = await db\n .select()\n .from(categories)\n .orderBy(categories.sort_order);\n\n // Fetch only active items\n const activeItems = await db\n .select()\n .from(items)\n .where(eq(items.status, 'active'));\n\n // Fetch all item-topping relations with topping details\n const toppingRows = await db\n .select({\n itemId: itemToppings.item_id,\n topping: {\n id: toppings.id,\n name: toppings.name,\n price: toppings.price,\n },\n })\n .from(itemToppings)\n .innerJoin(toppings, eq(itemToppings.topping_id, toppings.id));\n\n // Group toppings by item id\n const toppingByItem = new Map();\n for (const row of toppingRows) {\n const list = toppingByItem.get(row.itemId);\n if (list) {\n list.push(row.topping);\n } elserow.topping);\n toppingByItem.set(row.itemId, [row.topping]);\n }\n }\n\n // Build category → items structure\n const categoryMap = new Map;\n }>;\n }>();\n\n for (const cat of cats) {\n categoryMap.set(cat.id, { ...cat, items: [] });\n }\n\n for (const item of activeItems) {\n const parent = categoryMap.get(item.category_id);\n if (!parent) continue;\n\n parent.items.push({\n id: item.id,\n name: item.name,\n price: item.price,\n description: item.description,\n image: item.image,\n status: item.status,\n toppings: toppingByItem.get(item.id) || [],\n });\n }\n\n return Array.from(categoryMap.values());\n}",[],[550,93],"menu","1df1fd1e-538e-11f1-b9b6-ee650bb23af1",["D",1779200527795],[252],[550],"1d971a98-538e-11f1-8553-ee650bb23af1","1d971b38-538e-11f1-8553-ee650bb23af1","1bb073c9-c1d6-4b02-a95d-9625e8dd06ad",34,["D",1779200527199],"import { db } from \"../db.ts\";\nimport { items } from \"./items.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(items).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[563,102],"items","10937102-538e-11f1-9e88-ee650bb23af1","items.table.ts","109371ca-538e-11f1-9e88-ee650bb23af1",5,["D",1779200505362],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const items = sqliteTable(\"items\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n category_id: integer(\"category_id\").notNull(),\n \n price: integer(\"price\").notNull(),\n \n description: text(\"description\"),\n \n image: text(\"image\"),\n \n status: text(\"status\").notNull(),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[563,565],"1d2adef0-538e-11f1-9b3d-ee650bb23af1","1d2adfae-538e-11f1-9b3d-ee650bb23af1",33,["D",1779200526484],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { items } from \"./items.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n if (q.q) filters.push(like((items as any).name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (items as any)[sortKey] ?? (items as any).id;\n\n const rows = await db.select().from(items).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(items).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[563,93],"1c9c3bb4-538e-11f1-bd07-ee650bb23af1","1c9c3c5e-538e-11f1-bd07-ee650bb23af1","07e348b5-f31a-42f7-95da-07706a805518",32,["D",1779200525555],"import { db, eq } from \"../../db.ts\";\nimport { items } from \"../items.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(items).set({ ...body, updated_at: now } as any).where(eq((items as any).id, id));\n return { success: true };\n}\n",[],[563,82,349],"1bef5d68-538e-11f1-8b8d-ee650bb23af1","1bef5e1c-538e-11f1-8b8d-ee650bb23af1",31,["D",1779200524426],"import { db, eq } from \"../../db.ts\";\nimport { items } from \"../items.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(items).where(eq((items as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[563,82,93],"1b8171f4-538e-11f1-94d4-ee650bb23af1","1b8172bc-538e-11f1-94d4-ee650bb23af1",30,["D",1779200523703],"import { db, eq } from \"../../db.ts\";\nimport { items } from \"../items.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(items).set({ deleted_at: now } as any).where(eq((items as any).id, id));\n return { success: true };\n}\n",[],[563,82,364],"1b817cc6-538e-11f1-94d4-ee650bb23af1",["D",1779200523703],[245,246,247],[563,82],"10938296-538e-11f1-9e88-ee650bb23af1",["D",1779200505362],[244,248,249,250],[563],"1b14edc2-538e-11f1-ae22-ee650bb23af1","1b14ee80-538e-11f1-ae22-ee650bb23af1","c37d6086-e8db-4152-a564-d5729ab5da3e",29,["D",1779200522993],"import { db } from \"../db.ts\";\nimport { itemToppings } from \"./item_toppings.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(itemToppings).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[617,102],"item_toppings","103b6430-538e-11f1-ae69-ee650bb23af1","item_toppings.table.ts","103b6502-538e-11f1-ae69-ee650bb23af1",4,["D",1779200504788],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const itemToppings = sqliteTable(\"item_toppings\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n item_id: integer(\"item_id\").notNull(),\n \n topping_id: integer(\"topping_id\").notNull(),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[617,619],"1ab223ae-538e-11f1-a5f7-ee650bb23af1","1ab22462-538e-11f1-a5f7-ee650bb23af1",28,["D",1779200522343],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { itemToppings } from \"./item_toppings.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (itemToppings as any)[sortKey] ?? (itemToppings as any).id;\n\n const rows = await db.select().from(itemToppings).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(itemToppings).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[617,93],"1a4c6a28-538e-11f1-8615-ee650bb23af1","1a4c6af0-538e-11f1-8615-ee650bb23af1","58b5504c-70cd-4ff7-9a24-4a9c58a42805",27,["D",1779200521675],"import { db, eq } from \"../../db.ts\";\nimport { itemToppings } from \"../item_toppings.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(itemToppings).set({ ...body, updated_at: now } as any).where(eq((itemToppings as any).id, id));\n return { success: true };\n}\n",[],[617,82,349],"19dd9756-538e-11f1-94d4-ee650bb23af1","19dd980a-538e-11f1-94d4-ee650bb23af1",26,["D",1779200520954],"import { db, eq } from \"../../db.ts\";\nimport { itemToppings } from \"../item_toppings.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(itemToppings).where(eq((itemToppings as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[617,82,93],"195b2f00-538e-11f1-bec8-ee650bb23af1","195b2ff0-538e-11f1-bec8-ee650bb23af1",25,["D",1779200520094],"import { db, eq } from \"../../db.ts\";\nimport { itemToppings } from \"../item_toppings.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(itemToppings).set({ deleted_at: now } as any).where(eq((itemToppings as any).id, id));\n return { success: true };\n}\n",[],[617,82,364],"195b393c-538e-11f1-bec8-ee650bb23af1",["D",1779200520094],[237,238,239],[617,82],"103b6e4e-538e-11f1-ae69-ee650bb23af1",["D",1779200504788],[236,240,241,242],[617],"189cdc62-538e-11f1-bec8-ee650bb23af1","189cdd48-538e-11f1-bec8-ee650bb23af1","f47ebe5e-c25f-4902-891b-dd6ffcd0e6e5",23,["D",1779200518842],"import { db } from \"../db.ts\";\nimport { customers } from \"./customers.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(customers).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[671,102],"customers","181ab0f2-538e-11f1-9713-ee650bb23af1","181ab1ba-538e-11f1-9713-ee650bb23af1",22,["D",1779200517999],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { customers } from \"./customers.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n if (q.q) filters.push(like((customers as any).name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (customers as any)[sortKey] ?? (customers as any).id;\n\n const rows = await db.select().from(customers).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(customers).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[671,93],"0f6f901c-538e-11f1-8d89-ee650bb23af1","customers.table.ts","0f6f90e4-538e-11f1-8d89-ee650bb23af1",2,["D",1779200503414],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const customers = sqliteTable(\"customers\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n phone: text(\"phone\"),\n \n notes: text(\"notes\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[671,680],"18fe4ae2-538e-11f1-bc1e-ee650bb23af1","18fe4c18-538e-11f1-bc1e-ee650bb23af1","91417747-a2fa-4e72-85f2-32398d913d8b",24,["D",1779200519482],"import { Context } from \"npm:hono@3\";\nimport { db, ilike, or } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\nimport { ilike, and, or, db } from \"../../db.ts\";\n\nexport default async function handler(c: Context) {\n const q = c.req.query(\"q\")?.trim();\n const name = c.req.query(\"name\")?.trim();\n const phone = c.req.query(\"phone\")?.trim();\n\n let conditions;\n\n if (q) {\n conditions = or(\n ilike(customers.name, `%${q}%`),\n ilike(customers.phone ? ilike(customers.phone, `%${q}%`) : undefined\n );\n } else if (name && phone) {\n conditions = and(\n ilike(customers.name, `%${name}%`),\n ilike(customers.phone, `%${phone}%`)\n );\n } else if (name) {\n conditions = ilike(customers.name, `%${name}%`);\n } else if (phone) {\n conditions = ilike(customers.phone, `%${phone}%`);\n } else {\n return { data: [] };\n }\n\n const rows = await db\n .select({\n id: customers.id,\n name:customers.name,\n phone: customers.phone,\n notes: customers.notes,\n created_at: customers.created_at,\n })\n .from(customers)\n .where(conditions)\n .limit(10);\n\n return { data: rows };\n}",[],[671,695,93],"search","18fe95d8-538e-11f1-bc1e-ee650bb23af1",["D",1779200519482],[231],[671,695],"179c584c-538e-11f1-b9b6-ee650bb23af1","179c58f6-538e-11f1-b9b6-ee650bb23af1","85f9738d-c34f-45ea-8aaf-5636fadc4131",21,["D",1779200517171],"import { db, eq } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(customers).set({ ...body, updated_at: now } as any).where(eq((customers as any).id, id));\n return { success: true };\n}\n",[],[671,82,349],"172f7632-538e-11f1-9713-ee650bb23af1","172f76d2-538e-11f1-9713-ee650bb23af1",20,["D",1779200516456],"import { db, eq } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(customers).where(eq((customers as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[671,82,93],"16c2a30e-538e-11f1-925e-ee650bb23af1","16c2a3ea-538e-11f1-925e-ee650bb23af1",19,["D",1779200515720],"import { db, eq } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(customers).set({ deleted_at: now } as any).where(eq((customers as any).id, id));\n return { success: true };\n}\n",[],[671,82,364],"16c2cbea-538e-11f1-925e-ee650bb23af1",["D",1779200515720],[227,228,229],[671,82],"0f6fb128-538e-11f1-8d89-ee650bb23af1",["D",1779200503414],[226,230,232,233,234],[671],"164a5d90-538e-11f1-8d7c-ee650bb23af1","164a5e30-538e-11f1-8d7c-ee650bb23af1","06e0bf5b-302d-4dbd-9e7c-29de34f276e2",18,["D",1779200514954],"import { db } from \"../db.ts\";\nimport { categories } from \"./categories.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(categories).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[738,102],"categories","15d4ada2-538e-11f1-ae5b-ee650bb23af1","15d4ae60-538e-11f1-ae5b-ee650bb23af1",17,["D",1779200514184],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { categories } from \"./categories.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n if (q.q) filters.push(like((categories as any).name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (categories as any)[sortKey] ?? (categories as any).id;\n\n const rows = await db.select().from(categories).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(categories).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[738,93],"0ec40d64-538e-11f1-ae69-ee650bb23af1","categories.table.ts","0ec40e68-538e-11f1-ae69-ee650bb23af1",["D",1779200502324],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const categories = sqliteTable(\"categories\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n sort_order: integer(\"sort_order\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[738,747],"1576de7a-538e-11f1-b9b6-ee650bb23af1","1576df60-538e-11f1-b9b6-ee650bb23af1","9c313511-1b61-4ab7-85f6-e8c93e657c16",16,["D",1779200513569],"import { db, eq } from \"../../db.ts\";\nimport { categories } from \"../categories.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(categories).set({ ...body, updated_at: now } as any).where(eq((categories as any).id, id));\n return { success: true };\n}\n",[],[738,82,349],"14eb6f52-538e-11f1-9b3d-ee650bb23af1","14eb7006-538e-11f1-9b3d-ee650bb23af1",15,["D",1779200512654],"import { db, eq } from \"../../db.ts\";\nimport { categories } from \"../categories.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(categories).where(eq((categories as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[738,82,93],"148f4a88-538e-11f1-9270-ee650bb23af1","148f4b5a-538e-11f1-9270-ee650bb23af1",14,["D",1779200512045],"import { db, eq } from \"../../db.ts\";\nimport { categories } from \"../categories.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(categories).set({ deleted_at: now } as any).where(eq((categories as any).id, id));\n return { success: true };\n}\n",[],[738,82,364],"148f77e2-538e-11f1-9270-ee650bb23af1",["D",1779200512045],[219,220,221],[738,82],"0ec43b2c-538e-11f1-ae69-ee650bb23af1",["D",1779200502324],[218,222,223,224],[738],"13b24156-538e-11f1-94d4-ee650bb23af1","13b2421e-538e-11f1-94d4-ee650bb23af1","10b06273-fc42-4a1d-8c0f-e1bde1640832",13,["D",1779200510600],"import { db, eq } from \"../../db.ts\";\nimport { users } from \"../../users/users.table.ts\";\nimport bcryptDefault from \"npm:bcryptjs@2.4.3\";\nconst bcrypt: { hash: (s: string, n: number) => Promise; compare: (s: string, h: string) => Promise } = (bcryptDefault as any).default ?? bcryptDefault;\nimport { sign } from \"npm:hono@3/jwt\";\n\nconst JWT_SECRET = (globalThis as any).Deno?.env?.get?.(\"JWT_SECRET\") ?? \"dev-secret-change-me\";\n\n// body: { email: string; password: string; name?: string }\n// returns: { token: string; user: { id: number; email: string } }\nexport default async function handler(c: any) {\n const body = await c.req.json() as { email: string; password: string; name?: string };\n if (!body.email || !body.password || body.password.length < 6) {\n c.status(400);\n return { error: \"invalid input\" };\n }\n const [exists] = await db.select().from(users).where(eq((users as any).email, body.email));\n if (exists) {\n c.status(409);\n return { error: \"email taken\" };\n }\n\n const hash = await bcrypt.hash(body.password, 10);\n const now = new Date().toISOString();\n const inserted = await db.insert(users).values({\n email: body.email,\n password_hash: hash,\n name: body.name ?? body.email.split(\"@\")[0],\n created_at: now,\n updated_at: now,\n } as any).returning();\n const user = inserted[0] as any;\n\n const token = await sign(\n { sub: user.id, email: user.email, exp: Math.floor(Date.now() / 1000) + 60 * 60 * 24 * 7 },\n JWT_SECRET,\n );\n\n return { token, user: { id: user.id, email: user.email } };\n}\n",[],[791,792,102],"auth","register","13b254ac-538e-11f1-94d4-ee650bb23af1","78641fc9-2541-4b88-b8f0-012b1a61d4f7",["D",1779200510600],[216],[791,792],"1346cbec-538e-11f1-94d4-ee650bb23af1","1346ccaa-538e-11f1-94d4-ee650bb23af1","bb54daca-bb9c-476d-804a-d5e4712f5e50",12,["D",1779200509889],"import { db, eq } from \"../../db.ts\";\nimport { users } from \"../../users/users.table.ts\";\nimport { verify } from \"npm:hono@3/jwt\";\n\nconst JWT_SECRET = (globalThis as any).Deno?.env?.get?.(\"JWT_SECRET\") ?? \"dev-secret-change-me\";\n\n// header: Authorization: Bearer \n// returns: { id: number; email: string }\nexport default async function handler(c: any) {\n const auth = c.req.header(\"authorization\") ?? \"\";\n const token = auth.replace(/^Bearer\\s+/i, \"\");\n if (!token) { c.status(401); return { error: \"missing token\" }; }\n\n try {\n const payload = await verify(token, JWT_SECRET) as { sub: number };\n const [user] = await db.select().from(users).where(eq((users as any).id, payload.sub));\n if (!user) { c.status(404); return { error: \"user not found\" }; }\n return { id: (user as any).id, email: (user as any).email };\n } catch {\n c.status(401);\n return { error: \"invalid token\" };\n }\n}\n",[],[791,806,93],"me","1346effa-538e-11f1-94d4-ee650bb23af1",["D",1779200509889],[214],[791,806],"12ea3684-538e-11f1-9240-ee650bb23af1","12ea376a-538e-11f1-9240-ee650bb23af1","beb37a34-1d9c-47f0-9142-2ae30d742d75",11,["D",1779200509288],"import { db, eq } from \"../../db.ts\";\nimport { users } from \"../../users/users.table.ts\";\nimport bcryptDefault from \"npm:bcryptjs@2.4.3\";\nconst bcrypt: { hash: (s: string, n: number) => Promise; compare: (s: string, h: string) => Promise } = (bcryptDefault as any).default ?? bcryptDefault;\nimport { sign } from \"npm:hono@3/jwt\";\n\nconst JWT_SECRET = (globalThis as any).Deno?.env?.get?.(\"JWT_SECRET\") ?? \"dev-secret-change-me\";\n\n// body: { email: string; password: string }\n// returns: { token: string; user: { id: number; email: string } }\nexport default async function handler(c: any) {\n const body = await c.req.json() as { email: string; password: string };\n const [user] = await db.select().from(users).where(eq((users as any).email, body.email));\n if (!user) {\n c.status(401);\n return { error: \"invalid credentials\" };\n }\n const ok = await bcrypt.compare(body.password, (user as any).password_hash);\n if (!ok) {\n c.status(401);\n return { error: \"invalid credentials\" };\n }\n\n const token = await sign(\n { sub: (user as any).id, email: (user as any).email, exp: Math.floor(Date.now() / 1000) + 60 * 60 * 24 * 7 },\n JWT_SECRET,\n );\n\n return { token, user: { id: (user as any).id, email: (user as any).email } };\n}\n",[],[791,819,102],"login","12ea6c6c-538e-11f1-9240-ee650bb23af1",["D",1779200509288],[212],[791,819],"12ea5d26-538e-11f1-9240-ee650bb23af1",["D",1779200509288],[211,213,215],[791],["D",1779200494411],{"_11":12,"_151":72},{"_11":12,"_147":-5,"_71":72,"_31":70,"_148":149,"_150":30},{"_42":138,"_13":16,"_36":39,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":14,"_146":12},"ctx",{"_55":-5,"_170":865,"_866":867,"_868":869,"_870":30,"_871":30,"_872":30,"_873":24,"_874":-5,"_875":-7,"_876":-7,"_877":26,"_878":30,"_879":30,"_880":-5,"_881":30,"_882":30,"_883":30,"_884":-5},"ENV",{"_836":837,"_838":839,"_840":16,"_841":842,"_843":844,"_845":846,"_847":848,"_849":850,"_851":852,"_853":854,"_855":856,"_857":858,"_859":860,"_861":862,"_863":864},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · toppings