public function __construct($stackTraceId, $days)
{
$this->title("Last {$days} days analysis")->titleOnYAxis('count per day');
$offset = \Misc::getUserTimezoneOffsetInMinutes();
$cacheKey = "stacks-{$stackTraceId}-per-last-{$days}-days-offset-{$offset}min";
$from = new \DateTime(\Misc::userDate('Y-m-d 00:00:00'));
$from->modify("-{$days} day");
$records = Cache::getOrSet($cacheKey, function () use($from, $stackTraceId, $days, $offset) {
$operator = $offset < 0 ? '-' : '+';
$offsetAbs = abs($offset);
$today = new \DateTime(\Misc::userDate('Y-m-d 00:00:00'));
$query = \Crash\Archive::query()->field("DATE(created_at + INTERVAL {$offset} MINUTE)", 'time')->field('COUNT(*)', 'total')->where('stack_trace_id', $stackTraceId)->where('created_at', '>=', \Db::expr("'{$from->format('Y-m-d H:i:s')}' {$operator} INTERVAL {$offsetAbs} MINUTE"))->groupBy(1)->orderBy(1);
return $query->fetchAllObj();
}, 3720 - date('i') * 60 + date('s'));
$data = array();
foreach ($records as $r) {
$data[$r->time] = $r->total;
}
$serieData = array();
$startMinute = (int) $from->format('i');
for ($day = $from, $today = \Misc::userDate('Y-m-d'); $day->format('Y-m-d') <= $today; $day->modify('+1 day')) {
$date = $day->format('Y-m-d');
$serieData[$date] = isset($data[$date]) ? (int) $data[$date] : 0;
$this->addOnXAxis($day->format('jS'));
}
$this->addSerie('requests', array_values($serieData));
}
public function versionsAjax()
{
$packageId = (int) Input::post('package_id');
if ($packageId <= 0) {
Application::throwError(400, 'Bad request');
}
$resultSet = new Package\ResultSet\Version();
$resultSet->setPackageId($packageId, Input::post('last'));
$timeFrom = $resultSet->getFromTime();
return BootstrapUI::tableRemoteResponse()->primaryKey('package_version_id')->column('total', function ($value, $row) {
return \Bootstrap::label($value)->color('red');
})->column('name')->column('action', function ($value, $row) use($packageId, $timeFrom) {
return \Bootstrap::anchor(\Bootstrap::icon('search'), \Koldy\Url::href('reports', 'search', array('package_version_id' => $row['package_version_id'], 'date_from' => \Misc::userDate('Y-m-d H:i:s', strtotime($timeFrom)))))->title('Find reports with this package version')->asButton()->size('xs')->color('red');
})->resultSet($resultSet)->handle();
}
/**
* Show the page with user edit form
*/
public function editUserAction()
{
$id = (int) Url::getVar(2);
$user = User::fetchOne($id);
if ($user === false) {
Application::throwError(404, "Can not find user");
}
$title = "Edit user {$user->username}";
$elements = array(\Bootstrap::h(1, $title), \Bootstrap::panel("User #{$id}", $this->getUserForm($user->getData()))->color('blue'));
if ($user->last_login !== null) {
$info = \Bootstrap::alert('User logged in last time at ' . Misc::userDate('Y-m-d H:i:s', $user->last_login) . " from {$user->last_login_ip}")->color('info');
$elements[] = $info;
}
$content[] = Bootstrap::row()->add(8, $elements, 2);
return View::create('base')->with('title', $title)->with('content', $content);
}
public function __construct($days)
{
$user = Session::get('user');
$this->title("Crash reports per days (UTC time)")->titleOnYAxis('number of requests')->tooltipShared();
// $offset = \Misc::getUserTimezoneOffsetInMinutes();
$offset = 0;
$cacheKey = "DashboardDays-last-{$days}-days-offset-{$offset}min";
$data = Cache::getOrSet($cacheKey, function () use($days, $offset) {
$datetime = new \DateTime(\Misc::userDate('Y-m-d 00:00:00'));
$datetime->modify("-{$days} day");
$query = new Select();
$query->from('crash_archive', 'a')->field('DATE(a.created_at)', 'time')->field('COUNT(*)', 'total')->where('a.created_at', '>=', $datetime->format('Y-m-d H:i:s'))->orderBy(1, 'asc')->groupBy(1);
$records = $query->fetchAllObj();
$data = array();
foreach ($records as $r) {
$data[$r->time] = (int) $r->total;
}
return $data;
}, 3720 - date('i') * 60 + date('s'));
// get data in last 30 days per package per date
/*
$query = new Select();
$query
->from('crash_archive', 'a')
->field('DATE(a.created_at)', 'date')
->field('a.package_id')
->field('COUNT(*)', 'total')
->innerJoin('package p', 'p.id', '=', 'a.package_id')
->field('p.name', 'package_name')
->where('a.created_at', '>=', $datetime->format('Y-m-d H:i:s'))
->groupBy(2)
->groupBy(1)
->orderBy(1)
->orderBy(2)
->orderBy(4, 'DESC');
$records = $query->fetchAllObj();
$apps = $appName = array();
foreach ($records as $r) {
if (!isset($apps[$r->package_id])) {
$apps[$r->package_id] = array();
$appName[$r->package_id] = $r->package_name;
}
$apps[$r->package_id][$r->date] = (int) $r->total;
}
*/
$start = new \DateTime(gmdate('Y-m-d'));
$days--;
$start->modify("-{$days} day");
$serieData = $appsData = array();
$today = \Misc::userDate('Y-m-d');
do {
$pointer = $start->format('Y-m-d');
$serieData[$pointer] = isset($data[$pointer]) ? $data[$pointer] : 0;
// foreach ($apps as $packageId => $dates) {
// if (!isset($apps[$packageId][$pointer])) {
// $apps[$packageId][$pointer] = 0;
// }
// }
$start->modify('+1 day');
} while ($pointer < $today);
$this->addSerie('total requests', array_values($serieData));
/*foreach ($apps as $packageId => $dates) {
if (sizeof($this->series) < 6) {
ksort($dates);
$this->addSerie($appName[$packageId], array_values($dates));
}
}*/
foreach (array_keys($serieData) as $key) {
$date = new \DateTime($key);
$this->addOnXAxis($date->format('jS'));
}
}
public function indexAjax()
{
$where = array();
$bindings = array();
$params = Input::requireParams('package', 'package_version', 'brand', 'phone_model', 'product', 'os_version', 'country');
// package
if ($params->package !== '') {
$a = explode(',', $params->package);
$vals = array();
foreach ($a as $val) {
$vals[] = "s.package_name = ?";
$bindings[] = $val;
}
$vals = '(' . implode(' OR ', $vals) . ')';
$where[] = $vals;
}
// package_version
if ($params->package_version !== '') {
$a = explode(',', $params->package_version);
$vals = array();
foreach ($a as $val) {
$vals[] = "s.app_version_name = ?";
$bindings[] = $val;
}
$vals = '(' . implode(' OR ', $vals) . ')';
$where[] = $vals;
}
// brand
if ($params->brand !== '') {
$a = explode(',', $params->brand);
$vals = array();
foreach ($a as $val) {
$vals[] = "s.brand = ?";
$bindings[] = $val;
}
$vals = '(' . implode(' OR ', $vals) . ')';
$where[] = $vals;
}
// phone_model
if ($params->phone_model !== '') {
$a = explode(',', $params->phone_model);
$vals = array();
foreach ($a as $val) {
$vals[] = "s.phone_model = ?";
$bindings[] = $val;
}
$vals = '(' . implode(' OR ', $vals) . ')';
$where[] = $vals;
}
// product
if ($params->product !== '') {
$a = explode(',', $params->product);
$vals = array();
foreach ($a as $val) {
$vals[] = "s.product = ?";
$bindings[] = $val;
}
$vals = '(' . implode(' OR ', $vals) . ')';
$where[] = $vals;
}
// os_version
if ($params->os_version !== '') {
$a = explode(',', $params->os_version);
$vals = array();
foreach ($a as $val) {
$vals[] = "s.android_version = ?";
$bindings[] = $val;
}
$vals = '(' . implode(' OR ', $vals) . ')';
$where[] = $vals;
}
// country
if ($params->country !== '') {
$a = explode(',', $params->country);
$vals = array();
foreach ($a as $val) {
$vals[] = "s.country = ?";
$bindings[] = $val;
}
$vals = '(' . implode(' OR ', $vals) . ')';
$where[] = $vals;
}
if (sizeof($where) == 0) {
$where = '1';
} else {
$where = implode(' AND ', $where);
}
$query = "\n\t\t\tSELECT\n\t\t\t\ts.id,\n\t\t\t\ts.created_at,\n\t\t\t\ts.package_name,\n\t\t\t\ts.app_version_name as package_version,\n\t\t\t\ts.brand,\n\t\t\t\ts.phone_model,\n\t\t\t\ts.product,\n\t\t\t\ts.android_version,\n\t\t\t\ts.country,\n\t\t\t\ts.stack_trace\n\t\t\tFROM\n\t\t\t\tcrash_submit s\n\t\t\tWHERE\n\t\t\t\t{$where}\n\t\t\tORDER BY s.created_at DESC\n\t\t\tLIMIT 0, 50\n\t\t";
$records = Db::getAdapter()->query($query, $bindings);
$data = array();
foreach ($records as $r) {
if ($r->stack_trace !== null) {
$lines = explode("\n", $r->stack_trace);
$stackTraceSummary = array();
$more = 0;
foreach ($lines as $line) {
$ord = ord(substr($line, 0, 1));
if ($ord >= 65 && $ord <= 90 || $ord >= 97 && $ord <= 122) {
if (sizeof($stackTraceSummary) < 2) {
$stackTraceSummary[] = trim($line);
} else {
$more++;
}
}
}
if ($more > 0) {
$stackTraceSummary[] = "... and {$more} more line(s)";
}
$stackTraceSummary = implode("\n", $stackTraceSummary);
} else {
$stackTraceSummary = null;
}
$data[] = array('id' => (int) $r->id, 'created_at' => Misc::userDate('H:i:s', $r->created_at), 'package' => "{$r->package_name} {$r->package_version}", 'device' => "{$r->brand}<br/>{$r->phone_model}", 'product' => $r->phone_model != $r->product ? $r->product : null, 'os' => "Android {$r->android_version}", 'country' => $r->country, 'stack_trace' => $stackTraceSummary);
}
return Json::create(array('success' => true, 'time' => Misc::userDate('Y-m-d H:i:s'), 'data' => $data));
}
public function viewAction()
{
$id = Url::getVar(1);
// todo: ubaciti ovo u cache i odatle cupat van
$cacheKey = "report-{$id}";
$crash = CrashArchive::fetchOne($id);
if ($crash === false) {
Application::throwError(404, 'Can not find crash report ' . $id);
}
$title = "Crash Report #{$id}";
$content = array();
$panel = Bootstrap::panel($title)->color('blue')->addHeaderElement(Bootstrap::button('Back')->setAttribute('onclick', 'window.history.back()')->color('red')->size('xs'));
$table = Bootstrap::table();
$table->column('id', '')->column('value', '');
// time
$table->row(array('id' => 'time', 'value' => Misc::userDate('Y-m-d H:i:s', $crash->created_at) . ' (' . $this->user['timezone'] . ')'));
// package
$e = $crash->getPackage();
$v = $crash->getPackageVersion();
$table->row(array('id' => 'package and version', 'value' => implode(' ', array($e !== null ? "{$this->getSearchLink('package_id', $e->id, $e->name)} {$this->getLabel($e->total)}" : 'unknown', $v !== null ? "{$this->getSearchLink('package_version_id', $v->id, $v->value)} {$this->getLabel($v->total)}" : 'unknown'))));
// device
$value = '';
$e = $crash->getBrand();
if ($e === null) {
$value .= 'unknown brand<br/>';
} else {
$value .= "{$this->getSearchLink('brand_id', $e->id, $e->name)} {$this->getLabel($e->total)}<br/>";
}
$e = $crash->getPhoneModel();
if ($e === null) {
$value .= 'unknown phone model<br/>';
} else {
$value .= "{$this->getSearchLink('model_id', $e->id, $e->name)} {$this->getLabel($e->total)}<br/>";
}
$table->row(array('id' => 'device', 'value' => substr($value, 0, -5)));
// product
$e = $crash->getProduct();
if ($e !== null) {
$table->row(array('id' => 'product name', 'value' => "{$this->getSearchLink('product_id', $e->id, $e->name)} {$this->getLabel($e->total)}"));
}
// os
$e = $crash->getOsVersion();
$table->row(array('id' => 'OS', 'value' => $e === null ? 'unknown' : "{$this->getSearchLink('os_version_id', $e->id, "{$e->os} {$e->name}")} {$this->getLabel($e->total)}"));
// user comment
if ($crash->user_comment !== null && trim($crash->user_comment) != '') {
$table->row(array('id' => 'user comment', 'value' => $crash->user_comment));
}
// user email
if ($crash->user_email !== null && trim($crash->user_email) != '') {
$table->row(array('id' => 'user email', 'value' => $crash->user_email));
}
// app lifetime
if ($crash->user_app_start_date !== null && $crash->user_crash_date !== null) {
$table->row(array('id' => 'app lifetime', 'value' => "{$crash->user_app_start_date}<br/>{$crash->user_crash_date} (duration: {$this->duration($crash->user_app_start_date, $crash->user_crash_date)})"));
}
// memory usage
$table->row(array('id' => 'available / total memory size', 'value' => Convert::bytesToString($crash->available_mem_size) . ' / ' . Convert::bytesToString($crash->total_mem_size)));
// country
if ($crash->country_id !== null) {
$country = Country::fetchOne($crash->country_id);
$table->row(array('id' => 'country', 'value' => "<img src=\"" . Url::link("img/flag/{$country->tld}.png") . "\" /> <a href=\"" . Url::href('reports', 'search', array('country_id' => $crash->country_id)) . "\">{$country->country} (" . strtoupper($country->tld) . ")</a> " . Bootstrap::label($country->total)->color('red')));
}
// provider
if ($crash->provider_id !== null) {
$e = Provider::fetchOne($crash->provider_id);
$table->row(array('id' => 'internet provider', 'value' => "{$this->getSearchLink('provider_id', $e->id, $e->name)} {$this->getLabel($e->total)}"));
}
$metas = $crash->getMetas();
$toTabs = array();
foreach ($metas as $key => $value) {
if ($key != 'stack_trace') {
if (strpos(trim($value), "\n") === false) {
$table->row(array('id' => str_replace('_', ' ', $key), 'value' => trim($value) == '' ? '<em>empty</em>' : $value));
} else {
$toTabs[] = $key;
}
}
}
$toTabsUnknown = array();
$unknownMetas = $crash->getUnknownMetas();
foreach ($unknownMetas as $key => $value) {
if (strpos(trim($value), "\n") === false) {
$table->row(array('id' => str_replace('_', ' ', $key), 'value' => (trim($value) == '' ? '<em>empty</em>' : $value) . ' ' . Bootstrap::label('unknown meta')->color('lightblue')));
} else {
$toTabsUnknown[] = $key;
}
}
if ($crash->stack_trace_id !== null) {
$table->row(array('id' => 'find reports with this stack trace', 'value' => Bootstrap::anchor(\Bootstrap::icon('search'), Url::href('reports', 'search', array('stack_trace_id' => $crash->stack_trace_id)))->asButton()->color('red')->size('xs')));
}
$panel->content($table);
$content[] = Bootstrap::row()->add(12, $panel);
$tabs = Bootstrap::nav();
if (isset($metas['stack_trace'])) {
$tabs->addLink('stack trace', "<pre class=\"text-danger\">{$metas['stack_trace']}</pre>");
} else {
if ($crash->stack_trace_id !== null) {
$stackTrace = Stack\Trace::fetchOne($crash->stack_trace_id);
$tabs->addLink('stack trace summary', "<pre class=\"text-danger\">{$stackTrace->summary}</pre>");
}
}
if (sizeof($toTabs) > 0) {
foreach ($toTabs as $key) {
$tabs->addLink(str_replace('_', ' ', $key), "<pre>{$metas[$key]}</pre>");
}
}
if (sizeof($toTabsUnknown) > 0) {
foreach ($toTabsUnknown as $key) {
$tabs->addLink(str_replace('_', ' ', $key) . ' ' . Bootstrap::label('?')->color('lightblue'), "<pre>{$unknownMetas[$key]}</pre>");
}
}
if ($tabs->count() > 0) {
$content[] = Bootstrap::row()->add(12, $tabs);
}
if ($crash->stack_trace_id !== null) {
$content[] = Bootstrap::row()->add(12, Bootstrap::panel('This error count per day', new Chart\StackTracesPerDay($crash->stack_trace_id, 30))->color('red'));
}
return View::create('base')->with('title', $title)->with('content', $content);
}
