summaryrefslogtreecommitdiff
path: root/app/Models/CategoryDAO.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/Models/CategoryDAO.php')
-rw-r--r--app/Models/CategoryDAO.php170
1 files changed, 85 insertions, 85 deletions
diff --git a/app/Models/CategoryDAO.php b/app/Models/CategoryDAO.php
index f11f87f47..27a558522 100644
--- a/app/Models/CategoryDAO.php
+++ b/app/Models/CategoryDAO.php
@@ -1,19 +1,19 @@
<?php
class FreshRSS_CategoryDAO extends Minz_ModelPdo {
- public function addCategory ($valuesTmp) {
- $sql = 'INSERT INTO `' . $this->prefix . 'category` (name) VALUES(?)';
- $stm = $this->bd->prepare ($sql);
+ public function addCategory($valuesTmp) {
+ $sql = 'INSERT INTO `' . $this->prefix . 'category`(name) VALUES(?)';
+ $stm = $this->bd->prepare($sql);
- $values = array (
+ $values = array(
substr($valuesTmp['name'], 0, 255),
);
- if ($stm && $stm->execute ($values)) {
+ if ($stm && $stm->execute($values)) {
return $this->bd->lastInsertId();
} else {
$info = $stm == null ? array(2 => 'syntax error') : $stm->errorInfo();
- Minz_Log::record('SQL error addCategory: ' . $info[2], Minz_Log::ERROR);
+ Minz_Log::error('SQL error addCategory: ' . $info[2] );
return false;
}
}
@@ -31,73 +31,73 @@ class FreshRSS_CategoryDAO extends Minz_ModelPdo {
return $cat->id();
}
- public function updateCategory ($id, $valuesTmp) {
+ public function updateCategory($id, $valuesTmp) {
$sql = 'UPDATE `' . $this->prefix . 'category` SET name=? WHERE id=?';
- $stm = $this->bd->prepare ($sql);
+ $stm = $this->bd->prepare($sql);
- $values = array (
+ $values = array(
$valuesTmp['name'],
$id
);
- if ($stm && $stm->execute ($values)) {
+ if ($stm && $stm->execute($values)) {
return $stm->rowCount();
} else {
$info = $stm == null ? array(2 => 'syntax error') : $stm->errorInfo();
- Minz_Log::record('SQL error updateCategory: ' . $info[2], Minz_Log::ERROR);
+ Minz_Log::error('SQL error updateCategory: ' . $info[2]);
return false;
}
}
- public function deleteCategory ($id) {
+ public function deleteCategory($id) {
$sql = 'DELETE FROM `' . $this->prefix . 'category` WHERE id=?';
- $stm = $this->bd->prepare ($sql);
+ $stm = $this->bd->prepare($sql);
- $values = array ($id);
+ $values = array($id);
- if ($stm && $stm->execute ($values)) {
+ if ($stm && $stm->execute($values)) {
return $stm->rowCount();
} else {
$info = $stm == null ? array(2 => 'syntax error') : $stm->errorInfo();
- Minz_Log::record('SQL error deleteCategory: ' . $info[2], Minz_Log::ERROR);
+ Minz_Log::error('SQL error deleteCategory: ' . $info[2]);
return false;
}
}
- public function searchById ($id) {
+ public function searchById($id) {
$sql = 'SELECT * FROM `' . $this->prefix . 'category` WHERE id=?';
- $stm = $this->bd->prepare ($sql);
+ $stm = $this->bd->prepare($sql);
- $values = array ($id);
+ $values = array($id);
- $stm->execute ($values);
- $res = $stm->fetchAll (PDO::FETCH_ASSOC);
- $cat = self::daoToCategory ($res);
+ $stm->execute($values);
+ $res = $stm->fetchAll(PDO::FETCH_ASSOC);
+ $cat = self::daoToCategory($res);
- if (isset ($cat[0])) {
+ if (isset($cat[0])) {
return $cat[0];
} else {
return null;
}
}
- public function searchByName ($name) {
+ public function searchByName($name) {
$sql = 'SELECT * FROM `' . $this->prefix . 'category` WHERE name=?';
- $stm = $this->bd->prepare ($sql);
+ $stm = $this->bd->prepare($sql);
- $values = array ($name);
+ $values = array($name);
- $stm->execute ($values);
- $res = $stm->fetchAll (PDO::FETCH_ASSOC);
- $cat = self::daoToCategory ($res);
+ $stm->execute($values);
+ $res = $stm->fetchAll(PDO::FETCH_ASSOC);
+ $cat = self::daoToCategory($res);
- if (isset ($cat[0])) {
+ if (isset($cat[0])) {
return $cat[0];
} else {
return null;
}
}
- public function listCategories ($prePopulateFeeds = true, $details = false) {
+ public function listCategories($prePopulateFeeds = true, $details = false) {
if ($prePopulateFeeds) {
$sql = 'SELECT c.id AS c_id, c.name AS c_name, '
. ($details ? 'f.* ' : 'f.id, f.name, f.url, f.website, f.priority, f.error, f.cache_nbEntries, f.cache_nbUnreads ')
@@ -105,80 +105,80 @@ class FreshRSS_CategoryDAO extends Minz_ModelPdo {
. 'LEFT OUTER JOIN `' . $this->prefix . 'feed` f ON f.category=c.id '
. 'GROUP BY f.id '
. 'ORDER BY c.name, f.name';
- $stm = $this->bd->prepare ($sql);
- $stm->execute ();
- return self::daoToCategoryPrepopulated ($stm->fetchAll (PDO::FETCH_ASSOC));
+ $stm = $this->bd->prepare($sql);
+ $stm->execute();
+ return self::daoToCategoryPrepopulated($stm->fetchAll(PDO::FETCH_ASSOC));
} else {
$sql = 'SELECT * FROM `' . $this->prefix . 'category` ORDER BY name';
- $stm = $this->bd->prepare ($sql);
- $stm->execute ();
- return self::daoToCategory ($stm->fetchAll (PDO::FETCH_ASSOC));
+ $stm = $this->bd->prepare($sql);
+ $stm->execute();
+ return self::daoToCategory($stm->fetchAll(PDO::FETCH_ASSOC));
}
}
- public function getDefault () {
+ public function getDefault() {
$sql = 'SELECT * FROM `' . $this->prefix . 'category` WHERE id=1';
- $stm = $this->bd->prepare ($sql);
+ $stm = $this->bd->prepare($sql);
- $stm->execute ();
- $res = $stm->fetchAll (PDO::FETCH_ASSOC);
- $cat = self::daoToCategory ($res);
+ $stm->execute();
+ $res = $stm->fetchAll(PDO::FETCH_ASSOC);
+ $cat = self::daoToCategory($res);
- if (isset ($cat[0])) {
+ if (isset($cat[0])) {
return $cat[0];
} else {
return false;
}
}
- public function checkDefault () {
- $def_cat = $this->searchById (1);
+ public function checkDefault() {
+ $def_cat = $this->searchById(1);
if ($def_cat == null) {
- $cat = new FreshRSS_Category (Minz_Translate::t ('default_category'));
- $cat->_id (1);
+ $cat = new FreshRSS_Category(_t('gen.short.default_category'));
+ $cat->_id(1);
- $values = array (
- 'id' => $cat->id (),
- 'name' => $cat->name (),
+ $values = array(
+ 'id' => $cat->id(),
+ 'name' => $cat->name(),
);
- $this->addCategory ($values);
+ $this->addCategory($values);
}
}
- public function count () {
+ public function count() {
$sql = 'SELECT COUNT(*) AS count FROM `' . $this->prefix . 'category`';
- $stm = $this->bd->prepare ($sql);
- $stm->execute ();
- $res = $stm->fetchAll (PDO::FETCH_ASSOC);
+ $stm = $this->bd->prepare($sql);
+ $stm->execute();
+ $res = $stm->fetchAll(PDO::FETCH_ASSOC);
return $res[0]['count'];
}
- public function countFeed ($id) {
+ public function countFeed($id) {
$sql = 'SELECT COUNT(*) AS count FROM `' . $this->prefix . 'feed` WHERE category=?';
- $stm = $this->bd->prepare ($sql);
- $values = array ($id);
- $stm->execute ($values);
- $res = $stm->fetchAll (PDO::FETCH_ASSOC);
+ $stm = $this->bd->prepare($sql);
+ $values = array($id);
+ $stm->execute($values);
+ $res = $stm->fetchAll(PDO::FETCH_ASSOC);
return $res[0]['count'];
}
- public function countNotRead ($id) {
+ public function countNotRead($id) {
$sql = 'SELECT COUNT(*) AS count FROM `' . $this->prefix . 'entry` e INNER JOIN `' . $this->prefix . 'feed` f ON e.id_feed=f.id WHERE category=? AND e.is_read=0';
- $stm = $this->bd->prepare ($sql);
- $values = array ($id);
- $stm->execute ($values);
- $res = $stm->fetchAll (PDO::FETCH_ASSOC);
+ $stm = $this->bd->prepare($sql);
+ $values = array($id);
+ $stm->execute($values);
+ $res = $stm->fetchAll(PDO::FETCH_ASSOC);
return $res[0]['count'];
}
public static function findFeed($categories, $feed_id) {
foreach ($categories as $category) {
- foreach ($category->feeds () as $feed) {
- if ($feed->id () === $feed_id) {
+ foreach ($category->feeds() as $feed) {
+ if ($feed->id() === $feed_id) {
return $feed;
}
}
@@ -189,8 +189,8 @@ class FreshRSS_CategoryDAO extends Minz_ModelPdo {
public static function CountUnreads($categories, $minPriority = 0) {
$n = 0;
foreach ($categories as $category) {
- foreach ($category->feeds () as $feed) {
- if ($feed->priority () >= $minPriority) {
+ foreach ($category->feeds() as $feed) {
+ if ($feed->priority() >= $minPriority) {
$n += $feed->nbNotRead();
}
}
@@ -198,11 +198,11 @@ class FreshRSS_CategoryDAO extends Minz_ModelPdo {
return $n;
}
- public static function daoToCategoryPrepopulated ($listDAO) {
- $list = array ();
+ public static function daoToCategoryPrepopulated($listDAO) {
+ $list = array();
- if (!is_array ($listDAO)) {
- $listDAO = array ($listDAO);
+ if (!is_array($listDAO)) {
+ $listDAO = array($listDAO);
}
$previousLine = null;
@@ -210,11 +210,11 @@ class FreshRSS_CategoryDAO extends Minz_ModelPdo {
foreach ($listDAO as $line) {
if ($previousLine['c_id'] != null && $line['c_id'] !== $previousLine['c_id']) {
// End of the current category, we add it to the $list
- $cat = new FreshRSS_Category (
+ $cat = new FreshRSS_Category(
$previousLine['c_name'],
- FreshRSS_FeedDAO::daoToFeed ($feedsDao, $previousLine['c_id'])
+ FreshRSS_FeedDAO::daoToFeed($feedsDao, $previousLine['c_id'])
);
- $cat->_id ($previousLine['c_id']);
+ $cat->_id($previousLine['c_id']);
$list[$previousLine['c_id']] = $cat;
$feedsDao = array(); //Prepare for next category
@@ -226,29 +226,29 @@ class FreshRSS_CategoryDAO extends Minz_ModelPdo {
// add the last category
if ($previousLine != null) {
- $cat = new FreshRSS_Category (
+ $cat = new FreshRSS_Category(
$previousLine['c_name'],
- FreshRSS_FeedDAO::daoToFeed ($feedsDao, $previousLine['c_id'])
+ FreshRSS_FeedDAO::daoToFeed($feedsDao, $previousLine['c_id'])
);
- $cat->_id ($previousLine['c_id']);
+ $cat->_id($previousLine['c_id']);
$list[$previousLine['c_id']] = $cat;
}
return $list;
}
- public static function daoToCategory ($listDAO) {
- $list = array ();
+ public static function daoToCategory($listDAO) {
+ $list = array();
- if (!is_array ($listDAO)) {
- $listDAO = array ($listDAO);
+ if (!is_array($listDAO)) {
+ $listDAO = array($listDAO);
}
foreach ($listDAO as $key => $dao) {
- $cat = new FreshRSS_Category (
+ $cat = new FreshRSS_Category(
$dao['name']
);
- $cat->_id ($dao['id']);
+ $cat->_id($dao['id']);
$list[$key] = $cat;
}
generated by cgit v1.2.3 (git 2.39.1) at 2026-02-10 14:13:42 +0000