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

Completed

Push — 4.1 ( c2b28b...e69caa )

by Andrea

created 2018-11-15 21:31 UTC

TabellaXls::setCellFormat() B

↳ Parent: TabellaXls

Complexity

Conditions	9
Paths	9

Size

Total Lines	50
Code Lines	47

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	23
CRAP Score	19.7826

Importance

Changes

Metric	Value
eloc	47
dl	0
loc	50
ccs	23
cts	47
cp	0.4894
rs	7.6008
c	0
b	0
f	0
cc	9
nc	9
nop	4
crap	19.7826

<?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;
            }
        }

        if ($indicecolonnaheader > 0) {
            //Si imposta il colore dello sfondo delle celle
            //Colore header
            $style_header = array(
                'fill' => array(
                    'type' => Fill::FILL_SOLID,
                    'color' => array('rgb' => 'E5E4E2')
                ),
                'font' => array(
                    'bold' => true
                )
            );
            $sheet->getStyle('A1:' . $letteracolonna . '1')->applyFromArray($style_header);
        }

        $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($riga);
$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;
                    $this->setCellFormat($sheet, $col, $row, $valorecolonnatestata["tipocampo"]);
<?php

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

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

                }
            }
            $sheet->getRowDimension($row)->setRowHeight(18);
            ++$row;
        }
    }
    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 setCellFormat($sheet, $indicecolonna, $row, $tipocampo)
    {
        $letteracolonna = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::stringFromColumnIndex($indicecolonna);
        switch ($tipocampo) {
            case 'text':
                $sheet->getStyle($letteracolonna . '2:' . $letteracolonna . $row)
                        ->getNumberFormat()
                        ->setFormatCode("@");
<?php

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

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

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

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

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

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

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

print $doubleQuoted;
                break;
        }
    }
}


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
14	1	public function esportaexcel($parametri = array())
15		{
16	1	set_time_limit(960);
17	1	ini_set('memory_limit', '2048M');
18
19		//Creare un nuovo file
20	1	$spreadsheet = new Spreadsheet();
21	1	$objPHPExcel = new Xls($spreadsheet);
22	1	$spreadsheet->setActiveSheetIndex(0);
23
24		// Set properties
25	1	$spreadsheet->getProperties()->setCreator('Comune di Firenze');
26	1	$spreadsheet->getProperties()->setLastModifiedBy('Comune di Firenze');
27
28
29	1	$header = $parametri['parametritabella'];
30	1	$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		//Scrittura su file
32	1	$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	1	$titolosheet = 'Esportazione ' . $parametri['nomecontroller'];
34	1	$sheet->setTitle(substr($titolosheet, 0, 30));
35	1	$sheet->getParent()->getDefaultStyle()->getFont()->setName('Verdana');
36
37	1	$this->printHeaderXls($header, $sheet);
38

ComuneFI / FifreeCoreBundle

Push — 4.1 ( c2b28b...e69caa )

TabellaXls::setCellFormat() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like