public $__table = 'profile'; // table name
public $id; // int(4) primary_key not_null
- public $nickname; // varchar(64) not_null
- public $fullname; // varchar(255)
+ public $nickname; // varchar(64) multiple_key not_null
+ public $fullname; // varchar(255) multiple_key
public $profileurl; // varchar(255)
- public $homepage; // varchar(255)
- public $bio; // varchar(140)
- public $location; // varchar(255)
+ public $homepage; // varchar(255) multiple_key
+ public $bio; // varchar(140) multiple_key
+ public $location; // varchar(255) multiple_key
public $created; // datetime() not_null
public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
}
return true;
}
-
+
function getBestName() {
return ($this->fullname) ? $this->fullname : $this->nickname;
}
+
+ # Get latest notice on or before date; default now
+ function getCurrentNotice($dt=NULL) {
+ $notice = new Notice();
+ $notice->profile_id = $this->id;
+ if ($dt) {
+ $notice->whereAdd('created < "' . $dt . '"');
+ }
+ $notice->orderBy('created DESC, notice.id DESC');
+ $notice->limit(1);
+ if ($notice->find(true)) {
+ return $notice;
+ }
+ return NULL;
+ }
}