/**
* Returns array of offers investment.
* @param int $investmentId
* @param int $lngId
* @return array
*/
public static function GetOffers($investmentId, $lngId = 1045)
{
$db = DataBase::GetDbInstance();
$params = array((int) $investmentId, (int) $lngId);
$query = "SELECT o.id FROM #S#offers o INNER JOIN #S#investments_buildings b ON o.investments_buildings_id=b.id WHERE b.investments_id=? AND o.id_lng=? ORDER BY o.id";
$result = $db->ExecuteQueryWithParams($query, $params);
$offers = array();
while ($row = $db->FetchArray($result)) {
$offers[] = Offers::getOffer($row[0], $lngId);
}
return $offers;
}
