import { string } from 'alga-js'
import refreshTokenHelper from "../../utils/refreshTokenHelper"
import getTokenHelper from "../../utils/getTokenHelper"
import forceLogoutHelper from "../../utils/forceLogoutHelper"
import errorHandlingHelper from "../../utils/errorHandlingHelper"
import fetchHelper from "../../utils/fetchHelper"

// Union of the fields mapped by the consumer (procurements/returns) — never the
// blob columns (DHL_Label_Base64, DPD_Label_Base64, trackingnoarray,
// marketplace_confirm_log); unbounded full-column m_inout list queries
// OOM-crashed the ERP on 2026-07-07.
const SELECT = 'DocumentNo,Description,DocStatus,MovementType,MovementDate,DateAcct,DateOrdered,Created,ProcessedOn,Processed,IsActive,IsApproved,IsSOTrx,IsPrinted,IsInTransit,IsInDispute,IsDropShip,IsAlternateReturnAddress,SendEMail,POReference,FreightAmt,ChargeAmt,NoPackages,Volume,Weight,DeliveryRule,FreightCostRule,DeliveryViaRule,PriorityRule,M_RMA_ID,C_DocType_ID,C_BPartner_ID,C_BPartner_Location_ID,C_Order_ID,AD_User_ID,AD_Org_ID,M_Warehouse_ID,SalesRep_ID,C_Project_ID,C_Campaign_ID'

const handleFunc = async (event: any, authToken: any = null) => {
  let data: any = {}
  const token = authToken ?? await getTokenHelper(event)

  // Safety cap against unbounded growth; the grid expects the full list.
  const res: any = await fetchHelper(event, `models/m_inout?$filter=${string.urlEncode("startswith(MovementType,'V-') AND (isActive eq true OR isActive eq false)")}&$select=${SELECT}&$orderby=${string.urlEncode('M_InOut_ID desc')}&$top=2000`, 'GET', token, null)
  if(res) {
    data = res
  }

  return data
}

export default defineEventHandler(async (event) => {
  let data: any = {}

  try {
    data = await handleFunc(event)
  } catch(err: any) {
    try {
      let authToken: any = await refreshTokenHelper(event)
      data = await handleFunc(event, authToken)
    } catch(error: any) {
      data = errorHandlingHelper(err?.data ?? err, error?.data ?? error)
      forceLogoutHelper(event, data)
    }
  }

  return data
})