Пример #1
0
 protected static function GetFields()
 {
     if (!isset(self::$FIELDS)) {
         $responsibleJoin = 'LEFT JOIN b_user U ON A.RESPONSIBLE_ID = U.ID';
         //$bindingTableName = CCrmActivity::BINDING_TABLE_NAME;
         //$bindingJoin = "INNER JOIN {$bindingTableName} B ON A.ID = B.ACTIVITY_ID";
         self::$FIELDS = array('ID' => array('FIELD' => 'A.ID', 'TYPE' => 'int'), 'OWNER_ID' => array('FIELD' => 'A.OWNER_ID', 'TYPE' => 'int'), 'OWNER_TYPE_ID' => array('FIELD' => 'A.OWNER_TYPE_ID', 'TYPE' => 'int'), 'TYPE_ID' => array('FIELD' => 'A.TYPE_ID', 'TYPE' => 'int'), 'PARENT_ID' => array('FIELD' => 'A.PARENT_ID', 'TYPE' => 'int'), 'ASSOCIATED_ENTITY_ID' => array('FIELD' => 'A.ASSOCIATED_ENTITY_ID', 'TYPE' => 'int'), 'URN' => array('FIELD' => 'A.URN', 'TYPE' => 'string'), 'SUBJECT' => array('FIELD' => 'A.SUBJECT', 'TYPE' => 'string'), 'CREATED' => array('FIELD' => 'A.CREATED', 'TYPE' => 'datetime'), 'LAST_UPDATED' => array('FIELD' => 'A.LAST_UPDATED', 'TYPE' => 'datetime'), 'START_TIME' => array('FIELD' => 'A.START_TIME', 'TYPE' => 'datetime'), 'END_TIME' => array('FIELD' => 'A.END_TIME', 'TYPE' => 'datetime'), 'DEADLINE' => array('FIELD' => 'A.DEADLINE', 'TYPE' => 'datetime'), 'COMPLETED' => array('FIELD' => 'A.COMPLETED', 'TYPE' => 'char'), 'RESPONSIBLE_ID' => array('FIELD' => 'A.RESPONSIBLE_ID', 'TYPE' => 'int'), 'RESPONSIBLE_LOGIN' => array('FIELD' => 'U.LOGIN', 'TYPE' => 'string', 'FROM' => $responsibleJoin), 'RESPONSIBLE_NAME' => array('FIELD' => 'U.NAME', 'TYPE' => 'string', 'FROM' => $responsibleJoin), 'RESPONSIBLE_LAST_NAME' => array('FIELD' => 'U.LAST_NAME', 'TYPE' => 'string', 'FROM' => $responsibleJoin), 'RESPONSIBLE_SECOND_NAME' => array('FIELD' => 'U.SECOND_NAME', 'TYPE' => 'string', 'FROM' => $responsibleJoin), 'PRIORITY' => array('FIELD' => 'A.PRIORITY', 'TYPE' => 'int'), 'NOTIFY_TYPE' => array('FIELD' => 'A.NOTIFY_TYPE', 'TYPE' => 'int'), 'NOTIFY_VALUE' => array('FIELD' => 'A.NOTIFY_VALUE', 'TYPE' => 'int'), 'DESCRIPTION' => array('FIELD' => 'A.DESCRIPTION', 'TYPE' => 'string'), 'DESCRIPTION_TYPE' => array('FIELD' => 'A.DESCRIPTION_TYPE', 'TYPE' => 'int'), 'DIRECTION' => array('FIELD' => 'A.DIRECTION', 'TYPE' => 'int'), 'LOCATION' => array('FIELD' => 'A.LOCATION', 'TYPE' => 'string'), 'STORAGE_TYPE_ID' => array('FIELD' => 'A.STORAGE_TYPE_ID', 'TYPE' => 'int'), 'STORAGE_ELEMENT_IDS' => array('FIELD' => 'A.STORAGE_ELEMENT_IDS', 'TYPE' => 'string'), 'SETTINGS' => array('FIELD' => 'A.SETTINGS', 'TYPE' => 'string'), 'ORIGIN_ID' => array('FIELD' => 'A.ORIGIN_ID', 'TYPE' => 'string'), 'AUTHOR_ID' => array('FIELD' => 'A.AUTHOR_ID', 'TYPE' => 'int'), 'EDITOR_ID' => array('FIELD' => 'A.EDITOR_ID', 'TYPE' => 'int'));
     }
     $arFields = self::$FIELDS;
     CCrmActivity::CreateLogicalField('TYPE_NAME', $arFields);
     return $arFields;
 }