/** * Load all TransactionTypes * @param string $strOrderBy * @param string $strLimit * @param array $objExpansionMap map of referenced columns to be immediately expanded via early-binding * @return TransactionType[] */ public static function LoadArrayByAssetFlag($blnAssetFlag, $strOrderBy = null, $strLimit = null, $objExpansionMap = null) { // Call to ArrayQueryHelper to Get Database Object and Get SQL Clauses TransactionType::ArrayQueryHelper($strOrderBy, $strLimit, $strLimitPrefix, $strLimitSuffix, $strExpandSelect, $strExpandFrom, $objExpansionMap, $objDatabase); $blnAssetFlag = $objDatabase->SqlVariable($blnAssetFlag, true); // Setup the SQL Query $strQuery = sprintf(' SELECT %s `transaction_type`.`transaction_type_id` AS `transaction_type_id`, `transaction_type`.`short_description` AS `short_description`, `transaction_type`.`asset_flag` AS `asset_flag`, `transaction_type`.`inventory_flag` AS `inventory_flag` %s FROM `transaction_type` AS `transaction_type` %s WHERE `asset_flag` %s %s %s', $strLimitPrefix, $strExpandSelect, $strExpandFrom, $blnAssetFlag, $strOrderBy, $strLimitSuffix); // Perform the Query and Instantiate the Result $objDbResult = $objDatabase->Query($strQuery); return TransactionType::InstantiateDbResult($objDbResult); }