3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero General Public License version 3 as published by the
9 * Free Software Foundation with the addition of the following permission added
10 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
14 * This program is distributed in the hope that it will be useful, but WITHOUT
15 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
19 * You should have received a copy of the GNU Affero General Public License along with
20 * this program; if not, see http://www.gnu.org/licenses or write to the Free
21 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
27 * The interactive user interfaces in modified source and object code versions
28 * of this program must display Appropriate Legal Notices, as required under
29 * Section 5 of the GNU Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32 * these Appropriate Legal Notices must retain the display of the "Powered by
33 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34 * technical reasons, the Appropriate Legal Notices must display the words
35 * "Powered by SugarCRM".
36 ********************************************************************************/
39 require_once('data/SugarBean.php');
40 require_once('modules/Accounts/Account.php');
42 class FixUpFormattingTest extends Sugar_PHPUnit_Framework_TestCase
46 public function setUp()
48 $GLOBALS['current_user'] = SugarTestUserUtilities::createAnonymousUser();
50 $this->myBean = new SugarBean();
52 $this->myBean->field_defs = array(
53 'id' => array('name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, ),
54 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'required' => true, ),
55 'bool_field' => array('name' => 'bool_field', 'vname' => 'LBL_BOOL_FIELD', 'type' => 'bool', ),
56 'int_field' => array('name' => 'int_field', 'vname' => 'LBL_INT_FIELD', 'type' => 'int', ),
57 'float_field' => array('name' => 'float_field', 'vname' => 'LBL_FLOAT_FIELD', 'type' => 'float', 'precision' => 2, ),
58 'date_field' => array('name' => 'date_field', 'vname' => 'LBL_DATE_FIELD', 'type' => 'date', ),
59 'time_field' => array('name' => 'time_field', 'vname' => 'LBL_TIME_FIELD', 'type' => 'time', ),
60 'datetime_field' => array('name' => 'datetime_field', 'vname' => 'LBL_DATETIME_FIELD', 'type' => 'datetime', ),
63 $this->myBean->id = 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa';
64 $this->myBean->name = 'Fake Bean';
65 $this->myBean->bool_field = 1;
66 $this->myBean->int_field = 2001;
67 $this->myBean->float_field = 20.01;
68 $this->myBean->date_field = '2001-07-28';
69 $this->myBean->time_field = '21:19:37';
70 $this->myBean->datetime_field = '2001-07-28 21:19:37';
74 public function tearDown()
76 SugarTestUserUtilities::removeAllCreatedAnonymousUsers();
77 unset($GLOBALS['current_user']);
78 unset($this->time_date);
81 public function providerBoolFixups()
102 * @dataProvider providerBoolFixups
104 public function testBoolFixups($from, $to)
106 $this->myBean->bool_field = $from;
107 $this->myBean->fixUpFormatting();
108 $this->assertEquals($to,$this->myBean->bool_field,'fixUpFormatting did not adjust from ('.gettype($from).') "'.$from.'"');
114 public function testStringNULLFixups()
116 $bean = new SugarBean();
118 $bean->field_defs = array('date_field'=>array('type'=>'date'),
119 'datetime_field'=>array('type'=>'datetime'),
120 'time_field'=>array('type'=>'time'),
121 'datetimecombo_field'=>array('type'=>'datetimecombo')
123 $bean->date_field = 'NULL';
124 $bean->datetime_field = 'NULL';
125 $bean->time_field = 'NULL';
126 $bean->datetimecombo_field = 'NULL';
127 $bean->fixUpFormatting();
128 $this->assertEquals('', $bean->date_field,'fixUpFormatting did not reset string NULL for date');
129 $this->assertEquals('', $bean->datetime_field,'fixUpFormatting did not reset string NULL for time');
130 $this->assertEquals('', $bean->time_field,'fixUpFormatting did not reset string NULL for datetime');
131 $this->assertEquals('', $bean->datetimecombo_field,'fixUpFormatting did not reset string NULL for datetimecombo');