/**
* Handle the request
* @return \Bootstrap\Response\TableRemote
*/
public function handle()
{
$this->params = Input::requireParams('page', 'limit', 'field', 'dir');
$page = (int) $this->params->page;
if ($page < 1) {
$page = 1;
}
$limitPerPage = (int) $this->params->limit;
$field = (string) trim($this->params->field);
$this->resultSet->page($page, $limitPerPage)->orderBy($field, $this->params->dir);
// check if this is request with search
$search = trim((string) \Koldy\Input::post('search'));
if ($search != '') {
$fields = $this->searchFields !== null ? $this->searchFields : $this->columns;
foreach ($fields as $field) {
$this->resultSet->orWhere($field, "%{$search}%", null, 'LIKE');
}
}
\Log::debug($this->resultSet);
// get the rows of data
$this->data = $this->resultSet->fetch();
if (is_array($this->data)) {
$this->tbody = array();
foreach ($this->data as $row) {
$this->tbody[] = "<tr data-id=\"{$row[$this->primaryKey]}\">";
foreach ($this->columns as $column) {
$value = isset($row[$column]) ? $row[$column] : null;
if (isset($this->columnValueModifier[$column])) {
$fn = $this->columnValueModifier[$column];
$fnResult = $fn($value, $row);
$this->tbody[] = "<td>{$fnResult}</td>";
} else {
$value = strip_tags(stripslashes($value));
$this->tbody[] = "<td>{$value}</td>";
}
}
$this->tbody[] = '</tr>';
}
$this->tbody = implode("\n", $this->tbody);
}
// get the totals
$total = (int) $this->resultSet->count();
// get the info
if ($total > 0) {
$start = ($this->params->page - 1) * $this->params->limit + 1;
$end = $start + $this->params->limit;
if ($end > $total) {
$end = $total;
}
/*$this->info = __('table.records.info', 'Showing {from} - {to} of {total}',
'The info below remote table about how many rows are visible. Variables are {from}, {to} and {total}',
array('from' => $start, 'to' => $end, 'total' => $total)
);*/
$this->info = "Showing {$start} - {$end} of {$total}";
} else {
$this->info = 'No results';
}
// create pagination
$this->pagination = new \Koldy\Pagination($this->params->page, $total);
$this->pagination->setItemsPerPage(10)->setCssDefault('btn btn-primary btn-xs')->setCssSelected('btn-info');
return $this;
}
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();
}
}
/**
* Get the ResultSet object of this model
*
* @return \Koldy\Db\ResultSet
*/
public static function resultSet()
{
$rs = new ResultSet(static::getTableName());
$rs->setConnection(static::$connection);
return $rs;
}
