File: vendor/jackbooted/util/XLS.php

Recommend this page to a friend!
  Classes of Brett Dutton  >  JackBooted PHP Framework  >  vendor/jackbooted/util/XLS.php  >  Download  
File: vendor/jackbooted/util/XLS.php
Role: Class source
Content type: text/plain
Description: Class source
Class: JackBooted PHP Framework
Web application framework using simplified MVC
Author: By
Last change:
Date: 4 years ago
Size: 2,352 bytes
 

 

Contents

Class file image Download
<?php
namespace Jackbooted\Util;

use \
Jackbooted\DB\DB;
use \
Jackbooted\DB\DBTable;
/**
 * @copyright Confidential and copyright (c) 2016 Jackbooted Software. All rights reserved.
 *
 * Written by Brett Dutton of Jackbooted Software
 * brett at brettdutton dot com
 *
 * This software is written and distributed under the GNU General Public
 * License which means that its source code is freely-distributed and
 * available to the general public.
 *
 */
class XLS extends \Jackbooted\Util\JB {
    public static function
output ( $table, $name='' ) {
       
error_reporting ( 0 );
        if ( !
is_object ( $table ) && ! is_array ( $table ) ) exit;
        if (
$name == '' ) $name = 'output' . Invocation::next();
        if ( !
preg_match ( '/^.*\.xls$/i', $name ) ) $name .= '.xls';

       
$fileName = PHPExt::getTempDir() . '/' . $name;

       
$workbook = new Spreadsheet_Excel_Writer ( $fileName );
       
$worksheet = &$workbook->addWorksheet ( basename ( $name ) );
       
$rowIdx = 0;

        if (
$table instanceof DBTable || is_array( $table ) ) {
            foreach (
$table as $row ) {

                if (
$rowIdx == 0 ) {
                    foreach (
array_keys ( $row ) as $col => $heading ) {
                       
$worksheet->write ( $rowIdx, $col, $heading );
                    }
                   
$rowIdx ++;
                }

                foreach (
array_values ( $row ) as $col => $val ) {
                   
$worksheet->write ( $rowIdx, $col, $val );
                }
               
$rowIdx ++;
            }
        }
        else if (
$table instanceof PDOStatement ) {
            while (
$row = $table->fetch ( DB::FETCH_ASSOC ) ) {

                if (
$rowIdx == 0 ) {
                    foreach (
array_keys ( $row ) as $col => $heading ) {
                       
$worksheet->write ( $rowIdx, $col, $heading );
                    }
                   
$rowIdx ++;
                }

                foreach (
array_values ( $row ) as $col => $val ) {
                   
$worksheet->write ( $rowIdx, $col, $val );
                }
               
$rowIdx ++;
            }
        }

       
$workbook->close ();
       
$workbook->send ( $name );
       
$fp = fopen ( $fileName, 'rb' );
       
fpassthru ( $fp );
       
fclose ( $fp );
       
unlink ( $fileName );
        exit;
    }
}


For more information send a message to info at phpclasses dot org.