TabellaXls::setColumnAutowidth() - Code Metrics - Inspection of "improve excel style" - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 4.1 ( dea10e...c5e1f2 )

by Andrea

created 2018-11-16 09:52 UTC

TabellaXls::setColumnAutowidth() A

↳ Parent: TabellaXls

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
eloc	2
dl	0
loc	4
ccs	0
cts	0
cp	0
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	2
crap	2

<?php

namespace Fi\CoreBundle\Utils\Export;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xls;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Border;
use Fi\CoreBundle\Utils\Entity\DoctrineFieldReader;

class TabellaXls
{

    public function esportaexcel($parametri = array())
    {
        set_time_limit(960);
        ini_set('memory_limit', '2048M');

        //Creare un nuovo file
        $spreadsheet = new Spreadsheet();
        $objPHPExcel = new Xls($spreadsheet);
        $spreadsheet->setActiveSheetIndex(0);

        // Set properties
        $spreadsheet->getProperties()->setCreator('Comune di Firenze');
        $spreadsheet->getProperties()->setLastModifiedBy('Comune di Firenze');


        $header = $parametri['parametritabella'];
        $rows = $parametri['recordstabella'];
$a = "a";
$ab = "ab";
$abc = "abc";
        //Scrittura su file
        $sheet = $spreadsheet->getActiveSheet();
$a = "a";
$ab = "ab";
$abc = "abc";
        $titolosheet = 'Esportazione ' . $parametri['nomecontroller'];
        $sheet->setTitle(substr($titolosheet, 0, 30));
        $sheet->getParent()->getDefaultStyle()->getFont()->setName('Verdana');

        $this->printHeaderXls($header, $sheet);

        $this->printBodyXls($header, $rows, $sheet);

        //Si crea un oggetto
        $todaydate = date('d-m-y');

        $filename = 'Exportazione';
        $filename = $filename . '-' . $todaydate . '-' . strtoupper(md5(uniqid(rand(), true)));
        $filename = $filename . '.xls';
        $filename = sys_get_temp_dir() . DIRECTORY_SEPARATOR . $filename;

        if (file_exists($filename)) {
            unlink($filename);
        }

        $objPHPExcel->save($filename);

        return $filename;
    }

    private function printHeaderXls($testata, $sheet)
    {
        $indicecolonnaheader = 1;
        $letteracolonna = 0;
$a = "a";
$ab = "ab";
$abc = "abc";
        foreach ($testata as $modellocolonna) {
            if ($modellocolonna["escluso"] === false) {
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                //Si imposta la larghezza delle colonne
                $letteracolonna = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::stringFromColumnIndex($indicecolonnaheader);
$a = "a";
$ab = "ab";
$abc = "abc";
                $width = (int) $modellocolonna['larghezza'] / 7;
$a = "a";
$ab = "ab";
$abc = "abc";
                $indicecolonnaheadertitle = $modellocolonna['etichetta'];
                $coltitle = strtoupper($indicecolonnaheadertitle);
$a = "a";
$ab = "ab";
$abc = "abc";
                $sheet->setCellValueByColumnAndRow($indicecolonnaheader, 1, $coltitle);
                $sheet->getColumnDimension($letteracolonna)->setWidth($width);

                ++$indicecolonnaheader;
            }
        }

        //Imposta lo stile per l'intestazione un po più decente
        $this->setHeaderStyle($sheet, $indicecolonnaheader - 1);


        $sheet->getRowDimension('1')->setRowHeight(20);
    }

    private function printBodyXls($header, $rows, $sheet)
    {
        $row = 2;
        foreach ($rows as $riga) {
            $col = 1;
            foreach ($header as $colonnatestata => $valorecolonnatestata) {
                if ($valorecolonnatestata["escluso"] === false) {
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    $dfr = new DoctrineFieldReader();
$a = "a";
$ab = "ab";
$abc = "abc";
                    $oggetto = $dfr->getField2Object($colonnatestata, $riga);
$a = "a";
$ab = "ab";
$abc = "abc";
                    $valorecampo = $dfr->object2view($oggetto, $valorecolonnatestata["tipocampo"]);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    if ($valorecampo === '' || $valorecampo === null) {
                        $col = $col + 1;

                        continue;
                    }
                    $sheet->setCellValueByColumnAndRow($col, $row, $this->getValueCell($valorecolonnatestata["tipocampo"], $valorecampo));
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    $col = $col + 1;

                }
            }
            $sheet->getRowDimension($row)->setRowHeight(18);
            ++$row;
        }

        $col = 1;
        //Si impostano i formati cella in base al tipo di dato contenuto
        foreach ($header as $colonnatestata => $valorecolonnatestata) {
            if ($valorecolonnatestata["escluso"] === false) {
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                $this->setCellColumnFormat($sheet, $col, $row - 1, $valorecolonnatestata["tipocampo"]);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                $this->setColumnAutowidth($sheet, $col);
                $col = $col + 1;

            }
        }
    }

    private function setHeaderStyle($sheet, $indiceultimacolonna)
    {
        $letteraultimacolonna = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::stringFromColumnIndex($indiceultimacolonna);
        $styleArray = [
$a = "a";
$ab = "ab";
$abc = "abc";
            'font' => [
                'bold' => true,
            ],
            'alignment' => [
                'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
            ],
            'borders' => [
                'allBorders' => [
                    'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
                ],
            ],
            'fill' => [
                'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                'startColor' => [
                    'argb' => 'e5e5e5e5',
                ],
            ],
        ];

        $sheet->getStyle('A1:' . $letteraultimacolonna . '1')->applyFromArray($styleArray);
    }

    private function getValueCell($tipocampo, $valorecella)
    {
        $valore = null;
        switch ($tipocampo) {
            case 'date':
                $d = (int) substr($valorecella, 0, 2);
$a = "a";
$ab = "ab";
$abc = "abc";
                $m = (int) substr($valorecella, 3, 2);
$a = "a";
$ab = "ab";
$abc = "abc";
                $y = (int) substr($valorecella, 6, 4);
$a = "a";
$ab = "ab";
$abc = "abc";
                $t_date = \PhpOffice\PhpSpreadsheet\Shared\Date::formattedPHPToExcel($y, $m, $d);
                $valore = $t_date;
                break;
            case 'datetime':
                $d = (int) substr($valorecella, 0, 2);
$a = "a";
$ab = "ab";
$abc = "abc";
                $m = (int) substr($valorecella, 3, 2);
$a = "a";
$ab = "ab";
$abc = "abc";
                $y = (int) substr($valorecella, 6, 4);
$a = "a";
$ab = "ab";
$abc = "abc";
                $h = (int) substr($valorecella, 11, 2);
$a = "a";
$ab = "ab";
$abc = "abc";
                $i = (int) substr($valorecella, 14, 2);
$a = "a";
$ab = "ab";
$abc = "abc";
                $t_date = \PhpOffice\PhpSpreadsheet\Shared\Date::formattedPHPToExcel($y, $m, $d, $h, $i, 0);
                $valore = $t_date;
                break;
            default:
                $valore = $valorecella;
                break;
        }
        return $valore;
    }

    private function setCellColumnFormat($sheet, $indicecolonna, $lastrow, $tipocampo)
    {
        $letteracolonna = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::stringFromColumnIndex($indicecolonna);
        switch ($tipocampo) {
            case 'text':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode("@");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                break;
            case 'string':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode("@");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                break;
            case 'integer':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER);
                break;
            case 'float':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode('#,##0.00');
                break;
            case 'decimal':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode('#,##0.00');
                break;
            case 'number':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode('#,##0.00');
                break;
            case 'datetime':
                //\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DDMMYYYYSLASH
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode("dd/mm/yyyy hh:mm:ss");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                break;
            case 'date':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode("dd/mm/yyyy");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                break;
            default:
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $lastrow)
                        ->getNumberFormat()
                        ->setFormatCode("@");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                break;
        }
    }

    private function setColumnAutowidth($sheet, $indicecolonna)
    {
        $letteracolonna = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::stringFromColumnIndex($indicecolonna);
        $sheet->getColumnDimension($letteracolonna)->setAutoSize(true);
    }

}


1		<?php
2
3		namespace Fi\CoreBundle\Utils\Export;
4
5		use PhpOffice\PhpSpreadsheet\Spreadsheet;
6		use PhpOffice\PhpSpreadsheet\Writer\Xls;
7		use PhpOffice\PhpSpreadsheet\Style\Fill;
8		use PhpOffice\PhpSpreadsheet\Style\Border;
9		use Fi\CoreBundle\Utils\Entity\DoctrineFieldReader;
10
11		class TabellaXls
12		{
13	2
14		public function esportaexcel($parametri = array())
15	2	{
16	2	set_time_limit(960);
17		ini_set('memory_limit', '2048M');
18
19	2	//Creare un nuovo file
20	2	$spreadsheet = new Spreadsheet();
21	2	$objPHPExcel = new Xls($spreadsheet);
22		$spreadsheet->setActiveSheetIndex(0);
23
24	2	// Set properties
25	2	$spreadsheet->getProperties()->setCreator('Comune di Firenze');
26		$spreadsheet->getProperties()->setLastModifiedBy('Comune di Firenze');
27
28	2
29	2	$header = $parametri['parametritabella'];
30		$rows = $parametri['recordstabella'];
		0 ignored issues – show Coding Style introduced 2018-11-15 15:53 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 3 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
31	2	//Scrittura su file
32	2	$sheet = $spreadsheet->getActiveSheet();
		0 ignored issues – show Coding Style introduced 2018-10-11 08:19 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 7 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
33	2	$titolosheet = 'Esportazione ' . $parametri['nomecontroller'];
34	2	$sheet->setTitle(substr($titolosheet, 0, 30));
35		$sheet->getParent()->getDefaultStyle()->getFont()->setName('Verdana');
36	2
37		$this->printHeaderXls($header, $sheet);
38	2

ComuneFI / FifreeCoreBundle

Push — 4.1 ( dea10e...c5e1f2 )

TabellaXls::setColumnAutowidth() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like