DataObjects/Core_notify.php

[Pman.Core] / SimpleExcel.php

diff --git a/SimpleExcel.php b/SimpleExcel.php
index 2f039bf..d06cb92 100644 (file)
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -40,6 +40,7 @@
  
  
  
+require_once 'Pman.php';
 
 
 class Pman_Core_SimpleExcel extends Pman
@@ -62,7 +63,8 @@ class Pman_Core_SimpleExcel extends Pman
         //$workbook = new Spreadsheet_Excel_Writer();
         $workbook->setVersion(8);
         // sending HTTP headers
-        
+        $this->workbook = $workbook;
+            
         $formats = array();
        
         $cfg['formats'] = isset($cfg['formats']) ? $cfg['formats'] : array();
@@ -75,18 +77,19 @@ class Pman_Core_SimpleExcel extends Pman
              
         }
          
-
-        if (empty($cfg['workbooks'])) {
-            $this->buildpage( $workbook,  $formats , $data,$cfg);
-        } else {
+         
+        if (!empty($cfg['workbook'])) {
+            $this->buildPage(   $formats , $data,$cfg);
+        } elseif (!empty($cfg['workbooks'])) {
             foreach($cfg['workbooks'] as $i =>$wcfg) {
-                $this->buildpage( $workbook,  $formats , $data[$i],$wcfg);
+                $this->buildPage(   $formats , $data[$i],$wcfg);
             }
             
         }
+        // if workbooks == false - > the user can call buildpage..
+        
         
         if (!empty($cfg['leave_open'])) {
-            $this->workbook = $workbook;
             $this->outfile2 = $outfile2;
             return;
         }
@@ -97,6 +100,8 @@ class Pman_Core_SimpleExcel extends Pman
     }
     
     
+    
+    
     static function date($str)
     {
         
@@ -105,8 +110,9 @@ class Pman_Core_SimpleExcel extends Pman
     }
     
     
-    function buildpage($workbook,  $formats , $data,$cfg)
+    function buildPage( $formats , $data, $cfg)
     {
+        $workbook = $this->workbook;
         //echo '<PRE>';        print_R($cfg);
       //  print_r($cfg);exit;
         // Creating a worksheet
@@ -115,7 +121,8 @@ class Pman_Core_SimpleExcel extends Pman
         $this->worksheet_cfg[$cfg['workbook']] = &$cfg;
         
         $this->formats = $formats;
-        
+        //var_dump($cfg['workbook']);
+
         $worksheet =  $workbook->addWorksheet($cfg['workbook']);
         if (is_a($worksheet, 'PEAR_Error')) {
             die($worksheet->toString());
@@ -152,7 +159,6 @@ class Pman_Core_SimpleExcel extends Pman
                     'header' => $col_cfg,
                     'dataIndex' => $col_cfg,
                     'width' => 50,
-                    
                 );
             }
         }
@@ -162,14 +168,14 @@ class Pman_Core_SimpleExcel extends Pman
             $format = isset($col_cfg['color']) ? $formats[$col_cfg['color']] : false;
             $worksheet->write($start_row, $c, $col_cfg['header'],$format);
             $worksheet->setColumn ( $c, $c, $col_cfg['width'] / 5);
-             
         }
         $start_row++;
         $this->start_row = &$start_row;
         
         
         $hasRender  = false;
-           //     DB_DataObject::debugLevel(1);
+         
+        
         foreach($data as $r=>$clo) {
             $hasRenderRow = $this->addLine($cfg['workbook'], $clo);
             $hasRender = ($hasRender  || $hasRenderRow) ? true : false;