Log in
Contact
Forum
Hello, Actually we are adding images in word document using phpdocx libraryby following function :
function replacePlaceHolderByImage($target,$schemeCode, $templateDocx,$variableDetails,$tableFileName){
global $INPUT_DIRECTORY,$OUTPUT_DIRECTORY,$error_found,$template_file_name,$temp_scheme_code;
#get template filename without extension and attach scheme_code to it.
$templateFileNameWithoutExtention = explode('.',$template_file_name);
$templateFileNameWithoutExtention = str_replace("_template", "", $templateFileNameWithoutExtention);
$outputSidFileName=$templateFileNameWithoutExtention[0]."_".$schemeCode.".".$templateFileNameWithoutExtention[1];
mLog("replacePlaceHolderByImage :::: $outputSidFileName");
$imageFileName = '';
$placeHolderName = $variableDetails[0];
$placeHolderName = $_SESSION['session_placeholder_name']; //rupali
if(trim($variableDetails[2]) == 'table'){
$imageFileName = getCellValueByColumnNameAndSchemeCode($schemeCode,$columnName = $placeHolderName, $tableFileName,$tableName = $variableDetails[3]);
}else if(trim($variableDetails[2]) == 'query'){
$imageFileName = getSingleCellTextValueFromSqlQuery($schemeCode,$selectQuery=$variableDetails[3]);
}else if(trim($variableDetails[2]) == 'table_query'){
$selectQuery = getCellValueByColumnNameAndSchemeCode($schemeCode,$columnName = $placeHolderName, $tableFileName, $tableName = $variableDetails[3]);
$imageFileName = getSingleCellTextValueFromSqlQuery($schemeCode,$selectQuery);
}else{
$imageFileName = $variableDetails[3];
}
if($placeHolderName == 'img_prc'){
// Check if the string contents match a valid file extension pattern
if (preg_match('/^\.[a-zA-Z0-9]+$/', $imageFileName)) {
// String contents match the pattern of a valid file extension, so assign an empty string
$imageFileName = '';
}
}else{
// Check if the file name ends with "_".png
if (preg_match('/_.png$/', $imageFileName)) {
// Replace the file name with an empty string
$imageFileName = '';
}
}
if(empty($imageFileName) || $imageFileName=='off'){
mLog("Warning: Empty file name exception: File name is empty for the variable $placeHolderName");
mLogError("Warning : Empty file name exception: File name is empty for the variable $placeHolderName");
try {
$getRunIdQuery = "SELECT id FROM fs_background_jobs WHERE 'status'='R' LIMIT 1";
$mysqliConnection=getMysqliConnection();
$run_id = $mysqliConnection->query($getRunIdQuery);
if($temp_scheme_code != ''){
if($temp_scheme_code == $schemeCode){
file_put_contents($OUTPUT_DIRECTORY."/"."remove-images.txt", "~$$placeHolderName$", FILE_APPEND | LOCK_EX);
}
else{
file_put_contents($OUTPUT_DIRECTORY."/"."remove-images.txt", "\n$outputSidFileName^$$placeHolderName$", FILE_APPEND | LOCK_EX);
}
}
else{
file_put_contents($OUTPUT_DIRECTORY."/"."remove-images.txt", "$outputSidFileName^$$placeHolderName$", FILE_APPEND | LOCK_EX);
}
// Force a flush of the output to the file
clearstatcache();
}catch (Exception $e){
mLogError("An error occurred: $e->getMessage()");
}
$temp_scheme_code = $schemeCode;
$templateDocx->removeTemplateVariable($placeHolderName, 'inline');
return $templateDocx;
}
if(!file_exists("$INPUT_DIRECTORY/$imageFileName")){
//$error_found = $error_found + 1;
mlog("Missing file exception: File not found in the input folder $imageFileName");
mLogError("Missing file exception: File not found in the input folder $imageFileName");
//mLogError("-------$error_found Error(s) Found");
return $templateDocx;
}
if($target == 'footer'){
$options = array('target'=>$target);
$templateDocx->replacePlaceholderImage($placeHolderName, "$INPUT_DIRECTORY/$imageFileName", $options);
}else{
$templateDocx->replacePlaceholderImage($placeHolderName, "$INPUT_DIRECTORY/$imageFileName");
}
return $templateDocx;
}
here original image quality is good but it is not maintained in document after inserting an image quality is decreasing. Can you suggest us any tecnique to maintain quality of images in document file