Advertisement
azharnian

Make Report PDF using libreoffice in PHP

Sep 25th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.48 KB | None | 0 0
  1. <?php
  2. $config_libreoffice_path='C:\\Program Files (x86)\\LibreOffice 5\\program\\soffice.exe';
  3. $config_temp_dir='C:\\temp';
  4. $fname='surat';
  5.  
  6. header('Expires: Tue, 1 Jan 2019 00:00:00 GMT');
  7. header('Cache-Control: no-cache');
  8. header('Pragma: no-cache');
  9. header('Content-Disposition: attachment; filename="'.$fname.'.pdf"');
  10. header('Content-Type: application/pdf');
  11.  
  12. $field=array('{KEPADA}', '{TEMPAT}', '{PEJABAT}');
  13. $replace=array('Budi', 'Jakarta', 'Amir');
  14.  
  15. //$template=file_get_contents('C:\xampp\htdocs\cetak\surat.xml');
  16. //file_put_contents($config_temp_dir.'\\'.$fname.'.xml', str_replace($field, $replace, $template));
  17.  
  18. exec('"'.$config_libreoffice_path.'" --headless --convert-to pdf:writer_pdf_Export --outdir "'.$config_temp_dir.'" "'.$config_temp_dir.'\\'.$fname.'.xml"');
  19. readfile($config_temp_dir.'\\'.$fname.'.pdf');
  20.  
  21. /*
  22. xls :
  23. header('Content-Disposition: attachment; filename="'.$fname.'.xls"');
  24. header('Content-Type: application/vnd.ms-excel');
  25. exec('"'.$config_libreoffice_path.'" -headless -convert-to xls:"MS Excel 97" -outdir "'.$config_temp_dir.'" "'.$config_temp_dir.'\\'.$fname.'.xml"');
  26. readfile($config_temp_dir.'\\'.$fname.'.xls');
  27. doc :
  28. header('Content-Disposition: attachment; filename="'.$fname.'.doc"');
  29. header('Content-Type: application/vnd.ms-word');
  30. exec('"'.$config_libreoffice_path.'" -headless -convert-to doc:"MS Word 97" -outdir "'.$config_temp_dir.'" "'.$config_temp_dir.'\\'.$fname.'.xml"');
  31. readfile($config_temp_dir.'\\'.$fname.'.doc');
  32. */
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement