/**
* Count all Categories with their associated flags
* @param bool $blnAssetFlag
* @param bool $blnInventoryFlag
* @return int
*/
public static function CountAllWithFlags($blnAssetFlag = true, $blnInventoryFlag = true)
{
// Call to QueryHelper to Get the Database Object
Category::QueryHelper($objDatabase);
if ($blnAssetFlag) {
$sqlAssetWhere = "`category`.`asset_flag` = 1";
} else {
$sqlAssetWhere = "`category`.`asset_flag` = 0";
}
if ($blnInventoryFlag) {
$sqlInventoryWhere = " AND `category`.`inventory_flag` = 1";
} else {
$sqlInventoryWhere .= " AND `category`.`inventory_flag` = 0";
}
// Setup the SQL Query
$strQuery = sprintf('
SELECT
COUNT(*) as row_count
FROM
`category`
WHERE
%s
%s', $sqlAssetWhere, $sqlInventoryWhere);
// Perform the Query and Return the Count
$objDbResult = $objDatabase->Query($strQuery);
$strDbRow = $objDbResult->FetchRow();
return QType::Cast($strDbRow[0], QType::Integer);
}
