/Applications/XAMPP/xamppfiles/htdocs/researchdb/modules/summary/summary.php

Go to the documentation of this file.

<?php
/*
 * Xataface Summary Module
 * 
 * Copyright (C) 2011  Steve Hannah <shannah@sfu.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 modules_summary {

        private $cache = array();
        
        private $baseURL=null;

        public function __construct(){
        
                
        }
        
        
        public function decorateSummaryField($key, &$field){
                
                if ( !isset($field['widget']) ) $field['widget'] = array();
                if ( !isset($field['widget']['label']) ){
                        if ( isset($field['widget:label']) ){
                                $field['widget']['label'] = $field['widget:label'];
                        } else {
                                $field['widget']['label'] = $field['widget:label'];
                        }//$key;
                }
        }
        
        
        public function getBaseURL(){
                if ( !isset($this->baseURL) ){
                        $this->baseURL = Dataface_ModuleTool::getInstance()->getModuleURL(__FILE__);
                }
                return $this->baseURL;
        }
        
        public function &getSummaryFields(Dataface_Table $table){
                $tablename = $table->tablename;
                
                if ( !isset($this->cache[$tablename]) ){
                        $this->cache[$tablename] = array();
                }
                
                $cache =& $this->cache[$tablename];
                if ( !isset($cache['summary_fields']) ){
                        $cache['summary_fields'] = array();
                        $summary_fields =& $cache['summary_fields'];
                        
                        foreach ( $table->attributes() as $fieldname=>$field ){
                                if ( !is_array($field) ) continue;
                                if ( @$field['summary'] ){
                                        $summary_fields[$fieldname] = $field;
                                        $this->decorateSummaryField($fieldname, $summary_fields[$fieldname]);
                                }
                        }
                } else {
                        $summary_fields =& $cache['summary_fields'];
                }
                return $summary_fields;
        
        }
        
        
        public function getSummaryField(Dataface_Table $table, $fieldname){
                $fields =& $this->getSummaryFields($table);
                if ( !isset($fields[$fieldname]) ){
                        return null;
                }
                
                return $fields[$fieldname];
        }
        
        
        public function getSummarySQL(Dataface_Table $table, $query, $groupBy=null, $summaryFields=null, $graftedSummaryFields=null){
                
                $qb = new Dataface_QueryBuilder($table->tablename, $query);
                
                if ( !$groupBy ){
                        $groupBy = '';
                }
                
                if ( !isset($summaryFields) ){
                        $summaryFields = array_keys($this->getSummaryFields($table));
                }
                
                $sql = $qb->select($groupBy, $query);
                if ( $groupBy ){
                        $gbc = ' group by `'.implode('`,`', $groupBy).'`';
                        if ( preg_match('/( LIMIT [\s\S]*)$/i', $sql, $matches) ){
                                $sql = preg_replace('/( LIMIT [\s\S]*)$/i', $gbc.'$1', $sql);
                        } else {
                                $sql .= $gbc;
                        }
                } else {
                        $sql = preg_replace('/select (.*?) from /i', 'select  from ', $sql);
                }
                //echo $sql;
                if ( $summaryFields){
                        $pos = stripos($sql, ' from ');
                        $sql1 = substr($sql, 0, $pos);
                        $sql2 = substr($sql, $pos);
                        
                        $summaryStr = array();
                        foreach ($summaryFields as $fname){
                                $field = $this->getSummaryField($table, $fname);
                                if ( !$field  and is_array($graftedSummaryFields) ){
                                        $field = @$graftedSummaryFields[$fname];
                                }
                                if ( !$field ) continue;
                                if ( !@$field['formula'] ) continue;
                                
                                $summaryStr[] = $field['formula'].' as `'.$fname.'`';
                        }
                        $summaryStr = implode(', ', $summaryStr);
                        $sql = $sql1.($groupBy?',':'').' '.$summaryStr.' '.$sql2;
                }
                return $sql;
        
        }
        
        
        
        
}