/**
*
* @param string $title required user friendly message to return to the requestor
* @param int $code required HTTP response code
* @param array $errorList list of optional properites to set on the error object
* @param null $previous
*/
public function __construct($title, $code, $errorList, $previous = null)
{
parent::__construct($title, $code, $previous);
// store general error data
$this->errorStore = new ErrorStore($errorList);
$this->errorStore->title = $title;
$this->response = $this->getResponseDescription($code);
$this->di = Di::getDefault();
}
public function initialize()
{
self::$_tbprefix = config('config')['dbMaster']['prefix'];
$this->cache = Di::getDefault()->get('cacheData');
$this->setReadConnectionService('db');
//读
$this->setWriteConnectionService('dbMaster');
//写
$this->useDynamicUpdate(true);
//关闭更新全字段
$this->setup(array('notNullValidations' => false));
//关闭ORM自动验证非空列的映射表
}
/**
* Init menu
*
*/
private function setMenu()
{
$cache = Di::getDefault()->get('cache');
if ($cache->has('app:menu')) {
$this->tree = $cache->get('app:menu');
return null;
}
$db = Di::getDefault()->get('db_centreon');
$this->tree = array();
$stmt = $db->prepare("SELECT menu_id, name, parent_id, url, icon_class, icon, bgcolor, menu_order, menu_block\n FROM cfg_menus\n WHERE module_id IN (SELECT id FROM cfg_modules WHERE isactivated = '1' OR isactivated = '2')\n ORDER BY (CASE WHEN menu_order IS NULL then 1 ELSE 0 END), menu_order ASC, name ASC");
$stmt->execute();
$menus = $stmt->fetchAll(\PDO::FETCH_ASSOC);
$this->tree = $this->buildTree($menus);
$cache->set('app:menu', $this->tree);
}
/**
*
* @return type
* @throws Exception
*/
public static function getCentreonVersion()
{
$di = Di::getDefault();
$db = $di->get('db_centreon');
try {
$stmt = $db->query("SELECT `value` FROM cfg_informations WHERE `key` = 'version'");
$res = $stmt->fetchAll(\PDO::FETCH_ASSOC);
if (count($res) == 0) {
throw new \Exception("No values");
}
} catch (\PDOException $e) {
if ($e->getCode() == "42S02") {
throw new \Exception("Table not exist");
}
}
return $res[0]['value'];
}
/**
* Important
* ValidationException will accept a list of validation objects or a simple key->value list in the 3rd param of
*
* @param string $title the basic error message
* @param array $errorList key=>value pairs for properites of ErrorStore
* @param array $validationList list of phalcon validation objects or key=>value pairs to be converted
* into validation objects
*/
public function __construct($title, $errorList, $validationList)
{
// store general error data
$this->errorStore = new ErrorStore($errorList);
$this->errorStore->title = $title;
$mergedValidations = [];
foreach ($validationList as $key => $validation) {
// process simple key pair
if (is_string($validation)) {
$mergedValidations[] = new Message($validation, $key, 'InvalidValue');
} else {
// assume a validation object
$mergedValidations[] = $validation;
}
}
$this->errorStore->validationList = $mergedValidations;
$this->di = Di::getDefault();
}
/**
* Get user ACL
*
* @param string $route
*/
public function getUserAcl($route)
{
static $rules = null;
if (is_null($rules)) {
$rules = array();
$db = Di::getDefault()->get('db_centreon');
$stmt = $db->prepare("SELECT DISTINCT acl_level, url \n FROM cfg_acl_menu_menu_relations ammr, cfg_acl_groups_menus_relations agmr, cfg_menus m\n WHERE ammr.acl_menu_id = agmr.acl_menu_id\n AND ammr.menu_id = m.menu_id\n AND agmr.acl_group_id IN (\n SELECT acl_group_id \n FROM cfg_acl_group_contacts_relations agcr\n WHERE agcr.contact_contact_id = :contactid\n UNION\n SELECT acl_group_id\n FROM cfg_acl_group_contactgroups_relations agcgr, cfg_contactgroups_contacts_relations ccr\n WHERE agcgr.cg_cg_id = ccr.contactgroup_cg_id\n AND ccr.contact_contact_id = :contactid\n ) ");
$stmt->bindParam(':contactid', $this->userId);
$stmt->execute();
$rows = $stmt->fetchAll();
$aclFlag = 0;
foreach ($rows as $row) {
if (!isset($rules[$row['url']])) {
$rules[$row['url']] = 0;
}
$rules[$row['url']] = $rules[$row['url']] | $row['acl_level'];
}
}
foreach ($rules as $uri => $acl) {
if (strstr($route, $uri)) {
return $acl;
}
}
}
/**
* Set a configuration variable
*
* @param $group string The group of configuration
* @param $var string The variable name
* @param $value mixed The value to store
* @throws The group is not permit for store in database
* @throws If the configuration is not set in database
*/
public function set($group, $var, $value)
{
if (in_array($group, $this->fileGroups)) {
throw new Exception("This configuration group is not permit.");
}
if (false === isset($this->config[$group]) || false === isset($this->config[$group][$var])) {
throw new Exception("This configuration {$group} - {$var} does not exists into database.");
}
$di = Di::getDefault();
/* Save information in database */
$dbconn = $di->get('db_centreon');
$stmt = $dbconn->prepare("UPDATE `cfg_options`\n SET `value` = :value\n WHERE `group` = :group\n AND `key` = :key");
$stmt->bindParam(':value', $value, \PDO::PARAM_STR);
$stmt->bindParam(':group', $group, \PDO::PARAM_STR);
$stmt->bindParam(':key', $var, \PDO::PARAM_STR);
$stmt->execute();
$this->config[$group][$var] = $value;
/* Save config into cache */
$di->get('cache')->set('app:cache', $this->config);
}
public function setUp(\Phalcon\DiInterface $di = NULL, \Phalcon\Config $config = NULL)
{
$this->clearTables();
$this->createUsers();
parent::setUp(Di::getDefault());
}
/**
* Parse a array for generate the url
*
* @param array $params The url parameters
* @param array $castedElement The element converted
* @param array $values The values of row
* @return string
*/
protected static function parseUrl($params, $castedElement, $values)
{
if (isset($values['DT_RowData'])) {
unset($values['DT_RowData']);
unset($values['DT_RowId']);
}
$routeParams = array();
if (isset($params['routeParams']) && is_array($params['routeParams'])) {
$routeParams = str_replace($castedElement, $values, $params['routeParams']);
}
$finalRoute = str_replace("//", "/", Di::getDefault()->get('router')->getPathFor($params['route'], $routeParams));
return $finalRoute;
}
public function setUp()
{
$di = Di::getDefault();
$this->setDI($di);
$this->_loaded = true;
}
/**
* Generate a new CSRF token an store it in session
*
* @return string
*/
public static function generateToken()
{
$token = md5(uniqid(Di::getDefault()->get('config')->get('global', 'secret'), true));
$_SESSION[self::$sessionTokenName] = $token;
return $token;
}
/**
* Initializes the session bag. This method must not be called directly, the class calls it when its internal data is accesed
*
* @throws Exception
*/
public function initialize()
{
/* Ensure session object is present */
if (is_object($this->_session) === false) {
if (is_object($this->_dependencyInjector) === false) {
$dependencyInjector = DI::getDefault();
if (is_object($dependencyInjector) === false) {
throw new Exception('A dependency injection object is required to access the \'session\' service');
}
} else {
$dependencyInjector = $this->_dependencyInjector;
}
$session = $dependencyInjector->getShared('session');
if (is_object($session) === false || $session instanceof AdapterInterface === false) {
throw new Exception('Invalid session service.');
}
$this->_session = $session;
}
$session = $this->_session;
if (!is_object($session)) {
$dependencyInjector = $this->_dependencyInjector;
if (!is_object($dependencyInjector)) {
$dependencyInjector = Di::getDefault();
}
$session = $dependencyInjector->getShared('session');
$this->_session = $session;
}
$data = $session->get($this->_name);
if (!is_array($data)) {
$data = [];
}
$this->_data = $data;
$this->_initialized = true;
}
function CACHE()
{
static $cache = null;
if (!is_object($cache)) {
$cache = Di::getDefault()->get('cacheData');
}
return $cache;
}
/**
* Get module hook cache
*
* @return array
*/
private static function getModuleHookCache()
{
$db = Di::getDefault()->get('db_centreon');
if (!isset(self::$moduleHookCache)) {
self::$moduleHookCache = array();
$sql = "SELECT module_id, hook_id, module_hook_name, module_hook_description\n FROM cfg_modules_hooks";
$stmt = $db->prepare($sql);
$stmt->execute();
$rows = $stmt->fetchAll();
foreach ($rows as $row) {
$unique = implode("_", array($row['module_id'], $row['hook_id'], $row['module_hook_name']));
self::$moduleHookCache[$unique] = $row;
}
}
return self::$moduleHookCache;
}
/**
* @return array
*/
public function __debugInfo()
{
$defaultDi = Di::getDefault();
$data = [];
foreach (get_object_vars($this) as $k => $v) {
if ($v === $defaultDi) {
continue;
}
$data[$k] = $v;
}
return $data;
}
