/**
* Write an entry to the event log.
*
* @param string $message The message
* @param string $severity The severity
* @param string $type The type
* @param string $module The module
* @param mixed $data The data
* @return object LogEntry The inserted LogEntry object
*/
public static function log($message, $severity = 'info', $type = 'default', $module = null, $data = null)
{
$module = self::get_module($module);
$log = new LogEntry(array('message' => $message, 'severity' => $severity, 'module' => $module, 'type' => $type, 'data' => $data, 'ip' => Utils::get_ip()));
$user = User::identify();
if ($user->loggedin) {
$log->user_id = $user->id;
}
$log->insert();
return $log;
}
public function deleteBox($barcode)
{
$this->connection->query("begin;");
$query = "\n\t\tSELECT COUNT(a_barcode)\n\t\tFROM assets\n\t\tWHERE a_box = {$barcode};";
$this->connection->query($query);
$row = $this->connection->fetch_row();
if ($row[0] != 0) {
echo "Cannot delete an Assest Type that is currently being used by assets<br><br>";
} else {
$query = "DELETE FROM boxes WHERE b_barcode = {$barcode};";
$this->connection->query($query);
//log away
$user = new User();
$logEntry = new LogEntry($this->connection);
$logEntry->setBarcode($barcode);
$logEntry->setPerson($user->get_Username());
$logEntry->setType("Box Deleted");
$logEntry->insert();
}
$this->connection->query("commit;");
}
/**
* Limit the number of log entries returned
* - limit => the maximum number of posts to return, implicitly set for many queries
* - nolimit => do not implicitly set limit
*/
public function test_get_logs_with_limit()
{
for ($i = 1; $i <= 5; $i++) {
$entry = new LogEntry(array('user_id' => $this->user->id, 'type' => 'default', 'severity' => 'err', 'module' => 'habari', 'message' => 'Event message from test_logs_with_limit' . $i));
$entry->insert();
}
$count_entries = EventLog::get(array('count' => 1, 'limit' => 2, 'user_id' => $this->user->id));
$this->assert_equal($count_entries, 5, "LIMIT with a COUNT is pointless - COUNTing anything should return a single value.");
$entries = EventLog::get(array('limit' => 2, 'user_id' => $this->user->id));
$this->assert_equal(count($entries), 2);
$count_entries = EventLog::get(array('count' => 1, 'nolimit' => 1, 'user_id' => $this->user->id));
$this->assert_true($count_entries > 2);
$entries = EventLog::get(array('nolimit' => 1, 'user_id' => $this->user->id));
$this->assert_true(count($entries) > 2);
// OFFSET based on page number (and limit)
$entries = EventLog::get(array('limit' => 2, 'index' => 2, 'user_id' => $this->user->id));
$this->assert_equal(count($entries), 2);
$entries = EventLog::get(array('limit' => 2, 'index' => 3, 'user_id' => $this->user->id));
$this->assert_equal(count($entries), 1);
}
public function deleteAsset($barcode)
{
$this->connection->query("begin;");
//log this sad event
$user = new User();
$logEntry = new LogEntry($this->connection);
$logEntry->setBarcode($barcode);
$logEntry->setPerson($user->get_Username());
$logEntry->setType("Asset Deleted");
$logEntry->insert();
$query = "DELETE FROM assets WHERE a_barcode = '{$barcode}'";
$this->connection->query($query);
$this->connection->query("commit;");
}
