/**
* Print news
*/
function printNewsList()
{
global $news_limit_chars;
global $short_date_format;
global $tmpl;
$bNewsFriendly = getParam('permalinks_news') == 'on' ? true : false;
$res = getNewsList();
ob_start();
if (!mysql_num_rows($res)) {
?>
<div class="no_news">
<?php
echo _t("_No news available");
?>
</div>
<?php
} else {
while ($news_arr = mysql_fetch_array($res)) {
?>
<div class="news_cont">
<div class="clear_both"></div>
<div class="news_header">
<a href="<?php
echo getNewsUrl($news_arr['newsID'], $news_arr['NewsUri'], $bNewsFriendly);
?>
">
<?php
echo process_line_output($news_arr['Header']);
?>
</a>
</div>
<div class="news_date"><?php
echo date(str_replace('%', '', $short_date_format), $news_arr['Date']);
?>
</div>
<div class="news_snippet">
<?php
echo process_html_output($news_arr['Snippet']);
?>
</div>
<div class="clear_both"></div>
</div>
<?php
}
}
return ob_get_clean();
}
function MemberPrintNews()
{
global $site;
global $short_date_format;
$bNewsFriendly = getParam('permalinks_news') == 'on' ? true : false;
$res = getNewsList();
if (!$res) {
return;
}
echo "<table cellspacing=1 cellpadding=2 class=small width='100%'>\n";
if (!mysql_num_rows($res)) {
echo "<tr class=panel><td align=center>No news available.</td></tr>\n";
}
while ($news_arr = mysql_fetch_array($res)) {
$news_header = process_line_output($news_arr['Header']);
$sNewsUrl = getNewsUrl($news_arr['newsID'], $news_arr['NewsUri'], $bNewsFriendly);
echo "\r\n\t\t\t<tr >\r\n\t\t\t\t<td align=center width=15%>\r\n\t\t\t\t\t<a href=\"news.php?edit_id={$news_arr['newsID']}\">Edit</a> |\r\n\t\t\t\t\t<a href=\"news.php?action=delete&delete_id={$news_arr['newsID']}\">Delete</a>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td align=center width=15%>" . date(str_replace('%', '', $short_date_format), $news_arr['Date']) . "</td>\r\n\t\t\t\t<td aling=left> <a target='_blank' href='{$sNewsUrl}'>{$news_header}</a></td>\r\n\t\t\t</tr>\n";
}
echo "</table>\n";
}
function printNewsPanel($iLimit = 0, $iPreview = 128)
{
global $site;
$php_date_format = getParam('php_date_format');
// news
$news_limit_chars = getParam("max_news_preview");
$bNewsFriendly = getParam('permalinks_news') == 'on' ? true : false;
$news_res = getNewsList($iLimit);
$news_count = db_arr("SELECT COUNT(*) FROM `News`");
$news_counter = $news_count['0'];
$ret = '';
if ($news_counter > 0) {
while ($news_arr = mysql_fetch_assoc($news_res)) {
$ret .= '<div class="newsWrap">';
$ret .= '<div class="newsHead">';
$ret .= '<a href="' . getNewsUrl($news_arr['newsID'], $news_arr['NewsUri'], $bNewsFriendly) . '">';
$ret .= process_line_output($news_arr['Header']);
$ret .= '</a>';
$ret .= '</div>';
//$ret .= '<div class="newsInfo"><img src="' . getTemplateIcon( 'clock.gif' ) . '" />' . date( $php_date_format, $news_arr['Date'] ) . '</div>';
$ret .= '<div class="newsInfo"><img src="' . getTemplateIcon('clock.gif') . '" />' . LocaledDataTime($news_arr['Date']) . '</div>';
$ret .= '<div class="newsText">';
//$ret .= process_text_withlinks_output( $news_arr['Snippet'] );
$ret .= process_html_output($news_arr['Snippet']);
$ret .= '</div>';
$ret .= '</div>';
}
if ($news_counter > $max_news_on_home) {
$sNewsLink = $bNewsFriendly ? $site['url'] . 'news/' : $site['url'] . 'news.php';
$ret .= '<div class="newsReadMore">';
$ret .= '<a href="' . $sNewsLink . '">' . _t("_Read news in archive") . '</a>';
$ret .= '</div>';
}
} else {
$ret .= '<div class="no_result"><div>' . _t("_No news available") . '</div></div>';
}
return $ret;
}
function newsHome()
{
if (isset($_GET['Page'])) {
$page = $_GET['Page'];
} else {
$page = 1;
}
if (isset($_GET['NewsType'])) {
$listType = $_GET['NewsType'];
if ($listType == "Search") {
$criteria = $_GET['criteria'];
$results = getGeneralNewsSearch($criteria, $page);
$emailCountTemp = getNewsListCountSearch($criteria);
//url for moving to different pages
$queryUrl = "NewsType=Search&criteria={$criteria}";
}
} else {
//get the news items for the proper page, and display
$results = getNewsList($page);
$newsCountTemp = getNewsListCount();
}
if (count($results) == 0) {
//no news items are found, returns nothing
$errorMsg = "No Items were found.";
include '../view/errorPage.php';
} else {
if (count($results) == 1) {
$row = $results[0];
include '../view/newsDisp.php';
} else {
//$emailCountTemp is part of an array, only index
$newsCount = ceil($newsCountTemp[0] / 50);
include '../view/news.php';
}
}
}
insertNews($db, $_POST['title'], $_POST['newscontent'], $usr->getProperty('user_id'));
} else {
updateNewsContent($db, $_POST['id'], $_POST['title'], $_POST['newscontent'], $usr->getProperty('user_id'));
}
}
}
$category = 'general';
if (isset($_GET['mode']) && $_GET['mode'] == "edit") {
if (!isset($_GET['id']) && !is_numeric($_GET['id'])) {
die('Missing news id');
}
$news = getNewsContent($db, $_GET['id']);
} elseif (isset($_GET['mode']) && $_GET['mode'] == "insert") {
$news = getNewsContent($db, 0);
} else {
$news = getNewsList($db, $category);
}
$tpl =& new HTML_Template_IT('./');
$tpl->loadTemplatefile('admin.tpl', true, true);
// assign the content to the vars
$tpl->setVariable('USER', $usr->getProperty('handle'));
$tpl->setVariable('NEWS', $news);
$tpl->show();
/**
* Returns news list
* for a given category
*
* @param object &$db a reference to a db connection object
* @param string $category news category
*/
function getNewsList(&$db, $category)
echo date('d/m/Y - H.i', strtotime($blog['registered']));
?>
</td></tr>
<?php
// print_r($active);
?>
<?php
}
print '</table>';
break;
case 'newsList':
include 'xtecfunc.php';
$ipp = 20;
print '<h2 style="color: #1C4387; font-size: 1.3em; background-image: none; border: none; margin-bottom: 1em; margin-top: 1em;">Llista de notícies publicades</h2>';
$init = isset($_REQUEST['init']) && $_REQUEST['init'] != '' ? $_REQUEST['init'] : 1;
$newsList = getNewsList();
print '<div style="text-align:right; padding-right:60px;">' . $pager . '</div><br/ >';
print '<table>';
print '<th align="left" valign="top">Títol</th><th align="left" valign="top">Data de publicació</th>';
$bgcolor = "#e5f2fe";
foreach ($newsList as $new) {
$bgcolor = $bgcolor == '#e5f2fe' ? '#ffffff' : '#e5f2fe';
?>
<tr bgcolor="<?php
echo $bgcolor;
?>
">
<td width="250"><a href=index.php?id=<?php
echo $new['newId'];
?>
title="Vés a la notícia"><?php
echo '尚未指定關鍵字，關鍵字格式:keyword1,keyword2,keyword3...';
} else {
$three_month_before_str = date("Y-m-d", strtotime("-3 month"));
$year_str = substr($three_month_before_str, 0, 4);
$month_str = substr($three_month_before_str, 5, 2);
$temp_key = $_POST["MyKeywordLList"];
//echo 'temp_key:'.$temp_key;
$keyword_array = explode(",", $temp_key);
$conn = getConnection('news_db');
$data_list = array();
for ($i = 0; $i < sizeof($keyword_array); $i++) {
$data_list[$i] = getNewsStatistics_V1($year_str, $month_str, $conn, $keyword_array[$i]);
}
$ary = array();
for ($i = 0; $i < sizeof($keyword_array); $i++) {
$ary = getNewsList($conn, $keyword_array[$i], $ary);
//var_dump($ary);
}
$newslist = $ary;
//$newslist=getNewsList($conn);
}
?>
<form action="./news.php" method="post" id="mform" class="form-horizontal">
<div class="row">
<div class='col-md-12'>
<div class="form-group">
<label>請指定關鍵字</label>
<div class='input-group date' id='my_keyword'>
<input type='text' class="form-control" id="MyKeyword" name="MyKeywordLList" value=""/>
{
$sql = "select YEAR(n.ndate), MONTH(n.ndate) from newsarticles n group by YEAR(n.ndate),MONTH(n.ndate) order by YEAR(n.ndate) asc ,MONTH(n.ndate) asc";
$result = mysql_query($sql) or die('MySQL query error');
$ary = array();
while ($row = mysql_fetch_array($result)) {
$ary[] = $row[0];
$ary[] = $row[1];
}
mysql_free_result($result);
return $ary;
}
$conn = getConnection('jared');
$newsdlist = getNewsDateList($conn);
$ary1 = getNewsStatistics($conn, '麗嬰房');
$ary2 = getNewsStatistics($conn, '奇哥');
$newslist = getNewsList($conn);
?>
<link href="./assets/c3.css" rel="stylesheet" type="text/css">
<script src="./assets/d3.min.js" charset="utf-8"></script>
<script src="./assets/c3.min.js"></script>
<script src="./assets/js/jQDateRangeSlider.js"></script>
<script>
$(document).ready(function () {
$("#slider").dateRangeSlider();
});
</script>
<div id="chart"></div>
<div class="row">
<div class="col-sm-2"></div>
