YuCheng Hu
9cce682da9
yuchenghu@hawebs.net git-svn-id: https://svn.code.sf.net/p/hawebs/svn@618 a2543c7e-f6e9-4f8a-8bff-1ffc34733512
273 lines
12 KiB
PHP
273 lines
12 KiB
PHP
<?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('data/Tracker.php');
|
|
require_once('include/utils/utils.php');
|
|
require_once('include/utils/UserInfoUtil.php');
|
|
|
|
global $mod_strings,$app_strings,$log,$current_user,$theme;
|
|
|
|
$theme_path="themes/".$theme."/";
|
|
$image_path=$theme_path."images/";
|
|
|
|
if(isset($_REQUEST['record']))
|
|
{
|
|
$id = $_REQUEST['record'];
|
|
$log->debug(" the id is ".$id);
|
|
}
|
|
$category = getParentTab();
|
|
//Retreive lead details from database
|
|
$sql = "SELECT firstname, lastname, company, smownerid from vtiger_leaddetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_leaddetails.leadid where vtiger_leaddetails.leadid =?";
|
|
$result = $adb->pquery($sql, array($id));
|
|
$row = $adb->fetch_array($result);
|
|
|
|
//if company field is not present
|
|
if(getFieldVisibilityPermission('Leads',$current_user->id,'company') == '1'){
|
|
$row["company"] = '';
|
|
}
|
|
|
|
$firstname = $row["firstname"];
|
|
$lastname = $row["lastname"];
|
|
$company = $row["company"];
|
|
$potentialname = $row["company"] ."-";
|
|
$userid = $row["smownerid"];
|
|
|
|
//Retreiving the current user id
|
|
$modified_user_id = $current_user->id;
|
|
$log->info("Convert Lead view");
|
|
|
|
$date_format = parse_calendardate($app_strings['NTC_DATE_FORMAT']);
|
|
|
|
$roleid=$current_user->roleid;
|
|
$subrole = getRoleSubordinates($roleid);
|
|
if(count($subrole)> 0)
|
|
{
|
|
$roleids = $subrole;
|
|
array_push($roleids, $roleid);
|
|
}
|
|
else
|
|
{
|
|
$roleids = $roleid;
|
|
}
|
|
if($sortid != '') {
|
|
$sales_stage_query="select sales_stage from vtiger_sales_stage";
|
|
$params = array();
|
|
}
|
|
elseif($is_admin)
|
|
{
|
|
$sales_stage_query="select sales_stage from vtiger_sales_stage inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_sales_stage.picklist_valueid where roleid != 'H1' order by sortid";
|
|
$params = array();
|
|
}else
|
|
{
|
|
if (count($roleids) > 0) {
|
|
$sales_stage_query="select sales_stage from vtiger_sales_stage inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_sales_stage.picklist_valueid where roleid in (". generateQuestionMarks($roleids) .") and picklistid in (select picklistid from vtiger_sales_stage) order by sortid";
|
|
$params = array($roleids);
|
|
} else {
|
|
$sales_stage_query="select sales_stage from vtiger_sales_stage inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_sales_stage.picklist_valueid where picklistid in (select picklistid from vtiger_sales_stage) order by sortid";
|
|
$params = array();
|
|
}
|
|
}
|
|
$sales_stage_result = $adb->pquery($sales_stage_query, $params);
|
|
$noofsalesRows = $adb->num_rows($sales_stage_result);
|
|
$sales_stage_fld = '';
|
|
$sales_stage_list[] = array();
|
|
for($j = 0; $j < $noofsalesRows; $j++)
|
|
{
|
|
|
|
$sales_stageValue=$adb->query_result($sales_stage_result,$j,strtolower(sales_stage));
|
|
if(in_array($sales_stageValue,$sales_stage_list)) continue;
|
|
$sales_stage_list[] = $sales_stageValue;
|
|
if($value == $sales_stageValue)
|
|
{
|
|
$chk_val = "selected";
|
|
}
|
|
else
|
|
{
|
|
$chk_val = '';
|
|
}
|
|
|
|
$sales_stage_fld.= '<OPTION value="'.$sales_stageValue.'" '.$chk_val.'>'.getTranslatedString($sales_stageValue).'</OPTION>';
|
|
}
|
|
function isActive($field,$mod){
|
|
global $adb,$theme;
|
|
$tabid = getTabid($mod);
|
|
$query = 'select * from vtiger_field where fieldname = ? and tabid = ? and presence in (0,2)';
|
|
$res = $adb->pquery($query,array($field,$tabid));
|
|
$rows = $adb->num_rows($res);
|
|
if($rows > 0){
|
|
return true;
|
|
}else
|
|
return false;
|
|
}
|
|
$userselected = '';
|
|
$groupselected = '';
|
|
$userdisplay = 'none';
|
|
$groupdisplay = 'none';
|
|
$private = '';
|
|
if($userid != ''){
|
|
global $adb;
|
|
$query = "SELECT * from vtiger_users WHERE id = ?";
|
|
$res = $adb->pquery($query,array($userid));
|
|
$rows = $adb->num_rows($res);
|
|
if($rows > 0){
|
|
$userselected = 'checked';
|
|
$userdisplay= 'block';
|
|
}else{
|
|
$groupselected = 'checked';
|
|
$groupdisplay= 'block';
|
|
}
|
|
}
|
|
|
|
if($current_user->id != 1){
|
|
require('user_privileges/sharing_privileges_'.$current_user->id.'.php');
|
|
$Acc_tabid= getTabid('Accounts');
|
|
$con_tabid = getTabid('Contacts');
|
|
if($defaultOrgSharingPermission[$Acc_tabid] === 0 || $defaultOrgSharingPermission[$Acc_tabid] == 3){
|
|
$private = 'private';
|
|
}elseif($defaultOrgSharingPermission[$con_tabid] === 0 || $defaultOrgSharingPermission[$con_tabid] == 3){
|
|
$private = 'private';
|
|
}
|
|
}
|
|
|
|
$convertlead = '<form name="ConvertLead" method="POST" action="index.php" onsubmit="VtigerJS_DialogBox.block();">
|
|
<input type="hidden" name="module" value="Leads">
|
|
<input type="hidden" name="record" value="'.$id.'">
|
|
<input type="hidden" name="action">
|
|
<input type="hidden" name="parenttab" value="'.$category.'">
|
|
<input type="hidden" name="current_user_id" value="'.$modified_user_id.'">
|
|
|
|
<div id="orgLay" style="display: block;" class="layerPopup" >
|
|
<table width="100%" border="0" cellpadding="5" cellspacing="0" class="layerHeadingULine">
|
|
<tr>
|
|
<td class="genHeaderSmall" align="left"><IMG src="'. vtiger_imageurl('Leads.gif', $theme).'">'.$mod_strings['LBL_CONVERT_LEAD'].' '.$firstname.' '.$lastname.'</td>
|
|
<td align="right"><a href="javascript:fninvsh(\'orgLay\');"><img src="'. vtiger_imageurl('close.gif', $theme).'" align="absmiddle" border="0"></a></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<table border=0 cellspacing=0 cellpadding=0 width=95% align=center>
|
|
<tr>
|
|
<td class=small >
|
|
<table border=0 celspacing=0 cellpadding=5 width=100% align=center bgcolor=white>
|
|
<tr>
|
|
<td colspan="2" class="detailedViewHeader"><b>'.$mod_strings['LBL_CONVERT_LEAD_INFORMATION'].'</b></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" class="dvtCellLabel" width="50%">'.$app_strings['LBL_ASSIGNED_TO'].'</td>
|
|
<td class="dvtCellInfo" width="50%">
|
|
<input type="radio" name="assigntype" value="U" onclick="toggleAssignType(this.value)" '.$userselected.' /> '.$app_strings['LBL_USER'].'
|
|
<input type="radio" name="assigntype" value="T" onclick="toggleAssignType(this.value)" '.$groupselected.' /> '.$app_strings['LBL_GROUP'].'
|
|
<span id="assign_user" style="display:'.$userdisplay.'">
|
|
<select name="assigned_user_id" class="detailedViewTextBox">'.get_select_options_with_id(get_user_array(false,"Active", $userid,$private),$userid).'</select>
|
|
</span>
|
|
<span id="assign_team" style="display:'.$groupdisplay.'">
|
|
<select name="assigned_group_id" class="detailedViewTextBox">'.get_select_options_with_id(get_group_array(false,"Active", $userid,$private),$userid).'</select>
|
|
</span>
|
|
</td>
|
|
</tr>';
|
|
|
|
if(vtlib_isModuleActive('Accounts') && (isPermitted('Accounts','EditView')== 'yes')){
|
|
$convertlead .= '<tr>
|
|
<td align="right" class="dvtCellLabel">'.$mod_strings['LBL_ACCOUNT_NAME'].'</td>
|
|
<td class="dvtCellInfo"><input type="text" name="account_name" class="detailedViewTextBox" value="'.$company.'" readonly="readonly"></td>
|
|
</tr>';
|
|
}
|
|
if(vtlib_isModuleActive('Potentials') && (isPermitted('Potentials','EditView')== 'yes')){
|
|
// An array which as module => fields mapping, to check for field permissions
|
|
$fields_list = array( 'Potentials'=> array('potentialname', 'closingdate', 'amount', 'sales_stage'));
|
|
$fields_permission = array();
|
|
foreach($fields_list as $mod=>$fields){
|
|
foreach($fields as $key=>$field) {
|
|
if(getFieldVisibilityPermission($mod, $current_user->id, $field)=='0' && (isActive($field,$mod) == true)){
|
|
$fields_permission[$field] = '0';
|
|
$potTabid = getTabid('Potentials');
|
|
global $adb;
|
|
$query = 'select typeofdata from vtiger_field where fieldname = ? and tabid = ?';
|
|
$res = $adb->pquery($query,array($field,$potTabid));
|
|
$type = $adb->query_result($res,0,'typeofdata');
|
|
if(strpos($type,'M')){
|
|
$mandatory[$field] = '*';
|
|
}
|
|
}
|
|
else
|
|
$fields_permission[$field] = '1';
|
|
}
|
|
}
|
|
|
|
$convertlead .='<tr>
|
|
<td align="right" class="dvtCellLabel">'.$mod_strings['LBL_DO_NOT_CREATE_NEW_POTENTIAL'].'</td>
|
|
<td class="dvtCellInfo"><input type="checkbox" name="createpotential" onClick="if(this.checked) { $(\'ch\').hide(); } else { $(\'ch\').show(); }"></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" id="ch" height="100px" style="padding:0px;" >
|
|
<div style="display: block;" id="cc" >
|
|
<table width="100%" border="0" cellpadding="5" cellspacing="0" >';
|
|
if($fields_permission['potentialname']=='0') {
|
|
|
|
$convertlead .= '<tr>
|
|
<td align="right" class="dvtCellLabel" width="53%"><font color="red">'.$mandatory['potentialname'].'</font>'.$mod_strings['LBL_POTENTIAL_NAME'].'</td>
|
|
<td class="dvtCellInfo" width="47%">
|
|
<input name="potential_name" class="detailedViewTextBox" value="'.$potentialname.'" tabindex="3">
|
|
<input type="hidden" name="potentialname_mandatory" id="potentialname_mandatory" value='.$mandatory['potentialname'].' />
|
|
</td>
|
|
</tr>';
|
|
}
|
|
if($fields_permission['closingdate']=='0') {
|
|
$convertlead .= '<tr>
|
|
<td align="right" class="dvtCellLabel"><font color="red">'.$mandatory['closingdate'].'</font>'.$mod_strings['LBL_POTENTIAL_CLOSE_DATE'].'</td>
|
|
<td class="dvtCellInfo">
|
|
<input type="hidden" name="closingdate_mandatory" id="closingdate_mandatory" value='.$mandatory['closingdate'].' />
|
|
<input name="closedate" style="border: 1px solid rgb(186, 186, 186);" id="jscal_field_closedate" type="text" tabindex="4" size="10" maxlength="10" value="'.$focus->closedate.'">
|
|
<img src="themes/'.$theme.'/images/btnL3Calendar.gif" id="jscal_trigger_closedate" >
|
|
<font size=1><em old="(yyyy-mm-dd)">('.$current_user->date_format.')</em></font>
|
|
<script id="conv_leadcal">
|
|
getCalendarPopup(\'jscal_trigger_closedate\',\'jscal_field_closedate\',\''.$date_format.'\')
|
|
</script>
|
|
</td>
|
|
</tr>';
|
|
}
|
|
if($fields_permission['amount']=='0') {
|
|
$convertlead .= '<tr>
|
|
<td align="right" class="dvtCellLabel"><font color="red">'.$mandatory['amount'].'</font>'.$mod_strings['LBL_POTENTIAL_AMOUNT'].'</td>
|
|
<td class="dvtCellInfo">
|
|
<input type="hidden" name="amount_mandatory" id="amount_mandatory" value='.$mandatory['amount'].' />
|
|
<input type="text" name="potential_amount" class="detailedViewTextBox">'.$potential_amount.'</td>
|
|
</tr>';
|
|
}
|
|
if($fields_permission['sales_stage']=='0') {
|
|
$convertlead .='<tr>
|
|
<td align="right" class="dvtCellLabel"><font color="red">'.$mandatory['sales_stage'].'</font>'.$mod_strings['LBL_POTENTIAL_SALES_STAGE'].'</td>
|
|
<td class="dvtCellInfo">
|
|
<input type="hidden" name="salesstage_mandatory" id="salesstage_mandatory" value='.$mandatory['sales_stage'].' />
|
|
<select name="potential_sales_stage" class="detailedViewTextBox">'.$sales_stage_fld.'</select></td>
|
|
</tr>';
|
|
}
|
|
$convertlead .='</table>
|
|
</div>
|
|
</td>
|
|
</tr>';
|
|
|
|
}
|
|
$convertlead .='</table>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<table border=0 cellspacing=0 cellpadding=5 width=100% class="layerPopupTransport">
|
|
<tr>
|
|
<td align="center">
|
|
<input name="Save" value=" '.$app_strings['LBL_SAVE_BUTTON_LABEL'].' " onclick="this.form.action.value=\'LeadConvertToEntities\'; return verify_data(ConvertLead)" type="submit" class="crmbutton save small">
|
|
<input type="button" name=" Cancel " value=" '.$app_strings['LBL_CANCEL_BUTTON_LABEL'].' " onClick="hide(\'orgLay\')" class="crmbutton cancel small">
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div></form>';
|
|
echo $convertlead;
|
|
|
|
?>
|