Proyectos de Subversion Moodle

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1441 ariadna 1
<?php
2
 
3
namespace PhpOffice\PhpSpreadsheet\Writer;
4
 
5
use PhpOffice\PhpSpreadsheet\Shared\File;
6
use PhpOffice\PhpSpreadsheet\Spreadsheet;
7
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;
8
use PhpOffice\PhpSpreadsheet\Writer\Exception as WriterException;
9
 
10
abstract class Pdf extends Html
11
{
12
    /**
13
     * Temporary storage directory.
14
     */
15
    protected string $tempDir;
16
 
17
    /**
18
     * Font.
19
     */
20
    protected string $font = 'freesans';
21
 
22
    /**
23
     * Orientation (Over-ride).
24
     */
25
    protected ?string $orientation = null;
26
 
27
    /**
28
     * Paper size (Over-ride).
29
     */
30
    protected ?int $paperSize = null;
31
 
32
    /**
33
     * Paper Sizes xRef List.
34
     */
35
    protected static array $paperSizes = [
36
        PageSetup::PAPERSIZE_LETTER => 'LETTER', //    (8.5 in. by 11 in.)
37
        PageSetup::PAPERSIZE_LETTER_SMALL => 'LETTER', //    (8.5 in. by 11 in.)
38
        PageSetup::PAPERSIZE_TABLOID => [792.00, 1224.00], //    (11 in. by 17 in.)
39
        PageSetup::PAPERSIZE_LEDGER => [1224.00, 792.00], //    (17 in. by 11 in.)
40
        PageSetup::PAPERSIZE_LEGAL => 'LEGAL', //    (8.5 in. by 14 in.)
41
        PageSetup::PAPERSIZE_STATEMENT => [396.00, 612.00], //    (5.5 in. by 8.5 in.)
42
        PageSetup::PAPERSIZE_EXECUTIVE => 'EXECUTIVE', //    (7.25 in. by 10.5 in.)
43
        PageSetup::PAPERSIZE_A3 => 'A3', //    (297 mm by 420 mm)
44
        PageSetup::PAPERSIZE_A4 => 'A4', //    (210 mm by 297 mm)
45
        PageSetup::PAPERSIZE_A4_SMALL => 'A4', //    (210 mm by 297 mm)
46
        PageSetup::PAPERSIZE_A5 => 'A5', //    (148 mm by 210 mm)
47
        PageSetup::PAPERSIZE_B4 => 'B4', //    (250 mm by 353 mm)
48
        PageSetup::PAPERSIZE_B5 => 'B5', //    (176 mm by 250 mm)
49
        PageSetup::PAPERSIZE_FOLIO => 'FOLIO', //    (8.5 in. by 13 in.)
50
        PageSetup::PAPERSIZE_QUARTO => [609.45, 779.53], //    (215 mm by 275 mm)
51
        PageSetup::PAPERSIZE_STANDARD_1 => [720.00, 1008.00], //    (10 in. by 14 in.)
52
        PageSetup::PAPERSIZE_STANDARD_2 => [792.00, 1224.00], //    (11 in. by 17 in.)
53
        PageSetup::PAPERSIZE_NOTE => 'LETTER', //    (8.5 in. by 11 in.)
54
        PageSetup::PAPERSIZE_NO9_ENVELOPE => [279.00, 639.00], //    (3.875 in. by 8.875 in.)
55
        PageSetup::PAPERSIZE_NO10_ENVELOPE => [297.00, 684.00], //    (4.125 in. by 9.5 in.)
56
        PageSetup::PAPERSIZE_NO11_ENVELOPE => [324.00, 747.00], //    (4.5 in. by 10.375 in.)
57
        PageSetup::PAPERSIZE_NO12_ENVELOPE => [342.00, 792.00], //    (4.75 in. by 11 in.)
58
        PageSetup::PAPERSIZE_NO14_ENVELOPE => [360.00, 828.00], //    (5 in. by 11.5 in.)
59
        PageSetup::PAPERSIZE_C => [1224.00, 1584.00], //    (17 in. by 22 in.)
60
        PageSetup::PAPERSIZE_D => [1584.00, 2448.00], //    (22 in. by 34 in.)
61
        PageSetup::PAPERSIZE_E => [2448.00, 3168.00], //    (34 in. by 44 in.)
62
        PageSetup::PAPERSIZE_DL_ENVELOPE => [311.81, 623.62], //    (110 mm by 220 mm)
63
        PageSetup::PAPERSIZE_C5_ENVELOPE => 'C5', //    (162 mm by 229 mm)
64
        PageSetup::PAPERSIZE_C3_ENVELOPE => 'C3', //    (324 mm by 458 mm)
65
        PageSetup::PAPERSIZE_C4_ENVELOPE => 'C4', //    (229 mm by 324 mm)
66
        PageSetup::PAPERSIZE_C6_ENVELOPE => 'C6', //    (114 mm by 162 mm)
67
        PageSetup::PAPERSIZE_C65_ENVELOPE => [323.15, 649.13], //    (114 mm by 229 mm)
68
        PageSetup::PAPERSIZE_B4_ENVELOPE => 'B4', //    (250 mm by 353 mm)
69
        PageSetup::PAPERSIZE_B5_ENVELOPE => 'B5', //    (176 mm by 250 mm)
70
        PageSetup::PAPERSIZE_B6_ENVELOPE => [498.90, 354.33], //    (176 mm by 125 mm)
71
        PageSetup::PAPERSIZE_ITALY_ENVELOPE => [311.81, 651.97], //    (110 mm by 230 mm)
72
        PageSetup::PAPERSIZE_MONARCH_ENVELOPE => [279.00, 540.00], //    (3.875 in. by 7.5 in.)
73
        PageSetup::PAPERSIZE_6_3_4_ENVELOPE => [261.00, 468.00], //    (3.625 in. by 6.5 in.)
74
        PageSetup::PAPERSIZE_US_STANDARD_FANFOLD => [1071.00, 792.00], //    (14.875 in. by 11 in.)
75
        PageSetup::PAPERSIZE_GERMAN_STANDARD_FANFOLD => [612.00, 864.00], //    (8.5 in. by 12 in.)
76
        PageSetup::PAPERSIZE_GERMAN_LEGAL_FANFOLD => 'FOLIO', //    (8.5 in. by 13 in.)
77
        PageSetup::PAPERSIZE_ISO_B4 => 'B4', //    (250 mm by 353 mm)
78
        PageSetup::PAPERSIZE_JAPANESE_DOUBLE_POSTCARD => [566.93, 419.53], //    (200 mm by 148 mm)
79
        PageSetup::PAPERSIZE_STANDARD_PAPER_1 => [648.00, 792.00], //    (9 in. by 11 in.)
80
        PageSetup::PAPERSIZE_STANDARD_PAPER_2 => [720.00, 792.00], //    (10 in. by 11 in.)
81
        PageSetup::PAPERSIZE_STANDARD_PAPER_3 => [1080.00, 792.00], //    (15 in. by 11 in.)
82
        PageSetup::PAPERSIZE_INVITE_ENVELOPE => [623.62, 623.62], //    (220 mm by 220 mm)
83
        PageSetup::PAPERSIZE_LETTER_EXTRA_PAPER => [667.80, 864.00], //    (9.275 in. by 12 in.)
84
        PageSetup::PAPERSIZE_LEGAL_EXTRA_PAPER => [667.80, 1080.00], //    (9.275 in. by 15 in.)
85
        PageSetup::PAPERSIZE_TABLOID_EXTRA_PAPER => [841.68, 1296.00], //    (11.69 in. by 18 in.)
86
        PageSetup::PAPERSIZE_A4_EXTRA_PAPER => [668.98, 912.76], //    (236 mm by 322 mm)
87
        PageSetup::PAPERSIZE_LETTER_TRANSVERSE_PAPER => [595.80, 792.00], //    (8.275 in. by 11 in.)
88
        PageSetup::PAPERSIZE_A4_TRANSVERSE_PAPER => 'A4', //    (210 mm by 297 mm)
89
        PageSetup::PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER => [667.80, 864.00], //    (9.275 in. by 12 in.)
90
        PageSetup::PAPERSIZE_SUPERA_SUPERA_A4_PAPER => [643.46, 1009.13], //    (227 mm by 356 mm)
91
        PageSetup::PAPERSIZE_SUPERB_SUPERB_A3_PAPER => [864.57, 1380.47], //    (305 mm by 487 mm)
92
        PageSetup::PAPERSIZE_LETTER_PLUS_PAPER => [612.00, 913.68], //    (8.5 in. by 12.69 in.)
93
        PageSetup::PAPERSIZE_A4_PLUS_PAPER => [595.28, 935.43], //    (210 mm by 330 mm)
94
        PageSetup::PAPERSIZE_A5_TRANSVERSE_PAPER => 'A5', //    (148 mm by 210 mm)
95
        PageSetup::PAPERSIZE_JIS_B5_TRANSVERSE_PAPER => [515.91, 728.50], //    (182 mm by 257 mm)
96
        PageSetup::PAPERSIZE_A3_EXTRA_PAPER => [912.76, 1261.42], //    (322 mm by 445 mm)
97
        PageSetup::PAPERSIZE_A5_EXTRA_PAPER => [493.23, 666.14], //    (174 mm by 235 mm)
98
        PageSetup::PAPERSIZE_ISO_B5_EXTRA_PAPER => [569.76, 782.36], //    (201 mm by 276 mm)
99
        PageSetup::PAPERSIZE_A2_PAPER => 'A2', //    (420 mm by 594 mm)
100
        PageSetup::PAPERSIZE_A3_TRANSVERSE_PAPER => 'A3', //    (297 mm by 420 mm)
101
        PageSetup::PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER => [912.76, 1261.42], //    (322 mm by 445 mm)
102
    ];
103
 
104
    /**
105
     * Create a new PDF Writer instance.
106
     *
107
     * @param Spreadsheet $spreadsheet Spreadsheet object
108
     */
109
    public function __construct(Spreadsheet $spreadsheet)
110
    {
111
        parent::__construct($spreadsheet);
112
        //$this->setUseInlineCss(true);
113
        $this->tempDir = File::sysGetTempDir() . '/phpsppdf';
114
        $this->isPdf = true;
115
    }
116
 
117
    /**
118
     * Get Font.
119
     */
120
    public function getFont(): string
121
    {
122
        return $this->font;
123
    }
124
 
125
    /**
126
     * Set font. Examples:
127
     *      'arialunicid0-chinese-simplified'
128
     *      'arialunicid0-chinese-traditional'
129
     *      'arialunicid0-korean'
130
     *      'arialunicid0-japanese'.
131
     *
132
     * @return $this
133
     */
134
    public function setFont(string $fontName)
135
    {
136
        $this->font = $fontName;
137
 
138
        return $this;
139
    }
140
 
141
    /**
142
     * Get Paper Size.
143
     */
144
    public function getPaperSize(): ?int
145
    {
146
        return $this->paperSize;
147
    }
148
 
149
    /**
150
     * Set Paper Size.
151
     *
152
     * @param int $paperSize Paper size see PageSetup::PAPERSIZE_*
153
     */
154
    public function setPaperSize(int $paperSize): self
155
    {
156
        $this->paperSize = $paperSize;
157
 
158
        return $this;
159
    }
160
 
161
    /**
162
     * Get Orientation.
163
     */
164
    public function getOrientation(): ?string
165
    {
166
        return $this->orientation;
167
    }
168
 
169
    /**
170
     * Set Orientation.
171
     *
172
     * @param string $orientation Page orientation see PageSetup::ORIENTATION_*
173
     */
174
    public function setOrientation(string $orientation): self
175
    {
176
        $this->orientation = $orientation;
177
 
178
        return $this;
179
    }
180
 
181
    /**
182
     * Get temporary storage directory.
183
     */
184
    public function getTempDir(): string
185
    {
186
        return $this->tempDir;
187
    }
188
 
189
    /**
190
     * Set temporary storage directory.
191
     *
192
     * @param string $temporaryDirectory Temporary storage directory
193
     */
194
    public function setTempDir(string $temporaryDirectory): self
195
    {
196
        if (is_dir($temporaryDirectory)) {
197
            $this->tempDir = $temporaryDirectory;
198
        } else {
199
            throw new WriterException("Directory does not exist: $temporaryDirectory");
200
        }
201
 
202
        return $this;
203
    }
204
 
205
    /**
206
     * Save Spreadsheet to PDF file, pre-save.
207
     *
208
     * @param resource|string $filename Name of the file to save as
209
     *
210
     * @return resource
211
     */
212
    protected function prepareForSave($filename)
213
    {
214
        //  Open file
215
        $this->openFileHandle($filename);
216
 
217
        return $this->fileHandle;
218
    }
219
 
220
    /**
221
     * Save PhpSpreadsheet to PDF file, post-save.
222
     */
223
    protected function restoreStateAfterSave(): void
224
    {
225
        $this->maybeCloseFileHandle();
226
    }
227
}