inc/poche/Poche.class.php

   1 <?php
   2 /**
   3  * poche, a read it later open source system
   4  *
   5  * @category   poche
   6  * @author     Nicolas Lœuillet <support@inthepoche.com>
   7  * @copyright  2013
   8  * @license    http://www.wtfpl.net/ see COPYING file
   9  */
  10
  11 class Poche
  12 {
  13     public $user;
  14     public $store;
  15     public $tpl;
  16     public $messages;
  17     public $pagination;
  18
  19     function __construct()
  20     {
  21         $this->initTpl();
  22         if (!$this->checkBeforeInstall()) {
  23             exit;
  24         }
  25         $this->store = new Database();
  26         $this->init();
  27         $this->messages = new Messages();
  28
  29         # installation
  30         if(!$this->store->isInstalled())
  31         {
  32             $this->install();
  33         }
  34     }
  35
  36     /**
  37      * all checks before installation.
  38      * @return boolean
  39      */
  40     private function checkBeforeInstall()
  41     {
  42         $msg = '';
  43         $allIsGood = TRUE;
  44
  45         if (!is_writable(CACHE)) {
  46             Tools::logm('you don\'t have write access on cache directory');
  47             die('You don\'t have write access on cache directory.');
  48         }
  49         else if (file_exists('./install/update.php') && !DEBUG_POCHE) {
  50             $msg = '<h1>setup</h1><p><strong>It\'s your first time here?</strong> Please copy /install/poche.sqlite in db folder. Then, delete install folder.<br /><strong>If you have already installed poche</strong>, an update is needed <a href="install/update.php">by clicking here</a>.</p>';
  51             $allIsGood = FALSE;
  52         }
  53         else if (file_exists('./install') && !DEBUG_POCHE) {
  54             $msg = '<h1>setup</h1><p><strong>If you want to update your poche</strong>, you just have to delete /install folder. <br /><strong>To install your poche with sqlite</strong>, copy /install/poche.sqlite in /db and delete the folder /install. you have to delete the /install folder before using poche.</p>';
  55             $allIsGood = FALSE;
  56         }
  57         else if (STORAGE == 'sqlite' && !is_writable(STORAGE_SQLITE)) {
  58             Tools::logm('you don\'t have write access on sqlite file');
  59             $msg = '<h1>error</h1><p>You don\'t have write access on sqlite file.</p>';
  60             $allIsGood = FALSE;
  61         }
  62
  63         if (!$allIsGood) {
  64             echo $this->tpl->render('error.twig', array(
  65                 'msg' => $msg
  66             ));
  67         }
  68
  69         return $allIsGood;
  70     }
  71
  72     private function initTpl()
  73     {
  74         # template engine
  75         $loader = new Twig_Loader_Filesystem(TPL);
  76         if (DEBUG_POCHE) {
  77             $twig_params = array();
  78         }
  79         else {
  80             $twig_params = array('cache' => CACHE);
  81         }
  82         $this->tpl = new Twig_Environment($loader, $twig_params);
  83         $this->tpl->addExtension(new Twig_Extensions_Extension_I18n());
  84         # filter to display domain name of an url
  85         $filter = new Twig_SimpleFilter('getDomain', 'Tools::getDomain');
  86         $this->tpl->addFilter($filter);
  87
  88         # filter for reading time
  89         $filter = new Twig_SimpleFilter('getReadingTime', 'Tools::getReadingTime');
  90         $this->tpl->addFilter($filter);
  91     }
  92
  93     private function init()
  94     {
  95         Tools::initPhp();
  96         Session::init();
  97
  98         if (isset($_SESSION['poche_user']) && $_SESSION['poche_user'] != array()) {
  99             $this->user = $_SESSION['poche_user'];
 100         }
 101         else {
 102             # fake user, just for install & login screens
 103             $this->user = new User();
 104             $this->user->setConfig($this->getDefaultConfig());
 105         }
 106
 107         # l10n
 108         $language = $this->user->getConfigValue('language');
 109         putenv('LC_ALL=' . $language);
 110         setlocale(LC_ALL, $language);
 111         bindtextdomain($language, LOCALE);
 112         textdomain($language);
 113
 114         # Pagination
 115         $this->pagination = new Paginator($this->user->getConfigValue('pager'), 'p');
 116     }
 117
 118     private function install()
 119     {
 120         Tools::logm('poche still not installed');
 121         echo $this->tpl->render('install.twig', array(
 122             'token' => Session::getToken()
 123         ));
 124         if (isset($_GET['install'])) {
 125             if (($_POST['password'] == $_POST['password_repeat'])
 126                 && $_POST['password'] != "" && $_POST['login'] != "") {
 127                 # let's rock, install poche baby !
 128                 if ($this->store->install($_POST['login'], Tools::encodeString($_POST['password'] . $_POST['login'])))
 129                 {
 130                     Session::logout();
 131                     Tools::logm('poche is now installed');
 132                     Tools::redirect();
 133                 }
 134             }
 135             else {
 136                 Tools::logm('error during installation');
 137                 Tools::redirect();
 138             }
 139         }
 140         exit();
 141     }
 142
 143     public function getDefaultConfig()
 144     {
 145         return array(
 146             'pager' => PAGINATION,
 147             'language' => LANG,
 148             );
 149     }
 150
 151     /**
 152      * Call action (mark as fav, archive, delete, etc.)
 153      */
 154     public function action($action, Url $url, $id = 0, $import = FALSE)
 155     {
 156         switch ($action)
 157         {
 158             case 'add':
 159                 $content = $url->extract();
 160
 161                 if ($this->store->add($url->getUrl(), $content['title'], $content['body'], $this->user->getId())) {
 162                     Tools::logm('add link ' . $url->getUrl());
 163                     $sequence = '';
 164                     if (STORAGE == 'postgres') {
 165                         $sequence = 'entries_id_seq';
 166                     }
 167                     $last_id = $this->store->getLastId($sequence);
 168                     if (DOWNLOAD_PICTURES) {
 169                         $content = filtre_picture($content['body'], $url->getUrl(), $last_id);
 170                         Tools::logm('updating content article');
 171                         $this->store->updateContent($last_id, $content, $this->user->getId());
 172                     }
 173                     if (!$import) {
 174                         $this->messages->add('s', _('the link has been added successfully'));
 175                     }
 176                 }
 177                 else {
 178                     if (!$import) {
 179                         $this->messages->add('e', _('error during insertion : the link wasn\'t added'));
 180                         Tools::logm('error during insertion : the link wasn\'t added ' . $url->getUrl());
 181                     }
 182                 }
 183
 184                 if (!$import) {
 185                     Tools::redirect();
 186                 }
 187                 break;
 188             case 'delete':
 189                 $msg = 'delete link #' . $id;
 190                 if ($this->store->deleteById($id, $this->user->getId())) {
 191                     if (DOWNLOAD_PICTURES) {
 192                         remove_directory(ABS_PATH . $id);
 193                     }
 194                     $this->messages->add('s', _('the link has been deleted successfully'));
 195                 }
 196                 else {
 197                     $this->messages->add('e', _('the link wasn\'t deleted'));
 198                     $msg = 'error : can\'t delete link #' . $id;
 199                 }
 200                 Tools::logm($msg);
 201                 Tools::redirect('?');
 202                 break;
 203             case 'toggle_fav' :
 204                 $this->store->favoriteById($id, $this->user->getId());
 205                 Tools::logm('mark as favorite link #' . $id);
 206                 if (!$import) {
 207                     Tools::redirect();
 208                 }
 209                 break;
 210             case 'toggle_archive' :
 211                 $this->store->archiveById($id, $this->user->getId());
 212                 Tools::logm('archive link #' . $id);
 213                 if (!$import) {
 214                     Tools::redirect();
 215                 }
 216                 break;
 217             default:
 218                 break;
 219         }
 220     }
 221
 222     function displayView($view, $id = 0)
 223     {
 224         $tpl_vars = array();
 225
 226         switch ($view)
 227         {
 228             case 'config':
 229                 $dev = $this->getPocheVersion('dev');
 230                 $prod = $this->getPocheVersion('prod');
 231                 $compare_dev = version_compare(POCHE_VERSION, $dev);
 232                 $compare_prod = version_compare(POCHE_VERSION, $prod);
 233                 $tpl_vars = array(
 234                     'dev' => $dev,
 235                     'prod' => $prod,
 236                     'compare_dev' => $compare_dev,
 237                     'compare_prod' => $compare_prod,
 238                 );
 239                 Tools::logm('config view');
 240                 break;
 241             case 'view':
 242                 $entry = $this->store->retrieveOneById($id, $this->user->getId());
 243                 if ($entry != NULL) {
 244                     Tools::logm('view link #' . $id);
 245                     $content = $entry['content'];
 246                     if (function_exists('tidy_parse_string')) {
 247                         $tidy = tidy_parse_string($content, array('indent'=>true, 'show-body-only' => true), 'UTF8');
 248                         $tidy->cleanRepair();
 249                         $content = $tidy->value;
 250
 251                         // flattr checking
 252                         $flattr = new FlattrItem();
 253                         $flattr->checkitem($entry['url']);
 254
 255                         $tpl_vars = array(
 256                         'entry' => $entry,
 257                         'content' => $content,
 258                         'flattr' => $flattr
 259                         );
 260                     }
 261                 }
 262                 else {
 263                     Tools::logm('error in view call : entry is null');
 264                 }
 265                 break;
 266             default : // home, favorites and archive views
 267                 $entries = $this->store->getEntriesByView($view, $this->user->getId());
 268                 $tpl_vars = array(
 269                     'entries' => '',
 270                     'page_links' => '',
 271                 );
 272                 if (count($entries) > 0) {
 273                     $this->pagination->set_total(count($entries));
 274                     $page_links = $this->pagination->page_links('?view=' . $view . '&sort=' . $_SESSION['sort'] . '&');
 275                     $datas = $this->store->getEntriesByView($view, $this->user->getId(), $this->pagination->get_limit());
 276                     $tpl_vars['entries'] = $datas;
 277                     $tpl_vars['page_links'] = $page_links;
 278                 }
 279                 Tools::logm('display ' . $view . ' view');
 280                 break;
 281         }
 282
 283         return $tpl_vars;
 284     }
 285
 286     /**
 287      * update the password of the current user.
 288      * if MODE_DEMO is TRUE, the password can't be updated.
 289      * @todo add the return value
 290      * @todo set the new password in function header like this updatePassword($newPassword)
 291      * @return boolean
 292      */
 293     public function updatePassword()
 294     {
 295         if (MODE_DEMO) {
 296             $this->messages->add('i', _('in demo mode, you can\'t update your password'));
 297             Tools::logm('in demo mode, you can\'t do this');
 298             Tools::redirect('?view=config');
 299         }
 300         else {
 301             if (isset($_POST['password']) && isset($_POST['password_repeat'])) {
 302                 if ($_POST['password'] == $_POST['password_repeat'] && $_POST['password'] != "") {
 303                     $this->messages->add('s', _('your password has been updated'));
 304                     $this->store->updatePassword($this->user->getId(), Tools::encodeString($_POST['password'] . $this->user->getUsername()));
 305                     Session::logout();
 306                     Tools::logm('password updated');
 307                     Tools::redirect();
 308                 }
 309                 else {
 310                     $this->messages->add('e', _('the two fields have to be filled & the password must be the same in the two fields'));
 311                     Tools::redirect('?view=config');
 312                 }
 313             }
 314         }
 315     }
 316
 317     /**
 318      * checks if login & password are correct and save the user in session.
 319      * it redirects the user to the $referer link
 320      * @param  string $referer the url to redirect after login
 321      * @todo add the return value
 322      * @return boolean
 323      */
 324     public function login($referer)
 325     {
 326         if (!empty($_POST['login']) && !empty($_POST['password'])) {
 327             $user = $this->store->login($_POST['login'], Tools::encodeString($_POST['password'] . $_POST['login']));
 328             if ($user != array()) {
 329                 # Save login into Session
 330                 Session::login($user['username'], $user['password'], $_POST['login'], Tools::encodeString($_POST['password'] . $_POST['login']), array('poche_user' => new User($user)));
 331
 332                 $this->messages->add('s', _('welcome to your poche'));
 333                 if (!empty($_POST['longlastingsession'])) {
 334                     $_SESSION['longlastingsession'] = 31536000;
 335                     $_SESSION['expires_on'] = time() + $_SESSION['longlastingsession'];
 336                     session_set_cookie_params($_SESSION['longlastingsession']);
 337                 } else {
 338                     session_set_cookie_params(0);
 339                 }
 340                 session_regenerate_id(true);
 341                 Tools::logm('login successful');
 342                 Tools::redirect($referer);
 343             }
 344             $this->messages->add('e', _('login failed: bad login or password'));
 345             Tools::logm('login failed');
 346             Tools::redirect();
 347         } else {
 348             $this->messages->add('e', _('login failed: you have to fill all fields'));
 349             Tools::logm('login failed');
 350             Tools::redirect();
 351         }
 352     }
 353
 354     /**
 355      * log out the poche user. It cleans the session.
 356      * @todo add the return value
 357      * @return boolean
 358      */
 359     public function logout()
 360     {
 361         $this->user = array();
 362         Session::logout();
 363         $this->messages->add('s', _('see you soon!'));
 364         Tools::logm('logout');
 365         Tools::redirect();
 366     }
 367
 368     /**
 369      * import from Instapaper. poche needs a ./instapaper-export.html file
 370      * @todo add the return value
 371      * @param string $targetFile the file used for importing
 372      * @return boolean
 373      */
 374     private function importFromInstapaper($targetFile)
 375     {
 376         # TODO gestion des articles favs
 377         $html = new simple_html_dom();
 378         $html->load_file($targetFile);
 379         Tools::logm('starting import from instapaper');
 380
 381         $read = 0;
 382         $errors = array();
 383         foreach($html->find('ol') as $ul)
 384         {
 385             foreach($ul->find('li') as $li)
 386             {
 387                 $a = $li->find('a');
 388                 $url = new Url(base64_encode($a[0]->href));
 389                 $this->action('add', $url, 0, TRUE);
 390                 if ($read == '1') {
 391                     $sequence = '';
 392                     if (STORAGE == 'postgres') {
 393                         $sequence = 'entries_id_seq';
 394                     }
 395                     $last_id = $this->store->getLastId($sequence);
 396                     $this->action('toggle_archive', $url, $last_id, TRUE);
 397                 }
 398             }
 399
 400             # the second <ol> is for read links
 401             $read = 1;
 402         }
 403         $this->messages->add('s', _('import from instapaper completed'));
 404         Tools::logm('import from instapaper completed');
 405         Tools::redirect();
 406     }
 407
 408     /**
 409      * import from Pocket. poche needs a ./ril_export.html file
 410      * @todo add the return value
 411      * @param string $targetFile the file used for importing
 412      * @return boolean
 413      */
 414     private function importFromPocket($targetFile)
 415     {
 416         # TODO gestion des articles favs
 417         $html = new simple_html_dom();
 418         $html->load_file($targetFile);
 419         Tools::logm('starting import from pocket');
 420
 421         $read = 0;
 422         $errors = array();
 423         foreach($html->find('ul') as $ul)
 424         {
 425             foreach($ul->find('li') as $li)
 426             {
 427                 $a = $li->find('a');
 428                 $url = new Url(base64_encode($a[0]->href));
 429                 $this->action('add', $url, 0, TRUE);
 430                 if ($read == '1') {
 431                         $sequence = '';
 432                         if (STORAGE == 'postgres') {
 433                             $sequence = 'entries_id_seq';
 434                         }
 435                     $last_id = $this->store->getLastId($sequence);
 436                     $this->action('toggle_archive', $url, $last_id, TRUE);
 437                 }
 438             }
 439
 440             # the second <ul> is for read links
 441             $read = 1;
 442         }
 443         $this->messages->add('s', _('import from pocket completed'));
 444         Tools::logm('import from pocket completed');
 445         Tools::redirect();
 446     }
 447
 448     /**
 449      * import from Readability. poche needs a ./readability file
 450      * @todo add the return value
 451      * @param string $targetFile the file used for importing
 452      * @return boolean
 453      */
 454     private function importFromReadability($targetFile)
 455     {
 456         # TODO gestion des articles lus / favs
 457         $str_data = file_get_contents($targetFile);
 458         $data = json_decode($str_data,true);
 459         Tools::logm('starting import from Readability');
 460         $count = 0;
 461         foreach ($data as $key => $value) {
 462             $url = NULL;
 463             $favorite = FALSE;
 464             $archive = FALSE;
 465             foreach ($value as $attr => $attr_value) {
 466                 if ($attr == 'article__url') {
 467                     $url = new Url(base64_encode($attr_value));
 468                 }
 469                 $sequence = '';
 470                 if (STORAGE == 'postgres') {
 471                     $sequence = 'entries_id_seq';
 472                 }
 473                 if ($attr_value == 'true') {
 474                     if ($attr == 'favorite') {
 475                         $favorite = TRUE;
 476                     }
 477                     if ($attr == 'archive') {
 478                         $archive = TRUE;
 479                     }
 480                 }
 481             }
 482             # we can add the url
 483             if (!is_null($url) && $url->isCorrect()) {
 484                 $this->action('add', $url, 0, TRUE);
 485                 $count++;
 486                 if ($favorite) {
 487                     $last_id = $this->store->getLastId($sequence);
 488                     $this->action('toggle_fav', $url, $last_id, TRUE);
 489                 }
 490                 if ($archive) {
 491                     $last_id = $this->store->getLastId($sequence);
 492                     $this->action('toggle_archive', $url, $last_id, TRUE);
 493                 }
 494             }
 495         }
 496         $this->messages->add('s', _('import from Readability completed. ' . $count . ' new links.'));
 497         Tools::logm('import from Readability completed');
 498         Tools::redirect();
 499     }
 500
 501     /**
 502      * import datas into your poche
 503      * @param  string $from name of the service to import : pocket, instapaper or readability
 504      * @todo add the return value
 505      * @return boolean
 506      */
 507     public function import($from)
 508     {
 509         $providers = array(
 510             'pocket' => 'importFromPocket',
 511             'readability' => 'importFromReadability',
 512             'instapaper' => 'importFromInstapaper'
 513         );
 514
 515         if (! isset($providers[$from])) {
 516             $this->messages->add('e', _('Unknown import provider.'));
 517             Tools::redirect();
 518         }
 519
 520         $targetDefinition = 'IMPORT_' . strtoupper($from) . '_FILE';
 521         $targetFile = constant($targetDefinition);
 522
 523         if (! defined($targetDefinition)) {
 524             $this->messages->add('e', _('Incomplete inc/poche/define.inc.php file, please define "' . $targetDefinition . '".'));
 525             Tools::redirect();
 526         }
 527
 528         if (! file_exists($targetFile)) {
 529             $this->messages->add('e', _('Could not find required "' . $targetFile . '" import file.'));
 530             Tools::redirect();
 531         }
 532
 533         $this->$providers[$from]($targetFile);
 534     }
 535
 536     /**
 537      * export poche entries in json
 538      * @return json all poche entries
 539      */
 540     public function export()
 541     {
 542         $entries = $this->store->retrieveAll($this->user->getId());
 543         echo $this->tpl->render('export.twig', array(
 544             'export' => Tools::renderJson($entries),
 545         ));
 546         Tools::logm('export view');
 547     }
 548
 549     /**
 550      * Checks online the latest version of poche and cache it
 551      * @param  string $which 'prod' or 'dev'
 552      * @return string        latest $which version
 553      */
 554     private function getPocheVersion($which = 'prod')
 555     {
 556         $cache_file = CACHE . '/' . $which;
 557
 558         # checks if the cached version file exists
 559         if (file_exists($cache_file) && (filemtime($cache_file) > (time() - 86400 ))) {
 560            $version = file_get_contents($cache_file);
 561         } else {
 562            $version = file_get_contents('http://static.inthepoche.com/versions/' . $which);
 563            file_put_contents($cache_file, $version, LOCK_EX);
 564         }
 565         return $version;
 566     }
 567 }
 568
 569 /* class for Flattr querying. Should be put in a separate file
 570 *   Or maybe just create an array instead of a complete class... My mistake. :-°
 571 */
 572 class FlattrItem{
 573     public $status;
 574     public $urltoflattr;
 575     public $flattrItemURL;
 576     public $numflattrs;
 577
 578     public function checkitem($urltoflattr){
 579         $this->cacheflattrfile($urltoflattr);
 580         $flattrResponse = file_get_contents("cache/flattr/".base64_encode($urltoflattr).".cache");
 581         if($flattrResponse != FALSE){
 582             $result = json_decode($flattrResponse);
 583             if (isset($result->message)){
 584                 if ($result->message == "flattrable"){
 585                 $this->status = "flattrable";
 586                         }
 587                     }
 588             elseif ($result->link) {
 589                             $this->status = "flattred";
 590                             $this->flattrItemURL = $result->link;
 591                             $this->numflattrs = $result->flattrs;
 592                         }
 593             else{
 594                 $this->status = "not flattrable";
 595             }
 596         }
 597         else
 598         {
 599             $this->status = "FLATTR_ERR_CONNECTION";
 600         }
 601     }
 602
 603     private function cacheflattrfile($urltoflattr){
 604         if (!is_dir('cache/flattr')){
 605             mkdir('./cache/flattr', 0700);
 606         }
 607         // if a cache flattr file for this url already exists and it's been less than one day than it have been updated, see in /cache
 608         if ((!file_exists("cache/flattr/".base64_encode($urltoflattr).".cache")) || (time() - filemtime("cache/flattr/".base64_encode($urltoflattr).".cache") > 86400))
 609         {
 610             $askForFlattr = Tools::getFile("https://api.flattr.com/rest/v2/things/lookup/?url=".$urltoflattr);
 611              $flattrCacheFile = fopen("cache/flattr/".base64_encode($urltoflattr).".cache", 'w+');
 612              fwrite($flattrCacheFile, $askForFlattr);
 613              fclose($flattrCacheFile);
 614         }
 615     }
 616 }