diff options
Diffstat (limited to 'app/php')
-rw-r--r-- | app/php/model/Calendar.php | 40 | ||||
-rw-r--r-- | app/php/model/Category.php | 27 | ||||
-rw-r--r-- | app/php/model/Entry.php | 40 | ||||
-rw-r--r-- | app/php/model/User.php | 33 |
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); + } + +} + +?> |