function updateUrls()
{
$updatedKeywords = array();
$dao = new KeywordDAO();
$keywords = $dao->loadAll();
foreach ($keywords as $keyword) {
$keyword = $this->updateURL($keyword);
if ($keyword->isChanged()) {
$updatedKeywords[] = $keyword;
}
}
// Save changes
$dao = new KeywordDAO();
$dao->saveKeywords($updatedKeywords);
return $updatedKeywords;
}
function loadKeywords()
{
$keywordDAO = new KeywordDAO();
$keywords = $keywordDAO->loadAll();
$managedKeywords = array();
$todayStart = mktime(0, 0, 0, date("m", time()), date("d", time()), date("Y", time()));
$end = gmdate("Y-m-d", $todayStart - 1);
foreach ($keywords as $keyword) {
if ($keyword->isApplyBidRule()) {
$increaseStart = gmdate("Y-m-d", $todayStart - $keyword->getKeywordIncreaseDays() * SECONDS_IN_DAY);
$decreaseStart = gmdate("Y-m-d", $todayStart - $keyword->getKeywordDecreaseDays() * SECONDS_IN_DAY);
$managedKeyword = $this->getManagedEntity($keyword->id, "keyword_id", $increaseStart, $decreaseStart, $end);
$managedKeyword->ppcEntity = $keyword;
$managedKeywords[] = $managedKeyword;
}
}
return $managedKeywords;
}
<?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) {
?>
$service->yahooUpload($ysmMaster, $ysmClient, $keywords);
}
if ($_REQUEST["action"] == "adcenter_upload") {
$dao = new KeywordDAO();
$keywords = $dao->loadAll(false, true);
$filename = "adcenter-" . date("Y-m-d_H-i-s") . ".csv";
$service->adcenterUpload(dirname(__FILE__) . "/adcenter_temp/{$filename}", $keywords);
header("Content-type: text/csv");
header("Content-disposition: attachment; filename={$filename}");
print file_get_contents(dirname(__FILE__) . "/adcenter_temp/{$filename}");
die;
}
if ($_REQUEST["action"] == "update") {
$service->updateUrls();
$dao = new KeywordDAO();
$keywords = $dao->loadAll(false, true);
}
}
?>
<html>
<head>
<title>URL Update</title>
</head>
<body>
<h1>URL Update</h1>
<ul>
<li><a href="<?php
print $_SERVER["PHP_SELF"];
?>
?action=adwords_download">AdWords URL Download</a></li>
<li><a href="<?php
private function importKeywords($adgroups)
{
$keywordDAO = new KeywordDAO();
$report = $this->getKeywordReport();
$oldKeywords = $keywordDAO->loadAll();
$keywords = array();
foreach ($oldKeywords as $keyword) {
$keywords[$keyword->keywordId] = $keyword;
}
$rows = explode("\n", $report);
foreach ($rows as $row) {
$keyword = $this->importKeywordStructureRow($row, $adgroups, $keywords);
if ($keyword) {
$keywords[$keyword->keywordId] = $keyword;
}
}
$keywordDAO->saveKeywords($keywords);
return $keywords;
}
