$db_content = new db_query($sql_news_content);
$row = mysqli_fetch_assoc($db_content->result);
unset($db_content);
$detail_data['new_detail'] = $row['ndt_content'];
$datetime_facebook = $detail_data['new_date'];
$datetime_detail_timestamp = $detail_data['new_date'];
$detail_data['new_date'] = getDateTime(1, 1, 1, 1, '', $detail_data['new_date']);
$detail_data['link_cat'] = generate_cat_url($detail_data);
$detail_data['new_picture'] = get_picture_path($detail_data['new_picture'], 'large');
$detail_data['facebook_share_link'] = 'http://khang.vn' . generate_news_detail_url($detail_data);
$detail_data['facebook_social'] = array();
$detail_data['facebook_social']['like'] = get_facebook_like_button($detail_data['facebook_share_link']);
$detail_data['facebook_social']['comment'] = get_facebook_comment_frame($detail_data['facebook_share_link']);
$detail_data['facebook_social']['embed'] = get_facebook_embedded_post($detail_data['facebook_share_link']);
$detail_data['new_teaser'] = $detail_data['new_teaser'] ? $detail_data['new_teaser'] : cut_string(removeHTML($detail_data['new_detail']), 200, '...');
$color_cat = get_color_category($detail_data['cat_id']);
$rainTpl->assign('color_cat', $color_cat);
$rainTpl->assign('page_title', $detail_data['new_title']);
$rainTpl->assign('detail_data', $detail_data);
//query ra các tin cùng chuyên mục
$sql_cat_list_news = 'SELECT new_id,
new_picture,
new_title,
cat_name
FROM news
LEFT JOIN categories ON cat_id = new_cat_id
WHERE new_cat_id = ' . $detail_data['cat_id'] . ' AND new_active = 1 AND new_id <> ' . $iNews . '
AND new_date <= ' . $datetime_detail_timestamp . '
ORDER BY new_date DESC
LIMIT 3';
$db_cat_news = new db_query($sql_cat_list_news);
cat_name,
new_view
FROM news
LEFT JOIN categories ON cat_id = new_cat_id
WHERE new_active = 1 AND new_date >= ' . MIN_TIME_NEWS_HOT . '
ORDER BY new_view DESC
LIMIT 0,6';
$db_list_home = new db_query($sql_list_home);
$list_home = array();
while ($row = mysqli_fetch_assoc($db_list_home->result)) {
$row['new_title'] = htmlspecialbo($row['new_title']);
$row['new_picture'] = get_picture_path($row['new_picture'], 'small');
$row['new_date'] = date('d \\T\\h m, Y, h:i a', $row['new_date']);
$row['new_view'] = number_format($row['new_view']);
$row['link_cat'] = generate_cat_url($row);
$row['color_cat'] = get_color_category($row['cat_id']);
$row['link_detail'] = generate_news_detail_url($row);
$list_home[] = $row;
}
$rainTpl->assign('list_home', $list_home);
//lấy ra các category, mỗi category 3 tin mới nhất - trừ mục tin sức khỏe
$list_news_category = array();
$cat_tsk = $list_category[1];
foreach ($list_category as $cat_temp) {
//bỏ qua tin sức khỏe
if ($cat_tsk['cat_id'] == $cat_temp['cat_id'] || $cat_tsk['cat_id'] == 0) {
continue;
}
$db_query = new db_query('SELECT new_id,
new_title,
new_picture,
}
$detail_data['link_cat_next'] = generate_cat_url($detail_data, $iPage + 1);
$detail_data['cat_title'] = $detail_data['cat_title'] ? $detail_data['cat_title'] : $detail_data['cat_name'] . ' | Khang.vn - Cẩm nang sức khỏe';
//list category
$list_category = get_all_categories($iCat);
$count_list_cate = count($list_category) - 2;
$list_category2 = array_slice($list_category, 1, $count_list_cate);
$rainTpl->assign('list_categories', $list_category);
$rainTpl->assign('list_categories_slice', $list_category2);
$rainTpl->assign('detail_data', $detail_data);
$rainTpl->assign('iPage', $iPage);
$rainTpl->assign('page_title', $detail_data['cat_title']);
$rainTpl->assign('base_search_url', '/search');
$rainTpl->assign('meta_description', get_meta_description_category($detail_data));
$rainTpl->assign('meta_keyword', get_meta_keyword_category($detail_data));
$rainTpl->assign('color_cat', get_color_category($detail_data['cat_id']));
$rainTpl->assign('adv_top', $adv_top);
$rainTpl->assign('adv_right', $adv_right);
$rainTpl->assign('link_hoidap', generate_qaa_url());
//quảng cáo banner
$rainTpl->assign('adv_banner_list', $adv_banner_list);
if ($is_pjax) {
include_once '../includes/pjax/inc_cat_pjax.php';
exit;
}
include_once '../includes/inc_cat.php';
$facebook_og = '
<meta property="og:site_name" content="Khang.vn - Cẩm nang sức khỏe cho mọi nhà"/>
<meta property="og:title" content="Thông tin y tế, sức khỏe cộng đồng"/>
<meta property="og:type" content="website" />
<meta property="og:url" content="http://khang.vn' . $detail_data['link_cat'] . '" />
