Subversion Repositories computer_asset_manager_v2

<?php

   class Camp {

      protected static $dbStructure;

      //public static $myName;

      //protected static $viewName = 'view_device_location_owner_type';

      /**

       * Builds an instance and loads data from database

       * 

       * #parameter int $id The id of the record to load

       */

      public function __construct( $id ) {

         global $dbConnection;

         $this->data = array();

         $fields = array();

         foreach ( static::$dbStructure['table']['fields'] as $key => $data ) {

            if ( $data['type'] != 'calculated' ) { // we have some which are calculated

               $fields[] = $data['fieldname'];

            }

         }

         $query = sprintf( "select %s from %s where %s = %s",

            implode( ',', $fields ),

            static::$dbStructure['table']['tableName'],

            static::$dbStructure['table']['primaryKey'],

            $id

         );

         //print "<pre> Constructor using query\n$query</pre>";

         //print "<pre>Constructor finding dbstructure of\n" . print_r( static::$dbStructure, true) . '</pre>';

         if ( ( $this->data = $dbConnection->getOneRow( $query ) ) === false )

            print DBQuery::error2String();

         // figure out which fields have calculated set so we can

         // do them next

         $calculatedFields = array();

         foreach ( static::$dbStructure['table']['fields'] as $field => $record ) {

            if ( $record['type'] == 'calculated' || $record['type'] == 'link') {

               $calculatedFields[] = $field;

            }

         }

         //print "<pre>" . print_r( $calculatedFields, true ) . "</pre>"; die;

         //print "<pre>" . print_r( $this->data, true ) . "</pre>"; die;

         if ( count( $calculatedFields ) ) {

            $query = sprintf( 'select distinct %s from %s %s',

                     implode( ',', $calculatedFields ),

                     static::$dbStructure['view']['viewName'],

                     static::makeWhereClause( array( 

                        static::$dbStructure['table']['fields']['id']['fieldname'] . 

                        ' = ' . 

                        $this->data[static::$dbStructure['table']['primaryKey']] ) 

                        )

                     );

            //print "<pre>$query</pre>"; die;

            $result = $dbConnection->getOneRow( $query );

            foreach ( $calculatedFields as $field ) {

               $this->data[$field] = empty( $result[$field] ) ? '' : $result[$field];

            } // foreach

         }

      }

      /**

       * gets the contents of $fieldname

       * 

       * @parameter string $fieldname name of the database field to retrieve

       * 

       * @return string The value of $fieldname stored in structure

       */

      public function __get( $fieldname ) {

         return 

            isset( $this->data[static::$dbStructure['table']['fields'][$fieldname]['fieldname']] ) ?

               $this->data[static::$dbStructure['table']['fields'][$fieldname]['fieldname']] :

               null;

      } // __get

      /**

       * Gets stats for an extended class.

       * 

       * Gets number of active and inactive rows for a class, using the

       * view ($viewName)

       * 

       * @return int[] array of integers which is a count

       */

      public static function getStats () {

         global $dbConnection;

         global $activeOnly;

         $return = array();

         $restrictions = array();

         $trueClass = get_called_class();

         $saveActive = $activeOnly;

         $activeOnly = true;

         $active = sprintf( 

            'select count(distinct %s) from %s %s', 

            static::$dbStructure['table']['primaryKey'],  

            static::$dbStructure['view']['viewName'], 

            self::makeWhereClause() 

         );

         $activeOnly = false;

         $inactive = sprintf( 

            'select count(distinct %s) from %s  %s', 

            static::$dbStructure['table']['primaryKey'],  

            static::$dbStructure['view']['viewName'], 

            self::makeWhereClause( array( strtolower( $trueClass ) . "_removed is not null" ) )

         );

         $activeOnly = $saveActive;

         //print "<pre>Active\n$active</pre><pre>Inactive\n$inactive</pre>"; die;

         $return['active'] = $dbConnection->getOneDBValue( $active );

         $return['inactive'] = $dbConnection->getOneDBValue( $inactive );

         return $return;

      }

      /**

       * Creates a where clause

       * 

       * Merges $restrictions with any restrictions which may be in place

       * for the current user. Also sets 'class_removed is null' if

       * $activeOnly (global) is set

       * 

       * @parameter string[] $restrictions array of conditionals

       * 

       * @return string all restricions ANDED together

       */

      protected static function makeWhereClause( $restrictions = array() ) {

         global $activeOnly;

         //print "<pre>" . print_r( $restrictions, true ) . "</pre>";

         $trueClass = get_called_class();

         foreach ( $_SESSION['restrictions'] as $class => $restriction ) {

            $restrictions[] = $_SESSION['restrictions'][$class];

         }

         if ( $activeOnly ) {

            $restrictions[] = strtolower( $trueClass ) . '_removed is null';

         }

         return count( $restrictions ) ? 'where ' . implode( ' and ', $restrictions ) : '';

      } //

      /**

       * Creates a list of all records for a particular class and returns

       * a UL with all LI's set as links (A's) to displaying a record.

       * 

       * @parameter string[] $filter array of conditionals to limit if $list not set

       * @parameter string[] $list An optional list of data to be displayed

       * 

       * @return string A UL with each LI containing a link to an entry

       */

      public static function showSelectionList( $filter = array(), $list = array() ) {

         global $url;

         $return = array();

         if ( empty( $list ) ) {

            $list = self::getAll( $filter );

         }

         $module = get_called_class();

         foreach ( $list as $id => $name ) {

            $return[] = "<a href='$url?module=$module&id=$id'>$name</a>";

         }

         return "<ul>\n<li>" . implode( "</li>\n<li>", $return ) . "</li>\n</ul>";

      }

      /**

       * Gets all matching rows

       * 

       * Does an SQL call to retrieve ID and Name for all rows matching

       * $filter and $_REQUEST['to_find'].

       * 

       * @parameter string[] $filter Optional list of conditionals for where clause

       * 

       * @return array[] An array of indexes and names matching query

       */

      public static function getAll( $filter = array() ) {

         global $activeOnly;

         global $dbConnection;

         //print "<pre>" . print_r( $filter, true ) . "</pre>";

         if ( isset( $_REQUEST['to_find'] ) ) {

            $filter[] = sprintf( " %s like '%%%s%%'", static::$dbStructure['view']['selectionDisplay'],  $_REQUEST['to_find']) ;

         }

         $return = array();

         $query = sprintf( 'select distinct %s id, %s name from %s %s', 

               static::$dbStructure['view']['primaryKey'],

               static::$dbStructure['view']['selectionDisplay'],

               static::$dbStructure['view']['viewName'],

               self::makeWhereClause( $filter )

               );

         $query .= " order by " . static::$dbStructure['view']['selectionDisplay'];

         //print "<pre>$query</pre>\n";

         $result = $dbConnection->doSQL( $query );

         foreach ( $result['returnData'] as $row ) {

            $return[$row['id']] = $row['name'];

         }

         return $return;

      }

      /**

       * Returns the "name" of an instance

       * 

       * Normally, this is $this->name, but some classes may want to put

       * in additional data

       * 

       * @return string Display name of this instance

       */

      public function __toString() {

         return $this->name;

      }

      /**

       * Returns an HTML structure which can display a record

       * 

       * Note that if the instance has children, they will be displayed 

       * also. Additionally, if it has fields marked as type 'calculated'

       * it will perform the limited calculations.

       * 

       * @return string HTML to display record

       */

      public function display() {

         global $url;

         $return = array();

         $save = '';

         /* get the records for this, including from other tables */

         foreach ( static::$dbStructure['table']['fields'] as $key => $record ) {

            if ( isset( $record['display'] ) && $record['display'] === false ) // we don't try to show links

               continue;

            if ( isset( $record['link'] ) ) { // this one is supposed to be set up as a link

                  $return[] = sprintf( 

                     "<td>%s</td><td><a href='$url?module=%s&id=%s'>%s</a></td>",

                     $record['displayName'],

                     static::$dbStructure['table']['fields'][$record['link']]['class'],

                     $this->data[static::$dbStructure['table']['fields'][$record['link']]['fieldname']],

                     $this->data[$record['fieldname']]

                  );

            } else { // just pulling data from the table itself

               $return[] = '<td>' . $record['displayName'] . "</td>\n<td>" . $this->data[$record['fieldname']] . '</td>';

            }

         }

         $return[] = sprintf( "<td colspan='2'><a href='$url?module=%s&id=%s&action=edit'>Edit</a></td>",

                     get_called_class(),

                     $this->data[static::$dbStructure['table']['primaryKey']]

                  );

         $return = "<div class='show_record'>\n<table class='show_record'>\n<tr>" . implode("</tr>\n<tr>", $return ) . "</tr>\n</table>\n</div>";

         /* Now, get the children records */

         if ( isset( $_REQUEST['to_find'] ) ) {

            $save = $_REQUEST['to_find'];

            unset( $_REQUEST['to_find'] );

         }

         foreach ( static::$dbStructure['children'] as $class ) {

            $return .= "<div class='show_record'>\n<h3>$class</h3>\n" . $class::showSelectionList( array( static::$dbStructure['table']['primaryKey'] . ' = ' . $this->data[static::$dbStructure['table']['primaryKey']] )  ) . '</div>';

         }

         if ( $save !== null ) {

            $_REQUEST['to_find'] = $save;

         }

         return $return;

      }

      /**

       * Simple controller. Will determine what action is going on, then

       * call the correct method, returning the HTML required

       */

      public function run() {

         return $this->display();

      }

   } // abstract class Camp

?>