/** * Count InventoryLocations * by InventoryModelId Index(es) * @param integer $intInventoryModelId * @return int */ public static function CountByInventoryModelIdLocations($intInventoryModelId) { // Call to ArrayQueryHelper to Get Database Object and Get SQL Clauses InventoryLocation::QueryHelper($objDatabase); // Properly Escape All Input Parameters using Database->SqlVariable() $intInventoryModelId = $objDatabase->SqlVariable($intInventoryModelId, true); // Setup the SQL Query $strQuery = sprintf(' SELECT COUNT(*) AS row_count FROM `inventory_location` WHERE `inventory_model_id` %s AND `inventory_location`.`location_id` > 5', $intInventoryModelId); // Perform the Query and Return the Count $objDbResult = $objDatabase->Query($strQuery); $strDbRow = $objDbResult->FetchRow(); return QType::Cast($strDbRow[0], QType::Integer); }