function loadAdgroups()
{
$adgroupDAO = new AdgroupDAO();
$adgroups = $adgroupDAO->loadAll();
$managedAdgroups = array();
$todayStart = mktime(0, 0, 0, date("m", time()), date("d", time()), date("Y", time()));
$end = gmdate("Y-m-d", $todayStart - 1);
foreach ($adgroups as $adgroup) {
if ($adgroup->isApplyBidRule()) {
$increaseStart = gmdate("Y-m-d", $todayStart - $adgroup->getAdgroupIncreaseDays() * SECONDS_IN_DAY);
$decreaseStart = gmdate("Y-m-d", $todayStart - $adgroup->getAdgroupDecreaseDays() * SECONDS_IN_DAY);
$managedAdgroup = $this->getManagedEntity($adgroup->id, "adgroup_id", $increaseStart, $decreaseStart, $end);
$managedAdgroup->ppcEntity = $adgroup;
$managedAdgroups[] = $managedAdgroup;
}
}
return $managedAdgroups;
}
<?php
require_once dirname(__FILE__) . '/../database/BidRuleDAO.php';
require_once dirname(__FILE__) . '/../database/PPCEntityDAO.php';
$ruleDAO = new BidRuleDAO();
$adgroupDAO = new AdgroupDAO();
$adgroup = $adgroupDAO->load($_REQUEST["adgroupId"]);
if ($adgroup->keywordBidRule == null) {
$adgroup->keywordBidRule = new BidRule();
$adgroup->keywordBidRule->entityType = 2;
$adgroup->keywordBidRule->ruleType = 1;
}
if ($adgroup->adgroupBidRule == null) {
$adgroup->adgroupBidRule = new BidRule();
$adgroup->adgroupBidRule->entityType = 2;
$adgroup->adgroupBidRule->ruleType = 2;
}
if (isset($_REQUEST["keyword_cost_threshold"])) {
$adgroup->keywordBidRule->cost_threshold = strip_tags($_REQUEST["keyword_cost_threshold"]);
$adgroup->keywordBidRule->increase_percent = strip_tags($_REQUEST["keyword_bid_increase_percent"]);
$adgroup->keywordBidRule->increase_days = strip_tags($_REQUEST["keyword_bid_increase_days"]);
$adgroup->keywordBidRule->decrease_percent = strip_tags($_REQUEST["keyword_bid_decrease_percent"]);
$adgroup->keywordBidRule->decrease_days = strip_tags($_REQUEST["keyword_bid_decrease_days"]);
$adgroup->keywordBidRule->apply = $_REQUEST["apply_keyword_rule"] == "on";
$adgroup->adgroupBidRule->cost_threshold = strip_tags($_REQUEST["adgroup_cost_threshold"]);
$adgroup->adgroupBidRule->increase_percent = strip_tags($_REQUEST["adgroup_bid_increase_percent"]);
$adgroup->adgroupBidRule->increase_days = strip_tags($_REQUEST["adgroup_bid_increase_days"]);
$adgroup->adgroupBidRule->decrease_percent = strip_tags($_REQUEST["adgroup_bid_decrease_percent"]);
$adgroup->adgroupBidRule->decrease_days = strip_tags($_REQUEST["adgroup_bid_decrease_days"]);
$adgroup->adgroupBidRule->apply = $_REQUEST["apply_adgroup_rule"] == "on";
$adgroupDAO->saveAdgroups(array($adgroup));
<?php
require_once dirname(__FILE__) . '/../database/PPCEntityDAO.php';
$dao = new AdgroupDAO();
$adgroups = $dao->loadAll($_REQUEST["campaignId"]);
$campaignDAO = new CampaignDAO();
$campaign = $campaignDAO->load($_REQUEST["campaignId"]);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Ad Groups</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<h2>Ad Groups</h2>
<h3><?php
print "{$campaign->engine} >> {$campaign->name}";
?>
</h3>
<table>
<thead>
<tr>
<th>Ad Group</th>
</tr>
</thead>
<tbody>
<?php
foreach ($adgroups as $adgroup) {
?>
<tr>
<?php
require_once dirname(__FILE__) . '/../database/PPCEntityDAO.php';
$dao = new KeywordDAO();
$keywords = $dao->loadAll($_REQUEST["adgroupId"]);
$adgroupDAO = new AdgroupDAO();
$adgroup = $adgroupDAO->load($_REQUEST["adgroupId"]);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Keywords</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<h2>Keywords</h2>
<h3><?php
print "{$adgroup->campaign->engine} >> {$adgroup->campaign->name} >> {$adgroup->name}";
?>
</h3>
<table>
<thead>
<tr>
<th>Keyword</th>
<th>Match Type</th>
</tr>
</thead>
<tbody>
<?php
foreach ($keywords as $keyword) {
?>
function instantiateAd($row)
{
$ad = new Ad();
$ad->id = $row["id"];
$adgroupDAO = new AdgroupDAO();
$ad->adgroup = $adgroupDAO->load($row["adgroup_id"]);
$ad->adId = $row["ad_id"];
$ad->name = $row["ad_name"];
$ad->currentUrl = $row["current_url"];
return $ad;
}
function updateAdgroups()
{
$updatedAdgroups = array();
$dao = new ManagedEntityDAO();
$adgroups = $dao->loadAdgroups();
foreach ($adgroups as $adgroup) {
$adgroup->update();
if ($adgroup->ppcEntity->isChanged()) {
$updatedAdgroups[] = $adgroup->ppcEntity;
}
}
// Save changes
$dao = new AdgroupDAO();
$dao->saveAdgroups($updatedAdgroups);
return $updatedAdgroups;
}
private function importAdStructureRow($row, $adgroups, $ads)
{
$fields = $this->getAdStructureFields($row);
if ($fields) {
if (isset($ads[$fields["adId"]])) {
$ad = $ads[$fields["adId"]];
} else {
$ad = new Ad();
$ad->adId = $fields["adId"];
}
$ad->adgroup = $adgroups[$fields["adgroupId"]];
$ad->name = $fields["adName"];
$ad->currentStatus = $fields["status"];
$ad->newStatus = $fields["status"];
$ad->currentUrl = $fields["destinationUrl"];
if ($ad->currentUrl != "") {
$ad->adgroup->defaultUrl = $ad->currentUrl;
$adgroupDAO = new AdgroupDAO();
$adgroupDAO->saveAdgroups(array($ad->adgroup));
}
return $ad;
}
return false;
}
$service->adwordsUpload($adwordsMaster, $adwordsClient, $keywords, $adgroups, $campaigns);
}
if ($_REQUEST["action"] == "yahoo_upload") {
$dao = new KeywordDAO();
$keywords = $dao->loadAll(false, true);
$dao = new AdgroupDAO();
$adgroups = $dao->loadAll(false, true);
$dao = new CampaignDAO();
$campaigns = $dao->loadAll(false, true);
$service->yahooUpload($ysmMaster, $ysmClient, $keywords, $adgroups, $campaigns);
}
if ($_REQUEST["action"] == "update") {
$service->calculateUpdates();
$dao = new KeywordDAO();
$keywords = $dao->loadAll(false, true);
$dao = new AdgroupDAO();
$adgroups = $dao->loadAll(false, true);
$dao = new CampaignDAO();
$campaigns = $dao->loadAll(false, true);
}
}
?>
<html>
<head>
<title>Bid Management Update</title>
</head>
<body>
<h1>Bid Management Update</h1>
<ul>
<li><a
href="<?php
