'User Favourite', 'number' => '10029', 'description' => 'Define and mainten favourite', 'version' => '0.1.1', 'db_version' => '1001', 'mod_version' => '1.1.1', 'primary_entity_cb' => '', 'module_name' => 'extn', 'weight' => 29 ]; public $field_a = [ 'user_favourite_id', 'fav_name', 'fav_group', 'user_id', 'path_id', 'external_link', 'priority', 'created_by', 'creation_date', 'last_update_by', 'last_update_date', ]; public $initial_search = [ 'user_id', 'path_id', ]; public $requiredField = [ 'user_id', 'fav_name', ]; public $user_favourite_id; public $user_id; public $fav_name; public $fav_group; public $path_id; public $external_link; public $priority; public $comment_by; public $created_by; public $creation_date; public $last_update_by; public $last_update_date; Public static function favourite_group() { $option_type = option_header::find_by_name('USER_FAVOURITE_GROUP'); $option_line = option_line::find_by_option_id($option_type->option_header_id); return $option_line; } public function findBy_userId() { $sql = "SELECT * FROM " . self::$table_name . " where user_id='{$this->user_id}' "; $result = $this->findBySql($sql); 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($show_as_menu = false ) { $favs = $this->findBy_currentUser(); if (!$favs) { return false; } $ul_divClass = ($show_as_menu == true ) ? ' class="dropdown-menu" role="menu" ' : ''; $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 user_favourite_all_v() { global $db; $sql = " SELECT * FROM "; $sql .=" user_favourite AS rp , option_line AS ol"; $sql .=" WHERE rp.role_code = ol.option_line_id "; $result = $db->result_array_assoc($sql); return $result; } Public static function all_roles() { $option_header = option_header::find_by_name('USER_ROLES'); $all_roles = option_line::find_by_option_id($option_header->option_header_id); return $all_roles; } } $user_favourite = new user_favourite(); $fav = &$user_favourite; ?>