|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /proc/thread-self/root/home/akaindir/public_html/crm/modules/Campaigns/models/ |
Upload File : |
<?php
/*+**********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.1
* ("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.
*************************************************************************************/
class Campaigns_Record_Model extends Vtiger_Record_Model {
/**
* Function to get selected ids list of related module for send email
* @param <String> $relatedModuleName
* @param <array> $excludedIds
* @return <array> 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;
}
}