本文整理汇总了PHP中StatementBuilder::Where方法的典型用法代码示例。如果您正苦于以下问题:PHP StatementBuilder::Where方法的具体用法?PHP StatementBuilder::Where怎么用?PHP StatementBuilder::Where使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类StatementBuilder
的用法示例。
在下文中一共展示了StatementBuilder::Where方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: testToStatementNoOffset
/**
* @covers StatementBuilder::ToStatement
*/
public function testToStatementNoOffset()
{
$expectedQuery = 'WHERE a = b AND b = c ORDER BY a ASC, b DESC LIMIT 200';
$statementBuilder = new StatementBuilder();
$query = $statementBuilder->Where('a = b AND b = c')->OrderBy('a ASC, b DESC')->Limit(200)->ToStatement()->query;
$this->assertEquals($expectedQuery, $query);
}
示例2: syncDFPAPIadvertiser
public function syncDFPAPIadvertiser()
{
$data = array();
// Get the CompanyService.
$companyService = $this->dfp_user->GetService('CompanyService', 'v201508');
// Create a statement to select only companies that are advertisers.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('type = :type')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('type', 'ADVERTISER');
// Get companies by statement.
$page = $companyService->getCompaniesByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
foreach ($page->results as $company) {
$row = $this->getAdvertiserById($company->id);
if (!isset($row[0])) {
$data[] = array($company->id, $company->name);
}
}
}
$field = array('dfp_adv_id', 'dfp_adv_name');
return $this->insert($this->table, $data, $field, false);
}
示例3: dirname
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201608/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
// Set the ID of the custom targeting key to update.
$customTargetingKeyId = 'INSERT_CUSTOM_TARGETING_KEY_ID_HERE';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the CustomTargetingService.
$customTargetingService = $user->GetService('CustomTargetingService', 'v201608');
// Create a statement to select a single custom targeting key by ID.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('id = :id')->OrderBy('id ASC')->Limit(1)->WithBindVariableValue('id', $customTargetingKeyId);
// Default for total result set size.
$totalResultSetSize = 0;
// Get the custom targeting key.
$page = $customTargetingService->getCustomTargetingKeysByStatement($statementBuilder->ToStatement());
$customTargetingKey = $page->results[0];
// Update the custom targeting key's display name.
$customTargetingKey->displayName = 'New custom targeting key display name.';
// Update the custom targeting key on the server.
$customTargetingKeys = $customTargetingService->updateCustomTargetingKeys(array($customTargetingKey));
foreach ($customTargetingKeys as $updatedCustomTargetingKey) {
printf("Custom targeting key with ID %d, name '%s', and display name '%s' " . "was updated.\n", $updatedCustomTargetingKey->id, $updatedCustomTargetingKey->name, $updatedCustomTargetingKey->displayName);
}
} catch (OAuth2Exception $e) {
ExampleUtils::CheckForOAuth2Errors($e);
} catch (ValidationException $e) {
示例4: dirname
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201505/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
// Set the ID of the creative wrapper to update.
$creativeWrapperId = 'INSERT_CREATIVE_WRAPPER_ID_HERE';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the CreativeWrapperService.
$creativeWrapperService = $user->GetService('CreativeWrapperService', 'v201505');
// Create a statement to select a single creative wrapper by ID.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('id = :id')->OrderBy('id ASC')->Limit(1)->WithBindVariableValue('id', $creativeWrapperId);
// Get the creative wrapper.
$page = $creativeWrapperService->getCreativeWrappersByStatement($statementBuilder->ToStatement());
$creativeWrapper = $page->results[0];
// Update the creative wrapper ordering.
$creativeWrapper->ordering = 'OUTER';
// Update the creative wrapper on the server.
$creativeWrappers = $creativeWrapperService->updateCreativeWrappers(array($creativeWrapper));
foreach ($creativeWrappers as $updatedCreativeWrapper) {
printf("Creative wrapper with ID %d, and wrapping order '%s' was " . "updated.\n", $updatedCreativeWrapper->id, $updatedCreativeWrapper->ordering);
}
} catch (OAuth2Exception $e) {
ExampleUtils::CheckForOAuth2Errors($e);
} catch (ValidationException $e) {
ExampleUtils::CheckForOAuth2Errors($e);
} catch (Exception $e) {
示例5: dirname
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201508/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
// Set the ID of the line item to deactivate LICAs for.
$lineItemId = 'INSERT_LINE_ITEM_ID_HERE';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the LineItemCreativeAssociationService.
$licaService = $user->GetService('LineItemCreativeAssociationService', 'v201508');
// Create a statement to select all LICAs for a line item.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('lineItemId = :lineItemId')->OrderBy('lineItemId ASC, creativeId ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('lineItemId', $lineItemId);
// Default for total result set size.
$totalResultSetSize = 0;
do {
// Get LICAs by statement.
$page = $licaService->getLineItemCreativeAssociationsByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
$totalResultSetSize = $page->totalResultSetSize;
$i = $page->startIndex;
foreach ($page->results as $lica) {
if (isset($lica->creativeSetId)) {
printf("%d) LICA with line item ID %d, and creative set ID %d will " . "be deactivated.\n", $i++, $lica->lineItemId, $lica->creativeSetId);
} else {
printf("%d) LICA with line item ID %d, and creative ID %d will be " . "deactivated.\n", $i++, $lica->lineItemId, $lica->creativeId);
}
示例6: array
$customCriteria3->valueIds = array($customCriteriaIds3[1]);
$customCriteria3->operator = 'IS';
// Create the custom criteria set that will resemble:
//
// ($customCriteria1.key == $customCriteria1.value OR
// ($customCriteria2.key != $customCriteria2.value AND
// $customCriteria3.key == $customCriteria3.value))
$topCustomCriteriaSet = new CustomCriteriaSet();
$topCustomCriteriaSet->logicalOperator = 'OR';
$subCustomCriteriaSet = new CustomCriteriaSet();
$subCustomCriteriaSet->logicalOperator = 'AND';
$subCustomCriteriaSet->children = array($customCriteria2, $customCriteria3);
$topCustomCriteriaSet->children = array($customCriteria1, $subCustomCriteriaSet);
// Create a statement to select a single line item by ID.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('id = :id')->OrderBy('id ASC')->Limit(1)->WithBindVariableValue($lineItemId);
// Get the line item.
$results = $lineItemService->getLineItemsByStatement($statementBuilder->ToStatement())->results;
$lineItem = $results[0];
// Set the custom criteria targeting on the line item.
$lineItem->targeting->customTargeting = $topCustomCriteriaSet;
// Update the line item on the server.
$lineItems = $lineItemService->updateLineItems(array($lineItem));
foreach ($lineItems as $lineItem) {
printf("Line item with ID %d was updated.\n", $lineItem->id);
}
} catch (OAuth2Exception $e) {
ExampleUtils::CheckForOAuth2Errors($e);
} catch (ValidationException $e) {
ExampleUtils::CheckForOAuth2Errors($e);
} catch (Exception $e) {
示例7: DfpUser
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the ReportService.
$reportService = $user->GetService('ReportService', 'v201411');
// Create report query.
$reportQuery = new ReportQuery();
$reportQuery->dimensions = array('ORDER_ID', 'ORDER_NAME');
$reportQuery->dimensionAttributes = array('ORDER_TRAFFICKER', 'ORDER_START_DATE_TIME', 'ORDER_END_DATE_TIME');
$reportQuery->columns = array('AD_SERVER_IMPRESSIONS', 'AD_SERVER_CLICKS', 'AD_SERVER_CTR', 'AD_SERVER_CPM_AND_CPC_REVENUE', 'AD_SERVER_WITHOUT_CPD_AVERAGE_ECPM');
// Create statement to filter for an order.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('order_id = :orderId')->WithBindVariableValue('orderId', $orderId);
// Set the filter statement.
$reportQuery->statement = $statementBuilder->ToStatement();
// Set the start and end dates or choose a dynamic date range type.
$reportQuery->dateRangeType = 'LAST_MONTH';
// Create report job.
$reportJob = new ReportJob();
$reportJob->reportQuery = $reportQuery;
// Run report job.
$reportJob = $reportService->runReportJob($reportJob);
// Create report downloader.
$reportDownloader = new ReportDownloader($reportService, $reportJob->id);
// Wait for the report to be ready.
$reportDownloader->waitForReportReady();
// Change to your file location.
$filePath = sprintf('%s.csv.gz', tempnam(sys_get_temp_dir(), 'delivery-report-'));
示例8: dirname
require_once 'Google/Api/Ads/Dfp/Util/v201602/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
// Set the ad unit ID to archive underneath.
$parentAdUnitId = 'INSERT_AD_UNIT_ID_HERE';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the InventoryService.
$inventoryService = $user->GetService('InventoryService', 'v201602');
// Create a statement to select ad units under the parent ad unit and the
// parent ad unit.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('parentId = :parentId or id = :parentId')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('parentId', $parentAdUnitId);
// Default for total result set size.
$totalResultSetSize = 0;
do {
// Get ad units by statement.
$page = $inventoryService->getAdUnitsByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
$totalResultSetSize = $page->totalResultSetSize;
$i = $page->startIndex;
foreach ($page->results as $adUnit) {
printf("%d) Ad unit with ID %d, and name '%s' will be archived.\n", $i++, $adUnit->id, $adUnit->name);
}
}
$statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT);
} while ($statementBuilder->GetOffset() < $totalResultSetSize);
示例9: dirname
set_include_path(get_include_path() . PATH_SEPARATOR . $path);
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201605/DateTimeUtils.php';
require_once 'Google/Api/Ads/Dfp/Util/v201605/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the LineItemService.
$lineItemService = $user->GetService('LineItemService', 'v201605');
// Create a statement to select only recently updated line items.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('lastModifiedDateTime >= :lastModifiedDateTime')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('lastModifiedDateTime', DateTimeUtils::ToDfpDateTime(new DateTime('-1 day', new DateTimeZone('America/New_York'))));
// Default for total result set size.
$totalResultSetSize = 0;
do {
// Get line items by statement.
$page = $lineItemService->getLineItemsByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
$totalResultSetSize = $page->totalResultSetSize;
$i = $page->startIndex;
foreach ($page->results as $lineItem) {
printf("%d) Line item with ID %d, belonging to order %d, and name '%s' " . "was found.\n", $i++, $lineItem->id, $lineItem->orderId, $lineItem->name);
}
}
$statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT);
} while ($statementBuilder->GetOffset() < $totalResultSetSize);
示例10: dirname
$path = dirname(__FILE__) . '/../../../../lib';
set_include_path(get_include_path() . PATH_SEPARATOR . $path);
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201502/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the ProposalService.
$proposalService = $user->GetService('ProposalService', 'v201502');
// Create a statement to select only proposals pending approval.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('status = :status')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('status', 'PENDING_APPROVAL');
// Default for total result set size.
$totalResultSetSize = 0;
do {
// Get proposals by statement.
$page = $proposalService->getProposalsByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
$totalResultSetSize = $page->totalResultSetSize;
$i = $page->startIndex;
foreach ($page->results as $proposal) {
printf("%d) Proposal with ID %d and name '%s' was found.\n", $i++, $proposal->id, $proposal->name);
}
}
$statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT);
} while ($statementBuilder->GetOffset() < $totalResultSetSize);
示例11: DfpUser
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the ReportService.
$reportService = $user->GetService('ReportService', 'v201505');
// Get the NetworkService.
$networkService = $user->GetService('NetworkService', 'v201505');
// Get the root ad unit ID to filter on.
$rootAdUnitId = $networkService->getCurrentNetwork()->effectiveRootAdUnitId;
// Create statement to filter on a parent ad unit with the root ad unit ID to
// include all ad units in the network.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('PARENT_AD_UNIT_ID = :parentAdUnitId')->WithBindVariableValue('parentAdUnitId', intval($rootAdUnitId));
// Create report query.
$reportQuery = new ReportQuery();
$reportQuery->dimensions = array('AD_UNIT_ID', 'AD_UNIT_NAME');
$reportQuery->columns = array('AD_SERVER_IMPRESSIONS', 'AD_SERVER_CLICKS', 'DYNAMIC_ALLOCATION_INVENTORY_LEVEL_IMPRESSIONS', 'DYNAMIC_ALLOCATION_INVENTORY_LEVEL_CLICKS', 'TOTAL_INVENTORY_LEVEL_IMPRESSIONS', 'TOTAL_INVENTORY_LEVEL_CPM_AND_CPC_REVENUE');
// Set the filter statement.
$reportQuery->statement = $statementBuilder->ToStatement();
// Set the ad unit view to hierarchical.
$reportQuery->adUnitView = 'HIERARCHICAL';
// Set the start and end dates or choose a dynamic date range type.
$reportQuery->dateRangeType = 'YESTERDAY';
// Create report job.
$reportJob = new ReportJob();
$reportJob->reportQuery = $reportQuery;
// Run report job.
$reportJob = $reportService->runReportJob($reportJob);
示例12: dirname
$path = dirname(__FILE__) . '/../../../../lib';
set_include_path(get_include_path() . PATH_SEPARATOR . $path);
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201508/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the ProductTemplateService.
$productTemplateService = $user->GetService('ProductTemplateService', 'v201508');
// Create a statement to select only sponsorship product templates.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('lineItemType = :lineItemType')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('lineItemType', 'SPONSORSHIP');
// Default for total result set size.
$totalResultSetSize = 0;
do {
// Get product templates by statement.
$page = $productTemplateService->getProductTemplatesByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
$totalResultSetSize = $page->totalResultSetSize;
$i = $page->startIndex;
foreach ($page->results as $productTemplate) {
printf("%d) Product template with ID %d, and name '%s' was found.\n", $i++, $productTemplate->id, $productTemplate->name);
}
}
$statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT);
} while ($statementBuilder->GetOffset() < $totalResultSetSize);
示例13: dirname
set_include_path(get_include_path() . PATH_SEPARATOR . $path);
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201602/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the CustomFieldService.
$customFieldService = $user->GetService('CustomFieldService', 'v201602');
// Create a statement to select only custom fields that can be applied to
// line items.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('entityType = :entityType')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('entityType', 'LINE_ITEM');
// Default for total result set size.
$totalResultSetSize = 0;
do {
// Get custom fields by statement.
$page = $customFieldService->getCustomFieldsByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
$totalResultSetSize = $page->totalResultSetSize;
$i = $page->startIndex;
foreach ($page->results as $customField) {
printf("%d) Custom field with ID %d, and name '%s' was found.\n", $i++, $customField->id, $customField->name);
}
}
$statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT);
} while ($statementBuilder->GetOffset() < $totalResultSetSize);
示例14: dirname
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
// Set the user ID of the user team association to update.
$userId = 'INSERT_USER_ID_HERE';
// Set the team ID of the user team association to update.
$teamId = 'INSERT_TEAM_ID_HERE';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the UserTeamAssociationService.
$userTeamAssociationService = $user->GetService('UserTeamAssociationService', 'v201608');
// Create a statement to select a single user team association by ID.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('userId = :userId AND teamId = :teamId')->OrderBy('userId ASC, teamId ASC')->Limit(1)->WithBindVariableValue('userId', $userId)->WithBindVariableValue('teamId', $teamId);
// Get the user team association.
$page = $userTeamAssociationService->getUserTeamAssociationsByStatement($statementBuilder->ToStatement());
$userTeamAssociation = $page->results[0];
// Update the user's access type on the team.
$userTeamAssociation->overriddenTeamAccessType = 'READ_ONLY';
// Update the user team association on the server.
$userTeamAssociations = $userTeamAssociationService->updateUserTeamAssociations(array($userTeamAssociation));
foreach ($userTeamAssociations as $updatedUserTeamAssociation) {
printf("User team association with user ID %d, and team ID %d was " . "updated.\n", $updatedUserTeamAssociation->userId, $updatedUserTeamAssociation->teamId);
}
} catch (OAuth2Exception $e) {
ExampleUtils::CheckForOAuth2Errors($e);
} catch (ValidationException $e) {
ExampleUtils::CheckForOAuth2Errors($e);
} catch (Exception $e) {
示例15: dirname
$path = dirname(__FILE__) . '/../../../../src';
set_include_path(get_include_path() . PATH_SEPARATOR . $path);
require_once 'Google/Api/Ads/Dfp/Lib/DfpUser.php';
require_once 'Google/Api/Ads/Dfp/Util/v201411/StatementBuilder.php';
require_once dirname(__FILE__) . '/../../../Common/ExampleUtils.php';
try {
// Get DfpUser from credentials in "../auth.ini"
// relative to the DfpUser.php file's directory.
$user = new DfpUser();
// Log SOAP XML request and response.
$user->LogDefaults();
// Get the OrderService.
$orderService = $user->GetService('OrderService', 'v201411');
// Create a statement to select only orders that are starting soon.
$statementBuilder = new StatementBuilder();
$statementBuilder->Where('status = :status AND startDateTime >= :now AND startDateTime <= :soon')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('status', 'APPROVED')->WithBindVariableValue('now', date(DateTimeUtils::$DFP_DATE_TIME_STRING_FORMAT, strtotime('now')))->WithBindVariableValue('soon', date(DateTimeUtils::$DFP_DATE_TIME_STRING_FORMAT, strtotime('5 day')));
// Default for total result set size.
$totalResultSetSize = 0;
do {
// Get orders by statement.
$page = $orderService->getOrdersByStatement($statementBuilder->ToStatement());
// Display results.
if (isset($page->results)) {
$totalResultSetSize = $page->totalResultSetSize;
$i = $page->startIndex;
foreach ($page->results as $order) {
printf("%d) Order with ID %d, name '%s', and advertiser ID %d was " . "found.\n", $i++, $order->id, $order->name, $order->advertiserId);
}
}
$statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT);
} while ($statementBuilder->GetOffset() < $totalResultSetSize);