feedController.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426
  1. <?php
  2. class FreshRSS_feed_Controller extends Minz_ActionController {
  3. public function firstAction () {
  4. $token = $this->view->conf->token();
  5. $token_param = Minz_Request::param ('token', '');
  6. $token_is_ok = ($token != '' && $token == $token_param);
  7. $action = Minz_Request::actionName ();
  8. if (login_is_conf ($this->view->conf) &&
  9. !is_logged () &&
  10. !($token_is_ok && $action == 'actualize')) {
  11. Minz_Error::error (
  12. 403,
  13. array ('error' => array (Minz_Translate::t ('access_denied')))
  14. );
  15. }
  16. $this->catDAO = new FreshRSS_CategoryDAO ();
  17. $this->catDAO->checkDefault ();
  18. }
  19. private static function entryDateComparer($e1, $e2) {
  20. $d1 = $e1->date(true);
  21. $d2 = $e2->date(true);
  22. if ($d1 === $d2) {
  23. return 0;
  24. }
  25. return ($d1 < $d2) ? -1 : 1;
  26. }
  27. public function addAction () {
  28. @set_time_limit(300);
  29. if (Minz_Request::isPost ()) {
  30. $url = Minz_Request::param ('url_rss');
  31. $cat = Minz_Request::param ('category', false);
  32. if ($cat === false) {
  33. $def_cat = $this->catDAO->getDefault ();
  34. $cat = $def_cat->id ();
  35. }
  36. $user = Minz_Request::param ('username');
  37. $pass = Minz_Request::param ('password');
  38. $params = array ();
  39. $transactionStarted = false;
  40. try {
  41. $feed = new FreshRSS_Feed ($url);
  42. $feed->_category ($cat);
  43. $httpAuth = '';
  44. if ($user != '' || $pass != '') {
  45. $httpAuth = $user . ':' . $pass;
  46. }
  47. $feed->_httpAuth ($httpAuth);
  48. $feed->load ();
  49. $feedDAO = new FreshRSS_FeedDAO ();
  50. $values = array (
  51. 'url' => $feed->url (),
  52. 'category' => $feed->category (),
  53. 'name' => $feed->name (),
  54. 'website' => $feed->website (),
  55. 'description' => $feed->description (),
  56. 'lastUpdate' => time (),
  57. 'httpAuth' => $feed->httpAuth (),
  58. );
  59. if ($feedDAO->searchByUrl ($values['url'])) {
  60. // on est déjà abonné à ce flux
  61. $notif = array (
  62. 'type' => 'bad',
  63. 'content' => Minz_Translate::t ('already_subscribed', $feed->name ())
  64. );
  65. Minz_Session::_param ('notification', $notif);
  66. } else {
  67. $id = $feedDAO->addFeed ($values);
  68. if (!$id) {
  69. // problème au niveau de la base de données
  70. $notif = array (
  71. 'type' => 'bad',
  72. 'content' => Minz_Translate::t ('feed_not_added', $feed->name ())
  73. );
  74. Minz_Session::_param ('notification', $notif);
  75. } else {
  76. $feed->_id ($id);
  77. $feed->faviconPrepare();
  78. $is_read = $this->view->conf->markUponReception() === 'yes' ? 1 : 0;
  79. $entryDAO = new FreshRSS_EntryDAO ();
  80. $entries = $feed->entries ();
  81. usort($entries, 'self::entryDateComparer');
  82. // on calcule la date des articles les plus anciens qu'on accepte
  83. $nb_month_old = $this->view->conf->oldEntries ();
  84. $date_min = time () - (3600 * 24 * 30 * $nb_month_old);
  85. $transactionStarted = true;
  86. $feedDAO->beginTransaction ();
  87. // on ajoute les articles en masse sans vérification
  88. foreach ($entries as $entry) {
  89. $values = $entry->toArray ();
  90. $values['id_feed'] = $feed->id ();
  91. $values['id'] = min(time(), $entry->date (true)) . uSecString();
  92. $values['is_read'] = $is_read;
  93. $entryDAO->addEntry ($values);
  94. }
  95. $feedDAO->updateLastUpdate ($feed->id ());
  96. $feedDAO->commit ();
  97. $transactionStarted = false;
  98. // ok, ajout terminé
  99. $notif = array (
  100. 'type' => 'good',
  101. 'content' => Minz_Translate::t ('feed_added', $feed->name ())
  102. );
  103. Minz_Session::_param ('notification', $notif);
  104. // permet de rediriger vers la page de conf du flux
  105. $params['id'] = $feed->id ();
  106. }
  107. }
  108. } catch (FreshRSS_BadUrl_Exception $e) {
  109. Minz_Log::record ($e->getMessage (), Minz_Log::WARNING);
  110. $notif = array (
  111. 'type' => 'bad',
  112. 'content' => Minz_Translate::t ('invalid_url', $url)
  113. );
  114. Minz_Session::_param ('notification', $notif);
  115. } catch (FreshRSS_Feed_Exception $e) {
  116. Minz_Log::record ($e->getMessage (), Minz_Log::WARNING);
  117. $notif = array (
  118. 'type' => 'bad',
  119. 'content' => Minz_Translate::t ('internal_problem_feed')
  120. );
  121. Minz_Session::_param ('notification', $notif);
  122. } catch (Minz_FileNotExistException $e) {
  123. // Répertoire de cache n'existe pas
  124. Minz_Log::record ($e->getMessage (), Minz_Log::ERROR);
  125. $notif = array (
  126. 'type' => 'bad',
  127. 'content' => Minz_Translate::t ('internal_problem_feed')
  128. );
  129. Minz_Session::_param ('notification', $notif);
  130. }
  131. if ($transactionStarted) {
  132. $feedDAO->rollBack ();
  133. }
  134. Minz_Request::forward (array ('c' => 'configure', 'a' => 'feed', 'params' => $params), true);
  135. }
  136. }
  137. public function truncateAction () {
  138. if (Minz_Request::isPost ()) {
  139. $id = Minz_Request::param ('id');
  140. $feedDAO = new FreshRSS_FeedDAO ();
  141. $n = $feedDAO->truncate($id);
  142. $notif = array(
  143. 'type' => $n === false ? 'bad' : 'good',
  144. 'content' => Minz_Translate::t ('n_entries_deleted', $n)
  145. );
  146. Minz_Session::_param ('notification', $notif);
  147. invalidateHttpCache();
  148. Minz_Request::forward (array ('c' => 'configure', 'a' => 'feed', 'params' => array('id' => $id)), true);
  149. }
  150. }
  151. public function actualizeAction () {
  152. @set_time_limit(300);
  153. $feedDAO = new FreshRSS_FeedDAO ();
  154. $entryDAO = new FreshRSS_EntryDAO ();
  155. $id = Minz_Request::param ('id');
  156. $force = Minz_Request::param ('force', false);
  157. // on créé la liste des flux à mettre à actualiser
  158. // si on veut mettre un flux à jour spécifiquement, on le met
  159. // dans la liste, mais seul (permet d'automatiser le traitement)
  160. $feeds = array ();
  161. if ($id) {
  162. $feed = $feedDAO->searchById ($id);
  163. if ($feed) {
  164. $feeds = array ($feed);
  165. }
  166. } else {
  167. $feeds = $feedDAO->listFeedsOrderUpdate ();
  168. }
  169. // on calcule la date des articles les plus anciens qu'on accepte
  170. $nb_month_old = $this->view->conf->oldEntries ();
  171. $date_min = time () - (3600 * 24 * 30 * $nb_month_old);
  172. $i = 0;
  173. $flux_update = 0;
  174. foreach ($feeds as $feed) {
  175. try {
  176. $feed->load ();
  177. $feed->faviconPrepare();
  178. $entries = $feed->entries ();
  179. usort($entries, 'self::entryDateComparer');
  180. $is_read = $this->view->conf->markUponReception() === 'yes' ? 1 : 0;
  181. //For this feed, check last n entry GUIDs already in database
  182. $existingGuids = array_fill_keys ($entryDAO->listLastGuidsByFeed ($feed->id (), count($entries) + 10), 1);
  183. // On ne vérifie pas strictement que l'article n'est pas déjà en BDD
  184. // La BDD refusera l'ajout car (id_feed, guid) doit être unique
  185. $feedDAO->beginTransaction ();
  186. foreach ($entries as $entry) {
  187. if ((!isset ($existingGuids[$entry->guid ()])) &&
  188. ($entry->date (true) >= $date_min)) {
  189. $values = $entry->toArray ();
  190. //Use declared date at first import, otherwise use discovery date
  191. $values['id'] = empty($existingGuids) ? min(time(), $entry->date (true)) . uSecString() : uTimeString();
  192. $values['is_read'] = $is_read;
  193. $entryDAO->addEntry ($values);
  194. }
  195. }
  196. if (($feed->keepHistory() >= 0) && (rand(0, 30) === 1)) {
  197. $nb = $feedDAO->cleanOldEntries ($feed->id (), $date_min, max($feed->keepHistory(), count($entries) + 10));
  198. if ($nb > 0) {
  199. Minz_Log::record ($nb . ' old entries cleaned in feed ' . $feed->id (), Minz_Log::DEBUG);
  200. }
  201. }
  202. // on indique que le flux vient d'être mis à jour en BDD
  203. $feedDAO->updateLastUpdate ($feed->id ());
  204. $feedDAO->commit ();
  205. $flux_update++;
  206. } catch (FreshRSS_Feed_Exception $e) {
  207. Minz_Log::record ($e->getMessage (), Minz_Log::NOTICE);
  208. $feedDAO->updateLastUpdate ($feed->id (), 1);
  209. }
  210. // On arrête à 10 flux pour ne pas surcharger le serveur
  211. // sauf si le paramètre $force est à vrai
  212. $i++;
  213. if ($i >= 10 && !$force) {
  214. break;
  215. }
  216. }
  217. $url = array ();
  218. if ($flux_update === 1) {
  219. // on a mis un seul flux à jour
  220. $notif = array (
  221. 'type' => 'good',
  222. 'content' => Minz_Translate::t ('feed_actualized', $feed->name ())
  223. );
  224. } elseif ($flux_update > 1) {
  225. // plusieurs flux on été mis à jour
  226. $notif = array (
  227. 'type' => 'good',
  228. 'content' => Minz_Translate::t ('n_feeds_actualized', $flux_update)
  229. );
  230. } else {
  231. // aucun flux n'a été mis à jour, oups
  232. $notif = array (
  233. 'type' => 'bad',
  234. 'content' => Minz_Translate::t ('no_feed_actualized')
  235. );
  236. }
  237. if ($i === 1) {
  238. // Si on a voulu mettre à jour qu'un flux
  239. // on filtre l'affichage par ce flux
  240. $feed = reset ($feeds);
  241. $url['params'] = array ('get' => 'f_' . $feed->id ());
  242. }
  243. if (Minz_Request::param ('ajax', 0) === 0) {
  244. Minz_Session::_param ('notification', $notif);
  245. Minz_Request::forward ($url, true);
  246. } else {
  247. // Une requête Ajax met un seul flux à jour.
  248. // Comme en principe plusieurs requêtes ont lieu,
  249. // on indique que "plusieurs flux ont été mis à jour".
  250. // Cela permet d'avoir une notification plus proche du
  251. // ressenti utilisateur
  252. $notif = array (
  253. 'type' => 'good',
  254. 'content' => Minz_Translate::t ('feeds_actualized')
  255. );
  256. Minz_Session::_param ('notification', $notif);
  257. // et on désactive le layout car ne sert à rien
  258. $this->view->_useLayout (false);
  259. }
  260. }
  261. public function massiveImportAction () {
  262. @set_time_limit(300);
  263. $entryDAO = new FreshRSS_EntryDAO ();
  264. $feedDAO = new FreshRSS_FeedDAO ();
  265. $categories = Minz_Request::param ('categories', array (), true);
  266. $feeds = Minz_Request::param ('feeds', array (), true);
  267. // on ajoute les catégories en masse dans une fonction à part
  268. $this->addCategories ($categories);
  269. // on calcule la date des articles les plus anciens qu'on accepte
  270. $nb_month_old = $this->view->conf->oldEntries ();
  271. $date_min = time () - (3600 * 24 * 30 * $nb_month_old);
  272. // la variable $error permet de savoir si une erreur est survenue
  273. // Le but est de ne pas arrêter l'import même en cas d'erreur
  274. // L'utilisateur sera mis au courant s'il y a eu des erreurs, mais
  275. // ne connaîtra pas les détails. Ceux-ci seront toutefois logguées
  276. $error = false;
  277. $i = 0;
  278. foreach ($feeds as $feed) {
  279. try {
  280. $values = array (
  281. 'id' => $feed->id (),
  282. 'url' => $feed->url (),
  283. 'category' => $feed->category (),
  284. 'name' => $feed->name (),
  285. 'website' => $feed->website (),
  286. 'description' => $feed->description (),
  287. 'lastUpdate' => 0,
  288. 'httpAuth' => $feed->httpAuth ()
  289. );
  290. // ajout du flux que s'il n'est pas déjà en BDD
  291. if (!$feedDAO->searchByUrl ($values['url'])) {
  292. $id = $feedDAO->addFeed ($values);
  293. if ($id) {
  294. $feed->_id ($id);
  295. $feed->faviconPrepare();
  296. } else {
  297. $error = true;
  298. }
  299. }
  300. } catch (FreshRSS_Feed_Exception $e) {
  301. $error = true;
  302. Minz_Log::record ($e->getMessage (), Minz_Log::WARNING);
  303. }
  304. }
  305. if ($error) {
  306. $res = Minz_Translate::t ('feeds_imported_with_errors');
  307. } else {
  308. $res = Minz_Translate::t ('feeds_imported');
  309. }
  310. $notif = array (
  311. 'type' => 'good',
  312. 'content' => $res
  313. );
  314. Minz_Session::_param ('notification', $notif);
  315. Minz_Session::_param ('actualize_feeds', true);
  316. // et on redirige vers la page d'accueil
  317. Minz_Request::forward (array (
  318. 'c' => 'index',
  319. 'a' => 'index'
  320. ), true);
  321. }
  322. public function deleteAction () {
  323. if (Minz_Request::isPost ()) {
  324. $type = Minz_Request::param ('type', 'feed');
  325. $id = Minz_Request::param ('id');
  326. $feedDAO = new FreshRSS_FeedDAO ();
  327. if ($type == 'category') {
  328. if ($feedDAO->deleteFeedByCategory ($id)) {
  329. $notif = array (
  330. 'type' => 'good',
  331. 'content' => Minz_Translate::t ('category_emptied')
  332. );
  333. //TODO: Delete old favicons
  334. } else {
  335. $notif = array (
  336. 'type' => 'bad',
  337. 'content' => Minz_Translate::t ('error_occured')
  338. );
  339. }
  340. } else {
  341. if ($feedDAO->deleteFeed ($id)) {
  342. $notif = array (
  343. 'type' => 'good',
  344. 'content' => Minz_Translate::t ('feed_deleted')
  345. );
  346. FreshRSS_Feed::faviconDelete($id);
  347. } else {
  348. $notif = array (
  349. 'type' => 'bad',
  350. 'content' => Minz_Translate::t ('error_occured')
  351. );
  352. }
  353. }
  354. Minz_Session::_param ('notification', $notif);
  355. if ($type == 'category') {
  356. Minz_Request::forward (array ('c' => 'configure', 'a' => 'categorize'), true);
  357. } else {
  358. Minz_Request::forward (array ('c' => 'configure', 'a' => 'feed'), true);
  359. }
  360. }
  361. }
  362. private function addCategories ($categories) {
  363. $catDAO = new FreshRSS_CategoryDAO ();
  364. foreach ($categories as $cat) {
  365. if (!$catDAO->searchByName ($cat->name ())) {
  366. $values = array (
  367. 'id' => $cat->id (),
  368. 'name' => $cat->name (),
  369. 'color' => $cat->color ()
  370. );
  371. $catDAO->addCategory ($values);
  372. }
  373. }
  374. }
  375. }