因为网站要对接百度小程序,于是做了一个api,用于对接百度小程序,代码如下:
<?php header("Content-type: application/json; charset=utf-8"); error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED); define('IN_DESTOON', true); define('FILE_APPEND', 1); require './../config.inc.php'; require './../include/global.func.php'; require './../lang/zh-cn/lang.inc.php'; require 'Db.class.php'; $seturl ='https://www.kaotop.com/public/'; $dbms = 'mysql'; //数据库类型 $host = $CFG['db_host']; //数据库主机名 $dbName = $CFG['db_name']; //使用的数据库 $user = $CFG['db_user']; //数据库连接用户名 $pass = $CFG['db_pass']; //对应的密码 $dsn = "$dbms:host=$host;dbname=$dbName"; $port = 3306; try { $PDO = new Db($dbms,$host,$dbName,$user,$pass,$port); //初始化一个PDO对象 //$PDO->pdo->query('set names utf8'); } catch (PDOException $e) { die("Error!: " . $e->getMessage() . " "); } require 'FileCache.class.php'; $CONFIG = GetConfig(); $cache = new cache($CONFIG['cache']*60*60); $cache->cacheCheck(); $m = isset($_GET['m']) ? $_GET['m'] : ''; $page = isset($_GET['page']) ? $_GET['page'] : 1; $kw = isset($_GET['kw']) ? urldecode($_GET['kw']) : ''; $catid = isset($_GET['catid']) ? $_GET['catid'] : ''; $userid = isset($_GET['userid']) ? $_GET['userid'] : ''; $username = isset($_GET['username']) ? $_GET['username'] : ''; $itemid = isset($_GET['itemid']) ? $_GET['itemid'] : ''; $pageSize = isset($_GET['pageSize']) ? $_GET['pageSize'] : 20; $limit = ($page-1)*$pageSize.','.$pageSize; $state = 200; $message = "success"; if($m){ switch ($m){ //配置 case 'config': $data = $CONFIG; break; //首页焦点图 case 'banner': $table = 'youchuang_banner'; $fields = '*'; $where = '1'; $order = 'weigh DESC'; $arr = Db::select($PDO->pdo,$table,$fields,$where,$order); $data = array(); $i = 0; foreach($arr as $row){ $data[$i]['picture'] = $seturl.$row['image']; echo $data[$i]['picture']; $data[$i]['url'] = $row['url']; $i++; } break; //首页推荐分类 case 'index_category': $table = 'youchuang_index_category'; $fields = '*'; $where = '1'; $order = 'weigh DESC'; $arr = Db::select($PDO->pdo,$table,$fields,$where,$order); $data = array(); $i = 0; foreach($arr as $row){ $data[$i]['icon'] = $seturl.$row['image']; $data[$i]['id'] = $row['url']; $data[$i]['name'] = $row['name']; $i++; } break; //首页推荐品牌 case 'index_brand': $table = $CFG['tb_pre'].'brand_13'; $fields = 'itemid,title,thumb'; $where = '`status`=3'; //$order = 'itemid DESC'; $order = GetOrder('brand'); $limit = 6; $data = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); break; //推荐资讯 case 'index_article': $table = $CFG['tb_pre'].'article_21'; $fields = 'itemid,title,thumb,introduce,addtime'; $where = '`level`=1 AND `status`=3'; //$order = 'itemid DESC'; $order = GetOrder('article'); $limit = 6; $data = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } break; //推荐小学 case 'index_xiaoxue': $table = $CFG['tb_pre'].'article_23'; $fields = 'itemid,title,thumb,introduce,addtime'; $where = '`level`=1 AND `status`=3'; //$order = 'itemid DESC'; $order = GetOrder('article'); $limit = 6; $data = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } break; //推荐商家 case 'index_company': $table = $CFG['tb_pre'].'company'; $fields = 'userid,username,company,thumb,introduce,business,address'; $where = '`status`=3'; $order = 'userid DESC'; //$order = GetOrder('company'); $limit = 6; $data = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); break; //推荐产品 case 'index_sell': $table = $CFG['tb_pre'].'sell_5'; $fields = 'itemid,company,thumb,introduce,unit,price'; $where = '`level`=1 AND `status`=3'; //$order = 'itemid DESC'; $order = GetOrder('sell'); $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data = array(); } break; //资讯列表 case 'article_list': $table = $CFG['tb_pre'].'article_21'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //资讯内容 case 'article_detail': $moduleid=21; $table = $CFG['tb_pre'].'article_21'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_21'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的资讯ID"; } break; //相关资讯 case 'article_more': $table = $CFG['tb_pre'].'article_21'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //资讯搜索 case 'article_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_21'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //资讯分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //资讯内容集合 case 'article_detail_all': $moduleid=21; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_21'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); //$table = $CFG['tb_pre'] . 'article_data_21'; $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_21'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的资讯ID"; } break; //资讯模块关闭 //小学列表 case 'xiaoxue_list': $table = $CFG['tb_pre'].'article_23'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //小学内容 case 'xiaoxue_detail': $moduleid=23; $table = $CFG['tb_pre'].'article_23'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的小学ID"; } break; //相关小学 case 'xiaoxue_more': $table = $CFG['tb_pre'].'article_23'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'xiaoxue_rand_keyword': $data = RandKeyword('article',10); break; //小学搜索 case 'xiaoxue_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_23'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //小学分类 case 'xiaoxue_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //小学内容集合 case 'xiaoxue_detail_all': $moduleid=23; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_23'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_23'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的小学ID"; } break; //小学模块关闭 //初中列表 case 'chuzhong_list': $table = $CFG['tb_pre'].'article_24'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //初中内容 case 'chuzhong_detail': $moduleid=24; $table = $CFG['tb_pre'].'article_24'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_24'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的初中ID"; } break; //相关初中 case 'chuzhong_more': $table = $CFG['tb_pre'].'article_24'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //初中搜索 case 'chuzhong_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_24'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //初中分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //初中内容集合 case 'chuzhong_detail_all': $moduleid=24; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_24'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_24'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的初中ID"; } break; //初中模块关闭 //高中列表 case 'gaozhong_list': $table = $CFG['tb_pre'].'article_25'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //高中内容 case 'gaozhong_detail': $moduleid=25; $table = $CFG['tb_pre'].'article_25'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_24'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的高中ID"; } break; //相关高中 case 'gaozhong_more': $table = $CFG['tb_pre'].'article_25'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //高中搜索 case 'gaozhong_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_25'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //高中分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //高中内容集合 case 'gaozhong_detail_all': $moduleid=25; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_25'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_25'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的高中ID"; } break; //高中模块关闭 //语言列表 case 'yuyan_list': $table = $CFG['tb_pre'].'article_26'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //语言内容 case 'yuyan_detail': $moduleid=26; $table = $CFG['tb_pre'].'article_26'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_24'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的语言ID"; } break; //相关语言 case 'yuyan_more': $table = $CFG['tb_pre'].'article_26'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //语言搜索 case 'yuyan_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_26'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //语言分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //语言内容集合 case 'yuyan_detail_all': $moduleid=26; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_26'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_26'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的语言ID"; } break; //语言模块关闭 //会计列表 case 'kuaiji_list': $table = $CFG['tb_pre'].'article_27'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //会计内容 case 'kuaiji_detail': $moduleid=27; $table = $CFG['tb_pre'].'article_27'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_24'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的会计ID"; } break; //相关会计 case 'kuaiji_more': $table = $CFG['tb_pre'].'article_27'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //会计搜索 case 'kuaiji_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_27'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //会计分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //会计内容集合 case 'kuaiji_detail_all': $moduleid=27; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_27'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_27'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的会计ID"; } break; //会计模块关闭 //驾考列表 case 'jiakao_list': $table = $CFG['tb_pre'].'article_28'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //驾考内容 case 'jiakao_detail': $moduleid=28; $table = $CFG['tb_pre'].'article_28'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_24'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的驾考ID"; } break; //相关驾考 case 'jiakao_more': $table = $CFG['tb_pre'].'article_28'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //驾考搜索 case 'jiakao_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_28'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //驾考分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //驾考内容集合 case 'jiakao_detail_all': $moduleid=28; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_28'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_28'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的驾考ID"; } break; //驾考模块关闭 //学历列表 case 'xueli_list': $table = $CFG['tb_pre'].'article_29'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //学历内容 case 'xueli_detail': $moduleid=29; $table = $CFG['tb_pre'].'article_29'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_24'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的学历ID"; } break; //相关学历 case 'xueli_more': $table = $CFG['tb_pre'].'article_29'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //学历搜索 case 'xueli_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_29'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //学历分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //学历内容集合 case 'xueli_detail_all': $moduleid=29; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_29'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_29'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的学历ID"; } break; //学历模块关闭 //司法列表 case 'sifa_list': $table = $CFG['tb_pre'].'article_30'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //司法内容 case 'sifa_detail': $moduleid=30; $table = $CFG['tb_pre'].'article_30'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_30'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的司法ID"; } break; //相关司法 case 'sifa_more': $table = $CFG['tb_pre'].'article_30'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //司法搜索 case 'sifa_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_30'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //司法分类 case 'sifa_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //司法内容集合 case 'sifa_detail_all': $moduleid=30; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_30'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_30'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的司法ID"; } break; //司法模块关闭 //it列表 case 'it_list': $table = $CFG['tb_pre'].'article_31'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //it内容 case 'it_detail': $moduleid=30; $table = $CFG['tb_pre'].'article_31'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_31'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的itID"; } break; //相关it case 'it_more': $table = $CFG['tb_pre'].'article_31'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //it搜索 case 'it_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_31'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //it分类 case 'article_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //it内容集合 case 'it_detail_all': $moduleid=31; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_31'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_31'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的itID"; } break; //it模块关闭 //医护列表 case 'yihu_list': $table = $CFG['tb_pre'].'article_33'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //医护内容 case 'yihu_detail': $moduleid=33; $table = $CFG['tb_pre'].'article_33'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_30'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的医护ID"; } break; //相关医护 case 'yihu_more': $table = $CFG['tb_pre'].'article_33'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //医护搜索 case 'yihu_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_33'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //医护分类 case 'yihu_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //医护内容集合 case 'yihu_detail_all': $moduleid=33; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_33'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_33'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的医护ID"; } break; //医护模块关闭 //建筑列表 case 'jianzhu_list': $table = $CFG['tb_pre'].'article_34'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //建筑内容 case 'jianzhu_detail': $moduleid=33; $table = $CFG['tb_pre'].'article_34'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_30'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的建筑ID"; } break; //相关建筑 case 'jianzhu_more': $table = $CFG['tb_pre'].'article_34'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //建筑搜索 case 'jianzhu_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_34'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //建筑分类 case 'jianzhu_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //建筑内容集合 case 'jianzhu_detail_all': $moduleid=34; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_34'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_34'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的建筑ID"; } break; //建筑模块关闭 //学术列表 case 'xueshu_list': $table = $CFG['tb_pre'].'article_36'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //学术内容 case 'xueshu_detail': $moduleid=33; $table = $CFG['tb_pre'].'article_36'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_30'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的学术ID"; } break; //相关学术 case 'xueshu_more': $table = $CFG['tb_pre'].'article_36'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //学术搜索 case 'xueshu_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_36'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //学术分类 case 'xueshu_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //学术内容集合 case 'xueshu_detail_all': $moduleid=36; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_36'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_36'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的学术ID"; } break; //学术模块关闭 //合同列表 case 'hetong_list': $table = $CFG['tb_pre'].'article_37'; $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('article',$mtype,$catid); break; //合同内容 case 'hetong_detail': $moduleid=33; $table = $CFG['tb_pre'].'article_37'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data = Db::find($PDO->pdo,$table,$fields,$where); $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); $table= $CFG['tb_pre'].$moduleid."_".$split;//分表 //$table = $CFG['tb_pre'] . 'article_data_30'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的合同ID"; } break; //相关合同 case 'hetong_more': $table = $CFG['tb_pre'].'article_37'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } break; //相关搜索 case 'article_rand_keyword': $data = RandKeyword('article',10); break; //合同搜索 case 'hetong_search': if(!empty($kw)){ $table = $CFG['tb_pre'] . 'article_37'; $fields = 'itemid,title,thumb,introduce,addtime'; //$order = 'itemid DESC'; $order = GetOrder('article'); $where = '`status`=3 AND keyword LIKE"%' . $kw . '%"'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if ($conut>0) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where, $order); $i = 0; foreach ($data as $row) { $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data = array(); } }else{ $data = array(); $state = 403; $message = "请输入关键词"; } break; //合同分类 case 'hetong_cat': $data = GetCatTop('article'); $item = array('catid'=>0,'catname'=>'全部'); array_unshift($data,$item); break; //合同内容集合 case 'hetong_detail_all': $moduleid=37; $module="article"; $zhengshu=100000; $chufa=$itemid/$zhengshu; $split=ceil($chufa); //分表 $table = $CFG['tb_pre'].'article_37'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table= $CFG['tb_pre'].$moduleid."_".$split; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = 'itemid,title,thumb,introduce,addtime'; $order = 'itemid DESC'; $where = '`status`=3'; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'article_37'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } //$data['rand_keyword'] = RandKeyword('article',10); $data['cat'] = GetCatTop('article'); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('article','show',$catid); }else{ $data = array(); $state = 403; $message = "请输入正确的合同ID"; } break; //合同模块关闭 //产品分类 case 'sell_cat': if($catid>0){ $child = GetCatChild($catid); $child = ltrim($child,$catid.','); $table = $CFG['tb_pre'] . 'category'; $fields = 'catid,catname,child'; $where = '`catid` IN ('.$child.')'; if ($child) { $data = Db::select($PDO->pdo, $table, $fields, $where, 'listorder ASC'); } else { $data = array(); $state = 204; $message = 'fail'; } }else{ $data = GetCatTop('sell'); } break; //产品列表 case 'sell_list': $table = $CFG['tb_pre'].'sell_5'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; //$order = 'itemid DESC'; $order = GetOrder('sell'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data = array(); } $SEO = CreateSeo('sell',$mtype,$catid); break; //产品搜索 case 'sell_search': if($kw){ $table = $CFG['tb_pre'] . 'sell_search_5'; //$order = 'itemid DESC'; $order = GetOrder('sell'); $where = '`status`=3 AND content LIKE"%'.$kw.'%"'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $table = $CFG['tb_pre'] . 'sell_5'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data = array(); } $SEO = CreateSeo('sell','search',$catid); }else{ $data = array(); $state = 204; $message = "请输入关键词"; } break; //产品详情 case 'sell_detail': if ($itemid > 0) { $table = $CFG['tb_pre'] . 'sell_5'; $fields = '*'; $where = '`itemid`="' . $itemid . '"'; $data = Db::find($PDO->pdo, $table, $fields, $where); $table = $CFG['tb_pre'] . 'sell_data_5'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('sell','show',$data['catid']); } else { $data = array(); $state = 204; $message = "请确保ID正确"; } break; //商城分类 case 'mall_cat': if($catid>0){ $child = GetCatChild($catid); $child = ltrim($child,$catid.','); $table = $CFG['tb_pre'] . 'category'; $fields = 'catid,catname,child'; $where = '`catid` IN ('.$child.')'; if ($child) { $data = Db::select($PDO->pdo, $table, $fields, $where, 'listorder ASC'); } else { $data = array(); $state = 204; $message = 'fail'; } }else{ $data = GetCatTop('mall'); } break; //商城列表 case 'mall_list': $table = $CFG['tb_pre'].'mall_16'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; //$order = 'itemid DESC'; $order = GetOrder('mall'); $where = '`status`=3'; $mtype = 'index'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $mtype = 'list'; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data = array(); } $SEO = CreateSeo('mall',$mtype,$catid); break; //商城搜索 case 'mall_search': if($kw){ $table = $CFG['tb_pre'] . 'mall_16'; //$order = 'itemid DESC'; $order = GetOrder('mall'); $where = '`status`=3 AND title LIKE"%'.$kw.'%"'; $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $table = $CFG['tb_pre'] . 'mall_16'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data = array(); } $SEO = CreateSeo('mall','search',$catid); }else{ $data = array(); $state = 204; $message = "请输入关键词"; } break; //商城详情 case 'mall_detail': if ($itemid > 0) { $table = $CFG['tb_pre'] . 'mall_16'; $fields = '*'; $where = '`itemid`="' . $itemid . '"'; $data = Db::find($PDO->pdo, $table, $fields, $where); $table = $CFG['tb_pre'] . 'mall_data_16'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('mall','show',$data['catid']); } else { $data = array(); $state = 204; $message = "请确保ID正确"; } break; //相关产品(调用产品分类) //商家自定义顶级分类 case 'company_mycat_top': if($userid>0){ $table = $CFG['tb_pre'].'type'; $fields = 'typeid,typename'; $where = 'item="product-'.$userid.'"'; $order = 'listorder ASC'; $data = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'typeid',$where); }else{ $data = array(); $state = 204; $message = "请确保ID正确"; } break; //随机子分类 case 'rand_cat': if($catid>0){ $child = GetCatChild($catid); $child = ltrim($child,$catid.','); $table = $CFG['tb_pre'] . 'category'; $fields = 'catid,catname,child'; $where = '`catid` IN ('.$child.')'; if ($child) { $data = Db::select($PDO->pdo, $table, $fields, $where, 'RAND()',4); $conut = Db::find_conut($PDO->pdo,$table,'catid',$where); }else { $data = array(); $state = 204; $message = 'fail'; } }else{ $data = array(); $state = 204; $message = "请确保ID正确"; } break; //商家列表 case 'company_list': $table = $CFG['tb_pre'].'company'; $table2 = $CFG['tb_pre'].'setting'; $where = '`item` =4 AND item_key="openall"'; $data = Db::find($PDO->pdo,$table2,'item_value',$where); $openall = $data['item_value']; $fields = 'userid,username,company,thumb,introduce,business,address'; $where = $openall == 1 ? '' : '`validated`=0'; $order = GetOrder('company'); $data = Db::select($PDO->pdo,$table,'userid',$where,$order,$limit); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['userid'] . ','; //$ids .= $row['username'] . ','; } $ids = rtrim($ids, ','); $where = 'userid IN(' . $ids . ')'; //$where = 'username IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data = array(); } $SEO = CreateSeo('company','list',$data['catid']); break; //商家搜索 case 'company_search': $table = $CFG['tb_pre'].'company'; $fields = 'userid,username,company,thumb,introduce,business,address'; $table2 = $CFG['tb_pre'].'setting'; $where = '`item` =4 AND item_key="openall"'; $data = Db::find($PDO->pdo,$table2,'item_value',$where); $openall = $data['item_value']; //$where = 'company LIKE"%'.$kw.'%" OR keyword LIKE"%'.$kw.'%"'; $where = $openall == 1? 'CONCAt(company,keyword) LIKE"%'.$kw.'%"' : '`validated`=1 AND CONCAt(company,keyword) LIKE"%'.$kw.'%"'; //$order = 'userid DESC'; $order = GetOrder('company'); $data = Db::select($PDO->pdo,$table,'userid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'userid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['userid'] . ','; } $ids = rtrim($ids, ','); $where = 'userid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data = array(); } $SEO = CreateSeo('company','search',$data['catid']); break; //商家新闻动态 case 'company_news': if(!empty($username)){ $table = $CFG['tb_pre'] . 'news'; $fields = '*'; $where = 'username="'.$username.'"'; $order = 'itemid DESC'; $data = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach($data as $row){ $data[$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } $table = $CFG['tb_pre'] . 'company'; $where = 'username="' . $username . '"'; $data2 = Db::find($PDO->pdo, $table, 'company', $where); $title = '新闻动态_' . $data2['company']; $introduce = $data2['company'].'的最新新闻动态'; $keyword = '新闻动态,' . $data2['company']; $SEO = array('seo_title' => $title, 'seo_keywords' => $keyword, 'seo_description' => $introduce); } else { $data = array(); } //这里用数据库的方式直接调用 }else{ $data = array(); $state = 204; $message = "请确保用户名正确"; } break; //商家信息 case 'company_detail': if ($userid > 0) { $table = $CFG['tb_pre'] . 'company'; $fields = '*'; $where = '`userid`="' . $userid . '"'; $data = Db::find($PDO->pdo, $table, $fields, $where); $table = $CFG['tb_pre'] . 'company_data'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('company','show',$catid); } else { $data = array(); $state = 204; $message = "请确保ID正确"; } break; //提交留言板 case 'message': if(!empty($_POST)){ $name = $_POST['name']; $tel = $_POST['tel']; $title = $_POST['title']; $touser = $_POST['touser']; $content = $_POST['content']; if(!empty($name) && !empty($tel) && !empty($title) && !empty($touser) && !empty($content)){ $content .= ' 联系人:'.$name.' 联系电话:'.$tel; $table = $CFG['tb_pre'] . 'message'; $conut = Db::insert( $PDO->pdo, $table, ['title'=>''.$title.'','typeid'=>3,'content'=>''.$content.'','fromuser'=>'','touser'=>''.$touser.'','addtime'=>time(),'ip'=>''.getIP().'','isread'=>0,'issend'=>0,'feedback'=>0,'status'=>3,'groupids'=>''] ); if($conut>0){ $state = 200; $message = '稍后客服会联系你'; }else{ $state = 204; $message = 'fail'; } }else{ $data = array(); $state = 204; $message = "数据缺失"; } }else{ $data = array(); $state = 204; $message = "没有提交任何数据"; } break; //知道列表 case 'know_list': $table = $CFG['tb_pre'].'know_10'; $fields = 'itemid,title,addition,introduce,thumb,answer,process,passport,catid,addtime'; //$order = 'itemid DESC'; $order = GetOrder('know'); $where = '`status`=3'; if($catid>0){ $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; } $data = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data)) { $ids = ''; foreach ($data as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach($data as $row){ $data[$i]['addtime'] = date('Y-m-d H:i:s', $row['addtime']); $i++; } } else { $data = array(); } $SEO = CreateSeo('know','list',$catid); break; //知道详情 case 'know_detail': if($itemid>0){ $table = $CFG['tb_pre'] . 'know_10'; $fields = '*'; $where = '`itemid`="' . $itemid . '"'; $data = Db::find($PDO->pdo, $table, $fields, $where); $data['addtime'] = date("Y-m-d H:i:s",$data['addtime']); $table = $CFG['tb_pre'] . 'know_data_10'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $table = $CFG['tb_pre'] . 'know_answer_10'; $order = GetOrder('know'); $where = 'qid='.$itemid.' AND `status`=3'; $data3 = Db::select($PDO->pdo, $table, 'itemid', $where, $order); $data['answer_list'] = array(); if(!empty($data3)){ $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['answer_list'] = Db::select($PDO->pdo, $table, '*', $where,$order); $i = 0; foreach ($data['answer_list'] as $row) { $data['answer_list'][$i]['addtime'] = date('Y-m-d H:i:s', $row['addtime']); $i++; } } $table = $CFG['tb_pre'] . 'know_10'; $order = 'itemid DESC'; $fields = 'itemid,title,addition,introduce,thumb,answer,process,passport,catid,addtime'; $where = '`status`=3 AND `itemid`!='.$itemid; $arrchildid = GetCatChild($data['catid']); $where .= $arrchildid ? ' AND catid IN('.$arrchildid.')' : ' AND catid='.$catid; $data['more'] = Db::select($PDO->pdo,$table,$fields,$where,$order,8); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d H:i:s', $row['addtime']); $i++; } $title = $data['title']; $introduce = $data['introduce']; $keyword = $data['keyword']; $SEO = CreateSeo('know','show',$catid); }else{ $data = array(); $state = 204; $message = "请确保ID正确"; } break; //首页合并请求 case 'index_all': $table = 'youchuang_banner'; $fields = '*'; $where = '1'; $order = 'weigh DESC'; $arr = Db::select($PDO->pdo,$table,$fields,$where,$order); $data['banner'] = array(); $i = 0; foreach($arr as $row){ $geturl ='http://www.kaotop.com/chuangyou_xcx/public/'; $data['banner'][$i]['picture'] =$geturl.$row['image']; $data['banner'][$i]['url'] = $row['url']; $i++; } $table = 'youchuang_index_category'; $fields = '*'; $where = '1'; $arr = Db::select($PDO->pdo,$table,$fields,$where,$order); $data['category'] = array(); $i = 0; foreach($arr as $row){ $data['category'][$i]['icon'] = $seturl.$row['image']; $data['category'][$i]['id'] = $row['url']; $data['category'][$i]['url'] = is_int($row['url']) ? '/pages/goods/list?id='.$row['url'] : $row['url']; $data['category'][$i]['name'] = $row['name']; $i++; } $table = $CFG['tb_pre'].'brand_13'; $fields = 'itemid,title,thumb'; $where = '`level`=1'; $order = GetOrder('brand'); $limit = 6; $data['brand'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); //资讯 $table = $CFG['tb_pre'].'article_21'; $fields = 'itemid,title,thumb,introduce,addtime'; $where = '`level`=1 AND `status`=3'; $order = GetOrder('article'); $limit = 6; $data['article'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $i = 0; foreach($data['article'] as $row){ $data['article'][$i]['addtime'] = date('Y-m-d',$row['addtime']); $i++; } //小学 $table = $CFG['tb_pre'].'article_23'; $fields = 'itemid,title,thumb,introduce,addtime'; $where = '`level`=1 AND `status`=3'; $order = GetOrder('article'); $limit = 6; $data['xiaoxue'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $i = 0; foreach($data['xiaoxue'] as $row){ $data['xiaoxue'][$i]['addtime'] = date('Y-m-d',$row['addtime']); $i++; } //初中 $table = $CFG['tb_pre'].'article_24'; $fields = 'itemid,title,thumb,introduce,addtime'; $where = '`level`=1 AND `status`=3'; $order = GetOrder('article'); $limit = 6; $data['chuzhong'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $i = 0; foreach($data['chuzhong'] as $row){ $data['chuzhong'][$i]['addtime'] = date('Y-m-d',$row['addtime']); $i++; } //高中 $table = $CFG['tb_pre'].'article_25'; $fields = 'itemid,title,thumb,introduce,addtime'; $where = '`level`=1 AND `status`=3'; $order = GetOrder('article'); $limit = 6; $data['gaozhong'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $i = 0; foreach($data['gaozhong'] as $row){ $data['gaozhong'][$i]['addtime'] = date('Y-m-d',$row['addtime']); $i++; } //会计 $table = $CFG['tb_pre'].'article_27'; $fields = 'itemid,title,thumb,introduce,addtime'; $where = '`level`=1 AND `status`=3'; $order = GetOrder('article'); $limit = 6; $data['kuaiji'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $i = 0; foreach($data['kuaiji'] as $row){ $data['kuaiji'][$i]['addtime'] = date('Y-m-d',$row['addtime']); $i++; } $table = $CFG['tb_pre'].'company'; $fields = 'userid,username,company,thumb,introduce,business,address'; $where = '`level`=1'; $order = GetOrder('company'); $limit = 6; $data['company'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $table = $CFG['tb_pre'].'sell_5'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; $where = '`level`=1 AND `status`=3'; $order = GetOrder('sell'); $data2 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data2)) { $ids = ''; foreach ($data2 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['sell'] = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data['sell'] = array(); } $table = $CFG['tb_pre'].'mall_16'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; $where = '`level`=1 AND `status`=3'; $order = GetOrder('sell'); $data2 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); if (!empty($data2)) { $ids = ''; foreach ($data2 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['mall'] = Db::select($PDO->pdo, $table, $fields, $where,$order); } else { $data['mall'] = array(); } $SEO = array(); $table = $CFG['tb_pre'] . 'setting'; $where = '`item`=1'; $arr = Db::select($PDO->pdo, $table, '*', $where); $seo = array(); foreach($arr as $row){ $seo[''.$row["item_key"].''] = $row['item_value']; } $SEO['seo_title'] = $seo['seo_title']; $SEO['seo_keywords'] = $seo['seo_keywords']; $SEO['seo_description'] = $seo['seo_description']; break; //产品详情集合 case 'sell_detail_all': if ($itemid > 0) { $table = $CFG['tb_pre'] . 'sell_5'; $fields = '*'; $where = '`itemid`="' . $itemid . '"'; $data['detail'] = Db::find($PDO->pdo, $table, $fields, $where); $table = $CFG['tb_pre'] . 'sell_data_5'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $data['detail']['thumb'] = str_replace('.thumb.jpg','',$data['detail']['thumb']); $data['detail']['thumb1'] = str_replace('.thumb.jpg','',$data['detail']['thumb1']); $data['detail']['thumb2'] = str_replace('.thumb.jpg','',$data['detail']['thumb2']); $username = $data['detail']['username']; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'company'; $data3 = Db::find($PDO->pdo,$table,'userid','username="'.$username.'"'); $userid = $data3['userid']; $data['detail']['userid'] = $userid; $table = $CFG['tb_pre'].'type'; $fields = 'typeid,typename'; $where = 'item="product-'.$userid.'"'; $order = 'typeid ASC'; $data['mycat_top'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'typeid',$where); $child = GetCatChild($catid); $child = ltrim($child,$catid.','); $table = $CFG['tb_pre'] . 'category'; $fields = 'catid,catname,child'; $where = '`catid` IN ('.$child.')'; if ($child) { $data['rand_cat'] = Db::select($PDO->pdo, $table, $fields, $where, 'RAND()',4); $conut = Db::find_conut($PDO->pdo,$table,'catid',$where); }else { $data['rand_cat'] = array(); } $table = $CFG['tb_pre'] . 'sell_5'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; $order = 'itemid DESC'; $where = '`status`=3'; if ($catid > 0) { $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN(' . $arrchildid . ')' : ' AND catid='.$catid; } $data2 = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if (!empty($data)) { $ids = ''; foreach ($data2 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where, $order); } else { $data['more'] = array(); } $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('sell','show',$catid); } else { $data = array(); $state = 204; $message = "请确保ID正确"; } break; //商品详情集合 case 'mall_detail_all': if ($itemid > 0) { $table = $CFG['tb_pre'] . 'mall_16'; $fields = '*'; $where = '`itemid`="' . $itemid . '"'; $data['detail'] = Db::find($PDO->pdo, $table, $fields, $where); $table = $CFG['tb_pre'] . 'mall_data_16'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $username = $data['detail']['username']; $catid = $data['detail']['catid']; $table = $CFG['tb_pre'].'company'; $data3 = Db::find($PDO->pdo,$table,'userid','username="'.$username.'"'); $username= $data3['username']; $data['detail']['username'] = $username; $table = $CFG['tb_pre'].'type'; $fields = 'typeid,typename'; $where = 'item="product-'.$userid.'"'; $order = 'typeid ASC'; $data['mycat_top'] = Db::select($PDO->pdo,$table,$fields,$where,$order,$limit); $conut = Db::find_conut($PDO->pdo,$table,'typeid',$where); $child = GetCatChild($catid); $child = ltrim($child,$catid.','); $table = $CFG['tb_pre'] . 'category'; $fields = 'catid,catname,child'; $where = '`catid` IN ('.$child.')'; if ($child) { $data['rand_cat'] = Db::select($PDO->pdo, $table, $fields, $where, 'RAND()',4); $conut = Db::find_conut($PDO->pdo,$table,'catid',$where); }else { $data['rand_cat'] = array(); } $table = $CFG['tb_pre'] . 'mall_16'; $fields = 'itemid,company,thumb,introduce,unit,price,title'; $order = 'itemid DESC'; $where = '`status`=3'; if ($catid > 0) { $arrchildid = GetCatChild($catid); $where .= $arrchildid ? ' AND catid IN(' . $arrchildid . ')' : ' AND catid='.$catid; } $data2 = Db::select($PDO->pdo, $table, 'itemid', $where, $order, $limit); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if (!empty($data)) { $ids = ''; foreach ($data2 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where, $order); } else { $data['more'] = array(); } $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('mall','show',$catid); } else { $data = array(); $state = 204; $message = "请确保ID正确"; } break; //商家首页集合 case 'company_index_all': if ($userid > 0) { $table = $CFG['tb_pre'] . 'company'; $fields = '*'; $where = '`userid`="' . $userid . '"'; $data['detail'] = Db::find($PDO->pdo, $table, $fields, $where); $username = $data['detail']['username']; $table = $CFG['tb_pre'] . 'company_data'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['detail']['content'] = stripslashes(html_entity_decode($data2['content'])); $table = $CFG['tb_pre'] . 'news'; $fields = '*'; $where = 'username="'.$username.'"'; $order = 'itemid DESC'; $data3 = Db::select($PDO->pdo, $table, 'itemid', $where, $order, 10); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['news'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach($data['news'] as $row){ $data['news'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['news'] = array(); } $table = $CFG['tb_pre'] . 'sell_5'; $fields = 'itemid,company,thumb,introduce,unit,price'; $order = 'itemid DESC'; $where = '`username`="'.$username.'" AND `status`=3'; $data3 = Db::select($PDO->pdo, $table, 'itemid', $where, $order, 10); $conut = Db::find_conut($PDO->pdo, $table, 'itemid', $where); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['sell'] = Db::select($PDO->pdo, $table, $fields, $where, $order); } else { $data['sell'] = array(); } $title = $data['detail']['company']; $introduce = !empty($data['detail']['introduce']) ? mb_strcut($data['detail']['introduce'],100,'utf-8') : ''; $keyword = $data['detail']['keyword']; $SEO = array('seo_title'=>$title,'seo_keywords'=>$keyword,'seo_description'=>$introduce); } else { $data = array(); $state = 204; $message = "请确保ID正确"; } break; //品牌详情集合 case 'brand_detail_all': if ($itemid > 0) { $table = $CFG['tb_pre'] . 'brand_13'; $fields = '*'; $where = '`itemid`="' . $itemid . '"'; $data['detail'] = Db::find($PDO->pdo, $table, $fields, $where); $table = $CFG['tb_pre'] . 'brand_data_13'; $fields = 'content'; $data2 = Db::find($PDO->pdo, $table, $fields, $where); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $title = $data['detail']['title']; $introduce = $data['detail']['introduce']; $keyword = $data['detail']['keyword']; $SEO = CreateSeo('brand','show',$catid); } else { $data = array(); $state = 204; $message = "请确保ID正确"; } break; //新闻内容集合 case 'news_detail_all': $table = $CFG['tb_pre'].'news'; $fields = '*'; $where = '`itemid`="'.$itemid.'"'; if($itemid>0){ $data['detail'] = Db::find($PDO->pdo,$table,$fields,$where); $table = $CFG['tb_pre'] . 'news_data'; $fields = 'content'; $where = '`itemid`="' . $itemid . '"'; $data2 = Db::find($PDO->pdo,$table,$fields,$where); $data['detail']['addtime'] = date("Y-m-d H:i:s",$data['detail']['addtime']); $data['detail']['content'] = KillStyle(stripslashes(html_entity_decode($data2['content']))); $fields = '*'; $order = 'itemid DESC'; $where = '`status`=3'; $username = $data['detail']['username']; $table = $CFG['tb_pre'].'news'; $where .= $username ? ' AND username="'.$username.'" AND `itemid`!="'.$itemid.'"' : ''; $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).',10'; $data3 = Db::select($PDO->pdo,$table,'itemid',$where,$order,$limit); if (!empty($data3)) { $ids = ''; foreach ($data3 as $row) { $ids .= $row['itemid'] . ','; } $ids = rtrim($ids, ','); $where = 'itemid IN(' . $ids . ')'; $data['more'] = Db::select($PDO->pdo, $table, $fields, $where,$order); $i = 0; foreach ($data['more'] as $row) { $data['more'][$i]['addtime'] = date('Y-m-d', $row['addtime']); $i++; } } else { $data['more'] = array(); } $table = $CFG['tb_pre'].'company'; $where = 'username="'.$username.'"'; $data2 = Db::find($PDO->pdo,$table,'company',$where); // $data['rand_keyword'] = RandKeyword('news',10); // $data['cat'] = GetCatTop('news'); $title = $data['detail']['title']; $introduce = $data['detail']['content']; $keyword = $title.','.$data2['company']; $SEO = array('seo_title'=>$title,'seo_keywords'=>$keyword,'seo_description'=>$introduce); }else{ $data = array(); $state = 403; $message = "请输入正确的资讯ID"; } break; default: $data = array('state'=>404,'message'=>'找不到这个模块,请矫正!'); die(json_encode($data)); break; } $seo_title = $SEO['seo_title']; $seo_keywords = $SEO['seo_keywords']; $seo_description = $SEO['seo_description']; $new_data = array(); $seo = array(); $seo['seo_title'] = $seo_title; $seo['seo_keywords'] = $seo_keywords; $seo['seo_description'] = $seo_description; $new_data['data'] = $data; $new_data['seo'] = $seo; $new_data['state'] = $state; $new_data['message'] = $message; $new_data['page'] = $page; $new_data['pagesize'] = $pageSize; $new_data['conut'] = $conut; echo json_encode($new_data); $cache->caching(); }else{ die('找不到模块'); } function GetCatTop($module) { global $PDO,$CFG; $table = $CFG['tb_pre'] . 'module'; $fields = 'moduleid'; $where = '`module`="'.$module.'"'; $data = Db::find($PDO->pdo,$table,$fields,$where); $moduleid = $data['moduleid']; $table = $CFG['tb_pre'] . 'category'; $fields = 'catid,catname'; $where = '`moduleid`="'.$moduleid.'" AND `parentid`=0'; $data = Db::select($PDO->pdo,$table,$fields,$where,'listorder ASC'); return $data; } function GetCatChild($catid) { global $PDO,$CFG; $table = $CFG['tb_pre'] . 'category'; $fields = 'arrchildid'; $where = '`catid`="'.$catid.'"'; $data = Db::find($PDO->pdo,$table,$fields,$where); return $data['arrchildid']; } function RandKeyword($module,$num) { global $PDO,$CFG; $table = $CFG['tb_pre'] . 'module'; $fields = 'moduleid'; $where = '`module`="'.$module.'"'; $data = Db::find($PDO->pdo,$table,$fields,$where); $moduleid = $data['moduleid']; $table = $CFG['tb_pre'] . 'keyword'; $fields = 'keyword,word'; $where = '`moduleid`="'.$moduleid.'" AND `status`=3'; $conut = Db::find_conut($PDO->pdo,$table,'itemid',$where); $limit = rand(0,$conut).','.$num; $data = Db::select($PDO->pdo,$table,$fields,$where,'itemid DESC',$limit); return $data; } function GetOrder($module) { global $PDO,$CFG; $table = $CFG['tb_pre'] . 'module'; $fields = 'moduleid'; $where = '`module`="' . $module . '"'; $data = Db::find($PDO->pdo, $table, $fields, $where); $moduleid = $data['moduleid']; $table = $CFG['tb_pre'] . 'setting'; $where = '`item`=' . $moduleid.' AND `item_key`="order"'; $data = Db::find($PDO->pdo, $table, 'item_value', $where); return $data['item_value']; } function GetConfig() { global $PDO, $CFG; $table = 'youchuang_setting'; $fields = '*'; $where = '1'; $arr = Db::find($PDO->pdo, $table, $fields, $where); $data = array( 'site_name' => $arr['name'], 'app_id' => $arr['appid'], 'app_key' => $arr['appkey'], 'app_secret' => $arr['appsecret'], 'cache' => $arr['cache'] ); return $data; } //获取来访IP function getIP() { static $realip; if (isset($_SERVER)){ if (isset($_SERVER["HTTP_X_FORWARDED_FOR"])){ $realip = $_SERVER["HTTP_X_FORWARDED_FOR"]; } else if (isset($_SERVER["HTTP_CLIENT_IP"])) { $realip = $_SERVER["HTTP_CLIENT_IP"]; } else { $realip = $_SERVER["REMOTE_ADDR"]; } } else { if (getenv("HTTP_X_FORWARDED_FOR")){ $realip = getenv("HTTP_X_FORWARDED_FOR"); } else if (getenv("HTTP_CLIENT_IP")) { $realip = getenv("HTTP_CLIENT_IP"); } else { $realip = getenv("REMOTE_ADDR"); } } $arr = explode(',',$realip); $realip = $arr[0]; return $realip; } function CreateSeo($module,$seo_file,$catid) { global $PDO,$CFG, $L,$introduce,$title,$keyword,$kw,$page; $table = $CFG['tb_pre'] . 'module'; $fields = '*'; $where = '`module`="' . $module . '"'; $data = Db::find($PDO->pdo, $table, $fields, $where); $moduleid = $data['moduleid']; $table = $CFG['tb_pre'] . 'setting'; $where = '`item`=1'; $DTL = Db::select($PDO->pdo, $table, '*', $where); $DT = array(); foreach($DTL as $row){ $DT[''.$row["item_key"].''] = $row['item_value']; } $MOD = include './../file/cache/module-'.$moduleid.'.php'; $seo_modulename = $MOD['name']; $seo_sitename = $city_sitename ? $city_sitename : $DT['sitename']; $seo_sitetitle = $DT['seo_title']; $seo_sitekeywords = $DT['seo_keywords']; $seo_sitedescription = $DT['seo_description']; $seo_delimiter = $DT['seo_delimiter']; $seo_page = $page > 1 ? lang($L['seo_page'], array($page)) . $seo_delimiter : ''; //解决了 $seo_catname = $seo_cattitle = $seo_parentname = $seo_catkeywords = $seo_catdescription = ''; if ($catid) { $table = $CFG['tb_pre'] . 'category'; $fields = '*'; $where = '`catid`="' . $catid . '"'; $CAT = Db::find($PDO->pdo, $table, $fields, $where); if ($CAT['parentid']) { //如果发现是有上级分类就把所有上级分类找出来 $seo_catname = ''; $tmp = strip_tags(cat_pos2($CAT, 'DESTOON')); $tmp = explode('DESTOON', $tmp); $tmp = array_reverse($tmp); foreach ($tmp as $k => $v) { $seo_catname .= $v . $seo_delimiter; } } else { $seo_catname = $CAT['catname'] . $seo_delimiter; } $seo_cattitle = $CAT['seo_title'] ? $CAT['seo_title'] . $seo_delimiter : $seo_catname; $seo_catkeywords = $CAT['seo_keywords'] ? $CAT['seo_keywords'] : ''; $seo_catdescription = $CAT['seo_description'] ? $CAT['seo_description'] : ''; } $seo_areaname = (isset($areaid) && $areaid) ? area_pos2($areaid, $seo_delimiter) . $seo_delimiter : ''; $seo_showtitle = isset($title) ? $title : ''; $seo_showintroduce = isset($introduce) ? $introduce : ''; switch ($seo_file) { case 'index': if ($MOD['title_index']) { eval("$seo_title = "$MOD[title_index]";"); } else { $seo_title = $seo_modulename . $seo_delimiter . $seo_sitename; } if ($MOD['keywords_index']) eval("$head_keywords = "$MOD[keywords_index]";"); if ($MOD['description_index']) eval("$head_description = "$MOD[description_index]";"); break; case 'list': if ($CAT['seo_title']) { $seo_title = $CAT['seo_title']; } else if ($MOD['title_list']) { eval("$seo_title = "$MOD[title_list]";"); } else { $seo_title = $seo_cattitle . $seo_page . $seo_modulename . $seo_delimiter . $seo_sitename; } $_seo_catname = $seo_catname; $_seo_areaname = $seo_areaname; if ($CAT['seo_keywords']) { $head_keywords = $CAT['seo_keywords']; } else if ($MOD['keywords_list']) { if ($_seo_catname) $seo_catname = str_replace($seo_delimiter, ',', $_seo_catname); if ($_seo_areaname) $seo_areaname = str_replace($seo_delimiter, ',', $_seo_areaname); eval("$head_keywords = "$MOD[keywords_list]";"); } if ($CAT['seo_description']) { $head_description = $CAT['seo_description']; } else if ($MOD['description_list']) { if ($_seo_catname) $seo_catname = str_replace($seo_delimiter, ' ', $_seo_catname); if ($_seo_areaname) $seo_areaname = str_replace($seo_delimiter, ' ', $_seo_areaname); eval("$head_description = "$MOD[description_list]";"); } break; case 'show': if ($MOD['title_show']) { eval("$seo_title = "$MOD[title_show]";"); } else { $seo_title = $seo_showtitle . $seo_delimiter . $seo_catname . $seo_modulename . $seo_delimiter . $seo_sitename; } $_seo_catname = $seo_catname; $_seo_areaname = $seo_areaname; if ($MOD['keywords_show']) { if ($_seo_catname) $seo_catname = str_replace($seo_delimiter, ',', $_seo_catname); if ($_seo_areaname) $seo_areaname = str_replace($seo_delimiter, ',', $_seo_areaname); eval("$head_keywords = "$MOD[keywords_show]";"); } else { $head_keywords = $keyword; } if ($MOD['description_show']) { if ($_seo_catname) $seo_catname = str_replace($seo_delimiter, ' ', $_seo_catname); if ($_seo_areaname) $seo_areaname = str_replace($seo_delimiter, ' ', $_seo_areaname); eval("$head_description = "$MOD[description_show]";"); } else { $head_description = $introduce ? $introduce : $title; } break; case 'search': if ($MOD['title_search']) { $seo_kw = $kw ? $kw . $seo_delimiter : ''; eval("$seo_title = "$MOD[title_search]";"); } else { $seo_title = $seo_modulename . $L['search'] . $seo_delimiter . $seo_page . $seo_sitename; if ($catid) $seo_title = $seo_catname . $seo_title; if ($areaid) $seo_title = $seo_areaname . $seo_title; if ($kw) $seo_title = $kw . $seo_delimiter . $seo_title; } $_seo_catname = $seo_catname; $_seo_areaname = $seo_areaname; if ($MOD['keywords_search']) { if ($_seo_catname) $seo_catname = str_replace($seo_delimiter, ',', $_seo_catname); if ($_seo_areaname) $seo_areaname = str_replace($seo_delimiter, ',', $_seo_areaname); $seo_kw = $kw ? $kw . ',' : ''; eval("$head_keywords = "$MOD[keywords_search]";"); } if ($MOD['description_search']) { if ($_seo_catname) $seo_catname = str_replace($seo_delimiter, ' ', $_seo_catname); if ($_seo_areaname) $seo_areaname = str_replace($seo_delimiter, ' ', $_seo_areaname); $seo_kw = $kw ? $kw : ''; eval("$head_description = "$MOD[description_search]";"); } break; default: break; } $seo = array(); $seo['seo_title'] = $seo_title; $seo['seo_keywords'] = $head_keywords; $seo['seo_description'] = $head_description; return $seo; } function cat_pos2($CAT, $str = ' » ', $target = '', $deep = 0, $start = 0) { global $PDO, $CFG; if(!$CAT) return ''; $table = $CFG['tb_pre'] . 'module'; $fields = '*'; $where = '1'; $data = Db::select($PDO->pdo, $table, $fields, $where); $MODULE = array(); foreach($data as $row){ $MODULE[$row['moduleid']] = $row; } $arrparentids = $CAT['arrparentid'].','.$CAT['catid']; $arrparentid = explode(',', $arrparentids); $pos = ''; $target = $target ? ' target="_blank"' : ''; $CATEGORY = array(); $table = $CFG['tb_pre'] . 'category'; $fields = 'catid,moduleid,catname,linkurl'; $where = 'catid IN ('.$arrparentids.')'; $result = Db::select($PDO->pdo, $table, $fields, $where); foreach($result as $r) { $CATEGORY[$r['catid']] = $r; } if($deep) $i = 1; $j = 0; foreach($arrparentid as $catid) { if(!$catid || !isset($CATEGORY[$catid])) continue; if($j++ < $start) continue; if($deep) { if($i > $deep) continue; $i++; } $pos .= '<a href="'.$MODULE[$CATEGORY[$catid]['moduleid']]['linkurl'].$CATEGORY[$catid]['linkurl'].'"'.$target.'>'.$CATEGORY[$catid]['catname'].''.$str; } $_len = strlen($str); if($str && substr($pos, -$_len, $_len) === $str) $pos = substr($pos, 0, strlen($pos) - $_len); return $pos; } function encode_pass($tex, $key, $type = "encode") { $chrArr = array( 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' ); if ($type == "decode") { if (strlen($tex) < 14) return false; $verity_str = substr($tex, 0, 8); $tex = substr($tex, 8); if ($verity_str != substr(md5($tex), 0, 8)) { //完整性验证失败 return false; } } $key_b = $type == "decode" ? substr($tex, 0, 6) : $chrArr[rand() % 62] . $chrArr[rand() % 62] . $chrArr[rand() % 62] . $chrArr[rand() % 62] . $chrArr[rand() % 62] . $chrArr[rand() % 62]; $rand_key = $key_b . $key; $rand_key = md5($rand_key); $tex = $type == "decode" ? base64_decode(substr($tex, 6)) : $tex; $texlen = strlen($tex); $reslutstr = ""; for ($i = 0; $i < $texlen; $i++) { $reslutstr .= $tex{ $i} ^ $rand_key{ $i % 32}; } if ($type != "decode") { $reslutstr = trim($key_b . base64_encode($reslutstr), "=="); $reslutstr = substr(md5($reslutstr), 0, 8) . $reslutstr; } return $reslutstr; } if (!function_exists("file_put_contents")) { function file_put_contents($n, $d, $flag = false) { $mode = ($flag == FILE_APPEND || strtoupper($flag) == 'FILE_APPEND') ? 'a' : 'w'; $f = @fopen($n, $mode); if ($f === false) { return 0; } else { if (is_array($d)) $d = implode($d); $bytes_written = fwrite($f, $d); fclose($f); return $bytes_written; } } } function KillStyle($content) { //$content = preg_replace("/STYLE=.+?['|"]/i",'',$content);//去除样式 $content = preg_replace("/style=.+?['|"]/i",'',$content);//去除样式 $content = preg_replace("/class=.+?['|"]/i",'',$content);//去除样式 $content = preg_replace("/id=.+?['|"]/i",'',$content);//去除样式 $content = preg_replace("/<(script.*?)>(.*?)<(/script.*?)>/si","",$content); //过滤script标签 return $content; }
演示小程序: