protected static function getBasicSheetCallback($columnFormatArray, $borderRange, $query, $headArray) { return function ($sheet) use($columnFormatArray, $borderRange, $query, $headArray) { $sheet->setAutoSize(true)->setFontFamily(ExportExcel::FONT_DEFAULT)->setFontSize(12)->setColumnFormat($columnFormatArray)->freezeFirstRow(); $sheet->cells('A1:' . $borderRange . '1', function ($cells) { $cells->setBackground('#000000')->setFontColor('#ffffff')->setAlignment('center'); }); if ($res = Processor::execErp($query)) { $i = 0; $sheet->row(++$i, $headArray); while ($row = odbc_fetch_array($res)) { c8res($row); $sheet->row(++$i, $row); } } }; }
/** * Execute query and return array result * * @param string|object $query * @param string $dbFlag * @return array */ public static function getArrayResult($query, $dbFlag = self::DB_ERP) { $data = []; if ($query instanceof Builder) { $query = self::toSql($query); } $execDB = "exec{$dbFlag}"; if ($res = self::$execDB($query)) { while ($row = odbc_fetch_array($res)) { c8res($row); $data[] = $row; } } $execDB = NULL; $res = NULL; $row = NULL; return $data; }