107 lines
3.4 KiB
PHP
107 lines
3.4 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.
|
||
|
|
********************************************************************************/
|
||
|
|
|
||
|
|
$pmodule=vtlib_purify($_REQUEST['pmodule']);
|
||
|
|
$entityid=vtlib_purify($_REQUEST['entityid']);
|
||
|
|
|
||
|
|
if ($pmodule=='Accounts')
|
||
|
|
{
|
||
|
|
$querystr="select fieldid,fieldlabel,columnname,tablename from vtiger_field where tabid=6 and uitype='13' and vtiger_field.presence in (0,2)";
|
||
|
|
}
|
||
|
|
elseif ($pmodule=='Contacts')
|
||
|
|
{
|
||
|
|
$querystr="select fieldid,fieldlabel,columnname from vtiger_field where tabid=4 and uitype='13' and vtiger_field.presence in (0,2)";
|
||
|
|
}
|
||
|
|
elseif ($pmodule=='Leads')
|
||
|
|
{
|
||
|
|
$querystr="select fieldid,fieldlabel,columnname from vtiger_field where tabid=7 and uitype='13' and vtiger_field.presence in (0,2)";
|
||
|
|
}
|
||
|
|
$result=$adb->pquery($querystr, array());
|
||
|
|
$numrows = $adb->num_rows($result);
|
||
|
|
|
||
|
|
if ($pmodule=='Accounts')
|
||
|
|
{
|
||
|
|
require_once('modules/Accounts/Accounts.php');
|
||
|
|
$myfocus = new Accounts();
|
||
|
|
$myfocus->retrieve_entity_info($entityid,"Accounts");
|
||
|
|
}
|
||
|
|
elseif ($pmodule=='Contacts')
|
||
|
|
{
|
||
|
|
require_once('modules/Contacts/Contacts.php');
|
||
|
|
$myfocus = new Contacts();
|
||
|
|
$myfocus->retrieve_entity_info($entityid,"Contacts");
|
||
|
|
}
|
||
|
|
elseif ($pmodule=='Leads')
|
||
|
|
{
|
||
|
|
require_once('modules/Leads/Leads.php');
|
||
|
|
$myfocus = new Leads();
|
||
|
|
$myfocus->retrieve_entity_info($entityid,"Leads");
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<script language="javascript">
|
||
|
|
function passemail()
|
||
|
|
{
|
||
|
|
y=window.opener.document.EditView.parent_id.value+"<?php echo $entityid;?>";
|
||
|
|
z=window.opener.document.EditView.parent_name.value;
|
||
|
|
<?php
|
||
|
|
for ($x=0;$x<$numrows;$x++)
|
||
|
|
{
|
||
|
|
$temp=$adb->query_result($result,$x,'columnname');
|
||
|
|
$temp1=br2nl($myfocus->column_fields[$temp]);
|
||
|
|
if ($pmodule=='Accounts')
|
||
|
|
{
|
||
|
|
$fullname=br2nl($myfocus->column_fields['accountname']);
|
||
|
|
}
|
||
|
|
elseif ($pmodule=='Contacts')
|
||
|
|
{
|
||
|
|
$fname=br2nl($myfocus->column_fields['firstname']);
|
||
|
|
$lname=br2nl($myfocus->column_fields['lastname']);
|
||
|
|
$fullname=$lname.' '.$fname;
|
||
|
|
}
|
||
|
|
elseif ($pmodule=='Leads')
|
||
|
|
{
|
||
|
|
$fname=br2nl($myfocus->column_fields['firstname']);
|
||
|
|
$lname=br2nl($myfocus->column_fields['lastname']);
|
||
|
|
$fullname=$lname.' '.$fname;
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
if (document.choosemails.emails<?php echo $x;?>.checked)
|
||
|
|
{
|
||
|
|
y=y+"@<?php echo $adb->query_result($result,$x,'fieldid');?>";
|
||
|
|
z=z+"<?php echo $fullname.'<'.$temp1.'> ;';?>";
|
||
|
|
}
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
|
||
|
|
window.opener.document.EditView.parent_id.value=y+"|";
|
||
|
|
window.opener.document.EditView.parent_name.value=z;
|
||
|
|
window.close();
|
||
|
|
}
|
||
|
|
</script>
|
||
|
|
|
||
|
|
<form name="choosemails" method="post" onsubmit="VtigerJS_DialogBox.block();">
|
||
|
|
<h4>The following emails are available for the selected record. Please choose the ones you would like to use.</h4>
|
||
|
|
<div align="center">
|
||
|
|
<table cellpadding="0" cellspacing="0" border="0">
|
||
|
|
<?php
|
||
|
|
for ($i=0;$i<$numrows;$i++)
|
||
|
|
{
|
||
|
|
$temp=$adb->query_result($result,$i,'columnname');
|
||
|
|
$temp1=br2nl($myfocus->column_fields[$temp]);
|
||
|
|
echo '<tr><td>'.$adb->query_result($result,$i,'fieldlabel').' </td><td> <input name="emails'.$i.'" type="checkbox" title="Raju"></td><td>'.$temp1.'</tr>';
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<input type="button" name="OK" onClick="passemail()" value="OK">
|
||
|
|
</div>
|
||
|
|
</form>
|