12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- <?php
- class Confirm_address extends Managed_DataObject
- {
- public $__table = 'confirm_address';
- public $code;
- public $user_id;
- public $address;
- public $address_extra;
- public $address_type;
- public $claimed;
- public $sent;
- public $modified;
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'code' => array('type' => 'varchar', 'length' => 32, 'not null' => true, 'description' => 'good random code'),
- 'user_id' => array('type' => 'int', 'not null' => true, 'description' => 'user who requested confirmation'),
- 'address' => array('type' => 'varchar', 'length' => 191, 'not null' => true, 'description' => 'address (email, xmpp, SMS, etc.)'),
- 'address_extra' => array('type' => 'varchar', 'length' => 191, 'description' => 'carrier ID, for SMS'),
- 'address_type' => array('type' => 'varchar', 'length' => 8, 'not null' => true, 'description' => 'address type ("email", "xmpp", "sms")'),
- 'claimed' => array('type' => 'datetime', 'description' => 'date this was claimed for queueing'),
- 'sent' => array('type' => 'datetime', 'description' => 'date this was sent for queueing'),
- 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('code'),
- 'foreign keys' => array(
- 'confirm_address_user_id_fkey' => array('user', array('user_id' => 'id')),
- ),
- );
- }
- static function getAddress($address, $addressType)
- {
- $ca = new Confirm_address();
- $ca->address = $address;
- $ca->address_type = $addressType;
- if ($ca->find(true)) {
- return $ca;
- }
- return null;
- }
- static function saveNew($user, $address, $addressType, $extra=null)
- {
- $ca = new Confirm_address();
- if (!empty($user)) {
- $ca->user_id = $user->id;
- }
- $ca->address = $address;
- $ca->address_type = $addressType;
- $ca->address_extra = $extra;
- $ca->code = common_confirmation_code(64);
- $ca->insert();
- return $ca;
- }
- }
|