123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115 |
- <?php
- defined('GNUSOCIAL') || die();
- class File_to_post extends Managed_DataObject
- {
-
-
- public $__table = 'file_to_post';
- public $file_id;
- public $post_id;
- public $modified;
-
-
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'file_id' => array('type' => 'int', 'not null' => true, 'description' => 'id of URL/file'),
- 'post_id' => array('type' => 'int', 'not null' => true, 'description' => 'id of the notice it belongs to'),
- 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('file_id', 'post_id'),
- 'foreign keys' => array(
- 'file_to_post_file_id_fkey' => array('file', array('file_id' => 'id')),
- 'file_to_post_post_id_fkey' => array('notice', array('post_id' => 'id')),
- ),
- 'indexes' => array(
- 'file_to_post_post_id_idx' => array('post_id'),
- ),
- );
- }
- public static function processNew(File $file, Notice $notice)
- {
- static $seen = array();
- $file_id = $file->getID();
- $notice_id = $notice->getID();
- if (!array_key_exists($notice_id, $seen)) {
- $seen[$notice_id] = array();
- }
- if (empty($seen[$notice_id]) || !in_array($file_id, $seen[$notice_id])) {
- try {
- $f2p = File_to_post::getByPK(array('post_id' => $notice_id,
- 'file_id' => $file_id));
- } catch (NoResultException $e) {
- $f2p = new File_to_post;
- $f2p->file_id = $file_id;
- $f2p->post_id = $notice_id;
- $f2p->insert();
-
- $file->blowCache();
- }
- $seen[$notice_id][] = $file_id;
- }
- }
- public static function getNoticeIDsByFile(File $file)
- {
- $f2p = new File_to_post();
- $f2p->selectAdd();
- $f2p->selectAdd('post_id');
- $f2p->file_id = $file->getID();
- $ids = array();
- if (!$f2p->find()) {
- throw new NoResultException($f2p);
- }
- return $f2p->fetchAll('post_id');
- }
- public function delete($useWhere = false)
- {
- try {
- $f = File::getByID($this->file_id);
- $f->blowCache();
- } catch (NoResultException $e) {
-
- }
- return parent::delete($useWhere);
- }
- }
|