Subversion Repositories php_library

<?php

   class QueryParameters {
      protected $parameter;
      protected $prompt;
      protected $query;
      protected $displayQuery;
      protected $value;
      private $parametersDelimiter = '++';

      function __constructor ( $parameter = '', $prompt = '', $query = '' ) {
         $this->parameter = $parameter;
         $this->prompt = $prompt;
         $this->query = $query;
      }
      
      function stringToParameter( $string ) {
         $temp = explode( $this->parametersDelimiter, $string );
         $this->parameter = $temp[0];
         $this->prompt = $temp[1];
         $this->query = $temp[2];
         $this->displayQuery = $temp[3];
      }
      
      function name ( $newParameter = '' ) {
         $oldParameter = $this->parameter;
         if ($newParameter) {
            $this->parameter = $newParameter;
         }
         return $oldParameter;
      }
      
      function value ( $newValue = '' ) {
         $oldValue = $this->value;
         if ($newValue) {
            $this->value = $newValue;
         }
         return $oldValue;
      }

      function prompt ( $newPrompt = '' ) {
         $oldPrompt = $this->prompt;
         if ($newPrompt) {
            $this->prompt = $newPrompt;
         }
         return $oldPrompt;
      }
   
      function query ( $newQuery = '' ) {
         $oldQuery = $this->query;
         if ($newQuery) {
            $this->query = $newQuery;
         }
         return $oldQuery;
      }
      
      function displayQuery ( $newQuery = '' ) {
         $oldQuery = $this->displayQuery;
         if ($newQuery) {
            $this->displayQuery = $newQuery;
         }
         return $oldQuery;
      }
      
      function toHTML () {
         $result = "<td>$this->prompt</td><td>";
         if ( $this->query ) {
            $result .= "<select name='report_param_$this->parameter'>" . queryToSelect( $this->query ) . '</select>';
         } else {
            $result .= "<input type='text' name='$this->parameter'>";
         }
         $result .= '</td>';
         return $result;
      }
   } // class QueryParameters

   class Report {
      protected $name;
      protected $title;
      protected $query;
      protected $parameters = array();
      private $tableName = 'report';
      private $nameField = 'name';
      private $queryField = 'query';
      private $parametersField = 'parameters';
      private $idField = 'report_id';

      
      static public function listAllReports( $tableName = 'report', $nameField = 'name', $idField = 'report_id' ) {
         return queryToSelect( "select $idField, $nameField from $tableName" );
      }

      function __constructor ($name = '', $title = '', $query = '', $parameters = array() ) {
         $this->name = $name;
         $this->title = $title;
         $this->query = $query;
         $this->parameters = $parameters;
      }
      
      function loadFromDatabase ( $id ) {
         $sql = "select $this->nameField, $this->queryField, $this->parametersField from $this->tableName where $this->idField = $id";
         $result = queryDatabaseExtended( $sql );
         $result = $result['data'][0];
         $this->name = $result[$this->nameField];
         $this->title = $result[$this->nameField];
         $this->query = $result[$this->queryField];
         $parameters = $result[$this->parametersField];
         $parameters = explode("\n", $parameters);
         foreach ( $parameters as $thisParam ) {
            if (! $thisParam ) {
               continue;
            }
            $temp = new QueryParameters();
            $temp->stringToParameter($thisParam);
            $this->parameters[] = $temp;
         }
      }

      function name ( $newName = '' ) {
         $oldName = $this->name;
         if ($newName) {
            $this->name = $newName;
         }
         return $oldName;
      }

      function query ( $newQuery = '' ) {
         $oldQuery = $this->query;
         if ($newQuery) {
            $this->query = $newQuery;
         }
         return $oldQuery;
      }

      function parameters ( $newParameters = array() ) {
         $oldParameters = $this->parameters;
         if ($newParameters) {
            $this->parameters = $newParameters;
         }
         return $oldParameters;
      }

      function addParameter ( $newParameter = array() ) {
         $this->parameters[] = $newParameter;
      }
      
      function run( $parameters = '') {
         $conditions = array();
         if ( ! $parameters ) { // try to get them from the POST line
            foreach ( $this->parameters as $parameter ) {
               if ($_POST['report_param_' . $parameter->name()]) {
                  $parameter->value($_POST['report_param_' . $parameter->name()]);
               }
            }
         }
         // print "<pre>" . print_r( $this ); print "</pre>";
         foreach ( $this->parameters as $parameter ) {
            $toFind = '<' . $parameter->name() . '>';
            $this->query = preg_replace( "/$toFind/", $parameter->value(), $this->query );
            if ( $parameter->displayQuery() ) {
               //$result = preg_replace( '/<value>/', $parameter->value(), $parameter->displayQuery() );
               $result = queryDatabaseExtended(preg_replace( '/<value>/', $parameter->value(), $parameter->displayQuery() ), false);
               //print "<pre>" . print_r( $result ); print "</pre>";
               $conditions[] = $parameter->name() . ' - '  . $result['data'][0][0];
            } else {
               $conditions[] = $parameter->name() . ' - ' . $parameter->value();
            }
         }
         return '<h1>' . $this->title . '</h1>' . '<h2>' . implode('</h2><h2>', $conditions) . '</h2>' . queryToTable($this->query);
      }
      
      function toHTML( ) {
         $result = "<table border='1'>\n";
         $result .= "<tr><td colspan='2'>$this->name</td></tr>";
         foreach ( $this->parameters as $parameter ) {
            $result .= '<tr>' . $parameter->toHTML() . '</tr>';
         }
         return $result . '<table>';
      }

   } // class Report

?>