*
* @see DB_DataObject
*/
-
-class Group_message_profile extends Memcached_DataObject
+class Group_message_profile extends Managed_DataObject
{
public $__table = 'group_message_profile'; // table name
public $to_profile; // int
- public $group_message_id; // char(36) primary_key not_null
- public $created;
-
- /**
- * Get an instance by key
- *
- * This is a utility method to get a single instance with a given key value.
- *
- * @param string $k Key to use to lookup (usually 'user_id' for this class)
- * @param mixed $v Value to lookup
- *
- * @return Group_message object found, or null for no hits
- *
- */
- function staticGet($k, $v=null)
- {
- return Memcached_DataObject::staticGet('Group_message_profile', $k, $v);
- }
-
- /**
- * return table definition for DB_DataObject
- *
- * DB_DataObject needs to know something about the table to manipulate
- * instances. This method provides all the DB_DataObject needs to know.
- *
- * @return array array of column definitions
- */
- function table()
- {
- return array('to_profile' => DB_DATAOBJECT_INT + DB_DATAOBJECT_NOTNULL,
- 'group_message_id' => DB_DATAOBJECT_STR + DB_DATAOBJECT_NOTNULL,
- 'created' => DB_DATAOBJECT_STR + DB_DATAOBJECT_DATE + DB_DATAOBJECT_TIME + DB_DATAOBJECT_NOTNULL);
- }
-
- /**
- * return key definitions for DB_DataObject
- *
- * DB_DataObject needs to know about keys that the table has, since it
- * won't appear in StatusNet's own keys list. In most cases, this will
- * simply reference your keyTypes() function.
- *
- * @return array list of key field names
- */
- function keys()
- {
- return array_keys($this->keyTypes());
- }
+ public $group_message_id; // varchar(36) primary_key not_null
+ public $created; // datetime() not_null
+ public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
- /**
- * return key definitions for Memcached_DataObject
- *
- * @return array associative array of key definitions, field name to type:
- * 'K' for primary key: for compound keys, add an entry for each component;
- * 'U' for unique keys: compound keys are not well supported here.
- */
- function keyTypes()
+ public static function schemaDef()
{
- return array('to_profile' => 'K', 'group_message_id' => 'K');
- }
-
- /**
- * No sequence keys in this table.
- */
- function sequenceKey()
- {
- return array(false, false, false);
+ return array(
+ 'fields' => array(
+ 'to_profile' => array('type' => 'int', 'not null' => true, 'description' => 'id of group direct message'),
+ 'group_message_id' => array('type' => 'char', 'not null' => true, 'length' => 36, 'description' => 'related group message uuid'),
+ 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
+ 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
+ ),
+ 'primary key' => array('to_profile', 'group_message_id'),
+ 'foreign keys' => array(
+ 'group_message_profile_to_profile_fkey' => array('profile', array('to_profile' => 'id')),
+ 'group_message_profile_group_message_id_fkey' => array('group_message', array('group_message_id' => 'id')),
+ ),
+ );
}
function send($gm, $profile)
{
$gmp = new Group_message_profile();
-
+
$gmp->group_message_id = $gm->id;
$gmp->to_profile = $profile->id;
$gmp->created = common_sql_now();
$gmp->insert();
- $gmp->notify();
+ // If it's not for the author, send email notification
+ if ($gm->from_profile != $profile->id) {
+ $gmp->notify();
+ }
return $gmp;
}
$this->notifyByMail();
}
- function notifyByMail()
+ function notifyByMail()
{
- $to = User::staticGet('id', $this->to_profile);
+ $to = User::getKV('id', $this->to_profile);
if (empty($to) || is_null($to->email) || !$to->emailnotifymsg) {
return true;
}
- $gm = Group_message::staticGet('id', $this->group_message_id);
+ $gm = Group_message::getKV('id', $this->group_message_id);
- $from_profile = Profile::staticGet('id', $gm->from_profile);
+ $from_profile = Profile::getKV('id', $gm->from_profile);
$group = $gm->getGroup();
common_switch_locale($to->language);
// TRANS: Subject for direct-message notification email.
- // TRANS: %s is the sending user's nickname.
- $subject = sprintf(_('New private message from %s to group %s'), $from_profile->nickname, $group->nickname);
+ // TRANS: %1$s is the sending user's nickname, %2$s is the group nickname.
+ $subject = sprintf(_m('New private message from %1$s to group %2$s'), $from_profile->nickname, $group->nickname);
// TRANS: Body for direct-message notification email.
// TRANS: %1$s is the sending user's long name, %2$s is the sending user's nickname,
// TRANS: %3$s is the message content, %4$s a URL to the message,
// TRANS: %5$s is the StatusNet sitename.
- $body = sprintf(_("%1\$s (%2\$s) sent a private message to group %3\$s:\n\n".
- "------------------------------------------------------\n".
- "%4\$s\n".
- "------------------------------------------------------\n\n".
- "You can reply to their message here:\n\n".
- "%5\$s\n\n".
- "Don't reply to this email; it won't get to them.\n\n".
- "With kind regards,\n".
- "%6\$s\n"),
+ $body = sprintf(_m("%1\$s (%2\$s) sent a private message to group %3\$s:\n\n".
+ "------------------------------------------------------\n".
+ "%4\$s\n".
+ "------------------------------------------------------\n\n".
+ "You can reply to their message here:\n\n".
+ "%5\$s\n\n".
+ "Do not reply to this email; it will not get to them.\n\n".
+ "With kind regards,\n".
+ "%6\$s"),
$from_profile->getBestName(),
$from_profile->nickname,
$group->nickname,
$gm->content,
common_local_url('newmessage', array('to' => $from_profile->id)),
- common_config('site', 'name'));
+ common_config('site', 'name')) . "\n";
$headers = _mail_prepare_headers('message', $to->nickname, $from_profile->nickname);