* ActiveRecords model

4 files changed, 140 insertions, 0 deletions

diff --git a/app/php/model/Calendar.php b/app/php/model/Calendar.php
new file mode 100644
index 0000000..4438572
--- /dev/null
+++ b/app/php/model/Calendar.php
@@ -0,0 +1,40 @@
+<?php
+
+Prado::using('Application.model.Entry');
+Prado::using('Application.model.Category');
+
+class Calendar extends TActiveRecord {
+
+    const TABLE = 'calendars';
+    
+    public $UID;
+    public $Url;
+    public $Name;
+    public $Website;
+    public $Visible;
+    public $LastUpdated;
+
+    public $CategoryID;
+
+    public static $COLUMN_MAPPING = [
+        'uid' => 'UID',
+        'url' => 'Url',
+        'name' => 'Name',
+        'website' => 'Website',
+        'visible' => 'Visible',
+        'last_updated' => 'LastUpdated',
+        '_category' => 'CategoryID'        
+    ];
+
+    public static $RELATIONS = [
+        'Entries' => [self::HAS_MANY, 'Entry', '_calendar'],
+        'Category' => [self::BELONGS_TO, 'Category', '_category']
+    ];
+    
+    public static function finder($className=__CLASS__) {
+        return parent::finder($className);
+    }
+    
+}
+
+?>
diff --git a/app/php/model/Category.php b/app/php/model/Category.php
new file mode 100644
index 0000000..03a368a
--- /dev/null
+++ b/app/php/model/Category.php
@@ -0,0 +1,27 @@
+<?php
+
+Prado::using('Application.model.Calendar');
+
+class Category extends TActiveRecord {
+
+    const TABLE = 'categories';
+
+    public $ID;
+    public $Name;
+
+    public static $COLUMN_MAPPING = [
+        'id' => 'ID',
+        'name' => 'Name'
+    ];
+
+    public static $RELATIONS = [
+        'Calendars' => [self::HAS_MANY, 'Calendar', '_category']
+    ];
+    
+    public static function finder($className=__CLASS__) {
+        return parent::finder($className);
+    }
+    
+}
+
+?>
diff --git a/app/php/model/Entry.php b/app/php/model/Entry.php
new file mode 100644
index 0000000..85d522f
--- /dev/null
+++ b/app/php/model/Entry.php
@@ -0,0 +1,40 @@
+<?php
+
+Prado::using('Application.model.Calendar');
+
+class Entry extends TActiveRecord {
+
+    const TABLE = 'entries';
+
+    public $ID;
+    public $UID;
+    public $BeginDate;
+    public $EndDate;
+    public $AllDay;
+    public $Name;
+    public $Location;
+
+    public $CalendarID;
+
+    public static $COLUMN_MAPPING = [
+        'id' => 'ID',
+        'uid' => 'UID',
+        'begin_date' => 'BeginDate',
+        'end_date' => 'EndDate',
+        'all_day' => 'AllDay',
+        'name' => 'Name',
+        'location' => 'Location',
+        '_calendar' => 'CalendarID'
+    ];
+
+    public static $RELATIONS = [
+        'Calendar' => [self::BELONGS_TO, 'Calendar', '_calendar']
+    ];
+    
+    public static function finder($className=__CLASS__) {
+        return parent::finder($className);
+    }
+    
+}
+
+?>
diff --git a/app/php/model/User.php b/app/php/model/User.php
new file mode 100644
index 0000000..8a33f67
--- /dev/null
+++ b/app/php/model/User.php
@@ -0,0 +1,33 @@
+<?php
+
+Prado::using('Application.model.Calendar');
+
+class User extends TActiveRecord {
+
+    const TABLE = 'users';
+    
+    public $ID;
+    public $Login;
+    public $Password;
+    public $IsAdmin;
+    public $LastLogin;
+
+    public static $COLUMN_MAPPING = [
+        'id' => 'ID',
+        'login' => 'Login',
+        'password' => 'Password',
+        'is_admin' => 'IsAdmin',
+        'last_login' => 'LastLogin'
+    ];
+
+    public static $RELATIONS = [
+        'Calendars' => [self::MANY_TO_MANY, 'Calendar', 'user_selections']
+    ];
+    
+    public static function finder($className=__CLASS__) {
+        return parent::finder($className);
+    }
+    
+}
+
+?>