'Dashboard Config', 'number' => '10028', 'description' => 'Dashboard Config', 'version' => '0.1.1', 'db_version' => '1001', 'mod_version' => '1.1.1', 'primary_entity_cb' => '', 'module_name' => 'extn', 'weight' => 28 ]; public static $config_level_a = [ 'USER' => 'User', 'ROLE' => 'Role', 'GLOBAL' => 'Global' ]; public static $report_type_a = [ 'block' => 'Block', 'view' => 'View', 'report' => 'Reports' ]; public $field_a = [ 'user_dashboard_config_id', 'config_level', 'user_role', 'user_id', 'report_group', 'report_type', 'report_id', 'report_label', 'priority', 'created_by', 'creation_date', 'last_update_by', 'last_update_date', ]; public $initial_search = [ 'user_id', 'report_group', 'report_type', ]; public $requiredField = [ 'report_group', 'report_type', 'report_id', ]; public $fields_inForm_notInDataBase = [ 'username' ]; public $user_dashboard_config_id; public $config_level; public $user_id; public $user_role; public $report_group; public $report_type; public $report_id; public $priority; public $fav_group; public $report_label; public $created_by; public $creation_date; public $last_update_by; public $last_update_date; public $username; public function _before_save() { global $ino_user; if ($this->config_level == 'USER' && empty($this->user_id)) { $this->user_id = $ino_user->ino_user_id; } } Public static function report_group() { $option_type = option_header::find_by_name('USER_REPORT_GROUP'); $option_line = option_line::find_by_option_id($option_type->option_header_id); return $option_line; } public function findBy_userId($user_id) { $sql = "SELECT * FROM " . self::$table_name . " where user_id='{$user_id}' and user_id IS NOT NULL "; $result = $this->findBySql($sql); return !empty($result) ? $result : false; } public function findBy_userIdForAdmin($user_id) { $sql = "SELECT * FROM " . self::$table_name . " where user_id='{$user_id}' and user_id IS NOT NULL OR config_level = 'GLOBAL' "; $result = $this->findBySql($sql); return !empty($result) ? $result : false; } public static function findBy_userIdNconfigLevel($user_id, $config_level = 'GLOBAL') { $sql = "SELECT * FROM " . self::$table_name . " where user_id=:user_id and user_id IS NOT NULL OR config_level = :config_level "; $sql .= " ORDER BY priority ASC "; global $db; $value_a = ['user_id' => $user_id, 'config_level' => $config_level]; $result = $db->findBySql($sql, $value_a); return !empty($result) ? $result : false; } public function findBy_currentUser() { if ($_SESSION['user_id']) { $this->user_id = $_SESSION['user_id']; return $this->findBy_userId(); } else { return false; } } public function show_currentUser_fav() { $favs = $this->findBy_currentUser(); if (!$favs) { return false; } $fav_stmt = '

'; $count = 0; foreach ($favs as $links) { $divClass = ($count % 2 ) == 0 ? 'even' : 'odd'; $fav_stmt .= '
• '; if (!empty($links->path_id)) { $path = path::find_by_id($links->path_id); $fav_stmt .= '' . $links->fav_name . ''; } else { $fav_stmt .= '' . $links->fav_name . ''; } $fav_stmt .= '
'; } $fav_stmt .= '

'; return $fav_stmt; } public static function find_by_userId($user_id) { $sql = "SELECT * FROM " . self::$table_name . " where user_id='{$user_id}' "; $result = $this->findBySql($sql); return !empty($result) ? $result : false; } public static function find_roleAndGlobal_configs() { $sql = "SELECT * FROM " . self::$table_name . " where config_level IN ('GLOBAL', 'ROLE') "; global $db; $result = $db->findBySql($sql); return !empty($result) ? $result : false; } } ?>