class GetCampaignTargetingCriteria {
public static function runExample(AdWordsServices $adWordsServices,
AdWordsSession $session, $campaignId,$CustomerId,$kuerzel) {
global $DBH;
$campaignCriterionService =
$adWordsServices->get($session, CampaignCriterionService::class);
$sql="SELECT ac.campaign_id, ac.kuerzel_land,ac.status from adwords_campaign ac where ac.customer_id=".$CustomerId;
echo $sql."<br>";
try {
$STH_out= $DBH->query($sql);
} catch(PDOException $e) {
echo "Es ist ein Fehler aufgetreten getCampaigns-1: {$e->getMessage()} ";
file_put_contents('PDOErrors.txt', $e->getMessage()." getCampaigns-111111", FILE_APPEND);
}
$STH_out->setFetchMode(PDO::FETCH_ASSOC);
while($row = $STH_out->fetch()) {
$campaignarray[$row['campaign_id']][0]= $row['kuerzel_land'];
$campaignarray[$row['campaign_id']][1]= $row['status'];
}
// Create a selector to select all campaign criteria for the specified
// campaign.
$locale = 'DE';
$selector = new Selector();
$selector->setFields(['Id', 'CriteriaType','CampaignId','LocationName','ParentLocations','TargetingStatus']);
$selector->setPredicates([
// new Predicate('CampaignId', PredicateOperator::IN, [$campaignId])/*,
new Predicate('CriteriaType', PredicateOperator::IN,
['LOCATION']),
//new Predicate('LanguageCode', PredicateOperator::EQUALS, [$locale])
]);
$selector->setPaging(new Paging(0, self::PAGE_LIMIT));
$c=0;
do {
// Retrieve campaign criteria one page at a time, continuing to request
// pages until all campaign criteria have been retrieved.
$page = $campaignCriterionService->get($selector);
// Print out some information for each campaign criterion.
if ($page->getEntries() !== null) {
$totalNumEntries = $page->getTotalNumEntries();
foreach ($page->getEntries() as $campaignCriterion) {
$CampaignId = $campaignCriterion->getCampaignId();
$CriterionId = $campaignCriterion->getCriterion()->getId();
$LocationName = $campaignCriterion->getCriterion()->getLocationName();
$TargetingStatus = $campaignCriterion->getCriterion()->getTargetingStatus();
$TargetType = $campaignCriterion->getCriterion()->getDisplayType();