<?php
// $Id: profiloo.module,v 1.2.2.1 2009-03-31 10:04:24 marand Exp $
/**
 * @file
 *   An OO wrapper around the profile module
 *
 * @copyright 2008-2009 Ouest Systemes Informatiques (OSInet)
 * @author Frederic G. MARAND
 * @license Licensed under the CeCILL 2.0 and the General Public Licence version 2 or later
 */

/**
 * The wrapper class
 */
class Profiloo {

  /**
   * Return a list of the currently defined profile fields.
   *
   * This function is not subject to access control.
   *
   * @param array $ar_filter
   * @return array
   */
  static function get_fields($ar_filter = array()) {

    $sq = 'SELECT pf.fid, pf.title, pf.name, pf.explanation, pf.category, '
        .'  pf.page, pf.type, pf.weight, pf.required, pf.register, '
        .'  pf.visibility, pf.autocomplete, pf.options '
        .'FROM {profile_fields} pf ';

    if (empty($ar_filter)) {
      $q = db_query($sq);
    }
    else {
      $ar_query  = array();
      $ar_params = array();
      foreach ($ar_filter as $key => $value) {
        if (in_array($key, array('fid', 'weight', 'required', 'register', 'visibility', 'autocomplete'))) {
          $ar_query[] = "pf.$key = %d";
          $ar_params[] = $value;
        }
        else {
          $ar_query[] = "LOWER(pf.$key) = LOWER('%s')";
          $ar_params[] = $value;
        }
      }
      $sq .= 'WHERE '. implode(' AND ', $ar_query);
      $q = db_query($sq, $ar_params);
    }

    $ar_fields = array();
    while (is_object($o = db_fetch_object($q))) {
      $ar_fields[$o->fid] = $o;
    }
    return $ar_fields;
  }

  /**
   * Return a list of the currently defined fields as a FormsAPI #select needs them.
   *
   * This function is not subject to access control.
   *
   * @param array $ar_filter
   * @return array
   */
  static function get_fields_as_options($ar_filter = array()) {
    $ar_fields = self::get_fields($ar_filter);
    $ar_ret = array();
    foreach ($ar_fields as $fid => $o_field) {
      $ar_ret[$fid] = $o_field->title;
    }
    return $ar_ret;
  }
}