include/SugarFields/Fields/Datetime/SugarFieldDatetime.php

   1 <?php
   2 /*********************************************************************************
   3  * SugarCRM Community Edition is a customer relationship management program developed by
   4  * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
   5  *
   6  * This program is free software; you can redistribute it and/or modify it under
   7  * the terms of the GNU Affero General Public License version 3 as published by the
   8  * Free Software Foundation with the addition of the following permission added
   9  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  10  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  11  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  12  *
  13  * This program is distributed in the hope that it will be useful, but WITHOUT
  14  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  15  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  16  * details.
  17  *
  18  * You should have received a copy of the GNU Affero General Public License along with
  19  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  20  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  21  * 02110-1301 USA.
  22  *
  23  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  24  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  25  *
  26  * The interactive user interfaces in modified source and object code versions
  27  * of this program must display Appropriate Legal Notices, as required under
  28  * Section 5 of the GNU Affero General Public License version 3.
  29  *
  30  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  31  * these Appropriate Legal Notices must retain the display of the "Powered by
  32  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  33  * technical reasons, the Appropriate Legal Notices must display the words
  34  * "Powered by SugarCRM".
  35  ********************************************************************************/
  36
  37 require_once('include/SugarFields/Fields/Base/SugarFieldBase.php');
  38
  39 class SugarFieldDatetime extends SugarFieldBase {
  40
  41     function getEditViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex) {
  42
  43         // Create Smarty variables for the Calendar picker widget
  44         if(!isset($displayParams['showMinutesDropdown'])) {
  45            $displayParams['showMinutesDropdown'] = false;
  46         }
  47
  48         if(!isset($displayParams['showHoursDropdown'])) {
  49            $displayParams['showHoursDropdown'] = false;
  50         }
  51
  52         if(!isset($displayParams['showNoneCheckbox'])) {
  53            $displayParams['showNoneCheckbox'] = false;
  54         }
  55
  56         if(!isset($displayParams['showFormats'])) {
  57            $displayParams['showFormats'] = false;
  58         }
  59
  60         if(!isset($displayParams['hiddeCalendar'])) {
  61            $displayParams['hiddeCalendar'] = false;
  62         }
  63
  64         $this->setup($parentFieldArray, $vardef, $displayParams, $tabindex);
  65         //jchi , bug #24557 , 10/31/2008
  66         if(isset($vardef['name']) && ($vardef['name'] == 'date_entered' || $vardef['name'] == 'date_modified')){
  67                 return $this->fetch($this->findTemplate('DetailView'));
  68         }
  69         //end
  70         return $this->fetch($this->findTemplate('EditView'));
  71     }
  72
  73     function getImportViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex)
  74     {
  75         $displayParams['showMinutesDropdown'] = false;
  76         $displayParams['showHoursDropdown'] = false;
  77         $displayParams['showNoneCheckbox'] = false;
  78         $displayParams['showFormats'] = true;
  79         $displayParams['hiddeCalendar'] = false;
  80
  81         $this->setup($parentFieldArray, $vardef, $displayParams, $tabindex);
  82         return $this->fetch($this->findTemplate('EditView'));
  83     }
  84
  85
  86     function getSearchViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex) {
  87         if($this->isRangeSearchView($vardef)) {
  88            $this->setup($parentFieldArray, $vardef, $displayParams, $tabindex);
  89            $id = isset($displayParams['idName']) ? $displayParams['idName'] : $vardef['name'];
  90            $this->ss->assign('original_id', "{$id}");
  91            $this->ss->assign('id_range', "range_{$id}");
  92            $this->ss->assign('id_range_start', "start_range_{$id}");
  93            $this->ss->assign('id_range_end', "end_range_{$id}");
  94            $this->ss->assign('id_range_choice', "{$id}_range_choice");
  95            if(file_exists('custom/include/SugarFields/Fields/Datetimecombo/RangeSearchForm.tpl'))
  96            {
  97               return $this->fetch('custom/include/SugarFields/Fields/Datetimecombo/RangeSearchForm.tpl');
  98            }
  99            return $this->fetch('include/SugarFields/Fields/Datetimecombo/RangeSearchForm.tpl');
 100         }
 101         return $this->getSmartyView($parentFieldArray, $vardef, $displayParams, $tabindex, 'EditView');
 102     }
 103
 104     public function getEmailTemplateValue($inputField, $vardef, $context = null){
 105         global $timedate;
 106         // This does not return a smarty section, instead it returns a direct value
 107         if(isset($context['notify_user'])) {
 108             $user = $context['notify_user'];
 109         } else {
 110             $user = $GLOBALS['current_user'];
 111         }
 112         if($vardef['type'] == 'date') {
 113             if(!$timedate->check_matching_format($inputField, TimeDate::DB_DATE_FORMAT)) {
 114                 return $inputField;
 115             }
 116             // convert without TZ
 117             return $timedate->to_display($inputField, $timedate->get_db_date_format(),  $timedate->get_date_format($user));
 118         } else {
 119             if(!$timedate->check_matching_format($inputField, TimeDate::DB_DATETIME_FORMAT)) {
 120                 return $inputField;
 121             }
 122             return $timedate->to_display_date_time($inputField, true, true, $user);
 123         }
 124     }
 125
 126     public function save($bean, $inputData, $field, $def, $prefix = '') {
 127         global $timedate;
 128         if ( !isset($inputData[$prefix.$field]) ) {
 129             return;
 130         }
 131
 132         $offset = strlen(trim($inputData[$prefix.$field])) < 11 ? false : true;
 133         if ($timedate->check_matching_format($inputData[$prefix.$field], TimeDate::DB_DATE_FORMAT)) {
 134             $bean->$field = $inputData[$prefix.$field];
 135         } else {
 136             $bean->$field = $timedate->to_db_date($inputData[$prefix.$field], $offset);
 137         }
 138     }
 139
 140     /**
 141      * @see SugarFieldBase::importSanitize()
 142      */
 143     public function importSanitize(
 144         $value,
 145         $vardef,
 146         $focus,
 147         ImportFieldSanitize $settings
 148         )
 149     {
 150         global $timedate;
 151
 152         $format = $timedate->merge_date_time($settings->dateformat, $settings->timeformat);
 153
 154         if ( !$timedate->check_matching_format($value, $format) ) {
 155             $parts = $timedate->split_date_time($value);
 156             if(empty($parts[0])) {
 157                $datepart = $timedate->getNow()->format($settings->dateformat);
 158             }
 159             else {
 160                $datepart = $parts[0];
 161             }
 162             if(empty($parts[1])) {
 163                 $timepart = $timedate->fromTimestamp(0)->format($settings->timeformat);
 164             } else {
 165                 $timepart = $parts[1];
 166                 // see if we can get by stripping the seconds
 167                 if(strpos($settings->timeformat, 's') === false) {
 168                     $sep = $timedate->timeSeparatorFormat($settings->timeformat);
 169                     // We are assuming here seconds are the last component, which
 170                     // is kind of reasonable - no sane time format puts seconds first
 171                     $timeparts = explode($sep, $timepart);
 172                     if(!empty($timeparts[2])) {
 173                         $timepart = join($sep, array($timeparts[0], $timeparts[1]));
 174                     }
 175                 }
 176             }
 177
 178             $value = $timedate->merge_date_time($datepart, $timepart);
 179             if ( !$timedate->check_matching_format($value, $format) ) {
 180                 return false;
 181             }
 182         }
 183
 184         try {
 185             $date = SugarDateTime::createFromFormat($format, $value, new DateTimeZone($settings->timezone));
 186         } catch(Exception $e) {
 187             return false;
 188         }
 189         return $date->asDb();
 190     }
 191
 192
 193     function getDetailViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex) {
 194         global $timedate,$current_user;
 195
 196         //check to see if the date is in the proper format
 197         $user_dateFormat = $timedate->get_date_format();
 198         if(!empty($vardef['value']) && !$timedate->check_matching_format( $vardef['value'],$user_dateFormat)){
 199
 200             //date is not in proper user format, so get the SugarDateTiemObject and inject the vardef with a new element
 201             $sdt = $timedate->fromString($vardef['value'],$current_user);
 202
 203             if (!empty($sdt))
 204             {
 205                 //the new 'date_formatted_value' array element will be used in include/SugarFields/Fields/Datetime/DetailView.tpl if it exists
 206                 $vardef['date_formatted_value'] = $timedate->asUserDate($sdt,$current_user);
 207             }
 208
 209         }
 210
 211         return $this->getSmartyView($parentFieldArray, $vardef, $displayParams, $tabindex, 'DetailView');
 212     }
 213 }