| Server IP : 138.197.176.125 / Your IP : 216.73.216.41 Web Server : Apache/2.4.41 (Ubuntu) System : Linux SuiteCRM-8 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : root ( 0) PHP Version : 8.3.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/googleoffice365SuiteTesting/modules/Utilities/ |
Upload File : |
<html>
<body>
<?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.
********************************************************************************/
require_once('include/database/PearDatabase.php');
global $default_charset;
// Fix For: http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/2107
$randomfilename = "vt_" . str_replace(array("."," "), "", microtime());
$mergeFileName = vtlib_purify($_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 vtiger_wordtemplatestorage where filename=?";
$result = $adb->pquery($sql, array($mergeFileName));
$temparray = $adb->fetch_array($result);
$fileContent = $temparray['data'];
$filename=html_entity_decode($temparray['filename'], ENT_QUOTES, $default_charset);
// Fix For: http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/2107
$filename= $randomfilename . "_word.doc";
$filesize=$temparray['filesize'];
$wordtemplatedownloadpath =$_SERVER['DOCUMENT_ROOT'] ."/test/wordtemplatedownload/";
checkFileAccess($wordtemplatedownloadpath);
$handle = fopen($wordtemplatedownloadpath .$filename,"wb") ;
fwrite($handle,base64_decode($fileContent),$filesize);
fclose($handle);
$query = "SELECT * FROM " .$adb->sql_escape_string($_REQUEST["module"]) ." WHERE id = ?";
$result = $adb->pquery($query, array($_REQUEST['record']));
$y=$adb->num_fields($result);
for ($x=0; $x<$y; $x++)
{
$columnNames[$x] = "CONTACT_".strtoupper($adb->field_name($result, $x));
}
$columnValues = $adb->fetch_array($result);
for ($x=0; $x<$y; $x++)
{
$columnValString[$x] = $columnValues[$x];
}
$columnString = implode(",",$columnNames);
$columnValString = implode(",",$columnValString);
echo"<script type=\"text/javascript\">
var dHdr = '$columnString';
var dSrc = '$columnValString';
</script>";
?>
<OBJECT Name="vtigerVM" codebase="http://<?php echo $_SERVER["HTTP_HOST"] ?>/modules/Settings/vtigerVM.CAB#Version1,0,0,1"
id="objMMPage" classid="clsid:42C50C38-1984-4393-A736-890357E7112B" width=0 height=0></object><!--METADATA TYPE="MsHtmlPageDesigner" endspan-->
<Script>
if(objMMPage.bDLTempDoc("http://"+"<?php echo $_SERVER["HTTP_HOST"] ?>/test/wordtemplatedownload/"+"<?php echo $filename?>","MMTemplate.doc"))
{
try
{
if(objMMPage.Init())
{
objMMPage.vLTemplateDoc();
//objMMPage.vGetHDSrc(dHdr,dSrc);
objMMPage.vBulkHDSrc(dHdr,dSrc);
//objMMPage.vOpenDoc();
objMMPage.vBulkOpenDoc();
objMMPage.UnInit()
document.write("Template Document Merged with selected contacts data");
}
}catch(errorObject)
{
}
}
</Script>
</body>
</html>