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.= '';
}
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 = '';
echo $convertlead;
?>