Skip to content

GET /yms/equipment-loads/(?P\d+)/container-detail

YMS > yms.container-tracking

What it does

#^/yms/equipment-loads/(?P<id>\d+)/container-detail$# accepts GET and is declared in app/systems/YMS/container-tracking/api_routes.php:1936 as a regex pattern.

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

Who calls it

No literal caller path was found in frontend/, public/ or new-system/. The endpoint may be called through a constructed path, a helper wrapper, or only by an external client. Treat the route table and owner function as the authority.

Input

Where Key
path id

Request bodies must not use TYPE, ACTION or USERNAME as contract fields.

Output

Key
T_EQUIPMENT
T_EQUIPMENT_COMMODITY
T_EQUIPMENT_LOAD
T_OUTBOUND_ORDER
T_OUTBOUND_ORDER_ITEM
T_TRANSLOAD

Success is { "data": …, "requestId": "…" }. Failure is { "error": { "code", "message" }, "requestId": "…" }.

SQL executed

SELECT EQ.*, RB.BOOKING_NUMBER AS RETURN_BOOKING_NUMBER, BC.DISPLAY_NAME AS RETURN_BILLING_COMPANY_NAME, C.DISPLAY_NAME AS LAST_LOCATION_NAME FROM T_EQUIPMENT AS EQ LEFT JOIN T_COMPANY AS C ON C.ID=LAST_LOCATION_ID AND C.CLIENT_ID = EQ.CLIENT_ID AND C.DELETED_AT IS NULL LEFT JOIN T_BOOKING AS RB ON RB.ID = EQ.RETURN_BOOKING_ID AND RB.CLIENT_ID = EQ.CLIENT_ID AND RB.DELETED_AT IS NULL LEFT JOIN T_COMPANY AS BC ON BC.ID = RB.BILLING_COMPANY_ID AND BC.CLIENT_ID = RB.CLIENT_ID AND BC.DELETED_AT IS NULL WHERE EQ.CLIENT_ID = ? AND EQ.ID=? AND EQ.DELETED_AT IS NULL LIMIT 1

SELECT ID, COMMODITY_NAME, COMMODITY_QUANTITY, COMMODITY_WEIGHT FROM T_EQUIPMENT_COMMODITY WHERE CLIENT_ID = ? AND EQUIPMENT_LOAD_ID=? AND DELETED_AT IS NULL

SELECT TRANSLOADED_DATE FROM T_TRANSLOAD WHERE CLIENT_ID = ? AND FINAL_EQUIPMENT_LOAD_ID = ? AND LOAD_TYPE <> 'PICKUP' AND DELETED_AT IS NULL LIMIT 1

SELECT O.ID, O.ORDER_NUMBER,

Data

Tables reached from the owner function:

  • T_BOOKING
  • T_COMPANY
  • T_EQUIPMENT
  • T_EQUIPMENT_COMMODITY
  • T_EQUIPMENT_LOAD
  • T_LOAD
  • T_LOAD_ITEM
  • T_TRANSLOAD

Access

  • module-gated on yms.container-tracking, so tenant module access applies