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 (sales/shipments) — never the blob
// columns (DHL_Label_Base64, DPD_Label_Base64, trackingnoarray,
// marketplace_confirm_log); full-column m_inout list queries carried the whole
// label archive and contributed to the 2026-07-07 ERP OOM incident.
const SELECT = 'DocumentNo,Description,DocStatus,MovementType,DateAcct,DateOrdered,Created,ProcessedOn,Processed,IsActive,IsApproved,IsSOTrx,IsPrinted,IsInTransit,IsInDispute,IsDropShip,IsAlternateReturnAddress,IsCommissioned,SendEMail,POReference,TrackingNo,FreightAmt,ChargeAmt,NoPackages,Volume,Weight,DeliveryRule,FreightCostRule,DeliveryViaRule,PriorityRule,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)
  const query = getQuery(event)

  const limit = Math.min(Math.max(Number(query?.limit) || 100, 1), 200)
  const offset = Math.max(Number(query?.offset) || 0, 0)

  const res: any = await fetchHelper(event, `models/m_inout?$filter=${string.urlEncode("startswith(MovementType,'C-') AND (isActive eq true OR isActive eq false)")}&$select=${SELECT}&$orderby=${string.urlEncode('M_InOut_ID desc')}&$top=${limit}&$skip=${offset}`, '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
})