Exemplo n.º 1
0
 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);
             }
         }
     };
 }
Exemplo n.º 2
0
 /**
  * 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;
 }