[{"_1":2,"_172":-5,"_173":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","73d011c55f6ff6e543547a2f801bf2081197a5a4","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_169":170,"_171":-5},"handle","prashamtrivedi","name","stockApp","path","backend/services/inventoryService.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":72,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","04ed788e-326f-11f0-81a2-569c3dd06744","createdAt",["D",1747411285389],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","1591349e-125d-4fb7-930d-cf293627961f","pinnedFileId","pinPreview","screenshotVersion","likeCount","4d7791fe-1f5b-4867-8b6e-34823c16ee48","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaUF5OXE3VlcwNVRwRU9wSTRmcE1DZ0FSM1UifQ","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",114,"04edc32a-326f-11f0-81a2-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"99f546a4-327f-11f0-af1d-569c3dd06744","inventoryService.ts","fileId","99f5476c-327f-11f0-af1d-569c3dd06744","parentId","995101fc-327f-11f0-8bd6-569c3dd06744","branchId","branchVersion",16,"latest",true,["D",1747418407365],"fileType","script","content","import {\n InventoryBatch,\n CreateInventoryBatchPayload,\n Product,\n} from \"../../shared/types.ts\";\nimport * as db from \"../database/queries.ts\";\nimport { logUserAction } from \"./userService.ts\";\nimport { getProductById } from \"./productService.ts\"; // To validate product existence\n\nexport async function createInventoryBatch(\n payload: CreateInventoryBatchPayload,\n userId: string,\n): Promise {\n // Validate product ID\n const product: Product | null = await getProductById(payload.productId);\n if (!product) {\n throw new Error(`Product with ID \"${payload.productId}\" not found. Cannot create inventory batch.`);\n }\n\n // Ensure quantityCurrent is set, defaults to quantityReceived if not provided\n const batchToCreate: CreateInventoryBatchPayload = {\n ...payload,\n quantityCurrent: payload.quantityCurrent ?? payload.quantityReceived,\n };\n\n const batch = await db.createInventoryBatch(batchToCreate, userId);\n await logUserAction(userId, \"add_inventory\", {\n batchId: batch.id,\n productId: batch.productId,\n productName: product.name, // For better log readability\n quantityReceived: batch.quantityReceived,\n expiryDate: batch.expiryDate,\n });\n return batch;\n}\n\nexport async function getInventoryBatchById(id: string): Promise {\n return db.getInventoryBatchById(id);\n}\n\nexport async function getBatchesForProduct(productId: string): Promise {\n return db.getBatchesForProduct(productId);\n}\n\nexport async function updateInventoryBatch(\n batchId: string,\n updates: Partial>,\n userId: string,\n): Promise {\n const existingBatch = await db.getInventoryBatchById(batchId);\n if (!existingBatch) {\n throw new Error(`Inventory batch with ID \"${batchId}\" not found.`);\n }\n\n // Construct the update object carefully, only allowing certain fields to be updated.\n // For example, productId, createdBy, createdAt should generally not be changed.\n // quantityReceived might also be immutable after creation.\n \n const validUpdates: Partial = {};\n if (updates.quantityCurrent !== undefined) validUpdates.quantityCurrent = updates.quantityCurrent;\n if (updates.receiptDate) validUpdates.receiptDate = updates.receiptDate;\n if (updates.expiryDate) validUpdates.expiryDate = updates.expiryDate;\n if (updates.costPrice !== undefined) validUpdates.costPrice = updates.costPrice;\n if (updates.notes !== undefined) validUpdates.notes = updates.notes;\n // isInitialInventory is typically set at creation and not updated.\n // supplierBillId might be set once if not set at creation.\n\n if (Object.keys(validUpdates).length === 0) {\n return existingBatch; // No valid fields to update\n }\n \n // The db.updateInventoryBatch function needs to be implemented in queries.ts\n // For now, assuming it takes (batchId, updates, userId)\n // This is a simplified update; a real one might involve more complex logic or a dedicated query.\n // Let's assume we have a generic update in queries.ts or we update specific fields.\n // For this demo, let's focus on quantityCurrent as the primary updatable field.\n\n let updatedBatch: InventoryBatch | null = null;\n if (updates.quantityCurrent !== undefined) {\n updatedBatch = await db.updateInventoryBatchQuantity(batchId, updates.quantityCurrent, userId);\n } else {\n // If other fields were to be updated, we'd need a more generic update query\n // For now, if only quantityCurrent is supported for direct update via a specific query:\n console.warn(\"Only quantityCurrent update is directly supported by updateInventoryBatchQuantity. Other updates ignored for now.\");\n updatedBatch = existingBatch; // Return existing if no quantity update\n }\n\n\n if (updatedBatch) {\n await logUserAction(userId, \"update_inventory\", { batchId: updatedBatch.id, changes: validUpdates });\n }\n return updatedBatch;\n}\n\n\nexport async function getExpiringBatches(days?: number): Promise {\n return db.getExpiringBatches(days);\n}\n\nexport async function getTotalProductQuantity(productId: string): Promise {\n const result = await db.getTotalProductQuantity(productId);\n return result.totalQuantity;\n}\n\n// Placeholder for inventory reconciliation logic\nexport async function reconcileInventory(\n productId: string,\n actualPhysicalCount: number,\n userId: string,\n): Promise<{ discrepancies: number; updatedBatches: InventoryBatch[] }> {\n // This is a complex operation:\n // 1. Get all current batches for the product, ordered by expiry (FIFO/FEFO).\n // 2. Compare total system quantity with actualPhysicalCount.\n // 3. Adjust batch quantities. If actual < system, reduce from oldest/nearest expiry.\n // If actual > system, it might mean unrecorded stock (needs investigation or a new \"found\" batch).\n // 4. Log changes.\n console.warn(\n `Reconciliation for product ${productId} with count ${actualPhysicalCount} by user ${userId} - NOT IMPLEMENTED`,\n );\n // For demo, return no change\n const currentBatches = await db.getBatchesForProduct(productId);\n const systemTotal = currentBatches.reduce((sum, batch) => sum + batch.quantityCurrent, 0);\n return { discrepancies: actualPhysicalCount - systemTotal, updatedBatches: [] };\n}","deleted","label",[167,168,149],"backend","services","permalink","https://www.val.town/x/prashamtrivedi/stockApp/code/backend/services/inventoryService.ts","extension","actionData","errors"]