/** * 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; }