Source for file ViewExcel.php
Documentation is available at ViewExcel.php
// include the config file
require_once '../util/AlphaConfig.inc';
require_once $config->get('sysRoot'). 'alpha/controller/AlphaController.inc';
require_once $config->get('sysRoot'). 'alpha/util/Logger.inc';
require_once $config->get('sysRoot'). 'alpha/util/convertors/AlphaDAO2Excel.inc';
require_once $config->get('sysRoot'). 'alpha/controller/AlphaControllerInterface.inc';
* Controller for viewing Business Objects as Excel spreadsheets
* @package alpha::controller
* @author John Collins <dev@alphaframework.org>
* @version $Id: ViewExcel.php 1341 2011-03-17 15:02:02Z johnc $
* @license http://www.opensource.org/licenses/bsd-license.php The BSD License
* @copyright Copyright (c) 2011, John Collins (founder of Alpha Framework).
* Redistribution and use in source and binary forms, with or
* without modification, are permitted provided that the
* following conditions are met:
* * Redistributions of source code must retain the above
* copyright notice, this list of conditions and the
* * Redistributions in binary form must reproduce the above
* copyright notice, this list of conditions and the
* following disclaimer in the documentation and/or other
* materials provided with the distribution.
* * Neither the name of the Alpha Framework nor the names
* of its contributors may be used to endorse or promote
* products derived from this software without specific
* prior written permission.
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND
* CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
* INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
* MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
* NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
* HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
* OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
private static $logger = null;
self::$logger = new Logger('ViewExcel');
self::$logger->debug('>>__construct()');
// ensure that the super class constructor is called, indicating the rights group
parent::__construct('Public');
self::$logger->debug('<<__construct');
* Loads the BO indicated in the GET request and handles the conversion to Excel
* @throws ResourceNotFoundException
public function doGet($params) {
self::$logger->debug('>>doGet(params=['. var_export($params, true). '])');
if(isset ($params['bo'])) {
// the name of the file download
if(isset ($params['oid']))
$fileName = $BO->getTableName(). '-'. $params['oid'];
$fileName = $BO->getTableName();
//header info for browser
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename='. $fileName. '.xls');
if(isset ($params['oid'])) {
$BO->load($params['oid']);
// handle all BOs of this type
$convertor->render(true);
$convertor->render(false);
self::$logger->error($e->getMessage());
throw new ResourceNotFoundException($e->getMessage());
self::$logger->error($e->getMessage());
throw new ResourceNotFoundException($e->getMessage());
self::$logger->debug('<<__doGet');
public function doPOST($params) {
self::$logger->debug('>>doPOST($params=['. var_export($params, true). '])');
self::$logger->debug('<<doPOST');
// now build the new controller if this file is called directly
if ('ViewExcel.php' == basename($_SERVER['PHP_SELF'])) {
$controller->doGET($_GET);
|