2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero General Public License version 3 as published by the
9 * Free Software Foundation with the addition of the following permission added
10 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
14 * This program is distributed in the hope that it will be useful, but WITHOUT
15 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
19 * You should have received a copy of the GNU Affero General Public License along with
20 * this program; if not, see http://www.gnu.org/licenses or write to the Free
21 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
27 * The interactive user interfaces in modified source and object code versions
28 * of this program must display Appropriate Legal Notices, as required under
29 * Section 5 of the GNU Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32 * these Appropriate Legal Notices must retain the display of the "Powered by
33 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34 * technical reasons, the Appropriate Legal Notices must display the words
35 * "Powered by SugarCRM".
36 ********************************************************************************/
39 $dictionary['DocumentRevision'] = array('table' => 'document_revisions'
44 'vname' => 'LBL_REVISION_NAME',
53 'name' => 'change_log',
54 'vname' => 'LBL_CHANGE_LOG',
61 'name' => 'document_id',
62 'vname' => 'LBL_DOCUMENT',
71 'vname' => 'LBL_DOC_ID',
74 'comment' => 'Document ID from documents web server provider',
75 'importable' => false,
81 'vname' => 'LBL_DOC_TYPE',
83 'function' => 'getDocumentsExternalApiDropDown',
85 'comment' => 'Document type (ex: Google, box.net, IBM SmartCloud)',
91 'vname' => 'LBL_DOC_URL',
94 'comment' => 'Document URL from documents web server provider',
95 'importable' => false,
100 'name' => 'date_entered',
101 'vname' => 'LBL_DATE_ENTERED',
102 'type' => 'datetime',
106 'name' => 'created_by',
107 'rname' => 'user_name',
108 'id_name' => 'modified_user_id',
109 'vname' => 'LBL_CREATED',
110 'type' => 'assigned_user_name',
118 'name' => 'filename',
119 'vname' => 'LBL_FILENAME',
121 'dbType' => 'varchar',
125 'linkModuleOverride' => 'Documents',
129 'name' => 'file_ext',
130 'vname' => 'LBL_FILE_EXTENSION',
136 'name' => 'file_mime_type',
137 'vname' => 'LBL_MIME',
144 'name' => 'revision',
145 'vname' => 'LBL_REVISION',
148 'importable' => 'required',
154 'vname' => 'LBL_DELETED',
161 'name' => 'date_modified',
162 'vname' => 'LBL_DATE_MODIFIED',
163 'type' => 'datetime',
167 'name' => 'documents',
169 'relationship' => 'document_revisions',
171 'vname'=>'LBL_REVISIONS',
176 'name' => 'created_by_link',
178 'relationship' => 'revisions_created_by',
179 'vname' => 'LBL_CREATED_BY_USER',
180 'link_type' => 'one',
188 'name' => 'created_by_name',
189 'rname' => 'user_name',
190 'db_concat_fields'=> array(0=>'first_name', 1=>'last_name'),
191 'id_name' => 'created_by',
192 'vname' => 'LBL_CREATED_BY_NAME',
197 'dbType' => 'varchar',
198 'link'=>'created_by_link',
202 'latest_revision_id'=>
204 'name' => 'latest_revision_id',
205 'vname' => 'LBL_REVISION',
212 'name' => 'document_name',
213 'vname' => 'LBL_DOC_NAME',
216 'source' => 'non-db',
220 'name' => 'latest_revision',
221 'vname' => 'LBL_CURRENT_DOC_VERSION',
224 'source' => 'non-db',
228 'relationships'=>array(
229 'revisions_created_by' => array('lhs_module'=> 'Users', 'lhs_table'=> 'users', 'lhs_key' => 'id',
230 'rhs_module'=> 'DocumentRevisions', 'rhs_table'=> 'document_revisions', 'rhs_key' => 'created_by',
231 'relationship_type'=>'one-to-many'),
235 array('name' =>'documentrevisionspk', 'type' =>'primary', 'fields'=>array('id')),
236 array('name' =>'documentrevision_mimetype', 'type' =>'index', 'fields'=>array('file_mime_type')),