Core.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334
  1. <?php
  2. /**
  3. * 重庆赤晓店信息科技有限公司
  4. * https://www.chixiaodian.com
  5. * Copyright (c) 2023 赤店商城 All rights reserved.
  6. */
  7. abstract class PHPExcel_Writer_PDF_Core extends PHPExcel_Writer_HTML
  8. {
  9. /**
  10. * Temporary storage directory
  11. *
  12. * @var string
  13. */
  14. protected $tempDir = '';
  15. /**
  16. * Font
  17. *
  18. * @var string
  19. */
  20. protected $font = 'freesans';
  21. /**
  22. * Orientation (Over-ride)
  23. *
  24. * @var string
  25. */
  26. protected $orientation;
  27. /**
  28. * Paper size (Over-ride)
  29. *
  30. * @var int
  31. */
  32. protected $paperSize;
  33. /**
  34. * Temporary storage for Save Array Return type
  35. *
  36. * @var string
  37. */
  38. private $saveArrayReturnType;
  39. /**
  40. * Paper Sizes xRef List
  41. *
  42. * @var array
  43. */
  44. protected static $paperSizes = array(
  45. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER
  46. => 'LETTER', // (8.5 in. by 11 in.)
  47. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_SMALL
  48. => 'LETTER', // (8.5 in. by 11 in.)
  49. PHPExcel_Worksheet_PageSetup::PAPERSIZE_TABLOID
  50. => array(792.00, 1224.00), // (11 in. by 17 in.)
  51. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEDGER
  52. => array(1224.00, 792.00), // (17 in. by 11 in.)
  53. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEGAL
  54. => 'LEGAL', // (8.5 in. by 14 in.)
  55. PHPExcel_Worksheet_PageSetup::PAPERSIZE_STATEMENT
  56. => array(396.00, 612.00), // (5.5 in. by 8.5 in.)
  57. PHPExcel_Worksheet_PageSetup::PAPERSIZE_EXECUTIVE
  58. => 'EXECUTIVE', // (7.25 in. by 10.5 in.)
  59. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3
  60. => 'A3', // (297 mm by 420 mm)
  61. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4
  62. => 'A4', // (210 mm by 297 mm)
  63. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_SMALL
  64. => 'A4', // (210 mm by 297 mm)
  65. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5
  66. => 'A5', // (148 mm by 210 mm)
  67. PHPExcel_Worksheet_PageSetup::PAPERSIZE_B4
  68. => 'B4', // (250 mm by 353 mm)
  69. PHPExcel_Worksheet_PageSetup::PAPERSIZE_B5
  70. => 'B5', // (176 mm by 250 mm)
  71. PHPExcel_Worksheet_PageSetup::PAPERSIZE_FOLIO
  72. => 'FOLIO', // (8.5 in. by 13 in.)
  73. PHPExcel_Worksheet_PageSetup::PAPERSIZE_QUARTO
  74. => array(609.45, 779.53), // (215 mm by 275 mm)
  75. PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_1
  76. => array(720.00, 1008.00), // (10 in. by 14 in.)
  77. PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_2
  78. => array(792.00, 1224.00), // (11 in. by 17 in.)
  79. PHPExcel_Worksheet_PageSetup::PAPERSIZE_NOTE
  80. => 'LETTER', // (8.5 in. by 11 in.)
  81. PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO9_ENVELOPE
  82. => array(279.00, 639.00), // (3.875 in. by 8.875 in.)
  83. PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO10_ENVELOPE
  84. => array(297.00, 684.00), // (4.125 in. by 9.5 in.)
  85. PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO11_ENVELOPE
  86. => array(324.00, 747.00), // (4.5 in. by 10.375 in.)
  87. PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO12_ENVELOPE
  88. => array(342.00, 792.00), // (4.75 in. by 11 in.)
  89. PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO14_ENVELOPE
  90. => array(360.00, 828.00), // (5 in. by 11.5 in.)
  91. PHPExcel_Worksheet_PageSetup::PAPERSIZE_C
  92. => array(1224.00, 1584.00), // (17 in. by 22 in.)
  93. PHPExcel_Worksheet_PageSetup::PAPERSIZE_D
  94. => array(1584.00, 2448.00), // (22 in. by 34 in.)
  95. PHPExcel_Worksheet_PageSetup::PAPERSIZE_E
  96. => array(2448.00, 3168.00), // (34 in. by 44 in.)
  97. PHPExcel_Worksheet_PageSetup::PAPERSIZE_DL_ENVELOPE
  98. => array(311.81, 623.62), // (110 mm by 220 mm)
  99. PHPExcel_Worksheet_PageSetup::PAPERSIZE_C5_ENVELOPE
  100. => 'C5', // (162 mm by 229 mm)
  101. PHPExcel_Worksheet_PageSetup::PAPERSIZE_C3_ENVELOPE
  102. => 'C3', // (324 mm by 458 mm)
  103. PHPExcel_Worksheet_PageSetup::PAPERSIZE_C4_ENVELOPE
  104. => 'C4', // (229 mm by 324 mm)
  105. PHPExcel_Worksheet_PageSetup::PAPERSIZE_C6_ENVELOPE
  106. => 'C6', // (114 mm by 162 mm)
  107. PHPExcel_Worksheet_PageSetup::PAPERSIZE_C65_ENVELOPE
  108. => array(323.15, 649.13), // (114 mm by 229 mm)
  109. PHPExcel_Worksheet_PageSetup::PAPERSIZE_B4_ENVELOPE
  110. => 'B4', // (250 mm by 353 mm)
  111. PHPExcel_Worksheet_PageSetup::PAPERSIZE_B5_ENVELOPE
  112. => 'B5', // (176 mm by 250 mm)
  113. PHPExcel_Worksheet_PageSetup::PAPERSIZE_B6_ENVELOPE
  114. => array(498.90, 354.33), // (176 mm by 125 mm)
  115. PHPExcel_Worksheet_PageSetup::PAPERSIZE_ITALY_ENVELOPE
  116. => array(311.81, 651.97), // (110 mm by 230 mm)
  117. PHPExcel_Worksheet_PageSetup::PAPERSIZE_MONARCH_ENVELOPE
  118. => array(279.00, 540.00), // (3.875 in. by 7.5 in.)
  119. PHPExcel_Worksheet_PageSetup::PAPERSIZE_6_3_4_ENVELOPE
  120. => array(261.00, 468.00), // (3.625 in. by 6.5 in.)
  121. PHPExcel_Worksheet_PageSetup::PAPERSIZE_US_STANDARD_FANFOLD
  122. => array(1071.00, 792.00), // (14.875 in. by 11 in.)
  123. PHPExcel_Worksheet_PageSetup::PAPERSIZE_GERMAN_STANDARD_FANFOLD
  124. => array(612.00, 864.00), // (8.5 in. by 12 in.)
  125. PHPExcel_Worksheet_PageSetup::PAPERSIZE_GERMAN_LEGAL_FANFOLD
  126. => 'FOLIO', // (8.5 in. by 13 in.)
  127. PHPExcel_Worksheet_PageSetup::PAPERSIZE_ISO_B4
  128. => 'B4', // (250 mm by 353 mm)
  129. PHPExcel_Worksheet_PageSetup::PAPERSIZE_JAPANESE_DOUBLE_POSTCARD
  130. => array(566.93, 419.53), // (200 mm by 148 mm)
  131. PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_1
  132. => array(648.00, 792.00), // (9 in. by 11 in.)
  133. PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_2
  134. => array(720.00, 792.00), // (10 in. by 11 in.)
  135. PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_3
  136. => array(1080.00, 792.00), // (15 in. by 11 in.)
  137. PHPExcel_Worksheet_PageSetup::PAPERSIZE_INVITE_ENVELOPE
  138. => array(623.62, 623.62), // (220 mm by 220 mm)
  139. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_EXTRA_PAPER
  140. => array(667.80, 864.00), // (9.275 in. by 12 in.)
  141. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEGAL_EXTRA_PAPER
  142. => array(667.80, 1080.00), // (9.275 in. by 15 in.)
  143. PHPExcel_Worksheet_PageSetup::PAPERSIZE_TABLOID_EXTRA_PAPER
  144. => array(841.68, 1296.00), // (11.69 in. by 18 in.)
  145. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_EXTRA_PAPER
  146. => array(668.98, 912.76), // (236 mm by 322 mm)
  147. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_TRANSVERSE_PAPER
  148. => array(595.80, 792.00), // (8.275 in. by 11 in.)
  149. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_TRANSVERSE_PAPER
  150. => 'A4', // (210 mm by 297 mm)
  151. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER
  152. => array(667.80, 864.00), // (9.275 in. by 12 in.)
  153. PHPExcel_Worksheet_PageSetup::PAPERSIZE_SUPERA_SUPERA_A4_PAPER
  154. => array(643.46, 1009.13), // (227 mm by 356 mm)
  155. PHPExcel_Worksheet_PageSetup::PAPERSIZE_SUPERB_SUPERB_A3_PAPER
  156. => array(864.57, 1380.47), // (305 mm by 487 mm)
  157. PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_PLUS_PAPER
  158. => array(612.00, 913.68), // (8.5 in. by 12.69 in.)
  159. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_PLUS_PAPER
  160. => array(595.28, 935.43), // (210 mm by 330 mm)
  161. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5_TRANSVERSE_PAPER
  162. => 'A5', // (148 mm by 210 mm)
  163. PHPExcel_Worksheet_PageSetup::PAPERSIZE_JIS_B5_TRANSVERSE_PAPER
  164. => array(515.91, 728.50), // (182 mm by 257 mm)
  165. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_EXTRA_PAPER
  166. => array(912.76, 1261.42), // (322 mm by 445 mm)
  167. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5_EXTRA_PAPER
  168. => array(493.23, 666.14), // (174 mm by 235 mm)
  169. PHPExcel_Worksheet_PageSetup::PAPERSIZE_ISO_B5_EXTRA_PAPER
  170. => array(569.76, 782.36), // (201 mm by 276 mm)
  171. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A2_PAPER
  172. => 'A2', // (420 mm by 594 mm)
  173. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_TRANSVERSE_PAPER
  174. => 'A3', // (297 mm by 420 mm)
  175. PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER
  176. => array(912.76, 1261.42) // (322 mm by 445 mm)
  177. );
  178. /**
  179. * Create a new PHPExcel_Writer_PDF
  180. *
  181. * @param PHPExcel $phpExcel PHPExcel object
  182. */
  183. public function __construct(PHPExcel $phpExcel)
  184. {
  185. parent::__construct($phpExcel);
  186. $this->setUseInlineCss(true);
  187. $this->tempDir = PHPExcel_Shared_File::sys_get_temp_dir();
  188. }
  189. /**
  190. * Get Font
  191. *
  192. * @return string
  193. */
  194. public function getFont()
  195. {
  196. return $this->font;
  197. }
  198. /**
  199. * Set font. Examples:
  200. * 'arialunicid0-chinese-simplified'
  201. * 'arialunicid0-chinese-traditional'
  202. * 'arialunicid0-korean'
  203. * 'arialunicid0-japanese'
  204. *
  205. * @param string $fontName
  206. */
  207. public function setFont($fontName)
  208. {
  209. $this->font = $fontName;
  210. return $this;
  211. }
  212. /**
  213. * Get Paper Size
  214. *
  215. * @return int
  216. */
  217. public function getPaperSize()
  218. {
  219. return $this->paperSize;
  220. }
  221. /**
  222. * Set Paper Size
  223. *
  224. * @param string $pValue Paper size
  225. * @return PHPExcel_Writer_PDF
  226. */
  227. public function setPaperSize($pValue = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER)
  228. {
  229. $this->paperSize = $pValue;
  230. return $this;
  231. }
  232. /**
  233. * Get Orientation
  234. *
  235. * @return string
  236. */
  237. public function getOrientation()
  238. {
  239. return $this->orientation;
  240. }
  241. /**
  242. * Set Orientation
  243. *
  244. * @param string $pValue Page orientation
  245. * @return PHPExcel_Writer_PDF
  246. */
  247. public function setOrientation($pValue = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT)
  248. {
  249. $this->orientation = $pValue;
  250. return $this;
  251. }
  252. /**
  253. * Get temporary storage directory
  254. *
  255. * @return string
  256. */
  257. public function getTempDir()
  258. {
  259. return $this->tempDir;
  260. }
  261. /**
  262. * Set temporary storage directory
  263. *
  264. * @param string $pValue Temporary storage directory
  265. * @throws PHPExcel_Writer_Exception when directory does not exist
  266. * @return PHPExcel_Writer_PDF
  267. */
  268. public function setTempDir($pValue = '')
  269. {
  270. if (is_dir($pValue)) {
  271. $this->tempDir = $pValue;
  272. } else {
  273. throw new PHPExcel_Writer_Exception("Directory does not exist: $pValue");
  274. }
  275. return $this;
  276. }
  277. /**
  278. * Save PHPExcel to PDF file, pre-save
  279. *
  280. * @param string $pFilename Name of the file to save as
  281. * @throws PHPExcel_Writer_Exception
  282. */
  283. protected function prepareForSave($pFilename = null)
  284. {
  285. // garbage collect
  286. $this->phpExcel->garbageCollect();
  287. $this->saveArrayReturnType = PHPExcel_Calculation::getArrayReturnType();
  288. PHPExcel_Calculation::setArrayReturnType(PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE);
  289. // Open file
  290. $fileHandle = fopen($pFilename, 'w');
  291. if ($fileHandle === false) {
  292. throw new PHPExcel_Writer_Exception("Could not open file $pFilename for writing.");
  293. }
  294. // Set PDF
  295. $this->isPdf = true;
  296. // Build CSS
  297. $this->buildCSS(true);
  298. return $fileHandle;
  299. }
  300. /**
  301. * Save PHPExcel to PDF file, post-save
  302. *
  303. * @param resource $fileHandle
  304. * @throws PHPExcel_Writer_Exception
  305. */
  306. protected function restoreStateAfterSave($fileHandle)
  307. {
  308. // Close file
  309. fclose($fileHandle);
  310. PHPExcel_Calculation::setArrayReturnType($this->saveArrayReturnType);
  311. }
  312. }