Export::exportExcel() - Code Metrics - cjtterabytesoft/toolbar - Measure and Improve Code Quality continuously with Scrutinizer

Export::exportExcel() A
last analyzed 2018-08-11 19:17 UTC

↳ Parent: Export

Complexity

Conditions	5
Paths	6

Size

Total Lines	30
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	5
eloc	25
nc	6
nop	0
dl	0
loc	30
rs	9.2088
c	0
b	0
f	0

<?php

/**
 * (c) CJT TERABYTE INC
 * For the full copyright and license information, please view the LICENSE.md
 * file that was distributed with this source code.
 *
 *        @link: https://github.com/cjtterabytesoft/alert
 *      @author: Wilmer Arámbula <[email protected]>
 *   @copyright: (c) CJT TERABYTE INC
 *     @widgets: [Export]
 *       @since: 1.0
 *         @yii: 3.0
 **/

namespace cjtterabytesoft\toolbar;

use Dompdf\Dompdf;
use Dompdf\Options;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpWord\IOFactory;
use PhpOffice\PhpWord\PhpWord;
use yii\base\InvalidConfigException;
use yii\base\Widget;

/**
 * Export File diferents format Csv, Excel, Html, Pdf, Word.
 */
class Export extends Widget
{
	/**
	 * @var string Charset export csv.
	 */
	public $_csvCharset = 'UTF-8';

	/**
	 * @var \yii\data\DataProviderInterface the data provider for the view. This property is required.
	 */
	public $_dataProvider;

	/**
	 * @var \app\model\searchModel.
	 */
	public $_searchModel;

	/**
	 * @var string tableName.
	 */
	public $_tableName= '';

	/**
	 * @var string Title Export.
	 */
	public $_title = '';

	/**
	 * Initializes the view.
	 */
	public function init()
	{
		parent::init();

		if (empty($this->_dataProvider)) {
			throw new InvalidConfigException('The "dataProvider" property must be set.');
		}

		if (empty($this->_searchModel)) {
			throw new InvalidConfigException('The "dataProvider" property must be set.');
		}

		$this->_tableName = $this->_searchModel->tableName();

		if (empty($this->_title)) {
			$this->_title = $this->_tableName;
		}
	}

	/**
	 * @return file Csv Export.
	 */
	public function exportCsv()
	{
		$csvCharset = $this->_csvCharset;
		$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
		header('Pragma: public');
		header('Expires: 0');
		header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
		header('Content-Description: File Transfer');
		header('Content-Type: text/csv');
		$filename = $this->_tableName . '.csv';
		header('Content-Disposition: attachment;filename=' . $filename);
		header('Content-Transfer-Encoding: binary');
		$fp = fopen('php://output', 'w');
		fwrite($fp, $bom = (chr(0xEF) . chr(0xBB) . chr(0xBF)));
		if ($fp) {

			$items = [];
			$i = 0;
			foreach ($fields as $one) {
				$items[$i] = $one;
				$i++;
			}
			fwrite($fp, implode($items, ',') . "\n");
			$items = [];
			$i = 0;
			foreach ($this->_dataProvider->getModels() as $model) {
				foreach ($this->_searchModel->exportFields() as $one) {
					$item = str_replace('"', '\"', is_string($one) ? $model[$one] : $one($model));
					$items[$i] = ($item) ? '"' . $item . '"' : $item;
					$i++;
				}
				fwrite($fp, implode($items, ',') . "\n");
				$items = [];
				$i = 0;
			}
		}
		fclose($fp);
	}

	/**
	 * @return file Excel Export.
	 */
	public function exportExcel()
	{
		$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
		$objPHPExcel = new Spreadsheet();
		$objPHPExcel->setActiveSheetIndex(0);
		$objPHPExcel->getActiveSheet()->setTitle($this->_title);
		$letter = 65;
		foreach ($fields as $one) {
			$objPHPExcel->getActiveSheet()->getColumnDimension(chr($letter))->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue(chr($letter) . '1', $this->_searchModel->getAttributeLabel($one));
			$objPHPExcel->getActiveSheet()->getStyle(chr($letter) . '1')->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
			$letter++;
		}
		$row = 2;
		$letter = 65;
		foreach ($this->_dataProvider->getModels() as $model) {
			foreach ($this->_searchModel->exportFields() as $one) {
				$objPHPExcel->getActiveSheet()->setCellValue(chr($letter) . $row, (is_string($one)) ? $model[$one] : $one($model));
				$objPHPExcel->getActiveSheet()->getStyle(chr($letter) . $row)->getAlignment()->setHorizontal(Alignment::HORIZONTAL_LEFT);
				$letter++;
			}
			$letter = 65;
			$row++;
		}
		header('Content-Type: application/vnd.ms-excel');
		$filename = $this->_tableName . '.xlsx';
		header('Content-Disposition: attachment;filename=' . $filename);
		header('Cache-Control: max-age=0');
		$objWriter = new Xlsx($objPHPExcel);
		$objWriter->save('php://output');
	}

	/**
	 * @return file Htlm Export.
	 */
	public function exportHtml()
	{
		$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
		$phpWord = new PhpWord();
		$section = $phpWord->addSection();
		$section->addTitle($this->_title);
		$table = $section->addTable(['name' => 'Tahoma', 'size' => 10, 'align' => 'center',]);
		$table->addRow(300, ['exactHeight' => true]);
		foreach ($fields as $one) {
			$table->addCell(
				1500,
				['bgColor' => 'eeeeee', 'borderTopSize' => 5, 'borderRightSize' => 5, 'borderBottomSize' => 5,'borderLeftSize' => 5, 'valign' => 'center']
			)->addText($this->_searchModel->getAttributeLabel($one), ['bold' => true, 'size' => 10], ['align' => 'center']);
		}
		foreach ($this->_dataProvider->getModels() as $model) {
			$table->addRow(300, ['exactHeight' => true]);
			foreach ($this->_searchModel->exportFields() as $one) {
				$table->addCell(
					1500,
					['borderTopSize' => 1, 'borderRightSize' => 1, 'borderBottomSize' => 1, 'borderLeftSize' => 1, 'valign' => 'center']
				)->addText('<p style="margin-left: 10px;">' . (is_string($one)) ? $model[$one] : $one($model) . '</p>', ['bold' => false, 'size' => 10], ['align' => 'right']);
			}
		}
		header('Content-Type: application/html');
		$filename = $this->_tableName . '.html';
		header('Content-Disposition: attachment;filename=' . $filename . ' ');
		header('Cache-Control: max-age=0');
		$objWriter = IOFactory::createWriter($phpWord, 'HTML');
		$objWriter->save('php://output');
	}

	/**
	 * @return file Pdf Export.
	 */
	public function exportPdf()
	{
		$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
		$options = new Options();
		$options->set('defaultFont', 'times');
		$dompdf = new Dompdf($options);
		$html = '<html><body>';
		$html .= '<h1>' . '<center>' . $this->_title . '</center>' . '</h1>';
		$html .= '<table width="100%" cellspacing="0" cellpadding="0">';
		$html .= '<tr style="background-color: #ececec;">';
		foreach ($fields as $one) {
			$html .= '<td style="border: 2px solid #cccccc; text-align: center; font-weight: 500;">' . $this->_searchModel->getAttributeLabel($one) . '</td>';
		}
		$html .= '</tr>';
		foreach ($this->_dataProvider->getModels() as $model) {
			$html .= '<tr>';
			foreach ($this->_searchModel->exportFields() as $one) {
				switch (true) {
					case is_string($one):
						$html .= '<td style="border: 1px solid #cccccc; text-align: left; font-weight: 300; padding-left: 10px;">' . $model[$one] . '</td>';
						break;
					default:
						$html .= '<td style="border: 1px solid #cccccc; text-align: left; font-weight: 300; padding-left: 10px;">' . $one($model) . '</td>';
						break;
				}
			}
			$html .= '</tr>';
		}
		$html .= '</table>';
		$html .= '</body></html>';
		$dompdf->loadHtml($html);
		$dompdf->setPaper('letter', 'landscape');
		$dompdf->render();
		$dompdf->stream($this->_tableName . '_' . time());
	}

	/**
	 * @return file Word Export.
	 */
	public function exportWord()
	{
		$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
		$phpWord = new PhpWord();
		$phpWord->getCompatibility()->setOoxmlVersion(15);
		$section = $phpWord->addSection();
		$sectionStyle = $section->getSettings();
		$sectionStyle->setLandscape();
		$sectionStyle->setBorderTopColor('C0C0C0');
		$sectionStyle->setMarginTop(300);
		$sectionStyle->setMarginRight(300);
		$sectionStyle->setMarginBottom(300);
		$sectionStyle->setMarginLeft(300);
		$phpWord->addTitleStyle(1, ['name' => 'HelveticaNeueLT Std Med', 'size' => 16], ['align' => 'center']);
		$section->addTitle($this->_title);
		$table = $section->addTable(
			['name' => 'Tahoma', 'align' => 'center', 'cellMarginTop' => 30, 'cellMarginRight' => 30, 'cellMarginBottom' => 30,	'cellMarginLeft' => 30]
		);
		$table->addRow(300, ['exactHeight' => true]);
		foreach ($fields as $one) {
			$table->addCell(
				1500,
				['bgColor' => 'eeeeee', 'borderTopSize' => 5, 'borderRightSize' => 5, 'borderBottomSize' => 5,'borderLeftSize' => 5, 'valign' => 'center']
			)->addText($this->_searchModel->getAttributeLabel($one), ['bold' => true, 'size' => 10], ['align' => 'center']);
		}
		foreach ($this->_dataProvider->getModels() as $model) {
			$table->addRow(300, ['exactHeight' => true]);
			foreach ($this->_searchModel->exportFields() as $one) {
				$table->addCell(
					1500,
					['borderTopSize' => 1, 'borderRightSize' => 1, 'borderBottomSize' => 1, 'borderLeftSize' => 1, 'valign' => 'center']
				)->addText(is_string($one) ? $model[$one] : $one($model), ['bold' => false, 'size' => 10], ['align' => 'left']);
			}
		}
		header('Content-Type: application/vnd.ms-word');
		$filename = $this->_tableName . '.docx';
		header('Content-Disposition: attachment;filename=' . $filename . ' ');
		header('Cache-Control: max-age=0');
		$objWriter = IOFactory::createWriter($phpWord, 'Word2007');
		$objWriter->save('php://output');
	}

	/**
	 * @return array Fields List.
	 */
	private function getFieldsKeys($fieldsSended)
	{
		$fields = [];
		$i = 0;

		foreach ($fieldsSended as $key => $value) {
			switch (true) {
				case is_int($key):
					$fields[$i] = $value;
					break;
				default:
					$fields[$i] = $key;
					break;
			}
			$i++;
		}

		return $fields;
	}
}


1			<?php
2
3			/**
4			* (c) CJT TERABYTE INC
5			* For the full copyright and license information, please view the LICENSE.md
6			* file that was distributed with this source code.
7			*
8			* @link: https://github.com/cjtterabytesoft/alert
9			* @author: Wilmer Arámbula <[email protected]>
10			* @copyright: (c) CJT TERABYTE INC
11			* @widgets: [Export]
12			* @since: 1.0
13			* @yii: 3.0
14			**/
15
16			namespace cjtterabytesoft\toolbar;
17
18			use Dompdf\Dompdf;
19			use Dompdf\Options;
20			use PhpOffice\PhpSpreadsheet\Spreadsheet;
21			use PhpOffice\PhpSpreadsheet\Style\Alignment;
22			use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
23			use PhpOffice\PhpWord\IOFactory;
24			use PhpOffice\PhpWord\PhpWord;
25			use yii\base\InvalidConfigException;
26			use yii\base\Widget;
27
28			/**
29			* Export File diferents format Csv, Excel, Html, Pdf, Word.
30			*/
31			class Export extends Widget
32			{
33			/**
34			* @var string Charset export csv.
35			*/
36			public $_csvCharset = 'UTF-8';
37
38			/**
39			* @var \yii\data\DataProviderInterface the data provider for the view. This property is required.
40			*/
41			public $_dataProvider;
42
43			/**
44			* @var \app\model\searchModel.
45			*/
46			public $_searchModel;
47
48			/**
49			* @var string tableName.
50			*/
51			public $_tableName= '';
52
53			/**
54			* @var string Title Export.
55			*/
56			public $_title = '';
57
58			/**
59			* Initializes the view.
60			*/
61			public function init()
62			{
63			parent::init();
64
65			if (empty($this->_dataProvider)) {
66			throw new InvalidConfigException('The "dataProvider" property must be set.');
67			}
68
69			if (empty($this->_searchModel)) {
70			throw new InvalidConfigException('The "dataProvider" property must be set.');
71			}
72
73			$this->_tableName = $this->_searchModel->tableName();
74
75			if (empty($this->_title)) {
76			$this->_title = $this->_tableName;
77			}
78			}
79
80			/**
81			* @return file Csv Export.
82			*/
83			public function exportCsv()
84			{
85			$csvCharset = $this->_csvCharset;
86			$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
87			header('Pragma: public');
88			header('Expires: 0');
89			header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
90			header('Content-Description: File Transfer');
91			header('Content-Type: text/csv');
92			$filename = $this->_tableName . '.csv';
93			header('Content-Disposition: attachment;filename=' . $filename);
94			header('Content-Transfer-Encoding: binary');
95			$fp = fopen('php://output', 'w');
96			fwrite($fp, $bom = (chr(0xEF) . chr(0xBB) . chr(0xBF)));
97			if ($fp) {
			0 ignored issues – show introduced 2018-07-26 12:54 UTC by Report Bug Copy Issue Report `$fp` is of type `resource\|false`, thus it always evaluated to `false`. Loading history...
98			$items = [];
99			$i = 0;
100			foreach ($fields as $one) {
101			$items[$i] = $one;
102			$i++;
103			}
104			fwrite($fp, implode($items, ',') . "\n");
105			$items = [];
106			$i = 0;
107			foreach ($this->_dataProvider->getModels() as $model) {
108			foreach ($this->_searchModel->exportFields() as $one) {
109			$item = str_replace('"', '\"', is_string($one) ? $model[$one] : $one($model));
110			$items[$i] = ($item) ? '"' . $item . '"' : $item;
111			$i++;
112			}
113			fwrite($fp, implode($items, ',') . "\n");
114			$items = [];
115			$i = 0;
116			}
117			}
118			fclose($fp);
119			}
120
121			/**
122			* @return file Excel Export.
123			*/
124			public function exportExcel()
125			{
126			$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
127			$objPHPExcel = new Spreadsheet();
128			$objPHPExcel->setActiveSheetIndex(0);
129			$objPHPExcel->getActiveSheet()->setTitle($this->_title);
130			$letter = 65;
131			foreach ($fields as $one) {
132			$objPHPExcel->getActiveSheet()->getColumnDimension(chr($letter))->setAutoSize(true);
133			$objPHPExcel->getActiveSheet()->setCellValue(chr($letter) . '1', $this->_searchModel->getAttributeLabel($one));
134			$objPHPExcel->getActiveSheet()->getStyle(chr($letter) . '1')->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
135			$letter++;
136			}
137			$row = 2;
138			$letter = 65;
139			foreach ($this->_dataProvider->getModels() as $model) {
140			foreach ($this->_searchModel->exportFields() as $one) {
141			$objPHPExcel->getActiveSheet()->setCellValue(chr($letter) . $row, (is_string($one)) ? $model[$one] : $one($model));
142			$objPHPExcel->getActiveSheet()->getStyle(chr($letter) . $row)->getAlignment()->setHorizontal(Alignment::HORIZONTAL_LEFT);
143			$letter++;
144			}
145			$letter = 65;
146			$row++;
147			}
148			header('Content-Type: application/vnd.ms-excel');
149			$filename = $this->_tableName . '.xlsx';
150			header('Content-Disposition: attachment;filename=' . $filename);
151			header('Cache-Control: max-age=0');
152			$objWriter = new Xlsx($objPHPExcel);
153			$objWriter->save('php://output');
154			}
155
156			/**
157			* @return file Htlm Export.
158			*/
159			public function exportHtml()
160			{
161			$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
162			$phpWord = new PhpWord();
163			$section = $phpWord->addSection();
164			$section->addTitle($this->_title);
165			$table = $section->addTable(['name' => 'Tahoma', 'size' => 10, 'align' => 'center',]);
166			$table->addRow(300, ['exactHeight' => true]);
167			foreach ($fields as $one) {
168			$table->addCell(
169			1500,
170			['bgColor' => 'eeeeee', 'borderTopSize' => 5, 'borderRightSize' => 5, 'borderBottomSize' => 5,'borderLeftSize' => 5, 'valign' => 'center']
171			)->addText($this->_searchModel->getAttributeLabel($one), ['bold' => true, 'size' => 10], ['align' => 'center']);
172			}
173			foreach ($this->_dataProvider->getModels() as $model) {
174			$table->addRow(300, ['exactHeight' => true]);
175			foreach ($this->_searchModel->exportFields() as $one) {
176			$table->addCell(
177			1500,
178			['borderTopSize' => 1, 'borderRightSize' => 1, 'borderBottomSize' => 1, 'borderLeftSize' => 1, 'valign' => 'center']
179			)->addText('<p style="margin-left: 10px;">' . (is_string($one)) ? $model[$one] : $one($model) . '</p>', ['bold' => false, 'size' => 10], ['align' => 'right']);
180			}
181			}
182			header('Content-Type: application/html');
183			$filename = $this->_tableName . '.html';
184			header('Content-Disposition: attachment;filename=' . $filename . ' ');
185			header('Cache-Control: max-age=0');
186			$objWriter = IOFactory::createWriter($phpWord, 'HTML');
187			$objWriter->save('php://output');
188			}
189
190			/**
191			* @return file Pdf Export.
192			*/
193			public function exportPdf()
194			{
195			$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
196			$options = new Options();
197			$options->set('defaultFont', 'times');
198			$dompdf = new Dompdf($options);
199			$html = '<html><body>';
200			$html .= '<h1>' . '<center>' . $this->_title . '</center>' . '</h1>';
201			$html .= '<table width="100%" cellspacing="0" cellpadding="0">';
202			$html .= '<tr style="background-color: #ececec;">';
203			foreach ($fields as $one) {
204			$html .= '<td style="border: 2px solid #cccccc; text-align: center; font-weight: 500;">' . $this->_searchModel->getAttributeLabel($one) . '</td>';
205			}
206			$html .= '</tr>';
207			foreach ($this->_dataProvider->getModels() as $model) {
208			$html .= '<tr>';
209			foreach ($this->_searchModel->exportFields() as $one) {
210			switch (true) {
211			case is_string($one):
212			$html .= '<td style="border: 1px solid #cccccc; text-align: left; font-weight: 300; padding-left: 10px;">' . $model[$one] . '</td>';
213			break;
214			default:
215			$html .= '<td style="border: 1px solid #cccccc; text-align: left; font-weight: 300; padding-left: 10px;">' . $one($model) . '</td>';
216			break;
217			}
218			}
219			$html .= '</tr>';
220			}
221			$html .= '</table>';
222			$html .= '</body></html>';
223			$dompdf->loadHtml($html);
224			$dompdf->setPaper('letter', 'landscape');
225			$dompdf->render();
226			$dompdf->stream($this->_tableName . '_' . time());
227			}
228
229			/**
230			* @return file Word Export.
231			*/
232			public function exportWord()
233			{
234			$fields = $this->getFieldsKeys($this->_searchModel->exportFields());
235			$phpWord = new PhpWord();
236			$phpWord->getCompatibility()->setOoxmlVersion(15);
237			$section = $phpWord->addSection();
238			$sectionStyle = $section->getSettings();
239			$sectionStyle->setLandscape();
240			$sectionStyle->setBorderTopColor('C0C0C0');
241			$sectionStyle->setMarginTop(300);
242			$sectionStyle->setMarginRight(300);
243			$sectionStyle->setMarginBottom(300);
244			$sectionStyle->setMarginLeft(300);
245			$phpWord->addTitleStyle(1, ['name' => 'HelveticaNeueLT Std Med', 'size' => 16], ['align' => 'center']);
246			$section->addTitle($this->_title);
247			$table = $section->addTable(
248			['name' => 'Tahoma', 'align' => 'center', 'cellMarginTop' => 30, 'cellMarginRight' => 30, 'cellMarginBottom' => 30, 'cellMarginLeft' => 30]
249			);
250			$table->addRow(300, ['exactHeight' => true]);
251			foreach ($fields as $one) {
252			$table->addCell(
253			1500,
254			['bgColor' => 'eeeeee', 'borderTopSize' => 5, 'borderRightSize' => 5, 'borderBottomSize' => 5,'borderLeftSize' => 5, 'valign' => 'center']
255			)->addText($this->_searchModel->getAttributeLabel($one), ['bold' => true, 'size' => 10], ['align' => 'center']);
256			}
257			foreach ($this->_dataProvider->getModels() as $model) {
258			$table->addRow(300, ['exactHeight' => true]);
259			foreach ($this->_searchModel->exportFields() as $one) {
260			$table->addCell(
261			1500,
262			['borderTopSize' => 1, 'borderRightSize' => 1, 'borderBottomSize' => 1, 'borderLeftSize' => 1, 'valign' => 'center']
263			)->addText(is_string($one) ? $model[$one] : $one($model), ['bold' => false, 'size' => 10], ['align' => 'left']);
264			}
265			}
266			header('Content-Type: application/vnd.ms-word');
267			$filename = $this->_tableName . '.docx';
268			header('Content-Disposition: attachment;filename=' . $filename . ' ');
269			header('Cache-Control: max-age=0');
270			$objWriter = IOFactory::createWriter($phpWord, 'Word2007');
271			$objWriter->save('php://output');
272			}
273
274			/**
275			* @return array Fields List.
276			*/
277			private function getFieldsKeys($fieldsSended)
278			{
279			$fields = [];
280			$i = 0;
281
282			foreach ($fieldsSended as $key => $value) {
283			switch (true) {
284			case is_int($key):
285			$fields[$i] = $value;
286			break;
287			default:
288			$fields[$i] = $key;
289			break;
290			}
291			$i++;
292			}
293
294			return $fields;
295			}
296			}
297

cjtterabytesoft / toolbar

Export::exportExcel() A last analyzed 2018-08-11 19:17 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Export::exportExcel() A
last analyzed 2018-08-11 19:17 UTC