[github/wallabag/wallabag.git] / index.php

<?php
/**
 * poche, a read it later open source system
 *
 * @category   poche
 * @author     Nicolas Lœuillet <nicolas@loeuillet.org>
 * @copyright  2013
 * @license    http://www.wtfpl.net/ see COPYING file
 */

/**
 * TODO
 * gestion des erreurs sqlite (duplicate tout ça)
 * gérer si url vide
 * traiter les variables passées en get
 * récupérer le titre de la page pochée (cf readityourself.php)
 * actions archive, fav et delete à traiter
 * bookmarklet
 * améliorer présentation des liens
 * améliorer présentation d'un article
 * aligner verticalement les icones d'action
 * afficher liens mis en favoris et archivés
 * tri des liens
 */
require_once dirname(__FILE__).'/inc/Readability.php';
require_once dirname(__FILE__).'/inc/Encoding.php';
include dirname(__FILE__).'/inc/functions.php';

try
{
    $db_handle = new PDO('sqlite:db/poche.sqlite');
    $db_handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (Exception $e)
{
    die('database error : '.$e->getMessage());
}

$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
$view = (isset ($_GET['view'])) ? htmlspecialchars($_GET['view']) : '';
$id = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';

switch ($action) {
    case 'add':
        $url = (isset ($_GET['url'])) ? $_GET['url'] : '';
        $url = html_entity_decode(trim($url));
        $title = $url;
        // if url use https protocol change it to http
        if (!preg_match('!^https?://!i', $url)) $url = 'http://'.$url;
        // convert page to utf-8
        $html = Encoding::toUTF8(get_external_file($url,15));
        if(isset($html) and strlen($html) > 0) {
            // send result to readability library
            $r = new Readability($html, $url);
            if($r->init()) {
                $title = $r->articleTitle->innerHTML;
            }
        }

        $query = $db_handle->prepare('INSERT INTO entries ( url, title ) VALUES (?, ?)');
        $query->execute(array($url, $title));
        break;
    case 'toggle_fav' :
        $sql_action = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
        $params_action = array($id);
        break;
    case 'toggle_archive' :
        $sql_action = "UPDATE entries SET is_read=~is_read WHERE id=?";
        $params_action = array($id);
        break;
    case 'delete':
        $sql_action = "DELETE FROM entries WHERE id=?";
        $params_action = array($id);
        break;
    default:
        break;
}

try
{
    # action query
    if (isset($sql_action)) {
        $query = $db_handle->prepare($sql_action);
        $query->execute($params_action);
    }
}
catch (Exception $e)
{
    die('query error : '.$e->getMessage());
}

switch ($view) {
    case 'archive':
        $sql = "SELECT * FROM entries WHERE is_read=?";
        $params = array(-1);
        break;
    case 'fav' :
        $sql = "SELECT * FROM entries WHERE is_fav=?";
        $params = array(-1);
        break;
    default:
        $sql = "SELECT * FROM entries WHERE is_read=?";
        $params = array(0);
        break;
}

# view query
try
{
    $query = $db_handle->prepare($sql);
    $query->execute($params);
    $entries = $query->fetchAll();
}
catch (Exception $e)
{
    die('query error : '.$e->getMessage());
}

?>
<!DOCTYPE html>
<!--[if lte IE 6]> <html class="no-js ie6 ie67 ie678" lang="en"> <![endif]-->
<!--[if lte IE 7]> <html class="no-js ie7 ie67 ie678" lang="en"> <![endif]-->
<!--[if IE 8]> <html class="no-js ie8 ie678" lang="en"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
<html>
    <head>
        <meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0">
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=10">
        <title>poche : queue</title>
        <link rel="stylesheet" href="css/knacss.css" media="all">
        <link rel="stylesheet" href="css/style.css" media="all">
    </head>
    <body>
        <header>
            <h1><img src="img/logo.png" alt="logo poche" />poche, a read it later open source system</h1>
        </header>
        <div id="main" class="w800p">
            <ul id="links">
                <li><a href="index.php">home</a></li>
                <li><a href="?view=fav">favorites</a></li>
                <li><a href="?view=archive">archive</a></li>
                <li><a title="i am a bookmarklet, use me !" href="javascript:(function(){var%20url%20=%20location.href;var%20title%20=%20document.title%20||%20url;window.open('<?php echo url()?>?action=add&url='%20+%20encodeURIComponent(url),'_self');})();">poche it !</a></li>
            </ul>
            <ul id="entries">
                <?php
                foreach ($entries as $entry) {
                    echo '<li><a href="readityourself.php?url='.urlencode($entry['url']).'">' . $entry['title'] . '</a> <a href="?action=toggle_archive&id='.$entry['id'].'" title="toggle mark as read" class="tool">&#10003;</a> <a href="?action=toggle_fav&id='.$entry['id'].'" title="toggle favorite" class="tool">'.(($entry['is_fav'] == 0) ? '&#9734;' : '&#9733;' ).'</a> <a href="?action=delete&id='.$entry['id'].'" title="toggle delete" class="tool">&#10799;</a></li>';
                }
                ?>
            </ul>
        </div>
        <footer class="mr2 mt3">
            <p class="smaller"><a href="http://github.com/nicosomb/poche">poche</a> is a read it later open source system, based on <a href="http://www.memiks.fr/readityourself/">ReadItYourself</a>. <a href="https://twitter.com/getpoche" title="follow us on twitter">@getpoche</a>. Logo by <a href="http://www.iconfinder.com/icondetails/43256/128/jeans_monotone_pocket_icon">Brightmix</a>. poche is developed by <a href="http://nicolas.loeuillet.org">Nicolas Lœuillet</a> under the <a href="http://www.wtfpl.net/">WTFPL</a>.</p>
        </footer>
    </body>
</html>
Commit	Line	Data
1a268ba7 NL	1	<?php
	2	/**
	3	* poche, a read it later open source system
	4	*
	5	* @category poche
	6	* @author Nicolas Lœuillet <nicolas@loeuillet.org>
	7	* @copyright 2013
	8	* @license http://www.wtfpl.net/ see COPYING file
	9	*/
	10
	11	/**
	12	* TODO
	13	* gestion des erreurs sqlite (duplicate tout ça)
	14	* gérer si url vide
	15	* traiter les variables passées en get
	16	* récupérer le titre de la page pochée (cf readityourself.php)
	17	* actions archive, fav et delete à traiter
	18	* bookmarklet
	19	* améliorer présentation des liens
	20	* améliorer présentation d'un article
	21	* aligner verticalement les icones d'action
	22	* afficher liens mis en favoris et archivés
	23	* tri des liens
	24	*/
24619534	25	require_once dirname(__FILE__).'/inc/Readability.php';
	26	require_once dirname(__FILE__).'/inc/Encoding.php';
	27	include dirname(__FILE__).'/inc/functions.php';
1a268ba7 NL	28
	29	try
	30	{
a590ea55	31	$db_handle = new PDO('sqlite:db/poche.sqlite');
1a268ba7 NL	32	$db_handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	33	}
	34	catch (Exception $e)
	35	{
5917f419	36	die('database error : '.$e->getMessage());
1a268ba7 NL	37	}
	38
	39	$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
5917f419	40	$view = (isset ($_GET['view'])) ? htmlspecialchars($_GET['view']) : '';
5917f419	41	$id = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';
1a268ba7 NL	42
	43	switch ($action) {
	44	case 'add':
24619534	45	$url = (isset ($_GET['url'])) ? $_GET['url'] : '';
24619534	46	$url = html_entity_decode(trim($url));
1a268ba7	47	$title = $url;
24619534	48	// if url use https protocol change it to http
	49	if (!preg_match('!^https?://!i', $url)) $url = 'http://'.$url;
	50	// convert page to utf-8
	51	$html = Encoding::toUTF8(get_external_file($url,15));
	52	if(isset($html) and strlen($html) > 0) {
	53	// send result to readability library
	54	$r = new Readability($html, $url);
	55	if($r->init()) {
	56	$title = $r->articleTitle->innerHTML;
	57	}
	58	}
	59
1a268ba7 NL	60	$query = $db_handle->prepare('INSERT INTO entries ( url, title ) VALUES (?, ?)');
	61	$query->execute(array($url, $title));
	62	break;
5917f419	63	case 'toggle_fav' :
	64	$sql_action = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
	65	$params_action = array($id);
1a268ba7	66	break;
5917f419	67	case 'toggle_archive' :
	68	$sql_action = "UPDATE entries SET is_read=~is_read WHERE id=?";
	69	$params_action = array($id);
1a268ba7 NL	70	break;
1a268ba7 NL	71	case 'delete':
24619534	72	$sql_action = "DELETE FROM entries WHERE id=?";
24619534	73	$params_action = array($id);
1a268ba7 NL	74	break;
	75	default:
	76	break;
	77	}
c4fb6f01	78
5917f419	79	try
	80	{
	81	# action query
	82	if (isset($sql_action)) {
	83	$query = $db_handle->prepare($sql_action);
	84	$query->execute($params_action);
	85	}
	86	}
	87	catch (Exception $e)
	88	{
	89	die('query error : '.$e->getMessage());
	90	}
	91
	92	switch ($view) {
	93	case 'archive':
	94	$sql = "SELECT * FROM entries WHERE is_read=?";
	95	$params = array(-1);
	96	break;
	97	case 'fav' :
	98	$sql = "SELECT * FROM entries WHERE is_fav=?";
	99	$params = array(-1);
	100	break;
	101	default:
	102	$sql = "SELECT * FROM entries WHERE is_read=?";
	103	$params = array(0);
	104	break;
	105	}
	106
	107	# view query
	108	try
	109	{
	110	$query = $db_handle->prepare($sql);
	111	$query->execute($params);
	112	$entries = $query->fetchAll();
	113	}
	114	catch (Exception $e)
	115	{
	116	die('query error : '.$e->getMessage());
	117	}
	118
1a268ba7 NL	119	?>
	120	<!DOCTYPE html>
	121	<!--[if lte IE 6]> <html class="no-js ie6 ie67 ie678" lang="en"> <![endif]-->
	122	<!--[if lte IE 7]> <html class="no-js ie7 ie67 ie678" lang="en"> <![endif]-->
	123	<!--[if IE 8]> <html class="no-js ie8 ie678" lang="en"> <![endif]-->
	124	<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
	125	<html>
	126	<head>
	127	<meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0">
	128	<meta charset="utf-8">
	129	<meta http-equiv="X-UA-Compatible" content="IE=10">
	130	<title>poche : queue</title>
	131	<link rel="stylesheet" href="css/knacss.css" media="all">
	132	<link rel="stylesheet" href="css/style.css" media="all">
	133	</head>
	134	<body>
5917f419	135	<header>
1ef1b969	136	<h1><img src="img/logo.png" alt="logo poche" />poche, a read it later open source system</h1>
5917f419	137	</header>
	138	<div id="main" class="w800p">
	139	<ul id="links">
	140	<li><a href="index.php">home</a></li>
	141	<li><a href="?view=fav">favorites</a></li>
	142	<li><a href="?view=archive">archive</a></li>
	143	<li><a title="i am a bookmarklet, use me !" href="javascript:(function(){var%20url%20=%20location.href;var%20title%20=%20document.title%20\|\|%20url;window.open('<?php echo url()?>?action=add&url='%20+%20encodeURIComponent(url),'_self');})();">poche it !</a></li>
	144	</ul>
	145	<ul id="entries">
	146	<?php
	147	foreach ($entries as $entry) {
24619534	148	echo '<li><a href="readityourself.php?url='.urlencode($entry['url']).'">' . $entry['title'] . '</a> <a href="?action=toggle_archive&id='.$entry['id'].'" title="toggle mark as read" class="tool">✓</a> <a href="?action=toggle_fav&id='.$entry['id'].'" title="toggle favorite" class="tool">'.(($entry['is_fav'] == 0) ? '☆' : '★' ).'</a> <a href="?action=delete&id='.$entry['id'].'" title="toggle delete" class="tool">⨯</a></li>';
5917f419	149	}
	150	?>
	151	</ul>
	152	</div>
	153	<footer class="mr2 mt3">
644ba9a9	154	<p class="smaller"><a href="http://github.com/nicosomb/poche">poche</a> is a read it later open source system, based on <a href="http://www.memiks.fr/readityourself/">ReadItYourself</a>. <a href="https://twitter.com/getpoche" title="follow us on twitter">@getpoche</a>. Logo by <a href="http://www.iconfinder.com/icondetails/43256/128/jeans_monotone_pocket_icon">Brightmix</a>. poche is developed by <a href="http://nicolas.loeuillet.org">Nicolas Lœuillet</a> under the <a href="http://www.wtfpl.net/">WTFPL</a>.</p>
1a268ba7	155	</footer>
5917f419	156	</body>
1a268ba7	157	</html>