Example #1
0
 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;
 }