thinkphp百度小程序打造的接口api

     因为网站要对接百度小程序，于是做了一个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;
}

　　演示小程序：

 

 

 

 

​

千行代码，Bug何处藏。 纵使上线又怎样，朝令改，夕断肠。