root/vtigercrm/branches/5.1/modules/Campaigns/Campaigns.php

<?php
/*********************************************************************************
 * The contents of this file are subject to the SugarCRM Public License Version 1.1.2
 * ("License"); You may not use this file except in compliance with the
 * License. You may obtain a copy of txhe License at http://www.sugarcrm.com/SPL
 * Software distributed under the License is distributed on an  "AS IS"  basis,
 * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
 * the specific language governing rights and limitations under the License.
 * The Original Code is:  SugarCRM Open Source
 * The Initial Developer of the Original Code is SugarCRM, Inc.
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.;
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
 ********************************************************************************/
include_once('config.php');
require_once('include/logging.php');
require_once('data/SugarBean.php');
require_once('include/utils/utils.php');
require_once('modules/Contacts/Contacts.php');
require_once('modules/Leads/Leads.php');
require_once('user_privileges/default_module_view.php');

class Campaigns extends CRMEntity {
    var $log;
    var $db;
    var $table_name = "vtiger_campaign";
    var $table_index= 'campaignid';

    var $tab_name = Array('vtiger_crmentity','vtiger_campaign','vtiger_campaignscf');
    var $tab_name_index = Array('vtiger_crmentity'=>'crmid','vtiger_campaign'=>'campaignid','vtiger_campaignscf'=>'campaignid');
    /**
     * Mandatory table for supporting custom fields.
     */
    var $customFieldTable = Array('vtiger_campaignscf', 'campaignid');
    var $column_fields = Array();

    var $sortby_fields = Array('campaignname','smownerid','campaigntype','productname','expectedrevenue','closingdate','campaignstatus','expectedresponse','targetaudience','expectedcost');

    var $list_fields = Array(
                    'Campaign Name'=>Array('campaign'=>'campaignname'),
                    'Campaign Type'=>Array('campaign'=>'campaigntype'),
                    'Campaign Status'=>Array('campaign'=>'campaignstatus'),
                    'Expected Revenue'=>Array('campaign'=>'expectedrevenue'),
                    'Expected Close Date'=>Array('campaign'=>'closingdate'),
                    'Assigned To' => Array('crmentity'=>'smownerid')
                );

    var $list_fields_name = Array(
                    'Campaign Name'=>'campaignname',
                    'Campaign Type'=>'campaigntype',
                    'Campaign Status'=>'campaignstatus',
                    'Expected Revenue'=>'expectedrevenue',
                    'Expected Close Date'=>'closingdate',
                    'Assigned To'=>'assigned_user_id'
                     );                  

    var $list_link_field= 'campaignname';
    //Added these variables which are used as default order by and sortorder in ListView
    var $default_order_by = 'crmid';
    var $default_sort_order = 'DESC';

    //var $groupTable = Array('vtiger_campaigngrouprelation','campaignid');

    var $search_fields = Array(
            'Campaign Name'=>Array('vtiger_campaign'=>'campaignname'),
            'Campaign Type'=>Array('vtiger_campaign'=>'campaigntype'),
            );

    var $search_fields_name = Array(
            'Campaign Name'=>'campaignname',
            'Campaign Type'=>'campaigntype',
            );
    // Used when enabling/disabling the mandatory fields for the module.
    // Refers to vtiger_field.fieldname values.
    var $mandatory_fields = Array('campaignname','createdtime' ,'modifiedtime','assigned_user_id');
    
    function Campaigns() 
    {
        $this->log =LoggerManager::getLogger('campaign');
        $this->db = PearDatabase::getInstance();
        $this->column_fields = getColumnFields('Campaigns');
    }

    /** Function to handle module specific operations when saving a entity 
    */
    function save_module($module)
    {
    }

    // Mike Crowe Mod --------------------------------------------------------Default ordering for us
    /**
     * Function to get sort order
     * return string  $sorder    - sortorder string either 'ASC' or 'DESC'
     */
    function getSortOrder()
    {
        global $log;
        $log->debug("Entering getSortOrder() method ...");
        if(isset($_REQUEST['sorder']))
            $sorder = $this->db->sql_escape_string($_REQUEST['sorder']);
        else
            $sorder = (($_SESSION['CAMPAIGN_SORT_ORDER'] != '')?($_SESSION['CAMPAIGN_SORT_ORDER']):($this->default_sort_order));

        $log->debug("Exiting getSortOrder method ...");
        return $sorder;
    }

    /**
     * Function to get order by
     * return string  $order_by    - fieldname(eg: 'campaignname')
     */
    function getOrderBy()
    {
        global $log;
        $log->debug("Entering getOrderBy() method ...");
        
        $use_default_order_by = '';        
        if(PerformancePrefs::getBoolean('LISTVIEW_DEFAULT_SORTING', true)) {
            $use_default_order_by = $this->default_order_by;
        }
        
        if (isset($_REQUEST['order_by']))
            $order_by = $this->db->sql_escape_string($_REQUEST['order_by']);
        else
            $order_by = (($_SESSION['CAMPAIGN_ORDER_BY'] != '')?($_SESSION['CAMPAIGN_ORDER_BY']):($use_default_order_by));

        $log->debug("Exiting getOrderBy method ...");
        return $order_by;
    }
    // Mike Crowe Mod --------------------------------------------------------

    /**
     * Function to get Campaign related Contacts
     * @param  integer   $id      - campaignid
     * returns related Contacts record in array format
     */
    function get_contacts($id, $cur_tab_id, $rel_tab_id, $actions=false) {
        global $log, $singlepane_view,$currentModule;
        $log->debug("Entering get_contacts(".$id.") method ...");
        $this_module = $currentModule;

        $related_module = vtlib_getModuleNameById($rel_tab_id);
        require_once("modules/$related_module/$related_module.php");
        $other = new $related_module();
        vtlib_setup_modulevars($related_module, $other);        
        $singular_modname = vtlib_toSingular($related_module);
        
        $parenttab = getParentTab();
        
        if($singlepane_view == 'true')
            $returnset = '&return_module='.$this_module.'&return_action=DetailView&return_id='.$id;
        else
            $returnset = '&return_module='.$this_module.'&return_action=CallRelatedList&return_id='.$id;
        
        $button = '';
        
        // Send mail button for selected Leads
        $button .= "<input title='".getTranslatedString('LBL_SEND_MAIL_BUTTON')."' class='crmbutton small edit' value='".getTranslatedString('LBL_SEND_MAIL_BUTTON')."' type='button' name='button' onclick='rel_eMail(\"$this_module\",this,\"$related_module\")'>";
        $button .= '&nbsp;&nbsp;&nbsp;&nbsp';
        
        /* To get Leads CustomView -START */
        require_once('modules/CustomView/CustomView.php');
        $lhtml = "<select id='cont_cv_list' class='small'><option value='None'>-- ".getTranslatedString('Select One')." --</option>";
        $oCustomView = new CustomView($related_module);
        $viewid = $oCustomView->getViewId($related_module);
        $customviewcombo_html = $oCustomView->getCustomViewCombo($viewid, false);
        $lhtml .= $customviewcombo_html;
        $lhtml .= "</select>";
        /* To get Leads CustomView -END */
        
        $button .= $lhtml."<input title='".getTranslatedString('LBL_LOAD_LIST',$this_module)."' class='crmbutton small edit' value='".getTranslatedString('LBL_LOAD_LIST',$this_module)."' type='button' name='button' onclick='loadCvList(\"$related_module\",\"$id\")'>";
        $button .= '&nbsp;&nbsp;&nbsp;&nbsp';
        
        if($actions) {
            if(is_string($actions)) $actions = explode(',', strtoupper($actions));
            if(in_array('SELECT', $actions) && isPermitted($related_module,4, '') == 'yes') {
                $button .= "<input title='".getTranslatedString('LBL_SELECT')." ". getTranslatedString($related_module). "' class='crmbutton small edit' type='button' onclick=\"return window.open('index.php?module=$related_module&return_module=$currentModule&action=Popup&popuptype=detailview&select=enable&form=EditView&form_submit=false&recordid=$id&parenttab=$parenttab','test','width=640,height=602,resizable=0,scrollbars=0');\" value='". getTranslatedString('LBL_SELECT'). " " . getTranslatedString($related_module) ."'>&nbsp;";
            }
            if(in_array('ADD', $actions) && isPermitted($related_module,1, '') == 'yes') {
                $button .= "<input title='".getTranslatedString('LBL_ADD_NEW'). " ". getTranslatedString($singular_modname) ."' class='crmbutton small create'" .
                    " onclick='this.form.action.value=\"EditView\";this.form.module.value=\"$related_module\"' type='submit' name='button'" .
                    " value='". getTranslatedString('LBL_ADD_NEW'). " " . getTranslatedString($singular_modname) ."'>&nbsp;";
            }
        }

        $query = "SELECT vtiger_contactdetails.accountid, vtiger_account.accountname, 
                    CASE when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as user_name , 
                    vtiger_contactdetails.contactid, vtiger_contactdetails.lastname, vtiger_contactdetails.firstname, vtiger_contactdetails.title, 
                    vtiger_contactdetails.department, vtiger_contactdetails.email, vtiger_contactdetails.phone, vtiger_crmentity.crmid, 
                    vtiger_crmentity.smownerid, vtiger_crmentity.modifiedtime 
                    FROM vtiger_contactdetails 
                    INNER JOIN vtiger_campaigncontrel ON vtiger_campaigncontrel.contactid = vtiger_contactdetails.contactid 
                    INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_contactdetails.contactid  
                    LEFT JOIN vtiger_groups ON vtiger_groups.groupid=vtiger_crmentity.smownerid 
                    LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid=vtiger_users.id 
                    LEFT JOIN vtiger_account ON vtiger_account.accountid = vtiger_contactdetails.accountid 
                    WHERE vtiger_campaigncontrel.campaignid = ".$id." AND vtiger_crmentity.deleted=0";
                    
        $return_value = GetRelatedList($this_module, $related_module, $other, $query, $button, $returnset); 
        
        if($return_value == null) $return_value = Array();
        $return_value['CUSTOM_BUTTON'] = $button;
        
        $log->debug("Exiting get_contacts method ...");        
        return $return_value;
    }

    /**
     * Function to get Campaign related Leads
     * @param  integer   $id      - campaignid
     * returns related Leads record in array format
     */
    function get_leads($id, $cur_tab_id, $rel_tab_id, $actions=false) {
        global $log, $singlepane_view, $currentModule;
        $log->debug("Entering get_leads(".$id.") method ...");
        $this_module = $currentModule;

        $related_module = vtlib_getModuleNameById($rel_tab_id);
        require_once("modules/$related_module/$related_module.php");
        $other = new $related_module();
        vtlib_setup_modulevars($related_module, $other);        
        $singular_modname = vtlib_toSingular($related_module);
        
        $parenttab = getParentTab();
        
        if($singlepane_view == 'true')
            $returnset = '&return_module='.$this_module.'&return_action=DetailView&return_id='.$id;
        else
            $returnset = '&return_module='.$this_module.'&return_action=CallRelatedList&return_id='.$id;
        
        $button = '';
        
        // Send mail button for selected Leads
        $button .= "<input title='".getTranslatedString('LBL_SEND_MAIL_BUTTON')."' class='crmbutton small edit' value='".getTranslatedString('LBL_SEND_MAIL_BUTTON')."' type='button' name='button' onclick='rel_eMail(\"$this_module\",this,\"$related_module\")'>";
        $button .= '&nbsp;&nbsp;&nbsp;&nbsp';
        
        /* To get Leads CustomView -START */
        require_once('modules/CustomView/CustomView.php');
        $lhtml = "<select id='lead_cv_list' class='small'><option value='None'>-- ".getTranslatedString('Select One')." --</option>";
        $oCustomView = new CustomView($related_module);
        $viewid = $oCustomView->getViewId($related_module);
        $customviewcombo_html = $oCustomView->getCustomViewCombo($viewid, false);
        $lhtml .= $customviewcombo_html;
        $lhtml .= "</select>";
        /* To get Leads CustomView -END */
        
        $button .= $lhtml."<input title='".getTranslatedString('LBL_LOAD_LIST',$this_module)."' class='crmbutton small edit' value='".getTranslatedString('LBL_LOAD_LIST',$this_module)."' type='button' name='button' onclick='loadCvList(\"$related_module\",\"$id\")'>";
        $button .= '&nbsp;&nbsp;&nbsp;&nbsp';
        
        if($actions) {
            if(is_string($actions)) $actions = explode(',', strtoupper($actions));
            if(in_array('SELECT', $actions) && isPermitted($related_module,4, '') == 'yes') {
                $button .= "<input title='".getTranslatedString('LBL_SELECT')." ". getTranslatedString($related_module). "' class='crmbutton small edit' type='button' onclick=\"return window.open('index.php?module=$related_module&return_module=$currentModule&action=Popup&popuptype=detailview&select=enable&form=EditView&form_submit=false&recordid=$id&parenttab=$parenttab','test','width=640,height=602,resizable=0,scrollbars=0');\" value='". getTranslatedString('LBL_SELECT'). " " . getTranslatedString($related_module) ."'>&nbsp;";
            }
            if(in_array('ADD', $actions) && isPermitted($related_module,1, '') == 'yes') {
                $button .= "<input title='".getTranslatedString('LBL_ADD_NEW'). " ". getTranslatedString($singular_modname) ."' class='crmbutton small create'" .
                    " onclick='this.form.action.value=\"EditView\";this.form.module.value=\"$related_module\"' type='submit' name='button'" .
                    " value='". getTranslatedString('LBL_ADD_NEW'). " " . getTranslatedString($singular_modname) ."'>&nbsp;";
            }
        } 

        $query = "SELECT vtiger_leaddetails.*, vtiger_crmentity.crmid,vtiger_leadaddress.phone,vtiger_leadsubdetails.website, 
                    CASE when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as user_name, 
                    vtiger_crmentity.smownerid FROM vtiger_leaddetails      
                    INNER JOIN vtiger_campaignleadrel ON vtiger_campaignleadrel.leadid=vtiger_leaddetails.leadid
                    INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_leaddetails.leadid
                    INNER JOIN vtiger_leadsubdetails  ON vtiger_leadsubdetails.leadsubscriptionid = vtiger_leaddetails.leadid             
                    INNER JOIN vtiger_leadaddress ON vtiger_leadaddress.leadaddressid = vtiger_leadsubdetails.leadsubscriptionid
                    LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id
                    LEFT JOIN vtiger_groups ON vtiger_groups.groupid=vtiger_crmentity.smownerid
                    WHERE vtiger_crmentity.deleted=0 AND vtiger_campaignleadrel.campaignid = ".$id;
                    
        $return_value = GetRelatedList($this_module, $related_module, $other, $query, $button, $returnset); 
        
        if($return_value == null) $return_value = Array();
        $return_value['CUSTOM_BUTTON'] = $button;
        
        $log->debug("Exiting get_leads method ...");        
        return $return_value;
    }

    /**
     * Function to get Campaign related Potentials
     * @param  integer   $id      - campaignid
     * returns related potentials record in array format
     */
    function get_opportunities($id, $cur_tab_id, $rel_tab_id, $actions=false) {
        global $log, $singlepane_view,$currentModule,$current_user;
        $log->debug("Entering get_opportunities(".$id.") method ...");
        $this_module = $currentModule;

        $related_module = vtlib_getModuleNameById($rel_tab_id);
        require_once("modules/$related_module/$related_module.php");
        $other = new $related_module();
        vtlib_setup_modulevars($related_module, $other);        
        $singular_modname = vtlib_toSingular($related_module);
        
        $parenttab = getParentTab();
        
        if($singlepane_view == 'true')
            $returnset = '&return_module='.$this_module.'&return_action=DetailView&return_id='.$id;
        else
            $returnset = '&return_module='.$this_module.'&return_action=CallRelatedList&return_id='.$id;
        
        $button = '';
                
        if($actions && getFieldVisibilityPermission($related_module,$current_user->id,'campaignid') == '0') {
            if(is_string($actions)) $actions = explode(',', strtoupper($actions));
            if(in_array('SELECT', $actions) && isPermitted($related_module,4, '') == 'yes') {
                $button .= "<input title='".getTranslatedString('LBL_SELECT')." ". getTranslatedString($related_module). "' class='crmbutton small edit' type='button' onclick=\"return window.open('index.php?module=$related_module&return_module=$currentModule&action=Popup&popuptype=detailview&select=enable&form=EditView&form_submit=false&recordid=$id&parenttab=$parenttab','test','width=640,height=602,resizable=0,scrollbars=0');\" value='". getTranslatedString('LBL_SELECT'). " " . getTranslatedString($related_module) ."'>&nbsp;";
            }
            if(in_array('ADD', $actions) && isPermitted($related_module,1, '') == 'yes') {
                $button .= "<input title='".getTranslatedString('LBL_ADD_NEW'). " ". getTranslatedString($singular_modname) ."' class='crmbutton small create'" .
                    " onclick='this.form.action.value=\"EditView\";this.form.module.value=\"$related_module\"' type='submit' name='button'" .
                    " value='". getTranslatedString('LBL_ADD_NEW'). " " . getTranslatedString($singular_modname) ."'>&nbsp;";
            }
        } 

        $query = "SELECT CASE when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as user_name,
                    vtiger_potential.related_to, vtiger_account.accountname, vtiger_potential.potentialid, vtiger_potential.potentialname,  
                    vtiger_potential.potentialtype, vtiger_potential.sales_stage, vtiger_potential.amount, vtiger_potential.closingdate,  
                    vtiger_crmentity.crmid, vtiger_crmentity.smownerid FROM vtiger_campaign  
                    INNER JOIN vtiger_potential ON vtiger_campaign.campaignid = vtiger_potential.campaignid  
                    INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_potential.potentialid 
                    LEFT JOIN vtiger_groups ON vtiger_groups.groupid=vtiger_crmentity.smownerid
                    LEFT JOIN vtiger_users ON vtiger_users.id=vtiger_crmentity.smownerid
                    LEFT JOIN vtiger_account ON vtiger_account.accountid = vtiger_potential.related_to
                    WHERE vtiger_campaign.campaignid = ".$id." AND vtiger_crmentity.deleted=0";
                    
        $return_value = GetRelatedList($this_module, $related_module, $other, $query, $button, $returnset); 
        
        if($return_value == null) $return_value = Array();
        $return_value['CUSTOM_BUTTON'] = $button;
        
        $log->debug("Exiting get_opportunities method ...");        
        return $return_value;
    }

    /**
     * Function to get Campaign related Activities
     * @param  integer   $id      - campaignid
     * returns related activities record in array format
     */
    function get_activities($id, $cur_tab_id, $rel_tab_id, $actions=false) {
        global $log, $singlepane_view,$currentModule,$current_user;
        $log->debug("Entering get_activities(".$id.") method ...");
        $this_module = $currentModule;

        $related_module = vtlib_getModuleNameById($rel_tab_id);
        require_once("modules/$related_module/Activity.php");
        $other = new Activity();
        vtlib_setup_modulevars($related_module, $other);        
        $singular_modname = vtlib_toSingular($related_module);
        
        $parenttab = getParentTab();
        
        if($singlepane_view == 'true')
            $returnset = '&return_module='.$this_module.'&return_action=DetailView&return_id='.$id;
        else
            $returnset = '&return_module='.$this_module.'&return_action=CallRelatedList&return_id='.$id;
        
        $button = '';
                
        $button .= '<input type="hidden" name="activity_mode">';
                
        if($actions) {
            if(is_string($actions)) $actions = explode(',', strtoupper($actions));
            if(in_array('ADD', $actions) && isPermitted($related_module,1, '') == 'yes') {
                $button .= "<input title='".getTranslatedString('LBL_NEW'). " ". getTranslatedString('LBL_TODO', $related_module) ."' class='crmbutton small create'" .
                    " onclick='this.form.action.value=\"EditView\";this.form.module.value=\"$related_module\";this.form.return_module.value=\"$this_module\";this.form.activity_mode.value=\"Task\";' type='submit' name='button'" .
                    " value='". getTranslatedString('LBL_ADD_NEW'). " " . getTranslatedString('LBL_TODO', $related_module) ."'>&nbsp;";
            }
        }

        $query = "SELECT vtiger_contactdetails.lastname,
            vtiger_contactdetails.firstname,
            vtiger_contactdetails.contactid,
            vtiger_activity.*,
            vtiger_seactivityrel.*,
            vtiger_crmentity.crmid, vtiger_crmentity.smownerid,
            vtiger_crmentity.modifiedtime,
            CASE when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as user_name,
            vtiger_recurringevents.recurringtype
            FROM vtiger_activity
            INNER JOIN vtiger_seactivityrel
                ON vtiger_seactivityrel.activityid = vtiger_activity.activityid
            INNER JOIN vtiger_crmentity
                ON vtiger_crmentity.crmid=vtiger_activity.activityid
            LEFT JOIN vtiger_cntactivityrel
                ON vtiger_cntactivityrel.activityid = vtiger_activity.activityid
            LEFT JOIN vtiger_contactdetails
                ON vtiger_contactdetails.contactid = vtiger_cntactivityrel.contactid
            LEFT JOIN vtiger_users
                ON vtiger_users.id = vtiger_crmentity.smownerid
            LEFT OUTER JOIN vtiger_recurringevents
                ON vtiger_recurringevents.activityid = vtiger_activity.activityid
            LEFT JOIN vtiger_groups
                ON vtiger_groups.groupid = vtiger_crmentity.smownerid
            WHERE vtiger_seactivityrel.crmid=".$id."
            AND vtiger_crmentity.deleted = 0
            AND (activitytype = 'Task'
                OR activitytype !='Emails')";
                    
        $return_value = GetRelatedList($this_module, $related_module, $other, $query, $button, $returnset); 
        
        if($return_value == null) $return_value = Array();
        $return_value['CUSTOM_BUTTON'] = $button;
        
        $log->debug("Exiting get_activities method ...");        
        return $return_value;
    
    }
    
    /*
     * Function to get the secondary query part of a report 
     * @param - $module primary module name
     * @param - $secmodule secondary module name
     * returns the query string formed on fetching the related data for report for secondary module
     */
    function generateReportsSecQuery($module,$secmodule){
        $query = $this->getRelationQuery($module,$secmodule,"vtiger_campaign","campaignid");
        $query .=" left join vtiger_crmentity as vtiger_crmentityCampaigns on vtiger_crmentityCampaigns.crmid=vtiger_campaign.campaignid and vtiger_crmentityCampaigns.deleted=0 
                left join vtiger_products as vtiger_productsCampaigns on vtiger_campaign.product_id = vtiger_productsCampaigns.productid 
                left join vtiger_campaignscf on vtiger_campaignscf.campaignid = vtiger_crmentityCampaigns.crmid 
                left join vtiger_groups as vtiger_groupsCampaigns on vtiger_groupsCampaigns.groupid = vtiger_crmentityCampaigns.smownerid
                left join vtiger_users as vtiger_usersCampaigns on vtiger_usersCampaigns.id = vtiger_crmentityCampaigns.smownerid"; 

        return $query;
    }

    /*
     * Function to get the relation tables for related modules 
     * @param - $secmodule secondary module name
     * returns the array with table names and fieldnames storing relations between module and this module
     */
    function setRelationTables($secmodule){
        $rel_tables = array (
            "Contacts" => array("vtiger_campaigncontrel"=>array("campaignid","contactid"),"vtiger_campaign"=>"campaignid"),
            "Leads" => array("vtiger_campaignleadrel"=>array("campaignid","leadid"),"vtiger_campaign"=>"campaignid"),
            "Potentials" => array("vtiger_potential"=>array("campaignid","potentialid"),"vtiger_campaign"=>"campaignid"),
            "Calendar" => array("vtiger_seactivityrel"=>array("crmid","activityid"),"vtiger_campaign"=>"campaignid"),
            "Products" => array("vtiger_campaign"=>array("campaignid","product_id")),
        );
        return $rel_tables[$secmodule];
    }
    
    // Function to unlink an entity with given Id from another entity
    function unlinkRelationship($id, $return_module, $return_id) {
        global $log;
        if(empty($return_module) || empty($return_id)) return;
        
        if($return_module == 'Leads') {
            $sql = 'DELETE FROM vtiger_campaignleadrel WHERE campaignid=? AND leadid=?';
            $this->db->pquery($sql, array($id, $return_id));
        } elseif($return_module == 'Contacts') {
            $sql = 'DELETE FROM vtiger_campaigncontrel WHERE campaignid=? AND contactid=?';
            $this->db->pquery($sql, array($id, $return_id));
        } else {
            $sql = 'DELETE FROM vtiger_crmentityrel WHERE (crmid=? AND relmodule=? AND relcrmid=?) OR (relcrmid=? AND module=? AND crmid=?)';
            $params = array($id, $return_module, $return_id, $id, $return_module, $return_id);
            $this->db->pquery($sql, $params);
        }
    }

}
?>