public function isLead($email)
{
$isLead = $this->db->GetOne("\n SELECT pp.project_id\n FROM project_properties pp\n JOIN projects p ON p.project_id = pp.project_id\n WHERE pp.name = ?\n AND pp.value = ?\n AND p.archived = ?\n\n UNION\n\n SELECT cp.cc_id\n FROM cc_properties cp\n JOIN ccs c ON c.cc_id = cp.cc_id\n WHERE cp.name = ?\n AND cp.value = ?\n AND c.archived = ?\n ", [ProjectPropertyEntity::NAME_LEAD_EMAIL, $email, ProjectEntity::NOT_ARCHIVED, CostCentrePropertyEntity::NAME_LEAD_EMAIL, $email, CostCentreEntity::NOT_ARCHIVED]);
return $isLead ? true : false;
}