Source for file OCSP_FRMVIEW_PEAR_DATAGRID.phpclass

Documentation is available at OCSP_FRMVIEW_PEAR_DATAGRID.phpclass

  1. <?php
  2. /**
  3.   * openCSP class file OCSP_FRMVIEW_PEAR_DATAGRID.phpclass
  4.   *
  5.   * @project Open CSP-Management
  6.   * @package default
  7.   *
  8.   * @author Peter Krebs <pitlinz@users.sourceforge.net>
  9.   * @license http://opensource.org/licenses/gpl-license.php GNU Public License
  10.   *
  11.   * @since pk-27.11.2008
  12.   * @version $Id: OCSP_FRMVIEW_PEAR_DATAGRID.phpclass,v 1.3 2008/12/06 11:22:01 pitlinz Exp $
  13.   */
  14.  
  15.     // ---------------------------------------------------------
  16.     // requirements
  17.     // ---------------------------------------------------------
  18.  
  19.     pcf_require_class('OCSP_FRMVIEW_LIST',dirname(__FILE__) . _OCSP_DIRSEP_ . "OCSP_FRMVIEW_LIST.phpclass");
  20.  
  21.  
  22. /**
  23.   * openCSP class OCSP_FRMVIEW_PEAR_DATAGRID
  24.   *
  25.   * @project Open CSP-Management
  26.   * @package default
  27.   *
  28.   * @author Peter Krebs <pitlinz@users.sourceforge.net>
  29.   * @license http://opensource.org/licenses/gpl-license.php GNU Public License
  30.   *
  31.   * @since pk-27.11.2008
  32.   * @version $Id: OCSP_FRMVIEW_PEAR_DATAGRID.phpclass,v 1.3 2008/12/06 11:22:01 pitlinz Exp $
  33.   */
  34. class OCSP_FRMVIEW_PEAR_DATAGRID extends OCSP_FRMVIEW_LIST
  35. {
  36.     // ---------------------------------------------------------------------------
  37.     // constants
  38.     // ---------------------------------------------------------------------------
  39.     
  40.     /**
  41.      * @constant string CLASS_SRC_FILE
  42.      */
  43.     const CLASS_SRC_FILE = __FILE__;
  44.  
  45.     // ---------------------------------------------------------------------------
  46.     // class (static)
  47.     // ---------------------------------------------------------------------------
  48.     
  49.     /*** class vars ------------------------------------------------------ */
  50.     
  51.     /*** class methods --------------------------------------------------- */
  52.     
  53.     // ---------------------------------------------------------------------------
  54.     // object vars
  55.     // ---------------------------------------------------------------------------
  56.     
  57.     /*** compostion --------------------------------------------------- */
  58.     
  59.     /*** attributes  -------------------------------------------------- */
  60.     
  61.     protected $myExcelWorkBench = Null;
  62.     
  63.     // ---------------------------------------------------------------------------
  64.     // factory / construct
  65.     // ---------------------------------------------------------------------------
  66.     
  67.     // ---------------------------------------------------------------------------
  68.     // getter / setter
  69.     // ---------------------------------------------------------------------------    
  70.  
  71.     
  72.     public function getExcel($fileName="export.xls")
  73.     {
  74.         if (!class_exists('Spreadsheet_Excel_Writer'))
  75.         {
  76.             require_once "Spreadsheet/Excel/Writer.php";
  77.         }
  78.         
  79.         set_time_limit(60*5);
  80.         
  81.         // Create a workbook        
  82.         $this->myExcelWorkBench = new Spreadsheet_Excel_Writer();
  83.  
  84.         // Specify avoid tmpfile error
  85.         $this->myExcelWorkBench->setTempDir(OCSP_CONF::getInstance()->getValue('TMPPATH'));
  86.                 
  87.         // Specify that spreadsheet must be sent the browser
  88.         $this->myExcelWorkBench->send($fileName);
  89.                 
  90.         // Create your format
  91.         $format_bold =& $this->myExcelWorkBench->addFormat();
  92.         $format_bold->setBold();
  93.  
  94.         // Fill the workbook, passing the format as an option
  95.         $options = array(
  96.                 'headerFormat'     => &$format_bold,
  97.                 'tempDir'           => OCSP_CONF::getInstance()->getValue('TMPPATH'),
  98.                 'filename'           => $fileName,
  99.                 'sendToBrowser'    => True,
  100.                 'encoding'      => 'ISO-8859-15'
  101.             );
  102.         
  103.         
  104.         $obj_dataGrid = $this->getMyForm()->getControl()->getDataGrid($debug);
  105.         
  106.         if ($debug) echoDebugLine(__FILE__,__LINE__,"DataGrid: " . get_class($obj_dataGrid));
  107.         $obj_dataGrid->setRenderer('XLS',$options);
  108.         $obj_dataGrid->fill(&$this->myExcelWorkBench,$options);
  109.         $obj_dataGrid->render();
  110.         
  111.  
  112.         
  113.         
  114.     }
  115. }
  116.  
  117. ?>

Documentation generated on Thu, 08 Jan 2009 17:46:39 +0100 by phpDocumentor 1.4.0a2