htmlreports.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 modules_htmlreports {
        
        const REPORTS_TABLE = 'dataface__htmlreports_reports';

        
        private $baseURL = null;
        
        public static function getReportsTableSQL(){
                
                $sql = "create table `".self::REPORTS_TABLE."` (
                        `report_id` int(11) not null auto_increment primary key,
                        `actiontool_name` varchar(255),
                        `actiontool_category` varchar(255),
                        `actiontool_label` varchar(255),
                        `actiontool_permission` varchar(255),
                        `icon` varchar(255),
                        `tablename` varchar(255) not null,
                        `template_css` text,
                        `template_html` longtext not null,
                        `default_view` varchar(255),
                        `created_by` varchar(255),
                        `private` tinyint(1) default 0,
                        `date_created` datetime,
                        `last_modified` datetime
                        
                
                )";
                
                return $sql;
        
        }
        
        
        
        public static function q($sql){
                if ( is_array($sql) ){
                        $res = null;
                        foreach ($sql as $q){
                                $res = self::q($q);
                        }
                        return $res;
                } else {
                        $res = mysql_query($sql, df_db());
                        if ( !$res ){
                                throw new Exception(mysql_error(df_db()));
                        }
                        return $res;
                }
        }
        
        
        public static function queryReports($sql){
                try {
                        return self::q($sql);
                } catch ( Exception $ex){
                        self::q(self::getReportsTableSQL());
                        return self::q($sql);
                }
        }
        
        
        
        
        public function __construct(){
                //echo "here";exit;
                Dataface_Table::setBasePath(self::REPORTS_TABLE, dirname(__FILE__));
                $conf =& Dataface_Application::getInstance()->_conf;
                if ( !isset($conf['_allowed_tables']) ){
                        $conf['_allowed_tables'] = array();
                }
                $conf['_allowed_tables'][self::REPORTS_TABLE] = self::REPORTS_TABLE;
                
                self::queryReports("select report_id from `".self::REPORTS_TABLE."` limit 1");
                
                // Now add reports as actions
                $query = Dataface_Application::getInstance()->getQuery();
                
                $sql = "select report_id, actiontool_name, actiontool_category, actiontool_label, tablename, created_by, `private`, date_created, last_modified from `".self::REPORTS_TABLE."` where `tablename`='".addslashes($query['-table'])."' limit 100";
                $res = self::queryReports($sql);
                $reports = array();
                $table = Dataface_Table::loadTable($query['-table']);
                $at = Dataface_ActionTool::getInstance();
                
                while ($row = mysql_fetch_assoc($res) ){
                        $report = new Dataface_Record(self::REPORTS_TABLE, $row);
                        //$perms = $table->getPermissions(array('report'=>$report));
                        $icon = $this->getBaseURL().'/images/report_icon.png';
                        if ( $report->val('default_view') ){
                                $icon = $this->getBaseURL().'/images/'.basename($report->val('default_view')).'_icon.png';
                                
                        }
                        if ( $report->val('icon') ){
                                $icon = $report->val('icon');
                        }
                        //if ( @$perms['view report'] ){
                                $action = array(
                                        'name'=>$row['actiontool_name'],
                                        'label'=>$row['actiontool_label'],
                                        'category'=>$row['actiontool_category'],
                                        'url'=>'{$this->url(\'-action=htmlreports_view_report\')}&--report-id='.$row['report_id'],
                                        'table'=>$query['-table'],
                                        'icon'=>$icon,
                                        'permission' => $report->val('actiontool_permission')
                                );
                                $at->addAction($row['actiontool_name'], $action);
                        //}
                }
                
                
                
                Dataface_Application::getInstance()->addHeadContent(
                        '<script>XATAFACE_MODULES_HTMLREPORTS_URL="'.$this->getBaseURL().'";</script>'
                );
                
                
                
                
                
        
        }
        
        public function getBaseURL(){
                if ( !isset($this->baseURL) ){
                        $this->baseURL = Dataface_ModuleTool::getInstance()->getModuleURL(__FILE__);
                }
                return $this->baseURL;
        }
        
        
        public function getReportById($id){
                return df_get_record(self::REPORTS_TABLE, array('report_id'=>'='.$id));
        }
        
        
}