| alpha--util--convertors

# Source for file AlphaDAO2Excel.inc Documentation is available at AlphaDAO2Excel.inc <?php /** * Class for converting a Business Object to an Excel spreadsheet * * @package alpha::util::convertors * @since 1.0 * @author John Collins <dev@alphaframework.org> * @version $Id: AlphaDAO2Excel.inc 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). * All rights reserved. * * <pre> * 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 * following disclaimer. * * 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. * </pre> * */ class AlphaDAO2Excel { /** * The Business Object we will convert to an Excel sheet * * @var AlphaDAO * @since 1.0 */ private $BO; /** * Trace logger * * @var Logger * @since 1.0 */ private static $logger = null; /** * Constructor * * @param AlphaDAO $BO * @since 1.0 */ public function __construct($BO) { self::$logger = new Logger('AlphaDAO2Excel'); self::$logger->debug('>>__construct(BO=['.var_export($BO, true).'])'); $this->BO = $BO; 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). * @since 1.0 */ public function render($renderHeaders=true) { self::$logger->debug('>>render()'); //define separator (tabbed character) $sep = "\t"; // get the class attributes $reflection = new ReflectionClass(get_class($this->BO)); $properties = $reflection->getProperties(); // print headers if($renderHeaders) { 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 "\n"; } // print values 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())) { if(get_class($prop) == 'DEnum') echo $prop->getDisplayValue().$sep; elseif(get_class($prop) == 'Relation') echo $prop->getRelatedClassDisplayFieldValue().$sep; else echo preg_replace("/[\n\r]/", "", $prop->getValue()).$sep; } } echo "\n"; self::$logger->debug('<<render'); } } ?> Documentation generated on Thu, 17 Mar 2011 16:43:25 +0000 by phpDocumentor 1.4.3