public function getDetailData($id, $postData, $properties) { $pdShipPortInformation = PdShipPortInformation::getTableName(); $pdTransportShipDetail = PdTransportShipDetail::getTableName(); $dataSet = PdShipPortInformation::join($pdTransportShipDetail, function ($query) use($id, $pdShipPortInformation, $pdTransportShipDetail) { $query->on("{$pdShipPortInformation}.VOYAGE_ID", '=', "{$pdTransportShipDetail}.VOYAGE_ID"); $query->on("{$pdShipPortInformation}.PARCEL_NO", '=', "{$pdTransportShipDetail}.PARCEL_NO"); $query->where("{$pdTransportShipDetail}.ID", '=', $id); })->select("{$pdShipPortInformation}.*", "{$pdShipPortInformation}.ID as DT_RowId", "{$pdShipPortInformation}.ID as {$pdShipPortInformation}")->get(); return $dataSet; }