import Foundation
import CoreFoundation
import TeaQLCore
import TeaQLSQLite
import GeneratedTeaQL

enum Denied:Error{case code(String)}
let seedReason="Seed isolated tenant Order fixture",noteReason="Edit own tenant and buyer Order note",itemReason="Edit own tenant and buyer Order item label"
let trusted:[String:[String]]=["a":["ACTOR-A","TENANT-A","BUYER-A"],"b":["ACTOR-B","TENANT-A","BUYER-B"],"c":["ACTOR-C","TENANT-B","BUYER-A"],"d":["ACTOR-D","TENANT-B","BUYER-B"],"readonly":["ACTOR-READ","TENANT-A","BUYER-A"]]
func required<T>(_ v:T?) throws->T{guard let v else{throw Denied.code("MISSING_LOADED_VALUE")};return v}
func integer(_ v:Any?)->Int64?{guard let n=v as? NSNumber,CFGetTypeID(n) != CFBooleanGetTypeID(),n.doubleValue.isFinite,n.doubleValue.rounded(.towardZero)==n.doubleValue else{return nil};return n.int64Value}
func validate(_ token:String,_ r:[String:Any])throws->Int{
 guard trusted[token] != nil else{throw Denied.code("UNAUTHENTICATED")}
 if ["tenant","buyer","actor","permissions","policy","userContext"].contains(where:{r[$0] != nil}){throw Denied.code("FORGED_SCOPE")}
 let op=r["op"] as? String ?? ""
 guard ["list","detail","items","summary","retained","edit-note","edit-item"].contains(op),Set(r.keys).isSubset(of:Set(["op","orderId","orderNumber","itemId","limit","patch"])) else{throw Denied.code("INVALID_REQUEST")}
 let value=r["limit"] == nil ? Int64(2):integer(r["limit"]);guard let limit=value,(1...2).contains(limit) else{throw Denied.code("INVALID_BOUNDS")}
 for key in ["orderId","itemId"]{if let v=r[key],integer(v)==nil || integer(v)!<=0{throw Denied.code("INVALID_REQUEST")}}
 if ["detail","items","edit-note","edit-item"].contains(op),r["orderId"]==nil,r["orderNumber"] as? String==nil{throw Denied.code("INVALID_REQUEST")}
 if ["items","edit-item"].contains(op),r["itemId"]==nil{throw Denied.code("INVALID_REQUEST")}
 if op.hasPrefix("edit-"){
  if token=="readonly"{throw Denied.code("FORBIDDEN_OPERATION")};let field=op=="edit-note" ? "orderNote":"productName"
  guard let patch=r["patch"] as? [String:Any],Set(patch.keys)==Set([field]),let text=patch[field] as? String,(1...80).contains(text.count) else{throw Denied.code("FORBIDDEN_FIELD")}
 }else if r["patch"] != nil{throw Denied.code("FORBIDDEN_FIELD")};return Int(limit)
}
func row(_ o:CustomerOrder,_ children:Bool=true)throws->[String:Any]{let e=E.customerOrder(o);var result:[String:Any]=["id":try required(e.id().eval()),"buyer":try required(e.buyerReference().eval()),"orderNumber":try required(e.orderNumber().eval()),"note":try e.orderNote().eval() as Any? ?? NSNull(),"totalMinor":try required(e.totalMinor().eval()),"version":try required(e.version().eval())];if children{result["items"]=try o.orderItemList.map{i in ["id":try required(E.orderItem(i).id().eval()),"sku":try required(E.orderItem(i).skuCode().eval()),"productName":try required(E.orderItem(i).productName().eval()),"version":try required(E.orderItem(i).version().eval())] as [String:Any]}};return result}

func number(_ row:TeaQLRecord,_ key:String)throws->Double{NSDecimalNumber(decimal:try required(row[key]?.decimalValue)).doubleValue}
func handle(_ context:UserContext,_ token:String,_ r:[String:Any])async throws->[String:Any]{do{
 let limit=try validate(token,r),s=trusted[token]!,actor=s[0],tenant=s[1],buyer=s[2],op=r["op"] as! String
 let roots=try await Q.commercePlatforms().withTenantKeyIs(tenant).limit(2).comment("Resolve tenant from trusted server session").purpose("Bind the authorized Order scope").executeForList(context)
 guard roots.count==1 else{throw Denied.code("INVALID_TRUSTED_SCOPE")};let root=try required(E.commercePlatform(roots[0]).id().eval())
 if op=="summary"{
  let values=try await Q.customerOrders().filterByCommercePlatform(root).withBuyerReferenceIs(buyer).countAs("count").sumTotalMinorAs("amount").limit(1).comment("Summarize only authorized Orders").purpose("Enforce tenant and buyer scope on aggregates").executeForRows(context)
  return ["code":"OK","actor":actor,"tenant":tenant,"buyer":buyer,"count":try number(values[0],"count"),"amount":try number(values[0],"amount")]
 }
 var q=Q.customerOrders().filterByCommercePlatform(root).withBuyerReferenceIs(buyer).orderByIdAscending()
 if op != "retained"{q=q.selectOrderItemListWith(Q.orderItems().orderByIdAscending().limit(3))}
 if let id=integer(r["orderId"]){q=q.withIdIs(id)};if let value=r["orderNumber"] as? String{q=q.withOrderNumberIs(value)}
 if op=="retained"{q=q.optimizePaginationWithIdSet(namespace:"order-isolation-shared",ttlSeconds:300,maxIds:20)}
 let fetched=try await q.limit(limit).comment("Load authorized Orders and bounded owned items").purpose("Apply trusted tenant and buyer predicates before provider access").executeForPage(context,offset:0,limit:limit)
 let page=fetched.items
 if ["list","retained"].contains(op){var result:[String:Any]=["code":"OK","actor":actor,"tenant":tenant,"buyer":buyer,"rows":try page.map{try row($0,op != "retained")},"total":try required(page.totalCount)];if op=="retained"{result["plan"]=await context.idSetPaginationObservation().plan};return result}
 guard page.count==1 else{throw Denied.code("NOT_FOUND")};var order=page[0];let items=order.orderItemList;guard items.count<=2 else{throw Denied.code("ITEM_LIMIT")}
 var item=try items.first{try E.orderItem($0).id().eval()==integer(r["itemId"])}
 if ["items","edit-item"].contains(op),item==nil{throw Denied.code("NOT_FOUND")}
 if op=="edit-note"{order.updateOrderNote((r["patch"] as! [String:Any])["orderNote"] as? String);_ = try await order.auditAs(noteReason).save(context);return ["code":"OK","changed":true]}
 if op=="edit-item"{item!.updateProductName((r["patch"] as! [String:Any])["productName"] as? String);_ = try await item!.auditAs(itemReason).save(context);return ["code":"OK","changed":true]}
 var value=try row(order);if op=="items"{value["items"]=(value["items"] as! [[String:Any]]).filter{integer($0["id"])==integer(r["itemId"])}};return ["code":"OK","actor":actor,"tenant":tenant,"buyer":buyer,"rows":[value],"total":try required(page.totalCount)]
 }catch Denied.code(let code){return ["code":code]}}
func seed(_ context:UserContext)async throws{
 let roots=try await Q.commercePlatforms().limit(2).comment("Read initialized tenant root").purpose("Seed isolated Order fixture").executeForList(context);guard roots.count==1 else{throw Denied.code("INVALID_ROOT")}
 for (n,tenant) in ["TENANT-A","TENANT-B"].enumerated(){
  var root=n==0 ? roots[0]:try Q.commercePlatforms().comment("Create tenant root").purpose("Seed isolated Order fixture").newEntity(context)
  root.updateName("Tenant "+String(tenant.suffix(1)));root.updateTenantKey(tenant);_ = try await root.auditAs(seedReason).save(context)
  let stored=try await Q.commercePlatforms().withTenantKeyIs(tenant).limit(2).comment("Reload saved tenant identity").purpose("Seed isolated Order fixture").executeForList(context);guard stored.count==1 else{throw Denied.code("INVALID_ROOT")};let rootId=try required(E.commercePlatform(stored[0]).id().eval())
  for buyer in ["BUYER-A","BUYER-B"]{for orderNumber in ["ORD-SHARED-001","ORD-SHARED-002"]{
   var o=try Q.customerOrders().comment("Create tenant-owned Order").purpose("Seed isolated Order fixture").newEntity(context);o.updateCommercePlatform(rootId);o.updateOrderStatusToDraft();o.updateOrderNumber(orderNumber);o.updateBuyerReference(buyer);o.updateCurrencyCode("USD");o.updateTotalMinor(3850);o.updateOrderNote("Original "+tenant+" "+buyer);_ = try await o.auditAs(seedReason).save(context)
   let saved=try await Q.customerOrders().filterByCommercePlatform(rootId).withBuyerReferenceIs(buyer).withOrderNumberIs(orderNumber).limit(2).comment("Reload saved Order identity").purpose("Seed isolated Order fixture").executeForList(context);guard saved.count==1 else{throw Denied.code("INVALID_ORDER")};let id=try required(E.customerOrder(saved[0]).id().eval())
   for k in 0..<2{var i=try Q.orderItems().comment("Create owned Order line").purpose("Seed isolated Order fixture").newEntity(context);i.updateCustomerOrder(id);let sku=k==0 ? "SKU-NOTEBOOK":"SKU-PEN";i.updateSkuCode(sku);i.updateProductName(sku);i.updateQuantity(k==0 ? 2:3);i.updateUnitPriceMinor(k==0 ? 1250:450);i.updateLineTotalMinor(k==0 ? 2500:1350);_ = try await i.auditAs(seedReason).save(context)}
  }}
 }
}
func report(_ value:[String:Any])throws{print("ORDER_ISOLATION_RESULT "+String(decoding:try JSONSerialization.data(withJSONObject:value,options:[.sortedKeys]),as:UTF8.self))}
let phase=try required(CommandLine.arguments.dropFirst().first),env=ProcessInfo.processInfo.environment
let provider=try SQLiteDataService(path:required(env["ORDER_DATABASE"]));var runtime=TeaQLRuntime();try runtime.install(GeneratedRuntimeModule.module)
let context=UserContext(runtime:runtime,actor:"isolation-server",trustedTenant:"server-scope",queryExecutor:provider,mutationExecutor:provider,requestPolicy:RequestPolicy{$0},idSetStore:InMemoryIdSetStore())
if ["bootstrap","seed"].contains(phase){try await context.ensureSchema(GeneratedRuntimeModule.module)}
if phase=="seed"{try await seed(context)}
else if phase=="request"{let r=try JSONSerialization.jsonObject(with:Data(contentsOf:URL(fileURLWithPath:required(env["ORDER_REQUEST"])))) as! [String:Any];print("ORDER_ISOLATION_BEGIN");try report(await handle(context,env["ORDER_SESSION"] ?? "",r))}
else if phase=="cache"{print("ORDER_ISOLATION_BEGIN");var pages:[[String:Any]]=[];for token in ["a","b","c","a"]{pages.append(try await handle(context,token,["op":"retained","limit":1]))};try report(["pages":pages])}
else if phase != "bootstrap"{throw Denied.code("INVALID_PHASE")};print("ORDER_OK phase="+phase)
