<?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.
*
********************************************************************************/
require_once('Smarty_setup.php');
require_once('include/database/PearDatabase.php');
require_once('include/CustomFieldUtil.php');
require_once 'include/Webservices/DescribeObject.php';
global $mod_strings, $app_strings;

$smarty = new vtigerCRM_Smarty;
global $theme;
$theme_path = "themes/" . $theme . "/";
$image_path = $theme_path . "images/";
$smarty->assign("IMAGE_PATH", $image_path);

/**
 * Function to get leads mapping custom fields
 * return array   $leadcf - mapping custom fields
 */
function customFieldMappings() {
	global $adb;
	$tabid = getTabid('Leads');
	$convert_sql = "SELECT vtiger_convertleadmapping.*,uitype,fieldlabel,typeofdata,fieldid FROM vtiger_field  LEFT JOIN vtiger_convertleadmapping
				ON vtiger_field.fieldid = vtiger_convertleadmapping.leadfid
				WHERE tabid=?
				AND vtiger_field.presence IN (0,2)
				AND vtiger_field.fieldname NOT IN('assigned_user_id','createdtime','modifiedtime','lead_no','modifiedby','campaignrelstatus')
				ORDER BY vtiger_field.fieldlabel";
	$convert_result = $adb->pquery($convert_sql, array($tabid));

	$no_rows = $adb->num_rows($convert_result);
	for ($j = 0; $j < $no_rows; $j++) {
		$lead_field_id = $adb->query_result($convert_result, $j, "fieldlabel");
		if (!empty($lead_field_id)) {

			$cfmid = $adb->query_result($convert_result, $j, "cfmid");
			$accountid = $adb->query_result($convert_result, $j, "accountfid");
			$contactid = $adb->query_result($convert_result, $j, "contactfid");
			$potentialid = $adb->query_result($convert_result, $j, "potentialfid");
			if ((empty($accountid) && empty($contactid) && empty($potentialid))) {
				$lead_field['display'] = 'false';
			} else {
				$lead_field['display'] = 'true';
			}
			$lead_field['editable'] = $adb->query_result($convert_result, $j, "editable");
			$lead_field['cfmid'] = $cfmid;
			$lead_field['cfmname'] = $cfmid . '_cfmid';
			$lead_field['fieldid'] = $adb->query_result($convert_result, $j, "fieldid");
			$lead_field['leadid'] = getTranslatedString($adb->query_result($convert_result, $j, "fieldlabel"), 'Leads');
			$lead_field['typeofdata'] = $adb->query_result($convert_result, $j, "typeofdata");
			$lead_field['fieldtype'] = getCustomFieldTypeName($adb->query_result($convert_result, $j, "uitype"));
			$lead_field['account'] = getModuleValues( $accountid, 'Accounts');
			$lead_field['contact'] = getModuleValues( $contactid, 'Contacts');
			$lead_field['potential'] = getModuleValues( $potentialid, 'Potentials');
			$lead_field['lead'] = getModuleValues( null, 'Leads');

			if (empty($accountid) && empty($contactid) && empty($potentialid)) {
				$lead_field['display'] = 'false';
			} else {
				$lead_field['display'] = 'true';
			}
			$leadcf[] = $lead_field;
		}
	}
	return $leadcf;
}

/*
 * function to get all the field in given module, with the corresponding field mapping
 */

function getModuleValues( $moduleid, $module) {
	global $adb;
	$potentialcf = Array();
	switch($module){
		case "Accounts":$sql="SELECT fieldid,fieldlabel,uitype,typeofdata,fieldname FROM vtiger_field,vtiger_tab WHERE vtiger_field.tabid=vtiger_tab.tabid
						AND generatedtype IN (1,2)
						AND vtiger_tab.name=?
						AND vtiger_field.fieldname NOT IN('assigned_user_id','createdtime','modifiedtime','lead_no','modifiedby','campaignrelstatus','account_no','account_id','contact_no','contact_id','imagename','potential_no','related_to','campaignid','accountname','email1')
						AND vtiger_field.presence in (0,2)";
				break;
		case "Contacts":$sql="SELECT fieldid,fieldlabel,uitype,typeofdata,fieldname FROM vtiger_field,vtiger_tab WHERE vtiger_field.tabid=vtiger_tab.tabid
						AND generatedtype IN (1,2)
						AND vtiger_tab.name=?
						AND vtiger_field.fieldname NOT IN('assigned_user_id','createdtime','modifiedtime','lead_no','modifiedby','campaignrelstatus','account_no','account_id','contact_no','contact_id','imagename','potential_no','related_to','campaignid','firstname','email','lastname')
						AND vtiger_field.presence in (0,2)";
				break;
		case "Potentials":$sql="SELECT fieldid,fieldlabel,uitype,typeofdata,fieldname FROM vtiger_field,vtiger_tab WHERE vtiger_field.tabid=vtiger_tab.tabid
						AND generatedtype IN (1,2)
						AND vtiger_tab.name=?
						AND vtiger_field.fieldname NOT IN('assigned_user_id','createdtime','modifiedtime','lead_no','modifiedby','campaignrelstatus','account_no','account_id','contact_no','contact_id','imagename','potential_no','related_to','campaignid','potentialname')
						AND vtiger_field.presence in (0,2)";
				break;
		case 'Leads': $sql="SELECT fieldid,fieldlabel,uitype,typeofdata,fieldname FROM vtiger_field,vtiger_tab WHERE vtiger_field.tabid=vtiger_tab.tabid
						AND generatedtype IN (1,2)
						AND vtiger_tab.name=?
						AND vtiger_field.fieldname NOT IN('assigned_user_id','createdtime','modifiedtime','lead_no','modifiedby','campaignrelstatus')
						AND vtiger_field.presence in (0,2)";
				break;
	}
	
	$result = $adb->pquery($sql, array($module));
	$noofrows = $adb->num_rows($result);
	for ($i = 0; $i < $noofrows; $i++) {
		$module_field['fieldid'] = $adb->query_result($result, $i, "fieldid");
		$module_field['fieldlabel'] = getTranslatedString($adb->query_result($result, $i, "fieldlabel"), $module);
		$module_field['typeofdata'] = $adb->query_result($result, $i, "typeofdata");
		$module_field['fieldtype'] = getCustomFieldTypeName($adb->query_result($result, $i, "uitype"));

		if ($module_field['fieldid'] == $moduleid)
			$module_field['selected'] = "selected";
		else
			$module_field['selected'] = "";

		$module_cfelement[] = $module_field;
	}

	return $module_cfelement;
}

$module = 'Leads';
$smarty->assign("MOD", $mod_strings);
$smarty->assign("APP", $app_strings);
$smarty->assign("THEME", $theme);
$smarty->assign("CUSTOMFIELDMAPPING", customFieldMappings());
$smarty->assign("MODULE", $module);
$smarty->display("CustomFieldMapping.tpl");
?>