public function importStructure($masterAccount, $clientAccount)
{
parent::importStructure($masterAccount, $clientAccount);
$campaignDAO = new CampaignDAO();
$campaigns = $campaignDAO->loadAll("adcenter");
$campaignDAO->saveCampaigns($campaigns);
}
function loadCampaigns()
{
$campaignDAO = new CampaignDAO();
$campaigns = $campaignDAO->loadAll();
$managedCampaigns = array();
$todayStart = mktime(0, 0, 0, date("m", time()), date("d", time()), date("Y", time()));
$end = gmdate("Y-m-d", $todayStart - 1);
foreach ($campaigns as $campaign) {
if ($campaign->isApplyBidRule()) {
$increaseStart = gmdate("Y-m-d", $todayStart - $campaign->getCampaignIncreaseDays() * SECONDS_IN_DAY);
$decreaseStart = gmdate("Y-m-d", $todayStart - $campaign->getCampaignDecreaseDays() * SECONDS_IN_DAY);
$managedCampaign = $this->getManagedEntity($campaign->id, "campaign_id", $increaseStart, $decreaseStart, $end);
$managedCampaign->ppcEntity = $campaign;
$managedCampaigns[] = $managedCampaign;
}
}
return $managedCampaigns;
}
private function importCampaigns()
{
$campaignDAO = new CampaignDAO();
$report = $this->getCampaignReport();
$oldCampaigns = $campaignDAO->loadAll();
$campaigns = array();
foreach ($oldCampaigns as $campaign) {
$campaigns[$campaign->campaignId] = $campaign;
}
$rows = explode("\n", $report);
foreach ($rows as $row) {
$campaign = $this->importCampaignStructureRow($row, $campaigns);
if ($campaign) {
$campaigns[$campaign->campaignId] = $campaign;
}
}
$campaignDAO->saveCampaigns($campaigns);
$oldCampaigns = $campaignDAO->loadAll();
$campaigns = array();
foreach ($oldCampaigns as $campaign) {
$campaigns[$campaign->campaignId] = $campaign;
}
return $campaigns;
}
<?php include_once '../database/PPCEntityDAO.php'; $d = new CampaignDAO(); //$c = new Campaign(); //$d->saveCampaigns(array($c)); $c = $d->load(1); //print_r($c); //print $c->campaignBidRule->id; //$r1 = $c->campaignBidRule; $r1 = new BidRule(); $r1->cost_threshold = 1; $r1->decrease_days = 2; $r1->decrease_percent = 3; $r1->increase_days = 4; $r1->increase_percent = 5; $c->campaignBidRule = $r1; $r2 = new BidRule(); $r2->cost_threshold = 6; $r2->decrease_days = 7; $r2->decrease_percent = 8; $r2->increase_days = 9; $r2->increase_percent = 10; $c->adgroupBidRule = $r2; $r3 = new BidRule(); $r3->cost_threshold = 11; $r3->decrease_days = 12; $r3->decrease_percent = 13; $r3->increase_days = 14; $r3->increase_percent = 15; $c->keywordBidRule = $r3;
public function importStructure($masterAccount, $clientAccount)
{
parent::importStructure($masterAccount, $clientAccount);
$campaignDAO = new CampaignDAO();
$campaigns = $campaignDAO->loadAll("yahoo");
$this->yahooService->downloadCampaignBudgets($masterAccount, $clientAccount, $campaigns);
$campaignDAO->saveCampaigns($campaigns);
}
<?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>
function instantiateAdgroup($row)
{
$adgroup = new Adgroup();
$adgroup->id = $row["id"];
$campaignDAO = new CampaignDAO();
$adgroup->campaign = $campaignDAO->load($row["campaign_id"]);
$adgroup->adgroupId = $row["adgroup_id"];
$adgroup->name = $row["adgroup_name"];
$adgroup->searchMaxCpc = $row["search_max_cpc"];
$adgroup->currentBid = $row["content_max_cpc"];
$adgroup->newBid = $row["new_content_max_cpc"];
$adgroup->currentStatus = $row["status"];
$adgroup->newStatus = $row["new_status"];
$adgroup->defaultUrl = $row["default_url"];
$dao = new BidRuleDAO();
if (isset($row["adgroup_bid_rule_id"]) && $row["adgroup_bid_rule_id"] > 0) {
$adgroup->adgroupBidRule = $dao->load($row["adgroup_bid_rule_id"]);
}
if (isset($row["keyword_bid_rule_id"]) && $row["keyword_bid_rule_id"] > 0) {
$adgroup->keywordBidRule = $dao->load($row["keyword_bid_rule_id"]);
}
return $adgroup;
}
<?php
require_once dirname(__FILE__) . '/../database/BidRuleDAO.php';
require_once dirname(__FILE__) . '/../database/PPCEntityDAO.php';
$ruleDAO = new BidRuleDAO();
$campaignDAO = new CampaignDAO();
$campaign = $campaignDAO->load($_REQUEST["campaignId"]);
if ($campaign->keywordBidRule == null) {
$campaign->keywordBidRule = new BidRule();
$campaign->keywordBidRule->entityType = 3;
$campaign->keywordBidRule->ruleType = 1;
}
if ($campaign->adgroupBidRule == null) {
$campaign->adgroupBidRule = new BidRule();
$campaign->adgroupBidRule->entityType = 3;
$campaign->adgroupBidRule->ruleType = 2;
}
if ($campaign->campaignBidRule == null) {
$campaign->campaignBidRule = new BidRule();
$campaign->campaignBidRule->entityType = 3;
$campaign->campaignBidRule->ruleType = 3;
}
if (isset($_REQUEST["keyword_cost_threshold"])) {
$campaign->keywordBidRule->cost_threshold = strip_tags($_REQUEST["keyword_cost_threshold"]);
$campaign->keywordBidRule->increase_percent = strip_tags($_REQUEST["keyword_bid_increase_percent"]);
$campaign->keywordBidRule->increase_days = strip_tags($_REQUEST["keyword_bid_increase_days"]);
$campaign->keywordBidRule->decrease_percent = strip_tags($_REQUEST["keyword_bid_decrease_percent"]);
$campaign->keywordBidRule->decrease_days = strip_tags($_REQUEST["keyword_bid_decrease_days"]);
$campaign->keywordBidRule->apply = $_REQUEST["apply_keyword_rule"] == "on";
$campaign->adgroupBidRule->cost_threshold = strip_tags($_REQUEST["adgroup_cost_threshold"]);
$campaign->adgroupBidRule->increase_percent = strip_tags($_REQUEST["adgroup_bid_increase_percent"]);
function updateCampaigns()
{
$updatedCampaigns = array();
$dao = new ManagedEntityDAO();
$campaigns = $dao->loadCampaigns($engine);
foreach ($campaigns as $campaign) {
$campaign->update();
if ($campaign->ppcEntity->isChanged()) {
$updatedCampaigns[] = $campaign->ppcEntity;
}
}
// Save changes
$dao = new CampaignDAO();
$dao->saveCampaigns($updatedCampaigns);
return $updatedCampaigns;
}
<?php
require_once dirname(__FILE__) . '/../database/PPCEntityDAO.php';
$dao = new CampaignDAO();
$campaigns = $dao->loadAll($_REQUEST["engine"]);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Campaigns</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<h2>Campaigns</h2>
<table>
<thead>
<tr>
<th>Campaign</th>
</tr>
</thead>
<tbody>
<?php
foreach ($campaigns as $campaign) {
?>
<tr>
<td><a href="adgroups.php?campaignId=<?php
print $campaign->id;
?>
"><?php
print $campaign->name;
?>
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
print $_SERVER["PHP_SELF"];
?>
