/**
* @param Restaurant $restaurant
*
* @return integer
*/
public function getAverageCost(Restaurant $restaurant)
{
$sql = 'SELECT AVG(cost) as averageCost FROM reviews WHERE restaurant_id = :restaurant_id';
$stmt = $this->getEntityManager()->getConnection()->prepare($sql);
$stmt->bindValue('restaurant_id', $restaurant->getId());
$stmt->execute();
$results = $stmt->fetch();
return (int) $results["averageCost"];
}
