PHP Base_module_model::options_list方法代码示例

 function options_list($key = 'fuel_user_id', $val = 'display_name', $where = array(), $order = 'display_name')
 {
     if ($key == 'id') {
         $key = $this->table_name . '.fuel_user_id';
     }
     if ($val == 'display_name') {
         $val = 'IF(display_name = "", fuel_users.email, display_name) AS name';
     }
     $this->db->join('fuel_users', 'fuel_users.id = fuel_blog_users.fuel_user_id', 'left');
     $return = parent::options_list($key, $val, $where, $order);
     return $return;
 }

 function options_list($key = 'id', $val = 'name', $where = array(), $order = 'name')
 {
     $CI =& get_instance();
     if ($key == 'id') {
         $key = $this->table_name . '.id';
     }
     if ($val == 'name') {
         $val = 'CONCAT(first_name, " ", last_name) as name';
     }
     if (!$CI->fuel_auth->is_super_admin()) {
         $this->db->where(array('super_admin' => 'no'));
     }
     $return = parent::options_list($key, $val, $where, $order);
     return $return;
 }

 /**
  * Initializes the class with the parent model and field names
  *
  * @access	public
  * @return	array
  */
 public function context_options_list()
 {
     $this->db->group_by('context');
     $this->db->where('context != ""');
     return parent::options_list('context', 'context');
 }

 /**
  * Overwritten: Allows for grouping of menu items with last paramter
  *
  * @access	public
  * @param	string	The column to use for the value (optional)
  * @param	string	The column to use for the label (optional)
  * @param	mixed	An array or string containg the where paramters of a query (optional)
  * @param	string	The order by of the query. defaults to $val asc (optional)
  * @param	boolean	Determines whether it will group the options together based on the menu troup (optional)
  * @return	array	 */
 public function options_list($key = 'id', $val = 'label', $where = array(), $order = TRUE, $group = TRUE)
 {
     if (!empty($order) and is_bool($order)) {
         $this->db->order_by($val, 'asc');
     } else {
         if (!empty($order) and is_string($order)) {
             if (strpos($order, ' ') === FALSE) {
                 $order .= ' asc';
             }
             $this->db->order_by($order);
         }
     }
     if ($group) {
         // need to turn this off to get the proper ordering
         $data = $this->find_all_array_assoc($key, $where);
         return $this->_group_options($data, $key, $val);
     } else {
         return parent::options_list($key, $val, $where, $order);
     }
 }

 /**
  * Overwrites the parent option_list method 
  *
  * @access	public
  * @param	string	the name of the field to be used as the key (optional)
  * @param	string	the name of the filed to be used as the value (optional)
  * @param	mixed	the where condition to apply (optional)
  * @param	mixed	the order in which to return the results (optional)
  * @return	array 	
  */
 public function options_list($key = 'id', $val = 'name', $where = array(), $order = TRUE)
 {
     $this->db->join($this->_tables['fuel_categories'], $this->_tables['fuel_categories'] . '.id = ' . $this->_tables['fuel_tags'] . '.category_id', 'LEFT');
     // if (empty($key)) $key = $this->_tables['fuel_categories'].'.id';
     // if (empty($val)) $val = $this->_tables['fuel_categories'].'.name';
     if (empty($key)) {
         $key = $this->_tables['fuel_tags'] . '.id';
     }
     if (empty($val)) {
         $val = $this->_tables['fuel_tags'] . '.name';
     }
     // needed to prevent ambiguity
     if (strpos($key, '.') === FALSE and strpos($key, '(') === FALSE) {
         $key = $this->_tables['fuel_tags'] . '.' . $key;
     }
     // needed to prevent ambiguity
     if (strpos($val, '.') === FALSE and strpos($val, '(') === FALSE) {
         $val = $this->_tables['fuel_tags'] . '.' . $val;
     }
     $options = parent::options_list($key, $val, $where, $order);
     return $options;
 }

 public function options_list_with_views($where = array(), $dir_folder = '', $dir_filter = '^_(.*)|\\.html$', $order = TRUE, $recursive = TRUE)
 {
     $CI =& get_instance();
     $CI->load->helper('directory');
     $module_path = APPPATH;
     if (is_array($dir_folder)) {
         $module = key($dir_folder);
         $dir_folder = current($dir_folder);
         if (is_string($module)) {
             $module_path = MODULES_PATH . $module;
         }
     }
     $dir_folder = trim($dir_folder, '/');
     $blocks_path = $module_path . '/views/_blocks/' . $dir_folder;
     // don't display blocks with preceding underscores or .html files'
     $block_files = directory_to_array($blocks_path, $recursive, '#' . $dir_filter . '#', FALSE, TRUE);
     $view_blocks = array();
     foreach ($block_files as $block) {
         $view_blocks[$block] = $block;
     }
     // if a dir_folder exists, then we will look for any CMS blocks that may be prefixed with that dir_folder
     // (e.g. sections/left_block becomes just left_block)
     if (!empty($dir_folder) and empty($where)) {
         $where = 'name LIKE "' . $dir_folder . '/%"';
     }
     $blocks = parent::options_list('name', 'name', $where, $order);
     // continue filter of cms blocks dir_folder is specified
     $cms_blocks = array();
     if (!empty($dir_folder)) {
         $cms_blocks = array();
         foreach ($blocks as $key => $val) {
             $key = preg_replace('#^' . $dir_folder . '/(.+)#', '$1', $key);
             $cms_blocks[$key] = $key;
         }
     } else {
         $cms_blocks = $blocks;
     }
     $blocks = array_merge($view_blocks, $cms_blocks);
     if ($order) {
         ksort($blocks);
     }
     return $blocks;
 }