From c1ceff9eed61607f5970788c66ce4fff61045f03 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Thu, 22 May 2014 16:08:25 +0800
Subject: [PATCH] DatabaseColumns.php

---
 DatabaseColumns.php | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

diff --git a/DatabaseColumns.php b/DatabaseColumns.php
index e9e4c7fc..9d805e4b 100644
--- a/DatabaseColumns.php
+++ b/DatabaseColumns.php
@@ -31,6 +31,8 @@ class Pman_Core_DatabaseColumns extends Pman {
         foreach($re['join_names'] as $c=>$f) {
             $re['cols'][$c] = $f;
         }
+        
+        
         foreach($re['cols'] as $c=>$f) {
             $ret[]  = array(
                 'name' => $c,
@@ -38,6 +40,36 @@ class Pman_Core_DatabaseColumns extends Pman {
             );
             
         }
+        
+        
+        require_once 'Pman/Core/SimpleExcel.php';
+        $x = new Pman_Core_SimpleExcel(
+            array($bt,$et, $ut), array(
+            'formats' => array(
+                'vtop' => array('vAlign' => 'top'),
+                'vcenter' => array('vAlign' => 'vcenter'),
+                
+                'percent' => array('vAlign' => 'vcenter', 'numFormat' => '0%'),
+                'money' => array('vAlign' => 'vcenter', 'numFormat' => '$#,###'),
+                'date' => array('vAlign' => 'vcenter', 'numFormat' => 'd/M/Y'),
+            ),
+            'workbooks' => array(
+                array(
+                    'workbook' => 'Business',
+                    'cols' => explode('|', 'keyIdentity_taxId|description|type|countryIso3|countryRegion|addr1|addr2|addr3|city|zip')
+                ),
+                array(
+                    'workbook' => 'Employment',
+                    'cols' => explode('|', 'emailAddress|identity_taxId')
+                ),
+                array(
+                    'workbook' => 'Users',
+                    'cols' => explode('|', 'generateLogin|firstName|middleName|lastName|emailAddress|locale|countryIso3|countryRegion|addr1|addr2|addr3|city|zip|userStatus')
+                ),
+            )
+            
+        ));
+        $x->send('test_'. date('d_M_Y').'.xls');
         $this->jdata($ret);
         
         
-- 
2.39.2