67 lines
1.9 KiB
PHP
67 lines
1.9 KiB
PHP
<?php
|
|
namespace ZM;
|
|
require_once('database.php');
|
|
require_once('Object.php');
|
|
require_once('Event.php');
|
|
|
|
class Snapshot extends ZM_Object {
|
|
protected static $table = 'Snapshots';
|
|
protected $defaults = array(
|
|
'Id' => null,
|
|
'CreatedBy' => null,
|
|
'CreatedOn' => 'NOW()',
|
|
'Name' => '',
|
|
'Description' => '',
|
|
);
|
|
|
|
public static function find( $parameters = array(), $options = array() ) {
|
|
return ZM_Object::_find(get_class(), $parameters, $options);
|
|
}
|
|
|
|
public static function find_one( $parameters = array(), $options = array() ) {
|
|
return ZM_Object::_find_one(get_class(), $parameters, $options);
|
|
}
|
|
|
|
public function Event() {
|
|
return new Event( $this->{'EventId'} );
|
|
}
|
|
|
|
public function delete() {
|
|
if ( property_exists($this, 'Id') ) {
|
|
dbQuery('DELETE FROM `Snapshot_Events` WHERE `SnapshotId`=?', array($this->{'Id'}));
|
|
dbQuery('DELETE FROM `Snapshots` WHERE `Id`=?', array($this->{'Id'}));
|
|
}
|
|
}
|
|
|
|
public function EventIds( ) {
|
|
if ( ! property_exists($this, 'EventIds') ) {
|
|
$this->{'EventIds'} = dbFetchAll('SELECT `EventId` FROM `Snapshot_Events` WHERE `SnapshotId`=?', 'EventId', array($this->{'Id'}));
|
|
}
|
|
return $this->{'EventIds'};
|
|
}
|
|
public function Events() {
|
|
if ( ! property_exists($this, 'Events') ) {
|
|
$this->{'Events'} = Event::find(array('Id'=>$this->EventIds()));
|
|
}
|
|
return $this->{'Events'};
|
|
}
|
|
|
|
} # end class Snapshot
|
|
|
|
class Snapshot_Event extends ZM_Object {
|
|
protected static $table = 'Snapshot_Events';
|
|
protected $defaults = array(
|
|
'Id' => null,
|
|
'EventId' => 0,
|
|
'SnapshotId' => 0,
|
|
);
|
|
public static function find( $parameters = array(), $options = array() ) {
|
|
return ZM_Object::_find(get_class(), $parameters, $options);
|
|
}
|
|
|
|
public static function find_one( $parameters = array(), $options = array() ) {
|
|
return ZM_Object::_find_one(get_class(), $parameters, $options);
|
|
}
|
|
} # end class Snapshot_Event
|
|
?>
|