2 if(!defined('sugarEntry') || !sugarEntry)
3 die('Not A Valid Entry Point');
4 /*********************************************************************************
5 * SugarCRM Community Edition is a customer relationship management program developed by
6 * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
8 * This program is free software; you can redistribute it and/or modify it under
9 * the terms of the GNU Affero General Public License version 3 as published by the
10 * Free Software Foundation with the addition of the following permission added
11 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
12 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
13 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
15 * This program is distributed in the hope that it will be useful, but WITHOUT
16 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
17 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
20 * You should have received a copy of the GNU Affero General Public License along with
21 * this program; if not, see http://www.gnu.org/licenses or write to the Free
22 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
25 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
26 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
28 * The interactive user interfaces in modified source and object code versions
29 * of this program must display Appropriate Legal Notices, as required under
30 * Section 5 of the GNU Affero General Public License version 3.
32 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
33 * these Appropriate Legal Notices must retain the display of the "Powered by
34 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
35 * technical reasons, the Appropriate Legal Notices must display the words
36 * "Powered by SugarCRM".
37 ********************************************************************************/
39 require_once ('include/upload_file.php');
42 // User is used to store Forecast information.
43 class Document extends SugarBean {
55 var $modified_user_id;
56 var $assigned_user_id;
59 var $document_revision_id;
66 var $related_doc_name;
67 var $related_doc_rev_id;
68 var $related_doc_rev_number;
74 var $last_rev_create_date;
75 var $last_rev_created_by;
76 var $last_rev_created_name;
78 var $file_url_noimage;
80 var $table_name = "documents";
81 var $object_name = "Document";
82 var $user_preferences;
84 var $encodeFields = Array ();
86 // This is used to retrieve related fields from form posts.
87 var $additional_column_fields = Array ('revision');
89 var $new_schema = true;
90 var $module_dir = 'Documents';
94 var $relationship_fields = Array(
95 'contract_id'=>'contracts',
100 parent :: SugarBean();
101 $this->setupCustomFields('Documents'); //parameter is module name
102 $this->disable_row_level_security = false;
105 function save($check_notify = false) {
107 if (empty($this->doc_type)) {
108 $this->doc_type = 'Sugar';
110 if (empty($this->id) || $this->new_with_id)
112 if (empty($this->id)) {
113 $this->id = create_guid();
114 $this->new_with_id = true;
117 if ( isset($_REQUEST) && isset($_REQUEST['duplicateSave']) && $_REQUEST['duplicateSave'] == true && isset($_REQUEST['filename_old_doctype']) ) {
118 $this->doc_type = $_REQUEST['filename_old_doctype'];
121 $isDuplicate = false;
124 $Revision = new DocumentRevision();
126 $Revision->in_workflow = true;
127 $Revision->not_use_rel_in_req = true;
128 $Revision->new_rel_id = $this->id;
129 $Revision->new_rel_relname = 'Documents';
130 $Revision->change_log = translate('DEF_CREATE_LOG','Documents');
131 $Revision->revision = $this->revision;
132 $Revision->document_id = $this->id;
133 $Revision->filename = $this->filename;
135 if(isset($this->file_ext))
137 $Revision->file_ext = $this->file_ext;
140 if(isset($this->file_mime_type))
142 $Revision->file_mime_type = $this->file_mime_type;
145 $Revision->doc_type = $this->doc_type;
146 if ( isset($this->doc_id) ) {
147 $Revision->doc_id = $this->doc_id;
149 if ( isset($this->doc_url) ) {
150 $Revision->doc_url = $this->doc_url;
153 $Revision->id = create_guid();
154 $Revision->new_with_id = true;
156 $createRevision = false;
157 //Move file saved during populatefrompost to match the revision id rather than document id
158 if (!empty($_FILES['filename_file'])) {
159 rename(UploadFile :: get_url($this->filename, $this->id), UploadFile :: get_url($this->filename, $Revision->id));
160 $createRevision = true;
161 } else if ( $isDuplicate && ( empty($this->doc_type) || $this->doc_type == 'Sugar' ) ) {
162 // Looks like we need to duplicate a file, this is tricky
163 $oldDocument = new Document();
164 $oldDocument->retrieve($_REQUEST['duplicateId']);
165 $GLOBALS['log']->debug('Attempting to copy from '.UploadFile :: get_url($this->filename, $oldDocument->document_revision_id).' to '.UploadFile :: get_url($this->filename, $Revision->id));
166 copy(UploadFile :: get_url($this->filename, $oldDocument->document_revision_id), UploadFile :: get_url($this->filename, $Revision->id));
167 $createRevision = true;
170 // For external documents, we just need to make sure we have a doc_id
171 if ( !empty($this->doc_id) && $this->doc_type != 'Sugar' ) {
172 $createRevision = true;
175 if ( $createRevision ) {
177 //update document with latest revision id
178 $this->process_save_dates=false; //make sure that conversion does not happen again.
179 $this->document_revision_id = $Revision->id;
183 //set relationship field values if contract_id is passed (via subpanel create)
184 if (!empty($_POST['contract_id'])) {
185 $save_revision['document_revision_id']=$this->document_revision_id;
186 $this->load_relationship('contracts');
187 $this->contracts->add($_POST['contract_id'],$save_revision);
190 if ((isset($_POST['load_signed_id']) and !empty($_POST['load_signed_id']))) {
191 $query="update linked_documents set deleted=1 where id='".$_POST['load_signed_id']."'";
192 $this->db->query($query);
196 return parent :: save($check_notify);
198 function get_summary_text() {
199 return "$this->document_name";
202 function is_authenticated() {
203 return $this->authenticated;
206 function fill_in_additional_list_fields() {
207 $this->fill_in_additional_detail_fields();
210 function fill_in_additional_detail_fields() {
212 global $current_language;
216 parent::fill_in_additional_detail_fields();
218 $mod_strings = return_module_language($current_language, 'Documents');
220 if (!empty($this->document_revision_id)) {
221 $query = "SELECT users.first_name AS first_name, users.last_name AS last_name, document_revisions.date_entered AS rev_date, document_revisions.filename AS filename, document_revisions.revision AS revision, document_revisions.file_ext AS file_ext FROM users, document_revisions WHERE users.id = document_revisions.created_by AND document_revisions.id = '$this->document_revision_id'";
222 $result = $this->db->query($query);
223 $row = $this->db->fetchByAssoc($result);
226 if(isset($this->document_name))
228 $this->name = $this->document_name;
231 if(isset($row['filename']))$this->filename = $row['filename'];
232 //$this->latest_revision = $row['revision'];
233 if(isset($row['revision']))$this->revision = $row['revision'];
235 //populate the file url.
236 //image is selected based on the extension name <ext>_icon_inline, extension is stored in document_revisions.
237 //if file is not found then default image file will be used.
239 global $img_name_bare;
240 if (!empty ($row['file_ext'])) {
241 $img_name = SugarThemeRegistry::current()->getImageURL(strtolower($row['file_ext'])."_image_inline.gif");
242 $img_name_bare = strtolower($row['file_ext'])."_image_inline";
246 //set default file name.
247 if (!empty ($img_name) && file_exists($img_name)) {
248 $img_name = $img_name_bare;
250 $img_name = "def_image_inline"; //todo change the default image.
252 if($this->ACLAccess('DetailView')){
253 $file_url = "<a href='index.php?entryPoint=download&id=".basename(UploadFile :: get_url($this->filename, $this->document_revision_id))."&type=Documents' target='_blank'>".SugarThemeRegistry::current()->getImage($img_name, 'alt="'.$mod_strings['LBL_LIST_VIEW_DOCUMENT'].'" border="0"')."</a>";
255 if(!empty($this->doc_type) && $this->doc_type != 'Sugar' && !empty($this->doc_url))
256 $file_url= "<a href='".$this->doc_url."' target='_blank'>".SugarThemeRegistry::current()->getImage($this->doc_type.'_image_inline', 'alt="'.$mod_strings['LBL_LIST_VIEW_DOCUMENT'].'" border="0"',null,null,'.png')."</a>";
257 $this->file_url = $file_url;
258 $this->file_url_noimage = basename(UploadFile :: get_url($this->filename, $this->document_revision_id));
260 $this->file_url = "";
261 $this->file_url_noimage = "";
264 //get last_rev_by user name.
266 $this->last_rev_created_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name']);
268 $this->last_rev_create_date = $timedate->to_display_date_time($row['rev_date']);
271 global $app_list_strings;
272 if(!empty($this->status_id)) {
273 //_pp($this->status_id);
274 $this->status = $app_list_strings['document_status_dom'][$this->status_id];
276 if (!empty($this->related_doc_id)) {
277 $this->related_doc_name = Document::get_document_name($this->related_doc_id);
278 $this->related_doc_rev_number = DocumentRevision::get_document_revision_name($this->related_doc_rev_id);
280 $this->save_file = basename($this->file_url_noimage);
284 function list_view_parse_additional_sections(& $list_form, $xTemplateSection) {
288 function create_export_query(&$order_by, &$where, $relate_link_join='')
290 $custom_join = $this->custom_fields->getJOIN(true, true,$where);
292 $custom_join['join'] .= $relate_link_join;
296 $query .= $custom_join['select'];
298 $query .= " FROM documents ";
300 $query .= $custom_join['join'];
303 $where_auto = " documents.deleted = 0";
306 $query .= " WHERE $where AND ".$where_auto;
308 $query .= " WHERE ".$where_auto;
311 $query .= " ORDER BY $order_by";
313 $query .= " ORDER BY documents.document_name";
318 function get_list_view_data() {
319 global $current_language;
320 $app_list_strings = return_app_list_strings_language($current_language);
322 $document_fields = $this->get_list_view_array();
324 $this->fill_in_additional_list_fields();
327 $document_fields['FILENAME'] = $this->filename;
328 $document_fields['FILE_URL'] = $this->file_url;
329 $document_fields['FILE_URL_NOIMAGE'] = $this->file_url_noimage;
330 $document_fields['LAST_REV_CREATED_BY'] = $this->last_rev_created_name;
331 $document_fields['CATEGORY_ID'] = empty ($this->category_id) ? "" : $app_list_strings['document_category_dom'][$this->category_id];
332 $document_fields['SUBCATEGORY_ID'] = empty ($this->subcategory_id) ? "" : $app_list_strings['document_subcategory_dom'][$this->subcategory_id];
333 $document_fields['NAME'] = $this->document_name;
334 $document_fields['DOCUMENT_NAME_JAVASCRIPT'] = $GLOBALS['db']->helper->escape_quote($document_fields['DOCUMENT_NAME']);
335 return $document_fields;
337 function mark_relationships_deleted($id) {
338 //do nothing, this call is here to avoid default delete processing since
339 //delete.php handles deletion of document revisions.
342 function bean_implements($interface) {
343 switch ($interface) {
351 function get_document_name($doc_id){
352 if (empty($doc_id)) return null;
354 $db = DBManagerFactory::getInstance();
355 $query="select document_name from documents where id='$doc_id'";
356 $result=$db->query($query);
357 if (!empty($result)) {
358 $row=$db->fetchByAssoc($result);
360 return $row['document_name'];
367 require_once('modules/Documents/DocumentExternalApiDropDown.php');