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-2011 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             // convert without TZ
 114             return $timedate->to_display($inputField, $timedate->get_db_date_format(),  $timedate->get_date_format($user));
 115         } else {
 116             return $timedate->to_display_date_time($inputField, true, true, $user);
 117         }
 118     }
 119
 120     public function save($bean, $inputData, $field, $def, $prefix = '') {
 121         global $timedate;
 122         if ( !isset($inputData[$prefix.$field]) ) {
 123             return;
 124         }
 125
 126         $offset = strlen(trim($inputData[$prefix.$field])) < 11 ? false : true;
 127         if ($timedate->check_matching_format($inputData[$prefix.$field], TimeDate::DB_DATE_FORMAT)) {
 128             $bean->$field = $inputData[$prefix.$field];
 129         } else {
 130             $bean->$field = $timedate->to_db_date($inputData[$prefix.$field], $offset);
 131         }
 132     }
 133
 134     /**
 135      * @see SugarFieldBase::importSanitize()
 136      */
 137     public function importSanitize(
 138         $value,
 139         $vardef,
 140         $focus,
 141         ImportFieldSanitize $settings
 142         )
 143     {
 144         global $timedate;
 145
 146         $format = $timedate->merge_date_time($settings->dateformat, $settings->timeformat);
 147
 148         if ( !$timedate->check_matching_format($value, $format) ) {
 149             $parts = $timedate->split_date_time($value);
 150             if(empty($parts[0])) {
 151                $datepart = $timedate->getNow()->format($settings->dateformat);
 152             }
 153             else {
 154                $datepart = $parts[0];
 155             }
 156             if(empty($parts[1])) {
 157                 $timepart = $timedate->fromTimestamp(0)->format($settings->timeformat);
 158             } else {
 159                 $timepart = $parts[1];
 160                 // see if we can get by stripping the seconds
 161                 if(strpos($settings->timeformat, 's') === false) {
 162                     $sep = $timedate->timeSeparatorFormat($settings->timeformat);
 163                     // We are assuming here seconds are the last component, which
 164                     // is kind of reasonable - no sane time format puts seconds first
 165                     $timeparts = explode($sep, $timepart);
 166                     if(!empty($timeparts[2])) {
 167                         $timepart = join($sep, array($timeparts[0], $timeparts[1]));
 168                     }
 169                 }
 170             }
 171
 172             $value = $timedate->merge_date_time($datepart, $timepart);
 173             if ( !$timedate->check_matching_format($value, $format) ) {
 174                 return false;
 175             }
 176         }
 177
 178         try {
 179             $date = SugarDateTime::createFromFormat($format, $value, new DateTimeZone($settings->timezone));
 180         } catch(Exception $e) {
 181             return false;
 182         }
 183         return $date->asDb();
 184     }
 185 }