<?php
include 'classes/database.php';
include 'classes/table.php';
include 'classes/variable.php';
include 'include/header.php';
?>
<br />
Databases:
<table>
<?php
//show orphans
//databases
$orphan_database_revisions = Database::get_orphan_revisions();
while ($orphan_database_revision = mysqli_fetch_assoc($orphan_database_revisions)) {
?>
<tr>
<td>
<div id="orphan_database_revision_<?php
echo $orphan_database_revision['Database_Revision_ID'];
?>
_entry">
<a href="javascript:;" onclick="$('#orphan_database_revision_<?php
echo $orphan_database_revision['Database_Revision_ID'];
?>
').slideToggle('slow');">
<?php
echo $orphan_database_revision['Database_Name'];
?>
</a>
/**
* Builds the widget.
*
* Creates a table of content needing to be approved.
*/
public function buildWidget()
{
?>
<div class="widget">
<div class="widget-header">
<i class="<?php
echo $this->widget_icon_type;
?>
"></i>
<h3><?php
echo $this->widget_item_type;
?>
</h3>
</div>
<div class="widget-content">
<table class="table table-striped table-bordered">
<thead>
<tr>
<td>Name</td>
<td>Content Author</td>
<td>Date Created</td>
<td></td>
</tr>
</thead>
<tbody>
<?php
if ($this->widget_item_type == "database") {
$orphan_revisions = Database::get_orphan_revisions();
while ($orphan_revision = mysqli_fetch_assoc($orphan_revisions)) {
?>
<tr>
<td>
<a href="<?php
echo $orphan_revision['Database_Revision_ID'];
?>
"><?php
echo $orphan_revision['Database_Name'];
?>
</a>
</td>
<td>
<?php
echo $orphan_revision['Creator'];
?>
</td>
<td>
<?php
echo $orphan_revision['Last_Updated'];
?>
</td>
<td class="action-td">
<a href="javascript:;" class="btn btn-small btn-warning">
<i class="icon-ok"></i>
</a>
<a href="javascript:;" class="btn btn-small">
<i class="icon-remove"></i>
</a>
</td>
</tr>
<?php
}
} elseif ($this->widget_item_type == "table") {
$orphan_revisions = Table::get_orphan_revisions();
while ($orphan_revision = mysqli_fetch_assoc($orphan_revisions)) {
?>
<tr>
<td>
<a href="<?php
echo $orphan_revision['Table_Revision_ID'];
?>
"><?php
echo $orphan_revision['Table_Name'];
?>
</a>
</td>
<td>
<?php
echo $orphan_revision['Creator'];
?>
</td>
<td>
<?php
echo $orphan_revision['Date_Created'];
?>
</td>
<td class="action-td">
<a href="javascript:;" class="btn btn-small btn-warning">
<i class="icon-ok"></i>
</a>
<a href="javascript:;" class="btn btn-small">
<i class="icon-remove"></i>
</a>
</td>
</tr>
<?php
}
} elseif ($this->widget_item_type == "variable") {
$orphan_revisions = Variable::get_orphan_revisions();
while ($orphan_revision = mysqli_fetch_assoc($orphan_revisions)) {
?>
<tr>
<td>
<a href="<?php
echo $orphan_revision['Variable_Revision_ID'];
?>
"><?php
echo $orphan_revision['Variable_Name'];
?>
</a>
</td>
<td>
<?php
echo $orphan_revision['Creator'];
?>
</td>
<td>
<?php
echo $orphan_revision['Date_Created'];
?>
</td>
<td class="action-td">
<a href="javascript:;" class="btn btn-small btn-warning">
<i class="icon-ok"></i>
</a>
<a href="javascript:;" class="btn btn-small">
<i class="icon-remove"></i>
</a>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
<?php
}
