<?php
/*********************************************************************************
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/

 
require_once("modules/Accounts/Account.php");

class Bug34993Test extends Sugar_PHPUnit_Framework_TestCase
{
    private $_tablename;
    private $_old_installing;

    public function setUp()
    {
        $this->accountMockBean = $this->getMock('Account' , array('hasCustomFields'));
        $this->_tablename = 'test' . date("YmdHis");
        if ( isset($GLOBALS['installing']) )
        {
            $this->_old_installing = $GLOBALS['installing'];
        }
        $GLOBALS['installing'] = true;

        $GLOBALS['db']->createTableParams($this->_tablename . '_cstm',
            array(
                'id_c' => array (
                    'name' => 'id_c',
                    'type' => 'id',
                    ),                 
                ),
            array()
            );
        $GLOBALS['db']->query("INSERT INTO {$this->_tablename}_cstm (id_c) VALUES ('12345')");
        
        //Safety check in case the previous run had failed
        $GLOBALS['db']->query("DELETE FROM fields_meta_data WHERE id in ('Accountsbug34993_test_c', 'Accountsbug34993_test2_c')");
    }

    public function tearDown()
    {
        $GLOBALS['db']->dropTableName($this->_tablename . '_cstm');
        $GLOBALS['db']->query("DELETE FROM fields_meta_data WHERE id in ('Accountsbug34993_test_c', 'Accountsbug34993_test2_c')");
        if ( isset($this->_old_installing) ) {
            $GLOBALS['installing'] = $this->_old_installing;
        } else {
            unset($GLOBALS['installing']);
        }
        
        if(file_exists('custom/Extension/modules/Accounts/Ext/Vardefs/sugarfield_bug34993_test_c.php'))
        {
           unlink('custom/Extension/modules/Accounts/Ext/Vardefs/sugarfield_bug34993_test_c.php');
        }
        
        if(file_exists('custom/Extension/modules/Accounts/Ext/Vardefs/sugarfield_bug34993_test2_c.php'))
        {
           unlink('custom/Extension/modules/Accounts/Ext/Vardefs/sugarfield_bug34993_test2_c.php');
        }
        
        VardefManager::clearVardef('Accounts', 'Account');
        VardefManager::refreshVardefs('Accounts', 'Account');
    }

    public function testCustomFieldDefaultValue()
    {
    	require_once('modules/DynamicFields/templates/Fields/TemplateText.php');
    	require_once('modules/DynamicFields/DynamicField.php');
    	require_once('modules/DynamicFields/FieldCases.php');
    	
    	//Simulate create a custom text field with a default value set to 123
    	$templateText = get_widget('varchar');
    	$templateText->type = 'varchar';
    	$templateText->view = 'edit';
    	$templateText->label = 'CUSTOM TEST';
    	$templateText->name = 'bug34993_test';
    	$templateText->size = 20;
    	$templateText->len = 255;
    	$templateText->required = false;
    	$templateText->default = '123';
    	$templateText->default_value = '123';
    	$templateText->comment = '';
    	$templateText->audited = 0;
    	$templateText->massupdate = 0;
    	$templateText->importable = true;
    	$templateText->duplicate_merge = 0;
    	$templateText->reportable = 1;
        $templateText->ext1 = NULL;
        $templateText->ext2 = NULL;
        $templateText->ext3 = NULL;
        $templateText->ext4 = NULL;    	
    	
        $bean = $this->accountMockBean;
        $bean->custom_fields = new DynamicField($bean->module_dir);
        $bean->custom_fields->setup($bean);
   
        $bean->expects($this->any())
             ->method('hasCustomFields')
             ->will($this->returnValue(true));
        $bean->table_name = $this->_tablename;
        $bean->id = '12345';
        $bean->custom_fields->addFieldObject($templateText);        
        $bean->custom_fields->retrieve();
        $this->assertEquals($bean->id_c, '12345', "Assert that the custom table exists");
        $this->assertEquals($bean->bug34993_test_c, NULL, "Assert that the custom text field has a default value set to NULL");
        
        
    	//Simulate create a custom text field with a default value set to 123
    	$templateText = get_widget('enum');
    	$templateText->type = 'enum';
    	$templateText->view = 'edit';
    	$templateText->label = 'CUSTOM TEST2';
    	$templateText->name = 'bug34993_test2';
    	$templateText->size = 20;
    	$templateText->len = 255;
    	$templateText->required = false;
    	$templateText->default = '123';
    	$templateText->default_value = '123';
    	$templateText->comment = '';
    	$templateText->audited = 0;
    	$templateText->massupdate = 0;
    	$templateText->importable = true;
    	$templateText->duplicate_merge = 0;
    	$templateText->reportable = 1;
        $templateText->ext1 = 'account_type_dom';
        $templateText->ext2 = NULL;
        $templateText->ext3 = NULL;
        $templateText->ext4 = NULL;    	
    	
        $bean = $this->accountMockBean;
        $bean->custom_fields = new DynamicField($bean->module_dir);
        $bean->custom_fields->setup($bean);
   
        $bean->expects($this->any())
             ->method('hasCustomFields')
             ->will($this->returnValue(true));
        $bean->table_name = $this->_tablename;
        $bean->id = '12345';
        $bean->custom_fields->addFieldObject($templateText);        
        $bean->custom_fields->retrieve();
        $this->assertEquals($bean->id_c, '12345', "Assert that the custom table exists");
        $this->assertEquals($bean->bug34993_test2_c, NULL, "Assert that the custom enum field has a default value set to NULL");        
    }
}