[Sommaire] [Imprimer]

   1  <?php
   2  /*********************************************************************************
   3  ** The contents of this file are subject to the vtiger CRM Public License Version 1.0
   4   * ("License"); You may not use this file except in compliance with the License
   5   * The Original Code is:  vtiger CRM Open Source
   6   * The Initial Developer of the Original Code is vtiger.
   7   * Portions created by vtiger are Copyright (C) vtiger.
   8   * All Rights Reserved.
   9  *
  10   ********************************************************************************/
  11  
  12  require_once ('include/database/PearDatabase.php');
  13  /** Function to  returns the combo field values in array format
  14    * @param $combofieldNames -- combofieldNames:: Type string array
  15    * @returns $comboFieldArray -- comboFieldArray:: Type string array
  16   */
  17  function getComboArray($combofieldNames)
  18  {
  19      global $log;
  20          $log->debug("Entering getComboArray(".$combofieldNames.") method ...");
  21      global $adb;
  22      $comboFieldArray = Array();
  23      foreach ($combofieldNames as $tableName => $arrayName)
  24      {
  25          $fldArrName= $arrayName;
  26          $arrayName = Array();
  27          $result = $adb->query("select * from vtiger_".$tableName." where presence=1 order by sortorderid");
  28          while($row = $adb->fetch_array($result))
  29          {
  30              $val = $row[$tableName];
  31              $arrayName[$val] = $val;    
  32          }
  33          $comboFieldArray[$fldArrName] = $arrayName;
  34      }
  35      $log->debug("Exiting getComboArray method ...");
  36      return $comboFieldArray;    
  37  }
  38  ?>