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

const handleFunc = async (event: any, authToken: any = null) => {
  let data: any = {}
  const config = useRuntimeConfig()
  const token = authToken ?? await getTokenHelper(event)
  const organizationId = getCookie(event, 'organizationId')
  const query = getQuery(event)

  let limit: number = query?.limit ?? 100
  let offset: number = query?.offset ?? 0

  let filterParts: string[] = ['isSOTrx eq false']

  // DocStatus filter: accepts comma-separated status codes (e.g. "CO,CL")
  const docStatus: string = (query?.docStatus as string) || ''
  if (docStatus) {
    const statuses = docStatus.split(',').map((s: string) => s.trim()).filter(Boolean)
    if (statuses.length === 1) {
      filterParts.push(`DocStatus eq '${statuses[0]}'`)
    } else if (statuses.length > 1) {
      const statusFilter = statuses.map((s: string) => `DocStatus eq '${s}'`).join(' OR ')
      filterParts.push(`(${statusFilter})`)
    }
  }

  const filterString = filterParts.join(' AND ')

  const res: any = await event.context.fetch(`models/c_order?$filter=${string.urlEncode(filterString)}&$expand=c_orderline&$orderby=${string.urlEncode('c_order_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) {
      data = errorHandlingHelper(err?.data ?? err, error?.data ?? error)
      forceLogoutHelper(event, data)
    }
  }

  return data
})