'.$GetCPEmail_sql;
if ($var_Centre && $var_Type)
if ($GetCPEmail_results = mysqli_query($dblink,$GetCPEmail_sql))
if ($GetCPEmail_myrow = mysqli_fetch_array($GetCPEmail_results))
$var_PersonEmail = $GetCPEmail_myrow['col_Email'];
return $var_PersonEmail;
}
////////////////////////////////////////////////////////////////////////////////
function GetCPID($var_Centre, $var_Phase, $var_Type, $var_CompanyID, $var_CompanyName)
{
global $dblink;
if ($var_CompanyID)
$sql_Company = "AND tb_ListCompanyContact.col_ListCompanyID = '$var_CompanyID'";
elseif ($var_CompanyName)
$sql_Company = "AND tb_ListCompanyContact.col_CompanyName = \"$var_CompanyName\"";
if ($var_Phase)
$sql_Phase = "AND tb_ListCompanyContact.col_Phase = '$var_Phase'";
$var_PersonID = '';
//check to see if we have an override email for this company centre and phase
$GetCPEmail_sql = "
SELECT tb_Person.col_PersonID
FROM tb_ListCompanyContact
LEFT JOIN tb_Person
ON tb_ListCompanyContact.col_PersonID = tb_Person.col_PersonID
WHERE 1
$sql_Company
$sql_Phase
AND tb_ListCompanyContact.col_Centre = '$var_Centre'
AND tb_ListCompanyContact.col_Type = '$var_Type'";
//echo '
'.$GetCPEmail_sql;
if ($var_Centre && $var_Type)
if ($GetCPEmail_results = mysqli_query($dblink,$GetCPEmail_sql))
if ($GetCPEmail_myrow = mysqli_fetch_array($GetCPEmail_results))
$var_PersonID = $GetCPEmail_myrow['col_PersonID'];
return $var_PersonID;
}
////////////////////////////////////////////////////////////////////////////////
function GetCPName($var_Centre, $var_Phase, $var_Type, $var_CompanyID, $var_CompanyName)
{
global $dblink;
if ($var_CompanyID)
$sql_Company = "AND tb_ListCompanyContact.col_ListCompanyID = '$var_CompanyID'";
elseif ($var_CompanyName)
$sql_Company = "AND tb_ListCompanyContact.col_CompanyName = \"$var_CompanyName\"";
if ($var_Phase)
$sql_Phase = "AND tb_ListCompanyContact.col_Phase = '$var_Phase'";
$var_Name = '';
//check to see if we have an override email for this company centre and phase
$GetCPEmail_sql = "
SELECT tb_Person.col_Name
FROM tb_ListCompanyContact
LEFT JOIN tb_Person
ON tb_ListCompanyContact.col_PersonID = tb_Person.col_PersonID
WHERE 1
$sql_Company
$sql_Phase
AND tb_ListCompanyContact.col_Centre = '$var_Centre'
AND tb_ListCompanyContact.col_Type = '$var_Type'";
//echo '
'.$GetCPEmail_sql;
if ($var_Centre && $var_Type)
if ($GetCPEmail_results = mysqli_query($dblink,$GetCPEmail_sql))
if ($GetCPEmail_myrow = mysqli_fetch_array($GetCPEmail_results))
$var_Name = $GetCPEmail_myrow['col_Name'];
////////////////////////////////////////////////////////////////////////////////
return $var_Name;
}
////////////////////////////////////////////////////////////////////////////////
function GetCPPhone($var_Centre, $var_Phase, $var_Type, $var_CompanyID, $var_CompanyName)
{
global $dblink;
if ($var_CompanyID)
$sql_Company = "AND tb_ListCompanyContact.col_ListCompanyID = '$var_CompanyID'";
elseif ($var_CompanyName)
$sql_Company = "AND tb_ListCompanyContact.col_CompanyName = \"$var_CompanyName\"";
if ($var_Phase)
$sql_Phase = "AND tb_ListCompanyContact.col_Phase = '$var_Phase'";
$var_SubPhone = '';
//check to see if we have an override email for this company centre and phase
$GetCPEmail_sql = "
SELECT tb_Person.col_Phone1
FROM tb_ListCompanyContact
LEFT JOIN tb_Person
ON tb_ListCompanyContact.col_PersonID = tb_Person.col_PersonID
WHERE 1
$sql_Company
$sql_Phase
AND tb_ListCompanyContact.col_Centre = '$var_Centre'
AND tb_ListCompanyContact.col_Type = '$var_Type'";
//echo '
'.$GetCPEmail_sql;
if ($var_Centre && $var_Type)
if ($GetCPEmail_results = mysqli_query($dblink,$GetCPEmail_sql))
if ($GetCPEmail_myrow = mysqli_fetch_array($GetCPEmail_results))
$var_SubPhone = $GetCPEmail_myrow['col_Phone1'];
////////////////////////////////////////////////////////////////////////////////
return $var_SubPhone;
}
////////////////////////////////////////////////////////////////////////////////
?>