<?php
/*+***********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.0
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is:  vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 *************************************************************************************/
vimport('~~modules/PickList/DependentPickListUtils.php');

class Settings_PickListDependency_Record_Model extends Settings_Vtiger_Record_Model {

    private $mapping = false;
    private $sourcePickListValues = false;
    private $targetPickListValues = false;
    private $nonMappedSourcePickListValues = false;

    /**
	 * Function to get the Id
	 * @return <Number>
	 */
	public function getId() {
		return '';
	}

	public function getName() {
		return '';
	}
    
    public function getRecordLinks() {
        $soureModule = $this->get('sourceModule');
        $sourceField = $this->get('sourcefield');
        $targetField = $this->get('targetfield');
        $editLink = array(
            'linkurl' => "javascript:Settings_PickListDependency_Js.triggerEdit(event, '$soureModule', '$sourceField', '$targetField')",
            'linklabel' => 'LBL_EDIT',
            'linkicon' => 'icon-pencil'
        );
        $editLinkInstance = Vtiger_Link_Model::getInstanceFromValues($editLink);
        
        $deleteLink = array(
            'linkurl' => "javascript:Settings_PickListDependency_Js.triggerDelete(event, '$soureModule','$sourceField', '$targetField')",
            'linklabel' => 'LBL_DELETE',
            'linkicon' => 'icon-trash'
        );
        $deleteLinkInstance = Vtiger_Link_Model::getInstanceFromValues($deleteLink);
        return array($editLinkInstance,$deleteLinkInstance);
    }
    
    public function getAllPickListFields() {
		$db = PearDatabase::getInstance();
		$tabId = getTabid($this->get('sourceModule'));

		$query="select vtiger_field.fieldlabel,vtiger_field.fieldname FROM vtiger_field" .
				" where displaytype=1 and vtiger_field.tabid=? and vtiger_field.uitype in ('15','16') " .
				" and vtiger_field.presence in (0,2)";

		$result = $db->pquery($query, array($tabId));
		$noofrows = $db->num_rows($result);

		$fieldlist = array();
		if($noofrows > 0) {
			for($i=0; $i<$noofrows; ++$i) {
				$fieldlist[$db->query_result($result,$i,"fieldname")] = $db->query_result($result,$i,"fieldlabel");
			}
		}
		return $fieldlist;
    }
    
	public function getPickListDependency() {
        if(empty($this->mapping)) {
            $dependency = Vtiger_DependencyPicklist::getPickListDependency($this->get('sourceModule'), $this->get('sourcefield'), $this->get('targetfield'));
            $this->mapping = $dependency['valuemapping'];
        }
		return $this->mapping;
	}
    
    private function getPickListValues($fieldName) {
		//Need to decode the picklist values twice which are saved from old ui
        return array_map('decode_html', getAllPickListValues($fieldName));
    }
    
    public function getSourcePickListValues() {
        if(empty($this->sourcePickListValues)) {
            $this->sourcePickListValues = $this->getPickListValues($this->get('sourcefield'));
        }
        return $this->sourcePickListValues;
    }
    
    public function getTargetPickListValues() {
        if(empty($this->targetPickListValues)) {
            $this->targetPickListValues = $this->getPickListValues($this->get('targetfield'));
        }
        return $this->targetPickListValues;
    }
    
    public function getNonMappedSourcePickListValues() {
        if(empty($this->nonMappedSourcePickListValues)) {
            $sourcePickListValues = $this->getSourcePickListValues();
            $dependencyMapping = $this->getPickListDependency();
            foreach($dependencyMapping as $mappingDetails) {
                unset($sourcePickListValues[$mappingDetails['sourcevalue']]);
            }
            $this->nonMappedSourcePickListValues =  $sourcePickListValues;
        }
        return $this->nonMappedSourcePickListValues;
    }
    
    public function save($mapping) {
        $dependencyMap = array();
        $dependencyMap['sourcefield'] = $this->get('sourcefield');
        $dependencyMap['targetfield'] = $this->get('targetfield');
        $dependencyMap['valuemapping'] = $mapping;
        Vtiger_DependencyPicklist::savePickListDependencies($this->get('sourceModule'), $dependencyMap);
        return true;
    }
    
    public function delete() {
        Vtiger_DependencyPicklist::deletePickListDependencies($this->get('sourceModule'), $this->get('sourcefield'), $this->get('targetfield'));
        return true;
    }
	
	private function loadFieldLabels()  {
		$db = PearDatabase::getInstance();
		
		$tabId = getTabid($this->get('sourceModule'));
		$fieldNames = array($this->get('sourcefield'),$this->get('targetfield'));
		
		$query = 'SELECT fieldlabel,fieldname FROM vtiger_field WHERE fieldname IN ('.generateQuestionMarks($fieldNames).') AND tabid = ?';
		$params = array($fieldNames, $tabId);
		$result = $db->pquery($query, $params);
		$num_rows = $db->num_rows($result);
		for($i=0; $i<$num_rows; $i++) {
			$row = $db->query_result_rowdata($result,$i);
			$fieldName = $row['fieldname'];
			if($fieldName == $this->get('sourcefield')) {
				$this->set('sourcelabel', $row['fieldlabel']);
			}else{
				$this->set('targetlabel', $row['fieldlabel']);
			}
		}
	}
	
	public function getSourceFieldLabel() {
		$sourceFieldLabel = $this->get('sourcelabel');
		if(empty($sourceFieldLabel)) {
			$this->loadFieldLabels();
		}
		return vtranslate($this->get('sourcelabel'), $this->get('sourceModule'));
	}
	
	public function getTargetFieldLabel() {
		$targetFieldLabel = $this->get('targetlabel');
		if(empty($targetFieldLabel)) {
			$this->loadFieldLabels();
		}
		return vtranslate($this->get('targetlabel'), $this->get('sourceModule'));
	}
    
	public static function getInstance($module, $sourceField, $targetField) {
		$self = new self();
		$self->set('sourceModule', $module)
            ->set('sourcefield', $sourceField)
            ->set('targetfield', $targetField);
		return $self;
	}

}