2 /*********************************************************************************
3 * SugarCRM Community Edition is a customer relationship management program developed by
4 * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
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.
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
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
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.
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.
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 ********************************************************************************/
38 require_once('include/SearchForm/SearchForm2.php');
40 class Bug48623Test extends Sugar_PHPUnit_Framework_TestCase
43 public function setUp()
45 $GLOBALS['current_user'] = SugarTestUserUtilities::createAnonymousUser();
46 $GLOBALS['current_user']->setPreference('timezone', 'EDT');
49 public function tearDown()
51 unset($GLOBALS['current_user']);
52 SugarTestUserUtilities::removeAllCreatedAnonymousUsers();
56 * @dataProvider dateTestProvider
58 public function testParseDateExpressionWithAndWithoutTimezoneAdjustment($expected1, $expected2, $operator, $type) {
61 $seed = new Opportunity();
62 $sf = new SearchForm2Wrap($seed, 'Opportunities', 'index');
64 $where = $sf->publicParseDateExpression($operator, 'opportunities.date_closed', $type);
65 $this->assertRegExp($expected1, $where);
66 $this->assertRegExp($expected2, $where);
69 public function dateTestProvider() {
70 $noTzRegExp1 = '/\'[0-9]{4}-[0-9]{2}-[0-9]{2} 00:00:00\'/';
71 $noTzRegExp2 = '/\'[0-9]{4}-[0-9]{2}-[0-9]{2} 23:59:59\'/';
72 $tzRegExp1 = '/\'[0-9]{4}-[0-9]{2}-[0-9]{2} 0[4,5]:00:00\'/';
73 $tzRegExp2 = '/\'[0-9]{4}-[0-9]{2}-[0-9]{2} 0[3,4]:59:59\'/';
75 // $expected1, expected2, $operator, $type
76 array($noTzRegExp1, $noTzRegExp2, 'this_month', 'date'),
77 array($noTzRegExp1, $noTzRegExp2, 'last_month', 'date'),
78 array($noTzRegExp1, $noTzRegExp2, 'next_month', 'date'),
79 array($noTzRegExp1, $noTzRegExp2, 'this_year', 'date'),
80 array($noTzRegExp1, $noTzRegExp2, 'last_year', 'date'),
81 array($noTzRegExp1, $noTzRegExp2, 'next_year', 'date'),
82 array($noTzRegExp1, $noTzRegExp2, 'yesterday', 'date'),
83 array($noTzRegExp1, $noTzRegExp2, 'today', 'date'),
84 array($noTzRegExp1, $noTzRegExp2, 'tomorrow', 'date'),
85 array($noTzRegExp1, $noTzRegExp2, 'last_7_days', 'date'),
86 array($noTzRegExp1, $noTzRegExp2, 'next_7_days', 'date'),
87 array($noTzRegExp1, $noTzRegExp2, 'last_30_days', 'date'),
88 array($noTzRegExp1, $noTzRegExp2, 'next_30_days', 'date'),
90 array($tzRegExp1, $tzRegExp2, 'this_month', 'datetime'),
91 array($tzRegExp1, $tzRegExp2, 'last_month', 'datetime'),
92 array($tzRegExp1, $tzRegExp2, 'next_month', 'datetime'),
93 array($tzRegExp1, $tzRegExp2, 'this_year', 'datetime'),
94 array($tzRegExp1, $tzRegExp2, 'last_year', 'datetime'),
95 array($tzRegExp1, $tzRegExp2, 'next_year', 'datetime'),
96 array($tzRegExp1, $tzRegExp2, 'yesterday', 'datetime'),
97 array($tzRegExp1, $tzRegExp2, 'today', 'datetime'),
98 array($tzRegExp1, $tzRegExp2, 'tomorrow', 'datetime'),
99 array($tzRegExp1, $tzRegExp2, 'last_7_days', 'datetime'),
100 array($tzRegExp1, $tzRegExp2, 'next_7_days', 'datetime'),
101 array($tzRegExp1, $tzRegExp2, 'last_30_days', 'datetime'),
102 array($tzRegExp1, $tzRegExp2, 'next_30_days', 'datetime'),
110 * Wrap the SearchForm class to make a protected function public
112 class SearchForm2Wrap extends SearchForm {
113 public function publicParseDateExpression($operator, $db_field, $field_type) {
114 return $this->parseDateExpression($operator, $db_field, $field_type);