actions/htmlreports_schemabrowser_getschema.php

Go to the documentation of this file.

<?php
/*
 * Xataface HTML Reports Module
 * Copyright (C) 2011  Steve Hannah <steve@weblite.ca>
 * 
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Library General Public
 * License as published by the Free Software Foundation; either
 * version 2 of the License, or (at your option) any later version.
 * 
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Library General Public License for more details.
 * 
 * You should have received a copy of the GNU Library General Public
 * License along with this library; if not, write to the
 * Free Software Foundation, Inc., 51 Franklin St, Fifth Floor,
 * Boston, MA  02110-1301, USA.
 *
 */
 
class actions_htmlreports_schemabrowser_getschema {
        
        function handle($params){
                
                session_write_close();
                header('Connection:close');
                require_once(dirname(__FILE__).'/../classes/XfHtmlReportBuilder.class.php');
                $app = Dataface_Application::getInstance();
                $query = $app->getQuery();
                $table = Dataface_Table::loadTable($query['-table']);
                $perms = $table->getPermissions(array());
                
                
                try {
                
                        if ( !@$perms['view schema'] ){
                                throw new Exception("You don't have permission to view this table's schema.");
                        }
                        
                        
                        $opts = array();
                        $opts[] = array(
                                'data'=>df_translate('xataface.modules.htmlreports.schemabrowser.fields_label','Fields'),
                                'children'=>array()
                        );
                        
                        
                        // First do the regular fields
                        $fields =& $table->fields();
                        
                        $fieldOpts =& $opts[0]['children'];
                        foreach ($fields as $field){
                                $fperms = $table->getPermissions(array('field'=>$field['name']));
                                if ( !@$fperms['view schema'] ) continue;
                                $myopt= array(
                                        'data'=>$field['widget']['label'],
                                        'attr'=> array(
                                                'xf-htmlreports-fieldname'=>$field['name'],
                                                'xf-htmlreports-macro'=>'{$'.$field['name'].'}'
                                        )
                                );
                                
                                $children = array();
                                foreach ( XfHtmlReportBuilder::$SUMMARY_FUNCTIONS as $func ){
                                        $children[] = array(
                                                'data'=> $func.'('.$field['widget']['label'].')',
                                                'attr'=>array(
                                                        'xf-htmlreports-macro'=>'{@'.$func.'('.$field['name'].')}'
                                                )
                                        );
                                }
                                
                                $myopt['children'] = $children;
                                $fieldOpts[] = $myopt;
                        }
                        
                        unset($fieldOpts);
                        
                        
                        // Next we do the grafted fields
                        $fieldOpts = array();
                        $graftedOpt = array(
                                'data'=>df_translate('xataface.modules.htmlreports.schemabrowser.grafted_fields_label', 'Grafted Fields')
                        );
                        $graftedOpt['children'] =& $fieldOpts;
                        
                        unset($fields);
                        $fields =& $table->graftedfields();
                        foreach ($fields as $field){
                                $fperms = $table->getPermissions(array('field'=>$field['name']));
                                if ( !@$fperms['view'] or !@$fperms['view schema'] ) continue;
                                $myopt = array(
                                        'data'=>$field['widget']['label'],
                                        'attr'=>array(
                                                'xf-htmlreports-fieldname'=>$field['name'],
                                                'xf-htmlreports-macro'=> '{$'.$field['name'].'}'
                                        )
                                );
                                
                                $children = array();
                                foreach ( XfHtmlReportBuilder::$SUMMARY_FUNCTIONS as $func ){
                                        $children[] = array(
                                                'data'=> $func.'('.$field['widget']['label'].')',
                                                'attr'=>array(
                                                        'xf-htmlreports-macro'=>'{@'.$func.'('.$field['name'].')}'
                                                )
                                        );
                                }
                                
                                $myopt['children'] = $children;
                                $fieldOpts[] = $myopt;
                        }
                        
                        $opts[] = $graftedOpt;
                        
                        
                        unset($fieldOpts);
                        unset($graftedOpt);
                        unset($fields);
                        
                        
                        // Next we do the calculated fields
                        $fieldOpts = array();
                        $calcOpt = array(
                                'data'=>df_translate('xataface.modules.htmlreports.schemabrowser.calculated_fields_label', 'Calculated Fields')
                        );
                        $calcOpt['children'] =& $fieldOpts;
                        $fields =& $table->delegateFields();
                        
                        foreach ($fields as $field){
                                $fperms = $table->getPermissions(array('field'=>$field['name']));
                                if ( !@$fperms['view schema'] ) continue;
                                $myopt = array(
                                        'data'=>$field['widget']['label'],
                                        'attr'=>array(
                                                'xf-htmlreports-fieldname'=>$field['name'],
                                                'xf-htmlreports-macro'=> '{$'.$field['name'].'}'
                                        )
                                );
                                
                                $children = array();
                                foreach ( XfHtmlReportBuilder::$SUMMARY_FUNCTIONS as $func ){
                                        $children[] = array(
                                                'data'=> $func.'('.$field['widget']['label'].')',
                                                'attr'=>array(
                                                        'xf-htmlreports-macro'=>'{@'.$func.'('.$field['name'].')}'
                                                )
                                        );
                                }
                                
                                $myopt['children'] = $children;
                                
                                $fieldOpts[] = $myopt;
                        }
                        
                        $opts[] = $calcOpt;
                        
                        unset($calcOpt);
                        unset($fields);
                        unset($fieldOpts);
                        
                        
                        // Now we do the relationships
                        
                        $rOpt = array(
                                'data'=>df_translate('xataface.modules.htmlreports.schemabrowser.relationships_label', 'Relationships'),
                                'data-key'=>'relationships'
                        );
                        $rOptOpts = array();
                        $rOpt['children'] =& $rOptOpts;
                        $opts[] = $rOpt;
                        
                        $relationships =& $table->relationships();
                        foreach ($relationships as $rname=>$r){
                                $rperms = $table->getPermissions(array('relationship'=>$rname));
                                if ( !@$rperms['view schema'] ) continue;
                                
                                $rfieldOpts = array();
                                $rfields = $r->fields(true);
                                $thisrOpt = array(
                                        'data'=>$r->getLabel(),
                                        'attr'=>array(
                                                'xf-htmlreports-relationshipname'=>$rname
                                        )
                                );
                                $thisrOpt['children'] =& $rfieldOpts;
                                
                                foreach ($rfields as $rfield){
                                        $fieldDef = $r->getField($rfield);
                                        $ftable = Dataface_Table::loadTable($fieldDef['tablename']);
                                        $fperms = $table->getPermissions(array('field'=>$fieldDef['name']));
                                        if ( !@$fperms['view schema'] ){
                                                continue;
                                        }
                                        
                                        $rfieldOpts[] = array(
                                                'data' => $fieldDef['widget']['label'],
                                                'attr'=>array(
                                                        'xf-htmlreports-macro' => '{$'.$rname.'.'.$fieldDef['name'].'}',
                                                        'xf-htmlreports-fieldname'=>$fieldDef['name']
                                                )
                                        );
                                        
                                        
                                        
                                        
                                }
                                
                                unset($rfieldOpts);
                                $rOptOpts[] = $thisrOpt;
                                
                        }
                        
                        
                        
                        
                        $root = array(
                                'data'=>$table->getLabel(),
                                'children'=>$opts
                        );
                        
                        $this->out(array(
                                'code'=>200,
                                'schema'=>$opts
                        ));
                        exit;
                        
                        
                
                } catch (Exception $ex){
                        $this->out(array(
                                'code'=>$ex->getCode(),
                                'message'=>$ex->getMessage()
                        ));
                        exit;
                }
        
        }
        
        function out($params){
                header('Content-type: text/json; charset="'.Dataface_Application::getInstance()->_conf['oe'].'"');
                echo json_encode($params);
        }
        
        
}