function page_news($home = false, $search = false) { global $db, $fullsite, $cla_cid, $cla_nid, $cla_site, $ts_config; $curPage = $_POST['page']; if ((int) $curPage <= 0) { $curPage = 1; } $lang = '_' . get_language(); if ($home) { $title_page = get_lang('home'); } if ($search == true && __post('txt_search') != '') { $filter_search = " and (keyword_vi like '%" . __post('txt_search') . "%' or keyword_en like '%" . __post('txt_search') . "%' )"; if ($search == true && $has_data == false) { $title_page = get_lang('search_result'); } } if ($home == true || $search == true) { echo '<div class="group_area"> <div style="background-color:#71baf1;" class="lft-title"> ' . $title_page . ' </div> <div class="group_content">'; } if ((int) $cla_cid > 0 || $home) { $PageSize = (int) $ts_config['max_news_page']; $from = ($curPage - 1) * $PageSize; $limit = $PageSize; $sqlTotal = "SELECT count(*) as TotalRecord FROM ntk_news WHERE status = 1"; if ((int) $cla_cid > 0) { $sqlTotal .= " and cid=" . $cla_cid . " "; } if ((int) $cla_nid > 0) { $sqlTotal .= " AND id<=" . $cla_nid; } $sqlTotal .= $filter_search; if ($home) { $sqlTotal .= " AND show_index = 1 "; } //echo $sqlTotal; $result = $db->query($sqlTotal, true, "Query failed"); $TotalRecord = 0; if ($aR = $db->fetchByAssoc($result)) { $TotalRecord = (int) $aR['TotalRecord']; } $has_data = false; if ($TotalRecord > 0) { $TotalPage = intval($TotalRecord / $PageSize + ($TotalRecord % $PageSize > 0 ? 1 : 0)); $paging = Paging2($TotalPage, $curPage, 'form1'); $sql = "SELECT t1.*,t2.menu_name" . $lang . " FROM ntk_news t1\n\t\t\t\t\tleft join ntk_menus t2 on t1.cid = t2.menu_id\n\t\t\t\tWHERE t1.status = 1"; if ((int) $cla_cid > 0) { $sql .= " and t1.cid=" . $cla_cid . " "; } if ((int) $cla_nid > 0) { $sql .= " AND t1.id = " . $cla_nid; } if ($home) { $sql .= " AND t1.show_index = 1 "; } $sql .= $filter_search; $sql .= "ORDER BY news_order ASC,id ASC \tLIMIT " . $from . "," . $limit . " "; //echo $sql; $result = $db->query($sql, true, "Query failed"); echo '<form action="" name="form1" id="form1" method="POST"> <input type="hidden" value="1" name="page" id="page"/> '; $stt = 0; while ($aR = $db->fetchByAssoc($result)) { if ($aR['title' . $lang] != '' && $aR['short' . $lang] != '') { if ($stt == 0) { if ($home == false && $search == false) { echo '<div class="group_area"><div style="background-color:#71baf1;" class="lft-title">' . $aR['menu_name' . $lang] . '</div><div class="group_content">'; } } $has_data = true; $title_url = ''; $title_url = fnStrConvert($aR['title' . $lang]); $title_url = str_replace(" ", '-', $title_url); echo '<div class="news_title"><a href="' . $fullsite . '/' . (int) $aR['cid'] . '/' . (int) $aR['id'] . '/' . $title_url . '.html">' . $aR['title' . $lang] . '</a></div>'; echo '<div><div class="news_date">' . date2vndate($aR['create_date']) . '</div><div class="news_download">'; $sql = " select t1.*,t2.file_type_name,t2.file_type_icon \n\t\t\t\t\t\t\t\tfrom ntk_new_files t1\n\t\t\t\t\t\t\t\tleft join ntk_file_type t2 on t1.file_type_id = t2.file_type_id\n\t\t\t\t\t\t\t\twhere t1.new_id = " . (int) $aR['id'] . "\n\t\t\t\t\t\t"; $result_file = $db->query($sql, true, "Query failed"); $i = 0; while ($aR_file = $db->fetchByAssoc($result_file)) { if ($i == 0) { echo '<span class="download_file_title">Tải file tại đây</span> '; } if ($aR_file['require_login'] == 1 && !is_login()) { $href = 'javascript:notLogin();'; } else { $href = $ts_config['site_url_download_file'] . $aR_file['file_path']; } if ($i > 0) { echo ' | '; } //$urlre = $sugar_config['site_url_download_file']."/download_file_case.php?fn=".$filePath; //header('location:'.$urlre.''); //die(); echo '<a href="' . $href . '"><img src="' . $fullsite . '/images/' . $aR_file['file_type_icon'] . '"></a>'; $i++; } echo '</div></div><br>'; echo '<div class="news_short"><div style="width:25px; float:left;"> </div>' . html_entity_decode($aR['short' . $lang]) . ' <a href="' . $fullsite . '/' . (int) $aR['cid'] . '/' . (int) $aR['id'] . '/' . $title_url . '.html">' . get_lang('text_detail') . '</a></div>'; echo '<hr size=2 style="color:#cccccc">'; $stt++; } } if ($has_data == true) { echo '<div style="margin-top:10px;margin-bottom:10px;">' . $paging . '</div>'; } } if ($search == true && $has_data == false) { echo '<div style="">' . get_lang('search_no_result') . '</div>'; } echo "</form1>"; echo "</div></div>"; } }
function page_news($home = false) { global $db, $fullsite, $cla_cid, $cla_nid, $cla_site, $ts_config; $lang = '_' . get_language(); if ((int) $cla_cid > 0 || $home) { $sql = "SELECT * FROM ntk_news WHERE status = 1"; if ((int) $cla_cid > 0) { $sql .= " and cid=" . $cla_cid . " "; } if ((int) $cla_nid > 0) { $sql .= " AND id<=" . $cla_nid; } if ($home) { $sql .= " AND show_index = 1 "; } $sql .= "ORDER BY news_order ASC,id ASC \tLIMIT 0,10 "; //echo $sql;die(); $result = $db->query($sql, true, "Query failed"); while ($aR = $db->fetchByAssoc($result)) { if ($aR['title' . $lang] != '' && $aR['short' . $lang] != '') { $title_url = ''; $title_url = fnStrConvert($aR['title' . $lang]); $title_url = str_replace(" ", '-', $title_url); echo '<div class="news_title"><a href="' . $fullsite . '/' . (int) $aR['cid'] . '/' . (int) $aR['id'] . '/' . $title_url . '.html">' . $aR['title' . $lang] . '</a></div>'; echo '<div><div class="news_date">' . date2vndate($aR['create_date']) . '</div><div class="news_download">'; $sql = " select t1.*,t2.file_type_name,t2.file_type_icon \n\t\t\t\t\t\t\tfrom ntk_new_files t1\n\t\t\t\t\t\t\tleft join ntk_file_type t2 on t1.file_type_id = t2.file_type_id\n\t\t\t\t\t\t\twhere t1.new_id = " . (int) $aR['id'] . "\n\t\t\t\t\t"; $result_file = $db->query($sql, true, "Query failed"); $i = 0; while ($aR_file = $db->fetchByAssoc($result_file)) { if ($aR_file['require_login'] == 1 && !is_login()) { $href = 'javascript:notLogin();'; } else { $href = $ts_config['site_url_download_file'] . $aR_file['file_path']; } if ($i > 0) { echo ' | '; } //$urlre = $sugar_config['site_url_download_file']."/download_file_case.php?fn=".$filePath; //header('location:'.$urlre.''); //die(); echo '<a href="' . $href . '"><img src="' . $fullsite . '/images/' . $aR_file['file_type_icon'] . '"></a>'; $i++; } echo '</div></div><br>'; echo '<div class="news_short"><div style="width:25px; float:left;"> </div>' . $aR['short' . $lang] . ' <a href="' . $fullsite . '/' . (int) $aR['cid'] . '/' . (int) $aR['id'] . '/' . $title_url . '.html">' . get_lang('text_detail') . '</a></div>'; echo '<hr size=2 style="color:#cccccc">'; } } } }