PHP SugarBean::getIndices方法代碼示例

 /**
  * Returns an array of indices for the current module
  *
  * @return array
  */
 private function _getIndexVardefs()
 {
     $indexes = $this->_focus->getIndices();
     //grab any custom indexes if they exist
     if ($this->_focus->hasCustomFields()) {
         $custmIndexes = $this->_focus->db->helper->get_indices($this->_focus->table_name . '_cstm');
         $indexes = array_merge($custmIndexes, $indexes);
     }
     // remove any that are datetime or time field as we can't dupe check them correctly since we don't export
     // seconds
     $fields = $this->_focus->getFieldDefinitions();
     foreach ($indexes as $key => $index) {
         foreach ($index['fields'] as $field) {
             if (isset($fields[$field]) && ($fields[$field]['type'] == 'datetime' || $fields[$field]['type'] == 'datetimecombo' || $fields[$field]['type'] == 'time')) {
                 unset($indexes[$key]);
                 break 1;
             }
         }
     }
     if ($this->_focus->getFieldDefinition('email1')) {
         $indexes[] = array('name' => 'special_idx_email1', 'type' => 'index', 'fields' => array('email1'));
     }
     if ($this->_focus->getFieldDefinition('email2')) {
         $indexes[] = array('name' => 'special_idx_email2', 'type' => 'index', 'fields' => array('email2'));
     }
     return $indexes;
 }

 /**
  * Generates sql for create table statement for a bean.
  *
  * @param  object $bean SugarBean instance
  * @return string SQL Create Table statement
  */
 public function createTableSQL(SugarBean $bean)
 {
     $tablename = $bean->getTableName();
     $fieldDefs = $bean->getFieldDefinitions();
     $indices = $bean->getIndices();
     return $this->createTableSQLParams($tablename, $fieldDefs, $indices);
 }

 /**
  * Implements repair of a db table for a bean.
  *
  * @param  object $bean    SugarBean instance
  * @param  bool   $execute true if we want the action to take place, false if we just want the sql returned
  * @return string SQL statement or empty string, depending upon $execute
  */
 public function repairTable(SugarBean $bean, $execute = true)
 {
     $indices = $bean->getIndices();
     $fielddefs = $bean->getFieldDefinitions();
     $tablename = $bean->getTableName();
     //Clean the indicies to prevent duplicate definitions
     $new_Indecies = array();
     foreach ($indices as $ind_def) {
         $new_Indecies[$ind_def['name']] = $ind_def;
     }
     //jc: added this for beans that do not actually have a table, namely
     //ForecastOpportunities
     if ($tablename == 'does_not_exist' || $tablename == '') {
         return '';
     }
     global $dictionary;
     $engine = null;
     if (isset($dictionary[$bean->getObjectName()]['engine']) && !empty($dictionary[$bean->getObjectName()]['engine'])) {
         $engine = $dictionary[$bean->getObjectName()]['engine'];
     }
     return $this->repairTableParams($tablename, $fielddefs, $new_Indecies, $execute, $engine);
 }

 /**
  * Implements repair of a db table for a bean.
  *
  * @param  object $bean    SugarBean instance
  * @param  bool   $execute true if we want the action to take place, false if we just want the sql returned
  * @return string SQL statement or empty string, depending upon $execute
  */
 public function repairTable(SugarBean $bean, $execute = true)
 {
     $indices = $bean->getIndices();
     $fielddefs = $bean->getFieldDefinitions();
     $tablename = $bean->getTableName();
     //jc: added this for beans that do not actually have a table, namely
     //ForecastOpportunities
     if ($tablename == 'does_not_exist' || $tablename == '') {
         return '';
     }
     global $dictionary;
     $engine = null;
     if (isset($dictionary[$bean->getObjectName()]['engine']) && !empty($dictionary[$bean->getObjectName()]['engine'])) {
         $engine = $dictionary[$bean->getObjectName()]['engine'];
     }
     return $this->repairTableParams($tablename, $fielddefs, $indices, $execute, $engine);
 }