controller.php

<?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();

$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' :
			$cfg = CfgHelper::getInstance();
			$error = null;
			$reportDir = 'report/';
			
			if ($cfg->isReportBasicAuthEnabled() && $cfg->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 = $cfg->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' :
			$cfg = CfgHelper::getInstance();
			
			$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 { $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) {
				CfgHelper::init(true);				
				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 !");
}