$relatedModuleName * @param $excludedIds * @return List of selected ids */ public function getSelectedIdsList($relatedModuleName, $excludedIds = false) { $db = PearDatabase::getInstance(); switch($relatedModuleName) { case "Leads" : $tableName = "vtiger_campaignleadrel"; $fieldName = "leadid"; break; case "Accounts" : $tableName = "vtiger_campaignaccountrel"; $fieldName = "accountid"; break; case 'Contacts' : $tableName = "vtiger_campaigncontrel"; $fieldName = "contactid"; break; } $query = "SELECT $fieldName FROM $tableName INNER JOIN vtiger_crmentity ON $tableName.$fieldName = vtiger_crmentity.crmid AND vtiger_crmentity.deleted = ? WHERE campaignid = ?"; if ($excludedIds) { $query .= " AND $fieldName NOT IN (". implode(',', $excludedIds) .")"; } $result = $db->pquery($query, array(0, $this->getId())); $numOfRows = $db->num_rows($result); $selectedIdsList = array(); for ($i=0; $i<$numOfRows; $i++) { $selectedIdsList[] = $db->query_result($result, $i, $fieldName); } return $selectedIdsList; } }