Example #1
0
 /**
  * Load an array of Item objects by ShipmentId
  *
  * @param string $intShipmentId
  * @return Array
  */
 public static function LoadArrayByShipmentId($intShipmentId, $strOrderBy = null, $strLimit = null, $objExpansionMap = null)
 {
     Item::ArrayQueryHelper($strOrderBy, $strLimit, $strLimitPrefix, $strLimitSuffix, $objDatabase);
     $objShipment = Shipment::Load($intShipmentId);
     $strQuery = sprintf("\r\n\t\t\t\tSELECT \r\n\t\t\t\t\tasset_model.short_description AS short_description,\r\n\t\t\t\t\tasset.asset_code AS code,\r\n\t\t\t\t\t'1' AS quantity,\r\n\t\t\t\t\t(\r\n\t\t\t\t\tSELECT \r\n\t\t\t\t\t\treceipt.receipt_number \r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t\treceipt,\r\n\t\t\t\t\t\ttransaction,\r\n\t\t\t\t\t\tasset_transaction at\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\treceipt.transaction_id = transaction.transaction_id\r\n\t\t\t\t\tAND\r\n\t\t\t\t\t\tat.transaction_id = transaction.transaction_id\r\n\t\t\t\t\tAND\r\n\t\t\t\t\t\tat.parent_asset_transaction_id = asset_transaction.asset_transaction_id\t\t\t\t\t\r\n\t\t\t\t\t) AS receipt_number\r\n\t\t\t\tFROM \r\n\t\t\t\t\tasset_transaction \r\n\t\t\t\t\tLEFT JOIN asset ON asset_transaction.asset_id = asset.asset_id\r\n\t\t\t\t\tLEFT JOIN asset_model ON asset.asset_model_id = asset_model.asset_model_id\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tasset_transaction.transaction_id = %s\r\n\t\t\t\tUNION\r\n\t\t\t\tSELECT \r\n\t\t\t\t\tinventory_model.short_description AS short_description, \r\n\t\t\t\t\tinventory_model.inventory_model_code AS code, \r\n\t\t\t\t\tinventory_transaction.quantity AS quantity,\r\n\t\t\t\t\t'' AS receipt_number\r\n\t\t\t\tFROM \r\n\t\t\t\t\tinventory_transaction\r\n\t\t\t\t\tLEFT JOIN inventory_location ON inventory_transaction.inventory_location_id = inventory_location.inventory_location_id\r\n\t\t\t\t\tLEFT JOIN inventory_model ON inventory_location.inventory_model_id = inventory_model.inventory_model_id\r\n\t\t\t\tWHERE \r\n\t\t\t\t\tinventory_transaction.transaction_id = %s\r\n\t\t\t", $objShipment->TransactionId, $objShipment->TransactionId);
     $objDbResult = $objDatabase->Query($strQuery);
     return Item::InstantiateDbResult($objDbResult);
 }