ExportExcel2007::write_record()

Complexity

Conditions	22
Paths	4329

Size

Total Lines	97
Code Lines	68

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function write_record($array_selected_sorted, $objp, $outputlangs, $array_types)
    {
        // phpcs:enable

        // Define first row
        $this->col = 1;

        $reg = array();
        $selectlabelvalues = array();
        foreach ($array_selected_sorted as $code => $value) {
            if (strpos($code, ' as ') == 0) {
                $alias = str_replace(array('.', '-', '(', ')'), '_', $code);
            } else {
                $alias = substr($code, strpos($code, ' as ') + 4);
            }
            if (empty($alias)) {
                dol_print_error(null, 'Bad value for field with code=' . $code . '. Try to redefine export.');
            }

            $newvalue = !empty($objp->$alias) ? $objp->$alias : '';

            $newvalue = $this->excel_clean($newvalue);
            $typefield = isset($array_types[$code]) ? $array_types[$code] : '';

            if (preg_match('/^Select:/i', $typefield) && $typefield = substr($typefield, 7)) {
                $array = jsonOrUnserialize($typefield);
                if (is_array($array) && !empty($newvalue)) {
                    $array = $array['options'];
                    $selectlabelvalues[$code . "_label"] = $array[$newvalue];
                } else {
                    $selectlabelvalues[$code . "_label"] = "";
                }
            }

            // Traduction newvalue
            if (preg_match('/^\((.*)\)$/i', $newvalue, $reg)) {
                $newvalue = $outputlangs->transnoentities($reg[1]);
            } else {
                $newvalue = $outputlangs->convToOutputCharset($newvalue);
            }

            if (preg_match('/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$/i', $newvalue)) {
                $newvalue = dol_stringtotime($newvalue);
                $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($newvalue));
                $coord = $this->workbook->getActiveSheet()->getCellByColumnAndRow($this->col, $this->row + 1)->getCoordinate();

The method getCellByColumnAndRow() does not exist on PhpOffice\PhpSpreadsheet\Worksheet\Worksheet. Did you maybe mean getCell()?

                $this->workbook->getActiveSheet()->getStyle($coord)->getNumberFormat()->setFormatCode('yyyy-mm-dd');
            } elseif (preg_match('/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]$/i', $newvalue)) {
                $newvalue = dol_stringtotime($newvalue);
                $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($newvalue));
                $coord = $this->workbook->getActiveSheet()->getCellByColumnAndRow($this->col, $this->row + 1)->getCoordinate();
                $this->workbook->getActiveSheet()->getStyle($coord)->getNumberFormat()->setFormatCode('yyyy-mm-dd h:mm:ss');
            } else {
                if ($typefield == 'Text' || $typefield == 'TextAuto') {
                    // If $newvalue start with an equal sign we don't want it to be interpreted as a formula, so we add a '. Such transformation should be
                    // done by SetCellValueByColumnAndRow but it is not, so we do it ourself.
                    $newvalue = (dol_substr($newvalue, 0, 1) === '=' ? '\'' : '') . $newvalue;
                    $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, $newvalue);
                    $coord = $this->workbook->getActiveSheet()->getCellByColumnAndRow($this->col, $this->row + 1)->getCoordinate();
                    $this->workbook->getActiveSheet()->getStyle($coord)->getNumberFormat()->setFormatCode('@');
                    $this->workbook->getActiveSheet()->getStyle($coord)->getAlignment()->setHorizontal(PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT);
                } else {
                    $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, $newvalue);
                }
            }
            $this->col++;
        }

        // Complete with some columns to add columns with the labels of columns of type Select, so we have more then the ID
        foreach ($selectlabelvalues as $key => $newvalue) {
            $code = preg_replace('/_label$/', '', $key);
            $typefield = isset($array_types[$code]) ? $array_types[$code] : '';

            if (preg_match('/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$/i', $newvalue)) {
                $newvalue = dol_stringtotime($newvalue);
                $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($newvalue));
                $coord = $this->workbook->getActiveSheet()->getCellByColumnAndRow($this->col, $this->row + 1)->getCoordinate();
                $this->workbook->getActiveSheet()->getStyle($coord)->getNumberFormat()->setFormatCode('yyyy-mm-dd');
            } elseif (preg_match('/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]$/i', $newvalue)) {
                $newvalue = dol_stringtotime($newvalue);
                $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($newvalue));
                $coord = $this->workbook->getActiveSheet()->getCellByColumnAndRow($this->col, $this->row + 1)->getCoordinate();
                $this->workbook->getActiveSheet()->getStyle($coord)->getNumberFormat()->setFormatCode('yyyy-mm-dd h:mm:ss');
            } else {
                if ($typefield == 'Text' || $typefield == 'TextAuto') {
                    $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, (string)$newvalue);
                    $coord = $this->workbook->getActiveSheet()->getCellByColumnAndRow($this->col, $this->row + 1)->getCoordinate();
                    $this->workbook->getActiveSheet()->getStyle($coord)->getNumberFormat()->setFormatCode('@');
                    $this->workbook->getActiveSheet()->getStyle($coord)->getAlignment()->setHorizontal(PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT);
                } else {
                    $this->workbook->getActiveSheet()->SetCellValueByColumnAndRow($this->col, $this->row + 1, $newvalue);
                }
            }
            $this->col++;
        }

        $this->row++;
        return 0;
    }