1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 |
- <?php
- defined('GNUSOCIAL') || die();
- class GNUsocialProfileExtensionResponse extends Managed_DataObject
- {
- public $__table = 'gnusocialprofileextensionresponse';
- public $id;
- public $extension_id;
- public $profile_id;
- public $value;
- public $created;
- public $modified;
- public static function schemaDef(): array
- {
- return [
- 'fields' => [
- 'id' => ['type' => 'serial', 'not null' => true, 'description' => 'Unique ID for extension response'],
- 'extension_id' => ['type' => 'int', 'not null' => true, 'description' => 'The extension field ID'],
- 'profile_id' => ['type' => 'int', 'not null' => true, 'description' => 'Profile id that made the response'],
- 'value' => ['type' => 'text', 'not null' => true, 'description' => 'response entry'],
- 'created' => ['type' => 'datetime', 'description' => 'date this record was created'],
- 'modified' => ['type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'],
- ],
- 'primary key' => ['id'],
-
- 'foreign keys' => [
- 'gnusocialprofileextensionresponse_profile_id_fkey' => ['profile', ['profile_id' => 'id']],
- 'gnusocialprofileextensionresponse_extension_id_fkey' => ['gnusocialprofileextensionfield', ['extension_id' => 'id']],
- ],
- 'indexes' => [
- 'gnusocialprofileextensionresponse_profile_id_idx' => ['profile_id'],
- 'gnusocialprofileextensionresponse_extension_id_idx' => ['extension_id'],
- ],
- ];
- }
- public static function newResponse($extension_id, $profile_id, $value): GNUsocialProfileExtensionResponse
- {
- $response = new GNUsocialProfileExtensionResponse();
- $response->extension_id = $extension_id;
- $response->profile_id = $profile_id;
- $response->value = $value;
- $response->id = $response->insert();
- if (!$response->id) {
- common_log_db_error($response, 'INSERT', __FILE__);
- throw new ServerException(_m('Error creating new response.'));
- }
- return $response;
- }
- public static function findResponsesByProfile($id): array
- {
- $extf = 'gnusocialprofileextensionfield';
- $extr = 'gnusocialprofileextensionresponse';
- $sql = "SELECT $extr.*, $extf.title, $extf.description, $extf.type, $extf.systemname FROM $extr JOIN $extf ON $extr.extension_id=$extf.id WHERE $extr.profile_id = $id";
- $response = new GNUsocialProfileExtensionResponse();
- $response->query($sql);
- $responses = [];
- while ($response->fetch()) {
- $responses[] = clone($response);
- }
- return $responses;
- }
- }
|