public function goFilterAjax()
{
$validator = Validator::create(array('package' => 'min:3|max:1024', 'package_version' => 'min:3|max:255', 'brand' => 'min:3|max:255', 'os_version' => 'min:1|max:255', 'phone_model' => 'min:3|max:255', 'product' => 'min:3|max:255'));
if ($validator->failed()) {
return BootstrapUI::formResponse()->failedOn($validator);
}
$data = $validator->getParamsObj();
$params = array();
if ($data->package !== null) {
$params['package'] = $data->package;
}
if ($data->package_version !== null) {
$params['package_version'] = $data->package_version;
}
if ($data->brand !== null) {
$params['brand'] = $data->brand;
}
if ($data->os_version !== null) {
$params['os_version'] = $data->os_version;
}
if ($data->phone_model !== null) {
$params['phone_model'] = $data->phone_model;
}
if ($data->product !== null) {
$params['product'] = $data->product;
}
// the country is array
if (Input::hasPost('country')) {
$params['country'] = implode(',', array_values(Input::post('country')));
}
if (sizeof($params) == 0) {
return BootstrapUI::formResponse()->failed('You must define at least one criteria!');
}
return BootstrapUI::formResponse()->redirect(Url::href('live-feed', 'filter', $params));
}
public function indexAjax()
{
return BootstrapUI::tableRemoteResponse()->search(array('name'))->column('name')->column('total', function ($value, $row) {
return "<div class=\"text-right\">{$value}</div>";
})->column('action', function ($value, $row) {
return \Bootstrap::anchor(\Bootstrap::icon('search'), \Koldy\Url::href('reports', 'search', array('provider_id' => $row['id'])))->title('Find reports sent from this provider')->asButton()->size('xs')->color('red');
})->resultSet(Provider::resultSet())->handle();
}
public function logoutAction()
{
$user = Session::get('user');
Session::delete('user');
Session::destroy();
Log::info("User #{$user['id']} {$user['username']} logged out");
return Redirect::temporary(Url::href('index'));
}
public function indexAjax()
{
return BootstrapUI::tableRemoteResponse()->search(array('country'))->column('flag', function ($value, $row) {
return '<img src="' . \Koldy\Url::link('img/flag/' . $row['tld'] . '.png') . '" />';
})->column('tld')->column('country')->column('total', function ($value, $row) {
return "<div class=\"text-right\">{$value}</div>";
})->column('action', function ($value, $row) {
return \Bootstrap::anchor(\Bootstrap::icon('search'), \Koldy\Url::href('reports', 'search', array('country_id' => $row['id'])))->title('Find reports from this country')->asButton()->size('xs')->color('red');
})->resultSet(Country::resultSet())->handle();
}
/**
* Get reports links
* @return multitype:string
*/
public static function getReportLinks()
{
$user = Session::get('user');
$newStackTraces = isset($user['stats']) ? $user['stats']['new_stack_traces'] : 0;
if ($newStackTraces > 0) {
$newStacks = ' ' . Bootstrap::label($newStackTraces)->color('red');
} else {
$newStacks = '';
}
return array(Url::href('stack-traces') => 'Stack Traces' . $newStacks, Url::href('brands') => 'Brand reports', Url::href('packages') => 'Package reports', Url::href('os-versions') => 'OS version reports', Url::href('countries') => 'Country reports', Url::href('providers') => 'Provider reports');
}
public function findAnyAjax()
{
$stackTraceId = Input::post('stack_trace_id');
$total = Crash\Archive::count(array('stack_trace_id' => $stackTraceId));
if ($total > 0) {
$random = rand(0, $total - 1);
$records = Crash\Archive::query()->field('id')->where('stack_trace_id', $stackTraceId)->limit($random, 1)->fetchAllObj();
$id = $records[0]->id;
return BootstrapUI::buttonRemoteResponse()->redirect(\Koldy\Url::href('report', $id));
} else {
return BootstrapUI::buttonRemoteResponse()->disableButton()->text('No reports');
}
}
public function stackTracesAjax()
{
$osVersionId = (int) Input::post('os_version_id');
if ($osVersionId <= 0) {
Application::throwError(400, 'Bad request');
}
$resultSet = new Stack\Trace\ResultSet\OsVersion();
$resultSet->setOsVersionId($osVersionId);
return BootstrapUI::tableRemoteResponse()->primaryKey('stack_trace_id')->column('total', function ($value, $row) {
return \Bootstrap::label($value)->color('red');
})->column('summary', function ($value, $row) {
return "<pre class=\"text-danger\">{$value}</pre>";
})->column('action', function ($value, $row) use($osVersionId) {
return \Bootstrap::anchor(\Bootstrap::icon('search'), \Koldy\Url::href('reports', 'search', array('os_version_id' => $osVersionId, 'stack_trace_id' => $row['stack_trace_id'])))->title('Find reports with this os_version and package')->asButton()->size('xs')->color('red');
})->resultSet($resultSet)->handle();
}
public function indexAction()
{
$calculationInProgress = Status::isCalculationInProgress();
$elements = array();
$user = Session::get('user');
// Check for currently ongoing calculation
if ($calculationInProgress) {
$alert = Bootstrap::alert('<img src="' . Url::link('img/alert.png') . '" /> Data calculation is in progress! Reports might be slower then usual! Status: ' . Status::getCalculationStatus())->color('warning')->dismissable();
$elements[] = $alert;
}
$title = Bootstrap::h(1, 'Welcome ' . ($this->getUser('first_name') === null ? $this->getUser('username') : $this->getUser('first_name')))->secondaryText('Your timezone is <a href="' . Url::href('profile') . '">' . $user['timezone'] . '</a>, ' . Timezone::date($user['timezone'], 'M dS, H:i:s'));
$elements[] = Bootstrap::row()->add(12, $title);
// last reports row
$row = Bootstrap::row();
$minutes = 15;
$panel = Bootstrap::panel("Reports per minute in last {$minutes} minutes", new Chart\RequestsPerSecond($minutes))->color('blue');
$row->add(4, $panel);
$panel = Bootstrap::panel("Problematic apps in last {$minutes} minutes", new Chart\ProblematicApps($minutes))->color('blue');
$row->add(4, $panel);
$panel = Bootstrap::panel("Problematic brands in last {$minutes} minutes", new Chart\ProblematicBrands($minutes))->color('blue');
$row->add(4, $panel);
$elements[] = $row;
// quick reports
$row = Bootstrap::row();
// quick links
$listGroup = Bootstrap::listGroup();
foreach (Menu::getReportLinks() as $url => $text) {
$listGroup->addLink($url, $text);
}
$row->add(4, Bootstrap::panel('Quick links', $listGroup));
// countries
$panel = Bootstrap::panel("Reports from countries in last {$minutes} minutes", new Chart\ProblematicCountries($minutes))->color('blue');
$row->add(4, $panel);
// OS versions
$panel = Bootstrap::panel("OS and version in last {$minutes} minutes", new Chart\ProblematicOsVersions($minutes))->color('blue');
$row->add(4, $panel);
$elements[] = $row;
$dashboardDaysCacheKey = "DashboardDays-last-10-days-offset-0min";
if (!$calculationInProgress || Cache::has($dashboardDaysCacheKey)) {
// dahsboard last 10 days
$row = Bootstrap::row();
$row->add(12, Bootstrap::panel('Number of crash reports in last 10 days', new Chart\DashboardDays(10))->color('blue'));
$elements[] = $row;
}
return View::create('base')->with('title', 'Dashboard')->with('content', $elements);
}
public function searchAjax()
{
$validator = Validator::create(array('package_id' => 'required|integer', 'package_version_id' => 'required|integer', 'brand_id' => 'required|integer', 'os_version_id' => 'required|integer', 'product_id' => 'required|integer', 'model_id' => 'required|integer', 'country_id' => 'required|integer', 'provider_id' => 'required|integer', 'date_from' => null, 'date_to' => null, 'stack_trace_id' => 'required|integer'));
if ($validator->failed()) {
Application::throwError(400, 'Bad request');
} else {
$params = $validator->getParamsObj();
$prms = array();
$query = new ResultSet();
$count = new Select();
$count->from('crash_archive', 'a')->field('COUNT(*)', 'total');
$query->from('crash_archive', 'a')->field('a.id')->field('a.created_at')->leftJoin('package p', 'p.id', '=', 'a.package_id')->field('p.name', 'package_name')->leftJoin('package_version pv', 'pv.id', '=', 'a.package_version_id')->field('pv.value', 'package_version')->leftJoin('brand b', 'b.id', '=', 'a.brand_id')->field('b.name', 'brand_name')->leftJoin('stack_trace st', 'st.id', '=', 'a.stack_trace_id')->field('st.summary', 'stack_trace')->leftJoin('version v', 'v.id', '=', 'a.os_version_id')->field('v.os', 'os_name')->field('v.name', 'os_version_name')->leftJoin('country c', 'c.id', '=', 'a.country_id')->field('c.country', 'country_name')->field('c.tld', 'tld');
if ($params->date_from !== null) {
$dateFrom = new DateTime($params->date_from);
$query->where('a.created_at', '>=', Misc::utcFromUser('Y-m-d H:i:s', $dateFrom));
$count->where('a.created_at', '>=', Misc::utcFromUser('Y-m-d H:i:s', $dateFrom));
$prms['date_from'] = $params->date_from;
}
if ($params->date_to !== null) {
$dateTo = new DateTime($params->date_to);
$query->where('a.created_at', '<', Misc::utcFromUser('Y-m-d H:i:s', $dateTo));
$count->where('a.created_at', '<', Misc::utcFromUser('Y-m-d H:i:s', $dateTo));
$prms['date_to'] = $params->date_to;
}
if ($params->package_id > 0) {
$query->where('a.package_id', $params->package_id);
$count->where('a.package_id', $params->package_id);
$prms['package_id'] = $params->package_id;
}
if ($params->package_version_id > 0) {
$query->where('a.package_version_id', $params->package_version_id);
$count->where('a.package_version_id', $params->package_version_id);
$prms['package_version_id'] = $params->package_version_id;
}
if ($params->brand_id > 0) {
$query->where('a.brand_id', $params->brand_id);
$count->where('a.brand_id', $params->brand_id);
$prms['brand_id'] = $params->brand_id;
}
if ($params->os_version_id > 0) {
$query->where('a.os_version_id', $params->os_version_id);
$count->where('a.os_version_id', $params->os_version_id);
$prms['os_version_id'] = $params->os_version_id;
}
if ($params->product_id > 0) {
$query->where('a.product_id', $params->product_id);
$count->where('a.product_id', $params->product_id);
$prms['product_id'] = $params->product_id;
}
if ($params->model_id > 0) {
$query->where('a.model_id', $params->model_id);
$count->where('a.model_id', $params->model_id);
$prms['model_id'] = $params->model_id;
}
if ($params->country_id > 0) {
$query->where('a.country_id', $params->country_id);
$count->where('a.country_id', $params->country_id);
$prms['country_id'] = $params->country_id;
}
if ($params->provider_id > 0) {
$query->where('a.provider_id', $params->provider_id);
$count->where('a.provider_id', $params->provider_id);
$prms['provider_id'] = $params->provider_id;
}
if ($params->stack_trace_id > 0) {
$query->where('a.stack_trace_id', $params->stack_trace_id);
$count->where('a.stack_trace_id', $params->stack_trace_id);
$prms['stack_trace_id'] = $params->stack_trace_id;
}
if (sizeof($prms) == 1) {
// speed up count(*) ... because we have that precalculated
if (isset($prms['stack_trace_id'])) {
$count = new Select();
$count->from('stack_trace')->field('total')->where('id', $prms['stack_trace_id']);
} else {
if (isset($prms['brand_id'])) {
$count = new Select();
$count->from('brand')->field('total')->where('id', $prms['brand_id']);
} else {
if (isset($prms['package_id'])) {
$count = new Select();
$count->from('package')->field('total')->where('id', $prms['package_id']);
} else {
if (isset($prms['package_version_id'])) {
$count = new Select();
$count->from('package_version')->field('total')->where('id', $prms['package_version_id']);
} else {
if (isset($prms['os_version_id'])) {
$count = new Select();
$count->from('version')->field('total')->where('id', $prms['os_version_id']);
} else {
if (isset($prms['country_id'])) {
$count = new Select();
$count->from('country')->field('total')->where('id', $prms['country_id']);
} else {
if (isset($prms['provider_id'])) {
$count = new Select();
$count->from('provider')->field('total')->where('id', $prms['provider_id']);
} else {
if (isset($prms['model_id'])) {
$count = new Select();
$count->from('phone_model')->field('total')->where('id', $prms['model_id']);
}
}
}
}
}
}
}
}
}
$query->setCountQuery($count);
return BootstrapUI::tableRemoteResponse()->column('country_name', function ($value, $row) {
if ($row['tld'] !== null) {
$country = \Koldy\Html::quotes($row['country_name']);
return '<img src="' . \Koldy\Url::link("img/flag/{$row['tld']}.png") . '" title="' . $country . '" />';
} else {
return '';
}
})->column('created_at', function ($value, $row) {
$user = \Koldy\Session::get('user');
return \Koldy\Timezone::date($user['timezone'], 'd.m.Y', strtotime($value)) . '<br/>' . \Koldy\Timezone::date($user['timezone'], 'H:i:s', strtotime($value));
})->column('package_name', function ($value, $row) {
$html = $value;
$html .= "<details><summary>View stack trace summary</summary><pre class=\"text-danger\">{$row['stack_trace']}</pre></details>";
return $html;
})->column('package_version')->column('brand_name')->column('os_version_name', function ($value, $row) {
return "{$row['os_name']} {$row['os_version_name']}";
})->column('country')->column('action', function ($value, $row) {
return \Bootstrap::anchor(\Bootstrap::icon('eye-open'), \Koldy\Url::href('report', $row['id']))->title('View report')->size('xs');
})->resultSet($query)->handle();
}
}
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();
}
/**
* Actually add new user into database
*/
public function addUserAjax()
{
$validator = Validator::create(array('id' => 'is:0', 'username' => "required|min:2|max:32|unique:\\User,username", 'first_name' => 'max:255', 'last_name' => 'max:255', 'pass' => 'required|min:5|max:255', 'pass2' => 'identical:pass', 'account_type' => 'required', 'timezone' => 'required'));
if ($validator->failed()) {
return BootstrapUI::formResponse()->failedOn($validator);
}
$data = $validator->getParams();
unset($data['id'], $data['pass2']);
$data['pass'] = md5($data['pass']);
$user = User::create($data);
if ($user === false) {
Log::error('Can not create new user');
return BootstrapUI::formResponse()->failed('Something went wrong');
}
return BootstrapUI::formResponse()->redirect(Url::href('system', 'users'));
}
/**
* Clear the cache
* @return \Koldy\Redirect
* @link /report/clear-cache/12324324
*/
public function clearCacheAjax()
{
$id = Url::getVar(2);
$cacheKey = "report-{$id}";
Cache::delete($cacheKey);
return Redirect::href('report', $id);
}
