Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.
 All Data Structures Functions Variables Pages
DateTimeSanitizerUtil.php
1 <?php
2  /*********************************************************************************
3  * Zurmo is a customer relationship management program developed by
4  * Zurmo, Inc. Copyright (C) 2017 Zurmo Inc.
5  *
6  * Zurmo 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 ZURMO, ZURMO DISCLAIMS THE WARRANTY
11  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
12  *
13  * Zurmo 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 Zurmo, Inc. with a mailing address at 27 North Wacker Drive
24  * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.
25  *
26  * The interactive user interfaces in original and modified 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 Zurmo
32  * logo and Zurmo copyright notice. If the display of the logo is not reasonably
33  * feasible for technical reasons, the Appropriate Legal Notices must display the words
34  * "Copyright Zurmo Inc. 2017. All rights reserved".
35  ********************************************************************************/
36 
41  {
45  public static function getAcceptableFormats()
46  {
47  return array(
48  'yyyy-MM-dd hh:mm',
49  'MM-dd-yyyy hh:mm',
50  'dd-MM-yyyy hh:mm',
51  'MM/dd/yyyy hh:mm',
52  'M/d/yyyy hh:mm',
53  'd/M/yyyy hh:mm',
54  'yyyy-M-d hh:mm',
55  'yyyy-M-d hh:mm:ss',
56  );
57  }
58 
59  public static function getLinkedMappingRuleType()
60  {
61  return 'ValueFormat';
62  }
63 
67  public function analyzeByRow(RedBean_OODBBean $rowBean)
68  {
69  if ($rowBean->{$this->columnName} != null &&
70  CDateTimeParser::parse($rowBean->{$this->columnName}, $this->mappingRuleData['format']) === false)
71  {
72  $label = Zurmo::t('ImportModule', 'Is an invalid date time format. This value will be skipped during import.');
73  $this->analysisMessages[] = $label;
74  }
75  }
76 
85  public function sanitizeValue($value)
86  {
87  if ($value == null)
88  {
89  return $value;
90  }
91  $timeStamp = CDateTimeParser::parse($value, $this->mappingRuleData['format']);
92  if ($timeStamp === false || !is_int($timeStamp))
93  {
94  throw new InvalidValueToSanitizeException(Zurmo::t('ImportModule', 'Invalid datetime format.'));
95  }
96  return DateTimeUtil::convertTimestampToDbFormatDateTime($timeStamp);
97  }
98 
99  protected function assertMappingRuleDataIsValid()
100  {
101  assert('isset($this->mappingRuleData["format"])');
102  }
103  }
104 ?>
analyzeByRow(RedBean_OODBBean $rowBean)
Generated on Mon Jul 6 2020 07:10:34
Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.