Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/thietkewebvumi.com/code/ |
<?php
class pages{
function pages()
{
global $CORE;
switch ($CORE->input['code'])
{
default : $this -> goList(); break;
case 'detail' : $this -> goDetail(); break;
}
}
function dequy_sub_menu($menu_id,$class,$num){
global $DB,$CORE;
$txt = '';
$num = $num+1;
$r_check = $DB->fetch_row($DB->query("SELECT id FROM NNCCMS_menu WHERE parent_id='".$menu_id."' LIMIT 1"));
if($r_check){
$q_sub_menu = $DB->query("SELECT * FROM NNCCMS_menu WHERE parent_id='".$menu_id."'");
$txt .= '<ul class="'.$class.'">';
while($r_sub_menu = $DB->fetch_row($q_sub_menu)){
if($CORE->lang_type=='en'){
$txt .= '<li><a href="'.$r_sub_menu['fetitle'].'">'.$r_sub_menu['etitle'].'</a></li>';
}else{
$txt .= '<li><a href="'.$r_sub_menu['ftitle'].'">'.$r_sub_menu['title'].'</a></li>';
}
$txt .= $this->dequy_sub_menu($r_sub_menu['id'],'class_'.$num,$num);
}
$txt .= '</ul>';
}
return $txt;
}
function get_all_sub_menu_id($menu_id){
global $DB,$func;
$r_check = $DB->fetch_row($DB->query("SELECT id FROM NNCCMS_menu WHERE parent_id='".$menu_id."' LIMIT 1"));
$txt = '';
if($r_check){
$q_sub_menu = $DB->query("SELECT id FROM NNCCMS_menu WHERE parent_id='".$menu_id."'");
while($r_sub_menu = $DB->fetch_row($q_sub_menu)){
$txt .= $r_sub_menu['id'].',';
}
}
return $func->remove_lastchar($txt,1);
}
function dequy_sub_menu_product($menu_id,$sub_menu_id,$class,$num){
global $DB,$CORE;
$ftitle2 = $CORE->input['ftitle2'];
$txt = '';
$num = $num+1;
$r_check = $DB->fetch_row($DB->query("SELECT id FROM NNCCMS_menu WHERE parent_id='".$menu_id."' LIMIT 1"));
if($r_check){
$q_sub_menu = $DB->query("SELECT * FROM NNCCMS_menu WHERE parent_id='".$menu_id."'");
$txt .= '<ul class="'.$class.'">';
while($r_sub_menu = $DB->fetch_row($q_sub_menu)){
if($r_sub_menu['id']!=$sub_menu_id){
if($CORE->lang_type=='en'){
$txt .= '<li><a href="'.$r_sub_menu['fetitle'].'">'.$r_sub_menu['etitle'].'</a>';
}else{
$txt .= '<li><a href="'.$r_sub_menu['ftitle'].'">'.$r_sub_menu['title'].'</a>';
}
}else{
if($CORE->lang_type=='en'){
$txt .= '<li><a href="javascript:void(0);" class="active" onclick="show_pagesimg('.$r_sub_menu['id'].');">'.$r_sub_menu['etitle'].'</a>';
}else{
$txt .= '<li><a href="javascript:void(0);" class="active" onclick="show_pagesimg('.$r_sub_menu['id'].');">'.$r_sub_menu['title'].'</a>';
}
}
//show bo suu tap
if($r_sub_menu['id']==$sub_menu_id){
$q_bst = $DB->query("SELECT * FROM NNCCMS_pagesimg WHERE id IN (SELECT pagesimg_id FROM NNCCMS_menu_pagesimg WHERE menu_id = '".$sub_menu_id."') AND status=1 ORDER BY title ASC");
$txt .= '<ul class="list_pagesimg" id="list_pagesimg_'.$r_sub_menu['id'].'">';
while($r_bst = $DB->fetch_row($q_bst)){
$show_active = '';
if($CORE->lang_type=='en'){
if($ftitle2 == $r_bst['fetitle']){
$show_active = 'style="color:#ff7300"';
}
$txt .= '<li><a href="'.$r_sub_menu['fetitle'].'/'.$r_bst['fetitle'].'.html" '.$show_active.'>'.$r_bst['etitle'].'</a></li>';
}else{
if($ftitle2 == $r_bst['ftitle']){
$show_active = 'style="color:#ff7300"';
}
$txt .= '<li><a href="'.$r_sub_menu['ftitle'].'/'.$r_bst['ftitle'].'.html" '.$show_active.'>'.$r_bst['title'].'</a></li>';
}
}
$txt .= '</ul>';
}
$txt .= '</li>';
$txt .= $this->dequy_sub_menu_product($r_sub_menu['id'],$sub_menu_id,'class_'.$num,$num);
}
$txt .= '</ul>';
}
return $txt;
}
function get_top_menu_id($parent_id){
global $DB;
$row_check = $DB->fetch_row($DB->query("SELECT id,parent_id FROM NNCCMS_menu WHERE id='$parent_id'"));
if($row_check['parent_id']!=0){
$this->get_top_menu_id($row_check['parent_id']);
}
return $row_check['id'];
}
function id_first_sub_menu_product($menu_id){
global $DB;
$row_check = $DB->fetch_row($DB->query("SELECT menu_id FROM NNCCMS_menu_pagesimg WHERE menu_id='$menu_id' LIMIT 1"));
if(!$row_check){
$row_check2 = $DB->fetch_row($DB->query("SELECT id FROM NNCCMS_menu WHERE parent_id='".$menu_id."' LIMIT 1"));
$m_id = $row_check2['id'];
if(!$row_check2){
return $menu_id;
}else{
$this->id_first_sub_menu_product($row_check2['id']);
}
}else{
$m_id = $row_check['menu_id'];
}
return $m_id;
}
function id_first_sub_menu_pages($menu_id){
global $DB;
$row_check = $DB->fetch_row($DB->query("SELECT menu_id FROM NNCCMS_menu_pages WHERE menu_id='$menu_id' LIMIT 1"));
if(!$row_check){
$row_check2 = $DB->fetch_row($DB->query("SELECT id FROM NNCCMS_menu WHERE parent_id='".$menu_id."' LIMIT 1"));
$m_id = $row_check2['id'];
if(!$row_check2){
return $menu_id;
}else{
$this->id_first_sub_menu_pages($row_check2['id']);
}
}else{
$m_id = $row_check['menu_id'];
}
return $m_id;
}
function goList(){
global $CORE, $DB, $smarty, $print, $INFO;
$ftitle = trim($CORE->input['ftitle']);
$row_menu = $DB->fetch_row($DB->query("SELECT * FROM NNCCMS_menu WHERE ftitle='$ftitle' or fetitle='$ftitle'"));
//check if menu is blank link
if($row_menu['type']=='url' and !empty($row_menu['url'])){
$print->refresh(trim($row_menu['url']));
exit();
}
if($CORE->lang_type=='en'){
$row_menu['title'] = $row_menu['etitle'];
$row_menu['ftitle'] = $row_menu['fetitle'];
}
$smarty->assign('this_menu',$row_menu);
$row_menu['parent_id'] = intval($row_menu['parent_id']);
if($row_menu['parent_id']==0){
$main_menu_id = $row_menu['id'];
}else{
$main_menu_id = $this->get_top_menu_id($row_menu['parent_id']);
}
$row_main_menu = $DB->fetch_row($DB->query("SELECT * FROM NNCCMS_menu WHERE id='$main_menu_id'"));
if($CORE->lang_type=='en'){
$row_main_menu['title'] = $row_main_menu['etitle'];
$row_main_menu['ftitle'] = $row_main_menu['fetitle'];
}
$smarty->assign('main_menu',$row_main_menu);
//switch module special
switch($main_menu_id){
default://news
//show left menu
$smarty->assign('sub_menu_news',$this->dequy_sub_menu($main_menu_id,'class_1',1));
//show right news
//check haverec pages inner this menu:
$id_first_sub_menu_pages = $this->id_first_sub_menu_pages($row_menu['id']);
if($id_first_sub_menu_pages!=$row_menu['id']){
$row_menu = $DB->fetch_row($DB->query("SELECT * FROM NNCCMS_menu WHERE id='$id_first_sub_menu_pages'"));
$print->refresh($INFO['home_url'].$row_menu['ftitle'].'/');
exit();
}
$pageNum = ($_GET['pageNum']>0) ? intval($_GET['pageNum']) : 1;
$pageSize = 9;
$from = (($pageNum * $pageSize) - $pageSize);
$row_total_news = $DB->fetch_row($DB->query("SELECT count(*) as total,ftitle FROM NNCCMS_pages WHERE id IN (SELECT pages_id FROM NNCCMS_menu_pages WHERE menu_id='".$row_menu['id']."') AND status=1 AND type_page='normal'"));
$total = $row_total_news['total'];
if($total==1){
$print->refresh($INFO['home_url'].$row_menu['ftitle'].'/'.$row_total_news['ftitle'].'.html');
exit();
}
$totalPage = ceil($total/$pageSize);
$q_news = $DB->query("SELECT * FROM NNCCMS_pages WHERE id IN (SELECT pages_id FROM NNCCMS_menu_pages WHERE menu_id = '".$row_menu['id']."') AND status=1 AND type_page='normal' ORDER BY noibat DESC, time DESC LIMIT $from,$pageSize");
while($r_news = $DB->fetch_row($q_news)){
if($CORE->lang_type=='en'){
$r_news['title'] = $r_news['etitle'];
$r_news['ftitle'] = $r_news['fetitle'];
$r_news['intro'] = $r_news['eintro'];
$r_news['body'] = $r_news['ebody'];
}
$r_news['body'] = str_replace(array('../tinymce/plugins','thanhdosg/'),array('tinymce/plugins',''),$r_news['body']);
$r_news['body'] = str_replace(' ','',trim(strip_tags(html_entity_decode($r_news['body']))));
$r_news['time'] = date('d/m/Y',$r_news['time']);
$list_news[] = $r_news;
}
$smarty->assign('list_news',$list_news);
$nav = $print->Pagination($totalPage,$pageNum,'pages',$ftitle.'/');
$smarty->assign('nav',$nav);
$smarty->assign('title',$row_menu['title']);
break;
}
//show all sub menu
$sub_menu = $this->dequy_sub_menu($row_menu['id'],'class_1',1);
$smarty->assign('sub_menu',$sub_menu);
}
function goDetail(){
global $CORE, $DB, $smarty,$func;
$ftitle = $CORE->input['ftitle'];
$ftitle2 = $CORE->input['ftitle2'];
//load menu
$row_menu = $DB->fetch_row($DB->query("SELECT * FROM NNCCMS_menu WHERE ftitle='$ftitle' or fetitle='$ftitle'"));
if($CORE->lang_type=='en'){
$row_menu['title'] = $row_menu['etitle'];
$row_menu['ftitle'] = $row_menu['fetitle'];
}
$smarty->assign('this_menu',$row_menu);
$row_menu['parent_id'] = intval($row_menu['parent_id']);
if($row_menu['parent_id']==0){
$main_menu_id = $row_menu['id'];
}else{
$main_menu_id = $this->get_top_menu_id($row_menu['parent_id']);
}
$row_main_menu = $DB->fetch_row($DB->query("SELECT * FROM NNCCMS_menu WHERE id='$main_menu_id'"));
if($CORE->lang_type=='en'){
$row_main_menu['title'] = $row_main_menu['etitle'];
$row_main_menu['ftitle'] = $row_main_menu['fetitle'];
}
$smarty->assign('main_menu',$row_main_menu);
$smarty->assign('cur_url',$func->current_url());
//switch module
switch($main_menu_id){
default: //news
//show right
$sub_menu_news = $this->dequy_sub_menu($main_menu_id,'class_1',1);
$smarty->assign('sub_menu_news',$sub_menu_news);
//show right
$row_detail_news = $DB->fetch_row($DB->query("SELECT * FROM NNCCMS_pages WHERE ftitle='$ftitle2' or fetitle='$ftitle2' AND type_page='normal' "));
if($CORE->lang_type=='en'){
$row_detail_news['title'] = $row_detail_news['etitle'];
$row_detail_news['ftitle'] = $row_detail_news['fetitle'];
$row_detail_news['intro'] = $row_detail_news['eintro'];
$row_detail_news['body'] = $row_detail_news['ebody'];
}
$row_detail_news['body'] = str_replace(array('../tinymce/plugins','thanhdosg/'),array('tinymce/plugins',''),$row_detail_news['body']);
$row_detail_news['body'] = str_replace('../upload/editor_new','upload/editor_new',$row_detail_news['body']);
$row_detail_news['body'] = str_replace('<iframe','<div class="myIframe"><iframe',html_entity_decode($row_detail_news['body']));
$row_detail_news['body'] = str_replace('</iframe>','</iframe></div>',html_entity_decode($row_detail_news['body']));
$row_detail_news['time'] = date('d/m/Y',$row_detail_news['time']);
$smarty->assign('detail_news',$row_detail_news);
if($CORE->lang_type=='en'){
$smarty->assign('title',$row_detail_news['etitle']);
}else{
$smarty->assign('title',$row_detail_news['title']);
}
$query_img = $DB->query("SELECT * FROM NNCCMS_images WHERE id_pagesimg='".$row_detail_news['id']."'");
while($row_img = $DB->fetch_row($query_img)){
$list_img[] = $row_img;
}
$smarty->assign('list_img',$list_img);
//show file
$query_file = $DB->query("SELECT * FROM NNCCMS_pages_files WHERE pages_id='".$row_detail_news['id']."'");
while($row_file = $DB->fetch_row($query_file)){
$list_file[] = $row_file;
}
$smarty->assign('list_file',$list_file);
$q_lienquan = $DB->query("SELECT * FROM NNCCMS_pages WHERE ftitle<>'$ftitle2' AND id IN (SELECT pages_id FROM NNCCMS_menu_pages WHERE menu_id='".$row_menu['id']."') AND status=1 AND type_page='normal' ORDER BY noibat DESC, time DESC LIMIT 10");
while($r_lienquan = $DB->fetch_row($q_lienquan)){
if($CORE->lang_type=='en'){
$r_lienquan['title'] = $r_lienquan['etitle'];
$r_lienquan['ftitle'] = $r_lienquan['fetitle'];
$r_lienquan['intro'] = $r_lienquan['eintro'];
$r_lienquan['body'] = $r_lienquan['ebody'];
}
$r_lienquan['time'] = date('d/m/Y',$r_lienquan['time']);
$list_lienquan[] = $r_lienquan;
}
$smarty->assign('list_lienquan',$list_lienquan);
break;
}
}
}//end class
// Run class
$run = new pages();
?>