Source for file AlphaDAO2Excel.inc
Documentation is available at AlphaDAO2Excel.inc
* Class for converting a Business Object to an Excel spreadsheet
* @package alpha::util::convertors
* @author John Collins <dev@alphaframework.org>
* @version $Id: AlphaDAO2Excel.inc 1454 2011-12-04 15:14:05Z 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.
* The Business Object we will convert to an Excel sheet
private static $logger = null;
self::$logger = new Logger('AlphaDAO2Excel');
self::$logger->debug('>>__construct(BO=['. var_export($BO, true). '])');
self::$logger->debug('<<__construct');
* Sends the output as an Excel spreadsheet to standard output
* @param bool $renderHeaders Set to false to supress headers in the spreadsheet (defaults to true).
public function render($renderHeaders= true) {
self::$logger->debug('>>render()');
//define separator (tabbed character)
// get the class attributes
$reflection = new ReflectionClass(get_class($this->BO));
$properties = $reflection->getProperties();
echo $this->BO->getDataLabel('OID'). $sep;
foreach($properties as $propObj) {
$propName = $propObj->name;
if (!in_array($propName, $this->BO->getTransientAttributes()) && !in_array($propName, $this->BO->getDefaultAttributes())) {
echo $this->BO->getDataLabel($propName). $sep;
echo $this->BO->getOID(). $sep;
foreach($properties as $propObj) {
$propName = $propObj->name;
$prop = $this->BO->getPropObject($propName);
if (!in_array($propName, $this->BO->getTransientAttributes()) && !in_array($propName, $this->BO->getDefaultAttributes())) {
echo $prop->getDisplayValue(). $sep;
echo $prop->getRelatedClassDisplayFieldValue(). $sep;
self::$logger->debug('<<render');
|