classes/labels.php

   1 <?php
   2 class Labels
   3 {
   4         static function label_to_feed_id($label) {
   5                 return LABEL_BASE_INDEX - 1 - abs($label);
   6         }
   7
   8         static function feed_to_label_id($feed) {
   9                 return LABEL_BASE_INDEX - 1 + abs($feed);
  10         }
  11
  12         static function find_id($label, $owner_uid) {
  13                 $pdo = Db::pdo();
  14
  15                 $sth = $pdo->prepare("SELECT id FROM ttrss_labels2 WHERE caption = ?
  16                                 AND owner_uid = ? LIMIT 1");
  17                 $sth->execute([$label, $owner_uid]);
  18
  19                 if ($row = $sth->fetch()) {
  20                         return $row['id'];
  21                 } else {
  22                         return 0;
  23                 }
  24         }
  25
  26         static function find_caption($label, $owner_uid) {
  27                 $pdo = Db::pdo();
  28
  29                 $sth = $pdo->prepare("SELECT caption FROM ttrss_labels2 WHERE id = ?
  30                                 AND owner_uid = ? LIMIT 1");
  31                 $sth->execute([$label, $owner_uid]);
  32
  33                 if ($row = $sth->fetch()) {
  34                         return $row['caption'];
  35                 } else {
  36                         return "";
  37                 }
  38         }
  39
  40         static function get_all_labels($owner_uid)      {
  41                 $rv = array();
  42
  43                 $pdo = Db::pdo();
  44
  45                 $sth = $pdo->prepare("SELECT id, fg_color, bg_color, caption FROM ttrss_labels2
  46                         WHERE owner_uid = ? ORDER BY caption");
  47                 $sth->execute([$owner_uid]);
  48
  49                 while ($line = $sth->fetch()) {
  50                         array_push($rv, $line);
  51                 }
  52
  53                 return $rv;
  54         }
  55
  56         static function update_cache($owner_uid, $id, $labels = false, $force = false) {
  57                 $pdo = Db::pdo();
  58
  59                 if ($force)
  60                         Labels::clear_cache($id);
  61
  62                 if (!$labels)
  63                         $labels = Article::get_article_labels($id);
  64
  65                 $labels = json_encode($labels);
  66
  67                 $sth = $pdo->prepare("UPDATE ttrss_user_entries SET
  68                         label_cache = ? WHERE ref_id = ? AND owner_uid = ?");
  69                 $sth->execute([$labels, $id, $owner_uid]);
  70
  71         }
  72
  73         static function clear_cache($id)        {
  74
  75                 $pdo = Db::pdo();
  76
  77                 $sth = $pdo->prepare("UPDATE ttrss_user_entries SET
  78                         label_cache = '' WHERE ref_id = ?");
  79                 $sth->execute([$id]);
  80
  81         }
  82
  83         static function remove_article($id, $label, $owner_uid) {
  84
  85                 $label_id = Labels::find_id($label, $owner_uid);
  86
  87                 if (!$label_id) return;
  88
  89                 $pdo = Db::pdo();
  90
  91                 $sth = $pdo->prepare("DELETE FROM ttrss_user_labels2
  92                         WHERE
  93                                 label_id = ? AND
  94                                 article_id = ?");
  95
  96                 $sth->execute([$label_id, $id]);
  97
  98                 Labels::clear_cache($id);
  99         }
 100
 101         static function add_article($id, $label, $owner_uid)    {
 102
 103                 $label_id = Labels::find_id($label, $owner_uid);
 104
 105                 if (!$label_id) return;
 106
 107                 $pdo = Db::pdo();
 108
 109                 $sth = $pdo->prepare("SELECT
 110                                 article_id FROM ttrss_labels2, ttrss_user_labels2
 111                         WHERE
 112                                 label_id = id AND
 113                                 label_id = ? AND
 114                                 article_id = ? AND owner_uid = ?
 115                         LIMIT 1");
 116
 117                 $sth->execute([$label_id, $id, $owner_uid]);
 118
 119                 if (!$sth->fetch()) {
 120                         $sth = $pdo->prepare("INSERT INTO ttrss_user_labels2
 121                                 (label_id, article_id) VALUES (?, ?)");
 122
 123                         $sth->execute([$label_id, $id]);
 124                 }
 125
 126                 Labels::clear_cache($id);
 127
 128         }
 129
 130         static function remove($id, $owner_uid) {
 131                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
 132
 133                 $pdo = Db::pdo();
 134                 $tr_in_progress = false;
 135
 136                 try {
 137                         $pdo->beginTransaction();
 138                 } catch (Exception $e) {
 139                         $tr_in_progress = true;
 140                 }
 141
 142                 $sth = $pdo->prepare("SELECT caption FROM ttrss_labels2
 143                         WHERE id = ?");
 144                 $sth->execute([$id]);
 145
 146                 $row = $sth->fetch();
 147                 $caption = $row['caption'];
 148
 149                 $sth = $pdo->prepare("DELETE FROM ttrss_labels2 WHERE id = ?
 150                         AND owner_uid = ?");
 151                 $sth->execute([$id, $owner_uid]);
 152
 153                 if ($sth->rowCount() != 0 && $caption) {
 154
 155                         /* Remove access key for the label */
 156
 157                         $ext_id = LABEL_BASE_INDEX - 1 - $id;
 158
 159                         $sth = $pdo->prepare("DELETE FROM ttrss_access_keys WHERE
 160                                 feed_id = ? AND owner_uid = ?");
 161                         $sth->execute([$ext_id, $owner_uid]);
 162
 163                         /* Remove cached data */
 164
 165                         $sth = $pdo->prepare("UPDATE ttrss_user_entries SET label_cache = ''
 166                                 WHERE label_cache LIKE ? AND owner_uid = ?");
 167                         $sth->execute(["%$caption%", $owner_uid]);
 168
 169                 }
 170
 171                 if (!$tr_in_progress) $pdo->commit();
 172         }
 173
 174         static function create($caption, $fg_color = '', $bg_color = '', $owner_uid = false)    {
 175
 176                 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
 177
 178                 $pdo = Db::pdo();
 179
 180                 $tr_in_progress = false;
 181
 182                 try {
 183                         $pdo->beginTransaction();
 184                 } catch (Exception $e) {
 185                         $tr_in_progress = true;
 186                 }
 187
 188                 $sth = $pdo->prepare("SELECT id FROM ttrss_labels2
 189                         WHERE caption = ? AND owner_uid = ?");
 190                 $sth->execute([$caption, $owner_uid]);
 191
 192                 if (!$sth->fetch()) {
 193                         $sth = $pdo->prepare("INSERT INTO ttrss_labels2
 194                                 (caption,owner_uid,fg_color,bg_color) VALUES (?, ?, ?, ?)");
 195
 196                         $sth->execute([$caption, $owner_uid, $fg_color, $bg_color]);
 197
 198                         $result = $sth->rowCount();
 199                 }
 200
 201                 if (!$tr_in_progress) $pdo->commit();
 202
 203                 return $result;
 204         }
 205 }