function intSetReport(&$smarty)
{
$do_empty = TRUE;
$smarty->assign("show_report", TRUE);
$conds = collectConditions();
$report_helper = new ReportHelper();
$req = new GetCreditChanges($conds, $report_helper->getFrom(), $report_helper->getTo(), $report_helper->getOrderBy(), $report_helper->getDesc());
$resp = $req->sendAndRecv();
if ($resp->isSuccessful()) {
$result = $resp->getResult();
$report = $result["report"];
$total_rows = $result["total_rows"];
$total_per_user_credit = $result["total_per_user_credit"];
$total_admin_credit = $result["total_admin_credit"];
$do_empty = FALSE;
} else {
$resp->setErrorInSmarty($smarty);
}
if ($do_empty) {
$report = array();
$total_rows = 0;
$total_per_user_credit = 0;
$total_admin_credit = 0;
}
$smarty->assign_by_ref("report", $report);
$smarty->assign("total_rows", $total_rows);
$smarty->assign("total_per_user_credit", $total_per_user_credit);
$smarty->assign("total_admin_credit", $total_admin_credit);
}
function intDoSearch(&$smarty)
{
$user_search_helper = new ReportCollector();
$report_helper = new ReportHelper();
intSetConditions($smarty, $user_search_helper);
list($count, $user_ids, $user_infos) = searchUser($smarty, $user_search_helper->getConds(), $report_helper->getFrom(), $report_helper->getTo(), $report_helper->getOrderBy(), $report_helper->getDesc());
$smarty->assign_by_ref("user_infos", $user_infos);
$smarty->assign_by_ref("user_ids", $user_ids);
$smarty->assign("result_count", $count);
$smarty->assign("show_results", TRUE);
intShowUserSearch($smarty);
}
function intShowOnlineUsers(&$smarty)
{
$report_helper = new ReportHelper();
$req = new GetOnlineUsers($report_helper->getOrderBy(), $report_helper->getDesc());
$resp = $req->sendAndRecv();
if ($resp->isSuccessful()) {
$onlines = $resp->getResult();
} else {
$resp->setErrorInSmarty($smarty);
$onlines = array();
}
intShowOnlinesByType($smarty, $onlines);
}
function intSetReport(&$smarty)
{
$do_empty = TRUE;
if (isInRequest("show")) {
$conds = collectConditions();
$report_helper = new ReportHelper(0, 30, "add_date", TRUE);
$req = new SearchAddUserSaves($conds, $report_helper->getFrom(), $report_helper->getTo(), $report_helper->getOrderBy(), $report_helper->getDesc());
$resp = $req->sendAndRecv();
if ($resp->isSuccessful()) {
$result = $resp->getResult();
$report = $result["result"];
$total_rows = $result["total_rows"];
$do_empty = FALSE;
} else {
$resp->setErrorInSmarty($smarty);
}
}
if ($do_empty) {
$report = array();
$total_rows = 0;
}
$smarty->assign_by_ref("results", $report);
$smarty->assign("total_rows", $total_rows);
}
define('DIRECT_ACCESS_CHECK', true);
define('BASE_PATH', '../../');
require_once '../updatehelper.php';
require_once BASE_PATH . 'includes/reporthelper.class.php';
$mUpdateHelper = new UpdateHelper();
$mUpdateHelper->begin();
$mUpdateHelper->applySQLUpdateFile();
$mUpdateHelper->exitOnError();
$mUpdateHelper->printStartNextStepMsg("Start updating issues table");
$succeeded = true;
$packages = DbHelper::selectRows(TBL_REPORTS, null, REPORT_PACKAGE_NAME, REPORT_ISSUE . ', ' . REPORT_PACKAGE_NAME, REPORT_ISSUE, null, false);
foreach ($packages as $package) {
$issueId = $package[0];
$packageName = $package[1];
// skip empty package name
if (strlen($packageName) == 0) {
$mUpdateHelper->printStepMsg("Found empty package name !", true, false);
continue;
}
$appId = DbHelper::fetchOrInsertApplication($packageName, ReportHelper::formatPackageName($packageName, true));
if ($appId == -1) {
$succeeded = false;
}
$mUpdateHelper->printStepMsg("Inserted application " . $packageName . ", id is " . $appId, $appId == -1, false);
$mUpdateHelper->printStepMsg('Update issued #' . $issueId . ' with application id #' . $appId, false, false);
DbHelper::exec('UPDATE ' . TBL_ISSUES . ' SET ' . ISSUE_APP_ID . '=' . $appId . ' WHERE ' . ISSUE_ID . '=' . $issueId, false);
}
$mUpdateHelper->printEndStepMsg($succeeded, null, false);
$mUpdateHelper->printEndStepMsg(true, null, true);
$mUpdateHelper->end();
public function getFormattedAvailMemSize()
{
return ReportHelper::formatMemSize($this->available_mem_size);
}
$message = 'OK';
$chartId = $_GET['chartId'];
switch ($chartId) {
case REPORTS_PER_ANDROID_VERSION_PIE_CHART_ID:
$arr = DBHelper::selectRows(TBL_REPORTS, null, null, REPORT_ANDROID_VERSION . ', COUNT(*)', REPORT_ANDROID_VERSION, null, false);
if ($arr != null) {
$data = ChartHelper::convertMySQLArrToPieChartJSON($arr);
} else {
$message = 'No data yet recorded.|';
}
break;
case REPORTS_PER_APPLICATION_PIE_CHART_ID:
$arr = DBHelper::selectRows(TBL_REPORTS, null, null, REPORT_PACKAGE_NAME . ',COUNT(*)', REPORT_PACKAGE_NAME, null, false);
if ($arr != null) {
for ($i = 0; $i < sizeof($arr); ++$i) {
$arr[$i][0] = ReportHelper::formatPackageName($arr[$i][0], true);
}
$data = ChartHelper::convertMySQLArrToPieChartJSON($arr);
} else {
$message = 'No data yet recorded.|';
}
break;
case REPORTS_EVOLUTION_LINE_CHART_ID:
$projection = 'DATE(NOW()-INTERVAL ' . INC_VALUE . ' DAY) date, ' . 'DATE_FORMAT(DATE(NOW()-INTERVAL ' . INC_VALUE . ' DAY),"%m-%d") formatted_date, ' . '(SELECT COUNT(*) FROM ' . TBL_REPORTS . ' WHERE DATE(user_crash_date)=date) reports,' . '(SELECT COUNT(*) FROM ' . TBL_ISSUES . ' WHERE DATE(issue_datetime)=date) issues, ' . '(SELECT count(*)/DAYOFYEAR(DATE_FORMAT(' . REPORT_CRASH_DATE . ', "%Y-%m-%d")) FROM ' . TBL_REPORTS . ' WHERE DATE_FORMAT(' . REPORT_CRASH_DATE . ',"%Y")=\'' . date('Y') . '\') avg_per_day_current_year';
$orderby = 'inc ASC LIMIT 15';
$arr = DBHelper::selectRows(TBL_INCREMENTS, null, $orderby, $projection, null, null, true);
if ($arr != null && count($arr) > 0) {
$data = ChartHelper::convertMySQLArrToReportsEvolChartJSON($arr);
} else {
$message = 'No data yet recorded.|';
}
<dt>Settings System</dt><dd><br/><?php echo ReportHelper::displayObjectValuesToHTMLArray($r->settings_system, FORMAT_SETTINGS_KEY); ?> </dd> <dt>Settings Secure</dt><dd><br/><?php echo ReportHelper::displayObjectValuesToHTMLArray($r->settings_secure, FORMAT_SETTINGS_KEY); ?> </dd> </dl> </div> <div class="tab-pane" id="report-environments" > <dl> <dt>Environments</dt> <dd><br/><?php echo ReportHelper::displayObjectValuesToHTMLArray($r->environment, FORMAT_ENV_KEY); ?> </dd> </dl> </div> <div class="tab-pane" id="report-stacktrace" ><?php echo $r->getFormattedStackTrace(); ?> </div> <div class="tab-pane" id="report-logcat" ><?php echo $r->getFormattedLogCat(); ?> </div> <div class="tab-pane" id="report-eventslog" ><?php echo $r->getFormattedEventsLog();
break;
}
}
}
// if data not empty then store into DB
if (!empty($data)) {
Debug::logi("Seems to be a valid request... Try to decode JSON and save to DB.", 'REPORT');
$json = json_decode($data, true);
// check if device is in exception list
if (isset($json['device_id']) && !empty($json['device_id']) && $cfg->isInReportExceptionDevices($json['device_id'])) {
Debug::logi("Report ignored, device " . $json['device_id'] . " is in exception list.");
exit;
}
// open db connection
DBHelper::open();
$values = ReportHelper::buildMySQLValuesArr($json);
$result = DBHelper::insertReport($values);
if (!$result) {
Debug::loge('Inserting report data failed ! ' . DBHelper::getLastError(), 'REPORT');
Debug::loge('Report content ' . print_r($values, true), 'REPORT');
} else {
Debug::logi('Report inserted with success !', 'REPORT');
}
if ($cfg->sendMailOnReportReceived()) {
$package = explode('.', $json['PACKAGE_NAME']);
MailHelper::sendMail($cfg->getReportMailRecipients(), '[MABL] New ' . (isset($json['IS_SILENT']) && $json['IS_SILENT'] > 0 ? 'SILENT ' : '') . 'report received for ' . $package[count($package) - 1] . ' !', ReportHelper::createMailContent(!$result, $package, $json));
}
DBHelper::close();
} else {
Debug::loge('Invalid report request data ! ' . print_r($_REQUEST, true), 'REPORT');
}
public static function insertSale($values)
{
$error = null;
$packageName = $values[SALE_PRODUCT_ID];
$appId = DbHelper::fetchOrInsertApplication($packageName, ReportHelper::formatPackageName($packageName, true));
Debug::logd('Application id #' . $appId, 'INSERT SALE');
if ($appId > 0) {
$values[SALE_APP_ID] = $appId;
$error = self::exec('REPLACE INTO ' . TBL_SALES . ' ' . self::convertArrToInsertValues($values));
if ($error != null) {
if (self::countRows(TBL_SALES, SALE_ORDER_NUMBER . '=' . $values[SALE_ORDER_NUMBER]) == 0) {
$error = 'Row insertion check failed !';
}
}
} else {
$error = 'Retreive or insert application failed !';
}
return $error;
}
* * Copyright (c) 2010 University of Notre Dame
* *
* * This file is part of CORAL.
* *
* * CORAL is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
* *
* * CORAL is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
* *
* * You should have received a copy of the GNU General Public License along with CORAL. If not, see <http://www.gnu.org/licenses/>.
* *
* *************************************************************************************************************************
*/
session_start();
ob_start();
include_once 'directory.php';
$reportHelper = new ReportHelper();
if ($reportHelper->outputType === 'web') {
$pageTitle = $reportHelper->report->getName();
include 'templates/header.php';
} else {
if ($reportHelper->outputType === 'print') {
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CORAL Usage Statistics Reporting - <?php
echo $reportHelper->report->getName();
?>
</title>
<link rel="stylesheet" href="css/print.css" type="text/css"
if (!empty($reportId)) {
if (isset($_POST['issueFormat'])) {
require_once 'pages/issue_details_dialog_report_details.php';
} else {
require_once 'pages/report_details_dialog.php';
}
} else {
echo 'Report id is not valid !';
}
break;
//////// UPDATE ISSUES STATE
//////// UPDATE ISSUES STATE
case 'setissuesstate':
$issueIds = @$_POST['issueIds'];
$state = @$_POST['state'];
if (ReportHelper::checkState($state)) {
if (!empty($issueIds)) {
if (DBHelper::updateIssuesState(explode(',', $issueIds), $state)) {
echo 'O:';
$state = new IssueState($state);
$priority = new IssuePriority();
$label = $state->getLabel(true);
$issueIds = explode(',', $issueIds);
$sep = '';
foreach ($issueIds as $issueId) {
$res = DbHelper::selectRow(TBL_ISSUES, ISSUE_ID . '=' . $issueId, ISSUE_PRIORITY);
$priority->setPriority($res[0][0]);
echo $sep, $label, '|', IssueHelper::getHiliteBgColorClass($state, $priority), '|', strtolower($state->getName());
$sep = '||';
}
} else {
