<?php defined('DIRECT_ACCESS_CHECK') or die('DIRECT ACCESS NOT ALLOWED');

/**

* Copyright (c) 2013 EIRL DEVAUX J. - Medialoha.

* All rights reserved. This program and the accompanying materials

* are made available under the terms of the GNU Public License v3.0

* which accompanies this distribution, and is available at

* http://www.gnu.org/licenses/gpl.html

*

* Contributors:

* EIRL DEVAUX J. - Medialoha - initial API and implementation

*/

$mNavCtl = new NavigationController();

$mCfg = CfgHelper::getInstance();

$action = $_REQUEST['a'];

if (isset($_REQUEST['ctl'])) {

require_once(BASE_PATH.'controllers/'.$_REQUEST['ctl'].'controller.php');

exit;

}

switch ($action) {

//////// LOGOUT

case 'logout' :

unset($_SESSION['LOGGEDIN']);

unset($_SESSION[USER_ID]);

unset($_SESSION[USER_NAME]);

unset($_SESSION[USER_EMAIL]);

header('Location:index.php');

break;

//////// CREATE HTACCESS AND HTPASSWD FILES

case 'createHtFiles' :

$error = null;

$reportDir = 'report/';

if ($mCfg->isReportBasicAuthEnabled() && $mCfg->getBasicAuthMethod()==AUTH_METHOD_HTACCESS) {

require_once('libs/PHP-Htpasswd/Htpasswd.php');

if (!is_writeable($reportDir)) {

$error = 'Report directory is not writeable !';

} else {

$content = 'AuthUserFile "'.getcwd().'/report/.htpasswd"'."\n".

'AuthName "MAB-LAB Report Script"'."\n".

'AuthType Basic'."\n".

'<Files "report.php" >'."\n".

"\t".'require valid-user'."\n".

'</Files>';

if (file_put_contents($reportDir.'.htaccess', $content)) {

$account = $mCfg->getBasicAuthAccount();

$password = Htpasswd::encryptPassword($account->password, Htpasswd::ENCTYPE_APR_MD5);

$content = $account->login.':'.$password."\n";

if (!file_put_contents($reportDir.'.htpasswd', $content)) {

$error = 'An error occured while trying to write .htpasswd file ! .htaccess file was removed.';

@unlink($reportDir.'.htaccess');

}

} else { $error = 'An error occured while trying to write .htaccess file !'; }

}

} else { $error = 'Your configuration is not properly set !'; }

if ($error==null) {

Helper::pushAlert(ALERT_SUCCESS, 'Files created successfully !');

} else { Helper::pushAlert(ALERT_ERROR, $error); }

header('Location:index.php?p='.PAGE_ID_CONFIG);

break;

//////// DELETE HTACCESS AND HTPASSWD FILES

case 'deleteHtFiles' :

$error = null;

$reportDir = 'report/';

if (@file_exists($reportDir.'.htaccess') && !@unlink($reportDir.'.htaccess')) {

$error = '<p>Unable to delete .htaccess file ! You should delete it by hand : <em>'.getcwd().'/'.$reportDir.'.htaccess</em></p>';

}

if (@file_exists($reportDir.'.htpasswd') && !@unlink($reportDir.'.htpasswd')) {

$error .= '<p>Unable to delete .htpasswd file ! You should delete it by hand : <em>'.getcwd().'/'.$reportDir.'.htpasswd</em></p>';

}

if ($error==null) {

Helper::pushAlert(ALERT_SUCCESS, 'Files deleted successfully !');

} else { Helper::pushAlert(ALERT_ERROR, $error); }

header('Location:index.php?p='.PAGE_ID_CONFIG);

break;

//////// UPDATE CONFIG

case 'updateconfig' :

require_once('includes/currency.class.php');

$tmpCfg = array();

foreach ($_POST as $k=>$v) {

if (strpos('in-', $k, 0)==0) {

$key = str_replace('-', '.', substr($k, 3));

if (!empty($key)) {

// check for boolean value

if (strcmp($key, 'report.packagename.shrink')==0 || strcmp($key, 'report.sendmail')==0) {

$tmpCfg[$key] = $v=='1'?true:false;

} else if (strcmp($key, 'report.exception.devices')==0) {

if (!empty($v)) {

$tmpCfg[$key] = '"'.str_replace(PHP_EOL, '", "' , $v).'"';

} else { $tmpCfg[$key] = ''; }

} else { $tmpCfg[$key] = $v; }

}

}

}

//Debug::logd($_POST);

// http auth enabled

if (array_key_exists('report-basicauth', $_POST)) {

$tmpCfg['report.basicauth'] = true;

// check report basic auth account

$account = array(

'login'=>$_POST['report-basicauth-login'],

'password'=>$_POST['report-basicauth-password'],

'clear'=>(!array_key_exists('report-basicauth-obfuscate', $_POST))

);

$tmpCfg['report.basicauth.accounts'] = array($account);

$tmpCfg['report.basicauth.method'] = intval($_POST['report-basicauth-method']);

} else { $tmpCfg['report.basicauth'] = false; }

$error = CfgHelper::writeConfig($tmpCfg);

if ($error==null) {

$mCfg = CfgHelper::init(true);

// check if currency changed

if (array_key_exists('currency-update-db', $_POST)==1) {

$currency = new Currency($mCfg->getCurrencyCode());

DbHelper::updateSalesCurrency($currency);

}

Helper::pushAlert(ALERT_SUCCESS, 'Configuration saved.');

} else { Helper::pushAlert(ALERT_ERROR, $error); }

header('Location:index.php?p='.PAGE_ID_CONFIG);

break;

//////// DEL USER

case 'deluser' :

$userId = @$_POST['userId'];

if (!empty($userId)) {

if (DBHelper::countRows(TBL_USERS)>1) {

if (DBHelper::deleteUsers($userId))

Helper::pushAlert(ALERT_SUCCESS, 'User deleted with success !');

else

Helper::pushAlert(ALERT_ERROR, 'Unable to delete user with id #'.$userId);

} else { Helper::pushAlert(ALERT_ERROR, 'You must keep at least one user !!!'); }

} else { Helper::pushAlert(ALERT_ERROR, 'User id is not valid !'); }

header('Location:index.php?p='.PAGE_ID_USERS);

break;

//////// EDIT USER

case 'edituser' :

$u = array('user_id'=>@$_POST['user_id'], 'user_name'=>@$_POST['user_name'], 'user_password'=>@$_POST['user_password'], 'user_email'=>@$_POST['user_email']);

$error = null;

if (!empty($u['user_name'])) {

// if new user then password must be set

if (!($u['user_id']>0) && empty($u['user_password'])) {

$error = 'You must specify a password !';

} else {

$result = DBHelper::updateUser($u['user_id']>0?$u['user_id']:null, $u['user_name'], $u['user_password'], $u['user_email']);

if (!$result)

$error = 'Unable to update user ! '.DBHelper::getLastError();

}

} else { $error = 'Username can not be empty !'; }

if ($error!=null)

Helper::pushAlert(ALERT_ERROR, $error);

else

Helper::pushAlert(ALERT_SUCCESS, 'User updated with success !');

header('Location:index.php?p='.PAGE_ID_USERS);

break;

//////// GET NEW ISSUES BOX

case 'getnewreports' :

require_once('pages/home_new_issues_box.inc.php');

break;

//////// GET CHART DATA

case 'getmostaffecteddev' :

require_once('pages/home_most_affected_devices_box.inc.php');

break;

//////// GET CHART DATA

case 'getchartdata' :

require_once('includes/charthelper.class.php');

$data = null; $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.|'; }

break;

default : $message = 'Unhandled chart id requested !!!';

}

echo $message.'|'.$data;

break;

//////// CLEAR LOGS

case 'clearlogs' :

if (strcmp($_POST['tab'], 'tabFile')==0) {

$mDebug = new Debug();

$mDebug->clearLogFile();

} else { DBHelper::deleteLogs(); }

//////// GET LOGS TAB CONTENT

case 'getlogs' :

$mDebug = new Debug();

if (strcmp($_POST['tab'], 'tabFile')==0)

echo $mDebug->getFormattedLogs();

else

echo $mDebug->getFormattedDBLogs();

break;

default : die("UNHANDLED ACTION REQUESTED !");

}