Rev 57 | Rev 61 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed
<?php
class Camp {
protected static $dbStructure;
public static $myName;
protected static $viewName = 'view_device_location_owner_type';
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>';
$this->data = $dbConnection->getOneRow( $query );
// 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;
$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
}
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'],
self::$viewName,
self::makeWhereClause()
);
$activeOnly = false;
$inactive = sprintf(
'select count(distinct %s) from %s %s',
static::$dbStructure['table']['primaryKey'],
self::$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;
}
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 ) : '';
} //
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>";
}
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;
}
public function __toString() {
return $this->name;
}
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 = "<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;
}
public function run() {
return $this->display();
}
} // abstract class Camp
?>