Skip to content

GET /tms/daily-dip-drafts

TMS > tms.transload

What it does

/tms/daily-dip-drafts accepts GET and is declared in app/systems/TMS/transload/api_routes.php:97 as a path.

The route handler delegates to dailyDipDraftRead(). That function is the owner of this behaviour; the route entry is only dispatch.

Who calls it

Called from:

  • frontend/pages/system/TMS/transload/inbound-planning.php

A caller is the strongest available evidence of the intended use.

Input

No named input key is visible in the handler or its owner function. The endpoint either takes no parameters or reads them through a shared helper in app/shared/api/.

Output

The response is produced by a shared helper, so the key set is not visible at the route. Read the owner function to confirm the shape before writing a client.

SQL executed

SELECT ITEM_KIND, SORT_ORDER, DOCK_NUMBER, WORK_TYPE, BILLING_COMPANY_ID, BOOKING_ID, TRANSLOAD_ID, COMMODITY_NAME, TARGET_QTY, TARGET_QTY_MODE, INSTRUCTION, HISTORICAL_PREVIEW, RECOMMENDED_TRANSLOAD_ID, RECOMMENDED_LOCATION, RECOMMENDATION_OVERRIDDEN FROM T_DAILY_DIP_ITEM WHERE CLIENT_ID=? AND DAILY_DIP_DRAFT_ID=? ORDER BY ITEM_KIND, SORT_ORDER, ID

SELECT ID, PLANNING_DATE, STATUS, NOTES, REVISION, CREATED_AT, UPDATED_AT, CREATED_BY_USER_ID, CREATED_BY_USERNAME, UPDATED_BY_USER_ID, UPDATED_BY_USERNAME FROM T_DAILY_DIP_DRAFT WHERE CLIENT_ID=? AND PLANNING_DATE=? LIMIT 1

Data

Tables reached from the owner function:

  • T_DAILY_DIP_DRAFT
  • T_DAILY_DIP_ITEM

Access

  • module-gated on tms.transload, so tenant module access applies