function news_listing()
{
global $aidlink, $locale;
$result2 = dbquery("\n\tSELECT news_id, news_subject, news_image_t1, news_image, news_image_t2, news_news, news_draft FROM " . DB_NEWS . "\n\tWHERE " . (multilang_table("NS") ? "news_language='" . LANGUAGE . "' AND " : "") . " news_cat='0'\n\tORDER BY news_draft DESC, news_sticky DESC, news_datestamp DESC\n\t");
echo "<div class='m-t-20'>\n";
echo opencollapse('news-list');
echo "<div class='panel panel-default'>\n";
echo "<div class='panel-heading clearfix'>\n";
echo "<div class='overflow-hide'>\n";
echo "<span class='display-inline-block strong'><a " . collapse_header_link('news-list', '0', TRUE, 'm-r-10') . ">" . $locale['news_0202'] . "</a></span>\n";
echo "<span class='badge m-r-10'>" . dbrows($result2) . "</span>";
echo "<span class='text-smaller mid-opacity'>" . LANGUAGE . "</span>";
echo "</div>\n";
echo "</div>\n";
// end panel heading
echo "<div " . collapse_footer_link('news-list', '0', TRUE) . ">\n";
echo "<ul class='list-group p-15'>\n";
if (dbrows($result2) > 0) {
while ($data2 = dbarray($result2)) {
echo "<li class='list-group-item'>\n";
echo "<div class='pull-left m-r-10'>\n";
$image_thumb = get_news_image_path($data2['news_image'], $data2['news_image_t1'], $data2['news_image_t2']);
if (!$image_thumb) {
$image_thumb = IMAGES . "imagenotfound70.jpg";
}
echo thumbnail($image_thumb, '50px');
echo "</div>\n";
echo "<div class='overflow-hide'>\n";
$newsText = strip_tags(parse_textarea($data2['news_news']));
echo "<div><span class='strong text-dark'>" . $data2['news_subject'] . "</span><br/>" . fusion_first_words($newsText, '50') . "</div>\n";
echo "<a href='" . FUSION_SELF . $aidlink . "&action=edit&section=news_form&news_id=" . $data2['news_id'] . "'>" . $locale['edit'] . "</a> -\n";
echo "<a href='" . FUSION_SELF . $aidlink . "&action=delete&news_id=" . $data2['news_id'] . "' onclick=\"return confirm('" . $locale['news_0251'] . "');\">" . $locale['delete'] . "</a>\n";
echo "</li>\n";
}
} else {
echo "<div class='panel-body text-center'>\n";
echo $locale['news_0254'];
echo "</div>\n";
}
// news listing.
echo "</ul>\n";
echo "</div>\n";
// panel container
echo "</div>\n";
// panel default
$result = dbquery("\n\tSELECT cat.news_cat_id, cat.news_cat_name, cat.news_cat_image, cat.news_cat_language,\n\tcount(news.news_id) as news_count,\n\tcount(child.news_cat_id) as news_parent_count\n\tFROM " . DB_NEWS_CATS . " cat\n\tLEFT JOIN " . DB_NEWS_CATS . " child on child.news_cat_parent = cat.news_cat_id\n\tLEFT JOIN " . DB_NEWS . " news on news.news_cat = cat.news_cat_id\n\t" . (multilang_table("NS") ? "WHERE cat.news_cat_language='" . LANGUAGE . "'" : "") . " GROUP BY cat.news_cat_id ORDER BY cat.news_cat_name\n\t");
if (dbrows($result) > 0) {
while ($data = dbarray($result)) {
echo "<div class='panel panel-default'>\n";
echo "<div class='panel-heading clearfix'>\n";
echo "<div class='btn-group pull-right m-t-5'>\n";
echo "<a class='btn btn btn-default' href='" . clean_request("section=news_category&action=edit&cat_id=" . $data['news_cat_id'], array("aid")) . "'>" . $locale['edit'] . "</a>";
echo "<a class='" . ($data['news_count'] || $data['news_parent_count'] ? "disabled" : "") . " btn btn-danger' href='" . clean_request("section=news_category&action=delete&cat_id=" . $data['news_cat_id'], array("aid")) . "' onclick=\"return confirm('" . $locale['news_0252'] . "');\"><i class='fa fa-trash'></i> " . $locale['delete'] . "</a>\n";
echo "</div>\n";
echo "<div class='overflow-hide p-r-10'>\n";
echo "<span class='display-inline-block strong'><a " . collapse_header_link('news-list', $data['news_cat_id'], '0', 'm-r-10') . ">" . $data['news_cat_name'] . "</a></span>\n";
echo "<span class='badge m-r-10'>" . $data['news_count'] . "</span>";
echo "<span class='text-smaller mid-opacity'>" . LANGUAGE . "</span>";
echo "</div>\n";
/// end overflow-hide
echo "</div>\n";
// end panel heading
echo "<div " . collapse_footer_link('news-list', $data['news_cat_id'], '0') . ">\n";
echo "<ul class='list-group p-15'>\n";
$result2 = dbquery("SELECT news_id, news_subject, news_image_t1, news_image, news_image_t2, news_news, news_draft FROM " . DB_NEWS . " " . (multilang_table("NS") ? "WHERE news_language='" . LANGUAGE . "' AND" : "WHERE") . " news_cat='" . $data['news_cat_id'] . "' ORDER BY news_draft DESC, news_sticky DESC, news_datestamp DESC");
if (dbrows($result2) > 0) {
while ($data2 = dbarray($result2)) {
echo "<li class='list-group-item'>\n";
echo "<div class='pull-left m-r-10'>\n";
$image_thumb = get_news_image_path($data2['news_image'], $data2['news_image_t1'], $data2['news_image_t2']);
if (!$image_thumb) {
$image_thumb = IMAGES . "imagenotfound70.jpg";
}
echo thumbnail($image_thumb, '50px');
echo "</div>\n";
echo "<div class='overflow-hide'>\n";
$newsText = strip_tags(parse_textarea($data2['news_news']));
echo "<div><span class='strong text-dark'>" . $data2['news_subject'] . "</span><br/>" . fusion_first_words($newsText, 50) . "</div>\n";
echo "<a href='" . FUSION_SELF . $aidlink . "&action=edit&section=news_form&news_id=" . $data2['news_id'] . "'>" . $locale['edit'] . "</a> -\n";
echo "<a href='" . FUSION_SELF . $aidlink . "&action=delete&news_id=" . $data2['news_id'] . "' onclick=\"return confirm('" . $locale['news_0251'] . "');\">" . $locale['delete'] . "</a>\n";
echo "</li>\n";
}
} else {
echo "<div class='panel-body text-center'>\n";
echo $locale['news_0254'];
echo "</div>\n";
}
echo "</ul>\n";
echo "</div>\n</div>\n";
// panel container, default
}
}
echo closecollapse();
echo "</div>\n";
}
function opencollapsebody($title, $unique_id, $grouping_id, $active = 0, $class = FALSE)
{
$html = "<div class='panel panel-default'>\n";
$html .= "<div class='panel-heading clearfix'>\n";
$html .= "<div class='overflow-hide'>\n";
$html .= "<span class='display-inline-block strong'><a " . collapse_header_link($grouping_id, $unique_id, $active, $class) . ">" . $title . "</a></span>\n";
$html .= "</div>\n";
$html .= "</div>\n";
$html .= "<div " . collapse_footer_link($grouping_id, $unique_id, $active) . ">\n";
// body.
return $html;
}
