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, 'logship_organization_id')
  const query = getQuery(event)

  let limit: number = query?.limit ?? 100
  let offset: number = query?.offset ?? 0
  let filter: string = query?.filter ?? ''
  let openOnly: string = query?.openOnly ?? ''
  let nameFilter: string = query?.name ?? ''
  let trackingNoFilter: string = query?.trackingNo ?? ''

  let filterString = string.urlEncode('isSOTrx eq true AND (isActive eq true OR isActive eq false)')
  if(filter) {
    filterString += string.urlEncode(' AND ') + string.urlEncode(filter)
  }

  // Add name filter (searches in C_BPartner_Location_ID/Name)
  if(nameFilter) {
    filterString += string.urlEncode(' AND ') + string.urlEncode(`contains(C_BPartner_Location_ID/Name,'${nameFilter}')`)
  }

  // Add tracking number filter (searches in m_inout/TrackingNo)
  if(trackingNoFilter) {
    filterString += string.urlEncode(' AND ') + string.urlEncode(`m_inout/any(m:contains(m/TrackingNo,'${trackingNoFilter}'))`)
  }

  // If openOnly is true, use the C_Order_NotFulfilled view
  const model = openOnly === 'true' ? 'views/C_Order_NotFulfilled' : 'models/c_order'

  const res: any = await event.context.fetch(`${model}?$filter=${filterString}&$expand=c_ordersource_id,c_bpartner_location_id,bill_location_id,c_orderline,m_inout($expand=M_Shipper_ID),M_Shipper_ID&$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) {
      //@ts-ignore
      data = errorHandlingHelper(err?.data ?? err, error?.data ?? error)
      forceLogoutHelper(event, data)
    }
  }

  return data
})