You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
202 lines
6.9 KiB
202 lines
6.9 KiB
<?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.
|
|
*
|
|
********************************************************************************/
|
|
?>
|
|
<html>
|
|
<body>
|
|
<script>
|
|
if (document.layers)
|
|
{
|
|
document.write("This feature requires IE 5.5 or higher for Windows on Microsoft Windows 2000, Windows NT4 SP6, Windows XP.");
|
|
document.write("<br><br>Click <a href='#' onclick='window.history.back();'>here</a> to return to the previous page");
|
|
}
|
|
else if (document.layers || (!document.all && document.getElementById))
|
|
{
|
|
document.write("This feature requires IE 5.5 or higher for Windows on Microsoft Windows 2000, Windows NT4 SP6, Windows XP.");
|
|
document.write("<br><br>Click <a href='#' onclick='window.history.back();'>here</a> to return to the previous page");
|
|
}
|
|
else if(document.all)
|
|
{
|
|
document.write("<OBJECT Name='vtigerCRM' codebase='modules/Settings/vtigerCRM.CAB#version=1,2,0,0' id='objMMPage' classid='clsid:0FC436C2-2E62-46EF-A3FB-E68E94705126' width=0 height=0></object>");
|
|
}
|
|
</script>
|
|
<?php
|
|
require_once('include/database/PearDatabase.php');
|
|
require_once('config.php');
|
|
//echo 'id is ....... ' .$_REQUEST['record'];
|
|
|
|
//echo 'merge file name is ...' .$_REQUEST['mergefile'];
|
|
|
|
$mergeFileName = $_REQUEST['mergefile'];
|
|
//get the particular file from db and store it in the local hard disk.
|
|
//store the path to the location where the file is stored and pass it as parameter to the method
|
|
$sql = "select filename,data,filesize from wordtemplates where filename='".$mergeFileName."'";
|
|
|
|
$result = $adb->query($sql);
|
|
$temparray = $adb->fetch_array($result);
|
|
|
|
$fileContent = $temparray['data'];
|
|
$filename=$temparray['filename'];
|
|
$filesize=$temparray['filesize'];
|
|
$wordtemplatedownloadpath =$root_directory ."/test/wordtemplatedownload/";
|
|
|
|
//echo '<br> file name and size is ..'.$filename .'...'.$filesize;
|
|
if($mergeFileName == "")
|
|
{
|
|
die("Select Mail Merge Template");
|
|
}
|
|
$handle = fopen($wordtemplatedownloadpath .$temparray['filename'],"wb");
|
|
//chmod("/home/rajeshkannan/test/".$fileContent,0755);
|
|
fwrite($handle,base64_decode($fileContent),$filesize);
|
|
fclose($handle);
|
|
|
|
//for mass merge
|
|
$mass_merge = $_REQUEST['idlist'];
|
|
|
|
if($mass_merge != "")
|
|
{
|
|
$mass_merge = explode(";",$mass_merge);
|
|
|
|
for($i=0;$i < count($mass_merge) - 1;$i++)
|
|
{
|
|
$query = "SELECT * FROM contactdetails inner join contactsubdetails on contactsubdetails.contactsubscriptionid=contactdetails.contactid inner join contactaddress on contactaddress.contactaddressid=contactdetails.contactid and contactdetails.contactid = '".$mass_merge[$i]."'";
|
|
|
|
$result = $adb->query($query);
|
|
$y=$adb->num_fields($result);
|
|
$columnValues = $adb->fetch_array($result);
|
|
|
|
for ($x=0; $x<$y; $x++)
|
|
{
|
|
$columnValString[$x] = $columnValues[$x];
|
|
}
|
|
//for custom fields
|
|
$sql2 = "select contactscf.* from contactscf inner join contactdetails on contactdetails.contactid = contactscf.contactid where contactdetails.contactid = '".$mass_merge[$i]."'";
|
|
$result2 = $adb->query($sql2);
|
|
$numRows2 = $adb->num_fields($result2);
|
|
$custom_field_values = $adb->fetch_array($result2);
|
|
for ($z=1; $z<$numRows2; $z++)
|
|
{
|
|
$custom_values_str[$z] = $custom_field_values[$z];
|
|
}
|
|
//end custom fields
|
|
$merged_columnValString = array_merge($columnValString,$custom_values_str);
|
|
|
|
$mass_columnString = implode(",",$merged_columnValString);
|
|
$mass_columnValString = $mass_columnValString.$mass_columnString;
|
|
if($i < count($mass_merge) - 2)
|
|
{
|
|
$mass_columnValString = $mass_columnValString."###";
|
|
}
|
|
}
|
|
$columnValString = $mass_columnValString;
|
|
}
|
|
//end for mass merge
|
|
$query = "SELECT * FROM troubletickets where troubletickets.ticketid = '".$_REQUEST['record'] ."'";
|
|
|
|
//$query = "SELECT * FROM contactdetails,contactsubdetails,contactaddress where contactid = '".$_REQUEST['record'] ."'";
|
|
//echo $query;
|
|
$result = $adb->query($query);
|
|
|
|
$y=$adb->num_fields($result);
|
|
|
|
for ($x=0; $x<$y; $x++)
|
|
{
|
|
$fld = $adb->field_name($result, $x);
|
|
$columnNames[$x] = "TICKET_".strtoupper($fld->name);
|
|
}
|
|
|
|
//condition added for mass merge
|
|
if($mass_merge == "")
|
|
{
|
|
$columnValues = $adb->fetch_array($result);
|
|
for ($x=0; $x<$y; $x++)
|
|
{
|
|
$columnValString[$x] = str_replace(","," ",$columnValues[$x]);
|
|
}
|
|
//$columnValString = implode(",",$columnValString);
|
|
|
|
//<<<<<<<<<<<<<<<<to fetch values of custom fields>>>>>>>>>>>>>>>>>>>>>>
|
|
$sql2 = "select ticketcf.* from ticketcf inner join troubletickets on troubletickets.ticketid = ticketcf.ticketid where troubletickets.ticketid = '".$_REQUEST['record'] ."'";
|
|
$result2 = $adb->query($sql2);
|
|
$numRows2 = $adb->num_fields($result2);
|
|
$custom_field_values = $adb->fetch_array($result2);
|
|
for ($i=1; $i<$numRows2; $i++)
|
|
{
|
|
$custom_values_str[$i] = $custom_field_values[$i];
|
|
}
|
|
//<<<<<<<<<<<<<<<<end fetch values of custom fields>>>>>>>>>>>>>>>>>>>>>>
|
|
$columnValString = array_merge($columnValString,$custom_values_str);
|
|
$columnValString = implode(",",$columnValString);
|
|
}
|
|
//end condition added for mass merge
|
|
|
|
//start custom fields
|
|
$sql1 = "select fieldlabel from field where generatedtype=2 and tabid=13";
|
|
$result = $adb->query($sql1);
|
|
$numRows = $adb->num_rows($result);
|
|
for($i=0; $i < $numRows;$i++)
|
|
{
|
|
$custom_fields[$i] = "TICKET_".strtoupper(str_replace(" ","",$adb->query_result($result,$i,"fieldlabel")));
|
|
}
|
|
$column_string = array_merge($columnNames,$custom_fields);
|
|
//end custom fields
|
|
|
|
$columnString = implode(",",$column_string);
|
|
//echo $columnString;
|
|
//echo $columnValString;
|
|
|
|
echo"<script type=\"text/javascript\">
|
|
var dHdr = '$columnString';
|
|
var dSrc = '$columnValString';
|
|
</script>";
|
|
//echo $site_URL."/test/wordtemplatedownload/".$filename;
|
|
|
|
?>
|
|
<script>
|
|
if (window.ActiveXObject){
|
|
try
|
|
{
|
|
ovtigerVM = eval("new ActiveXObject('vtigerCRM.ActiveX');");
|
|
if(ovtigerVM)
|
|
{
|
|
var filename = "<?php echo $filename?>";
|
|
if(filename != "")
|
|
{
|
|
if(objMMPage.bDLTempDoc("<?php echo $site_URL?>/test/wordtemplatedownload/<?php echo $filename?>","MMTemplate.doc"))
|
|
{
|
|
try
|
|
{
|
|
if(objMMPage.Init())
|
|
{
|
|
objMMPage.vLTemplateDoc();
|
|
objMMPage.vBulkHDSrc(dHdr,dSrc);
|
|
objMMPage.vBulkOpenDoc();
|
|
objMMPage.UnInit()
|
|
window.history.back();
|
|
}
|
|
}catch(errorObject)
|
|
{
|
|
document.write("Error while processing mail merge operation");
|
|
}
|
|
}else
|
|
{
|
|
document.write("Cannot get template document");
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch(e) {
|
|
document.write("Requires to download ActiveX Control from vtigerCRM. Please, ensure that you have administration privilage");
|
|
}
|
|
}
|
|
</script>
|
|
</body>
|
|
</html>
|
|
|
|
|