<?php
/*********************************************************************************
 * By installing or using this file, you are confirming on behalf of the entity
 * subscribed to the SugarCRM Inc. product ("Company") that Company is bound by
 * the SugarCRM Inc. Master Subscription Agreement (“MSA”), which is viewable at:
 * http://www.sugarcrm.com/master-subscription-agreement
 *
 * If Company is not bound by the MSA, then by installing or using this file
 * you are agreeing unconditionally that Company will be bound by the MSA and
 * certifying that you have authority to bind Company accordingly.
 *
 * Copyright (C) 2004-2013 SugarCRM Inc.  All rights reserved.
 ********************************************************************************/


require_once 'modules/DynamicFields/FieldCases.php';

/**
 * Bug #56423
 * @ticket 56423
 */
class Bug56423Test extends Sugar_PHPUnit_Framework_TestCase
{
    /**
     * @var TemplateRelatedTextField
     */
    protected $accountFieldWidget;
    /**
     * @var DynamicField
     */
    protected $accountField;
    /**
     * @var TemplateRelatedTextField
     */
    protected $opportunityFieldWidget;
    /**
     * @var DynamicField
     */
    protected $opportunityField;

    public function setUp()
    {
        SugarTestHelper::setUp('beanList');
        SugarTestHelper::setUp('beanFiles');
        SugarTestHelper::setUp('app_strings');
        SugarTestHelper::setUp('app_list_strings');
        SugarTestHelper::setUp('mod_strings', array('ModuleBuilder'));
        SugarTestHelper::setUp('current_user', array(true, 1));

        $_POST = $_REQUEST = $this->getPostData();

        $this->accountFieldWidget = get_widget($_REQUEST['type']);
        $this->accountFieldWidget->populateFromPost();
        $module = $_REQUEST['view_module'];
        $this->accountField = new DynamicField($module);
        $class_name = $GLOBALS['beanList'][$module];
        require_once ($GLOBALS['beanFiles'][$class_name]);
        $mod = new $class_name();
        $this->accountField->setup($mod);
        $this->accountFieldWidget->save($this->accountField);

        $_POST['view_module'] = $_REQUEST['view_module'] = 'Opportunities';

        $this->opportunityFieldWidget = get_widget($_REQUEST['type']);
        $this->opportunityFieldWidget->populateFromPost();
        $module = $_REQUEST['view_module'];
        $this->opportunityField = new DynamicField($module);
        $class_name = $GLOBALS['beanList'][$module];
        require_once ($GLOBALS['beanFiles'][$class_name]);
        $mod = new $class_name();
        $this->opportunityField->setup($mod);
        $this->opportunityFieldWidget->save($this->opportunityField);

        $repair = new RepairAndClear();
        $repair->repairAndClearAll(array('rebuildExtensions', 'clearVardefs'),
                                   array($GLOBALS['beanList']['Accounts'], $GLOBALS['beanList']['Opportunities']),
                                   true,
                                   false);
    }

    public function getPostData()
    {
        return array (
            'module' => 'ModuleBuilder',
            'action' => 'saveField',
            'new_dropdown' => '',
            'to_pdf' => 'true',
            'view_module' => 'Accounts',
            'is_update' => 'true',
            'type' => 'relate',
            'name' => 'contact',
            'labelValue' => 'contact',
            'label' => 'LBL_CONTACT',
            'help' => '',
            'comments' => '',
            'ext2' => 'Contacts',
            'ext3' => '',
            'dependency' => '',
            'dependency_display' => '',
            'reportableCheckbox' => '1',
            'reportable' => '1',
            'importable' => 'true',
            'duplicate_merge' => '0',
        );
    } 

    public function tearDown()
    {
        if ($this->accountFieldWidget)
        {
            $this->accountFieldWidget->delete($this->accountField);
        }
        if ($this->opportunityFieldWidget)
        {
            $this->opportunityFieldWidget->delete($this->opportunityField);
        }

        $repair = new RepairAndClear();
        $repair->repairAndClearAll(array('rebuildExtensions', 'clearVardefs'),
                                   array($GLOBALS['beanList']['Accounts'], $GLOBALS['beanList']['Opportunities']),
                                   true,
                                   false);

        $_REQUEST = $_POST = array();
        SugarTestHelper::tearDown();
    }

    /**
     * Tests that 'create_new_list_query' creates query without duplicating
     * $vardef[id_name] column in select statement.
     */
    public function testListQuery()
    {
        $bean = BeanFactory::getBean('Accounts');
        $query = $bean->create_new_list_query(
            "accounts.name",
            "(accounts.name like 'A%')",
            array(),
            array(),
            0,
            "",
            true,
            NULL,
            false
        );
        $this->assertEquals(1, substr_count($query['select'], 'accounts_cstm.contact_id_c'));
    } 

}