/**
* This functions returns the number of records that maches given conditions.
*/
public static function recordsCount($year, $hspPlanId)
{
$selectTable = "`" . parent::DB_TABLE_HSP_SUMMARY . "`";
$selectFields[0] = "COUNT(summary_id)";
$selectConditions[0] = "`" . parent::DB_FIELD_HSP_PLAN_YEAR . "` = '" . $year . "'";
$selectConditions[1] = parent::_twoHspPlansCondition($hspPlanId);
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleSelect($selectTable, $selectFields, $selectConditions, null, null, null, true);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
$row = $dbConnection->dbObject->getArray($result);
return $row[0];
}
