YuCheng Hu
fce9ce115a
yuchenghu@hawebs.net git-svn-id: https://svn.code.sf.net/p/hawebs/svn@539 a2543c7e-f6e9-4f8a-8bff-1ffc34733512
45 lines
1.8 KiB
PHP
45 lines
1.8 KiB
PHP
<?php
|
|
/*+********************************************************************************
|
|
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("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.
|
|
* Contributor(s): mmbrich
|
|
********************************************************************************/
|
|
|
|
require_once('modules/CustomView/CustomView.php');
|
|
require_once('user_privileges/default_module_view.php');
|
|
|
|
global $singlepane_view, $adb;
|
|
$cvObj = new CustomView(vtlib_purify($_REQUEST["list_type"]));
|
|
|
|
$listquery = getListQuery(vtlib_purify($_REQUEST["list_type"]));
|
|
$rs = $adb->query($cvObj->getModifiedCvListQuery(vtlib_purify($_REQUEST["cvid"]),$listquery,vtlib_purify($_REQUEST["list_type"])));
|
|
|
|
if($_REQUEST["list_type"] == "Leads"){
|
|
$reltable = "vtiger_campaignleadrel";
|
|
$relid = "leadid";
|
|
}
|
|
elseif($_REQUEST["list_type"] == "Contacts"){
|
|
$reltable = "vtiger_campaigncontrel";
|
|
$relid = "contactid";
|
|
}
|
|
elseif($_REQUEST["list_type"] == "Accounts"){
|
|
$reltable = "vtiger_campaignaccountrel";
|
|
$relid = "accountid";
|
|
}
|
|
|
|
while($row=$adb->fetch_array($rs)) {
|
|
$sql = "SELECT $relid FROM $reltable WHERE $relid = ? AND campaignid = ?";
|
|
$result = $adb->pquery($sql, array($row['crmid'], $_REQUEST['return_id']));
|
|
if ($adb->num_rows($result) > 0) continue;
|
|
$adb->pquery("INSERT INTO $reltable(campaignid, $relid,campaignrelstatusid) VALUES(?,?,1)", array($_REQUEST["return_id"], $row["crmid"]));
|
|
}
|
|
|
|
header("Location: index.php?module=Campaigns&action=CampaignsAjax&file=CallRelatedList&ajax=true&".
|
|
"record=".vtlib_purify($_REQUEST['return_id']));
|
|
|
|
?>
|