1: <?php
2:
3: // include the config file
4: if(!isset($config)) {
5: require_once '../util/AlphaConfig.inc';
6: $config = AlphaConfig::getInstance();
7:
8: require_once $config->get('app.root').'alpha/util/AlphaAutoLoader.inc';
9: }
10:
11: /**
12: *
13: * Controller for viewing Business Objects as Excel spreadsheets
14: *
15: * @package alpha::controller
16: * @since 1.0
17: * @author John Collins <dev@alphaframework.org>
18: * @version $Id: ViewExcel.php 1654 2013-03-08 17:13:14Z alphadevx $
19: * @license http://www.opensource.org/licenses/bsd-license.php The BSD License
20: * @copyright Copyright (c) 2013, John Collins (founder of Alpha Framework).
21: * All rights reserved.
22: *
23: * <pre>
24: * Redistribution and use in source and binary forms, with or
25: * without modification, are permitted provided that the
26: * following conditions are met:
27: *
28: * * Redistributions of source code must retain the above
29: * copyright notice, this list of conditions and the
30: * following disclaimer.
31: * * Redistributions in binary form must reproduce the above
32: * copyright notice, this list of conditions and the
33: * following disclaimer in the documentation and/or other
34: * materials provided with the distribution.
35: * * Neither the name of the Alpha Framework nor the names
36: * of its contributors may be used to endorse or promote
37: * products derived from this software without specific
38: * prior written permission.
39: *
40: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND
41: * CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
42: * INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
43: * MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
44: * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR
45: * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
46: * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
47: * NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
48: * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
49: * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
50: * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
51: * OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
52: * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
53: * </pre>
54: *
55: */
56: class ViewExcel extends AlphaController implements AlphaControllerInterface {
57: /**
58: * Trace logger
59: *
60: * @var Logger
61: * @since 1.0
62: */
63: private static $logger = null;
64:
65: /**
66: * Constructor
67: *
68: * @since 1.0
69: */
70: public function __construct() {
71: self::$logger = new Logger('ViewExcel');
72: self::$logger->debug('>>__construct()');
73:
74: // ensure that the super class constructor is called, indicating the rights group
75: parent::__construct('Public');
76:
77: self::$logger->debug('<<__construct');
78: }
79:
80: /**
81: * Loads the BO indicated in the GET request and handles the conversion to Excel
82: *
83: * @param array $params
84: * @throws ResourceNotFoundException
85: * @since 1.0
86: */
87: public function doGet($params) {
88: self::$logger->debug('>>doGet(params=['.var_export($params, true).'])');
89:
90: try {
91: if(isset($params['bo'])) {
92: AlphaDAO::loadClassDef($params['bo']);
93: $BO = new $params['bo'];
94:
95: // the name of the file download
96: if(isset($params['oid']))
97: $fileName = $BO->getTableName().'-'.$params['oid'];
98: else
99: $fileName = $BO->getTableName();
100:
101: //header info for browser
102: header('Content-Type: application/vnd.ms-excel');
103: header('Content-Disposition: attachment; filename='.$fileName.'.xls');
104: header('Pragma: no-cache');
105: header('Expires: 0');
106:
107: // handle a single BO
108: if(isset($params['oid'])) {
109: $BO->load($params['oid']);
110: AlphaDAO::disconnect();
111:
112: $convertor = new AlphaDAO2Excel($BO);
113: $convertor->render();
114: }else{
115: // handle all BOs of this type
116: $BOs = $BO->loadAll();
117: AlphaDAO::disconnect();
118:
119: $first = true;
120:
121: foreach($BOs as $BO) {
122: $convertor = new AlphaDAO2Excel($BO);
123: if($first) {
124: $convertor->render(true);
125: $first = false;
126: }else{
127: $convertor->render(false);
128: }
129: }
130: }
131: }else{
132: throw new IllegalArguementException('No BO parameter available for ViewExcel controller!');
133: }
134: }catch (BONotFoundException $e) {
135: self::$logger->error($e->getMessage());
136: throw new ResourceNotFoundException($e->getMessage());
137: }catch (IllegalArguementException $e) {
138: self::$logger->error($e->getMessage());
139: throw new ResourceNotFoundException($e->getMessage());
140: }
141:
142: self::$logger->debug('<<__doGet');
143: }
144:
145: /**
146: * Handle POST requests
147: *
148: * @param array $params
149: * @since 1.0
150: */
151: public function doPOST($params) {
152: self::$logger->debug('>>doPOST($params=['.var_export($params, true).'])');
153:
154: self::$logger->debug('<<doPOST');
155: }
156: }
157:
158: // now build the new controller if this file is called directly
159: if ('ViewExcel.php' == basename($_SERVER['PHP_SELF'])) {
160: $controller = new ViewExcel();
161:
162: if(!empty($_POST)) {
163: $controller->doPOST($_POST);
164: }else{
165: $controller->doGET($_GET);
166: }
167: }
168:
169: ?>