public function testWriterDb()
{
$w = new Db(new Logs());
$this->assertInstanceOf('Pop\\Log\\Writer\\Db', $w);
$l = new Logger($w);
$l->debug('Test log message');
$entries = Logs::findAll();
$this->assertEquals(1, count($entries->rows));
foreach ($entries->rows as $row) {
$e = Logs::findById($row->id);
if (isset($e->id)) {
$e->delete();
}
}
}
$page = new Pages();
$conditions = array();
if (isset($_GET['do'])) {
$do = trim($_GET['do']);
if ($do == "clear") {
$result = $pdb->Execute("truncate {$tb_prefix}logs");
}
if ($do == "del" && !empty($_GET['id'])) {
$log->del($_GET['id']);
}
if ($do == 'search') {
if (!empty($_GET['q'])) {
$conditions[] = "description like '%" . $_GET['q'] . "%'";
}
}
}
if (isset($_GET['q'])) {
$conditions[] = "description like '%" . $_GET['q'] . "%'";
}
$amount = $log->findCount(null, $conditions);
$page->setPagenav($amount);
$result = $log->findAll("id,handle_type,source_module,description,created,created AS pubdate", null, $conditions, "id DESC ", $page->firstcount, $page->displaypg);
if (!empty($result)) {
for ($i = 0; $i < count($result); $i++) {
$result[$i]['label'] = "images/e_" . $result[$i]['handle_type'] . ".gif";
$result[$i]['pubdate'] = date("Y-m-d H:i:s", $result[$i]['created']);
}
setvar("Items", $result);
}
setvar("ByPages", $page->pagenav);
template("log");
