/**
* Check the status of the Onpub schema.
*
* @return mixed The version of the schema in the database as an int. An array
* of PDOException objects will be returned if the schema is incomplete or
* not installed.
*/
public function status()
{
$oaamaps = new OnpubAAMaps($this->pdo);
$oarticles = new OnpubArticles($this->pdo);
$oauthors = new OnpubAuthors($this->pdo);
$oimages = new OnpubImages($this->pdo);
$osamaps = new OnpubSAMaps($this->pdo);
$osections = new OnpubSections($this->pdo);
$owebsites = new OnpubWebsites($this->pdo);
$owsmaps = new OnpubWSMaps($this->pdo);
$queryOptions = new OnpubQueryOptions($this->pdo);
$queryOptions->setPage(1, 1);
$exceptions = array();
$version = 0;
try {
$oaamaps->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
try {
$oarticles->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
try {
$oauthors->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
try {
$oimages->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
try {
$osamaps->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
try {
$osections->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
try {
$owebsites->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
try {
$owsmaps->select($queryOptions);
} catch (PDOException $e) {
$exceptions[] = $e;
}
if (sizeof($exceptions)) {
return $exceptions;
}
$version = 1;
return $version;
}
public function display()
{
$osections = new OnpubSections($this->pdo);
$owebsites = new OnpubWebsites($this->pdo);
$this->fullTextSearch = "NA";
$counter = 0;
$currentPage = 1;
if ($this->page) {
$currentPage = $this->page;
}
if ($this->orderBy && $this->order) {
if ($this->keywords) {
try {
$queryOptions = new OnpubQueryOptions();
$queryOptions->orderBy = $this->orderBy;
$queryOptions->order = $this->order;
$sections = $osections->search($this->keywords, $queryOptions);
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
$totalSections = sizeof($sections);
} else {
if ($this->websiteID) {
try {
$queryOptions = new OnpubQueryOptions();
$queryOptions->orderBy = $this->orderBy;
$queryOptions->order = $this->order;
$sections = $osections->select($queryOptions, $this->websiteID);
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
$totalSections = sizeof($sections);
} else {
try {
$queryOptions = new OnpubQueryOptions();
$queryOptions->orderBy = $this->orderBy;
$queryOptions->order = $this->order;
$queryOptions->setPage($currentPage, ONPUBGUI_PDO_ROW_LIMIT);
$sections = $osections->select($queryOptions);
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
try {
$totalSections = $osections->count();
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
}
}
} else {
if ($this->keywords) {
try {
$queryOptions = new OnpubQueryOptions();
$queryOptions->orderBy = "created";
$queryOptions->order = "DESC";
$sections = $osections->search($this->keywords, $queryOptions);
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
$totalSections = sizeof($sections);
} else {
if ($this->websiteID) {
try {
$queryOptions = new OnpubQueryOptions();
$queryOptions->orderBy = "created";
$queryOptions->order = "DESC";
$sections = $osections->select($queryOptions, $this->websiteID);
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
$totalSections = sizeof($sections);
} else {
try {
$queryOptions = new OnpubQueryOptions();
$queryOptions->orderBy = "created";
$queryOptions->order = "DESC";
$queryOptions->setPage($currentPage, ONPUBGUI_PDO_ROW_LIMIT);
$sections = $osections->select($queryOptions);
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
try {
$totalSections = $osections->count();
} catch (PDOException $e) {
$widget = new OnpubWidgetPDOException($e);
$widget->display();
return;
}
}
}
}
$widget = new OnpubWidgetHeader("Sections", ONPUBAPI_SCHEMA_VERSION, $this->pdo);
$widget->display();
en('<form id="onpub-form" action="index.php" method="get">');
en('<div>');
if ($totalSections) {
if (!$this->keywords) {
$widget = new OnpubWidgetSelectWebsite($this->pdo, $this->websiteID);
$widget->display();
}
$widget = new OnpubWidgetPaginator($totalSections, $this->orderBy, $this->order, $this->page, $this->keywords, $this->fullTextSearch, "websiteID", $this->websiteID, "EditSections");
$widget->display();
en('<table>');
en('<tr>');
//en('<td></td>');
if ($this->keywords) {
$this->keywords = urlencode($this->keywords);
if ($this->fullTextSearch) {
switch ($this->orderBy) {
case "ID":
switch ($this->order) {
case "ASC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=ID&order=ASC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
}
break;
case "name":
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=name&order=DESC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
}
break;
default:
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=created&order=ASC">Created</a></span></td>');
break;
default:
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&fullTextSearch=' . $this->fullTextSearch . '&orderBy=created&order=ASC">Created</a></span></td>');
break;
}
break;
}
} else {
switch ($this->orderBy) {
case "ID":
switch ($this->order) {
case "ASC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=ID&order=ASC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
}
break;
case "name":
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=name&order=DESC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
}
break;
default:
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=created&order=ASC">Created</a></span></td>');
break;
default:
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&keywords=' . $this->keywords . '&orderBy=created&order=ASC">Created</a></span></td>');
break;
}
break;
}
}
$this->keywords = urldecode($this->keywords);
} else {
if ($this->websiteID) {
switch ($this->orderBy) {
case "ID":
switch ($this->order) {
case "ASC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC&websiteID=' . $this->websiteID . '">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC&websiteID=' . $this->websiteID . '">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC&websiteID=' . $this->websiteID . '">Created</a></span></td>');
break;
case "DESC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=ASC&websiteID=' . $this->websiteID . '">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC&websiteID=' . $this->websiteID . '">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC&websiteID=' . $this->websiteID . '">Created</a></span></td>');
break;
}
break;
case "name":
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC&websiteID=' . $this->websiteID . '">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=DESC&websiteID=' . $this->websiteID . '">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC&websiteID=' . $this->websiteID . '">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC&websiteID=' . $this->websiteID . '">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC&websiteID=' . $this->websiteID . '">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC&websiteID=' . $this->websiteID . '">Created</a></span></td>');
break;
}
break;
default:
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC&websiteID=' . $this->websiteID . '">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC&websiteID=' . $this->websiteID . '">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC&websiteID=' . $this->websiteID . '">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC&websiteID=' . $this->websiteID . '">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC&websiteID=' . $this->websiteID . '">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=ASC&websiteID=' . $this->websiteID . '">Created</a></span></td>');
break;
default:
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC&websiteID=' . $this->websiteID . '">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC&websiteID=' . $this->websiteID . '">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=ASC&websiteID=' . $this->websiteID . '">Created</a></span></td>');
break;
}
break;
}
} else {
switch ($this->orderBy) {
case "ID":
switch ($this->order) {
case "ASC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=ASC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC">Created</a></span></td>');
break;
}
break;
case "name":
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=DESC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC">Created</a></span></td>');
break;
}
break;
default:
switch ($this->order) {
case "ASC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=DESC">Created</a></span></td>');
break;
case "DESC":
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=ASC">Created</a></span></td>');
break;
default:
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=ID&order=DESC">ID</a></span></td>');
en('<td align="left"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=name&order=ASC">Name</a></span></td>');
en('<td align="left"><span class="onpub-field-header">Website</span></td>');
en('<td align="left" class="onpub-highlight2"><span class="onpub-field-header"><a href="index.php?onpub=EditSections&orderBy=created&order=ASC">Created</a></span></td>');
break;
}
break;
}
}
}
en('</tr>');
if ($this->keywords || $this->websiteID) {
$index = ($currentPage - 1) * ONPUBGUI_PDO_ROW_LIMIT;
} else {
$index = 0;
}
for ($i = 0; $i < ONPUBGUI_PDO_ROW_LIMIT && $index < sizeof($sections); $i++) {
$section = $sections[$index];
$this->ID = $sections[$index]->ID;
$name = $sections[$index]->name;
$created = $sections[$index]->getCreated()->format("M j, Y");
$website = $owebsites->get($sections[$index]->websiteID);
$websiteName = $website->name;
if ($section->parentID) {
$names = array();
$names[] = $name;
$name = "";
while ($section->parentID) {
$section = $section->parent;
$names[] = $section->name;
}
$names = array_reverse($names);
for ($j = 0; $j < sizeof($names); $j++) {
if ($j == 0) {
$name .= $names[$j];
} else {
$name .= ' – ' . $names[$j];
}
}
}
en('<tr valign="top">');
//en('<td align="right"><input type="checkbox" name="sectionIDs[]" value="' . $this->ID . '"></td>');
switch ($this->order) {
case "ASC":
switch ($counter) {
case 0:
en('<td class="onpub-highlight1" align="right">' . $this->ID . '</td>');
en('<td class="onpub-highlight1" align="left"><a href="index.php?onpub=EditSection&sectionID=' . $this->ID . '" title="Edit">' . $name . '</a></td>');
en('<td class="onpub-highlight1" align="left">' . $websiteName . '</td>');
en('<td class="onpub-highlight1" align="left">' . $created . '</td>');
break;
case 1:
en('<td class="onpub-highlight2" align="right">' . $this->ID . '</td>');
en('<td class="onpub-highlight2" align="left"><a href="index.php?onpub=EditSection&sectionID=' . $this->ID . '" title="Edit">' . $name . '</a></td>');
en('<td class="onpub-highlight2" align="left">' . $websiteName . '</td>');
en('<td class="onpub-highlight2" align="left">' . $created . '</td>');
break;
}
break;
case "DESC":
switch ($counter) {
case 0:
en('<td class="onpub-highlight1" align="right">' . $this->ID . '</td>');
en('<td class="onpub-highlight1" align="left"><a href="index.php?onpub=EditSection&sectionID=' . $this->ID . '" title="Edit">' . $name . '</a></td>');
en('<td class="onpub-highlight1" align="left">' . $websiteName . '</td>');
en('<td class="onpub-highlight1" align="left">' . $created . '</td>');
break;
case 1:
en('<td class="onpub-highlight2" align="right">' . $this->ID . '</td>');
en('<td class="onpub-highlight2" align="left"><a href="index.php?onpub=EditSection&sectionID=' . $this->ID . '" title="Edit">' . $name . '</a></td>');
en('<td class="onpub-highlight2" align="left">' . $websiteName . '</td>');
en('<td class="onpub-highlight2" align="left">' . $created . '</td>');
break;
}
break;
default:
switch ($counter) {
case 0:
en('<td class="onpub-highlight1" align="right">' . $this->ID . '</td>');
en('<td class="onpub-highlight1" align="left"><a href="index.php?onpub=EditSection&sectionID=' . $this->ID . '" title="Edit">' . $name . '</a></td>');
en('<td class="onpub-highlight1" align="left">' . $websiteName . '</td>');
en('<td class="onpub-highlight1" align="left">' . $created . '</td>');
break;
case 1:
en('<td class="onpub-highlight2" align="right">' . $this->ID . '</td>');
en('<td class="onpub-highlight2" align="left"><a href="index.php?onpub=EditSection&sectionID=' . $this->ID . '" title="Edit">' . $name . '</a></td>');
en('<td class="onpub-highlight2" align="left">' . $websiteName . '</td>');
en('<td class="onpub-highlight2" align="left">' . $created . '</td>');
break;
}
break;
}
en('</tr>');
if ($counter + 1 == 2) {
$counter = 0;
} else {
$counter++;
}
$index++;
}
en('</table>');
} else {
if ($this->keywords) {
en('<p>Your search did not yield any results. <a href="javascript:clearSearchField(); submitForm();">Display all sections</a>.</p>');
} else {
if ($this->websiteID) {
$widget = new OnpubWidgetSelectWebsite($this->pdo, $this->websiteID);
$widget->display();
br(2);
en('<p>There are 0 sections in the selected website. <a href="index.php?onpub=EditSections&websiteID=">Display all sections</a>.</p>');
} else {
en('<p>There are 0 sections in the database. <a href="index.php?onpub=NewSection">New Section</a>.</p>');
}
}
}
if ($totalSections) {
$widget = new OnpubWidgetStats($totalSections, $this->keywords, $this->websiteID, "Section", "Website");
$widget->display();
}
en('<input type="hidden" name="onpub" value="EditSections">');
en('</div>');
en('</form>');
$widget = new OnpubWidgetFooter();
$widget->display();
}